View In:   ArcGIS Online Map Viewer

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

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 24000.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: 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: false
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: SUBTYPE

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ASSETTYPE ( type: esriFieldTypeString, alias: ASSETTYPE, editable: true, nullable: true, length: 24, defaultValue: JUNCTION, modelName: ASSETTYPE )
• UNITID ( type: esriFieldTypeString, alias: UNITID, editable: true, nullable: true, length: 16, defaultValue: null, modelName: UNITID )
• JUNCTYPE ( type: esriFieldTypeString, alias: JUNCTION TYPE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: JUNCTYPE )
• JUNCDESC ( type: esriFieldTypeString, alias: DESCRIPTION, editable: true, nullable: true, length: 6, defaultValue: null, modelName: JUNCDESC )
• MATERIAL ( type: esriFieldTypeString, alias: MATERIAL, editable: true, nullable: true, length: 6, defaultValue: null, modelName: MATERIAL )
• MHACCESS ( type: esriFieldTypeString, alias: MANHOLE ACCESS, editable: true, nullable: true, length: 3, defaultValue: null, modelName: MHACCESS , Coded Values: [Y: YES] , [N: NO] , [UNK: UNKNOWN] )
• ATGRADE ( type: esriFieldTypeString, alias: ATGRADE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ATGRADE , Coded Values: [Y: Yes] , [N: No] )
• PIPES ( type: esriFieldTypeSmallInteger, alias: NUMBER OF PIPES, editable: true, nullable: true, defaultValue: null, modelName: PIPES , Range: [0, 20] )
• 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... )
• 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... )
• 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_BY ( type: esriFieldTypeString, alias: INSPECTED BY, editable: true, nullable: true, length: 30, defaultValue: null, modelName: INSP_BY , Coded Values: [1: ACEVEDOR] , [2: BACILAV] , [3: BROOMW] , ...13 more... )
• 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... )
• 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] )
• CONFLICT ( type: esriFieldTypeString, alias: CONFLICT, editable: true, nullable: true, length: 1, defaultValue: null, modelName: CONFLICT , 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... )
• SUBTYPE ( type: esriFieldTypeInteger, alias: SubType, editable: true, nullable: true, defaultValue: 2, modelName: SubType )
• SYMBROTATE ( type: esriFieldTypeSmallInteger, alias: SYMBROTATE, editable: true, nullable: true, defaultValue: null, modelName: SYMBROTATE , Range: [0, 360] )
• MEDIAKEY ( type: esriFieldTypeInteger, alias: MEDIAKEY, editable: true, nullable: true, defaultValue: null, modelName: MEDIAKEY )
• 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] )
• 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] )
• ANCILLARYROLE ( type: esriFieldTypeSmallInteger, alias: AncillaryRole, editable: true, nullable: true, defaultValue: 0, modelName: AncillaryRole , Coded Values: [0: None] , [1: Source] , [2: Sink] )
• 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 )
• UnderDrains ( type: esriFieldTypeString, alias: UnderDrains, editable: true, nullable: true, length: 1, defaultValue: null, modelName: UnderDrains , Coded Values: [Y: Yes] , [N: No] )
• 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 )

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
Templates:
• Name: JUNCTION BOX
  Description:
  Prototype:
  Insp_zone: null
  UnderDrains: null
  ASSETTYPE: JUNCTION
  UNITID: null
  JUNCTYPE: JUNC
  JUNCDESC: null
  MATERIAL: null
  MHACCESS: null
  ATGRADE: null
  PIPES: null
  OWNER: null
  MAINTAINER: null
  CATEGORY: null
  CONDITION: null
  BLOCKAGE: null
  INSP_DATE: null
  INSP_TIME: null
  INSP_BY: null
  INSP_TYPE: null
  ESTIMATE: null
  HOMEMADE: null
  CONFLICT: 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
  SUBTYPE: 2
  SYMBROTATE: null
  MEDIAKEY: null
  INSP_FLAG: null
  UNITNUM: null
  INSPUNIQUE: null
  WO_NUM: null
  ENABLED: 1
  ANCILLARYROLE: 0
  created_user: null
  created_date: null
  last_edited_user: null
  last_edited_date: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

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
Templates:
• Name: OTHER CONNECTION POINT
  Description:
  Prototype:
  Insp_zone: null
  UnderDrains: null
  ASSETTYPE: JUNCTION
  UNITID: null
  JUNCTYPE: OTHR
  JUNCDESC: null
  MATERIAL: null
  MHACCESS: null
  ATGRADE: null
  PIPES: null
  OWNER: null
  MAINTAINER: null
  CATEGORY: null
  CONDITION: null
  BLOCKAGE: null
  INSP_DATE: null
  INSP_TIME: null
  INSP_BY: null
  INSP_TYPE: null
  ESTIMATE: null
  HOMEMADE: null
  CONFLICT: 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
  SUBTYPE: 3
  SYMBROTATE: null
  MEDIAKEY: null
  INSP_FLAG: null
  UNITNUM: null
  INSPUNIQUE: null
  WO_NUM: null
  ENABLED: 1
  ANCILLARYROLE: 0
  created_user: null
  created_date: null
  last_edited_user: null
  last_edited_date: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

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