NHibernate.Spatial

New Post: Is there an Oracle implementation?

Greif — Mon, 15 Jun 2009 00:37:43 GMT

Any update on this? I am willing to assist with creating an Oracle dialect as well

Updated Wiki: Home

rstuven — Wed, 08 Oct 2008 17:19:01 GMT

__________________________________________________________________________________________________________

We're moving to NHibernate Forge

Thereinafter, please submit your bug reports or feature requests to NH issue tracker
and support questions to NH Users mailing list

__________________________________________________________________________________________________________

NHibernate.Spatial, Spatial extensions for NHibernate, allows you to connect NHibernate to a spatially enabled database and manipulate geometries in HQL or in .NET code using NetTopologySuite, providing you with a fully integrated GIS programming experience.

More info: http://www.nhforge.org/wikis/spatial/introduction.aspx

Updated Wiki: Configuration and mapping

rstuven — Wed, 08 Oct 2008 17:17:49 GMT

See http://www.nhforge.org/wikis/spatial/configuration-and-mapping.aspx

Updated Wiki: Sample usage

rstuven — Wed, 08 Oct 2008 17:17:16 GMT

See http://www.nhforge.org/wikis/spatial/sample-usage.aspx

Updated Wiki: Sample usage

rstuven — Wed, 08 Oct 2008 17:16:58 GMT

http://www.nhforge.org/wikis/spatial/sample-usage.aspx

Source code checked in, #23412

rstuven — Wed, 08 Oct 2008 17:05:56 GMT

Moved to NHContrib repository: https://nhcontrib.svn.sourceforge.net/svnroot/nhcontrib/trunk/src/NHibernate.Spatial/

Created Release: NHibernate.Spatial-1.0.0.Beta2 (Oct 08, 2008)

rstuven — Wed, 08 Oct 2008 16:34:35 GMT

NHibernate.Spatial, spatial extensions for NHibernate, allows you to connect NHibernate to a spatially enabled database and manipulate geometries in HQL or in .NET code providing you with a fully integrated GIS programming experience.

Read documentation at NH Spatial wiki site.

Please submit your bug reports, feature requests or patches to NH issue tracker and support questions to NH Users mailing list.

Released: NHibernate.Spatial-1.0.0.Beta2 (Oct 08, 2008)

Wed, 08 Oct 2008 16:34:33 GMT

New Post: MySQL Provider

rstuven — Wed, 08 Oct 2008 16:25:35 GMT

Ben,$0$0$0$0Check out the latest release of NH.Spatial:$0$0http://www.nhforge.org/media/p/83.aspx$0$0$0$0$0$0Ricardo.$0

New Post: MySQL Provider

santoshamb — Sun, 05 Oct 2008 06:18:26 GMT

dodecaphonic,

How is it going wit the MySQL provider? My host has MySQL and I really want to use NHibernate.Spatial!

Ben

Updated Wiki: Home

rstuven — Fri, 26 Sep 2008 22:40:59 GMT

__________________________________________________________________________________________________________

We're moving to NHibernate Forge

Thereinafter, please submit your bug reports or feature requests to NH issue tracker
and support questions to NH Users mailing list

__________________________________________________________________________________________________________

NHibernate.Spatial, Spatial extensions for NHibernate, allows you to connect NHibernate to a spatially enabled database and manipulate geometries in HQL or in .NET code using NetTopologySuite, providing you with a fully integrated GIS programming experience.

There is also a similar but independent effort for Java: Hibernate Spatial.

Features:

Geometry types: Geometry columns are mapped to .NET geometry types compliant with OGCspecifications.
Dialects: MsSqlSpatial and PostGIS are supported. SQL Server 2008 support is at early stage. The most common spatial functions are registered for use within HQL, providing compatible queries among different dialects.
Criteria: Spatial relations functions such as Intersects, Within, Crosses, etc.
Projections: Spatial aggregate, analysis and tranformation functions.
Schema generation: Support for automatic creation and droping of auxiliary data objects (eg. registering of geometry columns in metadata table).
Metadata mappings: Built-in mappings to spatial metadata through GeometryColumns and SpatialReferenceSystem classes.

Requirements:

.NET 2.0
NHibernate 1.2

Installation:

Download latest sources and build. Copy the binaries to your project's libraries folder.
In you project, add references to NHibernate.dll, NHibernate.Spatial.dll, NetTopologySuite.dll, GeoAPI.dll and to provider assembly (eg. NHibernate.Spatial.PostGis.dll).

Configuration and mapping

Sample usage

Updated Wiki: Home

rstuven — Fri, 26 Sep 2008 21:36:29 GMT

NHibernate.Spatial, Spatial extensions for NHibernate, allows you to connect NHibernate to a spatially enabled database and manipulate geometries in HQL or in .NET code using NetTopologySuite, providing you with a fully integrated GIS programming experience.

There is also a similar but independent effort for Java: Hibernate Spatial.

We're moving to NHibernate Forge

Thereinafter, please submit your report bugs or feature requests to NH JIRA
and support questions to NH Users mailing list

Features:

Geometry types: Geometry columns are mapped to .NET geometry types compliant with OGCspecifications.
Dialects: MsSqlSpatial and PostGIS are supported. SQL Server 2008 support is at early stage. The most common spatial functions are registered for use within HQL, providing compatible queries among different dialects.
Criteria: Spatial relations functions such as Intersects, Within, Crosses, etc.
Projections: Spatial aggregate, analysis and tranformation functions.
Schema generation: Support for automatic creation and droping of auxiliary data objects (eg. registering of geometry columns in metadata table).
Metadata mappings: Built-in mappings to spatial metadata through GeometryColumns and SpatialReferenceSystem classes.

Requirements:

.NET 2.0
NHibernate 1.2

Installation:

Download latest sources and build. Copy the binaries to your project's libraries folder.
In you project, add references to NHibernate.dll, NHibernate.Spatial.dll, NetTopologySuite.dll, GeoAPI.dll and to provider assembly (eg. NHibernate.Spatial.PostGis.dll).

Configuration and mapping

Sample usage

Updated Wiki: Home

rstuven — Fri, 26 Sep 2008 19:22:04 GMT

We're moving to NHibernate Forge

Thereinafter, please submit your report bugs or feature requests to NH JIRA
and support questions to NH Users mailing list

Features:

Geometry types: Geometry columns are mapped to .NET geometry types compliant with OGCspecifications.
Dialects: MsSqlSpatial and PostGIS are supported. SQL Server 2008 support is at early stage. The most common spatial functions are registered for use within HQL, providing compatible queries among different dialects.
Criteria: Spatial relations functions such as Intersects, Within, Crosses, etc.
Projections: Spatial aggregate, analysis and tranformation functions.
Schema generation: Support for automatic creation and droping of auxiliary data objects (eg. registering of geometry columns in metadata table).
Metadata mappings: Built-in mappings to spatial metadata through GeometryColumns and SpatialReferenceSystem classes.

Requirements:

.NET 2.0
NHibernate 1.2

Installation:

Download latest sources and build. Copy the binaries to your project's libraries folder.
In you project, add references to NHibernate.dll, NHibernate.Spatial.dll, NetTopologySuite.dll, GeoAPI.dll and to provider assembly (eg. NHibernate.Spatial.PostGis.dll).

Configuration and mapping

Sample usage

New Post: NH.Spatial Postgis possible bug?

rstuven — Fri, 26 Sep 2008 18:48:15 GMT

$0I think what you want to query is "City contains a point", so you sould use Contains instead of Within (ie. SpatialExpression.Contains(A,B) = "A contains B")$0

New Post: NH.Spatial Postgis possible bug?

demol — Fri, 26 Sep 2008 14:47:29 GMT

Hello guys...
I´m trying to execute a "within" postgis function using NH.Spatial ...
The SQL that I need to get is something like that :

select nomemunicipio from tblcity m where within
( '0101000020C31000000000000000C049C06666666666E633C0', m.the_geom)

So, I created my City class/xml, with geom like that:
<property name="Geometry" column="the_geom">
<type
name="NHibernate.Spatial.Type.GeometryType,NHibernate.Spatial">
<param name="subtype">MULTIPOLYGON</param>
<param name="srid">4291</param>
</type>
</property>

That works great to load, insert ...

So, I execute that:

public IList FindByPoint(IPoint __point)
{
IList results = Session.CreateCriteria(typeof(City))
.Add(SpatialExpression.Within("Geometry", __point))
.List();
return results;
}
And I always got a empty result...
The SQL generated was :

SELECT ... FROM tblCity this_ WHERE
ST_Within(this_.the_geom, :p0); :p0 =
'0101000020C31000000000000000C049C06666666666E633C0'

It seems the ST_Within attributes was inverted... The geometry (p0)
needs to be the fisrt in function...
Is that corrected?

Ps,: I´m using trunk build...

Thanks

New Post: New NHibernate support?

D_Guidi — Sat, 20 Sep 2008 08:33:56 GMT

WOW :-0

Updated Wiki: Home

rstuven — Fri, 19 Sep 2008 19:00:49 GMT

We're moving to NH Contrib project

More details coming soon.

Features:

Geometry types: Geometry columns are mapped to .NET geometry types compliant with OGCspecifications.
Dialects: MsSqlSpatial and PostGIS are supported. SQL Server 2008 support is at early stage. The most common spatial functions are registered for use within HQL, providing compatible queries among different dialects.
Criteria: Spatial relations functions such as Intersects, Within, Crosses, etc.
Projections: Spatial aggregate, analysis and tranformation functions.
Schema generation: Support for automatic creation and droping of auxiliary data objects (eg. registering of geometry columns in metadata table).
Metadata mappings: Built-in mappings to spatial metadata through GeometryColumns and SpatialReferenceSystem classes.

Requirements:

.NET 2.0
NHibernate 1.2

Installation:

Download latest sources and build. Copy the binaries to your project's libraries folder.
In you project, add references to NHibernate.dll, NHibernate.Spatial.dll, NetTopologySuite.dll, GeoAPI.dll and to provider assembly (eg. NHibernate.Spatial.PostGis.dll).

Configuration and mapping

Sample usage

New Post: New NHibernate support?

rstuven — Fri, 19 Sep 2008 18:46:59 GMT

Sorry for not mentioning it in the project homepage here at Codeplex in a timely manner: NH Spatial is moving to NH Contrib project. NH Spatial aims to support NH 2.0 SP1 and NH 1.2 support has already been dropped.

New Post: New NHibernate support?

demol — Thu, 18 Sep 2008 14:21:53 GMT

Hello guys...I´d like to known if you plan to realease support to the new NHibernate version ...
If yes, when?

Thnx

New Post: NHibernate Compatibility

rstuven — Thu, 31 Jul 2008 20:19:03 GMT

Currently, NHibernate 1.2 and an alpha (and patched) version of NHibernate 2.