Create Fiber Investment Proxy by Block/Track/Muni

[theryankelly]

This will initially be data analysis and the number of #12 could be an analysis process that expands to other municipalities in the future.

Potential questions to ask of data

• How many ft/miles of fiber/coaxial in city?
• How much ft/miles of fiber/coaxial per household?
• How much ft/miles of fiber/coaxial by street, etc.
• Is there more fiber in wealthier areas of city?
• Is there more fiber in whiter areas of city?
• Is there more fiber in commercial or residential areas?
• How much more copper cable infrastructure is there in the (hybrid fiber/coaxial) system?
• How much would it cost to put fiber on every street?
• How much would it cost to bring up underinvested areas?
• Fiber / Coaxial per ft/mile cost estimation
• Cost for "drops" (from street to home)
• Other costs/installation requirements related to fiber, i.e hubs, splits, racks, mini data centers in the field, etc

Data found here: https://mapc365.sharepoint.com/:f:/s/DigitalAccess/ElnEiM3BBQFGjMfpDJOjPbQBIP4qECplUJpXGlQx35oSoA?e=IEipyn

9 everett map found here S:\Network Shares\NEW K Drive\DataServices\Projects\Current_Projects\EconDev\Digital_Divide\Maps\Everett_Fiber_Routes.mxd

[theryankelly]

Notes from 2/7 Check-In:

• [ ] Will clip traced lines for RCN and Comcast to tract level to match there on Census Indicators #37
• [ ] Will also clip to block group to produce a map #38
• [ ] Will calculate and display in ft. for final output
• [x] Will start with Chelsea and Everett while waiting on RCN from Revere #8
• [x] Will not use GeoTel in Block or Tract aggregations for residential households.
• [x] @mapc-lberman and @japartridge to connect on files needed for clipping and calculating

[theryankelly]

I am moving this to the backlog as we will focus on just providing the block map of fiber coverage in the report. Will revisit if time.