[Tile-serving] [osm2pgsql] Broken geometries with -E 4326 projection. (#121)

[Ander]

I finally gave up using -E parameter for 4326 projection. I execute osm2pgsql in the default way and after reproject all tables:

SELECT UpdateGeometrySRID( 'planet_osm_point' , 'way' , 4326 );
SELECT UpdateGeometrySRID( 'planet_osm_line' , 'way' , 4326 );
SELECT UpdateGeometrySRID( 'planet_osm_polygon' , 'way' , 4326 );
...

UPDATE planet_osm_point SET way = ST_TRANSFORM( ST_SETSRID( way, 900913), 4326 );
UPDATE planet_osm_line SET way = ST_TRANSFORM( ST_SETSRID( way, 900913), 4326 );
UPDATE planet_osm_polygon SET way = ST_TRANSFORM( ST_SETSRID( way, 900913), 4326 );
...

---
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/121#issuecomment-64398007
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20141125/f198221e/attachment.html>