Translation status

15 Strings
100%
Browse Translate
429 Words
100%
2,591 Characters
100%

Strings status

Strings Words Characters
15 429 2,591
All strings Browse Translate Zen
15 429 2,591
Translated strings Browse Translate Zen

Summary

Project website postgis.net/workshops/postgis-intro
Project maintainers9 User avatar cvvergaraUser avatar dkastlUser avatar komzpaUser avatar astrid_emdeUser avatar dmateosUser avatar jsanzUser avatar andischiUser avatar jefUser avatar yellow73
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 Update sql cheat sheet with makevalid example 5f99414
Paul Ramsey authored 10/30/2025
Last commit in Weblate Translated using Weblate (Ukrainian) 34c3a85
User avatar dkovshun authored 08/10/2025
Weblate repository https://weblate.osgeo.org/git/postgis-workshop/index/
File mask postgis-intro/sources/locale/*/LC_MESSAGES/knn.po
Translation file Download postgis-intro/sources/locale/ja/LC_MESSAGES/knn.po
Last change Sept. 21, 2023, 10:23 a.m.
Last change made by None
Language Japanese
Language code ja
Text direction Left to right
Case sensitivity Case-insensitive
Number of speakers 117,608,755
Number of plurals 1
Plural type None
Plurals
Plural formula 0
02/09/2026

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 15 429 2,591
Translated 100% 15 100% 429 100% 2,591
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 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 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
FebMarAprMayJunJulAugSepOctNovDecJan

Quick numbers

429
Hosted words
15
Hosted strings
100%
Translated
1
Contributors
and previous 30 days

Trends of last 30 days

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

Changes committed
Changes committed 09/21/2023
User avatar yellow73

Suggestion accepted
The explain shows the loop on the subway stations, and the index-assisted order by inside the loop where we want it:
EXPLAIN は地下鉄駅のループと、求めるループ内のインデックスによる ORDER BY を表示します:
09/20/2023
User avatar yellow73

Suggestion accepted
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.
``CROSS JOIN LATERAL`` が地下鉄テーブルで駆動するループ内の処理部分として動作します。地下鉄テーブルの個々のレコードは LATERAL サブクエリにどんどん送られるので、地下鉄レコードごとの最近傍の結果を得ます。
09/20/2023
User avatar yellow73

Suggestion accepted
Here we will find the nearest street to each subway station:
地下鉄駅ごとに最も近いストリートを探索します:
09/20/2023
User avatar yellow73

Suggestion accepted
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>`_.
幸運なことに、ループ内で繰り返し駆動されるクエリの実行が可能になる SQL 言語機能 `LATERAL join <https://medium.com/kkempin/postgresqls-lateral-join-bfd6bd0199df>`_ があります。
09/20/2023
User avatar yellow73

Suggestion accepted
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.
インデックスによる ORDER BY 演算子は、演算子の一方が**単一ジオメトリリテラル**でないと動作しないという、大きな欠点があります。これはあるクエリオブジェクトに最も近いオブジェクトを探索する場合は良いのですが、候補から一つずつオブジェクトを抜き出して最近傍を検索することを目的とする空間結合には役立ちません。
09/20/2023
User avatar yellow73

Suggestion accepted
Nearest Neighbor Join
最近傍結合
09/20/2023
User avatar yellow73

Translation changed
This is the output from ``EXPLAIN``, note the index scan over the order by:
"``EXPLAIN"`` からの出力を示しますが、インデックススキャンは ORDER BY に対して実行しています:
09/20/2023
User avatar yellow73

Suggestion accepted
This is the output from ``EXPLAIN``, note the index scan over the order by:
"EXPLAIN" からの出力を示しますが、インデックススキャンは ORDER BY に対して実行しています:
09/20/2023
User avatar yellow73

Suggestion accepted
How can we be sure we are getting an index-assisted query? It's a good idea to check the ``EXPLAIN`` output for a nearest-neighbor query, because it's possible to get correct answers from non-indexed SQL and the lack of an index might not be obvious until the size of the tables scales up.
インデックスによるクエリをどの程度確定されられるでしょうか? 最近傍クエリの "EXPLAIN" 出力を確認するのが良い考えです。正しい答えを非インデックス SQL から得ることができ、テーブルのスケールアップが無い限りインデックスの欠如が明白にはならないことがあるためです。
09/20/2023
Browse all translation changes