There are about 4000 US Addresses with a non-standardized 2 letter code in the StateOrProvince field. Most of these ~4000 are the states spelled out: ex: “California” rather than “CA”.
I have a list of proposed mass update SQL statements in a Google sheet: openchargemap.io data cleanup - Google Sheets
Some are misspellings, ex: “Tennesse”
Some have leading or trailing spaces: ex: “CA " or " NY”. Perhaps you can trim the input values when saving.
Interesting! Thanks for looking at that, we’d need to filter on country (WHERE CountryID=2) but we also would only be able to update items that have been manually entered, anything that comes from an imported source (approx 1000 of those items) pretty much has to stay as it was as subsequent imports will clobber any changes.
Long term though, we would like pretty much all of our data to come via OCPI data feeds directly from the networks themselves, at that point we could have automated cleanup (for all US OCPI imports). What we really need is people to convince US networks to provide data to us, we currently only have a 10 or so OCPI network imports and most of those are Russia and a few European networks.