Name: sw.SW.BRWWTP_Inspections

Display Field: Inspector

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 )
• globalid ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: globalid )
• Inspector ( type: esriFieldTypeString, alias: Inspector, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Inspector , Coded Values: [Patrick Johnson: Patrick Johnson] , [John McComas: John McComas] , [Kris Carter: Kris Carter] , ...1 more... )
• StructureStatus ( type: esriFieldTypeString, alias: Structure Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: StructureStatus , Coded Values: [AC: Active] , [AB: Abandoned] , [UC: Under Construction] , ...3 more... )
• Structure_Status_Comment ( type: esriFieldTypeString, alias: Structure Status Comment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Structure_Status_Comment )
• StructureType ( type: esriFieldTypeString, alias: Structure Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: StructureType , Coded Values: [SD: Inlet/storm drain (point of where storm water enters underground system)] , [OF: Outfall (last point of storm water discharge)] , [CV: Culvert (concrete channel to convey runoff)] , ...12 more... )
• Structure_Type_Comment ( type: esriFieldTypeString, alias: Structure Type Comment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Structure_Type_Comment )
• Structure_Condition ( type: esriFieldTypeString, alias: Structure Condition, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Structure_Condition , Coded Values: [E: Excellent] , [G: Good] , [F: Fair] , ...2 more... )
• Structure_Condition_Comment ( type: esriFieldTypeString, alias: Structure Condition Comment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Structure_Condititon_Comment )
• Structure_Maint ( type: esriFieldTypeString, alias: Structure Maintenance, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Structure_Maint , Coded Values: [YES: Yes] , [NO: No] )
• Structure_Maint_Comment ( type: esriFieldTypeString, alias: Structure Maintenance Comment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Structure_Maint_Comment )
• Structure_Length ( type: esriFieldTypeDouble, alias: Structure Length (in.), editable: true, nullable: true, defaultValue: null, modelName: Structure_Length )
• Structure_Width ( type: esriFieldTypeDouble, alias: Structure Width (in.), editable: true, nullable: true, defaultValue: null, modelName: Structure_Width )
• Structure_Height ( type: esriFieldTypeDouble, alias: Structure Height (in.), editable: true, nullable: true, defaultValue: null, modelName: Structure_Height )
• Structure_Depth ( type: esriFieldTypeDouble, alias: Structure Depth (in.), editable: true, nullable: true, defaultValue: null, modelName: Structure_Depth )
• Structure_Material ( type: esriFieldTypeString, alias: Structure Material, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Structure_Material , Coded Values: [CON: Concrete] , [BRK: Brick] , [MTL: Metal] , ...5 more... )
• Other_Structure_Material ( type: esriFieldTypeString, alias: Additional Structure Material Types, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Other_Structure_Material , Coded Values: [ALU: Aluminum] , [ALUS2: Aluminized Steel Type 2] , [BCO: Brick and Concrete] , ...28 more... )
• Structure_Material_Comment ( type: esriFieldTypeString, alias: Structure Material Comment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Structure_Material_Comment )
• Vegetation_Status ( type: esriFieldTypeString, alias: Vegetation Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Vegetation_Status , Coded Values: [NONE: None Present] , [25: Less than 25%] , [50: 25%-50%] , ...2 more... )
• Vegetation_Status_Comment ( type: esriFieldTypeString, alias: Vegetation Status Comment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Vegetation_Status_Comment )
• Trash_Debris_Present ( type: esriFieldTypeString, alias: Trash/Debris Present, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Trash_Debris_Present , Coded Values: [NONE: None Present] , [25: Less than 25%] , [50: 25%-50%] , ...2 more... )
• Trash_Debris_Present_Comment ( type: esriFieldTypeString, alias: Trash/Debris Comment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Trash_Debris_Present_Comment )
• Sediment_Status ( type: esriFieldTypeString, alias: Sediment Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Sediment_Status , Coded Values: [NONE: None Present] , [25: Less than 25%] , [50: 25%-50%] , ...2 more... )
• Sediment_Status_Comment ( type: esriFieldTypeString, alias: Sediment Status Comment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Sediment_Status_Comment )
• Structural_Cleaning ( type: esriFieldTypeString, alias: Structural Cleaning Required, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Structural_Cleaning , Coded Values: [YES: Yes] , [NO: No] )
• Structural_Cleaning_Comment ( type: esriFieldTypeString, alias: Structural Cleaning Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Structural_Cleaning_Comment )
• Feature_Shape ( type: esriFieldTypeString, alias: Feature Shape, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Feature_Shape )
• Asset_GlobalID ( type: esriFieldTypeString, alias: Asset GlobalID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Asset_GlobalID )
• CreationDate ( type: esriFieldTypeDate, alias: CreationDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreationDate )
• Creator ( type: esriFieldTypeString, alias: Creator, editable: false, nullable: true, length: 128, defaultValue: null, modelName: Creator )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: EditDate )
• Editor ( type: esriFieldTypeString, alias: Editor, editable: false, nullable: true, length: 128, defaultValue: null, modelName: Editor )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Status )
• Orig_GlobalID ( type: esriFieldTypeString, alias: Orig_GlobalID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Orig_GlobalID )

Templates:

• Name: sw.SW.BRWWTP_Inspections
  Description:
  Prototype:
  Status: null
  Asset_GlobalID: null
  Orig_GlobalID: null
  Inspector: null
  StructureStatus: null
  Structure_Status_Comment: null
  StructureType: null
  Structure_Type_Comment: null
  Structure_Condition: null
  Structure_Condition_Comment: null
  Structure_Maint: null
  Structure_Maint_Comment: null
  Structure_Length: null
  Structure_Width: null
  Structure_Height: null
  Structure_Depth: null
  Structure_Material: null
  Other_Structure_Material: null
  Structure_Material_Comment: null
  Vegetation_Status: null
  Vegetation_Status_Comment: null
  Trash_Debris_Present: null
  Trash_Debris_Present_Comment: null
  Sediment_Status: null
  Sediment_Status_Comment: null
  Structural_Cleaning: null
  Structural_Cleaning_Comment: null
  Feature_Shape: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Structure_Points (0) -- Related To: sw.SW.Structure_Points (0)
• Structure_Line (1) -- Related To: sw.SW.Structure_Line (1)
• Structure_Area (2) -- Related To: sw.SW.Structure_Area (2)

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
• Creator Field: Creator
• Edit Date Field: EditDate
• Editor Field: Editor

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