[Talk-de] Postkasten mit Spät und Sonntagsleerung

Jan-Benedict Glaw jbglaw at lug-owl.de
Mo Nov 10 15:34:02 UTC 2008


On Mon, 2008-11-10 16:19:24 +0100, Tobias Wendorff <tobias.wendorff at uni-dortmund.de> 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      jbglaw at lug-owl.de              +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)
-------------- nächster Teil --------------
Ein Dateianhang mit Binärdaten wurde abgetrennt...
Dateiname   : signature.asc
Dateityp    : application/pgp-signature
Dateigröße  : 189 bytes
Beschreibung: Digital signature
URL         : <http://lists.openstreetmap.org/pipermail/talk-de/attachments/20081110/855a4ea4/attachment.sig>


Mehr Informationen über die Mailingliste Talk-de