# SOME DESCRIPTIVE TITLE.
#
# Translators:
# pibinko <pibinko@gmail.com>, 2013-2014
msgid ""
msgstr ""
"Project-Id-Version: PostGIS\n"
"Report-Msgid-Bugs-To: http://bugs.kde.org\n"
"POT-Creation-Date: 2016-07-04 13:02+0000\n"
"PO-Revision-Date: 2015-09-29 12:25+0000\n"
"Last-Translator: Sandro Santilli <strk@kbt.io>\n"
"Language-Team: Italian (Italy) (http://www.transifex.com/postgis/postgis/"
"language/it_IT/)\n"
"Language: it_IT\n"
"MIME-Version: 1.0\n"
"Content-Type: text/plain; charset=UTF-8\n"
"Content-Transfer-Encoding: 8bit\n"
"Plural-Forms: nplurals=2; plural=(n != 1);\n"

#. Tag: title
#: using_raster_dataman.xml:3
#, no-c-format
msgid "Raster Data Management, Queries, and Applications"
msgstr "Dati raster: gestione, interrogazione e applicazioni"

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

#. 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 ""
"Nella maggior parte dei casi, creerete i raster PostGIS caricando file "
"esterni tramite il raster loader <varname>raster2pgsql</varname> compreso "
"nell'installazione."

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

#. 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 ""
" <varname>raster2pgsql</varname> è un loader raster che trasforma i formati "
"raster supportati da GDAL in formato SQL utile al caricamento in una tabella "
"raster di PostGIS. Può caricare anche cartelle di file, e creare delle "
"anteprime."

#. 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 ""
"Dato che in genere raster2pgsql viene compilato come parte di PostGIS (a "
"meno che non abbiate compilato una vostra libreria GDAL a parte), i tipi di "
"raster supportati dall'eseguibile saranno gli stessi che sono compilati per "
"GDAL. Per avere una lista dei tipi di raster supportati dal vostro "
"raster2pgsql utilizzate l'opzione <varname>-G</varname>. Questi tipi "
"dovrebbero essere gli stessi disponibilii tramite la vostra installazione di "
"PostGIS e documentati qui <xref linkend=\"RT_ST_GDALDrivers\"/>, se usate la "
"stessa libreria gdal per entrambi i programmi."

#. 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 ""
"La vecchia versione di questo strumento era uno script in python. "
"L'eseguibile sostituisce lo script in python. Se vi trovate ad avere bisogno "
"dello script in Python, alcuni esempio sono reperibili alla pagina <ulink "
"url=\"http://trac.osgeo.org/gdal/wiki/frmts_wtkraster.html\">GDAL PostGIS "
"Raster Driver Usage</ulink>. Notate che lo script Python raster2pgsql "
"potrebbe non funzionare con le future versioni di raster PostGIS e che non è "
"più supportato."

#. 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 "ESEMPIO DI UTILIZZO:"

#. 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 ""
"raster2pgsql <varname>opzioni raster</varname> <varname>nome file raster</"
"varname> <varname>snome schema</varname>.<varname>nome tabella</varname> "
"&gt; out.sql"

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

#. 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 ""
"Mostra una schermata di aiuto. L'aiuto verra mostrato inoltre se non "
"assegnate alcun parametro."

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

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

#. Tag: term
#: using_raster_dataman.xml:46
#, no-c-format
msgid "(c|a|d|p) These are mutually exclusive options:"
msgstr "(c|a|d|p) sono opzioni che is escludono una con l'altra:"

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

#. 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 ""
"Crea una nuova tabella e carica in questa il/i raster. <emphasis>Questa è la "
"modalita di default</emphasis>"

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

#. Tag: para
#: using_raster_dataman.xml:62
#, no-c-format
msgid "Append raster(s) to an existing table."
msgstr "Accoda il o i raster a una tabella esistente."

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

#. Tag: para
#: using_raster_dataman.xml:71
#, no-c-format
msgid "Drop table, create new one and populate it with raster(s)"
msgstr "Elimina la tabella, ne crea una nuova e vi carica il/i dati raster"

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

#. Tag: para
#: using_raster_dataman.xml:80
#, no-c-format
msgid "Prepare mode, only create the table."
msgstr "Modalità di preparazione. Crea solamente la tabella."

#. 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 "<term>-C</term>"

#. 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 "<term>-x</term>"

#. 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 "<term>-r</term>"

#. 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 ""
"Elaborazioni raster: parametri opzionali utilizzati nel trattamento dei dati "
"raster in ingresso"

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

#. 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 ""
"Assegna lo SRID specificato al raster in uscita. Se non fornito o uguale a "
"zero, saranno controllati i metadati del raster per determinare uno SRID "
"appropriato."

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

#. 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 ""
"Indice (a partire da 1) della banda da estrarre dal raster. Per specificare "
"più di un indice di banda, separare con una virgola (,). Se non specificato, "
"saranno estratte tutte le bande."

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

#. 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 "-R, --register"

#. 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 ""
"Nel database vengono salvati solo i metadati e il percorso del raster (non i "
"pixel)."

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

#. 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 "-N <varname>NODATA</varname>"

#. Tag: para
#: using_raster_dataman.xml:189
#, no-c-format
msgid "NODATA value to use on bands without a NODATA value."
msgstr "Valore da usare come NODATA per le bande senza un valore NODATA."

#. Tag: term
#: using_raster_dataman.xml:201
#, no-c-format
msgid "Optional parameters used to manipulate database objects"
msgstr "Parametri opzionali usati per la manipolazione di oggetti del database"

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

#. 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 "-f COLONNA"

#. Tag: para
#: using_raster_dataman.xml:215
#, no-c-format
msgid "Specify name of destination raster column, default is 'rast'"
msgstr ""
"Specifica il nome della colonna di destinazione per i raster. Il default è "
"'rast'."

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

#. Tag: para
#: using_raster_dataman.xml:223
#, no-c-format
msgid "Add a column with the name of the file"
msgstr "Aggiunge una colonna con il nome del file"

#. 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 "<term>-I</term>"

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

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

#. 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 "-T <varname>tablespace</varname>"

#. 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 ""
"Specificare il tablespace per la nuova tabella. Notare che gli indici "
"(compresa la chiave primaria) useranno sempre il tablespace di default, a "
"meno che non venga usato anche il flag -X."

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

#. 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 ""
"Specifica il tablespace per il nuovo indice della tabella. Si applica alla "
"chiave primaria e all'indice spaziale se viene usato il flag  -I"

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

#. Tag: para
#: using_raster_dataman.xml:295
#, no-c-format
msgid "Use copy statements instead of insert statements."
msgstr "Utilizza comandi di copia anziché di inserimento."

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

#. Tag: para
#: using_raster_dataman.xml:307
#, no-c-format
msgid "Execute each statement individually, do not use a transaction."
msgstr "Esegui ogni comando individualmente, non utilizzare una transazione."

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

#. 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 ""
"Controlla l'ordine dei byte prodotti nell'output binario del raster: "
"specificare 0 per XDR e 1 per NDR (il default). Al momento viene supportato "
"solo lo NDR."

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

#. 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 ""
"Specifica la versione del formato in uscita. Il default è 0. Al momento 0 è "
"l'unico supportato."

#. 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 ""
"Una sessione di esempio che utilizzi il loader per creare un file di input e "
"per caricarlo a pezzi di tile 100x100 potrebbe essere il seguente:"

#. 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 ""
"Potete omettere il nome dello schema, per esempio <varname>demelevation</"
"varname> al posto di  <varname>public.demelevation</varname> e la tabella "
"raster sarà creata nello schema di default del database o dell'utente"

#. 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 ""
"La conversione e il caricamento possono essere eseguiti in un unico "
"passaggio tramite le pipe UNIX:"

#. 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 ""
"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"

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

#. Tag: para
#: using_raster_dataman.xml:335
#, no-c-format
msgid "The -G commands outputs a list something like"
msgstr "Il parametro -G restituirà un elenco tipo"

#. 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 ""
"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"

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

#. 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 ""
"In varie occasioni vorrete creare raster e tabelle raster direttamente nel "
"database. Per questo esiste una pletora di funzioni. Questi sono i passi "
"generali da seguire."

#. 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 ""
"Creare una tabella con una colonna raster per contenere i nuovi valori "
"raster può essere ottenuto da:"

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

#. 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 ""
"Esistono molte funzioni per assitervi verso questo obiettivo. Se state "
"creando un raster non derivato da altri raster, inizierete con: <xref "
"linkend=\"RT_ST_MakeEmptyRaster\"/>, seguito da <xref linkend=\"RT_ST_AddBand"
"\"/>"

#. 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 ""
"Potete anche creare raster a partire dalle geometria. Per questo userete "
"<xref linkend=\"RT_ST_AsRaster\"/>, magari accompagnato da altre funzioni "
"come <xref linkend=\"RT_ST_Union\"/> o <xref linkend="
"\"RT_ST_MapAlgebraFct2\"/>, o qualsiasi altra delle funzioni di algebra "
"sulle mappe."

#. 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 ""
"Vi sono poi ancora più opzioni per creare nuove tabelle raster a partire da "
"tabelle esistenti. Per esempio potete creare una tabella raster in una "
"proiezione diversa da una tabella esistente usando <xref linkend="
"\"RT_ST_Transform\"/>"

#. 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 ""
"Una volta inseriti dei valori iniziali nella tabella, vorrete creare un "
"indice spaziale sulla colonna raster, con un comando tipo:"

#. 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 ""
"CREATE INDEX myrasters_rast_st_convexhull_idx ON myrasters USING "
"gist( ST_ConvexHull(rast) );"

#. 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 "Cataloghi raster"

#. 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 ""
"Esistono due tipi di viste dei cataloghi raster fornite con PostGIS. "
"Entrambe le viste utilizzano informazioni contenute nei dati sui limiti "
"delle tabelle raster. Da ciò risulta che le viste dei cataloghi sono sempre "
"consistenti con i dati raster nelle tabelle, dato che sono considerati i "
"limiti di queste."

#. 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 ""
"<varname>raster_columns</varname> questa vista riporta il catalogo di tutte "
"le colonne raster nel vostro database."

#. 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 ""
"<varname>raster_overviews</varname> questa vista elenca tutte le colonne "
"raste di tabelle nel vostro database che sono utilizzate come vista "
"d'insieme per una tabella con maggiori dettagli. Le tabelle di questo tipo "
"sono generate quando utilizzate l'opzione <varname>-l</varname> durante il "
"caricamento."

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

#. 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 ""
" <varname>raster_columns</varname> è un catalogo di tutte le colonne di "
"tabelle che nel vostro database sono di tipo raster. E' una vista che "
"utilizza i limiti applicati alle tabelle, per cui le informazioni sono "
"sempre congruenti, anche se ripristinate una tabella raster dal backup di un "
"altro database. Il catalogo  <varname>raster_columns</varname> contiene le "
"seguenti colonne."

#. 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 ""
"Se non avete creato le tabelle con il loader o vi siete dimenticati di "
"specificare l'opzione  <varname>-C</varname> durante il caricamento, potete "
"far applicare i limiti a cose fatte utilizzando <xref linkend="
"\"RT_AddRasterConstraints\"/>, di modo che il catalogo "
"<varname>raster_columns</varname> registri le informazioni sulle vostre tile "
"raster."

#. 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 ""
"<varname>r_table_catalog</varname> Il database in cui si trova la tabella. "
"Conterrà sempre il database corrente."

#. 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 ""
"<varname>r_table_schema</varname> Lo schema database cui la tabella raster "
"appartiene."

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

#. 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 ""
"<varname>r_raster_column</varname> la colonna nella tabella  "
"<varname>r_table_name</varname> che è di tipo raster. Nulla in PostGIS vi "
"impedisce di avere più colonne raster per tabella, per cui è possibile avere "
"una tabella raster elencata più volte con il riferimento ogni volta a una "
"colonna raster differente.."

#. 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 ""
"<varname>srid</varname> L'identificatore del sistema di riferimento spaziale "
"del raster. Dovrebbe essere una voce di <xref linkend=\"spatial_ref_sys\"/>."

#. 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 ""
"<varname>scale_x</varname> Il rapporto di scala tra le coordinate "
"geometriche e il pixel, disponibile solo se tutte le tile nella colonna "
"raster hanno lo stesso valore di  <varname>scale_x</varname> e questo limite "
"è applicato. Si rimanda è <xref linkend=\"RT_ST_ScaleX\"/> per ulteriori "
"dettagli."

#. 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 ""
"<varname>scale_y</varname> Il rapporto di scala tra le coordinate "
"geometriche e il pixel, disponibile solo se tutte le tile nella colonna "
"raster hanno lo stesso valore di  <varname>scale_y</varname> e questo limite "
"è applicato. Si rimanda è <xref linkend=\"RT_ST_ScaleY\"/> per ulteriori "
"dettagli."

#. 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 ""
"<varname>blocksize_x</varname> La larghezza (come numero di pixel in "
"orizzontale) di ogni tile raster. Si rimanda a <xref linkend=\"RT_ST_Width\"/"
"> per ulteriori dettagli."

#. 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 ""
"<varname>blocksize_y</varname> L'altezza (number of pixels in verticale) di "
"ogni tile raster. Si rimanda a <xref linkend=\"RT_ST_Height\"/> per "
"ulteriori dettagli."

#. 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 ""
"<varname>stesso_allineamento</varname> Variabile booleana pari a \"vero\" se "
"tutte le tile raster hanno lo stesso allineamento. Si rimanda a <xref "
"linkend=\"RT_ST_SameAlignment\"/> per ulteriori dettagli."

#. 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 ""
"<varname>numero_bande</varname> Il numero delle bande in ogni tile del set "
"di raster. Questa è la stessa informazione fornita da"

#. 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 ""
"<varname>pixel_types</varname> Un vettore che definisce il tipo di pixel per "
"ciascuna banda. In questo vettore avrete un numero di elementi pari al "
"numero delle bande. I valori di  pixel_types possono essere tra quelli "
"definiti in  <xref linkend=\"RT_ST_BandPixelType\"/>."

#. 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 ""
"<varname>nodata_values</varname> Un vettore in doppia precisione che spefica "
"i valori <varname>nodata_value</varname> per ciascuna banda. Avrete in "
"questo vettore un numero di elementi pari al numero di bande. Questi numeri "
"definiscono il valore del pixel che per ciascuna banda deve essere ignorato "
"nella maggior parte delle operazioni. L'informazion è simile a quella "
"fornita da <xref linkend=\"RT_ST_BandNoDataValue\"/>."

#. 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 "Costruire applicazioni personalizzate con PostGIS Raster"

#. 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 ""
"Il fatto che PostGIS raster vi fornisca le funzioni per restituire i raster "
"in formati di immagine noti vi dà diverse opzioni per visualizzarli. Per "
"esempio potete utilizzare OpenOffice / LibreOffice, come mostrato alla "
"pagina <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>. "
"Inoltre potete utilizzare diversi linguaggi, come illustrato in questo "
"paragrafo."

#. Tag: title
#: using_raster_dataman.xml:488
#, no-c-format
msgid ""
"PHP Example Outputting using ST_AsPNG in concert with other raster functions"
msgstr ""
"Esempio di output in PHP, utilizzando ST_AsPNG assieme ad altre funzioni "
"raster"

#. 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 ""
"In questo paragrafo mostreremo come utilizzare il driver PHP PostgreSQL e la "
"famiglia di funzioni <xref linkend=\"RT_ST_AsGDALRaster\"/> per estrarre le "
"bande 1,2,3 di un raster a una richiesta PHP che poi può essere inserita in "
"un tag src di un'immagine HTML."

#. 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 ""
"La query di esempio mostra come combinare varie funzioni raster per "
"recuperare tutte le tile che intersecano una data area rettangolare in "
"wgs84, unisce le tile risultanti per tutte le bande con <xref linkend="
"\"RT_ST_Union\"/>, le trasforma in una proiezione specificata dall'utente "
"con <xref linkend=\"RT_ST_Transform\"/> e infine crea un PNG in uscita "
"tramite <xref linkend=\"RT_ST_AsPNG\"/>."

#. 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 ""
"Andreste a chiamare il codice sotto utilizzando  <programlisting>http://"
"mywebserver/test_raster.php?srid=2249</programlisting> per ottenere "
"l'immagine raster proiettata nel sistema di riferimento Massachusetts state "
"plane feet."

#. Tag: programlisting
#: using_raster_dataman.xml:496
#, fuzzy, 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 ""
"<![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"
"?>]]>"

#. 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 ""
"Esempio ASP.NET C# di output con ST_AsPNG, assieme ad altre funzioni raster"

#. 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 ""
"In questo paragrafo vi mostreremo come usare il driver .NET Npgsql e la "
"famiglia di funzioni <xref linkend=\"RT_ST_AsGDALRaster\"/> per inviare in "
"uscita le bande 1,2,3 di un raster a una richiesta PHP che può poi essere "
"inserita nel tag src di un immagine html."

#. 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 ""
"Per questo vi servirà il driver PostgreSQL npgsql .NET. Potete recuperare il "
"più recente da <ulink url=\"http://npgsql.projects.postgresql.org/\">http://"
"npgsql.projects.postgresql.org/</ulink>. Scaricatelo e salvatelo nella "
"vostra cartella bin di ASP.NET per poter lavorare."

#. 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 ""
"Questo è lo stesso esempio illustrato in <xref linkend=\"RT_PHP_Output\"/>, "
"implementato in C#."

#. 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 ""
"Richiamerete il codice sotto come <programlisting>http://mywebserver/"
"TestRaster.ashx?srid=2249</programlisting> per ottenere l'immagine raster "
"nel sistema di riferimento Massachusetts state plane feet."

#. Tag: programlisting
#: using_raster_dataman.xml:509
#, fuzzy, 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 ""
"-- 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>]]>"

#. Tag: programlisting
#: using_raster_dataman.xml:510
#, fuzzy, 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 ""
"// 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"
"}]]>"

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

#. 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 ""
"Questa è una semplice app per console java che prende una query, ne "
"restituisce la corrispondente immagine e la scrive in un file specificato."

#. 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 ""
"Potete scaricare i driver JDBC per PostgreSQL più recenti da  <ulink url="
"\"http://jdbc.postgresql.org/download.html\">http://jdbc.postgresql.org/"
"download.html</ulink>"

#. Tag: para
#: using_raster_dataman.xml:516
#, no-c-format
msgid "You can compile the following code using a command something like:"
msgstr "Potete compilare il codice seguente con un comando tipo:"

#. 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 ""
"set env CLASSPATH .:..\\postgresql-9.0-801.jdbc4.jar\n"
"javac SaveQueryImage.java\n"
"jar cfm SaveQueryImage.jar Manifest.txt *.class"

#. Tag: para
#: using_raster_dataman.xml:518
#, no-c-format
msgid "And call it from the command-line with something like"
msgstr "E lanciarlo dalla riga di comando con un'istruzione tipo"

#. 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 ""
"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\""

#. 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 ""
"-- Manifest.txt --\n"
"<![CDATA[Class-Path: postgresql-9.0-801.jdbc4.jar\n"
"Main-Class: SaveQueryImage]]>"

#. Tag: programlisting
#: using_raster_dataman.xml:521
#, fuzzy, 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 ""
"// 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"
"}]]>"

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

#. 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
#, fuzzy, 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 ""
"--scrive cinque immagini sul server PostgreSQL con dimensioni variabili\n"
"-- notaer che il l'account da cui gira il demone postgresql deve avere "
"diritto di scrittura sulla cartella\n"
"-- questo mostra i nomi dei file creati;\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"

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

#. Tag: para
#: using_raster_dataman.xml:533
#, fuzzy, 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 ""
"Purtroppo PSQL non dispone di una funzione comoda per l'esportazione di file "
"binari.  Quello che segue è una soluzione improvvisata derivante dai "
"suggerimenti che trovate alla pagina <ulink url=\"http://people."
"planetpostgresql.org/andrew/index.php?/archives/196-Clever-trick-challenge."
"html\">Clever Trick Challenge -- Outputting bytea with psql</ulink> e che si "
"appoggia al supporto di PostgreSQL per i tipi \"large object\". Per "
"utilizzare questo sistema anzitutto lanciate la riga di comando psql e "
"collegatevi al database."

#. 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 ""
"A differenza dell'approcio python, questo sistema crea il file in locale sul "
"vostro computer."

#. Tag: screen
#: using_raster_dataman.xml:536
#, fuzzy, 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 ""
"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"
"-- otterrete qualcosa tipo --\n"
"   oid   | num_bytes\n"
"---------+-----------\n"
" 2630819 |     74860\n"
" \n"
"-- prendete nota dell'oid e sostituite c:/test.png con il percorso del "
"file \n"
"-- sul vostro computer\n"
" \\lo_export 2630819 'C:/temp/aerial_samp.png'\n"
" \n"
"-- questo cancella il file dall'archiviazione dei large objects nel "
"database\n"
"SELECT lo_unlink(2630819);"