Feature request: new columns indicating lot intersection of supporting DCP layers

[allthesignals]

ZoLa lot detail views show users which layers the lot intersects with, including floodplain information, among other details. The app does this by performing spatial intersection queries on-the-fly. This is resource-intensive and inefficient.

It would help if PLUTO could include new columns - or include a supporting data product - that joined the spatial intersections of the following supporting tables:

• inclusionary_housing
• transitzones
• fresh_zones
• waterfront_access_plan
• coastal_zone_boundary
• lower_density_growth_management_areas
• floodplain_firm2007
• floodplain_pfirm2015
• mandatory_inclusionary_housing
• e_designations
• upland_waterfront_areas
• appendixj_designated_mdistricts

Because this information changes regularly, updates to supporting layers would need to trigger a refresh of the PLUTO columns or supporting product.

[AmandaDoyle]

@allthesignals Flagging that
firm07_flag (floodplain_firm2007) , pfirm15_flag (floodplain_pfirm2015) , edesignum (e_designations) are already included in PLUTO
We'll propose a way on how we can deliver the information from the spatial intersections that you need that are not included yet.

Are you also computing the zoning district / commercial overlay information on the fly as well?

[allthesignals]

Are you also computing the zoning district / commercial overlay information on the fly as well?

I think so!

[AmandaDoyle]

@baolingz remove floodplain_firm2007_flag,floodplain_pfirm2015_flag,e_designations_flag from output to avoid repetition, since these flags are already in PLUTO

[AmandaDoyle]

@baolingz rename sql queries so that they're prefixed with zola_
similar to the zoning_ sequence

[AmandaDoyle]

@baolingz Move pluto_zola_export.sql into 05_export.sh

[baolingz]

@AmandaDoyle I just updated the scripts and output.

[github-actions]

Stale issue message

[allthesignals]

Thanks everyone for working so hard on this1 :)

[allthesignals]

Hi all, how should I use these new flags?

I know there are flags for the current Pluto: edesignum, firm07_flag, pfirm15_flag. They're slightly cut off in Carto so they'll look like firm07_fla etc.