Questions tagged [geospatial]
The geospatial tag has no usage guidance.
0
votes
2answers
50 views
What are formats to store geographic maps for a robot to travel point A to point B
Very beginner. Need to compute route from A to B for a robot. i would like to know how to store area map and compute the route. I can compute shortest path etc using algorithms e.g. dijkstra. What ...
0
votes
0answers
19 views
Design for Handling Spatial Data using EF Core and MySql
So EF Core support for spatial data is practically nonexistent at the moment.
The majority of work that has been done is about to drop in the 2.2 Preview 3 which is fantastic news. However, it's ...
0
votes
1answer
25 views
Evaluate http reqres vs websockets for geolocation based broadcasts
My use case is that I have a real-time broadcast app where users get feed items based on a geolocation, i.e. a user will receive posts that were broadcasted from within a user-defined radius where (s)...
0
votes
0answers
123 views
Turning an IP geolocation estimate into a semi-accurate location
Let's say I get a fix from Google Maps Geolocation API without submitting any WiFi access points or cell towers (just my IP). It's pretty much guaranteed to be wildly inaccurate (if it's spot-on, then ...
2
votes
0answers
122 views
Self hosting map vector tiles for web application
I'm building a web application, which involves (currently) a REST backend and a frontend SPA. The backend is hosting massive geo-enabled data, and the frontend is displaying it on a mapbox map. I'm ...
2
votes
2answers
261 views
Handle country specific properties such as price and currency
I have an architecture front-end / back-end, specifically an Android app and a backend. I want that the app user can see different prices and currencies depending on their geo-localization.
So my ...
3
votes
0answers
84 views
How to store data at various point in time? [closed]
What are the techniques and technologies that people use to store spatial data over time that performs fast when querying?
For example, you have a map where people add data at certain locations over ...
1
vote
0answers
283 views
Android intent: Using ?q= in a geo: URI [closed]
I noticed that the Airbnb Android app sends such an intent to open a map app at a particular latitude/longitude:
geo:0:0?q=77.77%2C88.88
From my simplistic point of view, they should use the ...
0
votes
0answers
239 views
Correct way to geo query
I am currently using firebase which limits me to simple queries and because I want to avoid using geoFire's keyEntered way of handling geo queries I've decided to try my hand at my own (naive) ...
1
vote
0answers
29 views
Check if a point is deviating from a path made by a set of line segments
I'd like to know or have other ideas --other than my solution-- about how to check if a car on a given position (lat, lng) is getting away (let's say a distance D away) from the path where the car ...
1
vote
1answer
107 views
How do travel search engines combine flights
I'm curious about how the flight/train search engines combine the results from multiple sources. For example, let's say I'm asking to go from London to Paris, and let's assume there are no direct ...
0
votes
1answer
31 views
Find whether or not current location is near other locations with given radii
tl;dr: "Am I, with any given location, inside of any number of circles with varying radii"
Assume you have a database full of locations (coordinates) with arbitrary radii. Now the user enters and ...
1
vote
0answers
52 views
How do I minimize the number of database queries in a GeoJson API (of countries, and smaller areas) with custom data?
The general version of the question is above - a a little more detail, I am using Django Rest Framework, but am happy for answers to be dealing with the problem in abstract.
So, I have data with ~200 ...
0
votes
1answer
142 views
Compute geographic areas Laravel
I am developing a backend for a taxi app in Laravel 5.
Up to now, served areas are defined by the admins but I would like to change the way it works.
I would like each taxi driver to define their ...
1
vote
1answer
120 views
Search by Location and Keywords [closed]
I have data set with ~5M entries/rows (~2GB). Every entry contains a location field (lat/lon coordinate-pair) and n keyword fields (keyword-1, keyword-2, ... keyword-n). The keyword-fields can all ...
2
votes
3answers
99 views
Find all circles that cover one point
I'm not sure if I've been searching using the wrong keywords, but I've tried so many different ways of wording this and I can't find a relevant answer.
Basically, given a set of circles defined by ...
1
vote
4answers
342 views
Is it necessary to collect zip codes if I'm already collecting address, city, and state?
I'm currently building a B2B web application. As a part of the signup process, I require users to enter their office's street address, state, and city, which I then geocode into latitude and longitude ...
1
vote
2answers
213 views
How should one implement the dependency-injection for a geocoding client that aggregates different coordinate provider implementations?
I am new to DI and I would like to know how DI might be used to help resolve this problem.
If I have an ILatLongLocation which implements a Latitude and Longitude, then given two of these I can ...
2
votes
1answer
159 views
How to canonise a road network
I am working on geographical data which represents the road network of some city and I need to automatically fix inaccuracies in the data.
Data was manually produced by “drawing” the road network ...
2
votes
1answer
2k views
What is a good way to store geographical data for distance calculations
What would be the best way to store data in a database for geographical calculations? Say I have an ItemsForSale table paired to a Users table which holds their geo location. I know I can use latitude ...
2
votes
1answer
192 views
Programming conundrum - most efficient path
I have a non-language-specific problem which I'm having trouble finding a workable answer for.
I have a 10x10 grid containing integer values from 1-10.
Each value represents the cost of travelling ...
5
votes
1answer
69 views
How to model and query spatial responsibilites of company local branches
what are best practices, to model and query spatial responsibilities of company local branches?
My company has many local branches which are all in general responsible for 1 city. This is the easiest ...
0
votes
2answers
392 views
What are the benefits of using geospatial datatypes?
We currently store points as three floats (lat,lon,alt) and support only one type of query (points within a given radius) but look forward to support more queries. We are using PHP and MySQL.
What ...
9
votes
4answers
2k views
finding houses within a radius
During an interview I was asked given the following: A real estate application that lists all houses that are currently on the market (i.e., for sale) within a given distance (say for example the user ...
1
vote
1answer
242 views
Zoom to Fit Points on Surface
I'm attempting to develop a piece of functionality using a 3rd party map control in an application that automatically pans/zooms the map surface to the best possible view given points on map. The map ...
9
votes
8answers
4k views
Scanning a billion rows in an ultra-fast database
Background
A local database contains nearly 1.3 billion unique rows. Each row is indirectly associated with a specific latitude and longitude (location). Each row has a date stamp.
Use Case
The ...
