Translation status

61 Strings
0%
Browse Translate
1,634 Words
0%
10,453 Characters
0%

Strings status

Strings Words Characters
61 1,634 10,453
All strings Browse Translate Zen
61 1,634 10,453
Unfinished strings Browse Translate Zen
61 1,634 10,453
Untranslated strings Browse Translate Zen
1 1 8
Strings with suggestions Browse Translate Zen
60 1,633 10,445
Unfinished strings without suggestions Browse Translate Zen

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
Translation license Creative Commons Attribution 3.0 United States
Translation process
  • Translations can be made directly.
  • Translation suggestions can be made.
  • Any authenticated user can contribute.
  • The translation uses bilingual files.
Source code repository https://github.com/postgis/postgis-workshops.git
Repository branch master
Last remote commit Update sql cheat sheet with makevalid example 5f99414
Paul Ramsey authored 10/30/2025
Last commit in Weblate Update sql cheat sheet with makevalid example 5f99414
Paul Ramsey authored 10/30/2025
Weblate repository https://weblate.osgeo.org/git/postgis-workshop/index/
File mask postgis-intro/sources/locale/*/LC_MESSAGES/topology.po
Translation file Download postgis-intro/sources/locale/de/LC_MESSAGES/topology.po
Last change June 10, 2025, 6:58 p.m.
Last change made by None
Language German
Language code de
Text direction Left to right
Case sensitivity Case-sensitive
Number of speakers 141,873,196
Number of plurals 2
Plural type One/other
Plurals Singular 1
Plural 0, 2, 3, 4, 5, 6, 7, 8, 9, 10, …
Plural formula n != 1
02/18/2026

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 61 1,634 10,453
Translated 0% 0 0% 0 0% 0
Needs editing 0% 0 0% 0 0% 0
Read-only 0% 0 0% 0 0% 0
Failing checks 0% 0 0% 0 0% 0
Strings with suggestions 1% 1 1% 1 1% 8
Untranslated strings 100% 61 100% 1,634 100% 10,453
Last 12 months Previous

Activity in last 12 months

0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 5 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
MarAprMayJunJulAugSepOctNovDecJanFeb

Quick numbers

1,634
Hosted words
61
Hosted strings
0%
Translated
0
Contributors
and previous 30 days

Trends of last 30 days

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

Resource updated
The “postgis-intro/sources/locale/de/LC_MESSAGES/topology.po” file was changed. 06/10/2025
User avatar None

String added in the repository
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.
 
06/10/2025
User avatar None

String added in the repository
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:
 
06/10/2025
User avatar None

String added in the repository
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.
 
06/10/2025
User avatar None

String added in the repository
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.
 
06/10/2025
User avatar mt:weblate-translation-memory

Suggestion added
Topology
Topologie
02/11/2024
User avatar None

Resource updated
File “postgis-intro/sources/locale/de/LC_MESSAGES/topology.po” was added. 02/05/2024
User avatar None

String updated in the repository
The result of the above is 29 neighborhoods were updated. If you rerun the border dispute queries for neighborhoods and boroughs, you'll find you have no more border disputes.
 
02/05/2024
User avatar None

String updated in the repository
Removing elements from Topogeometries is handled using the `TopoGeom_remElement <https://postgis.net/docs/TopoGeom_remElement.html>`_ function. So lets get on with it, removing duplicaed elements from neighborhoods with the most amount of area as follows:
 
02/05/2024
User avatar None

String updated in the repository
There are a number of ways we could fix this. We could go out surveying asking people what neighbhood do they think they are standing in. Alternatively we could just assign slivers of land to the neighborhood with the least amount of area or to the highest bidder.
 
02/05/2024
Browse all translation changes