View In:   ArcGIS Online Map Viewer

Name: swUnderdrains

Display Field: ASSETTYPE

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: Underdrains are perforated pipes surrounded with gravel that are meant to aid in stormwater and/or percolation. They can be used for exfiltration or infiltration, however all of the pipes that Hillsborough County has inventoried thus far are considered mainly for infiltration. They can connect to various structures, and can also be fitted with Clean-outs. The asset inventory team typically inventories underdrains that run parallel to the roadway.

Copyright Text: Hillsborough County, FL

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.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: 458246.48082091287
YMin: 1212224.3646323234
XMax: 635577.7534542456
YMax: 1392677.2028729096
Spatial Reference: 102659  (2237)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [155, 144, 42, 255]
Width: 1
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Feature Draw Order:

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

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ASSETTYPE ( type: esriFieldTypeString, alias: ASSET TYPE, editable: true, nullable: true, length: 24, defaultValue: UNDERDRAIN, modelName: ASSETTYPE )
• UNITID ( type: esriFieldTypeString, alias: UNITID, editable: true, nullable: true, length: 16, defaultValue: null, modelName: UNITID )
• UNDRTYPE ( type: esriFieldTypeString, alias: UNDERDRAIN TYPE, editable: true, nullable: true, length: 8, defaultValue: INFLT, modelName: UNDRTYPE )
• UNDRDESC ( type: esriFieldTypeString, alias: DESCRIPTION, editable: true, nullable: true, length: 6, defaultValue: null, modelName: UNDERDESC )
• MATERIAL ( type: esriFieldTypeString, alias: MATERIAL, editable: true, nullable: true, length: 6, defaultValue: null, modelName: MATERIAL )
• P_SHAPE ( type: esriFieldTypeString, alias: SHAPE, editable: true, nullable: true, length: 6, defaultValue: null, modelName: D_SHAPE )
• WIDTH ( type: esriFieldTypeSmallInteger, alias: WIDTH, editable: true, nullable: true, defaultValue: null, modelName: WIDTH , Range: [0, 150] )
• VERTPANEL ( type: esriFieldTypeString, alias: VERTICAL PANEL, editable: true, nullable: true, length: 1, defaultValue: null, modelName: VERTPANEL )
• FLOW ( type: esriFieldTypeString, alias: FLOW, editable: true, nullable: true, length: 2, defaultValue: null, modelName: FLOW , Coded Values: [N: NORTH] , [NE: NORTHEAST] , [E: EAST] , ...5 more... )
• OUTFALL_TO ( type: esriFieldTypeString, alias: OUTFALL TO, editable: true, nullable: true, length: 20, defaultValue: null, modelName: OUTFALL_TO , Coded Values: [CANAL: CANAL] , [CREEK: CREEK] , [LAKE: LAKE] , ...6 more... )
• NODE1 ( type: esriFieldTypeString, alias: UPSTREAM UNIT ID, editable: true, nullable: true, length: 16, defaultValue: null, modelName: NODE1 )
• NODE2 ( type: esriFieldTypeString, alias: DOWNSTREAM UNIT ID, editable: true, nullable: true, length: 16, defaultValue: null, modelName: NODE2 )
• OWNER ( type: esriFieldTypeString, alias: OWNER, editable: true, nullable: true, length: 6, defaultValue: null, modelName: OWNER , Coded Values: [C: CITY OF TAMPA] , [FDOT: FLORIDA DEPT. OF TRANSPORTATION] , [H: HILLSBOROUGH COUNTY] , ...12 more... )
• MAINTAINER ( type: esriFieldTypeString, alias: MAINTAINER, editable: true, nullable: true, length: 6, defaultValue: null, modelName: MAINTAINER , Coded Values: [C: CITY OF TAMPA] , [FDOT: FLORIDA DEPT. OF TRANSPORTATION] , [H: HILLSBOROUGH COUNTY] , ...13 more... )
• CATEGORY ( type: esriFieldTypeString, alias: CATEGORY, editable: true, nullable: true, length: 16, defaultValue: null, modelName: CATEGORY , Coded Values: [OWN_ACPT: BOCC OWN/ACCEPT] , [PUB_RW: PUBLIC R/W] , [PUBEASE_INSTR: PUBLIC EASEMENT BY INSTRUMENT] , ...5 more... )
• INSP_DATE ( type: esriFieldTypeDate, alias: LAST INSPECTION DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSP_DATE )
• INSP_TIME ( type: esriFieldTypeString, alias: LAST INSPECTION TIME, editable: true, nullable: true, length: 10, defaultValue: null, modelName: INSP_TIME )
• INSP_TYPE ( type: esriFieldTypeString, alias: INSP_TYPE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSP_TYPE , Coded Values: [NPDES: SCHEDULED NPDES] , [OPS: OPERATIONS] , [INVEST: STORMWATER INVESTIGATIONS] , ...1 more... )
• INSP_BY ( type: esriFieldTypeString, alias: INSPECTED BY, editable: true, nullable: true, length: 255, defaultValue: null, modelName: INSP_BY , Coded Values: [1: ACEVEDOR] , [2: BACILAV] , [3: BROOMW] , ...13 more... )
• CONDITION ( type: esriFieldTypeSmallInteger, alias: CONDITION, editable: true, nullable: true, defaultValue: null, modelName: CONDITION , Coded Values: [5: 5] , [4: 4] , [3: 3] , ...3 more... )
• BLOCKAGE ( type: esriFieldTypeString, alias: BLOCKAGE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: BLOCKAGE , Coded Values: [0-10: 0%-10%] , [11-20: 11%-20%] , [21-30: 21%-30%] , ...7 more... )
• ESTIMATE ( type: esriFieldTypeString, alias: ESTIMATE, editable: true, nullable: true, length: 1, defaultValue: null, modelName: ESTIMATE , Coded Values: [Y: Yes] , [N: No] )
• HOMEMADE ( type: esriFieldTypeString, alias: HOMEMADE, editable: true, nullable: true, length: 1, defaultValue: null, modelName: HOMEMADE , Coded Values: [Y: Yes] , [N: No] )
• EXCEPTIONS ( type: esriFieldTypeSmallInteger, alias: EXCEPTIONS, editable: true, nullable: true, defaultValue: 0, modelName: EXCEPTIONS , Range: [0, 1] )
• NOTES ( type: esriFieldTypeString, alias: NOTES, editable: true, nullable: true, length: 100, defaultValue: null, modelName: NOTES )
• DESCRIPT ( type: esriFieldTypeString, alias: LOCATION DESCRIPTION, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DESCRIPT )
• SERV_UNIT ( type: esriFieldTypeString, alias: SERVICE UNIT, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SERV_UNIT , Coded Values: [ESU: EAST SERVICE UNIT] , [SSU: SOUTH SERVICE UNIT] , [WSU: WEST SERVICE UNIT] )
• BLOCK ( type: esriFieldTypeString, alias: OPERATIONS BLOCK, editable: true, nullable: true, length: 5, defaultValue: null, modelName: BLOCK )
• WATERSHED ( type: esriFieldTypeString, alias: DRAINAGE DISTRICT, editable: true, nullable: true, length: 14, defaultValue: null, modelName: WATERSHED , Coded Values: [Alafia River: ALAFIA RIVER] , [Brooker: BROOKER CREEK] , [Bullfrog/Wolf: BULLFROG/WOLF BRANCH CREEK] , ...16 more... )
• TTRRSS ( type: esriFieldTypeString, alias: TRS, editable: true, nullable: true, length: 6, defaultValue: null, modelName: TTRRSS )
• SUBAREA ( type: esriFieldTypeString, alias: SUBAREA, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SUBAREA )
• SOURCE ( type: esriFieldTypeString, alias: LOCATION SOURCE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SOURCE , Coded Values: [DIGR: DIGITIZED FROM RASTER] , [DIGV: DIGITIZED VECTOR] , [GPS: GPS ACQUIRED] , ...3 more... )
• INSTALL_DATE ( type: esriFieldTypeDate, alias: INSTALL_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALL_DATE )
• MS4 ( type: esriFieldTypeString, alias: MS4, editable: true, nullable: true, length: 1, defaultValue: null, modelName: MS4 , Coded Values: [Y: Yes] , [N: No] )
• ADD_DATE ( type: esriFieldTypeDate, alias: ADD DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ADD_DATE )
• ADD_BY ( type: esriFieldTypeString, alias: ADD BY, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ADD_BY , Coded Values: [1: ACEVEDOR] , [2: BACILAV] , [3: BROOMW] , ...13 more... )
• MOD_DATE ( type: esriFieldTypeDate, alias: MOD DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MOD_DATE )
• MOD_BY ( type: esriFieldTypeString, alias: MOD BY, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MOD_BY , Coded Values: [1: ACEVEDOR] , [2: BACILAV] , [3: BROOMW] , ...13 more... )
• MOD_WHY ( type: esriFieldTypeString, alias: MOD WHY, editable: true, nullable: true, length: 16, defaultValue: null, modelName: MOD_WHY , Coded Values: [GEO_CORR: GEOMETRY CORRECTED] , [GEO_RLCT: ASSET RELOCATED] , [ATTR_CORR: ATTRIBUTE CORRECTED] , ...2 more... )
• EXP_DATE ( type: esriFieldTypeDate, alias: EXPIRED DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EXP_DATE )
• EXP_BY ( type: esriFieldTypeString, alias: EXPIRED BY, editable: true, nullable: true, length: 16, defaultValue: null, modelName: EXP_BY , Coded Values: [1: ACEVEDOR] , [2: BACILAV] , [3: BROOMW] , ...13 more... )
• EXP_WHY ( type: esriFieldTypeString, alias: EXPIRED WHY, editable: true, nullable: true, length: 6, defaultValue: null, modelName: EXP_WHY , Coded Values: [RMVD: REMOVED] , [ABDN: ABANDONED] , [DUP: DUPLICATE ASSET] , ...1 more... )
• INSP_FLAG ( type: esriFieldTypeString, alias: INSP_FLAG, editable: true, nullable: true, length: 5, defaultValue: null, modelName: INSP_FLAG , Coded Values: [NA: NOT APPLICABLE] , [NINSP: NEEDS INSPECTION] , [INSP: INSPECTED] )
• MEDIAKEY ( type: esriFieldTypeInteger, alias: MEDIAKEY, editable: true, nullable: true, defaultValue: null, modelName: MEDIAKEY )
• UNITNUM ( type: esriFieldTypeInteger, alias: UNITNUM, editable: true, nullable: true, defaultValue: null, modelName: UNITNUM )
• INSPUNIQUE ( type: esriFieldTypeString, alias: INSPUNIQUE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INSPUNIQUE )
• WO_NUM ( type: esriFieldTypeString, alias: WO_NUM, editable: true, nullable: true, length: 18, defaultValue: null, modelName: WO_NUM )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• MID_X ( type: esriFieldTypeDouble, alias: MID_X, editable: true, nullable: true, defaultValue: null, modelName: MID_X )
• MID_Y ( type: esriFieldTypeDouble, alias: MID_Y, editable: true, nullable: true, defaultValue: null, modelName: MID_Y )
• Insp_zone ( type: esriFieldTypeString, alias: Insp Zone, editable: true, nullable: true, length: 75, defaultValue: null, modelName: Insp_zone )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, nullable: true, defaultValue: null, modelName: Shape.STLength(), required: true )

Templates:

• Name: swUnderdrains
  Description:
  Prototype:
  MID_Y: null
  Insp_zone: null
  ASSETTYPE: UNDERDRAIN
  UNITID: null
  UNDRTYPE: INFLT
  UNDRDESC: null
  MATERIAL: null
  P_SHAPE: null
  WIDTH: null
  VERTPANEL: null
  FLOW: null
  OUTFALL_TO: null
  NODE1: null
  NODE2: null
  OWNER: null
  MAINTAINER: null
  CATEGORY: null
  INSP_DATE: null
  INSP_TIME: null
  INSP_TYPE: null
  INSP_BY: null
  CONDITION: null
  BLOCKAGE: null
  ESTIMATE: null
  HOMEMADE: null
  EXCEPTIONS: 0
  NOTES: null
  DESCRIPT: null
  SERV_UNIT: null
  BLOCK: null
  WATERSHED: null
  TTRRSS: null
  SUBAREA: null
  SOURCE: null
  INSTALL_DATE: null
  MS4: null
  ADD_DATE: null
  ADD_BY: null
  MOD_DATE: null
  MOD_BY: null
  MOD_WHY: null
  EXP_DATE: null
  EXP_BY: null
  EXP_WHY: null
  INSP_FLAG: null
  MEDIAKEY: null
  UNITNUM: null
  INSPUNIQUE: null
  WO_NUM: null
  ENABLED: 1
  created_user: null
  created_date: null
  last_edited_user: null
  last_edited_date: null
  MID_X: null
  
  Drawing Tool: esriFeatureEditToolLine

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

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