Match REPD and OSM on location

[edwardchalstrey1]

Postgres or can/should it be done there? Postgis (also for computing distances between 2 points).

• Convert with Python
• Compare locations with Postgis

[edwardchalstrey1]

I think, somehow make a point from the lat/lon of each table entry: https://postgis.net/docs/ST_MakePoint.html, then calculate the minimum distance using: https://postgis.net/docs/ST_DistanceSphere.html

This might be how: https://postgis.net/workshops/postgis-intro/knn.html