🔧 AI Nachrichten Major AI platforms go down in unprecedented simultaneous outage(03.09.2026 um 17:34 Uhr)
🔧 AI Nachrichten ChatGPT, Claude, and Grok Down? Users Report Widespread Outages(03.09.2026 um 19:14 Uhr)
🔧 AI Nachrichten OpenAI Launches GPT-6 Astra, Says We May Have Entered the AGI Era(03.09.2026 um 22:08 Uhr)
🔧 AI Nachrichten Claude Comes to CarPlay as Fifth Major AI Chatbot App(05.09.2026 um 05:31 Uhr)
🔧 AI Nachrichten OpenAI’s GPT-6 Astra Is AGI, Says NVIDIA CEO Jensen Huang(07.09.2026 um 06:31 Uhr)
🔧 AI Nachrichten Blame AI companies for Mac mini and Mac Studio shortage(31.08.2026 um 10:32 Uhr)
🔧 AI Nachrichten Major AI platforms go down in unprecedented simultaneous outage(03.09.2026 um 17:34 Uhr)
🔧 AI Nachrichten ChatGPT, Claude, and Grok Down? Users Report Widespread Outages(03.09.2026 um 19:14 Uhr)
🔧 AI Nachrichten OpenAI Launches GPT-6 Astra, Says We May Have Entered the AGI Era(03.09.2026 um 22:08 Uhr)
🔧 AI Nachrichten Claude Comes to CarPlay as Fifth Major AI Chatbot App(05.09.2026 um 05:31 Uhr)
🔧 AI Nachrichten OpenAI’s GPT-6 Astra Is AGI, Says NVIDIA CEO Jensen Huang(07.09.2026 um 06:31 Uhr)
🔧 AI Nachrichten Blame AI companies for Mac mini and Mac Studio shortage(31.08.2026 um 10:32 Uhr)

🔧 Programmierung 🕛 kürzlich 4 Min Lesezeit
0

I turned a public-domain government CSV into a searchable index of every port and airport on Earth

↗ Quelle (dev.to)
🗣️ Stimme:
📑 Inhaltsübersicht

For a side project I needed something that turned out to be weirdly hard to find: a free, clean list of the world's seaports — real depths, coordinates, and the codes ships actually use. Everything out there was paywalled, login-walled, or a table that looked untouched since 2005.



So I built the thing I wanted. Then it grew: . Here's what I learned building it.






The data is all public domain — you just have to find it



No scraping, no licensing fees. Three public-domain sources do the heavy lifting:





  • NGA World Port Index (Pub 150) — a U.S. government dataset of ~4,000 ports, each with 100+ coded attributes (depths, max vessel size, pilotage, facilities…).


  • UN/LOCODE — the UNECE location codes.


  • OurAirports — a public-domain database behind the 9,640 airports (IATA/ICAO codes, runways, elevation).



Public data is everywhere; the value is in making it usable.






The data-cleaning was the actual project



The "just parse a CSV" part is where all the interesting bugs live:





  • Quoted fields with embedded newlines. The WPI CSV has multi-line values inside quotes. Naive split('\n') shreds it into garbage. You need a real CSV parser that respects quoting.


  • Offshore oil terminals listed with 900+ meter "depths." That's the ocean floor at the mooring buoy, not a harbor depth. Left in, they made my "deepest ports" ranking pure nonsense — a cluster of open-ocean SPM buoys beating every real deep-water port. I had to detect and filter them.


  • Zeros that mean "unknown." The source uses 0 for "not reported." Trust it blindly and you'll confidently render "0 m channel depth" for half the world.






Display data, or derive intelligence?



A depth of 14.5 m is boring. A depth that tells you "this berth can take a Panamax but not a Capesize" is useful. So I built a small inference layer: depth → vessel class for ports, and its aviation twin, runway length → aircraft class for airports.



The part I'm most into is the cross-modal graph: every port page lists its nearest airports, and every airport page lists its nearest seaports — computed at build time with a simple spatial grid. That linked structure is where a directory stops being a lookup table and starts being something you can explore.






14,000 pages, zero backend



The whole thing is Next.js, fully static. generateStaticParams runs over the entire dataset and pre-renders ~14,000 pages at build time. No database, no server, no runtime cost — it deploys to a CDN and is basically free to run and very fast.






The SEO lesson I didn't expect (the useful bit for other devs)



If you're building a programmatic site, here's a trap I hit face-first: dump 14,000 templated pages into Google's index and it flags you for "scaled / thin content." I learned this the hard way with an AdSense rejection.



The fix that worked: a lean core. Only the ~400 highest-quality pages per vertical are indexable and in the sitemap; the long tail stays fully live for users but is marked noindex, follow. You earn Google's trust with a small, genuinely-good set first, then expand the indexable core as the domain gains authority. If you're doing programmatic SEO, bake this in from day one instead of discovering it later.






It's free, and the data is yours





  • Browse it:

  • Also mirrored on .



All of it is built on public-domain data — use it for whatever you like.



I'd love feedback, especially from anyone in shipping, logistics, or aviation: what data or features would actually be useful to you? And for the builders — what would you make with a clean, global port + airport dataset?

Vollständiger Original-Bericht
Ausführliche Details, Code-Beispiele & Hersteller-Stellungnahme auf dev.to.
↗ Original-Artikel auf dev.to lesen
Wie bewertest du diesen Beitrag?
1 Klick Feedback
Teilen mit Netzwerk & Team:

Community-Analysen & Experten-Meinungen 0

Verfasse deine eigene Analyse, teile Workarounds oder diskutiere diesen Vorfall im Blog.
Noch keine Community-Analyse verfasst. Markiere einen Textabschnitt oder klicke oben auf Eigene Analyse verfassen“!
Community Pulse: Relevanz-Einschätzung
1 Klick Experten-Votum
🔴 Akute Relevanz 0%
🟡 In Evaluierung 0%
🟢 Keine Auswirkung 0%
Spannende Innovation 0%
Verwandte Story-Cluster & Quellen (Vektor-KI)
Port 8095 Engine
3 Quellen
GPT-6 Astra Release Today? OpenAI’s Next Major AI Model Is Almost Here
1 Quelle
Apple accuses OpenAI of destroying evidence as trade-secrets fight intensifies
1 Quelle
Major AI platforms go down in unprecedented simultaneous outage
Ähnliche Beiträge
🔍 Verwandte News

Auch interessante Nachrichten I turned a public-domain government CSV into a searchable index of every port and airport on Earth

Thematisch verwandte Begriffe: turned, publicdomain, government, into · 6 Treffer

Laden...

Videos werden geladen ...

Laden...

Beiträge werden geladen ...

Laden...

Videos werden geladen ...

Laden...

Beiträge werden geladen ...

Laden...

Videos werden geladen ...

Laden...

Beiträge werden geladen ...

Laden...

Videos werden geladen ...

Laden...

Beiträge werden geladen ...

Laden...

Videos werden geladen ...