FACT Geographical Boundaries

Official boundaries of US geographical locations (from Census blocks to States) and European ones (from Local Administrative Units - LAU - to countries). Data sources are the Census TIGER (Topologically Integrated Geographic Encoding and Referencing database) in the US and GISCO (Geographic Information System of the COmmission) in Europe.

Use

1. Through the command line:

docker pull registry.git.nilu.no/fact/data/fact_geo:latest
docker run -t -i --name fact\_geo -e MARIADB\_DATABASE=FACT_geo -e MYSQL\_ROOT\_PASSWORD=devops -p 3307:3306 -d registry.git.nilu.no/fact/data/fact\_geo:latest

2. Through a docker-compose file:

version: '3.8'

services:
  fact_geo:
    image: registry.git.nilu.no/fact/data/fact_geo:latest
    container_name: fact_geo
    environment:
      MARIADB_DATABASE: FACT_geo
      MYSQL_ROOT_PASSWORD: devops
    ports:
      - "3307:3306"
    restart: unless-stopped

which could be executed with docker-compose up fact_geo -d.

The container makes available a MariaDB instance with the full database on employment FACT_geo. It is reachable on port 3307 of the localhost and the root password is 'devops'.

Specifications

Data size

Table            |Size (MB)|Rows (#)|
-----------------+---------+--------+
eu_countries     |     4.54|      37|
eu_macro_regions |     5.80|     125|
eu_municipalities|    58.16|   98188|
eu_provinces     |    12.72|    1514|
eu_regions       |     7.46|     334|
geometry_columns |     0.02|      10|
spatial_ref_sys  |     0.02|       2|
us_block_groups  |  1279.08|  239780|
us_blocks        | 11394.32| 8132968|
us_counties      |   128.50|    3234|
us_states        |    14.96|      56|
us_tracts        |   731.10|   84414|

Data structure

All geographical objects are converted to EPSG:4326.

Notes

Data is selected, downloaded, and reorganized from multiple data sources.

TIGER (Topologically Integrated Geographic Encoding and Referencing

The U.S. Census maintains https://www.census.gov/programs-surveys/geography/guidance/tiger-data-products-guide.html

We use TIGER 2020.

GISCO (Geographic Information System of the COmmission)

Gisco maintains https://ec.europa.eu/eurostat/web/gisco/geodata/reference-data/administrative-units-statistical-units

We use 2021 data.

Author

Riccardo Boero - ribo@nilu.no

Licenses

All the code and the resulting docker images in this project are subject to:

• GNU Generla Public License v2.

The data is released under:

• CC BY 4.0 license.

The input data is subject to:

• Eurostat data
• Census Terms of Service This product uses the Census Bureau Data API but is not endorsed or certified by the Census Bureau.

Citation

• Boero, Riccardo. 2024. “FACT Data: Geographical Boundaries.” OSF. doi:10.17605/OSF.IO/WNJXB.

Part of the Fine scAle eConomic daTa - FACT project:

• Boero, Riccardo. 2024. “Fine scAle eConomic daTa - FACT.” OSF. doi:10.17605/OSF.IO/PV4ZW.