Translation status

35 Strings 100%
Browse Translate
868 Words 100%
5,703 Characters 100%

Strings status

Strings Words Characters
35 868 5,703
All strings Browse Translate Zen
35 868 5,703
Translated strings Browse Translate Zen
2 42 426
Strings with suggestions 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
advanced_geometry_construction 8% 53 1,166 7,208 53 1 1 0
simple_sql_exercises 0 0 0 0 9 3 0
3d 33% 26 621 3,924 26 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 50% 6 308 1,885 6 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 (Spanish) c2a4899
Paulo Cesar authored 12 days ago
Weblate repository https://weblate.osgeo.org/git/postgis-workshop/index/
File mask postgis-intro/sources/locale/*/LC_MESSAGES/joins.po
Translation file Download postgis-intro/sources/locale/zh_Hans/LC_MESSAGES/joins.po
Last change May 7, 2024, 12:40 a.m.
Last author Anonymous
6 days ago

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 35 868 5,703
Translated 100% 35 100% 868 100% 5,703
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 5% 2 4% 42 7% 426
Untranslated strings 0% 0 0% 0 0% 0
Last 12 months Previous

Activity in last 12 months

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

Quick numbers

868
Hosted words
35
Hosted strings
100%
Translated
0
Contributors
and previous 30 days

Trends of last 30 days

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

Suggestion removed during cleanup

  1. postgis-workshop
  2. joins
  3. Chinese (Simplified)
Function List
函数列表
10 months ago
User avatar None

Changes committed

  1. postgis-workshop
  2. joins
  3. Chinese (Simplified)
Changes committed 10 months ago
User avatar xinbo

Translation changed

  1. postgis-workshop
  2. joins
  3. Chinese (Simplified)
The ``JOIN`` clause combines two ``FROM`` items. By default, we are using an ``INNER JOIN``, but there are four other types of joins. For further information see the `join_type <http://www.postgresql.org/docs/9.1/interactive/sql-select.html#SQL-FROM>`_ definition in the PostgreSQL documentation.
``JOIN``子句组合了两个 ``FROM`` 项。默认情况下，我们使用 ``INNER JOIN``，但还有四种其他类型的连接。有关更多信息，请参阅 PostgreSQL 文档中的 `join_type <http://www.postgresql.org/docs/9.1/interactive/sql-select.html#SQL-FROM>`_ 定义。
10 months ago
User avatar xinbo

Translation completed

  1. postgis-workshop
  2. joins
  3. Chinese (Simplified)
Translation completed 10 months ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. joins
  3. Chinese (Simplified)
`sum(expression) <http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: PostgreSQL aggregate function that returns the sum of records in a set of records.
`sum(expression) <http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: PostgreSQL 聚合函数，返回一组记录中的记录总和。
10 months ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. joins
  3. Chinese (Simplified)
`strpos(string, substring) <http://www.postgresql.org/docs/current/static/functions-string.html>`_: PostgreSQL string function that returns an integer location of a specified substring.
`strpos(string, substring) <http://www.postgresql.org/docs/current/static/functions-string.html>`_:PostgreSQL 字符串函数，返回指定子字符串的整数位置。
10 months ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. joins
  3. Chinese (Simplified)
`round(v numeric, s integer) <http://www.postgresql.org/docs/current/interactive/functions-math.html>`_: PostgreSQL math function that rounds to s decimal places
`round(v numeric, s integer) <http://www.postgresql.org/docs/current/interactive/functions-math.html>`_: 四舍五入到 s 小数位的 PostgreSQL 数学函数
10 months ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. joins
  3. Chinese (Simplified)
`ST_Intersects(geometry A, geometry B) <http://postgis.net/docs/ST_Intersects.html>`_: Returns TRUE if the Geometries/Geography "spatially intersect" - (share any portion of space) and FALSE if they don't (they are Disjoint).
`ST_Intersects(geometry A, geometry B) <http://postgis.net/docs/ST_Intersects.html>`_: 如果几何/地理“空间相交”（有任意部分重叠），则返回 TRUE，否则返回 （FALSE它们不相交）。
10 months ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. joins
  3. Chinese (Simplified)
`ST_DWithin(geometry A, geometry B, radius) <http://postgis.net/docs/ST_DWithin.html>`_: Returns true if the geometries are within the specified distance of one another.
`ST_DWithin(geometry A, geometry B, radius) <http://postgis.net/docs/ST_DWithin.html>`_: 如果几何图形彼此之间在指定的距离内，则返回true。
10 months ago
User avatar xinbo

Translation added

  1. postgis-workshop
  2. joins
  3. Chinese (Simplified)
`ST_Contains(geometry A, geometry B) <http://postgis.net/docs/ST_Contains.html>`_: Returns true if and only if no points of B lie in the exterior of A, and at least one point of the interior of B lies in the interior of A.
`ST_Contains(geometry A, geometry B) <http://postgis.net/docs/ST_Contains.html>`_:当且仅当B的任何点都不位于A的外部，并且B的内部至少有一个点位于A的内部时，返回true。
10 months ago
Browse all translation changes