postgis-workshop

joins_exercises

	Language	Translated	Unfinished	Unfinished words	Unfinished characters	Untranslated	Checks	Suggestions	Comments
	English		0	0	0	0	0	0	0

	German	0%	29	266	1,937	29	0	0	0

	Japanese		0	0	0	0	0	1	0

	Spanish	0%	29	266	1,937	29	0	0	0

Please sign in to see the alerts.

Overview

Project website	postgis.net/workshops/postgis-intro
Project maintainers	jsanz yellow73 komzpa andischi dkastl astrid_emde dmateos jef 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	Merge pull request #103 from osgeoweblate/weblate-postgis-workshop-index `97ed677` Regina Obe authored yesterday
Last commit in Weblate	Translated using Weblate (Japanese) `e59f5fa` Teramoto Ikuhiro authored 2 months ago
Weblate repository	`https://weblate.osgeo.org/git/postgis-workshop/index/`
File mask	`postgis-intro/sources/locale/*/LC_MESSAGES/joins_exercises.po`

String statistics

	Strings percent	Hosted strings	Words percent	Hosted words	Characters percent	Hosted characters
Total		116		1,064		7,748
Source		29		266		1,937
Translated	50%	58	50%	532	50%	3,874
Needs editing	0%	0	0%	0	0%	0
Read-only	25%	29	25%	266	25%	1,937
Failing checks	0%	0	0%	0	0%	0
Strings with suggestions	1%	1	1%	13	1%	97
Untranslated strings	50%	58	50%	532	50%	3,874

Last 12 months Previous

Activity in last 12 months


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

Quick numbers

1,064

Hosted words

116

Hosted strings

50%

Translated

and previous 30 days

Trends of last 30 days

—

Hosted words

+100%

—

Hosted strings

+100%

—

Translated

+50%

—

Contributors

+100%

Search

Advanced query builder

Query examples

Review strings changed by other users	`changed:>=2023-11-04 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:>=2023-11-04 AND state:<=needs-editing`	Add
Translated strings in a certain language	`is:translated AND language:en`	Add

None New alert postgis-workshop / joins_exercises	Broken project website URL a month ago
None Committed changes postgis-workshop / joins_exercises — Japanese	Committed changes 2 months ago
yellow73 Translation changed postgis-workshop / joins_exercises — Japanese	English What are all the neighborhoods served by the 6-train? (Hint: The ``routes`` column in the ``nyc_subway_stations`` table has values like 'B,D,6,V' and 'C,6') Japanese 13 characters edited Current translation Translated 6列車が走っている町を全てを挙げ~~て下さい~~るとどうなるでしょう? (ヒント: ``nyc_subway_stations``テーブルの ``routes`` カラムは 'B,D,6,V' や 'C,6' のような値を持ちます。) 2 months ago
yellow73 Suggestion accepted postgis-workshop / joins_exercises — Japanese	English :command:`count(expression)`: aggregate to return the size of a set of records Japanese 4 characters edited Current translation Translated :command:`count(expression)`: はレコードの集合のサイズを返す集約関数です 3 months ago
yellow73 Suggestion removed postgis-workshop / joins_exercises — Japanese	English :command:`sum(expression)`: aggregate to return a sum for a set of records Japanese 47 characters edited :command:`sum(expression)` はレコードの集合の合計を返す集約関数です 3 months ago
yellow73 Suggestion accepted postgis-workshop / joins_exercises — Japanese	English What neighborhood has the highest population density (persons/km2)? Japanese 30 characters edited Current translation Translated 最も人口密度 (人/km2) が高い町はどこですか? 3 months ago
yellow73 Suggestion accepted postgis-workshop / joins_exercises — Japanese	English After 9/11, the 'Battery Park' neighborhood was off limits for several days. How many people had to be evacuated? Japanese 67 characters edited Current translation Translated 9/11後、'Battery Park' 町は数日間立ち入り禁止でした。非難しなけれならなかった人の数はどれぐらいでしょうか? 3 months ago
yellow73 Suggestion accepted postgis-workshop / joins_exercises — Japanese	English We used the ``DISTINCT`` keyword to remove duplicate values from our result set where there were more than one subway station in a neighborhood. Japanese 59 characters edited Current translation Translated 一つの町に複数の地下鉄駅がある時に、結果集合から重複値を削除するには ``DISTINCT`` キーワードを使います。 3 months ago
yellow73 Suggestion accepted postgis-workshop / joins_exercises — Japanese	English What are all the neighborhoods served by the 6-train? (Hint: The ``routes`` column in the ``nyc_subway_stations`` table has values like 'B,D,6,V' and 'C,6') Japanese 104 characters edited Translated 6列車が走っている町を全て挙げて下さい (ヒント: ``nyc_subway_stations``テーブルの ``routes`` カラムは 'B,D,6,V' や 'C,6' のような値を持ちます。 3 months ago
yellow73 Suggestion accepted postgis-workshop / joins_exercises — Japanese	English What subway station is in 'Little Italy'? What subway route is it on? Japanese 49 characters edited Current translation Translated 'Little Italy'内にある地下鉄駅はどれでしょう? どの地下鉄路線にありますか? 3 months ago

Browse all component changes