[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    [postgis-users] =?iso-8859-1?Q?Re:_[postgis-users]_Re:_Postgis_too_slow?=
From:       "=?iso-8859-1?Q?shpr () libero ! it?=" <shpr () libero ! it>
Date:       2002-05-22 16:47:15
Message-ID: GWIUMR$DA514FB7257D88D79B06B8F184ADFB64 () libero ! it
[Download RAW message or body]

[Attachment #2 (text/plain)]

Excuse me, here there is the right map file

> Sorry... I meant to say "mapfile" not "shapefile"...
> Chris
> 
> Chris Hodgson wrote:
> 
> > Did you send the wrong shapefile? There is no reference in there to 
a postgis layer...
> >
> > Chris
> >
> > "shpr@libero.it" wrote:
> >
> > > ok, here there are the db schema and the .map file.
> > >
> > > The street table have about 800000 tuples.
> > >
> > > Thanks for your help!
> > >
> > > Stefano
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users@postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
["mymapfile.map.txt" (application/octet-stream)]

NAME DEMO
STATUS ON
SIZE 400 300
SYMBOLSET ./symbols/symbols.sym
FONTSET "/usr/share/fonts/default/TrueType/fonts.list"
EXTENT 4.835673 35.4921 20.292527 47.0951
IMAGETYPE jpeg

UNITS dd
SHAPEPATH "/store2/data"
IMAGECOLOR 255 255 255
#FONTSET ../etc/fonts.txt
IMAGECOLOR 182 196 213

#
# Start of web interface definition
#
WEB
  MINSCALE 1000
  MAXSCALE 12100000
  TEMPLATE market.html
  IMAGEPATH "/var/www/html/tmp/"
  IMAGEURL "/tmp/"
END

#
# Start of reference map
#
REFERENCE
   IMAGE images/italy.jpg
   EXTENT 6.6148 35.4921 18.5134 47.0951
   STATUS ON
  COLOR -1 -1 -1
  OUTLINECOLOR 255 0 0
  SIZE 160 120      
END

#
# Start of legend
#
LEGEND
  KEYSIZE 18 12
  LABEL
    TYPE BITMAP
    SIZE MEDIUM
    COLOR 0 0 89
  END
  STATUS ON
END

#
# Start of scalebar
#
SCALEBAR
  IMAGECOLOR 255 255 255
  LABEL
    COLOR 0 0 0 
    SIZE SMALL
  END
  SIZE 200 5
  COLOR 255 255 255
  BACKGROUNDCOLOR 0 0 0
  OUTLINECOLOR 0 0 0
  UNITS kilometers
  INTERVALS 4
  STATUS ON
END


QUERYMAP
  STATUS ON
  STYLE HILITE
  COLOR 255 0 0
END


#
# Start of layer definitions
#


LAYER
  NAME Italy
  METADATA
    "DESCRIPTION" "Italy"
  END
  TYPE POLYGON
  STATUS ON
  DATA Italia_Regioni
  CLASS
     COLOR 225 255 0
     OUTLINECOLOR 0 0 0
  END  
END

LAYER
  NAME Comuni
  TYPE POLYGON
  STATUS OFF
  DATA AdminBndyB
  MINSCALE 10000
  MAXSCALE 1000000
 
  CLASS
     COLOR 225 225 225
     OUTLINECOLOR 0 0 0
  END
END


LAYER
  NAME ComuniQ
  METADATA
	"DESCRIPTION" "Comuni"
	"RESULT_FIELDS" "POLY_NM"
  END
  DATA AdminBndyB
  STATUS OFF
  TYPE POLYGON 
  CLASS
     COLOR 225 225 225
     OUTLINECOLOR 0 0 0
	TEMPLATE market_comuni_query.html
  END
END

LAYER
  NAME PCitta
  TYPE POLYGON
  STATUS ON
  DATA ToMiRm
  MINSCALE 300001
  LABELITEM "COMUNE"
  LABELMINSCALE 10000

  CLASS
     COLOR 0 255 0
     OUTLINECOLOR 0 0 0
     LABEL
        MINSIZE 7
        MAXSIZE 25
        POSITION cc
        COLOR 255 0 0
        #BACKGROUNDSHADOWCOLOR 128 128 128
        TYPE TRUETYPE
	  FONT arial
        ANTIALIAS true
       END

  END  
END

LAYER
  NAME Deformata
  TYPE LINE
  STATUS OFF
  DATA Torino_deformata
  MAXSCALE 300000
  CLASS
     COLOR 0 0 255
     OUTLINECOLOR 0 0 0
  END  
END


LAYER
  NAME strade
  TYPE LINE
  STATUS OFF
  DATA Streets
  MAXSCALE 300000
  TOLERANCE 3
  LABELITEM "St_Name"
  LABELMAXSCALE 7000
  CLASS
      EXPRESSION ([Lane_Cat]>1)
      SYMBOL "big_street"
      BACKGROUNDCOLOR 255 0 0
      COLOR 255 0 0
      LABEL
        MINSIZE 5
        MAXSIZE 18
        POSITION AUTO
        ANGLE AUTO
        PARTIALS false
        MINDISTANCE 600
        COLOR 0 0 0
        BACKGROUNDSHADOWCOLOR 128 128 128
        TYPE TRUETYPE
	  FONT arial
        ANTIALIAS true
       END
  END
    CLASS
      EXPRESSION ([Lane_Cat]=1)
      COLOR 0 0 0
      LABEL
        MINSIZE 5
        MAXSIZE 18
        POSITION AUTO
        ANGLE AUTO
        PARTIALS false
        MINDISTANCE 600
        COLOR 0 0 0
        BACKGROUNDSHADOWCOLOR 128 128 128
        TYPE TRUETYPE
	FONT arial
        ANTIALIAS true
       END
  END
END # streets



LAYER
STATUS ON
NAME "stradeQ"
CONNECTIONTYPE postgis
CONNECTION "user=postgres password=postgres dbname=market port=5432" 
DATA "the_geom from streets"
TYPE LINE

FILTER "(upper(st_nm_base) Like upper('%street%')) AND (l_area_id='%value%')
AND ('%number%'='' or '%number%' between l_refaddr and l_nrefaddr or '%number%'
between r_refaddr and r_nrefaddr or '%number%' between l_nrefaddr and l_refaddr or '%number%'
between r_nrefaddr and r_refaddr)"



CLASS
  SYMBOL 0
  OUTLINECOLOR 25 25 0
END

HEADER market.html
TEMPLATE blank.html

END


END # Map File










[prev in list] [next in list] [prev in thread] [next in thread]