1# SOME DESCRIPTIVE TITLE.
2#
3# Translators:
4msgid ""
5msgstr ""
6"Project-Id-Version: PostGIS\n"
7"Report-Msgid-Bugs-To: https://bugs.kde.org\n"
8"POT-Creation-Date: 2020-02-01 19:38+0000\n"
9"PO-Revision-Date: 2016-11-07 07:54+0000\n"
10"Last-Translator: TERAMOTO Ikuhiro <yellow@affrc.go.jp>\n"
11"Language-Team: Japanese (http://www.transifex.com/postgis/postgis/language/"
12"ja/)\n"
13"Language: ja\n"
14"MIME-Version: 1.0\n"
15"Content-Type: text/plain; charset=UTF-8\n"
16"Content-Transfer-Encoding: 8bit\n"
17"Plural-Forms: nplurals=1; plural=0;\n"
18
19#. Tag: title
20#: extras_historytable.xml:3
21#, no-c-format
22msgid "History Tracking"
23msgstr "履歴追跡"
24
25#. Tag: para
26#: extras_historytable.xml:6
27#, no-c-format
28msgid ""
29"Suppose you have a table of data that represents the current state of a "
30"particular geographic feature. A parcels table, or a roads table, or a fruit "
31"trees table, whatever. Generally, GIS tools understand a table as a single "
32"entity into which they can update, insert and delete rows from. How you do "
33"allow common GIS tools to work against your data, while maintaining an audit "
34"trail of what changes have been made, by whom, and what the past state of "
35"the data is?"
36msgstr ""
37"特定の地物の現在の状態を示すデータのテーブルがあるとします。区画テーブルで"
38"あったり、道路テーブルであったり、果樹テーブルであったり、なんでもかまいませ"
39"ん。一般的にGISツールはテーブルを、更新と削除が可能な単一の実体ととらえます。"
40"一般的なGISツールに、先ほどのデータに対して、どういう変更が、誰によってなさ"
41"れ、かつ過去のデータの状態がどうであったかの監査証跡を維持しながら動作させる"
42"にはどのようにするでしょうか。"
43
44#. Tag: para
45#: extras_historytable.xml:10
46#, no-c-format
47msgid ""
48"This <varname>history_table</varname> extra module provides some utility "
49"functions for creating and maintaining history."
50msgstr ""
51"<varname>history_table</varname>拡張モジュールは、履歴の生成と維持のための関"
52"数を提供します。"
53
54#. Tag: para
55#: extras_historytable.xml:14
56#, no-c-format
57msgid ""
58"The <varname>history_table</varname> was also packaged in PostGIS 1.5, but "
59"added to the documentation in PostGIS 2.0. This package is written in "
60"plpgsql and located in the <varname>extras/history_table</varname> of "
61"PostGIS source tar balls and source repository."
62msgstr ""
63"<varname>history_table</varname>はPostGIS 1.5に同梱されていましたが、文書は"
64"PostGIS 2.0で追加されました。このパッケージはPL/pgSQLで書かれ、PostGISソース"
65"アーカイブまたはソースレポジトリの<varname>extras/history_table</varname>にあ"
66"ります。"
67
68#. Tag: para
69#: extras_historytable.xml:15
70#, no-c-format
71msgid ""
72"If you have a table 'roads', this module will maintain a 'roads_history' "
73"side table, which contains all the columns of the parent table, and the "
74"following additional columns:"
75msgstr ""
76"'roads'テーブルを持っていると、親テーブルの全てのカラムと次に示すカラムを持"
77"つ'roads_history'副テーブルが、このモジュールによって維持されます。"
78
79#. Tag: programlisting
80#: extras_historytable.xml:16
81#, no-c-format
82msgid ""
83"history_id      | integer                     | not null default\n"
84" date_added      | timestamp without time zone | not null default now()\n"
85" date_deleted    | timestamp without time zone |\n"
86" last_operation  | character varying(30)       | not null\n"
87" active_user     | character varying(90)       | not null default "
88"\"current_user\"()\n"
89" current_version | text                        | not null"
90msgstr ""
91"history_id      | integer                     | not null default\n"
92" date_added      | timestamp (タイムゾーンなし)| not null default now()\n"
93" date_deleted    | timestamp (タイムゾーンなし)|\n"
94" last_operation  | character varying(30)       | not null\n"
95" active_user     | character varying(90)       | not null default "
96"\"current_user\"()\n"
97" current_version | text                        | not null"
98
99#. Tag: para
100#: extras_historytable.xml:20
101#, no-c-format
102msgid ""
103"When you insert a new record into 'roads' a record is automatically inserted "
104"into 'roads_history', with the 'date_added' filled in the 'date_deleted' set "
105"to NULL, a unique 'history_id', a 'last_operation' of 'INSERT' and "
106"'active_user' set."
107msgstr ""
108"新しいレコードを'roads'に追加すると、レコードは自動的に'roads_history'に挿入"
109"され、'date_added'に値が入り、'date_deleted'にNULLが設定され、'history_id'に"
110"一意の値が入り、'last_operation'に'INSERT'が入り、'active_user'に値が入りま"
111"す。"
112
113#. Tag: para
114#: extras_historytable.xml:23
115#, no-c-format
116msgid ""
117"When you delete a record in 'roads', the record in the history table is "
118"*not* deleted, but the 'date_deleted' is set to the current date."
119msgstr ""
120"'roads'内のテーブルを削除すると、履歴テーブルのレコードは*削除されません"
121"*。'date_deleted'に現在の日時が入ります。"
122
123#. Tag: para
124#: extras_historytable.xml:26
125#, no-c-format
126msgid ""
127"When you update a record in 'roads', the current record has 'date_deleted' "
128"filled in and a new record is created with the 'date_added' set and "
129"'date_deleted' NULL."
130msgstr ""
131"'roads'テーブルのレコードを更新すると、現在の持つ'date_deleted'に値が入り、新"
132"しいレコードが生成され、'date_added'に値が入り、'date_deleted'にNULLが入りま"
133"す。"
134
135#. Tag: para
136#: extras_historytable.xml:30
137#, no-c-format
138msgid ""
139"With this information maintained, it is possible to retrieve the history of "
140"any record in the roads table:"
141msgstr ""
142"この情報を維持することで、roadsテーブルの全てのレコードの履歴を取得することが"
143"できます。"
144
145#. Tag: programlisting
146#: extras_historytable.xml:31
147#, no-c-format
148msgid "SELECT * FROM roads_history WHERE roads_pk = 111;"
149msgstr "SELECT * FROM roads_history WHERE roads_pk = 111;"
150
151#. Tag: para
152#: extras_historytable.xml:33
153#, no-c-format
154msgid "Or, to retrieve a view of the roads table at any point in the past:"
155msgstr "ある過去の時点におけるroadsテーブルの状態を検索することもできます。"
156
157#. Tag: programlisting
158#: extras_historytable.xml:34
159#, no-c-format
160msgid ""
161"SELECT * FROM roads_history\n"
162"    WHERE date_added &lt; 'January 1, 2001' AND\n"
163"        ( date_deleted &gt;= 'January 1, 2001' OR date_deleted IS NULL );"
164msgstr ""
165"SELECT * FROM roads_history\n"
166"    WHERE date_added &lt; 'January 1, 2001' AND\n"
167"        ( date_deleted &gt;= 'January 1, 2001' OR date_deleted IS NULL );"
168
169#. Tag: refname
170#: extras_historytable.xml:38
171#, no-c-format
172msgid "Postgis_Install_History"
173msgstr "Postgis_Install_History"
174
175#. Tag: refpurpose
176#: extras_historytable.xml:39
177#, no-c-format
178msgid ""
179"Creates a table that will hold some interesting values for managing history "
180"tables."
181msgstr "履歴テーブルの管理のための値を持つテーブルを生成します。"
182
183#. Tag: funcprototype
184#: extras_historytable.xml:44
185#, no-c-format
186msgid ""
187"<funcdef>void <function>Postgis_Install_History</function></funcdef> "
188"<paramdef></paramdef>"
189msgstr ""
190"<funcdef>void <function>Postgis_Install_History</function></funcdef> "
191"<paramdef></paramdef>"
192
193#. Tag: title
194#: extras_historytable.xml:52 extras_historytable.xml:92
195#, no-c-format
196msgid "Description"
197msgstr "説明"
198
199#. Tag: para
200#: extras_historytable.xml:54
201#, no-c-format
202msgid ""
203"Creates a table that will hold some interesting values for managing history "
204"tables. Creates a table called <varname>historic_information</varname>"
205msgstr ""
206"履歴テーブルの管理のための値を持つテーブルを生成します。テーブル名は"
207"<varname>historic_information</varname>になります。"
208
209#. Tag: para
210#: extras_historytable.xml:58 extras_historytable.xml:100
211#, no-c-format
212msgid "Availability: 1.5.0"
213msgstr "Availability: 1.5.0"
214
215#. Tag: title
216#: extras_historytable.xml:63 extras_historytable.xml:105
217#, no-c-format
218msgid "Examples"
219msgstr "例"
220
221#. Tag: programlisting
222#: extras_historytable.xml:65
223#, no-c-format
224msgid "SELECT postgis_install_history();"
225msgstr "SELECT postgis_install_history();"
226
227#. Tag: title
228#: extras_historytable.xml:71 extras_historytable.xml:113
229#, no-c-format
230msgid "See Also"
231msgstr "関連情報"
232
233#. Tag: refname
234#: extras_historytable.xml:77
235#, no-c-format
236msgid "Postgis_Enable_History"
237msgstr "Postgis_Enable_History"
238
239#. Tag: refpurpose
240#: extras_historytable.xml:78
241#, no-c-format
242msgid ""
243"Registers a tablein the history_information table for tracking and also adds "
244"in side line history table and insert, update, delete rules on the table."
245msgstr ""
246"history_informationテーブルに追跡のための登録を行い、履歴テーブルを追加し、"
247"テーブルに挿入、更新、削除の規則を設定します。"
248
249#. Tag: funcprototype
250#: extras_historytable.xml:83
251#, no-c-format
252msgid ""
253"<funcdef>boolean <function>Postgis_Enable_History</function></funcdef> "
254"<paramdef><type>text </type> <parameter>p_schema</parameter></paramdef> "
255"<paramdef><type>text </type> <parameter>p_table</parameter></paramdef>"
256msgstr ""
257"<funcdef>boolean <function>Postgis_Enable_History</function></funcdef> "
258"<paramdef><type>text </type> <parameter>p_schema</parameter></paramdef> "
259"<paramdef><type>text </type> <parameter>p_table</parameter></paramdef>"
260
261#. Tag: para
262#: extras_historytable.xml:94
263#, no-c-format
264msgid ""
265"Registers a table in the history_information table for tracking and also "
266"adds in side line history table with same name as table but prefixed with "
267"<varname>history</varname> in the same schema as the original table. Puts in "
268"insert, update, delete rules on the table. Any inserts,updates,deletes of "
269"the geometry are recorded in the history table."
270msgstr ""
271"history_informationテーブルに追跡のための登録を行い、元テーブル名の前に"
272"<varname>history</varname>をつけた名前となる履歴テーブルを、元テーブルと同じ"
273"スキーマに追加し、テーブルに挿入、更新、削除の規則を設定します。ジオメトリの"
274"挿入、更新、削除は履歴テーブルに全て記録されます。"
275
276#. Tag: para
277#: extras_historytable.xml:97
278#, no-c-format
279msgid ""
280"This function currently relies on a geometry column being registered in "
281"<varname>geometry_columns</varname> and fails if the geometry column is not "
282"present in <varname>geometry_columns</varname> table."
283msgstr ""
284"この関数は現在は<varname>geometry_columns</varname>に登録されているジオメトリ"
285"カラムに依っていて、<varname>geometry_columns</varname>にないジオメトリカラム"
286"では失敗します。"
287
288#. Tag: programlisting
289#: extras_historytable.xml:107
290#, no-c-format
291msgid ""
292"CREATE TABLE roads(gid SERIAL PRIMARY KEY, road_name varchar(150));\n"
293"SELECT AddGeometryColumn('roads', 'geom', 26986, 'LINESTRING', 2);\n"
294"\n"
295"SELECT postgis_enable_history('public', 'roads', 'geom') As register_table;\n"
296"register_table\n"
297"--------------\n"
298"t\n"
299"\n"
300"INSERT INTO roads(road_name, geom)\n"
301"  VALUES('Test Street', ST_GeomFromText('LINESTRING(231660.5 832170,231647 "
302"832202,231627.5 832250.5)',26986));\n"
303"\n"
304"-- check transaction detail --\n"
305"SELECT date_added, last_operation, current_version\n"
306"FROM roads_history\n"
307"WHERE road_name = 'Test Street' ORDER BY date_added DESC;\n"
308"\n"
309"       date_added       | last_operation | current_version\n"
310"------------------------+----------------+-----------------\n"
311" 2011-02-07 12:44:36.92 | INSERT         | 2"
312msgstr ""
313"CREATE TABLE roads(gid SERIAL PRIMARY KEY, road_name varchar(150));\n"
314"SELECT AddGeometryColumn('roads', 'geom', 26986, 'LINESTRING', 2);\n"
315"\n"
316"SELECT postgis_enable_history('public', 'roads', 'geom') As register_table;\n"
317"register_table\n"
318"--------------\n"
319"t\n"
320"\n"
321"INSERT INTO roads(road_name, geom)\n"
322"  VALUES('Test Street', ST_GeomFromText('LINESTRING(231660.5 832170,231647 "
323"832202,231627.5 832250.5)',26986));\n"
324"\n"
325"-- トランザクションの詳細を確認--\n"
326"SELECT date_added, last_operation, current_version\n"
327"FROM roads_history\n"
328"WHERE road_name = 'Test Street' ORDER BY date_added DESC;\n"
329"\n"
330"       date_added       | last_operation | current_version\n"
331"------------------------+----------------+-----------------\n"
332" 2011-02-07 12:44:36.92 | INSERT         | 2"
333