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

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 license CC-BY-3.0-US installation topology index glossary 1 rasters
4 hours ago

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% 189 1% 615 2% 6,613
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 0 changes 0 changes 0 changes 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
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep

Quick numbers

40,938
Hosted words
2,185
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 robe

Changes committed

  1. postgis-workshop
  2. geography
  3. Swedish
Changes committed a month ago
User avatar robe

Translation changed

  1. postgis-workshop
  2. geography
  3. Swedish
`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.
a month ago
User avatar robe

Contributor joined

  1. postgis-workshop
  2. geography
  3. Swedish
Contributor joined a month ago
User avatar None

Changes committed

  1. postgis-workshop
  2. knn
  3. Swedish
Changes committed 4 months ago
User avatar None

Changes committed

  1. postgis-workshop
  2. equality
  3. Swedish
Changes committed 4 months ago
User avatar yeager

Translation changed

  1. postgis-workshop
  2. knn
  3. Swedish
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:
4 months ago
User avatar yeager

Translation changed

  1. postgis-workshop
  2. knn
  3. Swedish
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.
4 months ago
User avatar yeager

Translation changed

  1. postgis-workshop
  2. equality
  3. Swedish
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.
4 months ago
User avatar yeager

Translation changed

  1. postgis-workshop
  2. knn
  3. Swedish
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.
4 months ago
User avatar None

Changes committed

  1. postgis-workshop
  2. geometries
  3. Swedish
Changes committed 4 months ago
Browse all changes for this language