Translation status

35 Strings 100%
Browse Translate
868 Words 100%
5,703 Characters 100%

Strings status

Strings Words Characters
35 868 5,703
All strings Browse Translate Zen
35 868 5,703
Translated strings Browse Translate Zen
1 41 250
Translated strings with dismissed checks Browse Translate Zen

Other components

Component Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
geography_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
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
knn 0 0 0 0 0 0 0
equality 0 0 0 0 0 0 0
joins_advanced 0 0 0 0 0 0 0
Browse all components

Overview

Project website postgis.net/workshops/postgis-intro
Project maintainers User avatar yellow73 User avatar komzpa User avatar dmateos User avatar dkastl User avatar jsanz User avatar andischi User avatar cvvergara 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 #141 from osgeoweblate/weblate-postgis-workshop-index 742f800
Regina Obe authored 12 days ago
Last commit in Weblate Translated using Weblate (Chinese (Simplified)) 6fc44d9
Wangdapeng authored 3 weeks ago
Weblate repository https://weblate.osgeo.org/git/postgis-workshop/index/
File mask postgis-intro/sources/locale/*/LC_MESSAGES/joins.po
Translation file Download postgis-intro/sources/locale/ja/LC_MESSAGES/joins.po
Last change May 30, 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 35 868 5,703
Translated 100% 35 100% 868 100% 5,703
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 3 changes 8 changes 0 changes 1 change 0 changes 68 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 13 changes 0 changes 0 changes 0 changes
Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar

Quick numbers

868
Hosted words
35
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
  3. Japanese
Changes committed 10 months ago
User avatar yellow73

Suggestion accepted

  1. postgis-workshop
  2. joins
  3. Japanese
`ST_Intersects(geometry A, geometry B) <http://postgis.net/docs/ST_Intersects.html>`_: Returns TRUE if the Geometries/Geography "spatially intersect" - (share any portion of space) and FALSE if they don't (they are Disjoint).
`ST_Intersects(geometry_a, geometry_b) <https://boiledorange73.github.io/pgismanja/latestpostgis.net/docs/ja/ST_Intersects.html>`_: ジオメトリ/ジオグラフィが「空間的にインタセクトする」 - (空間の任意部分を共有する)場合にはTRUEを返し、そうでない(接続されていない、Disjoint)場合にはFALSEを返します。
10 months ago
User avatar yellow73

Suggestion added

  1. postgis-workshop
  2. joins
  3. Japanese
`ST_Intersects(geometry A, geometry B) <http://postgis.net/docs/ST_Intersects.html>`_: Returns TRUE if the Geometries/Geography "spatially intersect" - (share any portion of space) and FALSE if they don't (they are Disjoint).
`ST_Intersects(geometry_a, geometry_b) <https://boiledorange73.github.io/pgismanja/latestpostgis.net/docs/ja/ST_Intersects.html>`_: ジオメトリ/ジオグラフィが「空間的にインタセクトする」 - (空間の任意部分を共有する)場合にはTRUEを返し、そうでない(接続されていない、Disjoint)場合にはFALSEを返します。
10 months ago
User avatar None

Changes committed

  1. postgis-workshop
  2. joins
  3. Japanese
Changes committed a year ago
User avatar yellow73

Suggestion accepted

  1. postgis-workshop
  2. joins
  3. Japanese
The remaining rows are grouped by the neighborhood name and fed through the aggregation function to :command:`Sum()` the population values.
残る行は町地区名でグループ化され、人口値を :command:`Sum()` する集約関数に渡されます。
a year ago
User avatar yellow73

Suggestion accepted

  1. postgis-workshop
  2. joins
  3. Japanese
The ``JOIN`` clause creates a virtual table that includes columns from both the neighborhoods and census tables.
"JOIN" 節で、町地区とセンサスの両方のテーブルからのコラムを持つ、仮想的なテーブルが発生します。
a year ago
User avatar yellow73

Suggestion accepted

  1. postgis-workshop
  2. joins
  3. Japanese
For example: **"What is the population and racial make-up of the neighborhoods of Manhattan?"** Here we have a question that combines information from about population from the census with the boundaries of neighborhoods, with a restriction to just one borough of Manhattan.
例: **「マンハッタンの町地区ごとの人口と人口構成比率は?」** 国勢調査から人口情報と、町地区の境界データとの組み合わせた質問があり、マンハッタンの一つの行政区のみに制限された質問となります。
a year ago
User avatar yellow73

Suggestion accepted

  1. postgis-workshop
  2. joins
  3. Japanese
We could have joined every subway station to its containing neighborhood, but in this case we wanted information about just one. Any function that provides a true/false relationship between two tables can be used to drive a spatial join, but the most commonly used ones are: :command:`ST_Intersects`, :command:`ST_Contains`, and :command:`ST_DWithin`.
全ての地下鉄駅と、その駅の属する町地区とを結合することができますが、この場合は一つだけ情報が必要でした。二つのテーブルの間の TRUE / FALSE 関係を返す関数は全て、空間結合で使うことができます。最も一般的には :command:`ST_Intersects`, :command:`ST_Contains`, :command:`ST_DWithin` が使われます。
a year ago
User avatar yellow73

Suggestion accepted

  1. postgis-workshop
  2. joins
  3. Japanese
Using a spatial join, we can answer the question in one step, retrieving information about the subway station and the neighborhood that contains it:
空間結合を使うと、この地下鉄駅に関する情報の検索と、地下鉄駅を含む町地区の検索とを1ステップで実行できます:
a year ago
User avatar yellow73

Suggestion accepted

  1. postgis-workshop
  2. joins
  3. Japanese
In the previous section, we explored spatial relationships using a two-step process: first we extracted a subway station point for 'Broad St'; then, we used that point to ask further questions such as "what neighborhood is the 'Broad St' station in?"
前の節では、空間関係を2ステップで調べました。すなわち、最初に地下鉄 'Broad St' 駅のポイントを抽出し、その後、そのポイントを「'Broad St' のある町地区は何ですか?」といった、より大きな問題の質問に使いました。
a year ago
Browse all translation changes