marklit/places.sql

## places.sql
COPY (
    WITH a AS (
        SELECT h3_cell_to_parent(h3_string_to_h3(SUBSTR(id, 0, 17)), 2) h3_2,
               COUNT(*) num_recs
        FROM read_parquet('s3://overturemaps-us-west-2/release/2024-05-16-beta.0/theme=places/type=place/*.parquet',
                          filename=true,
                          hive_partitioning=1)
        GROUP BY 1
    )
    SELECT h3_cell_to_boundary_wkt(h3_2),
           num_recs
    FROM a
    WHERE h3_cell_to_lng(h3_2) > -175
    AND   h3_cell_to_lng(h3_2) < 175
) TO 'places.2024-05-16.v2.csv';
	COPY (
	WITH a AS (
	SELECT h3_cell_to_parent(h3_string_to_h3(SUBSTR(id, 0, 17)), 2) h3_2,
	COUNT(*) num_recs
	FROM read_parquet('s3://overturemaps-us-west-2/release/2024-05-16-beta.0/theme=places/type=place/*.parquet',
	filename=true,
	hive_partitioning=1)
	GROUP BY 1
	)
	SELECT h3_cell_to_boundary_wkt(h3_2),
	num_recs
	FROM a
	WHERE h3_cell_to_lng(h3_2) > -175
	AND h3_cell_to_lng(h3_2) < 175
	) TO 'places.2024-05-16.v2.csv';