[GIS] Convert a shapefile to GeoJSON with PHP

geojsonPHP

Is there a method in PHP to covert a shapefile to GeoJSON? I need to upload shapefile and load it into a PostgreSQL table. I tried PHP exec(), but it didn't work.

Best Answer

PHP exec() should work, what error do you get? And what commands/utilities are you using to convert?

For example with ogr2ogr:

$command = "/usr/bin/ogr2ogr -f GeoJSON output.geojson input.shp";
exec($command);

You should use escapeshellarg if any of these params are coming from user input

Related Solutions

[GIS] Problem with loading GeoJSON file in OpenLayers generated by PHP

Your generated GeoJSON is valid JSON, no problem. But, it's not valid GeoJson, as you can see here: http://geojsonlint.com/

The problem seems to be that the features-array in your featurecollection contains three features, two with geometry:none and one with just geometry (which is also string-encoded).

So, in short: Your OpenLayers-code seems fine, the trouble is your PHP-code that generates the GeoJSON.

Shapefile PostgreSQL PHP – How to Store Shapefile in PostgreSQL Database as a Table Using PHP

I experienced exactly the same problem (command works in cmd but nothing when called via PHP). What helped me a lot was to retrieve the error message (by adding: 2>&1'& $output). MY command looked something like:

?php
exec("\"C:\Program Files\PostgreSQL\9.6\bin\shp2pgsql.exe\" -s 28992 -I -W 
latin1 D:\somefolder\someshape.shp someschema.example_shape | psql -U postgres -h localhost -d somedbname 2>&1", $output);
foreach ($output as $key => $value)
{echo $value;}
?>

It returned "'psql' is not recognized as an internal or external command,operable program or batch file." My fix was to define the full path of the psql executable in the command like this:

<?php
exec("\"C:\Program Files\PostgreSQL\9.6\bin\shp2pgsql.exe\" -s 28992 -I -W 
latin1 D:\somefolder\someshape.shp someschema.example_shape | \"C:\Program 
Files\PostgreSQL\9.6\bin\psql.exe\" -U postgres -h localhost -d somedbname");
?>

Best Answer

Related Solutions

[GIS] Problem with loading GeoJSON file in OpenLayers generated by PHP

Shapefile PostgreSQL PHP – How to Store Shapefile in PostgreSQL Database as a Table Using PHP

Related Question