geospatial
Indexing a mysql table for geo lookup using latitude/longitude
I have a legacy innodb table Listing containing a business with latitude/longitude.Given an input latitude/longitude (below 51.2167/4.41667), the query is to return the first active, enabled, not-dele[详细]
2023-03-04 17:02 分类:问答Geospatial data in SQL
I have been experimenting with geography datatype lately and just love it. But I can\'t decide should i convert from my current schema, that stores latitude and longitude in two separate numeric(9,5)[详细]
2023-03-04 06:24 分类:问答How to get all parks of the world with address and lat/lng
I am trying to import a list of all parks in the world and data about them.I need the following information:[详细]
2023-03-01 18:55 分类:问答.NET library for geodata, mapping
We have a web-based application with a mapping component (ASP.NET/SQL Server 2005, Google Maps API). The mapping component is evolving - it started out as a simple, nice-to-have feature and is gradual[详细]
2023-03-01 15:11 分类:问答Efficient query to locate centroid of clusters in postgis?
I have a spatially-distributed collection of entities E stored and spatially indexed in a PostGis database.[详细]
2023-03-01 05:41 分类:问答Shortest path between raw geo coordinates and a node of a graph
I have implemented a simple Dijkstra\'s algorithm for finding the shortest path on an .osm map with Java.[详细]
2023-02-25 11:32 分类:问答MongoDB Count Inaccurate on Geospatial Queries
I\'m querying for documents that are close to a location ($near and $maxDistance) and fall within a date range (an $or with a 3 sets of $gt/$lt conditions relating to dates/schedules).[详细]
2023-02-25 03:02 分类:问答Good books/articles about spatial indexes [closed]
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.[详细]
2023-02-23 13:18 分类:问答How to make a custom query using django-nonrel and mongodb
Is there a recommended way to make a custom query to mongodb using django nonrel? I have an entire site set up and running well, now I am just adding in some geospatial indexing and queries, and want[详细]
2023-02-22 18:44 分类:问答Latitude/Longitude Combinations within Bounding Box
Given a bounding box, I would like to be able to calculate all possible latitude/longitude combinations within that box, to a certain accuracy e.g. 3 decimal places.At the moment the calculations are[详细]
2023-02-22 04:37 分类:问答