Official street of the City of Madrid
This dataset provides the official street register (callejero) of the municipality of Madrid, maintained by the Ayuntamiento de Madrid. It is updated daily to reflect approvals of new street names, new routes, and numbering changes. The dataset is organized into two subsets: the current street register and the street register with historical evolution, both downloadable in CSV format. It includes road names, administrative data, and address numbering (police numbers) for the city. Historical coverage is partial, as older records have not been fully digitized. A related online query form and web service are available for checking specific addresses or name changes.Data set of the official street of the municipality of Madrid, which includes the daily update with the data that are incorporated continuously on the occasion of the approvals of denominations and new routes, as well as the numbering changes. It is structured in two subsets of data corresponding to: * Current street (daily update) * Street with historical evolution All files can be downloaded in CSV format. The street in force and the street with historical evolution contain the updated information regarding the roads, their names, their administrative data and the addresses of the city (police numbers). The historical information of the municipal street that is shown is not complete since it is not fully computerized. For more information about any address or toponym, you can direct a query through the form Callejero. Enquiry about name or number changes - SEDE ELECTRONIC (madrid.es). El Ayuntamiento de Madrid también ofrece el [servicio web del callejero oficial](https://eur06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdatos.madrid.es%2Fportal%2Fsite%2Fegob%2Fmenuitem.c05c1f754a33a9fbe4b2e4b284f1a5a0%2F%3Fvgnextoid%3Da1aa044ac5e56610VgnVCM1000001d4a900aRCRD%26vgnextchannel%3D374512b9ace9f310VgnVCM100000171f5a0aRCRD%26vgnextfmt%3Ddefault&data=05%7C02%7Ctransparenciaydatos%40madrid.es%7C856ecbe9639e468f912108dcf82ec0eb%7Cb4532aa618954964b9c022b1444.
Trust score
How is this computed?Weighted across five axes. Tap a ring for what it measures.
Data schema (20 fields)
Click a field to see example values.
| Field | Type | Description |
|---|---|---|
| COD_VIACod via | int | Official numeric code identifying the street.Official numeric code identifying the street. |
| VIA_SQCVia sqc | text | Sequence code distinguishing street segments or entries.Sequence code distinguishing street segments or entries. |
| VIA_CLASEVia clase | text | Type of thoroughfare, e.g. street, avenue, square.Type of thoroughfare, e.g. street, avenue, square. |
| VIA_PARVia par | text | Preposition or particle used in the street name.Preposition or particle used in the street name. |
| VIA_NOMBREVia nombre | text | Official name of the street, without accents.Official name of the street, without accents. |
| VIA_NOMBRE_ACENTOSVia nombre acentos | text | Official name of the street, including accents.Official name of the street, including accents. |
| COD_NDPCod ndp | int | Numeric code identifying the numbering point (portal).Numeric code identifying the numbering point (portal). |
| CLASE_NDPClase ndp | text | Type of numbering point, e.g. number or kilometre.Type of numbering point, e.g. number or kilometre. |
| NÚMERO | int | Street number assigned to the numbering point.Street number assigned to the numbering point. |
| CALIFICADOR | text | Qualifier letter distinguishing duplicate street numbers.Qualifier letter distinguishing duplicate street numbers. |
| FECHA_DE_ALTAFecha de alta | text | Date the numbering point record became active.Date the numbering point record became active. |
| FECHA_DE_BAJAFecha de baja | text | Date the numbering point record was deactivated.Date the numbering point record was deactivated. |
| TIPO_NDPTipo ndp | text | Type of location the numbering point refers to, e.g. portal.Type of location the numbering point refers to, e.g. portal. |
| UTMX_EDUtmx ed | number | UTM X coordinate in the ED50 reference system.UTM X coordinate in the ED50 reference system. |
| UTMY_EDUtmy ed | number | UTM Y coordinate in the ED50 reference system.UTM Y coordinate in the ED50 reference system. |
| UTMX_ETRSUtmx etrs | number | UTM X coordinate in the ETRS89 reference system.UTM X coordinate in the ETRS89 reference system. |
| UTMY_ETRSUtmy etrs | number | UTM Y coordinate in the ETRS89 reference system.UTM Y coordinate in the ETRS89 reference system. |
| LATITUD | text | Latitude of the numbering point in degrees, minutes and seconds.Latitude of the numbering point in degrees, minutes and seconds. |
| LONGITUD | text | Longitude of the numbering point in degrees, minutes and seconds.Longitude of the numbering point in degrees, minutes and seconds. |
| ANGULO_ROTULACIONAngulo rotulacion | number | Angle used for labelling the number on maps.Angle used for labelling the number on maps. |
Schema captured from ckan 5 days ago.
Query the data
Pick columns and a sort, then fetch a live preview straight from the source. Choose an API-filterable column (marked ▾) under “Where” to pick from its list of values.
Sample data (5 records)
Record 1COD_NDP: 11049663 · COD_VIA: 127
{
"COD_NDP": "11049663",
"COD_VIA": "127",
"LATITUD": "40°30'54.12'' N",
"NÚMERO": "2",
"UTMX_ED": "443214,74",
"UTMY_ED": "4485347,45",
"VIA_PAR": "DE",
"VIA_SQC": "",
"LONGITUD": "3°40'17.75'' W",
"TIPO_NDP": "PORTAL",
"CLASE_NDP": "NUMERO",
"UTMX_ETRS": "443105,38",
"UTMY_ETRS": "4485139,98",
"VIA_CLASE": "CALLE",
"VIA_NOMBRE": "ISABEL COLBRAND",
"CALIFICADOR": "B",
"FECHA_DE_ALTA": "13/10/1992",
"FECHA_DE_BAJA": "",
"ANGULO_ROTULACION": "85,86",
"VIA_NOMBRE_ACENTOS": "ISABEL COLBRAND"
}Record 2COD_NDP: 11049663 · COD_VIA: 127
{
"COD_NDP": "11049663",
"COD_VIA": "127",
"LATITUD": "40°30'54.12'' N",
"NÚMERO": "2",
"UTMX_ED": "443214,74",
"UTMY_ED": "4485347,45",
"VIA_PAR": "DE",
"VIA_SQC": "",
"LONGITUD": "3°40'17.75'' W",
"TIPO_NDP": "PORTAL",
"CLASE_NDP": "NUMERO",
"UTMX_ETRS": "443105,38",
"UTMY_ETRS": "4485139,98",
"VIA_CLASE": "CALLE",
"VIA_NOMBRE": "ISABEL COLBRAND",
"CALIFICADOR": "",
"FECHA_DE_ALTA": "01/01/1991",
"FECHA_DE_BAJA": "13/10/1992",
"ANGULO_ROTULACION": "85,86",
"VIA_NOMBRE_ACENTOS": "ISABEL COLBRAND"
}Record 3COD_NDP: 11049664 · COD_VIA: 127
{
"COD_NDP": "11049664",
"COD_VIA": "127",
"LATITUD": "40°30'52.74'' N",
"NÚMERO": "4",
"UTMX_ED": "443212,21",
"UTMY_ED": "4485305,01",
"VIA_PAR": "DE",
"VIA_SQC": "",
"LONGITUD": "3°40'17.85'' W",
"TIPO_NDP": "PORTAL",
"CLASE_NDP": "NUMERO",
"UTMX_ETRS": "443102,86",
"UTMY_ETRS": "4485097,54",
"VIA_CLASE": "CALLE",
"VIA_NOMBRE": "ISABEL COLBRAND",
"CALIFICADOR": "",
"FECHA_DE_ALTA": "01/01/1991",
"FECHA_DE_BAJA": "",
"ANGULO_ROTULACION": "86,29",
"VIA_NOMBRE_ACENTOS": "ISABEL COLBRAND"
}Record 4COD_NDP: 20057084 · COD_VIA: 127
{
"COD_NDP": "20057084",
"COD_VIA": "127",
"LATITUD": "40°30'40.61'' N",
"NÚMERO": "14",
"UTMX_ED": "442858,75",
"UTMY_ED": "4484933,55",
"VIA_PAR": "DE",
"VIA_SQC": "",
"LONGITUD": "3°40'32.75'' W",
"TIPO_NDP": "PARCELA",
"CLASE_NDP": "NUMERO",
"UTMX_ETRS": "442749,39",
"UTMY_ETRS": "4484726,08",
"VIA_CLASE": "CALLE",
"VIA_NOMBRE": "ISABEL COLBRAND",
"CALIFICADOR": "",
"FECHA_DE_ALTA": "13/10/1992",
"FECHA_DE_BAJA": "",
"ANGULO_ROTULACION": "27,04",
"VIA_NOMBRE_ACENTOS": "ISABEL COLBRAND"
}Record 5COD_NDP: 20057087 · COD_VIA: 127
{
"COD_NDP": "20057087",
"COD_VIA": "127",
"LATITUD": "40°30'40.95'' N",
"NÚMERO": "16",
"UTMX_ED": "442750,17",
"UTMY_ED": "4484945,03",
"VIA_PAR": "DE",
"VIA_SQC": "",
"LONGITUD": "3°40'37.36'' W",
"TIPO_NDP": "PORTAL",
"CLASE_NDP": "NUMERO",
"UTMX_ETRS": "442640,81",
"UTMY_ETRS": "4484737,56",
"VIA_CLASE": "CALLE",
"VIA_NOMBRE": "ISABEL COLBRAND",
"CALIFICADOR": "A",
"FECHA_DE_ALTA": "06/11/1998",
"FECHA_DE_BAJA": "",
"ANGULO_ROTULACION": "16,81",
"VIA_NOMBRE_ACENTOS": "ISABEL COLBRAND"
}Live sample captured at profiling time — values may have changed upstream.
Verification Status
Using the API
Query examples
curl -s 'https://datos.madrid.es/dataset/213605-0-callejero-oficial-madrid.rdf' -H 'Accept: application/rdf+xml'DCAT (RDF/XML) record: title, publisher, freshness and every distribution. This portal disallows /api/ in robots.txt, so this is the route to use.
Dataset
Volume & freshness
Coverage
- First published
- 2015-04-09
License
- ✓ Redistributable
- ✓ Attribution required
- Category: cc
Themes
Distributions (7)
213605-5-callejero-oficial-madrid
https://datos.madrid.es/dataset/213605-0-callejero-oficial-madrid/resource/213605-5-callejero-oficial-madrid/download/callejero20oficial20-20descripcic3b3n20de20ficheros.pdf110 KB
60 MB
1.1 MB
33 MB
628 KB
610 KB
1.2 MB
Source: ckan · Open original page