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

Convert Sql Server Spatial data to GeoJSON & plot on map

I have a sql server table with Geo spatial data. An example of row would be (with Column names): type: streetline code: 231001 geog: 0xE6100000011 ........ Centroid 0xE61000000C....... geom: ...
0
votes
1answer
102 views

Export data from .mxd file to ms sql database

I am using ArcGIS product (v.10.1). I have also tempalte of Maps from ArcGIS. But i need to get data from maps (.mxd files) to store it into MS SQL database. Explanation: I have application that has ...
1
vote
0answers
196 views

How can we generate GeoJSON from SQL data with latlong

Is there any way we can create GeoJSON from SQL server table with Latitude & Longitude Data?
3
votes
4answers
155 views

How to assign geometry to records in a table that contain an ID of a geometry point?

We are looking to map out 'incidents' at schools, but the incident table, which contains a few thousand records, only has a school number (plus the incident data). The table format is an Excel ...
0
votes
1answer
100 views

Import non spatial data into SQL Server using ogr2ogr

I am trying to import a CSV files in to SQL Server 2012 using ogr2ogr. The spatial data imports without any problems, but I cannot work out why the non spatial tables fail. I can import the data using ...
0
votes
0answers
620 views

MSSQL Connection settings for QGIS

OK first lets get the blond elements out of the way- I'm not asking for how I connect to my actual database. What I'm asking for is an example or screen shot of the entries required when setting up a ...
0
votes
1answer
61 views

QGIS map tip / label showing a table

I have a MSSQQL Spatiatal layer with Point data (borehole locations, pointID) and a joint table lithology (soil info per borehole, pointID, depth from, depth to, constituent) Is there a way to use ...
1
vote
1answer
129 views

Routing in MS SQL 2012

I would like to perform routing in MS SQL 2012 similar to pgRouting. In pgRouting, I'd do the following steps to create a routable network: Create a database routing with template template_routing ...
0
votes
0answers
73 views

How to query if a set of polygons intersect another set of polygons

Is there a way to leverage .STIntersect to check if a set of polygons intersect another set of polygons? I have a MasterTable of polygons that represent all waterbodies in a florida County. These ...
1
vote
1answer
204 views

How to create polygon that goes over +/-180 (dateline) in ArcMap?

I want to create a polygon feature that will go through the dateline (180 long.) in ArcMap. I am using WGS_1984_Web_Mercator_Auxiliary_Sphere (WKID: 3857) for my data frame and my polygonal feature ...
3
votes
0answers
116 views

sql server spatial index performance

I have a table with around 2 million records in it. I create a spatial index, using the defaults other than the bounding box. I've been noticing that some queries are extremely fast, and some are ...
2
votes
1answer
136 views

how to transform DB stored EPSG data to Geography data type in sql server

I have a full, 3 GB, database in SQL Server stored with certain points stored in pure float values. The points are stored in EPSG 3765. I would prefer to have them saved in the Geograpy datatype. I ...
0
votes
2answers
73 views

Which GEO data format does this data represent

I am parsing GIS data from a ESRI webservice in which I get the data specified as the following in a JSON file "geometryType" : "esriGeometryPoint", "spatialReference" : { "wkid" : 102100 an ...
0
votes
0answers
29 views

ArcGIS Find task performance over SDE

We are having a problem in our Search feature for our app. We are using arcgis published REST services and SDE database. When we try to do our search manually using the REST url, it takes roughly 9 ...
1
vote
0answers
37 views

Is it possible to retrieve lost versioned data in SQL Server Management Studio?

One of my staff accidentally deleted a feature class she was creating in her version before I reconciled it. I have grabbed a back up of the database from yesterday in SQL Management Studio. Is ...
0
votes
0answers
77 views

How can I show both Base and Overlay layers in Layer Panel in GeoExt 2?

I have layer panel I load from Postgres using ajax call. This is the Store: Ext.define('GIS.store.Layers', { extend: 'Ext.data.TreeStore', autoLoad: false, model : 'GIS.model.Layers', ...
2
votes
0answers
68 views

Working with WKT data in XML File in SQL Server

Anyone have experience with importing XML files into SQL server 2008 or 2012 that have a WKT element that includes the geometry for each feature? I can get this to easily work using FME software but ...
3
votes
2answers
309 views

Load and display a layer using PYQGIS

I'm having a go at using pyqgis from within the QGIS python console to load a layer from SQL Server and display it. I feel like I'm part way there but I'm having a real issue getting the layer to ...
3
votes
2answers
77 views

Is transformation of spatial data lossy?

I have a shapefile that contains data of a country from the following Geographic Coordinate System ( GCS_North_American_1927 aka NAD27 ) contents from the shape file .prj: ...
0
votes
0answers
42 views

View for SDE Permissions for SQLServer

Does anyone know the correct tables and joins to write a view to see the permissions on objects in SDE? Here is what I had in 9.3 and it doesn't seem to work (ie., all Permissions are Edit b/c the ...
1
vote
0answers
33 views

Refreshing MSSQL Layer in QGIS

When working on a map in QGIS I will often set up a view in my SQL Server spatial database and create a MSSQL layer based on this. As part of my workflow I often make adjustments to the SQL view ...
3
votes
1answer
84 views

How to set up a QGIS project with SQL Server which can be opened on another computer?

I am using QGIS with SQL server 2008. I need to save project on one computer and then copy project to another 20 clients! After I save project and try to open it on another computer I am getting ...
0
votes
1answer
104 views

Get the vertices on a LineString either side of a point (Sql Server 2008)

I have a point that sits on top of a LineString, both Sql Geometry types. POINT('0.5 0.5') LINESTRING('0 0 NULL 1, 1 1 NULL 1') I want to find the vertices of the LineString that lie either side ...
1
vote
0answers
95 views

Using M 'Measure' value in SQL Server 2008

MS Sql Server 2008 geometry type supports adding Z and M values to geometry objects, including linestrings. However, I cannot find any way to make use of these values, since methods such as ...
0
votes
1answer
123 views

Create Ms-Access type queries in ArcMap [closed]

We have a dataset with a personal GDB (mdb) with several feature classes and an mxd tied to those features to create layers based on definition queries… Currently to QAQC our data we use MsAccess ...
1
vote
0answers
86 views

Find Nearby GPS Navigation Route

I am developing a car pooling website. For that, I have created the database which has the different route options selected by different user. These routes are saved in the Database as Geography ...
1
vote
0answers
222 views

ArcSDE Problems: Microsoft SQL Server 2008 R2 on Windows 2008 R2 Standard (64-Bit)

I´m trying to set up ArcSDE 10.2 on a Microsoft SQL Server 2008 R2 running on a Windows Server 2008 R2 Standard 64-Bit machine. I can create the database connection, but when I want to enable it for ...
1
vote
3answers
116 views

Sending and receiving gis data to map

I have a spatial database in Sql server and I am working in asp.net mvc. My project must show stored shape in web page that uses openlayers js and user must see and edit shapes and send the result to ...
0
votes
0answers
85 views

Publishing MSSQL spatial data as WFS with QGIS 2.0 results in empty layers

I am experiencing some very strange behaviour with a WFS layer served by QGIS Server through Apache, with data taken from an MSSQL table. There appears to be no problem at all getting the data into a ...
4
votes
1answer
527 views

call Sql Server stored procedure form arcpy

Is there a way to execute a SQL Server stored procedure with arcpy or Python and retrieve the results returned by the stored procedure? There is a very similar question posted on ArcGIS forum with ...
1
vote
1answer
78 views

MSSQL server 2008 dissolve sql query

I have a set of spatial objects in a MSSQL server 2008 R2 trying to dissolve adjoining objects where one of the attributes are equal. The table below is somewhat representative to my original table: ...
2
votes
1answer
60 views

How to use a SQL 2005 table as attribute data in QGIS

We have financial data in a SQL 2005 database which we would like to link to a cadastral shape file in QGIS. The idea is to be able to display up-to-date outstanding balances for each plot. How can we ...
3
votes
0answers
68 views

New SQL Monitor Showing Database Deadlocks, Should I be alarmed?

We recently installed a SQL Monitoring tool that is raising High Alerts for SQL Server Deadlocks on my SDE database at random times during the day. Using the information provided in the Alert I have ...
1
vote
1answer
193 views

Change coordinate system using SQL or Javascript

Is there any built in function in SQL Server 2008 R2 which can transform the cordinates from 102100 to 4269 coordinate system something equivalent to ST_Transform from postgres. If there is algorithm ...
3
votes
4answers
429 views

Esri File GDB multi-user edit through QGIS

I have an Esri File GDB with relationship classes. I would like to import this GDB in PostgreSQL or MSSQL to enable multi-user edit through QGIS (dufour) tool. What are the steps/procedures to ...
1
vote
1answer
60 views

Should large Basemaps be stored in DBMS via ArcSDE?

As I understand it, the SDE Geodatabase provides the technology for Multiuser databases, Versioning, replication and other Geodatabase functionality. In my organisation, this could be useful for ...
1
vote
0answers
59 views

How do I use ReorientObject() in an SQL Server 2012 UPDATE statement?

I'm trying to UPDATE a Geography field in an SQL Server 2012 database using the output of a web mapper. I got the dreaded "The specified input does not represent a valid geography instance because it ...
1
vote
1answer
398 views

How do I insert a geometry as WKT to SQL Server Spatial with PHP?

I have a web mapping application built on Bootleaf (Leaflet + Bootstrap). Using the leaflet Draw plugin the user can create a polygon on the map. I'd like to insert that polygon into a geometry ...
1
vote
0answers
141 views

ArcGIS Query Layer SQL Server Performance Issue

I'm experiencing a performance issue with ArcGIS Query Layer using non-sde Sql Server 2008 R2. Actually, I'm using a rather comprehensive view that pulls and joins data from multiple databases and ...
0
votes
0answers
47 views

Is there a way to force a featureclass to prevent the creation of non-simple shapes when using native geometry storage?

After spending a good chunk of the morning trying to figure out why a feature was displaying a circle when I was setting it as a rectangle polygon via SQL, I found the SDE_GEOMETRY table and some ...
0
votes
0answers
108 views

How do I set the timezone in GeoServer w/ Jetty on Windows?

GeoServer is set to the local server timezone, but I need to have it use UTC. I believe that to make this happen I need to set the Java's user.timezone variable. My understanding is that if ...
1
vote
0answers
89 views

Error When Generating INSERT Statements for Geometry Field SQL Server

I am populating a column of linestrings from a list of points in sql with which I use to create insert statements to populate an ID and a geometry field in a table. This creates a temporary dataset ...
2
votes
0answers
129 views

Issues importing feature class to SDE SQL Server 2012

I have received an error indicating there could be issues with my geometry when attempting to import a feature class into SDE. I ran the check geometry tool. No issues. I have removed all fields ...
1
vote
1answer
147 views

Not enough memory in the file group “Primary”: SDE Database error with MSSQL

I got this error message whilst trying to load data into a raster in ArcMap 10.0. Underlying DBMS error [Microsoft SQL Server Native Client 10.0: Eine neue Seite für die sde-Datenbank konnte nicht ...
4
votes
1answer
86 views

What is happening when I register a “Feature Class” with Geodatabase?

I'm registering a table w/ native geometry with the geodatabase and it is taking a long, long time. Actually I'm not sure if ArcCatalog is frozen or crashing. The table does have several million ...
5
votes
2answers
202 views

Is it possible to force uppercase in a geodatabase string field?

I have certain string fields in my geodatabase tables with which I would like to enforce an all-uppercase rule. These fields are ones that do not lend themselves to domains (such as address fields). ...
2
votes
1answer
95 views

Bug when viewing data from SQL Server in QGIS

I'm having an issue with viewing data in QGIS 2 based on a spatial query in SQL Server 2008 R2. The data appears to load, polygons appear and I can add thematic shading based on data. However when I ...
5
votes
1answer
1k views

QGIS and SQL Server Spatial Tables Performance

I'm trying to get a SQL Server 2008 R2 spatial database up and running to streamline the production of maps using QGIS. Currently I just have a handful of spatial tables (a postcode level point table ...
2
votes
1answer
344 views

Convert from Geometry to SDE Binary storage type in SDE database

We have been battling performance issues between SQL 2012 and ArcGIS 10.1. One of the most common solution is to convert to SDE Binary storage. We know that this storage type is not as dynamic as the ...
3
votes
1answer
370 views

Edit SQL Server table (not registered with geodatabase) with arcpy

I am trying to update some rows in a SQL Server database table (not registered with geodatabase) with arcpy.da.UpdateCursor. However, when running the deleteRow(), I get the error return without ...