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

[jamesmikedupont at googlemail.com]

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 <stefan at konink.de> wrote:
> 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
>
>
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> http://lists.openstreetmap.org/listinfo/dev
>