Overview

Project website postgis.net/workshops/postgis-intro
Project maintainers User avatar komzpa User avatar dmateos User avatar dkastl User avatar jsanz User avatar andischi User avatar yellow73 User avatar cvvergara User avatar astrid_emde User avatar jef
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 Merge pull request #143 from osgeoweblate/weblate-postgis-workshop-index 4a5082b
Regina Obe authored 11 days ago
Last commit in Weblate Translated using Weblate (Chinese (Simplified)) 59d4f95
Wangdapeng authored 2 months ago
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 Feb. 11, 2024, 5:45 p.m.
Last author Weblate Translation Memory
2 weeks ago

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 61 1,634 10,450
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,450
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 63 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes
Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May

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 mt:weblate-translation-memory

Suggestion added

  1. postgis-workshop
  2. topology
  3. German
Topology
Topologie
a year ago
User avatar None

Resource updated

  1. postgis-workshop
  2. topology
  3. German
File postgis-intro/sources/locale/de/LC_MESSAGES/topology.po was added. a year ago
User avatar None

String updated in the repository

  1. postgis-workshop
  2. topology
  3. German
We do still have gaps of empty space between neighborhoods caused by intensive simplication. 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.
 
a year ago
User avatar None

String updated in the repository

  1. postgis-workshop
  2. topology
  3. German
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.
 
a year ago
User avatar None

String updated in the repository

  1. postgis-workshop
  2. topology
  3. German
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:
 
a year ago
User avatar None

String updated in the repository

  1. postgis-workshop
  2. topology
  3. German
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.
 
a year ago
User avatar None

String updated in the repository

  1. postgis-workshop
  2. topology
  3. German
Because boroughs are an aggregation of neighborhoods, we can fix the borough issue by fixing the neighborhood border disputes.
 
a year ago
User avatar None

String updated in the repository

  1. postgis-workshop
  2. topology
  3. German
If we look at our neighborhoods, we'll see a similar story but with 44 border disputes:
 
a year ago
User avatar None

String updated in the repository

  1. postgis-workshop
  2. topology
  3. German
The result will be 5 rows corresponding to border disputes between Queens and Brooklyn.
 
a year ago
User avatar None

String updated 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 folows:
 
a year ago
Browse all translation changes