postgis-workshop

knn

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

	German	0%	15	429	2,591	15	0	0	0

	Japanese		0	0	0	0	0	0	0

	Spanish	0%	15	429	2,591	15	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) `14e6316` Teramoto Ikuhiro authored 2 months ago
Weblate repository	`https://weblate.osgeo.org/git/postgis-workshop/index/`
File mask	`postgis-intro/sources/locale/*/LC_MESSAGES/knn.po`

String statistics

	Strings percent	Hosted strings	Words percent	Hosted words	Characters percent	Hosted characters
Total		60		1,716		10,364
Source		15		429		2,591
Translated	50%	30	50%	858	50%	5,182
Needs editing	0%	0	0%	0	0%	0
Read-only	25%	15	25%	429	25%	2,591
Failing checks	0%	0	0%	0	0%	0
Strings with suggestions	0%	0	0%	0	0%	0
Untranslated strings	50%	30	50%	858	50%	5,182

Last 12 months Previous

Activity in last 12 months


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

Quick numbers

1,716

Hosted words

60

Hosted strings

50%

Translated

and previous 30 days

Trends of last 30 days

—

Hosted words

+100%

—

Hosted strings

+100%

—

Translated

+50%

—

Contributors

+100%

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 / knn	Broken project website URL a month ago
None Committed changes postgis-workshop / knn — Japanese	Committed changes 2 months ago
yellow73 Suggestion accepted postgis-workshop / knn — Japanese	English The explain shows the loop on the subway stations, and the index-assisted order by inside the loop where we want it: Japanese 53 characters edited Current translation Translated EXPLAIN は地下鉄駅のループと、求めるループ内のインデックスによる ORDER BY を表示します: 2 months ago
yellow73 Suggestion accepted postgis-workshop / knn — Japanese	English Note the way the ``CROSS JOIN LATERAL`` acts as the inner part of a loop driven by the subways table. Each record in the subways table gets fed into the lateral subquery, one at a time, so you get a nearest result for each subway record. Japanese 117 characters edited Current translation Translated ``CROSS JOIN LATERAL`` が地下鉄テーブルで駆動するループ内の処理部分として動作します。地下鉄テーブルの個々のレコードは LATERAL サブクエリにどんどん送られるので、地下鉄レコードごとの最近傍の結果を得ます。 2 months ago
yellow73 Suggestion accepted postgis-workshop / knn — Japanese	English Here we will find the nearest street to each subway station: Japanese 23 characters edited Current translation Translated 地下鉄駅ごとに最も近いストリートを探索します: 2 months ago
yellow73 Suggestion accepted postgis-workshop / knn — Japanese	English Fortunately, there's a SQL language feature that allows us to run a query repeatedly driven in a loop: the `LATERAL join <https://medium.com/kkempin/postgresqls-lateral-join-bfd6bd0199df>`_. Japanese 132 characters edited Current translation Translated 幸運なことに、ループ内で繰り返し駆動されるクエリの実行が可能になる SQL 言語機能 `LATERAL join <https://medium.com/kkempin/postgresqls-lateral-join-bfd6bd0199df>`_ があります。 2 months ago
yellow73 Suggestion accepted postgis-workshop / knn — Japanese	English The index assisted order by operator has one major draw back: it only works with a single geometry literal on one side of the operator. This is fine for finding the objects nearest to one query object, but does not help for a spatial join, where the goal is to find the nearest neighbor for each of a full set of candidates. Japanese 159 characters edited Current translation Translated インデックスによる ORDER BY 演算子は、演算子の一方が単一ジオメトリリテラルでないと動作しないという、大きな欠点があります。これはあるクエリオブジェクトに最も近いオブジェクトを探索する場合は良いのですが、候補から一つずつオブジェクトを抜き出して最近傍を検索することを目的とする空間結合には役立ちません。 2 months ago
yellow73 Suggestion accepted postgis-workshop / knn — Japanese	English Nearest Neighbor Join Japanese 5 characters edited Current translation Translated 最近傍結合 2 months ago
yellow73 Translation changed postgis-workshop / knn — Japanese	English This is the output from ``EXPLAIN``, note the index scan over the order by: Japanese 4 characters edited Current translation Translated "``EXPLAIN"`` からの出力を示しますが、インデックススキャンは ORDER BY に対して実行しています: 2 months ago
yellow73 Suggestion accepted postgis-workshop / knn — Japanese	English This is the output from ``EXPLAIN``, note the index scan over the order by: Japanese 55 characters edited Translated "EXPLAIN" からの出力を示しますが、インデックススキャンは ORDER BY に対して実行しています: 2 months ago

Browse all component changes