Easily store GeoJSON in a SQL database

dev-master 2015-01-20 10:35 UTC

This package is auto-updated.

Last update: 2023-03-13 17:48:32 UTC


A PHP library for moving data between database and standard output formats (e.g. GeoJSON and KML).

Initially created just as a wrapper to take GeoJSON data and input into a database.


php composer.phar require m1ke/geojson-sql


Written by Mike Lehan and StuRents.com.


  • For GeoJsonSql
    • process_and_save() Returns the $polygon array formatted for inclusion in a query. Also accepts a PDO statement if you want to save in a database.
    • process_with_query(PDO $db,$table,$name) Creates a PDO query with a single value which is replaced with the polygon
  • For SqlGeo
    • search_json(Array $where) Returns a JSON string based on the submitted query e.g. ['item_id' => 25]


For GeoJsonSql:

require __DIR__.'/vendor/autoload.php';

$db=new PDO('mysql:host=localhost;dbname=database','user','pass');


$geojson = new GeoJsonSql($file_name);

For SqlGeo:

require __DIR__.'/vendor/autoload.php';

$db=new PDO('mysql:host=localhost;dbname=geospatial','root','');

$sqljson=new SqlGeo($db,'table','polygon_field');
echo $sqljson->search_json(['title'=>'Polygon Title']);