Translation status

43 Strings 100%
Browse Translate
349 Words 100%
2,525 Characters 100%

Strings status

Strings Words Characters
43 349 2,525
All strings Browse Translate Zen
43 349 2,525
Translated strings Browse Translate Zen
11 11 144
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
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
knn 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 yellow73 User avatar dmateos User avatar dkastl User avatar astrid_emde User avatar jsanz User avatar andischi User avatar cvvergara 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 #126 from enockseth/fix-typo 9925f56
Paul Ramsey authored yesterday
Last commit in Weblate Translated using Weblate (Japanese) 0ede61d
Teramoto Ikuhiro authored a month ago
Weblate repository https://weblate.osgeo.org/git/postgis-workshop/index/
File mask postgis-intro/sources/locale/*/LC_MESSAGES/simple_sql_exercises.po
Translation file Download postgis-intro/sources/locale/ja/LC_MESSAGES/simple_sql_exercises.po
Last change Dec. 6, 2023, 9:23 a.m.
Last author None
2 weeks ago

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 43 349 2,525
Translated 100% 43 100% 349 100% 2,525
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 3 changes 0 changes 0 changes 0 changes 0 changes 24 changes 0 changes 0 changes 0 changes 0 changes 63 changes 2 changes 0 changes 0 changes 0 changes 6 changes 0 changes 0 changes 0 changes 0 changes 0 changes 8 changes 0 changes
Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun

Quick numbers

349
Hosted words
43
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. simple_sql_exercises
  3. Japanese
Changes committed 7 months ago
User avatar yellow73

Suggestion removed

  1. postgis-workshop
  2. simple_sql_exercises
  3. Japanese
`count(expression) <http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: PostgreSQL aggregate function that returns the number of records in a set of records.
`sum(expression) <https://www.postgresql.jp/document/current/html/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: レコード集合のレコードの合計を返すPostgreSQL 集約関数です。
7 months ago
User avatar yellow73

Suggestion accepted

  1. postgis-workshop
  2. simple_sql_exercises
  3. Japanese
`count(expression) <http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: PostgreSQL aggregate function that returns the number of records in a set of records.
`count(expression) <https://www.postgresql.jp/document/current/html/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: レコードの集合のレコード数を返す PostgreSQL 集約関数。
7 months ago
User avatar yellow73

Suggestion removed

  1. postgis-workshop
  2. simple_sql_exercises
  3. Japanese
まえの方が良い
`avg(expression) <http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: PostgreSQL aggregate function that returns the average value of a numeric column.
`sum(expression) <https://www.postgresql.jp/document/current/html/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: レコード集合のレコードの合計を返すPostgreSQL 集約関数です。
7 months ago
User avatar yellow73

Suggestion accepted

  1. postgis-workshop
  2. simple_sql_exercises
  3. Japanese
**For each borough, what percentage of the population is white?**
**それぞれの行政区で、白人の人口比率は何パーセントでしょうか?**
7 months ago
User avatar yellow73

Suggestion accepted

  1. postgis-workshop
  2. simple_sql_exercises
  3. Japanese
**How many "neighborhoods" are in each borough?**
**各行政区にはそれぞれどれだけの地区があるでしょうか?**
7 months ago
User avatar yellow73

Suggestion accepted

  1. postgis-workshop
  2. simple_sql_exercises
  3. Japanese
**What is the population of the Bronx?**
**ブロンクスの人口はいくらでしょうか?**
7 months ago
User avatar yellow73

Suggestion accepted

  1. postgis-workshop
  2. simple_sql_exercises
  3. Japanese
What is this ``AS``? You can give a table or a column another name by using an alias. Aliases can make queries easier to both write and to read. So instead of our outputted column name as ``sum`` we write it **AS** the more readable ``population``.
この"AS"とは何でしょう? テーブルまたはカラムに、エイリアスを使って他の名前を与えることができます。エイリアスは読み書きともにクエリを簡単にしてくれます。``sum`` という出力カラム名の代わりに、カラム名が読みやすい ``population`` にするために **AS** を書きます。
7 months ago
User avatar yellow73

Suggestion accepted

  1. postgis-workshop
  2. simple_sql_exercises
  3. Japanese
**What is the population of the City of New York?**
**ニューヨーク市の人口はいくらでしょうか?**
7 months ago
User avatar yellow73

Suggestion accepted

  1. postgis-workshop
  2. simple_sql_exercises
  3. Japanese
**How many streets in NYC start with ‘B’?**
**ニューヨーク市のストリート数はいくつでしょうか?**
7 months ago
Browse all translation changes