Retail Vacant Storefronts March 2024

The Economic Opportunity and Development Division of the Community Development Department maintains a listing of Cambridge’s ground floor vacant storefronts. This listing is not intended as a comprehensive source for ground floor vacancies in Cambridge. The data is sourced from Costar (an online real estate database), Cambridge Assessing Property Database, and staff commercial district inventory collection.

To learn more, please visit this interactive map on the topic, viewable at the following URL: https://cambridgegis.maps.arcgis.com/apps/MapTour/index.html?appid=8eb311a7bf3c48fcb10527eda76deddc

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"cambridgema-gov/retail-vacant-storefronts-march-2024-exmr-dxma\".\"retail_vacant_storefronts_march_2024\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.