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.

[@AlexJ_216]

I'm a beginner on arcGIS. What is the benefit of doing geoprocessing this way over doing it all in arcGIS? Maybe in a more complex example the benefit would become more apparent, but I'm struggling to understand why you would do it this way.

[@GISCoordinated]

Its true that my demo only has a small amount of data but when it comes to processing large amounts of data you are typically better off taking advantage of a dedicated database environment. In certain environments e.g. large corporates, you will find that the database infrastructure is far more powerful than your local PC or network drive where a geodatabase or shapefile may be residing. Also, if you have a cloud-based solution e.g. AWS with a database hooked up, why not offload complex or big data querying to that environment, freeing up your local device? The total database approach also gives you access to many more tools e.g. auditing, security and falls in line with corporate CyberSec strategy. It also means that you can take advantage of highly skilled DB folks who may not necessarily be geospatial experts but can definitely assist when it comes to things like optimising your queries or managing GRANTs. So it all comes down to what do you want to achieve i.e. business requirements. The video is simply show the possible. I hope the above info helps.

[@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

[@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

[@nguyennghialan]

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

[@geoffmulligan9891]

Is the view then registered with the geodatabase? Im trying to publish to Arcgis server so my view will participate in a distributed collaboration and running into issues where i can't register or even assign privileges. Thanks

[@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?

[@salehx07]

Thank you