search

mwgg / Airports

A JSON database of 28k+ airports with ICAO/IATA codes, names, cities, two-letter country identifiers, elevation, latitude & longitude, and a timezone identifier
MIT License
513 stars 184 forks source link

Inconsistent use of " " or "-" in state names #113

Closed eatdostacos closed 3 months ago

eatdostacos commented 8 months ago

In the names for states, I often see some state names use spaces and some use dashes instead. For example, "Newfoundland and Labrador" is the state for "CYCA", yet "Newfoundland-and-Labrador" is the state for "CYWK". There's a mix of similar inconsistencies. Here's a few: "AGGR": "state": "Rennell and Bellona", "LECA": "state": "Castille-and-Leon"

There is also an almost even split for North Carolina with 164 instances of "state": "North-Carolina" and 151 instances of "state": "North Carolina". To find more examples, you can search for instances of '"state": "North ' and instances of '"state": "North-' to see the different ones.

Is there a standard? Should the space be the standard instead of the dash?

mwgg commented 3 months ago

Does seem like there's a fair few of these. I've fixed a bunch, what I could spot, but I'm sure there are others. The standard should of course be the official name of the state/region, i.e. as it appears in Wikipedia, for example.