What Zebrio produces
The school makes every file itself in the browser, in the analysis and in the planning tool. Zebrio sends nothing anywhere.
| Export | Where | Files | For |
|---|---|---|---|
| Report | Analysis › Report and export | HTML file, printable as PDF | Municipality, traffic authority, parent council |
| GIS data | Analysis › Report and export | ZIP: segments, hazards, good_spots, school_notes (GeoJSON), codes.csv, LIESMICH.txt | The municipality's GIS (QGIS, ArcGIS) |
| Data for the school route plan | Analysis › Report and export | Zebrio file (GeoJSON) | Open in the planning tool |
| Save the planning (with all data) | Planning tool › Export | ZIP: zebrio.geojson, survey/ and plans/ (GeoJSON per layer), codes.csv, LIESMICH.txt | Carry on in Zebrio; GIS |
| Only the plan | Planning tool › Export | ZIP: a folder per plan with GeoJSON per layer, codes.csv, LIESMICH.txt | Give the finished plan to the municipality |
| Table, KML, GPX | Planning tool › Export | CSV, KML, GPX | Excel, Google Earth, walking and navigation apps |
| Map image and print | Planning tool › Print | PNG, SVG, print view (PDF) | Notice board, parents' letter, website |
What is never in a file
- No single route to school and no single answer, only summarised data.
- No exact number of children on a way, only classes (up to 2, 3–5, 6–10, 11–20, more than 20).
- No parents' texts the school has not approved.
- No names, addresses, codes or keys.
Formats
| Format | Layout | Open with |
|---|---|---|
| GeoJSON | GeoJSON as in RFC 7946, coordinates in WGS84 (EPSG:4326), longitude before latitude, 6 decimals. One file per layer. | QGIS (Layer › Add layer › Vector layer), ArcGIS Pro (JSON to Features) |
| CSV | UTF-8 with a byte order mark, semicolons between columns, CRLF line ends; decimal commas in the plan table. | Excel, LibreOffice; in QGIS as a table to join on id |
| KML | A folder per plan with ways and markers, readable names; the IDs as ExtendedData. | Google Earth, QGIS |
| GPX | The ways as tracks, the numbered markers as waypoints. | Walking and navigation apps |
| Zebrio GeoJSON (zebrio.geojson) | GeoJSON with the zebrio member; Zebrio reads it again. Its fields are Zebrio's own and may change with new versions; for a GIS use the other files. | Zebrio (Planning tool › Open) |
GIS data of the analysis
One file per layer. Distributions are written as ID:count, separated by semicolons, for example 102:3;103:1, and next to them with English names.
| Field | Content |
|---|---|
| edge_id | ID of the section in the OpenStreetMap road network |
| street | Street name or kind of way |
| highway | OpenStreetMap road type |
| length_m | Length in metres |
| count_class | How many children use the section, as a class |
| count_class_<mode> | Class per transport mode; empty when none, or only one child (when single uses are left out) |
| Field | Content |
|---|---|
| number | Number of the spot as in the report |
| location | Place in words |
| reports | Number of reports |
| category | Most reported category (ID) |
| category_name | Its English name |
| categories | All categories with their reports (ID:count) |
| category_names | The same with English names |
| subcategories | Subcategories with their reports (ID:count) |
| subcategory_names | The same with English names |
| conditions | When it is especially dangerous (ID:count) |
| condition_names | The same with English names |
| movers_category | Most reported official problem spot category (1–32) |
| movers_categories | All official categories with their reports (number:count) |
| movers_symbol | Symbol of the school route plan template (ID), empty for “other” |
| movers_symbol_name | Its English name |
| comments | Parents' comments the school approved, separated by | |
| suggestions | Suggestions for improvement, the same way |
| Field | Content |
|---|---|
| number | Number of the spot as in the report |
| location | Place in words |
| reports | Number of reports |
| category | Most reported category (ID) |
| category_name | Its English name |
| categories | All categories with their reports (ID:count) |
| category_names | The same with English names |
| movers_symbol | Symbol of the school route plan template (ID), empty for “other” |
| movers_symbol_name | Its English name |
| comments | Parents' comments the school approved, separated by | |
| Field | Content |
|---|---|
| kind | Kind: hazard, good_spot or note |
| category | Category (ID from 1xx or 4xx), empty for a note |
| category_name | Its English name |
| movers_symbol | Symbol of the school route plan template (ID), empty for “other” |
| movers_symbol_name | Its English name |
| title | Title |
| text | Description |
| place | Place in words |
| updated_on | Day of the last change |
Exports of the planning tool
The folders under plans/ (and with “Only the plan” the folders in the ZIP) hold school, ways, hazards, good_spots and places per plan as GeoJSON. The files under survey/ hold the survey's results with the fields of the GIS data, without the distributions by subcategory and condition.
The table (CSV) has the markers' fields plus place, latitude and longitude. KML and GPX carry readable names for people; KML also has the IDs as ExtendedData.
| Field | Content |
|---|---|
| kind | marker, way or school |
| symbol | Symbol of the school route plan template (ID) |
| symbol_name | Its English name |
| number | Number in the plan's legend; empty for markers without title and description |
| title | Title |
| category | Problem spot category (ID), where set |
| category_name | Its English name |
| plans | Plans it belongs to, separated by semicolons |
| note | The school's description |
Mapping to MOVERS
Every problem spot carries the official category of the Schulwegplaner (movers_category): its category's number on the way it was reported on, the footpath list for all but cycling children. Where that way's list lacks the category, it is that list's “Sonstige” (17 or 32). It also carries the symbol of the school route plan template (movers_symbol) the spot gets in the planning tool; empty for “other”.
Code lists
Every ID is a whole number, unique across all lists: problem spot categories 101–199, subcategories 201–299, conditions 301–399, good spot categories 401–499, school route plan symbols 501–599. The English name (name) is fixed too. The official problem spot categories of the Schulwegplaner (MOVERS) keep their own numbers 1–32.
| ID | Name | Label | MOVERS footpath | MOVERS cycle path | Symbol |
|---|---|---|---|---|---|
| 101 | no_safe_crossing | No way to cross the road safely | 21 | 502 | |
| 102 | car_traffic | Problems with car traffic | 19 | 3 | 504 |
| 103 | parked_cars | Problems with parked cars | 20 | 4 | 504 |
| 104 | unclear_spot | Hard to see what is coming | 22 | 5 | 504 |
| 105 | missing_path | No pavement or cycle path | 24 | 7 | 503 |
| 106 | narrow_path | Pavement or cycle path too narrow or badly laid out | 25 | 8 | 504 |
| 107 | path_ends | Pavement or cycle path ends suddenly | 26 | 9 | 504 |
| 108 | cycle_marking | Cycle path markings missing or poor | 11 | 504 | |
| 109 | poor_surface | Poor surface, uneven or not cleared | 12 | 504 | |
| 110 | high_curb | Kerb too high | 27 | 10 | 504 |
| 111 | obstacles | Obstacles in the way | 28 | 13 | 504 |
| 112 | poor_lighting | Poor lighting | 29 | 14 | 504 |
| 113 | long_wait | Long waits | 30 | 15 | 504 |
| 114 | fear_places | A place where children feel unsafe | 31 | 16 | 504 |
| 115 | pedestrians | Problems with pedestrians | 1 | 504 | |
| 116 | cyclists | Problems with cyclists | 18 | 2 | 504 |
| 117 | rule_breaking | My child walks or cycles here differently than allowed | 23 | 6 | 504 |
| 118 | other | Other | 32 | 17 |
| ID | Name | Label | Category |
|---|---|---|---|
| 201 | speeding | Cars drive too fast | 102 |
| 202 | heavy_traffic | Many lorries or buses | 102 |
| 203 | drop_off_traffic | Drop-off traffic (parents' cars) | 102 |
| 204 | dangerous_driveway | Dangerous entrance or exit (e.g. supermarket, petrol station) | 102 |
| 205 | missing_crossing_aid | No crossing (zebra crossing, lights, island) | 101 |
| 206 | no_gaps | Heavy traffic, hardly any gaps to cross | 101 |
| 207 | wide_road | Road very wide or several lanes | 101 |
| 208 | poor_visibility | Poor visibility | 104 |
| 209 | curve_or_crest | Bend or hilltop | 104 |
| 210 | blocked_view | Hedges, trees or signs block the view | 104 |
| 211 | potholes | Potholes or poor road condition | 109 |
| 212 | unpaved | Unpaved path (gravel, mud) | 109 |
| 213 | winter_maintenance | Not cleared or gritted in winter | 109 |
| 214 | construction | Roadworks | 111 |
| 215 | street_furniture | Bins, signs or posts in the way | 111 |
| 216 | overgrowth | Hedges or branches reach into the path | 111 |
| 217 | traffic_light_timing | Traffic light: green too short | 113 |
| 218 | long_red | Traffic light: long wait for green | 113 |
| 219 | unpleasant_place | Unpleasant place (e.g. underpass, lonely path) | 114 |
| 220 | dogs | Dogs | 114 |
| 221 | unpleasant_encounters | Unpleasant encounters (e.g. groups, harassment) | 114 |
| 222 | attention_required | Extra care needed | 118 |
| 223 | unsafe_bus_stop | Dangerous bus stop (e.g. too narrow, right next to the road) | 118 |
| ID | Name | Label |
|---|---|---|
| 301 | rush_hour | Mainly in rush hour |
| 302 | darkness | In the dark |
| 303 | winter | In winter (snow, ice) |
| 304 | rain | In rain or when wet |
| ID | Name | Label | Symbol |
|---|---|---|---|
| 401 | good_crossing | Good place to cross | 507 |
| 402 | zebra_crossing | Zebra crossing | 508 |
| 403 | traffic_light | Traffic lights | 509 |
| 404 | traffic_island | Traffic island | 510 |
| 405 | crossing_guard | School crossing patrol | 511 |
| 406 | good_path | Good path | 506 |
| 407 | traffic_calmed_area | Traffic-calmed area | 513 |
| 408 | help_point | Place to get help (e.g. shop, pharmacy) | 514 |
| 409 | other | Other |
| ID | Name | Label |
|---|---|---|
| 501 | hazard | Hazard |
| 502 | missing_crossing_aid | Missing crossing aid |
| 503 | missing_sidewalk | Missing pavement |
| 504 | attention_required | Extra care needed |
| 505 | roundabout | Roundabout |
| 506 | good_spot | Good spot |
| 507 | good_crossing | Good place to cross |
| 508 | zebra_crossing | Zebra crossing |
| 509 | traffic_light | Traffic lights |
| 510 | traffic_island | Traffic island |
| 511 | crossing_guard | School crossing patrol |
| 512 | good_path | Good path |
| 513 | traffic_calmed_area | Traffic-calmed area |
| 514 | help_point | Place to get help |
| 515 | meeting_point | Meeting point |
| 516 | sidewalk | Pavement |
| 517 | shared_path | Shared foot and cycle path |
| 518 | separate_paths | Separate foot and cycle paths |
| 519 | one_way_street | One-way street |
| 520 | drop_off_zone | Drop-off zone |
| 521 | walking_bus_stop | Walking bus stop |
| 522 | bus_stop | Bus stop |
| 523 | school | School |
| 524 | sports_field | Sports field |
| 525 | playground | Playground |
| 526 | shop | Shop |
| 527 | note | Note |
| ID | Way | Name (the official German one is in codes.csv) | Category | Name |
|---|---|---|---|---|
| 1 | cycle path | Problems with pedestrians | 115 | pedestrians |
| 2 | cycle path | Problems with cyclists | 116 | cyclists |
| 3 | cycle path | Problems with car traffic | 102 | car_traffic |
| 4 | cycle path | Problems with parked cars | 103 | parked_cars |
| 5 | cycle path | Hard to see what is coming | 104 | unclear_spot |
| 6 | cycle path | My child cycles here differently than allowed (e.g. on the pavement) | 117 | rule_breaking |
| 7 | cycle path | No cycle path | 105 | missing_path |
| 8 | cycle path | Cycle path too narrow or badly laid out | 106 | narrow_path |
| 9 | cycle path | Cycle path ends suddenly | 107 | path_ends |
| 10 | cycle path | Kerb too high | 110 | high_curb |
| 11 | cycle path | Cycle path markings missing or poor | 108 | cycle_marking |
| 12 | cycle path | Poor surface, uneven or not cleared | 109 | poor_surface |
| 13 | cycle path | Obstacles in the way | 111 | obstacles |
| 14 | cycle path | Poor lighting | 112 | poor_lighting |
| 15 | cycle path | Long waits | 113 | long_wait |
| 16 | cycle path | A place where children feel unsafe | 114 | fear_places |
| 17 | cycle path | Other | 118 | other |
| 18 | footpath | Problems with cyclists | 116 | cyclists |
| 19 | footpath | Problems with car traffic | 102 | car_traffic |
| 20 | footpath | Problems with parked cars | 103 | parked_cars |
| 21 | footpath | No way to cross the road safely | 101 | no_safe_crossing |
| 22 | footpath | Hard to see when crossing | 104 | unclear_spot |
| 23 | footpath | My child walks here differently than allowed (e.g. not at the lights) | 117 | rule_breaking |
| 24 | footpath | No pavement | 105 | missing_path |
| 25 | footpath | Pavement too narrow or badly laid out | 106 | narrow_path |
| 26 | footpath | Pavement ends suddenly | 107 | path_ends |
| 27 | footpath | Kerb too high | 110 | high_curb |
| 28 | footpath | Obstacles in the way | 111 | obstacles |
| 29 | footpath | Poor lighting | 112 | poor_lighting |
| 30 | footpath | Long waits | 113 | long_wait |
| 31 | footpath | A place where children feel unsafe | 114 | fear_places |
| 32 | footpath | Other | 118 | other |
| Value | Label |
|---|---|
| <=2 | up to 2 children |
| 3-5 | 3–5 children |
| 6-10 | 6–10 children |
| 11-20 | 11–20 children |
| >20 | more than 20 children |
| Name | Label |
|---|---|
| walk | on foot |
| bike | bicycle |
| scooter | scooter |
| bus | bus |
| car_drop_off | driven by car |
| mixed | mixed |
| unknown | unknown (older answers) |
Stable IDs
An ID never changes and is never given out again. New categories get the next free number of their list; a removed one stays in codes.csv, marked retired.
If a file has an ID your list does not know yet, download codes.csv here again.