ArcGIS Pro and SQLServer - An Intro to Spatial Queries

[@razvanafloarei6256]

As of now I am inclined to think that the synergy between ArcGIS and SQL is good for templates and very large amount of data to not just search into every project. Some autoupdate features would be extraordinary.

[@houstonfirefox]

If ArcGIS performs the query each time it accesses the data, as opposed to simply bringing it in and keeping it 'local' then the autoupdate would work. I can certainly see advantages here where other people are entering different pubs and ArcGIS would simply update the visuals as they were entered.

[@salehx07]

Thank you

[@nguyennghialan]

I think just export gdb to a SQLlite can handle this or try SQL for Arcpro extension for true SQL experience on gdb

[@houstonfirefox]

Very nice and concise explanation. Does ArcGIS, once it retrieves the view data simply have a static view of it from that point on or does it actively refresh with data from the view when updated? For instance, if a new pub is added while viewing the map, will it then appear automatically or is there a 'refresh' needed to view the locations of the new pubs?

[@GISCoordinated]

It would appear if the map is panned/zoomed or moved in some way so a refresh does take place - note that all layers have a refresh feature. Go to properties of the layer and under General, at the bottom, you will see Layer Should Be Refreshed Periodically.

[@gentryewing4734]

@@GISCoordinated so if sql is getting updates in real time on its own, then once this connection is established between ArcGIS Server and sql, the feature in ArcGIS Server should always have the latest and greatest data correct? Basically reflecting what ever the data is in sql. We have GeoEvent and we are looking into getting real time data from sql, but it seems more appropriate to bridge ArcGIS Server and sql and then GeoEvent can just poll ArcGIS Server.

[@GeminiLearning]

Very nice demo Thanks!. Do you have a reference resource for complete tackle of Enterprise Geodatabases in SQL Server or PostgreSQL?

[@GISCoordinated]

Hi - you could start here: pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-postgresql/setup-geodatabase-postgresql-windows.htm

[@joseportilla809]

Hi! great video! I followed the tutorial but i have a problem, when i try to open the tables these message pops up "Invalid database name. the operation is not supported by this implementation" do someone knows what im doing wrong?

[@battlesship]

Great video and example! I usually use STIntersects, do you know the difference between intersects, within and contains?

[@GISCoordinated]

I used CONTAINS as the pubs are points and the postcodes are polygons - so where a postcode contains a pub. Its really about the geometry as you would use intersects for a line feature maybe - where a road STINTERSECTS a polygon. But STWITHIN in that example would only be satisfied if the whole length of your road is completely within the polygon. It is possible though that there are cases where one operator would work with different geometry.

[@battlesship]

@@GISCoordinated thanks for the response! I usually work with points and polys so it seems like I should be using contains. Ill do some testing with that