View In:   ArcGIS Online Map Viewer

Name: Storm Boxes

Display Field: BoxSize

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 843675033281497bb730f92f96478d66

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 1589150.5049725324
YMin: 7187458.889273018
XMax: 1627185.1703728586
YMax: 7227502.171719104
Spatial Reference: 102743  (3566)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: BoxType
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Default Label: Unknown
UniqueValueInfos:
• Value: Cleanout Box
  Label: Cleanout Box
  Description: N/A
  Symbol:
  
• Value: LID Inlet Box
  Label: LID Inlet Box
  Description: N/A
  Symbol:
  
• Value: Storm Inlet Box
  Label: Storm Inlet Box
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling 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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: BoxType

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• BoxSize ( type: esriFieldTypeString, alias: Box Size, editable: true, nullable: true, length: 22, defaultValue: null, modelName: TYPE )
• Northing ( type: esriFieldTypeDouble, alias: Northing, editable: true, nullable: true, defaultValue: null, modelName: NORTHING )
• Easting ( type: esriFieldTypeDouble, alias: Easting, editable: true, nullable: true, defaultValue: null, modelName: EASTING )
• Elevation ( type: esriFieldTypeDouble, alias: Elevation, editable: true, nullable: true, defaultValue: null, modelName: ELEVATION )
• Snout ( type: esriFieldTypeString, alias: Snout, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Snout , Coded Values: [Yes: Yes] , [No: No] )
• Inlet1Direction ( type: esriFieldTypeString, alias: Inlet 1 Direction, editable: true, nullable: true, length: 10, defaultValue: null, modelName: In_1_Dir , Coded Values: [N: N] , [S: S] , [E: E] , ...6 more... )
• Inlet1MD ( type: esriFieldTypeDouble, alias: Inlet 1 MD, editable: true, nullable: true, defaultValue: 0, modelName: In_1_MD )
• Inlet1FlowLine ( type: esriFieldTypeDouble, alias: Inlet 1 FlowLine, editable: true, nullable: true, defaultValue: 0, modelName: In_1_Elev )
• Inlet2Direction ( type: esriFieldTypeString, alias: Inlet 2 Direction, editable: true, nullable: true, length: 10, defaultValue: null, modelName: In_2_Dir , Coded Values: [N: N] , [S: S] , [E: E] , ...6 more... )
• Inlet2MD ( type: esriFieldTypeDouble, alias: Inlet 2 MD, editable: true, nullable: true, defaultValue: 0, modelName: In_2_MD )
• Inlet2FlowLine ( type: esriFieldTypeDouble, alias: Inlet 2 FlowLine, editable: true, nullable: true, defaultValue: 0, modelName: In_2_Elev )
• Inlet3Direction ( type: esriFieldTypeString, alias: Inlet 3 Direction, editable: true, nullable: true, length: 10, defaultValue: null, modelName: In_3_Dir , Coded Values: [N: N] , [S: S] , [E: E] , ...6 more... )
• Inlet3MD ( type: esriFieldTypeDouble, alias: Inlet 3 MD, editable: true, nullable: true, defaultValue: null, modelName: In_3_MD )
• Inlet3FlowLine ( type: esriFieldTypeDouble, alias: Inlet 3 FlowLine, editable: true, nullable: true, defaultValue: 0, modelName: In_3_Elev )
• Inlet4Direction ( type: esriFieldTypeString, alias: Inlet 4 Direction, editable: true, nullable: true, length: 10, defaultValue: null, modelName: In_4_Dir , Coded Values: [N: N] , [S: S] , [E: E] , ...6 more... )
• Inlet4MD ( type: esriFieldTypeDouble, alias: Inlet 4 MD, editable: true, nullable: true, defaultValue: 0, modelName: In_4_MD )
• Inlet4FlowLine ( type: esriFieldTypeDouble, alias: Inlet 4 FlowLine, editable: true, nullable: true, defaultValue: 0, modelName: In_4_Elev )
• Inlet5Direction ( type: esriFieldTypeString, alias: Inlet 5 Direction, editable: true, nullable: true, length: 10, defaultValue: null, modelName: In_5_Dir , Coded Values: [N: N] , [S: S] , [E: E] , ...6 more... )
• Inlet5MD ( type: esriFieldTypeDouble, alias: Inlet 5 MD, editable: true, nullable: true, defaultValue: 0, modelName: In_5_MD )
• Inlet5FlowLine ( type: esriFieldTypeDouble, alias: Inlet 5 FlowLine, editable: true, nullable: true, defaultValue: 0, modelName: In_5_Elev )
• OutletDirection ( type: esriFieldTypeString, alias: Outlet Direction, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Outlet_Dir , Coded Values: [N: N] , [S: S] , [E: E] , ...6 more... )
• OutletMD ( type: esriFieldTypeDouble, alias: Outlet MD, editable: true, nullable: true, defaultValue: 0, modelName: Outlet_MD )
• OutletFlowLine ( type: esriFieldTypeDouble, alias: Outlet FlowLine, editable: true, nullable: true, defaultValue: null, modelName: Outlet_Elev )
• addfeats_user ( type: esriFieldTypeString, alias: Created By, editable: false, nullable: true, length: 50, defaultValue: null, modelName: addfeats_user )
• addfeats_date ( type: esriFieldTypeDate, alias: Date Created, editable: false, nullable: true, length: 8, defaultValue: null, modelName: addfeats_date )
• editfeats_user ( type: esriFieldTypeString, alias: Edited By, editable: false, nullable: true, length: 50, defaultValue: null, modelName: editfeats_user )
• editfeats_date ( type: esriFieldTypeDate, alias: Date Edited, editable: false, nullable: true, length: 8, defaultValue: null, modelName: editfeats_date )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Abandoned ( type: esriFieldTypeString, alias: Abandoned, editable: true, nullable: true, length: 10, defaultValue: No, modelName: Abandoned , Coded Values: [Yes: Yes] , [No: No] )
• YearInstalled ( type: esriFieldTypeSmallInteger, alias: Year Installed, editable: true, nullable: true, defaultValue: null, modelName: Year_Installed )
• LastCleanedInspectedBy ( type: esriFieldTypeString, alias: Last Cleaned or Inspected By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CleanedInspectedBy , Coded Values: [On-Call: On-Call] , [Tyler Argyle: Tyler Argyle] , [Brandon Johnson: Brandon Johnson] )
• LastDateCleanedInspected ( type: esriFieldTypeDate, alias: Last Date Cleaned or Inspected, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateCleanedInspected )
• LastInspectedOrCleaned ( type: esriFieldTypeString, alias: Last Inspected Or Cleaned, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LastInspectedOrCleaned , Coded Values: [Inspected: Inspected] , [Inspected & Cleaned: Inspected & Cleaned] )
• BoxType ( type: esriFieldTypeString, alias: Box Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BoxType , Coded Values: [Storm Inlet Box: Storm Inlet Box] , [LID Inlet Box: LID Inlet Box] , [LID Cleanout Box: LID Cleanout Box] , ...1 more... )
• NotesConcerns ( type: esriFieldTypeString, alias: Notes & Concerns, editable: true, nullable: true, length: 254, defaultValue: null, modelName: NotesConcerns )
• IsItClean ( type: esriFieldTypeString, alias: Is It Clean?, editable: true, nullable: true, length: 10, defaultValue: Yes, modelName: IsItClean , Coded Values: [Yes: Yes] , [No: No] )
• UpdateMaps ( type: esriFieldTypeString, alias: Update Maps?, editable: true, nullable: true, length: 10, defaultValue: No, modelName: UpdateMaps , Coded Values: [Yes: Yes] , [No: No] )
• HasOrifice ( type: esriFieldTypeString, alias: Has Orifice?, editable: true, nullable: true, length: 10, defaultValue: No, modelName: HasOrifice , Coded Values: [Yes: Yes] , [No: No] )
• UID ( type: esriFieldTypeString, alias: UID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: UID )
• MACPCode ( type: esriFieldTypeString, alias: MACPCode, editable: true, nullable: true, length: 10, defaultValue: null, modelName: MACPCode , Coded Values: [AC: Asbestos Cement] , [BR: Brick] , [CM: Corrugated Metal] , ...11 more... )
• HasTrashGuard ( type: esriFieldTypeString, alias: Has Trash Guard?, editable: true, nullable: true, length: 10, defaultValue: No, modelName: HasTrashGuard , Coded Values: [Yes: Yes] , [No: No] )
• HasOil ( type: esriFieldTypeString, alias: Has Oil, editable: true, nullable: true, length: 255, defaultValue: Yes, modelName: HasOil , Coded Values: [Yes: Yes] , [No: No] )
• HasGarbage ( type: esriFieldTypeString, alias: Has Garbage, editable: true, nullable: true, length: 255, defaultValue: No, modelName: HasGarbage , Coded Values: [Yes: Yes] , [No: No] )
• HasVegetation ( type: esriFieldTypeString, alias: Has Vegetation, editable: true, nullable: true, length: 255, defaultValue: No, modelName: HasVegetation , Coded Values: [Yes: Yes] , [No: No] )
• HasSilt ( type: esriFieldTypeString, alias: Has Silt, editable: true, nullable: true, length: 255, defaultValue: No, modelName: HasSilt , Coded Values: [Yes: Yes] , [No: No] )
• HasRocks ( type: esriFieldTypeString, alias: Has Rocks, editable: true, nullable: true, length: 255, defaultValue: No, modelName: HasRocks , Coded Values: [Yes: Yes] , [No: No] )
• HasOther ( type: esriFieldTypeString, alias: Has Other, editable: true, nullable: true, length: 255, defaultValue: No, modelName: HasOther , Coded Values: [Yes: Yes] , [No: No] )
• GrateCondition ( type: esriFieldTypeString, alias: Grate Condition, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GrateCondition , Coded Values: [Good: Good] , [Poor: Poor] , [Replace: Replace] )
• GrateReplacedDate ( type: esriFieldTypeDate, alias: Grate Replaced Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GrateReplacedDate )
• LinkedFiles ( type: esriFieldTypeString, alias: Linked Files, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: LinkedFiles )
• TrimbleID ( type: esriFieldTypeInteger, alias: Trimble ID, editable: true, nullable: true, defaultValue: null, modelName: TrimbleID )
• DateInstalled ( type: esriFieldTypeDate, alias: DateInstalled, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateInstalled )

Types:

ID: Cleanout Box
Name: Cleanout Box
Domains:
• Snout:
  Inherited
• Inlet1Direction:
  Inherited
• Inlet2Direction:
  Inherited
• Inlet3Direction:
  Inherited
• Inlet4Direction:
  Inherited
• Inlet5Direction:
  Inherited
• OutletDirection:
  Inherited
• Abandoned:
  Inherited
• LastCleanedInspectedBy:
  Inherited
• LastInspectedOrCleaned:
  Inherited
• BoxType:
  Inherited
• IsItClean:
  Inherited
• UpdateMaps:
  Inherited
• HasOrifice:
  Inherited
• MACPCode:
  Inherited
• HasTrashGuard:
  Inherited
• HasOil:
  Inherited
• HasGarbage:
  Inherited
• HasVegetation:
  Inherited
• HasSilt:
  Inherited
• HasRocks:
  Inherited
• HasOther:
  Inherited
• GrateCondition:
  Inherited
Templates:
• Name: Cleanout Box
  Description:
  Prototype:
  Inlet1MD: 0
  DateInstalled: null
  Inlet5MD: 0
  IsItClean: Yes
  Inlet4MD: 0
  UpdateMaps: No
  Inlet3MD: null
  NotesConcerns: null
  Inlet1Direction: null
  Inlet2Direction: null
  LastInspectedOrCleaned: null
  Inlet2MD: 0
  OutletDirection: null
  Inlet4Direction: null
  Inlet5Direction: null
  TrimbleID: null
  BoxSize: null
  Northing: null
  Easting: null
  Elevation: null
  Snout: null
  Inlet1FlowLine: 0
  Inlet2FlowLine: 0
  Inlet3Direction: null
  Inlet3FlowLine: 0
  Inlet4FlowLine: 0
  Inlet5FlowLine: 0
  OutletMD: 0
  OutletFlowLine: null
  LinkedFiles: null
  GrateReplacedDate: null
  GrateCondition: null
  HasOther: No
  Abandoned: No
  YearInstalled: null
  LastCleanedInspectedBy: null
  LastDateCleanedInspected: null
  BoxType: Cleanout Box
  HasOrifice: No
  UID: null
  MACPCode: null
  HasTrashGuard: No
  HasOil: Yes
  HasGarbage: No
  HasVegetation: No
  HasSilt: No
  HasRocks: No
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: LID Inlet Box
Name: LID Inlet Box
Domains:
• Snout:
  Inherited
• Inlet1Direction:
  Inherited
• Inlet2Direction:
  Inherited
• Inlet3Direction:
  Inherited
• Inlet4Direction:
  Inherited
• Inlet5Direction:
  Inherited
• OutletDirection:
  Inherited
• Abandoned:
  Inherited
• LastCleanedInspectedBy:
  Inherited
• LastInspectedOrCleaned:
  Inherited
• BoxType:
  Inherited
• IsItClean:
  Inherited
• UpdateMaps:
  Inherited
• HasOrifice:
  Inherited
• MACPCode:
  Inherited
• HasTrashGuard:
  Inherited
• HasOil:
  Inherited
• HasGarbage:
  Inherited
• HasVegetation:
  Inherited
• HasSilt:
  Inherited
• HasRocks:
  Inherited
• HasOther:
  Inherited
• GrateCondition:
  Inherited
Templates:
• Name: LID Inlet Box
  Description:
  Prototype:
  Inlet1MD: 0
  DateInstalled: null
  Inlet5MD: 0
  IsItClean: Yes
  Inlet4MD: 0
  UpdateMaps: No
  Inlet3MD: null
  NotesConcerns: null
  Inlet1Direction: null
  Inlet2Direction: null
  LastInspectedOrCleaned: null
  Inlet2MD: 0
  OutletDirection: null
  Inlet4Direction: null
  Inlet5Direction: null
  TrimbleID: null
  BoxSize: null
  Northing: null
  Easting: null
  Elevation: null
  Snout: null
  Inlet1FlowLine: 0
  Inlet2FlowLine: 0
  Inlet3Direction: null
  Inlet3FlowLine: 0
  Inlet4FlowLine: 0
  Inlet5FlowLine: 0
  OutletMD: 0
  OutletFlowLine: null
  LinkedFiles: null
  GrateReplacedDate: null
  GrateCondition: null
  HasOther: No
  Abandoned: No
  YearInstalled: null
  LastCleanedInspectedBy: null
  LastDateCleanedInspected: null
  BoxType: LID Inlet Box
  HasOrifice: No
  UID: null
  MACPCode: null
  HasTrashGuard: No
  HasOil: Yes
  HasGarbage: No
  HasVegetation: No
  HasSilt: No
  HasRocks: No
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Storm Inlet Box
Name: Storm Inlet Box
Domains:
• Snout:
  Inherited
• Inlet1Direction:
  Inherited
• Inlet2Direction:
  Inherited
• Inlet3Direction:
  Inherited
• Inlet4Direction:
  Inherited
• Inlet5Direction:
  Inherited
• OutletDirection:
  Inherited
• Abandoned:
  Inherited
• LastCleanedInspectedBy:
  Inherited
• LastInspectedOrCleaned:
  Inherited
• BoxType:
  Inherited
• IsItClean:
  Inherited
• UpdateMaps:
  Inherited
• HasOrifice:
  Inherited
• MACPCode:
  Inherited
• HasTrashGuard:
  Inherited
• HasOil:
  Inherited
• HasGarbage:
  Inherited
• HasVegetation:
  Inherited
• HasSilt:
  Inherited
• HasRocks:
  Inherited
• HasOther:
  Inherited
• GrateCondition:
  Inherited
Templates:
• Name: Storm Inlet Box
  Description:
  Prototype:
  Inlet1MD: 0
  DateInstalled: null
  Inlet5MD: 0
  IsItClean: Yes
  Inlet4MD: 0
  UpdateMaps: No
  Inlet3MD: null
  NotesConcerns: null
  Inlet1Direction: null
  Inlet2Direction: null
  LastInspectedOrCleaned: null
  Inlet2MD: 0
  OutletDirection: null
  Inlet4Direction: null
  Inlet5Direction: null
  TrimbleID: null
  BoxSize: null
  Northing: null
  Easting: null
  Elevation: null
  Snout: null
  Inlet1FlowLine: 0
  Inlet2FlowLine: 0
  Inlet3Direction: null
  Inlet3FlowLine: 0
  Inlet4FlowLine: 0
  Inlet5FlowLine: 0
  OutletMD: 0
  OutletFlowLine: null
  LinkedFiles: null
  GrateReplacedDate: null
  GrateCondition: null
  HasOther: No
  Abandoned: No
  YearInstalled: null
  LastCleanedInspectedBy: null
  LastDateCleanedInspected: null
  BoxType: Storm Inlet Box
  HasOrifice: No
  UID: null
  MACPCode: null
  HasTrashGuard: No
  HasOil: Yes
  HasGarbage: No
  HasVegetation: No
  HasSilt: No
  HasRocks: No
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• Utilities.DBO.SIBCleanInspRT (6) -- Related To: StormInletBoxCleaningInspectionsRT (2161)

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: addfeats_date
• Creator Field: addfeats_user
• Edit Date Field: editfeats_date
• Editor Field: editfeats_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

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