20240104
15363200
1.0
FALSE
CreateFeatureclass R:\annam\ED\Data\ED_Data.gdb\Businesses BusinessPts_0124 Point R:\annam\ED\Data\ED_Data.gdb\BusinessTable_0124 No No "PROJCS["NAD_1983_HARN_StatePlane_Washington_North_FIPS_4601_Feet",GEOGCS["GCS_North_American_1983_HARN",DATUM["D_North_American_1983_HARN",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",1640416.666666667],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-120.8333333333333],PARAMETER["Standard_Parallel_1",47.5],PARAMETER["Standard_Parallel_2",48.73333333333333],PARAMETER["Latitude_Of_Origin",47.0],UNIT["Foot_US",0.3048006096012192]];-117104300 -99539600 3048.00609601219;-100000 10000;-100000 10000;3.28083333333333E-03;0.001;0.001;IsHighPrecision" # 0 0 0 #
XYTableToPoint R:\annam\ED\Data\ED_Data.gdb\BusinessTable_0124 R:\annam\ED\Data\ED_Data.gdb\Businesses\BusinessPts_0124 Longitude Latitude # "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"
AddFields R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 "NAICS_Desc TEXT 'NAICS Industry Description' 255 # #;X DOUBLE # # # #;Y DOUBLE # # # #"
Append R:\annam\ED\Data\ED_Data.gdb\Businesses\BusinessTable_noLatLong_Geocoded R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 "Use the field map to reconcile field differences" "Run_Date "Run-Date" true true false 8 Date 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Run_Date,-1,-1;Home_Operated_Business "Home-Operated-Business" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Home_Operated_Business,0,8000;bus_ubi "bus-ubi" true true false 4 Long 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_bus_ubi,0,255;bus_id "bus-id" true true false 4 Long 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_bus_id,0,255;busloc_id "busloc-id" true true false 4 Long 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_busloc_id,0,255;LE_name "LE-name" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_LE_name,0,8000;firm_name "firm-name" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_firm_name,0,8000;Mail_addr1 "Mail-addr1" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Mail_addr1,0,8000;Mail_addr2 "Mail-addr2" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Mail_addr2,0,8000;Mail_addr3 "Mail-addr3" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Mail_addr3,0,8000;Mail_UnitType "Mail-UnitType" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Mail_UnitType,0,8000;Mail_Unit "Mail-Unit" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Mail_Unit,0,8000;Mail_City "Mail-City" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Mail_City,0,8000;Mail_State "Mail-State" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Mail_State,0,8000;Mail_Zip "Mail-Zip" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Mail_Zip,0,8000;Mail_Zip_4 "Mail-Zip+4" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Mail_Zip_4,0,8000;Phys_addr1 "Phys-addr1" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Phys_addr1,0,8000;Phys_addr2 "Phys-addr2" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Phys_addr2,0,8000;Phys_addr3 "Phys-addr3" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Phys_addr3,0,8000;Phys_UnitType "Phys-UnitType" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Phys_UnitType,0,8000;Phys_Unit "Phys-Unit" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Phys_Unit,0,8000;Phys_City "Phys-City" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Phys_City,0,8000;Phys_State "Phys-State" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Phys_State,0,8000;Phys_Zip "Phys-Zip" true true false 4 Long 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Phys_Zip,0,255;Phys_Zip_4 "Phys-Zip+4" true true false 4 Long 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Phys_Zip_4,0,255;phone "phone" true true false 8 Double 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\Businesses\BusinessTable_noLatLong_Geocoded,USER_phone,0,25;Location_Email "Location Email" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Location_Email,0,8000;Agency_Id "Agency-Id" true true false 4 Long 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Agency_Id,0,255;ETP_ID "ETP-ID" true true false 4 Long 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_ETP_ID,0,255;Endrs_Stat_Code "Endrs-Stat-Code" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Endrs_Stat_Code,0,8000;Endrs_Exp_Date "Endrs-Exp-Date" true true false 8 Date 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Endrs_Exp_Date,-1,-1;Endrs_Stat_Date "Endrs-Stat-Date" true true false 8 Date 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Endrs_Stat_Date,-1,-1;Endrs_1st_Issue_date "Endrs-1st-Issue-date" true true false 8 Date 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Endrs_1st_Issue_date,-1,-1;Cntct1_Last_Name "Cntct1-Last-Name" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Cntct1_Last_Name,0,8000;Cntct_First_Name "Cntct-First-Name" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Cntct_First_Name,0,8000;Cntct1_Mid_Othr_Name "Cntct1-Mid-Othr-Name" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Cntct1_Mid_Othr_Name,0,8000;Cntct1_Phone "Cntct1-Phone" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Cntct1_Phone,0,8000;Cntct1_Addr1 "Cntct1-Addr1" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Cntct1_Addr1,0,8000;Cntct1_Addr2 "Cntct1-Addr2" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Cntct1_Addr2,0,8000;Cntct1_Addr3 "Cntct1-Addr3" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Cntct1_Addr3,0,8000;Cntct1_City "Cntct1-City" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Cntct1_City,0,8000;Cntct1_State "Cntct1-State" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Cntct1_State,0,8000;Cntct1_Zip "Cntct1-Zip" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Cntct1_Zip,0,8000;Cntct2_Last_Name "Cntct2-Last-Name" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Cntct2_Last_Name,0,8000;Cntct2_First_Name "Cntct2-First-Name" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Cntct2_First_Name,0,8000;Cntct2_Mid_Othr_Name "Cntct2-Mid-Othr-Name" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Cntct2_Mid_Othr_Name,0,8000;Cntct2_Phone "Cntct2-Phone" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Cntct2_Phone,0,8000;HazardousFlammableMtrl "HazardousFlammableMtrl" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_HazardousFlammableMtrl,0,8000;Sqr_Footage "Sqr-Footage" true true false 4 Long 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Sqr_Footage,-1,-1;Endrs_Acct_Num "Endrs-Acct-Num" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Endrs_Acct_Num,0,8000;Employee_Cnt "Employee-Cnt" true true false 4 Long 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Employee_Cnt,-1,-1;Part_Time_Employee_Cnt "Part-Time-Employee-Cnt" true true false 4 Long 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Part_Time_Employee_Cnt,-1,-1;RentalUnitCount "RentalUnitCount" true true false 4 Long 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_RentalUnitCount,-1,-1;Dealer_Mgr_Lic_Num "Dealer-Mgr-Lic-Num" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Dealer_Mgr_Lic_Num,0,8000;Gross_Income "Gross Income" true true false 8 Double 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Gross_Income,-1,-1;City_Alarm_Company "City Alarm Company" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_City_Alarm_Company,0,8000;City_Alarm_Contact "City Alarm Contact" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_City_Alarm_Contact,0,8000;City_Alarm_Cntct_Phone "City Alarm Cntct Phone" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_City_Alarm_Cntct_Phone,0,8000;City_Limits "City Limits" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_City_Limits,0,8000;ProdDescription "ProdDescription" true true false 8000 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_ProdDescription,0,8000;Latitude "Latitude" true true false 8 Double 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Latitude,-1,-1;Longitude "Longitude" true true false 8 Double 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_Longitude,-1,-1;DOR_NAICS_Primary "DOR-NAICS-Primary" true true false 4 Long 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_DOR_NAICS_Primary,0,255;DOR_NAICS_Secondary "DOR-NAICS-Secondary" true true false 4 Long 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_DOR_NAICS_Secondary,0,255;UID "UID" true true false 255 Text 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\BusinessTable_noLatLong_Geocoded,USER_UID,0,255;X "X" true true false 8 Double 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\Businesses\BusinessTable_noLatLong_Geocoded,X,-1,-1;Y "Y" true true false 8 Double 0 0,First,#,R:\annam\ED\Data\ED_Data.gdb\Businesses\BusinessTable_noLatLong_Geocoded,Y,-1,-1" # #
CalculateGeometryAttributes R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 "X POINT_X;Y POINT_Y" # # PROJCS["NAD_1983_HARN_StatePlane_Washington_North_FIPS_4601_Feet",GEOGCS["GCS_North_American_1983_HARN",DATUM["D_North_American_1983_HARN",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",1640416.666666667],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-120.8333333333333],PARAMETER["Standard_Parallel_1",47.5],PARAMETER["Standard_Parallel_2",48.73333333333333],PARAMETER["Latitude_Of_Origin",47.0],UNIT["Foot_US",0.3048006096012192]] "Same as input"
CalculateGeometryAttributes R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 "Latitude POINT_Y;Longitude POINT_X" # # GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]] "Decimal Degrees"
DeleteField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Mail_addr3 "Delete Fields"
DeleteField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Phys_addr3 "Delete Fields"
DeleteField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Cntct1_Addr1 "Delete Fields"
DeleteField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Cntct1_Addr2 "Delete Fields"
DeleteField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Cntct1_Addr3 "Delete Fields"
DeleteField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Cntct1_City "Delete Fields"
DeleteField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Cntct1_State "Delete Fields"
DeleteField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Cntct1_Zip "Delete Fields"
DeleteField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Dealer_Mgr_Lic_Num "Delete Fields"
DeleteField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 UID "Delete Fields"
CalculateField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 phone Round($feature.phone,0) Arcade # Text NO_ENFORCE_DOMAINS
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Run_Date # "Date Data Downloaded" Date 8 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Home_Operated_Business # "Home Operated Business" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 bus_ubi # "Unified Business ID" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 bus_id # "Business ID" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 busloc_id # "Business Location ID" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 LE_name # "Legal Entity Name" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 firm_name # "Business/Firm Name" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Mail_addr1 # "Mailing Street Address" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Mail_addr2 # "Mailing Street Address Line 2" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Mail_UnitType # "Mailing Unit Type" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Mail_Unit # "Mailing Unit" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Mail_City # "Mailing City" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Mail_State # "Mailing State" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Mail_Zip # "Mailing Zip" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Mail_Zip_4 # "Mailing Zip +4" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Phys_addr1 # "Physical Street Address" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Phys_addr2 # "Physical Street Address Line 2" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Phys_UnitType # "Physical Unit Type" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Phys_Unit # "Physical Unit" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Phys_City # "Physical City" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Phys_State # "Physical State" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Phys_Zip # "Physical Zip" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Phys_Zip_4 # "Physical Zip +4" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 phone # Phone Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Location_Email # "Location Email" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Agency_Id # "Agency ID" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 ETP_ID # "Endorsement Type ID" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Endrs_Stat_Code # "Endorsement Status Code" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Endrs_Exp_Date # "Endorsement Expiration Date" Date 8 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Endrs_Stat_Date # "Endorsement Start Date" Date 8 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Endrs_1st_Issue_date # "Endorsement First Issuance Date" Date 8 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Cntct1_Last_Name # "Contact 1 Last Name" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Cntct_First_Name # "Contact 1 First Name" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Cntct1_Mid_Othr_Name # "Contact 1 Middle/Other Name" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Cntct1_Phone # "Contact 1 Phone" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Cntct2_Last_Name # "Contact 2 Last Name" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Cntct2_First_Name # "Contact 2 First Name" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Cntct2_Mid_Othr_Name # "Contact 2 Middle/Other Name" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Cntct2_Phone # "Contact 2 Phone" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 HazardousFlammableMtrl # "Hazardous or Flammable Material" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Sqr_Footage # "Business Floor Area (Sq Ft)" "Long (large integer)" 4 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Endrs_Acct_Num # "Endorsement Account Number" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Employee_Cnt # "Employee Count" "Long (large integer)" 4 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Part_Time_Employee_Cnt # "Part-Time Employee Count" "Long (large integer)" 4 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 RentalUnitCount # "Rental Unit Count" "Long (large integer)" 4 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 Gross_Income # "Gross Income" "Double (double precision)" 8 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 City_Alarm_Company # "Emergency City Alarm Company" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 City_Alarm_Contact # "Emergency City Alarm Contact" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 City_Alarm_Cntct_Phone # "Emergency City Alarm Contact Phone" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 City_Limits # "In City Limits" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 ProdDescription # "Products & Services" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 DOR_NAICS_Primary # "Primary NAICS Code" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 DOR_NAICS_Secondary # "Secondary NAICS Code" Text 255 NULLABLE DO_NOT_CLEAR
AlterField R:\annam\ED\Data\ED_Data.gdb\BusinessPts_0124 NAICS_Desc # "NAICS Description" Text 255 NULLABLE DO_NOT_CLEAR
SpatialJoin "BusinessPts_0124 selection" "Shopping Centers" R:\annam\ED\Data\ED_Data.gdb\Businesses\Businesses_ShoppingCenters "Join one to one" KEEP_ALL "Run_Date "Date Data Downloaded" true true false 8 Date 0 0,First,#,BusinessPts_0124 selection,Run_Date,-1,-1;Home_Operated_Business "Home Operated Business" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,Home_Operated_Business,0,255;bus_ubi "Unified Business ID" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,bus_ubi,0,255;bus_id "Business ID" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,bus_id,0,255;busloc_id "Business Location ID" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,busloc_id,0,255;LE_name "Legal Entity Name" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,LE_name,0,255;firm_name "Business/Firm Name" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,firm_name,0,255;Mail_addr1 "Mailing Street Address" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,Mail_addr1,0,255;Mail_addr2 "Mailing Street Address Line 2" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,Mail_addr2,0,255;Mail_UnitType "Mailing Unit Type" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,Mail_UnitType,0,255;Mail_Unit "Mailing Unit" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,Mail_Unit,0,255;Mail_City "Mailing City" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,Mail_City,0,255;Mail_State "Mailing State" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,Mail_State,0,255;Mail_Zip "Mailing Zip" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,Mail_Zip,0,255;Mail_Zip_4 "Mailing Zip +4" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,Mail_Zip_4,0,255;Phys_addr1 "Physical Street Address" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,Phys_addr1,0,255;Phys_addr2 "Physical Street Address Line 2" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,Phys_addr2,0,255;Phys_UnitType "Physical Unit Type" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,Phys_UnitType,0,255;Phys_Unit "Physical Unit" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,Phys_Unit,0,255;Phys_City "Physical City" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,Phys_City,0,255;Phys_State "Physical State" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,Phys_State,0,255;Phys_Zip "Physical Zip" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,Phys_Zip,0,255;Phys_Zip_4 "Physical Zip +4" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,Phys_Zip_4,0,255;phone "Phone" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,phone,0,255;Location_Email "Location Email" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,Location_Email,0,255;Agency_Id "Agency ID" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,Agency_Id,0,255;ETP_ID "Endorsement Type ID" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,ETP_ID,0,255;Endrs_Stat_Code "Endorsement Status Code" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,Endrs_Stat_Code,0,255;Endrs_Exp_Date "Endorsement Expiration Date" true true false 8 Date 0 0,First,#,BusinessPts_0124 selection,Endrs_Exp_Date,-1,-1;Endrs_Stat_Date "Endorsement Start Date" true true false 8 Date 0 0,First,#,BusinessPts_0124 selection,Endrs_Stat_Date,-1,-1;Endrs_1st_Issue_date "Endorsement First Issuance Date" true true false 8 Date 0 0,First,#,BusinessPts_0124 selection,Endrs_1st_Issue_date,-1,-1;Cntct1_Last_Name "Contact 1 Last Name" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,Cntct1_Last_Name,0,255;Cntct_First_Name "Contact 1 First Name" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,Cntct_First_Name,0,255;Cntct1_Mid_Othr_Name "Contact 1 Middle/Other Name" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,Cntct1_Mid_Othr_Name,0,255;Cntct1_Phone "Contact 1 Phone" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,Cntct1_Phone,0,255;Cntct2_Last_Name "Contact 2 Last Name" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,Cntct2_Last_Name,0,255;Cntct2_First_Name "Contact 2 First Name" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,Cntct2_First_Name,0,255;Cntct2_Mid_Othr_Name "Contact 2 Middle/Other Name" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,Cntct2_Mid_Othr_Name,0,255;Cntct2_Phone "Contact 2 Phone" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,Cntct2_Phone,0,255;HazardousFlammableMtrl "Hazardous or Flammable Material" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,HazardousFlammableMtrl,0,255;Sqr_Footage "Business Floor Area (Sq Ft)" true true false 4 Long 0 0,First,#,BusinessPts_0124 selection,Sqr_Footage,-1,-1;Endrs_Acct_Num "Endorsement Account Number" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,Endrs_Acct_Num,0,255;Employee_Cnt "Employee Count" true true false 4 Long 0 0,First,#,BusinessPts_0124 selection,Employee_Cnt,-1,-1;Part_Time_Employee_Cnt "Part-Time Employee Count" true true false 4 Long 0 0,First,#,BusinessPts_0124 selection,Part_Time_Employee_Cnt,-1,-1;RentalUnitCount "Rental Unit Count" true true false 4 Long 0 0,First,#,BusinessPts_0124 selection,RentalUnitCount,-1,-1;Gross_Income "Gross Income" true true false 8 Double 0 0,First,#,BusinessPts_0124 selection,Gross_Income,-1,-1;City_Alarm_Company "Emergency City Alarm Company" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,City_Alarm_Company,0,255;City_Alarm_Contact "Emergency City Alarm Contact" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,City_Alarm_Contact,0,255;City_Alarm_Cntct_Phone "Emergency City Alarm Contact Phone" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,City_Alarm_Cntct_Phone,0,255;City_Limits "In City Limits" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,City_Limits,0,255;ProdDescription "Products & Services" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,ProdDescription,0,255;Latitude "Latitude" true true false 8 Double 0 0,First,#,BusinessPts_0124 selection,Latitude,-1,-1;Longitude "Longitude" true true false 8 Double 0 0,First,#,BusinessPts_0124 selection,Longitude,-1,-1;DOR_NAICS_Primary "Primary NAICS Code" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,DOR_NAICS_Primary,0,255;DOR_NAICS_Secondary "Secondary NAICS Code" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,DOR_NAICS_Secondary,0,255;NAICS_Desc "NAICS Description" true true false 255 Text 0 0,First,#,BusinessPts_0124 selection,NAICS_Desc,0,255;X "X" true true false 8 Double 0 0,First,#,BusinessPts_0124 selection,X,-1,-1;Y "Y" true true false 8 Double 0 0,First,#,BusinessPts_0124 selection,Y,-1,-1;NAME "NAME" true true false 30 Text 0 0,First,#,Shopping Centers,NAME,0,30" Intersect # #
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/2.9.0'><FeatureDataset>Businesses</FeatureDataset><WorkspaceConnectionString>DATABASE=R:\annam\ED\Data\ED_Data.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Businesses_ShoppingCenters</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteField><field_name>Join_Count</field_name><field_name>TARGET_FID</field_name><field_name>Run_Date</field_name><field_name>Home_Operated_Business</field_name><field_name>bus_ubi</field_name><field_name>bus_id</field_name><field_name>busloc_id</field_name><field_name>LE_name</field_name><field_name>Mail_addr1</field_name><field_name>Mail_addr2</field_name><field_name>Mail_UnitType</field_name><field_name>Mail_Unit</field_name><field_name>Mail_City</field_name><field_name>Mail_State</field_name><field_name>Mail_Zip</field_name><field_name>Mail_Zip_4</field_name><field_name>Phys_addr2</field_name><field_name>phone</field_name><field_name>Location_Email</field_name><field_name>Agency_Id</field_name><field_name>ETP_ID</field_name><field_name>Endrs_Stat_Code</field_name><field_name>Endrs_Exp_Date</field_name><field_name>Endrs_Stat_Date</field_name><field_name>Endrs_1st_Issue_date</field_name><field_name>Cntct1_Last_Name</field_name><field_name>Cntct_First_Name</field_name><field_name>Cntct1_Mid_Othr_Name</field_name><field_name>Cntct1_Phone</field_name><field_name>Cntct2_Last_Name</field_name><field_name>Cntct2_First_Name</field_name><field_name>Cntct2_Mid_Othr_Name</field_name><field_name>Cntct2_Phone</field_name><field_name>HazardousFlammableMtrl</field_name><field_name>Sqr_Footage</field_name><field_name>Endrs_Acct_Num</field_name><field_name>Employee_Cnt</field_name><field_name>Part_Time_Employee_Cnt</field_name><field_name>RentalUnitCount</field_name><field_name>Gross_Income</field_name><field_name>City_Alarm_Company</field_name><field_name>City_Alarm_Contact</field_name><field_name>City_Alarm_Cntct_Phone</field_name><field_name>City_Limits</field_name><field_name>Latitude</field_name><field_name>Longitude</field_name><field_name>DOR_NAICS_Primary</field_name><field_name>DOR_NAICS_Secondary</field_name><field_name>X</field_name><field_name>Y</field_name></DeleteField></workflow></operationSequence>
DeleteField Businesses_ShoppingCenters NAICS_Desc "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/2.9.0'><FeatureDataset>Businesses</FeatureDataset><WorkspaceConnectionString>DATABASE=R:\annam\ED\Data\ED_Data.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Businesses_ShoppingCenters</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>Address</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_alias>Address</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateField Businesses_ShoppingCenters Address "!Phys_addr1! + ' ' + !Phys_UnitType! + ' ' + !Phys_Unit! + ', ' + !Phys_City!" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Businesses_ShoppingCenters Address !Address!.title() "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Businesses_ShoppingCenters Address !Address!.replace(' ,',',') "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Businesses_ShoppingCenters Address !Address!.replace('1St','1st') "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Businesses_ShoppingCenters Address !Address!.replace('2Nd','2nd') "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Businesses_ShoppingCenters Address !Address!.replace('3Rd','3rd') "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Businesses_ShoppingCenters Address !Address!.replace('4Th','4th') "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Businesses_ShoppingCenters Address !Address!.replace('5Th','5th') "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Businesses_ShoppingCenters Address !Address!.replace('6Th','6th') "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Businesses_ShoppingCenters Address !Address!.replace('7Th','7th') "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Businesses_ShoppingCenters Address !Address!.replace('8Th','8th') "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Businesses_ShoppingCenters Address !Address!.replace('9Th','9th') "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Businesses_ShoppingCenters Address !Address!.replace('0Th','0th') "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Businesses_ShoppingCenters Address !Address!.replace('Sw ','SW ') "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Businesses_ShoppingCenters Address !Address!.replace('Se ','SE ') "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Businesses_ShoppingCenters Address !Address!.replace('Ste ','Suite ') "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Businesses_ShoppingCenters Address "!Address! + ', ' + !Phys_State! + ' ' + !Phys_Zip!" "Python 3" # Text NO_ENFORCE_DOMAINS
DeleteField Businesses_ShoppingCenters Phys_addr1;Phys_UnitType;Phys_Unit;Phys_City;Phys_State;Phys_Zip;Phys_Zip_4 "Delete Fields"
CalculateField Businesses_ShoppingCenters firm_name !firm_name!.title() "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Businesses_ShoppingCenters firm_name !firm_name!.replace("'S ", "'s ") "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Businesses_ShoppingCenters firm_name !firm_name!.replace("Llc", "LLC") "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Businesses_ShoppingCenters firm_name !firm_name!.replace(" Of ", " of ") "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Businesses_ShoppingCenters firm_name !firm_name!.replace(" The ", " the ") "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Businesses_ShoppingCenters firm_name !firm_name!.replace("Pllc", "PLLC") "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Businesses_ShoppingCenters firm_name !firm_name!.replace(" And ", " and ") "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Businesses_ShoppingCenters firm_name !firm_name!.replace("Am Pm", "AM/PM") "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Businesses_ShoppingCenters firm_name !firm_name!.replace("Am/Pm", "AM/PM") "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Businesses_ShoppingCenters firm_name !firm_name!.replace("Dba ", "DBA ") "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Businesses_ShoppingCenters firm_name !firm_name!.replace("'S,", "'s,") "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Businesses_ShoppingCenters firm_name !firm_name!.replace("Mcdonald", "McDonald") "Python 3" # Text NO_ENFORCE_DOMAINS
{"type":"CIMLayerDocument","version":"2.9.0","build":32739,"layers":["CIMPATH=map11/businesspts_0124.xml"],"layerDefinitions":[{"type":"CIMFeatureLayer","name":"BusinessPts_0124","uRI":"CIMPATH=map11/businesspts_0124.xml","sourceModifiedTime":{"type":"TimeInstant"},"useSourceMetadata":true,"description":"BusinessPts_0124","layerElevation":{"type":"CIMLayerElevationSurface","mapElevationID":"{785AAFCA-BD0D-458B-AA13-7EFDB24E12FF}"},"expanded":true,"layerType":"Operational","showLegends":true,"visibility":true,"displayCacheType":"Permanent","maxDisplayCacheAge":5,"showPopups":true,"serviceLayerID":-1,"refreshRate":-1,"refreshRateUnit":"esriTimeUnitsSeconds","blendingMode":"Alpha","allowDrapingOnIntegratedMesh":true,"autoGenerateFeatureTemplates":true,"featureTable":{"type":"CIMFeatureTable","displayField":"LE_name","editable":true,"dataConnection":{"type":"CIMFeatureDatasetDataConnection","featureDataset":"Businesses","workspaceConnectionString":"DATABASE=R:\\annam\\ED\\Data\\ED_Data.gdb","workspaceFactory":"FileGDB","dataset":"BusinessPts_0124","datasetType":"esriDTFeatureClass"},"studyAreaSpatialRel":"esriSpatialRelUndefined","searchOrder":"esriSearchOrderSpatial"},"htmlPopupEnabled":true,"selectable":true,"featureCacheType":"Session","displayFiltersType":"ByScale","featureBlendingMode":"Alpha","labelClasses":[{"type":"CIMLabelClass","expression":"$feature.OBJECTID","expressionEngine":"Arcade","featuresToLabel":"AllVisibleFeatures","maplexLabelPlacementProperties":{"type":"CIMMaplexLabelPlacementProperties","featureType":"Point","avoidPolygonHoles":true,"canOverrunFeature":true,"canPlaceLabelOutsidePolygon":true,"canRemoveOverlappingLabel":true,"canStackLabel":true,"connectionType":"Unambiguous","constrainOffset":"NoConstraint","contourAlignmentType":"Page","contourLadderType":"Straight","contourMaximumAngle":90,"enableConnection":true,"enablePointPlacementPriorities":true,"featureWeight":0,"fontHeightReductionLimit":4,"fontHeightReductionStep":0.5,"fontWidthReductionLimit":90,"fontWidthReductionStep":5,"graticuleAlignmentType":"Straight","keyNumberGroupName":"Default","labelBuffer":15,"labelLargestPolygon":true,"labelPriority":-1,"labelStackingProperties":{"type":"CIMMaplexLabelStackingProperties","stackAlignment":"ChooseBest","maximumNumberOfLines":3,"minimumNumberOfCharsPerLine":3,"maximumNumberOfCharsPerLine":24,"separators":[{"type":"CIMMaplexStackingSeparator","separator":" ","splitAfter":true},{"type":"CIMMaplexStackingSeparator","separator":",","visible":true,"splitAfter":true}],"trimStackingSeparators":true},"lineFeatureType":"General","linePlacementMethod":"OffsetCurvedFromLine","maximumLabelOverrun":36,"maximumLabelOverrunUnit":"Point","minimumFeatureSizeUnit":"Map","multiPartOption":"OneLabelPerPart","offsetAlongLineProperties":{"type":"CIMMaplexOffsetAlongLineProperties","placementMethod":"BestPositionAlongLine","labelAnchorPoint":"CenterOfLabel","distanceUnit":"Percentage","useLineDirection":true},"pointExternalZonePriorities":{"type":"CIMMaplexExternalZonePriorities","aboveLeft":4,"aboveCenter":2,"aboveRight":1,"centerRight":3,"belowRight":5,"belowCenter":7,"belowLeft":8,"centerLeft":6},"pointPlacementMethod":"AroundPoint","polygonAnchorPointType":"GeometricCenter","polygonBoundaryWeight":0,"polygonExternalZones":{"type":"CIMMaplexExternalZonePriorities","aboveLeft":4,"aboveCenter":2,"aboveRight":1,"centerRight":3,"belowRight":5,"belowCenter":7,"belowLeft":8,"centerLeft":6},"polygonFeatureType":"General","polygonInternalZones":{"type":"CIMMaplexInternalZonePriorities","center":1},"polygonPlacementMethod":"CurvedInPolygon","primaryOffset":1,"primaryOffsetUnit":"Point","removeExtraWhiteSpace":true,"repetitionIntervalUnit":"Point","rotationProperties":{"type":"CIMMaplexRotationProperties","rotationType":"Arithmetic","alignmentType":"Straight"},"secondaryOffset":100,"strategyPriorities":{"type":"CIMMaplexStrategyPriorities","stacking":1,"overrun":2,"fontCompression":3,"fontReduction":4,"abbreviation":5},"thinningDistanceUnit":"Point","truncationMarkerCharacter":".","truncationMinimumLength":1,"truncationPreferredCharacters":"aeiou","truncationExcludedCharacters":"0123456789","polygonAnchorPointPerimeterInsetUnit":"Point"},"name":"Class 1","priority":-1,"standardLabelPlacementProperties":{"type":"CIMStandardLabelPlacementProperties","featureType":"Line","featureWeight":"Low","labelWeight":"High","numLabelsOption":"OneLabelPerName","lineLabelPosition":{"type":"CIMStandardLineLabelPosition","above":true,"inLine":true,"parallel":true},"lineLabelPriorities":{"type":"CIMStandardLineLabelPriorities","aboveStart":3,"aboveAlong":3,"aboveEnd":3,"centerStart":3,"centerAlong":3,"centerEnd":3,"belowStart":3,"belowAlong":3,"belowEnd":3},"pointPlacementMethod":"AroundPoint","pointPlacementPriorities":{"type":"CIMStandardPointPlacementPriorities","aboveLeft":2,"aboveCenter":2,"aboveRight":1,"centerLeft":3,"centerRight":2,"belowLeft":3,"belowCenter":3,"belowRight":2},"rotationType":"Arithmetic","polygonPlacementMethod":"AlwaysHorizontal"},"textSymbol":{"type":"CIMSymbolReference","symbol":{"type":"CIMTextSymbol","blockProgression":"TTB","depth3D":1,"extrapolateBaselines":true,"fontEffects":"Normal","fontEncoding":"Unicode","fontFamilyName":"Tahoma","fontStyleName":"Regular","fontType":"Unspecified","haloSize":1,"height":10,"hinting":"Default","horizontalAlignment":"Left","kerning":true,"letterWidth":100,"ligatures":true,"lineGapType":"ExtraLeading","symbol":{"type":"CIMPolygonSymbol","symbolLayers":[{"type":"CIMSolidFill","enable":true,"color":{"type":"CIMRGBColor","values":[0,0,0,100]}}]},"textCase":"Normal","textDirection":"LTR","verticalAlignment":"Bottom","verticalGlyphOrientation":"Right","wordSpacing":100,"billboardMode3D":"FaceNearPlane"}},"useCodedValue":true,"visibility":true,"iD":-1}],"renderer":{"type":"CIMSimpleRenderer","patch":"Default","symbol":{"type":"CIMSymbolReference","symbol":{"type":"CIMPointSymbol","symbolLayers":[{"type":"CIMVectorMarker","enable":true,"anchorPoint":{"x":0,"y":-0.5},"anchorPointUnits":"Relative","dominantSizeAxis3D":"Y","size":12,"billboardMode3D":"FaceNearPlane","frame":{"xmin":0,"ymin":0,"xmax":21,"ymax":21},"markerGraphics":[{"type":"CIMMarkerGraphic","geometry":{"curveRings":[[[17.170000000000002,14.33],{"b":[[10.5,0],[17.170000000000002,10.65],[12.380000000000001,6.1500000000000004]]},{"b":[[3.8300000000000001,14.33],[8.6500000000000004,6.1799999999999997],[3.8300000000000001,10.65]]},{"b":[[10.5,21],[3.8300000000000001,18.010000000000002],[6.8200000000000003,21]]},{"b":[[17.170000000000002,14.33],[14.19,21],[17.170000000000002,18.010000000000002]]}]]},"symbol":{"type":"CIMPolygonSymbol","symbolLayers":[{"type":"CIMSolidStroke","enable":true,"capStyle":"Round","joinStyle":"Round","lineStyle3D":"Strip","miterLimit":10,"width":0,"color":{"type":"CIMRGBColor","values":[110,110,110,100]}},{"type":"CIMSolidFill","enable":true,"color":{"type":"CIMRGBColor","values":[0,122,194,80]}}]}}],"scaleSymbolsProportionally":true,"respectFrame":true}],"haloSize":1,"scaleX":1,"angleAlignment":"Display"}}},"scaleSymbols":true,"snappable":true}]}
Businesses_ShoppingCenters
002
file://\\cfwgis1\users\annam\ED\Data\ED_Data.gdb
Local Area Network
Projected
GCS_North_American_1983_HARN
Linear Unit: Foot_US (0.304801)
NAD_1983_HARN_StatePlane_Washington_North_FIPS_4601_Feet
<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/2.9.0'><WKT>PROJCS["NAD_1983_HARN_StatePlane_Washington_North_FIPS_4601_Feet",GEOGCS["GCS_North_American_1983_HARN",DATUM["D_North_American_1983_HARN",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",1640416.666666667],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-120.8333333333333],PARAMETER["Standard_Parallel_1",47.5],PARAMETER["Standard_Parallel_2",48.73333333333333],PARAMETER["Latitude_Of_Origin",47.0],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2926]]</WKT><XOrigin>-117104300</XOrigin><YOrigin>-99539600</YOrigin><XYScale>3048.0060960121928</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>2926</WKID><LatestWKID>2926</LatestWKID></ProjectedCoordinateSystem>
20240123
14395000
20240123
14395000
Microsoft Windows 10 Version 10.0 (Build 19045) ; Esri ArcGIS 12.9.6.32739
Businesses_ShoppingCenters
business names
shopping
shopping center
Businesses within shopping centers in Federal Way
File Geodatabase Feature Class
dataset
EPSG
6.3(9.0.0)
0
Simple
FALSE
0
TRUE
FALSE
Businesses_ShoppingCenters
Feature Class
0
OBJECTID
OBJECTID
OID
4
0
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
Shape
Shape
Geometry
0
0
0
Feature geometry.
Esri
Coordinates defining the features.
Join_Count
Join_Count
Integer
4
0
0
TARGET_FID
TARGET_FID
Integer
4
0
0
Run_Date
Date Data Downloaded
Date
8
0
0
Home_Operated_Business
Home Operated Business
String
255
0
0
bus_ubi
Unified Business ID
String
255
0
0
bus_id
Business ID
String
255
0
0
busloc_id
Business Location ID
String
255
0
0
LE_name
Legal Entity Name
String
255
0
0
firm_name
Business/Firm Name
String
255
0
0
Mail_addr1
Mailing Street Address
String
255
0
0
Mail_addr2
Mailing Street Address Line 2
String
255
0
0
Mail_UnitType
Mailing Unit Type
String
255
0
0
Mail_Unit
Mailing Unit
String
255
0
0
Mail_City
Mailing City
String
255
0
0
Mail_State
Mailing State
String
255
0
0
Mail_Zip
Mailing Zip
String
255
0
0
Mail_Zip_4
Mailing Zip +4
String
255
0
0
Phys_addr1
Physical Street Address
String
255
0
0
Phys_addr2
Physical Street Address Line 2
String
255
0
0
Phys_UnitType
Physical Unit Type
String
255
0
0
Phys_Unit
Physical Unit
String
255
0
0
Phys_City
Physical City
String
255
0
0
Phys_State
Physical State
String
255
0
0
Phys_Zip
Physical Zip
String
255
0
0
Phys_Zip_4
Physical Zip +4
String
255
0
0
phone
Phone
String
255
0
0
Location_Email
Location Email
String
255
0
0
Agency_Id
Agency ID
String
255
0
0
ETP_ID
Endorsement Type ID
String
255
0
0
Endrs_Stat_Code
Endorsement Status Code
String
255
0
0
Endrs_Exp_Date
Endorsement Expiration Date
Date
8
0
0
Endrs_Stat_Date
Endorsement Start Date
Date
8
0
0
Endrs_1st_Issue_date
Endorsement First Issuance Date
Date
8
0
0
Cntct1_Last_Name
Contact 1 Last Name
String
255
0
0
Cntct_First_Name
Contact 1 First Name
String
255
0
0
Cntct1_Mid_Othr_Name
Contact 1 Middle/Other Name
String
255
0
0
Cntct1_Phone
Contact 1 Phone
String
255
0
0
Cntct2_Last_Name
Contact 2 Last Name
String
255
0
0
Cntct2_First_Name
Contact 2 First Name
String
255
0
0
Cntct2_Mid_Othr_Name
Contact 2 Middle/Other Name
String
255
0
0
Cntct2_Phone
Contact 2 Phone
String
255
0
0
HazardousFlammableMtrl
Hazardous or Flammable Material
String
255
0
0
Sqr_Footage
Business Floor Area (Sq Ft)
Integer
4
0
0
Endrs_Acct_Num
Endorsement Account Number
String
255
0
0
Employee_Cnt
Employee Count
Integer
4
0
0
Part_Time_Employee_Cnt
Part-Time Employee Count
Integer
4
0
0
RentalUnitCount
Rental Unit Count
Integer
4
0
0
Gross_Income
Gross Income
Double
8
0
0
City_Alarm_Company
Emergency City Alarm Company
String
255
0
0
City_Alarm_Contact
Emergency City Alarm Contact
String
255
0
0
City_Alarm_Cntct_Phone
Emergency City Alarm Contact Phone
String
255
0
0
City_Limits
In City Limits
String
255
0
0
ProdDescription
Products & Services
String
255
0
0
Latitude
Latitude
Double
8
0
0
Longitude
Longitude
Double
8
0
0
DOR_NAICS_Primary
Primary NAICS Code
String
255
0
0
DOR_NAICS_Secondary
Secondary NAICS Code
String
255
0
0
NAICS_Desc
NAICS Description
String
255
0
0
X
X
Double
8
0
0
Y
Y
Double
8
0
0
NAME
NAME
String
30
0
0
20240123
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD1Giii
tToEZcjtkdM03bgHhfyp9HWk4pjTJYUiKfIUYeo5pzxKy4AAPrjNPAA6AD6UtSb2TViJIApJO0/8
BxTwig5Ap+0+lG0/5NOwlyrYIhhrg/7CfzakqSNSUmwOcKP51HTYovVhVU9T9atU3y0/u0kxyjcr
UVY8pPSjyk9P1p3I9myvRVjyk9P1o8pPQ/nRcXs2V6Kn8lfejyV96Lh7NkFFT+SvqaVY1U55P1ou
Hs2JD9z8asRdJP8AdqOpI/uyf7tC3LkrRsR0UUUiwooooAKKKKACiiigTHTn/S5B6BarTff/AAqx
L/x+yn2Wq0xAfn0qupm/gGU1gxUhWwccHFIjkj5toOeMHt2pULFcsu0+mc07WMiO1jmihCzz+c/d
toFW4O9RVNB0NSy4bkw7/Q0lKvf6UlI26lSiiiqOcQsOmabDlVVXfcw6mn0q8sv1FKz3KXYsggjI
6U4dz6UlKPumkjZiUUUUDHQsRHcEEghlH6CnecSMOquPcUyIYhnPq6/yFJTuZpJ3uSeZH/zxH/fR
pfMj/wCeI/76NRUUXK5USb4/+eP/AI8aXfF/zy/8eNRUUXDlRJui/wCeX/jxo3Rf88z/AN9VHRRc
OVEm6L/nmf8AvqjdD/cb86joouHKSZh/uP8AnRmH+4/51HRRcOUkzD/df8xT1MflybQ3TvUFSJ/q
pPpQmTKOgzj3o+X1NJRSLsLx7/lR8vqfypKKAsL8vqfyo+X1P5UlFAWF49T+VKAMjnv6U2lX7w+t
AmhZv+PmQ+4H6VUn++TkjHpVpzm5n9n/AKCqdwfmcA4J4B/CqW5D+BEUMglTcC2BxhhipajhDLGF
dwzDqRUlPXqQ1Z6BU0P3T9ahqeH7p+tSyobko7/SkpV7/SkpGq3KlFFBzjjrVHORvJsdEKnLnA/L
P4dKdEuwoqoAoIxzTBOshlSNgZY+CrZGD2/D3qaPllzjPtT6DRapR900lKPumoN2JRRRQMcjAQSj
IzvH8hTNw9RSxYEcxwM+YBkj/ZFODkdl/IU3YzV9bDMj1FG5f7w/OpPMPov/AHyKTd/sp/3wKNCr
y7Dcg96Kdv8A9lPypCVPVF/KjQLy7CUUo2D/AJZp+VKSp6xJ+VGgXfYbRRtiznyU/WnZQdI1H50a
Bd9htFKdh/h/JjQBGP4T/wB9GiwXfYSpU/1Mn4Uz93/cP/fZoHlgEbXwevzmhCbb6DaKd+7H8L/9
9UhCH++PxH+FFh8z7CUUu1P70n6UYj9ZP0osHN5CUUu1P+ekv5LRhP78h+oFFg5vISlX76/UUuF7
OR9V/wDr0Kvzj96Ov9z/AOvRYTlpsI4xcT+7/wBBUTwq+TyCe4qWTeJX5Xlv7tRRmaVCytEPmZeU
J6Ej19qUpKOoLZaCLbqv8TH60vkr71IFn7mI/RcUES9kjP8AwIj+lT7SPcdvIj8lfU05ECDAJNLi
f/nlF/38P+FLiX+5GP8AgR/wo549wStshRwM0lNIuM/cjP1kP+FGJ/8Anmn/AH3/APWo54jSK1FF
FaHOQzt5MbykZwOgXJNSwAh0OAM9RioyHyfvYPuKkg3eaoO78aOZijJ81i5S/wAP40lL/D+NSdLE
ooooGOUYgc+sn/soptPU5tv+2hplNkx6kMjsHIBpvmv601juYk0lOxk5O4/zX9aPNf1FMoosHMyT
zW9qhnvTBtyNxY4AFO7U0pnqx/Kmkuo1J9SYTN6Cjzm9BUQBHUk0tKyFzMk85vQUvnH0FRUUWDnY
6W7WGJpJSqooySaIrtJolkiIZGGQQetVp03xMsuwoT3Hoc/0ogTy4wkSoEBPABHel1Lu+W99S55/
+zS+f/s/rUNFOxHOyX7QMgEcnoM1MDkVmtsdxJldy8D58VMrZUHI/A5pBGrcuUVRjmSUtsJO04NS
ZPqaS11RbnbdFqnR/wCsX6ioISTnJNTx/wCsX6ijqVe8bhL/AK1/94021GIT/vv/AOhGnSf61/8A
eNMt548AZ/iPb3NZ1QTSRZwF4PJ71DuMTO0jFlJ+VQOlBnj5+b9DVRmLsWPWskTKSSLf2mH0aj7T
B6t+X/1qp0U7GXtGaKBZMbDyemam+xz/AN0f99CqVscxlcdKnf7x/ClobLmdrMzaKKQjIwa6zEZK
zBCEOG4525FTREGQe1RbSDgZx/vU+FSXGSR+OappWCN+Yt0o6YpKKzOhi4NG1vQ/lSUUBqKgItRn
/no386Sn4xbJ/vMf1plNihsV5F2t9aZUk33h9KjpoyluFFFM81PN8rcN+M4oJH0UUgYEkAgkdR6U
ALTIpo54w8Th1PQg0+mJJG5IRlYr1x2oAfUcE8VzEssLh0bOCPyqSmpsA+QKB7CgB1FHSkVlcZVg
R7UALRRRQAEA9RTeVB6bR2Ap1FDQIYowSBgfhTxnvQSAMmiklYbZLD941Yj/ANYv1qtD94/SrUX+
tX60dTRfAI/+sf8A3j/OqFocj/to/wD6Eavv99vqaZawIEHy8lmPX3NZ1GKcXKJWPWqN4txMU8iV
4dh+b5c7un+fxrYa3TadoOe3NUnhVmywYHp1IrF6mbg47iRCM7pETDP947cE/WpKAMAD0pyIXOF/
OmQlfYmtejH3qy/3j+H8qYihECjtT3+8ak6oq1kU/J/2v0o8j/a/SpaK6rhyoh8j/apyRbWzmpKK
LhyoKKKKCgooooAUsfs0eBn5m/nTNzf3D+dPAxAn+8/86Shkw2K8x5zjt0rNvoPtsSrvmiwc/IO+
OD+FbDBcZIBx7VSKxnJRY9voQRih7WKjG0uZCo2eMN06kdaPKQSmTaN5GM1LbxxDICru74yePxqf
y0/uinczdPXQqnPY4poQgk/LuPU461b8pPSjyk9P1p8xPs2VW3BeCM/SoIY1ikfy0Cs2M8H3rRMK
EYx+tNFugOfm/FjUvcfIyBiccDP41FHGIs7I8buT81XvKT0/WoZLZ2uImRwI1zvXnJ9P607kukyN
z245HNMiVYl2oAFznrVwwqR1Ipq24AwWJqXvcvkdrELAkEcYPrSImxQqgBQMACrHkL/eajyB/eNX
zEezZDRU3kD+8aPIH96lcfIyrLGJUKOu5T2zT1G1QoGAOBU/kf7X6Unkf7X6UrK9w5ZWsLAOpqxD
/rk+tRImwEZzU0H+uT60+pdrRGN94/Wn2p3RRH1UH9KY33j9aLNgtpAWOP3Y5P0rKp0G/hJaRlVx
hhkUtFYFkRt4z/D+pqRVCqAOgpaUDPsPWgVktQAz/jSv/rG+ppGPGBwKV/8AWN/vGn0Er82pXopc
mjPsPyrqDUSilz7CjI9BQF2JRS5H90frRkf3R+dAXEopcj0/Wjj0P50BfyHH/Ux/if1plKDm3hPq
tJTe4obBRjJ6UUvRfrSG2G0+350bT7fnSUUBqLtPpRg+h/KkoxQGou0+lGD6UlGaA1FwfQ0mD6Gl
yfU0ZPqfzoDUSilyfWjJoDUSil3H1o3H1oDUSil3Gjcfb8qA1Eopc+w/KjPHQdfSgLsSpIP9en1p
mfYVJAf3y9Ka3Jk3ZkXWnRRJJbpG6hlCjg+1Np9qc28besYP6VjU6Dew+iilA7np/OsS27ABnk8D
1oJz7DsKCc/4UlMSXVgelOf/AFjfU02lb77fU0dA+0QUUyNxIuehHBHoafXUAUUUUAFFFFABRRRQ
Ao4toB6LSU848iE/7NN496bIi9BKU9BR8vqfypTtwPmP5UhtjaKXA9T+VGB60DuJRS496MD+8KLB
cSilwP7w/WjA/vD9aLBdCUUu33FG33H50WC6Eopdp9vzFGD7f99D/GiwXQlFLj3H/fQo2miwXQlF
LtNGxv7p/KiwXQlL/D+NGxv7pH1oPTFAr3EqSD/XLUdS2/8ArhQtwn8LIc8Zp9oMWsY9Ix/Ko2OI
yfQVZjCpEM+mFFZVOgS2ADjJ6dvegnJpCSTk0VkUl1YUUUAEnAGTSGKoy4HqaQnJJ9aXIAwPxNJm
mJau5UkBjbzV6fxD1HrUgIIBHQ0tQZFu2DxGx+X2PpXUBPTCzE/IARnkmjBfrwvp60/oOKAG/vP9
mj5/9mlZgoyxAHuaaJQfuhm+gpXsAvz/AOzR8/8As0Zk7R/mcUvlznsv5GlzxEClzbwcL9yk+f0F
TPaTIIlD5AjHATp+tR/Zrgn73H+5/wDXoc1ciElbcaC/cCgl+wH50/7Lcf3z/wB8f/Xpfs0/94/9
8j/GlzormXcjBfuB+dGX/uj86f8AZp/7x/75FO+zS46t+Qo50HMu5FlsdB+dGX/uj86l+zS+rfkK
UW7995/KjnQc0e5Dlv7v60Zf+6Pzqb7K/rJ+lH2V/WT9KOdBzR7kOX/uD86Mv/dH51L9kkz96X9P
8KPskn9+T9P8KOdBzLuRZf8AuD86Mv8A3R+dSfY5D/HKP++f8KPscn/PSX/x3/CjnQcy7ke5/wC4
Pzoy39z9aebKQ/8ALWYf98/4UfYpP+es3/jv+FHtEHMu5Huf+4Pzpct/c/Wn/YpP+es3/jv+FAsp
P+es3/jv+FHtEHNHuRgt/c/Wl3N/cP51KLVx/FIfrikNrP2fH1X/AOvRzoOaPcj3N/cNSQuRJkI3
Q+lILW47uP8Avj/69TRW0u5vnx8p52//AF6amrkykuXcpzysLeQ7T9w+npVgXEhAzG546kCo3srh
0ZfMADAj7n/16mWCcDBIP/Acf1rOcr7DvATzm/55H/vlaTzm/wCeTf8AfIpTFddlQ/WlWO5/iRPw
NZ6heAnmt/zyb8hSecxGPLcD8KVo7r+FE/EmlEVz3RPwJo1C8O40OxOFicn8KsKUQYaNs++P8aVV
kjGAiknvml+zRtzIod+7EVSVjCpUcnZbFBmwcDlvSmtGGU+ZzkfgKVFd+Ik+rNViOwz80rbj79vw
6Vq5o6HNLcpxSsQUClyvRh0P41Mscznsv0GTV9YI1/hyfepOFHYVLk2ZOsuhSis9vO0bu7N1NWFt
1HUk/pU4Vm6Kf5VBJd20K5luoU9t2T+QqeUzdWTJFRV+6oFOqZbbcobzTgjI2jFP+yxgfMzH6tj+
VVymVyGTqv8AuCmVaZIGILEZAx9/FJ5Vv6j/AL7P+NFguVqKsCO29V/77/8Ar0bLUd0/FqLAV6Ks
7LY91/BqTy7b+8P++z/jRYCvRVnybc9//Hz/AI0n2a3z/F/38b/GiwXK9FTyQRpE7IrMwBIUOeaz
hduwX/iX3oJ68DA6f5/CiwXLVFVWunWXy/sN23JG4Yxx/jRJeJHu3W97hT1VAc8ZosFy1RUkEKzQ
rJumXOeGAB/lUn2Qf89H/T/CiwXK9FT/AGQ/89T+Qo+yn/np/wCO0WYXIKKm+yt/z1H/AHz/APXo
+yv/AM9F/wC+P/r0rMLkNFTfZX/vr+VJ9lk/vr+VFmFyKnJ94/7pqT7NJ/eWhbeQFsleVIGDTSYE
NFS/Zpf9j8z/AIVW8+LBIuIMA4+/+FKzC5JRUbTxIxDSxDHXLgen+I/OnhlY4DxnjP3x0oswFopQ
kjcqoYeoYU7ypf8AnmfzFFmAyineVJ/cNJsf/nm35UWGNVQowoxS55x1PoKfHC8nP3V9T1P0qcmK
3GB1PYck00hNkBhkEbOwICgnavLH2qlHcXM0sbRW6W9vnLPPy7D2Harkt2cfMwjX681WMrH7keP9
p+P06/youkJu25Ammx+YJZ5p7qRfutI5VR+AqwsMEJJWOGMk5yFGSfqab8x+/Ix9lG0f40AIOka/
jzUOou5DqwXUkNyp4EjtjspJpvmA52xO31GP50eY30pN7epqfaIj6xEcXbH/AB7ufxX/ABqtPI/m
f8e79PVf8am3N6mo2OWOaXPfQ3w1ZTqWSIt7f88WH4j/ABpouYCAS6jNSt90/Sq1uc20RPdB/Krh
HmPQJRcQno607zYv760ykIB6gGr9l5gSebGf41/OjemPvr+dReWn9xfyoKLg4Vfyo9l5gTvIm9vn
HX1pPMQ/8tB/31UTRpuPyL19KTy0/uL+VDp+YktCcOOzfrTg7dmP51WKKf4RTfIj/uCl7N9wsuxb
3v8A33/76NKJZB/y0f8A76NVBEg6LQYYz1Wj2b7hZdi550v/AD1k/wC+jTkml3qPNfqOrVnELDPE
VBAOQcAntVlbiISLlscjqKlqSdhOMbbFy4nlWdwsjAA9BUf2iYf8tW/OoZ7qA3EhEqfe9aZ9oh/5
6L+dJ3uKMI8q0LX2qf8A56n8hR9ruP8Ansf++R/hVT7TD/z1X86X7RCf+Wi/nRdj5Idi39suP+en
6Cj7Zcf89P8Ax0VV82P++v50vmJ/eX86OZh7OHYtC9uB/Ep/4DVYxwF95tLYtnOTHRvX+8PzpN6/
3h+dHMw9lDsJLDBOcyWdq2fWM/4+woeC2k+/aQn5dvAI4/P3p29f7w/OjcPUUczF7KHYmtZls4vK
t4ERM5wCam/tKX/nin/fR/wqpRRzsPYw7F0ak3eEf99//Wpf7SP/ADxH/ff/ANaqNFHOxexgaM14
APlO0ep6n6CqRkkc5HyD35Y/4UgABzyW7setLUyqdjyZ1+kRAApyOvqetLRSMwUEsQAO5rJts53J
y3FqMTxEkCRSQcHnoaT5pfVU/U/4U5Yo0Hyoo/CgQvmJ/eH50eYn99fzpdi/3R+VGxf7o/KgBPMT
+8Pzphddx+YfnT9if3V/Ko9i5Pyjr6VUdztwC/ev0EaRApJYYx61DHhY1XI4AFOukUWkxCLkI3b2
oCKeMD8q6aXU9ZhuHqKMj1FLheyqPwpML/dX8q1FqGR6ijI9RRhf7q/lRtX+4v5UBqKxG480mR6i
lIU/wJ+VJtT/AJ5p+VAlcXI9aTI9aNqHqi/lRtT/AJ5r+VA7sXI9aMj1pDGhGQg/Kk2L/dH5UAmB
wXU56U9CN6896i2p5oG1fuk9KljRPMX5V6+lCB7Cykea/Pc03I9aWRI/Mb5B19Kbsj/ufypsSegu
R60mR60bI/7v6CjZH/cH5Uh3AhT1ANN8uL+4n5CnbI/QflR5cf8AdH/fIosFxuyMfwr+VHlxn+BP
yFO8uP0H/fNHlx+g/KiwXG+XGP4E/Kgxof4RTvLj9B+VHlp/s/lRYLjPJj9P1NKIkHb9TTvKT/Z/
I/4UeWn+zRYV0MMUZ7fqaUSyx/Ls8zHRs4/OneUg7LSbF9KlwT3Gn2LlFFFcJ84MaQKdoG5vQUgj
JO5zk9h2FFFAySiiigQUUUUAFR9z9aKKqO535f8AxH6DJseRJnptOfypo7/Q0UV00j1JbCUUUVqM
KKKKACiiigAooooAUfdP4UlFFAkRkf6QD/sn+YqeL/Wr9aKKED2Y1vvn60lFFALYKKKKBhRRRQAU
UUUAFFFFABRRRQAUUUUAf//Z