postgis/using_postgis_query.xml @ OSGeo Weblate

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

French		0	0	0	0	0	0	0

German	3%	105	2,057	15,988	105	1	0	0

Italian	0%	109	2,128	16,517	109	0	0	0

Japanese		0	0	0	0	0	0	0

Korean	0%	109	2,128	16,517	109	0	0	0

Polish	0%	109	2,128	16,517	109	0	0	0

Portuguese (Brazil)	0%	109	2,128	16,517	109	0	0	0

Russian	0%	109	2,128	16,517	109	0	0	0

Spanish	1%	108	2,126	16,502	108	0	0	0

Please sign in to see the alerts.

Overview

Project website	postgis.net
Project maintainers	komzpa cvvergara strk robe
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://git.osgeo.org/gitea/postgis/postgis.git`
Repository branch	master
Last remote commit	Show obtained output on failure, in oriented_envelope test `36fcdd626` Sandro Santilli authored yesterday
Last commit in Weblate	Translated reference_coverage using Weblate (French) `af45bca00` Vincent Bre authored 2 weeks ago
Weblate repository	`https://weblate.osgeo.org/git/postgis/postgis/`
File mask	`doc/po/*/using_postgis_query.xml.po`

String statistics

	Strings percent	Hosted strings	Words percent	Hosted words	Characters percent	Hosted characters
Total		1,090		21,280		165,170
Source		109		2,128		16,517
Approved	1%	1	1%	2	1%	15
Waiting for review	20%	222	20%	4,327	20%	33,563
Translated	30%	332	30%	6,457	30%	50,095
Needs editing	0%	0	0%	0	0%	0
Read-only	10%	109	10%	2,128	10%	16,517
Failing checks	2%	29	1%	415	2%	3,519
Strings with suggestions	0%	0	0%	0	0%	0
Untranslated strings	69%	758	69%	14,823	69%	115,075

Last 12 months Previous

Activity in last 12 months


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

Quick numbers

21,280

Hosted words

1,090

Hosted strings

30%

Translated

Contributors

and previous 30 days

Trends of last 30 days

—

Hosted words

—

Hosted strings

—

+9%

Translated

—

+100%

Contributors

—

Search

Advanced query builder

Query examples

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

None Component unlocked postgis / using_postgis_query.xml	Fixing an alert automatically unlocked the component. 12 days ago
None Component locked postgis / using_postgis_query.xml	The component was automatically locked because of an alert. 13 days ago
None New alert postgis / using_postgis_query.xml	Could not update the repository. 13 days ago
None Resource update postgis / using_postgis_query.xml — French	The "`doc/po/fr/using_postgis_query.xml.po`" file was changed. 2 weeks ago
None String updated in the repository postgis / using_postgis_query.xml — French	English -- Find wharves partly on a lake's shoreline SELECT a.lake_id, b.wharf_id FROM lakes a, wharfs b WHERE a.geom && b.geom AND ST_Relate(a.geom, b.geom, '102101FF2'); French 2 characters edited Current translation Translated -- Trouver des quais en partie sur les rives d'un lac SELECT a.lake_id, b.wharf_id FROM lakes a, wharfs b WHERE a.geom &amp ;&amp ; b.geom AND ST_Relate(a.geom, b.geom, '102101FF2') ; 2 weeks ago
None String updated in the repository postgis / using_postgis_query.xml — French	English -- Find road segments that intersect in a line SELECT a.id FROM roads a, roads b WHERE a.id != b.id AND a.geom && b.geom AND ST_Relate(a.geom, b.geom, '111'); French 2 characters edited Current translation Translated -- Trouver les segments de route qui se coupent en une ligne SELECT a.id FROM roads a, roads b WHERE a.id != b.id AND a.geom &amp ;&amp ; b.geom AND ST_Relate(a.geom, b.geom, '111') ; 2 weeks ago
vincentbre New translation postgis / using_postgis_query.xml — French	English This query selects the same geometries, but it does it in a more efficient way. This is enabled by <varname>ST_DWithin()</varname> using the <varname>&&</varname> operator internally on an expanded bounding box of the query geometry. If there is a spatial index on <code>geom</code>, the query planner will recognize that it can use the index to reduce the number of rows scanned before calculating the distance. The spatial index allows retrieving only records with geometries whose bounding boxes overlap the expanded extent and hence which <emphasis>might</emphasis> be within the required distance. The actual distance is then computed to confirm whether to include the record in the result set. French 808 characters edited Current translation Translated Cette requête sélectionne les mêmes géométries, mais de manière plus efficace. Ceci est possible en <varname>ST_DWithin()</varname> utilisant l'opérateur <varname>&&</varname> en interne sur une boîte de délimitation élargie de la géométrie de la requête. S'il existe un index spatial sur <code>geom</code>, le planificateur de requêtes reconnaîtra qu'il peut utiliser l'index pour réduire le nombre de lignes analysées avant de calculer la distance. L'index spatial permet d'extraire uniquement les enregistrements dont les boîtes de délimitation chevauchent l'étendue élargie et qui, par conséquent, <emphasis>pourraient</emphasis> se trouver à l'intérieur de la distance requise. La distance réelle est ensuite calculée pour confirmer l'inclusion de l'enregistrement dans l'ensemble des résultats. 2 weeks ago
vincentbre Translation changed postgis / using_postgis_query.xml — French	English SELECT gid, name, ST_Area(geom) AS area FROM bc_municipality WHERE ST_NRings(geom) > 1 ORDER BY area DESC LIMIT 1; gid \| name \| area -----+--------------+------------------ 12 \| SPALLUMCHEEN \| 257374619.430216 French 1 character edited Current translation Translated SELECT gid, name, ST_Area(geom) AS area FROM bc_municipality WHERE ST_NRings(geom) > 1 ORDER BY area DESC LIMIT 1 ; gid \| name \| area -----+--------------+------------------ 12 \| SPALLUMCHEEN \| 257374619.430216 2 weeks ago
vincentbre Translation changed postgis / using_postgis_query.xml — French	English Wikipedia: Dimensionally Extended Nine-Intersection Model (DE-9IM) French 1 character edited Current translation Translated Wikipedia : Dimensionally Extended Nine-Intersection Model (DE-9IM) 2 weeks ago
vincentbre Translation changed postgis / using_postgis_query.xml — French	English SELECT gid, name, ST_Area(geom) AS area FROM bc_municipality WHERE ST_NRings(geom) > 1 ORDER BY area DESC LIMIT 1; gid \| name \| area -----+--------------+------------------ 12 \| SPALLUMCHEEN \| 257374619.430216 French 0 characters edited Translated SELECT gid, name, ST_Area(geom) AS area FROM bc_municipality WHERE ST_NRings(geom) > 1 ORDER BY area DESC LIMIT 1; gid \| name \| area -----+--------------+------------------ 12 \| SPALLUMCHEEN \| 257374619.430216 2 weeks ago

Browse all component changes