Stack Overflow
Stack Overflow

Questions tagged [geography]

Geography is the science that deals with the study of the Earth and its lands, features, inhabitants, and phenomena.

The use of traditional spatial techniques used in cartography and topography and their application to computers is called geomatics, which encompasses a large area of fields involved with analysis, such as , Geographic information systems (), Remote sensing, and Global positioning systems ().

The above excerpt is quoted from Wikipedia.

There is a Stack Exchange site devoted to Geographic Information Systems.

498 questions
9
votes
6 answers

How to find nearest cities in a given radius?

Do you know some utility or a web site where I can give US city,state and radial distance in miles as input and it would return me all the cities within that radius? Thanks!
Jeremy Thomson
  • 999
  • 3
  • 16
  • 17
9
votes
3 answers

Create a surface plot of xyz altitude data in Python

I am trying to create a surface plot of a mountain in python, of which I have some xyz data. The end result should look something like that. The file is formatted as follows: 616000.0 90500.0 3096.712 616000.0 90525.0 3123.415 616000.0 90550.0…
sfluck
  • 345
  • 1
  • 2
  • 8
9
votes
3 answers

SQL Server 2008 Geography .STBuffer() distance measurement units

I'm working with a geographic point using lat/long and need to find other points in our database within a 5 mile radius of that point. However, I can't seem to find out what the "units" are for STBuffer, it doesn't seem to conform to feet, miles,…
user358089
9
votes
2 answers

Best way to export/import MS Sql 2008 Geography data

(ANSWER) How to export some Geography data from a Microsoft Sql Server 2008. You'll need to use the command line argument BCP to dump the data in it's original (native) format to a binary file. Then on the other server you can bulk insert this…
Pure.Krome
  • 84,693
  • 113
  • 396
  • 647
9
votes
4 answers

Identifying geographical locations in text

What kind of work has been done to determine whether a specific string pertains to a geographical location? For example: 'troy, ny' 'austin, texas' 'hotels in las vegas, nv' I guess what I'm sort of expecting is a statistical approach that gives a…
Robert Elwell
  • 6,598
  • 1
  • 28
  • 32
8
votes
7 answers

PHP/MySQL: Select locations close to a given location from DB

In PHP, I have the following code for calculating the distance between two locations:
caw
  • 30,999
  • 61
  • 181
  • 291
8
votes
2 answers

SQL Server 2008 R2 Geography Distance?

I have created a table with the following columns: Text:varchar(255) Location:geography They contain a few city's from The Netherlands as data (got the coordinates from google maps): Rotterdam - POINT (51.925637 4.493408 4326) Utrecht - POINT…
SaphuA
  • 3,092
  • 3
  • 39
  • 58
8
votes
2 answers

STIntersection result is STIntersects = 0

I have line @a that intersects another line @b. When I take the intersection point and detect if/where it intersects @b, it returns false declare @a GEOMETRY = Geometry::STGeomFromText('LINESTRING (-83 24, -80.4907132243685 24.788632986627039)',…
CuriousDeveloper
  • 849
  • 2
  • 8
  • 27
8
votes
1 answer

How to convert latitude and longitude to world coordinates à la Google Maps

I am designing an application in C++ to view and edit a map of a fictional planet. How it works will be similar to Google Maps. I would like the user to be able to see their current position in latitude/longitude and world coordinates on the…
Jake Petroules
  • 23,472
  • 35
  • 144
  • 225
8
votes
3 answers

Database of US metropolitan area names?

I've been unsuccessful in trying to find a US metropolitan area (e.x. San Francisco Bay Area, South Bay, The Berkshires, Upstate New York, etc.) database that is defined by cities. Does anyone know if such a thing exists? Wikipedia has a list of…
Michael
  • 81
  • 1
  • 3
7
votes
1 answer

Generating country-shaped geometry on the surface of a sphere in Godot

I am currently working on a game in Godot which involves rendering countries on a globe. I have very little prior experience with Godot, but have experimented with it in the past. I am using this data from Natural Earth for country borders, and have…
TXP Ghost
  • 71
  • 1
7
votes
2 answers

How to extract countries from a text?

I use Python 3 (I also have Python 2 installed) and I want to extract countries or cities from a short text. For example, text = "I live in Spain" or text = "United States (New York), United Kingdom (London)". The answer for…
Markus
  • 3,562
  • 12
  • 48
  • 85
7
votes
4 answers

Radius of multiple latitude/longitude points

I have a program that takes as input an array of lat/long points. I need to perform a check on that array to ensure that all of the points are within a certain radius. So, for example, the maximum radius I will allow is 100 miles. Given an array…
user301410
  • 87
  • 2
  • 5
7
votes
1 answer

How to define 'geography' type using Npgsql and OrmLite (using postgresql, postgis, c#)

How do I define a postgis 'geography' type in my C# class model so that OrmLite can easily pass it through to Postgresql so I can run spatial queries in addition to saving spatial data to the 'geography' column?
fractal
  • 1,649
  • 17
  • 31
7
votes
1 answer

Convert geography to geometry SQL Server 2008R2

Hello, i have the following code in SQL Server, why if i want to calculate the sTArea of @geog fails and with @geom succeed?, how can i convert this polygon from geometry to geography datatype in order to get the STArea?, thank you. DECLARE…
user1848515
  • 147
  • 2
  • 4
  • 7
1 2
3
…
33 34