Hello,

Does anyone know if it is possible in any way to get access to the values of the MP demographic data? That is, not just the field name but the actual numeric value?

Thanks
MLM

All the demographics are in an mdb file (Access database) in the MapPoint directory.

I know people had figured out the password for the mdb file in the past -- does anyone remember what it would be for MapPoint 2006 ?

Something like geo13na ?

Eric

Thanks Eric,

Yes it would be helpful if someone did know the Password. (But, also, I wanted to confirm that it is not possible to get the values in a program, that is, not only get the name of geodemographic field, but the value?. I don't think it is - i guess you can only query and get values on none geodemographic data sets- , but wanted to confirm.

Best
M. Martin

Yes definitely - first map whatever demographic variable at whatever geographic level you desire and then draw a big rectangle or circle over the area you wish to export using the drawing tools.

Then right click on the rectangle or circle and do an Export to Excel. I'm sure this requires that Excel be installed but that's it!

Let me know if it would help for me to post a screenshot and an Excel file to illustrate, I would be happy to do it.

Eric

Thanks Again Eric,

That's a good idea - the Excel export- but, any ideas how I can get the geographic data values in the code - that is, I need to get the values into veriables in a routine and then add several together - I'm trying to create a composit demograpich of certain ages and ethnic data - and then use the data mathematically. ?

Thanks Again,
MLM

No, I think you'd have to Export to Excel and then pick up the values from there.

Eric

I am also trying to query the population values and perform a calculation on the numbers to determine market potential. I can't believe this information is not available. It's all right there! Why would they not provide access to the census data? It's not like you can't get it for free from the government US census website. Please tell me this isn't true. My app depends on it.

I'm working in C#, if anyone has example of how to make this possible.

Gosh I remember this thread.

I haven't done this actually, so I might want to retract my statement from 2007.

Two things

1. There is a password-protected Access database with all the demographic data. It would be a little bit of a challenge to match it with a polygon or shape on the map.

2. Use the QueryPolygon method, I haven't tried this, but you could potentially pass the demographic dataset to the QueryPolygon method and loop over the results in code.

Let us know how it goes.

Eric

I've heard rumors that the password for the MapPoint database was floating around the internet at one time. Has anyone successfully connected? Anyone know the password?