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 yellow73 User avatar komzpa User avatar dmateos User avatar dkastl User avatar jsanz User avatar andischi 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 #141 from osgeoweblate/weblate-postgis-workshop-index 742f800
Regina Obe authored 10 days ago
Last commit in Weblate Translated using Weblate (Chinese (Simplified)) a0db485
Wangdapeng authored 2 weeks 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
3 days 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 0 changes 0 changes 0 changes 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
Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar

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%
+97%
Translated
+2%
—
Contributors
—
User avatar None

Changes committed

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

Translation completed

  1. postgis-workshop
  2. simple_sql
  3. Spanish
Translation completed a month 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.
a month 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.
a month 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.
a month 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.
a month 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?".
a month 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.
a month 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?".
a month 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?".
a month ago
Browse all translation changes