[OSM-dev] Cron job on dev to make a UK planet

[Nick Whitelegg]

On Friday 02 Nov 2007 23:09, Tom Hughes wrote:
> In message <20071102224340.GB32342 at lochewe.mathy.remote.org>
>
>           Frederik Ramm <frederik at remote.org> wrote:
> > > Would like to resume the cron job on dev I ran till about late July to
> > > make a UK planet (downloadable from
> > > http://nick.dev.openstreetmap.org/downloads/planet/)  on the dev
> > > server. It uses planetosm-excerpt-db.pl.
> >
> > I wasn't even aware that I have direct database access from the dev
> > server. How does this work? In that case I'd save me the trouble of
> > downloading the planet file and making a Germany excerpt each week and
> > instead create that on dev...
>
> As far as I know there is no general access to the database from
> dev - there certainly shouldn't be anyway.
>
> There is an account which has access to the database from dev for
> dumping the planet, but as far as I am aware that is the only thing
> that account is used for.
>
> I assumed Nick was talking about filtering planet to create a cut
> down version, not working against the database, but I see that the
> name of the script he was planning to use implies otherwise.
>
> I don't think we really want to get into the business of producing
> lots of mini-planets direct from the database as it isn't very
> scalable and there are security and privacy reasons for limiting
> access to the database.

Sorry this was a typo. I meant planetosm-excerpt-area.pl. Don't think there is 
a script called planetosm-excerpt-db.pl, I obviously had databases on the 
brain for some reason :-) What I am doing is filtering the planet.osm file to 
create a UK-only version. 

Nick