gistfile1.txt

{
  "table": "h3_l8_union_cities_urban",
  "description": "Hex-level spatial dataset (H3 resolution 8) combining administrative, urban, prosperity, safety, and structure/property data.",
  "fields": {
    "spatial_identity": [
      {
        "name": "h3",
        "type": "text",
        "description": "H3 index at resolution 8 (~0.74 km²)"
      },
      {
        "name": "geom",
        "type": "geometry(Polygon,4326)",
        "description": "Polygon geometry of the H3 cell"
      },
      {
        "name": "geom_centroid",
        "type": "geometry(Point,4326)",
        "description": "Centroid of the H3 cell polygon"
      }
    ],
    "admin_context": [
      {
        "prefix": "adm0_",
        "description": "Country-level administrative metadata (admin 0)"
      },
      {
        "prefix": "adm1_",
        "description": "State/province-level metadata (admin 1)"
      },
      {
        "name": "adm2_name",
        "type": "text",
        "description": "County-level or admin 2 name"
      },
      {
        "name": "adm2_gid",
        "type": "text",
        "description": "Admin 2 GADM-style global ID"
      }
    ],
    "urban_identifiers": [
      {
        "name": "city_landscan",
        "type": "text",
        "description": "LandScan-tagged major urban area, if any"
      },
      {
        "name": "nearest_city_name",
        "type": "text",
        "description": "Closest large city by GeoNames"
      },
      {
        "name": "nearest_geoname_name",
        "type": "text",
        "description": "Nearest populated place by GeoNames"
      },
      {
        "name": "overture_name",
        "type": "text",
        "description": "Name from Overture Maps locality dataset"
      }
    ],
    "prosperity_legatum": [
      {
        "name": "legatum_prosperity_score",
        "type": "double",
        "description": "Overall prosperity score"
      },
      {
        "name": "legatum_inclusive_societies",
        "type": "double",
        "description": "Inclusivity and social cohesion"
      },
      {
        "name": "legatum_safety_and_security",
        "type": "double",
        "description": "Perceived safety/crime at local level"
      },
      {
        "name": "legatum_property_crime",
        "type": "double",
        "description": "Perceived property crime"
      },
      {
        "name": "legatum_womens_agency",
        "type": "double",
        "description": "Freedom and autonomy for women"
      },
      {
        "name": "legatum_personal_freedom",
        "type": "double",
        "description": "Freedom of expression and action"
      },
      {
        "name": "legatum_health",
        "type": "double",
        "description": "Healthcare access and quality"
      }
    ],
    "geosure_raw_scores": [
      {
        "name": "geosure_women",
        "type": "double",
        "description": "Safety index for women"
      },
      {
        "name": "geosure_lgbt_safety",
        "type": "integer",
        "description": "LGBTQ+ safety index"
      },
      {
        "name": "geosure_health",
        "type": "integer",
        "description": "Health-related risk index"
      },
      {
        "name": "geosure_physical",
        "type": "integer",
        "description": "Physical safety index"
      },
      {
        "name": "geosure_political",
        "type": "integer",
        "description": "Political safety/stability index"
      },
      {
        "name": "geosure_theft",
        "type": "double",
        "description": "Index of petty theft or crime"
      }
    ],
    "geosure_baseline_scores": [
      {
        "name": "geosure_baseline_physical",
        "type": "integer",
        "description": "Baseline physical safety class"
      },
      {
        "name": "geosure_baseline_lgbtq",
        "type": "integer",
        "description": "Baseline LGBTQ+ safety class"
      },
      {
        "name": "geosure_baseline_women",
        "type": "integer",
        "description": "Baseline women's safety class"
      },
      {
        "name": "geosure_baseline_theft",
        "type": "integer",
        "description": "Baseline theft/property risk class"
      },
      {
        "name": "geosure_baseline_health",
        "type": "integer",
        "description": "Baseline healthcare risk class"
      },
      {
        "name": "geosure_baseline_political",
        "type": "integer",
        "description": "Baseline political stability class"
      }
    ],
    "geosure_classified_jenks_1_to_12": [
      {
        "name": "geosure_adm0_crime_class",
        "type": "integer",
        "description": "Country-level (adm0) crime index class (Jenks 1–12)"
      },
      {
        "name": "geosure_adm1_property_crime_class",
        "type": "integer",
        "description": "Property crime class at state/province (adm1) level"
      },
      {
        "name": "geosure_adm1_violent_crime_class",
        "type": "integer",
        "description": "Violent crime class at state/province (adm1) level"
      },
      {
        "name": "geosure_structure_class",
        "type": "integer",
        "description": "Structure density class (1–12, Jenks)"
      },
      {
        "name": "geosure_population_class",
        "type": "integer",
        "description": "Population density class (1–12, Jenks)"
      },
      {
        "name": "geosure_adm1_property_value_class",
        "type": "integer",
        "description": "Median property value index by adm1 region (1–12 Jenks)"
      }
    ],
    "raw_population_and_structures": [
      {
        "name": "pop_structures",
        "type": "bigint",
        "description": "Estimated number of physical structures in cell"
      },
      {
        "name": "pop_population",
        "type": "integer",
        "description": "Estimated population in cell"
      }
    ]
  },
  "classification_notes": {
    "jenks_classified_fields": [
      "geosure_structure_class",
      "geosure_population_class",
      "geosure_adm0_crime_class",
      "geosure_adm1_property_crime_class",
      "geosure_adm1_violent_crime_class",
      "geosure_adm1_property_value_class"
    ],
    "classification_method": "Jenks natural breaks",
    "scale": "1 (low) to 12 (high)",
    "purpose": "To normalize continuous or regional crime, structure, and economic metrics into ordinal spatial classes for comparison"
  }
}