[OSM-dev] amazon AMIs for a full blown openstreetmap.org-like server

[Stefan de Konink]

Op 08-01-10 13:49, jamesmikedupont at 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