FALSE
1.0
20191222
06505800
file://\\bazfs05\data$\kestes\Projects\MeterRead_2020\MeterRead_2020.gdb
Local Area Network
ServiceConnections
002
DeleteIdentical "Water Service Connections" SHAPE # 0
Append H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters "Water Service Connections" "Use the Field Map to reconcile schema differences" "FACILITYID "Facility Identifier" true true false 20 Text 0 0,First,#;ACCOUNTID "Account Number" true true false 30 Text 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,AccountNumber_1,-1,-1;METSERVICE "Metered Service" true true false 5 Text 0 0,First,#;SERVICETYPE "Service Type" true true false 50 Text 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,CustomerType,0,8000;INSTALLDATE "Install Date" true true false 8 Date 0 0,First,#;LOCDESC "Location Description" true true false 200 Text 0 0,First,#;ROTATION "Rotation" true true false 8 Double 0 0,First,#;LOCATIONID "Location Identifier" true true false 20 Text 0 0,First,#;CRITICAL "CriticalCustomer" true true false 2 Short 0 0,First,#;ENABLED "Enabled" true true false 2 Short 0 0,First,#;ACTIVEFLAG "Active Flag" true true false 2 Short 0 0,First,#;OWNEDBY "Owned By" true true false 2 Short 0 0,First,#;MAINTBY "Managed By" true true false 2 Short 0 0,First,#;LASTUPDATE "Last Update Date" true true false 8 Date 0 0,First,#;LASTEDITOR "Last Editor" true true false 50 Text 0 0,First,#;GlobalID "GlobalID" false false true 38 Guid 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,GlobalID,-1,-1;SERVICEADDRESS "Service Address" true true false 50 Text 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,StreetAddress,0,8000;LARGEMETER "Large Meter Flag" true true false 2 Short 0 0,First,#;ROUTENUMBER "Route Number" true true false 4 Long 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,RouteNumber,-1,-1;CYCLENUMBER "Cycle Number" true true false 4 Long 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,CycleNumber,-1,-1;METERSERIALNUMBER "Meter Serial Number" true true false 4 Long 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,MeterSerialNumber,-1,-1;ERTNUMBER "ERT Number" true true false 4 Long 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,ERTNumber_1,-1,-1;TRUNCATIONCODE "Truncation Code" true true false 4 Long 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,TrunCode,-1,-1;ERTMODEL "ERT MODEL" true true false 25 Text 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,ERTModel,0,8000;METERMANUFACTURER "Meter Manufacturer" true true false 30 Text 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,MeterManufact,0,8000;INSPECTEDYES_NO "Inspected Yes/No" true true false 2 Short 0 0,First,#;NOTES "NOTES" true true false 250 Text 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,Notes,0,256;PIPESIZE "Pipe Size" true true false 4 Long 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,PipeSize,-1,-1;MANUFACTURERMODEL "Manufacturer Model" true true false 100 Text 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,ManufacturerModel,0,75" # #
Append H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters "Water Service Connections" "Use the Field Map to reconcile schema differences" "FACILITYID "Facility Identifier" true true false 20 Text 0 0,First,#;ACCOUNTID "Account Number" true true false 30 Text 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,AccountNumber_1,-1,-1;METSERVICE "Metered Service" true true false 5 Text 0 0,First,#;SERVICETYPE "Service Type" true true false 50 Text 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,CustomerType,0,8000;INSTALLDATE "Install Date" true true false 8 Date 0 0,First,#;LOCDESC "Location Description" true true false 200 Text 0 0,First,#;ROTATION "Rotation" true true false 8 Double 0 0,First,#;LOCATIONID "Location Identifier" true true false 20 Text 0 0,First,#;CRITICAL "CriticalCustomer" true true false 2 Short 0 0,First,#;ENABLED "Enabled" true true false 2 Short 0 0,First,#;ACTIVEFLAG "Active Flag" true true false 2 Short 0 0,First,#;OWNEDBY "Owned By" true true false 2 Short 0 0,First,#;MAINTBY "Managed By" true true false 2 Short 0 0,First,#;LASTUPDATE "Last Update Date" true true false 8 Date 0 0,First,#;LASTEDITOR "Last Editor" true true false 50 Text 0 0,First,#;GlobalID "GlobalID" false false true 38 Guid 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,GlobalID,-1,-1;SERVICEADDRESS "Service Address" true true false 50 Text 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,StreetAddress,0,8000;LARGEMETER "Large Meter Flag" true true false 2 Short 0 0,First,#;ROUTENUMBER "Route Number" true true false 4 Long 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,RouteNumber,-1,-1;CYCLENUMBER "Cycle Number" true true false 4 Long 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,CycleNumber,-1,-1;METERSERIALNUMBER "Meter Serial Number" true true false 4 Long 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,MeterSerialNumber,-1,-1;ERTNUMBER "ERT Number" true true false 4 Long 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,ERTNumber_1,-1,-1;TRUNCATIONCODE "Truncation Code" true true false 4 Long 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,TrunCode,-1,-1;ERTMODEL "ERT MODEL" true true false 25 Text 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,ERTModel,0,8000;METERMANUFACTURER "Meter Manufacturer" true true false 30 Text 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,MeterManufact,0,8000;INSPECTEDYES_NO "Inspected Yes/No" true true false 2 Short 0 0,First,#;NOTES "NOTES" true true false 250 Text 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,Notes,0,256;PIPESIZE "Pipe Size" true true false 4 Long 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,PipeSize,-1,-1;MANUFACTURERMODEL "Manufacturer Model" true true false 100 Text 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,ManufacturerModel,0,75" # "CustomerType <> ''"
Append H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters "Water Service Connections" "Use the Field Map to reconcile schema differences" "FACILITYID "Facility Identifier" true true false 20 Text 0 0,First,#;ACCOUNTID "Account Number" true true false 30 Text 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,AccountNumber_1,-1,-1;METSERVICE "Metered Service" true true false 5 Text 0 0,First,#;SERVICETYPE "Service Type" true true false 50 Text 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,CustomerType,0,8000;INSTALLDATE "Install Date" true true false 8 Date 0 0,First,#;LOCDESC "Location Description" true true false 200 Text 0 0,First,#;ROTATION "Rotation" true true false 8 Double 0 0,First,#;LOCATIONID "Location Identifier" true true false 20 Text 0 0,First,#;CRITICAL "CriticalCustomer" true true false 2 Short 0 0,First,#;ENABLED "Enabled" true true false 2 Short 0 0,First,#;ACTIVEFLAG "Active Flag" true true false 2 Short 0 0,First,#;OWNEDBY "Owned By" true true false 2 Short 0 0,First,#;MAINTBY "Managed By" true true false 2 Short 0 0,First,#;LASTUPDATE "Last Update Date" true true false 8 Date 0 0,First,#;LASTEDITOR "Last Editor" true true false 50 Text 0 0,First,#;GlobalID "GlobalID" false false true 38 Guid 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,GlobalID,-1,-1;SERVICEADDRESS "Service Address" true true false 50 Text 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,StreetAddress,0,8000;LARGEMETER "Large Meter Flag" true true false 2 Short 0 0,First,#;ROUTENUMBER "Route Number" true true false 4 Long 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,RouteNumber,-1,-1;CYCLENUMBER "Cycle Number" true true false 4 Long 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,CycleNumber,-1,-1;METERSERIALNUMBER "Meter Serial Number" true true false 4 Long 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,MeterSerialNumber,-1,-1;ERTNUMBER "ERT Number" true true false 4 Long 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,ERTNumber_1,-1,-1;TRUNCATIONCODE "Truncation Code" true true false 4 Long 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,TrunCode,-1,-1;ERTMODEL "ERT MODEL" true true false 25 Text 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,ERTModel,0,8000;METERMANUFACTURER "Meter Manufacturer" true true false 30 Text 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,MeterManufact,0,8000;INSPECTEDYES_NO "Inspected Yes/No" true true false 2 Short 0 0,First,#;NOTES "NOTES" true true false 250 Text 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,Notes,0,256;PIPESIZE "Pipe Size" true true false 4 Long 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,PipeSize,-1,-1;MANUFACTURERMODEL "Manufacturer Model" true true false 100 Text 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,ManufacturerModel,0,75" # "CustomerType = 'CM'"
Append H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters "Water Service Connections" "Use the Field Map to reconcile schema differences" "FACILITYID "Facility Identifier" true true false 20 Text 0 0,First,#;ACCOUNTID "Account Number" true true false 30 Text 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,AccountNumber_1,-1,-1;METSERVICE "Metered Service" true true false 5 Text 0 0,First,#;SERVICETYPE "Service Type" true true false 50 Text 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,CustomerType,0,8000;INSTALLDATE "Install Date" true true false 8 Date 0 0,First,#;LOCDESC "Location Description" true true false 200 Text 0 0,First,#;ROTATION "Rotation" true true false 8 Double 0 0,First,#;LOCATIONID "Location Identifier" true true false 20 Text 0 0,First,#;CRITICAL "CriticalCustomer" true true false 2 Short 0 0,First,#;ENABLED "Enabled" true true false 2 Short 0 0,First,#;ACTIVEFLAG "Active Flag" true true false 2 Short 0 0,First,#;OWNEDBY "Owned By" true true false 2 Short 0 0,First,#;MAINTBY "Managed By" true true false 2 Short 0 0,First,#;LASTUPDATE "Last Update Date" true true false 8 Date 0 0,First,#;LASTEDITOR "Last Editor" true true false 50 Text 0 0,First,#;GlobalID "GlobalID" false false true 38 Guid 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,GlobalID,-1,-1;SERVICEADDRESS "Service Address" true true false 50 Text 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,StreetAddress,0,8000;LARGEMETER "Large Meter Flag" true true false 2 Short 0 0,First,#;ROUTENUMBER "Route Number" true true false 4 Long 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,RouteNumber,-1,-1;CYCLENUMBER "Cycle Number" true true false 4 Long 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,CycleNumber,-1,-1;METERSERIALNUMBER "Meter Serial Number" true true false 4 Long 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,MeterSerialNumber,-1,-1;ERTNUMBER "ERT Number" true true false 4 Long 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,ERTNumber_1,-1,-1;TRUNCATIONCODE "Truncation Code" true true false 4 Long 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,TrunCode,-1,-1;ERTMODEL "ERT MODEL" true true false 25 Text 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,ERTModel,0,8000;METERMANUFACTURER "Meter Manufacturer" true true false 30 Text 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,MeterManufact,0,8000;INSPECTEDYES_NO "Inspected Yes/No" true true false 2 Short 0 0,First,#;NOTES "NOTES" true true false 250 Text 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,Notes,0,256;PIPESIZE "Pipe Size" true true false 4 Long 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,PipeSize,-1,-1;MANUFACTURERMODEL "Manufacturer Model" true true false 100 Text 0 0,First,#,H:\Projects\MeterReadBatch\12_10_19\WaterMeters_bak_12_9_19\CommercialLandscape_12_9.gdb\WaterMeters,ManufacturerModel,0,75" # "CustomerType = 'CM'"
Append WaterMeters "Water Service Connections" "Use the Field Map to reconcile schema differences" "FACILITYID "Facility Identifier" true true false 20 Text 0 0,First,#;ACCOUNTID "Account Number" true true false 30 Text 0 0,First,#,WaterMeters,AccountNumber_1,-1,-1;METSERVICE "Metered Service" true true false 5 Text 0 0,First,#;SERVICETYPE "Service Type" true true false 50 Text 0 0,First,#;INSTALLDATE "Install Date" true true false 8 Date 0 0,First,#;LOCDESC "Location Description" true true false 200 Text 0 0,First,#;ROTATION "Rotation" true true false 8 Double 0 0,First,#;LOCATIONID "Location Identifier" true true false 20 Text 0 0,First,#;CRITICAL "CriticalCustomer" true true false 2 Short 0 0,First,#;ENABLED "Enabled" true true false 2 Short 0 0,First,#;ACTIVEFLAG "Active Flag" true true false 2 Short 0 0,First,#;OWNEDBY "Owned By" true true false 2 Short 0 0,First,#;MAINTBY "Managed By" true true false 2 Short 0 0,First,#;LASTUPDATE "Last Update Date" true true false 8 Date 0 0,First,#;LASTEDITOR "Last Editor" true true false 50 Text 0 0,First,#;GlobalID "GlobalID" false false true 38 Guid 0 0,First,#,WaterMeters,GlobalID,-1,-1;SERVICEADDRESS "Service Address" true true false 50 Text 0 0,First,#,WaterMeters,StreetAddress,0,8000;LARGEMETER "Large Meter Flag" true true false 2 Short 0 0,First,#;ROUTENUMBER "Route Number" true true false 4 Long 0 0,First,#,WaterMeters,RouteNumber,-1,-1;CYCLENUMBER "Cycle Number" true true false 4 Long 0 0,First,#,WaterMeters,CycleNumber,-1,-1;METERSERIALNUMBER "Meter Serial Number" true true false 4 Long 0 0,First,#,WaterMeters,MeterSerialNumber,-1,-1;ERTNUMBER "ERT Number" true true false 4 Long 0 0,First,#,WaterMeters,ERTNumber_1,-1,-1;TRUNCATIONCODE "Truncation Code" true true false 4 Long 0 0,First,#,WaterMeters,TrunCode,-1,-1;ERTMODEL "ERT MODEL" true true false 25 Text 0 0,First,#,WaterMeters,ERTModel,0,8000;METERMANUFACTURER "Meter Manufacturer" true true false 30 Text 0 0,First,#,WaterMeters,MeterManufact,0,8000;INSPECTEDYES_NO "Inspected Yes/No" true true false 2 Short 0 0,First,#;NOTES "NOTES" true true false 250 Text 0 0,First,#,WaterMeters,Notes,0,256;PIPESIZE "Pipe Size" true true false 4 Long 0 0,First,#,WaterMeters,PipeSize,-1,-1;MANUFACTURERMODEL "Manufacturer Model" true true false 100 Text 0 0,First,#,WaterMeters,ManufacturerModel,0,75" # "CustomerType = 'LD' Or CustomerType = 'MF'"
Append WaterMeters "Water Service Connections" "Use the Field Map to reconcile schema differences" "FACILITYID "Facility Identifier" true true false 20 Text 0 0,First,#;ACCOUNTID "Account Number" true true false 30 Text 0 0,First,#,WaterMeters,AccountNumber_1,-1,-1;METSERVICE "Metered Service" true true false 5 Text 0 0,First,#;SERVICETYPE "Service Type" true true false 50 Text 0 0,First,#,WaterMeters,CustomerType,0,8000;INSTALLDATE "Install Date" true true false 8 Date 0 0,First,#;LOCDESC "Location Description" true true false 200 Text 0 0,First,#;ROTATION "Rotation" true true false 8 Double 0 0,First,#;LOCATIONID "Location Identifier" true true false 20 Text 0 0,First,#;CRITICAL "CriticalCustomer" true true false 2 Short 0 0,First,#;ENABLED "Enabled" true true false 2 Short 0 0,First,#;ACTIVEFLAG "Active Flag" true true false 2 Short 0 0,First,#;OWNEDBY "Owned By" true true false 2 Short 0 0,First,#;MAINTBY "Managed By" true true false 2 Short 0 0,First,#;LASTUPDATE "Last Update Date" true true false 8 Date 0 0,First,#;LASTEDITOR "Last Editor" true true false 50 Text 0 0,First,#;GlobalID "GlobalID" false false true 38 Guid 0 0,First,#,WaterMeters,GlobalID,-1,-1;SERVICEADDRESS "Service Address" true true false 50 Text 0 0,First,#,WaterMeters,StreetAddress,0,8000;LARGEMETER "Large Meter Flag" true true false 2 Short 0 0,First,#;ROUTENUMBER "Route Number" true true false 4 Long 0 0,First,#,WaterMeters,RouteNumber,-1,-1;CYCLENUMBER "Cycle Number" true true false 4 Long 0 0,First,#,WaterMeters,CycleNumber,-1,-1;METERSERIALNUMBER "Meter Serial Number" true true false 4 Long 0 0,First,#,WaterMeters,MeterSerialNumber,-1,-1;ERTNUMBER "ERT Number" true true false 4 Long 0 0,First,#,WaterMeters,ERTNumber_1,-1,-1;TRUNCATIONCODE "Truncation Code" true true false 4 Long 0 0,First,#,WaterMeters,TrunCode,-1,-1;ERTMODEL "ERT MODEL" true true false 25 Text 0 0,First,#,WaterMeters,ERTModel,0,8000;METERMANUFACTURER "Meter Manufacturer" true true false 30 Text 0 0,First,#,WaterMeters,MeterManufact,0,8000;INSPECTEDYES_NO "Inspected Yes/No" true true false 2 Short 0 0,First,#;NOTES "NOTES" true true false 250 Text 0 0,First,#,WaterMeters,Notes,0,256;PIPESIZE "Pipe Size" true true false 4 Long 0 0,First,#,WaterMeters,PipeSize,-1,-1;MANUFACTURERMODEL "Manufacturer Model" true true false 100 Text 0 0,First,#,WaterMeters,ManufacturerModel,0,75" # #
Append wServiceConnection_resforload "Water Service Connections" "Use the Field Map to reconcile schema differences" "FACILITYID "Facility Identifier" true true false 20 Text 0 0,First,#;ACCOUNTID "Account Number" true true false 30 Text 0 0,First,#,wServiceConnection_resforload,ACCOUNTID,0,30;METSERVICE "Metered Service" true true false 5 Text 0 0,First,#,wServiceConnection_resforload,METSERVICE,0,5;SERVICETYPE "Service Type" true true false 50 Text 0 0,First,#,wServiceConnection_resforload,SERVICETYPE,0,50;INSTALLDATE "Install Date" true true false 8 Date 0 0,First,#,wServiceConnection_resforload,INSTALLDATE,-1,-1;LOCDESC "Location Description" true true false 200 Text 0 0,First,#,wServiceConnection_resforload,LOCDESC,0,200;ROTATION "Rotation" true true false 8 Double 0 0,First,#,wServiceConnection_resforload,ROTATION,-1,-1;LOCATIONID "Location Identifier" true true false 20 Text 0 0,First,#,wServiceConnection_resforload,LOCATIONID,0,20;CRITICAL "CriticalCustomer" true true false 2 Short 0 0,First,#,wServiceConnection_resforload,CRITICAL,-1,-1;ENABLED "Enabled" true true false 2 Short 0 0,First,#,wServiceConnection_resforload,ENABLED,-1,-1;ACTIVEFLAG "Active Flag" true true false 2 Short 0 0,First,#,wServiceConnection_resforload,ACTIVEFLAG,-1,-1;OWNEDBY "Owned By" true true false 2 Short 0 0,First,#,wServiceConnection_resforload,OWNEDBY,-1,-1;MAINTBY "Managed By" true true false 2 Short 0 0,First,#,wServiceConnection_resforload,MAINTBY,-1,-1;LASTUPDATE "Last Update Date" true true false 8 Date 0 0,First,#,wServiceConnection_resforload,LASTUPDATE,-1,-1;LASTEDITOR "Last Editor" true true false 50 Text 0 0,First,#,wServiceConnection_resforload,LASTEDITOR,0,50;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#,wServiceConnection_resforload,GlobalID,-1,-1;SERVICEADDRESS "Service Address" true true false 50 Text 0 0,First,#,wServiceConnection_resforload,LOCDESC,0,50;LARGEMETER "Large Meter Flag" true true false 2 Short 0 0,First,#,wServiceConnection_resforload,LARGEMETER,-1,-1;ROUTENUMBER "Route Number" true true false 4 Long 0 0,First,#;CYCLENUMBER "Cycle Number" true true false 4 Long 0 0,First,#;METERSERIALNUMBER "Meter Serial Number" true true false 4 Long 0 0,First,#;ERTNUMBER "ERT Number" true true false 4 Long 0 0,First,#;TRUNCATIONCODE "Truncation Code" true true false 4 Long 0 0,First,#;ERTMODEL "ERT MODEL" true true false 25 Text 0 0,First,#;METERMANUFACTURER "Meter Manufacturer" true true false 30 Text 0 0,First,#;INSPECTEDYES_NO "Inspected Yes/No" true true false 2 Short 0 0,First,#;NOTES "NOTES" true true false 250 Text 0 0,First,#;PIPESIZE "Pipe Size" true true false 4 Long 0 0,First,#;MANUFACTURERMODEL "Manufacturer Model" true true false 100 Text 0 0,First,#" # #
Append wServiceConnection_resforload "Water Service Connections" "Use the Field Map to reconcile schema differences" "FACILITYID "Facility Identifier" true true false 20 Text 0 0,First,#;ACCOUNTID "Account Number" true true false 30 Text 0 0,First,#,wServiceConnection_resforload,ACCOUNTID,0,30;METSERVICE "Metered Service" true true false 5 Text 0 0,First,#,wServiceConnection_resforload,METSERVICE,0,5;SERVICETYPE "Service Type" true true false 50 Text 0 0,First,#,wServiceConnection_resforload,SERVICETYPE,0,50;INSTALLDATE "Install Date" true true false 8 Date 0 0,First,#,wServiceConnection_resforload,INSTALLDATE,-1,-1;LOCDESC "Location Description" true true false 200 Text 0 0,First,#,wServiceConnection_resforload,LOCDESC,0,200;ROTATION "Rotation" true true false 8 Double 0 0,First,#,wServiceConnection_resforload,ROTATION,-1,-1;LOCATIONID "Location Identifier" true true false 20 Text 0 0,First,#,wServiceConnection_resforload,LOCATIONID,0,20;CRITICAL "CriticalCustomer" true true false 2 Short 0 0,First,#,wServiceConnection_resforload,CRITICAL,-1,-1;ENABLED "Enabled" true true false 2 Short 0 0,First,#,wServiceConnection_resforload,ENABLED,-1,-1;ACTIVEFLAG "Active Flag" true true false 2 Short 0 0,First,#,wServiceConnection_resforload,ACTIVEFLAG,-1,-1;OWNEDBY "Owned By" true true false 2 Short 0 0,First,#,wServiceConnection_resforload,OWNEDBY,-1,-1;MAINTBY "Managed By" true true false 2 Short 0 0,First,#,wServiceConnection_resforload,MAINTBY,-1,-1;LASTUPDATE "Last Update Date" true true false 8 Date 0 0,First,#,wServiceConnection_resforload,LASTUPDATE,-1,-1;LASTEDITOR "Last Editor" true true false 50 Text 0 0,First,#,wServiceConnection_resforload,LASTEDITOR,0,50;GlobalID "GlobalID" false false true 38 GlobalID 0 0,First,#,wServiceConnection_resforload,GlobalID,-1,-1;SERVICEADDRESS "Service Address" true true false 50 Text 0 0,First,#,wServiceConnection_resforload,LOCDESC,0,50;LARGEMETER "Large Meter Flag" true true false 2 Short 0 0,First,#,wServiceConnection_resforload,LARGEMETER,-1,-1;ROUTENUMBER "Route Number" true true false 4 Long 0 0,First,#;CYCLENUMBER "Cycle Number" true true false 4 Long 0 0,First,#;METERSERIALNUMBER "Meter Serial Number" true true false 4 Long 0 0,First,#;ERTNUMBER "ERT Number" true true false 4 Long 0 0,First,#;TRUNCATIONCODE "Truncation Code" true true false 4 Long 0 0,First,#;ERTMODEL "ERT MODEL" true true false 25 Text 0 0,First,#;METERMANUFACTURER "Meter Manufacturer" true true false 30 Text 0 0,First,#;INSPECTEDYES_NO "Inspected Yes/No" true true false 2 Short 0 0,First,#;NOTES "NOTES" true true false 250 Text 0 0,First,#;PIPESIZE "Pipe Size" true true false 4 Long 0 0,First,#;MANUFACTURERMODEL "Manufacturer Model" true true false 100 Text 0 0,First,#" # #
CalculateField "Water Service Connections_Load" LOCATIONID !LOCATIONID!.strip() PYTHON_9.3 #
CalculateField "Water Service Connections_Load" LOCATIONID left( [LOCATIONID], 9) VB #
CalculateField "Water Service Connections_Load" LOCATIONID !LOCATIONID!.strip() PYTHON_9.3 #
CalculateField "Water Service Connections_Load" CRITICAL 0 VB #
CalculateField "Water Service Connections_Load" OWNEDBY "City of Buckeye" VB #
CalculateField "Water Service Connections_Load" OWNEDBY "City of Buckeye" VB #
CalculateField "Water Service Connections_Load" OWNEDBY "City of Buckeye" VB #
CalculateField "Water Service Connections_Load" FACILITYID ""WSRV-" + str(autoIncrement())" PYTHON_9.3 "rec=0 \ndef autoIncrement(): \n global rec \n pStart = 1 #adjust start value, if req'd \n pInterval = 1 #adjust interval value, if req'd \n if (rec == 0): \n rec = pStart \n else: \n rec = rec + pInterval \n return rec "
FeatureClassToFeatureClass H:\Projects\EnterpriseGDBMigration\Load_Utilities_ESRI_Model.gdb\WaterDistribution\wServiceConnection H:\Projects\MeterRead_2020\MeterRead_2020.gdb ServiceConnections # "FACILITYID "Facility Identifier" true true false 20 Text 0 0 ,First,#,H:\Projects\EnterpriseGDBMigration\Load_Utilities_ESRI_Model.gdb\WaterDistribution\wServiceConnection,FACILITYID,-1,-1;ACCOUNTID "Account Number" true true false 30 Text 0 0 ,First,#,H:\Projects\EnterpriseGDBMigration\Load_Utilities_ESRI_Model.gdb\WaterDistribution\wServiceConnection,ACCOUNTID,-1,-1;METSERVICE "Metered Service" true true false 5 Text 0 0 ,First,#,H:\Projects\EnterpriseGDBMigration\Load_Utilities_ESRI_Model.gdb\WaterDistribution\wServiceConnection,METSERVICE,-1,-1;SERVICETYPE "Service Type" true true false 50 Text 0 0 ,First,#,H:\Projects\EnterpriseGDBMigration\Load_Utilities_ESRI_Model.gdb\WaterDistribution\wServiceConnection,SERVICETYPE,-1,-1;INSTALLDATE "Install Date" true true false 8 Date 0 0 ,First,#,H:\Projects\EnterpriseGDBMigration\Load_Utilities_ESRI_Model.gdb\WaterDistribution\wServiceConnection,INSTALLDATE,-1,-1;LOCDESC "Location Description" true true false 200 Text 0 0 ,First,#,H:\Projects\EnterpriseGDBMigration\Load_Utilities_ESRI_Model.gdb\WaterDistribution\wServiceConnection,LOCDESC,-1,-1;ROTATION "Rotation" true true false 8 Double 0 0 ,First,#,H:\Projects\EnterpriseGDBMigration\Load_Utilities_ESRI_Model.gdb\WaterDistribution\wServiceConnection,ROTATION,-1,-1;LOCATIONID "Location Identifier" true true false 20 Text 0 0 ,First,#,H:\Projects\EnterpriseGDBMigration\Load_Utilities_ESRI_Model.gdb\WaterDistribution\wServiceConnection,LOCATIONID,-1,-1;CRITICAL "CriticalCustomer" true true false 2 Short 0 0 ,First,#,H:\Projects\EnterpriseGDBMigration\Load_Utilities_ESRI_Model.gdb\WaterDistribution\wServiceConnection,CRITICAL,-1,-1;ENABLED "Enabled" true true false 2 Short 0 0 ,First,#,H:\Projects\EnterpriseGDBMigration\Load_Utilities_ESRI_Model.gdb\WaterDistribution\wServiceConnection,ENABLED,-1,-1;ACTIVEFLAG "Active Flag" true true false 2 Short 0 0 ,First,#,H:\Projects\EnterpriseGDBMigration\Load_Utilities_ESRI_Model.gdb\WaterDistribution\wServiceConnection,ACTIVEFLAG,-1,-1;OWNEDBY "Owned By" true true false 2 Short 0 0 ,First,#,H:\Projects\EnterpriseGDBMigration\Load_Utilities_ESRI_Model.gdb\WaterDistribution\wServiceConnection,OWNEDBY,-1,-1;MAINTBY "Managed By" true true false 2 Short 0 0 ,First,#,H:\Projects\EnterpriseGDBMigration\Load_Utilities_ESRI_Model.gdb\WaterDistribution\wServiceConnection,MAINTBY,-1,-1;LASTUPDATE "Last Update Date" true true false 8 Date 0 0 ,First,#,H:\Projects\EnterpriseGDBMigration\Load_Utilities_ESRI_Model.gdb\WaterDistribution\wServiceConnection,LASTUPDATE,-1,-1;LASTEDITOR "Last Editor" true true false 50 Text 0 0 ,First,#,H:\Projects\EnterpriseGDBMigration\Load_Utilities_ESRI_Model.gdb\WaterDistribution\wServiceConnection,LASTEDITOR,-1,-1;GlobalID "GlobalID" false false true 38 GlobalID 0 0 ,First,#,H:\Projects\EnterpriseGDBMigration\Load_Utilities_ESRI_Model.gdb\WaterDistribution\wServiceConnection,GlobalID,-1,-1;SERVICEADDRESS "Service Address" true true false 50 Text 0 0 ,First,#,H:\Projects\EnterpriseGDBMigration\Load_Utilities_ESRI_Model.gdb\WaterDistribution\wServiceConnection,SERVICEADDRESS,-1,-1;LARGEMETER "Large Meter Flag" true true false 2 Short 0 0 ,First,#,H:\Projects\EnterpriseGDBMigration\Load_Utilities_ESRI_Model.gdb\WaterDistribution\wServiceConnection,LARGEMETER,-1,-1;ROUTENUMBER "Route Number" true true false 4 Long 0 0 ,First,#,H:\Projects\EnterpriseGDBMigration\Load_Utilities_ESRI_Model.gdb\WaterDistribution\wServiceConnection,ROUTENUMBER,-1,-1;CYCLENUMBER "Cycle Number" true true false 4 Long 0 0 ,First,#,H:\Projects\EnterpriseGDBMigration\Load_Utilities_ESRI_Model.gdb\WaterDistribution\wServiceConnection,CYCLENUMBER,-1,-1;METERSERIALNUMBER "Meter Serial Number" true true false 4 Long 0 0 ,First,#,H:\Projects\EnterpriseGDBMigration\Load_Utilities_ESRI_Model.gdb\WaterDistribution\wServiceConnection,METERSERIALNUMBER,-1,-1;ERTNUMBER "ERT Number" true true false 4 Long 0 0 ,First,#,H:\Projects\EnterpriseGDBMigration\Load_Utilities_ESRI_Model.gdb\WaterDistribution\wServiceConnection,ERTNUMBER,-1,-1;TRUNCATIONCODE "Truncation Code" true true false 4 Long 0 0 ,First,#,H:\Projects\EnterpriseGDBMigration\Load_Utilities_ESRI_Model.gdb\WaterDistribution\wServiceConnection,TRUNCATIONCODE,-1,-1;ERTMODEL "ERT MODEL" true true false 25 Text 0 0 ,First,#,H:\Projects\EnterpriseGDBMigration\Load_Utilities_ESRI_Model.gdb\WaterDistribution\wServiceConnection,ERTMODEL,-1,-1;METERMANUFACTURER "Meter Manufacturer" true true false 30 Text 0 0 ,First,#,H:\Projects\EnterpriseGDBMigration\Load_Utilities_ESRI_Model.gdb\WaterDistribution\wServiceConnection,METERMANUFACTURER,-1,-1;INSPECTEDYES_NO "Inspected Yes/No" true true false 2 Short 0 0 ,First,#,H:\Projects\EnterpriseGDBMigration\Load_Utilities_ESRI_Model.gdb\WaterDistribution\wServiceConnection,INSPECTEDYES_NO,-1,-1;NOTES "NOTES" true true false 250 Text 0 0 ,First,#,H:\Projects\EnterpriseGDBMigration\Load_Utilities_ESRI_Model.gdb\WaterDistribution\wServiceConnection,NOTES,-1,-1;PIPESIZE "Pipe Size" true true false 4 Long 0 0 ,First,#,H:\Projects\EnterpriseGDBMigration\Load_Utilities_ESRI_Model.gdb\WaterDistribution\wServiceConnection,PIPESIZE,-1,-1;MANUFACTURERMODEL "Manufacturer Model" true true false 100 Text 0 0 ,First,#,H:\Projects\EnterpriseGDBMigration\Load_Utilities_ESRI_Model.gdb\WaterDistribution\wServiceConnection,MANUFACTURERMODEL,-1,-1" #
Projected
GCS_North_American_1983_HARN
Linear Unit: Foot (0.304800)
NAD_1983_HARN_StatePlane_Arizona_Central_FIPS_0202_Feet_Intl
<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/10.7'><WKT>PROJCS["NAD_1983_HARN_StatePlane_Arizona_Central_FIPS_0202_Feet_Intl",GEOGCS["GCS_North_American_1983_HARN",DATUM["D_North_American_1983_HARN",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",700000.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-111.9166666666667],PARAMETER["Scale_Factor",0.9999],PARAMETER["Latitude_Of_Origin",31.0],UNIT["Foot",0.3048],AUTHORITY["EPSG",2868]]</WKT><XOrigin>-17746700</XOrigin><YOrigin>-44067300</YOrigin><XYScale>3048</XYScale><ZOrigin>-100000</ZOrigin><ZScale>10000</ZScale><MOrigin>-100000</MOrigin><MScale>10000</MScale><XYTolerance>0.0032808398950131198</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>2868</WKID><LatestWKID>2868</LatestWKID></ProjectedCoordinateSystem>
20200107
05082100
20200107
05082100
A point of service at the end of a lateral where water service is connected. It may be one meter or multiple meters with the same LocationID.
Water Service Connections
X-Ray
WaterDistribution
NaN
NaN
NaN
NaN
OBJECTID
OBJECTID
OID
4
0
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
SHAPE
Shape
Geometry
0
0
0
Feature geometry.
Esri
Coordinates defining the features.
ACCOUNTID
Account Number
String
30
0
0
Water billing account identifier
ACTIVEFLAG
Active Flag
SmallInteger
2
0
0
Indicates if the feature is in use/active
CRITICAL
CriticalCustomer
SmallInteger
2
0
0
Flag to indicate if this is a Critical Customer
ENABLED
Enabled
SmallInteger
2
0
0
Enabled
FACILITYID
Facility Identifier
String
20
0
0
Locally assigned Facility Identifier
GlobalID
GlobalID
GlobalID
38
0
0
GlobalID
INSTALLDATE
Install Date
Date
8
0
0
The date the asset was installed
LASTEDITOR
Last Editor
String
50
0
0
The user who performed the last update
LASTUPDATE
Last Update Date
Date
8
0
0
The date the feature was last updated in the maintenance database
LOCATIONID
Location Identifier
String
20
0
0
Location Identifier
LOCDESC
Location Description
String
200
0
0
Text Description of the geographic location
MAINTBY
Managed By
SmallInteger
2
0
0
Indicates which organization maintains the asset
METSERVICE
Metered Service
String
5
0
0
An indicator used to signify whether the service connection is metered
OWNEDBY
Owned By
SmallInteger
2
0
0
Indicates which organization owns the asset
ROTATION
Rotation
Double
8
0
0
Map Symbol Rotation value
SERVICETYPE
Service Type
String
50
0
0
The type of service connection
ServiceConnections
Feature Class
0
SERVICEADDRESS
Service Address
String
50
0
0
LARGEMETER
Large Meter Flag
SmallInteger
2
0
0
ROUTENUMBER
Route Number
Integer
4
0
0
CYCLENUMBER
Cycle Number
Integer
4
0
0
METERSERIALNUMBER
Meter Serial Number
Integer
4
0
0
ERTNUMBER
ERT Number
Integer
4
0
0
TRUNCATIONCODE
Truncation Code
Integer
4
0
0
ERTMODEL
ERT MODEL
String
25
0
0
METERMANUFACTURER
Meter Manufacturer
String
30
0
0
INSPECTEDYES_NO
Inspected Yes/No
SmallInteger
2
0
0
NOTES
NOTES
String
250
0
0
PIPESIZE
Pipe Size
Integer
4
0
0
MANUFACTURERMODEL
Manufacturer Model
String
100
0
0
Version 6.2 (Build 9200) ; Esri ArcGIS 10.7.1.11595
ServiceConnections
Meters
Meters
File Geodatabase Feature Class
dataset
EPSG
6.13(9.0.0)
0
Simple
FALSE
0
TRUE
FALSE
20200107