Street Centerlines and Nodes
Last updated
Last updated
Street centerlines are lines that represent a network of streets
They are aligned generally to the center of a street
They are meant to model the street network and thus have no width or area
They have a length component
Street nodes are the endpoints of a street centerline and represent intersections
A node shared among multiple intersecting street segments is an intersection
Each node and centerline segment will have a unique Centerline Node Network (CNN) identifier
The collection of Centerline Node Network identifiers are collectively known as "CNNs"
Each segment sits between two nodes
A segment ends where it intersects with another segment OR at the physical end of a street (a dead end)
Some segments will start and end at the same node
Each segment and node has a CNN identifier pictured above
Segments share the same node where they intersect
Node ID 25352000 in the middle is shared by 6 segments
The management of streets falls to different jurisdictions within the City
Public Works manages and maintains the majority of streets within the City
The remaining are managed and maintained by other entities like Caltrans, Presidio Trust National Park and Parks & Recreation, a summary of miles of streets by jurisdiction is available on the open data portal
Basemap data including streets from various jurisdictions is maintained by Public Works
Centerline Node Network IDs (CNNs) are referenced in many datasets throughout the City (including but not limited to permits and inspections, project management and asset management systems)
Used to enhance data by adding location attributes, allowing disparate datasets to be mapped as well as compared for analysis
To model the transportation network
Every centerline and node will have a unique Centerline Node Network (CNN) identifier
cnn
as a number
cnntext
as a text string
CNN IDs (CNN) may be used in secondary columns as reference
For example:
f_node_cnn
and t_node_cnn
to indicate from and to nodes
When referencing a CNN, include clear definition in the data dictionary, and include cnn
in the column name
Valid IDs are in the reference datasets below
Dataset
Description and Constraints
Reference Columns
A list of street segments and intersections sorted by street name and ascending address number. This data set is based on the City's GIS basemap and contains CNN id numbers for each record.
cnn
as number
For segments: from_cnn
and to_cnn
define the node IDs at each end
A geographic reference of the all basemap streets including centerline node network identifiers and jurisdictions
cnn
as number
cnntext
as text
f_node_cnn
as the starting (from) node ID
t_node_cnn
as the ending (to) node ID
A list of Street Segment and Intersection (CNN) changes including new, dropped, realigned, divided and split records.
oldcnn
as number
newcnn
as number