MsSqlSpatial

New Post: import shape file error

zabcd117 — Wed, 08 Oct 2008 01:40:42 GMT

I import shape file with msscmd,when the .dbf file doesn't have nonunicode field,it works fine, but if the .dbf file contains some unicode field, it will retrieve some convert error.
the shape file is upload to the following link
http://www.live-share.com/files/355298/road.rar.html
I'm just a beginner in gis and program design and also english, my email is zabcd117@163.com, anyone's help is appreciated.

Source code checked in, #39645

JohnDiss — Fri, 12 Sep 2008 14:27:22 GMT

updated dependencies

New Post: Latitude and Longitude

JohnDiss — Thu, 11 Sep 2008 14:23:07 GMT

Hi NeSSaYah, it will be fine, just remember to use the correct srid for your coordinate system.. hth jd

New Post: MsSqlSpatial and Raster data

JohnDiss — Thu, 11 Sep 2008 14:21:14 GMT

Unfortunately MsSqlSpatial doesn't handle raster data. jd

New Post: Latitude and Longitude

NeSSaYah — Wed, 10 Sep 2008 18:24:08 GMT

Hello ~~

Fist of all, gratz to all who made this app, U guys done geat work ;)

The app runs smooth can i can play with coordinates in a flat surface.

But what if I would like to store Latitude and Longitude in my database ?
Is it possible somehow ?

New Post: MsSqlSpatial and Raster data

dmgimg — Wed, 10 Sep 2008 14:11:46 GMT

Can MsSqlSpatial work with raster data much like PostGis can?

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

angelobac — Wed, 13 Aug 2008 15:12:07 GMT

System.InvalidOperationException: Vertex components can't be NaN.
System.InvalidOperationException:
at NetTopologySuite.Coordinates.BufferedCoordinate2DFactory.getVertexInternal(Double x, Double y, Double w)
at NetTopologySuite.Coordinates.BufferedCoordinate2DFactory.getVertexInternal(Double x, Double y)
at NetTopologySuite.Coordinates.BufferedCoordinate2DFactory.Create(Double x, Double y)
at GisSharpBlog.NetTopologySuite.Algorithm.CentroidArea`1.get_Centroid()
at GisSharpBlog.NetTopologySuite.Geometries.Geometry`1.get_Centroid()
at GisSharpBlog.NetTopologySuite.Geometries.Geometry`1.GeoAPI.Geometries.IGeometry.get_Centroid()
at UserDefinedFunctions.Centroid(SqlBytes ewkb)

New Post: ST.PointN Vs ST.NPoint

belame — Tue, 12 Aug 2008 15:50:05 GMT

Thanks JohnDiss for the help!

-belame

New Post: ST.PointN Vs ST.NPoint

JohnDiss — Tue, 12 Aug 2008 08:47:30 GMT

Hi belame, you want something like SELECT HUC FROM Intersection_Output_2 where ST.[Contains](Geometry,ST.Point(@a,@b,@srid)) = 1
srid is the spatial reference for the point which should match the srid of the geometry (or -1 if they are not known)

ST.PointN Returns the N'th point in the first linestring in the geometry., ST.PointFromText creates a point from its well known text. The best reference for the functions is at http://www.opengeospatial.org/standards/sfs which are the standars which mssqlspatial implement. hth jd

New Post: ST.PointN Vs ST.NPoint

belame — Mon, 11 Aug 2008 17:46:02 GMT

Hello,

I have to find if a given set of latitude and longitude is present in the given set of Polygon (polygons are in a field named 'Geometry' in the spatial table ''Intersection_Output_2' )
..........................................................
Here is what I have:

Declare @a float
Declare @b float
Set @a = -93.6603392551339
Set @b = 29.8821835456083

SELECT HUC FROM Intersection_Output_2 where ST.[Contains](Geometry,ST.PointN(@a,@b)) = 1
...............................................................................................................................................

As I did not find any helpful explanation for the 'Functions' available with the MSSQL Spatial. I just had to guess that the function

ST.Contains would return a bit 1 /0 depending on if the point is present in the the polygon..

and to make a 'point' using the 'latitude' and 'longitude' available am not sure as to which function I need to use in the list below,

ST.PointN
ST.NPoint
ST.PointFromText.....

am sure there might be other mistakes in the above query.. as this is the 1st time am using this spatial extension to SQL server..If so Please do let me know I would really appreciate it!

Thanks a lot in advance!
-belame

New Post: measure for st.buffer

JohnDiss — Mon, 11 Aug 2008 11:02:22 GMT

Hi PuNk, the measure is the same unit as the geometry being buffered, hth jd

New Post: is MsSqlSpatial right for me?

SharpGIS — Sun, 10 Aug 2008 03:57:33 GMT

Have you looked at SQL Server 2008 ? It provides a lot of the functionality that MsSqlSpatial has out of the box, and its using its built-in spatial index instead.

New Post: measure for st.buffer

puNk — Sat, 09 Aug 2008 13:20:16 GMT

Hi,

what is the measure for distance in the St.buffer function?

SELECT [database].[ST].[Buffer] (
<@ewkb, varbinary(max),>
,<@distance, float,>)

thanks, puNk

New Post: is MsSqlSpatial right for me?

JohnDiss — Thu, 07 Aug 2008 10:25:57 GMT

Hi ronnyek, I think you would find it easier to keep the int Primary Key, you can always add your uniqueidentifier column and add appropriate indexes and unique constraints. This will allow the inner workings of mssqlspatial to work as intended while allowing you to use your original 'key' as an attribute filter. As far as index tables go, there isnt really a spatial index as such - rather each table has envelope columns added and indexed e.g yourgeometrycolumn_Envelope_MinX and these columns are used as a 'pre filter' for some of the query functions. hth jd

New Post: is MsSqlSpatial right for me?

ronnyek — Thu, 07 Aug 2008 03:18:09 GMT

Ok,

I've got an application existing, location with lat/long coords. My site like I am sure many others you provide a latlong and it'll return locations within x range etc. Its functional, but was hoping for a bit more flexibility and a bit more performance.

I've got MsSqlSpatial installed, and was trying to follow the populating the geo tables not from shape files. It would complain saying it couldnt convert int to uniqueidentifier... (which I assume is because rather than using int id's, I use guids.

I am definately going to need more of the functionality in this project, however I wont be using GIS tables or etc... just my locations with my lat/longs. I'd like to know if this is a good use of this library and wondering if somone could point me in the right direction as to creating the index tables and if there is something fundametally wrong wiht what I am trying to do...

EXECUTE ST.AddGeometryColumn 'dbo', 'zctas', 'thepoint_lonlat', 4269, 'POINT'

Thanks whats failing me with the fail between in and guid.

Thanks in advance.

New Post: What is the right syntax to define the DefinitionQuery

puNk — Thu, 31 Jul 2008 20:39:20 GMT

Okay, I should use the DefinitionQuery like this .DefinitionQuery = "country = 'DEU'"

solved!

New Post: What is the right syntax to define the DefinitionQuery

puNk — Thu, 31 Jul 2008 19:48:08 GMT

Hi community,

since some days i have tested your project – i can say it is working well.

Now, I want to use Sharpmap to display geometries in conjunction with the MsSqlSpatial database tools. I use sharpmap with shapefiles at the moment. My first tests and steps to implementation are finished. But there is a problem to form the DefinitionQuery for the FeatureDataTables.

For the following example I‘d like to have a Dataset wich is filtered by a where clause before execution a spatial function. The result must filtered again by an intersection query. The function „ST.FilterQueryWhere“ works well inside the sql development tools
What is the right syntax to define the query?

Function….

   Dim d As SharpMap.Data.Providers.MsSqlSpatial = New SharpMap.Data.Providers.MsSqlSpatial(Conn here, theTable, geomColum, idColumn)
   Dim ds As SharpMap.Data.FeatureDataSet
   ds = New SharpMap.Data.FeatureDataSet
-->   d.DefinitionQuery = "ST.FilterQueryWhere#dbo#datatable#the_geom ([ST].[MakeEnvelope](bounding 4x,SRID),'the clause here')"
   d.Open()
   d.ExecuteIntersectionQuery(bbox, ds)
   d.Close()
   d = Nothing

return…

I get an error like "near the ')' a boolean is expected"... Where is the documentation ;-)

Thanks in advance,
puNk

Source code checked in, #34396

JohnDiss — Fri, 18 Jul 2008 13:09:18 GMT

v1.7.x ran resharper over the code. v1.7.x and v2 changed the deployment routine to only install assymetric keys for MsSqlSpatial Library - this should make installing multiple versions side by side easier. Untested on a completely fresh master db though. Feedback on install requested.

Source code checked in, #34395

JohnDiss — Fri, 18 Jul 2008 11:43:27 GMT

v1.7.x renamed solution and project files to reflect version

Source code checked in, #34394

JohnDiss — Fri, 18 Jul 2008 11:40:34 GMT

trunk, v1.7x,v2 Added Google Mercator EPSG:900913 to srid.csv