Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/postgis-workshop/projection/ja/changes/?format=api
{ "count": 85, "next": "https://weblate.osgeo.org/api/translations/postgis-workshop/projection/ja/changes/?format=api&page=2", "previous": null, "results": [ { "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": "2024-05-30T02:45:24.067410Z", "action": 17, "target": "", "id": 1978396, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/1978396/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104713/?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": "2024-05-29T02:01:31.787996Z", "action": 7, "target": "`ST_SRID <http://postgis.net/docs/ja/ST_SRID.html>`_: ST_Geometry の、spatial_ref_sys テーブルで定義されている空間参照系識別子を返します。", "id": 1978382, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1978382/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/104713/?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": "2024-05-29T02:01:17.685157Z", "action": 4, "target": "`ST_SRID <http://postgis.net/docs/ja/ST_SRID.html>`_: ST_Geometry の、spatial_ref_sys テーブルで定義されている空間参照系識別子を返します。", "id": 1978381, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1978381/?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" }, { "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:02:00.221299Z", "action": 4, "target": "一つの SRID から他のものにデータを変換するには、最初に手持ちのジオメトリが妥当な SRID を持っていることを確認しなければなりません。既に妥当な SRID であると確認したら、次に変換先 SRID が必要です。言い換えると、地理座標系の SRID は何でしょうか?", "id": 1900928, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1900928/?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:02:00.215391Z", "action": 4, "target": "データを投影座標系から地理座標系 (「経度緯度」とも言います) に変換してみましょう。", "id": 1900927, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1900927/?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:02:00.209564Z", "action": 4, "target": "SRID 26918 の proj4 定義に戻ると、現在の投影座標系が UTM (Universal Transverse Mercator) のゾーン 18 で、計測単位はメートルであることが分かります。", "id": 1900926, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1900926/?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:02:00.203662Z", "action": 4, "target": "データの変換", "id": 1900925, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1900925/?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:02:00.197184Z", "action": 4, "target": "オンザフライ変換で :command:`ST_Transform` を使ってハッピーになりすぎないように注意して下さい。空間インデックスは格納されたジオメトリを使って構築されます。異なる SRID で比較された場合には、空間インデックスは (しばしば) 使用されません。データベースの全てのテーブルで **一つの SRID** を選ぶのが最善策です。変換関数は、外部アプリケーションとのデータの読み書きだけで使って下さい。", "id": 1900924, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1900924/?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:02:00.191127Z", "action": 4, "target": "異なる SRID のジオメトリを与えると、次のようなエラーが発生します:", "id": 1900923, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1900923/?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:02:00.185281Z", "action": 4, "target": "まとめると、座標と SRID は、地球上の位置が定義するものです。SRID なしでは、座標は抽象的な観念にすぎません。「デカルト」座標平面は、地表面上の位置の「平らな」座標系として定義されます。PostGIS 関数はこのような平面の上で動作するので、比較操作には、両方のジオメトリが同じ SRID で表現されている必要があります。", "id": 1900922, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1900922/?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:02:00.178958Z", "action": 4, "target": "データの比較", "id": 1900921, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1900921/?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:02:00.160340Z", "action": 4, "target": "カスタム投影法を生成する時に、できれば ``srtext`` カラムを入れて下さい。`GeoServer <http://geoserver.org>`_, `QGIS <https://qgis.org>`_, `FME <http://www.safe.com/>`_ などで使われるためです。", "id": 1900920, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1900920/?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:02:00.152038Z", "action": 4, "target": "このように冗長になっていて、PostGIS 内での新しい投影法生成に必要なものは、妥当な ``srtext`` 文字列または ``proj4text`` 文字列のいずれかになります。一般的なオーソリティ名/コードのペアは既にテーブルにロードされています。", "id": 1900919, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1900919/?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:02:00.143112Z", "action": 4, "target": "**proj4text** proj は最後に ``proj4text`` を処理しようとします。", "id": 1900918, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1900918/?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:00.134786Z", "action": 4, "target": "**srtext** ``srtext`` から定義オブジェクトを読み込め、かつ形成できる場合には、これを使います。", "id": 1900917, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1900917/?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:00.118267Z", "action": 4, "target": "**auth_name / auth_srid** proj が内部カタログから妥当な \"authority name\" と \"authority srid\" を見つけられる場合には、投影の定義を生成するために、これを使います。", "id": 1900916, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1900916/?format=api" } ] }