postgis-workshop

joins_exercises

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

	Chinese (Simplified)		0	0	0	0	0	0	0

	German	0%	29	266	1,937	29	0	0	0

	Japanese		0	0	0	0	0	0	0

	Spanish		0	0	0	0	8	0	0

	Swedish		0	0	0	0	1	0	0

	Ukrainian		0	0	0	0	0	0	0

Please sign in to see the alerts.

Overview

Project website	postgis.net/workshops/postgis-intro
Project maintainers	jef komzpa yellow73 astrid_emde dmateos dkastl jsanz andischi 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	Update sql cheat sheet with makevalid example `5f99414` Paul Ramsey authored 4 days ago
Last commit in Weblate	Translated using Weblate (Spanish) `469344c` wadmin authored 9 days ago
Weblate repository	`https://weblate.osgeo.org/git/postgis-workshop/index/`
File mask	`postgis-intro/sources/locale/*/LC_MESSAGES/joins_exercises.po`

yesterday

String statistics

	Strings percent	Hosted strings	Words percent	Hosted words	Characters percent	Hosted characters
Total		203		1,862		13,559
Source		29		266		1,937
Translated	85%	174	85%	1,596	85%	11,622
Needs editing	0%	0	0%	0	0%	0
Read-only	14%	29	14%	266	14%	1,937
Failing checks	8%	18	3%	74	4%	592
Strings with suggestions	0%	0	0%	0	0%	0
Untranslated strings	14%	29	14%	266	14%	1,937

Last 12 months Previous

Activity in last 12 months


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

Quick numbers

1,862

Hosted words

203

Hosted strings

85%

Translated

and previous 30 days

Trends of last 30 days

—

Hosted words

+100%

—

Hosted strings

+100%

—

Translated

+85%

−100%

Contributors

+100%

Search

Advanced query builder

Query examples

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

robe Changes committed postgis-workshop joins_exercises Spanish	Changes committed 9 days ago
robe Translation changed postgis-workshop joins_exercises Spanish	English :command:`ST_AsText(geometry)` returns WKT ``text`` Spanish 1 character edited Current translation Translated :command:`ST_AsText(geometry)` convierte formato binario en WKT 9 days ago
None Changes committed postgis-workshop joins_exercises Spanish	Changes committed 10 days ago
jusjimeneza Translation changed postgis-workshop joins_exercises Spanish	English :command:`ST_Contains(geometry A, geometry B)` returns the true if geometry A contains geometry B Spanish 5 characters edited Current translation Translated :command:`ST_Cont~~iene~~ains(geometría A, geometría B)` devuelve verdadero si la geometría A contiene a la geometría B 10 days ago
jusjimeneza Translation changed postgis-workshop joins_exercises Spanish	English :command:`ST_AsText(geometry)` returns WKT ``text`` Spanish 39 characters edited Translated :command:`ST_AsText(geometry)` ~~devuelve la representación de geometry en formato~~convierte formato binario en WKT 10 days ago
jusjimeneza Translation changed postgis-workshop joins_exercises Spanish	English :command:`ST_Area(geometry)` returns the area of the polygons Spanish 1 character edited Current translation Translated :comando:`ST_Area(geometría)` devuelve el área de las geometrías. 10 days ago
jusjimeneza Translation changed postgis-workshop joins_exercises Spanish	English :command:`ST_Area(geometry)` returns the area of the polygons Spanish 5 characters edited Translated :commando:`ST_Area(geometría)` devuelve el área de las geometrías. 10 days ago
jusjimeneza Translation changed postgis-workshop joins_exercises Spanish	English :command:`count(expression)`: aggregate to return the size of a set of records Spanish 58 characters edited Current translation Translated :commando:`count(expres~~sio~~ión)`: ~~devolver la cantidad de filas (registros) que retorna una consulta~~agregado para devolver el tamaño de un conjunto de registros. 10 days ago
jusjimeneza Contributor joined postgis-workshop joins_exercises Spanish	Contributor joined 10 days ago
robe Changes committed postgis-workshop joins_exercises Spanish	Changes committed 2 months ago

Browse all component changes