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
-1
votes
1 answer

ST_INTERSECTS issue BigQuery Waze

I'm using the following code to query a dataset based on a polygon: SELECT * FROM `waze-public-dataset.partner_name.view_jams_clustered` WHERE ST_INTERSECTS(geo, ST_GEOGFROMTEXT("POLYGON((-99.54913355822276 27.60526592074579,-99.52673174853038…
ZairaRosas
  • 27
  • 4
-1
votes
1 answer

SQL STDistance where both locations are in same record

I'm new to geographic SQL queries. I have two tables; [station_information] which describes bicycle rental stations with a geography type spatial column, and [bike_rides] which has information on a trips on rental bikes. [station_information] has…
-1
votes
1 answer

Transform angles from polar coordinates

I am in need of some help with angles. Calculating bearings with the package fossil and the function fossil::earth.bear we obtain, according to the help, "the bearing in degrees clockwise from True North between any two points on the globe". I…
-1
votes
1 answer

Geographic Data - Australia R

I have data where I have a series of postcodes and figures attached to them. E.g. Postcode Value 2001 $51,000 2050 $21,001,000 3123 $3,200,000 4254 $6,500,000 For a variety of postcodes. How would I go about…
Daniel V
  • 1,305
  • 7
  • 23
-1
votes
1 answer

Read coordinates from geography SQL datatype to SqlDataReader in C#

I've searched around and I've seen you can access the latitude with myGeography.Lat but it doesn't seem to work when trying to read to sqldatareader, this is what I'm trying: String sql = "SELECT * FROM myTable WHERE…
-1
votes
1 answer

Why my SQL query doesnt work in PHP?

So I use ms sql to store latitude and longitude in geography point, in sql I acces that data with: SELECT location.Lat AS lat, location.long AS long, location FROM tableName; And it work good, lat is 20,4706622 long is 44,8132969 and…
-1
votes
1 answer

Ride Sharing App - finding surrounding origins and destinations

I looked at several other SO questions that seem somewhat related, but not quite what i need (or i'm just not smart enough to connect the dots). Working on an app for a client. Their database holds the origin and destination of people that are…
-1
votes
2 answers

c# Multiple values from a single textbox

In C# I want to get multiple values from a single textbox. I want to develop an application that convert geographical coordinates frome latitude and longitude in other projection system. For example: The user enter following coordinat 41°24'12.2"N.…
-1
votes
2 answers

Need 3D GIS/mapping framework similar to Google Maps

I need to develop a 3D mapping/visualisation system that tightly integrates with Google Maps-like functionality. I need the ability to change the angle of view to the ground (instead of the fixed perpendicular on Google Maps) and then render content…
walshy002000
  • 99
  • 1
  • 10
-1
votes
1 answer

Does anyone know how I would go about making a map like the Dogs of NYC map?

I am pretty new to the world of web development. I stumbled upon this site quite sometime ago: http://project.wnyc.org/dogs-of-nyc/. I've tried using view source and looking at WNYC's github page and I've come up with nothing. I was hoping maybe…
Zaynaib Giwa
  • 5,366
  • 7
  • 21
  • 26
-1
votes
2 answers

Application for Prayer Time need help in programming language and calculation

I want to make an Android application for an university project which calculates prayer times. The first line in the code is: d = jd - 2451545.0; // jd is the given Julian date How can I obtain a Julian date? Also, in the code RA = arctan2(cos(e)*…
-1
votes
1 answer

Geographic coordinates c#

How can I get the geographic coordinates of a place just by entering the addresses in input? on c # I searched the internet but could not find information for c #
-2
votes
1 answer

Reverse Lat Long to Long Lat in T-SQL

I have been given MYSQL spatial data in CSV format. The geometry field contains the Latitude and Longitude values but I need to swap it to Longitude and Latitude in that order, so I can view this in TSQL as well known text. Is this possible to…
-2
votes
1 answer

Calculating the shortest distance between n GPS points

I have for example 4 points: A (latitute1, longitude1), B (latitute2, longitude2), C (latitute3, longitude3), D (latitute4, longitude4). If I am a driver and I go from point A, I need an algorithm that calculates the most efficient way for me to…
-2
votes
1 answer

find number of polygons a line intersects

I am working with SQL Server and spatial types. Have found the very interesting. I have reached a situation and I am not sure how I might work it out. Let me outline I have 2 points (coordinates) eg. 3,9 and 50, 20 - this is a straight line, joining…
amateur
  • 43,371
  • 65
  • 192
  • 320
1 2 3
33
34