Doctrine2 multi-platform support for spatial types and functions

5.0.1 2024-05-29 11:44 UTC



Doctrine-spatial is a doctrine extension. It implements spatial types and functions. As exemple, this extension can help you to know if your favorite superheroes is inside Gotham city.

Currently, MySQL and PostgreSQL with PostGIS are supported. Could potentially add support for other platforms if an interest is expressed.

Current status

longitude-one/doctrine--spatial Stable release Minimum PHP Version Packagist License

Last integration test Maintainability Downloads Test Coverage Documentation Status


The documentation explain how to:

  • install this doctrine extension,
  • configure this extension,
  • create spatial entities,
  • use spatial functions in your repositories,
  • contribute (and test)

The documentation contains a glossary of all available types and all available spatial functions.

Project origins

This useful library was created by Derek J. Lambert. Alexandre Tranchant forked it from creof/doctrine-spatial because project seems to be non-active since 2017.

The dev branch can be used, but be careful backward compatibility aren't warrantied. The main branch is dedicated to fix issue in the last stable version.



This doctrine extension is compatible with PHP 8.1+ Security fixes will follow the PHP Roadmap.

MySQL 5.7 and 8.0

MySQL5.7 is supported, but is deprecated. MySQL8.0 is supported.


This spatial library is compatible with PostgreSql. This library is tested with the last versions of Postgis and PostgreSql.

Help wanted

RFC I don't have enough money to buy the last edition of the ISO/IEC 13249-3:2016. I only bought the previous version. This document is essential to know which functions are in Standard and which one are specific to a database engine. If anyone has bought one and don't use it anymore, feel free to forward it. You can contact me by mail, specified in composer.json.

Microsoft SQL Server I'm searching help to create a docker delivering a Microsoft SQL Server service. So I'll be able to implement compatibility with this database server.

MariaDB I'm searching help to create a Github action delivering a MariaDB service, to launch test and determine if this library is compatible.