Skip to content

Instantly share code, notes, and snippets.

@knapply
Last active October 27, 2021 09:17
Show Gist options
  • Save knapply/10504862508f38ca6e3593e5b9f89c8a to your computer and use it in GitHub Desktop.
Save knapply/10504862508f38ca6e3593e5b9f89c8a to your computer and use it in GitHub Desktop.
Global Administrative Unit Layers (GAUL) data -- admin levels 1 and 2 (used in GDELT events table)
gaul_1_url <- "https://data.apps.fao.org/map/gsrv/gsrv1/gaul/wfs?service=WFS&version=1.1.0&request=GetFeature&typeName=gaul:g2015_2014_1&srsName=EPSG%3A4326&maxFeatures=900000"
curl::curl_download(gaul_1_url, "gaul_adm1.kml")
gaul_2_url <- "https://data.apps.fao.org/map/gsrv/gsrv1/gaul/wfs?service=WFS&version=1.1.0&request=GetFeature&typeName=gaul:g2015_2014_2&srsName=EPSG%3A4326&maxFeatures=900000"
curl::curl_download(gaul_2_url, "gaul_adm2.kml")
gaul_1 <- sf::read_sf("gaul_adm1.kml") |>
sf::st_cast("GEOMETRYCOLLECTION") |>
sf::st_collection_extract("POLYGON")
##> Simple feature collection with 254725 features and 12 fields
##> Geometry type: POLYGON
##> Dimension: XY
##> Bounding box: xmin: -180 ymin: -89.9 xmax: 180 ymax: 83.6274
##> Geodetic CRS: WGS 84
##> # A tibble: 254,725 × 13
##> gml_id adm1_code adm1_name str1_year exp1_year status disp_area adm0_code adm0_name shape_leng shape_area FID wkb_geometry
##> <chr> <dbl> <chr> <dbl> <dbl> <chr> <chr> <dbl> <chr> <dbl> <dbl> <int> <POLYGON [°]>
##> 1 g2015_2014_1.3163 25386 Pirotski 2006 NA Member State NO 2648 Serbia 2.88 0.298 3162 ((22.749 43.3853, 22.749…
##> 2 g2015_2014_1.3383 2300 Morobe NA NA Member State NO 192 Papua New Guinea 12.9 2.91 3382 ((147.6322 -7.7149, 147.…
##> 3 g2015_2014_1.3383 2300 Morobe NA NA Member State NO 192 Papua New Guinea 12.9 2.91 3382 ((147.5375 -7.6933, 147.…
##> 4 g2015_2014_1.3383 2300 Morobe NA NA Member State NO 192 Papua New Guinea 12.9 2.91 3382 ((147.3485 -7.439, 147.3…
##> 5 g2015_2014_1.3383 2300 Morobe NA NA Member State NO 192 Papua New Guinea 12.9 2.91 3382 ((147.2456 -7.4055, 147.…
##> 6 g2015_2014_1.3383 2300 Morobe NA NA Member State NO 192 Papua New Guinea 12.9 2.91 3382 ((147.0512 -7.0533, 147.…
##> 7 g2015_2014_1.3383 2300 Morobe NA NA Member State NO 192 Papua New Guinea 12.9 2.91 3382 ((148.0287 -5.9598, 148.…
##> 8 g2015_2014_1.3383 2300 Morobe NA NA Member State NO 192 Papua New Guinea 12.9 2.91 3382 ((147.9461 -5.8989, 147.…
##> 9 g2015_2014_1.3383 2300 Morobe NA NA Member State NO 192 Papua New Guinea 12.9 2.91 3382 ((147.9901 -5.8225, 147.…
##> 10 g2015_2014_1.3383 2300 Morobe NA NA Member State NO 192 Papua New Guinea 12.9 2.91 3382 ((146.7268 -5.799, 146.7…
##> # … with 254,715 more rows
gaul_2 <- sf::read_sf("gaul_adm2.kml") |>
sf::st_cast("GEOMETRYCOLLECTION") |>
sf::st_collection_extract("POLYGON")
##> Simple feature collection with 255858 features and 14 fields
##> Geometry type: POLYGON
##> Dimension: XY
##> Bounding box: xmin: -180 ymin: -89.9 xmax: 180 ymax: 83.6274
##> Geodetic CRS: WGS 84
##> # A tibble: 255,858 × 15
##> gml_id adm2_code adm2_name str2_year exp2_year adm1_code adm1_name status disp_area adm0_code adm0_name shape_leng shape_area FID
##> <chr> <dbl> <chr> <dbl> <dbl> <dbl> <chr> <chr> <chr> <dbl> <chr> <dbl> <dbl> <int>
##> 1 g2015_2014_2.5382 23037 Surulere NA NA 2235 Oyo Member State NO 182 Nigeria 1.16 0.0653 5381
##> 2 g2015_2014_2.6295 190590 Ellembelle 2007 NA 1333 Western Member State NO 94 Ghana 1.87 0.0804 6294
##> 3 g2015_2014_2.5788 191422 Lavun 1999 NA 2231 Niger Member State NO 182 Nigeria 3.84 0.324 5787
##> 4 g2015_2014_2.5788 191422 Lavun 1999 NA 2231 Niger Member State NO 182 Nigeria 3.84 0.324 5787
##> 5 g2015_2014_2.7811 17418 Gualaco NA NA 1434 Olancho Member State NO 111 Honduras 2.69 0.187 7810
##> 6 g2015_2014_2.7873 17480 Alianza NA NA 1437 Valle Member State NO 111 Honduras 1.65 0.0164 7872
##> 7 g2015_2014_2.7873 17480 Alianza NA NA 1437 Valle Member State NO 111 Honduras 1.65 0.0164 7872
##> 8 g2015_2014_2.7873 17480 Alianza NA NA 1437 Valle Member State NO 111 Honduras 1.65 0.0164 7872
##> 9 g2015_2014_2.7873 17480 Alianza NA NA 1437 Valle Member State NO 111 Honduras 1.65 0.0164 7872
##> 10 g2015_2014_2.7873 17480 Alianza NA NA 1437 Valle Member State NO 111 Honduras 1.65 0.0164 7872
##> # … with 255,848 more rows, and 1 more variable: wkb_geometry <POLYGON [°]>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment