Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/components/postgis-workshop/projection/changes/?format=api&page=6
{ "count": 370, "next": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/changes/?format=api&page=7", "previous": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/changes/?format=api&page=5", "results": [ { "unit": "https://weblate.osgeo.org/api/units/2241429/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-05-06T05:33:16.030708Z", "action": 71, "target": "", "id": 1956885, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/1956885/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2241428/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-05-06T05:33:16.030658Z", "action": 71, "target": "", "id": 1956884, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/1956884/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2241427/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-05-06T05:33:16.030609Z", "action": 71, "target": "", "id": 1956883, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/1956883/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2241426/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-05-06T05:33:16.030559Z", "action": 71, "target": "", "id": 1956882, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/1956882/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2241425/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-05-06T05:33:16.030510Z", "action": 71, "target": "", "id": 1956881, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/1956881/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2241424/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-05-06T05:33:16.030460Z", "action": 71, "target": "", "id": 1956880, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/1956880/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2241423/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-05-06T05:33:16.030410Z", "action": 71, "target": "", "id": 1956879, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/1956879/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2241422/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-05-06T05:33:16.030360Z", "action": 71, "target": "", "id": 1956878, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/1956878/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2241421/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-05-06T05:33:16.030311Z", "action": 71, "target": "", "id": 1956877, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/1956877/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2241420/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-05-06T05:33:16.030262Z", "action": 71, "target": "", "id": 1956876, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/1956876/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2241419/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-05-06T05:33:16.030213Z", "action": 71, "target": "", "id": 1956875, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/1956875/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2241418/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-05-06T05:33:16.030163Z", "action": 71, "target": "", "id": 1956874, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/1956874/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2241417/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-05-06T05:33:16.030112Z", "action": 71, "target": "", "id": 1956873, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/1956873/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2241416/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-05-06T05:33:16.030048Z", "action": 71, "target": "", "id": 1956872, "action_name": "String added in the repository", "url": "https://weblate.osgeo.org/api/changes/1956872/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2024-05-06T05:33:15.836580Z", "action": 48, "target": "", "id": 1956871, "action_name": "Language added", "url": "https://weblate.osgeo.org/api/changes/1956871/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": null, "timestamp": "2024-05-06T05:33:15.831471Z", "action": 17, "target": "", "id": 1956870, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/1956870/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/ja/?format=api", "user": null, "author": null, "timestamp": "2023-12-22T10:45:19.578447Z", "action": 17, "target": "", "id": 1900992, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/1900992/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104667/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-21T10:08:01.730558Z", "action": 2, "target": "**srtext** 定義オブジェクトを ``srtext`` から読み込め、かつ形成できる場合には、これを使います。", "id": 1900961, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/1900961/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-21T10:07:18.587967Z", "action": 1, "target": "", "id": 1900960, "action_name": "Translation completed", "url": "https://weblate.osgeo.org/api/changes/1900960/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104712/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-21T10:07:18.519757Z", "action": 7, "target": "`ST_SetSRID(geometry, srid) <https://postgis.net/docs/ja/ST_SetSRID.html>`_: ジオメトリに指定した整数値の SRID を設定します。", "id": 1900959, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1900959/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104709/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-21T10:07:09.482762Z", "action": 7, "target": "しかしながら、座標の SRID が何になるのか分かっている場合には、ジオメトリに対して事後的に :command:`ST_SetSRID` を使って設定できます。そうすると、ジオメトリを他の系に変換できるようになります。", "id": 1900958, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1900958/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104708/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-21T10:06:33.941567Z", "action": 2, "target": "テーブルの SRID 割当を表示するには、データベースの ``geometry_columns`` テーブルを見ます。", "id": 1900957, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/1900957/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104708/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-21T10:06:10.025849Z", "action": 7, "target": "テーブルの SRID 割当を表示するには、データベースの ``geometry_columns`` テーブルをクエリします。", "id": 1900956, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1900956/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104707/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-21T10:06:05.552612Z", "action": 7, "target": "SRID の指定なしでデータのロードやジオメトリの生成を行う場合には、SRID 値は 0 になります。:ref:`geometries` を思い出して下さい。``geometries`` テーブルを生成した時に、SRID を指定していませんでした。データベースにクエリを出す場合には、全ての ``nyc_`` テーブルが SRID 26918 を持つことを期待されているのに、``geometries`` テーブルは SRID はデフォルトで 0 でした。", "id": 1900955, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1900955/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104705/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-21T10:05:59.714427Z", "action": 7, "target": "'Broad St' 地下鉄駅の座標を地理座標系に変換してみましょう:", "id": 1900954, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1900954/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104703/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-21T10:05:57.342103Z", "action": 7, "target": "``spatial_ref_sys`` テーブルから定義を得ることもできます:", "id": 1900953, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1900953/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104701/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-21T10:05:53.941837Z", "action": 7, "target": "https://epsg.io/4326", "id": 1900952, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1900952/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104699/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-21T10:05:51.721862Z", "action": 7, "target": "地理座標系で最も一般的な SRID は 4326 です。これは、「WGS84 回転楕円体の経度/緯度」に対応します。定義は次のようにして見ることができます:", "id": 1900951, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1900951/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104697/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-21T10:05:45.977124Z", "action": 7, "target": "一つの SRID から他のものにデータを変換するには、最初に手持ちのジオメトリが妥当な SRID を持っていることを確認しなければなりません。既に妥当な SRID であると確認したら、次に変換先 SRID が必要です。言い換えると、地理座標系の SRID は何でしょうか?", "id": 1900950, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1900950/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104694/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-21T10:05:41.406705Z", "action": 7, "target": "データを投影座標系から地理座標系 (「経度緯度」とも言います) に変換してみましょう。", "id": 1900949, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1900949/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104692/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-21T10:05:36.617295Z", "action": 7, "target": "SRID 26918 の proj4 定義に戻ると、現在の投影座標系が UTM (Universal Transverse Mercator) のゾーン 18 で、計測単位はメートルであることが分かります。", "id": 1900948, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1900948/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104690/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-21T10:05:31.951138Z", "action": 7, "target": "データの変換", "id": 1900947, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1900947/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104687/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-21T10:05:28.816563Z", "action": 2, "target": "オンザフライ変換で :command:`ST_Transform` を使い過ぎないように注意して下さい。空間インデックスは格納されたジオメトリを使って構築されます。異なる SRID で比較された場合には、空間インデックスは (しばしば) 使用されません。データベースの全てのテーブルで **一つの SRID** を選ぶのが最善策です。変換関数は、外部アプリケーションとのデータの読み書きだけで使って下さい。", "id": 1900946, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/1900946/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104687/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-21T10:05:25.968421Z", "action": 7, "target": "オンザフライ変換で :command:`ST_Transform` を使ってハッピーになりすぎないように注意して下さい。空間インデックスは格納されたジオメトリを使って構築されます。異なる SRID で比較された場合には、空間インデックスは (しばしば) 使用されません。データベースの全てのテーブルで **一つの SRID** を選ぶのが最善策です。変換関数は、外部アプリケーションとのデータの読み書きだけで使って下さい。", "id": 1900945, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1900945/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104685/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-21T10:03:28.538560Z", "action": 7, "target": "異なる SRID のジオメトリを与えると、次のようなエラーが発生します:", "id": 1900944, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1900944/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104682/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-21T10:03:25.280442Z", "action": 7, "target": "まとめると、座標と SRID は、地球上の位置が定義するものです。SRID なしでは、座標は抽象的な観念にすぎません。「デカルト」座標平面は、地表面上の位置の「平らな」座標系として定義されます。PostGIS 関数はこのような平面の上で動作するので、比較操作には、両方のジオメトリが同じ SRID で表現されている必要があります。", "id": 1900943, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1900943/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104678/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-21T10:03:18.424413Z", "action": 7, "target": "データの比較", "id": 1900942, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1900942/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104675/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-21T10:03:15.459158Z", "action": 7, "target": "カスタム投影法を生成する時に、できれば ``srtext`` カラムを入れて下さい。`GeoServer <http://geoserver.org>`_, `QGIS <https://qgis.org>`_, `FME <http://www.safe.com/>`_ などで使われるためです。", "id": 1900941, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1900941/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104672/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-21T10:03:09.926124Z", "action": 7, "target": "このように冗長になっていて、PostGIS 内での新しい投影法生成に必要なものは、妥当な ``srtext`` 文字列または ``proj4text`` 文字列のいずれかになります。一般的なオーソリティ名/コードのペアは既にテーブルにロードされています。", "id": 1900940, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1900940/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104669/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-21T10:03:00.134755Z", "action": 7, "target": "**proj4text** proj は最後に ``proj4text`` を処理しようとします。", "id": 1900939, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1900939/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104667/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-21T10:02:29.975175Z", "action": 7, "target": "**srtext** ``srtext`` から定義オブジェクトを読み込め、かつ形成できる場合には、これを使います。", "id": 1900938, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1900938/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104665/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-21T10:02:19.116991Z", "action": 7, "target": "**auth_name / auth_srid** proj が内部カタログから妥当な \"authority name\" と \"authority srid\" を見つけられる場合には、投影の定義を生成するために、これを使います。", "id": 1900937, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1900937/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104712/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-21T10:02:00.268284Z", "action": 4, "target": "`ST_SetSRID(geometry, srid) <https://postgis.net/docs/ja/ST_SetSRID.html>`_: ジオメトリに指定した整数値の SRID を設定します。", "id": 1900936, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1900936/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104709/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-21T10:02:00.262429Z", "action": 4, "target": "しかしながら、座標の SRID が何になるのか分かっている場合には、ジオメトリに対して事後的に :command:`ST_SetSRID` を使って設定できます。そうすると、ジオメトリを他の系に変換できるようになります。", "id": 1900935, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1900935/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104708/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-21T10:02:00.256691Z", "action": 4, "target": "テーブルの SRID 割当を表示するには、データベースの ``geometry_columns`` テーブルをクエリします。", "id": 1900934, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1900934/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104707/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-21T10:02:00.250731Z", "action": 4, "target": "SRID の指定なしでデータのロードやジオメトリの生成を行う場合には、SRID 値は 0 になります。:ref:`geometries` を思い出して下さい。``geometries`` テーブルを生成した時に、SRID を指定していませんでした。データベースにクエリを出す場合には、全ての ``nyc_`` テーブルが SRID 26918 を持つことを期待されているのに、``geometries`` テーブルは SRID はデフォルトで 0 でした。", "id": 1900933, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1900933/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104705/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-21T10:02:00.244893Z", "action": 4, "target": "'Broad St' 地下鉄駅の座標を地理座標系に変換してみましょう:", "id": 1900932, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1900932/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104703/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-21T10:02:00.239251Z", "action": 4, "target": "``spatial_ref_sys`` テーブルから定義を得ることもできます:", "id": 1900931, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1900931/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104701/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-21T10:02:00.233433Z", "action": 4, "target": "https://epsg.io/4326", "id": 1900930, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1900930/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104699/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/projection/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-12-21T10:02:00.227323Z", "action": 4, "target": "地理座標系で最も一般的な SRID は 4326 です。これは、「WGS84 回転楕円体の経度/緯度」に対応します。定義は次のようにして見ることができます:", "id": 1900929, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1900929/?format=api" } ] }