Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/components/postgis-workshop/joins/changes/?format=api
{ "count": 340, "next": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/changes/?format=api&page=2", "previous": null, "results": [ { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/es/?format=api", "user": null, "author": null, "timestamp": "2025-09-02T03:56:12.138238Z", "action": 17, "target": "", "id": 2216897, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2216897/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100673/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-09-02T03:03:00.818858Z", "action": 2, "target": "`round(v numeric, s integer) <http://www.postgresql.org/docs/current/interactive/functions-math.html>`_: Función matemática de PostgreSQL que redondea a s decimales", "id": 2216854, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2216854/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-09-02T03:02:54.119070Z", "action": 1, "target": "", "id": 2216853, "action_name": "Translation completed", "url": "https://weblate.osgeo.org/api/changes/2216853/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100674/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-09-02T03:02:54.029089Z", "action": 5, "target": "`strpos(string, substring) <http://www.postgresql.org/docs/current/static/functions-string.html>`_: Función de cadena de PostgreSQL que devuelve una ubicación entera de una subcadena especificada.", "id": 2216852, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216852/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100673/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-09-02T03:02:48.215254Z", "action": 5, "target": "`round(v numeric, s integer) <http://www.postgresql.org/docs/current/interactive/functions-math.html>`_: Función matemática de PostgreSQL que redondea a s decimales.", "id": 2216851, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216851/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100672/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-09-02T03:02:40.966856Z", "action": 5, "target": "`ST_Intersects(geometry A, geometry B) <http://postgis.net/docs/ST_Intersects.html>`_: Devuelve TRUE si las geometrías/geografías \"intersectan espacialmente\" (comparten alguna porción del espacio) y FALSE si no lo hacen (son disjuntas).", "id": 2216850, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216850/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100670/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-09-02T03:02:33.251362Z", "action": 5, "target": "`ST_DWithin(geometry A, geometry B, radius) <http://postgis.net/docs/ST_DWithin.html>`_: Devuelve true si las geometrías están dentro de la distancia especificada entre sí.", "id": 2216848, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216848/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100669/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-09-02T03:02:26.873329Z", "action": 5, "target": "`ST_Contains(geometry A, geometry B) <http://postgis.net/docs/ST_Contains.html>`_: Devuelve true si y solo si ningún punto de B se encuentra en el exterior de A, y al menos un punto del interior de B se encuentra en el interior de A.", "id": 2216847, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216847/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100666/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-09-02T03:02:18.878140Z", "action": 5, "target": "Como antes, las uniones crean una tabla virtual de todas las combinaciones posibles disponibles dentro de las restricciones de ``JOIN ON``, y esas filas luego se pasan a un resumen con ``GROUP``. La magia espacial está en la función ``ST_DWithin``, que asegura que solo los bloques censales cercanos a las estaciones de metro apropiadas se incluyan en el cálculo.", "id": 2216844, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216844/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100665/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-09-02T03:02:11.943715Z", "action": 5, "target": "Ahora podemos unir la tabla de líneas de metro a nuestra consulta original.", "id": 2216843, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216843/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100664/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-09-02T03:02:05.310579Z", "action": 5, "target": "Para responder a esa pregunta, añadiremos otra unión a nuestra consulta, de modo que podamos calcular simultáneamente la composición de muchas líneas de metro a la vez. Para hacer eso, necesitaremos crear una nueva tabla que enumere todas las líneas que queremos resumir.", "id": 2216842, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216842/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100663/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-09-02T03:01:57.218517Z", "action": 5, "target": "En la última sección vimos que el tren A no servía a una población que difiriera mucho de la composición racial del resto de la ciudad. ¿Hay algunos trenes que tengan una composición racial no promedio?", "id": 2216841, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216841/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100662/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-09-02T03:01:51.185298Z", "action": 5, "target": "Joins avanzados", "id": 2216840, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216840/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100661/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-09-02T03:01:37.928281Z", "action": 5, "target": "Así que la composición racial a lo largo del tren A no es radicalmente diferente de la composición de la ciudad de Nueva York en su conjunto.", "id": 2216839, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216839/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100660/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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-09-02T03:01:33.007367Z", "action": 5, "target": "Resumamos la composición racial dentro de 200 metros de la línea del tren A.", "id": 2216838, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216838/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/es/?format=api", "user": null, "author": null, "timestamp": "2025-08-31T22:39:40.527959Z", "action": 17, "target": "", "id": 2216723, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2216723/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100659/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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:48:54.590960Z", "action": 5, "target": "Así que para encontrar el tren A, queremos cualquier fila en ``routes`` que tenga una 'A'. Podemos hacerlo de varias formas, pero hoy usaremos el hecho de que :command:`strpos(routes,'A')` devolverá un número distinto de cero solo si 'A' está en el campo ``routes``.", "id": 2216718, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216718/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100658/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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:48:47.983679Z", "action": 5, "target": "La palabra clave ``DISTINCT`` elimina filas duplicadas del resultado. Sin la palabra clave ``DISTINCT``, la consulta anterior identifica 491 resultados en lugar de 73.", "id": 2216717, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216717/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100657/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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:48:41.313335Z", "action": 5, "target": "Primero, nota que el contenido del campo ``routes`` de la tabla ``nyc_subway_stations`` es lo que nos interesa para encontrar el tren A. Los valores allí son un poco complejos.", "id": 2216716, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216716/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100655/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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:48:35.392409Z", "action": 5, "target": "Duke Ellington una vez cantó \"You / must take the A-train / To / go to Sugar Hill way up in Harlem.\" Como vimos antes, Harlem tiene por mucho la mayor población afroamericana en Manhattan (80.5%). ¿Es lo mismo cierto para el tren A de Duke?", "id": 2216715, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216715/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100653/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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:48:23.748081Z", "action": 5, "target": "Así, de los 8 millones de personas en Nueva York, aproximadamente 44% están registradas como \"blancas\" y 26% están registradas como \"negras\".", "id": 2216714, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216714/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100652/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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:48:14.826757Z", "action": 5, "target": "Primero, obtengamos la composición racial de referencia de la ciudad.", "id": 2216713, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216713/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100651/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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:48:05.525216Z", "action": 5, "target": "También podemos usar pruebas de distancia como clave de unión, para crear consultas resumidas de \"todos los elementos dentro de un radio\". Exploremos la geografía racial de Nueva York usando consultas de distancia.", "id": 2216712, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216712/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100650/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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:47:59.621470Z", "action": 5, "target": "La cláusula ``JOIN`` combina dos elementos de ``FROM``. Por defecto, estamos usando un ``INNER JOIN``, pero hay otros cuatro tipos de joins. Para más información ver la definición de `join_type <http://www.postgresql.org/docs/9.1/interactive/sql-select.html#SQL-FROM>`_ en la documentación de PostgreSQL.", "id": 2216709, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216709/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100649/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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:47:53.836563Z", "action": 5, "target": "Después de un poco de aritmética y formato (por ejemplo, ``GROUP BY``, ``ORDER BY``) sobre los números finales, nuestra consulta arroja los porcentajes.", "id": 2216708, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216708/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100648/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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:47:47.804065Z", "action": 5, "target": "Las filas restantes se agrupan por el nombre del vecindario y se procesan a través de la función de agregación :command:`Sum()` de los valores de población.", "id": 2216707, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216707/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100647/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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:47:40.830047Z", "action": 5, "target": "La cláusula ``WHERE`` filtra nuestra tabla virtual a solo filas en Manhattan.", "id": 2216705, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216705/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100646/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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:47:33.693814Z", "action": 5, "target": "La cláusula ``JOIN`` crea una tabla virtual que incluye columnas tanto de la tabla de vecindarios como de la tabla del censo.", "id": 2216704, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216704/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100645/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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:47:27.032098Z", "action": 5, "target": "¿Qué está pasando aquí? En teoría (el orden de evaluación real es optimizado internamente por la base de datos) esto es lo que ocurre:", "id": 2216703, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216703/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100644/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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:47:19.820977Z", "action": 5, "target": "Por ejemplo: **\"¿Cuál es la población y la composición racial de los vecindarios de Manhattan?\"** Aquí tenemos una pregunta que combina información de la población del censo con los límites de los vecindarios, con una restricción a solo un distrito de Manhattan.", "id": 2216702, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216702/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100643/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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:47:13.085560Z", "action": 5, "target": "La combinación de un ``JOIN`` con un ``GROUP BY`` proporciona el tipo de análisis que usualmente se hace en un SIG.", "id": 2216701, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216701/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100642/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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:47:00.054622Z", "action": 5, "target": "Unir y resumir", "id": 2216700, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216700/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100640/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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:46:54.961927Z", "action": 5, "target": "Podríamos haber unido cada estación de metro con su vecindario contenedor, pero en este caso queríamos información solo de una. Cualquier función que proporcione una relación verdadero/falso entre dos tablas puede usarse para realizar una unión espacial, pero las más comúnmente usadas son: :command:`ST_Intersects`, :command:`ST_Contains`, y :command:`ST_DWithin`.", "id": 2216699, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216699/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100638/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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:46:48.163940Z", "action": 5, "target": "Usando una unión espacial, podemos responder la pregunta en un solo paso, recuperando información sobre la estación de metro y el vecindario que la contiene:", "id": 2216698, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216698/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100637/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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:46:42.714056Z", "action": 5, "target": "En la sección anterior, exploramos relaciones espaciales usando un proceso de dos pasos: primero extrajimos un punto de estación de metro para 'Broad St'; luego, usamos ese punto para hacer más preguntas como \"¿en qué vecindario está la estación 'Broad St'?\"", "id": 2216697, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216697/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100636/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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:46:34.887598Z", "action": 5, "target": "Las uniones espaciales son el pan de cada día de las bases de datos espaciales. Permiten combinar información de diferentes tablas usando relaciones espaciales como la clave de unión. Gran parte de lo que consideramos \"análisis GIS estándar\" puede expresarse como uniones espaciales.", "id": 2216696, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2216696/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/es/?format=api", "user": null, "author": null, "timestamp": "2025-06-18T09:58:47.942226Z", "action": 17, "target": "", "id": 2143883, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2143883/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100635/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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:04.156835Z", "action": 5, "target": "Joins Espaciales", "id": 2143835, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/2143835/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/100635/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/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:50:50.782973Z", "action": 26, "target": "Uniones Espaciales", "id": 2143834, "action_name": "Suggestion removed", "url": "https://weblate.osgeo.org/api/changes/2143834/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-06T06:30:51.942449Z", "action": 17, "target": "", "id": 2136206, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2136206/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340246/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-06T06:24:48.707033Z", "action": 2, "target": "Klausulen ``JOIN`` kombinerar två ``FROM``-objekt. Som standard använder vi en ``INNER JOIN``, men det finns fyra andra typer av sammanfogningar. För mer information se definitionen av `join_type <http://www.postgresql.org/docs/9.1/interactive/sql-select.html#SQL-FROM>`_ i PostgreSQL-dokumentationen.", "id": 2136199, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2136199/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-06T06:20:22.047914Z", "action": 17, "target": "", "id": 2136174, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2136174/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340249/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-06T05:54:37.865899Z", "action": 2, "target": "Så av de 8 miljoner människorna i New York registreras cirka 44% som \"vita\" och 26% som \"svarta\".", "id": 2136113, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2136113/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340267/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/sv/?format=api", "user": null, "author": "https://weblate.osgeo.org/api/users/anonymous/?format=api", "timestamp": "2025-06-05T00:40:21.863654Z", "action": 29, "target": "`sum(uttryck) <http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: PostgreSQL-aggregeringsfunktion som returnerar summan av poster i en uppsättning poster.", "id": 2135754, "action_name": "Suggestion removed during cleanup", "url": "https://weblate.osgeo.org/api/changes/2135754/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340264/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/sv/?format=api", "user": null, "author": "https://weblate.osgeo.org/api/users/anonymous/?format=api", "timestamp": "2025-06-05T00:40:21.823308Z", "action": 29, "target": "`ST_Intersects(geometri A, geometri B) <http://postgis.net/docs/ST_Intersects.html>`_: Returnerar TRUE om geometrierna/geografin \"spatialt korsar varandra\" - (delar någon del av utrymmet) och FALSE om de inte gör det (de är disjunkta).", "id": 2135753, "action_name": "Suggestion removed during cleanup", "url": "https://weblate.osgeo.org/api/changes/2135753/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340262/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/sv/?format=api", "user": null, "author": "https://weblate.osgeo.org/api/users/anonymous/?format=api", "timestamp": "2025-06-05T00:40:21.777387Z", "action": 29, "target": "`ST_Contains(geometri A, geometri B) <http://postgis.net/docs/ST_Contains.html>`_: Returnerar sant om och endast om inga punkter i B ligger i utsidan av A, och minst en punkt i insidan av B ligger i insidan av A.", "id": 2135752, "action_name": "Suggestion removed during cleanup", "url": "https://weblate.osgeo.org/api/changes/2135752/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340261/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/sv/?format=api", "user": null, "author": "https://weblate.osgeo.org/api/users/anonymous/?format=api", "timestamp": "2025-06-05T00:40:21.737510Z", "action": 29, "target": "Funktionslista", "id": 2135751, "action_name": "Suggestion removed during cleanup", "url": "https://weblate.osgeo.org/api/changes/2135751/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/sv/?format=api", "user": null, "author": null, "timestamp": "2025-06-04T17:47:55.699155Z", "action": 17, "target": "", "id": 2135692, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2135692/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340267/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T14:56:53.938304Z", "action": 9, "target": "`sum(uttryck) <http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: PostgreSQL-aggregeringsfunktion som returnerar summan av poster i en uppsättning poster.", "id": 2134972, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134972/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2340266/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/sv/?format=api", "user": "https://weblate.osgeo.org/api/users/yeager/?format=api", "author": "https://weblate.osgeo.org/api/users/yeager/?format=api", "timestamp": "2025-06-04T14:56:53.885506Z", "action": 9, "target": "`strpos (sträng, delsträng) <http://www.postgresql.org/docs/current/static/functions-string.html>`_: PostgreSQL-strängfunktion som returnerar en heltalsplats för en angiven delsträng.", "id": 2134971, "action_name": "Translation uploaded", "url": "https://weblate.osgeo.org/api/changes/2134971/?format=api" } ] }