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)

2
votes
4answers
531 views

OGR OVF has no identified FID column

I have an OVF layer defined as follows: <OGRVRTDataSource> <OGRVRTLayer name="UserPoint"> <SrcDataSource>ODBC:un/pw@CLO</SrcDataSource> ...
7
votes
4answers
589 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
910 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 ...
2
votes
1answer
195 views

Why does SQL job choke on stored package?

I've written a stored package to pull a text file into a table in the geodatabase. It works perfectly. However, when it is a step in a SQL job, the job fails at that step. I'm looking for ideas on ...
6
votes
1answer
236 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: ...
12
votes
8answers
6k 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 ...
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?
21
votes
8answers
10k 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 ...