Translation status

34 Strings 100%
Browse Translate
599 Words 100%
4,000 Characters 100%

Strings status

Strings Words Characters
34 599 4,000
All strings Browse Translate Zen
34 599 4,000
Translated strings Browse Translate Zen
5 81 453
Strings with any failing checks Browse Translate Zen
5 81 453
Translated strings with any failing checks Browse Translate Zen
5 81 453
Failing check: Mismatched full stop Browse Translate Zen

Other components

Component Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
geography_exercises 0 0 0 0 7 0 0
projection_exercises 28% 20 252 1,698 20 4 2 0
advanced_geometry_construction 58% 24 505 3,188 24 2 0 0
simple_sql_exercises 0 0 0 0 16 5 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
knn 20% 12 406 2,431 12 1 0 0
equality 0 0 0 0 0 0 0
joins_advanced 5% 38 733 4,562 38 0 0 0
Browse all components

Overview

Project website postgis.net/workshops/postgis-intro
Project maintainers User avatar komzpa User avatar dmateos User avatar dkastl User avatar jsanz User avatar andischi User avatar yellow73 User avatar cvvergara User avatar astrid_emde User avatar jef
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 #143 from osgeoweblate/weblate-postgis-workshop-index 4a5082b
Regina Obe authored 11 days ago
Last commit in Weblate Translated using Weblate (Chinese (Simplified)) a0db485
Wangdapeng authored 2 months ago
Weblate repository https://weblate.osgeo.org/git/postgis-workshop/index/
File mask postgis-intro/sources/locale/*/LC_MESSAGES/simple_sql.po
Translation file Download postgis-intro/sources/locale/es/LC_MESSAGES/simple_sql.po
Last change March 14, 2025, 5:47 a.m.
Last author None
2 weeks ago

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 34 599 4,000
Translated 100% 34 100% 599 100% 4,000
Needs editing 0% 0 0% 0 0% 0
Read-only 0% 0 0% 0 0% 0
Failing checks 14% 5 13% 81 11% 453
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 3 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 0 changes 0 changes 40 changes 0 changes 0 changes 0 changes 0 changes
Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May

Quick numbers

599
Hosted words
34
Hosted strings
100%
Translated
0
Contributors
and previous 30 days

Trends of last 30 days

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

Changes committed

  1. postgis-workshop
  2. simple_sql
  3. Spanish
Changes committed 2 months ago
User avatar paulocoronado

Translation completed

  1. postgis-workshop
  2. simple_sql
  3. Spanish
Translation completed 2 months ago
User avatar paulocoronado

Translation added

  1. postgis-workshop
  2. simple_sql
  3. Spanish
`stddev(expression) <http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-STATISTICS-TABLE>`_: PostgreSQL aggregate function that returns the standard deviation of input values.
`stddev(expresión) <http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-STATISTICS-TABLE>`_: Función de agregación de PostgreSQL que devuelve la desviación estándar de los valores de entrada.
2 months ago
User avatar paulocoronado

Translation added

  1. postgis-workshop
  2. simple_sql
  3. Spanish
`char_length(string) <http://www.postgresql.org/docs/current/static/functions-string.html>`_: PostgreSQL string function that returns the number of character in a string.
`char_length(cadena) <http://www.postgresql.org/docs/current/static/functions-string.html>`_: Función de PostgreSQL que devuelve el número de caracteres de una cadena.
2 months ago
User avatar paulocoronado

Translation added

  1. postgis-workshop
  2. simple_sql
  3. Spanish
`avg(expression) <http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: PostgreSQL aggregate function that returns the average value of a numeric column.
`avg(expresión) <http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: Función de agregación de PostgreSQL que devuelve la media de una columna numérica.
2 months ago
User avatar paulocoronado

Translation added

  1. postgis-workshop
  2. simple_sql
  3. Spanish
We include the ``boroname`` column in the output result so we can determine which statistic applies to which borough. In an aggregate query, you can only output columns that are either (a) members of the grouping clause or (b) aggregate functions.
Incluimos la columna ``boroname`` en el resultado de salida para poder determinar qué estadística se aplica a qué distrito. En una consulta agregada, sólo se pueden mostrar columnas que sean (a) miembros de la cláusula de agrupación o (b) funciones agregadas.
2 months ago
User avatar paulocoronado

Translation added

  1. postgis-workshop
  2. simple_sql
  3. Spanish
"What is the average number of letters in the names of all the neighborhoods in New York City, reported by borough?"
"¿Cuál es la media de la cantidad de letras en los nombres de todos los barrios de Nueva York, desglosado por distritos?".
2 months ago
User avatar paulocoronado

Translation added

  1. postgis-workshop
  2. simple_sql
  3. Spanish
The aggregate functions in our last example were applied to every row in the result set. What if we want the summaries to be carried out over smaller groups within the overall result set? For that we add a ``GROUP BY`` clause. Aggregate functions often need an added ``GROUP BY`` statement to group the result-set by one or more columns.
Las funciones de agregación de nuestro último ejemplo se aplicaron a todas las filas del conjunto de resultados. ¿Qué ocurre si queremos que los resúmenes se realicen sobre grupos más pequeños dentro del conjunto de resultados global? Para ello añadimos una cláusula ``GROUP BY``. Las funciones agregadas a menudo necesitan una sentencia ``GROUP BY`` añadida para agrupar el conjunto de resultados por una o más columnas.
2 months ago
User avatar paulocoronado

Translation changed

  1. postgis-workshop
  2. simple_sql
  3. Spanish
"What is the average number of letters and standard deviation of number of letters in the names of all the neighborhoods in Brooklyn?"
"¿Cuál es la media estándar de la longitud de letras en los nombres de todos los barrios de Brooklyn?".
2 months ago
User avatar paulocoronado

Translation added

  1. postgis-workshop
  2. simple_sql
  3. Spanish
"What is the average number of letters and standard deviation of number of letters in the names of all the neighborhoods in Brooklyn?"
"¿Cuál es la media estándar de la longitud de letras en los nombres de todos los barrios de Brooklyn?".
2 months ago
Browse all translation changes