Component Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
3d 66% 78 1,670 10,298 78 0 0 0
about_data 63% 208 1,693 11,420 205 44 0 0
advanced_geometry_construction 72% 81 1,791 11,124 81 5 0 0
backup 35% 277 6,621 41,561 277 0 0 0
clusterindex 64% 45 1,267 7,558 45 1 0 0
creating_db 68% 44 653 4,298 44 7 0 0
de9im 51% 88 1,704 10,184 88 0 0 0
equality 80% 12 397 2,475 12 0 0 0
geography 50% 220 4,398 31,829 220 0 0 0
geography_exercises 66% 42 470 3,188 42 12 0 0
geometries 60% 262 4,521 32,664 262 4 0 0
geometries_exercises 52% 150 1,160 9,387 150 17 0 0
geometry_returning 54% 67 1,739 12,422 67 0 0 0
geometry_returning_exercises 55% 50 664 4,555 50 9 2 0
history_tracking 60% 82 1,708 10,062 82 0 0 0
index CC-BY-3.0-US 74% 60 338 2,957 50 12 4 0
indexing 72% 85 1,988 13,716 84 2 0 0
installation CC-BY-3.0-US 89% 16 215 1,488 16 0 0 0
introduction 57% 360 6,014 41,949 360 37 11 1
joins 61% 68 1,718 11,192 68 0 1 0
joins_advanced 51% 78 1,496 9,343 78 0 0 0
joins_exercises 70% 43 415 3,026 43 13 2 0
knn 55% 27 835 5,022 27 1 0 0
license 66% 6 112 808 6 0 0 0
linear_referencing 52% 44 1,102 7,827 44 0 1 0
loading_data 43% 288 6,454 41,947 288 1 2 0
postgis-functions 64% 72 535 4,189 72 21 0 0
projection 60% 61 1,662 11,141 61 0 0 0
projection_exercises 65% 48 543 3,675 48 13 2 0
rasters CC-BY-3.0-US 40% 627 17,874 114,234 627 1 5 0
schemas 59% 58 1,115 6,788 58 0 1 0
security 51% 132 2,416 15,896 132 1 0 0
simple_sql 67% 67 1,196 7,990 67 5 0 0
simple_sql_exercises 66% 86 698 5,050 86 27 5 0
spatial_relationships 50% 124 2,594 19,100 124 3 0 0
spatial_relationships_exercises 64% 53 618 4,309 53 13 3 0
topology CC-BY-3.0-US 50% 120 3,203 20,394 120 0 2 0
tuning 40% 136 3,288 21,278 136 0 6 0
upgrades 61% 65 1,096 6,796 65 1 0 0
validity 61% 52 1,292 8,356 52 1 0 0
welcome 76% 46 645 3,922 46 4 0 0
Glossary glossary 1 CC-BY-3.0-US 34% 255 3,183 26,022 255 0 46 0

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

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 10,931 201,121 1,345,461
Source 2,011 37,978 252,745
Translated 56% 6,148 53% 108,020 53% 724,021
Needs editing 1% 14 1% 59 1% 563
Read-only 18% 2,011 18% 37,978 18% 252,745
Failing checks 2% 255 1% 1,410 1% 10,748
Strings with suggestions 1% 93 1% 202 1% 1,399
Untranslated strings 43% 4,769 46% 93,042 46% 620,877
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

201 k
Hosted words
10,931
Hosted strings
56%
Translated
3
Contributors
and previous 30 days

Trends of last 30 days

—
Hosted words
+100%
—
Hosted strings
+100%
—
Translated
+56%
−33%
Contributors
+100%
User avatar anonymous

Suggestion added

  1. postgis-workshop
  2. joins
  3. Spanish
Spatial Joins
Uniones Espaciales
8 days ago
User avatar None

Repository rebased

  1. postgis-workshop
  2. index
Repository rebased

Original revision: 1bdc939ee05081d56718cb79a748cced4a2bf27a
New revision: 4a5082b8056bf4e6a25f25e692b9cb13d869cd5d 12 days ago
User avatar None

Repository notification received

  1. postgis-workshop
  2. index
GitHub: https://api.github.com/repos/postgis/postgis-workshops, master 12 days ago
User avatar None

Changes pushed

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

Changes committed

  1. postgis-workshop
  2. loading_data
  3. Chinese (Simplified)
Changes committed 2 weeks ago
User avatar xinbo

Translation changed

  1. postgis-workshop
  2. loading_data
  3. Chinese (Simplified)
QGIS comes with a tool called `DbManager <https://docs.qgis.org/3.28/en/docs/user_manual/plugins/core_plugins/plugins_db_manager.html#dbmanager>`_ that allows you to connect to various different kinds of databases, including a PostGIS enabled one. After you have a PostGIS Database connection configured, go to :command:`Database->DbManager` and expand to your database as shown below:
QGIS带有一个名为 `DbManager <https://docs.qgis.org/3.28/en/docs/user_manual/plugins/core_plugins/plugins_db_manager.html#dbmanager>`_ 的工具，它允许您连接到各种不同类型的数据库，包括启用了PostGIS的数据库。配置了PostGIS数据库连接后，转到 :command:`Database->DbManager` ，展开到您的数据库，如下所示：
2 weeks ago
User avatar xinbo

Translation changed

  1. postgis-workshop
  2. loading_data
  3. Chinese (Simplified)
The **lco** option stands for "layer create option". Different drivers have different create options, and we are using three options for the `PostgreSQL driver <https://gdal.org/drivers/vector/pg.html>`_ here.
**lco** 选项代表“图层创建选项”。不同的驱动程序具有不同的创建选项，我们在这里使用了 `PostgreSQL驱动程序 <https://gdal.org/drivers/vector/pg.html>`_ 的三个选项。
2 weeks ago
User avatar xinbo

Translation changed

  1. postgis-workshop
  2. loading_data
  3. Chinese (Simplified)
Finally, if you have installed `HomeBrew <https://brew.sh/>`_ you can install the **gdal** package to get access to :file:`ogr2ogr`
若已安装 `HomeBrew <https://brew.sh/>`_ ，可通过安装 **gdal** 软件包获取 :file:`ogr2ogr` 工具
2 weeks ago
User avatar xinbo

Translation changed

  1. postgis-workshop
  2. loading_data
  3. Chinese (Simplified)
If you installed `Postgres.app <https://postgresapp.com/>`_, then you will find :file:`ogr2ogr` in the :file:`/Applications/Postgres.app/Contents/Versions/*/bin` directory.
如果您安装了 `Postgres.app <https://postgresapp.com/>`_ ，那么您会在 :file:`/Applications/Postgres.app/Contents/Versions/*/bin` 目录中找到 :file:`ogr2ogr`。
2 weeks ago
User avatar xinbo

Translation changed

  1. postgis-workshop
  2. loading_data
  3. Chinese (Simplified)
Builds of ogr2ogr can be downloaded from `MS4W <https://ms4w.com/download.html>`_.
ogr2ogr的构建版本可以从 `MS4W <https://ms4w.com/download.html>`_ 下载。
2 weeks ago
Browse all project changes