topic SQL server photos to Arcmap in ArcGIS Pro Questions

SQL server photos to Arcmap

LieslDe_Swardt1 — Thu, 28 Mar 2019 12:05:27 GMT

Hi All,

We are busy with data capturing and have a bunch of geotagged photos in our sql server. I am trying to view these photos in arcmap / arcgis pro.

The process I have followed so far:

- Restored the .bak file in sql express in order to see the tables

- Connected the database to arcgis pro

- it consist of two tables (1) displaying lat and long coordinates (2) photo table with the doc ID in. Both these tables have the doc id.

I have displayed the points as per the coordinates, the tricky part is now linking the photo table to the points in order to see the pictures.

I have done a little bit of research and came across the tool "generate attachment table'. Not too sure how it works and if this is the path I should follow. Do I create a new geodatabase? Should I export the photo table? Just a bit lost and in desperate need of guidance.

I have a standard license.

Any advice and help will be appreciated.

Thanks.

Re: SQL server photos to Arcmap

ThomasColson — Thu, 28 Mar 2019 14:24:10 GMT

https://pro.arcgis.com/en/pro-app/tool-reference/data-management/geotagged-photos-to-points.htm

https://www.esri.com/arcgis-blog/products/arcgis-enterprise/uncategorized/add-geotagged-photos-to-your-web-map/

http://www.mostlymapping.com/2011/08/tip-for-adding-geotagged-photos-to.html

Re: SQL server photos to Arcmap

LieslDe_Swardt1 — Fri, 29 Mar 2019 08:17:09 GMT

Thank you Thomas, however I do not have the physical photos, I only have the .bak file which contains the details of the photos?