Closed ImreSamu closed 1 year ago
ImreSamu
commented
6 years ago the proposed mappings ( EU - WOF placetypes )
| EU hierarchical system | whosonfirst placetype | comment |
|---|---|---|
| NUTS0 | country | 28 country |
| NUTS1 | macroregion | 104 regions at NUTS 1 |
| NUTS2 | region | 281 regions at NUTS 2 |
| NUTS3 | ~county | 1348 regions at NUTS 3 level. |
| LAU ( Local Administrative Units) | 99 759 |
nvkelso
commented
6 years ago @ImreSamu Hey! Good to have you back working on Who's On First :)
Your proposal in https://github.com/whosonfirst-data/whosonfirst-data/issues/1209#issuecomment-394097604 generally looks workable except for LAU generally mapping to WOF's localadmin placetype (good) instead of locality (bad).
NOTE: I expect that not all LAU will be included in WOF at present, but almost all NUTS0, NUTS1, NUTS2, and NUTS3 should be. Does NUTS now include geometry for these at least as a centroid that we could import under CC0 or CC-BY to have the full set of features?
How would we add this data to WOF? At first I thought as a new set of concordances (with a nuts2016 namespace), but NUTS regions often span administrative units so it's not a 1:1 mapping. So maybe as a new nuts2016 property prefix and then property keys of nuts0, nuts1 & etc? For example: nuts2016:nuts0 = HU, nuts2018:nuts1 = HU01 (made up values).
This will require sources repo work and properties repo work. The sources repo description should specify that even though the prefix is nuts2016 it's only valid from 2018+?
Is there a reason to add the earlier NUTS codes, too?
/cc @stepps00.
ImreSamu
commented
6 years ago @nvkelso ! Thank for your answer and corrections ( -> "LAU = localadmin placetype " )
now I am still researching ...
my plan:
How would we add this data to WOF?
Let's discuss this topic - later. :smile:
ImreSamu
commented
6 years ago Geodata licensing :
I have received some information[1], but as I see - it is not OK for the project
[1] LAU data : http://ec.europa.eu/eurostat/web/gisco/geodata/reference-data/administrative-units-statistical-units/communes#commcentroids10
from the FAQ:
Q. Which are the rules and constraints for the usage of data for commercial purposes? A. Eurostat, being a license holder of the geospatial data coming from EuroGeographics, is not allowed to assign the rights for the usage of data. Our license agreement only covers non-commercial use. Please contact www.eurogeographics.org to obtain a license for commercial use.
http://ec.europa.eu/eurostat/web/gisco/faq
still researching ...
nvkelso
commented
6 years ago @ImreSamu We can still use the data you pointed at to add concordances to and validate our own data for the same. In terms of matching it up (for the concordances), could you see which countries have what % matches and propose a concordances PR?
Then for countries:
@stepps00 is also working on a GeoNames import that would bring in more localadmin records, too.
ImreSamu
commented
6 years ago There are a brand new ( 2018 ) version of the EU LAU list https://ec.europa.eu/eurostat/documents/345175/501971/EU-28-LAU-2018-NUTS-2016.xlsx
And I have created a simple wof-lau count(*) comparison by wof_country:
https://gist.github.com/ImreSamu/237f86f7728bee94f24e4ff2a3559bff
( WOF last git log: Mon Sep 17 18:03:10 2018 -0700 )
( Thinking about this problem ) imho : We can use the data in 2 ways
At least (the importing) only working for this countries ( ~ active local Wikidata community )
| country | LAU code mapping | label |
|---|---|---|
| AT | P964 | Austrian municipality key |
| DE | P439 | German municipality key |
| ES | P772 | INE municipality code |
| FR | P374 | INSEE municipality code |
| HU | P939 | KSH code |
| IT | P635 | ISTAT ID |
| SE | P525 | Swedish municipality code |
| SK | P782 | LAU |
I have wrote some draft SQL - and ~99.6% match
As I see -at least the Hungarian WOF data can be fixed with this method.
nvkelso
commented
6 years ago Rad! Sounds like a good plan :)
But looking at your Gist I wonder if we should first agree what WOF placetype matched up to what EU_LAU as I don't think they're always locality, sometimes county, sometimes localadmin?
@stepps00 Can you link the placetype per country sheet here?
stepps00
commented
6 years ago Here is a breakdown of placetypes per country I compiled through recent placetype cleanup: https://github.com/whosonfirst/whosonfirst-cookbook/blob/master/definition/placetypes_by_country.md
Open to changing this if we recognize an issue.
ImreSamu
commented
6 years ago But looking at your Gist I wonder if we should first agree what WOF placetype matched up to what EU_LAU as I don't think they're always locality, sometimes county, sometimes localadmin?
yes, it is different country-by-country
imho: we need country-by-country metadata rules - for comparing with other databases
(last update 10/04/2018, based on NUTS 2016 and LAU 2017) - frequent changes@stepps00 : thank you ;
example:
admin_level=4 and boundary=administrative in Hungaryadmin_level=5 and boundary=administrative in Hungary admin_level=6 and boundary=administrative in Hungaryadmin_level=8 and boundary=administrative in HungaryThere are lot of 'Wikidata property for authority control for administrative subdivisions' and I need a country specific wof-wikidata metadata for fine matching.
wikidata query - for actual - admin properties: http://tinyurl.com/y7r23dpu
example:
...
-CBS municipality code (P382)
-dantai code (P429)
-German municipality key (P439)
-German district key (P440)
-China administrative division code (P442)
-Swedish county code (P507)
-Swedish municipality code (P525)
-NUTS code (P605)
-ISTAT ID (P635)
-OKATO ID (P721)
-OKTMO ID (P764)
-Swiss municipality code (P771)
-INE municipality code (P772)
-ISO 3166-3 (P773)
-FIPS 55-3 (locations in the US) (P774)
-LAU (P782)
-Italian cadastre code (P806)
-FIPS 10-4 (countries and regions) (P901)
-KSH code (P939)
-Austrian municipality key (P964)
-Thailand central administrative unit code (P1067)
-KOATUU identifier (P1077)
-ATVK ID (P1115)
-ELSTAT geographical code (P1116)
-EHAK id (P1140)
...NUTS 2021 is out now... and there are a few other issues that track this now for:
statistical WOF placetype as NUTS is now closer to administrative geography, but still not 100% and should be treated as a special thing.
The EU territorial code system was modified on 1 January 2018.
The " current
NUTS 2016classification is valid from 1 January 2018 and lists 104 regions at NUTS 1, 281 regions at NUTS 2 and 1348 regions at NUTS 3 level." see more : http://ec.europa.eu/eurostat/web/nuts/backgrounddetails: http://ec.europa.eu/eurostat/documents/345175/629341/NUTS2013-NUTS2016.xls
NUTS 1 changes ( major socio-economic regions)
NUTS 2 changes (basic regions for the application of regional policies )
NUTS 3 changes ( small regions for specific diagnoses )
... see XLS http://ec.europa.eu/eurostat/documents/345175/629341/NUTS2013-NUTS2016.xls
special comment for Hungary
the official info about the changes : https://www.ksh.hu/regional_atlas_counties?lang=en but the wikipedia pages not yet updated ( be careful! ) https://en.wikipedia.org/wiki/NUTS_statistical_regions_of_Hungary