Sunday, September 9, 2012

Numbers- Statistical Information, Collecting, Preparing

Welcome to the beginning of the last Semester.   Our Special Topics class will have three parts to each lesson.   The first Topic is Statistical information.  Meth Labs.  Where, why, when?   Is there information out there to guide us.      Our 3 week study will be on Charleston, WV.  Preparing our base map which follows and collecting the information from the US Census 2010/2000.  We are adding categories to the Census data for calculation based on a proven social ecological model for regression analysis used by the CDC.    We'll see how this turns out later. 

Nothing fancy this week, just a base to get started.  Hope to add more to it next week.
Processes & thoughts follow:



1-Moved data from r to s.  Set up basic map properties and set geodata base to: Project1Data.gdb.
2-Saved map as Stat_Base.
3-Recorded list of fields in Census layer for creation of new fields using Idle (python script). Added new lines to python script created by UWF online staff as needed to create new fields with percentage values for statistical model.  New fields are: Roommates, pcntPopGro,  pcntWhite,  pcntRmmate,  pcnt_1M,  pcnt_1F,  pcnt_MFCLD, pcnt_MF,  pcnt_FCHLD,  pcnt_MCHLD, M_F_Ratio, pcntVacant, pcntRental, pcntUnder5,  pcnt5_17,  pcnt18_21,  pcnt22_29, pcnt30_39,  pcnt40_49, pcnt50_64,  pcnt65_UP,  pcntUnEdu. (yea it worked).
4- Performed spatial join with census and meth lab layers, output: Centrt_MethLab_Spatialjoin. Added new field for LabDensity (join/sqmi).
5- Added new dataframe with West Virginia as single layer from Week4 cartography, America's Administration map as inset (GCS wgs1984 to current projection on census tracts).

End for now.  Part 2 will be the Analysis section. 


No comments:

Post a Comment