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)

1
vote
1answer
144 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
304 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
294 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
330 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
87 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
341 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
890 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
300 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
66 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
189 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
1answer
389 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 ...
0
votes
1answer
109 views

Creating “Empty” version of ArcSDE geodatabase?

Is it possible to create an "Empty" version of an ArcSDE geodatabase? I have a large default ArcSDE geodatabase that I would like to create an empty version for a new project. By "Empty" version I ...
2
votes
2answers
907 views

ArcGIS Server 10.1 and SQL Server 2012 SP1

We have just built and new ArcGIS/ArcSDE system with SQL Server 2012 SP1. We are experiencing very long periods (up to 2 minutes) just to connect to the database in Desktop. Desktop does connect and ...
1
vote
1answer
516 views

Filtering a Feature Class in using ArcGISDynamicMapServiceLayer

I'm using the following code in Flex to display all the features in a Feature Class defined in the "Data Layer". var dataLayer:ArcGISDynamicMapServiceLayer= map.getLayer("Data Layers") as ...
0
votes
0answers
73 views

Retrieving ArcGIS:s Spatial Data into a Database

Background: If you have created a vector map with lots of spatial data in geometry flat in with measurement kilometer. The following object that is used in the map will be point, line and polygon ...
0
votes
0answers
138 views

Retrieving the data from SQL database is taking much more time than expected

I am creating a block wise vector layer and related data stored in a sql database while retrieving the data from the SQL database through querying and would represent the result on a map. This is ...
2
votes
1answer
223 views

Connecting gvSIG with SQLSERVER

I am working for the first time with gvSIG and SQL SERVER, I want to connect gvsig with spatial database SQL SERVER. I don't know how to, Is it by using a protocol and which one ? plz help me
1
vote
1answer
375 views

tools and ETLs for migrating data benchmarking - from shapefile to SQL SERVER

i need to migrate my shapefiles to my database SQL SERVER, and i don't know what's the best tool or ETLs to choose, i already tried FME Desktop and i succeded to load the shapefiles on my db, but ...
3
votes
4answers
419 views

What Application for Vector and Cartesian Coordinate System

Goal: Visualize a picture in SQL server 2012 spatial data based on geometry Problem: In order to display a vector picture I need to retrieve X, Y coordinate (cartesian coordinate system) and ...
5
votes
3answers
734 views

How to migrate PostGIS spatial data to MsSql spatial data?

am trying to migrate PostGIS geometry to SQL server Spatial data. which ETL i have to use. it's the first time i'll work with SQL server Spatial. is there any Data ETL model that do this migration. ...
0
votes
1answer
74 views

What kind of unit of measurement for scale does SQL Server 2012 Spatial use?

What kind of unit of measurement for scale does SQL Server 2012 Spatial use?
1
vote
3answers
137 views

How to Retrieve X and Y from a papermap or gif picture

Goal: Visualize a subway map in SQL server 2012 spatial data based on the map of the subway. The map shall use geometry, traffic rail road as line object, station as point object and zon as polygon ...
3
votes
1answer
316 views

How to use stored procedure in Geoserver?

I have a MS SQL Server 2008 R2 with and have stored procedure in here. I want to create layer in GEoserver using this. I try: EXECUTE [dd_base].[dbo].[Request BaseSration] 'param1', 'param2', ...
1
vote
0answers
341 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. ...
2
votes
1answer
1k views

How to use non-native spatial data from MS SQL Server with ogr2ogr?

I have some tables in MS SQL Server (2012) with WKT string columns. I want to export these data to a MapInfo tab file. Currently I am using the following command: ogr2ogr -f "MapInfo File" ...
2
votes
0answers
71 views

Critera for geometry or geography

What criteria do you need to take account to before you choose geometry or geography map? Is there a book or page about it?
4
votes
1answer
645 views

What licenses are needed for ArcGIS Server and SDE (vs a FOSS setup)?

Does anyone know where I could find a cost breakdown for an ESRI/Microsoft GIS server and database setup? I'm trying to figure out all the costs associated with an ArcGIS Server/SDE sitting on top of ...
5
votes
2answers
1k views

Does SQL Server need extensions to do spatial?

Does SQL Server need extensions to do spatial like Oracle does? Just wondering if there will be extra costs for implementing a SQL Server backend to SDE. Thanks
3
votes
2answers
243 views

Several questions about using spatial data?

If you have spatial data for SQL server, can you use the spatial data (both geometry and geography) in another application for instance ESRI ArcGIS? Is spatial data a standard that every GIS ...
3
votes
1answer
275 views

FME: Can I add multiple feature types to the SQL Server Spatial reader?

The title's it, really. With .TAB file reader, you can add multiple layers to the reader and use the 'merge feature type' check box with an '*' to read all the layers listed in the source files, ...
4
votes
1answer
327 views

SQL Server data modelling + spatial data = what book?

What recommended book can you provide about data modelling for geographical spatial data (geometry) in SQL server?
3
votes
2answers
534 views

Visualize Spatial Data in Reporting Service

Is it possible to visualize a piece of geographical map from SQL server Spatial data (geometry, not geography) in a report from reporting service? If yes, how should it be done in a course of action. ...
3
votes
1answer
846 views

Openlayers: OGC Filter problem

I have a problem with OGC filter. My layer in OpenLayers has this filter: filter: new OpenLayers.Filter.Comparison({ type: OpenLayers.Filter.Comparison.BETWEEN, property: ...
2
votes
1answer
509 views

What is the “best practice” way to retrieve features from MSSQL to OpenLayers and display them?

Today I have a table in the DB with columns Feature Name and Feature Point. When I want to load the points to OL I do the following : First I call web service to get list of json objects: var ...
4
votes
1answer
2k views

STIntersects - Update field to give me count of points in polygon

I have a points layer (dbo.ptLayer) Around 1M points Spatial Geometry Type (dbo.ptLayer.geom) No spatial index just yet, but will create one once data gathering complete. I have a polygon layer ...
7
votes
2answers
208 views

ArcSDE : Cascading Subtypes in ArcGIS 10/SQL Server

I'm currently creating an ArcSDE DB on an SQL Server. It is designed to complete species survey, with information from the field. In order to help themselves, they asked me to implement a particular ...
4
votes
1answer
600 views

Is there a way to get centroid of geographic object in MSSQL?

I have a table of OSM geographic roads in MSSQL 2012. I want to create a new column with the centroid of each road (So I can set center on OpenLayers map for each road). How can I do it ?
0
votes
0answers
112 views

Can osm way records in SQL spatial be merged to one geographic record if they have same Id?

I've imported England shp file of roads to mssql using OSM2MSSQL and I've noticed that the same road has couple of records with same Id but different geographic (probably it was segmented). Is there ...
0
votes
2answers
469 views

How can I get nearest road to a lat lon in MSSQL?

I've updated osm data (ways) in MSSQL and got geographic objects. Now I want to get the closet road to any lat lon a user will query. Which SQL spatial statement is used for that ?
0
votes
1answer
440 views

How can I relate between street and city in OSM imported data into SQL?

I've used OSM2MSSQL to fill db with 2 cities streets. Now I have the following tables in my DB : tNode tNodeTag tRelation tRelationMember tRelationTag tTagText tWay tWayCreation tWayTag How ...
1
vote
2answers
284 views

SQL Server STpointfromText comes from PHP into javascript as garbage

Sorry for the sloppy title. Here's the scenario - I have a table in SQL Server 2008 R2 It has a geographyColumn, created thusly: add geographyColumn as ...
2
votes
0answers
382 views

MSSQL spatial layer import error

I am currently working on a project in which spatial data are stored in a Microsoft SQL Server 2008 database. The tables which hold the spatial table contain 3 rows and are: RoomId - BIGINT, ...
2
votes
2answers
545 views

Can we use procedures in a Query layer (ArcGIS Desktop 10.1 & Server 10.1)?

I have one basic question that.. Can we use procedures in Query layer (ArcGIS Desktop 10.1)?? Currently I am using query layer for ArcGIS Desktop 10.1 and its working fine . My DBA person told me ...
2
votes
0answers
369 views

How to build a Query Layer in ArcMap 10.1 using columns of two different databases?

As you may know, to create a Query Layer in ArcMap 10.1, it is required to specify a connection to a concrete database and then, define the access to the tables and columns in the SQL Query ...
6
votes
2answers
408 views

Understanding Geodatabase Archiving and H tables in ArcSDE?

We have ArcSDE 10.0 on MSSQL 2008 with Geodatabase archiving enabled. In the process of updating a topology I deleted the topology, disabled archiving, unregistered as versioned and then recreated ...
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 ...
4
votes
2answers
330 views

PostGIS or SQL 2008 ? (For the newbie GIS programmer but familiar with .Net) [closed]

I've been using MS SQL for years. Starting now to develop GIS application and it is required to do queries and store vectors created in OpenLayers in DB. Assuming I'm developing over .Net , What will ...