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
tuning 0 0 0 0 5 1 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
geography_exercises 0 0 0 0 4 0 0
security 0 0 0 0 1 1 0
Browse all components

Overview

Project website postgis.net/workshops/postgis-intro
Project maintainers User avatar komzpa User avatar jef User avatar cvvergara User avatar yellow73 User avatar astrid_emde User avatar dmateos User avatar dkastl User avatar jsanz User avatar andischi
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 Update README.md with formatting f6c7aa6
Martin Davis authored 4 days ago
Last commit in Weblate Translated using Weblate (Spanish) a44e4fa
Paulo Cesar Coronado authored a month 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
4 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 86 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep

Quick numbers

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

Trends of last 30 days

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

Changes committed

  1. postgis-workshop
  2. joins_advanced
  3. Swedish
Changes committed 4 months 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)`)
4 months ago
User avatar None

Changes committed

  1. postgis-workshop
  2. joins_advanced
  3. Swedish
Changes committed 4 months 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.
4 months 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:
4 months 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.
4 months 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:
4 months 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:
4 months 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?"
4 months ago
User avatar yeager

Translation uploaded

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