Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/postgis-workshop/simple_sql/en/units/?format=api
{ "count": 34, "next": null, "previous": null, "results": [ { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/en/?format=api", "source": [ "Simple SQL" ], "previous_source": "", "target": [ "Simple SQL" ], "id_hash": 3260372505424773931, "content_hash": 3260372505424773931, "location": "../../en/simple_sql.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": 2, "source_unit": "https://weblate.osgeo.org/api/units/99017/?format=api", "priority": 100, "id": 99017, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/en/?checksum=ad3f2b84fd4b432b", "url": "https://weblate.osgeo.org/api/units/99017/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.127280Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/en/?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`, 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:" ], "id_hash": 6109885188356942522, "content_hash": 6109885188356942522, "location": "../../en/simple_sql.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": 30, "source_unit": "https://weblate.osgeo.org/api/units/99030/?format=api", "priority": 100, "id": 99030, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/en/?checksum=d4caac350e6faaba", "url": "https://weblate.osgeo.org/api/units/99030/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.161118Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/en/?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": [ "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," ], "id_hash": 3420781391977058570, "content_hash": 3420781391977058570, "location": "../../en/simple_sql.rst:12", "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": 27, "source_unit": "https://weblate.osgeo.org/api/units/99032/?format=api", "priority": 100, "id": 99032, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/en/?checksum=af790e8d4b0f110a", "url": "https://weblate.osgeo.org/api/units/99032/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.187339Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/en/?format=api", "source": [ "\"What are the names of all the neighborhoods in New York City?\"" ], "previous_source": "", "target": [ "\"What are the names of all the neighborhoods in New York City?\"" ], "id_hash": -1624571585063872884, "content_hash": -1624571585063872884, "location": "../../en/simple_sql.rst:14", "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": 12, "source_unit": "https://weblate.osgeo.org/api/units/99034/?format=api", "priority": 100, "id": 99034, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/en/?checksum=69745cc03013168c", "url": "https://weblate.osgeo.org/api/units/99034/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.216549Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/en/?format=api", "source": [ "Open up the SQL query window in pgAdmin by clicking the \"Query Tool\" button." ], "previous_source": "", "target": [ "Open up the SQL query window in pgAdmin by clicking the \"Query Tool\" button." ], "id_hash": -907009057047372689, "content_hash": -907009057047372689, "location": "../../en/simple_sql.rst:16", "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": 14, "source_unit": "https://weblate.osgeo.org/api/units/99036/?format=api", "priority": 100, "id": 99036, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/en/?checksum=7369a81172a11c6f", "url": "https://weblate.osgeo.org/api/units/99036/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.243771Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/en/?format=api", "source": [ "then enter the following query in to the query window" ], "previous_source": "", "target": [ "then enter the following query in to the query window" ], "id_hash": -2023684897651416972, "content_hash": -2023684897651416972, "location": "../../en/simple_sql.rst:20", "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": 10, "source_unit": "https://weblate.osgeo.org/api/units/99038/?format=api", "priority": 100, "id": 99038, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/en/?checksum=63ea6d4eba2a2074", "url": "https://weblate.osgeo.org/api/units/99038/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.270576Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/en/?format=api", "source": [ "and click the **Execute Query** button (the green triangle)." ], "previous_source": "", "target": [ "and click the **Execute Query** button (the green triangle)." ], "id_hash": -7293482142959842860, "content_hash": -7293482142959842860, "location": "../../en/simple_sql.rst:26", "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": 9, "source_unit": "https://weblate.osgeo.org/api/units/99040/?format=api", "priority": 100, "id": 99040, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/en/?checksum=1ac858a22d3949d4", "url": "https://weblate.osgeo.org/api/units/99040/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.292022Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/en/?format=api", "source": [ "The query will run for a few (milli)seconds and return the 129 results." ], "previous_source": "", "target": [ "The query will run for a few (milli)seconds and return the 129 results." ], "id_hash": 6173238359614649658, "content_hash": 6173238359614649658, "location": "../../en/simple_sql.rst:30", "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": 13, "source_unit": "https://weblate.osgeo.org/api/units/99042/?format=api", "priority": 100, "id": 99042, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/en/?checksum=d5abbf94b2a5753a", "url": "https://weblate.osgeo.org/api/units/99042/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.312557Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/en/?format=api", "source": [ "But what exactly happened here? To understand, let's begin with the four \"verbs\" of SQL," ], "previous_source": "", "target": [ "But what exactly happened here? To understand, let's begin with the four \"verbs\" of SQL," ], "id_hash": -4127000444081064219, "content_hash": -4127000444081064219, "location": "../../en/simple_sql.rst:35", "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": 15, "source_unit": "https://weblate.osgeo.org/api/units/99044/?format=api", "priority": 100, "id": 99044, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/en/?checksum=46b9f2f63eab36e5", "url": "https://weblate.osgeo.org/api/units/99044/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.333470Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/en/?format=api", "source": [ "``SELECT``, returns rows in response to a query" ], "previous_source": "", "target": [ "``SELECT``, returns rows in response to a query" ], "id_hash": -6660562141957401108, "content_hash": -6660562141957401108, "location": "../../en/simple_sql.rst:37", "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": 8, "source_unit": "https://weblate.osgeo.org/api/units/99046/?format=api", "priority": 100, "id": 99046, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/en/?checksum=2390ee056436d5ec", "url": "https://weblate.osgeo.org/api/units/99046/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.356077Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/en/?format=api", "source": [ "``INSERT``, adds new rows to a table" ], "previous_source": "", "target": [ "``INSERT``, adds new rows to a table" ], "id_hash": 9192180302915813808, "content_hash": 9192180302915813808, "location": "../../en/simple_sql.rst:38", "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": 7, "source_unit": "https://weblate.osgeo.org/api/units/99048/?format=api", "priority": 100, "id": 99048, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/en/?checksum=ff912f4882a3c1b0", "url": "https://weblate.osgeo.org/api/units/99048/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.379052Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/en/?format=api", "source": [ "``UPDATE``, alters existing rows in a table" ], "previous_source": "", "target": [ "``UPDATE``, alters existing rows in a table" ], "id_hash": 4219466802024757162, "content_hash": 4219466802024757162, "location": "../../en/simple_sql.rst:39", "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/99050/?format=api", "priority": 100, "id": 99050, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/en/?checksum=ba8e8eb3643d37aa", "url": "https://weblate.osgeo.org/api/units/99050/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.403911Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/en/?format=api", "source": [ "``DELETE``, removes rows from a table" ], "previous_source": "", "target": [ "``DELETE``, removes rows from a table" ], "id_hash": -485321283411790201, "content_hash": -485321283411790201, "location": "../../en/simple_sql.rst:40", "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": 6, "source_unit": "https://weblate.osgeo.org/api/units/99052/?format=api", "priority": 100, "id": 99052, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/en/?checksum=7943cadd344db687", "url": "https://weblate.osgeo.org/api/units/99052/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.429729Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/en/?format=api", "source": [ "We will be working almost exclusively with ``SELECT`` in order to ask questions of tables using spatial functions." ], "previous_source": "", "target": [ "We will be working almost exclusively with ``SELECT`` in order to ask questions of tables using spatial functions." ], "id_hash": -7357759092566018791, "content_hash": -7357759092566018791, "location": "../../en/simple_sql.rst:42", "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": 18, "source_unit": "https://weblate.osgeo.org/api/units/99055/?format=api", "priority": 100, "id": 99055, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/en/?checksum=19e3fd16a0b3b519", "url": "https://weblate.osgeo.org/api/units/99055/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.453663Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/en/?format=api", "source": [ "SELECT queries" ], "previous_source": "", "target": [ "SELECT queries" ], "id_hash": -3824971344125347342, "content_hash": -3824971344125347342, "location": "../../en/simple_sql.rst:45", "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": 2, "source_unit": "https://weblate.osgeo.org/api/units/99057/?format=api", "priority": 100, "id": 99057, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/en/?checksum=4aeaf8d3fd5c39f2", "url": "https://weblate.osgeo.org/api/units/99057/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.477127Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/en/?format=api", "source": [ "A select query is generally of the form::" ], "previous_source": "", "target": [ "A select query is generally of the form::" ], "id_hash": 2154556753285362955, "content_hash": 2154556753285362955, "location": "../../en/simple_sql.rst:47", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "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": 99060, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/en/?checksum=9de685f3a7fe350b", "url": "https://weblate.osgeo.org/api/units/99060/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.498799Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/en/?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": [ "For a synopsis of all ``SELECT`` parameters, see the `PostgresSQL documentation <http://www.postgresql.org/docs/current/interactive/sql-select.html>`_." ], "id_hash": -1510787613949988140, "content_hash": -1510787613949988140, "location": "../../en/simple_sql.rst:53", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "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": 99063, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/en/?checksum=6b089aab6b7372d4", "url": "https://weblate.osgeo.org/api/units/99063/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.520986Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/en/?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": [ "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." ], "id_hash": 1653121983106668767, "content_hash": 1653121983106668767, "location": "../../en/simple_sql.rst:55", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "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": 99066, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/en/?checksum=96f111af5d7658df", "url": "https://weblate.osgeo.org/api/units/99066/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.543665Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/en/?format=api", "source": [ "\"What are the names of all the neighborhoods in Brooklyn?\"" ], "previous_source": "", "target": [ "\"What are the names of all the neighborhoods in Brooklyn?\"" ], "id_hash": 6187990933837514987, "content_hash": 6187990933837514987, "location": "../../en/simple_sql.rst:57", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "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": 99069, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/en/?checksum=d5e028f80cb908eb", "url": "https://weblate.osgeo.org/api/units/99069/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.567082Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/en/?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": [ "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." ], "id_hash": -943566596679662443, "content_hash": -943566596679662443, "location": "../../en/simple_sql.rst:59", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "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": 99072, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/en/?checksum=72e7c72df6fc0495", "url": "https://weblate.osgeo.org/api/units/99072/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.590586Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/en/?format=api", "source": [ "The query will run for even fewer (milli)seconds and return the 23 results." ], "previous_source": "", "target": [ "The query will run for even fewer (milli)seconds and return the 23 results." ], "id_hash": -1483977016853120188, "content_hash": -1483977016853120188, "location": "../../en/simple_sql.rst:67", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "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": 99074, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/en/?checksum=6b67dac3ffa03b44", "url": "https://weblate.osgeo.org/api/units/99074/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.614604Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/en/?format=api", "source": [ "Sometimes we will need to apply a function to the results of our query. For example," ], "previous_source": "", "target": [ "Sometimes we will need to apply a function to the results of our query. For example," ], "id_hash": -8830976247187079690, "content_hash": -8830976247187079690, "location": "../../en/simple_sql.rst:69", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "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": 99076, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/en/?checksum=057211e446807df6", "url": "https://weblate.osgeo.org/api/units/99076/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.636746Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/en/?format=api", "source": [ "\"What is the number of letters in the names of all the neighborhoods in Brooklyn?\"" ], "previous_source": "", "target": [ "\"What is the number of letters in the names of all the neighborhoods in Brooklyn?\"" ], "id_hash": 197458882924291075, "content_hash": 197458882924291075, "location": "../../en/simple_sql.rst:71", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "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": 99078, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/en/?checksum=82bd83cece72a403", "url": "https://weblate.osgeo.org/api/units/99078/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.659388Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/en/?format=api", "source": [ "Fortunately, PostgreSQL has a string length function, :command:`char_length(string)`." ], "previous_source": "", "target": [ "Fortunately, PostgreSQL has a string length function, :command:`char_length(string)`." ], "id_hash": 8605128158431623754, "content_hash": 8605128158431623754, "location": "../../en/simple_sql.rst:73", "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": 8, "source_unit": "https://weblate.osgeo.org/api/units/99081/?format=api", "priority": 100, "id": 99081, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/en/?checksum=f76b8e77da073a4a", "url": "https://weblate.osgeo.org/api/units/99081/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.682098Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/en/?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": [ "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." ], "id_hash": -1600117973108927706, "content_hash": -1600117973108927706, "location": "../../en/simple_sql.rst:81", "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": 54, "source_unit": "https://weblate.osgeo.org/api/units/99083/?format=api", "priority": 100, "id": 99083, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/en/?checksum=69cb3d2e661fd326", "url": "https://weblate.osgeo.org/api/units/99083/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.704705Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/en/?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": [ "PostgreSQL has a series of built-in aggregate functions, including the general purpose :command:`avg()` for average values and :command:`stddev()` for standard deviations." ], "id_hash": 3994244424292428431, "content_hash": 3994244424292428431, "location": "../../en/simple_sql.rst:83", "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": 21, "source_unit": "https://weblate.osgeo.org/api/units/99086/?format=api", "priority": 100, "id": 99086, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/en/?checksum=b76e68243808ea8f", "url": "https://weblate.osgeo.org/api/units/99086/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.727524Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/en/?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": [ "\"What is the average number of letters and standard deviation of number of letters in the names of all the neighborhoods in Brooklyn?\"" ], "id_hash": 5702891689831228540, "content_hash": 5702891689831228540, "location": "../../en/simple_sql.rst:85", "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": 23, "source_unit": "https://weblate.osgeo.org/api/units/99089/?format=api", "priority": 100, "id": 99089, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/en/?checksum=cf24bdc6d4eae47c", "url": "https://weblate.osgeo.org/api/units/99089/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.751649Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/en/?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": [ "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." ], "id_hash": 2393826065730826252, "content_hash": 2393826065730826252, "location": "../../en/simple_sql.rst:99", "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": 60, "source_unit": "https://weblate.osgeo.org/api/units/99092/?format=api", "priority": 100, "id": 99092, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/en/?checksum=a138941fadf4f00c", "url": "https://weblate.osgeo.org/api/units/99092/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.774306Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/en/?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": [ "\"What is the average number of letters in the names of all the neighborhoods in New York City, reported by borough?\"" ], "id_hash": -4676956579218002815, "content_hash": -4676956579218002815, "location": "../../en/simple_sql.rst:101", "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": 21, "source_unit": "https://weblate.osgeo.org/api/units/99095/?format=api", "priority": 100, "id": 99095, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/en/?checksum=3f181cc551c8ec81", "url": "https://weblate.osgeo.org/api/units/99095/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.797528Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/en/?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": [ "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." ], "id_hash": 4597163752082972764, "content_hash": 4597163752082972764, "location": "../../en/simple_sql.rst:109", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "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": 99099, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/en/?checksum=bfcc68136135205c", "url": "https://weblate.osgeo.org/api/units/99099/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.868185Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/en/?format=api", "source": [ "Function List" ], "previous_source": "", "target": [ "Function List" ], "id_hash": 2815949782297668712, "content_hash": 2815949782297668712, "location": "../../en/simple_sql.rst:122", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "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": 99103, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/en/?checksum=a71443684f30ec68", "url": "https://weblate.osgeo.org/api/units/99103/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.890974Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/en/?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) <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." ], "id_hash": -5033877154090146436, "content_hash": -5033877154090146436, "location": "../../en/simple_sql.rst:124", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "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": 99107, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/en/?checksum=3a2413662380a57c", "url": "https://weblate.osgeo.org/api/units/99107/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.913256Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/en/?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) <http://www.postgresql.org/docs/current/static/functions-string.html>`_: PostgreSQL string function that returns the number of character in a string." ], "id_hash": -5151420096834902630, "content_hash": -5151420096834902630, "location": "../../en/simple_sql.rst:126", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "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": 99110, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/en/?checksum=38827ab71f58e59a", "url": "https://weblate.osgeo.org/api/units/99110/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.936083Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/simple_sql/en/?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": [ "`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." ], "id_hash": -7822121017709672541, "content_hash": -7822121017709672541, "location": "../../en/simple_sql.rst:128", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "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": 99113, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/simple_sql/en/?checksum=13723e60b54c47a3", "url": "https://weblate.osgeo.org/api/units/99113/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:40.959259Z" } ] }