[Mapserver-users] JOIN problem

Randy James rjames57 at yahoo.com
Wed Jul 14 12:44:42 EDT 2004


Hi

That it is not a join problem but maybe a regex problem or
something else with the filter.

Randy

--- Rebecca Colwell <colwell at geog.umn.edu> wrote: > Hey
Randy,
> 
> Yes, it displays my US shapefile when I comment out that
> line.  What 
> does this tell you?
> 
> Thanks!
> 
> ~Becky
> 
> Randy James wrote:
> 
> > Hi
> > 
> > Will it work if you do not filter it by 'Disfchmt_R' ?
> > 
> > Randy
> > --- Rebecca Colwell <colwell at geog.umn.edu> wrote: > Hi,
> > 
> >>I'm trying to work through building one of my first
> .map
> >>files, and have 
> >>hit a wall.  I can't seem to figure out how to do a
> >>one-to-one join.  I 
> >>keep getting the error messages:
> >>
> >>msDrawMap(): Image handling error. Failed to draw layer
> >>named 'states'.
> >>msDBFGetItemIndex(): DBASE file error. Item
> 'Disfchmt_R'
> >>not found.
> >>
> >>I triple checked the .dbf I'm trying to join, and that
> is
> >>the name of 
> >>the attribute field I want to access.
> >>
> >>Below is my short bit of code so far.  I would be so
> >>thankful if anyone 
> >>could guide me in the right direction on how to get it
> to
> >>work.
> >>
> >>~Becky
> >>
> >>
> >>MAP
> >>   IMAGETYPE      PNG24
> >>   EXTENT         -2153561.581984760 4847233.565621579
> >>2641846.236294404 
> >>-6178805.564371807
> >>   SIZE           800 500
> >>   SHAPEPATH      "data"
> >>   IMAGECOLOR     203 201 226
> >>
> >>   PROJECTION
> >>     "proj=laea"
> >>     "ellps=clrk66"
> >>     "lat_0=45"
> >>     "lon_0=-100"
> >>   END
> >>
> >>   # Start of LAYER DEFINITIONS 
> >>---------------------------------------------
> >>   LAYER # States polygon layer begins here
> >>     NAME         states
> >>     DATA         STATES
> >>     STATUS       DEFAULT
> >>     TYPE         POLYGON
> >>
> >>     PROJECTION
> >>       "init=epsg:4326"
> >>     END
> >>
> >>     JOIN
> >>     	NAME 	"Felon Ethnicity"
> >>	TABLE	"data/FelonEthnicity.dbf"
> >>	FROM 	"STATE_NAME"
> >>	TO 	"STATE"
> >>     	TYPE 	single
> >>     END #Join
> >>
> >>     CLASS
> >>	NAME "<21%"
> >>	EXPRESSION ('[Disfchmt_R]' <= .021)
> >>	COLOR 242 240 247
> >>	OUTLINECOLOR 200 200 200
> >>       COLOR        232 232 232
> >>       OUTLINECOLOR 32 32 32
> >>     END
> >>
> >>   END # States polygon layer ends here
> >>   # End of LAYER DEFINITIONS
> >>-------------------------------
> >>
> >>END # end of map file/object
> >>
> >>
> >>_______________________________________________
> >>Mapserver-users mailing list
> >>Mapserver-users at lists.gis.umn.edu
>
>>http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
> >> 
> > 
> > 
> >
>
______________________________________________________________________
> 
> > Post your free ad now! http://personals.yahoo.ca
> > _______________________________________________
> > Mapserver-users mailing list
> > Mapserver-users at lists.gis.umn.edu
> >
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
> 
>  

______________________________________________________________________ 
Post your free ad now! http://personals.yahoo.ca



More information about the mapserver-users mailing list