View In:
ArcGIS Online Map Viewer
Name: MTA.signals
Display Field: CNN
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description: | A. PURPOSE | This dataset serves as an inventory of traffic signal and related equipment.| B. METHODOLOGY | N/A| C. UPDATE FREQUENCY | Signals Access database updated regularly (weekly, or quarterly) based on SRC work orders returned to date. GIS file updated quarterly. | D. OTHER CRITICAL INFO | Attribute data primarily maintained in the Access database. Spatial data exports are sourced from the Access database. To query for TSP (Transit Signal Prioritization), load this query into the "Definition Query" tab under Properties: \\mtanas\sfmtagis\04_GeoTools\Queries\TSP.exp| E. ATTRIBUTES |CNN: San Francisco’s street centerline network unique ID If there is more than one type of equipment at an intersection or mid-block segment, the unique ID will be based on the CNN plus 1 or 2;STREET1: Cross street #1;STREET2: Cross street #2;STREET3: Cross street #3;STREET4: Cross street #4;SUP_DIST: Supervisorial district(s);SIG_NUM: Maintenance field for Traffic Signal Shop;TYPE: Type of equipment present at this location--SIGNAL-Traffic signal,FLASHER- Traffic signal that is always on flashing mode,BEACON-Flashing yellow warning light,PENDING- Pending signal location, programmed and/or under construction,FUTURE- Candidate intersection for new signals contract, not yet funded,CALTRANS- Traffic Signal maintained and operated by the State,Others- DALY CITY, LIGHTED CROSSWALK, MESSAGE SIGN, LANE CONTROL, MASTER, NEW BEACON;IC_MAKE: Manufacturer of traffic signal controller;MODEL: Model of traffic signal controller;CABINET_SI: Size and type of traffic signal controller cabinet;SYSTEM_NUM: Number indicating to which system a signal belongs;MASTER: Identifies location of system master or TBC system reference intersection;BBS: Indicates presence of battery backup system (BBS);VEH_ACTUATED: Indicates presence and type of vehicle detection;PED_SIGNAL: Indicates presence of pedestrian signals--ALL- Pedestrian signals for all open crosswalks,SOME PHASES- pedestrian signals only across some crosswalks,NONE- no pedestrian signals for any crosswalks,PENDING- pending additional pedestrian signals to be installed as part of a signal project (upgrade, modification, or new signals) which is under design or construction and not yet completed;APS: Indicates presence and model of accessible pedestrian signal (APS) push buttons as well as which project the APS units were installed by;PED_ACTUATED: “YES” if intersection is pedestrian actuated either by conventional push buttons or by buttons integrated in APS units;MANUAL_CONTROL: Unknown field;TBC: Indicates presence and type of time based clock (TBC);INTERCONNECT: Type of traffic signal interconnect used for coordination;PREEMPT_PR: Indicates presence and order of priority of traffic signal preempts, including TSP (Transit Signal Prioritization);DETECTION: Type of detection used to activate traffic signal preempt;D_ATE2070: Date when traffic signal controller was upgraded to type 2070;PROJECT_NEW: Most recent project (new signals, modifications, or full upgrade) planned, pending, or under construction;PROJECT_OLD: Previous signal contract (new signals, modifications, or full upgrade) which has already been completed;YR_OF_CONTRACT: Approximate date of UPGRADED contract certification;LAST_UPGRADE: Year intersection was last upgraded (since 1990);NEW_SIGNALS: Field indicates project status for new signals project--FUTURE-Candidate intersection for new signals project, not yet funded,PENDING- Intersection under design or construction as part of new signals project, not yet completed,DONE- Construction at intersection as part of new signals project has been completed. Please note that only intersections included as part of contracts completed after 1990 are noted as “DONE”,NONE- No new signals project planned; MOD _PROJECT: Field indicates project status for signal modifications project--FUTURE- Candidate intersection for signal modifications project, not yet funded,PENDING- Intersection under design or construction as part of signal modifications project, not yet completed,DONE- Construction at intersection as part of signal modifications project has been completed. Please note that only intersections included as part of contracts completed after 1990 are noted as “DONE”,NONE- No signal modifications project planned;FULL_UPGRADE _PROJECT: Field indicates project status for full upgrade project--FUTURE- Candidate intersection for full upgrade project, not yet funded,PENDING- Intersection under design or construction as part of full upgrade project, not yet completed,DONE- Construction at intersection as part of full upgrade project has been completed. Please note that only intersections included as part of contracts completed after 1990 are noted as “DONE”, NONE- No full upgrade project planned; BEACON_FLASHER: Field indicates project status for installation of beacons and flashers--FUTURE- Candidate intersection for beacon and flashers contract, not yet funded,PENDING- Intersection under design or construction as part of beacon and flashers contract, not yet completed,DONE- Construction at intersection as part of beacon and flashers contract has been completed. Please note that only intersections included as part of contracts completed after 1990 are noted as “DONE”,NONE- No beacon and flashers contract planned;FUNDING: Source of funds used to pay for signal contract;RLCAM: “YES” if intersection has red light camera system;STARTYEAR: Year equipment (traffic signal) began operation if known;CALTRANS_ROUTE: Caltrans highway route number if applicable; CALTRANS: “X” if signals are maintained in full or in part by Caltrans;PERCENT_C: Percent of maintenance paid by Caltrans;SF: “X” if signals are maintained in part by City of San Francisco;PERCENT_SF: Percent of maintenance paid by City of San Francisco;PERCENT_PORT: Percent of maintenance paid by Port of San Francisco;LAMP_ASSGN: Maintenance field for Traffic Signal Shop;LAMP_SORT: Maintenance field for Traffic Signal Shop;SORT_ME: Maintenance field for Traffic Signal Shop
Copyright Text: | A. CUSTODIAN | Jarrett Hornbostel, jarrett.hornbostel@sfmta.com, SFMTA, Sustainable Streets, Transportation Engineering
| B. CREATED | Unknown
| C. VERSIONS |
20161222, Jarrett Hornbostel, quarterly update
201605, Jarrett Hornbostel, quarterly update, prep for MTA spatial data store
20150611, Jarrett Hornbostel, quarterly update, prep for MTA spatial data store
Default Visibility: false
MaxRecordCount: 10000
MaxSelectionCount: 0
Supported Query Formats: JSON, geoJSON, PBF
Min Scale: 0.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: -122.51105375600001
YMin: 37.708085729000004
XMax: -122.363369475
YMax: 37.818187034000005
Spatial Reference: 4326
(4326)
LatestVCSWkid(0)
Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
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: 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: false
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
Fields:
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID
)
-
CNN
(
type: esriFieldTypeString, alias: CNN, editable: true, nullable: true, length: 16, defaultValue: null, modelName: CNN
)
-
CODE
(
type: esriFieldTypeString, alias: CODE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CODE
)
-
CNN_1
(
type: esriFieldTypeString, alias: CNN_1, editable: true, nullable: true, length: 254, defaultValue: null, modelName: CNN_1
)
-
STREET1
(
type: esriFieldTypeString, alias: STREET1, editable: true, nullable: true, length: 254, defaultValue: null, modelName: STREET1
)
-
STREET2
(
type: esriFieldTypeString, alias: STREET2, editable: true, nullable: true, length: 254, defaultValue: null, modelName: STREET2
)
-
DETECTION
(
type: esriFieldTypeString, alias: DETECTION, editable: true, nullable: true, length: 254, defaultValue: null, modelName: DETECTION
)
-
STREET3
(
type: esriFieldTypeString, alias: STREET3, editable: true, nullable: true, length: 254, defaultValue: null, modelName: STREET3
)
-
SUP_DIST
(
type: esriFieldTypeString, alias: SUP_DIST, editable: true, nullable: true, length: 254, defaultValue: null, modelName: SUP_DIST
)
-
STREET4
(
type: esriFieldTypeString, alias: STREET4, editable: true, nullable: true, length: 254, defaultValue: null, modelName: STREET4
)
-
SIG_NUM
(
type: esriFieldTypeString, alias: SIG_NUM, editable: true, nullable: true, length: 254, defaultValue: null, modelName: SIG_NUM
)
-
TYPE
(
type: esriFieldTypeString, alias: TYPE, editable: true, nullable: true, length: 254, defaultValue: null, modelName: TYPE
)
-
IC_MAKE
(
type: esriFieldTypeString, alias: IC_MAKE, editable: true, nullable: true, length: 254, defaultValue: null, modelName: IC_MAKE
)
-
MODEL
(
type: esriFieldTypeString, alias: MODEL, editable: true, nullable: true, length: 254, defaultValue: null, modelName: MODEL
)
-
CABINET_SI
(
type: esriFieldTypeString, alias: CABINET_SI, editable: true, nullable: true, length: 254, defaultValue: null, modelName: CABINET_SI
)
-
SYSTEM_NUM
(
type: esriFieldTypeString, alias: SYSTEM_NUM, editable: true, nullable: true, length: 254, defaultValue: null, modelName: SYSTEM_NUM
)
-
MASTER
(
type: esriFieldTypeString, alias: MASTER, editable: true, nullable: true, length: 254, defaultValue: null, modelName: MASTER
)
-
BBS
(
type: esriFieldTypeString, alias: BBS, editable: true, nullable: true, length: 254, defaultValue: null, modelName: BBS
)
-
VEH_ACTUAT
(
type: esriFieldTypeString, alias: VEH_ACTUAT, editable: true, nullable: true, length: 254, defaultValue: null, modelName: VEH_ACTUAT
)
-
PED_SIGNAL
(
type: esriFieldTypeString, alias: PED_SIGNAL, editable: true, nullable: true, length: 254, defaultValue: null, modelName: PED_SIGNAL
)
-
PED_ACTUAT
(
type: esriFieldTypeString, alias: PED_ACTUAT, editable: true, nullable: true, length: 254, defaultValue: null, modelName: PED_ACTUAT
)
-
MANUAL_CON
(
type: esriFieldTypeString, alias: MANUAL_CON, editable: true, nullable: true, length: 254, defaultValue: null, modelName: MANUAL_CON
)
-
TBC
(
type: esriFieldTypeString, alias: TBC, editable: true, nullable: true, length: 254, defaultValue: null, modelName: TBC
)
-
INTERCONNE
(
type: esriFieldTypeString, alias: INTERCONNE, editable: true, nullable: true, length: 254, defaultValue: null, modelName: INTERCONNE
)
-
PREEMPT_PR
(
type: esriFieldTypeString, alias: PREEMPT_PR, editable: true, nullable: true, length: 254, defaultValue: null, modelName: PREEMPT_PR
)
-
D_ATE2070
(
type: esriFieldTypeDate, alias: D_ATE2070, editable: true, nullable: true, length: 8, defaultValue: null, modelName: D_ATE2070
)
-
PROJECT_NE
(
type: esriFieldTypeString, alias: PROJECT_NE, editable: true, nullable: true, length: 254, defaultValue: null, modelName: PROJECT_NE
)
-
PROJECT_OL
(
type: esriFieldTypeString, alias: PROJECT_OL, editable: true, nullable: true, length: 254, defaultValue: null, modelName: PROJECT_OL
)
-
UPGRADED
(
type: esriFieldTypeString, alias: UPGRADED, editable: true, nullable: true, length: 254, defaultValue: null, modelName: UPGRADED
)
-
YR_OF_CONT
(
type: esriFieldTypeString, alias: YR_OF_CONT, editable: true, nullable: true, length: 254, defaultValue: null, modelName: YR_OF_CONT
)
-
LAST_UPGRA
(
type: esriFieldTypeString, alias: LAST_UPGRA, editable: true, nullable: true, length: 254, defaultValue: null, modelName: LAST_UPGRA
)
-
NEW_SIGNAL
(
type: esriFieldTypeString, alias: NEW_SIGNAL, editable: true, nullable: true, length: 254, defaultValue: null, modelName: NEW_SIGNAL
)
-
MOD_PROJEC
(
type: esriFieldTypeString, alias: MOD_PROJEC, editable: true, nullable: true, length: 254, defaultValue: null, modelName: MOD_PROJEC
)
-
FULL_UPGRA
(
type: esriFieldTypeString, alias: FULL_UPGRA, editable: true, nullable: true, length: 254, defaultValue: null, modelName: FULL_UPGRA
)
-
BEACON_FLA
(
type: esriFieldTypeString, alias: BEACON_FLA, editable: true, nullable: true, length: 254, defaultValue: null, modelName: BEACON_FLA
)
-
FUNDING
(
type: esriFieldTypeString, alias: FUNDING, editable: true, nullable: true, length: 254, defaultValue: null, modelName: FUNDING
)
-
RLCAM
(
type: esriFieldTypeString, alias: RLCAM, editable: true, nullable: true, length: 254, defaultValue: null, modelName: RLCAM
)
-
STARTYEAR
(
type: esriFieldTypeString, alias: STARTYEAR, editable: true, nullable: true, length: 254, defaultValue: null, modelName: STARTYEAR
)
-
CALTRANS_R
(
type: esriFieldTypeString, alias: CALTRANS_R, editable: true, nullable: true, length: 254, defaultValue: null, modelName: CALTRANS_R
)
-
CALTRANS
(
type: esriFieldTypeString, alias: CALTRANS, editable: true, nullable: true, length: 254, defaultValue: null, modelName: CALTRANS
)
-
PERCENT_C
(
type: esriFieldTypeDouble, alias: PERCENT_C, editable: true, nullable: true, defaultValue: null, modelName: PERCENT_C
)
-
SF
(
type: esriFieldTypeString, alias: SF, editable: true, nullable: true, length: 254, defaultValue: null, modelName: SF
)
-
PERCENT_SF
(
type: esriFieldTypeDouble, alias: PERCENT_SF, editable: true, nullable: true, defaultValue: null, modelName: PERCENT_SF
)
-
PERCENT_PO
(
type: esriFieldTypeInteger, alias: PERCENT_PO, editable: true, nullable: true, defaultValue: null, modelName: PERCENT_PO
)
-
LAMP_ASSGN
(
type: esriFieldTypeString, alias: LAMP_ASSGN, editable: true, nullable: true, length: 254, defaultValue: null, modelName: LAMP_ASSGN
)
-
LAMP_SORT
(
type: esriFieldTypeString, alias: LAMP_SORT, editable: true, nullable: true, length: 254, defaultValue: null, modelName: LAMP_SORT
)
-
SORT_ME
(
type: esriFieldTypeString, alias: SORT_ME, editable: true, nullable: true, length: 254, defaultValue: null, modelName: SORT_ME
)
-
APS
(
type: esriFieldTypeString, alias: APS, editable: true, nullable: true, length: 254, defaultValue: null, modelName: APS
)
-
CREATED_USER
(
type: esriFieldTypeString, alias: CREATED_USER, editable: false, nullable: true, length: 255, defaultValue: null, modelName: CREATED_USER
)
-
CREATED_DATE
(
type: esriFieldTypeDate, alias: CREATED_DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CREATED_DATE
)
-
LAST_EDITED_USER
(
type: esriFieldTypeString, alias: LAST_EDITED_USER, editable: false, nullable: true, length: 255, defaultValue: null, modelName: LAST_EDITED_USER
)
-
LAST_EDITED_DATE
(
type: esriFieldTypeDate, alias: LAST_EDITED_DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LAST_EDITED_DATE
)
Templates:
-
Name: MTA.signals
Description:
Prototype:
APS: null
SORT_ME: null
CNN: null
CODE: null
CNN_1: null
STREET1: null
STREET2: null
DETECTION: null
STREET3: null
SUP_DIST: null
STREET4: null
SIG_NUM: null
TYPE: null
IC_MAKE: null
MODEL: null
CABINET_SI: null
SYSTEM_NUM: null
MASTER: null
BBS: null
VEH_ACTUAT: null
PED_SIGNAL: null
PED_ACTUAT: null
MANUAL_CON: null
TBC: null
INTERCONNE: null
PREEMPT_PR: null
D_ATE2070: null
PROJECT_NE: null
PROJECT_OL: null
UPGRADED: null
YR_OF_CONT: null
LAST_UPGRA: null
NEW_SIGNAL: null
MOD_PROJEC: null
FULL_UPGRA: null
BEACON_FLA: null
FUNDING: null
RLCAM: null
STARTYEAR: null
CALTRANS_R: null
CALTRANS: null
PERCENT_C: null
SF: null
PERCENT_SF: null
PERCENT_PO: null
LAMP_ASSGN: null
LAMP_SORT: null
Drawing Tool: esriFeatureEditToolPoint
Capabilities: Query
Sync Can Return Changes: false
Is Data Versioned: false
Supports Rollback On Failure: true
Supports ApplyEdits With Global Ids: false
Edit Fields Info:
- Creation Date Field: created_date
- Creator Field: created_user
- Edit Date Field: last_edited_date
- Editor Field: last_edited_user
Supports Query With Historic Moment: false
Supports Coordinates Quantization: true
Child Resources:
Supported Operations:
Query
Validate SQL
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata
Update Metadata