# Visualizing photo exif geo-cordinates with Kibana and Elasticsearch **URL:** \ **Category:** Elasticsearch\ **Created:** [August 10, 2016, 4:08am UTC](https://discuss.elastic.co/t/visualizing-photo-exif-geo-cordinates-with-kibana-and-elasticsearch/57649 "2016-08-10T04:08:31Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![kmk3173](https://avatars.discourse-cdn.com/v4/letter/k/8baadc/32.png) [@kmk3173](https://discuss.elastic.co/u/kmk3173)\ **Post date:** [August 10, 2016, 4:08am UTC](https://discuss.elastic.co/t/visualizing-photo-exif-geo-cordinates-with-kibana-and-elasticsearch/57649/1 "2016-08-10T04:08:31Z")
Does anyone have any experience using Elasticsearch to analyze photos with geo data and visualize it using kibana? I'm looking at this from a digital forensics perspective where I'm extracting photos from forensic images with exif data, storing it using elasticsearch, and then using Kibana to visualize location and filter by those fields. Thanks ---
**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\ **Post date:** [August 10, 2016, 9:16pm UTC](https://discuss.elastic.co/t/visualizing-photo-exif-geo-cordinates-with-kibana-and-elasticsearch/57649/2 "2016-08-10T21:16:54Z")
I don't, but it sounds relatively simple. Which part are you after assistance with? ---
**Author:** ![kmk3173](https://avatars.discourse-cdn.com/v4/letter/k/8baadc/32.png) [@kmk3173](https://discuss.elastic.co/u/kmk3173)\ **Post date:** [August 11, 2016, 2:55pm UTC](https://discuss.elastic.co/t/visualizing-photo-exif-geo-cordinates-with-kibana-and-elasticsearch/57649/3 "2016-08-11T14:55:40Z")
I'm not sure how this would be set up with elasticsearch. I have it running on a windows 7 machine. For the data would it be possible to push exif table with the geo-coordinates from sql server to elastic search? Otherwise can it index csv files with the data stored there? I'm looking for the best way to analyze large datasets, so making it fast and efficient would be best, but at this point any help would be great. ---
**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\ **Post date:** [August 11, 2016, 11:17pm UTC](https://discuss.elastic.co/t/visualizing-photo-exif-geo-cordinates-with-kibana-and-elasticsearch/57649/4 "2016-08-11T23:17:47Z")
You can use Logstash for that, check out [https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html](https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html) for taking it from SQL, or the file input and CSV filter. ---
**Author:** ![kmk3173](https://avatars.discourse-cdn.com/v4/letter/k/8baadc/32.png) [@kmk3173](https://discuss.elastic.co/u/kmk3173)\ **Post date:** [August 11, 2016, 11:28pm UTC](https://discuss.elastic.co/t/visualizing-photo-exif-geo-cordinates-with-kibana-and-elasticsearch/57649/5 "2016-08-11T23:28:05Z")
Isn't that for mysql though? How would I be able to connect logstash/elastic search 2.4.3 with sql server? ---
**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\ **Post date:** [August 11, 2016, 11:39pm UTC](https://discuss.elastic.co/t/visualizing-photo-exif-geo-cordinates-with-kibana-and-elasticsearch/57649/6 "2016-08-11T23:39:21Z")
It's JDBC, so generic. You just need the driver jar file for MSSQL. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 5, 2017, 10:28pm UTC](https://discuss.elastic.co/t/visualizing-photo-exif-geo-cordinates-with-kibana-and-elasticsearch/57649/7 "2017-07-05T22:28:13Z")