Translation status

109 Strings 100%
Browse Translate
2,128 Words 100%

Strings status

109
All strings — 2,128 words Browse Translate Zen
109
Translated strings — 2,128 words Browse Translate Zen
109
Strings waiting for review — 2,128 words Browse Translate Zen
30
Translated strings with dismissed checks — 329 words Browse Translate Zen

Other components

Component Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
reference_transformation.xml This component is linked to the postgis/postgis repository. 0 0 0 0 0 0 0
faq.xml This component is linked to the postgis/postgis repository. 0 0 0 0 0 0 0
reference_management.xml This component is linked to the postgis/postgis repository. 0 0 0 0 0 0 0
database_tuning.xml This component is linked to the postgis/postgis repository. 0 0 0 0 0 0 0
faq_raster.xml This component is linked to the postgis/postgis repository. 0 0 0 0 0 0 0
extras.xml This component is linked to the postgis/postgis repository. 0 0 0 0 0 0 0
Glossary Glossary 0 0 0 0 0 0 0
reference_overlay.xml This component is linked to the postgis/postgis repository. 0 0 0 0 0 0 0
release_notes.xml This component is linked to the postgis/postgis repository. 0 0 0 0 0 0 0
reporting.xml This component is linked to the postgis/postgis repository. 0 0 0 0 0 0 0
Browse all components

Overview

Project website postgis.net
Project maintainers User avatar komzpa User avatar cvvergara User avatar strk User avatar robe
Translation process
  • Translations can be made directly.
  • Translation suggestions can be made.
  • Any authenticated user can contribute.
  • The translation uses bilingual files.
Source code repository https://git.osgeo.org/gitea/postgis/postgis.git
Repository branch master
Last remote commit Have skip signature generator scan full postgis upgrade script 5e05bc3e7
Sandro Santilli authored 16 hours ago
Last commit in Weblate Translated reference_coverage using Weblate (French) af45bca00
Vincent Bre authored 3 weeks ago
Weblate repository https://weblate.osgeo.org/git/postgis/postgis/
File mask doc/po/*/using_postgis_query.xml.po
Translation file Download doc/po/ja/using_postgis_query.xml.po
Last change Sept. 12, 2022, 5:46 a.m.
Last author Teramoto Ikuhiro

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 109 2,128 16,517
Approved 0% 0 0% 0 0% 0
Waiting for review 100% 109 100% 2,128 100% 16,517
Translated 100% 109 100% 2,128 100% 16,517
Needs editing 0% 0 0% 0 0% 0
Read-only 0% 0 0% 0 0% 0
Failing checks 0% 0 0% 0 0% 0
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

0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 103 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 2 changes 0 changes 0 changes 0 changes 0 changes 0 changes 9 changes 0 changes 20 changes 0 changes
Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May

Quick numbers

2,128
Hosted words
109
Hosted strings
100%
Translated
0
Contributors
and previous 30 days

Trends of last 30 days

—
Hosted words
—
—
Hosted strings
—
—
Translated
—
—
Contributors
—
User avatar yellow73

Translation changed

postgis / using_postgis_query.xml — Japanese

Create a new table with all the roads within the city of Prince George.
プリンスジョージ市内の全ての道路からなるテーブルを作るります。
8 months ago
User avatar yellow73

Translation uploaded

postgis / using_postgis_query.xml — Japanese

SELECT gid, name, ST_Area(geom) AS area
FROM bc_municipality
WHERE ST_NRings(geom) > 1
ORDER BY area DESC LIMIT 1;

gid | name | area
-----+--------------+------------------
12 | SPALLUMCHEEN | 257374619.430216
SELECT gid, name, ST_Area(geom) AS area
FROM bc_municipality
WHERE ST_NRings(geom) > 1
ORDER BY area DESC LIMIT 1;

gid | name | area
-----+--------------+------------------
12 | SPALLUMCHEEN | 257374619.430216
9 months ago
User avatar yellow73

Translation uploaded

postgis / using_postgis_query.xml — Japanese

What is the largest municipality polygon that has a hole?
穴を持つ自治体ポリゴンのうち最も大きいのはどれでしょう?
9 months ago
User avatar yellow73

Translation uploaded

postgis / using_postgis_query.xml — Japanese

SELECT
sum(ST_Length(r.geom))/1000 AS kilometers
FROM bc_roads r
JOIN bc_municipality m
ON ST_Intersects(m.geom, r.geom
WHERE
r.name = 'Douglas St'
AND m.name = 'VICTORIA';

kilometers
------------------
4.89151904172838
SELECT
sum(ST_Length(r.geom))/1000 AS kilometers
FROM bc_roads r
JOIN bc_municipality m
ON ST_Intersects(m.geom, r.geom
WHERE
r.name = 'Douglas St'
AND m.name = 'VICTORIA';

kilometers
------------------
4.89151904172838
9 months ago
User avatar yellow73

Translation uploaded

postgis / using_postgis_query.xml — Japanese

What is the length in kilometers of "Douglas St" in Victoria?
ビクトリア州の「ダグラス通り」の長さはkm表記でいくらになるでしょう?
9 months ago
User avatar yellow73

Translation uploaded

postgis / using_postgis_query.xml — Japanese

CREATE TABLE pg_roads as
SELECT
ST_Intersection(r.geom, m.geom) AS intersection_geom,
ST_Length(r.geom) AS rd_orig_length,
r.*
FROM bc_roads AS r
JOIN bc_municipality AS m
ON ST_Intersects(r.geom, m.geom)
WHERE
m.name = 'PRINCE GEORGE';
CREATE TABLE pg_roads as
SELECT
ST_Intersection(r.geom, m.geom) AS intersection_geom,
ST_Length(r.geom) AS rd_orig_length,
r.*
FROM bc_roads AS r
JOIN bc_municipality AS m
ON ST_Intersects(r.geom, m.geom)
WHERE
m.name = 'PRINCE GEORGE';
9 months ago
User avatar yellow73

Translation uploaded

postgis / using_postgis_query.xml — Japanese

This is an example of an "overlay", which takes in two tables and outputs a new table that consists of spatially clipped or cut resultants. Unlike the "spatial join" demonstrated above, this query creates new geometries. An overlay is like a turbo-charged spatial join, and is useful for more exact analysis work:
これは「オーバレイ」の例です。つまり、二つのテーブルを取得して、空間的に切り取られた結果からなる新しいテーブルを出力します。上で示した「空間結合」と違い、このクエリは実際に新しいジオメトリを生成します。生成されたオーバレイはターボのかかった空間結合みたいなもので、より確かな解析作業に便利です。
9 months ago
User avatar yellow73

Translation uploaded

postgis / using_postgis_query.xml — Japanese

Create a new table with all the roads within the city of Prince George.
プリンスジョージ市内の全ての道路からなるテーブルを作る
9 months ago
User avatar yellow73

Translation uploaded

postgis / using_postgis_query.xml — Japanese

This query takes a while, because every road in the table is summarized into the final result (about 250K roads for the example table). For smaller datsets (several thousand records on several hundred) the response can be very fast.
このクエリは、テーブル内の全ての道路の合計を最終結果 (この例での話ですが約250Kmの道です)にまとめられるので、少し時間がかかります。より小さいオーバレイ (数百の道路で数千のレコード)の場合、応答はもっと早くなりえます。
9 months ago
User avatar yellow73

Translation uploaded

postgis / using_postgis_query.xml — Japanese

SELECT
m.name,
sum(ST_Length(r.geom))/1000 as roads_km
FROM bc_roads AS r
JOIN bc_municipality AS m
ON ST_Contains(m.geom, r.geom)
GROUP BY m.name
ORDER BY roads_km;

name | roads_km
----------------------------+------------------
SURREY | 1539.47553551242
VANCOUVER | 1450.33093486576
LANGLEY DISTRICT | 833.793392535662
BURNABY | 773.769091404338
PRINCE GEORGE | 694.37554369147
...
SELECT
m.name,
sum(ST_Length(r.geom))/1000 as roads_km
FROM bc_roads AS r
JOIN bc_municipality AS m
ON ST_Contains(m.geom, r.geom)
GROUP BY m.name
ORDER BY roads_km;

name | roads_km
----------------------------+------------------
SURREY | 1539.47553551242
VANCOUVER | 1450.33093486576
LANGLEY DISTRICT | 833.793392535662
BURNABY | 773.769091404338
PRINCE GEORGE | 694.37554369147
...
9 months ago
Browse all translation changes