Now I also getting confused. I think there could be problem with my SQL
scripts generated with DDL generation utility.
Please see my SQL scripts. I think add_slp.sql file is not creating any
spatial table and inserting geom column in tile table column.
I think I have to edit the script, so guide me....
*
createmeta.sql*
CREATE TABLE rasterdata_master2(slp CHARACTER (64) NOT NULL,SpatialTable
VARCHAR (128) NOT NULL,TileTable VARCHAR (128) NOT NULL,resx FLOAT8,resy
FLOAT8,minx FLOAT8,miny FLOAT8,maxx FLOAT8,maxy FLOAT8,CONSTRAINT MASTER_PK
PRIMARY KEY (slp,SpatialTable,TileTable));
*add_slp.sql*
INSERT INTO rasterdata_master2(slp,TileTable,SpatialTable) VALUES
('slp','tilerasterdata_0','tilerasterdata_0');
INSERT INTO rasterdata_master2(slp,TileTable,SpatialTable) VALUES
('slp','tilerasterdata_1','tilerasterdata_1');
INSERT INTO rasterdata_master2(slp,TileTable,SpatialTable) VALUES
('slp','tilerasterdata_2','tilerasterdata_2');
INSERT INTO rasterdata_master2(slp,TileTable,SpatialTable) VALUES
('slp','tilerasterdata_3','tilerasterdata_3');
INSERT INTO rasterdata_master2(slp,TileTable,SpatialTable) VALUES
('slp','tilerasterdata_4','tilerasterdata_4');
CREATE TABLE tilerasterdata_0 (rid CHAR(64) NOT NULL ,rast BYTEA,CONSTRAINT
tilerasterdata_0_PK PRIMARY KEY(rid));
CREATE TABLE tilerasterdata_1 (rid CHAR(64) NOT NULL ,rast BYTEA,CONSTRAINT
tilerasterdata_1_PK PRIMARY KEY(rid));
CREATE TABLE tilerasterdata_2 (rid CHAR(64) NOT NULL ,rast BYTEA,CONSTRAINT
tilerasterdata_2_PK PRIMARY KEY(rid));
CREATE TABLE tilerasterdata_3 (rid CHAR(64) NOT NULL ,rast BYTEA,CONSTRAINT
tilerasterdata_3_PK PRIMARY KEY(rid));
CREATE TABLE tilerasterdata_4 (rid CHAR(64) NOT NULL ,rast BYTEA,CONSTRAINT
tilerasterdata_4_PK PRIMARY KEY(rid));
select AddGeometryColumn('tilerasterdata_0','geom',4326,'MULTIPOLYGON',2);
select AddGeometryColumn('tilerasterdata_1','geom',4326,'MULTIPOLYGON',2);
select AddGeometryColumn('tilerasterdata_2','geom',4326,'MULTIPOLYGON',2);
select AddGeometryColumn('tilerasterdata_3','geom',4326,'MULTIPOLYGON',2);
select AddGeometryColumn('tilerasterdata_4','geom',4326,'MULTIPOLYGON',2);
CREATE INDEX IX_tilerasterdata_0 ON tilerasterdata_0 USING gist(geom) ;
CREATE INDEX IX_tilerasterdata_1 ON tilerasterdata_1 USING gist(geom) ;
CREATE INDEX IX_tilerasterdata_2 ON tilerasterdata_2 USING gist(geom) ;
CREATE INDEX IX_tilerasterdata_3 ON tilerasterdata_3 USING gist(geom) ;
CREATE INDEX IX_tilerasterdata_4 ON tilerasterdata_4 USING gist(geom) ;
--
View this message in context:
http://osgeo-org.1560.x6.nabble.com/Problem-in-importing-raster-data-on-Geoserver-from-PostGIS-tp5051976p5052136.html
Sent from the GeoServer - User mailing list archive at Nabble.com.
------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and
their applications. This 200-page book is written by three acclaimed
leaders in the field. The early access version is available now.
Download your free book today! http://p.sf.net/sfu/neotech_d2d_may
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
