postgis-workshop

joins

	Language	Translated	Unfinished	Unfinished words	Unfinished characters	Untranslated	Checks	Suggestions	Comments
	English		0	0	0	0	0	0	0

	German	0%	35	868	5,703	35	0	0	0

	Japanese		0	0	0	0	0	0	0

	Spanish	0%	35	868	5,703	35	0	0	0

Please sign in to see the alerts.

Overview

Project website	postgis.net/workshops/postgis-intro
Project maintainers	jsanz yellow73 komzpa andischi dkastl astrid_emde dmateos jef cvvergara
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 #103 from osgeoweblate/weblate-postgis-workshop-index `97ed677` Regina Obe authored 3 days ago
Last commit in Weblate	Translated using Weblate (Japanese) `8ac7604` Teramoto Ikuhiro authored 3 months ago
Weblate repository	`https://weblate.osgeo.org/git/postgis-workshop/index/`
File mask	`postgis-intro/sources/locale/*/LC_MESSAGES/joins.po`

String statistics

	Strings percent	Hosted strings	Words percent	Hosted words	Characters percent	Hosted characters
Total		140		3,472		22,812
Source		35		868		5,703
Translated	50%	70	50%	1,736	50%	11,406
Needs editing	0%	0	0%	0	0%	0
Read-only	25%	35	25%	868	25%	5,703
Failing checks	0%	0	0%	0	0%	0
Strings with suggestions	0%	0	0%	0	0%	0
Untranslated strings	50%	70	50%	1,736	50%	11,406

Last 12 months Previous

Activity in last 12 months


Dec	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov

Quick numbers

3,472

Hosted words

140

Hosted strings

50%

Translated

and previous 30 days

Trends of last 30 days

—

Hosted words

+100%

—

Hosted strings

+100%

—

Translated

+50%

—

Contributors

—

Search

Advanced query builder

Query examples

Review strings changed by other users	`changed:>=2023-11-06 AND NOT changed_by:anonymous`	Add
Translated strings	`state:>=translated`	Add
Strings with comments	`has:comment`	Add
Strings with any failing checks	`has:check`	Add
Strings with suggestions from others	`has:suggestion AND NOT suggestion_author:anonymous`	Add
Approved strings with suggestions	`state:approved AND has:suggestion`	Add
All untranslated strings added the past month	`added:>=2023-11-06 AND state:<=needs-editing`	Add
Translated strings in a certain language	`is:translated AND language:en`	Add

None New alert postgis-workshop / joins	Broken project website URL a month ago
yellow73 Translation changed postgis-workshop / joins — Japanese	English `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. Japanese 1 character edited Current translation Translated `strpos(string, substring) <http://www.postgresql.org/docs/current/static/functions-string.html>`_: 指定した部分文字列の位置を示す整数を返す PostgreSQL 文字列関数。 3 months ago
yellow73 Suggestion accepted postgis-workshop / joins — Japanese	English `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. Japanese 137 characters edited Translated `strpos(string, substring) <http://www.postgresql.org/docs/current/static/functions-string.html>`_: 指定した部分文字列の位置を示す整数を返す PostgreSQL 文字列関数 3 months ago
yellow73 Suggestion accepted postgis-workshop / joins — Japanese	English `round(v numeric, s integer) <http://www.postgresql.org/docs/current/interactive/functions-math.html>`_: PostgreSQL math function that rounds to s decimal places Japanese 137 characters edited Current translation Translated `round(v numeric, s integer) <http://www.postgresql.org/docs/current/interactive/functions-math.html>`_: 小数点以下の桁数を s 桁に丸めるPostgreSQL 数学関数 3 months ago
yellow73 Suggestion accepted postgis-workshop / joins — Japanese	English `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. Japanese 133 characters edited Current translation Translated `ST_DWithin(geometry A, geometry B, radius) <http://postgis.net/docs/ST_DWithin.html>`_: ジオメトリと他のジオメトリとの距離が指定した距離以内である場合に TRUE を返します。 3 months ago
yellow73 Suggestion accepted postgis-workshop / joins — Japanese	English `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. Japanese 140 characters edited Current translation Translated `ST_Contains(geometry A, geometry B) <http://postgis.net/docs/ST_Contains.html>`_: Bの点がAの外部に全く存在せず、Bの内部の少なくとも一つの点がAの内部に存在する場合にのみ TRUE を返します。 3 months ago
yellow73 Suggestion accepted postgis-workshop / joins — Japanese	English As before, the joins create a virtual table of all the possible combinations available within the constraints of the ``JOIN ON`` restrictions, and those rows are then fed into a ``GROUP`` summary. The spatial magic is in the ``ST_DWithin`` function, that ensures only census blocks close to the appropriate subway stations are included in the calculation. Japanese 134 characters edited Current translation Translated 前のように、結合で、"JOIN ON" 制約に合致した全てのありえる組合せの仮想テーブルが生成され、これらの行は "GROUP" による集約に渡されます。``ST_DWithin`` 関数が空間処理のミソで、適切な地下鉄駅に近い統計区だけを計算に取り込むようにします。 3 months ago
yellow73 Suggestion accepted postgis-workshop / joins — Japanese	English Now we can join the table of subway lines onto our original query. Japanese 27 characters edited Current translation Translated これで地下鉄路線のテーブルを元のクエリに結合できます。 3 months ago
yellow73 Suggestion accepted postgis-workshop / joins — Japanese	English To answer that question, we'll add another join to our query, so that we can simultaneously calculate the make-up of many subway lines at once. To do that, we'll need to create a new table that enumerates all the lines we want to summarize. Japanese 103 characters edited Current translation Translated その問に答えるには、これまでのクエリに他の結合を追加して、多数の地下鉄路線の構成を一括して同時に計算できるようにします。これを行うには、要約したい路線の全てを列挙する新しいテーブルを生成する必要があります。 3 months ago
yellow73 Suggestion accepted postgis-workshop / joins — Japanese	English In the last section we saw that the A-train didn't serve a population that differed much from the racial make-up of the rest of the city. Are there any trains that have a non-average racial make-up? Japanese 90 characters edited Current translation Translated 最後のセクションでは、A列車が市の残りの領域の人種構成から大きく異なって人口に影響を与えるようなことがなかったことが分かりました。平均的でない人種構成を持つ列車はあるでしょうか? 3 months ago

Browse all component changes