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 2 days ago
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/ko_KR/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 13% 24 7% 327 7% 2,332
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

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 181 changes 0 changes
Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May

Quick numbers

4,141
Hosted words
179
Hosted strings
91%
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_raster_dataman — Korean

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

Resource update

postgis_branch_32 / using_raster_dataman — Korean

File doc/po/ko_KR/using_raster_dataman.xml.po was added. a year ago
User avatar None

String updated in the repository

postgis_branch_32 / using_raster_dataman — Korean

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);
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);
-- 다음과 비슷하게 출력될 것입니다. --
oid | num_bytes
---------+-----------
2630819 | 74860

-- 그 다음 oid를 기억하고 c:/test.png를 사용자의
-- 로컬 시스템 파일 경로 위치로 대체하십시오.
\lo_export 2630819 'C:/temp/aerial_samp.png'

-- 이 구문은 DB에 있는 대용량 객체 저장소에서 파일을 삭제합니다.
SELECT lo_unlink(2630819);
a year ago
User avatar None

String updated in the repository

postgis_branch_32 / using_raster_dataman — Korean

Unlike the python approach, this approach creates the file on your local computer.
파이썬 접근법과는 달리, 이 접근법은 사용자의 로컬 시스템에 파일을 생성합니다.
a year ago
User avatar None

String updated in the repository

postgis_branch_32 / using_raster_dataman — Korean

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.
안타깝게도 PSQL은 바이너리 출력 작업에 쉽게 사용할 수 있는 내장 기능성을 가지고 있지 않습니다. PostgreSQL의 레거시 대용량 객체 지원에 어느 정도 숟가락만 얹는 꼼수에 가깝습니다. PSQL을 사용하려면, 먼저 사용자 데이터베이스에 연결된 사용자의 PSQL 명령행을 실행하십시오.
a year ago
User avatar None

String updated in the repository

postgis_branch_32 / using_raster_dataman — Korean

Outputting Rasters with PSQL
PSQL을 이용해서 래스터 출력하기
a year ago
User avatar None

String updated in the repository

postgis_branch_32 / using_raster_dataman — Korean

--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),j*5, 'quad_segs=2'),150*j, 150*j, '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
-- PostgreSQL 서버에 여러 크기로 이미지 5장을 작성합니다.
-- PostgreSQL 데몬(daemon) 계정이 폴더의 쓰기 권한을 가져야 한다는 점에 주의하십시오.
-- 이 쿼리는 생성된 파일명을 화면에 출력합니다;
SELECT write_file(ST_AsPNG(
ST_AsRaster(ST_Buffer(ST_Point(1,5),j*5, 'quad_segs=2'),150*j, 150*j, '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
User avatar None

String updated in the repository

postgis_branch_32 / using_raster_dataman — Korean

<![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;]]>
<![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
User avatar None

String updated in the repository

postgis_branch_32 / using_raster_dataman — Korean

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.
서버 디렉터리에 각 레코드를 파일로 생성하는 PLPython 저장 함수입니다. PLPython을 설치해야 합니다. PLPythonu와 PLPythonu3u 모두 잘 작동할 것입니다.
a year ago
User avatar None

String updated in the repository

postgis_branch_32 / using_raster_dataman — Korean

Use PLPython to dump out images via SQL
PLPython을 이용해서 SQL을 통해 이미지를 덤프하기
a year ago
Browse all translation changes