ah Mark..... be glad to help....sounds like the application I first developed with Carl Samples of the Huntsville (Alabama) police department for tracking sex offenders. It's called Megans Mapper (was the very first in the Nation that we developed) and it makes use of child care center data for the nation..... I'd be very interested in helping you out for (FREE) and anyone else who is doing any application to protect our youths! -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mark Woo Sent: Tuesday, October 19, 1999 18:35 To: [EMAIL PROTECTED] Subject: MI Counting Site Capacities Within a Census Tract I need to add up the total capacity of multiple child care centers for each census tract in Alameda County. In one file I have the individual child care centers (a couple hundred sites throughout the County) and the capacity of each. Each of the child care sites is geocoded to an address. I need to calculate the total capacity of the child care centers in each of the census tracts (i.e. for the ten child care centers in tract X, they have a total capcity of Y). I know I can do it through an SQL query, but I'm not sure how to set it up. Any help would be appreciated. ===== __________________________________________________ Do You Yahoo!? Bid and sell for free at http://auctions.yahoo.com ---------------------------------------------------------------------- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED] ---------------------------------------------------------------------- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
