Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/components/postgis-workshop/geography/changes/?format=api&page=12
https://weblate.osgeo.org/api/components/postgis-workshop/geography/changes/?format=api&page=13", "previous": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/changes/?format=api&page=11", "results": [ { "unit": "https://weblate.osgeo.org/api/units/101739/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-14T08:02:16.543152Z", "action": 4, "target": "`ST_GeographyFromText(text) <http://postgis.net/docs/ST_GeographyFromText.html>`_: Well-Known Text (WKT) 表現または拡張 WKT (EWKT) 表現から、ジオグラフィを返します。", "id": 1454941, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1454941/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101736/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-14T08:02:16.539263Z", "action": 4, "target": "`ST_Distance(geometry, geometry) <http://postgis.net/docs/ST_Distance.html>`_: ジオメトリ型については、二つのジオメトリの2次元デカルト距離の最小値 (空間参照系に基づく) を空間参照系の単位で返します。ジオグラフィ型については、デフォルトでは二つのジオメトリの球面の最小距離をメートル単位で返します。", "id": 1454940, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1454940/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101730/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-14T08:02:16.535095Z", "action": 4, "target": "**地理的に分散したデータセットで距離を測定する必要がある場合には** (世界の大部分をカバーする場合)、**ジオグラフィ型を使います**。「ジオグラフィ」の作業でアプリケーションの複雑性が節約できるので、あらゆるパフォーマンス上の問題を埋め合わせてくれます。そして、「ジオメトリ」は多くの機能制限を埋め合わす能力があります。", "id": 1454939, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1454939/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101727/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-14T08:02:16.531010Z", "action": 4, "target": "**データが地理的にコンパクトな場合** (州、郡、市に含まれる場合)、**ジオメトリ型とデカルト投影を使います**。http://epsg.io/ サイトを見て、使用可能な空間参照系を選択するために、お住いの地域の名前を入力してみて下さい。", "id": 1454938, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1454938/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101721/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-14T08:02:16.526899Z", "action": 4, "target": "それと、球面上の計算は、デカルト計算よりも非常に計算量が多くなります。たとえば、デカルト空間の距離に関する式 (ピタゴラスの定理) は、sqrt() を1回呼びます。球面上の距離に関する式 (半正矢関数) は、sqrt() を2回呼び、arctan() を1回呼び、sin() を4回呼び、cos() を2回呼びます。三角関数は非常に計算コストがかかり、球面計算には多数の三角関数が使われます。", "id": 1454937, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1454937/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101719/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-14T08:02:16.522686Z", "action": 4, "target": "まず、前述の通り、ジオグラフィ型を直接サポートする関数は (今のところ) ごく少数です。ジオグラフィ型の制限の回避に多くの時間を費やす場合もあります。", "id": 1454936, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1454936/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101717/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-14T08:02:16.518794Z", "action": 4, "target": "地理座標は普遍的に受け入れられる座標で、誰もが緯度/経度がどういう意味かを理解していますが、UTM座標がどういう意味かを理解している人はまずいません。なのになぜ地理座標系を常に使うことにならないのでしょうか?", "id": 1454935, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1454935/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101711/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-14T08:02:16.510776Z", "action": 4, "target": ":command:`ST_X(point)` 関数はジオメトリ型だけに対応しています。では、ジオグラフィからX値を読むにはどうすればいいでしょうか?", "id": 1454933, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1454933/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/1514238/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-14T08:02:16.506568Z", "action": 4, "target": "PostgreSQLのキャストに関する構文規則では、キャストしたい値の後ろに ``::型名`` を追加します。よって ``2::text`` は 2 という数値を '2' という文字列に変換します。また、``'POINT(0 0)'::geometry`` はポイントの文字列表現をジオメトリのポイントに変換します。", "id": 1454932, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1454932/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101657/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-14T08:02:16.502120Z", "action": 4, "target": "ジオグラフィ座標の処理へのデカルトのアプローチは、日付変更線をクロスする地物について、完全に分解します。ロサンゼルスから東京までの最短大円ルートは太平洋とクロスします。デカルトでの最短ルートは大西洋とインド洋とクロスします。", "id": 1454931, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1454931/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101656/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-14T08:02:16.498168Z", "action": 4, "target": "LAX-CDGルートでアイスランドに最も接近する距離 (アイスランドの国際空港からの距離とします) は比較的小さな502kmです。", "id": 1454930, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1454930/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101653/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-14T08:02:16.494188Z", "action": 4, "target": "「ロサンゼルスからパリまでのフライトでどれだけアイスランドに近づくか」等の問題が出る時に、ポイント以外のジオメトリのサポートの必要性が非常にはっきりしました。", "id": 1454929, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1454929/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101646/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-14T08:02:16.489981Z", "action": 4, "target": "ORACLEは、SRIDが地理座標系の時に、透過的な地理座標系計算によって、違いを覆い隠そうとします。", "id": 1454928, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1454928/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101634/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-14T08:02:16.485387Z", "action": 4, "target": "地理座標をデカルト座標系の近似のように扱えますし、空間計算を続行できます。しかしながら、距離、長さ、面積の計測は**無意味**です。球面座標系は**角度**の距離を計測し、単位は「度」となるためです。さらに、インデックスとインタセクトや包含といった真偽テストからの近似的な結果が、ひどく悪くなる可能性があります。ポイント間の距離は、極 (北極や南極) や日付変更線といった問題の領域では大きくなります。", "id": 1454927, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1454927/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101633/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-14T08:02:16.471979Z", "action": 4, "target": "地理座標系は、メルカトル、UTM、州平面、座標と違い、**デカルト座標ではありません**。地理座標系では、平面上にプロットするような原点からの線形距離を表現しない座標系です。これらの**球面座標**は、地球上の角度の座標を表します。球面座標では、ポイントは基準子午線からの回転角度 (経度) と赤道からの角度 (緯度) で指定されます。", "id": 1454926, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1454926/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101733/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/anonymous/?format=api", "author": "https://weblate.osgeo.org/api/users/anonymous/?format=api", "timestamp": "2023-06-13T16:57:47.957945Z", "action": 4, "target": "関数リスト", "id": 1454579, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1454579/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101697/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/anonymous/?format=api", "author": "https://weblate.osgeo.org/api/users/anonymous/?format=api", "timestamp": "2023-06-13T16:57:47.943288Z", "action": 4, "target": "ジオグラフィテーブルの生成", "id": 1454578, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1454578/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101642/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-12T10:06:52.126194Z", "action": 2, "target": "球面では、「1平方度」は非常に可変的です。赤道から離れるにつれ小さくなります。極に向かって進むにつれ、地球上の子午線 (垂直線) が他の子午線と近くなっていくと考えて下さい。122度という距離は、全く*意味がありません*。無意味な数字なのです。", "id": 1454396, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/1454396/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101641/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-12T10:06:48.602288Z", "action": 2, "target": "空間参照系 4326 の単位は度です。結果は 122 度でした。でも (二度目)、これはどういう意味でしょう?", "id": 1454395, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/1454395/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101639/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-12T10:06:46.026281Z", "action": 2, "target": "わっ! 122! でもこれはどういう意味でしょう?", "id": 1454394, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/1454394/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101638/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-12T10:06:43.215723Z", "action": 2, "target": "通常のPostGISデカルト距離の計算である :command:`ST_Distance(geometry, geometry)` を使ってロサンゼルスとパリの間の距離の計算は次のように行います。SRIDが4326で地理空間参照系を宣言していることに注意して下さい。", "id": 1454393, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/1454393/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101637/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-12T10:06:39.438028Z", "action": 2, "target": "パリ: ``POINT(2.3490 48.8533)``", "id": 1454392, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/1454392/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101636/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-12T10:06:37.479195Z", "action": 2, "target": "ロサンゼルス: ``POINT(-118.4079 33.9434)``", "id": 1454391, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/1454391/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101635/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-12T10:06:34.526916Z", "action": 2, "target": "たとえば、ロサンゼルスとパリの座標です。", "id": 1454390, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/1454390/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101634/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-12T10:06:29.781815Z", "action": 2, "target": "地理座標をデカルト座標系の近似のように扱えますし、空間計算を続行できます。しかしながら、距離、長さ、面積の計測は**無意味**です。球面座標系は**角度**の距離を計測し、単位は「度」となるためです。さらに、インデックスとインタセクトや包含といった真偽テストからの近似的な結果が、ひどく悪くなる可能性があります。ポイント間の距離は、高緯度地域や日付変更線といった問題の領域では大きくなります。", "id": 1454389, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/1454389/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101632/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-12T10:06:04.812106Z", "action": 2, "target": "座標が「地理座標系」または「緯度/経度」のデータを持つことは極めて一般的です。", "id": 1454388, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/1454388/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101631/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-12T10:06:01.966848Z", "action": 2, "target": "ジオグラフィ", "id": 1454387, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/1454387/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101755/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-12T10:01:56.878190Z", "action": 9, "target": "脚注", "id": 1454386, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/1454386/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101733/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-12T10:01:56.805371Z", "action": 9, "target": "関数リスト", "id": 1454384, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/1454384/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101724/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-12T10:01:56.299851Z", "action": 9, "target": "結論は?", "id": 1454370, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/1454370/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101715/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-12T10:01:56.283688Z", "action": 9, "target": "なぜジオグラフィを使うのか/使わないのか", "id": 1454369, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/1454369/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101707/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-12T10:01:56.267438Z", "action": 9, "target": "ジオグラフィ型の基本関数が多数のユースケースを処理できる一方、ジオメトリ型にしか対応しない関数にアクセスする必要がある場合があります。幸運なことに、ジオメトリとジオグラフィは相互に変換できます。", "id": 1454368, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/1454368/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101705/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-12T10:01:56.248694Z", "action": 9, "target": "ジオメトリへのキャスト", "id": 1454367, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/1454367/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101703/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-12T10:01:56.230703Z", "action": 9, "target": "上の出力から一部のカラムが省略されました。", "id": 1454366, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/1454366/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101701/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-12T10:01:56.213200Z", "action": 9, "target": "テーブル定義では ``GEOGRAPHY(Point)`` は空港データタイプをポイントとして指定します。新しいジオグラフィフィールドは ``geometry_columns`` ビューには登録されません。かわりに ``geography_columns`` と呼ばれるビューに登録されます。", "id": 1454365, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/1454365/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101699/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-12T10:01:56.195284Z", "action": 9, "target": "ジオグラフィカラムを持つテーブルの新規作成のSQLはジオメトリテーブルの生成とよく似ています。しかしながら、ジオグラフィはテーブル生成時にオブジェクトタイプを直接指定する機能が含まれます。例を示します:", "id": 1454364, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/1454364/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101697/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-12T10:01:56.177749Z", "action": 9, "target": "ジオグラフィテーブルの生成", "id": 1454363, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/1454363/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101694/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-12T10:01:56.161538Z", "action": 9, "target": ":command:`ST_Intersection(geography, geography)` は ``geography`` [#Casting_note]_ 型を返します", "id": 1454362, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/1454362/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101692/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-12T10:01:56.145155Z", "action": 9, "target": ":command:`ST_Buffer(geography, float8)` は ``geography`` [#Casting_note]_ 型を返します", "id": 1454361, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/1454361/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101690/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-12T10:01:56.128204Z", "action": 9, "target": ":command:`ST_Intersects(geography, geography)` は ``boolean`` 型を返します", "id": 1454360, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/1454360/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101688/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-12T10:01:56.111613Z", "action": 9, "target": ":command:`ST_CoveredBy(geography, geography)` は ``boolean`` 型を返します", "id": 1454359, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/1454359/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101686/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-12T10:01:56.094594Z", "action": 9, "target": ":command:`ST_Covers(geography, geography)` は ``boolean`` 型を返します", "id": 1454358, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/1454358/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101684/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-12T10:01:56.078152Z", "action": 9, "target": ":command:`ST_Length(geography)` は ``double`` 型を返します", "id": 1454357, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/1454357/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101682/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-12T10:01:56.061017Z", "action": 9, "target": ":command:`ST_Area(geography)` は ``double`` 型を返します", "id": 1454356, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/1454356/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101680/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-12T10:01:56.044232Z", "action": 9, "target": ":command:`ST_DWithin(geography, geography, float8)` は ``boolean`` 型を返します", "id": 1454355, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/1454355/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101678/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-12T10:01:56.026629Z", "action": 9, "target": ":command:`ST_Distance(geography, geography)` は ``double`` 型を返します", "id": 1454354, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/1454354/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101676/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-12T10:01:56.005071Z", "action": 9, "target": ":command:`ST_AsGeoJson(geography)` は ``text`` 型を返します", "id": 1454353, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/1454353/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101674/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-12T10:01:55.988615Z", "action": 9, "target": ":command:`ST_AsKML(geography)` は ``text`` 型を返します", "id": 1454352, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/1454352/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101672/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-12T10:01:55.972217Z", "action": 9, "target": ":command:`ST_AsGML(geography)` は ``text`` 型を返します", "id": 1454351, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/1454351/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101670/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/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-06-12T10:01:55.955392Z", "action": 9, "target": ":command:`ST_AsSVG(geography)` は ``text`` 型を返します", "id": 1454350, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/1454350/?format=api" } ] }{ "count": 778, "next": "