> ## Documentation Index
> Fetch the complete documentation index at: https://docs.fix6.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Global administrative boundaries

The global adminsitrative boundary dataset allows provides the geospatial information for the aggregation level of our [agricultural climate indicator](/datasets/ag_climate_risk) dataset.
It allows you to join datasets using geospatial joins.
This dataset's source is the [geoBoundaries](https://www.geoboundaries.org/) project, using the [comprehensive global administrative zones (CGAZ) datset](https://www.geoboundaries.org/globalDownloads.html).

The dataset we make available contains the "county" (ADM2) and "state" (ADM1) level administrative boundaries for all countries in the world.
The dataset is made to be queried geospatially, so you can query for the geographies that intersect or contain a given geometry.
This allows you to obtain the join key for other datasets.

## Column definitions

#### `shape_id`

This is the unique identifier for the adminsitrative boundary and is used as the join key for datasets aggregated to the administrative boundary level.

#### `shape_name`

This is the name of the administrative boundary, if available, in the local language.

#### `parent_state`

The `shape_id` of the parent administrative boundary at the state (ADM1) level, if one exists.

#### `parent_country`

The [ISO-3](https://en.wikipedia.org/wiki/ISO_3166-1_alpha-3) country code for the parent country of the administrative boundary.

#### `area_sqkm`

The calculated area of the administrative boundary in square kilometers.
This calculation is very good approximation, but not a perfect calculation of the area as it involves projecting the geometry to a [universal transverse mercator](https://en.wikipedia.org/wiki/Universal_Transverse_Mercator_coordinate_system) projection.

#### `geometry`

The [GeoJSON](https://geojson.org/) geometry of the administrative boundary in [EPSG:4326](https://en.wikipedia.org/wiki/World_Geodetic_System) projection.
If querying this dataset, the output will be provided based on your default and/or requested format, as specified in [Snowflake's documentation](https://docs.snowflake.com/en/sql-reference/data-types-geospatial#specifying-the-output-format-for-result-sets).