Utility & Franchise Fees 2014-2015

Franchise agreements are a legal arrangement between a city and another entity for use of the city’s public right-of-way. For using the right-of-way (abbreviated ROW) a company, organization, or other government body must pay a franchise fee or privilege tax. These agreements ensure that cities are compensated for special use of public services. This also prevents city residents from subsidizing extraordinary use of public space. These agreements often take the form of contracts or city ordinances which outline the rate charged, term and conditions, and any extra services provided by either party.

The League asks cities their rates and rate calculations for telecommunication and cable franchises in the recent past. Questions are also posed for other franchises, such as electricity, water, garbage, and franchises to other governments. This information is crucial to understanding revenue sources in Oregon cities and to forecasting revenue trends into the future.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"orcities/utility-franchise-fees-20142015-nccv-bybq\".\"utility_franchise_fees_20142015\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.