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)

0
votes
1answer
132 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
92 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
274 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
142 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
91 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
667 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
99 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
67 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
71 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
216 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
493 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
62 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
72 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
525 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
149 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
50 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
135 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
108 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
145 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
185 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
89 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
224 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
103 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
2k 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
411 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
461 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 ...
0
votes
0answers
254 views

post instlacion ArcSde 10 "error creating Arcsde direct Connection (-9)

I installed SQL sever 2008'm doing the post installation used ArcSDE 10 these are the steps I am doing in post installation of ArcSDE 10 complete installation. SDE Schema. put the name of my ...
3
votes
1answer
385 views

Options for getting data from SQL Server into Leaflet app?

I have polygon data in SQL Server 2012 that I need to get onto a Leaflet application - we're not talking thousands of polygons, but simplified U.S. counties where only one state will be displayed at a ...
3
votes
1answer
146 views

Why does QGIS 2.0 and SQL Server say Data source name not found and no default driver specified?

I've just started using QGIS 2.0 after using 1.8 for sometime. However I'm having an issue getting a SQL Server connection, I'm using the same settings as as used in 1.8 but I keep gettting an error ...
0
votes
0answers
60 views

SQL Server query, simillar to Symmetrical Difference in ArcMap

i have two tables with geometry data in SQL Server. How can I get all geometry differences with spatial query? I tried: select k.geom.STSymDifference(r.geom).ToString() from table1 k, table2 r But ...
1
vote
0answers
168 views

How to add a MSSQL spatial layer using Python?

I'm having difficulty adding a MSSQL spatial data layer using Python. The database is password protected, and I can add the layer without any problems using the built in feature, but I can't make it ...
3
votes
1answer
246 views

Is there a method in SQL Server (2008 or 2012) that will return the equivalent of the Esri LabelPoint for geometry?

I'm looking for a method that is equivalent to the Esri LabelPoint for SQL Server Geometry (or fairly close). Does it exist by a different name? Or is there an after-market implementation? I found ...
1
vote
0answers
216 views

Not able to edit or draw new feature in databse geometry data [closed]

var DeleteFeature = OpenLayers.Class(OpenLayers.Control, { initialize: function(layer, options) { OpenLayers.Control.prototype.initialize.apply(this, ...
2
votes
0answers
300 views

ArcGIS 10.1 & SQL Server 2012

We currently updated to SQL Server 2012 and now we are encountering a slower performance when connecting to the geodatabase on SQL Server 2012. Here are the things that we tried to fix the issue: - ...
1
vote
0answers
477 views

Importing Census TIGER Shape Files to SQL Server 2012?

I've been doing my research on how to import shape files into Microsoft SQL Server 2012. and am still unable to figure out how to do it after hours of playing around with it. I'll document what I've ...
1
vote
1answer
66 views

Error in GUID fields using “Simple Data Loader”

I have a replicated table in my SQL Server (PE_AMB_ANP), that table has a field named "rowguid" (rowguid is auto generated) When I try yo load data, the field appear matched with 'none', but when the ...
0
votes
0answers
49 views

ArcGIS Full-Text search

I've set up Full-Text searching on a table in my SDE database (ms sql backend). I can perform the full-text commands from SQL queries, but it doesn't seem to work in ArcMap or any rest services. I ...
1
vote
1answer
352 views

Postgis functionalities in Microsoft SQL Server

I'm using Postgresql 8.4, Postgis 1.5 for My GIS works. Planning to change my Database to Microsoft SQL Server 2012. Can we use all the Postgis functionalities in Microsoft SQL Server 2012. Please ...
0
votes
1answer
84 views

Viewshed calculation using SQL

Can i calculate viewshed in MS-SQL server? Viewshed analysis is Raster operation. I have elevation value vector observation as point vectors. Are there any methods to calculate Viewshed (using ...
0
votes
0answers
336 views

STIntersects and STContains fails on parameter

I am new to GIS and using GIS in SQLServer, so apologies if this is a rudimentary question, but I cannot find the answer so far. I am trying to use STIntersects() or STContains to determine what ...
0
votes
1answer
45 views

Is there a way to force ArcCatalog to use a specific tessellation scheme for a SQL Server spatial index?

If I Recalculate a spatial index from ArcCatalog, the tessellation scheme is always set to "Geometry Grid". Even when the previous index was Geometry auto grid. ArcCatalog always changes it back. ...
7
votes
3answers
1k views

ArcGIS 10.2 Query Layer on SQL Server performance

I'm using a Query Layer on SQL Server in ArcMap. The Query Layer executes instantly in in SQL Server but but takes so long to draw in ArcMap that the system appears unresponsive for about 10 minutes ...
1
vote
1answer
228 views

How can I use a sub-query in where statement of a query in ArcGIS 10.2 Map service?

I'm migrating my ArcGIS map services from version 10.0 to 10.2. It uses ArcSDE to manage spatial data in a SQL Server database. I was able to create the map service and everything seems OK. However ...
0
votes
2answers
53 views

ShapeFile with Z Co-ordinates

I have 3 shapefiles, two of them wihtout the Z Co-ordinates elevation but 1 of them has a Z co-ordinate elevation. I can load two ShapeFiles into my SQL Server Database which does not have Z ...
1
vote
2answers
448 views

MSSQL Data Not Showing Up in QGIS

I started using QGIS a few weeks ago. I've been able to create some very nice maps with it. I've used the OpenLayers plugins to bring in different basemaps, I've brought in shapefiles and connected ...
0
votes
2answers
1k views

How to use Sharpmap to display spatial data from MS SQL Server 2008

Can anyone show me a step by step example on how to use Sharpmap to display MS SQL server spatial data using C# as the programming language? Please note I have exploit some of the example online but ...
6
votes
2answers
79 views

Define projection at the record level

Hopefully this isn't too dumb a question, but is it possible to define projection at the record level, instead of a whole layer or table? I want to create a "project" database for all the work my ...
4
votes
2answers
180 views

Can't open ArcCatalog Database Connection SQL database Tables with field names greater than 31 characters

I am using SQLEXPRESS as a test environment. My issue: I have a database connection in ArcCatalog to a SQL database. Some tables in the SQL database have field names greater than 31 characters and ...
4
votes
1answer
156 views

QGIS 2.0.1 linking table issue, MSSQL 2008 database

I'm trying to link tables in QGIS 2.0.1 and MSSQL 2008 database. I can link them but when I try to open the attribute table QGIS throws an error and shuts down creating a *.dmp file. I saw that ...
2
votes
1answer
267 views

How to Display Pie Chart when clicking on point feature in map?

I want to display pie charts from MS SQL Server database data. When I click on a point in the map, I wish to see a pie chart over the point. Can you please tell me how to implement such pie charts? ...