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

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: 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: false
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: true
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: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• CNN ( type: esriFieldTypeString, alias: CNN, length: 16 )
• CODE ( type: esriFieldTypeString, alias: CODE, length: 50 )
• CNN_1 ( type: esriFieldTypeString, alias: CNN_1, length: 254 )
• STREET1 ( type: esriFieldTypeString, alias: STREET1, length: 254 )
• STREET2 ( type: esriFieldTypeString, alias: STREET2, length: 254 )
• DETECTION ( type: esriFieldTypeString, alias: DETECTION, length: 254 )
• STREET3 ( type: esriFieldTypeString, alias: STREET3, length: 254 )
• SUP_DIST ( type: esriFieldTypeString, alias: SUP_DIST, length: 254 )
• STREET4 ( type: esriFieldTypeString, alias: STREET4, length: 254 )
• SIG_NUM ( type: esriFieldTypeString, alias: SIG_NUM, length: 254 )
• TYPE ( type: esriFieldTypeString, alias: TYPE, length: 254 )
• IC_MAKE ( type: esriFieldTypeString, alias: IC_MAKE, length: 254 )
• MODEL ( type: esriFieldTypeString, alias: MODEL, length: 254 )
• CABINET_SI ( type: esriFieldTypeString, alias: CABINET_SI, length: 254 )
• SYSTEM_NUM ( type: esriFieldTypeString, alias: SYSTEM_NUM, length: 254 )
• MASTER ( type: esriFieldTypeString, alias: MASTER, length: 254 )
• BBS ( type: esriFieldTypeString, alias: BBS, length: 254 )
• VEH_ACTUAT ( type: esriFieldTypeString, alias: VEH_ACTUAT, length: 254 )
• PED_SIGNAL ( type: esriFieldTypeString, alias: PED_SIGNAL, length: 254 )
• PED_ACTUAT ( type: esriFieldTypeString, alias: PED_ACTUAT, length: 254 )
• MANUAL_CON ( type: esriFieldTypeString, alias: MANUAL_CON, length: 254 )
• TBC ( type: esriFieldTypeString, alias: TBC, length: 254 )
• INTERCONNE ( type: esriFieldTypeString, alias: INTERCONNE, length: 254 )
• PREEMPT_PR ( type: esriFieldTypeString, alias: PREEMPT_PR, length: 254 )
• D_ATE2070 ( type: esriFieldTypeDate, alias: D_ATE2070, length: 8 )
• PROJECT_NE ( type: esriFieldTypeString, alias: PROJECT_NE, length: 254 )
• PROJECT_OL ( type: esriFieldTypeString, alias: PROJECT_OL, length: 254 )
• UPGRADED ( type: esriFieldTypeString, alias: UPGRADED, length: 254 )
• YR_OF_CONT ( type: esriFieldTypeString, alias: YR_OF_CONT, length: 254 )
• LAST_UPGRA ( type: esriFieldTypeString, alias: LAST_UPGRA, length: 254 )
• NEW_SIGNAL ( type: esriFieldTypeString, alias: NEW_SIGNAL, length: 254 )
• MOD_PROJEC ( type: esriFieldTypeString, alias: MOD_PROJEC, length: 254 )
• FULL_UPGRA ( type: esriFieldTypeString, alias: FULL_UPGRA, length: 254 )
• BEACON_FLA ( type: esriFieldTypeString, alias: BEACON_FLA, length: 254 )
• FUNDING ( type: esriFieldTypeString, alias: FUNDING, length: 254 )
• RLCAM ( type: esriFieldTypeString, alias: RLCAM, length: 254 )
• STARTYEAR ( type: esriFieldTypeString, alias: STARTYEAR, length: 254 )
• CALTRANS_R ( type: esriFieldTypeString, alias: CALTRANS_R, length: 254 )
• CALTRANS ( type: esriFieldTypeString, alias: CALTRANS, length: 254 )
• PERCENT_C ( type: esriFieldTypeDouble, alias: PERCENT_C )
• SF ( type: esriFieldTypeString, alias: SF, length: 254 )
• PERCENT_SF ( type: esriFieldTypeDouble, alias: PERCENT_SF )
• PERCENT_PO ( type: esriFieldTypeInteger, alias: PERCENT_PO )
• LAMP_ASSGN ( type: esriFieldTypeString, alias: LAMP_ASSGN, length: 254 )
• LAMP_SORT ( type: esriFieldTypeString, alias: LAMP_SORT, length: 254 )
• SORT_ME ( type: esriFieldTypeString, alias: SORT_ME, length: 254 )
• APS ( type: esriFieldTypeString, alias: APS, length: 254 )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, length: 255 )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, length: 8 )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, length: 255 )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, length: 8 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata