Feldbeschreibung - MunichWays/masterliste GitHub Wiki
- osm_id
- osm_name
- osm_class_bicycle
- osm_smoothness
- osm_surface
- osm_bicycle
- osm_highway
- osm_lit
- osm_width
- osm_access
- munichways_id
- munichways_name
- munichways_happy_bike_level
- munichways_color
- munichways_mapillary_link
- munichways_route_link
- munichways_net_type_plan
- munichways_net_type_target
- munichways_current
- munichways_target
- munichways_measure_category_link
- munichways_description
- munichways_status_implementation
- munichways_district_link
- munichways_neuralgic_point
- munichways_links
- munichways_mw_rv_route
- color
properties: {
osm_id: way.id,
osm_name: way.tags["name"],
osm_class_bicycle: way.tags["class:bicycle"],
osm_smoothness: way.tags["smoothness"],
osm_surface: way.tags["surface"],
osm_bicycle: way.tags["bicycle"],
osm_highway: way.tags["highway"],
osm_lit: way.tags["lit"],
osm_width: way.tags["width"],
osm_access: way.tags["access"],
...way.munichways.length > 0 ? {
munichways_id: mwInfos.map(info => info.id).join(","),
munichways_name: mwInfos.map(info => info.name).join(","),
munichways_happy_bike_level: mwInfos.map(info => info.happy_bike_level).join(","),
munichways_color: mwInfos.map(info => info.farbe).join(","),
munichways_mapillary_link: mwInfos.map(info => info.mapillary_link).join(","),
munichways_route_link: mwInfos.map(info => info.strecken_link).join(","),
munichways_net_type_plan: mwInfos.map(info => info.netztyp_plan).join(","),
munichways_net_type_target: mwInfos.map(info => info.netztyp_ziel).join(","),
munichways_current: mwInfos.map(info => info.ist_situation).join(","),
munichways_target: mwInfos.map(info => info.soll_massnahmen).join(","),
munichways_measure_category_link: mwInfos.map(info => info.massnahmen_kategorie_link).join(","),
munichways_description: mwInfos.map(info => info.beschreibung).join(","),
munichways_status_implementation: mwInfos.map(info => info.status_umsetzung).join(","),
munichways_district_link: mwInfos.map(info => info.bezirk_link).join(","),
munichways_neuralgic_point: mwInfos.map(info => info.neuralgischer_punkt).join(","),
munichways_links: mwInfos.map(info => info.links).join(","),
munichways_mw_rv_route: mwInfos.map(info => info.mw_rv_strecke).join(","),
} : {},
color: way.tags["class:bicycle"] ? translateClassBicycle(way.tags["class:bicycle"]) : way.munichways.length > 0 ? translateMunichwaysColor(way.munichways[0].properties.munichways_color) : undefined,
}
- 1 osm_id
- 2 osm_class_bicycle as 'class_bicycle' (Happy Bike Level) - als case Übersetzung siehe unten, Beispiel "2 = gemütlich = grün"
- 3 osm_name
- 4 osm_smoothness as 'osm_smoothness (Ebenheit)'
- 5 osm_surface as 'osm_surface (Oberfläche)'
- 6 osm_bicycle (Erlaubnis)
- 7 osm_highway as 'osm_highway (Straßentyp)'
- 8 osm_lit as 'osm_lit (beleuchtet)'
- 9 osm_width as 'osm_width (Breite)'
- 10 osm_access as 'osm_access (Zugang)'
--> osm 10 Felder
- 1 MunichWays_Id
- 2 MunichWays_Name
- 3 munichways_route_link as Strecken_Link
- 4 munichways_mw_rv_route as Ist_Radlvorrang_Netz
- 5 munichways_current as Ist_Situation
- 6 munichways_mapillary_link as Mapillary_Link
- 7 munichways_description as Beschreibung
- 8 munichways_target as Soll_Massnahmen
- 9 munichways_measure_category_link as Massnahmen_Kategorie_Link
- 10 munichways_status_implementation as Status_Umsetzung
- 11 munichways_district_link as Bezirk_Link
- 12 munichways_neuralgic_point as Neuralgischer_Punkt
- 13 munichways_links as Links
--> MW 13 Felder --> OSM + MunichWays: 23 Felder
optional Carto:
- 14 Netztyp_Plan --> optional in Carto, nicht in MunichWays App
- 15 Netztyp_Ziel --> optional in Carto, nicht in MunichWays App
select geom
, osm_id
, case when osm_class_bicycle=3 then '3 = hervorragend = grün'
when osm_class_bicycle=2 then '2 = gemütlich = grün'
when osm_class_bicycle=1 then '1 = durchschnittlich = gelb'
when osm_class_bicycle=0 then '0 = keine Aussage'
when osm_class_bicycle=-1 then '-1 = stressig = rot'
when osm_class_bicycle=-2 then '-2 = sehr stressig = schwarz'
when osm_class_bicycle=-3 then '-3 = Unter allen Umständen vermeiden = schwarz'
when osm_class_bicycle is null then ''
else 'ungültiger Wert'
End class_bicycle
, osm_name
, osm_smoothness
, osm_surface
, osm_bicycle
, osm_highway
, osm_lit
, osm_width
, access
, munichways_id
, munichways_name
, munichways_route_link
, munichways_mw_rv_route
, munichways_current
, munichways_mapillary_link
, munichways_description
, munichways_target
, munichways_measure_category_link
, munichways_net_type_plan
, munichways_net_type_target
, munichways_status_implementation
, munichways_district_link
, munichways_neuralgic_point
, munichways_links
from `carto-dw-ac-yq8go6t4.shared.IST_RadlVorrangNetz_MunichWays_V20`
<div class="CDB-SidePanelContent">
<div>{{munichways_name}}</div>
<dl>
<div>
<dt>Straßenansicht klick mich</dt>
<a target="_blank" href="{{munichways_mapillary_link}}"> <img width="175" src="https://www.munichways.de/img/Mapillary_Split_Odeonsplatz.png"></a>
</div>
<div>
<dt>OSM ID:</dt>
<dd>{{osm_id}}</dd>
<dt>class_bicycle (Happy Bike Level):</dt>
<dd>{{class_bicycle}}</dd>
<dt>OSM Name:</dt>
<dd>{{osm_name}}</dd>
<dt>OSM Smoothness (Ebenheit):</dt>
<dd>{{osm_smoothness}}</dd>
<dt>OSM Surface (Oberfläche):</dt>
<dd>{{osm_surface}}</dd>
<dt>OSM bicycle (Erlaubnis):</dt>
<dd>{{osm_bicycle}}</dd>
<dt>OSM Highway (Straßentyp):</dt>
<dd>{{osm_highway}}</dd>
<dt>OSM Lit (beleuchtet):</dt>
<dd>{{osm_lit}}</dd>
<dt>OSM Width (Breite):</dt>
<dd>{{osm_width}}</dd>
<dt>OSM Access (Zugang):</dt>
<dd>{{osm_access}}</dd>
</div>
<div>
<dt>MunichWays ID:</dt>
<dd>{{munichways_id}}</dd>
<dt>MunichWays Name:</dt>
<dd>{{munichways_name}}</dd>
<dt>Strecken Link:</dt>
<dd>{{munichways_route_link}}</dd>
<dt>Ist Radlvorrang Netz:</dt>
<dd>{{munichways_mw_rv_route}}</dd>
<dt>Ist Situation:</dt>
<dd>{{munichways_current}}</dd>
<dt>Mapillary Link:</dt>
<dd><a target="_blank" href="{{munichways_mapillary_link}}">Mapillary Straßenansicht</a></dd>
<dt>Beschreibung:</dt>
<dd>{{munichways_description}}</dd>
<dt>Soll Massahmen:</dt>
<dd>{{munichways_target}}</dd>
<dt>Massnahmen Kategorie Link:</dt>
<dd>{{munichways_measure_category_link}}</dd>
<dt>Netztyp Plan:</dt>
<dd>{{munichways_net_type_plan}}</dd>
<dt>Netztyp Ziel:</dt>
<dd>{{munichways_net_type_target}}</dd>
<dt>Status Umsetzung:</dt>
<dd>{{munichways_status_implementation}}</dd>
<dt>Bezirk Link:</dt>
<dd>{{munichways_district_link}}</dd>
<dt>Neuralgischer Punkt:</dt>
<dd>{{munichways_neuralgic_point}}</dd>
<dt>Links:</dt>
<dd>{{munichways_links}}</dd>
</div>
</dl>
</div>
- 1 Name
- 2 Mapillary Vorschaubild
- 3 streckenLink label: "Strecke"
- 4 Ist-Situation
- 4 Happy Bike Level
- 5 Soll-Maßnahmen
- 6 Maßnahmen-Kategorie
- 7 Beschreibung
- 8 Munichways-Id
- 9 Status-Umsetzung
- 10 Bezirk
- 11 Link
MW_RV_Strecke as IST_RadlVorrangNetz (ungleich '-' = Filter IST RadlVorrang-Netz)