Uploading raster format(*.tif) to postgis through raster2pgsql

[المشرف العام]

Hi I'm new to postgis and raster file format. i currently working on netcdf files and i want to import it into postgis through curl command line tool but its failed for me.so i jump on to GDAL v1.9.2 first i convert it into gtiff format and then upload it into postgis 2.0. I followed the steps in the below link:http://www.postgis.org/documentation/manualsvn/using_raster.xml.html#RT_Raster_Loaderto upload it. But i got some issue in that.

I used the below command to convert from single netcdf subdataset to single tif file.

gdal_translate -of Gtiff -a_srs EPSG:4326 NETCDF:"3z.nc":aabbc archv_4d.tifIt successfully created. now the problem starts, I used the below command to upload the .tiff file to postgis :

\9.2\bin>raster2pgsql -I -C -F -s 4326 -d -t 256x256 project/index_u.tif -b 1 public.td_test >test.sql \9.2\bin>psql -U postgres -d template_postgis_20 -f test.sql -h localhost -p 5432the response wassql:test.sql:2: NOTICE: CREATE TABLE will create implicit sequence "td_test_rid_seq" for serial column "td_test.rid"psql:test.sql:2: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index"td_test_pkey" for table "td_test"CREATE TABLEINSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1INSERT 0 1CREATE INDEXANALYZEpsql:test.sql:11: NOTICE: Adding SRID constraintCONTEXT: PL/pgSQL function addrasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean) line 53 at RETURNpsql:test.sql:11: NOTICE: Adding scale-X constraintCONTEXT: PL/pgSQL function addrasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean) line 53 at RETURNpsql:test.sql:11: NOTICE: Adding scale-Y constraintCONTEXT: PL/pgSQL function addrasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean) line 53 at RETURNpsql:test.sql:11: NOTICE: Adding blocksize-X constraintCONTEXT: PL/pgSQL function addrasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean) line 53 at RETURNpsql:test.sql:11: NOTICE: Adding blocksize-Y constraintCONTEXT: PL/pgSQL function addrasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean) line 53 at RETURNpsql:test.sql:11: NOTICE: Adding alignment constraintCONTEXT: PL/pgSQL function addrasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean) line 53 at RETURNpsql:test.sql:11: NOTICE: Adding number of bands constraintCONTEXT: PL/pgSQL function addrasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean) line 53 at RETURNpsql:test.sql:11: NOTICE: Adding pixel type constraintCONTEXT: PL/pgSQL function addrasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean) line 53 at RETURNpsql:test.sql:11: NOTICE: Adding nodata value constraintCONTEXT: PL/pgSQL function addrasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean) line 53 at RETURNpsql:test.sql:11: NOTICE: Unable to add constraint: enforce_nodata_values_rastCONTEXT: PL/pgSQL function _add_raster_constraint_nodata_values(name,name,name) line 48 at RETURNPL/pgSQL function addrasterconstraints(name,name,name,text[]) line 94 at assignmentPL/pgSQL function addrasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean) line 53 at RETURNpsql:test.sql:11: NOTICE: SQL used for failed constraint: ALTER TABLE public.td_test ADD CONSTRAINT enforce_nodata_values_rast CHECK (_raster_constraint_nodata_values(rast)::numeric(16,10)[] = '{1.26765060022823e+030}'::numeric(16,10)[])CONTEXT: PL/pgSQL function _add_raster_constraint_nodata_values(name,name,name) line 48 at RETURNPL/pgSQL function addrasterconstraints(name,name,name,text[]) line 94 at assignmentPL/pgSQL function addrasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean) line 53 at RETURNpsql:test.sql:11: NOTICE: Returned error message: numeric field overflowCONTEXT: PL/pgSQL function _add_raster_constraint_nodata_values(name,name,name) line 48 at RETURNPL/pgSQL function addrasterconstraints(name,name,name,text[]) line 94 at assignmentPL/pgSQL function addrasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean) line 53 at RETURNpsql:test.sql:11: WARNING: Unable to add constraint: 'nodata_values'. SkippingCONTEXT: PL/pgSQL function addrasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean) line 53 at RETURNpsql:test.sql:11: NOTICE: Adding out-of-database constraintCONTEXT: PL/pgSQL function addrasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean) line 53 at RETURNpsql:test.sql:11: NOTICE: Adding maximum extent constraintCONTEXT: PL/pgSQL function addrasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean) line 53 at RETURN addrasterconstraints---------------------- t(1 row)...the postgis table look with only serial and rid [pk] values NO raster data.

please help me out to find out the solution.thanks in advance.



أكثر...