Component Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
3d 0% 39 835 5,149 39 0 0 0
about_data 68% 30 105 851 20 10 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 85% 3 101 552 3 0 0 0
creating_db 4% 22 327 2,153 22 0 0 0
de9im 4% 43 849 5,064 43 0 0 0
equality 0% 12 397 2,475 12 0 0 0
geography 1% 73 1,465 10,604 73 0 0 0
geography_exercises 0% 21 235 1,594 21 0 0 0
geometries 1% 131 2,263 16,356 131 0 0 0
geometries_exercises 0% 53 402 3,241 53 0 0 0
geometry_returning 8% 34 877 6,309 34 0 0 0
geometry_returning_exercises 0% 28 346 2,370 28 0 1 0
Glossary glossary 1 CC-BY-3.0-US 6% 40 528 4,327 40 0 10 0
history_tracking 2% 41 854 5,031 41 0 0 0
index CC-BY-3.0-US 0 0 0 0 1 1 0
indexing 62% 23 670 4,385 22 1 0 0
installation CC-BY-3.0-US 0 0 0 0 0 0 0
introduction 81% 22 48 336 16 1 5 1
joins 2% 34 866 5,690 34 0 0 0
joins_advanced 0% 40 763 4,781 40 0 0 0
joins_exercises 0% 29 266 1,937 29 0 1 0
knn 20% 12 406 2,431 12 1 0 0
license 66% 1 14 94 1 0 0 0
linear_referencing 8% 21 549 3,898 21 0 0 0
loading_data 0% 73 1,620 10,529 73 0 1 0
postgis-functions 0% 41 281 2,254 41 0 1 0
projection 3% 30 830 5,564 30 0 0 0
projection_exercises 0% 28 291 1,977 28 0 1 0
rasters CC-BY-3.0-US 0% 209 5,958 38,078 209 0 1 0
schemas 0% 36 698 4,263 36 0 0 0
security 2% 66 1,208 7,948 66 0 0 0
simple_sql 2% 33 597 3,987 33 0 0 0
simple_sql_exercises 16% 36 309 2,268 29 8 5 0
spatial_relationships 2% 41 864 6,365 41 0 0 0
spatial_relationships_exercises 0% 30 324 2,271 30 0 1 0
topology CC-BY-3.0-US 0% 61 1,634 10,450 61 0 1 0
tuning 4% 44 1,092 7,066 44 0 4 0
upgrades 0% 34 594 3,714 34 0 0 0
validity 5% 32 794 5,055 32 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
an hour ago

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 2,011 37,978 252,745
Translated 15% 315 11% 4,420 12% 30,808
Needs editing 1% 24 1% 58 1% 532
Read-only 0% 0 0% 0 0% 0
Failing checks 1% 22 1% 95 1% 774
Strings with suggestions 1% 33 1% 88 1% 655
Untranslated strings 83% 1,672 88% 33,500 87% 221,405
Last 12 months Previous

Activity in last 12 months

2 changes 5 changes 7 changes 0 changes 393 changes 0 changes 0 changes 73 changes 33 changes 0 changes 2 changes 0 changes 1 change 72 changes 1 change 57 changes 6 changes 0 changes 0 changes 5 changes 0 changes 0 changes 52 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
15%
Translated
1
Contributors
and previous 30 days

Trends of last 30 days

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

Resource updated

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

String added in the repository

  1. postgis-workshop
  2. rasters
  3. Spanish
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. Spanish
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. Spanish
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. Spanish
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. Spanish
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. Spanish
The "postgis-intro/sources/locale/es/LC_MESSAGES/indexing.po" file was changed. 3 months ago
User avatar None

String added in the repository

  1. postgis-workshop
  2. indexing
  3. Spanish
`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. Spanish
`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. Spanish
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.
Para añadir aceleración por índices a otras funciones que no están en esta lista (la más habitual, `ST_Relate <http://postgis.net/docs/ST_Relate.html>`_) hay que añadir una clausula de indexación como la descrita debajo.
3 months ago
Browse all changes for this language