Quote:
Originally Posted by nortel07 I am trying to display county boundaries on a map however they only show when the map is zoomed in and in that case they show up as faint dashed lines. i would like to see the boundaries of the counties when the map is zoomed out enough to see the whole state. does anyone have any suggestions? thanks. |
Paul Larson gave me this idea from one of his posts, download Census 2000 County and County Equivalent Areas Cartographic Boundary Files from the U.S. Census Bureau at
http://www.census.gov/geo/www/cob/co2000.html#shp They are shape files. You can download them by state or the whole nation and then import them to MapPoint. For MapPoint 2002 and 2004 you will need MapPoint Spatial Data Import COM Add-in at
http://msdn2.microsoft.com/en-us/library/ms980069.aspx . The Boundaries will be "thick" black lines.
The only thing is the Census Bureau used two text fields for the FIPS codes, STATE (2) and COUNTY (3) [both with leading zeros], which is the correct way to represent the data. (some data, from the Census Bureau and other sources, for these fields does not have leading zeros because they used Excel). MapPoint uses five characters for the FIPS code to uniquely identify the County and County Equivalent Areas at that level/layer.
After I imported the Boundary Files, in my case I had to concatenate the STATE and COUNTY fields to create a MapPoint FIPS code (County) when I imported updated county level population data from Census Bureau's Population Estimates Data Sets at
Population Estimates Data Sets. Using MapPoint FIPS code and the Data import wizard mapped the data to all levels and I could get population estimates at the zip code and census tract level.
Population Estimates Data Sets do not have leading zeros, so you will have used Access (or another Database) to format the data so MapPoint can use it. Also when using the Data import wizard it automatically assumes that any five character number is a zip code, so you will have to change fields to skip or other data and change the MapPoint FIPS code field to county. In a Access query I reordered and renamed the fields and sorted the data, placing the the MapPoint FIPS code field first and renaming "county" and MapPoint was happy.
Paul's few little comments (about Boundary Files and FIPS codes) solved an issue I had for two years trying map some national plans. I could not get most of the jurisdiction names to match in Mappoint or the Census files, and only other data I had was the state and county names.
It was even more maddening when I found that county names in Census files do not match the same format used the Mappoint database, 50 % at times were no match on the first run and had to be manually matched. Not much fun with 3141 records.
BTW, FIPS codes work great too when creating multicounty territories.
I know this is bit more then you asked, however there have a few recent questions by "counties" I hope this helps.