I m developing an application using Google Maps API. The goal is to geocode certain locations and then allow users to search for these locations based on which ones are nearest to the user (e.g. "Thing x is 20 miles from you").
在我的SQL中,我只能储存地坐标,使用天线公式进行距离计算。 有些人建议我考虑邮政,因为它“对地理数据有更好的支持”。
因此,问题是:使用MySQL或Pogres有什么利弊?
邮政局支持你所说的话。 但是,对于更多的功能(就你提到的“某些”或许是想到的)来说,我们转向PostGIS。
见home page ,documentation, 或始于优良的Wikipedia 。
In particular, see the function support matrix to get an impression what PostGIS can do for you.
Computing the distance between two points is a standard feature. You can have that for a variety of data types. Which data type to use? See this question in the FAQ and further links there.
如果只是一点,我的SQL就会被罚款。 如果你们的地理分布更加复杂,如交付路线或细胞接收区,或者你想要邮政局,因为它支持更复杂的地貌数据(树木)指数化。 在空间数据方面,MyISAM实际上比InnoDB要好,因为MBTW也支持高树空间指数(但不是作为信标的强烈查询)。 但是,如果你只是需要的话,InnoDB或MyISAM的树就足够了。 如果捆绑的箱子足够(例如,你需要一环绕某一点的直径体内的一切),那么以地壳为基础的指数就是ok。 here。 熟悉地理信息系统和邮政局的麻烦非常值得,它们既是值得称道的良好项目,也是我最喜欢的关系项目,但只是看问题并不需要。
也可以检查MonogDB,支持地理空间指数化,让你对最接近物体的询问非常有效! Four Four Four using using
I noticed that there were some threads with similar questions, and I did look through them but did not really get a convincing answer. Here s my question: The subquery below returns a Table with 3 ...
<?php $con=mysql_connect("localhost","mts","mts"); if(!con) { die( unable to connect . mysql_error()); } mysql_select_db("mts",$con); /* date_default_timezone_set ("Asia/Calcutta"); $date = ...
我把我的用心从使用QQL转向MySQL。 它与凯科特合作,现在不工作,因为我已经改变,使用MySQL。 这里的错误信息是:
We have a restaurant table that has lat-long data for each row. We need to write a query that performs a search to find all restaurants within the provided radius e.g. 1 mile, 5 miles etc. We have ...
Is it possible in php to return a specific row of data from a mysql query? None of the fetch statements that I ve found return a 2 dimensional array to access specific rows. I want to be able to ...
Our website was developed with a meta tag set to... <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> This works fine for M-dashes and special quotes, etc. However, I ...
What are some of the strategies being used for pagination of data sets that involve complex queries? count(*) takes ~1.5 sec so we don t want to hit the DB for every page view. Currently there are ~...
My table looks like person_id | car_id | miles ------------------------------ 1 | 1 | 100 1 | 2 | 200 2 | 3 | 1000 2 | 4 | 500 I need to ...
