Translation status

40 Strings 100%
Browse Translate
763 Words 100%
4,781 Characters 100%

Strings status

Strings Words Characters
40 763 4,781
All strings Browse Translate Zen
40 763 4,781
Translated strings 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 5 1 0
index CC-BY-3.0-US 0 0 0 0 0 0 0
backup 0 0 0 0 4 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
topology CC-BY-3.0-US 0 0 0 0 0 1 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 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) 96cec16
Weblate authored 5 days ago
Weblate repository https://weblate.osgeo.org/git/postgis-workshop/index/
File mask postgis-intro/sources/locale/*/LC_MESSAGES/joins_advanced.po
Translation file Download postgis-intro/sources/locale/sv/LC_MESSAGES/joins_advanced.po
Last change June 5, 2025, 1:55 p.m.
Last author None
2 days ago

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 40 763 4,781
Translated 100% 40 100% 763 100% 4,781
Needs editing 0% 0 0% 0 0% 0
Read-only 0% 0 0% 0 0% 0
Failing checks 0% 0 0% 0 0% 0
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 0 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

763
Hosted words
40
Hosted strings
100%
Translated
2
Contributors
and previous 30 days

Trends of last 30 days

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

Changes committed

  1. postgis-workshop
  2. joins_advanced
  3. Swedish
Changes committed 2 weeks ago
User avatar yeager

Translation changed

  1. postgis-workshop
  2. joins_advanced
  3. Swedish
The complex method is to divide crossing tracts at the borders (using :command:`ST_Intersection(geometry,geometry)`)
Den komplexa metoden är att dela upp korsande trakter vid gränserna (med :kcommandot:`ST_Intersection(geometry,geometry)`)
2 weeks ago
User avatar None

Changes committed

  1. postgis-workshop
  2. joins_advanced
  3. Swedish
Changes committed 2 weeks ago
User avatar yeager

Translation uploaded

  1. postgis-workshop
  2. joins_advanced
  3. Swedish
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.
Det var bättre! Lite mer än hälften av New Yorks befolkning bor alltså inom 500 meter (cirka 5-7 minuters promenad) från tunnelbanan.
2 weeks ago
User avatar yeager

Translation uploaded

  1. postgis-workshop
  2. joins_advanced
  3. Swedish
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:
Lösningen är att se till att vi bara har distinkta folkräkningsblock innan vi skickar dem till sammanfattningsdelen av frågan. Vi kan göra det genom att bryta upp vår fråga i en underfråga som hittar de distinkta blocken, inslagna i en sammanfattningsfråga som returnerar vårt svar:
2 weeks ago
User avatar yeager

Translation uploaded

  1. postgis-workshop
  2. joins_advanced
  3. Swedish
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.
Det finns fler människor nära tunnelbanan än det finns människor! Det är uppenbart att vår enkla SQL gör ett stort dubbelräkningsfel. Du kan se problemet när du tittar på bilden av de buffrade tunnelbanorna.
2 weeks ago
User avatar yeager

Translation uploaded

  1. postgis-workshop
  2. joins_advanced
  3. Swedish
With the population of the people in New York within 500 meters of a subway station:
Med befolkningen i New York inom 500 meter från en tunnelbanestation:
2 weeks ago
User avatar yeager

Translation uploaded

  1. postgis-workshop
  2. joins_advanced
  3. Swedish
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:
Frågan stöter dock på vissa problem med dubbelräkning: många människor kommer att befinna sig inom 500 meter från flera tunnelbanestationer. Jämför befolkningen i New York:
2 weeks ago
User avatar yeager

Translation uploaded

  1. postgis-workshop
  2. joins_advanced
  3. Swedish
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?"
En fråga som är rolig att ställa är "Hur skiljer sig pendlingstiderna för människor nära (inom 500 meter) tunnelbanestationer från dem för människor långt bort från tunnelbanestationer?"
2 weeks ago
User avatar yeager

Translation uploaded

  1. postgis-workshop
  2. joins_advanced
  3. Swedish
Large Radius Distance Joins
Förband med stort radieavstånd
2 weeks ago
Browse all translation changes