FALSE 1.0 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/2.5.0'><FeatureDataset>Address</FeatureDataset><WorkspaceConnectionString>DATABASE=C:\Solutions\Tasks\January2020\Address Data Management.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>Site Address ID</rule_name><rule_type>CALCULATION</rule_type><expression>return "SID-" + NextSequenceValue("SiteAddressID");</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>siteaddid</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>Site Address ID</rule_name><evaluation_order>1</evaluation_order></ReorderAttributeRule></workflow></operationSequence>" 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/2.5.0'><FeatureDataset>Address</FeatureDataset><WorkspaceConnectionString>DATABASE=C:\Solutions\Tasks\January2020\Address Data Management.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>Full Address</rule_name><rule_type>CALCULATION</rule_type><expression>var fulladdr = null; var fields = [$feature.PREADDRNUM,$feature.ADDRNUM,$feature.ADDRNUMSUF,$feature.FULLNAME,$feature.UNITTYPE,$feature.UNITID,$feature.ALTUNITTYPE,$feature.ALTUNITID]; for(var i in fields) { var field = fields[i]; if (field == "" || field == null) continue; if (fulladdr == null) { fulladdr = field; continue; } fulladdr += " " + field; } return fulladdr;</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>fulladdr</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>Full Address</rule_name><evaluation_order>2</evaluation_order></ReorderAttributeRule></workflow></operationSequence>" 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/2.5.0'><FeatureDataset>Address</FeatureDataset><WorkspaceConnectionString>DATABASE=C:\Solutions\Tasks\January2020\Address Data Management.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><DisableAttributeRules><rule_name>Full Address</rule_name><rule_type>CALCULATION</rule_type></DisableAttributeRules></workflow></operationSequence>" CalculateField "Site Addresses\Addresses - Site Address Points" addrnum !fulladdr!.split(' ')[0] PYTHON3 # "Long (large integer)" CalculateField "Site Addresses\Addresses - Site Address Points" addrnum !fulladdr!.split(' ')[0] PYTHON3 # "Long (large integer)" CalculateField "Site Addresses\Addresses - Site Address Points" addrnum !fulladdr!.split(' ')[0] PYTHON3 # "Long (large integer)" 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/2.5.0'><FeatureDataset>Address</FeatureDataset><WorkspaceConnectionString>DATABASE=C:\Solutions\Tasks\January2020\Address Data Management\Address Data Management.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><EnableAttributeRules><rule_name>Full Address</rule_name><rule_type>CALCULATION</rule_type></EnableAttributeRules></workflow></operationSequence>" 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/2.5.0'><FeatureDataset>Address</FeatureDataset><WorkspaceConnectionString>DATABASE=C:\Solutions\Tasks\January2020\Address Data Management\Address Data Management.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Site Address ID</rule_name><severity>-1</severity><expression>// This rule will create a new unique id when a site address point is created return "SID-" + NextSequenceValue("SiteAddressID");</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update></AlterAttributeRule></workflow><workflow><AlterAttributeRule><rule_name>Full Address</rule_name><severity>-1</severity><expression>// This will calculate the full address for a site address point by concatenating several other field values // Specify the fields to concatenate var fulladdr = null; var addressValues = [$feature.PREADDRNUM,$feature.ADDRNUM,$feature.ADDRNUMSUF,$feature.FULLNAME,$feature.UNITTYPE,$feature.UNITID,$feature.ALTUNITTYPE,$feature.ALTUNITID]; // Loop through the field values and test if test if they are null or empty strings // If they are not null or empty add them to an array var concatValues = [] for(var i in addressValues) { var value = addressValues[i]; if (value == "" || value == null) continue; concatValues[Count(concatValues)] = value } // Return the field values concatenated with a space between return Concatenate(concatValues, " ");</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" 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/2.5.0'><FeatureDataset>Address</FeatureDataset><WorkspaceConnectionString>DATABASE=C:\Solutions\Tasks\January2020\Address Data Management\Address Data Management.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Site Address ID</rule_name><severity>-1</severity><expression>// This rule will create a new unique id when a site address point is created //Define the leading text, the trailing text and the delimiter for the ID var prefix = "SID" var join_char = "-" //Ensure the ID is not already set, if it is, return the original id if (IsEmpty($feature.siteaddid)) { // If you do not want to use a prefix, or suffix, remove it from the list return Concatenate([prefix, NextSequenceValue("SiteAddressID")], join_char) } else { return $feature.siteaddid }</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update></AlterAttributeRule></workflow><workflow><AlterAttributeRule><rule_name>Full Address</rule_name><severity>-1</severity><expression>// This will calculate the full address for a site address point by concatenating several other field values // Specify the fields to concatenate var values = [$feature.preaddrnum, $feature.addrnum, $feature.addrnumsuf, $feature.fullname, $feature.unittype, $feature.unitid, $feature.altunittype, $feature.altunitid]; var combined_value = []; // Loop through the field values and test if test if they are null or empty strings // If they are not null or empty add them to an array for (var i in values) { var value = values[i]; if (IsEmpty(value)) continue; combined_value[Count(combined_value)] = value } // Return the field values concatenated with a space between return Concatenate(combined_value, " ");</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" 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/2.5.0'><FeatureDataset>Address</FeatureDataset><WorkspaceConnectionString>DATABASE=C:\Users\scot6032\Documents\Demos and Prototypes\AddressDataManagement\Address Data Management.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>fullname</field_name><domain_name>RoadNameIndex</domain_name></AssignDomainToField></workflow></operationSequence> 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/2.5.0'><FeatureDataset>Address</FeatureDataset><WorkspaceConnectionString>DATABASE=C:\Users\scot6032\Documents\Demos and Prototypes\AddressDataManagement\Address Data Management.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><DisableAttributeRules><rule_name>Site Address ID</rule_name><rule_type>CALCULATION</rule_type></DisableAttributeRules></workflow><workflow><DisableAttributeRules><rule_name>Full Address</rule_name><rule_type>CALCULATION</rule_type></DisableAttributeRules></workflow></operationSequence>" CalculateField "Site Addresses" fullname !fullname!.replace("Trlee","Tree") PYTHON3 # Text CalculateField "Site Addresses" fulladdr !fulladdr!.replace("Trlee","Tree") PYTHON3 # Text 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/2.5.0'><FeatureDataset>Address</FeatureDataset><WorkspaceConnectionString>DATABASE=C:\Users\scot6032\Documents\Demos and Prototypes\AddressDataManagement\Address Data Management.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><EnableAttributeRules><rule_name>Site Address ID</rule_name><rule_type>CALCULATION</rule_type></EnableAttributeRules></workflow><workflow><EnableAttributeRules><rule_name>Full Address</rule_name><rule_type>CALCULATION</rule_type></EnableAttributeRules></workflow></operationSequence>" 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/2.5.0'><FeatureDataset>Address</FeatureDataset><WorkspaceConnectionString>DATABASE=C:\Users\scot6032\Documents\Demos and Prototypes\AddressDataManagement\Address Data Management.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><DisableAttributeRules><rule_name>Site Address ID</rule_name><rule_type>CALCULATION</rule_type></DisableAttributeRules></workflow><workflow><DisableAttributeRules><rule_name>Full Address</rule_name><rule_type>CALCULATION</rule_type></DisableAttributeRules></workflow></operationSequence>" CalculateField "Site Addresses" stateabbreviation "IL" PYTHON3 # Text CalculateField "Site Addresses" country "US" PYTHON3 # Text 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/2.5.0'><FeatureDataset>Address</FeatureDataset><WorkspaceConnectionString>DATABASE=C:\Users\scot6032\Documents\Demos and Prototypes\AddressDataManagement\Address Data Management.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><EnableAttributeRules><rule_name>Site Address ID</rule_name><rule_type>CALCULATION</rule_type></EnableAttributeRules></workflow><workflow><EnableAttributeRules><rule_name>Full Address</rule_name><rule_type>CALCULATION</rule_type></EnableAttributeRules></workflow></operationSequence>" Append 'Site Addresses' "Site Addresses (target)" "Use the Field Map to reconcile schema differences" "siteaddid "Site Address ID" true true false 20 Text 0 0,First,#,Site Addresses,siteaddid,0,20;addressptid "Address Point ID" true true false 20 Text 0 0,First,#,Site Addresses,addressptid,0,20;rclnguid "NENA Global ID" true true false 254 Text 0 0,First,#,Site Addresses,rclnguid,0,254;discrpagid "Discrepancy Agency ID" true true false 75 Text 0 0,First,#,Site Addresses,discrpagid,0,75;preaddrnum "Address Number Prefix" true true false 5 Text 0 0,First,#,Site Addresses,preaddrnum,0,5;addrnumsuf "Address Number Suffix" true true false 5 Text 0 0,First,#,Site Addresses,addrnumsuf,0,5;addrnum "Full Address Number" true true false 20 Text 0 0,First,#,Site Addresses,addrnum,0,20;addrrange "Address Range" true true false 50 Text 0 0,First,#,Site Addresses,addrrange,0,50;unittype "Address Unit Type" true true false 10 Text 0 0,First,#,Site Addresses,unittype,0,10;unitid "Address Unit Number" true true false 10 Text 0 0,First,#,Site Addresses,unitid,0,10;altunittype "Alternate Address Unit Type" true true false 10 Text 0 0,First,#,Site Addresses,altunittype,0,10;altunitid "Alternate Address Unit Number" true true false 10 Text 0 0,First,#,Site Addresses,altunitid,0,10;secondaltunittype "2nd Alternate Address Unit Type" true true false 10 Text 0 0,First,#,Site Addresses,secondaltunittype,0,10;secondaltunitid "2nd Alternate Address Unit Number" true true false 10 Text 0 0,First,#,Site Addresses,secondaltunitid,0,10;thirdaltunittype "3rd Alternate Address Unit Type" true true false 10 Text 0 0,First,#,Site Addresses,thirdaltunittype,0,10;thirdaltunitid "3rd Alternate Address Unit Number" true true false 10 Text 0 0,First,#,Site Addresses,thirdaltunitid,0,10;fourthaltunittype "4th Alternate Address Unit Type" true true false 10 Text 0 0,First,#,Site Addresses,fourthaltunittype,0,10;fourthaltunitid "4th Alternate Address Unit Number" true true false 10 Text 0 0,First,#,Site Addresses,fourthaltunitid,0,10;fullname "Full Road Name" true true false 300 Text 0 0,First,#,Site Addresses,fullname,0,300;fulladdr "Full Address" true true false 500 Text 0 0,First,#,Site Addresses,fulladdr,0,500;placename "Place Name" true true false 250 Text 0 0,First,#,Site Addresses,placename,0,250;country "Country Abbreviation" true true false 2 Text 0 0,First,#,Site Addresses,country,0,2;stateabbreviation "State Abbreviation" true true false 2 Text 0 0,First,#,Site Addresses,stateabbreviation,0,2;municipality "Municipality Name" true true false 100 Text 0 0,First,#,Site Addresses,municipality,0,100;esn "Emergency Service Number" true true false 5 Text 0 0,First,#,Site Addresses,esn,0,5;msag "MSAG Community" true true false 35 Text 0 0,First,#,Site Addresses,msag,0,35;usngcoord "USNG Coordinate" true true false 50 Text 0 0,First,#,Site Addresses,usngcoord,0,50;addrclass "Description" true true false 4 Long 0 0,First,#,Site Addresses,addrclass,-1,-1;pointtype "Location" true true false 30 Text 0 0,First,#,Site Addresses,pointtype,0,30;capturemeth "Capture Method" true true false 30 Text 0 0,First,#,Site Addresses,capturemeth,0,30;status "Status" true true false 30 Text 0 0,First,#,Site Addresses,status,0,30;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#,Site Addresses,GlobalID,-1,-1" # # ImportAttributeRules "C:\Solutions\Tasks\January2020\Address Data Management\Project\Address Data Management\Address Data Management Z.gdb\Address\SiteAddressPoint" "C:\Solutions\Tasks\January2020\Address Data Management\Project\Address Data Management\Rules\SiteAddresses.CSV" Append 'C:\Solutions\Tasks\January2020\Address Data Management\Sample Data\Address Data Management Sample.gdb\Address\SiteAddressPoint' "Site Addresses\Site Addresses" "Input schema must match target schema" # # # CalculateField "Site Addresses\Site Addresses" capturemeth "Plan or Drawing" "Python 3" # Text UpdateSchema "C:\Solutions\Tasks\January2020\Address Data Management\Sample Data\Address Data Management Sample.gdb\Address\SiteAddressPoint" "<operationSequence><workflow><AlterAttributeRule><rule_name>Full Address</rule_name><severity>-1</severity><expression>// This will calculate the full address for a site address point by concatenating several other field values // Specify the fields to concatenate var values = [$feature.preaddrnum, $feature.addrnum, $feature.addrnumsuf, $feature.fullname, $feature.unittype, $feature.unitid, $feature.altunittype, $feature.altunitid, $feature.secondaltunittype, $feature.secondaltunitid, $feature.thirdaltunittype, $feature.thirdaltunitid, $feature.fourthaltunittype, $feature.fourthaltunitid]; var combined_value = []; // Loop through the field values and test if they are null or empty strings // If they are not null or empty add them to an array for (var i in values) { var value = values[i]; if (IsEmpty(value)) continue; combined_value[Count(combined_value)] = value } // Return the field values concatenated with a space between return Concatenate(combined_value, " ");</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" 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/2.5.0'><FeatureDataset>Address</FeatureDataset><WorkspaceConnectionString>DATABASE=C:\Solutions\Tasks\January2020\Address Data Management\Data Reviewer\Address Data Management\Address Data Management Sample.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Site Address ID</rule_name><rule_description>This rule will create a new unique id when a site address point is created.</rule_description><severity>-1</severity><expression>// This rule will create a new unique id when a site address point is created // Define the leading text and the delimiter for the ID var prefix = "SID" var join_char = "-" //Ensure the ID is not already set, if it is, return the original id if (IsEmpty($feature.siteaddid)) { return Concatenate([prefix, NextSequenceValue("SiteAddressID")], join_char) } else { return $feature.siteaddid }</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" 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/2.5.0'><FeatureDataset>Address</FeatureDataset><WorkspaceConnectionString>DATABASE=C:\Solutions\Tasks\January2020\Address Data Management\Data Reviewer\Address Data Management\Address Data Management Sample.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Full Address</rule_name><rule_description>This will calculate the full address for a site address point by concatenating several other field values.</rule_description><severity>-1</severity><expression>// This will calculate the full address for a site address point by concatenating several other field values // Specify the fields to concatenate var values = [$feature.preaddrnum, $feature.addrnum, $feature.addrnumsuf, $feature.fullname, $feature.unittype, $feature.unitid, $feature.altunittype, $feature.altunitid, $feature.secondaltunittype, $feature.secondaltunitid, $feature.thirdaltunittype, $feature.thirdaltunitid, $feature.fourthaltunittype, $feature.fourthaltunitid]; var combined_value = []; // Loop through the field values and test if they are null or empty strings // If they are not null or empty add them to an array for (var i in values) { var value = values[i]; if (IsEmpty(value)) continue; combined_value[Count(combined_value)] = value } // Return the field values concatenated with a space between return Concatenate(combined_value, " ");</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" 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/2.5.0'><FeatureDataset>Address</FeatureDataset><WorkspaceConnectionString>DATABASE=C:\Solutions\Tasks\January2020\Address Data Management\Data Reviewer\Address Data Management\Address Data Management Sample.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Site Address ID</rule_name><rule_description>Creates a new unique id when a site address point is created.</rule_description><severity>-1</severity><expression>// This rule will create a new unique id when a site address point is created // Define the leading text and the delimiter for the ID var prefix = "SID" var join_char = "-" //Ensure the ID is not already set, if it is, return the original id if (IsEmpty($feature.siteaddid)) { return Concatenate([prefix, NextSequenceValue("SiteAddressID")], join_char) } else { return $feature.siteaddid }</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>False</triggering_events_update></AlterAttributeRule></workflow><workflow><AlterAttributeRule><rule_name>Full Address</rule_name><rule_description>Calculates the full address for a site address point by concatenating several other field values.</rule_description><severity>-1</severity><expression>// This will calculate the full address for a site address point by concatenating several other field values // Specify the fields to concatenate var values = [$feature.preaddrnum, $feature.addrnum, $feature.addrnumsuf, $feature.fullname, $feature.unittype, $feature.unitid, $feature.altunittype, $feature.altunitid, $feature.secondaltunittype, $feature.secondaltunitid, $feature.thirdaltunittype, $feature.thirdaltunitid, $feature.fourthaltunittype, $feature.fourthaltunitid]; var combined_value = []; // Loop through the field values and test if they are null or empty strings // If they are not null or empty add them to an array for (var i in values) { var value = values[i]; if (IsEmpty(value)) continue; combined_value[Count(combined_value)] = value } // Return the field values concatenated with a space between return Concatenate(combined_value, " ");</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" DeleteRows "C:\Solutions\Tasks\January2020\Address Data Management\Data Reviewer\Address Data Management\Address Data Management 2.gdb\Address\SiteAddressPoint" DefineProjection "C:\Users\efrank\Documents\Pasco_AddressDataManagement\Address Data Management\Address Data Management.gdb\SiteAddressPoint" PROJCS['NAD_1983_2011_StatePlane_Washington_South_FIPS_4602_Ft_US',GEOGCS['GCS_NAD_1983_2011',DATUM['D_NAD_1983_2011',SPHEROID['GRS_1980',6378137.0,298.257222101]],PRIMEM['Greenwich',0.0],UNIT['Degree',0.0174532925199433]],PROJECTION['Lambert_Conformal_Conic'],PARAMETER['False_Easting',1640416.666666667],PARAMETER['False_Northing',0.0],PARAMETER['Central_Meridian',-120.5],PARAMETER['Standard_Parallel_1',45.83333333333334],PARAMETER['Standard_Parallel_2',47.33333333333334],PARAMETER['Latitude_Of_Origin',45.33333333333334],UNIT['Foot_US',0.3048006096012192]] Append 'Site Address Points' "Site Addresses\Site Addresses" "Use the field map to reconcile field differences" "siteaddid "Site Address ID" true true false 20 Text 0 0,First,#,Site Address Points,SITEADDID,0,20;addressptid "Address Point ID" true true false 20 Text 0 0,First,#,Site Address Points,ADDPTKEY,0,20;rclnguid "NENA Global ID" true true false 254 Text 0 0,First,#;discrpagid "Discrepancy Agency ID" true true false 75 Text 0 0,First,#;preaddrnum "Address Number Prefix" true true false 5 Text 0 0,First,#,Site Address Points,PREADDRNUM,0,5;addrnumsuf "Address Number Suffix" true true false 5 Text 0 0,First,#,Site Address Points,ADDRNUMSUF,0,5;addrnum "Full Address Number" true true false 20 Text 0 0,First,#,Site Address Points,ADDRNUM,0,20;addrrange "Address Range" true true false 50 Text 0 0,First,#,Site Address Points,ADDRRANGE,0,50;unittype "Address Unit Type" true true false 10 Text 0 0,First,#,Site Address Points,UNITTYPE,0,10;unitid "Address Unit Number" true true false 10 Text 0 0,First,#,Site Address Points,UNITID,0,10;altunittype "Alternate Address Unit Type" true true false 10 Text 0 0,First,#,Site Address Points,ALTUNITTYPE,0,10;altunitid "Alternate Address Unit Number" true true false 10 Text 0 0,First,#,Site Address Points,ALTUNITID,0,10;secondaltunittype "2nd Alternate Address Unit Type" true true false 10 Text 0 0,First,#;secondaltunitid "2nd Alternate Address Unit Number" true true false 10 Text 0 0,First,#;thirdaltunittype "3rd Alternate Address Unit Type" true true false 10 Text 0 0,First,#;thirdaltunitid "3rd Alternate Address Unit Number" true true false 10 Text 0 0,First,#;fourthaltunittype "4th Alternate Address Unit Type" true true false 10 Text 0 0,First,#;fourthaltunitid "4th Alternate Address Unit Number" true true false 10 Text 0 0,First,#;fullname "Full Road Name" true true false 300 Text 0 0,First,#,Site Address Points,FULLNAME,0,125;fulladdr "Full Address" true true false 500 Text 0 0,First,#,Site Address Points,FULLADDR,0,250;placename "Place Name" true true false 250 Text 0 0,First,#,Site Address Points,PLACENAME,0,250;country "Country Abbreviation" true true false 2 Text 0 0,First,#;stateabbreviation "State Abbreviation" true true false 2 Text 0 0,First,#;municipality "Municipality Name" true true false 100 Text 0 0,First,#,Site Address Points,MUNICIPALITY,0,100;esn "Emergency Service Number" true true false 5 Text 0 0,First,#,Site Address Points,ESN,0,5;msag "MSAG Community" true true false 35 Text 0 0,First,#,Site Address Points,MSAG,0,35;usngcoord "USNG Coordinate" true true false 50 Text 0 0,First,#,Site Address Points,USNGCOORD,0,50;addrclass "Description" true true false 4 Long 0 0,First,#,Site Address Points,ADDRCLASS,-1,-1;pointtype "Location" true true false 30 Text 0 0,First,#,Site Address Points,POINTTYPE,0,30;capturemeth "Capture Method" true true false 30 Text 0 0,First,#,Site Address Points,CAPTUREMETH,0,30;status "Status" true true false 30 Text 0 0,First,#,Site Address Points,STATUS,0,30;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#" # # UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/2.9.0'><WorkspaceConnectionString>DATABASE=\\epsilon\GIS\GIS_Admin\Working\Pasco_AddressDataManagement\Pasco_AddressDataManagement\Address Data Management\Address Data Management.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><DisableAttributeRules><rule_name>Site Address ID</rule_name><rule_type>CALCULATION</rule_type></DisableAttributeRules></workflow><workflow><DisableAttributeRules><rule_name>Full Address</rule_name><rule_type>CALCULATION</rule_type></DisableAttributeRules></workflow></operationSequence>" Append 'Remove\Site Address Points' "Site Addresses\Site Addresses" "Use the field map to reconcile field differences" "siteaddid "Site Address ID" true true false 20 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,SITEADDID,0,20;addressptid "Address Point ID" true true false 20 Text 0 0,First,#,Remove\Site Address Points,ADDPTKEY,0,20;rclnguid "NENA Global ID" true true false 254 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,rclnguid,0,254;discrpagid "Discrepancy Agency ID" true true false 75 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,discrpagid,0,75;preaddrnum "Address Number Prefix" true true false 5 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,PREADDRNUM,0,5;addrnumsuf "Address Number Suffix" true true false 5 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,ADDRNUMSUF,0,5;addrnum "Full Address Number" true true false 20 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,ADDRNUM,0,20;addrrange "Address Range" true true false 50 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,ADDRRANGE,0,50;unittype "Address Unit Type" true true false 10 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,UNITTYPE,0,10;unitid "Address Unit Number" true true false 10 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,UNITID,0,10;altunittype "Alternate Address Unit Type" true true false 10 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,ALTUNITTYPE,0,10;altunitid "Alternate Address Unit Number" true true false 10 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,ALTUNITID,0,10;secondaltunittype "2nd Alternate Address Unit Type" true true false 10 Text 0 0,First,#;secondaltunitid "2nd Alternate Address Unit Number" true true false 10 Text 0 0,First,#;thirdaltunittype "3rd Alternate Address Unit Type" true true false 10 Text 0 0,First,#;thirdaltunitid "3rd Alternate Address Unit Number" true true false 10 Text 0 0,First,#;fourthaltunittype "4th Alternate Address Unit Type" true true false 10 Text 0 0,First,#;fourthaltunitid "4th Alternate Address Unit Number" true true false 10 Text 0 0,First,#;fullname "Full Road Name" true true false 300 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,FULLNAME,0,125;fulladdr "Full Address" true true false 500 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,FULLADDR,0,250;placename "Place Name" true true false 250 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,PLACENAME,0,250;country "Country Abbreviation" true true false 2 Text 0 0,First,#;stateabbreviation "State Abbreviation" true true false 2 Text 0 0,First,#;municipality "Municipality Name" true true false 100 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,MUNICIPALITY,0,100;esn "Emergency Service Number" true true false 5 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,ESN,0,5;msag "MSAG Community" true true false 35 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,MSAG,0,35;usngcoord "USNG Coordinate" true true false 50 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,USNGCOORD,0,50;addrclass "Description" true true false 4 Long 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,ADDRCLASS,-1,-1;pointtype "Location" true true false 30 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,POINTTYPE,0,30;capturemeth "Capture Method" true true false 30 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,CAPTUREMETH,0,30;status "Status" true true false 30 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,STATUS,0,30;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,GlobalID,-1,-1" # # RemoveIndex "\\epsilon\GIS\GIS_Admin\Working\Pasco_AddressDataManagement\Pasco_AddressDataManagement\Address Data Management\Address Data Management.gdb\SiteAddressPoint" FDO_GlobalID AddIndex "\\epsilon\GIS\GIS_Admin\Working\Pasco_AddressDataManagement\Pasco_AddressDataManagement\Address Data Management\Address Data Management.gdb\SiteAddressPoint" GlobalID GlobalID UNIQUE ASCENDING FeatureClassToFeatureClass "\\epsilon\GIS\GIS_Admin\Working\Pasco_AddressDataManagement\Pasco_AddressDataManagement\Address Data Management\Address Data Management.gdb\SiteAddressPoint" "\\epsilon\GIS\GIS_Admin\Working\Pasco_AddressDataManagement\Pasco_AddressDataManagement\Address Data Management\ARules_Admin.sde\ARules_Test.SDE.AddressDataManagement" SiteAddressPoint # "siteaddid "Site Address ID" true true false 20 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Working\Pasco_AddressDataManagement\Pasco_AddressDataManagement\Address Data Management\Address Data Management.gdb\SiteAddressPoint,siteaddid,0,20;addressptid "Address Point ID" true true false 20 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Working\Pasco_AddressDataManagement\Pasco_AddressDataManagement\Address Data Management\Address Data Management.gdb\SiteAddressPoint,addressptid,0,20;rclnguid "NENA Global ID" true true false 254 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Working\Pasco_AddressDataManagement\Pasco_AddressDataManagement\Address Data Management\Address Data Management.gdb\SiteAddressPoint,rclnguid,0,254;discrpagid "Discrepancy Agency ID" true true false 75 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Working\Pasco_AddressDataManagement\Pasco_AddressDataManagement\Address Data Management\Address Data Management.gdb\SiteAddressPoint,discrpagid,0,75;preaddrnum "Address Number Prefix" true true false 5 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Working\Pasco_AddressDataManagement\Pasco_AddressDataManagement\Address Data Management\Address Data Management.gdb\SiteAddressPoint,preaddrnum,0,5;addrnumsuf "Address Number Suffix" true true false 5 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Working\Pasco_AddressDataManagement\Pasco_AddressDataManagement\Address Data Management\Address Data Management.gdb\SiteAddressPoint,addrnumsuf,0,5;addrnum "Full Address Number" true true false 20 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Working\Pasco_AddressDataManagement\Pasco_AddressDataManagement\Address Data Management\Address Data Management.gdb\SiteAddressPoint,addrnum,0,20;addrrange "Address Range" true true false 50 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Working\Pasco_AddressDataManagement\Pasco_AddressDataManagement\Address Data Management\Address Data Management.gdb\SiteAddressPoint,addrrange,0,50;unittype "Address Unit Type" true true false 10 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Working\Pasco_AddressDataManagement\Pasco_AddressDataManagement\Address Data Management\Address Data Management.gdb\SiteAddressPoint,unittype,0,10;unitid "Address Unit Number" true true false 10 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Working\Pasco_AddressDataManagement\Pasco_AddressDataManagement\Address Data Management\Address Data Management.gdb\SiteAddressPoint,unitid,0,10;altunittype "Alternate Address Unit Type" true true false 10 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Working\Pasco_AddressDataManagement\Pasco_AddressDataManagement\Address Data Management\Address Data Management.gdb\SiteAddressPoint,altunittype,0,10;altunitid "Alternate Address Unit Number" true true false 10 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Working\Pasco_AddressDataManagement\Pasco_AddressDataManagement\Address Data Management\Address Data Management.gdb\SiteAddressPoint,altunitid,0,10;secondaltunittype "2nd Alternate Address Unit Type" true true false 10 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Working\Pasco_AddressDataManagement\Pasco_AddressDataManagement\Address Data Management\Address Data Management.gdb\SiteAddressPoint,secondaltunittype,0,10;secondaltunitid "2nd Alternate Address Unit Number" true true false 10 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Working\Pasco_AddressDataManagement\Pasco_AddressDataManagement\Address Data Management\Address Data Management.gdb\SiteAddressPoint,secondaltunitid,0,10;thirdaltunittype "3rd Alternate Address Unit Type" true true false 10 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Working\Pasco_AddressDataManagement\Pasco_AddressDataManagement\Address Data Management\Address Data Management.gdb\SiteAddressPoint,thirdaltunittype,0,10;thirdaltunitid "3rd Alternate Address Unit Number" true true false 10 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Working\Pasco_AddressDataManagement\Pasco_AddressDataManagement\Address Data Management\Address Data Management.gdb\SiteAddressPoint,thirdaltunitid,0,10;fourthaltunittype "4th Alternate Address Unit Type" true true false 10 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Working\Pasco_AddressDataManagement\Pasco_AddressDataManagement\Address Data Management\Address Data Management.gdb\SiteAddressPoint,fourthaltunittype,0,10;fourthaltunitid "4th Alternate Address Unit Number" true true false 10 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Working\Pasco_AddressDataManagement\Pasco_AddressDataManagement\Address Data Management\Address Data Management.gdb\SiteAddressPoint,fourthaltunitid,0,10;fullname "Full Road Name" true true false 300 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Working\Pasco_AddressDataManagement\Pasco_AddressDataManagement\Address Data Management\Address Data Management.gdb\SiteAddressPoint,fullname,0,300;fulladdr "Full Address" true true false 500 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Working\Pasco_AddressDataManagement\Pasco_AddressDataManagement\Address Data Management\Address Data Management.gdb\SiteAddressPoint,fulladdr,0,500;placename "Place Name" true true false 250 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Working\Pasco_AddressDataManagement\Pasco_AddressDataManagement\Address Data Management\Address Data Management.gdb\SiteAddressPoint,placename,0,250;country "Country Abbreviation" true true false 2 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Working\Pasco_AddressDataManagement\Pasco_AddressDataManagement\Address Data Management\Address Data Management.gdb\SiteAddressPoint,country,0,2;stateabbreviation "State Abbreviation" true true false 2 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Working\Pasco_AddressDataManagement\Pasco_AddressDataManagement\Address Data Management\Address Data Management.gdb\SiteAddressPoint,stateabbreviation,0,2;municipality "Municipality Name" true true false 100 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Working\Pasco_AddressDataManagement\Pasco_AddressDataManagement\Address Data Management\Address Data Management.gdb\SiteAddressPoint,municipality,0,100;esn "Emergency Service Number" true true false 5 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Working\Pasco_AddressDataManagement\Pasco_AddressDataManagement\Address Data Management\Address Data Management.gdb\SiteAddressPoint,esn,0,5;msag "MSAG Community" true true false 35 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Working\Pasco_AddressDataManagement\Pasco_AddressDataManagement\Address Data Management\Address Data Management.gdb\SiteAddressPoint,msag,0,35;usngcoord "USNG Coordinate" true true false 50 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Working\Pasco_AddressDataManagement\Pasco_AddressDataManagement\Address Data Management\Address Data Management.gdb\SiteAddressPoint,usngcoord,0,50;addrclass "Description" true true false 4 Long 0 0,First,#,\\epsilon\GIS\GIS_Admin\Working\Pasco_AddressDataManagement\Pasco_AddressDataManagement\Address Data Management\Address Data Management.gdb\SiteAddressPoint,addrclass,-1,-1;pointtype "Location" true true false 30 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Working\Pasco_AddressDataManagement\Pasco_AddressDataManagement\Address Data Management\Address Data Management.gdb\SiteAddressPoint,pointtype,0,30;capturemeth "Capture Method" true true false 30 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Working\Pasco_AddressDataManagement\Pasco_AddressDataManagement\Address Data Management\Address Data Management.gdb\SiteAddressPoint,capturemeth,0,30;status "Status" true true false 30 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Working\Pasco_AddressDataManagement\Pasco_AddressDataManagement\Address Data Management\Address Data Management.gdb\SiteAddressPoint,status,0,30;created_user "created_user" false true false 255 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Working\Pasco_AddressDataManagement\Pasco_AddressDataManagement\Address Data Management\Address Data Management.gdb\SiteAddressPoint,created_user,0,255;created_date "created_date" false true false 8 Date 0 0,First,#,\\epsilon\GIS\GIS_Admin\Working\Pasco_AddressDataManagement\Pasco_AddressDataManagement\Address Data Management\Address Data Management.gdb\SiteAddressPoint,created_date,-1,-1;last_edited_user "last_edited_user" false true false 255 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Working\Pasco_AddressDataManagement\Pasco_AddressDataManagement\Address Data Management\Address Data Management.gdb\SiteAddressPoint,last_edited_user,0,255;last_edited_date "last_edited_date" false true false 8 Date 0 0,First,#,\\epsilon\GIS\GIS_Admin\Working\Pasco_AddressDataManagement\Pasco_AddressDataManagement\Address Data Management\Address Data Management.gdb\SiteAddressPoint,last_edited_date,-1,-1" # 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/2.9.0'><FeatureDataset>ARules_Test.SDE.AddressDataManagement</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e687059416465416a2f736331796f6f4331524c4d3259654a4a75643268386637346b544e6b743633475031773d2a00;SERVER=gisdb;INSTANCE=sde:sqlserver:gisdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gisdb;DATABASE=ARules_Test;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ARules_Test.SDE.SiteAddressPoint</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>" Append \\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint "\\epsilon\GIS\GIS_Admin\Working\Pasco_AddressDataManagement\Pasco_AddressDataManagement\Address Data Management\ARules_Admin.sde\ARules_Test.SDE.AddressDataManagement\ARules_Test.SDE.SiteAddressPoint" "Use the field map to reconcile field differences" "siteaddid "Site Address ID" true true false 20 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,SITEADDID,0,20;addressptid "Address Point ID" true true false 20 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,ADDPTKEY,0,20;rclnguid "NENA Global ID" true true false 254 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,rclnguid,0,254;discrpagid "Discrepancy Agency ID" true true false 75 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,discrpagid,0,75;preaddrnum "Address Number Prefix" true true false 5 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,PREADDRNUM,0,5;addrnumsuf "Address Number Suffix" true true false 5 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,ADDRNUMSUF,0,5;addrnum "Full Address Number" true true false 20 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,ADDRNUM,0,20;addrrange "Address Range" true true false 50 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,ADDRRANGE,0,50;unittype "Address Unit Type" true true false 10 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,UNITTYPE,0,10;unitid "Address Unit Number" true true false 10 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,UNITID,0,10;altunittype "Alternate Address Unit Type" true true false 10 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,ALTUNITTYPE,0,10;altunitid "Alternate Address Unit Number" true true false 10 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,ALTUNITID,0,10;secondaltunittype "2nd Alternate Address Unit Type" true true false 10 Text 0 0,First,#;secondaltunitid "2nd Alternate Address Unit Number" true true false 10 Text 0 0,First,#;thirdaltunittype "3rd Alternate Address Unit Type" true true false 10 Text 0 0,First,#;thirdaltunitid "3rd Alternate Address Unit Number" true true false 10 Text 0 0,First,#;fourthaltunittype "4th Alternate Address Unit Type" true true false 10 Text 0 0,First,#;fourthaltunitid "4th Alternate Address Unit Number" true true false 10 Text 0 0,First,#;fullname "Full Road Name" true true false 300 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,FULLNAME,0,125;fulladdr "Full Address" true true false 500 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,FULLADDR,0,250;placename "Place Name" true true false 250 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,PLACENAME,0,250;country "Country Abbreviation" true true false 2 Text 0 0,First,#;stateabbreviation "State Abbreviation" true true false 2 Text 0 0,First,#;municipality "Municipality Name" true true false 100 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,MUNICIPALITY,0,100;esn "Emergency Service Number" true true false 5 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,ESN,0,5;msag "MSAG Community" true true false 35 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,MSAG,0,35;usngcoord "USNG Coordinate" true true false 50 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,USNGCOORD,0,50;addrclass "Description" true true false 4 Long 0 10,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,ADDRCLASS,-1,-1;pointtype "Location" true true false 30 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,POINTTYPE,0,30;capturemeth "Capture Method" true true false 30 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,CAPTUREMETH,0,30;status "Status" true true false 30 Text 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,STATUS,0,30;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#,\\epsilon\GIS\GIS_Admin\Database_Connections\COP_Admin.sde\COP.SDE.Address\COP.SDE.SiteAddressPoint,GlobalID,-1,-1" # # 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/2.9.0'><FeatureDataset>ARules_Test.SDE.AddressDataManagement</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68472f5769577655565262504a61385a7a306d61516f537452526359574f59754152436b353462386b306f673d2a00;SERVER=gisdb;INSTANCE=sde:sqlserver:gisdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gisdb;DATABASE=ARules_Test;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ARules_Test.SDE.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>Site Address ID</rule_name><rule_type>CALCULATION</rule_type><expression>// This rule will create a new unique id when a site address point is created // Define the leading text and the delimiter for the ID var prefix = "SID" var join_char = "-" //Ensure the ID is not already set, if it is, return the original id if (IsEmpty($feature.siteaddid)) { return Concatenate([prefix, NextSequenceValue("SiteAddressID")], join_char) } else { return $feature.siteaddid }</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>Creates a new unique id when a site address point is created.</rule_description><field_name>siteaddid</field_name><exclude_from_client_eval>True</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>Site Address ID</rule_name><evaluation_order>1</evaluation_order></ReorderAttributeRule></workflow></operationSequence>" 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/2.9.0'><FeatureDataset>ARules_Test.SDE.AddressDataManagement</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68472f5769577655565262504a61385a7a306d61516f537452526359574f59754152436b353462386b306f673d2a00;SERVER=gisdb;INSTANCE=sde:sqlserver:gisdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gisdb;DATABASE=ARules_Test;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ARules_Test.SDE.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>Full Address</rule_name><rule_type>CALCULATION</rule_type><expression>// This will calculate the full address for a site address point by concatenating several other field values // Specify the fields to concatenate var values = [$feature.preaddrnum, $feature.addrnum, $feature.addrnumsuf, $feature.fullname, $feature.unittype, $feature.unitid, $feature.altunittype, $feature.altunitid, $feature.secondaltunittype, $feature.secondaltunitid, $feature.thirdaltunittype, $feature.thirdaltunitid, $feature.fourthaltunittype, $feature.fourthaltunitid]; var combined_value = []; // Loop through the field values and test if they are null or empty strings // If they are not null or empty add them to an array for (var i in values) { var value = values[i]; if (IsEmpty(value)) continue; combined_value[Count(combined_value)] = value } // Return the field values concatenated with a space between return Concatenate(combined_value, " ");</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><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>Full Address</rule_name><evaluation_order>2</evaluation_order></ReorderAttributeRule></workflow></operationSequence>" 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/2.9.0'><FeatureDataset>ARules_Test.SDE.AddressDataManagement</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68472f5769577655565262504a61385a7a306d61516f537452526359574f59754152436b353462386b306f673d2a00;SERVER=gisdb;INSTANCE=sde:sqlserver:gisdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gisdb;DATABASE=ARules_Test;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ARules_Test.SDE.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><DeleteAttributeRule><rule_name>Full Address</rule_name><rule_type>CALCULATION</rule_type></DeleteAttributeRule></workflow></operationSequence>" 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/2.9.0'><FeatureDataset>ARules_Test.SDE.AddressDataManagement</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e68472f5769577655565262504a61385a7a306d61516f537452526359574f59754152436b353462386b306f673d2a00;SERVER=gisdb;INSTANCE=sde:sqlserver:gisdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gisdb;DATABASE=ARules_Test;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ARules_Test.SDE.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>Full Address</rule_name><rule_type>CALCULATION</rule_type><expression>// This will calculate the full address for a site address point by concatenating several other field values // Specify the fields to concatenate var values = [$feature.preaddrnum, $feature.addrnum, $feature.addrnumsuf, $feature.fullname, $feature.unittype, $feature.unitid, $feature.altunittype, $feature.altunitid, $feature.secondaltunittype, $feature.secondaltunitid, $feature.thirdaltunittype, $feature.thirdaltunitid, $feature.fourthaltunittype, $feature.fourthaltunitid]; var combined_value = []; // Loop through the field values and test if they are null or empty strings // If they are not null or empty add them to an array for (var i in values) { var value = values[i]; if (IsEmpty(value)) continue; combined_value[Count(combined_value)] = value } // Return the field values concatenated with a space between return Concatenate(combined_value, " ");</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>Calculates the full address for a site address point by concatenating several other field values.</rule_description><field_name>fulladdr</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>Full Address</rule_name><evaluation_order>2</evaluation_order></ReorderAttributeRule></workflow></operationSequence>" DeleteRows "Site Addresses_Scratch" 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>ENCRYPTED_PASSWORD=00022e687059416465416a2f736331796f6f4331524c4d3259654a4a75643268386637346b544e6b743633475031773d2a00;SERVER=gisdb;INSTANCE=sde:sqlserver:gisdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gisdb;DATABASE=ARules_Test;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ARules_Test.SDE.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AssignDefaultToField><field_name>country</field_name><clear_value>True</clear_value></AssignDefaultToField></workflow><workflow><AssignDefaultToField><field_name>stateabbreviation</field_name><default_value>WA</default_value></AssignDefaultToField></workflow><workflow><AssignDefaultToField><field_name>municipality</field_name><default_value>Pasco</default_value></AssignDefaultToField></workflow><workflow><AssignDefaultToField><field_name>capturemeth</field_name><default_value>Plan or Drawing</default_value></AssignDefaultToField></workflow><workflow><AssignDefaultToField><field_name>status</field_name><default_value>Pending</default_value></AssignDefaultToField></workflow></operationSequence>" CalculateField "ARules_Site Addresses\Site Addresses" status "Current" "Python 3" # Text NO_ENFORCE_DOMAINS UpdateSchema "ARules_Site Addresses\Site Addresses" "<operationSequence><workflow><DisableAttributeRules><rule_name>Site Address ID</rule_name><rule_type>CALCULATION</rule_type></DisableAttributeRules></workflow><workflow><DisableAttributeRules><rule_name>Full Address</rule_name><rule_type>CALCULATION</rule_type></DisableAttributeRules></workflow></operationSequence>" CalculateField "ARules_Site Addresses\Site Addresses" addrrange "1101-9308" "Python 3" # Text NO_ENFORCE_DOMAINS UpdateSchema "ARules_Site Addresses\Site Addresses" "<operationSequence><workflow><EnableAttributeRules><rule_name>Site Address ID</rule_name><rule_type>CALCULATION</rule_type></EnableAttributeRules></workflow><workflow><EnableAttributeRules><rule_name>Full Address</rule_name><rule_type>CALCULATION</rule_type></EnableAttributeRules></workflow></operationSequence>" CalculateField "ARules_Site Addresses\Site Addresses" country "US" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "ARules_Site Addresses\Site Addresses" stateabbreviation "WA" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "ARules_Site Addresses\Site Addresses" pointtype "Unit, Condo, Office or Suite" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "ARules_Site Addresses\Site Addresses" municipality "Pasco" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "ARules_Site Addresses\Site Addresses" pointtype "Building" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField "ARules_Site Addresses\Site Addresses" pointtype "Building" "Python 3" # Text NO_ENFORCE_DOMAINS UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e687059416465416a2f736331796f6f4331524c4d3259654a4a75643268386637346b544e6b743633475031773d2a00;SERVER=gisdb;INSTANCE=sde:sqlserver:gisdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gisdb;DATABASE=ARules_Test;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ARules_Test.SDE.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Unittypefixed</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>YesNo</field_domain><field_default_value>No</field_default_value></AddField></workflow></operationSequence> UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e687059416465416a2f736331796f6f4331524c4d3259654a4a75643268386637346b544e6b743633475031773d2a00;SERVER=gisdb;INSTANCE=sde:sqlserver:gisdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gisdb;DATABASE=ARules_Test;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ARules_Test.SDE.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>Unittypefixed</field_name></DeleteField></workflow></operationSequence> UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e687059416465416a2f736331796f6f4331524c4d3259654a4a75643268386637346b544e6b743633475031773d2a00;SERVER=gisdb;INSTANCE=sde:sqlserver:gisdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gisdb;DATABASE=ARules_Test;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ARules_Test.SDE.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>Unittypefixed</field_name></DeleteField></workflow></operationSequence> UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e687059416465416a2f736331796f6f4331524c4d3259654a4a75643268386637346b544e6b743633475031773d2a00;SERVER=gisdb;INSTANCE=sde:sqlserver:gisdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gisdb;DATABASE=ARules_Test;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ARules_Test.SDE.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><DeleteField><field_name>Unittypefixed</field_name></DeleteField></workflow><workflow><DisableAttributeRules><rule_name>Site Address ID</rule_name><rule_type>CALCULATION</rule_type></DisableAttributeRules></workflow><workflow><DisableAttributeRules><rule_name>Full Address</rule_name><rule_type>CALCULATION</rule_type></DisableAttributeRules></workflow></operationSequence>" UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e687059416465416a2f736331796f6f4331524c4d3259654a4a75643268386637346b544e6b743633475031773d2a00;SERVER=gisdb;INSTANCE=sde:sqlserver:gisdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gisdb;DATABASE=ARules_Test;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ARules_Test.SDE.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>Unittypefixed</field_name></DeleteField></workflow></operationSequence> UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD=00022e687059416465416a2f736331796f6f4331524c4d3259654a4a75643268386637346b544e6b743633475031773d2a00;SERVER=gisdb;INSTANCE=sde:sqlserver:gisdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gisdb;DATABASE=ARules_Test;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>ARules_Test.SDE.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><DisableAttributeRules><rule_name>Site Address ID</rule_name><rule_type>CALCULATION</rule_type></DisableAttributeRules></workflow><workflow><DisableAttributeRules><rule_name>Full Address</rule_name><rule_type>CALCULATION</rule_type></DisableAttributeRules></workflow></operationSequence>" DeleteField "ARules_Site Addresses\Site Addresses" Unittypefixed "Delete Fields" ExportFeatures "ARules_Site Addresses\Site Addresses" \\Epsilon\GIS\Standards\_Connections\gisdb(ADM).sde\COP.SDE.Address\COP.SDE.SiteAddressPoint # NOT_USE_ALIAS "siteaddid "Site Address ID" true true false 20 Text 0 0,First,#,ARules_Site Addresses\Site Addresses,siteaddid,0,20;addressptid "Address Point ID" true true false 20 Text 0 0,First,#,ARules_Site Addresses\Site Addresses,addressptid,0,20;preaddrnum "Address Number Prefix" true true false 5 Text 0 0,First,#,ARules_Site Addresses\Site Addresses,preaddrnum,0,5;addrnumsuf "Address Number Suffix" true true false 5 Text 0 0,First,#,ARules_Site Addresses\Site Addresses,addrnumsuf,0,5;addrnum "Full Address Number" true true false 20 Text 0 0,First,#,ARules_Site Addresses\Site Addresses,addrnum,0,20;addrrange "Address Range" true true false 50 Text 0 0,First,#,ARules_Site Addresses\Site Addresses,addrrange,0,50;unittype "Address Unit Type" true true false 10 Text 0 0,First,#,ARules_Site Addresses\Site Addresses,unittype,0,10;unitid "Address Unit Number" true true false 10 Text 0 0,First,#,ARules_Site Addresses\Site Addresses,unitid,0,10;fullname "Full Road Name" true true false 300 Text 0 0,First,#,ARules_Site Addresses\Site Addresses,fullname,0,300;fulladdr "Full Address" true true false 500 Text 0 0,First,#,ARules_Site Addresses\Site Addresses,fulladdr,0,500;placename "Place Name" true true false 250 Text 0 0,First,#,ARules_Site Addresses\Site Addresses,placename,0,250;country "Country Abbreviation" true true false 2 Text 0 0,First,#,ARules_Site Addresses\Site Addresses,country,0,2;stateabbreviation "State Abbreviation" true true false 2 Text 0 0,First,#,ARules_Site Addresses\Site Addresses,stateabbreviation,0,2;municipality "Municipality Name" true true false 100 Text 0 0,First,#,ARules_Site Addresses\Site Addresses,municipality,0,100;pointtype "Location" true true false 30 Text 0 0,First,#,ARules_Site Addresses\Site Addresses,pointtype,0,30;capturemeth "Capture Method" true true false 30 Text 0 0,First,#,ARules_Site Addresses\Site Addresses,capturemeth,0,30;status "Status" true true false 30 Text 0 0,First,#,ARules_Site Addresses\Site Addresses,status,0,30;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#,ARules_Site Addresses\Site Addresses,GlobalID,-1,-1;created_date "created_date" false true false 8 Date 0 0,First,#,ARules_Site Addresses\Site Addresses,created_date,-1,-1;last_edited_date "last_edited_date" false true false 8 Date 0 0,First,#,ARules_Site Addresses\Site Addresses,last_edited_date,-1,-1" # UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><FeatureDataset>COP.SDE.Address</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e684b305a6370376b66532b79543939777950346b466c7350456335586f3574504f754b43447a4d2f37624d453d2a00;ENCRYPTED_PASSWORD=00022e6879774c4a6e6c5063347433534a7970317841434b55463555703864427646434c79517471736c66656f6e383d2a00;SERVER=gisdb;INSTANCE=sde:sqlserver:gisdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gisdb;DATABASE=COP;USER=sde;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>COP.SDE.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>fullname</field_name><domain_name>RoadNameIndex</domain_name></AssignDomainToField></workflow></operationSequence> ExportFeatures "Site Addresses" "\\GSdatastore\GIS\GIS Projects\Dept CED Planning\Addressing\Addressing.gdb\SiteAddressPoint" # NOT_USE_ALIAS "siteaddid "Site Address ID" true true false 20 Text 0 0,First,#,Site Addresses,siteaddid,0,20;addressptid "Address Point ID" true true false 20 Text 0 0,First,#,Site Addresses,addressptid,0,20;preaddrnum "Address Number Prefix" true true false 5 Text 0 0,First,#,Site Addresses,preaddrnum,0,5;addrnumsuf "Address Number Suffix" true true false 5 Text 0 0,First,#,Site Addresses,addrnumsuf,0,5;addrnum "Full Address Number" true true false 20 Text 0 0,First,#,Site Addresses,addrnum,0,20;addrrange "Address Range" true true false 50 Text 0 0,First,#,Site Addresses,addrrange,0,50;unittype "Address Unit Type" true true false 10 Text 0 0,First,#,Site Addresses,unittype,0,10;unitid "Address Unit Number" true true false 10 Text 0 0,First,#,Site Addresses,unitid,0,10;fullname "Full Road Name" true true false 300 Text 0 0,First,#,Site Addresses,fullname,0,300;fulladdr "Full Address" true true false 500 Text 0 0,First,#,Site Addresses,fulladdr,0,500;placename "Place Name" true true false 250 Text 0 0,First,#,Site Addresses,placename,0,250;country "Country Abbreviation" true true false 2 Text 0 0,First,#,Site Addresses,country,0,2;stateabbreviation "State Abbreviation" true true false 2 Text 0 0,First,#,Site Addresses,stateabbreviation,0,2;municipality "Municipality Name" true true false 100 Text 0 0,First,#,Site Addresses,municipality,0,100;pointtype "Location" true true false 30 Text 0 0,First,#,Site Addresses,pointtype,0,30;capturemeth "Capture Method" true true false 30 Text 0 0,First,#,Site Addresses,capturemeth,0,30;status "Status" true true false 30 Text 0 0,First,#,Site Addresses,status,0,30;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#,Site Addresses,GlobalID,-1,-1;created_date "created_date" true true false 8 Date 0 0,First,#,Site Addresses,created_date,-1,-1;last_edited_date "last_edited_date" true true false 8 Date 0 0,First,#,Site Addresses,last_edited_date,-1,-1" # ExportFeatures SiteAddressPoint \\GSdatastore\GIS\DatabaseConnections\SA\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint # NOT_USE_ALIAS "siteaddid "Site Address ID" true true false 20 Text 0 0,First,#,SiteAddressPoint,siteaddid,0,20;addressptid "Address Point ID" true true false 20 Text 0 0,First,#,SiteAddressPoint,addressptid,0,20;preaddrnum "Address Number Prefix" true true false 5 Text 0 0,First,#,SiteAddressPoint,preaddrnum,0,5;addrnumsuf "Address Number Suffix" true true false 5 Text 0 0,First,#,SiteAddressPoint,addrnumsuf,0,5;addrnum "Full Address Number" true true false 20 Text 0 0,First,#,SiteAddressPoint,addrnum,0,20;addrrange "Address Range" true true false 50 Text 0 0,First,#,SiteAddressPoint,addrrange,0,50;unittype "Address Unit Type" true true false 10 Text 0 0,First,#,SiteAddressPoint,unittype,0,10;unitid "Address Unit Number" true true false 10 Text 0 0,First,#,SiteAddressPoint,unitid,0,10;fullname "Full Road Name" true true false 300 Text 0 0,First,#,SiteAddressPoint,fullname,0,300;fulladdr "Full Address" true true false 500 Text 0 0,First,#,SiteAddressPoint,fulladdr,0,500;placename "Place Name" true true false 250 Text 0 0,First,#,SiteAddressPoint,placename,0,250;country "Country Abbreviation" true true false 2 Text 0 0,First,#,SiteAddressPoint,country,0,2;stateabbreviation "State Abbreviation" true true false 2 Text 0 0,First,#,SiteAddressPoint,stateabbreviation,0,2;municipality "Municipality Name" true true false 100 Text 0 0,First,#,SiteAddressPoint,municipality,0,100;pointtype "Location" true true false 30 Text 0 0,First,#,SiteAddressPoint,pointtype,0,30;capturemeth "Capture Method" true true false 30 Text 0 0,First,#,SiteAddressPoint,capturemeth,0,30;status "Status" true true false 30 Text 0 0,First,#,SiteAddressPoint,status,0,30;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#,SiteAddressPoint,GlobalID,-1,-1;created_date "created_date" true true false 8 Date 0 0,First,#,SiteAddressPoint,created_date,-1,-1;last_edited_date "last_edited_date" true true false 8 Date 0 0,First,#,SiteAddressPoint,last_edited_date,-1,-1" # UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e685477483677735959695338526d332f6b6d616667654473566966456b6b70344d6a716b4879384f434f48593d2a00;ENCRYPTED_PASSWORD=00022e683973544f44476562713272654a426644595466394b496642307077656b314a794267592f705a75794d67413d2a00;SERVER=gsdb;INSTANCE=sde:sqlserver:gsdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gsdb;DATABASE=Planning;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>Full Address</rule_name><rule_type>CALCULATION</rule_type><expression>// This will calculate the full address for a site address point by concatenating several other field values // Define the full address field var fulladdr_field = "fulladdr"; If (!HasKey($feature, fulladdr_field)) return; // Define the fields to concatenate var values = [$feature.addrnum, $feature.]; var combined_value = []; // Loop through the field values and test if they are null or empty strings // If they are not null or empty add them to an array for (var i in values) { var value = values[i]; if (IsEmpty(value)) continue; combined_value[Count(combined_value)] = value } // Return the field values concatenated with a space between return { "result": { "attributes": Dictionary(fulladdr_field, Concatenate(combined_value, " ")) } }</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>Calculates the full address for a site address point by concatenating several other field values</rule_description><field_name>fulladdr</field_name><exclude_from_client_eval>True</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><DisableAttributeRules><rule_name>Full Address</rule_name><rule_type>CALCULATION</rule_type></DisableAttributeRules><ReorderAttributeRule><rule_name>Full Address</rule_name><evaluation_order>2</evaluation_order></ReorderAttributeRule></workflow></operationSequence>" UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e685477483677735959695338526d332f6b6d616667654473566966456b6b70344d6a716b4879384f434f48593d2a00;ENCRYPTED_PASSWORD=00022e683973544f44476562713272654a426644595466394b496642307077656b314a794267592f705a75794d67413d2a00;SERVER=gsdb;INSTANCE=sde:sqlserver:gsdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gsdb;DATABASE=Planning;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>Full Address</rule_name><rule_type>CALCULATION</rule_type><expression>// This will calculate the full address for a site address point by concatenating several other field values // Define the full address field var fulladdr_field = "fulladdr"; If (!HasKey($feature, fulladdr_field)) return; // Define the fields to concatenate var values = [$feature.addrnum, $feature.fullname]; var combined_value = []; // Loop through the field values and test if they are null or empty strings // If they are not null or empty add them to an array for (var i in values) { var value = values[i]; if (IsEmpty(value)) continue; combined_value[Count(combined_value)] = value } // Return the field values concatenated with a space between return { "result": { "attributes": Dictionary(fulladdr_field, Concatenate(combined_value, " ")) } }</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>Calculates the full address for a site address point by concatenating several other field values</rule_description><field_name>fulladdr</field_name><exclude_from_client_eval>True</exclude_from_client_eval><batch>False</batch><severity>-1</severity><category>-1</category></AddAttributeRule><DisableAttributeRules><rule_name>Full Address</rule_name><rule_type>CALCULATION</rule_type></DisableAttributeRules><ReorderAttributeRule><rule_name>Full Address</rule_name><evaluation_order>2</evaluation_order></ReorderAttributeRule></workflow></operationSequence>" UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e685477483677735959695338526d332f6b6d616667654473566966456b6b70344d6a716b4879384f434f48593d2a00;ENCRYPTED_PASSWORD=00022e683973544f44476562713272654a426644595466394b496642307077656b314a794267592f705a75794d67413d2a00;SERVER=gsdb;INSTANCE=sde:sqlserver:gsdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gsdb;DATABASE=Planning;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AlterField><field_name>fullname</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>fulladdr</field_name><field_type>TEXT</field_type><field_length>50</field_length><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AlterField><field_name>placename</field_name><field_type>TEXT</field_type><field_length>100</field_length><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AssignDefaultToField><field_name>country</field_name><default_value>US</default_value></AssignDefaultToField></workflow><workflow><AlterField><field_name>municipality</field_name><new_field_name>CityName</new_field_name><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AddField><field_name>ZIP</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>10</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_default_value>99301</field_default_value></AddField></workflow><workflow><AddField><field_name>RoadPrefix</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>15</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>RoadPrefix</field_domain></AddField></workflow><workflow><AddField><field_name>RoadType</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>15</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>RoadType</field_domain></AddField></workflow><workflow><AddField><field_name>RoadName</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>30</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e685477483677735959695338526d332f6b6d616667654473566966456b6b70344d6a716b4879384f434f48593d2a00;ENCRYPTED_PASSWORD=00022e68514f4e464b687a4f50454d365458534d4f316673754d6f6a63484b3636423769732f37736e4e69644e41493d2a00;SERVER=gsdb;INSTANCE=sde:sqlserver:gsdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gsdb;DATABASE=Planning;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Full Address</rule_name><rule_description>Calculates the full address for a site address point by concatenating several other field values</rule_description><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression>// This will calculate the full address for a site address point by concatenating several other field values // Define the full address field var fulladdr_field = "fulladdr"; If (!HasKey($feature, fulladdr_field)) return; // Define the fields to concatenate var values = [$feature.addrnum, $feature.RoadPrefix, $feature.RoadName, $feature.RoadType, $feature.unittype, $feature.unitid, $feature.CityName, $feature.Stateabbreviation, $feature.ZIP]; var combined_value = []; // Loop through the field values and test if they are null or empty strings // If they are not null or empty add them to an array for (var i in values) { var value = values[i]; if (IsEmpty(value)) continue; combined_value[Count(combined_value)] = value } // Return the field values concatenated with a space between return { "result": { "attributes": Dictionary(fulladdr_field, Concatenate(combined_value, " ")) } }</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e685477483677735959695338526d332f6b6d616667654473566966456b6b70344d6a716b4879384f434f48593d2a00;ENCRYPTED_PASSWORD=00022e68514f4e464b687a4f50454d365458534d4f316673754d6f6a63484b3636423769732f37736e4e69644e41493d2a00;SERVER=gsdb;INSTANCE=sde:sqlserver:gsdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gsdb;DATABASE=Planning;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><EnableAttributeRules><rule_name>Full Address</rule_name><rule_type>CALCULATION</rule_type></EnableAttributeRules></workflow></operationSequence>" CalculateField DBO.SiteAddressPoint ZIP "99301" "Python 3" # Text NO_ENFORCE_DOMAINS UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e685477483677735959695338526d332f6b6d616667654473566966456b6b70344d6a716b4879384f434f48593d2a00;ENCRYPTED_PASSWORD=00022e68514f4e464b687a4f50454d365458534d4f316673754d6f6a63484b3636423769732f37736e4e69644e41493d2a00;SERVER=gsdb;INSTANCE=sde:sqlserver:gsdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gsdb;DATABASE=Planning;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Full Address</rule_name><rule_description>Calculates the full address for a site address point by concatenating several other field values</rule_description><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression>// This will calculate the full address for a site address point by concatenating several other field values // Define the full address field var fulladdr_field = "fulladdr"; If (!HasKey($feature, fulladdr_field)) return; // Define the fields to concatenate var values = [$feature.addrnum, $feature.RoadPrefix, $feature.RoadName, $feature.RoadType]; var combined_value = [ values,$feature.unittype, $feature.unitid, $feature.CityName, $feature.Stateabbreviation, $feature.ZIP]; // Loop through the field values and test if they are null or empty strings // If they are not null or empty add them to an array for (var i in values) { var value = values[i]; if (IsEmpty(value)) continue; combined_value[Count(combined_value)] = value } // Return the field values concatenated with a space between return { "result": { "attributes": Dictionary(fulladdr_field, Concatenate(combined_value, " ")) } }</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e685477483677735959695338526d332f6b6d616667654473566966456b6b70344d6a716b4879384f434f48593d2a00;ENCRYPTED_PASSWORD=00022e68514f4e464b687a4f50454d365458534d4f316673754d6f6a63484b3636423769732f37736e4e69644e41493d2a00;SERVER=gsdb;INSTANCE=sde:sqlserver:gsdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gsdb;DATABASE=Planning;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Full Address</rule_name><rule_description>Calculates the full address for a site address point by concatenating several other field values</rule_description><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression>// This will calculate the full address for a site address point by concatenating several other field values // Define the full address field var fulladdr_field = "fulladdr"; If (!HasKey($feature, fulladdr_field)) return; // Define the fields to concatenate var values = ($feature.addrnum, $feature.RoadPrefix, $feature.RoadName, $feature.RoadType); var combined_value = [ values,$feature.unittype, $feature.unitid, $feature.CityName, $feature.Stateabbreviation, $feature.ZIP]; // Loop through the field values and test if they are null or empty strings // If they are not null or empty add them to an array for (var i in values) { var value = values[i]; if (IsEmpty(value)) continue; combined_value[Count(combined_value)] = value } // Return the field values concatenated with a space between return { "result": { "attributes": Dictionary(fulladdr_field, Concatenate(combined_value, " ")) } }</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e685477483677735959695338526d332f6b6d616667654473566966456b6b70344d6a716b4879384f434f48593d2a00;ENCRYPTED_PASSWORD=00022e68514f4e464b687a4f50454d365458534d4f316673754d6f6a63484b3636423769732f37736e4e69644e41493d2a00;SERVER=gsdb;INSTANCE=sde:sqlserver:gsdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gsdb;DATABASE=Planning;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><DisableAttributeRules><rule_name>Full Address</rule_name><rule_type>CALCULATION</rule_type></DisableAttributeRules><AlterAttributeRule><rule_name>Full Address</rule_name><rule_description>Calculates the full address for a site address point by concatenating several other field values</rule_description><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression>// This will calculate the full address for a site address point by concatenating several other field values // Define the full address field var fulladdr_field = "fulladdr"; If (!HasKey($feature, fulladdr_field)) return; // Define the fields to concatenate var values = ($feature.addrnum, $feature.RoadPrefix, $feature.RoadName, $feature.RoadType); var combined_value = [ values,$feature.unittype, $feature.unitid, $feature.CityName, $feature.Stateabbreviation, $feature.ZIP]; // Loop through the field values and test if they are null or empty strings // If they are not null or empty add them to an array for (var i in values) { var value = values[i]; if (IsEmpty(value)) continue; combined_value[Count(combined_value)] = value } // Return the field values concatenated with a space between return { "result": { "attributes": Dictionary(fulladdr_field, Concatenate(combined_value, " ")) } }</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e685477483677735959695338526d332f6b6d616667654473566966456b6b70344d6a716b4879384f434f48593d2a00;ENCRYPTED_PASSWORD=00022e68514f4e464b687a4f50454d365458534d4f316673754d6f6a63484b3636423769732f37736e4e69644e41493d2a00;SERVER=gsdb;INSTANCE=sde:sqlserver:gsdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gsdb;DATABASE=Planning;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><DisableAttributeRules><rule_name>Full Address</rule_name><rule_type>CALCULATION</rule_type></DisableAttributeRules><AlterAttributeRule><rule_name>Full Address</rule_name><rule_description>Calculates the full address for a site address point by concatenating several other field values</rule_description><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression>// This will calculate the full address for a site address point by concatenating several other field values // Define the full address field var fulladdr_field = "fulladdr"; If (!HasKey($feature, fulladdr_field)) return; // Define the fields to concatenate var values = [feature.addrnum, $feature.RoadPrefix, $feature.RoadName, $feature.RoadType]; var combined_value = [ values,$feature.unittype, $feature.unitid, $feature.CityName, $feature.Stateabbreviation, $feature.ZIP]; // Loop through the field values and test if they are null or empty strings // If they are not null or empty add them to an array for (var i in values) { var value = values[i]; if (IsEmpty(value)) continue; combined_value[Count(combined_value)] = value } // Return the field values concatenated with a space between return { "result": { "attributes": Dictionary(fulladdr_field, Concatenate(combined_value, " ")) } }</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e685477483677735959695338526d332f6b6d616667654473566966456b6b70344d6a716b4879384f434f48593d2a00;ENCRYPTED_PASSWORD=00022e68514f4e464b687a4f50454d365458534d4f316673754d6f6a63484b3636423769732f37736e4e69644e41493d2a00;SERVER=gsdb;INSTANCE=sde:sqlserver:gsdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gsdb;DATABASE=Planning;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Full Address</rule_name><rule_description>Calculates the full address for a site address point by concatenating several other field values</rule_description><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression>// This will calculate the full address for a site address point by concatenating several other field values // Define the full address field var fulladdr_field = "fulladdr"; If (!HasKey($feature, fulladdr_field)) return; // Define the fields to concatenate var values = [feature.addrnum, $feature.RoadPrefix, $feature.RoadName, $feature.RoadType]; var combined_value = [ values,$feature.unittype, $feature.unitid, $feature.CityName, $feature.Stateabbreviation, $feature.ZIP]; // Loop through the field values and test if they are null or empty strings // If they are not null or empty add them to an array for (var i in values) { var value = values[i]; if (IsEmpty(value)) continue; combined_value[Count(combined_value)] = value } // Return the field values concatenated with a space between return { "result": { "attributes": Dictionary(fulladdr_field, Concatenate(combined_value, ", ")) } }</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e685477483677735959695338526d332f6b6d616667654473566966456b6b70344d6a716b4879384f434f48593d2a00;ENCRYPTED_PASSWORD=00022e68514f4e464b687a4f50454d365458534d4f316673754d6f6a63484b3636423769732f37736e4e69644e41493d2a00;SERVER=gsdb;INSTANCE=sde:sqlserver:gsdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gsdb;DATABASE=Planning;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Full Address</rule_name><rule_description>Calculates the full address for a site address point by concatenating several other field values</rule_description><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression>// This will calculate the full address for a site address point by concatenating several other field values // Define the full address field var fulladdr_field = "fulladdr"; If (!HasKey($feature, fulladdr_field)) return; // Define the fields to concatenate var values = [feature.addrnum, $feature.RoadPrefix, $feature.RoadName, $feature.RoadType]; var combined_value = [ values,$feature.unittype, $feature.unitid, $feature.CityName, $feature.Stateabbreviation, $feature.ZIP]; // Loop through the field values and test if they are null or empty strings // If they are not null or empty add them to an array for (var i in values) { var value = values[i]; if (IsEmpty(value)) continue; combined_value[Count(combined_value)] = value } // Return the field values concatenated with a space between return { "result": { "attributes": Dictionary(fulladdr_field, Concatenate(combined_value, ", ")) } }</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule><EnableAttributeRules><rule_name>Full Address</rule_name><rule_type>CALCULATION</rule_type></EnableAttributeRules></workflow></operationSequence>" UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e685477483677735959695338526d332f6b6d616667654473566966456b6b70344d6a716b4879384f434f48593d2a00;ENCRYPTED_PASSWORD=00022e68514f4e464b687a4f50454d365458534d4f316673754d6f6a63484b3636423769732f37736e4e69644e41493d2a00;SERVER=gsdb;INSTANCE=sde:sqlserver:gsdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gsdb;DATABASE=Planning;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Full Address</rule_name><rule_description>Calculates the full address for a site address point by concatenating several other field values</rule_description><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression>// This will calculate the full address for a site address point by concatenating several other field values // Define the full address field var fulladdr_field = "fulladdr"; If (!HasKey($feature, fulladdr_field)) return; // Define the fields to concatenate var values = [feature.addrnum, $feature.RoadPrefix, $feature.RoadName, $feature.RoadType, $feature.unittype, $feature.unitid, $feature.CityName, $feature.Stateabbreviation, $feature.ZIP]; var combined_value = []; // Loop through the field values and test if they are null or empty strings // If they are not null or empty add them to an array for (var i in values) { var value = values[i]; if (IsEmpty(value)) continue; combined_value[Count(combined_value)] = value } // Return the field values concatenated with a space between return { "result": { "attributes": Dictionary(fulladdr_field, Concatenate(combined_value, " ")) } }</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e685477483677735959695338526d332f6b6d616667654473566966456b6b70344d6a716b4879384f434f48593d2a00;ENCRYPTED_PASSWORD=00022e68514f4e464b687a4f50454d365458534d4f316673754d6f6a63484b3636423769732f37736e4e69644e41493d2a00;SERVER=gsdb;INSTANCE=sde:sqlserver:gsdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gsdb;DATABASE=Planning;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Full Address</rule_name><rule_description>Calculates the full address for a site address point by concatenating several other field values</rule_description><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression>// This will calculate the full address for a site address point by concatenating several other field values // Define the full address field var fulladdr_field = "fulladdr"; If (!HasKey($feature, fulladdr_field)) return; // Define the fields to concatenate var values = [feature.addrnum, $feature.RoadPrefix, $feature.RoadName, $feature.RoadType, $feature.unittype, $feature.unitid, $feature.CityName, $feature.Stateabbreviation, $feature.ZIP]; var combined_value = []; // Loop through the field values and test if they are null or empty strings // If they are not null or empty add them to an array for (var i in values) { var value = values[i]; if (IsEmpty(value)) continue; combined_value[Count(combined_value)] = value } // Return the field values concatenated with a space between return { "result": { "attributes": Dictionary(fulladdr_field, Concatenate(combined_value, " ")) } }</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e685477483677735959695338526d332f6b6d616667654473566966456b6b70344d6a716b4879384f434f48593d2a00;ENCRYPTED_PASSWORD=00022e68514f4e464b687a4f50454d365458534d4f316673754d6f6a63484b3636423769732f37736e4e69644e41493d2a00;SERVER=gsdb;INSTANCE=sde:sqlserver:gsdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gsdb;DATABASE=Planning;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Full Address</rule_name><rule_description>Calculates the full address for a site address point by concatenating several other field values</rule_description><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression>// This will calculate the full address for a site address point by concatenating several other field values // Define the full address field var fulladdr_field = "fulladdr"; If (!HasKey($feature, fulladdr_field)) return; // Define the fields to concatenate var values = [$feature.addrnum, $feature.RoadPrefix, $feature.RoadName, $feature.RoadType, $feature.unittype, $feature.unitid, $feature.stateabbreviation, $feature.ZIP]; var combined_value = []; // Loop through the field values and test if they are null or empty strings // If they are not null or empty add them to an array for (var i in values) { var value = values[i]; if (IsEmpty(value)) continue; combined_value[Count(combined_value)] = value } // Return the field values concatenated with a space between return { "result": { "attributes": Dictionary(fulladdr_field, Concatenate(combined_value, " ")) } }</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e685477483677735959695338526d332f6b6d616667654473566966456b6b70344d6a716b4879384f434f48593d2a00;ENCRYPTED_PASSWORD=00022e68514f4e464b687a4f50454d365458534d4f316673754d6f6a63484b3636423769732f37736e4e69644e41493d2a00;SERVER=gsdb;INSTANCE=sde:sqlserver:gsdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gsdb;DATABASE=Planning;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Full Address</rule_name><rule_description>Calculates the full address for a site address point by concatenating several other field values</rule_description><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression>// This will calculate the full address for a site address point by concatenating several other field values // Define the full address field var fulladdr_field = "fulladdr"; If (!HasKey($feature, fulladdr_field)) return; // Define the fields to concatenate var values = [$feature.addrnum, $feature.RoadPrefix, $feature.RoadName, $feature.RoadType, $feature.unittype, $feature.unitid, $feature.CityName, $feature.stateabbreviation, $feature.ZIP]; var combined_value = []; // Loop through the field values and test if they are null or empty strings // If they are not null or empty add them to an array for (var i in values) { var value = values[i]; if (IsEmpty(value)) continue; combined_value[Count(combined_value)] = value } // Return the field values concatenated with a space between return { "result": { "attributes": Dictionary(fulladdr_field, Concatenate(combined_value, " ")) } }</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e685477483677735959695338526d332f6b6d616667654473566966456b6b70344d6a716b4879384f434f48593d2a00;ENCRYPTED_PASSWORD=00022e68514f4e464b687a4f50454d365458534d4f316673754d6f6a63484b3636423769732f37736e4e69644e41493d2a00;SERVER=gsdb;INSTANCE=sde:sqlserver:gsdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gsdb;DATABASE=Planning;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Full Address</rule_name><rule_description>Calculates the full address for a site address point by concatenating several other field values</rule_description><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression>// This will calculate the full address for a site address point by concatenating several other field values // Define the full address field var fulladdr_field = "fulladdr"; If (!HasKey($feature, fulladdr_field)) return; // Define the fields to concatenate var values = [$feature.addrnum, $feature.RoadPrefix, $feature.RoadName, $feature.RoadType, $feature.unittype, $feature.unitid, $feature.CityName, $feature.stateabbreviation, $feature.ZIP]; var combined_value = []; // Loop through the field values and test if they are null or empty strings // If they are not null or empty add them to an array for (var i in values) { var value = values[i]; if (IsEmpty(value)) continue; Insert(values, 6, " ," + values[6]); combined_value[Count(combined_value)] = value } // Return the field values concatenated with a space between return { "result": { "attributes": Dictionary(fulladdr_field, Concatenate(combined_value, " ")) } }</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e685477483677735959695338526d332f6b6d616667654473566966456b6b70344d6a716b4879384f434f48593d2a00;ENCRYPTED_PASSWORD=00022e68514f4e464b687a4f50454d365458534d4f316673754d6f6a63484b3636423769732f37736e4e69644e41493d2a00;SERVER=gsdb;INSTANCE=sde:sqlserver:gsdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gsdb;DATABASE=Planning;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Full Address</rule_name><rule_description>Calculates the full address for a site address point by concatenating several other field values</rule_description><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression>// This will calculate the full address for a site address point by concatenating several other field values // Define the full address field var fulladdr_field = "fulladdr"; If (!HasKey($feature, fulladdr_field)) return; // Define the fields to concatenate var values = [$feature.addrnum, $feature.RoadPrefix, $feature.RoadName, $feature.RoadType, $feature.unittype, $feature.unitid, Insert(values, 6, ", " + $feature.CityName), $feature.stateabbreviation, $feature.ZIP]; var combined_value = []; // Loop through the field values and test if they are null or empty strings // If they are not null or empty add them to an array for (var i in values) { var value = values[i]; if (IsEmpty(value)) continue; combined_value[Count(combined_value)] = value } // Return the field values concatenated with a space between return { "result": { "attributes": Dictionary(fulladdr_field, Concatenate(combined_value, " ")) } }</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e685477483677735959695338526d332f6b6d616667654473566966456b6b70344d6a716b4879384f434f48593d2a00;ENCRYPTED_PASSWORD=00022e68514f4e464b687a4f50454d365458534d4f316673754d6f6a63484b3636423769732f37736e4e69644e41493d2a00;SERVER=gsdb;INSTANCE=sde:sqlserver:gsdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gsdb;DATABASE=Planning;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Full Address</rule_name><rule_description>Calculates the full address for a site address point by concatenating several other field values</rule_description><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression>// This will calculate the full address for a site address point by concatenating several other field values // Define the full address field var fulladdr_field = "fulladdr"; If (!HasKey($feature, fulladdr_field)) return; // Define the fields to concatenate var values = [$feature.addrnum, $feature.RoadPrefix, $feature.RoadName, $feature.RoadType, $feature.unittype, $feature.unitid, ", " + $feature.CityName, $feature.stateabbreviation, $feature.ZIP]; var combined_value = []; // Loop through the field values and test if they are null or empty strings // If they are not null or empty add them to an array for (var i in values) { var value = values[i]; if (IsEmpty(value)) continue; combined_value[Count(combined_value)] = value } // Return the field values concatenated with a space between return { "result": { "attributes": Dictionary(fulladdr_field, Concatenate(combined_value, " ")) } }</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e685477483677735959695338526d332f6b6d616667654473566966456b6b70344d6a716b4879384f434f48593d2a00;ENCRYPTED_PASSWORD=00022e68514f4e464b687a4f50454d365458534d4f316673754d6f6a63484b3636423769732f37736e4e69644e41493d2a00;SERVER=gsdb;INSTANCE=sde:sqlserver:gsdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gsdb;DATABASE=Planning;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Full Address</rule_name><rule_description>Calculates the full address for a site address point by concatenating several other field values</rule_description><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression>// This will calculate the full address for a site address point by concatenating several other field values // Define the full address field var fulladdr_field = "fulladdr"; If (!HasKey($feature, fulladdr_field)) return; // Define the fields to concatenate var values = [$feature.addrnum, $feature.RoadPrefix, $feature.RoadName, $feature.RoadType, $feature.unittype, $feature.unitid, "," + $feature.CityName, $feature.stateabbreviation + ",", $feature.ZIP]; var combined_value = []; // Loop through the field values and test if they are null or empty strings // If they are not null or empty add them to an array for (var i in values) { var value = values[i]; if (IsEmpty(value)) continue; combined_value[Count(combined_value)] = value } // Return the field values concatenated with a space between return { "result": { "attributes": Dictionary(fulladdr_field, Concatenate(combined_value, " ")) } }</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e685477483677735959695338526d332f6b6d616667654473566966456b6b70344d6a716b4879384f434f48593d2a00;ENCRYPTED_PASSWORD=00022e68514f4e464b687a4f50454d365458534d4f316673754d6f6a63484b3636423769732f37736e4e69644e41493d2a00;SERVER=gsdb;INSTANCE=sde:sqlserver:gsdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gsdb;DATABASE=Planning;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Full Address</rule_name><rule_description>Calculates the full address for a site address point by concatenating several other field values</rule_description><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression>// This will calculate the full address for a site address point by concatenating several other field values // Define the full address field var fulladdr_field = "fulladdr"; If (!HasKey($feature, fulladdr_field)) return; var adds = ["," + $feature.CityName, $feature.stateabbreviation + ",", $feature.ZIP]; // Define the fields to concatenate var values = [$feature.addrnum, $feature.RoadPrefix, $feature.RoadName, $feature.RoadType, $feature.unittype, $feature.unitid, "," + $feature.CityName, $feature.stateabbreviation + ",", $feature.ZIP, adds]; var combined_value = []; // Loop through the field values and test if they are null or empty strings // If they are not null or empty add them to an array for (var i in values) { var value = values[i]; if (IsEmpty(value)) continue; combined_value[Count(combined_value)] = value } // Return the field values concatenated with a space between return { "result": { "attributes": Dictionary(fulladdr_field, Concatenate(combined_value, " ")) } }</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e685477483677735959695338526d332f6b6d616667654473566966456b6b70344d6a716b4879384f434f48593d2a00;ENCRYPTED_PASSWORD=00022e68514f4e464b687a4f50454d365458534d4f316673754d6f6a63484b3636423769732f37736e4e69644e41493d2a00;SERVER=gsdb;INSTANCE=sde:sqlserver:gsdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gsdb;DATABASE=Planning;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Full Address</rule_name><rule_description>Calculates the full address for a site address point by concatenating several other field values</rule_description><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression>// This will calculate the full address for a site address point by concatenating several other field values // Define the full address field var fulladdr_field = "fulladdr"; If (!HasKey($feature, fulladdr_field)) return; //var adds = ("," + $feature.CityName, $feature.stateabbreviation + ",", $feature.ZIP); // Define the fields to concatenate var values = [$feature.addrnum, $feature.RoadPrefix, $feature.RoadName, $feature.RoadType, $feature.unittype, $feature.unitid, "," + $feature.CityName, $feature.stateabbreviation + ",", $feature.ZIP, Concatenate("," + $feature.CityName, $feature.stateabbreviation + ",", $feature.ZIP)]; var combined_value = []; // Loop through the field values and test if they are null or empty strings // If they are not null or empty add them to an array for (var i in values) { var value = values[i]; if (IsEmpty(value)) continue; combined_value[Count(combined_value)] = value } // Return the field values concatenated with a space between return { "result": { "attributes": Dictionary(fulladdr_field, Concatenate(combined_value, " ")) } }</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e685477483677735959695338526d332f6b6d616667654473566966456b6b70344d6a716b4879384f434f48593d2a00;ENCRYPTED_PASSWORD=00022e68514f4e464b687a4f50454d365458534d4f316673754d6f6a63484b3636423769732f37736e4e69644e41493d2a00;SERVER=gsdb;INSTANCE=sde:sqlserver:gsdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gsdb;DATABASE=Planning;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Full Address</rule_name><rule_description>Calculates the full address for a site address point by concatenating several other field values</rule_description><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression>// This will calculate the full address for a site address point by concatenating several other field values // Define the full address field var fulladdr_field = "fulladdr"; If (!HasKey($feature, fulladdr_field)) return; //var adds = ("," + $feature.CityName, $feature.stateabbreviation + ",", $feature.ZIP); // Define the fields to concatenate var values = [$feature.addrnum, $feature.RoadPrefix, $feature.RoadName, $feature.RoadType, $feature.unittype, $feature.unitid, Concatenate(", " + $feature.CityName, + " " + $feature.stateabbreviation + ", ", $feature.ZIP)]; var combined_value = []; // Loop through the field values and test if they are null or empty strings // If they are not null or empty add them to an array for (var i in values) { var value = values[i]; if (IsEmpty(value)) continue; combined_value[Count(combined_value)] = value } // Return the field values concatenated with a space between return { "result": { "attributes": Dictionary(fulladdr_field, Concatenate(combined_value, " ")) } }</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e685477483677735959695338526d332f6b6d616667654473566966456b6b70344d6a716b4879384f434f48593d2a00;ENCRYPTED_PASSWORD=00022e68514f4e464b687a4f50454d365458534d4f316673754d6f6a63484b3636423769732f37736e4e69644e41493d2a00;SERVER=gsdb;INSTANCE=sde:sqlserver:gsdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gsdb;DATABASE=Planning;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Full Address</rule_name><rule_description>Calculates the full address for a site address point by concatenating several other field values</rule_description><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression>// This will calculate the full address for a site address point by concatenating several other field values // Define the full address field var fulladdr_field = "fulladdr"; If (!HasKey($feature, fulladdr_field)) return; //var adds = ("," + $feature.CityName, $feature.stateabbreviation + ",", $feature.ZIP); // Define the fields to concatenate var values = [$feature.addrnum, $feature.RoadPrefix, $feature.RoadName, $feature.RoadType, $feature.unittype, $feature.unitid, Concatenate(", " + $feature.CityName + " ", $feature.stateabbreviation + ", ", $feature.ZIP)]; var combined_value = []; // Loop through the field values and test if they are null or empty strings // If they are not null or empty add them to an array for (var i in values) { var value = values[i]; if (IsEmpty(value)) continue; combined_value[Count(combined_value)] = value } // Return the field values concatenated with a space between return { "result": { "attributes": Dictionary(fulladdr_field, Concatenate(combined_value, " ")) } }</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e685477483677735959695338526d332f6b6d616667654473566966456b6b70344d6a716b4879384f434f48593d2a00;ENCRYPTED_PASSWORD=00022e68514f4e464b687a4f50454d365458534d4f316673754d6f6a63484b3636423769732f37736e4e69644e41493d2a00;SERVER=gsdb;INSTANCE=sde:sqlserver:gsdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gsdb;DATABASE=Planning;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Full Address</rule_name><rule_description>Calculates the full address for a site address point by concatenating several other field values</rule_description><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression>// This will calculate the full address for a site address point by concatenating several other field values // Define the full address field var fulladdr_field = "fulladdr"; If (!HasKey($feature, fulladdr_field)) return; //var adds = ("," + $feature.CityName, $feature.stateabbreviation + ",", $feature.ZIP); // Define the fields to concatenate var values = [$feature.addrnum, $feature.RoadPrefix, $feature.RoadName, $feature.RoadType, $feature.unittype, $feature.unitid, Concatenate(", " + $feature.CityName + " ", $feature.stateabbreviation + ", ", $feature.ZIP)]; var combined_value = []; // Loop through the field values and test if they are null or empty strings // If they are not null or empty add them to an array for (var i in values) { var value = values[i]; if (IsEmpty(value)) continue; combined_value[Count(combined_value)] = value } // Return the field values concatenated with a space between return { "result": { "attributes": Dictionary(fulladdr_field, Concatenate(Replace(combined_value, ' ,', ','), " ")) } }</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e685477483677735959695338526d332f6b6d616667654473566966456b6b70344d6a716b4879384f434f48593d2a00;ENCRYPTED_PASSWORD=00022e68514f4e464b687a4f50454d365458534d4f316673754d6f6a63484b3636423769732f37736e4e69644e41493d2a00;SERVER=gsdb;INSTANCE=sde:sqlserver:gsdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gsdb;DATABASE=Planning;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Full Address</rule_name><rule_description>Calculates the full address for a site address point by concatenating several other field values</rule_description><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression>// This will calculate the full address for a site address point by concatenating several other field values // Define the full address field var fulladdr_field = "fulladdr"; If (!HasKey($feature, fulladdr_field)) return; //var adds = ("," + $feature.CityName, $feature.stateabbreviation + ",", $feature.ZIP); // Define the fields to concatenate var values = [$feature.addrnum, $feature.RoadPrefix, $feature.RoadName, $feature.RoadType, $feature.unittype, $feature.unitid, Concatenate(", " + $feature.CityName + " ", $feature.stateabbreviation + ", ", $feature.ZIP)]; var combined_value = []; // Loop through the field values and test if they are null or empty strings // If they are not null or empty add them to an array for (var i in values) { var value = values[i]; if (IsEmpty(value)) continue; combined_value[Count(combined_value)] = value } // Return the field values concatenated with a space between return { "result": { "attributes": Dictionary(fulladdr_field, Replace(Concatenate(combined_value, " "), ' ,', ',')) } }</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" CalculateField "Site Address Point" CityName "Pasco" "Python 3" # Text NO_ENFORCE_DOMAINS UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e685477483677735959695338526d332f6b6d616667654473566966456b6b70344d6a716b4879384f434f48593d2a00;ENCRYPTED_PASSWORD=00022e68514f4e464b687a4f50454d365458534d4f316673754d6f6a63484b3636423769732f37736e4e69644e41493d2a00;SERVER=gsdb;INSTANCE=sde:sqlserver:gsdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gsdb;DATABASE=Planning;USER=sa;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Full Address</rule_name><rule_description>Calculates the full address for a site address point by concatenating several other field values</rule_description><exclude_from_client_eval>True</exclude_from_client_eval><severity>-1</severity><expression>// This will calculate the full address for a site address point by concatenating several other field values // Define the full address field var fulladdr_field = "fulladdr"; If (!HasKey($feature, fulladdr_field)) return; //var adds = ("," + $feature.CityName, $feature.stateabbreviation + ",", $feature.ZIP); // Define the fields to concatenate var values = [$feature.addrnum, $feature.RoadPrefix, $feature.RoadName, $feature.RoadType, $feature.unittype, $feature.unitid, Concatenate(", " + $feature.CityName + ", ", $feature.stateabbreviation + " ", $feature.ZIP)]; var combined_value = []; // Loop through the field values and test if they are null or empty strings // If they are not null or empty add them to an array for (var i in values) { var value = values[i]; if (IsEmpty(value)) continue; combined_value[Count(combined_value)] = value } // Return the field values concatenated with a space between return { "result": { "attributes": Dictionary(fulladdr_field, Replace(Concatenate(combined_value, " "), ' ,', ',')) } }</expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" CalculateField "Site Address Point" CityName "Pasco" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DBO.SiteAddressPoint RoadType "Court" "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField DBO.SiteAddressPoint fullname "Argent Ct" "Python 3" # Text NO_ENFORCE_DOMAINS UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e68546641786c42564153782b6b694f47616957336c4d4e2b2b386c3450345a482b514b6e4d5736444c4576513d2a00;ENCRYPTED_PASSWORD=00022e6867744d2b4d7146747670796b6a4279743771634b556d69446f466c7333546b703146616174366b516a75673d2a00;SERVER=gsdb;INSTANCE=sde:sqlserver:gsdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gsdb;DATABASE=Planning;USER=sa;AUTHENTICATION_MODE=DBMS;BRANCH=sde.DEFAULT</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><DeleteDomain><domain_name>RoadNameIndex_1</domain_name></DeleteDomain></workflow><workflow><AssignDomainToField><field_name>fullname</field_name><domain_name>RoadNameIndex</domain_name></AssignDomainToField></workflow></operationSequence> CalculateField "E_Site Address Point" country "US" "Python 3" # Text NO_ENFORCE_DOMAINS UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e6874695536567559614a4171506247564c4f5566325733457334764c774c6a51636955617569365348454c553d2a00;ENCRYPTED_PASSWORD=00022e683064305a48775436664e5578484f686c4c44396e57706c685566594b56714579415377344a36506e464a633d2a00;SERVER=gsdb;INSTANCE=sde:sqlserver:gsdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gsdb;DATABASE=Planning;USER=sa;AUTHENTICATION_MODE=DBMS;BRANCH=sde.DEFAULT</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>fullname</field_name><domain_name>RoadNameIndex1</domain_name></AssignDomainToField></workflow></operationSequence> CalculateField "Site Address Point" unitid ""B" + !unitid![2:]" Python # Text NO_ENFORCE_DOMAINS CalculateField "Site Address Point" unitid ""BB" + !unitid![2:]" Python # Text NO_ENFORCE_DOMAINS CalculateField "Site Address Point" unitid ""CC" + !unitid![2:]" Python # Text NO_ENFORCE_DOMAINS CalculateField "Site Address Point" unitid ""DD" + !unitid![2:]" Python # Text NO_ENFORCE_DOMAINS CalculateField "Site Address Point" unitid ""EE" + !unitid![2:]" Python # Text NO_ENFORCE_DOMAINS CalculateField "Site Address Point" unitid ""FF" + !unitid![2:]" Python # Text NO_ENFORCE_DOMAINS CalculateField "Site Address Point" unitid ""GG" + !unitid![2:]" Python # Text NO_ENFORCE_DOMAINS CalculateField "Site Address Point" unitid ""HH" + !unitid![2:]" Python # Text NO_ENFORCE_DOMAINS UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.3.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e684e4351683351334e534b3473696e6b39674559344258476e592f486e3050547973336a332b5672727666453d2a00;ENCRYPTED_PASSWORD=00022e68394d76695161683553576d42434e6c48694e4b313579325163366a7861654f7438483142316661695236493d2a00;SERVER=gsdb;INSTANCE=sde:sqlserver:gsdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gsdb;DATABASE=Planning;USER=sa;AUTHENTICATION_MODE=DBMS;BRANCH=sde.DEFAULT</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><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> 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.3.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e684e4351683351334e534b3473696e6b39674559344258476e592f486e3050547973336a332b5672727666453d2a00;ENCRYPTED_PASSWORD=00022e686c655931686b486f5565495456443961446e30764f6a7950662b5166755535744244346c467246584269553d2a00;SERVER=gsdb;INSTANCE=sde:sqlserver:gsdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gsdb;DATABASE=Planning;USER=sa;AUTHENTICATION_MODE=DBMS;BRANCH=sde.DEFAULT</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><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> CalculateField "Site Address Point" unitid !unitid![1:] Python # Text NO_ENFORCE_DOMAINS CalculateField "Site Address Point" unitid !unitid![1:] Python # Text NO_ENFORCE_DOMAINS CalculateField "Site Address Point" unitid !unitid![1:] Python # Text NO_ENFORCE_DOMAINS CalculateField "Site Address Point" unitid !unitid![1:] Python # Text NO_ENFORCE_DOMAINS CalculateField "Site Address Point" unitid !unitid![1:] Python # Text NO_ENFORCE_DOMAINS UpdateSchema "CIMDATA=<CIMFeatureDatasetDataConnection xsi:type='typens:CIMFeatureDatasetDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.3.0'><FeatureDataset>DBO.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e684e4351683351334e534b3473696e6b39674559344258476e592f486e3050547973336a332b5672727666453d2a00;ENCRYPTED_PASSWORD=00022e685439624441572b416949505848527932474b782b7434523230716f435954536a6e623671583432564538513d2a00;SERVER=gsdb;INSTANCE=sde:sqlserver:gsdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gsdb;DATABASE=Planning;USER=sa;AUTHENTICATION_MODE=DBMS;BRANCH=sde.DEFAULT</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>DBO.SiteAddressPoint</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><AlterField><field_name>unitid</field_name><field_type>TEXT</field_type><field_length>30</field_length><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow></operationSequence> CalculateField "Site Address Point" unitid "B"+!unitid! Python # Text NO_ENFORCE_DOMAINS CalculateField "Site Address Point" unitid "B"+!unitid! Python # Text NO_ENFORCE_DOMAINS CalculateField "Site Address Point" unitid "C"+!unitid! Python # Text NO_ENFORCE_DOMAINS CalculateField "Site Address Point" unitid "D"+!unitid! Python # Text NO_ENFORCE_DOMAINS CalculateField "Site Address Point" unitid "E"+!unitid! Python # Text NO_ENFORCE_DOMAINS CalculateField "Site Address Point" unitid "A"+!unitid! Python # Text NO_ENFORCE_DOMAINS CalculateField "Site Address Point" unitid "F"+!unitid! Python # Text NO_ENFORCE_DOMAINS ExportFeatures "C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint" "C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Citybase.sde\GIS_PORTAL.Addressing\GIS_PORTAL.Addresses" # NOT_USE_ALIAS "SiteAddressID "Site Address ID" true true false 20 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,siteaddid,0,19;PreAddrNum "Address Number Prefix" true true false 5 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,preaddrnum,0,4;AddrNumSuf "Address Number Suffix" true true false 5 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,addrnumsuf,0,4;AddrNum "Full Address Number" true true false 20 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,addrnum,0,19;AddrRange "Address Range" true true false 50 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,addrrange,0,49;UnitType "Address Unit Type" true true false 10 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,unittype,0,9;UnitID "Address Unit Number" true true false 30 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,unitid,0,29;RoadPrefix "Road Prefix" true true false 15 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,RoadPrefix,0,14;RoadName "Road Name" true true false 30 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,RoadName,0,29;RoadSufix "Road Type" true true false 15 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,RoadType,0,14;FullRdName "Full Road Name" true true false 300 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,fullname,0,299;HalfAddress "Half Address" true true false 255 Text 0 0,First,#;FullAddr "Full Address" true true false 500 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,fulladdr,0,499;PlaceName "Place Name" true true false 250 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,placename,0,249;CityName "Municipality Name" true true false 100 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,CityName,0,99;State "State Abbreviation" true true false 2 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,stateabbreviation,0,1;ZIP "ZIP" true true false 10 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,ZIP,0,9;Country "Country Abbreviation" true true false 2 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,country,0,1;PointLocal "Location" true true false 30 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,pointtype,0,29;CaptureMethod "Capture Method" true true false 30 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,capturemeth,0,29;AddStatus "Address Status" true true false 30 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,status,0,29;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,GlobalID,-1,-1;created_date "created_date" false true false 8 Date 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,created_date,-1,-1;last_edited_date "last_edited_date" false true false 8 Date 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,last_edited_date,-1,-1;created_user "created_user" false true false 255 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,created_user,0,254;last_edited_user "last_edited_user" false true false 255 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,last_edited_user,0,254" # 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.3.0'><FeatureDataset>GIS_PORTAL.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e684565764d4e7664766b767a5a77534178334c514a63706a4b4a717a314761723851544e32534a4449476c383d2a00;ENCRYPTED_PASSWORD=00022e684a48336d595934357a615a636a5871654959755257437165334a44794c67385879452f5662555149436b513d2a00;SERVER=localhost;INSTANCE=sde:sqlserver:localhost;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=localhost;DATABASE=Citybase;USER=GIS_Portal;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS_PORTAL.Addresses</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" <operationSequence><workflow><RemoveDomainFromField><field_name>UnitType</field_name></RemoveDomainFromField></workflow><workflow><RemoveDomainFromField><field_name>FullRdName</field_name></RemoveDomainFromField></workflow><workflow><RemoveDomainFromField><field_name>PointLocal</field_name></RemoveDomainFromField></workflow><workflow><RemoveDomainFromField><field_name>CaptureMethod</field_name></RemoveDomainFromField></workflow></operationSequence> 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.3.0'><FeatureDataset>GIS_PORTAL.Addressing</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e684565764d4e7664766b767a5a77534178334c514a63706a4b4a717a314761723851544e32534a4449476c383d2a00;ENCRYPTED_PASSWORD=00022e6847317748364a386350764a7634707249754e314263515832793668366132586731354871505844733479733d2a00;SERVER=localhost;INSTANCE=sde:sqlserver:localhost;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=localhost;DATABASE=Citybase;USER=GIS_Portal;VERSION=sde.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS_PORTAL.Addresses</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AssignDomainToField><field_name>UnitType</field_name><domain_name>Address Unit Type</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>FullRdName</field_name><domain_name>Road Name Index</domain_name></AssignDomainToField></workflow><workflow><RemoveDomainFromField><field_name>HalfAddress</field_name></RemoveDomainFromField></workflow><workflow><AssignDomainToField><field_name>PointLocal</field_name><domain_name>Address Location</domain_name></AssignDomainToField><AssignDefaultToField><field_name>PointLocal</field_name><default_value>Building</default_value></AssignDefaultToField></workflow><workflow><AssignDomainToField><field_name>CaptureMethod</field_name><domain_name>Collection Method</domain_name></AssignDomainToField></workflow></operationSequence>" UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.3.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e686751373173733744576a57324632303371514e6857562f484e53513038725351366a574e6b6435305975513d2a00;ENCRYPTED_PASSWORD=00022e687a76496146463058466f435639377a7a2f745664515151784b3774325257525356576676624157553069303d2a00;SERVER=gsdb;INSTANCE=sde:sqlserver:gsdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gsdb;DATABASE=Citybase;USER=GIS_Portal;AUTHENTICATION_MODE=DBMS;BRANCH=sde.DEFAULT</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS_PORTAL.Addresses</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><UnregisterAsVersioned><keep_edit>FALSE</keep_edit><compress_default>FALSE</compress_default></UnregisterAsVersioned></workflow></operationSequence> UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.3.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e686751373173733744576a57324632303371514e6857562f484e53513038725351366a574e6b6435305975513d2a00;ENCRYPTED_PASSWORD=00022e684574465537745473514d77756853316d704f484c576a77533233753476754449695a647a734e32306d51413d2a00;SERVER=gsdb;INSTANCE=sde:sqlserver:gsdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gsdb;DATABASE=Citybase;USER=GIS_Portal;AUTHENTICATION_MODE=DBMS;BRANCH=sde.DEFAULT</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS_PORTAL.Addresses</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><EnableArchiving /></workflow></operationSequence>" Append DBO.SiteAddressPoint Addresses "Use the field map to reconcile field differences" "SiteAddressID "Site Address ID" true true false 20 Text 0 0,First,#,DBO.SiteAddressPoint,siteaddid,0,19;PreAddrNum "Address Number Prefix" true true false 5 Text 0 0,First,#,DBO.SiteAddressPoint,preaddrnum,0,4;AddrNumSuf "Address Number Suffix" true true false 5 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,addrnumsuf,0,4;AddrNum "Full Address Number" true true false 20 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,addrnum,0,19;AddrRange "Address Range" true true false 50 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,addrrange,0,49;UnitType "Address Unit Type" true true false 10 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,unittype,0,9;UnitID "Address Unit Number" true true false 30 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,unitid,0,29;RoadPrefix "Road Prefix" true true false 15 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,RoadPrefix,0,14;RoadName "Road Name" true true false 30 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,RoadName,0,29;RoadSufix "Road Type" true true false 15 Text 0 0,First,#,DBO.SiteAddressPoint,RoadType,0,14;FullRdName "Full Road Name" true true false 300 Text 0 0,First,#;HalfAddress "Half Address" true true false 255 Text 0 0,First,#;FullAddr "Full Address" true true false 500 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,fulladdr,0,499;PlaceName "Place Name" true true false 250 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,placename,0,249;CityName "Municipality Name" true true false 100 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,CityName,0,99;State "State Abbreviation" true true false 2 Text 0 0,First,#,DBO.SiteAddressPoint,stateabbreviation,0,1;ZIP "ZIP" true true false 10 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,ZIP,0,9;Country "Country Abbreviation" true true false 2 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,country,0,1;PointLocal "Location" true true false 30 Text 0 0,First,#,DBO.SiteAddressPoint,pointtype,0,29;CaptureMethod "Capture Method" true true false 30 Text 0 0,First,#,DBO.SiteAddressPoint,capturemeth,0,29;AddStatus "Address Status" true true false 30 Text 0 0,First,#,DBO.SiteAddressPoint,status,0,29;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,GlobalID,-1,-1" # # # NOT_UPDATE_GEOMETRY Append DBO.SiteAddressPoint Addresses "Skip and warn if schema does not match" # # # "SiteAddressID siteaddid" NOT_UPDATE_GEOMETRY Append DBO.SiteAddressPoint Addresses "Use the field map to reconcile field differences" "SiteAddressID "Site Address ID" true true false 20 Text 0 0,First,#;PreAddrNum "Address Number Prefix" true true false 5 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,preaddrnum,0,4;AddrNumSuf "Address Number Suffix" true true false 5 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,addrnumsuf,0,4;AddrNum "Full Address Number" true true false 20 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,addrnum,0,19;AddrRange "Address Range" true true false 50 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,addrrange,0,49;UnitType "Address Unit Type" true true false 10 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,unittype,0,9;UnitID "Address Unit Number" true true false 30 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,unitid,0,29;RoadPrefix "Road Prefix" true true false 15 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,RoadPrefix,0,14;RoadName "Road Name" true true false 30 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,RoadName,0,29;RoadSufix "Road Type" true true false 15 Text 0 0,First,#,DBO.SiteAddressPoint,RoadType,0,14;FullRdName "Full Road Name" true true false 300 Text 0 0,First,#;HalfAddress "Half Address" true true false 255 Text 0 0,First,#;FullAddr "Full Address" true true false 500 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,fulladdr,0,499;PlaceName "Place Name" true true false 250 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,placename,0,249;CityName "Municipality Name" true true false 100 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,CityName,0,99;State "State Abbreviation" true true false 2 Text 0 0,First,#,DBO.SiteAddressPoint,stateabbreviation,0,1;ZIP "ZIP" true true false 10 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,ZIP,0,9;Country "Country Abbreviation" true true false 2 Text 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,country,0,1;PointLocal "Location" true true false 30 Text 0 0,First,#,DBO.SiteAddressPoint,pointtype,0,29;CaptureMethod "Capture Method" true true false 30 Text 0 0,First,#,DBO.SiteAddressPoint,capturemeth,0,29;AddStatus "Address Status" true true false 30 Text 0 0,First,#,DBO.SiteAddressPoint,status,0,29;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#,C:\Users\kaufmannadm\Documents\Project Folder\Create_SDE_Workspace\Planning_SA.sde\DBO.Addressing\DBO.SiteAddressPoint,GlobalID,-1,-1" # # "SiteAddressID siteaddid" UPDATE_GEOMETRY UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.3.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e686751373173733744576a57324632303371514e6857562f484e53513038725351366a574e6b6435305975513d2a00;ENCRYPTED_PASSWORD=00022e6838345039664a3742744f5a467845373330496d636b57426c4f653531424147716a4f59437079657a4b44453d2a00;SERVER=gsdb;INSTANCE=sde:sqlserver:gsdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gsdb;DATABASE=Citybase;USER=GIS_Portal;AUTHENTICATION_MODE=DBMS;BRANCH=sde.DEFAULT</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS_PORTAL.Addresses</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AddAttributeRule><rule_name>Half Address</rule_name><rule_type>CALCULATION</rule_type><expression>// Build a street-only address (no city/state/ZIP). // Fields: AddrNum, RoadPrefix, RoadName, RoadSufix, UnitType, UnitID function clean(v){ if (v == null) { return ""; } var s = Trim(Text(v)); return IIf(s == "", "", s); } function addIf(arr, v){ var t = clean(v); if (t != "") { Push(arr, t); } } // Main address parts var parts = []; addIf(parts, $feature.AddrNum); addIf(parts, $feature.RoadPrefix); // e.g., N, S, E, W addIf(parts, $feature.RoadName); addIf(parts, $feature.RoadSufix); // e.g., St, Ave, Rd // Unit info (type + id) var unitType = clean($feature.UnitType); var unitID = clean($feature.UnitID); var unitBits = []; if (unitType != "") { Push(unitBits, unitType); } if (unitID != "") { Push(unitBits, unitID); } var unitStr = Concatenate(unitBits, " "); // &lt;-- Arcade equivalent of "join" var baseAddress = Concatenate(parts, " "); // Comma rule: // - If BOTH unitType and unitID exist -&gt; comma before the unit // - If only one exists -&gt; no comma, just a space if (unitType != "" &amp;&amp; unitID != "") { return baseAddress + ", " + unitStr; } else if (unitStr != "") { return baseAddress + " " + unitStr; } else { return baseAddress; } </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>Calculates the half address for a site address point by concatenating several other field values</rule_description><field_name>HalfAddress</field_name><exclude_from_client_eval>False</exclude_from_client_eval><batch>False</batch><severity>-1</severity><tags>Half Address;Street Address</tags><category>-1</category></AddAttributeRule><ReorderAttributeRule><rule_name>Half Address</rule_name><evaluation_order>3</evaluation_order></ReorderAttributeRule></workflow></operationSequence>" UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.3.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e686751373173733744576a57324632303371514e6857562f484e53513038725351366a574e6b6435305975513d2a00;ENCRYPTED_PASSWORD=00022e6838345039664a3742744f5a467845373330496d636b57426c4f653531424147716a4f59437079657a4b44453d2a00;SERVER=gsdb;INSTANCE=sde:sqlserver:gsdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gsdb;DATABASE=Citybase;USER=GIS_Portal;AUTHENTICATION_MODE=DBMS;BRANCH=sde.DEFAULT</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS_PORTAL.Addresses</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Full Address</rule_name><rule_description>Calculates the full address for a site address point by concatenating several other field values</rule_description><exclude_from_client_eval>True</exclude_from_client_eval><tags>Full Address</tags><severity>-1</severity><expression>// Helper: trim; convert null/blank to null function clean(v) { if (v == null) { return null; } var s = Trim(Text(v)); return (s == "") ? null : s; } // ---- Inputs (cleaned) ---- var num = clean($feature.AddrNum); var pre = clean($feature.RoadPrefix); var name = clean($feature.RoadName); var suf = clean($feature.RoadSufix); // spelling as provided var utype = clean($feature.UnitType); var uid = clean($feature.UnitID); var city = clean($feature.CityName); var st = clean($feature.State); var zip = clean($feature.ZIP); // ---- Street line ---- var streetParts = []; if (num != null) { Push(streetParts, num); } if (pre != null) { Push(streetParts, pre); } if (name != null) { Push(streetParts, name); } if (suf != null) { Push(streetParts, suf); } var street = Concatenate(streetParts, " "); // Optional unit: only if BOTH exist var unit = null; if (utype != null &amp;&amp; uid != null) { unit = Concatenate([utype, uid], " "); } // Start with street (+ optional “, UnitType UnitID”) var base = (unit != null) ? Concatenate([street + ",", unit], " ") : street; // ---- Locality (City, State ZIP) ---- var stateZip = null; if (st != null &amp;&amp; zip != null) { stateZip = Concatenate([st, zip], " "); } else if (st != null) { stateZip = st; } else if (zip != null) { stateZip = zip; } // Build the “City, State ZIP” piece, skipping blanks gracefully var locality = null; if (city != null &amp;&amp; stateZip != null) { locality = Concatenate([city + ",", stateZip], " "); } else if (city != null) { locality = city; } else if (stateZip != null) { locality = stateZip; } // ---- Final full address ---- return (locality != null) ? Concatenate([base + ",", locality], " ") : base; </expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</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/3.3.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e686751373173733744576a57324632303371514e6857562f484e53513038725351366a574e6b6435305975513d2a00;ENCRYPTED_PASSWORD=00022e6838345039664a3742744f5a467845373330496d636b57426c4f653531424147716a4f59437079657a4b44453d2a00;SERVER=gsdb;INSTANCE=sde:sqlserver:gsdb;DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES=gsdb;DATABASE=Citybase;USER=GIS_Portal;AUTHENTICATION_MODE=DBMS;BRANCH=sde.DEFAULT</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS_PORTAL.Addresses</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AlterAttributeRule><rule_name>Full Address</rule_name><rule_description>Calculates the full address for a site address point by concatenating several other field values</rule_description><exclude_from_client_eval>True</exclude_from_client_eval><tags>Full Address</tags><severity>-1</severity><expression>// Helper: trim; convert null/blank to null function clean(v) { if (v == null) { return null; } var s = Trim(Text(v)); if (s == "") { return null; } return s; } // ---- Inputs (cleaned) ---- var num = clean($feature.AddrNum); var pre = clean($feature.RoadPrefix); var name = clean($feature.RoadName); var suf = clean($feature.RoadSufix); // spelling as provided var utype = clean($feature.UnitType); var uid = clean($feature.UnitID); var city = clean($feature.CityName); var st = clean($feature.State); var zip = clean($feature.ZIP); // ---- Street line ---- var streetParts = []; if (num != null) { Push(streetParts, num); } if (pre != null) { Push(streetParts, pre); } if (name != null) { Push(streetParts, name); } if (suf != null) { Push(streetParts, suf); } var street = Concatenate(streetParts, " "); // Optional unit: only if BOTH exist var unit = null; if (utype != null &amp;&amp; uid != null) { unit = Concatenate([utype, uid], " "); } // Base (street + optional “, UnitType UnitID”) var base = street; if (unit != null) { base = Concatenate([street + ",", unit], " "); } // ---- Locality (City, State ZIP) ---- var stateZip = null; if (st != null &amp;&amp; zip != null) { stateZip = Concatenate([st, zip], " "); } else if (st != null) { stateZip = st; } else if (zip != null) { stateZip = zip; } var locality = null; if (city != null &amp;&amp; stateZip != null) { locality = Concatenate([city + ",", stateZip], " "); } else if (city != null) { locality = city; } else if (stateZip != null) { locality = stateZip; } // ---- Final full address ---- var full = base; if (locality != null) { full = Concatenate([base + ",", locality], " "); } return full; </expression><category>4294967295</category><triggering_events_insert>True</triggering_events_insert><triggering_events_delete>False</triggering_events_delete><triggering_events_update>True</triggering_events_update></AlterAttributeRule></workflow></operationSequence>" CalculateField Addresses ZIP 99301 Python # Text NO_ENFORCE_DOMAINS Server=localhost; Service=sde:sqlserver:localhost; Database=Citybase; User=GIS_Portal; Version=sde.DEFAULT ArcSDE Connection GIS_PORTAL.Addresses 002 Projected GCS_North_American_1983_HARN Linear Unit: Foot_US (0.304801) NAD_1983_HARN_StatePlane_Washington_South_FIPS_4602_Feet <ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.3.0'><WKT>PROJCS[&quot;NAD_1983_HARN_StatePlane_Washington_South_FIPS_4602_Feet&quot;,GEOGCS[&quot;GCS_North_American_1983_HARN&quot;,DATUM[&quot;D_North_American_1983_HARN&quot;,SPHEROID[&quot;GRS_1980&quot;,6378137.0,298.257222101]],PRIMEM[&quot;Greenwich&quot;,0.0],UNIT[&quot;Degree&quot;,0.0174532925199433]],PROJECTION[&quot;Lambert_Conformal_Conic&quot;],PARAMETER[&quot;False_Easting&quot;,1640416.666666667],PARAMETER[&quot;False_Northing&quot;,0.0],PARAMETER[&quot;Central_Meridian&quot;,-120.5],PARAMETER[&quot;Standard_Parallel_1&quot;,45.83333333333334],PARAMETER[&quot;Standard_Parallel_2&quot;,47.33333333333334],PARAMETER[&quot;Latitude_Of_Origin&quot;,45.33333333333334],UNIT[&quot;Foot_US&quot;,0.3048006096012192],AUTHORITY[&quot;EPSG&quot;,2927]]</WKT><XOrigin>-117498300</XOrigin><YOrigin>-98850300</YOrigin><XYScale>3048.0060960121928</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.0032808333333333331</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>2927</WKID><LatestWKID>2927</LatestWKID></ProjectedCoordinateSystem> 20230720 18535600 20250716 14544100 20250716 14544100 Site address points represent the location of site or service delivery addresses. Site Address Points X-Ray Addresses and Names NaN NaN NaN NaN OBJECTID OBJECTID OID 4 10 0 Internal feature number. Esri Sequential unique whole numbers that are automatically generated. SHAPE Shape Geometry 8 0 0 Feature geometry. Esri Coordinates defining the features. SiteAddressID Site Address ID String 20 0 0 addrnum Full Address Number String 20 0 0 The full address number addrnumsuf Address Number Suffix String 5 0 0 The address number suffix addrrange Address Range String 50 0 0 Address range when a point describes a set of addresses country Country Abbreviation String 2 0 0 The country abbreviation the site address resides in fulladdr Full Address String 500 0 0 Address information combined into one text field. In your community, this may include the following fields: PREADDRNUM, ADDRNUM, ADDRNUMSUF, FULLNAME, UNITTYPE, UNITID, ALTUNITTYPE, and ALTUNITID. placename Place Name String 250 0 0 A common name or vanity address for the site or service delivery address RoadPrefix Road Prefix String 15 0 0 RoadName Road Name String 30 0 0 RoadSufix Road Type String 15 0 0 FullRdName Full Road Name String 300 0 0 HalfAddress Half Address String 255 0 0 preaddrnum Address Number Prefix String 5 0 0 The address number prefix unitid Address Unit Number String 30 0 0 The address unit designation CityName Municipality Name String 100 0 0 State State Abbreviation String 2 0 0 ZIP ZIP String 10 0 0 unittype Address Unit Type String 10 0 0 The address unit type PointLocal Location String 30 0 0 CaptureMethod Capture Method String 30 0 0 AddStatus Address Status String 30 0 0 GlobalID GlobalID GlobalID 38 0 0 created_date created_date Date 8 0 0 last_edited_date last_edited_date Date 8 0 0 created_user created_user String 255 0 0 last_edited_user last_edited_user String 255 0 0 GIS_PORTAL.Addresses Feature Class 0 Microsoft Windows Server 2016 Technical Preview Version 10.0 (Build 20348) ; Esri ArcGIS 13.3.2.52636 Addresses Address Addressing Site Address Building Address City of Pasco WA Community and Economic Development C&ED EMS Emergency Services Postal Services Utility Billing ODP_Addressing OpenData City of Pasco approved and assigned address points. Enterprise Geodatabase Feature Class dataset EPSG 6.3(9.0.0) 0 Simple FALSE 0 TRUE FALSE 20250716 iVBORw0KGgoAAAANSUhEUgAAASwAAADICAYAAABS39xVAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAO xAAADsQBlSsOGwAAIABJREFUeJztnQd4lGXW/u/pk8ykdxIgISGU0CFIR4qiiIggoquruOVzV137 fn6ua9vPrp9/XXcti7qsLrsq6qoIdkAQpCfSew8tCek9M/O/7oPDomtJIJl6fl7vNW8mMXmZ5L3n POc55z5mj8fjQQDR2NiIv/71rzh27Bjq6+sxatQodOzYEd27d4fRaPT35SlKm/HFRWVwZJnQ/6lo fVVbiBkBxPHjx2G1WkWYhg0bhoULF2Lw4MGIjo5WsVIUJXAEi5HVm2++iSuuuAI5OTlYv349Ro8e jbi4OH9fmqK0DwG1tgkOAkaw9u/fD65OFy9eDIfDIZHVkCFD/H1ZitJuNFd7YI3RNEdQClZ6ejr6 9OmD559/HgMHDhSxMhgM/r4sRWk3mqs8MEfr33jQCRYjK+atli9fjhtuuAFOp1METFEUJeAEq7q6 Gh9++CHq6upEuHr06BEQIkoY5bnd7pPRHs9NJpN8nue8XpfLJZ/j8xoVKkqIC9bKlStRUlIiQvXp p5/KktCfUIiYSzObzbI0feONN3DWWWfJdVKcxo0bhzVr1qC4uFhybQcPHsTSpUsxc+ZMKb9QFCWE Besf//gHzjnnHKSkpMhjIER8jz76KC677DJs3LhRxIi7lf/6179kycrr5fPXXHONiNjFF1+Mhx9+ GA888IC/L11RQhq/ClZDQwMKCwtx3nnnoba2FqmpqVJz5W94DbfeeivKyspw9dVXy1IvJiZGoqwv vvgCVVVVsFgssNlsqKmpkXKMO++8UyIyRVHaD7/dYcwBHTlyBJ9//rksBy+44AKpaA8UKFLMT/Hg OcWoQ4cOKC0tld3MTz75BKtWrULPnj0xf/58WQ4qihKigrVr1y6JTBitMFFNUWCVuy+obahGwb4v pXIvK6k7OsR1wtGKIuw8ukmEdFjuORJNNTc3y9dzyWe329G1a1cpcE1MTJSiVkaFSUlJknuLiIjw ybUrSjjjN8HicooFohSqvn37Ij8/32c7bIfK9+OzTe+iqq4cMZEJSI3JwOHy/aiqr0B9Yy2yk3si Le7f0V5CQoI88nq9xMbGykE6derkk+tWlHDH54LljVq4C8flFYUrOTnZZ9EVMRiMMBlMeG/dHFAj 450pOF51FOytHtNzipYmKEqAYvZHg/PcuXORmZkpJQJsyenVq5dPRaJjfBaG5o7HK1/8EVlJPXDH hY/joXdvwb6SHZiWfw0So1J8di2KorQc86FDhyQn44sIh3YxPJgf+vLLLyV5fe655/p8d81qtsFh i5Lz0T3OR3VDFS4bei0enXc7Yh0JMJssPr0eRVFahvn999+XXAyLNbOystrVxqWyshKvv/66JK4z MjIkqmIpg68pqynB5oPrYDQAe4q3Y8eRTUiLPZGzWrXrc+Sm9oHTfkLQFEUJHMxXXXUVdu/eLd5T 3CG79NJLpeaorZdoXP6xyJLFoYzquAzs1q2bX3yuSquPoaK2DFERcVix430YDEymexDnSMSGA6sl Ga+CpSiBh5nb9awl4kEPqnvvvReTJk0Sp08mxNsK7gZOmDABs2fPliQ7f5a/WnCYcN9+ZAOGZI/F 2F6TMSxnPL7avxLzC1+T8gZeq6Iogcc3kkfMKbG9hEWRL7zwAgYNGiSRUFtVnxcUFEjx5cSJE/3q IJqRkIWHZ7ws53ZrJGxmO0Z0m4DB2aPluZjIeL9dm6Io389/ZLujoqIwdepUaehlg++cOXNEyFgn dSaJeZYzbNmyRSI3f3uzW0zW/xClCGukHIriC9yNHnjcgDlS/bBaw/duzzEpzmiIiXI2/fK46aab TibLWwvFik3FTOwrJ/oon376adx8883Yvn37yZaft99+GyNGjJBcHzsBuIxmRT3r1thz2blzZ335 QgBXHeBu9sAar46jreEH6wkYCXEHka4EbKWhzUpubq4sEylcbABuCRUVFXj22Wfx2GOPaVHm1zBy ffLJJ3HJJZfgz3/+s1TLc/d07969+Oqrr9ClSxepWVu0aJHk+iIjI8XgkF+nnlshgPq5nxYtLoDK zs7GtddeK3ko3jhcHo4cOfJHyxK488jojFYtXG4qJ6BQ/fGPf5S2H+b0uFPLYlpGotyQ4OtL0Sov L0deXh62bdsmEarXQFBRwpFWVWzSupgiRWdQLmNefPFFScyPGTPme3cUi4qKpMGZ/5/yb7yjyxil ehun+cgi2n79+snSb8OGDTLu7KOPPpKCW4pVgI2RVM4UTWG1itMqMeeNxYZl1lEx50KzO0YJLI3g 0uXbtVe86fydaPc1RyoOoq6xRqrm02M7o765HiVVR+Byu+C0RSEpOk1M/xhJ9e7dW5Z6NAnkkpu1 cHxzWLFihYhXU1OTRLZ8c1DPrRBD339axRn1xLCG6yc/+QmOHj0qxnZbt26VG443IEXt8OHD4nUV CC6ivuadNX/D7mPbpAiV5RIVdWVSXZ8W1wm5qb1xxfDrJaFOmGDnQcaPH3/ye5x99tknz9nCpCjh Tps08fFmu+iii2T5x1IIWgrTkO+zzz7D8OHDA8JF1Nc0uZqw+9hWbD20Git2LYIBBjQ2V2FY7gXo 2+ksf1+eogQlbdZ1zKUK8y48GFk9/vjjOHbsGK688sqT02XCiTE9J+HzLQvQ5AJuv+B/ceD4bsz5 4hl4PG6c0/tif1+eogQl7WKTkJaWJlv23JJnszNnDLIUghbI4SJcMRHxkr9KcCZjcM7ZcO1oRpwz SUoSIq26W6oop0O7+rowB8OkMbfk33vvPandYi7mVOfOUGXV7s/FvTTC6sAzH92LxuYGiTS5VFy9 ewmG5Izx9yUqStDRroLFaII7X5ztxx0uRlz33XefTKLhjmIoR1v7S3bCZDLjWOUeObzQHJBGgSpY itJ6fOacxxwXdwvZfvLWW29h9erVImQsjmxLV4hAgYMtxvWcjIl9ZyC/yyhU1JZi/YHVSIxKRYIj yd+XpyhBic8tkrmjeN1110nhKVtQli1bJsLFicmhVGN0bu9LUNtYDbvFjgRniiwJc9P6wOVuVjcI RTlN/KYQrNfijiLrtNi6w1IItu9wCRkKxDkS5DjVljklJt2v16QowY5fQxouBbmD+Otf/1o83p95 5hmMGzdOxIw9dqGc41IUpfUExBqMzby0VOFAUi4RFyxYIKUR9M5iNb2ihCzaSxh8guWFUdWFF16I srIyFBYWivspPx4wYECLrWyUH4YWNvTionMGbX/o38/Gaja085zN1fyYPaH8PdB4kct0ff2VQCCg BMtbChEfH4+xY8fKODB6wDO/xYZgRl1645w+FCg2XHNzg/nCG2+8UZwg/vKXv0iT+oMPPigf05Pr nnvuka/5+c9/Lst0joJT2g6PywO4AaO+Dwe3YJ0KC0yZ39q8ebPcSOxJ7N+/v7iWqnC1npqaGuk2 YOsUXSK8BbyMqJgvZJRFaNpIpw1+Lf8f+nCpYLUtzdUeuJsAe4p6m4WMYBHeSGzrYSJ+48aNYh7I AlS++3MJo7QcWl4zT3jkyBF5PRmxEvqVeXtA6Rbx7rvvyvN33HGHRLcHDhwQc0FF8TcBL1heGBEw l8Vjx44d4i/PxurRo0drtNUKaPvjLR1h1MQlOB1NlyxZIrVwzFnxjYCP7AdlNMuxb4oSCASNYJ1K 165dJe8yb948yXHxRmMFPZeM4ex33uxqwqzFj8Fpi0b/zGGIdyZh55FN2F+6S5qxz8o+G0OHDpWD PPTQQ/LIaJWHF+atyPPPP++nf4mihJBgeSOuiy++WKZIb9q0CXPnzhXRYgQWShXzrcHtcWPplg9Q 3VCFeevmwGK2oqahGg1NdTi/73RkJXdDckwHf1+mopw2QX1nM79FBwgWnzIvw4r5+fPnY+bMmZKT CbfCU6PBiNS4jli0aR5qG2swusdEbC4qQK2IVoNEXooSzAS1YHnhMpAJZPYo7tmzR3zmKVj0kmfv YrhMmaH/1uT+V4pgdU/rgxvOvQ9//OheLN36Afp3HoLMpK7+vkTlW1buaukehoJ1KkwSX3/99Vi7 dq1YNHPpyJwNt+hDPb/Fos+ymmI5H91zEgr3rUBqTDpMRqDR1YiG5nrYzNo5oAQvISdYhO08jK44 DGPfvn0ScXHCD+1tQjm/1exuwnvr5sj5mytfko9pyez2ABsPrEFOSk/kpvX292UqymkTsncvoynu GlK0cnJypLaIVd6TJ0+Wj0PR9ZQRFv/LSu4Ok9GECIsD1Q2VqGmoRFREDJpcjf6+REU5I0JWsL5d e8Rt+4MHD8o4snXr1onjKavmuWQMFShS5/e9FNERceifORSpMRnYeXSzHBSr5GjdIVSCm7AQLC/c UeSIeK9wsX+OswFZ1xUKO4omoxkzhvzXN57jMpCH0npqa2tl55mzNzmFm+kEphZY/8ed6ezsbHz8 8cfS87pr1y7s378fqampknrQ1rH2IawEi/CPjm0mPJjfYuEp//A4V5HTlkM9MR8MsLeR7UDcKOHU a9ba8c2GosFHthjt3r1bHCW47N+5c6cMO2lLWOn/2muviWPI+eefL21KjNKTkpJEsPg388Ybb8g1 UrR+9rOfySOvNZTzpP4mrF9Zlj7cddddEm2x8JQfc6nIUohQiLiCFd74FAUOLGG1PRuwudO7fv16 ERJGyffffz+mT58uVjn8eopHW8JSGH7/v//979KqdMUVV0hqgfB6+HMplLwuRla07eGsAnYP6Jte +xHWgkX4bshxZMxnFRQUyI1Ce5vzzjtPRGvLli3ybkoHA8U3cInO4SSEv4cPP/xQ3CP4u6JgMcqh UPBjNsazIb6toejQM4zCxYOiRVHyOldwg4ON5FwKsjeT1j38PN/sWvT9v/WotIywFywv/INkIzXL IWhlQ28oihQHZLAsYurUqfI1+u7Z/jAP5J2kxDcLvuYsCB4+fLg0abNshbu8zBNRPE53CVZVXyFD QSxmGxxWJ1wel3QF8Dmr2Y5IqwO33367fC2XnF7LnRkzZsibGiNyOuTyc7xe+ovp30f7ooJ1Cvxj 464h3QmYVN26dasUoLIMgksO5jL4B6ucGUcrDsoUIevXE4XMRjOKyvaemCgUEQ+7PQL5+fmSU2SU S/tsRlKMtGh/wwhr4MCBkr9iFMSNk9PhTx/fL7un3F0d02OSCNjyHZ/CbnUgLjIBvxr3u5Pf+9Tf +8iRI0+en/qzBw8e3OKf7W4EPG7AFHrVNe2KCtYP1HAxZ8GD7+6c7sN8hvddlAlf5fR4Z80rKK87 jrrGWvTo0Bd2SySWbf8E0RGxGJg1QkozThUFTgsnTGx7YbTlZdq0aad1HdX1FaisK8eq3Uswv+A1 qWFzezwYnjseMfb2TQE013rgafbAGq+50taggvUDLT58hy8uLpY8Bd/hWQbxyCOPyLutd4mo29et x+VxY8mWBTh4fB/e/Xpzw+2uRt9OZ/u0Ev+cXlPxyhdPo7ymBFeOuFHamuYX/BOHyvZj5shbfHYd SstRwfoemGhlLoUHxWvNmjWSCHa73SgqKpJoy2txwzyKt8Fadxd/nPF5F2HuyllobK7FT0fcjL0l O/D5lvmItDnRK2MQfMXg7NF4feVf5OfOHHUzCvYux5c7PpXP9e6Y77PrUFqOClYLYKTFJQgthFev Xi0ixlqhyspKvPrqq7LLSOgYwfyKjib7YbxRVIe4LPRI74dpg3+GtXuWIjYyAV2Su8FXbDy4Bk3N jUiPy8S8gjk4Xl2MKPsJ2+3NRWuR50PxVFqGClYL4dKvU6dOsoVdWloqOa4nnngCycnJ2LZtmyTo J06cKM+rYP0w6/evkkfuwi3cNA87jm6CwxYlZoN0R81N9c2y8IOv5qKxuR77SjbiuU82SokBG8Vz U3tJ8l0FK/BQwWol3JXiQdiCwWp51uZwa/uDDz6QCIy7WnQ+ZXJet7n/k2XbPxax2lO8EXtLNspz Hg9wvOaYWOL4SrDoRtWn81liJ92n01mobazGpgNrkRbbETWNVT66BqU1qGCdAWPGjJGcFgtOmZBn Yt67TGQUxuQ8e8/CxUCwpURanbho4E9RXHUUXVPzYDNHoGDvMtitkXBYT7wZ+ILLh/4aRyuLEOdI lNxZXWMNMuIyxeEiIz7LZ9eh+EGwGGVwq583MPu/WA7Am5dLKZ6zlYHVwYw4OFaKS6tQuJGZZGdN EPNXrHZmuwYPFjgyGc8lIqufmf/irqKOJgPO6zsdNQ1VsFnsSI5Oh8VkwYDMoWIwGBeZ6NNc2qm7 khFWh0RbSogLFnupfv/73+Opp57C66+/LoLF3bM//OEP4kc1ZcoU8aLiNGd2wHMEOgXr6quvRqjA hlwezGnRX96bmGcZBNt++JpQqG+77bawXyqmxKT/x+vXMSHbL783JQwFizfi8ePHJYJiTocRBWuX GGGwjonRBvM+nCzMkfMczvnOO++ElGB5SUhIkAJHTvJh6wZ74djpz7wW++BWrVolgkZ3CM1vKYof BIsOB2wEJZdffjk+//xzSULzxiwsLJQlE/u92BzKeiZ2tHtn4oUiXOpy5JgX1nEx2uLSeMGCBSJk jLhCyTxQUYJGsBgpcInHfA5vQuZtvNEE+/DoYcS8DmFkxecYbYULHExK00Dm9/jvZl7vhRdekGiz pd39iqK0ULA+3vA2DpfvF+vd4V3Hw2Sy4LNN70pnO3dTxveagltuuUXqjyhWrAhn9zrzVow2GF2x SZRLRjYWU8zCqaWFnf08uHTmv5uTquntRK8nRqcsSg2ncWSK0q6CxS1n1sl8UPgGFm9+XyKqI+UH 0b1DX2w7vF4Ey2tu5vUPIl6LEOJd/pz6XLjBPF5eXp6cMxHPMgi6QdCFgLkvWu0yaa/tPYpyBoIV 70yWgr6CfV9KUZ3NEoG9xdsRYXOit7YvnDaMtihSrNVipfwrr7wi5nVM1HvfABRFaaVg/XLMHbju r9zVAm6Z+CActhjc+LeLxNDn1omhmzz3Bd78Hx00uTnBcWR/+tOfpCyEuT9GpLqbqCitEKzKujJ5 7BCbiYYmTg+OQHZKbxmzXV5TilhHQku+jfIjcNlMH3GWhLAUhGLFJSTzXOGU81OUMxKsf635m4gT hWvWwkcZFqCytgwJzmTMWf5nXH/OPS35NkoLoS0wG61ZkMsyEJaJsG6LrT6a3woNXPU08AMs0Wrg 1+aCxQT7gMxh2FO8DQYYxTk/zpmIvp2GiLWt0vYwoqJw8eDIq+eee052F7lU9DZfK8GLu8EDj8sD S4yOoWhzwerXeai4MTKSGpozFmajBUu3fYiq+kpkJeW26gcqrYeR1T333IMVK1bgxRdflKJUHuwk 0PyWEk60SLBYtsABAbw5zCYLDDCI77bb4xYDf6X9YY0bjQJZCsFlIpPzbLimY4T6yyvhQosEi6L0 bWGicCm+h1EVhzJwmCcHwHIyMYd8sjVK81tKqKN+WEEIhYl5LI4dYwHqe++9J5XzLItgsl4dT5VQ RQUryKGNDV0vNm/eLFXzX375pThDsD1K81sBDLfdlVajghUCsF6LkRbrtXbs2CEN5lw6Tp48WYpS FSVUUMEKMeFiUp6tPvQcY8U8E/W0+uHkH424AgitZjgtVLBCtIaL7q6MupiYZ8TF3BZLIWJjY1W4 AgFdEp4WKlghDJeDHD1GP/mNGzdizpw5YmVDIVOUYEQFK8Sh1Q+bqHmUlJRIxTwLUKdOnfqNidWK j9El4WmhghVGUKDuvPNO2U1k4Sk9uFgKQTGjyaLiQ3RJeFroX2mYQWGiBxddIFgKsWjRIknWcyis tvoogY4KVpjCXcP8/HyZUL1s2TI8+eSTIlpM1itKoBKSgkXP+PLyctkR4zmHvHKAKaf48EZ1OBw4 evSo+M9zq58DUJOSksKuQlx6Q81mjB49WkofFi9ejGefffZk4SlfK0UJJEJSsBYuXCjb+TfddBNe fvlluSm5BKK/FCfXUJw4vYYCxnOO4OKO2iWXXIJwhYJOz629e/di3bp10mDNeq7BgwereaASMISk YLHPjv12jK44E5Bb+hyzxUhr27ZtMnn6wQcflNmInBHIm3T8+PH+vuyAIDMzUyZYczDu+++/L6Pa ZsyYIc8pbYfHBRjMulXYWkJSsDjIgXkZwgiByWW2qXDJQ+FiRMWDg115TJkyBZ9++il+8pOf+PvS A8aqmT2KnKdYUFCA2bNno3fv3pLzYkSqpRBnTlOVmveFjWDVNtbA7XbBbDTLBB/mYqrrK+VzFrNV bjjmYPjISIsCxuiKy0EKGH2k6G5AmxYuBfk5nivfhK8rk/J8/bhE/Pjjj2UMGV9DzllUFF8TlII1 Z9kzKKspRYfYzpjQdxoirE68sPBh1DfVIS99ACYPuFJGZTGJzuGtjK68Q15pdkchY1Lem1Smt5Ta Dn8/fG1oFMjNCQo9p1Yz4uJz3MBQFF8RlILV0NSAqroKvLFtFuaunCVlwx540KfTYBw8vkeiqlNd OL031alRwann3iGvyo8n5keOHCkR1rx582Ry9YUXXih5Qp3q00o0fRU+gtU5IQdzV72EI+UH0Ltj PlxuFzYXrUNydBoGZo3w9+WFPCw0nTZtGvbs2SO5v8LCQtlRzM3N1QGwSrsSlII1vvfFeGLBnYiw OnBe3+nIiM/CTa9MR1JUGsblTfb35YVNfot5wp/+9KciXJs2bZKNDm5g6I6i0l4EpWB5PC6ZQs3o Kj0+Cz0z+iMzsStMJjMMBv818xYVFaGpqUlKA1g+wSUUE/r79u3DsGHDZIeS5/So4g2/YMECWVIF MxEREWIcSE/5nTt34oknnpDWn0mTJml+S2lzglKw3lg5C2aTFVsPFeLuN34Jh82JyrpyFB3fi7dW vYSZo27x+TW5XC5pLB43bpwUpD799NMSfdDShTuQdEk4dOiQlAuwlIJlFbfddlvQC5YXCjB3E1nb xvIRlkL07dtXZimyyVrNA5WwFazS6mIMzBqOoxVFSIpKhcloxv7SXUiJSUdVfYVfromJfhafMoHP CIu+U6ywp/dUbW2t1DPRRI+5Hlbhs5yC/w+FLpTqmrgbO2HCBJSWloorBItPWZzLqEvHkSlhKVic Ql1afQyxkQkiXHZLJD74ai5cHheyk7v75ZoYQTB6YhV9SkqKLJW4czZo0CC5eblkKi4ulmUhRY1C xXIKVtlzunMowdeCzg9spubrwYiL48guvfRS6VlUlLASrDE9/3MZNTV/Zrv+zOqGShwuOyDn8c4k EUtOwz5eXYwmd5PUf1F4uNTzFlwyiuJQCBasXnfdddIixDzXzJkzRdBYFxZqYnUqjCC5HOSOIssh XnnlFanjGjVqlCTmw7mcxOI0oKlCTbHCQrD8wZ5j2/D51gXYfLAA6fGZ6BDXSXJmRysPob6xFrN+ seAb4uO1Ieby0AtdEE6FIhYusEKezegsgeBuIkWd9Vys4QqlJXFL4d6Qp1kFq7WoYLUQl6sZlbXl WLb9EzYHnXzeaU9Bx4TQjZLaEu8SmbuKXBqzhovLZ/rOs7YrnDBFGqT5ufG4B9Z4rSJtKSpYLaRz Ug5yUnqgvqkW3dL64Ppz7sXv3rgGdY21OL/P9Ba/4OEOIyt2HnDzgcn4Tz75BHfffTcuuOACWUaH yzgyk80gUVZTlRvW+PCLME8XFawWEudIQpQ9BiYjMKjLSNgsdlzQ73K8X/AP9MwYcNq/gHCGO4os 6+CO6pIlSzB37lypUWNBaqhjdhpgtBjQcMwNR2cVrJaigtVCisr2Yl/JTpiNwMHje/GP5c8iJvJE P+Lize8jv8uoFr/oyjdhXycLTQ8cOCCJ+nDA5DDAYAEaStz+vpSgQgWrhRRXHJZSiiYXsHTrfKm0 93iA6Ih4rN1zwntLOYM/RLNZEvDhwskIq1gFqzWoYLWQCJsD8VHJmDJoJjKTcpGZmIv9JTuxt3QH ahuqW/WiK4rZYYDZAdQdVMFSwWoHKFDn9LoYbo8LiVGpiHckoaL2OI5UFOndp5wWkR1NqNnj0lev FWiE1UKYZM9J6fmN55jD8uaxFKW1WJOMqFXBahUqWIriJ5yZJhz7tPHEFOjQr+RoE1SwFMVPOLLM aDzuRlOFG5bY8NgdPVNUsBTFT0SkG+FuAuoPq2C1FBUsRfETji4meNwe1B1xI6qH/hpaggqWovgJ W6IRNibe9+tOYUtRwVIUPxLbx4Ka3SpYLUUFK8ThLMGSkhJpNKZFM431aB7IwRHs2aNLAk0EaYND g0F+LW2Nw9mrypdE55lRe9B1YnS9thT+KCpYIUxVVRVefvllsXKh2+esWbPw29/+Vmxdtm/fLg4J hw8fFseEe++9V1xBOXSWvX0ZGRn+vvywIH6wBbvWNMluIZeHyg+jghXCMErKy8uToRi0b2avHt1P 6YrKo66uDvn5+TKGno3Hx44dE/95Cp3iG2J6fl3aUO6BLUlf9R9DBSuE4XKPBnl09KTjJy2ZyYYN G2TMfHl5uXjN8/McScaDX//VV1/J80r7Y44ywGg1oLGMPYW6JvwxVLCCmCZXIw6XH4DRYESCM1kG y9Y11oirhNvjRmpMhniqDx06VNwQ+vTpIz7zt956K5YvX46xY8eKWR791jm1eerUqRJlcXiE4hso VrSaqTusTdAtQQUriGHz9cuLnxCh6pjQBcnRaSiuPIKdRzchwurEtMHXIDM9F2lpaRJFUZi80316 9ep10nuK05r5+enTp8uSMRw91v2FyQZEdTWhamszcFF42USfDipYQQzFpaymBPML/4lmt0siLY/H DbfHgwm9p6G+qU4EyitAp5rjnXru/fypX6v4LsKK6mZG8aJGfclbgApWkHt0DcgagQ/XvwmnPQZX j7oZc1fOwrGKQ+iUmI14R6K/L1H5MQyAM9uEfa+44HEDBt0o/EFUsIIYesyP73URHnr3ZozIPQcT +85ATX0lZi/5f8jLGISUGC1NCAYcmSa4GoHqXS5ZHirfjwpWkCfdtx/eIOdZyd3xzMf3ITU2A3YL feeCXzAjAAANz0lEQVR343hNsRgNKoFv5GdLMODQu/XodrvD35cT0KhgBTFl1SX415q/wWoGXlr8 wMnn6TVPIRuYNUIFK0hmFMb2teDg2w3odptDvbF+ABWsIMZoMsHj8WBs3nRkJXVDUlQqiisPY1NR ASwmGywmba8JFhKHW7Hj/2pl7JctRRNZ34cKVhATExGPq0bcCIvZhsykroiNTEB5TSn2luyAy92M 9PhMf1+i0kIShlvksXhZEzKmannD96GCFcRYTBbkZ4/+xnOxjgT0cyT47ZqU08OebETSeAuKP29Q wfoBVLAUJUDIvCoCu1+sk1mF2gj93ahgKUqAkDrRhm1P1qB6p0sF63tQwVKUAMEWb5SlYeXWZiQM sehu4XeggqUoAUTyGBtKljWh0+V2mOw6++vbqGApSqBgAOIGW3DgzXo0VXpUsL4DFSxFCSDYmmOJ MqDkCy1v+C5UsBQlgIjoYEJsPwv2/LUOGRfbNI/1LVSwFCWA4CCK5LFW7J1dgZp9LmmMVv6NCpai BBhJZ1thiTPgwGv16P4/2gx9KipYihJgMIeVc0Mkit5uQM5vImF26G6hFxUspV2prq6WMWPZ2dky 95DTeugzv2vXLnmkXTOn9vTr108+z8EYHTt2lM+FMx2nR2D3C3UoXd6IlHO0t9CLCpbSrsybNw8r VqyQwRdPP/20zDukIHGoKwe6csDr448/jn/+85+orKwUIVu4cKF8fTgT2dGIuAFmFC9pQtJoq1gp KypYSjszcOBAmSxtt9tlmOuiRYtkcg8Fqn///jIY46WXXpKv5WixZ599VuYnKkD2tZHY8lgNGss8 sKeoYBGNsJR2JTY2VkaM8eBEaQ66WLt2La666ips3rxZnufgC0ZbL774IrZu3Yq77rpLfyu0Ts4y obnCjdIVjUi/yK6viQqWcqZwak+zuxk2sx1Rdg5qNaCk+qh8LiYiDpGRkRg8eDAiIiJEsIYMGYIO HTqIWI0YMUKGu06bNg0Oh0PE7brrrpM8lwLYO5iQOsGGvbPrVLC+RiMs5Yx4cfFjiLQ6EedIQn72 KHaX4O3Vs+Fyu3BW9tkYmzdZhIlRFEWLS0COGOOyj8/x/Morr5RzLhk5uuzUEWThjNECpE2yYc/s OpSuaDrREB3mqGApZ4TVZMM7a15BeW0pzCaLCBXgwYDM4ejWoc/3zj20WP5983FZeOqj8m9i+1gQ k2fG1oerMfTNOBGxcEb/QpQzol/mUDz76QMwGoCLBs3E+v2rsOvoZkRFxKJrSi99dc8Qgxno8Xsn VlxWjvLCJsTnh7diqWApZ8SI3HPlsVNiLsb0vBAju52HW/9+GTrEdUaPDn311W0DKFJx/c0oeqdB +gzDOcpSwVLOiOqGKnnMTu6BXcc2o2/Hs5AS0wENTXWoaqhEXGR4F4C2BZwGnfMbBzbcWYXOP7Uj unv43rbh+y9X2oR/LH9W5iIu2fYuFm95FxHWaNQ2VMpcxKVbPsDkgVfqK90GxPYzw5poxOH5DSpY inK67C3ejuG5k+CwRaFXxiCYjCZ8uvEdRNqcaGxu0Be2jbDEGJExzY7tT9Wgyy8iYYkJz0JSjbCU M+I3596PZnejlDYkOFNkJ3BUj/O5UYgEZ7K+um24LEybaMOu52qx9dEa9H7IGZavrQqWckZkfMew 1szEXH1V2wF7ihFZP4vAhruqkXlNhLiThhsqWIoSRHS63I6Dc+uxZ1Ytej0YFXY7hipYihJkuaye 9ztRcEMV0qeGX/W7CpaiBBmJQ6xIOvuE73vcwPCqy1LBUpQgrH7PmGrHuhsqUbmxGbH9w+c2Dp9/ qaKEEPGDLEg9x4r1d1Vh6GuxsESHR5mDCpYSNng8Hnlk6QXPvY+nPvdd54GIKdKArjc58PGAUuz+ Sy263eYIi5FgKlhKWNDQ0IBly5YhPT1dvLe2bNmCMWPGoLCwUHzkx40bJ26o9JLPzc3F4sWLkZaW hry8vG84SwQSkZ1MyLvXiX1/q5MareieoX87h/6/UFEAbNq0CbNnzxaRIp999pmYCX7wwQfYsWOH 2DO/+eab4jdPm5tXX31VjAc7deokxoOBStY1EShZ2ojdL9ai94NRMEWEdpilgqWEBX369MGwYcNg tVrFRJA2zTQKpLspJ/vs3r0bUVFRqKioEM+u0tJSed7r3xWomJ0GmV1YcFMVKjc3y65hKKOCpYQF Xl95Hlzi8bG5uRk2mw1dunQRK2cKFCOqoqIiGZDhdDpRW1uLmJgYBDLRPc1IGGqRCvizXo2BLSl0 HVtVsJSQoKquAtuOrJfzPh0Hw2w0Y/exrSivOw6H1YnslJ4YPny4iBUFaPr06ZLLmjRpkowXo0Dx uaSkJBEwJt15npiYiEDHZDcg51eRWHphGbb9Xw3y7nPKc6GICpYSEhws24OP17+FJlcjDpTugtFg ws6jm8WXK8oeg4SoFHTv3v3kzh+Xh3ykUHmfGz169MlzJuG958GAo4sJg2bFYPnUMiSfbUXqeaE5 fFUFSwkJjDBiU9E6rN2zFK+veA4OWyyq68vlc7+Z8L8w8L9TxMd7/l3Pffu8LWlqasILL7wg+bOh Q4fi7rvvxvPPP4/XXntN8me9e/fG4cOHZZOAg2e5IcBBs9wE+DESh1mQeVUEtj9TK8tE7iKGGipY SkiQEpsuLhFrdi9F9/SBGN1jIv65/DkZQzY4ezSiI+MQCDQ2NspkoLq6Oimn4NKTMxmPHDkiu5Gr Vq2Ssgp+vqCgQD4+ePBgi79/7i2RWH1tJXb9pQ69Hwg9CxoVLCUkcNqikRSVKudXj7wZaXGdsHLn Iqzd8wUyE7vK3MRAgHmzsWPH4sMPP5QlKKMr724kl6EPPfQQunXrJhEeJ2avW7dOxItRV1pa2o9+ f3uqSfJZBTdXig88Tf9CCRUsJSQorT6GA8d3y/mRioP4ZOO/UPO13/yGA2skyqIranvDMWfMozFy spitkvxvdjWhydUkIkThZGkFB8hyWcjEPjcBKEYLFy7EjBkzUFJSIjuUU6ZMkVqxRx55pOW1YAbI 8NWsmZFYd0OVlDk4OptCpgpeBUsJCY5XH0NFbRkSo1Lx9y+egdvjlufperr+wCr0SO/vE8HadWwL CvYuR11jDXplDERWcndsP7weO45sFvvoKYOuQk5ODjp37ixf/9hjj8Fut+P666+XmjBGYFw2Ej7P gbNPPfWUlF+0FIMJyL42AtW7mvHVb6sw4I/RsKeFRqmDCpYSEjCaiXUkIL/LKEzsN0N2Br/Y9pHs HtJbnpGOLzhSfgBbDhXii60fyWxGh82J6vpKia5yUnrigv6XiXB6BYj1X4TRlrcFiELlhf+f92ta gzXBiN4PROHLy8qxa1Yt8u52hkSUpYKlhARdknvg/mkvyLndYpdoZkDWcDS7XDAZjT7LYfFnu1zN sjzlII54RxKKju9BdGQ88jIGwuQj4SSMqthruPoXFegwyYa4/pagFy0VLCUkMBqMcNgc33iOImXz 8V/4wKyR2FuyE2+snIVBWaPwy7F3yGBZRnkcMuu0R/v0ehKHW2R5+OWMcgyeHSsfBzMqWIrShjQ0 18PtdsFsArKScqWsYkzPSfho/VuobayGx+2Gwei7+iijzYCc6x2oK3Jj4z1VyJ8VI0WmwYoKlqK0 IYX7VkgBq8sNvLX6r3hz1UuyDGQuaum2jzA2bzJiIuJ83iDd9/FoLL+0DJvuq8aA56JhdgTn2lAF S1HaEJYw2M0RSIrqgHhnkiTYK+rKEGGJRGxkPDxf7176GqMN6PtYFNb8VyW2P1WL7v/tCEoveBUs RWlDWKRan12HwTlno2tKL6TGpmN/yS7sL90FDzywWyL89no7c8zo/lsHCm+rgjXeiKxr7EHXJK2C pShtSMfEbGQkZMnka4PBKEvBrqm9xC2C59wc8BcGE6QpeqADWPurSpkmzcGswRRpqWApShtyosn6 m5XlFCoTnwuQiTvJY2zodV8UNt5fDUeWCannWhEsqGApShiSdqEN5ZuaseGuKpgjo5E4IjjCLBUs RQlDzE4Dut3qgKvWgzW/qsBZs2MQNyjwRUsFS1HCFGu8QXYOmW8rvK0SA5+LCfjJO4F9dYqitHtO q9f/OrHp/mqs/58q9Hk4CtF5gSsLgXtliqL4bvLOfzuw9bEarLyqHAOfj0F8fmAuD1WwFEUBJ+30 fjgK629nyUMFzno1NiCXh4F3RYqi+AWjGej7eBTW/w4ovKUKvR9yBtycQxUsRVFOYrAA3e9wYNtj NWJL0/PuKKRPtkmuKxAIkMtQFCVQsCUa0fNepywT191QgeaqKHS+IiIgRCsALkFRlECDbg65tztE tDiclYX6GVPtMEX6t/dQBUtRlO+Eoxk7XX5CpDb9oRoV65uRc2MkIjP812akgqUoyg8aAKZPtSOy kxFrrq1EbZEL/f4vGvZU/zRxq2ApivKju4cJQ6wY/WEcVv+8EssuLsNZc2LhyDSJ44MvUcFSFKVF 2NNMGPCnaMlpLZtcJon5tPNtUnjqK1SwFEVpMfSD7/NIFA68Xo+tD1ej4qtm5N3n9NkOogqWoiit whxlQNYvIhCdZ8Lqn1Xi6MJGDHsrBhGp7T9hWgVLUZTTgnmtYW/FYuM91fhyejm63eZA6gRbu5Y+ qGApinJ6GCD9hvkvxWDf3+uw5dEaHP2sURqpIzu1T+mDCpaiKDgTLDEGZF8bifhBFqz5VSWWTChD /ssxSBja9n2I/x+wjfekXn+UNAAAAABJRU5ErkJggg==