Language Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
English 0 0 0 0 0 0 0
Chinese (Simplified) 0 0 0 0 0 0 0
German 0% 35 868 5,703 35 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 1 0
Please sign in to see the alerts.

Overview

Project website postgis.net/workshops/postgis-intro
Project maintainers User avatar yellow73 User avatar jef User avatar cvvergara User avatar astrid_emde User avatar dmateos User avatar dkastl User avatar jsanz User avatar andischi User avatar komzpa
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 #154 from osgeoweblate/weblate-postgis-workshop-index 049c112
Regina Obe authored a month ago
Last commit in Weblate Translated using Weblate (Swedish) 24788ae
User avatar wadmin authored 2 weeks ago
Weblate repository https://weblate.osgeo.org/git/postgis-workshop/index/
File mask postgis-intro/sources/locale/*/LC_MESSAGES/joins.po
2 weeks ago

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 210 5,208 34,218
Source 35 868 5,703
Translated 83% 175 83% 4,340 83% 28,515
Needs editing 0% 0 0% 0 0% 0
Read-only 16% 35 16% 868 16% 5,703
Failing checks 0% 0 0% 0 0% 0
Strings with suggestions 1% 1 1% 19 1% 169
Untranslated strings 16% 35 16% 868 16% 5,703
Last 12 months Previous

Activity in last 12 months

0 changes 0 changes 1 change 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 54 changes 0 changes 0 changes 8 changes 0 changes 0 changes 43 changes 1 change 3 changes 90 changes 0 changes 0 changes 0 changes 0 changes
Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug

Quick numbers

5,208
Hosted words
210
Hosted strings
83%
Translated
2
Contributors
and previous 30 days

Trends of last 30 days

—
Hosted words
+100%
—
Hosted strings
+100%
+15%
Translated
+68%
+100%
Contributors
—
User avatar None

Changes committed

  1. postgis-workshop
  2. joins
  3. Spanish
Changes committed 2 weeks ago
User avatar paulo

Translation changed

  1. postgis-workshop
  2. joins
  3. Spanish
`round(v numeric, s integer) <http://www.postgresql.org/docs/current/interactive/functions-math.html>`_: PostgreSQL math function that rounds to s decimal places
`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.
2 weeks ago
User avatar paulo

Translation completed

  1. postgis-workshop
  2. joins
  3. Spanish
Translation completed 2 weeks ago
User avatar paulo

Translation added

  1. postgis-workshop
  2. joins
  3. Spanish
`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.
`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.
2 weeks ago
User avatar paulo

Translation added

  1. postgis-workshop
  2. joins
  3. Spanish
`round(v numeric, s integer) <http://www.postgresql.org/docs/current/interactive/functions-math.html>`_: PostgreSQL math function that rounds to s decimal places
`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.
2 weeks ago
User avatar paulo

Translation added

  1. postgis-workshop
  2. joins
  3. Spanish
`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).
`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).
2 weeks ago
User avatar paulo

Translation added

  1. postgis-workshop
  2. joins
  3. Spanish
`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.
`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í.
2 weeks ago
User avatar paulo

Translation added

  1. postgis-workshop
  2. joins
  3. Spanish
`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.
`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.
2 weeks ago
User avatar paulo

Translation added

  1. postgis-workshop
  2. joins
  3. Spanish
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.
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.
2 weeks ago
User avatar paulo

Translation added

  1. postgis-workshop
  2. joins
  3. Spanish
Now we can join the table of subway lines onto our original query.
Ahora podemos unir la tabla de líneas de metro a nuestra consulta original.
2 weeks ago
Browse all component changes