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
0answers
382 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
0answers
548 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
0answers
481 views

OGR VRT MSSQL example

I'm trying to import vector data into SAGA GIS from a SQLExpress 2008 server. Firstly is this possible? I would have thought using an OGR VRT layer would have been the way to do it, I've attached a ...
1
vote
0answers
20 views

Which SQL Server spatial data type to use for UK data in SQL Server?

Which spatial data type should be used for UK data in SQL Server?, i.e. GEOMETRY or GEOGRAPHY? I'm aware of OS National Grid and my understanding is it's an X/Y coordinate system, covering from ...
1
vote
0answers
37 views

Can't specify OID field in arcpy.MakeQueryLayer_management

I manage a library of query layers and have recently had the need to apply the same update to a bunch of them at once. Seems the only way to do that in python is to create new ones and apply ...
1
vote
0answers
21 views

Asp.net or MsSql Create bbox of a point proportional to image height and width

Short question is how do I create bbox dimensions that is proportional to image height and width? I'm working on a asp.net webservice to generate a map using geoserver. The parameters I have are ...
1
vote
0answers
50 views

Best SRID for worldwide data in Microsoft Sql Server geometry field?

I'm using Microsoft Sql Server 2012 to store geographical data related to hydrometeorological stations which are scattered around the globe (point layers and multipolygon layers). My data is in WGS84 ...
1
vote
0answers
70 views

Some point features in feature class not displaying in ArcMap?

I am trying to display a point feature class, but a few features from the same data set are not displayed. Originally I have heaps of point features in a point feature class, which are well displayed ...
1
vote
0answers
40 views

While connecting MS SQL getting error “Data source name not found and no default driver specified QODBC3: Unable to connect”

I have used the following code for connecting the Microsoft SQL Server's database. but at the time of opening database connection it is throwing an error. Here is my code, from PyQt4.QtGui import * ...
1
vote
0answers
22 views

SQL Server aggregate function in ogr2ogr command

I would like to define create a GeoJSON bounding box using SQL Server's EnvelopeAggregate function, embedded in an ogr2ogr command. I have the following command: ogr2ogr -f GeoJSON envelope.json ...
1
vote
0answers
58 views

GDAL MSSQL with numeric table names

I have many SHP tables organised by year, for example 2015_xx_data.shp that I have loaded into a MS SQL Server database using OGR2OGR. I have also loaded them into MySQL for a comparison. There are no ...
1
vote
0answers
112 views

SQL Server Geometry draw rectangle around a line

I am VERY new to spatial data queries, so please bear with me. I have a LineString (geometry) in SQL Server and need to "draw" a rectangle around it, based on padding for the Width and the Height, ...
1
vote
0answers
38 views

ArcSDE post installation error?

I had a problem during post installation of ArcSDE for SQL server 2008, and this is the message : The ArcSDE Repository was unsecessfully completed. would you like to view this error? then when I ...
1
vote
0answers
162 views

What if 'geometry_columns' already exists in MSSQL Server Database?

When trying to load a .SHP into MSSQLSpatial using OGR2OGR, I get the following error: ERROR 1: Error initializing the metadata tables : [Microsoft][ODBC SQL Server Dr iver][SQL Server]There is ...
1
vote
0answers
117 views

QGIS Connection with MSSQL localdb not possible correctly

I installed MSSql Server Express with localDB. Everything looks ok. The connection with the LocalDB is nessesary and the tables and views are displayed in the QGIS MSSQL Dioalog. A primary key is ...
1
vote
0answers
129 views

Reverse geocoding from sql server

I have a lot long/lat data in MS SQL Server, i want to do reverse geocoding by using openstreetmaps or some other free web service, and on the end i want to display all of that in report builder, does ...
1
vote
0answers
43 views

sql server geometry find points intersection buffer

How do I find the point of intersection of buffer?
1
vote
0answers
32 views

GeoWebCache Speed SQL Server Store

How to increase GeoWebCache speed, Am using geoserver 2.7.2 for tile cache and data store creating from a SQL Server database it will take 1 day and above to complete cache and it terminated several ...
1
vote
0answers
45 views

Managing privileges for an ArcSDE database using SSMS

I am trying to mange users for my ArcSDE database via SSMS as opposed to tools in ArcGIS, to do this i want to set up two new user roles, data-viewer and data-editor, and then assign users to those ...
1
vote
0answers
166 views

qgis unable to connect to ms sql server using sql authentication

I am getting the following error when I try to set up a connection to a MS SQL Server database using sql server authentication. I did find a bug report from 2014, but that was apparently fixed and ...
1
vote
0answers
46 views

ArcGIS SQL Server - Using Windows Authentication

I want to use a domain level service account to manage my database connections. This account is added as a Windows authenticated account in SQL Server 2012 as a sysadmin. If I try to use this ...
1
vote
0answers
197 views

FME 2015.1.01 and SQL Server 2012 Native Client Issues

I'm having trouble connecting to a SQL Server 2008 database from FME 2015.1.01 on a computer with SQL Server Management Studio 2012, including SQL Server Native Client. Here's the error message: MS ...
1
vote
0answers
88 views

LOX table shows up instead of an address locator in SDE geodatabase on SQL server 2012

Tried to copy an address locator from a network share to an SDE database, that worked. Tried the same thing on another database and it shows up in the target geodatabase as an SDE table with LOX in ...
1
vote
0answers
38 views

In ArcSDE, SQL Studio Manager 2012, How to get pixel data using a point layer?

I was using 'where' and 'ST_Intersects' with polygon data to get values 'under' my point layer. Example: Select rd.[FORESTNAME] as Forest, Count(Distinct morel.[OBJECTID]) AS Observations From ...
1
vote
0answers
26 views

Can I do the sql server for find fnode and tnode?

Can I do the sql server for find fnode and tnode field?
1
vote
0answers
524 views

Setup ArcGIS 10.2.2 and SQL Server 2012

I installed on Oracle VM VirtualBox two Windows Server 2008 R2. • One with ArcGIS Server and ArcGIS Desktop 10.2.2 10.2.2 • The second SQL Server 2012 in Mixed Mode Because I'm not connected to ...
1
vote
0answers
35 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
0answers
24 views

what I do share data in sqlserver enterprise for server?

I want to create a web editing services using ArcGIS Server, but the following error occurs when I add an editor task and click on configure. "No Editable layers found". I am using Microsoft SQL ...
1
vote
0answers
266 views

Importing 2014 TIGER County Shape Files to 2012 SQL Server?

Last year, I figured out how to import TIGER Census Block shape files into 2012 SQL Server with no issues. I assumed I would use similar code to do the county shape files but I keep getting a few ...
1
vote
0answers
127 views

'OutofMemoryException' whilst data trasnfer

I have a process in which data is transferred from PGDB to SDE GDB, recently I have encountered error - 'OutofMemoryException' and the process stops. I have noticed this error while trying to transfer ...
1
vote
0answers
47 views

How to reduce MSSQL Logfile size?

First of all I am not a Database specialist. I am using MSSQL to store my SDE 9.3 Data which is served with AGS 10.0. I have Vector and raster data stored in the databases and have very little room ...
1
vote
0answers
50 views

Update enterprise database from shapefile data?

Where I work we recently moved our GIS data from GDB databases to an enterprise SQL database. We primarily use ArcGIS 10.2 to edit and maintain our internal data but we also receive ancillary data ...
1
vote
0answers
47 views

Preventing Export Layer by user via ArcObjects?

In my project, I am using a Geodatabase (SQL Server) to store feature classes. I want to prevent users (who do not have permission to access or edit) exporting layers into shapefile or other ...
1
vote
0answers
113 views

Query Data from an Event Table in ArcGIS (Linear Referencing)

My goal is to store a bunch of past present and future Events in a central place from different vehicles, query those tables on demand and display the result in ArcMap. Note that right now, my Route ...
1
vote
0answers
48 views

primary key in sql server uneditable in mapinfo attribute?

I trying create table relationship in sqlserver 2008 R2. Tables will have spatial table and non-spatial (tabular) . I having trouble while selecting varchar field as primary key, this field cannon be ...
1
vote
0answers
46 views

mapping and update data in database

We have two feature layers: layer A - drainage segment layer (along road outline) layer B - road centre line layer. In my SQL Server database I have a table storing the mapping information of ...
1
vote
0answers
146 views

Creating Irregular ellipses using SQL Spatial 2012 Geometry

I have stumbled across a problem in SQL Server 2012 - whereby I need to create different shape ellipses from the following data points: centre_x | centre_y | max_x | max_y | min_x | min_y I have ...
1
vote
0answers
88 views

Hindi character support in MS SQL 2012

I have spatial MS SQL 2012 and i need to store hindi characters in a column. I tried using nvarchar datatype but I'm getting only "Question marks(????)". Is it possible to store non-english ...
1
vote
0answers
349 views

Split polyline feature in sql server 2012

Please find the below attached image. I have one point(in blue color) and polyline(in black color). Using the below sql server 2012 comment i got the nearest path(in red color) between ...
1
vote
0answers
39 views

Error trying to create mssql layer in geoserver

with mssql 2008 and the latest geoserver with the mssql store plugin, I can create a dbo connection with a mssql database and list the tables. When I try to create a layer with one of the tables which ...
1
vote
0answers
112 views

SDE Performance issue with SQL Spatial labelled lines on one server

Here is an issue that has stumped ESRI and SQL Server experts alike. I ask it here just to get more people thinking about it. Exhibit A is this screencast. I have two servers: ROGIS: A dedicated ...
1
vote
0answers
99 views

SQL 2012 shortestlineto method

I am trying to find the nearest centerline segment to an address point. I was hoping that I would be able to use the ShortestLineTo method, but it is not working. I have tested with Microsoft's ...
1
vote
0answers
46 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 ...
1
vote
0answers
164 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
552 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
0answers
178 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
0answers
260 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 ...
1
vote
0answers
240 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 ...
1
vote
0answers
80 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
415 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 ...