raw_coords_with_countries¶
Info¶
Data contract for the coordinates with countries data from the raw sheets into raw. - name: Coordinates with Countries - version: 0.0.4 - status: draft
Terms of Use¶
Purpose¶
Data contract for the coordinates with countries data from the raw sheets into raw.
Servers¶
| Name | Type | Attributes |
|---|---|---|
| production | databricks | No description. • environment: production • roles: [{'role': 'Admins', 'description': 'Access to all the data and settings'}] • catalog: raw_production • host: dbc-2030845a-6c3b.cloud.databricks.com • schema_: nominatim |
| development | databricks | No description. • environment: development • roles: [{'role': 'Admins', 'description': 'Access to all the data and settings'}] • catalog: raw_development • host: dbc-03ed8bbb-c0ec.cloud.databricks.com • schema_: nominatim |
Schema¶
coords_with_countries¶
Table storing the coordinates with countries in the raw layer of the Biocloud.
| Field | Type | Attributes |
|---|---|---|
| decimal_latitude | double | Latitude in decimal degrees • primaryKey• primaryKeyPosition: 1 |
| decimal_longitude | double | Longitude in decimal degrees • primaryKey• primaryKeyPosition: 2 |
| country | string | The country name as identified by Nominatim's reverse geocoding |
| country_code | string | The ISO 3166-1 alpha-2 country code as identified by Nominatim's reverse geocoding |
| inserted_ts_utc | timestamp | UTC timestamp when record was inserted |
| updated_ts_utc | timestamp | UTC timestamp when record was last updated |