Sample usage

Ricardo Stuven — Wed, 01 Oct 2008 17:37:00 GMT

Current revision posted to Spatial by Ricardo Stuven on 01/10/2008 02:37:00 p.m.

Sample usage

Find a country by coordinates:

Using NHibernate:

Country country = session.CreateCriteria(typeof(Country))
    .Add(SpatialExpression.Contains("Boundaries", new Point(-70.40, -33.24)))
    .UniqueResult() as Country;

Using ActiveRecord:

Country country = Country.FindOne(
    SpatialExpression.Contains("Boundaries", new Point(-70.40, -33.24))
);

Find all the towns in a bounding box, except the one located at some coordinates:

Using NHibernate:

IList towns = session.CreateCriteria(typeof(Town))
    .Add(SpatialExpression.Filter("Boundaries", new Envelope(-70, -68, -32, -34)))
    .Add(Expression.Not(SpatialExpression.Contains("Boundaries", new Point(-70.40, -33.24))))
    .List();

Using ActiveRecord:

Town[] towns = Town.FindAll(
    SpatialExpression.Filter("Boundaries", new Envelope(-70, -68, -32, -34)),
    Expression.Not(SpatialExpression.Contains("Boundaries", new Point(-70.40, -33.24)))
);

The previous example just shows how to combine a spatial criterion (Contains) with a normal criterion (Not), but in this case we could use simply Disjoint.

Get states boundaries grouping counties by state:

Using ActiveRecord:

ProjectionQuery<County> query = new ProjectionQuery<County>(
    Projections.ProjectionList()
        .Add(Projections.GroupProperty("State"))
        .Add(SpatialProjections.Union("Boundaries"))
    );
IList<object[]> stateBoundaries= query.Execute();

Note: For people with a GIS backgroud, the "projection" term could be confusing. In this context, it has nothing to do with cartographic projections. It's rather a term borrowed from relational algebra.

Create a new vehicle GPS position:

Using NHibernate:

public void TrackVehicule(Vehicle vehicule, double longitude, double latitude, DateTime when)
{
    Tracking tracking = new Tracking();
    tracking.Vehicle = vehicle;
    tracking.Position = new Point(longitude, latitude);
    tracking.When = when;
    session.Save(tracking);
}

More, please!

You also will find lots of sample usage code in the tests project (Tests.NHibernate.Spatial). Check out:

Sample usage

Ricardo Stuven — Wed, 01 Oct 2008 01:22:23 GMT

Revision 3 posted to Spatial by Ricardo Stuven on 30/09/2008 10:22:23 p.m.

Sample usage

Find a country by coordinates:

Using NHibernate:

Country country = session.CreateCriteria(typeof(Country))
    .Add(SpatialExpression.Contains("Boundaries", new Point(-70.40, -33.24)))
    .UniqueResult() as Country;

Using ActiveRecord:

Country country = Country.FindOne(
    SpatialExpression.Contains("Boundaries", new Point(-70.40, -33.24))
);

Find all the towns in a bounding box, except the one located at some coordinates:

Using NHibernate:

IList towns = session.CreateCriteria(typeof(Town))
    .Add(SpatialExpression.Filter("Boundaries", new Envelope(-70, -68, -32, -34)))
    .Add(Expression.Not(SpatialExpression.Contains("Boundaries", new Point(-70.40, -33.24))))
    .List();

Using ActiveRecord:

Town[] towns = Town.FindAll(
    SpatialExpression.Filter("Boundaries", new Envelope(-70, -68, -32, -34)),
    Expression.Not(SpatialExpression.Contains("Boundaries", new Point(-70.40, -33.24)))
);

The previous example just shows how to combine a spatial criterion (Contains) with a normal criterion (Not), but in this case we could use simply Disjoint.

Get states boundaries grouping counties by state:

Using ActiveRecord:

ProjectionQuery<County> query = new ProjectionQuery<County>(
    Projections.ProjectionList()
        .Add(Projections.GroupProperty("State"))
        .Add(SpatialProjections.Union("Boundaries"))
    );
IList<object[]> stateBoundaries= query.Execute();

Create a new vehicle GPS position:

Using NHibernate:

public void TrackVehicule(Vehicle vehicule, double longitude, double latitude, DateTime when)
{
    Tracking tracking = new Tracking();
    tracking.Vehicle = vehicle;
    tracking.Position = new Point(longitude, latitude);
    tracking.When = when;
    session.Save(tracking);
}

More, please!

You also will find lots of sample usage code in the tests project (Tests.NHibernate.Spatial). Check out:

CriteriaFixture.cs
ProjectionsFixture.cs
OgcSfSql11Compliance/ConformanceItemsFixture.cs
RandomGeometries/SpatialQueriesFixture.cs

Sample usage

Ricardo Stuven — Wed, 01 Oct 2008 01:17:22 GMT

Revision 2 posted to Spatial by Ricardo Stuven on 30/09/2008 10:17:22 p.m.

Sample usage

Find a country by coordinates:

Using NHibernate:

Country country = session.CreateCriteria(typeof(Country))
    .Add(SpatialExpression.Contains("Boundaries", new Point(-70.40, -33.24)))
    .UniqueResult() as Country;

Using ActiveRecord:

Country country = Country.FindOne(
    SpatialExpression.Contains("Boundaries", new Point(-70.40, -33.24))
);

Find all the towns in a bounding box, except the one located at some coordinates:

Using NHibernate:

IList towns = session.CreateCriteria(typeof(Town))
    .Add(SpatialExpression.Filter("Boundaries", new Envelope(-70, -68, -32, -34)))
    .Add(Expression.Not(SpatialExpression.Contains("Boundaries", new Point(-70.40, -33.24))))
    .List();

Using ActiveRecord:

Town[] towns = Town.FindAll(
    SpatialExpression.Filter("Boundaries", new Envelope(-70, -68, -32, -34)),
    Expression.Not(SpatialExpression.Contains("Boundaries", new Point(-70.40, -33.24)))
);


The previous example just shows how to combine a spatial criterion (Contains) with a normal criterion (Not), but in this case we could use simply Disjoint.

Get states boundaries grouping counties by state:

Using ActiveRecord:

ProjectionQuery<County> query = new ProjectionQuery<County>(
    Projections.ProjectionList()
        .Add(Projections.GroupProperty("State"))
        .Add(SpatialProjections.Union("Boundaries"))
    );
IList<object[]> stateBoundaries= query.Execute();

Create a new vehicle GPS position:

Using NHibernate:

public void TrackVehicule(Vehicle vehicule, double longitude, double latitude, DateTime when)
{
    Tracking tracking = new Tracking();
    tracking.Vehicle = vehicle;
    tracking.Position = new Point(longitude, latitude);
    tracking.When = when;
    session.Save(tracking);
}

More, please!

You also will find lots of sample usage code in the tests project (Tests.NHibernate.Spatial). Check out:

CriteriaFixture.cs
ProjectionsFixture.cs
OgcSfSql11Compliance/ConformanceItemsFixture.cs
RandomGeometries/SpatialQueriesFixture.cs

Sample usage

Ricardo Stuven — Fri, 26 Sep 2008 21:35:40 GMT

Revision 1 posted to Spatial by Ricardo Stuven on 26/09/2008 06:35:40 p.m.

Find a country by coordinates:

Using NHibernate:

Country country = session.CreateCriteria(typeof(Country))
    .Add(SpatialExpression.Contains("Boundaries", new Point(-70.40, -33.24)))
    .UniqueResult() as Country;

Using ActiveRecord:

Country country = Country.FindOne(
    SpatialExpression.Contains("Boundaries", new Point(-70.40, -33.24))
);

Find all the towns in a bounding box, except the one located at some coordinates:

Using NHibernate:

IList towns = session.CreateCriteria(typeof(Town))
    .Add(SpatialExpression.Filter("Boundaries", new Envelope(-70, -68, -32, -34)))
    .Add(Expression.Not(SpatialExpression.Contains("Boundaries", new Point(-70.40, -33.24))))
    .List();

Using ActiveRecord:

Town[] towns = Town.FindAll(
    SpatialExpression.Filter("Boundaries", new Envelope(-70, -68, -32, -34)),
    Expression.Not(SpatialExpression.Contains("Boundaries", new Point(-70.40, -33.24)))
);


The previous example just shows how to combine a spatial criterion (Contains) with a normal criterion (Not), but in this case we could use simply Disjoint.

Get states boundaries grouping counties by state:

Using ActiveRecord:

ProjectionQuery<County> query = new ProjectionQuery<County>(
    Projections.ProjectionList()
        .Add(Projections.GroupProperty("State"))
        .Add(SpatialProjections.Union("Boundaries"))
    );
IList<object[]> stateBoundaries= query.Execute();

Create a new vehicle GPS position:

Using NHibernate:

public void TrackVehicule(Vehicle vehicule, double longitude, double latitude, DateTime when)
{
    Tracking tracking = new Tracking();
    tracking.Vehicle = vehicle;
    tracking.Position = new Point(longitude, latitude);
    tracking.When = when;
    session.Save(tracking);
}

More, please!

You also will find lots of sample usage code in the tests project (Tests.NHibernate.Spatial). Check out:

CriteriaFixture.cs
ProjectionsFixture.cs
OgcSfSql11Compliance/ConformanceItemsFixture.cs
RandomGeometries/SpatialQueriesFixture.cs