Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 3 of 3

Census Tract Input Field

This is a discussion on Census Tract Input Field within the MapPoint Desktop Discussion forums, part of the Map Forums category; How should the census tract field be formatted for Mappoint 2002 to understand it. First I had it as a ...

  1. #1
    Jim Grace is offline Junior Member White Belt
    Join Date
    Dec 2002
    Posts
    4

    Census Tract Input Field

    How should the census tract field be formatted for Mappoint 2002 to understand it.

    First I had it as a 4 digit number 0050 or 1641 etc.,, I then changed the format to 50.00 or 16.41. This appeared to be putting it in the format that Mappoint 2002 would display on some sample maps.

    Census Tracts are not tied to a certain location. I might have a census tract 16.41 in Los Angeles, another 16.41 in Omaha and another 16.41 in New York. Thus all of my census tracts were not matched when I ran the mapping wizard. Do I need to reformat them again so that the input looks like 16.41,Los Angeles,CA....?

    I currently have to bring up each unmatched record and match it up with the right census city state combination that is listed.

  2. #2
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    I think you have to include your state name (or abbreviation) and county name in your data set. I did that and it seemed to work. My problem is that my census tracts are based on the 2000 census, and I think the ones in MapPoint are based on the 1990 census. I have tract numbers in my data that don't seem to exist in MapPoint, and there are some in MapPoint that don't seem to exist in my dataset.
    Sigh...

  3. #3
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137

    Census Tact field

    :P

    I have fought this very issue for the last 2 days straight, and came up with an inelegant solution . . .

    In my data set (an Excel spreadsheet) I added a field for State and county, then had a field for the 4 digit census tract.

    Do a Google search on Census tract codes. You'll find your way to a census.gov TIGER site that talks about converting 2000 tracts to 1990 tracts. You can then download an entire state's list of census codes that will include the 1990 code, 2000 code and some other population info (it is almost all numbers without field names).

    Some of the web screens will help you understand what the census codes mean (like what it looks like when a 1990 tract has been split into 2 2000 tracts, or mergers, deletions, additions, or other stuff). I MANUALLY matched my 2k codes with the 1990 (270 records), then was able to have Mappoint plot the data.

    It wasn't too bad, just alot of time staring at pages of #'s.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. appending census tract to a pushpoint
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 5
    Last Post: 12-15-2010, 10:11 AM
  2. Getting Census Tract from a pushpin
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 06-06-2005, 11:09 AM
  3. trying to automate lat long (pushpin) to census tract mappin
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 02-02-2005, 11:54 AM
  4. Problems importing census tract data into MapPoint
    By tblazer in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 12-12-2004, 04:06 PM
  5. census tract format
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 10-17-2003, 07:03 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83