Enabling reading GeoParquet

[sfkeller]

Add PostGIS type GEOMETRY to read GeoParquet (https://geoparquet.org/).

Reading GEOMETRY types POINT/LINESTRING/... would be first. Later GEOGRAPHY types could follow, finally a writer.

Note also the filter parameter in the URL with “…/theme=places/…”.

Here's a test case with the expected functionality adapted from https://docs.overturemaps.org/getting-data/duckdb/ :

SELECT
  id,
  names.primary as name,
  geometry                            -- the GEOMETRY type to be implemted 
FROM read_parquet('s3://overturemaps-us-west-2/release/2024-10-23.0/theme=places/type=place/*', filename=true, hive_partitioning=1)
WHERE 
  bbox.xmin BETWEEN -75 AND -73       -- Only use the bbox miny/miny values 
  AND bbox.ymin BETWEEN 40 AND 41     -- because they are point geometries.
  AND categories.primary = 'pizza_restaurant'