Hi all,
My name is Markus and I am doing my bachelor thesis on an OpenStreetMap Routing
topic.
Therefore I use a postGIS db to store the osm data. Actually I have a dump of
the data of Germany.
For my routing I cache areas. These areas I access like this:
SELECT id, version, tags, nodes FROM ways WHERE linestring &&
ST_SetSRID('BOX3D(9.00000000 50.0000000, 9.005000 50.0050000)'::box3d,4326)
AND(
'highway=>motorway'::hstore <@
tags
OR
'highway=>motorway_link'::hstore <@ tags
OR 'highway=>trunk'::hstore <@
tags
OR
'highway=>trunk_link'::hstore <@ tags
OR 'highway=>primary'::hstore
<@ tags
OR
'highway=>primary_link'::hstore <@ tags
OR 'highway=>secondary'::hstore
<@ tags
OR
'highway=>secondary_link'::hstore <@ tags
OR 'highway=>tertiary'::hstore
<@ tags
OR
'highway=>unclassified'::hstore <@ tags
OR
'highway=>residential'::hstore <@ tags
OR
'highway=>living_street'::hstore <@ tags
);
The x and y of the box3d variate but every time have the same range of 0.005.
Linestring is the gist index. I did a Vacuum.
Table (ways) has 9040062 rows.
In my oppinion, the query is still slow. So my question to you is: Is this the
best way to cache such an area of ways or is there an faster alternative?
Best regards,
Markus Hens
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
