View In:   ArcGIS Online Map Viewer

Name: Inspection Status

Display Field: StreetAddress

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 24000.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: 733297.6493670791
YMin: 243939.3031663224
XMax: 749312.340434745
YMax: 264052.83019640297
Spatial Reference: 102671  (3435)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: InspectionStatus
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Default Label: Unknown
UniqueValueInfos:
• Value: COMPLETE
  Label: Inspection Complete
  Description: N/A
  Symbol:
  
• Value: PARTCOMP
  Label: Partial Inspection Complete
  Description: N/A
  Symbol:
  
• Value: REQUIRED
  Label: Inspection Required
  Description: N/A
  Symbol:
  
• Value: CNA
  Label: Could Not Access
  Description: N/A
  Symbol:
  
• Value: CNL
  Label: Could Not Locate
  Description: N/A
  Symbol:
  
• Value: OTHER
  Label: Other (See Comments)
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:

Feature Draw Order:

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: 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: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: InspectionStatus

Fields:

• CLYear ( type: esriFieldTypeString, alias: CLYear, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CLYear )
• 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 )
• StreetAddress ( type: esriFieldTypeString, alias: StreetAddress, editable: true, nullable: true, length: 255, defaultValue: null, modelName: StreetAddress )
• OtherLocationIdentifier ( type: esriFieldTypeString, alias: OtherLocationIdentifier, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OtherLocationIdentifier )
• SensitivePop ( type: esriFieldTypeString, alias: SensitivePop, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SensitivePop )
• DisadvantagedNeighborhood ( type: esriFieldTypeString, alias: DisadvantagedNeighborhood, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DisadvantagedNeighborhood )
• ServiceLineMaterial ( type: esriFieldTypeString, alias: ServiceLineMaterial, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ServiceLineMaterial )
• SLMaterialPrevLead ( type: esriFieldTypeString, alias: SLMaterialPrevLead, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SLMaterialPrevLead )
• ServiceLineInstallDate ( type: esriFieldTypeDate, alias: ServiceLineInstallDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ServiceLineInstallDate )
• ServiceLineSize ( type: esriFieldTypeString, alias: ServiceLineSize, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ServiceLineSize )
• SLBasisMatClass ( type: esriFieldTypeString, alias: SLBasisMatClass, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SLBasisMatClass )
• SLFieldVerified ( type: esriFieldTypeString, alias: SLFieldVerified, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SLFieldVerified )
• SLFieldVerifMethod ( type: esriFieldTypeString, alias: SLFieldVerifMethod, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SLFieldVerifMethod )
• SLFieldVerifDate ( type: esriFieldTypeDate, alias: SLFieldVerifDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SLFieldVerifDate )
• SLNotes ( type: esriFieldTypeString, alias: SLNotes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SLNotes )
• CustomerLineMaterial ( type: esriFieldTypeString, alias: CustomerLineMaterial, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CustomerLineMaterial )
• CSLInstalDate ( type: esriFieldTypeDate, alias: CSLInstalDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CSLInstalDate )
• CSLSize ( type: esriFieldTypeString, alias: CSLSize, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CSLSize )
• CSLBasisMatClass ( type: esriFieldTypeString, alias: CSLBasisMatClass, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CSLBasisMatClass )
• CSLMatVerified ( type: esriFieldTypeString, alias: CSLMatVerified, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CSLMatVerified )
• CSLFieldVerifyMethod ( type: esriFieldTypeString, alias: CSLFieldVerifyMethod, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CSLFieldVerifyMethod )
• CSLFieldVerifDate ( type: esriFieldTypeDate, alias: CSLFieldVerifDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CSLFieldVerifDate )
• CSLNotes ( type: esriFieldTypeString, alias: CSLNotes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CSLNotes )
• EntSerLineMatClass ( type: esriFieldTypeString, alias: EntSerLineMatClass, editable: true, nullable: true, length: 255, defaultValue: null, modelName: EntSerLineMatClass )
• LeadConn ( type: esriFieldTypeString, alias: LeadConn, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LeadConn )
• LeadSolder ( type: esriFieldTypeString, alias: LeadSolder, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LeadSolder )
• OtherFittings ( type: esriFieldTypeString, alias: OtherFittings, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OtherFittings )
• BuildingType ( type: esriFieldTypeString, alias: BuildingType, editable: true, nullable: true, length: 255, defaultValue: null, modelName: BuildingType )
• POETreatment ( type: esriFieldTypeString, alias: POETreatment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: POETreatment )
• IntPlumbInstall ( type: esriFieldTypeString, alias: IntPlumbInstall, editable: true, nullable: true, length: 255, defaultValue: null, modelName: IntPlumbInstall )
• LCRSampleSite ( type: esriFieldTypeString, alias: LCRSampleSite, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LCRSampleSite )
• InspectionStatus ( type: esriFieldTypeString, alias: InspectionStatus, editable: true, nullable: true, length: 255, defaultValue: null, modelName: InspectionStatus )
• InspectedBy ( type: esriFieldTypeString, alias: InspectedBy, editable: true, nullable: true, length: 255, defaultValue: null, modelName: InspectedBy )
• InspectionComments ( type: esriFieldTypeString, alias: InspectionComments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: InspectionComments )
• City ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 255, defaultValue: null, modelName: City )
• State ( type: esriFieldTypeString, alias: State, editable: true, nullable: true, length: 255, defaultValue: null, modelName: State )
• ZipCode ( type: esriFieldTypeString, alias: ZipCode, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ZipCode )
• BuiltBeforeAfterSDWA ( type: esriFieldTypeString, alias: BuiltBeforeAfterSDWA, editable: true, nullable: true, length: 255, defaultValue: null, modelName: BuiltBeforeAfterSDWA )
• YearBuilt ( type: esriFieldTypeString, alias: YearBuilt, editable: true, nullable: true, length: 255, defaultValue: null, modelName: YearBuilt )
• PWSID ( type: esriFieldTypeString, alias: PWSID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PWSID )
• PublicWaterDistrict ( type: esriFieldTypeString, alias: PublicWaterDistrict, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PublicWaterDistrict )
• LeadCopSampSitNum ( type: esriFieldTypeString, alias: LeadCopSampSitNum, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LeadCopSampSitNum )
• HighRisk ( type: esriFieldTypeString, alias: HighRisk, editable: true, nullable: true, length: 255, defaultValue: null, modelName: HighRisk )
• NewIdentify ( type: esriFieldTypeString, alias: NewIdentify, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NewIdentify )
• SLYear ( type: esriFieldTypeString, alias: SLYear, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SLYear )
• RefusedAccess ( type: esriFieldTypeString, alias: RefusedAccess, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RefusedAccess )
• CustomerWaiver ( type: esriFieldTypeString, alias: CustomerWaiver, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CustomerWaiver )
• PrevReplaced ( type: esriFieldTypeString, alias: PrevReplaced, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PrevReplaced )
• LeadServiceLineRepacedDate ( type: esriFieldTypeString, alias: LeadServiceLineRepacedDate, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LeadServiceLineRepacedDate )
• CustNotify ( type: esriFieldTypeString, alias: CustNotify, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CustNotify )
• GlaveLeadDS ( type: esriFieldTypeString, alias: GlaveLeadDS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GlaveLeadDS )
• SLClassification ( type: esriFieldTypeString, alias: SLClassification, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SLClassification )
• Gooseneck_Pig ( type: esriFieldTypeString, alias: Gooseneck_Pig, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Gooseneck_Pig )
• CustomerSL ( type: esriFieldTypeString, alias: CustomerSL, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CustomerSL )
• MaterialReplace ( type: esriFieldTypeString, alias: MaterialReplace, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MaterialReplace )
• 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 )

Types:

ID: COMPLETE
Name: Inspection Complete
Domains:
Templates:
• Name: COMPLETE
  Description:
  Prototype:
  CustomerSL: null
  CLYear: null
  MaterialReplace: null
  Gooseneck_Pig: null
  StreetAddress: null
  OtherLocationIdentifier: null
  SensitivePop: null
  DisadvantagedNeighborhood: null
  ServiceLineMaterial: null
  SLMaterialPrevLead: null
  ServiceLineInstallDate: null
  ServiceLineSize: null
  SLBasisMatClass: null
  SLFieldVerified: null
  SLFieldVerifMethod: null
  SLFieldVerifDate: null
  SLNotes: null
  CustomerLineMaterial: null
  CSLInstalDate: null
  CSLSize: null
  CSLBasisMatClass: null
  CSLMatVerified: null
  CSLFieldVerifyMethod: null
  CSLFieldVerifDate: null
  CSLNotes: null
  EntSerLineMatClass: null
  LeadConn: null
  LeadSolder: null
  OtherFittings: null
  BuildingType: null
  POETreatment: null
  IntPlumbInstall: null
  LCRSampleSite: null
  InspectionStatus: COMPLETE
  InspectedBy: null
  InspectionComments: null
  City: null
  State: null
  ZipCode: null
  BuiltBeforeAfterSDWA: null
  YearBuilt: null
  PWSID: null
  PublicWaterDistrict: null
  LeadCopSampSitNum: null
  HighRisk: null
  NewIdentify: null
  SLYear: null
  RefusedAccess: null
  CustomerWaiver: null
  PrevReplaced: null
  LeadServiceLineRepacedDate: null
  CustNotify: null
  GlaveLeadDS: null
  SLClassification: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: PARTCOMP
Name: Partial Inspection Complete
Domains:
Templates:
• Name: PARTCOMP
  Description:
  Prototype:
  CustomerSL: null
  CLYear: null
  MaterialReplace: null
  Gooseneck_Pig: null
  StreetAddress: null
  OtherLocationIdentifier: null
  SensitivePop: null
  DisadvantagedNeighborhood: null
  ServiceLineMaterial: null
  SLMaterialPrevLead: null
  ServiceLineInstallDate: null
  ServiceLineSize: null
  SLBasisMatClass: null
  SLFieldVerified: null
  SLFieldVerifMethod: null
  SLFieldVerifDate: null
  SLNotes: null
  CustomerLineMaterial: null
  CSLInstalDate: null
  CSLSize: null
  CSLBasisMatClass: null
  CSLMatVerified: null
  CSLFieldVerifyMethod: null
  CSLFieldVerifDate: null
  CSLNotes: null
  EntSerLineMatClass: null
  LeadConn: null
  LeadSolder: null
  OtherFittings: null
  BuildingType: null
  POETreatment: null
  IntPlumbInstall: null
  LCRSampleSite: null
  InspectionStatus: PARTCOMP
  InspectedBy: null
  InspectionComments: null
  City: null
  State: null
  ZipCode: null
  BuiltBeforeAfterSDWA: null
  YearBuilt: null
  PWSID: null
  PublicWaterDistrict: null
  LeadCopSampSitNum: null
  HighRisk: null
  NewIdentify: null
  SLYear: null
  RefusedAccess: null
  CustomerWaiver: null
  PrevReplaced: null
  LeadServiceLineRepacedDate: null
  CustNotify: null
  GlaveLeadDS: null
  SLClassification: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: REQUIRED
Name: Inspection Required
Domains:
Templates:
• Name: REQUIRED
  Description:
  Prototype:
  CustomerSL: null
  CLYear: null
  MaterialReplace: null
  Gooseneck_Pig: null
  StreetAddress: null
  OtherLocationIdentifier: null
  SensitivePop: null
  DisadvantagedNeighborhood: null
  ServiceLineMaterial: null
  SLMaterialPrevLead: null
  ServiceLineInstallDate: null
  ServiceLineSize: null
  SLBasisMatClass: null
  SLFieldVerified: null
  SLFieldVerifMethod: null
  SLFieldVerifDate: null
  SLNotes: null
  CustomerLineMaterial: null
  CSLInstalDate: null
  CSLSize: null
  CSLBasisMatClass: null
  CSLMatVerified: null
  CSLFieldVerifyMethod: null
  CSLFieldVerifDate: null
  CSLNotes: null
  EntSerLineMatClass: null
  LeadConn: null
  LeadSolder: null
  OtherFittings: null
  BuildingType: null
  POETreatment: null
  IntPlumbInstall: null
  LCRSampleSite: null
  InspectionStatus: REQUIRED
  InspectedBy: null
  InspectionComments: null
  City: null
  State: null
  ZipCode: null
  BuiltBeforeAfterSDWA: null
  YearBuilt: null
  PWSID: null
  PublicWaterDistrict: null
  LeadCopSampSitNum: null
  HighRisk: null
  NewIdentify: null
  SLYear: null
  RefusedAccess: null
  CustomerWaiver: null
  PrevReplaced: null
  LeadServiceLineRepacedDate: null
  CustNotify: null
  GlaveLeadDS: null
  SLClassification: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: CNA
Name: Could Not Access
Domains:
Templates:
• Name: CNA
  Description:
  Prototype:
  CustomerSL: null
  CLYear: null
  MaterialReplace: null
  Gooseneck_Pig: null
  StreetAddress: null
  OtherLocationIdentifier: null
  SensitivePop: null
  DisadvantagedNeighborhood: null
  ServiceLineMaterial: null
  SLMaterialPrevLead: null
  ServiceLineInstallDate: null
  ServiceLineSize: null
  SLBasisMatClass: null
  SLFieldVerified: null
  SLFieldVerifMethod: null
  SLFieldVerifDate: null
  SLNotes: null
  CustomerLineMaterial: null
  CSLInstalDate: null
  CSLSize: null
  CSLBasisMatClass: null
  CSLMatVerified: null
  CSLFieldVerifyMethod: null
  CSLFieldVerifDate: null
  CSLNotes: null
  EntSerLineMatClass: null
  LeadConn: null
  LeadSolder: null
  OtherFittings: null
  BuildingType: null
  POETreatment: null
  IntPlumbInstall: null
  LCRSampleSite: null
  InspectionStatus: CNA
  InspectedBy: null
  InspectionComments: null
  City: null
  State: null
  ZipCode: null
  BuiltBeforeAfterSDWA: null
  YearBuilt: null
  PWSID: null
  PublicWaterDistrict: null
  LeadCopSampSitNum: null
  HighRisk: null
  NewIdentify: null
  SLYear: null
  RefusedAccess: null
  CustomerWaiver: null
  PrevReplaced: null
  LeadServiceLineRepacedDate: null
  CustNotify: null
  GlaveLeadDS: null
  SLClassification: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: CNL
Name: Could Not Locate
Domains:
Templates:
• Name: CNL
  Description:
  Prototype:
  CustomerSL: null
  CLYear: null
  MaterialReplace: null
  Gooseneck_Pig: null
  StreetAddress: null
  OtherLocationIdentifier: null
  SensitivePop: null
  DisadvantagedNeighborhood: null
  ServiceLineMaterial: null
  SLMaterialPrevLead: null
  ServiceLineInstallDate: null
  ServiceLineSize: null
  SLBasisMatClass: null
  SLFieldVerified: null
  SLFieldVerifMethod: null
  SLFieldVerifDate: null
  SLNotes: null
  CustomerLineMaterial: null
  CSLInstalDate: null
  CSLSize: null
  CSLBasisMatClass: null
  CSLMatVerified: null
  CSLFieldVerifyMethod: null
  CSLFieldVerifDate: null
  CSLNotes: null
  EntSerLineMatClass: null
  LeadConn: null
  LeadSolder: null
  OtherFittings: null
  BuildingType: null
  POETreatment: null
  IntPlumbInstall: null
  LCRSampleSite: null
  InspectionStatus: CNL
  InspectedBy: null
  InspectionComments: null
  City: null
  State: null
  ZipCode: null
  BuiltBeforeAfterSDWA: null
  YearBuilt: null
  PWSID: null
  PublicWaterDistrict: null
  LeadCopSampSitNum: null
  HighRisk: null
  NewIdentify: null
  SLYear: null
  RefusedAccess: null
  CustomerWaiver: null
  PrevReplaced: null
  LeadServiceLineRepacedDate: null
  CustNotify: null
  GlaveLeadDS: null
  SLClassification: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: OTHER
Name: Other (See Comments)
Domains:
Templates:
• Name: OTHER
  Description:
  Prototype:
  CustomerSL: null
  CLYear: null
  MaterialReplace: null
  Gooseneck_Pig: null
  StreetAddress: null
  OtherLocationIdentifier: null
  SensitivePop: null
  DisadvantagedNeighborhood: null
  ServiceLineMaterial: null
  SLMaterialPrevLead: null
  ServiceLineInstallDate: null
  ServiceLineSize: null
  SLBasisMatClass: null
  SLFieldVerified: null
  SLFieldVerifMethod: null
  SLFieldVerifDate: null
  SLNotes: null
  CustomerLineMaterial: null
  CSLInstalDate: null
  CSLSize: null
  CSLBasisMatClass: null
  CSLMatVerified: null
  CSLFieldVerifyMethod: null
  CSLFieldVerifDate: null
  CSLNotes: null
  EntSerLineMatClass: null
  LeadConn: null
  LeadSolder: null
  OtherFittings: null
  BuildingType: null
  POETreatment: null
  IntPlumbInstall: null
  LCRSampleSite: null
  InspectionStatus: OTHER
  InspectedBy: null
  InspectionComments: null
  City: null
  State: null
  ZipCode: null
  BuiltBeforeAfterSDWA: null
  YearBuilt: null
  PWSID: null
  PublicWaterDistrict: null
  LeadCopSampSitNum: null
  HighRisk: null
  NewIdentify: null
  SLYear: null
  RefusedAccess: null
  CustomerWaiver: null
  PrevReplaced: null
  LeadServiceLineRepacedDate: null
  CustNotify: null
  GlaveLeadDS: null
  SLClassification: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

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: true

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Attachments   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata