20220928 13374400 1.0 FALSE GIS_DEP.LSL_Inventory 002 Server=depweb.world; Service=sde:oracle11g:depweb.world; User=GIS_DEP; Version=SDE.DEFAULT ArcSDE Connection Projected GCS_WGS_1984 Linear Unit: Meter (1.000000) WGS_1984_Web_Mercator_Auxiliary_Sphere <ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><WKT>PROJCS[&quot;WGS_1984_Web_Mercator_Auxiliary_Sphere&quot;,GEOGCS[&quot;GCS_WGS_1984&quot;,DATUM[&quot;D_WGS_1984&quot;,SPHEROID[&quot;WGS_1984&quot;,6378137.0,298.257223563]],PRIMEM[&quot;Greenwich&quot;,0.0],UNIT[&quot;Degree&quot;,0.0174532925199433]],PROJECTION[&quot;Mercator_Auxiliary_Sphere&quot;],PARAMETER[&quot;False_Easting&quot;,0.0],PARAMETER[&quot;False_Northing&quot;,0.0],PARAMETER[&quot;Central_Meridian&quot;,0.0],PARAMETER[&quot;Standard_Parallel_1&quot;,0.0],PARAMETER[&quot;Auxiliary_Sphere_Type&quot;,0.0],UNIT[&quot;Meter&quot;,1.0],AUTHORITY[&quot;EPSG&quot;,3857]]</WKT><XOrigin>-20037700</XOrigin><YOrigin>-30241100</YOrigin><XYScale>10000</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102100</WKID><LatestWKID>3857</LatestWKID></ProjectedCoordinateSystem> ExportFeatures "Utility Side | Customer Side" "C:\Users\caroline_chan\Water\Lead\Lead Service Line\LeadServiceLine.gdb\LSLschema" # NOT_USE_ALIAS "accountid "Account ID" true true false 255 Text 0 0,First,#,Utility Side | Customer Side,accountid,0,255;address "Address" true true false 255 Text 0 0,First,#,Utility Side | Customer Side,address,0,255;utilassetid "System Asset ID" true true false 255 Text 0 0,First,#,Utility Side | Customer Side,utilassetid,0,255;utilmaterial "System Material" true true false 0 Short 0 0,First,#,Utility Side | Customer Side,utilmaterial,-1,-1;utildiameter "System Diameter" true true false 0 Double 0 0,First,#,Utility Side | Customer Side,utildiameter,-1,-1;utilinstalldate "System Install Date" true true false 8 Date 0 0,First,#,Utility Side | Customer Side,utilinstalldate,-1,-1;utilverifdate "System Verification Date" true true false 8 Date 0 0,First,#,Utility Side | Customer Side,utilverifdate,-1,-1;utilsource "System Source" true true false 0 Short 0 0,First,#,Utility Side | Customer Side,utilsource,-1,-1;utilstatus "System Status" true true false 0 Short 0 0,First,#,Utility Side | Customer Side,utilstatus,-1,-1;custassetid "Customer Asset ID" true true false 255 Text 0 0,First,#,Utility Side | Customer Side,custassetid,0,255;custmaterial "Customer Material" true true false 0 Short 0 0,First,#,Utility Side | Customer Side,custmaterial,-1,-1;custdiameter "Customer Diameter" true true false 0 Double 0 0,First,#,Utility Side | Customer Side,custdiameter,-1,-1;custinstalldate "Customer Install Date" true true false 8 Date 0 0,First,#,Utility Side | Customer Side,custinstalldate,-1,-1;custverifdate "Customer Verification Date" true true false 8 Date 0 0,First,#,Utility Side | Customer Side,custverifdate,-1,-1;custsource "Customer Source" true true false 0 Short 0 0,First,#,Utility Side | Customer Side,custsource,-1,-1;custstatus "Customer Status" true true false 0 Short 0 0,First,#,Utility Side | Customer Side,custstatus,-1,-1;replacestatus "Replacement Status" true true false 0 Short 0 0,First,#,Utility Side | Customer Side,replacestatus,-1,-1;scheddate "Scheduled Replacement Date" true true false 8 Date 0 0,First,#,Utility Side | Customer Side,scheddate,-1,-1;custnotified "Notified Customer" true true false 0 Short 0 0,First,#,Utility Side | Customer Side,custnotified,-1,-1;notifydate "Notification Date" true true false 8 Date 0 0,First,#,Utility Side | Customer Side,notifydate,-1,-1;yearstructbuilt "Year Structure Built" true true false 0 Short 0 0,First,#,Utility Side | Customer Side,yearstructbuilt,-1,-1;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#,Utility Side | Customer Side,GlobalID,-1,-1;replacereason "Reason for Replacement" true true false 0 Long 0 0,First,#,Utility Side | Customer Side,replacereason,-1,-1;CreationDate "CreationDate" false true true 8 Date 0 0,First,#,Utility Side | Customer Side,CreationDate,-1,-1;Creator "Creator" false true true 128 Text 0 0,First,#,Utility Side | Customer Side,Creator,0,128;EditDate "EditDate" false true true 8 Date 0 0,First,#,Utility Side | Customer Side,EditDate,-1,-1;Editor "Editor" false true true 128 Text 0 0,First,#,Utility Side | Customer Side,Editor,0,128;bldgtype "Building Type" true true false 0 Long 0 0,First,#,Utility Side | Customer Side,bldgtype,-1,-1" # Append GPLYR_{CA99BEA2-4536-403E-826B-6D04D187A4C1} GPLYR_{8F046CA5-7172-4D48-9AD9-492B10C89128} "Use the field map to reconcile field differences" "address "Address" true true false 255 Text 0 0,First,#,C:\Users\caroline_chan\Water\Lead\Lead Service Line\LeadServiceLine.gdb\PtsTransformFeatures,Address,0,255;bldgtype "BldgType" true true false 255 Text 0 0,First,#,C:\Users\caroline_chan\Water\Lead\Lead Service Line\LeadServiceLine.gdb\PtsTransformFeatures,BldgType,0,255;accountid "UniqueID" true true false 4 Long 0 0,First,#,C:\Users\caroline_chan\Water\Lead\Lead Service Line\LeadServiceLine.gdb\PtsTransformFeatures,UniqueID,-1,-1;utilmaterial "sysMat" true true false 255 Text 0 0,First,#,C:\Users\caroline_chan\Water\Lead\Lead Service Line\LeadServiceLine.gdb\PtsTransformFeatures,sysMat,0,255;custmaterial "consMat" true true false 255 Text 0 0,First,#,C:\Users\caroline_chan\Water\Lead\Lead Service Line\LeadServiceLine.gdb\PtsTransformFeatures,consMat,0,255;utildiameter "Slsize" true true false 255 Text 0 0,First,#,C:\Users\caroline_chan\Water\Lead\Lead Service Line\LeadServiceLine.gdb\PtsTransformFeatures,Slsize,0,255;yearstructbuilt "Built" true true false 4 Long 0 0,First,#,C:\Users\caroline_chan\Water\Lead\Lead Service Line\LeadServiceLine.gdb\PtsTransformFeatures,Built,-1,-1;utilverifdate "DateVer" true true false 8 Date 0 0,First,#,C:\Users\caroline_chan\Water\Lead\Lead Service Line\LeadServiceLine.gdb\PtsTransformFeatures,DateVer,-1,-1;utilsource "VerMethod" true true false 255 Text 0 0,First,#,C:\Users\caroline_chan\Water\Lead\Lead Service Line\LeadServiceLine.gdb\PtsTransformFeatures,VerMethod,0,255" # # UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.0.0'><WorkspaceConnectionString>DATABASE=C:\Users\caroline_chan\Water\Lead\Lead Service Line\LeadServiceLine.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LSLschema</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AlterField><field_name>custinstalldate</field_name><new_field_name>plumbdate</new_field_name><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AddField><field_name>locid</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>city</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>zip</field_name><field_type>SHORT</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>pwsid</field_name><field_type>TEXT</field_type><field_length>9</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>otherver</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>lcrid</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>slclass</field_name><field_type>SHORT</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>Status</field_domain></AddField></workflow><workflow><AddField><field_name>coordmethod</field_name><field_type>LONG</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>gooseverified</field_name><field_type>SHORT</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>Yes_No</field_domain></AddField></workflow><workflow><AddField><field_name>goosematerial</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>utilsolder</field_name><field_type>SHORT</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>Yes_No</field_domain></AddField></workflow><workflow><AddField><field_name>tapresults</field_name><field_type>DOUBLE</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>custsolder</field_name><field_type>SHORT</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>Yes_No</field_domain></AddField></workflow><workflow><AddField><field_name>mainmaterial</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>utilslmatver1</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>utilslmatver2</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>utilpreslmat</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>utilsleverlead</field_name><field_type>SHORT</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>Yes_No</field_domain></AddField></workflow><workflow><AddField><field_name>custslmatver1</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>custslmatver2</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>custpreslmat</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>custsleverlead</field_name><field_type>SHORT</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>Yes_No</field_domain></AddField></workflow><workflow><AddField><field_name>custinstalldate</field_name><field_type>DATE</field_type><field_alias>Customer Install Date</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>" UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.0.0'><WorkspaceConnectionString>DATABASE=C:\Users\caroline_chan\Water\Lead\Lead Service Line\LeadServiceLine.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LSLschema</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>custinstalldate</field_name></DeleteField></workflow><workflow><AddField><field_name>custinstalldate</field_name><field_type>DATE</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.0.0'><WorkspaceConnectionString>DATABASE=C:\Users\caroline_chan\Water\Lead\Lead Service Line\LeadServiceLine.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LSLschema</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>plumbdate</field_name><field_name>custinstalldate</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.0.0'><WorkspaceConnectionString>DATABASE=C:\Users\caroline_chan\Water\Lead\Lead Service Line\LeadServiceLine.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LSLschema</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>plumbdate</field_name><field_type>DATE</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>custinstalldate</field_name><field_type>DATE</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>vulnpop</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>hipriority</field_name><field_type>SHORT</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>Yes_No</field_domain></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.0.0'><WorkspaceConnectionString>DATABASE=C:\Users\caroline_chan\Water\Lead\Lead Service Line\LeadServiceLine.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LSLschema</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>coordmethod</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.0.0'><WorkspaceConnectionString>DATABASE=C:\Users\caroline_chan\Water\Lead\Lead Service Line\LeadServiceLine.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LSLschema</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><CreateDomain><domain_name>coord_record</domain_name><field_type>SHORT</field_type><domain_type>CODED</domain_type><split_policy>DEFAULT</split_policy><merge_policy>DEFAULT</merge_policy></CreateDomain><AddCodedValueToDomain><domain_name>coord_record</domain_name><coded_values><coded_value><code>1</code><code_description>cellular phone</code_description></coded_value><coded_value><code>2</code><code_description>tablet</code_description></coded_value><coded_value><code>3</code><code_description>hand-held GPS</code_description></coded_value><coded_value><code>4</code><code_description>geocode from address</code_description></coded_value></coded_values></AddCodedValueToDomain></workflow><workflow><DeleteField><field_name>mainmaterial</field_name></DeleteField></workflow><workflow><AddField><field_name>coordmethod</field_name><field_type>SHORT</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>coord_record</field_domain></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.0.0'><WorkspaceConnectionString>DATABASE=C:\Users\caroline_chan\Water\Lead\Lead Service Line\LeadServiceLine.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LSLschema</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>vulnpop</field_name></DeleteField></workflow><workflow><AddField><field_name>mainmaterial</field_name><field_type>SHORT</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>Water_Service_Material</field_domain></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.0.0'><WorkspaceConnectionString>DATABASE=C:\Users\caroline_chan\Water\Lead\Lead Service Line\LeadServiceLine.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LSLschema</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><CreateDomain><domain_name>Vulnerble</domain_name><field_type>SHORT</field_type><domain_type>CODED</domain_type><split_policy>DEFAULT</split_policy><merge_policy>DEFAULT</merge_policy></CreateDomain><AddCodedValueToDomain><domain_name>Vulnerble</domain_name><coded_values><coded_value><code>1</code><code_description>School</code_description></coded_value><coded_value><code>2</code><code_description>Daycare</code_description></coded_value><coded_value><code>3</code><code_description>Healthcare facility</code_description></coded_value><coded_value><code>4</code><code_description>Pregnant</code_description></coded_value><coded_value><code>5</code><code_description>Young children</code_description></coded_value><coded_value><code>6</code><code_description>Elderly</code_description></coded_value></coded_values></AddCodedValueToDomain></workflow><workflow><AddField><field_name>vulnpop</field_name><field_type>SHORT</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>Vulnerble</field_domain></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.0.0'><WorkspaceConnectionString>DATABASE=C:\Users\caroline_chan\Water\Lead\Lead Service Line\LeadServiceLine.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LSLschema</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>utilpreslmat</field_name><field_name>custpreslmat</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.0.0'><WorkspaceConnectionString>DATABASE=C:\Users\caroline_chan\Water\Lead\Lead Service Line\LeadServiceLine.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LSLschema</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>utilpreslmat</field_name><field_type>SHORT</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>Water_Service_Material</field_domain></AddField></workflow><workflow><AddField><field_name>custpreslmat</field_name><field_type>SHORT</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>Water_Service_Material</field_domain></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.0.0'><WorkspaceConnectionString>DATABASE=C:\Users\caroline_chan\Water\Lead\Lead Service Line\LeadServiceLine.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LSLschema</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>goosematerial</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.0.0'><WorkspaceConnectionString>DATABASE=C:\Users\caroline_chan\Water\Lead\Lead Service Line\LeadServiceLine.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LSLschema</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>goosematerial</field_name><field_type>SHORT</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>Gooseneck</field_domain></AddField></workflow></operationSequence> ExportFeatures LSLschema "E:\Water\Lead\Lead Service Line\LeadServiceLine.gdb\LSLschemaA" # NOT_USE_ALIAS "accountid "Account ID" true true false 255 Text 0 0,First,#,LSLschema,accountid,0,255;address "Address" true true false 255 Text 0 0,First,#,LSLschema,address,0,255;utilassetid "System Asset ID" true true false 255 Text 0 0,First,#,LSLschema,utilassetid,0,255;utilmaterial "System Material" true true false 2 Short 0 0,First,#,LSLschema,utilmaterial,-1,-1;utildiameter "System Diameter" true true false 8 Double 0 0,First,#,LSLschema,utildiameter,-1,-1;utilinstalldate "System Install Date" true true false 8 Date 0 0,First,#,LSLschema,utilinstalldate,-1,-1;utilverifdate "System Verification Date" true true false 8 Date 0 0,First,#,LSLschema,utilverifdate,-1,-1;utilsource "System Source" true true false 2 Short 0 0,First,#,LSLschema,utilsource,-1,-1;utilstatus "System Status" true true false 2 Short 0 0,First,#,LSLschema,utilstatus,-1,-1;custassetid "Customer Asset ID" true true false 255 Text 0 0,First,#,LSLschema,custassetid,0,255;custmaterial "Customer Material" true true false 2 Short 0 0,First,#,LSLschema,custmaterial,-1,-1;custdiameter "Customer Diameter" true true false 8 Double 0 0,First,#,LSLschema,custdiameter,-1,-1;custverifdate "Customer Verification Date" true true false 8 Date 0 0,First,#,LSLschema,custverifdate,-1,-1;custsource "Customer Source" true true false 2 Short 0 0,First,#,LSLschema,custsource,-1,-1;custstatus "Customer Status" true true false 2 Short 0 0,First,#,LSLschema,custstatus,-1,-1;replacestatus "Replacement Status" true true false 2 Short 0 0,First,#,LSLschema,replacestatus,-1,-1;scheddate "Scheduled Replacement Date" true true false 8 Date 0 0,First,#,LSLschema,scheddate,-1,-1;custnotified "Notified Customer" true true false 2 Short 0 0,First,#,LSLschema,custnotified,-1,-1;notifydate "Notification Date" true true false 8 Date 0 0,First,#,LSLschema,notifydate,-1,-1;yearstructbuilt "Year Structure Built" true true false 2 Short 0 0,First,#,LSLschema,yearstructbuilt,-1,-1;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#,LSLschema,GlobalID,-1,-1;replacereason "Reason for Replacement" true true false 4 Long 0 0,First,#,LSLschema,replacereason,-1,-1;CreationDate "CreationDate" true true false 8 Date 0 0,First,#,LSLschema,CreationDate,-1,-1;Creator "Creator" true true false 128 Text 0 0,First,#,LSLschema,Creator,0,128;EditDate "EditDate" true true false 8 Date 0 0,First,#,LSLschema,EditDate,-1,-1;Editor "Editor" true true false 128 Text 0 0,First,#,LSLschema,Editor,0,128;bldgtype "Building Type" true true false 4 Long 0 0,First,#,LSLschema,bldgtype,-1,-1;locid "locid" true true false 255 Text 0 0,First,#,LSLschema,locid,0,255;city "city" true true false 255 Text 0 0,First,#,LSLschema,city,0,255;zip "zip" true true false 2 Short 0 0,First,#,LSLschema,zip,-1,-1;pwsid "pwsid" true true false 9 Text 0 0,First,#,LSLschema,pwsid,0,9;otherver "otherver" true true false 255 Text 0 0,First,#,LSLschema,otherver,0,255;lcrid "lcrid" true true false 255 Text 0 0,First,#,LSLschema,lcrid,0,255;slclass "slclass" true true false 2 Short 0 0,First,#,LSLschema,slclass,-1,-1;gooseverified "gooseverified" true true false 2 Short 0 0,First,#,LSLschema,gooseverified,-1,-1;utilsolder "utilsolder" true true false 2 Short 0 0,First,#,LSLschema,utilsolder,-1,-1;tapresults "tapresults" true true false 8 Double 0 0,First,#,LSLschema,tapresults,-1,-1;custsolder "custsolder" true true false 2 Short 0 0,First,#,LSLschema,custsolder,-1,-1;utilslmatver1 "utilslmatver1" true true false 255 Text 0 0,First,#,LSLschema,utilslmatver1,0,255;utilslmatver2 "utilslmatver2" true true false 255 Text 0 0,First,#,LSLschema,utilslmatver2,0,255;utilsleverlead "utilsleverlead" true true false 2 Short 0 0,First,#,LSLschema,utilsleverlead,-1,-1;custslmatver1 "custslmatver1" true true false 255 Text 0 0,First,#,LSLschema,custslmatver1,0,255;custslmatver2 "custslmatver2" true true false 255 Text 0 0,First,#,LSLschema,custslmatver2,0,255;custsleverlead "custsleverlead" true true false 2 Short 0 0,First,#,LSLschema,custsleverlead,-1,-1;plumbdate "plumbdate" true true false 8 Date 0 0,First,#,LSLschema,plumbdate,-1,-1;custinstalldate "custinstalldate" true true false 8 Date 0 0,First,#,LSLschema,custinstalldate,-1,-1;hipriority "hipriority" true true false 2 Short 0 0,First,#,LSLschema,hipriority,-1,-1;coordmethod "coordmethod" true true false 2 Short 0 0,First,#,LSLschema,coordmethod,-1,-1;mainmaterial "mainmaterial" true true false 2 Short 0 0,First,#,LSLschema,mainmaterial,-1,-1;vulnpop "vulnpop" true true false 2 Short 0 0,First,#,LSLschema,vulnpop,-1,-1;utilpreslmat "utilpreslmat" true true false 2 Short 0 0,First,#,LSLschema,utilpreslmat,-1,-1;custpreslmat "custpreslmat" true true false 2 Short 0 0,First,#,LSLschema,custpreslmat,-1,-1;goosematerial "goosematerial" true true false 2 Short 0 0,First,#,LSLschema,goosematerial,-1,-1" # ExportFeatures LSLschemaA "E:\ProProjects\LSL\missing name_a8207d\p20\Water\Lead\Lead Service Line\LeadServiceLine.gdb\LSLschemaA" # NOT_USE_ALIAS "accountid "Account ID" true true false 255 Text 0 0,First,#,LSLschemaA,accountid,0,255;address "Address" true true false 255 Text 0 0,First,#,LSLschemaA,address,0,255;utilassetid "System Asset ID" true true false 255 Text 0 0,First,#,LSLschemaA,utilassetid,0,255;utilmaterial "System Material" true true false 2 Short 0 0,First,#,LSLschemaA,utilmaterial,-1,-1;utildiameter "System Diameter" true true false 8 Double 0 0,First,#,LSLschemaA,utildiameter,-1,-1;utilinstalldate "System Install Date" true true false 8 Date 0 0,First,#,LSLschemaA,utilinstalldate,-1,-1;utilverifdate "System Verification Date" true true false 8 Date 0 0,First,#,LSLschemaA,utilverifdate,-1,-1;utilsource "System Source" true true false 2 Short 0 0,First,#,LSLschemaA,utilsource,-1,-1;utilstatus "System Status" true true false 2 Short 0 0,First,#,LSLschemaA,utilstatus,-1,-1;custassetid "Customer Asset ID" true true false 255 Text 0 0,First,#,LSLschemaA,custassetid,0,255;custmaterial "Customer Material" true true false 2 Short 0 0,First,#,LSLschemaA,custmaterial,-1,-1;custdiameter "Customer Diameter" true true false 8 Double 0 0,First,#,LSLschemaA,custdiameter,-1,-1;custverifdate "Customer Verification Date" true true false 8 Date 0 0,First,#,LSLschemaA,custverifdate,-1,-1;custsource "Customer Source" true true false 2 Short 0 0,First,#,LSLschemaA,custsource,-1,-1;custstatus "Customer Status" true true false 2 Short 0 0,First,#,LSLschemaA,custstatus,-1,-1;replacestatus "Replacement Status" true true false 2 Short 0 0,First,#,LSLschemaA,replacestatus,-1,-1;scheddate "Scheduled Replacement Date" true true false 8 Date 0 0,First,#,LSLschemaA,scheddate,-1,-1;custnotified "Notified Customer" true true false 2 Short 0 0,First,#,LSLschemaA,custnotified,-1,-1;notifydate "Notification Date" true true false 8 Date 0 0,First,#,LSLschemaA,notifydate,-1,-1;yearstructbuilt "Year Structure Built" true true false 2 Short 0 0,First,#,LSLschemaA,yearstructbuilt,-1,-1;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#,LSLschemaA,GlobalID,-1,-1;replacereason "Reason for Replacement" true true false 4 Long 0 0,First,#,LSLschemaA,replacereason,-1,-1;CreationDate "CreationDate" true true false 8 Date 0 0,First,#,LSLschemaA,CreationDate,-1,-1;Creator "Creator" true true false 128 Text 0 0,First,#,LSLschemaA,Creator,0,128;EditDate "EditDate" true true false 8 Date 0 0,First,#,LSLschemaA,EditDate,-1,-1;Editor "Editor" true true false 128 Text 0 0,First,#,LSLschemaA,Editor,0,128;bldgtype "Building Type" true true false 4 Long 0 0,First,#,LSLschemaA,bldgtype,-1,-1;locid "locid" true true false 255 Text 0 0,First,#,LSLschemaA,locid,0,255;city "city" true true false 255 Text 0 0,First,#,LSLschemaA,city,0,255;zip "zip" true true false 2 Short 0 0,First,#,LSLschemaA,zip,-1,-1;pwsid "pwsid" true true false 9 Text 0 0,First,#,LSLschemaA,pwsid,0,9;otherver "otherver" true true false 255 Text 0 0,First,#,LSLschemaA,otherver,0,255;lcrid "lcrid" true true false 255 Text 0 0,First,#,LSLschemaA,lcrid,0,255;slclass "slclass" true true false 2 Short 0 0,First,#,LSLschemaA,slclass,-1,-1;gooseverified "gooseverified" true true false 2 Short 0 0,First,#,LSLschemaA,gooseverified,-1,-1;utilsolder "utilsolder" true true false 2 Short 0 0,First,#,LSLschemaA,utilsolder,-1,-1;tapresults "tapresults" true true false 8 Double 0 0,First,#,LSLschemaA,tapresults,-1,-1;custsolder "custsolder" true true false 2 Short 0 0,First,#,LSLschemaA,custsolder,-1,-1;utilslmatver1 "utilslmatver1" true true false 255 Text 0 0,First,#,LSLschemaA,utilslmatver1,0,255;utilslmatver2 "utilslmatver2" true true false 255 Text 0 0,First,#,LSLschemaA,utilslmatver2,0,255;utilsleverlead "utilsleverlead" true true false 2 Short 0 0,First,#,LSLschemaA,utilsleverlead,-1,-1;custslmatver1 "custslmatver1" true true false 255 Text 0 0,First,#,LSLschemaA,custslmatver1,0,255;custslmatver2 "custslmatver2" true true false 255 Text 0 0,First,#,LSLschemaA,custslmatver2,0,255;custsleverlead "custsleverlead" true true false 2 Short 0 0,First,#,LSLschemaA,custsleverlead,-1,-1;plumbdate "plumbdate" true true false 8 Date 0 0,First,#,LSLschemaA,plumbdate,-1,-1;custinstalldate "custinstalldate" true true false 8 Date 0 0,First,#,LSLschemaA,custinstalldate,-1,-1;hipriority "hipriority" true true false 2 Short 0 0,First,#,LSLschemaA,hipriority,-1,-1;coordmethod "coordmethod" true true false 2 Short 0 0,First,#,LSLschemaA,coordmethod,-1,-1;mainmaterial "mainmaterial" true true false 2 Short 0 0,First,#,LSLschemaA,mainmaterial,-1,-1;vulnpop "vulnpop" true true false 2 Short 0 0,First,#,LSLschemaA,vulnpop,-1,-1;utilpreslmat "utilpreslmat" true true false 2 Short 0 0,First,#,LSLschemaA,utilpreslmat,-1,-1;custpreslmat "custpreslmat" true true false 2 Short 0 0,First,#,LSLschemaA,custpreslmat,-1,-1;goosematerial "goosematerial" true true false 2 Short 0 0,First,#,LSLschemaA,goosematerial,-1,-1" # UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><WorkspaceConnectionString>DATABASE=E:\ProProjects\LSL\missing name_a8207d\p20\Water\Lead\Lead Service Line\LeadServiceLine.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LSLschemaA</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>CreationDate</field_name><field_name>Creator</field_name><field_name>EditDate</field_name><field_name>Editor</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>DATABASE=E:\ProProjects\LSL\missing name_a8207d\p20\Water\Lead\Lead Service Line\LeadServiceLine.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LSLschemaA</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>accountid</field_name></DeleteField></workflow><workflow><AddField><field_name>lat</field_name><field_type>DOUBLE</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>long</field_name><field_type>DOUBLE</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><WorkspaceConnectionString>DATABASE=E:\ProProjects\LSL\missing name_a8207d\p20\Water\Lead\Lead Service Line\LeadServiceLine.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LSLschemaA</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>utilassetid</field_name><field_name>utilstatus</field_name><field_name>custassetid</field_name><field_name>custdiameter</field_name><field_name>custstatus</field_name><field_name>replacestatus</field_name><field_name>scheddate</field_name><field_name>custnotified</field_name><field_name>notifydate</field_name><field_name>replacereason</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>DATABASE=E:\ProProjects\LSL\missing name_a8207d\p20\Water\Lead\Lead Service Line\LeadServiceLine.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LSLschemaA</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>utilstatus</field_name><field_type>SHORT</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>Status</field_domain></AddField></workflow><workflow><AddField><field_name>custstatus</field_name><field_type>SHORT</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>Status</field_domain></AddField></workflow></operationSequence> CalculateField LSLschemaA utilstatus 1 Arcade # Text NO_ENFORCE_DOMAINS CalculateField LSLschemaA custstatus 1 Arcade # Text NO_ENFORCE_DOMAINS CalculateField LSLschemaA custstatus IsNan($feature.custmaterial) Arcade # Text NO_ENFORCE_DOMAINS CalculateField LSLschemaA custstatus 2 Arcade # Text NO_ENFORCE_DOMAINS CalculateField LSLschemaA custstatus 3 Arcade # Text NO_ENFORCE_DOMAINS CalculateField LSLschemaA custstatus 1 Arcade # Text NO_ENFORCE_DOMAINS CalculateField LSLschemaA utilmaterial 0 Arcade # Text NO_ENFORCE_DOMAINS CalculateField LSLschemaA utilmaterial 2 Arcade # Text NO_ENFORCE_DOMAINS CalculateField LSLschemaA utilmaterial 0 Arcade # Text NO_ENFORCE_DOMAINS CalculateField LSLschemaA utilmaterial 3 Arcade # Text NO_ENFORCE_DOMAINS CalculateField LSLschemaA utilstatus 3 Arcade # Text NO_ENFORCE_DOMAINS CalculateField LSLschemaA utilmaterial 89 Arcade # Text NO_ENFORCE_DOMAINS CalculateField LSLschemaA utilmaterial 109 Arcade # Text NO_ENFORCE_DOMAINS CalculateField LSLschemaA utilstatus 1 Arcade # Text NO_ENFORCE_DOMAINS CalculateField LSLschemaA utilstatus 2 Arcade # Text NO_ENFORCE_DOMAINS CalculateField LSLschemaA utilstatus 0 Arcade # Text NO_ENFORCE_DOMAINS CalculateField LSLschemaA utilstatus 3 Arcade # Text NO_ENFORCE_DOMAINS UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><WorkspaceConnectionString>DATABASE=E:\ProProjects\LSL\missing name_a8207d\p20\Water\Lead\Lead Service Line\LeadServiceLine.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LSLschemaA</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><CreateDomain><domain_name>Domain</domain_name><field_type>SHORT</field_type><domain_type>CODED</domain_type><split_policy>DEFAULT</split_policy><merge_policy>DEFAULT</merge_policy></CreateDomain><AddCodedValueToDomain><domain_name>Domain</domain_name></AddCodedValueToDomain></workflow><workflow><AddField><field_name>pws_name</field_name><field_type>SHORT</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><WorkspaceConnectionString>DATABASE=E:\ProProjects\LSL\missing name_a8207d\p20\Water\Lead\Lead Service Line\LeadServiceLine.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LSLschemaA</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>pws_name</field_name><domain_name>Status</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.1.0'><WorkspaceConnectionString>DATABASE=E:\ProProjects\LSL\missing name_a8207d\p20\Water\Lead\Lead Service Line\LeadServiceLine.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LSLschemaA</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>pws_name</field_name><domain_name>CodeS</domain_name></AssignDomainToField></workflow></operationSequence> ExportFeatures LSLschemaA "E:\Water\Lead\Lead Service Line\LeadServiceLine.gdb\LSLschemaB" # NOT_USE_ALIAS "address "Address" true true false 255 Text 0 0,First,#,LSLschemaA,address,0,255;utilmaterial "System Material" true true false 2 Short 0 0,First,#,LSLschemaA,utilmaterial,-1,-1;utildiameter "System Diameter" true true false 8 Double 0 0,First,#,LSLschemaA,utildiameter,-1,-1;utilinstalldate "System Install Date" true true false 8 Date 0 0,First,#,LSLschemaA,utilinstalldate,-1,-1;utilverifdate "System Verification Date" true true false 8 Date 0 0,First,#,LSLschemaA,utilverifdate,-1,-1;utilsource "System Source" true true false 2 Short 0 0,First,#,LSLschemaA,utilsource,-1,-1;custmaterial "Customer Material" true true false 2 Short 0 0,First,#,LSLschemaA,custmaterial,-1,-1;custverifdate "Customer Verification Date" true true false 8 Date 0 0,First,#,LSLschemaA,custverifdate,-1,-1;custsource "Customer Source" true true false 2 Short 0 0,First,#,LSLschemaA,custsource,-1,-1;yearstructbuilt "Year Structure Built" true true false 2 Short 0 0,First,#,LSLschemaA,yearstructbuilt,-1,-1;bldgtype "Building Type" true true false 4 Long 0 0,First,#,LSLschemaA,bldgtype,-1,-1;locid "locid" true true false 255 Text 0 0,First,#,LSLschemaA,locid,0,255;city "city" true true false 255 Text 0 0,First,#,LSLschemaA,city,0,255;zip "zip" true true false 2 Short 0 0,First,#,LSLschemaA,zip,-1,-1;pwsid "pwsid" true true false 9 Text 0 0,First,#,LSLschemaA,pwsid,0,9;otherver "otherver" true true false 255 Text 0 0,First,#,LSLschemaA,otherver,0,255;lcrid "lcrid" true true false 255 Text 0 0,First,#,LSLschemaA,lcrid,0,255;slclass "slclass" true true false 2 Short 0 0,First,#,LSLschemaA,slclass,-1,-1;gooseverified "gooseverified" true true false 2 Short 0 0,First,#,LSLschemaA,gooseverified,-1,-1;utilsolder "utilsolder" true true false 2 Short 0 0,First,#,LSLschemaA,utilsolder,-1,-1;tapresults "tapresults" true true false 8 Double 0 0,First,#,LSLschemaA,tapresults,-1,-1;custsolder "custsolder" true true false 2 Short 0 0,First,#,LSLschemaA,custsolder,-1,-1;utilslmatver1 "utilslmatver1" true true false 255 Text 0 0,First,#,LSLschemaA,utilslmatver1,0,255;utilslmatver2 "utilslmatver2" true true false 255 Text 0 0,First,#,LSLschemaA,utilslmatver2,0,255;utilsleverlead "utilsleverlead" true true false 2 Short 0 0,First,#,LSLschemaA,utilsleverlead,-1,-1;custslmatver1 "custslmatver1" true true false 255 Text 0 0,First,#,LSLschemaA,custslmatver1,0,255;custslmatver2 "custslmatver2" true true false 255 Text 0 0,First,#,LSLschemaA,custslmatver2,0,255;custsleverlead "custsleverlead" true true false 2 Short 0 0,First,#,LSLschemaA,custsleverlead,-1,-1;plumbdate "plumbdate" true true false 8 Date 0 0,First,#,LSLschemaA,plumbdate,-1,-1;custinstalldate "custinstalldate" true true false 8 Date 0 0,First,#,LSLschemaA,custinstalldate,-1,-1;hipriority "hipriority" true true false 2 Short 0 0,First,#,LSLschemaA,hipriority,-1,-1;coordmethod "coordmethod" true true false 2 Short 0 0,First,#,LSLschemaA,coordmethod,-1,-1;mainmaterial "mainmaterial" true true false 2 Short 0 0,First,#,LSLschemaA,mainmaterial,-1,-1;vulnpop "vulnpop" true true false 2 Short 0 0,First,#,LSLschemaA,vulnpop,-1,-1;utilpreslmat "utilpreslmat" true true false 2 Short 0 0,First,#,LSLschemaA,utilpreslmat,-1,-1;custpreslmat "custpreslmat" true true false 2 Short 0 0,First,#,LSLschemaA,custpreslmat,-1,-1;goosematerial "goosematerial" true true false 2 Short 0 0,First,#,LSLschemaA,goosematerial,-1,-1;lat "lat" true true false 8 Double 0 0,First,#,LSLschemaA,lat,-1,-1;long "long" true true false 8 Double 0 0,First,#,LSLschemaA,long,-1,-1;utilstatus "utilstatus" true true false 2 Short 0 0,First,#,LSLschemaA,utilstatus,-1,-1;custstatus "custstatus" true true false 2 Short 0 0,First,#,LSLschemaA,custstatus,-1,-1;pws_name "pws_name" true true false 2 Short 0 0,First,#,LSLschemaA,pws_name,-1,-1" # Append PrincetonFC LSLschemaB "Use the field map to reconcile field differences" "address "Address" true true false 255 Text 0 0,First,#,E:\Water\Lead\Lead Service Line\LeadServiceLine.gdb\PrincetonFC,Address,0,8000;utilmaterial "System Material" true true false 2 Short 0 0,First,#,E:\Water\Lead\Lead Service Line\LeadServiceLine.gdb\PrincetonFC,utilmaterial,-1,-1;utildiameter "System Diameter" true true false 8 Double 0 0,First,#,E:\Water\Lead\Lead Service Line\LeadServiceLine.gdb\PrincetonFC,utildiameter,-1,-1;utilinstalldate "System Install Date" true true false 8 Date 0 0,First,#;utilverifdate "System Verification Date" true true false 8 Date 0 0,First,#,E:\Water\Lead\Lead Service Line\LeadServiceLine.gdb\PrincetonFC,utilverifdate,-1,-1;utilsource "System Source" true true false 2 Short 0 0,First,#,E:\Water\Lead\Lead Service Line\LeadServiceLine.gdb\PrincetonFC,utilsource,-1,-1;custmaterial "Customer Material" true true false 2 Short 0 0,First,#,E:\Water\Lead\Lead Service Line\LeadServiceLine.gdb\PrincetonFC,custmaterial,-1,-1;custverifdate "Customer Verification Date" true true false 8 Date 0 0,First,#,E:\Water\Lead\Lead Service Line\LeadServiceLine.gdb\PrincetonFC,custverifdate,-1,-1;custsource "Customer Source" true true false 2 Short 0 0,First,#,E:\Water\Lead\Lead Service Line\LeadServiceLine.gdb\PrincetonFC,custsource,-1,-1;yearstructbuilt "Year Structure Built" true true false 2 Short 0 0,First,#;bldgtype "Building Type" true true false 4 Long 0 0,First,#,E:\Water\Lead\Lead Service Line\LeadServiceLine.gdb\PrincetonFC,bldgtype,-1,-1;locid "locid" true true false 255 Text 0 0,First,#;city "city" true true false 255 Text 0 0,First,#,E:\Water\Lead\Lead Service Line\LeadServiceLine.gdb\PrincetonFC,city,0,8000;zip "zip" true true false 2 Short 0 0,First,#,E:\Water\Lead\Lead Service Line\LeadServiceLine.gdb\PrincetonFC,zip,-1,-1;pwsid "pwsid" true true false 9 Text 0 0,First,#,E:\Water\Lead\Lead Service Line\LeadServiceLine.gdb\PrincetonFC,pwsid,0,8000;otherver "otherver" true true false 255 Text 0 0,First,#;lcrid "lcrid" true true false 255 Text 0 0,First,#;slclass "slclass" true true false 2 Short 0 0,First,#;gooseverified "gooseverified" true true false 2 Short 0 0,First,#;utilsolder "utilsolder" true true false 2 Short 0 0,First,#;tapresults "tapresults" true true false 8 Double 0 0,First,#;custsolder "custsolder" true true false 2 Short 0 0,First,#;utilslmatver1 "utilslmatver1" true true false 255 Text 0 0,First,#;utilslmatver2 "utilslmatver2" true true false 255 Text 0 0,First,#;utilsleverlead "utilsleverlead" true true false 2 Short 0 0,First,#;custslmatver1 "custslmatver1" true true false 255 Text 0 0,First,#;custslmatver2 "custslmatver2" true true false 255 Text 0 0,First,#;custsleverlead "custsleverlead" true true false 2 Short 0 0,First,#;plumbdate "plumbdate" true true false 8 Date 0 0,First,#;custinstalldate "custinstalldate" true true false 8 Date 0 0,First,#,E:\Water\Lead\Lead Service Line\LeadServiceLine.gdb\PrincetonFC,custinstalldate,-1,-1;hipriority "hipriority" true true false 2 Short 0 0,First,#;coordmethod "coordmethod" true true false 2 Short 0 0,First,#,E:\Water\Lead\Lead Service Line\LeadServiceLine.gdb\PrincetonFC,coordmethod,-1,-1;mainmaterial "mainmaterial" true true false 2 Short 0 0,First,#;vulnpop "vulnpop" true true false 2 Short 0 0,First,#;utilpreslmat "utilpreslmat" true true false 2 Short 0 0,First,#;custpreslmat "custpreslmat" true true false 2 Short 0 0,First,#;goosematerial "goosematerial" true true false 2 Short 0 0,First,#;lat "lat" true true false 8 Double 0 0,First,#,E:\Water\Lead\Lead Service Line\LeadServiceLine.gdb\PrincetonFC,lat,-1,-1;long "long" true true false 8 Double 0 0,First,#,E:\Water\Lead\Lead Service Line\LeadServiceLine.gdb\PrincetonFC,long,-1,-1;utilstatus "utilstatus" true true false 2 Short 0 0,First,#,E:\Water\Lead\Lead Service Line\LeadServiceLine.gdb\PrincetonFC,utilstatus,-1,-1;custstatus "custstatus" true true false 2 Short 0 0,First,#,E:\Water\Lead\Lead Service Line\LeadServiceLine.gdb\PrincetonFC,custstatus,-1,-1;pws_name "pws_name" true true false 2 Short 0 0,First,#,E:\Water\Lead\Lead Service Line\LeadServiceLine.gdb\PrincetonFC,pws_name,-1,-1" # # # NOT_UPDATE_GEOMETRY CalculateField LSLschemaB zip 42445 "Python 3" # Text NO_ENFORCE_DOMAINS ExportFeatures LSLschemaB "E:\Water\Lead\Lead Service Line\LeadServiceLine.gdb\LSLschemaC" # NOT_USE_ALIAS "address "Address" true true false 255 Text 0 0,First,#,LSLschemaB,address,0,255;utilmaterial "System Material" true true false 2 Short 0 0,First,#,LSLschemaB,utilmaterial,-1,-1;utildiameter "System Diameter" true true false 8 Double 0 0,First,#,LSLschemaB,utildiameter,-1,-1;utilinstalldate "System Install Date" true true false 8 Date 0 0,First,#,LSLschemaB,utilinstalldate,-1,-1;utilverifdate "System Verification Date" true true false 8 Date 0 0,First,#,LSLschemaB,utilverifdate,-1,-1;utilsource "System Source" true true false 2 Short 0 0,First,#,LSLschemaB,utilsource,-1,-1;custmaterial "Customer Material" true true false 2 Short 0 0,First,#,LSLschemaB,custmaterial,-1,-1;custverifdate "Customer Verification Date" true true false 8 Date 0 0,First,#,LSLschemaB,custverifdate,-1,-1;custsource "Customer Source" true true false 2 Short 0 0,First,#,LSLschemaB,custsource,-1,-1;yearstructbuilt "Year Structure Built" true true false 2 Short 0 0,First,#,LSLschemaB,yearstructbuilt,-1,-1;bldgtype "Building Type" true true false 4 Long 0 0,First,#,LSLschemaB,bldgtype,-1,-1;locid "locid" true true false 255 Text 0 0,First,#,LSLschemaB,locid,0,255;city "city" true true false 255 Text 0 0,First,#,LSLschemaB,city,0,255;zip "zip" true true false 2 Long 0 0,First,#,LSLschemaB,zip,-1,-1;pwsid "pwsid" true true false 9 Text 0 0,First,#,LSLschemaB,pwsid,0,9;otherver "otherver" true true false 255 Text 0 0,First,#,LSLschemaB,otherver,0,255;lcrid "lcrid" true true false 255 Text 0 0,First,#,LSLschemaB,lcrid,0,255;slclass "slclass" true true false 2 Short 0 0,First,#,LSLschemaB,slclass,-1,-1;gooseverified "gooseverified" true true false 2 Short 0 0,First,#,LSLschemaB,gooseverified,-1,-1;utilsolder "utilsolder" true true false 2 Short 0 0,First,#,LSLschemaB,utilsolder,-1,-1;tapresults "tapresults" true true false 8 Double 0 0,First,#,LSLschemaB,tapresults,-1,-1;custsolder "custsolder" true true false 2 Short 0 0,First,#,LSLschemaB,custsolder,-1,-1;utilslmatver1 "utilslmatver1" true true false 255 Text 0 0,First,#,LSLschemaB,utilslmatver1,0,255;utilslmatver2 "utilslmatver2" true true false 255 Text 0 0,First,#,LSLschemaB,utilslmatver2,0,255;utilsleverlead "utilsleverlead" true true false 2 Short 0 0,First,#,LSLschemaB,utilsleverlead,-1,-1;custslmatver1 "custslmatver1" true true false 255 Text 0 0,First,#,LSLschemaB,custslmatver1,0,255;custslmatver2 "custslmatver2" true true false 255 Text 0 0,First,#,LSLschemaB,custslmatver2,0,255;custsleverlead "custsleverlead" true true false 2 Short 0 0,First,#,LSLschemaB,custsleverlead,-1,-1;plumbdate "plumbdate" true true false 8 Date 0 0,First,#,LSLschemaB,plumbdate,-1,-1;custinstalldate "custinstalldate" true true false 8 Date 0 0,First,#,LSLschemaB,custinstalldate,-1,-1;hipriority "hipriority" true true false 2 Short 0 0,First,#,LSLschemaB,hipriority,-1,-1;coordmethod "coordmethod" true true false 2 Short 0 0,First,#,LSLschemaB,coordmethod,-1,-1;mainmaterial "mainmaterial" true true false 2 Short 0 0,First,#,LSLschemaB,mainmaterial,-1,-1;vulnpop "vulnpop" true true false 2 Short 0 0,First,#,LSLschemaB,vulnpop,-1,-1;utilpreslmat "utilpreslmat" true true false 2 Short 0 0,First,#,LSLschemaB,utilpreslmat,-1,-1;custpreslmat "custpreslmat" true true false 2 Short 0 0,First,#,LSLschemaB,custpreslmat,-1,-1;goosematerial "goosematerial" true true false 2 Short 0 0,First,#,LSLschemaB,goosematerial,-1,-1;lat "lat" true true false 8 Double 0 0,First,#,LSLschemaB,lat,-1,-1;long "long" true true false 8 Double 0 0,First,#,LSLschemaB,long,-1,-1;utilstatus "utilstatus" true true false 2 Short 0 0,First,#,LSLschemaB,utilstatus,-1,-1;custstatus "custstatus" true true false 2 Short 0 0,First,#,LSLschemaB,custstatus,-1,-1;pws_name "pws_name" true true false 2 Short 0 0,First,#,LSLschemaB,pws_name,-1,-1" # CalculateField LSLschemaC zip 42445 "Python 3" # Text NO_ENFORCE_DOMAINS AlterField LSLschemaC zip zip1 # "Long (32-bit integer)" 4 NULLABLE DO_NOT_CLEAR 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>DATABASE=E:\Water\Lead\Lead Service Line\LeadServiceLine.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LSLschemaC</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>zip</field_name><field_type>TEXT</field_type><field_length>10</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CalculateField LSLschemaC zip Text($feature.zip1) Arcade # Text NO_ENFORCE_DOMAINS UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><WorkspaceConnectionString>DATABASE=E:\Water\Lead\Lead Service Line\LeadServiceLine.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LSLschemaC</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>zip1</field_name></DeleteField></workflow></operationSequence> ExportFeatures LSLschemaC "E:\ProProjects\LSL\missing name_a8207d\p20\Water\Lead\Lead Service Line\LeadServiceLine.gdb\LSLschemaC" # NOT_USE_ALIAS "address "Address" true true false 255 Text 0 0,First,#,LSLschemaC,address,0,255;utilmaterial "System Material" true true false 2 Short 0 0,First,#,LSLschemaC,utilmaterial,-1,-1;utildiameter "System Diameter" true true false 8 Double 0 0,First,#,LSLschemaC,utildiameter,-1,-1;utilinstalldate "System Install Date" true true false 8 Date 0 0,First,#,LSLschemaC,utilinstalldate,-1,-1;utilverifdate "System Verification Date" true true false 8 Date 0 0,First,#,LSLschemaC,utilverifdate,-1,-1;utilsource "System Source" true true false 2 Short 0 0,First,#,LSLschemaC,utilsource,-1,-1;custmaterial "Customer Material" true true false 2 Short 0 0,First,#,LSLschemaC,custmaterial,-1,-1;custverifdate "Customer Verification Date" true true false 8 Date 0 0,First,#,LSLschemaC,custverifdate,-1,-1;custsource "Customer Source" true true false 2 Short 0 0,First,#,LSLschemaC,custsource,-1,-1;yearstructbuilt "Year Structure Built" true true false 2 Short 0 0,First,#,LSLschemaC,yearstructbuilt,-1,-1;bldgtype "Building Type" true true false 4 Long 0 0,First,#,LSLschemaC,bldgtype,-1,-1;locid "locid" true true false 255 Text 0 0,First,#,LSLschemaC,locid,0,255;city "city" true true false 255 Text 0 0,First,#,LSLschemaC,city,0,255;pwsid "pwsid" true true false 9 Text 0 0,First,#,LSLschemaC,pwsid,0,9;otherver "otherver" true true false 255 Text 0 0,First,#,LSLschemaC,otherver,0,255;lcrid "lcrid" true true false 255 Text 0 0,First,#,LSLschemaC,lcrid,0,255;slclass "slclass" true true false 2 Short 0 0,First,#,LSLschemaC,slclass,-1,-1;gooseverified "gooseverified" true true false 2 Short 0 0,First,#,LSLschemaC,gooseverified,-1,-1;utilsolder "utilsolder" true true false 2 Short 0 0,First,#,LSLschemaC,utilsolder,-1,-1;tapresults "tapresults" true true false 8 Double 0 0,First,#,LSLschemaC,tapresults,-1,-1;custsolder "custsolder" true true false 2 Short 0 0,First,#,LSLschemaC,custsolder,-1,-1;utilslmatver1 "utilslmatver1" true true false 255 Text 0 0,First,#,LSLschemaC,utilslmatver1,0,255;utilslmatver2 "utilslmatver2" true true false 255 Text 0 0,First,#,LSLschemaC,utilslmatver2,0,255;utilsleverlead "utilsleverlead" true true false 2 Short 0 0,First,#,LSLschemaC,utilsleverlead,-1,-1;custslmatver1 "custslmatver1" true true false 255 Text 0 0,First,#,LSLschemaC,custslmatver1,0,255;custslmatver2 "custslmatver2" true true false 255 Text 0 0,First,#,LSLschemaC,custslmatver2,0,255;custsleverlead "custsleverlead" true true false 2 Short 0 0,First,#,LSLschemaC,custsleverlead,-1,-1;plumbdate "plumbdate" true true false 8 Date 0 0,First,#,LSLschemaC,plumbdate,-1,-1;custinstalldate "custinstalldate" true true false 8 Date 0 0,First,#,LSLschemaC,custinstalldate,-1,-1;hipriority "hipriority" true true false 2 Short 0 0,First,#,LSLschemaC,hipriority,-1,-1;coordmethod "coordmethod" true true false 2 Short 0 0,First,#,LSLschemaC,coordmethod,-1,-1;mainmaterial "mainmaterial" true true false 2 Short 0 0,First,#,LSLschemaC,mainmaterial,-1,-1;vulnpop "vulnpop" true true false 2 Short 0 0,First,#,LSLschemaC,vulnpop,-1,-1;utilpreslmat "utilpreslmat" true true false 2 Short 0 0,First,#,LSLschemaC,utilpreslmat,-1,-1;custpreslmat "custpreslmat" true true false 2 Short 0 0,First,#,LSLschemaC,custpreslmat,-1,-1;goosematerial "goosematerial" true true false 2 Short 0 0,First,#,LSLschemaC,goosematerial,-1,-1;lat "lat" true true false 8 Double 0 0,First,#,LSLschemaC,lat,-1,-1;long "long" true true false 8 Double 0 0,First,#,LSLschemaC,long,-1,-1;utilstatus "utilstatus" true true false 2 Short 0 0,First,#,LSLschemaC,utilstatus,-1,-1;custstatus "custstatus" true true false 2 Short 0 0,First,#,LSLschemaC,custstatus,-1,-1;pws_name "pws_name" true true false 2 Short 0 0,First,#,LSLschemaC,pws_name,-1,-1;zip "zip" true true false 10 Text 0 0,First,#,LSLschemaC,zip,0,10" # CalculateField LSLschemaC pwsid 'KY0150242' Arcade # Text NO_ENFORCE_DOMAINS CalculateField LSLschemaC zip '40150' Arcade # Text NO_ENFORCE_DOMAINS CalculateField LSLschemaC pws_name 'Lebanon Junction Water Works' Arcade # Text NO_ENFORCE_DOMAINS CalculateField LSLschemaC pws_name 242 Arcade # Text NO_ENFORCE_DOMAINS CalculateField LSLschemaC pwsid 'KY0370143' Arcade # Text NO_ENFORCE_DOMAINS CalculateField LSLschemaC zip '42718' Arcade # Text NO_ENFORCE_DOMAINS CalculateField LSLschemaC pws_name 60 Arcade # Text NO_ENFORCE_DOMAINS CalculateField LSLschemaC pwsid 'KY1090060' Arcade # Text NO_ENFORCE_DOMAINS CalculateField LSLschemaC pws_name 232 Arcade # Text NO_ENFORCE_DOMAINS ExportFeatures LSLschemaC "D:\ProProjects\LSL\missing name_a8207d\p20\Water\Lead\Lead Service Line\LSL3.gdb\LSL_Inventory" # NOT_USE_ALIAS "pwsid "pwsid" true true false 9 Text 0 0,First,#,LSLschemaC,pwsid,0,9;pws_name "pws_name" true true false 2 Short 0 0,First,#,LSLschemaC,pws_name,-1,-1;address "Address" true true false 255 Text 0 0,First,#,LSLschemaC,address,0,255;city "city" true true false 255 Text 0 0,First,#,LSLschemaC,city,0,255;zip "zip" true true false 10 Text 0 0,First,#,LSLschemaC,zip,0,10;locid "locid" true true false 255 Text 0 0,First,#,LSLschemaC,locid,0,255;bldgtype "Building Type" true true false 4 Long 0 0,First,#,LSLschemaC,bldgtype,-1,-1;yearstructbuilt "Year Structure Built" true true false 2 Short 0 0,First,#,LSLschemaC,yearstructbuilt,-1,-1;utilmaterial "System Material" true true false 2 Short 0 0,First,#,LSLschemaC,utilmaterial,-1,-1;utilverifdate "System Verification Date" true true false 8 Date 0 0,First,#,LSLschemaC,utilverifdate,-1,-1;custmaterial "Customer Material" true true false 2 Short 0 0,First,#,LSLschemaC,custmaterial,-1,-1;custverifdate "Customer Verification Date" true true false 8 Date 0 0,First,#,LSLschemaC,custverifdate,-1,-1;otherver "otherver" true true false 255 Text 0 0,First,#,LSLschemaC,otherver,0,255;lcrid "lcrid" true true false 255 Text 0 0,First,#,LSLschemaC,lcrid,0,255;slclass "slclass" true true false 2 Short 0 0,First,#,LSLschemaC,slclass,-1,-1;gooseverified "gooseverified" true true false 2 Short 0 0,First,#,LSLschemaC,gooseverified,-1,-1;utilsolder "utilsolder" true true false 2 Short 0 0,First,#,LSLschemaC,utilsolder,-1,-1;tapresults "tapresults" true true false 8 Double 0 0,First,#,LSLschemaC,tapresults,-1,-1;utilslmatver1 "utilslmatver1" true true false 255 Text 0 0,First,#,LSLschemaC,utilslmatver1,0,255;utilsleverlead "utilsleverlead" true true false 2 Short 0 0,First,#,LSLschemaC,utilsleverlead,-1,-1;custslmatver1 "custslmatver1" true true false 255 Text 0 0,First,#,LSLschemaC,custslmatver1,0,255;plumbdate "plumbdate" true true false 8 Date 0 0,First,#,LSLschemaC,plumbdate,-1,-1;coordmethod "coordmethod" true true false 2 Short 0 0,First,#,LSLschemaC,coordmethod,-1,-1;mainmaterial "mainmaterial" true true false 2 Short 0 0,First,#,LSLschemaC,mainmaterial,-1,-1;goosematerial "goosematerial" true true false 2 Short 0 0,First,#,LSLschemaC,goosematerial,-1,-1;lat "lat" true true false 8 Double 0 0,First,#,LSLschemaC,lat,-1,-1;long "long" true true false 8 Double 0 0,First,#,LSLschemaC,long,-1,-1;utilstatus "utilstatus" true true false 2 Short 0 0,First,#,LSLschemaC,utilstatus,-1,-1;custstatus "custstatus" true true false 2 Short 0 0,First,#,LSLschemaC,custstatus,-1,-1" # UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.0.0'><WorkspaceConnectionString>DATABASE=D:\ProProjects\LSL\missing name_a8207d\p20\Water\Lead\Lead Service Line\LSL3.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LSL_Inventory</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" "<operationSequence><workflow><AssignDomainToField><field_name>bldgtype</field_name><domain_name>Utility Side | Customer Side_bldgtype_dc48ce0d-e48d-451c-8c93-8ba8c5a8b59b</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>custmaterial</field_name><domain_name>Utility Side | Customer Side_utilmaterial_51df8e30bfb1411580900a9c53b45482</domain_name></AssignDomainToField></workflow><workflow><AddField><field_name>custreplacedate</field_name><field_type>DATE</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Goose1</field_name><field_type>SHORT</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Goose2</field_name><field_type>SHORT</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Goose3</field_name><field_type>SHORT</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>Goose4</field_name><field_type>SHORT</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence>" UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.0.0'><WorkspaceConnectionString>DATABASE=D:\ProProjects\LSL\missing name_a8207d\p20\Water\Lead\Lead Service Line\LSL3.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LSL_Inventory</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AssignDomainToField><field_name>Goose1</field_name><domain_name>Gooseneck</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>Goose2</field_name><domain_name>Gooseneck</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>Goose3</field_name><domain_name>Gooseneck</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>Goose4</field_name><domain_name>Gooseneck</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.0.0'><WorkspaceConnectionString>DATABASE=D:\ProProjects\LSL\missing name_a8207d\p20\Water\Lead\Lead Service Line\LSL3.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LSL_Inventory</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>PlumbLead</field_name><field_type>SHORT</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>Yes_No</field_domain></AddField></workflow><workflow><AddField><field_name>SLID</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>STAT</field_name><field_type>SHORT</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>Yes_No</field_domain></AddField></workflow><workflow><AddField><field_name>UtilReplaceDate</field_name><field_type>DATE</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.0.0'><WorkspaceConnectionString>DATABASE=D:\ProProjects\LSL\missing name_a8207d\p20\Water\Lead\Lead Service Line\LSL3.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LSL_Inventory</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>goosematerial</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.0.0'><WorkspaceConnectionString>DATABASE=D:\ProProjects\LSL\missing name_a8207d\p20\Water\Lead\Lead Service Line\LSL3.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LSL_Inventory</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>yearstructbuilt</field_name><field_name>utilsleverlead</field_name><field_name>plumbdate</field_name><field_name>mainmaterial</field_name><field_name>utilstatus</field_name><field_name>custstatus</field_name></DeleteField></workflow><workflow><AddField><field_name>gooseOther</field_name><field_type>TEXT</field_type><field_length>255</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.0.0'><WorkspaceConnectionString>DATABASE=D:\ProProjects\LSL\missing name_a8207d\p20\Water\Lead\Lead Service Line\LSL3.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LSL_Inventory</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>PlumbLead</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.0.0'><WorkspaceConnectionString>DATABASE=D:\ProProjects\LSL\missing name_a8207d\p20\Water\Lead\Lead Service Line\LSL3.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LSL_Inventory</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>utilverifdate</field_name><field_name>custverifdate</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.0.0'><WorkspaceConnectionString>DATABASE=D:\ProProjects\LSL\missing name_a8207d\p20\Water\Lead\Lead Service Line\LSL3.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LSL_Inventory</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>plumbLead</field_name><field_type>SHORT</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>Yes_No</field_domain></AddField></workflow></operationSequence> CalculateField LSL_Inventory pwsid 'KY1112364' "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField LSL_Inventory pws_name 'LBL MAINTENANCE CENTER' "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField LSL_Inventory pws_name 'LBL MAINTENANCE CENTER' "Python 3" # Text NO_ENFORCE_DOMAINS CalculateField LSL_Inventory pws_name 'LBL MAINTENANCE CENTER' Arcade # Text NO_ENFORCE_DOMAINS CalculateField LSL_Inventory pws_name 237 Arcade # Text NO_ENFORCE_DOMAINS CalculateField LSL_Inventory city 'GOLDEN POND' Arcade # Text NO_ENFORCE_DOMAINS CalculateField LSL_Inventory zip '40342' Arcade # Text NO_ENFORCE_DOMAINS CalculateField LSL_Inventory SLID Concatenate('SL-0',TEXT($feature.OBJECTID-151)) Arcade # Text NO_ENFORCE_DOMAINS CalculateField LSL_Inventory utilmaterial 83 Arcade # Text NO_ENFORCE_DOMAINS CalculateField LSL_Inventory utilsolder 2 Arcade # Text NO_ENFORCE_DOMAINS CalculateField LSL_Inventory plumbLead 2 Arcade # Text NO_ENFORCE_DOMAINS CalculateField LSL_Inventory slclass 2 Arcade # Text NO_ENFORCE_DOMAINS Append LSL_Inventory_ExportTable_XYTableToPoint1 LSL_Inventory "Input fields must match target fields" # # # Append LSL_Inventory_ExportTable_XYTableToPoint2 LSL_Inventory "Input fields must match target fields" # # # UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.0.0'><WorkspaceConnectionString>DATABASE=D:\ProProjects\LSL\missing name_a8207d\p20\Water\Lead\Lead Service Line\LSL3.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LSL_Inventory</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><RemoveDomainFromField><field_name>custslmatver1</field_name></RemoveDomainFromField></workflow></operationSequence> Append LSL_Inventory_GrFleming LSL_Inventory "Input fields must match target fields" # # # UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.0.0'><WorkspaceConnectionString>DATABASE=D:\ProProjects\LSL\missing name_a8207d\p20\Water\Lead\Lead Service Line\LSL3.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LSL_Inventory</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>custvermet</field_name><field_type>SHORT</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>Customer_Source</field_domain></AddField></workflow><workflow><AddField><field_name>utilvermet</field_name><field_type>SHORT</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>Utility_Source</field_domain></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.0.0'><WorkspaceConnectionString>DATABASE=D:\ProProjects\LSL\missing name_a8207d\p20\Water\Lead\Lead Service Line\LSL3.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LSL_Inventory</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>utilslmatver1</field_name><field_name>custslmatver1</field_name></DeleteField></workflow></operationSequence> AlterField LSL_Inventory custvermet custslmatver1 "Customer-side verification method" "Short (16-bit integer)" 2 NULLABLE DO_NOT_CLEAR AlterField LSL_Inventory utilvermet utilslmatver1 "Customer-side verification method" "Short (16-bit integer)" 2 NULLABLE DO_NOT_CLEAR AlterField LSL_Inventory Goose1 # "Connector 1 Material" "Short (16-bit integer)" 2 NULLABLE DO_NOT_CLEAR AlterField LSL_Inventory Goose1 conn1 "Connector 1 Material" "Short (16-bit integer)" 2 NULLABLE DO_NOT_CLEAR AlterField LSL_Inventory Goose2 conn2 "Connector 2 Material" "Short (16-bit integer)" 2 NULLABLE DO_NOT_CLEAR AlterField LSL_Inventory conn2 conn2 "Connector 2 Material" "Short (16-bit integer)" 2 NULLABLE DO_NOT_CLEAR AlterField LSL_Inventory Goose3 conn3 "Connector 3 Material" "Short (16-bit integer)" 2 NULLABLE DO_NOT_CLEAR AlterField LSL_Inventory Goose4 conn4 "Connector 4 Material" "Short (16-bit integer)" 2 NULLABLE DO_NOT_CLEAR AlterField LSL_Inventory utilsolder leadsolder # "Short (16-bit integer)" 2 NULLABLE DO_NOT_CLEAR UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.0.0'><WorkspaceConnectionString>DATABASE=D:\ProProjects\LSL\missing name_a8207d\p20\Water\Lead\Lead Service Line\LSL3.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LSL_Inventory</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>Field</field_name><field_type>LONG</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> AlterField LSL_Inventory gooseverified connverified # "Short (16-bit integer)" 2 NULLABLE DO_NOT_CLEAR AlterField LSL_Inventory gooseOther connOtherver # Text 255 NULLABLE DO_NOT_CLEAR UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.0.0'><WorkspaceConnectionString>DATABASE=D:\ProProjects\LSL\missing name_a8207d\p20\Water\Lead\Lead Service Line\LSL3.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LSL_Inventory</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>Field</field_name></DeleteField></workflow><workflow><AssignDomainToField><field_name>connverified</field_name><domain_name>Utility_Source</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.0.0'><WorkspaceConnectionString>DATABASE=D:\ProProjects\LSL\missing name_a8207d\p20\Water\Lead\Lead Service Line\LSL3.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LSL_Inventory</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>fieldverdate</field_name><field_type>DATE</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>leadpremise</field_name><field_type>SHORT</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required><field_domain>Yes_No</field_domain></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>DATABASE=D:\ProProjects\LSL\missing name_a8207d\p20\Water\Lead\Lead Service Line\LSL3.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LSL_Inventory</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AddField><field_name>lcrisp</field_name><field_type>SHORT</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>tier</field_name><field_type>SHORT</field_type><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> AlterField LSL_Inventory lcrid lcrsp "LCR Sampling Point" Text 255 NULLABLE DO_NOT_CLEAR 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>DATABASE=D:\ProProjects\LSL\missing name_a8207d\p20\Water\Lead\Lead Service Line\LSL3.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LSL_Inventory</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>tier</field_name></DeleteField></workflow><workflow><AddField><field_name>tier</field_name><field_type>TEXT</field_type><field_length>5</field_length><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><WorkspaceConnectionString>DATABASE=D:\ProProjects\LSL\missing name_a8207d\p20\Water\Lead\Lead Service Line\LSL3.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LSL_Inventory</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AlterField><field_name>tier</field_name><new_field_name>tier1</new_field_name><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow></operationSequence> AlterField LSL_Inventory tier1 tier "LCRI Tier" Text 5 NULLABLE DO_NOT_CLEAR 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>DATABASE=D:\ProProjects\LSL\missing name_a8207d\p20\Water\Lead\Lead Service Line\LSL3.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LSL_Inventory</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>tapresults</field_name></DeleteField></workflow></operationSequence> ExportFeatures LSL_Inventory "D:\ProProjects\LSL\missing name_a8207d\LSL_WM_2.gdb\LSL_Inventory" # NOT_USE_ALIAS "pwsid "PWSID" true true false 9 Text 0 0,First,#,LSL_Inventory,pwsid,0,9;pws_name "PWS Name" true true false 2 Short 0 0,First,#,LSL_Inventory,pws_name,-1,-1;address "Address" true true false 255 Text 0 0,First,#,LSL_Inventory,address,0,255;city "City" true true false 255 Text 0 0,First,#,LSL_Inventory,city,0,255;zip "ZIP" true true false 10 Text 0 0,First,#,LSL_Inventory,zip,0,10;SLID "Service Line ID (SLID)" true true false 255 Text 0 0,First,#,LSL_Inventory,SLID,0,255;bldgtype "Building Type" true true false 4 Long 0 0,First,#,LSL_Inventory,bldgtype,-1,-1;custmaterial "Customer-owned SL Material" true true false 2 Short 0 0,First,#,LSL_Inventory,custmaterial,-1,-1;custslmatver1 "Customer-side verification method" true true false 2 Short 0 0,First,#,LSL_Inventory,custslmatver1,-1,-1;custreplacedate "Date replaced - customer-owned side" true true false 8 Date 0 0,First,#,LSL_Inventory,custreplacedate,-1,-1;conn1 "Connector 1 Material" true true false 2 Short 0 0,First,#,LSL_Inventory,conn1,-1,-1;conn2 "Connector 2 Material" true true false 2 Short 0 0,First,#,LSL_Inventory,conn2,-1,-1;conn3 "Connector 3 Material" true true false 2 Short 0 0,First,#,LSL_Inventory,conn3,-1,-1;conn4 "Connector 4 Material" true true false 2 Short 0 0,First,#,LSL_Inventory,conn4,-1,-1;connverified "Connector verification method" true true false 2 Short 0 0,First,#,LSL_Inventory,connverified,-1,-1;connOtherver "Connector - other or multiple verification" true true false 255 Text 0 0,First,#,LSL_Inventory,connOtherver,0,255;lcrsp "LCR Sampling Point" true true false 255 Text 0 0,First,#,LSL_Inventory,lcrsp,0,255;locid "Location identifier (optional)" true true false 255 Text 0 0,First,#,LSL_Inventory,locid,0,255;coordmethod "Coordinate recording method" true true false 2 Short 0 0,First,#,LSL_Inventory,coordmethod,-1,-1;lat "Latitude" true true false 8 Double 0 0,First,#,LSL_Inventory,lat,-1,-1;long "Longitude" true true false 8 Double 0 0,First,#,LSL_Inventory,long,-1,-1;otherver "Other verification method(s)" true true false 255 Text 0 0,First,#,LSL_Inventory,otherver,0,255;slclass "LCRR SL classification" true true false 2 Short 0 0,First,#,LSL_Inventory,slclass,-1,-1;STAT "Field verified for statistical method" true true false 2 Short 0 0,First,#,LSL_Inventory,STAT,-1,-1;utilmaterial "System-owned SL Material" true true false 2 Short 0 0,First,#,LSL_Inventory,utilmaterial,-1,-1;utilslmatver1 "System-side verification method" true true false 2 Short 0 0,First,#,LSL_Inventory,utilslmatver1,-1,-1;UtilReplaceDate "Date replaced - system side" true true false 8 Date 0 0,First,#,LSL_Inventory,UtilReplaceDate,-1,-1;leadsolder "Lead solder in SL" true true false 2 Short 0 0,First,#,LSL_Inventory,leadsolder,-1,-1;plumbLead "Upstream lead plumbing history" true true false 2 Short 0 0,First,#,LSL_Inventory,plumbLead,-1,-1;fieldverdate "Field verification date" true true false 8 Date 0 0,First,#,LSL_Inventory,fieldverdate,-1,-1;leadpremise "Lead premise plumbing" true true false 2 Short 0 0,First,#,LSL_Inventory,leadpremise,-1,-1;lcrisp "LCRI sampling point" true true false 2 Short 0 0,First,#,LSL_Inventory,lcrisp,-1,-1;tier "LCRI tier" true true false 5 Text 0 0,First,#,LSL_Inventory,tier,0,5" # UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.1.0'><WorkspaceConnectionString>DATABASE=D:\ProProjects\LSL\missing name_a8207d\LSL_WM_2.gdb</WorkspaceConnectionString><WorkspaceFactory>FileGDB</WorkspaceFactory><Dataset>LSL_Inventory</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><DeleteField><field_name>pws_name</field_name></DeleteField></workflow></operationSequence> CopyFeatures LSL_Inventory C:\Users\jeanluc.dobson\Documents\ArcGIS\Projects\MyProject9\depweb.world.sde\GIS_DEP.DOW_GRANT_WM\GIS_DEP.LSL_Inventory # # # # 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>GIS_DEP.DOW_GRANT_WM</FeatureDataset><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e686b367952796d72494371506f584c51334b714b44784f4b712b51456a6b4c31396644553346787a6272616b3d2a00;ENCRYPTED_PASSWORD=00022e68416b3563776833365735566a666b707768732b456742636b686e423153436f4661684c6a4c6b786274636f3d2a00;SERVER=depweb.world;INSTANCE=sde:oracle11g:depweb.world;DBCLIENT=oracle;DB_CONNECTION_PROPERTIES=depweb.world;PROJECT_INSTANCE=sde;USER=GIS_DEP;VERSION=SDE.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>GIS_DEP.LSL_Inventory</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMFeatureDatasetDataConnection>" "<operationSequence><workflow><AssignDomainToField><field_name>BLDGTYPE</field_name><domain_name>Utility Side | Customer Side_bldgtype_dc48ce0d-e48d-451c-8c93-8ba8c5a8b59b</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>CUSTMATERIAL</field_name><domain_name>Utility Side | Customer Side_utilmaterial_51df8e30bfb1411580900a9c53b45482</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>CUSTSLMATVER1</field_name><domain_name>Customer_Source</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>CONN1</field_name><domain_name>Gooseneck</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>CONN2</field_name><domain_name>Gooseneck</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>CONN3</field_name><domain_name>Gooseneck</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>CONN4</field_name><domain_name>Gooseneck</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>CONNVERIFIED</field_name><domain_name>Utility_Source</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>COORDMETHOD</field_name><domain_name>coord_record</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>SLCLASS</field_name><domain_name>Status</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>STAT</field_name><domain_name>Yes_No</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>UTILMATERIAL</field_name><domain_name>Utility Side | Customer Side_utilmaterial_51df8e30bfb1411580900a9c53b45482</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>UTILSLMATVER1</field_name><domain_name>Utility_Source</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>LEADSOLDER</field_name><domain_name>Yes_No</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>PLUMBLEAD</field_name><domain_name>Yes_No</domain_name></AssignDomainToField></workflow><workflow><AssignDomainToField><field_name>LEADPREMISE</field_name><domain_name>Yes_No</domain_name></AssignDomainToField></workflow></operationSequence>" Append 'C:\Users\caroline_chan\ProProjects\Water\Lead\Lead Service Line\LeadServiceLine.gdb\InventoryAppend_ExportTable_XYTableToPoint' GIS_DEP.LSL_Inventory "Input fields must match target fields" # # # # NOT_UPDATE_GEOMETRY Append 'C:\Users\caroline_chan\ProProjects\Water\Lead\Lead Service Line\LeadServiceLine.gdb\InventoryAppend_ExportTable_XYTableToPoint' GIS_DEP.LSL_Inventory "Input fields must match target fields" # # # # NOT_UPDATE_GEOMETRY Append 'C:\Users\caroline_chan\ProProjects\Water\Lead\Lead Service Line\LeadServiceLine.gdb\InventoryAppend_ExportTable_XYTableToPoint' GIS_DEP.LSL_Inventory "Input fields must match target fields" # # # # NOT_UPDATE_GEOMETRY Append InventoryAppend__ExportTable GIS_DEP.LSL_Inventory "Input fields must match target fields" # # # # NOT_UPDATE_GEOMETRY Append 'C:\Users\caroline_chan\ProProjects\Water\Lead\Lead Service Line\LeadServiceLine.gdb\InventoryAppend_ExportTable1' GIS_DEP.LSL_Inventory "Input fields must match target fields" # # # # NOT_UPDATE_GEOMETRY Append 'C:\Users\caroline_chan\ProProjects\Water\Lead\Lead Service Line\LeadServiceLine.gdb\InventoryAppend_ExportTable1_XYTableToPoint1' GIS_DEP.LSL_Inventory "Input fields must match target fields" # # # "PWSID PWSID;ADDRESS ADDRESS;SLID SLID" UPDATE_GEOMETRY Append InvCoord_Append GIS_DEP.LSL_Inventory "Input fields must match target fields" # # # # NOT_UPDATE_GEOMETRY CalculateField GIS_DEP.LSL_Inventory SLCLASS 3 "Python 3" Text NO_ENFORCE_DOMAINS CalculateField GIS_DEP.LSL_Inventory SLCLASS 3 Arcade # Text NO_ENFORCE_DOMAINS CalculateField GIS_DEP.LSL_Inventory SLCLASS 2 Arcade # Text NO_ENFORCE_DOMAINS CalculateField GIS_DEP.LSL_Inventory SLCLASS 2 Arcade # Text NO_ENFORCE_DOMAINS Append 'C:\Users\caroline_chan\ProProjects\Water\Lead\Lead Service Line\LeadServiceLine.gdb\LatLongInventoryAppend__LatLong_XYTableToPoint' GIS_DEP.LSL_Inventory "Input fields must match target fields" # # # "PWSID PWSID;ADDRESS ADDRESS;SLID SLID" UPDATE_GEOMETRY Append ModelBuilder\LatLongInventoryAppend__LatLong_XYTableToPoint:LatLongInventoryAppend__LatLong_XYTableToPoint GIS_DEP.LSL_Inventory "Input fields must match target fields" # # # # NOT_UPDATE_GEOMETRY CalculateField GIS_DEP.LSL_Inventory SHAPE Update(!Shape!,!LONG_!,!LAT!) "Python 3" "def Update(shape, newX, newY): pnt = shape.getPart(0) pnt.x = newX pnt.y = newY return pnt " Text NO_ENFORCE_DOMAINS Append InventoryAppend__Geocode:InventoryAppend__Geocode GIS_DEP.LSL_Inventory "Input fields must match target fields" # # # # NOT_UPDATE_GEOMETRY Append InventoryAppend__GeocodeInventoryAppend__Geocode_XYTableToPoint GIS_DEP.LSL_Inventory "Input fields must match target fields" # # # # NOT_UPDATE_GEOMETRY CalculateField GIS_DEP.LSL_Inventory SHAPE Update(!SHAPE!,!LONG_!,!LAT!) "Python 3" "def Update(shape, newX, newY): pnt = shape.getPart(0) pnt.x = newX pnt.y = newY return pnt " Text NO_ENFORCE_DOMAINS CalculateField GIS_DEP.LSL_Inventory SHAPE Update(!SHAPE!,!LONG_!,!LAT!) "Python 3" "def Update(shape, newX, newY): pnt = shape.getPart(0) pnt.x = newX pnt.y = newY return pnt " Text NO_ENFORCE_DOMAINS CalculateField GIS_DEP.LSL_Inventory SHAPE Update(!SHAPE!,!LONG_!,!LAT!) "Python 3" "def Update(shape, newX, newY): pnt = shape.getPart(0) pnt.x = newX pnt.y = newY return pnt " Text NO_ENFORCE_DOMAINS Append InventoryAppend__GeocodeInventoryAppend__Geocode_XYTableToPoint GIS_DEP.LSL_Inventory "Input fields must match target fields" # # # # NOT_UPDATE_GEOMETRY Append ModelBuilder\LatLongInventoryAppend__LatLong_XYTableToPoint:LatLongInventoryAppend__LatLong_XYTableToPoint GIS_DEP.LSL_Inventory "Input fields must match target fields" # # # # NOT_UPDATE_GEOMETRY Append GEocodeXY_ExportFeatures GIS_DEP.LSL_Inventory "Input fields must match target fields" # # # # NOT_UPDATE_GEOMETRY CalculateField GIS_DEP.LSL_Inventory SHAPE Update(!SHAPE!,!LONG_!,!LAT!) "Python 3" "def Update(shape, newX, newY): pnt = shape.getPart(0) pnt.x = newX pnt.y = newY return pnt " Text NO_ENFORCE_DOMAINS CalculateField GIS_DEP.LSL_Inventory SHAPE Update(!SHAPE!,!LONG_!,!LAT!) "Python 3" "def Update(shape, newX, newY): pnt = shape.getPart(0) pnt.x = newX pnt.y = newY return pnt " Text NO_ENFORCE_DOMAINS Append KY1060457_09192024 GIS_DEP.LSL_Inventory "Input fields must match target fields" # # # # NOT_UPDATE_GEOMETRY Append KY1070144_09062024 GIS_DEP.LSL_Inventory "Input fields must match target fields" # # # # NOT_UPDATE_GEOMETRY Append KY0700380_09172024 GIS_DEP.LSL_Inventory "Input fields must match target fields" # # # # NOT_UPDATE_GEOMETRY 20240507 13085500 20240507 13085500 Microsoft Windows 10 Version 10.0 (Build 19045) ; Esri ArcGIS 13.1.2.41833 LSL_Inventory LSL DOW Water LSL, DOW, Water Enterprise Geodatabase Feature Class dataset EPSG 6.18.3(9.3.1.2) 0 Simple FALSE 0 TRUE TRUE GIS_DEP.LSL_Inventory Feature Class 0 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. address Address String 255 0 0 utilmaterial System-owned SL Material SmallInteger 2 5 0 custmaterial Customer-owned SL Material SmallInteger 2 5 0 locid Location identifier (optional) String 255 0 0 city City String 255 0 0 SLID Service Line ID (SLID) String 255 0 0 zip ZIP String 10 0 0 pwsid PWSID String 9 0 0 otherver Other verification method(s) String 255 0 0 custreplacedate Date replaced - customer-owned side Date 8 0 0 conn1 Connector 1 Material SmallInteger 2 5 0 conn2 Connector 2 Material SmallInteger 2 5 0 conn3 Connector 3 Material SmallInteger 2 5 0 conn4 Connector 4 Material SmallInteger 2 5 0 connverified Connector verification method SmallInteger 2 5 0 connOtherver Connector - other or multiple verification String 255 0 0 lcrsp LCR Sampling Point String 255 0 0 slclass LCRR SL classification SmallInteger 2 5 0 LONG_ Longitude Double 8 38 8 utilslmatver1 System-side verification method SmallInteger 2 5 0 custslmatver1 Customer-side verification method SmallInteger 2 5 0 bldgtype Building Type Integer 4 10 0 coordmethod Coordinate recording method SmallInteger 2 5 0 lat Latitude Double 8 38 8 STAT Field verified for statistical method SmallInteger 2 5 0 UtilReplaceDate Date replaced - system side Date 8 0 0 leadsolder Lead solder in SL SmallInteger 2 5 0 plumbLead Upstream lead plumbing history SmallInteger 2 5 0 fieldverdate Field verification date Date 8 0 0 leadpremise Lead premise plumbing SmallInteger 2 5 0 lcrisp LCRI sampling point SmallInteger 2 5 0 tier LCRI tier String 5 0 0 20240507 /9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iii gAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKA CiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK KKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoo ooAKKKKACiiigAooooAKKKZJLHCu6WRUX1Y4FAD6KzpRfz6laz2d3b/2eAwnTGWc9sGtGgAoopru saF3YKqjJZjgAUAOoqnZarYakCbK8hn2nB8twcVcoAKKKKACiiigAooooAKKKKACiiigAooooAKK KKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAK5Px74Mk8aaXBZx6nPYmKTfuiON3Tr +VdZRQBg+EfDEfhTRV0+O8uLrByZJ2yc1vUUUBsFc9410/UNV8M3On6dCkktxhDvkKbRnk5BFdDR QDPlLS/Dnj3w74jkXTLG/wAwy8OsbFG/oRX1FpjXj6ZbtfqqXZjBlVOgbvVrA9BS02yYxUQoorw3 4n/FvVtE1ifS9GRYvssgEsz9Se4x6H+lIbaW57lRXn3wt8e3PjXTJWvY4VuIfvMhxu9Plr0GgE7q 6CiiigYUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFZmutrC6eP7ES3a78xc/aCdoXv070A adFZOreILLw/Yw3GqyiPzGCfKM/MaWz1oajZ3FzZW0ksaAmFjwJuOx+vFFhcyvY1aK4nx149k8GW NnMdMe4kuQ3yq3CEY6nHvXhuufGbxDqxmhlkNjGV2lIRweeOfpTSJlNI+qKK81+EPi+HXdCFhLcy S3sHLFzkFfavSqTHGXMrhRRWbqevabo8tvHfXSQm4fYm496CjD1LTfFE/j6wvLW6SPRIYyJI933m I7jvXXUyKaKYZikRx6qc0+gVgooooGFFFFABRRRQBRsLu7uJrlLmzMCxvtjbcCHHrXJeLvhZo/i/ U2vrp3hlaMJ+6AGSO59TXd0UXJcU1ZnnXw7+H83g7VNSkLD7M/7uHOCzDOc8dBXotNdd8bJkjcCM jqKo6Npf9kWH2b7TLcfOzb5Dk8nOKb1CMeXRGhRRRSKCiiigAooooAKKKKACiiigAooooAKKKKAC kV1cZRgw9Qc0pGRiqOk6VBo9n9ltjIY95fMjFjk+5oAvVDdPNHayvbxiSZVJRCcbj6VNVea7SG4h tyH3zZ2kLkDHqe1AHD65Zf8ACUX+i6frkP2KQjz1VTu3OvVPTHJ/Ku8hhjt4UhiQJGgwqgYAFcNp VlqUvjR0v9Qke4s8uCVUrJE3QAYyp6V3tNmcFuyG5tYLyFobiJJI2GCrDNeZXvwJ8O3d3NMtxPEs jFtgGcfjmvU6KVy3FPc4zwV8ONL8F7pLeR57g5AkbjAPbFdnRXL+IdG13UPEWj3WnakLawtmY3EW OXPY/wAx+NAJKK0OmdtiM2CcDOB1NfE/jLVtYv8AxPePqL3Kyea2yOYnKDPbPSvtO8ge5tJIY53g dhgSJjK/nXCeNPhNpPjC7ivpJpIL1ECNIoGHA9RjrQDPLPgDqd7H4llsHlm8lwdyEnbkD0/CvpWu b8LeBtE8I26rp9t+/wAYe4c5dz6//qrpKbFFNbhRRRSKCiiigAooooAKKKKACiiigAooooAKKKKA CiiigAooooAKKKKACiiigAooooAKKKKACjAoooATau7dgZ9aWiigAooooAKKKKACiiigAooooAKK KKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooo oAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiig AooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAC iiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKK KKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooo oAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiig AooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAC iiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKK KKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooA//2Q==