<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>
Hi, <br><br>Try to see if you have Postgis correct installed. In the PGSQL console type: SELECT * FROM Postgis_lib_version(); <br><br>If not is correct install try to do this in the terminal as postgresql SU: <br><br>1 - Find /usr -name 'rtpostgis.sql' (copy the path of this file)<br><br>2 - pgsql -d yourDBname -f thepreviouspath<br><br>3 - Try again to import the file <br><br>Best Regards<br>José Santos<br><div><div id="SkyDrivePlaceholder"></div><hr id="stopSpelling">From: smaran.harihar@gmail.com<br>Date: Mon, 26 Nov 2012 21:40:25 -0700<br>To: postgis-users@lists.osgeo.org<br>Subject: Re: [postgis-users] Adding raster to PostGIS database<br><br>Oh it seems the error was due to ownership being in the name of another user.<div><br></div><div>Now I am able to get the gdalinfo,</div><div><br></div><div><div>Driver: GTiff/GeoTIFF</div><div>Files: Quercus_acutifolia_raw.tif</div>
<div>Size is 3864, 1583</div><div>Coordinate System is:</div><div>GEOGCS["WGS 84",</div><div> DATUM["unknown",</div><div> SPHEROID["WGS84",6378137,298.257223563]],</div><div> PRIMEM["Greenwich",0],</div>
<div> UNIT["degree",0.0174532925199433]]</div><div>Origin = (-179.960724061474451,86.577964063072983)</div><div>Pixel Size = (0.093000000000000,-0.090400000000000)</div><div>Metadata:</div><div> AREA_OR_POINT=Area</div>
<div>Image Structure Metadata:</div><div> COMPRESSION=LZW</div><div> INTERLEAVE=BAND</div><div>Corner Coordinates:</div><div>Upper Left (-179.9607241, 86.5779641) (179d57'38.61"W, 86d34'40.67"N)</div>
<div>Lower Left (-179.9607241, -56.5252359) (179d57'38.61"W, 56d31'30.85"S)</div><div>Upper Right ( 179.3912759, 86.5779641) (179d23'28.59"E, 86d34'40.67"N)</div><div>Lower Right ( 179.3912759, -56.5252359) (179d23'28.59"E, 56d31'30.85"S)</div>
<div>Center ( -0.2847241, 15.0263641) ( 0d17' 5.01"W, 15d 1'34.91"N)</div><div>Band 1 Block=3864x1 Type=Float32, ColorInterp=Gray</div><div> Min=0.000 Max=0.923 </div><div> Minimum=0.000, Maximum=0.923, Mean=0.000, StdDev=0.000</div>
<div> NoData Value=-3.39999999999999996e+38</div><div> Metadata:</div><div> STATISTICS_MAXIMUM=0.92262234256096</div><div> STATISTICS_MEAN=0</div><div> STATISTICS_MINIMUM=5.6834812171638e-19</div><div> STATISTICS_STDDEV=0</div>
<div><br></div><div>But when I execute,</div><div><br></div><div><div>raster2pgsql -c -s 4326 -I Quercus_acutifolia_raw.tif public.Quercus_acutifolia_raw | psql -h localhost -d dbname -U usr</div><div><br></div><div>I am still not able to create a Table? This is the output,</div>
<div><br></div><div>Processing 1/1: Quercus_acutifolia_raw.tif</div><div>Password for user postgres: </div><div>BEGIN</div><div>NOTICE: CREATE TABLE will create implicit sequence "quercus_acutifolia_raw_rid_seq" for serial column "quercus_acutifolia_raw.rid"</div>
<div>ERROR: type "raster" does not exist</div><div>LINE 1: ...us_acutifolia_raw" ("rid" serial PRIMARY KEY,"rast" raster);</div><div> ^</div>
<div>ERROR: current transaction is aborted, commands ignored until end of transaction block</div><div>ERROR: current transaction is aborted, commands ignored until end of transaction block</div><div>ERROR: current transaction is aborted, commands ignored until end of transaction block</div>
<div>ROLLBACK</div></div><div><br></div><div>Thanks,</div><div>Smaran</div><br><div class="ecxgmail_quote">On Mon, Nov 26, 2012 at 3:07 PM, Bborie Park <span dir="ltr"><<a href="mailto:bkpark@ucdavis.edu">bkpark@ucdavis.edu</a>></span> wrote:<br>
<blockquote class="ecxgmail_quote" style="border-left:1px #ccc solid;padding-left:1ex">Run the following...<br>
<br>
gdalinfo Quercus_acutifolia_raw.tif<br>
<br>
If that returns an error, something may be wrong with the tif file.<br>
<span class="ecxHOEnZb"><font color="#888888"><br>
-bborie<br>
</font></span><div class="ecxHOEnZb"><div class="h5"><br>
On 11/26/2012 02:03 PM, Smaran Harihar wrote:<br>
> But I am executing the command in the directory where it is located<br>
><br>
> I can list that raster using `ls`<br>
><br>
> On Mon, Nov 26, 2012 at 2:46 PM, Bborie Park <<a href="mailto:bkpark@ucdavis.edu">bkpark@ucdavis.edu</a>> wrote:<br>
><br>
>> That error would only happen if raster2pgsql can't find the file in your<br>
>> current working directory. raster2pgsql supports relative paths for<br>
>> input rasters.<br>
>><br>
>> -bborie<br>
>><br>
>> On 11/26/2012 01:37 PM, Smaran Harihar wrote:<br>
>>> Thanks for the reply bborie,<br>
>>><br>
>>> I ran this command,<br>
>>><br>
>>> raster2pgsql -c -s 4326 -I Quercus_acutifolia_raw.tif<br>
>>> public.Quercus_acutifolia_raw | psql -h localhost -d rasterdb -U postgres<br>
>>><br>
>>> But this is the new error,<br>
>>><br>
>>> ERROR: Unable to read raster file: Quercus_acutifolia_raw.tif<br>
>>><br>
>>> Thanks,<br>
>>> Smaran<br>
>>><br>
>>> On Mon, Nov 26, 2012 at 2:27 PM, Bborie Park <<a href="mailto:bkpark@ucdavis.edu">bkpark@ucdavis.edu</a>> wrote:<br>
>>><br>
>>>> -D is not a valid flag recognized by raster2pgsql. Remove the flag as<br>
>>>> raster2pgsql is assuming that -D is a file.<br>
>>>><br>
>>>> -bborie<br>
>>>><br>
>>>> On 11/26/2012 01:23 PM, Smaran Harihar wrote:<br>
>>>>> Hi Guys,<br>
>>>>><br>
>>>>> I am trying to add a raster to PostGIS database using,<br>
>>>>><br>
>>>>> raster2pgsql -c -D -s 4326 -I Quercus_acutifolia_raw.tif<br>
>>>>> public.Quercus_acutifolia_raw | psql -h localhost -d dbnm -U usr<br>
>>>>><br>
>>>>> But I am getting this error,<br>
>>>>><br>
>>>>> ERROR: Unable to read raster file: -D<br>
>>>>><br>
>>>>> Any idea what is wrong? The database already has numerous point and<br>
>>>> polygon<br>
>>>>> shapefiles. Is that a problem that I cannot add rasters to the same<br>
>>>>> database having shapefiles?<br>
>>>>><br>
>>>>><br>
>>>>><br>
>>>>> _______________________________________________<br>
>>>>> postgis-users mailing list<br>
>>>>> <a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
>>>>> <a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
>>>>><br>
>>>><br>
>>>> --<br>
>>>> Bborie Park<br>
>>>> Programmer<br>
>>>> Center for Vectorborne Diseases<br>
>>>> UC Davis<br>
>>>> <a target="_blank">530-752-8380</a><br>
>>>> <a href="mailto:bkpark@ucdavis.edu">bkpark@ucdavis.edu</a><br>
>>>> _______________________________________________<br>
>>>> postgis-users mailing list<br>
>>>> <a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
>>>> <a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
>>>><br>
>>><br>
>>><br>
>>><br>
>>><br>
>>><br>
>>> _______________________________________________<br>
>>> postgis-users mailing list<br>
>>> <a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
>>> <a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
>>><br>
>><br>
>> --<br>
>> Bborie Park<br>
>> Programmer<br>
>> Center for Vectorborne Diseases<br>
>> UC Davis<br>
>> <a target="_blank">530-752-8380</a><br>
>> <a href="mailto:bkpark@ucdavis.edu">bkpark@ucdavis.edu</a><br>
>> _______________________________________________<br>
>> postgis-users mailing list<br>
>> <a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
>> <a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
>><br>
><br>
><br>
><br>
><br>
><br>
> _______________________________________________<br>
> postgis-users mailing list<br>
> <a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
> <a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
><br>
<br>
--<br>
Bborie Park<br>
Programmer<br>
Center for Vectorborne Diseases<br>
UC Davis<br>
<a target="_blank">530-752-8380</a><br>
<a href="mailto:bkpark@ucdavis.edu">bkpark@ucdavis.edu</a><br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br>Thanks & Regards<div>Smaran Harihar</div><br>
</div>
<br>_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</div> </div></body>
</html>