Baselight

Street Network Database SND

City of Seattle

@usgov.city_of_seattle_street_network_database_snd_1712b

Loading...
Loading...

About this Dataset

Street Network Database SND

The pathway representation consists of segments and intersection elements. A segment is a linear graphic element that represents a continuous physical travel path terminated by path end (dead end) or physical intersection with other travel paths. Segments have one street name, one address range and one set of segment characteristics. A segment may have none or multiple alias street names. Segment types included are Freeways, Highways, Streets, Alleys (named only), Railroads, Walkways, and Bike lanes. SNDSEG_PV is a linear feature class representing the SND Segment Feature, with attributes for Street name, Address Range, Alias Street name and segment Characteristics objects. Part of the Address Range and all of Street name objects are logically shared with the Discrete Address Point-Master Address File layer.

Appropriate uses include: Cartography - Used to depict the City's transportation network location and connections, typically on smaller scaled maps or images where a single line representation is appropriate. Used to depict specific classifications of roadway use, also typically at smaller scales. Used to label transportation network feature names typically on larger scaled maps. Used to label address ranges with associated transportation network features typically on larger scaled maps. Geocode reference - Used as a source for derived reference data for address validation and theoretical address location Address Range data repository - This data store is the City's address range repository defining address ranges in association with transportation network features. Polygon boundary reference - Used to define various area boundaries is other feature classes where coincident with the transportation network. Does not contain polygon features. Address based extracts - Used to create flat-file extracts typically indexed by address with reference to business data typically associated with transportation network features. Thematic linear location reference - By providing unique, stable identifiers for each linear feature, thematic data is associated to specific transportation network features via these identifiers. Thematic intersection location reference - By providing unique, stable identifiers for each intersection feature, thematic data is associated to specific transportation network features via these identifiers. Network route tracing - Used as source for derived reference data used to determine point to point travel paths or determine optimal stop allocation along a travel path. Topological connections with segments - Used to provide a specific definition of location for each transportation network feature. Also provides a specific definition of connection between each transportation network feature. (defines where the streets are and the relationship between them ie. 4th Ave is west of 5th Ave and 4th Ave does intersect with Cherry St) Event location reference - Used as source for derived reference data used to locate event and linear referencing.

Data source is TRANSPO.SNDSEG_PV. Updated weekly.
Organization: City of Seattle
Last updated: 2025-02-28T23:30:47.328330
Tags: seattle-gis-open-data, snd, streets, transportation

Tables

Table 1

@usgov.city_of_seattle_street_network_database_snd_1712b.table_1
  • 2.29 MB
  • 34398 rows
  • 38 columns
Loading...

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "f_intr_id" BIGINT,
  "t_intr_id" BIGINT,
  "snd_id" BIGINT,
  "snd_feacode" BIGINT,
  "citycode" BIGINT,
  "stname_id" BIGINT,
  "st_code" BIGINT,
  "arterial_code" BIGINT,
  "segment_type" BIGINT,
  "agency_code" BIGINT,
  "access_code" BIGINT,
  "divided_code" BIGINT,
  "structure_type" BIGINT,
  "legalloc_code" BIGINT,
  "vehicle_use_code" BIGINT,
  "gis_seg_length" DOUBLE,
  "l_adrs_from" BIGINT,
  "l_adrs_to" BIGINT,
  "r_adrs_from" BIGINT,
  "r_adrs_to" BIGINT,
  "ord_pre_dir" VARCHAR,
  "ord_street_name" VARCHAR,
  "ord_street_type" VARCHAR,
  "ord_suf_dir" VARCHAR,
  "ord_stname_concat" VARCHAR,
  "l_city" VARCHAR,
  "l_state" VARCHAR,
  "l_zip" BIGINT,
  "r_city" VARCHAR,
  "r_state" VARCHAR,
  "r_zip" BIGINT,
  "sndseg_update" VARCHAR,
  "compkey" BIGINT,
  "comptype" BIGINT,
  "unitid" DOUBLE,
  "unitid2" DOUBLE,
  "shape_length" DOUBLE
);

Share link

Anyone who has the link will be able to view this.