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 3 0 0
Swedish 0 0 0 0 0 0 0
Ukrainian 0% 34 599 4,000 34 2 2 0
Please sign in to see the alerts.

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 jsanz User avatar andischi User avatar yellow73 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 2 days ago
Last commit in Weblate Translated using Weblate (Spanish) 2c8c71c
User avatar wadmin authored a month ago
Weblate repository https://weblate.osgeo.org/git/postgis-workshop/index/
File mask postgis-intro/sources/locale/*/LC_MESSAGES/simple_sql.po
10 hours ago

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 272 4,792 32,000
Source 34 599 4,000
Translated 62% 171 62% 2,997 62% 20,010
Needs editing 0% 0 0% 0 0% 0
Read-only 12% 34 12% 599 12% 4,000
Failing checks 1% 5 1% 64 1% 487
Strings with suggestions 1% 2 1% 16 1% 213
Untranslated strings 37% 101 37% 1,795 37% 11,990
Last 12 months Previous

Activity in last 12 months

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

Quick numbers

4,193
Hosted words
238
Hosted strings
71%
Translated
1
Contributors
and previous 30 days

Trends of last 30 days

—
Hosted words
+100%
—
Hosted strings
+100%
—
Translated
+71%
−100%
Contributors
+100%
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, яка повертає середнє значення числового стовпця.
20 hours ago
User avatar mt:weblate-translation-memory

Suggestion added

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

Resource updated

  1. postgis-workshop
  2. simple_sql
  3. Ukrainian
File postgis-intro/sources/locale/uk/LC_MESSAGES/simple_sql.po was added. 20 hours 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.
 
20 hours 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.
 
20 hours 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.
 
20 hours ago
User avatar None

String added in the repository

  1. postgis-workshop
  2. simple_sql
  3. Ukrainian
Function List
 
20 hours 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.
 
20 hours 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?"
 
20 hours 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.
 
20 hours ago
Browse all component changes