tyrasd / overpass-turbo

A web based data mining tool for OpenStreetMap using the Overpass API.
https://overpass-turbo.eu
Other
891 stars 129 forks source link

Italian provinces borders not found #669

Open NicolasAmadori opened 8 months ago

NicolasAmadori commented 8 months ago

While trying to get all italian provinces borders i found out that for some 7 of them the border is not returned by the api. The query i am executing is: [out:json] area["ISO3166-2"= "IT-{initials}"]->.searchArea; ( relation(area.searchArea)["admin_level"="6"]; ); out geom;

using this vector values instead of {initials} -> INITIALS= [ 'AG', 'AL', 'AN', 'AO', 'AR', 'AP', 'AT', 'AV', 'BA', 'BT', 'BL', 'BN', 'BG', 'BI', 'BO', 'BZ', 'BS', 'BR', 'CA', 'CL', 'CB', 'CI', 'CE', 'CT', 'CZ', 'CH', 'CO', 'CS', 'CR', 'KR', 'CN', 'EN', 'FM', 'FE', 'FI', 'FG', 'FC', 'FR', 'GE', 'GO', 'GR', 'IM', 'IS', 'SP', 'AQ', 'LT', 'LE', 'LC', 'LI', 'LO', 'LU', 'MC', 'MN', 'MS', 'MT', 'VS', 'ME', 'MI', 'MO', 'MB', 'NA', 'NO', 'NU', 'OT', 'OR', 'PD', 'PA', 'PR', 'PV', 'PG', 'PU', 'PE', 'PC', 'PI', 'PT', 'PN', 'PZ', 'PO', 'RG', 'RA', 'RC', 'RE', 'RI', 'RN', 'RM', 'RO', 'SA', 'VS', 'SS', 'SV', 'SI', 'SR', 'SO', 'TA', 'TE', 'TR', 'TO', 'OG', 'TP', 'TN', 'TV', 'TS', 'UD', 'VA', 'VE', 'VB', 'VC', 'VR', 'VV', 'VI', 'VT' ]

The provinces not working are: AO, BL, BZ, CI, OT, PN, PU.

mmd-osm commented 8 months ago

area + rel(area) seems a bit complicated in this case. Maybe try:

[out:json];rel["ISO3166-2" ~ "^IT-(AG|AL|AN|AO|AR|AP|AT|AV|BA|BT|BL|BN|BG|BI|BO|BZ|BS|BR|CA|CL|CB|CI|CE|CT|CZ|CH|CO|CS|CR|KR|CN|EN|FM|FE|FI|FG|FC|FR|GE|GO|GR|IM|IS|SP|AQ|LT|LE|LC|LI|LO|LU|MC|MN|MS|MT|VS|ME|MI|MO|MB|NA|NO|NU|OT|OR|PD|PA|PR|PV|PG|PU|PE|PC|PI|PT|PN|PZ|PO|RG|RA|RC|RE|RI|RN|RM|RO|SA|VS|SS|SV|SI|SR|SO|TA|TE|TR|TO|OG|TP|TN|TV|TS|UD|VA|VE|VB|VC|VR|VV|VI|VT)$"]["admin_level"="6"]; out geom;

By the way, better ask howto questions on https://c.osm.org

simolg commented 6 months ago

https://it.wikipedia.org/wiki/ISO_3166-2:IT https://it.wikipedia.org/wiki/Province_d%27Italia

to see all the Italian provinces: rel["ISO3166-2"~"IT-"]["admin_level"="6"]; out geom;

OK : Belluno, Bolzano, Pordenone, Pesaro e Urbino rel["ISO3166-2"~"^IT-(BL|BZ|PN|PU)$"]["admin_level"="6"]; out geom;

they do not exist : Aosta (ex-province), Carbonia-Iglesias, Olbia-Tempio rel["ISO3166-2"~"^IT-(AO|CI|OT)$"]["admin_level"="6"]; out geom;