Site Selection Tool Development with Model Builder October

Site Selection Tool Development with Model. Builder October 16, 2006 Kwangbae Kim CE 697 V, Project 3 1

Descriptions & object of this project ¡ GIS geoprocessing to select suitable locations by tool development with Model. Builder ¡ Relocation his family at the city of West Lafayette of a new Purdue student ¡ The object of this project: to make a tool with Model. Builder to find the best site selection for his family CE 697 V, Project 3 2

Procedure 1. Build a personal geodatabase to save or load all the involved data 2. Create geocode house addresses data 3. Perform spatial analysis tools by selection criteria to find best location CE 697 V, Project 3 3

Selection criteria ¡ Select US Highway 52 from all streets including major roads ¡ Buffer US Highway 52 within 1 mile from selected US Highway 52 ¡ Buffer grocery within 3 mile from grocery stores ¡ Buffer 6 driving distance miles to the School of Civil Engineering CE 697 V, Project 3 4

Selection criteria (cont’d) ¡ Select elementary schools from school ¡ Buffer 3 driving distance miles to the selected elementary school of his kid(s) ¡ Buffer 5 driving distance miles to library ¡ Select houses with 3 bedrooms and a price less than $150, 000 from geocoding house addresses CE 697 V, Project 3 5

Site selection with Model. Builder ¡ US Highway 52 (US 52_select_shp) was selected by choosing from attributes: (“NAME” = 'US HIGHWAY 52') OR (“NAME” = 'US HWY 52') OR (“NAME” = 'SAGAMORE' ) ¡ Buffering (US 52_select_buffer_shp) within 1 mile to selected US Highway 52 was performed ¡ Buffering (Grocery 3_buffer_shp) within 3 mile from grocery store shape file. CE 697 V, Project 3 6

Site selection with Model. Builder (cont’d) ¡ Buffering (Driving_dist_CEBuilding_buffer_shp) 6 driving distance miles to the School of Civil Engineering shapefile (geocoding_result_5. shp). ¡ Elementary school (Elementary_school_select_shp) was selected by choosing from attributes: ("NAME" = 'Burtsfield Elementary School' ) OR( "NAME" = 'Cumberland Elementary School' ) OR( "NAME" = 'Happy Hollow Elementary School' ) OR( "NAME" = 'Klondike Elementary' ) of schoolmap shape file (schoolmap. shp) ¡ Buffering (Elementary_school_buffer_shp) 3 driving distance miles to the selected elementary school of his kid(s) in project 3_personal_geodatabase. CE 697 V, Project 3 7

Site selection with Model. Builder (cont’d) ¡ Buffering (Library_Buffer_shp) 5 driving distance miles to librarymap shape file (librarymap. shp). ¡ Clipping (out 1_shp) US 52_select_buffer_shp and Grocery 3_buffer_shp. ¡ Intersecting (out 2_shp) Driving_dist_CEBuilding_buffer_shp, Elementary_school_buffer_shp, and Library_Buffer_shp. ¡ Clipping (out 3_shp) out 1_shp and out 2_shp. CE 697 V, Project 3 8

Site selection with Model. Builder (cont’d) ¡ Houses (three_bedrooms_less_than_150000_select_shp) with 2 bedrooms and a price less than $150, 000 from geocoding result shape file (geocoding_result_6. shp) were selected by SQL expression: ("BED" = 3) AND ("PRICE" <=150000). ¡ Intersecting (final_output_shp) out 3_shp and three_bedrooms_less_than_150000_select_shp. CE 697 V, Project 3 9

Final Results (Model) CE 697 V, Project 3 10

Final Results (Map) CE 697 V, Project 3 11