MapForums

I searched on google and these forums before asking this question, so please bear with me if it is a repeat.

I have databases of about 10,000 records that I geocode and map by census tract, zip code, and etc.

I would like to be able to export my clients information into a spreadsheet and have the census tract included in the spreadsheet for each client. Then I can perform statistical analyses by census tract.

Thus far, I have only been able to export aggregated census tract data from MapPoint., and I wish to export census tract data for every record.

Bump for resolution. Any ideas, anyone?

does anyone know if this can be done?

thank you

If you have any idea about this, please post it. Even if you are not sure.

Hi,

What is: 'census tract data' ?
What you try to do, do you mean you dont know how to program it, or do you mean if it is something in the user interface of mappoint itself ?

__________________
rgds, Wilfried Mestdagh
www.mestdagh.biz
MapPoint coding demo
Order MapPoint 2009 with Routing and User Tools Spreadsheet

What I mean by "Census Tract" Data is this. I would like to be able to export the census tract of each address in my database. Currently, I can only export the aggregated numbers for census tracts, which do not help me.
So, if my data reads in as:
Name, Address, Zip Code, Gender, Age
I would like it to read out as
Name, Address, Zip Code, Gender, Age, Census Tract


Thanks,
-Tim

Hi Tim,

Still dont know what census tract is. Hope someone else jumps in here..

__________________
rgds, Wilfried Mestdagh
www.mestdagh.biz
MapPoint coding demo
Order MapPoint 2009 with Routing and User Tools Spreadsheet

A defenition i found:

What is a Census Tract?
A census tract is a small statistical subdivision of a county. Census tract data allows a user to find population and housing statistics about a specific part of an urban area. This is particularly important when you want information about part of a city, such as Northridge or other communities in the San Fernando Valley which are part of the City of Los Angeles. A single community may be composed of several census tracts.

But i'm wondering if mappoint has this data?
Is it something like a postal code?

The U.S. has a "Census Bureau" that is responsible for counting its citizens and their demographics. So, all of the U.S. is split into geographical units, known as "Census Tracts." For example, Baltimore City is divided into 200 Census Tracts.

Hi Jeurink,

Thanks for explaining it to me
According to the explanation it does not seems to me like a postal code, but more like parts of cities that does not have state borders. I dont know how to spit it out in english, maybe you know ?

for example we have city -> in city are 'gemeente' in 'gemeente' are 'wijk'. The last one is I think comparable to 'cencus track' (because a 'gemeente' can be from the city itself). What do you think ?

__________________
rgds, Wilfried Mestdagh
www.mestdagh.biz
MapPoint coding demo
Order MapPoint 2009 with Routing and User Tools Spreadsheet