--- On Sat, 22/8/09, Jon Burgess <jburgess...@googlemail.com> wrote: > One possibility is: > > ogr2ogr -f "KML" admin.kml PG:"dbname=gis" -sql "select > name,transform(ST_ExteriorRing(way),4326) from > planet_osm_polygon where boundary='administrative' and > "admin_level"='10'"
I get the following error and have no idea how to get round/past it: ERROR 1: ERROR: AddToPROJ4SRSCache: Cannot find SRID (4326) in spatial_ref_sys > postgis also has an AsKML() function but this does not > appear to create > a complete KML document. It outputs the geometry data with > no styling. I found that as well, but couldn't figure out how to make use of it. _______________________________________________ talk mailing list talk@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk