# KML polygons generator with attributes from PostGIS

# Sample data can be retrieve from http://professionnels.ign.fr/ficheProduitCMS.do?idDoc=6185461
# You have to choose "Télécharger GEOFLA® Départements (format Shapefile)"
# Direct link http://professionnels.ign.fr/DISPLAY/000/528/175/5281750/GEOFLADept_FR_Corse_AV_L93.zip
# Data restricted for non-commercial use

# You have to import them into PostGIS with shp2pgsql

You can use both python and php scripts to generate KML
  * kml_php.php
  * kml_python.py

You have some sql queries samples in postgis_kml_attributes.sql

You only need PostGIS and PHP or Python with this scripts.

For licence, see LICENCE.txt

#Alternatives

If you can install OGR/GDAL (http://www.gdal.org/), a short way to do the same can be
ogr2ogr -f KML output.kml PG:'host=localhost dbname=france user=user password=pass' -sql "SELECT * from departement"
Further about KML in OGR/GDAL http://www.gdal.org/ogr/drv_kml.html

You can for example embed the previous line with parameters in a python script using Subprocess http://docs.python.org/library/subprocess.html
or start to use gdal python for custom needs.

For PHP, you can use embed Exec command http://php.net/manual/fr/function.exec.php