Component Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
3d 37% 147 3,247 20,142 147 0 0 0
about_data 61% 215 1,700 11,511 205 45 0 0
advanced_geometry_construction 40% 172 3,860 23,816 172 1 1 0
backup 34% 282 6,709 42,177 282 0 0 0
clusterindex 48% 65 1,848 11,048 65 1 0 0
creating_db 52% 66 980 6,451 66 4 0 0
de9im 51% 88 1,704 10,184 88 0 0 0
equality 40% 36 1,191 7,425 36 0 0 0
geography 50% 221 4,399 31,838 221 0 0 0
geography_exercises 45% 69 841 5,575 69 8 0 0
geometries 60% 263 4,528 32,725 263 3 0 0
geometries_exercises 50% 159 1,206 9,723 159 13 0 0
geometry_returning 54% 68 1,755 12,623 68 0 0 0
geometry_returning_exercises 50% 56 692 4,740 56 1 1 0
history_tracking 41% 123 2,562 15,093 123 1 0 0
index CC-BY-3.0-US 74% 60 338 2,957 50 12 4 0
indexing 71% 88 2,059 14,250 84 2 0 0
installation CC-BY-3.0-US 89% 16 215 1,488 16 0 0 0
introduction 54% 382 6,062 42,285 376 35 14 1
joins 60% 69 1,734 11,393 69 0 2 0
joins_advanced 50% 80 1,526 9,562 80 0 0 0
joins_exercises 60% 58 532 3,874 58 8 1 0
knn 55% 27 835 5,022 27 1 0 0
license 44% 10 182 1,306 10 0 0 0
linear_referencing 52% 44 1,102 7,827 44 0 1 0
loading_data 43% 288 6,454 41,947 288 3 2 0
postgis-functions 54% 93 742 5,623 93 16 1 0
projection 60% 61 1,662 11,141 61 0 0 0
projection_exercises 60% 56 582 3,954 56 16 1 0
rasters CC-BY-3.0-US 40% 627 17,874 114,234 627 1 5 0
schemas 50% 72 1,396 8,526 72 0 1 0
security 51% 132 2,416 15,896 132 1 0 0
simple_sql 50% 100 1,793 11,977 100 0 0 0
simple_sql_exercises 52% 122 1,007 7,318 115 28 8 0
spatial_relationships 35% 162 3,393 24,997 162 0 0 0
spatial_relationships_exercises 60% 60 648 4,542 60 9 3 0
topology CC-BY-3.0-US 50% 122 3,268 20,900 122 0 2 0
tuning 40% 136 3,288 21,278 136 0 5 0
upgrades 40% 102 1,782 11,142 102 0 0 0
validity 51% 66 1,591 10,131 66 0 0 0
welcome 65% 67 959 5,838 67 4 0 0
Glossary glossary 1 CC-BY-3.0-US 34% 255 3,183 26,022 255 0 45 0

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 astrid_emde User avatar jef User avatar yellow73
Translation license CC-BY-3.0-US index installation rasters topology glossary 1
10 hours ago

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 10,931 201,121 1,345,461
Source 2,011 37,978 252,745
Translated 50% 5,546 48% 97,276 48% 654,960
Needs editing 1% 37 1% 159 1% 1,392
Read-only 18% 2,011 18% 37,978 18% 252,745
Failing checks 1% 213 1% 1,020 1% 8,224
Strings with suggestions 1% 97 1% 264 1% 2,149
Untranslated strings 48% 5,348 51% 103,686 51% 689,109
Last 12 months Previous

Activity in last 12 months

128 changes 324 changes 116 changes 335 changes 2,240 changes 227 changes 7 changes 1,754 changes 581 changes 58 changes 74 changes 67 changes 56 changes 774 changes 1,104 changes 71 changes 457 changes 8 changes 505 changes 45 changes 297 changes 9 changes 597 changes 5 changes
Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct

Quick numbers

201 k
Hosted words
10,931
Hosted strings
50%
Translated
3
Contributors
and previous 30 days

Trends of last 30 days

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

Repository rebased

  1. postgis-workshop
  2. index
Repository rebased

Original revision: e89afabaf6e4896d6bbe284a66866265b1523d69
New revision: 3b31e91c6f4108c340e80a333d1c397622535447 12 hours ago
User avatar None

Repository notification received

  1. postgis-workshop
  2. index
GitHub: https://github.com/postgis/postgis-workshops, master 12 hours ago
User avatar None

Repository rebased

  1. postgis-workshop
  2. index
Repository rebased

Original revision: 95835f3d413e7469a1f828e4a8bacea1aac8b044
New revision: e89afabaf6e4896d6bbe284a66866265b1523d69 6 days ago
User avatar None

Repository notification received

  1. postgis-workshop
  2. index
GitHub: https://github.com/postgis/postgis-workshops, master 6 days ago
User avatar None

Alert triggered

  1. postgis-workshop
  2. security
Component seems unused. 8 days ago
User avatar None

Changes pushed

  1. postgis-workshop
  2. index
Changes pushed 13 days ago
User avatar None

Changes committed

  1. postgis-workshop
  2. rasters
  3. Japanese
Changes committed 13 days ago
User avatar yellow73

Suggestion removed

  1. postgis-workshop
  2. rasters
  3. Japanese
Dont change "3" to "1"
The `overview_factor` tells you at what resolution the row is with respect to it's parent. An `overview_factor` of `2` means that 2x2 = 4 tiles can fit into one overview_2 tile. Similarly an overview_factor of `3` meants that 2x2x2 = 8 tiles of the original can be shoved into an overview_3 tile.
`overview_factor` で、その行の親に対する解像度が分かります。`overview_factor` が `2` の場合には、2z2 = 4 タイルが、ひとつの overview_2 タイルに当てはまります。同様に `overview_factor` が `1` の場合には、overview_3 タイルに、元のタイルの 2x2x2 = 8 タイルが押し込まれます。
13 days ago
User avatar yellow73

Suggestion removed

  1. postgis-workshop
  2. rasters
  3. Japanese
The `overview_factor` tells you at what resolution the row is with respect to it's parent. An `overview_factor` of `2` means that 2x2 = 4 tiles can fit into one overview_2 tile. Similarly an overview_factor of `3` meants that 2x2x2 = 8 tiles of the original can be shoved into an overview_3 tile.
`overview_factor` で、その行の親に対する解像度が分かります。`overview_factor` が `2` の場合には、2x2 = 4 タイルが、ひとつの overview_2 タイルに当てはまります。同様に `overview_factor` が `1` の場合には、overview_3 タイルに、元のタイルの 2x2x2 = 8 タイルが押し込まれます。
13 days ago
User avatar yellow73

Suggestion removed

  1. postgis-workshop
  2. rasters
  3. Japanese
"raster2pgsql" is correct.
The :command:`raster2pgsql` tool is similar to the :command:`shp2gpsql` except instead of loading ESRI shapefiles into PostGIS geometry/geography tables, it loads any GDAL supported raster format into raster tables. Just like :command:`shp2pgsql` you can pass it a spatial reference id (SRID) of the source. Unlike :command:`shp2pgsql` it can infer the spatial references system of the source data if your source data has suitable metadata.
:command:`rasterpgsql` ツールは、ESRIシェープファイル を PostGIS ジオメトリ/ジオグラフィテーブルにロードする代わりに、GDAL が対応するラスタフォーマットをラスタテーブルにロードするところが違いますが、 :command:`shp2gpsql` と似ています。:command:`shp2pgsql` のように、ソースデータの空間参照系ID (SRID) を渡すことができます。:command:`shp2pgsql` と違い、適切なメタデータを持っているソースデータに対しては空間参照系を推測できます。
13 days ago
Browse all project changes