Component Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
3d 71% 78 1,670 10,298 78 0 0 0
about_data 68% 207 1,692 11,403 205 80 0 0
advanced_geometry_construction 76% 81 1,791 11,124 81 9 0 0
backup 45% 277 6,621 41,561 277 4 0 0
clusterindex 71% 42 1,166 7,006 42 1 0 0
creating_db 72% 44 653 4,298 44 8 0 0
de9im 60% 88 1,704 10,184 88 0 0 0
equality 83% 12 397 2,475 12 0 0 0
geography 57% 221 4,451 32,139 220 1 0 0
geography_exercises 71% 42 470 3,188 42 10 0 0
geometries 67% 262 4,521 32,664 262 6 0 0
geometries_exercises 61% 142 1,120 9,011 142 25 0 0
geometry_returning 64% 65 1,720 12,307 65 2 0 0
geometry_returning_exercises 67% 45 645 4,396 45 22 2 0
history_tracking 67% 82 1,708 10,062 82 1 0 0
index CC-BY-3.0-US 77% 58 332 2,886 50 11 2 0
indexing 77% 85 1,988 13,716 84 35 0 0
installation CC-BY-3.0-US 90% 16 215 1,488 16 0 0 0
introduction 62% 360 6,014 41,949 360 60 8 1
joins 68% 67 1,716 11,179 67 0 1 0
joins_advanced 64% 71 1,408 8,771 71 0 0 0
joins_exercises 78% 38 399 2,828 38 16 0 0
knn 80% 15 429 2,591 15 0 0 0
license 71% 6 112 808 6 0 0 0
linear_referencing 61% 44 1,102 7,827 44 0 1 0
loading_data 50% 287 6,451 41,927 287 1 2 0
postgis-functions 70% 72 535 4,189 72 33 1 0
projection 67% 61 1,662 11,141 61 0 0 0
projection_exercises 83% 28 291 1,977 28 17 0 0
rasters CC-BY-3.0-US 50% 626 17,873 114,224 626 7 4 0
schemas 67% 58 1,115 6,788 58 0 1 0
security 61% 132 2,416 15,896 132 2 1 0
simple_sql 71% 67 1,196 7,990 67 4 0 0
simple_sql_exercises 71% 86 698 5,050 86 26 0 0
spatial_relationships 57% 124 2,594 19,100 124 5 0 0
spatial_relationships_exercises 73% 48 592 4,105 48 18 0 0
topology CC-BY-3.0-US 60% 120 3,203 20,400 120 0 2 0
topology_base_types 73% 92 1,748 9,405 79 26 0 0
topology_topo_types 71% 101 1,932 10,421 89 36 0 0
tuning 52% 132 3,276 21,198 132 11 3 0
upgrades 68% 65 1,096 6,796 65 2 0 0
validity 71% 49 1,180 7,740 49 0 0 0
welcome 78% 46 645 3,922 46 4 0 0
Glossary glossary 1 CC-BY-3.0-US 45% 235 3,163 25,946 235 0 28 0

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

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 13,646 251,003 1,663,310
Source 2,189 40,970 269,165
Translated 64% 8,769 61% 155,293 61% 1,028,936
Needs editing 1% 37 1% 762 1% 4,337
Read-only 16% 2,189 16% 40,970 16% 269,165
Failing checks 3% 483 1% 2,406 1% 20,738
Strings with suggestions 1% 56 1% 194 1% 1,417
Untranslated strings 35% 4,840 37% 94,948 37% 630,037
Last 12 months Previous

Activity in last 12 months

1,104 changes 71 changes 457 changes 8 changes 505 changes 45 changes 297 changes 9 changes 597 changes 5 changes 324 changes 65 changes 335 changes 3 changes 227 changes 0 changes 1,754 changes 42 changes 58 changes 697 changes 67 changes 106 changes 774 changes 12 changes
Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May

Quick numbers

251 k
Hosted words
13,646
Hosted strings
64%
Translated
10
Contributors
and previous 30 days

Trends of last 30 days

+19%
Hosted words
+100%
+19%
Hosted strings
+100%
+8%
Translated
+56%
+60%
Contributors
+100%
User avatar mt:weblate

Suggestion added

  1. postgis-workshop
  2. geometry_returning_exercises
  3. Spanish
:command:`ST_Transform(geometry, srid)` converts ``geometries`` into different spatial reference systems
:command:`ST_Transform(geometry, srid)` convierte las geometrías a un determinado SRID
3 days ago
User avatar None

Changes pushed

  1. postgis-workshop
  2. index
Changes pushed 3 days ago
User avatar None

Changes committed

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

Changes committed

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

Changes pushed

  1. postgis-workshop
  2. index
Changes pushed 5 days ago
User avatar None

Changes committed

  1. postgis-workshop
  2. joins_advanced
  3. Spanish
Changes committed 5 days ago
Browse all project changes