report % of properties owned by LLCs with permit data
We want to see how many properties with 'LLC' in the property owner name field have permit data from the period of one year before LLC appeared in the name to one year after. Let's also look for any sale in the period from when LLC appeared in the name to the following year. Create a data set that conforms to the following parameters:
- Every PIN in HEAD with the string 'LLC' in HD_NAME field. Include their AV in the year they have LLC in the name.
- LEFT joined against PERMITTRACKING
- LEFT joined against IDORSALES (modified in the same way we modified it in modeldata)
- Indicator for whether there is a permit within the specified time period.
- Sale data for specified time period.
- Contextual information: location of PIN (address, xy, town, NBHD)
We then want to calculate:
- What % of properties have a permit associated with them?
- What % have a sale?
- What do the sales ratios look like for these properties with and without permit information?