Tag Info

Hot answers tagged

2

I suspect you want to keep the incidents file as an excel file (to continue monitoring)? Probably the most straightforward way to do this would be to use Excel lookup functions to create geometry in the Excel file, which can then be used for mapping directly. Add X and Y colums to the geometry point file, and save-as a CSV file; Open the CSV in Excel and ...


2

I assume, from your question and from some of the comments on the original question, that you are trying to perform ideally a one to many join and are trying to do this in ArcGIS Desktop software. Unfortunately, the basic join in ArcMap available via right click on the layer doesn't work with one to many joins well, but if that's what you're after, there ...


2

I just figured out that one of my earlier approaches would have worked, but I had a typo in my postgres query. Right-click and copy the binary hex string from SQL Server Management Studio. Paste into a string in the PG Admin III SQL Editor window. Delete the "0x" at the beginning of the string. Wrap that value with a decode. Now ST_GeomFromWKB has WKB. ...


1

In 2008, I usually do select SHAPE.STSrid from dbo.STATES (where SHAPE is the geometry column and dbo.states is the table name). It will give you SRID. Now you can run select * from sys.spatial_reference_systems where spatial_reference_id = 4326 However, as @Jay Cummins mentioned, it seems to have only geographic coordinate systems. Link to the ...


1

ogr2ogr should do this for you. Looks like you have multiple geometry types in the dataset, not sure how that will work out. You might have to filter out by geometry type. Below not tested. See docs linked to above for inputs and flags. ogr2ogr -f "GeoJSON" "sqlexport.geojson" "MSSQL:server=localhost\sqlexpress;database=tempdb;trusted_connection=yes;" -sql ...


1

In order to use C# with the ArcGIS Platform I recommend that you review the ArcObjects API Reference for .NET, and in particular this ArcMap Overview. Something to be aware of at the outset is that little (some annotation is one exception) or no spatial data is stored in *.mxd files. Consequently, I suspect that what you are looking to do is to access ...



Only top voted, non community-wiki answers of a minimum length are eligible