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

Other components

Component Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
spatial_relationships_exercises 0 0 0 0 0 0 0
geography_exercises 0 0 0 0 0 0 0
joins_exercises 0 0 0 0 0 0 0
projection_exercises 0 0 0 0 0 0 0
advanced_geometry_construction 0 0 0 0 0 0 0
simple_sql_exercises 0 0 0 0 0 0 0
3d 0 0 0 0 0 0 0
backup 0 0 0 0 0 0 0
license 0 0 0 0 0 0 0
installation CC-BY-3.0-US 0 0 0 0 0 0 0
Browse all components

Overview

Project website postgis.net/workshops/postgis-intro
Project maintainers User avatar komzpa User avatar cvvergara User avatar dmateos User avatar dkastl User avatar jsanz User avatar andischi User avatar yellow73 User avatar astrid_emde User avatar jef
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 #137 from latot/topo_intro 5ca8351
Regina Obe authored a month ago
Last commit in Weblate Translated using Weblate (Chinese (Simplified)) c78c2ad
Zuochenwei authored 10 months ago
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 author None
4 weeks ago

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

1 change 0 changes 0 changes 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 92 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

Quick numbers

763
Hosted words
40
Hosted strings
100%
Translated
0
Contributors
and previous 30 days

Trends of last 30 days

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

Changes committed

  1. postgis-workshop
  2. joins_advanced
  3. Japanese
Changes committed 10 months ago
User avatar yellow73

Suggestion accepted

  1. postgis-workshop
  2. joins_advanced
  3. Japanese
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 です。しかし、町地区境界は公園の北側に隣接する高級な国勢調査統計区の一つ (高級になったパークスロープ) を削ります。ポリゴン/ポリゴンテストを使用すると、この一つの統計区が空っぽのフラットブッシュに追加され、非常に高いスコアになりました。
10 months ago
User avatar yellow73

Suggestion accepted

  1. postgis-workshop
  2. joins_advanced
  3. Japanese
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.
特にフラットブッシュ町地区はリストから外れました。テーブル内のフラットブッシュ町地区の地図を詳しく見ると理由が分かります。
10 months ago
User avatar yellow73

Suggestion accepted

  1. postgis-workshop
  2. joins_advanced
  3. Japanese
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)` 関数を使いました。次の質問に繋がります: 地区が二つの町の境界線上にある場合にはどうなりますか? 両方にインタセクトするため、**両方**の統計値に含んでしまいます。
10 months ago
User avatar yellow73

Suggestion accepted

  1. postgis-workshop
  2. joins_advanced
  3. Japanese
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.
ニューヨークの地理学者は、この高学歴の町地区のリストに「フラットブッシュ」があることに疑問を抱きます。答については次のセクションで検討します。
10 months ago
User avatar yellow73

Suggestion accepted

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

Suggestion added

  1. postgis-workshop
  2. joins_advanced
  3. Japanese
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 です。しかし、町地区境界は公園の北側に隣接する高級な国勢調査統計区の一つ (高級になったパークスロープ) を削ります。ポリゴン/ポリゴンテストを使用すると、この一つの統計区が空っぽのフラットブッシュに追加され、非常に高いスコアになりました。
10 months ago
User avatar yellow73

Suggestion added

  1. postgis-workshop
  2. joins_advanced
  3. Japanese
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.
特にフラットブッシュ町地区はリストから外れました。テーブル内のフラットブッシュ町地区の地図を詳しく見ると理由が分かります。
10 months ago
User avatar yellow73

Suggestion added

  1. postgis-workshop
  2. joins_advanced
  3. Japanese
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)` 関数を使いました。次の質問に繋がります: 地区が二つの町の境界線上にある場合にはどうなりますか? 両方にインタセクトするため、**両方**の統計値に含んでしまいます。
10 months ago
User avatar yellow73

Suggestion added

  1. postgis-workshop
  2. joins_advanced
  3. Japanese
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.
ニューヨークの地理学者は、この高学歴の町地区のリストに「フラットブッシュ」があることに疑問を抱きます。答については次のセクションで検討します。
10 months ago
Browse all translation changes