Component Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
3d 0 0 0 0 0 0 0
about_data 76% 22 97 743 20 10 0 0
advanced_geometry_construction 58% 24 505 3,188 24 0 0 0
backup 6% 67 1,610 10,052 67 0 0 0
clusterindex 0 0 0 0 0 0 0
creating_db 0 0 0 0 1 0 0
de9im 4% 43 849 5,064 43 0 0 0
equality 0 0 0 0 0 0 0
geography 2% 72 1,464 10,594 72 0 0 0
geography_exercises 0 0 0 0 2 0 0
geometries 2% 130 2,256 16,295 130 0 0 0
geometries_exercises 32% 36 316 2,529 36 7 0 0
geometry_returning 16% 31 842 5,993 31 0 0 0
geometry_returning_exercises 39% 17 299 2,026 17 5 1 0
Glossary glossary 1 CC-BY-3.0-US 30% 30 518 4,289 30 0 0 0
history_tracking 2% 41 854 5,031 41 0 0 0
index CC-BY-3.0-US 0 0 0 0 0 0 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 0 0 0 0 6 0 1
joins 8% 32 848 5,476 32 0 0 0
joins_advanced 22% 31 645 3,990 31 0 0 0
joins_exercises 68% 9 133 891 9 7 0 0
knn 0 0 0 0 0 0 0
license 0 0 0 0 0 0 0
linear_referencing 8% 21 549 3,898 21 0 0 0
loading_data 1% 72 1,617 10,509 72 0 0 0
postgis-functions 21% 32 255 1,942 32 1 0 0
projection 3% 30 830 5,564 30 0 0 0
projection_exercises 0 0 0 0 0 0 0
rasters CC-BY-3.0-US 1% 208 5,957 38,068 208 0 0 0
schemas 38% 22 417 2,525 22 0 0 0
security 2% 66 1,208 7,948 66 0 0 0
simple_sql 0 0 0 0 4 0 0
simple_sql_exercises 0 0 0 0 0 0 0
spatial_relationships 2% 41 864 6,365 41 0 0 0
spatial_relationships_exercises 40% 18 268 1,834 18 0 0 0
topology CC-BY-3.0-US 3% 59 1,569 9,947 59 0 0 0
topology_base_types 11% 79 1,400 7,527 79 0 0 0
topology_topo_types 11% 79 1,400 7,527 79 0 0 0
tuning 13% 40 1,080 6,986 40 0 0 0
upgrades 8% 31 502 3,082 31 0 0 0
validity 55% 15 383 2,664 15 0 0 0
welcome 0 0 0 0 0 0 0

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 yellow73 User avatar jsanz User avatar andischi User avatar komzpa User avatar cvvergara
Translation license CC-BY-3.0-US installation topology index glossary 1 rasters
yesterday

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 2,189 40,970 269,165
Translated 35% 768 26% 10,765 26% 72,233
Needs editing 1% 3 1% 28 1% 220
Read-only 0% 0 0% 0 0% 0
Failing checks 2% 44 1% 278 1% 1,927
Strings with suggestions 1% 1 1% 9 1% 104
Untranslated strings 64% 1,418 73% 30,177 73% 196,712
Last 12 months Previous

Activity in last 12 months

1 change 57 changes 6 changes 0 changes 0 changes 5 changes 0 changes 0 changes 52 changes 0 changes 5 changes 6 changes 0 changes 0 changes 0 changes 0 changes 73 changes 35 changes 0 changes 414 changes 0 changes 3 changes 72 changes 1 change
Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May

Quick numbers

40,970
Hosted words
2,189
Hosted strings
35%
Translated
5
Contributors
and previous 30 days

Trends of last 30 days

+7%
Hosted words
+100%
+8%
Hosted strings
+100%
+2%
Translated
+32%
+40%
Contributors
+100%
User avatar mt:weblate

Suggestion added

  1. postgis-workshop
  2. geometry_returning_exercises
  3. Spanish
:command:`ST_Transform(geometry, srid)` converts ``geometries`` into different spatial reference systems
:command:`ST_Transform(geometry, srid)` convierte las geometrías a un determinado SRID
4 days ago
User avatar None

Changes committed

  1. postgis-workshop
  2. joins_advanced
  3. Spanish
Changes committed 5 days ago
User avatar None

Changes committed

  1. postgis-workshop
  2. validity
  3. Spanish
Changes committed 5 days ago
User avatar paulo

Translation added

  1. postgis-workshop
  2. validity
  3. Spanish
Detecting Validity
Detectando Validez
6 days ago
User avatar paulo

Translation added

  1. postgis-workshop
  2. validity
  3. Spanish
What's going on here? The algorithm that calculates area assumes that rings do not self-intersect. A well-behaved ring will always have the area that is bounded (the interior) on one side of the bounding line (it doesn't matter which side, just that it is on *one* side). However, in our (poorly behaved) figure-eight, the bounded area is to the right of the line for one lobe and to the left for the other. This causes the areas calculated for each lobe to cancel out (one comes out as 1, the other as -1) hence the "zero area" result.
¿Qué ocurre aquí? El algoritmo que calcula el área asume que los anillos no se auto-intersecan. Un anillo que se comporte bien siempre tendrá el área delimitada (el interior) a un lado de la línea de delimitación (no importa a qué lado, sólo que sea a *un* lado). Sin embargo, en nuestro (mal comportamiento) ocho, el área delimitada está a la derecha de la línea para un lóbulo y a la izquierda para el otro. Esto hace que las áreas calculadas para cada lóbulo se anulen (una sale como 1, la otra como -1), de ahí el resultado de «área cero».
6 days ago
User avatar paulo

Translation added

  1. postgis-workshop
  2. validity
  3. Spanish
Let's see what the database thinks the area of our polygon is:
Veamos cuál cree la base de datos que es el área de nuestro polígono:
6 days ago
User avatar paulo

Contributor joined

  1. postgis-workshop
  2. validity
  3. Spanish
Contributor joined 6 days ago
User avatar paulo

Translation added

  1. postgis-workshop
  2. joins_advanced
  3. Spanish
Carry out some analysis using our new data
Realizar algunos análisis con nuestros nuevos datos
6 days ago
User avatar paulo

Translation added

  1. postgis-workshop
  2. joins_advanced
  3. Spanish
Join the attribute data to the spatial data
Unir los datos de atributos a los datos espaciales
6 days ago
User avatar paulo

Translation added

  1. postgis-workshop
  2. joins_advanced
  3. Spanish
Create a spatial table for census tracts
Crear una tabla espacial para las secciones censales
6 days ago
Browse all changes for this language