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

How to create an SQL Persisted Computed Column which values are derived from spatial column

Our GDB is using the SQL native GEOMETRY data storage type (SQL 2012 Standard) and the spatial reference for this uses a unit of square feet. I want to create a (persisted) computed column which will ...
2
votes
0answers
22 views

Save edits before disconnecting users from enterprise geodatabase?

Is there any method that enables the Administrator to save the users edits before disconnecting them for an enterprise geodatabase. Because I am disconnecting users as shown in the screenshot, but ...
2
votes
0answers
14 views

SQL Server, Given a linestring with M value, what is the location of this other M value

We are investigating migrating a prototype into SQL Server (azure). We have LineStrings that also have M values. What we would like to do is given another M value find out what its geographical ...
5
votes
2answers
578 views

Load and display a layer from SQL Server 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 ...
0
votes
1answer
21 views

Coordinates from a SQL Server Inserts don't Show Results

I am trying to parse a JSON output file from an .Mxd file. All work fine and the following SQL Insert in SSMS using sample coordinates: delete from RoomData insert into RoomData ...
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 ...
0
votes
1answer
366 views

SQL Geometry Query similar to Select by Centroid

Does anyone know if it's possible to query SQL geometry by something like 'centroid of polygon'...similar to ArcMap's select by location? I'm using SQL Server 2008 R2 as the DBMS. I have two polygon ...
2
votes
1answer
21 views

Populate X and Y fields in SDE Point Data Using SQL trigger

Here is my situation. I am running ESRI ArcGIS Server and Desktop 10.2 on SQL Server 2008 R2. I would like to populate the Latitude and Longitude fields from point data (Signs data collected using ...
0
votes
0answers
21 views

C#, SQL Server Spatial Functions: Convert Polygon's Lat Long ESRI Polygon Values?

I have a C# program which parses a .kml file and reads polygonal Shape field's data and then does sql inserts to a SQL Server database. The value of the final_coords variable in code below is: ...
3
votes
2answers
1k views

Can I fix 'qodbc3:unable to execute statement' when querying SQL Server 2008?

I was testing features of QGIS and its really cool.I tried to query each table using right click and query but I can't query sql server 2008 database : Error: An error occured when executing the ...
7
votes
1answer
567 views

Geoserver with SQL server consuming all my CPU

This question is long please bear me and my problem. SQL Server Query profiler The Sample Query from profiler that geoserver is running that corresponds to SLD I am using and not the SQL SERVER view I ...
2
votes
0answers
31 views

Shoehorning hierarchial data into ArcSDE for MS SQL Server?

I've been tasked with creating a set of tables to store hierarchical data within an ArcSDE. This is in reference to utility data, i.e, a set of valves, control panels, actuators, etc (each ...
0
votes
1answer
35 views

Adding multiple users to an enterprise database in one go

I couldn’t figure out how to add multiple users to an Enterprise database in one go. Please consider the following situation: 1 ) I have an enterprise database named “ Test02” 2) Then I try to ...
0
votes
1answer
299 views

Not able to register spatial view with sde

I am using 10.2 ArcGIS and SOL Server 2008 R2. I have created a cross database spatial view in sql server using following syntax: USE [pipelines] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON ...
4
votes
8answers
1k views

Any Good Map Rendering Engines for SqlGeometry/SqlGeography

Can anyone suggest good map rendering engines for MS SQL Server Spatial types (SqlGeometry/SqlGeography)? By rendering, I mean plot the geometries to a common image format such as png or jpeg with ...
1
vote
2answers
31 views

Converting OSGB easting and northing to geometry on the fly in SQL Server 2008 R2

I have a table in a database that contains an easting and a northing for broadband relay stations. I am trying to create a view in SQL Server 2008 R2 that I can use in QGIS and I want to create a ...
1
vote
0answers
19 views

SQL Error: Latitude values must be between -90 and 90 degrees

I'm more of an ArcGIS user than a SQL Server user but I have polygon data in a 'geography' type in SQL 2008 R2. For a couple of these poly layers, I get this persistent drawing error in ArcMap: ...
2
votes
2answers
239 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?
0
votes
1answer
161 views

Can't create new geodatabase for SQLServer Express in ArcCatalog 10.0

I'm trying to create a new geodatabase in my local SQLExpress Database Server from ArcCatalog 10.0 (ArcInfo). I can create a database server entry just fine (image below): ESRI documentation has me ...
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 ...
1
vote
1answer
17 views

Is there any way to know if a polygon is part of another bigger polygon(s) in SQL server?

Basicaly, what I am trying to do is we have a lot of geographical containers like territories, sub-territories etc. and the boundaries of each keep on changing all the times and I have to store the ...
2
votes
1answer
114 views

Create Auto-Incremented Field within SDE Feature Class (SQL Server)

Has anyone implemented a way of creating an auto-incremented integer field within an ArcSDE (SQL Server 2008 R2) feature class / table and if so, would be willing to give a little guidance on how to ...
1
vote
1answer
260 views

ArcGIS 10.1 SDE database schema other than SDE or DBO

Just wondering if it's possible to apply a schema other than SDE or DBO to SDE feature or raster tables stored in an enterprise database on MS SQL Server 2008 R2. I have got a new customise schema ...
2
votes
1answer
346 views

Why does a geoprocessing service fail every other time it is run?

I have a ArcGIS Server 10 geoprocessing service right now that takes in a string and runs a parameterized query to SQL Server 2008R2 through pyodbc. The service works, but only every other time. I can ...
1
vote
2answers
42 views

Order sql server spatial geometry distance by the nearest

I have a geometry column in a table, I want to get the N nearest neighbours; here is a specific example with the geography type DECLARE @PTO Geography = Geography::STPointFromText('POINT(-57.432546 ...
0
votes
1answer
202 views

How to edit feature in sqlserver geodatabase

I am using arcmap 10.2.1 and arcobject 10.2.1,I just want to conncet to a geodatabase and edit,add,delete a feature from a feature class using arcobject,I tried to connect to database and it works ...
1
vote
1answer
640 views

Plotting Multiple Points on Google Map using VB.net

I am creating a database application using VB.net and MSSQL 2012. I have retrieved a list of customer from the database and want to plot them on google map. At it stands, I can only plot the first ...
2
votes
1answer
369 views

SQL Server UNion of geography feature returns FULLGLOBE result?

I have some trouble with sql server 2012. I store coordinates of french cities in my database as geography object (with ESRI 4326) and i want to make the UNION of some cities. I have in result ...
0
votes
0answers
26 views

Windows 8.1, surveysegments, system.data problem

I Have a c# project written back in 2009, trying to bring into the windows store universal app (windows 8.1 VS 2013, c#). The old project has references to Microsoft.sql.server.types ...
0
votes
1answer
14 views

Locking fields in ArcGIS to maintain integrity of last_edited_user field

I have a Collector for ArcGIS application which records the last_edited_user from the field, however post-processing needs to occur and overwrites my users from the field to my desktop user. Is there ...
1
vote
0answers
11 views

Using REST Services acquiring limited data from DataBase like LayerDefinition

I am working with ArcGIS Server 10.2 and MS SQL DB. I have a requirement in which i need to retrieve limited data using a query from a bulk data using the same Map Service REST URL which can give me ...
1
vote
1answer
38 views

Using CURRENT_DATE function on ArcSDE SQL Server Database?

I am writing a script to access data from each day. I would like to select by attribute and send these features to a local file geodatabase. After reading some documenation, CURRENT_DATE is the ...
2
votes
2answers
80 views

How to use SQL Server Spatial without ArcSDE

At work we are using ArcGIS 10.1 for fairly simple spatial data. We don't use the more advanced items such as topology that are available in Arc. We have a couple SQL Server databases for other ...
1
vote
1answer
190 views

Union of several linestring to multilinestring using MS SQL Server

Followed Postgreql query is the existing one used to combine serveral linestring to a single multilinestring. is there any equivalent of this in SQLServer . SELECT ST_AsText(ST_Collect( ARRAY[ ...
2
votes
1answer
567 views

SQL Server 2008 Distance and Performance Problem

I had been working on PostGIS to do some geographic processes and due to some reasons, I had to start to use SQL Server 2008. I ported same code for SQL Server but performance is almost dying when I ...
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. ...
0
votes
2answers
50 views

ArcSDE Locks With No Owner

Running enterprise SDE on Sql Server 2008, ArcGIS 10.1, SP1. The issue is old locks on all feature classes within a specific feature dataset that aren't being released. When viewed with an admin ...
0
votes
1answer
1k 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 ...
1
vote
1answer
252 views

How to store AutoCAD data in ArcSDE database?

Does anyone have an idea how i can create a database instance on my ArcSDE geodatabase to store my .dwg files? I have over 1 million of these files and would be happy to automatically extract and ...
0
votes
0answers
48 views

API for Java and JavaScript app integration

Are there any APIs to make calls or integrate JavaScript functions to a Java written application? I have come across Rhino's liveconnect.js, but this is uncharted territory for me, and would like a ...
1
vote
1answer
58 views

FME Data Tranform and Concatenate Tables in DB without Key from Access to SQL

I have been able to do a conversion (in FME2013) from an Access DB to a SQL Express DB(in Desktop Workbench), adding some transformers to grab data from three of the tables, two of which have primary ...
2
votes
1answer
104 views

Broken MSSQL provider in recent QGIS versions - has anyone experienced this?

I recently moved from QGIS 2.2 to 2.4.0 and in the process the MSSQL spatial data provider appears to have stopped working properly (behaviour is also the same with 2.5.0). QGIS will still connect ...
1
vote
2answers
747 views

Why do I get wrong length using STLength on MultiLineString?

I have 2 MultiLineString representing the a route (first is driving there and the second is the return way) . MULTILINESTRING ((34.787315938035292 31.318235314177119, 34.788431415005249 ...
2
votes
1answer
60 views

Edit default version table view using SQL Server

I have a ArcSDE (10.3) geodatabase setup which is versioned as we have a few people working concurrently on the data. However, I want to run some background scripts in SQL Server to update the default ...
4
votes
1answer
163 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 ...
5
votes
1answer
416 views

Is it possible that a good spatial index just cannot be made?

I have about 6 million rows with geography spatial features - they are all 1000 meter radius hexagons all over the US. There are a couple hundred thousand that would have been NULL, which I updated ...
1
vote
0answers
51 views

from shape files to a database [closed]

I've previously converted simple shape files to WKT so that I can store them in RDMS that has spatial capabilities. I'm a new user to QGIS, which I'm using to browse a shape file. But now I have a ...
2
votes
1answer
206 views

How to perform SQL query using .STContains in MS SQL Server

I have a table that stores polygons and a table that stores points with a value field. Both sets of data are stored using the Geometry type in MS SQL Server. I have a simple requirement - I need to ...
0
votes
1answer
265 views

Geometry datatype to latitude /Longitude MS SQL Server

I need to convert Sql Server geometry datatype to latitude /Longitude I have just imported a shapefile to my table (geometry) This query does not work:- select geom.Lat as [Latitude], ...
-1
votes
2answers
241 views

How to learn ArcGIS Server? [closed]

I have SQL Server, ArcGIS Server Standard Enterprise 10.0 - and I am new to both. How can I learn to use it. I want to learn ArcSDE but i am unable to understand it. Is ArcSDE available with ArcGIS ...