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)

9
votes
2answers
915 views

why do people use geometry to represent geography?

Historically I've mainly worked with simple latitude and longitude coordinates in a SQL Server. I stored them as a geography datatype in SQL Server, and rendered them on a variety of displays ...
2
votes
1answer
19 views

SQL Server equivelent to Arcmap Intersect for polygons?

I have three different sets of GEOMETRY Polygon datasets in SQL Server that completely overlap. I need to create a new dataset that has a polygon for each unique area of the three layers. So ...
0
votes
1answer
27 views

How to convert MapXtreme FeatureGeometry to something writable to sql server geometry type

I'm new in MapXtreme and I'm bit lost. I have polygon in MapXtreme 7.0 (in C#) saved as FeatureGeometry type. I need to save this in SqlServer 2008 as geometry type, but I don't have direct access to ...
2
votes
1answer
26 views

Moving geodatabase from SQL Server 2008 R2 Express to SQL Server 2012 Enterprise

I am able to successfully move an ArcSDE geodatabase from one SQL Server 2008 R2 Express to another SQL Server of the same version using the restore backup method. Now I tried to move it the same way ...
0
votes
0answers
46 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
vote
0answers
16 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
52 views

How To Bulk Export Shapefiles Into Microsoft SQL Server using QGIS or PostGIS

Hey all thanks so much in advance for your help I have been researching this issue for a while. I have found two popularly suggested ways to preform this task: ogr2ogr - just take a shapefile and use ...
1
vote
1answer
30 views

Geoserver WFS features query inaccurate using SQL Server Backend with spatial index

I´m using Geoserver to query features through WFS in an Web Application with Openlayers as client. The queried layer is using SQL Server as backend storage. When applying a spatial index to the ...
2
votes
1answer
53 views

Fastest strategy for proximity searches in SQL Server 2012

This is my very first question here, so bear with me! I'm implementing a back end for a mobile app which will have to do proximity searches to find nearby POIs (points os interest). I know it's a ...
2
votes
1answer
39 views

using arcpy to get all database names within a server?

I am trying to populate a folder with ArcSDE database connection files for all the databases within a server instance. I need to be able to do this for several of our servers. Although I know within ...
7
votes
2answers
222 views

Do I need ArcGIS for server to edit my MS SQL Server database?

Here is what I have: ArcGIS Desktop Advanced (10.2) & MS SQL Server 2008 R2 Here is my problem: I need to be able to connect to the ms sql server and import, export, create, and edit spatial ...
2
votes
0answers
25 views

Is there a way to eliminate duplicate 'point clusters' in SQL Server 2008 r2 spatial?

I am using the ST.Distance function to identify clusters of geometry data points. Each point has a unique reference number associated with it. I would like to eliminate duplicate clusters from the ...
0
votes
1answer
71 views

dealing with geometry that should be geography (bad coordinates)

I'm working on a project with a few publicly available datasets. One of them is from the USGS, it's their prediction of peak ground acceleration in 50 years. Here's a link, and here's what it looks ...
1
vote
1answer
16 views

Can adding of attribute table fields cause geoDB replica fail

We have a arcsde replica between 2 sql server geoDB, it is one way replica and our side is the child. Recently our scheduler to synchronize the replica failed. The parent side add fields in some ...
1
vote
0answers
19 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 ...
2
votes
1answer
49 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 ...
0
votes
0answers
40 views

Specifying which fields in SQL Server table are lat/longs using QGIS?

I have successfully connected my MSSQL DB to my project and I am trying to add a layer to represent the data in a table. I want to make a density map using the lat/longs that are stored in two fields ...
1
vote
1answer
93 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
0answers
24 views

split polyline at specific distance

I am working on a project that uses sql server for geometry datatype and arcgis server and asp.net website and entity framework for data access and arcgis javascript api for map viewer. I want to ...
1
vote
1answer
42 views

Replicate Geodatabase and append to main SDE database

I have my ArcSDE GDB on SQL Server 2005. This we are maintaining at our end at head office. Now we have installed ArcGIS editor license to regional offices. GIS technicians at regional offices can't ...
0
votes
0answers
51 views

How to convert multipolygons to a single polygon

I have converted a set of gps points to polygon and then using .makevalid() I saved them in sql server.But It converted them to multypolygons.Is there any way to fix this problem and convert them to ...
1
vote
1answer
69 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 ...
4
votes
2answers
88 views

What is the significance of the SDE lineage length?

ORA-55378 left a great answer to my question: Does a high number of SDE_state_lineages slow performance? But, I realized I don't really understand what lineage length means and how it affects ...
2
votes
1answer
144 views

Converting set of points to polygon using C#?

I want to convert a set of gps ponints to polygon.I used a simple loop to convert it to a WKT and than used makevalid() in sql server and save it in a gemetry column in databasae.Is this way right?or ...
1
vote
1answer
51 views

StArea() in sqlserver is in which unit?

I have a problem with saving STArea in sqlserver. Here is a query where I get the area of a polygon: select Geometry::STGeomFromText('POLYGON ((51.3386535086000000 31.7951253522000000, ...
1
vote
1answer
33 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 ...
1
vote
0answers
20 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
27 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 ...
2
votes
2answers
109 views

Getting coordinates of shortest distance between point and line MS SQL 2008

I have a table of point data (POINTS) in a SQL Server 2008 database table (No ShortestLineTo Function!). Each one has a SpatialPoint field of type geography (4326). I have another table of line data ...
1
vote
1answer
45 views

Cannot Register Database

I want to publish a database to ArcGIS Server. When I try and register the database, I get this error: Can anyone help me? I am using ArcGIS Server and Desktop 10.2 with Microsoft SQL Server 2008. ...
1
vote
1answer
35 views

Start session edit on a specific layer on the map?

I created a GIS using ArcObjects, my application needs to be connected with a geodatabase stored in SQL Server. I used ARCSDE to connect my application to the database and when the database is ...
2
votes
1answer
71 views

ArcSDE performance and table changes on upgrade from 9.3 to 10.1?

I'm using ArcSDE 9.3 and SQL Server 2008 R2 and I want to migrate from ArcSDE 9.3 to ArcSDE 10.1. Is there any performance differences between ArcSDE 10.1 and ArcSDE 9.3 ? Is there any change ...
0
votes
0answers
62 views

Convert series of WKT to Shapefile

I have seen am ability in SQL Server 2008 Spatial Tools here that saves result of query as shapefile..I am intrested in how to do this task using C#..Is there any way to do this?I found ways to ...
1
vote
1answer
32 views

Recommended approach to integrate GeoNetwork with SQL Server database

I am new to GeoNetwork. But now my organization wants to invest in it to see how we can make the best use of it for publishing, sharing and distributing metadata. We currently have all our GIS data ...
4
votes
1answer
120 views

arcpy - ascii encoding error when updating field content in SQL Server table

I know there are plenty of posts and blog explanations about unicode errors, but I still can't figure out to handle it in my particular case. So here is my problem: I am writing a Python script to ...
5
votes
0answers
48 views

editor tracking updated in attribute table, but not in sql server database

When I enable editor tracking and make modification on an object, I can find the edit user and edit time, but I cannot find the data updated in the sql server database. Is it because of the ...
4
votes
2answers
125 views

How to set up an ArcMap Relate with a table from MS SQL Server 2012

This is my first time working with data directly from MS SQL Server 2012, and I'm unsure whether I can use it in a Relate in ArcMap. I have a table in MS SQL Server, which I brought into ArcMap via ...
-1
votes
1answer
59 views

Create gdb file from Sql-Server Views using ArcObject in .Net

I am able to Create blank .gdb file using arcObjects in .net. e.g for Create blank gdb file i have wrriten this code. public IWorkspace CreateFileGdbWorkspace() { IWorkspaceFactory ...
2
votes
1answer
54 views

Filtering MSSQL layers in QGIS doesnt work

In my QGIS Plugin I am filtering layers with this Python code: FeatureIterator = layer.getFeatures( QgsFeatureRequest().setFilterExpression ("Fieldname='SomeValue'") ) for feature in FeatureIterator ...
2
votes
0answers
50 views

How to populate the geometry_columns table

I have a SQL Server table of vector data (containing latitude, longitude, UComp and VComp columns), that I am trying to add as a layer to QGIS. Here is a sample of the data in the SQL Server data ...
1
vote
1answer
26 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? ...
0
votes
1answer
123 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
41 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 ...
2
votes
0answers
71 views

Import GML data in SQL Server Spatial

I have GML file with Application Schema whose data I need to import into SQL Server Spatial. I have been creted database structure with all thing that I need in database, and now I need to fill it ...
4
votes
1answer
84 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
47 views

How to create a model which executes a SQL stored procedure with user-provided parameters?

How can I create an ArcToolbox that executes a SQL stored procedure and asks the user for two inputs? As it stands now, I have to log in to my SQL server and run an execute statement for the stored ...
1
vote
1answer
112 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 ...
1
vote
1answer
73 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[ ...
0
votes
0answers
65 views

How to convert data type from float to integer in QGIS?

Currently I am working on importing data from MSSQL to Qgis 2.4. In imported database table attributes are shown in the format of integer ( in attribute table it showing like 48.23 and 16.20 in ...
1
vote
0answers
19 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 ...