Name: Service Line Maintenance

Display Field: DATE

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• DATE ( type: esriFieldTypeDate, alias: DATE, length: 8 )
• WORK_PERFORMED ( type: esriFieldTypeString, alias: WORK PERFORMED, length: 50 , Coded Values: [New Installation: New Installation] , [Reservice: Reservice] , [Repair: Repair] , ...2 more... )
• DIAMETER ( type: esriFieldTypeString, alias: DIAMETER, length: 50 , Coded Values: [3/4": 3/4"] , [1": 1"] , [1 1/4": 1 1/4"] , ...20 more... )
• MATERIAL ( type: esriFieldTypeString, alias: MATERIAL, length: 50 , Coded Values: [Copper: Copper] , [Black Plastic: Black Plastic] , [?: ?] , ...3 more... )
• CUSTOMER_SIDE_MATERIAL ( type: esriFieldTypeString, alias: CUSTOMER SIDE MATERIAL, length: 50 , Coded Values: [Lead-Lined Galvanized: Lead-Lined Galvanized] , [Galvanized: Galvanized] , [Non-Lead Copper: Non-Lead Copper] , ...5 more... )
• LENGTH_ft ( type: esriFieldTypeString, alias: LENGTH ft, length: 50 )
• SERVICE_LOCATION ( type: esriFieldTypeString, alias: SERVICE LOCATION, length: 50 )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 250 )
• NUMBER_OF_EMPLOYEES ( type: esriFieldTypeString, alias: NUMBER OF EMPLOYEES, length: 255 , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...7 more... )
• EMPLOYEE_1 ( type: esriFieldTypeString, alias: EMPLOYEE 1, length: 255 , Coded Values: [Radio_68: Radio 68] , [Radio_69: Radio 69] , [Radio_70: Radio 70] , ...21 more... )
• EMPLOYEE_2 ( type: esriFieldTypeString, alias: EMPLOYEE 2, length: 255 , Coded Values: [Radio_68: Radio 68] , [Radio_69: Radio 69] , [Radio_70: Radio 70] , ...21 more... )
• EMPLOYEE_3 ( type: esriFieldTypeString, alias: EMPLOYEE 3, length: 255 , Coded Values: [Radio_68: Radio 68] , [Radio_69: Radio 69] , [Radio_70: Radio 70] , ...21 more... )
• EMPLOYEE_4 ( type: esriFieldTypeString, alias: EMPLOYEE 4, length: 255 , Coded Values: [Radio_68: Radio 68] , [Radio_69: Radio 69] , [Radio_70: Radio 70] , ...21 more... )
• EMPLOYEE_5 ( type: esriFieldTypeString, alias: EMPLOYEE 5, length: 255 , Coded Values: [Radio_68: Radio 68] , [Radio_69: Radio 69] , [Radio_70: Radio 70] , ...21 more... )
• EMPLOYEE_6 ( type: esriFieldTypeString, alias: EMPLOYEE 6, length: 255 , Coded Values: [Radio_68: Radio 68] , [Radio_69: Radio 69] , [Radio_70: Radio 70] , ...21 more... )
• EMPLOYEE_7 ( type: esriFieldTypeString, alias: EMPLOYEE 7, length: 255 , Coded Values: [Radio_68: Radio 68] , [Radio_69: Radio 69] , [Radio_70: Radio 70] , ...21 more... )
• EMPLOYEE_8 ( type: esriFieldTypeString, alias: EMPLOYEE 8, length: 255 , Coded Values: [Radio_68: Radio 68] , [Radio_69: Radio 69] , [Radio_70: Radio 70] , ...21 more... )
• EMPLOYEE_9 ( type: esriFieldTypeString, alias: EMPLOYEE 9, length: 255 , Coded Values: [Radio_68: Radio 68] , [Radio_69: Radio 69] , [Radio_70: Radio 70] , ...21 more... )
• EMPLOYEE_10 ( type: esriFieldTypeString, alias: EMPLOYEE 10, length: 255 , Coded Values: [Radio_68: Radio 68] , [Radio_69: Radio 69] , [Radio_70: Radio 70] , ...21 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• RelatedGUID ( type: esriFieldTypeGUID, alias: RelatedGUID, length: 38 )
• JOB_TIME ( type: esriFieldTypeDouble, alias: TIME TO COMPLETE JOB , Coded Values: [0.5: 0.5 Hours] , [1: 1 Hour] , [1.5: 1.5 Hours] , ...21 more... )
• METER_TYPE ( type: esriFieldTypeString, alias: Meter Type, length: 50 , Coded Values: [Residential: Residential] , [Irrigation: Irrigation] , [Commercial: Commercial] , ...3 more... )
• MATERIAL_COST ( type: esriFieldTypeDouble, alias: Material Cost($) ? )
• SensitivePopulation ( type: esriFieldTypeString, alias: Sensitive Population?, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• DisadvantagedNeighborhood ( type: esriFieldTypeString, alias: Disadvantaged Neighborhood?, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• WasServiceLineMaterialEverPrevi ( type: esriFieldTypeString, alias: Was Service Line Material Ever Previously Lead?, length: 50 , Coded Values: [Yes: Yes] , [No: No] , [?: ?] )
• ServiceLineInstallationDate ( type: esriFieldTypeDate, alias: Service Line Installation Date, length: 8 )
• ServiceLineBasisofMaterialClass ( type: esriFieldTypeString, alias: Service Line Basis of Material Classification, length: 50 , Coded Values: [Installation Record: Installation Record (e.g., Tap Card)] , [Installtion Date After Lead Ban: Installtion Date After Lead Ban] , [Service Line Diameter is > 2": Service Line Diameter is > 2"] , ...5 more... )
• ServiceLineMaterialFieldVerifie ( type: esriFieldTypeString, alias: Service Line Material Field Verified?, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• HowServiceLineMaterialFieldVeri ( type: esriFieldTypeString, alias: How Service Line Material Field Verified?, length: 50 , Coded Values: [Visual Inspection at the Meter Pit: Visual Inspection at the Meter Pit] , [Mechanical Excavation at One Location: Mechanical Excavation at One Location] , [Mechanical Excavation at Multiple Locations: Mechanical Excavation at Multiple Locations] , ...2 more... )
• ServiceLineFieldVerificationDat ( type: esriFieldTypeDate, alias: Service Line Field Verification Date, length: 8 )
• ServiceLineComments ( type: esriFieldTypeString, alias: Service Line Comments, length: 250 )
• CustomerSideLineInstallationDat ( type: esriFieldTypeDate, alias: Customer Side Line Installation Date, length: 8 )
• CustomerSideLineSize ( type: esriFieldTypeString, alias: Customer Side Line Size, length: 50 , Coded Values: [3/4": 3/4"] , [1": 1"] , [1 1/4": 1 1/4"] , ...20 more... )
• CustomerSideBasisOfMaterialClas ( type: esriFieldTypeString, alias: Customer Side Basis of Material Classificication, length: 50 , Coded Values: [Installation Record: Installation Record (e.g., Tap Card)] , [Installtion Date After Lead Ban: Installtion Date After Lead Ban] , [Service Line Diameter is > 2": Service Line Diameter is > 2"] , ...5 more... )
• CustomerSideLineFieldVerified ( type: esriFieldTypeString, alias: Was Customer Side Line Field Verified?, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• HowWasCustomerSideFieldVerified ( type: esriFieldTypeString, alias: How was Customer Side Field Verified?, length: 50 , Coded Values: [Customer Self-Identification: Customer Self-Identification] , [Visual Inspection at the Meter Pit: Visual Inspection at the Meter Pit] , [Mechanical Excavation at One Location: Mechanical Excavation at One Location] , ...2 more... )
• CustomerSideFieldVerificationDa ( type: esriFieldTypeDate, alias: Customer Side Field Verification Date, length: 8 )
• IsThereLeadConnector ( type: esriFieldTypeString, alias: Is There a Lead Connector, length: 50 , Coded Values: [Yes: Yes] , [No: No] , [?: ?] )
• DescribeOtherThatMayContainLead ( type: esriFieldTypeString, alias: Describe OtherFitting/Equipment Connected That May Contain Lead, length: 250 )
• CustomerSideBuildingType ( type: esriFieldTypeString, alias: Customer Side Building Type, length: 50 , Coded Values: [Single Family Residential: Single Family Residential] , [Multiple Family Residential: Multiple Family Residential] , [Building: Building] , ...1 more... )
• PointofEntryorPointofUseTreatme ( type: esriFieldTypeString, alias: Point-of-Entry or Point-of-Use Treatment Present?, length: 50 , Coded Values: [Yes: Yes] , [No: No] , [?: ?] )
• InteriorBuildingPlumbingCopperB ( type: esriFieldTypeString, alias: Interior Building Plumbing Contain Copper Pipes with Lead Solder Before1988, length: 50 , Coded Values: [Yes: Yes] , [No: No] , [?: ?] )
• CurrentLCRSampleSite ( type: esriFieldTypeString, alias: Current LCR Sampling Site?, length: 50 , Coded Values: [Yes: Yes] , [No: No] )

Relationships:

• Laterals (10) -- Related To: Laterals (29)

Supported Operations:   Query   Query Attachments   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata