Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/postgis-workshop/joins/es/units/?format=api
{ "count": 35, "next": null, "previous": null, "results": [ { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/es/?format=api", "source": [ "Spatial Joins" ], "previous_source": "", "target": [ "Joins Espaciales" ], "id_hash": -5425486766171526135, "content_hash": -5425486766171526135, "location": "../../en/joins.rst:4", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://weblate.osgeo.org/api/units/100140/?format=api", "priority": 100, "id": 100635, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins/es/?checksum=34b4cc8818c36c09", "url": "https://weblate.osgeo.org/api/units/100635/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.138878Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/es/?format=api", "source": [ "Spatial joins are the bread-and-butter of spatial databases. They allow you to combine information from different tables by using spatial relationships as the join key. Much of what we think of as \"standard GIS analysis\" can be expressed as spatial joins." ], "previous_source": "", "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_hash": 1724638230228873817, "content_hash": 1724638230228873817, "location": "../../en/joins.rst:6", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://weblate.osgeo.org/api/units/100145/?format=api", "priority": 100, "id": 100636, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins/es/?checksum=97ef255536d9b259", "url": "https://weblate.osgeo.org/api/units/100636/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.141044Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/es/?format=api", "source": [ "In the previous section, we explored spatial relationships using a two-step process: first we extracted a subway station point for 'Broad St'; then, we used that point to ask further questions such as \"what neighborhood is the 'Broad St' station in?\"" ], "previous_source": "", "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_hash": 8998108940892953547, "content_hash": 8998108940892953547, "location": "../../en/joins.rst:8", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 3, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://weblate.osgeo.org/api/units/100148/?format=api", "priority": 100, "id": 100637, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins/es/?checksum=fcdfb4686030dbcb", "url": "https://weblate.osgeo.org/api/units/100637/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.142935Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/es/?format=api", "source": [ "Using a spatial join, we can answer the question in one step, retrieving information about the subway station and the neighborhood that contains it:" ], "previous_source": "", "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_hash": 7798048384651666458, "content_hash": 7798048384651666458, "location": "../../en/joins.rst:10", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 4, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://weblate.osgeo.org/api/units/100151/?format=api", "priority": 100, "id": 100638, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins/es/?checksum=ec383bb0a478a41a", "url": "https://weblate.osgeo.org/api/units/100638/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.144665Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/es/?format=api", "source": [ "We could have joined every subway station to its containing neighborhood, but in this case we wanted information about just one. Any function that provides a true/false relationship between two tables can be used to drive a spatial join, but the most commonly used ones are: :command:`ST_Intersects`, :command:`ST_Contains`, and :command:`ST_DWithin`." ], "previous_source": "", "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_hash": 5088780059535443474, "content_hash": 5088780059535443474, "location": "../../en/joins.rst:29", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 5, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 50, "source_unit": "https://weblate.osgeo.org/api/units/100154/?format=api", "priority": 100, "id": 100640, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins/es/?checksum=c69efa80acb38612", "url": "https://weblate.osgeo.org/api/units/100640/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.146442Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/es/?format=api", "source": [ "Join and Summarize" ], "previous_source": "", "target": [ "Unir y resumir" ], "id_hash": -1847153558732912639, "content_hash": -1847153558732912639, "location": "../../en/joins.rst:32", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://weblate.osgeo.org/api/units/100157/?format=api", "priority": 100, "id": 100642, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins/es/?checksum=665d979ffe204801", "url": "https://weblate.osgeo.org/api/units/100642/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.148152Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/es/?format=api", "source": [ "The combination of a ``JOIN`` with a ``GROUP BY`` provides the kind of analysis that is usually done in a GIS system." ], "previous_source": "", "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_hash": -4227252774726392639, "content_hash": -4227252774726392639, "location": "../../en/joins.rst:34", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://weblate.osgeo.org/api/units/100159/?format=api", "priority": 100, "id": 100643, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins/es/?checksum=4555c7ff92a624c1", "url": "https://weblate.osgeo.org/api/units/100643/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.149756Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/es/?format=api", "source": [ "For example: **\"What is the population and racial make-up of the neighborhoods of Manhattan?\"** Here we have a question that combines information from about population from the census with the boundaries of neighborhoods, with a restriction to just one borough of Manhattan." ], "previous_source": "", "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_hash": -3593446660621537819, "content_hash": -3593446660621537819, "location": "../../en/joins.rst:36", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 8, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://weblate.osgeo.org/api/units/100161/?format=api", "priority": 100, "id": 100644, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins/es/?checksum=4e21834d1256ede5", "url": "https://weblate.osgeo.org/api/units/100644/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.151404Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/es/?format=api", "source": [ "What's going on here? Notionally (the actual evaluation order is optimized under the covers by the database) this is what happens:" ], "previous_source": "", "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_hash": 5132787266087895283, "content_hash": 5132787266087895283, "location": "../../en/joins.rst:88", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 9, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://weblate.osgeo.org/api/units/100163/?format=api", "priority": 100, "id": 100645, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins/es/?checksum=c73b52d2e6d140f3", "url": "https://weblate.osgeo.org/api/units/100645/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.153149Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/es/?format=api", "source": [ "The ``JOIN`` clause creates a virtual table that includes columns from both the neighborhoods and census tables." ], "previous_source": "", "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_hash": -2693526692474564121, "content_hash": -2693526692474564121, "location": "../../en/joins.rst:90", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 10, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://weblate.osgeo.org/api/units/100177/?format=api", "priority": 100, "id": 100646, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins/es/?checksum=5a9eabbe7e0551e7", "url": "https://weblate.osgeo.org/api/units/100646/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.154817Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/es/?format=api", "source": [ "The ``WHERE`` clause filters our virtual table to just rows in Manhattan." ], "previous_source": "", "target": [ "La cláusula ``WHERE`` filtra nuestra tabla virtual a solo filas en Manhattan." ], "id_hash": -8850922359759847952, "content_hash": -8850922359759847952, "location": "../../en/joins.rst:91", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 11, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://weblate.osgeo.org/api/units/100194/?format=api", "priority": 100, "id": 100647, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins/es/?checksum=052b35020bf3bdf0", "url": "https://weblate.osgeo.org/api/units/100647/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.156479Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/es/?format=api", "source": [ "The remaining rows are grouped by the neighborhood name and fed through the aggregation function to :command:`Sum()` the population values." ], "previous_source": "", "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_hash": -9045473858693384040, "content_hash": -9045473858693384040, "location": "../../en/joins.rst:92", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 12, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://weblate.osgeo.org/api/units/100211/?format=api", "priority": 100, "id": 100648, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins/es/?checksum=02780573537fb898", "url": "https://weblate.osgeo.org/api/units/100648/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.158101Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/es/?format=api", "source": [ "After a little arithmetic and formatting (e.g., ``GROUP BY``, ``ORDER BY``) on the final numbers, our query spits out the percentages." ], "previous_source": "", "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_hash": 2127088926380224508, "content_hash": 2127088926380224508, "location": "../../en/joins.rst:93", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 13, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://weblate.osgeo.org/api/units/100224/?format=api", "priority": 100, "id": 100649, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins/es/?checksum=9d84f01bd68f6ffc", "url": "https://weblate.osgeo.org/api/units/100649/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.159780Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/es/?format=api", "source": [ "The ``JOIN`` clause combines two ``FROM`` items. By default, we are using an ``INNER JOIN``, but there are four other types of joins. For further information see the `join_type <http://www.postgresql.org/docs/9.1/interactive/sql-select.html#SQL-FROM>`_ definition in the PostgreSQL documentation." ], "previous_source": "", "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_hash": -3677532737146978112, "content_hash": -3677532737146978112, "location": "../../en/joins.rst:97", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 14, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://weblate.osgeo.org/api/units/100227/?format=api", "priority": 100, "id": 100650, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins/es/?checksum=4cf6c775c07c00c0", "url": "https://weblate.osgeo.org/api/units/100650/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.161449Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/es/?format=api", "source": [ "We can also use distance tests as a join key, to create summarized \"all items within a radius\" queries. Let's explore the racial geography of New York using distance queries." ], "previous_source": "", "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_hash": 1897920025893632328, "content_hash": 1897920025893632328, "location": "../../en/joins.rst:99", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 15, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://weblate.osgeo.org/api/units/100283/?format=api", "priority": 100, "id": 100651, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins/es/?checksum=9a56c4353b7d7948", "url": "https://weblate.osgeo.org/api/units/100651/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.163225Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/es/?format=api", "source": [ "First, let's get the baseline racial make-up of the city." ], "previous_source": "", "target": [ "Primero, obtengamos la composición racial de referencia de la ciudad." ], "id_hash": 8445889119057210940, "content_hash": 8445889119057210940, "location": "../../en/joins.rst:101", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 16, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://weblate.osgeo.org/api/units/100299/?format=api", "priority": 100, "id": 100652, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins/es/?checksum=f535d367d1bdee3c", "url": "https://weblate.osgeo.org/api/units/100652/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.164892Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/es/?format=api", "source": [ "So, of the 8M people in New York, about 44% are recorded as \"white\" and 26% are recorded as \"black\"." ], "previous_source": "", "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_hash": -1119824914707765487, "content_hash": -1119824914707765487, "location": "../../en/joins.rst:118", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 17, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://weblate.osgeo.org/api/units/100314/?format=api", "priority": 100, "id": 100653, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins/es/?checksum=7075952c54362711", "url": "https://weblate.osgeo.org/api/units/100653/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.166585Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/es/?format=api", "source": [ "Duke Ellington once sang that \"You / must take the A-train / To / go to Sugar Hill way up in Harlem.\" As we saw earlier, Harlem has far and away the highest African-American population in Manhattan (80.5%). Is the same true of Duke's A-train?" ], "previous_source": "", "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_hash": -1342548986431579362, "content_hash": -1342548986431579362, "location": "../../en/joins.rst:120", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 18, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 45, "source_unit": "https://weblate.osgeo.org/api/units/100321/?format=api", "priority": 100, "id": 100655, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins/es/?checksum=6d5e4ecf5a2f5b1e", "url": "https://weblate.osgeo.org/api/units/100655/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.168354Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/es/?format=api", "source": [ "First, note that the contents of the ``nyc_subway_stations`` table ``routes`` field is what we are interested in to find the A-train. The values in there are a little complex." ], "previous_source": "", "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_hash": -7300359216607236646, "content_hash": -7300359216607236646, "location": "../../en/joins.rst:122", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 19, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://weblate.osgeo.org/api/units/100323/?format=api", "priority": 100, "id": 100657, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins/es/?checksum=1aafe9f8b1606dda", "url": "https://weblate.osgeo.org/api/units/100657/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.170096Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/es/?format=api", "source": [ "The ``DISTINCT`` keyword eliminates duplicate rows from the result. Without the ``DISTINCT`` keyword, the query above identifies 491 results instead of 73." ], "previous_source": "", "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_hash": -3003700658704677879, "content_hash": -3003700658704677879, "location": "../../en/joins.rst:140", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 20, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://weblate.osgeo.org/api/units/100325/?format=api", "priority": 100, "id": 100658, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins/es/?checksum=5650b62a4a4d0409", "url": "https://weblate.osgeo.org/api/units/100658/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.171922Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/es/?format=api", "source": [ "So to find the A-train, we will want any row in ``routes`` that has an 'A' in it. We can do this a number of ways, but today we will use the fact that :command:`strpos(routes,'A')` will return a non-zero number only if 'A' is in the ``routes`` field." ], "previous_source": "", "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_hash": -2623652864075220262, "content_hash": -2623652864075220262, "location": "../../en/joins.rst:142", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 21, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 48, "source_unit": "https://weblate.osgeo.org/api/units/100327/?format=api", "priority": 100, "id": 100659, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins/es/?checksum=5b96e99eeedc3ada", "url": "https://weblate.osgeo.org/api/units/100659/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.173570Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/es/?format=api", "source": [ "Let's summarize the racial make-up of within 200 meters of the A-train line." ], "previous_source": "", "target": [ "Resumamos la composición racial dentro de 200 metros de la línea del tren A." ], "id_hash": -598279198790900837, "content_hash": -598279198790900837, "location": "../../en/joins.rst:162", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 22, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://weblate.osgeo.org/api/units/100333/?format=api", "priority": 100, "id": 100660, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins/es/?checksum=77b27c3d0f90239b", "url": "https://weblate.osgeo.org/api/units/100660/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.175262Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/es/?format=api", "source": [ "So the racial make-up along the A-train isn't radically different from the make-up of New York City as a whole." ], "previous_source": "", "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_hash": -192670648102174808, "content_hash": -192670648102174808, "location": "../../en/joins.rst:181", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 23, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://weblate.osgeo.org/api/units/100352/?format=api", "priority": 100, "id": 100661, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins/es/?checksum=7d537f10fd39bfa8", "url": "https://weblate.osgeo.org/api/units/100661/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.176846Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/es/?format=api", "source": [ "Advanced Join" ], "previous_source": "", "target": [ "Joins avanzados" ], "id_hash": -6904937117022797415, "content_hash": -6904937117022797415, "location": "../../en/joins.rst:184", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 24, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://weblate.osgeo.org/api/units/100379/?format=api", "priority": 100, "id": 100662, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins/es/?checksum=202cbc46a7724199", "url": "https://weblate.osgeo.org/api/units/100662/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.178496Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/es/?format=api", "source": [ "In the last section we saw that the A-train didn't serve a population that differed much from the racial make-up of the rest of the city. Are there any trains that have a non-average racial make-up?" ], "previous_source": "", "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_hash": -7165230616024674765, "content_hash": -7165230616024674765, "location": "../../en/joins.rst:186", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 25, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://weblate.osgeo.org/api/units/100393/?format=api", "priority": 100, "id": 100663, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins/es/?checksum=1c8ffcb7be188e33", "url": "https://weblate.osgeo.org/api/units/100663/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.180096Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/es/?format=api", "source": [ "To answer that question, we'll add another join to our query, so that we can simultaneously calculate the make-up of many subway lines at once. To do that, we'll need to create a new table that enumerates all the lines we want to summarize." ], "previous_source": "", "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_hash": 5389970817759621817, "content_hash": 5389970817759621817, "location": "../../en/joins.rst:188", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 26, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 44, "source_unit": "https://weblate.osgeo.org/api/units/100408/?format=api", "priority": 100, "id": 100664, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins/es/?checksum=cacd05e6c648b2b9", "url": "https://weblate.osgeo.org/api/units/100664/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.181767Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/es/?format=api", "source": [ "Now we can join the table of subway lines onto our original query." ], "previous_source": "", "target": [ "Ahora podemos unir la tabla de líneas de metro a nuestra consulta original." ], "id_hash": 2361798782662354016, "content_hash": 2361798782662354016, "location": "../../en/joins.rst:199", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 27, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://weblate.osgeo.org/api/units/100416/?format=api", "priority": 100, "id": 100665, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins/es/?checksum=a0c6cb7abf8a2460", "url": "https://weblate.osgeo.org/api/units/100665/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.183495Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/es/?format=api", "source": [ "As before, the joins create a virtual table of all the possible combinations available within the constraints of the ``JOIN ON`` restrictions, and those rows are then fed into a ``GROUP`` summary. The spatial magic is in the ``ST_DWithin`` function, that ensures only census blocks close to the appropriate subway stations are included in the calculation." ], "previous_source": "", "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_hash": -7505817473923993912, "content_hash": -7505817473923993912, "location": "../../en/joins.rst:244", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 28, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 56, "source_unit": "https://weblate.osgeo.org/api/units/100417/?format=api", "priority": 100, "id": 100666, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins/es/?checksum=17d5fac665d72ec8", "url": "https://weblate.osgeo.org/api/units/100666/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.185157Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/es/?format=api", "source": [ "Function List" ], "previous_source": "", "target": [ "Lista de funciones" ], "id_hash": 2815949782297668712, "content_hash": 2815949782297668712, "location": "../../en/joins.rst:247", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 29, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://weblate.osgeo.org/api/units/100418/?format=api", "priority": 100, "id": 100667, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins/es/?checksum=a71443684f30ec68", "url": "https://weblate.osgeo.org/api/units/100667/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.187235Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/es/?format=api", "source": [ "`ST_Contains(geometry A, geometry B) <http://postgis.net/docs/ST_Contains.html>`_: Returns true if and only if no points of B lie in the exterior of A, and at least one point of the interior of B lies in the interior of A." ], "previous_source": "", "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_hash": -3461741183843462030, "content_hash": -3461741183843462030, "location": "../../en/joins.rst:249", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 30, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://weblate.osgeo.org/api/units/100434/?format=api", "priority": 100, "id": 100669, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins/es/?checksum=4ff56cbc00ab9472", "url": "https://weblate.osgeo.org/api/units/100669/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.189098Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/es/?format=api", "source": [ "`ST_DWithin(geometry A, geometry B, radius) <http://postgis.net/docs/ST_DWithin.html>`_: Returns true if the geometries are within the specified distance of one another." ], "previous_source": "", "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_hash": -351803667909692060, "content_hash": -351803667909692060, "location": "../../en/joins.rst:251", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 31, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://weblate.osgeo.org/api/units/100448/?format=api", "priority": 100, "id": 100670, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins/es/?checksum=7b1e246d8f903564", "url": "https://weblate.osgeo.org/api/units/100670/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.190819Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/es/?format=api", "source": [ "`ST_Intersects(geometry A, geometry B) <http://postgis.net/docs/ST_Intersects.html>`_: Returns TRUE if the Geometries/Geography \"spatially intersect\" - (share any portion of space) and FALSE if they don't (they are Disjoint)." ], "previous_source": "", "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_hash": -1853455483272913415, "content_hash": -1853455483272913415, "location": "../../en/joins.rst:253", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 32, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://weblate.osgeo.org/api/units/100449/?format=api", "priority": 100, "id": 100672, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins/es/?checksum=6647340ed8849df9", "url": "https://weblate.osgeo.org/api/units/100672/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.192524Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/es/?format=api", "source": [ "`round(v numeric, s integer) <http://www.postgresql.org/docs/current/interactive/functions-math.html>`_: PostgreSQL math function that rounds to s decimal places" ], "previous_source": "", "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_hash": -8324492604403631257, "content_hash": -8324492604403631257, "location": "../../en/joins.rst:255", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 33, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://weblate.osgeo.org/api/units/100450/?format=api", "priority": 100, "id": 100673, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins/es/?checksum=0c797614d327bb67", "url": "https://weblate.osgeo.org/api/units/100673/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.194252Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/es/?format=api", "source": [ "`strpos(string, substring) <http://www.postgresql.org/docs/current/static/functions-string.html>`_: PostgreSQL string function that returns an integer location of a specified substring." ], "previous_source": "", "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_hash": 292966121382721450, "content_hash": 292966121382721450, "location": "../../en/joins.rst:257", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 34, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://weblate.osgeo.org/api/units/100451/?format=api", "priority": 100, "id": 100674, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins/es/?checksum=8410d3229c3db7aa", "url": "https://weblate.osgeo.org/api/units/100674/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.195936Z" }, { "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/es/?format=api", "source": [ "`sum(expression) <http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: PostgreSQL aggregate function that returns the sum of records in a set of records." ], "previous_source": "", "target": [ "`sum(expresión) <http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: Función de PostgreSQL que devuelve la suma de los valores de un conjunto de registros." ], "id_hash": 3440714517161692930, "content_hash": 3440714517161692930, "location": "../../en/joins.rst:259", "context": "", "note": "", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 35, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://weblate.osgeo.org/api/units/100452/?format=api", "priority": 100, "id": 100675, "web_url": "https://weblate.osgeo.org/translate/postgis-workshop/joins/es/?checksum=afbfdf9fa8f3cf02", "url": "https://weblate.osgeo.org/api/units/100675/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-11-14T01:14:46.197641Z" } ] }