Hello Jukka,
that looks very interesting! Thanks a lot! With a query like: select * from planet_osm_line where boundary is not null and name like 'Schleswig%' LIMIT 100; I get exactly one entry with heaps of data, seems it represents Schleswig- Holstein, a federal state. Seems it needs some refinement, it doesn't seem to work for "Bayern" or some others. But those seem to be in "planet_osm_polygon" then. Is there a way to create a ShapeFile from these data? Or something i can import into QGIS? Thanks a lot, Torsten. Am Donnerstag, 7. Mai 2009 08:15:14 schrieb Jukka Rahkonen: > Torsten Mohr <tmohr <at> s.netic.de> writes: > > Hello, > > > > this issue is not related to another post that i did here regarding the > > outline of the world (shoreline_300). > > > > I want to create a map of Germany with many details, especially the > > federal states should have different background colors. > > > > I got a hint already for a ShapeFile that contains these data. That file > > looked great, but the borderlines defined in there are _much_ more coarse > > than the data in the PostGIS, so creating the background from the > > rough, coarse data does not look that good. It does not match the > > borders that are drawn. > > > > Is there a way to get the border information from the PostGIS server > > that runs locally on my machine? > > Hi, > > Import osm data into PostGIS with osm2pgsql utility and query borders with > SQL query like > SELECT * FROM osm_line WHERE admin_level is not null; > > At least in the Finnish data excerpt the borders are lines. For making > coloured areas border lines must first be converted to polygons. Last step > is to draw the states with different colours for example by adding a > single value theme looking at state name etc. All this can be done with > OpenJUMP, QGis, uDig, gvSIG etc. > > > _______________________________________________ > talk mailing list > [email protected] > http://lists.openstreetmap.org/listinfo/talk _______________________________________________ talk mailing list [email protected] http://lists.openstreetmap.org/listinfo/talk
