Spatial Synthesis
Volume II, Book 1:
Scientific, Planning, Humanitarian, and Teaching Applications, From DevInfo to Google Earth


ASSESSMENT

This chapter is split into sections arranged by continent (as defined in DevInfo).  Within each continent, subsections are created according to software.  Thus, one moves from the database in DevInfo, from which only indicators available for all countries are extracted, to GIS software, to Google Earth.  The path through this maze of software interfaces is complex.  It helps to keep the big picture in mind that the ultimate goal is 3D visualization of data sets.  At each stage, there are files available to download.  The ones that the reader needs to download, in order to read later sections of the book effectively, are the .kml files for Google Earth.  Reference will be made later in this document to such files.

The strategy for moving from one software package to another is presented in great detail for Africa.  For other continents, files are available for download and the reader should follow the steps in the process in the Africa section.  Click on the linked continent names below (names as used in DevInfo) to see more.

AFRICA
DevInfo:  there are 8 indicators available for all nations.  The "raw .apr" files are the GIS files extracted from the underlying DevInfo database.  These files may be opened directly in ArcView 3.2+ and may be imported into ArcMap 9.2+.  The path of bringing them into ArcView 3.2+ and then into ArcMap 9.2+ produces results that are more reliable than simply importing them into ArcMap 9.x.

Indicators Available:
  • Maternal mortality ratio, Deaths per 100,000 Live Births, Total
  • Prevalence of underweight (moderate and Severe), Percent, Total <5yr.
  • Primary completion rate, Rate, Total
  • Proportion of 1 year-old children immunised against measles, percent, total 1yr
  • Proportion of births attended by skilled helath personnel, Percent, Total
  • Proportion of population with access to improved sanitation, Percent, Total
  • Proportion of population with sustainable access to an improved water source, Percent, Total
  • Under-five mortality rate, Deaths per 1000 live births, Total
Raw .apr Files:
  • Maternal mortality ratio, raw .apr
  • Prevalence of underweight (moderate and severe)--Percent, Total < 5 yr., raw .apr
  • Primary Completion Rate, Rate, Total, raw .apr
  • Proportion of 1 year-old children immunised against measles, Percent, Total 1 yr., raw .apr
  • Proportion of births attended by skilled health personnel, Percent, Total, raw .apr
  • Proportion of population with access to improved sanitation, Percent, Total, raw .apr
  • Proportion of population with sustainable access to an improved water source, Percent, Total, raw .apr
  • Under-five mortality rate, Deaths per 1000 live births, Total, raw .apr
ArcView 3.2+:  the raw .apr files generated above are opened in ArcView 3.2+ and the underlying database is edited in ways that will eventually create files that will work well in Google Earth.  These new .apr files are referred to below as "edited .apr" files.

Edited .apr Files:
  • Maternal mortality ratio, edited .apr
  • Prevalence of underweight (moderate and severe)--Percent, Total < 5 yr., edited .apr
  • Primary Completion Rate, Rate, Total, edited .apr
  • Proportion of 1 year-old children immunised against measles, Percent, Total 1 yr., edited .apr
  • Proportion of births attended by skilled health personnel, Percent, Total, edited .apr
  • Proportion of population with access to improved sanitation, Percent, Total, edited .apr
  • Proportion of population with sustainable access to an improved water source, Percent, Total, edited .apr
  • Under-five mortality rate, Deaths per 1000 live births, Total, edited .apr
ArcCatalog:  the shape files in the edited .apr files  need to be "projected" to make them display properly in ArcMap 9.2+.   Download all four file formats for each map and put them in a single folder.

Projected Shape Files:
  • Maternal mortality ratio:  |  dbf prj  |  shp  |  shx  |
  • Prevalence of underweight (moderate and severe)--Percent, Total < 5 yr.:  |  dbf  |  prj  |  shp  |  shx  |
  • Primary Completion Rate, Rate, Total:  dbf  |  prj  |  shp  |  shx  |
  • Proportion of 1 year-old children immunised against measles, Percent, Total 1 yr.:  |  dbf  |  prj  |  shp  |  shx  |
  • Proportion of births attended by skilled health personnel, Percent, Total:  dbf  |  prj  |  shp  |  shx  |
  • Proportion of population with access to improved sanitation, Percent, Total:  |  dbf  |  prj  |  shp  |  shx  |
  • Proportion of population with sustainable access to an improved water source, Percent, Total:  |  dbf  |  prj  |  shp  |  shx  |
  • Under-five mortality rate, Deaths per 1000 live births, Total:  |  dbf  |  prj  |  shp  |  shx  |
ArcMap 9.2+:  the shape files are opened in ArcMap and a choropleth map is created from them.  The results are saved in the native .mxd format (again, available for download).  When ArcMap has a plug-in added to it, these files can be converted to .kml files suitable for display in Google Earth.  Download and install "export shape to KML" plug-in for ArcMap 9.2+.

Set of Choropleth Maps from Shape Files:
All available indicators in a single file, mxd format
Raw .kml Files:
  • Maternal mortality ratio, kml
  • Prevalence of underweight (moderate and severe)--Percent, Total < 5 yr., kml
  • Primary Completion Rate, Rate, Total, kml
  • Proportion of 1 year-old children immunised against measles, Percent, Total 1 yr., kml
  • Proportion of births attended by skilled health personnel, Percent, Total, kml
  • Proportion of population with access to improved sanitation, Percent, Total, kml
  • Proportion of population with sustainable access to an improved water source, Percent, Total, kml
  • Under-five mortality rate, Deaths per 1000 live births, Total, kml
Google Earth:  further editing of .kml files can take place in Google Earth.

Edited .kml Files:
  • Maternal mortality ratio, edited kml
  • Prevalence of underweight (moderate and severe)--Percent, Total < 5 yr., edited kml
  • Primary Completion Rate, Rate, Total, edited kml
  • Proportion of 1 year-old children immunised against measles, Percent, Total 1 yr., edited kml
  • Proportion of births attended by skilled health personnel, Percent, Total, edited kml
  • Proportion of population with access to improved sanitation, Percent, Total, edited kml
  • Proportion of population with sustainable access to an improved water source, Percent, Total, edited kml
  • Under-five mortality rate, Deaths per 1000 live births, Total, edited kml
ASIA
DevInfo:  there are 8 indicators available for all nations.  The "raw .apr" files are the GIS files extracted from the underlying DevInfo database.  These files may be opened directly in ArcView 3.2+ and may be imported into ArcMap 9.2+.  The path of bringing them into ArcView 3.2+ and then into ArcMap 9.2+ produces results that are more reliable than simply importing them into ArcMap 9.2+.

Indicators Available:
  • Maternal mortality ratio, Deaths per 100,000 Live Births, Total
  • Prevalence of underweight (moderate and Severe), Percent, Total <5yr.
  • Primary completion rate, Rate, Total
  • Proportion of 1 year-old children immunised against measles, percent, total 1yr
  • Proportion of births attended by skilled helath personnel, Percent, Total
  • Proportion of population with access to improved sanitation, Percent, Total
  • Proportion of population with sustainable access to an improved water source, Percent, Total
  • Under-five mortality rate, Deaths per 1000 live births, Total
Raw .apr Files:
  • Maternal mortality ratio, raw .apr
  • Prevalence of underweight (moderate and severe)--Percent, Total < 5 yr., raw .apr
  • Primary Completion Rate, Rate, Total, raw .apr
  • Proportion of 1 year-old children immunised against measles, Percent, Total 1 yr., raw .apr
  • Proportion of births attended by skilled health personnel, Percent, Total, raw .apr
  • Proportion of population with access to improved sanitation, Percent, Total, raw .apr
  • Proportion of population with sustainable access to an improved water source, Percent, Total, raw .apr
  • Under-five mortality rate, Deaths per 1000 live births, Total, raw .apr
ArcView 3.2+:  the raw .apr files generated above are opened in ArcView 3.2+ and the underlying database is edited in ways that will eventually create files that will work well in Google Earth.  These new .apr files are referred to below as "edited .apr" files.

Edited .apr Files:
  • Maternal mortality ratio, edited .apr
  • Prevalence of underweight (moderate and severe)--Percent, Total < 5 yr., edited .apr
  • Primary Completion Rate, Rate, Total, edited .apr
  • Proportion of 1 year-old children immunised against measles, Percent, Total 1 yr., edited .apr
  • Proportion of births attended by skilled health personnel, Percent, Total, edited .apr
  • Proportion of population with access to improved sanitation, Percent, Total, edited .apr
  • Proportion of population with sustainable access to an improved water source, Percent, Total, edited .apr
  • Under-five mortality rate, Deaths per 1000 live births, Total, edited .apr
ArcCatalog:  the shape files in the edited .apr files  need to be "projected" to make them display properly in ArcMap 9.2+.   Download all four file formats for each map and put them in a single folder.

Projected Shape Files:
  • Maternal mortality ratio:  |  dbf prj  |  shp  |  shx  |
  • Prevalence of underweight (moderate and severe)--Percent, Total < 5 yr.:  |  dbf  |  prj  |  shp  |  shx  |
  • Primary Completion Rate, Rate, Total:  dbf  |  prj  |  shp  |  shx  |
  • Proportion of 1 year-old children immunised against measles, Percent, Total 1 yr.:  |  dbf  |  prj  |  shp  |  shx  |
  • Proportion of births attended by skilled health personnel, Percent, Total:  dbf  |  prj  |  shp  |  shx  |
  • Proportion of population with access to improved sanitation, Percent, Total:  |  dbf  |  prj  |  shp  |  shx  |
  • Proportion of population with sustainable access to an improved water source, Percent, Total:  |  dbf  |  prj  |  shp  |  shx  |
  • Under-five mortality rate, Deaths per 1000 live births, Total:  |  dbf  |  prj  |  shp  |  shx  |
ArcMap 9.2+:  the shape files are opened in ArcMap and a choropleth map is created from them.  The results are saved in the native .mxd format (again, available for download).  When ArcMap has a plug-in added to it, these files can be converted to .kml files suitable for display in Google Earth.  Download and install "export shape to KML" plug-in for ArcMap 9.2+.
Set of Choropleth Maps from Shape Files:
All available indicators in a single file, mxd format
Raw .kml Files:
  • Maternal mortality ratio, kml
  • Prevalence of underweight (moderate and severe)--Percent, Total < 5 yr., kml
  • Primary Completion Rate, Rate, Total, kml
  • Proportion of 1 year-old children immunised against measles, Percent, Total 1 yr., kml
  • Proportion of births attended by skilled health personnel, Percent, Total, kml
  • Proportion of population with access to improved sanitation, Percent, Total, kml
  • Proportion of population with sustainable access to an improved water source, Percent, Total, kml
  • Under-five mortality rate, Deaths per 1000 live births, Total, kml
Google Earth:  further editing of .kml files can take place in Google Earth.

Edited .kml Files:  Suggestions are given in the files for Africa.  There is a great deal of variation in how one might choose to edit these files depending on desired visual and comparative outcomes.
EUROPE
DevInfo:  there are 8 indicators available for all nations.  The "raw .apr" files are the GIS files extracted from the underlying DevInfo database.  These files may be opened directly in ArcView 3.2+ and may be imported into ArcMap 9.2+.  The path of bringing them into ArcView 3.2+ and then into ArcMap 9.2+ produces results that are more reliable than simply importing them into ArcMap 9.2+.

Indicators Available:
  • Maternal mortality ratio, Deaths per 100,000 Live Births, Total
  • Prevalence of underweight (moderate and Severe), Percent, Total <5yr.
  • Primary completion rate, Rate, Total
  • Proportion of 1 year-old children immunised against measles, percent, total 1yr
  • Proportion of births attended by skilled helath personnel, Percent, Total
  • Proportion of population with access to improved sanitation, Percent, Total
  • Proportion of population with sustainable access to an improved water source, Percent, Total
  • Under-five mortality rate, Deaths per 1000 live births, Total
Raw .apr Files:
  • Maternal mortality ratio, raw .apr
  • Prevalence of underweight (moderate and severe)--Percent, Total < 5 yr., raw .apr
  • Primary Completion Rate, Rate, Total, raw .apr
  • Proportion of 1 year-old children immunised against measles, Percent, Total 1 yr., raw .apr
  • Proportion of births attended by skilled health personnel, Percent, Total, raw .apr
  • Proportion of population with access to improved sanitation, Percent, Total, raw .apr
  • Proportion of population with sustainable access to an improved water source, Percent, Total, raw .apr
  • Under-five mortality rate, Deaths per 1000 live births, Total, raw .apr
ArcView 3.2+:  the raw .apr files generated above are opened in ArcView 3.2+ and the underlying database is edited in ways that will eventually create files that will work well in Google Earth.  These new .apr files are referred to below as "edited .apr" files.

Edited .apr Files:
  • Maternal mortality ratio, edited .apr
  • Prevalence of underweight (moderate and severe)--Percent, Total < 5 yr., edited .apr
  • Primary Completion Rate, Rate, Total, edited .apr
  • Proportion of 1 year-old children immunised against measles, Percent, Total 1 yr., edited .apr
  • Proportion of births attended by skilled health personnel, Percent, Total, edited .apr
  • Proportion of population with access to improved sanitation, Percent, Total, edited .apr
  • Proportion of population with sustainable access to an improved water source, Percent, Total, edited .apr
  • Under-five mortality rate, Deaths per 1000 live births, Total, edited .apr
ArcCatalog:  the shape files in the edited .apr files  need to be "projected" to make them display properly in ArcMap 9.2+.   Download all four file formats for each map and put them in a single folder.

Projected Shape Files:
  • Maternal mortality ratio:  |  dbf prj  |  shp  |  shx  |
  • Prevalence of underweight (moderate and severe)--Percent, Total < 5 yr.:  |  dbf  |  prj  |  shp  |  shx  |
  • Primary Completion Rate, Rate, Total:  dbf  |  prj  |  shp  |  shx  |
  • Proportion of 1 year-old children immunised against measles, Percent, Total 1 yr.:  |  dbf  |  prj  |  shp  |  shx  |
  • Proportion of births attended by skilled health personnel, Percent, Total:  dbf  |  prj  |  shp  |  shx  |
  • Proportion of population with access to improved sanitation, Percent, Total:  |  dbf  |  prj  |  shp  |  shx  |
  • Proportion of population with sustainable access to an improved water source, Percent, Total:  |  dbf  |  prj  |  shp  |  shx  |
  • Under-five mortality rate, Deaths per 1000 live births, Total:  |  dbf  |  prj  |  shp  |  shx  |
ArcMap 9.2+:  the shape files are opened in ArcMap and a choropleth map is created from them.  The results are saved in the native .mxd format (again, available for download).  When ArcMap has a plug-in added to it, these files can be converted to .kml files suitable for display in Google Earth.  Download and install "export shape to KML" plug-in for ArcMap 9.2+.

Set of Choropleth Maps from Shape Files:
All available indicators in a single file, mxd format
In some cases, using "Natural Breaks" for data classification yielded fewer than 8 classes.  In those cases, the maximum number available was used.
Raw .kml Files:
  • Maternal mortality ratio, kml
  • Prevalence of underweight (moderate and severe)--Percent, Total < 5 yr., kml
  • Primary Completion Rate, Rate, Total, kml
  • Proportion of 1 year-old children immunised against measles, Percent, Total 1 yr., kml
  • Proportion of births attended by skilled health personnel, Percent, Total, kml
  • Proportion of population with access to improved sanitation, Percent, Total, kml
  • Proportion of population with sustainable access to an improved water source, Percent, Total, kml
  • Under-five mortality rate, Deaths per 1000 live births, Total, kml
Google Earth:  further editing of .kml files can take place in Google Earth.

Edited .kml Files:  Suggestions are given in the files for Africa.  There is a great deal of variation in how one might choose to edit these files depending on desired visual and comparative outcomes.
LATIN AMERICA
DevInfo:  there are 8 indicators available for all nations.  The "raw .apr" files are the GIS files extracted from the underlying DevInfo database.  These files may be opened directly in ArcView 3.2+ and may be imported into ArcMap 9.2+.  The path of bringing them into ArcView 3.2+ and then into ArcMap 9.2+ produces results that are more reliable than simply importing them into ArcMap 9.2+.

Indicators Available:
  • Maternal mortality ratio, Deaths per 100,000 Live Births, Total
  • Prevalence of underweight (moderate and Severe), Percent, Total <5yr.
  • Primary completion rate, Rate, Total
  • Proportion of 1 year-old children immunised against measles, percent, total 1yr
  • Proportion of births attended by skilled helath personnel, Percent, Total
  • Proportion of population with access to improved sanitation, Percent, Total
  • Proportion of population with sustainable access to an improved water source, Percent, Total
  • Under-five mortality rate, Deaths per 1000 live births, Total
Raw .apr Files:
  • Maternal mortality ratio, raw .apr
  • Prevalence of underweight (moderate and severe)--Percent, Total < 5 yr., raw .apr
  • Primary Completion Rate, Rate, Total, raw .apr
  • Proportion of 1 year-old children immunised against measles, Percent, Total 1 yr., raw .apr
  • Proportion of births attended by skilled health personnel, Percent, Total, raw .apr
  • Proportion of population with access to improved sanitation, Percent, Total, raw .apr
  • Proportion of population with sustainable access to an improved water source, Percent, Total, raw .apr
  • Under-five mortality rate, Deaths per 1000 live births, Total, raw .apr
ArcView 3.2+:  the raw .apr files generated above are opened in ArcView 3.2+ and the underlying database is edited in ways that will eventually create files that will work well in Google Earth.  These new .apr files are referred to below as "edited .apr" files.


Edited .apr Files:
  • Maternal mortality ratio, edited .apr
  • Prevalence of underweight (moderate and severe)--Percent, Total < 5 yr., edited .apr
  • Primary Completion Rate, Rate, Total, edited .apr
  • Proportion of 1 year-old children immunised against measles, Percent, Total 1 yr., edited .apr
  • Proportion of births attended by skilled health personnel, Percent, Total, edited .apr
  • Proportion of population with access to improved sanitation, Percent, Total, edited .apr
  • Proportion of population with sustainable access to an improved water source, Percent, Total, edited .apr
  • Under-five mortality rate, Deaths per 1000 live births, Total, edited .apr
ArcCatalog:  the shape files in the edited .apr files  need to be "projected" to make them display properly in ArcMap 9.2+.   Download all four file formats for each map and put them in a single folder.


Projected Shape Files:
  • Maternal mortality ratio:  |  dbf prj  |  shp  |  shx  |
  • Prevalence of underweight (moderate and severe)--Percent, Total < 5 yr.:  |  dbf  |  prj  |  shp  |  shx  |
  • Primary Completion Rate, Rate, Total:  dbf  |  prj  |  shp  |  shx  |
  • Proportion of 1 year-old children immunised against measles, Percent, Total 1 yr.:  |  dbf  |  prj  |  shp  |  shx  |
  • Proportion of births attended by skilled health personnel, Percent, Total:  dbf  |  prj  |  shp  |  shx  |
  • Proportion of population with access to improved sanitation, Percent, Total:  |  dbf  |  prj  |  shp  |  shx  |
  • Proportion of population with sustainable access to an improved water source, Percent, Total:  |  dbf  |  prj  |  shp  |  shx  |
  • Under-five mortality rate, Deaths per 1000 live births, Total:  |  dbf  |  prj  |  shp  |  shx  |
ArcMap 9.2+:  the shape files are opened in ArcMap and a choropleth map is created from them.  The results are saved in the native .mxd format (again, available for download).  When ArcMap has a plug-in added to it, these files can be converted to .kml files suitable for display in Google Earth.  Download and install "export shape to KML" plug-in for ArcMap 9.2+.

Set of Choropleth Maps from Shape Files:
All available indicators in a single file, mxd format
Raw .kml Files:
  • Maternal mortality ratio, kml
  • Prevalence of underweight (moderate and severe)--Percent, Total < 5 yr., kml
  • Primary Completion Rate, Rate, Total, kml
  • Proportion of 1 year-old children immunised against measles, Percent, Total 1 yr., kml
  • Proportion of births attended by skilled health personnel, Percent, Total, kml
  • Proportion of population with access to improved sanitation, Percent, Total, kml
  • Proportion of population with sustainable access to an improved water source, Percent, Total, kml
  • Under-five mortality rate, Deaths per 1000 live births, Total, kml
Google Earth:  further editing of .kml files can take place in Google Earth.

Edited .kml Files:  Suggestions are given in the files for Africa.  There is a great deal of variation in how one might choose to edit these files depending on desired visual and comparative outcomes.
NORTHERN AMERICA
DevInfo:  there are 5 indicators available for all nations.  The "raw .apr" files are the GIS files extracted from the underlying DevInfo database.  These files may be opened directly in ArcView 3.2+ and may be imported into ArcMap 9.2+.  The path of bringing them into ArcView 3.2+ and then into ArcMap 9.2+ produces results that are more reliable than simply importing them into ArcMap 9.2+.


Indicators Available:
  • Maternal mortality ratio, Deaths per 100,000 Live Births, Total
  • Proportion of 1 year-old children immunised against measles, percent, total 1yr
  • Proportion of births attended by skilled helath personnel, Percent, Total
  • Proportion of population with sustainable access to an improved water source, Percent, Total
  • Under-five mortality rate, Deaths per 1000 live births, Total
Raw .apr Files:
  • Maternal mortality ratio, Deaths per 100,000 Live Births, Total, raw .apr
  • Proportion of 1 year-old children immunised against measles, percent, total 1yr, raw .apr
  • Proportion of births attended by skilled helath personnel, Percent, Total, raw .apr
  • Proportion of population with access to improved sanitation, Percent, Total, raw .apr
  • Proportion of population with sustainable access to an improved water source, Percent, Total, raw .apr
  • Under-five mortality rate, Deaths per 1000 live births, Total, raw .apr
ArcView 3.2+:  the raw .apr files generated above are opened in ArcView 3.2+ and the underlying database is edited in ways that will eventually create files that will work well in Google Earth.  These new .apr files are referred to below as "edited .apr" files.


Edited .apr Files:
  • Maternal mortality ratio, Deaths per 100,000 Live Births, Total, edited .apr
  • Proportion of 1 year-old children immunised against measles, percent, total 1yr, edited .apr
  • Proportion of births attended by skilled helath personnel, Percent, Total, edited .apr
  • Proportion of population with access to improved sanitation, Percent, Total, edited .apr
  • Proportion of population with sustainable access to an improved water source, Percent, Total, edited .apr
  • Under-five mortality rate, Deaths per 1000 live births, Total, edited .apr
ArcCatalog:  the shape files in the edited .apr files  need to be "projected" to make them display properly in ArcMap 9.2+.   Download all four file formats for each map and put them in a single folder.


Projected Shape Files: 
  • Maternal mortality ratio:  |  dbf prj  |  shp  |  shx  |
  • Proportion of 1 year-old children immunised against measles, Percent, Total 1 yr.:  |  dbf  |  prj  |  shp  |  shx  |
  • Proportion of births attended by skilled health personnel, Percent, Total:  dbf  |  prj  |  shp  |  shx  |
  • Proportion of population with access to improved sanitation, Percent, Total:  |  dbf  |  prj  |  shp  |  shx  |
  • Proportion of population with sustainable access to an improved water source, Percent, Total:  |  dbf  |  prj  |  shp  |  shx  |
  • Under-five mortality rate, Deaths per 1000 live births, Total:  |  dbf  |  prj  |  shp  |  shx  |
ArcMap 9.2+:  the shape files are opened in ArcMap and a choropleth map is created from them.  The results are saved in the native .mxd format (again, available for download).  When ArcMap has a plug-in added to it, these files can be converted to .kml files suitable for display in Google Earth.  Download and install "export shape to KML" plug-in for ArcMap 9.2+.

Set of Choropleth Maps from Shape Files:
All available indicators in a single file, mxd format
In some cases, using "Natural Breaks" for data classification yielded fewer than 8 classes.  In those cases, the maximum number available was used.
Raw .kml Files:
  • Maternal mortality ratio, Deaths per 100,000 Live Births, Total, kml
  • Proportion of 1 year-old children immunised against measles, percent, total 1yr, kml
  • Proportion of births attended by skilled helath personnel, Percent, Total, kml
  • Proportion of population with access to improved sanitation, Percent, Total, kml
  • Proportion of population with sustainable access to an improved water source, Percent, Total, kml
  • Under-five mortality rate, Deaths per 1000 live births, Total, kml
Google Earth:  further editing of .kml files can take place in Google Earth.

Edited .kml Files:  Suggestions are given in the files for Africa.  There is a great deal of variation in how one might choose to edit these files depending on desired visual and comparative outcomes.
OCEANIA
DevInfo:  there are 7 indicators available for all nations.  The "raw .apr" files are the GIS files extracted from the underlying DevInfo database.  These files may be opened directly in ArcView 3.2+ and may be imported into ArcMap 9.2+.  The path of bringing them into ArcView 3.2+ and then into ArcMap 9.2+ produces results that are more reliable than simply importing them into ArcMap 9.2+.


Indicators Available:
  • Maternal mortality ratio, Deaths per 100,000 Live Births, Total
  • Primary completion rate, Rate, Total
  • Proportion of 1 year-old children immunised against measles, percent, total 1yr
  • Proportion of births attended by skilled helath personnel, Percent, Total
  • Proportion of population with access to improved sanitation, Percent, Total
  • Proportion of population with sustainable access to an improved water source, Percent, Total
  • Under-five mortality rate, Deaths per 1000 live births, Total
Raw .apr Files:
  • Maternal mortality ratio, Deaths per 100,000 Live Births, Total, raw .apr
  • Primary completion rate, Rate, Total, raw .apr
  • Proportion of 1 year-old children immunised against measles, percent, total 1yr, raw .apr
  • Proportion of births attended by skilled helath personnel, Percent, Total, raw .apr
  • Proportion of population with access to improved sanitation, Percent, Total, raw .apr
  • Proportion of population with sustainable access to an improved water source, Percent, Total, raw .apr
  • Under-five mortality rate, Deaths per 1000 live births, Total, raw .apr
ArcView 3.2+:  the raw .apr files generated above are opened in ArcView 3.2+ and the underlying database is edited in ways that will eventually create files that will work well in Google Earth.  These new .apr files are referred to below as "edited .apr" files.


Edited .apr Files:
  • Maternal mortality ratio, edited .apr
  • Primary Completion Rate, Rate, Total, edited .apr
  • Proportion of 1 year-old children immunised against measles, Percent, Total 1 yr., edited .apr
  • Proportion of births attended by skilled health personnel, Percent, Total, edited .apr
  • Proportion of population with access to improved sanitation, Percent, Total, edited .apr
  • Proportion of population with sustainable access to an improved water source, Percent, Total, edited .apr
  • Under-five mortality rate, Deaths per 1000 live births, Total, edited .apr
ArcCatalog:  the shape files in the edited .apr files  need to be "projected" to make them display properly in ArcMap 9.2+.   Download all four file formats for each map and put them in a single folder.


Projected Shape Files:
  • Maternal mortality ratio:  |  dbf prj  |  shp  |  shx  |
  • Primary Completion Rate, Rate, Total:  dbf  |  prj  |  shp  |  shx  |
  • Proportion of 1 year-old children immunised against measles, Percent, Total 1 yr.:  |  dbf  |  prj  |  shp  |  shx  |
  • Proportion of births attended by skilled health personnel, Percent, Total:  dbf  |  prj  |  shp  |  shx  |
  • Proportion of population with access to improved sanitation, Percent, Total:  |  dbf  |  prj  |  shp  |  shx  |
  • Proportion of population with sustainable access to an improved water source, Percent, Total:  |  dbf  |  prj  |  shp  |  shx  |
  • Under-five mortality rate, Deaths per 1000 live births, Total:  |  dbf  |  prj  |  shp  |  shx  |
ArcMap 9.2+:  the shape files are opened in ArcMap and a choropleth map is created from them.  The results are saved in the native .mxd format (again, available for download).  When ArcMap has a plug-in added to it, these files can be converted to .kml files suitable for display in Google Earth.  Download and install "export shape to KML" plug-in for ArcMap 9.2+.

Set of Choropleth Maps from Shape Files:
All available indicators in a single file, mxd format
In some cases, using "Natural Breaks" for data classification yielded fewer than 8 classes.  In those cases, the maximum number available was used.
Raw .kml Files:
  • Maternal mortality ratio, kml
  • Primary Completion Rate, Rate, Total, kml
  • Proportion of 1 year-old children immunised against measles, Percent, Total 1 yr., kml
  • Proportion of births attended by skilled health personnel, Percent, Total, kml
  • Proportion of population with access to improved sanitation, Percent, Total, kml
  • Proportion of population with sustainable access to an improved water source, Percent, Total, kml
  • Under-five mortality rate, Deaths per 1000 live births, Total, kml
Google Earth:  further editing of .kml files can take place in Google Earth.

Edited .kml Files:  Suggestions are given in the files for Africa.  There is a great deal of variation in how one might choose to edit these files depending on desired visual and comparative outcomes.

Technical notes:
http://support.esri.com/index.cfm?fa=knowledgebase.techarticles.articleShow&d=17424

TABLE OF CONTENTS


Software used in analysis:
  • DevInfo 5.0:  http://www.devinfo.org/
  • Adobe® PhotoShop and ImageReady
  • Adobe® DreamWeaver
  • ESRI:
    • ArcView® 3.2
    • ArcGIS® 9.2
      • ArcCatalog®
      • ArcMap®
  • Google Earth®

Author affiliations:
  • Arlinghaus, Sandra Lach.  Adjunct Professor of Mathematical Geography and Population-Environment Dynamics, School of Natural Resources and Environment, The University of Michigan.  Executive Committee Member (Secretary) Community Systems Foundation, sarhaus@umich.edu, http://www-personal.umich.edu/~sarhaus/
  • Naud, Matthew.  Environmental Coordinator and Assistant Emergency Manager, Systems Planning Unit, City of Ann Arbor
  • Oswalt, Kris S.  President, Community Systems Foundation
  • Rayle, Roger.  Scio Residents for Safe Water
  • Lars Schumann.  Manager and Research Computer Specialist, University of Michigan 3D Laboratory at the Duderstadt Center; also of Cornell University, Ithaca NY
  • Arlinghaus, William C.  Professor of Mathematics and Computer Science, Lawrence Technological University, Southfield, MI
  • Arlinghaus, William E.  General Manager, Chapel Hill Memorial Gardens, Grand Rapids, MI
  • Batty, Michael. Bartlett Professor of Planning and Director of the Centre for Advanced Spatial Analysis (CASA) at University College London
  • Haug, Robert.  Ph.D. Candidate, Middle Eastern and North African Studies, The University of Michigan
  • Larimore, Ann Evans.  Professor Emerita, Residential College, The University of Michigan
  • Longstreth, Karl.  Head, Map Library, The University of Michigan
  • Nystuen, Gwen L.  Parks Advisory Commission; Environmental Commission; City of Ann Arbor
  • Nystuen, John D.  Professor Emeritus of Geography and Urban Planning, Taubman College of Architecture and Urban Planning, The University of Michigan.  Chief Executive Officer, Community Systems Foundation

Published by:
Institute of Mathematical Geography

http://www.imagenet.org
http://deepblue.lib.umich.edu/handle/2027.42/58219
August, 2008.
Copyright by Sandra Arlinghaus, all rights reserved.