Spatial data

[hongbo-miao]

Techs

• GeoParquet
  • Add an spatial index in geoparquet format as optional opengeospatial/geoparquet#13
  • Integrations
    • Delta
      • [Feature Request] GeoParquet support delta-io/delta#2129
    • Apache Sedona
      • (Support GeoParquet) https://sedona.apache.org/latest-snapshot/tutorial/sql/#load-geoparquet
      • Delta integration: Sedona 173 delta lake tests apache/sedona#696
    • Trino
      • (Not support GeoParquet) FR: Support GeoParquet Format trinodb/trino#15847
      • Geospatial functions: https://trino.io/docs/current/functions/geospatial.html
    • GeoPandas
      • (Support GeoParquet) to_parquet
• Apache Sedona
  • Amazon EMR integration
  • AWS Glue integration
• GeoMesa
• Mosaic: needs Databricks
• PostGIS: for Postgres
• Pygeohash

Formats

• Well-Known Text (“WKT”)
• Well-Known Binary (“WKB”)
• Extended WKT and WKB (EWKT and EWKB)

Info

Link:

EWKT and EWKB are non-standard formats introduced by PostGIS. They enhance the WKT and WKB formats by including a spatial reference system identifier (SRID), which specifies the coordinate reference system to use with the data. Snowflake currently supports only WGS84, which maps to SRID=4326.
By default, Snowflake issues an error if an EWKB or EWKT input value contains an SRID other than 4326. Conversely, all EWKB and EWKT output values have SRID=4326.