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)

20
votes
3answers
2k 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 ...
19
votes
8answers
7k 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 ...
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?
13
votes
2answers
2k 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
5k 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 ...
10
votes
3answers
2k 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
5k 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
948 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
2answers
306 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
706 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 ...
8
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 ...
8
votes
2answers
1k 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 ...
7
votes
4answers
982 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
568 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
12k 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 ...
7
votes
2answers
3k 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 ...
7
votes
2answers
286 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 ...
7
votes
2answers
944 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 ...
7
votes
3answers
1k 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 ...
7
votes
1answer
720 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 ...
7
votes
1answer
834 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
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 ...
7
votes
2answers
208 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
0answers
67 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 ...
7
votes
1answer
524 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 ...
6
votes
3answers
1k 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
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
2answers
79 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
1answer
226 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
1k 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
2answers
5k 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?? ...
6
votes
2answers
434 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
2answers
969 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 ...
6
votes
1answer
1k views

Installing 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 ...
6
votes
1answer
2k 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 ...
5
votes
2answers
985 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 ...
5
votes
2answers
610 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
3answers
280 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 ...
5
votes
1answer
206 views

What exactly does the ArcGIS Server service do? SQL Server service?

What is the purpose of the ArcGIS Server service? It's not used at all to do a direct connect to an SDE database, right? That would just use the SQL Server service? While we are on the ArcGIS Server ...
5
votes
3answers
763 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. ...
5
votes
2answers
224 views

Is it possible to force uppercase in a geodatabase string field?

I have certain string fields in my geodatabase tables with which I would like to enforce an all-uppercase rule. These fields are ones that do not lend themselves to domains (such as address fields). ...
5
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 ...
5
votes
1answer
2k views

QGIS and SQL Server Spatial Tables Performance

I'm trying to get a SQL Server 2008 R2 spatial database up and running to streamline the production of maps using QGIS. Currently I just have a handful of spatial tables (a postcode level point table ...
5
votes
2answers
1k 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
2answers
790 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 ...
5
votes
1answer
258 views

How to create polygons in ArcMap 10.0 using lat/long data 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 ...
5
votes
4answers
749 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
79 views

Automate loading a table into SDE

How can I automatically load a table stored on a network share into SDE when the original table is edited? Environment is ESRI 10.1 ArcSDE on SQL Server. Preference for python or existing GP tools. ...
5
votes
1answer
334 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
2answers
2k 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 ...