Component Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
3d 0 0 0 0 0 0 0
about_data 75% 23 98 760 20 10 0 0
advanced_geometry_construction 58% 24 505 3,188 24 2 0 0
backup 6% 67 1,610 10,052 67 0 0 0
clusterindex 85% 3 101 552 3 0 0 0
creating_db 0 0 0 0 3 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,595 72 0 0 0
geography_exercises 4% 20 233 1,575 20 0 0 0
geometries 2% 130 2,256 16,295 130 1 0 0
geometries_exercises 3% 51 391 3,129 51 1 0 0
geometry_returning 10% 33 861 6,108 33 0 0 0
geometry_returning_exercises 3% 27 327 2,266 27 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 98% 2 2 10 0 6 3 1
joins 5% 33 850 5,489 33 0 0 0
joins_advanced 5% 38 733 4,562 38 0 0 0
joins_exercises 31% 20 165 1,213 20 1 2 0
knn 20% 12 406 2,431 12 1 0 0
license 0 0 0 0 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 7% 26 268 1,822 26 0 1 0
rasters CC-BY-3.0-US 0% 209 5,958 38,078 209 0 1 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 5 0 0
simple_sql_exercises 0 0 0 0 16 5 0
spatial_relationships 2% 41 864 6,365 41 0 0 0
spatial_relationships_exercises 3% 29 310 2,162 29 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 yellow73 User avatar astrid_emde User avatar jef
Translation license CC-BY-3.0-US installation topology rasters glossary 1 index
7 hours ago

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 2,011 37,978 252,745
Translated 27% 559 21% 8,342 22% 56,367
Needs editing 1% 6 1% 31 1% 247
Read-only 0% 0 0% 0 0% 0
Failing checks 2% 48 1% 320 1% 2,143
Strings with suggestions 1% 32 1% 89 1% 667
Untranslated strings 71% 1,446 77% 29,605 77% 196,131
Last 12 months Previous

Activity in last 12 months

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 5 changes 6 changes 0 changes 0 changes 0 changes 0 changes 73 changes 35 changes
Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb

Quick numbers

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

Trends of last 30 days

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

Changes committed

  1. postgis-workshop
  2. advanced_geometry_construction
  3. Spanish
Changes committed yesterday
User avatar paulocoronado

Translation added

  1. postgis-workshop
  2. advanced_geometry_construction
  3. Spanish
An obvious failure mode of the "furthest from middle" rule is a circular line, like the Circle Line in London, UK. Fortunately, New York doesn't have any such lines!
Un fallo obvio de la regla "lo más lejos posible del centro" es una línea circular, como la Circle Line de Londres (Reino Unido). Afortunadamente, Nueva York no tiene líneas de este tipo.
yesterday
User avatar paulocoronado

Translation added

  1. postgis-workshop
  2. advanced_geometry_construction
  3. Spanish
Since there is no 100% heuristic to figure out the end points, let's try this second rule out.
Puesto que no existe una heurística al 100% para averiguar los puntos finales, probemos esta segunda regla.
yesterday
User avatar paulocoronado

Translation added

  1. postgis-workshop
  2. advanced_geometry_construction
  3. Spanish
A less directional characterization of the end stations is "they are the furthest stations from the middle of the route". With this characterization it doesn't matter if the route runs north/south or east/west, just that it run in more-or-less one direction, particularly at the ends.
Una caracterización menos direccional de las estaciones finales es "son las estaciones más alejadas del centro de la ruta". Con esta caracterización no importa si la ruta discurre en dirección norte/sur o este/oeste, sólo que discurra más o menos en una dirección, sobre todo en los extremos.
yesterday
User avatar paulocoronado

Translation added

  1. postgis-workshop
  2. advanced_geometry_construction
  3. Spanish
One answer is "they are the most northerly and southerly stations". However, imagine if the 'Q' train ran from east to west. Would the condition still hold?
Una respuesta es "son las estaciones más al norte (septentrionales) y más al sur ( meridionales)". Sin embargo, imagine que el tren "Q" circulara de este a oeste. ¿Se cumpliría la condición?
yesterday
User avatar paulocoronado

Translation added

  1. postgis-workshop
  2. advanced_geometry_construction
  3. Spanish
Our 'Q' train stops can serve as a starting point. What characterizes the end stations of the route?
Nuestras paradas del tren "Q" pueden servir de punto de partida. ¿Qué caracteriza a las estaciones finales de la ruta?
yesterday
User avatar paulocoronado

Translation added

  1. postgis-workshop
  2. advanced_geometry_construction
  3. Spanish
Let's tackle the hard problem first, figuring out the first station on a route without manually eyeballing the set of stations that make up the route.
Abordemos primero el problema más difícil: averiguar cuál es la primera estación de una ruta sin echar un vistazo manual al conjunto de estaciones que la componen.
yesterday
User avatar paulocoronado

Translation added

  1. postgis-workshop
  2. advanced_geometry_construction
  3. Spanish
Our query includes a piece of *a priori* knowledge, the initial station identifier that serves as the seed for the search algorithm that builds the route.
Nuestra consulta requiere un conocimiento *a priori*, el identificador inicial de la estación que sirve de semilla para el algoritmo de búsqueda que construye la ruta.
yesterday
User avatar paulocoronado

Translation added

  1. postgis-workshop
  2. advanced_geometry_construction
  3. Spanish
We are only calculating one subway route here, we want to calculate all the routes.
Aquí sólo estamos calculando una ruta de metro, queremos calcular todas las rutas.
yesterday
User avatar paulocoronado

Translation added

  1. postgis-workshop
  2. advanced_geometry_construction
  3. Spanish
Except, two problems:
Excepto por dos problemas:
yesterday
Browse all changes for this language