Re: [OSM-dev] Extracting data for testing low scale rendering
W dniu 13.07.2015 19:28, Paul Norman napisał(a): Import on a more powerful machine, delete unwanted data, re-sort/re-cluster tables, and pg_dump with -Z 9. That's what I did with https://lists.openstreetmap.org/pipermail/dev/2015-July/028625.html Great, thanks! 1. I'm not familiar with databases, how should I restore it? I try with just: $ pg_restore --dbname=gis -O --verbose planet-lz-150202.dump I gave -O, because it was complaining that role "pnorman" does not exist (of course), but I'm not sure if it will work and more guessing and repeating this import would be tedious. 2. Could you also publish exact script/commands you have used to create it? For low zoom levels testing this dump should be enough for some time, but it would be good to know how to create a newer version. -- "The train is always on time / The trick is to be ready to put your bags down" [A. Cohen] ___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Extracting data for testing low scale rendering
On 7/13/2015 5:41 AM, Daniel Koć wrote: Hi, I'd like to know how to extract from planet.osm only the features visible on 1-6 or even 1-7 levels in osm-carto (default OSM style). Mateusz Konieczny has already tried to do something like this, but hit the wall at the moment: http://forum.openstreetmap.org/viewtopic.php?pid=514998#p514998 If anyone can help us with it in any way, we would appreciate it a lot. It would be very useful for massive testing of proposed highway rendering changes and general low scale rendering problems. Import on a more powerful machine, delete unwanted data, re-sort/re-cluster tables, and pg_dump with -Z 9. That's what I did with https://lists.openstreetmap.org/pipermail/dev/2015-July/028625.html I got it down from 100GB to 50GB in-database, 25GB compressed pg_dump. This is about the same download size as the planet. You could probably get father by dropping small polygons or buildings with addresses ___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev
Re: [OSM-dev] Extracting data for testing low scale rendering
On Monday 13 July 2015, Daniel Koć wrote: > > I'd like to know how to extract from planet.osm only the features > visible on 1-6 or even 1-7 levels in osm-carto (default OSM style). > Mateusz Konieczny has already tried to do something like this, but > hit the wall at the moment: > > http://forum.openstreetmap.org/viewtopic.php?pid=514998#p514998 > > If anyone can help us with it in any way, we would appreciate it a > lot. It would be very useful for massive testing of proposed highway > rendering changes and general low scale rendering problems. With the default style for z=1-5 this should be fairly easy, for z=6 and above the volume of data required will increase massively since you need all water areas. Filtering for the following will probably get you all you need for z=1-5 and will not get you too much you do not need: admin_level=* highway=motorway, highway=trunk place=city, capital=* -- Christoph Hormann http://www.imagico.de/ ___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev
[OSM-dev] Extracting data for testing low scale rendering
Hi, I'd like to know how to extract from planet.osm only the features visible on 1-6 or even 1-7 levels in osm-carto (default OSM style). Mateusz Konieczny has already tried to do something like this, but hit the wall at the moment: http://forum.openstreetmap.org/viewtopic.php?pid=514998#p514998 If anyone can help us with it in any way, we would appreciate it a lot. It would be very useful for massive testing of proposed highway rendering changes and general low scale rendering problems. -- "The train is always on time / The trick is to be ready to put your bags down" [A. Cohen] ___ dev mailing list dev@openstreetmap.org https://lists.openstreetmap.org/listinfo/dev
