Translation status

40 Strings
100%
Browse Translate
763 Words
100%
4,781 Characters
100%

Strings status

Strings Words Characters
40 763 4,781
All strings Browse Translate Zen
40 763 4,781
Translated strings Browse Translate Zen
1 31 166
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) a44e4fa
Paulo Cesar Coronado authored 08/31/2025
Weblate repository https://weblate.osgeo.org/git/postgis-workshop/index/
File mask postgis-intro/sources/locale/*/LC_MESSAGES/joins_advanced.po
Translation file Download postgis-intro/sources/locale/ja/LC_MESSAGES/joins_advanced.po
Last change Feb. 27, 2024, 2:45 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/21/2026

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 40 763 4,781
Translated 100% 40 100% 763 100% 4,781
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

11 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

763
Hosted words
40
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 02/27/2024
User avatar yellow73

Suggestion accepted
As defined by our data source, Flatbush is not really a neighborhood in the conventional sense, since it just covers the area of Prospect Park. The census tract for that area records, naturally, zero residents. However, the neighborhood boundary does scrape one of the expensive census tracts bordering the north side of the park (in the gentrified Park Slope neighborhood). When using polygon/polygon tests, this single tract was added to the otherwise empty Flatbush, resulting in the very high score for that query.
データソースで定義されている通り、プロスペクト公園だけしかないので、従来の意味ではフラットブッシュは本当の町地区とは言えません。この領域における国勢調査統計区は、当然のことですが、住民は 0 です。しかし、町地区境界は公園の北側に隣接する高級な国勢調査統計区の一つ (高級になったパークスロープ) を削ります。ポリゴン/ポリゴンテストを使用すると、この一つの統計区が空っぽのフラットブッシュに追加され、非常に高いスコアになりました。
02/27/2024
User avatar yellow73

Suggestion accepted
In particular, the Flatbush neighborhood has dropped off the list. The reason why can be seen by looking more closely at the map of the Flatbush neighborhood in our table.
特にフラットブッシュ町地区はリストから外れました。テーブル内のフラットブッシュ町地区の地図を詳しく見ると理由が分かります。
02/27/2024
User avatar yellow73

Suggestion accepted
In our interesting query (in :ref:`interestingquestion`) we used the :command:`ST_Intersects(geometry_a, geometry_b)` function to determine which census tract polygons to include in each neighborhood summary. Which leads to the question: what if a tract falls on the border between two neighborhoods? It will intersect both, and so will be included in the summary statistics for **both**.
興味深いクエリ (:ref:`interestingquestion` 内) の中で、町地区ごとの集約をどの国勢調査統計区ポリゴンに含ませるかを決めるために :command:`ST_Intersects(geometry_a, geometry_b)` 関数を使いました。次の質問に繋がります: 地区が二つの町の境界線上にある場合にはどうなりますか? 両方にインタセクトするため、**両方**の統計値に含んでしまいます。
02/27/2024
User avatar yellow73

Suggestion accepted
New York geographers will be wondering at the presence of "Flatbush" in this list of over-educated neighborhoods. The answer is discussed in the next section.
ニューヨークの地理学者は、この高学歴の町地区のリストに「フラットブッシュ」があることに疑問を抱きます。答については次のセクションで検討します。
02/27/2024
User avatar yellow73

Suggestion accepted
Answer an interesting question! "List top 10 New York neighborhoods ordered by the proportion of people who have graduate degrees."
興味深い質問に答えて下さい! 「大学院の学位を持つ人の数が多い町地区の上位10件までのリストを作成して下さい」
02/27/2024
User avatar yellow73

Suggestion added
As defined by our data source, Flatbush is not really a neighborhood in the conventional sense, since it just covers the area of Prospect Park. The census tract for that area records, naturally, zero residents. However, the neighborhood boundary does scrape one of the expensive census tracts bordering the north side of the park (in the gentrified Park Slope neighborhood). When using polygon/polygon tests, this single tract was added to the otherwise empty Flatbush, resulting in the very high score for that query.
データソースで定義されている通り、プロスペクト公園だけしかないので、従来の意味ではフラットブッシュは本当の町地区とは言えません。この領域における国勢調査統計区は、当然のことですが、住民は 0 です。しかし、町地区境界は公園の北側に隣接する高級な国勢調査統計区の一つ (高級になったパークスロープ) を削ります。ポリゴン/ポリゴンテストを使用すると、この一つの統計区が空っぽのフラットブッシュに追加され、非常に高いスコアになりました。
02/27/2024
User avatar yellow73

Suggestion added
In particular, the Flatbush neighborhood has dropped off the list. The reason why can be seen by looking more closely at the map of the Flatbush neighborhood in our table.
特にフラットブッシュ町地区はリストから外れました。テーブル内のフラットブッシュ町地区の地図を詳しく見ると理由が分かります。
02/27/2024
User avatar yellow73

Suggestion added
In our interesting query (in :ref:`interestingquestion`) we used the :command:`ST_Intersects(geometry_a, geometry_b)` function to determine which census tract polygons to include in each neighborhood summary. Which leads to the question: what if a tract falls on the border between two neighborhoods? It will intersect both, and so will be included in the summary statistics for **both**.
興味深いクエリ (:ref:`interestingquestion` 内) の中で、町地区ごとの集約をどの国勢調査統計区ポリゴンに含ませるかを決めるために :command:`ST_Intersects(geometry_a, geometry_b)` 関数を使いました。次の質問に繋がります: 地区が二つの町の境界線上にある場合にはどうなりますか? 両方にインタセクトするため、**両方**の統計値に含んでしまいます。
02/27/2024
User avatar yellow73

Suggestion added
New York geographers will be wondering at the presence of "Flatbush" in this list of over-educated neighborhoods. The answer is discussed in the next section.
ニューヨークの地理学者は、この高学歴の町地区のリストに「フラットブッシュ」があることに疑問を抱きます。答については次のセクションで検討します。
02/27/2024
Browse all translation changes