Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/postgis-workshop/joins_advanced/en/units/?format=api
{ "count": 40, "next": null, "previous": null, "results": [ { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_advanced/en/?format=api", "source": [ "More Spatial Joins" ], "previous_source": "", "target": [ "More Spatial Joins" ], "id_hash": -3392623466463422677, "content_hash": -3392623466463422677, "location": "../../en/joins_advanced.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/100521/?format=api", "priority": 100, "id": 100521, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_advanced/en/?checksum=50eafaeea0cb172b", "url": "https://weblate.osgeo.org/api/units/100521/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:45.903185Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_advanced/en/?format=api", "source": [ "In the last section we saw the :command:`ST_Centroid(geometry)` and :command:`ST_Union([geometry])` functions, and some simple examples. In this section we will do some more elaborate things with them." ], "previous_source": "", "target": [ "In the last section we saw the :command:`ST_Centroid(geometry)` and :command:`ST_Union([geometry])` functions, and some simple examples. In this section we will do some more elaborate things with them." ], "id_hash": 1872710098979203295, "content_hash": 1872710098979203295, "location": "../../en/joins_advanced.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": 27, "source_unit": "https://weblate.osgeo.org/api/units/100523/?format=api", "priority": 100, "id": 100523, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_advanced/en/?checksum=99fd33e9b8f128df", "url": "https://weblate.osgeo.org/api/units/100523/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:45.937525Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_advanced/en/?format=api", "source": [ "Creating a Census Tracts Table" ], "previous_source": "", "target": [ "Creating a Census Tracts Table" ], "id_hash": 8349735931926094152, "content_hash": 8349735931926094152, "location": "../../en/joins_advanced.rst:11, ../../en/joins_advanced.rst:31", "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": 5, "source_unit": "https://weblate.osgeo.org/api/units/100540/?format=api", "priority": 100, "id": 100540, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_advanced/en/?checksum=f3e038975ec52148", "url": "https://weblate.osgeo.org/api/units/100540/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:45.960053Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_advanced/en/?format=api", "source": [ "In the workshop ``\\data\\`` directory, is a file that includes attribute data, but no geometry, ``nyc_census_sociodata.sql``. The table includes interesting socioeconomic data about New York: commute times, incomes, and education attainment. There is just one problem. The data are summarized by \"census tract\" and we have no census tract spatial data!" ], "previous_source": "", "target": [ "In the workshop ``\\data\\`` directory, is a file that includes attribute data, but no geometry, ``nyc_census_sociodata.sql``. The table includes interesting socioeconomic data about New York: commute times, incomes, and education attainment. There is just one problem. The data are summarized by \"census tract\" and we have no census tract spatial data!" ], "id_hash": 5454618918660209615, "content_hash": 5454618918660209615, "location": "../../en/joins_advanced.rst:13", "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": 51, "source_unit": "https://weblate.osgeo.org/api/units/100565/?format=api", "priority": 100, "id": 100565, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_advanced/en/?checksum=cbb2b301b7ddfbcf", "url": "https://weblate.osgeo.org/api/units/100565/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:45.982576Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_advanced/en/?format=api", "source": [ "In this section we will" ], "previous_source": "", "target": [ "In this section we will" ], "id_hash": -4912173885241305723, "content_hash": -4912173885241305723, "location": "../../en/joins_advanced.rst:15", "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": 5, "source_unit": "https://weblate.osgeo.org/api/units/100588/?format=api", "priority": 100, "id": 100588, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_advanced/en/?checksum=3bd473e08f3dd585", "url": "https://weblate.osgeo.org/api/units/100588/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.006159Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_advanced/en/?format=api", "source": [ "Load the ``nyc_census_sociodata.sql`` table" ], "previous_source": "", "target": [ "Load the ``nyc_census_sociodata.sql`` table" ], "id_hash": 1313794134543160800, "content_hash": 1313794134543160800, "location": "../../en/joins_advanced.rst:17", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 6, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://weblate.osgeo.org/api/units/100601/?format=api", "priority": 100, "id": 100601, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_advanced/en/?checksum=923b88cdf96fd5e0", "url": "https://weblate.osgeo.org/api/units/100601/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.029081Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_advanced/en/?format=api", "source": [ "Create a spatial table for census tracts" ], "previous_source": "", "target": [ "Create a spatial table for census tracts" ], "id_hash": 5551588161941797163, "content_hash": 5551588161941797163, "location": "../../en/joins_advanced.rst:18", "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": 7, "source_unit": "https://weblate.osgeo.org/api/units/100616/?format=api", "priority": 100, "id": 100616, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_advanced/en/?checksum=cd0b34050bcdf92b", "url": "https://weblate.osgeo.org/api/units/100616/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.052193Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_advanced/en/?format=api", "source": [ "Join the attribute data to the spatial data" ], "previous_source": "", "target": [ "Join the attribute data to the spatial data" ], "id_hash": 8377418651366660903, "content_hash": 8377418651366660903, "location": "../../en/joins_advanced.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/100631/?format=api", "priority": 100, "id": 100631, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_advanced/en/?checksum=f44291e0c1711b27", "url": "https://weblate.osgeo.org/api/units/100631/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.075080Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_advanced/en/?format=api", "source": [ "Carry out some analysis using our new data" ], "previous_source": "", "target": [ "Carry out some analysis using our new data" ], "id_hash": 5797312620146075117, "content_hash": 5797312620146075117, "location": "../../en/joins_advanced.rst:20", "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": 8, "source_unit": "https://weblate.osgeo.org/api/units/100632/?format=api", "priority": 100, "id": 100632, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_advanced/en/?checksum=d074311ccfb225ed", "url": "https://weblate.osgeo.org/api/units/100632/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.098008Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_advanced/en/?format=api", "source": [ "Loading nyc_census_sociodata.sql" ], "previous_source": "", "target": [ "Loading nyc_census_sociodata.sql" ], "id_hash": -8308815481128608749, "content_hash": -8308815481128608749, "location": "../../en/joins_advanced.rst:23", "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": 2, "source_unit": "https://weblate.osgeo.org/api/units/100634/?format=api", "priority": 100, "id": 100634, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_advanced/en/?checksum=0cb1285787101c13", "url": "https://weblate.osgeo.org/api/units/100634/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.120676Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_advanced/en/?format=api", "source": [ "Open the SQL query window in PgAdmin" ], "previous_source": "", "target": [ "Open the SQL query window in PgAdmin" ], "id_hash": -6308635586766803371, "content_hash": -6308635586766803371, "location": "../../en/joins_advanced.rst:25", "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/100639/?format=api", "priority": 100, "id": 100639, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_advanced/en/?checksum=2873395bc1606e55", "url": "https://weblate.osgeo.org/api/units/100639/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.144898Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_advanced/en/?format=api", "source": [ "Select **File->Open** from the menu and browse to the ``nyc_census_sociodata.sql`` file" ], "previous_source": "", "target": [ "Select **File->Open** from the menu and browse to the ``nyc_census_sociodata.sql`` file" ], "id_hash": 9044142387377142919, "content_hash": 9044142387377142919, "location": "../../en/joins_advanced.rst:26", "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": 11, "source_unit": "https://weblate.osgeo.org/api/units/100654/?format=api", "priority": 100, "id": 100654, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_advanced/en/?checksum=fd833f9559aafc87", "url": "https://weblate.osgeo.org/api/units/100654/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.167355Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_advanced/en/?format=api", "source": [ "Press the \"Run Query\" button" ], "previous_source": "", "target": [ "Press the \"Run Query\" button" ], "id_hash": 7598561794106580120, "content_hash": 7598561794106580120, "location": "../../en/joins_advanced.rst:27", "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": 5, "source_unit": "https://weblate.osgeo.org/api/units/100671/?format=api", "priority": 100, "id": 100671, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_advanced/en/?checksum=e97383b15d93dc98", "url": "https://weblate.osgeo.org/api/units/100671/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.191935Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_advanced/en/?format=api", "source": [ "If you press the \"Refresh\" button in PgAdmin, the list of tables should now include at ``nyc_census_sociodata`` table" ], "previous_source": "", "target": [ "If you press the \"Refresh\" button in PgAdmin, the list of tables should now include at ``nyc_census_sociodata`` table" ], "id_hash": -3339695968650290930, "content_hash": -3339695968650290930, "location": "../../en/joins_advanced.rst:28", "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/100677/?format=api", "priority": 100, "id": 100677, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_advanced/en/?checksum=51a7043602cb990e", "url": "https://weblate.osgeo.org/api/units/100677/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.216099Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_advanced/en/?format=api", "source": [ "As we saw in the previous section, we can build up higher level geometries from the census block by summarizing on substrings of the ``blkid`` key. In order to get census tracts, we need to summarize grouping on the first 11 characters of the ``blkid``." ], "previous_source": "", "target": [ "As we saw in the previous section, we can build up higher level geometries from the census block by summarizing on substrings of the ``blkid`` key. In order to get census tracts, we need to summarize grouping on the first 11 characters of the ``blkid``." ], "id_hash": -6750182731229709151, "content_hash": -6750182731229709151, "location": "../../en/joins_advanced.rst:33", "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": 45, "source_unit": "https://weblate.osgeo.org/api/units/100709/?format=api", "priority": 100, "id": 100709, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_advanced/en/?checksum=22528891e813bca1", "url": "https://weblate.osgeo.org/api/units/100709/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.346628Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_advanced/en/?format=api", "source": [ "Create the new table using the :command:`ST_Union` aggregate:" ], "previous_source": "", "target": [ "Create the new table using the :command:`ST_Union` aggregate:" ], "id_hash": -1306926866106250868, "content_hash": -1306926866106250868, "location": "../../en/joins_advanced.rst:46", "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/100738/?format=api", "priority": 100, "id": 100738, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_advanced/en/?checksum=6ddcdcf08e52898c", "url": "https://weblate.osgeo.org/api/units/100738/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.369604Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_advanced/en/?format=api", "source": [ "Join the Attributes to the Spatial Data" ], "previous_source": "", "target": [ "Join the Attributes to the Spatial Data" ], "id_hash": -2033039602306746630, "content_hash": -2033039602306746630, "location": "../../en/joins_advanced.rst:64", "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": 7, "source_unit": "https://weblate.osgeo.org/api/units/100764/?format=api", "priority": 100, "id": 100764, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_advanced/en/?checksum=63c93140d23476fa", "url": "https://weblate.osgeo.org/api/units/100764/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.392530Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_advanced/en/?format=api", "source": [ "Join the table of tract geometries to the table of tract attributes with a standard attribute join" ], "previous_source": "", "target": [ "Join the table of tract geometries to the table of tract attributes with a standard attribute join" ], "id_hash": 8657563039863842897, "content_hash": 8657563039863842897, "location": "../../en/joins_advanced.rst:66", "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/100778/?format=api", "priority": 100, "id": 100778, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_advanced/en/?checksum=f825d7b70ba2a851", "url": "https://weblate.osgeo.org/api/units/100778/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.414738Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_advanced/en/?format=api", "source": [ "Answer an Interesting Question" ], "previous_source": "", "target": [ "Answer an Interesting Question" ], "id_hash": 3186820688860855576, "content_hash": 3186820688860855576, "location": "../../en/joins_advanced.rst:87", "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": 4, "source_unit": "https://weblate.osgeo.org/api/units/100792/?format=api", "priority": 100, "id": 100792, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_advanced/en/?checksum=ac39dc88326abd18", "url": "https://weblate.osgeo.org/api/units/100792/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.437790Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_advanced/en/?format=api", "source": [ "Answer an interesting question! \"List top 10 New York neighborhoods ordered by the proportion of people who have graduate degrees.\"" ], "previous_source": "", "target": [ "Answer an interesting question! \"List top 10 New York neighborhoods ordered by the proportion of people who have graduate degrees.\"" ], "id_hash": -4080374263971430300, "content_hash": -4080374263971430300, "location": "../../en/joins_advanced.rst:89", "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": 20, "source_unit": "https://weblate.osgeo.org/api/units/100797/?format=api", "priority": 100, "id": 100797, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_advanced/en/?checksum=475f9939c5564064", "url": "https://weblate.osgeo.org/api/units/100797/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.462654Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_advanced/en/?format=api", "source": [ "We sum up the statistics we are interested, then divide them together at the end. In order to avoid divide-by-zero errors, we don't bother bringing in tracts that have a population count of zero." ], "previous_source": "", "target": [ "We sum up the statistics we are interested, then divide them together at the end. In order to avoid divide-by-zero errors, we don't bother bringing in tracts that have a population count of zero." ], "id_hash": -7480440935927542294, "content_hash": -7480440935927542294, "location": "../../en/joins_advanced.rst:104", "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": 34, "source_unit": "https://weblate.osgeo.org/api/units/100799/?format=api", "priority": 100, "id": 100799, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_advanced/en/?checksum=1830229a12bf8dea", "url": "https://weblate.osgeo.org/api/units/100799/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.486760Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_advanced/en/?format=api", "source": [ "New York geographers will be wondering at the presence of \"Flatbush\" in this list of over-educated neighborhoods. The answer is discussed in the next section." ], "previous_source": "", "target": [ "New York geographers will be wondering at the presence of \"Flatbush\" in this list of over-educated neighborhoods. The answer is discussed in the next section." ], "id_hash": -5847788693712791620, "content_hash": -5847788693712791620, "location": "../../en/joins_advanced.rst:124", "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": 25, "source_unit": "https://weblate.osgeo.org/api/units/100801/?format=api", "priority": 100, "id": 100801, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_advanced/en/?checksum=2ed87b2a7db417bc", "url": "https://weblate.osgeo.org/api/units/100801/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.510242Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_advanced/en/?format=api", "source": [ "Polygon/Polygon Joins" ], "previous_source": "", "target": [ "Polygon/Polygon Joins" ], "id_hash": -8515559408093211794, "content_hash": -8515559408093211794, "location": "../../en/joins_advanced.rst:129", "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": 2, "source_unit": "https://weblate.osgeo.org/api/units/100803/?format=api", "priority": 100, "id": 100803, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_advanced/en/?checksum=09d2a7d5f0de536e", "url": "https://weblate.osgeo.org/api/units/100803/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.533227Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_advanced/en/?format=api", "source": [ "In our interesting query (in :ref:`interestingquestion`) we used the :command:`ST_Intersects(geometry_a, geometry_b)` function to determine which census tract polygons to include in each neighborhood summary. Which leads to the question: what if a tract falls on the border between two neighborhoods? It will intersect both, and so will be included in the summary statistics for **both**." ], "previous_source": "", "target": [ "In our interesting query (in :ref:`interestingquestion`) we used the :command:`ST_Intersects(geometry_a, geometry_b)` function to determine which census tract polygons to include in each neighborhood summary. Which leads to the question: what if a tract falls on the border between two neighborhoods? It will intersect both, and so will be included in the summary statistics for **both**." ], "id_hash": 3640414590896490819, "content_hash": 3640414590896490819, "location": "../../en/joins_advanced.rst:131", "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": 55, "source_unit": "https://weblate.osgeo.org/api/units/100804/?format=api", "priority": 100, "id": 100804, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_advanced/en/?checksum=b28559c85d88c943", "url": "https://weblate.osgeo.org/api/units/100804/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.555812Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_advanced/en/?format=api", "source": [ "To avoid this kind of double counting there are two methods:" ], "previous_source": "", "target": [ "To avoid this kind of double counting there are two methods:" ], "id_hash": 8676361690884726002, "content_hash": 8676361690884726002, "location": "../../en/joins_advanced.rst:135", "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": 11, "source_unit": "https://weblate.osgeo.org/api/units/100806/?format=api", "priority": 100, "id": 100806, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_advanced/en/?checksum=f868a0fd0ffddcf2", "url": "https://weblate.osgeo.org/api/units/100806/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.579104Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_advanced/en/?format=api", "source": [ "The simple method is to ensure that each tract only falls in **one** summary area (using :command:`ST_Centroid(geometry)`)" ], "previous_source": "", "target": [ "The simple method is to ensure that each tract only falls in **one** summary area (using :command:`ST_Centroid(geometry)`)" ], "id_hash": 8848307806311307418, "content_hash": 8848307806311307418, "location": "../../en/joins_advanced.rst:137", "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": 17, "source_unit": "https://weblate.osgeo.org/api/units/100808/?format=api", "priority": 100, "id": 100808, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_advanced/en/?checksum=facb8111ca80589a", "url": "https://weblate.osgeo.org/api/units/100808/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.602074Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_advanced/en/?format=api", "source": [ "The complex method is to divide crossing tracts at the borders (using :command:`ST_Intersection(geometry,geometry)`)" ], "previous_source": "", "target": [ "The complex method is to divide crossing tracts at the borders (using :command:`ST_Intersection(geometry,geometry)`)" ], "id_hash": 2711854175413044844, "content_hash": 2711854175413044844, "location": "../../en/joins_advanced.rst:138", "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": 13, "source_unit": "https://weblate.osgeo.org/api/units/100810/?format=api", "priority": 100, "id": 100810, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_advanced/en/?checksum=a5a271012827866c", "url": "https://weblate.osgeo.org/api/units/100810/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.624763Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_advanced/en/?format=api", "source": [ "Here is an example of using the simple method to avoid double counting in our graduate education query:" ], "previous_source": "", "target": [ "Here is an example of using the simple method to avoid double counting in our graduate education query:" ], "id_hash": -8417425023123261216, "content_hash": -8417425023123261216, "location": "../../en/joins_advanced.rst:140", "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": 18, "source_unit": "https://weblate.osgeo.org/api/units/100812/?format=api", "priority": 100, "id": 100812, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_advanced/en/?checksum=0b2f4c89f540f8e0", "url": "https://weblate.osgeo.org/api/units/100812/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.648031Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_advanced/en/?format=api", "source": [ "Note that the query takes longer to run now, because the :command:`ST_Centroid` function has to be run on every census tract." ], "previous_source": "", "target": [ "Note that the query takes longer to run now, because the :command:`ST_Centroid` function has to be run on every census tract." ], "id_hash": -9170186433521469946, "content_hash": -9170186433521469946, "location": "../../en/joins_advanced.rst:155", "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/100814/?format=api", "priority": 100, "id": 100814, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_advanced/en/?checksum=00bcf40641d8b606", "url": "https://weblate.osgeo.org/api/units/100814/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.671491Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_advanced/en/?format=api", "source": [ "Avoiding double counting changes the results!" ], "previous_source": "", "target": [ "Avoiding double counting changes the results!" ], "id_hash": -6055798861902977539, "content_hash": -6055798861902977539, "location": "../../en/joins_advanced.rst:172", "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": 6, "source_unit": "https://weblate.osgeo.org/api/units/100816/?format=api", "priority": 100, "id": 100816, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_advanced/en/?checksum=2bf57b05250ee5fd", "url": "https://weblate.osgeo.org/api/units/100816/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.694138Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_advanced/en/?format=api", "source": [ "What about Flatbush?" ], "previous_source": "", "target": [ "What about Flatbush?" ], "id_hash": -3065524780926050069, "content_hash": -3065524780926050069, "location": "../../en/joins_advanced.rst:175", "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": 3, "source_unit": "https://weblate.osgeo.org/api/units/100818/?format=api", "priority": 100, "id": 100818, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_advanced/en/?checksum=557511741ebee0eb", "url": "https://weblate.osgeo.org/api/units/100818/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.716656Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_advanced/en/?format=api", "source": [ "In particular, the Flatbush neighborhood has dropped off the list. The reason why can be seen by looking more closely at the map of the Flatbush neighborhood in our table." ], "previous_source": "", "target": [ "In particular, the Flatbush neighborhood has dropped off the list. The reason why can be seen by looking more closely at the map of the Flatbush neighborhood in our table." ], "id_hash": -2120033894125119250, "content_hash": -2120033894125119250, "location": "../../en/joins_advanced.rst:177", "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": 30, "source_unit": "https://weblate.osgeo.org/api/units/100820/?format=api", "priority": 100, "id": 100820, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_advanced/en/?checksum=62942067dce258ee", "url": "https://weblate.osgeo.org/api/units/100820/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.739595Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_advanced/en/?format=api", "source": [ "As defined by our data source, Flatbush is not really a neighborhood in the conventional sense, since it just covers the area of Prospect Park. The census tract for that area records, naturally, zero residents. However, the neighborhood boundary does scrape one of the expensive census tracts bordering the north side of the park (in the gentrified Park Slope neighborhood). When using polygon/polygon tests, this single tract was added to the otherwise empty Flatbush, resulting in the very high score for that query." ], "previous_source": "", "target": [ "As defined by our data source, Flatbush is not really a neighborhood in the conventional sense, since it just covers the area of Prospect Park. The census tract for that area records, naturally, zero residents. However, the neighborhood boundary does scrape one of the expensive census tracts bordering the north side of the park (in the gentrified Park Slope neighborhood). When using polygon/polygon tests, this single tract was added to the otherwise empty Flatbush, resulting in the very high score for that query." ], "id_hash": 3725438071567615755, "content_hash": 3725438071567615755, "location": "../../en/joins_advanced.rst:181", "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": 83, "source_unit": "https://weblate.osgeo.org/api/units/100822/?format=api", "priority": 100, "id": 100822, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_advanced/en/?checksum=b3b36a301881070b", "url": "https://weblate.osgeo.org/api/units/100822/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.762233Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_advanced/en/?format=api", "source": [ "Large Radius Distance Joins" ], "previous_source": "", "target": [ "Large Radius Distance Joins" ], "id_hash": -5445100779960694013, "content_hash": -5445100779960694013, "location": "../../en/joins_advanced.rst:186", "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": 4, "source_unit": "https://weblate.osgeo.org/api/units/100824/?format=api", "priority": 100, "id": 100824, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_advanced/en/?checksum=346f1db0a43d8b03", "url": "https://weblate.osgeo.org/api/units/100824/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.785425Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_advanced/en/?format=api", "source": [ "A query that is fun to ask is \"How do the commute times of people near (within 500 meters) subway stations differ from those of people far away from subway stations?\"" ], "previous_source": "", "target": [ "A query that is fun to ask is \"How do the commute times of people near (within 500 meters) subway stations differ from those of people far away from subway stations?\"" ], "id_hash": -90016852499211448, "content_hash": -90016852499211448, "location": "../../en/joins_advanced.rst:188", "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": 31, "source_unit": "https://weblate.osgeo.org/api/units/100826/?format=api", "priority": 100, "id": 100826, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_advanced/en/?checksum=7ec032264afc5b48", "url": "https://weblate.osgeo.org/api/units/100826/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.807528Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_advanced/en/?format=api", "source": [ "However, the question runs into some problems of double counting: many people will be within 500 meters of multiple subway stations. Compare the population of New York:" ], "previous_source": "", "target": [ "However, the question runs into some problems of double counting: many people will be within 500 meters of multiple subway stations. Compare the population of New York:" ], "id_hash": -434106997040732084, "content_hash": -434106997040732084, "location": "../../en/joins_advanced.rst:190", "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": 27, "source_unit": "https://weblate.osgeo.org/api/units/100829/?format=api", "priority": 100, "id": 100829, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_advanced/en/?checksum=79f9bdfc76e0284c", "url": "https://weblate.osgeo.org/api/units/100829/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.830345Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_advanced/en/?format=api", "source": [ "With the population of the people in New York within 500 meters of a subway station:" ], "previous_source": "", "target": [ "With the population of the people in New York within 500 meters of a subway station:" ], "id_hash": -7447650784629638899, "content_hash": -7447650784629638899, "location": "../../en/joins_advanced.rst:201", "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": 16, "source_unit": "https://weblate.osgeo.org/api/units/100832/?format=api", "priority": 100, "id": 100832, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_advanced/en/?checksum=18a4a1121afdb90d", "url": "https://weblate.osgeo.org/api/units/100832/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.852487Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_advanced/en/?format=api", "source": [ "There's more people close to the subway than there are people! Clearly, our simple SQL is making a big double-counting error. You can see the problem looking at the picture of the buffered subways." ], "previous_source": "", "target": [ "There's more people close to the subway than there are people! Clearly, our simple SQL is making a big double-counting error. You can see the problem looking at the picture of the buffered subways." ], "id_hash": 6520405023545321753, "content_hash": 6520405023545321753, "location": "../../en/joins_advanced.rst:214", "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": 34, "source_unit": "https://weblate.osgeo.org/api/units/100835/?format=api", "priority": 100, "id": 100835, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_advanced/en/?checksum=da7d21d284176919", "url": "https://weblate.osgeo.org/api/units/100835/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.874120Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_advanced/en/?format=api", "source": [ "The solution is to ensure that we have only distinct census blocks before passing them into the summarization portion of the query. We can do that by breaking our query up into a subquery that finds the distinct blocks, wrapped in a summarization query that returns our answer:" ], "previous_source": "", "target": [ "The solution is to ensure that we have only distinct census blocks before passing them into the summarization portion of the query. We can do that by breaking our query up into a subquery that finds the distinct blocks, wrapped in a summarization query that returns our answer:" ], "id_hash": -4653762178163165790, "content_hash": -4653762178163165790, "location": "../../en/joins_advanced.rst:218", "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": 48, "source_unit": "https://weblate.osgeo.org/api/units/100838/?format=api", "priority": 100, "id": 100838, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_advanced/en/?checksum=3f6a83f4a56fb5a2", "url": "https://weblate.osgeo.org/api/units/100838/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.896765Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_advanced/en/?format=api", "source": [ "That's better! So a bit over half the population of New York is within 500m (about a 5-7 minute walk) of the subway." ], "previous_source": "", "target": [ "That's better! So a bit over half the population of New York is within 500m (about a 5-7 minute walk) of the subway." ], "id_hash": 2711214984404221230, "content_hash": 2711214984404221230, "location": "../../en/joins_advanced.rst:235", "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": 23, "source_unit": "https://weblate.osgeo.org/api/units/100841/?format=api", "priority": 100, "id": 100841, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins_advanced/en/?checksum=a5a02ba9e7213d2e", "url": "https://weblate.osgeo.org/api/units/100841/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.919580Z" } ] }