有多组经纬度数据，如何找一个集中点
在数据库有一个商家表 location 存储有 商家所在城市 商家经纬度，现知道了城市，如何找商家最多那个经纬度点，
比如说在一个城市 火车站附近有很多商家，经纬度就定位在火车站附近， 跟大家请教一个思路
回复讨论(解决方案)
聚集？
可将坐标缩小一（或几个）个数量级，然后统计个数
感觉不好搞啊，
聚集？
可将坐标缩小一（或几个）个数量级，然后统计个数
如果这些点分别聚集在几个位置怎么办呢？就是说如果LZ要找出好几个中心点。
把所有点算进去得到的中心点可能就是个鸟不拉屎的地方。
如果这些点分别聚集在几个位置怎么办呢？就是说如果LZ要找出好几个中心点。
把所有点算进去得到的中心点可能就是个鸟不拉屎的地方。
集中点和中心点是一回事吗？
如果这些点分别聚集在几个位置怎么办呢？就是说如果LZ要找出好几个中心点。
把所有点算进去得到的中心点可能就是个鸟不拉屎的地方。
集中点和中心点是一回事吗？
完全不清楚，我关注好了。
感觉不好搞啊，
聚集？
可将坐标缩小一（或几个）个数量级，然后统计个数
如果这些点分别聚集在几个位置怎么办呢？就是说如果LZ要找出好几个中心点。
把所有点算进去得到的中心点可能就是个鸟不拉屎的地方。
不是找中心点 ，是找商家集中的地方，哪个商家集中的地方多， 就定位到哪儿，如果一样多，就随机定位
如果这些点分别聚集在几个位置怎么办呢？就是说如果LZ要找出好几个中心点。
把所有点算进去得到的中心点可能就是个鸟不拉屎的地方。
集中点和中心点是一回事吗？
不是一回事， 集中点有可能不是中心点，这个是要在服务端实现，客户端app传过来城市名称，由服务端返回商家集中点的经纬度
谢谢大家的热心回答
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1662
14
1419
52
1311
25
1261
29
1234
24
Explain different error types in PHP (Notice, Warning, Fatal Error, Parse Error).
Apr 08, 2025 am 12:03 AM
There are four main error types in PHP: 1.Notice: the slightest, will not interrupt the program, such as accessing undefined variables; 2. Warning: serious than Notice, will not terminate the program, such as containing no files; 3. FatalError: the most serious, will terminate the program, such as calling no function; 4. ParseError: syntax error, will prevent the program from being executed, such as forgetting to add the end tag.
PHP and Python: Comparing Two Popular Programming Languages
Apr 14, 2025 am 12:13 AM
PHP and Python each have their own advantages, and choose according to project requirements. 1.PHP is suitable for web development, especially for rapid development and maintenance of websites. 2. Python is suitable for data science, machine learning and artificial intelligence, with concise syntax and suitable for beginners.
Explain secure password hashing in PHP (e.g., password_hash, password_verify). Why not use MD5 or SHA1?
Apr 17, 2025 am 12:06 AM
In PHP, password_hash and password_verify functions should be used to implement secure password hashing, and MD5 or SHA1 should not be used. 1) password_hash generates a hash containing salt values to enhance security. 2) Password_verify verify password and ensure security by comparing hash values. 3) MD5 and SHA1 are vulnerable and lack salt values, and are not suitable for modern password security.
PHP in Action: Real-World Examples and Applications
Apr 14, 2025 am 12:19 AM
PHP is widely used in e-commerce, content management systems and API development. 1) E-commerce: used for shopping cart function and payment processing. 2) Content management system: used for dynamic content generation and user management. 3) API development: used for RESTful API development and API security. Through performance optimization and best practices, the efficiency and maintainability of PHP applications are improved.
What are HTTP request methods (GET, POST, PUT, DELETE, etc.) and when should each be used?
Apr 09, 2025 am 12:09 AM
HTTP request methods include GET, POST, PUT and DELETE, which are used to obtain, submit, update and delete resources respectively. 1. The GET method is used to obtain resources and is suitable for read operations. 2. The POST method is used to submit data and is often used to create new resources. 3. The PUT method is used to update resources and is suitable for complete updates. 4. The DELETE method is used to delete resources and is suitable for deletion operations.
PHP: A Key Language for Web Development
Apr 13, 2025 am 12:08 AM
PHP is a scripting language widely used on the server side, especially suitable for web development. 1.PHP can embed HTML, process HTTP requests and responses, and supports a variety of databases. 2.PHP is used to generate dynamic web content, process form data, access databases, etc., with strong community support and open source resources. 3. PHP is an interpreted language, and the execution process includes lexical analysis, grammatical analysis, compilation and execution. 4.PHP can be combined with MySQL for advanced applications such as user registration systems. 5. When debugging PHP, you can use functions such as error_reporting() and var_dump(). 6. Optimize PHP code to use caching mechanisms, optimize database queries and use built-in functions. 7
How does PHP handle file uploads securely?
Apr 10, 2025 am 09:37 AM
PHP handles file uploads through the $\_FILES variable. The methods to ensure security include: 1. Check upload errors, 2. Verify file type and size, 3. Prevent file overwriting, 4. Move files to a permanent storage location.
Explain the difference between self::, parent::, and static:: in PHP OOP.
Apr 09, 2025 am 12:04 AM
In PHPOOP, self:: refers to the current class, parent:: refers to the parent class, static:: is used for late static binding. 1.self:: is used for static method and constant calls, but does not support late static binding. 2.parent:: is used for subclasses to call parent class methods, and private methods cannot be accessed. 3.static:: supports late static binding, suitable for inheritance and polymorphism, but may affect the readability of the code.
