Hello all:

I'm trying to publish a view from a postgis 2.0 database.
this is the view:
CREATE OR REPLACE VIEW delimitaciones_administrativas.aaa_regiones_v AS
 SELECT aaa_regiones.gid, aaa_regiones.municipio, aaa_regiones.regiones,
    st_area(aaa_regiones.geom) AS area_sq_meters,
    st_perimeter(aaa_regiones.geom) AS perim_meters,
    st_area(aaa_regiones.geom) * 0.0001::double precision AS hectares,
    st_area(aaa_regiones.geom) * 0.000247105::double precision AS acres,
    st_area(aaa_regiones.geom) * 0.000254427::double precision AS cuerdas,
    st_area(aaa_regiones.geom) * 0.0000010::double precision AS sq_kilometers,
    st_area(aaa_regiones.geom) * 0.0000003861::double precision AS sq_miles,
    aaa_regiones.geom
   FROM delimitaciones_administrativas.aaa_regiones;

I added the postgis data store, saw the list of tables and views, etc.

Then, when trying to publish that view, the following error occurs at 
calculating extent:
java.lang.RuntimeException: java.io.IOException: Error occured calculating 
bounds
... and so forth ...
loose bbox is unchecked
estimated extend unchecked

Tables also give me the same error when trying to publish (bounding boxes, 
compute from data). It is strange that it does not recognize the native SRS 
neither on tables or views.

Any help will be appreciated.

---------------------------
Iván Santiago
GIS Specialist
Information Technologies
Office of Management and 
Budget<https://mail.ogp.gobierno.pr/exchweb/bin/redir.asp?URL=https://mail.ogp.gobierno.pr/exchweb/bin/redir.asp?URL=http://www.ogp.gobierno.pr/>
787.725.9420 x 2233
Calle Cruz 254
PO Box 9023228
San Juan, PR 00902-3228

------------------------------------------------------------------------------
Introducing Performance Central, a new site from SourceForge and 
AppDynamics. Performance Central is your source for news, insights, 
analysis and resources for efficient Application Performance Management. 
Visit us today!
http://pubads.g.doubleclick.net/gampad/clk?id=48897511&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to