--- On Fri, 21/8/09, Peter Körner osm-li...@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
xplanet can download cloud images and overlay them onto a map/globe
http://xplanet.sourceforge.net/
it just needs an OSM world-map image in plate-carre format to use as
the ground image, and you'd have a cloud map.
On Thu, Aug 20, 2009 at 2:05 PM, Peter Körnerosm-li...@mazdermind.de wrote:
On Fri, 2009-08-21 at 10:50 +, John Smith wrote:
--- On Fri, 21/8/09, Peter Körner osm-li...@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
I'm currently playing with the PostGIS Queries, too. I tried sth. like
SELECT osm_id, name
FROM planet_osm_polygon
WHERE boundary='administrative' AND
ST_Within(way, (SELECT way FROM planet_osm_polygon WHERE
boundary='administrative' AND admin_level='2' AND name='Deutschland'
LIMIT
admin_level=2 is country level, 4 and lower for state and regional boundaries.
I'm aware of that and the admin_level=2 is only used in the subquery to
determine the boundary of germany. The main query runs without a
admin_level-condition, only with boundary='administrative', does it?
Peter
--- On Sat, 22/8/09, John Smith delta_foxt...@yahoo.com wrote:
ERROR 1: ERROR: AddToPROJ4SRSCache: Cannot find SRID
(4326) in spatial_ref_sys
nm, found this:
psql gis /usr/share/postgresql-8.3-postgis/spatial_ref_sys.sql
Then run this SQL query:
INSERT into spatial_ref_sys (srid,
--- On Sat, 22/8/09, Peter Körner osm-li...@mazdermind.de wrote:
I'm aware of that and the admin_level=2 is only used in the
subquery to determine the boundary of germany. The main
query runs without a admin_level-condition, only with
boundary='administrative', does it?
What boundaries are
John Smith schrieb:
--- On Sat, 22/8/09, Peter Körner osm-li...@mazdermind.de wrote:
I'm aware of that and the admin_level=2 is only used in the
subquery to determine the boundary of germany. The main
query runs without a admin_level-condition, only with
boundary='administrative', does it?
John Smith schrieb:
--- On Sat, 22/8/09, Peter Körner osm-li...@mazdermind.de wrote:
Any :) I'm just getting started. I tried to find any
boundaries in a given Area, in this case in Germany.
Leave admin_level= out of the query
Thank you for the hint :)
Please take a look at my query,
--- On Sat, 22/8/09, Peter Körner osm-li...@mazdermind.de wrote:
boundary='administrative' AND admin_level='2'
AND name='Deutschland'
LIMIT 1) )
to get all boundaries in germany but i only get Aachen [1]
and Deutschland [2] back. Any idea?
admin_level=2 is country level, 4 and
--- 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
--- On Sat, 22/8/09, Peter Körner osm-li...@mazdermind.de wrote:
Any :) I'm just getting started. I tried to find any
boundaries in a given Area, in this case in Germany.
Leave admin_level= out of the query
___
talk mailing list
John Smith schrieb:
--- On Sat, 22/8/09, Jon Burgess jburgess...@googlemail.com wrote:
This admin.kml loads up fine in GoogleEarth and the
boundaries appear as lines.
Thanks for your help, just admin_level=10 information for only the Australia
region is 186M uncompressed and 76M when
--- On Sat, 22/8/09, Jon Burgess jburgess...@googlemail.com wrote:
This admin.kml loads up fine in GoogleEarth and the
boundaries appear as lines.
Thanks for your help, just admin_level=10 information for only the Australia
region is 186M uncompressed and 76M when zipped.
Will have to come
--- On Sat, 22/8/09, Peter Körner osm-li...@mazdermind.de wrote:
I thought of this before and that's why I would suggest to
do it with mapnik mod_tiles or so (as is said in my
initial posting).
I currently do, but I was hoping to avoid needing 2 tile sets just for showing
the admin_level=10
--- On Sat, 22/8/09, Peter Körner osm-li...@mazdermind.de wrote:
Thank you for the hint :)
I really shouldn't be emailing when tired...
The second should fetch the border of Germany and the first
one all boundaries in that. At least that's what I want it
to do :)
I just ran that query on
Has anyone ever made an whether-overlay for openstreetmap using the
Google [1] or the Yahoo API [2]? I think this would be possible with mapnik:
* load a planet.osm into some kind of db (or process it in-place with
a sax-parser)
* find the regions with ZIP, PLZ or whatever
* fetch the
On Thu, 20 Aug 2009 15:05:02 +0200, Peter Körner osm-li...@mazdermind.de
wrote:
Has anyone ever made an whether-overlay for openstreetmap using the
Google [1] or the Yahoo API [2]?
Probably not exactly what you're after, but you might find this
interesting:
maybe you could skip the complete db and make a dynamic kml layer (by using
a php file that outputs xml) in openlayers
Rob
2009/8/20 Peter Körner osm-li...@mazdermind.de
Has anyone ever made an whether-overlay for openstreetmap using the
Google [1] or the Yahoo API [2]? I think this would be
--- On Fri, 21/8/09, Rob r...@coolbegin.com wrote:
maybe you could skip the complete db and
make a dynamic kml layer (by using a php file that outputs
xml) in openlayers
Any suggestions on exporting admin boundaries from a database to kml format?
Any suggestions on exporting admin boundaries from a database to kml format?
If you have some kind of database anyway (e.g. postgis for
mapnik-rendering on cassini, it shouldn't be the problem. You may also
try query2map [1]. If none of this works for you, you may consider
processing a
21 matches
Mail list logo