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
107 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
191 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 ...
1
vote
0answers
248 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
0answers
303 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
53 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
98 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
198 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
417 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
314 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
102 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
115 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
595 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
318 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
285 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
6 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
44 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
30 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
16 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
31 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
17 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
57 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
30 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
33 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 ...
0
votes
0answers
52 views

Using Geometry commands in MS SQL Server 2008

I am looking to find the most effect way to use SDE and ST_Geometry SQL commands. Can anyone tell me how/what commands I might use to perform a spatial query in MS Sql Server 2008, to Select property ...
0
votes
0answers
55 views

Geoserver SQL View layer not displaying on map

I am trying to create a SQL View in GeoServer from my SQL Server 2008 R2 data store. It is a very basic query: SELECT [Id] ,[Location] FROM [schema_name].[table_name] I set the Id column, ...
0
votes
0answers
55 views

How to store esri geometry types in sql server

I have a txt file containing some data of polylines. Actually it is saved json objects. The features in it are esriPolyLine objects. Now i want to store it in my sql server db as geography data types ...
0
votes
0answers
229 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 ...
0
votes
0answers
48 views

How to query if a set of polygons intersect another set of polygons

Is there a way to leverage .STIntersect to check if a set of polygons intersect another set of polygons? I have a MasterTable of polygons that represent all waterbodies in a florida County. These ...
0
votes
0answers
26 views

ArcGIS Find task performance over SDE

We are having a problem in our Search feature for our app. We are using arcgis published REST services and SDE database. When we try to do our search manually using the REST url, it takes roughly 9 ...
0
votes
0answers
64 views

How can I show both Base and Overlay layers in Layer Panel in GeoExt 2?

I have layer panel I load from Postgres using ajax call. This is the Store: Ext.define('GIS.store.Layers', { extend: 'Ext.data.TreeStore', autoLoad: false, model : 'GIS.model.Layers', ...
0
votes
0answers
38 views

View for SDE Permissions for SQLServer

Does anyone know the correct tables and joins to write a view to see the permissions on objects in SDE? Here is what I had in 9.3 and it doesn't seem to work (ie., all Permissions are Edit b/c the ...
0
votes
0answers
21 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 ...
0
votes
0answers
56 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 ...
0
votes
0answers
65 views

Publishing MSSQL spatial data as WFS with QGIS 2.0 results in empty layers

I am experiencing some very strange behaviour with a WFS layer served by QGIS Server through Apache, with data taken from an MSSQL table. There appears to be no problem at all getting the data into a ...
0
votes
0answers
32 views

Is there a way to force a featureclass to not allow non-simple shapes when using native geometry storage?

After spending a good chunk of the morning trying to figure out why a feature was displaying a circle when I was setting it as a rectangle polygon via SQL, I found the SDE_GEOMETRY table and some ...
0
votes
0answers
66 views

How do I set the timezone in GeoServer w/ Jetty on Windows?

GeoServer is set to the local server timezone, but I need to have it use UTC. I believe that to make this happen I need to set the Java's user.timezone variable. My understanding is that if ...
0
votes
0answers
179 views

post instlacion ArcSde 10 "error creating Arcsde direct Connection (-9)

I installed SQL sever 2008'm doing the post installation used ArcSDE 10 these are the steps I am doing in post installation of ArcSDE 10 complete installation. SDE Schema. put the name of my ...
0
votes
0answers
53 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 ...
0
votes
0answers
76 views

Create Feature to selected layer from database (MSSQL) in GXP

I want to do online editing,creating new feature for selected layer data from mssql, it is possible to create new feature in shape file, but not able to do in database data.I am using Opengeo ...
0
votes
0answers
34 views

ArcGIS Full-Text search

I've set up Full-Text searching on a table in my SDE database (ms sql backend). I can perform the full-text commands from SQL queries, but it doesn't seem to work in ArcMap or any rest services. I ...
0
votes
0answers
86 views

Methods to calculate Viewshed analysis

Does anyone know an algorithm to calculate Viewshed analysis? I calculated them in ArcGIS, MapInfo and SAGA GIS. I wish to calculate Viewshed analysis using algorithm or methods which I can use in ...
0
votes
0answers
183 views

STIntersects and STContains fails on parameter

I am new to GIS and using GIS in SQLServer, so apologies if this is a rudimentary question, but I cannot find the answer so far. I am trying to use STIntersects() or STContains to determine what ...
0
votes
0answers
59 views

What is this ArcSDE 10 for SQL server 2008 Enterprise sp2 64bit setup error?

I setup ArcSDE 10 for SQL Server 2008 Enterprise SP2 64 bit but error. I'm using: ArcSDE 10 for SQL server 64 bit; Sql Server 2008 Enterprise SP2 64 bit; Window Server 2008 Enterprise SP1 64 bit; ...
0
votes
0answers
40 views

Can I create a table showing all the Srid values for all the tables in my DB?

Hi I can identify the current SRID of one table (at a time) in my database, but I was wondering if there was a way to bring back a single table that would tell me all the datasets that do not ...
0
votes
0answers
80 views

QGIS: MSSQL spatial layer bug with estimated metadata

It looks like there is a bug when connecting to MSSQL databases to add a spatial layer when using estimated table parameters. Connecting one time works fine and all the spatial enabled tables are ...
0
votes
0answers
54 views

using Arcgis silverlight viewer, how to autoload a layer of Lat/Long points stored in MS SQL 2008

I use Arcmap to register a layer into ArcGIS server whose source data is spatial points stored in MS SQL 2008. Everything works fine until a new entry is added into the database table, it doesn't ...
0
votes
0answers
203 views

What does OGR “driver not loaded” mean when connecting to SQL Server through QGIS?

All, Using QGIS 1.8, SQL Server 2012, and OGR 1.9.2 (also fails on our SQL Server 2008 sandbox machine) When creating a connection in QGIS I'm getting the following errors: Ubuntu 12.04 Driver ...
0
votes
0answers
193 views

Upgraded ESRI .NET ADF application (9.3 to 10.1) intermittently missing service issue

I also asked this question on the ESRI forum but I'm not sure if anyone will see it through the tumbleweeds over there. I had an application based on the .NET Web ADF originally built in 9.3. The ...
0
votes
0answers
139 views

Openlayer seems slow when zooming / panning on vector (geometry line) from geojson. Why?

I have a layer with 7 lines . when I zoom on some of the lines , the maps seems to be very slow. I thought it might be because I bring a lot of points to the client (that represents the line) aa ...
0
votes
0answers
83 views

Is there a big (if any) performance difference between Geoserver SQL Layer and OpenLayers geojson Layer?

I have a table with multiline geography items in SQL Server 2008 (Routes). I want to show them on OL Google Map but I'm having trouble creating SQL Data source in geoserver (something related to ...