20231101 13280500 1.0 FGDC CSDGM Metadata FALSE CASF_Approved__LMRequested 002 file://\\SF5S6TTQ3LT\C$\Users\ndy\Desktop\Requested Data\p30\sig_gis.gdb Local Area Network Projected GCS_WGS_1984 Linear Unit: Meter (1.000000) <ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.0.0'><WKT>PROJCS[&quot;WGS_1984_Web_Mercator_Auxiliary_Sphere&quot;,GEOGCS[&quot;GCS_WGS_1984&quot;,DATUM[&quot;D_WGS_1984&quot;,SPHEROID[&quot;WGS_1984&quot;,6378137.0,298.257223563]],PRIMEM[&quot;Greenwich&quot;,0.0],UNIT[&quot;Degree&quot;,0.0174532925199433]],PROJECTION[&quot;Mercator_Auxiliary_Sphere&quot;],PARAMETER[&quot;False_Easting&quot;,0.0],PARAMETER[&quot;False_Northing&quot;,0.0],PARAMETER[&quot;Central_Meridian&quot;,0.0],PARAMETER[&quot;Standard_Parallel_1&quot;,0.0],PARAMETER[&quot;Auxiliary_Sphere_Type&quot;,0.0],UNIT[&quot;Meter&quot;,1.0],AUTHORITY[&quot;EPSG&quot;,3857]]</WKT><XOrigin>-20037700</XOrigin><YOrigin>-30241100</YOrigin><XYScale>148923141.92838538</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102100</WKID><LatestWKID>3857</LatestWKID></ProjectedCoordinateSystem> WGS_1984_Web_Mercator_Auxiliary_Sphere Merge 'D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects' "D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects2" "PROVIDER "PROVIDER" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects,PROVIDER,-1,-1;DBA "DBA" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects,DBA,-1,-1;FRN "FRN" true true false 10 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects,FRN,-1,-1;APP_TYPE "Application Type" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects,APP_TYPE,-1,-1;APP_DATE "Application Date" true true false 0 Date 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects,APP_DATE,-1,-1;PROJ_NAME "Project Name" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects,NAME,-1,-1;APPR_STAT "Approval Status" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects,APPR_STAT,-1,-1;PROJ_TYPE "Project Type" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects,TYPE,-1,-1;TECHNOLOGY "Technology of Transmission" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects,TECHNOLOGY,-1,-1;DOWNSTREAM "Downstream Speed (Mbps)" true true false 0 Float 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects,DOWNSTREAM,-1,-1;UPSTREAM "Upstream Speed (Mbps)" true true false 0 Float 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects,UPSTREAM,-1,-1;HOUSEHOLDS "Households" true true false 0 Long 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects,HOUSEHOLDS,-1,-1;REQ_AMT "Requested Amount" true true false 0 Float 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects,REQ_AMT,-1,-1;APPR_DATE "Approval Date" true true false 8 Date 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects,APPR_DATE,-1,-1;RESOLUTION "Resolution" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects,RESOLUTION,-1,-1;FUND_LEVEL "Funding Level" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects,FUND_LEVEL,-1,-1;GRANT_AMT "Grant Amount" true true false 0 Float 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects,GRANT_AMT,-1,-1" Merge 'D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects2' "D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects3" "PROVIDER "Provider Name" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects2,PROVIDER,-1,-1;DBA "DBA Name" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects2,DBA,-1,-1;FRN "FRN" true true false 10 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects2,FRN,-1,-1;PROJ_NAME "Project Name" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects2,PROJ_NAME,-1,-1;PROJ_TYPE "Project Type" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects2,PROJ_TYPE,-1,-1;TECHNOLOGY "Technology of Transmission" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects2,TECHNOLOGY,-1,-1;DOWNSTREAM "Downstream Speed (Mbps)" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects2,DOWNSTREAM,-1,-1;UPSTREAM "Upstream Speed (Mbps)" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects2,UPSTREAM,-1,-1;HOUSEHOLDS "Households" true true false 4 Long 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects2,HOUSEHOLDS,-1,-1;APP_DATE "Application Date" true true false 8 Date 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects2,APP_DATE,-1,-1;APP_TYPE "Application Type" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects2,APP_TYPE,-1,-1;REQ_AMT "Requested Amount" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects2,REQ_AMT,-1,-1;APPR_STAT "Approval Status" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects2,APPR_STAT,-1,-1;APPR_DATE "Approval Date" true true false 8 Date 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects2,APPR_DATE,-1,-1;GRANT_AMT "Grant Amount" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects2,GRANT_AMT,-1,-1;FUND_LEVEL "Funding Level" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects2,FUND_LEVEL,-1,-1;RESOLUTION "Resolution" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects2,RESOLUTION,-1,-1;Shape_Length "Shape_Length" false true true 8 Double 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects2,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects2,Shape_Area,-1,-1" Append 'D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Brookside__Dissolve.shp' "D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects" NO_TEST "PROVIDER "Provider Name" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Brookside__Dissolve.shp,PROVIDER_1,-1,-1;DBA "DBA Name" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Brookside__Dissolve.shp,DBA_,-1,-1;FRN "FRN" true true false 10 Text 0 0 ,First,#;PROJ_NAME "Project Name" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Brookside__Dissolve.shp,NAME,-1,-1;PROJ_TYPE "Project Type" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Brookside__Dissolve.shp,TYPE,-1,-1;TECHNOLOGY "Technology of Transmission" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Brookside__Dissolve.shp,TECHNOLOGY,-1,-1;DOWNSTREAM "Downstream Speed (Mbps)" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Brookside__Dissolve.shp,DOWNSTREAM,-1,-1;UPSTREAM "Upstream Speed (Mbps)" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Brookside__Dissolve.shp,UPSTREAM_S,-1,-1;HOUSEHOLDS "Households" true true false 4 Long 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Brookside__Dissolve.shp,HOUSEHOL_1,-1,-1;APP_DATE "Application Date" true true false 8 Date 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Brookside__Dissolve.shp,APPLICATIO,-1,-1;APP_TYPE "Application Type" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Brookside__Dissolve.shp,Applicat_1,-1,-1;REQ_AMT "Requested Amount" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Brookside__Dissolve.shp,REQUESTED_,-1,-1;APPR_STAT "Approval Status" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Brookside__Dissolve.shp,APPROVAL_S,-1,-1;APPR_DATE "Approval Date" true true false 8 Date 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Brookside__Dissolve.shp,DATE,-1,-1;GRANT_AMT "Grant Amount" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Brookside__Dissolve.shp,GRANT_AMOU,-1,-1;FUND_LEVEL "Funding Level" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Brookside__Dissolve.shp,FUNDING_LE,-1,-1;RESOLUTION "Resolution" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Brookside__Dissolve.shp,RESOLUTION,-1,-1;Shape_Length "Shape_Length" false true true 8 Double 0 0 ,First,#;Shape_Area "Shape_Area" false true true 8 Double 0 0 ,First,#" # Append 'D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Country_Meadows_Dissolve.shp' "D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects" NO_TEST "PROVIDER "Provider Name" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Country_Meadows_Dissolve.shp,PROVIDER_1,-1,-1;DBA "DBA Name" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Country_Meadows_Dissolve.shp,DBA_,-1,-1;FRN "FRN" true true false 10 Text 0 0 ,First,#;PROJ_NAME "Project Name" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Country_Meadows_Dissolve.shp,NAME,-1,-1;PROJ_TYPE "Project Type" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Country_Meadows_Dissolve.shp,TYPE,-1,-1;TECHNOLOGY "Technology of Transmission" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Country_Meadows_Dissolve.shp,TECHNOLOGY,-1,-1;DOWNSTREAM "Downstream Speed (Mbps)" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Country_Meadows_Dissolve.shp,DOWNSTREAM,-1,-1;UPSTREAM "Upstream Speed (Mbps)" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Country_Meadows_Dissolve.shp,UPSTREAM_S,-1,-1;HOUSEHOLDS "Households" true true false 4 Long 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Country_Meadows_Dissolve.shp,HOUSEHOL_1,-1,-1;APP_DATE "Application Date" true true false 8 Date 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Country_Meadows_Dissolve.shp,APPLICATIO,-1,-1;APP_TYPE "Application Type" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Country_Meadows_Dissolve.shp,TYPE,-1,-1;REQ_AMT "Requested Amount" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Country_Meadows_Dissolve.shp,REQUESTED_,-1,-1;APPR_STAT "Approval Status" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Country_Meadows_Dissolve.shp,APPROVAL_S,-1,-1;APPR_DATE "Approval Date" true true false 8 Date 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Country_Meadows_Dissolve.shp,DATE,-1,-1;GRANT_AMT "Grant Amount" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Country_Meadows_Dissolve.shp,GRANT_AMOU,-1,-1;FUND_LEVEL "Funding Level" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Country_Meadows_Dissolve.shp,FUNDING_LE,-1,-1;RESOLUTION "Resolution" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Country_Meadows_Dissolve.shp,RESOLUTION,-1,-1;Shape_Length "Shape_Length" false true true 8 Double 0 0 ,First,#;Shape_Area "Shape_Area" false true true 8 Double 0 0 ,First,#" # CalculateField CASF_Approved_Projects APP_TYPE "CPCN" VB # Append 'D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_El_Dorado_Dissolve.shp' "D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects" NO_TEST "PROVIDER "Provider Name" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_El_Dorado_Dissolve.shp,PROVIDER_1,-1,-1;DBA "DBA Name" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_El_Dorado_Dissolve.shp,DBA_,-1,-1;FRN "FRN" true true false 10 Text 0 0 ,First,#;PROJ_NAME "Project Name" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_El_Dorado_Dissolve.shp,NAME,-1,-1;PROJ_TYPE "Project Type" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_El_Dorado_Dissolve.shp,TYPE,-1,-1;TECHNOLOGY "Technology of Transmission" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_El_Dorado_Dissolve.shp,TECHNOLOGY,-1,-1;DOWNSTREAM "Downstream Speed (Mbps)" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_El_Dorado_Dissolve.shp,DOWNSTREAM,-1,-1;UPSTREAM "Upstream Speed (Mbps)" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_El_Dorado_Dissolve.shp,UPSTREAM_S,-1,-1;HOUSEHOLDS "Households" true true false 4 Long 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_El_Dorado_Dissolve.shp,HOUSEHOL_1,-1,-1;APP_DATE "Application Date" true true false 8 Date 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_El_Dorado_Dissolve.shp,APPLICATIO,-1,-1;APP_TYPE "Application Type" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_El_Dorado_Dissolve.shp,TYPE,-1,-1;REQ_AMT "Requested Amount" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_El_Dorado_Dissolve.shp,REQUESTED_,-1,-1;APPR_STAT "Approval Status" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_El_Dorado_Dissolve.shp,DATE,-1,-1;APPR_DATE "Approval Date" true true false 8 Date 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_El_Dorado_Dissolve.shp,DATE,-1,-1;GRANT_AMT "Grant Amount" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_El_Dorado_Dissolve.shp,GRANT_AMOU,-1,-1;FUND_LEVEL "Funding Level" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_El_Dorado_Dissolve.shp,FUNDING_LE,-1,-1;RESOLUTION "Resolution" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_El_Dorado_Dissolve.shp,RESOLUTION,-1,-1;Shape_Length "Shape_Length" false true true 8 Double 0 0 ,First,#;Shape_Area "Shape_Area" false true true 8 Double 0 0 ,First,#" # CalculateField CASF_Approved_Projects APPR_STAT "Approved" VB # CalculateField CASF_Approved_Projects APP_TYPE "CPCN" VB # Append 'D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Foothill_Terrace_Dissolve.shp';'D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Los_Alisos_Dissolve.shp' "D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects" NO_TEST "PROVIDER "Provider Name" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Foothill_Terrace_Dissolve.shp,PROVIDER_1,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Los_Alisos_Dissolve.shp,PROVIDER_1,-1,-1;DBA "DBA Name" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Foothill_Terrace_Dissolve.shp,DBA_,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Los_Alisos_Dissolve.shp,DBA_,-1,-1;FRN "FRN" true true false 10 Text 0 0 ,First,#;PROJ_NAME "Project Name" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Foothill_Terrace_Dissolve.shp,NAME,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Los_Alisos_Dissolve.shp,NAME,-1,-1;PROJ_TYPE "Project Type" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Foothill_Terrace_Dissolve.shp,TYPE,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Los_Alisos_Dissolve.shp,TYPE,-1,-1;TECHNOLOGY "Technology of Transmission" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Foothill_Terrace_Dissolve.shp,TECHNOLOGY,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Los_Alisos_Dissolve.shp,TECHNOLOGY,-1,-1;DOWNSTREAM "Downstream Speed (Mbps)" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Foothill_Terrace_Dissolve.shp,DOWNSTREAM,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Los_Alisos_Dissolve.shp,DOWNSTREAM,-1,-1;UPSTREAM "Upstream Speed (Mbps)" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Foothill_Terrace_Dissolve.shp,UPSTREAM_S,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Los_Alisos_Dissolve.shp,UPSTREAM_S,-1,-1;HOUSEHOLDS "Households" true true false 4 Long 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Los_Alisos_Dissolve.shp,HOUSEHOLDS,-1,-1;APP_DATE "Application Date" true true false 8 Date 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Foothill_Terrace_Dissolve.shp,APPLICATIO,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Los_Alisos_Dissolve.shp,APPLICATIO,-1,-1;APP_TYPE "Application Type" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Foothill_Terrace_Dissolve.shp,Applicat_1,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Los_Alisos_Dissolve.shp,Applicat_1,-1,-1;REQ_AMT "Requested Amount" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Foothill_Terrace_Dissolve.shp,REQUESTED_,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Los_Alisos_Dissolve.shp,REQUESTED_,-1,-1;APPR_STAT "Approval Status" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Foothill_Terrace_Dissolve.shp,APPROVAL_S,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Los_Alisos_Dissolve.shp,APPROVAL_S,-1,-1;APPR_DATE "Approval Date" true true false 8 Date 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Foothill_Terrace_Dissolve.shp,DATE,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Los_Alisos_Dissolve.shp,DATE,-1,-1;GRANT_AMT "Grant Amount" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Foothill_Terrace_Dissolve.shp,GRANT_AMOU,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Los_Alisos_Dissolve.shp,GRANT_AMOU,-1,-1;FUND_LEVEL "Funding Level" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Foothill_Terrace_Dissolve.shp,FUNDING_LE,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Los_Alisos_Dissolve.shp,FUNDING_LE,-1,-1;RESOLUTION "Resolution" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Foothill_Terrace_Dissolve.shp,RESOLUTION,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Los_Alisos_Dissolve.shp,RESOLUTION,-1,-1;Shape_Length "Shape_Length" false true true 8 Double 0 0 ,First,#;Shape_Area "Shape_Area" false true true 8 Double 0 0 ,First,#" # CalculateField CASF_Approved_Projects HOUSEHOLDS 308 VB # Append 'D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Monterey_Manor_Dissolve.shp';'D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Plaza_Village_Dissolve.shp';'D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Soboba_Springs_Dissolve.shp';'D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Villa_Montclair_Dissolve.shp';'D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\DigitalPath_Sutter_Placer_Dissolve.shp';'D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Hunter_Hoopa_Valley_Dissolve.shp';'D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\PST_Scott_Rd_Dissolve.shp';'D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Race_Gigafy_Williams_Dissolve.shp' "D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\CASF_Projects_Data.gdb\CASF_Approved_Projects" NO_TEST "PROVIDER "Provider Name" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Hunter_Hoopa_Valley_Dissolve.shp,PROVIDER,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\PST_Scott_Rd_Dissolve.shp,PROVIDER,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Monterey_Manor_Dissolve.shp,PROVIDER_1,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Plaza_Village_Dissolve.shp,PROVIDER_1,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Soboba_Springs_Dissolve.shp,PROVIDER_1,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Villa_Montclair_Dissolve.shp,PROVIDER_1,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\DigitalPath_Sutter_Placer_Dissolve.shp,PROVIDER_1,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Race_Gigafy_Williams_Dissolve.shp,PROVIDER_1,-1,-1;DBA "DBA Name" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\DigitalPath_Sutter_Placer_Dissolve.shp,DBA,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Hunter_Hoopa_Valley_Dissolve.shp,DBA,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\PST_Scott_Rd_Dissolve.shp,DBA,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Race_Gigafy_Williams_Dissolve.shp,DBA,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Monterey_Manor_Dissolve.shp,DBA_,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Plaza_Village_Dissolve.shp,DBA_,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Soboba_Springs_Dissolve.shp,DBA_,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Villa_Montclair_Dissolve.shp,DBA_,-1,-1;FRN "FRN" true true false 10 Text 0 0 ,First,#;PROJ_NAME "Project Name" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Monterey_Manor_Dissolve.shp,NAME,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Plaza_Village_Dissolve.shp,NAME,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Soboba_Springs_Dissolve.shp,NAME,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Villa_Montclair_Dissolve.shp,NAME,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\DigitalPath_Sutter_Placer_Dissolve.shp,NAME,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Hunter_Hoopa_Valley_Dissolve.shp,NAME,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\PST_Scott_Rd_Dissolve.shp,NAME_1,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Race_Gigafy_Williams_Dissolve.shp,NAME,-1,-1;PROJ_TYPE "Project Type" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Monterey_Manor_Dissolve.shp,TYPE,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Plaza_Village_Dissolve.shp,TYPE,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Soboba_Springs_Dissolve.shp,TYPE,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Villa_Montclair_Dissolve.shp,TYPE,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\DigitalPath_Sutter_Placer_Dissolve.shp,TYPE,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Hunter_Hoopa_Valley_Dissolve.shp,TYPE,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\PST_Scott_Rd_Dissolve.shp,TYPE,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Race_Gigafy_Williams_Dissolve.shp,TYPE,-1,-1;TECHNOLOGY "Technology of Transmission" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Monterey_Manor_Dissolve.shp,TECHNOLOGY,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Plaza_Village_Dissolve.shp,TECHNOLOGY,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Soboba_Springs_Dissolve.shp,TECHNOLOGY,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Villa_Montclair_Dissolve.shp,TECHNOLOGY,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\DigitalPath_Sutter_Placer_Dissolve.shp,TECHNOLOGY,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Hunter_Hoopa_Valley_Dissolve.shp,TECHNOLOGY,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\PST_Scott_Rd_Dissolve.shp,TECHNOLOGY,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Race_Gigafy_Williams_Dissolve.shp,TECHNOLOGY,-1,-1;DOWNSTREAM "Downstream Speed (Mbps)" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Monterey_Manor_Dissolve.shp,DOWNSTREAM,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Plaza_Village_Dissolve.shp,DOWNSTREAM,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Soboba_Springs_Dissolve.shp,DOWNSTREAM,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Villa_Montclair_Dissolve.shp,DOWNSTREAM,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\DigitalPath_Sutter_Placer_Dissolve.shp,DOWNSTREAM,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Hunter_Hoopa_Valley_Dissolve.shp,DOWNSTREAM,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\PST_Scott_Rd_Dissolve.shp,DOWNSTREAM,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Race_Gigafy_Williams_Dissolve.shp,DOWNSTREAM,-1,-1;UPSTREAM "Upstream Speed (Mbps)" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Monterey_Manor_Dissolve.shp,UPSTREAM_S,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Plaza_Village_Dissolve.shp,UPSTREAM_S,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Soboba_Springs_Dissolve.shp,UPSTREAM_S,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Villa_Montclair_Dissolve.shp,UPSTREAM_S,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\DigitalPath_Sutter_Placer_Dissolve.shp,UPSTREAM_S,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Hunter_Hoopa_Valley_Dissolve.shp,UPSTREAM_S,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\PST_Scott_Rd_Dissolve.shp,UPSTREAM_S,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Race_Gigafy_Williams_Dissolve.shp,UPSTREAM_S,-1,-1;HOUSEHOLDS "Households" true true false 4 Long 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Monterey_Manor_Dissolve.shp,HOUSEHOLDS,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Hunter_Hoopa_Valley_Dissolve.shp,HOUSEHOLDS,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\PST_Scott_Rd_Dissolve.shp,HOUSEHOLDS,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Race_Gigafy_Williams_Dissolve.shp,HOUSEHOLDS,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Plaza_Village_Dissolve.shp,HOUSEHOL_1,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Soboba_Springs_Dissolve.shp,HOUSEHOL_1,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Villa_Montclair_Dissolve.shp,HOUSEHOL_1,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\DigitalPath_Sutter_Placer_Dissolve.shp,HOUSEHOL_1,-1,-1;APP_DATE "Application Date" true true false 8 Date 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Monterey_Manor_Dissolve.shp,APPLICATIO,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Plaza_Village_Dissolve.shp,APPLICATIO,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Soboba_Springs_Dissolve.shp,APPLICATIO,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Villa_Montclair_Dissolve.shp,APPLICATIO,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\DigitalPath_Sutter_Placer_Dissolve.shp,APPLICATIO,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Hunter_Hoopa_Valley_Dissolve.shp,APPLICATIO,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\PST_Scott_Rd_Dissolve.shp,APPLICATIO,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Race_Gigafy_Williams_Dissolve.shp,APPLICATIO,-1,-1;APP_TYPE "Application Type" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Monterey_Manor_Dissolve.shp,Applicat_1,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Plaza_Village_Dissolve.shp,Applicat_1,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Soboba_Springs_Dissolve.shp,Applicat_1,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Villa_Montclair_Dissolve.shp,Applicat_1,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\DigitalPath_Sutter_Placer_Dissolve.shp,Applicat_1,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Hunter_Hoopa_Valley_Dissolve.shp,APPLICAT_1,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\PST_Scott_Rd_Dissolve.shp,Applicat_1,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Race_Gigafy_Williams_Dissolve.shp,Applicat_1,-1,-1;REQ_AMT "Requested Amount" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Monterey_Manor_Dissolve.shp,REQUESTED_,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Plaza_Village_Dissolve.shp,REQUESTED_,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Soboba_Springs_Dissolve.shp,REQUESTED_,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Villa_Montclair_Dissolve.shp,REQUESTED_,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\DigitalPath_Sutter_Placer_Dissolve.shp,REQUESTED_,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Hunter_Hoopa_Valley_Dissolve.shp,REQUESTED_,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\PST_Scott_Rd_Dissolve.shp,REQUESTED_,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Race_Gigafy_Williams_Dissolve.shp,REQUESTED_,-1,-1;APPR_STAT "Approval Status" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Monterey_Manor_Dissolve.shp,APPROVAL_S,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Plaza_Village_Dissolve.shp,APPROVAL_S,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Soboba_Springs_Dissolve.shp,APPROVAL_S,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Villa_Montclair_Dissolve.shp,APPROVAL_S,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\DigitalPath_Sutter_Placer_Dissolve.shp,APPROVAL_S,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Hunter_Hoopa_Valley_Dissolve.shp,APPROVAL_S,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\PST_Scott_Rd_Dissolve.shp,APPROVAL_S,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Race_Gigafy_Williams_Dissolve.shp,APPROVAL_S,-1,-1;APPR_DATE "Approval Date" true true false 8 Date 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Monterey_Manor_Dissolve.shp,DATE,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Plaza_Village_Dissolve.shp,DATE,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Soboba_Springs_Dissolve.shp,DATE,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Villa_Montclair_Dissolve.shp,DATE,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\DigitalPath_Sutter_Placer_Dissolve.shp,DATE,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Hunter_Hoopa_Valley_Dissolve.shp,DATE,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\PST_Scott_Rd_Dissolve.shp,DATE,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Race_Gigafy_Williams_Dissolve.shp,DATE,-1,-1;GRANT_AMT "Grant Amount" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Monterey_Manor_Dissolve.shp,GRANT_AMOU,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Plaza_Village_Dissolve.shp,GRANT_AMOU,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Soboba_Springs_Dissolve.shp,GRANT_AMOU,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Villa_Montclair_Dissolve.shp,GRANT_AMOU,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\DigitalPath_Sutter_Placer_Dissolve.shp,GRANT_AMOU,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Hunter_Hoopa_Valley_Dissolve.shp,GRANT_AMOU,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\PST_Scott_Rd_Dissolve.shp,GRANT_AMOU,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Race_Gigafy_Williams_Dissolve.shp,GRANT_AMOU,-1,-1;FUND_LEVEL "Funding Level" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Monterey_Manor_Dissolve.shp,FUNDING_LE,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Plaza_Village_Dissolve.shp,FUNDING_LE,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Soboba_Springs_Dissolve.shp,FUNDING_LE,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Villa_Montclair_Dissolve.shp,FUNDING_LE,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\DigitalPath_Sutter_Placer_Dissolve.shp,FUNDING_LE,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Hunter_Hoopa_Valley_Dissolve.shp,FUNDING_LE,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\PST_Scott_Rd_Dissolve.shp,FUNDING_LE,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Race_Gigafy_Williams_Dissolve.shp,FUNDING_LE,-1,-1;RESOLUTION "Resolution" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Monterey_Manor_Dissolve.shp,RESOLUTION,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Plaza_Village_Dissolve.shp,RESOLUTION,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Soboba_Springs_Dissolve.shp,RESOLUTION,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Charter_Villa_Montclair_Dissolve.shp,RESOLUTION,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\DigitalPath_Sutter_Placer_Dissolve.shp,RESOLUTION,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Hunter_Hoopa_Valley_Dissolve.shp,RESOLUTION,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\PST_Scott_Rd_Dissolve.shp,RESOLUTION,-1,-1,D:\PROJECTS\CPUC_2020\LAYERS\WEB\CASF\2020 Approved CASF Last Mile Projects\Race_Gigafy_Williams_Dissolve.shp,RESOLUTION,-1,-1;Shape_Length "Shape_Length" false true true 8 Double 0 0 ,First,#;Shape_Area "Shape_Area" false true true 8 Double 0 0 ,First,#" # CalculateField CASF_Approved_Projects RESOLUTION "Ministerial Letter" VB # CalculateField CASF_Approved_Projects FRN "0025646373" VB # CalculateField CASF_Approved_Projects FRN "0022537807" VB # CalculateField CASF_Approved_Projects FRN "0009558909" VB # CalculateField CASF_Approved_Projects FRN "0017389735" VB # Merge D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects2 "PROVNAME "Provider Name" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects,PROVIDER,-1,-1;DBA "DBA Name" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects,DBA,-1,-1;FRN "FRN" true true false 10 Text 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects,FRN,-1,-1;PROJNAME "Project Name" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects,PROJ_NAME,-1,-1;PROJTYPE "Project Type" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects,PROJ_TYPE,-1,-1;TECHNOLOGY "Technology of Transmission" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects,TECHNOLOGY,-1,-1;DOWNSTREAM "Downstream Speed (Mbps)" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects,DOWNSTREAM,-1,-1;UPSTREAM "Upstream Speed (Mbps)" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects,UPSTREAM,-1,-1;HOUSEHOLDS "Households" true true false 4 Long 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects,HOUSEHOLDS,-1,-1;APP_DATE "Application Date" true true false 8 Date 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects,APP_DATE,-1,-1;APPTYPE "Application Type" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects,APP_TYPE,-1,-1;REQAMT "Requested Amount" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects,REQ_AMT,-1,-1;APPRSTAT "Approval Status" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects,APPR_STAT,-1,-1;APPRDATE "Approval Date" true true false 8 Date 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects,APPR_DATE,-1,-1;GRANTAMT "Grant Amount" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects,GRANT_AMT,-1,-1;FUNDLEVEL "Funding Level" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects,FUND_LEVEL,-1,-1;RESOLUTION "Resolution" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects,RESOLUTION,-1,-1;Shape_Length "Shape_Length" false true true 8 Double 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects,Shape_Area,-1,-1" Append D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects2 NO_TEST "PROVNAME "Provider Name" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects,PROVNAME,-1,-1;DBA "DBA Name" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects,DBANAME,-1,-1;FRN "FRN" true true false 10 Text 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects,FRN,-1,-1;PROJNAME "Project Name" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects,PROJNAME,-1,-1;PROJTYPE "Project Type" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects,PROJTYPE,-1,-1;TECHNOLOGY "Technology of Transmission" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects,TRANSTECH,-1,-1;DOWNSTREAM "Downstream Speed (Mbps)" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects,PROPDSS,-1,-1;UPSTREAM "Upstream Speed (Mbps)" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects,PROPUSS,-1,-1;HOUSEHOLDS "Households" true true false 4 Long 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects,HOUSEHOLDS,-1,-1;APP_DATE "Application Date" true true false 8 Date 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects,APPDATE,-1,-1;APPTYPE "Application Type" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects,APPLTYPE,-1,-1;REQAMT "Requested Amount" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects,APPAMT,-1,-1;APPRSTAT "Approval Status" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects,APPRSTAT,-1,-1;APPRDATE "Approval Date" true true false 8 Date 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects,GRANTDATE,-1,-1;GRANTAMT "Grant Amount" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects,GRANTAMT,-1,-1;FUNDLEVEL "Funding Level" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects,GRANTPCT,-1,-1;RESOLUTION "Resolution" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects,RESNO,-1,-1;Shape_Length "Shape_Length" false true true 8 Double 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects,SHAPE_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects,SHAPE_Area,-1,-1" # CalculateField CASF_Approved_Projects APPRSTAT "Approved" VB # CalculateField CASF_Approved_Projects TECHNOLOGY "Cable Modem DOCSIS 3.1" VB # CalculateField CASF_Approved_Projects TECHNOLOGY "Optical Carrier/Fiber to the End User" VB # CalculateField CASF_Approved_Projects TECHNOLOGY "VDSL" VB # CalculateField CASF_Approved_Projects TECHNOLOGY "Terrestrial Fixed Wireless" VB # CalculateField CASF_Approved_Projects FRN "" VB # CalculateField CASF_Approved_Projects FUNDLEVEL "[FUNDLEVEL] / 100" VB # CalculateField CASF_Approved_Projects GRANTAMT 692888.58 VB # TruncateTable D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects Append 'D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF Approved Infrastructure Grant Projects as of 15 JAN 2022\CASF_All_Approved_Projects_January_2022.shp' D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF_Projects_Data.gdb\CASF_Approved_Projects NO_TEST "PROVNAME "Provider Name" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF Approved Infrastructure Grant Projects as of 15 JAN 2022\CASF_All_Approved_Projects_January_2022.shp,PROVNAME,-1,-1;DBA "DBA Name" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF Approved Infrastructure Grant Projects as of 15 JAN 2022\CASF_All_Approved_Projects_January_2022.shp,DBA,-1,-1;FRN "FRN" true true false 10 Text 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF Approved Infrastructure Grant Projects as of 15 JAN 2022\CASF_All_Approved_Projects_January_2022.shp,FRN,-1,-1;PROJNAME "Project Name" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF Approved Infrastructure Grant Projects as of 15 JAN 2022\CASF_All_Approved_Projects_January_2022.shp,PROJNAME,-1,-1;PROJTYPE "Project Type" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF Approved Infrastructure Grant Projects as of 15 JAN 2022\CASF_All_Approved_Projects_January_2022.shp,PROJTYPE,-1,-1;TECHNOLOGY "Technology of Transmission" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF Approved Infrastructure Grant Projects as of 15 JAN 2022\CASF_All_Approved_Projects_January_2022.shp,TECHNOLOGY,-1,-1;DOWNSTREAM "Downstream Speed (Mbps)" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF Approved Infrastructure Grant Projects as of 15 JAN 2022\CASF_All_Approved_Projects_January_2022.shp,DOWNSTREAM,-1,-1;UPSTREAM "Upstream Speed (Mbps)" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF Approved Infrastructure Grant Projects as of 15 JAN 2022\CASF_All_Approved_Projects_January_2022.shp,UPSTREAM,-1,-1;HOUSEHOLDS "Households" true true false 4 Long 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF Approved Infrastructure Grant Projects as of 15 JAN 2022\CASF_All_Approved_Projects_January_2022.shp,HOUSEHOLDS,-1,-1;APP_DATE "Application Date" true true false 8 Date 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF Approved Infrastructure Grant Projects as of 15 JAN 2022\CASF_All_Approved_Projects_January_2022.shp,APP_DATE,-1,-1;APPTYPE "Application Type" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF Approved Infrastructure Grant Projects as of 15 JAN 2022\CASF_All_Approved_Projects_January_2022.shp,APPTYPE,-1,-1;REQAMT "Requested Amount" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF Approved Infrastructure Grant Projects as of 15 JAN 2022\CASF_All_Approved_Projects_January_2022.shp,REQAMT,-1,-1;APPRSTAT "Approval Status" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF Approved Infrastructure Grant Projects as of 15 JAN 2022\CASF_All_Approved_Projects_January_2022.shp,APPRSTAT,-1,-1;APPRDATE "Approval Date" true true false 8 Date 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF Approved Infrastructure Grant Projects as of 15 JAN 2022\CASF_All_Approved_Projects_January_2022.shp,APPRDATE,-1,-1;GRANTAMT "Grant Amount" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF Approved Infrastructure Grant Projects as of 15 JAN 2022\CASF_All_Approved_Projects_January_2022.shp,GRANTAMT,-1,-1;FUNDLEVEL "Funding Level" true true false 4 Float 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF Approved Infrastructure Grant Projects as of 15 JAN 2022\CASF_All_Approved_Projects_January_2022.shp,FUNDLEVEL,-1,-1;RESOLUTION "Resolution" true true false 50 Text 0 0 ,First,#,D:\PROJECTS\CPUC_WEB\DATA\CASF\CASF Approved Infrastructure Grant Projects as of 15 JAN 2022\CASF_All_Approved_Projects_January_2022.shp,RESOLUTION,-1,-1;Shape_Length "Shape_Length" false true true 8 Double 0 0 ,First,#;Shape_Area "Shape_Area" false true true 8 Double 0 0 ,First,#" # Append Cruzio_Projects_Add_20221024_dissolve_join "CASF Approved Last-Mile Projects" "Use the field map to reconcile field differences" "PROVNAME "Provider Name" true true false 50 Text 0 0,First,#,E:\Projects\CASF\Cruzio_Projects_Add_20221024_dissolve_join\Cruzio_Projects_Add_20221024_dissolve_join.shp,PROVNAME,0,50;DBA "DBA Name" true true false 50 Text 0 0,First,#,E:\Projects\CASF\Cruzio_Projects_Add_20221024_dissolve_join\Cruzio_Projects_Add_20221024_dissolve_join.shp,DBA,0,50;FRN "FRN" true true false 10 Text 0 0,First,#,E:\Projects\CASF\Cruzio_Projects_Add_20221024_dissolve_join\Cruzio_Projects_Add_20221024_dissolve_join.shp,FRN,0,10;PROJNAME "Project Name" true true false 50 Text 0 0,First,#,E:\Projects\CASF\Cruzio_Projects_Add_20221024_dissolve_join\Cruzio_Projects_Add_20221024_dissolve_join.shp,PROJNAME,0,50;PROJTYPE "Project Type" true true false 50 Text 0 0,First,#,E:\Projects\CASF\Cruzio_Projects_Add_20221024_dissolve_join\Cruzio_Projects_Add_20221024_dissolve_join.shp,PROJTYPE,0,50;TECHNOLOGY "Technology of Transmission" true true false 50 Text 0 0,First,#,E:\Projects\CASF\Cruzio_Projects_Add_20221024_dissolve_join\Cruzio_Projects_Add_20221024_dissolve_join.shp,TECHNOLOGY,0,50;DOWNSTREAM "Downstream Speed (Mbps)" true true false 4 Float 0 0,First,#,E:\Projects\CASF\Cruzio_Projects_Add_20221024_dissolve_join\Cruzio_Projects_Add_20221024_dissolve_join.shp,DOWNSTREAM,-1,-1;UPSTREAM "Upstream Speed (Mbps)" true true false 4 Float 0 0,First,#,E:\Projects\CASF\Cruzio_Projects_Add_20221024_dissolve_join\Cruzio_Projects_Add_20221024_dissolve_join.shp,UPSTREAM,-1,-1;HOUSEHOLDS "Households" true true false 4 Long 0 0,First,#,E:\Projects\CASF\Cruzio_Projects_Add_20221024_dissolve_join\Cruzio_Projects_Add_20221024_dissolve_join.shp,HOUSEHOLDS,-1,-1;APP_DATE "Application Date" true true false 8 Date 0 0,First,#,E:\Projects\CASF\Cruzio_Projects_Add_20221024_dissolve_join\Cruzio_Projects_Add_20221024_dissolve_join.shp,APP_DATE,-1,-1;APPTYPE "Application Type" true true false 50 Text 0 0,First,#,E:\Projects\CASF\Cruzio_Projects_Add_20221024_dissolve_join\Cruzio_Projects_Add_20221024_dissolve_join.shp,APPTYPE,0,50;REQAMT "Requested Amount" true true false 4 Float 0 0,First,#,E:\Projects\CASF\Cruzio_Projects_Add_20221024_dissolve_join\Cruzio_Projects_Add_20221024_dissolve_join.shp,REQAMT,-1,-1;APPRSTAT "Approval Status" true true false 50 Text 0 0,First,#,E:\Projects\CASF\Cruzio_Projects_Add_20221024_dissolve_join\Cruzio_Projects_Add_20221024_dissolve_join.shp,APPRSTAT,0,50;APPRDATE "Approval Date" true true false 8 Date 0 0,First,#,E:\Projects\CASF\Cruzio_Projects_Add_20221024_dissolve_join\Cruzio_Projects_Add_20221024_dissolve_join.shp,APPRDATE,-1,-1;GRANTAMT "Grant Amount" true true false 4 Float 0 0,First,#,E:\Projects\CASF\Cruzio_Projects_Add_20221024_dissolve_join\Cruzio_Projects_Add_20221024_dissolve_join.shp,GRANTAMT,-1,-1;FUNDLEVEL "Funding Level" true true false 4 Float 0 0,First,#,E:\Projects\CASF\Cruzio_Projects_Add_20221024_dissolve_join\Cruzio_Projects_Add_20221024_dissolve_join.shp,FUNDLEVEL,-1,-1;RESOLUTION "Resolution" true true false 50 Text 0 0,First,#,E:\Projects\CASF\Cruzio_Projects_Add_20221024_dissolve_join\Cruzio_Projects_Add_20221024_dissolve_join.shp,RESOLUTION,0,50" # # Append E:\Projects\CASF\Cruzio_San_Jerardo_Project_Area_11142022\Cruzio_San_Jerardo_Project_Area_11142022.shp "CASF Approved Last-Mile Projects" "Use the field map to reconcile field differences" "PROVNAME "Provider Name" true true false 50 Text 0 0,First,#,E:\Projects\CASF\Cruzio_San_Jerardo_Project_Area_11142022\Cruzio_San_Jerardo_Project_Area_11142022.shp,PROVNAME,0,50;DBA "DBA Name" true true false 50 Text 0 0,First,#,E:\Projects\CASF\Cruzio_San_Jerardo_Project_Area_11142022\Cruzio_San_Jerardo_Project_Area_11142022.shp,DBA,0,50;FRN "FRN" true true false 10 Text 0 0,First,#,E:\Projects\CASF\Cruzio_San_Jerardo_Project_Area_11142022\Cruzio_San_Jerardo_Project_Area_11142022.shp,FRN,0,10;PROJNAME "Project Name" true true false 50 Text 0 0,First,#,E:\Projects\CASF\Cruzio_San_Jerardo_Project_Area_11142022\Cruzio_San_Jerardo_Project_Area_11142022.shp,PROJNAME,0,50;PROJTYPE "Project Type" true true false 50 Text 0 0,First,#,E:\Projects\CASF\Cruzio_San_Jerardo_Project_Area_11142022\Cruzio_San_Jerardo_Project_Area_11142022.shp,PROJTYPE,0,50;TECHNOLOGY "Technology of Transmission" true true false 50 Text 0 0,First,#,E:\Projects\CASF\Cruzio_San_Jerardo_Project_Area_11142022\Cruzio_San_Jerardo_Project_Area_11142022.shp,TECHNOLOGY,0,50;DOWNSTREAM "Downstream Speed (Mbps)" true true false 4 Float 0 0,First,#,E:\Projects\CASF\Cruzio_San_Jerardo_Project_Area_11142022\Cruzio_San_Jerardo_Project_Area_11142022.shp,DOWNSTREAM,-1,-1;UPSTREAM "Upstream Speed (Mbps)" true true false 4 Float 0 0,First,#,E:\Projects\CASF\Cruzio_San_Jerardo_Project_Area_11142022\Cruzio_San_Jerardo_Project_Area_11142022.shp,UPSTREAM,-1,-1;HOUSEHOLDS "Households" true true false 4 Long 0 0,First,#,E:\Projects\CASF\Cruzio_San_Jerardo_Project_Area_11142022\Cruzio_San_Jerardo_Project_Area_11142022.shp,HOUSEHOLDS,-1,-1;APP_DATE "Application Date" true true false 8 Date 0 0,First,#,E:\Projects\CASF\Cruzio_San_Jerardo_Project_Area_11142022\Cruzio_San_Jerardo_Project_Area_11142022.shp,APP_DATE,-1,-1;APPTYPE "Application Type" true true false 50 Text 0 0,First,#,E:\Projects\CASF\Cruzio_San_Jerardo_Project_Area_11142022\Cruzio_San_Jerardo_Project_Area_11142022.shp,APPTYPE,0,50;REQAMT "Requested Amount" true true false 4 Float 0 0,First,#,E:\Projects\CASF\Cruzio_San_Jerardo_Project_Area_11142022\Cruzio_San_Jerardo_Project_Area_11142022.shp,REQAMT,-1,-1;APPRSTAT "Approval Status" true true false 50 Text 0 0,First,#,E:\Projects\CASF\Cruzio_San_Jerardo_Project_Area_11142022\Cruzio_San_Jerardo_Project_Area_11142022.shp,APPRSTAT,0,50;APPRDATE "Approval Date" true true false 8 Date 0 0,First,#,E:\Projects\CASF\Cruzio_San_Jerardo_Project_Area_11142022\Cruzio_San_Jerardo_Project_Area_11142022.shp,APPRDATE,-1,-1;GRANTAMT "Grant Amount" true true false 4 Float 0 0,First,#,E:\Projects\CASF\Cruzio_San_Jerardo_Project_Area_11142022\Cruzio_San_Jerardo_Project_Area_11142022.shp,GRANTAMT,-1,-1;FUNDLEVEL "Funding Level" true true false 4 Float 0 0,First,#,E:\Projects\CASF\Cruzio_San_Jerardo_Project_Area_11142022\Cruzio_San_Jerardo_Project_Area_11142022.shp,FUNDLEVEL,-1,-1;RESOLUTION "Resolution" true true false 50 Text 0 0,First,#,E:\Projects\CASF\Cruzio_San_Jerardo_Project_Area_11142022\Cruzio_San_Jerardo_Project_Area_11142022.shp,RESOLUTION,0,50" # # Append E:\Projects\CASF\Cruzio_San_Jerardo_Project_Area_11182022\Cruzio_San_Jerardo_Project_Area_11182022.shp "CASF Approved Last-Mile Projects" "Use the field map to reconcile field differences" "PROVNAME "Provider Name" true true false 50 Text 0 0,First,#,E:\Projects\CASF\Cruzio_San_Jerardo_Project_Area_11182022\Cruzio_San_Jerardo_Project_Area_11182022.shp,PROVNAME,0,50;DBA "DBA Name" true true false 50 Text 0 0,First,#,E:\Projects\CASF\Cruzio_San_Jerardo_Project_Area_11182022\Cruzio_San_Jerardo_Project_Area_11182022.shp,DBA,0,50;FRN "FRN" true true false 10 Text 0 0,First,#,E:\Projects\CASF\Cruzio_San_Jerardo_Project_Area_11182022\Cruzio_San_Jerardo_Project_Area_11182022.shp,FRN,0,10;PROJNAME "Project Name" true true false 50 Text 0 0,First,#,E:\Projects\CASF\Cruzio_San_Jerardo_Project_Area_11182022\Cruzio_San_Jerardo_Project_Area_11182022.shp,PROJNAME,0,50;PROJTYPE "Project Type" true true false 50 Text 0 0,First,#,E:\Projects\CASF\Cruzio_San_Jerardo_Project_Area_11182022\Cruzio_San_Jerardo_Project_Area_11182022.shp,PROJTYPE,0,50;TECHNOLOGY "Technology of Transmission" true true false 50 Text 0 0,First,#,E:\Projects\CASF\Cruzio_San_Jerardo_Project_Area_11182022\Cruzio_San_Jerardo_Project_Area_11182022.shp,TECHNOLOGY,0,50;DOWNSTREAM "Downstream Speed (Mbps)" true true false 4 Float 0 0,First,#,E:\Projects\CASF\Cruzio_San_Jerardo_Project_Area_11182022\Cruzio_San_Jerardo_Project_Area_11182022.shp,DOWNSTREAM,-1,-1;UPSTREAM "Upstream Speed (Mbps)" true true false 4 Float 0 0,First,#,E:\Projects\CASF\Cruzio_San_Jerardo_Project_Area_11182022\Cruzio_San_Jerardo_Project_Area_11182022.shp,UPSTREAM,-1,-1;HOUSEHOLDS "Households" true true false 4 Long 0 0,First,#,E:\Projects\CASF\Cruzio_San_Jerardo_Project_Area_11182022\Cruzio_San_Jerardo_Project_Area_11182022.shp,HOUSEHOLDS,-1,-1;APP_DATE "Application Date" true true false 8 Date 0 0,First,#,E:\Projects\CASF\Cruzio_San_Jerardo_Project_Area_11182022\Cruzio_San_Jerardo_Project_Area_11182022.shp,APP_DATE,-1,-1;APPTYPE "Application Type" true true false 50 Text 0 0,First,#,E:\Projects\CASF\Cruzio_San_Jerardo_Project_Area_11182022\Cruzio_San_Jerardo_Project_Area_11182022.shp,APPTYPE,0,50;REQAMT "Requested Amount" true true false 4 Float 0 0,First,#,E:\Projects\CASF\Cruzio_San_Jerardo_Project_Area_11182022\Cruzio_San_Jerardo_Project_Area_11182022.shp,REQAMT,-1,-1;APPRSTAT "Approval Status" true true false 50 Text 0 0,First,#,E:\Projects\CASF\Cruzio_San_Jerardo_Project_Area_11182022\Cruzio_San_Jerardo_Project_Area_11182022.shp,APPRSTAT,0,50;APPRDATE "Approval Date" true true false 8 Date 0 0,First,#,E:\Projects\CASF\Cruzio_San_Jerardo_Project_Area_11182022\Cruzio_San_Jerardo_Project_Area_11182022.shp,APPRDATE,-1,-1;GRANTAMT "Grant Amount" true true false 4 Float 0 0,First,#,E:\Projects\CASF\Cruzio_San_Jerardo_Project_Area_11182022\Cruzio_San_Jerardo_Project_Area_11182022.shp,GRANTAMT,-1,-1;FUNDLEVEL "Funding Level" true true false 4 Float 0 0,First,#,E:\Projects\CASF\Cruzio_San_Jerardo_Project_Area_11182022\Cruzio_San_Jerardo_Project_Area_11182022.shp,FUNDLEVEL,-1,-1;RESOLUTION "Resolution" true true false 50 Text 0 0,First,#,E:\Projects\CASF\Cruzio_San_Jerardo_Project_Area_11182022\Cruzio_San_Jerardo_Project_Area_11182022.shp,RESOLUTION,0,50" # # ExportFeatures "Working...\From Hayley Folder\CASF_Approved_Projects" "D:\FRY_TEMP\Projects\CASF (California Advanced Services Fund)\CASF_230215\Data\CASF_Projects_Data_2021.gdb\CASF_Approved_Master_Nov_2022_join" # NOT_USE_ALIAS "PROVNAME "Provider Name" true true false 50 Text 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Projects,CASF_Approved_Projects.PROVNAME,0,50;DBA "DBA Name" true true false 50 Text 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Projects,CASF_Approved_Projects.DBA,0,50;FRN "FRN" true true false 10 Text 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Projects,CASF_Approved_Projects.FRN,0,10;PROJNAME "Project Name" true true false 50 Text 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Projects,CASF_Approved_Projects.PROJNAME,0,50;PROJTYPE "Project Type" true true false 50 Text 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Projects,CASF_Approved_Projects.PROJTYPE,0,50;TECHNOLOGY "Technology of Transmission" true true false 50 Text 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Projects,CASF_Approved_Projects.TECHNOLOGY,0,50;DOWNSTREAM "Downstream Speed (Mbps)" true true false 4 Float 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Projects,CASF_Approved_Projects.DOWNSTREAM,-1,-1;UPSTREAM "Upstream Speed (Mbps)" true true false 4 Float 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Projects,CASF_Approved_Projects.UPSTREAM,-1,-1;HOUSEHOLDS "Households" true true false 4 Long 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Projects,CASF_Approved_Projects.HOUSEHOLDS,-1,-1;APP_DATE "Application Date" true true false 8 Date 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Projects,CASF_Approved_Projects.APP_DATE,-1,-1;APPTYPE "Application Type" true true false 50 Text 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Projects,CASF_Approved_Projects.APPTYPE,0,50;REQAMT "Requested Amount" true true false 4 Float 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Projects,CASF_Approved_Projects.REQAMT,-1,-1;APPRSTAT "Approval Status" true true false 50 Text 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Projects,CASF_Approved_Projects.APPRSTAT,0,50;APPRDATE "Approval Date" true true false 8 Date 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Projects,CASF_Approved_Projects.APPRDATE,-1,-1;GRANTAMT "Grant Amount" true true false 4 Float 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Projects,CASF_Approved_Projects.GRANTAMT,-1,-1;FUNDLEVEL "Funding Level" true true false 4 Float 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Projects,CASF_Approved_Projects.FUNDLEVEL,-1,-1;RESOLUTION "Resolution" true true false 50 Text 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Projects,CASF_Approved_Projects.RESOLUTION,0,50;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Projects,CASF_Approved_Projects.Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Projects,CASF_Approved_Projects.Shape_Area,-1,-1;OBJECTID "OBJECTID" false true false 4 Long 0 9,First,#,Working...\From Hayley Folder\CASF_Approved_Projects,CASF_Project_Master_Nov_2022.OBJECTID,-1,-1;Number "Number" true true false 255 Text 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Projects,CASF_Project_Master_Nov_2022.Number,0,255;PROVNAME "PROVNAME" true true false 255 Text 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Projects,CASF_Project_Master_Nov_2022.PROVNAME,0,255;DBA "DBA" true true false 255 Text 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Projects,CASF_Project_Master_Nov_2022.DBA,0,255;FRN "FRN" true true false 8 Double 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Projects,CASF_Project_Master_Nov_2022.FRN,-1,-1;PROJNAME "PROJNAME" true true false 255 Text 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Projects,CASF_Project_Master_Nov_2022.PROJNAME,0,255;PROJTYPE "PROJTYPE" true true false 255 Text 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Projects,CASF_Project_Master_Nov_2022.PROJTYPE,0,255;TECHNOLOGY "TECHNOLOGY" true true false 255 Text 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Projects,CASF_Project_Master_Nov_2022.TECHNOLOGY,0,255;DOWNSTREAM "DOWNSTREAM" true true false 8 Double 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Projects,CASF_Project_Master_Nov_2022.DOWNSTREAM,-1,-1;UPSTREAM "UPSTREAM" true true false 8 Double 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Projects,CASF_Project_Master_Nov_2022.UPSTREAM,-1,-1;HOUSEHOLDS "HOUSEHOLDS" true true false 8 Double 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Projects,CASF_Project_Master_Nov_2022.HOUSEHOLDS,-1,-1;APP_DATE "APP_DATE" true true false 8 Date 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Projects,CASF_Project_Master_Nov_2022.APP_DATE,-1,-1;APPTYPE "APPTYPE" true true false 255 Text 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Projects,CASF_Project_Master_Nov_2022.APPTYPE,0,255;REQAMT "REQAMT" true true false 8 Double 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Projects,CASF_Project_Master_Nov_2022.REQAMT,-1,-1;APPRSTAT "APPRSTAT" true true false 255 Text 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Projects,CASF_Project_Master_Nov_2022.APPRSTAT,0,255;APPRDATE "APPRDATE" true true false 8 Date 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Projects,CASF_Project_Master_Nov_2022.APPRDATE,-1,-1;GRANTAMT "GRANTAMT" true true false 8 Double 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Projects,CASF_Project_Master_Nov_2022.GRANTAMT,-1,-1;FUNDLEVEL "FUNDLEVEL" true true false 8 Double 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Projects,CASF_Project_Master_Nov_2022.FUNDLEVEL,-1,-1;RESOLUTION "RESOLUTION" true true false 255 Text 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Projects,CASF_Project_Master_Nov_2022.RESOLUTION,0,255;COMMENT "COMMENT" true true false 255 Text 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Projects,CASF_Project_Master_Nov_2022.COMMENT,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.0.0'><WorkspaceConnectionString>DATABASE=D:\FRY_TEMP\Projects\CASF (California Advanced Services Fund)\CASF_230215\Data\CASF_Projects_Data_2021.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>CASF_Approved_Master_Nov_2022_join</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>REQAMT_NoRounding</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField "Working...\From Hayley Folder\CASF_Approved_Master_Nov_2022_join" REQAMT_NoRounding !REQAMT! "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.0.0'><WorkspaceConnectionString>DATABASE=D:\FRY_TEMP\Projects\CASF (California Advanced Services Fund)\CASF_230215\Data\CASF_Projects_Data_2021.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>CASF_Approved_Master_Nov_2022_join</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>GRANTAMT_NoRounding</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField "Working...\From Hayley Folder\CASF_Approved_Master_Nov_2022_join" GRANTAMT_NoRounding !GRANTAMT! "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.0.0'><WorkspaceConnectionString>DATABASE=D:\FRY_TEMP\Projects\CASF (California Advanced Services Fund)\CASF_230215\Data\CASF_Projects_Data_2021.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>CASF_Approved_Master_Nov_2022_join</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AlterField><field_name>PROJNAME</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow></operationSequence> ExportFeatures "Working...\From Hayley Folder\CASF_Approved_Master_Nov_2022_join" "D:\FRY_TEMP\Projects\CASF (California Advanced Services Fund)\CASF_230215\Data\CASF_Projects_Data_2021.gdb\CASF_Project_Master_Nov_2022_20230217" # NOT_USE_ALIAS "PROVNAME "Provider Name" true true false 50 Text 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Master_Nov_2022_join,PROVNAME,0,50;DBA "DBA Name" true true false 50 Text 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Master_Nov_2022_join,DBA,0,50;FRN "FRN" true true false 10 Text 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Master_Nov_2022_join,FRN,0,10;PROJNAME "Project Name" true true false 255 Text 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Master_Nov_2022_join,PROJNAME,0,255;PROJTYPE "Project Type" true true false 50 Text 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Master_Nov_2022_join,PROJTYPE,0,50;TECHNOLOGY "Technology of Transmission" true true false 50 Text 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Master_Nov_2022_join,TECHNOLOGY,0,50;DOWNSTREAM "Downstream Speed (Mbps)" true true false 4 Float 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Master_Nov_2022_join,DOWNSTREAM,-1,-1;UPSTREAM "Upstream Speed (Mbps)" true true false 4 Float 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Master_Nov_2022_join,UPSTREAM,-1,-1;HOUSEHOLDS "Households" true true false 4 Long 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Master_Nov_2022_join,HOUSEHOLDS,-1,-1;APP_DATE "Application Date" true true false 8 Date 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Master_Nov_2022_join,APP_DATE,-1,-1;APPTYPE "Application Type" true true false 50 Text 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Master_Nov_2022_join,APPTYPE,0,50;REQAMT_NoRounding "Requested Amount" true true false 255 Text 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Master_Nov_2022_join,REQAMT_NoRounding,0,255;APPRSTAT "Approval Status" true true false 50 Text 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Master_Nov_2022_join,APPRSTAT,0,50;APPRDATE "Approval Date" true true false 8 Date 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Master_Nov_2022_join,APPRDATE,-1,-1;GRANTAMT_NoRounding "Grant Amount" true true false 255 Text 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Master_Nov_2022_join,GRANTAMT_NoRounding,0,255;FUNDLEVEL "Funding Level" true true false 4 Float 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Master_Nov_2022_join,FUNDLEVEL,-1,-1;RESOLUTION "Resolution" true true false 50 Text 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Master_Nov_2022_join,RESOLUTION,0,50;COMMENT "COMMENT" true true false 255 Text 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Master_Nov_2022_join,COMMENT,0,255;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Master_Nov_2022_join,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,Working...\From Hayley Folder\CASF_Approved_Master_Nov_2022_join,Shape_Area,-1,-1" # ExportFeatures Working...\CASF_Project_Master_Nov_2022_20230217 "Y:\CED\K\11 - Staff\Hayley Stone\CASF_Projects_Data_2021.gdb\CASF_Project_Master_Nov_2022" # NOT_USE_ALIAS "PROVNAME "Provider Name" true true false 50 Text 0 0,First,#,Working...\CASF_Project_Master_Nov_2022_20230217,PROVNAME,0,50;DBA "DBA Name" true true false 50 Text 0 0,First,#,Working...\CASF_Project_Master_Nov_2022_20230217,DBA,0,50;FRN "FRN" true true false 10 Text 0 0,First,#,Working...\CASF_Project_Master_Nov_2022_20230217,FRN,0,10;PROJNAME "Project Name" true true false 255 Text 0 0,First,#,Working...\CASF_Project_Master_Nov_2022_20230217,PROJNAME,0,255;PROJTYPE "Project Type" true true false 50 Text 0 0,First,#,Working...\CASF_Project_Master_Nov_2022_20230217,PROJTYPE,0,50;TECHNOLOGY "Technology of Transmission" true true false 50 Text 0 0,First,#,Working...\CASF_Project_Master_Nov_2022_20230217,TECHNOLOGY,0,50;DOWNSTREAM "Downstream Speed (Mbps)" true true false 4 Float 0 0,First,#,Working...\CASF_Project_Master_Nov_2022_20230217,DOWNSTREAM,-1,-1;UPSTREAM "Upstream Speed (Mbps)" true true false 4 Float 0 0,First,#,Working...\CASF_Project_Master_Nov_2022_20230217,UPSTREAM,-1,-1;HOUSEHOLDS "Households" true true false 4 Long 0 0,First,#,Working...\CASF_Project_Master_Nov_2022_20230217,HOUSEHOLDS,-1,-1;APP_DATE "Application Date" true true false 8 Date 0 0,First,#,Working...\CASF_Project_Master_Nov_2022_20230217,APP_DATE,-1,-1;APPTYPE "Application Type" true true false 50 Text 0 0,First,#,Working...\CASF_Project_Master_Nov_2022_20230217,APPTYPE,0,50;REQAMT_NoRounding "Requested Amount" true true false 255 Text 0 0,First,#,Working...\CASF_Project_Master_Nov_2022_20230217,REQAMT_NoRounding,0,255;APPRSTAT "Approval Status" true true false 50 Text 0 0,First,#,Working...\CASF_Project_Master_Nov_2022_20230217,APPRSTAT,0,50;APPRDATE "Approval Date" true true false 8 Date 0 0,First,#,Working...\CASF_Project_Master_Nov_2022_20230217,APPRDATE,-1,-1;GRANTAMT_NoRounding "Grant Amount" true true false 255 Text 0 0,First,#,Working...\CASF_Project_Master_Nov_2022_20230217,GRANTAMT_NoRounding,0,255;FUNDLEVEL "Funding Level" true true false 4 Float 0 0,First,#,Working...\CASF_Project_Master_Nov_2022_20230217,FUNDLEVEL,-1,-1;RESOLUTION "Resolution" true true false 50 Text 0 0,First,#,Working...\CASF_Project_Master_Nov_2022_20230217,RESOLUTION,0,50;COMMENT "COMMENT" true true false 255 Text 0 0,First,#,Working...\CASF_Project_Master_Nov_2022_20230217,COMMENT,0,255;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,Working...\CASF_Project_Master_Nov_2022_20230217,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,Working...\CASF_Project_Master_Nov_2022_20230217,Shape_Area,-1,-1" # ExportFeatures Deliverables\CASF_Project_Master_Nov_2022 "D:\FRY_TEMP\Projects\CASF (California Advanced Services Fund)\CASF_230215\Data\CASF_Projects_Data_2021.gdb\CASF_Project_Master_Nov_2022_20230217" # NOT_USE_ALIAS "PROVNAME "Provider Name" true true false 50 Text 0 0,First,#,Deliverables\CASF_Project_Master_Nov_2022,PROVNAME,0,50;DBA "DBA Name" true true false 50 Text 0 0,First,#,Deliverables\CASF_Project_Master_Nov_2022,DBA,0,50;FRN "FRN" true true false 10 Text 0 0,First,#,Deliverables\CASF_Project_Master_Nov_2022,FRN,0,10;PROJNAME "Project Name" true true false 255 Text 0 0,First,#,Deliverables\CASF_Project_Master_Nov_2022,PROJNAME,0,255;PROJTYPE "Project Type" true true false 50 Text 0 0,First,#,Deliverables\CASF_Project_Master_Nov_2022,PROJTYPE,0,50;TECHNOLOGY "Technology of Transmission" true true false 50 Text 0 0,First,#,Deliverables\CASF_Project_Master_Nov_2022,TECHNOLOGY,0,50;DOWNSTREAM "Downstream Speed (Mbps)" true true false 4 Float 0 0,First,#,Deliverables\CASF_Project_Master_Nov_2022,DOWNSTREAM,-1,-1;UPSTREAM "Upstream Speed (Mbps)" true true false 4 Float 0 0,First,#,Deliverables\CASF_Project_Master_Nov_2022,UPSTREAM,-1,-1;HOUSEHOLDS "Households" true true false 4 Long 0 0,First,#,Deliverables\CASF_Project_Master_Nov_2022,HOUSEHOLDS,-1,-1;APP_DATE "Application Date" true true false 8 Date 0 0,First,#,Deliverables\CASF_Project_Master_Nov_2022,APP_DATE,-1,-1;APPTYPE "Application Type" true true false 50 Text 0 0,First,#,Deliverables\CASF_Project_Master_Nov_2022,APPTYPE,0,50;REQAMT_NoRounding "Requested Amount" true true false 255 Text 0 0,First,#,Deliverables\CASF_Project_Master_Nov_2022,REQAMT_NoRounding,0,255;APPRSTAT "Approval Status" true true false 50 Text 0 0,First,#,Deliverables\CASF_Project_Master_Nov_2022,APPRSTAT,0,50;APPRDATE "Approval Date" true true false 8 Date 0 0,First,#,Deliverables\CASF_Project_Master_Nov_2022,APPRDATE,-1,-1;GRANTAMT_NoRounding "Grant Amount" true true false 255 Text 0 0,First,#,Deliverables\CASF_Project_Master_Nov_2022,GRANTAMT_NoRounding,0,255;FUNDLEVEL "Funding Level" true true false 4 Float 0 0,First,#,Deliverables\CASF_Project_Master_Nov_2022,FUNDLEVEL,-1,-1;RESOLUTION "Resolution" true true false 50 Text 0 0,First,#,Deliverables\CASF_Project_Master_Nov_2022,RESOLUTION,0,50;COMMENT "COMMENT" true true false 255 Text 0 0,First,#,Deliverables\CASF_Project_Master_Nov_2022,COMMENT,0,255;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,Deliverables\CASF_Project_Master_Nov_2022,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,Deliverables\CASF_Project_Master_Nov_2022,Shape_Area,-1,-1" # ExportFeatures Working...\CASF_Project_Master_Nov_2022_20230217 "Y:\CED\K\11 - Staff\Hayley Stone\CASF_Projects_Data_2021.gdb\CASF_Project_Master_Nov_2022" # NOT_USE_ALIAS "PROVNAME "Provider Name" true true false 50 Text 0 0,First,#,Working...\CASF_Project_Master_Nov_2022_20230217,PROVNAME,0,50;DBA "DBA Name" true true false 50 Text 0 0,First,#,Working...\CASF_Project_Master_Nov_2022_20230217,DBA,0,50;FRN "FRN" true true false 10 Text 0 0,First,#,Working...\CASF_Project_Master_Nov_2022_20230217,FRN,0,10;PROJNAME "Project Name" true true false 255 Text 0 0,First,#,Working...\CASF_Project_Master_Nov_2022_20230217,PROJNAME,0,255;PROJTYPE "Project Type" true true false 50 Text 0 0,First,#,Working...\CASF_Project_Master_Nov_2022_20230217,PROJTYPE,0,50;TECHNOLOGY "Technology of Transmission" true true false 50 Text 0 0,First,#,Working...\CASF_Project_Master_Nov_2022_20230217,TECHNOLOGY,0,50;DOWNSTREAM "Downstream Speed (Mbps)" true true false 4 Float 0 0,First,#,Working...\CASF_Project_Master_Nov_2022_20230217,DOWNSTREAM,-1,-1;UPSTREAM "Upstream Speed (Mbps)" true true false 4 Float 0 0,First,#,Working...\CASF_Project_Master_Nov_2022_20230217,UPSTREAM,-1,-1;HOUSEHOLDS "Households" true true false 4 Long 0 0,First,#,Working...\CASF_Project_Master_Nov_2022_20230217,HOUSEHOLDS,-1,-1;APP_DATE "Application Date" true true false 8 Date 0 0,First,#,Working...\CASF_Project_Master_Nov_2022_20230217,APP_DATE,-1,-1;APPTYPE "Application Type" true true false 50 Text 0 0,First,#,Working...\CASF_Project_Master_Nov_2022_20230217,APPTYPE,0,50;REQAMT_NoRounding "Requested Amount" true true false 255 Text 0 0,First,#,Working...\CASF_Project_Master_Nov_2022_20230217,REQAMT_NoRounding,0,255;APPRSTAT "Approval Status" true true false 50 Text 0 0,First,#,Working...\CASF_Project_Master_Nov_2022_20230217,APPRSTAT,0,50;APPRDATE "Approval Date" true true false 8 Date 0 0,First,#,Working...\CASF_Project_Master_Nov_2022_20230217,APPRDATE,-1,-1;GRANTAMT_NoRounding "Grant Amount" true true false 255 Text 0 0,First,#,Working...\CASF_Project_Master_Nov_2022_20230217,GRANTAMT_NoRounding,0,255;FUNDLEVEL "Funding Level" true true false 4 Float 0 0,First,#,Working...\CASF_Project_Master_Nov_2022_20230217,FUNDLEVEL,-1,-1;RESOLUTION "Resolution" true true false 50 Text 0 0,First,#,Working...\CASF_Project_Master_Nov_2022_20230217,RESOLUTION,0,50;COMMENT "COMMENT" true true false 255 Text 0 0,First,#,Working...\CASF_Project_Master_Nov_2022_20230217,COMMENT,0,255;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,Working...\CASF_Project_Master_Nov_2022_20230217,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,Working...\CASF_Project_Master_Nov_2022_20230217,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.0.0'><WorkspaceConnectionString>DATABASE=Y:\CPUC_WEB\DATA\CASF\CASF_Projects_Data_2021_1.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>CASF_Project_Master_Nov_2022</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>COMMENT</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.0.0'><WorkspaceConnectionString>DATABASE=Y:\CPUC_WEB\DATA\CASF\CASF_Projects_Data_2021_1.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>CASF_Project_Master_Nov_2022</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AlterField><field_name>REQAMT_NoRounding</field_name><new_field_name>REQAMT</new_field_name><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>GRANTAMT_NoRounding</field_name><new_field_name>GRANTAMT</new_field_name><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow></operationSequence> Append CASF_Approved_Projects CASF_Project_Master_Nov_2022 "Use the field map to reconcile field differences" "PROVNAME "Provider Name" true true false 50 Text 0 0,First,#,C:\Users\hmstone\Downloads\CASF_Projects_Data_20230228\CASF_Projects_Data_2021.gdb\CASF_Approved_Projects,PROVNAME,0,50;DBA "DBA Name" true true false 50 Text 0 0,First,#,C:\Users\hmstone\Downloads\CASF_Projects_Data_20230228\CASF_Projects_Data_2021.gdb\CASF_Approved_Projects,DBA,0,50;FRN "FRN" true true false 10 Text 0 0,First,#,C:\Users\hmstone\Downloads\CASF_Projects_Data_20230228\CASF_Projects_Data_2021.gdb\CASF_Approved_Projects,FRN,0,10;PROJNAME "Project Name" true true false 255 Text 0 0,First,#,C:\Users\hmstone\Downloads\CASF_Projects_Data_20230228\CASF_Projects_Data_2021.gdb\CASF_Approved_Projects,PROJNAME,0,50;PROJTYPE "Project Type" true true false 50 Text 0 0,First,#,C:\Users\hmstone\Downloads\CASF_Projects_Data_20230228\CASF_Projects_Data_2021.gdb\CASF_Approved_Projects,PROJTYPE,0,50;TECHNOLOGY "Technology of Transmission" true true false 50 Text 0 0,First,#,C:\Users\hmstone\Downloads\CASF_Projects_Data_20230228\CASF_Projects_Data_2021.gdb\CASF_Approved_Projects,TECHNOLOGY,0,50;DOWNSTREAM "Downstream Speed (Mbps)" true true false 4 Float 0 0,First,#,C:\Users\hmstone\Downloads\CASF_Projects_Data_20230228\CASF_Projects_Data_2021.gdb\CASF_Approved_Projects,DOWNSTREAM,-1,-1;UPSTREAM "Upstream Speed (Mbps)" true true false 4 Float 0 0,First,#,C:\Users\hmstone\Downloads\CASF_Projects_Data_20230228\CASF_Projects_Data_2021.gdb\CASF_Approved_Projects,UPSTREAM,-1,-1;HOUSEHOLDS "Households" true true false 4 Long 0 0,First,#,C:\Users\hmstone\Downloads\CASF_Projects_Data_20230228\CASF_Projects_Data_2021.gdb\CASF_Approved_Projects,HOUSEHOLDS,-1,-1;APP_DATE "Application Date" true true false 8 Date 0 0,First,#,C:\Users\hmstone\Downloads\CASF_Projects_Data_20230228\CASF_Projects_Data_2021.gdb\CASF_Approved_Projects,APP_DATE,-1,-1;APPTYPE "Application Type" true true false 50 Text 0 0,First,#,C:\Users\hmstone\Downloads\CASF_Projects_Data_20230228\CASF_Projects_Data_2021.gdb\CASF_Approved_Projects,APPTYPE,0,50;REQAMT "Requested Amount" true true false 255 Text 0 0,First,#,C:\Users\hmstone\Downloads\CASF_Projects_Data_20230228\CASF_Projects_Data_2021.gdb\CASF_Approved_Projects,REQAMT,-1,-1;APPRSTAT "Approval Status" true true false 50 Text 0 0,First,#,C:\Users\hmstone\Downloads\CASF_Projects_Data_20230228\CASF_Projects_Data_2021.gdb\CASF_Approved_Projects,APPRSTAT,0,50;APPRDATE "Approval Date" true true false 8 Date 0 0,First,#,C:\Users\hmstone\Downloads\CASF_Projects_Data_20230228\CASF_Projects_Data_2021.gdb\CASF_Approved_Projects,APPRDATE,-1,-1;GRANTAMT "Grant Amount" true true false 255 Text 0 0,First,#,C:\Users\hmstone\Downloads\CASF_Projects_Data_20230228\CASF_Projects_Data_2021.gdb\CASF_Approved_Projects,GRANTAMT,-1,-1;FUNDLEVEL "Funding Level" true true false 4 Float 0 0,First,#,C:\Users\hmstone\Downloads\CASF_Projects_Data_20230228\CASF_Projects_Data_2021.gdb\CASF_Approved_Projects,FUNDLEVEL,-1,-1;RESOLUTION "Resolution" true true false 50 Text 0 0,First,#,C:\Users\hmstone\Downloads\CASF_Projects_Data_20230228\CASF_Projects_Data_2021.gdb\CASF_Approved_Projects,RESOLUTION,0,50" # # Rename Y:\CPUC_WEB\DATA\CASF\CASF_Projects_Data_2021_1.gdb\CASF_Project_Master_Nov_2022 Y:\CPUC_WEB\DATA\CASF\CASF_Projects_Data_2021_1.gdb\CASF_Approved_Projects FeatureClass ExportFeatures CASF_Approved_Projects "C:\Users\ndy\Documents\ArcGIS\Projects\SIG GIS\SIG GIS.gdb\CASF_Approved__LM" # NOT_USE_ALIAS "PROVNAME "Provider Name" true true false 50 Text 0 0,First,#,CASF_Approved_Projects,PROVNAME,0,50;DBA "DBA Name" true true false 50 Text 0 0,First,#,CASF_Approved_Projects,DBA,0,50;FRN "FRN" true true false 10 Text 0 0,First,#,CASF_Approved_Projects,FRN,0,10;PROJNAME "Project Name" true true false 255 Text 0 0,First,#,CASF_Approved_Projects,PROJNAME,0,255;PROJTYPE "Project Type" true true false 50 Text 0 0,First,#,CASF_Approved_Projects,PROJTYPE,0,50;TECHNOLOGY "Technology of Transmission" true true false 50 Text 0 0,First,#,CASF_Approved_Projects,TECHNOLOGY,0,50;DOWNSTREAM "Downstream Speed (Mbps)" true true false 4 Float 0 0,First,#,CASF_Approved_Projects,DOWNSTREAM,-1,-1;UPSTREAM "Upstream Speed (Mbps)" true true false 4 Float 0 0,First,#,CASF_Approved_Projects,UPSTREAM,-1,-1;HOUSEHOLDS "Households" true true false 4 Long 0 0,First,#,CASF_Approved_Projects,HOUSEHOLDS,-1,-1;APP_DATE "Application Date" true true false 8 Date 0 0,First,#,CASF_Approved_Projects,APP_DATE,-1,-1;APPTYPE "Application Type" true true false 50 Text 0 0,First,#,CASF_Approved_Projects,APPTYPE,0,50;REQAMT "Requested Amount" true true false 255 Text 0 0,First,#,CASF_Approved_Projects,REQAMT,0,255;APPRSTAT "Approval Status" true true false 50 Text 0 0,First,#,CASF_Approved_Projects,APPRSTAT,0,50;APPRDATE "Approval Date" true true false 8 Date 0 0,First,#,CASF_Approved_Projects,APPRDATE,-1,-1;GRANTAMT "Grant Amount" true true false 255 Text 0 0,First,#,CASF_Approved_Projects,GRANTAMT,0,255;FUNDLEVEL "Funding Level" true true false 4 Float 0 0,First,#,CASF_Approved_Projects,FUNDLEVEL,-1,-1;RESOLUTION "Resolution" true true false 50 Text 0 0,First,#,CASF_Approved_Projects,RESOLUTION,0,50;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,CASF_Approved_Projects,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,CASF_Approved_Projects,Shape_Area,-1,-1" # ExportFeatures CASF_Approved__LM "C:\Users\ndy\Documents\ArcGIS\Projects\SIG GIS\SIG GIS.gdb\CASF_Approved__LMRequested" # NOT_USE_ALIAS "PROVNAME "Provider Name" true true false 50 Text 0 0,First,#,CASF_Approved__LM,PROVNAME,0,50;DBA "DBA Name" true true false 50 Text 0 0,First,#,CASF_Approved__LM,DBA,0,50;FRN "FRN" true true false 10 Text 0 0,First,#,CASF_Approved__LM,FRN,0,10;PROJNAME "Project Name" true true false 255 Text 0 0,First,#,CASF_Approved__LM,PROJNAME,0,255;PROJTYPE "Project Type" true true false 50 Text 0 0,First,#,CASF_Approved__LM,PROJTYPE,0,50;TECHNOLOGY "Technology of Transmission" true true false 50 Text 0 0,First,#,CASF_Approved__LM,TECHNOLOGY,0,50;DOWNSTREAM "Downstream Speed (Mbps)" true true false 4 Float 0 0,First,#,CASF_Approved__LM,DOWNSTREAM,-1,-1;UPSTREAM "Upstream Speed (Mbps)" true true false 4 Float 0 0,First,#,CASF_Approved__LM,UPSTREAM,-1,-1;HOUSEHOLDS "Households" true true false 4 Long 0 0,First,#,CASF_Approved__LM,HOUSEHOLDS,-1,-1;APP_DATE "Application Date" true true false 8 Date 0 0,First,#,CASF_Approved__LM,APP_DATE,-1,-1;APPTYPE "Application Type" true true false 50 Text 0 0,First,#,CASF_Approved__LM,APPTYPE,0,50;REQAMT "Requested Amount" true true false 255 Text 0 0,First,#,CASF_Approved__LM,REQAMT,0,255;APPRSTAT "Approval Status" true true false 50 Text 0 0,First,#,CASF_Approved__LM,APPRSTAT,0,50;APPRDATE "Approval Date" true true false 8 Date 0 0,First,#,CASF_Approved__LM,APPRDATE,-1,-1;GRANTAMT "Grant Amount" true true false 255 Text 0 0,First,#,CASF_Approved__LM,GRANTAMT,0,255;FUNDLEVEL "Funding Level" true true false 4 Float 0 0,First,#,CASF_Approved__LM,FUNDLEVEL,-1,-1;RESOLUTION "Resolution" true true false 50 Text 0 0,First,#,CASF_Approved__LM,RESOLUTION,0,50;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,CASF_Approved__LM,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,CASF_Approved__LM,Shape_Area,-1,-1" # 20231101 13243600 20231101 13243600 Microsoft Windows 10 Version 10.0 (Build 19045) ; Esri ArcGIS 13.0.2.36056 CASF_Approved_Last_Mile_Requested CASF_Approved_Last_Mile_Requested File Geodatabase Feature Class dataset EPSG 6.18.3(9.3.1.2) 0 Simple FALSE 0 TRUE FALSE CASF_Approved__LMRequested 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. PROVNAME Provider Name String 50 0 0 DBA DBA Name String 50 0 0 FRN FRN String 10 0 0 PROJNAME Project Name String 255 0 0 PROJTYPE Project Type String 50 0 0 APP_DATE Application Date Date 8 0 0 TECHNOLOGY Technology of Transmission String 50 0 0 DOWNSTREAM Downstream Speed (Mbps) Single 4 0 0 UPSTREAM Upstream Speed (Mbps) Single 4 0 0 HOUSEHOLDS Households Integer 4 0 0 APPTYPE Application Type String 50 0 0 REQAMT Requested Amount String 255 0 0 APPRSTAT Approval Status String 50 0 0 APPRDATE Approval Date Date 8 0 0 GRANTAMT Grant Amount String 255 0 0 FUNDLEVEL Funding Level Single 4 0 0 RESOLUTION Resolution String 50 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. 20231101 /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=