Reputation
9,259
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
1 37 108
Impact
~341k people reached

Aug
19
reviewed Reviewed How can I use data from PDF map?
Aug
19
reviewed Approve One to Many / Many to Many
Aug
19
reviewed Approve Cannot convert dms to dd in Excel 2007 using VBA code
Aug
19
comment How to set up an ArcMap Relate with a table from MS SQL Server 2012
The relate works correctly after adding this - thanks!
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