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
1answer
349 views

Why are STDistance results so small?

Im trying to get familiar with spatial data using sql server 2008. I use book: http://www.beginningspatial.com/ and there is sample data: ...
4
votes
2answers
1k 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 ...
1
vote
0answers
336 views

Connecting uDig with Sql server 2008

I tried to connect uDig with Sql server 2008 but could not do it the following error poped that it missed imageio ext and jdbc driver for sql server. I added it to jre/ext/lib (both of them). Now the ...
2
votes
4answers
2k views

How can I transform some KML data to Sql Server 2008 using FME?

I've just downloaded FME 14 day trial. I'm trying to see how easy/hard it is to transform some KML data (a simple neighbourhood shape) into my Sql Server 2008 database using FME. I sorta don't even ...
3
votes
2answers
5k views

How can I display this polygon in Google Maps, properly

NOTE: this question is sorta like a follow-on question to this original GIS Question I asked. In that question, the main suggestion was that I was trying to show two polys. Now, I'm asking about a ...
2
votes
0answers
413 views

How to transform Lambert to WGS84 in SQL Server?

Need to create a SQL view of calculated Lat/Lon values from an existing SQL view of County Coords. Loaded up SQL Server Spatial Tools and registerd CLR types. Lambert generated a resource error. -- ...
2
votes
1answer
1k views

Calculating the outer boundary of several Geometry objects in SQL Server 2008

I have lots of Polygons of datatype Geometry in SQL Server 2008. The image below shows how a select of all these Geometrys looks visualized. What I need to do is create a Polygon which represents ...
3
votes
1answer
1k views

MS SQL Server's STDistance output differs from Google Earth/Maps straight line distance

I am testing SQL Server STDistance function in the following way: DECLARE @g geography; DECLARE @h geography; SET @g = geography::STGeomFromText('POINT(53.553813 9.99158)', 4326); SET @h = ...
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 ...
5
votes
2answers
611 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 ...
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 ...
4
votes
4answers
658 views

update spatial data from excel to ms-sql server 2008

I have 1000's of data with 50's of column. It is point data. The data is in MS-SQL server.Now each day I need to load 100's of data similar in structure. How can I achieve it ? I tried to append ...
4
votes
1answer
337 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 ...
1
vote
1answer
349 views

How to convert SQL Server Rasters to ASCII Grid?

I have 25km by 25km squares of the world in a relational database. Each square has coordinates for the top left and lower right corner as latitudes and longitudes. Each square also has an index ilat ...
3
votes
2answers
1k views

Adding rows of data to a non-spatial table in ArcMap with a SDE SQL Server for Metadata purposes

I'm attempting to use several non-spatial tables to better organize the large set of feature classes I continually add to a SDE Geodatabase (SQL Server Express). So I have several tables setup and ...
2
votes
1answer
239 views

Link non-spatial SQL Server query to a Geodatabase?

Is it possible to build an object (of whatever kind) in ArcEngine code that links the geodatabase data with a non-spatial SQL Server query? How would you go about doing this?
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 ...
3
votes
2answers
865 views

SQL server views in geoserver - problem with sql

I try to extract non-spatial data from mssql as spatial data to my Geoserver 2.1.0 installation from a sql statement looking like this: SELECT database.table1.id, ...
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 ...
4
votes
1answer
2k views

Why does “Add Database Server” in Catalog 10 allow only ArcSDE Personal or Workgroup databases?

Arc Catalog 10 - ArcInfo - Database Severs - Add Database Server: "Add an ArcSDE Personal or Workgroup database server by typing in the SQL Server Express instance you wish to connect to." I want to ...
2
votes
3answers
2k views

Trigger on SQL Server 2008 ArcSDE 10 and ArcGIS Server 10

I need to build a sql server db trigger to update a date field with the current date when a record is inserted or updated, I think. I will be using the date field as a way to recognize ...
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 ...
1
vote
0answers
297 views

T-SQL with SDE and Web Map ArcGIS Server 10 MSSQL 2008

I need to build a system whereby the user of a web map (the standard web map that ArcGIS Server Manager builds) can edit a feature class's attributes. The attribute will be a 'Comments' field. The ...
3
votes
2answers
393 views

What's the best way to store State Plane data in SQL 2008R2?

I have a client with data that is currently in a State Plane coordinate system. They are looking to store this data in SQL Server 2008R2. SQL does not "support" the SRID for the State Plane in ...
1
vote
0answers
318 views

Is it possible to create an updateable spatial view? [closed]

1- I have encountered a problem relating with sde commands for creating sde_ view and also sde_table . I used appropriate codes but an error massage occured during execution. the related codes: ...
0
votes
1answer
312 views

Where does MapInfo store its error and log files?

I am having errors opening a table with spatial co-ordinates in Microsoft SQL and my question in gis.stackexchange is here. I want to know where are the error and log files of Mapinfo stored. I ...
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
1answer
836 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 ...
1
vote
1answer
915 views

ArcGIS Server 10 and SQL Server 2008 R2 permissions and feature services

I have ArcGIS Server 10 with SP1 and SP2 on windows server 2008 and ArcSDE (from an edn liscense) installed on top of MS SQL Server 2008. When I make a spatial db connection in ArcCatalog (direct ...
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 ...
3
votes
2answers
3k views

find location details within circle buffer

Wondering how would i go about getting this to work. I have a table with location data (lat, long, homevalue) in sql server 2008. Given a lat long say (32.113, -81.3225), i want to draw a 50 mile ...
5
votes
2answers
987 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 ...
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 ...
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?? ...
2
votes
1answer
1k views

Find distance from a point to linestring

I have table (shapetable) with my coastline shape file loaded. I have another table (pointtable) with lat long points. Wondering how would i go about writing a sql query to find the distance between ...
2
votes
1answer
673 views

Convert SqlGeometry data from SQL directly to Tiles / PNG file

I would like to know a basic method for 'exporting' SqlGeometry data from SQL Server 2008 to a Tile Server / PNG File generator. I already have a Silverlight Map application which uses a Custom Tile ...
1
vote
2answers
141 views

Get All Records 60 Degree North in SQL with query on Lattitude-Longitude Column?

i have table with latitude & longitude columns in sql. how can i select all records with lat-long 60 degree north> ( Arctic Region ) Thanks Pragnesh
2
votes
1answer
804 views

How to insert DateTime null using IRowBuffer

I am using IRowBuffer/IFeatureBuffer to insert fields to SQL Server 2008 DB. When inserting a field I am using: public void SetValue(IRowBuffer buffer, string field, object value) { int ...
2
votes
3answers
2k views

Transform Data with Microsoft Spatial SQL

Is there a way to transform geographic data in SQL Server 2008 R2? Specifically, I want to take Lat/Long data and convert it to a State Plane coordinate system.
1
vote
2answers
454 views

Access Feature Classes on Multiple Database Schemas with ArcSDE

I am using ArcObjects to access a GeoDatabase that was set up with ArcSDE 10 and SQL Server 2008 R2. In this particular case, I have some tables set up on alternate schemas (this is to replicate a ...
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 ...
1
vote
3answers
996 views

ArcSDE & Oracle & Database Model — Best diagram the system

Having Oracle dbms with ArcSDE and ArgGIS Pipeline Database Model (APDM), I would like to best describe the system with a diagram. In MS SQL each db is autonomous, I think, meaning ArcSDE(using dbo ...
0
votes
1answer
1k views

How to safely replace ArcGIS SDE feature classes using transactions

I am using C#, ArcGIS Server 10, MS-SQL Server 2008, and I want to replace an ArcGIS SDE feature class inside of a transaction. After the deletion of the feature class, I have to create a new one with ...
5
votes
2answers
791 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 ...
1
vote
3answers
1k views

Is the “sdetable” command available with ArcGIS Workgroup

Is the "sdetable" command available with ArcGIS Workgroup, or only the Enterprise edition? We have ArcGIS Server Workgroup 9.3.1 and want to update some of the feature class tables with data from ...
3
votes
1answer
1k views

Can spatial data in Oracle be imported into SQL server?

Oracle supports spatial data and so does SQL Server. What are the things to consider if we have to migrate spatial data from Oracle to SQL Server? Are there any features in Oracle that are not there ...
4
votes
2answers
1k 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 ...
2
votes
0answers
418 views

OGR VRT MSSQL example

I'm trying to import vector data into SAGA GIS from a SQLExpress 2008 server. Firstly is this possible? I would have thought using an OGR VRT layer would have been the way to do it, I've attached a ...
2
votes
1answer
727 views

How to create SDE GDB without post installation?

Is there any way to create a SDE sqlserver2008 geodatabase without : SDE post-installation execution on the server having sde service running on the server and using : execution of some DDL ...
3
votes
4answers
1k views

Creating a multiversioned view with ArcSDE and SQL Server 2008 R2

I am using the administration command sdetable -o create_mv_view to create a multiversioned view on a table in SQL Server 2008 R2. Everything appears to be working correctly with one exception: The ...