postgis-workshop

history_tracking

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

	Chinese (Simplified)	2%	41	854	5,031	41	1	0	0

	German	2%	41	854	5,031	41	0	0	0

	Japanese		0	0	0	0	0	0	0

	Spanish	2%	41	854	5,031	41	0	0	0

Please sign in to see the alerts.

Overview

Project website	postgis.net/workshops/postgis-intro
Project maintainers	komzpa dmateos dkastl jsanz andischi cvvergara astrid_emde jef yellow73
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	Merge pull request #136 from latot/topo_intro `3b31e91` Regina Obe authored 14 hours ago
Last commit in Weblate	Merge pull request #117 from osgeoweblate/weblate-postgis-workshop-index `e91022e` Regina Obe authored 8 months ago
Weblate repository	`https://weblate.osgeo.org/git/postgis-workshop/index/`
File mask	`postgis-intro/sources/locale/*/LC_MESSAGES/history_tracking.po`

6 days ago

String statistics

	Strings percent	Hosted strings	Words percent	Hosted words	Characters percent	Hosted characters
Total		210		4,280		25,195
Source		42		856		5,039
Translated	41%	87	40%	1,718	40%	10,102
Needs editing	0%	0	0%	0	0%	0
Read-only	20%	42	20%	856	20%	5,039
Failing checks	1%	1	1%	2	1%	8
Strings with suggestions	0%	0	0%	0	0%	0
Untranslated strings	58%	123	59%	2,562	59%	15,093

Last 12 months Previous

Activity in last 12 months


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

Quick numbers

4,280

Hosted words

210

Hosted strings

41%

Translated

and previous 30 days

Trends of last 30 days

—

Hosted words

+100%

—

Hosted strings

+100%

—

Translated

+41%

—

Contributors

—

Search

Advanced query builder

Query examples

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

None Alert triggered postgis-workshop history_tracking	Component seems unused. 4 months ago
None Alert triggered postgis-workshop history_tracking	Broken project website URL a year ago
yellow73 Suggestion accepted postgis-workshop history_tracking Japanese	English History tracking works by keeping a history table that records, for every edit: Japanese 1 character edited Current translation Translated 編集操作ごとに記録する履歴テーブルを維持することで履歴追跡が働きます。: a year ago
yellow73 Suggestion accepted postgis-workshop history_tracking Japanese	English `PostgreSQL Range Types <https://www.postgresql.org/docs/current/rangetypes.html>`_ Japanese 83 characters edited Current translation Translated `PostgreSQL 範囲型 <https://www.postgresql.jp/document/current/html/rangetypes.html>`_ a year ago
yellow73 Suggestion accepted postgis-workshop history_tracking Japanese	English `PostgreSQL Triggers <http://www.postgresql.org/docs/current/static/plpgsql-trigger.html>`_ Japanese 90 characters edited Current translation Translated `PostgreSQL トリガ関数 <https://www.postgresql.jp/document/current/html/plpgsql-trigger.html>`_ a year ago
yellow73 Suggestion accepted postgis-workshop history_tracking Japanese	English `QGIS open source GIS <http://qgis.org>`_ Japanese 46 characters edited Current translation Translated `QGIS フリーでオープンソースの地理情報システム <http://qgis.org>`_ a year ago
yellow73 Suggestion accepted postgis-workshop history_tracking Japanese	English We can also create views that show just what a particular used has added, for example: Japanese 43 characters edited Current translation Translated 特定の使用者が追加したものだけを表示するビューを作ることもできます。次のようにします: a year ago
yellow73 Suggestion accepted postgis-workshop history_tracking Japanese	English We can use this logic to create a query, or a view, of the state of the data in the past. Since presumably all your test edits have happened in the past couple minutes, let's create a view of the history table that shows the state of the table 10 minutes ago, before you started editing (so, the original data). Japanese 125 characters edited Current translation Translated このロジックを使って、過去のデータ状況のクエリやビューを生成できます。おそらく全ての試験編集は過去数分に行われているので、編集開始前 (つまりオリジナルデータ) である、10分前のテーブルの状況を示す履歴テーブルのビューを生成してみましょう。 a year ago
yellow73 Suggestion accepted postgis-workshop history_tracking Japanese	English All records created before T, but deleted after T. Japanese 29 characters edited Current translation Translated T の前に作られるが T の後に削除された全てのレコード。 a year ago
yellow73 Suggestion accepted postgis-workshop history_tracking Japanese	English All records created before T, and not yet deleted; and also Japanese 31 characters edited Current translation Translated T の前に作られ、まだ削除されていない全てのレコードと、さらに a year ago

Browse all component changes