CARTO & OSM: Using Overpass Turbo to create CARTO Sync Tables

README.md

Steps to create a synchronized table in CARTO that queries OSM for specific data.

1. Navigate to Overpass Turbo web interface and put on the map on the right the area you wnat to query
2. You can use the wizard or simply put this code and adapt it to your desired tags. Use the Map Features page from the OSM wiki to look for your desired tags.

[out:xml][timeout:25];
(
  node["amenity"="school"]({{bbox}});
);
out body;
>;
out skel qt;

3. Run the query and check if it's working, you should see points or lines being rendered on top of your basemap.
4. Open the Export interface and copy the link from Data ▶️ Raw data directly from Overpass API

5. Put that link on the URL text box on CARTO Connect new dataset interface and click on SUBMIT
6. Here you can choose to put a frequency and create a sync table or select Never and create a standard table

7. Several tables will be created, some with none geometries, some with your data depending on the geometry type you are importing.

That's it!

zz_carto.png

zz_osm.png