I am trying to build a database from scratch and for my Locations Table, I need a way to be able to obtain coordinates and political boundaries. The locations will all be in wilderness areas, so we can't use address-based data sets. Does anyone have any suggestions for how to do this in SQL Server, and what resources are available?
For example, is there a way to drop a pin on a map (e.g. based in Google maps, Bing, Esri, etc.) and the coordinates extract into the SQL database?
I am new to SQL Server Databases, pardon my naivete.