postgis/extras_historytable.xml — French @ OSGeo Weblate

Translation status

28	Strings		100%	Browse Translate
579	Words		100%	Browse Translate

Strings status

28	All strings — 579 words	Browse Translate Zen
28	Translated strings — 579 words	Browse Translate Zen
28	Strings waiting for review — 579 words	Browse Translate Zen

Other components

Component	Translated	Unfinished	Unfinished words	Unfinished characters	Untranslated	Checks	Suggestions	Comments
reference_raster.xml	11%	1,429	40,921	339,543	1,429	0	0	0

release_notes.xml	11%	1,597	15,436	141,542	1,597	0	0	0

reference_transformation.xml		0	0	0	0	0	0	0

reference_transaction.xml		0	0	0	0	0	0	0

faq.xml		0	0	0	0	0	0	0

postgis CC-BY-3.0		0	0	0	0	0	0	0

reference_management.xml		0	0	0	0	0	0	0

database_tuning.xml		0	0	0	0	0	0	0

faq_raster.xml		0	0	0	0	0	0	0

extras.xml		0	0	0	0	0	0	0

Browse all components

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	Translated using Weblate (French) `57cbcb942` Vincent Bre authored 2 days ago
Last commit in Weblate	Translated reference_coverage using Weblate (Japanese) `b12c50677` Teramoto Ikuhiro authored 2 weeks ago
Weblate repository	`https://weblate.osgeo.org/git/postgis/postgis/`
File mask	`doc/po/*/extras_historytable.xml.po`
Translation file	Download `doc/po/fr/extras_historytable.xml.po`
Last change	May 12, 2023, 7:17 a.m.
Last author	Vincent Bre

String statistics

	Strings percent	Hosted strings	Words percent	Hosted words	Characters percent	Hosted characters
Total		28		579		4,396
Approved	0%	0	0%	0	0%	0
Waiting for review	100%	28	100%	579	100%	4,396
Translated	100%	28	100%	579	100%	4,396
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


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

Quick numbers

579

Hosted words

Hosted strings

100%

Translated

Contributors

and previous 30 days

Trends of last 30 days

—

Hosted words

—

Hosted strings

—

+50%

Translated

—

+100%

Contributors

—

None Resource update postgis / extras_historytable.xml — French	The "`doc/po/fr/extras_historytable.xml.po`" file was changed. 2 weeks ago
None String updated in the repository postgis / extras_historytable.xml — French	English SELECT * FROM roads_history WHERE date_added < 'January 1, 2001' AND ( date_deleted >= 'January 1, 2001' OR date_deleted IS NULL ); French 2 characters edited Current translation Translated SELECT * FROM roads_history WHERE date_added &lt ; 'January 1, 2001' AND ( date_deleted &gt ;= 'January 1, 2001' OR date_deleted IS NULL ) ; 2 weeks ago
vincentbre Translation changed postgis / extras_historytable.xml — French	English CREATE TABLE roads(gid SERIAL PRIMARY KEY, road_name varchar(150)); SELECT AddGeometryColumn('roads', 'geom', 26986, 'LINESTRING', 2); SELECT postgis_enable_history('public', 'roads', 'geom') As register_table; register_table -------------- t INSERT INTO roads(road_name, geom) VALUES('Test Street', ST_GeomFromText('LINESTRING(231660.5 832170,231647 832202,231627.5 832250.5)',26986)); -- check transaction detail -- SELECT date_added, last_operation, current_version FROM roads_history WHERE road_name = 'Test Street' ORDER BY date_added DESC; date_added \| last_operation \| current_version ------------------------+----------------+----------------- 2011-02-07 12:44:36.92 \| INSERT \| 2 French 7 characters edited Current translation Translated CREATE TABLE roads(gid SERIAL PRIMARY KEY, road_name varchar(150)) ; SELECT AddGeometryColumn('roads', 'geom', 26986, 'LINESTRING', 2) ; SELECT postgis_enable_history('public', 'roads', 'geom') As register_table ; register_table -------------- t INSERT INTO roads(road_name, geom) VALUES('Test Street', ST_GeomFromText('LINESTRING(231660.5 832170,231647 832202,231627.5 832250.5)',26986)) ; -- check transaction detail -- SELECT date_added, last_operation, current_version FROM roads_history WHERE road_name = 'Test Street' ORDER BY date_added DESC ; date_added \| last_operation \| current_version ------------------------+----------------+----------------- 2011-02-07 12 :44 :36.92 \| INSERT \| 2 2 weeks ago
vincentbre New translation postgis / extras_historytable.xml — French	English CREATE TABLE roads(gid SERIAL PRIMARY KEY, road_name varchar(150)); SELECT AddGeometryColumn('roads', 'geom', 26986, 'LINESTRING', 2); SELECT postgis_enable_history('public', 'roads', 'geom') As register_table; register_table -------------- t INSERT INTO roads(road_name, geom) VALUES('Test Street', ST_GeomFromText('LINESTRING(231660.5 832170,231647 832202,231627.5 832250.5)',26986)); -- check transaction detail -- SELECT date_added, last_operation, current_version FROM roads_history WHERE road_name = 'Test Street' ORDER BY date_added DESC; date_added \| last_operation \| current_version ------------------------+----------------+----------------- 2011-02-07 12:44:36.92 \| INSERT \| 2 French 715 characters edited Translated CREATE TABLE roads(gid SERIAL PRIMARY KEY, road_name varchar(150)); SELECT AddGeometryColumn('roads', 'geom', 26986, 'LINESTRING', 2); SELECT postgis_enable_history('public', 'roads', 'geom') As register_table; register_table -------------- t INSERT INTO roads(road_name, geom) VALUES('Test Street', ST_GeomFromText('LINESTRING(231660.5 832170,231647 832202,231627.5 832250.5)',26986)); -- check transaction detail -- SELECT date_added, last_operation, current_version FROM roads_history WHERE road_name = 'Test Street' ORDER BY date_added DESC; date_added \| last_operation \| current_version ------------------------+----------------+----------------- 2011-02-07 12:44:36.92 \| INSERT \| 2 2 weeks ago
vincentbre New translation postgis / extras_historytable.xml — French	English This function currently relies on a geometry column being registered in <varname>geometry_columns</varname> and fails if the geometry column is not present in <varname>geometry_columns</varname> table. French 228 characters edited Current translation Translated Cette fonction repose actuellement sur l'enregistrement d'une colonne géométrique dans <varname>geometry_columns</varname> et échoue si la colonne géométrique n'est pas présente dans la table <varname>geometry_columns</varname>. 2 weeks ago
vincentbre New translation postgis / extras_historytable.xml — French	English Registers a table in the history_information table for tracking and also adds in side line history table with same name as table but prefixed with <varname>history</varname> in the same schema as the original table. Puts in insert, update, delete rules on the table. Any inserts,updates,deletes of the geometry are recorded in the history table. French 441 characters edited Current translation Translated Enregistre une table dans la table history_information pour le suivi et ajoute également en ligne latérale une table history portant le même nom que la table mais préfixée par <varname>history</varname> dans le même schéma que la table d'origine. Instaure des règles d'insertion, de mise à jour et de suppression pour la table. Toutes les insertions, mises à jour et suppressions de la géométrie sont enregistrées dans la table d'historique. 2 weeks ago
vincentbre New translation postgis / extras_historytable.xml — French	English Registers a table in the history_information table for tracking and also adds in side line history table and insert, update, delete rules on the table. French 203 characters edited Current translation Translated Enregistre une table dans la table history_information pour le suivi et ajoute également une table d'historique de ligne latérale et des règles d'insertion, de mise à jour et de suppression sur la table. 2 weeks ago
vincentbre New translation postgis / extras_historytable.xml — French	English Creates a table that will hold some interesting values for managing history tables. Creates a table called <varname>historic_information</varname> French 159 characters edited Current translation Translated Crée une table qui contiendra des valeurs intéressantes pour la gestion des tables d'historique. Crée une table appelée <varname>historic_information</varname> 2 weeks ago
vincentbre New translation postgis / extras_historytable.xml — French	English Creates a table that will hold some interesting values for managing history tables. French 96 characters edited Current translation Translated Crée une table qui contiendra des valeurs intéressantes pour la gestion des tables d'historique. 2 weeks ago
vincentbre Translation changed postgis / extras_historytable.xml — French	English SELECT * FROM roads_history WHERE date_added < 'January 1, 2001' AND ( date_deleted >= 'January 1, 2001' OR date_deleted IS NULL ); French 3 characters edited Translated SELECT * FROM roads_history WHERE date_added &lt ; 'January 1, 2001' AND ( date_deleted &gt ;= 'January 1, 2001' OR date_deleted IS NULL ) ; 2 weeks ago

Browse all translation changes

Quick downloads

28	File in original format as translated in the repository	gettext PO file
28	All strings, converted files enriched with comments; suitable for offline translation	CSV	gettext MO	gettext PO	TBX	TMX	XLIFF 1.1 with gettext extensions	XLIFF 1.1	XLSX

Customize download

Search

Advanced query builder

Query examples

Review strings changed by other users	`changed:>=2023-05-01 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-05-01 AND state:<=needs-editing`	Add