Please sign in to see the alerts.

Overview

Project website postgis.net
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 stable-3.2
Last remote commit Push to 3.2.6dev milestone 6e2c5206d
Regina Obe authored a week ago
Weblate repository https://weblate.osgeo.org/git/postgis_branch_32/postgis/
File mask doc/po/*/reference_troubleshooting.xml.po

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 234 3,663 28,089
Source 26 407 3,121
Translated 11% 26 11% 407 11% 3,121
Needs editing 0% 0 0% 0 0% 0
Read-only 11% 26 11% 407 11% 3,121
Failing checks 7% 17 1% 58 4% 1,168
Strings with suggestions 66% 156 57% 2,122 58% 16,509
Untranslated strings 88% 208 88% 3,256 88% 24,968
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 5 changes 0 changes 0 changes 0 changes 0 changes 0 changes 3 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 398 changes 5 changes
Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May

Quick numbers

3,663
Hosted words
234
Hosted strings
11%
Translated
2
Contributors
and previous 30 days

Trends of last 30 days

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

Component unlocked

postgis_branch_32 / reference_troubleshooting

Fixing an alert automatically unlocked the component. 2 weeks ago
User avatar None

Component locked

postgis_branch_32 / reference_troubleshooting

The component was automatically locked because of an alert. 2 weeks ago
User avatar None

New alert

postgis_branch_32 / reference_troubleshooting

Could not update the repository. 2 weeks ago
User avatar anonymous

Suggestion added

postgis_branch_32 / reference_troubleshooting — French

Troubleshooting Functions
Fonctions de dépannage
3 weeks ago
User avatar anonymous

Suggestion added

postgis_branch_32 / reference_troubleshooting — French

These functions are utilities for troubleshooting and repairing geometry data. They are only needed if the geometry data is corrupted in some way, which should never happen under normal circumstances.
Ces fonctions sont des utilitaires de dépannage et de réparation des données géométriques. Elles ne sont nécessaires que si les données géométriques sont corrompues d'une manière ou d'une autre, ce qui ne devrait jamais se produire dans des circonstances normales.
3 weeks ago
User avatar anonymous

Suggestion added

postgis_branch_32 / reference_troubleshooting — French

SELECT geom
FROM sometable WHERE PostGIS_HasBBox(geom) = false;
SELECT the_geom
FROM sometable WHERE PostGIS_HasBBox(the_geom) = false ;
4 months ago
User avatar anonymous

Suggestion added

postgis_branch_32 / reference_troubleshooting — French

--This example drops bounding boxes where the cached box is not correct
--The force to ST_AsBinary before applying Box2D forces a recalculation of the box, and Box2D applied to the table geometry always
-- returns the cached bounding box.
UPDATE sometable
SET geom = PostGIS_DropBBox(geom)
WHERE Not (Box2D(ST_AsBinary(geom)) = Box2D(geom));

UPDATE sometable
SET geom = PostGIS_AddBBox(geom)
WHERE Not PostGIS_HasBBOX(geom);
-- Cet exemple supprime les emprises lorsque l'emprise mise en cache est incorrecte
-- Le fait de forcer ST_AsBinary avant d'appliquer Box2D provoque un recalcul de l'emprise, et
-- Box2D appliquée à la géométrie de la table renvoie toujours l'emprise mise en cache.
UPDATE sometable
SET the_geom = PostGIS_DropBBox(the_geom)
WHERE Not (Box2D(ST_AsBinary(the_geom)) = Box2D(the_geom)) ;

UPDATE sometable
SET the_geom = PostGIS_AddBBox(the_geom)
WHERE Not PostGIS_HasBBOX(the_geom) ;
4 months ago
User avatar anonymous

Suggestion added

postgis_branch_32 / reference_troubleshooting — French

UPDATE sometable
SET geom = PostGIS_AddBBox(geom)
WHERE PostGIS_HasBBox(geom) = false;
UPDATE sometable
SET geom = PostGIS_AddBBox(geom)
WHERE PostGIS_HasBBox(geom) = false ;
4 months ago
User avatar anonymous

Suggestion added

postgis_branch_32 / reference_troubleshooting — Japanese

SELECT geom
FROM sometable WHERE PostGIS_HasBBox(geom) = false;
SELECT geom
FROM sometable WHERE PostGIS_HasBBox(geom) = false;
7 months ago
User avatar anonymous

Suggestion added

postgis_branch_32 / reference_troubleshooting — Japanese

--This example drops bounding boxes where the cached box is not correct
--The force to ST_AsBinary before applying Box2D forces a recalculation of the box, and Box2D applied to the table geometry always
-- returns the cached bounding box.
UPDATE sometable
SET geom = PostGIS_DropBBox(geom)
WHERE Not (Box2D(ST_AsBinary(geom)) = Box2D(geom));

UPDATE sometable
SET geom = PostGIS_AddBBox(geom)
WHERE Not PostGIS_HasBBOX(geom);
-- これは、バウンディングボックスのキャッシュが正しくないときに
-- バウンディングボックスを削除する例です。
-- Box2Dの適用でバウンディングボックスの再計算が強制される前に
-- ST_AsBinaryを実行して、
-- ジオメトリテーブルに適用されたBox2Dが
-- 常にバウンディングボックスのキャッシュを返すようにします。
UPDATE sometable
SET geom = PostGIS_DropBBox(geom)
WHERE Not (Box2D(ST_AsBinary(geom)) = Box2D(geom));

UPDATE sometable
SET geom = PostGIS_AddBBox(geom)
WHERE Not PostGIS_HasBBOX(geom);
7 months ago
Browse all component changes