Cannot export shapefile to database because of invalid sql create/insert statement

In my case, I tried to export a shapefile that contains an attribute named '1986'. This is not valid column name in the MS SQL Server unless we surround it with "[]". This affects both create and i...

Id #25105 | Release: None | Updated: Feb 14, 2013 at 5:56 PM by eclave | Created: Oct 27, 2009 at 10:09 AM by eclave

A .NET Framework error occurred during execution of user-defined routine or aggregate "Centroid":

System.InvalidOperationException: Vertex components can't be NaN. System.InvalidOperationException: at NetTopologySuite.Coordinates.BufferedCoordinate2DFactory.getVertexInternal(Double x, Doubl...

Id #17818 | Release: None | Updated: Feb 14, 2013 at 5:56 PM by angelobac | Created: Aug 13, 2008 at 3:12 PM by angelobac

Schema Change breaks geometry columns

It appears that when I make a schema change in a table from SQL Management Studio (right click table--> design) that the record in ST.GEOMETRY_COLUMNS gets removes along with the associated table f...

Id #16777 | Release: None | Updated: Feb 14, 2013 at 5:56 PM by jncoign | Created: May 25, 2008 at 8:58 PM by jncoign

Cannot Import Shapefile due to duplicate column name

How do i get around of this error? (I really dont care about names as long as it would import the file)   Unhandled Exception: System.Data.DuplicateNameException: A column named 'ID' alr eady belon...

Id #12500 | Release: None | Updated: Feb 14, 2013 at 5:56 PM by mlehiste | Created: Aug 29, 2007 at 3:53 PM by mlehiste

Transform 2868 <-> 4326 SRIDs

I'm having some trouble transforming coordinates. I've tracked down the SRID's and searched and looked at this for hours. Using one coordinate pair I've converted back and forth in ArcGIS and MsSql...

Id #9665 | Release: None | Updated: Feb 14, 2013 at 5:56 PM by SharpGIS | Created: Apr 16, 2007 at 2:28 PM by rstuven

Allow GUID for OID

Integer primary keys prevent geo tables from participating in replication.

Id #9444 | Release: None | Updated: Feb 14, 2013 at 5:56 PM by oeustice | Created: Apr 8, 2007 at 3:07 PM by oeustice

Implement Polar_Stereographic projection

Both "WGS 84 / UPS North" (SRID 32661) and "WGS 84 / UPS South" (SRID 32761) use Polar_Stereographic projection which is not supported.   GeoTools project (LGPL/Java) has an implementation that cou...

Id #7911 | Release: None | Updated: Feb 14, 2013 at 5:56 PM by Odegaard | Created: Feb 2, 2007 at 12:30 AM by rstuven

Explore application of DDL triggers

Study feasibility of feature suggested by Volleyknaller: DROP TABLE trigger to execute DropGeometryTable or equivalent functionality. Think other applications for MsSqlSpatial and identify limitati...

Id #3721 | Release: None | Updated: Feb 14, 2013 at 5:56 PM by rstuven | Created: Sep 26, 2006 at 7:56 AM by rstuven

Implement Scale function

From PostGIS docs: "Scale(geometry,float8,float8,float8) Scales the geometry to a new size by multiplying the ordinates with the parameters. Ie: scale(geom, Xfactor, Yfactor, Zfactor). Note: Scale ...

Id #2346 | Release: 0.2 Beta | Updated: Feb 14, 2013 at 5:56 PM by rstuven | Created: Aug 20, 2006 at 3:04 AM by rstuven

Implement Translate function

From PostGIS docs: "Translate(geometry,float8,float8,float8) Translates the geometry to a new location using the numeric parameters as offsets. Ie: translate(geom, X, Y, Z). Note: Translate functio...

Id #2345 | Release: 0.2 Beta | Updated: Feb 14, 2013 at 5:56 PM by rstuven | Created: Aug 20, 2006 at 2:51 AM by rstuven