csv geodata filter

• filters geodata stored in csv filetypes by their haversine distance from a given coordinate
• edit coords, radius, datafile in script and run

view fullscreen

howto:

1. make a route using GraphHopper
2. export route to .gpx file format by hitting the gpx button below waypoint input, and selecting the track checkbox
3. export points of interest data to .csv filetype if using overpass-turbo data mining utility, export data as .gpx & convert to .csv with gpx_converter:

   $ pip install gpx-converter
   $ python3
   >>> from gpx_converter import Converter
   >>> Converter(input_file='sample.gpx').gpx_to_csv(output_file='output.csv')
   

4. edit filter.py to include all the necessary files (GPXfile, poi file)
5. run filter.py
6. view output as csv or graphically with umap (ctrl+I import out.csv)

possible future expansions:

• instead of only selecting points within radius of a given point, select points within radius of a given path (or google maps route), to narrow down candidates for visitation on a roadtrip
• instead of only taking data from csv coordinates, also take data from alltrails to find hiking trails along the way/ nearby

further info:

• data for this project from skytruth

• additional geodata can be obtained through the overpass-turbo utility

  • guide
  • example map features

• openstreetmap.org

• haversine formula derivation

• AMLIS database

• metal mines

• metal mines ii

• AML hazards and problem types

• an interesting story about a west virginia mining disaster