postgis-workshop

geometry_returning_exercises

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

	German	0%	28	346	2,370	28	0	0	0

	Japanese		0	0	0	0	0	0	0

	Spanish	0%	28	346	2,370	28	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) `145ef53` Teramoto Ikuhiro authored 4 months ago
Weblate repository	`https://weblate.osgeo.org/git/postgis-workshop/index/`
File mask	`postgis-intro/sources/locale/*/LC_MESSAGES/geometry_returning_exercises.po`

String statistics

	Strings percent	Hosted strings	Words percent	Hosted words	Characters percent	Hosted characters
Total		112		1,384		9,480
Source		28		346		2,370
Translated	50%	56	50%	692	50%	4,740
Needs editing	0%	0	0%	0	0%	0
Read-only	25%	28	25%	346	25%	2,370
Failing checks	1%	1	4%	62	3%	329
Strings with suggestions	0%	0	0%	0	0%	0
Untranslated strings	50%	56	50%	692	50%	4,740

Last 12 months Previous

Activity in last 12 months


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

Quick numbers

1,384

Hosted words

112

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:>=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 / geometry_returning_exercises	Broken project website URL a month ago
yellow73 Suggestion accepted postgis-workshop / geometry_returning_exercises — Japanese	English It is easy to buffer both the neighborhoods of interest, but to get the intersection requires a self-join of the table, creating one relation (``ps``) with just the "Park Slope" record and another (``cg``) with just the "Carroll Gardens" record. Note that the area of the intersection is in square meters because we are still working in UTM 18 (EPSG:26918). Japanese 188 characters edited Current translation Translated 両方の対象街区のバッファを生成すると簡単ですが、共有領域の抽出にはテーブルの自己結合が必要です。"Park Slope" で一方のリレーション (``ps``) を作り、"Carroll Gardens" でもう一方のリレーション (``cg``) を作ります。UTM 18 (EPSG:26918) を使っているので共有領域の面積は平方メートル単位であることにご注意下さい。 4 months ago
yellow73 Suggestion accepted postgis-workshop / geometry_returning_exercises — Japanese	English The Brooklyn neighborhoods of ‘Park Slope’ and ‘Carroll Gardens’ are going to war! Construct a polygon delineating a 100 meter wide DMZ on the border between the neighborhoods. What is the area of the DMZ? Japanese 117 characters edited Current translation Translated ブルックリンの ‘Park Slope’ 街区と ‘Carroll Gardens’ 街区とが戦争を起こしました! 街区間の境界に100m幅のDMZ (中立地帯) を描くポリゴンを構築します。DMZ の面積はいくらでしょう? 4 months ago
yellow73 Suggestion accepted postgis-workshop / geometry_returning_exercises — Japanese	English A unit circle (circle with radius of one) should have an area of pi, 3.1415926... The difference is due to the linear stroking of the edges of the buffer. The buffer has a finite number of edges. Increasing the number of edges in the buffer will get the value closer to pi, but it will always be smaller due to the linearization. Japanese 132 characters edited Current translation Translated 単位円 (半径1単位の円) の面積は π (3.1415926...) となります。結果との差は、バッファのエッジの線形描画によるものです。バッファは有限数のエッジでできています。バッファ内のエッジ数の増加でπに近づいていきますが、線形化のため常に小さくなります。 4 months ago
yellow73 Suggestion accepted postgis-workshop / geometry_returning_exercises — Japanese	English What is the area of a one unit buffer around the origin? How different is it from what you would expect? Why? Japanese 59 characters edited Current translation Translated 原点から周囲1単位の範囲内の面積はいくつでしょうか? 予想とどれぐらい違いましたか? また理由は何でしょう? 4 months ago
yellow73 Suggestion accepted postgis-workshop / geometry_returning_exercises — Japanese	English Union all the census blocks into a single output. What kind of geometry is it? How many parts does it have? Japanese 56 characters edited Current translation Translated 全ての国勢調査区を単一の出力に結合します。どういうジオメトリでしょうか? 要素数はいくつになりますか? 4 months ago
yellow73 Suggestion accepted postgis-workshop / geometry_returning_exercises — Japanese	English How many census blocks don’t contain their own centroid? Japanese 30 characters edited Current translation Translated 自身の重心を含まない国勢調査区はいくつありますか? 4 months ago
yellow73 Suggestion accepted postgis-workshop / geometry_returning_exercises — Japanese	English name, popn_total, boroname, geom Japanese 32 characters edited Current translation Translated name, popn_total, boroname, geom 4 months ago
yellow73 Suggestion accepted postgis-workshop / geometry_returning_exercises — Japanese	English Remember the tables we have available: Japanese 18 characters edited Current translation Translated 次のテーブルを覚えておいてください: 4 months ago
yellow73 Suggestion accepted postgis-workshop / geometry_returning_exercises — Japanese	English :command:`ST_Intersection(geometry, geometry)` returns the area that the two input geometries share in common Japanese 70 characters edited Current translation Translated :command:`ST_Intersection(geometry, geometry)` は二つの入力ジオメトリが共有する領域を返します 4 months ago

Browse all component changes