Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/postgis-workshop/joins_exercises/ja/units/?format=api
{ "count": 29, "next": null, "previous": null, "results": [ { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "source": [ "Spatial Joins Exercises" ], "previous_source": "", "target": [ "空間結合の演習" ], "id_hash": 8766519822627832265, "content_hash": 8766519822627832265, "location": "../../en/joins_exercises.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": 3, "source_unit": "https://weblate.osgeo.org/api/units/102592/?format=api", "priority": 100, "id": 102975, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/ja/?checksum=f9a8ef54e82701c9", "url": "https://weblate.osgeo.org/api/units/102975/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:53.727604Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "source": [ "Here's a reminder of some of the functions we have seen. Hint: they should be useful for the exercises!" ], "previous_source": "", "target": [ "これまでに見た全ての関数のリマインダです。演習に役立つはずです!" ], "id_hash": -909720833227067697, "content_hash": -909720833227067697, "location": "../../en/joins_exercises.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": 19, "source_unit": "https://weblate.osgeo.org/api/units/102596/?format=api", "priority": 100, "id": 102976, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/ja/?checksum=736005b8daba6ecf", "url": "https://weblate.osgeo.org/api/units/102976/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:53.729287Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "source": [ ":command:`sum(expression)`: aggregate to return a sum for a set of records" ], "previous_source": "", "target": [ ":command:`sum(expression)`: レコードの集合の合計を返す集約関数" ], "id_hash": -2242501564706137077, "content_hash": -2242501564706137077, "location": "../../en/joins_exercises.rst:8", "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": 11, "source_unit": "https://weblate.osgeo.org/api/units/102599/?format=api", "priority": 100, "id": 102978, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/ja/?checksum=60e108b54b6edc0b", "url": "https://weblate.osgeo.org/api/units/102978/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:53.730796Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "source": [ ":command:`count(expression)`: aggregate to return the size of a set of records" ], "previous_source": "", "target": [ ":command:`count(expression)` はレコードの集合のサイズを返す集約関数です" ], "id_hash": 5619356840860995366, "content_hash": 5619356840860995366, "location": "../../en/joins_exercises.rst:9", "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": 11, "source_unit": "https://weblate.osgeo.org/api/units/102601/?format=api", "priority": 100, "id": 102979, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/ja/?checksum=cdfbf7462dae4f26", "url": "https://weblate.osgeo.org/api/units/102979/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:53.732277Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "source": [ ":command:`ST_Area(geometry)` returns the area of the polygons" ], "previous_source": "", "target": [ ":command:`ST_Area(geometry)` ポリゴンの面積を返します" ], "id_hash": 4769711107713515951, "content_hash": 4769711107713515951, "location": "../../en/joins_exercises.rst:10", "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": 7, "source_unit": "https://weblate.osgeo.org/api/units/102604/?format=api", "priority": 100, "id": 102980, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/ja/?checksum=c2316afb407fc1af", "url": "https://weblate.osgeo.org/api/units/102980/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:53.733729Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "source": [ ":command:`ST_AsText(geometry)` returns WKT ``text``" ], "previous_source": "", "target": [ ":command:`ST_AsText(geometry)` は WKT ``text`` を返します" ], "id_hash": 4195690895016880771, "content_hash": 4195690895016880771, "location": "../../en/joins_exercises.rst:11", "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": 4, "source_unit": "https://weblate.osgeo.org/api/units/102607/?format=api", "priority": 100, "id": 102981, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/ja/?checksum=ba3a16a3a8d26a83", "url": "https://weblate.osgeo.org/api/units/102981/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:53.735277Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "source": [ ":command:`ST_Contains(geometry A, geometry B)` returns the true if geometry A contains geometry B" ], "previous_source": "", "target": [ ":command:`ST_Contains(geometry A, geometry B)` ジオメトリAがジオメトリBを含む場合には TRUE を返します" ], "id_hash": 3653086772417313220, "content_hash": 3653086772417313220, "location": "../../en/joins_exercises.rst:12", "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": 13, "source_unit": "https://weblate.osgeo.org/api/units/102610/?format=api", "priority": 100, "id": 102983, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/ja/?checksum=b2b25f108b9cb9c4", "url": "https://weblate.osgeo.org/api/units/102983/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:53.736744Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "source": [ ":command:`ST_Distance(geometry A, geometry B)` returns the minimum distance between geometry A and geometry B" ], "previous_source": "", "target": [ ":command:`ST_Distance(geometry A, geometry B)` ジオメトリAとジオメトリBの距離の最小値を返します" ], "id_hash": 7087089013872496991, "content_hash": 7087089013872496991, "location": "../../en/joins_exercises.rst:13", "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": 14, "source_unit": "https://weblate.osgeo.org/api/units/102613/?format=api", "priority": 100, "id": 102984, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/ja/?checksum=e25a65e8bb71915f", "url": "https://weblate.osgeo.org/api/units/102984/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:53.738233Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "source": [ ":command:`ST_DWithin(geometry A, geometry B, radius)` returns the true if geometry A is radius distance or less from geometry B" ], "previous_source": "", "target": [ ":command:`ST_DWithin(geometry A, geometry B, radius)` ジオメトリAがジオメトリBからの距離が radius 未満の場合には TRUE を返します" ], "id_hash": -6931634306698326142, "content_hash": -6931634306698326142, "location": "../../en/joins_exercises.rst:14", "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": 19, "source_unit": "https://weblate.osgeo.org/api/units/102616/?format=api", "priority": 100, "id": 102985, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/ja/?checksum=1fcde352cc55cf82", "url": "https://weblate.osgeo.org/api/units/102985/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:53.739728Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "source": [ ":command:`ST_GeomFromText(text)` returns ``geometry``" ], "previous_source": "", "target": [ ":command:`ST_GeomFromText(text)` は ``geometry`` を返します" ], "id_hash": -5254946734501622109, "content_hash": -5254946734501622109, "location": "../../en/joins_exercises.rst:15", "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": 3, "source_unit": "https://weblate.osgeo.org/api/units/102619/?format=api", "priority": 100, "id": 102986, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/ja/?checksum=3712adc9706e8ea3", "url": "https://weblate.osgeo.org/api/units/102986/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:53.741231Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "source": [ ":command:`ST_Intersects(geometry A, geometry B)` returns the true if geometry A intersects geometry B" ], "previous_source": "", "target": [ ":command:`ST_Intersects(geometry A, geometry B)` ジオメトリAがジオメトリBとインタセクトする場合には TRUE を返します" ], "id_hash": -3183266962236771336, "content_hash": -3183266962236771336, "location": "../../en/joins_exercises.rst:16", "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": 13, "source_unit": "https://weblate.osgeo.org/api/units/102627/?format=api", "priority": 100, "id": 102987, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/ja/?checksum=53d2c39042a3f3f8", "url": "https://weblate.osgeo.org/api/units/102987/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:53.742754Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "source": [ ":command:`ST_Length(linestring)` returns the length of the linestring" ], "previous_source": "", "target": [ ":command:`ST_Length(linestring)` はラインストリングの長さを返します" ], "id_hash": -8541996009102286529, "content_hash": -8541996009102286529, "location": "../../en/joins_exercises.rst:17", "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/102637/?format=api", "priority": 100, "id": 102988, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/ja/?checksum=0974bbe31ca7613f", "url": "https://weblate.osgeo.org/api/units/102988/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:53.744393Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "source": [ ":command:`ST_Touches(geometry A, geometry B)` returns the true if the boundary of geometry A touches geometry B" ], "previous_source": "", "target": [ ":command:`ST_Touches(geometry A, geometry B)` ジオメトリAがジオメトリBと接触する場合には TRUE を返します" ], "id_hash": -8419174106411189223, "content_hash": -8419174106411189223, "location": "../../en/joins_exercises.rst:18", "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": 16, "source_unit": "https://weblate.osgeo.org/api/units/102640/?format=api", "priority": 100, "id": 102989, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/ja/?checksum=0b2915c1c531bc19", "url": "https://weblate.osgeo.org/api/units/102989/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:53.745923Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "source": [ ":command:`ST_Within(geometry A, geometry B)` returns the true if geometry A is within geometry B" ], "previous_source": "", "target": [ ":command:`ST_Within(geometry A, geometry B)` ジオメトリAがジオメトリBの内側にある場合には TRUE を返します" ], "id_hash": 7630096418786976153, "content_hash": 7630096418786976153, "location": "../../en/joins_exercises.rst:19", "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": 14, "source_unit": "https://weblate.osgeo.org/api/units/102642/?format=api", "priority": 100, "id": 102990, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/ja/?checksum=e9e38c4453c72199", "url": "https://weblate.osgeo.org/api/units/102990/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:53.747462Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "source": [ "Also remember the tables we have available:" ], "previous_source": "", "target": [ "次の利用可能なテーブルも覚えておいてください:" ], "id_hash": 2887433863364510331, "content_hash": 2887433863364510331, "location": "../../en/joins_exercises.rst:21", "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": 7, "source_unit": "https://weblate.osgeo.org/api/units/102645/?format=api", "priority": 100, "id": 102991, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/ja/?checksum=a81239ccea46827b", "url": "https://weblate.osgeo.org/api/units/102991/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:53.748968Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "source": [ "``nyc_census_blocks``" ], "previous_source": "", "target": [ "``nyc_census_blocks``" ], "id_hash": -3025002096340458652, "content_hash": -3025002096340458652, "location": "../../en/joins_exercises.rst:23", "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": 1, "source_unit": "https://weblate.osgeo.org/api/units/102648/?format=api", "priority": 100, "id": 102992, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/ja/?checksum=5605089edad0a364", "url": "https://weblate.osgeo.org/api/units/102992/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:53.750529Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "source": [ "name, popn_total, boroname, geom" ], "previous_source": "", "target": [ "name, popn_total, boroname, geom" ], "id_hash": -6574357095730481895, "content_hash": -6574357095730481895, "location": "../../en/joins_exercises.rst:25", "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": 4, "source_unit": "https://weblate.osgeo.org/api/units/102650/?format=api", "priority": 100, "id": 102993, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/ja/?checksum=24c3310dca6a7519", "url": "https://weblate.osgeo.org/api/units/102993/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:53.752014Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "source": [ "``nyc_streets``" ], "previous_source": "", "target": [ "``nyc_streets``" ], "id_hash": 2609392578440045565, "content_hash": 2609392578440045565, "location": "../../en/joins_exercises.rst:27", "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": 1, "source_unit": "https://weblate.osgeo.org/api/units/102652/?format=api", "priority": 100, "id": 102995, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/ja/?checksum=a4366cb99575a3fd", "url": "https://weblate.osgeo.org/api/units/102995/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:53.753495Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "source": [ "name, type, geom" ], "previous_source": "", "target": [ "name, type, geom" ], "id_hash": 6604575797723661680, "content_hash": 6604575797723661680, "location": "../../en/joins_exercises.rst:29", "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": 3, "source_unit": "https://weblate.osgeo.org/api/units/102654/?format=api", "priority": 100, "id": 102996, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/ja/?checksum=dba82ab20b760570", "url": "https://weblate.osgeo.org/api/units/102996/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:53.754993Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "source": [ "``nyc_subway_stations``" ], "previous_source": "", "target": [ "``nyc_subway_stations``" ], "id_hash": 6679113862865211847, "content_hash": 6679113862865211847, "location": "../../en/joins_exercises.rst:31", "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": 1, "source_unit": "https://weblate.osgeo.org/api/units/102656/?format=api", "priority": 100, "id": 102997, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/ja/?checksum=dcb0faabba77d1c7", "url": "https://weblate.osgeo.org/api/units/102997/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:53.756478Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "source": [ "name, routes, geom" ], "previous_source": "", "target": [ "name, routes, geom" ], "id_hash": 1714469939781930163, "content_hash": 1714469939781930163, "location": "../../en/joins_exercises.rst:33", "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": 3, "source_unit": "https://weblate.osgeo.org/api/units/102658/?format=api", "priority": 100, "id": 102998, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/ja/?checksum=97cb05539ac98cb3", "url": "https://weblate.osgeo.org/api/units/102998/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:53.757958Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "source": [ "``nyc_neighborhoods``" ], "previous_source": "", "target": [ "``nyc_neighborhoods``" ], "id_hash": 7631548142037648666, "content_hash": 7631548142037648666, "location": "../../en/joins_exercises.rst:35", "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": 1, "source_unit": "https://weblate.osgeo.org/api/units/102660/?format=api", "priority": 100, "id": 102999, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/ja/?checksum=e9e8b499fc72451a", "url": "https://weblate.osgeo.org/api/units/102999/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:53.759465Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "source": [ "name, boroname, geom" ], "previous_source": "", "target": [ "name, boroname, geom" ], "id_hash": 236775198660524252, "content_hash": 236775198660524252, "location": "../../en/joins_exercises.rst:37", "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": 3, "source_unit": "https://weblate.osgeo.org/api/units/102674/?format=api", "priority": 100, "id": 103001, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/ja/?checksum=834931c9e7c878dc", "url": "https://weblate.osgeo.org/api/units/103001/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:53.761252Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "source": [ "Exercises" ], "previous_source": "", "target": [ "演習" ], "id_hash": -7091084141687761545, "content_hash": -7091084141687761545, "location": "../../en/joins_exercises.rst:40", "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": 1, "source_unit": "https://weblate.osgeo.org/api/units/102676/?format=api", "priority": 100, "id": 103002, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/ja/?checksum=1d97688b164b9577", "url": "https://weblate.osgeo.org/api/units/103002/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:53.762860Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "source": [ "**What subway station is in 'Little Italy'? What subway route is it on?**" ], "previous_source": "", "target": [ "**'Little Italy'内にある地下鉄駅はどれでしょう? どの地下鉄路線にありますか?**" ], "id_hash": -7289444008014798345, "content_hash": -7289444008014798345, "location": "../../en/joins_exercises.rst:42", "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": 13, "source_unit": "https://weblate.osgeo.org/api/units/102678/?format=api", "priority": 100, "id": 103003, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/ja/?checksum=1ad6b14bbc2da1f7", "url": "https://weblate.osgeo.org/api/units/103003/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:53.764325Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "source": [ "**What are all the neighborhoods served by the 6-train?** (Hint: The ``routes`` column in the ``nyc_subway_stations`` table has values like 'B,D,6,V' and 'C,6')" ], "previous_source": "", "target": [ "**6列車が通る地区を全てを挙げるとどうなるでしょう?** (ヒント: ``nyc_subway_stations``テーブルの ``routes`` カラムは 'B,D,6,V' や 'C,6' のような値を持ちます)" ], "id_hash": 5097887020946561371, "content_hash": 5097887020946561371, "location": "../../en/joins_exercises.rst:58", "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": 23, "source_unit": "https://weblate.osgeo.org/api/units/102680/?format=api", "priority": 100, "id": 103004, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/ja/?checksum=c6bf553c5c98195b", "url": "https://weblate.osgeo.org/api/units/103004/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:53.765828Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "source": [ "We used the ``DISTINCT`` keyword to remove duplicate values from our result set where there were more than one subway station in a neighborhood." ], "previous_source": "", "target": [ "一つの地区に複数の地下鉄駅がある時に、結果集合から重複値を削除するには ``DISTINCT`` キーワードを使います。" ], "id_hash": -2978355995316057361, "content_hash": -2978355995316057361, "location": "../../en/joins_exercises.rst:90", "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": 24, "source_unit": "https://weblate.osgeo.org/api/units/102682/?format=api", "priority": 100, "id": 103005, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/ja/?checksum=56aac10094880aef", "url": "https://weblate.osgeo.org/api/units/103005/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:53.767387Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "source": [ "**After 9/11, the 'Battery Park' neighborhood was off limits for several days. How many people had to be evacuated?**" ], "previous_source": "", "target": [ "**9/11後、'Battery Park' 地区は数日間立ち入り禁止でした。避難しなけれならなかった人の数はどれぐらいでしょうか?**" ], "id_hash": -2261390803127803774, "content_hash": -2261390803127803774, "location": "../../en/joins_exercises.rst:92", "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": 19, "source_unit": "https://weblate.osgeo.org/api/units/102684/?format=api", "priority": 100, "id": 103006, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/ja/?checksum=609ded0bc13b6082", "url": "https://weblate.osgeo.org/api/units/103006/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:53.768966Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/ja/?format=api", "source": [ "**What neighborhood has the highest population density (persons/km2)?**" ], "previous_source": "", "target": [ "**最も人口密度 (人/km2) が高い地区はどこですか?**" ], "id_hash": -4825349443184984293, "content_hash": -4825349443184984293, "location": "../../en/joins_exercises.rst:106", "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": 8, "source_unit": "https://weblate.osgeo.org/api/units/102694/?format=api", "priority": 100, "id": 103007, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/ja/?checksum=3d08ea3f49d47f1b", "url": "https://weblate.osgeo.org/api/units/103007/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:53.770734Z" } ] }