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

School District Mapping System****

Development and Implementation

Tai A. PhanTai_Phan@ed.gov202-502-7431DCSDLIST@inet.ed.gov

2000 Decennial Censusdata

1999-2000 SDboundaries

CCD and other NCESdata

ArcIMS SpatialServer

ArcIMS ApplicationServer

ArcIMS ApplicationServer Connectors

ArcIMS Management(Admin, Authors,..)

JAVA

TEXT

HTML NCESServer

ArcSDE

ArcSD

E

ArcSD

E

Architecture

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

Resources

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

Features

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

Products

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.

The School District Mapping System

The School District Mapping System - Data Availability

• Timeliness and Currency• Cost Effectiveness/Funding: Efficiency of data file size• Accessibility• Security• Flexibility• Content• Cooperation

The School District Mapping System - GIS

ArcIMS and ArcSDEContent Process/implementation

RDBMS install and configurationDatabase design

1-geodatabase2-storage3-feature of system

Admin tasksserver- power, memory, resource requirements

Performance Tuning1-bandwidth requirements2-internets and intranets

Backup and Recovery

CooperationInter-governmentPrivate Companies

ArcIMS*Multi-tier system :

Browser to present maps and dataApplications / LogicData Source

• Browser - Java, HTML, and Text viewers

•Applications / LogicWeb Server - Windows NT, communicates with Application server by connectors

using Active XArcIMS Application Server - Handles incoming requests

Tracks mapping services from Spatial serverCan talk to multiple servers

ArcIMS Active X Connectors - Using Windows NT solutionSpatial 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

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 ModelID, geometry, address - Spatial indexes for support spatial data queriesVirtually all formats can be imported

* - ESRI Technical Notes

The School District Mapping System - GIS ArcIMS and ArcSDE

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

MISNCES Summer Data Conference??