Re: [Geoserver-users] creating a view in PostGis for GeoServer

[Chris H. <ch...@op...>]

See: http://docs.codehaus.org/display/GEOSDOC/PostGIS+DataStore the=20
section called: 'PostGIS view as a FeatureType'

Omar Zevallos wrote:
> Hi all, I=B4m trying to create a view in PostGis that shows center poin=
t of
> the_geom field, but GeoServer doesnt recognise it. How I must define th=
e
> view so that Geoserver cant recognise the geographic field?
> I have defined it thus:
>=20
> CREATE OR REPLACE VIEW Points_provincia AS
>  SELECT provincia.gid, centroid(provincia.the_geom) AS the_geom,
> point(centroid(provincia.the_geom)::box) AS the_geom1, provincia.despro=
v
>    FROM provincia;
>=20
> Thanks in advance
>=20
>=20
>=20
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting lang=
uage
> that extends applications into web and mobile media. Attend the live we=
bcast
> and join the prime developer group breaking into this new coding territ=
ory!
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=110944&bid$1720&dat=12164=
2
> _______________________________________________
> Geoserver-users mailing list
> Geo...@li...
> https://lists.sourceforge.net/lists/listinfo/geoserver-users

--=20
Chris Holmes
The Open Planning Project
thoughts at: http://cholmes.wordpress.com