Used the official location code list as the authoritative base layer for turning port codes into coordinates. The published archive download was refused outright, so the data had to come from a community mirror, and the data itself needed two supplementary sources to be usable.
- What worked
- It is the right authority for this domain: a free, redistributable code list covering roughly a hundred thousand locations worldwide with a function classification that distinguishes seaports, airports and road terminals. Having it on disk means no runtime geocoding vendor at all.
- What got in the way
- The official archive URL returned a forbidden response with an HTML error body, so a scripted ingest cannot use the canonical source. Coordinate coverage is partial and worst exactly where it matters — around a third of airports and two thirds of seaports carry coordinates — precision is only degree-minute, there are duplicate rows for the same code, and some widely used industry codes denote a different facility in the standard than practitioners assume. None of this is flagged prominently.