View In:   ArcGIS Online Map Viewer

Name: Service Line Inventory Survey

Display Field: accountid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 16e359d3acb2436397d1ea0f854239a6

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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: 2217690.4585406333
YMin: 230860.53748847544
XMax: 2217690.4585406333
YMax: 230860.53748847544
Spatial Reference: 103140  (6563)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [76, 230, 0, 255]
Size: 8.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
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: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: true

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• accountid ( modelName: accountid, nullable: true, editable: true, defaultValue: null, length: 30, alias: Unique Service Line ID, type: esriFieldTypeString )
• recordtype ( modelName: recordtype, nullable: true, editable: true, defaultValue: null, length: 255, alias: Record Type, type: esriFieldTypeString , Coded Values: [Initial: Initial] , [Update: Update] , [Add: Add] , ...1 more... )
• datereplacementcompleted ( modelName: datereplacementcompleted, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date Replacement Completed, type: esriFieldTypeDate )
• ownershiptype ( modelName: ownershiptype, nullable: true, editable: true, defaultValue: null, length: 255, alias: Ownership Type, type: esriFieldTypeString , Coded Values: [Customer: Customer] , [Jointly: Jointly] , [System: System] )
• propertyownername ( modelName: propertyownername, nullable: true, editable: true, defaultValue: null, length: 255, alias: Property Owner Name, type: esriFieldTypeString )
• propertyphonenumber ( modelName: propertyphonenumber, nullable: true, editable: true, defaultValue: null, length: 255, alias: Property Phone Number, type: esriFieldTypeString )
• propertyemail ( modelName: propertyemail, nullable: true, editable: true, defaultValue: null, length: 255, alias: Property Email Address, type: esriFieldTypeString )
• streetaddress1 ( modelName: streetaddress1, nullable: true, editable: true, defaultValue: null, length: 255, alias: Street Address 1, type: esriFieldTypeString )
• streetaddress2 ( modelName: streetaddress2, nullable: true, editable: true, defaultValue: null, length: 255, alias: Street Address 2, type: esriFieldTypeString )
• city ( modelName: city, nullable: true, editable: true, defaultValue: null, length: 255, alias: City or Township, type: esriFieldTypeString )
• zipcode ( modelName: zipcode, nullable: true, editable: true, defaultValue: null, length: 255, alias: Zip Code, type: esriFieldTypeString )
• school ( modelName: school, nullable: true, editable: true, defaultValue: null, length: 255, alias: School?, type: esriFieldTypeString , Coded Values: [No: No] , [Yes - Elementary: Yes - Elementary] , [Yes - Secondary: Yes - Secondary] , ...1 more... )
• childcarefacility ( modelName: childcarefacility, nullable: true, editable: true, defaultValue: null, length: 255, alias: Childcare Facility?, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• system_material ( modelName: system_material, nullable: true, editable: true, defaultValue: null, length: 255, alias: Material, type: esriFieldTypeString , Coded Values: [A) Lead: A) Lead] , [B) Lead-Lined Galvanized: B) Lead-Lined Galvanized] , [C) Galvanized: C) Galvanized] , ...14 more... )
• system_materialeverlead ( modelName: system_materialeverlead, nullable: true, editable: true, defaultValue: null, length: 255, alias: Was Material Ever Previously Lead?, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] , [Not Sure : Not Sure] )
• system_leadpigtail_goose ( modelName: system_leadpigtail_goose, nullable: true, editable: true, defaultValue: null, length: 255, alias: Lead Pigtail, Gooseneck or Connector Upstream?, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] , [Not Sure : Not Sure] )
• system_installdaterange ( modelName: system_installdaterange, nullable: true, editable: true, defaultValue: null, length: 255, alias: Installation Date Range, type: esriFieldTypeString , Coded Values: [A) Pre-1901: A) Pre-1901] , [B) 1901 - 1910: B) 1901 - 1910] , [C) 1911 - 1920: C) 1911 - 1920] , ...11 more... )
• system_installdatespecfic ( modelName: system_installdatespecfic, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Installation Date Specific, type: esriFieldTypeDate )
• system_diameter ( modelName: system_diameter, nullable: true, editable: true, defaultValue: null, alias: Diameter (In Inches), type: esriFieldTypeDouble )
• system_mateclass_nonfie ( modelName: system_mateclass_nonfie, nullable: true, editable: true, defaultValue: null, length: 255, alias: Basis of Material Classification - Non-Field Method, type: esriFieldTypeString , Coded Values: [A) Records Review: A) Records Review] , [B) Modeling/Statistical Analysis: B) Modeling/Statistical Analysis] , [C) Water Sampling (No CCT): C) Water Sampling (No CCT)] , ...1 more... )
• system_mateclass_nonfie1 ( modelName: system_mateclass_nonfie1, nullable: true, editable: true, defaultValue: null, length: 255, alias: Basis of Material Classification - Non-Field Method, type: esriFieldTypeString , Coded Values: [A) Records Review: A) Records Review] , [B) Modeling/Statistical Analysis: B) Modeling/Statistical Analysis] , [C) Water Sampling (No CCT): C) Water Sampling (No CCT)] , ...1 more... )
• system_materialclass_field ( modelName: system_materialclass_field, nullable: true, editable: true, defaultValue: null, length: 255, alias: Basis of Material Classification - Field Method, type: esriFieldTypeString , Coded Values: [E) Visual Inspection at Existing Access Point: E) Visual Inspection at Existing Access Point] , [F) CCTV Inspection Inside Pipe - Full Length: F) CCTV Inspection Inside Pipe - Full Length] , [G) CCTV Inspection Outside Pipe - At Curb Box: G) CCTV Inspection Outside Pipe - At Curb Box] , ...4 more... )
• system_datefieldver ( modelName: system_datefieldver, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date of Field Verification, type: esriFieldTypeDate )
• system_additionalcomments ( modelName: system_additionalcomments, nullable: true, editable: true, defaultValue: null, length: 255, alias: Additional Comments, type: esriFieldTypeString )
• customer_material ( modelName: customer_material, nullable: true, editable: true, defaultValue: null, length: 255, alias: Material, type: esriFieldTypeString , Coded Values: [A) Lead: A) Lead] , [B) Lead-Lined Galvanized: B) Lead-Lined Galvanized] , [C) Galvanized: C) Galvanized] , ...14 more... )
• customer_leadpigtail_goose ( modelName: customer_leadpigtail_goose, nullable: true, editable: true, defaultValue: null, length: 255, alias: Lead Pigtail, Gooseneck or Connector Upstream?, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] , [Not Sure : Not Sure] )
• customer_installdaterainge ( modelName: customer_installdaterainge, nullable: true, editable: true, defaultValue: null, length: 255, alias: Installation Date Range, type: esriFieldTypeString , Coded Values: [A) Pre-1901: A) Pre-1901] , [B) 1901 - 1910: B) 1901 - 1910] , [C) 1911 - 1920: C) 1911 - 1920] , ...11 more... )
• customer_installdatespecific ( modelName: customer_installdatespecific, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Installation Date Specific, type: esriFieldTypeDate )
• customer_mateclass_nonfie ( modelName: customer_mateclass_nonfie, nullable: true, editable: true, defaultValue: null, length: 255, alias: Basis of Material Classification - Non-Field Method, type: esriFieldTypeString , Coded Values: [A) Records Review: A) Records Review] , [B) Modeling/Statistical Analysis: B) Modeling/Statistical Analysis] , [C) Water Sampling (No CCT): C) Water Sampling (No CCT)] , ...1 more... )
• customer_mateslass_nonfie1 ( modelName: customer_mateslass_nonfie1, nullable: true, editable: true, defaultValue: null, length: 255, alias: Basis of Material Classification - Non-Field Method, type: esriFieldTypeString , Coded Values: [A) Records Review: A) Records Review] , [B) Modeling/Statistical Analysis: B) Modeling/Statistical Analysis] , [C) Water Sampling (No CCT): C) Water Sampling (No CCT)] , ...1 more... )
• customer_materialclass_field ( modelName: customer_materialclass_field, nullable: true, editable: true, defaultValue: null, length: 255, alias: Basis of Material Classification - Field Method, type: esriFieldTypeString , Coded Values: [E) Visual Inspection at Existing Access Point: E) Visual Inspection at Existing Access Point] , [F) CCTV Inspection Inside Pipe - Full Length: F) CCTV Inspection Inside Pipe - Full Length] , [G) CCTV Inspection Outside Pipe - At Curb Box: G) CCTV Inspection Outside Pipe - At Curb Box] , ...4 more... )
• customer_datefieldver ( modelName: customer_datefieldver, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date of Field Verification, type: esriFieldTypeDate )
• customer_additionalcomments ( modelName: customer_additionalcomments, nullable: true, editable: true, defaultValue: null, length: 255, alias: Additional Comments, type: esriFieldTypeString )
• servicelineconnected ( modelName: servicelineconnected, nullable: true, editable: true, defaultValue: null, length: 255, alias: Service Line Connected To:, type: esriFieldTypeString , Coded Values: [S) Single Family Residence: S) Single Family Residence] , [M) Multi Family Residence: M) Multi Family Residence] , [O) Building/Other: O) Building/Other] )
• poe_treatment ( modelName: poe_treatment, nullable: true, editable: true, defaultValue: null, length: 255, alias: POE Treatment Present?, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] , [Not Sure : Not Sure] )
• interiorcontainslead ( modelName: interiorcontainslead, nullable: true, editable: true, defaultValue: null, length: 255, alias: Interior Building Plumbing Contains Lead Solder?, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] , [Not Sure : Not Sure] )
• lcr_sampling_site ( modelName: lcr_sampling_site, nullable: true, editable: true, defaultValue: null, length: 255, alias: Current LCR Sampling Site?, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: globalid, alias: GlobalID )
• created_user ( modelName: created_user, nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( modelName: created_date, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( modelName: last_edited_user, nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( modelName: last_edited_date, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
• x ( nullable: true, editable: true, defaultValue: null, alias: Longitude, type: esriFieldTypeDouble )
• y ( nullable: true, editable: true, defaultValue: null, alias: Latitude, type: esriFieldTypeDouble )

Templates:

• Name: Lead Service Survey
  Description:
  Prototype:
  x: null
  y: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata