20241206
14210600
1.0
FALSE
swNodes
002
779649.549864
2069982.641263
770202.448536
2046650.550190
1
Projected
GCS_North_American_1983
Linear Unit: Foot_US (0.304801)
NAD_1983_StatePlane_North_Carolina_FIPS_3200_Feet
<ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/10.7'><WKT>PROJCS["NAD_1983_StatePlane_North_Carolina_FIPS_3200_Feet",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",2000000.002616666],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-79.0],PARAMETER["Standard_Parallel_1",34.33333333333334],PARAMETER["Standard_Parallel_2",36.16666666666666],PARAMETER["Latitude_Of_Origin",33.75],UNIT["Foot_US",0.3048006096012192],AUTHORITY["EPSG",2264]]</WKT><XOrigin>-121841899.99576168</XOrigin><YOrigin>-93658999.996060342</YOrigin><XYScale>1599.9999999999948</XYScale><ZOrigin>-9999</ZOrigin><ZScale>6400</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.020000000000000066</XYTolerance><ZTolerance>0.02</ZTolerance><MTolerance>0.02</MTolerance><HighPrecision>true</HighPrecision><WKID>102719</WKID><LatestWKID>2264</LatestWKID></ProjectedCoordinateSystem>
20231212
08045600
20231212
08045600
ISO 19139 Metadata Implementation Specification
500000
5000
ISO19139
Version 6.2 (Build 9200) ; Esri ArcGIS 10.7.1.11595
swNodes
Stormwater Structures
2024-01-01T00:00:00
-9999.000000
563.090000
1
-83.302927
-78.753089
39.368506
35.796704
A point feature class representing features such as inlets, outlets, riser pipes, headwalls, and other single-location features.
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>RELEASE 202311 </SPAN></P><P><SPAN>Provides accurate location and attributes for all closed system inlet and outlet structures such as catch basins, drop inlets, and end sections. </SPAN></P><P><SPAN><SPAN>This feature class is a member of the storm water geometric network.</SPAN></SPAN></P></DIV></DIV></DIV>
PWGBIS
Stormwater
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Private Use Policy: </SPAN><SPAN /></P><P><SPAN>No use for resale or commercial purposes, as defined in North Carolina General Statute Chapter 132-10, is permitted. </SPAN></P><P><SPAN>Commercial Use Policy:</SPAN><SPAN /></P><P><SPAN>The purpose of this Policy is to address GIS data distribution requests by an individual or organization that intends to use Durham's GIS data for commercial purposes. This Policy includes product availability,distribution methods, and product costs. The requester is required to use a GIS Data Distribution Application for Commercial Use. None of the GIS data purchased through this Policy shall be published by the requestor without the City's explicit written consent, nor shall the requestor permit any other party to publish the data. For example, to make this data available over the Internet is prohibited as a form of publication. This Policy shall apply to all GIS Data used for commercial purposes.</SPAN></P><P><SPAN /></P></DIV></DIV></DIV>
external
72692fdc70af22892b601118cbd43ad4
Public Works Gegoraphic and Business Information Systems
City of Durham
101 City Hall Plaza
Durham
NC
27701
PWGIS@durhamnc.gov
US
True
Public Works Gegoraphic and Business Information Systems
Feature Class
dataset
EPSG
6.12(9.0.0)
87896
Simple Junction
TRUE
87896
TRUE
FALSE
None
swNodes
Feature Class
87896
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
Esri
Sequential unique whole numbers that are automatically generated.
FACILITYID
Facility ID
String
20
0
0
The unique identification number assigned to the structure.
Automated (Attribute Assistant).
LEGACYID
Legacy ID
String
20
0
0
Previous FACILITYID. Allows users to find work orders and other records that are associated with feature
Left <NULL> when feature created.
LOCATION
Location
String
100
0
0
Nearest address
Site Address in Address Point or Parcel layer .
DEPTH
Depth
Double
8
38
8
Difference between the z/elevation of the top of the structure and the invert.
Z (RIM) - Invert Elevation (INV OUT). If either value is not available leave <NULL>. For end sections and headwalls value can be 0.
INVERT
Invert
Double
8
38
8
Elevation of the bottom of the structure.
‘INV OUT’ on as-built Plan-Profile sheets. Can never be 0. For end sections and headwalls value the INVERT may match the Z if the structure was shot at the bottom.
RISKSCORE
Risk Score
Double
8
38
8
Risk of failure score for individual feature. Part of asset management
Provided via Stormwater Risk Model Script.
X
X
Double
8
38
8
The easting (X-coordinate) of the structure.
Only completed if XY is provided from digital or GPS data.
.01
Y
Y
Double
8
38
8
The northing (Y-coordinate) of the structure.
Only completed if XY is provided from digital or GPS data.
.01
Z
Z
Double
8
38
8
Elevation of the top of the structure.
AKA ‘RIM’ on Plan-Profile sheets. Can never be 0. For end sections and headwalls value the INVERT may match the Z if the structure was shot at the bottom.
.01
COMMENT
Comment
String
255
0
0
Text field to store notes about unusual attributes or qualities.
Not typically used. Comments should be preceded by date and last name of editor.
CREATEDATE
Create Date
Date
8
0
0
Date that the feature was created in the GIS.
Automated (Attribute Assistant).
EDITEDBY
Edited By
String
16
0
0
Username for editor who last edited the feature.
Automated (Attribute Assistant).
INSTALLDATE
Install Date
Date
8
0
0
An estimate of when the structure was built.
The date should be pulled from the “DATEBUILT” field in the project tracking layer. This date is derived from the date of the first as-built review in the as-built database.
ENABLED
Enabled
SmallInteger
2
5
0
Indicates whether the feature participates in the geometric network
True.
0
False
1
True
MATERIAL
Material
String
16
0
0
Type of material that the structure or pipe is made from.
Most new structures are made of precast concrete, but refer to the as-built construction drawing details to confirm they are not brick.
BRICK
Brick
CEMENT
Cement
CLAY
Clay
CONCRETE
Concrete
CONCRETE-BLOCK
Concrete Block
CONCRETE-REINF
Reinforced Concrete
HDPE
HDPE (High-density polyethylene)
HDPE-CORRUGATED
Corrugated HDPE (High-density polyethylene)
IRON
Iron
IRON-DUCTILE
Ductile Iron
METAL
Metal
METAL-CORRUGATED
Corrugated Metal
PRECAST
Precast Concrete
PVC
PVC (polyvinyl chloride)
RUBBLE MASONRY
Rubble Masonry
STONE
Stone
UNKNOWN
Unknown
WOOD
Wood
CONCRETE-UNREINF
Unreinforced Concrete
FORM
Form
String
16
0
0
Shape of the structure or pipe.
These are dependent upon feature the feature TYPE.
ARCH
Arch
BELL
Bell
BOX
Box
CIRCULAR
Circular
CUT
Cut
ELLIPTICAL
Elliptical
FLARED
Flared
RECTANGULAR
Rectangular
SOCKET
Socket
SQUARE
Square
L-WALL
L-Wall
MITERED
Mitered
VERTICAL
Vertical
WING WALL
Wing Wall
STATUS
Status
String
16
0
0
Indicates whether the feature is currently in use.
Editor sets value to Active.
ABANDONED
Abandoned
ACTIVE
Active
ASSUMED
Assumed
INACTIVE
Inactive
TYPE
Type
String
16
0
0
Specific structure or pipe within the larger feature class. Based on a domain for the feature class.
There are different types of inlet and outlet features that make up the stormwater system and is determined via field work, as-builts, or DS Reviews.
COMBINATION INLET
An inlet built into the curb and gutter section of a street that includes a both a drop inlet like grate and a curb inlet like throat opening in the face of the curb.
CURB INLET
An inlet built into the curb face of a street. It does not include a grate, but may have a very long throat.
DROP INLET
An inlet that is flush with the ground and consists of a large grate.
END SECTION
End sections represent the terminal end of a pipe or they may be a specifically designed structure, such as a flared end section. These locations represent points at which the “open” stormwater system (i.e. a stream or ditch) connects to the “closed” system.
FILTERRA
Essentially a large curb inlet with a precast box which contains engineered soil material to filter incoming stormwater. Filtered water is piped to a nearby catch basin (the downstream catch basin also serves as an overflow device).
HATCH
An access structure associated specifically with underground SCMs. A hatch allows access to the SCM and is a large, metal door flush with the ground.
HEADWALL
Headwalls represent the terminal end of a pipe. These locations represent points at which the “open” stormwater system (i.e. a stream or ditch) connects to the “closed” system. Headwalls come in several forms including the wing wall, vertical, and L-wall. Headwalls are often, but not always, associated with large culverts and SCMs.
JUNCTION BOX
Structure where two or more pipes meet. Junction boxes are not accessible and new construction will not include any “true” junction boxes. Any junction box that is accessible through a manhole should be coded as a manhole.
MANHOLE
Junction boxes that can be accessed through a manhole where two or more pipes connect. If the digital submittal data indicates that they have installed “junction boxes” check the imagery and the construction drawing details if these are actually manholes and, if so, set the Type to Manhole.
MINOR DRAIN
Minor drains will typically be connected to “minor pipes.” Attribution of minor drains is minimal and minor drains are only included in the stormwater system if (a) the data is provided by the engineer as part of the digital submittal or (b) there is a special request within the Public Works Department to include this infrastructure based existing drawings or field work.
PIPE JUNCTION
This is an implied junction where two pipes are connected without a standard structure.
POSSIBLE JUNCTION
This type only used when the nature of the connection between two pipes has not yet been determined.
RISER PIPE
An inlet structure that is designed to remove water from a stormwater control measure. Typically, a riser pipe has a small diameter opening near the base so that during lower flows water leaves the SCM slowly, but during higher volumes more water can leave the SCM. Riser Pipes are typically connected to a 15- or 18-inch reinforced concrete pipe that terminates with an end section. Riser pipes can be found in dry ponds, wet ponds, constructed wetlands, and bio-retention ponds.
SLAB INLET
This feature consists of a large inlet covered by a slab (typically concrete) elevated above the surface by several inches. Stormwater flows across the ground and enters the inlet through the gap, a.k.a. throat, between the slab and the ground.
WEIR BOX
A structure designed to control the rate at which stormwater is released from the upstream portion of a site and is found in conjunction with related SCM infrastructure such as an underground storage device or level spreader. These structures have an interior wall (i.e. the “wier”) which serves If the water level is lower than the wall, then the stormwater exits slowly through a small opening at the bottom of the wall. If the volume of water is in excess of the interior wall, then the excess volume flows over the wall and exits the system more rapidly.
TASK
Task
String
16
0
0
The primary task of the TYPE of structure.
TASK values are dependent upon the TYPE and context of the structure.
ACCESS
Access
BMP
BMP (Best management Practice)
INLET
Inlet
JUNCTION
Junction
OUTLET
Outlet
ADMINAREA
Administrative Area
String
16
0
0
Indicates whether the feature is inside or outside the city limits.
City Limits layer. County assets are not mapped.
CITY
City
COUNTY
County
ACCEPTDATE
Accept Date
Date
8
0
0
Date that infrastructure is accepted by City Council for maintenance. For private infrastructure use date that mylars are delivered to PWGIS.
Updated when mylars are delivered to PWGIS. Left <NULL> when feature is created.
OPERATIONALAREA
Operational Area
String
100
0
0
Indicates which watershed the feature is in.
Name in swStormSewershed layer
BRIER CREEK
Brier Creek
CROOKED CREEK
Crooked Creek
ELLERBE CREEK
Ellerbe Creek
ENO RIVER
Eno River
FLAT RIVER
Flat River
LICK CREEK
Lick Creek
LITTLE CREEK
Little Creek
LITTLE LICK CREEK
Little Lick Creek
LITTLE RIVER
Little River
MORGAN CREEK
Morgan Creek
MUD CREEK
Mud Creek
NEW HOPE CREEK
New Hope Creek
NORTHEAST CREEK
Northeast Creek
PANTHER CREEK
Panther Creek
SANDY CREEK
Sandy Creek
SOUTH FORK
South Fork
STIRRUP IRON CREEK
Stirrup Iron Creek
THIRD FORK CREEK
Third Fork Creek
BARTON CREEK
Barton Creek
CAMP CREEK
Camp Creek
DEEP CREEK
Deep Creek
FALLS LAKE
Falls Lake
JORDAN LAKE
Jordan Lake
KNAP OF REEDS CREEK
Knap of Reeds Creek
LITTLE RIVER (UPPER)
Little River (upper)
SYCAMORE CREEK
Sycamore Creek
CREATEDBY
Created By
String
16
0
0
Username for editor who created the feature.
Automated (Attribute Assistant).
OWNER
Owner
String
16
0
0
Entity that is responsible for maintaining the structure.
Dependent on road owner and parcel owner.
CITY
City
CITY-PENDING
Pending City Acceptance
CITY-ROW
City Right-Of-Way
COUNTY
Durham County
DOT-ROW
NCDOT
PRIVATE
Private
STATE
State
INLETDIM
Inlet Dimensions
String
20
0
0
Dimensions of the top of the structure where the stormwater enters
Fieldwork only. Otherwise left <NULL>.
BOXDIM
Box Dimensions
String
20
0
0
Dimensions of the below-ground box.
Field work only. Otherwise <NULL>.
PHOTOPATH
Photo Path
String
255
0
0
UNC Path to the photo of the infrastructure.
Only structures added as part of the original inventory have photos.
PHOTOURL
Photo URL
String
255
0
0
URL to the photo of the infrastructure
Only structures added as part of the original inventory have photos.
THROATZ
Throat Z
Double
8
38
8
Absolute elevation at the base of the throat of the structure.
Calculate as Z – THROATROD and valid only for certain types of structures. Otherwise <NULL>.
THROATROD
Throat Rod
Double
8
38
8
Distance from the GPS shot to the lowest elevation of the throat opening.
Valid only for structures with throat openings such as COMBINATION INLETS, CURB INLETs, and SLAB INLETs. Otherwise <NULL>.
PROJECTID
Project ID
String
10
0
0
Unique ID associated with the project in the project polygon layer.
ProjectID in Project polygon. Existing features that are drawn in based on information from a new as-built get a PROJECTID of 0000.00.
ASBUILTID
As-Built ID
String
18
0
0
Unique ID for feature found on the as-built.
Plan-Profile sheet.
THROATDIM
Throat Dimensions
String
20
0
0
The dimensions of a curb or catch basin opening.
Field work only. Otherwise <NULL>.
EDITDATE
Edit Date
Date
8
0
0
Date that the feature was last edited.
Automated (Attribute Assistant).
GlobalID
GlobalID
GlobalID
38
0
0
Needed for replicated feature classes. Assigned by Database.
Automated (SDE).
SOURCE
Source
String
32
0
0
Primary source for the attributes.
Source used (digital submittal, as-built, field visit, construction drawing, etc.).
SOURCECOMMENT
Source Comment
String
255
0
0
Text field to store notes about unusual attributes or qualities.
Not typically used. Comments should be preceded by date and last name of editor (20231201-Caddell: note).
SOURCEXYZ
Source XYZ
String
32
0
0
If X,Y, and Z data provided, field should indicate source for these data.
Completed only if field-verified XYZ data available.
SOURCEXYZDATE
Source XYZ Date
Date
8
0
0
If X,Y, and Z data are collected by PWGBIS or another group, field indicates collection date.
Date that XYZ data collected.
CONDITIONSCORE
Condition Score
Integer
4
10
0
Condition score for individual feature. Part of asset management.
Determined via ITPipes.
CONDITIONDATE
Condition Date
Date
8
0
0
Date condition score was determined. Part of asset management.
Determined via ITPipes.
SHAPE
SHAPE
Geometry
4
0
0
Feature geometry.
Esri
Coordinates defining the features.
COMMENTS
==========
Entries into the comment attributes fields usually following the following format: the comment
begins with a date in YYYYMMDD format, followed by a dash, then followed by the last name
of the user that entered the comment.
ASSET MANAGEMENT ATTRIBUTES
===============================
These include the FACILITYID, LEGACYID, LOCATION, and the ADMINAREA fields. FACILITYID,
LEGACYID, and LOCATION are used by (and required) by the CityWorks system.
The FACILITYID is a unique 5-digit identification number assigned to all structures. This number is sequential and new structures are simply assigned the next number
in series.
LEGACYID values are currently coded as follows: All identification numbers assinged
during the vendor derived field inventory period have been moved into the LEGACYID
field (these numbers are often still visible on some structures).
Currently the county-wide parcel layer is used to assess the location of the structure
and determine the code assigned to the ADMINAREA field. The accuracy of the assigned
code is therefore subject to the accuracy of the parcel layer.
STRUCTURE CLASSIFICATION
========================
Structures are classified using the TASK, TYPE, and STANDARD attributes. The TASK attribute is the most coarse classification and is used to indicate
the primary function of the structure. Structures classified as "END SECTION"
will be classified as either INLET or OUTLET depending upon whether water enters
or leaves the closed system at their location. "RISER PIPE" and "WIER BOX" types
are coded as "BMP".
The TYPE field is used to further identify the structure. The exact descriptions
can be found above. We avoid the term "CATCH BASIN" since that is too generic,
although it's use is very common.
STRUCTURE PHYSICAL ATTRIBUTES
=============================
CONDITION INFORMATION
=====================
This condition information is a simple visual field evaluation of the current structure
condition. For as-built structures and those submitted via digital submission an assumed
condition is assigned. Condition information is addressed in three areas: access, physical condition of the
structure, and any material within the structure.
Missing grates and lids are not tracked but are resolved immediately since they present
a safety hazard.
EDIT TRACKING
============= The CREATEDATE, MODIFYDATE, and EDITEDBY fields are used for internal tracking of changes
to the database.
20231212
Public Works Gegoraphic and Business Information Systems
City of Durham
101 City Hall Plaza
Durham
NC
27701
PWGIS@durhamnc.gov
US