<metadata xml:lang="en"><Esri><CreaDate>20250110</CreaDate><CreaTime>09051400</CreaTime><ArcGISFormat>1.0</ArcGISFormat><SyncOnce>FALSE</SyncOnce><DataProperties><lineage><Process ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\toolboxes\Data Management Tools.tbx\DeleteFeatures" Date="20250110" Time="090514">DeleteFeatures "Root Water\Water Laterals"</Process><Process ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\toolboxes\Data Management Tools.tbx\Append" Date="20250110" Time="091629">Append 'Utilities Water\Water Laterals' "Root Water\Water Laterals" "Input fields must match target fields" # # # # NOT_UPDATE_GEOMETRY</Process><Process ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema" Date="20250409" Time="120040">UpdateSchema "Q:\GIS - Docs and Other\0 - SF Dbs Connections\0-SUVGIS-gisadmin\0-gisadmin-WaterAndPI-SUVGIS.sde\DBO.WaterFeatures\DBO.WaterLaterals" "&lt;operationSequence&gt;&lt;workflow&gt;&lt;DisableAttributeRules&gt;&lt;rule_name&gt;Geometry Edit Rule&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DisableAttributeRules&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;DisableAttributeRules&gt;&lt;rule_name&gt;Year Installed Rule&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DisableAttributeRules&gt;&lt;AlterAttributeRule&gt;&lt;rule_name&gt;Year Installed Rule&lt;/rule_name&gt;&lt;rule_description&gt;Add year installed to field automatically when inserted.&lt;/rule_description&gt;&lt;exclude_from_client_eval&gt;True&lt;/exclude_from_client_eval&gt;&lt;severity&gt;-1&lt;/severity&gt;&lt;expression&gt;var yr = Year(Now())
var YearInstalled = $feature.YearInstalled
//We need to have a check on if the field is null or not, so we don't overwrite existing values.
//If the field is empty, just exit
if (IsEmpty(YearInstalled) == false) {
 return;
}
else {
 return yr;
 }&lt;/expression&gt;&lt;category&gt;0&lt;/category&gt;&lt;triggering_events_insert&gt;True&lt;/triggering_events_insert&gt;&lt;triggering_events_delete&gt;False&lt;/triggering_events_delete&gt;&lt;triggering_events_update&gt;False&lt;/triggering_events_update&gt;&lt;/AlterAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;DisableAttributeRules&gt;&lt;rule_name&gt;Length Rule&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DisableAttributeRules&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;DisableAttributeRules&gt;&lt;rule_name&gt;MT to RT Add Record Lead Pipe Analysis Date Inspected&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DisableAttributeRules&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;DisableAttributeRules&gt;&lt;rule_name&gt;MT to RT Update Record Lead Pipe Analysis Date Inspected&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DisableAttributeRules&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;DisableAttributeRules&gt;&lt;rule_name&gt;New Lateral Pipe Inspection Method Insertion Rule&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DisableAttributeRules&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;DisableAttributeRules&gt;&lt;rule_name&gt;New Lateral Lead Pipe Date Inspected Insertion Rule&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DisableAttributeRules&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;"</Process><Process ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema" Date="20250409" Time="120130">UpdateSchema "Q:\GIS - Docs and Other\0 - SF Dbs Connections\0-SUVGIS-gisadmin\0-gisadmin-WaterAndPI-SUVGIS.sde\DBO.WaterFeatures\DBO.WaterLaterals" "&lt;operationSequence&gt;&lt;workflow&gt;&lt;DisableAttributeRules&gt;&lt;rule_name&gt;Year Installed Rule&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DisableAttributeRules&gt;&lt;AlterAttributeRule&gt;&lt;rule_name&gt;Year Installed Rule&lt;/rule_name&gt;&lt;rule_description&gt;Add year installed to field automatically when inserted.&lt;/rule_description&gt;&lt;exclude_from_client_eval&gt;True&lt;/exclude_from_client_eval&gt;&lt;severity&gt;-1&lt;/severity&gt;&lt;expression&gt;var yr = Year(Now())
var YearInstalled = $feature.YearInstalled
//We need to have a check on if the field is null or not, so we don't overwrite existing values.
//If the field is empty, just exit
if (IsEmpty(YearInstalled) == false) {
 return;
}
else {
 return yr;
 }&lt;/expression&gt;&lt;category&gt;0&lt;/category&gt;&lt;triggering_events_insert&gt;True&lt;/triggering_events_insert&gt;&lt;triggering_events_delete&gt;False&lt;/triggering_events_delete&gt;&lt;triggering_events_update&gt;False&lt;/triggering_events_update&gt;&lt;/AlterAttributeRule&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;EnableAttributeRules&gt;&lt;rule_name&gt;Length Rule&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/EnableAttributeRules&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AlterAttributeRule&gt;&lt;rule_name&gt;MT to RT Add Record Lead Pipe Analysis Date Inspected&lt;/rule_name&gt;&lt;rule_description&gt;Create a related record of the date inspected and related fields for the lead pipe analysis project.&lt;/rule_description&gt;&lt;exclude_from_client_eval&gt;True&lt;/exclude_from_client_eval&gt;&lt;tags&gt;Water Laterals;Lead Pipe Analysis&lt;/tags&gt;&lt;severity&gt;-1&lt;/severity&gt;&lt;expression&gt;//Get the field value for the feature
//This field value will reflect what was input by the user at the last update, which should already be in Local Time
var FeatureFieldValue = $feature.LdPipeDateInsp
//This is the value that will be used to create a new record. Because this would be considered a new input, it would automatically be set to GMT (Time zone 0 of UTC time), we need to adjust it to the Local time for any inputs the rule creates.
var FeatureLdPipeDateInspConvert = ToLocal(FeatureFieldValue)
//If the field is empty, just exit
if (IsEmpty(FeatureFieldValue) == true) {
    return;
}
else {
    //If the field in question has not changed, then just exit.
    if (
        $originalfeature.LdPipeDateInsp == $feature.LdPipeDateInsp
        )
    {
        return;
    }
    else {
        //Get the globalid field value for the feature
        var FeatureGlobalID = $feature.GlobalID;
        //Get a list of the related records and filter them to include only the records that pertain to the feature in question.
        var AssociatedFeatureClassList = Filter((FeatureSetByName($datastore, "DBO.WaterLateralsLeadPipeDateInspectedRT", ["GLOBALID", 'LdPipeDateInsp',"RelatedGlobalID"], false)), "RelatedGlobalID = @FeatureGlobalID")
        //If there is no related record, then proceed to adding a new record. Otherwise, there are additional checks that need to be performed.
        if (Count(AssociatedFeatureClassList) &amp;gt; 0) {
            //Build a list of the related records, where the date field matches the related date field in the related record.
            var i = 0;
            var AssociatedRows = [];
            for (var List1 in AssociatedFeatureClassList) {
                if (List1.LdPipeDateInsp == FeatureFieldValue) {
                AssociatedRows[i++] = List1.GLOBALID
                }
            }
            //If there are any records remaining after this last check, then that means there is already a record with a matching date field and we do not want to add an additional record with the same date.
            if (Count(AssociatedRows) &amp;gt; 0) {
                return;
            }
            else {
                //Create the dictionary of edits that will be used to update the feature in question in the related table.
                return {
                'edit': [{
                    'className': "DBO.WaterLateralsLeadPipeDateInspectedRT",
                    'adds': [{
                        'attributes': {"LdPipeDateInsp": FeatureLdPipeDateInspConvert,
                                    "RelatedGlobalID": $feature.GlobalID,
                                    "Material": $feature.Material,
                                    "NotesConcerns": $feature.NotesConcerns,
                                    "LeadPipingCheck": $feature.LeadPipingCheck,
                                    "PipeInspectionMethod": $feature.PipeInspectionMethod
                                }
                            }]
                        }]
                }
            }
        }
        else {
            //Create the dictionary of edits that will be used to update the feature in question in the related table.
            return {
                'edit': [{
                    'className': "DBO.WaterLateralsLeadPipeDateInspectedRT",
                    'adds': [{
                        'attributes': {"LdPipeDateInsp": FeatureLdPipeDateInspConvert,
                                    "RelatedGlobalID": $feature.GlobalID,
                                    "Material": $feature.Material,
                                    "NotesConcerns": $feature.NotesConcerns,
                                    "LeadPipingCheck": $feature.LeadPipingCheck,
                                    "PipeInspectionMethod": $feature.PipeInspectionMethod
                                }
                            }]
                        }]
                }
        }
    }
}&lt;/expression&gt;&lt;category&gt;4294967295&lt;/category&gt;&lt;triggering_events_insert&gt;False&lt;/triggering_events_insert&gt;&lt;triggering_events_delete&gt;False&lt;/triggering_events_delete&gt;&lt;triggering_events_update&gt;True&lt;/triggering_events_update&gt;&lt;/AlterAttributeRule&gt;&lt;EnableAttributeRules&gt;&lt;rule_name&gt;MT to RT Add Record Lead Pipe Analysis Date Inspected&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/EnableAttributeRules&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;AlterAttributeRule&gt;&lt;rule_name&gt;MT to RT Update Record Lead Pipe Analysis Date Inspected&lt;/rule_name&gt;&lt;rule_description&gt;Update the related record of the date inspected and related fields for the lead pipe analysis project.&lt;/rule_description&gt;&lt;exclude_from_client_eval&gt;True&lt;/exclude_from_client_eval&gt;&lt;tags&gt;Water Laterals;Lead Pipe Analysis&lt;/tags&gt;&lt;severity&gt;-1&lt;/severity&gt;&lt;expression&gt;//Get the field value for the feature
var FeatureFieldValue = $feature.LdPipeDateInsp
//If the field is empty, just exit
if (IsEmpty(FeatureFieldValue) == true) {
    return;
}
else {
    //If any of the related fields have been changed, we want to push an update. If the date field in question has been changed, we just want to exit the rule because it should be caught by the Add Record Rule, not this rule.
    if (
        (
        $originalfeature.LdPipeDateInsp == $feature.LdPipeDateInsp &amp;amp;&amp;amp;
        $originalfeature.Material == $feature.Material &amp;amp;&amp;amp;
        $originalfeature.NotesConcerns == $feature.NotesConcerns &amp;amp;&amp;amp;
        $originalfeature.LeadPipingCheck == $feature.LeadPipingCheck &amp;amp;&amp;amp;
        $originalfeature.PipeInspectionMethod == $feature.PipeInspectionMethod
        ) ||
        ($originalfeature.LdPipeDateInsp != $feature.LdPipeDateInsp)
        )
    {
        return;
    }
    else {
        //Get the field value for the feature
        var FeatureGlobalID = $feature.GlobalID
        //Get the last edited date editor tracking field of the feature for the date difference statement below
        var EndDate = Date($feature.last_edited_date)
        //Get a list of the related records and filter them to include only the records that pertain to the feature in question.
        var AssociatedFeatureClassList = Filter((FeatureSetByName($datastore, "DBO.WaterLateralsLeadPipeDateInspectedRT", ["GLOBALID", 'LdPipeDateInsp', 'last_edited_date',"RelatedGlobalID"], false)), "RelatedGlobalID = @FeatureGlobalID")
        //If there is no related record, just exit. This should be caught by the Add Record Rule, not this rule.
        if (Count(AssociatedFeatureClassList) &amp;gt; 0) {
            //Build a list of the related records, where the date field matches the related date field in the related record.
            var i = 0;
            var AssociatedRows = [];
            for (var List1 in AssociatedFeatureClassList) {
                if (List1.LdPipeDateInsp == FeatureFieldValue) {
                AssociatedRows[i++] = List1.GLOBALID
                }
            }
            //There should only be 1 record, if an edit is going to be made. If there are 0, this should be caught by the Add Record Rule. If there is more then 1, there is an issue and we do not want to push any updates.
            if (Count(AssociatedRows) == 1) {
                //Get the feature from the initial list, using the filtered list we created via the globalid.
                //There should only be 1 feature due to the last if statement.
                //Use the First function to get this feature. This allows the script to properly work and forces the feature into the correct format we need.
                var AssociatedFeatureToUpdate = First(Filter (AssociatedFeatureClassList, "GLOBALID IN @AssociatedRows"))
                //Get the last edited date editor tracking field of the related record for the date difference statement below
                var StartDate = Date(AssociatedFeatureToUpdate.last_edited_date)
                //Find the difference in editing dates between the feature and related record.
                var DateDifference = DateDiff(EndDate, StartDate, 'days');
                //If the difference in time between editing the feature and the related record is more then 1 day, we do not want to push the edit updates to the related record.
                if (DateDifference &amp;gt; 1) {
                    return;
                }
                else {
                    //Create the dictionary of edits that will be used to update the feature in question in the related table.
                    return {
                    'edit': [{
                        'className': "DBO.WaterLateralsLeadPipeDateInspectedRT",
                        'updates': [{
                            'globalid': AssociatedFeatureToUpdate.GlobalID,
                            'attributes': {"Material": $feature.Material,
                                        "NotesConcerns": $feature.NotesConcerns,
                                        "LeadPipingCheck": $feature.LeadPipingCheck,
                                        "PipeInspectionMethod": $feature.PipeInspectionMethod
                                    }
                                }]
                            }]
                        }
                }
            }
            else {
                return;
            }
        }
        else {
            return;
        }
    }
}&lt;/expression&gt;&lt;category&gt;4294967295&lt;/category&gt;&lt;triggering_events_insert&gt;False&lt;/triggering_events_insert&gt;&lt;triggering_events_delete&gt;False&lt;/triggering_events_delete&gt;&lt;triggering_events_update&gt;True&lt;/triggering_events_update&gt;&lt;/AlterAttributeRule&gt;&lt;EnableAttributeRules&gt;&lt;rule_name&gt;MT to RT Update Record Lead Pipe Analysis Date Inspected&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/EnableAttributeRules&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;EnableAttributeRules&gt;&lt;rule_name&gt;New Lateral Pipe Inspection Method Insertion Rule&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/EnableAttributeRules&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;EnableAttributeRules&gt;&lt;rule_name&gt;New Lateral Lead Pipe Date Inspected Insertion Rule&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/EnableAttributeRules&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;"</Process><Process ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\toolboxes\Data Management Tools.tbx\UpdateSchema" Date="20250409" Time="120544">UpdateSchema "Q:\GIS - Docs and Other\0 - SF Dbs Connections\0-SUVGIS-gisadmin\0-gisadmin-WaterAndPI-SUVGIS.sde\DBO.WaterFeatures\DBO.WaterLaterals" "&lt;operationSequence&gt;&lt;workflow&gt;&lt;DisableAttributeRules&gt;&lt;rule_name&gt;Geometry Edit Rule&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DisableAttributeRules&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;DisableAttributeRules&gt;&lt;rule_name&gt;Length Rule&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DisableAttributeRules&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;DisableAttributeRules&gt;&lt;rule_name&gt;MT to RT Add Record Lead Pipe Analysis Date Inspected&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DisableAttributeRules&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;DisableAttributeRules&gt;&lt;rule_name&gt;MT to RT Update Record Lead Pipe Analysis Date Inspected&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DisableAttributeRules&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;DisableAttributeRules&gt;&lt;rule_name&gt;New Lateral Pipe Inspection Method Insertion Rule&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DisableAttributeRules&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;DisableAttributeRules&gt;&lt;rule_name&gt;New Lateral Lead Pipe Date Inspected Insertion Rule&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/DisableAttributeRules&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;"</Process><Process ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema" Date="20250410" Time="143810">UpdateSchema "Q:\GIS - Docs and Other\0 - SF Dbs Connections\0-SUVGIS-gisadmin\0-gisadmin-WaterAndPI-SUVGIS.sde\DBO.WaterFeatures\DBO.WaterLaterals" "&lt;operationSequence&gt;&lt;workflow&gt;&lt;EnableAttributeRules&gt;&lt;rule_name&gt;Geometry Edit Rule&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/EnableAttributeRules&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;EnableAttributeRules&gt;&lt;rule_name&gt;Year Installed Rule&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/EnableAttributeRules&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;EnableAttributeRules&gt;&lt;rule_name&gt;Length Rule&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/EnableAttributeRules&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;EnableAttributeRules&gt;&lt;rule_name&gt;MT to RT Add Record Lead Pipe Analysis Date Inspected&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/EnableAttributeRules&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;EnableAttributeRules&gt;&lt;rule_name&gt;MT to RT Update Record Lead Pipe Analysis Date Inspected&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/EnableAttributeRules&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;EnableAttributeRules&gt;&lt;rule_name&gt;New Lateral Pipe Inspection Method Insertion Rule&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/EnableAttributeRules&gt;&lt;/workflow&gt;&lt;workflow&gt;&lt;EnableAttributeRules&gt;&lt;rule_name&gt;New Lateral Lead Pipe Date Inspected Insertion Rule&lt;/rule_name&gt;&lt;rule_type&gt;CALCULATION&lt;/rule_type&gt;&lt;/EnableAttributeRules&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;"</Process><Process ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\Toolboxes\Data Management Tools.tbx\UpdateSchema" Date="20260107" Time="135533">UpdateSchema "Q:\GIS - Docs and Other\0 - SF Dbs Connections\0-SUVGIS-gisadmin\0-gisadmin-WaterAndPI-SUVGIS.sde\DBO.WaterFeatures\DBO.WaterLaterals" "&lt;operationSequence&gt;&lt;workflow&gt;&lt;AlterAttributeRule&gt;&lt;rule_name&gt;Geometry Edit Rule&lt;/rule_name&gt;&lt;rule_description&gt;Update the 'Needs Verification' field when anyone other than GIS division personell change the geometry of the feature.&lt;/rule_description&gt;&lt;exclude_from_client_eval&gt;True&lt;/exclude_from_client_eval&gt;&lt;tags&gt;Geometry&lt;/tags&gt;&lt;severity&gt;-1&lt;/severity&gt;&lt;expression&gt;// This rule will update the Verification Needed field to 'Yes' if non-GIS Division personnel edit the feature's geometry.
// Create local variables.
var leu = $feature.last_edited_user
var geom = !Equals(Geometry($originalFeature), Geometry($feature))
var result = "No";

// Determine if the current editing user is a member of the GIS division and update the Verification Needed attribute.
// The GIS division list is an Array of admin users we have defined here.
// The array of admin users must include both sql and portal usernames to work correctly.

if (geom) {
    if (!Includes(['shawnbeecher', 'SBEECHER', 'gisadmin','GISADMIN', 'twarren', 'TWARREN', 'rjackson', 'RJACKSON', 'mcastrillo', 'MCASTRILLO', 'wwoodhouse', 'WWOODHOUSE', 'jblack', 'JBLACK', 'gstewart', 'GSTEWART', 'kaitlynmead', 'KAITLYNMEAD', 'dgomez', 'DGOMEZ'], leu)) {
        result = "Yes";
    }
    return result;
}

// If the geometry has not been changed but another field in the feature has been edited, exit the script without making any changes.
return;&lt;/expression&gt;&lt;category&gt;-1&lt;/category&gt;&lt;triggering_events_insert&gt;False&lt;/triggering_events_insert&gt;&lt;triggering_events_delete&gt;False&lt;/triggering_events_delete&gt;&lt;triggering_events_update&gt;True&lt;/triggering_events_update&gt;&lt;/AlterAttributeRule&gt;&lt;/workflow&gt;&lt;/operationSequence&gt;"</Process><Process ToolSource="c:\program files\arcgis\pro\Resources\ArcToolbox\toolboxes\Conversion Tools.tbx\ExportFeatures" Date="20260724" Time="191203">ExportFeatures "C:\GIS - Docs and Other\GDB_Connections\0-gisadmin-WaterAndPI-SUVGIS.sde\WaterAndPI.DBO.WaterFeatures\WaterAndPI.DBO.WaterLaterals" C:\inetpub\wwwroot\SFGISDataDownload\DataDump\Utilities\Water\WaterLaterals.shp "(InCanyon = 'No' And Abandoned &lt;&gt; 'Yes') OR (Abandoned &lt;&gt; 'Yes' And InCanyon IS NULL) OR (Abandoned IS NULL And InCanyon IS NULL) OR (Abandoned IS NULL And InCanyon = 'No')" NOT_USE_ALIAS "Material "MATERIAL" true true false 30 Text 0 0,First,#,C:\GIS - Docs and Other\GDB_Connections\0-gisadmin-WaterAndPI-SUVGIS.sde\WaterAndPI.DBO.WaterFeatures\WaterAndPI.DBO.WaterLaterals,Material,0,29;MaterialAcronym "Material Acronym" true true false 6 Text 0 0,First,#,C:\GIS - Docs and Other\GDB_Connections\0-gisadmin-WaterAndPI-SUVGIS.sde\WaterAndPI.DBO.WaterFeatures\WaterAndPI.DBO.WaterLaterals,MaterialAcronym,0,5;YearInstalled "Year Installed" true true false 2 Short 0 5,First,#,C:\GIS - Docs and Other\GDB_Connections\0-gisadmin-WaterAndPI-SUVGIS.sde\WaterAndPI.DBO.WaterFeatures\WaterAndPI.DBO.WaterLaterals,YearInstalled,-1,-1;Abandoned "Abandoned" true true false 10 Text 0 0,First,#,C:\GIS - Docs and Other\GDB_Connections\0-gisadmin-WaterAndPI-SUVGIS.sde\WaterAndPI.DBO.WaterFeatures\WaterAndPI.DBO.WaterLaterals,Abandoned,0,9;NotesConcerns "Notes &amp; Concerns" true true false 254 Text 0 0,First,#,C:\GIS - Docs and Other\GDB_Connections\0-gisadmin-WaterAndPI-SUVGIS.sde\WaterAndPI.DBO.WaterFeatures\WaterAndPI.DBO.WaterLaterals,NotesConcerns,0,253;Diameter "Diameter" true true false 20 Text 0 0,First,#,C:\GIS - Docs and Other\GDB_Connections\0-gisadmin-WaterAndPI-SUVGIS.sde\WaterAndPI.DBO.WaterFeatures\WaterAndPI.DBO.WaterLaterals,Diameter,0,19;PubliclyVisible "Publicly Visible?" true true false 10 Text 0 0,First,#,C:\GIS - Docs and Other\GDB_Connections\0-gisadmin-WaterAndPI-SUVGIS.sde\WaterAndPI.DBO.WaterFeatures\WaterAndPI.DBO.WaterLaterals,PubliclyVisible,0,9;GlobalID "GlobalID" false false true 38 Text 0 0,First,#,C:\GIS - Docs and Other\GDB_Connections\0-gisadmin-WaterAndPI-SUVGIS.sde\WaterAndPI.DBO.WaterFeatures\WaterAndPI.DBO.WaterLaterals,GlobalID,-1,-1;created_user "created_user" false true true 255 Text 0 0,First,#,C:\GIS - Docs and Other\GDB_Connections\0-gisadmin-WaterAndPI-SUVGIS.sde\WaterAndPI.DBO.WaterFeatures\WaterAndPI.DBO.WaterLaterals,created_user,0,254;created_date "created_date" false true true 8 Date 0 0,First,#,C:\GIS - Docs and Other\GDB_Connections\0-gisadmin-WaterAndPI-SUVGIS.sde\WaterAndPI.DBO.WaterFeatures\WaterAndPI.DBO.WaterLaterals,created_date,-1,-1;last_edited_user "last_edited_user" false true true 255 Text 0 0,First,#,C:\GIS - Docs and Other\GDB_Connections\0-gisadmin-WaterAndPI-SUVGIS.sde\WaterAndPI.DBO.WaterFeatures\WaterAndPI.DBO.WaterLaterals,last_edited_user,0,254;last_edited_date "last_edited_date" false true true 8 Date 0 0,First,#,C:\GIS - Docs and Other\GDB_Connections\0-gisadmin-WaterAndPI-SUVGIS.sde\WaterAndPI.DBO.WaterFeatures\WaterAndPI.DBO.WaterLaterals,last_edited_date,-1,-1;LeadPipingCheck "Lead Piping Check" true true false 255 Text 0 0,First,#,C:\GIS - Docs and Other\GDB_Connections\0-gisadmin-WaterAndPI-SUVGIS.sde\WaterAndPI.DBO.WaterFeatures\WaterAndPI.DBO.WaterLaterals,LeadPipingCheck,0,254;Length "Length" true true false 8 Double 1 7,First,#,C:\GIS - Docs and Other\GDB_Connections\0-gisadmin-WaterAndPI-SUVGIS.sde\WaterAndPI.DBO.WaterFeatures\WaterAndPI.DBO.WaterLaterals,Length,-1,-1;VerificationNeeded "VerificationNeeded" true true false 255 Text 0 0,First,#,C:\GIS - Docs and Other\GDB_Connections\0-gisadmin-WaterAndPI-SUVGIS.sde\WaterAndPI.DBO.WaterFeatures\WaterAndPI.DBO.WaterLaterals,VerificationNeeded,0,254;InCanyon "In the Canyon?" true true false 5 Text 0 0,First,#,C:\GIS - Docs and Other\GDB_Connections\0-gisadmin-WaterAndPI-SUVGIS.sde\WaterAndPI.DBO.WaterFeatures\WaterAndPI.DBO.WaterLaterals,InCanyon,0,4;PipeInspectionMethod "PipeInspectionMethod" true true false 255 Text 0 0,First,#,C:\GIS - Docs and Other\GDB_Connections\0-gisadmin-WaterAndPI-SUVGIS.sde\WaterAndPI.DBO.WaterFeatures\WaterAndPI.DBO.WaterLaterals,PipeInspectionMethod,0,254;LdPipeDateInsp "Lead Pipe Date Inspected" true true false 8 Date 0 0,First,#,C:\GIS - Docs and Other\GDB_Connections\0-gisadmin-WaterAndPI-SUVGIS.sde\WaterAndPI.DBO.WaterFeatures\WaterAndPI.DBO.WaterLaterals,LdPipeDateInsp,-1,-1" #</Process></lineage><itemProps><itemName Sync="TRUE">WaterLaterals</itemName><imsContentType Sync="TRUE">002</imsContentType><itemSize Sync="TRUE">0.000</itemSize><itemLocation><linkage Sync="TRUE">file://\\SUVGIS\ADMINC$\inetpub\wwwroot\SFGISDataDownload\DataDump\Utilities\Water\WaterLaterals.shp</linkage><protocol Sync="TRUE">Local Area Network</protocol></itemLocation></itemProps><coordRef><type Sync="TRUE">Projected</type><geogcsn Sync="TRUE">GCS_North_American_1983</geogcsn><csUnits Sync="TRUE">Linear Unit: Foot_US (0.304801)</csUnits><projcsn Sync="TRUE">NAD_1983_StatePlane_Utah_Central_FIPS_4302_Feet</projcsn><peXml Sync="TRUE">&lt;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.5.0'&gt;&lt;WKT&gt;PROJCS[&amp;quot;NAD_1983_StatePlane_Utah_Central_FIPS_4302_Feet&amp;quot;,GEOGCS[&amp;quot;GCS_North_American_1983&amp;quot;,DATUM[&amp;quot;D_North_American_1983&amp;quot;,SPHEROID[&amp;quot;GRS_1980&amp;quot;,6378137.0,298.257222101]],PRIMEM[&amp;quot;Greenwich&amp;quot;,0.0],UNIT[&amp;quot;Degree&amp;quot;,0.0174532925199433]],PROJECTION[&amp;quot;Lambert_Conformal_Conic&amp;quot;],PARAMETER[&amp;quot;False_Easting&amp;quot;,1640416.666666667],PARAMETER[&amp;quot;False_Northing&amp;quot;,6561666.666666666],PARAMETER[&amp;quot;Central_Meridian&amp;quot;,-111.5],PARAMETER[&amp;quot;Standard_Parallel_1&amp;quot;,39.01666666666667],PARAMETER[&amp;quot;Standard_Parallel_2&amp;quot;,40.65],PARAMETER[&amp;quot;Latitude_Of_Origin&amp;quot;,38.33333333333334],UNIT[&amp;quot;Foot_US&amp;quot;,0.3048006096012192],AUTHORITY[&amp;quot;EPSG&amp;quot;,3566]]&lt;/WKT&gt;&lt;XOrigin&gt;-119796900&lt;/XOrigin&gt;&lt;YOrigin&gt;-89212200&lt;/YOrigin&gt;&lt;XYScale&gt;37085786.435314134&lt;/XYScale&gt;&lt;ZOrigin&gt;-100000&lt;/ZOrigin&gt;&lt;ZScale&gt;10000&lt;/ZScale&gt;&lt;MOrigin&gt;-100000&lt;/MOrigin&gt;&lt;MScale&gt;10000&lt;/MScale&gt;&lt;XYTolerance&gt;0.0032808333333333331&lt;/XYTolerance&gt;&lt;ZTolerance&gt;0.001&lt;/ZTolerance&gt;&lt;MTolerance&gt;0.001&lt;/MTolerance&gt;&lt;HighPrecision&gt;true&lt;/HighPrecision&gt;&lt;WKID&gt;102743&lt;/WKID&gt;&lt;LatestWKID&gt;3566&lt;/LatestWKID&gt;&lt;/ProjectedCoordinateSystem&gt;</peXml></coordRef></DataProperties><SyncDate>20260724</SyncDate><SyncTime>19115900</SyncTime><ModDate>20260724</ModDate><ModTime>19115900</ModTime></Esri><dataIdInfo><envirDesc Sync="TRUE">Microsoft Windows Server 2016 Technical Preview Version 10.0 (Build 17763) ; Esri ArcGIS 13.5.2.57366</envirDesc><dataLang><languageCode value="eng" Sync="TRUE"></languageCode><countryCode value="USA" Sync="TRUE"></countryCode></dataLang><idCitation><resTitle Sync="TRUE">WaterLaterals</resTitle><presForm><PresFormCd value="005" Sync="TRUE"></PresFormCd></presForm></idCitation><spatRpType><SpatRepTypCd value="001" Sync="TRUE"></SpatRepTypCd></spatRpType></dataIdInfo><mdLang><languageCode value="eng" Sync="TRUE"></languageCode><countryCode value="USA" Sync="TRUE"></countryCode></mdLang><distInfo><distFormat><formatName Sync="TRUE">Shapefile</formatName></distFormat><distTranOps><transSize Sync="TRUE">0.000</transSize></distTranOps></distInfo><mdHrLv><ScopeCd value="005" Sync="TRUE"></ScopeCd></mdHrLv><mdHrLvName Sync="TRUE">dataset</mdHrLvName><refSysInfo><RefSystem><refSysID><identCode code="3566" Sync="TRUE"></identCode><idCodeSpace Sync="TRUE">EPSG</idCodeSpace><idVersion Sync="TRUE">8.9.3(9.3.0.0)</idVersion></refSysID></RefSystem></refSysInfo><spatRepInfo><VectSpatRep><geometObjs Name="WaterLaterals"><geoObjTyp><GeoObjTypCd value="002" Sync="TRUE"></GeoObjTypCd></geoObjTyp><geoObjCnt Sync="TRUE">0</geoObjCnt></geometObjs><topLvl><TopoLevCd value="001" Sync="TRUE"></TopoLevCd></topLvl></VectSpatRep></spatRepInfo><spdoinfo><ptvctinf><esriterm Name="WaterLaterals"><efeatyp Sync="TRUE">Simple</efeatyp><efeageom code="3" Sync="TRUE"></efeageom><esritopo Sync="TRUE">FALSE</esritopo><efeacnt Sync="TRUE">0</efeacnt><spindex Sync="TRUE">FALSE</spindex><linrefer Sync="TRUE">FALSE</linrefer></esriterm></ptvctinf></spdoinfo><eainfo><detailed Name="WaterLaterals"><enttyp><enttypl Sync="TRUE">WaterLaterals</enttypl><enttypt Sync="TRUE">Feature Class</enttypt><enttypc Sync="TRUE">0</enttypc></enttyp><attr><attrlabl Sync="TRUE">FID</attrlabl><attalias Sync="TRUE">FID</attalias><attrtype Sync="TRUE">OID</attrtype><attwidth Sync="TRUE">4</attwidth><atprecis Sync="TRUE">0</atprecis><attscale Sync="TRUE">0</attscale><attrdef Sync="TRUE">Internal feature number.</attrdef><attrdefs Sync="TRUE">Esri</attrdefs><attrdomv><udom Sync="TRUE">Sequential unique whole numbers that are automatically generated.</udom></attrdomv></attr><attr><attrlabl Sync="TRUE">Shape</attrlabl><attalias Sync="TRUE">Shape</attalias><attrtype Sync="TRUE">Geometry</attrtype><attwidth Sync="TRUE">0</attwidth><atprecis Sync="TRUE">0</atprecis><attscale Sync="TRUE">0</attscale><attrdef Sync="TRUE">Feature geometry.</attrdef><attrdefs Sync="TRUE">Esri</attrdefs><attrdomv><udom Sync="TRUE">Coordinates defining the features.</udom></attrdomv></attr><attr><attrlabl Sync="TRUE">Material</attrlabl><attalias Sync="TRUE">Material</attalias><attrtype Sync="TRUE">String</attrtype><attwidth Sync="TRUE">30</attwidth><atprecis Sync="TRUE">0</atprecis><attscale Sync="TRUE">0</attscale></attr><attr><attrlabl Sync="TRUE">MaterialAc</attrlabl><attalias Sync="TRUE">MaterialAc</attalias><attrtype Sync="TRUE">String</attrtype><attwidth Sync="TRUE">6</attwidth><atprecis Sync="TRUE">0</atprecis><attscale Sync="TRUE">0</attscale></attr><attr><attrlabl Sync="TRUE">YearInstal</attrlabl><attalias Sync="TRUE">YearInstal</attalias><attrtype Sync="TRUE">Integer</attrtype><attwidth Sync="TRUE">5</attwidth><atprecis Sync="TRUE">5</atprecis><attscale Sync="TRUE">0</attscale></attr><attr><attrlabl Sync="TRUE">Abandoned</attrlabl><attalias Sync="TRUE">Abandoned</attalias><attrtype Sync="TRUE">String</attrtype><attwidth Sync="TRUE">10</attwidth><atprecis Sync="TRUE">0</atprecis><attscale Sync="TRUE">0</attscale></attr><attr><attrlabl Sync="TRUE">NotesConce</attrlabl><attalias Sync="TRUE">NotesConce</attalias><attrtype Sync="TRUE">String</attrtype><attwidth Sync="TRUE">254</attwidth><atprecis Sync="TRUE">0</atprecis><attscale Sync="TRUE">0</attscale></attr><attr><attrlabl Sync="TRUE">Diameter</attrlabl><attalias Sync="TRUE">Diameter</attalias><attrtype Sync="TRUE">String</attrtype><attwidth Sync="TRUE">20</attwidth><atprecis Sync="TRUE">0</atprecis><attscale Sync="TRUE">0</attscale></attr><attr><attrlabl Sync="TRUE">PubliclyVi</attrlabl><attalias Sync="TRUE">PubliclyVi</attalias><attrtype Sync="TRUE">String</attrtype><attwidth Sync="TRUE">10</attwidth><atprecis Sync="TRUE">0</atprecis><attscale Sync="TRUE">0</attscale></attr><attr><attrlabl Sync="TRUE">GlobalID</attrlabl><attalias Sync="TRUE">GlobalID</attalias><attrtype Sync="TRUE">String</attrtype><attwidth Sync="TRUE">38</attwidth><atprecis Sync="TRUE">0</atprecis><attscale Sync="TRUE">0</attscale></attr><attr><attrlabl Sync="TRUE">created_us</attrlabl><attalias Sync="TRUE">created_us</attalias><attrtype Sync="TRUE">String</attrtype><attwidth Sync="TRUE">254</attwidth><atprecis Sync="TRUE">0</atprecis><attscale Sync="TRUE">0</attscale></attr><attr><attrlabl Sync="TRUE">created_da</attrlabl><attalias Sync="TRUE">created_da</attalias><attrtype Sync="TRUE">Date</attrtype><attwidth Sync="TRUE">8</attwidth><atprecis Sync="TRUE">0</atprecis><attscale Sync="TRUE">0</attscale></attr><attr><attrlabl Sync="TRUE">last_edite</attrlabl><attalias Sync="TRUE">last_edite</attalias><attrtype Sync="TRUE">String</attrtype><attwidth Sync="TRUE">254</attwidth><atprecis Sync="TRUE">0</atprecis><attscale Sync="TRUE">0</attscale></attr><attr><attrlabl Sync="TRUE">last_edi_1</attrlabl><attalias Sync="TRUE">last_edi_1</attalias><attrtype Sync="TRUE">Date</attrtype><attwidth Sync="TRUE">8</attwidth><atprecis Sync="TRUE">0</atprecis><attscale Sync="TRUE">0</attscale></attr><attr><attrlabl Sync="TRUE">LeadPiping</attrlabl><attalias Sync="TRUE">LeadPiping</attalias><attrtype Sync="TRUE">String</attrtype><attwidth Sync="TRUE">254</attwidth><atprecis Sync="TRUE">0</atprecis><attscale Sync="TRUE">0</attscale></attr><attr><attrlabl Sync="TRUE">Length</attrlabl><attalias Sync="TRUE">Length</attalias><attrtype Sync="TRUE">Single</attrtype><attwidth Sync="TRUE">8</attwidth><atprecis Sync="TRUE">7</atprecis><attscale Sync="TRUE">1</attscale></attr><attr><attrlabl Sync="TRUE">Verificati</attrlabl><attalias Sync="TRUE">Verificati</attalias><attrtype Sync="TRUE">String</attrtype><attwidth Sync="TRUE">254</attwidth><atprecis Sync="TRUE">0</atprecis><attscale Sync="TRUE">0</attscale></attr><attr><attrlabl Sync="TRUE">InCanyon</attrlabl><attalias Sync="TRUE">InCanyon</attalias><attrtype Sync="TRUE">String</attrtype><attwidth Sync="TRUE">5</attwidth><atprecis Sync="TRUE">0</atprecis><attscale Sync="TRUE">0</attscale></attr><attr><attrlabl Sync="TRUE">PipeInspec</attrlabl><attalias Sync="TRUE">PipeInspec</attalias><attrtype Sync="TRUE">String</attrtype><attwidth Sync="TRUE">254</attwidth><atprecis Sync="TRUE">0</atprecis><attscale Sync="TRUE">0</attscale></attr><attr><attrlabl Sync="TRUE">LdPipeDate</attrlabl><attalias Sync="TRUE">LdPipeDate</attalias><attrtype Sync="TRUE">Date</attrtype><attwidth Sync="TRUE">8</attwidth><atprecis Sync="TRUE">0</atprecis><attscale Sync="TRUE">0</attscale></attr></detailed></eainfo><mdDateSt Sync="TRUE">20260724</mdDateSt></metadata>
