Skip to content

Instantly share code, notes, and snippets.

@matthewberryman

matthewberryman/water_taps.sql

Created February 14, 2018 04:03
Show Gist options
  • Save matthewberryman/8c50fa774f55e330f219a0769d98028a to your computer and use it in GitHub Desktop.
Save matthewberryman/8c50fa774f55e330f219a0769d98028a to your computer and use it in GitHub Desktop.
Download ZIP
water tap extraction from West Africa HOT openstreetmap data
Raw
water_taps.sql
SELECT * from osm.planet
WHERE type = 'node'
AND tags['man_made'] IN ('water_tap')
AND lon BETWEEN -15.0863 AND -7.3651
AND lat BETWEEN 4.3531 AND 12.6762;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment