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% 34 599 4,000 34 0 0 0
Japanese 0 0 0 0 0 0 0
Korean 2% 33 597 3,990 33 0 0 0
Spanish 0 0 0 0 5 0 0
Please sign in to see the alerts.

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 cvvergara User avatar yellow73 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 #140 from ThomasPrioul/patch-2 0a18451
Regina Obe authored 3 weeks ago
Last commit in Weblate Translated using Weblate (Spanish) 50b22d1
Paulo Cesar authored 10 days ago
Weblate repository https://weblate.osgeo.org/git/postgis-workshop/index/
File mask postgis-intro/sources/locale/*/LC_MESSAGES/simple_sql.po
10 days ago

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 204 3,594 24,000
Source 34 599 4,000
Translated 67% 137 66% 2,398 66% 16,010
Needs editing 0% 0 0% 0 0% 0
Read-only 16% 34 16% 599 16% 4,000
Failing checks 2% 5 2% 81 1% 453
Strings with suggestions 0% 0 0% 0 0% 0
Untranslated strings 32% 67 33% 1,196 33% 7,990
Last 12 months Previous

Activity in last 12 months

3 changes 0 changes 0 changes 0 changes 0 changes 0 changes 8 changes 3 changes 1 change 0 changes 0 changes 0 changes 0 changes 0 changes 1 change 0 changes 0 changes 0 changes 77 changes 0 changes 0 changes 0 changes 103 changes 0 changes
Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb

Quick numbers

3,594
Hosted words
204
Hosted strings
67%
Translated
2
Contributors
and previous 30 days

Trends of last 30 days

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

Changes committed

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

Translation completed

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