Translation status

58 Strings 50%
Browse Translate
1,288 Words 50%
7,944 Characters 49%

Strings status

Strings Words Characters
58 1,288 7,944
All strings Browse Translate Zen
29 646 3,957
Translated strings Browse Translate Zen
29 642 3,987
Unfinished strings Browse Translate Zen
29 642 3,987
Untranslated strings Browse Translate Zen
29 642 3,987
Unfinished strings without suggestions Browse Translate Zen

Other components

Component Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
geography_exercises 0 0 0 0 0 0 0
projection_exercises 0 0 0 0 0 0 0
simple_sql_exercises 0 0 0 0 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 0 0 0 0 0 0 0
clusterindex 0 0 0 0 0 0 0
postgis-functions 87% 5 68 436 5 0 0 0
loading_data 0 0 0 0 0 0 0
about_data 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 cvvergara User avatar jsanz User avatar andischi 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)) 6fc44d9
Wangdapeng authored 22 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 27, 2025, 8:47 a.m.
Last author None
22 hours ago

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 58 1,288 7,944
Translated 50% 29 50% 646 49% 3,957
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 50% 29 49% 642 50% 3,987
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
22%
Translated
2
Contributors
and previous 30 days

Trends of last 30 days

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

Changes committed

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

Translation added

  1. postgis-workshop
  2. advanced_geometry_construction
  3. Chinese (Simplified)
Let's tackle the hard problem first, figuring out the first station on a route without manually eyeballing the set of stations that make up the route.
让我们优先攻克核心难题：如何在不人工识别的情况下，自动确定某条线路的起始站点。
23 hours ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. advanced_geometry_construction
  3. Chinese (Simplified)
Our query includes a piece of *a priori* knowledge, the initial station identifier that serves as the seed for the search algorithm that builds the route.
我们的查询语句包含一项*先验知识*——作为路径搜索算法初始种子节点的起始站点标识符。
23 hours ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. advanced_geometry_construction
  3. Chinese (Simplified)
We are only calculating one subway route here, we want to calculate all the routes.
当前仅计算单条地铁线路，而实际需求是计算所有线路的路径。
23 hours ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. advanced_geometry_construction
  3. Chinese (Simplified)
Except, two problems:
然而存在两个技术问题：
23 hours ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. advanced_geometry_construction
  3. Chinese (Simplified)
The second half iterates until it finds no further records. At each iteration it takes in the value at the previous iteration via the self-reference to "next_stop". We search every stop on the Q line (**strpos(s.routes,'Q')**) that we have not already added to our visited list (**NOT n.idlist @> ARRAY[s.gid]**) and order them by their distance from the previous point, taking just the first one (the nearest).
后半部分通过递归迭代运行，直至无法找到新的记录为止。每次迭代时，通过自引用"next_stop"获取前一次迭代的值。我们会搜索Q线路上所有站点（**strpos(s.routes,'Q')**），且未加入已访问列表的站点（**NOT n.idlist @> ARRAY[s.gid]**），然后按照与前一站点的距离排序，仅选择最近的一个站点（LIMIT 1）。
yesterday
User avatar xinbo

Suggestion removed

  1. postgis-workshop
  2. advanced_geometry_construction
  3. Chinese (Simplified)
See Also
另请参阅
yesterday
User avatar xinbo

Translation added

  1. postgis-workshop
  2. advanced_geometry_construction
  3. Chinese (Simplified)
See Also
另请参阅
yesterday
User avatar xinbo

Translation added

  1. postgis-workshop
  2. advanced_geometry_construction
  3. Chinese (Simplified)
*Success!*
*成功！*
yesterday
User avatar xinbo

Translation added

  1. postgis-workshop
  2. advanced_geometry_construction
  3. Chinese (Simplified)
Which looks like this:
其语法结构如下：
yesterday
Browse all translation changes