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)

1
vote
1answer
932 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 ...
1
vote
0answers
18 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
1answer
410 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
403 views

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

I have a 3 GB database in SQL Server, with certain points stored in float values. The points are stored in EPSG 3765. I would prefer to have them saved in the Geography datatype. I can not store them ...
0
votes
1answer
49 views

Geodatabase disappears

I have an old ArcGIS 10.1 in my laptop. While I'm trying to create a geodatabase it gets created, but doesn't let me create new featureclass and/or feature dataset. I get the error:" failed to connect ...
1
vote
1answer
20 views

enable enterprise geodatabase error

I am trying to enable an enterprise database. I right click > enable and then navigate to our organizations keycode file. I get this error: Attribute Column Not found... (see screenshot) This ...
2
votes
1answer
165 views

Batch geocoding 1.5 million data points in SQL Server

I am currently attempting to batch geocode 1.5 million points that are stored in a sql database. The points are not very specific (ie only city, state points). I have used ArcGIS in the past but due ...
0
votes
1answer
10 views

How do you use ogrinfo with a SQL Server database?

How do you use ogrinfo with a SQL Server database? I've tracked down documentation on it at GDAL and it mentions ... datasource_name: The data source to open. May be a filename, directory or ...
1
vote
1answer
618 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
1k 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
3k 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 ...
0
votes
2answers
608 views

how to reproject data in EPSG:4326 to 3857 using SharpMapv0.9 for display on google maps

I have data stored in SQL Server 2012 in EPSG:4326. I need to display this data on a google map in 3857. but without an ST_Transform function, I cannot determine how to convert my data on the fly to ...
3
votes
1answer
483 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 ...
6
votes
2answers
1k 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?
1
vote
1answer
298 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 ...
3
votes
1answer
1k 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 ...
3
votes
1answer
56 views

Error when using arcpy.ArcSDESQLExecute() to connect to SQL Server - ArcGIS 10.4

I am able to connect to a MS SQL Server 2012 geodatabase with the arcpy.ArcSDESQLExecute() when using the .sde connection file pre-created in ArcGIS. I am not able to connect to a MS SQL Server 2012 ...
3
votes
2answers
2k 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 ...
0
votes
1answer
1k 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 ...
1
vote
1answer
184 views

Connect to remote Sqlserver using arcobject

I want to connect to a database assigned to a vps with an ip address.I used this string to connect to Database when it was on localhost. how I change it to connect to remote one? ...
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 ...
7
votes
1answer
1k views

Does a high number of SDE_state_lineages slow performance?

In our SDE database, the SDE_state_lineages table has around 200,000 records, the SDE_states has around 900, and our SDE_versions table has around 1,300 records. We've been having performance issues ...
1
vote
1answer
932 views

SQL Server to Google Maps

Does someone have a beginning to end example of how to take data from a SQL Server geography type field and pass it to the Google Maps API to display the shape on a map? The geography data I'm ...
2
votes
0answers
12 views

Why does QGIS try to create spatial tables when loading into MSSQL Server?

When trying to load a layer from the QGIS layers panel or browsers panel, errors pop up that either the 'spatial_ref_sys' table or 'geometry_columns' table exists: If these tables exist already, ...
1
vote
2answers
38 views

Can raster maps be stored in a SQL Server spatial database?

Can raster maps be stored in a SQL Server spatial database? And if so, how? ... I'm aware of VARBINARY and FILESTREAM for images, but can only see GEOMETRIC and GEOGRAPHY for vector data
3
votes
1answer
74 views

Delete table rows in non-spatial database using arcpy

Working on a python script that does a bit of spatial analysis on a few layers, a spatial join of those layers, and then pulls data from a couple of other tables and holds them all in an in_memory ...
4
votes
2answers
363 views

DBMS and ArcSDE Architecture for Large (Mostly Non-Spatial) Dataset

I have ~1000 fixed points representing data collection stations with multiple sensors, and a csv that is ~4.5GB of values in the format: id pointid sensor measdatetime measvalue 50345 500 ...
5
votes
1answer
45 views

Can ArcGis accept SQL field names with spaces?

Im working on an integration project that is providing data from our billing system to ArcGis. Field names can include spaces which are acceptable in SQL Server if enclosed in brackets eg: [Street ...
9
votes
4answers
3k views

Inserting points into SQL Server using pymssql?

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. ...
3
votes
0answers
47 views

Rename the output file ArcGIS

I am copying a tons of features from a file geodatabase to a database server. First I created an enterprise geodatabase connenction and after a database connection. In the first step I added a ...
2
votes
2answers
258 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: ...
4
votes
1answer
39 views

Change feature class from ESRI native geometry to SQL Server geography

Original question: I have found a lot of documentation on importing and using query layers from SQL Server into ArcCatalog/ArcMap/etc. However, when you change the projection of a feature class or use ...
0
votes
1answer
161 views

How to Transform Many Projections Into One With SQL Server

I know very little SQL Server, but am quite familiar with Arc and Python. The data I want to transform is point data which is in a single table [ID], [X] [Y], [COORDSYS]. There are 5 possible ...
-3
votes
1answer
463 views

Sending Shapefile to SQL Server 2012?

How can I send a shapefile to an SQL Server table? I have searched and found a tool called ShapetoSQL but I am developing a c# Windows application so I am looking for an Open Source solution.
4
votes
1answer
36 views

Auto-generated field in ArcSDE for end user

The objective: Create a process where a coworker can open an .MXD, start editing, add a feature to represent a complaint, then add records in a related table to represent an inspection. Along the way, ...
4
votes
4answers
10k views

Insert Geography data into SQL Server 2008

Can someone guide me to or give me an example on how would one go about insert/query Geography data in Sql Server 2008 ( Polygon with 4 points and Point in specific) using C# EF or Linq2Sql. I've ...
0
votes
0answers
45 views

Triangulation of Cell Towers using MSQL Server Spatial

I need to triangulate a GSM Device by using known cell towers locations and GSM readings. All Data is in a MS SQL Server as Geometry Types. herewith an example of the data : here is also a SQL ...
2
votes
1answer
845 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 ...
0
votes
1answer
18 views

WMS of Geoserver SQL view shows nothing, however WFS works properly [closed]

I am using Geoserver to create a WMS service to serve data out of an SQL Server database. Everything works fine (WMS & WFS) untill I create an SQLView in Geoserver. The SQLView: SELECT * FROM ...
8
votes
0answers
119 views

Given two lat/longs, how can I tell if they are within 1 mile of each other?

I'm trying to implement a very efficient check to see whether two points are within a mile of each other, or not. My current approach is to compute the Haversine distance, and then check to see if ...
4
votes
0answers
35 views

Are there any MSSQL Licencing restrictions regarding ArcGIS Server Services

I use ArcGIS Server in conjuction with MSSQL Server 2012. According to my Database Administrator there could be licencing restrictions on the side of MSSQL when publishing Data over the web with ...
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 ...
0
votes
0answers
66 views

How to load points in a SQL server polygon table?

I have a spatial table in SQL server which stores both points and polygons geometry and I am using the table to return geoJSON for API calls. I want to load some points to this table with shapetype ...
0
votes
1answer
48 views

How to find Nearest point on line from a point cordinate in SQL server

I want to find out the nearest point on my road network which is a multiline string from a point with lat lon value. The below code I have tried for finding buffer distance line from a point. ...
0
votes
1answer
1k views

Safely replacing ArcSDE feature classes using transactions in ArcObjects?

I am using C#, ArcGIS Server 10, MS-SQL Server 2008, and I want to replace an ArcGIS SDE feature class inside of a transaction. After the deletion of the feature class, I have to create a new one with ...
1
vote
1answer
1k views

ArcGIS Server 10 and SQL Server 2008 R2 permissions and feature services

I have ArcGIS Server 10 with SP1 and SP2 on windows server 2008 and ArcSDE (from an edn liscense) installed on top of MS SQL Server 2008. When I make a spatial db connection in ArcCatalog (direct ...
0
votes
5answers
69 views

PDF Plotting from ArcGIS for Desktop?

I am experiencing a very annoying phenomenon at the moment when trying to plot an A0 PDF Plot and would be interested to hear if anyone has had a similar problem and whether there is a solution or ...
3
votes
2answers
2k views

Can spatial data in Oracle be imported into SQL server?

Oracle supports spatial data and so does SQL Server. What are the things to consider if we have to migrate spatial data from Oracle to SQL Server? Are there any features in Oracle that are not there ...
2
votes
0answers
30 views

How to properly deal with rectangles being curved on geographies?

I'm using Microsoft SQL Server to store simple data for administrative boundaries of the world (lots of polygons). I store this in a geography data type column. Afterwards I query these polygons by a ...
2
votes
2answers
73 views

Labeling MSSQL-Layer in QGIS 2.14

I am using QGIS 2.14 and have problems with labeling a layer. My layer is a MSSQL-Layer (from a GIS-Server) and the fieldtype I am using for labeling is a Sting (typename is nvarchar).If the string ...