Name: sw.DBO.Inlets_Cleaning_Form

Display Field: Accessible

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Supports Advanced Queries: true

Supports Statistics: 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

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• CleaningStatus ( type: esriFieldTypeString, alias: Did you clean the inlet?, editable: true, nullable: true, length: 5, defaultValue: null, modelName: CleaningStatus , Coded Values: [Y: Yes] , [N: No] )
• NotCleanedReason ( type: esriFieldTypeString, alias: Why was inlet not cleaned?, editable: true, nullable: true, length: 256, defaultValue: null, modelName: NotCleanedReason )
• Accessible ( type: esriFieldTypeString, alias: Is inlet accessible?, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Accessible , Coded Values: [Y: Yes] , [N: No] )
• Reason_Inaccessible ( type: esriFieldTypeString, alias: Reason for inaccessibility, editable: true, nullable: true, length: 256, defaultValue: null, modelName: Reason_Inaccessible , Coded Values: [CON: Construction] , [VEH: Parked Vehicles] , [OTH: Other] )
• Stru_Condit ( type: esriFieldTypeString, alias: Structural condition of inlet, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Stru_Condit , Coded Values: [Good: Good] , [Poor: Poor] , [NA: NA] )
• Outfall_Condit ( type: esriFieldTypeString, alias: Condition of outfall pipe, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Outfall_Condit , Coded Values: [Obstructed: Obstructed] , [Clear: Clear] )
• Outfall_Release ( type: esriFieldTypeString, alias: Did you release outfall pipe?, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Outfall_Release , Coded Values: [Yes: Yes] , [No: No] , [NA: NA] )
• Inlet_ID ( type: esriFieldTypeString, alias: Inlet_ID, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Inlet_ID )
• Neighborhood ( type: esriFieldTypeString, alias: Neighborhood, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Neighborhood )
• Street ( type: esriFieldTypeString, alias: Street, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Street )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Location )
• InspectionDate ( type: esriFieldTypeDate, alias: InspectionDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InspectionDate )
• QC ( type: esriFieldTypeString, alias: QC, editable: true, nullable: true, length: 20, defaultValue: null, modelName: QC )
• QC_Comments ( type: esriFieldTypeString, alias: QC_Comments, editable: true, nullable: true, length: 256, defaultValue: null, modelName: QC_Comments )
• CreationDate_1 ( type: esriFieldTypeDate, alias: CreationDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreationDate_1 )
• Creator_1 ( type: esriFieldTypeString, alias: Creator, editable: false, nullable: true, length: 128, defaultValue: null, modelName: Creator_1 )
• EditDate_1 ( type: esriFieldTypeDate, alias: EditDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: EditDate_1 )
• Editor_1 ( type: esriFieldTypeString, alias: Editor, editable: false, nullable: true, length: 128, defaultValue: null, modelName: Editor_1 )
• FY_PO ( type: esriFieldTypeString, alias: FY_PO, editable: true, nullable: true, length: 10, defaultValue: null, modelName: FY_PO )
• Crew ( type: esriFieldTypeString, alias: Crew, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Crew )
• Comment_Contractor ( type: esriFieldTypeString, alias: Comment_Contractor, editable: true, nullable: true, length: 256, defaultValue: null, modelName: Comment_Contractor )
• DateCleaned ( type: esriFieldTypeDate, alias: Date Inlet was cleaned or visited by Contractor, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateCleaned )
• Orig_GBID ( type: esriFieldTypeString, alias: Orig_GBID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Orig_GBID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: sw.DBO.Inlets_Cleaning_Form
  Description:
  Prototype:
  Orig_GBID: null
  DateCleaned: null
  CleaningStatus: null
  NotCleanedReason: null
  Accessible: null
  Reason_Inaccessible: null
  Stru_Condit: null
  Outfall_Condit: null
  Outfall_Release: null
  Inlet_ID: null
  Neighborhood: null
  Street: null
  Location: null
  InspectionDate: null
  QC: null
  QC_Comments: null
  Comment_Contractor: null
  Crew: null
  FY_PO: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• sw.DBO.Inlet_Contractor_Cleaning (0) -- Related To: Inlets Contractor Cleaning (0)

Capabilities: Query,Create,Update,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: CreationDate_1
• Creator Field: Creator_1
• Edit Date Field: EditDate_1
• Editor Field: Editor_1

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

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