20220325 20403300 1.0 FALSE CalculateField prd_ADNB.ADNBEDIT.ADNB_CIVIC_ADDRESS STREET_DIR_CD 0 VB # CalculateField "Civic Address" COLLECTION_METHOD_CD "[COLLECTION_METHOD_CD] =0" VB # CalculateField "Civic Address" COLLECTION_METHOD_CD "[COLLECTION_METHOD_CD] = -1" VB # CalculateField "Civic Address" COLLECTION_METHOD_CD -1 VB # CalculateField "Civic Address" COLLECTION_METHOD_CD -1 VB # CalculateField "Civic Address" COLLECTION_METHOD_CD -1 VB # FeatureClassToFeatureClass "R:\\SDEConnections\\PROD\\ADNBEDIT on prd_ADNB.sde\prd_ADNB.ADNBEDIT.ADNB_CIVIC_ADDRESS" "R:\\SDEConnections\\PROD\\ADNBADMIN on ADNB.sde" ADNB_CIVIC_ADDRESS # "CIVIC_ID "CIVIC_ID" true false false 38 Guid 0 0,First,#,R:\\SDEConnections\\PROD\\ADNBEDIT on prd_ADNB.sde\prd_ADNB.ADNBEDIT.ADNB_CIVIC_ADDRESS,CIVIC_ID,-1,-1;FULL_ADDRESS_SYM "FULL_ADDRESS_SYM" true false false 100 Text 0 0,First,#,R:\\SDEConnections\\PROD\\ADNBEDIT on prd_ADNB.sde\prd_ADNB.ADNBEDIT.ADNB_CIVIC_ADDRESS,FULL_ADDRESS_SYM,0,100;FULL_ADDRESS_DESC "FULL_ADDRESS_DESC" true false false 100 Text 0 0,First,#,R:\\SDEConnections\\PROD\\ADNBEDIT on prd_ADNB.sde\prd_ADNB.ADNBEDIT.ADNB_CIVIC_ADDRESS,FULL_ADDRESS_DESC,0,100;ROAD_ID "ROAD_ID" true false false 4 Long 0 10,First,#,R:\\SDEConnections\\PROD\\ADNBEDIT on prd_ADNB.sde\prd_ADNB.ADNBEDIT.ADNB_CIVIC_ADDRESS,ROAD_ID,-1,-1;PID "PID" true false false 8 Text 0 0,First,#,R:\\SDEConnections\\PROD\\ADNBEDIT on prd_ADNB.sde\prd_ADNB.ADNBEDIT.ADNB_CIVIC_ADDRESS,PID,0,8;CIVIC_NUMBER "CIVIC_NUMBER" true false false 4 Long 0 10,First,#,R:\\SDEConnections\\PROD\\ADNBEDIT on prd_ADNB.sde\prd_ADNB.ADNBEDIT.ADNB_CIVIC_ADDRESS,CIVIC_NUMBER,-1,-1;CIVIC_NUMBER_SUFFIX "CIVIC_NUMBER_SUFFIX" true true false 5 Text 0 0,First,#,R:\\SDEConnections\\PROD\\ADNBEDIT on prd_ADNB.sde\prd_ADNB.ADNBEDIT.ADNB_CIVIC_ADDRESS,CIVIC_NUMBER_SUFFIX,0,5;STREET_NAME "STREET_NAME" true false false 50 Text 0 0,First,#,R:\\SDEConnections\\PROD\\ADNBEDIT on prd_ADNB.sde\prd_ADNB.ADNBEDIT.ADNB_CIVIC_ADDRESS,STREET_NAME,0,50;STREET_TYPE_CD "STREET_TYPE_CD" true false false 2 Short 0 5,First,#,R:\\SDEConnections\\PROD\\ADNBEDIT on prd_ADNB.sde\prd_ADNB.ADNBEDIT.ADNB_CIVIC_ADDRESS,STREET_TYPE_CD,-1,-1;STREET_DIR_CD "STREET_DIR_CD" true true false 2 Short 0 5,First,#,R:\\SDEConnections\\PROD\\ADNBEDIT on prd_ADNB.sde\prd_ADNB.ADNBEDIT.ADNB_CIVIC_ADDRESS,STREET_DIR_CD,-1,-1;COMMUNITY_NAME "COMMUNITY_NAME" true false false 50 Text 0 0,First,#,R:\\SDEConnections\\PROD\\ADNBEDIT on prd_ADNB.sde\prd_ADNB.ADNBEDIT.ADNB_CIVIC_ADDRESS,COMMUNITY_NAME,0,50;SIDE_OF_ROAD_CD "SIDE_OF_ROAD_CD" true false false 2 Short 0 5,First,#,R:\\SDEConnections\\PROD\\ADNBEDIT on prd_ADNB.sde\prd_ADNB.ADNBEDIT.ADNB_CIVIC_ADDRESS,SIDE_OF_ROAD_CD,-1,-1;BUILDING_NAME "BUILDING_NAME" true true false 50 Text 0 0,First,#,R:\\SDEConnections\\PROD\\ADNBEDIT on prd_ADNB.sde\prd_ADNB.ADNBEDIT.ADNB_CIVIC_ADDRESS,BUILDING_NAME,0,50;STRUCTURE_TYPE_CD "STRUCTURE_TYPE_CD" true true false 2 Short 0 5,First,#,R:\\SDEConnections\\PROD\\ADNBEDIT on prd_ADNB.sde\prd_ADNB.ADNBEDIT.ADNB_CIVIC_ADDRESS,STRUCTURE_TYPE_CD,-1,-1;EMS_ORG_ID "EMS_ORG_ID" true false false 2 Short 0 5,First,#,R:\\SDEConnections\\PROD\\ADNBEDIT on prd_ADNB.sde\prd_ADNB.ADNBEDIT.ADNB_CIVIC_ADDRESS,EMS_ORG_ID,-1,-1;FIRE_ORG_ID "FIRE_ORG_ID" true false false 2 Short 0 5,First,#,R:\\SDEConnections\\PROD\\ADNBEDIT on prd_ADNB.sde\prd_ADNB.ADNBEDIT.ADNB_CIVIC_ADDRESS,FIRE_ORG_ID,-1,-1;POLICE_ORG_ID "POLICE_ORG_ID" true false false 2 Short 0 5,First,#,R:\\SDEConnections\\PROD\\ADNBEDIT on prd_ADNB.sde\prd_ADNB.ADNBEDIT.ADNB_CIVIC_ADDRESS,POLICE_ORG_ID,-1,-1;POISON_CONTROL_ORG_ID "POISON_CONTROL_ORG_ID" true false false 2 Short 0 5,First,#,R:\\SDEConnections\\PROD\\ADNBEDIT on prd_ADNB.sde\prd_ADNB.ADNBEDIT.ADNB_CIVIC_ADDRESS,POISON_CONTROL_ORG_ID,-1,-1;PSAP_ORG_ID "PSAP_ORG_ID" true false false 2 Short 0 5,First,#,R:\\SDEConnections\\PROD\\ADNBEDIT on prd_ADNB.sde\prd_ADNB.ADNBEDIT.ADNB_CIVIC_ADDRESS,PSAP_ORG_ID,-1,-1;ESN "ESN" true false false 2 Short 0 5,First,#,R:\\SDEConnections\\PROD\\ADNBEDIT on prd_ADNB.sde\prd_ADNB.ADNBEDIT.ADNB_CIVIC_ADDRESS,ESN,-1,-1;COLLECTION_METHOD_CD "COLLECTION_METHOD_CD" true true false 2 Short 0 5,First,#,R:\\SDEConnections\\PROD\\ADNBEDIT on prd_ADNB.sde\prd_ADNB.ADNBEDIT.ADNB_CIVIC_ADDRESS,COLLECTION_METHOD_CD,-1,-1;ISSUING_ORG_ID "ISSUING_ORG_ID" true true false 2 Short 0 5,First,#,R:\\SDEConnections\\PROD\\ADNBEDIT on prd_ADNB.sde\prd_ADNB.ADNBEDIT.ADNB_CIVIC_ADDRESS,ISSUING_ORG_ID,-1,-1;ALTERNATE_ACCESS "ALTERNATE_ACCESS" true true false 30 Text 0 0,First,#,R:\\SDEConnections\\PROD\\ADNBEDIT on prd_ADNB.sde\prd_ADNB.ADNBEDIT.ADNB_CIVIC_ADDRESS,ALTERNATE_ACCESS,0,30;LATITUDE "LATITUDE" true false false 8 Double 8 38,First,#,R:\\SDEConnections\\PROD\\ADNBEDIT on prd_ADNB.sde\prd_ADNB.ADNBEDIT.ADNB_CIVIC_ADDRESS,LATITUDE,-1,-1;LONGITUDE "LONGITUDE" true false false 8 Double 8 38,First,#,R:\\SDEConnections\\PROD\\ADNBEDIT on prd_ADNB.sde\prd_ADNB.ADNBEDIT.ADNB_CIVIC_ADDRESS,LONGITUDE,-1,-1;ADDRESS_POINT_TYPE_CD "ADDRESS_POINT_TYPE_CD" true false false 2 Short 0 5,First,#,R:\\SDEConnections\\PROD\\ADNBEDIT on prd_ADNB.sde\prd_ADNB.ADNBEDIT.ADNB_CIVIC_ADDRESS,ADDRESS_POINT_TYPE_CD,-1,-1;DESCRIPTION "DESCRIPTION" true true false 50 Text 0 0,First,#,R:\\SDEConnections\\PROD\\ADNBEDIT on prd_ADNB.sde\prd_ADNB.ADNBEDIT.ADNB_CIVIC_ADDRESS,DESCRIPTION,0,50;REQUEST_ID "REQUEST_ID" true true false 12 Text 0 0,First,#,R:\\SDEConnections\\PROD\\ADNBEDIT on prd_ADNB.sde\prd_ADNB.ADNBEDIT.ADNB_CIVIC_ADDRESS,REQUEST_ID,0,12;LAST_MODIFIED_BY "LAST_MODIFIED_BY" true true false 50 Text 0 0,First,#,R:\\SDEConnections\\PROD\\ADNBEDIT on prd_ADNB.sde\prd_ADNB.ADNBEDIT.ADNB_CIVIC_ADDRESS,LAST_MODIFIED_BY,0,50;LAST_MODIFIED_BY_AGENCY "LAST_MODIFIED_BY_AGENCY" true true false 2 Short 0 5,First,#,R:\\SDEConnections\\PROD\\ADNBEDIT on prd_ADNB.sde\prd_ADNB.ADNBEDIT.ADNB_CIVIC_ADDRESS,LAST_MODIFIED_BY_AGENCY,-1,-1;LAST_MODIFIED_DATE "LAST_MODIFIED_DATE" true true false 8 Date 0 0,First,#,R:\\SDEConnections\\PROD\\ADNBEDIT on prd_ADNB.sde\prd_ADNB.ADNBEDIT.ADNB_CIVIC_ADDRESS,LAST_MODIFIED_DATE,-1,-1;CREATED_BY "CREATED_BY" true false false 50 Text 0 0,First,#,R:\\SDEConnections\\PROD\\ADNBEDIT on prd_ADNB.sde\prd_ADNB.ADNBEDIT.ADNB_CIVIC_ADDRESS,CREATED_BY,0,50;CREATED_DATE "CREATED_DATE" true false false 8 Date 0 0,First,#,R:\\SDEConnections\\PROD\\ADNBEDIT on prd_ADNB.sde\prd_ADNB.ADNBEDIT.ADNB_CIVIC_ADDRESS,CREATED_DATE,-1,-1;CREATED_BY_AGENCY "CREATED_BY_AGENCY" true false false 2 Short 0 5,First,#,R:\\SDEConnections\\PROD\\ADNBEDIT on prd_ADNB.sde\prd_ADNB.ADNBEDIT.ADNB_CIVIC_ADDRESS,CREATED_BY_AGENCY,-1,-1;RETIRED_DATE "RETIRED_DATE" true true false 8 Date 0 0,First,#,R:\\SDEConnections\\PROD\\ADNBEDIT on prd_ADNB.sde\prd_ADNB.ADNBEDIT.ADNB_CIVIC_ADDRESS,RETIRED_DATE,-1,-1;COMMUNITY_CD "COMMUNITY_CD" true false false 2 Short 0 5,First,#,R:\\SDEConnections\\PROD\\ADNBEDIT on prd_ADNB.sde\prd_ADNB.ADNBEDIT.ADNB_CIVIC_ADDRESS,COMMUNITY_CD,-1,-1" # DeleteField "R:\\SDEConnections\\PROD\\ADNBADMIN on ADNB.sde\ADNB.ADNBADMIN.ADNB_CIVIC_ADDRESS" STREET_TYPE_CD "Delete Fields" DeleteField "R:\\SDEConnections\\PROD\\ADNBADMIN on ADNB.sde\ADNB.ADNBADMIN.ADNB_CIVIC_ADDRESS" EMS_ORG_ID "Delete Fields" DeleteField "R:\\SDEConnections\\PROD\\ADNBADMIN on ADNB.sde\ADNB.ADNBADMIN.ADNB_CIVIC_ADDRESS" FIRE_ORG_ID "Delete Fields" DeleteField "R:\\SDEConnections\\PROD\\ADNBADMIN on ADNB.sde\ADNB.ADNBADMIN.ADNB_CIVIC_ADDRESS" POLICE_ORG_ID "Delete Fields" DeleteField "R:\\SDEConnections\\PROD\\ADNBADMIN on ADNB.sde\ADNB.ADNBADMIN.ADNB_CIVIC_ADDRESS" POISON_CONTROL_ORG_ID "Delete Fields" DeleteField "R:\\SDEConnections\\PROD\\ADNBADMIN on ADNB.sde\ADNB.ADNBADMIN.ADNB_CIVIC_ADDRESS" ESN "Delete Fields" AddField "R:\\SDEConnections\\PROD\\ADNBADMIN on ADNB.sde\ADNB.ADNBADMIN.ADNB_CIVIC_ADDRESS" STREET_PREFIX "Short (small integer)" # # # "Street Prefix" NULLABLE NON_REQUIRED # AddField "R:\\SDEConnections\\PROD\\ADNBADMIN on ADNB.sde\ADNB.ADNBADMIN.ADNB_CIVIC_ADDRESS" STREET_SUFFIX "Short (small integer)" # # # "Street Suffix" NULLABLE NON_REQUIRED # AddField "R:\\SDEConnections\\PROD\\ADNBADMIN on ADNB.sde\ADNB.ADNBADMIN.ADNB_CIVIC_ADDRESS" BELL_SUFFIX Text # # 1 "Bell Suffix" NULLABLE NON_REQUIRED # AddField "R:\\SDEConnections\\PROD\\ADNBADMIN on ADNB.sde\ADNB.ADNBADMIN.ADNB_CIVIC_ADDRESS" EDIT_STATUS Text # # 10 "Edit Status" NULLABLE NON_REQUIRED # AddField "R:\\SDEConnections\\PROD\\ADNBADMIN on ADNB.sde\ADNB.ADNBADMIN.ADNB_CIVIC_ADDRESS" EDIT_USER Text # # 100 "Edit User" NULLABLE NON_REQUIRED # AddField "R:\\SDEConnections\\PROD\\ADNBADMIN on ADNB.sde\ADNB.ADNBADMIN.ADNB_CIVIC_ADDRESS" EDIT_DATE Date # # # "Edit Date" NULLABLE NON_REQUIRED # AddGlobalIDs 'R:\\SDEConnections\\PROD\\ADNBADMIN on ADNB.sde\ADNB.ADNBADMIN.ADNB_CIVIC_ADDRESS' EnableEditorTracking "R:\\SDEConnections\\PROD\\ADNBADMIN on ADNB.sde\ADNB.ADNBADMIN.ADNB_CIVIC_ADDRESS" CREATED_BY CREATED_DATE LAST_MODIFIED_BY LAST_MODIFIED_DATE NO_ADD_FIELDS "UTC (Coordinated Universal Time)" ChangePrivileges 'R:\\SDEConnections\\PROD\\ADNBADMIN on ADNB.sde\ADNB.ADNBADMIN.ADNB_CIVIC_ADDRESS' ADNBEDIT "Grant view privileges" "Do not change edit privileges" UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68533830492b516664643064305839426d4867454a6a6b6b4949755a5673484b52362f3945445a5951464b383d2a00;SERVER=S78IWVGISDBP01.GNB.CA;INSTANCE=sde:sqlserver:S78IWVGISDBP01.GNB.CA;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=S78IWVGISDBP01.GNB.CA;DATABASE=ADNB;USER=ADNBADMIN;AUTHENTICATION_MODE=DBMS;BRANCH=sde.DEFAULT</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ADNB.ADNBADMIN.ADNB_CIVIC_ADDRESS</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><RegisterAsVersioned><edit_to_base>FALSE</edit_to_base></RegisterAsVersioned></workflow></operationSequence> UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68533830492b516664643064305839426d4867454a6a6b6b4949755a5673484b52362f3945445a5951464b383d2a00;SERVER=S78IWVGISDBP01.GNB.CA;INSTANCE=sde:sqlserver:S78IWVGISDBP01.GNB.CA;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=S78IWVGISDBP01.GNB.CA;DATABASE=ADNB;USER=ADNBADMIN;AUTHENTICATION_MODE=DBMS;BRANCH=sde.DEFAULT</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ADNB.ADNBADMIN.ADNB_CIVIC_ADDRESS</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>PSAP_ID_From_Geometry</rule_name><rule_type>CALCULATION</rule_type><expression>var PSAPfeatures = FeatureSetByName($datastore, "ADNB.ADNBADMIN.ADNB_PRIMARY_PSAP_BOUNDARIES",['PSAP_ORG_ID', 'PSAP_NAME_E'], true); var ptGeom = Geometry($feature); var fsIntersects = Intersects(PSAPfeatures, ptGeom) if (count(fsIntersects)&gt; 0) { var PSAPID = ""; for (var f in fsIntersects) { if (PSAPID == "") { return f.PSAP_ORG_ID; } }} return ""</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><rule_description>Auto Populates the PSAP ID into Civic Address on Insert and Update</rule_description><field_name>PSAP_ORG_ID</field_name><exclude_from_client_eval>True</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>0</category></AddAttributeRule><ReorderAttributeRule><rule_name>PSAP_ID_From_Geometry</rule_name><evaluation_order>1</evaluation_order></ReorderAttributeRule></workflow><workflow><AddAttributeRule><rule_name>PID_From_Geometry</rule_name><rule_type>CALCULATION</rule_type><expression>var PIDfeatures = FeatureSetByName($datastore, "ADNB.ADNBADMIN.ADNB_PARCELS",['PID'], true); var ptGeom = Geometry($feature); var fsIntersects = Intersects(PIDfeatures , ptGeom); if (count(fsIntersects)&gt; 0) { var PID= ""; for (var f in fsIntersects) { if (PID == "") { return f.PID; } }} return ""</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><rule_description>Auto Populates the PID into the Civic Address</rule_description><field_name>PID</field_name><exclude_from_client_eval>True</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>0</category></AddAttributeRule><DisableAttributeRules><rule_name>PID_From_Geometry</rule_name><rule_type>CALCULATION</rule_type></DisableAttributeRules><ReorderAttributeRule><rule_name>PID_From_Geometry</rule_name><evaluation_order>2</evaluation_order></ReorderAttributeRule></workflow><workflow><AddAttributeRule><rule_name>CIVIC ID</rule_name><rule_type>CALCULATION</rule_type><expression>Guid()</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><field_name>CIVIC_ID</field_name><exclude_from_client_eval>True</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>0</category></AddAttributeRule><ReorderAttributeRule><rule_name>CIVIC ID</rule_name><evaluation_order>3</evaluation_order></ReorderAttributeRule></workflow><workflow><AddAttributeRule><rule_name>Community Name</rule_name><rule_type>CALCULATION</rule_type><expression>var CommunityFeatures = FeatureSetByName($datastore, "ADNB.ADNBADMIN.ADNB_COMMUNITY_BOUNDARIES",['COMMUNITY_NAME'], true); var ptGeom = Geometry($feature); var fsIntersects = Intersects(CommunityFeatures , ptGeom); if (count(fsIntersects)&gt; 0) { var Community= ""; for (var f in fsIntersects) { if (Community == "") { return f.COMMUNITY_NAME; } }} return ""</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><field_name>COMMUNITY_NAME</field_name><exclude_from_client_eval>True</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>0</category></AddAttributeRule><ReorderAttributeRule><rule_name>Community Name</rule_name><evaluation_order>4</evaluation_order></ReorderAttributeRule></workflow><workflow><AddAttributeRule><rule_name>Community CD</rule_name><rule_type>CALCULATION</rule_type><expression>var CommunityFeatures = FeatureSetByName($datastore, "ADNB.ADNBADMIN.ADNB_COMMUNITY_BOUNDARIES",['COMMUNITY_CD'], true); var ptGeom = Geometry($feature); var fsIntersects = Intersects(CommunityFeatures , ptGeom); if (count(fsIntersects)&gt; 0) { var Community= ""; for (var f in fsIntersects) { if (Community == "") { return f.COMMUNITY_CD; } }} return ""</expression><is_editable>True</is_editable><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update><field_name>COMMUNITY_CD</field_name><exclude_from_client_eval>True</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>0</category></AddAttributeRule><ReorderAttributeRule><rule_name>Community CD</rule_name><evaluation_order>5</evaluation_order></ReorderAttributeRule></workflow><workflow><AddAttributeRule><rule_name>Too Far From Road Segment</rule_name><rule_type>VALIDATION</rule_type><expression>// ********************************** // CONFIGURATION // ********************************** //THE DISANCE FROM ROAD (in meters) var MIN_DISATANCE_FROM_ROAD = 50 // ********************************** // DO NOT EDIT BELOW // ********************************** //DEFINE GLOBALS var units = "meters"; //IGNORE IF DELETED if ($feature.EDIT_STATUS == 'Deleted') return true; //GET THE INTERSECTING ROADS FEATURESET var fs = FeatureSetByName($datastore, "ADNB.ADNBADMIN.ADNB_ROADS"); fs = Filter(fs, "ROAD_ID = " + $feature.ROAD_ID); //** IMPORTANT **** GET ITSELF - BUGS WHEN USING $feature var oidWhere = "OBJECTID = " + $feature.OBJECTID; var civicfs= FeatureSetByName($datastore, "ADNB.ADNBADMIN.ADNB_CIVIC_ADDRESS"); var myFeatureFeatureSet = Filter(civicfs, oidWhere); var myFeature = First(myFeatureFeatureSet); if (myFeature != null) { //BUFFER THE CURRENT FEATURE BY THE BUFFER SIZE var featureBuffer = Buffer(myFeature, MIN_DISATANCE_FROM_ROAD, units); //GET THE FEATURES THAT INTERSECT THE BUFFER var intersectingFeatures = Intersects(featureBuffer, fs); //GET FEATURE COUNT var intersectingCount = Count(intersectingFeatures); //IF ANY FEATURES ARE FOUND, RETURN TRUE (TRUE = THIS IS VALID) if (intersectingCount &gt; 0) return true; else return false; //ERROR } else { return false; //ERROR }</expression><is_editable>True</is_editable><triggering_events_insert>False</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><error_number>1</error_number><error_message>Address point is too far from the defined road segment / Le point d'adresse est trop éloigné du segment de route défini</error_message><rule_description>Checks if an address point is too far from the defined road segment/ ROAD_ID.</rule_description><exclude_from_client_eval>False</exclude_from_client_eval><batch>True</batch><severity>5</severity><category>0</category></AddAttributeRule></workflow><workflow><AddAttributeRule><rule_name>No Releated Road ID</rule_name><rule_type>VALIDATION</rule_type><expression>var roadId= $feature.ROAD_ID //IGNORE IF DELETED if ($feature.Edit_Status == 'Deleted') return true; var fsRoads= FeatureSetByName($datastore, "ADNB.ADNBADMIN.ADNB_ROADS", ["*"], false) var roadsFiltered = Filter(fsRoads, 'ROAD_ID = @roadId'); if (Count(roadsFiltered) == 0) { return false; } return true;</expression><is_editable>True</is_editable><triggering_events_insert>False</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><error_number>1</error_number><error_message>Invalid Road ID / ID de route invalide</error_message><rule_description>Checks to see if the civic address has a related road ID in the roads feature class</rule_description><exclude_from_client_eval>False</exclude_from_client_eval><batch>True</batch><severity>5</severity><category>0</category></AddAttributeRule></workflow><workflow><AddAttributeRule><rule_name>Civic Number Not In Range</rule_name><rule_type>VALIDATION</rule_type><expression>var roadId= $feature.ROAD_ID var civicNumber = $feature.CIVIC_NUMBER //IGNORE IF DELETED if ($feature.Edit_Status == 'Deleted') return true; var fsRoads= FeatureSetByName($datastore, "ADNB.ADNBADMIN.ADNB_ROADS", ["*"], false) var roadsFiltered = Filter(fsRoads, 'ROAD_ID = @roadId'); if (Count(roadsFiltered) == 0) return false; //GET ROAD var rd = First(roadsFiltered); //ADD ALL RANGES INTO AN ARRAY var addressRangeArray = [ rd.SEGMENT_LOW_LEFT_CIVIC_NUM, rd.SEGMENT_LOW_RIGHT_CIVIC_NUM, rd.SEGMENT_HIGH_LEFT_CIVIC_NUM, rd.SEGMENT_HIGH_RIGHT_CIVIC_NUM ] //GET LOW AND HIGH VALUES FROM ARRAY var low = Min(addressRangeArray); var high = Max(addressRangeArray) //CHECK IF IT CALLS IN BETWEEN OR EQUAL if (civicNumber &gt;= low &amp;&amp; civicNumber &lt;= high) { return true; } return false</expression><is_editable>True</is_editable><triggering_events_insert>False</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><error_number>100</error_number><error_message>Civc Number Not In Range / Numéro civique hors de portee</error_message><rule_description>Checks to see if the civic address is within the address range defined in the roads data.</rule_description><exclude_from_client_eval>False</exclude_from_client_eval><batch>True</batch><severity>5</severity><tags>Soft Error</tags><category>0</category></AddAttributeRule></workflow><workflow><AddAttributeRule><rule_name>On Correct Side Of Road</rule_name><rule_type>VALIDATION</rule_type><expression>var leftSide = 1; //Codes = Left: 1; Right: 2; var rightSide = 2; var roadId= $feature.ROAD_ID; var civicNumber = $feature.CIVIC_NUMBER; var sideOfStreet = $feature.SIDE_OF_ROAD_CD; var isCivicAddressOdd = civicNumber % 2; //IGNORE IF DELETED if ($feature.Edit_Status == 'Deleted') return true; //GET ROAD var whereClause = "ROAD_ID = @roadId"; var roads = FeatureSetByName($datastore, "ADNB.ADNBADMIN.ADNB_ROADS", ["*"], true); var roadsFiltered= Filter(roads, whereClause); var road = First(roadsFiltered); if (road == null) return false; var lowLeft = road.SEGMENT_LOW_LEFT_CIVIC_NUM; var lowRight = road.SEGMENT_LOW_RIGHT_CIVIC_NUM; var isLowLeftOdd = lowLeft % 2; var isLowRightOdd = lowRight % 2; //IF THE ROAD IS ON THE LEFT SIDE OF THE STREET, CHECK THAT IT MATCHES THE ODD/EVENT OF THE LOW LEFT if (sideOfStreet == leftSide) { if (isCivicAddressOdd == isLowLeftOdd) return true; else return false; } //IF THE ROAD IS ON THE RIGHT SIDE OF THE STREET, CHECK THAT IT MATCHES THE ODD/EVENT OF THE LOW RIGHT if (sideOfStreet == rightSide) { if (isCivicAddressOdd == isLowRightOdd) return true; else return false; } return false;</expression><is_editable>True</is_editable><triggering_events_insert>False</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><error_number>1</error_number><error_message>Located on wrong side of road / Situé du mauvais côté de la route</error_message><rule_description>Checks to see if the address number parity matches left or right side</rule_description><exclude_from_client_eval>False</exclude_from_client_eval><batch>True</batch><severity>5</severity><tags>Soft Error</tags><category>0</category></AddAttributeRule></workflow><workflow><AddAttributeRule><rule_name>Duplicated Address</rule_name><rule_type>VALIDATION</rule_type><expression>//IGNORE IF DELETED if ($feature.EDIT_STATUS== 'Deleted') return true; //REPLACE SINGLE QUOTES var streetName = Replace($feature.STREET_NAME, "'", "''"); var communityName= Replace($feature.COMMUNITY_NAME, "'", "''"); //DEFINE WHERE CLAUSE var where = ""; if ($feature.CIVIC_NUMBER != null) where += "CIVIC_NUMBER =" + $feature.CIVIC_NUMBER + " AND "; if ($feature.STREET_NAME != null) where += "UPPER(STREET_NAME) ='" + Upper(streetName) + "' AND "; if ($feature.STREET_PREFIX != null) where += "STREET_PREFIX =" + $feature.STREET_PREFIX + " AND "; if ($feature.STREET_SUFFIX != null) where += "STREET_SUFFIX =" + $feature.STREET_SUFFIX + " AND "; if ($feature.STREET_DIR_CD == 0) { where += "(STREET_DIR_CD =" + $feature.STREET_DIR_CD + " OR STREET_DIR_CD IS NULL) AND "; } if ($feature.STREET_DIR_CD &gt; 0) { where += "STREET_DIR_CD =" + $feature.STREET_DIR_CD + " AND "; } //where += "UPPER(COMMUNITY_NAME) ='" + Upper(communityName) + "' AND "; where += "UPPER(COMMUNITY_NAME) ='" + Upper(communityName) + "' AND "; where += "(EDIT_STATUS &lt;&gt; 'Deleted' OR EDIT_STATUS Is Null)"; //where += "UPPER(COMMUNITY_NAME) ='" + Upper(communityName) + "' AND "; //where += "(EDIT_STATUS IN ('Added', 'Updated') OR EDIT_STATUS IS NULL)"; //SEARCH var fs= FeatureSetByName($datastore, "ADNB.ADNBADMIN.ADNB_CIVIC_ADDRESS", ["*"], false); var results= Filter(fs, where); //CHECK FOR RESULTS if (Count(results) &gt; 1) { return false; } return true;</expression><is_editable>True</is_editable><triggering_events_insert>False</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><error_number>100</error_number><error_message>Duplicated Address / Adresse dupliquée</error_message><rule_description>Checks to see if the civic address is a duplicate in the community.</rule_description><exclude_from_client_eval>False</exclude_from_client_eval><batch>True</batch><severity>5</severity><tags>Hard Error</tags><category>0</category></AddAttributeRule></workflow><workflow><AddAttributeRule><rule_name>PID Is Not Unique</rule_name><rule_type>VALIDATION</rule_type><expression>var pid= $feature.PID //IGNORE IF DELETED if ($feature.Edit_Status == 'Deleted') return true; //GET var fs= FeatureSetByName($datastore, "ADNB.ADNBADMIN.ADNB_CIVIC_ADDRESS", ["PID"], false); var results= Filter(fs, "PID = @pid AND (EDIT_STATUS IN ('Added', 'Updated') OR EDIT_STATUS IS NULL)"); if (Count(results) &gt; 1) { return false; } return true;</expression><is_editable>True</is_editable><triggering_events_insert>False</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><error_number>1</error_number><error_message>PID is not unique / Le PID n'est pas unique.</error_message><rule_description>Checks to see if the civic address has a unique PID</rule_description><exclude_from_client_eval>False</exclude_from_client_eval><batch>True</batch><severity>5</severity><tags>Soft Error</tags><category>0</category></AddAttributeRule></workflow><workflow><AddAttributeRule><rule_name>Close to Address Points</rule_name><rule_type>VALIDATION</rule_type><expression>// ********************************** // CONFIGURATION // ********************************** //THE DISANCE THE POINT SHOULD BE AWAY FROM OTHERS (in meters) var MIN_DISATANCE_FROM_ANOTHER_POINT = 10 // ********************************** // DO NOT EDIT BELOW // ********************************** //DEFINE GLOBALS var units = "meters"; var whereClause = "EDIT_STATUS IN ('Added', 'Updated') OR EDIT_STATUS IS NULL" //IGNORE IF DELETED if ($feature.EDIT_STATUS == 'Deleted') return true; //GET CIVIC ADDRESS FEATURESET var fs = FeatureSetByName($datastore, "ADNB.ADNBADMIN.ADNB_CIVIC_ADDRESS"); var results = Filter(fs, whereClause); //** IMPORTANT **** GET ITSELF - BUGS WHEN USING $feature var oidWhere = "OBJECTID = " + $feature.OBJECTID; var myFeatureFeatureSet = Filter(fs, oidWhere); var myFeature = First(myFeatureFeatureSet); if (myFeature != null) { //DEFINE A BUFFER var featureBuffer = Buffer(myFeature, MIN_DISATANCE_FROM_ANOTHER_POINT, units); //CHECK WHAT FEATURES INTERSECT THE BUFFER var intersectingFeatures = Intersects(fs, featureBuffer); //GET NUMBER OF FEATURES THAT INTERSECTED THE BUFFER var intersectingCount = Count(intersectingFeatures); //IF THERE IS MORE THAN ITSELF FOUND, RETURN ERROR if (intersectingCount &gt; 1) return false; else return true; } else { return false; }</expression><is_editable>True</is_editable><triggering_events_insert>False</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><error_number>1</error_number><error_message>Close to another address point / Près d'un autre point d'adresse</error_message><rule_description>Checks to see if the address point is close to another</rule_description><exclude_from_client_eval>False</exclude_from_client_eval><batch>True</batch><severity>5</severity><category>0</category></AddAttributeRule></workflow></operationSequence>" UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6861306d2f3765424a356e7241793770644756414a6552503269723335586a7642303453524b51447a4f57303d2a00;SERVER=S78IWVGISDBP01.GNB.CA;INSTANCE=sde:sqlserver:S78IWVGISDBP01.GNB.CA;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=S78IWVGISDBP01.GNB.CA;DATABASE=ADNB;USER=ADNBADMIN;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ADNB.ADNBADMIN.ADNB_CIVIC_ADDRESS</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Duplicated Address</rule_name><rule_description>Checks to see if the civic address is a duplicate in the community.</rule_description><error_number>100</error_number><error_message>Duplicated Address / Adresse dupliquée</error_message><exclude_from_client_eval>False</exclude_from_client_eval><tags>Hard Error</tags><severity>5</severity><expression>//IGNORE IF DELETED if ($feature.EDIT_STATUS== 'Deleted') return true; //REPLACE SINGLE QUOTES var streetName = Replace($feature.STREET_NAME, "'", "''"); var communityName= Replace($feature.COMMUNITY_NAME, "'", "''"); //DEFINE WHERE CLAUSE var where = ""; if ($feature.CIVIC_NUMBER != null) where += "CIVIC_NUMBER =" + $feature.CIVIC_NUMBER + " AND "; if ($feature.CIVIC_NUMBER_SUFFIX != null &amp;&amp; $feature.CIVIC_NUMBER_SUFFIX != "") where += "UPPER(CIVIC_NUMBER_SUFFIX) ='" + Upper($feature.CIVIC_NUMBER_SUFFIX) + "' AND "; if ($feature.CIVIC_NUMBER_SUFFIX == "") where += "(CIVIC_NUMBER_SUFFIX Is Null or CIVIC_NUMBER_SUFFIX ='') AND "; if ($feature.CIVIC_NUMBER_SUFFIX == null) where += "(CIVIC_NUMBER_SUFFIX Is Null or CIVIC_NUMBER_SUFFIX ='') AND "; if ($feature.STREET_NAME != null) where += "UPPER(STREET_NAME) ='" + Upper(streetName) + "' AND "; if ($feature.STREET_PREFIX != null) where += "STREET_PREFIX =" + $feature.STREET_PREFIX + " AND "; if ($feature.STREET_SUFFIX != null) where += "STREET_SUFFIX =" + $feature.STREET_SUFFIX + " AND "; if ($feature.STREET_DIR_CD == 0) where += "(STREET_DIR_CD =" + $feature.STREET_DIR_CD + " OR STREET_DIR_CD IS NULL) AND "; if ($feature.STREET_DIR_CD &gt; 0) where += "STREET_DIR_CD =" + $feature.STREET_DIR_CD + " AND "; where += "UPPER(COMMUNITY_NAME) ='" + Upper(communityName) + "' AND "; where += "(EDIT_STATUS &lt;&gt; 'Deleted' OR EDIT_STATUS Is Null)"; //SEARCH var fs= FeatureSetByName($datastore, "ADNB.ADNBADMIN.ADNB_CIVIC_ADDRESS", ["*"], false); var results= Filter(fs, where); //CHECK FOR RESULTS. IF THERE IS 1 OR MORE, RETURN ERROR if (Count(results) &gt; 1) { return false; } return true; </expression><category>0</category><triggering_events_insert>False</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6861306d2f3765424a356e7241793770644756414a6552503269723335586a7642303453524b51447a4f57303d2a00;SERVER=S78IWVGISDBP01.GNB.CA;INSTANCE=sde:sqlserver:S78IWVGISDBP01.GNB.CA;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=S78IWVGISDBP01.GNB.CA;DATABASE=ADNB;USER=ADNBADMIN;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ADNB.ADNBADMIN.ADNB_CIVIC_ADDRESS</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Duplicated Address</rule_name><rule_description>Checks to see if the civic address is a duplicate in the community.</rule_description><error_number>100</error_number><error_message>Duplicated Address / Adresse dupliquée</error_message><exclude_from_client_eval>False</exclude_from_client_eval><tags>Hard Error</tags><severity>5</severity><expression> //IGNORE IF DELETED if ($feature.EDIT_STATUS== 'Deleted') return true; //REPLACE SINGLE QUOTES var streetName = Replace($feature.STREET_NAME, "'", "''"); var communityName= Replace($feature.COMMUNITY_NAME, "'", "''"); //DEFINE WHERE CLAUSE var where = ""; if ($feature.CIVIC_NUMBER != null) where += "CIVIC_NUMBER =" + $feature.CIVIC_NUMBER + " AND "; if ($feature.CIVIC_NUMBER_SUFFIX != null &amp;&amp; $feature.CIVIC_NUMBER_SUFFIX != "") where += "UPPER(CIVIC_NUMBER_SUFFIX) ='" + Upper($feature.CIVIC_NUMBER_SUFFIX) + "' AND "; if ($feature.CIVIC_NUMBER_SUFFIX == "") where += "(CIVIC_NUMBER_SUFFIX Is Null or CIVIC_NUMBER_SUFFIX ='') AND "; if ($feature.CIVIC_NUMBER_SUFFIX == null) where += "(CIVIC_NUMBER_SUFFIX Is Null or CIVIC_NUMBER_SUFFIX ='') AND "; if ($feature.STREET_NAME != null) where += "UPPER(STREET_NAME) ='" + Upper(streetName) + "' AND "; if ($feature.STREET_PREFIX != null) where += "STREET_PREFIX =" + $feature.STREET_PREFIX + " AND "; if ($feature.STREET_SUFFIX != null) where += "STREET_SUFFIX =" + $feature.STREET_SUFFIX + " AND "; if ($feature.STREET_DIR_CD == 0) where += "(STREET_DIR_CD =" + $feature.STREET_DIR_CD + " OR STREET_DIR_CD IS NULL) AND "; if ($feature.STREET_DIR_CD &gt; 0) where += "STREET_DIR_CD =" + $feature.STREET_DIR_CD + " AND "; where += "UPPER(COMMUNITY_NAME) ='" + Upper(communityName) + "' AND "; where += "(EDIT_STATUS &lt;&gt; 'Deleted' OR EDIT_STATUS Is Null)"; //SEARCH var fs= FeatureSetByName($datastore, "ADNB.ADNBADMIN.ADNB_CIVIC_ADDRESS", ["*"], false); var results= Filter(fs, where); //CHECK FOR RESULTS. IF THERE IS 1 OR MORE, RETURN ERROR if (Count(results) &gt; 1) { return false; } return true; </expression><category>0</category><triggering_events_insert>False</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6861306d2f3765424a356e7241793770644756414a6552503269723335586a7642303453524b51447a4f57303d2a00;SERVER=S78IWVGISDBP01.GNB.CA;INSTANCE=sde:sqlserver:S78IWVGISDBP01.GNB.CA;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=S78IWVGISDBP01.GNB.CA;DATABASE=ADNB;USER=ADNBADMIN;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ADNB.ADNBADMIN.ADNB_CIVIC_ADDRESS</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Duplicated Address</rule_name><rule_description>Checks to see if the civic address is a duplicate in the community.</rule_description><error_number>100</error_number><error_message>Duplicated Address / Adresse dupliquée</error_message><exclude_from_client_eval>False</exclude_from_client_eval><tags>Hard Error</tags><severity>5</severity><expression> //IGNORE IF DELETED if ($feature.EDIT_STATUS== 'Deleted') return true; //REPLACE SINGLE QUOTES var streetName = Replace($feature.STREET_NAME, "'", "''"); var communityName= Replace($feature.COMMUNITY_NAME, "'", "''"); //DEFINE WHERE CLAUSE var where = ""; if ($feature.CIVIC_NUMBER != null) where += "CIVIC_NUMBER =" + $feature.CIVIC_NUMBER + " AND "; if ($feature.CIVIC_NUMBER_SUFFIX != null &amp;&amp; $feature.CIVIC_NUMBER_SUFFIX != "") where += "UPPER(CIVIC_NUMBER_SUFFIX) ='" + Upper($feature.CIVIC_NUMBER_SUFFIX) + "' AND "; if ($feature.CIVIC_NUMBER_SUFFIX == "") where += "(CIVIC_NUMBER_SUFFIX Is Null or CIVIC_NUMBER_SUFFIX ='') AND "; if ($feature.CIVIC_NUMBER_SUFFIX == null) where += "(CIVIC_NUMBER_SUFFIX Is Null or CIVIC_NUMBER_SUFFIX ='') AND "; if ($feature.STREET_NAME != null) where += "UPPER(STREET_NAME) ='" + Upper(streetName) + "' AND "; if ($feature.STREET_PREFIX != null) where += "STREET_PREFIX =" + $feature.STREET_PREFIX + " AND "; if ($feature.STREET_SUFFIX != null) where += "STREET_SUFFIX =" + $feature.STREET_SUFFIX + " AND "; if ($feature.STREET_DIR_CD == 0) where += "(STREET_DIR_CD =" + $feature.STREET_DIR_CD + " OR STREET_DIR_CD IS NULL) AND "; if ($feature.STREET_DIR_CD &gt; 0) where += "STREET_DIR_CD =" + $feature.STREET_DIR_CD + " AND "; where += "UPPER(COMMUNITY_NAME) ='" + Upper(communityName) + "' AND "; where += "(EDIT_STATUS &lt;&gt; 'Deleted' OR EDIT_STATUS Is Null)"; //SEARCH var fs= FeatureSetByName($datastore, "ADNB.ADNBADMIN.ADNB_CIVIC_ADDRESS", ["*"], false); var results= Filter(fs, where); //CHECK FOR RESULTS. IF THERE IS 1 OR MORE, RETURN ERROR if (Count(results) &gt; 1) { return false; } return true; </expression><category>0</category><triggering_events_insert>False</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6861306d2f3765424a356e7241793770644756414a6552503269723335586a7642303453524b51447a4f57303d2a00;SERVER=S78IWVGISDBP01.GNB.CA;INSTANCE=sde:sqlserver:S78IWVGISDBP01.GNB.CA;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=S78IWVGISDBP01.GNB.CA;DATABASE=ADNB;USER=ADNBADMIN;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ADNB.ADNBADMIN.ADNB_CIVIC_ADDRESS</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>PID Match</rule_name><rule_type>VALIDATION</rule_type><expression>//DEFINE VARABLES var whereClause = "PID = '" + $feature.PID + "'"; //** IMPORTANT **** GET ITSELF - BUGS WHEN USING $feature var oidWhere = "OBJECTID = " + $feature.OBJECTID; var civicfs = FeatureSetByName($datastore, "ADNB.ADNBADMIN.ADNB_CIVIC_ADDRESS"); var myFeatureFeatureSet = Filter(civicfs, oidWhere); var myFeature = First(myFeatureFeatureSet); //GET PARCEL var fs = FeatureSetByName($datastore, "ADNB.ADNBADMIN.ADNB_PARCELS", ['*'], true); var filteredParcels = Filter(fs ,whereClause); var parcelCount = Count(filteredParcels); //CHECK IF THERE ARE ANY PARCELS FOUND if (parcelCount == 0) return false; //CHECK FOR INTERSECT PARCEL for (var parcel in filteredParcels) { var isMatch = Intersects(myFeature, Geometry(parcel)); if (isMatch) return true; } return false; </expression><is_editable>True</is_editable><triggering_events_insert>False</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><error_number>1</error_number><error_message>Civic Address’s does not intersect with the PID defined. / L'adresse civique ne croise pas le PID défini.</error_message><rule_description>Checks to see if the features PID intersects with the correct Parcel</rule_description><exclude_from_client_eval>False</exclude_from_client_eval><batch>True</batch><severity>5</severity><category>-1</category></AddAttributeRule></workflow></operationSequence>" UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e6861306d2f3765424a356e7241793770644756414a6552503269723335586a7642303453524b51447a4f57303d2a00;SERVER=S78IWVGISDBP01.GNB.CA;INSTANCE=sde:sqlserver:S78IWVGISDBP01.GNB.CA;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=S78IWVGISDBP01.GNB.CA;DATABASE=ADNB;USER=ADNBADMIN;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ADNB.ADNBADMIN.ADNB_CIVIC_ADDRESS</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>PID Match</rule_name><rule_type>VALIDATION</rule_type><expression>//DEFINE VARABLES var whereClause = "PID = '" + $feature.PID + "'"; //** IMPORTANT **** GET ITSELF - BUGS WHEN USING $feature var oidWhere = "OBJECTID = " + $feature.OBJECTID; var civicfs = FeatureSetByName($datastore, "ADNB.ADNBADMIN.ADNB_CIVIC_ADDRESS"); var myFeatureFeatureSet = Filter(civicfs, oidWhere); var myFeature = First(myFeatureFeatureSet); //GET PARCEL var fs = FeatureSetByName($datastore, "ADNB.ADNBADMIN.ADNB_PARCELS", ['*'], true); var filteredParcels = Filter(fs ,whereClause); var parcelCount = Count(filteredParcels); //CHECK IF THERE ARE ANY PARCELS FOUND if (parcelCount == 0) return false; //CHECK FOR INTERSECT PARCEL for (var parcel in filteredParcels) { var isMatch = Intersects(myFeature, Geometry(parcel)); if (isMatch) return true; } return false; </expression><is_editable>True</is_editable><triggering_events_insert>False</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><error_number>1</error_number><error_message>Civic Address’s does not intersect with the PID defined. / L'adresse civique ne croise pas le PID défini.</error_message><rule_description>Checks to see if the features PID intersects with the correct Parcel</rule_description><exclude_from_client_eval>False</exclude_from_client_eval><batch>True</batch><severity>5</severity><category>-1</category></AddAttributeRule></workflow></operationSequence>" UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68533830492b516664643064305839426d4867454a6a6b6b4949755a5673484b52362f3945445a5951464b383d2a00;SERVER=S78IWVGISDBP01.GNB.CA;INSTANCE=sde:sqlserver:S78IWVGISDBP01.GNB.CA;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=S78IWVGISDBP01.GNB.CA;DATABASE=ADNB;USER=ADNBADMIN;AUTHENTICATION_MODE=DBMS;BRANCH=sde.DEFAULT</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ADNB.ADNBADMIN.ADNB_CIVIC_ADDRESS</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>PID Match</rule_name><rule_type>VALIDATION</rule_type><expression>//DEFINE VARABLES var whereClause = "PID = '" + $feature.PID + "'"; //** IMPORTANT **** GET ITSELF - BUGS WHEN USING $feature var oidWhere = "OBJECTID = " + $feature.OBJECTID; var civicfs = FeatureSetByName($datastore, "ADNB.ADNBADMIN.ADNB_CIVIC_ADDRESS"); var myFeatureFeatureSet = Filter(civicfs, oidWhere); var myFeature = First(myFeatureFeatureSet); //GET PARCEL var fs = FeatureSetByName($datastore, "ADNB.ADNBADMIN.ADNB_PARCELS", ['*'], true); var filteredParcels = Filter(fs ,whereClause); var parcelCount = Count(filteredParcels); //CHECK IF THERE ARE ANY PARCELS FOUND if (parcelCount == 0) return false; //CHECK FOR INTERSECT PARCEL for (var parcel in filteredParcels) { var isMatch = Intersects(myFeature, Geometry(parcel)); if (isMatch) return true; } return false; </expression><is_editable>True</is_editable><triggering_events_insert>False</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update><error_number>1</error_number><error_message>Civic Address’s does not intersect with the PID defined. / L'adresse civique ne croise pas le PID défini.</error_message><rule_description>Checks to see if the features PID intersects with the correct Parcel</rule_description><exclude_from_client_eval>False</exclude_from_client_eval><batch>True</batch><severity>5</severity><category>-1</category></AddAttributeRule></workflow></operationSequence>" FeatureClassToFeatureClass Civics \\geoappcifs-test.snb.ca\geonbtest\geonb_data\adnb_update\ADNB_Export_v2_prod.gdb Civic_Addresses_v2 # "CIVIC_ID "CIVIC_ID" true false false 38 Guid 0 0,First,#,Civics,CIVIC_ID,-1,-1;FULL_ADDRESS_SYM "FULL_ADDRESS_SYM" true false false 100 Text 0 0,First,#,Civics,FULL_ADDRESS_SYM,0,100;FULL_ADDRESS_DESC "FULL_ADDRESS_DESC" true false false 100 Text 0 0,First,#,Civics,FULL_ADDRESS_DESC,0,100;ROAD_ID "ROAD_ID" true false false 4 Long 0 10,First,#,Civics,ROAD_ID,-1,-1;PID "PID" true false false 8 Text 0 0,First,#,Civics,PID,0,8;CIVIC_NUMBER "CIVIC_NUMBER" true false false 4 Long 0 10,First,#,Civics,CIVIC_NUMBER,-1,-1;CIVIC_NUMBER_SUFFIX "CIVIC_NUMBER_SUFFIX" true true false 5 Text 0 0,First,#,Civics,CIVIC_NUMBER_SUFFIX,0,5;STREET_NAME "STREET_NAME" true false false 50 Text 0 0,First,#,Civics,STREET_NAME,0,50;STREET_DIR_CD "STREET_DIR_CD" true true false 2 Short 0 5,First,#,Civics,STREET_DIR_CD,-1,-1;COMMUNITY_NAME "COMMUNITY_NAME" true false false 50 Text 0 0,First,#,Civics,COMMUNITY_NAME,0,50;SIDE_OF_ROAD_CD "SIDE_OF_ROAD_CD" true false false 2 Short 0 5,First,#,Civics,SIDE_OF_ROAD_CD,-1,-1;BUILDING_NAME "BUILDING_NAME" true true false 50 Text 0 0,First,#,Civics,BUILDING_NAME,0,50;STRUCTURE_TYPE_CD "STRUCTURE_TYPE_CD" true true false 2 Short 0 5,First,#,Civics,STRUCTURE_TYPE_CD,-1,-1;PSAP_ORG_ID "PSAP_ORG_ID" true false false 2 Short 0 5,First,#,Civics,PSAP_ORG_ID,-1,-1;COLLECTION_METHOD_CD "COLLECTION_METHOD_CD" true true false 2 Short 0 5,First,#,Civics,COLLECTION_METHOD_CD,-1,-1;ISSUING_ORG_ID "ISSUING_ORG_ID" true true false 2 Short 0 5,First,#,Civics,ISSUING_ORG_ID,-1,-1;ALTERNATE_ACCESS "ALTERNATE_ACCESS" true true false 30 Text 0 0,First,#,Civics,ALTERNATE_ACCESS,0,30;LATITUDE "LATITUDE" true false false 8 Double 8 38,First,#,Civics,LATITUDE,-1,-1;LONGITUDE "LONGITUDE" true false false 8 Double 8 38,First,#,Civics,LONGITUDE,-1,-1;ADDRESS_POINT_TYPE_CD "ADDRESS_POINT_TYPE_CD" true false false 2 Short 0 5,First,#,Civics,ADDRESS_POINT_TYPE_CD,-1,-1;DESCRIPTION "DESCRIPTION" true true false 50 Text 0 0,First,#,Civics,DESCRIPTION,0,50;REQUEST_ID "REQUEST_ID" true true false 12 Text 0 0,First,#,Civics,REQUEST_ID,0,12;LAST_MODIFIED_BY "LAST_MODIFIED_BY" false true true 50 Text 0 0,First,#,Civics,LAST_MODIFIED_BY,0,50;LAST_MODIFIED_BY_AGENCY "LAST_MODIFIED_BY_AGENCY" true true false 2 Short 0 5,First,#,Civics,LAST_MODIFIED_BY_AGENCY,-1,-1;LAST_MODIFIED_DATE "LAST_MODIFIED_DATE" false true true 8 Date 0 0,First,#,Civics,LAST_MODIFIED_DATE,-1,-1;CREATED_BY "CREATED_BY" false false true 50 Text 0 0,First,#,Civics,CREATED_BY,0,50;CREATED_DATE "CREATED_DATE" false false true 8 Date 0 0,First,#,Civics,CREATED_DATE,-1,-1;CREATED_BY_AGENCY "CREATED_BY_AGENCY" true false false 2 Short 0 5,First,#,Civics,CREATED_BY_AGENCY,-1,-1;RETIRED_DATE "RETIRED_DATE" true true false 8 Date 0 0,First,#,Civics,RETIRED_DATE,-1,-1;COMMUNITY_CD "COMMUNITY_CD" true false false 2 Short 0 5,First,#,Civics,COMMUNITY_CD,-1,-1;STREET_PREFIX "Street Prefix" true true false 2 Short 0 5,First,#,Civics,STREET_PREFIX,-1,-1;STREET_SUFFIX "Street Suffix" true true false 2 Short 0 5,First,#,Civics,STREET_SUFFIX,-1,-1;BELL_SUFFIX "Bell Suffix" true true false 1 Text 0 0,First,#,Civics,BELL_SUFFIX,0,1;EDIT_STATUS "Edit Status" true true false 10 Text 0 0,First,#,Civics,EDIT_STATUS,0,10;EDIT_USER "Edit User" true true false 100 Text 0 0,First,#,Civics,EDIT_USER,0,100;EDIT_DATE "Edit Date" true true false 8 Date 0 0,First,#,Civics,EDIT_DATE,-1,-1;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#,Civics,GlobalID,-1,-1;VALIDATIONSTATUS "Validation status" false true true 2 Short 0 5,First,#,Civics,VALIDATIONSTATUS,-1,-1" # CopyFeatures \\geoappcifs-test.snb.ca\geonbtest\geonb_data\adnb_update\ADNB_Export_v2_prod.gdb\Civic_Addresses_v2 E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working # # # # AddField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working ADDRESS_TYPE_E Text # # # # NULLABLE NON_REQUIRED # AddField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working ADDRESS_TYPE_F Text # # # # NULLABLE NON_REQUIRED # AddField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working ROAD_SIDE_E Text # # # # NULLABLE NON_REQUIRED # AddField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working ROAD_SIDE_F Text # # # # NULLABLE NON_REQUIRED # AddField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working COLLECTION_METHOD Text # # # # NULLABLE NON_REQUIRED # AddField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working STREET_DIR_E Text # # # # NULLABLE NON_REQUIRED # AddField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working STREET_DIR_F Text # # # # NULLABLE NON_REQUIRED # AddField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working STREET_TYPE_E Text # # # # NULLABLE NON_REQUIRED # AddField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working STREET_TYPE_F Text # # # # NULLABLE NON_REQUIRED # AddField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working STRUCTURE_TYPE_E Text # # # # NULLABLE NON_REQUIRED # AddField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working STRUCTURE_TYPE_F Text # # # # NULLABLE NON_REQUIRED # DeleteField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working PSAP_ORG_ID DeleteField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working ISSUING_ORG_ID DeleteField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working REQUEST_ID DeleteField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working LAST_MODIFIED_BY DeleteField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working LAST_MODIFIED_BY_AGENCY DeleteField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working CREATED_BY DeleteField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working CREATED_BY_AGENCY DeleteField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working RETIRED_DATE DeleteField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working EDIT_DATE DeleteField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working EDIT_STATUS DeleteField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working EDIT_USER DeleteField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working GlobalID DeleteField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working VALIDATIONSTATUS DeleteField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working COMMUNITY_CD DeleteField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working STREET_DIR_CD DeleteField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working SIDE_OF_ROAD_CD DeleteField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working STRUCTURE_TYPE_CD DeleteField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working COLLECTION_METHOD_CD DeleteField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working ADDRESS_POINT_TYPE_CD DeleteField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working STREET_PREFIX DeleteField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working STREET_SUFFIX SpatialJoin E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working \\geoappcifs.snb.ca\GEONBPROD\geonbdata\Administrative_Areas.gdb\Counties E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined "Join one to one" KEEP_ALL "CIVIC_ID "CIVIC_ID" true false false 38 Guid 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working,CIVIC_ID,-1,-1;FULL_ADDRESS_SYM "FULL_ADDRESS_SYM" true false false 100 Text 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working,FULL_ADDRESS_SYM,0,100;FULL_ADDRESS_DESC "FULL_ADDRESS_DESC" true false false 100 Text 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working,FULL_ADDRESS_DESC,0,100;ROAD_ID "ROAD_ID" true false false 4 Long 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working,ROAD_ID,-1,-1;PID "PID" true false false 8 Text 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working,PID,0,8;CIVIC_NUMBER "CIVIC_NUMBER" true false false 4 Long 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working,CIVIC_NUMBER,-1,-1;CIVIC_NUMBER_SUFFIX "CIVIC_NUMBER_SUFFIX" true true false 5 Text 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working,CIVIC_NUMBER_SUFFIX,0,5;STREET_NAME "STREET_NAME" true false false 50 Text 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working,STREET_NAME,0,50;COMMUNITY_NAME "COMMUNITY_NAME" true false false 50 Text 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working,COMMUNITY_NAME,0,50;BUILDING_NAME "BUILDING_NAME" true true false 50 Text 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working,BUILDING_NAME,0,50;ALTERNATE_ACCESS "ALTERNATE_ACCESS" true true false 30 Text 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working,ALTERNATE_ACCESS,0,30;LATITUDE "LATITUDE" true false false 8 Double 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working,LATITUDE,-1,-1;LONGITUDE "LONGITUDE" true false false 8 Double 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working,LONGITUDE,-1,-1;DESCRIPTION "DESCRIPTION" true true false 50 Text 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working,DESCRIPTION,0,50;LAST_MODIFIED_DATE "LAST_MODIFIED_DATE" true true false 8 Date 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working,LAST_MODIFIED_DATE,-1,-1;CREATED_DATE "CREATED_DATE" true false false 8 Date 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working,CREATED_DATE,-1,-1;BELL_SUFFIX "Bell Suffix" true true false 1 Text 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working,BELL_SUFFIX,0,1;ADDRESS_TYPE_E "ADDRESS_TYPE_E" true true false 255 Text 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working,ADDRESS_TYPE_E,0,255;ADDRESS_TYPE_F "ADDRESS_TYPE_F" true true false 255 Text 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working,ADDRESS_TYPE_F,0,255;ROAD_SIDE_E "ROAD_SIDE_E" true true false 255 Text 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working,ROAD_SIDE_E,0,255;ROAD_SIDE_F "ROAD_SIDE_F" true true false 255 Text 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working,ROAD_SIDE_F,0,255;COLLECTION_METHOD "COLLECTION_METHOD" true true false 255 Text 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working,COLLECTION_METHOD,0,255;STREET_DIR_E "STREET_DIR_E" true true false 255 Text 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working,STREET_DIR_E,0,255;STREET_DIR_F "STREET_DIR_F" true true false 255 Text 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working,STREET_DIR_F,0,255;STREET_TYPE_E "STREET_TYPE_E" true true false 255 Text 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working,STREET_TYPE_E,0,255;STREET_TYPE_F "STREET_TYPE_F" true true false 255 Text 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working,STREET_TYPE_F,0,255;STRUCTURE_TYPE_E "STRUCTURE_TYPE_E" true true false 255 Text 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working,STRUCTURE_TYPE_E,0,255;STRUCTURE_TYPE_F "STRUCTURE_TYPE_F" true true false 255 Text 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_working,STRUCTURE_TYPE_F,0,255;RECNO "RECNO" true true false 8 Double 0 0,First,#,\\geoappcifs.snb.ca\GEONBPROD\geonbdata\Administrative_Areas.gdb\Counties,RECNO,-1,-1;AREA "AREA" true true false 8 Double 0 0,First,#,\\geoappcifs.snb.ca\GEONBPROD\geonbdata\Administrative_Areas.gdb\Counties,AREA,-1,-1;DISPX "DISPX" true true false 8 Double 0 0,First,#,\\geoappcifs.snb.ca\GEONBPROD\geonbdata\Administrative_Areas.gdb\Counties,DISPX,-1,-1;DISPY "DISPY" true true false 8 Double 0 0,First,#,\\geoappcifs.snb.ca\GEONBPROD\geonbdata\Administrative_Areas.gdb\Counties,DISPY,-1,-1;SIZE_ "SIZE_" true true false 8 Double 0 0,First,#,\\geoappcifs.snb.ca\GEONBPROD\geonbdata\Administrative_Areas.gdb\Counties,SIZE_,-1,-1;ANGLE "ANGLE" true true false 8 Double 0 0,First,#,\\geoappcifs.snb.ca\GEONBPROD\geonbdata\Administrative_Areas.gdb\Counties,ANGLE,-1,-1;KEYWORD "KEYWORD" true true false 15 Text 0 0,First,#,\\geoappcifs.snb.ca\GEONBPROD\geonbdata\Administrative_Areas.gdb\Counties,KEYWORD,0,15;USERNUM "USERNUM" true true false 8 Double 0 0,First,#,\\geoappcifs.snb.ca\GEONBPROD\geonbdata\Administrative_Areas.gdb\Counties,USERNUM,-1,-1;FCODE "FCODE" true true false 12 Text 0 0,First,#,\\geoappcifs.snb.ca\GEONBPROD\geonbdata\Administrative_Areas.gdb\Counties,FCODE,0,12;DATATYPE "DATATYPE" true true false 2 Short 0 0,First,#,\\geoappcifs.snb.ca\GEONBPROD\geonbdata\Administrative_Areas.gdb\Counties,DATATYPE,-1,-1;DESCFLAGS "DESCFLAGS" true true false 8 Double 0 0,First,#,\\geoappcifs.snb.ca\GEONBPROD\geonbdata\Administrative_Areas.gdb\Counties,DESCFLAGS,-1,-1;THEMENUM "THEMENUM" true true false 8 Double 0 0,First,#,\\geoappcifs.snb.ca\GEONBPROD\geonbdata\Administrative_Areas.gdb\Counties,THEMENUM,-1,-1;INDEXKEY "INDEXKEY" true true false 12 Text 0 0,First,#,\\geoappcifs.snb.ca\GEONBPROD\geonbdata\Administrative_Areas.gdb\Counties,INDEXKEY,0,12;SUPERFLAGS "SUPERFLAGS" true true false 8 Double 0 0,First,#,\\geoappcifs.snb.ca\GEONBPROD\geonbdata\Administrative_Areas.gdb\Counties,SUPERFLAGS,-1,-1;SOURCEID "SOURCEID" true true false 12 Text 0 0,First,#,\\geoappcifs.snb.ca\GEONBPROD\geonbdata\Administrative_Areas.gdb\Counties,SOURCEID,0,12;OID_1 "OID_1" true true false 4 Long 0 0,First,#,\\geoappcifs.snb.ca\GEONBPROD\geonbdata\Administrative_Areas.gdb\Counties,OID_1,-1,-1;KEY "KEY" true true false 15 Text 0 0,First,#,\\geoappcifs.snb.ca\GEONBPROD\geonbdata\Administrative_Areas.gdb\Counties,KEY,0,15;ENG_NAME "ENG_NAME" true true false 254 Text 0 0,First,#,\\geoappcifs.snb.ca\GEONBPROD\geonbdata\Administrative_Areas.gdb\Counties,ENG_NAME,0,254;FRE_NAME "FRE_NAME" true true false 254 Text 0 0,First,#,\\geoappcifs.snb.ca\GEONBPROD\geonbdata\Administrative_Areas.gdb\Counties,FRE_NAME,0,254;DATE_ "DATE_" true true false 254 Text 0 0,First,#,\\geoappcifs.snb.ca\GEONBPROD\geonbdata\Administrative_Areas.gdb\Counties,DATE_,0,254;Shape_Length "Shape_Length" false true true 8 Double 0 0,First,#,\\geoappcifs.snb.ca\GEONBPROD\geonbdata\Administrative_Areas.gdb\Counties,Shape_Length,-1,-1;Shape_Area "Shape_Area" false true true 8 Double 0 0,First,#,\\geoappcifs.snb.ca\GEONBPROD\geonbdata\Administrative_Areas.gdb\Counties,Shape_Area,-1,-1" Intersect # # DeleteField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined Join_Count DeleteField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined TARGET_FID DeleteField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined RECNO DeleteField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined AREA DeleteField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined DISPX DeleteField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined DISPY DeleteField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined SIZE_ DeleteField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined ANGLE DeleteField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined KEYWORD DeleteField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined USERNUM DeleteField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined FCODE DeleteField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined DATATYPE DeleteField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined DESCFLAGS DeleteField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined THEMENUM DeleteField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined INDEXKEY DeleteField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined SUPERFLAGS DeleteField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined SOURCEID DeleteField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined OID_1 DeleteField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined KEY DeleteField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined FRE_NAME DeleteField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined DATE_ AlterField E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined ENG_NAME COUNTY COUNTY Text 254 NULLABLE DO_NOT_CLEAR FeatureClassToFeatureClass E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined E:\scripts\ADNB\Update\outputs\geonb_anb.gdb geonb_anb_addresses # "CIV_ID "CIV_ID" true true false 38 Guid 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined,CIVIC_ID,-1,-1;ADDR_SYM "ADDR_SYM" true true false 100 Text 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined,FULL_ADDRESS_SYM,0,100;ADDR_DESC "ADDR_DESC" true true false 100 Text 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined,FULL_ADDRESS_DESC,0,100;CIVIC_NUM "CIVIC_NUM" true true false 4 Long 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined,CIVIC_NUMBER,-1,-1;NUM_SUFFIX "NUM_SUFFIX" true true false 5 Text 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined,CIVIC_NUMBER_SUFFIX,0,5;PID "PID" true true false 8 Text 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined,PID,0,8;STREET "STREET_NAME" true true false 50 Text 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined,STREET_NAME,0,50;ST_TYPE_E "STREET_TYPE_EN" true true false 255 Text 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined,STREET_TYPE_E,0,255;ST_TYPE_F "STREET_TYPE_FR" true true false 255 Text 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined,STREET_TYPE_F,0,255;RD_SIDE_E "ROAD_SIDE_EN" true true false 255 Text 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined,ROAD_SIDE_E,0,255;RD_SIDE_F "ROAD_SIDE_FR" true true false 255 Text 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined,ROAD_SIDE_F,0,255;ST_DIR_E "STREET_DIR_EN" true true false 255 Text 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined,STREET_DIR_E,0,255;ST_DIR_F "STREET_DIR_FR" true true false 255 Text 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined,STREET_DIR_F,0,255;COMMUNITY "COMMUNITY" true true false 50 Text 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined,COMMUNITY_NAME,0,50;COUNTY "COUNTY" true true false 254 Text 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined,COUNTY,0,254;ADD_TYPE_E "ADDRESS_TYPE_EN" true true false 255 Text 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined,ADDRESS_TYPE_E,0,255;ADD_TYPE_F "ADDRESS_TYPE_FR" true true false 255 Text 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined,ADDRESS_TYPE_F,0,255;DESCRIPT "DESCRIPT" true true false 50 Text 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined,DESCRIPTION,0,50;STRUCT_E "STRUCTURE_TYPE_EN" true true false 255 Text 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined,STRUCTURE_TYPE_E,0,255;STRUCT_F "STRUCTURE_TYPE_FR" true true false 255 Text 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined,STRUCTURE_TYPE_F,0,255;STRU_NAME "STRUCTURE_NAME" true true false 50 Text 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined,BUILDING_NAME,0,50;ALT_ACCESS "ALTERNATE_ACCESS" true true false 30 Text 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined,ALTERNATE_ACCESS,0,30;COLL_MTHD "COLLECTION_METHOD" true true false 255 Text 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined,COLLECTION_METHOD,0,255;CREATED "CREATED" true true false 8 Date 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined,CREATED_DATE,-1,-1;MODIFIED "MODIFIED" true true false 8 Date 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined,LAST_MODIFIED_DATE,-1,-1;LATITUDE "LATITUDE" true true false 8 Double 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined,LATITUDE,-1,-1;LONGITUDE "LONGITUDE" true true false 8 Double 0 0,First,#,E:\scripts\ADNB\Update\Working\GDB.gdb\addresses_joined,LONGITUDE,-1,-1" # AddField E:\scripts\ADNB\Update\outputs\geonb_anb.gdb\geonb_anb_addresses SUB_COUNT Text # # 5 # NULLABLE NON_REQUIRED # FeatureClassToFeatureClass E:\scripts\ADNB\Update\outputs\geonb_anb.gdb\geonb_anb_addresses E:\scripts\ADNB\Update\ToPack\fgdb\geonb_anb.gdb geonb_anb_addresses # "CIV_ID "CIV_ID" true true false 38 Guid 0 0,First,#,E:\scripts\ADNB\Update\outputs\geonb_anb.gdb\geonb_anb_addresses,CIV_ID,-1,-1;ADDR_SYM "ADDR_SYM" true true false 100 Text 0 0,First,#,E:\scripts\ADNB\Update\outputs\geonb_anb.gdb\geonb_anb_addresses,ADDR_SYM,0,100;ADDR_DESC "ADDR_DESC" true true false 100 Text 0 0,First,#,E:\scripts\ADNB\Update\outputs\geonb_anb.gdb\geonb_anb_addresses,ADDR_DESC,0,100;CIVIC_NUM "CIVIC_NUM" true true false 4 Long 0 0,First,#,E:\scripts\ADNB\Update\outputs\geonb_anb.gdb\geonb_anb_addresses,CIVIC_NUM,-1,-1;NUM_SUFFIX "NUM_SUFFIX" true true false 5 Text 0 0,First,#,E:\scripts\ADNB\Update\outputs\geonb_anb.gdb\geonb_anb_addresses,NUM_SUFFIX,0,5;PID "PID" true true false 8 Text 0 0,First,#,E:\scripts\ADNB\Update\outputs\geonb_anb.gdb\geonb_anb_addresses,PID,0,8;STREET "STREET_NAME" true true false 50 Text 0 0,First,#,E:\scripts\ADNB\Update\outputs\geonb_anb.gdb\geonb_anb_addresses,STREET,0,50;ST_TYPE_E "STREET_TYPE_EN" true true false 255 Text 0 0,First,#,E:\scripts\ADNB\Update\outputs\geonb_anb.gdb\geonb_anb_addresses,ST_TYPE_E,0,255;ST_TYPE_F "STREET_TYPE_FR" true true false 255 Text 0 0,First,#,E:\scripts\ADNB\Update\outputs\geonb_anb.gdb\geonb_anb_addresses,ST_TYPE_F,0,255;RD_SIDE_E "ROAD_SIDE_EN" true true false 255 Text 0 0,First,#,E:\scripts\ADNB\Update\outputs\geonb_anb.gdb\geonb_anb_addresses,RD_SIDE_E,0,255;RD_SIDE_F "ROAD_SIDE_FR" true true false 255 Text 0 0,First,#,E:\scripts\ADNB\Update\outputs\geonb_anb.gdb\geonb_anb_addresses,RD_SIDE_F,0,255;ST_DIR_E "STREET_DIR_EN" true true false 255 Text 0 0,First,#,E:\scripts\ADNB\Update\outputs\geonb_anb.gdb\geonb_anb_addresses,ST_DIR_E,0,255;ST_DIR_F "STREET_DIR_FR" true true false 255 Text 0 0,First,#,E:\scripts\ADNB\Update\outputs\geonb_anb.gdb\geonb_anb_addresses,ST_DIR_F,0,255;COMMUNITY "COMMUNITY" true true false 50 Text 0 0,First,#,E:\scripts\ADNB\Update\outputs\geonb_anb.gdb\geonb_anb_addresses,COMMUNITY,0,50;COUNTY "COUNTY" true true false 254 Text 0 0,First,#,E:\scripts\ADNB\Update\outputs\geonb_anb.gdb\geonb_anb_addresses,COUNTY,0,254;ADD_TYPE_E "ADDRESS_TYPE_EN" true true false 255 Text 0 0,First,#,E:\scripts\ADNB\Update\outputs\geonb_anb.gdb\geonb_anb_addresses,ADD_TYPE_E,0,255;ADD_TYPE_F "ADDRESS_TYPE_FR" true true false 255 Text 0 0,First,#,E:\scripts\ADNB\Update\outputs\geonb_anb.gdb\geonb_anb_addresses,ADD_TYPE_F,0,255;DESCRIPT "DESCRIPT" true true false 50 Text 0 0,First,#,E:\scripts\ADNB\Update\outputs\geonb_anb.gdb\geonb_anb_addresses,DESCRIPT,0,50;STRUCT_E "STRUCTURE_TYPE_EN" true true false 255 Text 0 0,First,#,E:\scripts\ADNB\Update\outputs\geonb_anb.gdb\geonb_anb_addresses,STRUCT_E,0,255;STRUCT_F "STRUCTURE_TYPE_FR" true true false 255 Text 0 0,First,#,E:\scripts\ADNB\Update\outputs\geonb_anb.gdb\geonb_anb_addresses,STRUCT_F,0,255;STRU_NAME "STRUCTURE_NAME" true true false 50 Text 0 0,First,#,E:\scripts\ADNB\Update\outputs\geonb_anb.gdb\geonb_anb_addresses,STRU_NAME,0,50;ALT_ACCESS "ALTERNATE_ACCESS" true true false 30 Text 0 0,First,#,E:\scripts\ADNB\Update\outputs\geonb_anb.gdb\geonb_anb_addresses,ALT_ACCESS,0,30;COLL_MTHD "COLLECTION_METHOD" true true false 255 Text 0 0,First,#,E:\scripts\ADNB\Update\outputs\geonb_anb.gdb\geonb_anb_addresses,COLL_MTHD,0,255;CREATED "CREATED" true true false 8 Date 0 0,First,#,E:\scripts\ADNB\Update\outputs\geonb_anb.gdb\geonb_anb_addresses,CREATED,-1,-1;MODIFIED "MODIFIED" true true false 8 Date 0 0,First,#,E:\scripts\ADNB\Update\outputs\geonb_anb.gdb\geonb_anb_addresses,MODIFIED,-1,-1;LATITUDE "LATITUDE" true true false 8 Double 0 0,First,#,E:\scripts\ADNB\Update\outputs\geonb_anb.gdb\geonb_anb_addresses,LATITUDE,-1,-1;LONGITUDE "LONGITUDE" true true false 8 Double 0 0,First,#,E:\scripts\ADNB\Update\outputs\geonb_anb.gdb\geonb_anb_addresses,LONGITUDE,-1,-1;SUB_COUNT "SUB_COUNT" true true false 5 Text 0 0,First,#,E:\scripts\ADNB\Update\outputs\geonb_anb.gdb\geonb_anb_addresses,SUB_COUNT,0,5" # ExportFeatures geonb_anb_addresses X:\ArcGisProjects\Amalgamation_Clean\Amalgamation_Clean.gdb\Amalgamation_Address # NOT_USE_ALIAS "CIV_ID "CIV_ID" true true false 38 Guid 0 0,First,#,geonb_anb_addresses,CIV_ID,-1,-1;ADDR_SYM "ADDR_SYM" true true false 100 Text 0 0,First,#,geonb_anb_addresses,ADDR_SYM,0,100;ADDR_DESC "ADDR_DESC" true true false 100 Text 0 0,First,#,geonb_anb_addresses,ADDR_DESC,0,100;CIVIC_NUM "CIVIC_NUM" true true false 4 Long 0 0,First,#,geonb_anb_addresses,CIVIC_NUM,-1,-1;NUM_SUFFIX "NUM_SUFFIX" true true false 5 Text 0 0,First,#,geonb_anb_addresses,NUM_SUFFIX,0,5;PID "PID" true true false 8 Text 0 0,First,#,geonb_anb_addresses,PID,0,8;STREET "STREET_NAME" true true false 50 Text 0 0,First,#,geonb_anb_addresses,STREET,0,50;ST_TYPE_E "STREET_TYPE_EN" true true false 255 Text 0 0,First,#,geonb_anb_addresses,ST_TYPE_E,0,255;ST_TYPE_F "STREET_TYPE_FR" true true false 255 Text 0 0,First,#,geonb_anb_addresses,ST_TYPE_F,0,255;RD_SIDE_E "ROAD_SIDE_EN" true true false 255 Text 0 0,First,#,geonb_anb_addresses,RD_SIDE_E,0,255;RD_SIDE_F "ROAD_SIDE_FR" true true false 255 Text 0 0,First,#,geonb_anb_addresses,RD_SIDE_F,0,255;ST_DIR_E "STREET_DIR_EN" true true false 255 Text 0 0,First,#,geonb_anb_addresses,ST_DIR_E,0,255;ST_DIR_F "STREET_DIR_FR" true true false 255 Text 0 0,First,#,geonb_anb_addresses,ST_DIR_F,0,255;COMMUNITY "COMMUNITY" true true false 50 Text 0 0,First,#,geonb_anb_addresses,COMMUNITY,0,50;COUNTY "COUNTY" true true false 254 Text 0 0,First,#,geonb_anb_addresses,COUNTY,0,254;ADD_TYPE_E "ADDRESS_TYPE_EN" true true false 255 Text 0 0,First,#,geonb_anb_addresses,ADD_TYPE_E,0,255;ADD_TYPE_F "ADDRESS_TYPE_FR" true true false 255 Text 0 0,First,#,geonb_anb_addresses,ADD_TYPE_F,0,255;DESCRIPT "DESCRIPT" true true false 50 Text 0 0,First,#,geonb_anb_addresses,DESCRIPT,0,50;STRUCT_E "STRUCTURE_TYPE_EN" true true false 255 Text 0 0,First,#,geonb_anb_addresses,STRUCT_E,0,255;STRUCT_F "STRUCTURE_TYPE_FR" true true false 255 Text 0 0,First,#,geonb_anb_addresses,STRUCT_F,0,255;STRU_NAME "STRUCTURE_NAME" true true false 50 Text 0 0,First,#,geonb_anb_addresses,STRU_NAME,0,50;ALT_ACCESS "ALTERNATE_ACCESS" true true false 30 Text 0 0,First,#,geonb_anb_addresses,ALT_ACCESS,0,30;COLL_MTHD "COLLECTION_METHOD" true true false 255 Text 0 0,First,#,geonb_anb_addresses,COLL_MTHD,0,255;CREATED "CREATED" true true false 8 Date 0 0,First,#,geonb_anb_addresses,CREATED,-1,-1;MODIFIED "MODIFIED" true true false 8 Date 0 0,First,#,geonb_anb_addresses,MODIFIED,-1,-1;LATITUDE "LATITUDE" true true false 8 Double 0 0,First,#,geonb_anb_addresses,LATITUDE,-1,-1;LONGITUDE "LONGITUDE" true true false 8 Double 0 0,First,#,geonb_anb_addresses,LONGITUDE,-1,-1;SUB_COUNT "SUB_COUNT" true true false 5 Text 0 0,First,#,geonb_anb_addresses,SUB_COUNT,0,5" # UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.0.0'><WorkspaceConnectionString>DATABASE=X:\ArcGisProjects\Amalgamation_Clean\Amalgamation_Clean.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Amalgamation_Address</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Ward</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>tax_rate</field_name><field_type>DOUBLE</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Garbage</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Garbage_en</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Garbage_fr</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Police</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Fire</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Snow_removal</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Bylaw</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Building_Permit</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField Amalgamation_Address Police 'tel 911' Arcade # Text NO_ENFORCE_DOMAINS CalculateField Amalgamation_Address Fire 'tel 911' Arcade # Text NO_ENFORCE_DOMAINS CalculateField Amalgamation_Address Garbage 'Chaleur RSC - CSR Chaleur' Arcade # Text NO_ENFORCE_DOMAINS CalculateField Amalgamation_Address Garbage_en 'https://www.csrchaleurrsc.ca/en/schedule' Arcade # Text NO_ENFORCE_DOMAINS CalculateField Amalgamation_Address Garbage_fr 'https://www.csrchaleurrsc.ca/fr/schedule' Arcade # Text NO_ENFORCE_DOMAINS CalculateField Amalgamation_Address Garbage 'City of Bathurst - Ville de Bathurst' Arcade # Text NO_ENFORCE_DOMAINS CalculateField Amalgamation_Address Bylaw 'tel (506) 549 3284' Arcade # Text NO_ENFORCE_DOMAINS CalculateField Amalgamation_Address Building_Permit 'Chaleur RSC - CSR Chaleur tel (506) 542-2688' Arcade # Text NO_ENFORCE_DOMAINS CalculateField Amalgamation_Address Building_Permit 'City of Bathurst - Ville de Bathurst tel (506) 548-0400' Arcade # Text NO_ENFORCE_DOMAINS CalculateField Amalgamation_Address Building_Permit 'Chaleur RSC - CSR Chaleur tel (506) 542-2688' Arcade # Text NO_ENFORCE_DOMAINS CalculateField Amalgamation_Address Snow_removal 'City of Bathurst - Ville de Bathurst (506) 548-0400' Arcade # Text NO_ENFORCE_DOMAINS CalculateField Amalgamation_Address Snow_removal 'DTI' Arcade # Text NO_ENFORCE_DOMAINS UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.0.0'><WorkspaceConnectionString>DATABASE=X:\ArcGisProjects\Amalgamation_Clean\Amalgamation_Clean.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>Amalgamation_Address</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Tax_Zone</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField Amalgamation_Address Ward 'Ward / Quartier 1' Arcade # Text NO_ENFORCE_DOMAINS CalculateField Amalgamation_Address Tax_Zone 'A' Arcade # Text NO_ENFORCE_DOMAINS CalculateField Amalgamation_Address Ward 'Ward / Quartier 2' Arcade # Text NO_ENFORCE_DOMAINS CalculateField Amalgamation_Address Tax_Zone 'B' Arcade # Text NO_ENFORCE_DOMAINS CalculateField Amalgamation_Address Tax_Zone 'C' Arcade # Text NO_ENFORCE_DOMAINS CalculateField Amalgamation_Address Tax_Zone 'D' Arcade # Text NO_ENFORCE_DOMAINS CalculateField Amalgamation_Address Police '(506) 548-0420 -- (Emergency/urgence: 911)' Arcade # Text NO_ENFORCE_DOMAINS CalculateField Amalgamation_Address Fire '(506) 548-0439 -- (Emergency/urgence: 911)' Arcade # Text NO_ENFORCE_DOMAINS CalculateField Amalgamation_Address Police '(Emergency/urgence: 911)' Arcade # Text NO_ENFORCE_DOMAINS CalculateField Amalgamation_Address Fire '(Emergency/urgence: 911)' Arcade # Text NO_ENFORCE_DOMAINS ExportFeatures Amalgamation_Address X:\ArcGisProjects\Amalgamation_Clean\gis_vector.sde\gis_vector.sde.Amalgamation\gis_vector.sde.Amalgamation_Address # NOT_USE_ALIAS "CIV_ID "CIV_ID" true true false 38 Guid 0 0,First,#,Amalgamation_Address,CIV_ID,-1,-1;ADDR_SYM "ADDR_SYM" true true false 100 Text 0 0,First,#,Amalgamation_Address,ADDR_SYM,0,100;ADDR_DESC "ADDR_DESC" true true false 100 Text 0 0,First,#,Amalgamation_Address,ADDR_DESC,0,100;CIVIC_NUM "CIVIC_NUM" true true false 4 Long 0 0,First,#,Amalgamation_Address,CIVIC_NUM,-1,-1;NUM_SUFFIX "NUM_SUFFIX" true true false 5 Text 0 0,First,#,Amalgamation_Address,NUM_SUFFIX,0,5;PID "PID" true true false 8 Text 0 0,First,#,Amalgamation_Address,PID,0,8;STREET "STREET_NAME" true true false 50 Text 0 0,First,#,Amalgamation_Address,STREET,0,50;ST_TYPE_E "STREET_TYPE_EN" true true false 255 Text 0 0,First,#,Amalgamation_Address,ST_TYPE_E,0,255;ST_TYPE_F "STREET_TYPE_FR" true true false 255 Text 0 0,First,#,Amalgamation_Address,ST_TYPE_F,0,255;RD_SIDE_E "ROAD_SIDE_EN" true true false 255 Text 0 0,First,#,Amalgamation_Address,RD_SIDE_E,0,255;RD_SIDE_F "ROAD_SIDE_FR" true true false 255 Text 0 0,First,#,Amalgamation_Address,RD_SIDE_F,0,255;ST_DIR_E "STREET_DIR_EN" true true false 255 Text 0 0,First,#,Amalgamation_Address,ST_DIR_E,0,255;ST_DIR_F "STREET_DIR_FR" true true false 255 Text 0 0,First,#,Amalgamation_Address,ST_DIR_F,0,255;COMMUNITY "COMMUNITY" true true false 50 Text 0 0,First,#,Amalgamation_Address,COMMUNITY,0,50;COUNTY "COUNTY" true true false 254 Text 0 0,First,#,Amalgamation_Address,COUNTY,0,254;ADD_TYPE_E "ADDRESS_TYPE_EN" true true false 255 Text 0 0,First,#,Amalgamation_Address,ADD_TYPE_E,0,255;ADD_TYPE_F "ADDRESS_TYPE_FR" true true false 255 Text 0 0,First,#,Amalgamation_Address,ADD_TYPE_F,0,255;DESCRIPT "DESCRIPT" true true false 50 Text 0 0,First,#,Amalgamation_Address,DESCRIPT,0,50;STRUCT_E "STRUCTURE_TYPE_EN" true true false 255 Text 0 0,First,#,Amalgamation_Address,STRUCT_E,0,255;STRUCT_F "STRUCTURE_TYPE_FR" true true false 255 Text 0 0,First,#,Amalgamation_Address,STRUCT_F,0,255;STRU_NAME "STRUCTURE_NAME" true true false 50 Text 0 0,First,#,Amalgamation_Address,STRU_NAME,0,50;ALT_ACCESS "ALTERNATE_ACCESS" true true false 30 Text 0 0,First,#,Amalgamation_Address,ALT_ACCESS,0,30;COLL_MTHD "COLLECTION_METHOD" true true false 255 Text 0 0,First,#,Amalgamation_Address,COLL_MTHD,0,255;CREATED "CREATED" true true false 8 Date 0 0,First,#,Amalgamation_Address,CREATED,-1,-1;MODIFIED "MODIFIED" true true false 8 Date 0 0,First,#,Amalgamation_Address,MODIFIED,-1,-1;LATITUDE "LATITUDE" true true false 8 Double 0 0,First,#,Amalgamation_Address,LATITUDE,-1,-1;LONGITUDE "LONGITUDE" true true false 8 Double 0 0,First,#,Amalgamation_Address,LONGITUDE,-1,-1;SUB_COUNT "SUB_COUNT" true true false 5 Text 0 0,First,#,Amalgamation_Address,SUB_COUNT,0,5;Ward "Ward" true true false 255 Text 0 0,First,#,Amalgamation_Address,Ward,0,255;tax_rate "tax_rate" true true false 8 Double 0 0,First,#,Amalgamation_Address,tax_rate,-1,-1;Garbage "Garbage" true true false 255 Text 0 0,First,#,Amalgamation_Address,Garbage,0,255;Garbage_en "Garbage_en" true true false 255 Text 0 0,First,#,Amalgamation_Address,Garbage_en,0,255;Garbage_fr "Garbage_fr" true true false 255 Text 0 0,First,#,Amalgamation_Address,Garbage_fr,0,255;Police "Police" true true false 255 Text 0 0,First,#,Amalgamation_Address,Police,0,255;Fire "Fire" true true false 255 Text 0 0,First,#,Amalgamation_Address,Fire,0,255;Snow_removal "Snow_removal" true true false 255 Text 0 0,First,#,Amalgamation_Address,Snow_removal,0,255;Bylaw "Bylaw" true true false 255 Text 0 0,First,#,Amalgamation_Address,Bylaw,0,255;Building_Permit "Building_Permit" true true false 255 Text 0 0,First,#,Amalgamation_Address,Building_Permit,0,255;Tax_Zone "Tax_Zone" true true false 255 Text 0 0,First,#,Amalgamation_Address,Tax_Zone,0,255" # UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.0.0'><FeatureDataset>gis_vector.sde.Amalgamation</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e684978347245456e637a575439777264306e3375726a3537793551367874446168442f53514f6d302b4272633d2a00;ENCRYPTED_PASSWORD=00022e684d3970514b757069324a6339742b316e336273784c6c57696475526f4661444275744477323846354e48513d2a00;SERVER=srv-ch-arcgispg;INSTANCE=sde:postgresql:srv-ch-arcgispg;DBCLIENT=postgresql;DB_CONNECTION_PROPERTIES=srv-ch-arcgispg;DATABASE=gis_vector;USER=sde;AUTHENTICATION_MODE=DBMS;BRANCH=sde.DEFAULT</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>gis_vector.sde.Amalgamation_Address</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddGlobalIDs /></workflow><workflow><EnableEditorTracking><creator_field>created_user</creator_field><creation_date_field>created_date</creation_date_field><last_editor_field>last_edited_user</last_editor_field><last_edit_date_field>last_edited_date</last_edit_date_field><add_fields>TRUE</add_fields><record_dates_in>UTC</record_dates_in></EnableEditorTracking></workflow></operationSequence>" gis_vector.sde.Amalgamation_Address 002 Server=srv-ch-arcgispg; Service=sde:postgresql:srv-ch-arcgispg; Database=gis_vector; User=sde ArcSDE Connection Projected GCS_North_American_1983_CSRS Linear Unit: Meter (1.000000) NAD_1983_CSRS_New_Brunswick_Stereographic <ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.0.0'><WKT>PROJCS[&quot;NAD_1983_CSRS_New_Brunswick_Stereographic&quot;,GEOGCS[&quot;GCS_North_American_1983_CSRS&quot;,DATUM[&quot;D_North_American_1983_CSRS&quot;,SPHEROID[&quot;GRS_1980&quot;,6378137.0,298.257222101]],PRIMEM[&quot;Greenwich&quot;,0.0],UNIT[&quot;Degree&quot;,0.0174532925199433]],PROJECTION[&quot;Double_Stereographic&quot;],PARAMETER[&quot;False_Easting&quot;,2500000.0],PARAMETER[&quot;False_Northing&quot;,7500000.0],PARAMETER[&quot;Central_Meridian&quot;,-66.5],PARAMETER[&quot;Scale_Factor&quot;,0.999912],PARAMETER[&quot;Latitude_Of_Origin&quot;,46.5],UNIT[&quot;Meter&quot;,1.0],AUTHORITY[&quot;EPSG&quot;,2953]],VERTCS[&quot;CGVD2013_CGG2013a_height&quot;,VDATUM[&quot;Canadian_Geodetic_Vertical_Datum_of_2013_CGG2013a&quot;],PARAMETER[&quot;Vertical_Shift&quot;,0.0],PARAMETER[&quot;Direction&quot;,1.0],UNIT[&quot;Meter&quot;,1.0],AUTHORITY[&quot;EPSG&quot;,9245]]</WKT><XOrigin>-28216700</XOrigin><YOrigin>-23260100</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>2036</WKID><LatestWKID>2953</LatestWKID><VCSWKID>9245</VCSWKID><LatestVCSWKID>9245</LatestVCSWKID></ProjectedCoordinateSystem> 20221212 14203800 20221212 14203800 Microsoft Windows 10 Version 10.0 (Build 19045) ; Esri ArcGIS 13.0.3.36057 Amalgamation_Address Adress Amalgamation_Address Enterprise Geodatabase Feature Class dataset EPSG 6.2(9.3.0.0) 0 Simple FALSE 0 TRUE FALSE gis_vector.sde.Amalgamation_Address Feature Class 0 OBJECTID objectid OID 4 10 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. PID PID String 8 0 0 CIV_ID CIV_ID GUID 38 0 0 ADDR_SYM ADDR_SYM String 100 0 0 ADDR_DESC ADDR_DESC String 100 0 0 CIVIC_NUM CIVIC_NUM Integer 4 10 0 NUM_SUFFIX NUM_SUFFIX String 5 0 0 LATITUDE LATITUDE Double 8 38 8 STREET STREET_NAME String 50 0 0 ST_TYPE_E STREET_TYPE_EN String 255 0 0 ST_TYPE_F STREET_TYPE_FR String 255 0 0 RD_SIDE_E ROAD_SIDE_EN String 255 0 0 RD_SIDE_F ROAD_SIDE_FR String 255 0 0 ST_DIR_E STREET_DIR_EN String 255 0 0 ST_DIR_F STREET_DIR_FR String 255 0 0 COMMUNITY COMMUNITY String 50 0 0 COUNTY COUNTY String 254 0 0 ADD_TYPE_E ADDRESS_TYPE_EN String 255 0 0 ADD_TYPE_F ADDRESS_TYPE_FR String 255 0 0 DESCRIPT DESCRIPT String 50 0 0 STRUCT_E STRUCTURE_TYPE_EN String 255 0 0 STRUCT_F STRUCTURE_TYPE_FR String 255 0 0 STRU_NAME STRUCTURE_NAME String 50 0 0 ALT_ACCESS ALTERNATE_ACCESS String 30 0 0 COLL_MTHD COLLECTION_METHOD String 255 0 0 CREATED CREATED Date 8 0 0 MODIFIED MODIFIED Date 8 0 0 LONGITUDE LONGITUDE Double 8 38 8 Shape shape Geometry 8 0 0 Feature geometry. Esri Coordinates defining the features. ward Ward String 255 0 0 tax_rate tax_rate Double 8 38 8 garbage Garbage String 255 0 0 garbage_en Garbage_en String 255 0 0 garbage_fr Garbage_fr String 255 0 0 police Police String 255 0 0 fire Fire String 255 0 0 snow_removal Snow_removal String 255 0 0 bylaw Bylaw String 255 0 0 building_permit Building_Permit String 255 0 0 tax_zone Tax_Zone String 255 0 0 SUB_COUNT SUB_COUNT String 5 0 0 20221212 /9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwCbYJRu lfgdBmo1u54l2DoO2KWSQEjLEEHt3pDIWIBTA9cV7qZ8OxqyuFJYEknNLliQ3ABPc0pwhxt2g0pA dNmeR7U+g9Lj1LowkUKcdeaq5ZmBJ+brgVZt8JJsfkEU2W2SFd65znrntRYQjRucFJMYGTSREo2T ye1Rhn3HCE+nPFTSo0qRHGCOSKdtAbuTFHkQuAMAdj2qr8yPmNuPpUyGSLOCACMYpsKbsgU0gbGv KWQs+NxpIpGj24HynpTzhZSrdAafsDdACDUpK4+g1olcmbBDVDMjZUqxHPNWw3y4pnzBuAMGiyC7 3Ko3KxJyQR+VLGdkilQKsuQQvy4IHJ9aijUM23jI5BqtCS3Gy+YvTrU9yPlDCoLWLEm5hkd6vMiM pXGBU20GZe1Q3Qc0792o461M0DqegYetNMTAZK0lcCJCMkY5pcDHrUkULNk7sVL5AGMyE02tQIFV mOACPrVlYhGBnGTTo0WM5Bz9TRIVcgFsU0gAK2STjHal6U1pEiXk5pi3Mblh6CgBzcDjmnIpJHYV XN1uGEUcUxr9kYAr1ouBbmhEhyDg1B5C92NOa4yhKntVZ7hugcZ+lFgLf2dG+YmgwRBeCBVBbiUy kfMQPalmeQhdgJ55FHS4Wd7FsvAqHkEjg0yC4jMoUY6VTjjZ2w6lVJ5IqwLeKJlaIt1/ixQg9Cw9 zskIx0qP7bhTgDNQ3LEMykHnkVAzbtoIx70WYGh9pLYNIbp89T+dV4iCgqQOgGD1qbsYkUCvtYfe xRcIQAo+8OTz2pFwFHJ/CgozHIVjVJ9CSIRF2yWJI9TVkxqM8c4HNC27ddv51OYiQPpii7YFRoA3 O6hyXYhhxU/kMvzFhQ0KGfJYjjpRqNEce08Y6dqWVMopUkYOOaVUhWY/Nx9ala4gA29ce1FguVBE pbOcmoCrCQ4BxV83EPUAiqrTAyMQpINC2sACCWUAhelSCGQcEgAU43JjACYxUJunDEkAg+tKyQi0 tq2PvYp32ZcAlqoS3jK20yYJFNSckMN5PHrTGaDwxCMknnHrUUBiEnaqAn3DnPPrUYZoiSTnmlcL O9jceZE4zj6U9XBXPJ+lZjSK8aMTzjpVy3yVI/hxTEEl1g4UCq0t4zKQB0pkh2vipzYKqK5Y5Iz1 60LUZTW8lVfqanuJWeNGDckdB3pIYY5871ztNMmdUuEXGApBFJANiaVQ4fcPr60B2bjaxI6GrV9k xhlUls9qrW8x8plbqPWnYLodIZJYyq9c55piq0W0noeKRZtkmTnOMCmzTGTGTxT0ENBdc4c8mpkR JsM2SR71CHzhcL9aWOTy2YDBpOw+Z3uWxEGbYDgfWhoYoUwWye1VDOVc8mlLjbk5zQBrK8a2gKAE AfnVJJlEpJGA1MWSL7IUBO8jniq7glVPQ4496Yi5cSBIlIIzu6A0QP5jgY461nSK7DIDZHtVu2lU dAQ2Oc0AXjEhVmdzuP3c1UmjAIw4b1qUsRgMc0KAxxU37DepHEB5dV3Ylzwfyq4qbMqOlVpI3LnF JWvqM0ftMKjjH4VG18oHyrzms0StkZqwtq3lGXfnvinrcRZa+IH3aabpzEXB6U2G0W8ILNgJ2FIy LDMYBnaTjNNXB2ITcvLhd3H1pJJgmCS288YAqeS2gjUuGG4dMUQhQhlZvvUW6BcqAu+SoLE8gd6V UnQbpEKqfWrKSobhGB4HBzUl1MrlUBBB54pLcOhQld8jbnFSKwKcYDelJBLmQoV71ZNum7K8etNp DTZCScYNTx2cBj8wkknnrUXkhmOWI9MVI9r9lAxIXBHftRoK7II3jWYhkDEetLLEC+5FCjviqbSe XISOtSQyyEb2IZKEBfEcexTkHPp2qrOp+0bR6VJuIXI+tReYynft570ru4Mau5JMt09K1rU7o6zF LTcjHWr9mGUsp65p3uFmitdjEv402a5d4kjwSAMVPdx72OeKpBWYEIQcdc0gJo32sSmAPSorkmTL DnHU0sSHJV+abMq+YFAwfWl1AiiuHSUHrjtSqzNuyCAT0qOQqrBc5Y9SKkVWiYOxLJxwKoQSA7ht pHiYvtzjIzU6XMbFyyEDPy0KmW8xuAxwpFFxlTb8/wA7AY4pGcpgg9aSd1Usm0Mc5JHamCJ2hLY4 HSmKxI0hIznBp8fZ3YAds1AyNuXGSCO9S28Sv+7k4fOSSegoAneZiBzgHuPSmb3JUA5x0zSSTxx/ uYk3gNwxqOSWRBymM9KALLl/LYKQpx60RbkTIOfU1UVpDgbsjqfarAbcMJ0pMCQy4G4nipop02jD DJqq0JkGDxSw26xyZLDIpWVgNE4Me4Hk1AWlB4XI+tTJt8rAPFVCSDgGla5d7E00Y8wL/DU8cipE VI4FVfMIRixBxT7ZFkQu0gz/AHetPcXS46C68h2IGQ1Rz3PmS7sYpPLUYLEbs8jpgUkkQP8AqzwT yaPIVhrEupYHpSI2VORzTikofKqCuKdJGIF3Nlg654HSiwWKx3MpAB+oqe3WSI7hjkY59KYjZTYg YD3qchBH87lSOMetCvsDsN8vcd4bp1qU7sY3k49KgtywBCj5c1LhxISOh9KevUNOg1nKp84PsKY8 m5SCrAn+VWYkBmUPyRnGelTvEEQsWXpxzRYLmLJD8wLSEL605oEYfI3I6mrElsJACKDAqIeecdMU B5FZPO8wHJKj9attGZQACRnrirFvPHFEqmEEjvTXbc24cZo0toIiS3aEgA8VaVynKjJFQq46HJPa pocifYVNAx1wDuB9RVWMfM2AOe1XLoEhSPpVRYtr7magLiAKWyCd3f0psig/U8VLuU5C4qNlPJJw M5NT1CxWVI/N2lMsO5pdjbyQcKegqVmjXAPIzTSFVCSwz2qwGFVOwZ2hf1pXJ+VB0Yc571Imx3UF xx60SmJHIB3MvINICEQI4xtACnketSgRY4YBR1p0jIsZfH3hg1XjKbdjqEB6e9ADYdg3ZIIUnigQ CWTeTgY4yarbShIwducE+tWreYxrzHlCeMnmnYROESNMELkrniqckTybXdivYg1ZlHlzCUBTn+H1 pjS+c2GHTsO1AEjpGUVUAVscmmeXGp8reQ2M7gaWRt2cADjkZqJcuzByi7umByKBkwgBGAx3jqGq F0aF8E575pfNccbgwHGe9J5hZl+TOOvNAXLcbKEB5xUbE7jhQRUiqNpOMDGcVHmpGT+RHHcNC3zK eRmnSQBCCg2qOuKfL80vmYG4Uze7HnpQSQ+X52ccsDjJpxidI2VTwKmCL1qUKDGw9RTuOxBCwW2G 44qAFtg6uM8Va8lmQKFOB0pyQMicAChsEMVF2glcU14lJLYyamEUrBemO9S+QPWlqGhUjU7QcY45 FKhbA3cEdqs7FQ8mmKsZ6Y4pgQ7eSSc5OfpRgNwc1ZWSMc7QKa88fIHGKQXI1iIPCmnLETuUjkji ni7XsM1G12fMH8NGgCJayHIOBUq2hAAZqi+1sCRkA1H9sZpAm45Io0QWZYFuokI54qVQqt1GapPJ 5bBmJJNPiOTvU00waZZuPmh46ZrMaWRwAq57VrEeZERjqKoeSYWUc4J4HXFJgiqVuIDmRNueOTTx 5rDEmVU9yK0LlBJGPMIJAzx61QlR2RstjIz9KdkLUhePb94ge5pgIaMk/p2p5uSYP3uCM4GBUDOp bJbJ70wHsAwwM/X1p4UMQdp6cZqqZeRk5C+9TiYKud3Hv2oAJUYldzE46c1IzCVVDDdt7CoiHm5X gD1pPMKSFevckUASntgDB604jAAGD9KjT5nKq4HHAqFndXKsckdcUASySAFhnBx+VIPl6FScVFGA 6t1qeNFKjPbigAJ24JpsmAxPTPTNOkfDHK/IKjD7n+UZH0oAXyVIDZ4qeABQQFzn1pihkJ7g9qnj hJIYnAB5pATlPkxxnHNQO6o23jipGfL5zx3qs+1nJ55pFM1mjTB5/WmxmLZlsZ96oFzuK8lqR3ZV 96L3FZmn5sIOBj8BUcsoDYQc1mpIxYZzUspkLDYBjHJzQgsXo7nKnI6VA95wwGBmqyM8Z+YZz2FQ ZYSkgZAOQDTtcDQS42W6kscd+ajW6ZpR8xx9ajVjNGBgDn8KbKvlIWAGRSAnnmG/k9RTIpDg8jPa q6SechJBOKfC489VJ2g8dKdguL5sp6rjmrfktMkZRsMeoNOe1VGO+RR3+tRWsjBzIGyinoeposF9 biyW8lspkcggnGBUJjaYhiSo9KvXVyssBGzHcd6qLOo4PSk0CYsZUypGQCW4Jq42mxRgyE/N25rO YB8PECCB61KzyyqgmbO0cYpt2ESJCrKSxzntUbK0cgCD5D0xRHJIuVCZHvUjRkYZG3EjkHjFK4y7 DzEKqsTnBJq1C2VHA/CqsqkzEChghpxTJP8AVkbQSe9SFMdTTSm5TzilYDMaNpMrjCA96hOI2HJI J6etWihTeu4hvTrUeAGX5dxqxEByJQHG3PU04oYwMc5PUdDU8sRniDEfN2oikcLsfGB04oEIAcZy V45FQsnRs+3vU4BAbJ/Om5V0wB0657UDIGJQ7uVB9qnWJSglTk45B70KDLGNq5CnkGmrIQjDpg8C gQsQY8NThuEmMcYpIiACc856U4MCWbIz05oGP2ZzuOc+9AjMYGBwaIySM96Duc4JI+lAArhWKnqP frVhZdy4HTFQSJHGilgWz1xSwkYLKOBxzSGiSUbEY+1VdxPQHFWnO4d6ajoi7TnP0pDYEu0m4ADF Ql3MwJXKg80xJyU471IhGSZFbaPSquSTyyRbSAMH6U2OcheV+h9agWUrPkRhx0Aamo7MSu3kH8qA JZJCxznkU+KZCCHUfhUTQMV5YH2FNEAwuCfU5oWgMf54DFF4Umi5nV8BcgAc/WmmBRjk9akMSN95 RwPzoAgD4BI9O1MMnTrnPpVvyMRrtbil+zKdo3EH1xSArteu3JLEj1qzaIWjJ3lQT0qvbWzMz7j1 PerhKp7UNgglG1AN5I96rqqLMR2xUsjBsY59aTzEBzjmpuMsWygwl+g7UpbHaoUmDHaBgVLgEUmA pds8CnBXYc8CpYYcjc1NnnWNivXinbuBNENgQdd1RXA2zhj3ohuFlKAHDDsadeDhTT6AiM/MOtRk 44oVuOtNJO6gZWmTYxPOTUaHdzjGKtzjfH71UT5GNNEjWYxjIOAabuG7B9KbK25yoPPvTBu2hgQe aYiQOMck8dvWmhhk7ePbNRDfITnIHpT8OBgKcDvigBQWTJVsdutKMleTgjjPtUbAqDkhSeaEdtvX imBY2qArxnJA+YUxMBmaQHa3pSRtiPbjr0p3mjOCeB0ApDJS4A5pJQzsADtP86iaZQ3TPsacGMgx g+lAE2zemwEqO+acqRhjhjnONuOtQlGUDYT6YqykZYjdyQOtIEP28YHercQjaMEoM/SqyDLAdTUu cEgGkW0ZojjUgL1HJFPaQjoaiAYAZ5PcGnqQR71RBFliw7DJP1qQEDoSPYVEHQOQ2cnpSjdn7vGO tAiVuFJUZI96am7fuJwCOQe1JEoKDacEjk01twwOo7igY9SwkKg59SaawJTBPOaTzQq7SPcY6ikB Mg2qoJ75oAtW7naqnpVvcduOKoRblYK3arqnctQxoFjdj8oJ+lNktJWxn5frV6y+6w96mmXI9qEg MtdPORmT8hUg0+JfvMxqwi4YntVpbV5VBxwaoDLmt1ijDRIc5+tSpBMyg7cfWtMWLBT83asfLYwW JI45NTIC9JuijCnAOOazJASSTWky74lfknZVBgef0oYDLfKzofetC6XMec1RVSJA2eB2rRl+eDPq KEBTjAxmlwMU1D1p3TtTGIRlTkVQxh2BHetLIxjNVJkycAUCZVaH5tx4703YBjrkdcVMVYgCk2kH 5jimIYSVBHr1ppLOAo7DrVgxqf46auxPmL4NMCvFF8xEg+lOeFc4UZqYzKCSFBz3NIr7jt+XnqTS 1CxGqPsA7iiOI7GAX5j+lPkVsD5uBSK2BwDn19qYWGmIKADgnvTovY59TSx7mfcMDFTCEBsk0h2B OOtTxkluBTUQd+MVPEIyDzyD0ouNDPIyQS/NKYSCeKtBVB6fSn7QeQaVxtGLt6nnNJtx8x4xTx0z UTORkEZGM0ySOJAzHJ55x7UsiuQFJw3cjvUa/KNxYg9Me1SoAUIOTzwaZIhbCjOeOtIMFvc85qTy 2YAAgcYz61GV8knAJPb2oGBCiQFsAk5ye9TDDkjYqgng571Au0MhdPYe9TyBHkICMpx0oAaS4nwe h9KvRD5KrbSYsKRwM1bgU+SpNQykTQu0bHHepGuHCk8HsMiowMZNQS3CbtoPSkBMbiU/xY+grU06 QvbcnJBrBNwMcCtTRpxIkq9MHNNbiZq1z0qbZpV9HNdDuHrWDf7kv32qSHAPHSqktBE8HzW4/EVR +65zWjaxuLcllwM5GaiawkdiwZQp9TU9BlFydvvV+HL2o+lRvZRquXuF/CrFsiCHCPkCmgM7ac9a eMA880smBKVA59aMEEAkc+lAxr+1VZHIbBP5VcKHnJzVIlzO33QBzzQhETFx1B56Uoic8k84p7kj ZtbLHqPWpTMCo4IPTGOlUBUmRI9vJOevtTGUYJParoWNmC7dxAy3pUJVslMYI7EUCIygEYB4btg0 77MnlghsMeT9KVOeBgn196Vix6Jjjoe1ADUQF+DwOxNTuihGwwHHTHWoVQDJyd3p6U/g5OSQDzSA QjAIyBx6VNGxZOOcVG6KzY3ce/FEHTgnr2oGhyEb8k7uecVOmGcjrkjBp2AqkqoAz6U1ImDlwQDm pAkLsrbc5xUglGOuKQGM4bqTUuw/88xTLMoZx0qOaMKpY/rVgFF79KhYfaMqcBR60yLFSLJnXMZK sOM1O7nzQiJtGMsaf5J2CMtgL0NTQxLtw3J6ZoYrFdI9yYXJOc5qVYyy4I5zVhYo1z3p+1Cv3RSu NIpSR7oQD8oTvUkQWfHUEHGRVzylcDcM49aVYY1OQoBpXHYiNsQpweCOlTwwsYwoHSlzU9vkMaW4 CC0Z/lyFJpqaAm7c87E+gFXe4PvVvI9atJCuzPTRrReoZj7mmy2Zib/REVQfvHOKvtKg6sKhCkb2 ZhtfpTEU90kWUc5I680hKyAHGTT7lcTj/aWmBdqjrSYxLOeRi6OcgdKfcHdAR0xVe3+W7YepI/Sp bhiibfWpWwFVVVhzV6zA8tgPWqiYA6VbtGy7j1FCGU7rCTk0ADhutOv0/e1GDhRTAdnmq8sDSSZQ DA5NSu2BxTC5A60BYqlBj92xbavIPrSwFjkFwABlRjvQ6spcjGGOQQKSW3Xy1fcc9QDxTJEErMyR 5BByTgd6mXzJGYuAB0xUO1I03Pjee9SpOGUqnXsxHFAC7BGflAHoCOtN2b2L7jgHBA7U7JZS2ST2 NLu2Jyc7uo9KBkDKdj8YUcg+tRxhSjKzFcjn3Pared0RIHHTrVbyyWVT1JwPamImabYFY/MRwc+l KgQOSvA9zRJbZBIkXg49gaQjB2sQXIyeehpDRPuyvGMUK53deo7VD5gTg9fTHWgShlbHBpDJ4TiT jrmtENkVlQPjGTk5/OtNWXaOaTKMBmO7HOTU4Ax0G7FRYy24HipYdrMdxqySeM7oN3y8Hp3qR12k EkHI7VRYslxx09KnVyWIPUUmBJ0pA+DTSaTPOakCwslSKc/WqinJqZSc0MZZETH+HipYs7C2MkVL FzEPpVcSMhOKNhFkSZwM8+lKWJPJrLkkk83duznk4HSrqzdM/nVNW3EtSYipxzEpqq0ox1FKt0sa +W6sT19qLhYW64MbD6VCpJzuOAPSla6WUqmzAzxzUlupd3VkxxwaTY0iFBbi4D73JPbFSXMO9fl6 ioRazb/uYwepNWzvzgAY+tC1EZu1wcbTmrVtE8Y8xuM8YqYqepYfgKch4xnP1p8oXKuoL8yEelUc /KMVoX/+pDelZrHgHPWgYobPFNPWo9/NIXyevNFgCdWfA3YHaod/y4OcDpUuBK4DMQAOoqBlxcbc 5jB600IQsCp9RUauScDJB7CrDRJHG2ELEnGc9KJMRwqBHl+vB6UwIVc8qeB6GpopcqQ3QdsU1gXQ jBz64pkcZWLB+8T94c0tBFpGG4YAx9KV9quXbr/C1RrHIh4bdxyMU84ZF+U5B6GkA2Hf5TZO4E5x jvUchClRjkdSPWp95WMR78Ec8imAFs5B9M460xkLSbhzye2aRX2hSB16+9WCFjhw6jH60ieWkgLL jjjnPFITHwtvUDjOK04lVolJ61nbozL8gwuKvQH90MmpZaMpAuB0H1pwUZ2jr1zSA5GM8inYyB1z 61QhXGIwx4z0zSRyHbtb72aJSfLIwSegpsayFRuw3oBTAl3ZpmcnrSqyq43A8nGKeVXzc4KH9Kmw DASKmViSKaFGOB8/bNKDtPU5zRYC/E0hACnig9eabExHQ4pxBPNSMQqpPvSkcUuCOoxSUXATrUvm LtAKqSO5qBmxUfmc4oAsGRu20fQVbjncLkEciswNmrtucxCmhMkJJ70ZpaKoRBPIUx71CJ2yKsTx mQAVB5Hq1J3AmugJLYj1Gay5IXXAJHT1rWlGbYgelZjEhQXBz2NMCIxoE+ZsHvUXllScntketLvG Tljjpmh2kzhUBFMLjVQ7mZG4Xv60/bvGSwOD+VVt2wKg3fN0xUwGFCkkkde2aBDpIwYyQBke/WmR OGQ7kYEHnHcU8szDawwO1OEQKHOSByT6UgE+RXUj9DSKzAbcDBPXFPGQpWUggj5cdqRPulQCQO+K BhnZwPlYHB96l8oySdckcnBpYwrnainJHWnhUgAD/M7HseaAIHiOTn5/cdaUf6pUHGeuamTGflBG PXrSMVaRc9V96AITHuRht3DOMk0xYAjNI5wR0ANTtKmxyABk8YquNwjA3DcDkEjNICSNA2Gf5c9F qZVYDjOKgwNpkOfMNTpKoUZoKWxnkMo2kGpQ/wAgKiiimShswZhlc7Ryc9qZBcH5owhIxkEHFFFM RMzo+CeHPXvz6UuHdckj6HpRRQMaHbdt35A7UodmkAAO0HvRRSBGjH8w9Kk804C9hRRUFA0m4D0F RlwM0UUgIWYZPNJkdqKKoQm/tVu3lVVIZgKKKa3Am89PWnJMr5x2oopiIriUhcAEe9VPMJ6k0UVL GXojutsVnTrn5WB64G2iiqApjcx2qMFOcGnMNyNhcH29aKKYhoQ7R2OcU7zlEZbHK8YHaiigBBlw Gz17GrCqrqQxOfTNFFICNZAzFWORnPSlVASSj/KvAz3oopN2AkhkUEhSAfWmMQSWwSwHQUUUgQwF /KOODTxJGy5ILOD3oopoByymVmUL909TTmXID8ADqfSiikwIZJI5E2RruI5JHaol3kZooqkho//Z