Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/postgis-workshop/geography/en/units/?format=api
{ "count": 74, "next": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/units/?format=api&page=2", "previous": null, "results": [ { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ "Geography" ], "previous_source": "", "target": [ "Geography" ], "id_hash": -5791183297552914269, "content_hash": -5791183297552914269, "location": "../../en/geography.rst:4", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 1, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://weblate.osgeo.org/api/units/100842/?format=api", "priority": 100, "id": 100842, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=2fa19579502ee8a3", "url": "https://weblate.osgeo.org/api/units/100842/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.928345Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ "It is very common to have data in which the coordinate are \"geographics\" or \"latitude/longitude\"." ], "previous_source": "", "target": [ "It is very common to have data in which the coordinate are \"geographics\" or \"latitude/longitude\"." ], "id_hash": 2032077327940972663, "content_hash": 2032077327940972663, "location": "../../en/geography.rst:6", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 2, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://weblate.osgeo.org/api/units/100846/?format=api", "priority": 100, "id": 100846, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=9c336390380bf077", "url": "https://weblate.osgeo.org/api/units/100846/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.960518Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ "Unlike coordinates in Mercator, UTM, or Stateplane, geographic coordinates are **not Cartesian coordinates**. Geographic coordinates do not represent a linear distance from an origin as plotted on a plane. Rather, these **spherical coordinates** describe angular coordinates on a globe. In spherical coordinates a point is specified by the angle of rotation from a reference meridian (longitude), and the angle from the equator (latitude)." ], "previous_source": "", "target": [ "Unlike coordinates in Mercator, UTM, or Stateplane, geographic coordinates are **not Cartesian coordinates**. Geographic coordinates do not represent a linear distance from an origin as plotted on a plane. Rather, these **spherical coordinates** describe angular coordinates on a globe. In spherical coordinates a point is specified by the angle of rotation from a reference meridian (longitude), and the angle from the equator (latitude)." ], "id_hash": 1409168443057769681, "content_hash": 1409168443057769681, "location": "../../en/geography.rst:8", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 3, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 63, "source_unit": "https://weblate.osgeo.org/api/units/100849/?format=api", "priority": 100, "id": 100849, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=938e5f3b9d260cd1", "url": "https://weblate.osgeo.org/api/units/100849/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.982878Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ "You can treat geographic coordinates as approximate Cartesian coordinates and continue to do spatial calculations. However, measurements of distance, length and area will be **nonsensical**. Since spherical coordinates measure **angular** distance, the units are in \"degrees.\" Further, the approximate results from indexes and true/false tests like intersects and contains can become terribly wrong. The distance between points get larger as problem areas like the poles or the international dateline are approached." ], "previous_source": "", "target": [ "You can treat geographic coordinates as approximate Cartesian coordinates and continue to do spatial calculations. However, measurements of distance, length and area will be **nonsensical**. Since spherical coordinates measure **angular** distance, the units are in \"degrees.\" Further, the approximate results from indexes and true/false tests like intersects and contains can become terribly wrong. The distance between points get larger as problem areas like the poles or the international dateline are approached." ], "id_hash": 9168346536601859095, "content_hash": 9168346536601859095, "location": "../../en/geography.rst:13", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 4, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 71, "source_unit": "https://weblate.osgeo.org/api/units/100852/?format=api", "priority": 100, "id": 100852, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=ff3c82995bd63417", "url": "https://weblate.osgeo.org/api/units/100852/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.006016Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ "For example, here are the coordinates of Los Angeles and Paris." ], "previous_source": "", "target": [ "For example, here are the coordinates of Los Angeles and Paris." ], "id_hash": 1946928843331276802, "content_hash": 1946928843331276802, "location": "../../en/geography.rst:15", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 5, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://weblate.osgeo.org/api/units/100855/?format=api", "priority": 100, "id": 100855, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=9b04e177bdb91002", "url": "https://weblate.osgeo.org/api/units/100855/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.029081Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ "Los Angeles: ``POINT(-118.4079 33.9434)``" ], "previous_source": "", "target": [ "Los Angeles: ``POINT(-118.4079 33.9434)``" ], "id_hash": 4047197220043115811, "content_hash": 4047197220043115811, "location": "../../en/geography.rst:17", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 6, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://weblate.osgeo.org/api/units/100858/?format=api", "priority": 100, "id": 100858, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=b82a886dbc9e4d23", "url": "https://weblate.osgeo.org/api/units/100858/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.051839Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ "Paris: ``POINT(2.3490 48.8533)``" ], "previous_source": "", "target": [ "Paris: ``POINT(2.3490 48.8533)``" ], "id_hash": 4079517186440654121, "content_hash": 4079517186440654121, "location": "../../en/geography.rst:18", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 7, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://weblate.osgeo.org/api/units/100861/?format=api", "priority": 100, "id": 100861, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=b89d5b4450e56d29", "url": "https://weblate.osgeo.org/api/units/100861/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.074350Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ "The following calculates the distance between Los Angeles and Paris using the standard PostGIS Cartesian :command:`ST_Distance(geometry, geometry)`. Note that the SRID of 4326 declares a geographic spatial reference system." ], "previous_source": "", "target": [ "The following calculates the distance between Los Angeles and Paris using the standard PostGIS Cartesian :command:`ST_Distance(geometry, geometry)`. Note that the SRID of 4326 declares a geographic spatial reference system." ], "id_hash": -7612518291780292317, "content_hash": -7612518291780292317, "location": "../../en/geography.rst:20", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 8, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://weblate.osgeo.org/api/units/100864/?format=api", "priority": 100, "id": 100864, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=165ae6f24c45b123", "url": "https://weblate.osgeo.org/api/units/100864/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.096690Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ "Aha! 122! But, what does that mean?" ], "previous_source": "", "target": [ "Aha! 122! But, what does that mean?" ], "id_hash": 3556723977372371438, "content_hash": 3556723977372371438, "location": "../../en/geography.rst:33", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 9, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://weblate.osgeo.org/api/units/100867/?format=api", "priority": 100, "id": 100867, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=b15c059cf36509ee", "url": "https://weblate.osgeo.org/api/units/100867/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.120132Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ "The units for spatial reference 4326 are degrees. So our answer is 122 degrees. But (again), what does that mean?" ], "previous_source": "", "target": [ "The units for spatial reference 4326 are degrees. So our answer is 122 degrees. But (again), what does that mean?" ], "id_hash": -1857812963210652148, "content_hash": -1857812963210652148, "location": "../../en/geography.rst:35", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 10, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://weblate.osgeo.org/api/units/100870/?format=api", "priority": 100, "id": 100870, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=6637b8f3fcb6960c", "url": "https://weblate.osgeo.org/api/units/100870/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.142566Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ "On a sphere, the size of one \"degree square\" is quite variable, becoming smaller as you move away from the equator. Think of the meridians (vertical lines) on the globe getting closer to each other as you go towards the poles. So, a distance of 122 degrees doesn't *mean* anything. It is a nonsense number." ], "previous_source": "", "target": [ "On a sphere, the size of one \"degree square\" is quite variable, becoming smaller as you move away from the equator. Think of the meridians (vertical lines) on the globe getting closer to each other as you go towards the poles. So, a distance of 122 degrees doesn't *mean* anything. It is a nonsense number." ], "id_hash": -8038371436149620872, "content_hash": -8038371436149620872, "location": "../../en/geography.rst:37", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 11, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 55, "source_unit": "https://weblate.osgeo.org/api/units/100873/?format=api", "priority": 100, "id": 100873, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=1071f7c497a7bf78", "url": "https://weblate.osgeo.org/api/units/100873/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.165692Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ "In order to calculate a meaningful distance, we must treat geographic coordinates not as approximate Cartesian coordinates but rather as true spherical coordinates. We must measure the distances between points as true paths over a sphere -- a portion of a great circle." ], "previous_source": "", "target": [ "In order to calculate a meaningful distance, we must treat geographic coordinates not as approximate Cartesian coordinates but rather as true spherical coordinates. We must measure the distances between points as true paths over a sphere -- a portion of a great circle." ], "id_hash": 8602181937164088923, "content_hash": 8602181937164088923, "location": "../../en/geography.rst:39", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 12, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 43, "source_unit": "https://weblate.osgeo.org/api/units/100882/?format=api", "priority": 100, "id": 100882, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=f76116e541f2765b", "url": "https://weblate.osgeo.org/api/units/100882/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.188666Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ "PostGIS provides this functionality through the ``geography`` type." ], "previous_source": "", "target": [ "PostGIS provides this functionality through the ``geography`` type." ], "id_hash": -8363523490293318602, "content_hash": -8363523490293318602, "location": "../../en/geography.rst:41", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 13, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://weblate.osgeo.org/api/units/100898/?format=api", "priority": 100, "id": 100898, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=0beecbb28a6e7c36", "url": "https://weblate.osgeo.org/api/units/100898/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.212033Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ "Different spatial databases have different approaches for \"handling geographics\"" ], "previous_source": "", "target": [ "Different spatial databases have different approaches for \"handling geographics\"" ], "id_hash": 7584820244039604777, "content_hash": 7584820244039604777, "location": "../../en/geography.rst:45", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 14, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://weblate.osgeo.org/api/units/100912/?format=api", "priority": 100, "id": 100912, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=e942b1d36b2c1a29", "url": "https://weblate.osgeo.org/api/units/100912/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.234556Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ "Oracle attempts to paper over the differences by transparently doing geographic calculations when the SRID is geographic." ], "previous_source": "", "target": [ "Oracle attempts to paper over the differences by transparently doing geographic calculations when the SRID is geographic." ], "id_hash": 4491463936021027778, "content_hash": 4491463936021027778, "location": "../../en/geography.rst:47", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 15, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://weblate.osgeo.org/api/units/100922/?format=api", "priority": 100, "id": 100922, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=be54e2a72c02dbc2", "url": "https://weblate.osgeo.org/api/units/100922/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.257615Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ "SQL Server uses two spatial types, \"STGeometry\" for Cartesian data and \"STGeography\" for geographics." ], "previous_source": "", "target": [ "SQL Server uses two spatial types, \"STGeometry\" for Cartesian data and \"STGeography\" for geographics." ], "id_hash": 698522022531877530, "content_hash": 698522022531877530, "location": "../../en/geography.rst:48", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 16, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://weblate.osgeo.org/api/units/100924/?format=api", "priority": 100, "id": 100924, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=89b1a6141cccca9a", "url": "https://weblate.osgeo.org/api/units/100924/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.280294Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ "Informix Spatial is a pure Cartesian extension to Informix, while Informix Geodetic is a pure geographic extension." ], "previous_source": "", "target": [ "Informix Spatial is a pure Cartesian extension to Informix, while Informix Geodetic is a pure geographic extension." ], "id_hash": -7538038256570410525, "content_hash": -7538038256570410525, "location": "../../en/geography.rst:49", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 17, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://weblate.osgeo.org/api/units/100926/?format=api", "priority": 100, "id": 100926, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=17638224d5d0d9e3", "url": "https://weblate.osgeo.org/api/units/100926/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.302868Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ "Similar to SQL Server, PostGIS uses two types, \"geometry\" and \"geography\"." ], "previous_source": "", "target": [ "Similar to SQL Server, PostGIS uses two types, \"geometry\" and \"geography\"." ], "id_hash": -6902820549170089808, "content_hash": -6902820549170089808, "location": "../../en/geography.rst:50", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 18, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://weblate.osgeo.org/api/units/100928/?format=api", "priority": 100, "id": 100928, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=20344148827330b0", "url": "https://weblate.osgeo.org/api/units/100928/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.325894Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ "Using the ``geography`` instead of ``geometry`` type, let's try again to measure the distance between Los Angeles and Paris." ], "previous_source": "", "target": [ "Using the ``geography`` instead of ``geometry`` type, let's try again to measure the distance between Los Angeles and Paris." ], "id_hash": 6351146275310177884, "content_hash": 6351146275310177884, "location": "../../en/geography.rst:52", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 19, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://weblate.osgeo.org/api/units/100931/?format=api", "priority": 100, "id": 100931, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=d823cde338688e5c", "url": "https://weblate.osgeo.org/api/units/100931/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.348299Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ "A big number! All return values from ``geography`` calculations are in **meters**, so our answer is 9125km." ], "previous_source": "", "target": [ "A big number! All return values from ``geography`` calculations are in **meters**, so our answer is 9125km." ], "id_hash": 961731632417006643, "content_hash": 961731632417006643, "location": "../../en/geography.rst:65", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 20, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://weblate.osgeo.org/api/units/100934/?format=api", "priority": 100, "id": 100934, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=8d58c1d2ff78e433", "url": "https://weblate.osgeo.org/api/units/100934/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.370448Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ "Older versions of PostGIS supported very basic calculations over the sphere using the :command:`ST_Distance_Spheroid(point, point, measurement)` function. However, :command:`ST_Distance_Spheroid` is substantially limited. The function only works on points and provides no support for indexing across the poles or international dateline." ], "previous_source": "", "target": [ "Older versions of PostGIS supported very basic calculations over the sphere using the :command:`ST_Distance_Spheroid(point, point, measurement)` function. However, :command:`ST_Distance_Spheroid` is substantially limited. The function only works on points and provides no support for indexing across the poles or international dateline." ], "id_hash": -4149149917010710402, "content_hash": -4149149917010710402, "location": "../../en/geography.rst:67", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 21, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 40, "source_unit": "https://weblate.osgeo.org/api/units/100938/?format=api", "priority": 100, "id": 100938, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=466b422234bc307e", "url": "https://weblate.osgeo.org/api/units/100938/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.393677Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ "The need to support non-point geometries becomes very clear when posing a question like \"How close will a flight from Los Angeles to Paris come to Iceland?\"" ], "previous_source": "", "target": [ "The need to support non-point geometries becomes very clear when posing a question like \"How close will a flight from Los Angeles to Paris come to Iceland?\"" ], "id_hash": 8334898336838379244, "content_hash": 8334898336838379244, "location": "../../en/geography.rst:69", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 22, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://weblate.osgeo.org/api/units/100954/?format=api", "priority": 100, "id": 100954, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=f3ab81e08e3ee6ec", "url": "https://weblate.osgeo.org/api/units/100954/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.416942Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ "Working with geographic coordinates on a Cartesian plane (the purple line) yields a *very* wrong answer indeed! Using great circle routes (the red lines) gives the right answer. If we convert our LAX-CDG flight into a line string and calculate the distance to a point in Iceland using ``geography`` we'll get the right answer (recall) in meters." ], "previous_source": "", "target": [ "Working with geographic coordinates on a Cartesian plane (the purple line) yields a *very* wrong answer indeed! Using great circle routes (the red lines) gives the right answer. If we convert our LAX-CDG flight into a line string and calculate the distance to a point in Iceland using ``geography`` we'll get the right answer (recall) in meters." ], "id_hash": -4916002942328333298, "content_hash": -4916002942328333298, "location": "../../en/geography.rst:73", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 23, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 57, "source_unit": "https://weblate.osgeo.org/api/units/100971/?format=api", "priority": 100, "id": 100971, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=3bc6d95ebbbe9c0e", "url": "https://weblate.osgeo.org/api/units/100971/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.439870Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ "So the closest approach to Iceland (as measured from its international airport) on the LAX-CDG route is a relatively small 502km." ], "previous_source": "", "target": [ "So the closest approach to Iceland (as measured from its international airport) on the LAX-CDG route is a relatively small 502km." ], "id_hash": -1384382057240150738, "content_hash": -1384382057240150738, "location": "../../en/geography.rst:86", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 24, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://weblate.osgeo.org/api/units/100986/?format=api", "priority": 100, "id": 100986, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=6cc9afda8cc6bd2e", "url": "https://weblate.osgeo.org/api/units/100986/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.463300Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ "The Cartesian approach to handling geographic coordinates breaks down entirely for features that cross the international dateline. The shortest great-circle route from Los Angeles to Tokyo crosses the Pacific Ocean. The shortest Cartesian route crosses the Atlantic and Indian Oceans." ], "previous_source": "", "target": [ "The Cartesian approach to handling geographic coordinates breaks down entirely for features that cross the international dateline. The shortest great-circle route from Los Angeles to Tokyo crosses the Pacific Ocean. The shortest Cartesian route crosses the Atlantic and Indian Oceans." ], "id_hash": 7070565409245278549, "content_hash": 7070565409245278549, "location": "../../en/geography.rst:88", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 25, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 40, "source_unit": "https://weblate.osgeo.org/api/units/100989/?format=api", "priority": 100, "id": 100989, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=e21fb1c73b3ab155", "url": "https://weblate.osgeo.org/api/units/100989/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.486592Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ "Using Geography" ], "previous_source": "", "target": [ "Using Geography" ], "id_hash": -1698443057261887380, "content_hash": -1698443057261887380, "location": "../../en/geography.rst:111", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 26, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://weblate.osgeo.org/api/units/100992/?format=api", "priority": 100, "id": 100992, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=686deb09c4ad406c", "url": "https://weblate.osgeo.org/api/units/100992/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.509400Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ "In order to load geometry data into a geography table, the geometry first needs to be projected into EPSG:4326 (longitude/latitude), then it needs to be changed into geography. The :command:`ST_Transform(geometry,srid)` function converts coordinates to geographics and the :command:`Geography(geometry)` function or the ``::geography`` suffix \"casts\" to geography." ], "previous_source": "", "target": [ "In order to load geometry data into a geography table, the geometry first needs to be projected into EPSG:4326 (longitude/latitude), then it needs to be changed into geography. The :command:`ST_Transform(geometry,srid)` function converts coordinates to geographics and the :command:`Geography(geometry)` function or the ``::geography`` suffix \"casts\" to geography." ], "id_hash": -5539497829337475016, "content_hash": -5539497829337475016, "location": "../../en/geography.rst:113", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 27, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 46, "source_unit": "https://weblate.osgeo.org/api/units/100995/?format=api", "priority": 100, "id": 100995, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=331fc012e04ad838", "url": "https://weblate.osgeo.org/api/units/100995/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.531920Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ "Building a spatial index on a geography table is exactly the same as for geometry:" ], "previous_source": "", "target": [ "Building a spatial index on a geography table is exactly the same as for geometry:" ], "id_hash": 4732512300612600216, "content_hash": 4732512300612600216, "location": "../../en/geography.rst:124", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 28, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://weblate.osgeo.org/api/units/100998/?format=api", "priority": 100, "id": 100998, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=c1ad42dd0d2e4198", "url": "https://weblate.osgeo.org/api/units/100998/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.555048Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ "The difference is under the covers: the geography index will correctly handle queries that cover the poles or the international date-line, while the geometry one will not." ], "previous_source": "", "target": [ "The difference is under the covers: the geography index will correctly handle queries that cover the poles or the international date-line, while the geometry one will not." ], "id_hash": 2295679713820686652, "content_hash": 2295679713820686652, "location": "../../en/geography.rst:131", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 29, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://weblate.osgeo.org/api/units/101001/?format=api", "priority": 100, "id": 101001, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=9fdbe489645a393c", "url": "https://weblate.osgeo.org/api/units/101001/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.577180Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ "Here's a query to find all the subway stations within 500 meters of the Empire State Building." ], "previous_source": "", "target": [ "Here's a query to find all the subway stations within 500 meters of the Empire State Building." ], "id_hash": 2372427764034399291, "content_hash": 2372427764034399291, "location": "../../en/geography.rst:133", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 30, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://weblate.osgeo.org/api/units/101005/?format=api", "priority": 100, "id": 101005, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=a0ec8e7b528b6c3b", "url": "https://weblate.osgeo.org/api/units/101005/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.600291Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ "There are only a small number of native functions for the geography type:" ], "previous_source": "", "target": [ "There are only a small number of native functions for the geography type:" ], "id_hash": 6257478921021833796, "content_hash": 6257478921021833796, "location": "../../en/geography.rst:148", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 31, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://weblate.osgeo.org/api/units/101020/?format=api", "priority": 100, "id": 101020, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=d6d707ecd5004244", "url": "https://weblate.osgeo.org/api/units/101020/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.622902Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ ":command:`ST_AsText(geography)` returns ``text``" ], "previous_source": "", "target": [ ":command:`ST_AsText(geography)` returns ``text``" ], "id_hash": 1253148432611274855, "content_hash": 1253148432611274855, "location": "../../en/geography.rst:150", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 32, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://weblate.osgeo.org/api/units/101037/?format=api", "priority": 100, "id": 101037, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=916413dc28a1f067", "url": "https://weblate.osgeo.org/api/units/101037/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.646412Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ ":command:`ST_GeographyFromText(text)` returns ``geography``" ], "previous_source": "", "target": [ ":command:`ST_GeographyFromText(text)` returns ``geography``" ], "id_hash": 2167772588706828518, "content_hash": 2167772588706828518, "location": "../../en/geography.rst:151", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 33, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://weblate.osgeo.org/api/units/101053/?format=api", "priority": 100, "id": 101053, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=9e1579af1fb310e6", "url": "https://weblate.osgeo.org/api/units/101053/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.670065Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ ":command:`ST_AsBinary(geography)` returns ``bytea``" ], "previous_source": "", "target": [ ":command:`ST_AsBinary(geography)` returns ``bytea``" ], "id_hash": -4160158133768897072, "content_hash": -4160158133768897072, "location": "../../en/geography.rst:152", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 34, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://weblate.osgeo.org/api/units/101057/?format=api", "priority": 100, "id": 101057, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=464426380340bdd0", "url": "https://weblate.osgeo.org/api/units/101057/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.694081Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ ":command:`ST_GeogFromWKB(bytea)` returns ``geography``" ], "previous_source": "", "target": [ ":command:`ST_GeogFromWKB(bytea)` returns ``geography``" ], "id_hash": 6355031183460841014, "content_hash": 6355031183460841014, "location": "../../en/geography.rst:153", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 35, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://weblate.osgeo.org/api/units/101060/?format=api", "priority": 100, "id": 101060, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=d8319b30e2b6b636", "url": "https://weblate.osgeo.org/api/units/101060/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.717475Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ ":command:`ST_AsSVG(geography)` returns ``text``" ], "previous_source": "", "target": [ ":command:`ST_AsSVG(geography)` returns ``text``" ], "id_hash": 4845852315063992835, "content_hash": 4845852315063992835, "location": "../../en/geography.rst:154", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 36, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://weblate.osgeo.org/api/units/101063/?format=api", "priority": 100, "id": 101063, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=c33fed019164c203", "url": "https://weblate.osgeo.org/api/units/101063/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.742545Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ ":command:`ST_AsGML(geography)` returns ``text``" ], "previous_source": "", "target": [ ":command:`ST_AsGML(geography)` returns ``text``" ], "id_hash": -7710514868276639439, "content_hash": -7710514868276639439, "location": "../../en/geography.rst:155", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 37, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://weblate.osgeo.org/api/units/101066/?format=api", "priority": 100, "id": 101066, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=14febf945100c931", "url": "https://weblate.osgeo.org/api/units/101066/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.766793Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ ":command:`ST_AsKML(geography)` returns ``text``" ], "previous_source": "", "target": [ ":command:`ST_AsKML(geography)` returns ``text``" ], "id_hash": -3400817160998207296, "content_hash": -3400817160998207296, "location": "../../en/geography.rst:156", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 38, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://weblate.osgeo.org/api/units/101069/?format=api", "priority": 100, "id": 101069, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=50cddecf74a640c0", "url": "https://weblate.osgeo.org/api/units/101069/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.789390Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ ":command:`ST_AsGeoJson(geography)` returns ``text``" ], "previous_source": "", "target": [ ":command:`ST_AsGeoJson(geography)` returns ``text``" ], "id_hash": 1892568838556006044, "content_hash": 1892568838556006044, "location": "../../en/geography.rst:157", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 39, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://weblate.osgeo.org/api/units/101072/?format=api", "priority": 100, "id": 101072, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=9a43c154d71ab69c", "url": "https://weblate.osgeo.org/api/units/101072/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.811685Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ ":command:`ST_Distance(geography, geography)` returns ``double``" ], "previous_source": "", "target": [ ":command:`ST_Distance(geography, geography)` returns ``double``" ], "id_hash": -8087162956075973739, "content_hash": -8087162956075973739, "location": "../../en/geography.rst:158", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 40, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://weblate.osgeo.org/api/units/101075/?format=api", "priority": 100, "id": 101075, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=0fc4a0239a64c395", "url": "https://weblate.osgeo.org/api/units/101075/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.834419Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ ":command:`ST_DWithin(geography, geography, float8)` returns ``boolean``" ], "previous_source": "", "target": [ ":command:`ST_DWithin(geography, geography, float8)` returns ``boolean``" ], "id_hash": -2670519839050706452, "content_hash": -2670519839050706452, "location": "../../en/geography.rst:159", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 41, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://weblate.osgeo.org/api/units/101078/?format=api", "priority": 100, "id": 101078, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=5af0685afbbfd1ec", "url": "https://weblate.osgeo.org/api/units/101078/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.857058Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ ":command:`ST_Area(geography)` returns ``double``" ], "previous_source": "", "target": [ ":command:`ST_Area(geography)` returns ``double``" ], "id_hash": 6401874495825927805, "content_hash": 6401874495825927805, "location": "../../en/geography.rst:160", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 42, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://weblate.osgeo.org/api/units/101080/?format=api", "priority": 100, "id": 101080, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=d8d806ef74565e7d", "url": "https://weblate.osgeo.org/api/units/101080/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.879829Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ ":command:`ST_Length(geography)` returns ``double``" ], "previous_source": "", "target": [ ":command:`ST_Length(geography)` returns ``double``" ], "id_hash": 844191953209370030, "content_hash": 844191953209370030, "location": "../../en/geography.rst:161", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 43, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://weblate.osgeo.org/api/units/101082/?format=api", "priority": 100, "id": 101082, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=8bb72c1bd549a5ae", "url": "https://weblate.osgeo.org/api/units/101082/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.904414Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ ":command:`ST_Covers(geography, geography)` returns ``boolean``" ], "previous_source": "", "target": [ ":command:`ST_Covers(geography, geography)` returns ``boolean``" ], "id_hash": 5727374772217617385, "content_hash": 5727374772217617385, "location": "../../en/geography.rst:162", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 44, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://weblate.osgeo.org/api/units/101084/?format=api", "priority": 100, "id": 101084, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=cf7bb902a9909be9", "url": "https://weblate.osgeo.org/api/units/101084/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.930853Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ ":command:`ST_CoveredBy(geography, geography)` returns ``boolean``" ], "previous_source": "", "target": [ ":command:`ST_CoveredBy(geography, geography)` returns ``boolean``" ], "id_hash": -5579932683330725781, "content_hash": -5579932683330725781, "location": "../../en/geography.rst:163", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 45, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://weblate.osgeo.org/api/units/101086/?format=api", "priority": 100, "id": 101086, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=329018c9cb7ad86b", "url": "https://weblate.osgeo.org/api/units/101086/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.953432Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ ":command:`ST_Intersects(geography, geography)` returns ``boolean``" ], "previous_source": "", "target": [ ":command:`ST_Intersects(geography, geography)` returns ``boolean``" ], "id_hash": -9193174826364831209, "content_hash": -9193174826364831209, "location": "../../en/geography.rst:164", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 46, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://weblate.osgeo.org/api/units/101088/?format=api", "priority": 100, "id": 101088, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=006b4833f475fa17", "url": "https://weblate.osgeo.org/api/units/101088/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.976124Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ ":command:`ST_Buffer(geography, float8)` returns ``geography`` [#Casting_note]_" ], "previous_source": "", "target": [ ":command:`ST_Buffer(geography, float8)` returns ``geography`` [#Casting_note]_" ], "id_hash": 1148519768974895339, "content_hash": 1148519768974895339, "location": "../../en/geography.rst:165", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 47, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://weblate.osgeo.org/api/units/101090/?format=api", "priority": 100, "id": 101090, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=8ff05ca50f4328eb", "url": "https://weblate.osgeo.org/api/units/101090/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:47.998920Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ ":command:`ST_Intersection(geography, geography)` returns ``geography`` [#Casting_note]_" ], "previous_source": "", "target": [ ":command:`ST_Intersection(geography, geography)` returns ``geography`` [#Casting_note]_" ], "id_hash": -6667517120159902763, "content_hash": -6667517120159902763, "location": "../../en/geography.rst:166", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 48, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://weblate.osgeo.org/api/units/101092/?format=api", "priority": 100, "id": 101092, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=23783881570893d5", "url": "https://weblate.osgeo.org/api/units/101092/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:48.021241Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ "Creating a Geography Table" ], "previous_source": "", "target": [ "Creating a Geography Table" ], "id_hash": 6241225547685314505, "content_hash": 6241225547685314505, "location": "../../en/geography.rst:169", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 49, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://weblate.osgeo.org/api/units/101094/?format=api", "priority": 100, "id": 101094, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=d69d499174e03fc9", "url": "https://weblate.osgeo.org/api/units/101094/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:48.043335Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/en/?format=api", "source": [ "The SQL for creating a new table with a geography column is much like that for creating a geometry table. However, geography includes the ability to specify the object type directly at the time of table creation. For example:" ], "previous_source": "", "target": [ "The SQL for creating a new table with a geography column is much like that for creating a geometry table. However, geography includes the ability to specify the object type directly at the time of table creation. For example:" ], "id_hash": -5498513876783507062, "content_hash": -5498513876783507062, "location": "../../en/geography.rst:171", "context": "", "note": "", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 50, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://weblate.osgeo.org/api/units/101096/?format=api", "priority": 100, "id": 101096, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/geography/en/?checksum=33b15ac2edc3598a", "url": "https://weblate.osgeo.org/api/units/101096/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:48.063748Z" } ] }