Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/postgis-workshop/joins/zh_Hans/changes/?format=api
{ "count": 86, "next": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/changes/?format=api&page=2", "previous": null, "results": [ { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2025-03-27T08:47:38.309648Z", "action": 17, "target": "", "id": 2042755, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/2042755/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236817/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2025-03-27T07:15:37.836139Z", "action": 26, "target": "`sum(expression) <http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: 返回一组记录中记录总和的PostgreSQL聚合函数。", "id": 2042714, "action_name": "Suggestion removed", "url": "https://weblate.osgeo.org/api/changes/2042714/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236817/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2025-03-27T07:15:34.476942Z", "action": 2, "target": "`sum(expression) <http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_：PostgreSQL 聚合函数，用于计算记录集中所有记录的总和值。", "id": 2042713, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2042713/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236814/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2025-03-27T07:15:01.932257Z", "action": 26, "target": "`ST_Intersects(geometry_a, geometry_b) <http://postgis.net/docs/ST_Intersects.html>`_：若 Geometries 对象或 Geography 对象存在 “空间相交”，即有任意部分重叠，返回 TRUE，否则返回 FALSE.", "id": 2042711, "action_name": "Suggestion removed", "url": "https://weblate.osgeo.org/api/changes/2042711/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236814/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2025-03-27T07:14:59.089838Z", "action": 2, "target": "`ST_Intersects(geometry A, geometry B) <http://postgis.net/docs/ST_Intersects.html>`_：当几何图形/地理要素\"存在空间交集\"（即共享任意空间区域）时返回 TRUE，否则（两者相离时）返回 FALSE。", "id": 2042710, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/2042710/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236811/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": null, "author": "https://weblate.osgeo.org/api/users/anonymous/?format=api", "timestamp": "2024-05-07T00:40:59.417253Z", "action": 29, "target": "函数列表", "id": 1957057, "action_name": "Suggestion removed during cleanup", "url": "https://weblate.osgeo.org/api/changes/1957057/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-05-06T21:00:37.769754Z", "action": 17, "target": "", "id": 1957042, "action_name": "Changes committed", "url": "https://weblate.osgeo.org/api/changes/1957042/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236796/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2024-05-06T02:58:58.561635Z", "action": 2, "target": "``JOIN``子句组合了两个 ``FROM`` 项。默认情况下，我们使用 ``INNER JOIN``，但还有四种其他类型的连接。有关更多信息，请参阅 PostgreSQL 文档中的`join_type <http://www.postgresql.org/docs/9.1/interactive/sql-select.html#SQL-FROM>`_ 定义。", "id": 1956761, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/1956761/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2024-05-06T02:57:15.689546Z", "action": 1, "target": "", "id": 1956757, "action_name": "Translation completed", "url": "https://weblate.osgeo.org/api/changes/1956757/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236817/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2024-05-06T02:57:15.587940Z", "action": 5, "target": "`sum(expression) <http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: PostgreSQL 聚合函数，返回一组记录中的记录总和。", "id": 1956756, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/1956756/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236816/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2024-05-06T02:56:52.715837Z", "action": 5, "target": "`strpos(string, substring) <http://www.postgresql.org/docs/current/static/functions-string.html>`_:PostgreSQL 字符串函数，返回指定子字符串的整数位置。", "id": 1956753, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/1956753/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236815/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2024-05-06T02:56:35.434099Z", "action": 5, "target": "`round(v numeric, s integer) <http://www.postgresql.org/docs/current/interactive/functions-math.html>`_: 四舍五入到 s 小数位的 PostgreSQL 数学函数", "id": 1956752, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/1956752/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236814/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2024-05-06T02:55:59.333066Z", "action": 5, "target": "`ST_Intersects(geometry A, geometry B) <http://postgis.net/docs/ST_Intersects.html>`_: 如果几何/地理“空间相交”（有任意部分重叠），则返回 TRUE，否则返回 （FALSE它们不相交）。", "id": 1956751, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/1956751/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236813/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2024-05-06T02:53:56.820677Z", "action": 5, "target": "`ST_DWithin(geometry A, geometry B, radius) <http://postgis.net/docs/ST_DWithin.html>`_: 如果几何图形彼此之间在指定的距离内，则返回true。", "id": 1956749, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/1956749/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236812/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2024-05-06T02:53:21.951284Z", "action": 5, "target": "`ST_Contains(geometry A, geometry B) <http://postgis.net/docs/ST_Contains.html>`_:当且仅当B的任何点都不位于A的外部，并且B的内部至少有一个点位于A的内部时，返回true。", "id": 1956748, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/1956748/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236811/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2024-05-06T02:52:22.899682Z", "action": 5, "target": "函数列表", "id": 1956746, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/1956746/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236810/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2024-05-06T02:52:01.506055Z", "action": 5, "target": "和以前一样，连接创建一个虚拟表，其中包含 ``JOIN ON`` 限制范围内可用的所有可能组合，然后将这些行输入到 ``GROUP`` 摘要中。空间魔力在于 ``ST_DWithin`` 函数，它确保计算中仅包含靠近相应地铁站的人口普查区块。", "id": 1956743, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/1956743/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236809/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2024-05-06T02:50:52.631393Z", "action": 5, "target": "现在我们可以将地铁线路表连接到我们的原始查询中。", "id": 1956742, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/1956742/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236808/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2024-05-06T02:50:44.944496Z", "action": 5, "target": "为了回答这个问题，我们将在查询中添加另一个连接，以便我们可以同时计算许多地铁线路的组成。为此，我们需要创建一个新表来枚举我们想要汇总的所有行。", "id": 1956741, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/1956741/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236807/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2024-05-06T02:49:01.176240Z", "action": 5, "target": "在上一节中，我们看到 A 列车所服务的人群与城市其他地区的种族构成差异不大。是否存在种族构成非平均的火车？", "id": 1956738, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/1956738/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236806/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2024-05-06T02:48:18.722281Z", "action": 5, "target": "高级连接", "id": 1956737, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/1956737/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236805/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2024-05-06T02:48:07.614580Z", "action": 5, "target": "因此，A 号列车沿线的种族构成与整个纽约市的构成并没有根本不同。", "id": 1956736, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/1956736/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236804/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2024-05-06T02:47:33.527490Z", "action": 5, "target": "我们来总结一下A线附近200米范围内的种族构成。", "id": 1956735, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/1956735/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236803/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2024-05-06T02:47:17.966184Z", "action": 5, "target": "因此，要找到 A 列，我们需要其中``routes``包含“A”的任何行。我们可以通过多种方式做到这一点，但今天我们将使用这样一个事实：仅当“A”位于 ``routes``字段中时，:command:`strpos(routes,'A')`才会返回非零数字。", "id": 1956732, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/1956732/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236802/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2024-05-06T02:43:50.097503Z", "action": 5, "target": "``DISTINCT`` 关键字可消除结果中的重复行。如果没有 ``DISTINCT`` 关键字，上面的查询会识别 491 个结果，而不是 73 个。", "id": 1956731, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/1956731/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236801/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2024-05-06T02:43:03.930977Z", "action": 5, "target": "首先，请注意 ``nyc_subway_stations`` table ``routes`` 字段的内容是我们感兴趣的查找 A-train 的内容。里面的值有点复杂。", "id": 1956730, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/1956730/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236800/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2024-05-06T02:40:58.205266Z", "action": 5, "target": "杜克·艾灵顿曾经唱过“你必须乘坐 A 列车去哈莱姆区的糖山。”正如我们之前所看到的，哈莱姆区的非裔美国人人口是曼哈顿最高的（80.5%）。那么杜克所说的 A 列车也是如此吗？", "id": 1956729, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/1956729/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236799/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2024-05-06T02:36:43.227526Z", "action": 5, "target": "因此，在纽约的 800 万人口中，大约 44% 被记录为“白人”，26% 被记录为“黑人”。", "id": 1956728, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/1956728/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236798/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2024-05-06T02:36:17.271232Z", "action": 5, "target": "首先，让我们了解一下该城市的基本种族构成。", "id": 1956727, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/1956727/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236797/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2024-05-06T02:36:09.062087Z", "action": 5, "target": "我们还可以使用距离测试作为连接键，来创建汇总的“半径内的所有项目”查询。让我们使用距离查询来探索纽约的种族地理。", "id": 1956726, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/1956726/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236796/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2024-05-06T02:35:46.320123Z", "action": 5, "target": "``JOIN``子句组合了两个 ``FROM`` 项。默认情况下，我们使用 ``INNER JOIN``，但还有四种其他类型的连接。有关更多信息，请参阅 PostgreSQL 文档中的 `join_type <http://www.postgresql.org/docs/9.1/interactive/sql-select.html#SQL-FROM>` 定义。", "id": 1956725, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/1956725/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236795/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2024-05-06T02:31:34.589931Z", "action": 5, "target": "对最终数字进行一些算术和格式化（例如 ``GROUP BY``, ``ORDER BY``）后，我们的查询会输出百分比。", "id": 1956724, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/1956724/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236794/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2024-05-06T02:31:10.336742Z", "action": 5, "target": "其余行按邻域名称分组，并通过聚合函数将人口值输入 :command:`Sum()` 。", "id": 1956723, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/1956723/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236793/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2024-05-06T02:30:30.191639Z", "action": 5, "target": "该``WHERE``子句将我们的虚拟表过滤为仅曼哈顿中的行。", "id": 1956722, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/1956722/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236792/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2024-05-06T02:30:03.384945Z", "action": 5, "target": "该``JOIN``子句创建一个虚拟表，其中包括邻域表和人口普查表中的列。", "id": 1956721, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/1956721/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236791/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2024-05-06T02:29:21.004106Z", "action": 5, "target": "这里发生了什么？理论上（实际的评估顺序是由数据库在幕后优化的），发生的情况如下：", "id": 1956720, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/1956720/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236790/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2024-05-06T02:28:36.471360Z", "action": 5, "target": "例如：**“曼哈顿社区的人口和种族构成是多少？”**这里我们有一个问题，将人口普查中的人口信息与社区边界相结合，并仅限于曼哈顿的一个行政区。", "id": 1956719, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/1956719/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236788/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2024-05-06T02:27:14.151149Z", "action": 5, "target": "连接并总结", "id": 1956718, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/1956718/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236789/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2024-05-06T02:26:05.060528Z", "action": 5, "target": "JOIN 与 GROUP BY 的组合提供了通常在 GIS 系统中完成的分析类型。", "id": 1956717, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/1956717/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236787/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2024-05-06T02:21:30.217044Z", "action": 5, "target": "我们本可以将每个地铁站与其所在的社区连接起来，但在这种情况下，我们只需要一个地铁站的信息。任何在两个表之间提供真/假关系的函数都可用于驱动空间联接，但最常用的函数是: :command:`ST_Intersects`, :command:`ST_Contains`, and :command:`ST_DWithin`.", "id": 1956716, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/1956716/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236786/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2024-05-06T02:17:35.086481Z", "action": 5, "target": "使用空间连接，我们可以一步回答这个问题，检索有关地铁站及其所在社区的信息：", "id": 1956715, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/1956715/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236785/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2024-05-06T02:16:22.941862Z", "action": 5, "target": "在上一节中，我们使用两步过程探索了空间关系：首先，我们提取“Broad St”的地铁站点；然后，我们利用这一点提出了进一步的问题，例如“‘Broad St’车站位于哪个社区？”", "id": 1956714, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/1956714/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236784/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2024-05-06T02:15:04.302036Z", "action": 5, "target": "空间连接是空间数据库的基础.它们允许您通过使用空间关系作为连接键来组合来自不同表的信息。我们所认为的“标准 GIS 分析”的大部分内容都可以表示为空间连接。", "id": 1956713, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/1956713/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236783/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2024-05-06T01:58:42.775010Z", "action": 5, "target": "空间连接", "id": 1956712, "action_name": "Translation added", "url": "https://weblate.osgeo.org/api/changes/1956712/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236783/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "author": "https://weblate.osgeo.org/api/users/xinbo/?format=api", "timestamp": "2024-05-06T01:58:42.772783Z", "action": 45, "target": "", "id": 1956711, "action_name": "Contributor joined", "url": "https://weblate.osgeo.org/api/changes/1956711/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236817/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/mt:weblate-translation-memory/?format=api", "author": "https://weblate.osgeo.org/api/users/mt:weblate-translation-memory/?format=api", "timestamp": "2024-02-26T05:10:40.859247Z", "action": 4, "target": "`sum(expression) <http://www.postgresql.org/docs/current/static/functions-aggregate.html#FUNCTIONS-AGGREGATE-TABLE>`_: 返回一组记录中记录总和的PostgreSQL聚合函数。", "id": 1948845, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1948845/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236814/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/mt:weblate/?format=api", "author": "https://weblate.osgeo.org/api/users/mt:weblate/?format=api", "timestamp": "2024-02-26T05:10:40.849447Z", "action": 4, "target": "`ST_Intersects(geometry_a, geometry_b) <http://postgis.net/docs/ST_Intersects.html>`_：若 Geometries 对象或 Geography 对象存在 “空间相交”，即有任意部分重叠，返回 TRUE，否则返回 FALSE.", "id": 1948844, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1948844/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236811/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/mt:weblate-translation-memory/?format=api", "author": "https://weblate.osgeo.org/api/users/mt:weblate-translation-memory/?format=api", "timestamp": "2024-02-26T05:10:40.747917Z", "action": 4, "target": "函数列表", "id": 1948843, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1948843/?format=api" }, { "unit": null, "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": "https://weblate.osgeo.org/api/users/zcw5/?format=api", "author": "https://weblate.osgeo.org/api/users/zcw5/?format=api", "timestamp": "2024-02-26T05:09:25.189010Z", "action": 0, "target": "", "id": 1948829, "action_name": "Resource updated", "url": "https://weblate.osgeo.org/api/changes/1948829/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/2236817/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/joins/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/joins/zh_Hans/?format=api", "user": null, "author": null, "timestamp": "2024-02-26T05:09:25.188956Z", "action": 59, "target": "", "id": 1948828, "action_name": "String updated in the repository", "url": "https://weblate.osgeo.org/api/changes/1948828/?format=api" } ] }