Hi again everybody! I am trying to implement the post-processing solution: removing all records in *planet_osm_ways* that are completely outside my bounding box. For this I first need to find out all the nodes outside the bounding box...
The problem is that the x and y coordinates of *planet_osm_nodes* seem to be plenty wrong. My first record, for instance, has lat = 450768421 lon = 796483777 I assume that these are in srid 900913 but, if they are, they are way outside the limits of the 900913 srs. Actually, I just realised that they are systematically wrong by a factor 100. The correct coordinates should be something like: lat = 4507684 lon = 7964837 Have I done something wrong? or is there a known (or unknown?) bug with osm2pgsql? The geometries of the "useful" tables (line, point, polygon, roads) seem correct, but the x/y columns of the temporary tableshave this problem... Cheers Stéphane -- "Le mot progrès n'aura aucun sens tant qu'il y aura des enfants malheureux" -- Albert Einstein "A journey does not need reasons. Before long, it proves to be reason enough in itself. One thinks that one is going to make a journey, yet soon it is the journey that makes or unmakes you." -- Nicolas Bouvier Photos de voyages, photos de montagne: http://www.henriod.info On Wed, Sep 5, 2012 at 5:25 PM, Ramas <[email protected]> wrote: > You can check tool osmupdate which has option to clip data outside > boundaries. > http://wiki.openstreetmap.org/wiki/Osmupdate#Applying_Geographical_Borders > > On 5 September 2012 16:06, Stéphane Henriod <[email protected]> wrote: > >> thanks for your anwers! >> >> But it looks like I have a problem now... >> >> 1. I need to keep the tables ways, rels and nodes because of the diff >> updates >> 2. Those 3 tables will continue growing up with each new diff, until >> I reach the storage capacity of the server >> >> The only solution I see is a post-processing that will erase from PostGIS >> all the nodes lying outside my bounding box + all the ways using one of >> thses nodes + all the relations using one of thses nodes or one of these >> ways. >> >> Except if anyone else has a magical solution... >> >> >
_______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
