20230811 13241000 1.0 FALSE CreateFeatureclass C:\Users\jjw0023.CAMPUSAD\AppData\Local\Temp\ArcGISProTemp19980\Untitled\Default.gdb GeocodeResults_Rounds_1_through_4_PARTIAL_XYTableToPoint Point GPLYR_{C207066C-7F99-470E-B1A0-D092916CF304} No No "GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]];-400 -400 1000000000;-100000 10000;-100000 10000;8.98315284119521E-09;0.001;0.001;IsHighPrecision" # 0 0 0 # XYTableToPoint GeocodeResults_Rounds_1_through_4_PARTIAL.csv C:\Users\jjw0023.CAMPUSAD\AppData\Local\Temp\ArcGISProTemp19980\Untitled\Default.gdb\GeocodeResults_Rounds_1_through_4_PARTIAL_XYTableToPoint Long Lat # "GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]];-400 -400 1000000000;-100000 10000;-100000 10000;8.98315284119521E-09;0.001;0.001;IsHighPrecision" ExportFeatures GeocodeResults_Rounds_1_through_4_PARTIAL_XYTableToPoint "E:\Provost Project\2023\6_Geocoded_Data\Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN.shp" # NOT_USE_ALIAS "ID "ID" true true false 8000 Text 0 0,First,#,GeocodeResults_Rounds_1_through_4_PARTIAL_XYTableToPoint,ID,0,8000;Address "Address" true true false 8000 Text 0 0,First,#,GeocodeResults_Rounds_1_through_4_PARTIAL_XYTableToPoint,Address,0,8000;Level "Level" true true false 8000 Text 0 0,First,#,GeocodeResults_Rounds_1_through_4_PARTIAL_XYTableToPoint,Level,0,8000;Level_2 "Level_2" true true false 8000 Text 0 0,First,#,GeocodeResults_Rounds_1_through_4_PARTIAL_XYTableToPoint,Level_2,0,8000;Address2 "Address2" true true false 8000 Text 0 0,First,#,GeocodeResults_Rounds_1_through_4_PARTIAL_XYTableToPoint,Address2,0,8000;Lat "Lat" true true false 8 Double 0 0,First,#,GeocodeResults_Rounds_1_through_4_PARTIAL_XYTableToPoint,Lat,-1,-1;Long "Long" true true false 8 Double 0 0,First,#,GeocodeResults_Rounds_1_through_4_PARTIAL_XYTableToPoint,Long,-1,-1" # ExportFeatures Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN "E:\Provost Project\2023\6_Geocoded_Data\Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN.shp" # NOT_USE_ALIAS "ID "ID" true true false 254 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN.ID,0,254;Address "Address" true true false 254 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN.Address,0,254;Level "Level" true true false 254 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN.Level,0,254;Level_2 "Level_2" true true false 254 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN.Level_2,0,254;Address2 "Address2" true true false 254 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN.Address2,0,254;Lat "Lat" true true false 19 Double 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN.Lat,-1,-1;Long "Long" true true false 19 Double 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN.Long,-1,-1;ID "ID" true true false 255 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN,Sheet1$.ID,0,255;Round_Submitted_to_RS_GIS "Round Submitted to RS&GIS" true true false 8 Double 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN,Sheet1$.Round_Submitted_to_RS_GIS,-1,-1;Reviewed "Reviewed" true true false 8 Double 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN,Sheet1$.Reviewed,-1,-1;Include "Include" true true false 8 Double 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN,Sheet1$.Include,-1,-1;Year "Year" true true false 8 Double 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN,Sheet1$.Year,-1,-1;College_MAU "College/MAU" true true false 255 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN,Sheet1$.College_MAU,0,255;Department_Subunit "Department/Subunit" true true false 255 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN,Sheet1$.Department_Subunit,0,255;Last_Name "Last Name" true true false 255 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN,Sheet1$.Last_Name,0,255;First_Name "First Name" true true false 255 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN,Sheet1$.First_Name,0,255;Email "Email" true true false 255 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN,Sheet1$.Email,0,255;Title "Title" true true false 255 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN,Sheet1$.Title,0,255;Project_Name "Project Name" true true false 255 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN,Sheet1$.Project_Name,0,255;Project_Description "Project Description" true true false 32767 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN,Sheet1$.Project_Description,0,32767;F__empty_fields_in_External_Par "# empty fields in External Partners and locations (4 max)" true true false 8 Double 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN,Sheet1$.F__empty_fields_in_External_Par,-1,-1;External_Partners "External Partners" true true false 255 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN,Sheet1$.External_Partners,0,255;Duration_of_Project__one_time_o "Duration of Project (one-time or ongoing)" true true false 255 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN,Sheet1$.Duration_of_Project__one_time_o,0,255;Michigan_Cities "Michigan Cities" true true false 255 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN,Sheet1$.Michigan_Cities,0,255;Michigan_Counties "Michigan Counties" true true false 255 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN,Sheet1$.Michigan_Counties,0,255;Countries "Countries" true true false 255 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN,Sheet1$.Countries,0,255;Areas_of_Interest "Areas of Interest" true true false 255 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN,Sheet1$.Areas_of_Interest,0,255;Additional_Funding "Additional Funding" true true false 255 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN,Sheet1$.Additional_Funding,0,255;Funding_Source_s_ "Funding Source(s)" true true false 255 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN,Sheet1$.Funding_Source_s_,0,255;Additional_Comments "Additional Comments" true true false 255 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN,Sheet1$.Additional_Comments,0,255;RSGIS_ID "RSGIS_ID" true true false 255 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN,Sheet1$.RSGIS_ID,0,255;Name "Name" true true false 255 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN,Sheet1$.Name,0,255;Address "Address" true true false 255 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN,Sheet1$.Address,0,255;City "City" true true false 255 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN,Sheet1$.City,0,255;State "State" true true false 255 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN,Sheet1$.State,0,255;Zip "Zip" true true false 255 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN,Sheet1$.Zip,0,255;Non_US "Non_US" true true false 255 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN,Sheet1$.Non_US,0,255;GenLocationInfo "GenLocationInfo" true true false 255 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN,Sheet1$.GenLocationInfo,0,255;Note "Note" true true false 255 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN,Sheet1$.Note,0,255;F33 "F33" true true false 255 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN,Sheet1$.F33,0,255;ObjectID "ObjectID" false true false 4 Long 0 9,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_NO_JOIN,Sheet1$.ObjectID,-1,-1" # ExportFeatures Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN E:\Spartan_Public_Engagement_Map\0_Data_Formatting\SpartanPublicEngagmentFORMATTING.gdb\All_Pre_2023_PROJECT_Points # NOT_USE_ALIAS "ID "ID" true true false 254 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN,ID,0,254;Address "Address" true true false 254 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN,Address,0,254;Level "Level" true true false 254 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN,Level,0,254;Level_2 "Level_2" true true false 254 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN,Level_2,0,254;Address2 "Address2" true true false 254 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN,Address2,0,254;Lat "Lat" true true false 19 Double 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN,Lat,-1,-1;Long "Long" true true false 19 Double 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN,Long,-1,-1;ID_1 "ID_1" true true false 254 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN,ID_1,0,254;Round_Subm "Round_Subm" true true false 19 Double 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN,Round_Subm,-1,-1;Reviewed "Reviewed" true true false 19 Double 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN,Reviewed,-1,-1;Include "Include" true true false 19 Double 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN,Include,-1,-1;Year "Year" true true false 19 Double 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN,Year,-1,-1;College_MA "College_MA" true true false 254 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN,College_MA,0,254;Department "Department" true true false 254 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN,Department,0,254;Last_Name "Last_Name" true true false 254 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN,Last_Name,0,254;First_Name "First_Name" true true false 254 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN,First_Name,0,254;Email "Email" true true false 254 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN,Email,0,254;Title "Title" true true false 254 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN,Title,0,254;Project_Na "Project_Na" true true false 254 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN,Project_Na,0,254;Project_De "Project_De" true true false 254 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN,Project_De,0,254;F__empty_f "F__empty_f" true true false 19 Double 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN,F__empty_f,-1,-1;External_P "External_P" true true false 254 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN,External_P,0,254;Duration_o "Duration_o" true true false 254 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN,Duration_o,0,254;Michigan_C "Michigan_C" true true false 254 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN,Michigan_C,0,254;Michigan_1 "Michigan_1" true true false 254 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN,Michigan_1,0,254;Countries "Countries" true true false 254 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN,Countries,0,254;Areas_of_I "Areas_of_I" true true false 254 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN,Areas_of_I,0,254;Additional "Additional" true true false 254 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN,Additional,0,254;Funding_So "Funding_So" true true false 254 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN,Funding_So,0,254;Addition_1 "Addition_1" true true false 254 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN,Addition_1,0,254;RSGIS_ID "RSGIS_ID" true true false 254 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN,RSGIS_ID,0,254;Name "Name" true true false 254 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN,Name,0,254;Address_1 "Address_1" true true false 254 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN,Address_1,0,254;City "City" true true false 254 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN,City,0,254;State "State" true true false 254 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN,State,0,254;Zip "Zip" true true false 254 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN,Zip,0,254;Non_US "Non_US" true true false 254 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN,Non_US,0,254;GenLocatio "GenLocatio" true true false 254 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN,GenLocatio,0,254;Note "Note" true true false 254 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN,Note,0,254;F33 "F33" true true false 254 Text 0 0,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN,F33,0,254;ObjectID "ObjectID" true true false 9 Long 0 9,First,#,Geocoded_Results_Rounds_1_through_4_Partial_File_1_WITH_JOIN,ObjectID,-1,-1" # ExportFeatures All_Pre_2023_PROJECT_Points E:\Spartan_Public_Engagement_Map\0_Data_Formatting\SpartanPublicEngagmentFORMATTING.gdb\All_Pre_2023_PROJECT_Points_NO_DATA # NOT_USE_ALIAS "ID "ID" true true false 254 Text 0 0,First,#,All_Pre_2023_PROJECT_Points,ID,0,254;Address "Address" true true false 254 Text 0 0,First,#,All_Pre_2023_PROJECT_Points,Address,0,254;Level "Level" true true false 254 Text 0 0,First,#,All_Pre_2023_PROJECT_Points,Level,0,254;Level_2 "Level_2" true true false 254 Text 0 0,First,#,All_Pre_2023_PROJECT_Points,Level_2,0,254;Address2 "Address2" true true false 254 Text 0 0,First,#,All_Pre_2023_PROJECT_Points,Address2,0,254;Lat "Lat" true true false 8 Double 0 0,First,#,All_Pre_2023_PROJECT_Points,Lat,-1,-1;Long "Long" true true false 8 Double 0 0,First,#,All_Pre_2023_PROJECT_Points,Long,-1,-1;ID_1 "ID_1" true true false 254 Text 0 0,First,#,All_Pre_2023_PROJECT_Points,ID_1,0,254;Round_Subm "Round_Subm" true true false 8 Double 0 0,First,#,All_Pre_2023_PROJECT_Points,Round_Subm,-1,-1;Reviewed "Reviewed" true true false 8 Double 0 0,First,#,All_Pre_2023_PROJECT_Points,Reviewed,-1,-1;Include "Include" true true false 8 Double 0 0,First,#,All_Pre_2023_PROJECT_Points,Include,-1,-1;Year "Year" true true false 8 Double 0 0,First,#,All_Pre_2023_PROJECT_Points,Year,-1,-1;College_MA "College_MA" true true false 254 Text 0 0,First,#,All_Pre_2023_PROJECT_Points,College_MA,0,254;Department "Department" true true false 254 Text 0 0,First,#,All_Pre_2023_PROJECT_Points,Department,0,254;Last_Name "Last_Name" true true false 254 Text 0 0,First,#,All_Pre_2023_PROJECT_Points,Last_Name,0,254;First_Name "First_Name" true true false 254 Text 0 0,First,#,All_Pre_2023_PROJECT_Points,First_Name,0,254;Email "Email" true true false 254 Text 0 0,First,#,All_Pre_2023_PROJECT_Points,Email,0,254;Title "Title" true true false 254 Text 0 0,First,#,All_Pre_2023_PROJECT_Points,Title,0,254;Project_Na "Project_Na" true true false 254 Text 0 0,First,#,All_Pre_2023_PROJECT_Points,Project_Na,0,254;Project_De "Project_De" true true false 254 Text 0 0,First,#,All_Pre_2023_PROJECT_Points,Project_De,0,254;F__empty_f "F__empty_f" true true false 8 Double 0 0,First,#,All_Pre_2023_PROJECT_Points,F__empty_f,-1,-1;External_P "External_P" true true false 254 Text 0 0,First,#,All_Pre_2023_PROJECT_Points,External_P,0,254;Duration_o "Duration_o" true true false 254 Text 0 0,First,#,All_Pre_2023_PROJECT_Points,Duration_o,0,254;Michigan_C "Michigan_C" true true false 254 Text 0 0,First,#,All_Pre_2023_PROJECT_Points,Michigan_C,0,254;Michigan_1 "Michigan_1" true true false 254 Text 0 0,First,#,All_Pre_2023_PROJECT_Points,Michigan_1,0,254;Countries "Countries" true true false 254 Text 0 0,First,#,All_Pre_2023_PROJECT_Points,Countries,0,254;Areas_of_I "Areas_of_I" true true false 254 Text 0 0,First,#,All_Pre_2023_PROJECT_Points,Areas_of_I,0,254;Additional "Additional" true true false 254 Text 0 0,First,#,All_Pre_2023_PROJECT_Points,Additional,0,254;Funding_So "Funding_So" true true false 254 Text 0 0,First,#,All_Pre_2023_PROJECT_Points,Funding_So,0,254;Addition_1 "Addition_1" true true false 254 Text 0 0,First,#,All_Pre_2023_PROJECT_Points,Addition_1,0,254;RSGIS_ID "RSGIS_ID" true true false 254 Text 0 0,First,#,All_Pre_2023_PROJECT_Points,RSGIS_ID,0,254;Name "Name" true true false 254 Text 0 0,First,#,All_Pre_2023_PROJECT_Points,Name,0,254;Address_1 "Address_1" true true false 254 Text 0 0,First,#,All_Pre_2023_PROJECT_Points,Address_1,0,254;City "City" true true false 254 Text 0 0,First,#,All_Pre_2023_PROJECT_Points,City,0,254;State "State" true true false 254 Text 0 0,First,#,All_Pre_2023_PROJECT_Points,State,0,254;Zip "Zip" true true false 254 Text 0 0,First,#,All_Pre_2023_PROJECT_Points,Zip,0,254;Non_US "Non_US" true true false 254 Text 0 0,First,#,All_Pre_2023_PROJECT_Points,Non_US,0,254;GenLocatio "GenLocatio" true true false 254 Text 0 0,First,#,All_Pre_2023_PROJECT_Points,GenLocatio,0,254;Note "Note" true true false 254 Text 0 0,First,#,All_Pre_2023_PROJECT_Points,Note,0,254;F33 "F33" true true false 254 Text 0 0,First,#,All_Pre_2023_PROJECT_Points,F33,0,254;ObjectID "ObjectID" true true false 4 Long 0 0,First,#,All_Pre_2023_PROJECT_Points,ObjectID,-1,-1" # 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/3.1.0'><WorkspaceConnectionString>DATABASE=E:\Spartan_Public_Engagement_Map\0_Data_Formatting\SpartanPublicEngagmentFORMATTING.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>All_Pre_2023_PROJECT_Points_NO_DATA</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>ID</field_name><field_name>Address</field_name><field_name>Level</field_name><field_name>Level_2</field_name><field_name>Address2</field_name><field_name>Lat</field_name><field_name>Long</field_name><field_name>ID_1</field_name><field_name>Round_Subm</field_name><field_name>Reviewed</field_name><field_name>Include</field_name><field_name>Year</field_name><field_name>College_MA</field_name><field_name>Department</field_name><field_name>Last_Name</field_name><field_name>First_Name</field_name><field_name>Email</field_name><field_name>Title</field_name><field_name>Project_Na</field_name><field_name>Project_De</field_name><field_name>F__empty_f</field_name><field_name>External_P</field_name><field_name>Duration_o</field_name><field_name>Michigan_C</field_name><field_name>Michigan_1</field_name><field_name>Countries</field_name><field_name>Areas_of_I</field_name><field_name>Additional</field_name><field_name>Funding_So</field_name><field_name>Addition_1</field_name><field_name>Name</field_name><field_name>Address_1</field_name><field_name>City</field_name><field_name>State</field_name><field_name>Zip</field_name><field_name>Non_US</field_name><field_name>GenLocatio</field_name><field_name>Note</field_name><field_name>F33</field_name><field_name>ObjectID</field_name></DeleteField></workflow></operationSequence> ExportFeatures All_Pre_2023_PROJECT_Points_NO_DATA E:\Spartan_Public_Engagement_Map\0_Data_Formatting\SpartanPublicEngagmentFORMATTING.gdb\All_Pre_2023_PROJECT_Points_WITH_DATA_JOIN # NOT_USE_ALIAS "RSGIS_ID "RSGIS_ID" true true false 254 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_NO_DATA,All_Pre_2023_PROJECT_Points_NO_DATA.RSGIS_ID,0,254;RSGIS_ID "RSGIS_ID" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_NO_DATA,TO_JOIN__Rounds_1_through_4_Combined_Standardized.csv.RSGIS_ID,0,8000;ID "ID" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_NO_DATA,TO_JOIN__Rounds_1_through_4_Combined_Standardized.csv.ID,0,8000;Round Submitted to RS&GIS "Round Submitted to RS&GIS" true true false 4 Long 0 0,First,#,All_Pre_2023_PROJECT_Points_NO_DATA,TO_JOIN__Rounds_1_through_4_Combined_Standardized.csv.Round Submitted to RS&GIS,-1,-1;Reviewed "Reviewed" true true false 4 Long 0 0,First,#,All_Pre_2023_PROJECT_Points_NO_DATA,TO_JOIN__Rounds_1_through_4_Combined_Standardized.csv.Reviewed,-1,-1;Include "Include" true true false 4 Long 0 0,First,#,All_Pre_2023_PROJECT_Points_NO_DATA,TO_JOIN__Rounds_1_through_4_Combined_Standardized.csv.Include,-1,-1;Year "Year" true true false 4 Long 0 0,First,#,All_Pre_2023_PROJECT_Points_NO_DATA,TO_JOIN__Rounds_1_through_4_Combined_Standardized.csv.Year,-1,-1;College/MAU "College/MAU" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_NO_DATA,TO_JOIN__Rounds_1_through_4_Combined_Standardized.csv.College/MAU,0,8000;Department/Subunit "Department/Subunit" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_NO_DATA,TO_JOIN__Rounds_1_through_4_Combined_Standardized.csv.Department/Subunit,0,8000;Last Name "Last Name" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_NO_DATA,TO_JOIN__Rounds_1_through_4_Combined_Standardized.csv.Last Name,0,8000;First Name "First Name" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_NO_DATA,TO_JOIN__Rounds_1_through_4_Combined_Standardized.csv.First Name,0,8000;Email "Email" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_NO_DATA,TO_JOIN__Rounds_1_through_4_Combined_Standardized.csv.Email,0,8000;Title "Title" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_NO_DATA,TO_JOIN__Rounds_1_through_4_Combined_Standardized.csv.Title,0,8000;Project Name "Project Name" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_NO_DATA,TO_JOIN__Rounds_1_through_4_Combined_Standardized.csv.Project Name,0,8000;Project Description "Project Description" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_NO_DATA,TO_JOIN__Rounds_1_through_4_Combined_Standardized.csv.Project Description,0,8000;# empty fields in External Partners and locations (4 max) "# empty fields in External Partners and locations (4 max)" true true false 4 Long 0 0,First,#,All_Pre_2023_PROJECT_Points_NO_DATA,TO_JOIN__Rounds_1_through_4_Combined_Standardized.csv.# empty fields in External Partners and locations (4 max),-1,-1;External Partners "External Partners" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_NO_DATA,TO_JOIN__Rounds_1_through_4_Combined_Standardized.csv.External Partners,0,8000;Duration of Project (one-time or ongoing) "Duration of Project (one-time or ongoing)" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_NO_DATA,TO_JOIN__Rounds_1_through_4_Combined_Standardized.csv.Duration of Project (one-time or ongoing),0,8000;Michigan Cities "Michigan Cities" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_NO_DATA,TO_JOIN__Rounds_1_through_4_Combined_Standardized.csv.Michigan Cities,0,8000;Michigan Counties "Michigan Counties" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_NO_DATA,TO_JOIN__Rounds_1_through_4_Combined_Standardized.csv.Michigan Counties,0,8000;Countries "Countries" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_NO_DATA,TO_JOIN__Rounds_1_through_4_Combined_Standardized.csv.Countries,0,8000;Areas of Interest "Areas of Interest" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_NO_DATA,TO_JOIN__Rounds_1_through_4_Combined_Standardized.csv.Areas of Interest,0,8000;Additional Funding "Additional Funding" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_NO_DATA,TO_JOIN__Rounds_1_through_4_Combined_Standardized.csv.Additional Funding,0,8000;Funding Source(s) "Funding Source(s)" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_NO_DATA,TO_JOIN__Rounds_1_through_4_Combined_Standardized.csv.Funding Source(s),0,8000;Additional Comments "Additional Comments" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_NO_DATA,TO_JOIN__Rounds_1_through_4_Combined_Standardized.csv.Additional Comments,0,8000;Name "Name" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_NO_DATA,TO_JOIN__Rounds_1_through_4_Combined_Standardized.csv.Name,0,8000;Address "Address" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_NO_DATA,TO_JOIN__Rounds_1_through_4_Combined_Standardized.csv.Address,0,8000;City "City" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_NO_DATA,TO_JOIN__Rounds_1_through_4_Combined_Standardized.csv.City,0,8000;State "State" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_NO_DATA,TO_JOIN__Rounds_1_through_4_Combined_Standardized.csv.State,0,8000;Zip "Zip" true true false 4 Long 0 0,First,#,All_Pre_2023_PROJECT_Points_NO_DATA,TO_JOIN__Rounds_1_through_4_Combined_Standardized.csv.Zip,-1,-1;Non_US "Non_US" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_NO_DATA,TO_JOIN__Rounds_1_through_4_Combined_Standardized.csv.Non_US,0,8000;GenLocationInfo "GenLocationInfo" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_NO_DATA,TO_JOIN__Rounds_1_through_4_Combined_Standardized.csv.GenLocationInfo,0,8000;Note "Note" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_NO_DATA,TO_JOIN__Rounds_1_through_4_Combined_Standardized.csv.Note,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/3.1.0'><WorkspaceConnectionString>DATABASE=E:\Spartan_Public_Engagement_Map\0_Data_Formatting\SpartanPublicEngagmentFORMATTING.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>All_Pre_2023_PROJECT_Points_WITH_DATA_JOIN</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AlterField><field_name>RSGIS_ID_1</field_name><new_field_name>RSGIS_ID_Copy</new_field_name><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>Round_Submitted_to_RS_GIS</field_name><new_field_name>Round_Submitted</new_field_name><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>F__empty_fields_in_External_Partners_and_locations__4_max_</field_name><new_field_name>Empty_Fields_External_Partner</new_field_name><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>Funding_Source_s_</field_name><new_field_name>Funding_Source</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/3.1.0'><WorkspaceConnectionString>DATABASE=E:\Spartan_Public_Engagement_Map\0_Data_Formatting\SpartanPublicEngagmentFORMATTING.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>All_Pre_2023_PROJECT_Points_WITH_DATA_JOIN</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AlterField><field_name>Duration_of_Project__one_time_or_ongoing_</field_name><new_field_name>Duration</new_field_name><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AddField><field_name>Location_General</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Orig_Address</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> ExportFeatures All_Pre_2023_PROJECT_Points_WITH_DATA_JOIN E:\Spartan_Public_Engagement_Map\0_Data_Formatting\SpartanPublicEngagmentFORMATTING.gdb\Data_Merge_Version_02 # NOT_USE_ALIAS "RSGIS_ID "RSGIS_ID" true true false 254 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_WITH_DATA_JOIN,RSGIS_ID,0,254;RSGIS_ID_Copy "RSGIS_ID" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_WITH_DATA_JOIN,RSGIS_ID_Copy,0,8000;ID "ID" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_WITH_DATA_JOIN,ID,0,8000;Round_Submitted "Round Submitted to RS&GIS" true true false 4 Long 0 0,First,#,All_Pre_2023_PROJECT_Points_WITH_DATA_JOIN,Round_Submitted,-1,-1;Reviewed "Reviewed" true true false 4 Long 0 0,First,#,All_Pre_2023_PROJECT_Points_WITH_DATA_JOIN,Reviewed,-1,-1;Include "Include" true true false 4 Long 0 0,First,#,All_Pre_2023_PROJECT_Points_WITH_DATA_JOIN,Include,-1,-1;Year "Year" true true false 4 Long 0 0,First,#,All_Pre_2023_PROJECT_Points_WITH_DATA_JOIN,Year,-1,-1;College_MAU "College/MAU" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_WITH_DATA_JOIN,College_MAU,0,8000;Department_Subunit "Department/Subunit" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_WITH_DATA_JOIN,Department_Subunit,0,8000;Last_Name "Last Name" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_WITH_DATA_JOIN,Last_Name,0,8000;First_Name "First Name" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_WITH_DATA_JOIN,First_Name,0,8000;Email "Email" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_WITH_DATA_JOIN,Email,0,8000;Title "Title" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_WITH_DATA_JOIN,Title,0,8000;Project_Name "Project Name" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_WITH_DATA_JOIN,Project_Name,0,8000;Project_Description "Project Description" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_WITH_DATA_JOIN,Project_Description,0,8000;Empty_Fields_External_Partner "# empty fields in External Partners and locations (4 max)" true true false 4 Long 0 0,First,#,All_Pre_2023_PROJECT_Points_WITH_DATA_JOIN,Empty_Fields_External_Partner,-1,-1;External_Partners "External Partners" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_WITH_DATA_JOIN,External_Partners,0,8000;Michigan_Cities "Michigan Cities" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_WITH_DATA_JOIN,Michigan_Cities,0,8000;Michigan_Counties "Michigan Counties" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_WITH_DATA_JOIN,Michigan_Counties,0,8000;Countries "Countries" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_WITH_DATA_JOIN,Countries,0,8000;Areas_of_Interest "Areas of Interest" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_WITH_DATA_JOIN,Areas_of_Interest,0,8000;Additional_Funding "Additional Funding" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_WITH_DATA_JOIN,Additional_Funding,0,8000;Funding_Source "Funding Source(s)" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_WITH_DATA_JOIN,Funding_Source,0,8000;Additional_Comments "Additional Comments" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_WITH_DATA_JOIN,Additional_Comments,0,8000;Name "Name" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_WITH_DATA_JOIN,Name,0,8000;Address "Address" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_WITH_DATA_JOIN,Address,0,8000;City "City" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_WITH_DATA_JOIN,City,0,8000;State "State" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_WITH_DATA_JOIN,State,0,8000;Zip "Zip" true true false 4 Long 0 0,First,#,All_Pre_2023_PROJECT_Points_WITH_DATA_JOIN,Zip,-1,-1;Non_US "Non_US" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_WITH_DATA_JOIN,Non_US,0,8000;GenLocationInfo "GenLocationInfo" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_WITH_DATA_JOIN,GenLocationInfo,0,8000;Note "Note" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_WITH_DATA_JOIN,Note,0,8000;Duration "Duration of Project (one-time or ongoing)" true true false 8000 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_WITH_DATA_JOIN,Duration,0,8000;Location_General "Location_General" true true false 255 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_WITH_DATA_JOIN,Location_General,0,255;Orig_Address "Orig_Address" true true false 255 Text 0 0,First,#,All_Pre_2023_PROJECT_Points_WITH_DATA_JOIN,Orig_Address,0,255" # ExportFeatures Data_Merge_Version_02 E:\Spartan_Public_Engagement_Map\0_Data_Formatting\SpartanPublicEngagmentFORMATTING.gdb\Data_Merge_Version_03 # NOT_USE_ALIAS "RSGIS_ID "RSGIS_ID" true true false 254 Text 0 0,First,#,Data_Merge_Version_02,Data_Merge_Version_02.RSGIS_ID,0,254;RSGIS_ID_Copy "RSGIS_ID" true true false 8000 Text 0 0,First,#,Data_Merge_Version_02,Data_Merge_Version_02.RSGIS_ID_Copy,0,8000;ID "ID" true true false 8000 Text 0 0,First,#,Data_Merge_Version_02,Data_Merge_Version_02.ID,0,8000;Round_Submitted "Round Submitted to RS&GIS" true true false 4 Long 0 0,First,#,Data_Merge_Version_02,Data_Merge_Version_02.Round_Submitted,-1,-1;Reviewed "Reviewed" true true false 4 Long 0 0,First,#,Data_Merge_Version_02,Data_Merge_Version_02.Reviewed,-1,-1;Include "Include" true true false 4 Long 0 0,First,#,Data_Merge_Version_02,Data_Merge_Version_02.Include,-1,-1;Year "Year" true true false 4 Long 0 0,First,#,Data_Merge_Version_02,Data_Merge_Version_02.Year,-1,-1;College_MAU "College/MAU" true true false 8000 Text 0 0,First,#,Data_Merge_Version_02,Data_Merge_Version_02.College_MAU,0,8000;Department_Subunit "Department/Subunit" true true false 8000 Text 0 0,First,#,Data_Merge_Version_02,Data_Merge_Version_02.Department_Subunit,0,8000;Last_Name "Last Name" true true false 8000 Text 0 0,First,#,Data_Merge_Version_02,Data_Merge_Version_02.Last_Name,0,8000;First_Name "First Name" true true false 8000 Text 0 0,First,#,Data_Merge_Version_02,Data_Merge_Version_02.First_Name,0,8000;Email "Email" true true false 8000 Text 0 0,First,#,Data_Merge_Version_02,Data_Merge_Version_02.Email,0,8000;Title "Title" true true false 8000 Text 0 0,First,#,Data_Merge_Version_02,Data_Merge_Version_02.Title,0,8000;Project_Name "Project Name" true true false 8000 Text 0 0,First,#,Data_Merge_Version_02,Data_Merge_Version_02.Project_Name,0,8000;Project_Description "Project Description" true true false 8000 Text 0 0,First,#,Data_Merge_Version_02,Data_Merge_Version_02.Project_Description,0,8000;Empty_Fields_External_Partner "# empty fields in External Partners and locations (4 max)" true true false 4 Long 0 0,First,#,Data_Merge_Version_02,Data_Merge_Version_02.Empty_Fields_External_Partner,-1,-1;External_Partners "External Partners" true true false 8000 Text 0 0,First,#,Data_Merge_Version_02,Data_Merge_Version_02.External_Partners,0,8000;Michigan_Cities "Michigan Cities" true true false 8000 Text 0 0,First,#,Data_Merge_Version_02,Data_Merge_Version_02.Michigan_Cities,0,8000;Michigan_Counties "Michigan Counties" true true false 8000 Text 0 0,First,#,Data_Merge_Version_02,Data_Merge_Version_02.Michigan_Counties,0,8000;Countries "Countries" true true false 8000 Text 0 0,First,#,Data_Merge_Version_02,Data_Merge_Version_02.Countries,0,8000;Areas_of_Interest "Areas of Interest" true true false 8000 Text 0 0,First,#,Data_Merge_Version_02,Data_Merge_Version_02.Areas_of_Interest,0,8000;Additional_Funding "Additional Funding" true true false 8000 Text 0 0,First,#,Data_Merge_Version_02,Data_Merge_Version_02.Additional_Funding,0,8000;Funding_Source "Funding Source(s)" true true false 8000 Text 0 0,First,#,Data_Merge_Version_02,Data_Merge_Version_02.Funding_Source,0,8000;Additional_Comments "Additional Comments" true true false 8000 Text 0 0,First,#,Data_Merge_Version_02,Data_Merge_Version_02.Additional_Comments,0,8000;Name "Name" true true false 8000 Text 0 0,First,#,Data_Merge_Version_02,Data_Merge_Version_02.Name,0,8000;Address "Address" true true false 8000 Text 0 0,First,#,Data_Merge_Version_02,Data_Merge_Version_02.Address,0,8000;City "City" true true false 8000 Text 0 0,First,#,Data_Merge_Version_02,Data_Merge_Version_02.City,0,8000;State "State" true true false 8000 Text 0 0,First,#,Data_Merge_Version_02,Data_Merge_Version_02.State,0,8000;Zip "Zip" true true false 4 Long 0 0,First,#,Data_Merge_Version_02,Data_Merge_Version_02.Zip,-1,-1;Non_US "Non_US" true true false 8000 Text 0 0,First,#,Data_Merge_Version_02,Data_Merge_Version_02.Non_US,0,8000;GenLocationInfo "GenLocationInfo" true true false 8000 Text 0 0,First,#,Data_Merge_Version_02,Data_Merge_Version_02.GenLocationInfo,0,8000;Note "Note" true true false 8000 Text 0 0,First,#,Data_Merge_Version_02,Data_Merge_Version_02.Note,0,8000;Duration "Duration of Project (one-time or ongoing)" true true false 8000 Text 0 0,First,#,Data_Merge_Version_02,Data_Merge_Version_02.Duration,0,8000;Location_General "Location_General" true true false 255 Text 0 0,First,#,Data_Merge_Version_02,Data_Merge_Version_02.Location_General,0,255;Orig_Address "Orig_Address" true true false 255 Text 0 0,First,#,Data_Merge_Version_02,Data_Merge_Version_02.Orig_Address,0,255;OBJECTID "OBJECTID" false true false 4 Long 0 9,First,#,Data_Merge_Version_02,Detroit_PROJECT_Points_with_Duplicates.OBJECTID,-1,-1;RSGIS_ID "RSGIS_Uniq" true true false 254 Text 0 0,First,#,Data_Merge_Version_02,Detroit_PROJECT_Points_with_Duplicates.RSGIS_ID,0,254;ID "ID" true true false 8 Double 0 0,First,#,Data_Merge_Version_02,Detroit_PROJECT_Points_with_Duplicates.ID,-1,-1;Year "Year_" true true false 254 Text 0 0,First,#,Data_Merge_Version_02,Detroit_PROJECT_Points_with_Duplicates.Year,0,254;College_MAU "College_MA" true true false 254 Text 0 0,First,#,Data_Merge_Version_02,Detroit_PROJECT_Points_with_Duplicates.College_MAU,0,254;Department_Subunit "Department" true true false 254 Text 0 0,First,#,Data_Merge_Version_02,Detroit_PROJECT_Points_with_Duplicates.Department_Subunit,0,254;Last_Name "Last_Name" true true false 254 Text 0 0,First,#,Data_Merge_Version_02,Detroit_PROJECT_Points_with_Duplicates.Last_Name,0,254;First_Name "First_Name" true true false 254 Text 0 0,First,#,Data_Merge_Version_02,Detroit_PROJECT_Points_with_Duplicates.First_Name,0,254;Email "Email" true true false 254 Text 0 0,First,#,Data_Merge_Version_02,Detroit_PROJECT_Points_with_Duplicates.Email,0,254;Title "Title" true true false 254 Text 0 0,First,#,Data_Merge_Version_02,Detroit_PROJECT_Points_with_Duplicates.Title,0,254;Project_Name "Project_Na" true true false 254 Text 0 0,First,#,Data_Merge_Version_02,Detroit_PROJECT_Points_with_Duplicates.Project_Name,0,254;Duration "Years" true true false 254 Text 0 0,First,#,Data_Merge_Version_02,Detroit_PROJECT_Points_with_Duplicates.Duration,0,254;Location_General "Location_C" true true false 254 Text 0 0,First,#,Data_Merge_Version_02,Detroit_PROJECT_Points_with_Duplicates.Location_General,0,254;Orig_Address "Add_Orig" true true false 254 Text 0 0,First,#,Data_Merge_Version_02,Detroit_PROJECT_Points_with_Duplicates.Orig_Address,0,254;Name "Place" true true false 254 Text 0 0,First,#,Data_Merge_Version_02,Detroit_PROJECT_Points_with_Duplicates.Name,0,254;Address "Address" true true false 254 Text 0 0,First,#,Data_Merge_Version_02,Detroit_PROJECT_Points_with_Duplicates.Address,0,254;City "City" true true false 254 Text 0 0,First,#,Data_Merge_Version_02,Detroit_PROJECT_Points_with_Duplicates.City,0,254;State "State" true true false 254 Text 0 0,First,#,Data_Merge_Version_02,Detroit_PROJECT_Points_with_Duplicates.State,0,254;Zip "Zip" true true false 8 Double 0 0,First,#,Data_Merge_Version_02,Detroit_PROJECT_Points_with_Duplicates.Zip,-1,-1;Latitude "Latitude" true true false 8 Double 0 0,First,#,Data_Merge_Version_02,Detroit_PROJECT_Points_with_Duplicates.Latitude,-1,-1;Longitude "Longitude" true true false 8 Double 0 0,First,#,Data_Merge_Version_02,Detroit_PROJECT_Points_with_Duplicates.Longitude,-1,-1;ReportURL "ReportURL" true true false 254 Text 0 0,First,#,Data_Merge_Version_02,Detroit_PROJECT_Points_with_Duplicates.ReportURL,0,254;OnlineLabe "OnlineLabe" true true false 254 Text 0 0,First,#,Data_Merge_Version_02,Detroit_PROJECT_Points_with_Duplicates.OnlineLabe,0,254;Areas_of_Interest "Area_of_In" true true false 254 Text 0 0,First,#,Data_Merge_Version_02,Detroit_PROJECT_Points_with_Duplicates.Areas_of_Interest,0,254" # CalculateField Data_Merge_Version_03 Zip !Zip_1! "Python 3" # Text NO_ENFORCE_DOMAINS ExportFeatures Data_Merge_Version_03 E:\Spartan_Public_Engagement_Map\0_Data_Formatting\SpartanPublicEngagmentFORMATTING.gdb\Data_Merge_Version_04 # NOT_USE_ALIAS "RSGIS_ID "RSGIS_ID" true true false 254 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.RSGIS_ID,0,254;RSGIS_ID_Copy "RSGIS_ID" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.RSGIS_ID_Copy,0,8000;ID "ID" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.ID,0,8000;Round_Submitted "Round Submitted to RS&GIS" true true false 4 Long 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.Round_Submitted,-1,-1;Reviewed "Reviewed" true true false 4 Long 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.Reviewed,-1,-1;Include "Include" true true false 4 Long 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.Include,-1,-1;Year "Year" true true false 4 Long 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.Year,-1,-1;College_MAU "College/MAU" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.College_MAU,0,8000;Department_Subunit "Department/Subunit" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.Department_Subunit,0,8000;Last_Name "Last Name" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.Last_Name,0,8000;First_Name "First Name" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.First_Name,0,8000;Email "Email" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.Email,0,8000;Title "Title" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.Title,0,8000;Project_Name "Project Name" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.Project_Name,0,8000;Project_Description "Project Description" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.Project_Description,0,8000;Empty_Fields_External_Partner "# empty fields in External Partners and locations (4 max)" true true false 4 Long 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.Empty_Fields_External_Partner,-1,-1;External_Partners "External Partners" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.External_Partners,0,8000;Michigan_Cities "Michigan Cities" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.Michigan_Cities,0,8000;Michigan_Counties "Michigan Counties" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.Michigan_Counties,0,8000;Countries "Countries" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.Countries,0,8000;Areas_of_Interest "Areas of Interest" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.Areas_of_Interest,0,8000;Additional_Funding "Additional Funding" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.Additional_Funding,0,8000;Funding_Source "Funding Source(s)" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.Funding_Source,0,8000;Additional_Comments "Additional Comments" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.Additional_Comments,0,8000;Name "Name" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.Name,0,8000;Address "Address" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.Address,0,8000;City "City" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.City,0,8000;State "State" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.State,0,8000;Zip "Zip" true true false 4 Long 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.Zip,-1,-1;Non_US "Non_US" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.Non_US,0,8000;GenLocationInfo "GenLocationInfo" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.GenLocationInfo,0,8000;Note "Note" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.Note,0,8000;Duration "Duration of Project (one-time or ongoing)" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.Duration,0,8000;Location_General "Location_General" true true false 255 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.Location_General,0,255;Orig_Address "Orig_Address" true true false 255 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.Orig_Address,0,255;OBJECTID "OBJECTID" true true false 4 Long 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.OBJECTID,-1,-1;RSGIS_ID_1 "RSGIS_Uniq" true true false 254 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.RSGIS_ID_1,0,254;ID_1 "ID" true true false 8 Double 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.ID_1,-1,-1;Year_1 "Year_" true true false 254 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.Year_1,0,254;College_MAU_1 "College_MA" true true false 254 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.College_MAU_1,0,254;Department_Subunit_1 "Department" true true false 254 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.Department_Subunit_1,0,254;Last_Name_1 "Last_Name" true true false 254 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.Last_Name_1,0,254;First_Name_1 "First_Name" true true false 254 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.First_Name_1,0,254;Email_1 "Email" true true false 254 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.Email_1,0,254;Title_1 "Title" true true false 254 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.Title_1,0,254;Project_Name_1 "Project_Na" true true false 254 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.Project_Name_1,0,254;Duration_1 "Years" true true false 254 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.Duration_1,0,254;Location_General_1 "Location_C" true true false 254 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.Location_General_1,0,254;Orig_Address_1 "Add_Orig" true true false 254 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.Orig_Address_1,0,254;Name_1 "Place" true true false 254 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.Name_1,0,254;Address_1 "Address" true true false 254 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.Address_1,0,254;City_1 "City" true true false 254 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.City_1,0,254;State_1 "State" true true false 254 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.State_1,0,254;Zip_1 "Zip" true true false 8 Double 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.Zip_1,-1,-1;Latitude "Latitude" true true false 8 Double 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.Latitude,-1,-1;Longitude "Longitude" true true false 8 Double 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.Longitude,-1,-1;ReportURL "ReportURL" true true false 254 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.ReportURL,0,254;OnlineLabe "OnlineLabe" true true false 254 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.OnlineLabe,0,254;Areas_of_Interest_1 "Area_of_In" true true false 254 Text 0 0,First,#,Data_Merge_Version_03,Data_Merge_Version_03.Areas_of_Interest_1,0,254;RSGIS_ID "RSGIS_ID" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.RSGIS_ID,0,8000;Year "Year" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.Year,0,8000;College/MAU "College/MAU" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.College/MAU,0,8000;Department/Subunit "Department/Subunit" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.Department/Subunit,0,8000;Last Name "Last Name" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.Last Name,0,8000;First Name "First Name" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.First Name,0,8000;Email "Email" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.Email,0,8000;Title "Title" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.Title,0,8000;Project Name "Project Name" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.Project Name,0,8000;Description "Description" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.Description,0,8000;External Partners "External Partners" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.External Partners,0,8000;Years "Years" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.Years,0,8000;Location/County "Location/County" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.Location/County,0,8000;Area of Interest "Area of Interest" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.Area of Interest,0,8000;Addresses of Detroit Partners "Addresses of Detroit Partners" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.Addresses of Detroit Partners,0,8000;Place "Place" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.Place,0,8000;Address "Address" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.Address,0,8000;City "City" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.City,0,8000;State "State" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.State,0,8000;Zip "Zip" true true false 4 Long 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.Zip,-1,-1;Lat_OLD "Lat_OLD" true true false 8 Double 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.Lat_OLD,-1,-1;Long_OLD "Long_OLD" true true false 8 Double 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.Long_OLD,-1,-1;RSGIS_Lat "RSGIS_Lat" true true false 8 Double 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.RSGIS_Lat,-1,-1;RSGIS_Long "RSGIS_Long" true true false 8 Double 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.RSGIS_Long,-1,-1;Field25 "Field25" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.Field25,0,8000;Field26 "Field26" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.Field26,0,8000;Field27 "Field27" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.Field27,0,8000;Field28 "Field28" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.Field28,0,8000;Field29 "Field29" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.Field29,0,8000;Field30 "Field30" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.Field30,0,8000;Field31 "Field31" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.Field31,0,8000;Field32 "Field32" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.Field32,0,8000;Field33 "Field33" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.Field33,0,8000;Field34 "Field34" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.Field34,0,8000;Field35 "Field35" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.Field35,0,8000;Field36 "Field36" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.Field36,0,8000;Field37 "Field37" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.Field37,0,8000;Field38 "Field38" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.Field38,0,8000;Field39 "Field39" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.Field39,0,8000;Field40 "Field40" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.Field40,0,8000;Field41 "Field41" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.Field41,0,8000;Field42 "Field42" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.Field42,0,8000;Field43 "Field43" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.Field43,0,8000;Field44 "Field44" true true false 8000 Text 0 0,First,#,Data_Merge_Version_03,DETROIT_JOIN_GOOD_RSGIS_DetroitProjects2022FullErinBunting.csv.Field44,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/3.1.0'><WorkspaceConnectionString>DATABASE=E:\Spartan_Public_Engagement_Map\0_Data_Formatting\SpartanPublicEngagmentFORMATTING.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Data_Merge_Version_04</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>Field25</field_name><field_name>Field26</field_name><field_name>Field27</field_name><field_name>Field28</field_name><field_name>Field29</field_name><field_name>Field30</field_name><field_name>Field31</field_name><field_name>Field32</field_name><field_name>Field33</field_name><field_name>Field34</field_name><field_name>Field35</field_name><field_name>Field36</field_name><field_name>Field37</field_name><field_name>Field38</field_name><field_name>Field39</field_name><field_name>Field40</field_name><field_name>Field41</field_name><field_name>Field42</field_name><field_name>Field43</field_name><field_name>Field44</field_name></DeleteField></workflow></operationSequence> CalculateField Data_Merge_Version_04 Year !Year_12! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Data_Merge_Version_04 Project_Description !Description! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Data_Merge_Version_04 External_Partners !External_Partners_1! "Python 3" # Text NO_ENFORCE_DOMAINS ExportFeatures Data_Merge_Version_04 E:\Spartan_Public_Engagement_Map\0_Data_Formatting\SpartanPublicEngagmentFORMATTING.gdb\Data_Merge_Version_05 # NOT_USE_ALIAS "RSGIS_ID "RSGIS_ID" true true false 254 Text 0 0,First,#,Data_Merge_Version_04,RSGIS_ID,0,254;RSGIS_ID_Copy "RSGIS_ID" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,RSGIS_ID_Copy,0,8000;ID "ID" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,ID,0,8000;Round_Submitted "Round Submitted to RS&GIS" true true false 4 Long 0 0,First,#,Data_Merge_Version_04,Round_Submitted,-1,-1;Reviewed "Reviewed" true true false 4 Long 0 0,First,#,Data_Merge_Version_04,Reviewed,-1,-1;Include "Include" true true false 4 Long 0 0,First,#,Data_Merge_Version_04,Include,-1,-1;Year "Year" true true false 4 Long 0 0,First,#,Data_Merge_Version_04,Year,-1,-1;College_MAU "College/MAU" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,College_MAU,0,8000;Department_Subunit "Department/Subunit" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,Department_Subunit,0,8000;Last_Name "Last Name" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,Last_Name,0,8000;First_Name "First Name" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,First_Name,0,8000;Email "Email" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,Email,0,8000;Title "Title" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,Title,0,8000;Project_Name "Project Name" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,Project_Name,0,8000;Project_Description "Project Description" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,Project_Description,0,8000;Empty_Fields_External_Partner "# empty fields in External Partners and locations (4 max)" true true false 4 Long 0 0,First,#,Data_Merge_Version_04,Empty_Fields_External_Partner,-1,-1;External_Partners "External Partners" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,External_Partners,0,8000;Michigan_Cities "Michigan Cities" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,Michigan_Cities,0,8000;Michigan_Counties "Michigan Counties" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,Michigan_Counties,0,8000;Countries "Countries" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,Countries,0,8000;Areas_of_Interest "Areas of Interest" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,Areas_of_Interest,0,8000;Additional_Funding "Additional Funding" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,Additional_Funding,0,8000;Funding_Source "Funding Source(s)" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,Funding_Source,0,8000;Additional_Comments "Additional Comments" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,Additional_Comments,0,8000;Name "Name" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,Name,0,8000;Address "Address" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,Address,0,8000;City "City" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,City,0,8000;State "State" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,State,0,8000;Zip "Zip" true true false 4 Long 0 0,First,#,Data_Merge_Version_04,Zip,-1,-1;Non_US "Non_US" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,Non_US,0,8000;GenLocationInfo "GenLocationInfo" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,GenLocationInfo,0,8000;Note "Note" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,Note,0,8000;Duration "Duration of Project (one-time or ongoing)" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,Duration,0,8000;Location_General "Location_General" true true false 255 Text 0 0,First,#,Data_Merge_Version_04,Location_General,0,255;Orig_Address "Orig_Address" true true false 255 Text 0 0,First,#,Data_Merge_Version_04,Orig_Address,0,255;OBJECTID "OBJECTID" true true false 4 Long 0 0,First,#,Data_Merge_Version_04,OBJECTID,-1,-1;RSGIS_ID_1 "RSGIS_Uniq" true true false 254 Text 0 0,First,#,Data_Merge_Version_04,RSGIS_ID_1,0,254;ID_1 "ID" true true false 8 Double 0 0,First,#,Data_Merge_Version_04,ID_1,-1,-1;Year_1 "Year_" true true false 254 Text 0 0,First,#,Data_Merge_Version_04,Year_1,0,254;College_MAU_1 "College_MA" true true false 254 Text 0 0,First,#,Data_Merge_Version_04,College_MAU_1,0,254;Department_Subunit_1 "Department" true true false 254 Text 0 0,First,#,Data_Merge_Version_04,Department_Subunit_1,0,254;Last_Name_1 "Last_Name" true true false 254 Text 0 0,First,#,Data_Merge_Version_04,Last_Name_1,0,254;First_Name_1 "First_Name" true true false 254 Text 0 0,First,#,Data_Merge_Version_04,First_Name_1,0,254;Email_1 "Email" true true false 254 Text 0 0,First,#,Data_Merge_Version_04,Email_1,0,254;Title_1 "Title" true true false 254 Text 0 0,First,#,Data_Merge_Version_04,Title_1,0,254;Project_Name_1 "Project_Na" true true false 254 Text 0 0,First,#,Data_Merge_Version_04,Project_Name_1,0,254;Duration_1 "Years" true true false 254 Text 0 0,First,#,Data_Merge_Version_04,Duration_1,0,254;Location_General_1 "Location_C" true true false 254 Text 0 0,First,#,Data_Merge_Version_04,Location_General_1,0,254;Orig_Address_1 "Add_Orig" true true false 254 Text 0 0,First,#,Data_Merge_Version_04,Orig_Address_1,0,254;Name_1 "Place" true true false 254 Text 0 0,First,#,Data_Merge_Version_04,Name_1,0,254;Address_1 "Address" true true false 254 Text 0 0,First,#,Data_Merge_Version_04,Address_1,0,254;City_1 "City" true true false 254 Text 0 0,First,#,Data_Merge_Version_04,City_1,0,254;State_1 "State" true true false 254 Text 0 0,First,#,Data_Merge_Version_04,State_1,0,254;Zip_1 "Zip" true true false 8 Double 0 0,First,#,Data_Merge_Version_04,Zip_1,-1,-1;Latitude "Latitude" true true false 8 Double 0 0,First,#,Data_Merge_Version_04,Latitude,-1,-1;Longitude "Longitude" true true false 8 Double 0 0,First,#,Data_Merge_Version_04,Longitude,-1,-1;ReportURL "ReportURL" true true false 254 Text 0 0,First,#,Data_Merge_Version_04,ReportURL,0,254;OnlineLabe "OnlineLabe" true true false 254 Text 0 0,First,#,Data_Merge_Version_04,OnlineLabe,0,254;Areas_of_Interest_1 "Area_of_In" true true false 254 Text 0 0,First,#,Data_Merge_Version_04,Areas_of_Interest_1,0,254;RSGIS_ID_12 "RSGIS_ID" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,RSGIS_ID_12,0,8000;Year_12 "Year" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,Year_12,0,8000;College_MAU_12 "College/MAU" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,College_MAU_12,0,8000;Department_Subunit_12 "Department/Subunit" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,Department_Subunit_12,0,8000;Last_Name_12 "Last Name" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,Last_Name_12,0,8000;First_Name_12 "First Name" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,First_Name_12,0,8000;Email_12 "Email" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,Email_12,0,8000;Title_12 "Title" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,Title_12,0,8000;Project_Name_12 "Project Name" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,Project_Name_12,0,8000;Description "Description" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,Description,0,8000;External_Partners_1 "External Partners" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,External_Partners_1,0,8000;Years "Years" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,Years,0,8000;Location_County "Location/County" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,Location_County,0,8000;Area_of_Interest "Area of Interest" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,Area_of_Interest,0,8000;Addresses_of_Detroit_Partners "Addresses of Detroit Partners" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,Addresses_of_Detroit_Partners,0,8000;Place "Place" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,Place,0,8000;Address_12 "Address" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,Address_12,0,8000;City_12 "City" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,City_12,0,8000;State_12 "State" true true false 8000 Text 0 0,First,#,Data_Merge_Version_04,State_12,0,8000;Zip_12 "Zip" true true false 4 Long 0 0,First,#,Data_Merge_Version_04,Zip_12,-1,-1;Lat_OLD "Lat_OLD" true true false 8 Double 0 0,First,#,Data_Merge_Version_04,Lat_OLD,-1,-1;Long_OLD "Long_OLD" true true false 8 Double 0 0,First,#,Data_Merge_Version_04,Long_OLD,-1,-1;RSGIS_Lat "RSGIS_Lat" true true false 8 Double 0 0,First,#,Data_Merge_Version_04,RSGIS_Lat,-1,-1;RSGIS_Long "RSGIS_Long" true true false 8 Double 0 0,First,#,Data_Merge_Version_04,RSGIS_Long,-1,-1" # CalculateField Data_Merge_Version_05 RSGIS_ID ""Detroit_" + !RSGIS_ID!" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Data_Merge_Version_05 Round_Submitted "Detroit Pilot" "Python 3" # Text NO_ENFORCE_DOMAINS 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/3.1.0'><WorkspaceConnectionString>DATABASE=E:\Spartan_Public_Engagement_Map\0_Data_Formatting\SpartanPublicEngagmentFORMATTING.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Data_Merge_Version_05</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AlterField><field_name>Years</field_name><new_field_name>Yea_2</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/3.1.0'><WorkspaceConnectionString>DATABASE=E:\Spartan_Public_Engagement_Map\0_Data_Formatting\SpartanPublicEngagmentFORMATTING.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Data_Merge_Version_05</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>OBJECTID</field_name><field_name>RSGIS_ID_1</field_name><field_name>ID_1</field_name><field_name>Year_1</field_name><field_name>College_MAU_1</field_name><field_name>Department_Subunit_1</field_name><field_name>Last_Name_1</field_name><field_name>First_Name_1</field_name><field_name>Email_1</field_name><field_name>Title_1</field_name><field_name>Project_Name_1</field_name><field_name>Duration_1</field_name><field_name>Location_General_1</field_name><field_name>Orig_Address_1</field_name><field_name>Name_1</field_name><field_name>Address_1</field_name><field_name>City_1</field_name><field_name>State_1</field_name><field_name>Zip_1</field_name><field_name>Latitude</field_name><field_name>Longitude</field_name><field_name>ReportURL</field_name><field_name>Areas_of_Interest_1</field_name><field_name>RSGIS_ID_12</field_name><field_name>Year_12</field_name><field_name>College_MAU_12</field_name><field_name>Department_Subunit_12</field_name><field_name>Last_Name_12</field_name><field_name>First_Name_12</field_name><field_name>Email_12</field_name><field_name>Title_12</field_name><field_name>Project_Name_12</field_name><field_name>Description</field_name><field_name>External_Partners_1</field_name><field_name>Location_County</field_name><field_name>Area_of_Interest</field_name><field_name>Addresses_of_Detroit_Partners</field_name><field_name>Place</field_name><field_name>Address_12</field_name><field_name>City_12</field_name><field_name>State_12</field_name><field_name>Zip_12</field_name><field_name>Lat_OLD</field_name><field_name>Long_OLD</field_name><field_name>RSGIS_Lat</field_name><field_name>RSGIS_Long</field_name></DeleteField></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/3.1.0'><WorkspaceConnectionString>DATABASE=E:\Spartan_Public_Engagement_Map\0_Data_Formatting\SpartanPublicEngagmentFORMATTING.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Data_Merge_Version_05</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Private</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> ExportFeatures Data_Merge_Version_05 E:\Spartan_Public_Engagement_Map\0_Data_Formatting\SpartanPublicEngagmentFORMATTING.gdb\Spartan_Engagement_Points_August_2023 # NOT_USE_ALIAS "RSGIS_ID "RSGIS_ID" true true false 254 Text 0 0,First,#,Data_Merge_Version_05,RSGIS_ID,0,254;RSGIS_ID_Copy "RSGIS_ID" true true false 8000 Text 0 0,First,#,Data_Merge_Version_05,RSGIS_ID_Copy,0,8000;ID "ID" true true false 8000 Text 0 0,First,#,Data_Merge_Version_05,ID,0,8000;Round_Submitted "Round Submitted to RS&GIS" true true false 4 Long 0 0,First,#,Data_Merge_Version_05,Round_Submitted,-1,-1;Reviewed "Reviewed" true true false 4 Long 0 0,First,#,Data_Merge_Version_05,Reviewed,-1,-1;Include "Include" true true false 4 Long 0 0,First,#,Data_Merge_Version_05,Include,-1,-1;Year "Year" true true false 4 Long 0 0,First,#,Data_Merge_Version_05,Year,-1,-1;Yea_2 "Years" true true false 8000 Text 0 0,First,#,Data_Merge_Version_05,Yea_2,0,8000;College_MAU "College/MAU" true true false 8000 Text 0 0,First,#,Data_Merge_Version_05,College_MAU,0,8000;Department_Subunit "Department/Subunit" true true false 8000 Text 0 0,First,#,Data_Merge_Version_05,Department_Subunit,0,8000;Last_Name "Last Name" true true false 8000 Text 0 0,First,#,Data_Merge_Version_05,Last_Name,0,8000;First_Name "First Name" true true false 8000 Text 0 0,First,#,Data_Merge_Version_05,First_Name,0,8000;Email "Email" true true false 8000 Text 0 0,First,#,Data_Merge_Version_05,Email,0,8000;Title "Title" true true false 8000 Text 0 0,First,#,Data_Merge_Version_05,Title,0,8000;Project_Name "Project Name" true true false 8000 Text 0 0,First,#,Data_Merge_Version_05,Project_Name,0,8000;Project_Description "Project Description" true true false 8000 Text 0 0,First,#,Data_Merge_Version_05,Project_Description,0,8000;Empty_Fields_External_Partner "# empty fields in External Partners and locations (4 max)" true true false 4 Long 0 0,First,#,Data_Merge_Version_05,Empty_Fields_External_Partner,-1,-1;External_Partners "External Partners" true true false 8000 Text 0 0,First,#,Data_Merge_Version_05,External_Partners,0,8000;Michigan_Cities "Michigan Cities" true true false 8000 Text 0 0,First,#,Data_Merge_Version_05,Michigan_Cities,0,8000;Michigan_Counties "Michigan Counties" true true false 8000 Text 0 0,First,#,Data_Merge_Version_05,Michigan_Counties,0,8000;Countries "Countries" true true false 8000 Text 0 0,First,#,Data_Merge_Version_05,Countries,0,8000;Areas_of_Interest "Areas of Interest" true true false 8000 Text 0 0,First,#,Data_Merge_Version_05,Areas_of_Interest,0,8000;Additional_Funding "Additional Funding" true true false 8000 Text 0 0,First,#,Data_Merge_Version_05,Additional_Funding,0,8000;Funding_Source "Funding Source(s)" true true false 8000 Text 0 0,First,#,Data_Merge_Version_05,Funding_Source,0,8000;Additional_Comments "Additional Comments" true true false 8000 Text 0 0,First,#,Data_Merge_Version_05,Additional_Comments,0,8000;Name "Name" true true false 8000 Text 0 0,First,#,Data_Merge_Version_05,Name,0,8000;Address "Address" true true false 8000 Text 0 0,First,#,Data_Merge_Version_05,Address,0,8000;City "City" true true false 8000 Text 0 0,First,#,Data_Merge_Version_05,City,0,8000;State "State" true true false 8000 Text 0 0,First,#,Data_Merge_Version_05,State,0,8000;Zip "Zip" true true false 4 Long 0 0,First,#,Data_Merge_Version_05,Zip,-1,-1;Non_US "Non_US" true true false 8000 Text 0 0,First,#,Data_Merge_Version_05,Non_US,0,8000;GenLocationInfo "GenLocationInfo" true true false 8000 Text 0 0,First,#,Data_Merge_Version_05,GenLocationInfo,0,8000;Note "Note" true true false 8000 Text 0 0,First,#,Data_Merge_Version_05,Note,0,8000;Duration "Duration of Project (one-time or ongoing)" true true false 8000 Text 0 0,First,#,Data_Merge_Version_05,Duration,0,8000;Location_General "Location_General" true true false 255 Text 0 0,First,#,Data_Merge_Version_05,Location_General,0,255;Orig_Address "Orig_Address" true true false 255 Text 0 0,First,#,Data_Merge_Version_05,Orig_Address,0,255;OnlineLabe "OnlineLabe" true true false 254 Text 0 0,First,#,Data_Merge_Version_05,OnlineLabe,0,254;Private "Private" true true false 255 Text 0 0,First,#,Data_Merge_Version_05,Private,0,255" # CopyFeatures E:\Spartan_Public_Engagement_Map\0_Data_Formatting\SpartanPublicEngagmentFORMATTING.gdb\Spartan_Engagement_Points_August_2023 E:\Spartan_Public_Engagement_Map\1_Data_to_Upload_to_Enterprise\SpartanPublicEngagement_Data.gdb\WGS_1984_Web_Mercator_Aux_Sphere\Spartan_Engagement_Points_August_2023 # # # # UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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/3.1.0'><FeatureDataset>WGS_1984_Web_Mercator_Aux_Sphere</FeatureDataset><WorkspaceConnectionString>DATABASE=E:\Spartan_Public_Engagement_Map\1_Data_to_Upload_to_Enterprise\SpartanPublicEngagement_Data.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Spartan_Engagement_Points_August_2023</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>Year2</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Zip2</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField Spartan_Engagement_Points_August_2023 Year2 !Year! "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField Spartan_Engagement_Points_August_2023 Zip2 !Zip! "Python 3" # Text NO_ENFORCE_DOMAINS DeleteField Spartan_Engagement_Points_August_2023 Year "Delete Fields" DeleteField Spartan_Engagement_Points_August_2023 Zip "Delete Fields" UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' 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/3.1.0'><FeatureDataset>WGS_1984_Web_Mercator_Aux_Sphere</FeatureDataset><WorkspaceConnectionString>DATABASE=E:\Spartan_Public_Engagement_Map\1_Data_to_Upload_to_Enterprise\SpartanPublicEngagement_Data.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Spartan_Engagement_Points_August_2023</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>Year</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Zip</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField Spartan_Engagement_Points_August_2023 Year !Year2! "Python 3" # Text NO_ENFORCE_DOMAINS DeleteField Spartan_Engagement_Points_August_2023 Year2 "Delete Fields" CalculateField Spartan_Engagement_Points_August_2023 Zip !Zip2! "Python 3" # Text NO_ENFORCE_DOMAINS DeleteField Spartan_Engagement_Points_August_2023 Zip2 "Delete Fields" CopyMultiple "E:\Spartan_Public_Engagement_Map\1_Data_to_Upload_to_Enterprise\SpartanPublicEngagement_Data.gdb\WGS_1984_Web_Mercator_Aux_Sphere\Spartan_Engagement_Points_August_2023 FeatureClass" K:\Provost\DB_Connection\SpartanImpact_gisowner.sde Spartan_Engagement_Points_August_2023_1 "Spartan_Engagement_Points_August_2023 FeatureClass GISOWNER.Spartan_Engagement_Points_August_2023_1 #" Rename K:\Provost\DB_Connection\SpartanImpact_gisowner.sde\GISOWNER.Spartan_Engagement_Points_August_2023_1 K:\Provost\DB_Connection\SpartanImpact_gisowner.sde\GISOWNER.Spartan_Engagement_Points_August_2023_2 FeatureClass Spartan_Engagement_Points_August_2023 002 0.000 Server=rsgis-map.campusad.msu.edu\rsgissql; Service=sde:sqlserver:rsgis-map.campusad.msu.edu\rsgissql; Database=SpartanImpact; User=gisowner; Version=sde.DEFAULT ArcSDE Connection Projected GCS_WGS_1984 Linear Unit: Meter (1.000000) <ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' 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/3.1.0'><WKT>PROJCS[&quot;WGS_1984_Web_Mercator_Auxiliary_Sphere&quot;,GEOGCS[&quot;GCS_WGS_1984&quot;,DATUM[&quot;D_WGS_1984&quot;,SPHEROID[&quot;WGS_1984&quot;,6378137.0,298.257223563]],PRIMEM[&quot;Greenwich&quot;,0.0],UNIT[&quot;Degree&quot;,0.0174532925199433]],PROJECTION[&quot;Mercator_Auxiliary_Sphere&quot;],PARAMETER[&quot;False_Easting&quot;,0.0],PARAMETER[&quot;False_Northing&quot;,0.0],PARAMETER[&quot;Central_Meridian&quot;,0.0],PARAMETER[&quot;Standard_Parallel_1&quot;,0.0],PARAMETER[&quot;Auxiliary_Sphere_Type&quot;,0.0],UNIT[&quot;Meter&quot;,1.0],AUTHORITY[&quot;EPSG&quot;,3857]]</WKT><XOrigin>-20037700</XOrigin><YOrigin>-30241100</YOrigin><XYScale>10000</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102100</WKID><LatestWKID>3857</LatestWKID></ProjectedCoordinateSystem> WGS_1984_Web_Mercator_Auxiliary_Sphere 20230810 12005500 20230810 12005500 Microsoft Windows 10 Version 10.0 (Build 19045) ; Esri ArcGIS 13.1.0.41833 Spartan_Engagement_Points_August_2023 Spartan_Engagement Spartan_Engagement File Geodatabase Feature Class 0.000 dataset EPSG 6.18.3(9.3.1.2) 0 Simple FALSE 0 TRUE FALSE Spartan_Engagement_Points_August_2023 Feature Class 0 Shape Shape Geometry 0 0 0 Feature geometry. Esri Coordinates defining the features. ID ID String 8000 0 0 Address Address String 8000 0 0 RSGIS_ID_Copy RSGIS_ID String 8000 0 0 Reviewed Reviewed Integer 4 0 0 Round_Submitted Round Submitted to RS&GIS Integer 4 0 0 Include Include Integer 4 0 0 Year Year Integer 4 0 0 Last_Name Last Name String 8000 0 0 Yea_2 Years String 8000 0 0 College_MAU College/MAU String 8000 0 0 Department_Subunit Department/Subunit String 8000 0 0 First_Name First Name String 8000 0 0 Email Email String 8000 0 0 Title Title String 8000 0 0 Countries Countries String 8000 0 0 Project_Name Project Name String 8000 0 0 Project_Description Project Description String 8000 0 0 Empty_Fields_External_Partner # empty fields in External Partners and locations (4 max) Integer 4 0 0 External_Partners External Partners String 8000 0 0 Michigan_Cities Michigan Cities String 8000 0 0 Michigan_Counties Michigan Counties String 8000 0 0 RSGIS_ID RSGIS_ID String 254 0 0 Areas_of_Interest Areas of Interest String 8000 0 0 Additional_Funding Additional Funding String 8000 0 0 Funding_Source Funding Source(s) String 8000 0 0 Additional_Comments Additional Comments String 8000 0 0 Name Name String 8000 0 0 City City String 8000 0 0 State State String 8000 0 0 Zip Zip Integer 4 0 0 Non_US Non_US String 8000 0 0 Note Note String 8000 0 0 GenLocationInfo GenLocationInfo String 8000 0 0 ObjectID OBJECTID OID 4 0 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. Duration Duration of Project (one-time or ongoing) String 8000 0 0 Location_General Location_General String 255 0 0 Orig_Address Orig_Address String 255 0 0 OnlineLabe OnlineLabe String 254 0 0 Private Private String 255 0 0 20230810 /9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD2YKQc ik28ehp4fgDaKcrDbkLzXIZjUkZTgVNHMpHzZJzTEzvyBu9RT9iZyP1q4p9CkSGRRz0pkknzZxTG Qs39BSZAOM0Sb6g7jjJvIG0igjaBufaO2TU0e3HTmq95ateskTgrEp3blPOapQvqwsP2453fkaQZ 6kc5qjH4btox8s0+c5JL0L4dgjfes033s4LU+QdjRTgnJ60v54+tPWPCbc8j1pPLboeM0rNCEAVT lTwaQybTjBbPrQI2VSN2aBESeTRaQFCRr4NcfKOc+UB0xjj9arb9WZ7Y7Qox++X8e1ajHYcZyfak LELnrQncOYzXl1Mx3I2YO790QecU6J9Sa4tlkVdmzExH96r6NgcnJpxBJBzwPStPZsn2iJgoQfM2 aYdhbAbmjNROdr/P+lZNlEpBFJ3xUBOTwTj3pQ7DpU3QrktLTQ5xllyKFcFueBQA7rSfSnMuOR0p tUm47A0hcmjNFJVqrK5Lgh1NbHcUoYGg85FdfoZD1TcOoApAdvApoPHWngoPU1ySqOWhsopbD1PH X9aeuQKhyg5GaUSn0pKS6l3JicUxt2O1NPz85x7UKHX6U7gS9qaVGaUk4460zcaYyqijnjvRsG/j gmnI4Ycn5qpXd9bQSBZpVjPUE1DhYmyexcJaLnAPHWqV0sl2IzHJsdDn2NRrqdqysPtCfTNLDe2c 03kwzLI23dgelSm0GpYtr3fw42yjqKsFBISVwDVCYSFmkiKCULwW6CpLW4L2yyd84df8Ku6aGXYD hyrdarX2tRWDuskMrbcDKrnOalfK/MD9TVi3jCQ7dxf3anHsCM2PxHayybFimyOp28Vrk5ANNWGM LtCKFznGO9PboPrVDA80mCepp1BoAOnFFFLQBC0RZiQf0qBlVPvZJq5TQobIPrUuPYVioMLnIIpQ Tj5RkVYKnkE5U0kalflxwOhrRX3W5Dh0IUPPNLIV3HOOnGaeUIk3YGKY8WTuz2rOa10Gr2IKKXHO DSEYPWsBBk4AzSU4njGKaOe2aLN7CHiRu/IqZBkZ28VWp6ysgwDTT7jTJTRTVm4O4ZpQykdcGmMO BS5pjFQeCTQrDOc4PpW0K1tGQ4XY8U5evSjkGmmVx0AArNvW7LWhIdp46Ui5VunFJHjOWPzVLvG3 JppX1GGQW5HTvTieOKgaTaDuOSemKQTAAhgfwquZDuPaRx91c00XIxz1pm87MqTmoCMnOahza2E2 R+Ztb7wJ6e9V47aOZJHuo0cLyCx4AHNX5Ig2TxzVcQzj5flKZIYN/dra+rjIzj3Rnu2m4JKwAN3L DmrNjHCWke2ijzgfMpqN9G09nXZaocHI5NathZwW8JSGPYCeRWUUmaIp7WEhO3pgnmqdwZLeRpY4 2Ksw3qOa6E26ZqrOoGV7Gk1yhsQwzNLAWVAw9m6VajlfGNg5/wBqqNtGIJWO4hT/AAjpVj52divT tTUuw7lsPL/zzH/fVIWlYAeWP++qSKT5ADnPfNP3fNjNaJjE3S/88x/31QGl/wCeY/76pe5APNP5 9RTAj3y5/wBWP++qN8v/ADzH/fVSYHekI5HagBpaX/nmP++qaGlz/qx/31UuPSjvzQAwtLn/AFY/ 76pC0oP+rH/fVSUjDcpGce9IBhMjrgxD/vqoQsqOWx8uMFQcmqmg6RNpEM6TXst0ZJS4Mn8IPatF n+fCik7biKjMGYlQR7YpoYN0INXDECRnr3rMlvdP/tE2Cyp9rC7jHu5xWbgS0ixScofrSi2UjJOP oay9a1e20P7KZoJ5/tEojXy1J257nArSFFp3bsZuSNXY3pSYx1qvLOoOyNvmK52A8/lTIlZMytDJ k9Ruq5UU1oLmLY680HAPBzTVdTxkZ9M0tcrVnZljgMnFOCFWHzL+dR05dp+9kUIaJRubnJJ9qazk ZVuaajlDxSM24knvRfQLjhJjnHNKXdhkdqjoycYzxSuFyVI9435BPpQwAOD8o+lRgHHANID13cAd zVrULknylSAPxqMjnrTWmLcKhx2PrSZ9SwPpV3S2VxcrZN/AD6UvzmHNI3CY9afK37tVHpV1muZi p/CV4EZn3AfdPSrwDfextNQ2g/dNj7xNObfn5qiOiNVsPdzyFIz61AZOCrjPvUmPn3e2KasO1GbG e2Kbu0BVJDfSpovuEg4wAMmlC7ee/al4Q54qIIUUPyDJ3AP605mAIPYHk0FWdQduDTNmYz1J71o3 YonUqRuBH1p4ORmqNqFUMhznOcZp0yvAQ6EspPK5ouBczSOTxQFGAefzpkh2YPWmA/JpDnHShGDq CKcaAEycdKBux0o9qcPSgBqn5jxilZc9OtIR8wNOzQBXmkihUGWZI8nALsBk1QOkWo1FtRWBftRX b5nfFZ/ijwePE11ZSvqE1vHbNuMcY4c/nXRoPKRUPIAxmk43JtchWJnHPFRXEAwocK4ByMjOKvE4 +lIyByCecUnG6sHKeeatpDaP4pttZtlvbyS4kCNEr/JGMYzjNdffXkGn2ElzcNsCLuOTyfoKuSja WYDJAzgV4J421nXpfFSXk9vcW9lDJsWJn+VscZxnnNaqKS1MZOzOp8K61H4p8a3OoobmFbdNiIT+ 6Yep969IhlSdQUZSPVTkV4To/jW30LVdWt2tCbe9c4WNtu3r0x9a9b8GwxxeFbYxwvCGO8o77iPx oUVLRoSZ0YBGcAYppK9NtTxx7xuzimPGFVmJG7tnvUVIRt7ppHmZXORTghIGKzHvb9UH/EvLNjnD d6ns7y6e48uazaMHowOayVOXVFF7yn9Kr3cMskJggmEVw4+RiMgVakyFw7En0Bxis2/1Kz0mE3V5 IyRLgbsnvTSinYeiF+waysaD+0Idy/eO3r+lMSK/a+QTXcMkODlVXn27VZikSeFZY3YpINwOTyDT GuLeCSJJpUiaVtqBjjcaHO+iC5ZbCsAOcVBNvaUkA4q6QoA2jdxUfln1FONOXREOaixHYBMU3ORS thoxUaHa+0LuNKsv3jFT1iW0Owg4zxU+VbmoI23LhgKcvCEY+bJqomqJFO8njC5puGRzjlPSkCY5 PUVIFAXpVDGmME5I4oCxj7o5pDjJPp2pipuXeO3aiyAkY+9RRgElT35pTh1PY07zEjAJpNa6iVmR xRukxV1yvZqsOobA9DSCVG6ZNKzYGcGmhiM4UgHihxnjGRURmBUhxjn5fenrKrMQDkjqPSkA9RtG ABUN2lw8OIGCtnrnFTbvY1mnXIVtZbgxtsjPOOvXFMBTDqpl/wBfH5fHbkU6SHUVlZ4p1IZuFboB Sf2xEVDLGWzGZBz2yP8AGlTVkeaKLyiDIm/OegoAkgW9FwvnOpTnOKuFfc1yF942R5Psml2zXOoK wLQ+i55OfzrromaSFHddrFQSPQ0xXHY46mkIAHJ6+9LmsrWNDg1l7ZpZ5o/s8gkXy2xn60hmlk7d v8WK5DS9bvbYavZ6nqlm1/AGeNQeI1xxursFBOOeBWXqPhrStSS7861QSXSbJJF4YjtTE79DA8O+ KTf6IJ7m5guLhWZZWhPAwTj9K8N8XeILu78TzvJdNfW0cjeUknzKBnpjtXs/hz4YxaCdRjXUZXgu 0KKo4KAms7U/hJ4e0/QpZTFeXMsXztsbLv7DiqcjFwlY+f5JfNuWYYXceQvavQvh54l8UNcxaDpX lurNvPnDgL3+nArubb4S6Bq/hiKS1gubG6kTcplPzKccbuBn9K0fAngPUfCl7dJM1s9uwGydFw7H 86E0JQaZ0yy65DCqsbbd3Iq5ct9qtQu3fKFzhem7FVZL6WHxBDp39nzSRSRljdD7inng8VoAxSzM kEyM6feAYEr9aTaWq1NNTO0AahcWLNrNolvcbyAFOcjt2qW81nTdJ1C0tJ94mu22x7VyM+/51cYs gwad5CTBJGjUsvQkcio9o2NIlkCy+x9a5S01q11rXtS0KazV0tVDln5DdO341vX11FYW0lzO3lwx jLsewrzPSvFFjF4quI9P1H7a184Co8ZG049e/SpSvrYTep6Ne3I0vSZrvySyQJu2KOo9q5O0lh8d ra6tbRxlbV8rHL1jfv8A0rX12x1jW9AnsUMdtK/y7lOcipvCukXGiaVDp8kUaJFGvzIeWbuT+law p2epMn2LMH9s+eodoBEDyAOcVqEDPWnAYpcVutDJ6lZGDY9BT4gEvfVSvBqpC+x+ehql4i8RWOgw QfaJ/LluH2RHGeazr0mpcyHQqK1mbciMkxI6HpUkbZz65xWZGur3Vrv86AblBQqM+hz0qNk1iNmc yQ44HT/61YJWZ0rQ2ivzc9O9AI7Gsq1l1MzhJpYSgI3Y64/KtMpsAAPFUUJIVRST070QPlCD93PF IVDKwakh4HTAWlcQ6RVTJ/GolwwVmXINNmZmVzySegHep0IIPGCBgiktXcBPMQH5BwKQzsxCqO/J NI0ZYnBwO2KTATGRjvSd7iKOrwTTWEiW0pScjCuP4TVHR/DcyafCNTv5ri6HLODgEn6VrneI2ZeV Jqxb/wCoTqeO9NAinb6LBa3AmWWZioIAZjiom1G2ENwRbBljcI44GScf41rk8HioxBCVIMSYbk/K OaoZRa8tVuXtxCpmSLcVHpxxUcWoW0klpi22tOhZDnovH+NaXkQbzJ5SbyMbtvOKBbwgofJQbBhc L0HtQFzG0/UNEk1MRwrDFfupwuPmKj/JrUkvbS3WQzXMKrH9/Lj5fr6U0aRYC/W+W1iFyowJAoBx WdJ4R0qS4v5pY3k+3Y85WkOOMdOeOlMWptxSxTRLJGyujDKspyCKcy5BxUVvbQ2NpHbwJtijUKo9 AKUsw6dKTaQXFlmSCB5X4RBk1j6xqC3mkTR2N+LW4dPklK/d/SqV3ouo3XieHUY9UdLNQA9tjKt6 8V0f2W2ZRmCIj3QUJ32Bamf4fuCbCK2nvRd3UafvJAMbvel0u91O6v76G+sFgt4nxBIGz5g9TzV+ KOCElookQ9PlUCpAzN2xTAcmOQMYzWFaQ61H4ku57q8R9MYAQQqOVNPt9aMviC50s2c6LCobzyPl atJeCxLA0m7Be4+aYKMAZJrCsNEs9K1W71OBpjLdfeVmyq/SrWparZacI2vJ1hWRwiFs8t6VOqmc fKRt9ayc3fQm92KJN7l3+VepJPAFeZ+ItR0ex8aRXcniG6Yb1kMMDho1wehwK7I6xBeSarp15bTW 1rbrte4bgMOeQRzWJ4a+Hvh6yM99C4v4bsAqZFBAHPStKa6EyY2w8Ta1rWssLrSgNEdSgG0kuMcG tPT10WzuZGs9CMTh+WCZ5x2zXUxxxxRpHEgREGAAMAUx3WIEKoBPoK3hB9CJzS3FE6mJXII3DOD2 pv2kelVmfJ5NMLntXQqZzOo+hba59BURuWz1qvnNFWoIhzYVS1rQtP8AEtklpqEZZUYMrKcEH2NX aVTg5olFNWYouzNK1jjtLaKKHOyJFTBPOAMCp3jEq7h9arW74P1qfzRETnpXnzjyuzPShNSVzJO+ 3vHCjKbSyk1oW8/nRc8FTzUFzPaxTb5mwpUke/rUP9sabC6bZgBIT071KNB0OsWFzqUunw3CNcRr ukjzyv1q8EXqW/CueS70CDVpL+IRC5f5ZZQOT7GuhimhkhM6sNgGc9sU7IQ1ced5a+nXFTFCq4zk HrxVO21K11GPzbKeKZFbBZGzzWgrB1FJdgRCDukMeccccUNCU5zn6inFNshcDJ7UhdmOOgo3Ark7 YnA6Z4qSBXWJSG/OlNuhQdeDmpVWi2oDcscg5/KnDOO/5UoHJpc0wEGT3/SlwfX9KQdTVTVpry30 u4l0+ETXSqTGhPBNAC3+o22lWj3V7OsMCdXbpSyX8C6cb4Sb4NnmAqM5HXiqyQHVdGij1e0QvIuZ YTyoNW1jiihWFFCRqMBQOAKTYrsr6TrltrWnre2iSCJiQBIuDwcdKtM5ZSOfwqPy0UfKQAOcCqGl 69p+rX91ZWkxea0bbKCuAD/kVLuxXNGGIg7myBUqgnPXH0pz4+7ikL7eADgdapJRQ9hwbPAHSlyf SmhwRkKajecqOFOaLjFZt7YKn2pgjYn7uBTZpxHHksF/2jWFqiapfS2b6fqKW8SS7ps/xrxx1qdG yWaOr6NY6zaG2uYg2OUYjJRvUUuhaU2jaYlm9zLclCT5knU81DrF1qVnZRNpVulxKZFDhj0XPJrV DPLEoYbSy/NjscVQ9LkN3a29/byW88YlhkG10IyCKZbWFvp9nHbW0YjhiGFQDAAqHRtGi0VLhY7i WXzpTIfMbOM+lXXkLPjAIqorXQmVrajScR5FUXc5qzK4RCveqROTmu2mjhqPWwnWiikJA61sZC0U wv6U3cfWnYVyWiiikMlikKnFWc85PNUasRybhg9aynBMuEmjKfR9Qn1O+nk1M/Z5Y9sEQUfujzz0 qfR9Jm0y2itry4F3IeshUCtHJqUxtNCzq53qMqMd65atO2qOyjO7swTT7WNSot4xuPp1q15cflGI INuMEe1V4hvRGLkMOoPrU4kdTgpn3Ws7G5UsNGs9MgeGxhWFGYsVX1NWNrLnB5qUSoSSG/PimMN2 ctwelS43CxEkkmTu6Cnbt8g29ByTTwy/MDgY70zzIUVnBwMZPBoSYEkkmEBHQ0+PlSazrHU7HV4n NlMJlhfY+3IwR25q9GxBI2nFMB46mg9aADzxS0AJjNHQZ3ce9LVbUbNdQsJ7RpHjEqlS6HBH0oAg 1DUGs0jZIWnVs58sZxVCLWzNLsawuUyQAShx/Kr2j6PHo9nHbJPLMEXG6Rsk1dfBPelKwiHAAzxS W9vbwSO8MKJJIcuyjBanhO1SRqFzkVCWohwOIy3c0wNlWFBcBcVEelOUtR3Hq5UYpGYt1oBGMEUr AEfKKnURzmo22s32u/Znt4Topiz5pb5hJ24zUWieGJrW0ZNTuftM5clXUkYXsK6qJSRz0oKDd7VW ttAsYuoeG4b9LELdzwLaSbwI2+97GtwsoGOtMl4AC9TTD6mtYwbJlNRFOScmmM4UcUhYmoJH7Cui EEtjmnUuQSMWcmmE4pSOaic84rqSOZsUv6UzOaKKokKKKKAJqKKKkoKAcHNFFAEyyZqzby7X9jVA HBqWN+eePSs5Rui4Tady2Y3imZicoxyPapkbDAg8d6RX3x4fkVE4McnXIPNcsVb3Wdknf3kXWVHG WANQPGgYDJ596fC+8bT+FLMgKZ7ispJo2Urq6K4VCMndx71YUhgR/DjGKrEZHNSoBsypxWcZNgmQ w6bbWIc2UMcBdizhFADH3qwh3ICOGB5FJESyEH71I0TR5aM9eoNWMl3gYpw56VV2s4LyKNvYZpV3 R/Mg47igZYJxWVqev2ulXVnb3CSl7p9iFFyAfetPYr4bJ55oMSEgsoJHQntS1uSPByBWfe6kbaVU igaf+9sIO361eZ1XqcVi2GhWmm6peX9s8vm3ZBk3Nkdug/CrUWxSkkI2tuX+Wznx3+WtO0uDc25c xPEc9HHNPyc5yaQkk5yafsiPaIq32o2mnbGvLlIhI21N3c+lTg7lBHIPQ1U1TSbLWEhW+t0m8l96 bh0NWVIiULxgcDFCo33JlUsPzyOuPaniTGAP1FQebuOBT1bdwat0UtiVVJw7cAYqKZ2jwzMqgnHJ xS4rP1fRLXXooIrtpQIZBIpjbHIIPP5VnKm7bminfQ0McgnuKjc84qKO/snunsIbmN7i3Ub4w2WU e4qV/vVrSd0ZVdGNqrLkGrJOBVa4JIGO9dENznlsRUxl7inDpS1qZENFPZe9MqhBRRRQBNRRRUlB RRRQAUUUUAXYJgwweDVsqGi28Fu1ZAODmr0Eu5RzyK5qtO+qOmjVtowLNG5HpU8UnmKVY80joJEL AfMKrA7GqElNWe5bbpu62ZJOpR89qEb5MqeKmXEijkE+9V5F8okk4Ga4pRcGbruW4yMBvWnOcVVh kO8A9Ogqzu2nJrRO6LQ1yEQZ6HikhOY8HpTigJJJyO1Rsdm92+6ozxTGOH7pwAfkb9DUrNtUn0rC Fvf30puLW+2Qk8Iy9P0pz2Gsgk/2kCvptH+FMTNLP8TdaYZh6VTs4b6Jn+1T+YmPl4HWnu+3611Q V0cVSTTLPm8UnnVV872pHmCqWJ4Fachn7QsmU4qJnzVY3Kk4zSpMrgkc4pqNiXK5LkjkU6Oc7sNU RbNNqrX3JvY1FOVzWZexau2sWb2dxElmpPnqw5P61etzmMVMeRXNJdDqi9mRQ6RYW+oT38Nsi3U4 xJIOrCoY761up5Ybe4jkeI7XVGBKn3rQRwV2n0rz3QdKtrjVdWlsIryxb7Sd5l6SNzyM9qzhdOxr Us0jtnRutVphwKit9Purd0eW9eULjIOMGpZiWOQPlFdNNtnLUSWxFQeKKYzHpWyMAZgRgUyiiqEF FFFAE1FFFSUFFFFABRRRQAU+N9je1MopAacEwHOcqaZNGMlgOKpRyFD7VZE4KFSeCKwlTcXeJ0Rq KS5ZBG5U4qw4WVMHrVEsC3y1LHJjvSqUudBCpyuwsZKyY7ip3uIbe386ZwiA8k0ySIOu5fvVEFSU mKRRIp6qw4rgScHZnZFjl1exbI89eCRnn609L+1lkCLKrb+g55pUsbMj/j3j6/3RTntLdWBSJFK9 CB0rQoghK2l60AOEflfrV18lCDVG7jMkkTgAHdgGrsgPXPFEN7ClsyrM+BgVSY5arEpyart1NejB WPNm7sSmyBihC4z2zTqVVLHAFWQV1SUDnZn1xU8ETnggde1WYrY5y1WlRUGAKzlNLY0jTb3KZgwK hZSpwa0nAK1UdBkk0ozuEoWEt5Shx2q2ZVCkk4A5NVY4Wf7op81tIY9qleeDn0qZuNy6alYX7fbH kTL+dEc8Mr4SRWPXANVx4esXw3koTj0qSLSreyl82KFUbGMj0rJS1NZQdrlqQAqc5pjAeUAAMU8M rDBxShAM471S0JauZ8ibTxyKrtnNX5CC20DFV3i6muiMu5zSj2K9FOZMU2tCAooooAmoooqSgooo oAKKKKACiiigAoopRxQA/ovFIrbeaCcimUrDNGCYEA0SbS2V9ck1Wt2XlTUpPlZHXI6+tefiFaVj toSvEqvf3UEzFLR54gMrs7/jUb6tfuw/4lMoB/2vb6VpQzRRRlVXCjrUouYxjJ69qyTVjoMFdWu5 UUHTZQFbOS3/ANat6OVZoeOvpTZ5Y44t7HCnvisRbbWUmeWKaF1PAyKaundBa5pTLg1Wcc1WWTUr nzEJUMpHK/rTrVLwTMtztKD7pHWu6nUTRwVKdmT7DV6BFWMYHNQhM9qsRqVXBpzd0KmrMfTth74F Nx3zwKarbjgGuOdVxdkdMYprUkKEDOQRVKZgCT2qzO+xduaz5H3NXTRTauzGs0nZEguXHA4FSC7G OVJNVKK2cImCnJFo3foCPxqNy10cGYpximBQaX5AeWAqXTi1axcas073JINOkWXf9qYjOdp9KsvD Mv3TkVAlyqDBbNSf2iqgBVJHvWPJJPQ29pCa97QicuT8w6U3kipXu0cY8vk1GFDH0Fapu2qsYySv o7hEkbqQfvVBLDg8VJN5NtKiyyhC/wB0k8UhaLG5bqFlzjO8daFUSe4OlK2xWIIPNJRJeW7Oy+am V681GJkYZVkI9c1spJmTi0WqKKKACiiigAooooAKKKKAClPWiigBKXPY0UUALjHINTRz4I3DNFFZ zipLU0hJxeg8kNIWUDaexqXMSSZZeD3oorz6kUnodsJOW5HKiSyDPzJ6ZqzEqojFfriiis47mhRs SkdzIj8bjlSavSQcgqM5oorSnJrYmUU9xRAcZwKURse9FFaOTuJQRDMwV8bhimQygOQnLfyoorn+ 2PqNuZMjnrVPFFFepS+E4J6y1F3KvXmkLBunFFFXYyDk+tAiz0FFFF7DJYrQP1bFOa32Ec5FFFYy k7nRGC5RQqjtTlKZPzce9FFORMSpcR/aW2SxrKo4X2FINNsSUVYgEU52e9FFc8oLmOjnfKix9j08 x7Psy1CNOslGFjUD0zRRWiijKUmf/9k=