- New ticket [6e95dbcac98c8c5c|6e95dbcac9] <i>RL2_WriteGeoTiff: bank images with 1-BIT MONOCHROME, FAX4</i>.
by
mj10777
2017-08-28 08:31:02.
D 2017-08-28T08:31:02.003
J foundin dev
J icomment In\spreparation\sfor\sa\sQGIS\sQgsRasterLite2Provider,\sI\sam\sbuilding\sa\ssmall\sDatabase\swith\s4\sRasterCoverages\sof\sthe\ssame\s2000x2000\sMeter\sarea.\r\n<ul>\r\n1656\s:\s1-BIT\sMONOCHROME,\sFAX4<br>\r\n1811\s:\sUINT8\sRGB,\sJPEG<br>\r\n1910\s:\sUINT8\sRGB,\sJPEG<br>\r\n2010\s:\s1-BIT\sMONOCHROME,\sFAX4\r\n</ul>\r\n<hr>\r\nFrom\sexisting\sRL2\sDatabases\sthe\sattempt\swas\smad\sto\sextract\sthis\sare\sfrom\sthe\s4\swith\sRL2_WriteGeoTiff.<br>\r\nFor\sthe\sUINT8\sRGB,\sJPEG:\sno\sproblem.<br>\r\nFor\sthe\s1-BIT\sMONOCHROME,\sFAX4:\sthe\simages\sare\sblank.<br>\r\n<hr>\r\nAll\s4\sare\sexported\sfrom\s1\sscript<br>\r\n-\shere\sthe\sportion\sfrom\sthe\slast\simage:\r\n<pre>\r\n--\s--\s----------------------------------\s--\r\nSELECT\sDateTime('now','localtime'),'ATTACH\sDATABASE\s''../2010.berlin_k5.400_dpi.db''\sAS\sdb_import';\r\nATTACH\sDATABASE\s'../2010.berlin_k5.400_dpi.db'\sAS\sdb_import;\r\n--\s--\s----------------------------------\s--\r\nSELECT\sDateTime('now'),'2010.alt_berlin_coelln_friedrichsweder:\spixel_size_x['||round((26000.0-24000.0)/0.3175065154982885)||']\spixel_size_y['||round((22250.0-20250.0)/0.3174918146641513)||']';\r\n--\s--\s----------------------------------\s--\r\n--\sgdal_translate\s2010.Berlin.5000.3068.FAX4_MINISWHITE.400.tif\s-projwin\s24000.0\s22250.000\s26000.0\s20250.000\s2010.Alt_Berlin_Coelln_Friedrichsweder.5000.3068.tif\r\n--\sgdalinfo\s2010.Alt_Berlin_Coelln_Friedrichsweder.5000.3068.tif\s>\s2010.Alt_Berlin_Coelln_Friedrichsweder.5000.3068.tif.info.txt\r\n--\s--\s----------------------------------\s--\r\nSELECT\sRL2_WriteGeoTiff\r\n(\r\n\s--\sThe\sdbPrefix\sargument\sis\sintended\sto\sspecify\sthe\sATTACHED-DB\swhere\sthe\sCoverage\sis\sexpected\sto\sbe\sfound\r\n\s'db_import',\r\n\s--\schosen\sname\sof\sraster_coverage\r\n\slower('2010.berlin_k5'),\r\n\s\s--\sdirectory\swhere\sthe\sfiles\sto\sbe\sloaded\sare\sstored\r\n\s'2010.alt_berlin_coelln_friedrichsweder.5000.3068.tif',\r\n\s--\simage-size\swidth,height\s(calculate)\r\n\s--\s2143.730401266\r\n\sCAST(round((26000.0-24000.0)/0.3175065154982885)\sAS\sINTEGER),\r\n\s--\s2144.134100369\r\n\sCAST(round((22250.0-20250.0)/0.3174918146641513)AS\sINTEGER),\r\n\s--\sarea\sto\sextract,\r\n\sBuildMbr\r\n\s(\r\n\s\s24000.0,22250.000,\s26000.0,20250.000,\r\n\s\s3068\r\n\s),\r\n\s--\sresolution\shorz/x\r\n\s0.3175065154982885,\r\n--\sresolution\svert/y\r\n\s0.3174918146641513,\r\n\s--\sworld-file\s0=no\s;\s1=yes\r\n\s1,\r\n\s--\scompression\r\n\s'FAX4',\r\n--\stile-size\s\s(of\stif)\r\n\s512\r\n);\r\n--\s--\s----------------------------------\s--\r\nSELECT\sDateTime('now','localtime'),'DETACH\sDATABASE\s''../2010.berlin_k5.400_dpi.db''\sAS\sdb_import';\r\nDETACH\sDATABASE\sdb_import;\r\n--\s--\s----------------------------------\s--\r\n</pre>\r\nThe\sshown\sgdal\scommand\sfor\sthe\ssame\stask\s(from\sthe\soriginal\stiff)\sreturns\scorrect\sresults.\r\n<hr>\r\nNote\son\sthe\sside:<br>\r\nWhen\sthe\sextent\sis\sgiven\sand\seither\r\n<ul>\r\nimage\ssize\s<b>or</b>\r\nresolution\r\n</ul>\r\nare\sgiven\s-\sthe\smissing\svalue\sshould\sbe\scalculated.<br>\r\nIn\smost\scases,\speople\swill\sgive\sthe\s<b>extent</b>\sand\s<b>size</b><br>\r\n<ul>they\sshould\snot\shave\sto\sbother\sabout\sthe\sresolution</ul>\r\nIf\sno\sresolution\sor\ssize\sis\sgiven\s(i.e.\svalues\sare\s0):<br>\r\n<ul>The\soriginal\sresolution\sshould\sbe\staken\sto\scalculate\sthe\ssize<br>\r\nas\sI\shave\sdone\swith\sthis\sscript</ul>\r\nThis\swas\sa\spart\sof\smy\spatch\swhich\swas\snever\slooked\sinto.
J login mj10777
J mimetype text/html
J private_contact a3ab3a740c17d1a955665bbfeda76d4f8b6739bf
J severity Critical
J status Open
J title RL2_WriteGeoTiff:\sbank\simages\swith\s1-BIT\sMONOCHROME,\sFAX4
J type Code_Defect
K 6e95dbcac98c8c5c2b1777a71d40dedd454a8453
U mj10777
Z f3843741b26e67539bcce94bfc5c57ae