[postgis] postgis/mapserver

[gispmpf]

Hello!

I have some questions about postgis/mapserver interface...
I have created the following script:

# Definição das Camadas (Layers)
 LAYER
  NAME lotes
  TYPE  POLYGON 
 STATUS DEFAULT 
 DATA teste
   CLASSITEM 'mapkey'
 CLASS   
 EXPRESSION '2c'
    OUTLINECOLOR 128 128 90
  COLOR 225 225 185 
 END
  CLASS 
    EXPRESSION /./
   OUTLINECOLOR 128 128 128
   COLOR 255 255 255
  END
END
 LAYER 
 CONNECTIONTYPE postgis  
 NAME 'Roads' 
 CONNECTION "user=postgres dbname=teste host=localhost"
  DATA "linha from teste"
  STATUS ON
  TYPE LINE
  CLASS
  EXPRESSION (id=1)
   COLOR 255 22 22
   SYMBOL 'line' 
  SIZE 2
   END  
 CLASS  
    EXPRESSION (id=1)
     COLOR 205 92 82
   END 
END
 
END # Fim do MapFile   

i want to draw lines in the first layer and get it from postgis 
tables created like this:
CREATE TABLE teste (id int4, linha geometry , nome varchar(25)); 
INSERT INTO 
teste (id,linha,nome) VALUES (1, 'LINESTRING(1 1,50 50)','PRIM');
1) my question is : can i do it?
2) the second layer is referencing correctly the postgis table?
3) how can i define a symbol file for this lines?
4) What is the use of the EXPRESSION for postgis?

Thanks
João 
GIS/Analyst



------------------------ Yahoo! Groups Sponsor ---------------------~-->
Get your FREE VeriSign guide to security solutions for your web site: encrypting transactions, securing intranets, and more!
http://us.click.yahoo.com/UnN2wB/m5_CAA/yigFAA/PhFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
postgis-unsubscribe at yahoogroups.com

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/