This PR addresses #182 by updating the SQL queries that calculate project statistics (on the about page), and pulls in profile data from Carto.
Note
In app/routes/about.js, where we calculate the stats for "publiclyowned":
-- app/routes/about.js
WITH
publiclyowned AS (
SELECT
count(*)
FROM planninglabs.publiclyownedwaterfront -- <== old view
WHERE status LIKE 'Constructed%25'
),
The new view, wam_publiclyownedwaterfront does not have a status or construci field to query on:
.
This PR does not change the publiclyowned view, since there was nothing to query on with the new view.
Check that updates are successful:
[x] Sky View Parc. The profile says the site is “under construction”, but should be “Open”
[x] 155 West Street. The profile says the site is “under construction”, but should be “Open”
[x] 1 Huron Street. This site is recently “Approved (to be constructed)”, and should have a profile, but it is not possible to click on the polygon.
[x] Seafood City. Should be “Open” (the polygon appears green), but it is not possible to click on the polygon/ view the profile.
This PR addresses #182 by updating the SQL queries that calculate project statistics (on the
aboutpage), and pulls in profile data from Carto.Note
In
app/routes/about.js, where we calculate the stats for "publiclyowned":The new view,
.
wam_publiclyownedwaterfrontdoes not have astatusorconstrucifield to query on:This PR does not change the
publiclyownedview, since there was nothing to query on with the new view.Check that updates are successful:
[x] Sky View Parc. The profile says the site is “under construction”, but should be “Open”
[x] 155 West Street. The profile says the site is “under construction”, but should be “Open”
[x] 1 Huron Street. This site is recently “Approved (to be constructed)”, and should have a profile, but it is not possible to click on the polygon.
[x] Seafood City. Should be “Open” (the polygon appears green), but it is not possible to click on the polygon/ view the profile.