Skip to content

Instantly share code, notes, and snippets.

@CodeKokeshi
Last active January 24, 2026 09:22
Show Gist options
  • Select an option

  • Save CodeKokeshi/47f94dab0f7ba3610fc5dc58574cfd2c to your computer and use it in GitHub Desktop.

Select an option

Save CodeKokeshi/47f94dab0f7ba3610fc5dc58574cfd2c to your computer and use it in GitHub Desktop.
The Latest Carmona Water District Rate Table and Math Implementation API
{
"config_version": 2026.0124172231,
"table_label": "January 2026 - Carmona Water District",
"effective_date": "2026-01-24",
"esf_rate": 3.5,
"service_types": [
{
"type_id": "RESIDENTIAL",
"display_name": "Residential",
"tiers": [
{
"min": 1,
"max": 10,
"is_minimum_charge": true,
"rate": 238.6
},
{
"min": 11,
"max": 20,
"is_minimum_charge": false,
"rate": 26.2
},
{
"min": 21,
"max": 30,
"is_minimum_charge": false,
"rate": 29.0
},
{
"min": 31,
"max": 40,
"is_minimum_charge": false,
"rate": 32.6
},
{
"min": 41,
"max": null,
"is_minimum_charge": false,
"rate": 37.0
}
]
},
{
"type_id": "COMMERCIAL",
"display_name": "Commercial/Industrial",
"tiers": [
{
"min": 1,
"max": 10,
"is_minimum_charge": true,
"rate": 477.2
},
{
"min": 11,
"max": 20,
"is_minimum_charge": false,
"rate": 52.4
},
{
"min": 21,
"max": 30,
"is_minimum_charge": false,
"rate": 58.0
},
{
"min": 31,
"max": 40,
"is_minimum_charge": false,
"rate": 65.2
},
{
"min": 41,
"max": null,
"is_minimum_charge": false,
"rate": 74.0
}
]
},
{
"type_id": "GOVERNMENT",
"display_name": "Government",
"tiers": [
{
"min": 1,
"max": 10,
"is_minimum_charge": true,
"rate": 238.6
},
{
"min": 11,
"max": 20,
"is_minimum_charge": false,
"rate": 26.2
},
{
"min": 21,
"max": 30,
"is_minimum_charge": false,
"rate": 29.0
},
{
"min": 31,
"max": 40,
"is_minimum_charge": false,
"rate": 32.6
},
{
"min": 41,
"max": null,
"is_minimum_charge": false,
"rate": 37.0
}
]
},
{
"type_id": "SEMI_COMMERCIAL_A",
"display_name": "Semi-Commercial A",
"tiers": [
{
"min": 1,
"max": 10,
"is_minimum_charge": true,
"rate": 417.55
},
{
"min": 11,
"max": 20,
"is_minimum_charge": false,
"rate": 45.85
},
{
"min": 21,
"max": 30,
"is_minimum_charge": false,
"rate": 50.75
},
{
"min": 31,
"max": 40,
"is_minimum_charge": false,
"rate": 57.05
},
{
"min": 41,
"max": null,
"is_minimum_charge": false,
"rate": 64.75
}
]
},
{
"type_id": "SEMI_COMMERCIAL_B",
"display_name": "Semi-Commercial B",
"tiers": [
{
"min": 1,
"max": 10,
"is_minimum_charge": true,
"rate": 357.9
},
{
"min": 11,
"max": 20,
"is_minimum_charge": false,
"rate": 39.3
},
{
"min": 21,
"max": 30,
"is_minimum_charge": false,
"rate": 43.5
},
{
"min": 31,
"max": 40,
"is_minimum_charge": false,
"rate": 48.9
},
{
"min": 41,
"max": null,
"is_minimum_charge": false,
"rate": 55.5
}
]
},
{
"type_id": "SEMI_COMMERCIAL_C",
"display_name": "Semi-Commercial C",
"tiers": [
{
"min": 1,
"max": 10,
"is_minimum_charge": true,
"rate": 298.25
},
{
"min": 11,
"max": 20,
"is_minimum_charge": false,
"rate": 32.75
},
{
"min": 21,
"max": 30,
"is_minimum_charge": false,
"rate": 36.25
},
{
"min": 31,
"max": 40,
"is_minimum_charge": false,
"rate": 40.75
},
{
"min": 41,
"max": null,
"is_minimum_charge": false,
"rate": 46.25
}
]
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment