Source strings

109 Strings 100%
Browse Translate
2,146 Words 100%
This translation is being used as source strings within this component.

Strings status

109
All strings — 2,146 words Browse Translate Zen
109
Read-only strings — 2,146 words Browse Translate Zen
3
Strings with any failing checks — 84 words Browse Translate Zen
1
Failing check: Unpluralised — 32 words Browse Translate Zen
2
Failing check: Ellipsis — 52 words Browse Translate Zen

Other components

Component Translated Unfinished Unfinished words Unfinished characters Untranslated Checks Suggestions Comments
postgis This language is used for source strings. 0 0 0 0 3 0 0
reference_troubleshooting This language is used for source strings. This component is linked to the postgis_branch_32/postgis repository. 0 0 0 0 2 0 0
Glossary postgis_branch_32 This language is used for source strings. 0 0 0 0 0 0 0
extras_topology This language is used for source strings. This component is linked to the postgis_branch_32/postgis repository. 0 0 0 0 291 0 0
introduction This language is used for source strings. This component is linked to the postgis_branch_32/postgis repository. 0 0 0 0 31 0 0
reference_accessor This language is used for source strings. This component is linked to the postgis_branch_32/postgis repository. 0 0 0 0 307 0 0
reference_operator This language is used for source strings. This component is linked to the postgis_branch_32/postgis repository. 0 0 0 0 90 0 0
reference_lrs This language is used for source strings. This component is linked to the postgis_branch_32/postgis repository. 0 0 0 0 87 0 0
reference_transformation This language is used for source strings. This component is linked to the postgis_branch_32/postgis repository. 0 0 0 0 2 0 0
using_raster_dataman This language is used for source strings. This component is linked to the postgis_branch_32/postgis repository. 0 0 0 0 76 0 0
Browse all components

Overview

Project website postgis.net
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 stable-3.2
Last remote commit Push to 3.2.6dev milestone 6e2c5206d
Regina Obe authored a week ago
Weblate repository https://weblate.osgeo.org/git/postgis_branch_32/postgis/
File mask doc/po/*/using_postgis_query.xml.po
Translation file Download doc/po/templates/using_postgis_query.xml.pot
Last change None
Last author None

String statistics

Strings percent Hosted strings Words percent Hosted words Characters percent Hosted characters
Total 109 2,146 16,760
Translated 100% 109 100% 2,146 100% 16,760
Needs editing 0% 0 0% 0 0% 0
Read-only 100% 109 100% 2,146 100% 16,760
Failing checks 2% 3 3% 84 5% 953
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 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 0 changes 110 changes 0 changes
Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May

Quick numbers

2,146
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 None

Resource update

postgis_branch_32 / using_postgis_query — English

File doc/po/templates/using_postgis_query.xml.pot was added. a year ago
User avatar None

String updated in the repository

postgis_branch_32 / using_postgis_query — English

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

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

gid | name | area
-----+--------------+------------------
12 | SPALLUMCHEEN | 257374619.430216
(1 row)
a year ago
User avatar None

String updated in the repository

postgis_branch_32 / using_postgis_query — English

What is the largest municipality polygon that has a hole?
What is the largest municipality polygon that has a hole?
a year ago
User avatar None

String updated in the repository

postgis_branch_32 / using_postgis_query — English

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

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

kilometers
------------------
4.89151904172838
(1 row)
a year ago
User avatar None

String updated in the repository

postgis_branch_32 / using_postgis_query — English

What is the length in kilometers of "Douglas St" in Victoria?
What is the length in kilometers of "Douglas St" in Victoria?
a year ago
User avatar None

String updated in the repository

postgis_branch_32 / using_postgis_query — English

CREATE TABLE pg_roads as
SELECT
ST_Intersection(r.the_geom, m.the_geom) AS intersection_geom,
ST_Length(r.the_geom) AS rd_orig_length,
r.*
FROM
bc_roads AS r,
bc_municipality AS m
WHERE
m.name = 'PRINCE GEORGE'
AND ST_Intersects(r.the_geom, m.the_geom);
CREATE TABLE pg_roads as
SELECT
ST_Intersection(r.the_geom, m.the_geom) AS intersection_geom,
ST_Length(r.the_geom) AS rd_orig_length,
r.*
FROM
bc_roads AS r,
bc_municipality AS m
WHERE
m.name = 'PRINCE GEORGE'
AND ST_Intersects(r.the_geom, m.the_geom);
a year ago
User avatar None

String updated in the repository

postgis_branch_32 / using_postgis_query — English

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 actually creates new geometries. An overlay is like a turbo-charged spatial join, and is useful for more exact analysis work:
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 actually creates new geometries. An overlay is like a turbo-charged spatial join, and is useful for more exact analysis work:
a year ago
User avatar None

String updated in the repository

postgis_branch_32 / using_postgis_query — English

Create a new table with all the roads within the city of Prince George.
Create a new table with all the roads within the city of Prince George.
a year ago
User avatar None

String updated in the repository

postgis_branch_32 / using_postgis_query — English

This query takes a while, because every road in the table is summarized into the final result (about 250K roads for our particular example table). For smaller overlays (several thousand records on several hundred) the response can be very fast.
This query takes a while, because every road in the table is summarized into the final result (about 250K roads for our particular example table). For smaller overlays (several thousand records on several hundred) the response can be very fast.
a year ago
User avatar None

String updated in the repository

postgis_branch_32 / using_postgis_query — English

SELECT
m.name,
sum(ST_Length(r.the_geom))/1000 as roads_km
FROM
bc_roads AS r,
bc_municipality AS m
WHERE
ST_Contains(m.the_geom, r.the_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.the_geom))/1000 as roads_km
FROM
bc_roads AS r,
bc_municipality AS m
WHERE
ST_Contains(m.the_geom, r.the_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
...
a year ago
Browse all translation changes