Name: Inventory_120Water

Display Field: location_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: b2ff18caf79c475ca19f85feac1c50b6

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -111.96487248599999
YMin: 33.79963590400007
XMax: -111.87449792999996
YMax: 33.84542945700008
Spatial Reference: 4326  (4326)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: false
Supports Query With Current User: true

HasZ: true

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• locationid_external ( type: esriFieldTypeString, alias: EXTERNAL LOCATION ID, length: 8000 )
• customerid ( type: esriFieldTypeString, alias: CUSTOMER ID, length: 8000 )
• assetid_120water ( type: esriFieldTypeInteger, alias: 120WATER ASSET ID )
• assetid_external ( type: esriFieldTypeString, alias: EXTERNAL ASSET ID, length: 8000 )
• address1 ( type: esriFieldTypeString, alias: ADDRESS LINE 1, length: 8000 )
• address2 ( type: esriFieldTypeString, alias: ADDRESS LINE 2, length: 8000 )
• city ( type: esriFieldTypeString, alias: CITY, length: 8000 )
• state ( type: esriFieldTypeString, alias: STATE, length: 8000 )
• zip ( type: esriFieldTypeString, alias: ZIP, length: 8000 )
• county ( type: esriFieldTypeString, alias: COUNTY, length: 8000 )
• mailing_address1 ( type: esriFieldTypeString, alias: MAILING ADDRESS LINE 1, length: 8000 )
• mailing_address2 ( type: esriFieldTypeString, alias: MAILING ADDRESS LINE 2, length: 8000 )
• mailing_city ( type: esriFieldTypeString, alias: MAILING CITY, length: 8000 )
• mailing_state ( type: esriFieldTypeString, alias: MAILING STATE, length: 8000 )
• mailing_zip ( type: esriFieldTypeString, alias: MAILING ZIP, length: 8000 )
• building ( type: esriFieldTypeString, alias: BUILDING, length: 8000 )
• neighborhood ( type: esriFieldTypeString, alias: NEIGHBORHOOD, length: 8000 )
• location_name ( type: esriFieldTypeString, alias: LOCATION NAME, length: 8000 )
• latitude ( type: esriFieldTypeDouble, alias: LATITUDE )
• longitude ( type: esriFieldTypeDouble, alias: LONGITUDE )
• locationid_gis ( type: esriFieldTypeString, alias: GIS LOCATION ID, length: 8000 )
• dwelr_code ( type: esriFieldTypeString, alias: DWELR CODE, length: 8000 )
• lcr_tier ( type: esriFieldTypeString, alias: LCR TIER, length: 8000 )
• property_class ( type: esriFieldTypeString, alias: PROPERTY CLASSIFICATION, length: 8000 , Coded Values: [SingleFamilyResidence: SingleFamilyResidence] , [Single Family Residence: Single Family Residence] , [Commercial: Commercial] , ...21 more... )
• parcel_number ( type: esriFieldTypeString, alias: PARCEL NUMBER, length: 8000 )
• yrbuilt ( type: esriFieldTypeSmallInteger, alias: YEAR BUILT )
• lot_sqfeet ( type: esriFieldTypeSingle, alias: LOT SQUARE FEET )
• main_material ( type: esriFieldTypeString, alias: WATER MAIN MATERIAL, length: 8000 )
• main_size ( type: esriFieldTypeSingle, alias: WATER MAIN SIZE )
• main_install_year ( type: esriFieldTypeSmallInteger, alias: WATER MAIN INSTALLED YEAR )
• curb_size ( type: esriFieldTypeSingle, alias: CURB STOP SIZE )
• curb_install_year ( type: esriFieldTypeSmallInteger, alias: CURB STOP INSTALLED YEAR )
• meter_material ( type: esriFieldTypeString, alias: METER MATERIAL, length: 8000 )
• meter_size ( type: esriFieldTypeSingle, alias: METER SIZE )
• meter_install_year ( type: esriFieldTypeSmallInteger, alias: METER INSTALLED YEAR )
• other_buildings ( type: esriFieldTypeString, alias: OTHER BUILDINGS ON PROPERTY, length: 8000 , Coded Values: [False: False] , [True: True] )
• children_under_7 ( type: esriFieldTypeString, alias: HAS CHILDREN UNDER 7, length: 8000 , Coded Values: [False: False] , [True: True] )
• pregnant_women ( type: esriFieldTypeString, alias: HAS PREGNANT WOMEN, length: 8000 , Coded Values: [False: False] , [True: True] )
• disadvantaged_neighborhood ( type: esriFieldTypeString, alias: DISADVANTAGED NEIGHBORHOOD, length: 8000 , Coded Values: [False: False] , [True: True] )
• owned_by_business ( type: esriFieldTypeString, alias: PROPERTY OWNED BY BUSINESS, length: 8000 , Coded Values: [False: False] , [True: True] )
• business_name ( type: esriFieldTypeString, alias: BUSINESS NAME, length: 8000 )
• estimated_value ( type: esriFieldTypeString, alias: ESTIMATED HOME VALUE, length: 8000 )
• notes ( type: esriFieldTypeString, alias: NOTES, length: 8000 )
• point_of_entry ( type: esriFieldTypeString, alias: POINT OF ENTRY OR POINT OF USE TREATMENT, length: 8000 , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• plumbing_lead_solder ( type: esriFieldTypeString, alias: BUILDING PLUMBING LEAD SOLDER, length: 8000 , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• sample_site ( type: esriFieldTypeString, alias: CURRENT LCR SAMPLING SITE, length: 8000 , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• sensitive_pop ( type: esriFieldTypeString, alias: SENSITIVE POPULATION, length: 8000 )
• description ( type: esriFieldTypeString, alias: DESCRIPTION, length: 8000 )
• status ( type: esriFieldTypeString, alias: STATUS, length: 8000 , Coded Values: [InService: InService] , [OutOfService: OutOfService] , [Abandoned: Abandoned] , ...3 more... )
• cust_material ( type: esriFieldTypeString, alias: CUSTOMER OWNED MATERIAL, length: 8000 , Coded Values: [UNK: Unknown - Material Unknown] , [LLD: Unknown - Likely Lead] , [LEAD: Lead] , ...23 more... )
• cust_lead_solder ( type: esriFieldTypeString, alias: CUSTOMER OWNED LEAD SOLDER, length: 8000 , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• cust_verif_by ( type: esriFieldTypeString, alias: CUSTOMER OWNED VERIFIED BY, length: 8000 )
• cust_verif_date ( type: esriFieldTypeDate, alias: CUSTOMER OWNED VERIFIED DATE, length: 8 )
• cust_verif_method ( type: esriFieldTypeString, alias: CUSTOMER OWNED VERIFICATION METHOD, length: 8000 , Coded Values: [VisualExcavation: VisualExcavation] , [Visual - Excavation: Visual - Excavation] , [Records: Records] , ...19 more... )
• cust_removal_date ( type: esriFieldTypeDate, alias: CUSTOMER OWNED REMOVAL DATE, length: 8 )
• cust_install_date ( type: esriFieldTypeDate, alias: CUSTOMER OWNED INSTALLED DATE, length: 8 )
• cust_depth ( type: esriFieldTypeSmallInteger, alias: CUSTOMER OWNED LINE DEPTH )
• cust_diameter ( type: esriFieldTypeString, alias: CUSTOMER OWNED LINE DIAMETER, length: 8000 , Coded Values: [0.375: 3/8"] , [0.5: 1/2"] , [0.625: 5/8"] , ...15 more... )
• util_material ( type: esriFieldTypeString, alias: SYSTEM OWNED MATERIAL, length: 8000 , Coded Values: [UNK: Unknown - Material Unknown] , [LLD: Unknown - Likely Lead] , [LEAD: Lead] , ...23 more... )
• util_lead_solder ( type: esriFieldTypeString, alias: SYSTEM OWNED LEAD SOLDER, length: 8000 , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• util_verif_by ( type: esriFieldTypeString, alias: SYSTEM OWNED VERIFIED BY, length: 8000 )
• util_verif_date ( type: esriFieldTypeDate, alias: SYSTEM OWNED VERIFIED DATE, length: 8 )
• util_verif_method ( type: esriFieldTypeString, alias: SYSTEM OWNED VERIFICATION METHOD, length: 8000 , Coded Values: [VisualExcavation: VisualExcavation] , [Visual - Excavation: Visual - Excavation] , [Records: Records] , ...19 more... )
• util_removal_date ( type: esriFieldTypeDate, alias: SYSTEM OWNED REMOVAL DATE, length: 8 )
• util_install_date ( type: esriFieldTypeDate, alias: SYSTEM OWNED INSTALLED DATE, length: 8 )
• util_depth ( type: esriFieldTypeSmallInteger, alias: SYSTEM OWNED LINE DEPTH )
• util_diameter ( type: esriFieldTypeString, alias: SYSTEM OWNED LINE DIAMETER, length: 8000 , Coded Values: [0.375: 3/8"] , [0.5: 1/2"] , [0.625: 5/8"] , ...15 more... )
• lead_fitting ( type: esriFieldTypeString, alias: LEAD FITTINGS, length: 8000 , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• fitting_verif_by ( type: esriFieldTypeString, alias: FITTING VERIFIED BY, length: 8000 )
• fitting_verif_date ( type: esriFieldTypeDate, alias: FITTINGS VERIFIED DATE, length: 8 )
• fitting_verif_method ( type: esriFieldTypeString, alias: FITTINGS VERIFICATION METHOD, length: 8000 , Coded Values: [VisualExcavation: VisualExcavation] , [Visual - Excavation: Visual - Excavation] , [Records: Records] , ...19 more... )
• util_classification_method ( type: esriFieldTypeString, alias: SYSTEM OWNED CLASSIFICATION BASIS, length: 8000 , Coded Values: [Other: Other] , [Age: Age] , [Modeling: Modeling] , ...27 more... )
• cust_classification_method ( type: esriFieldTypeString, alias: CUSTOMER OWNED CLASSIFICATION BASIS, length: 8000 , Coded Values: [Other: Other] , [Age: Age] , [Modeling: Modeling] , ...27 more... )
• util_notes ( type: esriFieldTypeString, alias: SYSTEM OWNED NOTES, length: 8000 )
• cust_notes ( type: esriFieldTypeString, alias: CUSTOMER OWNED NOTES, length: 8000 )
• util_previous_lead ( type: esriFieldTypeString, alias: SYSTEM OWNED PREVIOUSLY LEAD, length: 8000 , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• lead_solder ( type: esriFieldTypeString, alias: LEAD SOLDER, length: 8000 , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• lead_other ( type: esriFieldTypeString, alias: OTHER LEAD EQUIPMENT, length: 8000 )
• cust_verif ( type: esriFieldTypeString, alias: CUSTOMER OWNED VERIFIED, length: 8000 , Coded Values: [False: False] , [True: True] )
• util_verif ( type: esriFieldTypeString, alias: SYSTEM OWNED VERIFIED, length: 8000 , Coded Values: [False: False] , [True: True] )
• util_material_other ( type: esriFieldTypeString, alias: SYSTEM OWNED MATERIAL OTHER, length: 8000 )
• util_verif_method_other ( type: esriFieldTypeString, alias: SYSTEM OWNED VERIFICATION METHOD OTHER, length: 8000 )
• cust_material_other ( type: esriFieldTypeString, alias: CUSTOMER OWNED MATERIAL OTHER, length: 8000 )
• cust_verif_method_other ( type: esriFieldTypeString, alias: CUSTOMER OWNED VERIFICATION METHOD OTHER, length: 8000 )
• fitting_verif_method_other ( type: esriFieldTypeString, alias: FITTINGS VERIFICATION METHOD OTHER, length: 8000 )
• util_after_lead_ban ( type: esriFieldTypeString, alias: SYSTEM OWNED INSTALLED AFTER LEAD BAN, length: 8000 )
• cust_after_lead_ban ( type: esriFieldTypeString, alias: CUSTOMER OWNED INSTALLED AFTER LEAD BAN, length: 8000 )
• ownership ( type: esriFieldTypeString, alias: OWNERSHIP, length: 8000 , Coded Values: [Split: Split] , [System-Owned: System-Owned] , [Customer-Owned: Customer-Owned] , ...1 more... )
• util_diameter_over_2in ( type: esriFieldTypeString, alias: SYSTEM OWNED DIAMETER OVER TWO INCHES, length: 8000 )
• cust_diameter_over_2in ( type: esriFieldTypeString, alias: CUSTOMER OWNED DIAMETER OVER TWO INCHES, length: 8000 )
• cust_notice_complete ( type: esriFieldTypeString, alias: CONSUMER NOTICE COMPLETED, length: 8000 , Coded Values: [False: False] , [True: True] )
• cust_notice_complete_date ( type: esriFieldTypeDate, alias: CONSUMER NOTICE COMPLETION DATE, length: 8 )
• cust_classification_method_notes ( type: esriFieldTypeString, alias: CUSTOMER OWNED CLASSIFICATION BASIS NOTES, length: 8000 )
• util_classification_method_notes ( type: esriFieldTypeString, alias: SYSTEM OWNED CLASSIFICATION BASIS NOTES, length: 8000 )
• cws_id ( type: esriFieldTypeString, alias: cws_id, length: 255 )
• cws_name ( type: esriFieldTypeString, alias: cws_name, length: 255 )
• hazenid ( type: esriFieldTypeString, alias: hazenid, length: 255 )
• NEAR_FID ( type: esriFieldTypeInteger, alias: NEAR_FID )
• NEAR_DIST ( type: esriFieldTypeDouble, alias: NEAR_DIST )

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

  Iteminfo   Thumbnail   Metadata