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 34 0 0
advanced_geometry_construction 0 0 0 0 0 0 0
backup 0 0 0 0 0 0 0
clusterindex 0 0 0 0 1 0 0
creating_db 0 0 0 0 4 0 0
de9im 0 0 0 0 0 0 0
equality 0 0 0 0 0 0 0
geography 0 0 0 0 0 0 0
geography_exercises 0 0 0 0 0 0 0
geometries 0 0 0 0 3 0 0
geometries_exercises 0 0 0 0 9 0 0
geometry_returning 0 0 0 0 0 0 0
geometry_returning_exercises 0 0 0 0 1 0 0
Glossary glossary 1 CC-BY-3.0-US 0 0 0 0 0 0 0
history_tracking 0 0 0 0 0 0 0
index CC-BY-3.0-US 0 0 0 0 3 0 0
indexing 0 0 0 0 1 0 0
installation CC-BY-3.0-US 0 0 0 0 0 0 0
introduction 0 0 0 0 31 0 0
joins 0 0 0 0 0 0 0
joins_advanced 0 0 0 0 0 0 0
joins_exercises 0 0 0 0 0 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 2 0 0
postgis-functions 0 0 0 0 16 0 0
projection 0 0 0 0 0 0 0
projection_exercises 0 0 0 0 0 0 0
rasters CC-BY-3.0-US 0 0 0 0 1 0 0
schemas 0 0 0 0 0 0 0
security 0 0 0 0 1 0 0
simple_sql 0 0 0 0 0 0 0
simple_sql_exercises 0 0 0 0 11 0 0
spatial_relationships 0 0 0 0 0 0 0
spatial_relationships_exercises 0 0 0 0 8 0 0
topology CC-BY-3.0-US 0 0 0 0 0 0 0
tuning 0 0 0 0 0 0 0
upgrades 0 0 0 0 0 0 0
validity 0 0 0 0 0 0 0
welcome 0 0 0 0 1 0 0

Overview

Project website postgis.net/workshops/postgis-intro
Project maintainers User avatar jsanz User avatar cvvergara User avatar komzpa User avatar dmateos User avatar yellow73 User avatar dkastl User avatar andischi User avatar astrid_emde User avatar jef
Translation license CC-BY-3.0-US installation topology rasters index glossary 1
3 hours ago

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 2,009 37,874 252,071
Translated 100% 2,009 100% 37,874 100% 252,071
Needs editing 0% 0 0% 0 0% 0
Read-only 100% 2,009 100% 37,874 100% 252,071
Failing checks 6% 127 1% 592 1% 4,827
Strings with suggestions 0% 0 0% 0 0% 0
Untranslated strings 0% 0 0% 0 0% 0
Last 12 months Previous

Activity in last 12 months

12 changes 1 change 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 1 change 0 changes 355 changes 0 changes 0 changes 62 changes 9 changes 0 changes
Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar

Quick numbers

37,874
Hosted words
2,009
Hosted strings
100%
Translated
0
Contributors
and previous 30 days

Trends of last 30 days

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

Resource updated

  1. postgis-workshop
  2. topology
  3. English
File postgis-intro/sources/locale/pot/topology.pot was added. 2 months ago
User avatar None

String updated in the repository

  1. postgis-workshop
  2. topology
  3. English
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.
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.
2 months ago
User avatar None

String updated in the repository

  1. postgis-workshop
  2. topology
  3. English
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.
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.
2 months ago
User avatar None

String updated in the repository

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

String updated in the repository

  1. postgis-workshop
  2. topology
  3. English
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.
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.
2 months ago
User avatar None

String updated in the repository

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

String updated in the repository

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

String updated in the repository

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

String updated in the repository

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

String updated in the repository

  1. postgis-workshop
  2. topology
  3. English
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 declaritively inspect what components are shared across boroughs.
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 declaritively inspect what components are shared across boroughs.
2 months ago
Browse all changes for this language