Name: Water.DATA_ADMIN6.tblLSLMaterialsInventory

Display Field: SITEID

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
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• SITEID ( type: esriFieldTypeString, alias: SITE ID, length: 50 )
• LOCATIONID ( type: esriFieldTypeString, alias: LOCATIONAL IDENTIFIER, length: 50 )
• LEAD_GOOSENECK ( type: esriFieldTypeString, alias: LEAD GOOSENECK CURRENTLY PRESENT, length: 5 , Coded Values: [Y: Y] , [N: N] , [UNK: UNK] )
• MATERIAL ( type: esriFieldTypeString, alias: CURRENT STREET SIDE SERVIC LINE MATERIAL, length: 10 , Coded Values: [L: CONFIRMED LEAD] , [C: CONFIRMED COPPER] , [G: CONFIRMED GALVANIZED] , ...6 more... )
• PREVIOUSLY_LEAD ( type: esriFieldTypeString, alias: WAS STREET SIDE SERVICE LINE EVER PREVIOUSLY LEAD, length: 5 , Coded Values: [Y: Y] , [N: N] , [UNK: UNK] )
• SIZE ( type: esriFieldTypeString, alias: STREET SIDE SERVICE LINE SIZE, length: 10 )
• INSTALLDATE ( type: esriFieldTypeInteger, alias: STREET SIDE SERVICE LINE INSTALL DATE )
• POMATERIAL ( type: esriFieldTypeString, alias: CURRENT PROPERTY SIDE SERVICE LINE MATERIAL, length: 10 , Coded Values: [L: CONFIRMED LEAD] , [C: CONFIRMED COPPER] , [G: CONFIRMED GALVANIZED] , ...6 more... )
• POSIZE ( type: esriFieldTypeString, alias: PROPERTY SIZE SERVICE LINE SIZE, length: 10 )
• POINSTALLDATE ( type: esriFieldTypeInteger, alias: PROPERTY SIDE SERVICE LINE INSTALL DATE )
• BUILDINGTYPE ( type: esriFieldTypeString, alias: BUILDING TYPE, length: 10 , Coded Values: [SF: SINGLE-FAMILY RESIDENTIAL] , [MF: MULTI-FAMILY RESIDENTIAL] , [SCH/CC: SCHOOL OR CHILD CARE] , ...4 more... )
• POE_TREATMENT ( type: esriFieldTypeString, alias: POINT-OF-ENTRY OR POINT-OF-USE TREATMENT PRESENT, length: 5 , Coded Values: [Y: Y] , [N: N] , [UNK: UNK] )
• BUILDINGMATERIAL1 ( type: esriFieldTypeString, alias: BUILDING PLUMBING MATERIAL 1, length: 5 , Coded Values: [CLS: COPPER WITH LEAD SOLDER] , [C: COPPER, NO LEAD SOLDER] , [O: OTHER MATERIAL THAT IS NOT COPPER, OR COPPER WITH LEAD SOLDER] , ...1 more... )
• BUILDINGMATERIAL2 ( type: esriFieldTypeString, alias: BUILDING PLUMBING MATERIAL 2, length: 5 , Coded Values: [CLS: COPPER WITH LEAD SOLDER] , [C: COPPER, NO LEAD SOLDER] , [O: OTHER MATERIAL THAT IS NOT COPPER, OR COPPER WITH LEAD SOLDER] , ...1 more... )
• BUILDINGMATERIALINSTALLDATE ( type: esriFieldTypeInteger, alias: BUILDING PLUMBING MATERIAL INSTALL DATE )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 255 )
• BASIS_MAT_CLASS ( type: esriFieldTypeString, alias: BASIS OF STREET SIDE MATERIAL CLASSIFICATION, length: 30 , Coded Values: [PREVIOUS EVAL: PREVIOUS MATERIALS EVALUATION] , [INSTALLATION RECORD: INSTALLATION RECORD (EG TAP CARD)] , [INSTALLED AFTER LEAD BAN: INSTALLATION AFTER LEAD BAN (1986)] , ...5 more... )
• MAT_FIELD_VERIFIED ( type: esriFieldTypeString, alias: WAS STREET SIDE MATERIAL FIELD VERIFIED, length: 5 , Coded Values: [Y: Y] , [N: N] , [UNK: UNK] )
• DATE_VERIFIED ( type: esriFieldTypeDate, alias: DATE OF STREET SIDE FIELD VERIFICATION, IF APPLICABLE, length: 8 )
• METHOD_VERIFIED ( type: esriFieldTypeString, alias: METHOD OF STREET SIDE FIELD VERIFICATION, IF APPLICABLE, length: 50 , Coded Values: [CUSTOMER SELF ID: CUSTOMER SELF IDENTIFICATION] , [CCTV - INTERNAL: CCTV AT CURB STOP - INTERNAL] , [CCTV - EXTERNAL: CCTV AT CURB STOP - EXTERNAL] , ...5 more... )
• BASIS_PO_MAT_CLASS ( type: esriFieldTypeString, alias: BASIS OF PROPERTY SIDE MATERIAL CLASSIFICATION, length: 30 , Coded Values: [PREVIOUS EVAL: PREVIOUS MATERIALS EVALUATION] , [INSTALLATION RECORD: INSTALLATION RECORD (EG TAP CARD)] , [INSTALLED AFTER LEAD BAN: INSTALLATION AFTER LEAD BAN (1986)] , ...5 more... )
• PO_MAT_FIELD ( type: esriFieldTypeString, alias: WATER PROPERTY SIDE MATERIAL FIELD VERIFIED, length: 5 , Coded Values: [Y: Y] , [N: N] , [UNK: UNK] )
• DATE_PO_VERIFIED ( type: esriFieldTypeDate, alias: DATE OF PROPERTY SIDE FIELD VERIFICATION, length: 8 )
• METHOD_PO_VERIFIED ( type: esriFieldTypeString, alias: METHOD OF PROPERTY SIDE FIELD VERIFICATION, length: 50 , Coded Values: [CUSTOMER SELF ID: CUSTOMER SELF IDENTIFICATION] , [CCTV - INTERNAL: CCTV AT CURB STOP - INTERNAL] , [CCTV - EXTERNAL: CCTV AT CURB STOP - EXTERNAL] , ...5 more... )
• NOTES_MAT_CLASS ( type: esriFieldTypeString, alias: NOTES_MAT_CLASS, length: 200 )
• ServiceLateralID ( type: esriFieldTypeString, alias: ServiceLateralID, length: 25 )
• PropertyID ( type: esriFieldTypeString, alias: PropertyID, length: 12 )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata