Language Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
English 0 0 0 0 14 0 0
Chinese (Simplified) 0 0 0 0 0 0 0
German 0% 43 349 2,525 43 0 0 0
Italian 0% 43 349 2,525 43 0 0 0
Japanese 0 0 0 0 0 0 0
Spanish 0 0 0 0 0 0 0
Swedish 0 0 0 0 12 0 0
Ukrainian 0 0 0 0 3 0 0
Please sign in to see the alerts.

Overview

Project website postgis.net/workshops/postgis-intro
Project maintainers User avatar komzpa User avatar jef User avatar yellow73 User avatar astrid_emde User avatar dmateos User avatar dkastl User avatar jsanz User avatar andischi User avatar cvvergara
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 Update sql cheat sheet with makevalid example 5f99414
Paul Ramsey authored 22 hours ago
Last commit in Weblate Translated using Weblate (Spanish) 4a8aa11
Weblate authored a month ago
Weblate repository https://weblate.osgeo.org/git/postgis-workshop/index/
File mask postgis-intro/sources/locale/*/LC_MESSAGES/simple_sql_exercises.po
2 weeks ago

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 344 2,792 20,200
Source 43 349 2,525
Translated 75% 258 75% 2,094 75% 15,150
Needs editing 0% 0 0% 0 0% 0
Read-only 12% 43 12% 349 12% 2,525
Failing checks 8% 29 3% 92 4% 967
Strings with suggestions 0% 0 0% 0 0% 0
Untranslated strings 25% 86 25% 698 25% 5,050
Last 12 months Previous

Activity in last 12 months

14 changes 0 changes 5 changes 0 changes 63 changes 0 changes 0 changes 0 changes 116 changes 0 changes 0 changes 49 changes 0 changes 0 changes 6 changes 0 changes 2 changes 114 changes 0 changes 0 changes 0 changes 120 changes 0 changes 5 changes
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep

Quick numbers

2,792
Hosted words
344
Hosted strings
75%
Translated
0
Contributors
and previous 30 days

Trends of last 30 days

—
Hosted words
+100%
—
Hosted strings
+100%
—
Translated
+75%
—
Contributors
+100%
User avatar robe

Changes committed

  1. postgis-workshop
  2. simple_sql_exercises
  3. Ukrainian
Changes committed a month ago
User avatar robe

Translation changed

  1. postgis-workshop
  2. simple_sql_exercises
  3. Ukrainian
What is this ``AS``? You can give a table or a column another name by using an alias. Aliases can make queries easier to both write and to read. So instead of our outputted column name as ``sum`` we write it **AS** the more readable ``population``.
Що таке «AS»``AS``? Ви можете надати таблиці або стовпцю іншу назву, використовуючи псевдонім. Псевдоніми можуть спростити як написання, так і читання запитів. Тому замість виведеного імені стовпця «sum»``sum`` ми пишемо **AS** більш зрозуміле «population».
a month ago
User avatar robe

Translation changed

  1. postgis-workshop
  2. simple_sql_exercises
  3. Ukrainian
Number of people self-identifying as "white" in the block
Кількість людей, які самоідентифікуються як «``білі»`` у цьому кварталі
a month ago
User avatar robe

Translation changed

  1. postgis-workshop
  2. simple_sql_exercises
  3. Ukrainian
Using the ``nyc_census_blocks`` table, answer the following questions (don't peek at the answers!).
Використовуючи таблицю «``nyc_census_blocks»``, дайте відповіді на наступні питання (не підглядайте відповіді!).
a month ago
User avatar robe

Contributor joined

  1. postgis-workshop
  2. simple_sql_exercises
  3. Ukrainian
Contributor joined a month ago
User avatar None

Changes committed

  1. postgis-workshop
  2. simple_sql_exercises
  3. Ukrainian
Changes committed 2 months ago
User avatar None

Changes committed

  1. postgis-workshop
  2. simple_sql_exercises
  3. Ukrainian
Changes committed 2 months ago
User avatar dkovshun

Translation changed

  1. postgis-workshop
  2. simple_sql_exercises
  3. Ukrainian
`sum(expression) <http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: PostgreSQL aggregate function that returns the sum of records in a set of records.
`sum(expression) <http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: Агрегатна функція PostgreSQL, яка повертає суму записів у наборі записів.
2 months ago
User avatar dkovshun

Translation completed

  1. postgis-workshop
  2. simple_sql_exercises
  3. Ukrainian
Translation completed 2 months ago
User avatar dkovshun

Translation added

  1. postgis-workshop
  2. simple_sql_exercises
  3. Ukrainian
`sum(expression) <http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: PostgreSQL aggregate function that returns the sum of records in a set of records.
`sum(expression) <http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: Агрегатна функція PostgreSQL, яка повертає суму записів у наборі записів.
2 months ago
Browse all component changes