whosonfirst-data / whosonfirst-data

Who's On First is a gazetteer of places.
http://www.whosonfirst.org/
Other
417 stars 9 forks source link

Deprecate records at placetypes that do not exist in specific countries #1126

Open stepps00 opened 6 years ago

stepps00 commented 6 years ago

WOF has records in various countries, at various placetypes, that need to be tagged as "not current" and given an edtf:* date. The table below has the country, feature count and placetype about each set to tag as "not current".

Colombia, for example, has three records at the localadmin level. All three of these records need to be deprecated, as they do not represent actual divisions in Colombia.

Country Feature Count Placetype
Colombia 3 localadmin
Italy 1 county
Singapore 2 county
Albania 4 localadmin
Algeria 1 localadmin
Andorra 1 localadmin
Azerbaijan 1 county
Democratic Republic of the Congo 2 localadmin
Georgia 6 localadmin
Greenland 15 localadmin
Hungary 5 localadmin
Iceland 11 localadmin
Indian Ocean Territories 3 region
Indian Ocean Territories 1 localadmin
Kiribati 3 localadmin
Laos 1 localadmin
Macedonia 1 localadmin
Montenegro 2 county
Palestine 1 localadmin
Samoa 1 localadmin
Seychelles 1 localadmin
Slovakia 333 localadmin
Slovenia 2 localadmin
Tanzania 1 localadmin
Trinidad and Tobago 3 county
Tuvalu 1 county
Ukraine 1 localadmin
Vietnam 1 localadmin
Western Sahara 5 localadmin
stepps00 commented 6 years ago

@stepps00 to add links..

ImreSamu commented 6 years ago

Checking the Hungarian localadmin records --> they are Slovakian rekords ( 'SK' ) - near the border , mistaged as 'HU'

select id, meta from wf.wof_localadmin where properties->>'wof:country' = 'HU';

id meta
1125277753 {"wof:name": "Kecovo", "wof:repo": "whosonfirst-data", "wof:country": "HU", "wof:hierarchy": [{"region_id": 85684919, "country_id": 85633237, "continent_id": 102191581, "localadmin_id": 1125277753, "macroregion_id": 404227477}]}
1125277761 {"wof:name": "Slovenske Nove Mesto", "wof:repo": "whosonfirst-data", "wof:country": "HU", "wof:hierarchy": [{"region_id": 85684919, "country_id": 85633237, "continent_id": 102191581, "localadmin_id": 1125277761, "macroregion_id": 404227477}]}
1125289367 {"wof:name": "Ipelske Predmostie", "wof:repo": "whosonfirst-data", "wof:country": "HU", "wof:hierarchy": [{"region_id": 85684913, "country_id": 85633237, "continent_id": 102191581, "localadmin_id": 1125289367, "macroregion_id": 404227477}]}
1125374173 {"wof:name": "Slovenske Darmoty", "wof:repo": "whosonfirst-data", "wof:country": "HU", "wof:hierarchy": [{"region_id": 85684913, "country_id": 85633237, "continent_id": 102191581, "localadmin_id": 1125374173, "macroregion_id": 404227477}]}

the first record : Kečovo ( municipality of Slovakia )