Translation status

58 Strings 20%
Browse Translate
1,288 Words 21%
7,944 Characters 21%

Strings status

Strings Words Characters
58 1,288 7,944
All strings Browse Translate Zen
12 280 1,685
Translated strings Browse Translate Zen
46 1,008 6,259
Unfinished strings Browse Translate Zen
46 1,008 6,259
Untranslated strings Browse Translate Zen
1 2 8
Strings with suggestions Browse Translate Zen
45 1,006 6,251
Unfinished strings without suggestions Browse Translate Zen
1 2 8
Strings with any failing checks Browse Translate Zen
1 2 8
Failing check: Inconsistent Browse Translate Zen

Other components

Component Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
spatial_relationships_exercises 0 0 0 0 1 2 0
geography_exercises 71% 6 136 793 6 4 0 0
joins_exercises 0 0 0 0 0 0 0
projection_exercises 0 0 0 0 8 0 0
simple_sql_exercises 0 0 0 0 9 3 0
3d 46% 21 542 3,364 21 0 0 0
license 0 0 0 0 0 0 0
installation CC-BY-3.0-US 0 0 0 0 0 0 0
equality 83% 2 125 740 2 0 0 0
welcome 0 0 0 0 0 0 0
Browse all components

Overview

Project website postgis.net/workshops/postgis-intro
Project maintainers User avatar komzpa User avatar dmateos User avatar dkastl User avatar jsanz User avatar andischi User avatar cvvergara User avatar yellow73 User avatar astrid_emde User avatar jef
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 Merge pull request #140 from ThomasPrioul/patch-2 0a18451
Regina Obe authored 3 weeks ago
Last commit in Weblate Translated using Weblate (Chinese (Simplified)) 410125f
Wangdapeng authored 11 hours ago
Weblate repository https://weblate.osgeo.org/git/postgis-workshop/index/
File mask postgis-intro/sources/locale/*/LC_MESSAGES/advanced_geometry_construction.po
Translation file Download postgis-intro/sources/locale/zh_Hans/LC_MESSAGES/advanced_geometry_construction.po
Last change March 26, 2025, 8:25 a.m.
Last author Wangdapeng
a minute ago

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 58 1,288 7,944
Translated 20% 12 21% 280 21% 1,685
Needs editing 0% 0 0% 0 0% 0
Read-only 0% 0 0% 0 0% 0
Failing checks 1% 1 1% 2 1% 8
Strings with suggestions 1% 1 1% 2 1% 8
Untranslated strings 79% 46 78% 1,008 78% 6,259
Last 12 months Previous

Activity in last 12 months

0 changes 0 changes 0 changes 62 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
Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb

Quick numbers

1,288
Hosted words
58
Hosted strings
0%
Translated
0
Contributors
and previous 30 days

Trends of last 30 days

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

Translation added

  1. postgis-workshop
  2. advanced_geometry_construction
  3. Chinese (Simplified)
The CTE consists of two halves, unioned together:
该表达式(CTE)由通过UNION连接的两部分组成：
a minute ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. advanced_geometry_construction
  3. Chinese (Simplified)
Common table expressions (CTE) have the virtue of not requiring a function definition to run. Here's the CTE to calculate the route line of the 'Q' train, starting from the northernmost stop (where ``gid`` is 304).
Common table expressions (CTE)的优势在于无需预定义函数即可执行。以下是通过CTE计算'Q'号线路径的示例，从最北端站点（``gid``为304的位置）开始构建线路。
4 minutes ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. advanced_geometry_construction
  3. Chinese (Simplified)
The ``routes`` column of ``nyc_subway_stations`` has multiple route identifiers in each row, so a station that might appear in multiple routes appears only once in the table.
``nyc_subway_stations`` 表中的``routes`` 列每行包含多个线路标识符，因此一个可能出现在多条线路中的站点在表中仅出现一次。
56 minutes ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. advanced_geometry_construction
  3. Chinese (Simplified)
Using a procedural language, like `PL/PgSQL <http://www.postgresql.org/docs/current/static/plpgsql.html>`_.
使用过程化语言，例如`PL/PgSQL <http://www.postgresql.org/docs/current/static/plpgsql.html>`_。
59 minutes ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. advanced_geometry_construction
  3. Chinese (Simplified)
There are two ways to run such an iterative routine in a database:
在数据库中执行此类迭代计算有两种实现方式：
an hour ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. advanced_geometry_construction
  3. Chinese (Simplified)
If we start at one of the end stations, the next station on the line seems to always be the closest. We can repeat the process each time as long as we exclude all the previously found stations from our search.
若从任一终点站出发，线路上的下一站似乎始终是距离最近的站点。只要在搜索中排除已确定的站点，即可重复此过程完成全线排序。
an hour ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. advanced_geometry_construction
  3. Chinese (Simplified)
The second problem is the harder one: given an unordered set of points in a route, how do we order them to match the actual route.
第二个问题更为棘手:给定一条线路上无序的站点集合，如何对它们进行排序以匹配实际线路走向。
2 hours ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. advanced_geometry_construction
  3. Chinese (Simplified)
Related to the previous issue, there is no route ordering information in the stations table, so while it is possible to find all the stations in a particular route, it's not possible using the attributes to determine what the order in which trains travel through the stations.
与前一个问题相关，站点表中缺少线路顺序信息。虽然可以查询到某条线路上的所有站点，但无法通过现有属性确定列车经过各站点的运行顺序。
2 hours ago
User avatar None

Changes committed

  1. postgis-workshop
  2. advanced_geometry_construction
  3. Chinese (Simplified)
Changes committed 11 hours ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. advanced_geometry_construction
  3. Chinese (Simplified)
Our task is made especially difficult by two issues:
我们的任务尤其受到两个问题的困扰：
yesterday
Browse all translation changes