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
362 views

Can a spatial View in ArcSDE be viewed in ArcCatalog?

Can a spatial view in ArcSDE created by "sdetable create view" command be viewed as feature class in ArcCatalog, or is it just another plain table? I have a feature class table and an attribute table ...
2
votes
1answer
313 views

How to run “sdetable register” command in SQL Server?

I was planning to run "sdetable register" command to register a particular field as OID for an non-spatial table already created in a SDE database. I am with SQL Server 2008 R2. I tried to run the ...
0
votes
1answer
355 views

how to reproject data in EPSG:4326 to 3857 using SharpMapv0.9 for display on google maps

I have data stored in SQL Server 2012 in EPSG:4326. I need to display this data on a google map in 3857. but without an ST_Transform function, I cannot determine how to convert my data on the fly to ...
1
vote
1answer
288 views

How to convert int type OBJECTID to ObjectID type recognised by ArcSDE?

I have an ordinary table with OBJECTID column (type of int) in a MS SQL Server 2008 R2 instance. I need to store it in an ArcSDE geodatabase instance running on top of the SQL Server. The thing is how ...
1
vote
0answers
595 views

Converting Lon Lat to UTM Zone 32N in C# with SQLSpatialTools

I have a set of coordinates; Lon 9.42221521, Lat 56.44978001 and I want to convert them to UTM Zone 32N coordinates. I found the SQLSpatialTools library to do the conversion but I need some help. When ...
5
votes
1answer
1k views

Reset Object ID After Truncating Table In SQL Server

I am working on a program to export data from a view containing a geometry type in Sql Server 2008, to an ArcSDE table on another server which also stores data using the geometry type. The source ...
2
votes
1answer
383 views

get segments of constant length from Linestring MS SQL SERVER

For Example I have simple linestring 'LINESTRING(25 50, 100 125, 150 190)' and I need to divide it to segments of length 10. In postgis i know there is a function ST_Segmentize but what about MS SQL ...
5
votes
1answer
411 views

Ogr2Ogr exported this boundary 90 degrees incorrectly

I've got some GEOGRAPHY data in my Sql Server 2008. I wish to export it as a shapefile (so I can import it into QGIS) and when I do, it's rotated 90 degrees to the left and then flipped 180 degrees to ...
3
votes
2answers
217 views

What program(s) can I use to edit a boundary?

So i've got some shapefiles imported into my Sql Server 2008 Database. A number of these boundaries need to get 'cleaned up'. As such I need to do the following :- Export them from Sql Server 2008. ...
3
votes
3answers
877 views

SQL Spatial view using a Query Layer in ArcMap 10 is SLOW

We have a number of SQL Spatial views each made up of approximately 10 tables (so relatively complex views) and each including a table with a SQL Geometry column. A view could return up to 300-400 ...
6
votes
3answers
9k 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 ...
0
votes
3answers
732 views

How to load spatial data into ArcGIS Javascript API application from SQL Server 2008?

I have geometry data in SQL Server 2008 R2. How do I load that spatial data using the ArcGIS Javascript API?
0
votes
2answers
945 views

Enabling SQL Server 2008 database to access it as Esri geodatabase via ArcSDE using ArcGIS 10.0?

I have 1 SQL Server 2008 and 1 Oracle database (did not check which version it is). I'd like to convert them to geodatabases, first that 'MS SQL Server 2008', then Oracle. So, leave Oracle for a ...
3
votes
1answer
3k views

Geoserver SLD using PropertyIsEqualTo And PropertyIsLike

I have two SLD rules one using PropertyIsEqualTo and another using PropertyIsLike Using PropertyIsEqualTo <Rule> <Name>Vendor FirstVendor</Name> ...
6
votes
1answer
927 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 ...
2
votes
0answers
232 views

Updating SDE point feature classes with SQL SERVER 2008 R2 [closed]

I am contacting you in hope that you can help me resolve an issue using SQL Server 2008 R2 to push updates to a SDE point feature class. We are using a C# app that uses ArcGIS Runtime to edit the ...
3
votes
3answers
647 views

Merging edited data back into ArcSDE master geodatabase?

I need some suggestions/inspiration for a problem we have. The problem: We have an ArcSDE master GIS database. We will edit this data almost exclusively outside of ArcGIS and outside of ArcSDE. In ...
4
votes
2answers
377 views

Spatial Indexes on OS MasterMap Data

What are the optimal settings for setting up a SQL Server 2008 Spatial database with full UK OS MasterMap data in? Seperate tables for the different feature types, or a single table with everything ...
2
votes
1answer
576 views

Using MS SQL 2005 as the data store in GeoServer

In my project, I am trying to set up a simple WFS service in GeoServer in order to create a layer consisting of point features. I have succeeded doing so with the points being stored in a shapefile. ...
4
votes
1answer
3k views

Transforming geometry coordinates from SRID 4326 to SRID 3011

In SQLServer geometry field, I want to change the coordinates of geometry from one spatial reference system to another spatial reference system (from SRID 4326 to SRID 3011) by using ST_Transform. But ...
2
votes
1answer
7k 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 ...
1
vote
2answers
902 views

what is the format of Geometry data type of SQLServer 2008

I want to know, In which format the Geographic data stored in geometry data type of SQLServer 2008.it looks like a long string,like 0xE6100010466DFEOA4089663524....... for one polygon. My second ...
5
votes
1answer
1k 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 ...
0
votes
1answer
1k views

C# library for converting geom field of SQLServer into set of google latlng

Is there any C# library which can convert the geometry field into set of google latlngs? I have stored a shapefile into SQLserver table. From Sqlserver i want to read the geometry field data and want ...
1
vote
1answer
139 views

What are the areas, relating to database or server, that should be viewed while making map based webapplication?

This question is relating to GIS web application that are based on relational database. I have database that is not indexed with spatial column and I use geoserver to display these data as layers. But ...
2
votes
3answers
2k views

How to convert geometry coordinates into Google lat/lons?

For storing geospatial data, the geometry field is used in SQL Server or Oracle Spatial. I want to know is there any way where we can convert this geometry field into a set of latitudes and ...
1
vote
1answer
236 views

Difference in two datasource in geoserver

We have two datasource in geoserver for Sql server. what is the difference between them? Microsoft SQL Server - Microsoft SQL Server Microsoft SQL Server (JNDI) - Microsoft SQL Server (JNDI)
2
votes
1answer
764 views

How to get data from MS SQL Server 2008 into Mapserver?

I need to create some layers in my map from a Microsoft SQL 2008 database. I am using Openlayers and Mapserver. The Mapserver instance is running on SUSE linux, so the Mapserver documentation on ...
2
votes
1answer
323 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
318 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
1k 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
391 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
889 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 = ...
6
votes
1answer
616 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
554 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
629 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
335 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
317 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
232 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
938 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
755 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

Use arcgis with SQL Server 2008 as a backend

I'm wondering how best to use arcgis] and sql 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 data type I ...
3
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
988 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 ...