20230324
11031800
1.0
FALSE
CreateFeatureclass E:\Buildings_Footprints\V2\V2_lidar_A\V2_lidar_A.gdb Building_Polygons Polygon # No No "PROJCS["WGS_1984_Web_Mercator_Auxiliary_Sphere",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Mercator_Auxiliary_Sphere"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",0.0],PARAMETER["Auxiliary_Sphere_Type",0.0],UNIT["Meter",1.0]];-20037700 -30241100 10000;-100000 10000;-100000 10000;0.001;0.001;0.001;IsHighPrecision" # # # # #
UpdateSchema E:\Buildings_Footprints\V2\V2_lidar_A\V2_lidar_A.gdb\Building_Polygons <operationSequence><workflow><AddField><field_name>Join_Count</field_name><field_type>Long</field_type><field_alias>Join_Count</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>4</field_length></AddField></workflow><workflow><AddField><field_name>TARGET_FID</field_name><field_type>Long</field_type><field_alias>TARGET_FID</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>4</field_length></AddField></workflow><workflow><AddField><field_name>FID_V2_Lidar_OSM_MsAI_Inter_DisT</field_name><field_type>Long</field_type><field_alias>FID_V2_Lidar_OSM_MsAI_Inter_DisT</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>4</field_length></AddField></workflow><workflow><AddField><field_name>FID_V2_Lidar_OSM_MSAI_SJoin</field_name><field_type>Long</field_type><field_alias>FID_V2_Lidar_OSM_MSAI_SJoin</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>4</field_length></AddField></workflow><workflow><AddField><field_name>AREA_SQFT_B</field_name><field_type>Long</field_type><field_alias>AREA_SQFT_B</field_alias><field_is_nullable>TRUE</field_is_nullable><field_length>4</field_length></AddField></workflow></operationSequence>
UpdateSchema E:\Buildings_Footprints\V2\V2_lidar_A\V2_lidar_A.gdb\Building_Polygons <operationSequence><workflow><AlterField><field_name>OBJECTID</field_name><field_alias>OBJECTID</field_alias></AlterField></workflow><workflow><AlterField><field_name>SHAPE</field_name><field_alias>SHAPE</field_alias></AlterField></workflow></operationSequence>
Append Main_Polygons;Sliver_SpatialJoin Building_Polygons "Use the field map to reconcile field differences" "FID_V2_Lidar_OSM_MsAI_Inter_DisT "FID_V2_Lidar_OSM_MsAI_Inter_DisT" true true false 4 Long 0 0,First,#,E:\Buildings_Footprints\V2\V2_lidar_A\V2_lidar_A.gdb\Main_Polygons,FID_V2_Lidar_OSM_MsAI_Inter_DisT,-1,-1,Sliver_SpatialJoin,FID_V2_Lidar_OSM_MsAI_Inter_DisT,-1,-1;FID_V2_Lidar_OSM_MSAI_SJoin "FID_V2_Lidar_OSM_MSAI_SJoin" true true false 4 Long 0 0,First,#,E:\Buildings_Footprints\V2\V2_lidar_A\V2_lidar_A.gdb\Main_Polygons,FID_V2_Lidar_OSM_MSAI_SJoin,-1,-1,Sliver_SpatialJoin,FID_V2_Lidar_OSM_MSAI_SJoin,-1,-1;AREA_SQFT_B "AREA_SQFT_B" true true false 4 Long 0 0,First,#,E:\Buildings_Footprints\V2\V2_lidar_A\V2_lidar_A.gdb\Main_Polygons,AREA_SQFT_B,-1,-1,Sliver_SpatialJoin,AREA_SQFT_B,-1,-1" # #
Append Main_Polygons;Sliver_SpatialJoin E:\Buildings_Footprints\V2\V2_lidar_A\V2_lidar_A.gdb\Building_Polygons "Use the field map to reconcile field differences" "FID_V2_Lidar_OSM_MsAI_Inter_DisT "FID_V2_Lidar_OSM_MsAI_Inter_DisT" true true false 4 Long 0 0,First,#,E:\Buildings_Footprints\V2\V2_lidar_A\V2_lidar_A.gdb\Main_Polygons,FID_V2_Lidar_OSM_MsAI_Inter_DisT,-1,-1,Sliver_SpatialJoin,FID_V2_Lidar_OSM_MsAI_Inter_DisT,-1,-1;FID_V2_Lidar_OSM_MSAI_SJoin "FID_V2_Lidar_OSM_MSAI_SJoin" true true false 4 Long 0 0,First,#,E:\Buildings_Footprints\V2\V2_lidar_A\V2_lidar_A.gdb\Main_Polygons,FID_V2_Lidar_OSM_MSAI_SJoin,-1,-1,Sliver_SpatialJoin,FID_V2_Lidar_OSM_MSAI_SJoin,-1,-1;AREA_SQFT_B "AREA_SQFT_B" true true false 4 Long 0 0,First,#,E:\Buildings_Footprints\V2\V2_lidar_A\V2_lidar_A.gdb\Main_Polygons,AREA_SQFT_B,-1,-1,Sliver_SpatialJoin,AREA_SQFT_B,-1,-1" # #
PairwiseDissolve Building_Polygons E:\Buildings_Footprints\V2\V2fix.gdb\Building_Poly_Dis FID_V2_Lidar_OSM_MsAI_Inter_DisT # MULTI_PART
FeatureClassToFeatureClass Building_Poly_Dis E:\Buildings_Footprints\V2\V2fix.gdb Building_Poly_Dis2 # "FID_V2_Lidar_OSM_MsAI_Inter_DisT "FID_V2_Lidar_OSM_MsAI_Inter_DisT" true true false 4 Long 0 0,First,#,Building_Poly_Dis,FID_V2_Lidar_OSM_MsAI_Inter_DisT,-1,-1;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,Building_Poly_Dis,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,Building_Poly_Dis,Shape_Area,-1,-1" #
Append Building_Poly_Singles Building_Poly_Dis2 "Use the field map to reconcile field differences" "FID_V2_Lidar_OSM_MsAI_Inter_DisT "FID_V2_Lidar_OSM_MsAI_Inter_DisT" true true false 4 Long 0 0,First,#,E:\Buildings_Footprints\V2\V2fix.gdb\Building_Poly_Singles,FID_V2_Lidar_OSM_MsAI_Inter_DisT,-1,-1" # #
MultipartToSinglepart Building_Poly_Dis2 E:\Buildings_Footprints\V2\V2fix.gdb\Building_Poly_SP
FeatureClassToFeatureClass Building_Poly_SP E:\Buildings_Footprints\V2\V2fix.gdb Building_Poly_SP_S # "Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,Building_Poly_SP,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,Building_Poly_SP,Shape_Area,-1,-1" #
DeleteIdentical Building_Poly_SP_S Shape_Length;Shape_Area # 0
SpatialJoin Building_Poly_SP_S stratmap19_land_parcels_48_S E:\Buildings_Footprints\V2\V2fix.gdb\Building_Poly_Sp_JoS "Join one to one" KEEP_ALL "prop_id "PROP_ID" true true false 70 Text 0 0,First,#,stratmap19_land_parcels_48_S,prop_id,0,70;geo_id "GEO_ID" true true false 50 Text 0 0,First,#,stratmap19_land_parcels_48_S,geo_id,0,50;legal_desc "LEGAL_DESC" true true false 254 Text 0 0,First,#,stratmap19_land_parcels_48_S,legal_desc,0,254;land_value "LAND_VALUE" true true false 8 Double 0 0,First,#,stratmap19_land_parcels_48_S,land_value,-1,-1;imp_value "IMP_VALUE" true true false 8 Double 0 0,First,#,stratmap19_land_parcels_48_S,imp_value,-1,-1;mkt_value "MKT_VALUE" true true false 8 Double 0 0,First,#,stratmap19_land_parcels_48_S,mkt_value,-1,-1;county "COUNTY" true true false 60 Text 0 0,First,#,stratmap19_land_parcels_48_S,county,0,60;tax_year "TAX_YEAR" true true false 4 Long 0 0,First,#,stratmap19_land_parcels_48_S,tax_year,-1,-1;COUNTY_1 "County Name" true true false 100 Text 0 0,First,#,stratmap19_land_parcels_48_S,COUNTY_1,0,100;USE_CODE_STD_CTGR_DESC_LPS "Land Use Standardized CTGR Description" true true false 100 Text 0 0,First,#,stratmap19_land_parcels_48_S,USE_CODE_STD_CTGR_DESC_LPS,0,100;VAL_ASSD_LAND "Assessment Value Land" true true false 4 Long 0 0,First,#,stratmap19_land_parcels_48_S,VAL_ASSD_LAND,-1,-1;VAL_ASSD_IMPRV "Assessment Value Improvement" true true false 4 Long 0 0,First,#,stratmap19_land_parcels_48_S,VAL_ASSD_IMPRV,-1,-1;VAL_ASSD "Assessment Value" true true false 4 Long 0 0,First,#,stratmap19_land_parcels_48_S,VAL_ASSD,-1,-1;TAX_YEAR_1 "Tax Year" true true false 4 Long 0 0,First,#,stratmap19_land_parcels_48_S,TAX_YEAR_1,-1,-1;BUILDING_SQFT "Building Square Foot" true true false 4 Long 0 0,First,#,stratmap19_land_parcels_48_S,BUILDING_SQFT,-1,-1;STORIES_NUMBER "Number of Stories" true true false 10 Text 0 0,First,#,stratmap19_land_parcels_48_S,STORIES_NUMBER,0,10;Build_Type_County "Build_Type_County" true true false 80 Text 0 0,First,#,stratmap19_land_parcels_48_S,Build_Type_County,0,80" "Have their center in" # #
SpatialJoin Building_Poly_Sp_JoS V2_Lidar_OSM_MSAI_SJoin E:\Buildings_Footprints\V2\V2fix.gdb\Building_Poly_Sp_JoS_2 "Join one to one" KEEP_ALL "Join_Count "Join_Count" true true false 4 Long 0 0,First,#,Building_Poly_Sp_JoS,Join_Count,-1,-1;TARGET_FID "TARGET_FID" true true false 4 Long 0 0,First,#,Building_Poly_Sp_JoS,TARGET_FID,-1,-1;prop_id "PROP_ID" true true false 70 Text 0 0,First,#,Building_Poly_Sp_JoS,prop_id,0,70;geo_id "GEO_ID" true true false 50 Text 0 0,First,#,Building_Poly_Sp_JoS,geo_id,0,50;legal_desc "LEGAL_DESC" true true false 254 Text 0 0,First,#,Building_Poly_Sp_JoS,legal_desc,0,254;land_value "LAND_VALUE" true true false 8 Double 0 0,First,#,Building_Poly_Sp_JoS,land_value,-1,-1;imp_value "IMP_VALUE" true true false 8 Double 0 0,First,#,Building_Poly_Sp_JoS,imp_value,-1,-1;mkt_value "MKT_VALUE" true true false 8 Double 0 0,First,#,Building_Poly_Sp_JoS,mkt_value,-1,-1;county "COUNTY" true true false 60 Text 0 0,First,#,Building_Poly_Sp_JoS,county,0,60;tax_year "TAX_YEAR" true true false 4 Long 0 0,First,#,Building_Poly_Sp_JoS,tax_year,-1,-1;COUNTY_1 "County Name" true true false 100 Text 0 0,First,#,Building_Poly_Sp_JoS,COUNTY_1,0,100;USE_CODE_STD_CTGR_DESC_LPS "Land Use Standardized CTGR Description" true true false 100 Text 0 0,First,#,Building_Poly_Sp_JoS,USE_CODE_STD_CTGR_DESC_LPS,0,100;VAL_ASSD_LAND "Assessment Value Land" true true false 4 Long 0 0,First,#,Building_Poly_Sp_JoS,VAL_ASSD_LAND,-1,-1;VAL_ASSD_IMPRV "Assessment Value Improvement" true true false 4 Long 0 0,First,#,Building_Poly_Sp_JoS,VAL_ASSD_IMPRV,-1,-1;VAL_ASSD "Assessment Value" true true false 4 Long 0 0,First,#,Building_Poly_Sp_JoS,VAL_ASSD,-1,-1;TAX_YEAR_1 "Tax Year" true true false 4 Long 0 0,First,#,Building_Poly_Sp_JoS,TAX_YEAR_1,-1,-1;BUILDING_SQFT "Building Square Foot" true true false 4 Long 0 0,First,#,Building_Poly_Sp_JoS,BUILDING_SQFT,-1,-1;STORIES_NUMBER "Number of Stories" true true false 10 Text 0 0,First,#,Building_Poly_Sp_JoS,STORIES_NUMBER,0,10;Build_Type_County "Build_Type_County" true true false 80 Text 0 0,First,#,Building_Poly_Sp_JoS,Build_Type_County,0,80;BLDGHEIGHT "BLDGHEIGHT" true true false 4 Float 0 0,First,#,V2_Lidar_OSM_MSAI_SJoin,BLDGHEIGHT,-1,-1;ROOFFORM "ROOFFORM" true true false 255 Text 0 0,First,#,V2_Lidar_OSM_MSAI_SJoin,ROOFFORM,0,255;Source "Source" true true false 50 Text 0 0,First,#,V2_Lidar_OSM_MSAI_SJoin,Source,0,50;Fraction_of_SQFT "Fraction_of_SQFT" true true false 4 Float 0 0,First,#,V2_Lidar_OSM_MSAI_SJoin,Fraction_of_SQFT,-1,-1;Frac_Imp_Val "Frac_Imp_Val" true true false 8 Double 0 0,First,#,V2_Lidar_OSM_MSAI_SJoin,Frac_Imp_Val,-1,-1;Method "Method" true true false 20 Text 0 0,First,#,V2_Lidar_OSM_MSAI_SJoin,Method,0,20;Damage_Curve "Damage_Curve" true true false 10 Text 0 0,First,#,V2_Lidar_OSM_MSAI_SJoin,Damage_Curve,0,10" "Have their center in" # #
Append Building_Poly_Sp_JoN_2 Building_Poly_Sp_JoS_2 "Use the field map to reconcile field differences" "Join_Count "Join_Count" true true false 4 Long 0 0,First,#,E:\Buildings_Footprints\V2\V2fix.gdb\Building_Poly_Sp_JoN_2,Join_Count,-1,-1;TARGET_FID "TARGET_FID" true true false 4 Long 0 0,First,#,E:\Buildings_Footprints\V2\V2fix.gdb\Building_Poly_Sp_JoN_2,TARGET_FID,-1,-1;prop_id "PROP_ID" true true false 70 Text 0 0,First,#,E:\Buildings_Footprints\V2\V2fix.gdb\Building_Poly_Sp_JoN_2,prop_id,0,70;geo_id "GEO_ID" true true false 50 Text 0 0,First,#,E:\Buildings_Footprints\V2\V2fix.gdb\Building_Poly_Sp_JoN_2,geo_id,0,50;land_value "LAND_VALUE" true true false 8 Double 0 0,First,#,E:\Buildings_Footprints\V2\V2fix.gdb\Building_Poly_Sp_JoN_2,land_value,-1,-1;imp_value "IMP_VALUE" true true false 8 Double 0 0,First,#,E:\Buildings_Footprints\V2\V2fix.gdb\Building_Poly_Sp_JoN_2,imp_value,-1,-1;mkt_value "MKT_VALUE" true true false 8 Double 0 0,First,#,E:\Buildings_Footprints\V2\V2fix.gdb\Building_Poly_Sp_JoN_2,mkt_value,-1,-1;county "COUNTY" true true false 60 Text 0 0,First,#,E:\Buildings_Footprints\V2\V2fix.gdb\Building_Poly_Sp_JoN_2,county,0,60;tax_year "TAX_YEAR" true true false 4 Long 0 0,First,#,E:\Buildings_Footprints\V2\V2fix.gdb\Building_Poly_Sp_JoN_2,tax_year,-1,-1;COUNTY_1 "County Name" true true false 100 Text 0 0,First,#,E:\Buildings_Footprints\V2\V2fix.gdb\Building_Poly_Sp_JoN_2,COUNTY_1,0,100;USE_CODE_STD_CTGR_DESC_LPS "Land Use Standardized CTGR Description" true true false 100 Text 0 0,First,#,E:\Buildings_Footprints\V2\V2fix.gdb\Building_Poly_Sp_JoN_2,USE_CODE_STD_CTGR_DESC_LPS,0,100;VAL_ASSD_LAND "Assessment Value Land" true true false 4 Long 0 0,First,#,E:\Buildings_Footprints\V2\V2fix.gdb\Building_Poly_Sp_JoN_2,VAL_ASSD_LAND,-1,-1;VAL_ASSD_IMPRV "Assessment Value Improvement" true true false 4 Long 0 0,First,#,E:\Buildings_Footprints\V2\V2fix.gdb\Building_Poly_Sp_JoN_2,VAL_ASSD_IMPRV,-1,-1;VAL_ASSD "Assessment Value" true true false 4 Long 0 0,First,#,E:\Buildings_Footprints\V2\V2fix.gdb\Building_Poly_Sp_JoN_2,VAL_ASSD,-1,-1;TAX_YEAR_1 "Tax Year" true true false 4 Long 0 0,First,#,E:\Buildings_Footprints\V2\V2fix.gdb\Building_Poly_Sp_JoN_2,TAX_YEAR_1,-1,-1;BUILDING_SQFT "Building Square Foot" true true false 4 Long 0 0,First,#,E:\Buildings_Footprints\V2\V2fix.gdb\Building_Poly_Sp_JoN_2,BUILDING_SQFT,-1,-1;STORIES_NUMBER "Number of Stories" true true false 10 Text 0 0,First,#,E:\Buildings_Footprints\V2\V2fix.gdb\Building_Poly_Sp_JoN_2,STORIES_NUMBER,0,10;Build_Type_County "Build_Type_County" true true false 80 Text 0 0,First,#,E:\Buildings_Footprints\V2\V2fix.gdb\Building_Poly_Sp_JoN_2,Build_Type_County,0,80;BLDGHEIGHT "BLDGHEIGHT" true true false 4 Float 0 0,First,#,E:\Buildings_Footprints\V2\V2fix.gdb\Building_Poly_Sp_JoN_2,BLDGHEIGHT,-1,-1;ROOFFORM "ROOFFORM" true true false 255 Text 0 0,First,#,E:\Buildings_Footprints\V2\V2fix.gdb\Building_Poly_Sp_JoN_2,ROOFFORM,0,255;Source "Source" true true false 50 Text 0 0,First,#,E:\Buildings_Footprints\V2\V2fix.gdb\Building_Poly_Sp_JoN_2,Source,0,50;Fraction_of_SQFT "Fraction_of_SQFT" true true false 4 Float 0 0,First,#,E:\Buildings_Footprints\V2\V2fix.gdb\Building_Poly_Sp_JoN_2,Fraction_of_SQFT,-1,-1;Frac_Imp_Val "Frac_Imp_Val" true true false 8 Double 0 0,First,#,E:\Buildings_Footprints\V2\V2fix.gdb\Building_Poly_Sp_JoN_2,Frac_Imp_Val,-1,-1;Method "Method" true true false 20 Text 0 0,First,#,E:\Buildings_Footprints\V2\V2fix.gdb\Building_Poly_Sp_JoN_2,Method,0,20;Damage_Curve "Damage_Curve" true true false 10 Text 0 0,First,#,E:\Buildings_Footprints\V2\V2fix.gdb\Building_Poly_Sp_JoN_2,Damage_Curve,0,10" # #
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/2.8.0'><WorkspaceConnectionString>DATABASE=E:\Buildings_Footprints\V2\V2fix.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Building_Poly_Sp_JoS_2</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>Join_Count</field_name><field_name>TARGET_FID</field_name><field_name>Join_Count_1</field_name><field_name>TARGET_FID_1</field_name></DeleteField></workflow><workflow><AddField><field_name>Footprint_SQFT</field_name><field_type>LONG</field_type><field_alias>Footprint_SQFT</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Prop_ID_County</field_name><field_type>TEXT</field_type><field_length>50</field_length><field_alias>Prop_ID_County</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateField Building_Poly_Sp_JoS_2 county !COUNTY_1! "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateGeometryAttributes Building_Poly_Sp_JoS_2 "Footprint_SQFT AREA_GEODESIC" # "Square feet (United States)" PROJCS["NAD_1983_NSRS2007_Texas_Centric_Mapping_System_Lambert",GEOGCS["GCS_NAD_1983_NSRS2007",DATUM["D_NAD_1983_NSRS2007",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",1500000.0],PARAMETER["False_Northing",5000000.0],PARAMETER["Central_Meridian",-100.0],PARAMETER["Standard_Parallel_1",27.5],PARAMETER["Standard_Parallel_2",35.0],PARAMETER["Latitude_Of_Origin",18.0],UNIT["Meter",1.0]] "Same as input"
CalculateField Building_Poly_Sp_JoS_2 BUILDING_SQFT !Footprint_SQFT! "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Building_Poly_Sp_JoS_2 BUILDING_SQFT "!Footprint_SQFT! * 1.5" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Building_Poly_Sp_JoS_2 BUILDING_SQFT "!Footprint_SQFT! * 1.5" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Building_Poly_Sp_JoS_2 BUILDING_SQFT "!Footprint_SQFT! * 1.25" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Building_Poly_Sp_JoS_2 BUILDING_SQFT "$feature.Footprint_SQFT * Left($feature.STORIES_NUMBER, 1)" Arcade # Text NO_ENFORCE_DOMAINS
CalculateField Building_Poly_Sp_JoS_2 BUILDING_SQFT "$feature.Footprint_SQFT * Left($feature.STORIES_NUMBER, 1)" Arcade # Text NO_ENFORCE_DOMAINS
CalculateField Building_Poly_Sp_JoS_2 BUILDING_SQFT "$feature.Footprint_SQFT * 1.5" Arcade # Text NO_ENFORCE_DOMAINS
CalculateField Building_Poly_Sp_JoS_2 BUILDING_SQFT "$feature.Footprint_SQFT * $feature.STORIES_NUMBER" Arcade # Text NO_ENFORCE_DOMAINS
CalculateField Building_Poly_Sp_JoS_2 Damage_Curve 139 "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Building_Poly_Sp_JoS_2 prop_id !OBJECTID! "Python 3" # Text NO_ENFORCE_DOMAINS
SpatialJoin Building_Poly_Sp_JoS_2 txdot-2015-county-generalized_tx E:\Buildings_Footprints\V2\V2fix.gdb\Building_Poly_Sp_JoS_21 "Join one to one" KEEP_ALL "prop_id "PROP_ID" true true false 70 Text 0 0,First,#,Building_Poly_Sp_JoS_2,prop_id,0,70;geo_id "GEO_ID" true true false 50 Text 0 0,First,#,Building_Poly_Sp_JoS_2,geo_id,0,50;legal_desc "LEGAL_DESC" true true false 254 Text 0 0,First,#,Building_Poly_Sp_JoS_2,legal_desc,0,254;land_value "LAND_VALUE" true true false 8 Double 0 0,First,#,Building_Poly_Sp_JoS_2,land_value,-1,-1;imp_value "IMP_VALUE" true true false 8 Double 0 0,First,#,Building_Poly_Sp_JoS_2,imp_value,-1,-1;mkt_value "MKT_VALUE" true true false 8 Double 0 0,First,#,Building_Poly_Sp_JoS_2,mkt_value,-1,-1;county "COUNTY" true true false 60 Text 0 0,First,#,Building_Poly_Sp_JoS_2,county,0,60;tax_year "TAX_YEAR" true true false 4 Long 0 0,First,#,Building_Poly_Sp_JoS_2,tax_year,-1,-1;COUNTY_1 "County Name" true true false 100 Text 0 0,First,#,Building_Poly_Sp_JoS_2,COUNTY_1,0,100;USE_CODE_STD_CTGR_DESC_LPS "Land Use Standardized CTGR Description" true true false 100 Text 0 0,First,#,Building_Poly_Sp_JoS_2,USE_CODE_STD_CTGR_DESC_LPS,0,100;VAL_ASSD_LAND "Assessment Value Land" true true false 4 Long 0 0,First,#,Building_Poly_Sp_JoS_2,VAL_ASSD_LAND,-1,-1;VAL_ASSD_IMPRV "Assessment Value Improvement" true true false 4 Long 0 0,First,#,Building_Poly_Sp_JoS_2,VAL_ASSD_IMPRV,-1,-1;VAL_ASSD "Assessment Value" true true false 4 Long 0 0,First,#,Building_Poly_Sp_JoS_2,VAL_ASSD,-1,-1;TAX_YEAR_1 "Tax Year" true true false 4 Long 0 0,First,#,Building_Poly_Sp_JoS_2,TAX_YEAR_1,-1,-1;BUILDING_SQFT "Building Square Foot" true true false 4 Long 0 0,First,#,Building_Poly_Sp_JoS_2,BUILDING_SQFT,-1,-1;STORIES_NUMBER "Number of Stories" true true false 10 Text 0 0,First,#,Building_Poly_Sp_JoS_2,STORIES_NUMBER,0,10;Build_Type_County "Build_Type_County" true true false 80 Text 0 0,First,#,Building_Poly_Sp_JoS_2,Build_Type_County,0,80;BLDGHEIGHT "BLDGHEIGHT" true true false 4 Float 0 0,First,#,Building_Poly_Sp_JoS_2,BLDGHEIGHT,-1,-1;ROOFFORM "ROOFFORM" true true false 255 Text 0 0,First,#,Building_Poly_Sp_JoS_2,ROOFFORM,0,255;Source "Source" true true false 50 Text 0 0,First,#,Building_Poly_Sp_JoS_2,Source,0,50;Fraction_of_SQFT "Fraction_of_SQFT" true true false 4 Float 0 0,First,#,Building_Poly_Sp_JoS_2,Fraction_of_SQFT,-1,-1;Frac_Imp_Val "Frac_Imp_Val" true true false 8 Double 0 0,First,#,Building_Poly_Sp_JoS_2,Frac_Imp_Val,-1,-1;Method "Method" true true false 20 Text 0 0,First,#,Building_Poly_Sp_JoS_2,Method,0,20;Damage_Curve "Damage_Curve" true true false 10 Text 0 0,First,#,Building_Poly_Sp_JoS_2,Damage_Curve,0,10;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,Building_Poly_Sp_JoS_2,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,Building_Poly_Sp_JoS_2,Shape_Area,-1,-1;Footprint_SQFT "Footprint_SQFT" true true false 4 Long 0 0,First,#,Building_Poly_Sp_JoS_2,Footprint_SQFT,-1,-1;Prop_ID_County "Prop_ID_County" true true false 50 Text 0 0,First,#,Building_Poly_Sp_JoS_2,Prop_ID_County,0,50;County_NM "County_NM" true true false 255 Text 0 0,First,#,txdot-2015-county-generalized_tx,CNTY_NM,0,13" "Have their center in" # #
CalculateField Building_Poly_Sp_JoS_21 county !County_NM! "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Building_Poly_Sp_JoS_21 Prop_ID_County "!prop_id! + !county!" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Building_Poly_Sp_JoS_21 Prop_ID_County "Text($feature.prop_id) + $feature.county" Arcade # Text NO_ENFORCE_DOMAINS
CalculateField Building_Poly_Sp_JoS_21 Prop_ID_County "Text($feature.prop_id) + $feature.county" Arcade # Text NO_ENFORCE_DOMAINS
SpatialJoin Building_Poly_Sp_JoS_21 V2_Lidar_OSM_MSAI_SJoin E:\Buildings_Footprints\V2\V2fix.gdb\Building_Poly_Sp_JoS_21_Spat1 "Join one to one" KEEP_ALL "prop_id "PROP_ID" true true false 70 Text 0 0,First,#,Building_Poly_Sp_JoS_21,prop_id,0,70;geo_id "GEO_ID" true true false 50 Text 0 0,First,#,Building_Poly_Sp_JoS_21,geo_id,0,50;legal_desc "LEGAL_DESC" true true false 254 Text 0 0,First,#,Building_Poly_Sp_JoS_21,legal_desc,0,254;land_value "LAND_VALUE" true true false 8 Double 0 0,First,#,Building_Poly_Sp_JoS_21,land_value,-1,-1;imp_value "IMP_VALUE" true true false 8 Double 0 0,First,#,Building_Poly_Sp_JoS_21,imp_value,-1,-1;mkt_value "MKT_VALUE" true true false 8 Double 0 0,First,#,Building_Poly_Sp_JoS_21,mkt_value,-1,-1;county "COUNTY" true true false 60 Text 0 0,First,#,Building_Poly_Sp_JoS_21,county,0,60;tax_year "TAX_YEAR" true true false 4 Long 0 0,First,#,Building_Poly_Sp_JoS_21,tax_year,-1,-1;COUNTY_1 "County Name" true true false 100 Text 0 0,First,#,Building_Poly_Sp_JoS_21,COUNTY_1,0,100;USE_CODE_STD_CTGR_DESC_LPS "Land Use Standardized CTGR Description" true true false 100 Text 0 0,First,#,Building_Poly_Sp_JoS_21,USE_CODE_STD_CTGR_DESC_LPS,0,100;VAL_ASSD_LAND "Assessment Value Land" true true false 4 Long 0 0,First,#,Building_Poly_Sp_JoS_21,VAL_ASSD_LAND,-1,-1;VAL_ASSD_IMPRV "Assessment Value Improvement" true true false 4 Long 0 0,First,#,Building_Poly_Sp_JoS_21,VAL_ASSD_IMPRV,-1,-1;VAL_ASSD "Assessment Value" true true false 4 Long 0 0,First,#,Building_Poly_Sp_JoS_21,VAL_ASSD,-1,-1;TAX_YEAR_1 "Tax Year" true true false 4 Long 0 0,First,#,Building_Poly_Sp_JoS_21,TAX_YEAR_1,-1,-1;BUILDING_SQFT "Building Square Foot" true true false 4 Long 0 0,First,#,Building_Poly_Sp_JoS_21,BUILDING_SQFT,-1,-1;STORIES_NUMBER "Number of Stories" true true false 10 Text 0 0,First,#,Building_Poly_Sp_JoS_21,STORIES_NUMBER,0,10;Build_Type_County "Build_Type_County" true true false 80 Text 0 0,First,#,Building_Poly_Sp_JoS_21,Build_Type_County,0,80;BLDGHEIGHT "BLDGHEIGHT" true true false 4 Float 0 0,First,#,Building_Poly_Sp_JoS_21,BLDGHEIGHT,-1,-1;ROOFFORM "ROOFFORM" true true false 255 Text 0 0,First,#,Building_Poly_Sp_JoS_21,ROOFFORM,0,255;Source "Source" true true false 50 Text 0 0,First,#,Building_Poly_Sp_JoS_21,Source,0,50;Fraction_of_SQFT "Fraction_of_SQFT" true true false 4 Float 0 0,First,#,Building_Poly_Sp_JoS_21,Fraction_of_SQFT,-1,-1;Frac_Imp_Val "Frac_Imp_Val" true true false 8 Double 0 0,First,#,Building_Poly_Sp_JoS_21,Frac_Imp_Val,-1,-1;Method "Method" true true false 20 Text 0 0,First,#,Building_Poly_Sp_JoS_21,Method,0,20;Damage_Curve "Damage_Curve" true true false 10 Text 0 0,First,#,Building_Poly_Sp_JoS_21,Damage_Curve,0,10;Footprint_SQFT "Footprint_SQFT" true true false 4 Long 0 0,First,#,Building_Poly_Sp_JoS_21,Footprint_SQFT,-1,-1;Prop_ID_County "Prop_ID_County" true true false 50 Text 0 0,First,#,Building_Poly_Sp_JoS_21,Prop_ID_County,0,50;Floors "Lidar_Floors" true true false 2 Short 0 0,First,#,V2_Lidar_OSM_MSAI_SJoin,Floors,-1,-1" "Have their center in" # #
CalculateField Building_Poly_Sp_JoS_21_Spat1 BUILDING_SQFT "!Footprint_SQFT! * !Floors!" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Building_Poly_Sp_JoS_21_Spat1 BUILDING_SQFT !Footprint_SQFT! "Python 3" # Text NO_ENFORCE_DOMAINS
AddIndex "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/2.8.0'><WorkspaceConnectionString>DATABASE=E:\Buildings_Footprints\V2\V2fix.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Building_Poly_Sp_JoS_21_Spat1</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" Prop_ID_County Prop_ID_County NON_UNIQUE NON_ASCENDING
CalculateField Building_Poly_Sp_JoS_21_Spat1 imp_value "!BUILDING_SQFT! * 100" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Building_Poly_Sp_JoS_21_Spat1 Method "Estimated" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Building_Poly_Sp_JoS_21_Spat1 USE_CODE_STD_CTGR_DESC_LPS 'Vacant or Unknown' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Building_Poly_Sp_JoS_21_Spat1 USE_CODE_STD_CTGR_DESC_LPS 'Residential' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Building_Poly_Sp_JoS_21_Spat1 USE_CODE_STD_CTGR_DESC_LPS 'Commercial' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Building_Poly_Sp_JoS_21_Spat1 USE_CODE_STD_CTGR_DESC_LPS 'Industrial' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Building_Poly_Sp_JoS_21_Spat1 USE_CODE_STD_CTGR_DESC_LPS 'Public' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Building_Poly_Sp_JoS_21_Spat1 USE_CODE_STD_CTGR_DESC_LPS 'Vacant or Unknown ' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Building_Poly_Sp_JoS_21_Spat1 USE_CODE_STD_CTGR_DESC_LPS 'Vacant or Unknown' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Building_Poly_Sp_JoS_21_Spat1 USE_CODE_STD_CTGR_DESC_LPS 'Agricultural' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Building_Poly_Sp_JoS_21_Spat1 Frac_Imp_Val "!imp_value! * !Fraction_of_SQFT!" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Building_Poly_Sp_JoS_21_Spat1 Frac_Imp_Val 120000 "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Texas_Buildings4a_Extended Frac_Imp_Val "!BUILDING_SQFT! * 71" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Texas_Buildings4a_Extended BUILDING_SQFT !Footprint_SQFT! "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Texas_Buildings4a_Extended Frac_Imp_Val "!BUILDING_SQFT! * 74" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Texas_Buildings4a_Extended Method 'Estimated' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Texas_Buildings4a_Extended Frac_Imp_Val "!BUILDING_SQFT! * 60" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Texas_Buildings4a_Extended Frac_Imp_Val "!Footprint_SQFT! * 96" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Texas_Buildings4a_Extended Frac_Imp_Val "!Footprint_SQFT! * 98" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Texas_Buildings4a_Extended Method 'Estimated' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Texas_Buildings4a_Extended Frac_Imp_Val "!Footprint_SQFT! * 100" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Texas_Buildings4a_Extended Frac_Imp_Val "!Footprint_SQFT! * 54" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Texas_Buildings4a_Extended Method 'E' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Texas_Buildings4a_Extended Frac_Imp_Val "1.5 * !Footprint_SQFT! * 52" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Texas_Buildings4a_Extended Frac_Imp_Val "!Floors! * !Footprint_SQFT! * 51" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Texas_Buildings4a_Extended Method 'Estimated' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Texas_Buildings4a_Extended Method 'Estimated' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Texas_Buildings4a_Extended Frac_Imp_Val "!Footprint_SQFT! * 39" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Texas_Buildings4a_Extended Frac_Imp_Val "!Footprint_SQFT! * 39 * !Floors!" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Texas_Buildings4a_Extended Frac_Imp_Val "67.96 * !Footprint_SQFT!" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Texas_Buildings4a_Extended Frac_Imp_Val "34.48 * !Footprint_SQFT!" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Texas_Buildings4a_Extended Method 'Estimated' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Texas_Buildings4a_Extended Frac_Imp_Val "69.97 * !Footprint_SQFT!" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Texas_Buildings4a_Extended Frac_Imp_Val "100 * !Footprint_SQFT!" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Texas_Buildings4a_Extended Frac_Imp_Val "100 * !Footprint_SQFT!" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Texas_Buildings4a_Extended Frac_Imp_Val "100 * !Footprint_SQFT!" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Texas_Buildings4a_Extended Frac_Imp_Val "100 * !Footprint_SQFT!" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Texas_Buildings4a_Extended Prop_ID_County Concatenate($feature.USE_CODE_STD_CTGR_DESC_LPS,'_',$feature.county) Arcade # 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/2.8.0'><WorkspaceConnectionString>DATABASE=E:\Buildings_Footprints\V2\V2fix.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Building_Poly_Sp_JoS_21_Spat1</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>GIS_Floors</field_name><field_type>SHORT</field_type><field_alias>GIS_Floors</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>GIS_Building_SQFT</field_name><field_type>LONG</field_type><field_alias>GIS_Building_SQFT</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></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/2.8.0'><WorkspaceConnectionString>DATABASE=E:\Buildings_Footprints\V2\V2fix.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Building_Poly_Sp_JoS_21_Spat1</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><DeleteField><field_name>GIS_Floors</field_name></DeleteField></workflow><workflow><AddField><field_name>GIS_Floors</field_name><field_type>FLOAT</field_type><field_alias>Number of floors (GIS)</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>"
CalculateField Texas_Buildings4a_Extended GIS_Floors !Floors! "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Texas_Buildings4a_Extended Fraction_of_SQFT "!Footprint_SQFT! / 35839" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Texas_Buildings4a_Extended Frac_Imp_Val "!imp_value! * !Fraction_of_SQFT!" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Texas_Buildings4a_Extended GIS_Floors !STORIES_NUMBER! "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Texas_Buildings4a_Extended GIS_Floors !STORIES_NUMBER!.replace('+AB','') "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Texas_Buildings4a_Extended GIS_Floors !STORIES_NUMBER!.replace('+B','') "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Texas_Buildings4a_Extended GIS_Floors 1 "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Texas_Buildings4a_Extended GIS_Building_SQFT !Footprint_SQFT! "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Texas_Buildings4a_Extended GIS_Building_SQFT "!Footprint_SQFT! * !GIS_Floors!" "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Texas_Buildings4a_Extended Method 'Estimated' "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField Texas_Buildings4a_Extended Source 'Microsoft AI V1' "Python 3" # Text NO_ENFORCE_DOMAINS
FeatureClassToFeatureClass Texas_Buildings4a_Extended S:\Shared\90Temp\Cynthia_Roush\Buildings_Footprints_V2.gdb Texas_Buildings4a_Extended # "Join_Count "Join_Count" true true false 4 Long 0 0,First,#,Texas_Buildings4a_Extended,Join_Count,-1,-1;TARGET_FID "TARGET_FID" true true false 4 Long 0 0,First,#,Texas_Buildings4a_Extended,TARGET_FID,-1,-1;prop_id "PROP_ID" true true false 70 Text 0 0,First,#,Texas_Buildings4a_Extended,prop_id,0,70;geo_id "GEO_ID" true true false 50 Text 0 0,First,#,Texas_Buildings4a_Extended,geo_id,0,50;legal_desc "LEGAL_DESC" true true false 254 Text 0 0,First,#,Texas_Buildings4a_Extended,legal_desc,0,254;land_value "LAND_VALUE" true true false 8 Double 0 0,First,#,Texas_Buildings4a_Extended,land_value,-1,-1;imp_value "IMP_VALUE" true true false 8 Double 0 0,First,#,Texas_Buildings4a_Extended,imp_value,-1,-1;mkt_value "MKT_VALUE" true true false 8 Double 0 0,First,#,Texas_Buildings4a_Extended,mkt_value,-1,-1;county "COUNTY" true true false 60 Text 0 0,First,#,Texas_Buildings4a_Extended,county,0,60;tax_year "TAX_YEAR" true true false 4 Long 0 0,First,#,Texas_Buildings4a_Extended,tax_year,-1,-1;COUNTY_1 "County Name" true true false 100 Text 0 0,First,#,Texas_Buildings4a_Extended,COUNTY_1,0,100;USE_CODE_STD_CTGR_DESC_LPS "Land Use Standardized CTGR Description" true true false 100 Text 0 0,First,#,Texas_Buildings4a_Extended,USE_CODE_STD_CTGR_DESC_LPS,0,100;VAL_ASSD_LAND "Assessment Value Land" true true false 4 Long 0 0,First,#,Texas_Buildings4a_Extended,VAL_ASSD_LAND,-1,-1;VAL_ASSD_IMPRV "Assessment Value Improvement" true true false 4 Long 0 0,First,#,Texas_Buildings4a_Extended,VAL_ASSD_IMPRV,-1,-1;VAL_ASSD "Assessment Value" true true false 4 Long 0 0,First,#,Texas_Buildings4a_Extended,VAL_ASSD,-1,-1;TAX_YEAR_1 "Tax Year" true true false 4 Long 0 0,First,#,Texas_Buildings4a_Extended,TAX_YEAR_1,-1,-1;BUILDING_SQFT "Building Square Foot" true true false 4 Long 0 0,First,#,Texas_Buildings4a_Extended,BUILDING_SQFT,-1,-1;STORIES_NUMBER "Number of Stories" true true false 10 Text 0 0,First,#,Texas_Buildings4a_Extended,STORIES_NUMBER,0,10;Build_Type_County "Build_Type_County" true true false 80 Text 0 0,First,#,Texas_Buildings4a_Extended,Build_Type_County,0,80;BLDGHEIGHT "BLDGHEIGHT" true true false 4 Float 0 0,First,#,Texas_Buildings4a_Extended,BLDGHEIGHT,-1,-1;ROOFFORM "ROOFFORM" true true false 255 Text 0 0,First,#,Texas_Buildings4a_Extended,ROOFFORM,0,255;Source "Source" true true false 50 Text 0 0,First,#,Texas_Buildings4a_Extended,Source,0,50;Fraction_of_SQFT "Fraction_of_SQFT" true true false 4 Float 0 0,First,#,Texas_Buildings4a_Extended,Fraction_of_SQFT,-1,-1;Frac_Imp_Val "Frac_Imp_Val" true true false 8 Double 0 0,First,#,Texas_Buildings4a_Extended,Frac_Imp_Val,-1,-1;Method "Method" true true false 20 Text 0 0,First,#,Texas_Buildings4a_Extended,Method,0,20;Damage_Curve "Damage_Curve" true true false 10 Text 0 0,First,#,Texas_Buildings4a_Extended,Damage_Curve,0,10;Footprint_SQFT "Footprint_SQFT" true true false 4 Long 0 0,First,#,Texas_Buildings4a_Extended,Footprint_SQFT,-1,-1;Prop_ID_County "Prop_ID_County" true true false 50 Text 0 0,First,#,Texas_Buildings4a_Extended,Prop_ID_County,0,50;Floors "Lidar_Floors" true true false 2 Short 0 0,First,#,Texas_Buildings4a_Extended,Floors,-1,-1;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,Texas_Buildings4a_Extended,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,Texas_Buildings4a_Extended,Shape_Area,-1,-1;GIS_Building_SQFT "GIS_Building_SQFT" true true false 4 Long 0 0,First,#,Texas_Buildings4a_Extended,GIS_Building_SQFT,-1,-1;GIS_Floors "Number of floors (GIS)" true true false 4 Float 0 0,First,#,Texas_Buildings4a_Extended,GIS_Floors,-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/2.7.0'><WorkspaceConnectionString>DATABASE=C:\Users\CRoush\Documents\GIS_Resources\Buildings\Buildings_Footprints_V2.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Texas_Buildings4a_Extended</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Temp_Long</field_name><field_type>LONG</field_type><field_alias>Temp_Long</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
FeatureClassToFeatureClass C:\Users\CRoush\Documents\GIS_Resources\Buildings\Buildings_Footprints_V2.gdb\Texas_Buildings4a_Extended C:\Users\CRoush\Documents\Pop_Calc_Project_v2\Pop_Calc_20210816.gdb TX_Bldgs4a_Ext_ge_500sqft "BUILDING_SQFT >= 500" "Bldg_ID "Bldg_ID" false false true 254 Long 0 0,First,",",C:\Users\CRoush\Documents\GIS_Resources\Buildings\Buildings_Footprints_V2.gdb\Texas_Buildings4a_Extended,OBJECTID,-1,-1;BLDG_SQFT "BLDG_SQFT" true true false 254 Long 0 0,First,",",C:\Users\CRoush\Documents\GIS_Resources\Buildings\Buildings_Footprints_V2.gdb\Texas_Buildings4a_Extended,GIS_Building_SQFT,-1,-1;FTPRNT_SQFT "FTPRNT_SQFT" true true false 254 Long 0 0,First,",",C:\Users\CRoush\Documents\GIS_Resources\Buildings\Buildings_Footprints_V2.gdb\Texas_Buildings4a_Extended,Footprint_SQFT,-1,-1;IMP_VALUE "IMP_VALUE" true true false 254 Float 0 0,First,",",C:\Users\CRoush\Documents\GIS_Resources\Buildings\Buildings_Footprints_V2.gdb\Texas_Buildings4a_Extended,imp_value,-1,-1;USE_CODE "USE_CODE" true true false 254 Text 0 0,First,",",C:\Users\CRoush\Documents\GIS_Resources\Buildings\Buildings_Footprints_V2.gdb\Texas_Buildings4a_Extended,USE_CODE_STD_CTGR_DESC_LPS,0,100;ASSD_IMP "ASSD_IMP" true true false 254 Long 0 0,First,",",C:\Users\CRoush\Documents\GIS_Resources\Buildings\Buildings_Footprints_V2.gdb\Texas_Buildings4a_Extended,VAL_ASSD_IMPRV,-1,-1;BLD_TYPE_CNTY "BLD_TYPE_CNTY" true true false 254 Text 0 0,First,",",C:\Users\CRoush\Documents\GIS_Resources\Buildings\Buildings_Footprints_V2.gdb\Texas_Buildings4a_Extended,Build_Type_County,0,80;SRC "SRC" true true false 254 Text 0 0,First,",",C:\Users\CRoush\Documents\GIS_Resources\Buildings\Buildings_Footprints_V2.gdb\Texas_Buildings4a_Extended,Source,0,50;FRAC_SQFT "FRAC_SQFT" true true false 254 Float 0 0,First,",",C:\Users\CRoush\Documents\GIS_Resources\Buildings\Buildings_Footprints_V2.gdb\Texas_Buildings4a_Extended,Fraction_of_SQFT,-1,-1;FRAC_IMP "FRAC_IMP" true true false 254 Long 0 0,First,",",C:\Users\CRoush\Documents\GIS_Resources\Buildings\Buildings_Footprints_V2.gdb\Texas_Buildings4a_Extended,Frac_Imp_Val,-1,-1;IMP_METHOD "IMP_METHOD" true true false 254 Text 0 0,First,",",C:\Users\CRoush\Documents\GIS_Resources\Buildings\Buildings_Footprints_V2.gdb\Texas_Buildings4a_Extended,Method,0,20;PARCEL_ID "PARCEL_ID" true true false 254 Text 0 0,First,",",C:\Users\CRoush\Documents\GIS_Resources\Buildings\Buildings_Footprints_V2.gdb\Texas_Buildings4a_Extended,Prop_ID_County,0,50;LIDAR_FLOORS "LIDAR_FLOORS" true true false 254 Short 0 0,First,",",C:\Users\CRoush\Documents\GIS_Resources\Buildings\Buildings_Footprints_V2.gdb\Texas_Buildings4a_Extended,Floors,-1,-1" #
CalculateField C:\Users\CRoush\Documents\Pop_Calc_Project_v2\Pop_Calc_20210816.gdb\TX_Bldgs4a_Ext_ge_500sqft SQFT_MULT !BLDG_SQFT!/!FTPRNT_SQFT! "Python 3" # "Float (single precision)"
SpatialJoin C:\Users\CRoush\Documents\Pop_Calc_Project_v2\Pop_Calc_20210816.gdb\TX_Bldgs4a_Ext_ge_500sqft C:\Users\CRoush\Documents\GIS_Resources\FPRs_generalized_coast\FPRs_generalized_coast.gdb\FPR03 C:\Users\CRoush\Documents\Pop_Calc_Project_v2\Pop_Calc_20210816.gdb\FPR03_TX_Bldgs4a_Ext_ge_500sqft "Join one to one" KEEP_COMMON "Bldg_ID "Bldg_ID" true false false 4 Long 0 0,First,#,C:\Users\CRoush\Documents\Pop_Calc_Project_v2\Pop_Calc_20210816.gdb\TX_Bldgs4a_Ext_ge_500sqft,Bldg_ID,-1,-1;BLDG_SQFT "BLDG_SQFT" true true false 4 Long 0 0,First,#,C:\Users\CRoush\Documents\Pop_Calc_Project_v2\Pop_Calc_20210816.gdb\TX_Bldgs4a_Ext_ge_500sqft,BLDG_SQFT,-1,-1;FTPRNT_SQFT "FTPRNT_SQFT" true true false 4 Long 0 0,First,#,C:\Users\CRoush\Documents\Pop_Calc_Project_v2\Pop_Calc_20210816.gdb\TX_Bldgs4a_Ext_ge_500sqft,FTPRNT_SQFT,-1,-1;IMP_VALUE "IMP_VALUE" true true false 4 Float 0 0,First,#,C:\Users\CRoush\Documents\Pop_Calc_Project_v2\Pop_Calc_20210816.gdb\TX_Bldgs4a_Ext_ge_500sqft,IMP_VALUE,-1,-1;USE_CODE "USE_CODE" true true false 254 Text 0 0,First,#,C:\Users\CRoush\Documents\Pop_Calc_Project_v2\Pop_Calc_20210816.gdb\TX_Bldgs4a_Ext_ge_500sqft,USE_CODE,0,254;ASSD_IMP "ASSD_IMP" true true false 4 Long 0 0,First,#,C:\Users\CRoush\Documents\Pop_Calc_Project_v2\Pop_Calc_20210816.gdb\TX_Bldgs4a_Ext_ge_500sqft,ASSD_IMP,-1,-1;BLD_TYPE_CNTY "BLD_TYPE_CNTY" true true false 254 Text 0 0,First,#,C:\Users\CRoush\Documents\Pop_Calc_Project_v2\Pop_Calc_20210816.gdb\TX_Bldgs4a_Ext_ge_500sqft,BLD_TYPE_CNTY,0,254;SRC "SRC" true true false 254 Text 0 0,First,#,C:\Users\CRoush\Documents\Pop_Calc_Project_v2\Pop_Calc_20210816.gdb\TX_Bldgs4a_Ext_ge_500sqft,SRC,0,254;FRAC_SQFT "FRAC_SQFT" true true false 4 Float 0 0,First,#,C:\Users\CRoush\Documents\Pop_Calc_Project_v2\Pop_Calc_20210816.gdb\TX_Bldgs4a_Ext_ge_500sqft,FRAC_SQFT,-1,-1;FRAC_IMP "FRAC_IMP" true true false 4 Long 0 0,First,#,C:\Users\CRoush\Documents\Pop_Calc_Project_v2\Pop_Calc_20210816.gdb\TX_Bldgs4a_Ext_ge_500sqft,FRAC_IMP,-1,-1;IMP_METHOD "IMP_METHOD" true true false 254 Text 0 0,First,#,C:\Users\CRoush\Documents\Pop_Calc_Project_v2\Pop_Calc_20210816.gdb\TX_Bldgs4a_Ext_ge_500sqft,IMP_METHOD,0,254;PARCEL_ID "PARCEL_ID" true true false 254 Text 0 0,First,#,C:\Users\CRoush\Documents\Pop_Calc_Project_v2\Pop_Calc_20210816.gdb\TX_Bldgs4a_Ext_ge_500sqft,PARCEL_ID,0,254;LIDAR_FLOORS "LIDAR_FLOORS" true true false 2 Short 0 0,First,#,C:\Users\CRoush\Documents\Pop_Calc_Project_v2\Pop_Calc_20210816.gdb\TX_Bldgs4a_Ext_ge_500sqft,LIDAR_FLOORS,-1,-1;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,C:\Users\CRoush\Documents\Pop_Calc_Project_v2\Pop_Calc_20210816.gdb\TX_Bldgs4a_Ext_ge_500sqft,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,C:\Users\CRoush\Documents\Pop_Calc_Project_v2\Pop_Calc_20210816.gdb\TX_Bldgs4a_Ext_ge_500sqft,Shape_Area,-1,-1;SQFT_MULT "SQFT_MULT" true true false 4 Float 0 0,First,#,C:\Users\CRoush\Documents\Pop_Calc_Project_v2\Pop_Calc_20210816.gdb\TX_Bldgs4a_Ext_ge_500sqft,SQFT_MULT,-1,-1;RFPG_NAME "RFPG_NAME" true true false 50 Text 0 0,First,#,C:\Users\CRoush\Documents\GIS_Resources\FPRs_generalized_coast\FPRs_generalized_coast.gdb\FPR03,RFPG_NAME,0,50;RFPG_NUM "RFPG_NUM" true true false 4 Long 0 0,First,#,C:\Users\CRoush\Documents\GIS_Resources\FPRs_generalized_coast\FPRs_generalized_coast.gdb\FPR03,RFPG_NUM,-1,-1;Shape_Leng "Shape_Leng" true true false 8 Double 0 0,First,#,C:\Users\CRoush\Documents\GIS_Resources\FPRs_generalized_coast\FPRs_generalized_coast.gdb\FPR03,Shape_Leng,-1,-1;Suffix "Suffix" true true false 10 Text 0 0,First,#,C:\Users\CRoush\Documents\GIS_Resources\FPRs_generalized_coast\FPRs_generalized_coast.gdb\FPR03,Suffix,0,10;URL "URL" true true false 254 Text 0 0,First,#,C:\Users\CRoush\Documents\GIS_Resources\FPRs_generalized_coast\FPRs_generalized_coast.gdb\FPR03,URL,0,254;Region "Region" true true false 254 Text 0 0,First,#,C:\Users\CRoush\Documents\GIS_Resources\FPRs_generalized_coast\FPRs_generalized_coast.gdb\FPR03,Region,0,254;Shape_Length_1 "Shape_Length" false true true 8 Double 0 0,First,#,C:\Users\CRoush\Documents\GIS_Resources\FPRs_generalized_coast\FPRs_generalized_coast.gdb\FPR03,Shape_Length,-1,-1;Shape_Area_1 "Shape_Area" false true true 8 Double 0 0,First,#,C:\Users\CRoush\Documents\GIS_Resources\FPRs_generalized_coast\FPRs_generalized_coast.gdb\FPR03,Shape_Area,-1,-1" "Within a distance" "150 Unknown" #
JoinField C:\Users\CRoush\Documents\Pop_Calc_Project_v2\Pop_Calc_20210816.gdb\FPR03_TX_Bldgs4a_Ext_ge_500sqft Bldg_ID C:\Users\CRoush\Documents\Pop_Calc_Project_v2\Pop_Calc_20210816.gdb\FPR03_bldg_pop_table Bldg_ID SUM_NIGHT_POP_BLDG_PART;SUM_DAY_POP_BLDG_PART
SpatialJoin C:\Users\CRoush\Documents\Pop_Calc_Project_v2\Pop_Calc_20210816.gdb\FPR03_TX_Bldgs4a_Ext_ge_500sqft C:\Users\CRoush\Documents\GIS_Resources\GIS_Resources_for_Flood_Planning.gdb\SVI2018_Texas_tract_CDC_2018 C:\Users\CRoush\Documents\GIS_Resources\Buildings\Bldgs_SVI_Pop_Aug2021.gdb\Bldgs_Pop_SVI_FPR03 "Join one to one" KEEP_ALL "Bldg_ID "Bldg_ID" true true false 254 Text 0 0,First,",",C:\Users\CRoush\Documents\Pop_Calc_Project_v2\Pop_Calc_20210816.gdb\FPR03_TX_Bldgs4a_Ext_ge_500sqft,Bldg_ID,-1,-1;Est_Night_Pop "Est_Night_Pop" true true false 254 Long 0 0,First,",",C:\Users\CRoush\Documents\Pop_Calc_Project_v2\Pop_Calc_20210816.gdb\FPR03_TX_Bldgs4a_Ext_ge_500sqft,SUM_NIGHT_POP_BLDG_PART,-1,-1;Est_Day_Pop "Est_Day_Pop" true true false 254 Long 0 0,First,",",C:\Users\CRoush\Documents\Pop_Calc_Project_v2\Pop_Calc_20210816.gdb\FPR03_TX_Bldgs4a_Ext_ge_500sqft,SUM_DAY_POP_BLDG_PART,-1,-1;Simp_type "Simp_type" true true false 254 Text 0 0,First,",",C:\Users\CRoush\Documents\Pop_Calc_Project_v2\Pop_Calc_20210816.gdb\FPR03_TX_Bldgs4a_Ext_ge_500sqft,USE_CODE,0,254;SVI "SVI" true true false 254 Float 0 0,First,",",C:\Users\CRoush\Documents\GIS_Resources\GIS_Resources_for_Flood_Planning.gdb\SVI2018_Texas_tract_CDC_2018,RPL_THEMES,-1,-1;Est_value "Est_value" true true false 254 Text 0 0,First,",",C:\Users\CRoush\Documents\Pop_Calc_Project_v2\Pop_Calc_20210816.gdb\FPR03_TX_Bldgs4a_Ext_ge_500sqft,FRAC_IMP,-1,-1;Est_floors "Est_floors" true true false 254 Long 0 0,First,",",C:\Users\CRoush\Documents\Pop_Calc_Project_v2\Pop_Calc_20210816.gdb\FPR03_TX_Bldgs4a_Ext_ge_500sqft,LIDAR_FLOORS,-1,-1" "Have their center in" # #
SpatialJoin C:\Users\CRoush\Documents\GIS_Resources\Buildings\Bldgs_SVI_Pop_Aug2021.gdb\Bldgs_Pop_SVI_FPR03 C:\Users\CRoush\Documents\GIS_Resources\Buildings\Buildings_Aug2021_TNRIS.gdb\Buildings_Aug2021_TNRIS C:\Users\CRoush\Documents\ArcGIS\Projects\MyWorkspace\MyWorkspace.gdb\fpr03_check_value_match "Join one to one" KEEP_ALL "Bldg_ID "Bldg_ID" true true false 254 Long 0 0,First,",",C:\Users\CRoush\Documents\GIS_Resources\Buildings\Bldgs_SVI_Pop_Aug2021.gdb\Bldgs_Pop_SVI_FPR03,Bldg_ID,0,254;Est_Night_Pop "Est_Night_Pop" true true false 254 Long 0 0,First,",",C:\Users\CRoush\Documents\GIS_Resources\Buildings\Bldgs_SVI_Pop_Aug2021.gdb\Bldgs_Pop_SVI_FPR03,Est_Night_Pop,-1,-1;Est_Day_Pop "Est_Day_Pop" true true false 254 Long 0 0,First,",",C:\Users\CRoush\Documents\GIS_Resources\Buildings\Bldgs_SVI_Pop_Aug2021.gdb\Bldgs_Pop_SVI_FPR03,Est_Day_Pop,-1,-1;Simp_type "Simp_type" true true false 254 Text 0 0,First,",",C:\Users\CRoush\Documents\GIS_Resources\Buildings\Bldgs_SVI_Pop_Aug2021.gdb\Bldgs_Pop_SVI_FPR03,Simp_type,0,254;SVI "SVI" true true false 254 Float 0 0,First,",",C:\Users\CRoush\Documents\GIS_Resources\Buildings\Bldgs_SVI_Pop_Aug2021.gdb\Bldgs_Pop_SVI_FPR03,SVI,-1,-1;Est_value_old "Est_value_old" true true false 254 Float 0 0,First,",",C:\Users\CRoush\Documents\GIS_Resources\Buildings\Bldgs_SVI_Pop_Aug2021.gdb\Bldgs_Pop_SVI_FPR03,Est_value,0,254;Est_floors "Est_floors" true true false 254 Float 0 0,First,",",C:\Users\CRoush\Documents\GIS_Resources\Buildings\Bldgs_SVI_Pop_Aug2021.gdb\Bldgs_Pop_SVI_FPR03,Est_floors,-1,-1;Est_value "Est_value" true true false 254 Float 0 0,First,",",C:\Users\CRoush\Documents\GIS_Resources\Buildings\Buildings_Aug2021_TNRIS.gdb\Buildings_Aug2021_TNRIS,Frac_Imp_Val,-1,-1;Ftprnt_sqft "Ftprnt_sqft" true true false 254 Float 0 0,First,",",C:\Users\CRoush\Documents\GIS_Resources\Buildings\Buildings_Aug2021_TNRIS.gdb\Buildings_Aug2021_TNRIS,Footprint_SQFT,-1,-1" "Have their center in" # #
FeatureClassToFeatureClass C:\Users\CRoush\Documents\ArcGIS\Projects\MyWorkspace\MyWorkspace.gdb\fpr03_check_value_match C:\Users\CRoush\Documents\GIS_Resources\Buildings\Bldgs_SVI_Pop_Aug2021_03.gdb Bldgs_SVI_Pop_Aug2021_FPR03 # "Bldg_ID "Bldg_ID" true true false 254 Long 0 0,First,",",C:\Users\CRoush\Documents\ArcGIS\Projects\MyWorkspace\MyWorkspace.gdb\fpr03_check_value_match,Bldg_ID,-1,-1;Est_Night_Pop "Est_Night_Pop" true true false 254 Long 0 0,First,",",C:\Users\CRoush\Documents\ArcGIS\Projects\MyWorkspace\MyWorkspace.gdb\fpr03_check_value_match,Est_Night_Pop,-1,-1;Est_Day_Pop "Est_Day_Pop" true true false 254 Long 0 0,First,",",C:\Users\CRoush\Documents\ArcGIS\Projects\MyWorkspace\MyWorkspace.gdb\fpr03_check_value_match,Est_Day_Pop,-1,-1;Simp_type "Simp_type" true true false 254 Text 0 0,First,",",C:\Users\CRoush\Documents\ArcGIS\Projects\MyWorkspace\MyWorkspace.gdb\fpr03_check_value_match,Simp_type,0,254;SVI "SVI" true true false 254 Float 0 0,First,",",C:\Users\CRoush\Documents\ArcGIS\Projects\MyWorkspace\MyWorkspace.gdb\fpr03_check_value_match,SVI,-1,-1;Est_floors "Est_floors" true true false 254 Float 0 0,First,",",C:\Users\CRoush\Documents\ArcGIS\Projects\MyWorkspace\MyWorkspace.gdb\fpr03_check_value_match,Est_floors,-1,-1;Est_value "Est_value" true true false 254 Float 0 0,First,",",C:\Users\CRoush\Documents\ArcGIS\Projects\MyWorkspace\MyWorkspace.gdb\fpr03_check_value_match,Est_value,-1,-1;Ftprnt_sqft "Ftprnt_sqft" true true false 254 Float 0 0,First,",",C:\Users\CRoush\Documents\ArcGIS\Projects\MyWorkspace\MyWorkspace.gdb\fpr03_check_value_match,Ftprnt_sqft,-1,-1" #
AddField C:\Users\CRoush\Documents\GIS_Resources\Buildings\Bldgs_SVI_Pop_Aug2021_FPR03.gdb\Bldgs_SVI_Pop_Aug2021_FPR03 CentroidX "Double (double precision)" # # # # NULLABLE NON_REQUIRED #
AddField C:\Users\CRoush\Documents\GIS_Resources\Buildings\Bldgs_SVI_Pop_Aug2021_FPR03.gdb\Bldgs_SVI_Pop_Aug2021_FPR03 CentroidY "Double (double precision)" # # # # NULLABLE NON_REQUIRED #
CalculateFields C:\Users\CRoush\Documents\GIS_Resources\Buildings\Bldgs_SVI_Pop_Aug2021_FPR03.gdb\Bldgs_SVI_Pop_Aug2021_FPR03 "Python 3" "CentroidX !SHAPE.CENTROID.X!;CentroidY !SHAPE.CENTROID.Y!" #
PairwiseDissolve C:\Users\CRoush\Documents\GIS_Resources\Buildings\Bldgs_SVI_Pop_Aug2021_FPR03.gdb\Bldgs_SVI_Pop_Aug2021_FPR03 C:\Users\CRoush\Documents\Bldg_Footprint_Modification\buildings_remove_duplicates.gdb\FPR03_Bldgs_dissolved # # SINGLE_PART
SpatialJoin C:\Users\CRoush\Documents\Bldg_Footprint_Modification\buildings_remove_duplicates.gdb\FPR03_Bldgs_dissolved C:\Users\CRoush\Documents\GIS_Resources\Buildings\Bldgs_SVI_Pop_Aug2021_FPR03.gdb\Bldgs_SVI_Pop_Aug2021_FPR03 C:\Users\CRoush\Documents\Bldg_Footprint_Modification\buildings_remove_duplicates.gdb\FPR03_Bldgs_dissolved_with_fields_added "Join one to one" KEEP_ALL "Bldg_ID "Bldg_ID" true true false 254 Text 0 0,First,",",C:\Users\CRoush\Documents\GIS_Resources\Buildings\Bldgs_SVI_Pop_Aug2021_FPR03.gdb\Bldgs_SVI_Pop_Aug2021_FPR03,Bldg_ID,-1,-1;Simp_type "Simp_type" true true false 254 Text 0 0,First,",",C:\Users\CRoush\Documents\GIS_Resources\Buildings\Bldgs_SVI_Pop_Aug2021_FPR03.gdb\Bldgs_SVI_Pop_Aug2021_FPR03,Simp_type,0,254;SVI "SVI" true true false 254 Text 0 0,First,",",C:\Users\CRoush\Documents\GIS_Resources\Buildings\Bldgs_SVI_Pop_Aug2021_FPR03.gdb\Bldgs_SVI_Pop_Aug2021_FPR03,SVI,-1,-1;Est_floors "Est_floors" true true false 254 Text 0 0,First,",",C:\Users\CRoush\Documents\GIS_Resources\Buildings\Bldgs_SVI_Pop_Aug2021_FPR03.gdb\Bldgs_SVI_Pop_Aug2021_FPR03,Est_floors,-1,-1;Prev_Bldg_IDs "Prev_Bldg_IDs" true true false 254 Text 0 0,Join,",",C:\Users\CRoush\Documents\GIS_Resources\Buildings\Bldgs_SVI_Pop_Aug2021_FPR03.gdb\Bldgs_SVI_Pop_Aug2021_FPR03,Bldg_ID,-1,-1" "Have their center in" # #
DeleteField C:\Users\CRoush\Documents\Bldg_Footprint_Modification\buildings_remove_duplicates.gdb\FPR03_Bldgs_dissolved_with_fields_added Join_Count;TARGET_FID
JoinField C:\Users\CRoush\Documents\Bldg_Footprint_Modification\buildings_remove_duplicates.gdb\FPR03_Bldgs_dissolved_with_fields_added Bldg_ID C:\Users\CRoush\Documents\Bldg_Footprint_Modification\add_pop_to_single_layer_bldgs.gdb\FPR03_bldg_pop_table Bldg_ID SUM_NIGHT_POP_BLDG_PART;SUM_DAY_POP_BLDG_PART
SpatialJoin C:\Users\CRoush\Documents\Bldg_Footprint_Modification\buildings_remove_duplicates.gdb\FPR03_Bldgs_dissolved_with_fields_added C:\Users\CRoush\Documents\GIS_Resources\Buildings\Bldgs_SVI_Pop_Aug2021_FPR03.gdb\Bldgs_SVI_Pop_Aug2021_FPR03 C:\Users\CRoush\Documents\Bldg_Footprint_Modification\buildings_remove_duplicates.gdb\FPR03_Bldgs_diss_w_fields_added_v2 "Join one to one" KEEP_ALL "Bldg_ID "Bldg_ID" true true false 254 Text 0 0,First,",",C:\Users\CRoush\Documents\GIS_Resources\Buildings\Bldgs_SVI_Pop_Aug2021_FPR03.gdb\Bldgs_SVI_Pop_Aug2021_FPR03,Bldg_ID,-1,-1;Simp_type "Simp_type" true true false 254 Text 0 0,First,",",C:\Users\CRoush\Documents\GIS_Resources\Buildings\Bldgs_SVI_Pop_Aug2021_FPR03.gdb\Bldgs_SVI_Pop_Aug2021_FPR03,Simp_type,0,254;SVI "SVI" true true false 254 Text 0 0,First,",",C:\Users\CRoush\Documents\GIS_Resources\Buildings\Bldgs_SVI_Pop_Aug2021_FPR03.gdb\Bldgs_SVI_Pop_Aug2021_FPR03,SVI,-1,-1;Est_floors "Est_floors" true true false 254 Text 0 0,First,",",C:\Users\CRoush\Documents\GIS_Resources\Buildings\Bldgs_SVI_Pop_Aug2021_FPR03.gdb\Bldgs_SVI_Pop_Aug2021_FPR03,Est_floors,-1,-1;Prev_Bldg_IDs "Prev_Bldg_IDs" true true false 254 Text 0 0,Join,",",C:\Users\CRoush\Documents\GIS_Resources\Buildings\Bldgs_SVI_Pop_Aug2021_FPR03.gdb\Bldgs_SVI_Pop_Aug2021_FPR03,Bldg_ID,-1,-1" Closest # #
DeleteField C:\Users\CRoush\Documents\Bldg_Footprint_Modification\buildings_remove_duplicates.gdb\FPR03_Bldgs_diss_w_fields_added_v2 Join_Count;TARGET_FID
DeleteField C:\Users\CRoush\Documents\Bldg_Footprint_Modification\buildings_remove_duplicates.gdb\FPR03_Bldgs_diss_w_fields_added_v2 Join_Count;TARGET_FID;Prev_Bldg_IDs
JoinField C:\Users\CRoush\Documents\Bldg_Footprint_Modification\buildings_remove_duplicates.gdb\FPR03_Bldgs_diss_w_fields_added_v2 Bldg_ID C:\Users\CRoush\Documents\Bldg_Footprint_Modification\buildings_remove_duplicates.gdb\FPR03_bldg_pop_table Bldg_ID SUM_NIGHT_POP_BLDG_PART;SUM_DAY_POP_BLDG_PART
CalculateField C:\Users\CRoush\Documents\Bldg_Footprint_Modification\buildings_remove_duplicates.gdb\FPR03_Bldgs_diss_w_fields_added_v2 Est_Day_Pop !SUM_DAY_POP_BLDG_PART! "Python 3" # "Long (large integer)"
CalculateField C:\Users\CRoush\Documents\Bldg_Footprint_Modification\buildings_remove_duplicates.gdb\FPR03_Bldgs_diss_w_fields_added_v2 Est_Night_Pop !SUM_NIGHT_POP_BLDG_PART! "Python 3" # "Long (large integer)"
AlterField C:\Users\CRoush\Documents\Bldg_Footprint_Modification\buildings_remove_duplicates.gdb\FPR03_Bldgs_diss_w_fields_added_v2 SUM_DAY_POP_BLDG_PART EstDayPop_Float EstDayPop_Float "Double (double precision)" 8 NULLABLE DO_NOT_CLEAR
AlterField C:\Users\CRoush\Documents\Bldg_Footprint_Modification\buildings_remove_duplicates.gdb\FPR03_Bldgs_diss_w_fields_added_v2 SUM_NIGHT_POP_BLDG_PART EstNtPop_Float EstNtPop_Float "Double (double precision)" 8 NULLABLE DO_NOT_CLEAR
SpatialJoin C:\Users\CRoush\Documents\Bldg_Footprint_Modification\buildings_remove_duplicates.gdb\FPR03_Bldgs_diss_w_fields_added_v2 C:\Users\CRoush\Documents\GIS_Resources\Landscan\Landscan_poly_grid_2019.gdb\FPR03_LSgrid_v3 C:\Users\CRoush\Documents\Bldg_Footprint_Modification\bldgs_Pop_SVI_SimpType_Nov2021.gdb\FPR03_Bldgs_w_LS_boundary_Nov2021 "Join one to one" KEEP_COMMON "Bldg_ID "Bldg_ID" true true false 254 Text 0 0,First,#,C:\Users\CRoush\Documents\Bldg_Footprint_Modification\buildings_remove_duplicates.gdb\FPR03_Bldgs_diss_w_fields_added_v2,Bldg_ID,0,254;Simp_type "Simp_type" true true false 254 Text 0 0,First,#,C:\Users\CRoush\Documents\Bldg_Footprint_Modification\buildings_remove_duplicates.gdb\FPR03_Bldgs_diss_w_fields_added_v2,Simp_type,0,254;SVI "SVI" true true false 254 Text 0 0,First,#,C:\Users\CRoush\Documents\Bldg_Footprint_Modification\buildings_remove_duplicates.gdb\FPR03_Bldgs_diss_w_fields_added_v2,SVI,0,254;Est_floors "Est_floors" true true false 254 Text 0 0,First,#,C:\Users\CRoush\Documents\Bldg_Footprint_Modification\buildings_remove_duplicates.gdb\FPR03_Bldgs_diss_w_fields_added_v2,Est_floors,0,254;EstNtPop_Float "EstNtPop_Float" true true false 8 Double 0 0,First,#,C:\Users\CRoush\Documents\Bldg_Footprint_Modification\buildings_remove_duplicates.gdb\FPR03_Bldgs_diss_w_fields_added_v2,EstNtPop_Float,-1,-1;EstDayPop_Float "EstDayPop_Float" true true false 8 Double 0 0,First,#,C:\Users\CRoush\Documents\Bldg_Footprint_Modification\buildings_remove_duplicates.gdb\FPR03_Bldgs_diss_w_fields_added_v2,EstDayPop_Float,-1,-1;Est_Day_Pop "Est_Day_Pop" true true false 4 Long 0 0,First,#,C:\Users\CRoush\Documents\Bldg_Footprint_Modification\buildings_remove_duplicates.gdb\FPR03_Bldgs_diss_w_fields_added_v2,Est_Day_Pop,-1,-1;Est_Night_Pop "Est_Night_Pop" true true false 4 Long 0 0,First,#,C:\Users\CRoush\Documents\Bldg_Footprint_Modification\buildings_remove_duplicates.gdb\FPR03_Bldgs_diss_w_fields_added_v2,Est_Night_Pop,-1,-1" Intersect # #
Copy C:\Users\CRoush\Documents\Bldg_Footprint_Modification\bldgs_Pop_SVI_SimpType_Nov2021.gdb\FPR03_Bldgs_w_LS_boundary_Nov2021 C:\Users\CRoush\Documents\GIS_Resources\Buildings\Bldgs_SVI_Pop_Nov2021.gdb\FPR03_Bldgs_Pop_SVI_SimpType_Nov2021 FeatureClass #
DeleteField C:\Users\CRoush\Documents\GIS_Resources\Buildings\Bldgs_SVI_Pop_Nov2021.gdb\FPR03_Bldgs_Pop_SVI_SimpType_Nov2021 Join_Count;TARGET_FID
Copy C:\Users\CRoush\Documents\GIS_Resources\Buildings\Bldgs_SVI_Pop_Nov2021.gdb\FPR03_Bldgs_Pop_SVI_SimpType_Nov2021 C:\Users\CRoush\Documents\GIS_Resources\Buildings\FPR03Bldgs_SVI_Pop_Nov2021.gdb\FPR03_Bldgs_Pop_SVI_SimpType_Nov2021 FeatureClass #
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/2.9.0'><WorkspaceConnectionString>DATABASE=W:\Citrix\43000s\43791\GIS\Ch2\Buildings\FPR03Bldgs_SVI_Pop_Nov2021.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>FPR03_Bldgs_Pop_SVI_SimpType_March2022_Update</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Levee_Area</field_name><field_type>TEXT</field_type><field_length>5</field_length><field_alias>Levee_Area</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Dam_Inundation_Area</field_name><field_type>TEXT</field_type><field_length>5</field_length><field_alias>Dam_Inundation_Area</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></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/2.9.0'><WorkspaceConnectionString>DATABASE=W:\Citrix\43000s\43791\GIS\Ch2\Buildings\FPR03Bldgs_SVI_Pop_Nov2021.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>FPR03_Bldgs_Pop_SVI_SimpType_March2022_Update</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>EST_EV</field_name><field_type>DOUBLE</field_type><field_alias>EST_EV</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
DeleteField FPR03_Bldgs_Pop_SVI_SimpType_March2022_Update EST_EV "Delete Fields"
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/2.9.0'><WorkspaceConnectionString>DATABASE=W:\Citrix\43000s\43791\GIS\Ch2\Buildings\FPR03Bldgs_SVI_Pop_Nov2021.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>FPR03_Bldgs_Pop_SVI_SimpType_March2022_Update</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>POP_AFFECT</field_name><field_type>LONG</field_type><field_alias>POP_AFFECT</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
CalculateField FPR03_Bldgs_Pop_SVI_SimpType_March2022_Update POP_AFFECT !EstNtPop_Float! "Python 3" # Text NO_ENFORCE_DOMAINS
CalculateField FPR03_Bldgs_Pop_SVI_SimpType_March2022_Update POP_AFFECT !EstDayPop_Float! "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/2.9.0'><WorkspaceConnectionString>DATABASE=W:\Citrix\43000s\43791\GIS\Ch2\Buildings\FPR03Bldgs_SVI_Pop_Nov2021.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>FPR03_Bldgs_Pop_SVI_SimpType_March2022_Update</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>EST_EV</field_name><field_type>DOUBLE</field_type><field_alias>EST_EV</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>
FeatureClassToFeatureClass W:\Citrix\43000s\43791\GIS\Ch2\Buildings\FPR03Bldgs_SVI_Pop_Nov2021.gdb\FPR03_Bldgs_Pop_SVI_SimpType_March2022_Update W:\Citrix\43000s\43791\GIS\Ch2\Trinity_Base_Data\Final_Files.gdb\Critical_Facilities_forSubmittal Trinity_Buildings_Final # "Bldg_ID "Bldg_ID" true true false 254 Text 0 0 ,First,#,W:\Citrix\43000s\43791\GIS\Ch2\Buildings\FPR03Bldgs_SVI_Pop_Nov2021.gdb\FPR03_Bldgs_Pop_SVI_SimpType_March2022_Update,Bldg_ID,-1,-1;Simp_type "Simp_type" true true false 254 Text 0 0 ,First,#,W:\Citrix\43000s\43791\GIS\Ch2\Buildings\FPR03Bldgs_SVI_Pop_Nov2021.gdb\FPR03_Bldgs_Pop_SVI_SimpType_March2022_Update,Simp_type,-1,-1;SVI "SVI" true true false 254 Text 0 0 ,First,#,W:\Citrix\43000s\43791\GIS\Ch2\Buildings\FPR03Bldgs_SVI_Pop_Nov2021.gdb\FPR03_Bldgs_Pop_SVI_SimpType_March2022_Update,SVI,-1,-1;Est_floors "Est_floors" true true false 254 Text 0 0 ,First,#,W:\Citrix\43000s\43791\GIS\Ch2\Buildings\FPR03Bldgs_SVI_Pop_Nov2021.gdb\FPR03_Bldgs_Pop_SVI_SimpType_March2022_Update,Est_floors,-1,-1;EstNtPop_Float "EstNtPop_Float" true true false 8 Double 0 0 ,First,#,W:\Citrix\43000s\43791\GIS\Ch2\Buildings\FPR03Bldgs_SVI_Pop_Nov2021.gdb\FPR03_Bldgs_Pop_SVI_SimpType_March2022_Update,EstNtPop_Float,-1,-1;EstDayPop_Float "EstDayPop_Float" true true false 8 Double 0 0 ,First,#,W:\Citrix\43000s\43791\GIS\Ch2\Buildings\FPR03Bldgs_SVI_Pop_Nov2021.gdb\FPR03_Bldgs_Pop_SVI_SimpType_March2022_Update,EstDayPop_Float,-1,-1;Est_Day_Pop "Est_Day_Pop" true true false 4 Long 0 0 ,First,#,W:\Citrix\43000s\43791\GIS\Ch2\Buildings\FPR03Bldgs_SVI_Pop_Nov2021.gdb\FPR03_Bldgs_Pop_SVI_SimpType_March2022_Update,Est_Day_Pop,-1,-1;Est_Night_Pop "Est_Night_Pop" true true false 4 Long 0 0 ,First,#,W:\Citrix\43000s\43791\GIS\Ch2\Buildings\FPR03Bldgs_SVI_Pop_Nov2021.gdb\FPR03_Bldgs_Pop_SVI_SimpType_March2022_Update,Est_Night_Pop,-1,-1;SOURCE "SOURCE" true true false 50 Text 0 0 ,First,#,W:\Citrix\43000s\43791\GIS\Ch2\Buildings\FPR03Bldgs_SVI_Pop_Nov2021.gdb\FPR03_Bldgs_Pop_SVI_SimpType_March2022_Update,SOURCE,-1,-1;Shape_Length "Shape_Length" false true true 8 Double 0 0 ,First,#,W:\Citrix\43000s\43791\GIS\Ch2\Buildings\FPR03Bldgs_SVI_Pop_Nov2021.gdb\FPR03_Bldgs_Pop_SVI_SimpType_March2022_Update,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0 ,First,#,W:\Citrix\43000s\43791\GIS\Ch2\Buildings\FPR03Bldgs_SVI_Pop_Nov2021.gdb\FPR03_Bldgs_Pop_SVI_SimpType_March2022_Update,Shape_Area,-1,-1" #
CopyFeatures W:\Citrix\52000s\52456\001\GIS\Data\To_Use\Base_Map\Building_Footprints_2021.shp W:\Citrix\52000s\52456\001\GIS\Data\To_Use\Hutchins_Data.gdb\BaseMap\Building_Footprints_2021 # # # #
Rename W:\Citrix\52000s\52456\001\GIS\Data\To_Use\Hutchins_Data.gdb\BaseMap\Building_Footprints_2021 W:\Citrix\52000s\52456\001\GIS\Data\To_Use\Hutchins_Data.gdb\BaseMap\Building_Footprints FeatureClass
CopyFeatures W:\Citrix\52000s\52456\001\GIS\Data\To_Use\Hutchins_Data.gdb\BaseMap\Building_Footprints "W:\Citrix\SDE_Connections\SQL19\SQL19_PROD\DBO Connections\Hutchins_AVO_52456_DBO.sde\Hutchins_AVO_52456.GISDBO.Base_Map\Hutchins_AVO_52456.GISDBO.Building_Footprints" # # # #
Hutchins_AVO_52456.GISDBO.Building_Footprints
002
Server=RCHDB03-ahv; Service=sde:sqlserver:RCHDB03-ahv\sde; Database=Hutchins_AVO_52456; User=GISDBO; Version=sde.DEFAULT
ArcSDE Connection
-10991177.679500
-10524622.994300
3459845.529500
3993381.752600
1
Projected
GCS_WGS_1984
Linear Unit: Meter (1.000000)
WGS_1984_Web_Mercator_Auxiliary_Sphere
<ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WKT>PROJCS["WGS_1984_Web_Mercator_Auxiliary_Sphere",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Mercator_Auxiliary_Sphere"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",0.0],PARAMETER["Auxiliary_Sphere_Type",0.0],UNIT["Meter",1.0],AUTHORITY["EPSG",3857]]</WKT><XOrigin>-20037700</XOrigin><YOrigin>-30241100</YOrigin><XYScale>10000</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102100</WKID><LatestWKID>3857</LatestWKID></ProjectedCoordinateSystem>
20230501
15391400
20230501
15391400
Microsoft Windows 10 Version 10.0 (Build 19044) ; Esri ArcGIS 12.9.4.32739
Hutchins Building Footprints
0.000000
0.000000
1
-98.735429
-94.544297
33.735803
29.659415
Hutchins
52456
Building
City of Hutchins Building Footprints
Enterprise Geodatabase Feature Class
dataset
EPSG
6.18.3(9.3.1.2)
0
Simple
FALSE
0
TRUE
TRUE
Hutchins_AVO_52456.GISDBO.Building_Footprints
Feature Class
0
OBJECTID_1
OBJECTID_1
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
OBJECTID
OBJECTID
Integer
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
Shape
Shape
Geometry
8
0
0
Feature geometry.
Esri
Coordinates defining the features.
Bldg_ID
Bldg_ID
String
254
0
0
Simp_type
Simp_type
String
254
0
0
SVI
SVI
String
254
0
0
Est_floors
Est_floors
String
254
0
0
EstNtPop_F
EstNtPop_F
Double
8
38
8
EstDayPop_
EstDayPop_
Double
8
38
8
Est_Day_Po
Est_Day_Po
Integer
4
10
0
Est_Night_
Est_Night_
Integer
4
10
0
Shape_Leng
Shape_Leng
Double
8
38
8
SOURCE
SOURCE
String
50
0
0
Shape.STArea()
Shape.STArea()
Double
0
0
0
Shape.STLength()
Shape.STLength()
Double
0
0
0
20230501
iVBORw0KGgoAAAANSUhEUgAAASwAAADICAYAAABS39xVAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAO
xAAADsQBlSsOGwAAAqpJREFUeJzt1DENADAMwLAd5U+5o7BvimQjyJXZ3T0AAfM7AOCVYQEZhgVk
GBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFY
QIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZ
hgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgW
kGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECG
YQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYF
ZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBh
WECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEB
GYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQY
FpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhA
hmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmG
BWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQ
YVhAhmEBGYYFnIoLreIHHblfYqUAAAAASUVORK5CYII=