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
geometry_returning 0 0 0 0 0 0 0
projection_exercises 0 0 0 0 0 0 0
simple_sql_exercises 0 0 0 0 0 0 0
tuning 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 jef User avatar komzpa User avatar dmateos User avatar dkastl User avatar jsanz User avatar andischi User avatar yellow73 User avatar cvvergara User avatar astrid_emde
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 Add link to html Swedish translation 524c211
Regina Obe authored yesterday
Last commit in Weblate Translated using Weblate (Swedish) b1ba7d9
Daniel Nylander authored yesterday
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
2 days 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

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

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 a year 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を返します。
a year 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を返します。
a year 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