Op 08-01-10 13:49, [email protected] 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 [email protected] http://lists.openstreetmap.org/listinfo/dev
