Name: Watersheds.SDE.CapitalStatus

Display Field: WPname

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 2e4b15e4b6054a20ada5a9f33631c30c

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• WPname ( type: esriFieldTypeString, alias: WPname, editable: true, nullable: true, length: 255, defaultValue: null, modelName: WPname )
• WPid ( type: esriFieldTypeString, alias: WPid, editable: true, nullable: true, length: 255, defaultValue: null, modelName: WPid )
• BondEndDate ( type: esriFieldTypeDate, alias: BondEndDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: BondEndDate )
• BondInspec ( type: esriFieldTypeDate, alias: BondInspec, editable: true, nullable: true, length: 8, defaultValue: null, modelName: BondInspec )
• TreeSurvey ( type: esriFieldTypeDate, alias: TreeSurvey, editable: true, nullable: true, length: 8, defaultValue: null, modelName: TreeSurvey )
• CONpercent ( type: esriFieldTypeDouble, alias: CONpercent, editable: true, nullable: true, defaultValue: null, modelName: CONpercent )
• CONcomplete ( type: esriFieldTypeDate, alias: CONcomplete, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Holder )
• CONstart ( type: esriFieldTypeDate, alias: CONstart, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CONstart )
• PreCon ( type: esriFieldTypeDate, alias: PreCon, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PreCon )
• Plans_SpecPrint ( type: esriFieldTypeString, alias: Plans_SpecPrint, editable: true, nullable: true, length: 255, defaultValue: No, modelName: Plans_SpecPrint , Coded Values: [Yes: Yes] , [No: No] )
• BID ( type: esriFieldTypeDate, alias: BID, editable: true, nullable: true, length: 8, defaultValue: null, modelName: BID )
• NEXTsubmit ( type: esriFieldTypeDate, alias: NEXTsubmit, editable: true, nullable: true, length: 8, defaultValue: null, modelName: NEXTsubmit )
• WPR ( type: esriFieldTypeDouble, alias: WPR, editable: true, nullable: true, defaultValue: null, modelName: WPR2 , Coded Values: [0.1: 10%] , [0.3: 30%] , [0.75: 75%] , ...3 more... )
• WPRdate ( type: esriFieldTypeDate, alias: WPRdate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WPRdate )
• WPRloc ( type: esriFieldTypeString, alias: WPRloc, editable: true, nullable: true, length: 255, defaultValue: null, modelName: WPRloc , Coded Values: [to consultant: to consultant] , [from consultant: from consultant] )
• NOTES ( type: esriFieldTypeString, alias: NOTES, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NOTES )
• DESpercent ( type: esriFieldTypeDouble, alias: DESpercent, editable: true, nullable: true, defaultValue: null, modelName: DESpercent )
• DESduedate ( type: esriFieldTypeDate, alias: DESduedate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DESduedate )
• DESnotes ( type: esriFieldTypeString, alias: DESnotes, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: DESnotes )
• TreeWalkDate ( type: esriFieldTypeDate, alias: TreeWalkDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: TreeWalkDate )
• FinalWalkDate ( type: esriFieldTypeDate, alias: FinalWalkDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FinalWalkDate )
• CONplantmaterial ( type: esriFieldTypeDate, alias: CONplantmaterial, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CONplantmaterial )
• CONplantinstall ( type: esriFieldTypeDate, alias: CONplantinstall, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CONplantinstall )
• CONnotes ( type: esriFieldTypeString, alias: CONnotes, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: CONnotes )
• PartialInspectionDate ( type: esriFieldTypeDate, alias: PartialInspectionDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PartialInspectionDate )
• InspectionDate ( type: esriFieldTypeDate, alias: InspectionDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InspectionDate )
• MaintNotes ( type: esriFieldTypeString, alias: MaintNotes, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: MaintNotes )
• DESschedule30 ( type: esriFieldTypeDate, alias: DESschedule30, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DESschedule30 )
• DESschedule60 ( type: esriFieldTypeDate, alias: DESschedule60, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DESschedule60 )
• DESschedule90 ( type: esriFieldTypeDate, alias: DESschedule90, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DESschedule90 )
• DESschedule100 ( type: esriFieldTypeDate, alias: DESschedule100, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DESschedule100 )
• CONpermit ( type: esriFieldTypeString, alias: CONpermit, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CONpermit )
• StreamCloseDate ( type: esriFieldTypeDate, alias: StreamCloseDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: StreamCloseDate )
• StreamType ( type: esriFieldTypeString, alias: StreamType, editable: true, nullable: true, length: 255, defaultValue: null, modelName: StreamType )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: Watersheds.SDE.CapitalStatus
  Description:
  Prototype:
  StreamType: null
  StreamCloseDate: null
  WPname: null
  WPid: null
  BondEndDate: null
  BondInspec: null
  TreeSurvey: null
  CONpercent: null
  CONcomplete: null
  CONstart: null
  PreCon: null
  Plans_SpecPrint: No
  BID: null
  NEXTsubmit: null
  WPR: null
  WPRdate: null
  WPRloc: null
  NOTES: null
  DESpercent: null
  DESduedate: null
  DESnotes: null
  TreeWalkDate: null
  FinalWalkDate: null
  CONplantmaterial: null
  CONplantinstall: null
  CONnotes: null
  PartialInspectionDate: null
  InspectionDate: null
  MaintNotes: null
  DESschedule30: null
  DESschedule60: null
  DESschedule90: null
  DESschedule100: null
  CONpermit: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• ProjectInformation (1) -- Related To: Watersheds.SDE.ProjectInformation (0)

Capabilities: Query,Update,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

Child Resources:

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