postgis-workshop

simple_sql

	Language	Translated	Unfinished	Unfinished words	Unfinished characters	Untranslated	Checks	Suggestions	Comments
	English		0	0	0	0	0	0	0

	Chinese (Simplified)		0	0	0	0	0	0	0

	German	0%	34	599	4,000	34	0	0	0

	Japanese		0	0	0	0	0	0	0

	Korean	2%	33	597	3,990	33	0	0	0

	Spanish	2%	33	597	3,987	33	0	0	0

Please sign in to see the alerts.

Overview

Project website	postgis.net/workshops/postgis-intro
Project maintainers	komzpa yellow73 dmateos dkastl astrid_emde jsanz andischi cvvergara 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.po`

2 weeks ago

String statistics

	Strings percent	Hosted strings	Words percent	Hosted words	Characters percent	Hosted characters
Total		204		3,594		24,000
Source		34		599		4,000
Translated	50%	104	50%	1,801	50%	12,023
Needs editing	0%	0	0%	0	0%	0
Read-only	16%	34	16%	599	16%	4,000
Failing checks	0%	0	0%	0	0%	0
Strings with suggestions	0%	0	0%	0	0%	0
Untranslated strings	49%	100	49%	1,793	49%	11,977

Last 12 months Previous

Activity in last 12 months


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

Quick numbers

3,594

Hosted words

204

Hosted strings

50%

Translated

and previous 30 days

Trends of last 30 days

—

Hosted words

+100%

—

Hosted strings

+100%

+1%

Translated

+50%

+100%

Contributors

—

Search

Advanced query builder

Query examples

Review strings changed by other users	`changed:>=2024-06-26 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:>=2024-06-26 AND state:<=needs-editing`	Add
Translated strings in a certain language	`is:translated AND language:en`	Add

None Changes committed postgis-workshop simple_sql Spanish	Changes committed a month ago
dmateos Translation added postgis-workshop simple_sql Spanish	English Function List Spanish 18 characters edited Current translation Translated Lista de funciones a month ago
dmateos Contributor joined postgis-workshop simple_sql Spanish	Contributor joined a month ago
None Changes committed postgis-workshop simple_sql Japanese	Changes committed 5 months ago
yellow73 Suggestion accepted postgis-workshop simple_sql Japanese	English "What is the average number of letters in the names of all the neighborhoods in New York City, reported by borough?" Japanese 1 character edited Current translation Translated 「ニューヨーク市の、行政区ごとの地域区の名前の文字数の平均値を知りたい」 5 months ago
yellow73 Suggestion accepted postgis-workshop simple_sql Japanese	English "What is the average number of letters and standard deviation of number of letters in the names of all the neighborhoods in Brooklyn?" Japanese 1 character edited Current translation Translated 「ブルックリンの全地域区の名前の文字数の平均値と標準偏差を知りたい」 5 months ago
yellow73 Suggestion accepted postgis-workshop simple_sql Japanese	English Often, we are less interested in the individual rows than in a statistic that applies to all of them. So knowing the lengths of the neighborhood names might be less interesting than knowing the average length of the names. Functions that take in multiple rows and return a single result are called "aggregate" functions. Japanese 1 character edited Current translation Translated 私たちはしばしば、結果の個々の行よりも、全体の統計値の方に興味を持ちます。ここで、地区ごとの名前の長さを知ることより、地域区名の長さの平均値の方に興味を持っているとします。ここで使う関数は複数の行を引数に取り、単一の結果を返すもので、「集約」関数と呼ばれます。 5 months ago
yellow73 Suggestion accepted postgis-workshop simple_sql Japanese	English "What is the number of letters in the names of all the neighborhoods in Brooklyn?" Japanese 1 character edited Current translation Translated 「ブルックリンの全ての地域区の名前の文字数を知りたい」 5 months ago
yellow73 Suggestion accepted postgis-workshop simple_sql Japanese	English "What are the names of all the neighborhoods in Brooklyn?" Japanese 1 character edited Current translation Translated 「ブルックリンの全ての地域区の名前を知りたい」 5 months ago
yellow73 Suggestion accepted postgis-workshop simple_sql Japanese	English "What are the names of all the neighborhoods in New York City?" Japanese 1 character edited Current translation Translated 「ニューヨーク市内の全ての地域区の名前を知りたい」 5 months ago

Browse all component changes