Tagged Questions

1
vote
0answers
18 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
1answer
235 views

How to import ArcGIS 10.1 File geodatabse to MS SQL Server 2012

Hello I´d like to import my File Geodatabase from ArcGIS 10.1 into MS SQL Server 2012. I´ve never do it before, so I expect to do the import same way as import data from excel table. Problem is ...
2
votes
0answers
389 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 ...
3
votes
3answers
176 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 ...
0
votes
0answers
79 views

SqlGeography STArea for CW and CCW polygons

I'm using a SqlGeographyBuilder to make a simple polygon (with SRID of WGS84). When I add the vertices CW and call the STArea() method, The area would be very large. When I add the vertices CCW and ...
0
votes
0answers
61 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
89 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
2answers
131 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 ...
4
votes
1answer
170 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
191 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. ...
6
votes
3answers
280 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. ...
1
vote
2answers
627 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 ...
2
votes
0answers
233 views

Can a spatial View in ArcSDE be viewed in ArcCatalog?

Can a spatial view in ArcSDE created by "sdetable create view" command be viewed as feature class in ArcCatalog, or is it just another plain table? I have a feature class table and an attribute table ...
5
votes
1answer
561 views

Reset Object ID After Truncating Table In SQL Server

I am working on a program to export data from a view containing a geometry type in Sql Server 2008, to an ArcSDE table on another server which also stores data using the geometry type. The source ...
1
vote
1answer
129 views

What are the areas, relating to database or server, that should be viewed while making map based webapplication?

This question is relating to GIS web application that are based on relational database. I have database that is not indexed with spatial column and I use geoserver to display these data as layers. But ...
5
votes
2answers
382 views

Spatial metadata table in SQL Server 2008

I have a db and want to know if it contains any spatial tables. Is there a table in SQL Server that holds spatial metadata i.e. a list of all the spatial tables in the current db? Oracle has the ...
18
votes
3answers
1k views

When should you NOT use a spatial index?

I am asking this because I was mainly working with Oracle but for the past year I've been doubling with PostGIS and SQLServer 2008. Most spatial functions in Oracle won't work without a spatial index ...
2
votes
1answer
448 views

Convert SqlGeometry data from SQL directly to Tiles / PNG file

I would like to know a basic method for 'exporting' SqlGeometry data from SQL Server 2008 to a Tile Server / PNG File generator. I already have a Silverlight Map application which uses a Custom Tile ...
3
votes
1answer
879 views

Can spatial data in Oracle be imported into SQL server?

Oracle supports spatial data and so does SQL Server. What are the things to consider if we have to migrate spatial data from Oracle to SQL Server? Are there any features in Oracle that are not there ...
3
votes
4answers
781 views

Creating a multiversioned view with ArcSDE and SQL Server 2008 R2

I am using the administration command sdetable -o create_mv_view to create a multiversioned view on a table in SQL Server 2008 R2. Everything appears to be working correctly with one exception: The ...
3
votes
3answers
2k views

STDistance Unit in SQL Server 2008

I've got a SPROC in SQL Server 2008 where I'm trying to calculate the distance between a point and a polygon, and I'm getting unexpected results. I am passing a parameter (@Radius) in miles to the ...
3
votes
1answer
598 views

Configuring WMS from a MSSQL data source with MapGuide Open Source

I've having trouble configuring WMS out of MapGuide Open Source. Here's what I've done so far: Installed MapGuide Downloaded MapGuide Maestro Created a "feature" in Maestro that connects to ...
4
votes
1answer
890 views

ArcSDE - Registering table with Geography spatial column fails with error -138 (SQL Server 2008)

I have a table of point features I am trying to register with ArcSDE (9.3.1 on SQL Server 2008) using the following command: sdelayer -o register -l ThirdPartyWellsSurface,Shape -e np -C OBJECTID,SDE ...
8
votes
2answers
506 views

Find duplicate vertices in SQL Server geometry line (ArcSDE)

I have a line in a ZM polyline featureclass that has a invalid geometry. My suspicion is that the line doubles back on itself somewhere, which I've found SQL Server doesn't like. Anyone know of a ...
7
votes
4answers
527 views

MS SQL Spatial as Central Datastore?

I've been working on opening up our spatial data from a proprietry system to one that can be read by more products (MapGuide, ESRI, gvSIG, Map3D etc....) I've decided on using SQL Spatial as we have ...
2
votes
1answer
184 views

Why does SQL job choke on stored package?

I've written a stored package to pull a text file into a table in the geodatabase. It works perfectly. However, when it is a step in a SQL job, the job fails at that step. I'm looking for ideas on ...
15
votes
6answers
3k views

What are the best databases for storing spatial data? Pros and Cons

A couple of days ago I installed the demo of spatialware 4.9 from MapInfo into my SQL Server 2005 install and loaded all the larger dataset into it. I was quite impressed with the performance vs the ...