View In:   ArcGIS Online Map Viewer

Name: JOLIETPU.COJ_SERVICEMATERIALLOCATIONS_NEW

Display Field: HighRiskName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 730136610fec4033b307fa2cb9010a2f

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 978725.5305575803
YMin: 1737461.8971519023
XMax: 1077571.07302358
YMax: 1794783.933754325
Spatial Reference: 102671  (3435)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [50, 108, 130, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
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: true
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: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: true

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• AddressNum ( type: esriFieldTypeString, alias: Address Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: AddressNum )
• AddressPreDir ( type: esriFieldTypeString, alias: Address Pre Dir, editable: true, nullable: true, length: 5, defaultValue: null, modelName: AddressPreDir )
• Street ( type: esriFieldTypeString, alias: Street, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Street )
• StreetType ( type: esriFieldTypeString, alias: Street Type, editable: true, nullable: true, length: 10, defaultValue: null, modelName: StreetType )
• StreetPostDir ( type: esriFieldTypeString, alias: Street Post Dir, editable: true, nullable: true, length: 5, defaultValue: null, modelName: StreetPostDir )
• FullStreetAddr ( type: esriFieldTypeString, alias: Full Street Address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FullStreetAddr )
• ProjectReplacement ( type: esriFieldTypeString, alias: Project Replaces, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ProjectReplacement , Coded Values: [Phase 1 LSLR: Phase 1 LSLR] , [Phase 2A LSLR: Phase 2A LSLR] , [Phase 2B LSLR: Phase 2B LSLR] , ...8 more... )
• CurrentPubMaterial ( type: esriFieldTypeString, alias: Current Public Material, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CurrentPubMaterial , Coded Values: [Copper: Copper] , [Ductile Iron: Ductile Iron] , [Unknown: Unknown] , ...8 more... )
• CurrentPubSource ( type: esriFieldTypeString, alias: Current Public Material Source, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CurrentPubSource , Coded Values: [Visual: Visual Inspection] , [Home: Home Age] , [Construction: Construction Record] )
• CurrentPrivMaterial ( type: esriFieldTypeString, alias: Current Private Material, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CurrentPrivMaterial , Coded Values: [Copper: Copper] , [Ductile Iron: Ductile Iron] , [Unknown: Unknown] , ...8 more... )
• CurrentPrivSource ( type: esriFieldTypeString, alias: Current Private Material Source, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CurrentPrivSource , Coded Values: [Visual: Visual Inspection] , [Home: Home Age] , [Construction: Construction Record] )
• PreviousPubMaterial ( type: esriFieldTypeString, alias: Previous Public Material, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PreviousPubMaterial , Coded Values: [Copper: Copper] , [Ductile Iron: Ductile Iron] , [Unknown: Unknown] , ...8 more... )
• PreviousPubSource ( type: esriFieldTypeString, alias: Previous Public Material Source, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PreviousPubSource , Coded Values: [Visual: Visual Inspection] , [Home: Home Age] , [Construction: Construction Record] )
• PreviousPrivMaterial ( type: esriFieldTypeString, alias: Previous Private Material, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PreviousPrivMaterial , Coded Values: [Copper: Copper] , [Ductile Iron: Ductile Iron] , [Unknown: Unknown] , ...8 more... )
• PreviousPrivSource ( type: esriFieldTypeString, alias: Previous Private Material Source, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PreviousPrivSource , Coded Values: [Visual: Visual Inspection] , [Home: Home Age] , [Construction: Construction Record] )
• PreviousPubInspectDate ( type: esriFieldTypeDate, alias: Previous Public Material Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PreviousPubInspectDate )
• PreviousPrivInspectDate ( type: esriFieldTypeDate, alias: Previous Private Material Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PreviousPrivInspectDate )
• LeadBoundary ( type: esriFieldTypeString, alias: Within Suspected Lead Boundary, editable: true, nullable: true, length: 5, defaultValue: null, modelName: LeadBoundary , Coded Values: [Yes: Yes] , [No: No] )
• PropertyBuilt ( type: esriFieldTypeString, alias: Year Property Built, editable: true, nullable: true, length: 5, defaultValue: null, modelName: PropertyBuilt )
• HighRisk ( type: esriFieldTypeString, alias: High-Risk Facility, editable: true, nullable: true, length: 5, defaultValue: null, modelName: HighRisk , Coded Values: [Yes: Yes] , [No: No] )
• Disadvantaged ( type: esriFieldTypeString, alias: Disadvantaged Property, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Disadvantaged , Coded Values: [Yes: Yes] , [No: No] )
• Access ( type: esriFieldTypeString, alias: Access Refused, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Access , Coded Values: [Yes: Yes] , [No: No] )
• LeadNotification ( type: esriFieldTypeDate, alias: Lead Service Notification Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LeadNotification )
• Waiver_IDPH_Notification ( type: esriFieldTypeDate, alias: Waiver or IDPH Notification Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Waiver_IDPH_Notification )
• LeadSolder ( type: esriFieldTypeString, alias: Copper/Assumed Lead Solder, editable: true, nullable: true, length: 5, defaultValue: null, modelName: LeadSolder , Coded Values: [Yes: Yes] , [No: No] )
• Lead_2018_Earlier ( type: esriFieldTypeString, alias: Lead 2018 or Earlier, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Lead_2018_Earlier , Coded Values: [Yes: Yes] , [No: No] )
• HighRiskCategory ( type: esriFieldTypeString, alias: High Risk Category, editable: true, nullable: true, length: 255, defaultValue: null, modelName: HighRiskCategory , Coded Values: [School: School] , [Park: Park] , [Child Care Facility: Child Care Facility] , ...6 more... )
• HighRiskName ( type: esriFieldTypeString, alias: High Risk Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: HighRiskName )
• WaterMainYear ( type: esriFieldTypeString, alias: Water Main Year, editable: true, nullable: true, length: 10, defaultValue: null, modelName: WaterMainYear , Coded Values: [2025: 2025] , [2026: 2026] , [2027: 2027] , ...7 more... )
• AccountNum ( type: esriFieldTypeString, alias: Account Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: AccountNum )
• SampleSiteID ( type: esriFieldTypeString, alias: Sample Site ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SampleSiteID )
• NewlyID_Lead ( type: esriFieldTypeString, alias: Service Line Newly Identified (as Lead), editable: true, nullable: true, length: 5, defaultValue: null, modelName: NewlyID_Lead )
• PWS_Owned_Year ( type: esriFieldTypeString, alias: Year PWS-Owned Service Line Installed, editable: true, nullable: true, length: 5, defaultValue: null, modelName: PWS_Owned_Year )
• Customer_Installed_Year ( type: esriFieldTypeString, alias: Year Customer Side Service Line Installed, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Customer_Installed_Year )
• Service_Material_Calssification ( type: esriFieldTypeString, alias: Overall Service Line Material Classification, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Service_Material_Calssification )
• Lead_Service_Previous_Replace ( type: esriFieldTypeString, alias: Lead Service Line Previously Replaced, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Lead_Service_Previous_Replace , Coded Values: [Yes: Yes] , [No: No] )
• Lead_Service_Replaced_Date ( type: esriFieldTypeDate, alias: Date Lead Service Line Replaced, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Lead_Service_Replaced_Date )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: Notes )
• CurrentPubInspectDate ( type: esriFieldTypeDate, alias: Current Public Material Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CurrentPubInspectDate )
• CurrentPrivInspectDate ( type: esriFieldTypeDate, alias: Current Private Material Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CurrentPrivInspectDate )
• CurrentPubInstallDate ( type: esriFieldTypeDate, alias: Current Public Material Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CurrentPubInstallDate )
• CurrentPrivInstallDate ( type: esriFieldTypeDate, alias: Current Private Material Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CurrentPrivInstallDate )
• PreviousPubInstallDate ( type: esriFieldTypeDate, alias: Previous Public Material Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PreviousPubInstallDate )
• PreviousPrivInstallDate ( type: esriFieldTypeDate, alias: Previous Private Material Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PreviousPrivInstallDate )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )

Templates:

• Name: JOLIETPU.COJ_SERVICEMATERIALLOCATIONS_NEW
  Description:
  Prototype:
  PreviousPubInstallDate: null
  PreviousPrivInstallDate: null
  CurrentPrivInstallDate: null
  AddressNum: null
  AddressPreDir: null
  Street: null
  StreetType: null
  StreetPostDir: null
  FullStreetAddr: null
  ProjectReplacement: null
  CurrentPubMaterial: null
  CurrentPubSource: null
  CurrentPrivMaterial: null
  CurrentPrivSource: null
  PreviousPubMaterial: null
  PreviousPubSource: null
  PreviousPrivMaterial: null
  PreviousPrivSource: null
  PreviousPubInspectDate: null
  PreviousPrivInspectDate: null
  LeadBoundary: null
  PropertyBuilt: null
  HighRisk: null
  Disadvantaged: null
  Access: null
  LeadNotification: null
  Waiver_IDPH_Notification: null
  LeadSolder: null
  Lead_2018_Earlier: null
  HighRiskCategory: null
  HighRiskName: null
  WaterMainYear: null
  AccountNum: null
  SampleSiteID: null
  NewlyID_Lead: null
  PWS_Owned_Year: null
  Customer_Installed_Year: null
  Service_Material_Calssification: null
  Lead_Service_Previous_Replace: null
  Lead_Service_Replaced_Date: null
  Notes: null
  CurrentPubInspectDate: null
  CurrentPrivInspectDate: null
  CurrentPubInstallDate: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Create,Update,Delete,Uploads,Editing,Extract

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

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 Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata