Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/components/postgis-workshop/joins_exercises/changes/?format=api
{ "count": 407, "next": "https://weblate.osgeo.org/api/components/postgis-workshop/joins_exercises/changes/?format=api&page=2", "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/uk/?format=api", "user": null, "author": null, "timestamp": "2025-08-11T19:49:51.859767Z", "action": 17, "target": "", "id": 2193012, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2193012/?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/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "timestamp": "2025-08-11T14:46:25.093841Z", "action": 1, "target": "", "id": 2192644, "action_name": "Translation completed", "url": "https://weblate.osgeo.org/api/changes/2192644/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360432/?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/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "timestamp": "2025-08-11T14:46:25.020462Z", "action": 5, "target": "**Який район має найвищу густоту населення (осіб/км²)?**", "id": 2192643, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2192643/?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/uk/?format=api", "user": null, "author": null, "timestamp": "2025-08-11T14:45:47.280049Z", "action": 17, "target": "", "id": 2192641, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2192641/?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/uk/?format=api", "user": null, "author": null, "timestamp": "2025-08-11T14:45:47.209281Z", "action": 17, "target": "", "id": 2192640, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2192640/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360431/?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/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "timestamp": "2025-08-11T14:45:40.076811Z", "action": 2, "target": "**Після подій 11 вересня район 'Battery Park' був закритий на кілька днів. Скільки людей довелося евакуювати?**", "id": 2192639, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2192639/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360431/?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/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "timestamp": "2025-08-11T14:45:30.468759Z", "action": 5, "target": "Після подій 11 вересня район 'Battery Park' був закритий на кілька днів. Скільки людей довелося евакуювати?", "id": 2192638, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2192638/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360430/?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/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "timestamp": "2025-08-11T14:45:09.008757Z", "action": 5, "target": "Ми використали ключове слово DISTINCT, щоб видалити дублікати зі списку результатів, коли в одному районі було більше однієї станції метро.", "id": 2192637, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2192637/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360429/?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/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "timestamp": "2025-08-11T14:44:54.051704Z", "action": 5, "target": "**Які райони обслуговує поїзд 6?**(Підказка: у стовпці ``routes `` таблиц `` nyc_subway_stations `` містяться значення типу 'B,D,6,V' та 'C,6')", "id": 2192636, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2192636/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360428/?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/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "timestamp": "2025-08-11T14:44:04.238913Z", "action": 5, "target": "**Яка станція метро знаходиться в 'Little Italy'? Яким маршрутом метро вона обслуговується?**", "id": 2192635, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2192635/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360427/?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/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/mt:weblate-translation-memory/?format=api", "timestamp": "2025-08-11T14:43:48.477834Z", "action": 7, "target": "Вправи", "id": 2192634, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/2192634/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360426/?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/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "timestamp": "2025-08-11T14:43:39.624790Z", "action": 5, "target": "name, boroname, geom", "id": 2192633, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2192633/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360425/?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/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/mt:weblate-translation-memory/?format=api", "timestamp": "2025-08-11T14:43:34.299463Z", "action": 7, "target": "``nyc_neighborhoods``", "id": 2192632, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/2192632/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360424/?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/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "timestamp": "2025-08-11T14:43:25.739133Z", "action": 5, "target": "name, routes, geom", "id": 2192631, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2192631/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360423/?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/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/mt:weblate-translation-memory/?format=api", "timestamp": "2025-08-11T14:43:20.571138Z", "action": 7, "target": "``nyc_subway_stations``", "id": 2192630, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/2192630/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360422/?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/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/mt:weblate-translation-memory/?format=api", "timestamp": "2025-08-11T14:43:18.707615Z", "action": 7, "target": "name, type, geom", "id": 2192629, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/2192629/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360421/?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/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/mt:weblate-translation-memory/?format=api", "timestamp": "2025-08-11T14:43:12.113170Z", "action": 7, "target": "``nyc_streets``", "id": 2192628, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/2192628/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360420/?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/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "timestamp": "2025-08-11T14:43:05.430792Z", "action": 5, "target": "name, popn_total, boroname, geom", "id": 2192627, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2192627/?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/uk/?format=api", "user": null, "author": null, "timestamp": "2025-08-11T14:42:57.999350Z", "action": 17, "target": "", "id": 2192625, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2192625/?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/uk/?format=api", "user": null, "author": null, "timestamp": "2025-08-11T14:42:57.923005Z", "action": 17, "target": "", "id": 2192624, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2192624/?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/uk/?format=api", "user": null, "author": null, "timestamp": "2025-08-11T14:42:57.846189Z", "action": 17, "target": "", "id": 2192623, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2192623/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360419/?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/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/mt:weblate-translation-memory/?format=api", "timestamp": "2025-08-11T14:42:47.466105Z", "action": 7, "target": "``nyc_census_blocks``", "id": 2192619, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/2192619/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360418/?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/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/mt:weblate-translation-memory/?format=api", "timestamp": "2025-08-11T14:42:43.258413Z", "action": 7, "target": "Також пам’ятайте про таблиці, які у нас є:", "id": 2192618, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/2192618/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360417/?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/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "timestamp": "2025-08-11T14:42:37.591515Z", "action": 5, "target": ":command:`ST_Within(geometry A, geometry B)` повертає true, якщо геометрія A знаходиться всередині геометрії B", "id": 2192617, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2192617/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360416/?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/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "timestamp": "2025-08-11T14:42:20.476113Z", "action": 5, "target": ":command:`ST_Touches(geometry A, geometry B)` повертає true, якщо межа геометрії A торкається геометрії B", "id": 2192616, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2192616/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360415/?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/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/mt:weblate-translation-memory/?format=api", "timestamp": "2025-08-11T14:41:54.384170Z", "action": 7, "target": ":command:`ST_Length(linestring)` повертає довжину лінії (linestring)", "id": 2192615, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/2192615/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360414/?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/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "timestamp": "2025-08-11T14:41:44.758511Z", "action": 5, "target": ":command:`ST_Intersects(geometry A, geometry B)` повертає true, якщо геометрія A перетинається з геометрією B", "id": 2192614, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2192614/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360413/?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/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/mt:weblate-translation-memory/?format=api", "timestamp": "2025-08-11T14:41:16.399025Z", "action": 7, "target": ":command:`ST_GeomFromText(text)` повертає ``geometry``", "id": 2192613, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/2192613/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360412/?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/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "timestamp": "2025-08-11T14:41:08.916300Z", "action": 5, "target": ":command:`ST_DWithin(geometry A, geometry B, radius)` повертає true, якщо геометрія A знаходиться на відстані радіуса або ближче до геометрії B", "id": 2192612, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2192612/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360411/?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/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "timestamp": "2025-08-11T14:40:48.472011Z", "action": 5, "target": ":command:`ST_Distance(geometry A, geometry B)`повертає мінімальну відстань між геометрією A та геометрією B", "id": 2192611, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2192611/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360410/?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/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "timestamp": "2025-08-11T14:40:29.660793Z", "action": 2, "target": ":command:`ST_Contains(geometry A, geometry B)` повертає true, якщо геометрія A містить геометрію B", "id": 2192610, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2192610/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360410/?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/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "timestamp": "2025-08-11T14:40:24.118920Z", "action": 5, "target": ":command:`ST_Contains(geometry A, geometry B)` Повертає true, якщо геометрія A містить геометрію B", "id": 2192609, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2192609/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360409/?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/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/mt:weblate-translation-memory/?format=api", "timestamp": "2025-08-11T14:39:02.454017Z", "action": 7, "target": ":command:`ST_AsText(geometry)` повертає WKT ``text``", "id": 2192606, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/2192606/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360408/?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/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/mt:weblate-translation-memory/?format=api", "timestamp": "2025-08-11T14:38:57.353171Z", "action": 7, "target": ":command:`ST_Area(geometry)` повертає площу полігону", "id": 2192604, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/2192604/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360407/?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/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/mt:weblate/?format=api", "timestamp": "2025-08-11T14:38:51.938564Z", "action": 7, "target": ":command:`count(expression)`агрегатна функція, що повертає кількість записів у наборі", "id": 2192603, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/2192603/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2360406/?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/uk/?format=api", "user": "https://weblate.osgeo.org/api/users/dkovshun/?format=api", "author": "https://weblate.osgeo.org/api/users/mt:weblate/?format=api", "timestamp": "2025-08-11T14:38:43.644974Z", "action": 7, "target": ":command:`sum(expression)`агрегатна функція, що повертає суму для набору записів", "id": 2192601, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/2192601/?format=api" } ] }