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

[spaetz]

On Mon, Sep 01, 2008 at 09:29:20AM -0500, Ian Dees wrote:
> 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.

Thanks for sharing looks good. I am sure people will be happy to help you with the minute diff file.

> 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.

Import speed is of no (well little) concern compared to map answering times, I would say.
 
> 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?

You can half your database space by dropping <tag k="created_by|tiger|ele|source|note"... (and perhaps a few more) username/user id is not required either. timestamps could be useful to see how old the data is, but I'd not cry if it weren't in the first version either.

spaetz