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 0 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
yesterday

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% 92 1% 200 1% 1,386
Untranslated strings 43% 4,769 46% 93,042 46% 620,877
Last 12 months Previous

Activity in last 12 months

56 changes 774 changes 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
May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr

Quick numbers

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

Trends of last 30 days

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

Repository rebased

  1. postgis-workshop
  2. index
Repository rebased

Original revision: 1bdc939ee05081d56718cb79a748cced4a2bf27a
New revision: 4a5082b8056bf4e6a25f25e692b9cb13d869cd5d yesterday
User avatar None

Repository notification received

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

Changes pushed

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

Changes committed

  1. postgis-workshop
  2. loading_data
  3. Chinese (Simplified)
Changes committed a week 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` ，展开到您的数据库，如下所示：
8 days 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>`_ 的三个选项。
8 days 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` 工具
8 days 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`。
8 days 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>`_ 下载。
8 days ago
User avatar xinbo

Translation changed

  1. postgis-workshop
  2. loading_data
  3. Chinese (Simplified)
ogr2ogr is included as part of `QGIS Install <https://qgis.org/en/site/forusers/download.html>`_ and accessible via OSGeo4W Shell -
ogr2ogr包含在 `QGIS安装包 <https://qgis.org/en/site/forusers/download.html>`_ 中，并可以通过OSGeo4W Shell访问 -
8 days ago
Browse all project changes