Questions tagged [geospatial]

pertaining to the geographic location and characteristics of natural or constructed features and boundaries on, above, or below the earth's surface; esp. referring to data that is geographic and spatial in nature.

Geospatial (adj) Definition: pertaining to the geographic location and characteristics of natural or constructed features and boundaries on, above, or below the earth's surface; esp. referring to data that is geographic and spatial in nature.

[Source]

4809 questions
12
votes
2 answers

coordinateSystemId on DbGeography

I need to geocode a large number of addresses, using the Bing Map service, EF 5 and SQL Server 2008. I'm using the geography data type in SQL, which translates to a DbGeography type by the EF. When I create a DbGeography object, like this string…
12
votes
6 answers

Rails + PostGIS errors migrating database

I was following Daniel Azuma's talk on geospatial analysis with rails but I am having difficulty whenever I run rake db:migrate in the second project. The details of my setup are as follows: I am running Postgresql using Postgres.app which gives me…
tomciopp
  • 2,602
  • 2
  • 31
  • 60
12
votes
1 answer

Create a SqlGeography polygon-circle from a center and radius

I would like to save a circle in a sql-server 2008 geography field, using c#. In c# I have a latitude, a longitude and a radius but I just can't find a way to calculate the polygon that would represent the circle and create a SqlGeography from it. I…
Johann
  • 12,158
  • 11
  • 62
  • 89
12
votes
4 answers

How to look up elevation data by lat/lng

I am planning an app that will need the ability to look up the elevation of geographic points by lat/lng. Ideally I would like something that would work worldwide, but US-only would also suffice. I have looked at using the USGS Elevation Query Web…
Bryan
  • 3,453
  • 6
  • 26
  • 20
11
votes
2 answers

MySQL Postgresql / PostGIS

I have lat/lon coordinates in a 400 million rows partitioned mysql table. The table grows @ 2000 records a minute and old data is flushed every few weeks. I am exploring ways to do spatial analysis of this data as it comes in. Most of the analysis…
Dojo
  • 5,374
  • 4
  • 49
  • 79
11
votes
5 answers

Geospatial Routing

I'm a logistics programmer, and I've been asked to figure out if a GPS point is "off route" where the route consists of a number of geospatial points (latitude,longitude). What is the best algorithm for determining if a point is near the route? I…
Doug Heeren
  • 143
  • 1
  • 7
11
votes
2 answers

What SQL datatype should be used to populate a Solr location (spatial) field when using a DataImportHandler?

I have a Solr schema which contains a location field (using the default solr.LatLonType ): And I am trying to populate it using a DataImportHandler. Currently I SELECT the value…
STW
  • 44,917
  • 17
  • 105
  • 161
11
votes
3 answers

How to truly calculate a spherical voronoi diagram using sf?

I want to make a world map with a voronoi tessellation using the spherical nature of the world (not a projection of it), similar to this using D3.js, but with R. As I understand ("Goodbye flat Earth, welcome S2 spherical geometry") the sf package is…
Arthur Welle
  • 586
  • 5
  • 15
11
votes
1 answer

Find distance between 2 coordinates in .NET core

I need to find the distance between 2 coordinates in .NET core. I've tried using the below mentioned code, var sCoord = new GeoCoordinate(sLatitude, sLongitude); var eCoord = new GeoCoordinate(eLatitude, eLongitude); return…
Kezia Rose
  • 365
  • 1
  • 2
  • 12
11
votes
6 answers

How can I do efficient range searching + counting with latitude/longitude data?

I'm working with a large set of points represented by latitude/longitude pairs (the points are not necessarily unique, there could be several points in the set that are at the same location). The points are stored in a database. What I need to do is…
11
votes
1 answer

Calculating geospatial distance with radians

I have a method in an API that takes a lat/long coordinate and will find other coordinates within a specified distance. That distance is in radians. All the math I do these days deals with accounting or maybe x,y coordinates for laying out UI…
blu
  • 12,905
  • 20
  • 70
  • 106
11
votes
2 answers

Point in polygon on Earth globe

I have a list of coordinates (latitude, longitude) that define a polygon. Its edges are created by connecting two points with the arc that is the shortest path between those points. My problem is to determine whether another point (let's call it U)…
MateuszPrzybyla
  • 897
  • 8
  • 17
11
votes
6 answers

R_Extracting coordinates from SpatialPolygonsDataFrame

Is it only me who have the problem with extracting coordinates of a polygon from SpatialPolygonsDataFrame object? I am able to extract other slots of the object (ID,plotOrder) but not coordinates (coords). I don't know what I am doing wrong. Please…
rm167
  • 1,185
  • 2
  • 10
  • 26
11
votes
3 answers

spatial clustering in R (simple example)

I have this simple data.frame lat<-c(1,2,3,10,11,12,20,21,22,23) lon<-c(5,6,7,30,31,32,50,51,52,53) data=data.frame(lat,lon) The idea is to find the spatial clusters based on the distance First, I plot the map (lon,lat)…
Math
  • 1,274
  • 3
  • 14
  • 32
11
votes
4 answers

How can I divide the globe in to small grids such that it allows me to assign each lat/long location to a grid?

In order to calculate the nearest locations that are represented by latitude/longitude, I was considering dividing the map into small grids, approximately 100x100 meter grids. Essentially each point would be assigned to a grid. I understand that I…
Nishith
  • 268
  • 3
  • 9