Language Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
English 0 0 0 0 0 0 0
German 0% 40 763 4,781 40 0 0 0
Japanese 0 0 0 0 0 0 0
Spanish 0 0 0 0 0 0 0
Swedish 0 0 0 0 0 0 0
Please sign in to see the alerts.

Overview

Project website postgis.net/workshops/postgis-intro
Project maintainers User avatar yellow73 User avatar jef User avatar cvvergara User avatar astrid_emde User avatar dmateos User avatar dkastl User avatar jsanz User avatar andischi User avatar komzpa
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 #154 from osgeoweblate/weblate-postgis-workshop-index 049c112
Regina Obe authored a month ago
Last commit in Weblate Translated using Weblate (Spanish) a44e4fa
Paulo Cesar Coronado authored 2 weeks ago
Weblate repository https://weblate.osgeo.org/git/postgis-workshop/index/
File mask postgis-intro/sources/locale/*/LC_MESSAGES/joins_advanced.po
2 weeks ago

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 200 3,815 23,905
Source 40 763 4,781
Translated 80% 160 80% 3,052 80% 19,124
Needs editing 0% 0 0% 0 0% 0
Read-only 20% 40 20% 763 20% 4,781
Failing checks 0% 0 0% 0 0% 0
Strings with suggestions 0% 0 0% 0 0% 0
Untranslated strings 20% 40 20% 763 20% 4,781
Last 12 months Previous

Activity in last 12 months

92 changes 0 changes 1 change 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 11 changes 1 change 0 changes 4 changes 0 changes 0 changes 0 changes 0 changes 0 changes 96 changes 0 changes 0 changes 0 changes 0 changes
Sep Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug

Quick numbers

3,815
Hosted words
200
Hosted strings
80%
Translated
2
Contributors
and previous 30 days

Trends of last 30 days

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

Changes committed

  1. postgis-workshop
  2. joins_advanced
  3. Spanish
Changes committed 2 weeks ago
User avatar paulo

Translation completed

  1. postgis-workshop
  2. joins_advanced
  3. Spanish
Translation completed 2 weeks ago
User avatar paulo

Translation added

  1. postgis-workshop
  2. joins_advanced
  3. Spanish
That's better! So a bit over half the population of New York is within 500m (about a 5-7 minute walk) of the subway.
Eso es mejor! Así que un poco más de la mitad de la población de Nueva York está dentro de 500 m (aproximadamente una caminata de 5 a 7 minutos) del metro.
2 weeks ago
User avatar paulo

Translation added

  1. postgis-workshop
  2. joins_advanced
  3. Spanish
The solution is to ensure that we have only distinct census blocks before passing them into the summarization portion of the query. We can do that by breaking our query up into a subquery that finds the distinct blocks, wrapped in a summarization query that returns our answer:
La solución es asegurarse de tener solo bloques censales distintos antes de pasarlos a la parte de resumen de la consulta. Podemos hacerlo dividiendo nuestra consulta en una subconsulta que encuentra los bloques distintos, envuelta en una consulta de resumen que devuelve nuestra respuesta:
2 weeks ago
User avatar paulo

Translation added

  1. postgis-workshop
  2. joins_advanced
  3. Spanish
There's more people close to the subway than there are people! Clearly, our simple SQL is making a big double-counting error. You can see the problem looking at the picture of the buffered subways.
Hay más personas cerca del metro de las que existen! Claramente, nuestro SQL simple está cometiendo un gran error de doble conteo. Puedes ver el problema observando la imagen de los buffers de las estaciones de metro.
2 weeks ago
User avatar paulo

Translation added

  1. postgis-workshop
  2. joins_advanced
  3. Spanish
With the population of the people in New York within 500 meters of a subway station:
Con la población de personas en Nueva York dentro de 500 metros de una estación de metro:
2 weeks ago
User avatar paulo

Translation added

  1. postgis-workshop
  2. joins_advanced
  3. Spanish
However, the question runs into some problems of double counting: many people will be within 500 meters of multiple subway stations. Compare the population of New York:
Sin embargo, la pregunta se enfrenta a algunos problemas de doble conteo: muchas personas estarán a menos de 500 metros de múltiples estaciones de metro. Compara la población de Nueva York:
2 weeks ago
User avatar paulo

Translation added

  1. postgis-workshop
  2. joins_advanced
  3. Spanish
A query that is fun to ask is "How do the commute times of people near (within 500 meters) subway stations differ from those of people far away from subway stations?"
Una consulta divertida de hacer es: "¿Cómo difieren los tiempos de viaje de las personas que viven cerca (a menos de 500 metros) de estaciones de metro de aquellos que viven lejos de las estaciones de metro?"
2 weeks ago
User avatar paulo

Translation added

  1. postgis-workshop
  2. joins_advanced
  3. Spanish
Large Radius Distance Joins
Large Radius Distance Joins
2 weeks ago
User avatar paulo

Translation added

  1. postgis-workshop
  2. joins_advanced
  3. Spanish
As defined by our data source, Flatbush is not really a neighborhood in the conventional sense, since it just covers the area of Prospect Park. The census tract for that area records, naturally, zero residents. However, the neighborhood boundary does scrape one of the expensive census tracts bordering the north side of the park (in the gentrified Park Slope neighborhood). When using polygon/polygon tests, this single tract was added to the otherwise empty Flatbush, resulting in the very high score for that query.
Según lo definido por nuestra fuente de datos, Flatbush no es realmente un vecindario en el sentido convencional, ya que solo cubre el área de Prospect Park. El distrito censal de esa área registra, naturalmente, cero residentes. Sin embargo, el límite del vecindario toca uno de los distritos censales costosos que bordean el lado norte del parque (en el gentrificado vecindario de Park Slope). Al usar pruebas de polígono/polígono, este único distrito fue agregado al Flatbush vacío, resultando en la puntuación muy alta de esa consulta.
2 weeks ago
Browse all component changes