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/pt_BR/using_postgis_query.xml.po
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 0% 0 0% 0 0% 0
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 100% 109 100% 2,146 100% 16,760
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 111 changes 0 changes
Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May

Quick numbers

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

Trends of last 30 days

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

New strings to translate

postgis_branch_32 / using_postgis_query — Portuguese (Brazil)

109 new strings to translate appeared to the translation. a year ago
User avatar None

Resource update

postgis_branch_32 / using_postgis_query — Portuguese (Brazil)

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

String updated in the repository

postgis_branch_32 / using_postgis_query — Portuguese (Brazil)

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 — Portuguese (Brazil)

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 — Portuguese (Brazil)

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 — Portuguese (Brazil)

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 — Portuguese (Brazil)

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 — Portuguese (Brazil)

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 — Portuguese (Brazil)

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 — Portuguese (Brazil)

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
Browse all translation changes