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)

5
votes
3answers
851 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. ...
0
votes
1answer
74 views

What kind of unit of measurement for scale does SQL Server 2012 Spatial use?

What kind of unit of measurement for scale does SQL Server 2012 Spatial use?
1
vote
3answers
138 views

How to Retrieve X and Y from a papermap or gif picture

Goal: Visualize a subway map in SQL server 2012 spatial data based on the map of the subway. The map shall use geometry, traffic rail road as line object, station as point object and zon as polygon ...
3
votes
1answer
345 views

How to use stored procedure in Geoserver?

I have a MS SQL Server 2008 R2 with and have stored procedure in here. I want to create layer in GEoserver using this. I try: EXECUTE [dd_base].[dbo].[Request BaseSration] 'param1', 'param2', ...
1
vote
0answers
360 views

Connect QGIS to MSSQL view (i.e. not a table)

I've got a MSSQL view containing data I want to show in QGIS. The view transforms a BLOB field containing WKB that is in one of my tables into a SQL geometry, which QGIS will be able to display. ...
2
votes
1answer
1k views

How to use non-native spatial data from MS SQL Server with ogr2ogr?

I have some tables in MS SQL Server (2012) with WKT string columns. I want to export these data to a MapInfo tab file. Currently I am using the following command: ogr2ogr -f "MapInfo File" ...
2
votes
0answers
71 views

Critera for geometry or geography

What criteria do you need to take account to before you choose geometry or geography map? Is there a book or page about it?
4
votes
1answer
777 views

What licenses are needed for ArcGIS Server and SDE (vs a FOSS setup)?

Does anyone know where I could find a cost breakdown for an ESRI/Microsoft GIS server and database setup? I'm trying to figure out all the costs associated with an ArcGIS Server/SDE sitting on top of ...
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
3
votes
2answers
265 views

Several questions about using spatial data?

If you have spatial data for SQL server, can you use the spatial data (both geometry and geography) in another application for instance ESRI ArcGIS? Is spatial data a standard that every GIS ...
3
votes
1answer
313 views

FME: Can I add multiple feature types to the SQL Server Spatial reader?

The title's it, really. With .TAB file reader, you can add multiple layers to the reader and use the 'merge feature type' check box with an '*' to read all the layers listed in the source files, ...
4
votes
1answer
346 views

SQL Server data modelling + spatial data = what book?

What recommended book can you provide about data modelling for geographical spatial data (geometry) in SQL server?
3
votes
2answers
603 views

Visualize Spatial Data in Reporting Service

Is it possible to visualize a piece of geographical map from SQL server Spatial data (geometry, not geography) in a report from reporting service? If yes, how should it be done in a course of action. ...
3
votes
1answer
926 views

Openlayers: OGC Filter problem

I have a problem with OGC filter. My layer in OpenLayers has this filter: filter: new OpenLayers.Filter.Comparison({ type: OpenLayers.Filter.Comparison.BETWEEN, property: ...
2
votes
1answer
549 views

What is the “best practice” way to retrieve features from MSSQL to OpenLayers and display them?

Today I have a table in the DB with columns Feature Name and Feature Point. When I want to load the points to OL I do the following : First I call web service to get list of json objects: var ...
4
votes
1answer
2k views

STIntersects - Update field to give me count of points in polygon

I have a points layer (dbo.ptLayer) Around 1M points Spatial Geometry Type (dbo.ptLayer.geom) No spatial index just yet, but will create one once data gathering complete. I have a polygon layer ...
7
votes
2answers
219 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 ...
4
votes
1answer
673 views

Is there a way to get centroid of geographic object in MSSQL?

I have a table of OSM geographic roads in MSSQL 2012. I want to create a new column with the centroid of each road (So I can set center on OpenLayers map for each road). How can I do it ?
0
votes
0answers
118 views

Can osm way records in SQL spatial be merged to one geographic record if they have same Id?

I've imported England shp file of roads to mssql using OSM2MSSQL and I've noticed that the same road has couple of records with same Id but different geographic (probably it was segmented). Is there ...
0
votes
2answers
505 views

How can I get nearest road to a lat lon in MSSQL?

I've updated osm data (ways) in MSSQL and got geographic objects. Now I want to get the closet road to any lat lon a user will query. Which SQL spatial statement is used for that ?
0
votes
1answer
468 views

How can I relate between street and city in OSM imported data into SQL?

I've used OSM2MSSQL to fill db with 2 cities streets. Now I have the following tables in my DB : tNode tNodeTag tRelation tRelationMember tRelationTag tTagText tWay tWayCreation tWayTag How ...
1
vote
2answers
318 views

SQL Server STpointfromText comes from PHP into javascript as garbage

Sorry for the sloppy title. Here's the scenario - I have a table in SQL Server 2008 R2 It has a geographyColumn, created thusly: add geographyColumn as ...
2
votes
0answers
423 views

MSSQL spatial layer import error

I am currently working on a project in which spatial data are stored in a Microsoft SQL Server 2008 database. The tables which hold the spatial table contain 3 rows and are: RoomId - BIGINT, ...
2
votes
2answers
592 views

Can we use procedures in a Query layer (ArcGIS Desktop 10.1 & Server 10.1)?

I have one basic question that.. Can we use procedures in Query layer (ArcGIS Desktop 10.1)?? Currently I am using query layer for ArcGIS Desktop 10.1 and its working fine . My DBA person told me ...
2
votes
0answers
394 views

How to build a Query Layer in ArcMap 10.1 using columns of two different databases?

As you may know, to create a Query Layer in ArcMap 10.1, it is required to specify a connection to a concrete database and then, define the access to the tables and columns in the SQL Query ...
6
votes
2answers
503 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 ...
1
vote
0answers
54 views

SQL server 08 Limitations

The Soil SURvey GeOgraphic (SSURGO) database is a set of very large and complicated shapefiles. We want to load all of the shapefiles for the US into a national SQL database. Are there import ...
4
votes
2answers
338 views

PostGIS or SQL 2008 ? (For the newbie GIS programmer but familiar with .Net) [closed]

I've been using MS SQL for years. Starting now to develop GIS application and it is required to do queries and store vectors created in OpenLayers in DB. Assuming I'm developing over .Net , What will ...
4
votes
1answer
493 views

How to register a Stored Procedure in ArcSDE?

I just registered a SQL Server view with ArcSDE through sdetable -o register [...]. I wonder, how to register a SQL Server stored procedure with ArcSDE? Is it the same process as the view? EDIT ...
4
votes
1answer
659 views

Why don't my polygons from MSSQL2008 display in QGIS?

I have imported a polygon shape file in MSSQL2008 using Shape2SQL loader without any issue. When I import the loaded polygon file in QGIS, I can't see it ! When I import other point or line features ...
7
votes
4answers
2k 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. ...
4
votes
0answers
354 views

Geoserver WMS-T backend problems

I've been trying to set up a few timed WMS layers in GeoServer. They're simple enough, of the form ID(PRIMARY KEY) REGION DATE VALUE so for every region and date you have some value, e.g. the ...
3
votes
1answer
419 views

How to force sql server to use the spatial index?

I'm beginner with SQL Server (2012). I created a spatial index, and I'm trying to force SQL Server to use that index to solve the query. Here's what I have: DECLARE @g geography SET @g = ...
5
votes
1answer
355 views

Can you synchronize tables between ArcSDE(MSSQL) and PostgreSQL(PostGIS) regularly?

I have spatial tables in ArcSDE 10.1 (MSSQL 2008 R2) geodatabases and need to update the same spatial tables in PostgreSQL 9.1(PostGIS 2.0.1) geodatabases. Basically I use my ArcSDE environment for ...
4
votes
1answer
209 views

Using xml workspace to overwrite geodatabase in ArcGIS Server 10 with ArcSDE for SQL Server?

I want to transfer a geodatabase from my development server to my client's production server. We are using SQL Server, but in different versions. Hence I cannot use Backup/restore or detach/attach. ...
2
votes
1answer
485 views

Live update (the database & Map) possible in ArcGIS Server 10.1?

I am using sql server data base contains lat/lon values and using this information I have created the shape files and published on server.. When I get the update say 100 records then I need to ...
2
votes
0answers
438 views

Ogr2ogr: Unable to open datasource problem

I downloaded the Precints shapefile from the City of Boston's data hub, and I'm trying import it into SQLServer (I'm running the Express verson). I've already created the database in the SQLServer ...
0
votes
1answer
1k views

Getting 001270 error : Consolidating the data failed while publishing as map service in ArcGIS for Server?

I am getting an error "001270 error" . I am inserting table for sql-server database and joining few records to polygon layer also I have lat,Lon data in few tables so I am displaying data using ...
3
votes
2answers
345 views

Is it possible to load features into ArcSDE without using ArcObjects?

I have a SDE geodatabase in MS SQL Server, where geometries are stored in MS SQL's native geometry types, rather than the ArcSDE Binary. It seems like it would be relatively easy to create new ...
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 ...
2
votes
0answers
293 views

Store elements of Imap into BLOB fields using IPersistStream

I have an IMap (include elements: text, line) and I want to store it into a field of a table in SQL, so I can load it again later. I used below codes, but I got an the error : public class Test { ...
1
vote
1answer
706 views

MapServer connection to SQL Server 2008

I'm trying to view some data held in a SQL Server 2008 database using MapServer. I can run the GetCapabilities requests without any errors, but when i try and run a GetFeature I get the following ...
6
votes
2answers
1k 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 ...
2
votes
1answer
1k views

Shapefile to MSSQL with ogr2ogr fails to make connection

I am using ogr2ogr from OSGeo4W on my Windows 7 box to import a shapefile into a SQL Server database on one of my servers. I was able to successfully complete the conversion using shp2sqlserver, but I ...
2
votes
1answer
158 views

How to create a network with all the track points

I have created a sample network through the use of gps visualizer. Than I used the ogr2ogr function to import this data in my database. Now I have a table which holds all the track points of these ...
0
votes
1answer
831 views

Ogr2Ogr doesn't work with QGIS 1.8

I'm trying to use Ogr2Ogr.exe to import some shapefiles. It came installed with QGIS 1.8. When I try and run it, i get the following error: C:\Program Files (x86)\Quantum GIS Lisboa\bin>ogr2ogr ...
2
votes
1answer
2k views

How to save a vector layer from QGIS to Sql Server 2008 or 2012?

using QGIS, i've loaded up some administrative boundary data of New Zealand. I wish to now import this vector data from QGIS into my Sql Server 2012. Is there any way to do this with QGIS ...
2
votes
4answers
7k views

How to import shapefiles into MS SQL 2008 and then view that data using QGIS?

I'm a QGIS users but not a database person and I need some help on the DB side. I'm currently in the need to import several shape files into MSSQL 2008 and I have no clue how to do that and my IT guy ...
0
votes
1answer
188 views

What is the best way to sum the area from a number of polygons in .NET/SQL Server?

I have an Mapbasic/.NET application that read data from SQL Server 2008 R2. I have a table with polygons and need to sum up the area of a subset of the polygons. This should work dynamic so the user ...
2
votes
3answers
358 views

How to save a QGIS workspace with database link for offline use?

Is it possible to save current workspace of QGIS for offline usage like in mapinfo? My workspace has link to database. and when I reopen workspace unlink in mapinfo it can't open it.