Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/postgis-workshop/joins_exercises/en/units/?format=api
{ "count": 29, "next": null, "previous": null, "results": [ { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/en/?format=api", "source": [ "Spatial Joins Exercises" ], "previous_source": "", "target": [ "Spatial Joins Exercises" ], "id_hash": 8766519822627832265, "content_hash": 8766519822627832265, "location": "../../en/joins_exercises.rst:4", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "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": 102592, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/en/?checksum=f9a8ef54e82701c9", "url": "https://weblate.osgeo.org/api/units/102592/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:52.488334Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/en/?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": [ "Here's a reminder of some of the functions we have seen. Hint: they should be useful for the exercises!" ], "id_hash": -909720833227067697, "content_hash": -909720833227067697, "location": "../../en/joins_exercises.rst:6", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "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": 102596, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/en/?checksum=736005b8daba6ecf", "url": "https://weblate.osgeo.org/api/units/102596/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:52.519317Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/en/?format=api", "source": [ ":command:`sum(expression)`: aggregate to return a sum for a set of records" ], "previous_source": "", "target": [ ":command:`sum(expression)`: aggregate to return a sum for a set of records" ], "id_hash": -2242501564706137077, "content_hash": -2242501564706137077, "location": "../../en/joins_exercises.rst:8", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "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": 102599, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/en/?checksum=60e108b54b6edc0b", "url": "https://weblate.osgeo.org/api/units/102599/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:52.541490Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/en/?format=api", "source": [ ":command:`count(expression)`: aggregate to return the size of a set of records" ], "previous_source": "", "target": [ ":command:`count(expression)`: aggregate to return the size of a set of records" ], "id_hash": 5619356840860995366, "content_hash": 5619356840860995366, "location": "../../en/joins_exercises.rst:9", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "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": 102601, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/en/?checksum=cdfbf7462dae4f26", "url": "https://weblate.osgeo.org/api/units/102601/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:52.563632Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/en/?format=api", "source": [ ":command:`ST_Area(geometry)` returns the area of the polygons" ], "previous_source": "", "target": [ ":command:`ST_Area(geometry)` returns the area of the polygons" ], "id_hash": 4769711107713515951, "content_hash": 4769711107713515951, "location": "../../en/joins_exercises.rst:10", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "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": 102604, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/en/?checksum=c2316afb407fc1af", "url": "https://weblate.osgeo.org/api/units/102604/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:52.585702Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/en/?format=api", "source": [ ":command:`ST_AsText(geometry)` returns WKT ``text``" ], "previous_source": "", "target": [ ":command:`ST_AsText(geometry)` returns WKT ``text``" ], "id_hash": 4195690895016880771, "content_hash": 4195690895016880771, "location": "../../en/joins_exercises.rst:11", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "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": 102607, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/en/?checksum=ba3a16a3a8d26a83", "url": "https://weblate.osgeo.org/api/units/102607/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:52.607750Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/en/?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)` returns the true if geometry A contains geometry B" ], "id_hash": 3653086772417313220, "content_hash": 3653086772417313220, "location": "../../en/joins_exercises.rst:12", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "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": 102610, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/en/?checksum=b2b25f108b9cb9c4", "url": "https://weblate.osgeo.org/api/units/102610/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:52.629783Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/en/?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)` returns the minimum distance between geometry A and geometry B" ], "id_hash": 7087089013872496991, "content_hash": 7087089013872496991, "location": "../../en/joins_exercises.rst:13", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "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": 102613, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/en/?checksum=e25a65e8bb71915f", "url": "https://weblate.osgeo.org/api/units/102613/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:52.651599Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/en/?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)` returns the true if geometry A is radius distance or less from geometry B" ], "id_hash": -6931634306698326142, "content_hash": -6931634306698326142, "location": "../../en/joins_exercises.rst:14", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "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": 102616, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/en/?checksum=1fcde352cc55cf82", "url": "https://weblate.osgeo.org/api/units/102616/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:52.673224Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/en/?format=api", "source": [ ":command:`ST_GeomFromText(text)` returns ``geometry``" ], "previous_source": "", "target": [ ":command:`ST_GeomFromText(text)` returns ``geometry``" ], "id_hash": -5254946734501622109, "content_hash": -5254946734501622109, "location": "../../en/joins_exercises.rst:15", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "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": 102619, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/en/?checksum=3712adc9706e8ea3", "url": "https://weblate.osgeo.org/api/units/102619/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:52.695066Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/en/?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)` returns the true if geometry A intersects geometry B" ], "id_hash": -3183266962236771336, "content_hash": -3183266962236771336, "location": "../../en/joins_exercises.rst:16", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "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": 102627, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/en/?checksum=53d2c39042a3f3f8", "url": "https://weblate.osgeo.org/api/units/102627/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:52.716711Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/en/?format=api", "source": [ ":command:`ST_Length(linestring)` returns the length of the linestring" ], "previous_source": "", "target": [ ":command:`ST_Length(linestring)` returns the length of the linestring" ], "id_hash": -8541996009102286529, "content_hash": -8541996009102286529, "location": "../../en/joins_exercises.rst:17", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "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": 102637, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/en/?checksum=0974bbe31ca7613f", "url": "https://weblate.osgeo.org/api/units/102637/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:52.738741Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/en/?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)` returns the true if the boundary of geometry A touches geometry B" ], "id_hash": -8419174106411189223, "content_hash": -8419174106411189223, "location": "../../en/joins_exercises.rst:18", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "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": 102640, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/en/?checksum=0b2915c1c531bc19", "url": "https://weblate.osgeo.org/api/units/102640/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:52.760603Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/en/?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)` returns the true if geometry A is within geometry B" ], "id_hash": 7630096418786976153, "content_hash": 7630096418786976153, "location": "../../en/joins_exercises.rst:19", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "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": 102642, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/en/?checksum=e9e38c4453c72199", "url": "https://weblate.osgeo.org/api/units/102642/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:52.782023Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/en/?format=api", "source": [ "Also remember the tables we have available:" ], "previous_source": "", "target": [ "Also remember the tables we have available:" ], "id_hash": 2887433863364510331, "content_hash": 2887433863364510331, "location": "../../en/joins_exercises.rst:21", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "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": 102645, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/en/?checksum=a81239ccea46827b", "url": "https://weblate.osgeo.org/api/units/102645/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:52.803973Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/en/?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": 100, "fuzzy": false, "translated": true, "approved": false, "position": 16, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/102648/?format=api", "priority": 100, "id": 102648, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/en/?checksum=5605089edad0a364", "url": "https://weblate.osgeo.org/api/units/102648/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:52.825643Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/en/?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": 100, "fuzzy": false, "translated": true, "approved": false, "position": 17, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 4, "source_unit": "https://weblate.osgeo.org/api/units/102650/?format=api", "priority": 100, "id": 102650, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/en/?checksum=24c3310dca6a7519", "url": "https://weblate.osgeo.org/api/units/102650/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:52.847299Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/en/?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": 100, "fuzzy": false, "translated": true, "approved": false, "position": 18, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/102652/?format=api", "priority": 100, "id": 102652, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/en/?checksum=a4366cb99575a3fd", "url": "https://weblate.osgeo.org/api/units/102652/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:52.870419Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/en/?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": 100, "fuzzy": false, "translated": true, "approved": false, "position": 19, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 3, "source_unit": "https://weblate.osgeo.org/api/units/102654/?format=api", "priority": 100, "id": 102654, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/en/?checksum=dba82ab20b760570", "url": "https://weblate.osgeo.org/api/units/102654/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:52.893479Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/en/?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": 100, "fuzzy": false, "translated": true, "approved": false, "position": 20, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/102656/?format=api", "priority": 100, "id": 102656, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/en/?checksum=dcb0faabba77d1c7", "url": "https://weblate.osgeo.org/api/units/102656/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:52.915159Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/en/?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": 100, "fuzzy": false, "translated": true, "approved": false, "position": 21, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 3, "source_unit": "https://weblate.osgeo.org/api/units/102658/?format=api", "priority": 100, "id": 102658, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/en/?checksum=97cb05539ac98cb3", "url": "https://weblate.osgeo.org/api/units/102658/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:52.937271Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/en/?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": 100, "fuzzy": false, "translated": true, "approved": false, "position": 22, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/102660/?format=api", "priority": 100, "id": 102660, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/en/?checksum=e9e8b499fc72451a", "url": "https://weblate.osgeo.org/api/units/102660/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:52.959475Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/en/?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": 100, "fuzzy": false, "translated": true, "approved": false, "position": 23, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 3, "source_unit": "https://weblate.osgeo.org/api/units/102674/?format=api", "priority": 100, "id": 102674, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/en/?checksum=834931c9e7c878dc", "url": "https://weblate.osgeo.org/api/units/102674/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:52.981538Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/en/?format=api", "source": [ "Exercises" ], "previous_source": "", "target": [ "Exercises" ], "id_hash": -7091084141687761545, "content_hash": -7091084141687761545, "location": "../../en/joins_exercises.rst:40", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "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": 102676, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/en/?checksum=1d97688b164b9577", "url": "https://weblate.osgeo.org/api/units/102676/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:53.003820Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/en/?format=api", "source": [ "**What subway station is in 'Little Italy'? What subway route is it on?**" ], "previous_source": "", "target": [ "**What subway station is in 'Little Italy'? What subway route is it on?**" ], "id_hash": -7289444008014798345, "content_hash": -7289444008014798345, "location": "../../en/joins_exercises.rst:42", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "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": 102678, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/en/?checksum=1ad6b14bbc2da1f7", "url": "https://weblate.osgeo.org/api/units/102678/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:53.025980Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/en/?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": [ "**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')" ], "id_hash": 5097887020946561371, "content_hash": 5097887020946561371, "location": "../../en/joins_exercises.rst:58", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "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": 102680, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/en/?checksum=c6bf553c5c98195b", "url": "https://weblate.osgeo.org/api/units/102680/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:53.048647Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/en/?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": [ "We used the ``DISTINCT`` keyword to remove duplicate values from our result set where there were more than one subway station in a neighborhood." ], "id_hash": -2978355995316057361, "content_hash": -2978355995316057361, "location": "../../en/joins_exercises.rst:90", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "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": 102682, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/en/?checksum=56aac10094880aef", "url": "https://weblate.osgeo.org/api/units/102682/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:53.072247Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/en/?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": [ "**After 9/11, the 'Battery Park' neighborhood was off limits for several days. How many people had to be evacuated?**" ], "id_hash": -2261390803127803774, "content_hash": -2261390803127803774, "location": "../../en/joins_exercises.rst:92", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "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": 102684, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/en/?checksum=609ded0bc13b6082", "url": "https://weblate.osgeo.org/api/units/102684/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:53.094445Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/en/?format=api", "source": [ "**What neighborhood has the highest population density (persons/km2)?**" ], "previous_source": "", "target": [ "**What neighborhood has the highest population density (persons/km2)?**" ], "id_hash": -4825349443184984293, "content_hash": -4825349443184984293, "location": "../../en/joins_exercises.rst:106", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "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": 102694, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_exercises/en/?checksum=3d08ea3f49d47f1b", "url": "https://weblate.osgeo.org/api/units/102694/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:53.117481Z" } ] }