gistfile1.txt

geosure=# \d h3_l8_union_cities_urban
                           Table "public.h3_l8_union_cities_urban"
              Column               |          Type          | Collation | Nullable | Default 
-----------------------------------+------------------------+-----------+----------+---------
 h3                                | text                   |           |          | 
 geom                              | geometry(Polygon,4326) |           |          | 
 source                            | text                   |           |          | 
 adm0_admin                        | text                   |           |          | 
 adm0_a3                           | text                   |           |          | 
 adm0_name                         | text                   |           |          | 
 adm0_gdp_md                       | text                   |           |          | 
 adm0_economy                      | text                   |           |          | 
 adm0_income_grp                   | text                   |           |          | 
 adm0_fips_10                      | text                   |           |          | 
 adm0_woe_id                       | text                   |           |          | 
 adm0_iso                          | text                   |           |          | 
 adm0_continent                    | text                   |           |          | 
 adm0_region_un                    | text                   |           |          | 
 adm0_subregion                    | text                   |           |          | 
 adm0_region_wb                    | text                   |           |          | 
 adm0_ne_id                        | text                   |           |          | 
 adm1_code                         | text                   |           |          | 
 adm1_iso_3166_2                   | text                   |           |          | 
 adm1_name                         | text                   |           |          | 
 adm1_type                         | text                   |           |          | 
 adm1_abbrev                       | text                   |           |          | 
 adm1_postal                       | text                   |           |          | 
 adm1_woe_name                     | text                   |           |          | 
 adm1_woe_id                       | text                   |           |          | 
 city_landscan                     | text                   |           |          | 
 nearest_pop_name                  | text                   |           |          | 
 nearest_pop_wikidataid            | text                   |           |          | 
 nearest_pop_wof_id                | text                   |           |          | 
 nearest_geonameid                 | text                   |           |          | 
 nearest_geoname_name              | text                   |           |          | 
 nearest_geoname_population        | text                   |           |          | 
 geoname_name_if_single            | text                   |           |          | 
 geom_centroid                     | geometry(Point,4326)   |           |          | 
 geonameid_if_single               | text                   |           |          | 
 geoname_fcode_if_single           | text                   |           |          | 
 geoname_fcode_name_list           | text                   |           |          | 
 nearest_city_geonameid            | text                   |           |          | 
 nearest_city_name                 | text                   |           |          | 
 nearest_city_population           | text                   |           |          | 
 overture_id                       | text                   |           |          | 
 overture_subtype                  | text                   |           |          | 
 overture_name                     | text                   |           |          | 
 overture_parent_id                | text                   |           |          | 
 overture_division_list            | text                   |           |          | 
 legatum_prosperity_score          | double precision       |           |          | 
 legatum_inclusive_societies       | double precision       |           |          | 
 legatum_safety_and_security       | double precision       |           |          | 
 pop_structures                    | bigint                 |           |          | 
 pop_population                    | integer                |           |          | 
 adm2_gid                          | text                   |           |          | 
 adm2_name                         | text                   |           |          | 
 adm2_type                         | text                   |           |          | 
 geosure_women                     | double precision       |           |          | 
 geosure_political                 | integer                |           |          | 
 geosure_lgbt_safety               | integer                |           |          | 
 geosure_health                    | integer                |           |          | 
 geosure_physical                  | integer                |           |          | 
 geosure_theft                     | double precision       |           |          | 
 legatum_womens_agency             | double precision       |           |          | 
 legatum_property_crime            | double precision       |           |          | 
 legatum_personal_freedom          | double precision       |           |          | 
 legatum_health                    | double precision       |           |          | 
 geosure_baseline_physical         | integer                |           |          | 
 geosure_baseline_lgbtq            | integer                |           |          | 
 geosure_baseline_women            | integer                |           |          | 
 geosure_baseline_theft            | integer                |           |          | 
 geosure_baseline_health           | integer                |           |          | 
 geosure_baseline_political        | integer                |           |          | 
 geosure_adm0_crime_class          | integer                |           |          | 
 geosure_structure_class           | integer                |           |          | 
 geosure_adm1_violent_crime_class  | integer                |           |          | 
 geosure_adm1_property_crime_class | integer                |           |          | 
 geosure_adm1_property_value_class | integer                |           |          | 
 geosure_population_class          | integer                |           |          | 
 geosure_adm0_risk                 | integer                |           |          | 
Indexes:
    "h3_l8_union_cities_urban_geom_centroid_idx" gist (geom_centroid)
    "h3_l8_union_cities_urban_geom_idx" gist (geom)
    "h3_l8_union_cities_urban_h3_idx" btree (h3)
    "idx_adm0_a3" btree (adm0_a3)
    "idx_adm0_admin" btree (adm0_admin)
    "idx_adm0_fips" btree (adm0_fips_10)
    "idx_adm0_iso" btree (adm0_iso)
    "idx_adm0_name" btree (adm0_name)
    "idx_adm0_woe_id" btree (adm0_woe_id)
    "idx_adm1_code" btree (adm1_code)
    "idx_adm1_iso" btree (adm1_iso_3166_2)
    "idx_adm1_name" btree (adm1_name)
    "idx_adm1_woe_name" btree (adm1_woe_name)
    "idx_adm2_gid" btree (adm2_gid)
    "idx_adm2_name" btree (adm2_name)
    "idx_pop_population" btree (pop_population)
    "idx_pop_structures" btree (pop_structures)