[Tilesathome] setting up the api was: [OSM-dev] t at h API still turn off...

[Ian Dees]

On Mon, Sep 1, 2008 at 8:29 AM, spaetz <osm at sspaeth.de> wrote:

>
> I don't know if Ian Dees is implementing an API solution or whether he
> works on the database side of things...
>
>
My current work is here: http://svn.yellowbkpk.com/geo/

I'm using http://svn.yellowbkpk.com/geo/osm_to_mysql.py to do the planet ->
MySQL import, the http://svn.yellowbkpk.com/geo/planet.sql schema is what
I'm importing into, and http://svn.yellowbkpk.com/geo/bbox.php is what
performs the map HTTP request.

The minutely diff import is a missing piece, and should be fairly easy to
augment into my osm_to_mysql.py script.

The most important part is the spatial indexes on both the node and way data
types. This significantly improves the bbox.php MySQL calls, but it takes
more storage in the DB and longer to import.

Also, I'm thinking about getting rid of the username/userid tracking in the
database. This would save several gigabytes of storage in the database and I
don't think t at h uses it for rendering at this point, right?

-Ian
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tilesathome/attachments/20080901/2159f9eb/attachment.html>