overture-buildings-philly.md

SELECT 
    id,
    names.primary AS primary_name,
    sources[1].dataset AS primary_source,
    ST_GeomFromBinary(geometry) AS geometry
FROM v2024_04_16_beta_0
WHERE type = 'building'
	AND ST_INTERSECTS(
		ST_GeomFromBinary(geometry),
		(
		SELECT 
	            ST_GeomFromBinary(geometry)
		FROM v2024_04_16_beta_0
		WHERE type = 'division_area'
		    AND subtype = 'locality'
		    AND country = 'US'
		    AND names.primary = 'Philadelphia'
		    ORDER BY ST_AREA(ST_GeomFromBinary(geometry)) DESC
		    LIMIT 1
		)
	);