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 andischi User avatar cvvergara User avatar dmateos User avatar dkastl User avatar jsanz User avatar astrid_emde User avatar jef User avatar yellow73
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 4 days ago
Last commit in Weblate Translated using Weblate (Japanese) 0ede61d
Teramoto Ikuhiro authored 5 months 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
4 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 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 3 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes
Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov

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 a year 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 集約関数です。
a year 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 集約関数。
a year 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 集約関数です。
a year 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?**
**それぞれの行政区で、白人の人口比率は何パーセントでしょうか?**
a year ago
User avatar yellow73

Suggestion accepted

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

Suggestion accepted

  1. postgis-workshop
  2. simple_sql_exercises
  3. Japanese
**What is the population of the Bronx?**
**ブロンクスの人口はいくらでしょうか?**
a year 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** を書きます。
a year 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?**
**ニューヨーク市の人口はいくらでしょうか?**
a year ago
User avatar yellow73

Suggestion accepted

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