# Abfrage auch unter http://overpass-turbo.eu/s/aDD
wget -qO - http://overpass-api.de/api/interpreter --post-data='data=
[out:csv(ref, network, type, name, ::id, "name:de", "official_name", "snr:ref", "snr:name";false;"\t")];
area[boundary=administrative]["ISO3166-2"="DE-SN"]->.sax;

rel[route=bicycle][network=icn](area.sax)->.i;
rel[route=bicycle][network=ncn](area.sax)->.n;
rel[route=bicycle][network=rcn](area.sax)->.r;
rel[route=bicycle][network=lcn](area.sax)->.l;
rel[route=bicycle][network=radweit](area.sax)->.rw;
rel[route=bicycle][network!~"[inrl]cn|radweit"](area.sax)->.rest;

(.i;.n;.r;.l;.rw;.rest;)->.all;(.all <<; - .all;)->.sup;

rel.sup[network!~"[inrl]cn|radweit"];out tags;
rel.sup[network=icn];out tags;.i out tags;
rel.sup[network=ncn];out tags;.n out tags;
rel.sup[network=rcn];out tags;.r out tags;
rel.sup[network=lcn];out tags;.l out tags;
rel.sup[network=radweit];out tags;.rw out tags;
.rest out tags;' \
| sed -e 's/^\t/ \t/;s/\t\t/\t \t/g;s/\t\t/\t \t/g;s/\t$/\t /;s/|/<nowiki>|<\/nowiki>/;' \
| while IFS=$'\t' read _ref _network _type _name _id _n2 _n3 _snrref _snrname
  do echo -e "|-\n| $_ref || $_network || $_type || ${_name/# /${_n2/# /$_n3}} || {{Relation|$_id}} || $_snrref || $_snrname"
  done