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
0answers
137 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
20 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
66 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
51 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
37 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
34 views

Refreshing MSSQL Layer in QGIS

When working on a map in QGIS I will often set up a view in my SQL Server spatial database and create a MSSQL layer based on this. As part of my workflow I often make adjustments to the SQL view ...
1
vote
0answers
124 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 ...
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
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
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 ...
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 ...
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 ...
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
0answers
76 views

QGis 2.01 Fedora 19 vs Windows SQL-Server Access

i just installed QGis 2.01 on Ubuntu / Fedora 19 / windows 8, configured ODBC-support for Fedora 19 and created ODBC-DSNs on the windows machine and the Fedora machine to the same SQL-Server 2012 ...
1
vote
0answers
391 views

How to connect to MSSQL-Server using Geoserver?

I have Geoserver on Ubuntu 13.04. On another machine I have MS SQL-Server 2008 R2. Now I want to connect it together. Google says that its possible to connect to SQL-Server from Ubuntu using ODBC ...
1
vote
0answers
555 views

Why can't QGIS connect to MS SQL Server?

All, Up until yesterday, QGIS connected to my SQL Server 2012 database no problem. However, yesterday I installed SQL Server Management Studio (SSMS), and the SQL Server Client tools, and now I get ...
1
vote
0answers
159 views

SQL Server geography.Intersects Yields Unexpected Results (arch shape)

I've coupled ESRI's ArcGIS with SQL Server 2008 R2 in an attempt to allow users to search for geographical points using a polygon (with ArcGIS' drawing toolbar). I've run up against an issue that's ...
1
vote
0answers
83 views

Why is my linestring not valid ? was recorded from GPX file

I have a linestring that was built from points from GPX file. I've insert it to sql as geometry and when I try to run funcs on it (like STStartPoint ) I get error that line isn't valid and I need to ...
1
vote
0answers
133 views

Polygon not a valid geography instance

I am trying to create and insert data from ESRI shape files. This is one of the many features in the shape file, you can copy paste it and try it yourself: DECLARE @g geography; SET @g = ...
1
vote
0answers
349 views

Connect QGIS to MSSQL view (i.e. not a table)

I've got a MSSQL view containing data I want to show in QGIS. The view transforms a BLOB field containing WKB that is in one of my tables into a SQL geometry, which QGIS will be able to display. ...
1
vote
0answers
54 views

SQL server 08 Limitations

The Soil SURvey GeOgraphic (SSURGO) database is a set of very large and complicated shapefiles. We want to load all of the shapefiles for the US into a national SQL database. Are there import ...
1
vote
0answers
103 views

Need to create custom map based the spatial Database

I need to create a custom map in .net 2008 c# webapplication based the spatial database(sqlserver 2008) without using any third party tools For example in sqlserver 2008 i am create a map using this ...
1
vote
0answers
223 views

One-way ArcGIS replication copying __ATTACH tables instead of base tables

I'm trying to get one-way replication working in ESRI ArcGIS 10. Here's a quick summary of the steps I followed: Open map in ArcMap with the relevant data layers I want to replicate Choose Create ...
1
vote
0answers
497 views

SQL sub query syntax does not work on versioned tables without base option- Modified

My original question asked why the where clause below, which includes a sub query, would not work on an SDE database but the same query against a file geodatabase would work. I had thought the ...
1
vote
0answers
370 views

Cannot join feature layer with SQL Server table with query built in it in ArcMap

I need to join a feature layer with a SQL Server View with a common field in ArcMap. The View was successfully added to ArcMap as data table with some query built on it from Query Builder. When I ...
1
vote
0answers
111 views

Acceptable Reduce() amounts for google maps zoom levels?

I'm using SQL Server Spatial to return large polygons to Google Maps for display. Given that google maps has a zoom scale of 1 - 20, I would like to reduce my polygons (reduce function uses the ...
1
vote
0answers
121 views

Making donut without updating id in MapInfo

I wont to make a donut out of an polygon in MapInfo. I store my data in Sql Server 2008 R2 and access it as a linked table. In SQL Server the Id-column is an Identity column that is used to as a ...
1
vote
0answers
702 views

Converting Lon Lat to UTM Zone 32N in C# with SQLSpatialTools

I have a set of coordinates; Lon 9.42221521, Lat 56.44978001 and I want to convert them to UTM Zone 32N coordinates. I found the SQLSpatialTools library to do the conversion but I need some help. When ...
1
vote
0answers
336 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 ...
1
vote
0answers
296 views

T-SQL with SDE and Web Map ArcGIS Server 10 MSSQL 2008

I need to build a system whereby the user of a web map (the standard web map that ArcGIS Server Manager builds) can edit a feature class's attributes. The attribute will be a 'Comments' field. The ...
0
votes
0answers
14 views

SQL Server ShortestLineTo doesn't return an intersecting line

I have a LineString describing a path, and a Point, which is not on the line. I am trying to find the closest point to my POI on the line. I figured I'd get the ShortestLineTo between the two objects, ...
0
votes
0answers
28 views

SQL Server : find Intersecting geometries with a geometry using sql query

I asked this question on parallel site (h++p://stackoverflow.com)and think this is a better place to ask such questions I want to find all geometries in a table that intersects with spacial geometry ...
0
votes
0answers
23 views

How to convert geometric point to geographic point in SQL Server?

I am new to sql geometric and geographic types What I need is a way to convert a sql table of geometric points into geographic points?
0
votes
0answers
24 views

how to connect with MS sql server 2014 with Geo server 2.6

I am working with MS Sq l server 2014 and want to developed a web based application with Geo server 2.6 .............i am not able to see the MS Sq l server option in Data->Store please provide ...
0
votes
0answers
68 views

Error while connecting to Sql server Data Base

i use opengeo suite 4.1.1 with geoserver 2.5-snapshot i downloaded sql server server extension , i install it with both microsoft jdbc while connecting to sql server i recived this error Error ...
0
votes
0answers
21 views

ArcGIS Explorer “Play Time Animation” button missing

I've connected ArcGIS Explorer 2.0.0.2500 to my SQL Server data and the points come up on the map just fine (well, super slowly, but they come up). I have a datetime column in the table that has the ...
0
votes
0answers
43 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 ...
0
votes
0answers
97 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 ...
0
votes
0answers
82 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 ...
0
votes
0answers
91 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 ...
0
votes
0answers
13 views

Convert Surface to MultiSurface in SQL Server

I need to create view where geometry column is MultiSurface datatype. But, column in my table is Surface datatype. Is there any chance how to convert single Surface column to MultiSurface column ...
0
votes
0answers
96 views

How to improve performance using spatial indexing with STIntersects()

I am working on Spatial database. I need to check intersection of state geometry with geometry inside database. I am presently using the query as SELECT a.ID, a.OBJECTID, a.MSID, ...
0
votes
0answers
35 views

Query's “Get Unique Values” includes case variants that don't exist in attribute table

I ran a query on an ArcSDE 10.2 Feature Class to find features that do not follow our office's standard of being in uppercase. The "Get Unique Values" seems to return values that do not exist in the ...
0
votes
0answers
28 views

Select polylines that are having mutual points from another table with condition

I am struggling with this MapInfo SQL (or T-SQL) query too long so I need little help :) I have two tables: PIPES with polylines CHECK_NODES with points that represents starting and ending points ...
0
votes
0answers
55 views

Error post installation ArcSDE for SQL server 2008

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

SQL Server 2012 spatial check constraints disabled after migration from 2008

Currently we are using SQL Server 2008 geometry datatyped columns in our databases. These are registered with ESRIs enterprise geodatabase repository, so every spatial table has a check constraint ...
0
votes
0answers
176 views

Export GeoJSON to MSSQL with UTF-8 encoding

I'm testing this command to migrate GeoJSON data to MSSQL table: ogr2ogr -f MSSQLSpatial "MSSQL:server=.\SQLEXPRESS;database=geodb;trusted_connection=yes" test.json -nln test It works beautifully, ...
0
votes
0answers
57 views

Communication between widgets (flex)

Default Communication between widgets hi, i'm new in flex, and im working on Webmapping application using flex 4.6, java, and sql server as database, i'm just trying to make a communication between ...
0
votes
0answers
59 views

Shortest path between two points in multilinestring

I have a table which contain information about edges of the graph in form of geometry linestring. I combine those linestrings into one shape, and the result is multilinestring SELECT ...