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	3	0	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 cvvergara komzpa dmateos yellow73 dkastl andischi 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 #120 from osgeoweblate/weblate-postgis-workshop-index `75182f2` Regina Obe authored 3 weeks ago
Last commit in Weblate	Translated using Weblate (Japanese) `d09fe53` Teramoto Ikuhiro authored a month ago
Weblate repository	`https://weblate.osgeo.org/git/postgis-workshop/index/`
File mask	`postgis-intro/sources/locale/*/LC_MESSAGES/joins_exercises.po`

2 weeks ago

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	2%	3	1%	3	1%	65
Strings with suggestions	0%	0	0%	0	0%	0
Untranslated strings	50%	58	50%	532	50%	3,874

Last 12 months Previous

Activity in last 12 months


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

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

—

Search

Advanced query builder

Query examples

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

None Changes committed postgis-workshop joins_exercises Japanese	Changes committed a month ago
yellow73 Suggestion accepted postgis-workshop joins_exercises Japanese	English ``nyc_neighborhoods`` Japanese 4 characters edited Current translation Translated ``nyc_neighborhoods`` a month ago
yellow73 Suggestion accepted postgis-workshop joins_exercises Japanese	English ``nyc_subway_stations`` Japanese 4 characters edited Current translation Translated ``nyc_subway_stations`` a month ago
yellow73 Suggestion accepted postgis-workshop joins_exercises Japanese	English ``nyc_census_blocks`` Japanese 4 characters edited Current translation Translated ``nyc_census_blocks`` a month ago
None Changes committed postgis-workshop joins_exercises Japanese	Changes committed a month ago
yellow73 Suggestion removed postgis-workshop joins_exercises Japanese	Rejection reason 引数名が原文に従っていないので English :command:`ST_Contains(geometry A, geometry B)` returns the true if geometry A contains geometry B Japanese 86 characters edited :command:`ST_Contains(geometry1, geometry2)` は geometry1 が geometry2 を含む場合に TRUE を返します a month ago
yellow73 Suggestion accepted postgis-workshop joins_exercises Japanese	English What neighborhood has the highest population density (persons/km2)? Japanese 2 characters edited Current translation Translated 最も人口密度 (人/km2) が高い町地区はどこですか? a month 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 3 characters edited Current translation Translated 9/11後、'Battery Park' 町地区は数日間立ち入り禁止でした。非避難しなけれならなかった人の数はどれぐらいでしょうか? a month 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 2 characters edited Current translation Translated 一つの町地区に複数の地下鉄駅がある時に、結果集合から重複値を削除するには ``DISTINCT`` キーワードを使います。 a month 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 2 characters edited Current translation Translated 6列車が走っている町地区を全てを挙げるとどうなるでしょう? (ヒント: ``nyc_subway_stations``テーブルの ``routes`` カラムは 'B,D,6,V' や 'C,6' のような値を持ちます) a month ago

Browse all component changes