Name: CB Storm Water Inspection Data
Display Field: FacilityID
Type: Table
Geometry Type: N/A
Description:
Service Item Id: bca953ccd6a0433e8b6eca7613b1ac1b
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:
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: true
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID
)
-
FacilityID
(
type: esriFieldTypeString, alias: Facility ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FacilityID
)
-
Date
(
type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Date
)
-
Condition
(
type: esriFieldTypeString, alias: Structure Condition, editable: true, nullable: true, length: 25, defaultValue: Good, modelName: Condition
, Coded Values:
[Excellent: Excellent]
, [Good: Good]
, [Fair: Fair]
, ...1 more...
)
-
Flow
(
type: esriFieldTypeString, alias: Flow Amount, editable: true, nullable: true, length: 25, defaultValue: None, modelName: Flow
, Coded Values:
[None: None]
, [Trickle: Trickle]
, [Steady: Steady]
, ...1 more...
)
-
Excessive_Sediment
(
type: esriFieldTypeSmallInteger, alias: Excessive Sediment, editable: true, nullable: true, defaultValue: 0, modelName: Excessive_Sediment
, Coded Values:
[-1: Yes]
, [0: No]
)
-
Pollution
(
type: esriFieldTypeSmallInteger, alias: Pollution, editable: true, nullable: true, defaultValue: 0, modelName: Pollution
, Coded Values:
[-1: Yes]
, [0: No]
)
-
Oil_Sheen
(
type: esriFieldTypeSmallInteger, alias: Oil Sheen, editable: true, nullable: true, defaultValue: 0, modelName: Oil_Sheen
, Coded Values:
[-1: Yes]
, [0: No]
)
-
Discoloration
(
type: esriFieldTypeSmallInteger, alias: Discoloration, editable: true, nullable: true, defaultValue: 0, modelName: Discoloration
, Coded Values:
[-1: Yes]
, [0: No]
)
-
Foam_Soap
(
type: esriFieldTypeSmallInteger, alias: Foam or Soap, editable: true, nullable: true, defaultValue: 0, modelName: Foam_Soap
, Coded Values:
[-1: Yes]
, [0: No]
)
-
AlgaGrowth
(
type: esriFieldTypeSmallInteger, alias: Algal Growth, editable: true, nullable: true, defaultValue: 0, modelName: AlgaGrowth
, Coded Values:
[-1: Yes]
, [0: No]
)
-
Sewage
(
type: esriFieldTypeSmallInteger, alias: Sewage, editable: true, nullable: true, defaultValue: 0, modelName: Sewage
, Coded Values:
[-1: Yes]
, [0: No]
)
-
Odor
(
type: esriFieldTypeSmallInteger, alias: Odor, editable: true, nullable: true, defaultValue: 0, modelName: Odor
, Coded Values:
[-1: Yes]
, [0: No]
)
-
Yard_Waste
(
type: esriFieldTypeSmallInteger, alias: Yard Waste, editable: true, nullable: true, defaultValue: 0, modelName: Yard_Waste
, Coded Values:
[-1: Yes]
, [0: No]
)
-
Pet_Waste
(
type: esriFieldTypeSmallInteger, alias: Pet Waste, editable: true, nullable: true, defaultValue: 0, modelName: Pet_Waste
, Coded Values:
[-1: Yes]
, [0: No]
)
-
Cig_Butts
(
type: esriFieldTypeSmallInteger, alias: Cigarette Butts, editable: true, nullable: true, defaultValue: 0, modelName: Cig_Butts
, Coded Values:
[0: None]
, [-1: Less than 10 Butts]
, [-2: 10 or More Butts]
)
-
Accessible
(
type: esriFieldTypeString, alias: Accessable, editable: true, nullable: true, length: 25, defaultValue: Accessible, modelName: Accessible
, Coded Values:
[Accessible: Accessible]
, [Paved Over: Paved Over]
, [Unopenable: Unopenable]
, ...2 more...
)
-
Cleaned
(
type: esriFieldTypeSmallInteger, alias: Cleaned, editable: true, nullable: true, defaultValue: 0, modelName: Cleaned
, Coded Values:
[-1: Yes]
, [0: No]
)
-
Clean_Date
(
type: esriFieldTypeDate, alias: Date Cleaned, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Clean_Date
)
-
Follow_Up
(
type: esriFieldTypeSmallInteger, alias: Follow Up, editable: true, nullable: true, defaultValue: 0, modelName: Follow_Up
, Coded Values:
[-1: Yes]
, [0: No]
)
-
Comments
(
type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 1024, defaultValue: null, modelName: Comments
)
-
created_user
(
type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user
)
-
created_date
(
type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date
)
-
last_edited_user
(
type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user
)
-
last_edited_date
(
type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date
)
-
GlobalID
(
type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID
)
-
CleanedBy
(
type: esriFieldTypeString, alias: Cleaned By, editable: true, nullable: true, length: 25, defaultValue: null, modelName: CleanedBy
)
-
Sediment_Depth
(
type: esriFieldTypeSmallInteger, alias: Sediment Depth, editable: true, nullable: true, defaultValue: 0, modelName: Sediment_Depth
, Range: [0, 48]
)
-
sw_cb_insp_status
(
type: esriFieldTypeSmallInteger, alias: CB Inspection Status, editable: true, nullable: true, defaultValue: null, modelName: sw_cb_insp_status
, Coded Values:
[1: 2021 Not inspected]
, [2: 2022 Not inspected]
, [4: Inspected - Follow up needed]
, ...3 more...
)
-
CleanYear
(
type: esriFieldTypeInteger, alias: Year for Next Cleaning, editable: true, nullable: true, defaultValue: null, modelName: CleanYear
)
Templates:
-
Name: CB Storm Water Inspection Data
Description:
Prototype:
sw_cb_insp_status: null
FacilityID: null
Date: null
Condition: Good
Flow: None
Excessive_Sediment: 0
Pollution: 0
Oil_Sheen: 0
Discoloration: 0
Foam_Soap: 0
AlgaGrowth: 0
Sewage: 0
Odor: 0
Yard_Waste: 0
Pet_Waste: 0
Cig_Butts: 0
Accessible: Accessible
Cleaned: 0
Clean_Date: null
Follow_Up: 0
Comments: null
Sediment_Depth: 0
CleanedBy: null
CleanYear: null
Drawing Tool: esriFeatureEditToolNone
Relationships:
Capabilities: Query,Create,Update,Delete,Uploads,Editing,Extract
Sync Can Return Changes: true
Is Data Versioned: true
Supports Rollback On Failure: false
Supports ApplyEdits With Global Ids: false
Supports ApplyEdits By Upload Id: true
Edit Fields Info:
- Creation Date Field: created_date
- Creator Field: created_user
- Edit Date Field: last_edited_date
- Editor Field: last_edited_user
Supports Query With Historic Moment: true
Supports Coordinates Quantization: false
Child Resources:
Field Groups
  
Contingent Values
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
Update Metadata