Translation status

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

Strings status

Strings Words Characters
34 599 4,000
All strings Browse Translate Zen
34 599 4,000
Unfinished strings Browse Translate Zen
34 599 4,000
Untranslated strings Browse Translate Zen
2 16 213
Strings with suggestions Browse Translate Zen
32 583 3,787
Unfinished strings without suggestions Browse Translate Zen
2 16 213
Strings with any failing checks Browse Translate Zen
2 16 213
Failing check: Inconsistent Browse Translate Zen

Other components

Component Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
geometry_returning 0% 37 881 6,346 37 2 3 0
license 0 0 0 0 0 0 0
installation CC-BY-3.0-US 0 0 0 0 0 0 0
equality 0 0 0 0 0 0 0
geography_exercises 0 0 0 0 0 0 0
clusterindex 0 0 0 0 1 0 0
joins_exercises 0 0 0 0 0 0 0
linear_referencing 0% 23 553 3,929 23 1 1 0
about_data 0 0 0 0 3 0 0
upgrades 0 0 0 0 0 0 0
Browse all components

Overview

Project website postgis.net/workshops/postgis-intro
Project maintainers User avatar jef User avatar cvvergara User avatar astrid_emde User avatar dmateos User avatar dkastl User avatar yellow73 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 3 weeks ago
Last commit in Weblate Translated using Weblate (Spanish) f56bfb1
Weblate authored 2 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/uk/LC_MESSAGES/simple_sql.po
Last change Aug. 13, 2025, 4:16 p.m.
Last author Weblate Translation Memory
3 weeks ago

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 34 599 4,000
Translated 0% 0 0% 0 0% 0
Needs editing 0% 0 0% 0 0% 0
Read-only 0% 0 0% 0 0% 0
Failing checks 5% 2 2% 16 5% 213
Strings with suggestions 5% 2 2% 16 5% 213
Untranslated strings 100% 34 100% 599 100% 4,000
Last 12 months Previous

Activity in last 12 months

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 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 39 changes
Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug

Quick numbers

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

Trends of last 30 days

+100%
Hosted words
—
+100%
Hosted strings
—
—
Translated
—
+100%
Contributors
—
User avatar mt:weblate-translation-memory

Suggestion added

  1. postgis-workshop
  2. simple_sql
  3. Ukrainian
`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(expression) <http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: Агрегатна функція PostgreSQL, яка повертає середнє значення числового стовпця.
3 weeks ago
User avatar mt:weblate-translation-memory

Suggestion added

  1. postgis-workshop
  2. simple_sql
  3. Ukrainian
Function List
Список функцій
3 weeks ago
User avatar dkovshun

Resource updated

  1. postgis-workshop
  2. simple_sql
  3. Ukrainian
File postgis-intro/sources/locale/uk/LC_MESSAGES/simple_sql.po was added. 3 weeks ago
User avatar None

String added in the repository

  1. postgis-workshop
  2. simple_sql
  3. Ukrainian
`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.
 
3 weeks ago
User avatar None

String added in the repository

  1. postgis-workshop
  2. simple_sql
  3. Ukrainian
`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.
 
3 weeks ago
User avatar None

String added in the repository

  1. postgis-workshop
  2. simple_sql
  3. Ukrainian
`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.
 
3 weeks ago
User avatar None

String added in the repository

  1. postgis-workshop
  2. simple_sql
  3. Ukrainian
Function List
 
3 weeks ago
User avatar None

String added in the repository

  1. postgis-workshop
  2. simple_sql
  3. Ukrainian
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.
 
3 weeks ago
User avatar None

String added in the repository

  1. postgis-workshop
  2. simple_sql
  3. Ukrainian
"What is the average number of letters in the names of all the neighborhoods in New York City, reported by borough?"
 
3 weeks ago
User avatar None

String added in the repository

  1. postgis-workshop
  2. simple_sql
  3. Ukrainian
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.
 
3 weeks ago
Browse all translation changes