Unit List
Units API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/units/?format=api&page=3
{ "count": 783812, "next": "https://weblate.osgeo.org/api/units/?format=api&page=4", "previous": "https://weblate.osgeo.org/api/units/?format=api&page=2", "results": [ { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/clusterindex/de/?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": [ "" ], "id_hash": 2429495461099896061, "content_hash": 2429495461099896061, "location": "../../en/clusterindex.rst:8", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98152, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/clusterindex/de/?checksum=a1b74d3ff6487cfd", "url": "https://weblate.osgeo.org/api/units/98152/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.088699Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/clusterindex/de/?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": [ "" ], "id_hash": -3600786829566960189, "content_hash": -3600786829566960189, "location": "../../en/clusterindex.rst:13", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98153, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/clusterindex/de/?checksum=4e076f74cfc19dc3", "url": "https://weblate.osgeo.org/api/units/98153/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.090563Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/clusterindex/de/?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": [ "" ], "id_hash": -6321006127397681694, "content_hash": -6321006127397681694, "location": "../../en/clusterindex.rst:15", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98154, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/clusterindex/de/?checksum=2847466ad164c5e2", "url": "https://weblate.osgeo.org/api/units/98154/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.092271Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/clusterindex/de/?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": [ "" ], "id_hash": -1339690944101775227, "content_hash": -1339690944101775227, "location": "../../en/clusterindex.rst:20", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98155, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/clusterindex/de/?checksum=6d68762f30018885", "url": "https://weblate.osgeo.org/api/units/98155/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.094088Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/clusterindex/de/?format=api", "source": [ "Clustering on the R-Tree" ], "previous_source": "", "target": [ "" ], "id_hash": -3500876434757799414, "content_hash": -3500876434757799414, "location": "../../en/clusterindex.rst:23", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98156, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/clusterindex/de/?checksum=4f6a636e57b9b20a", "url": "https://weblate.osgeo.org/api/units/98156/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.095783Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/clusterindex/de/?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": [ "" ], "id_hash": 6082353535378252836, "content_hash": 6082353535378252836, "location": "../../en/clusterindex.rst:25", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98157, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/clusterindex/de/?checksum=d468dc50928fe424", "url": "https://weblate.osgeo.org/api/units/98157/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.097429Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/clusterindex/de/?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": [ "" ], "id_hash": 2246219023358421029, "content_hash": 2246219023358421029, "location": "../../en/clusterindex.rst:27", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98158, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/clusterindex/de/?checksum=9f2c2c4cff00e825", "url": "https://weblate.osgeo.org/api/units/98158/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.099167Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/clusterindex/de/?format=api", "source": [ "Let's cluster our ``nyc_census_blocks`` based on their spatial index:" ], "previous_source": "", "target": [ "" ], "id_hash": -1738337983529182516, "content_hash": -1738337983529182516, "location": "../../en/clusterindex.rst:29", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98159, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/clusterindex/de/?checksum=67e02ed0682c9acc", "url": "https://weblate.osgeo.org/api/units/98159/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.101030Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/clusterindex/de/?format=api", "source": [ "Function List" ], "previous_source": "", "target": [ "" ], "id_hash": 2815949782297668712, "content_hash": 2815949782297668712, "location": "../../en/clusterindex.rst:61", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98169, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/clusterindex/de/?checksum=a71443684f30ec68", "url": "https://weblate.osgeo.org/api/units/98169/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.118333Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/de/?format=api", "source": [ "PostgreSQL Schemas" ], "previous_source": "", "target": [ "" ], "id_hash": -8886816310691054916, "content_hash": -8886816310691054916, "location": "../../en/schemas.rst:4", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1, "has_suggestion": true, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://weblate.osgeo.org/api/units/98038/?format=api", "priority": 100, "id": 98171, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/de/?checksum=04abafa6591cbabc", "url": "https://weblate.osgeo.org/api/units/98171/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.218143Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/de/?format=api", "source": [ "Production databases inevitably have a large number of tables and views, and managing them all in one schema can become unwieldy quickly. Fortunately, PostgreSQL_ includes the concept of a \"_Schema\"." ], "previous_source": "", "target": [ "" ], "id_hash": -1470311288627131034, "content_hash": -1470311288627131034, "location": "../../en/schemas.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": 30, "source_unit": "https://weblate.osgeo.org/api/units/98039/?format=api", "priority": 100, "id": 98172, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/de/?checksum=6b9867ac4c220d66", "url": "https://weblate.osgeo.org/api/units/98172/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.220322Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/de/?format=api", "source": [ "Schemas are like folders, and can hold tables, views, functions, sequences and other relations. Every database starts out with one schema, the ``public`` schema." ], "previous_source": "", "target": [ "" ], "id_hash": -2590022651747296629, "content_hash": -2590022651747296629, "location": "../../en/schemas.rst:8", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://weblate.osgeo.org/api/units/98040/?format=api", "priority": 100, "id": 98173, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/de/?checksum=5c0e641eea631a8b", "url": "https://weblate.osgeo.org/api/units/98173/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.222746Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/de/?format=api", "source": [ "Inside that schema, the default install of PostGIS creates the ``geometry_columns``, ``geography_columns`` and ``spatial_ref_sys`` metadata relations, as well as all the types and functions used by PostGIS. So users of PostGIS always need access to the public schema." ], "previous_source": "", "target": [ "" ], "id_hash": -1204846504760395790, "content_hash": -1204846504760395790, "location": "../../en/schemas.rst:12", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://weblate.osgeo.org/api/units/98041/?format=api", "priority": 100, "id": 98174, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/de/?checksum=6f47867ccae2b7f2", "url": "https://weblate.osgeo.org/api/units/98174/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.224864Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/de/?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": [ "" ], "id_hash": 8695137541537991919, "content_hash": 8695137541537991919, "location": "../../en/schemas.rst:14", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98175, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/de/?checksum=f8ab558674890cef", "url": "https://weblate.osgeo.org/api/units/98175/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.226877Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/de/?format=api", "source": [ "Why use Schemas?" ], "previous_source": "", "target": [ "" ], "id_hash": 1052508970105633935, "content_hash": 1052508970105633935, "location": "../../en/schemas.rst:18", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98176, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/de/?checksum=8e9b4354f60efc8f", "url": "https://weblate.osgeo.org/api/units/98176/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.228923Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/de/?format=api", "source": [ "There are two very good reasons for using schemas:" ], "previous_source": "", "target": [ "" ], "id_hash": -1635901640625452398, "content_hash": -1635901640625452398, "location": "../../en/schemas.rst:20", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98177, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/de/?checksum=694c1c200f0a8a92", "url": "https://weblate.osgeo.org/api/units/98177/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.230634Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/de/?format=api", "source": [ "Data that is managed in a schema is easier to apply bulk actions to." ], "previous_source": "", "target": [ "" ], "id_hash": -3225587216245516428, "content_hash": -3225587216245516428, "location": "../../en/schemas.rst:22", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98178, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/de/?checksum=533c698447a51774", "url": "https://weblate.osgeo.org/api/units/98178/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.232357Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/de/?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": [ "" ], "id_hash": 7678548437974895935, "content_hash": 7678548437974895935, "location": "../../en/schemas.rst:24", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98179, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/de/?checksum=ea8faf1f241fcd3f", "url": "https://weblate.osgeo.org/api/units/98179/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.234037Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/de/?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": [ "" ], "id_hash": -4853520692566493137, "content_hash": -4853520692566493137, "location": "../../en/schemas.rst:25", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98180, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/de/?checksum=3ca4d4a52990f82f", "url": "https://weblate.osgeo.org/api/units/98180/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.235883Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/de/?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": [ "" ], "id_hash": 4703619327588052336, "content_hash": 4703619327588052336, "location": "../../en/schemas.rst:26", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98181, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/de/?checksum=c1469cdb8b8c2d70", "url": "https://weblate.osgeo.org/api/units/98181/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.237569Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/de/?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": [ "" ], "id_hash": -1816223157841303210, "content_hash": -1816223157841303210, "location": "../../en/schemas.rst:28", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98182, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/de/?checksum=66cb7aa92407e956", "url": "https://weblate.osgeo.org/api/units/98182/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.239277Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/de/?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": [ "" ], "id_hash": 212467821786474283, "content_hash": 212467821786474283, "location": "../../en/schemas.rst:30", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98183, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/de/?checksum=82f2d65bb3c8a72b", "url": "https://weblate.osgeo.org/api/units/98183/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.241062Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/de/?format=api", "source": [ "Creating a Data Schema" ], "previous_source": "", "target": [ "" ], "id_hash": 7568461229420045468, "content_hash": 7568461229420045468, "location": "../../en/schemas.rst:34", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98184, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/de/?checksum=e908936383e5e49c", "url": "https://weblate.osgeo.org/api/units/98184/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.242789Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/de/?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": [ "" ], "id_hash": -279613405728732838, "content_hash": -279613405728732838, "location": "../../en/schemas.rst:36", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98185, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/de/?checksum=7c1e9d16c51a095a", "url": "https://weblate.osgeo.org/api/units/98185/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.244440Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/de/?format=api", "source": [ "Next, we will move the ``nyc_census_blocks`` table to the ``census`` schema:" ], "previous_source": "", "target": [ "" ], "id_hash": 8464045524879258247, "content_hash": 8464045524879258247, "location": "../../en/schemas.rst:42", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98186, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/de/?checksum=f576548f7929b287", "url": "https://weblate.osgeo.org/api/units/98186/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.246218Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/de/?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": [ "" ], "id_hash": 1436805870175200359, "content_hash": 1436805870175200359, "location": "../../en/schemas.rst:48", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98187, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/de/?checksum=93f08f538efd2467", "url": "https://weblate.osgeo.org/api/units/98187/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.248147Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/de/?format=api", "source": [ "You can access tables inside schemas in two ways:" ], "previous_source": "", "target": [ "" ], "id_hash": -8600915504822134896, "content_hash": -8600915504822134896, "location": "../../en/schemas.rst:50", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98188, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/de/?checksum=08a368eaffed5790", "url": "https://weblate.osgeo.org/api/units/98188/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.250076Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/de/?format=api", "source": [ "by referencing them using ``schema.table`` notation" ], "previous_source": "", "target": [ "" ], "id_hash": 4184222717610201623, "content_hash": 4184222717610201623, "location": "../../en/schemas.rst:52", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98189, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/de/?checksum=ba11586488469217", "url": "https://weblate.osgeo.org/api/units/98189/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.251883Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/de/?format=api", "source": [ "Installation" ], "previous_source": "", "target": [ "Installation" ], "id_hash": -3959746046122658226, "content_hash": -3959746046122658226, "location": "../../en/installation.rst:4", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 98190, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/de/?checksum=490c27f36019f64e", "url": "https://weblate.osgeo.org/api/units/98190/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.253328Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/de/?format=api", "source": [ "by adding the schema to your ``search_path``" ], "previous_source": "", "target": [ "" ], "id_hash": 788069461238815375, "content_hash": 788069461238815375, "location": "../../en/schemas.rst:53", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98191, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/de/?checksum=8aefc8ffe7791a8f", "url": "https://weblate.osgeo.org/api/units/98191/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.253658Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/de/?format=api", "source": [ "Explicit referencing is easy, but it gets tiring to type after a while:" ], "previous_source": "", "target": [ "" ], "id_hash": 5451639701760265941, "content_hash": 5451639701760265941, "location": "../../en/schemas.rst:55", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98192, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/de/?checksum=cba81d6cbad64ed5", "url": "https://weblate.osgeo.org/api/units/98192/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.255292Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/de/?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": [ "" ], "id_hash": -1714055629652603552, "content_hash": -1714055629652603552, "location": "../../en/installation.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": 27, "source_unit": "https://weblate.osgeo.org/api/units/98064/?format=api", "priority": 100, "id": 98193, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/de/?checksum=6836737c7d4c4d60", "url": "https://weblate.osgeo.org/api/units/98193/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.255324Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/de/?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": [ "" ], "id_hash": -8766865489712415021, "content_hash": -8766865489712415021, "location": "../../en/schemas.rst:61", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98194, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/de/?checksum=0655d649340f7ed3", "url": "https://weblate.osgeo.org/api/units/98194/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.256965Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/de/?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": [ "" ], "id_hash": -8645956409205777958, "content_hash": -8645956409205777958, "location": "../../en/installation.rst:8", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98195, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/de/?checksum=080364743dc719da", "url": "https://weblate.osgeo.org/api/units/98195/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.257166Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/de/?format=api", "source": [ "You can set the ``search_path`` at run time using the ``SET`` command:" ], "previous_source": "", "target": [ "" ], "id_hash": 6261257118765750880, "content_hash": 6261257118765750880, "location": "../../en/schemas.rst:63", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98196, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/de/?checksum=d6e4742d0b6b1a60", "url": "https://weblate.osgeo.org/api/units/98196/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.258685Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/de/?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": [ "" ], "id_hash": -188319640073046668, "content_hash": -188319640073046668, "location": "../../en/installation.rst:9", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98197, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/de/?checksum=7d62f448fd377574", "url": "https://weblate.osgeo.org/api/units/98197/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.259011Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/de/?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": [ "" ], "id_hash": -7875221711749531039, "content_hash": -7875221711749531039, "location": "../../en/schemas.rst:69", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98198, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/de/?checksum=12b59793efb9ba61", "url": "https://weblate.osgeo.org/api/units/98198/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.260552Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/de/?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": [ "" ], "id_hash": -649280775685351699, "content_hash": -649280775685351699, "location": "../../en/installation.rst:11", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98199, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/de/?checksum=76fd4a9315c8d6ed", "url": "https://weblate.osgeo.org/api/units/98199/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.260803Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/de/?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": [ "" ], "id_hash": -2639337842923577153, "content_hash": -2639337842923577153, "location": "../../en/schemas.rst:71", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98200, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/de/?checksum=5b5f3037364b60bf", "url": "https://weblate.osgeo.org/api/units/98200/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.262492Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/de/?format=api", "source": [ "PostgreSQL for Microsoft Windows" ], "previous_source": "", "target": [ "PostgreSQL für Microsoft Windows" ], "id_hash": -2592733842513398091, "content_hash": -2592733842513398091, "location": "../../en/installation.rst:15", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 98201, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/de/?checksum=5c04c24e9fdaf6b5", "url": "https://weblate.osgeo.org/api/units/98201/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.262609Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/de/?format=api", "source": [ "Now the postgres user will always have the ``census`` schema in their search path." ], "previous_source": "", "target": [ "" ], "id_hash": -4405374113662166495, "content_hash": -4405374113662166495, "location": "../../en/schemas.rst:77", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98202, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/de/?checksum=42dcf79594771a21", "url": "https://weblate.osgeo.org/api/units/98202/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.264284Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/de/?format=api", "source": [ "For a Windows install:" ], "previous_source": "", "target": [ "Installation unter Windows:" ], "id_hash": 4283678020284972700, "content_hash": 4283678020284972700, "location": "../../en/installation.rst:17", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 98203, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/de/?checksum=bb72ae76ab3bfe9c", "url": "https://weblate.osgeo.org/api/units/98203/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.264318Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/de/?format=api", "source": [ "Creating a User Schema" ], "previous_source": "", "target": [ "" ], "id_hash": 3047927684053294564, "content_hash": 3047927684053294564, "location": "../../en/schemas.rst:81", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98204, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/de/?checksum=aa4c6a147d135de4", "url": "https://weblate.osgeo.org/api/units/98204/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.265970Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/de/?format=api", "source": [ "Go to the `Windows PostgreSQL download page <https://www.enterprisedb.com/downloads/postgres-postgresql-downloads>`_." ], "previous_source": "", "target": [ "Gehen Sie zur`Windows PostgreSQL Download Seite <https://www.enterprisedb.com/downloads/postgres-postgresql-downloads>`_." ], "id_hash": 5758989352120956278, "content_hash": 5758989352120956278, "location": "../../en/installation.rst:19", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 98205, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/de/?checksum=cfec0a4da66d3576", "url": "https://weblate.osgeo.org/api/units/98205/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.266125Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/de/?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": [ "" ], "id_hash": -2034115669987581779, "content_hash": -2034115669987581779, "location": "../../en/schemas.rst:83", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98206, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/de/?checksum=63c55e934a55a0ad", "url": "https://weblate.osgeo.org/api/units/98206/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.267632Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/de/?format=api", "source": [ "Select the latest version of PostgreSQL and save the installer to disk." ], "previous_source": "", "target": [ "Wählen Sie die aktuelle PostgreSQL Version und speichern Sie das Installationspaket lokal." ], "id_hash": -9184842678157571158, "content_hash": -9184842678157571158, "location": "../../en/installation.rst:21", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 98207, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/de/?checksum=0088e23f62920baa", "url": "https://weblate.osgeo.org/api/units/98207/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.267819Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/de/?format=api", "source": [ "Spatial Relationships Exercises" ], "previous_source": "", "target": [ "" ], "id_hash": -4666230909319952095, "content_hash": -4666230909319952095, "location": "../../en/spatial_relationships_exercises.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/98046/?format=api", "priority": 100, "id": 98208, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/de/?checksum=3f3e37b5f2094921", "url": "https://weblate.osgeo.org/api/units/98208/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.268534Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/de/?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": [ "" ], "id_hash": -1237469761498094955, "content_hash": -1237469761498094955, "location": "../../en/schemas.rst:85", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98209, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/de/?checksum=6ed39fceed9e6295", "url": "https://weblate.osgeo.org/api/units/98209/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.269371Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/de/?format=api", "source": [ "Run the installer and accept the defaults." ], "previous_source": "", "target": [ "Starten Sie das Installationsprogramm und akzeptieren Sie dabei die Standardeinstellungen." ], "id_hash": 5467413961897680895, "content_hash": 5467413961897680895, "location": "../../en/installation.rst:23", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 98210, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/de/?checksum=cbe02807deec1fff", "url": "https://weblate.osgeo.org/api/units/98210/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.269506Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/de/?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": [ "" ], "id_hash": -914448493331288555, "content_hash": -914448493331288555, "location": "../../en/spatial_relationships_exercises.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": 19, "source_unit": "https://weblate.osgeo.org/api/units/98049/?format=api", "priority": 100, "id": 98211, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/de/?checksum=734f39f0b598ee15", "url": "https://weblate.osgeo.org/api/units/98211/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.270402Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/de/?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": [ "" ], "id_hash": 6955049323959501885, "content_hash": 6955049323959501885, "location": "../../en/schemas.rst:87", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98212, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/de/?checksum=e0854c82bded443d", "url": "https://weblate.osgeo.org/api/units/98212/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.271147Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/de/?format=api", "source": [ "Find and run the \"StackBuilder\" program that was installed with the database." ], "previous_source": "", "target": [ "Suchen Sie nach dem Programm \"StackBuilder\" starten Sie dieses. Der \"StackBuilder\" wurde bei der Installation von PostgreSQL installiert." ], "id_hash": 8185905482281552012, "content_hash": 8185905482281552012, "location": "../../en/installation.rst:25", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 98213, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/de/?checksum=f19a2daa5450888c", "url": "https://weblate.osgeo.org/api/units/98213/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.271193Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/de/?format=api", "source": [ ":command:`sum(expression)` aggregate to return a sum for a set of records" ], "previous_source": "", "target": [ "" ], "id_hash": -1020726507756385293, "content_hash": -1020726507756385293, "location": "../../en/spatial_relationships_exercises.rst:8", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98214, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/de/?checksum=71d5a6a6345b0bf3", "url": "https://weblate.osgeo.org/api/units/98214/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.272084Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/de/?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": [ "" ], "id_hash": 7750240245039702294, "content_hash": 7750240245039702294, "location": "../../en/schemas.rst:94", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98215, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/de/?checksum=eb8e6270b9872116", "url": "https://weblate.osgeo.org/api/units/98215/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.272802Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/de/?format=api", "source": [ "Select the \"Spatial Extensions\" section and choose latest \"PostGIS ..Bundle\" option." ], "previous_source": "", "target": [ "Gehen Sie in den Bereich \"Spatial Extensions\" und wählen Sie die aktuellste \"PostGIS ..Bundle\" Option." ], "id_hash": 1603893007130196785, "content_hash": 1603893007130196785, "location": "../../en/installation.rst:27", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 98216, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/de/?checksum=96422c3133ba7b31", "url": "https://weblate.osgeo.org/api/units/98216/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.272961Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/de/?format=api", "source": [ ":command:`count(expression)` aggregate to return the size of a set of records" ], "previous_source": "", "target": [ "" ], "id_hash": 2546828127738688663, "content_hash": 2546828127738688663, "location": "../../en/spatial_relationships_exercises.rst:9", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98217, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/de/?checksum=a35826b041d67497", "url": "https://weblate.osgeo.org/api/units/98217/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.273832Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/de/?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": [ "" ], "id_hash": 3280979363715958380, "content_hash": 3280979363715958380, "location": "../../en/schemas.rst:106", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98218, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/de/?checksum=ad88615911ad466c", "url": "https://weblate.osgeo.org/api/units/98218/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.274505Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/de/?format=api", "source": [ "Accept the defaults and install." ], "previous_source": "", "target": [ "Akzeptieren Sie die Standardwerte und starten die Installation." ], "id_hash": -2358525550891236173, "content_hash": -2358525550891236173, "location": "../../en/installation.rst:32", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "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": 98219, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/de/?checksum=5f44d581e97204b3", "url": "https://weblate.osgeo.org/api/units/98219/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.274708Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/de/?format=api", "source": [ ":command:`ST_Contains(geometry A, geometry B)` returns true if geometry A contains geometry B" ], "previous_source": "", "target": [ "" ], "id_hash": -7721309242972623132, "content_hash": -7721309242972623132, "location": "../../en/spatial_relationships_exercises.rst:10", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98220, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/de/?checksum=14d866271bad2ee4", "url": "https://weblate.osgeo.org/api/units/98220/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.275469Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/de/?format=api", "source": [ "The user exists, with the ability to create spatial tables." ], "previous_source": "", "target": [ "" ], "id_hash": -2722499917199656732, "content_hash": -2722499917199656732, "location": "../../en/schemas.rst:108", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98221, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/de/?checksum=5a37bcbfee48b8e4", "url": "https://weblate.osgeo.org/api/units/98221/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.276238Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/de/?format=api", "source": [ "PostgreSQL for Apple MacOS" ], "previous_source": "", "target": [ "" ], "id_hash": 4268814684739276314, "content_hash": 4268814684739276314, "location": "../../en/installation.rst:36", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98222, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/de/?checksum=bb3de056afdb0e1a", "url": "https://weblate.osgeo.org/api/units/98222/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.276411Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/de/?format=api", "source": [ ":command:`ST_Crosses(geometry A, geometry B)` returns true if geometry A crosses geometry B" ], "previous_source": "", "target": [ "" ], "id_hash": 5578600074370826496, "content_hash": 5578600074370826496, "location": "../../en/spatial_relationships_exercises.rst:11", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98223, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/de/?checksum=cd6b2b3600d74100", "url": "https://weblate.osgeo.org/api/units/98223/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.277216Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/de/?format=api", "source": [ "The user's named schema exists, and the user owns it." ], "previous_source": "", "target": [ "" ], "id_hash": 1323214385234670449, "content_hash": 1323214385234670449, "location": "../../en/schemas.rst:109", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98224, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/de/?checksum=925d007901997371", "url": "https://weblate.osgeo.org/api/units/98224/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.277933Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/de/?format=api", "source": [ "For a MacOS install:" ], "previous_source": "", "target": [ "" ], "id_hash": 2940029150869453330, "content_hash": 2940029150869453330, "location": "../../en/installation.rst:38", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98225, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/de/?checksum=a8cd14ef8eddfa12", "url": "https://weblate.osgeo.org/api/units/98225/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.278105Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/de/?format=api", "source": [ ":command:`ST_Disjoint(geometry A , geometry B)` returns true if the geometries do not \"spatially intersect\"" ], "previous_source": "", "target": [ "" ], "id_hash": 4391678326084475809, "content_hash": 4391678326084475809, "location": "../../en/spatial_relationships_exercises.rst:12", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98226, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/de/?checksum=bcf2602b620c1ba1", "url": "https://weblate.osgeo.org/api/units/98226/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.278868Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/de/?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": [ "" ], "id_hash": 4302773267715094602, "content_hash": 4302773267715094602, "location": "../../en/schemas.rst:110", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98227, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/de/?checksum=bbb6857d6b34784a", "url": "https://weblate.osgeo.org/api/units/98227/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.279541Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/de/?format=api", "source": [ "Go to the `Postgres.app <https://postgresapp.com/>`_ site, and download the latest release." ], "previous_source": "", "target": [ "" ], "id_hash": 2155204446861859309, "content_hash": 2155204446861859309, "location": "../../en/installation.rst:40", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98228, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/de/?checksum=9de8d306918b19ed", "url": "https://weblate.osgeo.org/api/units/98228/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.279830Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/de/?format=api", "source": [ ":command:`ST_Distance(geometry A, geometry B)` returns the minimum distance between geometry A and geometry B" ], "previous_source": "", "target": [ "" ], "id_hash": 7087089013872496991, "content_hash": 7087089013872496991, "location": "../../en/spatial_relationships_exercises.rst:13", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98229, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/de/?checksum=e25a65e8bb71915f", "url": "https://weblate.osgeo.org/api/units/98229/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.280621Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/de/?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": [ "" ], "id_hash": 898247385090668541, "content_hash": 898247385090668541, "location": "../../en/schemas.rst:112", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98230, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/schemas/de/?checksum=8c77373cd4c0b7fd", "url": "https://weblate.osgeo.org/api/units/98230/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.281190Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/de/?format=api", "source": [ "Open the disk image, and drag the **Postgres** icon into the **Applications** folder." ], "previous_source": "", "target": [ "" ], "id_hash": -1157008299630404153, "content_hash": -1157008299630404153, "location": "../../en/installation.rst:42", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98231, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/de/?checksum=6ff17b14e259ddc7", "url": "https://weblate.osgeo.org/api/units/98231/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.281564Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/de/?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": [ "" ], "id_hash": 7582434958965590212, "content_hash": 7582434958965590212, "location": "../../en/spatial_relationships_exercises.rst:14", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98232, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/de/?checksum=e93a386bf5a5c8c4", "url": "https://weblate.osgeo.org/api/units/98232/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.282307Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/de/?format=api", "source": [ "In the **Applications** folder, double-click the **Postgres** icon to start the server." ], "previous_source": "", "target": [ "" ], "id_hash": -5469349182078464079, "content_hash": -5469349182078464079, "location": "../../en/installation.rst:47", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98233, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/de/?checksum=3418f7e591a3cfb1", "url": "https://weblate.osgeo.org/api/units/98233/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.283308Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/de/?format=api", "source": [ ":command:`ST_Equals(geometry A, geometry B)` returns true if geometry A is the same as geometry B" ], "previous_source": "", "target": [ "" ], "id_hash": -801899052372634229, "content_hash": -801899052372634229, "location": "../../en/spatial_relationships_exercises.rst:15", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98234, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/de/?checksum=74df150f7d9b558b", "url": "https://weblate.osgeo.org/api/units/98234/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.284068Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/de/?format=api", "source": [ "Click the **Initialize** button to create a new blank database instance." ], "previous_source": "", "target": [ "" ], "id_hash": -4652394043697558133, "content_hash": -4652394043697558133, "location": "../../en/installation.rst:49", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98235, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/de/?checksum=3f6f604446438d8b", "url": "https://weblate.osgeo.org/api/units/98235/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.284973Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/de/?format=api", "source": [ ":command:`ST_Intersects(geometry A, geometry B)` returns true if geometry A intersects geometry B" ], "previous_source": "", "target": [ "" ], "id_hash": 4171181830668624899, "content_hash": 4171181830668624899, "location": "../../en/spatial_relationships_exercises.rst:16", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98236, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/de/?checksum=b9e303c66e912403", "url": "https://weblate.osgeo.org/api/units/98236/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.285876Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/de/?format=api", "source": [ "In the **Applications** folder, go to the **Utilities** folder and open **Terminal**." ], "previous_source": "", "target": [ "" ], "id_hash": 5674422533494681631, "content_hash": 5674422533494681631, "location": "../../en/installation.rst:54", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98237, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/de/?checksum=cebf993ad66c301f", "url": "https://weblate.osgeo.org/api/units/98237/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.286683Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/de/?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": [ "" ], "id_hash": -3680407313083740575, "content_hash": -3680407313083740575, "location": "../../en/spatial_relationships_exercises.rst:17", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98238, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/de/?checksum=4cec910c62e4ce61", "url": "https://weblate.osgeo.org/api/units/98238/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.287614Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/de/?format=api", "source": [ "Add the command-line utilities to your `PATH` for convenience." ], "previous_source": "", "target": [ "" ], "id_hash": -6825520350773037763, "content_hash": -6825520350773037763, "location": "../../en/installation.rst:56", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98239, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/de/?checksum=2146e16774f9353d", "url": "https://weblate.osgeo.org/api/units/98239/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.288403Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/de/?format=api", "source": [ ":command:`ST_Touches(geometry A, geometry B)` returns true if the boundary of geometry A touches geometry B" ], "previous_source": "", "target": [ "" ], "id_hash": 8996529351994791185, "content_hash": 8996529351994791185, "location": "../../en/spatial_relationships_exercises.rst:18", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98240, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/de/?checksum=fcda17c7ad065511", "url": "https://weblate.osgeo.org/api/units/98240/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.289251Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/de/?format=api", "source": [ "PgAdmin for Windows and MacOS" ], "previous_source": "", "target": [ "" ], "id_hash": 9092307591548700150, "content_hash": 9092307591548700150, "location": "../../en/installation.rst:65", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98241, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/de/?checksum=fe2e5d94d6d905f6", "url": "https://weblate.osgeo.org/api/units/98241/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.290096Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/de/?format=api", "source": [ ":command:`ST_Within(geometry A, geometry B)` returns true if geometry A is within geometry B" ], "previous_source": "", "target": [ "" ], "id_hash": -1114080780013847962, "content_hash": -1114080780013847962, "location": "../../en/spatial_relationships_exercises.rst:19", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98242, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/de/?checksum=7089fd6ee82f3a66", "url": "https://weblate.osgeo.org/api/units/98242/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.290916Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/de/?format=api", "source": [ "PgAdmin is available for multiple platforms, at https://www.pgadmin.org/download/." ], "previous_source": "", "target": [ "" ], "id_hash": -1550665375203098239, "content_hash": -1550665375203098239, "location": "../../en/installation.rst:67", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98243, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/de/?checksum=6a7aee0e99858181", "url": "https://weblate.osgeo.org/api/units/98243/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.291866Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/de/?format=api", "source": [ "Also remember the tables we have available:" ], "previous_source": "", "target": [ "" ], "id_hash": 2887433863364510331, "content_hash": 2887433863364510331, "location": "../../en/spatial_relationships_exercises.rst:21", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98244, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/de/?checksum=a81239ccea46827b", "url": "https://weblate.osgeo.org/api/units/98244/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.292511Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/de/?format=api", "source": [ "Download and install the latest version for your platform." ], "previous_source": "", "target": [ "" ], "id_hash": 4502033285802049596, "content_hash": 4502033285802049596, "location": "../../en/installation.rst:69", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98245, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/de/?checksum=be7a6f6baf37403c", "url": "https://weblate.osgeo.org/api/units/98245/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.293673Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/de/?format=api", "source": [ "``nyc_census_blocks``" ], "previous_source": "", "target": [ "" ], "id_hash": -3025002096340458652, "content_hash": -3025002096340458652, "location": "../../en/spatial_relationships_exercises.rst:23", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 16, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/98102/?format=api", "priority": 100, "id": 98246, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/de/?checksum=5605089edad0a364", "url": "https://weblate.osgeo.org/api/units/98246/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.294143Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/installation/de/?format=api", "source": [ "Start PgAdmin!" ], "previous_source": "", "target": [ "" ], "id_hash": -329990344798113340, "content_hash": -329990344798113340, "location": "../../en/installation.rst:71", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98247, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/installation/de/?checksum=7b6ba3879efff1c4", "url": "https://weblate.osgeo.org/api/units/98247/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.295300Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/de/?format=api", "source": [ "blkid, popn_total, boroname, geom" ], "previous_source": "", "target": [ "" ], "id_hash": -7922362892942442027, "content_hash": -7922362892942442027, "location": "../../en/spatial_relationships_exercises.rst:25", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 17, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://weblate.osgeo.org/api/units/98105/?format=api", "priority": 100, "id": 98248, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/de/?checksum=120e1cec606e01d5", "url": "https://weblate.osgeo.org/api/units/98248/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.295762Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/de/?format=api", "source": [ "``nyc_streets``" ], "previous_source": "", "target": [ "" ], "id_hash": 2609392578440045565, "content_hash": 2609392578440045565, "location": "../../en/spatial_relationships_exercises.rst:27", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 18, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/98109/?format=api", "priority": 100, "id": 98249, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/de/?checksum=a4366cb99575a3fd", "url": "https://weblate.osgeo.org/api/units/98249/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.297437Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/de/?format=api", "source": [ "name, type, geom" ], "previous_source": "", "target": [ "" ], "id_hash": 6604575797723661680, "content_hash": 6604575797723661680, "location": "../../en/spatial_relationships_exercises.rst:29", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 19, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://weblate.osgeo.org/api/units/98113/?format=api", "priority": 100, "id": 98250, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/de/?checksum=dba82ab20b760570", "url": "https://weblate.osgeo.org/api/units/98250/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.299187Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/de/?format=api", "source": [ "``nyc_subway_stations``" ], "previous_source": "", "target": [ "" ], "id_hash": 6679113862865211847, "content_hash": 6679113862865211847, "location": "../../en/spatial_relationships_exercises.rst:31", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 20, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/98117/?format=api", "priority": 100, "id": 98251, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/de/?checksum=dcb0faabba77d1c7", "url": "https://weblate.osgeo.org/api/units/98251/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.300975Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/de/?format=api", "source": [ "name, geom" ], "previous_source": "", "target": [ "" ], "id_hash": 7505500002104016843, "content_hash": 7505500002104016843, "location": "../../en/spatial_relationships_exercises.rst:33", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 21, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://weblate.osgeo.org/api/units/98121/?format=api", "priority": 100, "id": 98252, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/de/?checksum=e828e47c6f1a7fcb", "url": "https://weblate.osgeo.org/api/units/98252/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.302756Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/de/?format=api", "source": [ "``nyc_neighborhoods``" ], "previous_source": "", "target": [ "" ], "id_hash": 7631548142037648666, "content_hash": 7631548142037648666, "location": "../../en/spatial_relationships_exercises.rst:35", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 22, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/98125/?format=api", "priority": 100, "id": 98253, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/de/?checksum=e9e8b499fc72451a", "url": "https://weblate.osgeo.org/api/units/98253/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.304488Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/de/?format=api", "source": [ "name, boroname, geom" ], "previous_source": "", "target": [ "" ], "id_hash": 236775198660524252, "content_hash": 236775198660524252, "location": "../../en/spatial_relationships_exercises.rst:37", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 23, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://weblate.osgeo.org/api/units/98129/?format=api", "priority": 100, "id": 98254, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/de/?checksum=834931c9e7c878dc", "url": "https://weblate.osgeo.org/api/units/98254/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.306212Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/de/?format=api", "source": [ "Exercises" ], "previous_source": "", "target": [ "" ], "id_hash": -7091084141687761545, "content_hash": -7091084141687761545, "location": "../../en/spatial_relationships_exercises.rst:40", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98255, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/de/?checksum=1d97688b164b9577", "url": "https://weblate.osgeo.org/api/units/98255/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.307828Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/de/?format=api", "source": [ "**What is the geometry value for the street named 'Atlantic Commons'?**" ], "previous_source": "", "target": [ "" ], "id_hash": -4743593144360516935, "content_hash": -4743593144360516935, "location": "../../en/spatial_relationships_exercises.rst:42", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98256, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/de/?checksum=3e2b5f2af769c2b9", "url": "https://weblate.osgeo.org/api/units/98256/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.309579Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/de/?format=api", "source": [ "**What neighborhood and borough is Atlantic Commons in?**" ], "previous_source": "", "target": [ "" ], "id_hash": -1201137509290988304, "content_hash": -1201137509290988304, "location": "../../en/spatial_relationships_exercises.rst:54", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98257, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/de/?checksum=6f54b3cc98502cf0", "url": "https://weblate.osgeo.org/api/units/98257/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.311659Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/de/?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": [ "" ], "id_hash": 5975553881150125820, "content_hash": 5975553881150125820, "location": "../../en/spatial_relationships_exercises.rst:73", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98258, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/de/?checksum=d2ed6e985628f6fc", "url": "https://weblate.osgeo.org/api/units/98258/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.313428Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/de/?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": [ "" ], "id_hash": 8664594807567453013, "content_hash": 8664594807567453013, "location": "../../en/spatial_relationships_exercises.rst:75", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98259, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/de/?checksum=f83ed3120bc08b55", "url": "https://weblate.osgeo.org/api/units/98259/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.315220Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/de/?format=api", "source": [ "**What streets does Atlantic Commons join with?**" ], "previous_source": "", "target": [ "" ], "id_hash": 2935191107731349332, "content_hash": 2935191107731349332, "location": "../../en/spatial_relationships_exercises.rst:78", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98260, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/de/?checksum=a8bbe4c2dc365f54", "url": "https://weblate.osgeo.org/api/units/98260/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.317001Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/spatial_relationships_exercises/de/?format=api", "source": [ "**Approximately how many people live on (within 50 meters of) Atlantic Commons?**" ], "previous_source": "", "target": [ "" ], "id_hash": 3670796357754674229, "content_hash": 3670796357754674229, "location": "../../en/spatial_relationships_exercises.rst:100", "context": "", "note": "", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 98261, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/spatial_relationships_exercises/de/?checksum=b2f149d6b2c3dc35", "url": "https://weblate.osgeo.org/api/units/98261/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:37.318683Z" } ] }