20240524 14494100 1.0 FALSE FC_NewRegisteredTitledLots_v01 002 file://\\CFE04\data$\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb Local Area Network Projected GCS_North_American_1983 Linear Unit: Meter (1.000000) NAD_1983_3TM_114 <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.3.0'><WKT>PROJCS[&quot;NAD_1983_3TM_114&quot;,GEOGCS[&quot;GCS_North_American_1983&quot;,DATUM[&quot;D_North_American_1983&quot;,SPHEROID[&quot;GRS_1980&quot;,6378137.0,298.257222101]],PRIMEM[&quot;Greenwich&quot;,0.0],UNIT[&quot;Degree&quot;,0.0174532925199433]],PROJECTION[&quot;Transverse_Mercator&quot;],PARAMETER[&quot;False_Easting&quot;,0.0],PARAMETER[&quot;False_Northing&quot;,0.0],PARAMETER[&quot;Central_Meridian&quot;,-114.0],PARAMETER[&quot;Scale_Factor&quot;,0.9999],PARAMETER[&quot;Latitude_Of_Origin&quot;,0.0],UNIT[&quot;Meter&quot;,1.0],AUTHORITY[&quot;EPSG&quot;,3776]]</WKT><XOrigin>-5622600</XOrigin><YOrigin>-10001100</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>102187</WKID><LatestWKID>3776</LatestWKID></ProjectedCoordinateSystem> CopyFeatures P:\Planning\GIS_Data\GIS_2021-22\CoE_Data\Quarterly\Sep_2021\TitleLots.shp\TitledLots.shp P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210901 # # # # ExportFeatures FC_TitledLots_20210901 P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_NewRegisteredTitledLots_v01 # NOT_USE_ALIAS "PGM_ID "PGM_ID" true true false 8 Double 0 0,First,#,FC_TitledLots_20210901,PGM_ID,-1,-1;LUC "LUC" true true false 254 Text 0 0,First,#,FC_TitledLots_20210901,LUC,0,253;LUC_COLOR "LUC_COLOR" true true false 8 Double 0 0,First,#,FC_TitledLots_20210901,LUC_COLOR,-1,-1;ADD_ID "ADD_ID" true true false 8 Double 0 0,First,#,FC_TitledLots_20210901,ADD_ID,-1,-1;SUITE_NO "SUITE_NO" true true false 8 Text 0 0,First,#,FC_TitledLots_20210901,SUITE_NO,0,7;UNIT_NO "UNIT_NO" true true false 8 Text 0 0,First,#,FC_TitledLots_20210901,UNIT_NO,0,7;HOUSE_NO "HOUSE_NO" true true false 8 Double 0 0,First,#,FC_TitledLots_20210901,HOUSE_NO,-1,-1;HOUSE_SUFF "HOUSE_SUFF" true true false 2 Text 0 0,First,#,FC_TitledLots_20210901,HOUSE_SUFF,0,1;STREET_NAM "STREET_NAM" true true false 40 Text 0 0,First,#,FC_TitledLots_20210901,STREET_NAM,0,39;QUADRANT "QUADRANT" true true false 2 Text 0 0,First,#,FC_TitledLots_20210901,QUADRANT,0,1;POSTAL_COD "POSTAL_COD" true true false 6 Text 0 0,First,#,FC_TitledLots_20210901,POSTAL_COD,0,5;ADD_STATUS "ADD_STATUS" true true false 15 Text 0 0,First,#,FC_TitledLots_20210901,ADD_STATUS,0,14;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,FC_TitledLots_20210901,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,FC_TitledLots_20210901,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.3.0'><WorkspaceConnectionString>DATABASE=P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>FC_NewRegisteredTitledLots_v01</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>date_from</field_name><field_type>DATE</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>date_to</field_name><field_type>DATE</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField FC_NewRegisteredTitledLots_v01 date_from "6/1/2021" Python # Text NO_ENFORCE_DOMAINS CalculateField FC_NewRegisteredTitledLots_v01 date_to "9/1/2021" Python # Text NO_ENFORCE_DOMAINS AddSpatialJoin FC_NewRegisteredTitledLots_v01 FC_CoE_ResidentialZoningHistory_2019to2024_v01 JOIN_ONE_TO_ONE KEEP_ALL "zoning "zoning" true true false 254 Text 0 0,First,#,FC_CoE_ResidentialZoningHistory_2019to2024_v01,zoning,0,253;zoning_des "zoning_des" true true false 254 Text 0 0,First,#,FC_CoE_ResidentialZoningHistory_2019to2024_v01,zoning_des,0,253;Res_Density "Res_Density" true true false 2 Short 0 0,First,#,FC_CoE_ResidentialZoningHistory_2019to2024_v01,Res_Density,-1,-1" "Have their center in" # # PERMANENT_FIELDS # AddSpatialJoin FC_NewRegisteredTitledLots_v01 "CoE Neighbourhoods (Current)" JOIN_ONE_TO_ONE KEEP_ALL "coe_nbhd_name "CoE Nbhd Name" true true false 120 Text 0 0,First,#,CoE Neighbourhoods (Current),coe_nbhd_name,0,119;coe_nbhd_name_alt "CoE Nbhd Name Alt" true true false 254 Text 0 0,First,#,CoE Neighbourhoods (Current),coe_nbhd_name_alt,0,253;coe_nbhd_number_t "CoE Nbhd Number T" true true false 20 Text 0 0,First,#,CoE Neighbourhoods (Current),coe_nbhd_number_t,0,19;coe_nbhd_number_n "CoE Nbhd Number N" true true false 4 Long 0 0,First,#,CoE Neighbourhoods (Current),coe_nbhd_number_n,-1,-1;coe_plngdistrict_name "CoE Planning District" true true false 254 Text 0 0,First,#,CoE Neighbourhoods (Current),coe_plngdistrict_name,0,253;coe_plngdistrict_num "coe_plngdistrict_num" true true false 4 Long 0 0,First,#,CoE Neighbourhoods (Current),coe_plngdistrict_num,-1,-1;coe_ward2021_name "CoE Ward 2021" true true false 254 Text 0 0,First,#,CoE Neighbourhoods (Current),coe_ward2021_name,0,253" "Have their center in" # # PERMANENT_FIELDS # AddSpatialJoin FC_NewRegisteredTitledLots_v01 "EPSB Neighbourhoods (2023)" JOIN_ONE_TO_ONE KEEP_ALL "epsb_nbhd_name "EPSB Nbhd Name" true true false 50 Text 0 0,First,#,EPSB Neighbourhoods (2023),epsb_nbhd_name,0,49;epsb_nbhd_number_n "EPSB Nbhd Number N" true true false 4 Long 0 0,First,#,EPSB Neighbourhoods (2023),epsb_nbhd_number_n,-1,-1;el_aa_school_name "EL AA School Name" true true false 50 Text 0 0,First,#,EPSB Neighbourhoods (2023),el_aa_school_name,0,49;jh_aa_school_name "JH AA School Name" true true false 50 Text 0 0,First,#,EPSB Neighbourhoods (2023),jh_aa_school_name,0,49;sh_aa_school_name "SH AA School Name" true true false 50 Text 0 0,First,#,EPSB Neighbourhoods (2023),sh_aa_school_name,0,49;epsb_plngsector2020_name "EPSB Planning Sector" true true false 50 Text 0 0,First,#,EPSB Neighbourhoods (2023),epsb_plngsector2020_name,0,49;epsb_plngsector2020_code "EPSB Planning Sector Code" true true false 5 Text 0 0,First,#,EPSB Neighbourhoods (2023),epsb_plngsector2020_code,0,4;epsb_plngarea_name "EPSB Planning Area" true true false 50 Text 0 0,First,#,EPSB Neighbourhoods (2023),epsb_plngarea_name,0,49" "Have their center in" # # PERMANENT_FIELDS # DeleteField FC_NewRegisteredTitledLots_v01 Join_Count_1;coe_nbhd_name;coe_nbhd_name_alt;coe_nbhd_number_t;coe_nbhd_number_n;coe_plngdistrict_name;coe_plngdistrict_num;coe_ward2021_name;Join_Count_12;epsb_nbhd_name;epsb_nbhd_number_n;el_aa_school_name;jh_aa_school_name;sh_aa_school_name;epsb_plngsector2020_name;epsb_plngsector2020_code;epsb_plngarea_name "Delete Fields" Append FC_TitledLots_20210601 FC_NewRegisteredTitledLots_v01 "Use the field map to reconcile field differences" "PGM_ID "PGM_ID" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210601,PGM_ID,-1,-1;LUC "LUC" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210601,LUC,0,253;LUC_COLOR "LUC_COLOR" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210601,LUC_COLOR,-1,-1;ADD_ID "ADD_ID" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210601,ADD_ID,-1,-1;SUITE_NO "SUITE_NO" true true false 8 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210601,SUITE_NO,0,7;UNIT_NO "UNIT_NO" true true false 8 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210601,UNIT_NO,0,7;HOUSE_NO "HOUSE_NO" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210601,HOUSE_NO,-1,-1;HOUSE_SUFF "HOUSE_SUFF" true true false 2 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210601,HOUSE_SUFF,0,1;STREET_NAM "STREET_NAM" true true false 40 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210601,STREET_NAM,0,39;QUADRANT "QUADRANT" true true false 2 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210601,QUADRANT,0,1;POSTAL_COD "POSTAL_COD" true true false 6 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210601,POSTAL_COD,0,5;ADD_STATUS "ADD_STATUS" true true false 15 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210601,ADD_STATUS,0,14;date_from "date_from" true true false 8 Date 0 0,First,#;date_to "date_to" true true false 8 Date 0 0,First,#;Join_Count "Join_Count" true true false 4 Long 0 0,First,#;zoning "zoning" true true false 254 Text 0 0,First,#;zoning_des "zoning_des" true true false 254 Text 0 0,First,#;Res_Density "Res_Density" true true false 2 Short 0 0,First,#" # # # NOT_UPDATE_GEOMETRY CalculateField FC_NewRegisteredTitledLots_v01 date_from "4/1/2021" Python # Text NO_ENFORCE_DOMAINS CalculateField FC_NewRegisteredTitledLots_v01 date_to "6/1/2021" Python # Text NO_ENFORCE_DOMAINS AddSpatialJoin FC_NewRegisteredTitledLots_v01 FC_CoE_ResidentialZoningHistory_2019to2024_v01 JOIN_ONE_TO_ONE KEEP_ALL "zoning "zoning" true true false 254 Text 0 0,First,#,FC_CoE_ResidentialZoningHistory_2019to2024_v01,zoning,0,253;zoning_des "zoning_des" true true false 254 Text 0 0,First,#,FC_CoE_ResidentialZoningHistory_2019to2024_v01,zoning_des,0,253;Res_Density "Res_Density" true true false 2 Short 0 0,First,#,FC_CoE_ResidentialZoningHistory_2019to2024_v01,Res_Density,-1,-1" "Have their center in" # # PERMANENT_FIELDS # CalculateField FC_NewRegisteredTitledLots_v01 Join_Count !Join_Count_1! Python # Text NO_ENFORCE_DOMAINS CalculateField FC_NewRegisteredTitledLots_v01 zoning !zoning_1! Python # Text NO_ENFORCE_DOMAINS CalculateField FC_NewRegisteredTitledLots_v01 zoning_des !zoning_des_1! Python # Text NO_ENFORCE_DOMAINS CalculateField FC_NewRegisteredTitledLots_v01 Res_Density !Res_Density_1! Python # Text NO_ENFORCE_DOMAINS DeleteField FC_NewRegisteredTitledLots_v01 Join_Count_1;zoning_1;zoning_des_1;Res_Density_1 "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/3.3.0'><WorkspaceConnectionString>DATABASE=P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>FC_NewRegisteredTitledLots_v01</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>date_as_of</field_name><field_type>DATE</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> Append FC_TitledLots_20210601 FC_NewRegisteredTitledLots_v01 "Use the field map to reconcile field differences" "PGM_ID "PGM_ID" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210601,PGM_ID,-1,-1;LUC "LUC" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210601,LUC,0,253;LUC_COLOR "LUC_COLOR" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210601,LUC_COLOR,-1,-1;ADD_ID "ADD_ID" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210601,ADD_ID,-1,-1;SUITE_NO "SUITE_NO" true true false 8 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210601,SUITE_NO,0,7;UNIT_NO "UNIT_NO" true true false 8 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210601,UNIT_NO,0,7;HOUSE_NO "HOUSE_NO" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210601,HOUSE_NO,-1,-1;HOUSE_SUFF "HOUSE_SUFF" true true false 2 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210601,HOUSE_SUFF,0,1;STREET_NAM "STREET_NAM" true true false 40 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210601,STREET_NAM,0,39;QUADRANT "QUADRANT" true true false 2 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210601,QUADRANT,0,1;POSTAL_COD "POSTAL_COD" true true false 6 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210601,POSTAL_COD,0,5;ADD_STATUS "ADD_STATUS" true true false 15 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210601,ADD_STATUS,0,14;date_from "date_from" true true false 8 Date 0 0,First,#;date_to "date_to" true true false 8 Date 0 0,First,#;Join_Count "Join_Count" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210601,Join_Count,-1,-1;zoning "zoning" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210601,zoning,0,253;zoning_des "zoning_des" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210601,zoning_des,0,253;Res_Density "Res_Density" true true false 2 Short 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210601,Res_Density,-1,-1;date_as_of "date_as_of" true true false 8 Date 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210601,date_as_of,-1,-1" # # # NOT_UPDATE_GEOMETRY CalculateField FC_NewRegisteredTitledLots_v01 date_as_of '2021-09-06 00:00:00' Python # Text NO_ENFORCE_DOMAINS CalculateField FC_NewRegisteredTitledLots_v01 date_from '2021-04-01 00:00:00' Python # Text NO_ENFORCE_DOMAINS CalculateField FC_NewRegisteredTitledLots_v01 date_to '2021-06-01 00:00:00' Python # Text NO_ENFORCE_DOMAINS Append FC_TitledLots_20210401 FC_NewRegisteredTitledLots_v01 "Use the field map to reconcile field differences" "PGM_ID "PGM_ID" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210401,PGM_ID,-1,-1;LUC "LUC" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210401,LUC,0,253;LUC_COLOR "LUC_COLOR" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210401,LUC_COLOR,-1,-1;ADD_ID "ADD_ID" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210401,ADD_ID,-1,-1;SUITE_NO "SUITE_NO" true true false 8 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210401,SUITE_NO,0,7;UNIT_NO "UNIT_NO" true true false 8 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210401,UNIT_NO,0,7;HOUSE_NO "HOUSE_NO" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210401,HOUSE_NO,-1,-1;HOUSE_SUFF "HOUSE_SUFF" true true false 2 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210401,HOUSE_SUFF,0,1;STREET_NAM "STREET_NAM" true true false 40 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210401,STREET_NAM,0,39;QUADRANT "QUADRANT" true true false 2 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210401,QUADRANT,0,1;POSTAL_COD "POSTAL_COD" true true false 6 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210401,POSTAL_COD,0,5;ADD_STATUS "ADD_STATUS" true true false 15 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210401,ADD_STATUS,0,14;date_from "date_from" true true false 8 Date 0 0,First,#;date_to "date_to" true true false 8 Date 0 0,First,#;Join_Count "Join_Count" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210401,Join_Count,-1,-1;zoning "zoning" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210401,zoning,0,253;zoning_des "zoning_des" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210401,zoning_des,0,253;Res_Density "Res_Density" true true false 2 Short 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210401,Res_Density,-1,-1;date_as_of "date_as_of" true true false 8 Date 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20210401,date_as_of,-1,-1" # # # NOT_UPDATE_GEOMETRY CalculateField FC_NewRegisteredTitledLots_v01 date_to '2021-04-01 00:00:00' Python # Text NO_ENFORCE_DOMAINS CalculateField FC_NewRegisteredTitledLots_v01 date_from '2020-12-01 00:00:00' Python # Text NO_ENFORCE_DOMAINS CalculateField FC_NewRegisteredTitledLots_v01 date_to '2021-09-01 00:00:00' Python # Text NO_ENFORCE_DOMAINS CalculateField FC_NewRegisteredTitledLots_v01 date_from '2021-06-01 00:00:00' Python # Text NO_ENFORCE_DOMAINS CalculateField FC_NewRegisteredTitledLots_v01 date_from '2021-04-01 00:00:00' Python # Text NO_ENFORCE_DOMAINS CalculateField FC_NewRegisteredTitledLots_v01 date_to '2021-06-01 00:00:00' Python # 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.3.0'><WorkspaceConnectionString>DATABASE=P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>FC_NewRegisteredTitledLots_v01</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>year_and_quarter</field_name><field_type>DOUBLE</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField FC_NewRegisteredTitledLots_v01 year_and_quarter int(datetime.datetime.strftime(!date_to!, "%Y")) Python "import datetime" Text NO_ENFORCE_DOMAINS CalculateField FC_NewRegisteredTitledLots_v01 year_and_quarter "int(datetime.datetime.strftime(!date_to!, "%Y")) + (math.ceil(int(datetime.datetime.strftime(!date_to!, "%m"))/3))/10" Python "import datetime" Text NO_ENFORCE_DOMAINS AddSpatialJoin FC_NewRegisteredTitledLots_v01 "CoE Neighbourhoods (Current)" JOIN_ONE_TO_ONE KEEP_ALL "coe_nbhd_name "CoE Nbhd Name" true true false 120 Text 0 0,First,#,CoE Neighbourhoods (Current),coe_nbhd_name,0,119;coe_nbhd_number_t "CoE Nbhd Number T" true true false 20 Text 0 0,First,#,CoE Neighbourhoods (Current),coe_nbhd_number_t,0,19;coe_nbhd_number_n "CoE Nbhd Number N" true true false 4 Long 0 0,First,#,CoE Neighbourhoods (Current),coe_nbhd_number_n,-1,-1;coe_plngdistrict_name "CoE Planning District" true true false 254 Text 0 0,First,#,CoE Neighbourhoods (Current),coe_plngdistrict_name,0,253;coe_plngdistrict_num "coe_plngdistrict_num" true true false 4 Long 0 0,First,#,CoE Neighbourhoods (Current),coe_plngdistrict_num,-1,-1;coe_ward2021_name "CoE Ward 2021" true true false 254 Text 0 0,First,#,CoE Neighbourhoods (Current),coe_ward2021_name,0,253" "Have their center in" # # PERMANENT_FIELDS # AddSpatialJoin FC_NewRegisteredTitledLots_v01 "EPSB Neighbourhoods (2023)" JOIN_ONE_TO_ONE KEEP_ALL "epsb_nbhd_name "EPSB Nbhd Name" true true false 50 Text 0 0,First,#,EPSB Neighbourhoods (2023),epsb_nbhd_name,0,49;el_aa_school_name "EL AA School Name" true true false 50 Text 0 0,First,#,EPSB Neighbourhoods (2023),el_aa_school_name,0,49;jh_aa_school_name "JH AA School Name" true true false 50 Text 0 0,First,#,EPSB Neighbourhoods (2023),jh_aa_school_name,0,49;sh_aa_school_name "SH AA School Name" true true false 50 Text 0 0,First,#,EPSB Neighbourhoods (2023),sh_aa_school_name,0,49;epsb_plngsector2020_name "EPSB Planning Sector" true true false 50 Text 0 0,First,#,EPSB Neighbourhoods (2023),epsb_plngsector2020_name,0,49;epsb_plngarea_name "EPSB Planning Area" true true false 50 Text 0 0,First,#,EPSB Neighbourhoods (2023),epsb_plngarea_name,0,49;epsb_ward2021_name "EPSB Ward 2021" true true false 5 Text 0 0,First,#,EPSB Neighbourhoods (2023),epsb_ward2021_name,0,4" "Have their center in" # # PERMANENT_FIELDS # Append FC_TitledLots_20201201 FC_NewRegisteredTitledLots_v01 "Use the field map to reconcile field differences" "PGM_ID "PGM_ID" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20201201,PGM_ID,-1,-1;LUC "LUC" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20201201,LUC,0,253;LUC_COLOR "LUC_COLOR" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20201201,LUC_COLOR,-1,-1;ADD_ID "ADD_ID" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20201201,ADD_ID,-1,-1;SUITE_NO "SUITE_NO" true true false 8 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20201201,SUITE_NO,0,7;UNIT_NO "UNIT_NO" true true false 8 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20201201,UNIT_NO,0,7;HOUSE_NO "HOUSE_NO" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20201201,HOUSE_NO,-1,-1;HOUSE_SUFF "HOUSE_SUFF" true true false 2 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20201201,HOUSE_SUFF,0,1;STREET_NAM "STREET_NAM" true true false 40 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20201201,STREET_NAM,0,39;QUADRANT "QUADRANT" true true false 2 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20201201,QUADRANT,0,1;POSTAL_COD "POSTAL_COD" true true false 6 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20201201,POSTAL_COD,0,5;ADD_STATUS "ADD_STATUS" true true false 15 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20201201,ADD_STATUS,0,14;date_from "date_from" true true false 8 Date 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20201201,date_from,-1,-1;date_to "date_to" true true false 8 Date 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20201201,date_to,-1,-1;Join_Count "Join_Count" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20201201,Join_Count,-1,-1;zoning "zoning" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20201201,zoning,0,253;zoning_des "zoning_des" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20201201,zoning_des,0,253;Res_Density "Res_Density" true true false 2 Short 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20201201,Res_Density,-1,-1;date_as_of "date_as_of" true true false 8 Date 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20201201,date_as_of,-1,-1;year_and_quarter "year_and_quarter" true true false 8 Double 0 0,First,#;Join_Count_1 "Join_Count_1" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20201201,Join_Count_1,-1,-1;coe_nbhd_name "CoE Nbhd Name" true true false 120 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20201201,coe_nbhd_name,0,119;coe_nbhd_number_t "CoE Nbhd Number T" true true false 20 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20201201,coe_nbhd_number_t,0,19;coe_nbhd_number_n "CoE Nbhd Number N" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20201201,coe_nbhd_number_n,-1,-1;coe_plngdistrict_name "CoE Planning District" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20201201,coe_plngdistrict_name,0,253;coe_plngdistrict_num "coe_plngdistrict_num" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20201201,coe_plngdistrict_num,-1,-1;coe_ward2021_name "CoE Ward 2021" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20201201,coe_ward2021_name,0,253;Join_Count_12 "Join_Count_12" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20201201,Join_Count_12,-1,-1;epsb_nbhd_name "EPSB Nbhd Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20201201,epsb_nbhd_name,0,49;el_aa_school_name "EL AA School Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20201201,el_aa_school_name,0,49;jh_aa_school_name "JH AA School Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20201201,jh_aa_school_name,0,49;sh_aa_school_name "SH AA School Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20201201,sh_aa_school_name,0,49;epsb_plngsector2020_name "EPSB Planning Sector" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20201201,epsb_plngsector2020_name,0,49;epsb_plngarea_name "EPSB Planning Area" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20201201,epsb_plngarea_name,0,49;epsb_ward2021_name "EPSB Ward 2021" true true false 5 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20201201,epsb_ward2021_name,0,4" # # # NOT_UPDATE_GEOMETRY Append FC_TitledLots_20200601 FC_NewRegisteredTitledLots_v01 "Use the field map to reconcile field differences" "PGM_ID "PGM_ID" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200601,PGM_ID,-1,-1;LUC "LUC" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200601,LUC,0,253;LUC_COLOR "LUC_COLOR" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200601,LUC_COLOR,-1,-1;ADD_ID "ADD_ID" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200601,ADD_ID,-1,-1;SUITE_NO "SUITE_NO" true true false 8 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200601,SUITE_NO,0,7;UNIT_NO "UNIT_NO" true true false 8 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200601,UNIT_NO,0,7;HOUSE_NO "HOUSE_NO" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200601,HOUSE_NO,-1,-1;HOUSE_SUFF "HOUSE_SUFF" true true false 2 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200601,HOUSE_SUFF,0,1;STREET_NAM "STREET_NAM" true true false 40 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200601,STREET_NAM,0,39;QUADRANT "QUADRANT" true true false 2 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200601,QUADRANT,0,1;POSTAL_COD "POSTAL_COD" true true false 6 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200601,POSTAL_COD,0,5;ADD_STATUS "ADD_STATUS" true true false 15 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200601,ADD_STATUS,0,14;date_from "date_from" true true false 8 Date 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200601,date_from,-1,-1;date_to "date_to" true true false 8 Date 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200601,date_to,-1,-1;Join_Count "Join_Count" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200601,Join_Count,-1,-1;zoning "zoning" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200601,zoning,0,253;zoning_des "zoning_des" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200601,zoning_des,0,253;Res_Density "Res_Density" true true false 2 Short 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200601,Res_Density,-1,-1;date_as_of "date_as_of" true true false 8 Date 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200601,date_as_of,-1,-1;year_and_quarter "year_and_quarter" true true false 8 Double 0 0,First,#;Join_Count_1 "Join_Count_1" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200601,Join_Count_1,-1,-1;coe_nbhd_name "CoE Nbhd Name" true true false 120 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200601,coe_nbhd_name,0,119;coe_nbhd_number_t "CoE Nbhd Number T" true true false 20 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200601,coe_nbhd_number_t,0,19;coe_nbhd_number_n "CoE Nbhd Number N" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200601,coe_nbhd_number_n,-1,-1;coe_plngdistrict_name "CoE Planning District" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200601,coe_plngdistrict_name,0,253;coe_plngdistrict_num "coe_plngdistrict_num" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200601,coe_plngdistrict_num,-1,-1;coe_ward2021_name "CoE Ward 2021" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200601,coe_ward2021_name,0,253;Join_Count_12 "Join_Count_12" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200601,Join_Count_12,-1,-1;epsb_nbhd_name "EPSB Nbhd Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200601,epsb_nbhd_name,0,49;el_aa_school_name "EL AA School Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200601,el_aa_school_name,0,49;jh_aa_school_name "JH AA School Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200601,jh_aa_school_name,0,49;sh_aa_school_name "SH AA School Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200601,sh_aa_school_name,0,49;epsb_plngsector2020_name "EPSB Planning Sector" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200601,epsb_plngsector2020_name,0,49;epsb_plngarea_name "EPSB Planning Area" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200601,epsb_plngarea_name,0,49;epsb_ward2021_name "EPSB Ward 2021" true true false 5 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200601,epsb_ward2021_name,0,4" # # # NOT_UPDATE_GEOMETRY Append FC_TitledLots_20200301 FC_NewRegisteredTitledLots_v01 "Use the field map to reconcile field differences" "PGM_ID "PGM_ID" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200301,PGM_ID,-1,-1;LUC "LUC" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200301,LUC,0,253;LUC_COLOR "LUC_COLOR" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200301,LUC_COLOR,-1,-1;ADD_ID "ADD_ID" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200301,ADD_ID,-1,-1;SUITE_NO "SUITE_NO" true true false 8 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200301,SUITE_NO,0,7;UNIT_NO "UNIT_NO" true true false 8 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200301,UNIT_NO,0,7;HOUSE_NO "HOUSE_NO" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200301,HOUSE_NO,-1,-1;HOUSE_SUFF "HOUSE_SUFF" true true false 2 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200301,HOUSE_SUFF,0,1;STREET_NAM "STREET_NAM" true true false 40 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200301,STREET_NAM,0,39;QUADRANT "QUADRANT" true true false 2 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200301,QUADRANT,0,1;POSTAL_COD "POSTAL_COD" true true false 6 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200301,POSTAL_COD,0,5;ADD_STATUS "ADD_STATUS" true true false 15 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200301,ADD_STATUS,0,14;date_from "date_from" true true false 8 Date 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200301,date_from,-1,-1;date_to "date_to" true true false 8 Date 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200301,date_to,-1,-1;Join_Count "Join_Count" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200301,Join_Count,-1,-1;zoning "zoning" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200301,zoning,0,253;zoning_des "zoning_des" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200301,zoning_des,0,253;Res_Density "Res_Density" true true false 2 Short 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200301,Res_Density,-1,-1;date_as_of "date_as_of" true true false 8 Date 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200301,date_as_of,-1,-1;year_and_quarter "year_and_quarter" true true false 8 Double 0 0,First,#;Join_Count_1 "Join_Count_1" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200301,Join_Count_1,-1,-1;coe_nbhd_name "CoE Nbhd Name" true true false 120 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200301,coe_nbhd_name,0,119;coe_nbhd_number_t "CoE Nbhd Number T" true true false 20 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200301,coe_nbhd_number_t,0,19;coe_nbhd_number_n "CoE Nbhd Number N" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200301,coe_nbhd_number_n,-1,-1;coe_plngdistrict_name "CoE Planning District" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200301,coe_plngdistrict_name,0,253;coe_plngdistrict_num "coe_plngdistrict_num" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200301,coe_plngdistrict_num,-1,-1;coe_ward2021_name "CoE Ward 2021" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200301,coe_ward2021_name,0,253;Join_Count_12 "Join_Count_12" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200301,Join_Count_12,-1,-1;epsb_nbhd_name "EPSB Nbhd Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200301,epsb_nbhd_name,0,49;el_aa_school_name "EL AA School Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200301,el_aa_school_name,0,49;jh_aa_school_name "JH AA School Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200301,jh_aa_school_name,0,49;sh_aa_school_name "SH AA School Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200301,sh_aa_school_name,0,49;epsb_plngsector2020_name "EPSB Planning Sector" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200301,epsb_plngsector2020_name,0,49;epsb_plngarea_name "EPSB Planning Area" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200301,epsb_plngarea_name,0,49;epsb_ward2021_name "EPSB Ward 2021" true true false 5 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20200301,epsb_ward2021_name,0,4" # # # NOT_UPDATE_GEOMETRY Append FC_TitledLots_20191201 FC_NewRegisteredTitledLots_v01 "Use the field map to reconcile field differences" "PGM_ID "PGM_ID" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20191201,PGM_ID,-1,-1;LUC "LUC" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20191201,LUC,0,253;LUC_COLOR "LUC_COLOR" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20191201,LUC_COLOR,-1,-1;ADD_ID "ADD_ID" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20191201,ADD_ID,-1,-1;SUITE_NO "SUITE_NO" true true false 8 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20191201,SUITE_NO,0,7;UNIT_NO "UNIT_NO" true true false 8 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20191201,UNIT_NO,0,7;HOUSE_NO "HOUSE_NO" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20191201,HOUSE_NO,-1,-1;HOUSE_SUFF "HOUSE_SUFF" true true false 2 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20191201,HOUSE_SUFF,0,1;STREET_NAM "STREET_NAM" true true false 40 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20191201,STREET_NAM,0,39;QUADRANT "QUADRANT" true true false 2 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20191201,QUADRANT,0,1;POSTAL_COD "POSTAL_COD" true true false 6 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20191201,POSTAL_COD,0,5;ADD_STATUS "ADD_STATUS" true true false 15 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20191201,ADD_STATUS,0,14;date_from "date_from" true true false 8 Date 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20191201,date_from,-1,-1;date_to "date_to" true true false 8 Date 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20191201,date_to,-1,-1;Join_Count "Join_Count" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20191201,Join_Count,-1,-1;zoning "zoning" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20191201,zoning,0,253;zoning_des "zoning_des" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20191201,zoning_des,0,253;Res_Density "Res_Density" true true false 2 Short 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20191201,Res_Density,-1,-1;date_as_of "date_as_of" true true false 8 Date 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20191201,date_as_of,-1,-1;year_and_quarter "year_and_quarter" true true false 8 Double 0 0,First,#;Join_Count_1 "Join_Count_1" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20191201,Join_Count_1,-1,-1;coe_nbhd_name "CoE Nbhd Name" true true false 120 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20191201,coe_nbhd_name,0,119;coe_nbhd_number_t "CoE Nbhd Number T" true true false 20 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20191201,coe_nbhd_number_t,0,19;coe_nbhd_number_n "CoE Nbhd Number N" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20191201,coe_nbhd_number_n,-1,-1;coe_plngdistrict_name "CoE Planning District" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20191201,coe_plngdistrict_name,0,253;coe_plngdistrict_num "coe_plngdistrict_num" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20191201,coe_plngdistrict_num,-1,-1;coe_ward2021_name "CoE Ward 2021" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20191201,coe_ward2021_name,0,253;Join_Count_12 "Join_Count_12" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20191201,Join_Count_12,-1,-1;epsb_nbhd_name "EPSB Nbhd Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20191201,epsb_nbhd_name,0,49;el_aa_school_name "EL AA School Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20191201,el_aa_school_name,0,49;jh_aa_school_name "JH AA School Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20191201,jh_aa_school_name,0,49;sh_aa_school_name "SH AA School Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20191201,sh_aa_school_name,0,49;epsb_plngsector2020_name "EPSB Planning Sector" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20191201,epsb_plngsector2020_name,0,49;epsb_plngarea_name "EPSB Planning Area" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20191201,epsb_plngarea_name,0,49;epsb_ward2021_name "EPSB Ward 2021" true true false 5 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20191201,epsb_ward2021_name,0,4" # # # NOT_UPDATE_GEOMETRY CalculateField FC_NewRegisteredTitledLots_v01 year_and_quarter "int(datetime.datetime.strftime(!date_to!, "%Y")) + (math.ceil(int(datetime.datetime.strftime(!date_to!, "%m"))/3))/10" Python "import datetime" Text NO_ENFORCE_DOMAINS Append FC_TitledLots_20190901 FC_NewRegisteredTitledLots_v01 "Use the field map to reconcile field differences" "PGM_ID "PGM_ID" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190901,PGM_ID,-1,-1;LUC "LUC" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190901,LUC,0,253;LUC_COLOR "LUC_COLOR" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190901,LUC_COLOR,-1,-1;ADD_ID "ADD_ID" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190901,ADD_ID,-1,-1;SUITE_NO "SUITE_NO" true true false 8 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190901,SUITE_NO,0,7;UNIT_NO "UNIT_NO" true true false 8 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190901,UNIT_NO,0,7;HOUSE_NO "HOUSE_NO" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190901,HOUSE_NO,-1,-1;HOUSE_SUFF "HOUSE_SUFF" true true false 2 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190901,HOUSE_SUFF,0,1;STREET_NAM "STREET_NAM" true true false 40 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190901,STREET_NAM,0,39;QUADRANT "QUADRANT" true true false 2 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190901,QUADRANT,0,1;POSTAL_COD "POSTAL_COD" true true false 6 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190901,POSTAL_COD,0,5;ADD_STATUS "ADD_STATUS" true true false 15 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190901,ADD_STATUS,0,14;date_from "date_from" true true false 8 Date 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190901,date_from,-1,-1;date_to "date_to" true true false 8 Date 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190901,date_to,-1,-1;Join_Count "Join_Count" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190901,Join_Count,-1,-1;zoning "zoning" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190901,zoning,0,253;zoning_des "zoning_des" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190901,zoning_des,0,253;Res_Density "Res_Density" true true false 2 Short 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190901,Res_Density,-1,-1;date_as_of "date_as_of" true true false 8 Date 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190901,date_as_of,-1,-1;year_and_quarter "year_and_quarter" true true false 8 Double 0 0,First,#;Join_Count_1 "Join_Count_1" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190901,Join_Count_1,-1,-1;coe_nbhd_name "CoE Nbhd Name" true true false 120 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190901,coe_nbhd_name,0,119;coe_nbhd_number_t "CoE Nbhd Number T" true true false 20 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190901,coe_nbhd_number_t,0,19;coe_nbhd_number_n "CoE Nbhd Number N" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190901,coe_nbhd_number_n,-1,-1;coe_plngdistrict_name "CoE Planning District" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190901,coe_plngdistrict_name,0,253;coe_plngdistrict_num "coe_plngdistrict_num" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190901,coe_plngdistrict_num,-1,-1;coe_ward2021_name "CoE Ward 2021" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190901,coe_ward2021_name,0,253;Join_Count_12 "Join_Count_12" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190901,Join_Count_12,-1,-1;epsb_nbhd_name "EPSB Nbhd Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190901,epsb_nbhd_name,0,49;el_aa_school_name "EL AA School Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190901,el_aa_school_name,0,49;jh_aa_school_name "JH AA School Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190901,jh_aa_school_name,0,49;sh_aa_school_name "SH AA School Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190901,sh_aa_school_name,0,49;epsb_plngsector2020_name "EPSB Planning Sector" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190901,epsb_plngsector2020_name,0,49;epsb_plngarea_name "EPSB Planning Area" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190901,epsb_plngarea_name,0,49;epsb_ward2021_name "EPSB Ward 2021" true true false 5 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190901,epsb_ward2021_name,0,4" # # # NOT_UPDATE_GEOMETRY Append FC_TitledLots_20190601 FC_NewRegisteredTitledLots_v01 "Use the field map to reconcile field differences" "PGM_ID "PGM_ID" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190601,PGM_ID,-1,-1;LUC "LUC" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190601,LUC,0,253;LUC_COLOR "LUC_COLOR" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190601,LUC_COLOR,-1,-1;ADD_ID "ADD_ID" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190601,ADD_ID,-1,-1;SUITE_NO "SUITE_NO" true true false 8 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190601,SUITE_NO,0,7;UNIT_NO "UNIT_NO" true true false 8 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190601,UNIT_NO,0,7;HOUSE_NO "HOUSE_NO" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190601,HOUSE_NO,-1,-1;HOUSE_SUFF "HOUSE_SUFF" true true false 2 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190601,HOUSE_SUFF,0,1;STREET_NAM "STREET_NAM" true true false 40 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190601,STREET_NAM,0,39;QUADRANT "QUADRANT" true true false 2 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190601,QUADRANT,0,1;POSTAL_COD "POSTAL_COD" true true false 6 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190601,POSTAL_COD,0,5;ADD_STATUS "ADD_STATUS" true true false 15 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190601,ADD_STATUS,0,14;date_from "date_from" true true false 8 Date 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190601,date_from,-1,-1;date_to "date_to" true true false 8 Date 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190601,date_to,-1,-1;Join_Count "Join_Count" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190601,Join_Count,-1,-1;zoning "zoning" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190601,zoning,0,253;zoning_des "zoning_des" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190601,zoning_des,0,253;Res_Density "Res_Density" true true false 2 Short 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190601,Res_Density,-1,-1;date_as_of "date_as_of" true true false 8 Date 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190601,date_as_of,-1,-1;year_and_quarter "year_and_quarter" true true false 8 Double 0 0,First,#;Join_Count_1 "Join_Count_1" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190601,Join_Count_1,-1,-1;coe_nbhd_name "CoE Nbhd Name" true true false 120 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190601,coe_nbhd_name,0,119;coe_nbhd_number_t "CoE Nbhd Number T" true true false 20 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190601,coe_nbhd_number_t,0,19;coe_nbhd_number_n "CoE Nbhd Number N" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190601,coe_nbhd_number_n,-1,-1;coe_plngdistrict_name "CoE Planning District" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190601,coe_plngdistrict_name,0,253;coe_plngdistrict_num "coe_plngdistrict_num" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190601,coe_plngdistrict_num,-1,-1;coe_ward2021_name "CoE Ward 2021" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190601,coe_ward2021_name,0,253;Join_Count_12 "Join_Count_12" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190601,Join_Count_12,-1,-1;epsb_nbhd_name "EPSB Nbhd Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190601,epsb_nbhd_name,0,49;el_aa_school_name "EL AA School Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190601,el_aa_school_name,0,49;jh_aa_school_name "JH AA School Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190601,jh_aa_school_name,0,49;sh_aa_school_name "SH AA School Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190601,sh_aa_school_name,0,49;epsb_plngsector2020_name "EPSB Planning Sector" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190601,epsb_plngsector2020_name,0,49;epsb_plngarea_name "EPSB Planning Area" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190601,epsb_plngarea_name,0,49;epsb_ward2021_name "EPSB Ward 2021" true true false 5 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190601,epsb_ward2021_name,0,4" # # # NOT_UPDATE_GEOMETRY Append FC_TitledLots_20190301 FC_NewRegisteredTitledLots_v01 "Use the field map to reconcile field differences" "PGM_ID "PGM_ID" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190301,PGM_ID,-1,-1;LUC "LUC" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190301,LUC,0,253;LUC_COLOR "LUC_COLOR" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190301,LUC_COLOR,-1,-1;ADD_ID "ADD_ID" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190301,ADD_ID,-1,-1;SUITE_NO "SUITE_NO" true true false 8 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190301,SUITE_NO,0,7;UNIT_NO "UNIT_NO" true true false 8 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190301,UNIT_NO,0,7;HOUSE_NO "HOUSE_NO" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190301,HOUSE_NO,-1,-1;HOUSE_SUFF "HOUSE_SUFF" true true false 2 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190301,HOUSE_SUFF,0,1;STREET_NAM "STREET_NAM" true true false 40 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190301,STREET_NAM,0,39;QUADRANT "QUADRANT" true true false 2 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190301,QUADRANT,0,1;POSTAL_COD "POSTAL_COD" true true false 6 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190301,POSTAL_COD,0,5;ADD_STATUS "ADD_STATUS" true true false 15 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190301,ADD_STATUS,0,14;date_from "date_from" true true false 8 Date 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190301,date_from,-1,-1;date_to "date_to" true true false 8 Date 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190301,date_to,-1,-1;Join_Count "Join_Count" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190301,Join_Count,-1,-1;zoning "zoning" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190301,zoning,0,253;zoning_des "zoning_des" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190301,zoning_des,0,253;Res_Density "Res_Density" true true false 2 Short 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190301,Res_Density,-1,-1;date_as_of "date_as_of" true true false 8 Date 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190301,date_as_of,-1,-1;year_and_quarter "year_and_quarter" true true false 8 Double 0 0,First,#;Join_Count_1 "Join_Count_1" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190301,Join_Count_1,-1,-1;coe_nbhd_name "CoE Nbhd Name" true true false 120 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190301,coe_nbhd_name,0,119;coe_nbhd_number_t "CoE Nbhd Number T" true true false 20 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190301,coe_nbhd_number_t,0,19;coe_nbhd_number_n "CoE Nbhd Number N" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190301,coe_nbhd_number_n,-1,-1;coe_plngdistrict_name "CoE Planning District" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190301,coe_plngdistrict_name,0,253;coe_plngdistrict_num "coe_plngdistrict_num" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190301,coe_plngdistrict_num,-1,-1;coe_ward2021_name "CoE Ward 2021" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190301,coe_ward2021_name,0,253;Join_Count_12 "Join_Count_12" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190301,Join_Count_12,-1,-1;epsb_nbhd_name "EPSB Nbhd Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190301,epsb_nbhd_name,0,49;el_aa_school_name "EL AA School Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190301,el_aa_school_name,0,49;jh_aa_school_name "JH AA School Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190301,jh_aa_school_name,0,49;sh_aa_school_name "SH AA School Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190301,sh_aa_school_name,0,49;epsb_plngsector2020_name "EPSB Planning Sector" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190301,epsb_plngsector2020_name,0,49;epsb_plngarea_name "EPSB Planning Area" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190301,epsb_plngarea_name,0,49;epsb_ward2021_name "EPSB Ward 2021" true true false 5 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_TitledLots_20190301,epsb_ward2021_name,0,4" # # # NOT_UPDATE_GEOMETRY CalculateField FC_NewRegisteredTitledLots_v01 year_and_quarter "int(datetime.datetime.strftime(!date_to!, "%Y")) + (math.ceil(int(datetime.datetime.strftime(!date_to!, "%m"))/3))/10" Python "import datetime" 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.3.0'><WorkspaceConnectionString>DATABASE=P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>FC_NewRegisteredTitledLots_v01</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>PID</field_name><field_type>DOUBLE</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> Append Title_new_v01 FC_NewRegisteredTitledLots_v01 "Use the field map to reconcile field differences" "PID "PID" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_v01,PID,-1,-1;PGM_ID "PGM_ID" true true false 8 Double 0 0,First,#;LUC "LUC" true true false 254 Text 0 0,First,#;LUC_COLOR "LUC_COLOR" true true false 8 Double 0 0,First,#;ADD_ID "ADD_ID" true true false 8 Double 0 0,First,#;SUITE_NO "SUITE_NO" true true false 8 Text 0 0,First,#;UNIT_NO "UNIT_NO" true true false 8 Text 0 0,First,#;HOUSE_NO "HOUSE_NO" true true false 8 Double 0 0,First,#;HOUSE_SUFF "HOUSE_SUFF" true true false 2 Text 0 0,First,#;STREET_NAM "STREET_NAM" true true false 40 Text 0 0,First,#;QUADRANT "QUADRANT" true true false 2 Text 0 0,First,#;POSTAL_COD "POSTAL_COD" true true false 6 Text 0 0,First,#;ADD_STATUS "ADD_STATUS" true true false 15 Text 0 0,First,#;date_from "date_from" true true false 8 Date 0 0,First,#,Title_new_v01,from_date,-1,-1;date_to "date_to" true true false 8 Date 0 0,First,#,Title_new_v01,to_date,-1,-1;Join_Count "Join_Count" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_v01,Join_Count,-1,-1;zoning "zoning" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_v01,zoning,0,253;zoning_des "zoning_des" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_v01,zoning_des,0,253;Res_Density "Res_Density" true true false 2 Short 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_v01,Res_Density,-1,-1;date_as_of "date_as_of" true true false 8 Date 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_v01,date_as_of,-1,-1;year_and_quarter "year_and_quarter" true true false 8 Double 0 0,First,#;Join_Count_1 "Join_Count_1" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_v01,Join_Count_1,-1,-1;coe_nbhd_name "CoE Nbhd Name" true true false 120 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_v01,coe_nbhd_name,0,119;coe_nbhd_number_t "CoE Nbhd Number T" true true false 20 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_v01,coe_nbhd_number_t,0,19;coe_nbhd_number_n "CoE Nbhd Number N" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_v01,coe_nbhd_number_n,-1,-1;coe_plngdistrict_name "CoE Planning District" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_v01,coe_plngdistrict_name,0,253;coe_plngdistrict_num "coe_plngdistrict_num" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_v01,coe_plngdistrict_num,-1,-1;coe_ward2021_name "CoE Ward 2021" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_v01,coe_ward2021_name,0,253;Join_Count_12 "Join_Count_12" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_v01,Join_Count_12,-1,-1;epsb_nbhd_name "EPSB Nbhd Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_v01,epsb_nbhd_name,0,49;el_aa_school_name "EL AA School Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_v01,el_aa_school_name,0,49;jh_aa_school_name "JH AA School Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_v01,jh_aa_school_name,0,49;sh_aa_school_name "SH AA School Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_v01,sh_aa_school_name,0,49;epsb_plngsector2020_name "EPSB Planning Sector" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_v01,epsb_plngsector2020_name,0,49;epsb_plngarea_name "EPSB Planning Area" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_v01,epsb_plngarea_name,0,49;epsb_ward2021_name "EPSB Ward 2021" true true false 5 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_v01,epsb_ward2021_name,0,4" # # # NOT_UPDATE_GEOMETRY CalculateField FC_NewRegisteredTitledLots_v01 year_and_quarter "int(datetime.datetime.strftime(!date_to!, "%Y")) + (math.ceil(int(datetime.datetime.strftime(!date_to!, "%m"))/3))/10" Python "import datetime" Text NO_ENFORCE_DOMAINS Append Title_new_20220202_v01 FC_NewRegisteredTitledLots_v01 "Use the field map to reconcile field differences" "PID "PID" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_20220202_v01,PID,-1,-1;PGM_ID "PGM_ID" true true false 8 Double 0 0,First,#;LUC "LUC" true true false 254 Text 0 0,First,#;LUC_COLOR "LUC_COLOR" true true false 8 Double 0 0,First,#;ADD_ID "ADD_ID" true true false 8 Double 0 0,First,#;SUITE_NO "SUITE_NO" true true false 8 Text 0 0,First,#;UNIT_NO "UNIT_NO" true true false 8 Text 0 0,First,#;HOUSE_NO "HOUSE_NO" true true false 8 Double 0 0,First,#;HOUSE_SUFF "HOUSE_SUFF" true true false 2 Text 0 0,First,#;STREET_NAM "STREET_NAM" true true false 40 Text 0 0,First,#;QUADRANT "QUADRANT" true true false 2 Text 0 0,First,#;POSTAL_COD "POSTAL_COD" true true false 6 Text 0 0,First,#;ADD_STATUS "ADD_STATUS" true true false 15 Text 0 0,First,#;date_from "date_from" true true false 8 Date 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_20220202_v01,date_from,-1,-1;date_to "date_to" true true false 8 Date 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_20220202_v01,date_to,-1,-1;Join_Count "Join_Count" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_20220202_v01,Join_Count,-1,-1;zoning "zoning" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_20220202_v01,zoning,0,253;zoning_des "zoning_des" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_20220202_v01,zoning_des,0,253;Res_Density "Res_Density" true true false 2 Short 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_20220202_v01,Res_Density,-1,-1;date_as_of "date_as_of" true true false 8 Date 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_20220202_v01,date_as_of,-1,-1;year_and_quarter "year_and_quarter" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_20220202_v01,year_and_quarter,-1,-1;Join_Count_1 "Join_Count_1" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_20220202_v01,Join_Count_1,-1,-1;coe_nbhd_name "CoE Nbhd Name" true true false 120 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_20220202_v01,coe_nbhd_name,0,119;coe_nbhd_number_t "CoE Nbhd Number T" true true false 20 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_20220202_v01,coe_nbhd_number_t,0,19;coe_nbhd_number_n "CoE Nbhd Number N" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_20220202_v01,coe_nbhd_number_n,-1,-1;coe_plngdistrict_name "CoE Planning District" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_20220202_v01,coe_plngdistrict_name,0,253;coe_plngdistrict_num "coe_plngdistrict_num" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_20220202_v01,coe_plngdistrict_num,-1,-1;coe_ward2021_name "CoE Ward 2021" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_20220202_v01,coe_ward2021_name,0,253;Join_Count_12 "Join_Count_12" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_20220202_v01,Join_Count_12,-1,-1;epsb_nbhd_name "EPSB Nbhd Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_20220202_v01,epsb_nbhd_name,0,49;el_aa_school_name "EL AA School Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_20220202_v01,el_aa_school_name,0,49;jh_aa_school_name "JH AA School Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_20220202_v01,jh_aa_school_name,0,49;sh_aa_school_name "SH AA School Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_20220202_v01,sh_aa_school_name,0,49;epsb_plngsector2020_name "EPSB Planning Sector" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_20220202_v01,epsb_plngsector2020_name,0,49;epsb_plngarea_name "EPSB Planning Area" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_20220202_v01,epsb_plngarea_name,0,49;epsb_ward2021_name "EPSB Ward 2021" true true false 5 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\Altalis_CoE_New_Titled_Lots_FGDB.gdb\Title_new_20220202_v01,epsb_ward2021_name,0,4" # # # NOT_UPDATE_GEOMETRY Append P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01 P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_NewRegisteredTitledLots_v01 "Use the field map to reconcile field differences" "PGM_ID "PGM_ID" true true false 8 Double 0 0,First,#;LUC "LUC" true true false 254 Text 0 0,First,#;LUC_COLOR "LUC_COLOR" true true false 8 Double 0 0,First,#;ADD_ID "ADD_ID" true true false 8 Double 0 0,First,#;SUITE_NO "SUITE_NO" true true false 8 Text 0 0,First,#;UNIT_NO "UNIT_NO" true true false 8 Text 0 0,First,#;HOUSE_NO "HOUSE_NO" true true false 8 Double 0 0,First,#;HOUSE_SUFF "HOUSE_SUFF" true true false 2 Text 0 0,First,#;STREET_NAM "STREET_NAM" true true false 40 Text 0 0,First,#;QUADRANT "QUADRANT" true true false 2 Text 0 0,First,#;POSTAL_COD "POSTAL_COD" true true false 6 Text 0 0,First,#;ADD_STATUS "ADD_STATUS" true true false 15 Text 0 0,First,#;date_from "date_from" true true false 8 Date 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,from_date,-1,-1;date_to "date_to" true true false 8 Date 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,to_date,-1,-1;Join_Count "Join_Count" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,Join_Count,-1,-1;zoning "zoning" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,zoning,0,1999999999;zoning_des "zoning_des" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,description,0,1999999999;Res_Density "Res_Density" true true false 2 Short 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,Res_Density,-1,-1;date_as_of "date_as_of" true true false 8 Date 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,date_as_of,-1,-1;year_and_quarter "year_and_quarter" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,year_and_quarter,-1,-1;Join_Count_1 "Join_Count_1" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,Join_Count_1,-1,-1;coe_nbhd_name "CoE Nbhd Name" true true false 120 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,coe_nbhd_name,0,119;coe_nbhd_number_t "CoE Nbhd Number T" true true false 20 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,coe_nbhd_number_t,0,19;coe_nbhd_number_n "CoE Nbhd Number N" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,coe_nbhd_number_n,-1,-1;coe_plngdistrict_name "CoE Planning District" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,coe_plngdistrict_name,0,253;coe_plngdistrict_num "coe_plngdistrict_num" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,coe_plngdistrict_num,-1,-1;coe_ward2021_name "CoE Ward 2021" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,coe_ward2021_name,0,253;Join_Count_12 "Join_Count_12" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,Join_Count_12,-1,-1;epsb_nbhd_name "EPSB Nbhd Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,epsb_nbhd_name,0,49;el_aa_school_name "EL AA School Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,el_aa_school_name,0,49;jh_aa_school_name "JH AA School Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,jh_aa_school_name,0,49;sh_aa_school_name "SH AA School Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,sh_aa_school_name,0,49;epsb_plngsector2020_name "EPSB Planning Sector" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,epsb_plngsector2020_name,0,49;epsb_plngarea_name "EPSB Planning Area" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,epsb_plngarea_name,0,49;epsb_ward2021_name "EPSB Ward 2021" true true false 5 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,epsb_ward2021_name,0,4;PID "PID" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,PID,-1,-1" # # # NOT_UPDATE_GEOMETRY Append P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01 P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\PreAltalis_CoE_Titled_Lots_FGDB.gdb\FC_NewRegisteredTitledLots_v01 "Use the field map to reconcile field differences" "PGM_ID "PGM_ID" true true false 8 Double 0 0,First,#;LUC "LUC" true true false 254 Text 0 0,First,#;LUC_COLOR "LUC_COLOR" true true false 8 Double 0 0,First,#;ADD_ID "ADD_ID" true true false 8 Double 0 0,First,#;SUITE_NO "SUITE_NO" true true false 8 Text 0 0,First,#;UNIT_NO "UNIT_NO" true true false 8 Text 0 0,First,#;HOUSE_NO "HOUSE_NO" true true false 8 Double 0 0,First,#;HOUSE_SUFF "HOUSE_SUFF" true true false 2 Text 0 0,First,#;STREET_NAM "STREET_NAM" true true false 40 Text 0 0,First,#;QUADRANT "QUADRANT" true true false 2 Text 0 0,First,#;POSTAL_COD "POSTAL_COD" true true false 6 Text 0 0,First,#;ADD_STATUS "ADD_STATUS" true true false 15 Text 0 0,First,#;date_from "date_from" true true false 8 Date 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,from_date,-1,-1;date_to "date_to" true true false 8 Date 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,to_date,-1,-1;Join_Count "Join_Count" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,Join_Count,-1,-1;zoning "zoning" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,zoning,0,1999999999;zoning_des "zoning_des" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,description,0,1999999999;Res_Density "Res_Density" true true false 2 Short 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,Res_Density,-1,-1;date_as_of "date_as_of" true true false 8 Date 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,date_as_of,-1,-1;year_and_quarter "year_and_quarter" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,year_and_quarter,-1,-1;Join_Count_1 "Join_Count_1" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,Join_Count_1,-1,-1;coe_nbhd_name "CoE Nbhd Name" true true false 120 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,coe_nbhd_name,0,119;coe_nbhd_number_t "CoE Nbhd Number T" true true false 20 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,coe_nbhd_number_t,0,19;coe_nbhd_number_n "CoE Nbhd Number N" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,coe_nbhd_number_n,-1,-1;coe_plngdistrict_name "CoE Planning District" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,coe_plngdistrict_name,0,253;coe_plngdistrict_num "coe_plngdistrict_num" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,coe_plngdistrict_num,-1,-1;coe_ward2021_name "CoE Ward 2021" true true false 254 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,coe_ward2021_name,0,253;Join_Count_12 "Join_Count_12" true true false 4 Long 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,Join_Count_12,-1,-1;epsb_nbhd_name "EPSB Nbhd Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,epsb_nbhd_name,0,49;el_aa_school_name "EL AA School Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,el_aa_school_name,0,49;jh_aa_school_name "JH AA School Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,jh_aa_school_name,0,49;sh_aa_school_name "SH AA School Name" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,sh_aa_school_name,0,49;epsb_plngsector2020_name "EPSB Planning Sector" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,epsb_plngsector2020_name,0,49;epsb_plngarea_name "EPSB Planning Area" true true false 50 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,epsb_plngarea_name,0,49;epsb_ward2021_name "EPSB Ward 2021" true true false 5 Text 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,epsb_ward2021_name,0,4;PID "PID" true true false 8 Double 0 0,First,#,P:\Planning\GIS_Data\Data\Altalis\YEG_Titled_Lots\CoE_Lots_20240701\Title_AOI_GDB_10TM_Resource\title_30-06-2024.gdb\Title_new_20240630_v01,PID,-1,-1" # "Res_Density IS NOT NULL" # NOT_UPDATE_GEOMETRY DeleteField FC_NewRegisteredTitledLots_v01 Join_Count_12;epsb_nbhd_name;el_aa_school_name;jh_aa_school_name;sh_aa_school_name;epsb_plngsector2020_name;epsb_plngarea_name;epsb_ward2021_name "Delete Fields" AddSpatialJoin FC_NewRegisteredTitledLots_v01 EPSB_Nbhd_2024 JOIN_ONE_TO_ONE KEEP_ALL "epsb_nbhd_name "EPSB Nbhd Name" true true false 50 Text 0 0,First,#,EPSB Neighbourhoods (2023),epsb_nbhd_name,0,49;el_aa_school_name "EL AA School Name" true true false 50 Text 0 0,First,#,EPSB Neighbourhoods (2023),el_aa_school_name,0,49;jh_aa_school_name "JH AA School Name" true true false 50 Text 0 0,First,#,EPSB Neighbourhoods (2023),jh_aa_school_name,0,49;sh_aa_school_name "SH AA School Name" true true false 50 Text 0 0,First,#,EPSB Neighbourhoods (2023),sh_aa_school_name,0,49;epsb_plngsector2020_name "EPSB Planning Sector" true true false 50 Text 0 0,First,#,EPSB Neighbourhoods (2023),epsb_plngsector2020_name,0,49;epsb_plngarea_name "EPSB Planning Area" true true false 50 Text 0 0,First,#,EPSB Neighbourhoods (2023),epsb_plngarea_name,0,49;epsb_ward2021_name "EPSB Ward 2021" true true false 5 Text 0 0,First,#,EPSB Neighbourhoods (2023),epsb_ward2021_name,0,4" "Have their center in" # # PERMANENT_FIELDS # CalculateField FC_NewRegisteredTitledLots_v01 PID !PGM_ID! Python # Text NO_ENFORCE_DOMAINS CalculateField FC_NewRegisteredTitledLots_v01 PID None Python # Text NO_ENFORCE_DOMAINS 20240528 14203300 20240528 14203300 Microsoft Windows 10 Version 10.0 (Build 19045) ; Esri ArcGIS 13.3.0.52636 FC_NewRegisteredTitledLots_v01 File Geodatabase Feature Class dataset EPSG 6.16(10.0.0) 0 Simple FALSE 0 TRUE FALSE FC_NewRegisteredTitledLots_v01 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. PGM_ID PGM_ID Double 8 0 0 LUC LUC String 254 0 0 LUC_COLOR LUC_COLOR Double 8 0 0 ADD_ID ADD_ID Double 8 0 0 SUITE_NO SUITE_NO String 8 0 0 UNIT_NO UNIT_NO String 8 0 0 HOUSE_NO HOUSE_NO Double 8 0 0 HOUSE_SUFF HOUSE_SUFF String 2 0 0 STREET_NAM STREET_NAM String 40 0 0 QUADRANT QUADRANT String 2 0 0 POSTAL_COD POSTAL_COD String 6 0 0 ADD_STATUS ADD_STATUS String 15 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. 20240528 iVBORw0KGgoAAAANSUhEUgAAASwAAADICAYAAABS39xVAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAO xAAADsQBlSsOGwAAIABJREFUeJzt3Qd8VGW6P/DfnOklyaQQehGQLggiiIAiCliwY++6dr3eVa8r 67Xddd31upb/ut513b1iubsr4q6KuKvoikpRmkiVIl1qSJ9ezvw/zzPJkDJJJiFTzszz/Xzmk2Qy 5SSSn+95z/s+jyESiUQghBAaYEj3AQghRKIksIQQmiGBJYTQDAksIYRmSGAJITRDAksIoRkSWEII zZDAEkJohgSWEEIzJLCEEJohgSWE0AwJLCGEZkhgCSE0QwJLCKEZElhCCM2QwBJCaIYElhBCMySw hBCaIYElhNAMCSyRMQLbNyMSDMDYpz8Um6PVxwb37YFaWwVDl27QF5em7BhFeklgiYzgXvwZyl96 GjqDAYbS7uj+4hstPjYS8KPmg7fh+uR9WEaORekTzyO4ewe8q5ZCZ7bAccY5UPKdKT1+kRoSWCIj mAePQNenfgfFbAaga/Wxvg3fIuJx8efhyiOAGoF/01pU/fmPgF6P0JHDKLrlvhQduUglCSyREQyl 3fjWltqF81Hx8q9hHjYKxffMhr6ohEdlltHjYOo/GIEdW6AvKEzJMYvUk8ASmmIdeRIcMy5C/nmX wth3QOx+xWaH5YQxHFj+zeubPa/i1ed5fsx++gxYRoxO2vHx+29ax6et+Zdcm7T3yVUSWCItXJ99 BMVhh7FnXxh7H5fQcyhwDN16oviuh6Jf+7wIlR/Ggfuuh7HXcfw5CZeXNXqef8sGuL/4GKrbBdfC +bCNPw2FP/n3hEZ07VXxh+fg37wBOqMJpsEjYBl+Yqe/Ry6TwBJpETq0D9Uvvc4jnpL7H2/z8RQ4 FATO6+/k0VRg9w5UvPIsTAOGwH7medApCnTbt0B1FiLvvFlxX8M+eRoi4RA8yxbBOm4SHGfN7PSf K//S6+BduTQaWP0Gdvrr5zoJLJEWzqtuQcGsG3iSPBH6Ll1hcNXGvq7525sIbN2IvOkXcOiRiBrm jzp943/W5kHD0OWRZ2AZOjI24jIPGoFksI2bDNvYidEvFCUp75HLJLBEeih66MyJhRWxDB/NN6LW VCN0cD90FhvMNB9VFww0yopLp/BzAzu2ombBPH6+Y+o5sJ16BpJCgippJLCE5ujsdhRcdUt00WhR ScLP865aBve/PuLPrWMnJPEIRbJIYAnNoVM+6+jx7X4eLYUw9uyDcG0NIn5/Uo5NJJcElsgZ5iEj UPr483xKaOjZJ92HIzpAAkvkDJ3BCEPXHgDdhCZJYAkhNEMCSwihGRJYQgjNkMASQmiGBJYQQjMk sERKBfft5g3Pcb+3d2fCG6HTJXRoP2oXzINp0HDYJ5+V7sPJORJYIiWossKhXzwI/4Y1KL7vUd4a 01DtP9/jj5keWLy9Z/5crnQqgZV6Elg5RK2tRrimKvZ1SyOdZPBznai1gC5+NdG8cy6GFlDNreJ7 f84VI0TqSWDlCO+a5Tj8xE8b3Vd050PIO/uilLy/ZcgJ0bCKRKBliiM/KWVpRGIksHIErfC2jpsM 1X20RItOab12eqdQVQR2b+cGEfX0hUXJf1+RlSSwcoSxR290eegXHCANt6okW9Xbr6Hmg78CoSAQ jtarso4cm/T3FdlJAiuHUBXMVKue+xp/5D6DShCGrt0Rqijj0jBCtJcElkiqbs+8Cu+3XyNcWQHr yadyZxtDiTQ+FR0jgSWSXtKFbkJ0BgksIYRmSGAJITRDAksIoRkSWEIIzZDASoNwdSUCP2yGYrHy JlqdMfnroYTIBhJYaeBdsQQVf3qRu7/onYUouPJm2E+bjmzgXbMC1tHj4Fu/GvriUl6wmiwRvw/e 71bCNm4i9x4U2U8CKw10FisQDkFnd/DeOmoIqkmqCs/qZbCdPCl2V+jAXkSGjYTOZG7Wgbkh6r4c 2PUDHFPPjbugNRIIwLduFaxjT23xNcKV5Qju2Q6MO/r+IrtJYKWBWlOFSDAI1e2CYrXDs/hTGHv3 g7F7r3QczjGINNrqQ/LOvZQ/mgePaLXUjGLPQ/Xbr8E29lQeiTWlM5nihpX32+W8idrYuy9/bp80 rcUKECL7SGClSkSFe/G/4N+8AarXxbv+TccdD9XjgnvxZ1xfSXOBpehhG38aqv/2f7w41DL8RBz5 zWMovmd2dBTZAu+338DQrSd6zZnf7rek35epb38YSrry3B91fqamqDqz+Rh/GKEFElgpEgmH+Y8t dPBH/to++UxEQiGEK47ANmEKTAOHQKscU2ZAZ42e1hbd8WCrYUVsp57R4feyTzoz9jn9zo489zig A7rM/nWHX1NohwRWilBlhLwZFyFv+oWAkl0TxPriLrHPaeTYKahuVhunelSu2LNiMX8e3L8Hxh6t d3Ou+MNzcEw7H6b+gzrnGEXKSWClCM1ZVb/7JtxffoLiOx6E5cRxqXprTYkE/HyKbOzZB2Yq+tcK 27hJKH3sOf68WVjRiDboh9Lggobq80CpGwkKbZLASpFI0I/Qvj3QFzihFBan6m01ORK1jZsMJS86 Uqv5YC7Mg4bBPDROeCl6WMecEvd1PCuXILB9M5zX3B67r/ju2dAZ5J+8lsl/vRShelAlDz6JbKbW 1sSCpsMUpdFrWMeM5yuobb43jZ4ajKboCmPE5+MCgs4rb667N8LzhhJa2iWBlWKBndv46mA28f/w PXzfrYR35RKUPPAkDKXd23wOzT/R3JfqcUOf72zxca2FFa3loiUSllEnw/Xx+8g7dxYvh6gfqVlP mgCz1xN7vPuLT2DqNwCmgUPb/TOKzCCBlSKRUBCVf3wRnuVfoduzf4KhS1dkg9DhAyh/4b9gPWUK h08iYaV63fBv3QTLsFFwffkxCi65rkPvbep3PPc5JPkXXd3s+zRSazhak+YR2ieBlSL0f/yCy2+E Y8ZFmgor2v5CK8pp3VQ8FFBdn3oJoYP7m7Xqov2S8ZZr0GLZ+p5+HQ0rQmuv5IpfbpHASiE6BWq4 BEALeK1YbU2LgRXYtY1HOvrCkkb3h44cwpGXnuatN3nnzYo7b0SvDTXM23haP4i6uaeObhKP1K3I 1+sb36+qqHn/L3CcfbH0GdQICSzRKsXugPn4+HM+FCLB3Ts4sJoJhWA/fTqCu7fDt2Y5rCdPbPYQ 2gcY3LcH9snTWnx/38bvoh83rIHzipsSWhbhW7e60bae4I+74N/2PYdn4x9OQf4l17b5miJzSGCJ DqNRk/30GfH/YXXtwVuNat59CwUtBA01pGjrAgQFFZ0+FlzcfI4qHjp9dX3+j1hg0bYhOm1suEI+ RlURKj8sHXw0RAJLdGqdL31BYfQLnY63HNGtqaq//i/sp03jQHN/vQiW4aN5IzgtFm0qkVFVQ7Qt iEaF9WVubOMn8er7eKednuWLYezVt12vL9JLAkt0mHvpItgnHt0XWPb0wyi5/3EeXbUmb8aFfPVO 9XpQu+BdDjnV7W4UWHRqR+uolPyCdh0TvVbRrT+NBZSxV8vLImwTTm/Xa4v0k8ASHRbc/QPUkWOg 5EVDpeiuh9oMK0IVFsjB2Xci//zLecI7sHUTgMmxx6iuWvg2fQf7pOjVxPZocxJfaJYElugw59W3 Nvra1HdAo6/9WzZCceTFPdUjXR9/IbZOquleQAq1joSVyG4SWKJN3pVLebN2/bKC8t/+EgVX/aTN 9WQURvUlkmnhLK1Fa/r9em2VpBFCAks02y7T9JSO6nhFggGEqypiAeW88e5Wt9PUa1jPveJ/noHz xntafV6o7JCmFtWK1JMRVo5ezat6839QfO8jje6nxhilj/x3o/tor15gz85GRfcSCaum7FPOhr5u rqslnm++Qv75l7X7tUXukMDKQXQlzXHW+c3291GBQdobSEsSXAvnw3nNbbxE4Gi1g5YFdmyB+6tP UTDrBp63qheuKofeWcwloLmGPTXeaEEyw4pGiLRZmko6e1d/g+CBvcifKeGoNRJYOYjKwHhWLIF5 6MjYfTqjmevN67t05clz2vfYLnoDjH0HQGe2NLrb/dVnvGgzXHkE7iWfo/CGu5AOdCXSUvfz+rdu hG380SuSQjsksHIQTXbnTb+g2ap157W3Hf06TuuthnNdNAprWJmBQq7pVUKSf8EVsat+irOoU47f 9cUnCB34EeZBQ2E9qeU2YA1x27G65Q7Oq27plOMQqSeBlYPo1EwN+I7p+U03Egf37IChW69YPaqG 6LSQ5s1MfQeiM5gHDeebTp9dtfFF2ySwcgzNNVW+9hJMg4bDdH3zAKFgKfvVbBTd/gAMXbtzpVQq MUOtaWiey73kX83mfuj7PCJrIUBCBw/AT6Vm2gismvf+grzzL4stf6ClEJ6vv4yVoqln7BFth+Zd sxze1V/HeiGK7CeBlWNowzEtSzCUdIv7fTrVsk06E8H9e7lxBp3mVb7xexj79eeOP003EdNkdsUr z3JoGFroq0g9C+nWFvPg4Yh4vdDl1QWW38cB2zSwqCu0a+H7sJx0KjeqoGMOlR3kif2mvKu+hmnQ 0A5d2RSZRwIrmagOU0QFdEpGdSdWaIJ9y3q+YtYUrcOiyXfql0iNUWlPn1LgjLYno7moJvNQVLaF yrl0efhXcd+rau4cWE44CZZhI4/+TkiT3we16TIPG9X4OO15KLzhbg6jilefjy25oNNO6hZd33iW OuFE6PfcVCQC//bNfPpKG6GF9klgJVH5K7+Bb+0K5M+8HHmJXEKnP7Ctm7izTksF8zoDX8lTmhSz q6MvLEb+RVchXF4G18IPYOjRp9WKCbaTJ8L2l4Utfr/gkmvgW78mWkBPUVA973XorHbeQ9hQYMtG Dkudvvk/SUOXbryhudH7ToiWZKYu0vaJU5tt7VFdNRym7a32IDKbBFYSBbZsQOjAPvi+X59YYKkq qt+ZA8e0mUkNLENpN56fag1VRs2/9LqjI6IO00FfXHK0eazB1GyLDrGfcU6rr9K0VjydstKqeFOf 4+KOXmm9F9WMF9lFAiuJnDfchep5b8A2rnm1zXg4GvgPO3mnj2ptNY94fGtXoujO/2j1sfFGO+1F +w8bLnegERcfh8fNfRppiQXNlSXSyqsezW1RQ1rnVT+BsU//Ft5YabYmTGifBFYSWUePj15+tyT2 h6NTFBTedA/0ecmbIKaSxL71qxNeE9W05lVn0en1fJWPRkL6ktJ2BVaovAyOM89D5ZyXYD/jXG7d JXKDBFaStbYVpRmdrnnL9U5E5YOr3noFXX/5Mu/bS/S01jJ8VLPJ9mNFox9aTe//fj0Cu7cn/Dxa 5hDavweGPv3hWfYF9ySEBFbOkMBKkuCP0X55mVSClybUKayI7ZTmVwjjKbz53qQeE7Wgj9uGvo0q obR4tfTR38BIc1giZ0hgJUH1O6+j6s+v8oip6M6HuCRwxlJVuL/+Ar7vVvDVOGoKEa/DTUZQVe7U 4/9+Le9blLDKPRJYSUCba+vLBnu+WtgosKgLjGXEaGSKsKsGvnWreOEnnb4qFhsyCa3BoiAl4Zoq BPfuii7JyKB1bSJ1JLCSwHT8cF5hTdf9VI+Lr8xRgLk+W4CKV5/j2lCF19/VqAxLutAK8OLbHmje ZDRDVPz+WdhPmw77lBl8Gmg5YUy6D0mkkQRWEjivuBHWE0/mkiq2Uxp0ZgmHeVKdRgnUMSYTAosd Q1hRjSlDtx7QF3TOpDytr9LnF/Di0uDObbzn0VBXubR2wbxoja7631s4DNeXn3CgxessLbKP/FdO EtoX15R96rmwjpvEa5MUqx1aQGukVE9ti4HELeTNLddjj4RDUGuqecI/offzuKFS6RqbA/rColhL MFJ4072Nq0Ho9dw1WsIqd0hgpQDNvYQO7oPpuEEJ/+F2BipvHFHD0VpQcVaXEwoT77pV8Tsjc6v4 NfCuWML12elUtumokPcbhkJ8ukvfbxoegR3bOKBb+rnD5Yd5rVd93SzTwCGx79F+QVppHzpyGIbi LnFL19Q3xhC5QQIrBXxrV6HyTy+g23NzYCgpTcVb8iknLawM7dsN84gxvCo8HmowYShpufGDdeRY 3uJy5P89BfPwE2GKdxobURHcu5NP0dAksMzHD231OCmUaH6qJe6ln0PvLISBtvfU/2y11VB9PmlY kYMksJKArrr5N65F3oVX8opuKo9CI5RUhVV92ReqokClV8KVFS0GFu0ZpFuLFIVHaF3+4xetbuFx TLsg7gioKRqNRTwuKA3KvbRW+sW7YjGc19/ZaLN22bOPwjrmFORfdPXRB6oqVL+PKzeI7CWBlQTU Y4/KnRx54UnemlNw2Q0wDRiMVKJTKMf0C3i/Xv2ygKa8363gfX4NT9eoSkNg705YT2xHORadDsED P0bXSalqq1tlAru28eR5yb8/ltBLl9z/RNz7eOW9GoZ/+1aYBwzmMjh0Wtq0CoTILhJYSUAhRa3W a+fPRcTj4cBKNRoVFVwc3Wjc2ules/VMio5Hhe17Mx1sY6O11YM/7mo2B2Yo7cGnb1zzasAQBOMU 2muP2DYhRQ993YQ8/U8i/7xZx/S6IvNJYCUJVRFwnHtperuztLW4UlE4WBtOpOsLS/jWXqq7lovs 0ZW8+sl0KqtDJZfplJQCy7NsUd1pXOvH5frkfdhOnQr314tihQMbXsBoeArZqAxPfQkbkbUksJL1 iy0pRSHNvXSQ+8uFsI6flNSV53QVsWb+23BefWuLj6EyNHSaR5UnWqM48lF8z+xYZxrFWQxjz958 aknhRSis6GplS/sYXZ//k9dg0fIPepzj9OhkPFU/VQoK+Uprzd/fatYAVuQOCawMVfnab3n9EU0u JwudRrUWVoSuDFLtqoRez2Tm8jVUNiZv2vmonvcmHLT2rO50sX5pBfUIjPteg4bxMXmWLoKxb39+ PWPPPgjX1vDvgj6XsMptElgZquiun3Gp5HSjkGlPAweqZOqYMoPLx9QHVbxlHpZRzeex6itbGKbM 4OCjkArs+oGXNbTWJ1HkDgmsTKCq8G1aC1Pf/rFN01rtTEwBp3NER1I0umqKOt4Edm7ldVtNy0bT fBrNeVHY0WiKuBd/BvPAodzuXggJrAypmEC9Amlup90t4jWGehtys4k4K+99G7/jq37Upad+LZlc +RMNSWBlADrlKnnwSV5cms1oyYOxVz/ueBNP01Eldb3ROxwwD227mUToyCE+jQzu2g7H1HNiI1WR XSSwMoQWwoorTNBVwA5Ud6Arhd5vl/MyhJb2NcZrIZao2gXv8lVE6ggUOeZOPyJTSWCJhLk//wi2 iWeidv7byJ91PbexT5SSX8gldxINq/birUe07kyvdEq3H5GZ5L+sSFjeedFJcsc5lyYeVuEwqt// C6yjT0G4qhzQG3ileruacyRAZ46u/xLZTQJLtP8fTZeWqzs0o9dzSy7qaE1XQT2rlgF+H/IvuVZ+ 86LdJLBEp6NGpw2bmNKIivYn0tVBueonjoUElmi3UDkV1ItfKodWxdf+410UzGq84ZuapQpxrCSw ROIiEa6+UP3OG+jys1/GnYeibTdNw4o0bFcvREdJYImEqT4P1KpKlDzwRKdPmguRCAkskTBqnGFr ofa7EKkggSVQ+/F7MB8/LOVVUYVoLwkswU0gkrWgU4jOJIElOrVIYGD3DvjWfNO4QYQQnUQCK0P5 N6/nLtFKfuZt4g2VHWyxsQUtKrWfPj3lxyRygwRWBomEwzj85P1cyI4qGxTden+bgUWLNKvmzoHj rJkp2UAd2LEVNR+8jaLbH4hfOTSiSu0qkTQSWBlEpygcOp6vv0DeuZcmtNjSs2IJvMu/4oalqQgs U/9ByL/wSpT9aja6/uK3zb7vXf0NbKdOkTkxkRQSWJlEp0P+JddwbSdqxpqXQNsqajFvnzi17Q45 nYi23eSdc3H845l8VkqPJRP4t25E7YfzuAZ98b2z0304WU0CK00Cu7Zzp+SmoyJDaXeU/uezXH1T 16Tte1wUDikMCKoCSt2k6T3jzmXlWFhRezMabVJnn2jtewmsZJLASgNqrFD2zCOwnzatcQv5SCS6 T6+kKyzDT0QmorIyOkvLDSZyjX/LRqgeV6zAoUguCaw0oDbyiskE18IPuQGFbeJUmPoNhGvRx4j4 PDx/laloVGgZMSbdh5ExqMKpdcwEvvhhGXVyug8n60lgpQHVGy+4/CZUz3s9epXvzd/DMno88s+/ HJGAPx2HJDqIatTTRnCRGhJYaUKjKrqRQ4/eC/eXn/DI6tAT98M8cAgKb462fBdCHCWBlQFotFX7 0bvwrl7Gp4vGPv3SfUhCZCQJrAxg7N0PoUMHENixDSX3Px690haJIBIOoXrunOiD9AY4zjibq3YK kasksDJAcP9ehCvK4F//LdTzZnGLdlrWUPb0z6C6XTznpdZW88LSbG+0KkRrJLAyAIWV6qrhFu5V c19D4bW3A2qYW2q5Fn6ASN1lcyFynQRWBgju3olIKIRIyAXXwvm8tcWzcincn/+Dt7hEQsF0H6Jo gP57RHxeKI58+b2kmARWBrCfMYO3d6jVlTzSMvXuD++KJbyRGMitleOZLFxehtp//h3hymh/xeK7 Hkr3IeUcCawMQGVkuj75Ivw/fA+oEZ7DokYOtGdPraqIPkjRw3qSrC7vLHSqzRcyzjwv4efQ7gT/ lg3QWawovOmeTjsWkTgJrAxiHjg09rniyGu8bUd0Ktuks+KXx2mFzmiMfTT1l3LS6SCBJXJSImFF y0p0ekOjjc4ivSSwhIiDlpNU/PEFFN8zO1Y1Q3EW8UcKsfaOzkTnkMASIh41DP/61aj+21twXnET 31U6+xkeddHCXsVild9bGkhgiQ7Vmw8dPsjlcbKWokBntcG/biVQF1g6sxk6mNN9ZDlNAku0m2/D t6ie+zpM/QbA2Kd/1jaNLbrjQeiLuqT7UEQDElii/cIqzIOGAXp99v72FEXqfmUgCSzRbgVX3MQ3 IVJNAksIoRkSWEIIzZDAEkJohgSWyEk18+fC9c+/w0iNYWdeBn1hMQzdeqb7sEQbJLBE1qNKGKbj BsX2ApLg7u0IHT4A44DB3FeQrgoW3vJvsE/O4rVlWUACS2T1AteK3/83N621jp+Mkp8+DsVq4+85 pl8Iy+hTuDz1oVXLuKdgqOxQug9ZtEECS2StcEU5jP0GcmB5ly+GrkFXavPg4XwjzuvvhPurTxE6 sC+NRysSIYElshZVbqUb1a5S7PmNTgkbovZq1ASVSvqIzCaBJVoV3L8H+vxCTf8x653FbT7G2LNP So5FHBsJLK2KRLj8SXD3D/yl4+xLYJ98Ft9/5PknEAkEeGTRritfVJJZp0Q/V6k8M+BdviS6yVnD gSWyhwSWRvm3b+bmqzFGM+yTzoxOHh86EO1t2NJzN62FzmJpVDUzsOsHuD5+D6bjh/HEtGfFYpiH jkL+xVc3ei7VmreOm5ScH0qINkhgZQk/VVB4/69cA948dCQKrriRKw40eszWTTz6CleVw3Tc8TB2 64X8S6+DoXtP1C54B65PF0C38EOYBg5GcO9uOM6c2ex9KOiESBcJLI3S17WYotM1/w+bEdq/F1Wv /47vM/ToHbdJAvc3pBZVXi/8m9ZBp1OgLyrmCprO6+6EdcypKH/5V9yBmgLNNHBIs9ewjBx7TMcd OvAjVFctX71raRK8M4WrKxE6uA+1C95F0Z0PQrE5kv6eInkksDSK5qZMAwbz1a28mZfh4EO38f36 gkIUXHZ93OeYh4+G86Z74Fn8GbxrVnAtq/o/YHoeXVEre+bn/HWovAy+datgG39apxxv5Wsvwdj7 OG6TRdU8uzz8dNJXlofKD+Pwkw+g4MqbESo72Kg+u9Am+S+oYYHtW1D+0tMwDxkBY98BvHq7+L7/ hPWkCXEf7/5qISpefgbF//ZzOK+7A8aefZs/SK/n5q3h8sMoe/ph9Jn7L+7Dt++Oy9Fl9q9hO6Wd ARaJQPV5YZ8yA6b+g+BZ/hUHlpJXgM6getzcurHp6W/9eyMcgnvRx/B/vw6eFUuiFyaEZklgZQH/ 5g3Q1zVI0BdGP9ajBZG04pvXGVHjBEWBku/ksKKmrdV//zPUyiO88pvmvgwlpRwCEb8P5sEj4F2/ Gt6VS/m1que9geDObSi46paEjitcUYbKOb9DuKYKjmkXcGCV3PcIv75idxxzU9OquXOgdxZCyS9E /sxZzR5jKOmKrr98GYGd2/hY6GcT2iaBpWHOG+6GsVdfBH/cDcvIk4BQoNGVP/eXC3mSnbg+/RAl Dz7Jp4TWMafE5nfcX3yMiNfDzUHDtdUovvth6ExmDhQ6Zax86xUeoVAwRIIBVM17HYaefRKq5+7+ 4hN4li7iEVDBpdfxfTSy6ozRlb64C9Sqcvi+W85XRf3fr0XRbffzqW2jxzmLYB09nm9C+ySwNKzg kmuin7SwzMAyaiyc19TNbRUWo/zFp/iUsR7VKy+69ad8mmYaNBy+1d/APvUcHlnVK7z6Vl7mUPPu mzwJHzq0P+Hjs581k1tj6RQ9lxtWa6p4dNdRvnWroS8uiZ3KFlz1Exx+6qHYZL7IfhJYWYxGFwWX 38ifV7/zOq9WP/Lso+j+2zf5j56CyDZhSvQ00eaA4/bpgNKkTrtez6eSNA9Fp2E0ykr4/fOdcEw9 N/a1f8tGWE+e2OGf5/B/3Q/TgCH8GnQxgE53w0cOxQJZMcuSi2wngZUDaA7H882XfNpoGT2+2WR7 a1cCg3t28twTTWAHtm8GwmF4Vy1FYOdWFN5wN1c4oGUKpuMGtnkcHQorVYV78ad8RZGamgZ270Dt gnnc6LTw2tt5lNlZE/gi80lg5QBaU1X62PM8D9VenlVLeb6q+N7ZPIntWbUMtR++w9+jwKIwNA+K Vj1IhpqP3kXV//0BlqEnoPSJF2EL+JE340LojKbo6E/CKqdIYOWIhmFV/d6f+VSNtuhUvzMHxfc9 BmPP3hwC3m+/QWDHVl7bxd2NwyoQCsFx1vn8XMuJ4/jqorF7bx79BLZ9D1O/tkdXHUHbg6r/+r/R 1vDf75EbAAABf0lEQVR1c190QUAqg+YuCawcRFfM6A+f1nDRqRXNDRXf8zCsYybwxLb3my+Rd+4l /FjbhNObVWqgUzO69BeuqoBn2SLoTCYUXHZDpx+n+fhhKH30Wf7c0L1Xp7++0B4JrBxEI6Lgnh0c VjqzhSerTX2jo6TCG+/mWz1aNtEULSwlNQvmcfkZ8/BRSTlOmkinmxD1JLByFK2xohrmdGpHW3z0 RSXtfo2CWdfD2K0HjF2leYNIDQmsHJZ/wZXH9Hxa7kAr5IVIFQksIYRmSGAJITRDAksIoRkSWEII zZDAEkJohgSWEEIzJLCEEJohgSWE0AwJLCGEZkhgCSE0QwJLCKEZElhCCM2QwBJCaIYElhBCMySw hBCaIYElhNAMCSwhhGZIYAkhNEMCSwihGRJYQgjNkMASQmiGBJYQQjMksIQQmiGBJYTQDAksIYRm SGAJITRDAksIoRkSWEIIzZDAEkJohgSWEEIzJLCEEJohgSWE0AwJLCGEZkhgCSGgFf8ffBpsO8Zs 57YAAAAASUVORK5CYII=