Balaton (Plattensee) drawing error about imposm3 HOT 6 CLOSED

Is the geometry missing in all waterareas tables or only the _genX.
Do you have an OSM ID of the geometry?

from imposm3.

Okay, here we are :-)

SELECT "id","osm_id","name","type","area","geometry" FROM "public"."osm_waterareas" WHERE "name" LIKE 'Plattensee'

310438 => 26735206
3995998 => 168361423

SELECT "osm_id","geometry","name","type","area" FROM "public"."osm_waterareas_gen1" WHERE "name" LIKE 'Plattensee'

26735206
168361423

Data in gen0 not found (too small).

from imposm3.

On 03.02.2014, at 13:05, tds4u wrote:

Okay, here we are :-)

SELECT "id","osm_id","name","type","area","geometry" FROM "public"."osm_waterareas" WHERE "name" LIKE 'Plattensee'

310438 => 26735206
3995998 => 168361423

And these are the geometries that are not rendered?
You can check the IDs on OSM: http://www.openstreetmap.org/way/12345 or http://www.openstreetmap.org/relation/12345

Can you check if the geometries make sense (ST_IsValid, ST_IsSimple, ST_Area)?

from imposm3.

Ah, sorry, searched wrong name (Plattensee instead of Balaton). Right
ist http://www.openstreetmap.org/relation/1638031 = reservoir. But still
not displayed.

=> Should be correct

SELECT "id","osm_id","name","type","area","geometry",
ST_AsText(geometry) FROM "public"."osm_waterareas" WHERE "name" = 'Balaton'

=> Polygon from WMS BoundingBox => no visible Balaton as name

SELECT "osm_id","name","type","area","geometry" FROM
"public"."osm_waterareas_gen1"
WHERE ST_Intersects(ST_GeomFromText('POLYGON((
1956787.9268898 5948635.2920548,
1956787.9268898 5909499.5335728,
1995923.6853718 5909499.5335728,
1956787.9268898 5909499.5335728,
1956787.9268898 5948635.2920548
))', '3857'), geometry)
ORDER BY name

Is there a mistake or why no correct results returned? Small basins
inside are there but not the big one.

MfG M. Martin

Am 04.02.2014 10:27, schrieb Oliver Tonnhofer:

On 03.02.2014, at 13:05, tds4u wrote:

Okay, here we are :-)

SELECT "id","osm_id","name","type","area","geometry" FROM
"public"."osm_waterareas" WHERE "name" LIKE 'Plattensee'

310438 => 26735206
3995998 => 168361423

And these are the geometries that are not rendered?
You can check the IDs on OSM: http://www.openstreetmap.org/way/12345
or http://www.openstreetmap.org/relation/12345

Can you check if the geometries make sense (ST_IsValid, ST_IsSimple,
ST_Area)?

—
Reply to this email directly or view it on GitHub
#18 (comment).

from imposm3.

Ok, the relation is broken. See:
http://analyser.openstreetmap.fr/cgi-bin/index.py?relation=1638031
The end node 2607089288 of way http://www.openstreetmap.org/way/232147389 is not connected.

Not sure what magic osm2pgsql does do get a geometry out of that.

from imposm3.

Have to say that the same problem is on other geometries, too. Like natural polygons (forrest, etc.). Fix should be important.

from imposm3.