A developer has released a free, searchable index that lists every seaport and airport on the planet—3,804 ports and 9,640 airports—without requiring sign-up or payment. The site, theportindex.online, lets users browse the data or download the full dataset in CSV or JSON format.

Why the index was needed

The creator set out to find a clean, up-to-date list of the world’s seaports and hit a wall: most commercial offerings sit behind paywalls, and the publicly available lists are often years out of date. Relying on incomplete or stale data forces analysts to waste hours cleaning spreadsheets, a cost that adds up across the industry. By pulling together three public sources—a US government port index, an international location code directory, and a crowdsourced airport database—the developer assembled a single, unified reference anyone can use instantly.

The data sources behind the scenes

  • NGA World Port Index – a U.S. government compilation that provides basic details for every recognized seaport.
  • UN/LOCODE – the United Nations’ location code system, which adds standardized identifiers for ports and airports.
  • OurAirports – a community-maintained collection of airport information, including runway lengths and coordinates.

Each source offers a different slice of the picture, but none alone delivers a ready-to-use, searchable catalog. Merging them required more than a copy-paste; the developer had to resolve inconsistencies, duplicate entries, and missing fields.

Cleaning the data: three hard-won lessons

  1. Embedded newlines break naïve parsers – CSV files that contain line breaks inside quoted fields cannot be split with a basic “split on newline” command. A proper CSV parser is essential to keep rows intact.
  2. Outlier values hide mistakes – some oil terminals listed depths of 900 meters, a figure that belongs to mooring buoys, not harbors. Filtering implausible numbers was necessary to keep depth-based rankings credible.
  3. Zeros are often placeholders – a depth recorded as zero usually means the measurement is unknown, not that the water is flat. Treating zero as missing data preserves the integrity of any analysis that depends on depth.

Adding value beyond raw numbers

The index does more than list coordinates. For ports, it translates depth into the classes of vessels that can safely dock, turning a single metric into a practical decision aid. For airports, runway length is mapped to the types of aircraft that can operate there, giving pilots and planners an at-glance assessment of capability.

A spatial grid links every port to its nearest airports and vice versa, turning the site into an exploration tool. Users can discover, for example, which airports lie within a short drive of a given harbor—a feature useful for multimodal freight planning.

Building a static-site engine at scale

The entire front end runs on Next.js with static generation. During the build process, roughly 14,000 pages—one for each port and airport—are pre-rendered. Because there is no database or server-side logic, the site incurs no ongoing compute costs; it lives on a content-delivery network (CDN) that serves pages instantly worldwide.

SEO pitfalls and the thin-content fix

Uploading thousands of templated pages can raise red flags with search engines, which may deem the site “thin content” and penalize rankings. The developer hit this problem when an AdSense application was rejected. The remedy was to keep the full set of pages live for visitors but add a noindex directive to all but the top 400 high-quality pages in each category. This tells crawlers that only the most valuable pages should appear in search results, preserving credibility while still offering the full dataset.

Who benefits, and what the limits are

  • Logistics firms can quickly verify whether a cargo ship fits a port’s depth limits without digging through multiple PDFs.
  • Airline planners gain instant access to runway-to-aircraft mappings, useful for route feasibility studies.
  • Developers and researchers receive a clean, machine-readable dump that can be imported into custom tools.

What’s next for the project

The creator is asking the community for feedback on additional features.

Takeaway

Решая проблемы с очисткой данных, добавляя слои инференса и избегая серверных затрат благодаря статической генерации, разработчик доказывает, что лаконичная архитектура способна создать полезный во всем мире инструмент — если вы готовы к периодическим обновлениям и соблюдению рекомендаций поисковых систем.