Both Guatemala City and Shanghai participate in the UNCHS Urban Indicators Program. As such, each city has available a comprehensive set of aggregate indicators in such subject areas as socio-economic development, infrastructure, transportation, environmental management, local government, and housing.

As part of this project, we have identified the most suitable geographic resolution(s) for each data item and an extendable database is designed to hold the baseline data. The database design includes capabilities for maintaining historical data, supporting future data collection and updating, and adding new indicator data items as they become available.

The identification of appropriate indicators is based on several factors. First, we have started with the list of key urban indicators provided by the UNCHS Urban Indicators Program. With some exceptions, our set of indicators falls within this list. Second, we have consulted with our international partners extensively on several occasions on the selection of sub-city indicators so that local research needs and interests can be fulfilled. Last, data availability is a critical factor in our selection, given that sub-city data is often lacking in many developing cities

Shanghai

Based on information provided by our partner and collected from Shanghai, we have developed and enriched our baseline set of sub-city urban indicators. As of now, the following categories of indicators have been developed for Shanghai (all at district level unless specifically noted):
 

Population and population density, 1996, 1997 and 1999
Natural population growth rate, 1997 and 1999
Sex ratio, 1995
Population age structure, 1995
Population and population density by subdistrict, 1997
 

Employment by sector, 1995
Employment by occupation, 1995
Unemployment, 1995
Employment and establishment by subdistrict, 1996
Revenue by sector by subdistrict, 1996
 

Hospital beds per thousand population, 1997 and 1999
Doctors per thousand population, 1997 and 1999
Educational levels, 1995
Illiteracy level by gender, 1995
Distribution of primary schools, 2000
Distribution of high schools, 2000
Elementary schools student and teacher ratio, 1997 and 1999
Middle schools student and teacher ratio, 1997 and 1999
Vocational schools student and teacher ratio, 1997 and 1999
Per capita green space, 1997 and 1999
Waste water treated, 2000
 

Housing by type, 1997 and 1999
Older housing stock, 1997 and 1999
Per capita housing area, 2000
 

Land use changes within Shanghai's built-up area at eight time periods, 1947-1996
Boundary changes within Shanghai's built-up area at eight time periods, 1947-1996
Land use pattern in Shanghai metropolitan area, 1994
Land use pattern within Shanghai's second ring road, 2000

  Guatemala City

We have been able to develop the following sub-city indicators (all at district level unless otherwise specified):

Percent of the region's population that lives in each district in 1994,1981, 1973
Population density persons per square kilometers in 1994, 1981 and 1973
Sex ratio 1994, 1981, 1973
Percent of urban and rural population in 1994
Age structure (0 to 14 years, 15 and 64 years, and 65 or older) in 1994,1981, 1973
Number of households in 1994
Household size in 1994
 

Literacy rates in 1994,1981,1973
Percent of persons without formal education in 1994 by district
Educational levels (preschool, elementary school, middle or high school, and college) in 1994
 

Gender makeup of work force in 1994
Total workforce in 1981 and 1973
 

Percent of housing units located in each district in 1994 and 1981
Single family homes (classified as formal housing) in 1994 and 1981
Multi-family housing (apartments) formal construction in 1994 and 1981
Percent of formal housing by district in 1994 and 1984
Formal housing deficit (formal housing less number of households) in 1994
 

Number of inhabitants in each settlement.
Number of families
Location
Housing ownership status
Infrastructure and services, including water, electricity and sewage
Level of risk from natural hazards (proximity to seismic falls, water sheets, and deforestation)