Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/postgis-workshop/simple_sql/ja/units/?format=api
{ "count": 34, "next": null, "previous": null, "results": [ { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "source": [ "Simple SQL" ], "previous_source": "", "target": [ "単純なSQL" ], "id_hash": 3260372505424773931, "content_hash": 3260372505424773931, "location": "../../en/simple_sql.rst:4", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://weblate.osgeo.org/api/units/99017/?format=api", "priority": 100, "id": 99326, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/ja/?checksum=ad3f2b84fd4b432b", "url": "https://weblate.osgeo.org/api/units/99326/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.805389Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "source": [ ":term:`SQL`, or \"Structured Query Language\", is a means of asking questions of, and updating data in, relational databases. You have already seen SQL when we created our first database. Recall:" ], "previous_source": "", "target": [ ":term:`SQL` (\"Structured Query Language\") は、リレーショナルデータベースにおいて、問合せ、更新を行う手段です。データベースの生成の地点で、みなさんは既に SQL を見ています。思い返してみましょう:" ], "id_hash": 6109885188356942522, "content_hash": 6109885188356942522, "location": "../../en/simple_sql.rst:6", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://weblate.osgeo.org/api/units/99030/?format=api", "priority": 100, "id": 99327, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/ja/?checksum=d4caac350e6faaba", "url": "https://weblate.osgeo.org/api/units/99327/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.807261Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "source": [ "But that was a question about the database. Now that we've loaded data into our database, let's use SQL to ask questions of the data! For example," ], "previous_source": "", "target": [ "これはデータベースに関する問合せでした。現時点では既にデータをロードしています。SQL でデータの問合せを実行してみましょう! たとえば、" ], "id_hash": 3420781391977058570, "content_hash": 3420781391977058570, "location": "../../en/simple_sql.rst:12", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 3, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://weblate.osgeo.org/api/units/99032/?format=api", "priority": 100, "id": 99328, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/ja/?checksum=af790e8d4b0f110a", "url": "https://weblate.osgeo.org/api/units/99328/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.809009Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "source": [ "\"What are the names of all the neighborhoods in New York City?\"" ], "previous_source": "", "target": [ "「ニューヨーク市内の全ての地区の名前を知りたい」" ], "id_hash": -1624571585063872884, "content_hash": -1624571585063872884, "location": "../../en/simple_sql.rst:14", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 4, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://weblate.osgeo.org/api/units/99034/?format=api", "priority": 100, "id": 99329, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/ja/?checksum=69745cc03013168c", "url": "https://weblate.osgeo.org/api/units/99329/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.810782Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "source": [ "Open up the SQL query window in pgAdmin by clicking the \"Query Tool\" button." ], "previous_source": "", "target": [ "\"Query Tool\" ボタンをクリックして、pgAdmin の SQLクエリウィンドウを開きます。" ], "id_hash": -907009057047372689, "content_hash": -907009057047372689, "location": "../../en/simple_sql.rst:16", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 5, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://weblate.osgeo.org/api/units/99036/?format=api", "priority": 100, "id": 99330, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/ja/?checksum=7369a81172a11c6f", "url": "https://weblate.osgeo.org/api/units/99330/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.812454Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "source": [ "then enter the following query in to the query window" ], "previous_source": "", "target": [ "クエリウィンドウに次のクエリを入力して" ], "id_hash": -2023684897651416972, "content_hash": -2023684897651416972, "location": "../../en/simple_sql.rst:20", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://weblate.osgeo.org/api/units/99038/?format=api", "priority": 100, "id": 99331, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/ja/?checksum=63ea6d4eba2a2074", "url": "https://weblate.osgeo.org/api/units/99331/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.814141Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "source": [ "and click the **Execute Query** button (the green triangle)." ], "previous_source": "", "target": [ "最後に **Execute Query** ボタン (緑の三角形) をクリックします。" ], "id_hash": -7293482142959842860, "content_hash": -7293482142959842860, "location": "../../en/simple_sql.rst:26", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://weblate.osgeo.org/api/units/99040/?format=api", "priority": 100, "id": 99333, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/ja/?checksum=1ac858a22d3949d4", "url": "https://weblate.osgeo.org/api/units/99333/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.815807Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "source": [ "The query will run for a few (milli)seconds and return the 129 results." ], "previous_source": "", "target": [ "クエリは数秒 (数ミリ秒) 間実行されて、129 件の結果が返ります。" ], "id_hash": 6173238359614649658, "content_hash": 6173238359614649658, "location": "../../en/simple_sql.rst:30", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 8, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://weblate.osgeo.org/api/units/99042/?format=api", "priority": 100, "id": 99334, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/ja/?checksum=d5abbf94b2a5753a", "url": "https://weblate.osgeo.org/api/units/99334/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.817682Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "source": [ "But what exactly happened here? To understand, let's begin with the four \"verbs\" of SQL," ], "previous_source": "", "target": [ "しかし、ここで何が起こったのでしょう? これを理解するために、SQL の四つの「動詞」から始めましょう、" ], "id_hash": -4127000444081064219, "content_hash": -4127000444081064219, "location": "../../en/simple_sql.rst:35", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 9, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://weblate.osgeo.org/api/units/99044/?format=api", "priority": 100, "id": 99335, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/ja/?checksum=46b9f2f63eab36e5", "url": "https://weblate.osgeo.org/api/units/99335/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.819344Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "source": [ "``SELECT``, returns rows in response to a query" ], "previous_source": "", "target": [ "``SELECT``, クエリに応答して行を返します" ], "id_hash": -6660562141957401108, "content_hash": -6660562141957401108, "location": "../../en/simple_sql.rst:37", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 10, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://weblate.osgeo.org/api/units/99046/?format=api", "priority": 100, "id": 99336, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/ja/?checksum=2390ee056436d5ec", "url": "https://weblate.osgeo.org/api/units/99336/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.821030Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "source": [ "``INSERT``, adds new rows to a table" ], "previous_source": "", "target": [ "``INSERT``, 新しい行をテーブルに追加します" ], "id_hash": 9192180302915813808, "content_hash": 9192180302915813808, "location": "../../en/simple_sql.rst:38", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 11, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://weblate.osgeo.org/api/units/99048/?format=api", "priority": 100, "id": 99337, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/ja/?checksum=ff912f4882a3c1b0", "url": "https://weblate.osgeo.org/api/units/99337/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.822638Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "source": [ "``UPDATE``, alters existing rows in a table" ], "previous_source": "", "target": [ "``UPDATE``, テーブルの既存の行に変更を加えます" ], "id_hash": 4219466802024757162, "content_hash": 4219466802024757162, "location": "../../en/simple_sql.rst:39", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 12, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://weblate.osgeo.org/api/units/99050/?format=api", "priority": 100, "id": 99338, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/ja/?checksum=ba8e8eb3643d37aa", "url": "https://weblate.osgeo.org/api/units/99338/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.824389Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "source": [ "``DELETE``, removes rows from a table" ], "previous_source": "", "target": [ "``DELETE``,テーブルから行を削除します" ], "id_hash": -485321283411790201, "content_hash": -485321283411790201, "location": "../../en/simple_sql.rst:40", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 13, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://weblate.osgeo.org/api/units/99052/?format=api", "priority": 100, "id": 99339, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/ja/?checksum=7943cadd344db687", "url": "https://weblate.osgeo.org/api/units/99339/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.826026Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "source": [ "We will be working almost exclusively with ``SELECT`` in order to ask questions of tables using spatial functions." ], "previous_source": "", "target": [ "空間関数を使うテーブルの問合せでは、使うのはほとんど \"SELECT\" だけになります。" ], "id_hash": -7357759092566018791, "content_hash": -7357759092566018791, "location": "../../en/simple_sql.rst:42", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 14, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://weblate.osgeo.org/api/units/99055/?format=api", "priority": 100, "id": 99341, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/ja/?checksum=19e3fd16a0b3b519", "url": "https://weblate.osgeo.org/api/units/99341/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.827858Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "source": [ "SELECT queries" ], "previous_source": "", "target": [ "SELECT クエリ" ], "id_hash": -3824971344125347342, "content_hash": -3824971344125347342, "location": "../../en/simple_sql.rst:45", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 15, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://weblate.osgeo.org/api/units/99057/?format=api", "priority": 100, "id": 99342, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/ja/?checksum=4aeaf8d3fd5c39f2", "url": "https://weblate.osgeo.org/api/units/99342/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.829513Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "source": [ "A select query is generally of the form::" ], "previous_source": "", "target": [ "SELECTクエリは一般的に次の形式になります:" ], "id_hash": 2154556753285362955, "content_hash": 2154556753285362955, "location": "../../en/simple_sql.rst:47", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 16, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://weblate.osgeo.org/api/units/99060/?format=api", "priority": 100, "id": 99343, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/ja/?checksum=9de685f3a7fe350b", "url": "https://weblate.osgeo.org/api/units/99343/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.831101Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "source": [ "For a synopsis of all ``SELECT`` parameters, see the `PostgresSQL documentation <http://www.postgresql.org/docs/current/interactive/sql-select.html>`_." ], "previous_source": "", "target": [ "\"SELECT\" の全てのパラメータの概要については、`PostgresSQL 文書 <https://www.postgresql.jp/document/current/html/sql-select.html>`_ をご覧下さい。" ], "id_hash": -1510787613949988140, "content_hash": -1510787613949988140, "location": "../../en/simple_sql.rst:53", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 17, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://weblate.osgeo.org/api/units/99063/?format=api", "priority": 100, "id": 99344, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/ja/?checksum=6b089aab6b7372d4", "url": "https://weblate.osgeo.org/api/units/99344/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.832757Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "source": [ "The ``some_columns`` are either column names or functions of column values. The ``some_data_source`` is either a single table, or a composite table created by joining two tables on a key or condition. The ``some_condition`` is a filter that restricts the number of rows to be returned." ], "previous_source": "", "target": [ "\"some_columns\" は、カラム名またはカラム値の半数のいずれかです。\"some_data_source\" は、単一のテーブルか、二つのテーブルをキーまたは条件で結合した複合テーブルです。\"some_condition\" は、返される行数を制限するフィルタです。" ], "id_hash": 1653121983106668767, "content_hash": 1653121983106668767, "location": "../../en/simple_sql.rst:55", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 18, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 46, "source_unit": "https://weblate.osgeo.org/api/units/99066/?format=api", "priority": 100, "id": 99345, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/ja/?checksum=96f111af5d7658df", "url": "https://weblate.osgeo.org/api/units/99345/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.834496Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "source": [ "\"What are the names of all the neighborhoods in Brooklyn?\"" ], "previous_source": "", "target": [ "「ブルックリンの全ての地区の名前を知りたい」" ], "id_hash": 6187990933837514987, "content_hash": 6187990933837514987, "location": "../../en/simple_sql.rst:57", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 19, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://weblate.osgeo.org/api/units/99069/?format=api", "priority": 100, "id": 99346, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/ja/?checksum=d5e028f80cb908eb", "url": "https://weblate.osgeo.org/api/units/99346/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.836193Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "source": [ "We return to our ``nyc_neighborhoods`` table with a filter in hand. The table contains all the neighborhoods in New York, but we only want the ones in Brooklyn." ], "previous_source": "", "target": [ "``nyc_neighborhoods`` テーブルに話を戻します。テーブルはニューヨーク市の全ての地区を持っていますが、ブルックリン内の地区だけを求めています。" ], "id_hash": -943566596679662443, "content_hash": -943566596679662443, "location": "../../en/simple_sql.rst:59", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 20, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://weblate.osgeo.org/api/units/99072/?format=api", "priority": 100, "id": 99348, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/ja/?checksum=72e7c72df6fc0495", "url": "https://weblate.osgeo.org/api/units/99348/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.837894Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "source": [ "The query will run for even fewer (milli)seconds and return the 23 results." ], "previous_source": "", "target": [ "クエリは、さらに短く、数秒 (数ミリ秒) で終わり、23件の結果を返します。" ], "id_hash": -1483977016853120188, "content_hash": -1483977016853120188, "location": "../../en/simple_sql.rst:67", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 21, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://weblate.osgeo.org/api/units/99074/?format=api", "priority": 100, "id": 99349, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/ja/?checksum=6b67dac3ffa03b44", "url": "https://weblate.osgeo.org/api/units/99349/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.839578Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "source": [ "Sometimes we will need to apply a function to the results of our query. For example," ], "previous_source": "", "target": [ "時々、関数をクエリの結果に適用する必要があります。例を挙げます、" ], "id_hash": -8830976247187079690, "content_hash": -8830976247187079690, "location": "../../en/simple_sql.rst:69", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 22, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://weblate.osgeo.org/api/units/99076/?format=api", "priority": 100, "id": 99350, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/ja/?checksum=057211e446807df6", "url": "https://weblate.osgeo.org/api/units/99350/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.841261Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "source": [ "\"What is the number of letters in the names of all the neighborhoods in Brooklyn?\"" ], "previous_source": "", "target": [ "「ブルックリンの全ての地区の名前の文字数を知りたい」" ], "id_hash": 197458882924291075, "content_hash": 197458882924291075, "location": "../../en/simple_sql.rst:71", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 23, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://weblate.osgeo.org/api/units/99078/?format=api", "priority": 100, "id": 99351, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/ja/?checksum=82bd83cece72a403", "url": "https://weblate.osgeo.org/api/units/99351/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.843189Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "source": [ "Fortunately, PostgreSQL has a string length function, :command:`char_length(string)`." ], "previous_source": "", "target": [ "幸運なことに、PostgreSQL には、文字列長を得る :command:`char_length(string)`. という関数があります。" ], "id_hash": 8605128158431623754, "content_hash": 8605128158431623754, "location": "../../en/simple_sql.rst:73", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 24, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://weblate.osgeo.org/api/units/99081/?format=api", "priority": 100, "id": 99352, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/ja/?checksum=f76b8e77da073a4a", "url": "https://weblate.osgeo.org/api/units/99352/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.844805Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "source": [ "Often, we are less interested in the individual rows than in a statistic that applies to all of them. So knowing the lengths of the neighborhood names might be less interesting than knowing the average length of the names. Functions that take in multiple rows and return a single result are called \"aggregate\" functions." ], "previous_source": "", "target": [ "私たちはしばしば、結果の個々の行よりも、全体の統計値の方に興味を持ちます。ここで、地区ごとの名前の長さを知ることより、地区名の長さの平均値の方に興味を持っているとします。ここで使う関数は複数の行を引数に取り、単一の結果を返すもので、「集約」関数と呼ばれます。" ], "id_hash": -1600117973108927706, "content_hash": -1600117973108927706, "location": "../../en/simple_sql.rst:81", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 25, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 54, "source_unit": "https://weblate.osgeo.org/api/units/99083/?format=api", "priority": 100, "id": 99353, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/ja/?checksum=69cb3d2e661fd326", "url": "https://weblate.osgeo.org/api/units/99353/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.846616Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "source": [ "PostgreSQL has a series of built-in aggregate functions, including the general purpose :command:`avg()` for average values and :command:`stddev()` for standard deviations." ], "previous_source": "", "target": [ "PostgrSQL は、平均値を求める :command:`avg()` や、標準偏差を求める :command:`stddev()` などといった汎用的な一連の組込集約関数を持っています。" ], "id_hash": 3994244424292428431, "content_hash": 3994244424292428431, "location": "../../en/simple_sql.rst:83", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 26, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://weblate.osgeo.org/api/units/99086/?format=api", "priority": 100, "id": 99354, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/ja/?checksum=b76e68243808ea8f", "url": "https://weblate.osgeo.org/api/units/99354/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.848311Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "source": [ "\"What is the average number of letters and standard deviation of number of letters in the names of all the neighborhoods in Brooklyn?\"" ], "previous_source": "", "target": [ "「ブルックリンの全地区の名前の文字数の平均値と標準偏差を知りたい」" ], "id_hash": 5702891689831228540, "content_hash": 5702891689831228540, "location": "../../en/simple_sql.rst:85", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 27, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://weblate.osgeo.org/api/units/99089/?format=api", "priority": 100, "id": 99355, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/ja/?checksum=cf24bdc6d4eae47c", "url": "https://weblate.osgeo.org/api/units/99355/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.850048Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "source": [ "The aggregate functions in our last example were applied to every row in the result set. What if we want the summaries to be carried out over smaller groups within the overall result set? For that we add a ``GROUP BY`` clause. Aggregate functions often need an added ``GROUP BY`` statement to group the result-set by one or more columns." ], "previous_source": "", "target": [ "最後の例での集約関数は、結果集合の全ての行に適用されました。もし結果集合全体をより小さなグループにして集計を実行したい場合には、どうするでしょうか。その場合には、\"GROUP BY\"句 を追加します。集約関数はしばしば、1以上のカラムによる結果セットのグループ化のために \"GROUP BY\"句 を追加しなければなりません。" ], "id_hash": 2393826065730826252, "content_hash": 2393826065730826252, "location": "../../en/simple_sql.rst:99", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 28, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 60, "source_unit": "https://weblate.osgeo.org/api/units/99092/?format=api", "priority": 100, "id": 99357, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/ja/?checksum=a138941fadf4f00c", "url": "https://weblate.osgeo.org/api/units/99357/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.851789Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "source": [ "\"What is the average number of letters in the names of all the neighborhoods in New York City, reported by borough?\"" ], "previous_source": "", "target": [ "「ニューヨーク市の、行政区ごとの地区の名前の文字数の平均値を知りたい」" ], "id_hash": -4676956579218002815, "content_hash": -4676956579218002815, "location": "../../en/simple_sql.rst:101", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 29, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://weblate.osgeo.org/api/units/99095/?format=api", "priority": 100, "id": 99358, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/ja/?checksum=3f181cc551c8ec81", "url": "https://weblate.osgeo.org/api/units/99358/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.853664Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "source": [ "We include the ``boroname`` column in the output result so we can determine which statistic applies to which borough. In an aggregate query, you can only output columns that are either (a) members of the grouping clause or (b) aggregate functions." ], "previous_source": "", "target": [ "出力結果に \"boroname\" (行政区名) カラムが含まれているので、どの統計がどの行政区に適用されるかの判断ができます。集約クエリでは、(a) グループ句のメンバーか、または (b) 集約関数かのカラムだけを出力できます。" ], "id_hash": 4597163752082972764, "content_hash": 4597163752082972764, "location": "../../en/simple_sql.rst:109", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 30, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://weblate.osgeo.org/api/units/99099/?format=api", "priority": 100, "id": 99359, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/ja/?checksum=bfcc68136135205c", "url": "https://weblate.osgeo.org/api/units/99359/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.855355Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "source": [ "Function List" ], "previous_source": "", "target": [ "関数リスト" ], "id_hash": 2815949782297668712, "content_hash": 2815949782297668712, "location": "../../en/simple_sql.rst:122", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 31, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://weblate.osgeo.org/api/units/99103/?format=api", "priority": 100, "id": 99360, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/ja/?checksum=a71443684f30ec68", "url": "https://weblate.osgeo.org/api/units/99360/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.857061Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "source": [ "`avg(expression) <http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: PostgreSQL aggregate function that returns the average value of a numeric column." ], "previous_source": "", "target": [ "`avg(expression) <https://www.postgresql.jp/document/current/html/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: 数値カラムの値の平均を返す PostgreSQL 集約関数。" ], "id_hash": -5033877154090146436, "content_hash": -5033877154090146436, "location": "../../en/simple_sql.rst:124", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 32, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://weblate.osgeo.org/api/units/99107/?format=api", "priority": 100, "id": 99361, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/ja/?checksum=3a2413662380a57c", "url": "https://weblate.osgeo.org/api/units/99361/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.858715Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "source": [ "`char_length(string) <http://www.postgresql.org/docs/current/static/functions-string.html>`_: PostgreSQL string function that returns the number of character in a string." ], "previous_source": "", "target": [ "`char_length(string) <https://www.postgresql.jp/document/current/html/functions-string.html>`_: 文字列の文字数を返すPostgreSQL 文字列関数。" ], "id_hash": -5151420096834902630, "content_hash": -5151420096834902630, "location": "../../en/simple_sql.rst:126", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 33, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://weblate.osgeo.org/api/units/99110/?format=api", "priority": 100, "id": 99363, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/ja/?checksum=38827ab71f58e59a", "url": "https://weblate.osgeo.org/api/units/99363/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.860566Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/ja/?format=api", "source": [ "`stddev(expression) <http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-STATISTICS-TABLE>`_: PostgreSQL aggregate function that returns the standard deviation of input values." ], "previous_source": "", "target": [ "`avg(expression) <https://www.postgresql.jp/document/current/html/functions-aggregate.html#FUNCTIONS-AGGREGATE-STATISTICS-TABLE>`_: 入力値の標準偏差を返す PostgreSQL 集約関数。" ], "id_hash": -7822121017709672541, "content_hash": -7822121017709672541, "location": "../../en/simple_sql.rst:128", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 34, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://weblate.osgeo.org/api/units/99113/?format=api", "priority": 100, "id": 99364, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/ja/?checksum=13723e60b54c47a3", "url": "https://weblate.osgeo.org/api/units/99364/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:41.862320Z" } ] }