[OSM-talk] Weather overlay

John Smith delta_foxtrot at yahoo.com
Fri Aug 21 16:45:29 BST 2009


--- On Sat, 22/8/09, Jon Burgess <jburgess777 at 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.


      




More information about the talk mailing list