Name: Production.LI.PublicWells_SiteVisitForm

Display Field: SystemName

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 9b5f208d4336468ab86b70c415ca3ab9

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• SystemName ( type: esriFieldTypeString, alias: System Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SystemName )
• PWSID ( type: esriFieldTypeString, alias: PWSID#, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PWSID )
• ChangesLandUse ( type: esriFieldTypeString, alias: Changes in nearby land use activity/potential new contamination sources (blasting, fire suppression, land spreading, septic issues), editable: true, nullable: true, length: 50, defaultValue: null, modelName: ChangesLandUse , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• ChangesVisibleIndicators ( type: esriFieldTypeString, alias: ChangesVisibleIndicators, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ChangesVisibleIndicators , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• ChangesOther ( type: esriFieldTypeString, alias: Other Changes, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ChangesOther , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• ChangesOtherDescription ( type: esriFieldTypeString, alias: If other, describe the other changes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ChangesOtherDescription )
• SourceConduitDamage ( type: esriFieldTypeString, alias: Conduit damaged/missing, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SourceConduitDamage , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• SourceFloodwater ( type: esriFieldTypeString, alias: Floodwater / runoff ponding / topped well, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SourceFloodwater , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• SourceSealDamage ( type: esriFieldTypeString, alias: Grout or seal around well damaged, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SourceSealDamage , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• SourceVentDamage ( type: esriFieldTypeString, alias: Vent damaged / unscreened, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SourceVentDamage , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• SourceWellCasingDamage ( type: esriFieldTypeString, alias: Well casing damaged / corroded, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SourceWellCasingDamage , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• SourceWellCapDamage ( type: esriFieldTypeString, alias: Well cap / well seal damaged, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SourceWellCapDamage , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• SourceOpenings ( type: esriFieldTypeString, alias: Openings through well cap not watertight (bolts/wires/lines), editable: true, nullable: true, length: 50, defaultValue: null, modelName: SourceOpenings , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• SourceOther ( type: esriFieldTypeString, alias: Other Source Issues, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SourceOther , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• SourceOtherDescription ( type: esriFieldTypeString, alias: If other, describe the other source issues, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SourceOtherDescription )
• ControlFlow ( type: esriFieldTypeString, alias: Noncomplying flowing well piping, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ControlFlow , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• ControlPipe ( type: esriFieldTypeString, alias: Piping leak/ponding/wet along buried piping, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ControlPipe , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• ControlFaucet ( type: esriFieldTypeString, alias: Noncomplying well / entry point sampling faucet, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ControlFaucet , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• ControlOther ( type: esriFieldTypeString, alias: Other Control Issues, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ControlOther , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• ControlOtherDescription ( type: esriFieldTypeString, alias: If other, describe the other control issues, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ControlOtherDescription )
• StoragePressure ( type: esriFieldTypeString, alias: Pressure not holding, editable: true, nullable: true, length: 50, defaultValue: null, modelName: StoragePressure , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• StorageTank ( type: esriFieldTypeString, alias: Tank deterioration, rust, holes, editable: true, nullable: true, length: 50, defaultValue: null, modelName: StorageTank , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• StorageOther ( type: esriFieldTypeString, alias: Other Storage Issues, editable: true, nullable: true, length: 50, defaultValue: null, modelName: StorageOther , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• StorageOtherDescription ( type: esriFieldTypeString, alias: If other, describe the other storage issues, editable: true, nullable: true, length: 255, defaultValue: null, modelName: StorageOtherDescription )
• DistributionAirGaps ( type: esriFieldTypeString, alias: Air gaps missing, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DistributionAirGaps , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• DistributionDeadEnds ( type: esriFieldTypeString, alias: Dead-end plumbing lines/devices not in use, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DistributionDeadEnds , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• DistributionLeak ( type: esriFieldTypeString, alias: Leaking distribution piping, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DistributionLeak , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• DistributionVacuum ( type: esriFieldTypeString, alias: Vacuum breaker/backflow protection device missing or device required testing not current, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DistributionVacuum , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• DistributionProcedures ( type: esriFieldTypeString, alias: Improper sample collection sites / procedures, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DistributionProcedures , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• DistributionOther ( type: esriFieldTypeString, alias: Other Distribution Issues, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DistributionOther , Coded Values: [Yes: Yes] , [No: No] , [N/A: N/A] )
• DistributionOtherDescription ( type: esriFieldTypeString, alias: If other, describe the other distribution issues, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DistributionOtherDescription )
• CorrectiveAction ( type: esriFieldTypeString, alias: Description of Corrective Action (If required), editable: true, nullable: true, length: 2000, defaultValue: null, modelName: CorrectiveAction )
• CorrectiveActionDue ( type: esriFieldTypeDate, alias: Corrective Action Due Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CorrectiveActionDue )
• CreationDate ( type: esriFieldTypeDate, alias: CreationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CreationDate )
• Creator ( type: esriFieldTypeString, alias: Creator, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Creator )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EditDate )
• Editor ( type: esriFieldTypeString, alias: Editor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Editor )
• PublicSiteVisitForm_GUID ( type: esriFieldTypeGUID, alias: PublicSiteVisitForm_GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: PublicSiteVisitForm_GUID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• guid_copy ( type: esriFieldTypeString, alias: guid_copy, editable: true, nullable: true, length: 100, defaultValue: null, modelName: guid_copy )

Templates:

• Name: Production.LI.PublicWells_SiteVisitForm
  Description:
  Prototype:
  guid_copy: null
  PublicSiteVisitForm_GUID: null
  SystemName: null
  PWSID: null
  ChangesLandUse: null
  ChangesVisibleIndicators: null
  ChangesOther: null
  ChangesOtherDescription: null
  SourceConduitDamage: null
  SourceFloodwater: null
  SourceSealDamage: null
  SourceVentDamage: null
  SourceWellCasingDamage: null
  SourceWellCapDamage: null
  SourceOpenings: null
  SourceOther: null
  SourceOtherDescription: null
  ControlFlow: null
  ControlPipe: null
  ControlFaucet: null
  ControlOther: null
  ControlOtherDescription: null
  StoragePressure: null
  StorageTank: null
  StorageOther: null
  StorageOtherDescription: null
  DistributionAirGaps: null
  DistributionDeadEnds: null
  DistributionLeak: null
  DistributionVacuum: null
  DistributionProcedures: null
  DistributionOther: null
  DistributionOtherDescription: null
  CorrectiveAction: null
  CorrectiveActionDue: null
  CreationDate: null
  Creator: null
  EditDate: null
  Editor: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• PublicWaterWells (8) -- Related To: Production.LI.PublicWaterWells (1)

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

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