Name: Feature Condition Inspection Table

Display Field: proj_id

Type: Table

Geometry Type: N/A

Description:

Service Item Id: a99422cec2da4fffbb4df6fc3737e4a4

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

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: false
Supports Returning Query Extent: false
Supports Query With Distance: false
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: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
• proj_id ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: Proj_ID, alias: Project ID )
• date ( nullable: true, editable: true, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: Date, alias: Date )
• bafflebox ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: BaffleBox, alias: Baffle Box , Coded Values: [Funct: Functioning] , [BlockSW: Stormwater Blocking Outflow] , [BlockVeg: Vegetation Blocking Outflow] , ...3 more... )
• bam_dn ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: BAM_DN, alias: BAM-DN , Coded Values: [Funct: Functioning] , [Flow: Flow Blocked] , [Veg: Vegetation Overgrown] , ...1 more... )
• condition ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: Condition, alias: Condition , Coded Values: [OK: No Issues Noted] , [Fence: Fence Down or Broken] , [Tree: Tree Down or Needs Removal] , ...5 more... )
• floodpoint ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: FloodPoint, alias: Flood Point , Coded Values: [Street: Street Flooding] , [Yard: Yard Flooding] , [House: House Flooding] , ...5 more... )
• inletbskt ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: InletBskt, alias: Inlet Basket , Coded Values: [Funct: Little Debris and Functioning] , [Some: Some Debris But Still Functioning] , [Full: Full of Debris But Still Functioning] , ...2 more... )
• notes ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: Notes, alias: Notes , Coded Values: [Street: Street Flooding] , [Yard: Yard Flooding] , [House: House Flooding] , ...5 more... )
• pond ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: Pond, alias: Pond , Coded Values: [NoIssue: No Problems Noted] , [BeeMat: BeeMats Flipped or Untethered] , [Fence: Fence Section Broken] , ...5 more... )
• sedtrap ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: SedTrap, alias: Sediment Trap , Coded Values: [Functioning: Debris in Sump but Functioning] , [Full: Sump Full of Debris] , [Blocked: Debris Blocking Flow] )
• water_depth ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: Water_Depth, alias: Water Depth , Range: [0, 60] )
• sed_in ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: SedIn, alias: Sediment Inches , Range: [0, 60] )
• fieldnote ( nullable: true, editable: true, defaultValue: null, length: 300, type: esriFieldTypeString, modelName: FieldNote, alias: Field Note )
• prepostinsp ( nullable: true, editable: true, defaultValue: null, length: 4, type: esriFieldTypeString, modelName: PrePostInsp, alias: Pre or Post Storm , Coded Values: [Pre: Before a Storm] , [Post: After a Storm] )
• creationdate ( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: creationdate, alias: CreationDate )
• creator ( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: creator, alias: Creator )
• editdate ( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: editdate, alias: EditDate )
• editor ( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: editor, alias: Editor )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: globalid, alias: globalid )
• assetnam ( nullable: true, editable: true, defaultValue: null, length: 25, type: esriFieldTypeString, modelName: assetnam, alias: Asset Name )

Templates:

• Name: Feature Condition Inspection Table
  Description:
  Prototype:
  date: null
  pond: null
  sedtrap: null
  notes: null
  floodpoint: null
  sed_in: null
  assetnam: null
  proj_id: null
  prepostinsp: null
  inletbskt: null
  condition: null
  water_depth: null
  fieldnote: null
  bafflebox: null
  bam_dn: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• FeaturesToInspect (0) -- Related To: FeaturesToInspect (0)

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

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

Supported Operations:   Query   Query Attachments   Query Related Records   Calculate   Validate SQL   Generate Renderer   Return Updates   Metadata