Source strings

209 Strings 100%
Browse Translate
5,958 Words 100%
38,078 Characters 100%
This translation is being used as source strings within this component.

Strings status

Strings Words Characters
209 5,958 38,078
All strings Browse Translate Zen
209 5,958 38,078
Read-only strings Browse Translate Zen
3 44 356
Strings with any failing checks Browse Translate Zen
1 42 326
Failing check: Ellipsis Browse Translate Zen
2 2 30
Failing check: Multiple failing checks Browse Translate Zen

Other components

Component Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
geometry_returning 0 0 0 0 1 0 0
projection_exercises 0 0 0 0 8 0 0
simple_sql_exercises 0 0 0 0 13 0 0
tuning 0 0 0 0 6 0 0
index CC-BY-3.0-US 0 0 0 0 3 0 0
backup 0 0 0 0 0 0 0
license 0 0 0 0 0 0 0
installation CC-BY-3.0-US 0 0 0 0 0 0 0
equality 0 0 0 0 0 0 0
joins_advanced 0 0 0 0 0 0 0
Browse all components

Overview

Project website postgis.net/workshops/postgis-intro
Project maintainers User avatar jef User avatar astrid_emde User avatar dmateos User avatar dkastl User avatar jsanz User avatar andischi User avatar yellow73 User avatar komzpa User avatar cvvergara
Translation license Creative Commons Attribution 3.0 United States
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 #146 from AllenSH12/fixups 37f3a52
Regina Obe authored 11 days ago
Last commit in Weblate Translated using Weblate (Spanish) 71b2709
Weblate authored 5 days ago
Weblate repository https://weblate.osgeo.org/git/postgis-workshop/index/
File mask postgis-intro/sources/locale/*/LC_MESSAGES/rasters.po
Translation file Download postgis-intro/sources/locale/pot/rasters.pot
Last change Nov. 2, 2024, 10:35 p.m.
Last author None
9 days ago

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 209 5,958 38,078
Translated 100% 209 100% 5,958 100% 38,078
Needs editing 0% 0 0% 0 0% 0
Read-only 100% 209 100% 5,958 100% 38,078
Failing checks 1% 3 1% 44 1% 356
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 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 6 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
Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May

Quick numbers

5,958
Hosted words
209
Hosted strings
100%
Translated
0
Contributors
and previous 30 days

Trends of last 30 days

—
Hosted words
+100%
—
Hosted strings
+100%
—
Translated
+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. 7 months 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.
7 months 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.
7 months 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.
7 months 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.
7 months 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.
7 months ago
User avatar None

Resource updated

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

String updated in the repository

  1. postgis-workshop
  2. rasters
  3. English
The only problem with the aforementioned :command:`ST_Transform` approach is that when you transform, the transformed often exists in other tiles. If you looked at the above output closely enough by outputting the convex hull of the rasters, in the next example you'd see annoying overlaps around the borders.
The only problem with the aforementioned :command:`ST_Transform` approach is that when you transform, the transformed often exists in other tiles. If you looked at the above output closely enough by outputting the convex hull of the rasters, in the next example you'd see annoying overlaps around the borders.
2 years ago
User avatar None

Resource updated

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

Resource updated

  1. postgis-workshop
  2. rasters
  3. English
The "postgis-intro/sources/locale/pot/rasters.pot" file was changed. 2 years ago
Browse all translation changes