20200918 11241700 1.0 TRUE CalculateField ntm_agencies NTD_ID [NTDID5] VB # Append ntm_agency_50522 ntm_agencies NO_TEST "F5_Digit_NTD_ID "F5_Digit_NTD_ID" true true false 4 Long 0 0 ,First,#,ntm_agency_50522,F5_Digit_NTD_ID,-1,-1;Legacy_NTD_ID "Legacy_NTD_ID" true true false 8000 Text 0 0 ,First,#,ntm_agency_50522,Legacy_NTD_ID,-1,-1;Agency_Name "Agency_Name" true true false 8000 Text 0 0 ,First,#,ntm_agency_50522,Agency_Name,-1,-1;Reporter_Acronym "Reporter_Acronym" true true false 8000 Text 0 0 ,First,#,ntm_agency_50522,Reporter_Acronym,-1,-1;Doing_Business_As "Doing_Business_As" true true false 8000 Text 0 0 ,First,#,ntm_agency_50522,Doing_Business_As,-1,-1;Reporter_Status "Reporter_Status" true true false 8000 Text 0 0 ,First,#,ntm_agency_50522,Reporter_Status,-1,-1;Reporter_Type "Reporter_Type" true true false 8000 Text 0 0 ,First,#,ntm_agency_50522,Reporter_Type,-1,-1;Reporting_Module "Reporting_Module" true true false 8000 Text 0 0 ,First,#,ntm_agency_50522,Reporting_Module,-1,-1;Organization_Type "Organization_Type" true true false 8000 Text 0 0 ,First,#,ntm_agency_50522,Organization_Type,-1,-1;Reported_By_NTD_ID "Reported_By_NTD_ID" true true false 8000 Text 0 0 ,First,#,ntm_agency_50522,Reported_By_NTD_ID,-1,-1;Reported_by_Name "Reported_by_Name" true true false 8000 Text 0 0 ,First,#,ntm_agency_50522,Reported_by_Name,-1,-1;Subrecipient_Type "Subrecipient_Type" true true false 8000 Text 0 0 ,First,#,ntm_agency_50522,Subrecipient_Type,-1,-1;FY_End_Date "FY_End_Date" true true false 8 Date 0 0 ,First,#,ntm_agency_50522,FY_End_Date,-1,-1;Original_Due_Date "Original_Due_Date" true true false 8 Date 0 0 ,First,#,ntm_agency_50522,Original_Due_Date,-1,-1;Address_Line_1 "Address_Line_1" true true false 8000 Text 0 0 ,First,#,ntm_agency_50522,Address_Line_1,-1,-1;Address_Line_2 "Address_Line_2" true true false 8000 Text 0 0 ,First,#,ntm_agency_50522,Address_Line_2,-1,-1;PO_Box "PO_Box" true true false 8000 Text 0 0 ,First,#,ntm_agency_50522,PO_Box,-1,-1;City "City" true true false 8000 Text 0 0 ,First,#,ntm_agency_50522,City,-1,-1;State "State" true true false 8000 Text 0 0 ,First,#,ntm_agency_50522,State,-1,-1;Zip_Code "Zip_Code" true true false 4 Long 0 0 ,First,#,ntm_agency_50522,Zip_Code,-1,-1;Zip_Code_Ext "Zip_Code_Ext" true true false 8000 Text 0 0 ,First,#,ntm_agency_50522,Zip_Code_Ext,-1,-1;Region "Region" true true false 4 Long 0 0 ,First,#,ntm_agency_50522,Region,-1,-1;URL "URL" true true false 8000 Text 0 0 ,First,#,ntm_agency_50522,URL,-1,-1;FTA_Recipient_ID "FTA_Recipient_ID" true true false 8000 Text 0 0 ,First,#,ntm_agency_50522,FTA_Recipient_ID,-1,-1;Service_Area_Sq_Miles "Service_Area_Sq_Miles" true true false 4 Long 0 0 ,First,#,ntm_agency_50522,Service_Area_Sq_Miles,-1,-1;Service_Area_Pop "Service_Area_Pop" true true false 4 Long 0 0 ,First,#,ntm_agency_50522,Service_Area_Pop,-1,-1;Primary_UZA "Primary_UZA" true true false 4 Long 0 0 ,First,#,ntm_agency_50522,Primary_UZA,-1,-1;UZA_Name "UZA_Name" true true false 8000 Text 0 0 ,First,#,ntm_agency_50522,UZA_Name,-1,-1;Tribal_Area_Name "Tribal_Area_Name" true true false 8000 Text 0 0 ,First,#,ntm_agency_50522,Tribal_Area_Name,-1,-1;Density "Density" true true false 4 Long 0 0 ,First,#,ntm_agency_50522,Density,-1,-1;Sq_Miles "Sq_Miles" true true false 4 Long 0 0 ,First,#,ntm_agency_50522,Sq_Miles,-1,-1;Required_Reporter "Required_Reporter" true true false 8000 Text 0 0 ,First,#,ntm_agency_50522,Required_Reporter,-1,-1;VOMS_DO "VOMS_DO" true true false 4 Long 0 0 ,First,#,ntm_agency_50522,VOMS_DO,-1,-1;VOMS_PT "VOMS_PT" true true false 8000 Text 0 0 ,First,#,ntm_agency_50522,VOMS_PT,-1,-1;Total_VOMS "Total_VOMS" true true false 4 Long 0 0 ,First,#,ntm_agency_50522,Total_VOMS,-1,-1;Volunteer_Drivers "Volunteer_Drivers" true true false 8000 Text 0 0 ,First,#,ntm_agency_50522,Volunteer_Drivers,-1,-1;Personal_Vehicles "Personal_Vehicles" true true false 8000 Text 0 0 ,First,#,ntm_agency_50522,Personal_Vehicles,-1,-1;MSGUSPS "MSGUSPS" true true false 8000 Text 0 0 ,First,#,ntm_agency_50522,MSGUSPS,-1,-1;MSG2KX "MSG2KX" true true false 8000 Text 0 0 ,First,#,ntm_agency_50522,MSG2KX,-1,-1;LON_1 "LON" true true false 8 Double 0 0 ,First,#,ntm_agency_50522,LON_1,-1,-1;LAT_1 "LAT" true true false 8 Double 0 0 ,First,#,ntm_agency_50522,LAT_1,-1,-1;NTMParticipation "NTMParticipation" true true false 8000 Text 0 0 ,First,#,ntm_agency_50522,NTMParticipation,-1,-1;NTD_ID "NTD_ID" true true false 10 Text 0 0 ,First,#,ntm_agency_50522,NTD_ID,-1,-1" # DeleteField NTM_Agencies_082020 Legacy_NTD_ID;Reporter_Acronym;Doing_Business_As;Reported_By_NTD_ID;Reported_by_Name;Subrecipient_Type;FY_End_Date;Original_Due_Date;Address_Line_1;Address_Line_2;PO_Box;Zip_Code_Ext;Region;URL;FTA_Recipient_ID;Primary_UZA;UZA_Name;Required_Reporter;VOMS_DO;VOMS_PT;Volunteer_Drivers;Personal_Vehicles;MSGUSPS;MSG2KX file://\\RITSLHQE-77526\C$\Users\g.grandstaff.ctr\Documents\ArcGIS\Projects\NTM\NTM.gdb Local Area Network ISO 19139 Metadata Implementation Specification BTS DOT NTM GTFS NTM Agencies. Data Trimmed down from original attributes. Created and published for BTS/ DOT applications 2020. NTM_Agencies_All_082020