Table of Contents
Use database calculation
GEO Algorithm
Redis GEO command
Home Database Redis Let's talk about the GEO geographical location module in Redis

Let's talk about the GEO geographical location module in Redis

Dec 28, 2021 am 10:10 AM
geo redis

GEO is a new geographical location module added to Redis after version 3.2. This article will take you through the GEO geographical location module. I hope it will be helpful to you!

Let's talk about the GEO geographical location module in Redis

GEO is a new geographical location module added to Redis after version 3.2, which means that Redis can be used to implement nearby location functions. [Related recommendations: Redis video tutorial]

Use database calculation

Lets talk about the GEO geographical location module in Redis

The general method is to pass A rectangular area is used to limit the number of elements, and then the full distance calculation is performed on the elements in the area and then sorted. This can significantly reduce the amount of calculation.

select id from positions where x0-r < x < x0+r and y0-r < y < y0+r
Copy after login

In order to increase performance, the above SQL needs to add a two-way composite index to the latitude and longitude coordinates. However, database query performance is limited after all. If it is used in high concurrency situations, this may not be a good solution.

GEO Algorithm

  • The industry’s most common geographical distance sorting algorithm is the GeoHash algorithm, and Redis also uses GeoHash algorithm.
  • GeoHash The algorithm maps two-dimensional longitude and latitude data to one-dimensional integers , so that all elements will be mounted on a line, close to each other The distance between points after mapping two-dimensional coordinates to one dimension will also be very close. When we want to calculate "people nearby", we first map the target position to this line, and then obtain nearby points on this one-dimensional line.
  • Algorithm implementation, it treats the entire earth as a two-dimensional plane, and then divides it into a series of square grids, just like a Go board. All map element coordinates will be placed in unique squares. The smaller the square, the more precise the coordinates. Then perform integer coding on these squares, the closer the squares are, the closer the coding is.
  • After encoding, the coordinates of each map element will become an integer. Through this integer, the coordinates of the element can be restored. The longer the integer, the smaller the loss of the restored coordinate value.
  • GeoHash The algorithm will continue to do this integer oncebase32 Encoding(0-9,a-z remove the four letters a,i,l,o) becomes a string.
  • In Redis, the latitude and longitude are encoded using 52-bit integers and put into zset. The value of zset is the # of the element. ##key, score is the 52-bit integer value of GeoHash.
  • When using Redis for Geo query, we must always remember that its internal structure is actually just a
  • zset(skiplist). By sorting score of zset, you can get other elements near the coordinates (the actual situation is more complicated, but this is enough to understand), and by restoring score to The coordinate value can be used to obtain the original coordinates of the element.

Redis GEO command

Lets talk about the GEO geographical location module in Redis

##1. Add geoadd

geoadd key longitude latitude member [longitude latitude member ...]
Copy after login
127.0.0.1:6379> geoadd beijing 116.403856 39.924043 gugong
(integer) 1
127.0.0.1:6379> geoadd beijing 116.343620 39.947633 dongwuyuan
(integer) 1
127.0.0.1:6379> geoadd beijing 116.328643 39.900272 xizhan 116.415324 39.931231 meishuguan 116.416852 39.887607 tiantan
(integer) 3
Copy after login
Delete

zrem

using zset

2. Distance geodist

geodist key member1 member2 [unit]
Copy after login
127.0.0.1:6379> geodist beijing gugong xizhan km
"6.9402"
127.0.0.1:6379> geodist beijing gugong dongwuyuan   # 默认单位m
"5768.5737"
127.0.0.1:6379> geodist beijing xizhan xizhan
"0.0000"
Copy after login
Distance unit It can be m, km, ml, or ft, which represent meters, kilometers, miles, and feet respectively.

3. Location geopos

geopos key member [member ...]
Copy after login
127.0.0.1:6379> geopos beijing gugong
1) 1) "116.4038559794426"
   2) "39.92404192186725"
127.0.0.1:6379> geopos beijing tiantan xizhan
1) 1) "116.41685396432877"
   2) "39.887607839922914"
2) 1) "116.32864147424698"
   2) "39.900271306834973"
Copy after login

4. Hash value geohash

geohash key member [member ...]
Copy after login
127.0.0.1:6379> geohash beijing gugong
1) "wx4g0gfwqk0"
Copy after login
The latitude and longitude string encoding is

base32

encoding, you can directly find the latitude and longitude through http://geohash.org/wx4g0gfwqk0

##5 . Nearby location georadiusbymember

1. Query ireader

Range

20 The maximum number of elements within 3 kilometers are sorted by distance. , it will not exclude itself (use desc when using inversion)

127.0.0.1:6379> georadiusbymember company ireader 20 km count 3 asc
1) "ireader"
2) "juejin"
3) "meituan"
Copy after login
2. Three optional parameters withcoord withdist withhash

are used to carry additional parameters,

withdist is very useful, it can be used to display distance

georadiusbymember key member radius m|km|ft|mi [WITHCOORD] [WITHDIST] [WITHHASH] [COUNT count] [ASC|DES]
Copy after login
127.0.0.1:6379> georadiusbymember beijing gugong 5 km withcoord withdist withhash count 3 asc
1) 1) "gugong"
   2) "0.0000"
   3) (integer) 4069885568932443
   4) 1) "116.4038559794426"
      2) "39.92404192186725"
2) 1) "meishuguan"
   2) "1.2634"
   3) (integer) 4069885710390435
   4) 1) "116.41532510519028"
      2) "39.93123039107514"
3) 1) "tiantan"
   2) "4.2014"
   3) (integer) 4069885398502557
   4) 1) "116.41685396432877"
      2) "39.887607839922914"
Copy after login
3. Query nearby elements based on coordinate values
 georadius key longitude latitude radius m|km|ft|mi [WITHCOORD] [WITHDIST] [WITHHASH] [COUNT count] [ASC|DES]
Copy after login
127.0.0.1:6379> georadius beijing 116.383882 39.922061 5 km withcoord withdist withhash count 3 asc
1) 1) "gugong"
   2) "1.7180"
   3) (integer) 4069885568932443
   4) 1) "116.4038559794426"
      2) "39.92404192186725"
2) 1) "meishuguan"
   2) "2.8693"
   3) (integer) 4069885710390435
   4) 1) "116.41532510519028"
      2) "39.93123039107514"
3) 1) "dongwuyuan"
   2) "4.4588"
   3) (integer) 4069879836419688
   4) 1) "116.34361892938614"
      2) "39.94763257169722"
Copy after login

Notes

In actual applications, there may be millions of pieces of data. We know that Redis Geo

will put them all in a

zset collection. In the Redis cluster environment, the collection may be migrated from one node to another node. If the data of a single key is too large, it will have a greater impact on the migration work of the cluster. In a cluster environment, a single key The corresponding data volume should not exceed 1M, otherwise it will cause lags in cluster migration and affect the normal operation of online services.

So, it is recommended that Geo data be deployed using a separate Redis instance instead of a cluster environment.

If the amount of data exceeds 100 million or even larger, the Geo data needs to be split, split by country, province, city, even in very populous cities. Can be split by zone. This can significantly reduce the size of a single zset set.

For more programming related knowledge, please visit: Programming Video! !

The above is the detailed content of Let's talk about the GEO geographical location module in Redis. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Best Graphic Settings
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. How to Fix Audio if You Can't Hear Anyone
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Solution to 0x80242008 error when installing Windows 11 10.0.22000.100 Solution to 0x80242008 error when installing Windows 11 10.0.22000.100 May 08, 2024 pm 03:50 PM

1. Start the [Start] menu, enter [cmd], right-click [Command Prompt], and select Run as [Administrator]. 2. Enter the following commands in sequence (copy and paste carefully): SCconfigwuauservstart=auto, press Enter SCconfigbitsstart=auto, press Enter SCconfigcryptsvcstart=auto, press Enter SCconfigtrustedinstallerstart=auto, press Enter SCconfigwuauservtype=share, press Enter netstopwuauserv , press enter netstopcryptS

Golang API caching strategy and optimization Golang API caching strategy and optimization May 07, 2024 pm 02:12 PM

The caching strategy in GolangAPI can improve performance and reduce server load. Commonly used strategies are: LRU, LFU, FIFO and TTL. Optimization techniques include selecting appropriate cache storage, hierarchical caching, invalidation management, and monitoring and tuning. In the practical case, the LRU cache is used to optimize the API for obtaining user information from the database. The data can be quickly retrieved from the cache. Otherwise, the cache can be updated after obtaining it from the database.

Caching mechanism and application practice in PHP development Caching mechanism and application practice in PHP development May 09, 2024 pm 01:30 PM

In PHP development, the caching mechanism improves performance by temporarily storing frequently accessed data in memory or disk, thereby reducing the number of database accesses. Cache types mainly include memory, file and database cache. Caching can be implemented in PHP using built-in functions or third-party libraries, such as cache_get() and Memcache. Common practical applications include caching database query results to optimize query performance and caching page output to speed up rendering. The caching mechanism effectively improves website response speed, enhances user experience and reduces server load.

How to upgrade Win11 English 21996 to Simplified Chinese 22000_How to upgrade Win11 English 21996 to Simplified Chinese 22000 How to upgrade Win11 English 21996 to Simplified Chinese 22000_How to upgrade Win11 English 21996 to Simplified Chinese 22000 May 08, 2024 pm 05:10 PM

First you need to set the system language to Simplified Chinese display and restart. Of course, if you have changed the display language to Simplified Chinese before, you can just skip this step. Next, start operating the registry, regedit.exe, directly navigate to HKEY_LOCAL_MACHINESYSTEMCurrentControlSetControlNlsLanguage in the left navigation bar or the upper address bar, and then modify the InstallLanguage key value and Default key value to 0804 (if you want to change it to English en-us, you need First set the system display language to en-us, restart the system and then change everything to 0409) You must restart the system at this point.

How to use Redis cache in PHP array pagination? How to use Redis cache in PHP array pagination? May 01, 2024 am 10:48 AM

Using Redis cache can greatly optimize the performance of PHP array paging. This can be achieved through the following steps: Install the Redis client. Connect to the Redis server. Create cache data and store each page of data into a Redis hash with the key "page:{page_number}". Get data from cache and avoid expensive operations on large arrays.

How to find the update file downloaded by Win11_Share the location of the update file downloaded by Win11 How to find the update file downloaded by Win11_Share the location of the update file downloaded by Win11 May 08, 2024 am 10:34 AM

1. First, double-click the [This PC] icon on the desktop to open it. 2. Then double-click the left mouse button to enter [C drive]. System files will generally be automatically stored in C drive. 3. Then find the [windows] folder in the C drive and double-click to enter. 4. After entering the [windows] folder, find the [SoftwareDistribution] folder. 5. After entering, find the [download] folder, which contains all win11 download and update files. 6. If we want to delete these files, just delete them directly in this folder.

PHP Redis caching applications and best practices PHP Redis caching applications and best practices May 04, 2024 am 08:33 AM

Redis is a high-performance key-value cache. The PHPRedis extension provides an API to interact with the Redis server. Use the following steps to connect to Redis, store and retrieve data: Connect: Use the Redis classes to connect to the server. Storage: Use the set method to set key-value pairs. Retrieval: Use the get method to obtain the value of the key.

Why does an error occur when installing an extension using PECL in a Docker environment? How to solve it? Why does an error occur when installing an extension using PECL in a Docker environment? How to solve it? Apr 01, 2025 pm 03:06 PM

Causes and solutions for errors when using PECL to install extensions in Docker environment When using Docker environment, we often encounter some headaches...

See all articles