postgis-workshop/history_tracking — Japanese @ OSGeo Weblate

Translation status

42	Strings	100%	Browse Translate
856	Words	100%
5,039	Characters	100%

Strings status

Strings Words Characters
42 856 5,039		All strings	Browse Translate Zen
42 856 5,039		Translated strings	Browse Translate Zen

Other components

Component	Unfinished	Unfinished words	Unfinished characters	Untranslated	Checks	Suggestions	Comments
spatial_relationships	0	0	0	0	0	0	0

spatial_relationships_exercises	0	0	0	0	3	0	0

joins_exercises	0	0	0	0	3	0	0

geography_exercises	0	0	0	0	1	0	0

geometry_returning	0	0	0	0	0	0	0

projection_exercises	0	0	0	0	3	0	0

advanced_geometry_construction	0	0	0	0	0	0	0

3d	0	0	0	0	0	0	0

backup	0	0	0	0	0	0	0

license	0	0	0	0	0	0	0

Browse all components

Overview

Project website	postgis.net/workshops/postgis-intro
Project maintainers	jsanz komzpa dmateos yellow73 dkastl cvvergara andischi astrid_emde jef
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 #120 from osgeoweblate/weblate-postgis-workshop-index `75182f2` Regina Obe authored 3 weeks ago
Last commit in Weblate	Merge pull request #117 from osgeoweblate/weblate-postgis-workshop-index `e91022e` Regina Obe authored a month ago
Weblate repository	`https://weblate.osgeo.org/git/postgis-workshop/index/`
File mask	`postgis-intro/sources/locale/*/LC_MESSAGES/history_tracking.po`
Translation file	Download `postgis-intro/sources/locale/ja/LC_MESSAGES/history_tracking.po`
Last change	July 21, 2023, 7:22 a.m.
Last author	Teramoto Ikuhiro

3 days ago

String statistics

	Strings percent	Hosted strings	Words percent	Hosted words	Characters percent	Hosted characters
Total		42		856		5,039
Translated	100%	42	100%	856	100%	5,039
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


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

Quick numbers

856

Hosted words

Hosted strings

100%

Translated

Contributors

and previous 30 days

Trends of last 30 days

—

Hosted words

+100%

—

Hosted strings

+100%

—

Translated

+100%

—

Contributors

—

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 編集操作ごとに記録する履歴テーブルを維持することで履歴追跡が働きます。: 9 months 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>`_ 9 months 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>`_ 9 months 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>`_ 9 months 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 特定の使用者が追加したものだけを表示するビューを作ることもできます。次のようにします: 9 months 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分前のテーブルの状況を示す履歴テーブルのビューを生成してみましょう。 9 months 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 の後に削除された全てのレコード。 9 months 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 の前に作られ、まだ削除されていない全てのレコードと、さらに 9 months ago
yellow73 Suggestion accepted postgis-workshop history_tracking Japanese	English Now that we have a history table, what use is it? It's useful for time travel! To travel to a particular time T, you need to construct a query that includes: Japanese 80 characters edited Current translation Translated 現在、履歴テーブルを持っています。どういう用途でしょうか? 時間旅行に使うのです! 特定の時刻 T に行くには、次を含むクエリを構築する必要があります: 9 months ago
yellow73 Suggestion accepted postgis-workshop history_tracking Japanese	English Updating the two streets will cause the original streets to be marked as deleted in the history table, with a deletion time of now, and two new streets with the new name added, with an addition time of now. You can inspect the historical records: Japanese 101 characters edited Current translation Translated 二つのストリートの更新によって、履歴テーブルでは元のストリートに削除済みマーク、削除時刻が付き、二つの名前が変更された新しいストリートが追加され、現在時刻が付きます。履歴レコードを調べることができます: 9 months ago

Browse all translation changes

Quick downloads

42	File in original format as translated in the repository	gettext PO file
42	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:>=2024-03-18 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-03-18 AND state:<=needs-editing`	Add