Component Approved Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
PostGIS Manual CC-BY-SA-3.0 6% 44% 55,247 1,015,726 7,287,674 51,388 5,440 8,513 164
Glossary Glossary 59% 73% 736 1,003 10,820 736 0 1 0

Overview

Project website postgis.net
Project maintainers User avatar komzpa User avatar strk User avatar robe User avatar cvvergara
Translation license CC-BY-SA-3.0 PostGIS Manual
4 days ago

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 102,972 1,819,151 13,034,188
Source 6,095 107,066 767,235
Approved 1% 376 1% 4,877 1% 37,588
Waiting for review 38% 39,075 38% 688,915 37% 4,911,098
Translated 45% 46,989 44% 802,422 44% 5,735,694
Needs editing 3% 3,859 3% 66,516 3% 480,302
Read-only 7% 7,538 5% 108,630 6% 787,008
Failing checks 5% 5,440 4% 89,002 4% 619,537
Strings with suggestions 8% 8,514 8% 157,172 8% 1,112,129
Untranslated strings 50% 52,124 52% 950,213 52% 6,818,192
Last 12 months Previous

Activity in last 12 months

918 changes 911 changes 2,798 changes 240 changes 78 changes 117 changes 1,608 changes 4,550 changes 59 changes 6,461 changes 4,438 changes 1,039 changes 7,466 changes 12,927 changes 1,328 changes 1,675 changes 749 changes 4,410 changes 520 changes 592 changes 95 changes 7,326 changes 1,275 changes 3,516 changes
Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov

Quick numbers

1,819 k
Hosted words
102 k
Hosted strings
45%
Translated
5
Contributors
and previous 30 days

Trends of last 30 days

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

Alert triggered

  1. postgis
  2. PostGIS Manual
Broken project website URL 3 days ago
User avatar None

Alert triggered

  1. postgis
  2. Glossary
Broken project website URL 3 days ago
User avatar None

Changes pushed

  1. postgis
  2. PostGIS Manual
Changes pushed 4 days ago
User avatar None

Repository notification received

  1. postgis
  2. PostGIS Manual
Gitea: https://gitea.osgeo.org/postgis/postgis, master 4 days ago
User avatar None

Changes committed

  1. postgis
  2. PostGIS Manual
  3. Chinese (Simplified)
Changes committed 4 days ago
User avatar xinbo

Translation completed

  1. postgis
  2. PostGIS Manual
  3. Chinese (Simplified)
Translation completed 4 days ago
User avatar xinbo

Translation added

  1. postgis
  2. PostGIS Manual
  3. Chinese (Simplified)
BRIN stands for "Block Range Index". It is a general-purpose index method provided by PostgreSQL. BRIN is a <emphasis>lossy</emphasis> index method, meaning that a secondary check is required to confirm that a record matches a given search condition (which is the case for all provided spatial indexes). It provides much faster index creation and much smaller index size, with reasonable read performance. Its primary purpose is to support indexing very large tables on columns which have a correlation with their physical location within the table. In addition to spatial indexing, BRIN can speed up searches on various kinds of attribute data structures (integer, arrays etc). For more information see the <link xlink:href="https://www.postgresql.org/docs/current/brin.html">PostgreSQL manual</link>.
BRIN 代表 Block Range Index，是 PostgreSQL 提供的一种通用索引方法。BRIN 是一种 <emphasis>有损</emphasis> 索引，这意味着需要二次检查以确认记录是否符合搜索条件（所有空间索引都是如此）。它提供了更快的索引创建速度和更小的索引尺寸，同时读取性能仍然合理。BRIN 的主要用途是为与表内物理位置相关的列建立索引，以支持超大表的高效查询。除了空间索引，BRIN 还可以加速各种属性数据结构（整数、数组等）的搜索。更多信息请参见 <link xlink:href="https://www.postgresql.org/docs/current/brin.html">PostgreSQL manual</link>。
4 days ago
User avatar xinbo

Translation changed

  1. postgis
  2. PostGIS Manual
  3. Chinese (Simplified)
Like the geometry data type, geography data is associated with a spatial reference system via a spatial reference system identifier (SRID). Any geodetic (long/lat based) spatial reference system defined in the <varname>spatial_ref_sys</varname> table can be used. You can add your own custom geodetic spatial reference system as described in <xref linkend="user-spatial-ref-sys"/>.
与 geometry 类型类似，geography 数据也通过空间参考系统标识符（SRID）关联到空间参考系统。<varname>spatial_ref_sys</varname> 表中定义的任何大地测量（基于经纬度）的空间参考系统都可以使用，也可以按 <xref linkend="user-spatial-ref-sys"/> 所述添加自定义的大地测量空间参考系统。
4 days ago
User avatar xinbo

Translation added

  1. postgis
  2. PostGIS Manual
  3. Chinese (Simplified)
Like the geometry data type, geography data is associated with a spatial reference system via a spatial reference system identifier (SRID). Any geodetic (long/lat based) spatial reference system defined in the <varname>spatial_ref_sys</varname> table can be used. You can add your own custom geodetic spatial reference system as described in <xref linkend="user-spatial-ref-sys"/>.
与 geometry 类型类似，geography 数据也通过空间参考系统标识符（SRID）关联到空间参考系统。spatial_ref_sys 表中定义的任何大地测量（基于经纬度）的空间参考系统都可以使用，也可以按 <xref linkend="user-spatial-ref-sys"/> 所述添加自定义的大地测量空间参考系统。
4 days ago
User avatar xinbo

Translation added

  1. postgis
  2. PostGIS Manual
  3. Chinese (Simplified)
[raster] Add ST_ReclassExact to quickly remap values in raster (Paul Ramsey)
[raster] 新增 ST_ReclassExact，用于快速重映射 raster 中的值（Paul Ramsey）
4 days ago
Browse all project changes
User avatar strk

Announcement posted

  1. postgis

Translators please make sure NOT to translate XML entities like &gt; as those translation (maybe automated by some browser plugin) tend to often break the system, as shown for example here for the Chinese translation: https://woodie.osgeo.org/repos/30/pipeline/964/22

2 years ago
Browse all project changes