Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/components/postgis-workshop/geography/changes/?format=api&page=2
{ "count": 778, "next": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/changes/?format=api&page=3", "previous": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/changes/?format=api", "results": [ { "unit": "https://weblate.osgeo.org/api/units/101560/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:49:52.307983Z", "action": 2, "target": "Segundo, los cálculos en una esfera son mucho más costosos computacionalmente que los cálculos cartesianos. La fórmula cartesiana de distancia (Pitágoras) requiere una llamada a sqrt(). La fórmula esférica (Haversine) requiere dos sqrt(), una arctan(), cuatro sin() y dos cos(). Las funciones trigonométricas son costosas, y los cálculos esféricos involucran muchas de ellas.", "id": 2214793, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2214793/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101557/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:49:30.784979Z", "action": 2, "target": "Primero, como se señaló antes, hay muchas menos funciones disponibles directamente para geography. Podrías pasar mucho tiempo buscando soluciones a sus limitaciones.", "id": 2214792, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2214792/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101560/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:49:18.099341Z", "action": 5, "target": "Los cálculos en una esfera son mucho más costosos computacionalmente que los cálculos cartesianos.\n\nLa fórmula cartesiana de distancia (Pitágoras) requiere una llamada a sqrt().\n\nLa fórmula esférica (Haversine) requiere dos sqrt(), una arctan(), cuatro sin() y dos cos(). Las funciones trigonométricas son costosas, y los cálculos esféricos involucran muchas de ellas.", "id": 2214791, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214791/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101557/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:49:09.844020Z", "action": 5, "target": "Como se señaló antes, hay muchas menos funciones disponibles directamente para geography. Podrías pasar mucho tiempo buscando soluciones a sus limitaciones.", "id": 2214790, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214790/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101552/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:49:00.626170Z", "action": 5, "target": "Las coordenadas geográficas son universalmente aceptadas: todos entienden qué significan latitud y longitud, pero muy pocos entienden lo que significan coordenadas UTM. ¿Por qué no usar siempre geography?", "id": 2214789, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214789/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101549/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:48:51.973712Z", "action": 5, "target": "Por qué (no) usar Geography", "id": 2214788, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214788/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2342217/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:48:44.758305Z", "action": 5, "target": "Adjuntando ::geometry a nuestro valor geography lo convertimos a geometry con SRID 4326. Desde ahí podemos usar todas las funciones de geometry que queramos. Pero hay que recordar que, una vez convertido a geometry, las coordenadas se interpretan como cartesianas, no esféricas.", "id": 2214787, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214787/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101543/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:48:37.717333Z", "action": 5, "target": "La función :command:ST_X(point) solo admite el tipo geometry. ¿Cómo leer la coordenada X de nuestras geographies?", "id": 2214786, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214786/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/1514236/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:48:22.343699Z", "action": 5, "target": "La convención de PostgreSQL para casting es añadir ``::typename`` al final del valor. Por ejemplo: `2::text` convierte el número dos en una cadena de texto '2'. Y ``'POINT(0 0)'::geometry`` convierte la representación en texto de un punto a una geometría de tipo punto.", "id": 2214785, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214785/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101538/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:47:16.863314Z", "action": 5, "target": "Aunque las funciones básicas para geography cubren muchos casos de uso, en ocasiones se necesitan funciones que solo soporta geometry. Afortunadamente, se pueden convertir objetos de geography a geometry y viceversa.", "id": 2214784, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214784/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101535/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:47:04.437310Z", "action": 2, "target": "Convertir a tipo Geometry", "id": 2214783, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2214783/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101535/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:45:34.455321Z", "action": 2, "target": "TraCasting a Geometry", "id": 2214782, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2214782/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101535/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:45:21.468666Z", "action": 5, "target": "Casting to Geometry", "id": 2214781, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214781/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101532/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:45:07.892740Z", "action": 5, "target": "Algunas columnas fueron omitidas en la salida de arriba.", "id": 2214780, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214780/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101526/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:44:43.044154Z", "action": 2, "target": "El SQL para crear una nueva tabla con una columna geography es muy similar al de geometry. Sin embargo, geography permite especificar el tipo de objeto directamente en la creación de la tabla. Por ejemplo:", "id": 2214779, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2214779/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101529/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:44:11.551967Z", "action": 5, "target": "En la definición de la tabla, GEOGRAPHY(Point) especifica nuestro tipo de datos de aeropuertos como puntos. Los nuevos campos geography no se registran en la vista geometry_columns, sino en la vista geography_columns.", "id": 2214778, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214778/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101526/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:43:59.267528Z", "action": 5, "target": "El SQL para crear una nueva tabla con una columna geography es muy similar al de geometry. Sin embargo, geography permite especificar el tipo de objeto directamente en la creación de la tabla.", "id": 2214777, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214777/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101523/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:43:53.241452Z", "action": 5, "target": "Crear una tabla Geography", "id": 2214776, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214776/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101520/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:43:47.991037Z", "action": 5, "target": ":command:ST_Intersection(geography, geography) devuelve geography [#Casting_note]_", "id": 2214775, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214775/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101517/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:43:39.051830Z", "action": 5, "target": ":command:ST_Buffer(geography, float8) devuelve geography [#Casting_note]_", "id": 2214774, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214774/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101513/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:43:28.514939Z", "action": 5, "target": ":command:ST_Intersects(geography, geography) devuelve boolean", "id": 2214773, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214773/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101510/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:43:21.523383Z", "action": 5, "target": ":command:ST_CoveredBy(geography, geography) devuelve boolean", "id": 2214772, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214772/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101507/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:43:15.504589Z", "action": 5, "target": ":command:ST_Covers(geography, geography) devuelve boolean", "id": 2214771, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214771/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101504/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:43:09.534265Z", "action": 5, "target": ":command:ST_Length(geography) devuelve double", "id": 2214770, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214770/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101501/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:43:02.881585Z", "action": 5, "target": ":command:ST_Area(geography) devuelve double", "id": 2214769, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214769/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101498/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:42:56.556071Z", "action": 5, "target": ":command:ST_DWithin(geography, geography, float8) devuelve boolean", "id": 2214768, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214768/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101496/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:42:49.714450Z", "action": 5, "target": ":command:ST_Distance(geography, geography) devuelve double", "id": 2214767, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214767/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101493/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:42:42.794015Z", "action": 5, "target": ":command:ST_AsGeoJson(geography) devuelve text", "id": 2214766, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214766/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101490/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:42:33.209688Z", "action": 5, "target": ":command:ST_AsKML(geography) devuelve text", "id": 2214765, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214765/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101487/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:42:24.639691Z", "action": 5, "target": ":command:ST_AsGML(geography) devuelve text", "id": 2214764, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214764/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101484/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:42:18.190453Z", "action": 5, "target": ":command:ST_AsSVG(geography) devuelve text", "id": 2214763, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214763/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101481/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:42:13.181715Z", "action": 5, "target": ":command:ST_GeogFromWKB(bytea) devuelve geography", "id": 2214762, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214762/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101478/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:42:02.338945Z", "action": 5, "target": ":command:ST_AsBinary(geography) devuelve bytea", "id": 2214761, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214761/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101476/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:41:56.764812Z", "action": 5, "target": ":command:ST_GeographyFromText(text) devuelve geography", "id": 2214760, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214760/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101472/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:41:48.450280Z", "action": 5, "target": ":command:ST_AsText(geography) devuelve text", "id": 2214759, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214759/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101470/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:41:42.267741Z", "action": 5, "target": "Existen solo unas pocas funciones nativas para el tipo geography:", "id": 2214758, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214758/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101468/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:41:36.672001Z", "action": 5, "target": "Aquí hay una consulta para encontrar todas las estaciones de metro dentro de 500 metros del Empire State Building.", "id": 2214757, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214757/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101465/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:41:31.120155Z", "action": 5, "target": "La diferencia está en el funcionamiento interno: el índice geography manejará correctamente consultas que crucen los polos o la línea internacional de cambio de fecha, mientras que el de geometry no lo hará.", "id": 2214756, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214756/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101463/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:41:19.459819Z", "action": 5, "target": "Construir un índice espacial en una tabla geography es exactamente igual que en una tabla geometry:", "id": 2214755, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214755/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101462/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:41:10.989764Z", "action": 5, "target": "Para cargar datos de geometría en una tabla de tipo geography, primero la geometría debe proyectarse a EPSG:4326 (longitud/latitud), y luego debe convertirse a geography. La función :command:ST_Transform(geometry,srid) convierte coordenadas a geográficas y la función :command:Geography(geometry) o el sufijo ::geography realiza el casting a geography.", "id": 2214754, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214754/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101460/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:40:28.313555Z", "action": 5, "target": "Usando Geography", "id": 2214753, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214753/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101458/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:40:22.467057Z", "action": 5, "target": "El enfoque cartesiano para manejar coordenadas geográficas se rompe completamente en el caso de entidades que cruzan la línea internacional de cambio de fecha. La ruta de círculo máximo más corta de Los Ángeles a Tokio cruza el Océano Pacífico. La ruta cartesiana más corta cruza el Atlántico y el Índico.", "id": 2214752, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214752/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101455/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:40:13.394895Z", "action": 5, "target": "Así, la aproximación más cercana a Islandia (medida desde su aeropuerto internacional) en la ruta LAX-CDG es relativamente pequeña: 502 km.", "id": 2214751, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214751/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101453/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:40:06.399960Z", "action": 5, "target": "Trabajar con coordenadas geográficas en un plano cartesiano (la línea púrpura) da una respuesta muy errónea. Usar rutas de círculo máximo (las líneas rojas) da la respuesta correcta. Si convertimos nuestro vuelo LAX-CDG en una line string y calculamos la distancia a un punto en Islandia usando geography, obtendremos la respuesta correcta (en metros).", "id": 2214750, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214750/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101451/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:39:59.901723Z", "action": 5, "target": "La necesidad de soportar geometrías que no son puntos se hace muy clara al plantear una pregunta como: “¿Qué tan cerca pasará un vuelo de Los Ángeles a París de Islandia?”", "id": 2214749, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214749/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101449/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:39:51.897107Z", "action": 5, "target": "Las versiones antiguas de PostGIS soportaban cálculos muy básicos sobre la esfera mediante la función :command:ST_Distance_Spheroid(point, point, measurement). Sin embargo, :command:ST_Distance_Spheroid es bastante limitada. La función solo funciona con puntos y no proporciona soporte para indexación a través de los polos o la línea internacional de cambio de fecha.", "id": 2214748, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214748/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101447/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:39:45.062641Z", "action": 5, "target": "¡Un número grande! Todos los valores devueltos por cálculos con geography están en metros, así que nuestra respuesta es 9125 km.", "id": 2214747, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214747/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101444/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:39:33.209675Z", "action": 5, "target": "Usando el tipo geography en lugar de geometry, probemos de nuevo medir la distancia entre Los Ángeles y París.", "id": 2214746, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214746/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101442/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:39:25.147138Z", "action": 5, "target": "De forma similar a SQL Server, PostGIS usa dos tipos: “geometry” y “geography”.", "id": 2214745, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214745/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/101440/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geography/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geography/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulo/?format=api", "author": "https://weblate.osgeo.org/api/users/paulo/?format=api", "timestamp": "2025-08-29T05:39:14.552362Z", "action": 5, "target": "Informix Spatial es una extensión puramente cartesiana de Informix, mientras que Informix Geodetic es una extensión puramente geográfica.", "id": 2214744, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2214744/?format=api" } ] }