Language Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
English 0 0 0 0 0 0 0
Chinese (Simplified) 0% 35 868 5,703 35 2 3 0
German 0% 35 868 5,703 35 0 0 0
Japanese 0 0 0 0 0 0 0
Spanish 0% 35 868 5,703 35 0 0 0
Please sign in to see the alerts.

Overview

Project website postgis.net/workshops/postgis-intro
Project maintainers User avatar jsanz User avatar cvvergara User avatar komzpa User avatar dmateos User avatar yellow73 User avatar dkastl User avatar andischi 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 #120 from osgeoweblate/weblate-postgis-workshop-index 75182f2
Regina Obe authored 4 weeks ago
Last commit in Weblate Translated using Weblate (Chinese (Simplified)) 1291b44
Zuochenwei authored a month ago
Weblate repository https://weblate.osgeo.org/git/postgis-workshop/index/
File mask postgis-intro/sources/locale/*/LC_MESSAGES/joins.po
4 days ago

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 175 4,340 28,515
Source 35 868 5,703
Translated 40% 70 40% 1,736 40% 11,406
Needs editing 0% 0 0% 0 0% 0
Read-only 20% 35 20% 868 20% 5,703
Failing checks 1% 2 1% 18 1% 214
Strings with suggestions 1% 3 1% 44 1% 439
Untranslated strings 60% 105 60% 2,604 60% 17,109
Last 12 months Previous

Activity in last 12 months

0 changes 0 changes 0 changes 0 changes 0 changes 8 changes 0 changes 1 change 0 changes 68 changes 0 changes 0 changes 0 changes 1 change 0 changes 0 changes 0 changes 0 changes 6 changes 0 changes 0 changes 54 changes 3 changes 0 changes
Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar

Quick numbers

4,340
Hosted words
175
Hosted strings
40%
Translated
0
Contributors
and previous 30 days

Trends of last 30 days

+20%
Hosted words
+100%
+20%
Hosted strings
+100%
−10%
Translated
+50%
—
Contributors
—
User avatar None

Changes committed

  1. postgis-workshop
  2. joins
  3. Japanese
Changes committed a month 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 month 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 month 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 month 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 month 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 month 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 month ago
User avatar yellow73

Suggestion added

  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 month ago
User avatar yellow73

Suggestion added

  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 month ago
User avatar yellow73

Suggestion added

  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 month ago
Browse all component changes