NAME "SEACOOS Drifter testing"
    STATUS ON
    EXTENT -98.17 14.82 -59.55 45.62  # -88.5 22.5 -69.19 37.9
    SIZE 523 419
    SHAPEPATH "../data"
    SYMBOLSET "../etc/symbols.sym"
    FONTSET "../etc/fonts.txt"
    IMAGECOLOR 230 247 254 # seacoos_key.png
    UNITS DD
    IMAGETYPE Gtiff
    OUTPUTFORMAT
      NAME png
      MIMETYPE "image/png"
      DRIVER "GD/PNG"
      EXTENSION "png"
      IMAGEMODE RGB
      FORMATOPTION "INTERLACE=OFF"
      TRANSPARENT OFF
    END
    OUTPUTFORMAT
      NAME GTiff
      MIMETYPE "image/tiff"
      DRIVER "GDAL/GTiff"
      EXTENSION "tif"
      IMAGEMODE RGB
    END
    OUTPUTFORMAT
      NAME jpeg                                                                                                                                       
      MIMETYPE "image/jpeg"                                                                                                                           
      DRIVER "GD/JPEG"
      EXTENSION "jpg"
      IMAGEMODE RGB
      FORMATOPTION "QUALITY=100"
    END
    OUTPUTFORMAT
      NAME gif
      DRIVER "GD/GIF"
      MIMETYPE "image/gif"
      IMAGEMODE RGBA
      EXTENSION "gif"
      TRANSPARENT ON
    END
    PROJECTION
      "proj=latlong"
     END
    WEB
      IMAGEPATH "/usr/local/tmp/ms_tmp/"
      IMAGEURL "/tmp/"
    END
    QUERYMAP
      STATUS ON
      STYLE NORMAL    
    END
    REFERENCE
     STATUS ON
     IMAGE "../data/nccoos_basemap.jpg"
     SIZE 185 87
     EXTENT -84.45 32.07 -71.97 37.92
     COLOR -1 -1 -1
     OUTLINECOLOR 255 0 0
     MINBOXSIZE 20
     MAXBOXSIZE 105
     MARKERSIZE 15
    END
    SCALEBAR
      STATUS OFF
      OUTLINECOLOR 0 0 0
      IMAGECOLOR 255 255 255
      TRANSPARENT TRUE
      UNITS KILOMETERS
      INTERVALS 1 
      SIZE 70 3
      STYLE 1
      POSITION LR
      INTERLACE TRUE
      POSTLABELCACHE true
      LABEL
        TYPE BITMAP
        SIZE SMALL
        OFFSET 0 0
        BUFFER 0
        MINDISTANCE -1
        MINFEATURESIZE -1
        COLOR 0 0 0
        PARTIALS TRUE
        FORCE FALSE
      END
  END
#
#
#############
#
#
  LAYER
    NAME "states"
    STATUS ON
    DATA "STATES"
    TYPE POLYGON
    METADATA
      # "wms_title"    "STATES"
      "legendvis"    "hidden"
      "display"   "yes"
    END
    PROJECTION
      "init=epsg:4269"
    END
    CLASS
      STYLE
        SYMBOL 0
        COLOR 249 248 226
        OUTLINECOLOR 200 200 200
      END
    END
  END
#
#
###################
#
#
  LAYER
    NAME "world_filled"
    STATUS ON
    DATA "country"
    FILTERITEM "CNTRY_NAME"
    FILTER ("[CNTRY_NAME]" ne "United States")
    TYPE POLYGON
    PROJECTION
      "init=epsg:4326"
    END
    CLASS
      COLOR 250 249 228
      OUTLINECOLOR 178 178 178
    END
  END
#
#
#################################################
#
#
  LAYER
    NAME "oi_sst"
    STATUS ON
    TYPE RASTER
    #OFFSITE 0 0 0
    MINSCALE 300000
    MAXSCALE 100000000
    TRANSPARENCY 60
    CONNECTION "http://nautilus.baruch.sc.edu/wms/seacoos_rs?time=%time%"
    CONNECTIONTYPE WMS
    PROJECTION
     "init=epsg:4269"
    END
    METADATA
      "wms_srs" "EPSG:4269 EPSG:4326"
      "wms_name" "oi_sst"
      "wms_server_version" "1.1.0"
      "wms_formatlist" "image/png"
      "wms_format" "image/png"
      "wms_onlineresource" "http://nautilus.baruch.sc.edu/wms/seacoos_rs?"
      "wms_title" "OI SST"
      "wms_dataurl_href"  "http://seacoos.org/Data%20Access%20and%20Mapping/Document.SeaSurfaceTemperatureHome"
    END
 END
#
#
#################################################
#
#
  LAYER
    NAME "bathymetry"
    STATUS ON
    TYPE RASTER    
    MINSCALE 300000
    MAXSCALE 100000000
    TRANSPARENCY 60
    CONNECTION "http://nautilus.baruch.sc.edu/wms/seacoos_rs?"
    CONNECTIONTYPE WMS
    PROJECTION
     "init=epsg:4269"
    END
    METADATA
      "wms_srs" "EPSG:4269 EPSG:4326"
      "wms_name" "etopo2_bathy_contour"
      "wms_server_version" "1.1.0"
      "wms_formatlist" "image/png"
      "wms_format" "image/png"
      "wms_onlineresource" "http://nautilus.baruch.sc.edu/wms/seacoos_rs?"
      "wms_title" "ETOPO2 Bathymetry"
      "wms_dataurl_href"  "http://seacoos.org/Data%20Access%20and%20Mapping/Document.SeaSurfaceTemperatureHome"
    END
 END
#
#
#
#################################################
#
#
#
  LAYER
    NAME "particle_trajectory"
    STATUS ON
    DATA "the_geom from multi_obs USING UNIQUE row_id USING SRID=-1"
    FILTER "(sensor_id IN (select row_id from sensor where type_id ='1')) AND (m_date > (to_timestamp('%time%','YYYY_MM_DD_HH_MI_SS') - interval '%offset% hours')) AND (m_date < (to_timestamp('%time%','YYYY_MM_DD_HH_MI_SS'))) AND (m_type_id = '41')"
    GROUP "drifter_trajectory"
    TYPE POINT
    CONNECTIONTYPE POSTGIS
    CONNECTION "user=map password=map dbname=db_xenia_v2 host=coriolis.marine.unc.edu"
    PROJECTION
      "init=epsg:4326"
    END
    CLASS
      COLOR 90 90 90
      SYMBOL 'circle' 
      SIZE 1
      EXPRESSION ([m_value_3] > 0)
    END
  END
#
#
##############################################################
#
#
  LAYER
    NAME "particle_tail"
    STATUS ON
    DATA "the_geom FROM multi_obs USING UNIQUE row_id USING SRID=-1" 
    FILTER "(sensor_id IN (SELECT row_id FROM sensor WHERE type_id ='1')) AND (row_id IN (select min(row_id) FROM multi_obs WHERE (m_date >(to_timestamp('%time%','YYYY_MM_DD_HH_MI_SS') - interval '%offset% hours')) AND (m_date < (to_timestamp('%time%','YYYY_MM_DD_HH_MI_SS') - interval '%offset_end% hours') AND (m_type_id ='41')) GROUP BY platform_handle ))"
    TYPE POINT
    GROUP "drifter_trajectory"
    CONNECTIONTYPE POSTGIS
    CONNECTION "user=map password=map dbname=db_xenia_v2 host=coriolis.marine.unc.edu"
    PROJECTION
      "init=epsg:4326"
    END
    CLASS
      STYLE
        COLOR 0 0 200
        OUTLINECOLOR 0 0 255
        SYMBOL 'circle'
        SIZE 4
      END
    END
  END
#
#
##############################################################
#
#
  LAYER
    NAME "particle_head_label"
    STATUS OFF
    DATA "the_geom from (select *, to_char(m_date,'HH24:MI') as lab from multi_obs) as foo USING UNIQUE row_id"
    FILTER "(sensor_id IN (select row_id from sensor where type_id ='1'))  AND (row_id IN (select max(row_id) FROM multi_obs WHERE (m_date > (to_timestamp('%time%','YYYY_MM_DD_HH_MI_SS') - interval '14 hours' )) and  (m_date < (to_timestamp('%time%','YYYY_MM_DD_HH_MI_SS')) AND (m_type_id ='41')) GROUP BY platform_handle ))"
    TYPE POINT
    CONNECTIONTYPE POSTGIS
    CONNECTION "user=map password=map dbname=db_xenia_v2 host=coriolis.marine.unc.edu"
    PROJECTION
      "init=epsg:4326"
    END
    LABELITEM "lab"
    CLASS
      STYLE END
      LABEL
        TYPE TRUETYPE
        FONT "arial"
        SIZE 7
        COLOR 0 0 0
        POSITION CR
        OFFSET 2 -7
        FORCE TRUE 
        PARTIALS TRUE
      END
    END
  END
#
#
###########################################
#
#
  LAYER
    NAME "particle_head"
    STATUS ON
    DATA "the_geom from multi_obs USING UNIQUE row_id USING SRID=-1"
    FILTER "(sensor_id IN (select row_id from sensor where type_id ='1')) AND (row_id IN (select max(row_id) FROM multi_obs WHERE (m_date > (to_timestamp('%time%','YYYY_MM_DD_HH_MI_SS') - interval '14 hours')) AND (m_date < (to_timestamp('%time%','YYYY_MM_DD_HH_MI_SS')) AND (m_type_id ='41')) GROUP BY platform_handle ))"   
    TYPE POINT
    GROUP "drifter_trajectory"
    CONNECTIONTYPE POSTGIS
    CONNECTION "user=map password=map dbname=db_xenia_v2 host=coriolis.marine.unc.edu"
    PROJECTION
      "init=epsg:4326"
    END
    LABELANGLEITEM "d_label_theta"
    CLASS
      STYLE END
      TEXT '&#182;'
      EXPRESSION ([m_value_3] <= 10)
      LABEL
        TYPE TRUETYPE
        FONT "esricart"
        SIZE 9
        COLOR 0 0 200 #50 50 50  
        POSITION CC FORCE TRUE PARTIALS TRUE
      END
    END
  END
#
#
###############################################
#
#
  LAYER
    NAME "sea_surface_currents"
    STATUS OFF
    DATA "the_geom from current_in_situ_map USING UNIQUE seq USING SRID=-1"
    FILTER "(report_time_stamp = date_trunc('hour',to_timestamp('%time%','YYYY_MM_DD_HH_MI_SS')) and surface_or_bottom = 'surface')"
    TEMPLATE "dummy"
    TOLERANCE 5
    TOLERANCEUNITS pixels
    TYPE POINT
    CONNECTIONTYPE POSTGIS
    CONNECTION "user=map password=map dbname=seacoos_test host=coriolis.marine.unc.edu"
    PROJECTION
      "init=epsg:4326"
    END
    GROUP "is_currents"
    LABELANGLEITEM "theta"
    CLASSITEM "speed_knots"
    CLASS
      STYLE END
      TEXT '&#176;'
      EXPRESSION ([speed_knots] <= .25)
      LABEL
        TYPE TRUETYPE
        FONT "esricart"
        SIZE 12 
        COLOR 52 13 113
	POSITION CC FORCE TRUE PARTIALS TRUE
      END
    END
    CLASS
      STYLE END
      TEXT '&#176;'
      EXPRESSION (.25 < [speed_knots] AND [speed_knots] <= .50)
      LABEL
        TYPE TRUETYPE
        FONT "esricart"
        SIZE 14 
        COLOR 145 130 182
	POSITION CC FORCE TRUE PARTIALS TRUE
      END
    END
    CLASS
      STYLE END
      TEXT '&#176;'
      EXPRESSION (.50 < [speed_knots] AND [speed_knots] <= .75)
      LABEL
        TYPE TRUETYPE
        FONT "esricart"
        SIZE 16 
        COLOR 0 120 210
	POSITION CC FORCE TRUE PARTIALS TRUE
      END
    END
    CLASS
      STYLE END
      TEXT '&#176;'
      EXPRESSION (.75 < [speed_knots] AND [speed_knots] <= 1.0)
      LABEL
        TYPE TRUETYPE
        FONT "esricart"
        SIZE 18 
        COLOR 110 200 250
	POSITION CC FORCE TRUE PARTIALS TRUE
      END
    END
    CLASS
      STYLE END
      TEXT '&#176;'
      EXPRESSION (1.0 < [speed_knots] AND [speed_knots] <= 1.25)
      LABEL
        TYPE TRUETYPE
        FONT "esricart"
        SIZE 22 
        COLOR 0 144 73
        POSITION CC FORCE TRUE PARTIALS TRUE
      END
    END
    CLASS
      STYLE END
      TEXT '&#176;'
      EXPRESSION (1.25 < [speed_knots] AND [speed_knots] <= 1.50)
      LABEL
        TYPE TRUETYPE
        FONT "esricart"
        SIZE 25 
        COLOR 177 255 177
        POSITION CC FORCE TRUE PARTIALS TRUE
      END
    END
    CLASS
      STYLE END
      TEXT '&#176;'
      EXPRESSION (1.5 < [speed_knots] AND [speed_knots] <= 1.75)
      LABEL
        TYPE TRUETYPE
        FONT "esricart"
        SIZE 27 
        COLOR 254 248 0
        POSITION CC FORCE TRUE PARTIALS TRUE
      END
    END
    CLASS
      STYLE END
      TEXT '&#176;'
      EXPRESSION (1.75 < [speed_knots] AND [speed_knots] <= 2.0)
      LABEL
        TYPE TRUETYPE
        FONT "esricart"
        SIZE 29 
        COLOR 232 123 20
        POSITION CC FORCE TRUE PARTIALS TRUE
      END
    END
    CLASS
      STYLE END
      TEXT '&#176;'
      EXPRESSION (2.0 < [speed_knots] AND [speed_knots] <= 2.25)
      LABEL
        TYPE TRUETYPE
        FONT "esricart"
        SIZE 31 
        COLOR 235 61 0
        POSITION CC FORCE TRUE PARTIALS TRUE
      END
    END
    CLASS
      STYLE END
      TEXT '&#176;'
      EXPRESSION (2.25 < [speed_knots] AND [speed_knots] <= 2.5)
      LABEL
        TYPE TRUETYPE
        FONT "esricart"
        SIZE 33 
        COLOR 164 0 2
        POSITION CC FORCE TRUE PARTIALS TRUE
      END
    END
    CLASS
      STYLE END
      TEXT '&#176;'
      EXPRESSION (2.5 < [speed_knots] AND [speed_knots] <= 5.8)
      LABEL
        TYPE TRUETYPE
        FONT "esricart"
        SIZE 35 
        COLOR 255 9 189
        POSITION CC FORCE TRUE PARTIALS TRUE
      END
    END
  END
#
#
###############################################
#
#
 LAYER
    NAME "adcp_vectors"
    STATUS OFF
    DATA "the_geom from multi_obs"
    FILTER "m_type_id = 41 and (sensor_id IN (select row_id from sensor where type_id ='4')) and (d_report_hour = to_timestamp('%time%','YYYY_MM_DD_HH_MI_SS')) and (d_top_of_hour = 1)" 
    #FILTER "m_type_id = 41 and (sensor_id IN (select row_id from sensor where type_id ='4')) and (m_date > (to_timestamp('%time%','YYYY_MM_DD_HH_MI_SS') - interval '30 minutes' )) and  (m_date < (to_timestamp('%time%','YYYY_MM_DD_HH_MI_SS') + interval '31 minutes'))"
    TYPE POINT
    CONNECTIONTYPE POSTGIS
    CONNECTION "user=map password=map dbname=db_xenia_v2 host=coriolis.marine.unc.edu"
    GROUP "is_currents"
    PROJECTION
      "init=epsg:4326"
    END
    LABELANGLEITEM "d_label_theta"
    CLASS
      STYLE END
      TEXT '&#176;'
      EXPRESSION ([m_value_3] <= .25)
      LABEL
        TYPE TRUETYPE
        FONT "esricart"
        SIZE 12 
        COLOR 52 13 113
	POSITION CC FORCE TRUE PARTIALS TRUE
      END
    END
    CLASS
      STYLE END
      TEXT '&#176;'
      EXPRESSION (.25 < [m_value_3] AND [m_value_3] <= .50)
      LABEL
        TYPE TRUETYPE
        FONT "esricart"
        SIZE 14 
        COLOR 145 130 182
	POSITION CC FORCE TRUE PARTIALS TRUE
      END
    END
    CLASS
      STYLE END
      TEXT '&#176;'
      EXPRESSION (.50 < [m_value_3] AND [m_value_3] <= .75)
      LABEL
        TYPE TRUETYPE
        FONT "esricart"
        SIZE 16 
        COLOR 0 120 210
	POSITION CC FORCE TRUE PARTIALS TRUE
      END
    END
    CLASS
      STYLE END
      TEXT '&#176;'
      EXPRESSION (.75 < [m_value_3] AND [m_value_3] <= 1.0)
      LABEL
        TYPE TRUETYPE
        FONT "esricart"
        SIZE 18 
        COLOR 110 200 250
	POSITION CC FORCE TRUE PARTIALS TRUE
      END
    END
    CLASS
      STYLE END
      TEXT '&#176;'
      EXPRESSION (1.0 < [m_value_3] AND [m_value_3] <= 1.25)
      LABEL
        TYPE TRUETYPE
        FONT "esricart"
        SIZE 22 
        COLOR 0 144 73
        POSITION CC FORCE TRUE PARTIALS TRUE
      END
    END
    CLASS
      STYLE END
      TEXT '&#176;'
      EXPRESSION (1.25 < [m_value_3] AND [m_value_3] <= 1.50)
      LABEL
        TYPE TRUETYPE
        FONT "esricart"
        SIZE 25 
        COLOR 177 255 177
        POSITION CC FORCE TRUE PARTIALS TRUE
      END
    END
    CLASS
      STYLE END
      TEXT '&#176;'
      EXPRESSION (1.5 < [m_value_3] AND [m_value_3] <= 1.75)
      LABEL
        TYPE TRUETYPE
        FONT "esricart"
        SIZE 27 
        COLOR 254 248 0
        POSITION CC FORCE TRUE PARTIALS TRUE
      END
    END
    CLASS
      STYLE END
      TEXT '&#176;'
      EXPRESSION (1.75 < [m_value_3] AND [m_value_3] <= 2.0)
      LABEL
        TYPE TRUETYPE
        FONT "esricart"
        SIZE 29 
        COLOR 232 123 20
        POSITION CC FORCE TRUE PARTIALS TRUE
      END
    END
    CLASS
      STYLE END
      TEXT '&#176;'
      EXPRESSION (2.0 < [m_value_3] AND [m_value_3] <= 2.25)
      LABEL
        TYPE TRUETYPE
        FONT "esricart"
        SIZE 31 
        COLOR 235 61 0
        POSITION CC FORCE TRUE PARTIALS TRUE
      END
    END
    CLASS
      STYLE END
      TEXT '&#176;'
      EXPRESSION (2.25 < [m_value_3] AND [m_value_3] <= 2.5)
      LABEL
        TYPE TRUETYPE
        FONT "esricart"
        SIZE 33 
        COLOR 164 0 2
        POSITION CC FORCE TRUE PARTIALS TRUE
      END
    END
    CLASS
      STYLE END
      TEXT '&#176;'
      EXPRESSION (2.5 < [m_value_3] AND [m_value_3] <= 5.8)
      LABEL
        TYPE TRUETYPE
        FONT "esricart"
        SIZE 35 
        COLOR 255 9 189
        POSITION CC FORCE TRUE PARTIALS TRUE
      END
    END
  END
#
#
################################################
#
#
 LAYER
    NAME "RADAR_small"
    TOLERANCE 3
    TOLERANCEUNITS PIXELS
    TEMPLATE ttt_query.html
    STATUS OFF
    OFFSITE 230 247 254
    TYPE RASTER
    PROJECTION
      "init=epsg:4269"
    END
    CONNECTION   "http://maury.marine.unc.edu/cgi-bin/hf_radar_wrap?time=%time%"
    CONNECTIONTYPE WMS
     METADATA
        "wms_srs" "EPSG:4269"
        "wms_onlineresource"  "http://maury.marine.unc.edu/cgi-bin/hf_radar_wrap?"
        "wms_name"  "RADAR_small"
        "wms_formatlist"  "image/png"
        "wms_format"  "image/png"
        "wms_server_version"  "1.1.0"
    END
  END
 END  
END