Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

"College, Texas, United States" should be "College Station, Texas, United States" #515

Open
duogenesis opened this issue Nov 19, 2024 · 0 comments

Comments

@duogenesis
Copy link
Member

In fact, several locations seem to be mislabelled.

WITH target_point AS (
  SELECT ST_SetSRID(ST_MakePoint(-96.314444, 30.601389), 4326) AS geom
)
SELECT
  *,
  ST_Distance(location.coordinates, target_point.geom) AS distance,
  ST_AsText(location.coordinates) AS location_geom
FROM
  location,
  target_point
ORDER BY
  location.coordinates <-> target_point.geom
LIMIT 10;
  id   |               short_friendly               |                   long_friendly                   |            city             | subdivision |    country    |                    coordinates                     |                        geom                        |   distance    |                location_geom                 
-------+--------------------------------------------+---------------------------------------------------+-----------------------------+-------------+---------------+----------------------------------------------------+----------------------------------------------------+---------------+----------------------------------------------
 24074 | College (Southwood Valley), United States  | College (Southwood Valley), Texas, United States  | College (Southwood Valley)  | Texas       | United States | 0101000020E6100000C139234A7B1358C0D59AE61DA7983E40 | 0101000020E6100000191BBAD91F1458C0952C27A1F4993E40 | 1116.29924058 | POINT(-96.3044 30.596300000000003)
 24068 | College, Texas, United States              | College, Texas, United States                     | College                     | Texas       | United States | 0101000020E61000000D1BD22E1B1558C0484A5C492C9D3E40 | 0101000020E6100000191BBAD91F1458C0952C27A1F4993E40 | 2026.13457381 | POINT(-96.32978411214954 30.613957009345796)
 24071 | College (L O Ball Memorial), United States | College (L O Ball Memorial), Texas, United States | College (L O Ball Memorial) | Texas       | United States | 0101000020E6100000BC0512143F1258C0DA1B7C6132953E40 | 0101000020E6100000191BBAD91F1458C0952C27A1F4993E40 | 3488.19028556 | POINT(-96.2851 30.5828)
 24069 | College (College Heights), United States   | College (College Heights), Texas, United States   | College (College Heights)   | Texas       | United States | 0101000020E6100000E9482EFF211558C08B6CE7FBA9A13E40 | 0101000020E6100000191BBAD91F1458C0952C27A1F4993E40 | 3664.13817276 | POINT(-96.3302 30.6315)
 24070 | College (Dove Crossing), United States     | College (Dove Crossing), Texas, United States     | College (Dove Crossing)     | Texas       | United States | 0101000020E61000005839B4C8761258C04F1E166A4D933E40 | 0101000020E6100000191BBAD91F1458C0952C27A1F4993E40 | 3806.99016471 | POINT(-96.2885 30.5754)
 24072 | College (Northgate), United States         | College (Northgate), Texas, United States         | College (Northgate)         | Texas       | United States | 0101000020E610000052499D80261658C0567DAEB6629F3E40 | 0101000020E6100000191BBAD91F1458C0952C27A1F4993E40 | 3839.73826608 | POINT(-96.3461 30.6226)
 24073 | College (Post Oak Forest), United States   | College (Post Oak Forest), Texas, United States   | College (Post Oak Forest)   | Texas       | United States | 0101000020E61000008E06F016481458C0508D976E12A33E40 | 0101000020E6100000191BBAD91F1458C0952C27A1F4993E40 | 3954.95710371 | POINT(-96.3169 30.637)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant