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 36 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 13 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 jef User avatar cvvergara User avatar astrid_emde User avatar dmateos User avatar dkastl User avatar jsanz User avatar andischi User avatar yellow73 User avatar komzpa
Translation license CC-BY-3.0-US installation topology index glossary 1 rasters
an hour 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% 191 1% 633 2% 6,727
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 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 4,986 changes
Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun

Quick numbers

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

Trends of last 30 days

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

Changes committed

  1. postgis-workshop
  2. knn
  3. Swedish
Changes committed a month ago
User avatar None

Changes committed

  1. postgis-workshop
  2. equality
  3. Swedish
Changes committed a month 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:
a month 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.
a month 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.
a month 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.
a month ago
User avatar None

Changes committed

  1. postgis-workshop
  2. geometries
  3. Swedish
Changes committed a month ago
User avatar None

Changes committed

  1. postgis-workshop
  2. rasters
  3. Swedish
Changes committed a month ago
User avatar None

Changes committed

  1. postgis-workshop
  2. installation
  3. Swedish
Changes committed a month ago
User avatar yeager

Translation changed

  1. postgis-workshop
  2. rasters
  3. Swedish
PostGIS raster comes packaged with a number of functions for editing rasters. These functions are both used for editing as well as creating derivative raster data sets. You will find these listed in `Raster Editors <https://postgis.net/docs/RT_reference.html#Raster_Editors>`_ and `Raster Management <https://postgis.net/docs/RT_reference.html#Raster_Management_Functions>`_.
PostGIS raster levereras med ett antal funktioner för att redigera raster. Dessa funktioner används både för att redigera och för att skapa derivata rasterdatauppsättningar. Du hittar dessa listade i `Raster Editors-redigerare <https://postgis.net/docs/RT_reference.html#Raster_Editors>`_ och `Raster Management <https://postgis.net/docs/RT_reference.html#Raster_Management_Functions>`_.
a month ago
Browse all changes for this language