DevelopmentProjectsProcessing

The Development Projects list contains events that are forced into the BAUS simulation. Buildings can be built, added, and demolished. The list contains two major classes of events:

1. Committed events that occur in all scenarios. These include:

• The pipeline of approved, funded, and highly likely projects in the early years of the forecast
• Recent development that has occurred or is under construction but occurs after the forecast's base year

2. Opportunity events that occur in select scenarios. These are large projects that are deemed feasible off model but won't get built in the normal process. For example, the posited redevelopment of a BART parking lot.

Format

The list enters BAUS as a single csv file with the format. We want to be able to produce this file on-the-fly from a set of GIS files that will be updated over time.

Sources

Currently we are building the list by combining information from 2 different time periods and 6 different sources. The time periods are:

• 2011-2015
• 2016 onward (though some of the inputs end in 2019 or 2020) The data sources are:
• Costar has commercial and apartments (proprietary, do not post online)
• Redfin has ownership residential
• BASIS Parcel data has ownership residential
• BASIS pipeline data has any type of developments but only for sfr, scl, son, Emeryville, South SF..
• Our Manual maps are compiled by us to track projects not in other data
• Our opp-sites map is compiled by us to represent potential large projects

Process

• Spatial join the 2010 parcels to each point file
• add new clean fields for the final list to each file
• translate variables into new fields
• merge files for committed projects
• build related demolish list
• merge committed and opportunity projects
• export csv (this csv still has proprietary data so do no post online)