# Presentation: 734331

## 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

## Architecture

**data**

**1999-2000 SD**
**boundaries**

**CCD and other NCES**
**data**

**ArcIMS Spatial**
**Server**

**ArcIMS Application**
**Server **

**ArcIMS Application**
**Server Connectors**

**ArcIMS Management**
**(Admin, Authors,..)**

**JAVA**

**TEXT**

**HTML**

**NCES**
**Server**

**ArcSDE**

**ArcSDE**

**ArcSDE**

## Resources

**	**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

## 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

## Products

- 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

## The School District Mapping System

- 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

**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 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

## 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

## The School District Mapping System - GIS          	

- 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

**The School District Mapping System - GIS          ****	**
**ArcIMS and ArcSDE**

## Summary, Recommendations, and Conclusions

**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
- ??