20210602 18134800 1.0 TRUE FeatureClassToFeatureClass programs_06022021 "C:\Users\cdeal\OneDrive - American Institutes for Research in the Behavioral Sciences\Documents\ArcGIS\Projects\Walmart\Walmart.gdb" programs_06022021_updated # "walmart_data_05242021_geocoded_ "Walmart_Data_05242021_Geocoded_ObjectID" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.walmart_data_05242021_geocoded_,0,8000;loc_name "Loc_name" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.loc_name,0,8000;status "Status" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.status,0,8000;score "Score" true true false 8 Double 0 0,First,#,programs_06022021,programs_06022021.score,-1,-1;match_type "Match_type" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.match_type,0,8000;match_addr "Match_addr" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.match_addr,0,8000;longlabel "LongLabel" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.longlabel,0,8000;shortlabel "ShortLabel" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.shortlabel,0,8000;addr_type "Addr_type" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.addr_type,0,8000;type "Type" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.type,0,8000;placename "PlaceName" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.placename,0,8000;place_addr "Place_addr" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.place_addr,0,8000;phone "Phone" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.phone,0,8000;url "URL" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.url,0,8000;rank "Rank" true true false 8 Double 0 0,First,#,programs_06022021,programs_06022021.rank,-1,-1;addbldg "BuildingName" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.addbldg,0,8000;addnum "AddressNumber" true true false 4 Long 0 0,First,#,programs_06022021,programs_06022021.addnum,-1,-1;addnumfrom "AddNumFrom" true true false 4 Long 0 0,First,#,programs_06022021,programs_06022021.addnumfrom,-1,-1;addnumto "AddNumTo" true true false 4 Long 0 0,First,#,programs_06022021,programs_06022021.addnumto,-1,-1;addrange "AddressRange" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.addrange,0,8000;side "Side" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.side,0,8000;stpredir "StPreDir" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.stpredir,0,8000;stpretype "StPreType" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.stpretype,0,8000;stname "StName" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.stname,0,8000;sttype "StType" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.sttype,0,8000;stdir "StDir" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.stdir,0,8000;bldgtype "BldgType" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.bldgtype,0,8000;bldgname "BldgName" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.bldgname,0,8000;leveltype "LevelType" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.leveltype,0,8000;levelname "LevelName" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.levelname,0,8000;unittype "UnitType" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.unittype,0,8000;unitname "UnitName" true true false 4 Long 0 0,First,#,programs_06022021,programs_06022021.unitname,-1,-1;subaddr "SubAddress" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.subaddr,0,8000;staddr "StAddr" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.staddr,0,8000;block "Block" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.block,0,8000;sector "Sector" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.sector,0,8000;nbrhd "Neighborhood" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.nbrhd,0,8000;district "District" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.district,0,8000;city "City" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.city,0,8000;metroarea "MetroArea" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.metroarea,0,8000;subregion "Subregion" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.subregion,0,8000;region "Region" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.region,0,8000;regionabbr "RegionAbbr" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.regionabbr,0,8000;territory "Territory" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.territory,0,8000;zone "Zone" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.zone,0,8000;postal "Postal" true true false 4 Long 0 0,First,#,programs_06022021,programs_06022021.postal,-1,-1;postalext "PostalExt" true true false 4 Long 0 0,First,#,programs_06022021,programs_06022021.postalext,-1,-1;country "Country" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.country,0,8000;langcode "LangCode" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.langcode,0,8000;distance "Distance" true true false 4 Long 0 0,First,#,programs_06022021,programs_06022021.distance,-1,-1;x "X" true true false 8 Double 0 0,First,#,programs_06022021,programs_06022021.x,-1,-1;y "Y" true true false 8 Double 0 0,First,#,programs_06022021,programs_06022021.y,-1,-1;displayx "DisplayX" true true false 8 Double 0 0,First,#,programs_06022021,programs_06022021.displayx,-1,-1;displayy "DisplayY" true true false 8 Double 0 0,First,#,programs_06022021,programs_06022021.displayy,-1,-1;xmin_ "Xmin" true true false 8 Double 0 0,First,#,programs_06022021,programs_06022021.xmin_,-1,-1;xmax_ "Xmax" true true false 8 Double 0 0,First,#,programs_06022021,programs_06022021.xmax_,-1,-1;ymin "Ymin" true true false 8 Double 0 0,First,#,programs_06022021,programs_06022021.ymin,-1,-1;ymax "Ymax" true true false 8 Double 0 0,First,#,programs_06022021,programs_06022021.ymax,-1,-1;exinfo "ExtraInfo" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.exinfo,0,8000;resultid "ResultID" true true false 4 Long 0 0,First,#,programs_06022021,programs_06022021.resultid,-1,-1;in_singleline "Single Line Input" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.in_singleline,0,8000;user__3_program_number "_3_Program_number" true true false 4 Long 0 0,First,#,programs_06022021,programs_06022021.user__3_program_number,-1,-1;user_program_name "Program name" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.user_program_name,0,8000;user_program_website "Program website" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.user_program_website,0,8000;user_prior_postsecondary_experi "Prior postsecondary experience allowed" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.user_prior_postsecondary_experi,0,8000;user_part_time_attendance_allow "Part-time attendance allowed" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.user_part_time_attendance_allow,0,8000;user_residency_requirements "Residency requirements" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.user_residency_requirements,0,8000;user__42_institutional_sector_s "_42_Institutional_sector_s_eli" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.user__42_institutional_sector_s,0,8000;user__42_updated "_42_Updated" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.user__42_updated,0,8000;user__41_name_s_of_institution_ "USER__41_Name_s_of_institution_s_e" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.user__41_name_s_of_institution_,0,8000;user_notes_of_how_we_might_clea "Notes of how we might clean it up" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.user_notes_of_how_we_might_clea,0,8000;user__8_program_administrative_ "_8_Program_administrative_addre" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.user__8_program_administrative_,0,8000;user__9_city_of_program_adminis "_9_City_of_program_administrati" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.user__9_city_of_program_adminis,0,8000;user__10_state_of_program_admin "_10_State_of_program_administra" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.user__10_state_of_program_admin,0,8000;symbology "symbology" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.symbology,0,8000;institutions_use "institutions_use" true true false 8000 Text 0 0,First,#,programs_06022021,programs_06022021.institutions_use,0,8000;toggle "toggle" true true false 256 Text 0 0,First,#,programs_06022021,programs_06022021.toggle,0,256;pt_filter "PT_filter" true true false 256 Text 0 0,First,#,programs_06022021,programs_06022021.pt_filter,0,256;OBJECTID "OBJECTID" false true false 4 Long 0 9,First,#,programs_06022021,institutions_alpha_update_06022021.OBJECTID,-1,-1;_3_Program_number "_3_Program_number" true true false 4 Long 0 0,First,#,programs_06022021,institutions_alpha_update_06022021._3_Program_number,-1,-1;final_41_alphabitzed_list_of_institutions "final_41_alphabitzed_list_of institutions" true true false 8000 Text 0 0,First,#,programs_06022021,institutions_alpha_update_06022021.final_41_alphabitzed_list_of_institutions,0,8000" # UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.4.0'><WorkspaceConnectionString>DATABASE=C:\Users\cdeal\OneDrive - American Institutes for Research in the Behavioral Sciences\Documents\ArcGIS\Projects\Walmart\Walmart.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>programs_06022021_updated</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>institutions_use</field_name><field_name>OBJECTID</field_name><field_name>_3_Program_number</field_name></DeleteField></workflow><workflow><AlterField><field_name>institutions_use</field_name><new_field_name>institutions_use</new_field_name><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow></operationSequence> UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.4.0'><WorkspaceConnectionString>DATABASE=C:\Users\cdeal\OneDrive - American Institutes for Research in the Behavioral Sciences\Documents\ArcGIS\Projects\Walmart\Walmart.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>programs_06022021_updated</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>institutions_use</field_name><field_type>TEXT</field_type><field_length>8000</field_length><field_alias>institutions_use</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField programs_06022021_updated institutions_use !final_41_alphabitzed_list_of_institutions! "Python 3" # DeleteField programs_06022021_updated final_41_alphabitzed_list_of_institutions Walmart Walmart programs, updated 05242021 Walmart_Data_05242021_Geocoded