postgis_branch_32/using_raster_dataman — Portuguese (Brazil) @ OSGeo Weblate

Translation status

179	Strings		91%	Browse Translate
4,141	Words		87%	Browse Translate

Strings status

179	All strings — 4,141 words	Browse Translate Zen
164	Translated strings — 3,630 words	Browse Translate Zen
15	Unfinished strings — 511 words	Browse Translate Zen
15	Untranslated strings — 511 words	Browse Translate Zen
15	Unfinished strings without suggestions — 511 words	Browse Translate Zen
56	Strings with any failing checks — 1,198 words	Browse Translate Zen
56	Translated strings with any failing checks — 1,198 words	Browse Translate Zen
9	Failing check: Unchanged translation — 19 words	Browse Translate Zen
39	Failing check: Trailing space — 865 words	Browse Translate Zen
13	Failing check: Double space — 483 words	Browse Translate Zen
30	Failing check: Mismatched full stop — 787 words	Browse Translate Zen
2	Failing check: Mismatched colon — 20 words	Browse Translate Zen
1	Failing check: XML markup — 6 words	Browse Translate Zen

Other components

Component	Translated	Unfinished	Unfinished words	Unfinished characters	Untranslated	Checks	Suggestions	Comments
extras	0%	3	45	318	3	0	0	0

reference_relationship	0%	273	5,065	46,644	273	6	36	0

reference_troubleshooting	0%	26	407	3,121	26	2	21	0

reference_overlay	0%	143	2,782	24,240	143	3	14	0

reference_version	0%	88	709	8,318	88	1	5	0

database_tuning	0%	33	543	3,893	33	0	0	0

reference_cluster	0%	55	1,131	9,962	55	1	5	0

reference_bbox	0%	117	1,991	19,058	117	7	30	0

using_postgis_query	0%	109	2,146	16,760	109	0	0	0

reporting	0%	20	360	2,524	20	0	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 yesterday
Weblate repository	`https://weblate.osgeo.org/git/postgis_branch_32/postgis/`
File mask	`doc/po/*/using_raster_dataman.xml.po`
Translation file	Download `doc/po/pt_BR/using_raster_dataman.xml.po`
Last change	None
Last author	None

String statistics

	Strings percent	Hosted strings	Words percent	Hosted words	Characters percent	Hosted characters
Total		179		4,141		32,259
Translated	91%	164	87%	3,630	88%	28,404
Needs editing	0%	0	0%	0	0%	0
Read-only	0%	0	0%	0	0%	0
Failing checks	31%	56	28%	1,198	25%	8,181
Strings with suggestions	0%	0	0%	0	0%	0
Untranslated strings	8%	15	12%	511	11%	3,855

Last 12 months Previous

Activity in last 12 months


May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Jan	Feb	Mar	Apr

Quick numbers

4,141

Hosted words

179

Hosted strings

91%

Translated

Contributors

and previous 30 days

Trends of last 30 days

—

Hosted words

—

Hosted strings

—

Translated

—

Contributors

—

None New strings to translate postgis_branch_32 / using_raster_dataman — Portuguese (Brazil)	15 new strings to translate appeared to the translation. a year ago
None Resource update postgis_branch_32 / using_raster_dataman — Portuguese (Brazil)	File `doc/po/pt_BR/using_raster_dataman.xml.po` was added. a year ago
None String updated in the repository postgis_branch_32 / using_raster_dataman — Portuguese (Brazil)	English SELECT oid, lowrite(lo_open(oid, 131072), png) As num_bytes FROM ( VALUES (lo_create(0), ST_AsPNG( (SELECT rast FROM aerials.boston WHERE rid=1) ) ) ) As v(oid,png); -- you'll get an output something like -- oid \| num_bytes ---------+----------- 2630819 \| 74860 -- next note the oid and do this replacing the c:/test.png to file path location -- on your local computer \lo_export 2630819 'C:/temp/aerial_samp.png' -- this deletes the file from large object storage on db SELECT lo_unlink(2630819); Portuguese (Brazil) 517 characters edited Current translation Translated SELECT oid, lowrite(lo_open(oid, 131072), png) As num_bytes FROM ( VALUES (lo_create(0), ST_AsPNG( (SELECT rast FROM aerials.boston WHERE rid=1) ) ) ) As v(oid,png); -- you'll get an output something like -- oid \| num_bytes ---------+----------- 2630819 \| 74860 -- next note the oid and do this replacing the c:/test.png to file path location -- on your local computer \lo_export 2630819 'C:/temp/aerial_samp.png' -- this deletes the file from large object storage on db SELECT lo_unlink(2630819); a year ago
None String updated in the repository postgis_branch_32 / using_raster_dataman — Portuguese (Brazil)	English Unlike the python approach, this approach creates the file on your local computer. Portuguese (Brazil) 77 characters edited Current translation Translated Diferente da aproximação python, esta cria o arquivo no seu computador local. a year ago
None String updated in the repository postgis_branch_32 / using_raster_dataman — Portuguese (Brazil)	English Sadly PSQL doesn't have easy to use built-in functionality for outputting binaries. This is a bit of a hack that piggy backs on PostgreSQL somewhat legacy large object support. To use first launch your psql commandline connected to your database. Portuguese (Brazil) 254 characters edited Current translation Translated Infelizmente o PSQL não tem facilidade em usar funcionalidade embutida para binários gerados. Isto é um pequeno hack no legado PostgreSQL de suporte de objetos grandes. Para usar, primeiro lance sua linha de comando psql conectada no seu banco de dados. a year ago
None String updated in the repository postgis_branch_32 / using_raster_dataman — Portuguese (Brazil)	English Outputting Rasters with PSQL Portuguese (Brazil) 25 characters edited Current translation Translated Rasters de saída com PSQL a year ago
None String updated in the repository postgis_branch_32 / using_raster_dataman — Portuguese (Brazil)	English --write out 5 images to the PostgreSQL server in varying sizes -- note the postgresql daemon account needs to have write access to folder -- this echos back the file names created; SELECT write_file(ST_AsPNG( ST_AsRaster(ST_Buffer(ST_Point(1,5),j5, 'quad_segs=2'),150j, 150j, '8BUI',100)), 'C:/temp/slices'\|\| j \|\| '.png') FROM generate_series(1,5) As j; write_file --------------------- C:/temp/slices1.png C:/temp/slices2.png C:/temp/slices3.png C:/temp/slices4.png C:/temp/slices5.png Portuguese (Brazil) 527 characters edited Current translation Translated --write out 5 images to the PostgreSQL server in varying sizes -- note the postgresql daemon account needs to have write access to folder -- this echos back the file names created; SELECT write_file(ST_AsPNG( ST_AsRaster(ST_Buffer(ST_Point(1,5),j5, 'quad_segs=2'),150j, 150j, '8BUI',100)), 'C:/temp/slices'\|\| j \|\| '.png') FROM generate_series(1,5) As j; write_file --------------------- C:/temp/slices1.png C:/temp/slices2.png C:/temp/slices3.png C:/temp/slices4.png C:/temp/slices5.png a year ago
None String updated in the repository postgis_branch_32 / using_raster_dataman — Portuguese (Brazil)	English <![CDATA[CREATE OR REPLACE FUNCTION write_file (param_bytes bytea, param_filepath text) RETURNS text AS $$ f = open(param_filepath, 'wb+') f.write(param_bytes) return param_filepath $$ LANGUAGE plpythonu;]]> Portuguese (Brazil) 207 characters edited Current translation Translated <![CDATA[CREATE OR REPLACE FUNCTION write_file (param_bytes bytea, param_filepath text) RETURNS text AS $$ f = open(param_filepath, 'wb+') f.write(param_bytes) return param_filepath $$ LANGUAGE plpythonu;]]> a year ago
None String updated in the repository postgis_branch_32 / using_raster_dataman — Portuguese (Brazil)	English This is a plpython stored function that creates a file in the server directory for each record. Requires you have plpython installed. Should work fine with both plpythonu and plpython3u. Portuguese (Brazil) 185 characters edited Current translation Translated Esta é uma função plpython armazenada que cria um arquivo no diretório do servidor para cada relato. Requer que tenha instalado plpython. Deve funcionar bem com plpythonu e plpython3u. a year ago
None String updated in the repository postgis_branch_32 / using_raster_dataman — Portuguese (Brazil)	English Use PLPython to dump out images via SQL Portuguese (Brazil) 41 characters edited Current translation Translated Use PLPython para excluir imagens via SQL a year ago

Browse all translation changes

Quick downloads

179	File in original format as translated in the repository	gettext PO file
179	All strings, converted files enriched with comments; suitable for offline translation	CSV	gettext MO	gettext PO	TBX	TMX	XLIFF 1.1 with gettext extensions	XLIFF 1.1	XLSX
15	Unfinished strings, converted files enriched with comments; suitable for offline translation	CSV	gettext MO	gettext PO	TBX	TMX	XLIFF 1.1 with gettext extensions	XLIFF 1.1	XLSX

Customize download

Search

Advanced query builder

Query examples

Review strings changed by other users	`changed:>=2023-04-30 AND NOT changed_by:anonymous`	Add
Translated strings	`state:>=translated`	Add
Strings with comments	`has:comment`	Add
Strings with any failing checks	`has:check`	Add
Strings with suggestions from others	`has:suggestion AND NOT suggestion_author:anonymous`	Add
Approved strings with suggestions	`state:approved AND has:suggestion`	Add
All untranslated strings added the past month	`added:>=2023-04-30 AND state:<=needs-editing`	Add