postgis-workshop/simple_sql_exercises — Japanese @ OSGeo Weblate

Translation status

43	Strings		100%	Browse Translate
349	Words		100%	Browse Translate

Strings status

43	All strings — 349 words	Browse Translate Zen
43	Translated strings — 349 words	Browse Translate Zen
11	Translated strings with dismissed checks — 11 words	Browse Translate Zen

Other components

Component	Translated	Unfinished	Unfinished words	Unfinished characters	Untranslated	Checks	Suggestions	Comments
rasters CC-BY-3.0-US	1%	207	5,883	37,606	207	0	0	0

projection	32%	21	534	3,369	21	0	0	0

projection_exercises	57%	12	219	1,367	12	5	1	0

loading_data	58%	30	903	5,799	30	0	0	0

equality		0	0	0	0	0	0	0

welcome		0	0	0	0	0	0	0

installation CC-BY-3.0-US		0	0	0	0	0	0	0

spatial_relationships_exercises		0	0	0	0	0	0	0

Glossary glossary 1 CC-BY-3.0-US		0	0	0	0	0	0	0

geography_exercises		0	0	0	0	0	0	0

Browse all components

Overview

Project website	postgis.net/workshops/postgis-intro
Project maintainers	jsanz yellow73 komzpa andischi dkastl astrid_emde dmateos jef cvvergara
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 #103 from osgeoweblate/weblate-postgis-workshop-index `97ed677` Regina Obe authored 3 days ago
Last commit in Weblate	Translated using Weblate (Japanese) `455a697` Teramoto Ikuhiro authored yesterday
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, 7:54 a.m.
Last author	Teramoto Ikuhiro

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


Dec	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov

Quick numbers

349

Hosted words

Hosted strings

48%

Translated

Contributors

and previous 30 days

Trends of last 30 days

—

Hosted words

+100%

—

Hosted strings

+100%

+2%

Translated

+46%

+100%

Contributors

—

None Committed changes postgis-workshop / simple_sql_exercises — Japanese	Committed changes yesterday
yellow73 Suggestion removed postgis-workshop / simple_sql_exercises — Japanese	English `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. Japanese 156 characters edited `sum(expression) <https://www.postgresql.jp/document/current/html/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: レコード集合のレコードの合計を返すPostgreSQL 集約関数です。 yesterday
yellow73 Suggestion accepted postgis-workshop / simple_sql_exercises — Japanese	English `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. Japanese 156 characters edited Current translation Translated `count(expression) <https://www.postgresql.jp/document/current/html/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: レコードの集合のレコード数を返す PostgreSQL 集約関数。 yesterday
yellow73 Suggestion removed postgis-workshop / simple_sql_exercises — Japanese	Rejection reason まえの方が良い English `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. Japanese 156 characters edited `sum(expression) <https://www.postgresql.jp/document/current/html/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: レコード集合のレコードの合計を返すPostgreSQL 集約関数です。 yesterday
yellow73 Suggestion accepted postgis-workshop / simple_sql_exercises — Japanese	English For each borough, what percentage of the population is white? Japanese 34 characters edited Current translation Translated それぞれの行政区で、白人の人口比率は何パーセントでしょうか? yesterday
yellow73 Suggestion accepted postgis-workshop / simple_sql_exercises — Japanese	English How many "neighborhoods" are in each borough? Japanese 30 characters edited Current translation Translated 各行政区にはそれぞれどれだけの地区があるでしょうか? yesterday
yellow73 Suggestion accepted postgis-workshop / simple_sql_exercises — Japanese	English What is the population of the Bronx? Japanese 22 characters edited Current translation Translated ブロンクスの人口はいくらでしょうか? yesterday
yellow73 Suggestion accepted postgis-workshop / simple_sql_exercises — Japanese	English 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``. Japanese 148 characters edited Current translation Translated この"AS"とは何でしょう? テーブルまたはカラムに、エイリアスを使って他の名前を与えることができます。エイリアスは読み書きともにクエリを簡単にしてくれます。``sum`` という出力カラム名の代わりに、カラム名が読みやすい ``population`` にするために AS を書きます。 yesterday
yellow73 Suggestion accepted postgis-workshop / simple_sql_exercises — Japanese	English What is the population of the City of New York? Japanese 24 characters edited Current translation Translated ニューヨーク市の人口はいくらでしょうか? yesterday
yellow73 Suggestion accepted postgis-workshop / simple_sql_exercises — Japanese	English How many streets in NYC start with ‘B’? Japanese 28 characters edited Current translation Translated ニューヨーク市のストリート数はいくつでしょうか? yesterday

Browse all translation changes

Quick downloads

43	File in original format as translated in the repository	gettext PO file
43	All strings, converted files enriched with comments; suitable for offline translation	CSV	gettext MO	gettext PO	TBX	TMX	XLIFF 1.1 with gettext extensions	XLIFF 1.1	XLSX

Customize download

Search

Advanced query builder

Query examples

Review strings changed by other users	`changed:>=2023-11-06 AND NOT changed_by:anonymous`	Add
Translated strings	`state:>=translated`	Add
Strings with comments	`has:comment`	Add
Strings with any failing checks	`has:check`	Add
Strings with suggestions from others	`has:suggestion AND NOT suggestion_author:anonymous`	Add
Approved strings with suggestions	`state:approved AND has:suggestion`	Add
All untranslated strings added the past month	`added:>=2023-11-06 AND state:<=needs-editing`	Add