Import schools in Catalunya
Goals
The goal is to complete and add the schools in Catalunya from the official data offered by the regional government in its open government web. You can see more in Ca:Importació dades Generalitat de Catalunya (in catalan).
The original dataset have 21799 entries, but for some centers there are data from more than one course. If we'll take the data of the last available course (2018-2019), there are 5472 centers. For each center there are interesting data such as name, address, type, contact, studies offered ... Searching in OSM with overpass, we find ~2500 schools and ~400 kindergarten, the majority have only tagged the name, and many only have the tag amenity=*.
We have checked the geographic quality of the dataset data, achieving correspondence of ~3800 centers in a buffer of 300 meters, without debugging false positives.
Therefore, we believe that the main objective of the import will be to improve the information on the map, adding dataset data and, where appropriate, add the missing centers.
Import Data
License
We have an express authorization from the Generalitat de Catalunya for the reuse of open data published on its open Government website.
Data description
We'll use the xml files for processing. You can download the data here.
Import type
The import will be done manually, using the Tasks Manager, so it can be assigned to different volunteers. JOSM will be used to edit the data.
Data Preparation
Data Reduction & Simplification
The original dataset consists of > 2000 entries for < 5000 centers. For some centers there are data from more than one course, so we'll delete the duplicates and will take the most actual.
Tagging Plans
Here are the original fields, their meaning and how they will be converted to the resulting OSM file:
| Original Fields | Meaning | OSM tag | Comments |
|---|---|---|---|
| Curs | Course of reference | Not used | |
| Any | Year of the inferior course | source:date=* | |
| Codi centre | Code of educational center | ref=* | |
| Denominació completa | Complete name of the education center | name=* | |
| Codi naturalesa | Code operator type: public / private | Not used | |
| Nom naturalesa | Name operator type: public / private | operator:type=* | |
| Codi titularitat | Code operator | Not used | |
| Nom titularitat | Name operator | operator=* | |
| Adreça | Address of the center | addr:street=* + addr:housenumber=* | |
| Codi postal | Postal code of the center | addr:postcode=* | |
| Telèfon | Phone of the center | contact:phone=* | We'll append +34 followed by a space at the beginning |
| FAX | Fax of the center | contact:fax=* | We'll append +34 followed by a space at the beginning |
| Codi delegació | Code of Territorial service | Not used | |
| Nom delegació | Name of Territorial service | Not used | |
| Codi comarca | Code of region | Not used | |
| Nom comarca | Name of region | Not used | |
| Codi municipi_5 | Code of township | 5 digits | Not used |
| Codi municipì_6 | Code of township | 5 digits | Not used |
| Nom municipi | Name of the township | addr:city=* | |
| Codi districte municipal | Code of the district | Not used | |
| Nom DM | Name of the district | Not used | |
| Codi localitat | Code of locality | Not used | |
| Nom localitat | Name of locality | addr:place=* | |
| Zona educativa | Name of the educational zone | Not used | |
| Coordenades UTM X | ETRS89 | Not used | |
| Coordenades UTM Y | ETRS89 | Not used | |
| Coordenades GEO X | WGS84 | Longitude in WGS84 | |
| Coordenades GEO Y | WGS84 | Latitude in WGS84 | |
| E-mail centre | E-mail of the center | contact:email=* | |
| EINF1C | Infant education, 1st cycle | isced:level=* + min_age=* + max_age=* | * see below |
| EINF2C | Infant education, 2nd cycle | isced:level=* + min_age=* + max_age=* | * see below |
| EPRI | Primary education | isced:level=* + min_age=* + max_age=* | * see below |
| ESO | High school, 1st cycle | isced:level=* + min_age=* + max_age=* | * see below |
| BATX | High school, 2nd cycle | isced:level=* + min_age=* + max_age=* | * see below |
| AA01 | Specific course of access to middle-level vocational training courses | isced:level=* | * see below |
| CFPM | Medium-grade training cycles | isced:level=* + min_age=* | * see below |
| PPAS | Course of preparation to test access High-level training cycles | isced:level=* + min_age=* | * see below |
| AA03 | Course of preparation access High-level training cycles | isced:level=* + min_age=* | * see below |
| CFPS | High-level training cycles | isced:level=* + min_age=* | * see below |
| EE | Special education | isced:level=* + min_age=* | ** see below |
| PFI | Training and insertion program | isced:level=* + min_age=* + max_age=* | * see below |
| PA01 | Cycles of arts medium degree | isced:level=* + min_age=* | * see below |
| CFAM | Cycles of plastic arts and design medium degree | isced:level=* + min_age=* | * see below |
| PA02 | Cycles of arts higher degree | isced:level=* + min_age=* | * see below |
| CFAS | Cycles of plastic arts and design higher degree | isced:level=* + min_age=* | * see below |
| ESDI | Design higher education | isced:level=* + min_age=* | * see below |
| ADR | Dramatic art | isced:level=* + min_age=* | * see below |
| CRBC | Conservation and restoration of cultural assets | isced:level=* + min_age=* | * see below |
| IDI | Languages | min_age=* | * see below |
| DANE | Dance school | isced:level=* | * see below |
| DANP | Professional dance school | isced:level=* + min_age=* | * see below |
| DANS | Higher dance school | isced:level=* + min_age=* | * see below |
| MUSE | Music school | isced:level=* | * see below |
| MUSP | Professional music school | isced:level=* + min_age=* | * see below |
| MUSS | Hihger music school | isced:level=* + min_age=* | * see below |
| TEGM | Sport medium cycle school | isced:level=* + min_age=* | * see below |
| TEGS | Sport higher cycle school | isced:level=* + min_age=* | * see below |
| ESTR | Foreign education centers | isced:level=* + min_age=* + max_age=* | * see below |
| ADULTS | Adult education | min_age=* | * see below |
| Columna amb nova georeferència | Agrupated geographic fields | Not used | |
| LIMADM_MUNICIPI | Not used | ||
| LIMADM COMARCA | Not used |
We added the following tags:
- import=yes
- amenity=* Kindergarten for those who only have EINFC1, EINFC2 or EINFC1 + EINFC2. School for the rest.
- building=* (optional although recommended if there are kindergarten and school in the same center, in separate buildings)
- source=Generalitat de Catalunya. Departament d'Educació
- source:date=2019-06-18
- description=* (optional, recommende for special education centers, see below **)
* ISCED level and ages
The equivalences in level and ages for the cycles are:
| Cycle | ISCED level | min_age | max_age |
|---|---|---|---|
| EINF1C | 0 | 0 | 3 |
| EINF2C | 1 | 3 | 6 |
| EPRI | 1 | 6 | 12 |
| ESO | 2 | 12 | 16 |
| BATX | 3 | 16 | 18 |
| AA01 | 2 | ||
| CFPM, CFAM, TEGM, PA01 | 3 | 16 | |
| PPAS, AA03 | 3 | 16 | |
| CFPS, CFAS, ESDI, DANS, MUSS, TEGS, PA02, ADR, CRBC | 5 | 18 | |
| PFI | 2 | 16 | 21 |
| DANE, MUSE | 1; 2 | ||
| DANP, MUSP | 2; 3 | 12 | 18 |
| ESTR | |||
| IDI | 16 | ||
| ADULTS | 1; 2; 3 | 18 | |
| EE | 1; 2 | 3 |
** Special Education Centers
Special education centers are educational centers adapted to students with specific needs, whether physical (blind, deaf, etc.) or cognitive. We'll indicate this property by adding the tag description=* 'Centre d'educació especial'. In future editions it can be completed indicating the type of adaptation it offers.
Changeset Tags
We will use the following changeset tags:
- comment=#Catalunya_Schools_import
- source=Generalitat de Catalunya. Departament d'Educació
- source:date=2019-06-18
- url=https://wiki.openstreetmap.org/wiki/Import_schools_in_Catalunya (this page)
- created_by=JOSM/version (this tag is created automatically by JOSM)