postgis-workshop @ OSGeo Weblate

Component	Translated	Unfinished	Unfinished words	Unfinished characters	Untranslated	Checks	Suggestions	Comments
3d	37%	147	3,247	20,142	147	0	0	0

about_data	45%	258	2,093	14,007	248	19	0	0

advanced_geometry_construction	50%	114	2,572	15,872	114	0	0	0

backup	34%	282	6,709	42,177	282	0	0	0

clusterindex	34%	83	2,330	13,999	83	1	0	0

creating_db	50%	68	1,045	6,938	67	4	0	0

de9im	50%	89	1,706	10,197	89	0	0	0

equality	50%	24	794	4,950	24	0	0	0

geography	40%	222	4,401	31,851	222	0	0	0

geography_exercises	40%	63	705	4,782	63	0	0	0

geometries	42%	383	6,660	48,219	383	0	0	0

geometries_exercises	40%	159	1,206	9,723	159	1	0	0

geometry_returning	53%	69	1,757	12,636	69	0	0	0

geometry_returning_exercises	50%	56	692	4,740	56	1	0	0

history_tracking	41%	123	2,562	15,093	123	0	0	0

index CC-BY-3.0-US	71%	65	353	3,120	50	12	8	0

indexing	68%	97	2,465	16,653	97	2	0	0

installation CC-BY-3.0-US	89%	16	215	1,488	16	0	0	0

introduction	46%	456	7,748	54,027	444	20	16	1

joins	50%	70	1,736	11,406	70	0	0	0

joins_advanced	50%	80	1,526	9,562	80	0	0	0

joins_exercises	50%	58	532	3,874	58	0	1	0

knn	50%	30	858	5,182	30	0	0	0

license	33%	12	224	1,616	12	0	0	0

linear_referencing	51%	45	1,104	7,840	45	0	1	0

loading_data	27%	318	7,357	47,746	318	1	2	0

postgis-functions	54%	93	742	5,623	93	16	1	0

projection	33%	83	2,198	14,523	83	0	0	0

projection_exercises	39%	68	801	5,321	68	5	1	0

rasters CC-BY-3.0-US	20%	831	23,535	150,460	831	1	5	0

schemas	50%	72	1,396	8,526	72	0	0	0

security	51%	132	2,416	15,896	132	1	0	0

simple_sql	40%	101	1,795	11,990	101	0	0	0

simple_sql_exercises	42%	124	1,014	7,360	117	16	5	0

spatial_relationships	40%	125	2,596	19,113	125	0	0	0

spatial_relationships_exercises	50%	60	648	4,542	60	0	0	0

tuning	40%	136	3,288	21,278	136	0	5	0

upgrades	40%	102	1,782	11,142	102	0	0	0

validity	50%	67	1,593	10,144	67	0	0	0

welcome	65%	67	959	5,838	67	3	0	0

Glossary glossary 1 CC-BY-3.0-US	34%	255	3,183	26,022	255	0	45	0

Overview

Project website	postgis.net/workshops/postgis-intro
Project maintainers	jsanz yellow73 komzpa andischi dkastl astrid_emde dmateos jef cvvergara
Translation license	CC-BY-3.0-US ^index ^installation ^rasters ^{glossary 1}

String statistics

	Strings percent	Hosted strings	Words percent	Hosted words	Characters percent	Hosted characters
Total		10,020		183,443		1,228,067
Source		1,948		36,240		241,621
Translated	43%	4,317	39%	72,900	40%	492,449
Needs editing	1%	45	1%	155	1%	1,413
Read-only	19%	1,948	19%	36,240	19%	241,621
Failing checks	1%	103	1%	686	1%	5,331
Strings with suggestions	1%	90	1%	240	1%	1,697
Untranslated strings	56%	5,658	60%	110,388	59%	734,205

Last 12 months Previous

Activity in last 12 months


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

Quick numbers

183 k

Hosted words

10,020

Hosted strings

42%

Translated

Contributors

and previous 30 days

Trends of last 30 days

+1%

Hosted words

+100%

+1%

Hosted strings

+100%

+2%

Translated

+40%

—

Contributors

+100%

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

Chinese (Simplified)	45%	348	7,448	49,699	341	3	3	0

French	45%	52	566	4,610	47	8	14	0

German	1%	1,914	36,085	240,390	1,914	2	19	0

Italian	1%	552	9,840	67,127	552	0	9	0

Japanese	86%	270	7,539	48,141	270	5	2	0

Korean	8%	686	13,747	90,415	681	1	11	0

Spanish	11%	1,717	32,780	216,897	1,689	20	32	1

Ukrainian	12%	164	2,538	18,339	164	0	0	0

None Pushed changes postgis-workshop / index	Pushed changes 4 hours ago
None Committed changes postgis-workshop / rasters — Japanese	Committed changes 4 hours ago
yellow73 Suggestion accepted postgis-workshop / rasters — Japanese	English ST_Histogram Japanese 12 characters edited Current translation Translated ST_Histogram 4 hours ago
yellow73 New contributor postgis-workshop / rasters — Japanese	New contributor 4 hours ago
None Pushed changes postgis-workshop / index	Pushed changes yesterday
None Committed changes postgis-workshop / about_data — Japanese	Committed changes yesterday
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

Browse all project changes

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
Translated strings in a certain language	`is:translated AND language:en`	Add