This dataset created by the SADEI contains information about the populated places of my area, Asturias, including:
- Codes to identify the type of a populated place: CC/PP/EE (C: code of first level division called “Concejo”, P: code of second level division called Parroquia Rural and EE: code of third level division the real place)
- Name in Spanish and Asturian
- Statistics about: altitude, distance, area, men, women and number of apartments (main and not main)
The structure of places is a hierarchy of 3 levels: Concejo (Municipality), Parroquia rural and others like: city, town, suburb, etc. Depending on the type of place some statistics are missing and their values are indicated with a value of “-1″. For instance “Concejo” and “Parroquia Rural” do not have “altitude and distance” and third level places do not have “area”.
Anyway all this information is publicly available via the WESO SPARQL endpoint (5 star linked data) and a Pubby frontend (more information about the dataset can be found in nomenclator-asturias-2010 dataset at thedatahub.org) . The structure of the data and definitions is the next one:
- Noménclator definitions. Graph IRI: http://purl.org/weso/nomenclator/definitions . Total: 101 triples. Example at: http://purl.org/weso/nomenclator/ontology/Concejo
- Dump file (Turtle) (6.3 KB)
- Noménclator populated places dataset. Graph IRI: http://purl.org/weso/nomenclator/asturias/2010. Total: 60,196 triples. Example at: http://purl.org/weso/nomenclator/asturias/2010/resource/53/00/00
- Noménclator statistics definitions. Graph IRI: http://purl.org/weso/nomenclator/stats/ontology. Total: 68 triples. Example at: http://purl.org/weso/nomenclator/stats/ontology/physicaldata
- Dump file (Turtle) (3.5 KB)
- Noménclator statistics dataset. Graph IRI: http://purl.org/weso/nomenclator/asturias/2010/stats. Total: 370,160 triples.
- Dump file (Turtle) (27 MB)
- Area: http://purl.org/weso/nomenclator/asturias/2010/stats/resource/physicaldata/area/53/00/00
- Altitude: Example at: http://purl.org/weso/nomenclator/asturias/2010/stats/resource/physicaldata/altitude/53/08/02
- Distance: http://purl.org/weso/nomenclator/asturias/2010/stats/resource/physicaldata/distance/53/08/02
- Men: http://purl.org/weso/nomenclator/asturias/2010/stats/resource/sex/m/53/08/02
- Women: http://purl.org/weso/nomenclator/asturias/2010/stats/resource/sex/f/53/08/02
- Apartment (main): http://purl.org/weso/nomenclator/asturias/2010/stats/resource/apartment/main/53/08/02
- Apartment (not main): http://purl.org/weso/nomenclator/asturias/2010/stats/resource/apartment/notmain/53/08/02
Example of query: “Give me all municipalities that have more women than men”
The definitions have been made using the vocabularies:
The whole dataset uses links to other datasets (126,127):
- 1 link to NUTS
- 78 links to DBPedia one per each “Concejo”
- 78,859 links to DBPedia, one per each populated place and observation
- 55,146 links to Reference Data Gov UK, one per each populated place and observation
- 70,904 links to SDMX attributes (sex-m and sex-f)
- 29 links to GeoLinkedData.es
In order to create all this data we have used different tools:
- Google Refine and the RDF extension (to produce data)
- Pubby (to publish data)
- OpenLink Virtuoso (to store data)
- Google Maps API (to get lat and long of the populated places)
Collaborators:
- José Emilio Labra (Main Researcher of WESO Research Group at the University of Oviedo)
- Ignacio Fuertes (Researcher of WESO Research Group at the University of Oviedo)
- The first version of the Noménclator Asturias was developed in conjunction with my colleagues of CTIC: Luis Polo and Emilio Rubiera in 2006 as part of BOPA Project.
TO DO List
- Fix the missing values “-1″
- Create Named graphs to group populated places by divisions
- Create slices
- Reconciliate all populated places with the DBPedia resources