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.