Component Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
3d 0% 39 835 5,149 39 0 0 0
about_data 1% 93 815 5,442 93 0 0 0
advanced_geometry_construction 1% 57 1,286 7,936 57 0 0 0
backup 0% 72 1,698 10,668 72 0 0 0
clusterindex 0% 21 583 3,503 21 0 0 0
creating_db 0% 23 329 2,166 23 0 0 0
de9im 0% 45 855 5,120 45 0 0 0
equality 0% 12 397 2,475 12 0 0 0
geography 0% 74 1,467 10,617 74 0 0 0
geography_exercises 0% 21 235 1,594 21 0 0 0
geometries 1% 132 2,265 16,369 132 0 0 0
geometries_exercises 0% 53 402 3,241 53 0 0 0
geometry_returning 8% 34 878 6,314 34 0 0 0
geometry_returning_exercises 0% 28 346 2,370 28 0 0 0
Glossary glossary 1 CC-BY-3.0-US 0% 43 531 4,339 43 0 9 0
history_tracking 2% 41 854 5,031 41 0 0 0
index CC-BY-3.0-US 24% 22 125 1,064 22 2 0 0
indexing 0% 62 1,318 9,331 62 0 0 0
installation CC-BY-3.0-US 36% 16 215 1,488 16 0 0 0
introduction 1% 119 2,001 13,961 119 0 7 0
joins 0% 35 868 5,703 35 0 0 0
joins_advanced 0% 40 763 4,781 40 0 0 0
joins_exercises 0% 29 266 1,937 29 0 0 0
knn 0% 15 429 2,591 15 0 0 0
license 0% 3 56 404 3 0 0 0
linear_referencing 0% 23 553 3,929 23 0 1 0
loading_data 2% 71 1,613 10,486 71 0 0 0
postgis-functions 2% 40 280 2,247 40 0 0 0
projection 0% 31 832 5,577 31 0 0 0
projection_exercises 0% 28 291 1,977 28 0 0 0
rasters CC-BY-3.0-US 0% 209 5,958 38,078 209 0 2 0
schemas 0% 36 698 4,263 36 0 1 0
security 2% 66 1,208 7,948 66 0 0 0
simple_sql 0% 34 599 4,000 34 0 0 0
simple_sql_exercises 0% 43 349 2,525 43 0 0 0
spatial_relationships 2% 41 864 6,357 41 0 0 0
spatial_relationships_exercises 0% 30 324 2,271 30 0 0 0
topology CC-BY-3.0-US 0% 61 1,634 10,450 61 0 1 0
tuning 0% 46 1,098 7,106 46 0 0 0
upgrades 0% 34 594 3,714 34 0 0 0
validity 0% 34 797 5,076 34 0 0 0
welcome 12% 21 314 1,916 21 0 0 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 installation topology rasters glossary 1 index
15 minutes ago

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 2,011 37,978 252,745
Translated 1% 34 1% 155 1% 1,231
Needs editing 0% 0 0% 0 0% 0
Read-only 0% 0 0% 0 0% 0
Failing checks 1% 2 1% 30 1% 285
Strings with suggestions 1% 21 1% 24 1% 147
Untranslated strings 98% 1,977 99% 37,823 99% 251,514
Last 12 months Previous

Activity in last 12 months

6 changes 0 changes 4 changes 0 changes 376 changes 0 changes 2 changes 63 changes 24 changes 0 changes 2 changes 0 changes 16 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 4 changes 0 changes 1 change 0 changes 0 changes
Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct

Quick numbers

37,978
Hosted words
2,011
Hosted strings
1%
Translated
1
Contributors
and previous 30 days

Trends of last 30 days

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

Resource updated

  1. postgis-workshop
  2. rasters
  3. German
The "postgis-intro/sources/locale/de/LC_MESSAGES/rasters.po" file was changed. 3 weeks ago
User avatar None

String added in the repository

  1. postgis-workshop
  2. rasters
  3. German
People have the habit of jumping to :command:`ST_MapAlgebra`, probably because the name sounds so cool and sophisticated. Who wouldn't want to tell their friends? *I'm using a function called ST_MapAlgebra.* My advice, explore other functions before you pull out that shotgun. Your life will be simpler and your performance will be 100 times better, and your code will be shorter.
 
3 weeks ago
User avatar None

String added in the repository

  1. postgis-workshop
  2. rasters
  3. German
Map algebra is the idea that you can do math on your pixel values. The :command:`ST_Union` and :command:`ST_Intersection` functions covered earlier are a special fast case of map algebra. Then there are the `ST_MapAlgebra <https://postgis.net/docs/RT_ST_MapAlgebra.html>`_ family of functions which allow you to define your own crazy math, but at cost of performance.
 
3 weeks ago
User avatar None

String added in the repository

  1. postgis-workshop
  2. rasters
  3. German
By default ST_Clip will leave out pixels where the centroid of the pixel doesn't intersect the geometry. This can be annoying for big pixels and you may prefer to instead, include a pixel if any part of the pixel touches the geometry. Introduced in PostGIS 3.5, is the touched argument. Replace your `ST_Clip(r.rast, g.geom)` with `ST_Clip(r.rast, g.geom, touched => true)` and voila any pixels that intersect your geometry in any way will be included.
 
3 weeks ago
User avatar None

String added in the repository

  1. postgis-workshop
  2. rasters
  3. German
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.
 
3 weeks ago
User avatar None

String added in the repository

  1. postgis-workshop
  2. rasters
  3. German
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.
 
3 weeks ago
User avatar anonymous

Suggestion added

  1. postgis-workshop
  2. schemas
  3. German
PostgreSQL Schemas
PostgresSQL Schemas
2 months ago
User avatar None

Resource updated

  1. postgis-workshop
  2. indexing
  3. German
The "postgis-intro/sources/locale/de/LC_MESSAGES/indexing.po" file was changed. 3 months ago
User avatar None

String added in the repository

  1. postgis-workshop
  2. indexing
  3. German
`geometry_a ~= geometry_b <http://postgis.net/docs/ST_Geometry_Same.html>`_: Returns TRUE if A's bounding box equals B's bounding box.
 
3 months ago
User avatar None

String added in the repository

  1. postgis-workshop
  2. indexing
  3. German
`geometry_a = geometry_b <http://postgis.net/docs/ST_Geometry_EQ.html>`_: Before PostGIS 2.4 returns true if A's bounding box is same as B's. From 2.4 on Returns TRUE only if A's geometry is the same as B.
 
3 months ago
Browse all changes for this language