Microsoft SQL Server is a relational database server product by Microsoft. Its primary query languages are T-SQL and ANSI SQL.

learn more… | top users | synonyms (1)

22
votes
3answers
3k 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 ...
21
votes
9answers
13k views

Choosing database for storing spatial data?

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 ...
14
votes
15answers
2k 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?
14
votes
5answers
7k views

Using ArcGIS Desktop with SQL Server Spatial as backend?

I'm wondering how best to use ArcGIS Desktop and SQL Server 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 ...
14
votes
3answers
30k views

Create a geography/geometry column from x and y fields - SQL Server 2008

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 geometry/...
14
votes
8answers
8k 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 types,...
14
votes
2answers
3k 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 ...
13
votes
3answers
2k views

Optimize nearest neighbor query on 70 million 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 ...
12
votes
3answers
7k 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 I'...
11
votes
3answers
495 views

Searching many feature datasets for ArcSDE feature classes using field filters in ArcCatalog?

I have ~30 feature datasets and ~100 feature classes spread throughout the feature datasets. I would like to search for a feature class by name among the feature datasets. Also, I would like to ...
11
votes
2answers
2k views

Do I need ArcGIS for server to edit my MS SQL Server database?

Here is what I have: ArcGIS Desktop Advanced (10.2) & MS SQL Server 2008 R2 Here is my problem: I need to be able to connect to the ms sql server and import, export, create, and edit spatial ...
10
votes
2answers
17k views

How I get SRID from Geometry field

what is the function for getting SRID from Geometry field. I have inserted a shapefile into SQLServer table with Geometry field defined. I know the projection of shapefile is Swreff99_1800 (EPSG:3011)....
10
votes
2answers
896 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 ...
10
votes
4answers
3k views

Inserting points into SQL Server using pymssql?

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. ...
10
votes
2answers
460 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 ...
10
votes
2answers
2k 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 ...
9
votes
4answers
1k views

What is 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 ...
9
votes
2answers
1k views

why do people use geometry to represent geography?

Historically I've mainly worked with simple latitude and longitude coordinates in a SQL Server. I stored them as a geography datatype in SQL Server, and rendered them on a variety of displays (...
9
votes
3answers
1k views

Are there any training resources in SQL and Python as applied to GIS database management? [duplicate]

I've taken ESRI database courses, which have been helpful to my work. But I also need training in SQL and Python as applied to GIS database management. There are lots of suggestions for Python (...
9
votes
1answer
1k 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 ...
9
votes
4answers
2k views

ArcGIS 10.2 Query Layer on SQL Server performance

I'm using a Query Layer on SQL Server in ArcMap. The Query Layer executes instantly in in SQL Server but but takes so long to draw in ArcMap that the system appears unresponsive for about 10 minutes ...
8
votes
4answers
605 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 ...
8
votes
3answers
2k views

How to convert from SQL Server geometry BLOB to something else?

I have a CSV data file from a 3rd party that is an exported SQL Server table. They simply did a select * from foo and output the result to a text file and sent it over. In their table is column of ...
8
votes
2answers
2k views

How to use the ESRI JS API to map SQL Server Spatial Types without ArcGIS Server

I have heard of people using the ESRI Javascript API to create webmaps with spatial data from SQL Server or other RDBMS's. From what I can tell, they are not using ArcGIS Server as a middleware. In ...
8
votes
4answers
5k 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: ...
8
votes
1answer
150 views

Given two lat/longs, how can I tell if they are within 1 mile of each other?

I'm trying to implement a very efficient check to see whether two points are within a mile of each other, or not. My current approach is to compute the Haversine distance, and then check to see if it'...
7
votes
1answer
4k views

STIntersects - Update field to give me count of points in polygon

I have a points layer (dbo.ptLayer) Around 1M points Spatial Geometry Type (dbo.ptLayer.geom) No spatial index just yet, but will create one once data gathering complete. I have a polygon layer (...
7
votes
1answer
6k views

Importing shapefiles to SQL Server

I often use the brilliant SQL Server 2008 Spatial Tools to import shapefiles into SQL Server 2008. This works absolutely fine but it leaves me wondering, how do Microsoft expect end users of SQL ...
7
votes
3answers
1k 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
2answers
10k 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?? ...
7
votes
1answer
1k views

Does a high number of SDE_state_lineages slow performance?

In our SDE database, the SDE_state_lineages table has around 200,000 records, the SDE_states has around 900, and our SDE_versions table has around 1,300 records. We've been having performance issues ...
7
votes
2answers
496 views

Can't open ArcCatalog Database Connection SQL database Tables with field names greater than 31 characters

I am using SQLEXPRESS as a test environment. My issue: I have a database connection in ArcCatalog to a SQL database. Some tables in the SQL database have field names greater than 31 characters and ...
7
votes
1answer
985 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
2answers
3k 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 ...
7
votes
2answers
329 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 ...
7
votes
1answer
758 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 ...
7
votes
0answers
428 views

Geoserver WMS-T backend problems [closed]

I've been trying to set up a few timed WMS layers in GeoServer. They're simple enough, of the form ID(PRIMARY KEY) REGION DATE VALUE so for every region and date you have some value, e.g. the ...
7
votes
0answers
75 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 order ...
6
votes
2answers
1k views

ArcSDE Geodatabase MS SQL Server restore of .bak file

If we have ArcSDE 9.3.1 running on MSSQL Server 2008 R2 Enterprise and we do a full backup of a geodatabase. Then I try to restore the .bak file to a MSSQL Server 2008 R2 Express on a machine that ...
6
votes
3answers
3k 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
3answers
2k 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 ...
6
votes
2answers
940 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 ...
6
votes
2answers
93 views

Define projection at the record level

Hopefully this isn't too dumb a question, but is it possible to define projection at the record level, instead of a whole layer or table? I want to create a "project" database for all the work my ...
6
votes
3answers
2k views

How to migrate PostGIS spatial data to MsSql spatial data?

am trying to migrate PostGIS geometry to SQL server Spatial data. which ETL i have to use. it's the first time i'll work with SQL server Spatial. is there any Data ETL model that do this migration. ...
6
votes
2answers
2k 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
6
votes
1answer
1k 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 ...
6
votes
1answer
250 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: http:...
6
votes
2answers
2k views

Understanding Geodatabase Archiving and H tables in ArcSDE?

We have ArcSDE 10.0 on MSSQL 2008 with Geodatabase archiving enabled. In the process of updating a topology I deleted the topology, disabled archiving, unregistered as versioned and then recreated ...
6
votes
1answer
1k views

Is it possible that a good spatial index just cannot be made?

I have about 6 million rows with geography spatial features - they are all 1000 meter radius hexagons all over the US. There are a couple hundred thousand that would have been NULL, which I updated ...
6
votes
2answers
1k views

Autonumbering fields in versioned ArcSDE Geodatabase?

I want to have a field with autonumbering in ArcGIS. I have a versioned ArcSDE for SQL Server geodatabase. Thus, using the identity seed attribute in the SQL Server is not an option. Is it not ...