Stack Overflow
Stack Overflow

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

Geographical data encoding (standard codes for countries/regions/cities)

is there a standard way to encode the user location (country, state/region, town), so that I can ask the user to select these items upon registration and then use this data to show his location on the map?
Andy
  • 2,670
  • 3
  • 30
  • 49
1
vote
3 answers

Is it possible to find the distance between two routers?

I was thinking about making a fun project that would tell me where I am throughout my house. My idea was to put two routers in different spots of the house at the same height and then send ping requests or something and check the latency, from that…
rball
  • 6,925
  • 7
  • 49
  • 77
1
vote
3 answers

What is the most efficient way to work with distances between two coordinates?

I have 2063 locations stored in a mysql table. In one of my processes I need to exclude certain results based on how far away they are from a given point of origin. The problem is, I will need to filter a couple of hundred, maybe a couple of…
gargantuan
  • 8,888
  • 16
  • 67
  • 108
1
vote
4 answers

Storing multiple GPS coordinates in MySQL

I'm making an Android app that tracks a user and displays their location in real time. I have it working, but I'm having issues storing the coordinates in a database properly. Right now, the user's location will update every second, and it stores…
mkyong
  • 12,497
  • 12
  • 37
  • 56
1
vote
1 answer

DB2: Insert into a column of data type st_Geometry, from a column of varchar datatype?

Im trying to copy over data from one table to another in the same db2 database, using this command: INSERT INTO SCH.TAB1 (SOMEPK, GEOM) SELECT SOMEPK, db2gse.ST_Geometry(GEOM) FROM SCH.TAB2 The 2 tables are identical except that TAB2 GEOM column is…
Mo.
  • 40,243
  • 37
  • 86
  • 131
1
vote
1 answer

Exporting table with a ST_GEOMETRY column?

I'm currently writing a script that exports data from a list of tables and then imports this data in to an identical copy of the original database, everything seems to work expect one issue: I cant seem to export tables that have a column containing…
Mo.
  • 40,243
  • 37
  • 86
  • 131
1
vote
2 answers

Passing variables into node.js mongoose find query

I hope you guys can help. I'm fairly new to node.js / mongodb and i'm having trouble passing in variables to a mongoose model query. If I run this, passing in the longitude/latitude (-0.18, 51.24) manually as strings then it works perfectly and…
Paul Maddox
  • 15
  • 1
  • 4
1
vote
2 answers

Determine census tract of US address

I have a list of about 20k addresses in the US, and I would like to determine each one's census tract. I found a tool online that does this here, but making 20,000 requests and screenscraping the output seems like the wrong way to do. One idea I had…
Diogenes Creosote
  • 1,922
  • 2
  • 17
  • 22
1
vote
1 answer

How to calculate geo-distance from a polygon?

I have a shapefile with 50+ different polygonal shapes (representing 50+ different regions) and 10,000+ data points that are supposed to be present in one of the regions. The thing is, the 10,000+ points are already coded with a region they are…
prabhasp
  • 528
  • 3
  • 18
1
vote
1 answer

mongodb terminates on any find command

I keep getting thrown out of my mongo session when I do queries like find. I am specifically trying to do a geo query (db.places.find( { loc : { $near : [50,50] } } ) but the issue seems to be with any find query. I get this error: Sun Dec 18…
Jordan
  • 4,928
  • 4
  • 26
  • 39
1
vote
3 answers

Return records in chronological order, given a separation factor

I have a massive table in SQLServer 2008, it contains the position reported by technicians every minute. I need to report on this table but in order to control the amount of records that are displayed in the report both a time and distance…
Raciel R.
  • 2,136
  • 20
  • 27
1
vote
5 answers

Query on distance

Not sure how to build this so opening up to the experts: I have a list of customers in db that are looking for events within a radius of their location. I can store their zipcode (or lat/lng) and the max distance they will go for an event. So…
jcvd
  • 403
  • 1
  • 4
  • 10
1
vote
1 answer

Solr LatLonType multivalued=true, to sort document by nearest one of multiple points

The official Solr documentation were clear about this issue: Fields using LatLonType must be single valued (i.e. multiValued="false") The question is why there is such limitation, and how it's possible to extend Solr to support this feature. Any…
Omar Al-Ithawi
  • 4,988
  • 5
  • 36
  • 47
1
vote
1 answer

Why are spatial queries taking longer against a spatial index in SQL Azure when I decrease my radius?

I've recently started seeing this weird behavior whereby doing a spatial search results in a degradated experience as I decrease my radius. I dropped and rebuilt my spatial index last night but the same weird result. Any help would be…
bmwlexusman
  • 21
  • 1
1
vote
1 answer

Search engine by distance

I am looking to make an option of my serach engine on my site so that users can search for items within a set distance, e.g. search items within 10 miles, or 20 miles etc. I was wondering how this could be done? The user would have to enter thier…
Euan Hume
  • 119
  • 1
  • 4
  • 10
1 2 3
…
99
100