[Chameleon] No Query Results for Postgis layer
David Dabney
David.Dabney at noaa.gov
Tue Feb 1 14:19:15 EST 2005
I am using Chameleon 2.0 and am trying to query a Postgis layer with the
Query Widget. For some reason only shape_index, tile_index, and
layer_index are the only features returned. I used pgsql2shp and the
queries work fine for this layer pointing to the shapefile. Any help
would be greatly appreciated.
Here are my layers:
LAYER
NAME stations
METADATA
"wms_title" "Stations Shape"
"wfs_title" "Stations Shape"
END
TYPE POINT
STATUS ON
DATA stations
CLASS
SYMBOL star
COLOR 0 0 0
SIZE 7
END
TEMPLATE "ttt_query.html"
TOLERANCE 10
TOLERANCEUNITS pixels
PROJECTION
"proj=latlong"
"datum=WGS84"
END
END # layer
LAYER
CONNECTIONTYPE postgis
NAME "luces_stations"
CONNECTION "user=****** dbname=****** host=******** port=5432"
DATA "lat_long from (select * from stations) as s using unique
station_code using SRID=26917"
#FILTER "station = 'Middle'"
METADATA
"wms_title" "Stations PostGIS"
"wfs_title" "Stations PostGIS"
END
STATUS ON
DUMP TRUE
TYPE POINT
PROJECTION
"proj=latlong"
#"init=epsg:4269"
"datum=WGS84"
END
TEMPLATE "ttt"
TOLERANCE 10
TOLERANCEUNITS pixels
LABELITEM "station"
CLASS
TEMPLATE "ttt"
SYMBOL star
COLOR 0 0 0
SIZE 7
END
END
--
~~~~~~~~~~~~~~~~~~~~~~~
David Dabney
NOAA Hollings Marine Lab/JHT
331 Fort Johnson Rd
Charleston, SC 29412
843.762.8984
david.dabney at noaa.gov
More information about the Chameleon
mailing list