I have been working on c++ code with rtrees and other nice things. depending on what you want to do with it, I think it is fair to make updates very slow if the rendering is very fast... mike
On Fri, Jan 8, 2010 at 2:39 PM, Stefan de Konink <ste...@konink.de> wrote: > Op 08-01-10 13:49, jamesmikedup...@googlemail.com schreef: >> I would like to have an account. >> >> We could try out some ideas for replacing the database with a lot of >> small files. > > We could just switch to MonetDB get deduplication, and don't require a > lot of space ;) > > ...in other news did anyone try SphinxSearch on OSM data? Since I > dislike PostgreSQL's geo-non-indiced functionality. Hence: an index on > IsValid(...) is not materialised, I wonder if anyone succesfully applied > stuff like: > > select planet_osm_point.osm_id, planet_osm_polygon.name, > planet_osm_point.name from planet_osm_point, planet_osm_polygon where > ST_Intersects(planet_osm_point.way, planet_osm_polygon.way) and > planet_osm_polygon.name <> '' and planet_osm_point.name <> '' and > planet_osm_polygon.name <> planet_osm_point.name; > > sql_query = select planet_osm_roads.osm_id, planet_osm_polygon.name, > planet_osm_roads.name from planet_osm_roads, planet_osm_polygon where > st_isvalid(planet_osm_roads.way) AND st_isvalid(planet_osm_polygon.way) > AND ST_Intersects(planet_osm_roads.way, planet_osm_polygon.way) and > planet_osm_polygon.name <> '' and planet_osm_roads.name <> '' and > planet_osm_polygon.name <> planet_osm_roads.name; > > sql_query = select p2.osm_id, p1.name, p2.name from planet_osm_polygon > as p2, planet_osm_polygon as p1 where ST_Intersects(p1.way, p2.way) and > p1.name <> '' and p2.name <> '' and p1.name <> p2.name; > > > Stefan > > ps. TomH thanks for the comment on IRC :D > > > _______________________________________________ > dev mailing list > dev@openstreetmap.org > http://lists.openstreetmap.org/listinfo/dev > _______________________________________________ dev mailing list dev@openstreetmap.org http://lists.openstreetmap.org/listinfo/dev