Mark,
Try a MapBasic command like
Select Sum(Capacity) from Centers, CensusRegions where CensusRegions.Obj
Contains Centers.Obj group by CensusRegions.CensusTractID into Selection
Note that 'CensusTractID' connotes a field in your census table which is
unique for each census region. You may also wish to sub-select those
Census Regions that are within the county boundary, or change your
'where' clause with something like
.. where (CensusRegions.Obj Contains CensusRegions.Obj group by
CensusRegions.CensusTractID And (CensusRegions.State = "CA" And
CensusRegions.County = "Alameda")) ..
Or perhaps use a fips code. You can select addtional columns into your
query as well..
- Tom
**********************************
Tom A. White, GIS Programmer / Analyst
Schlosser Geographic Systems, Inc.
http://www.sgsi.com [EMAIL PROTECTED]
Two Union Sq. 601 Union St. Seattle, WA 98101 USA
(206) 224 - 0800 fax: (206) 467 - 0458
>----------
>From: Mark Woo[SMTP:[EMAIL PROTECTED]]
>Sent: Tuesday, October 19, 1999 4:35 PM
>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]
