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

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

You'll have to use the batik (non-streaming) renderer, and you'll have=20
to define an SLD file that will put the labelling on, see:=20
http://docs.codehaus.org/display/GEOSDOC/SLD+Intro+Tutorial

Omar Zevallos wrote:
> thanks for your answer. excuse that I=B4m so inquisitive, but I have be=
en all
> the day trying to solve this and I see that it was very simple.
>=20
> How to make to show the description of a point in SVG? my view is thus:
>=20
> CREATE OR REPLACE VIEW puntos_provincia AS
>  SELECT provincia.gid AS oid, provincia.gid, provincia.desprov,
> centroid(provincia.the_geom) AS the_geom
>    FROM provincia;
>=20
> and when I request
> http://localhost:8080/gs1.3rc7/wms?request=3DGetMap&layers=3Dprovincia,=
puntos_provincia&width=3D800&height=3D400&srs=3DEPSG:32719&styles=3Dprovi=
ncia,linea_simple&Format=3Dimage/svg+xml
>=20
> draws a map and points, but I would like show the provincia.desprov fie=
ld.
> excuses the annoyances.
>=20
>=20
> ----- Original Message -----=20
> From: "Chris Holmes" <ch...@op...>
> To: "Omar Zevallos" <om...@st...>
> Cc: <geo...@li...>
> Sent: Sunday, February 26, 2006 9:05 PM
> Subject: Re: [Geoserver-users] creating a view in PostGis for GeoServer
>=20
>=20
>=20
>>See: http://docs.codehaus.org/display/GEOSDOC/PostGIS+DataStore the
>>section called: 'PostGIS view as a FeatureType'
>>
>>Omar Zevallos wrote:
>>
>>>Hi all, I=B4m trying to create a view in PostGis that shows center poi=
nt
>=20
> of
>=20
>>>the_geom field, but GeoServer doesnt recognise it. How I must define t=
he
>>>view so that Geoserver cant recognise the geographic field?
>>>I have defined it thus:
>>>
>>>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.despr=
ov
>>>   FROM provincia;
>>>
>>>Thanks in advance
>>>
>>>
>>>
>>>-------------------------------------------------------
>>>This SF.Net email is sponsored by xPML, a groundbreaking scripting
>=20
> language
>=20
>>>that extends applications into web and mobile media. Attend the live
>=20
> webcast
>=20
>>>and join the prime developer group breaking into this new coding
>=20
> territory!
>=20
>>>http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=110944&bid$1720&dat=1216=
42
>>>_______________________________________________
>>>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
>>

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