[fdo-users] Creating a spatial filter

Dan Stoica dan.stoica at autodesk.com
Mon Dec 10 10:16:23 EST 2007


In general when in doubt or looking for snippets, your best bet is the unit tests. At least this is my approach :-)

Dan.

-----Original Message-----
From: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of simon hope
Sent: Sunday, December 09, 2007 3:08 PM
To: fdo-users at lists.osgeo.org
Subject: RE: [fdo-users] Creating a spatial filter


Gavin,

Thanks for the advice that worked - here is the code for completeness:

            //set the geometry fields
            qryPropName = new OSGeo.FDO.Expression.Identifier("shape");

            //create a geometry from a poly
            poly =
(OSGeo.FDO.Geometry.IPolygon)geomFactory.CreateGeometry("POLYGON((176954.045
5914119.79, 1769564.823 5914473.302, 1770089.64 5914474.08, 1770091.198
5914117.454, 176954.045 5914119.79))");
            geom = geomFactory.CreateGeometry(poly);

            //create the byte array required to create the expression
            byteArray = geomFactory.GetFgf(geom);
            OSGeo.FDO.Expression.GeometryValue qryGeomVal = new
OSGeo.FDO.Expression.GeometryValue(byteArray);

            //create the filter
            OSGeo.FDO.Filter.Filter fltr;
            fltr = new OSGeo.FDO.Filter.SpatialCondition(qryPropName,
OSGeo.FDO.Filter.SpatialOperations.SpatialOperations_Intersects,
qryGeomVal);

            //set the filter on the query command
            qrySelect.SetFilter(fltr.ToString());

Cheers

Simon


Gavin Cramer wrote:
>
> Hi, Simon.  Instead of GetWkb, use GetFgf.  FGF is the binary storage
> format for FDO geometries.
>
> Gavin
>
>
> -----Original Message-----
> From: fdo-users-bounces at lists.osgeo.org
> [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of simon hope
> Sent: Tuesday, December 04, 2007 9:44 PM
> To: fdo-users at lists.osgeo.org
> Subject: RE: [fdo-users] Creating a spatial filter
>
>
> Hi Dan,
>
> I tried the following:
>
>             //set the geometry fields
>             qryPropName = new OSGeo.FDO.Expression.Identifier("shape");
>
>             //create a geometry from a poly
>             poly =
> (OSGeo.FDO.Geometry.IPolygon)geomFactory.CreateGeometry("POLYGON((176954.045
> 5914119.79, 1769564.823 5914473.302, 1770089.64 5914474.08, 1770091.198
> 5914117.454, 176954.045 5914119.79))");
>             geom = geomFactory.CreateGeometry(poly);
>
>             //create the byte array required to create the expression
>             byteArray = geomFactory.GetWkb(geom);
>             OSGeo.FDO.Expression.GeometryValue qryGeomVal = new
> OSGeo.FDO.Expression.GeometryValue(byteArray);
>
>             //create the filter
>             OSGeo.FDO.Filter.Filter fltr;
>             fltr = new OSGeo.FDO.Filter.SpatialCondition(qryPropName,
> OSGeo.FDO.Filter.SpatialOperations.SpatialOperations_Intersects,
> qryGeomVal);
>
>             //set the filter on the query command
>             qrySelect.SetFilter(fltr.ToString());
>
> And I get the same issue - I also tried creating the byteArray directly
> from
> the poly object i.e.
>
> byteArray = geomFactory.GetWkb(poly);
>
> But i get the same message - is it advisable to use this method to create
> polygons? i.e from a WKT or is it better to use LinearRings?
>
> Cheers
>
> Simon
>
>
> Dan Stoica wrote:
>>
>> Hi,
>>
>> Use a IPolygon instead of IEnvelope.
>>
>> Dan.
>>
>> -----Original Message-----
>> From: fdo-users-bounces at lists.osgeo.org
>> [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of simon hope
>> Sent: Tuesday, December 04, 2007 2:08 AM
>> To: fdo-users at lists.osgeo.org
>> Subject: [fdo-users] Creating a spatial filter
>>
>>
>> Hello,
>>
>> I'm attempting to create a spatial filter against an SDE FeatureClass.
>> I'm
>> hitting a problem with the code below:
>>
>>             byte[] byteArray;
>>             OSGeo.FDO.Geometry.IGeometry geom;
>>             OSGeo.FDO.Geometry.IEnvelope env;
>>             OSGeo.FDO.Geometry.FgfGeometryFactory geomFactory = new
>> OSGeo.FDO.Geometry.FgfGeometryFactory();
>>             OSGeo.FDO.Expression.Identifier qryPropName;
>>
>>             try
>>             {
>>
>>             //set the geometry fields
>>             qryPropName = new OSGeo.FDO.Expression.Identifier("shape");
>>
>>             //create a geometry from an envelope
>>             env =
>> geomFactory.CreateEnvelopeXY(1765068.119,5916635.233,1765756.4,5917101.847);
>>             geom = geomFactory.CreateGeometry(env);
>>
>>             //create the byte array required to create the expression
>>             byteArray = geomFactory.GetWkb(geom);
>>             OSGeo.FDO.Expression.GeometryValue qryGeomVal = new
>> OSGeo.FDO.Expression.GeometryValue(byteArray);
>>
>>             //create the filter
>>             OSGeo.FDO.Filter.Filter fltr;
>>             fltr = new OSGeo.FDO.Filter.SpatialCondition(qryPropName,
>> OSGeo.FDO.Filter.SpatialOperations.SpatialOperations_Intersects,
>> qryGeomVal);
>>
>>             //set the filter on the query command
>>             qrySelect.SetFilter(fltr.ToString());
>>
>>             }
>>             catch (Exception ex)
>>             {
>>                 throw new Exception(ex.ToString());
>>             }
>>             finally
>>             {
>>                 //todo clean up
>>             }
>>
>> the code falls over when i try and SetFilter - giving me an error:
>> {"'FdoFgfGeometryFactory::CreateGeometryFromFgf': Unknown geometry type
>> '769' discovered. "}
>>
>> I've managed to create attribute filters, and have tried to follow that
>> pattern for a spatial filter - should I be creating a specific geometry
>> type?
>>
>> Any ideas?
>>
>> Cheers
>>
>> Simon
>> --
>> View this message in context:
>> http://www.nabble.com/Creating-a-spatial-filter-tf4941500s18162.html#a14145736
>> Sent from the fdo-users mailing list archive at Nabble.com.
>>
>> _______________________________________________
>> fdo-users mailing list
>> fdo-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/fdo-users
>> _______________________________________________
>> fdo-users mailing list
>> fdo-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/fdo-users
>>
>>
>
> --
> View this message in context:
> http://www.nabble.com/Creating-a-spatial-filter-tf4941500s18162.html#a14164229
> Sent from the fdo-users mailing list archive at Nabble.com.
>
> _______________________________________________
> fdo-users mailing list
> fdo-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-users
> _______________________________________________
> fdo-users mailing list
> fdo-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-users
>
>

--
View this message in context: http://www.nabble.com/Creating-a-spatial-filter-tp14145736s18162p14242581.html
Sent from the fdo-users mailing list archive at Nabble.com.

_______________________________________________
fdo-users mailing list
fdo-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/fdo-users


More information about the fdo-users mailing list