New answers tagged spatial-database
$sql = "SELECT points.name FROM polygons, points WHERE ST_CONTAINS(polygons.geom, Point(points.longitude, points.latitude)) AND polygons.name = 'California'";
Given the non-specific nature of your request, I'll assume that you are an American. Obstacle is often used an aviation context. From that, the most useful single source (current, traceable, accurate) will be the FAA Digital Obstacle File: The Digital Obstacle File (updated every 56 days) describes all known obstacles of interest to aviation users in ...
We provided an easy to use JSON format for country adjacency based on COW dataset, have a look and fork it on github :) https://github.com/P1sec/country_adjacency
Top 50 recent answers are included