20230515
11253100
1.0
FGDC CSDGM Metadata
FALSE
a_count_overlap
002
file://\\LAPTOP-0T2RH73M\C$\projects\PC224_SBC\data\2023_10_cpuc_data_interpret\FFA_Project_Applicant_Split\FFA_Project_Applicant_Split.gdb
Local Area Network
0.000
Projected
GCS_WGS_1984
Linear Unit: Meter (1.000000)
WGS_1984_Web_Mercator_Auxiliary_Sphere
<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["WGS_1984_Web_Mercator_Auxiliary_Sphere",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Mercator_Auxiliary_Sphere"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",0.0],PARAMETER["Auxiliary_Sphere_Type",0.0],UNIT["Meter",1.0],AUTHORITY["EPSG",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>
Merge D:\PROJECTS\CPUC_2021\LAYERS\WEB\CPUC_WEB_2021.gdb\Political_Boundaries\Census_Blocks_2020 D:\PROJECTS\CPUC_2021\LAYERS\WEB\CPUC_WEB_2021.gdb\Political_Boundaries\Census_Blocks_2020_Merge "GEOID20 "Full Census Block Code" true true false 15 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2021\LAYERS\WEB\CPUC_WEB_2021.gdb\Political_Boundaries\Census_Blocks_2020,GEOID20,-1,-1;NAMELSAD20 "Name" true true false 20 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2021\LAYERS\WEB\CPUC_WEB_2021.gdb\Political_Boundaries\Census_Blocks_2020,NAMELSAD20,-1,-1;CNTYNAME20 "COUNTY" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2021\LAYERS\WEB\CPUC_WEB_2021.gdb\Political_Boundaries\Census_Blocks_2020,CNTYNAME20,-1,-1;PLNAME20 "PLACE" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2021\LAYERS\WEB\CPUC_WEB_2021.gdb\Political_Boundaries\Census_Blocks_2020,PLNAME20,-1,-1;ALAND20 "Land Area (Sqare Meters)" true true false 4 Long 0 0 ,First,#,D:\PROJECTS\CPUC_2021\LAYERS\WEB\CPUC_WEB_2021.gdb\Political_Boundaries\Census_Blocks_2020,ALAND20,-1,-1;AWATER20 "Water Area (Sqare Meters)" true true false 4 Long 0 0 ,First,#,D:\PROJECTS\CPUC_2021\LAYERS\WEB\CPUC_WEB_2021.gdb\Political_Boundaries\Census_Blocks_2020,AWATER20,-1,-1;SQMI_GIS "Area (Square Miles)" true true false 8 Double 0 0 ,First,#,D:\PROJECTS\CPUC_2021\LAYERS\WEB\CPUC_WEB_2021.gdb\Political_Boundaries\Census_Blocks_2020,SQMI_GIS,-1,-1;POP_2020 "Population 2020" true true false 8 Double 0 0 ,First,#,D:\PROJECTS\CPUC_2021\LAYERS\WEB\CPUC_WEB_2021.gdb\Political_Boundaries\Census_Blocks_2020,POP_2020,-1,-1;HH_2020 "Households 2020" true true false 8 Double 0 0 ,First,#,D:\PROJECTS\CPUC_2021\LAYERS\WEB\CPUC_WEB_2021.gdb\Political_Boundaries\Census_Blocks_2020,HH_2020,-1,-1;HU_2020 "Housing Units 2020" true true false 8 Double 0 0 ,First,#,D:\PROJECTS\CPUC_2021\LAYERS\WEB\CPUC_WEB_2021.gdb\Political_Boundaries\Census_Blocks_2020,HU_2020,-1,-1;STATUS "Fixed Broadband Served Status" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2021\LAYERS\WEB\CPUC_WEB_2021.gdb\Political_Boundaries\Census_Blocks_2020,STATUS,-1,-1;ELIGIBLE "CASF Eligibility" true true false 25 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2021\LAYERS\WEB\CPUC_WEB_2021.gdb\Political_Boundaries\Census_Blocks_2020,ELIGIBLE,-1,-1;POP_DENS "Population per Square Mile" true true false 8 Double 0 0 ,First,#,D:\PROJECTS\CPUC_2021\LAYERS\WEB\CPUC_WEB_2021.gdb\Political_Boundaries\Census_Blocks_2020,POP_DENS,-1,-1;HH_DENS "Households per Square Mile" true true false 8 Double 0 0 ,First,#,D:\PROJECTS\CPUC_2021\LAYERS\WEB\CPUC_WEB_2021.gdb\Political_Boundaries\Census_Blocks_2020,HH_DENS,-1,-1;HU_DENS "Housing Units per Square Mile" true true false 8 Double 0 0 ,First,#,D:\PROJECTS\CPUC_2021\LAYERS\WEB\CPUC_WEB_2021.gdb\Political_Boundaries\Census_Blocks_2020,HU_DENS,-1,-1;HU_RANGE "Housing Unit Range" true true false 25 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2021\LAYERS\WEB\CPUC_WEB_2021.gdb\Political_Boundaries\Census_Blocks_2020,HU_RANGE,-1,-1"
Append D:\PROJECTS\CPUC_2021\RESOURCES\Census_2020_GIC_Master.gdb\Census_2020_Blocks_GIC_Master_NoCoast D:\PROJECTS\CPUC_2021\LAYERS\WEB\CPUC_WEB_2021.gdb\Political_Boundaries\Census_Blocks_2020_Merge NO_TEST "GEOID20 "Full Census Block Code" true true false 15 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2021\RESOURCES\Census_2020_GIC_Master.gdb\Census_2020_Blocks_GIC_Master_NoCoast,GEOID20,-1,-1;NAMELSAD20 "Name" true true false 20 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2021\RESOURCES\Census_2020_GIC_Master.gdb\Census_2020_Blocks_GIC_Master_NoCoast,NAME20,-1,-1;CNTYNAME20 "COUNTY" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2021\RESOURCES\Census_2020_GIC_Master.gdb\Census_2020_Blocks_GIC_Master_NoCoast,CNTYNAME20,-1,-1;PLNAME20 "PLACE" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2021\RESOURCES\Census_2020_GIC_Master.gdb\Census_2020_Blocks_GIC_Master_NoCoast,PLNAME20,-1,-1;ALAND20 "Land Area (Sqare Meters)" true true false 4 Long 0 0 ,First,#,D:\PROJECTS\CPUC_2021\RESOURCES\Census_2020_GIC_Master.gdb\Census_2020_Blocks_GIC_Master_NoCoast,ALAND20,-1,-1;AWATER20 "Water Area (Sqare Meters)" true true false 4 Long 0 0 ,First,#,D:\PROJECTS\CPUC_2021\RESOURCES\Census_2020_GIC_Master.gdb\Census_2020_Blocks_GIC_Master_NoCoast,AWATER20,-1,-1;SQMI_GIS "Area (Square Miles)" true true false 8 Double 0 0 ,First,#;POP_2020 "Population 2020" true true false 8 Double 0 0 ,First,#,D:\PROJECTS\CPUC_2021\RESOURCES\Census_2020_GIC_Master.gdb\Census_2020_Blocks_GIC_Master_NoCoast,POP2020,-1,-1;HH_2020 "Households 2020" true true false 8 Double 0 0 ,First,#,D:\PROJECTS\CPUC_2021\RESOURCES\Census_2020_GIC_Master.gdb\Census_2020_Blocks_GIC_Master_NoCoast,HH2020,-1,-1;HU_2020 "Housing Units 2020" true true false 8 Double 0 0 ,First,#,D:\PROJECTS\CPUC_2021\RESOURCES\Census_2020_GIC_Master.gdb\Census_2020_Blocks_GIC_Master_NoCoast,HH2020,-1,-1;STATUS "Fixed Broadband Served Status" true true false 50 Text 0 0 ,First,#;ELIGIBLE "CASF Eligibility" true true false 25 Text 0 0 ,First,#;POP_DENS "Population per Square Mile" true true false 8 Double 0 0 ,First,#;HH_DENS "Households per Square Mile" true true false 8 Double 0 0 ,First,#;HU_DENS "Housing Units per Square Mile" true true false 8 Double 0 0 ,First,#;HU_RANGE "Housing Unit Range" true true false 25 Text 0 0 ,First,#;Shape_Length "Shape_Length" false true true 8 Double 0 0 ,First,#,D:\PROJECTS\CPUC_2021\RESOURCES\Census_2020_GIC_Master.gdb\Census_2020_Blocks_GIC_Master_NoCoast,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0 ,First,#,D:\PROJECTS\CPUC_2021\RESOURCES\Census_2020_GIC_Master.gdb\Census_2020_Blocks_GIC_Master_NoCoast,Shape_Area,-1,-1" #
CalculateField Census_Blocks_2020 POP_DENS 0 VB #
CalculateField Census_Blocks_2020 POP_DENS round( !POP_2020! / !SQMI_GIS!,1) PYTHON_9.3 #
CalculateField Census_Blocks_2020 HH_DENS round( !HH_2020! / !SQMI_GIS!,1) PYTHON_9.3 #
CalculateField Census_Blocks_2020 HU_DENS round( !HU_2020! / !SQMI_GIS!,1) PYTHON_9.3 #
CalculateField Census_Blocks_2020 HU_RANGE hurange( !HU_DENS!) PYTHON_9.3 "def hurange(x):
if x ==0:
return "0"
elif x > 0 and x < 5:
return "1 - 5"
elif x >=5 and x < 10:
return "5 - 10"
elif x >=10 and x < 50:
return "10 - 50"
elif x >=50 and x < 150:
return "50 - 150"
elif x>= 150 and x < 300:
return "150 - 300"
elif x>=300:
return "300 or greater"
"
CalculateField Census_Blocks_2020 PLNAME20 "" VB #
CalculateField Census_Blocks_2020 ELIGIBLE "Ineligible" VB #
CalculateField Census_Blocks_2020 ELIGIBLE "Eligible" VB #
CalculateField Census_Blocks_2020 ELIGIBLE "Unpopulated" VB #
JoinField Census_Blocks_2020 GEOID20 Downsteam_Deployment_Consumer_Fixed GEOID20 MaxAdDn
CalculateField Census_Blocks_2020 STATUS "Unserved < 25 Mbps Down / 3 Mbps Up" VB #
CalculateField Census_Blocks_2020 STATUS "Priority Unserved < 10 Mbps Down / 1 Mbps Up" VB #
CalculateField "Census Blocks" ELIGIBLE "Priority Eligible" "Python 3" # Text
CalculateField Census_Blocks_2020 HU_DENS round(!HU_2020! / !SQMI_GIS!,1) "Python 3" # Text
CalculateField "Census Blocks" HU_RANGE hurange( !HU_DENS!) "Python 3" "def hurange(x):
if x ==0:
return "0"
elif x > 0 and x < 5:
return "1 - 5"
elif x >=5 and x < 10:
return "5 - 10"
elif x >=10 and x < 50:
return "10 - 50"
elif x >=50 and x < 150:
return "50 - 150"
elif x>= 150 and x < 300:
return "150 - 300"
elif x>=300:
return "300 or greater"" Text
CalculateField "Census Blocks 2020 - Excluded Areas " ELIGIBLE ""Eligible" or "Priority Eligible"" "Python 3" # Text NO_ENFORCE_DOMAINS
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>CENSUS</FeatureDataset><WorkspaceConnectionString>DATABASE=D:\FFA\CPUC_WEB_2021.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Census_Blocks_2020</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>ACAT_ALL</field_name><field_type>SHORT</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>ACAT_253</field_name><field_type>SHORT</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
ExportFeatures Census_Blocks_2020 C:\Users\jykst\Documents\ArcGIS\Projects\FFA_FCC\FFA_FCC.gdb\Census_Blocks_2020_ExportFeature # NOT_USE_ALIAS "GEOID20 "Full Census Block Code" true true false 15 Text 0 0,First,#,Census_Blocks_2020,Census_Blocks_2020.GEOID20,0,15;NAMELSAD20 "Name" true true false 20 Text 0 0,First,#,Census_Blocks_2020,Census_Blocks_2020.NAMELSAD20,0,20;CNTYNAME20 "COUNTY" true true false 50 Text 0 0,First,#,Census_Blocks_2020,Census_Blocks_2020.CNTYNAME20,0,50;PLNAME20 "PLACE" true true false 50 Text 0 0,First,#,Census_Blocks_2020,Census_Blocks_2020.PLNAME20,0,50;ALAND20 "Land Area (Sqare Meters)" true true false 4 Long 0 0,First,#,Census_Blocks_2020,Census_Blocks_2020.ALAND20,-1,-1;AWATER20 "Water Area (Sqare Meters)" true true false 4 Long 0 0,First,#,Census_Blocks_2020,Census_Blocks_2020.AWATER20,-1,-1;SQMI_GIS "Area (Square Miles)" true true false 8 Double 0 0,First,#,Census_Blocks_2020,Census_Blocks_2020.SQMI_GIS,-1,-1;POP_2020 "Population 2020" true true false 8 Double 0 0,First,#,Census_Blocks_2020,Census_Blocks_2020.POP_2020,-1,-1;HH_2020 "Households 2020" true true false 8 Double 0 0,First,#,Census_Blocks_2020,Census_Blocks_2020.HH_2020,-1,-1;HU_2020 "Housing Units 2020" true true false 8 Double 0 0,First,#,Census_Blocks_2020,Census_Blocks_2020.HU_2020,-1,-1;STATUS "Fixed Broadband Served Status" true true false 50 Text 0 0,First,#,Census_Blocks_2020,Census_Blocks_2020.STATUS,0,50;ELIGIBLE "CASF Eligibility" true true false 25 Text 0 0,First,#,Census_Blocks_2020,Census_Blocks_2020.ELIGIBLE,0,25;POP_DENS "Population per Square Mile" true true false 8 Double 0 0,First,#,Census_Blocks_2020,Census_Blocks_2020.POP_DENS,-1,-1;HH_DENS "Households per Square Mile" true true false 8 Double 0 0,First,#,Census_Blocks_2020,Census_Blocks_2020.HH_DENS,-1,-1;HU_DENS "Housing Units per Square Mile" true true false 8 Double 0 0,First,#,Census_Blocks_2020,Census_Blocks_2020.HU_DENS,-1,-1;HU_RANGE "Housing Unit Range" true true false 25 Text 0 0,First,#,Census_Blocks_2020,Census_Blocks_2020.HU_RANGE,0,25;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,Census_Blocks_2020,Census_Blocks_2020.Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,Census_Blocks_2020,Census_Blocks_2020.Shape_Area,-1,-1;MaxAdDn "Maximum Advertised Downstream Speed (Mbps)" true true false 8 Double 0 0,First,#,Census_Blocks_2020,Census_Blocks_2020.MaxAdDn,-1,-1;ACAT_ALL "Consumer Connections Exceeding 200 Kbps in at least one Direction" true true false 2 Short 0 0,First,#,Census_Blocks_2020,Census_Blocks_2020.ACAT_ALL,-1,-1;ACAT_253 "Consumer Connections at Served Speeds (25/3)" true true false 2 Short 0 0,First,#,Census_Blocks_2020,Census_Blocks_2020.ACAT_253,-1,-1;OBJECTID "OBJECTID" false true false 4 Long 0 9,First,#,Census_Blocks_2020,Served_Status_Consumer_Fixed.OBJECTID,-1,-1;GEOID20 "GEOID20" true true false 15 Text 0 0,First,#,Census_Blocks_2020,Served_Status_Consumer_Fixed.GEOID20,0,15;fStat "fStat" true true false 4 Long 0 0,First,#,Census_Blocks_2020,Served_Status_Consumer_Fixed.fStat,-1,-1;Status "Status" true true false 255 Text 0 0,First,#,Census_Blocks_2020,Served_Status_Consumer_Fixed.Status,0,255;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,Census_Blocks_2020,Served_Status_Consumer_Fixed.Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,Census_Blocks_2020,Served_Status_Consumer_Fixed.Shape_Area,-1,-1" #
CalculateField "Census_Blocks_2020_ExportFeature Null_Geoid20" STATUS "Priority Unserved < 10 Mbps Down / 1 Mbps Up" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "Census_Blocks_2020_ExportFeature Null_Geoid20" STATUS "Priority Unserved" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField "Census_Blocks_2020_ExportFeature Null_Geoid20" ELIGIBLE "Unpopulated" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Census_Blocks_2020_ExportFeature STATUS !Status_1! "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Census_Blocks_2020_ExportFeature STATUS "Priority Unserved < 10 Mbps Down / 1 Mbps Up" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Census_Blocks_2020_ExportFeature Status_1 "Priority Unserved < 10 Mbps Down / 1 Mbps Up" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Census_Blocks_2020_ExportFeature ELIGIBLE "Ineligible" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Census_Blocks_2020_ExportFeature ELIGIBLE "Eligible" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Census_Blocks_2020_ExportFeature STATUS "Priority Unserved <= 10 Mbps Down / 1 Mbps Up" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Census_Blocks_2020_ExportFeature ELIGIBLE "Priority Eligible" "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=C:\Users\jykst\Documents\ArcGIS\Projects\FFA_FCC\FFA_FCC.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Census_Blocks_2020_ExportFeature</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>OBJECTID</field_name><field_name>GEOID20_1</field_name><field_name>fStat</field_name><field_name>Status_1</field_name><field_name>Shape_Length_1</field_name><field_name>Shape_Area_1</field_name></DeleteField></workflow></operationSequence>
CopyFeatures Census_Blocks_2020_ExportFeature D:\Census_Blocks_2020.gdb\Census_Blocks_2020_ExportFeature # # # #
FeatureClassToFeatureClass Census_Blocks_2020 Y:\CPUC_WEB\DATA\CPUC_WEB_2022.gdb\CENSUS Census_Blocks_2020 # "GEOID20 "Full Census Block Code" true true false 15 Text 0 0,First,#,Census_Blocks_2020,GEOID20,0,15;NAMELSAD20 "Name" true true false 20 Text 0 0,First,#,Census_Blocks_2020,NAMELSAD20,0,20;CNTYNAME20 "COUNTY" true true false 50 Text 0 0,First,#,Census_Blocks_2020,CNTYNAME20,0,50;PLNAME20 "PLACE" true true false 50 Text 0 0,First,#,Census_Blocks_2020,PLNAME20,0,50;ALAND20 "Land Area (Sqare Meters)" true true false 4 Long 0 0,First,#,Census_Blocks_2020,ALAND20,-1,-1;AWATER20 "Water Area (Sqare Meters)" true true false 4 Long 0 0,First,#,Census_Blocks_2020,AWATER20,-1,-1;SQMI_GIS "Area (Square Miles)" true true false 8 Double 0 0,First,#,Census_Blocks_2020,SQMI_GIS,-1,-1;POP_2020 "Population 2020" true true false 8 Double 0 0,First,#,Census_Blocks_2020,POP_2020,-1,-1;HH_2020 "Households 2020" true true false 8 Double 0 0,First,#,Census_Blocks_2020,HH_2020,-1,-1;HU_2020 "Housing Units 2020" true true false 8 Double 0 0,First,#,Census_Blocks_2020,HU_2020,-1,-1;STATUS "Fixed Broadband Served Status" true true false 50 Text 0 0,First,#,Census_Blocks_2020,STATUS,0,50;ELIGIBLE "CASF Eligibility" true true false 25 Text 0 0,First,#,Census_Blocks_2020,ELIGIBLE,0,25;POP_DENS "Population per Square Mile" true true false 8 Double 0 0,First,#,Census_Blocks_2020,POP_DENS,-1,-1;HH_DENS "Households per Square Mile" true true false 8 Double 0 0,First,#,Census_Blocks_2020,HH_DENS,-1,-1;HU_DENS "Housing Units per Square Mile" true true false 8 Double 0 0,First,#,Census_Blocks_2020,HU_DENS,-1,-1;HU_RANGE "Housing Unit Range" true true false 25 Text 0 0,First,#,Census_Blocks_2020,HU_RANGE,0,25;MaxAdDn "Maximum Advertised Downstream Speed (Mbps)" true true false 8 Double 0 0,First,#,Census_Blocks_2020,MaxAdDn,-1,-1;ACAT_ALL "Consumer Connections Exceeding 200 Kbps in at least one Direction" true true false 2 Short 0 0,First,#,Census_Blocks_2020,ACAT_ALL,-1,-1;ACAT_253 "Consumer Connections at Served Speeds (25/3)" true true false 2 Short 0 0,First,#,Census_Blocks_2020,ACAT_253,-1,-1;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,Census_Blocks_2020,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,Census_Blocks_2020,Shape_Area,-1,-1" #
AssignDomainToField E:\Projects\2022\CPUC_WEB_2022.gdb\CENSUS\Census_Blocks_2020 ACAT_ALL "Adoption Rate" #
AssignDomainToField E:\Projects\2022\CPUC_WEB_2022.gdb\CENSUS\Census_Blocks_2020 ACAT_253 "Adoption Rate" #
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>CENSUS</FeatureDataset><WorkspaceConnectionString>DATABASE=E:\Projects\2022\CPUC_WEB_2022.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Census_Blocks_2020</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AddField><field_name>CASF_EL_LOC</field_name><field_type>LONG</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>CASF_PE_LOC</field_name><field_type>LONG</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateField Census_Blocks_2020 STATUS "Priority Unserved <= 10 Mbps Down / 1 Mbps Up" "Python 3" # Text NO_ENFORCE_DOMAINS
CopyMultiple "D:\Hayley\CPUC_WEB_2022.gdb\CPUC_WEB_2022.gdb\CENSUS\Census_Blocks_2020 FeatureClass" D:\Hayley\Census_Blocks2020.gdb Census_Blocks_2020 "Census_Blocks_2020 FeatureClass Census_Blocks_2020 #"
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=D:\Census_Blocks2020.gdb (1)\Census_Blocks2020.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Census_Blocks_2020</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Geoid_num</field_name><field_type>DOUBLE</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateField Census_Blocks_2020 Geoid_num !GEOID20! "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Census_Blocks_2020 GEOID20 !GEOID20!.lstrip("0") "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Census_Blocks_2020 GEOID20 "0"+str(!GEOID20!) "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=D:\Census_Blocks2020.gdb (1)\Census_Blocks2020.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Census_Blocks_2020</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>Geoid_num</field_name></DeleteField></workflow></operationSequence>
ExportFeatures Census_Blocks_2020 D:\NTIA_Master_Cleaned.gdb\Census_Block_2020 # NOT_USE_ALIAS "GEOID20 "Full Census Block Code" true true false 15 Text 0 0,First,#,Census_Blocks_2020,GEOID20,0,15;NAMELSAD20 "Name" true true false 20 Text 0 0,First,#,Census_Blocks_2020,NAMELSAD20,0,20;CNTYNAME20 "COUNTY" true true false 50 Text 0 0,First,#,Census_Blocks_2020,CNTYNAME20,0,50;PLNAME20 "PLACE" true true false 50 Text 0 0,First,#,Census_Blocks_2020,PLNAME20,0,50;ALAND20 "Land Area (Sqare Meters)" true true false 4 Long 0 0,First,#,Census_Blocks_2020,ALAND20,-1,-1;AWATER20 "Water Area (Sqare Meters)" true true false 4 Long 0 0,First,#,Census_Blocks_2020,AWATER20,-1,-1;SQMI_GIS "Area (Square Miles)" true true false 8 Double 0 0,First,#,Census_Blocks_2020,SQMI_GIS,-1,-1;POP_2020 "Population 2020" true true false 8 Double 0 0,First,#,Census_Blocks_2020,POP_2020,-1,-1;HH_2020 "Households 2020" true true false 8 Double 0 0,First,#,Census_Blocks_2020,HH_2020,-1,-1;HU_2020 "Housing Units 2020" true true false 8 Double 0 0,First,#,Census_Blocks_2020,HU_2020,-1,-1;STATUS "Fixed Broadband Served Status" true true false 50 Text 0 0,First,#,Census_Blocks_2020,STATUS,0,50;ELIGIBLE "CASF Eligibility" true true false 25 Text 0 0,First,#,Census_Blocks_2020,ELIGIBLE,0,25;POP_DENS "Population per Square Mile" true true false 8 Double 0 0,First,#,Census_Blocks_2020,POP_DENS,-1,-1;HH_DENS "Households per Square Mile" true true false 8 Double 0 0,First,#,Census_Blocks_2020,HH_DENS,-1,-1;HU_DENS "Housing Units per Square Mile" true true false 8 Double 0 0,First,#,Census_Blocks_2020,HU_DENS,-1,-1;HU_RANGE "Housing Unit Range" true true false 25 Text 0 0,First,#,Census_Blocks_2020,HU_RANGE,0,25;MaxAdDn "Maximum Advertised Downstream Speed (Mbps)" true true false 8 Double 0 0,First,#,Census_Blocks_2020,MaxAdDn,-1,-1;ACAT_ALL "Consumer Connections Exceeding 200 Kbps in at least one Direction" true true false 2 Short 0 0,First,#,Census_Blocks_2020,ACAT_ALL,-1,-1;ACAT_253 "Consumer Connections at Served Speeds (25/3)" true true false 2 Short 0 0,First,#,Census_Blocks_2020,ACAT_253,-1,-1;CASF_EL_LOC "CASF_EL_LOC" true true false 4 Long 0 0,First,#,Census_Blocks_2020,CASF_EL_LOC,-1,-1;CASF_PE_LOC "CASF_PE_LOC" true true false 4 Long 0 0,First,#,Census_Blocks_2020,CASF_PE_LOC,-1,-1;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,Census_Blocks_2020,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,Census_Blocks_2020,Shape_Area,-1,-1" #
ExportFeatures Census_Block_2020 C:\Users\jykst\Documents\ArcGIS\Projects\FFA_Vitro\FFA_Vitro.gdb\Census_Block_FinalVersion # NOT_USE_ALIAS "GEOID20 "Full Census Block Code" true true false 15 Text 0 0,First,#,Census_Block_2020,Census_Block_2020.GEOID20,0,15;NAMELSAD20 "Name" true true false 20 Text 0 0,First,#,Census_Block_2020,Census_Block_2020.NAMELSAD20,0,20;CNTYNAME20 "COUNTY" true true false 50 Text 0 0,First,#,Census_Block_2020,Census_Block_2020.CNTYNAME20,0,50;PLNAME20 "PLACE" true true false 50 Text 0 0,First,#,Census_Block_2020,Census_Block_2020.PLNAME20,0,50;ALAND20 "Land Area (Sqare Meters)" true true false 4 Long 0 0,First,#,Census_Block_2020,Census_Block_2020.ALAND20,-1,-1;AWATER20 "Water Area (Sqare Meters)" true true false 4 Long 0 0,First,#,Census_Block_2020,Census_Block_2020.AWATER20,-1,-1;SQMI_GIS "Area (Square Miles)" true true false 8 Double 0 0,First,#,Census_Block_2020,Census_Block_2020.SQMI_GIS,-1,-1;POP_2020 "Population 2020" true true false 8 Double 0 0,First,#,Census_Block_2020,Census_Block_2020.POP_2020,-1,-1;HH_2020 "Households 2020" true true false 8 Double 0 0,First,#,Census_Block_2020,Census_Block_2020.HH_2020,-1,-1;HU_2020 "Housing Units 2020" true true false 8 Double 0 0,First,#,Census_Block_2020,Census_Block_2020.HU_2020,-1,-1;STATUS "Fixed Broadband Served Status" true true false 50 Text 0 0,First,#,Census_Block_2020,Census_Block_2020.STATUS,0,50;ELIGIBLE "CASF Eligibility" true true false 25 Text 0 0,First,#,Census_Block_2020,Census_Block_2020.ELIGIBLE,0,25;POP_DENS "Population per Square Mile" true true false 8 Double 0 0,First,#,Census_Block_2020,Census_Block_2020.POP_DENS,-1,-1;HH_DENS "Households per Square Mile" true true false 8 Double 0 0,First,#,Census_Block_2020,Census_Block_2020.HH_DENS,-1,-1;HU_DENS "Housing Units per Square Mile" true true false 8 Double 0 0,First,#,Census_Block_2020,Census_Block_2020.HU_DENS,-1,-1;HU_RANGE "Housing Unit Range" true true false 25 Text 0 0,First,#,Census_Block_2020,Census_Block_2020.HU_RANGE,0,25;MaxAdDn "Maximum Advertised Downstream Speed (Mbps)" true true false 8 Double 0 0,First,#,Census_Block_2020,Census_Block_2020.MaxAdDn,-1,-1;ACAT_ALL "Consumer Connections Exceeding 200 Kbps in at least one Direction" true true false 2 Short 0 0,First,#,Census_Block_2020,Census_Block_2020.ACAT_ALL,-1,-1;ACAT_253 "Consumer Connections at Served Speeds (25/3)" true true false 2 Short 0 0,First,#,Census_Block_2020,Census_Block_2020.ACAT_253,-1,-1;CASF_EL_LOC "CASF_EL_LOC" true true false 4 Long 0 0,First,#,Census_Block_2020,Census_Block_2020.CASF_EL_LOC,-1,-1;CASF_PE_LOC "CASF_PE_LOC" true true false 4 Long 0 0,First,#,Census_Block_2020,Census_Block_2020.CASF_PE_LOC,-1,-1;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,Census_Block_2020,Census_Block_2020.Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,Census_Block_2020,Census_Block_2020.Shape_Area,-1,-1;OBJECTID "OBJECTID" false true false 4 Long 0 9,First,#,Census_Block_2020,Final_CB.OBJECTID,-1,-1;Company_Applicant "Company Applicant" true true false 8000 Text 0 0,First,#,Census_Block_2020,Final_CB.Company_Applicant,0,8000;Project_Title "Project_Title" true true false 8000 Text 0 0,First,#,Census_Block_2020,Final_CB.Project_Title,0,8000;Census_Blo "Census_Blo" true true false 8 Double 0 0,First,#,Census_Block_2020,Final_CB.Census_Blo,-1,-1;County "County" true true false 8000 Text 0 0,First,#,Census_Block_2020,Final_CB.County,0,8000;Plan_ID "Plan_ID" true true false 4 Long 0 0,First,#,Census_Block_2020,Final_CB.Plan_ID,-1,-1;CB_TEXT "CB_TEXT" true true false 255 Text 0 0,First,#,Census_Block_2020,Final_CB.CB_TEXT,0,255" #
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=C:\Users\jykst\Documents\ArcGIS\Projects\FFA_Vitro\FFA_Vitro.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Census_Block_FinalVersion</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>NAMELSAD20</field_name><field_name>CNTYNAME20</field_name><field_name>PLNAME20</field_name><field_name>ALAND20</field_name><field_name>AWATER20</field_name><field_name>SQMI_GIS</field_name><field_name>POP_2020</field_name><field_name>HH_2020</field_name><field_name>HU_2020</field_name><field_name>STATUS</field_name><field_name>ELIGIBLE</field_name><field_name>POP_DENS</field_name><field_name>HH_DENS</field_name><field_name>HU_DENS</field_name><field_name>HU_RANGE</field_name><field_name>MaxAdDn</field_name><field_name>ACAT_ALL</field_name><field_name>ACAT_253</field_name><field_name>CASF_EL_LOC</field_name><field_name>CASF_PE_LOC</field_name><field_name>OBJECTID</field_name><field_name>CB_TEXT</field_name></DeleteField></workflow></operationSequence>
Dissolve Census_Block_FinalVersion C:\Users\jykst\Documents\ArcGIS\Projects\FFA_Vitro\FFA_Vitro.gdb\Census_Block_FinalV_Dissolve Plan_ID;Company_Applicant;Project_Title # MULTI_PART DISSOLVE_LINES #
ExportFeatures Census_Block_FinalV_Dissolve C:\Users\jykst\Documents\ArcGIS\Projects\MyProject3\MyProject3.gdb\FFA_ProjectAreas # NOT_USE_ALIAS "Company_Applicant "Company Applicant" true true false 8000 Text 0 0,First,#,Census_Block_FinalV_Dissolve,Census_Block_FinalV_Dissolve.Company_Applicant,0,8000;Project_Title "Project_Title" true true false 8000 Text 0 0,First,#,Census_Block_FinalV_Dissolve,Census_Block_FinalV_Dissolve.Project_Title,0,8000;Plan_ID "Plan_ID" true true false 4 Long 0 0,First,#,Census_Block_FinalV_Dissolve,Census_Block_FinalV_Dissolve.Plan_ID,-1,-1;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,Census_Block_FinalV_Dissolve,Census_Block_FinalV_Dissolve.Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,Census_Block_FinalV_Dissolve,Census_Block_FinalV_Dissolve.Shape_Area,-1,-1;OBJECTID "OBJECTID" false true false 4 Long 0 9,First,#,Census_Block_FinalV_Dissolve,T_ProjectSummari_ExportTable.OBJECTID,-1,-1;F1 "1" true true false 8 Double 0 0,First,#,Census_Block_FinalV_Dissolve,T_ProjectSummari_ExportTable.F1,-1,-1;Application__Project_Name "Application: Project Name" true true false 255 Text 0 0,First,#,Census_Block_FinalV_Dissolve,T_ProjectSummari_ExportTable.Application__Project_Name,0,255;Company_Applicant_Name "Company Applicant Name" true true false 255 Text 0 0,First,#,Census_Block_FinalV_Dissolve,T_ProjectSummari_ExportTable.Company_Applicant_Name,0,255;CPCN_U_Number "CPCN/U-Number" true true false 255 Text 0 0,First,#,Census_Block_FinalV_Dissolve,T_ProjectSummari_ExportTable.CPCN_U_Number,0,255;Contact_Person "Contact Person" true true false 255 Text 0 0,First,#,Census_Block_FinalV_Dissolve,T_ProjectSummari_ExportTable.Contact_Person,0,255;Contact_Email "Contact Email" true true false 255 Text 0 0,First,#,Census_Block_FinalV_Dissolve,T_ProjectSummari_ExportTable.Contact_Email,0,255;Contact_Position "Contact Position" true true false 255 Text 0 0,First,#,Census_Block_FinalV_Dissolve,T_ProjectSummari_ExportTable.Contact_Position,0,255;Project_Title "Project Title" true true false 255 Text 0 0,First,#,Census_Block_FinalV_Dissolve,T_ProjectSummari_ExportTable.Project_Title,0,255;Amount_of_FFA_grant_funding_req "Amount of FFA grant funding requested" true true false 8 Double 0 0,First,#,Census_Block_FinalV_Dissolve,T_ProjectSummari_ExportTable.Amount_of_FFA_grant_funding_req,-1,-1;Project_Cost "Project Cost" true true false 8 Double 0 0,First,#,Census_Block_FinalV_Dissolve,T_ProjectSummari_ExportTable.Project_Cost,-1,-1;Median_Household_Income "Median Household Income" true true false 8 Double 0 0,First,#,Census_Block_FinalV_Dissolve,T_ProjectSummari_ExportTable.Median_Household_Income,-1,-1;Number_of_Business_Locations "Number of Business Locations" true true false 8 Double 0 0,First,#,Census_Block_FinalV_Dissolve,T_ProjectSummari_ExportTable.Number_of_Business_Locations,-1,-1;Number_of_Anchor_Institutions "Number of Anchor Institutions" true true false 8 Double 0 0,First,#,Census_Block_FinalV_Dissolve,T_ProjectSummari_ExportTable.Number_of_Anchor_Institutions,-1,-1;Number_of_Public_Safety_Locatio "Number of Public Safety Locations" true true false 8 Double 0 0,First,#,Census_Block_FinalV_Dissolve,T_ProjectSummari_ExportTable.Number_of_Public_Safety_Locatio,-1,-1;Number_of_Unserved_Households "Number of Unserved Households" true true false 8 Double 0 0,First,#,Census_Block_FinalV_Dissolve,T_ProjectSummari_ExportTable.Number_of_Unserved_Households,-1,-1;Max_mbps_down___Unserved_locati "Max mbps down + Unserved locations" true true false 8 Double 0 0,First,#,Census_Block_FinalV_Dissolve,T_ProjectSummari_ExportTable.Max_mbps_down___Unserved_locati,-1,-1;Max_Mbps_Upload_Speed "Max Mbps Upload Speed" true true false 8 Double 0 0,First,#,Census_Block_FinalV_Dissolve,T_ProjectSummari_ExportTable.Max_Mbps_Upload_Speed,-1,-1;Number_of_Mass_Market_Unserved_ "Number of Mass Market Unserved Locations" true true false 8 Double 0 0,First,#,Census_Block_FinalV_Dissolve,T_ProjectSummari_ExportTable.Number_of_Mass_Market_Unserved_,-1,-1;Description_of_the_major_infras "Description of the major infrastructure" true true false 255 Text 0 0,First,#,Census_Block_FinalV_Dissolve,T_ProjectSummari_ExportTable.Description_of_the_major_infras,0,255;Estimated_Breakdown_of_Aerial "Estimated Breakdown of Aerial" true true false 255 Text 0 0,First,#,Census_Block_FinalV_Dissolve,T_ProjectSummari_ExportTable.Estimated_Breakdown_of_Aerial,0,255;Major_Equipment_Expenses "Major Equipment Expenses" true true false 255 Text 0 0,First,#,Census_Block_FinalV_Dissolve,T_ProjectSummari_ExportTable.Major_Equipment_Expenses,0,255;Estimated_project_plan_with_maj "Estimated project plan with major milest" true true false 255 Text 0 0,First,#,Census_Block_FinalV_Dissolve,T_ProjectSummari_ExportTable.Estimated_project_plan_with_maj,0,255;DescProposedBroadbandPlan "DescProposedBroadbandPlan" true true false 255 Text 0 0,First,#,Census_Block_FinalV_Dissolve,T_ProjectSummari_ExportTable.DescProposedBroadbandPlan,0,255;Application_Submitted_Date "Application Submitted Date" true true false 8 Date 0 0,First,#,Census_Block_FinalV_Dissolve,T_ProjectSummari_ExportTable.Application_Submitted_Date,-1,-1;Funding_Opportunity "Funding Opportunity" true true false 255 Text 0 0,First,#,Census_Block_FinalV_Dissolve,T_ProjectSummari_ExportTable.Funding_Opportunity,0,255;Status "Status" true true false 255 Text 0 0,First,#,Census_Block_FinalV_Dissolve,T_ProjectSummari_ExportTable.Status,0,255" #
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=C:\Users\jykst\Documents\ArcGIS\Projects\MyProject3\MyProject3.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>FFA_ProjectAreas</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>Company_Applicant</field_name><field_name>Project_Title</field_name><field_name>Plan_ID</field_name><field_name>OBJECTID</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=C:\Users\jykst\Documents\ArcGIS\Projects\MyProject3\MyProject3.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>FFA_ProjectAreas</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AlterField><field_name>F1</field_name><new_field_name>Plan_ID</new_field_name><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow></operationSequence>
CopyFeatures FFA_ProjectAreas C:\Users\jykst\Documents\FFA_ProjectAreas_fixed.gdb\FFA_ProjectAreas # # # #
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=C:\Users\jykst\Documents\FFA_ProjectAreas_fixed.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>FFA_ProjectAreas</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>Application__Project_Name</field_name></DeleteField></workflow></operationSequence>
ExportFeatures FFA_ProjectAreas D:\Public_Files_For_Vetro\FFA_ProjectAreas.shp # NOT_USE_ALIAS "Plan_ID "Plan_ID" true true false 8 Double 0 0,First,#,FFA_ProjectAreas,Plan_ID,-1,-1;Company_Applicant_Name "Company Applicant Name" true true false 255 Text 0 0,First,#,FFA_ProjectAreas,Company_Applicant_Name,0,255;CPCN_U_Number "CPCN/U-Number" true true false 255 Text 0 0,First,#,FFA_ProjectAreas,CPCN_U_Number,0,255;Contact_Person "Contact Person" true true false 255 Text 0 0,First,#,FFA_ProjectAreas,Contact_Person,0,255;Contact_Email "Contact Email" true true false 255 Text 0 0,First,#,FFA_ProjectAreas,Contact_Email,0,255;Contact_Position "Contact Position" true true false 255 Text 0 0,First,#,FFA_ProjectAreas,Contact_Position,0,255;Project_Title_1 "Project Title" true true false 255 Text 0 0,First,#,FFA_ProjectAreas,Project_Title_1,0,255;Amount_of_FFA_grant_funding_req "Amount of FFA grant funding requested" true true false 8 Double 0 0,First,#,FFA_ProjectAreas,Amount_of_FFA_grant_funding_req,-1,-1;Project_Cost "Project Cost" true true false 8 Double 0 0,First,#,FFA_ProjectAreas,Project_Cost,-1,-1;Median_Household_Income "Median Household Income" true true false 8 Double 0 0,First,#,FFA_ProjectAreas,Median_Household_Income,-1,-1;Number_of_Business_Locations "Number of Business Locations" true true false 8 Double 0 0,First,#,FFA_ProjectAreas,Number_of_Business_Locations,-1,-1;Number_of_Anchor_Institutions "Number of Anchor Institutions" true true false 8 Double 0 0,First,#,FFA_ProjectAreas,Number_of_Anchor_Institutions,-1,-1;Number_of_Public_Safety_Locatio "Number of Public Safety Locations" true true false 8 Double 0 0,First,#,FFA_ProjectAreas,Number_of_Public_Safety_Locatio,-1,-1;Number_of_Unserved_Households "Number of Unserved Households" true true false 8 Double 0 0,First,#,FFA_ProjectAreas,Number_of_Unserved_Households,-1,-1;Max_mbps_down___Unserved_locati "Max mbps down + Unserved locations" true true false 8 Double 0 0,First,#,FFA_ProjectAreas,Max_mbps_down___Unserved_locati,-1,-1;Max_Mbps_Upload_Speed "Max Mbps Upload Speed" true true false 8 Double 0 0,First,#,FFA_ProjectAreas,Max_Mbps_Upload_Speed,-1,-1;Number_of_Mass_Market_Unserved_ "Number of Mass Market Unserved Locations" true true false 8 Double 0 0,First,#,FFA_ProjectAreas,Number_of_Mass_Market_Unserved_,-1,-1;Description_of_the_major_infras "Description of the major infrastructure" true true false 255 Text 0 0,First,#,FFA_ProjectAreas,Description_of_the_major_infras,0,255;Estimated_Breakdown_of_Aerial "Estimated Breakdown of Aerial" true true false 255 Text 0 0,First,#,FFA_ProjectAreas,Estimated_Breakdown_of_Aerial,0,255;Major_Equipment_Expenses "Major Equipment Expenses" true true false 255 Text 0 0,First,#,FFA_ProjectAreas,Major_Equipment_Expenses,0,255;Estimated_project_plan_with_maj "Estimated project plan with major milest" true true false 255 Text 0 0,First,#,FFA_ProjectAreas,Estimated_project_plan_with_maj,0,255;DescProposedBroadbandPlan "DescProposedBroadbandPlan" true true false 255 Text 0 0,First,#,FFA_ProjectAreas,DescProposedBroadbandPlan,0,255;Application_Submitted_Date "Application Submitted Date" true true false 8 Date 0 0,First,#,FFA_ProjectAreas,Application_Submitted_Date,-1,-1;Funding_Opportunity "Funding Opportunity" true true false 255 Text 0 0,First,#,FFA_ProjectAreas,Funding_Opportunity,0,255;Status "Status" true true false 255 Text 0 0,First,#,FFA_ProjectAreas,Status,0,255;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,FFA_ProjectAreas,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,FFA_ProjectAreas,Shape_Area,-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=D:\Public_Files_For_Vetro</WorkspaceConnectionString><WorkspaceFactory>Shapefile</WorkspaceFactory><Dataset>FFA_ProjectAreas.shp</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>Descriptio</field_name><field_name>Estimated_</field_name><field_name>Major_Equi</field_name><field_name>Estimated1</field_name><field_name>DescPropos</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=D:\Public_Files_For_Vetro</WorkspaceConnectionString><WorkspaceFactory>Shapefile</WorkspaceFactory><Dataset>FFA_ProjectAreas.shp</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AlterField><field_name>Applicatio</field_name><field_is_nullable>False</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=D:\Public_Files_For_Vetro</WorkspaceConnectionString><WorkspaceFactory>Shapefile</WorkspaceFactory><Dataset>FFA_ProjectAreas.shp</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AlterField><field_name>Applicatio</field_name><field_is_nullable>False</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=D:\Public_Files_For_Vetro</WorkspaceConnectionString><WorkspaceFactory>Shapefile</WorkspaceFactory><Dataset>FFA_ProjectAreas.shp</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AlterField><field_name>Applicatio</field_name><field_is_nullable>False</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=D:\Public_Files_For_Vetro</WorkspaceConnectionString><WorkspaceFactory>Shapefile</WorkspaceFactory><Dataset>FFA_ProjectAreas.shp</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AlterField><field_name>Applicatio</field_name><field_is_nullable>False</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=D:\Public_Files_For_Vetro</WorkspaceConnectionString><WorkspaceFactory>Shapefile</WorkspaceFactory><Dataset>FFA_ProjectAreas.shp</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AlterField><field_name>Applicatio</field_name><field_is_nullable>False</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow></operationSequence>
Merge FFA_ProjectAreas_SHP D:\Shapefiles\FFA_Project_Areas.shp "PID "PID" true true false 19 Double 0 0,First,#,FFA_ProjectAreas_SHP,Plan_ID,-1,-1;Applicant "Applicant" true true false 254 Text 0 0,First,#,FFA_ProjectAreas_SHP,Company_Ap,0,254;CPCNU_Num "CPCN_U_Num" true true false 254 Text 0 0,First,#,FFA_ProjectAreas_SHP,CPCN_U_Num,0,254;Con_Pers "Con_Pers" true true false 254 Text 0 0,First,#,FFA_ProjectAreas_SHP,Contact_Pe,0,254;Con_Email "Con_Email" true true false 254 Text 0 0,First,#,FFA_ProjectAreas_SHP,Contact_Em,0,254;Con_Pos "Con_Pos" true true false 254 Text 0 0,First,#,FFA_ProjectAreas_SHP,Contact_Po,0,254;Proj_Name "Proj_Name" true true false 254 Text 0 0,First,#,FFA_ProjectAreas_SHP,Project_Ti,0,254;Amt_Req "Amt_Req" true true false 19 Double 0 0,First,#,FFA_ProjectAreas_SHP,Amount_of_,-1,-1;Proj_Cost "Proj_Cost" true true false 19 Double 0 0,First,#,FFA_ProjectAreas_SHP,Project_Co,-1,-1;MHI "MHI" true true false 19 Double 0 0,First,#,FFA_ProjectAreas_SHP,Median_Hou,-1,-1;Num_Bus "Num_Bus" true true false 19 Double 0 0,First,#,FFA_ProjectAreas_SHP,Number_of_,-1,-1;Num_AI "Num_AI" true true false 19 Double 0 0,First,#,FFA_ProjectAreas_SHP,Number_of1,-1,-1;Num_PSL "Num_PSL" true true false 19 Double 0 0,First,#,FFA_ProjectAreas_SHP,Number_o_1,-1,-1;Unsv_HH "Unsv_HH" true true false 19 Double 0 0,First,#,FFA_ProjectAreas_SHP,Number_o_2,-1,-1;MaxDown "MaxDown" true true false 19 Double 0 0,First,#,FFA_ProjectAreas_SHP,Max_mbps_d,-1,-1;MaxUp "MaxUp" true true false 19 Double 0 0,First,#,FFA_ProjectAreas_SHP,Max_Mbps_U,-1,-1;MM_Unsv "MM_Unsv" true true false 19 Double 0 0,First,#,FFA_ProjectAreas_SHP,Number_o_3,-1,-1;Sub_Date "Sub_Date" true true false 8 Date 0 0,First,#,FFA_ProjectAreas_SHP,Applicatio,-1,-1;Funding_Op "Funding_Op" true true false 254 Text 0 0,First,#,FFA_ProjectAreas_SHP,Funding_Op,0,254;Status "Status" true true false 254 Text 0 0,First,#,FFA_ProjectAreas_SHP,Status,0,254;Shape_Leng "Shape_Leng" true true false 19 Double 0 0,First,#,FFA_ProjectAreas_SHP,Shape_Leng,-1,-1;Shape_Area "Shape_Area" true true false 19 Double 0 0,First,#,FFA_ProjectAreas_SHP,Shape_Area,-1,-1" NO_SOURCE_INFO
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=D:\Shapefiles</WorkspaceConnectionString><WorkspaceFactory>Shapefile</WorkspaceFactory><Dataset>FFA_Project_Areas.shp</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>Funding_Op</field_name><field_name>Status</field_name></DeleteField></workflow></operationSequence>
Append selected-california-census-blocks FFA_Project_Areas "Skip and warn if schema does not match" # # # # NOT_UPDATE_GEOMETRY
Append selected-california-census-blocks FFA_Project_Areas "Use the field map to reconcile field differences" "PID "PID" true false false 19 Double 0 0,First,#;Applicant "Applicant" true false false 254 Text 0 0,First,#;CPCNU_Num "CPCNU_Num" true false false 254 Text 0 0,First,#;Con_Pers "Con_Pers" true false false 254 Text 0 0,First,#;Con_Email "Con_Email" true false false 254 Text 0 0,First,#;Con_Pos "Con_Pos" true false false 254 Text 0 0,First,#;Proj_Name "Proj_Name" true false false 254 Text 0 0,First,#;Amt_Req "Amt_Req" true false false 19 Double 0 0,First,#;Proj_Cost "Proj_Cost" true false false 19 Double 0 0,First,#;MHI "MHI" true false false 19 Double 0 0,First,#;Num_Bus "Num_Bus" true false false 19 Double 0 0,First,#;Num_AI "Num_AI" true false false 19 Double 0 0,First,#;Num_PSL "Num_PSL" true false false 19 Double 0 0,First,#;Unsv_HH "Unsv_HH" true false false 19 Double 0 0,First,#;MaxDown "MaxDown" true false false 19 Double 0 0,First,#;MaxUp "MaxUp" true false false 19 Double 0 0,First,#;MM_Unsv "MM_Unsv" true false false 19 Double 0 0,First,#;Sub_Date "Sub_Date" true true false 8 Date 0 0,First,#;Shape_Leng "Shape_Leng" true false false 19 Double 0 0,First,#;Shape_Area "Shape_Area" true false false 19 Double 0 0,First,#" # # # NOT_UPDATE_GEOMETRY
Append selectedcaliforniac_Dissolve FFA_Project_Areas "Use the field map to reconcile field differences" "PID "PID" true false false 19 Double 0 0,First,#;Applicant "Applicant" true false false 254 Text 0 0,First,#;CPCNU_Num "CPCNU_Num" true false false 254 Text 0 0,First,#;Con_Pers "Con_Pers" true false false 254 Text 0 0,First,#;Con_Email "Con_Email" true false false 254 Text 0 0,First,#;Con_Pos "Con_Pos" true false false 254 Text 0 0,First,#;Proj_Name "Proj_Name" true false false 254 Text 0 0,First,#;Amt_Req "Amt_Req" true false false 19 Double 0 0,First,#;Proj_Cost "Proj_Cost" true false false 19 Double 0 0,First,#;MHI "MHI" true false false 19 Double 0 0,First,#;Num_Bus "Num_Bus" true false false 19 Double 0 0,First,#;Num_AI "Num_AI" true false false 19 Double 0 0,First,#;Num_PSL "Num_PSL" true false false 19 Double 0 0,First,#;Unsv_HH "Unsv_HH" true false false 19 Double 0 0,First,#;MaxDown "MaxDown" true false false 19 Double 0 0,First,#;MaxUp "MaxUp" true false false 19 Double 0 0,First,#;MM_Unsv "MM_Unsv" true false false 19 Double 0 0,First,#;Sub_Date "Sub_Date" true true false 8 Date 0 0,First,#;Shape_Leng "Shape_Leng" true false false 19 Double 0 0,First,#;Shape_Area "Shape_Area" true false false 19 Double 0 0,First,#,C:\Users\jykst\Documents\ArcGIS\Projects\TEST_FFA\TEST_FFA.gdb\selectedcaliforniac_Dissolve,Shape_Area,-1,-1" # # # NOT_UPDATE_GEOMETRY
ExportFeatures FFA_Project_Areas D:\Public_Files_For_Vetro\Shapefiles\FFA_Project_Areas_Updated.shp # NOT_USE_ALIAS "PID "PID" true true false 19 Double 0 0,First,#,FFA_Project_Areas,PID,-1,-1;Applicant "Applicant" true true false 254 Text 0 0,First,#,FFA_Project_Areas,Applicant,0,254;CPCNU_Num "CPCNU_Num" true true false 254 Text 0 0,First,#,FFA_Project_Areas,CPCNU_Num,0,254;Con_Pers "Con_Pers" true true false 254 Text 0 0,First,#,FFA_Project_Areas,Con_Pers,0,254;Con_Email "Con_Email" true true false 254 Text 0 0,First,#,FFA_Project_Areas,Con_Email,0,254;Con_Pos "Con_Pos" true true false 254 Text 0 0,First,#,FFA_Project_Areas,Con_Pos,0,254;Proj_Name "Proj_Name" true true false 254 Text 0 0,First,#,FFA_Project_Areas,Proj_Name,0,254;Amt_Req "Amt_Req" true true false 19 Double 0 0,First,#,FFA_Project_Areas,Amt_Req,-1,-1;Proj_Cost "Proj_Cost" true true false 19 Double 0 0,First,#,FFA_Project_Areas,Proj_Cost,-1,-1;MHI "MHI" true true false 19 Double 0 0,First,#,FFA_Project_Areas,MHI,-1,-1;Num_Bus "Num_Bus" true true false 19 Double 0 0,First,#,FFA_Project_Areas,Num_Bus,-1,-1;Num_AI "Num_AI" true true false 19 Double 0 0,First,#,FFA_Project_Areas,Num_AI,-1,-1;Num_PSL "Num_PSL" true true false 19 Double 0 0,First,#,FFA_Project_Areas,Num_PSL,-1,-1;Unsv_HH "Unsv_HH" true true false 19 Double 0 0,First,#,FFA_Project_Areas,Unsv_HH,-1,-1;MaxDown "MaxDown" true true false 19 Double 0 0,First,#,FFA_Project_Areas,MaxDown,-1,-1;MaxUp "MaxUp" true true false 19 Double 0 0,First,#,FFA_Project_Areas,MaxUp,-1,-1;MM_Unsv "MM_Unsv" true true false 19 Double 0 0,First,#,FFA_Project_Areas,MM_Unsv,-1,-1;Sub_Date "Sub_Date" true true false 8 Date 0 0,First,#,FFA_Project_Areas,Sub_Date,-1,-1;Shape_Leng "Shape_Leng" true true false 19 Double 0 0,First,#,FFA_Project_Areas,Shape_Leng,-1,-1;Shape_Area "Shape_Area" true true false 19 Double 0 0,First,#,FFA_Project_Areas,Shape_Area,-1,-1" #
ExportFeatures FFA_Project_Areas_Updated C:\projects\PC224_SBC\data\2023_10_cpuc_data_interpret\FFA_Project_Areas_Layer\FFA_Project_Areas_Updated_Nevada_County_Gigafy.shp # NOT_USE_ALIAS "PID "PID" true true false 19 Double 0 0,First,#,FFA_Project_Areas_Updated,PID,-1,-1;Applicant "Applicant" true true false 254 Text 0 0,First,#,FFA_Project_Areas_Updated,Applicant,0,254;CPCNU_Num "CPCNU_Num" true true false 254 Text 0 0,First,#,FFA_Project_Areas_Updated,CPCNU_Num,0,254;Con_Pers "Con_Pers" true true false 254 Text 0 0,First,#,FFA_Project_Areas_Updated,Con_Pers,0,254;Con_Email "Con_Email" true true false 254 Text 0 0,First,#,FFA_Project_Areas_Updated,Con_Email,0,254;Con_Pos "Con_Pos" true true false 254 Text 0 0,First,#,FFA_Project_Areas_Updated,Con_Pos,0,254;Proj_Name "Proj_Name" true true false 254 Text 0 0,First,#,FFA_Project_Areas_Updated,Proj_Name,0,254;Amt_Req "Amt_Req" true true false 19 Double 0 0,First,#,FFA_Project_Areas_Updated,Amt_Req,-1,-1;Proj_Cost "Proj_Cost" true true false 19 Double 0 0,First,#,FFA_Project_Areas_Updated,Proj_Cost,-1,-1;MHI "MHI" true true false 19 Double 0 0,First,#,FFA_Project_Areas_Updated,MHI,-1,-1;Num_Bus "Num_Bus" true true false 19 Double 0 0,First,#,FFA_Project_Areas_Updated,Num_Bus,-1,-1;Num_AI "Num_AI" true true false 19 Double 0 0,First,#,FFA_Project_Areas_Updated,Num_AI,-1,-1;Num_PSL "Num_PSL" true true false 19 Double 0 0,First,#,FFA_Project_Areas_Updated,Num_PSL,-1,-1;Unsv_HH "Unsv_HH" true true false 19 Double 0 0,First,#,FFA_Project_Areas_Updated,Unsv_HH,-1,-1;MaxDown "MaxDown" true true false 19 Double 0 0,First,#,FFA_Project_Areas_Updated,MaxDown,-1,-1;MaxUp "MaxUp" true true false 19 Double 0 0,First,#,FFA_Project_Areas_Updated,MaxUp,-1,-1;MM_Unsv "MM_Unsv" true true false 19 Double 0 0,First,#,FFA_Project_Areas_Updated,MM_Unsv,-1,-1;Sub_Date "Sub_Date" true true false 8 Date 0 0,First,#,FFA_Project_Areas_Updated,Sub_Date,-1,-1;Shape_Leng "Shape_Leng" true true false 19 Double 0 0,First,#,FFA_Project_Areas_Updated,Shape_Leng,-1,-1;Shape_Area "Shape_Area" true true false 19 Double 0 0,First,#,FFA_Project_Areas_Updated,Shape_Area,-1,-1" #
Select "FFA Project Areas Nevada County" C:\projects\PC224_SBC\data\2023_10_cpuc_data_interpret\FFA_Project_Applicant_Split\FFA_Project_Applicant_Split.gdb\Golden_State_Connect_Authority " "Applicant" = 'Golden State Connect Authority' "
Merge FFA_Applicant_Split\Golden_State_Connect_Authority;FFA_Applicant_Split\Nevada_County_Fiber;FFA_Applicant_Split\Northern_Sierra_Broadband;FFA_Applicant_Split\Frontier_of_California_Inc_;FFA_Applicant_Split\AT_T_Services__Inc__on_behalf_of_its_affiliate_Pacific_Bell_Telephone_Company_d_b_a_AT_T_California;FFA_Applicant_Split\Comcast_Cable_Communications_Management__LLC;FFA_Applicant_Split\El_Dorado_County;FFA_Applicant_Split\County_of_Placer;FFA_Applicant_Split\City_of_Roseville;FFA_Applicant_Split\Placerville__City_of C:\projects\PC224_SBC\data\2023_10_cpuc_data_interpret\FFA_Project_Applicant_Split\FFA_Project_Applicant_Split.gdb\FFA_Project_Areas_Merge "PID "PID" true true false 8 Double 0 0,First,#,FFA_Applicant_Split\Golden_State_Connect_Authority,PID,-1,-1,FFA_Applicant_Split\Nevada_County_Fiber,PID,-1,-1,FFA_Applicant_Split\Northern_Sierra_Broadband,PID,-1,-1,FFA_Applicant_Split\Frontier_of_California_Inc_,PID,-1,-1,FFA_Applicant_Split\AT_T_Services__Inc__on_behalf_of_its_affiliate_Pacific_Bell_Telephone_Company_d_b_a_AT_T_California,PID,-1,-1,FFA_Applicant_Split\Comcast_Cable_Communications_Management__LLC,PID,-1,-1,FFA_Applicant_Split\El_Dorado_County,PID,-1,-1,FFA_Applicant_Split\County_of_Placer,PID,-1,-1,FFA_Applicant_Split\City_of_Roseville,PID,-1,-1,FFA_Applicant_Split\Placerville__City_of,PID,-1,-1;Applicant "Applicant" true true false 254 Text 0 0,First,#,FFA_Applicant_Split\Golden_State_Connect_Authority,Applicant,0,254,FFA_Applicant_Split\Nevada_County_Fiber,Applicant,0,254,FFA_Applicant_Split\Northern_Sierra_Broadband,Applicant,0,254,FFA_Applicant_Split\Frontier_of_California_Inc_,Applicant,0,254,FFA_Applicant_Split\AT_T_Services__Inc__on_behalf_of_its_affiliate_Pacific_Bell_Telephone_Company_d_b_a_AT_T_California,Applicant,0,254,FFA_Applicant_Split\Comcast_Cable_Communications_Management__LLC,Applicant,0,254,FFA_Applicant_Split\El_Dorado_County,Applicant,0,254,FFA_Applicant_Split\County_of_Placer,Applicant,0,254,FFA_Applicant_Split\City_of_Roseville,Applicant,0,254,FFA_Applicant_Split\Placerville__City_of,Applicant,0,254;CPCNU_Num "CPCNU_Num" true true false 254 Text 0 0,First,#,FFA_Applicant_Split\Golden_State_Connect_Authority,CPCNU_Num,0,254,FFA_Applicant_Split\Nevada_County_Fiber,CPCNU_Num,0,254,FFA_Applicant_Split\Northern_Sierra_Broadband,CPCNU_Num,0,254,FFA_Applicant_Split\Frontier_of_California_Inc_,CPCNU_Num,0,254,FFA_Applicant_Split\AT_T_Services__Inc__on_behalf_of_its_affiliate_Pacific_Bell_Telephone_Company_d_b_a_AT_T_California,CPCNU_Num,0,254,FFA_Applicant_Split\Comcast_Cable_Communications_Management__LLC,CPCNU_Num,0,254,FFA_Applicant_Split\El_Dorado_County,CPCNU_Num,0,254,FFA_Applicant_Split\County_of_Placer,CPCNU_Num,0,254,FFA_Applicant_Split\City_of_Roseville,CPCNU_Num,0,254,FFA_Applicant_Split\Placerville__City_of,CPCNU_Num,0,254;Con_Pers "Con_Pers" true true false 254 Text 0 0,First,#,FFA_Applicant_Split\Golden_State_Connect_Authority,Con_Pers,0,254,FFA_Applicant_Split\Nevada_County_Fiber,Con_Pers,0,254,FFA_Applicant_Split\Northern_Sierra_Broadband,Con_Pers,0,254,FFA_Applicant_Split\Frontier_of_California_Inc_,Con_Pers,0,254,FFA_Applicant_Split\AT_T_Services__Inc__on_behalf_of_its_affiliate_Pacific_Bell_Telephone_Company_d_b_a_AT_T_California,Con_Pers,0,254,FFA_Applicant_Split\Comcast_Cable_Communications_Management__LLC,Con_Pers,0,254,FFA_Applicant_Split\El_Dorado_County,Con_Pers,0,254,FFA_Applicant_Split\County_of_Placer,Con_Pers,0,254,FFA_Applicant_Split\City_of_Roseville,Con_Pers,0,254,FFA_Applicant_Split\Placerville__City_of,Con_Pers,0,254;Con_Email "Con_Email" true true false 254 Text 0 0,First,#,FFA_Applicant_Split\Golden_State_Connect_Authority,Con_Email,0,254,FFA_Applicant_Split\Nevada_County_Fiber,Con_Email,0,254,FFA_Applicant_Split\Northern_Sierra_Broadband,Con_Email,0,254,FFA_Applicant_Split\Frontier_of_California_Inc_,Con_Email,0,254,FFA_Applicant_Split\AT_T_Services__Inc__on_behalf_of_its_affiliate_Pacific_Bell_Telephone_Company_d_b_a_AT_T_California,Con_Email,0,254,FFA_Applicant_Split\Comcast_Cable_Communications_Management__LLC,Con_Email,0,254,FFA_Applicant_Split\El_Dorado_County,Con_Email,0,254,FFA_Applicant_Split\County_of_Placer,Con_Email,0,254,FFA_Applicant_Split\City_of_Roseville,Con_Email,0,254,FFA_Applicant_Split\Placerville__City_of,Con_Email,0,254;Con_Pos "Con_Pos" true true false 254 Text 0 0,First,#,FFA_Applicant_Split\Golden_State_Connect_Authority,Con_Pos,0,254,FFA_Applicant_Split\Nevada_County_Fiber,Con_Pos,0,254,FFA_Applicant_Split\Northern_Sierra_Broadband,Con_Pos,0,254,FFA_Applicant_Split\Frontier_of_California_Inc_,Con_Pos,0,254,FFA_Applicant_Split\AT_T_Services__Inc__on_behalf_of_its_affiliate_Pacific_Bell_Telephone_Company_d_b_a_AT_T_California,Con_Pos,0,254,FFA_Applicant_Split\Comcast_Cable_Communications_Management__LLC,Con_Pos,0,254,FFA_Applicant_Split\El_Dorado_County,Con_Pos,0,254,FFA_Applicant_Split\County_of_Placer,Con_Pos,0,254,FFA_Applicant_Split\City_of_Roseville,Con_Pos,0,254,FFA_Applicant_Split\Placerville__City_of,Con_Pos,0,254;Proj_Name "Proj_Name" true true false 254 Text 0 0,First,#,FFA_Applicant_Split\Golden_State_Connect_Authority,Proj_Name,0,254,FFA_Applicant_Split\Nevada_County_Fiber,Proj_Name,0,254,FFA_Applicant_Split\Northern_Sierra_Broadband,Proj_Name,0,254,FFA_Applicant_Split\Frontier_of_California_Inc_,Proj_Name,0,254,FFA_Applicant_Split\AT_T_Services__Inc__on_behalf_of_its_affiliate_Pacific_Bell_Telephone_Company_d_b_a_AT_T_California,Proj_Name,0,254,FFA_Applicant_Split\Comcast_Cable_Communications_Management__LLC,Proj_Name,0,254,FFA_Applicant_Split\El_Dorado_County,Proj_Name,0,254,FFA_Applicant_Split\County_of_Placer,Proj_Name,0,254,FFA_Applicant_Split\City_of_Roseville,Proj_Name,0,254,FFA_Applicant_Split\Placerville__City_of,Proj_Name,0,254;Amt_Req "Amt_Req" true true false 8 Double 0 0,First,#,FFA_Applicant_Split\Golden_State_Connect_Authority,Amt_Req,-1,-1,FFA_Applicant_Split\Nevada_County_Fiber,Amt_Req,-1,-1,FFA_Applicant_Split\Northern_Sierra_Broadband,Amt_Req,-1,-1,FFA_Applicant_Split\Frontier_of_California_Inc_,Amt_Req,-1,-1,FFA_Applicant_Split\AT_T_Services__Inc__on_behalf_of_its_affiliate_Pacific_Bell_Telephone_Company_d_b_a_AT_T_California,Amt_Req,-1,-1,FFA_Applicant_Split\Comcast_Cable_Communications_Management__LLC,Amt_Req,-1,-1,FFA_Applicant_Split\El_Dorado_County,Amt_Req,-1,-1,FFA_Applicant_Split\County_of_Placer,Amt_Req,-1,-1,FFA_Applicant_Split\City_of_Roseville,Amt_Req,-1,-1,FFA_Applicant_Split\Placerville__City_of,Amt_Req,-1,-1;Proj_Cost "Proj_Cost" true true false 8 Double 0 0,First,#,FFA_Applicant_Split\Golden_State_Connect_Authority,Proj_Cost,-1,-1,FFA_Applicant_Split\Nevada_County_Fiber,Proj_Cost,-1,-1,FFA_Applicant_Split\Northern_Sierra_Broadband,Proj_Cost,-1,-1,FFA_Applicant_Split\Frontier_of_California_Inc_,Proj_Cost,-1,-1,FFA_Applicant_Split\AT_T_Services__Inc__on_behalf_of_its_affiliate_Pacific_Bell_Telephone_Company_d_b_a_AT_T_California,Proj_Cost,-1,-1,FFA_Applicant_Split\Comcast_Cable_Communications_Management__LLC,Proj_Cost,-1,-1,FFA_Applicant_Split\El_Dorado_County,Proj_Cost,-1,-1,FFA_Applicant_Split\County_of_Placer,Proj_Cost,-1,-1,FFA_Applicant_Split\City_of_Roseville,Proj_Cost,-1,-1,FFA_Applicant_Split\Placerville__City_of,Proj_Cost,-1,-1;MHI "MHI" true true false 8 Double 0 0,First,#,FFA_Applicant_Split\Golden_State_Connect_Authority,MHI,-1,-1,FFA_Applicant_Split\Nevada_County_Fiber,MHI,-1,-1,FFA_Applicant_Split\Northern_Sierra_Broadband,MHI,-1,-1,FFA_Applicant_Split\Frontier_of_California_Inc_,MHI,-1,-1,FFA_Applicant_Split\AT_T_Services__Inc__on_behalf_of_its_affiliate_Pacific_Bell_Telephone_Company_d_b_a_AT_T_California,MHI,-1,-1,FFA_Applicant_Split\Comcast_Cable_Communications_Management__LLC,MHI,-1,-1,FFA_Applicant_Split\El_Dorado_County,MHI,-1,-1,FFA_Applicant_Split\County_of_Placer,MHI,-1,-1,FFA_Applicant_Split\City_of_Roseville,MHI,-1,-1,FFA_Applicant_Split\Placerville__City_of,MHI,-1,-1;Num_Bus "Num_Bus" true true false 8 Double 0 0,First,#,FFA_Applicant_Split\Golden_State_Connect_Authority,Num_Bus,-1,-1,FFA_Applicant_Split\Nevada_County_Fiber,Num_Bus,-1,-1,FFA_Applicant_Split\Northern_Sierra_Broadband,Num_Bus,-1,-1,FFA_Applicant_Split\Frontier_of_California_Inc_,Num_Bus,-1,-1,FFA_Applicant_Split\AT_T_Services__Inc__on_behalf_of_its_affiliate_Pacific_Bell_Telephone_Company_d_b_a_AT_T_California,Num_Bus,-1,-1,FFA_Applicant_Split\Comcast_Cable_Communications_Management__LLC,Num_Bus,-1,-1,FFA_Applicant_Split\El_Dorado_County,Num_Bus,-1,-1,FFA_Applicant_Split\County_of_Placer,Num_Bus,-1,-1,FFA_Applicant_Split\City_of_Roseville,Num_Bus,-1,-1,FFA_Applicant_Split\Placerville__City_of,Num_Bus,-1,-1;Num_AI "Num_AI" true true false 8 Double 0 0,First,#,FFA_Applicant_Split\Golden_State_Connect_Authority,Num_AI,-1,-1,FFA_Applicant_Split\Nevada_County_Fiber,Num_AI,-1,-1,FFA_Applicant_Split\Northern_Sierra_Broadband,Num_AI,-1,-1,FFA_Applicant_Split\Frontier_of_California_Inc_,Num_AI,-1,-1,FFA_Applicant_Split\AT_T_Services__Inc__on_behalf_of_its_affiliate_Pacific_Bell_Telephone_Company_d_b_a_AT_T_California,Num_AI,-1,-1,FFA_Applicant_Split\Comcast_Cable_Communications_Management__LLC,Num_AI,-1,-1,FFA_Applicant_Split\El_Dorado_County,Num_AI,-1,-1,FFA_Applicant_Split\County_of_Placer,Num_AI,-1,-1,FFA_Applicant_Split\City_of_Roseville,Num_AI,-1,-1,FFA_Applicant_Split\Placerville__City_of,Num_AI,-1,-1;Num_PSL "Num_PSL" true true false 8 Double 0 0,First,#,FFA_Applicant_Split\Golden_State_Connect_Authority,Num_PSL,-1,-1,FFA_Applicant_Split\Nevada_County_Fiber,Num_PSL,-1,-1,FFA_Applicant_Split\Northern_Sierra_Broadband,Num_PSL,-1,-1,FFA_Applicant_Split\Frontier_of_California_Inc_,Num_PSL,-1,-1,FFA_Applicant_Split\AT_T_Services__Inc__on_behalf_of_its_affiliate_Pacific_Bell_Telephone_Company_d_b_a_AT_T_California,Num_PSL,-1,-1,FFA_Applicant_Split\Comcast_Cable_Communications_Management__LLC,Num_PSL,-1,-1,FFA_Applicant_Split\El_Dorado_County,Num_PSL,-1,-1,FFA_Applicant_Split\County_of_Placer,Num_PSL,-1,-1,FFA_Applicant_Split\City_of_Roseville,Num_PSL,-1,-1,FFA_Applicant_Split\Placerville__City_of,Num_PSL,-1,-1;Unsv_HH "Unsv_HH" true true false 8 Double 0 0,First,#,FFA_Applicant_Split\Golden_State_Connect_Authority,Unsv_HH,-1,-1,FFA_Applicant_Split\Nevada_County_Fiber,Unsv_HH,-1,-1,FFA_Applicant_Split\Northern_Sierra_Broadband,Unsv_HH,-1,-1,FFA_Applicant_Split\Frontier_of_California_Inc_,Unsv_HH,-1,-1,FFA_Applicant_Split\AT_T_Services__Inc__on_behalf_of_its_affiliate_Pacific_Bell_Telephone_Company_d_b_a_AT_T_California,Unsv_HH,-1,-1,FFA_Applicant_Split\Comcast_Cable_Communications_Management__LLC,Unsv_HH,-1,-1,FFA_Applicant_Split\El_Dorado_County,Unsv_HH,-1,-1,FFA_Applicant_Split\County_of_Placer,Unsv_HH,-1,-1,FFA_Applicant_Split\City_of_Roseville,Unsv_HH,-1,-1,FFA_Applicant_Split\Placerville__City_of,Unsv_HH,-1,-1;MaxDown "MaxDown" true true false 8 Double 0 0,First,#,FFA_Applicant_Split\Golden_State_Connect_Authority,MaxDown,-1,-1,FFA_Applicant_Split\Nevada_County_Fiber,MaxDown,-1,-1,FFA_Applicant_Split\Northern_Sierra_Broadband,MaxDown,-1,-1,FFA_Applicant_Split\Frontier_of_California_Inc_,MaxDown,-1,-1,FFA_Applicant_Split\AT_T_Services__Inc__on_behalf_of_its_affiliate_Pacific_Bell_Telephone_Company_d_b_a_AT_T_California,MaxDown,-1,-1,FFA_Applicant_Split\Comcast_Cable_Communications_Management__LLC,MaxDown,-1,-1,FFA_Applicant_Split\El_Dorado_County,MaxDown,-1,-1,FFA_Applicant_Split\County_of_Placer,MaxDown,-1,-1,FFA_Applicant_Split\City_of_Roseville,MaxDown,-1,-1,FFA_Applicant_Split\Placerville__City_of,MaxDown,-1,-1;MaxUp "MaxUp" true true false 8 Double 0 0,First,#,FFA_Applicant_Split\Golden_State_Connect_Authority,MaxUp,-1,-1,FFA_Applicant_Split\Nevada_County_Fiber,MaxUp,-1,-1,FFA_Applicant_Split\Northern_Sierra_Broadband,MaxUp,-1,-1,FFA_Applicant_Split\Frontier_of_California_Inc_,MaxUp,-1,-1,FFA_Applicant_Split\AT_T_Services__Inc__on_behalf_of_its_affiliate_Pacific_Bell_Telephone_Company_d_b_a_AT_T_California,MaxUp,-1,-1,FFA_Applicant_Split\Comcast_Cable_Communications_Management__LLC,MaxUp,-1,-1,FFA_Applicant_Split\El_Dorado_County,MaxUp,-1,-1,FFA_Applicant_Split\County_of_Placer,MaxUp,-1,-1,FFA_Applicant_Split\City_of_Roseville,MaxUp,-1,-1,FFA_Applicant_Split\Placerville__City_of,MaxUp,-1,-1;MM_Unsv "MM_Unsv" true true false 8 Double 0 0,First,#,FFA_Applicant_Split\Golden_State_Connect_Authority,MM_Unsv,-1,-1,FFA_Applicant_Split\Nevada_County_Fiber,MM_Unsv,-1,-1,FFA_Applicant_Split\Northern_Sierra_Broadband,MM_Unsv,-1,-1,FFA_Applicant_Split\Frontier_of_California_Inc_,MM_Unsv,-1,-1,FFA_Applicant_Split\AT_T_Services__Inc__on_behalf_of_its_affiliate_Pacific_Bell_Telephone_Company_d_b_a_AT_T_California,MM_Unsv,-1,-1,FFA_Applicant_Split\Comcast_Cable_Communications_Management__LLC,MM_Unsv,-1,-1,FFA_Applicant_Split\El_Dorado_County,MM_Unsv,-1,-1,FFA_Applicant_Split\County_of_Placer,MM_Unsv,-1,-1,FFA_Applicant_Split\City_of_Roseville,MM_Unsv,-1,-1,FFA_Applicant_Split\Placerville__City_of,MM_Unsv,-1,-1;Sub_Date "Sub_Date" true true false 8 Date 0 0,First,#,FFA_Applicant_Split\Golden_State_Connect_Authority,Sub_Date,-1,-1,FFA_Applicant_Split\Nevada_County_Fiber,Sub_Date,-1,-1,FFA_Applicant_Split\Northern_Sierra_Broadband,Sub_Date,-1,-1,FFA_Applicant_Split\Frontier_of_California_Inc_,Sub_Date,-1,-1,FFA_Applicant_Split\AT_T_Services__Inc__on_behalf_of_its_affiliate_Pacific_Bell_Telephone_Company_d_b_a_AT_T_California,Sub_Date,-1,-1,FFA_Applicant_Split\Comcast_Cable_Communications_Management__LLC,Sub_Date,-1,-1,FFA_Applicant_Split\El_Dorado_County,Sub_Date,-1,-1,FFA_Applicant_Split\County_of_Placer,Sub_Date,-1,-1,FFA_Applicant_Split\City_of_Roseville,Sub_Date,-1,-1,FFA_Applicant_Split\Placerville__City_of,Sub_Date,-1,-1;Shape_Leng "Shape_Leng" true true false 8 Double 0 0,First,#,FFA_Applicant_Split\Golden_State_Connect_Authority,Shape_Leng,-1,-1,FFA_Applicant_Split\Nevada_County_Fiber,Shape_Leng,-1,-1,FFA_Applicant_Split\Northern_Sierra_Broadband,Shape_Leng,-1,-1,FFA_Applicant_Split\Frontier_of_California_Inc_,Shape_Leng,-1,-1,FFA_Applicant_Split\AT_T_Services__Inc__on_behalf_of_its_affiliate_Pacific_Bell_Telephone_Company_d_b_a_AT_T_California,Shape_Leng,-1,-1,FFA_Applicant_Split\Comcast_Cable_Communications_Management__LLC,Shape_Leng,-1,-1,FFA_Applicant_Split\El_Dorado_County,Shape_Leng,-1,-1,FFA_Applicant_Split\County_of_Placer,Shape_Leng,-1,-1,FFA_Applicant_Split\City_of_Roseville,Shape_Leng,-1,-1,FFA_Applicant_Split\Placerville__City_of,Shape_Leng,-1,-1;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,FFA_Applicant_Split\Golden_State_Connect_Authority,Shape_Length,-1,-1,FFA_Applicant_Split\Nevada_County_Fiber,Shape_Length,-1,-1,FFA_Applicant_Split\Northern_Sierra_Broadband,Shape_Length,-1,-1,FFA_Applicant_Split\Frontier_of_California_Inc_,Shape_Length,-1,-1,FFA_Applicant_Split\AT_T_Services__Inc__on_behalf_of_its_affiliate_Pacific_Bell_Telephone_Company_d_b_a_AT_T_California,Shape_Length,-1,-1,FFA_Applicant_Split\Comcast_Cable_Communications_Management__LLC,Shape_Length,-1,-1,FFA_Applicant_Split\El_Dorado_County,Shape_Length,-1,-1,FFA_Applicant_Split\County_of_Placer,Shape_Length,-1,-1,FFA_Applicant_Split\City_of_Roseville,Shape_Length,-1,-1,FFA_Applicant_Split\Placerville__City_of,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,FFA_Applicant_Split\Golden_State_Connect_Authority,Shape_Area,-1,-1,FFA_Applicant_Split\Nevada_County_Fiber,Shape_Area,-1,-1,FFA_Applicant_Split\Northern_Sierra_Broadband,Shape_Area,-1,-1,FFA_Applicant_Split\Frontier_of_California_Inc_,Shape_Area,-1,-1,FFA_Applicant_Split\AT_T_Services__Inc__on_behalf_of_its_affiliate_Pacific_Bell_Telephone_Company_d_b_a_AT_T_California,Shape_Area,-1,-1,FFA_Applicant_Split\Comcast_Cable_Communications_Management__LLC,Shape_Area,-1,-1,FFA_Applicant_Split\El_Dorado_County,Shape_Area,-1,-1,FFA_Applicant_Split\County_of_Placer,Shape_Area,-1,-1,FFA_Applicant_Split\City_of_Roseville,Shape_Area,-1,-1,FFA_Applicant_Split\Placerville__City_of,Shape_Area,-1,-1" NO_SOURCE_INFO
CountOverlappingFeatures FFA_Applicant_Split\FFA_Project_Areas_Merge C:\projects\PC224_SBC\data\2023_10_cpuc_data_interpret\FFA_Project_Applicant_Split\FFA_Project_Applicant_Split.gdb\a_count_overlap 1 #
20231108
12513900
20231108
12513900
Microsoft Windows 10 Version 10.0 (Build 19045) ; Esri ArcGIS 13.1.3.41833
a_count_overlap
a_count_overlap
File Geodatabase Feature Class
0.000
dataset
EPSG
6.18.3(9.3.1.2)
0
Simple
FALSE
0
TRUE
FALSE
a_count_overlap
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.
COUNT_
COUNT_
Integer
4
0
0
COUNT_FC
COUNT_FC
Integer
4
0
0
Shape_Length
Shape_Length
Double
8
0
0
Length of feature in internal units.
Esri
Positive real numbers that are automatically generated.
Shape_Area
Shape_Area
Double
8
0
0
Area of feature in internal units squared.
Esri
Positive real numbers that are automatically generated.
20231108
/9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD1Kiii
mSFSQv5cyN2B5qOigDeoqG3dmt0Y4PHapqRQUnelpB0oAWiiigAooooAKKKKACiiigAooooAKKKK
ACiijNACHgUtJ17UtAAehpF+6PpSnoaRfuj6UALRRRQAUUUUAFFFFABRRRQAUUUUAFFFFAGDRRRT
JCiiigDYtVxaoD6VKOmPSkQBUVR0ApT6ikULSDpSfe9cU6gAooooAKKKKACijGaO9ABRRRQAUUUU
AFJyaWkHegAx+NLjFFFABRRRQAHoaRfuj6Up6GkX7o+lAC0UUUAFFFFABRRRQAUUUUAFFFFABRRR
QBg0UUUyQqW3ZVnQv93NRU+JN8qr6mgDbooopFCD0paQ9c0tABRRRQAUUUUAFFB6UUAFFIehowCK
AFyPWijFJgUAGaB1NKRQOKACiiigAooooAD0NIv3R9KU9DSL90fSgBaKKKACiiigAooooAKKKKAC
iiigApM0tFAGDRRRTJCrFrb+ex5KgdxUCKXcKvU1rwRrCuNm0nGec0DJVXYgUZ4GOaWiikMKTHpS
0UAJk+lAPrS0YoAQ0tJiloAQ9KUnnoaaxwwOKcDkZoATrS0UUAFFFFABRRRQAUUUUAFFFFAAehpF
+6PpSnoaRfuj6UALRRRQAUUUUAFFFFABRRSHqBQAtA6UYHpn60UAFFFFAGDRRRTJLenx7pi5/hFa
ZGaybJityo9eDWtSGhobHDdadSMAVIIzQCcetAxaKKKACiiigAooooAQgGgccYxS0jfdoAWiiigA
ooooAKKKKACiiigAooooAD0NIv3R9KD0NC/dH0oAWiiigAooooAKKKKACjuKKO9ABRRRQAUUUUAY
NFFFMkcjtG4ZTgitW3uVnHow6isilBIOQcGgZu0mOeKhtZxNEMnLjrU/ekMTofalopB6UALRRRQA
UUUUAFI3IxilooAKKRe4z3paACiiigAooooAKKKKACiiigBD0NC/dH0oPQ0L90fSgBaKKKACiiig
AooooAKB0oOTRQAUUUUAFFFFAGDRRRTJCiiigB8UrQyB17dq2UdZFDKcg1h1oac42Mmec5oGi9Sd
6WkPSkMWiiigAooooAKKKKAG9HPvTqQjOOelNJbII6GgB9FFFABRSE9hRigAz9aM0tBGaACikA/O
jAoAD0NC/dH0oPQ0L90fSgBaKKKAAHNFJ3zS0AFFFFABRRRQAUUUUAFFFFAGDRRRTJCiiigAqzYn
FyPcGq1XdOUGR29BQM0aKKKQxB6UtIRmjNAC0UUUAFFFFACN900tIwyKWgApM+gzQaWgBB60tFFA
BRRRQAUUUUAIehpu4BRyM4px+6aTGYxyelACK+Tg0+mR8A0+gAooooAKKKKACiiigAooooAKKKKA
MGiiimSFFFFABVvT3ImK/wB4VUp8UhilVx2NAG3RSKQygjoRmlpFBRRRQAUUUUAFAoooAaxxg571
GjTHztyp8p+QAnkY7kj+VTEVWmjmS1kW3cmXll3nOe+M9qAKqaoSdOVkXfduwODwuAT+fA4/wrTq
lFptumyRogXWQzJu58tmHOPzP51doAKztVuL21EElqITHvxL5pxxjjmtGsjxGSNMCrA07s4CxoDu
J56HsfegC/ZSzy2wN0sazjhxESVz7EgVYrJXVFsYrO1u/mvZQAYoyGI//VkVrUAFFFFACHkZ9qF+
6PpQeFNC/dH0oAWiiigAooooAKKKKACiiigAooooAKKKKAMGiiimSFFFFABR1oooA24lKRIp6gU+
qNndAgRSHnsTV6kUFFFFABRRRQAUUUUAFIe31paCARQBnzS3y6zBGgQWbRtuJGTuGO/bitDtTc84
PrTqACmSxLNGY3ztPocGk3fPxyKeSdp24z2oAyV1DTNNkW3ubvNyqkB5yPMcDrzgZqSw1b7Xc+RJ
EsLFC6AvlmAIGcde/Ws0+HJ5lUzm2d0XcGKkl5CMHcfTgYxitHS9IFl++nkM902S0jYPJPbjI4wP
TigDUooooADyKap7HginUhGaAFopoJBw3X19adQAUUUUAFFFFABRRRQAUUUUAFFFFAGDRRRTJCii
igAooooAK0bK5L/unPI6H1rOpQSpBBwRQBu0VVt7xZQFc7X/AJ1azSKCiikBB6GgBaKKKACiiigA
I4qBkXz/ADgDv27c7jjH06VPVfGDQAvXgVIpOcYwMUqKB9adQAUUUUAFFFFABRRRQAhAIwaQEqcN
+Bp1BGRg0AFFN5Tryvr6U6gAooooAKKKKACiiigAooooAwaKKKZIUUUUAFFFFABRRRQAVrWcvmQD
P3hwayakgcxzKw9aBmyRkYpFXaKEcOgYdDTqQwoopiOsgJU5wcUAPopM80oORxQAUwruHXjNLnEh
y3bpSrnHNAAq7RS0UUAFFFFABRRRQAUUUUAFFFFABTfudPu/yp1FAB1opuCvI6dxTgQRkUAFFFFA
BRRRQAUUUUAYNFFFMkKKKKACiiigAooooAKkhGZAT0HJoooA1YGR8tGwweSPQ1LRRSKMu8mfzSgY
7RyKntJZSjEoWHr3oooEDmeSYSIpCr0G7Gak+1OoG6Ej15oooAaHch2VsjuQMYqaKUFfmPI/Kiig
CQMCcCloooGFFFFABRRRQAUUUUAFFFFABRRRQAU0gg5X8R60UUAKCCOKWiigAooooAKKKKAP/9k=