Microsoft SQL Server is a relational database server product by Microsoft. Its primary query languages are T-SQL and ANSI SQL.
6
votes
2answers
2k views
Is it possible to reproject spatial data using SQL Server?
SQL Server takes an SRID when creating spatial data, but is it possible to retrieve an object as a different spheroid?
For example, let's say I have a bunch of spatial polygons using SRID 4258, but ...
2
votes
1answer
3k views
How to import shape file into SQL Server 2008 R2 using only SQL scripts?
I am trying to import some shape files into SQL Server 2008 R2. I found this useful tool called Shape2SQL however I am not sure how I can import shape file directly using only SQL scripts as this is ...
4
votes
1answer
1k views
Transforming geometry coordinates from SRID 4326 to SRID 3011
In SQLServer geometry field, I want to change the coordinates of geometry from one spatial reference system to another spatial reference system (from SRID 4326 to SRID 3011) by using ST_Transform. But ...
15
votes
6answers
3k views
What are the best databases for storing spatial data? Pros and Cons
A couple of days ago I installed the demo of spatialware 4.9 from MapInfo into my SQL Server 2005 install and loaded all the larger dataset into it. I was quite impressed with the performance vs the ...
4
votes
2answers
2k views
Find closest lat long to an input lat long (SQL Server 2008)
I have a point cloud in my database (SQL Server 2008 spatial). That is about 6 million records. There are 3 columns: id, value, geom. What is the optimal way of getting the 'value' at input lat long??
...
13
votes
2answers
982 views
How can I fix my complex Polygons so they show correctly in Google Maps?
Problem: I'm trying to find a way to fix some broken polygon shapes and I'm not sure how I can do this.
Details:
I've got a number of polygons which I basically imported from TIGERLINES a while ...
3
votes
3answers
2k views
STDistance Unit in SQL Server 2008
I've got a SPROC in SQL Server 2008 where I'm trying to calculate the distance between a point and a polygon, and I'm getting unexpected results. I am passing a parameter (@Radius) in miles to the ...
2
votes
2answers
124 views
ArcGIS Server Error: “Feature service requires a registered database”
I'm attempting to publish a feature service to ArcGIS server. I'm running SQL Server Express and ArcSDE. When I try to publish the service I get the error "00090: Feature service requires a registered ...
7
votes
0answers
64 views
How can I automatically split a spatial layer to a grid [duplicate]
Possible Duplicate:
Divide vector in equal smaller parts in QGIS or similar
I am a software engineer and the company I work for has a project that needs some spatial data manipulation in ...
4
votes
2answers
485 views
How can we use SQL to update feature class attributes in a versioned geodatabase in ArcGIS Workgroup
ArcGIS Workgroup Edition 9.3.1, MS SQL 2005 Express
I have some attribute data that I want to periodically update with information from another RDBMS using SQL UPDATE commands. The data is ...
4
votes
7answers
703 views
Any Good Map Rendering Engines for SqlGeometry/SqlGeography
Can anyone suggest good map rendering engines for MS SQL Server Spatial types (SqlGeometry/SqlGeography)? By rendering, I mean plot the geometries to a common image format such as png or jpeg with ...
3
votes
1answer
97 views
Create polygons in ArcMap 10.0 from lat/long data pulled from SQL Server 2008 database
Forgive me if this is very basic, as I'm new to GIS work (though I've been a programmer for 10 years) and so I'm not really sure how to approach this, but here goes...
Can I take a table with ...
2
votes
3answers
927 views
Transform Data with Microsoft Spatial SQL
Is there a way to transform geographic data in SQL Server 2008 R2?
Specifically, I want to take Lat/Long data and convert it to a State Plane coordinate system.
1
vote
1answer
255 views
How to convert SQL Server Rasters to ASCII Grid?
I have 25km by 25km squares of the world in a relational database. Each square has coordinates for the top left and lower right corner as latitudes and longitudes. Each square also has an index ilat ...
0
votes
3answers
405 views
How to load spatial data into ArcGIS Javascript API application from SQL Server 2008?
I have geometry data in SQL Server 2008 R2. How do I load that spatial data using the ArcGIS Javascript API?
0
votes
1answer
983 views
C# library for converting geom field of SQLServer into set of google latlng
Is there any C# library which can convert the geometry field into set of google latlngs? I have stored a shapefile into SQLserver table. From Sqlserver i want to read the geometry field data and want ...
