Changes

HTTP 200 OK
Allow: GET, HEAD, OPTIONS
Content-Type: application/json
Vary: Accept

{
    "count": 1196,
    "next": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/changes/?format=api&page=5",
    "previous": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/changes/?format=api&page=3",
    "results": [
        {
            "unit": "https://weblate.osgeo.org/api/units/103601/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/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-29T06:01:38.761021Z",
            "action": 5,
            "target": "Una linestring es un camino entre ubicaciones. Toma la forma de una serie ordenada de dos o más puntos. Las carreteras y ríos se representan típicamente como linestrings. Una linestring se dice que está cerrada si comienza y termina en el mismo punto. Se dice que es simple si no se cruza ni se toca a sí misma (excepto en sus extremos si está cerrada). Una linestring puede ser tanto cerrada como simple.",
            "id": 2214860,
            "action_name": "Translation added",
            "url": "https://weblate.osgeo.org/api/changes/2214860/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/103600/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/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-29T06:01:29.778562Z",
            "action": 5,
            "target": "Linestrings",
            "id": 2214859,
            "action_name": "Translation added",
            "url": "https://weblate.osgeo.org/api/changes/2214859/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/103599/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/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-29T06:01:26.248962Z",
            "action": 5,
            "target": "Las estaciones de metro de Nueva York (nyc_subway_stations) son un conjunto de datos representado como puntos. La siguiente consulta SQL devuelve la geometría asociada con un punto (en la columna ST_AsText).",
            "id": 2214858,
            "action_name": "Translation added",
            "url": "https://weblate.osgeo.org/api/changes/2214858/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/103597/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/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-29T06:01:19.966678Z",
            "action": 5,
            "target": "Por tanto, podemos leer las coordenadas de un punto como:",
            "id": 2214857,
            "action_name": "Translation added",
            "url": "https://weblate.osgeo.org/api/changes/2214857/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/103595/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/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-29T06:00:55.402085Z",
            "action": 2,
            "target": ":command:`ST_X(geometry)` devuelve la coordenada X",
            "id": 2214856,
            "action_name": "Translation changed",
            "url": "https://weblate.osgeo.org/api/changes/2214856/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/103595/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/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-29T06:00:39.759940Z",
            "action": 5,
            "target": ":command:`ST_X(geometry)` returns the X ordinate",
            "id": 2214855,
            "action_name": "Translation added",
            "url": "https://weblate.osgeo.org/api/changes/2214855/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/103596/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/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-29T06:00:39.666733Z",
            "action": 2,
            "target": ":command:`ST_Y(geometry)` devuelve la coordenada Y",
            "id": 2214854,
            "action_name": "Translation changed",
            "url": "https://weblate.osgeo.org/api/changes/2214854/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/103596/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/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-29T06:00:25.334311Z",
            "action": 5,
            "target": ":command:`ST_Y(geometry)` returns the Y ordinate",
            "id": 2214853,
            "action_name": "Translation added",
            "url": "https://weblate.osgeo.org/api/changes/2214853/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/103594/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/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-29T06:00:25.226629Z",
            "action": 5,
            "target": "Algunas funciones espaciales específicas para trabajar con puntos son:",
            "id": 2214852,
            "action_name": "Translation added",
            "url": "https://weblate.osgeo.org/api/changes/2214852/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/103593/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/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-29T06:00:20.628412Z",
            "action": 5,
            "target": "Un punto espacial representa una única ubicación en la Tierra. Este punto se representa por una sola coordenada (que puede incluir 2, 3 o 4 dimensiones). Los puntos se usan para representar objetos cuando los detalles exactos, como forma y tamaño, no son importantes en la escala objetivo. Por ejemplo, las ciudades en un mapa del mundo pueden describirse como puntos, mientras que un mapa de un estado individual podría representarlas como polígonos.",
            "id": 2214851,
            "action_name": "Translation added",
            "url": "https://weblate.osgeo.org/api/changes/2214851/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/103592/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/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-29T06:00:05.949256Z",
            "action": 5,
            "target": "Puntos",
            "id": 2214850,
            "action_name": "Translation added",
            "url": "https://weblate.osgeo.org/api/changes/2214850/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/103591/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/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-29T06:00:03.182177Z",
            "action": 2,
            "target": ":command:`ST_SRID(geometry)` devuelve el número identificador de referencia espacial de la geometría",
            "id": 2214849,
            "action_name": "Translation changed",
            "url": "https://weblate.osgeo.org/api/changes/2214849/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/103591/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/es/?format=api",
            "user": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "author": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "timestamp": "2025-08-29T05:59:56.306556Z",
            "action": 5,
            "target": ":command:`ST_SRID(geometry)` returns the spatial reference identifier number of the geometry",
            "id": 2214847,
            "action_name": "Translation added",
            "url": "https://weblate.osgeo.org/api/changes/2214847/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/103590/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/es/?format=api",
            "user": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "author": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "timestamp": "2025-08-29T05:59:52.501722Z",
            "action": 2,
            "target": ":command:`ST_NDims(geometry)` devuelve el número de dimensiones de la geometría",
            "id": 2214845,
            "action_name": "Translation changed",
            "url": "https://weblate.osgeo.org/api/changes/2214845/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/103590/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/es/?format=api",
            "user": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "author": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "timestamp": "2025-08-29T05:59:41.511344Z",
            "action": 5,
            "target": ":command:`ST_NDims(geometry)` returns the number of dimensions of the geometry",
            "id": 2214843,
            "action_name": "Translation added",
            "url": "https://weblate.osgeo.org/api/changes/2214843/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/103589/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/es/?format=api",
            "user": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "author": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "timestamp": "2025-08-29T05:59:37.290958Z",
            "action": 2,
            "target": ":command:`ST_GeometryType(geometry)` devuelve el tipo de geometría",
            "id": 2214841,
            "action_name": "Translation changed",
            "url": "https://weblate.osgeo.org/api/changes/2214841/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/103589/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/es/?format=api",
            "user": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "author": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "timestamp": "2025-08-29T05:59:23.797317Z",
            "action": 5,
            "target": ":command:`ST_GeometryType(geometry)` returns the type of the geometry",
            "id": 2214838,
            "action_name": "Translation added",
            "url": "https://weblate.osgeo.org/api/changes/2214838/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/103588/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/es/?format=api",
            "user": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "author": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "timestamp": "2025-08-29T05:59:16.855821Z",
            "action": 5,
            "target": "Nuestra tabla de ejemplo contiene una mezcla de diferentes tipos de geometrías. Podemos recopilar información general sobre cada objeto usando funciones que leen los metadatos de la geometría.",
            "id": 2214835,
            "action_name": "Translation added",
            "url": "https://weblate.osgeo.org/api/changes/2214835/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/103587/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/es/?format=api",
            "user": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "author": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "timestamp": "2025-08-29T05:59:11.183214Z",
            "action": 5,
            "target": "La especificación Simple Features for SQL (SFSQL), estándar guía original para el desarrollo de PostGIS, define cómo se representa un objeto del mundo real. Al tomar una forma continua y digitalizarla a una resolución fija se logra una representación aceptable del objeto. SFSQL solo manejaba representaciones bidimensionales. PostGIS ha extendido esto para incluir representaciones en 3 y 4 dimensiones; más recientemente la especificación SQL-Multimedia Parte 3 (SQL/MM) ha definido oficialmente su propia representación.",
            "id": 2214834,
            "action_name": "Translation added",
            "url": "https://weblate.osgeo.org/api/changes/2214834/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/103586/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/es/?format=api",
            "user": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "author": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "timestamp": "2025-08-29T05:59:05.771187Z",
            "action": 5,
            "target": "Representación de objetos del mundo real",
            "id": 2214833,
            "action_name": "Translation added",
            "url": "https://weblate.osgeo.org/api/changes/2214833/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/103585/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/es/?format=api",
            "user": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "author": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "timestamp": "2025-08-29T05:59:01.406587Z",
            "action": 5,
            "target": "Algunas de tus tablas nyc no tienen un srid de 26918? Es fácil corregirlo actualizando la tabla.",
            "id": 2214832,
            "action_name": "Translation added",
            "url": "https://weblate.osgeo.org/api/changes/2214832/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/103583/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/es/?format=api",
            "user": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "author": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "timestamp": "2025-08-29T05:58:55.184458Z",
            "action": 5,
            "target": "Consultando esta tabla, los clientes SIG y bibliotecas pueden determinar qué esperar al recuperar datos y pueden realizar cualquier proyección, procesamiento o representación necesarios sin tener que inspeccionar cada geometría.",
            "id": 2214831,
            "action_name": "Translation added",
            "url": "https://weblate.osgeo.org/api/changes/2214831/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/103582/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/es/?format=api",
            "user": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "author": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "timestamp": "2025-08-29T05:58:39.580038Z",
            "action": 5,
            "target": "La columna type define el tipo de geometría. Hemos visto hasta ahora Point y Linestring.",
            "id": 2214830,
            "action_name": "Translation added",
            "url": "https://weblate.osgeo.org/api/changes/2214830/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/103581/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/es/?format=api",
            "user": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "author": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "timestamp": "2025-08-29T05:58:35.086093Z",
            "action": 5,
            "target": "coord_dimension y srid definen, respectivamente, la dimensión de la geometría (2, 3 o 4 dimensiones) y el identificador del sistema de referencia espacial que remite a la tabla spatial_ref_sys.",
            "id": 2214829,
            "action_name": "Translation added",
            "url": "https://weblate.osgeo.org/api/changes/2214829/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/103580/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/es/?format=api",
            "user": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "author": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "timestamp": "2025-08-29T05:58:29.650607Z",
            "action": 5,
            "target": "f_geometry_column es el nombre de la columna que contiene la geometría. En tablas con múltiples columnas geométricas, habrá un registro por cada una.",
            "id": 2214828,
            "action_name": "Translation added",
            "url": "https://weblate.osgeo.org/api/changes/2214828/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/103579/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/es/?format=api",
            "user": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "author": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "timestamp": "2025-08-29T05:58:20.898150Z",
            "action": 5,
            "target": "f_table_catalog, f_table_schema y f_table_name proveen el nombre completo de la tabla de entidades que contiene una geometría. Dado que PostgreSQL no usa catálogos, f_table_catalog suele estar vacío.",
            "id": 2214827,
            "action_name": "Translation added",
            "url": "https://weblate.osgeo.org/api/changes/2214827/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/103578/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/es/?format=api",
            "user": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "author": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "timestamp": "2025-08-29T05:58:08.974882Z",
            "action": 5,
            "target": "Veamos la tabla geometry_columns en nuestra base de datos. Pega este comando en la herramienta de consultas como antes:",
            "id": 2214826,
            "action_name": "Translation added",
            "url": "https://weblate.osgeo.org/api/changes/2214826/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/103577/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/es/?format=api",
            "user": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "author": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "timestamp": "2025-08-29T05:58:03.685822Z",
            "action": 5,
            "target": "La segunda tabla (en realidad, una vista), geometry_columns, proporciona una lista de todas las \"features\" (objetos con atributos geométricos) y los detalles básicos de esas entidades.",
            "id": 2214825,
            "action_name": "Translation added",
            "url": "https://weblate.osgeo.org/api/changes/2214825/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/103576/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/es/?format=api",
            "user": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "author": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "timestamp": "2025-08-29T05:57:58.236194Z",
            "action": 5,
            "target": "La primera tabla, spatial_ref_sys, define todos los sistemas de referencia espacial conocidos por la base de datos (se explicará con más detalle más adelante).",
            "id": 2214824,
            "action_name": "Translation added",
            "url": "https://weblate.osgeo.org/api/changes/2214824/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/103575/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/es/?format=api",
            "user": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "author": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "timestamp": "2025-08-29T05:57:52.030424Z",
            "action": 5,
            "target": "De acuerdo con la especificación Simple Features for SQL (SFSQL), PostGIS proporciona dos tablas para rastrear e informar sobre los tipos de geometría disponibles en una base de datos determinada.",
            "id": 2214823,
            "action_name": "Translation added",
            "url": "https://weblate.osgeo.org/api/changes/2214823/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/103574/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/es/?format=api",
            "user": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "author": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "timestamp": "2025-08-29T05:57:36.243769Z",
            "action": 5,
            "target": "Tablas de metadatos",
            "id": 2214822,
            "action_name": "Translation added",
            "url": "https://weblate.osgeo.org/api/changes/2214822/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/103573/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/es/?format=api",
            "user": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "author": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "timestamp": "2025-08-29T05:57:32.242901Z",
            "action": 5,
            "target": "El ejemplo anterior crea una tabla (geometries) y luego inserta cinco geometrías: un punto, una línea, un polígono, un polígono con un agujero y una colección. Finalmente, las filas insertadas se seleccionan y se muestran en el panel de salida.",
            "id": 2214821,
            "action_name": "Translation added",
            "url": "https://weblate.osgeo.org/api/changes/2214821/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/103572/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/es/?format=api",
            "user": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "author": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "timestamp": "2025-08-29T05:57:27.380159Z",
            "action": 2,
            "target": "En la sección anterior, cargamos una variedad de datos. Antes de comenzar a trabajar con ellos, veamos algunos ejemplos más simples. En pgAdmin, selecciona nuevamente la base de datos nyc y abre la herramienta de consultas SQL. Pega este código de ejemplo en el editor SQL de pgAdmin (eliminando cualquier texto que haya allí) y ejecútalo.",
            "id": 2214820,
            "action_name": "Translation changed",
            "url": "https://weblate.osgeo.org/api/changes/2214820/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/103572/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/es/?format=api",
            "user": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "author": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "timestamp": "2025-08-29T05:57:03.556692Z",
            "action": 5,
            "target": "En la sección anterior, cargamos una variedad de datos. Antes de comenzar a trabajar con ellos, veamos algunos ejemplos más simples.",
            "id": 2214819,
            "action_name": "Translation added",
            "url": "https://weblate.osgeo.org/api/changes/2214819/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/103570/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/es/?format=api",
            "user": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "author": "https://weblate.osgeo.org/api/users/paulo/?format=api",
            "timestamp": "2025-08-29T05:56:46.641047Z",
            "action": 5,
            "target": "Geometrías",
            "id": 2214818,
            "action_name": "Translation added",
            "url": "https://weblate.osgeo.org/api/changes/2214818/?format=api"
        },
        {
            "unit": null,
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/es/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2025-06-18T09:58:48.946206Z",
            "action": 17,
            "target": "",
            "id": 2143892,
            "action_name": "Changes committed",
            "url": "https://weblate.osgeo.org/api/changes/2143892/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/103618/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/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.388933Z",
            "action": 2,
            "target": ":command:`ST_Area(geometría)` devuelve el área de la geometría",
            "id": 2143829,
            "action_name": "Translation changed",
            "url": "https://weblate.osgeo.org/api/changes/2143829/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/103618/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/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.386091Z",
            "action": 45,
            "target": "",
            "id": 2143828,
            "action_name": "Contributor joined",
            "url": "https://weblate.osgeo.org/api/changes/2143828/?format=api"
        },
        {
            "unit": null,
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/sv/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2025-06-17T09:48:44.587939Z",
            "action": 17,
            "target": "",
            "id": 2143497,
            "action_name": "Changes committed",
            "url": "https://weblate.osgeo.org/api/changes/2143497/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/2339512/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/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-16T16:54:31.408273Z",
            "action": 2,
            "target": "I föregående :ref:`avsnitt <loading_data>` laddade vi en mängd olika data.  Innan vi börjar leka med våra data kan vi ta en titt på några enklare exempel.  I pgAdmin väljer du återigen databasen **nyc** och öppnar SQL-frågeverktyget.  Klistra in detta exempel på SQL-kod i pgAdmins SQL-redigerarfönster (ta bort all text som kan finnas där som standard) och kör sedan.",
            "id": 2143374,
            "action_name": "Translation changed",
            "url": "https://weblate.osgeo.org/api/changes/2143374/?format=api"
        },
        {
            "unit": null,
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/sv/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2025-06-06T06:20:24.814791Z",
            "action": 17,
            "target": "",
            "id": 2136188,
            "action_name": "Changes committed",
            "url": "https://weblate.osgeo.org/api/changes/2136188/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/2339519/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/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:52:39.690461Z",
            "action": 2,
            "target": "``f_table_catalog``, ``f_table_schema`` och ``f_table_name`` ger det fullständigt kvalificerade namnet på funktionstabellen som innehåller en given geometri.  Eftersom PostgreSQL inte använder kataloger tenderar ``f_table_catalog`` att vara tom.",
            "id": 2136111,
            "action_name": "Translation changed",
            "url": "https://weblate.osgeo.org/api/changes/2136111/?format=api"
        },
        {
            "unit": null,
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/sv/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2025-06-05T21:38:33.081129Z",
            "action": 17,
            "target": "",
            "id": 2136093,
            "action_name": "Changes committed",
            "url": "https://weblate.osgeo.org/api/changes/2136093/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/2339578/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/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-05T16:40:34.689953Z",
            "action": 27,
            "target": ":command:`ST_GeomFromText(text, srid)` returnerar ``geometry``",
            "id": 2136071,
            "action_name": "Translation replaced",
            "url": "https://weblate.osgeo.org/api/changes/2136071/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/2339589/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/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-05T16:40:34.611166Z",
            "action": 27,
            "target": ":command:`ST_GeomFromKML(text)` returnerar ``geometry``",
            "id": 2136069,
            "action_name": "Translation replaced",
            "url": "https://weblate.osgeo.org/api/changes/2136069/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/2339586/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/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-05T16:40:34.473174Z",
            "action": 27,
            "target": ":command:`ST_GeomFromGML(text)` returnerar ``geometry``",
            "id": 2136067,
            "action_name": "Translation replaced",
            "url": "https://weblate.osgeo.org/api/changes/2136067/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/2339582/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/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-05T16:40:34.343358Z",
            "action": 27,
            "target": ":command:`ST_GeomFromWKB(bytea)` returnerar ``geometry``",
            "id": 2136065,
            "action_name": "Translation replaced",
            "url": "https://weblate.osgeo.org/api/changes/2136065/?format=api"
        },
        {
            "unit": null,
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/sv/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2025-06-05T13:18:02.949856Z",
            "action": 17,
            "target": "",
            "id": 2135992,
            "action_name": "Changes committed",
            "url": "https://weblate.osgeo.org/api/changes/2135992/?format=api"
        },
        {
            "unit": "https://weblate.osgeo.org/api/units/2339521/?format=api",
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/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-05T13:17:18.003219Z",
            "action": 2,
            "target": "``coord_dimension`` och ``srid`` definierar geometrins dimension (2-, 3- eller 4-dimensionell) respektive identifieraren för det spatiala referenssystemet som hänvisar till tabellen ``spatial_ref_sys``.",
            "id": 2135988,
            "action_name": "Translation changed",
            "url": "https://weblate.osgeo.org/api/changes/2135988/?format=api"
        },
        {
            "unit": null,
            "component": "https://weblate.osgeo.org/api/components/postgis-workshop/geometries/?format=api",
            "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/geometries/sv/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2025-06-04T17:47:46.127038Z",
            "action": 17,
            "target": "",
            "id": 2135669,
            "action_name": "Changes committed",
            "url": "https://weblate.osgeo.org/api/changes/2135669/?format=api"
        }
    ]
}