postgis-workshop

simple_sql_exercises

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

	German	0%	43	349	2,525	43	0	0	0

	Italian	0%	43	349	2,525	43	0	0	0

	Japanese	48%	22	225	1,454	22	8	2	0

	Spanish	11%	38	316	2,310	31	8	5	0

Please sign in to see the alerts.

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 yesterday
Last commit in Weblate	Translated using Weblate (Japanese) `c719078` Teramoto Ikuhiro authored 9 hours ago
Weblate repository	`https://weblate.osgeo.org/git/postgis-workshop/index/`
File mask	`postgis-intro/sources/locale/*/LC_MESSAGES/simple_sql_exercises.po`

String statistics

	Strings percent	Hosted strings	Words percent	Hosted words	Characters percent	Hosted characters
Total		215		1,745		12,625
Source		43		349		2,525
Translated	32%	69	28%	506	30%	3,811
Needs editing	3%	7	1%	7	1%	91
Read-only	20%	43	20%	349	20%	2,525
Failing checks	11%	24	1%	24	2%	315
Strings with suggestions	3%	7	4%	77	5%	728
Untranslated strings	64%	139	70%	1,232	69%	8,723

Last 12 months Previous

Activity in last 12 months


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

Quick numbers

1,745

Hosted words

215

Hosted strings

31%

Translated

and previous 30 days

Trends of last 30 days

—

Hosted words

+100%

—

Hosted strings

+100%

+1%

Translated

+29%

+100%

Contributors

—

Search

Advanced query builder

Query examples

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

None Committed changes postgis-workshop / simple_sql_exercises — Japanese	Committed changes 9 hours ago
yellow73 Suggestion accepted postgis-workshop / simple_sql_exercises — Japanese	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 151 characters edited Current translation Translated `avg(expression) <https://www.postgresql.jp/document/current/html/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: 数値カラムの値の平均を返す PostgreSQL 集約関数。 yesterday
anonymous Suggestion added postgis-workshop / simple_sql_exercises — Spanish	English Number of people self-identifying as "asias" in the block Spanish 60 characters edited Número de personas que se auto-identifican como "Asiático/a" 3 weeks ago
anonymous Suggestion added postgis-workshop / simple_sql_exercises — Spanish	English Number of people self-identifying as "native american" in the block Spanish 70 characters edited Número de personas que se auto-identifican como "Nativo/a Americano/a" 3 weeks ago
anonymous Suggestion added postgis-workshop / simple_sql_exercises — Spanish	English Number of people self-identifying as "black" in the block Spanish 56 characters edited Número de personas que se auto-identifican con "Negro/a" 3 weeks ago
anonymous Suggestion added postgis-workshop / simple_sql_exercises — Spanish	English Number of people self-identifying as "white" in the block Spanish 58 characters edited Número de personas que se auto-identifican como "Blanco/a" 3 weeks ago
anonymous Suggestion added postgis-workshop / simple_sql_exercises — Spanish	English A 15-digit code that uniquely identifies every census block. ("360050001009000") Spanish 100 characters edited Un código de 15 dígitos que identifica de forma única cada bloque del censo. Ej: 360050001009000 3 weeks ago
None New alert postgis-workshop / simple_sql_exercises	Broken project website URL a month ago
None Committed changes postgis-workshop / simple_sql_exercises — Spanish	Committed changes a month ago
dmateos New translation postgis-workshop / simple_sql_exercises — Spanish	English Name of the New York borough. Manhattan, The Bronx, Brooklyn, Staten Island, Queens Spanish 97 characters edited Current translation Translated Nombre del distrito de Nueva York New York. Manhattan, The Bronx, Brooklyn, Staten Island, Queens a month ago

Browse all component changes