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

[Knut Arne Bjørndal]

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

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
bob+osm at cakebox.net
bobkare at irc
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 4167 bytes
Desc: not available
URL: <http://lists.openstreetmap.org/pipermail/tilesathome/attachments/20080901/ecc0d489/attachment.bin>