Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/postgis-workshop/joins_exercises/es/changes/?format=api
{ "count": 49, "next": null, "previous": null, "results": [ { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/es/?format=api", "user": "https://weblate.osgeo.org/api/users/robe/?format=api", "author": null, "timestamp": "2025-09-01T05:23:32.518358Z", "action": 17, "target": "", "id": 2216750, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2216750/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102874/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/es/?format=api", "user": "https://weblate.osgeo.org/api/users/robe/?format=api", "author": "https://weblate.osgeo.org/api/users/robe/?format=api", "timestamp": "2025-09-01T05:20:42.613721Z", "action": 2, "target": ":command:`ST_Distance(geometría A, geometría B)` devuelve la distancia mínima entre la geometría A y la geometría B", "id": 2216738, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2216738/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102874/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/es/?format=api", "user": "https://weblate.osgeo.org/api/users/robe/?format=api", "author": "https://weblate.osgeo.org/api/users/robe/?format=api", "timestamp": "2025-09-01T05:20:42.393489Z", "action": 45, "target": "", "id": 2216737, "action_name": "Contributor joined", "url": "https://weblate.osgeo.org/api/changes/2216737/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/es/?format=api", "user": null, "author": null, "timestamp": "2025-08-31T22:39:40.689670Z", "action": 17, "target": "", "id": 2216724, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2216724/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/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-31T21:45:17.376687Z", "action": 1, "target": "", "id": 2216695, "action_name": "Translation completed", "url": "https://weblate.osgeo.org/api/changes/2216695/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102918/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/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-31T21:45:17.302181Z", "action": 5, "target": "**¿Qué vecindario tiene la mayor densidad de población (personas/km2)?**", "id": 2216694, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216694/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102915/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/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-31T21:45:09.065254Z", "action": 5, "target": "**Después del 11/9, el vecindario 'Battery Park' estuvo fuera de límites durante varios días. ¿Cuántas personas tuvieron que ser evacuadas?**", "id": 2216693, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216693/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102914/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/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-31T21:45:03.377479Z", "action": 5, "target": "Usamos la palabra clave ``DISTINCT`` para eliminar valores duplicados de nuestro conjunto de resultados cuando había más de una estación de metro en un vecindario.", "id": 2216692, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216692/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102912/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/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-31T21:44:57.737015Z", "action": 5, "target": "**¿Cuáles son todos los vecindarios servidos por el tren 6?** (Pista: la columna ``routes`` en la tabla ``nyc_subway_stations`` tiene valores como 'B,D,6,V' y 'C,6')", "id": 2216691, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216691/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102910/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/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-31T21:44:51.039452Z", "action": 5, "target": "**¿Qué estación de metro está en 'Little Italy'? ¿En qué ruta de metro está?**", "id": 2216690, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216690/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102902/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/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-31T21:44:42.349636Z", "action": 5, "target": "name, routes, geom", "id": 2216689, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216689/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102886/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/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-31T21:44:42.256182Z", "action": 5, "target": ":command:`ST_Within(geometry A, geometry B)` devuelve verdadero si la geometría A está dentro de la geometría B", "id": 2216688, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216688/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102884/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/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-31T21:44:35.372197Z", "action": 5, "target": ":command:`ST_Touches(geometry A, geometry B)` devuelve verdadero si el límite de la geometría A toca la geometría B", "id": 2216687, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216687/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102880/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/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-31T21:44:29.425641Z", "action": 5, "target": ":command:`ST_Intersects(geometry A, geometry B)` devuelve verdadero si la geometría A intersecta la geometría B", "id": 2216686, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216686/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/es/?format=api", "user": null, "author": null, "timestamp": "2025-06-18T09:58:48.633115Z", "action": 17, "target": "", "id": 2143889, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2143889/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102900/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/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-06-18T09:54:15.762840Z", "action": 26, "target": "nyc_subway_stations", "id": 2143854, "action_name": "Suggestion removed", "url": "https://weblate.osgeo.org/api/changes/2143854/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102860/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/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-06-18T09:51:21.406614Z", "action": 26, "target": "Ejerc Joins Exercises", "id": 2143836, "action_name": "Suggestion removed", "url": "https://weblate.osgeo.org/api/changes/2143836/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102868/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/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-06-18T09:48:39.543244Z", "action": 2, "target": ":command:`ST_Area(geometría)` devuelve el área de la geometría", "id": 2143831, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2143831/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102900/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/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-06-18T09:07:52.931933Z", "action": 5, "target": "``nyc_subway_stations``", "id": 2143542, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2143542/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102893/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/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-06-18T09:07:45.460695Z", "action": 5, "target": "name, popn_total, boroname, geom", "id": 2143538, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2143538/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102891/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/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-06-18T09:07:24.684982Z", "action": 5, "target": "``nyc_census_blocks``", "id": 2143534, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2143534/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102878/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/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-06-18T09:05:51.789149Z", "action": 2, "target": ":command:`ST_GeomFromText(text)` retorna un objeto ``geometry`` desde una definición WKT", "id": 2143523, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2143523/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102878/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/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-06-18T09:05:36.190158Z", "action": 5, "target": ":command:`ST_GeomFromText(text)` retorna un objeto ``geometry`` desde una definición WKT", "id": 2143520, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2143520/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102882/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/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-06-18T09:03:28.284730Z", "action": 5, "target": ":command:`ST_Length(linestring)` retorna la longitud de la línea", "id": 2143515, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2143515/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102882/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/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-06-18T09:03:28.281732Z", "action": 45, "target": "", "id": 2143514, "action_name": "Contributor joined", "url": "https://weblate.osgeo.org/api/changes/2143514/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/es/?format=api", "user": null, "author": null, "timestamp": "2025-03-27T06:47:37.675375Z", "action": 17, "target": "", "id": 2042656, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2042656/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102908/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "author": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "timestamp": "2025-03-26T09:19:30.719365Z", "action": 5, "target": "Ejercicios", "id": 2042424, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2042424/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102906/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "author": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "timestamp": "2025-03-26T09:19:16.665803Z", "action": 5, "target": "name, boroname, geom", "id": 2042418, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2042418/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102904/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "author": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "timestamp": "2025-03-26T09:19:08.378418Z", "action": 5, "target": "``nyc_neighborhoods``", "id": 2042412, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2042412/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102897/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "author": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "timestamp": "2025-03-26T09:18:57.177687Z", "action": 5, "target": "name, type, geom", "id": 2042406, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2042406/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102895/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "author": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "timestamp": "2025-03-26T09:18:36.945832Z", "action": 5, "target": "``nyc_streets``", "id": 2042400, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2042400/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102889/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "author": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "timestamp": "2025-03-26T09:18:29.648253Z", "action": 5, "target": "También recuerde las tablas que tenemos disponibles:", "id": 2042394, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2042394/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/es/?format=api", "user": null, "author": null, "timestamp": "2025-03-14T05:47:39.075920Z", "action": 17, "target": "", "id": 2037622, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2037622/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102876/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "author": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "timestamp": "2025-03-14T04:33:23.677866Z", "action": 5, "target": ":command:`ST_DWithin(geometría A, geometría B, radio)` devuelve verdadero si la geometría A está a una distancia dentro del 'radio' de la geometría B", "id": 2037458, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2037458/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102874/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "author": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "timestamp": "2025-03-14T04:31:43.185449Z", "action": 5, "target": ":command:`ST_Distancia(geometría A, geometría B)` devuelve la distancia mínima entre la geometría A y la geometría B", "id": 2037438, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2037438/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102872/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "author": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "timestamp": "2025-03-14T04:31:22.679007Z", "action": 5, "target": ":command:`ST_Contiene(geometría A, geometría B)` devuelve verdadero si la geometría A contiene a la geometría B", "id": 2037430, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2037430/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102870/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "author": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "timestamp": "2025-03-14T04:30:58.724017Z", "action": 5, "target": ":command:`ST_AsText(geometry)` devuelve la representación de geometry en formato WKT", "id": 2037429, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2037429/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102868/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "author": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "timestamp": "2025-03-14T04:29:45.998455Z", "action": 5, "target": ":command:`ST_Area(geometría)` devuelve el área de la geometría.", "id": 2037425, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2037425/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102866/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "author": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "timestamp": "2025-03-14T04:29:08.931128Z", "action": 5, "target": ":command:`count(expression)`: devolver la cantidad de filas (registros) que retorna una consulta", "id": 2037420, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2037420/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102864/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "author": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "timestamp": "2025-03-14T04:28:02.800681Z", "action": 5, "target": ":command:`suma(expresión)`: función de agregación para devolver una suma de un conjunto de registros", "id": 2037416, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2037416/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102862/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "author": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "timestamp": "2025-03-14T04:27:14.953304Z", "action": 5, "target": "Aquí tienes un recordatorio de algunas de las funciones que hemos visto. Pista: ¡serán útiles para los ejercicios!", "id": 2037415, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2037415/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102860/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "author": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "timestamp": "2025-03-14T04:26:49.570725Z", "action": 5, "target": "Ejercicios de Joins espaciales", "id": 2037409, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2037409/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102860/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/es/?format=api", "user": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "author": "https://weblate.osgeo.org/api/users/paulocoronado/?format=api", "timestamp": "2025-03-14T04:26:19.875306Z", "action": 4, "target": "Ejerc Joins Exercises", "id": 2037407, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/2037407/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/102900/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/es/?format=api", "user": "https://weblate.osgeo.org/api/users/mt:weblate/?format=api", "author": "https://weblate.osgeo.org/api/users/mt:weblate/?format=api", "timestamp": "2024-05-02T20:45:12.123834Z", "action": 4, "target": "nyc_subway_stations", "id": 1956636, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1956636/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/es/?format=api", "user": null, "author": null, "timestamp": "2023-04-12T02:15:38.487902Z", "action": 0, "target": "", "id": 1324470, "action_name": "Resource updated", "url": "https://weblate.osgeo.org/api/changes/1324470/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/es/?format=api", "user": null, "author": null, "timestamp": "2023-01-08T02:49:24.727241Z", "action": 0, "target": "", "id": 1096175, "action_name": "Resource updated", "url": "https://weblate.osgeo.org/api/changes/1096175/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/es/?format=api", "user": null, "author": null, "timestamp": "2022-01-07T18:01:31.860191Z", "action": 0, "target": "", "id": 5490, "action_name": "Resource updated", "url": "https://weblate.osgeo.org/api/changes/5490/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/es/?format=api", "user": null, "author": null, "timestamp": "2021-11-14T17:34:27.976186Z", "action": 0, "target": "", "id": 2128, "action_name": "Resource updated", "url": "https://weblate.osgeo.org/api/changes/2128/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins_exercises/es/?format=api", "user": null, "author": null, "timestamp": "2021-11-14T01:14:53.604516Z", "action": 0, "target": "", "id": 1959, "action_name": "Resource updated", "url": "https://weblate.osgeo.org/api/changes/1959/?format=api" } ] }