On Mon, 2008-11-10 16:19:24 +0100, Tobias Wendorff <[EMAIL PROTECTED]> wrote: > André Riedel schrieb: > > Man könnte auch nur *time* nehmen um generell besondere Zeiten > > darzustellen. (z.B. jeden Tag um 12:00 Uhr gibt es ein Glockenspiel) > > Nur "time" wäre mir irgendwie zu wenig. Ein Glockenspiel ist ja > etwas, was aktiv um 12 Uhr stattfindet. > > Ein Briefkasten tut aber um 12 Uhr immer noch das, was er immer > tut, außer jemand kommt von außen dazu. > > Ich würde allerdings mit Doppelpunkten arbeiten: > > collection:time = 17:15 UTC > collection:days = Monday to Friday > collection:special = Saturday, 23:00 UTC
Für Deutschland:
osm=> select k, count(*) from (select k, v from node_tags nt where k not in
('amenity', 'operator', 'source', 'created_by') and node_id in (select node_id
from node_tags where k='amenity' and v='post_box') ) as foo group by k order
by 2 desc;
k | count
----------------------------+-------
postal_code | 222
name | 169
opening_hours | 79
note | 48
ref | 43
is_in | 36
ele | 24
wpt_symbol | 21
wpt_description | 21
collect_monfri | 9
layer | 9
collect_sat | 9
highway | 9
post_box_info | 6
addr:postcode | 5
description | 5
shop | 5
stamps | 4
leerungszeiten | 3
collect_sun | 3
survey | 3
poi | 3
source_ref | 3
addr:street | 2
landuse | 2
kismet:coordinates | 2
parcel_box | 1
fixme | 1
lines | 1
post | 1
motorcar | 1
Info | 1
Telekom | 1
key | 1
comment | 1
Time of Collection (Sa) | 1
emptying_time | 1
Leerung | 1
place | 1
Time of Collection (Mo-Fr) | 1
emtied | 1
tourism | 1
recycling:clothes | 1
FIXME | 1
railway | 1
misc | 1
(46 rows)
'opening_hours' macht also den Eindruck, als wär' das ein Kandidat:
osm=> select k, v from node_tags nt where k ='opening_hours' and node_id in
(select node_id from node_tags where k='amenity' and v='post_box');
k | v
---------------+----------------------------------------------------------------------
opening_hours | Mo-Fr 14:00; Sa 13:30
opening_hours | Mo-Fr 14:30, 16:45, 19:45\s Sa 13:00\s So 09:00
opening_hours | Mo-Fr 16:45; Sa 10:45
opening_hours | Mo-Fr 11:30,15:30,17:30; Sa 12:30; Su 10:30
opening_hours | Mo-Fr 16:30; Sa 10:30
opening_hours | Mo-Fr 15:30,17:30\s Sa 13:30\s Su 08:45
opening_hours | Mo-Fr 16:45
opening_hours | Mo-Fr 16:30, 18:15; Sa 11:45; So 9:30
opening_hours | Mo-Fr 17:15, Sa 11:30
opening_hours | Mo-Fr 14:30,17:30; Sa 13:00; Su 08:30
opening_hours | Mo-Fr 16:15,17:45,19:00; Sa 12:00; So 11:15
opening_hours | Mo-Fr 14:30, 16:45, 19:45\s Sa 13:00\s So 09:00
opening_hours | Mo-Fr 14:30,17:45; Sa 13:15
opening_hours | Mo-Fr 17:30; Sa 14:00
opening_hours | Mo-Fr 14:15, 17:45; Sa 14:00
opening_hours | Mo-Fr 16:00; Sa 12:00
opening_hours | Mo-Fr 14:00,16:00; Sa 12:00; Su 08:15
opening_hours | Mo-Sa 08:00
opening_hours | Mo-Fr 16:30, Sa 10:00
opening_hours | Mo-Fr 17:00; Sa 11:00
opening_hours | Mo-Fr 16:00; Sa 12:15; Su 10:15
opening_hours | Mo-Sa 08:30
opening_hours | Mo-Fr 16:30; Sa 12:00
opening_hours | Mo-Fr 11:30,15:30,17:30\s Sa 15:30\s Su 08:15
opening_hours | Mo-Sa 08:00
opening_hours | Mo-Fr 13:30,17:15; Sa 13:15; Su 08:30
opening_hours | Mo-Fr 16:00, Sa 13:30
opening_hours | Mo-Fr 15:30,17:30\s Sa 13:30
opening_hours | Mo-Fr 16:15; Sa 10:30
opening_hours | Mo-Fr 14:00,16:00; Sa 12:00; Su 08:15
opening_hours | Mo-Sa 10:00
opening_hours | Mo-Fr 14:30,17:15; Sa 13:00; Su 10:00
opening_hours | Mo-Fr 15:15,17:30,18:30; Sa 11:45
opening_hours | Mo-Fr 17:30; Sa 10:30
opening_hours | Mo-Fr 16:30; Sa 12:15; Su 10:30
opening_hours | Mo-Fr 16:30; Sa 11:15; Su 09:45
opening_hours | Mo-Fr 16:30; Sa 12:00
opening_hours | Mo-Fr 18:00
opening_hours | Mo-Fr 17:30; Sa 11:45
opening_hours | Mo-Fr 11:30,15:00,16:15,18:15; Sa 15:45; Su 08:15
opening_hours | Mo-Fr 16:30,18:00; Sa 12:15
opening_hours | Mo-Fr 14:00,16:30; Sa 12:00; Su 08:15
opening_hours | Mo-Fr 11:30,14:45,16:30,17:45,18:15; Sa 13:30
opening_hours | Mo-Fr 11:30, 14:00, 17:45; Sa 15:30
opening_hours | Mo-Fr 11:30, 14:00, 17:45; Sa 15:30; So 08:15
opening_hours | Mo-Sa 09:00
opening_hours | Mo-Fr 16:00; Sa 12:00
opening_hours | Mo-Fr 15:45,17:30; Sa 11:45
opening_hours | Mo-Fr 17:15; Sa 12:30
opening_hours | Mo-Fr 16:15,17:30; Sa 12:15
opening_hours | Mo-Fr 11:30, 14:30, 17:45, 19:00, 24:00\s Sa 13:30\s Su 12:00,
24:00
opening_hours | Mo-Fr 16:30; Sa 12:00; Su 08:30
opening_hours | Mo-Fr 17:30; Sa 14:00; Su 08:15
opening_hours | Mo-Sa 08:00
opening_hours | Mo-Fr 13:30,17:15; Sa 13:15; Su 08:30
opening_hours | Mo-Fr 17:00; Sa 12:30
opening_hours | Mo-Fr 11:30,14:30,16:45,17:45; Sa 13:30; Su 08:15
opening_hours | Mo-Fr 18:00; Sa 12:15
opening_hours | Mo-Fr 16:00, Sa 11:45
opening_hours | Mo-Fr 14:30,17:30,18:45; Sa 14:00; Su 10:00
opening_hours | Mo-Fr 15:30,17:45; Sa 13:30
opening_hours | Mo-Fr 16:00; Sa 12:00
opening_hours | Mo-Fr 17:00; Sa 12:00; Su 08:15
opening_hours | Mo-Fr 13:45,16:00,17:30,18:30; Sa 14:00; Su 10:00
opening_hours | Mo-Fr 16:15; Sa 12:30
opening_hours | Mo-Fr 17:15; Sa 13:15
opening_hours | Mo-Fr 16:00
opening_hours | Mo-Fr 08:00-19:00, 24:00\s Sa 12:30, 17:30\s Su 8:00, 12:00
24:00
opening_hours | Mo-Fr 11:30,14:30,16:30,17:30,18:15\s Sa 13:30\s Su 08:45
opening_hours | Mo-Sa 9:00
opening_hours | Mo-Fr 08:00-19:00,24:00\s Sa 12:30\s Su 08:00,12:00,24:00
opening_hours | Mo-Fr 13:30,17:30; Sa 12:30; Su 08:30
opening_hours | Mo-Fr 15:45,17:30; Sa 11:45; So 7:45
opening_hours | Mo-Fr 14:00,16:30; Sa 12:00
opening_hours | Mo-Fr 15:30; Sa 10:15
opening_hours | Mo-Sa 09:00
opening_hours | Mo-Fr 14:00, 16:00; Sa 12:00
opening_hours | Mo-Fr 16:30, Sa 11:00, So 07:30
opening_hours | Mo-Fr 17:15; Sa 11:30
(79 rows)
Ich würd' also das tag nehmen...
MfG, JBG
--
Jan-Benedict Glaw [EMAIL PROTECTED] +49-172-7608481
Signature of: What we do for ourselves dies with us. What we do for
the second : others and the world remains and is immortal. (Albert
Pine)
signature.asc
Description: Digital signature
_______________________________________________ Talk-de mailing list Talk-de@openstreetmap.org http://lists.openstreetmap.org/listinfo/talk-de
