Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/components/postgis-workshop/joins/changes/?format=api&page=6
{ "count": 340, "next": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/changes/?format=api&page=7", "previous": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/changes/?format=api&page=5", "results": [ { "unit": "https://weblate.osgeo.org/api/units/100726/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-30T07:09:00.755418Z", "action": 7, "target": "まず、``nyc_subway_stations`` テーブルの ``routes`` フィールドの内容は、A列車 を見つけるのに興味を持っていることに注意して下さい。そこの値は少し複雑です。", "id": 1487390, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487390/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100723/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-30T07:08:57.896000Z", "action": 7, "target": "デューク・エリントンは、かつて「あなたは / A列車に乗らないと / だって / ハーレムのシュガーヒルにいくのでしょう」と歌いました。先に見た通り、ハーレムはアフリカ系アメリカ人の人口がはるかに多くなっています (80.5%)。デューク・エリントンの A列車 もそう言えるでしょうか?", "id": 1487389, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487389/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100721/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-30T07:08:50.996317Z", "action": 7, "target": "ニューヨーク市には 800万人 がいて、44% が「白人」で、26% が「黒人」と記録されています。", "id": 1487388, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487388/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100719/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-30T07:08:46.888810Z", "action": 7, "target": "最初に、市の人種構成の基準を得ましょう。", "id": 1487387, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487387/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100717/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-30T07:08:42.666480Z", "action": 7, "target": "距離テストも結合キーとして使うことができます。「半径内の全ての地物」クエリを生成する場合に使います。距離クエリを使ってニューヨークの人種地理を見ていきましょう。", "id": 1487386, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487386/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100715/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-30T07:08:35.211329Z", "action": 7, "target": "``JOIN`` 節は、二つの ``FROM`` の項目を結合します。デフォルトでは ``INNER JOIN`` を使いますが、4種の結合のタイプがあります。詳細については、PostgreSQL ドキュメントで定義されている `join_type <https://www.postgresql.jp/document/current/html/sql-select.html#SQL-FROM>`_ をご覧下さい。", "id": 1487385, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487385/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100713/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-30T07:08:26.076858Z", "action": 7, "target": "最後の数に関する計算とフォーマット調整 (例: ``GROUP BY``, ``ORDER BY``) の後に、クエリはパーセンテージを吐き出します。", "id": 1487384, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487384/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100711/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-30T07:08:19.613472Z", "action": 7, "target": "残る行は町名でグループ化され、人口値を :command:`Sum()` する集約関数に渡されます。", "id": 1487383, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487383/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100708/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-30T07:08:14.422674Z", "action": 7, "target": "\"WHERE\" 節で、仮想テーブルをマンハッタン内の行にフィルタリングします。", "id": 1487382, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487382/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100706/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-30T07:08:10.306383Z", "action": 7, "target": "\"JOIN\" 節で、町とセンサスの両方のテーブルからのコラムを持つ、仮想的なテーブルが発生します。", "id": 1487381, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487381/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100704/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-30T07:08:07.968140Z", "action": 7, "target": "ここで何がおこっているのでしょう? 概念上 (実際の評価順はデータベース内部で最適化されています) は次のことが発生しています:", "id": 1487380, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487380/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100702/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-30T07:08:04.192878Z", "action": 7, "target": "例: **「マンハッタンの町ごとの人口と人口構成比率は?」** 国勢調査から人口情報と、町の境界データとの組み合わせた質問があり、マンハッタンの一つの区のみに制限された質問となります。", "id": 1487379, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487379/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100700/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-30T07:08:00.783630Z", "action": 7, "target": "``GROUP BY`` と ``JOIN`` の組合せによって、GIS システムで通常行われるような解析が可能です。", "id": 1487378, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487378/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100697/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-30T07:07:57.323763Z", "action": 7, "target": "結合と要約", "id": 1487377, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487377/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100695/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-30T07:07:49.810199Z", "action": 2, "target": "全ての地下鉄駅と、その駅の属する町とを結合することができますが、この場合は一つだけ情報が必要でした。二つのテーブルの間の TRUE / FALSE 関係を返す関数は全て、空間結合で使うことができます。最も一般的には :command:`ST_Intersects`, :command:`ST_Contains`, :command:`ST_DWithin` が使われます。", "id": 1487376, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/1487376/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100695/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-30T07:07:24.651696Z", "action": 7, "target": "全ての地下鉄駅と、その駅の属する町とを結合することができますが、この場合は一つだけ情報が必要でした。二つのテーブルの間の TRUE / FALSE 関係を返す関数は全て、空間結合で使うことができます。最も一般的には :command:`ST_Intersects`, :command:`ST_Contains`, and :command:`ST_DWithin` が使われます。", "id": 1487375, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487375/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100693/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-30T07:07:15.252072Z", "action": 7, "target": "空間結合を使うと、この地下鉄駅に関する情報の検索と、地下鉄駅を含む町の検索とを1ステップで実行できます:", "id": 1487374, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487374/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100691/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-30T07:07:10.929147Z", "action": 7, "target": "前の節では、空間関係を2ステップで調べました。すなわち、最初に地下鉄 'Broad St' 駅のポイントを抽出し、その後、そのポイントを「'Broad St' のある町は何ですか?」といった、より大きな問題の質問に使いました。", "id": 1487373, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487373/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100689/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-30T07:06:58.061504Z", "action": 7, "target": "空間結合は空間データベースの基本です。空間関係を結合キーにによって使用することで、異なるテーブルからの情報を結びつけることができます。「標準GIS解析」と考えるものの多くは空間結合として表現できます。", "id": 1487372, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1487372/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100745/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-30T07:06:45.944894Z", "action": 4, "target": "前のように、結合で、\"JOIN ON\" 制約に合致した全てのありえる組合せの仮想テーブルが生成され、これらの行は \"GROUP\" による集約に渡されます。``ST_DWithin`` 関数が空間処理のミソで、適切な地下鉄駅に近い統計区だけを計算に取り込むようにします。", "id": 1487371, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1487371/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100743/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-30T07:06:45.940749Z", "action": 4, "target": "これで地下鉄路線のテーブルを元のクエリに結合できます。", "id": 1487370, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1487370/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100741/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-30T07:06:45.936852Z", "action": 4, "target": "その問に答えるには、これまでのクエリに他の結合を追加して、多数の地下鉄路線の構成を一括して同時に計算できるようにします。これを行うには、要約したい路線の全てを列挙する新しいテーブルを生成する必要があります。", "id": 1487369, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1487369/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100739/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-30T07:06:45.932802Z", "action": 4, "target": "最後のセクションでは、A列車 が市の残りの領域の人種構成から大きく異なって人口に影響を与えるようなことがなかったことが分かりました。平均的でない人種構成を持つ列車はあるでしょうか?", "id": 1487368, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1487368/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100702/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-30T07:06:45.884059Z", "action": 4, "target": "例: **「マンハッタンの町ごとの人口と人口構成比率は?」** 国勢調査から人口情報と、町の境界データとの組み合わせた質問があり、マンハッタンの一つの区のみに制限された質問となります。", "id": 1487367, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1487367/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100687/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-29T02:13:09.221129Z", "action": 7, "target": "空間結合", "id": 1486989, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1486989/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100758/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-29T02:13:02.465053Z", "action": 4, "target": "`strpos(string, substring) <http://www.postgresql.org/docs/current/static/functions-string.html>`_: 指定した部分文字列の位置を示す整数を返す PostgreSQL 文字列関数", "id": 1486988, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1486988/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100756/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-29T02:13:02.458963Z", "action": 4, "target": "`round(v numeric, s integer) <http://www.postgresql.org/docs/current/interactive/functions-math.html>`_: 小数点以下の桁数を s 桁に丸めるPostgreSQL 数学関数", "id": 1486987, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1486987/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100751/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-29T02:13:02.452896Z", "action": 4, "target": "`ST_DWithin(geometry A, geometry B, radius) <http://postgis.net/docs/ST_DWithin.html>`_: ジオメトリと他のジオメトリとの距離が指定した距離以内である場合に TRUE を返します。", "id": 1486986, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1486986/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100749/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-29T02:13:02.446570Z", "action": 4, "target": "`ST_Contains(geometry A, geometry B) <http://postgis.net/docs/ST_Contains.html>`_: Bの点がAの外部に全く存在せず、Bの内部の少なくとも一つの点がAの内部に存在する場合にのみ TRUE を返します。", "id": 1486985, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1486985/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100736/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-29T02:13:02.440562Z", "action": 4, "target": "高度な結合", "id": 1486984, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1486984/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100734/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-29T02:13:02.434903Z", "action": 4, "target": "A系統 に沿った人種構成はニューヨーク市全体の人種構成と根本的に違いはありません。", "id": 1486983, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1486983/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100732/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-29T02:13:02.429145Z", "action": 4, "target": "A系統 の200メートル内の人種構成を要約しましょう。", "id": 1486982, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1486982/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100730/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-29T02:13:02.423464Z", "action": 4, "target": "よって A列車 を見つけるには、``routes`` 内の 'A' を含む全ての行が必要です。これは様々な方法がありますが、今回は ``routes`` フィールド内に 'A' がある場合にだけ :command:`strpos(routes,'A')` が 0 以外の値を返すのを使います。", "id": 1486981, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1486981/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100728/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-29T02:13:02.417295Z", "action": 4, "target": "``DISTINCT`` キーワードは結果から重複する行を削除します。``DISTINCT`` を使わない場合には、クエリの結果は 73件 でなく 491件 となります。", "id": 1486980, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1486980/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100726/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-29T02:13:02.411292Z", "action": 4, "target": "まず、``nyc_subway_stations`` テーブルの ``routes`` フィールドの内容は、A列車 を見つけるのに興味を持っていることに注意して下さい。そこの値は少し複雑です。", "id": 1486979, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1486979/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100723/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-29T02:13:02.405311Z", "action": 4, "target": "デューク・エリントンは、かつて「あなたは / A列車に乗らないと / だって / ハーレムのシュガーヒルにいくのでしょう」と歌いました。先に見た通り、ハーレムはアフリカ系アメリカ人の人口がはるかに多くなっています (80.5%)。デューク・エリントンの A列車 もそう言えるでしょうか?", "id": 1486978, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1486978/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100721/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-29T02:13:02.399338Z", "action": 4, "target": "ニューヨーク市には 800万人 がいて、44% が「白人」で、26% が「黒人」と記録されています。", "id": 1486977, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1486977/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100719/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-29T02:13:02.393675Z", "action": 4, "target": "最初に、市の人種構成の基準を得ましょう。", "id": 1486976, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1486976/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100717/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-29T02:13:02.387880Z", "action": 4, "target": "距離テストも結合キーとして使うことができます。「半径内の全ての地物」クエリを生成する場合に使います。距離クエリを使ってニューヨークの人種地理を見ていきましょう。", "id": 1486975, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1486975/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100715/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-29T02:13:02.381658Z", "action": 4, "target": "``JOIN`` 節は、二つの ``FROM`` の項目を結合します。デフォルトでは ``INNER JOIN`` を使いますが、4種の結合のタイプがあります。詳細については、PostgreSQL ドキュメントで定義されている `join_type <https://www.postgresql.jp/document/current/html/sql-select.html#SQL-FROM>`_ をご覧下さい。", "id": 1486974, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1486974/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100713/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-29T02:13:02.375635Z", "action": 4, "target": "最後の数に関する計算とフォーマット調整 (例: ``GROUP BY``, ``ORDER BY``) の後に、クエリはパーセンテージを吐き出します。", "id": 1486973, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1486973/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100711/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-29T02:13:02.369635Z", "action": 4, "target": "残る行は町名でグループ化され、人口値を :command:`Sum()` する集約関数に渡されます。", "id": 1486972, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1486972/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100708/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-29T02:13:02.363729Z", "action": 4, "target": "\"WHERE\" 節で、仮想テーブルをマンハッタン内の行にフィルタリングします。", "id": 1486971, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1486971/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100706/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-29T02:13:02.357870Z", "action": 4, "target": "\"JOIN\" 節で、町とセンサスの両方のテーブルからのコラムを持つ、仮想的なテーブルが発生します。", "id": 1486970, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1486970/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100704/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-29T02:13:02.351929Z", "action": 4, "target": "ここで何がおこっているのでしょう? 概念上 (実際の評価順はデータベース内部で最適化されています) は次のことが発生しています:", "id": 1486969, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1486969/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100700/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-29T02:13:02.345660Z", "action": 4, "target": "``GROUP BY`` と ``JOIN`` の組合せによって、GIS システムで通常行われるような解析が可能です。", "id": 1486968, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1486968/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100697/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-29T02:13:02.339877Z", "action": 4, "target": "結合と要約", "id": 1486967, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1486967/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100695/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-29T02:13:02.333828Z", "action": 4, "target": "全ての地下鉄駅と、その駅の属する町とを結合することができますが、この場合は一つだけ情報が必要でした。二つのテーブルの間の TRUE / FALSE 関係を返す関数は全て、空間結合で使うことができます。最も一般的には :command:`ST_Intersects`, :command:`ST_Contains`, and :command:`ST_DWithin` が使われます。", "id": 1486966, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1486966/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100693/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-29T02:13:02.320174Z", "action": 4, "target": "空間結合を使うと、この地下鉄駅に関する情報の検索と、地下鉄駅を含む町の検索とを1ステップで実行できます:", "id": 1486965, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1486965/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100691/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-08-29T02:13:02.314196Z", "action": 4, "target": "前の節では、空間関係を2ステップで調べました。すなわち、最初に地下鉄 'Broad St' 駅のポイントを抽出し、その後、そのポイントを「'Broad St' のある町は何ですか?」といった、より大きな問題の質問に使いました。", "id": 1486964, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1486964/?format=api" } ] }