The 2000 Decennial Census School District Project: Using Census Data for the

1. The 2000 Decennial Census School District Project: Using Census Data for the School District Mapping System **** Development and Implementation Tai A. Phan Tai_Phan@ed.gov 202-502-7431 DCSDLIST@inet.ed.gov

2. Architecture ArcIMS Application Server Connectors ArcIMS Application Server JAVA NCES Server ArcIMS Spatial Server HTML ArcSDE 2000 Decennial Census data ArcSDE 1999-2000 SD boundaries TEXT CCD and other NCES data ArcSDE ArcIMS Management (Admin, Authors,..)

3. Resources • Teams: • NCES Staff • Synectics for Management Decisions Inc. • Unisys Corp. • ESRI • Experts • Data: • PL94-171 redistricting data from 2000 decennial census • 1999-2000 school district boundary files from TIGER/line files • 2000 decennial census long form sample data (384,000 households) • 1999-2000 Common Core of Data

4. Features • Geographic Information System • Computers are cheaper and faster • GIS software is easier to use and geographical data are available • Analyze data visually so they can be easily understood • Presentation tool • Query data on the fly • Data display and analysis capabilities • Create maps and download data using your Web browser • Easy access to data with your standard Web browser • Integrate local and Internet data • Highly scalable server architecture

5. Products • Using the Internet • Resources • Expand number of data users • Cooperation between agencies in the government and between private sector and government • Timeliness • Flexibility • Access to a wealth of geographic and census data • Using ArcIMS and ArcSDE • Requires some minor customization • Integrated application capabilities • Leading technology • Can be upgraded and maintained one year from now, and 10 years into the future • Can be applied to local data integration • Centralized database • Support for Windows and Unix • Industry Standards • Uses TCP/IP protocol

6. The School District Mapping System • Text viewer: • Profiles of school district - comparison between 2 school districts • Download data file - by state, county, or by school district • Standard viewer: • Easy to use • Map and profile of school district/county/state • Thematic mapping of pre-selected tables/items • Download school district boundary files by state/county/school district • Standard GIS functions: pan, zoom, identify, select, query • Java viewers: • Thematic mapping • Map and profile of school district/county/state • Standard GIS functions • Extended GIS functions: map note, local data, WWW data, selected by • circle, line, multiple points • Note: Requires downloading of Java and ArcIms Viewers (10MB). Primarily for GIS users.

7. The School District Mapping System - Data Availability • Timeliness and Currency • Cost Effectiveness/Funding: Efficiency of data file size • Accessibility • Security • Flexibility • Content • Cooperation

8. The School District Mapping System - GIS ArcIMS and ArcSDE Content Process/implementation RDBMS install and configuration Database design 1-geodatabase 2-storage 3-feature of system Admin tasks server- power, memory, resource requirements Performance Tuning 1-bandwidth requirements 2-internets and intranets Backup and Recovery Cooperation Inter-government Private Companies

9. ArcIMS* • Multi-tier system : • Browser to present maps and data • Applications / Logic • Data Source • Browser - Java, HTML, and Text viewers • Applications / Logic • Web Server - Windows NT, communicates with Application server by connectors • using Active X • ArcIMS Application Server - Handles incoming requests • Tracks mapping services from Spatial server • Can talk to multiple servers • ArcIMS Active X Connectors - Using Windows NT solution • Spatial Server - Holds Created Images, renders maps on server • Query - handling data queries • Support Geocode • Extract - send files (shape and data) to data users • Data Access Manager • Support ArcSDE layers, shapefiles, ArcSDE coverages • Map services - Image - requested maps are generated as JPG, or GIF • Feature - requested data is in bundled and streamed and cached • on the client allow additional client side capabilities • Data Storage - shape files, ArcSDE, images

10. The School District Mapping System - GIS ArcIMS and ArcSDE • ArcSDE* • A channel for storing, managing spatial data in relational database management system • RDBMS - leverage scalable structure • Integrated Data - cartographic and tabular can be stored together and retrieved • Geodatabase Technology • Multi-user access • Support spatial and non-spatial queries • Perform GIS operation on data • ArcSDE server is an application server for GIS clients - direct access to RDBMS • Minimizes network traffic with server data filtering • Back up and security • TCP/IP access • ArcSDE Data Model • ID, geometry, address - • Spatial indexes for support spatial data queries • Virtually all formats can be imported • * - ESRI Technical Notes

11. Summary, Recommendations, and Conclusions • Implementation phases based on the available budget and resources • No one vendor offers all of the services required • Ensure to give continuous input into designing specifications before the work begins • and throughout the project • Don’t micro-manage and avoid big change orders • Ask for input from others (consultants, experts) but don’t expect a free lunch • Make sure that data would be compatible with the GIS software • Make sure NCES existing hardware system is compatible and can be upgraded as needs evolve • System is scalable and easily updateable to meet NCES data users need • KEEP IT SIMPLE Training and Workshops MIS NCES Summer Data Conference ??