Lars Francke schrieb:
> Hier was ich gemacht habe (auf dem Osmosis-Schema)d
> SELECT AddGeometryColumn('ways', 'line', 4326, 'LINESTRING', 2);
> UPDATE ways w SET line = (SELECT st_makeline(geom) FROM (SELECT geom
> FROM nodes n, way_nodes wn WHERE w.id = wn.way_id AND n.id =
> wn.node_id ORDER BY wn.sequence_id) AS foo);
> CREATE INDEX idx_way_line ON ways USING GIST (line);

Danke, da muss ich mich mal reinhängen.

_______________________________________________
Talk-de mailing list
[email protected]
http://lists.openstreetmap.org/listinfo/talk-de

Antwort per Email an