Language Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
English 0 0 0 0 0 0 0
German 0% 15 429 2,591 15 0 0 0
Japanese 0 0 0 0 0 0 0
Spanish 0 0 0 0 0 0 0
Swedish 0 0 0 0 0 0 0
Please sign in to see the alerts.

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 jsanz User avatar andischi User avatar yellow73 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 10 days ago
Last commit in Weblate Translated using Weblate (Spanish) 78c5aae
Weblate authored 3 days ago
Weblate repository https://weblate.osgeo.org/git/postgis-workshop/index/
File mask postgis-intro/sources/locale/*/LC_MESSAGES/knn.po
3 days ago

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 75 2,145 12,955
Source 15 429 2,591
Translated 80% 60 80% 1,716 80% 10,364
Needs editing 0% 0 0% 0 0% 0
Read-only 20% 15 20% 429 20% 2,591
Failing checks 0% 0 0% 0 0% 0
Strings with suggestions 0% 0 0% 0 0% 0
Untranslated strings 20% 15 20% 429 20% 2,591
Last 12 months Previous

Activity in last 12 months

0 changes 0 changes 0 changes 0 changes 16 changes 0 changes 20 changes 0 changes 1 change 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 6 changes 1 change 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

2,145
Hosted words
75
Hosted strings
80%
Translated
3
Contributors
and previous 30 days

Trends of last 30 days

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

Changes committed

  1. postgis-workshop
  2. knn
  3. Swedish
Changes committed 3 days ago
User avatar yeager

Translation changed

  1. postgis-workshop
  2. knn
  3. Swedish
The explain shows the loop on the subway stations, and the index-assisted order by inside the loop where we want it:
Förklaringen visar slingan på tunnelbanestationerna och den indexassisterade beställordningen genom att lägga in slingan där vi vill ha den:
3 days ago
User avatar yeager

Translation changed

  1. postgis-workshop
  2. knn
  3. Swedish
PostgreSQL solves the nearest neighbor problem by introducing an "order by distance" (``<->``) operator that induces the database to use an index to speed up a sorted return set. With an "order by distance" operator in place, a nearest neighbor query can return the "N nearest features" just by adding an ordering and limiting the result set to N entries.
PostgreSQL löser det närmaste grannproblemet genom att införa en "order by distance" (``<->``) operatöor som inducerar databasen att använda ett index för att påskynda en sorterad returuppsättning. Med en "order by distance" -operator på plats kan en närmaste grannfråga returnera "N närmaste funktioner" bara genom att lägga till en beställordning och begränsa resultatuppsättningen till N-poster.
3 days ago
User avatar yeager

Translation changed

  1. postgis-workshop
  2. knn
  3. Swedish
PostgreSQL solves the nearest neighbor problem by introducing an "order by distance" (``<->``) operator that induces the database to use an index to speed up a sorted return set. With an "order by distance" operator in place, a nearest neighbor query can return the "N nearest features" just by adding an ordering and limiting the result set to N entries.
PostgreSQL löser det närmaste grannproblemet genom att införa en "order by distance" (``<->``) operatör som inducerar databasen att använda ett index för att påskynda en sorterad returuppsättning. Med en "order by distance" -operatöor på plats kan en närmaste grannfråga returnera "N närmaste funktioner" bara genom att lägga till en beställning och begränsa resultatuppsättningen till N-poster.
3 days ago
User avatar None

Changes committed

  1. postgis-workshop
  2. knn
  3. Spanish
Changes committed 5 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>>?"
5 days ago
User avatar paulo

Translation completed

  1. postgis-workshop
  2. knn
  3. Spanish
Translation completed 5 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:
5 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.
5 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:
5 days ago
Browse all component changes