[OSM-talk] Weather overlay

[Jon Burgess]

On Fri, 2009-08-21 at 10:50 +0000, John Smith wrote:
> --- On Fri, 21/8/09, Peter Körner <osm-lists at mazdermind.de> wrote:
> 
> > If you have some kind of database anyway (e.g. postgis for
> > mapnik-rendering on cassini, it shouldn't be the problem.
> 
> I have a suitable query, I just don't know how to turn the query into kml data, such as lines.
> 
> select way from planet_osm_polygon where boundary='administrative' and "admin_level"='10'


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'"

This admin.kml loads up fine in GoogleEarth and the boundaries appear as lines.

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.

	Jon