Translation status

109 Strings 100%
Browse Translate
2,128 Words 100%

Strings status

109
All strings — 2,128 words Browse Translate Zen
109
Translated strings — 2,128 words Browse Translate Zen
109
Strings waiting for review — 2,128 words Browse Translate Zen
25
Translated strings with dismissed checks — 246 words Browse Translate Zen

Other components

Component Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
reference_raster.xml This component is linked to the postgis/postgis repository. 11% 1,429 40,921 339,543 1,429 0 0 0
release_notes.xml This component is linked to the postgis/postgis repository. 11% 1,597 15,436 141,542 1,597 0 0 0
reference_transformation.xml This component is linked to the postgis/postgis repository. 0 0 0 0 0 0 0
reference_transaction.xml This component is linked to the postgis/postgis repository. 0 0 0 0 0 0 0
faq.xml This component is linked to the postgis/postgis repository. 0 0 0 0 0 0 0
postgis CC-BY-3.0 0 0 0 0 0 0 0
reference_management.xml This component is linked to the postgis/postgis repository. 0 0 0 0 0 0 0
database_tuning.xml This component is linked to the postgis/postgis repository. 0 0 0 0 0 0 0
faq_raster.xml This component is linked to the postgis/postgis repository. 0 0 0 0 0 0 0
extras.xml This component is linked to the postgis/postgis repository. 0 0 0 0 0 0 0
Browse all components

Overview

Project website postgis.net
Project maintainers User avatar komzpa User avatar cvvergara User avatar strk User avatar 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 Have skip signature generator scan full postgis upgrade script 5e05bc3e7
Sandro Santilli authored 4 days ago
Last commit in Weblate Translated reference_coverage using Weblate (French) af45bca00
Vincent Bre authored 4 weeks ago
Weblate repository https://weblate.osgeo.org/git/postgis/postgis/
File mask doc/po/*/using_postgis_query.xml.po
Translation file Download doc/po/fr/using_postgis_query.xml.po
Last change May 11, 2023, 3:53 p.m.
Last author Vincent Bre

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 109 2,128 16,517
Approved 0% 0 0% 0 0% 0
Waiting for review 100% 109 100% 2,128 100% 16,517
Translated 100% 109 100% 2,128 100% 16,517
Needs editing 0% 0 0% 0 0% 0
Read-only 0% 0 0% 0 0% 0
Failing checks 0% 0 0% 0 0% 0
Strings with suggestions 0% 0 0% 0 0% 0
Untranslated strings 0% 0 0% 0 0% 0
Last 12 months Previous

Activity in last 12 months

0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 2 changes 0 changes 8 changes 0 changes 9 changes 0 changes 0 changes 0 changes 20 changes 124 changes
Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May

Quick numbers

2,128
Hosted words
109
Hosted strings
100%
Translated
2
Contributors
and previous 30 days

Trends of last 30 days

—
Hosted words
—
—
Hosted strings
—
+94%
Translated
—
+100%
Contributors
—
User avatar None

Resource update

postgis / using_postgis_query.xml — French

The "doc/po/fr/using_postgis_query.xml.po" file was changed. 3 weeks ago
User avatar None

String updated in the repository

postgis / using_postgis_query.xml — French

-- 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');
-- 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') ;
3 weeks ago
User avatar None

String updated in the repository

postgis / using_postgis_query.xml — French

-- 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, '1*1***1**');
-- 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, '1*1***1**') ;
3 weeks ago
User avatar vincentbre

New translation

postgis / using_postgis_query.xml — French

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>&amp;&amp;</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.
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>&amp;&amp;</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.
4 weeks ago
User avatar vincentbre

Translation changed

postgis / using_postgis_query.xml — French

SELECT gid, name, ST_Area(geom) AS area
FROM bc_municipality
WHERE ST_NRings(geom) &gt; 1
ORDER BY area DESC LIMIT 1;

gid | name | area
-----+--------------+------------------
12 | SPALLUMCHEEN | 257374619.430216
SELECT gid, name, ST_Area(geom) AS area
FROM bc_municipality
WHERE ST_NRings(geom) &gt; 1
ORDER BY area DESC LIMIT 1 ;

gid | name | area
-----+--------------+------------------
12 | SPALLUMCHEEN | 257374619.430216
4 weeks ago
User avatar vincentbre

Translation changed

postgis / using_postgis_query.xml — French

Wikipedia: Dimensionally Extended Nine-Intersection Model (DE-9IM)
Wikipedia : Dimensionally Extended Nine-Intersection Model (DE-9IM)
4 weeks ago
User avatar vincentbre

Translation changed

postgis / using_postgis_query.xml — French

SELECT gid, name, ST_Area(geom) AS area
FROM bc_municipality
WHERE ST_NRings(geom) &gt; 1
ORDER BY area DESC LIMIT 1;

gid | name | area
-----+--------------+------------------
12 | SPALLUMCHEEN | 257374619.430216
SELECT gid, name, ST_Area(geom) AS area
FROM bc_municipality
WHERE ST_NRings(geom) &gt; 1
ORDER BY area DESC LIMIT 1;

gid | name | area
-----+--------------+------------------
12 | SPALLUMCHEEN | 257374619.430216
4 weeks ago
User avatar vincentbre

Marked for edit

postgis / using_postgis_query.xml — French

SELECT gid, name, ST_Area(geom) AS area
FROM bc_municipality
WHERE ST_NRings(geom) &gt; 1
ORDER BY area DESC LIMIT 1;

gid | name | area
-----+--------------+------------------
12 | SPALLUMCHEEN | 257374619.430216
SELECT gid, name, ST_Area(geom) AS area
FROM bc_municipality
WHERE ST_NRings(geom) &gt; 1
ORDER BY area DESC LIMIT 1;

gid | name | area
-----+--------------+------------------
12 | SPALLUMCHEEN | 257374619.430216
4 weeks ago
User avatar vincentbre

New translation

postgis / using_postgis_query.xml — French

What is the largest municipality polygon that has a hole?
Quel est le plus grand polygone municipal comportant un trou ?
4 weeks ago
User avatar vincentbre

Translation changed

postgis / using_postgis_query.xml — French

SELECT
sum(ST_Length(r.geom))/1000 AS kilometers
FROM bc_roads r
JOIN bc_municipality m
ON ST_Intersects(m.geom, r.geom
WHERE
r.name = 'Douglas St'
AND m.name = 'VICTORIA';

kilometers
------------------
4.89151904172838
SELECT
sum(ST_Length(r.geom))/1000 AS kilometers
FROM bc_roads r
JOIN bc_municipality m
ON ST_Intersects(m.geom, r.geom
WHERE
r.name = 'Douglas St'
AND m.name = 'VICTORIA' ;

kilometers
------------------
4.89151904172838
4 weeks ago
Browse all translation changes