DB Quacks SQL Tutorial · Chapter 7
Finding Nemo: A Spatial Odyssey
Deep-sea explorer duck surfaces in scuba gear. Dude! Im Nemos cousin, mapping the data ocean floor! Duck locations are latitude/longitude coordinates stored in our duck_locations.csv file. Find which ducks live within 10km of Central Pond using spatial extension!
Your task
Install spatial extension and find ducks within 10km of Central Pond using the 'data/duck_locations.csv' file. The pond location coordinates are provided. You will be performing geographical distance calculations.