Translation status

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

Strings status

Strings Words Characters
58 1,288 7,944
All strings Browse Translate Zen
58 1,288 7,944
Translated strings Browse Translate Zen
2 31 229
Translated strings with dismissed checks 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 (Spanish) e9864c6
Weblate authored 09/04/2025
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/ja/LC_MESSAGES/advanced_geometry_construction.po
Last change Jan. 8, 2023, 2:49 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/05/2026

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 58 1,288 7,944
Translated 100% 58 100% 1,288 100% 7,944
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
MarAprMayJunJulAugSepOctNovDecJanFeb

Quick numbers

1,288
Hosted words
58
Hosted strings
100%
Translated
2
Contributors
and previous 30 days

Trends of last 30 days

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

Resource updated
The “postgis-intro/sources/locale/ja/LC_MESSAGES/advanced_geometry_construction.po” file was changed. 01/08/2023
User avatar yellow73

Translation changed
As usual, there are some problems with our simple understanding of the data:
いつものように、データの単純な理解にでは問題があります:
01/05/2023
User avatar yellow73

Translation changed
the '4' train (and a few others) splits at the end of one line into two terminuses, so the "follow one line" assumption breaks and the result has a funny hook on the end.
'4'列車 (と他少数の列車) は一つの線の終着駅がが二つの終端に分割され、「一つの線に従うなる」仮定が壊れ、結果の終わりに、おかしなフックがあります。
01/05/2023
User avatar yellow73

Translation changed
there are actually two 'S' (short distance "shuttle") trains, one in Manhattan and one in the Rockaways, and we join them together because they are both called 'S';
実は二つの 'S' (短距離の「シャトル」)列車があり、マンハッタンとロックウエイにあり、どちらも 'S' と呼ばれるので、結合しこれをつなげてしまっています。
01/05/2023
User avatar yellow73

Translation changed
**first_stops** filters the **stops_distance** output by only taking the first record for each distinct group. Because of the way we ordered **stops_distance** the first record is the furthest record, which means it's the station we want to use as our starting seed to build each subway route.
**first_stops** は、個別グループかたまりごとの最初のレコードの取得だけを行って **stops_distance** の出力をフィルタリングします。**stops_distance** に最初のレコードが最も遠いレコードとなるよう並べ替えているため、それが個々の地下鉄の順路を構築するための開始シードとして使いたいう駅となります。
01/05/2023
User avatar yellow73

Translation changed
**stops_distance** joins the centers points back to the stations table and calculates the distance between the stations and center for each route. The result is ordered such that the records come out in batches for each route, with the furthest station as the first record of the batch.
**stops_distance** は、順路の中心の点を駅テーブルに結合し、駅と順路ごとの中心との距離を計算します。結果に対してレコードが順路ごとのバッチかたまりで出力され、最も遠い駅をバッチ、かたまりの最初のレコードとするよう並べ替えを行っています。
01/05/2023
User avatar yellow73

Translation added
Hopefully this example has provided a taste of some of the complex data manipulations that are possible combining the advanced features of PostgreSQL and PostGIS.
うまくいけば、この例で、PostgreSQLとPostGISの高度な機能の組み合わせである複雑なデータ処理を味わってもらえます。
01/05/2023
User avatar yellow73

Marked for edit
the '4' train (and a few others) splits at the end of one line into two terminuses, so the "follow one line" assumption breaks and the result has a funny hook on the end.
'4'列車 (と他少数の列車) は一つの線の終着駅がが二つの終端に分割され、「一つの線に従う」仮定が壊れ、結果の終わりに、おかしなフックがあります。
01/05/2023
User avatar yellow73

Marked for edit
there are actually two 'S' (short distance "shuttle") trains, one in Manhattan and one in the Rockaways, and we join them together because they are both called 'S';
実は二つの 'S' (短距離の「シャトル」)列車があり、マンハッタンとロックウエイにあり、どちらも 'S' と呼ばれるので、結合します。
01/05/2023
User avatar yellow73

Marked for edit
As usual, there are some problems with our simple understanding of the data:
いつものように、データの単純な理解には問題があります:
01/05/2023
Browse all translation changes