Tagged Questions

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)

4
votes
1answer
457 views

How to register a Stored Procedure in ArcSDE?

I just registered a SQL Server view with ArcSDE through sdetable -o register [...]. I wonder, how to register a SQL Server stored procedure with ArcSDE? Is it the same process as the view? EDIT ...
4
votes
1answer
561 views

Why don't my polygons from MSSQL2008 display in QGIS?

I have imported a polygon shape file in MSSQL2008 using Shape2SQL loader without any issue. When I import the loaded polygon file in QGIS, I can't see it ! When I import other point or line features ...
6
votes
3answers
1k views

Insert points into SQL Server?

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

Geoserver WMS-T backend problems

I've been trying to set up a few timed WMS layers in GeoServer. They're simple enough, of the form ID(PRIMARY KEY) REGION DATE VALUE so for every region and date you have some value, e.g. the ...
3
votes
1answer
390 views

How to force sql server to use the spatial index?

I'm beginner with SQL Server (2012). I created a spatial index, and I'm trying to force SQL Server to use that index to solve the query. Here's what I have: DECLARE @g geography SET @g = ...
5
votes
1answer
328 views

Can you synchronize tables between ArcSDE(MSSQL) and PostgreSQL(PostGIS) regularly?

I have spatial tables in ArcSDE 10.1 (MSSQL 2008 R2) geodatabases and need to update the same spatial tables in PostgreSQL 9.1(PostGIS 2.0.1) geodatabases. Basically I use my ArcSDE environment for ...
4
votes
1answer
195 views

Using xml workspace to overwrite geodatabase in ArcGIS Server 10 with ArcSDE for SQL Server?

I want to transfer a geodatabase from my development server to my client's production server. We are using SQL Server, but in different versions. Hence I cannot use Backup/restore or detach/attach. ...
2
votes
1answer
454 views

Live update (the database & Map) possible in ArcGIS Server 10.1?

I am using sql server data base contains lat/lon values and using this information I have created the shape files and published on server.. When I get the update say 100 records then I need to ...
2
votes
0answers
408 views

Ogr2ogr: Unable to open datasource problem

I downloaded the Precints shapefile from the City of Boston's data hub, and I'm trying import it into SQLServer (I'm running the Express verson). I've already created the database in the SQLServer ...
3
votes
2answers
327 views

Is it possible to load features into ArcSDE without using ArcObjects?

I have a SDE geodatabase in MS SQL Server, where geometries are stored in MS SQL's native geometry types, rather than the ArcSDE Binary. It seems like it would be relatively easy to create new ...
7
votes
0answers
67 views

How can I automatically split a spatial layer to a grid [duplicate]

Possible Duplicate: Divide vector in equal smaller parts in QGIS or similar I am a software engineer and the company I work for has a project that needs some spatial data manipulation in ...
2
votes
0answers
277 views

Store elements of Imap into BLOB fields using IPersistStream

I have an IMap (include elements: text, line) and I want to store it into a field of a table in SQL, so I can load it again later. I used below codes, but I got an the error : public class Test { ...
1
vote
1answer
655 views

MapServer connection to SQL Server 2008

I'm trying to view some data held in a SQL Server 2008 database using MapServer. I can run the GetCapabilities requests without any errors, but when i try and run a GetFeature I get the following ...
6
votes
2answers
952 views

Autonumbering fields in versioned ArcSDE Geodatabase?

I want to have a field with autonumbering in ArcGIS. I have a versioned ArcSDE for SQL Server geodatabase. Thus, using the identity seed attribute in the SQL Server is not an option. Is it not ...
2
votes
1answer
1k views

Shapefile to MSSQL with ogr2ogr fails to make connection

I am using ogr2ogr from OSGeo4W on my Windows 7 box to import a shapefile into a SQL Server database on one of my servers. I was able to successfully complete the conversion using shp2sqlserver, but I ...
2
votes
1answer
156 views

How to create a network with all the track points

I have created a sample network through the use of gps visualizer. Than I used the ogr2ogr function to import this data in my database. Now I have a table which holds all the track points of these ...
0
votes
1answer
727 views

Ogr2Ogr doesn't work with QGIS 1.8

I'm trying to use Ogr2Ogr.exe to import some shapefiles. It came installed with QGIS 1.8. When I try and run it, i get the following error: C:\Program Files (x86)\Quantum GIS Lisboa\bin>ogr2ogr ...
2
votes
1answer
2k views

How to save a vector layer from QGIS to Sql Server 2008 or 2012?

using QGIS, i've loaded up some administrative boundary data of New Zealand. I wish to now import this vector data from QGIS into my Sql Server 2012. Is there any way to do this with QGIS ...
2
votes
4answers
6k views

How to import shapefiles into MS SQL 2008 and then view that data using QGIS?

I'm a QGIS users but not a database person and I need some help on the DB side. I'm currently in the need to import several shape files into MSSQL 2008 and I have no clue how to do that and my IT guy ...
0
votes
1answer
178 views

What is the best way to sum the area from a number of polygons in .NET/SQL Server?

I have an Mapbasic/.NET application that read data from SQL Server 2008 R2. I have a table with polygons and need to sum up the area of a subset of the polygons. This should work dynamic so the user ...
2
votes
3answers
335 views

How to save a QGIS workspace with database link for offline use?

Is it possible to save current workspace of QGIS for offline usage like in mapinfo? My workspace has link to database. and when I reopen workspace unlink in mapinfo it can't open it.
3
votes
2answers
1k 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 ...
2
votes
0answers
509 views

View in ArcSDE 10.1 Problem

I have created a view by joining a feature layer and 2-3 other tables in ArcSDE database using help from James Richard Post. The view gets created fine in both SQL Server 2008 and also in SDE. In ...
2
votes
1answer
194 views

How can I copy archive data from one server to another?

I have an SDE 10.0 server and an SDE 10.1 server and I am trying to migrate the layers from 10.0 to 10.1. (On a side note the 10.0 server is running SQL Server 2005 and the 10.1 server is running SQL ...
2
votes
0answers
429 views

Is it acceptable to store OSGB36 data as geometry in SQL Server?

I've set myself a project of getting some geo data into SQL Server but before I get started doing any of the big jobs I wanted to see if I was on the right track. All of my data is for the UK and is ...
3
votes
1answer
295 views

Using CAST function in ArcMap 10 with ArcSDE?

I would like to use the CAST function in the definition query property of a layer and/or in the label class sql query window. This was the most promising link that I've found, including the two links ...
1
vote
0answers
101 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 ...
0
votes
1answer
133 views

Porting existing MSSQL database to SDE

I have an existing MSSQL2008R2 database with views each containing a single geometry field along with a big number of "attributes". I would like to be able to do INSERTS, UPDATES, and DELETES on ...
1
vote
0answers
55 views

Using SQL replication to replicate Geodatabases (in stead of ArcGIS replicas) [closed]

Given two geodatabases (A and B) in SQL Server (Express) is it possible to replicate from A to B using SQL Server replication instead of using Esri's geodatabase replication?
1
vote
2answers
487 views

Distances and areas in Google projection

I have a mapping website used to capture polygons using OpenLayers in Google projection (900913) and storing them in sql server 2008 as geometry. The SRID on the sql geometry column is set to 900913. ...
3
votes
1answer
1k views

SQL Server 2008 Spatial Index Nearest Neighbour

I am trying to query geopoints for nearest neighbour, Whether I use spatial index or not, I always get similar times and it takes about 6 seconds. How can I speed this query up? Here is my query: ...
2
votes
0answers
199 views

How to compress enterprise geodatabase with stored procedure?

I'm looking for a stored procedure in ArcSDE for SQL Server which performs geodatabase compression to include it in our daily maintenance plan. Is there any such thing in ArcSDE 10.0?
1
vote
0answers
222 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 ...
3
votes
4answers
3k views

SQL Server Geometry to geography conversion

I have imported a number of Shape files from the ordnance survey using shape2SQL these have been imported as geometry however i would like to convert them to Geography and specifically to srid 4326 ...
1
vote
2answers
2k views

Convert spatial Geographic data from sql server 2008 to Json

Is there any example to convert spatial data (point,line,polygon) stored as geographic in sql server 2008 into Json and display data using Arcgis Javascript Api 3.0.I have tried converting geographic ...
5
votes
1answer
1k views

STGeomFromText not working on large polygons

I'm using Microsoft.SqlServer.Types to do intersections on polygons. SqlChars scFullSwath = new SqlChars(new SqlString(fullSwath)); SqlGeography fullSwathGeom = ...
3
votes
2answers
1k views

How can i select a polygon in MS SQL 2008

I am very new to MS SQL 2008. I got a task to select a polygon from the polygon layer by giving the X-Y coordinates. I already got the script for PostgreSQL for the same thing, but i need it for MS ...
4
votes
1answer
9k views

How to import shape file into SQL Server 2008 R2 using only SQL scripts?

I am trying to import some shape files into SQL Server 2008 R2. I found this useful tool called Shape2SQL however I am not sure how I can import shape file directly using only SQL scripts as this is ...
4
votes
2answers
759 views

Why does ST_Area(g.geom) + ST_Area(p.geom) - ST_Area(ST_Union(g.geom,p.geom)) produce negative result when using ST_Overlaps(g.geom, p.geom) = true?

I have two set of shape data. Let's say file gov.shp contains list of post codes and their boundaries. File post.shp contains list of government area name and their boundaries. I want to find out the ...
1
vote
1answer
420 views

Determine if GPS coordinate in Canada

I have GPS tracking solution and most my customers in US. My reverse-geocoding solution pretty basic: Table with US ZIP database Procedure in SQL Server where I search for city/state closest to ...
5
votes
1answer
327 views

BigInt data type in SQL Server mapped as Text in ArcMap

I have a table in a SQL Server 2008 database containing a BIGINT data column. When I tried to import it into ArcMap 10, it automatically converted as Text of 8 length. This caused the records that ...
3
votes
3answers
4k 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 ...
1
vote
2answers
2k views

ArCGIS Server 10/10.1 And Sql Server 2008

Is there any compulsion that SQL server 2008 and ArcGIS server 10/10.1 should be installed on same server machine and is it possible to install SQL server 2008 and ArcGis server on separate server ...
2
votes
2answers
812 views

ArcGIS Server simple link with SQL Server database

I am using ArcGIS Server 10 to create Rich Internet Application with embeded Maps. Basicaly, I created an Optimized Map Service on ArcGIS Server, from an MXD file (produced with Arc Map). I have ...
1
vote
0answers
481 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 ...
2
votes
1answer
2k views

Feature Class To Geodatabase => ERROR 000210: Cannot create output

error messages: Executing: FeatureClassToGeodatabase E:\jags20120321.mdb\ch_cs "Database Connections\Connection to localhost.sde" "Database Connections\Connection to localhost.sde" Start Time: Sat ...
2
votes
0answers
458 views

How to get WKT from SHAPE column in the ArcSDE geodatabase?

I have an ArcSDE geodatabase running on top of SQL Server 2008. A table for a feature layer was added from ArcCatalog. The SHAPE column is a type of int which was automatically converted from ...
1
vote
0answers
360 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 ...
2
votes
1answer
871 views

Creating ArcSDE feature class in MS SQL Server?

Unfortunately I am totally dumb when it comes to programming, and very new to databases (mainly because I studied geography), so : I have a Microsoft SQL Database Server, and a ArcSDE geodatabase. I ...
2
votes
0answers
3k views

ArcSDE error: “Maximum number of connections to instance exceeded ”

I have an ArcSDE error: " *Failed to connect to database. Maximum number of connections to instance exceeded " Did what ESRI recommended :" Check the value set for the CONNECTIONS parameter in ...