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
1answer
454 views

Detecting invalid WKT in text column in SQL Server

I've got a whole load of WKT data in a SQL Server table, of which I'm trying to detect the validity. I'm currently doing a query like this: UPDATE f SET f."CurrentGeomValid" = ...
0
votes
0answers
154 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 ...
2
votes
0answers
75 views

Polygons to Lines SQL Server 2008/2012

Given a polygon (no multipolygons, or holes) what is the best way to explode it into lines using T-SQL. The end results is I need a record for each line that makes up the polygon.
1
vote
0answers
519 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 ...
0
votes
1answer
1k views

Trying to convert geometry to geography keep failing in MSSQL 2012

In MSSQL I have LineString in Geometry type. When I try to convert it to geography using : ...
1
vote
0answers
146 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 ...
2
votes
0answers
353 views

Publish ESRI Feature Services from spatial view on ArcGIS Server 10.1

I have a feature class layer and a handful of non spatial plain tables in a 10.1 SDE geodatabase on MS SQL Server. What I want to achieve is to publish a feature service from ArcGIS Server so as for ...
1
vote
1answer
170 views

GeoServer using GeoWebcache and SQL Server whats the process?

I'm using GeoWebCache and GeoServer to tile cache a layer of data from a SQL Server database. If I seed the cache and I send a tiled WMS request what occurs? Does GeoServer make a call to SQL Server ...
1
vote
2answers
2k views

How do you create and use a SQL Server spatial view in ArcMap?

All, (using SQL Server 2012, ArcMap 10.1) I have created a SQL spatial statement to test out how a) the union function works, and b) how creating a view of this data will work with ArcGIS. a) the ...
1
vote
2answers
547 views

Why do I get wrong length using STLength on MultiLineString?

I have 2 MultiLineString representing the a route (first is driving there and the second is the return way) . MULTILINESTRING ((34.787315938035292 31.318235314177119, 34.788431415005249 ...
1
vote
0answers
78 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 ...
0
votes
0answers
90 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 ...
2
votes
1answer
421 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 ...
0
votes
3answers
98 views

database server connection to MSSQL Server with ArcCatalog not possible?

I have a MSSQL Server where my geodata is held. In the ArcGIS Docs, it says... "To administer ArcSDE geodatabases for SQL Server Express, you can also connect to these geodatabases by first making a ...
3
votes
3answers
294 views

ArcSDE command registration issues

I have an ArcSDE 10.0 enabled SQL Server 2008 R2 database on a development server. We are using TeamCity to run continual deployment to this development server, which runs through the following steps: ...
7
votes
2answers
857 views

How to use the ESRI JS API to map SQL Server Spatial Types without ArcGIS Server

I have heard of people using the ESRI Javascript API to create webmaps with spatial data from SQL Server or other RDBMS's. From what I can tell, they are not using ArcGIS Server as a middleware. In ...
0
votes
1answer
102 views

How can i generate parcel extracts on demand through a webservice

Ok, i need to generate parcel extract documents on demand. The backend is Arcgis 9.3.1 on SQL server 2008. I would like to build a webservice (C# .Net) on the server that generates these extracts. My ...
0
votes
1answer
197 views

Do any of the SQL Server 2008 R2 SP 2 cumulative updates contain the MAXDOP spatial index fix?

I am troubleshooting ArcGIS 10.1 performance issues with SQL Server 2008 R2 SP 2 (10.50.4000) and the issue appears to be this MAXDOP issue: ...
0
votes
1answer
160 views

geoserver problem to join sql-server table to a layer

i have a layer published on geoserver based on a connection to a postgres/postgis Table and i need to add another table existing on sql server to do a data jointure table to table in order to add ...
3
votes
5answers
321 views

Installing ArcGIS 10.1 on SQL Server 2008 R2 Cluster

We're running into some performance issues when accessing large enterprise geodatabases on a SQL Server 2008 R2 cluster. The database itself performs well and returns queries fine but presenting the ...
0
votes
1answer
36 views

layer from sqlserver database table

I'm new in ArcGIS. Is it possible to create a layer from a SqlServer table instead of a shapefile? in other words, is it possible to store layer data in a table in Sql Sever instead of a shapfile? ...
2
votes
0answers
199 views

Problem viewing SQL 2008 “Date” field

I am using ArcMap Basic 10.1 SP1 and I'm connected to a permitting database stored in a SQL Server 2008 R2 database. I am trying to pull the tabular data over into my ArcGIS Desktop Project so that I ...
1
vote
0answers
121 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 = ...
0
votes
0answers
23 views

Asp code for distance in SQL sever

I've looked around but I can't find the answer anywhere and im getting kinda frustrated now. I'm using sql server and what im trying to do is to find apartments within a 0.5km radious of a said ...
1
vote
1answer
347 views

How to insert features in a MS SQL based SDE without giving ObjectID s?

I'm trying to load features into ArcSDE without using ArcObjects, and using SQL from my .NET Application instead. I have followed the answers given in this question: Is it possible to load features ...
0
votes
1answer
200 views

Problem in filling table of ArcSDE feature class in SQL Server 2008?

I have an ArcSDE point feature class and I add it to ArcMap 10. After that I add some points to it and fill every field for all points in the attribute table and Save Editing. However, the SQL ...
0
votes
2answers
197 views

Need help in ArcGIS Desktop: Automate the task

I am using ArcGIS 10.1 desktop on Windows 7 and I want to run few task automatically. Scenario: I have plane table from sql server contains lat,lon information. I have added that table in Arc Map ...
1
vote
1answer
206 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 ...
3
votes
0answers
219 views

Geoserver WMST Date Format

There is table in SLQ-Server 2008 R2. In this table i have date column with date format like this 2006-09-08 14:39:41.000. Now i make View from this table on Geoserver side but do nothing wiht date ...
1
vote
1answer
389 views

Insert XY table data into SQL Spatial column

ArcGIS Server 10.1.1 SQL Server Standard 2012 Current workflow is user submits a table (text file) containing lat-long data (same spatial reference each time); SQL Server Integration services pushes ...
0
votes
2answers
199 views

How to learn ArcGIS Server? [closed]

I have SQL Server, ArcGIS Server Standard Enterprise 10.0 - and I am new to both. How can I learn to use it. I want to learn ArcSDE but i am unable to understand it. Is ArcSDE available with ArcGIS ...
2
votes
1answer
164 views

ArcExplorer - possible connect to a non-SDE database?

In ArcExplorer, I'm wondering if you can connect to a non-SDE database, like SQL Server, with geometry or geography columns?
1
vote
2answers
522 views

Plotting large numbers of objects on a chart using R and WKT format

I am retrieving thousands of geometry lines in WKT format from a Microsoft SQL Server database. I would like to plot all of those lines in one map, but I am having some difficulty with the code. How ...
2
votes
1answer
364 views

Reading OGC geometry data from SQL server using R

I would like to write a script in R that creates a map using OGC geometry data that is stored on a Microsoft SQL server. Is there a way to read OGC geometry data using a query passed from R? Maybe ...
5
votes
1answer
244 views

How to create polygons in ArcMap 10.0 using lat/long data from SQL Server 2008 database?

Forgive me if this is very basic, as I'm new to GIS work (though I've been a programmer for 10 years) and so I'm not really sure how to approach this, but here goes... Can I take a table with ...
3
votes
2answers
2k views

How to import ArcGIS 10.1 File geodatabase to MS SQL Server 2012?

I would like to import my File Geodatabase from ArcGIS 10.1 into MS SQL Server 2012. I have never done it before, so I expect to do the import the same way as import data from excel table. Problem ...
1
vote
1answer
137 views

How to share *.sql files between ArcGIS and MapInfo?

In Denmark many municipalities have the same provider of public data. These data are pushed to a local database – often a SQL Server. The DBMS layout is the same for all municipalities. When I create ...
4
votes
2answers
3k views

ArcGIS Server Error: “Feature service requires a registered database”

I'm attempting to publish a feature service to ArcGIS server. I'm running SQL Server Express and ArcSDE. When I try to publish the service I get the error "00090: Feature service requires a registered ...
9
votes
2answers
299 views

How do I perform a 3 parameter geotransformation and projection in Sql Server 2012?

I have a table with latitude longitude (NAD27) columns in it. I compute two other columns, X and Y, representing Web Mercator (WGS84) location. Currently I'm using a Arcmap to do this, by applying ...
2
votes
1answer
270 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 ...
2
votes
1answer
317 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 ...
0
votes
1answer
86 views

Unsupported WFS request in MapServer at Insert and Update

I'm created a WFS with MapServer (ms4w) and SQL Server DB. The wfs:GetFeature works fine. But I cann't get the wfs:insert/wfs:update to work, they return: <?xml version="1.0" ...
2
votes
1answer
1k views

Which one is better ?SQL server 2012 or Oracle 11g

I want to learn a database server, SQL server 2012 or Oracle 11g . I surf in the internet to compare SQL server and Oracle for spatial data and found good websites such as gisboston.it was very ...
2
votes
0answers
321 views

ArcMap runs custom script once and then it crashes on second run

So I made a script that takes data from an MSSQL database and inserts it into a featureclass. I added the script to a toolbox and am able to run the tool from within ArcMap 10.1. The problem is that ...
3
votes
1answer
830 views

add new SRID to sql server

Is it possible to add a new SRID to sql server 2012? I've tried insert into sys.spatial_reference_systems values (4938, 'GEOCCS["GDA94",DATUM["Geocentric Datum of Australia 1994",SPHEROID["GRS ...
0
votes
1answer
292 views

how to make a join with sql server table

I have a question. I'd like to join .shp to table by using AddJoin_management. But I'd like to make join to sqlserver table (not to *.dbf). Is it possible to do? it should look something like this: ...
1
vote
2answers
61 views

Seek assistance with: SQL Server 2008 Query that takes values from a column in another table (or from a flat file)

I am given a list in MS Excel of 554 statistical units (called Primary Sampling Units or PSUs) from another department and have to query all 554 PSUs from a SQL Server 2008 Spatial database table ...
0
votes
1answer
64 views

number of arcgis server users for CAL-based backends

The licenses for our organization's MS SQL and ArcGIS Server are such: MS SQL: CAL ArcGIS Server: enterprise Are the number of users that can be served still limited to the number of CALs present in ...
0
votes
1answer
178 views

How to export Spatial data from MsSQL to MySQL using OpenSource/Free tools

I have a few tables with geometry fields in MsSQL Server 2008. I would like to export the whole table with data to MsSQL Server. Are there any open source/free tools that does this job?
0
votes
0answers
338 views

SDE connection error

In my company we have a number of databases in an MS SQL instance. This morning only 1 database i generating following error when I try to do a direct-connect in ArcCatalog: Failed to connect to ...