Component Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
3d
about_data 100% 35
advanced_geometry_construction 100% 5
backup 100% 4
clusterindex
creating_db 100% 3
de9im
equality
geography 100% 1
geography_exercises 100% 4
geometries 100% 3
geometries_exercises 100% 8
geometry_returning 100% 1
geometry_returning_exercises 100% 8 1
Glossary glossary 1 CC-BY-3.0-US 2
history_tracking
index CC-BY-3.0-US
indexing 100% 18
installation CC-BY-3.0-US
introduction 100% 23
joins 1
joins_advanced 100% 1
joins_exercises
knn
license
linear_referencing
loading_data 1
postgis-functions 100% 16 1
projection
projection_exercises 100% 8
rasters CC-BY-3.0-US 100% 4
schemas
security 100% 1 1
simple_sql
simple_sql_exercises 100% 12
spatial_relationships 100% 2
spatial_relationships_exercises 100% 8
topology CC-BY-3.0-US 1
topology_base_types 100% 7
topology_topo_types 100% 10
tuning 100% 5 1
upgrades 100% 1
validity
welcome

Summary

Project website postgis.net/workshops/postgis-intro
Project maintainers9 User avatar cvvergaraUser avatar dkastlUser avatar komzpaUser avatar astrid_emdeUser avatar dmateosUser avatar jsanzUser avatar andischiUser avatar jefUser avatar yellow73
Language Swedish
Language code sv
Text direction Left to right
Case sensitivity Case-sensitive
Number of speakers 13,338,376
03/03/2026

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 2,185 40,938 268,877
Translated 100% 2,185 100% 40,938 100% 268,877
Needs editing 0% 0 0% 0 0% 0
Read-only 0% 0 0% 0 0% 0
Failing checks 8% 188 1% 629 2% 6,714
Strings with suggestions 1% 9 1% 130 1% 952
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 4,986 changes 0 changes 0 changes 0 changes 0 changes 0 changes 3 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes
MarAprMayJunJulAugSepOctNovDecJanFeb

Quick numbers

40,938
Hosted words
2,185
Hosted strings
100%
Translated
2
Contributors
and previous 30 days

Trends of last 30 days

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

Changes committed
Changes committed 09/01/2025
User avatar robe

Translation changed
`ST_Distance(geometry, geometry) <http://postgis.net/docs/ST_Distance.html>`_: For geometry type Returns the 2-dimensional Cartesian minimum distance (based on spatial ref) between two geometries in projected units. For geography type defaults to return spheroidal minimum distance between two geographies in meters.
`ST_Distance(geometriy, geometriy) <http://postgis.net/docs/ST_Distance.html>`_: För geometrityp Returnerar det 2-dimensionella kartesiska minimiavståndet (baserat på spatial ref) mellan två geometrier i projicerade enheter. För geograftyp returneras som standard det sfäroida minsta avståndet mellan två geografier i meter.
09/01/2025
User avatar robe

Contributor joined
Contributor joined 09/01/2025
User avatar None

Changes committed
Changes committed 06/19/2025
User avatar None

Changes committed
Changes committed 06/19/2025
User avatar yeager

Translation changed
The explain shows the loop on the subway stations, and the index-assisted order by inside the loop where we want it:
Förklaringen visar slingan på tunnelbanestationerna och den indexassisterade beställordningen genom att lägga in slingan där vi vill ha den:
06/19/2025
User avatar yeager

Translation changed
PostgreSQL solves the nearest neighbor problem by introducing an "order by distance" (``<->``) operator that induces the database to use an index to speed up a sorted return set. With an "order by distance" operator in place, a nearest neighbor query can return the "N nearest features" just by adding an ordering and limiting the result set to N entries.
PostgreSQL löser det närmaste grannproblemet genom att införa en "order by distance" (``<->``) operatöor som inducerar databasen att använda ett index för att påskynda en sorterad returuppsättning. Med en "order by distance" -operator på plats kan en närmaste grannfråga returnera "N närmaste funktioner" bara genom att lägga till en beställordning och begränsa resultatuppsättningen till N-poster.
06/19/2025
User avatar yeager

Translation changed
Exact equality requires, in the worst case, comparison of each and every vertex in the geometry to determine equality. This can be slow, and may not be appropriate for comparing huge numbers of geometries. To allow for speedier comparison, the equal bounds operator, :command:`~=`, is provided. This operates only on the bounding box (rectangle), ensuring that the geometries occupy the same two dimensional extent, but not necessarily the same space.
Exakt likhet kräver, i värsta fall, jämförelse av varje enskilt vertex i geometrin för att fastställa likhet. Detta kan ta lång tid och är kanske inte lämpligt för att jämföra ett stort antal geometrier. För att möjliggöra snabbare jämförelser finns operatorn equal bounds, :command:`~=`. Denna operatöor verkar endast på den avgränsande rutan (rektangeln) och säkerställer att geometrierna har samma tvådimensionella utsträckning, men inte nödvändigtvis samma utrymme.
06/19/2025
User avatar yeager

Translation changed
PostgreSQL solves the nearest neighbor problem by introducing an "order by distance" (``<->``) operator that induces the database to use an index to speed up a sorted return set. With an "order by distance" operator in place, a nearest neighbor query can return the "N nearest features" just by adding an ordering and limiting the result set to N entries.
PostgreSQL löser det närmaste grannproblemet genom att införa en "order by distance" (``<->``) operatör som inducerar databasen att använda ett index för att påskynda en sorterad returuppsättning. Med en "order by distance" -operatöor på plats kan en närmaste grannfråga returnera "N närmaste funktioner" bara genom att lägga till en beställning och begränsa resultatuppsättningen till N-poster.
06/19/2025
User avatar None

Changes committed
Changes committed 06/17/2025
Browse all changes for this language