Import/Sachsen-Anhalt Naturschutzgebiete/Wikidata

From OpenStreetMap Wiki
Jump to: navigation, search

This SPARQL query

#Naturschutzgebiete in Sachsen-Anhalt (Q1206)
SELECT ?nr ?nrLabel ?nrDescription ?website ?coord ?WDPA_id WHERE {
  ?nr wdt:P31 wd:Q759421.
  ?nr wdt:P131* wd:Q1206.
  ?nr wdt:P625 ?coord.
  OPTIONAL { ?nr wdt:P856 ?website. }
  OPTIONAL { ?nr wdt:P809 ?WDPA_id. }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "de". }


will load all entities that are (P:31) Naturschutzgebiete (Q759421), and located within the administrative boundary or any subdivision thereof (P:131*) of Saxony-Anhalt (Q1206).

This will be downloaded as CSV, loaded into QGIS and saved as shapefile.

An example of the attribute table looks like this:

nr nrLabel nrDescript website WDPA_id image Ohre-Drömling Naturschutzgebiet in Sachsen-Anhalt, Deutschland 344828 Ohreaue Naturschutzgebiet im Altmarkkreis Salzwedel, Sachsen-Anhalt, Deutschland 318911

The following attribute transforms will then be performed:

new field name created with expression for QGIS field calculator
wikidata replace("nr", '','')

The fields "nr","nrLabel","nrDescript","website" will be deleted.