On Mon, Sep 01, 2008 at 06:14:58PM +0200, spaetz wrote: > 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.
Please don't rip out quite that much, I imagine it will be some pain to re-add them, so we should probably start off with not filtering too hard. First, I think mapnik renders ele on mountains now, we might want do the same. Also I've been thinking about how to add note rendering to maplint. I think I know how, just need some spare time... There are some other bulk-import tags that can probably be safely dropped though, the maplint not-in-map_features script ignores these: tiger: AND_ AND: gns: massgis: openGeoDB: opengeodb: -- Knut Arne Bjørndal aka Bob Kåre [EMAIL PROTECTED] [EMAIL PROTECTED]
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ Tilesathome mailing list [email protected] http://lists.openstreetmap.org/listinfo/tilesathome
