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

GML TimePeriod mapping in MapForce

I made SQLServer database structure based on xsd schema I got. In that schema two fields have gml:TimePeriodType. In database I put two columns for each field of this type (begin and end) and the ...
2
votes
1answer
265 views

Convert from Geometry to SDE Binary storage type in SDE database

We have been battling performance issues between SQL 2012 and ArcGIS 10.1. One of the most common solution is to convert to SDE Binary storage. We know that this storage type is not as dynamic as the ...
2
votes
1answer
417 views

How to convert Geometry type column to degree Minutes Second in SQL Server 2008 R2

I have shape column of type geometry and I want to convert X and Y coordinates into Degree Minutes Second format using SQL query and i am using sql server 2008 R2. Currently I got Lat and long using ...
2
votes
2answers
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 ...
13
votes
2answers
2k views

How can I fix my complex Polygons so they show correctly in Google Maps?

Problem: I'm trying to find a way to fix some broken polygon shapes and I'm not sure how I can do this. Details: I've got a number of polygons which I basically imported from TIGERLINES a while ...