Doctrine2 multi-platform support for spatial types and functions. Currently MySQL and PostgreSQL with PostGIS are supported. Could potentially add support for other platforms if an interest is expressed.
This package is a refactor/continuation of my doctrine2-mysql-spatial package.
The following SQL/OpenGIS types have been implemented as PHP objects and accompanying Doctrine types:
- Point
- LineString
- Polygon
- MultiPoint
- MultiLineString
- MultiPolygon
Similar to Geometry but SRID value is always used (SRID supported in PostGIS only), and accepts only valid "geographic" coordinates.
- Point
- LineString
- Polygon
- GeometryCollection
- 3D/4D geometries ??
- Rasters ??????
There is support for both WKB/WKT and EWKB/EWKT return values. Currently only WKT/EWKT is used in statements.
Currently the following SQL functions are supported in DQL (more coming):
- ST_Area
- ST_AsBinary
- ST_AsText
- ST_Centroid
- ST_ClosestPoint
- ST_Contains
- ST_ContainsProperly
- ST_CoveredBy
- ST_Covers
- ST_Crosses
- ST_Disjoint
- ST_Distance
- ST_Envelope
- ST_GeomFromText
- ST_Length
- ST_LineCrossingDirection
- ST_StartPoint
- ST_Summary
- Area
- AsBinary
- AsText
- Contains
- Disjoint
- Envelope
- GeomFromText
- GLength
- MBRContains
- MBRDisjoint
- StartPoint
If you're using Doctrine with Symfony2 take a look at INSTALL.md, otherwise the OrmTest.php test class shows their use with Doctrine alone.
A DQL AST walker is included which when used with the following DQL functions will return the appropriate Geometry type object from queries instead of strings:
- AsText
- ST_AsText
- AsBinary
- ST_AsBinary
EWKT/EWKB function support planned.
$query = $this->em->createQuery('SELECT AsText(StartPoint(l.lineString)) MyLineStringEntity l');
$query->setHint(Query::HINT_CUSTOM_OUTPUT_WALKER, 'CrEOF\Spatial\ORM\Query\GeometryWalker');
$result = $query->getResult();
$result[n][1] will now be of type Point instead of the string 'POINT(X Y)'