Unit List
Units API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/units/?format=api&page=2
{ "count": 783812, "next": "https://weblate.osgeo.org/api/units/?format=api&page=3", "previous": "https://weblate.osgeo.org/api/units/?format=api", "results": [ { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "In the public schema you can also see all the tables we have created so far in the workshop." ], "previous_source": "", "target": [ "In the public schema you can also see all the tables we have created so far in the workshop." ], "id_hash": 8695137541537991919, "content_hash": 8695137541537991919, "location": "../../en/schemas.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": 19, "source_unit": "https://weblate.osgeo.org/api/units/98042/?format=api", "priority": 100, "id": 98042, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=f8ab558674890cef", "url": "https://weblate.osgeo.org/api/units/98042/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.267188Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "Why use Schemas?" ], "previous_source": "", "target": [ "Why use Schemas?" ], "id_hash": 1052508970105633935, "content_hash": 1052508970105633935, "location": "../../en/schemas.rst:18", "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": 3, "source_unit": "https://weblate.osgeo.org/api/units/98043/?format=api", "priority": 100, "id": 98043, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=8e9b4354f60efc8f", "url": "https://weblate.osgeo.org/api/units/98043/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.296004Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "There are two very good reasons for using schemas:" ], "previous_source": "", "target": [ "There are two very good reasons for using schemas:" ], "id_hash": -1635901640625452398, "content_hash": -1635901640625452398, "location": "../../en/schemas.rst:20", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 7, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://weblate.osgeo.org/api/units/98044/?format=api", "priority": 100, "id": 98044, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=694c1c200f0a8a92", "url": "https://weblate.osgeo.org/api/units/98044/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.321887Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "Data that is managed in a schema is easier to apply bulk actions to." ], "previous_source": "", "target": [ "Data that is managed in a schema is easier to apply bulk actions to." ], "id_hash": -3225587216245516428, "content_hash": -3225587216245516428, "location": "../../en/schemas.rst:22", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 8, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://weblate.osgeo.org/api/units/98045/?format=api", "priority": 100, "id": 98045, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=533c698447a51774", "url": "https://weblate.osgeo.org/api/units/98045/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.345452Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/en/?format=api", "source": [ "Spatial Relationships Exercises" ], "previous_source": "", "target": [ "Spatial Relationships Exercises" ], "id_hash": -4666230909319952095, "content_hash": -4666230909319952095, "location": "../../en/spatial_relationships_exercises.rst:4", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://weblate.osgeo.org/api/units/98046/?format=api", "priority": 100, "id": 98046, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/en/?checksum=3f3e37b5f2094921", "url": "https://weblate.osgeo.org/api/units/98046/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.362241Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "It's easier to back-up data that's in a separate schema: so volatile data can have a different back-up schedule from non-volatile data." ], "previous_source": "", "target": [ "It's easier to back-up data that's in a separate schema: so volatile data can have a different back-up schedule from non-volatile data." ], "id_hash": 7678548437974895935, "content_hash": 7678548437974895935, "location": "../../en/schemas.rst:24", "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": 22, "source_unit": "https://weblate.osgeo.org/api/units/98047/?format=api", "priority": 100, "id": 98047, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=ea8faf1f241fcd3f", "url": "https://weblate.osgeo.org/api/units/98047/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.368502Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "It's easier to restore data that's in a separate schema: so application-oriented schemas can be separately restored and backed up for time travel and recovery." ], "previous_source": "", "target": [ "It's easier to restore data that's in a separate schema: so application-oriented schemas can be separately restored and backed up for time travel and recovery." ], "id_hash": -4853520692566493137, "content_hash": -4853520692566493137, "location": "../../en/schemas.rst:25", "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": 25, "source_unit": "https://weblate.osgeo.org/api/units/98048/?format=api", "priority": 100, "id": 98048, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=3ca4d4a52990f82f", "url": "https://weblate.osgeo.org/api/units/98048/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.392010Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/en/?format=api", "source": [ "Here's a reminder of the functions we saw in the last section. They should be useful for the exercises!" ], "previous_source": "", "target": [ "Here's a reminder of the functions we saw in the last section. They should be useful for the exercises!" ], "id_hash": -914448493331288555, "content_hash": -914448493331288555, "location": "../../en/spatial_relationships_exercises.rst:6", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 2, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://weblate.osgeo.org/api/units/98049/?format=api", "priority": 100, "id": 98049, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/en/?checksum=734f39f0b598ee15", "url": "https://weblate.osgeo.org/api/units/98049/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.398142Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "It's easier to manage application differences when the application data is in a schema: so a new version of software can work off a table structure in a new schema, and cut-over involves a simple change to the schema name." ], "previous_source": "", "target": [ "It's easier to manage application differences when the application data is in a schema: so a new version of software can work off a table structure in a new schema, and cut-over involves a simple change to the schema name." ], "id_hash": 4703619327588052336, "content_hash": 4703619327588052336, "location": "../../en/schemas.rst:26", "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": 40, "source_unit": "https://weblate.osgeo.org/api/units/98050/?format=api", "priority": 100, "id": 98050, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=c1469cdb8b8c2d70", "url": "https://weblate.osgeo.org/api/units/98050/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.414757Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/en/?format=api", "source": [ ":command:`sum(expression)` aggregate to return a sum for a set of records" ], "previous_source": "", "target": [ ":command:`sum(expression)` aggregate to return a sum for a set of records" ], "id_hash": -1020726507756385293, "content_hash": -1020726507756385293, "location": "../../en/spatial_relationships_exercises.rst:8", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 3, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://weblate.osgeo.org/api/units/98051/?format=api", "priority": 100, "id": 98051, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/en/?checksum=71d5a6a6345b0bf3", "url": "https://weblate.osgeo.org/api/units/98051/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.421953Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/clusterindex/en/?format=api", "source": [ "Clustering on Indices" ], "previous_source": "", "target": [ "Clustering on Indices" ], "id_hash": -4346401973050206674, "content_hash": -4346401973050206674, "location": "../../en/clusterindex.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/98052/?format=api", "priority": 100, "id": 98052, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/clusterindex/en/?checksum=43ae7a6f0949162e", "url": "https://weblate.osgeo.org/api/units/98052/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.421765Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "Users can be restricted in their work to single schemas to allow isolation of analytical and test tables from production tables." ], "previous_source": "", "target": [ "Users can be restricted in their work to single schemas to allow isolation of analytical and test tables from production tables." ], "id_hash": -1816223157841303210, "content_hash": -1816223157841303210, "location": "../../en/schemas.rst:28", "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": 21, "source_unit": "https://weblate.osgeo.org/api/units/98053/?format=api", "priority": 100, "id": 98053, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=66cb7aa92407e956", "url": "https://weblate.osgeo.org/api/units/98053/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.438085Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/en/?format=api", "source": [ ":command:`count(expression)` aggregate to return the size of a set of records" ], "previous_source": "", "target": [ ":command:`count(expression)` aggregate to return the size of a set of records" ], "id_hash": 2546828127738688663, "content_hash": 2546828127738688663, "location": "../../en/spatial_relationships_exercises.rst:9", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 4, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://weblate.osgeo.org/api/units/98054/?format=api", "priority": 100, "id": 98054, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/en/?checksum=a35826b041d67497", "url": "https://weblate.osgeo.org/api/units/98054/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.445683Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/clusterindex/en/?format=api", "source": [ "Databases can only retrieve information as fast as they can get it off of disk. Small databases will float up entirely into RAM cache, and get away from physical disk limitations, but for large databases, access to the physical disk will be a limiting stop in disk access speed." ], "previous_source": "", "target": [ "Databases can only retrieve information as fast as they can get it off of disk. Small databases will float up entirely into RAM cache, and get away from physical disk limitations, but for large databases, access to the physical disk will be a limiting stop in disk access speed." ], "id_hash": 1295087543756109786, "content_hash": 1295087543756109786, "location": "../../en/clusterindex.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": 49, "source_unit": "https://weblate.osgeo.org/api/units/98055/?format=api", "priority": 100, "id": 98055, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/clusterindex/en/?checksum=91f91342669db7da", "url": "https://weblate.osgeo.org/api/units/98055/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.453366Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "So for production purposes, keeping your application data separate in schemas improves management; and for user purposes, keeping your users in separate schemas keeps them from treading on each other." ], "previous_source": "", "target": [ "So for production purposes, keeping your application data separate in schemas improves management; and for user purposes, keeping your users in separate schemas keeps them from treading on each other." ], "id_hash": 212467821786474283, "content_hash": 212467821786474283, "location": "../../en/schemas.rst:30", "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": 30, "source_unit": "https://weblate.osgeo.org/api/units/98056/?format=api", "priority": 100, "id": 98056, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=82f2d65bb3c8a72b", "url": "https://weblate.osgeo.org/api/units/98056/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.461286Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/en/?format=api", "source": [ ":command:`ST_Contains(geometry A, geometry B)` returns true if geometry A contains geometry B" ], "previous_source": "", "target": [ ":command:`ST_Contains(geometry A, geometry B)` returns true if geometry A contains geometry B" ], "id_hash": -7721309242972623132, "content_hash": -7721309242972623132, "location": "../../en/spatial_relationships_exercises.rst:10", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 5, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://weblate.osgeo.org/api/units/98057/?format=api", "priority": 100, "id": 98057, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/en/?checksum=14d866271bad2ee4", "url": "https://weblate.osgeo.org/api/units/98057/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.470706Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/clusterindex/en/?format=api", "source": [ "Data is written to disk opportunistically, so there is not necessarily any correlation between the order data is stored on the disk and the way it will be accessed or organized by applications." ], "previous_source": "", "target": [ "Data is written to disk opportunistically, so there is not necessarily any correlation between the order data is stored on the disk and the way it will be accessed or organized by applications." ], "id_hash": 2429495461099896061, "content_hash": 2429495461099896061, "location": "../../en/clusterindex.rst:8", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 3, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://weblate.osgeo.org/api/units/98058/?format=api", "priority": 100, "id": 98058, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/clusterindex/en/?checksum=a1b74d3ff6487cfd", "url": "https://weblate.osgeo.org/api/units/98058/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.477014Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/en/?format=api", "source": [ "Installation" ], "previous_source": "", "target": [ "Installation" ], "id_hash": -3959746046122658226, "content_hash": -3959746046122658226, "location": "../../en/installation.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": 1, "source_unit": "https://weblate.osgeo.org/api/units/98059/?format=api", "priority": 100, "id": 98059, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/en/?checksum=490c27f36019f64e", "url": "https://weblate.osgeo.org/api/units/98059/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.483698Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "Creating a Data Schema" ], "previous_source": "", "target": [ "Creating a Data Schema" ], "id_hash": 7568461229420045468, "content_hash": 7568461229420045468, "location": "../../en/schemas.rst:34", "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": 4, "source_unit": "https://weblate.osgeo.org/api/units/98060/?format=api", "priority": 100, "id": 98060, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=e908936383e5e49c", "url": "https://weblate.osgeo.org/api/units/98060/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.484667Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/en/?format=api", "source": [ ":command:`ST_Crosses(geometry A, geometry B)` returns true if geometry A crosses geometry B" ], "previous_source": "", "target": [ ":command:`ST_Crosses(geometry A, geometry B)` returns true if geometry A crosses geometry B" ], "id_hash": 5578600074370826496, "content_hash": 5578600074370826496, "location": "../../en/spatial_relationships_exercises.rst:11", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 6, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://weblate.osgeo.org/api/units/98061/?format=api", "priority": 100, "id": 98061, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/en/?checksum=cd6b2b3600d74100", "url": "https://weblate.osgeo.org/api/units/98061/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.496578Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/clusterindex/en/?format=api", "source": [ "One way to speed up access to data is to ensure that records which is likely to be retrieved together in the same result set are located in similar physical locations on the hard disk platters. This is called \"clustering\"." ], "previous_source": "", "target": [ "One way to speed up access to data is to ensure that records which is likely to be retrieved together in the same result set are located in similar physical locations on the hard disk platters. This is called \"clustering\"." ], "id_hash": -3600786829566960189, "content_hash": -3600786829566960189, "location": "../../en/clusterindex.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": 40, "source_unit": "https://weblate.osgeo.org/api/units/98062/?format=api", "priority": 100, "id": 98062, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/clusterindex/en/?checksum=4e076f74cfc19dc3", "url": "https://weblate.osgeo.org/api/units/98062/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.500824Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "Let's create a new schema and move a table into it. First, create a new schema in the database:" ], "previous_source": "", "target": [ "Let's create a new schema and move a table into it. First, create a new schema in the database:" ], "id_hash": -279613405728732838, "content_hash": -279613405728732838, "location": "../../en/schemas.rst:36", "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": 19, "source_unit": "https://weblate.osgeo.org/api/units/98063/?format=api", "priority": 100, "id": 98063, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=7c1e9d16c51a095a", "url": "https://weblate.osgeo.org/api/units/98063/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.507567Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/en/?format=api", "source": [ "To explore the PostgreSQL/PostGIS database, and learn about writing spatial queries in SQL, we will need some software, either installed locally or available remotely on the cloud." ], "previous_source": "", "target": [ "To explore the PostgreSQL/PostGIS database, and learn about writing spatial queries in SQL, we will need some software, either installed locally or available remotely on the cloud." ], "id_hash": -1714055629652603552, "content_hash": -1714055629652603552, "location": "../../en/installation.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/98064/?format=api", "priority": 100, "id": 98064, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/en/?checksum=6836737c7d4c4d60", "url": "https://weblate.osgeo.org/api/units/98064/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.519339Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/en/?format=api", "source": [ ":command:`ST_Disjoint(geometry A , geometry B)` returns true if the geometries do not \"spatially intersect\"" ], "previous_source": "", "target": [ ":command:`ST_Disjoint(geometry A , geometry B)` returns true if the geometries do not \"spatially intersect\"" ], "id_hash": 4391678326084475809, "content_hash": 4391678326084475809, "location": "../../en/spatial_relationships_exercises.rst:12", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 7, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://weblate.osgeo.org/api/units/98065/?format=api", "priority": 100, "id": 98065, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/en/?checksum=bcf2602b620c1ba1", "url": "https://weblate.osgeo.org/api/units/98065/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.522988Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/clusterindex/en/?format=api", "source": [ "The right clustering scheme to use can be tricky, but a general rule applies: indexes define a natural ordering scheme for data which is similar to the access pattern that will be used in retrieving the data." ], "previous_source": "", "target": [ "The right clustering scheme to use can be tricky, but a general rule applies: indexes define a natural ordering scheme for data which is similar to the access pattern that will be used in retrieving the data." ], "id_hash": -6321006127397681694, "content_hash": -6321006127397681694, "location": "../../en/clusterindex.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": 37, "source_unit": "https://weblate.osgeo.org/api/units/98066/?format=api", "priority": 100, "id": 98066, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/clusterindex/en/?checksum=2847466ad164c5e2", "url": "https://weblate.osgeo.org/api/units/98066/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.524651Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "Next, we will move the ``nyc_census_blocks`` table to the ``census`` schema:" ], "previous_source": "", "target": [ "Next, we will move the ``nyc_census_blocks`` table to the ``census`` schema:" ], "id_hash": 8464045524879258247, "content_hash": 8464045524879258247, "location": "../../en/schemas.rst:42", "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": 11, "source_unit": "https://weblate.osgeo.org/api/units/98067/?format=api", "priority": 100, "id": 98067, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=f576548f7929b287", "url": "https://weblate.osgeo.org/api/units/98067/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.530535Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/en/?format=api", "source": [ "There are instructions below on how to access PostgreSQL for installation on Windows or MacOS. PostgreSQL for Windows and MacOS either include PostGIS or have an easy way to add it on." ], "previous_source": "", "target": [ "There are instructions below on how to access PostgreSQL for installation on Windows or MacOS. PostgreSQL for Windows and MacOS either include PostGIS or have an easy way to add it on." ], "id_hash": -8645956409205777958, "content_hash": -8645956409205777958, "location": "../../en/installation.rst:8", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 3, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://weblate.osgeo.org/api/units/98068/?format=api", "priority": 100, "id": 98068, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/en/?checksum=080364743dc719da", "url": "https://weblate.osgeo.org/api/units/98068/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.542135Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/en/?format=api", "source": [ ":command:`ST_Distance(geometry A, geometry B)` returns the minimum distance between geometry A and geometry B" ], "previous_source": "", "target": [ ":command:`ST_Distance(geometry A, geometry B)` returns the minimum distance between geometry A and geometry B" ], "id_hash": 7087089013872496991, "content_hash": 7087089013872496991, "location": "../../en/spatial_relationships_exercises.rst:13", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 8, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://weblate.osgeo.org/api/units/98069/?format=api", "priority": 100, "id": 98069, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/en/?checksum=e25a65e8bb71915f", "url": "https://weblate.osgeo.org/api/units/98069/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.547106Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/clusterindex/en/?format=api", "source": [ "Because of this, ordering the data on the disk in the same order as the index can provide a speed advantage in some cases." ], "previous_source": "", "target": [ "Because of this, ordering the data on the disk in the same order as the index can provide a speed advantage in some cases." ], "id_hash": -1339690944101775227, "content_hash": -1339690944101775227, "location": "../../en/clusterindex.rst:20", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 6, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://weblate.osgeo.org/api/units/98070/?format=api", "priority": 100, "id": 98070, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/clusterindex/en/?checksum=6d68762f30018885", "url": "https://weblate.osgeo.org/api/units/98070/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.548641Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "If you're using the :command:`psql` command-line program, you'll notice that ``nyc_census_blocks`` has disappeared from your table listing now! If you're using PgAdmin, you might have to refresh your view to see the new schema and the table inside it." ], "previous_source": "", "target": [ "If you're using the :command:`psql` command-line program, you'll notice that ``nyc_census_blocks`` has disappeared from your table listing now! If you're using PgAdmin, you might have to refresh your view to see the new schema and the table inside it." ], "id_hash": 1436805870175200359, "content_hash": 1436805870175200359, "location": "../../en/schemas.rst:48", "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": 39, "source_unit": "https://weblate.osgeo.org/api/units/98071/?format=api", "priority": 100, "id": 98071, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=93f08f538efd2467", "url": "https://weblate.osgeo.org/api/units/98071/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.553213Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/en/?format=api", "source": [ "There are instructions below on how to install `PgAdmin <https://www.pgadmin.org/>`_. PgAdmin is a graphical database explorer and SQL editor which provides a \"user facing\" interface to the database engine that does all the world." ], "previous_source": "", "target": [ "There are instructions below on how to install `PgAdmin <https://www.pgadmin.org/>`_. PgAdmin is a graphical database explorer and SQL editor which provides a \"user facing\" interface to the database engine that does all the world." ], "id_hash": -188319640073046668, "content_hash": -188319640073046668, "location": "../../en/installation.rst:9", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 4, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://weblate.osgeo.org/api/units/98072/?format=api", "priority": 100, "id": 98072, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/en/?checksum=7d62f448fd377574", "url": "https://weblate.osgeo.org/api/units/98072/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.565088Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/en/?format=api", "source": [ ":command:`ST_DWithin(geometry A, geometry B, radius)` returns true if geometry A is radius distance or less from geometry B" ], "previous_source": "", "target": [ ":command:`ST_DWithin(geometry A, geometry B, radius)` returns true if geometry A is radius distance or less from geometry B" ], "id_hash": 7582434958965590212, "content_hash": 7582434958965590212, "location": "../../en/spatial_relationships_exercises.rst:14", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 9, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://weblate.osgeo.org/api/units/98073/?format=api", "priority": 100, "id": 98073, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/en/?checksum=e93a386bf5a5c8c4", "url": "https://weblate.osgeo.org/api/units/98073/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.570533Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/clusterindex/en/?format=api", "source": [ "Clustering on the R-Tree" ], "previous_source": "", "target": [ "Clustering on the R-Tree" ], "id_hash": -3500876434757799414, "content_hash": -3500876434757799414, "location": "../../en/clusterindex.rst:23", "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": 4, "source_unit": "https://weblate.osgeo.org/api/units/98074/?format=api", "priority": 100, "id": 98074, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/clusterindex/en/?checksum=4f6a636e57b9b20a", "url": "https://weblate.osgeo.org/api/units/98074/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.572044Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "You can access tables inside schemas in two ways:" ], "previous_source": "", "target": [ "You can access tables inside schemas in two ways:" ], "id_hash": -8600915504822134896, "content_hash": -8600915504822134896, "location": "../../en/schemas.rst:50", "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": 9, "source_unit": "https://weblate.osgeo.org/api/units/98075/?format=api", "priority": 100, "id": 98075, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=08a368eaffed5790", "url": "https://weblate.osgeo.org/api/units/98075/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.576555Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/en/?format=api", "source": [ "For always up-to-date directions on installing PostgreSQL, go to the `PostgreSQL download page <https://www.postgresql.org/download/>`_ and select the operating system you are using." ], "previous_source": "", "target": [ "For always up-to-date directions on installing PostgreSQL, go to the `PostgreSQL download page <https://www.postgresql.org/download/>`_ and select the operating system you are using." ], "id_hash": -649280775685351699, "content_hash": -649280775685351699, "location": "../../en/installation.rst:11", "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": 22, "source_unit": "https://weblate.osgeo.org/api/units/98076/?format=api", "priority": 100, "id": 98076, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/en/?checksum=76fd4a9315c8d6ed", "url": "https://weblate.osgeo.org/api/units/98076/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.587635Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/en/?format=api", "source": [ ":command:`ST_Equals(geometry A, geometry B)` returns true if geometry A is the same as geometry B" ], "previous_source": "", "target": [ ":command:`ST_Equals(geometry A, geometry B)` returns true if geometry A is the same as geometry B" ], "id_hash": -801899052372634229, "content_hash": -801899052372634229, "location": "../../en/spatial_relationships_exercises.rst:15", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 10, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://weblate.osgeo.org/api/units/98077/?format=api", "priority": 100, "id": 98077, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/en/?checksum=74df150f7d9b558b", "url": "https://weblate.osgeo.org/api/units/98077/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.594165Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/clusterindex/en/?format=api", "source": [ "Spatial data tends to be accessed in spatially correlated windows: think of the map window in a web or desktop application. All the data in the windows has similar location value (or it wouldn't be in the window!)" ], "previous_source": "", "target": [ "Spatial data tends to be accessed in spatially correlated windows: think of the map window in a web or desktop application. All the data in the windows has similar location value (or it wouldn't be in the window!)" ], "id_hash": 6082353535378252836, "content_hash": 6082353535378252836, "location": "../../en/clusterindex.rst:25", "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": 38, "source_unit": "https://weblate.osgeo.org/api/units/98078/?format=api", "priority": 100, "id": 98078, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/clusterindex/en/?checksum=d468dc50928fe424", "url": "https://weblate.osgeo.org/api/units/98078/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.594939Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "by referencing them using ``schema.table`` notation" ], "previous_source": "", "target": [ "by referencing them using ``schema.table`` notation" ], "id_hash": 4184222717610201623, "content_hash": 4184222717610201623, "location": "../../en/schemas.rst:52", "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": 6, "source_unit": "https://weblate.osgeo.org/api/units/98079/?format=api", "priority": 100, "id": 98079, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=ba11586488469217", "url": "https://weblate.osgeo.org/api/units/98079/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.599383Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/en/?format=api", "source": [ "PostgreSQL for Microsoft Windows" ], "previous_source": "", "target": [ "PostgreSQL for Microsoft Windows" ], "id_hash": -2592733842513398091, "content_hash": -2592733842513398091, "location": "../../en/installation.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": 4, "source_unit": "https://weblate.osgeo.org/api/units/98080/?format=api", "priority": 100, "id": 98080, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/en/?checksum=5c04c24e9fdaf6b5", "url": "https://weblate.osgeo.org/api/units/98080/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.610345Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/en/?format=api", "source": [ ":command:`ST_Intersects(geometry A, geometry B)` returns true if geometry A intersects geometry B" ], "previous_source": "", "target": [ ":command:`ST_Intersects(geometry A, geometry B)` returns true if geometry A intersects geometry B" ], "id_hash": 4171181830668624899, "content_hash": 4171181830668624899, "location": "../../en/spatial_relationships_exercises.rst:16", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 11, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://weblate.osgeo.org/api/units/98081/?format=api", "priority": 100, "id": 98081, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/en/?checksum=b9e303c66e912403", "url": "https://weblate.osgeo.org/api/units/98081/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.617100Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/clusterindex/en/?format=api", "source": [ "So, clustering based on a spatial index makes sense for spatial data that is going to be accessed with spatial queries: similar things tend to have similar locations." ], "previous_source": "", "target": [ "So, clustering based on a spatial index makes sense for spatial data that is going to be accessed with spatial queries: similar things tend to have similar locations." ], "id_hash": 2246219023358421029, "content_hash": 2246219023358421029, "location": "../../en/clusterindex.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": 28, "source_unit": "https://weblate.osgeo.org/api/units/98082/?format=api", "priority": 100, "id": 98082, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/clusterindex/en/?checksum=9f2c2c4cff00e825", "url": "https://weblate.osgeo.org/api/units/98082/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.618085Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "by adding the schema to your ``search_path``" ], "previous_source": "", "target": [ "by adding the schema to your ``search_path``" ], "id_hash": 788069461238815375, "content_hash": 788069461238815375, "location": "../../en/schemas.rst:53", "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": 7, "source_unit": "https://weblate.osgeo.org/api/units/98083/?format=api", "priority": 100, "id": 98083, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=8aefc8ffe7791a8f", "url": "https://weblate.osgeo.org/api/units/98083/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.622173Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/en/?format=api", "source": [ "For a Windows install:" ], "previous_source": "", "target": [ "For a Windows install:" ], "id_hash": 4283678020284972700, "content_hash": 4283678020284972700, "location": "../../en/installation.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": 4, "source_unit": "https://weblate.osgeo.org/api/units/98084/?format=api", "priority": 100, "id": 98084, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/en/?checksum=bb72ae76ab3bfe9c", "url": "https://weblate.osgeo.org/api/units/98084/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.632665Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/en/?format=api", "source": [ ":command:`ST_Overlaps(geometry A, geometry B)` returns true if geometry A and geometry B share space, but are not completely contained by each other." ], "previous_source": "", "target": [ ":command:`ST_Overlaps(geometry A, geometry B)` returns true if geometry A and geometry B share space, but are not completely contained by each other." ], "id_hash": -3680407313083740575, "content_hash": -3680407313083740575, "location": "../../en/spatial_relationships_exercises.rst:17", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 12, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://weblate.osgeo.org/api/units/98085/?format=api", "priority": 100, "id": 98085, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/en/?checksum=4cec910c62e4ce61", "url": "https://weblate.osgeo.org/api/units/98085/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.639813Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/clusterindex/en/?format=api", "source": [ "Let's cluster our ``nyc_census_blocks`` based on their spatial index:" ], "previous_source": "", "target": [ "Let's cluster our ``nyc_census_blocks`` based on their spatial index:" ], "id_hash": -1738337983529182516, "content_hash": -1738337983529182516, "location": "../../en/clusterindex.rst:29", "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": 9, "source_unit": "https://weblate.osgeo.org/api/units/98086/?format=api", "priority": 100, "id": 98086, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/clusterindex/en/?checksum=67e02ed0682c9acc", "url": "https://weblate.osgeo.org/api/units/98086/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.640571Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "Explicit referencing is easy, but it gets tiring to type after a while:" ], "previous_source": "", "target": [ "Explicit referencing is easy, but it gets tiring to type after a while:" ], "id_hash": 5451639701760265941, "content_hash": 5451639701760265941, "location": "../../en/schemas.rst:55", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 21, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://weblate.osgeo.org/api/units/98087/?format=api", "priority": 100, "id": 98087, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=cba81d6cbad64ed5", "url": "https://weblate.osgeo.org/api/units/98087/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.645506Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/en/?format=api", "source": [ "Go to the `Windows PostgreSQL download page <https://www.enterprisedb.com/downloads/postgres-postgresql-downloads>`_." ], "previous_source": "", "target": [ "Go to the `Windows PostgreSQL download page <https://www.enterprisedb.com/downloads/postgres-postgresql-downloads>`_." ], "id_hash": 5758989352120956278, "content_hash": 5758989352120956278, "location": "../../en/installation.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/98088/?format=api", "priority": 100, "id": 98088, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/en/?checksum=cfec0a4da66d3576", "url": "https://weblate.osgeo.org/api/units/98088/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.655149Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/en/?format=api", "source": [ ":command:`ST_Touches(geometry A, geometry B)` returns true if the boundary of geometry A touches geometry B" ], "previous_source": "", "target": [ ":command:`ST_Touches(geometry A, geometry B)` returns true if the boundary of geometry A touches geometry B" ], "id_hash": 8996529351994791185, "content_hash": 8996529351994791185, "location": "../../en/spatial_relationships_exercises.rst:18", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 13, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://weblate.osgeo.org/api/units/98089/?format=api", "priority": 100, "id": 98089, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/en/?checksum=fcda17c7ad065511", "url": "https://weblate.osgeo.org/api/units/98089/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.662545Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "Manipulating the ``search_path`` is a nice way to provide access to tables in multiple schemas without lots of extra typing." ], "previous_source": "", "target": [ "Manipulating the ``search_path`` is a nice way to provide access to tables in multiple schemas without lots of extra typing." ], "id_hash": -8766865489712415021, "content_hash": -8766865489712415021, "location": "../../en/schemas.rst:61", "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": 20, "source_unit": "https://weblate.osgeo.org/api/units/98091/?format=api", "priority": 100, "id": 98091, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=0655d649340f7ed3", "url": "https://weblate.osgeo.org/api/units/98091/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.668292Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/en/?format=api", "source": [ "Select the latest version of PostgreSQL and save the installer to disk." ], "previous_source": "", "target": [ "Select the latest version of PostgreSQL and save the installer to disk." ], "id_hash": -9184842678157571158, "content_hash": -9184842678157571158, "location": "../../en/installation.rst:21", "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": 12, "source_unit": "https://weblate.osgeo.org/api/units/98092/?format=api", "priority": 100, "id": 98092, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/en/?checksum=0088e23f62920baa", "url": "https://weblate.osgeo.org/api/units/98092/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.678570Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/en/?format=api", "source": [ ":command:`ST_Within(geometry A, geometry B)` returns true if geometry A is within geometry B" ], "previous_source": "", "target": [ ":command:`ST_Within(geometry A, geometry B)` returns true if geometry A is within geometry B" ], "id_hash": -1114080780013847962, "content_hash": -1114080780013847962, "location": "../../en/spatial_relationships_exercises.rst:19", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 14, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://weblate.osgeo.org/api/units/98093/?format=api", "priority": 100, "id": 98093, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/en/?checksum=7089fd6ee82f3a66", "url": "https://weblate.osgeo.org/api/units/98093/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.685018Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "You can set the ``search_path`` at run time using the ``SET`` command:" ], "previous_source": "", "target": [ "You can set the ``search_path`` at run time using the ``SET`` command:" ], "id_hash": 6261257118765750880, "content_hash": 6261257118765750880, "location": "../../en/schemas.rst:63", "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": 12, "source_unit": "https://weblate.osgeo.org/api/units/98095/?format=api", "priority": 100, "id": 98095, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=d6e4742d0b6b1a60", "url": "https://weblate.osgeo.org/api/units/98095/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.690962Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/en/?format=api", "source": [ "Run the installer and accept the defaults." ], "previous_source": "", "target": [ "Run the installer and accept the defaults." ], "id_hash": 5467413961897680895, "content_hash": 5467413961897680895, "location": "../../en/installation.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": 7, "source_unit": "https://weblate.osgeo.org/api/units/98096/?format=api", "priority": 100, "id": 98096, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/en/?checksum=cbe02807deec1fff", "url": "https://weblate.osgeo.org/api/units/98096/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.700871Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/en/?format=api", "source": [ "Also remember the tables we have available:" ], "previous_source": "", "target": [ "Also remember the tables we have available:" ], "id_hash": 2887433863364510331, "content_hash": 2887433863364510331, "location": "../../en/spatial_relationships_exercises.rst:21", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 15, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://weblate.osgeo.org/api/units/98097/?format=api", "priority": 100, "id": 98097, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/en/?checksum=a81239ccea46827b", "url": "https://weblate.osgeo.org/api/units/98097/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.707624Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "This ensures that all references to relations and functions are searched in both the ``census`` and the ``public`` schemas. Remember that all the PostGIS functions and types are in ``public`` so we don't want to drop that from the search path." ], "previous_source": "", "target": [ "This ensures that all references to relations and functions are searched in both the ``census`` and the ``public`` schemas. Remember that all the PostGIS functions and types are in ``public`` so we don't want to drop that from the search path." ], "id_hash": -7875221711749531039, "content_hash": -7875221711749531039, "location": "../../en/schemas.rst:69", "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": 41, "source_unit": "https://weblate.osgeo.org/api/units/98099/?format=api", "priority": 100, "id": 98099, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=12b59793efb9ba61", "url": "https://weblate.osgeo.org/api/units/98099/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.713230Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/en/?format=api", "source": [ "Find and run the \"StackBuilder\" program that was installed with the database." ], "previous_source": "", "target": [ "Find and run the \"StackBuilder\" program that was installed with the database." ], "id_hash": 8185905482281552012, "content_hash": 8185905482281552012, "location": "../../en/installation.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": 12, "source_unit": "https://weblate.osgeo.org/api/units/98100/?format=api", "priority": 100, "id": 98100, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/en/?checksum=f19a2daa5450888c", "url": "https://weblate.osgeo.org/api/units/98100/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.722942Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/en/?format=api", "source": [ "``nyc_census_blocks``" ], "previous_source": "", "target": [ "``nyc_census_blocks``" ], "id_hash": -3025002096340458652, "content_hash": -3025002096340458652, "location": "../../en/spatial_relationships_exercises.rst:23", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 16, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/98102/?format=api", "priority": 100, "id": 98102, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/en/?checksum=5605089edad0a364", "url": "https://weblate.osgeo.org/api/units/98102/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.729761Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "Setting the search path every time you connect can get tiring too, but fortunately it's possible to permanently set the search path for a user:" ], "previous_source": "", "target": [ "Setting the search path every time you connect can get tiring too, but fortunately it's possible to permanently set the search path for a user:" ], "id_hash": -2639337842923577153, "content_hash": -2639337842923577153, "location": "../../en/schemas.rst:71", "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": 25, "source_unit": "https://weblate.osgeo.org/api/units/98103/?format=api", "priority": 100, "id": 98103, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=5b5f3037364b60bf", "url": "https://weblate.osgeo.org/api/units/98103/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.735679Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/en/?format=api", "source": [ "Select the \"Spatial Extensions\" section and choose latest \"PostGIS ..Bundle\" option." ], "previous_source": "", "target": [ "Select the \"Spatial Extensions\" section and choose latest \"PostGIS ..Bundle\" option." ], "id_hash": 1603893007130196785, "content_hash": 1603893007130196785, "location": "../../en/installation.rst:27", "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/98104/?format=api", "priority": 100, "id": 98104, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/en/?checksum=96422c3133ba7b31", "url": "https://weblate.osgeo.org/api/units/98104/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.746092Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/en/?format=api", "source": [ "blkid, popn_total, boroname, geom" ], "previous_source": "", "target": [ "blkid, popn_total, boroname, geom" ], "id_hash": -7922362892942442027, "content_hash": -7922362892942442027, "location": "../../en/spatial_relationships_exercises.rst:25", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 17, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 4, "source_unit": "https://weblate.osgeo.org/api/units/98105/?format=api", "priority": 100, "id": 98105, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/en/?checksum=120e1cec606e01d5", "url": "https://weblate.osgeo.org/api/units/98105/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.752198Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "Now the postgres user will always have the ``census`` schema in their search path." ], "previous_source": "", "target": [ "Now the postgres user will always have the ``census`` schema in their search path." ], "id_hash": -4405374113662166495, "content_hash": -4405374113662166495, "location": "../../en/schemas.rst:77", "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": 14, "source_unit": "https://weblate.osgeo.org/api/units/98107/?format=api", "priority": 100, "id": 98107, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=42dcf79594771a21", "url": "https://weblate.osgeo.org/api/units/98107/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.758033Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/en/?format=api", "source": [ "Accept the defaults and install." ], "previous_source": "", "target": [ "Accept the defaults and install." ], "id_hash": -2358525550891236173, "content_hash": -2358525550891236173, "location": "../../en/installation.rst:32", "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/98108/?format=api", "priority": 100, "id": 98108, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/en/?checksum=5f44d581e97204b3", "url": "https://weblate.osgeo.org/api/units/98108/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.768291Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/en/?format=api", "source": [ "``nyc_streets``" ], "previous_source": "", "target": [ "``nyc_streets``" ], "id_hash": 2609392578440045565, "content_hash": 2609392578440045565, "location": "../../en/spatial_relationships_exercises.rst:27", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 18, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/98109/?format=api", "priority": 100, "id": 98109, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/en/?checksum=a4366cb99575a3fd", "url": "https://weblate.osgeo.org/api/units/98109/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.775427Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "Creating a User Schema" ], "previous_source": "", "target": [ "Creating a User Schema" ], "id_hash": 3047927684053294564, "content_hash": 3047927684053294564, "location": "../../en/schemas.rst:81", "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": 4, "source_unit": "https://weblate.osgeo.org/api/units/98111/?format=api", "priority": 100, "id": 98111, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=aa4c6a147d135de4", "url": "https://weblate.osgeo.org/api/units/98111/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.779867Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/en/?format=api", "source": [ "PostgreSQL for Apple MacOS" ], "previous_source": "", "target": [ "PostgreSQL for Apple MacOS" ], "id_hash": 4268814684739276314, "content_hash": 4268814684739276314, "location": "../../en/installation.rst:36", "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": 4, "source_unit": "https://weblate.osgeo.org/api/units/98112/?format=api", "priority": 100, "id": 98112, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/en/?checksum=bb3de056afdb0e1a", "url": "https://weblate.osgeo.org/api/units/98112/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.790905Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/en/?format=api", "source": [ "name, type, geom" ], "previous_source": "", "target": [ "name, type, geom" ], "id_hash": 6604575797723661680, "content_hash": 6604575797723661680, "location": "../../en/spatial_relationships_exercises.rst:29", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 19, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 3, "source_unit": "https://weblate.osgeo.org/api/units/98113/?format=api", "priority": 100, "id": 98113, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/en/?checksum=dba82ab20b760570", "url": "https://weblate.osgeo.org/api/units/98113/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.799067Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "Users like to create tables, and PostGIS users do so particularly: analysis operations with SQL demand temporary tables for visualization or interim results, so spatial SQL tends to require that users have CREATE privileges more than ordinary database workloads." ], "previous_source": "", "target": [ "Users like to create tables, and PostGIS users do so particularly: analysis operations with SQL demand temporary tables for visualization or interim results, so spatial SQL tends to require that users have CREATE privileges more than ordinary database workloads." ], "id_hash": -2034115669987581779, "content_hash": -2034115669987581779, "location": "../../en/schemas.rst:83", "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": 39, "source_unit": "https://weblate.osgeo.org/api/units/98115/?format=api", "priority": 100, "id": 98115, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=63c55e934a55a0ad", "url": "https://weblate.osgeo.org/api/units/98115/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.802307Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/en/?format=api", "source": [ "For a MacOS install:" ], "previous_source": "", "target": [ "For a MacOS install:" ], "id_hash": 2940029150869453330, "content_hash": 2940029150869453330, "location": "../../en/installation.rst:38", "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": 4, "source_unit": "https://weblate.osgeo.org/api/units/98116/?format=api", "priority": 100, "id": 98116, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/en/?checksum=a8cd14ef8eddfa12", "url": "https://weblate.osgeo.org/api/units/98116/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.813308Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/en/?format=api", "source": [ "``nyc_subway_stations``" ], "previous_source": "", "target": [ "``nyc_subway_stations``" ], "id_hash": 6679113862865211847, "content_hash": 6679113862865211847, "location": "../../en/spatial_relationships_exercises.rst:31", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 20, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/98117/?format=api", "priority": 100, "id": 98117, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/en/?checksum=dcb0faabba77d1c7", "url": "https://weblate.osgeo.org/api/units/98117/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.821524Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "By default, every role in Oracle is given a personal schema. This is a nice practice to use for PostgreSQL users too, and is easy to replicate using PostgreSQL roles, schemas, and search paths." ], "previous_source": "", "target": [ "By default, every role in Oracle is given a personal schema. This is a nice practice to use for PostgreSQL users too, and is easy to replicate using PostgreSQL roles, schemas, and search paths." ], "id_hash": -1237469761498094955, "content_hash": -1237469761498094955, "location": "../../en/schemas.rst:85", "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": 34, "source_unit": "https://weblate.osgeo.org/api/units/98119/?format=api", "priority": 100, "id": 98119, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=6ed39fceed9e6295", "url": "https://weblate.osgeo.org/api/units/98119/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.824693Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/en/?format=api", "source": [ "Go to the `Postgres.app <https://postgresapp.com/>`_ site, and download the latest release." ], "previous_source": "", "target": [ "Go to the `Postgres.app <https://postgresapp.com/>`_ site, and download the latest release." ], "id_hash": 2155204446861859309, "content_hash": 2155204446861859309, "location": "../../en/installation.rst:40", "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": 11, "source_unit": "https://weblate.osgeo.org/api/units/98120/?format=api", "priority": 100, "id": 98120, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/en/?checksum=9de8d306918b19ed", "url": "https://weblate.osgeo.org/api/units/98120/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.835582Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/en/?format=api", "source": [ "name, geom" ], "previous_source": "", "target": [ "name, geom" ], "id_hash": 7505500002104016843, "content_hash": 7505500002104016843, "location": "../../en/spatial_relationships_exercises.rst:33", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 21, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 2, "source_unit": "https://weblate.osgeo.org/api/units/98121/?format=api", "priority": 100, "id": 98121, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/en/?checksum=e828e47c6f1a7fcb", "url": "https://weblate.osgeo.org/api/units/98121/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.844100Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "Create a new user with table creation privileges (see :ref:`security` for information about the ``postgis_writer`` role), then create a schema with that user as the authorization:" ], "previous_source": "", "target": [ "Create a new user with table creation privileges (see :ref:`security` for information about the ``postgis_writer`` role), then create a schema with that user as the authorization:" ], "id_hash": 6955049323959501885, "content_hash": 6955049323959501885, "location": "../../en/schemas.rst:87", "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": 26, "source_unit": "https://weblate.osgeo.org/api/units/98123/?format=api", "priority": 100, "id": 98123, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=e0854c82bded443d", "url": "https://weblate.osgeo.org/api/units/98123/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.847230Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/en/?format=api", "source": [ "Open the disk image, and drag the **Postgres** icon into the **Applications** folder." ], "previous_source": "", "target": [ "Open the disk image, and drag the **Postgres** icon into the **Applications** folder." ], "id_hash": -1157008299630404153, "content_hash": -1157008299630404153, "location": "../../en/installation.rst:42", "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": 13, "source_unit": "https://weblate.osgeo.org/api/units/98124/?format=api", "priority": 100, "id": 98124, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/en/?checksum=6ff17b14e259ddc7", "url": "https://weblate.osgeo.org/api/units/98124/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.858329Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/en/?format=api", "source": [ "``nyc_neighborhoods``" ], "previous_source": "", "target": [ "``nyc_neighborhoods``" ], "id_hash": 7631548142037648666, "content_hash": 7631548142037648666, "location": "../../en/spatial_relationships_exercises.rst:35", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 22, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/98125/?format=api", "priority": 100, "id": 98125, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/en/?checksum=e9e8b499fc72451a", "url": "https://weblate.osgeo.org/api/units/98125/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.866330Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/clusterindex/en/?format=api", "source": [ "Function List" ], "previous_source": "", "target": [ "Function List" ], "id_hash": 2815949782297668712, "content_hash": 2815949782297668712, "location": "../../en/clusterindex.rst:61", "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": 2, "source_unit": "https://weblate.osgeo.org/api/units/98126/?format=api", "priority": 100, "id": 98126, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/clusterindex/en/?checksum=a71443684f30ec68", "url": "https://weblate.osgeo.org/api/units/98126/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.867297Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "If you log in as that user, you'll find the default ``search_path`` for PostgreSQL is actually this:" ], "previous_source": "", "target": [ "If you log in as that user, you'll find the default ``search_path`` for PostgreSQL is actually this:" ], "id_hash": 7750240245039702294, "content_hash": 7750240245039702294, "location": "../../en/schemas.rst:94", "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": 17, "source_unit": "https://weblate.osgeo.org/api/units/98127/?format=api", "priority": 100, "id": 98127, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=eb8e6270b9872116", "url": "https://weblate.osgeo.org/api/units/98127/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.869285Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/en/?format=api", "source": [ "In the **Applications** folder, double-click the **Postgres** icon to start the server." ], "previous_source": "", "target": [ "In the **Applications** folder, double-click the **Postgres** icon to start the server." ], "id_hash": -5469349182078464079, "content_hash": -5469349182078464079, "location": "../../en/installation.rst:47", "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": 12, "source_unit": "https://weblate.osgeo.org/api/units/98128/?format=api", "priority": 100, "id": 98128, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/en/?checksum=3418f7e591a3cfb1", "url": "https://weblate.osgeo.org/api/units/98128/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.880649Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/en/?format=api", "source": [ "name, boroname, geom" ], "previous_source": "", "target": [ "name, boroname, geom" ], "id_hash": 236775198660524252, "content_hash": 236775198660524252, "location": "../../en/spatial_relationships_exercises.rst:37", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 23, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 3, "source_unit": "https://weblate.osgeo.org/api/units/98129/?format=api", "priority": 100, "id": 98129, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/en/?checksum=834931c9e7c878dc", "url": "https://weblate.osgeo.org/api/units/98129/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.888428Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "The first schema on the search path us the user's named schema! So now the following conditions exist:" ], "previous_source": "", "target": [ "The first schema on the search path us the user's named schema! So now the following conditions exist:" ], "id_hash": 3280979363715958380, "content_hash": 3280979363715958380, "location": "../../en/schemas.rst:106", "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/98131/?format=api", "priority": 100, "id": 98131, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=ad88615911ad466c", "url": "https://weblate.osgeo.org/api/units/98131/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.891050Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/en/?format=api", "source": [ "Click the **Initialize** button to create a new blank database instance." ], "previous_source": "", "target": [ "Click the **Initialize** button to create a new blank database instance." ], "id_hash": -4652394043697558133, "content_hash": -4652394043697558133, "location": "../../en/installation.rst:49", "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": 11, "source_unit": "https://weblate.osgeo.org/api/units/98132/?format=api", "priority": 100, "id": 98132, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/en/?checksum=3f6f604446438d8b", "url": "https://weblate.osgeo.org/api/units/98132/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.902594Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/en/?format=api", "source": [ "Exercises" ], "previous_source": "", "target": [ "Exercises" ], "id_hash": -7091084141687761545, "content_hash": -7091084141687761545, "location": "../../en/spatial_relationships_exercises.rst:40", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 24, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/98133/?format=api", "priority": 100, "id": 98133, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/en/?checksum=1d97688b164b9577", "url": "https://weblate.osgeo.org/api/units/98133/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.910589Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "The user exists, with the ability to create spatial tables." ], "previous_source": "", "target": [ "The user exists, with the ability to create spatial tables." ], "id_hash": -2722499917199656732, "content_hash": -2722499917199656732, "location": "../../en/schemas.rst:108", "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": 10, "source_unit": "https://weblate.osgeo.org/api/units/98134/?format=api", "priority": 100, "id": 98134, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=5a37bcbfee48b8e4", "url": "https://weblate.osgeo.org/api/units/98134/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.913147Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/en/?format=api", "source": [ "In the **Applications** folder, go to the **Utilities** folder and open **Terminal**." ], "previous_source": "", "target": [ "In the **Applications** folder, go to the **Utilities** folder and open **Terminal**." ], "id_hash": 5674422533494681631, "content_hash": 5674422533494681631, "location": "../../en/installation.rst:54", "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/98135/?format=api", "priority": 100, "id": 98135, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/en/?checksum=cebf993ad66c301f", "url": "https://weblate.osgeo.org/api/units/98135/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.924789Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/en/?format=api", "source": [ "**What is the geometry value for the street named 'Atlantic Commons'?**" ], "previous_source": "", "target": [ "**What is the geometry value for the street named 'Atlantic Commons'?**" ], "id_hash": -4743593144360516935, "content_hash": -4743593144360516935, "location": "../../en/spatial_relationships_exercises.rst:42", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 25, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://weblate.osgeo.org/api/units/98136/?format=api", "priority": 100, "id": 98136, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/en/?checksum=3e2b5f2af769c2b9", "url": "https://weblate.osgeo.org/api/units/98136/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.933407Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "The user's named schema exists, and the user owns it." ], "previous_source": "", "target": [ "The user's named schema exists, and the user owns it." ], "id_hash": 1323214385234670449, "content_hash": 1323214385234670449, "location": "../../en/schemas.rst:109", "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": 10, "source_unit": "https://weblate.osgeo.org/api/units/98137/?format=api", "priority": 100, "id": 98137, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=925d007901997371", "url": "https://weblate.osgeo.org/api/units/98137/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.934975Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/en/?format=api", "source": [ "Add the command-line utilities to your `PATH` for convenience." ], "previous_source": "", "target": [ "Add the command-line utilities to your `PATH` for convenience." ], "id_hash": -6825520350773037763, "content_hash": -6825520350773037763, "location": "../../en/installation.rst:56", "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": 9, "source_unit": "https://weblate.osgeo.org/api/units/98138/?format=api", "priority": 100, "id": 98138, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/en/?checksum=2146e16774f9353d", "url": "https://weblate.osgeo.org/api/units/98138/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.947326Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/en/?format=api", "source": [ "**What neighborhood and borough is Atlantic Commons in?**" ], "previous_source": "", "target": [ "**What neighborhood and borough is Atlantic Commons in?**" ], "id_hash": -1201137509290988304, "content_hash": -1201137509290988304, "location": "../../en/spatial_relationships_exercises.rst:54", "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": 8, "source_unit": "https://weblate.osgeo.org/api/units/98139/?format=api", "priority": 100, "id": 98139, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/en/?checksum=6f54b3cc98502cf0", "url": "https://weblate.osgeo.org/api/units/98139/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.956058Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "The user's search path has the user schema first, so new tables are automatically created there, and queries automatically search there first." ], "previous_source": "", "target": [ "The user's search path has the user schema first, so new tables are automatically created there, and queries automatically search there first." ], "id_hash": 4302773267715094602, "content_hash": 4302773267715094602, "location": "../../en/schemas.rst:110", "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": 22, "source_unit": "https://weblate.osgeo.org/api/units/98140/?format=api", "priority": 100, "id": 98140, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=bbb6857d6b34784a", "url": "https://weblate.osgeo.org/api/units/98140/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.957059Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/en/?format=api", "source": [ "PgAdmin for Windows and MacOS" ], "previous_source": "", "target": [ "PgAdmin for Windows and MacOS" ], "id_hash": 9092307591548700150, "content_hash": 9092307591548700150, "location": "../../en/installation.rst:65", "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": 5, "source_unit": "https://weblate.osgeo.org/api/units/98141/?format=api", "priority": 100, "id": 98141, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/en/?checksum=fe2e5d94d6d905f6", "url": "https://weblate.osgeo.org/api/units/98141/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.969705Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/en/?format=api", "source": [ "That's all there is to it, the user's default work area is now nicely separated from any tables in other schemas." ], "previous_source": "", "target": [ "That's all there is to it, the user's default work area is now nicely separated from any tables in other schemas." ], "id_hash": 898247385090668541, "content_hash": 898247385090668541, "location": "../../en/schemas.rst:112", "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": 21, "source_unit": "https://weblate.osgeo.org/api/units/98142/?format=api", "priority": 100, "id": 98142, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/en/?checksum=8c77373cd4c0b7fd", "url": "https://weblate.osgeo.org/api/units/98142/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.979911Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/en/?format=api", "source": [ "\"Hey, why did you change from a 'MULTILINESTRING' to a 'LINESTRING'?\" Spatially they describe the same shape, so going from a single-item multi-geometry to a singleton saves a few keystrokes." ], "previous_source": "", "target": [ "\"Hey, why did you change from a 'MULTILINESTRING' to a 'LINESTRING'?\" Spatially they describe the same shape, so going from a single-item multi-geometry to a singleton saves a few keystrokes." ], "id_hash": 5975553881150125820, "content_hash": 5975553881150125820, "location": "../../en/spatial_relationships_exercises.rst:73", "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": 30, "source_unit": "https://weblate.osgeo.org/api/units/98143/?format=api", "priority": 100, "id": 98143, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/en/?checksum=d2ed6e985628f6fc", "url": "https://weblate.osgeo.org/api/units/98143/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.980105Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/en/?format=api", "source": [ "PgAdmin is available for multiple platforms, at https://www.pgadmin.org/download/." ], "previous_source": "", "target": [ "PgAdmin is available for multiple platforms, at https://www.pgadmin.org/download/." ], "id_hash": -1550665375203098239, "content_hash": -1550665375203098239, "location": "../../en/installation.rst:67", "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": 8, "source_unit": "https://weblate.osgeo.org/api/units/98144/?format=api", "priority": 100, "id": 98144, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/en/?checksum=6a7aee0e99858181", "url": "https://weblate.osgeo.org/api/units/98144/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:36.991870Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/en/?format=api", "source": [ "More importantly, we also rounded the coordinates to make them easier to read, which does actually change results: we couldn't use the ST_Touches() predicate to find out which roads join Atlantic Commons, because the coordinates are not exactly the same anymore." ], "previous_source": "", "target": [ "More importantly, we also rounded the coordinates to make them easier to read, which does actually change results: we couldn't use the ST_Touches() predicate to find out which roads join Atlantic Commons, because the coordinates are not exactly the same anymore." ], "id_hash": 8664594807567453013, "content_hash": 8664594807567453013, "location": "../../en/spatial_relationships_exercises.rst:75", "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": 41, "source_unit": "https://weblate.osgeo.org/api/units/98145/?format=api", "priority": 100, "id": 98145, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/en/?checksum=f83ed3120bc08b55", "url": "https://weblate.osgeo.org/api/units/98145/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.003062Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/en/?format=api", "source": [ "Download and install the latest version for your platform." ], "previous_source": "", "target": [ "Download and install the latest version for your platform." ], "id_hash": 4502033285802049596, "content_hash": 4502033285802049596, "location": "../../en/installation.rst:69", "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": 9, "source_unit": "https://weblate.osgeo.org/api/units/98146/?format=api", "priority": 100, "id": 98146, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/en/?checksum=be7a6f6baf37403c", "url": "https://weblate.osgeo.org/api/units/98146/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.015369Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/en/?format=api", "source": [ "**What streets does Atlantic Commons join with?**" ], "previous_source": "", "target": [ "**What streets does Atlantic Commons join with?**" ], "id_hash": 2935191107731349332, "content_hash": 2935191107731349332, "location": "../../en/spatial_relationships_exercises.rst:78", "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": 7, "source_unit": "https://weblate.osgeo.org/api/units/98147/?format=api", "priority": 100, "id": 98147, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/en/?checksum=a8bbe4c2dc365f54", "url": "https://weblate.osgeo.org/api/units/98147/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.025960Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/en/?format=api", "source": [ "Start PgAdmin!" ], "previous_source": "", "target": [ "Start PgAdmin!" ], "id_hash": -329990344798113340, "content_hash": -329990344798113340, "location": "../../en/installation.rst:71", "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": 2, "source_unit": "https://weblate.osgeo.org/api/units/98148/?format=api", "priority": 100, "id": 98148, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/en/?checksum=7b6ba3879efff1c4", "url": "https://weblate.osgeo.org/api/units/98148/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.038683Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/en/?format=api", "source": [ "**Approximately how many people live on (within 50 meters of) Atlantic Commons?**" ], "previous_source": "", "target": [ "**Approximately how many people live on (within 50 meters of) Atlantic Commons?**" ], "id_hash": 3670796357754674229, "content_hash": 3670796357754674229, "location": "../../en/spatial_relationships_exercises.rst:100", "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": 12, "source_unit": "https://weblate.osgeo.org/api/units/98149/?format=api", "priority": 100, "id": 98149, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/en/?checksum=b2f149d6b2c3dc35", "url": "https://weblate.osgeo.org/api/units/98149/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.050929Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/clusterindex/de/?format=api", "source": [ "Clustering on Indices" ], "previous_source": "", "target": [ "" ], "id_hash": -4346401973050206674, "content_hash": -4346401973050206674, "location": "../../en/clusterindex.rst:4", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/98052/?format=api", "priority": 100, "id": 98150, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/clusterindex/de/?checksum=43ae7a6f0949162e", "url": "https://weblate.osgeo.org/api/units/98150/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.084873Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/clusterindex/de/?format=api", "source": [ "Databases can only retrieve information as fast as they can get it off of disk. Small databases will float up entirely into RAM cache, and get away from physical disk limitations, but for large databases, access to the physical disk will be a limiting stop in disk access speed." ], "previous_source": "", "target": [ "" ], "id_hash": 1295087543756109786, "content_hash": 1295087543756109786, "location": "../../en/clusterindex.rst:6", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 49, "source_unit": "https://weblate.osgeo.org/api/units/98055/?format=api", "priority": 100, "id": 98151, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/clusterindex/de/?checksum=91f91342669db7da", "url": "https://weblate.osgeo.org/api/units/98151/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.086827Z" } ] }