[Durham INC] Update on EHC (incl. small house/small lot) permits & demolitions

[David Eklund]

Thank you for your suggestions. I focused first on the selling price of the
new developments, specifically single family dwellings (SFD). One caveat -
the city's dataset only contains the price of the most recent sale, no
historical data, so if a property was (for example) sold in 2019 and then
sold again in 2020, this plot would not contain any information about the
2019 sale.

In this plot I've attempted to show:

   1. The 30-day rolling median sale price for all sales of all single
   family dwellings - *the blue line*
   2. The 30-day rolling median sale price for all sales that seem to be
   new construction (involves some guesswork of comparing new construction
   permits to sale date) - *the orange line*
   3. The sale price of all single family dwellings that involved an
   EHC-allowed new construction permit (i.e., hopefully all new small
   house/small lot single family homes) - *the red dots*

[image: Figure_2.png]
Apologies if some of the text is small; depending on how you view your
email you may be able to make it bigger by hitting Ctrl-+ or Cmd-+ on your
keyboard.

Will try to get to some of the other requests, though some may not be
possible (e.g., figuring out what the previous use of the property was,
since I don't have historical data).

David

On Tue, Jun 28, 2022 at 8:29 AM kjj1bg <kjj1bg at yahoo.com> wrote:

> And number of rentals destroyed and were they replaced by rentals or owner
> occupied units?
>
> Kelly Jarrett. Sent from iPhone. Please take misspellings and autocorrect
> errors lightly.
>
>
> On Jun 28, 2022, at 5:20 AM, Christy Ferguson <christymferg at gmail.com>
> wrote:
>
> Hi David,
>
> Four metrics would be interesting to know:  the average selling price of
> the new units, the average number of square feet of each new unit, the net
> number of new units, and the net increase/decrease in the number of
> multi-family units, especially duplexes.  Are those  knowable?
>
> Best,
> Christy
>
> Sent from my iPhone
>
> On Jun 27, 2022, at 11:23 PM, David Eklund <deklund at gmail.com> wrote:
>
> 
> Hello,
>
> Sometime back I sent an email with some analysis I did of a dataset I'd
> received from the city regarding the use of the EHC amendment in Durham
> since it was approved in Oct 2019. That dataset was curated by the city and
> even at the time was outdated. After some delay I finally figured out how
> to query the data myself, and can therefore provide some updated figures,
> along with correlations with demolitions and an interactive map.
>
>    - From Oct 2019 to mid-June, there were 244 permits issued that the
>    city marked as being enabled by the EHC amendment. Of these, 150 were for
>    new construction (the others were related to additions, alterations, and
>    foundation work, for example).
>    - Of those 150 new construction permits, 66 were for existing parcels
>    and 84 were new parcels (i.e., that had been subdivided from an existing
>    parcel). Of the 66 existing parcels, 19 had a demolition permit approved
>    sometime since 2018 associated with it; the other 47 did not. In the same
>    time period city-wide I found a total of 378 demolition permits (among 333
>    unique parcels).
>
> You can see a full interactive map of all EHC new construction permits
> here: https://durhamehc.onrender.com. Sites marked with a red marker had
> a demolition permit associated with them; sites with a blue marker did
> not have any associated demolition permit. Clicking on the marker will pop
> up the street address and the "Description" field of the associated new
> construction permit.
>
> <http://goog_691272343>
> [image: durhamehc_scaled.png] <http://durhamehc_scaled.png>
> Let me know if you have any further requests for information; this could
> be worth transitioning into a Code for Durham project if there are further
> use cases for it.
>
> David
> _______________________________________________
> INC Website: https://sites.google.com/view/durhaminc/
>
> Durham INC Mailing List
> inc-list at lists.deltaforce.net
> https://lists.deltaforce.net/mailman/listinfo/inc-list
>
> _______________________________________________
> INC Website: https://sites.google.com/view/durhaminc/
>
> Durham INC Mailing List
> inc-list at lists.deltaforce.net
> https://lists.deltaforce.net/mailman/listinfo/inc-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.deltaforce.net/pipermail/inc-list/attachments/20220630/2d5662f8/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: durhamehc_scaled.png
Type: image/png
Size: 124473 bytes
Desc: not available
URL: <https://lists.deltaforce.net/pipermail/inc-list/attachments/20220630/2d5662f8/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Figure_2.png
Type: image/png
Size: 136798 bytes
Desc: not available
URL: <https://lists.deltaforce.net/pipermail/inc-list/attachments/20220630/2d5662f8/attachment-0003.png>