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.
@salehx076 ай бұрын
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.
@GeminiLearning2 жыл бұрын
Very nice demo Thanks!. Do you have a reference resource for complete tackle of Enterprise Geodatabases in SQL Server or PostgreSQL?
@GISCoordinated2 жыл бұрын
Hi - you could start here: pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-postgresql/setup-geodatabase-postgresql-windows.htm
@joseportilla8092 жыл бұрын
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