[OSM-talk] Creating a subset of OSM and storing it in Postgis tables

[Roland Olbricht]

> My current thinking is that I need to:
> 
> 1. download the weekly England, Scotland & Wales excerpts from geofabrik
> 2. merge the 3 files
> 3. filter out what I don't need

You can replace steps one to three by doing a wget from Overpass. Please try 
e.g.:
wget -O natural.osm 
"http://overpass.osm.rambler.ru/cgi/interpreter?data=[timeout:900];node(50,-10,61,2)
[natural];out;"

This returns all nodes that have a tag with key "natural".

You may need to fine-tune the bounding box (50,-10,61,2), but I think, it 
should roughly match.

It may take some time to download, but it is perfectly well within normal 
server usage.

If you want to combine several keys in one query, you can enclose 
node(50,-10,61,2)[natural]; in parentheses "(" ");" and write multiple. E.g.
wget -O multiple.osm 
"http://overpass.osm.rambler.ru/cgi/interpreter?data=[timeout:900];
(node(50,-10,61,2)[natural];node(50,-10,61,2)[historic];);out;"

If you want also ways and relations, you can try
wget -O multiple.osm 
"http://overpass.osm.rambler.ru/cgi/interpreter?data=[timeout:900];
(way(50,-10,61,2)[natural];node(w);rel(50,-10,61,2)[natural];node(r)-
>.x;way(r);node(w););out;"

All commands are in one line. More information is at
http://wiki.openstreetmap.org/wiki/Overpass_API/Language_Guide

Cheers,

Roland