Translation status

12 Strings
100%
Browse Translate
397 Words
100%
2,475 Characters
100%

Strings status

Strings Words Characters
12 397 2,475
All strings Browse Translate Zen
12 397 2,475
Translated strings Browse Translate Zen

Summary

Project website postgis.net/workshops/postgis-intro
Project maintainers9 User avatar cvvergaraUser avatar dkastlUser avatar komzpaUser avatar astrid_emdeUser avatar dmateosUser avatar jsanzUser avatar andischiUser avatar jefUser avatar yellow73
Translation process
  • Translations can be made directly.
  • Translation suggestions can be made.
  • Any authenticated user can contribute.
  • The translation uses bilingual files.
Source code repository https://github.com/postgis/postgis-workshops.git
Repository branch master
Last remote commit Update sql cheat sheet with makevalid example 5f99414
Paul Ramsey authored 10/30/2025
Last commit in Weblate Update sql cheat sheet with makevalid example 5f99414
Paul Ramsey authored 10/30/2025
Weblate repository https://weblate.osgeo.org/git/postgis-workshop/index/
File mask postgis-intro/sources/locale/*/LC_MESSAGES/equality.po
Translation file Download postgis-intro/sources/locale/zh_Hans/LC_MESSAGES/equality.po
Last change March 27, 2025, 6:47 a.m.
Last change made by None
Language Chinese (Simplified Han script)
Language code zh_Hans
Text direction Left to right
Case sensitivity Case-insensitive
Number of speakers 1,286,444,445
Number of plurals 1
Plural type None
Plurals
Plural formula 0
03/01/2026

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 12 397 2,475
Translated 100% 12 100% 397 100% 2,475
Needs editing 0% 0 0% 0 0% 0
Read-only 0% 0 0% 0 0% 0
Failing checks 0% 0 0% 0 0% 0
Strings with suggestions 0% 0 0% 0 0% 0
Untranslated strings 0% 0 0% 0 0% 0
Last 12 months Previous

Activity in last 12 months

0 changes 16 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes
MarAprMayJunJulAugSepOctNovDecJanFeb

Quick numbers

397
Hosted words
12
Hosted strings
100%
Translated
2
Contributors
and previous 30 days

Trends of last 30 days

—
Hosted words
+100%
—
Hosted strings
+100%
—
Translated
+100%
—
Contributors
—
User avatar None

Changes committed
Changes committed 03/27/2025
User avatar xinbo

Translation completed
Translation completed 03/27/2025
User avatar xinbo

Translation added
These results are more in line with our intuitive understanding of equality. Polygons 1 through 4 are considered equal, since they enclose the same area. Note that neither the direction of the polygon is drawn, the starting point for defining the polygon, nor the number of points used are important here. What is important is that the polygons contain the same space.
这一结果更符合我们对"相等性"的直观理解——多边形1至4因其包围的区域完全相同而被判定为相等。需特别注意：多边形的绘制方向、定义起点或顶点数量均不影响判定，关键在于多边形是否占据相同的空间范围。
03/27/2025
User avatar xinbo

Translation added
In this example, the polygons are only equal to themselves, not to other seemingly equivalent polygons (as in the case of Polygons 1 through 3). In the case of Polygons 1, 2, and 3, the vertices are in identical positions but are defined in differing orders. Polygon 4 has colinear (and thus redundant) vertices on the hexagon edges causing inequality with Polygon 1.
在示例中，这些多边形仅与自身相等，而不会与其他看似相同的多边形相等（例如多边形 1 到 3 的情况）。对于多边形 1、2 和 3，它们的顶点位置相同，但定义顺序不同。而多边形 4 在六边形的边上包含共线（因此是多余的）顶点，导致它与多边形 1 不相等。
03/26/2025
User avatar xinbo

Translation added
As we saw above, exact equality does not take into account the spatial nature of the geometries. There is an function, aptly named :command:`ST_Equals`, available to test the spatial equality or equivalence of geometries.
如前述所示，精确相等性检测并未考虑几何图形的空间特性。为此，系统专门提供:command:`ST_Equals`函数，用于检测几何图形间的空间相等性或等价关系。
03/26/2025
User avatar xinbo

Translation added
As you can see, all of our spatially equal geometries also have equal bounds. Unfortunately, Polygon 5 is also returned as equal under this test, because it shares the same bounding box as the other geometries. Why is this useful, then? Although this will be covered in detail later, the short answer is that this enables the use of spatial indexing that can quickly reduce huge comparison sets into more manageable blocks when joining or filtering data.
如图所示，所有空间相等的几何图形必然具有相等的边界框。但值得注意的是，多边形5在此测试中也会被判定为相等——因其边界框与其他图形重合。这种机制的实用价值在于：虽然后续将详细阐述，但简而言之，它能利用空间索引在数据连接或过滤时，将海量比对集快速缩减至更易处理的区块规模。
03/26/2025
User avatar xinbo

Translation added
Exact equality requires, in the worst case, comparison of each and every vertex in the geometry to determine equality. This can be slow, and may not be appropriate for comparing huge numbers of geometries. To allow for speedier comparison, the equal bounds operator, :command:`~=`, is provided. This operates only on the bounding box (rectangle), ensuring that the geometries occupy the same two dimensional extent, but not necessarily the same space.
精确相等性检测在最坏情况下需要逐顶点比对几何图形的所有坐标点，这种计算可能较慢，尤其不适用于海量几何数据的比对。为提升比对效率，系统提供了边界相等运算符 :command:`~=`，该运算符仅对比几何图形的外包矩形（边界框），确保几何体占据相同的二维空间范围，但不保证实际空间位置完全一致。
03/26/2025
User avatar xinbo

Translation added
Equal Bounds
边界相等
03/26/2025
User avatar xinbo

Translation added
Spatially Equal
空间相等
03/26/2025
User avatar None

Changes committed
Changes committed 03/25/2025
Browse all translation changes