Component Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
3d 0% 39 835 5,149 39 0 0 0
about_data 1% 93 815 5,442 93 0 0 0
advanced_geometry_construction 1% 57 1,286 7,936 57 0 0 0
backup 0% 72 1,698 10,668 72 0 0 0
clusterindex 0% 21 583 3,503 21 0 0 0
creating_db 0% 23 329 2,166 23 0 0 0
de9im 0% 45 855 5,120 45 0 0 0
equality 0% 12 397 2,475 12 0 0 0
geography 0% 74 1,467 10,616 74 0 0 0
geography_exercises 0% 21 235 1,594 21 0 0 0
geometries 1% 132 2,265 16,369 132 0 0 0
geometries_exercises 0% 53 402 3,241 53 0 0 0
geometry_returning 8% 34 878 6,314 34 0 0 0
geometry_returning_exercises 0% 28 346 2,370 28 0 0 0
Glossary glossary 1 CC-BY-3.0-US 0% 43 531 4,339 43 0 9 0
history_tracking 2% 41 854 5,031 41 0 0 0
index CC-BY-3.0-US 24% 22 125 1,064 22 2 0 0
indexing 0% 62 1,318 9,331 62 0 0 0
installation CC-BY-3.0-US 36% 16 215 1,488 16 0 0 0
introduction 1% 119 2,001 13,961 119 0 7 0
joins 0% 35 868 5,703 35 0 0 0
joins_advanced 0% 40 763 4,781 40 0 0 0
joins_exercises 0% 29 266 1,937 29 0 0 0
knn 0% 15 429 2,591 15 0 0 0
license 0% 3 56 404 3 0 0 0
linear_referencing 0% 23 553 3,929 23 0 1 0
loading_data 2% 71 1,613 10,486 71 0 0 0
postgis-functions 2% 40 280 2,247 40 0 0 0
projection 0% 31 832 5,577 31 0 0 0
projection_exercises 0% 28 291 1,977 28 0 0 0
rasters CC-BY-3.0-US 0% 209 5,958 38,078 209 0 2 0
schemas 0% 36 698 4,263 36 0 1 0
security 2% 66 1,208 7,948 66 0 0 0
simple_sql 0% 34 599 4,000 34 0 0 0
simple_sql_exercises 0% 43 349 2,525 43 0 0 0
spatial_relationships 2% 41 864 6,357 41 0 0 0
spatial_relationships_exercises 0% 30 324 2,271 30 0 0 0
topology CC-BY-3.0-US 0% 61 1,634 10,453 61 0 1 0
tuning 0% 46 1,098 7,106 46 0 1 0
upgrades 0% 34 594 3,714 34 0 0 0
validity 0% 34 797 5,076 34 0 0 0
welcome 12% 21 314 1,916 21 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 yellow73 User avatar dkastl User avatar jsanz User avatar andischi User avatar komzpa
Translation license CC-BY-3.0-US installation topology index glossary 1 rasters
6 hours ago

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 2,011 37,978 252,747
Translated 1% 34 1% 155 1% 1,231
Needs editing 0% 0 0% 0 0% 0
Read-only 0% 0 0% 0 0% 0
Failing checks 1% 2 1% 30 1% 285
Strings with suggestions 1% 22 1% 25 1% 161
Untranslated strings 98% 1,977 99% 37,823 99% 251,516
Last 12 months Previous

Activity in last 12 months

0 changes 0 changes 0 changes 4 changes 0 changes 1 change 0 changes 0 changes 0 changes 6 changes 0 changes 1 change 0 changes 0 changes 63 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 10 changes
Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun

Quick numbers

37,978
Hosted words
2,011
Hosted strings
1%
Translated
1
Contributors
and previous 30 days

Trends of last 30 days

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

Resource updated

  1. postgis-workshop
  2. geography
  3. German
The "postgis-intro/sources/locale/de/LC_MESSAGES/geography.po" file was changed. 3 weeks ago
User avatar None

String added in the repository

  1. postgis-workshop
  2. geography
  3. German
By appending ``::geometry`` to our geography value, we convert the object to a geometry with an SRID of 4326. From there we can use as many geometry functions as strike our fancy. But, remember -- now that our object is a geometry, the coordinates will be interpreted as Cartesian coordinates, not spherical ones.
 
3 weeks ago
User avatar None

Resource updated

  1. postgis-workshop
  2. 3d
  3. German
The "postgis-intro/sources/locale/de/LC_MESSAGES/3d.po" file was changed. 3 weeks ago
User avatar None

Resource updated

  1. postgis-workshop
  2. about_data
  3. German
The "postgis-intro/sources/locale/de/LC_MESSAGES/about_data.po" file was changed. 3 weeks ago
User avatar None

String added in the repository

  1. postgis-workshop
  2. about_data
  3. German
Number of records: 38794
 
3 weeks ago
User avatar None

Resource updated

  1. postgis-workshop
  2. topology
  3. German
The "postgis-intro/sources/locale/de/LC_MESSAGES/topology.po" file was changed. 3 weeks ago
User avatar None

String added in the repository

  1. postgis-workshop
  2. topology
  3. German
We do still have gaps of empty space between neighborhoods caused by intensive simplification. Such issues can be fixed by directly editing the topology using the `Topology Editor family of functions <https://postgis.net/docs/Topology.html#Topology_Editing>`_ and/or filling in the holes and assigning those to neighborhoods.
 
3 weeks ago
User avatar None

String added in the repository

  1. postgis-workshop
  2. topology
  3. German
What is returned are a set of topolements. A topoelement is represented as an array of 2 integers with the first number being the id of the element, and the second, being the layer (or primitive type) of the element. PostGIS GetTopoElements returns the primitives of a topogeometry with types number 1-3 corresponding to (1: nodes, 2: edges, and 3: faces). All the topoelements for neighborhoods and boroughs are type 3, which corresponds to a topological face. We can use the `ST_GetFaceGeometry <https://postgis.net/docs/ST_GetFaceGeometry.html>`_ to get a visual representation of these shared faces as follows:
 
3 weeks ago
User avatar None

String added in the repository

  1. postgis-workshop
  2. topology
  3. German
Which tells us that Queens and Brooklyn are in the middle of border wars. In this query we use the `GetTopoGeomElements <https://postgis.net/docs/GetTopoGeomElements.html>`_ function to declaratively inspect what components are shared across boroughs.
 
3 weeks ago
User avatar None

String added in the repository

  1. postgis-workshop
  2. topology
  3. German
Now we can express declaratively that boros are formed from a collection of neighborhoods by defining a column called *topo* in *nyc_boros_t* table that is of type POLYGON and is a collection of other topogeometries from *nyc_neighborhoods_t.topo* column.
 
3 weeks ago
Browse all changes for this language