Language Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
English 0 0 0 0 0 0 0
German 0% 40 763 4,781 40 0 0 0
Japanese 0 0 0 0 0 0 0
Spanish 5% 38 733 4,562 38 0 0 0
Please sign in to see the alerts.

Overview

Project website postgis.net/workshops/postgis-intro
Project maintainers User avatar komzpa User avatar dmateos User avatar dkastl User avatar jsanz User avatar andischi User avatar cvvergara User avatar yellow73 User avatar astrid_emde User avatar 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 #140 from ThomasPrioul/patch-2 0a18451
Regina Obe authored 3 weeks ago
Last commit in Weblate Translated using Weblate (Spanish) c2a4899
Paulo Cesar authored 10 days ago
Weblate repository https://weblate.osgeo.org/git/postgis-workshop/index/
File mask postgis-intro/sources/locale/*/LC_MESSAGES/joins_advanced.po
3 days ago

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 160 3,052 19,124
Source 40 763 4,781
Translated 51% 82 50% 1,556 51% 9,781
Needs editing 0% 0 0% 0 0% 0
Read-only 25% 40 25% 763 25% 4,781
Failing checks 0% 0 0% 0 0% 0
Strings with suggestions 0% 0 0% 0 0% 0
Untranslated strings 48% 78 49% 1,496 48% 9,343
Last 12 months Previous

Activity in last 12 months

3 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 1 change 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 11 changes 1 change
Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb

Quick numbers

3,052
Hosted words
160
Hosted strings
51%
Translated
2
Contributors
and previous 30 days

Trends of last 30 days

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

Changes committed

  1. postgis-workshop
  2. joins_advanced
  3. Spanish
Changes committed 10 days ago
User avatar paulocoronado

Translation added

  1. postgis-workshop
  2. joins_advanced
  3. Spanish
In the last section we saw the :command:`ST_Centroid(geometry)` and :command:`ST_Union([geometry])` functions, and some simple examples. In this section we will do some more elaborate things with them.
En la última sección vimos las funciones :command:`ST_Centroid(geometría)` y :command:`ST_Union([geometría])`, y algunos ejemplos sencillos. En esta sección haremos algunas cosas más elaboradas con ellas.
10 days ago
User avatar paulocoronado

Translation added

  1. postgis-workshop
  2. joins_advanced
  3. Spanish
More Spatial Joins
Más Joins Espaciales
10 days ago
User avatar paulocoronado

Contributor joined

  1. postgis-workshop
  2. joins_advanced
  3. Spanish
Contributor joined 10 days ago
User avatar None

Alert triggered

  1. postgis-workshop
  2. joins_advanced
Component seems unused. 3 weeks ago
User avatar None

Changes committed

  1. postgis-workshop
  2. joins_advanced
  3. Japanese
Changes committed a year ago
User avatar yellow73

Suggestion accepted

  1. postgis-workshop
  2. joins_advanced
  3. 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 です。しかし、町地区境界は公園の北側に隣接する高級な国勢調査統計区の一つ (高級になったパークスロープ) を削ります。ポリゴン/ポリゴンテストを使用すると、この一つの統計区が空っぽのフラットブッシュに追加され、非常に高いスコアになりました。
a year ago
User avatar yellow73

Suggestion accepted

  1. postgis-workshop
  2. joins_advanced
  3. 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.
特にフラットブッシュ町地区はリストから外れました。テーブル内のフラットブッシュ町地区の地図を詳しく見ると理由が分かります。
a year ago
User avatar yellow73

Suggestion accepted

  1. postgis-workshop
  2. joins_advanced
  3. Japanese
In our interesting query (in :ref:`interestingquestion`) we used the :command:`ST_Intersects(geometry_a, geometry_b)` function to determine which census tract polygons to include in each neighborhood summary. Which leads to the question: what if a tract falls on the border between two neighborhoods? It will intersect both, and so will be included in the summary statistics for **both**.
興味深いクエリ (:ref:`interestingquestion` 内) の中で、町地区ごとの集約をどの国勢調査統計区ポリゴンに含ませるかを決めるために :command:`ST_Intersects(geometry_a, geometry_b)` 関数を使いました。次の質問に繋がります: 地区が二つの町の境界線上にある場合にはどうなりますか? 両方にインタセクトするため、**両方**の統計値に含んでしまいます。
a year ago
User avatar yellow73

Suggestion accepted

  1. postgis-workshop
  2. joins_advanced
  3. Japanese
New York geographers will be wondering at the presence of "Flatbush" in this list of over-educated neighborhoods. The answer is discussed in the next section.
ニューヨークの地理学者は、この高学歴の町地区のリストに「フラットブッシュ」があることに疑問を抱きます。答については次のセクションで検討します。
a year ago
Browse all component changes