League of Oregon Cities

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

• API Docs
• Developer Portal

API Endpoint:

Field Names:

City

city

Population

population

QCODE

qcode

Region

region

How often are bills issued?

how_often_are_bills_issued

How often are bills issued? - Other (Please Specify) - Text

how_often_are_bills_issued_1

What methods of payment are accepted? (Check all that apply)

what_methods_of_payment_are

Do you provide paperless billing?

do_you_provide_paperless

What methods of enforcement are used for late or nonpayments? (Check all that Apply) - Selected Choice

what_methods_of_enforcement

What methods of enforcement are used for late or nonpayments? (Check all that Apply) - Other (Please Specify) - Text

what_methods_of_enforcement_1

What is the late fee rate?

what_is_the_late_fee_rate

What is the interest rate?

what_is_the_interest_rate

How many days past due date are allowed before the late fee is assessed?

how_many_days_past_due_date

What is the penalties amount and interest rate? - Penalties Amount

what_is_the_penalties_amount

What is the penalties amount and interest rate? - Interest Rate

what_is_the_penalties_amount_1

How many days after due date before you disconnect water service?

how_many_days_after_due_date

What dollar amount or number of days late triggers collections? - Dollar Amount

what_dollar_amount_or_number

What dollar amount or number of days late triggers collections? - Days

what_dollar_amount_or_number_1

Does the city provide waivers, discounts or reductions to certain utility customers?

does_the_city_provide_waivers

Please describe these waivers, discounts and reductions:

please_describe_these_waivers

Does your city provide credit or make any billing adjustments for leaks or billing errors?

does_your_city_provide_credit

For what services are adjustments made for customer water leaks

for_what_services_are

If a leak is detected, how far back does the city make adjustments to the water bill? - Days

if_a_leak_is_detected_how

If a leak is detected, how far back does the city make adjustments to the water bill? - Other Comments

if_a_leak_is_detected_how_1

Please describe what you do for wastewater adjustments.

please_describe_what_you

What percentage of rate revenue is obligated to debt services for the following systems? - Rate Revenue - Water - %

what_percentage_of_rate

What percentage of rate revenue is obligated to debt services for the following systems? - Rate Revenue - Wastewater - %

what_percentage_of_rate_1

What percentage of rate revenue is obligated to debt services for the following systems? - Rate Revenue - Stormwater - %

what_percentage_of_rate_2

What percentage of rate revenue is obligated to debt services for the following systems? - Not Applicable - Water

what_percentage_of_rate_3

What percentage of rate revenue is obligated to debt services for the following systems? - Not Applicable - Wastewater

what_percentage_of_rate_4

What percentage of rate revenue is obligated to debt services for the following systems? - Not Applicable - Stormwater

what_percentage_of_rate_5

Does your city maintain an asset management system for the following services? - Water

does_your_city_maintain_an

Does your city maintain an asset management system for the following services? - Wastewater

does_your_city_maintain_an_1

Does your city maintain an asset management system for the following services? - Stormwater

does_your_city_maintain_an_2

What was the last year you did a Rate Study for the following services? - Water

what_was_the_last_year_you

What was the last year you did a Rate Study for the following services? - Wastewater

what_was_the_last_year_you_1

What was the last year you did a Rate Study for the following services? - Stormwater

what_was_the_last_year_you_2

What was the last year you did a Methodology Update for the following services? - Water

what_was_the_last_year_you_3

What was the last year you did a Methodology Update for the following services? - Wastewater

what_was_the_last_year_you_4

What was the last year you did a Methodology Update for the following services? - Stormwater

what_was_the_last_year_you_5

Does your city require accounts to be in the name of the property owner?

does_your_city_require

How does your city handle billing for vacant properties? - Selected Choice

how_does_your_city_handle

How does your city handle billing for vacant properties? - Charge a vacant rate upon request of the owner. (Please Explain) - Text

how_does_your_city_handle_1

How does your city handle billing for vacant properties? - Other (Please Specify) - Text

how_does_your_city_handle_2

What other account fees or charges are included on the utility bill? (Check all that apply) - Selected Choice

what_other_account_fees_or

What other account fees or charges are included on the utility bill? (Check all that apply) - Other (Please Specify) - Text

what_other_account_fees_or_1

Is stormwater included in the utility bill?

is_stormwater_included_in

What general government fees are included on the utility bill? (Check all that apply) - Selected Choice

what_general_government_fees

What general government fees are included on the utility bill? (Check all that apply) - Other (Please Specify) - Text

what_general_government_fees_1

Does city ordinance have an automatic CPI/Income adjustment for the following services? - Water

does_city_ordinance_have

Does city ordinance have an automatic CPI/Income adjustment for the following services? - Wastewater

does_city_ordinance_have_1

Does city ordinance have an automatic CPI/Income adjustment for the following services? - Stormwater

does_city_ordinance_have_2

Does your city charge for drinking water service?

does_your_city_charge_for

What was the last effective date of your city's most recent rate change for water services? (Please respond with the year only)

what_was_the_last_effective

Overall, did the rate increase or decrease at the most recent rate change? Please also include the percent (%) change. - Selected Choice

overall_did_the_rate_increase

Overall, did the rate increase or decrease at the most recent rate change? Please also include the percent (%) change. - Increase (% Increase) - Text

overall_did_the_rate_increase_1

Overall, did the rate increase or decrease at the most recent rate change? Please also include the percent (%) change. - Decrease (% Decrease) - Text

overall_did_the_rate_increase_2

Why did the city change water rates? (Check all that apply) - Selected Choice

why_did_the_city_change_water

Why did the city change water rates? (Check all that apply) - Other (Please Specify) - Text

why_did_the_city_change_water_1

What is the rate structure for your city's water service? - Selected Choice

what_is_the_rate_structure

What is the rate structure for your city's water service? - Other (Please Specify) - Text

what_is_the_rate_structure_1

For water services, if you were to bill a residential customer for 5,000 gallons (6.684 CCFs) with a 3/4'' meter size, what dollar amount would you bill them, including the base rate?

for_water_services_if_you

Does your city charge for wastewater service?

does_your_city_charge_for_1

What was the last effective date of your city's most recent rate change for wastewater services? (Please respond with the year only)

what_was_the_last_effective_1

Overall, did the rate increase or decrease at the most recent rate change? Please include percent (%) change. - Selected Choice

overall_did_the_rate_increase_3

Overall, did the rate increase or decrease at the most recent rate change? Please include percent (%) change. - Increase (% Increase) - Text

overall_did_the_rate_increase_4

Overall, did the rate increase or decrease at the most recent rate change? Please include percent (%) change. - Decrease (% Decrease) - Text

overall_did_the_rate_increase_5

Why did the city change wastewater rates? (Check all that apply) - Selected Choice

why_did_the_city_change

Why did the city change wastewater rates? (Check all that apply) - Other (Please Specify) - Text

why_did_the_city_change_1

What is the rate structure for your city's wastewater service? - Selected Choice

what_is_the_rate_structure_2

What is the rate structure for your city's wastewater service? - Other (Please Specify) - Text

what_is_the_rate_structure_3

For wastewater services, if you were to bill a residential customer for 5,000 gallons (6.684 CCFs) with a 3/4'' meter size, what dollar amount would you bill them, including the base rate?

for_wastewater_services_if

Does your city charge for stormwater service?

does_your_city_charge_for_2

What was the last effective date of your city's most recent rate change for stormwater services? (Please respond with the year only)

what_was_the_last_effective_2

Overall, did the rate increase or decrease at the most recent rate change? Please include the percent (%) change. - Selected Choice

overall_did_the_rate_increase_6

Overall, did the rate increase or decrease at the most recent rate change? Please include the percent (%) change. - Increase (% Increase) - Text

overall_did_the_rate_increase_7

Overall, did the rate increase or decrease at the most recent rate change? Please include the percent (%) change. - Decrease (% Decrease) - Text

overall_did_the_rate_increase_8

Is your city subject to an MS4 Phase I or Phase II (DEQ Issued Stormwater) Permit?

is_your_city_subject_to_an

Why did the city change stormwater rates? (Check all that apply) - Selected Choice

why_did_the_city_change_2

Why did the city change stormwater rates? (Check all that apply) - Other (Please Specify) - Text

why_did_the_city_change_3

What is the rate structure for your city's stormwater service? - Selected Choice

what_is_the_rate_structure_4

What is the rate structure for your city's stormwater service? - Other (Please Specify) - Text

what_is_the_rate_structure_5

Does your city offer stormwater fee reductions or credits for onsite stormwater management?

does_your_city_offer

Please describe the reduction or credit (including the amount for onsite stormwater management)

please_describe_the_reduction

What does the average house pay for stormwater services (dollars per month)?

what_does_the_average_house

Does your city provide drinking water services?

does_your_city_provide

What is the service population in 2020? - Service Population (Permanent Residents) - Inside City Limits

what_is_the_service_population

What is the service population in 2020? - Service Population (Permanent Residents) - Outside City Limits

what_is_the_service_population_1

What is the service population in 2020? - Service Population (Including Peak Seasonal) - Inside City Limits

what_is_the_service_population_2

What is the service population in 2020? - Service Population (Including Peak Seasonal) - Outside City Limits

what_is_the_service_population_3

Please list the number of connections for the following: - Residential - Inside City Limits

please_list_the_number_of

Please list the number of connections for the following: - Residential - Outside City Limits

please_list_the_number_of_1

Please list the number of connections for the following: - Commercial - Inside City Limits

please_list_the_number_of_2

Please list the number of connections for the following: - Commercial - Outside City Limits

please_list_the_number_of_3

Please list the number of connections for the following: - Other - Inside City Limits

please_list_the_number_of_4

Please list the number of connections for the following: - Other - Outside City Limits

please_list_the_number_of_5

What is the annual average water consumption for residential customers (in gallons)?

what_is_the_annual_average

Please provide the following facility and water source information: - Total miles of water lines (all sizes), not including service laterals

please_provide_the_following

Please provide the following facility and water source information: - Total number of pumps and lift stations in your city

please_provide_the_following_1

Please provide the following facility and water source information: - How many levels or zones based on elevation do you have?

please_provide_the_following_2

Please provide the following facility and water source information: - How far away is the water source from the city (miles)?

please_provide_the_following_3

Please provide the following system age and capacity information: - Year of original system construction completion

please_provide_the_following_4

Please provide the following system age and capacity information: - Year of last major update

please_provide_the_following_5

Please provide the following system age and capacity information: - What is the capacity of your water source?

please_provide_the_following_6

Please provide the following system age and capacity information: - What is the design capacity of your water plant(s) (MGD)?

please_provide_the_following_7

Please provide the following system age and capacity information: - What was the average daily production in 2020 (MG)?

please_provide_the_following_8

Please provide the following system age and capacity information: - How much of your daily average production is sold (not including city use)?

please_provide_the_following_9

Please provide the following system age and capacity information: - What was the peak flow of water treated in a 24-hour period in 2020?

please_provide_the_following_10

Please list the amount of raw and treated water storage you have for the different types of applicable storage: - Closed Tanks - Raw Water Storage (MG)

please_list_the_amount_of

Please list the amount of raw and treated water storage you have for the different types of applicable storage: - Closed Tanks - Treated Water Storage (MG)

please_list_the_amount_of_1

Please list the amount of raw and treated water storage you have for the different types of applicable storage: - Covered Urban Reservoirs - Raw Water Storage (MG)

please_list_the_amount_of_2

Please list the amount of raw and treated water storage you have for the different types of applicable storage: - Covered Urban Reservoirs - Treated Water Storage (MG)

please_list_the_amount_of_3

Please list the amount of raw and treated water storage you have for the different types of applicable storage: - ASR Reservoir - Raw Water Storage (MG)

please_list_the_amount_of_4

Please list the amount of raw and treated water storage you have for the different types of applicable storage: - ASR Reservoir - Treated Water Storage (MG)

please_list_the_amount_of_5

Please list the amount of raw and treated water storage you have for the different types of applicable storage: - Other (Please Specify) - Text

please_list_the_amount_of_6

Please list the amount of raw and treated water storage you have for the different types of applicable storage: - Other (Please Specify) - Raw Water Storage (MG)

please_list_the_amount_of_7

Please list the amount of raw and treated water storage you have for the different types of applicable storage: - Other (Please Specify) - Treated Water Storage (MG)

please_list_the_amount_of_8

In what year will your daily production exceed design capacity?

in_what_year_will_your_daily

Does your city have an approved water conservation and management plan?

does_your_city_have_an

Do you measure water loss?

do_you_measure_water_loss

What method is used to determine water loss in the system? - Selected Choice

what_method_is_used_to

What method is used to determine water loss in the system? - Other (Please Specify) - Text

what_method_is_used_to_1

What percentage of the system does each type of meter represent? - Radio (%)

what_percentage_of_the_system

What percentage of the system does each type of meter represent? - Touch (%)

what_percentage_of_the_system_1

What percentage of the system does each type of meter represent? - Manual Read (%)

what_percentage_of_the_system_2

Do you have any additional comments on water services?

do_you_have_any_additional

Does your city provide wastewater services?

does_your_city_provide_1

What is the service population in 2020? - Service Population (Permanent Residents) - Inside City Limits 1

what_is_the_service_population_4

What is the service population in 2020? - Service Population (Permanent Residents) - Outside City Limits 1

what_is_the_service_population_5

What is the service population in 2020? - Service Population (Including Peak Seasonal) - Inside City Limits 1

what_is_the_service_population_6

What is the service population in 2020? - Service Population (Including Peak Seasonal) - Outside City Limits 1

what_is_the_service_population_7

Please list the number of connections for the following: - Residential - Inside City Limits 1

please_list_the_number_of_6

Please list the number of connections for the following: - Residential - Outside City Limits 1

please_list_the_number_of_7

Please list the number of connections for the following: - Commercial - Inside City Limits 1

please_list_the_number_of_8

Please list the number of connections for the following: - Commercial - Outside City Limits 1

please_list_the_number_of_9

Please list the number of connections for the following: - Other - Inside City Limits 1

please_list_the_number_of_10

Please list the number of connections for the following: - Other - Outside City Limits 1

please_list_the_number_of_11

What is the annual average wastewater base (volume) for a residential customer (x1000 gal. or 1.337 CCFs)?

what_is_the_annual_average_1

Please provide the following facility, lines, and treatment information: - Total miles of sewer lines (all sizes), not including service laterals

please_provide_the_following_11

Please provide the following facility, lines, and treatment information: - Total number of pumps and lift stations in your city

please_provide_the_following_12

Please provide the following facility, lines, and treatment information: - Total number of treatment plants

please_provide_the_following_13

Please provide the following facility, lines, and treatment information: - What percent of city wastewater lines also serve stormwater (i.e. combined sewer)?

please_provide_the_following_14

What level of wastewater treatment is provided to city wastewater (Check all that apply)? - Selected Choice

what_level_of_wastewater

What level of wastewater treatment is provided to city wastewater (Check all that apply)? - Other (Please Specify) - Text

what_level_of_wastewater_1

Please provide the following system age and capacity information: - Year of original plant construction completion

please_provide_the_following_15

Please provide the following system age and capacity information: - Year of last major plant update

please_provide_the_following_16

Please provide the following system age and capacity information: - What is the design capacity of your treatment plant(s) in dry weather (MGD)?

please_provide_the_following_17

Please provide the following system age and capacity information: - What is the design capacity of your treatment plant(s) in peak wet weather (MGD)?

please_provide_the_following_18

Please provide the following system age and capacity information: - What is the total amount of wastewater treated in 2020 (MG)?

please_provide_the_following_19

Please provide the following system age and capacity information: - What was the peak wet weather flow in 2020 (MGD)?

please_provide_the_following_20

Please provide the following system age and capacity information: - What was the peak dry weather flow in 2020 (MGD)?

please_provide_the_following_21

At what percent (%) capacity is the entire wastewater system operating?

at_what_percent_capacity

In what year will the wastewater system be at maximum capacity?

in_what_year_will_the

In what year will your daily production exceed design capacity? 1

in_what_year_will_your_daily_1

Does your city administer an industrial wastewater pre-treatment program?

does_your_city_administer

Does your city apply or provide reclaimed water to public/private property?

does_your_city_apply_or

What percentage (%) of total reclaimed water is reused/applied?

what_percentage_of_total

Where does this reuse and application occur (i.e. city park, private golf course, industrial cooling tower, etc.)?

where_does_this_reuse_and

Does your city apply biosolids to public/ private property?

does_your_city_apply_biosolids

Where does this biosolid application occur (i.e. city park, private golf course, etc.)?

where_does_this_biosolid

Does your city landfill biosolids?

does_your_city_landfill

What percentage (%) of biosolids are landfilled?

what_percentage_of_biosolids

Do you have any additional comments on wastewater services?

do_you_have_any_additional_1

Does your city provide stormwater services?

does_your_city_provide_2

Please list the number of accounts for the following: - Residential - Inside City Limits

please_list_the_number_of_12

Please list the number of accounts for the following: - Residential - Outside City Limits

please_list_the_number_of_13

Please list the number of accounts for the following: - Commercial - Inside City Limits

please_list_the_number_of_14

Please list the number of accounts for the following: - Commercial - Outside City Limits

please_list_the_number_of_15

Please list the number of accounts for the following: - Other - Inside City Limits

please_list_the_number_of_16

Please list the number of accounts for the following: - Other - Outside City Limits

please_list_the_number_of_17

Please provide the following facility and water source information: - Total miles of piped system

please_provide_the_following_22

Please provide the following facility and water source information: - Total miles of open channels, ditches, and swales

please_provide_the_following_23

What is the average Equivalent Dwelling Unit (EDU) for residential in square feet?

what_is_the_average_equivalent

Do you have any additional comments on stormwater services?

do_you_have_any_additional_2

Thank You for participating in this survey. Do you have any additional comments on any topic in this survey?

thank_you_for_participating