Component Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
3d 0 0 0 0 0 0 0
about_data 0 0 0 0 34 0 0
advanced_geometry_construction 0 0 0 0 0 0 0
backup 0 0 0 0 0 0 0
clusterindex 0 0 0 0 1 0 0
creating_db 0 0 0 0 4 0 0
de9im 0 0 0 0 0 0 0
equality 0 0 0 0 0 0 0
geography 0 0 0 0 0 0 0
geography_exercises 0 0 0 0 4 0 0
geometries 0 0 0 0 3 0 0
geometries_exercises 0 0 0 0 9 0 0
geometry_returning 0 0 0 0 0 0 0
geometry_returning_exercises 0 0 0 0 1 0 0
Glossary glossary 1 CC-BY-3.0-US 0 0 0 0 0 0 0
history_tracking 0 0 0 0 0 0 0
index CC-BY-3.0-US 0 0 0 0 3 0 0
indexing 0 0 0 0 1 0 0
installation CC-BY-3.0-US 0 0 0 0 0 0 0
introduction 0 0 0 0 31 0 0
joins 0 0 0 0 0 0 0
joins_advanced 0 0 0 0 0 0 0
joins_exercises 0 0 0 0 8 0 0
knn 0 0 0 0 0 0 0
license 0 0 0 0 0 0 0
linear_referencing 0 0 0 0 0 0 0
loading_data 0 0 0 0 2 0 0
postgis-functions 0 0 0 0 16 0 0
projection 0 0 0 0 0 0 0
projection_exercises 0 0 0 0 8 0 0
rasters CC-BY-3.0-US 0 0 0 0 1 0 0
schemas 0 0 0 0 0 0 0
security 0 0 0 0 1 0 0
simple_sql 0 0 0 0 0 0 0
simple_sql_exercises 0 0 0 0 11 0 0
spatial_relationships 0 0 0 0 0 0 0
spatial_relationships_exercises 0 0 0 0 8 0 0
topology CC-BY-3.0-US 0 0 0 0 0 0 0
tuning 0 0 0 0 0 0 0
upgrades 0 0 0 0 0 0 0
validity 0 0 0 0 0 0 0
welcome 0 0 0 0 1 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
12 hours ago

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 2,011 37,978 252,745
Translated 100% 2,011 100% 37,978 100% 252,745
Needs editing 0% 0 0% 0 0% 0
Read-only 100% 2,011 100% 37,978 100% 252,745
Failing checks 7% 147 1% 633 2% 5,223
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 0 changes 355 changes 0 changes 0 changes 62 changes 9 changes 0 changes 1 change 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 4 changes 0 changes 0 changes 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
100%
Translated
1
Contributors
and previous 30 days

Trends of last 30 days

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

Resource updated

  1. postgis-workshop
  2. rasters
  3. English
The "postgis-intro/sources/locale/pot/rasters.pot" file was changed. 2 weeks ago
User avatar None

String added in the repository

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

String added in the repository

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

String added in the repository

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

String added in the repository

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

String added in the repository

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

Resource updated

  1. postgis-workshop
  2. indexing
  3. English
The "postgis-intro/sources/locale/pot/indexing.pot" file was changed. 3 months ago
User avatar None

String added in the repository

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

String added in the repository

  1. postgis-workshop
  2. indexing
  3. English
In order to add index acceleration to other functions that are not in this list (most commonly, `ST_Relate <http://postgis.net/docs/ST_Relate.html>`_) add an index-only clause as described below.
In order to add index acceleration to other functions that are not in this list (most commonly, `ST_Relate <http://postgis.net/docs/ST_Relate.html>`_) add an index-only clause as described below.
3 months ago
Browse all changes for this language