[Talk-GB] "OSMUK-in-a-box"

[Jez Nicholson]

Excellent. Not a new idea then.

https://alexurquhart.com/post/set-up-postgis-with-docker/ looks like a
reasonable summary of what Docker is and why.

It being the whole of the UK, the download and create takes a while. I will
be giving the choice of a smaller area, e.g. Greater Manchester.

I'd like to include some sample SQL queries to help people get started.
Help here would be useful.

On Thu, 6 Feb 2020, 13:17 Derry Hamilton, <rasilon.x at gmail.com> wrote:

> Hi Tony,
> I did something similar a while back at
> https://github.com/rasilon/osm_database so that might help you get
> started?
>
> Cheers,
> Derry
>
> On Thu, 6 Feb 2020 at 13:10, Tony OSM <tonyosm9 at gmail.com> wrote:
>
>> Absolutely Fabulous!
>>
>> Not done Docker but I'll start learning how to get it on those
>> environments.
>>
>> I'll try to support by QA and writing instructions as to how to get it
>> live.
>>
>> Cheers
>>
>> TonyS999
>> On 06/02/2020 12:29, Jez Nicholson wrote:
>>
>> I come from a database background, and when a question isn't easily
>> answered with Taginfo or Overpass Turbo I jump to my trusty local postgres
>> database of UK data. I have a script that downloads the British Isles from
>> Geofabrik, loads it with osm2pgsql, adds some useful indexes, and then
>> removes Eire. Thereafter I can run SQL queries across the whole database to
>> get 'UK-wide' results.
>>
>> I think that this would be useful for people on hackdays and the like and
>> would be a good service for OSMUK to provide, so have just added a new
>> github repository https://github.com/osm-uk/osmuk2pgsql
>>
>> Friendly-worded Issues are welcome, as are code contributions. I'd like
>> to put it on a Docker environment so that it works quickly-and-easily on
>> Windows, Linux, Mac, whatever.
>>
>> Comments? Thoughts?
>>
>> Regards,
>>              Jez
>>
>> _______________________________________________
>> Talk-GB mailing listTalk-GB at openstreetmap.orghttps://lists.openstreetmap.org/listinfo/talk-gb
>>
>> _______________________________________________
>> Talk-GB mailing list
>> Talk-GB at openstreetmap.org
>> https://lists.openstreetmap.org/listinfo/talk-gb
>>
> _______________________________________________
> Talk-GB mailing list
> Talk-GB at openstreetmap.org
> https://lists.openstreetmap.org/listinfo/talk-gb
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/talk-gb/attachments/20200206/bb8fb62a/attachment-0001.htm>