Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/postgis-workshop/advanced_geometry_construction/en/units/?format=api
{ "count": 58, "next": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/units/?format=api&page=2", "previous": null, "results": [ { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "Advanced Geometry Constructions" ], "previous_source": "", "target": [ "Advanced Geometry Constructions" ], "id_hash": -4910238172837700490, "content_hash": -4910238172837700490, "location": "../../en/advanced_geometry_construction.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/103176/?format=api", "priority": 100, "id": 103176, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=3bdb5465b9721c76", "url": "https://weblate.osgeo.org/api/units/103176/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:54.538246Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "The ``nyc_subway_stations`` layer has provided us with lots of interesting examples so far, but there is something striking about it:" ], "previous_source": "", "target": [ "The ``nyc_subway_stations`` layer has provided us with lots of interesting examples so far, but there is something striking about it:" ], "id_hash": 4700658032076294221, "content_hash": 4700658032076294221, "location": "../../en/advanced_geometry_construction.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": 20, "source_unit": "https://weblate.osgeo.org/api/units/103181/?format=api", "priority": 100, "id": 103181, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=c13c1793347e884d", "url": "https://weblate.osgeo.org/api/units/103181/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:54.571373Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "Although it is a database of all the stations, it doesn't allow easy visualization of routes! In this chapter we will use advanced features of PostgreSQL and PostGIS to build up a new linear routes layer from the point layer of subway stations." ], "previous_source": "", "target": [ "Although it is a database of all the stations, it doesn't allow easy visualization of routes! In this chapter we will use advanced features of PostgreSQL and PostGIS to build up a new linear routes layer from the point layer of subway stations." ], "id_hash": -5768036309799560640, "content_hash": -5768036309799560640, "location": "../../en/advanced_geometry_construction.rst:10", "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": 43, "source_unit": "https://weblate.osgeo.org/api/units/103184/?format=api", "priority": 100, "id": 103184, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=2ff3d1895ed79a40", "url": "https://weblate.osgeo.org/api/units/103184/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:54.594404Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "Our task is made especially difficult by two issues:" ], "previous_source": "", "target": [ "Our task is made especially difficult by two issues:" ], "id_hash": 2374801152723311146, "content_hash": 2374801152723311146, "location": "../../en/advanced_geometry_construction.rst:12", "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": 9, "source_unit": "https://weblate.osgeo.org/api/units/103188/?format=api", "priority": 100, "id": 103188, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=a0f4fd10f042da2a", "url": "https://weblate.osgeo.org/api/units/103188/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:54.617525Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "The ``routes`` column of ``nyc_subway_stations`` has multiple route identifiers in each row, so a station that might appear in multiple routes appears only once in the table." ], "previous_source": "", "target": [ "The ``routes`` column of ``nyc_subway_stations`` has multiple route identifiers in each row, so a station that might appear in multiple routes appears only once in the table." ], "id_hash": -236515127925730744, "content_hash": -236515127925730744, "location": "../../en/advanced_geometry_construction.rst:14", "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": 27, "source_unit": "https://weblate.osgeo.org/api/units/103191/?format=api", "priority": 100, "id": 103191, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=7cb7babe87fb1248", "url": "https://weblate.osgeo.org/api/units/103191/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:54.640234Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "Related to the previous issue, there is no route ordering information in the stations table, so while it is possible to find all the stations in a particular route, it's not possible using the attributes to determine what the order in which trains travel through the stations." ], "previous_source": "", "target": [ "Related to the previous issue, there is no route ordering information in the stations table, so while it is possible to find all the stations in a particular route, it's not possible using the attributes to determine what the order in which trains travel through the stations." ], "id_hash": 3705510743705725480, "content_hash": 3705510743705725480, "location": "../../en/advanced_geometry_construction.rst:15", "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": 47, "source_unit": "https://weblate.osgeo.org/api/units/103194/?format=api", "priority": 100, "id": 103194, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=b36c9e6385f92a28", "url": "https://weblate.osgeo.org/api/units/103194/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:54.666006Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "The second problem is the harder one: given an unordered set of points in a route, how do we order them to match the actual route." ], "previous_source": "", "target": [ "The second problem is the harder one: given an unordered set of points in a route, how do we order them to match the actual route." ], "id_hash": -1289053591726447324, "content_hash": -1289053591726447324, "location": "../../en/advanced_geometry_construction.rst:17", "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": 26, "source_unit": "https://weblate.osgeo.org/api/units/103197/?format=api", "priority": 100, "id": 103197, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=6e1c5c9688b42524", "url": "https://weblate.osgeo.org/api/units/103197/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:54.690285Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "Here are the stops for the 'Q' train:" ], "previous_source": "", "target": [ "Here are the stops for the 'Q' train:" ], "id_hash": -2095880027753953734, "content_hash": -2095880027753953734, "location": "../../en/advanced_geometry_construction.rst:19", "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": 8, "source_unit": "https://weblate.osgeo.org/api/units/103201/?format=api", "priority": 100, "id": 103201, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=62e9f0381de3c63a", "url": "https://weblate.osgeo.org/api/units/103201/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:54.713693Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "In this picture, the stops are labelled with their unique ``gid`` primary key." ], "previous_source": "", "target": [ "In this picture, the stops are labelled with their unique ``gid`` primary key." ], "id_hash": -3067615960282801432, "content_hash": -3067615960282801432, "location": "../../en/advanced_geometry_construction.rst:27", "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": 13, "source_unit": "https://weblate.osgeo.org/api/units/103204/?format=api", "priority": 100, "id": 103204, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=556da3897c065ae8", "url": "https://weblate.osgeo.org/api/units/103204/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:54.736749Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "If we start at one of the end stations, the next station on the line seems to always be the closest. We can repeat the process each time as long as we exclude all the previously found stations from our search." ], "previous_source": "", "target": [ "If we start at one of the end stations, the next station on the line seems to always be the closest. We can repeat the process each time as long as we exclude all the previously found stations from our search." ], "id_hash": -2556353240596278412, "content_hash": -2556353240596278412, "location": "../../en/advanced_geometry_construction.rst:31", "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": 41, "source_unit": "https://weblate.osgeo.org/api/units/103207/?format=api", "priority": 100, "id": 103207, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=5c86024595d71374", "url": "https://weblate.osgeo.org/api/units/103207/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:54.760816Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "There are two ways to run such an iterative routine in a database:" ], "previous_source": "", "target": [ "There are two ways to run such an iterative routine in a database:" ], "id_hash": -824900678934827011, "content_hash": -824900678934827011, "location": "../../en/advanced_geometry_construction.rst:33", "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/103209/?format=api", "priority": 100, "id": 103209, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=748d5d33f91c6ffd", "url": "https://weblate.osgeo.org/api/units/103209/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:54.783821Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "Using a procedural language, like `PL/PgSQL <http://www.postgresql.org/docs/current/static/plpgsql.html>`_." ], "previous_source": "", "target": [ "Using a procedural language, like `PL/PgSQL <http://www.postgresql.org/docs/current/static/plpgsql.html>`_." ], "id_hash": 2223672847978308097, "content_hash": 2223672847978308097, "location": "../../en/advanced_geometry_construction.rst:35", "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/103210/?format=api", "priority": 100, "id": 103210, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=9edc12ac786da201", "url": "https://weblate.osgeo.org/api/units/103210/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:54.806474Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "Using recursive `common table expressions <http://www.postgresql.org/docs/current/static/queries-with.html>`_." ], "previous_source": "", "target": [ "Using recursive `common table expressions <http://www.postgresql.org/docs/current/static/queries-with.html>`_." ], "id_hash": 7213315137536939625, "content_hash": 7213315137536939625, "location": "../../en/advanced_geometry_construction.rst:36", "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/103211/?format=api", "priority": 100, "id": 103211, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=e41ad7e659d65669", "url": "https://weblate.osgeo.org/api/units/103211/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:54.830563Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "Common table expressions (CTE) have the virtue of not requiring a function definition to run. Here's the CTE to calculate the route line of the 'Q' train, starting from the northernmost stop (where ``gid`` is 304)." ], "previous_source": "", "target": [ "Common table expressions (CTE) have the virtue of not requiring a function definition to run. Here's the CTE to calculate the route line of the 'Q' train, starting from the northernmost stop (where ``gid`` is 304)." ], "id_hash": 5046524513283190754, "content_hash": 5046524513283190754, "location": "../../en/advanced_geometry_construction.rst:38", "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": 36, "source_unit": "https://weblate.osgeo.org/api/units/103212/?format=api", "priority": 100, "id": 103212, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=c608db4ea48bafe2", "url": "https://weblate.osgeo.org/api/units/103212/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:54.853366Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "The CTE consists of two halves, unioned together:" ], "previous_source": "", "target": [ "The CTE consists of two halves, unioned together:" ], "id_hash": 4462086612340509723, "content_hash": 4462086612340509723, "location": "../../en/advanced_geometry_construction.rst:60", "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": 8, "source_unit": "https://weblate.osgeo.org/api/units/103213/?format=api", "priority": 100, "id": 103213, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=bdec8421fd950c1b", "url": "https://weblate.osgeo.org/api/units/103213/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:54.876612Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "The first half establishes a start point for the expression. We get the initial geometry and initialize the array of visited identifiers, using the record of \"gid\" 304 (the end of the line)." ], "previous_source": "", "target": [ "The first half establishes a start point for the expression. We get the initial geometry and initialize the array of visited identifiers, using the record of \"gid\" 304 (the end of the line)." ], "id_hash": 5387660158047494929, "content_hash": 5387660158047494929, "location": "../../en/advanced_geometry_construction.rst:62", "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": 33, "source_unit": "https://weblate.osgeo.org/api/units/103214/?format=api", "priority": 100, "id": 103214, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=cac4d05e62f22311", "url": "https://weblate.osgeo.org/api/units/103214/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:54.899736Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "The second half iterates until it finds no further records. At each iteration it takes in the value at the previous iteration via the self-reference to \"next_stop\". We search every stop on the Q line (**strpos(s.routes,'Q')**) that we have not already added to our visited list (**NOT n.idlist @> ARRAY[s.gid]**) and order them by their distance from the previous point, taking just the first one (the nearest)." ], "previous_source": "", "target": [ "The second half iterates until it finds no further records. At each iteration it takes in the value at the previous iteration via the self-reference to \"next_stop\". We search every stop on the Q line (**strpos(s.routes,'Q')**) that we have not already added to our visited list (**NOT n.idlist @> ARRAY[s.gid]**) and order them by their distance from the previous point, taking just the first one (the nearest)." ], "id_hash": 5889666356066061323, "content_hash": 5889666356066061323, "location": "../../en/advanced_geometry_construction.rst:63", "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": 67, "source_unit": "https://weblate.osgeo.org/api/units/103218/?format=api", "priority": 100, "id": 103218, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=d1bc4c5896e30c0b", "url": "https://weblate.osgeo.org/api/units/103218/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:54.923092Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "Beyond the recursive CTE itself, there are a number of advanced PostgreSQL array features being used here:" ], "previous_source": "", "target": [ "Beyond the recursive CTE itself, there are a number of advanced PostgreSQL array features being used here:" ], "id_hash": 5826301372872188558, "content_hash": 5826301372872188558, "location": "../../en/advanced_geometry_construction.rst:65", "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": 17, "source_unit": "https://weblate.osgeo.org/api/units/103231/?format=api", "priority": 100, "id": 103231, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=d0db2e3ac46ae28e", "url": "https://weblate.osgeo.org/api/units/103231/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:54.946218Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "We are using ARRAY! PostgreSQL supports arrays of any type. In this case we have an array of integers, but we could also build an array of geometries, or any other PostgreSQL type." ], "previous_source": "", "target": [ "We are using ARRAY! PostgreSQL supports arrays of any type. In this case we have an array of integers, but we could also build an array of geometries, or any other PostgreSQL type." ], "id_hash": 1890110948791648245, "content_hash": 1890110948791648245, "location": "../../en/advanced_geometry_construction.rst:67", "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": 33, "source_unit": "https://weblate.osgeo.org/api/units/103245/?format=api", "priority": 100, "id": 103245, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=9a3b05e4c8cd7ff5", "url": "https://weblate.osgeo.org/api/units/103245/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:54.969118Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "We are using **array_append** to build up our array of visited identifiers." ], "previous_source": "", "target": [ "We are using **array_append** to build up our array of visited identifiers." ], "id_hash": 5772782590480689284, "content_hash": 5772782590480689284, "location": "../../en/advanced_geometry_construction.rst:68", "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": 12, "source_unit": "https://weblate.osgeo.org/api/units/103259/?format=api", "priority": 100, "id": 103259, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=d01d0b2e37292884", "url": "https://weblate.osgeo.org/api/units/103259/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:54.992354Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "We are using the **@>** array operator (\"array contains\") to find which of the Q train stations we have already visited. The **@>** operators requires ARRAY values on both sides, so we have to turn the individual \"gid\" numbers into single-entry arrays using the ARRAY[] syntax." ], "previous_source": "", "target": [ "We are using the **@>** array operator (\"array contains\") to find which of the Q train stations we have already visited. The **@>** operators requires ARRAY values on both sides, so we have to turn the individual \"gid\" numbers into single-entry arrays using the ARRAY[] syntax." ], "id_hash": -1333716205635802704, "content_hash": -1333716205635802704, "location": "../../en/advanced_geometry_construction.rst:69", "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": 46, "source_unit": "https://weblate.osgeo.org/api/units/103262/?format=api", "priority": 100, "id": 103262, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=6d7db02d63e569b0", "url": "https://weblate.osgeo.org/api/units/103262/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:55.015388Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "When you run the query, you get each geometry in the order it is found (which is the route order), as well as the list of identifiers already visited. Wrapping the geometries into the PostGIS `ST_MakeLine <http://postgis.net/docs/ST_MakeLine.html>`_ aggregate function turns the set of geometries into a single linear output, constructed in the provided order." ], "previous_source": "", "target": [ "When you run the query, you get each geometry in the order it is found (which is the route order), as well as the list of identifiers already visited. Wrapping the geometries into the PostGIS `ST_MakeLine <http://postgis.net/docs/ST_MakeLine.html>`_ aggregate function turns the set of geometries into a single linear output, constructed in the provided order." ], "id_hash": -7159958636721304112, "content_hash": -7159958636721304112, "location": "../../en/advanced_geometry_construction.rst:71", "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": 54, "source_unit": "https://weblate.osgeo.org/api/units/103263/?format=api", "priority": 100, "id": 103263, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=1ca2b78e13bc8dd0", "url": "https://weblate.osgeo.org/api/units/103263/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:55.038222Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "Which looks like this:" ], "previous_source": "", "target": [ "Which looks like this:" ], "id_hash": 382687652304819661, "content_hash": 382687652304819661, "location": "../../en/advanced_geometry_construction.rst:93", "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": 4, "source_unit": "https://weblate.osgeo.org/api/units/103264/?format=api", "priority": 100, "id": 103264, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=854f9464678e95cd", "url": "https://weblate.osgeo.org/api/units/103264/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:55.061274Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "*Success!*" ], "previous_source": "", "target": [ "*Success!*" ], "id_hash": 5543329467801700845, "content_hash": 5543329467801700845, "location": "../../en/advanced_geometry_construction.rst:97", "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/103265/?format=api", "priority": 100, "id": 103265, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=cceddcc7f94689ed", "url": "https://weblate.osgeo.org/api/units/103265/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:55.082852Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "Except, two problems:" ], "previous_source": "", "target": [ "Except, two problems:" ], "id_hash": 330080386931321676, "content_hash": 330080386931321676, "location": "../../en/advanced_geometry_construction.rst:99", "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": 3, "source_unit": "https://weblate.osgeo.org/api/units/103278/?format=api", "priority": 100, "id": 103278, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=8494ae5cf25d6b4c", "url": "https://weblate.osgeo.org/api/units/103278/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:55.105115Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "We are only calculating one subway route here, we want to calculate all the routes." ], "previous_source": "", "target": [ "We are only calculating one subway route here, we want to calculate all the routes." ], "id_hash": 6426275117448981499, "content_hash": 6426275117448981499, "location": "../../en/advanced_geometry_construction.rst:101", "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": 15, "source_unit": "https://weblate.osgeo.org/api/units/103289/?format=api", "priority": 100, "id": 103289, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=d92eb72be47a6bfb", "url": "https://weblate.osgeo.org/api/units/103289/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:55.127484Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "Our query includes a piece of *a priori* knowledge, the initial station identifier that serves as the seed for the search algorithm that builds the route." ], "previous_source": "", "target": [ "Our query includes a piece of *a priori* knowledge, the initial station identifier that serves as the seed for the search algorithm that builds the route." ], "id_hash": -2919127326063432868, "content_hash": -2919127326063432868, "location": "../../en/advanced_geometry_construction.rst:102", "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": 26, "source_unit": "https://weblate.osgeo.org/api/units/103303/?format=api", "priority": 100, "id": 103303, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=577d2d29c3da6b5c", "url": "https://weblate.osgeo.org/api/units/103303/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:55.150129Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "Let's tackle the hard problem first, figuring out the first station on a route without manually eyeballing the set of stations that make up the route." ], "previous_source": "", "target": [ "Let's tackle the hard problem first, figuring out the first station on a route without manually eyeballing the set of stations that make up the route." ], "id_hash": -6799698599808442357, "content_hash": -6799698599808442357, "location": "../../en/advanced_geometry_construction.rst:104", "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": 26, "source_unit": "https://weblate.osgeo.org/api/units/103318/?format=api", "priority": 100, "id": 103318, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=21a29e265ab2600b", "url": "https://weblate.osgeo.org/api/units/103318/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:55.173539Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "Our 'Q' train stops can serve as a starting point. What characterizes the end stations of the route?" ], "previous_source": "", "target": [ "Our 'Q' train stops can serve as a starting point. What characterizes the end stations of the route?" ], "id_hash": 3064769104151151793, "content_hash": 3064769104151151793, "location": "../../en/advanced_geometry_construction.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": 18, "source_unit": "https://weblate.osgeo.org/api/units/103340/?format=api", "priority": 100, "id": 103340, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=aa883f432b8584b1", "url": "https://weblate.osgeo.org/api/units/103340/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:55.196611Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "One answer is \"they are the most northerly and southerly stations\". However, imagine if the 'Q' train ran from east to west. Would the condition still hold?" ], "previous_source": "", "target": [ "One answer is \"they are the most northerly and southerly stations\". However, imagine if the 'Q' train ran from east to west. Would the condition still hold?" ], "id_hash": 934731448973337642, "content_hash": 934731448973337642, "location": "../../en/advanced_geometry_construction.rst:110", "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": 27, "source_unit": "https://weblate.osgeo.org/api/units/103355/?format=api", "priority": 100, "id": 103355, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=8cf8d54ce871242a", "url": "https://weblate.osgeo.org/api/units/103355/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:55.219449Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "A less directional characterization of the end stations is \"they are the furthest stations from the middle of the route\". With this characterization it doesn't matter if the route runs north/south or east/west, just that it run in more-or-less one direction, particularly at the ends." ], "previous_source": "", "target": [ "A less directional characterization of the end stations is \"they are the furthest stations from the middle of the route\". With this characterization it doesn't matter if the route runs north/south or east/west, just that it run in more-or-less one direction, particularly at the ends." ], "id_hash": -6478405378127542428, "content_hash": -6478405378127542428, "location": "../../en/advanced_geometry_construction.rst:112", "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": 45, "source_unit": "https://weblate.osgeo.org/api/units/103370/?format=api", "priority": 100, "id": 103370, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=261814a1f5ba4764", "url": "https://weblate.osgeo.org/api/units/103370/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:55.242475Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "Since there is no 100% heuristic to figure out the end points, let's try this second rule out." ], "previous_source": "", "target": [ "Since there is no 100% heuristic to figure out the end points, let's try this second rule out." ], "id_hash": -1088962159568114954, "content_hash": -1088962159568114954, "location": "../../en/advanced_geometry_construction.rst:114", "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": 18, "source_unit": "https://weblate.osgeo.org/api/units/103397/?format=api", "priority": 100, "id": 103397, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=70e33aaf7919aaf6", "url": "https://weblate.osgeo.org/api/units/103397/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:55.265680Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "An obvious failure mode of the \"furthest from middle\" rule is a circular line, like the Circle Line in London, UK. Fortunately, New York doesn't have any such lines!" ], "previous_source": "", "target": [ "An obvious failure mode of the \"furthest from middle\" rule is a circular line, like the Circle Line in London, UK. Fortunately, New York doesn't have any such lines!" ], "id_hash": 857784032421667555, "content_hash": 857784032421667555, "location": "../../en/advanced_geometry_construction.rst:118", "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": 29, "source_unit": "https://weblate.osgeo.org/api/units/103418/?format=api", "priority": 100, "id": 103418, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=8be77608627ee2e3", "url": "https://weblate.osgeo.org/api/units/103418/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:55.288368Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "To work out the end stations of every route, we first have to work out what routes there are! We find the distinct routes." ], "previous_source": "", "target": [ "To work out the end stations of every route, we first have to work out what routes there are! We find the distinct routes." ], "id_hash": -7932274881581551746, "content_hash": -7932274881581551746, "location": "../../en/advanced_geometry_construction.rst:120", "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": 24, "source_unit": "https://weblate.osgeo.org/api/units/103430/?format=api", "priority": 100, "id": 103430, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=11eae605ae93ef7e", "url": "https://weblate.osgeo.org/api/units/103430/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:55.311637Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "Note the use of two advanced PostgreSQL ARRAY functions:" ], "previous_source": "", "target": [ "Note the use of two advanced PostgreSQL ARRAY functions:" ], "id_hash": -2722377532654539441, "content_hash": -2722377532654539441, "location": "../../en/advanced_geometry_construction.rst:130", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 35, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://weblate.osgeo.org/api/units/103443/?format=api", "priority": 100, "id": 103443, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=5a382c0ecd9f2d4f", "url": "https://weblate.osgeo.org/api/units/103443/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:55.334863Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "**string_to_array** takes in a string and splits it into an array using a separator character. `PostgreSQL supports arrays <http://www.postgresql.org/docs/current/static/arrays.html>`_ of any type, so it's possible to build arrays of strings, as in this case, but also of geometries and geographies as we'll see later in this example." ], "previous_source": "", "target": [ "**string_to_array** takes in a string and splits it into an array using a separator character. `PostgreSQL supports arrays <http://www.postgresql.org/docs/current/static/arrays.html>`_ of any type, so it's possible to build arrays of strings, as in this case, but also of geometries and geographies as we'll see later in this example." ], "id_hash": -3134869836740548663, "content_hash": -3134869836740548663, "location": "../../en/advanced_geometry_construction.rst:132", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 36, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 47, "source_unit": "https://weblate.osgeo.org/api/units/103466/?format=api", "priority": 100, "id": 103466, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=547eb47e23fe27c9", "url": "https://weblate.osgeo.org/api/units/103466/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:55.357488Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "**unnest** takes in an array and builds a new row for each entry in the array. The effect is to take a \"horizontal\" array embedded in a single row and turn it into a \"vertical\" array with a row for each value." ], "previous_source": "", "target": [ "**unnest** takes in an array and builds a new row for each entry in the array. The effect is to take a \"horizontal\" array embedded in a single row and turn it into a \"vertical\" array with a row for each value." ], "id_hash": -1260448722315181063, "content_hash": -1260448722315181063, "location": "../../en/advanced_geometry_construction.rst:133", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 37, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://weblate.osgeo.org/api/units/103491/?format=api", "priority": 100, "id": 103491, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=6e81fc90b0cf03f9", "url": "https://weblate.osgeo.org/api/units/103491/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:55.380905Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "The result is a list of all the unique subway route identifiers." ], "previous_source": "", "target": [ "The result is a list of all the unique subway route identifiers." ], "id_hash": -5105986198258513878, "content_hash": -5105986198258513878, "location": "../../en/advanced_geometry_construction.rst:135", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 38, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://weblate.osgeo.org/api/units/103517/?format=api", "priority": 100, "id": 103517, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=3923e49af8c1082a", "url": "https://weblate.osgeo.org/api/units/103517/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:55.404088Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "We can build on this result by joining it back to the ``nyc_subway_stations`` table to create a new table that has, for each route, a row for every station on that route." ], "previous_source": "", "target": [ "We can build on this result by joining it back to the ``nyc_subway_stations`` table to create a new table that has, for each route, a row for every station on that route." ], "id_hash": 810570763135387199, "content_hash": 810570763135387199, "location": "../../en/advanced_geometry_construction.rst:167", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 39, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://weblate.osgeo.org/api/units/103544/?format=api", "priority": 100, "id": 103544, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=8b3fb9d08200863f", "url": "https://weblate.osgeo.org/api/units/103544/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:55.426872Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "Now we can find the center point by collecting all the stations for each route into a single multi-point, and calculating the centroid of that multi-point." ], "previous_source": "", "target": [ "Now we can find the center point by collecting all the stations for each route into a single multi-point, and calculating the centroid of that multi-point." ], "id_hash": -710681427359648278, "content_hash": -710681427359648278, "location": "../../en/advanced_geometry_construction.rst:193", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 40, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://weblate.osgeo.org/api/units/103561/?format=api", "priority": 100, "id": 103561, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=76232701d5c2b5ea", "url": "https://weblate.osgeo.org/api/units/103561/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:55.448959Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "The center point of the collection of 'Q' train stops looks like this:" ], "previous_source": "", "target": [ "The center point of the collection of 'Q' train stops looks like this:" ], "id_hash": 3319171301432337027, "content_hash": 3319171301432337027, "location": "../../en/advanced_geometry_construction.rst:214", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 41, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://weblate.osgeo.org/api/units/103564/?format=api", "priority": 100, "id": 103564, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=ae1010b6828ba283", "url": "https://weblate.osgeo.org/api/units/103564/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:55.472105Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "So the northern most stop, the end point, appears to also be the stop furthest from the center. Let's calculate the furthest point for every route." ], "previous_source": "", "target": [ "So the northern most stop, the end point, appears to also be the stop furthest from the center. Let's calculate the furthest point for every route." ], "id_hash": 9179613037738890727, "content_hash": 9179613037738890727, "location": "../../en/advanced_geometry_construction.rst:218", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 42, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://weblate.osgeo.org/api/units/103565/?format=api", "priority": 100, "id": 103565, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=ff64896c11f895e7", "url": "https://weblate.osgeo.org/api/units/103565/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:55.495126Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "We've added two sub-queries this time:" ], "previous_source": "", "target": [ "We've added two sub-queries this time:" ], "id_hash": -3086563020479548974, "content_hash": -3086563020479548974, "location": "../../en/advanced_geometry_construction.rst:249", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 43, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://weblate.osgeo.org/api/units/103566/?format=api", "priority": 100, "id": 103566, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=552a53494375b1d2", "url": "https://weblate.osgeo.org/api/units/103566/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:55.517927Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "**stops_distance** joins the centers points back to the stations table and calculates the distance between the stations and center for each route. The result is ordered such that the records come out in batches for each route, with the furthest station as the first record of the batch." ], "previous_source": "", "target": [ "**stops_distance** joins the centers points back to the stations table and calculates the distance between the stations and center for each route. The result is ordered such that the records come out in batches for each route, with the furthest station as the first record of the batch." ], "id_hash": 5998203451465320349, "content_hash": 5998203451465320349, "location": "../../en/advanced_geometry_construction.rst:251", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 44, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 48, "source_unit": "https://weblate.osgeo.org/api/units/103567/?format=api", "priority": 100, "id": 103567, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=d33de6425f1cc79d", "url": "https://weblate.osgeo.org/api/units/103567/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:55.541155Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "**first_stops** filters the **stops_distance** output by only taking the first record for each distinct group. Because of the way we ordered **stops_distance** the first record is the furthest record, which means it's the station we want to use as our starting seed to build each subway route." ], "previous_source": "", "target": [ "**first_stops** filters the **stops_distance** output by only taking the first record for each distinct group. Because of the way we ordered **stops_distance** the first record is the furthest record, which means it's the station we want to use as our starting seed to build each subway route." ], "id_hash": -3796276562856999770, "content_hash": -3796276562856999770, "location": "../../en/advanced_geometry_construction.rst:252", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 45, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 47, "source_unit": "https://weblate.osgeo.org/api/units/103568/?format=api", "priority": 100, "id": 103568, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=4b50ea9461c484a6", "url": "https://weblate.osgeo.org/api/units/103568/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:55.567855Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "Now we know every route, and we know (approximately) what station each route starts from: we're ready to generate the route lines!" ], "previous_source": "", "target": [ "Now we know every route, and we know (approximately) what station each route starts from: we're ready to generate the route lines!" ], "id_hash": -4780085077900394697, "content_hash": -4780085077900394697, "location": "../../en/advanced_geometry_construction.rst:254", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 46, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://weblate.osgeo.org/api/units/103569/?format=api", "priority": 100, "id": 103569, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=3da9b9f29799ff37", "url": "https://weblate.osgeo.org/api/units/103569/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:55.594661Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "But first, we need to turn our recursive CTE expression into a function we can call with parameters." ], "previous_source": "", "target": [ "But first, we need to turn our recursive CTE expression into a function we can call with parameters." ], "id_hash": 7842144592257044109, "content_hash": 7842144592257044109, "location": "../../en/advanced_geometry_construction.rst:256", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 47, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://weblate.osgeo.org/api/units/103584/?format=api", "priority": 100, "id": 103584, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=ecd4e4f50abb4e8d", "url": "https://weblate.osgeo.org/api/units/103584/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:55.618929Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "And now we are ready to go!" ], "previous_source": "", "target": [ "And now we are ready to go!" ], "id_hash": 7109275323302367638, "content_hash": 7109275323302367638, "location": "../../en/advanced_geometry_construction.rst:283", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 48, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://weblate.osgeo.org/api/units/103598/?format=api", "priority": 100, "id": 103598, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=e2a9383d6fe35196", "url": "https://weblate.osgeo.org/api/units/103598/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:55.642712Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "Here's what our final table looks like visualized in QGIS:" ], "previous_source": "", "target": [ "Here's what our final table looks like visualized in QGIS:" ], "id_hash": -8590953763636616495, "content_hash": -8590953763636616495, "location": "../../en/advanced_geometry_construction.rst:328", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 49, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://weblate.osgeo.org/api/units/103614/?format=api", "priority": 100, "id": 103614, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=08c6cd119ca262d1", "url": "https://weblate.osgeo.org/api/units/103614/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:55.667963Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/advanced_geometry_construction/en/?format=api", "source": [ "As usual, there are some problems with our simple understanding of the data:" ], "previous_source": "", "target": [ "As usual, there are some problems with our simple understanding of the data:" ], "id_hash": 1079495082808292905, "content_hash": 1079495082808292905, "location": "../../en/advanced_geometry_construction.rst:332", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 50, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://weblate.osgeo.org/api/units/103628/?format=api", "priority": 100, "id": 103628, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/advanced_geometry_construction/en/?checksum=8efb230ef391b629", "url": "https://weblate.osgeo.org/api/units/103628/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:55.691197Z" } ] }