Dear All ...
I have trouble on pulling "label" from my PgSQL and put it as "label" to my map.
For reference, below is the SLD :
---------------------------------SLD START---------------------
<?xml version="1.0" encoding="UTF-8"?>
<StyledLayerDescriptor version="1.0.0"
xsi:schemaLocation="http://www.opengis.net/sld StyledLayerDescriptor.xsd"
xmlns="http://www.opengis.net/sld" xmlns:ogc="http://www.opengis.net/ogc"
xmlns:xlink="http://www.w3.org/1999/xlink"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<NamedLayer>
<Name>poi</Name>
<UserStyle>
<Name>poi_style</Name>
<Title>geoserver style</Title>
<Abstract>Generated by GeoServer</Abstract>
<FeatureTypeStyle>
<Rule>
<PointSymbolizer>
<Graphic>
<Mark>
<WellKnownName>circle</WellKnownName>
<Fill>
<CssParameter name="fill">#0000FF</CssParameter>
<CssParameter name="fill-opacity">1</CssParameter>
</Fill>
</Mark>
<Opacity>1</Opacity>
<Size>5</Size>
</Graphic>
</PointSymbolizer>
<TextSymbolizer>
<Label>
<ogc:PropertyName>label</ogc:PropertyName>
</Label> <Font>
<CssParameter name="font-family">Times New Roman</CssParameter>
<CssParameter name="font-style">Normal</CssParameter>
<CssParameter name="font-size">12</CssParameter>
</Font>
<Fill>
<CssParameter name="fill">#5555EE</CssParameter>
</Fill>
<VendorOption name="group">yes</VendorOption>
</TextSymbolizer>
</Rule>
</FeatureTypeStyle>
</UserStyle>
</NamedLayer>
</StyledLayerDescriptor>
---------------------------------SLD-STOP-----------------------
And Below is my table create script, exported by PGAdmin3 :
--------------PGSql-Start---
-- Table: poi
-- DROP TABLE poi;
CREATE TABLE poi
(
ogc_fid serial NOT NULL,
wkb_geometry geometry,
"type" numeric(5),
label character(80),
descr character(80),
city character(80),
region character(80),
country character(80),
house character(80),
phone character(80),
zip character(80),
highway character(80),
"level" numeric(5),
endlevel numeric(5),
CONSTRAINT poi_pk PRIMARY KEY (ogc_fid),
CONSTRAINT enforce_dims_wkb_geometry CHECK (ndims(wkb_geometry) = 2),
CONSTRAINT enforce_geotype_wkb_geometry CHECK (geometrytype(wkb_geometry) = 'POINT'::text OR wkb_geometry IS NULL),
CONSTRAINT enforce_srid_wkb_geometry CHECK (srid(wkb_geometry) = (-1))
)
WITH (OIDS=FALSE);
ALTER TABLE poi OWNER TO postgres;
--------------PgSql-Stop----
Notes : The POIs are showed , but without label
any enlightment please ?
Sincerely
-bino-