Name: swJunctions

Display Field: ASSETTYPE

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Hillsborough County categorizes JUNCTIONS into 2 distinct subtypes.JUNCTION BOX: A vault where pipes connect to accommodate changes in pipe size or direction, or else to provide access to the stormwater system. They are not designed to allow the input of stormwater directly from the surface. The shape of the vault can be round or rectangular in nature. Whether or not the junction box has manhole access (this includes both the metal lids and when the entire top slab is removable).OTHER CONNECTION POINT: Fittings, cleanouts, reducers, etc. There is no enclosed structure associated with it. To be used when you need to change direction or otherwise need to indicate a different main or underdrain due to attribute changes. Typically, this type of asset will be digitized off of plans or at least in reference to plans as it is often something that is not visible from the ground. For instance, clean-outs would only apply to Other Connection Points, and would mostly be used for clean-outs found in conjunction for underdrains. Clean-outs provide access points for maintenance.

Copyright Text: Hillsborough County, FL

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 24000.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: 446204.31363232806
YMin: 1211434.5240204036
XMax: 638254.7956723273
YMax: 1396151.6595066562
Spatial Reference: 102659  (2237)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: SUBTYPE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [130, 130, 130, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Default Label: <all other values>
UniqueValueInfos:
• Value: 2
  Label: JUNCTION BOX
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [252, 194, 234, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: 3
  Label: OTHER CONNECTION POINT
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [187, 252, 179, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
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: SUBTYPE

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ASSETTYPE ( type: esriFieldTypeString, alias: ASSETTYPE, length: 24 )
• UNITID ( type: esriFieldTypeString, alias: UNITID, length: 16 )
• JUNCTYPE ( type: esriFieldTypeString, alias: JUNCTION TYPE, length: 8 )
• JUNCDESC ( type: esriFieldTypeString, alias: DESCRIPTION, length: 6 )
• MATERIAL ( type: esriFieldTypeString, alias: MATERIAL, length: 6 )
• MHACCESS ( type: esriFieldTypeString, alias: MANHOLE ACCESS, length: 3 , Coded Values: [Y: YES] , [N: NO] , [UNK: UNKNOWN] )
• ATGRADE ( type: esriFieldTypeString, alias: ATGRADE, length: 8 , Coded Values: [Y: Yes] , [N: No] )
• PIPES ( type: esriFieldTypeSmallInteger, alias: NUMBER OF PIPES , Range: [0, 20] )
• 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... )
• 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... )
• INSP_DATE ( type: esriFieldTypeDate, alias: LAST INSPECTION DATE, length: 8 )
• INSP_TIME ( type: esriFieldTypeString, alias: LAST INSPECTION TIME, length: 10 )
• INSP_BY ( type: esriFieldTypeString, alias: INSPECTED BY, length: 30 , Coded Values: [1: ACEVEDOR] , [2: BACILAV] , [3: BROOMW] , ...13 more... )
• INSP_TYPE ( type: esriFieldTypeString, alias: INSP_TYPE, length: 8 , Coded Values: [NPDES: SCHEDULED NPDES] , [OPS: OPERATIONS] , [INVEST: STORMWATER INVESTIGATIONS] , ...1 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] )
• CONFLICT ( type: esriFieldTypeString, alias: CONFLICT, 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... )
• SUBTYPE ( type: esriFieldTypeInteger, alias: SubType )
• SYMBROTATE ( type: esriFieldTypeSmallInteger, alias: SYMBROTATE , Range: [0, 360] )
• MEDIAKEY ( type: esriFieldTypeInteger, alias: MEDIAKEY )
• INSP_FLAG ( type: esriFieldTypeString, alias: INSP_FLAG, length: 5 , Coded Values: [NA: NOT APPLICABLE] , [NINSP: NEEDS INSPECTION] , [INSP: INSPECTED] )
• 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] )
• ANCILLARYROLE ( type: esriFieldTypeSmallInteger, alias: AncillaryRole , Coded Values: [0: None] , [1: Source] , [2: Sink] )
• 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 )
• UnderDrains ( type: esriFieldTypeString, alias: UnderDrains, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• Insp_zone ( type: esriFieldTypeString, alias: Insp Zone, length: 75 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• SHAPE ( type: esriFieldTypeGeometry, alias: Shape )

Types:

ID: 2
Name: JUNCTION BOX
Domains:
• JUNCDESC:
  Coded Values: [CLN: CLEAN-OUT] , [FIT: FITTING] , [STAND: STANDARD]
• MATERIAL:
  Coded Values: [CONC: POURED CONCRETE] , [BRK: BRICK] , [FIB: FIBERGLASS] , ...1 more...
• MHACCESS:
  Inherited
• ATGRADE:
  Inherited
• PIPES:
  Coded Values: [-98: UNKNOWN] , [9: 9] , [1: 1] , ...19 more...
• OWNER:
  Inherited
• MAINTAINER:
  Inherited
• CATEGORY:
  Inherited
• CONDITION:
  Inherited
• BLOCKAGE:
  Inherited
• INSP_BY:
  Inherited
• INSP_TYPE:
  Inherited
• ESTIMATE:
  Inherited
• HOMEMADE:
  Inherited
• CONFLICT:
  Inherited
• EXCEPTIONS:
  Inherited
• SERV_UNIT:
  Inherited
• WATERSHED:
  Inherited
• SOURCE:
  Inherited
• MS4:
  Inherited
• ADD_BY:
  Inherited
• MOD_BY:
  Inherited
• MOD_WHY:
  Inherited
• EXP_BY:
  Inherited
• EXP_WHY:
  Inherited
• SYMBROTATE:
  Inherited
• INSP_FLAG:
  Inherited
• ENABLED:
  Inherited
• ANCILLARYROLE:
  Inherited
• UnderDrains:
  Inherited

---

ID: 3
Name: OTHER CONNECTION POINT
Domains:
• JUNCDESC:
  Coded Values: [CLN: CLEAN-OUT] , [FIT: FITTING]
• MATERIAL:
  Coded Values: [CONC: POURED CONCRETE] , [BRK: BRICK] , [FIB: FIBERGLASS] , ...1 more...
• MHACCESS:
  Inherited
• ATGRADE:
  Inherited
• PIPES:
  Coded Values: [-98: UNKNOWN] , [9: 9] , [1: 1] , ...19 more...
• OWNER:
  Inherited
• MAINTAINER:
  Inherited
• CATEGORY:
  Inherited
• CONDITION:
  Inherited
• BLOCKAGE:
  Inherited
• INSP_BY:
  Inherited
• INSP_TYPE:
  Inherited
• ESTIMATE:
  Inherited
• HOMEMADE:
  Inherited
• CONFLICT:
  Inherited
• EXCEPTIONS:
  Inherited
• SERV_UNIT:
  Inherited
• WATERSHED:
  Inherited
• SOURCE:
  Inherited
• MS4:
  Inherited
• ADD_BY:
  Inherited
• MOD_BY:
  Inherited
• MOD_WHY:
  Inherited
• EXP_BY:
  Inherited
• EXP_WHY:
  Inherited
• SYMBROTATE:
  Inherited
• INSP_FLAG:
  Inherited
• ENABLED:
  Inherited
• ANCILLARYROLE:
  Inherited
• UnderDrains:
  Inherited

---

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

  Iteminfo   Thumbnail   Metadata