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

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: 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: false
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: true
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: null

Fields:

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

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata