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 [EMAIL PROTECTED] 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 _______________________________________________ Tilesathome mailing list [email protected] http://lists.openstreetmap.org/listinfo/tilesathome
