# SOME DESCRIPTIVE TITLE.
# FIRST AUTHOR <EMAIL@ADDRESS>, YEAR.
#
#, fuzzy
msgid ""
msgstr ""
"Project-Id-Version: PACKAGE VERSION\n"
"Report-Msgid-Bugs-To: http://bugs.kde.org\n"
"POT-Creation-Date: 2017-01-28 07:03+0000\n"
"PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n"
"Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"
"Language-Team: LANGUAGE <kde-i18n-doc@kde.org>\n"
"MIME-Version: 1.0\n"
"Content-Type: text/plain; charset=UTF-8\n"
"Content-Transfer-Encoding: 8bit\n"

#. Tag: title
#: using_raster_dataman.xml:3
#, no-c-format
msgid "Raster Data Management, Queries, and Applications"
msgstr ""

#. Tag: title
#: using_raster_dataman.xml:5
#, no-c-format
msgid "Loading and Creating Rasters"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:6
#, no-c-format
msgid ""
"For most use cases, you will create PostGIS rasters by loading existing "
"raster files using the packaged <varname>raster2pgsql</varname> raster "
"loader."
msgstr ""

#. Tag: title
#: using_raster_dataman.xml:9
#, no-c-format
msgid "Using raster2pgsql to load rasters"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:10
#, no-c-format
msgid ""
"The <varname>raster2pgsql</varname> is a raster loader executable that loads "
"GDAL supported raster formats into sql suitable for loading into a PostGIS "
"raster table. It is capable of loading folders of raster files as well as "
"creating overviews of rasters."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:13
#, no-c-format
msgid ""
"Since the raster2pgsql is compiled as part of PostGIS most often (unless you "
"compile your own GDAL library), the raster types supported by the executable "
"will be the same as those compiled in the GDAL dependency library. To get a "
"list of raster types your particular raster2pgsql supports use the <varname>-"
"G</varname> switch. These should be the same as those provided by your "
"PostGIS install documented here <xref linkend=\"RT_ST_GDALDrivers\"/> if you "
"are using the same gdal library for both."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:16
#, no-c-format
msgid ""
"The older version of this tool was a python script. The executable has "
"replaced the python script. If you still find the need for the Python script "
"Examples of the python one can be found at <ulink url=\"http://trac.osgeo."
"org/gdal/wiki/frmts_wtkraster.html\">GDAL PostGIS Raster Driver Usage</"
"ulink>. Please note that the raster2pgsql python script may not work with "
"future versions of PostGIS raster and is no longer supported."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:21
#, no-c-format
msgid ""
"When creating overviews of a specific factor from a set of rasters that are "
"aligned, it is possible for the overviews to not align. Visit <ulink url="
"\"http://trac.osgeo.org/postgis/ticket/1764\">http://trac.osgeo.org/postgis/"
"ticket/1764</ulink> for an example where the overviews do not align."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:23
#, no-c-format
msgid "EXAMPLE USAGE:"
msgstr ""

#. Tag: programlisting
#: using_raster_dataman.xml:24
#, no-c-format
msgid ""
"raster2pgsql <varname>raster_options_go_here</varname> <varname>raster_file</"
"varname> <varname>someschema</varname>.<varname>sometable</varname> &gt; out."
"sql"
msgstr ""

#. Tag: term
#: using_raster_dataman.xml:28
#, no-c-format
msgid "<term>-?</term>"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:30
#, no-c-format
msgid ""
"Display help screen. Help will also display if you don't pass in any "
"arguments."
msgstr ""

#. Tag: term
#: using_raster_dataman.xml:37
#, no-c-format
msgid "<term>-G</term>"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:39
#, no-c-format
msgid "Print the supported raster formats."
msgstr ""

#. Tag: term
#: using_raster_dataman.xml:46
#, no-c-format
msgid "(c|a|d|p) These are mutually exclusive options:"
msgstr ""

#. Tag: term
#: using_raster_dataman.xml:51
#, no-c-format
msgid "<term>-c</term>"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:53
#, no-c-format
msgid ""
"Create new table and populate it with raster(s), <emphasis>this is the "
"default mode</emphasis>"
msgstr ""

#. Tag: term
#: using_raster_dataman.xml:60
#, no-c-format
msgid "<term>-a</term>"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:62
#, no-c-format
msgid "Append raster(s) to an existing table."
msgstr ""

#. Tag: term
#: using_raster_dataman.xml:69
#, no-c-format
msgid "<term>-d</term>"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:71
#, no-c-format
msgid "Drop table, create new one and populate it with raster(s)"
msgstr ""

#. Tag: term
#: using_raster_dataman.xml:78
#, no-c-format
msgid "<term>-p</term>"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:80
#, no-c-format
msgid "Prepare mode, only create the table."
msgstr ""

#. Tag: term
#: using_raster_dataman.xml:91
#, no-c-format
msgid ""
"Raster processing: Applying constraints for proper registering in raster "
"catalogs"
msgstr ""

#. Tag: term
#: using_raster_dataman.xml:96
#, no-c-format
msgid "<term>-C</term>"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:98
#, no-c-format
msgid ""
"Apply raster constraints -- srid, pixelsize etc. to ensure raster is "
"properly registered in <varname>raster_columns</varname> view."
msgstr ""

#. Tag: term
#: using_raster_dataman.xml:104
#, no-c-format
msgid "<term>-x</term>"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:106
#, no-c-format
msgid ""
"Disable setting the max extent constraint. Only applied if -C flag is also "
"used."
msgstr ""

#. Tag: term
#: using_raster_dataman.xml:112
#, no-c-format
msgid "<term>-r</term>"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:114
#, no-c-format
msgid ""
"Set the constraints (spatially unique and coverage tile) for regular "
"blocking. Only applied if -C flag is also used."
msgstr ""

#. Tag: term
#: using_raster_dataman.xml:125
#, no-c-format
msgid ""
"Raster processing: Optional parameters used to manipulate input raster "
"dataset"
msgstr ""

#. Tag: term
#: using_raster_dataman.xml:130
#, no-c-format
msgid "-s &lt;SRID&gt;"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:132
#, no-c-format
msgid ""
"Assign output raster with specified SRID. If not provided or is zero, "
"raster's metadata will be checked to determine an appropriate SRID."
msgstr ""

#. Tag: term
#: using_raster_dataman.xml:139
#, no-c-format
msgid "-b BAND"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:141
#, no-c-format
msgid ""
"Index (1-based) of band to extract from raster. For more than one band "
"index, separate with comma (,). If unspecified, all bands of raster will be "
"extracted."
msgstr ""

#. Tag: term
#: using_raster_dataman.xml:149
#, no-c-format
msgid "-t TILE_SIZE"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:151
#, no-c-format
msgid ""
"Cut raster into tiles to be inserted one per table row. <varname>TILE_SIZE</"
"varname> is expressed as WIDTHxHEIGHT or set to the value \"auto\" to allow "
"the loader to compute an appropriate tile size using the first raster and "
"applied to all rasters."
msgstr ""

#. Tag: term
#: using_raster_dataman.xml:158
#, no-c-format
msgid "<term>-P</term>"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:160
#, no-c-format
msgid ""
"Pad right-most and bottom-most tiles to guarantee that all tiles have the "
"same width and height."
msgstr ""

#. Tag: term
#: using_raster_dataman.xml:170
#, no-c-format
msgid "-R, --register"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:172
#, no-c-format
msgid "Register the raster as a filesystem (out-db) raster."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:173
#, no-c-format
msgid ""
"Only the metadata of the raster and path location to the raster is stored in "
"the database (not the pixels)."
msgstr ""

#. Tag: term
#: using_raster_dataman.xml:178
#, no-c-format
msgid "-l <varname>OVERVIEW_FACTOR</varname>"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:179
#, no-c-format
msgid ""
"Create overview of the raster. For more than one factor, separate with "
"comma(,). Overview table name follows the pattern o_<varname>overview "
"factor</varname>_<varname>table</varname>, where <varname>overview factor</"
"varname> is a placeholder for numerical overview factor and <varname>table</"
"varname> is replaced with the base table name. Created overview is stored in "
"the database and is not affected by -R. Note that your generated sql file "
"will contain both the main table and overview tables."
msgstr ""

#. Tag: term
#: using_raster_dataman.xml:187
#, no-c-format
msgid "-N <varname>NODATA</varname>"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:189
#, no-c-format
msgid "NODATA value to use on bands without a NODATA value."
msgstr ""

#. Tag: term
#: using_raster_dataman.xml:201
#, no-c-format
msgid "Optional parameters used to manipulate database objects"
msgstr ""

#. Tag: term
#: using_raster_dataman.xml:206 using_raster_dataman.xml:235
#, no-c-format
msgid "<term>-q</term>"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:208
#, no-c-format
msgid "Wrap PostgreSQL identifiers in quotes"
msgstr ""

#. Tag: term
#: using_raster_dataman.xml:213
#, no-c-format
msgid "-f COLUMN"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:215
#, no-c-format
msgid "Specify name of destination raster column, default is 'rast'"
msgstr ""

#. Tag: term
#: using_raster_dataman.xml:221
#, no-c-format
msgid "<term>-F</term>"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:223
#, no-c-format
msgid "Add a column with the name of the file"
msgstr ""

#. Tag: term
#: using_raster_dataman.xml:228
#, no-c-format
msgid "-n COLUMN"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:230
#, no-c-format
msgid "Specify the name of the filename column. Implies -F."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:237
#, no-c-format
msgid "Wrap PostgreSQL identifiers in quotes."
msgstr ""

#. Tag: term
#: using_raster_dataman.xml:242
#, no-c-format
msgid "<term>-I</term>"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:244
#, no-c-format
msgid "Create a GiST index on the raster column."
msgstr ""

#. Tag: term
#: using_raster_dataman.xml:251
#, no-c-format
msgid "<term>-M</term>"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:253
#, no-c-format
msgid "Vacuum analyze the raster table."
msgstr ""

#. Tag: term
#: using_raster_dataman.xml:261
#, no-c-format
msgid "<term>-k</term>"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:263
#, no-c-format
msgid "Skip NODATA value checks for each raster band."
msgstr ""

#. Tag: term
#: using_raster_dataman.xml:271
#, no-c-format
msgid "-T <varname>tablespace</varname>"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:273
#, no-c-format
msgid ""
"Specify the tablespace for the new table. Note that indices (including the "
"primary key) will still use the default tablespace unless the -X flag is "
"also used."
msgstr ""

#. Tag: term
#: using_raster_dataman.xml:282
#, no-c-format
msgid "-X <varname>tablespace</varname>"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:284
#, no-c-format
msgid ""
"Specify the tablespace for the table's new index. This applies to the "
"primary key and the spatial index if the -I flag is used."
msgstr ""

#. Tag: term
#: using_raster_dataman.xml:293
#, no-c-format
msgid "<term>-Y</term>"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:295
#, no-c-format
msgid "Use copy statements instead of insert statements."
msgstr ""

#. Tag: term
#: using_raster_dataman.xml:306
#, no-c-format
msgid "<term>-e</term>"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:307
#, no-c-format
msgid "Execute each statement individually, do not use a transaction."
msgstr ""

#. Tag: term
#: using_raster_dataman.xml:311
#, no-c-format
msgid "-E ENDIAN"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:312
#, no-c-format
msgid ""
"Control endianness of generated binary output of raster; specify 0 for XDR "
"and 1 for NDR (default); only NDR output is supported now"
msgstr ""

#. Tag: term
#: using_raster_dataman.xml:316
#, no-c-format
msgid "-V <varname>version</varname>"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:317
#, no-c-format
msgid ""
"Specify version of output format. Default is 0. Only 0 is supported at this "
"time."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:320
#, no-c-format
msgid ""
"An example session using the loader to create an input file and uploading it "
"chunked in 100x100 tiles might look like this:"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:321
#, no-c-format
msgid ""
"You can leave the schema name out e.g <varname>demelevation</varname> "
"instead of <varname>public.demelevation</varname> and the raster table will "
"be created in the default schema of the database or user"
msgstr ""

#. Tag: programlisting
#: using_raster_dataman.xml:323
#, no-c-format
msgid ""
"raster2pgsql -s 4326 -I -C -M *.tif -F -t 100x100 public.demelevation > elev."
"sql\n"
"psql -d gisdb -f elev.sql"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:325
#, no-c-format
msgid "A conversion and upload can be done all in one step using UNIX pipes:"
msgstr ""

#. Tag: programlisting
#: using_raster_dataman.xml:327
#, no-c-format
msgid ""
"raster2pgsql -s 4326 -I -C -M *.tif -F -t 100x100 public.demelevation | psql "
"-d gisdb"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:329
#, no-c-format
msgid ""
"Load rasters Massachusetts state plane meters aerial tiles into a schema "
"called <varname>aerial</varname> and create a full view, 2 and 4 level "
"overview tables, use copy mode for inserting (no intermediary file just "
"straight to db), and -e don't force everything in a transaction (good if you "
"want to see data in tables right away without waiting). Break up the rasters "
"into 128x128 pixel tiles and apply raster constraints. Use copy mode instead "
"of table insert. (-F) Include a field called filename to hold the name of "
"the file the tiles were cut from."
msgstr ""

#. Tag: programlisting
#: using_raster_dataman.xml:331
#, no-c-format
msgid ""
"raster2pgsql -I -C -e -Y -F -s 26986 -t 128x128  -l 2,4 bostonaerials2008/*."
"jpg aerials.boston | psql -U postgres -d gisdb -h localhost -p 5432"
msgstr ""

#. Tag: programlisting
#: using_raster_dataman.xml:333
#, no-c-format
msgid ""
"--get a list of raster types supported:\n"
"raster2pgsql -G"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:335
#, no-c-format
msgid "The -G commands outputs a list something like"
msgstr ""

#. Tag: screen
#: using_raster_dataman.xml:336
#, no-c-format
msgid ""
"Available GDAL raster formats:\n"
"  Virtual Raster\n"
"  GeoTIFF\n"
"  National Imagery Transmission Format\n"
"  Raster Product Format TOC format\n"
"  ECRG TOC format\n"
"  Erdas Imagine Images (.img)\n"
"  CEOS SAR Image\n"
"  CEOS Image\n"
"  JAXA PALSAR Product Reader (Level 1.1/1.5)\n"
"  Ground-based SAR Applications Testbed File Format (.gff)\n"
"  ELAS\n"
"  Arc/Info Binary Grid\n"
"  Arc/Info ASCII Grid\n"
"  GRASS ASCII Grid\n"
"  SDTS Raster\n"
"  DTED Elevation Raster\n"
"  Portable Network Graphics\n"
"  JPEG JFIF\n"
"  In Memory Raster\n"
"  Japanese DEM (.mem)\n"
"  Graphics Interchange Format (.gif)\n"
"  Graphics Interchange Format (.gif)\n"
"  Envisat Image Format\n"
"  Maptech BSB Nautical Charts\n"
"  X11 PixMap Format\n"
"  MS Windows Device Independent Bitmap\n"
"  SPOT DIMAP\n"
"  AirSAR Polarimetric Image\n"
"  RadarSat 2 XML Product\n"
"  PCIDSK Database File\n"
"  PCRaster Raster File\n"
"  ILWIS Raster Map\n"
"  SGI Image File Format 1.0\n"
"  SRTMHGT File Format\n"
"  Leveller heightfield\n"
"  Terragen heightfield\n"
"  USGS Astrogeology ISIS cube (Version 3)\n"
"  USGS Astrogeology ISIS cube (Version 2)\n"
"  NASA Planetary Data System\n"
"  EarthWatch .TIL\n"
"  ERMapper .ers Labelled\n"
"  NOAA Polar Orbiter Level 1b Data Set\n"
"  FIT Image\n"
"  GRIdded Binary (.grb)\n"
"  Raster Matrix Format\n"
"  EUMETSAT Archive native (.nat)\n"
"  Idrisi Raster A.1\n"
"  Intergraph Raster\n"
"  Golden Software ASCII Grid (.grd)\n"
"  Golden Software Binary Grid (.grd)\n"
"  Golden Software 7 Binary Grid (.grd)\n"
"  COSAR Annotated Binary Matrix (TerraSAR-X)\n"
"  TerraSAR-X Product\n"
"  DRDC COASP SAR Processor Raster\n"
"  R Object Data Store\n"
"  Portable Pixmap Format (netpbm)\n"
"  USGS DOQ (Old Style)\n"
"  USGS DOQ (New Style)\n"
"  ENVI .hdr Labelled\n"
"  ESRI .hdr Labelled\n"
"  Generic Binary (.hdr Labelled)\n"
"  PCI .aux Labelled\n"
"  Vexcel MFF Raster\n"
"  Vexcel MFF2 (HKV) Raster\n"
"  Fuji BAS Scanner Image\n"
"  GSC Geogrid\n"
"  EOSAT FAST Format\n"
"  VTP .bt (Binary Terrain) 1.3 Format\n"
"  Erdas .LAN/.GIS\n"
"  Convair PolGASP\n"
"  Image Data and Analysis\n"
"  NLAPS Data Format\n"
"  Erdas Imagine Raw\n"
"  DIPEx\n"
"  FARSITE v.4 Landscape File (.lcp)\n"
"  NOAA Vertical Datum .GTX\n"
"  NADCON .los/.las Datum Grid Shift\n"
"  NTv2 Datum Grid Shift\n"
"  ACE2\n"
"  Snow Data Assimilation System\n"
"  Swedish Grid RIK (.rik)\n"
"  USGS Optional ASCII DEM (and CDED)\n"
"  GeoSoft Grid Exchange Format\n"
"  Northwood Numeric Grid Format .grd/.tab\n"
"  Northwood Classified Grid Format .grc/.tab\n"
"  ARC Digitized Raster Graphics\n"
"  Standard Raster Product (ASRP/USRP)\n"
"  Magellan topo (.blx)\n"
"  SAGA GIS Binary Grid (.sdat)\n"
"  Kml Super Overlay\n"
"  ASCII Gridded XYZ\n"
"  HF2/HFZ heightfield raster\n"
"  OziExplorer Image File\n"
"  USGS LULC Composite Theme Grid\n"
"  Arc/Info Export E00 GRID\n"
"  ZMap Plus Grid\n"
"  NOAA NGS Geoid Height Grids"
msgstr ""

#. Tag: title
#: using_raster_dataman.xml:339
#, no-c-format
msgid "Creating rasters using PostGIS raster functions"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:340
#, no-c-format
msgid ""
"On many occasions, you'll want to create rasters and raster tables right in "
"the database. There are a plethora of functions to do that. The general "
"steps to follow."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:342
#, no-c-format
msgid ""
"Create a table with a raster column to hold the new raster records which can "
"be accomplished with:"
msgstr ""

#. Tag: programlisting
#: using_raster_dataman.xml:343
#, no-c-format
msgid "CREATE TABLE myrasters(rid serial primary key, rast raster);"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:346
#, no-c-format
msgid ""
"There are many functions to help with that goal. If you are creating rasters "
"not as a derivative of other rasters, you will want to start with: <xref "
"linkend=\"RT_ST_MakeEmptyRaster\"/>, followed by <xref linkend="
"\"RT_ST_AddBand\"/>"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:348
#, no-c-format
msgid ""
"You can also create rasters from geometries. To achieve that you'll want to "
"use <xref linkend=\"RT_ST_AsRaster\"/> perhaps accompanied with other "
"functions such as <xref linkend=\"RT_ST_Union\"/> or <xref linkend="
"\"RT_ST_MapAlgebraFct2\"/> or any of the family of other map algebra "
"functions."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:350
#, no-c-format
msgid ""
"There are even many more options for creating new raster tables from "
"existing tables. For example you can create a raster table in a different "
"projection from an existing one using <xref linkend=\"RT_ST_Transform\"/>"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:352
#, no-c-format
msgid ""
"Once you are done populating your table initially, you'll want to create a "
"spatial index on the raster column with something like:"
msgstr ""

#. Tag: programlisting
#: using_raster_dataman.xml:353
#, no-c-format
msgid ""
"CREATE INDEX myrasters_rast_st_convexhull_idx ON myrasters USING "
"gist( ST_ConvexHull(rast) );"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:354
#, no-c-format
msgid ""
"Note the use of <xref linkend=\"RT_ST_ConvexHull\"/> since most raster "
"operators are based on the convex hull of the rasters."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:355
#, no-c-format
msgid ""
"Pre-2.0 versions of PostGIS raster were based on the envelop rather than the "
"convex hull. For the spatial indexes to work properly you'll need to drop "
"those and replace with convex hull based index."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:356
#, no-c-format
msgid ""
"Apply raster constraints using <xref linkend=\"RT_AddRasterConstraints\"/>"
msgstr ""

#. Tag: title
#: using_raster_dataman.xml:361
#, no-c-format
msgid "Raster Catalogs"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:362
#, no-c-format
msgid ""
"There are two raster catalog views that come packaged with PostGIS. Both "
"views utilize information embedded in the constraints of the raster tables. "
"As a result the catalog views are always consistent with the raster data in "
"the tables since the constraints are enforced."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:366
#, no-c-format
msgid ""
"<varname>raster_columns</varname> this view catalogs all the raster table "
"columns in your database."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:369
#, no-c-format
msgid ""
"<varname>raster_overviews</varname> this view catalogs all the raster table "
"columns in your database that serve as overviews for a finer grained table. "
"Tables of this type are generated when you use the <varname>-l</varname> "
"switch during load."
msgstr ""

#. Tag: title
#: using_raster_dataman.xml:373
#, no-c-format
msgid "Raster Columns Catalog"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:374
#, no-c-format
msgid ""
"The <varname>raster_columns</varname> is a catalog of all raster table "
"columns in your database that are of type raster. It is a view utilizing the "
"constraints on the tables so the information is always consistent even if "
"you restore one raster table from a backup of another database. The "
"following columns exist in the <varname>raster_columns</varname> catalog."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:376
#, no-c-format
msgid ""
"If you created your tables not with the loader or forgot to specify the "
"<varname>-C</varname> flag during load, you can enforce the constraints "
"after the fact using <xref linkend=\"RT_AddRasterConstraints\"/> so that the "
"<varname>raster_columns</varname> catalog registers the common information "
"about your raster tiles."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:381
#, no-c-format
msgid ""
"<varname>r_table_catalog</varname> The database the table is in. This will "
"always read the current database."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:384
#, no-c-format
msgid ""
"<varname>r_table_schema</varname> The database schema the raster table "
"belongs to."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:387
#, no-c-format
msgid "<varname>r_table_name</varname> raster table"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:390
#, no-c-format
msgid ""
"<varname>r_raster_column</varname> the column in the <varname>r_table_name</"
"varname> table that is of type raster. There is nothing in PostGIS "
"preventing you from having multiple raster columns per table so its possible "
"to have a raster table listed multiple times with a different raster column "
"for each."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:393
#, no-c-format
msgid ""
"<varname>srid</varname> The spatial reference identifier of the raster. "
"Should be an entry in the <xref linkend=\"spatial_ref_sys\"/>."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:396
#, no-c-format
msgid ""
"<varname>scale_x</varname> The scaling between geometric spatial coordinates "
"and pixel. This is only available if all tiles in the raster column have the "
"same <varname>scale_x</varname> and this constraint is applied. Refer to "
"<xref linkend=\"RT_ST_ScaleX\"/> for more details."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:399
#, no-c-format
msgid ""
"<varname>scale_y</varname> The scaling between geometric spatial coordinates "
"and pixel. This is only available if all tiles in the raster column have the "
"same <varname>scale_y</varname> and the <varname>scale_y</varname> "
"constraint is applied. Refer to <xref linkend=\"RT_ST_ScaleY\"/> for more "
"details."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:402
#, no-c-format
msgid ""
"<varname>blocksize_x</varname> The width (number of pixels across) of each "
"raster tile . Refer to <xref linkend=\"RT_ST_Width\"/> for more details."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:405
#, no-c-format
msgid ""
"<varname>blocksize_y</varname> The width (number of pixels down) of each "
"raster tile . Refer to <xref linkend=\"RT_ST_Height\"/> for more details."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:408
#, no-c-format
msgid ""
"<varname>same_alignment</varname> A boolean that is true if all the raster "
"tiles have the same alignment . Refer to <xref linkend=\"RT_ST_SameAlignment"
"\"/> for more details."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:411
#, no-c-format
msgid ""
"<varname>regular_blocking</varname> If the raster column has the spatially "
"unique and coverage tile constraints, the value with be TRUE. Otherwise, it "
"will be FALSE."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:414
#, no-c-format
msgid ""
"<varname>num_bands</varname> The number of bands in each tile of your raster "
"set. This is the same information as what is provided by"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:417
#, no-c-format
msgid ""
"<varname>pixel_types</varname> An array defining the pixel type for each "
"band. You will have the same number of elements in this array as you have "
"number of bands. The pixel_types are one of the following defined in <xref "
"linkend=\"RT_ST_BandPixelType\"/>."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:420
#, no-c-format
msgid ""
"<varname>nodata_values</varname> An array of double precision numbers "
"denoting the <varname>nodata_value</varname> for each band. You will have "
"the same number of elements in this array as you have number of bands. These "
"numbers define the pixel value for each band that should be ignored for most "
"operations. This is similar information provided by <xref linkend="
"\"RT_ST_BandNoDataValue\"/>."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:423
#, no-c-format
msgid ""
"<varname>out_db</varname> An array of boolean flags indicating if the raster "
"bands data is maintained outside the database. You will have the same number "
"of elements in this array as you have number of bands."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:426
#, no-c-format
msgid ""
"<varname>extent</varname> This is the extent of all the raster rows in your "
"raster set. If you plan to load more data that will change the extent of the "
"set, you'll want to run the <xref linkend=\"RT_DropRasterConstraints\"/> "
"function before load and then reapply constraints with <xref linkend="
"\"RT_AddRasterConstraints\"/> after load."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:429
#, no-c-format
msgid ""
"<varname>spatial_index</varname> A boolean that is true if raster column has "
"a spatial index."
msgstr ""

#. Tag: title
#: using_raster_dataman.xml:434
#, no-c-format
msgid "Raster Overviews"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:435
#, no-c-format
msgid ""
"<varname>raster_overviews</varname> catalogs information about raster table "
"columns used for overviews and additional information about them that is "
"useful to know when utilizing overviews. Overview tables are cataloged in "
"both <varname>raster_columns</varname> and <varname>raster_overviews</"
"varname> because they are rasters in their own right but also serve an "
"additional special purpose of being a lower resolution caricature of a "
"higher resolution table. These are generated along-side the main raster "
"table when you use the <varname>-l</varname> switch in raster loading or can "
"be generated manually using <xref linkend=\"RT_AddOverviewConstraints\"/>."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:436
#, no-c-format
msgid ""
"Overview tables contain the same constraints as other raster tables as well "
"as additional informational only constraints specific to overviews."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:437
#, no-c-format
msgid ""
"The information in <varname>raster_overviews</varname> does not duplicate "
"the information in <varname>raster_columns</varname>. If you need the "
"information about an overview table present in <varname>raster_columns</"
"varname> you can join the <varname>raster_overviews</varname> and "
"<varname>raster_columns</varname> together to get the full set of "
"information you need."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:438
#, no-c-format
msgid "Two main reasons for overviews are:"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:440
#, no-c-format
msgid ""
"Low resolution representation of the core tables commonly used for fast "
"mapping zoom-out."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:441
#, no-c-format
msgid ""
"Computations are generally faster to do on them than their higher resolution "
"parents because there are fewer records and each pixel covers more "
"territory. Though the computations are not as accurate as the high-res "
"tables they support, they can be sufficient in many rule-of-thumb "
"computations."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:444
#, no-c-format
msgid ""
"The <varname>raster_overviews</varname> catalog contains the following "
"columns of information."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:447
#, no-c-format
msgid ""
"<varname>o_table_catalog</varname> The database the overview table is in. "
"This will always read the current database."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:450
#, no-c-format
msgid ""
"<varname>o_table_schema</varname> The database schema the overview raster "
"table belongs to."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:453
#, no-c-format
msgid "<varname>o_table_name</varname> raster overview table name"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:456
#, no-c-format
msgid ""
"<varname>o_raster_column</varname> the raster column in the overview table."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:460
#, no-c-format
msgid ""
"<varname>r_table_catalog</varname> The database the raster table that this "
"overview services is in. This will always read the current database."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:463
#, no-c-format
msgid ""
"<varname>r_table_schema</varname> The database schema the raster table that "
"this overview services belongs to."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:466
#, no-c-format
msgid ""
"<varname>r_table_name</varname> raster table that this overview services."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:469
#, no-c-format
msgid ""
"<varname>r_raster_column</varname> the raster column that this overview "
"column services."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:472
#, no-c-format
msgid ""
"<varname>overview_factor</varname> - this is the pyramid level of the "
"overview table. The higher the number the lower the resolution of the table. "
"raster2pgsql if given a folder of images, will compute overview of each "
"image file and load separately. Level 1 is assumed and always the original "
"file. Level 2 is will have each tile represent 4 of the original. So for "
"example if you have a folder of 5000x5000 pixel image files that you chose "
"to chunk 125x125, for each image file your base table will have (5000*5000)/"
"(125*125) records = 1600, your (l=2) <varname>o_2</varname> table will have "
"ceiling(1600/Power(2,2)) = 400 rows, your (l=3) <varname>o_3</varname> will "
"have ceiling(1600/Power(2,3) ) = 200 rows. If your pixels aren't divisible "
"by the size of your tiles, you'll get some scrap tiles (tiles not completely "
"filled). Note that each overview tile generated by raster2pgsql has the same "
"number of pixels as its parent, but is of a lower resolution where each "
"pixel of it represents (Power(2,overview_factor) pixels of the original)."
msgstr ""

#. Tag: title
#: using_raster_dataman.xml:484
#, no-c-format
msgid "Building Custom Applications with PostGIS Raster"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:485
#, no-c-format
msgid ""
"The fact that PostGIS raster provides you with SQL functions to render "
"rasters in known image formats gives you a lot of optoins for rendering "
"them. For example you can use OpenOffice / LibreOffice for rendering as "
"demonstrated in <ulink url=\"http://www.postgresonline.com/journal/"
"archives/244-Rendering-PostGIS-Raster-graphics-with-LibreOffice-Base-Reports."
"html\">Rendering PostGIS Raster graphics with LibreOffice Base Reports</"
"ulink>. In addition you can use a wide variety of languages as demonstrated "
"in this section."
msgstr ""

#. Tag: title
#: using_raster_dataman.xml:488
#, no-c-format
msgid ""
"PHP Example Outputting using ST_AsPNG in concert with other raster functions"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:489
#, no-c-format
msgid ""
"In this section, we'll demonstrate how to use the PHP PostgreSQL driver and "
"the <xref linkend=\"RT_ST_AsGDALRaster\"/> family of functions to output "
"band 1,2,3 of a raster to a PHP request stream that can then be embedded in "
"an img src html tag."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:492 using_raster_dataman.xml:504
#, no-c-format
msgid ""
"The sample query demonstrates how to combine a whole bunch of raster "
"functions together to grab all tiles that intersect a particular wgs 84 "
"bounding box and then unions with <xref linkend=\"RT_ST_Union\"/> the "
"intersecting tiles together returning all bands, transforms to user "
"specified projection using <xref linkend=\"RT_ST_Transform\"/>, and then "
"outputs the results as a png using <xref linkend=\"RT_ST_AsPNG\"/>."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:495
#, no-c-format
msgid ""
"You would call the below using <programlisting>http://mywebserver/"
"test_raster.php?srid=2249</programlisting> to get the raster image in "
"Massachusetts state plane feet."
msgstr ""

#. Tag: programlisting
#: using_raster_dataman.xml:496
#, no-c-format
msgid ""
"<![CDATA[<?php\n"
"/** contents of test_raster.php **/\n"
"$conn_str ='dbname=mydb host=localhost port=5432 user=myuser "
"password=mypwd';\n"
"$dbconn = pg_connect($conn_str);\n"
"header('Content-Type: image/png');\n"
"/**If a particular projection was requested use it otherwise use mass state "
"plane meters **/\n"
"if (!empty( $_REQUEST['srid'] ) && is_numeric( $_REQUEST['srid']) ){\n"
"                $input_srid = intval($_REQUEST['srid']);\n"
"}\n"
"else { $input_srid = 26986; }\n"
"/** The set bytea_output may be needed for PostgreSQL 9.0+, but not for 8.4 "
"**/\n"
"$sql = \"set bytea_output='escape';\n"
"SELECT ST_AsPNG(ST_Transform(\n"
"                        ST_AddBand(ST_Union(rast,1), ARRAY[ST_Union(rast,2),"
"ST_Union(rast,3)])\n"
"                                ,$input_srid) ) As new_rast\n"
" FROM aerials.boston\n"
"        WHERE\n"
"         ST_Intersects(rast, ST_Transform(ST_MakeEnvelope(-71.1217, 42.227, "
"-71.1210, 42.218,4326),26986) )\";\n"
"$result = pg_query($sql);\n"
"$row = pg_fetch_row($result);\n"
"pg_free_result($result);\n"
"if ($row === false) return;\n"
"echo pg_unescape_bytea($row[0]);\n"
"?>]]>"
msgstr ""

#. Tag: title
#: using_raster_dataman.xml:499
#, no-c-format
msgid ""
"ASP.NET C# Example Outputting using ST_AsPNG in concert with other raster "
"functions"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:500
#, no-c-format
msgid ""
"In this section, we'll demonstrate how to use Npgsql PostgreSQL .NET driver "
"and the <xref linkend=\"RT_ST_AsGDALRaster\"/> family of functions to output "
"band 1,2,3 of a raster to a PHP request stream that can then be embedded in "
"an img src html tag."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:503
#, no-c-format
msgid ""
"You will need the npgsql .NET PostgreSQL driver for this exercise which you "
"can get the latest of from <ulink url=\"http://npgsql.projects.postgresql."
"org/\">http://npgsql.projects.postgresql.org/</ulink>. Just download the "
"latest and drop into your ASP.NET bin folder and you'll be good to go."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:507
#, no-c-format
msgid ""
"This is same example as <xref linkend=\"RT_PHP_Output\"/> except implemented "
"in C#."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:508
#, no-c-format
msgid ""
"You would call the below using <programlisting>http://mywebserver/TestRaster."
"ashx?srid=2249</programlisting> to get the raster image in Massachusetts "
"state plane feet."
msgstr ""

#. Tag: programlisting
#: using_raster_dataman.xml:509
#, no-c-format
msgid ""
"-- web.config connection string section --\n"
"<![CDATA[<connectionStrings>\n"
"    <add name=\"DSN\"\n"
"        connectionString=\"server=localhost;database=mydb;Port=5432;User "
"Id=myuser;password=mypwd\"/>\n"
"</connectionStrings>]]>"
msgstr ""

#. Tag: programlisting
#: using_raster_dataman.xml:510
#, no-c-format
msgid ""
"// Code for TestRaster.ashx\n"
"<![CDATA[<%@ WebHandler Language=\"C#\" Class=\"TestRaster\" %>\n"
"using System;\n"
"using System.Data;\n"
"using System.Web;\n"
"using Npgsql;\n"
"\n"
"public class TestRaster : IHttpHandler\n"
"{\n"
"        public void ProcessRequest(HttpContext context)\n"
"        {\n"
"\n"
"                context.Response.ContentType = \"image/png\";\n"
"                context.Response.BinaryWrite(GetResults(context));\n"
"\n"
"        }\n"
"\n"
"        public bool IsReusable {\n"
"                get { return false; }\n"
"        }\n"
"\n"
"        public byte[] GetResults(HttpContext context)\n"
"        {\n"
"                byte[] result = null;\n"
"                NpgsqlCommand command;\n"
"                string sql = null;\n"
"                int input_srid = 26986;\n"
"        try {\n"
"                    using (NpgsqlConnection conn = new "
"NpgsqlConnection(System.Configuration.ConfigurationManager."
"ConnectionStrings[\"DSN\"].ConnectionString)) {\n"
"                            conn.Open();\n"
"\n"
"                if (context.Request[\"srid\"] != null)\n"
"                {\n"
"                    input_srid = Convert.ToInt32(context.Request[\"srid"
"\"]);\n"
"                }\n"
"                sql = @\"SELECT ST_AsPNG(\n"
"                            ST_Transform(\n"
"                                        ST_AddBand(\n"
"                                ST_Union(rast,1), ARRAY[ST_Union(rast,2),"
"ST_Union(rast,3)])\n"
"                                                    ,:input_srid) ) As "
"new_rast\n"
"                        FROM aerials.boston\n"
"                                WHERE\n"
"                                    ST_Intersects(rast,\n"
"                                    ST_Transform(ST_MakeEnvelope(-71.1217, "
"42.227, -71.1210, 42.218,4326),26986) )\";\n"
"                            command = new NpgsqlCommand(sql, conn);\n"
"                command.Parameters.Add(new NpgsqlParameter(\"input_srid\", "
"input_srid));\n"
"\n"
"\n"
"                            result = (byte[]) command.ExecuteScalar();\n"
"                conn.Close();\n"
"                        }\n"
"\n"
"                }\n"
"        catch (Exception ex)\n"
"        {\n"
"            result = null;\n"
"            context.Response.Write(ex.Message.Trim());\n"
"        }\n"
"                return result;\n"
"        }\n"
"}]]>"
msgstr ""

#. Tag: title
#: using_raster_dataman.xml:513
#, no-c-format
msgid "Java console app that outputs raster query as Image file"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:514
#, no-c-format
msgid ""
"This is a simple java console app that takes a query that returns one image "
"and outputs to specified file."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:515
#, no-c-format
msgid ""
"You can download the latest PostgreSQL JDBC drivers from <ulink url=\"http://"
"jdbc.postgresql.org/download.html\">http://jdbc.postgresql.org/download."
"html</ulink>"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:516
#, no-c-format
msgid "You can compile the following code using a command something like:"
msgstr ""

#. Tag: programlisting
#: using_raster_dataman.xml:517
#, no-c-format
msgid ""
"set env CLASSPATH .:..\\postgresql-9.0-801.jdbc4.jar\n"
"javac SaveQueryImage.java\n"
"jar cfm SaveQueryImage.jar Manifest.txt *.class"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:518
#, no-c-format
msgid "And call it from the command-line with something like"
msgstr ""

#. Tag: programlisting
#: using_raster_dataman.xml:519
#, no-c-format
msgid ""
"java -jar SaveQueryImage.jar \"SELECT "
"ST_AsPNG(ST_AsRaster(ST_Buffer(ST_Point(1,5),10, 'quad_segs=2'),150, 150, "
"'8BUI',100));\" \"test.png\""
msgstr ""

#. Tag: programlisting
#: using_raster_dataman.xml:520
#, no-c-format
msgid ""
"-- Manifest.txt --\n"
"<![CDATA[Class-Path: postgresql-9.0-801.jdbc4.jar\n"
"Main-Class: SaveQueryImage]]>"
msgstr ""

#. Tag: programlisting
#: using_raster_dataman.xml:521
#, no-c-format
msgid ""
"// Code for SaveQueryImage.java\n"
"<![CDATA[import java.sql.Connection;\n"
"import java.sql.SQLException;\n"
"import java.sql.PreparedStatement;\n"
"import java.sql.ResultSet;\n"
"import java.io.*;\n"
"\n"
"public class SaveQueryImage {\n"
"  public static void main(String[] argv) {\n"
"      System.out.println(\"Checking if Driver is registered with "
"DriverManager.\");\n"
"\n"
"      try {\n"
"        //java.sql.DriverManager.registerDriver (new org.postgresql."
"Driver());\n"
"        Class.forName(\"org.postgresql.Driver\");\n"
"      }\n"
"      catch (ClassNotFoundException cnfe) {\n"
"        System.out.println(\"Couldn't find the driver!\");\n"
"        cnfe.printStackTrace();\n"
"        System.exit(1);\n"
"      }\n"
"\n"
"      Connection conn = null;\n"
"\n"
"      try {\n"
"        conn = DriverManager.getConnection(\"jdbc:postgresql://"
"localhost:5432/mydb\",\"myuser\", \"mypwd\");\n"
"        conn.setAutoCommit(false);\n"
"\n"
"        PreparedStatement sGetImg = conn.prepareStatement(argv[0]);\n"
"\n"
"        ResultSet rs = sGetImg.executeQuery();\n"
"\n"
"                FileOutputStream fout;\n"
"                try\n"
"                {\n"
"                        rs.next();\n"
"                        /** Output to file name requested by user **/\n"
"                        fout = new FileOutputStream(new File(argv[1]) );\n"
"                        fout.write(rs.getBytes(1));\n"
"                        fout.close();\n"
"                }\n"
"                catch(Exception e)\n"
"                {\n"
"                        System.out.println(\"Can't create file\");\n"
"                        e.printStackTrace();\n"
"                }\n"
"\n"
"        rs.close();\n"
"                sGetImg.close();\n"
"        conn.close();\n"
"      }\n"
"      catch (SQLException se) {\n"
"        System.out.println(\"Couldn't connect: print out a stack trace and "
"exit.\");\n"
"        se.printStackTrace();\n"
"        System.exit(1);\n"
"      }\n"
"  }\n"
"}]]>"
msgstr ""

#. Tag: title
#: using_raster_dataman.xml:525
#, no-c-format
msgid "Use PLPython to dump out images via SQL"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:526
#, no-c-format
msgid ""
"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."
msgstr ""

#. Tag: programlisting
#: using_raster_dataman.xml:528
#, no-c-format
msgid ""
"<![CDATA[CREATE OR REPLACE FUNCTION write_file (param_bytes bytea, "
"param_filepath text)\n"
"RETURNS text\n"
"AS $$\n"
"f = open(param_filepath, 'wb+')\n"
"f.write(param_bytes)\n"
"return param_filepath\n"
"$$ LANGUAGE plpythonu;]]>"
msgstr ""

#. Tag: programlisting
#: using_raster_dataman.xml:529
#, no-c-format
msgid ""
"--write out 5 images to the PostgreSQL server in varying sizes\n"
"-- note the postgresql daemon account needs to have write access to folder\n"
"-- this echos back the file names created;\n"
" SELECT write_file(ST_AsPNG(\n"
"        ST_AsRaster(ST_Buffer(ST_Point(1,5),j*5, 'quad_segs=2'),150*j, "
"150*j, '8BUI',100)),\n"
"         'C:/temp/slices'|| j || '.png')\n"
"         FROM generate_series(1,5) As j;\n"
"\n"
"     write_file\n"
"---------------------\n"
" C:/temp/slices1.png\n"
" C:/temp/slices2.png\n"
" C:/temp/slices3.png\n"
" C:/temp/slices4.png\n"
" C:/temp/slices5.png"
msgstr ""

#. Tag: title
#: using_raster_dataman.xml:532
#, no-c-format
msgid "Outputting Rasters with PSQL"
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:533
#, no-c-format
msgid ""
"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."
msgstr ""

#. Tag: para
#: using_raster_dataman.xml:535
#, no-c-format
msgid ""
"Unlike the python approach, this approach creates the file on your local "
"computer."
msgstr ""

#. Tag: screen
#: using_raster_dataman.xml:536
#, no-c-format
msgid ""
"SELECT oid, lowrite(lo_open(oid, 131072), png) As num_bytes\n"
" FROM\n"
" ( VALUES (lo_create(0),\n"
"   ST_AsPNG( (SELECT rast FROM aerials.boston WHERE rid=1) )\n"
"  ) ) As v(oid,png);\n"
"-- you'll get an output something like --\n"
"   oid   | num_bytes\n"
"---------+-----------\n"
" 2630819 |     74860\n"
"\n"
"-- next note the oid and do this replacing the c:/test.png to file path "
"location\n"
"-- on your local computer\n"
" \\lo_export 2630819 'C:/temp/aerial_samp.png'\n"
"\n"
"-- this deletes the file from large object storage on db\n"
"SELECT lo_unlink(2630819);"
msgstr ""