Deploying a local copy of the OSM db: https://wiki.openstreetmap.org/wiki/Osmosis/PostGIS_Setup

• osmium-tool, a command line tool to manipulate OSM data
• osmfilter, a command line tool to filter OSM data

• overpassify, a python library to OverpassQL transpiler
• Cartes, a python library offers some facilities to request and parse the results from the OpenStreetMap Nominatim (search engine) and Overpass (map data database) API.

• Overpass API via XML
• osmdata, R package to build Overpass querie

• KID2 Spot Application, a natural language interface for querying OpenStreetMap data via GPT.

• A relation [public_transport=stop_area](https://wiki.openstreetmap.org/wiki/FR:Tag:public transport=stop area) corresponds to a subway station of a single line. name= corresponds to the name of the station, possibly with the name of the line in parenthesis. Example: République (11).
• A relation public_transport=stop_area_group contain multiple stop areas, each of them corresponding to a single line. Its name can be different from the contained stop areas. Example: La Chapelle vs Gare du Nord.
• Interesting elements of apublic_transport=stop_area (example La Chapelle):
  • railway=stop such as 329096792 and 329096792, that are part of a relation type=route corresponding to the metro line: 4728208 and 123917 (one in each direction)
  • railway=subway_entrance with a name, such as Rue du Faubourg Saint-Denis and Rue Marx Dormoy