Skip to content

data: recent SAT centre country batches share placeholder coordinates (570 validator warnings) #227

Description

@yakew7

Problem

npm run validate:places currently reports 570 near-duplicate-coordinate warnings in sat_centre.json (up from 0 after #171). 24 of those are exact-coordinate clusters (multiple different schools sharing the identical lat/lng), concentrated almost entirely in a handful of recently-added country batches:

City Schools sharing one coordinate
Dubai 19
Sharjah 17
Abu Dhabi 16
Istanbul 12
Al Ain 10
Seoul 8
Ajman 6
Kayseri 4
Lagos 3
Izmir 3
Yongin 3

UAE alone accounts for 68 of these. This pattern (many real, differently-named schools all pinned to one identical point) is the same class of bug fixed for two records in #171 - except here it looks systemic to how these country batches were entered, most likely one city-center coordinate copy-pasted for every school in that city instead of each school's own address.

Fix

For each flagged school (run npm run validate:places locally to get the full, current list — it changes as more countries get added), look up its real address/coordinates individually and correct lat/lng. Don't bulk-replace with new placeholder coordinates - #171's precedent is to geocode each one from its actual address (school website, Google Maps listing, etc.), not to just spread them apart arbitrarily.

Acceptance criteria

  • npm run validate:places warning count drops to (near) zero
  • Every corrected record still points at its actual real-world location, not just a coordinate that happens to no longer collide with another one

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't workingdataPlaces datasetowner-shauryaOwned by Shaurya

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions