Integrating attribute data from relational databases with Map Server

[Vinod Chettur]

Hi Stephen:
The rates are dynamically computed using stored procedures based on user
input. So for example, death rates/1000 by counties for cancer for a given
year are obtained as a result set:
County 1 - 4.2/1000
County 2 - 3.0/1000
and so on.

So I would like to represent these rates by county as color coded categories
such as

blue =  >0 and <1
green = >=1 and < 5
red >=5 etc.
Categories could be done in SQL itself if needed. Just wondering what my
strategy will be to merge this resultset with my counties shape file on the
fly.

Thanks, Vinod

> -----Original Message-----
> From:	Stephen Lime [SMTP:steve.lime at dnr.state.mn.us]
> Sent:	Thursday, August 10, 2000 12:00 PM
> To:	Vinod Chettur
> Subject:	Re: Integrating attribute data from relational databases
> with MapServer
> 
> Do you want to map the rates or display the rates summaries based on
> a users interaction with a map. Depending on what exactly you'd like to
> do there are different stratagies you can use.
> 
> Steve
> 
> Stephen Lime
> Internet Applications Analyst
> 
> Minnesota DNR
> 500 Lafayette Road
> St. Paul, MN 55155
> 651-297-2937
> 
> >>> Vinod Chettur <chetturv at sdhu.moh.gov.on.ca> 08/10/00 10:12AM >>>
> 	Hello everyone: 
> 	Just wondering about the state of things with regards to relational
> database integration with mapserver. I am currently invoking a bunch of
> stored SQL procedures to generate tabular reports of statistical
> computations done at the database server (NT 4.0 /SQL Server). I hope to
> be
> able to represent these statistical rates for various counties in Ontario
> using MapServer. Wondering if any pointers or examples are out there
> perhaps
> with the new PHP module or otherwise.
> 
> 	Thanks in advance, 
> 	Vinod Chettur
> 	Senior Systems Consultant, NHIP
> 	Canada
>