Microsoft SQL Server is a relational database server product by Microsoft. Its primary query languages are T-SQL and ANSI SQL.
18
votes
3answers
1k views
When should you NOT use a spatial index?
I am asking this because I was mainly working with Oracle but for the past year I've been doubling with PostGIS and SQLServer 2008. Most spatial functions in Oracle won't work without a spatial index ...
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 ...
13
votes
15answers
1k views
What GIS editors work with GIS data that is stored in SQL-Server
If I store my vector GIS data in SQL-Server, what editors can I use to edit the GIS data?
13
votes
2answers
984 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 ...
12
votes
5answers
3k views
Use arcgis with SQL Server 2008 as a backend
I'm wondering how best to use arcgis] and sql 2008 together. At the moment we run manual imports and exports between sql 2008 and arcgis 10 shape files. With sql 2008 having a geography data type I ...
10
votes
3answers
889 views
optimize nearest neighbor query on 70 million extremely high density spatial point cloud on SQL Server 2008
I have about 75 million records in a SQL Server 2008 R2 Express database. Each is a lat long corresponding to some value. The table has geography column. I am trying to find one nearest neighbor for a ...
9
votes
8answers
3k views
How can I use SQL Server's spatial types from a .Net application?
For an upcoming project, one of the requirements is to store and use basic geogrpahic data as part of an existing SQL-Server/.Net application.
It seems obvious that we could use the SQL Spatial ...
9
votes
2answers
244 views
How do I perform a 3 parameter geotransformation and projection in Sql Server 2012?
I have a table with latitude longitude (NAD27) columns in it. I compute two other columns, X and Y, representing Web Mercator (WGS84) location.
Currently I'm using a Arcmap to do this, by applying ...
8
votes
2answers
493 views
Find duplicate vertices in SQL Server geometry line (ArcSDE)
I have a line in a ZM polyline featureclass that has a invalid geometry. My suspicion is that the line doubles back on itself somewhere, which I've found SQL Server doesn't like. Anyone know of a ...
7
votes
4answers
758 views
Spatial query tool for laymen
I know nothing about GIS, but I have what I think is a GIS problem. From spending a few hours googling my problem, I think what I need to do is perform a spatial query, but I'm not sure how to go ...
7
votes
4answers
525 views
MS SQL Spatial as Central Datastore?
I've been working on opening up our spatial data from a proprietry system to one that can be read by more products (MapGuide, ESRI, gvSIG, Map3D etc....)
I've decided on using SQL Spatial as we have ...
7
votes
3answers
753 views
Are large companies successfully using SQL Server GeoSpatial functionality?
I am working on a project where I have to allow users to find things that are near by. In the past I have just manually stored lat/longs and done my own calculations but I'm curious if it's worth ...
7
votes
1answer
495 views
Visual Studio Lightswitch and spatial data
I'm looking for a way to handle spatial data (for instance geography data type in SQL Server 2008) in Visual Studio Lightswitch 2011.
Preferably with an extension that can show data on a map. So far ...
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 ...
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 ...
6
votes
3answers
2k views
When to store geometries using SQL-server geometry datatypes or ArcSDE?
With the release of SQL Server 2008 Microsoft added geometry data types. So geometries can now in an ESRI enviroment be either be stored using SQL-Server datatypes or ArcSDE datatypes.
A colleague ...
6
votes
1answer
205 views
What is the best way to store Flickr's Shapefiles Public Dataset in SQL Server 2008?
I'm wanting to import specific locations from the Flickr Shapefile Dataset into SQL Server would like to know what is the best way to store the data in SQL Server 2008?
Link the the 1.0 Dataset: ...
6
votes
3answers
247 views
Insert points into SQL Server?
I am collecting X and Y values from a web service (Twitter) via a python script. In the long run, this will run over a period of months and I intend on stopping at around the 6 million point mark.
...
6
votes
1answer
394 views
SQL Server Relationships in ArcSDE
I am running ArcSDE 10 with SQL Server 2008 R2 Standard Edition. I am new to SDE and SQL Server, but I understand that SQL Server has the ability to create relationships between tables and maintain ...
6
votes
2answers
2k views
ArcSDE - where to start?
As I long ago figured out that I need more complex query-asking abilities (other than the standard select provided by arcgis), and as I will someday have to admin a small scale SDE database that will ...
6
votes
2answers
969 views
Can Mapnik render spatial data from SQL Server?
This is a very simple question - I just want to know if anybody can confirm that they have successfully used Mapnik to render tiles directly from data held in SQL Server. (And, if so, what did you do ...
6
votes
1answer
64 views
ArcSDE : Cascading Subtypes in ArcGIS 10/SQL Server
I'm currently creating an ArcSDE DB on an SQL Server. It is designed to complete species survey, with information from the field.
In order to help themselves, they asked me to implement a particular ...
5
votes
3answers
666 views
Determine if a polygon intersects itself in OpenLayers
I let the users draw polygons and then I try to save them out to the SQL Server 2008 SQLGeography field, but it is giving me an error:
Error 24200: The specified input does not represent a valid ...
5
votes
2answers
372 views
Spatial metadata table in SQL Server 2008
I have a db and want to know if it contains any spatial tables. Is there a table in SQL Server that holds spatial metadata i.e. a list of all the spatial tables in the current db? Oracle has the ...
5
votes
1answer
690 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 ...
5
votes
2answers
163 views
Does SQL Server need extensions to do spatial?
Does SQL Server need extensions to do spatial like Oracle does?
Just wondering if there will be extra costs for implementing a SQL Server backend to SDE.
Thanks
5
votes
4answers
616 views
Are there any tools for editing Sql Server spatial types in Silverlight?
I see from this post that I can tweak RIA Services to transmit Sql Server spatial types. What I'd like to do is edit these spatial types. Does anyone know of any tools that would run in Silverlight ...
5
votes
1answer
173 views
BigInt data type in SQL Server mapped as Text in ArcMap
I have a table in a SQL Server 2008 database containing a BIGINT data column. When I tried to import it into ArcMap 10, it automatically converted as Text of 8 length. This caused the records that ...
5
votes
1answer
598 views
ArcSDE 10 on SQL Server 2008 R2 Cluster 64bit or 32bit
I am looking for Tips an Tricks on installing ArcSDE on SQL Server 2008 R2 Cluster. Our IT division would like to have all the databases on their new 2008 cluster.
I've only done standard install ...
5
votes
2answers
1k views
why is a gdb query WHERE clause invalid according to the ArcGIS REST API?
Update: This only occurs when the layer being queried has a join.
It doesn't matter if it has a join to a different database or not. And the query that fails is not trying to access columns in the ...
5
votes
1answer
155 views
Can you synchronize tables between ArcSDE(MSSQL) and PostgreSQL(PostGIS) regularly?
I have spatial tables in ArcSDE 10.1 (MSSQL 2008 R2) geodatabases and need to update the same spatial tables in PostgreSQL 9.1(PostGIS 2.0.1) geodatabases. Basically I use my ArcSDE environment for ...
5
votes
1answer
302 views
STGeomFromText not working on large polygons
I'm using Microsoft.SqlServer.Types to do intersections on polygons.
SqlChars scFullSwath = new SqlChars(new SqlString(fullSwath));
SqlGeography fullSwathGeom = ...
5
votes
1answer
524 views
Reset Object ID After Truncating Table In SQL Server
I am working on a program to export data from a view containing a geometry type in Sql Server 2008, to an ArcSDE table on another server which also stores data using the geometry type. The source ...
5
votes
0answers
275 views
Geoserver with SQL server consuming all my CPU
This question is long please bear me and my problem.
SQL Server Query profiler
The Sample Query from profiler that geoserver is running that corresponds to SLD I am using and not the SQL SERVER view I ...
4
votes
7answers
705 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 ...
4
votes
1answer
162 views
SQL Server data modelling + spatial data = what book?
What recommended book can you provide about data modelling for geographical spatial data (geometry) in SQL server?
4
votes
2answers
3k views
Create a geography/geometry column from x and y fields - SQL Server 2008
Hy guys,
I'm new in SQL Server 2008 and I hope you will understand my question/need.
Thus, I have a table which contains 3 fields (Name, Lat and Long) in my data base (spatial). I want to create a ...
4
votes
2answers
854 views
Adding data from a SQL Server Spatial database to ArcMap or ArcEngine application with ArcObjects for better performance
I have an ArcSDE geodatabase stored in MS SQL Server 2008 R2. The datasets in this geodatabase range from 10 record to 7 million records and there is a mixture of tables and spatial datasets (SQL ...
4
votes
2answers
809 views
Get Database Table Name From Layer Name in ArcObjects
I am using ArcObjects v10.0 with a SQL Server 2008 database. Given the name of a Layer, is there a way for me to extract the corresponding name of the database table that represents that Layer?
The ...
4
votes
2answers
410 views
Why does ST_Area(g.geom) + ST_Area(p.geom) - ST_Area(ST_Union(g.geom,p.geom)) produce negative result when using ST_Overlaps(g.geom, p.geom) = true?
I have two set of shape data. Let's say file gov.shp contains list of post codes and their boundaries. File post.shp contains list of government area name and their boundaries. I want to find out the ...
4
votes
1answer
608 views
Clipping a SqlGeometry
I have been messing around with the SqlGeometry in the Microsoft.SqlServer.Types namespace in .NET, and have been rather impressed.
Can anyone provide me with an example of how I could clip a ...
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 ...
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??
...
4
votes
2answers
487 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
1answer
201 views
What licenses are needed for ArcGIS Server and SDE (vs a FOSS setup)?
Does anyone know where I could find a cost breakdown for an ESRI/Microsoft GIS server and database setup?
I'm trying to figure out all the costs associated with an ArcGIS Server/SDE sitting on top of ...
4
votes
1answer
69 views
How can I overwrite a geodatabase in AcrGIS server 10 with SQL Server SDE, using xml workspace?
I want to transfer a geodatabase from my development server to my client's production server. We are using SQL Server, but in different versions. Hence I cannot use Backup/restore or detach/attach. ...
4
votes
1answer
960 views
Registering SQL Spatial View in ArcSDE and updating Row_ID
I am having issues registering an inner join SQL view with a spatial column in ArcSDE. Any help would be much appreciated.
Here is the background info:
ArcSDE 10, SQL Server Enterprise 2008 R2, SQL ...
4
votes
1answer
301 views
DBMS and ArcSDE Architecture for Large (Mostly Non-Spatial) Dataset
I have ~1000 fixed points representing data collection stations with multiple sensors, and a csv that is ~4.5GB of values in the format:
id pointid sensor measdatetime measvalue
50345 500 ...
4
votes
1answer
273 views
Has anyone successfully installed HAZUS MR4?
I am attempting to install HAZUS-MH MR4 (v1.4) on a Windows XP SP3 computer with ArcGIS 9.3 SP1 installed. The installation seems to be running fine up until it attempts to start services. Then it ...
4
votes
1answer
869 views
ArcSDE - Registering table with Geography spatial column fails with error -138 (SQL Server 2008)
I have a table of point features I am trying to register with ArcSDE (9.3.1 on SQL Server 2008) using the following command:
sdelayer -o register -l ThirdPartyWellsSurface,Shape -e np -C OBJECTID,SDE ...
