Map View (view)

Data license: Public Domain

84 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: year, status, size_category

CREATE VIEW map_view AS
    SELECT 
        address_display as address,
        net_units,
        year,
        status,
        latitude,
        longitude,
        CASE 
            WHEN net_units >= 200 THEN '🔴 200+ units'
            WHEN net_units >= 100 THEN '🟠 100-199 units'
            WHEN net_units >= 50 THEN '🔵 50-99 units'
            WHEN net_units >= 20 THEN '🟢 20-49 units'
            ELSE '🔷 <20 units'
        END as size_category
    FROM projects
    WHERE latitude IS NOT NULL;