postgis-workshop/simple_sql — Spanish @ OSGeo Weblate

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
spatial_relationships_exercises	3%	29	310	2,162	29	0	1	0

geography_exercises	4%	20	233	1,575	20	0	0	0

joins_exercises	31%	20	165	1,213	20	1	2	0

projection_exercises	7%	26	268	1,822	26	0	1	0

advanced_geometry_construction	58%	24	505	3,188	24	2	0	0

simple_sql_exercises		0	0	0	0	16	5	0

3d		0	0	0	0	0	0	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

Browse all components

Overview

Project website	postgis.net/workshops/postgis-intro
Project maintainers	komzpa dmateos dkastl jsanz andischi cvvergara yellow73 astrid_emde 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 12 days 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

12 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


Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Jan	Feb

Quick numbers

599

Hosted words

Hosted strings

100%

Translated

Contributors

and previous 30 days

Trends of last 30 days

—

Hosted words

+100%

—

Hosted strings

+100%

+97%

Translated

+2%

+100%

Contributors

—

None Changes committed postgis-workshop simple_sql Spanish	Changes committed 12 days ago
paulocoronado Translation completed postgis-workshop simple_sql Spanish	Translation completed 12 days ago
paulocoronado Translation added postgis-workshop simple_sql Spanish	English `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. Spanish 230 characters edited Current translation Translated `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. 12 days ago
paulocoronado Translation added postgis-workshop simple_sql Spanish	English `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. Spanish 167 characters edited Current translation Translated `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. 12 days ago
paulocoronado Translation added postgis-workshop simple_sql Spanish	English `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. Spanish 200 characters edited Current translation Translated `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. 12 days ago
paulocoronado Translation added postgis-workshop simple_sql Spanish	English 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. Spanish 259 characters edited Current translation Translated 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. 12 days ago
paulocoronado Translation added postgis-workshop simple_sql Spanish	English "What is the average number of letters in the names of all the neighborhoods in New York City, reported by borough?" Spanish 122 characters edited Current translation Translated "¿Cuál es la media de la cantidad de letras en los nombres de todos los barrios de Nueva York, desglosado por distritos?". 12 days ago
paulocoronado Translation added postgis-workshop simple_sql Spanish	English 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. Spanish 421 characters edited Current translation Translated 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. 12 days ago
paulocoronado Translation changed postgis-workshop simple_sql Spanish	English "What is the average number of letters and standard deviation of number of letters in the names of all the neighborhoods in Brooklyn?" Spanish 1 character edited Current translation Translated "¿Cuál es la media estándar de la longitud de letras en los nombres de todos los barrios de Brooklyn?". 12 days ago
paulocoronado Translation added postgis-workshop simple_sql Spanish	English "What is the average number of letters and standard deviation of number of letters in the names of all the neighborhoods in Brooklyn?" Spanish 104 characters edited Translated "¿Cuál es la media estándar de la longitud de letras en los nombres de todos los barrios de Brooklyn?". 12 days ago

Browse all translation changes

Quick downloads

34	File in original format as translated in the repository	gettext PO file
34	All strings, converted files enriched with comments; suitable for offline translation	CSV	gettext MO	gettext PO	TBX	TMX	XLIFF 1.1 with gettext extensions	XLIFF 1.1	XLSX

Customize download

Search

Advanced query builder

Query examples

Review strings changed by other users	`changed:>=2025-02-23 AND NOT changed_by:anonymous`	Add
Translated strings	`state:>=translated`	Add
Strings with comments	`has:comment`	Add
Strings with any failing checks	`has:check`	Add
Strings with suggestions from others	`has:suggestion AND NOT suggestion_author:anonymous`	Add
Approved strings with suggestions	`state:approved AND has:suggestion`	Add
All untranslated strings added the past month	`added:>=2025-02-23 AND state:<=needs-editing`	Add