[OSM-dev] [OSM-talk] Geofabrik downloads post-licence-change

[Paul Norman]

> From: Frederik Ramm [mailto:frederik at remote.org]
> Subject: Re: [OSM-talk] Geofabrik downloads post-licence-change
> 
> Hi,
> 
> On 04/13/2012 11:25 AM, Paul Norman wrote:
> > Something I've wondered is if it is more efficient to be generating
> > these with osmosis with a planet file updated daily or with a
> > pgsnapshot database updated continually?
> 
> I have little experience with the pgsnapshot schema so cannot really
> say. When we started doing the Geofabrik extracts, that schema wasn't
> around and PostGIS was at release 1.3 and had really bad point-in-
> polygon performance so unless you were happy with rectangular extracts,
> it was impossible to run the job off a PostGIS database.
> Things might have changed now and I'd love to hear from someone who
> tried it.

Unfortunately there is no "--dataset-bounding-polygon" task so I couldn't do
it with osmosis. I tried the UK with jxapi which does support polygons and
it errored after about 80 minutes.

Just for reference, a typical way[natural=coastline] query generates 5G of
data and takes just over an hour on my hardware.