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)

3
votes
1answer
783 views

Configuring WMS from a MSSQL data source with MapGuide Open Source

I've having trouble configuring WMS out of MapGuide Open Source. Here's what I've done so far: Installed MapGuide Downloaded MapGuide Maestro Created a "feature" in Maestro that connects to ...
5
votes
4answers
729 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 ...
4
votes
1answer
1k 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 ...
3
votes
2answers
462 views

Has anyone successfully implemented a web service that sits on top of ArcSDE (SQL Server 2008)?

Here's the situation. We have planned point locations that lie within predefined polygonal project areas. Our IT department currently has these polygonal project areas in SQL Server 2008 as geography ...
2
votes
2answers
2k views

Create ArcSDE Database from ArcCatalog

Is there a way to create a spatial database from ArcCatalog that also creates the ArcSDE user, repository, and service. Basically, I am trying to do everything that the ArcSDE Post Installation does, ...
8
votes
2answers
667 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 ...
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 ...
4
votes
2answers
2k views

ArcSDE 10.0 giomgr Error During Post Install

I just installed ArcSDE 10.0 and ran the post install once to test the install and it ran great. Today I tried to run another post install to create another database and I get the error: "Parameter ...
6
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 ...
4
votes
1answer
862 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 ...
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 ...
2
votes
4answers
482 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
559 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 ...
2
votes
1answer
191 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
223 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: ...
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 ...
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?
19
votes
8answers
6k 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 ...