3
votes
1answer
222 views

Convert Sql Server Spatial data to GeoJSON & plot on map

I have a sql server table with Geo spatial data. An example of row would be (with Column names): type: streetline code: 231001 geog: 0xE6100000011 ........ Centroid 0xE61000000C....... geom: ...
0
votes
1answer
74 views

Export data from .mxd file to ms sql database

I am using ArcGIS product (v.10.1). I have also tempalte of Maps from ArcGIS. But i need to get data from maps (.mxd files) to store it into MS SQL database. Explanation: I have application that has ...
2
votes
1answer
97 views

how to transform DB stored EPSG data to Geography data type in sql server

I have a full, 3 GB, database in SQL Server stored with certain points stored in pure float values. The points are stored in EPSG 3765. I would prefer to have them saved in the Geograpy datatype. I ...
0
votes
1answer
62 views

Get the vertices on a LineString either side of a point (Sql Server 2008)

I have a point that sits on top of a LineString, both Sql Geometry types. POINT('0.5 0.5') LINESTRING('0 0 NULL 1, 1 1 NULL 1') I want to find the vertices of the LineString that lie either side ...
1
vote
0answers
61 views

Find Nearby GPS Navigation Route

I am developing a car pooling website. For that, I have created the database which has the different route options selected by different user. These routes are saved in the Database as Geography ...
0
votes
2answers
834 views

How to use Sharpmap to display spatial data from MS SQL Server 2008

Can anyone show me a step by step example on how to use Sharpmap to display MS SQL server spatial data using C# as the programming language? Please note I have exploit some of the example online but ...
0
votes
1answer
96 views

What is the most efficient way to check if coordinate didn't change for 10 minutes (c# or mssql) from a list of coords

I have a list of GPS coordinates (lat,lon) with a timestamp that I got from GPS logger. I want to find the first points that didn't change in a buffer of 100 meter for 10 minutes. What will be the ...
2
votes
1answer
220 views

Entity Framework & Sql Server 2012 spatial

I'm struggling to find any concrete performance of Entity Framework paired with SQL server 2012. We're looking at storing nearly a million points in a database an right now the most common scenario ...
0
votes
1answer
101 views

How can i generate parcel extracts on demand through a webservice

Ok, i need to generate parcel extract documents on demand. The backend is Arcgis 9.3.1 on SQL server 2008. I would like to build a webservice (C# .Net) on the server that generates these extracts. My ...
2
votes
0answers
266 views

Store elements of Imap into BLOB fields using IPersistStream

I have an IMap (include elements: text, line) and I want to store it into a field of a table in SQL, so I can load it again later. I used below codes, but I got an the error : public class Test { ...
0
votes
1answer
158 views

What is the best way to sum the area from a number of polygons in .NET/SQL Server?

I have an Mapbasic/.NET application that read data from SQL Server 2008 R2. I have a table with polygons and need to sum up the area of a subset of the polygons. This should work dynamic so the user ...
2
votes
3answers
2k views

SQL Server Geometry to geography conversion

I have imported a number of Shape files from the ordnance survey using shape2SQL these have been imported as geometry however i would like to convert them to Geography and specifically to srid 4326 ...
3
votes
3answers
4k views

Insert Geography data into SQL Server 2008

Can someone guide me to or give me an example on how would one go about insert/query Geography data in Sql Server 2008 ( Polygon with 4 points and Point in specific) using C# EF or Linq2Sql. I've ...
1
vote
0answers
595 views

Converting Lon Lat to UTM Zone 32N in C# with SQLSpatialTools

I have a set of coordinates; Lon 9.42221521, Lat 56.44978001 and I want to convert them to UTM Zone 32N coordinates. I found the SQLSpatialTools library to do the conversion but I need some help. When ...
2
votes
0answers
231 views

Updating SDE point feature classes with SQL SERVER 2008 R2 [closed]

I am contacting you in hope that you can help me resolve an issue using SQL Server 2008 R2 to push updates to a SDE point feature class. We are using a C# app that uses ArcGIS Runtime to edit the ...
5
votes
1answer
937 views

How to persist a polygon to SQL Server database and vice versa?

How do I extract all the points from a Polygon drawn in ArcMAP and then persist that data into a SQLServer database table containing a geometry column and then when I've got the data persisted read ...
0
votes
1answer
999 views

How to safely replace ArcGIS SDE feature classes using transactions

I am using C#, ArcGIS Server 10, MS-SQL Server 2008, and I want to replace an ArcGIS SDE feature class inside of a transaction. After the deletion of the feature class, I have to create a new one with ...