Reputation
9,383
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
1 37 111
Impact
~356k people reached

Aug
19
comment How to set up an ArcMap Relate with a table from MS SQL Server 2012
I note that after adding the unique ID field directly in SQL Server, I don't see the New Query Layer dialog in ArcMap. Instead, the table is simply added, which is what I was expecting.
Aug
19
accepted How to set up an ArcMap Relate with a table from MS SQL Server 2012
Aug
19
comment How to set up an ArcMap Relate with a table from MS SQL Server 2012
I found that this worked to create a unique ID in SQL Server 2012: (ID INT IDENTITY(1,1) NOT NULL)
Aug
19
comment How to set up an ArcMap Relate with a table from MS SQL Server 2012
Thanks, I'll give this a try. I'm populating the table using a multi-processing python script, so I'll need to think about how to create a unique ID for each row.
Aug
19
revised How to set up an ArcMap Relate with a table from MS SQL Server 2012
removed the mention of Management Server
Aug
19
comment How to set up an ArcMap Relate with a table from MS SQL Server 2012
Excellent answer, thanks for the detailed steps and explanations.
Aug
19
comment How to set up an ArcMap Relate with a table from MS SQL Server 2012
@Vince yeah I think you're right. Preparing to use query layers says "The query layer definition must include a unique, not-null column or combination of columns that can be used as the ObjectID"
Aug
19
awarded  Custodian
Aug
19
reviewed Reviewed How to export raster from PostGIS enabled DB as GTiff with gdal_translate
Aug
19
reviewed Reviewed Using QGIS to access data delivered by ArcGIS for Server?
Aug
19
asked How to set up an ArcMap Relate with a table from MS SQL Server 2012
Aug
18
awarded  Constituent
Aug
18
awarded  Notable Question
Aug
18
comment How to get link of wms layer in Geoserver
Hi @swamy and welcome to GIS Stack Exchange. When posting a code sample it helps to use the code tags using the { } button
Aug
18
revised How to get link of wms layer in Geoserver
formatted as code
Aug
18
comment Leaflet: How to enable pan & zoom while GeoJSON still rendering?
I think this is a good point. Older web-map software like ArcIMS often had a Refresh button, to allow the user to make multiple changes in one batch, before all changes were applied. This approach may also work here - pan/zoom the map until the extent is correct, and only draw the GeoJSON then
Aug
18
comment Determining active layer regardless of its name using ArcPy?
@DanPatterson it must be especially confusing when someone in the arctic circle says "ArcGIS has frozen"
Aug
18
comment Determining active layer regardless of its name using ArcPy?
That seems to be a badly named function, since there may be more than one layer selected. The sample code also implies that the result will be a data frame ("df")
Aug
18
comment Displaying Shapefiles using Python?
Google how to display shapefile in python
Aug
18
revised Leaflet error: Uncaught TypeError: Cannot read property '_controlCorners'
updated the title (who's to say what's strange...)