Translation status

15 Strings 100%
Browse Translate
429 Words 100%
2,591 Characters 100%

Strings status

Strings Words Characters
15 429 2,591
All strings Browse Translate Zen
15 429 2,591
Translated strings Browse Translate Zen

Other components

Component Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
geometry_returning 16% 31 842 5,993 31 0 0 0
projection_exercises 0 0 0 0 0 0 0
simple_sql_exercises 0 0 0 0 0 0 0
tuning 13% 40 1,080 6,986 40 0 0 0
backup 6% 67 1,610 10,052 67 0 0 0
license 0 0 0 0 0 0 0
installation CC-BY-3.0-US 0 0 0 0 0 0 0
equality 0 0 0 0 0 0 0
joins_advanced 22% 31 645 3,990 31 0 0 0
topology CC-BY-3.0-US 3% 59 1,569 9,947 59 0 0 0
Browse all components

Overview

Project website postgis.net/workshops/postgis-intro
Project maintainers User avatar jef User avatar astrid_emde User avatar dmateos User avatar dkastl User avatar yellow73 User avatar jsanz User avatar andischi User avatar komzpa User avatar cvvergara
Translation process
  • Translations can be made directly.
  • Translation suggestions can be made.
  • Any authenticated user can contribute.
  • The translation uses bilingual files.
Source code repository https://github.com/postgis/postgis-workshops.git
Repository branch master
Last remote commit Merge pull request #146 from AllenSH12/fixups 37f3a52
Regina Obe authored 12 days ago
Last commit in Weblate Translated using Weblate (Spanish) 78c5aae
Weblate authored 4 days ago
Weblate repository https://weblate.osgeo.org/git/postgis-workshop/index/
File mask postgis-intro/sources/locale/*/LC_MESSAGES/knn.po
Translation file Download postgis-intro/sources/locale/es/LC_MESSAGES/knn.po
Last change June 18, 2025, 9:58 a.m.
Last author None
6 days ago

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 15 429 2,591
Translated 100% 15 100% 429 100% 2,591
Needs editing 0% 0 0% 0 0% 0
Read-only 0% 0 0% 0 0% 0
Failing checks 0% 0 0% 0 0% 0
Strings with suggestions 0% 0 0% 0 0% 0
Untranslated strings 0% 0 0% 0 0% 0
Last 12 months Previous

Activity in last 12 months

0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 6 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes
Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May

Quick numbers

429
Hosted words
15
Hosted strings
100%
Translated
2
Contributors
and previous 30 days

Trends of last 30 days

—
Hosted words
+100%
—
Hosted strings
+100%
+80%
Translated
+20%
+100%
Contributors
—
User avatar None

Changes committed

  1. postgis-workshop
  2. knn
  3. Spanish
Changes committed 6 days ago
User avatar paulo

Translation changed

  1. postgis-workshop
  2. knn
  3. Spanish
A frequently posed spatial query is: "what is the nearest <candidate feature> to <query feature>?"
Una pregunta espacial frecuente es : "¿Cuál es la <<entidad>> más cercana a la consulta de entidad realizada?.<<entidad de consulta>>?"
6 days ago
User avatar paulo

Translation completed

  1. postgis-workshop
  2. knn
  3. Spanish
Translation completed 6 days ago
User avatar paulo

Translation added

  1. postgis-workshop
  2. knn
  3. Spanish
The explain shows the loop on the subway stations, and the index-assisted order by inside the loop where we want it:
La explicación muestra el bucle en las estaciones de metro, y el orden asistido por índices dentro del bucle donde queramos:
6 days ago
User avatar paulo

Translation added

  1. postgis-workshop
  2. knn
  3. Spanish
Note the way the ``CROSS JOIN LATERAL`` acts as the inner part of a loop driven by the subways table. Each record in the subways table gets fed into the lateral subquery, one at a time, so you get a nearest result for each subway record.
Observe cómo el ``CROSS JOIN LATERAL`` actúa como la parte interna de un bucle controlado por la tabla subways. Cada registro de la tabla subways se introduce en la subconsulta lateral, de uno en uno, de forma que se obtiene un resultado más cercano para cada registro de metro.
6 days ago
User avatar paulo

Translation added

  1. postgis-workshop
  2. knn
  3. Spanish
Here we will find the nearest street to each subway station:
Aquí encontrará la calle más cercana a cada estación de metro:
6 days ago
User avatar paulo

Translation added

  1. postgis-workshop
  2. knn
  3. Spanish
Fortunately, there's a SQL language feature that allows us to run a query repeatedly driven in a loop: the `LATERAL join <https://medium.com/kkempin/postgresqls-lateral-join-bfd6bd0199df>`_.
Afortunadamente, existe una característica del lenguaje SQL que nos permite ejecutar una consulta en un bucle: el `LATERAL join <https://medium.com/kkempin/postgresqls-lateral-join-bfd6bd0199df>`_.
6 days ago
User avatar paulo

Translation added

  1. postgis-workshop
  2. knn
  3. Spanish
The index assisted order by operator has one major draw back: it only works with a **single geometry literal** on one side of the operator. This is fine for finding the objects nearest to one query object, but does not help for a spatial join, where the goal is to find the nearest neighbor for each of a full set of candidates.
El operador de ordenación por índice tiene un inconveniente importante: sólo funciona con **un único literal geométrico** en un lado del operador. Esto está bien para encontrar los objetos más cercanos a un objeto definido, pero no ayuda para un JOIN espacial, donde el objetivo es encontrar el vecino más cercano para cada uno de los objetos de un conjunto completo de candidatos.
6 days ago
User avatar paulo

Translation added

  1. postgis-workshop
  2. knn
  3. Spanish
Nearest Neighbor Join
Join Vecino más próximo
6 days ago
User avatar paulo

Translation added

  1. postgis-workshop
  2. knn
  3. Spanish
This is the output from ``EXPLAIN``, note the index scan over the order by:
Esta es la salida de ``EXPLAIN``, observe la exploración del índice sobre el order by:
6 days ago
Browse all translation changes