[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