1# SOME DESCRIPTIVE TITLE. 2# 3# Translators: 4# pibinko <pibinko@gmail.com>, 2013-2014 5msgid "" 6msgstr "" 7"Project-Id-Version: PostGIS\n" 8"Report-Msgid-Bugs-To: https://bugs.kde.org\n" 9"POT-Creation-Date: 2021-11-08 06:12+0000\n" 10"PO-Revision-Date: 2021-11-28 22:35+0000\n" 11"Last-Translator: Regina Obe\n" 12"Language-Team: Italian (Italy) (http://www.transifex.com/postgis/postgis/" 13"language/it_IT/)\n" 14"Language: it_IT\n" 15"MIME-Version: 1.0\n" 16"Content-Type: text/plain; charset=UTF-8\n" 17"Content-Transfer-Encoding: 8bit\n" 18"Plural-Forms: nplurals=2; plural=(n != 1);\n" 19 20#. Tag: title 21#: using_raster_dataman.xml:3 22#, no-c-format 23msgid "Raster Data Management, Queries, and Applications" 24msgstr "Dati raster: gestione, interrogazione e applicazioni" 25 26#. Tag: title 27#: using_raster_dataman.xml:5 28#, no-c-format 29msgid "Loading and Creating Rasters" 30msgstr "Caricare e creare raster" 31 32#. Tag: para 33#: using_raster_dataman.xml:6 34#, no-c-format 35msgid "" 36"For most use cases, you will create PostGIS rasters by loading existing " 37"raster files using the packaged <varname>raster2pgsql</varname> raster " 38"loader." 39msgstr "" 40"Nella maggior parte dei casi, creerete i raster PostGIS caricando file " 41"esterni tramite il raster loader <varname>raster2pgsql</varname> compreso " 42"nell'installazione." 43 44#. Tag: title 45#: using_raster_dataman.xml:9 46#, no-c-format 47msgid "Using raster2pgsql to load rasters" 48msgstr "Usare raster2pgsql per caricare i raster" 49 50#. Tag: para 51#: using_raster_dataman.xml:10 52#, no-c-format 53msgid "" 54"The <varname>raster2pgsql</varname> is a raster loader executable that loads " 55"GDAL supported raster formats into sql suitable for loading into a PostGIS " 56"raster table. It is capable of loading folders of raster files as well as " 57"creating overviews of rasters." 58msgstr "" 59" <varname>raster2pgsql</varname> è un loader raster che trasforma i formati " 60"raster supportati da GDAL in formato SQL utile al caricamento in una tabella " 61"raster di PostGIS. Può caricare anche cartelle di file, e creare delle " 62"anteprime." 63 64#. Tag: para 65#: using_raster_dataman.xml:13 66#, no-c-format 67msgid "" 68"Since the raster2pgsql is compiled as part of PostGIS most often (unless you " 69"compile your own GDAL library), the raster types supported by the executable " 70"will be the same as those compiled in the GDAL dependency library. To get a " 71"list of raster types your particular raster2pgsql supports use the <varname>-" 72"G</varname> switch. These should be the same as those provided by your " 73"PostGIS install documented here <xref linkend=\"RT_ST_GDALDrivers\"/> if you " 74"are using the same GDAL library for both." 75msgstr "" 76 77#. Tag: para 78#: using_raster_dataman.xml:16 79#, no-c-format 80msgid "" 81"The older version of this tool was a python script. The executable has " 82"replaced the python script. If you still find the need for the Python script " 83"Examples of the python one can be found at <ulink url=\"http://trac.osgeo." 84"org/gdal/wiki/frmts_wtkraster.html\">GDAL PostGIS Raster Driver Usage</" 85"ulink>. Please note that the raster2pgsql python script may not work with " 86"future versions of PostGIS raster and is no longer supported." 87msgstr "" 88"La vecchia versione di questo strumento era uno script in python. " 89"L'eseguibile sostituisce lo script in python. Se vi trovate ad avere bisogno " 90"dello script in Python, alcuni esempio sono reperibili alla pagina <ulink " 91"url=\"http://trac.osgeo.org/gdal/wiki/frmts_wtkraster.html\">GDAL PostGIS " 92"Raster Driver Usage</ulink>. Notate che lo script Python raster2pgsql " 93"potrebbe non funzionare con le future versioni di raster PostGIS e che non è " 94"più supportato." 95 96#. Tag: para 97#: using_raster_dataman.xml:21 98#, no-c-format 99msgid "" 100"When creating overviews of a specific factor from a set of rasters that are " 101"aligned, it is possible for the overviews to not align. Visit <ulink url=" 102"\"http://trac.osgeo.org/postgis/ticket/1764\">http://trac.osgeo.org/postgis/" 103"ticket/1764</ulink> for an example where the overviews do not align." 104msgstr "" 105 106#. Tag: para 107#: using_raster_dataman.xml:23 108#, no-c-format 109msgid "EXAMPLE USAGE:" 110msgstr "ESEMPIO DI UTILIZZO:" 111 112#. Tag: programlisting 113#: using_raster_dataman.xml:24 114#, no-c-format 115msgid "" 116"raster2pgsql <varname>raster_options_go_here</varname> <varname>raster_file</" 117"varname> <varname>someschema</varname>.<varname>sometable</varname> > out." 118"sql" 119msgstr "" 120"raster2pgsql <varname>opzioni raster</varname> <varname>nome file raster</" 121"varname> <varname>snome schema</varname>.<varname>nome tabella</varname> " 122"> out.sql" 123 124#. Tag: term 125#: using_raster_dataman.xml:28 126#, no-c-format 127msgid "<term>-?</term>" 128msgstr "<term>-?</term>" 129 130#. Tag: para 131#: using_raster_dataman.xml:30 132#, no-c-format 133msgid "" 134"Display help screen. Help will also display if you don't pass in any " 135"arguments." 136msgstr "" 137"Mostra una schermata di aiuto. L'aiuto verra mostrato inoltre se non " 138"assegnate alcun parametro." 139 140#. Tag: term 141#: using_raster_dataman.xml:37 142#, no-c-format 143msgid "<term>-G</term>" 144msgstr "<term>-G</term>" 145 146#. Tag: para 147#: using_raster_dataman.xml:39 148#, no-c-format 149msgid "Print the supported raster formats." 150msgstr "Elenca i formati raster supportati." 151 152#. Tag: term 153#: using_raster_dataman.xml:46 154#, no-c-format 155msgid "(c|a|d|p) These are mutually exclusive options:" 156msgstr "(c|a|d|p) sono opzioni che is escludono una con l'altra:" 157 158#. Tag: term 159#: using_raster_dataman.xml:51 160#, no-c-format 161msgid "<term>-c</term>" 162msgstr "<term>-c</term>" 163 164#. Tag: para 165#: using_raster_dataman.xml:53 166#, no-c-format 167msgid "" 168"Create new table and populate it with raster(s), <emphasis>this is the " 169"default mode</emphasis>" 170msgstr "" 171"Crea una nuova tabella e carica in questa il/i raster. <emphasis>Questa è la " 172"modalita di default</emphasis>" 173 174#. Tag: term 175#: using_raster_dataman.xml:60 176#, no-c-format 177msgid "<term>-a</term>" 178msgstr "<term>-a</term>" 179 180#. Tag: para 181#: using_raster_dataman.xml:62 182#, no-c-format 183msgid "Append raster(s) to an existing table." 184msgstr "Accoda il o i raster a una tabella esistente." 185 186#. Tag: term 187#: using_raster_dataman.xml:69 188#, no-c-format 189msgid "<term>-d</term>" 190msgstr "<term>-d</term>" 191 192#. Tag: para 193#: using_raster_dataman.xml:71 194#, no-c-format 195msgid "Drop table, create new one and populate it with raster(s)" 196msgstr "Elimina la tabella, ne crea una nuova e vi carica il/i dati raster" 197 198#. Tag: term 199#: using_raster_dataman.xml:78 200#, no-c-format 201msgid "<term>-p</term>" 202msgstr "<term>-p</term>" 203 204#. Tag: para 205#: using_raster_dataman.xml:80 206#, no-c-format 207msgid "Prepare mode, only create the table." 208msgstr "Modalità di preparazione. Crea solamente la tabella." 209 210#. Tag: term 211#: using_raster_dataman.xml:91 212#, no-c-format 213msgid "" 214"Raster processing: Applying constraints for proper registering in raster " 215"catalogs" 216msgstr "" 217 218#. Tag: term 219#: using_raster_dataman.xml:96 220#, no-c-format 221msgid "<term>-C</term>" 222msgstr "<term>-C</term>" 223 224#. Tag: para 225#: using_raster_dataman.xml:98 226#, no-c-format 227msgid "" 228"Apply raster constraints -- srid, pixelsize etc. to ensure raster is " 229"properly registered in <varname>raster_columns</varname> view." 230msgstr "" 231 232#. Tag: term 233#: using_raster_dataman.xml:104 234#, no-c-format 235msgid "<term>-x</term>" 236msgstr "<term>-x</term>" 237 238#. Tag: para 239#: using_raster_dataman.xml:106 240#, no-c-format 241msgid "" 242"Disable setting the max extent constraint. Only applied if -C flag is also " 243"used." 244msgstr "" 245 246#. Tag: term 247#: using_raster_dataman.xml:112 248#, no-c-format 249msgid "<term>-r</term>" 250msgstr "<term>-r</term>" 251 252#. Tag: para 253#: using_raster_dataman.xml:114 254#, no-c-format 255msgid "" 256"Set the constraints (spatially unique and coverage tile) for regular " 257"blocking. Only applied if -C flag is also used." 258msgstr "" 259 260#. Tag: term 261#: using_raster_dataman.xml:125 262#, no-c-format 263msgid "" 264"Raster processing: Optional parameters used to manipulate input raster " 265"dataset" 266msgstr "" 267"Elaborazioni raster: parametri opzionali utilizzati nel trattamento dei dati " 268"raster in ingresso" 269 270#. Tag: term 271#: using_raster_dataman.xml:130 272#, no-c-format 273msgid "-s <SRID>" 274msgstr "-s <SRID>" 275 276#. Tag: para 277#: using_raster_dataman.xml:132 278#, no-c-format 279msgid "" 280"Assign output raster with specified SRID. If not provided or is zero, " 281"raster's metadata will be checked to determine an appropriate SRID." 282msgstr "" 283"Assegna lo SRID specificato al raster in uscita. Se non fornito o uguale a " 284"zero, saranno controllati i metadati del raster per determinare uno SRID " 285"appropriato." 286 287#. Tag: term 288#: using_raster_dataman.xml:139 289#, no-c-format 290msgid "-b BAND" 291msgstr "-b BANDA" 292 293#. Tag: para 294#: using_raster_dataman.xml:141 295#, no-c-format 296msgid "" 297"Index (1-based) of band to extract from raster. For more than one band " 298"index, separate with comma (,). If unspecified, all bands of raster will be " 299"extracted." 300msgstr "" 301"Indice (a partire da 1) della banda da estrarre dal raster. Per specificare " 302"più di un indice di banda, separare con una virgola (,). Se non specificato, " 303"saranno estratte tutte le bande." 304 305#. Tag: term 306#: using_raster_dataman.xml:149 307#, no-c-format 308msgid "-t TILE_SIZE" 309msgstr "-t DIMENSIONE_TILE" 310 311#. Tag: para 312#: using_raster_dataman.xml:151 313#, no-c-format 314msgid "" 315"Cut raster into tiles to be inserted one per table row. <varname>TILE_SIZE</" 316"varname> is expressed as WIDTHxHEIGHT or set to the value \"auto\" to allow " 317"the loader to compute an appropriate tile size using the first raster and " 318"applied to all rasters." 319msgstr "" 320 321#. Tag: term 322#: using_raster_dataman.xml:158 323#, no-c-format 324msgid "<term>-P</term>" 325msgstr "" 326 327#. Tag: para 328#: using_raster_dataman.xml:160 329#, no-c-format 330msgid "" 331"Pad right-most and bottom-most tiles to guarantee that all tiles have the " 332"same width and height." 333msgstr "" 334 335#. Tag: term 336#: using_raster_dataman.xml:170 337#, no-c-format 338msgid "-R, --register" 339msgstr "-R, --register" 340 341#. Tag: para 342#: using_raster_dataman.xml:172 343#, no-c-format 344msgid "Register the raster as a filesystem (out-db) raster." 345msgstr "" 346 347#. Tag: para 348#: using_raster_dataman.xml:173 349#, no-c-format 350msgid "" 351"Only the metadata of the raster and path location to the raster is stored in " 352"the database (not the pixels)." 353msgstr "" 354"Nel database vengono salvati solo i metadati e il percorso del raster (non i " 355"pixel)." 356 357#. Tag: term 358#: using_raster_dataman.xml:178 359#, no-c-format 360msgid "<code>-l</code> <varname>OVERVIEW_FACTOR</varname>" 361msgstr "" 362 363#. Tag: para 364#: using_raster_dataman.xml:179 365#, no-c-format 366msgid "" 367"Create overview of the raster. For more than one factor, separate with " 368"comma(,). Overview table name follows the pattern o_<varname>overview " 369"factor</varname>_<varname>table</varname>, where <varname>overview factor</" 370"varname> is a placeholder for numerical overview factor and <varname>table</" 371"varname> is replaced with the base table name. Created overview is stored in " 372"the database and is not affected by -R. Note that your generated sql file " 373"will contain both the main table and overview tables." 374msgstr "" 375 376#. Tag: term 377#: using_raster_dataman.xml:187 378#, no-c-format 379msgid "-N <varname>NODATA</varname>" 380msgstr "-N <varname>NODATA</varname>" 381 382#. Tag: para 383#: using_raster_dataman.xml:189 384#, no-c-format 385msgid "NODATA value to use on bands without a NODATA value." 386msgstr "Valore da usare come NODATA per le bande senza un valore NODATA." 387 388#. Tag: term 389#: using_raster_dataman.xml:201 390#, no-c-format 391msgid "Optional parameters used to manipulate database objects" 392msgstr "Parametri opzionali usati per la manipolazione di oggetti del database" 393 394#. Tag: term 395#: using_raster_dataman.xml:206 396#, no-c-format 397msgid "-f COLUMN" 398msgstr "-f COLONNA" 399 400#. Tag: para 401#: using_raster_dataman.xml:208 402#, no-c-format 403msgid "Specify name of destination raster column, default is 'rast'" 404msgstr "" 405"Specifica il nome della colonna di destinazione per i raster. Il default è " 406"'rast'." 407 408#. Tag: term 409#: using_raster_dataman.xml:214 410#, no-c-format 411msgid "<term>-F</term>" 412msgstr "<term>-F</term>" 413 414#. Tag: para 415#: using_raster_dataman.xml:216 416#, no-c-format 417msgid "Add a column with the name of the file" 418msgstr "Aggiunge una colonna con il nome del file" 419 420#. Tag: term 421#: using_raster_dataman.xml:221 422#, no-c-format 423msgid "-n COLUMN" 424msgstr "" 425 426#. Tag: para 427#: using_raster_dataman.xml:223 428#, no-c-format 429msgid "Specify the name of the filename column. Implies -F." 430msgstr "" 431 432#. Tag: term 433#: using_raster_dataman.xml:228 434#, no-c-format 435msgid "<term>-q</term>" 436msgstr "<term>-q</term>" 437 438#. Tag: para 439#: using_raster_dataman.xml:230 440#, no-c-format 441msgid "Wrap PostgreSQL identifiers in quotes." 442msgstr "" 443 444#. Tag: term 445#: using_raster_dataman.xml:235 446#, no-c-format 447msgid "<term>-I</term>" 448msgstr "<term>-I</term>" 449 450#. Tag: para 451#: using_raster_dataman.xml:237 452#, no-c-format 453msgid "Create a GiST index on the raster column." 454msgstr "Crea un indice GiST sulla colonna raster." 455 456#. Tag: term 457#: using_raster_dataman.xml:244 458#, no-c-format 459msgid "<term>-M</term>" 460msgstr "<term>-M</term>" 461 462#. Tag: para 463#: using_raster_dataman.xml:246 464#, no-c-format 465msgid "Vacuum analyze the raster table." 466msgstr "" 467 468#. Tag: term 469#: using_raster_dataman.xml:254 470#, no-c-format 471msgid "<term>-k</term>" 472msgstr "<term>-k</term>" 473 474#. Tag: para 475#: using_raster_dataman.xml:256 476#, no-c-format 477msgid "Skip NODATA value checks for each raster band." 478msgstr "" 479 480#. Tag: term 481#: using_raster_dataman.xml:264 482#, no-c-format 483msgid "-T <varname>tablespace</varname>" 484msgstr "-T <varname>tablespace</varname>" 485 486#. Tag: para 487#: using_raster_dataman.xml:266 488#, no-c-format 489msgid "" 490"Specify the tablespace for the new table. Note that indices (including the " 491"primary key) will still use the default tablespace unless the -X flag is " 492"also used." 493msgstr "" 494"Specificare il tablespace per la nuova tabella. Notare che gli indici " 495"(compresa la chiave primaria) useranno sempre il tablespace di default, a " 496"meno che non venga usato anche il flag -X." 497 498#. Tag: term 499#: using_raster_dataman.xml:275 500#, no-c-format 501msgid "-X <varname>tablespace</varname>" 502msgstr "-X <varname>tablespace</varname>" 503 504#. Tag: para 505#: using_raster_dataman.xml:277 506#, no-c-format 507msgid "" 508"Specify the tablespace for the table's new index. This applies to the " 509"primary key and the spatial index if the -I flag is used." 510msgstr "" 511"Specifica il tablespace per il nuovo indice della tabella. Si applica alla " 512"chiave primaria e all'indice spaziale se viene usato il flag -I" 513 514#. Tag: term 515#: using_raster_dataman.xml:286 516#, no-c-format 517msgid "<term>-Y</term>" 518msgstr "<term>-Y</term>" 519 520#. Tag: para 521#: using_raster_dataman.xml:288 522#, no-c-format 523msgid "Use copy statements instead of insert statements." 524msgstr "Utilizza comandi di copia anziché di inserimento." 525 526#. Tag: term 527#: using_raster_dataman.xml:299 528#, no-c-format 529msgid "<term>-e</term>" 530msgstr "<term>-e</term>" 531 532#. Tag: para 533#: using_raster_dataman.xml:300 534#, no-c-format 535msgid "Execute each statement individually, do not use a transaction." 536msgstr "Esegui ogni comando individualmente, non utilizzare una transazione." 537 538#. Tag: term 539#: using_raster_dataman.xml:304 540#, no-c-format 541msgid "-E ENDIAN" 542msgstr "-E ENDIAN" 543 544#. Tag: para 545#: using_raster_dataman.xml:305 546#, no-c-format 547msgid "" 548"Control endianness of generated binary output of raster; specify 0 for XDR " 549"and 1 for NDR (default); only NDR output is supported now" 550msgstr "" 551"Controlla l'ordine dei byte prodotti nell'output binario del raster: " 552"specificare 0 per XDR e 1 per NDR (il default). Al momento viene supportato " 553"solo lo NDR." 554 555#. Tag: term 556#: using_raster_dataman.xml:309 557#, no-c-format 558msgid "-V <varname>version</varname>" 559msgstr "-V <varname>versione</varname>" 560 561#. Tag: para 562#: using_raster_dataman.xml:310 563#, no-c-format 564msgid "" 565"Specify version of output format. Default is 0. Only 0 is supported at this " 566"time." 567msgstr "" 568"Specifica la versione del formato in uscita. Il default è 0. Al momento 0 è " 569"l'unico supportato." 570 571#. Tag: para 572#: using_raster_dataman.xml:313 573#, no-c-format 574msgid "" 575"An example session using the loader to create an input file and uploading it " 576"chunked in 100x100 tiles might look like this:" 577msgstr "" 578"Una sessione di esempio che utilizzi il loader per creare un file di input e " 579"per caricarlo a pezzi di tile 100x100 potrebbe essere il seguente:" 580 581#. Tag: para 582#: using_raster_dataman.xml:314 583#, no-c-format 584msgid "" 585"You can leave the schema name out e.g <varname>demelevation</varname> " 586"instead of <varname>public.demelevation</varname> and the raster table will " 587"be created in the default schema of the database or user" 588msgstr "" 589"Potete omettere il nome dello schema, per esempio <varname>demelevation</" 590"varname> al posto di <varname>public.demelevation</varname> e la tabella " 591"raster sarà creata nello schema di default del database o dell'utente" 592 593#. Tag: programlisting 594#: using_raster_dataman.xml:316 595#, no-c-format 596msgid "" 597"raster2pgsql -s 4326 -I -C -M *.tif -F -t 100x100 public.demelevation > elev." 598"sql\n" 599"psql -d gisdb -f elev.sql" 600msgstr "" 601 602#. Tag: para 603#: using_raster_dataman.xml:318 604#, no-c-format 605msgid "A conversion and upload can be done all in one step using UNIX pipes:" 606msgstr "" 607"La conversione e il caricamento possono essere eseguiti in un unico " 608"passaggio tramite le pipe UNIX:" 609 610#. Tag: programlisting 611#: using_raster_dataman.xml:320 612#, no-c-format 613msgid "" 614"raster2pgsql -s 4326 -I -C -M *.tif -F -t 100x100 public.demelevation | psql " 615"-d gisdb" 616msgstr "" 617 618#. Tag: para 619#: using_raster_dataman.xml:322 620#, no-c-format 621msgid "" 622"Load rasters Massachusetts state plane meters aerial tiles into a schema " 623"called <varname>aerial</varname> and create a full view, 2 and 4 level " 624"overview tables, use copy mode for inserting (no intermediary file just " 625"straight to db), and -e don't force everything in a transaction (good if you " 626"want to see data in tables right away without waiting). Break up the rasters " 627"into 128x128 pixel tiles and apply raster constraints. Use copy mode instead " 628"of table insert. (-F) Include a field called filename to hold the name of " 629"the file the tiles were cut from." 630msgstr "" 631 632#. Tag: programlisting 633#: using_raster_dataman.xml:324 634#, no-c-format 635msgid "" 636"raster2pgsql -I -C -e -Y -F -s 26986 -t 128x128 -l 2,4 bostonaerials2008/*." 637"jpg aerials.boston | psql -U postgres -d gisdb -h localhost -p 5432" 638msgstr "" 639"raster2pgsql -I -C -e -Y -F -s 26986 -t 128x128 -l 2,4 bostonaerials2008/*." 640"jpg aerials.boston | psql -U postgres -d gisdb -h localhost -p 5432" 641 642#. Tag: programlisting 643#: using_raster_dataman.xml:326 644#, no-c-format 645msgid "" 646"--get a list of raster types supported:\n" 647"raster2pgsql -G" 648msgstr "" 649"--ottieni la lista dei tipi raster supportati:\n" 650"raster2pgsql -G" 651 652#. Tag: para 653#: using_raster_dataman.xml:328 654#, no-c-format 655msgid "The -G commands outputs a list something like" 656msgstr "Il parametro -G restituirà un elenco tipo" 657 658#. Tag: screen 659#: using_raster_dataman.xml:329 660#, no-c-format 661msgid "" 662"Available GDAL raster formats:\n" 663" Virtual Raster\n" 664" GeoTIFF\n" 665" National Imagery Transmission Format\n" 666" Raster Product Format TOC format\n" 667" ECRG TOC format\n" 668" Erdas Imagine Images (.img)\n" 669" CEOS SAR Image\n" 670" CEOS Image\n" 671" JAXA PALSAR Product Reader (Level 1.1/1.5)\n" 672" Ground-based SAR Applications Testbed File Format (.gff)\n" 673" ELAS\n" 674" Arc/Info Binary Grid\n" 675" Arc/Info ASCII Grid\n" 676" GRASS ASCII Grid\n" 677" SDTS Raster\n" 678" DTED Elevation Raster\n" 679" Portable Network Graphics\n" 680" JPEG JFIF\n" 681" In Memory Raster\n" 682" Japanese DEM (.mem)\n" 683" Graphics Interchange Format (.gif)\n" 684" Graphics Interchange Format (.gif)\n" 685" Envisat Image Format\n" 686" Maptech BSB Nautical Charts\n" 687" X11 PixMap Format\n" 688" MS Windows Device Independent Bitmap\n" 689" SPOT DIMAP\n" 690" AirSAR Polarimetric Image\n" 691" RadarSat 2 XML Product\n" 692" PCIDSK Database File\n" 693" PCRaster Raster File\n" 694" ILWIS Raster Map\n" 695" SGI Image File Format 1.0\n" 696" SRTMHGT File Format\n" 697" Leveller heightfield\n" 698" Terragen heightfield\n" 699" USGS Astrogeology ISIS cube (Version 3)\n" 700" USGS Astrogeology ISIS cube (Version 2)\n" 701" NASA Planetary Data System\n" 702" EarthWatch .TIL\n" 703" ERMapper .ers Labelled\n" 704" NOAA Polar Orbiter Level 1b Data Set\n" 705" FIT Image\n" 706" GRIdded Binary (.grb)\n" 707" Raster Matrix Format\n" 708" EUMETSAT Archive native (.nat)\n" 709" Idrisi Raster A.1\n" 710" Intergraph Raster\n" 711" Golden Software ASCII Grid (.grd)\n" 712" Golden Software Binary Grid (.grd)\n" 713" Golden Software 7 Binary Grid (.grd)\n" 714" COSAR Annotated Binary Matrix (TerraSAR-X)\n" 715" TerraSAR-X Product\n" 716" DRDC COASP SAR Processor Raster\n" 717" R Object Data Store\n" 718" Portable Pixmap Format (netpbm)\n" 719" USGS DOQ (Old Style)\n" 720" USGS DOQ (New Style)\n" 721" ENVI .hdr Labelled\n" 722" ESRI .hdr Labelled\n" 723" Generic Binary (.hdr Labelled)\n" 724" PCI .aux Labelled\n" 725" Vexcel MFF Raster\n" 726" Vexcel MFF2 (HKV) Raster\n" 727" Fuji BAS Scanner Image\n" 728" GSC Geogrid\n" 729" EOSAT FAST Format\n" 730" VTP .bt (Binary Terrain) 1.3 Format\n" 731" Erdas .LAN/.GIS\n" 732" Convair PolGASP\n" 733" Image Data and Analysis\n" 734" NLAPS Data Format\n" 735" Erdas Imagine Raw\n" 736" DIPEx\n" 737" FARSITE v.4 Landscape File (.lcp)\n" 738" NOAA Vertical Datum .GTX\n" 739" NADCON .los/.las Datum Grid Shift\n" 740" NTv2 Datum Grid Shift\n" 741" ACE2\n" 742" Snow Data Assimilation System\n" 743" Swedish Grid RIK (.rik)\n" 744" USGS Optional ASCII DEM (and CDED)\n" 745" GeoSoft Grid Exchange Format\n" 746" Northwood Numeric Grid Format .grd/.tab\n" 747" Northwood Classified Grid Format .grc/.tab\n" 748" ARC Digitized Raster Graphics\n" 749" Standard Raster Product (ASRP/USRP)\n" 750" Magellan topo (.blx)\n" 751" SAGA GIS Binary Grid (.sdat)\n" 752" Kml Super Overlay\n" 753" ASCII Gridded XYZ\n" 754" HF2/HFZ heightfield raster\n" 755" OziExplorer Image File\n" 756" USGS LULC Composite Theme Grid\n" 757" Arc/Info Export E00 GRID\n" 758" ZMap Plus Grid\n" 759" NOAA NGS Geoid Height Grids" 760msgstr "" 761"Available GDAL raster formats:\n" 762" Virtual Raster\n" 763" GeoTIFF\n" 764" National Imagery Transmission Format\n" 765" Raster Product Format TOC format\n" 766" ECRG TOC format\n" 767" Erdas Imagine Images (.img)\n" 768" CEOS SAR Image\n" 769" CEOS Image\n" 770" JAXA PALSAR Product Reader (Level 1.1/1.5)\n" 771" Ground-based SAR Applications Testbed File Format (.gff)\n" 772" ELAS\n" 773" Arc/Info Binary Grid\n" 774" Arc/Info ASCII Grid\n" 775" GRASS ASCII Grid\n" 776" SDTS Raster\n" 777" DTED Elevation Raster\n" 778" Portable Network Graphics\n" 779" JPEG JFIF\n" 780" In Memory Raster\n" 781" Japanese DEM (.mem)\n" 782" Graphics Interchange Format (.gif)\n" 783" Graphics Interchange Format (.gif)\n" 784" Envisat Image Format\n" 785" Maptech BSB Nautical Charts\n" 786" X11 PixMap Format\n" 787" MS Windows Device Independent Bitmap\n" 788" SPOT DIMAP\n" 789" AirSAR Polarimetric Image\n" 790" RadarSat 2 XML Product\n" 791" PCIDSK Database File\n" 792" PCRaster Raster File\n" 793" ILWIS Raster Map\n" 794" SGI Image File Format 1.0\n" 795" SRTMHGT File Format\n" 796" Leveller heightfield\n" 797" Terragen heightfield\n" 798" USGS Astrogeology ISIS cube (Version 3)\n" 799" USGS Astrogeology ISIS cube (Version 2)\n" 800" NASA Planetary Data System\n" 801" EarthWatch .TIL\n" 802" ERMapper .ers Labelled\n" 803" NOAA Polar Orbiter Level 1b Data Set\n" 804" FIT Image\n" 805" GRIdded Binary (.grb)\n" 806" Raster Matrix Format\n" 807" EUMETSAT Archive native (.nat)\n" 808" Idrisi Raster A.1\n" 809" Intergraph Raster\n" 810" Golden Software ASCII Grid (.grd)\n" 811" Golden Software Binary Grid (.grd)\n" 812" Golden Software 7 Binary Grid (.grd)\n" 813" COSAR Annotated Binary Matrix (TerraSAR-X)\n" 814" TerraSAR-X Product\n" 815" DRDC COASP SAR Processor Raster\n" 816" R Object Data Store\n" 817" Portable Pixmap Format (netpbm)\n" 818" USGS DOQ (Old Style)\n" 819" USGS DOQ (New Style)\n" 820" ENVI .hdr Labelled\n" 821" ESRI .hdr Labelled\n" 822" Generic Binary (.hdr Labelled)\n" 823" PCI .aux Labelled\n" 824" Vexcel MFF Raster\n" 825" Vexcel MFF2 (HKV) Raster\n" 826" Fuji BAS Scanner Image\n" 827" GSC Geogrid\n" 828" EOSAT FAST Format\n" 829" VTP .bt (Binary Terrain) 1.3 Format\n" 830" Erdas .LAN/.GIS\n" 831" Convair PolGASP\n" 832" Image Data and Analysis\n" 833" NLAPS Data Format\n" 834" Erdas Imagine Raw\n" 835" DIPEx\n" 836" FARSITE v.4 Landscape File (.lcp)\n" 837" NOAA Vertical Datum .GTX\n" 838" NADCON .los/.las Datum Grid Shift\n" 839" NTv2 Datum Grid Shift\n" 840" ACE2\n" 841" Snow Data Assimilation System\n" 842" Swedish Grid RIK (.rik)\n" 843" USGS Optional ASCII DEM (and CDED)\n" 844" GeoSoft Grid Exchange Format\n" 845" Northwood Numeric Grid Format .grd/.tab\n" 846" Northwood Classified Grid Format .grc/.tab\n" 847" ARC Digitized Raster Graphics\n" 848" Standard Raster Product (ASRP/USRP)\n" 849" Magellan topo (.blx)\n" 850" SAGA GIS Binary Grid (.sdat)\n" 851" Kml Super Overlay\n" 852" ASCII Gridded XYZ\n" 853" HF2/HFZ heightfield raster\n" 854" OziExplorer Image File\n" 855" USGS LULC Composite Theme Grid\n" 856" Arc/Info Export E00 GRID\n" 857" ZMap Plus Grid\n" 858" NOAA NGS Geoid Height Grids" 859 860#. Tag: title 861#: using_raster_dataman.xml:332 862#, no-c-format 863msgid "Creating rasters using PostGIS raster functions" 864msgstr "Creazione di raster tramite le funzioni raster di PostGIS" 865 866#. Tag: para 867#: using_raster_dataman.xml:333 868#, no-c-format 869msgid "" 870"On many occasions, you'll want to create rasters and raster tables right in " 871"the database. There are a plethora of functions to do that. The general " 872"steps to follow." 873msgstr "" 874"In varie occasioni vorrete creare raster e tabelle raster direttamente nel " 875"database. Per questo esiste una pletora di funzioni. Questi sono i passi " 876"generali da seguire." 877 878#. Tag: para 879#: using_raster_dataman.xml:335 880#, no-c-format 881msgid "" 882"Create a table with a raster column to hold the new raster records which can " 883"be accomplished with:" 884msgstr "" 885"Creare una tabella con una colonna raster per contenere i nuovi valori " 886"raster può essere ottenuto da:" 887 888#. Tag: programlisting 889#: using_raster_dataman.xml:336 890#, no-c-format 891msgid "CREATE TABLE myrasters(rid serial primary key, rast raster);" 892msgstr "CREATE TABLE myrasters(rid serial primary key, rast raster);" 893 894#. Tag: para 895#: using_raster_dataman.xml:339 896#, no-c-format 897msgid "" 898"There are many functions to help with that goal. If you are creating rasters " 899"not as a derivative of other rasters, you will want to start with: <xref " 900"linkend=\"RT_ST_MakeEmptyRaster\"/>, followed by <xref linkend=" 901"\"RT_ST_AddBand\"/>" 902msgstr "" 903"Esistono molte funzioni per assitervi verso questo obiettivo. Se state " 904"creando un raster non derivato da altri raster, inizierete con: <xref " 905"linkend=\"RT_ST_MakeEmptyRaster\"/>, seguito da <xref linkend=\"RT_ST_AddBand" 906"\"/>" 907 908#. Tag: para 909#: using_raster_dataman.xml:341 910#, no-c-format 911msgid "" 912"You can also create rasters from geometries. To achieve that you'll want to " 913"use <xref linkend=\"RT_ST_AsRaster\"/> perhaps accompanied with other " 914"functions such as <xref linkend=\"RT_ST_Union\"/> or <xref linkend=" 915"\"RT_ST_MapAlgebraFct2\"/> or any of the family of other map algebra " 916"functions." 917msgstr "" 918"Potete anche creare raster a partire dalle geometria. Per questo userete " 919"<xref linkend=\"RT_ST_AsRaster\"/>, magari accompagnato da altre funzioni " 920"come <xref linkend=\"RT_ST_Union\"/> o <xref linkend=" 921"\"RT_ST_MapAlgebraFct2\"/>, o qualsiasi altra delle funzioni di algebra " 922"sulle mappe." 923 924#. Tag: para 925#: using_raster_dataman.xml:343 926#, no-c-format 927msgid "" 928"There are even many more options for creating new raster tables from " 929"existing tables. For example you can create a raster table in a different " 930"projection from an existing one using <xref linkend=\"RT_ST_Transform\"/>" 931msgstr "" 932"Vi sono poi ancora più opzioni per creare nuove tabelle raster a partire da " 933"tabelle esistenti. Per esempio potete creare una tabella raster in una " 934"proiezione diversa da una tabella esistente usando <xref linkend=" 935"\"RT_ST_Transform\"/>" 936 937#. Tag: para 938#: using_raster_dataman.xml:345 939#, no-c-format 940msgid "" 941"Once you are done populating your table initially, you'll want to create a " 942"spatial index on the raster column with something like:" 943msgstr "" 944"Una volta inseriti dei valori iniziali nella tabella, vorrete creare un " 945"indice spaziale sulla colonna raster, con un comando tipo:" 946 947#. Tag: programlisting 948#: using_raster_dataman.xml:346 949#, no-c-format 950msgid "" 951"CREATE INDEX myrasters_rast_st_convexhull_idx ON myrasters USING " 952"gist( ST_ConvexHull(rast) );" 953msgstr "" 954"CREATE INDEX myrasters_rast_st_convexhull_idx ON myrasters USING " 955"gist( ST_ConvexHull(rast) );" 956 957#. Tag: para 958#: using_raster_dataman.xml:347 959#, no-c-format 960msgid "" 961"Note the use of <xref linkend=\"RT_ST_ConvexHull\"/> since most raster " 962"operators are based on the convex hull of the rasters." 963msgstr "" 964 965#. Tag: para 966#: using_raster_dataman.xml:348 967#, no-c-format 968msgid "" 969"Pre-2.0 versions of PostGIS raster were based on the envelop rather than the " 970"convex hull. For the spatial indexes to work properly you'll need to drop " 971"those and replace with convex hull based index." 972msgstr "" 973 974#. Tag: para 975#: using_raster_dataman.xml:349 976#, no-c-format 977msgid "" 978"Apply raster constraints using <xref linkend=\"RT_AddRasterConstraints\"/>" 979msgstr "" 980 981#. Tag: title 982#: using_raster_dataman.xml:354 983#, no-c-format 984msgid "Using \"out db\" cloud rasters" 985msgstr "" 986 987#. Tag: para 988#: using_raster_dataman.xml:355 989#, no-c-format 990msgid "" 991"The <varname>raster2pgsql</varname> tool uses GDAL to access raster data, " 992"and can take advantage of a key GDAL feature: the ability to read from " 993"rasters that are <ulink url=\"https://gdal.org/user/virtual_file_systems." 994"html#network-based-file-systems\">stored remotely</ulink> in cloud \"object " 995"stores\" (e.g. AWS S3, Google Cloud Storage)." 996msgstr "" 997 998#. Tag: para 999#: using_raster_dataman.xml:359 1000#, no-c-format 1001msgid "" 1002"Efficient use of cloud stored rasters requires the use of a \"cloud optimized" 1003"\" format. The most well-known and widely used is the \"<ulink url=\"https://" 1004"gdal.org/drivers/raster/cog.html\">cloud optimized GeoTIFF</ulink>\" format. " 1005"Using a non-cloud format, like a JPEG, or an un-tiled TIFF will result in " 1006"very poor performance, as the system will have to download the entire raster " 1007"each time it needs to access a subset." 1008msgstr "" 1009 1010#. Tag: para 1011#: using_raster_dataman.xml:362 1012#, no-c-format 1013msgid "" 1014"First, load your raster into the cloud storage of your choice. Once it is " 1015"loaded, you will have a URI to access it with, either an \"http\" URI, or " 1016"sometimes a URI specific to the service. (e.g., \"s3://bucket/object\"). To " 1017"access non-public buckets, you will need to supply GDAL config options to " 1018"authenticate your connection. Note that this command is <emphasis>reading</" 1019"emphasis> from the cloud raster and <emphasis>writing</emphasis> to the " 1020"database." 1021msgstr "" 1022 1023#. Tag: programlisting 1024#: using_raster_dataman.xml:365 1025#, no-c-format 1026msgid "" 1027"AWS_ACCESS_KEY_ID=xxxxxxxxxxxxxxxxxxxx \\\n" 1028"AWS_SECRET_ACCESS_KEY=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx \\\n" 1029"raster2pgsql \\\n" 1030" -s 990000 \\\n" 1031" -t 256x256 \\\n" 1032" -I \\\n" 1033" -R \\\n" 1034" /vsis3/your.bucket.com/your_file.tif \\\n" 1035" your_table \\\n" 1036" | psql your_db" 1037msgstr "" 1038 1039#. Tag: para 1040#: using_raster_dataman.xml:366 1041#, no-c-format 1042msgid "" 1043"Once the table is loaded, you need to give the database permission to read " 1044"from remote rasters, by setting two permissions, <xref linkend=" 1045"\"postgis_enable_outdb_rasters\"/> and <xref linkend=" 1046"\"postgis_gdal_enabled_drivers\"/>." 1047msgstr "" 1048 1049#. Tag: programlisting 1050#: using_raster_dataman.xml:369 1051#, no-c-format 1052msgid "" 1053"SET postgis.enable_outdb_rasters = true;\n" 1054"SET postgis.gdal_enabled_drivers TO 'ENABLE_ALL';" 1055msgstr "" 1056 1057#. Tag: para 1058#: using_raster_dataman.xml:370 1059#, no-c-format 1060msgid "" 1061"To make the changes sticky, set them directly on your database. You will " 1062"need to re-connect to experience the new settings." 1063msgstr "" 1064 1065#. Tag: programlisting 1066#: using_raster_dataman.xml:373 1067#, no-c-format 1068msgid "" 1069"ALTER DATABASE your_db SET postgis.enable_outdb_rasters = true;\n" 1070"ALTER DATABASE your_db SET postgis.gdal_enabled_drivers TO 'ENABLE_ALL';" 1071msgstr "" 1072 1073#. Tag: para 1074#: using_raster_dataman.xml:374 1075#, no-c-format 1076msgid "" 1077"For non-public rasters, you may have to provide access keys to read from the " 1078"cloud rasters. The same keys you used to write the <varname>raster2pgsql</" 1079"varname> call can be set for use inside the database, with the <xref linkend=" 1080"\"postgis_gdal_vsi_options\"/> configuration. Note that multiple options can " 1081"be set by space-separating the <varname>key=value</varname> pairs." 1082msgstr "" 1083 1084#. Tag: programlisting 1085#: using_raster_dataman.xml:377 1086#, no-c-format 1087msgid "" 1088"SET postgis.gdal_vsi_options = 'AWS_ACCESS_KEY_ID=xxxxxxxxxxxxxxxxxxxx\n" 1089"AWS_SECRET_ACCESS_KEY=xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx';" 1090msgstr "" 1091 1092#. Tag: para 1093#: using_raster_dataman.xml:378 1094#, no-c-format 1095msgid "" 1096"Once you have the data loaded and permissions set you can interact with the " 1097"raster table like any other raster table, using the same functions. The " 1098"database will handle all the mechanics of connecting to the cloud data when " 1099"it needs to read pixel data." 1100msgstr "" 1101 1102#. Tag: title 1103#: using_raster_dataman.xml:384 1104#, no-c-format 1105msgid "Raster Catalogs" 1106msgstr "Cataloghi raster" 1107 1108#. Tag: para 1109#: using_raster_dataman.xml:385 1110#, no-c-format 1111msgid "" 1112"There are two raster catalog views that come packaged with PostGIS. Both " 1113"views utilize information embedded in the constraints of the raster tables. " 1114"As a result the catalog views are always consistent with the raster data in " 1115"the tables since the constraints are enforced." 1116msgstr "" 1117"Esistono due tipi di viste dei cataloghi raster fornite con PostGIS. " 1118"Entrambe le viste utilizzano informazioni contenute nei dati sui limiti " 1119"delle tabelle raster. Da ciò risulta che le viste dei cataloghi sono sempre " 1120"consistenti con i dati raster nelle tabelle, dato che sono considerati i " 1121"limiti di queste." 1122 1123#. Tag: para 1124#: using_raster_dataman.xml:389 1125#, no-c-format 1126msgid "" 1127"<varname>raster_columns</varname> this view catalogs all the raster table " 1128"columns in your database." 1129msgstr "" 1130"<varname>raster_columns</varname> questa vista riporta il catalogo di tutte " 1131"le colonne raster nel vostro database." 1132 1133#. Tag: para 1134#: using_raster_dataman.xml:392 1135#, no-c-format 1136msgid "" 1137"<varname>raster_overviews</varname> this view catalogs all the raster table " 1138"columns in your database that serve as overviews for a finer grained table. " 1139"Tables of this type are generated when you use the <varname>-l</varname> " 1140"switch during load." 1141msgstr "" 1142"<varname>raster_overviews</varname> questa vista elenca tutte le colonne " 1143"raste di tabelle nel vostro database che sono utilizzate come vista " 1144"d'insieme per una tabella con maggiori dettagli. Le tabelle di questo tipo " 1145"sono generate quando utilizzate l'opzione <varname>-l</varname> durante il " 1146"caricamento." 1147 1148#. Tag: title 1149#: using_raster_dataman.xml:396 1150#, no-c-format 1151msgid "Raster Columns Catalog" 1152msgstr "Catalogo delle colonne raster" 1153 1154#. Tag: para 1155#: using_raster_dataman.xml:397 1156#, no-c-format 1157msgid "" 1158"The <varname>raster_columns</varname> is a catalog of all raster table " 1159"columns in your database that are of type raster. It is a view utilizing the " 1160"constraints on the tables so the information is always consistent even if " 1161"you restore one raster table from a backup of another database. The " 1162"following columns exist in the <varname>raster_columns</varname> catalog." 1163msgstr "" 1164" <varname>raster_columns</varname> è un catalogo di tutte le colonne di " 1165"tabelle che nel vostro database sono di tipo raster. E' una vista che " 1166"utilizza i limiti applicati alle tabelle, per cui le informazioni sono " 1167"sempre congruenti, anche se ripristinate una tabella raster dal backup di un " 1168"altro database. Il catalogo <varname>raster_columns</varname> contiene le " 1169"seguenti colonne." 1170 1171#. Tag: para 1172#: using_raster_dataman.xml:399 1173#, no-c-format 1174msgid "" 1175"If you created your tables not with the loader or forgot to specify the " 1176"<varname>-C</varname> flag during load, you can enforce the constraints " 1177"after the fact using <xref linkend=\"RT_AddRasterConstraints\"/> so that the " 1178"<varname>raster_columns</varname> catalog registers the common information " 1179"about your raster tiles." 1180msgstr "" 1181"Se non avete creato le tabelle con il loader o vi siete dimenticati di " 1182"specificare l'opzione <varname>-C</varname> durante il caricamento, potete " 1183"far applicare i limiti a cose fatte utilizzando <xref linkend=" 1184"\"RT_AddRasterConstraints\"/>, di modo che il catalogo " 1185"<varname>raster_columns</varname> registri le informazioni sulle vostre tile " 1186"raster." 1187 1188#. Tag: para 1189#: using_raster_dataman.xml:404 1190#, no-c-format 1191msgid "" 1192"<varname>r_table_catalog</varname> The database the table is in. This will " 1193"always read the current database." 1194msgstr "" 1195"<varname>r_table_catalog</varname> Il database in cui si trova la tabella. " 1196"Conterrà sempre il database corrente." 1197 1198#. Tag: para 1199#: using_raster_dataman.xml:407 1200#, no-c-format 1201msgid "" 1202"<varname>r_table_schema</varname> The database schema the raster table " 1203"belongs to." 1204msgstr "" 1205"<varname>r_table_schema</varname> Lo schema database cui la tabella raster " 1206"appartiene." 1207 1208#. Tag: para 1209#: using_raster_dataman.xml:410 1210#, no-c-format 1211msgid "<varname>r_table_name</varname> raster table" 1212msgstr "<varname>r_table_name</varname> tabella raster" 1213 1214#. Tag: para 1215#: using_raster_dataman.xml:413 1216#, no-c-format 1217msgid "" 1218"<varname>r_raster_column</varname> the column in the <varname>r_table_name</" 1219"varname> table that is of type raster. There is nothing in PostGIS " 1220"preventing you from having multiple raster columns per table so its possible " 1221"to have a raster table listed multiple times with a different raster column " 1222"for each." 1223msgstr "" 1224"<varname>r_raster_column</varname> la colonna nella tabella " 1225"<varname>r_table_name</varname> che è di tipo raster. Nulla in PostGIS vi " 1226"impedisce di avere più colonne raster per tabella, per cui è possibile avere " 1227"una tabella raster elencata più volte con il riferimento ogni volta a una " 1228"colonna raster differente.." 1229 1230#. Tag: para 1231#: using_raster_dataman.xml:416 1232#, no-c-format 1233msgid "" 1234"<varname>srid</varname> The spatial reference identifier of the raster. " 1235"Should be an entry in the <xref linkend=\"spatial_ref_sys\"/>." 1236msgstr "" 1237"<varname>srid</varname> L'identificatore del sistema di riferimento spaziale " 1238"del raster. Dovrebbe essere una voce di <xref linkend=\"spatial_ref_sys\"/>." 1239 1240#. Tag: para 1241#: using_raster_dataman.xml:419 1242#, no-c-format 1243msgid "" 1244"<varname>scale_x</varname> The scaling between geometric spatial coordinates " 1245"and pixel. This is only available if all tiles in the raster column have the " 1246"same <varname>scale_x</varname> and this constraint is applied. Refer to " 1247"<xref linkend=\"RT_ST_ScaleX\"/> for more details." 1248msgstr "" 1249"<varname>scale_x</varname> Il rapporto di scala tra le coordinate " 1250"geometriche e il pixel, disponibile solo se tutte le tile nella colonna " 1251"raster hanno lo stesso valore di <varname>scale_x</varname> e questo limite " 1252"è applicato. Si rimanda è <xref linkend=\"RT_ST_ScaleX\"/> per ulteriori " 1253"dettagli." 1254 1255#. Tag: para 1256#: using_raster_dataman.xml:422 1257#, no-c-format 1258msgid "" 1259"<varname>scale_y</varname> The scaling between geometric spatial coordinates " 1260"and pixel. This is only available if all tiles in the raster column have the " 1261"same <varname>scale_y</varname> and the <varname>scale_y</varname> " 1262"constraint is applied. Refer to <xref linkend=\"RT_ST_ScaleY\"/> for more " 1263"details." 1264msgstr "" 1265"<varname>scale_y</varname> Il rapporto di scala tra le coordinate " 1266"geometriche e il pixel, disponibile solo se tutte le tile nella colonna " 1267"raster hanno lo stesso valore di <varname>scale_y</varname> e questo limite " 1268"è applicato. Si rimanda è <xref linkend=\"RT_ST_ScaleY\"/> per ulteriori " 1269"dettagli." 1270 1271#. Tag: para 1272#: using_raster_dataman.xml:425 1273#, no-c-format 1274msgid "" 1275"<varname>blocksize_x</varname> The width (number of pixels across) of each " 1276"raster tile . Refer to <xref linkend=\"RT_ST_Width\"/> for more details." 1277msgstr "" 1278"<varname>blocksize_x</varname> La larghezza (come numero di pixel in " 1279"orizzontale) di ogni tile raster. Si rimanda a <xref linkend=\"RT_ST_Width\"/" 1280"> per ulteriori dettagli." 1281 1282#. Tag: para 1283#: using_raster_dataman.xml:428 1284#, no-c-format 1285msgid "" 1286"<varname>blocksize_y</varname> The width (number of pixels down) of each " 1287"raster tile . Refer to <xref linkend=\"RT_ST_Height\"/> for more details." 1288msgstr "" 1289"<varname>blocksize_y</varname> L'altezza (number of pixels in verticale) di " 1290"ogni tile raster. Si rimanda a <xref linkend=\"RT_ST_Height\"/> per " 1291"ulteriori dettagli." 1292 1293#. Tag: para 1294#: using_raster_dataman.xml:431 1295#, no-c-format 1296msgid "" 1297"<varname>same_alignment</varname> A boolean that is true if all the raster " 1298"tiles have the same alignment . Refer to <xref linkend=\"RT_ST_SameAlignment" 1299"\"/> for more details." 1300msgstr "" 1301"<varname>stesso_allineamento</varname> Variabile booleana pari a \"vero\" se " 1302"tutte le tile raster hanno lo stesso allineamento. Si rimanda a <xref " 1303"linkend=\"RT_ST_SameAlignment\"/> per ulteriori dettagli." 1304 1305#. Tag: para 1306#: using_raster_dataman.xml:434 1307#, no-c-format 1308msgid "" 1309"<varname>regular_blocking</varname> If the raster column has the spatially " 1310"unique and coverage tile constraints, the value with be TRUE. Otherwise, it " 1311"will be FALSE." 1312msgstr "" 1313 1314#. Tag: para 1315#: using_raster_dataman.xml:437 1316#, no-c-format 1317msgid "" 1318"<varname>num_bands</varname> The number of bands in each tile of your raster " 1319"set. This is the same information as what is provided by" 1320msgstr "" 1321"<varname>numero_bande</varname> Il numero delle bande in ogni tile del set " 1322"di raster. Questa è la stessa informazione fornita da" 1323 1324#. Tag: para 1325#: using_raster_dataman.xml:440 1326#, no-c-format 1327msgid "" 1328"<varname>pixel_types</varname> An array defining the pixel type for each " 1329"band. You will have the same number of elements in this array as you have " 1330"number of bands. The pixel_types are one of the following defined in <xref " 1331"linkend=\"RT_ST_BandPixelType\"/>." 1332msgstr "" 1333"<varname>pixel_types</varname> Un vettore che definisce il tipo di pixel per " 1334"ciascuna banda. In questo vettore avrete un numero di elementi pari al " 1335"numero delle bande. I valori di pixel_types possono essere tra quelli " 1336"definiti in <xref linkend=\"RT_ST_BandPixelType\"/>." 1337 1338#. Tag: para 1339#: using_raster_dataman.xml:443 1340#, no-c-format 1341msgid "" 1342"<varname>nodata_values</varname> An array of double precision numbers " 1343"denoting the <varname>nodata_value</varname> for each band. You will have " 1344"the same number of elements in this array as you have number of bands. These " 1345"numbers define the pixel value for each band that should be ignored for most " 1346"operations. This is similar information provided by <xref linkend=" 1347"\"RT_ST_BandNoDataValue\"/>." 1348msgstr "" 1349"<varname>nodata_values</varname> Un vettore in doppia precisione che spefica " 1350"i valori <varname>nodata_value</varname> per ciascuna banda. Avrete in " 1351"questo vettore un numero di elementi pari al numero di bande. Questi numeri " 1352"definiscono il valore del pixel che per ciascuna banda deve essere ignorato " 1353"nella maggior parte delle operazioni. L'informazion è simile a quella " 1354"fornita da <xref linkend=\"RT_ST_BandNoDataValue\"/>." 1355 1356#. Tag: para 1357#: using_raster_dataman.xml:446 1358#, no-c-format 1359msgid "" 1360"<varname>out_db</varname> An array of boolean flags indicating if the raster " 1361"bands data is maintained outside the database. You will have the same number " 1362"of elements in this array as you have number of bands." 1363msgstr "" 1364 1365#. Tag: para 1366#: using_raster_dataman.xml:449 1367#, no-c-format 1368msgid "" 1369"<varname>extent</varname> This is the extent of all the raster rows in your " 1370"raster set. If you plan to load more data that will change the extent of the " 1371"set, you'll want to run the <xref linkend=\"RT_DropRasterConstraints\"/> " 1372"function before load and then reapply constraints with <xref linkend=" 1373"\"RT_AddRasterConstraints\"/> after load." 1374msgstr "" 1375 1376#. Tag: para 1377#: using_raster_dataman.xml:452 1378#, no-c-format 1379msgid "" 1380"<varname>spatial_index</varname> A boolean that is true if raster column has " 1381"a spatial index." 1382msgstr "" 1383 1384#. Tag: title 1385#: using_raster_dataman.xml:457 1386#, no-c-format 1387msgid "Raster Overviews" 1388msgstr "" 1389 1390#. Tag: para 1391#: using_raster_dataman.xml:458 1392#, no-c-format 1393msgid "" 1394"<varname>raster_overviews</varname> catalogs information about raster table " 1395"columns used for overviews and additional information about them that is " 1396"useful to know when utilizing overviews. Overview tables are cataloged in " 1397"both <varname>raster_columns</varname> and <varname>raster_overviews</" 1398"varname> because they are rasters in their own right but also serve an " 1399"additional special purpose of being a lower resolution caricature of a " 1400"higher resolution table. These are generated along-side the main raster " 1401"table when you use the <varname>-l</varname> switch in raster loading or can " 1402"be generated manually using <xref linkend=\"RT_AddOverviewConstraints\"/>." 1403msgstr "" 1404 1405#. Tag: para 1406#: using_raster_dataman.xml:459 1407#, no-c-format 1408msgid "" 1409"Overview tables contain the same constraints as other raster tables as well " 1410"as additional informational only constraints specific to overviews." 1411msgstr "" 1412 1413#. Tag: para 1414#: using_raster_dataman.xml:460 1415#, no-c-format 1416msgid "" 1417"The information in <varname>raster_overviews</varname> does not duplicate " 1418"the information in <varname>raster_columns</varname>. If you need the " 1419"information about an overview table present in <varname>raster_columns</" 1420"varname> you can join the <varname>raster_overviews</varname> and " 1421"<varname>raster_columns</varname> together to get the full set of " 1422"information you need." 1423msgstr "" 1424 1425#. Tag: para 1426#: using_raster_dataman.xml:461 1427#, no-c-format 1428msgid "Two main reasons for overviews are:" 1429msgstr "" 1430 1431#. Tag: para 1432#: using_raster_dataman.xml:463 1433#, no-c-format 1434msgid "" 1435"Low resolution representation of the core tables commonly used for fast " 1436"mapping zoom-out." 1437msgstr "" 1438 1439#. Tag: para 1440#: using_raster_dataman.xml:464 1441#, no-c-format 1442msgid "" 1443"Computations are generally faster to do on them than their higher resolution " 1444"parents because there are fewer records and each pixel covers more " 1445"territory. Though the computations are not as accurate as the high-res " 1446"tables they support, they can be sufficient in many rule-of-thumb " 1447"computations." 1448msgstr "" 1449 1450#. Tag: para 1451#: using_raster_dataman.xml:467 1452#, no-c-format 1453msgid "" 1454"The <varname>raster_overviews</varname> catalog contains the following " 1455"columns of information." 1456msgstr "" 1457 1458#. Tag: para 1459#: using_raster_dataman.xml:470 1460#, no-c-format 1461msgid "" 1462"<varname>o_table_catalog</varname> The database the overview table is in. " 1463"This will always read the current database." 1464msgstr "" 1465 1466#. Tag: para 1467#: using_raster_dataman.xml:473 1468#, no-c-format 1469msgid "" 1470"<varname>o_table_schema</varname> The database schema the overview raster " 1471"table belongs to." 1472msgstr "" 1473 1474#. Tag: para 1475#: using_raster_dataman.xml:476 1476#, no-c-format 1477msgid "<varname>o_table_name</varname> raster overview table name" 1478msgstr "" 1479 1480#. Tag: para 1481#: using_raster_dataman.xml:479 1482#, no-c-format 1483msgid "" 1484"<varname>o_raster_column</varname> the raster column in the overview table." 1485msgstr "" 1486 1487#. Tag: para 1488#: using_raster_dataman.xml:483 1489#, no-c-format 1490msgid "" 1491"<varname>r_table_catalog</varname> The database the raster table that this " 1492"overview services is in. This will always read the current database." 1493msgstr "" 1494 1495#. Tag: para 1496#: using_raster_dataman.xml:486 1497#, no-c-format 1498msgid "" 1499"<varname>r_table_schema</varname> The database schema the raster table that " 1500"this overview services belongs to." 1501msgstr "" 1502 1503#. Tag: para 1504#: using_raster_dataman.xml:489 1505#, no-c-format 1506msgid "" 1507"<varname>r_table_name</varname> raster table that this overview services." 1508msgstr "" 1509 1510#. Tag: para 1511#: using_raster_dataman.xml:492 1512#, no-c-format 1513msgid "" 1514"<varname>r_raster_column</varname> the raster column that this overview " 1515"column services." 1516msgstr "" 1517 1518#. Tag: para 1519#: using_raster_dataman.xml:495 1520#, no-c-format 1521msgid "" 1522"<varname>overview_factor</varname> - this is the pyramid level of the " 1523"overview table. The higher the number the lower the resolution of the table. " 1524"raster2pgsql if given a folder of images, will compute overview of each " 1525"image file and load separately. Level 1 is assumed and always the original " 1526"file. Level 2 is will have each tile represent 4 of the original. So for " 1527"example if you have a folder of 5000x5000 pixel image files that you chose " 1528"to chunk 125x125, for each image file your base table will have (5000*5000)/" 1529"(125*125) records = 1600, your (l=2) <varname>o_2</varname> table will have " 1530"ceiling(1600/Power(2,2)) = 400 rows, your (l=3) <varname>o_3</varname> will " 1531"have ceiling(1600/Power(2,3) ) = 200 rows. If your pixels aren't divisible " 1532"by the size of your tiles, you'll get some scrap tiles (tiles not completely " 1533"filled). Note that each overview tile generated by raster2pgsql has the same " 1534"number of pixels as its parent, but is of a lower resolution where each " 1535"pixel of it represents (Power(2,overview_factor) pixels of the original)." 1536msgstr "" 1537 1538#. Tag: title 1539#: using_raster_dataman.xml:507 1540#, no-c-format 1541msgid "Building Custom Applications with PostGIS Raster" 1542msgstr "Costruire applicazioni personalizzate con PostGIS Raster" 1543 1544#. Tag: para 1545#: using_raster_dataman.xml:508 1546#, no-c-format 1547msgid "" 1548"The fact that PostGIS raster provides you with SQL functions to render " 1549"rasters in known image formats gives you a lot of options for rendering " 1550"them. For example you can use OpenOffice / LibreOffice for rendering as " 1551"demonstrated in <ulink url=\"http://www.postgresonline.com/journal/" 1552"archives/244-Rendering-PostGIS-Raster-graphics-with-LibreOffice-Base-Reports." 1553"html\">Rendering PostGIS Raster graphics with LibreOffice Base Reports</" 1554"ulink>. In addition you can use a wide variety of languages as demonstrated " 1555"in this section." 1556msgstr "" 1557 1558#. Tag: title 1559#: using_raster_dataman.xml:511 1560#, no-c-format 1561msgid "" 1562"PHP Example Outputting using ST_AsPNG in concert with other raster functions" 1563msgstr "" 1564"Esempio di output in PHP, utilizzando ST_AsPNG assieme ad altre funzioni " 1565"raster" 1566 1567#. Tag: para 1568#: using_raster_dataman.xml:512 1569#, no-c-format 1570msgid "" 1571"In this section, we'll demonstrate how to use the PHP PostgreSQL driver and " 1572"the <xref linkend=\"RT_ST_AsGDALRaster\"/> family of functions to output " 1573"band 1,2,3 of a raster to a PHP request stream that can then be embedded in " 1574"an img src html tag." 1575msgstr "" 1576"In questo paragrafo mostreremo come utilizzare il driver PHP PostgreSQL e la " 1577"famiglia di funzioni <xref linkend=\"RT_ST_AsGDALRaster\"/> per estrarre le " 1578"bande 1,2,3 di un raster a una richiesta PHP che poi può essere inserita in " 1579"un tag src di un'immagine HTML." 1580 1581#. Tag: para 1582#: using_raster_dataman.xml:515 using_raster_dataman.xml:527 1583#, no-c-format 1584msgid "" 1585"The sample query demonstrates how to combine a whole bunch of raster " 1586"functions together to grab all tiles that intersect a particular wgs 84 " 1587"bounding box and then unions with <xref linkend=\"RT_ST_Union\"/> the " 1588"intersecting tiles together returning all bands, transforms to user " 1589"specified projection using <xref linkend=\"RT_ST_Transform\"/>, and then " 1590"outputs the results as a png using <xref linkend=\"RT_ST_AsPNG\"/>." 1591msgstr "" 1592"La query di esempio mostra come combinare varie funzioni raster per " 1593"recuperare tutte le tile che intersecano una data area rettangolare in " 1594"wgs84, unisce le tile risultanti per tutte le bande con <xref linkend=" 1595"\"RT_ST_Union\"/>, le trasforma in una proiezione specificata dall'utente " 1596"con <xref linkend=\"RT_ST_Transform\"/> e infine crea un PNG in uscita " 1597"tramite <xref linkend=\"RT_ST_AsPNG\"/>." 1598 1599#. Tag: para 1600#: using_raster_dataman.xml:518 1601#, no-c-format 1602msgid "" 1603"You would call the below using <programlisting>http://mywebserver/" 1604"test_raster.php?srid=2249</programlisting> to get the raster image in " 1605"Massachusetts state plane feet." 1606msgstr "" 1607"Andreste a chiamare il codice sotto utilizzando <programlisting>http://" 1608"mywebserver/test_raster.php?srid=2249</programlisting> per ottenere " 1609"l'immagine raster proiettata nel sistema di riferimento Massachusetts state " 1610"plane feet." 1611 1612#. Tag: programlisting 1613#: using_raster_dataman.xml:519 1614#, no-c-format 1615msgid "" 1616"<![CDATA[<?php\n" 1617"/** contents of test_raster.php **/\n" 1618"$conn_str ='dbname=mydb host=localhost port=5432 user=myuser " 1619"password=mypwd';\n" 1620"$dbconn = pg_connect($conn_str);\n" 1621"header('Content-Type: image/png');\n" 1622"/**If a particular projection was requested use it otherwise use mass state " 1623"plane meters **/\n" 1624"if (!empty( $_REQUEST['srid'] ) && is_numeric( $_REQUEST['srid']) ){\n" 1625" $input_srid = intval($_REQUEST['srid']);\n" 1626"}\n" 1627"else { $input_srid = 26986; }\n" 1628"/** The set bytea_output may be needed for PostgreSQL 9.0+, but not for 8.4 " 1629"**/\n" 1630"$sql = \"set bytea_output='escape';\n" 1631"SELECT ST_AsPNG(ST_Transform(\n" 1632" ST_AddBand(ST_Union(rast,1), ARRAY[ST_Union(rast,2)," 1633"ST_Union(rast,3)])\n" 1634" ,$input_srid) ) As new_rast\n" 1635" FROM aerials.boston\n" 1636" WHERE\n" 1637" ST_Intersects(rast, ST_Transform(ST_MakeEnvelope(-71.1217, 42.227, " 1638"-71.1210, 42.218,4326),26986) )\";\n" 1639"$result = pg_query($sql);\n" 1640"$row = pg_fetch_row($result);\n" 1641"pg_free_result($result);\n" 1642"if ($row === false) return;\n" 1643"echo pg_unescape_bytea($row[0]);\n" 1644"?>]]>" 1645msgstr "" 1646 1647#. Tag: title 1648#: using_raster_dataman.xml:522 1649#, no-c-format 1650msgid "" 1651"ASP.NET C# Example Outputting using ST_AsPNG in concert with other raster " 1652"functions" 1653msgstr "" 1654"Esempio ASP.NET C# di output con ST_AsPNG, assieme ad altre funzioni raster" 1655 1656#. Tag: para 1657#: using_raster_dataman.xml:523 1658#, no-c-format 1659msgid "" 1660"In this section, we'll demonstrate how to use Npgsql PostgreSQL .NET driver " 1661"and the <xref linkend=\"RT_ST_AsGDALRaster\"/> family of functions to output " 1662"band 1,2,3 of a raster to a PHP request stream that can then be embedded in " 1663"an img src html tag." 1664msgstr "" 1665"In questo paragrafo vi mostreremo come usare il driver .NET Npgsql e la " 1666"famiglia di funzioni <xref linkend=\"RT_ST_AsGDALRaster\"/> per inviare in " 1667"uscita le bande 1,2,3 di un raster a una richiesta PHP che può poi essere " 1668"inserita nel tag src di un immagine html." 1669 1670#. Tag: para 1671#: using_raster_dataman.xml:526 1672#, no-c-format 1673msgid "" 1674"You will need the npgsql .NET PostgreSQL driver for this exercise which you " 1675"can get the latest of from <ulink url=\"http://npgsql.projects.postgresql." 1676"org/\">http://npgsql.projects.postgresql.org/</ulink>. Just download the " 1677"latest and drop into your ASP.NET bin folder and you'll be good to go." 1678msgstr "" 1679"Per questo vi servirà il driver PostgreSQL npgsql .NET. Potete recuperare il " 1680"più recente da <ulink url=\"http://npgsql.projects.postgresql.org/\">http://" 1681"npgsql.projects.postgresql.org/</ulink>. Scaricatelo e salvatelo nella " 1682"vostra cartella bin di ASP.NET per poter lavorare." 1683 1684#. Tag: para 1685#: using_raster_dataman.xml:530 1686#, no-c-format 1687msgid "" 1688"This is same example as <xref linkend=\"RT_PHP_Output\"/> except implemented " 1689"in C#." 1690msgstr "" 1691"Questo è lo stesso esempio illustrato in <xref linkend=\"RT_PHP_Output\"/>, " 1692"implementato in C#." 1693 1694#. Tag: para 1695#: using_raster_dataman.xml:531 1696#, no-c-format 1697msgid "" 1698"You would call the below using <programlisting>http://mywebserver/TestRaster." 1699"ashx?srid=2249</programlisting> to get the raster image in Massachusetts " 1700"state plane feet." 1701msgstr "" 1702"Richiamerete il codice sotto come <programlisting>http://mywebserver/" 1703"TestRaster.ashx?srid=2249</programlisting> per ottenere l'immagine raster " 1704"nel sistema di riferimento Massachusetts state plane feet." 1705 1706#. Tag: programlisting 1707#: using_raster_dataman.xml:532 1708#, no-c-format 1709msgid "" 1710"-- web.config connection string section --\n" 1711"<![CDATA[<connectionStrings>\n" 1712" <add name=\"DSN\"\n" 1713" connectionString=\"server=localhost;database=mydb;Port=5432;User " 1714"Id=myuser;password=mypwd\"/>\n" 1715"</connectionStrings>]]>" 1716msgstr "" 1717 1718#. Tag: programlisting 1719#: using_raster_dataman.xml:533 1720#, no-c-format 1721msgid "" 1722"// Code for TestRaster.ashx\n" 1723"<![CDATA[<%@ WebHandler Language=\"C#\" Class=\"TestRaster\" %>\n" 1724"using System;\n" 1725"using System.Data;\n" 1726"using System.Web;\n" 1727"using Npgsql;\n" 1728"\n" 1729"public class TestRaster : IHttpHandler\n" 1730"{\n" 1731" public void ProcessRequest(HttpContext context)\n" 1732" {\n" 1733"\n" 1734" context.Response.ContentType = \"image/png\";\n" 1735" context.Response.BinaryWrite(GetResults(context));\n" 1736"\n" 1737" }\n" 1738"\n" 1739" public bool IsReusable {\n" 1740" get { return false; }\n" 1741" }\n" 1742"\n" 1743" public byte[] GetResults(HttpContext context)\n" 1744" {\n" 1745" byte[] result = null;\n" 1746" NpgsqlCommand command;\n" 1747" string sql = null;\n" 1748" int input_srid = 26986;\n" 1749" try {\n" 1750" using (NpgsqlConnection conn = new " 1751"NpgsqlConnection(System.Configuration.ConfigurationManager." 1752"ConnectionStrings[\"DSN\"].ConnectionString)) {\n" 1753" conn.Open();\n" 1754"\n" 1755" if (context.Request[\"srid\"] != null)\n" 1756" {\n" 1757" input_srid = Convert.ToInt32(context.Request[\"srid" 1758"\"]);\n" 1759" }\n" 1760" sql = @\"SELECT ST_AsPNG(\n" 1761" ST_Transform(\n" 1762" ST_AddBand(\n" 1763" ST_Union(rast,1), ARRAY[ST_Union(rast,2)," 1764"ST_Union(rast,3)])\n" 1765" ,:input_srid) ) As " 1766"new_rast\n" 1767" FROM aerials.boston\n" 1768" WHERE\n" 1769" ST_Intersects(rast,\n" 1770" ST_Transform(ST_MakeEnvelope(-71.1217, " 1771"42.227, -71.1210, 42.218,4326),26986) )\";\n" 1772" command = new NpgsqlCommand(sql, conn);\n" 1773" command.Parameters.Add(new NpgsqlParameter(\"input_srid\", " 1774"input_srid));\n" 1775"\n" 1776"\n" 1777" result = (byte[]) command.ExecuteScalar();\n" 1778" conn.Close();\n" 1779" }\n" 1780"\n" 1781" }\n" 1782" catch (Exception ex)\n" 1783" {\n" 1784" result = null;\n" 1785" context.Response.Write(ex.Message.Trim());\n" 1786" }\n" 1787" return result;\n" 1788" }\n" 1789"}]]>" 1790msgstr "" 1791 1792#. Tag: title 1793#: using_raster_dataman.xml:536 1794#, no-c-format 1795msgid "Java console app that outputs raster query as Image file" 1796msgstr "app per Java console per esportare una query raster come file immagine" 1797 1798#. Tag: para 1799#: using_raster_dataman.xml:537 1800#, no-c-format 1801msgid "" 1802"This is a simple java console app that takes a query that returns one image " 1803"and outputs to specified file." 1804msgstr "" 1805"Questa è una semplice app per console java che prende una query, ne " 1806"restituisce la corrispondente immagine e la scrive in un file specificato." 1807 1808#. Tag: para 1809#: using_raster_dataman.xml:538 1810#, no-c-format 1811msgid "" 1812"You can download the latest PostgreSQL JDBC drivers from <ulink url=\"http://" 1813"jdbc.postgresql.org/download.html\">http://jdbc.postgresql.org/download." 1814"html</ulink>" 1815msgstr "" 1816"Potete scaricare i driver JDBC per PostgreSQL più recenti da <ulink url=" 1817"\"http://jdbc.postgresql.org/download.html\">http://jdbc.postgresql.org/" 1818"download.html</ulink>" 1819 1820#. Tag: para 1821#: using_raster_dataman.xml:539 1822#, no-c-format 1823msgid "You can compile the following code using a command something like:" 1824msgstr "Potete compilare il codice seguente con un comando tipo:" 1825 1826#. Tag: programlisting 1827#: using_raster_dataman.xml:540 1828#, no-c-format 1829msgid "" 1830"set env CLASSPATH .:..\\postgresql-9.0-801.jdbc4.jar\n" 1831"javac SaveQueryImage.java\n" 1832"jar cfm SaveQueryImage.jar Manifest.txt *.class" 1833msgstr "" 1834"set env CLASSPATH .:..\\postgresql-9.0-801.jdbc4.jar\n" 1835"javac SaveQueryImage.java\n" 1836"jar cfm SaveQueryImage.jar Manifest.txt *.class" 1837 1838#. Tag: para 1839#: using_raster_dataman.xml:541 1840#, no-c-format 1841msgid "And call it from the command-line with something like" 1842msgstr "E lanciarlo dalla riga di comando con un'istruzione tipo" 1843 1844#. Tag: programlisting 1845#: using_raster_dataman.xml:542 1846#, no-c-format 1847msgid "" 1848"java -jar SaveQueryImage.jar \"SELECT " 1849"ST_AsPNG(ST_AsRaster(ST_Buffer(ST_Point(1,5),10, 'quad_segs=2'),150, 150, " 1850"'8BUI',100));\" \"test.png\"" 1851msgstr "" 1852"java -jar SaveQueryImage.jar \"SELECT " 1853"ST_AsPNG(ST_AsRaster(ST_Buffer(ST_Point(1,5),10, 'quad_segs=2'),150, 150, " 1854"'8BUI',100));\" \"test.png\"" 1855 1856#. Tag: programlisting 1857#: using_raster_dataman.xml:543 1858#, no-c-format 1859msgid "" 1860"-- Manifest.txt --\n" 1861"<![CDATA[Class-Path: postgresql-9.0-801.jdbc4.jar\n" 1862"Main-Class: SaveQueryImage]]>" 1863msgstr "" 1864"-- Manifest.txt --\n" 1865"<![CDATA[Class-Path: postgresql-9.0-801.jdbc4.jar\n" 1866"Main-Class: SaveQueryImage]]>" 1867 1868#. Tag: programlisting 1869#: using_raster_dataman.xml:544 1870#, no-c-format 1871msgid "" 1872"// Code for SaveQueryImage.java\n" 1873"<![CDATA[import java.sql.Connection;\n" 1874"import java.sql.SQLException;\n" 1875"import java.sql.PreparedStatement;\n" 1876"import java.sql.ResultSet;\n" 1877"import java.io.*;\n" 1878"\n" 1879"public class SaveQueryImage {\n" 1880" public static void main(String[] argv) {\n" 1881" System.out.println(\"Checking if Driver is registered with " 1882"DriverManager.\");\n" 1883"\n" 1884" try {\n" 1885" //java.sql.DriverManager.registerDriver (new org.postgresql." 1886"Driver());\n" 1887" Class.forName(\"org.postgresql.Driver\");\n" 1888" }\n" 1889" catch (ClassNotFoundException cnfe) {\n" 1890" System.out.println(\"Couldn't find the driver!\");\n" 1891" cnfe.printStackTrace();\n" 1892" System.exit(1);\n" 1893" }\n" 1894"\n" 1895" Connection conn = null;\n" 1896"\n" 1897" try {\n" 1898" conn = DriverManager.getConnection(\"jdbc:postgresql://" 1899"localhost:5432/mydb\",\"myuser\", \"mypwd\");\n" 1900" conn.setAutoCommit(false);\n" 1901"\n" 1902" PreparedStatement sGetImg = conn.prepareStatement(argv[0]);\n" 1903"\n" 1904" ResultSet rs = sGetImg.executeQuery();\n" 1905"\n" 1906" FileOutputStream fout;\n" 1907" try\n" 1908" {\n" 1909" rs.next();\n" 1910" /** Output to file name requested by user **/\n" 1911" fout = new FileOutputStream(new File(argv[1]) );\n" 1912" fout.write(rs.getBytes(1));\n" 1913" fout.close();\n" 1914" }\n" 1915" catch(Exception e)\n" 1916" {\n" 1917" System.out.println(\"Can't create file\");\n" 1918" e.printStackTrace();\n" 1919" }\n" 1920"\n" 1921" rs.close();\n" 1922" sGetImg.close();\n" 1923" conn.close();\n" 1924" }\n" 1925" catch (SQLException se) {\n" 1926" System.out.println(\"Couldn't connect: print out a stack trace and " 1927"exit.\");\n" 1928" se.printStackTrace();\n" 1929" System.exit(1);\n" 1930" }\n" 1931" }\n" 1932"}]]>" 1933msgstr "" 1934 1935#. Tag: title 1936#: using_raster_dataman.xml:548 1937#, no-c-format 1938msgid "Use PLPython to dump out images via SQL" 1939msgstr "Utilizzare PLPython per esportare immagini tramite SQL" 1940 1941#. Tag: para 1942#: using_raster_dataman.xml:549 1943#, no-c-format 1944msgid "" 1945"This is a plpython stored function that creates a file in the server " 1946"directory for each record. Requires you have plpython installed. Should work " 1947"fine with both plpythonu and plpython3u." 1948msgstr "" 1949 1950#. Tag: programlisting 1951#: using_raster_dataman.xml:551 1952#, no-c-format 1953msgid "" 1954"<![CDATA[CREATE OR REPLACE FUNCTION write_file (param_bytes bytea, " 1955"param_filepath text)\n" 1956"RETURNS text\n" 1957"AS $$\n" 1958"f = open(param_filepath, 'wb+')\n" 1959"f.write(param_bytes)\n" 1960"return param_filepath\n" 1961"$$ LANGUAGE plpythonu;]]>" 1962msgstr "" 1963 1964#. Tag: programlisting 1965#: using_raster_dataman.xml:552 1966#, no-c-format 1967msgid "" 1968"--write out 5 images to the PostgreSQL server in varying sizes\n" 1969"-- note the postgresql daemon account needs to have write access to folder\n" 1970"-- this echos back the file names created;\n" 1971" SELECT write_file(ST_AsPNG(\n" 1972" ST_AsRaster(ST_Buffer(ST_Point(1,5),j*5, 'quad_segs=2'),150*j, " 1973"150*j, '8BUI',100)),\n" 1974" 'C:/temp/slices'|| j || '.png')\n" 1975" FROM generate_series(1,5) As j;\n" 1976"\n" 1977" write_file\n" 1978"---------------------\n" 1979" C:/temp/slices1.png\n" 1980" C:/temp/slices2.png\n" 1981" C:/temp/slices3.png\n" 1982" C:/temp/slices4.png\n" 1983" C:/temp/slices5.png" 1984msgstr "" 1985 1986#. Tag: title 1987#: using_raster_dataman.xml:555 1988#, no-c-format 1989msgid "Outputting Rasters with PSQL" 1990msgstr "Produrre raster con PSQL" 1991 1992#. Tag: para 1993#: using_raster_dataman.xml:556 1994#, no-c-format 1995msgid "" 1996"Sadly PSQL doesn't have easy to use built-in functionality for outputting " 1997"binaries. This is a bit of a hack that piggy backs on PostgreSQL somewhat " 1998"legacy large object support. To use first launch your psql commandline " 1999"connected to your database." 2000msgstr "" 2001 2002#. Tag: para 2003#: using_raster_dataman.xml:558 2004#, no-c-format 2005msgid "" 2006"Unlike the python approach, this approach creates the file on your local " 2007"computer." 2008msgstr "" 2009"A differenza dell'approcio python, questo sistema crea il file in locale sul " 2010"vostro computer." 2011 2012#. Tag: screen 2013#: using_raster_dataman.xml:559 2014#, no-c-format 2015msgid "" 2016"SELECT oid, lowrite(lo_open(oid, 131072), png) As num_bytes\n" 2017" FROM\n" 2018" ( VALUES (lo_create(0),\n" 2019" ST_AsPNG( (SELECT rast FROM aerials.boston WHERE rid=1) )\n" 2020" ) ) As v(oid,png);\n" 2021"-- you'll get an output something like --\n" 2022" oid | num_bytes\n" 2023"---------+-----------\n" 2024" 2630819 | 74860\n" 2025"\n" 2026"-- next note the oid and do this replacing the c:/test.png to file path " 2027"location\n" 2028"-- on your local computer\n" 2029" \\lo_export 2630819 'C:/temp/aerial_samp.png'\n" 2030"\n" 2031"-- this deletes the file from large object storage on db\n" 2032"SELECT lo_unlink(2630819);" 2033msgstr "" 2034
