Overview

Project website postgis.net/workshops/postgis-intro
Project maintainers User avatar jsanz User avatar yellow73 User avatar komzpa User avatar andischi User avatar dkastl User avatar astrid_emde User avatar dmateos User avatar jef 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 Merge pull request #103 from osgeoweblate/weblate-postgis-workshop-index 97ed677
Regina Obe authored 14 hours ago
Last commit in Weblate Translated using Weblate (Japanese) 2418b9b
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_advanced.po
Translation file Download postgis-intro/sources/locale/ja/LC_MESSAGES/joins_advanced.po
Last change Sept. 13, 2023, 8:33 a.m.
Last author Teramoto Ikuhiro

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 40 763 4,781
Translated 100% 40 100% 763 100% 4,781
Needs editing 0% 0 0% 0 0% 0
Read-only 0% 0 0% 0 0% 0
Failing checks 0% 0 0% 0 0% 0
Strings with suggestions 0% 0 0% 0 0% 0
Untranslated strings 0% 0 0% 0 0% 0
Last 12 months Previous

Activity in last 12 months

0 changes 0 changes 1 change 1 change 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 92 changes 0 changes 0 changes 0 changes 0 changes
Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov

Quick numbers

763
Hosted words
40
Hosted strings
100%
Translated
0
Contributors
and previous 30 days

Trends of last 30 days

—
Hosted words
+100%
—
Hosted strings
+100%
—
Translated
+100%
—
Contributors
+100%
User avatar None

Committed changes

postgis-workshop / joins_advanced — Japanese

Committed changes 2 months ago
User avatar yellow73

Suggestion accepted

postgis-workshop / joins_advanced — Japanese

That's better! So a bit over half the population of New York is within 500m (about a 5-7 minute walk) of the subway.
この方がいいです! 地下鉄駅から 500m 圏内 (徒歩約 5-7 分) の人口はニューヨーク市の半分です。
2 months ago
User avatar yellow73

Suggestion accepted

postgis-workshop / joins_advanced — Japanese

The solution is to ensure that we have only distinct census blocks before passing them into the summarization portion of the query. We can do that by breaking our query up into a subquery that finds the distinct blocks, wrapped in a summarization query that returns our answer:
クエリの集約部分に渡す前に、重複しない統計調査細分区だけを持つようにすることで解決できます。クエリを、重複しない細分区を探すサブクエリと、答を返す集約クエリにくるまれたサブクエリとに分割することで、実現できます:
2 months ago
User avatar yellow73

Suggestion accepted

postgis-workshop / joins_advanced — Japanese

There's more people close to the subway than there are people! Clearly, our simple SQL is making a big double-counting error. You can see the problem looking at the picture of the buffered subways.
地下鉄に近い人の人口が、全体の人口を超えてしまっています! 明らかに、この単純な SQL では、大きな二重カウントのエラーを犯しています。バッファリングされた地下鉄の図を見ると、問題点が分かってきます。
2 months ago
User avatar yellow73

Suggestion accepted

postgis-workshop / joins_advanced — Japanese

With the population of the people in New York within 500 meters of a subway station:
ニューヨーク市内の、地下鉄駅から 500m 圏内にいる人の人口は、次の通りです:
2 months ago
User avatar yellow73

Suggestion accepted

postgis-workshop / joins_advanced — Japanese

However, the question runs into some problems of double counting: many people will be within 500 meters of multiple subway stations. Compare the population of New York:
しかしながら、この質問は、複数の地下鉄駅の 500m 圏内に入る人が多数出るという、二重カウントの問題に行き当たります。ニューヨークの人口を比較します:
2 months ago
User avatar yellow73

Suggestion accepted

postgis-workshop / joins_advanced — Japanese

A query that is fun to ask is "How do the commute times of people near (within 500 meters) subway stations differ from those of people far away from subway stations?"
「地下鉄駅近く (500m以内) の人と、そうでない人との通勤時間がどれぐらい違うか?」と聞いてみたいですね。
2 months ago
User avatar yellow73

Suggestion accepted

postgis-workshop / joins_advanced — Japanese

As defined by our data source, Flatbush is not really a neighborhood in the conventional sense, since it just covers the area of Prospect Park. The census tract for that area records, naturally, zero residents. However, the neighborhood boundary does scrape one of the expensive census tracts bordering the north side of the park (in the gentrified Park Slope neighborhood). When using polygon/polygon tests, this single tract was added to the otherwise empty Flatbush, resulting in the very high score for that query.
データソースで定義されている通り、プロスペクト公園だけしかないので、従来の意味ではフラットブッシュは本当の町とは言えません。この領域における国勢調査統計区は、当然のことですが、住民は 0 です。しかし、町境界は公園の北側に隣接する高級な国勢調査統計区の一つ (高級になったパークスロープ) を削ります。ポリゴン/ポリゴンテストを使用すると、この一つの統計区が空っぽのフラットブッシュに追加され、非常に高いスコアになりました。
2 months ago
User avatar yellow73

Suggestion accepted

postgis-workshop / joins_advanced — Japanese

In particular, the Flatbush neighborhood has dropped off the list. The reason why can be seen by looking more closely at the map of the Flatbush neighborhood in our table.
特にフラットブッシュ町はリストから外れました。テーブル内のフラットブッシュ町の地図を詳しく見ると理由が分かります。
2 months ago
User avatar yellow73

Translation changed

postgis-workshop / joins_advanced — Japanese

Avoiding double counting changes the results!
二重カウントを回避すると結果が変わります。!
2 months ago
Browse all translation changes