1
Vote

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: Oct 27 2009 at 10:09 AM by eclave | Created: Oct 27 2009 at 10:09 AM by eclave

1
Vote

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: Aug 13 2008 at 3:12 PM by angelobac | Created: Aug 13 2008 at 3:12 PM by angelobac

1
Vote

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: May 25 2008 at 8:59 PM by jncoign | Created: May 25 2008 at 8:58 PM by jncoign

1
Vote

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 belong...

Id #12500 | Release: None | Updated: Aug 29 2007 at 3:53 PM by mlehiste | Created: Aug 29 2007 at 3:53 PM by mlehiste

1
Vote

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: Aug 26 2007 at 6:53 PM by SharpGIS | Created: Apr 16 2007 at 2:28 PM by rstuven

1
Vote

Allow GUID for OID

Integer primary keys prevent geo tables from participating in replication.

Id #9444 | Release: None | Updated: Apr 8 2007 at 3:07 PM by oeustice | Created: Apr 8 2007 at 3:07 PM by oeustice

1
Vote

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 coul...

Id #7911 | Release: None | Updated: Feb 2 2007 at 4:38 AM by Odegaard | Created: Feb 2 2007 at 12:30 AM by rstuven

0
Vote

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: Jan 30 2007 at 10:09 PM by rstuven | Created: Sep 26 2006 at 7:56 AM by rstuven

0
Vote

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: Aug 24 2006 at 12:56 PM by rstuven | Created: Aug 20 2006 at 3:04 AM by rstuven

0
Vote

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: Aug 20 2006 at 2:51 AM by rstuven | Created: Aug 20 2006 at 2:51 AM by rstuven