Create distance to vacant land feature - Githubissues

ccao-data / data-architecture

Codebase for CCAO data infrastructure construction and management

https://ccao-data.github.io/data-architecture/

6 stars 4 forks source link

Create distance to vacant land feature #295

Closed Damonamajor closed 8 months ago

Damonamajor commented 8 months ago

This PR:

Adds distance to vacant lot as a proximity CTAS. A vacant lot in this case is any class 100 land larger than 1,000 sqft.
Also adds our first ever ephemeral table - ephemeral_vacant_land, which gets used by the CTAS. @jeancochrane let me know if my schema setup here makes sense.
Adds missing doc block calls for the distance to university feature

A couple notes on this:

The vacant land feature takes about 2.5 hours to generate :/
Since we're matching parcel file to parcel file, class 100 parcels match with themselves and are the "nearest" vacant land, but that's okay for now