Import ISO
No additional information has been provided for this dataset.
Between for ranges (e.g., 10,100)Regex for pattern matchingCase sensitive for exact matches
| ID | Feature ID | Geometry Type | ACCEPTED | ACTIVE | ADDRANGE | ARROW DIR | ASSET ID | ASSET NAME | ASSET NAME 1 | BAPA | BOOM TRUCK | CANCEL | CLEARANCE PERMIT | CNN | CNN 1 | COMBOKEY | CONDITION | CORNER SIDE FACING | CREATED DATE | CREATED USER | CURLYIDS | ETL | FROM ST | FROM ST 1 | GISOBJID | GLOBALID UDFCHAR44 | GPS LATITUDE | GPS LONGITUDE | INTERSECTION | INTERSECTION 1 | LAST EDITED DATE | LAST EDITED USER | LEGEND | LIMITS | LOCATION TRACK ID | LOC SPEC | NEW PURPOSE | NEW SIGN CODE | NEW SIGN LEGEND | NEW SIGN SIZE | NUM OF ASSETS | OBJECTID 1 | ORIG INSTALL DATE | POINT X | POINT Y | PURPOSE | REPLACEMENT DATE | RETIREMENT DATE | SF SUP DISTRICT | SHEETING | SIGN CATEGORY | SIGN CLASS | SIGN CODE | SIGN SIZE | SIGN SUPERVISOR | SIGN SUPPORT | STATUS CODE | STATUS DATE | STREETNAME | STREET ADDRESS RANGE | STREET ADDRESS RANGE 1 | STREET BLOCK | STREET VIEW | TO ST | TO ST 1 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 42001 | N/A | Point | - | - | - | - | S102849 | JERSEY ST: DOLORES ST | - | F | F | - | F | 25613000 | 25613000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | DOLORES ST | DOLORES ST | 6129 | 6129 | 37.75103315 | -122.4250757 | JERSEY ST \ DOLORES ST | JERSEY ST \ DOLORES ST | 1710539427000 | MTA | STOP | DOLORES ST intersection | - | - | - | - | - | - | - | 59091 | -379641600000 | -122.4250757 | 37.75103315 | - | 1197331200000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373568420000 | JERSEY ST | - | - | - | - | - | - |
| 42002 | N/A | Point | - | - | - | - | S108207 | BADEN ST: CIRCULAR AVE | - | F | F | - | F | 22131000 | 22131000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CIRCULAR AVE | CIRCULAR AVE | 6130 | 6130 | 37.73032572 | -122.43968607 | BADEN ST \ CIRCULAR AVE | BADEN ST \ CIRCULAR AVE | 1736801558000 | middleware_editor | STOP | CIRCULAR AVE intersection | - | - | - | - | - | - | - | 59092 | 290739600000 | -122.43968607 | 37.73032572 | - | 897868800000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373570100000 | BADEN ST | - | - | - | - | - | - |
| 42003 | N/A | Point | - | - | - | - | S108209 | BROADWAY: FRONT ST | - | F | F | - | F | 24800000 | 24800000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BROADWAY | FRONT ST | 6131 | 6131 | 37.798729 | -122.39987346 | FRONT ST \ BROADWAY | BROADWAY \ FRONT ST | 1741974386000 | middleware_editor | STOP | FRONT ST intersection | - | 0 / 00 | - | - | - | - | - | 59093 | 290851200000 | -122.39987346 | 37.798729 | - | 977904000000 | 1741973880000 | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | RETD | 1373570100000 | BROADWAY | - | - | - | - | - | - |
| 42004 | N/A | Point | - | - | - | - | S102525 | FILBERT ST: LEAVENWORTH ST | - | F | F | - | F | 25517000 | 25517000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | FILBERT ST | FILBERT ST | 6132 | 6132 | 37.80034079 | -122.41758698 | LEAVENWORTH ST \ FILBERT ST | LEAVENWORTH ST \ FILBERT ST | 1710539427000 | MTA | DO NOT ENTER | FILBERT ST intersection | - | 0 / MAKE EASTBOUND ONE WAY | - | - | - | - | - | 59094 | -387849600000 | -122.41758698 | 37.80034079 | - | - | - | D2 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373568300000 | LEAVENWORTH ST | - | - | - | - | - | - |
| 42005 | N/A | Point | - | - | - | - | S102526 | FILBERT ST: LEAVENWORTH ST | - | F | F | - | F | 25517000 | 25517000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | FILBERT ST | FILBERT ST | 6133 | 6133 | 37.80034079 | -122.41758698 | LEAVENWORTH ST \ FILBERT ST | LEAVENWORTH ST \ FILBERT ST | 1710539427000 | MTA | DO NOT ENTER | FILBERT ST intersection | - | 0 / MAKE EASTBOUND ONE WAY | - | - | - | - | - | 59095 | -387849600000 | -122.41758698 | 37.80034079 | - | - | - | D2 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373568300000 | LEAVENWORTH ST | - | - | - | - | - | - |
| 42006 | N/A | Point | - | - | - | - | S102527 | FILBERT ST: LEAVENWORTH ST | - | F | F | - | F | 25517000 | 25517000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | FILBERT ST | FILBERT ST | 6134 | 6134 | 37.80034079 | -122.41758698 | LEAVENWORTH ST \ FILBERT ST | LEAVENWORTH ST \ FILBERT ST | 1710539427000 | MTA | ONE WAY (LA) | FILBERT ST intersection | - | 0 / 0 | - | - | - | - | - | 59096 | -387849600000 | -122.41758698 | 37.80034079 | - | - | - | D2 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | UNKNOWN | IS | 1373568300000 | LEAVENWORTH ST | - | - | - | - | - | - |
| 42007 | N/A | Point | - | - | - | - | S102528 | DIVISION ST: SAN BRUNO AVE | - | F | F | - | F | 23880000 | 23880000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | DIVISION ST | DIVISION ST | 6135 | 6135 | 37.76965901 | -122.4059392 | SAN BRUNO AVE \ DIVISION ST | SAN BRUNO AVE \ DIVISION ST | 1710539427000 | MTA | ONE WAY (LA) | DIVISION ST intersection | - | 0 / 0 | - | - | - | - | - | 59097 | -387849600000 | -122.4059392 | 37.76965901 | - | - | - | D10 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | UNKNOWN | IS | 1373568300000 | SAN BRUNO AVE | - | - | - | - | - | - |
| 42008 | N/A | Point | - | - | - | - | S102529 | FILBERT ST: LEAVENWORTH ST | - | F | F | - | F | 25517000 | 25517000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | FILBERT ST | FILBERT ST | 6136 | 6136 | 37.80034079 | -122.41758698 | LEAVENWORTH ST \ FILBERT ST | LEAVENWORTH ST \ FILBERT ST | 1710539427000 | MTA | ONE WAY (RA) | FILBERT ST intersection | - | 0 / 0 | - | - | - | - | - | 59098 | -387849600000 | -122.41758698 | 37.80034079 | - | - | - | D2 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | UNKNOWN | IS | 1373568300000 | LEAVENWORTH ST | - | - | - | - | - | - |
| 42009 | N/A | Point | - | - | - | - | S102530 | JESSIE ST: 4TH ST | - | F | F | - | F | 24635000 | 24635000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | JESSIE ST | 04TH ST | 6137 | 6137 | 37.7849083 | -122.40479506 | 4TH ST \ JESSIE ST | JESSIE ST \ 04TH ST | 1752777242000 | middleware_editor | STOP | 04TH ST intersection | - | 0 / 00 | - | - | - | - | - | 59099 | -387738000000 | -122.40479506 | 37.7849083 | - | 1669622400000 | - | D6 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN FLANGE POST | IS | 1373568300000 | JESSIE ST | - | - | - | - | - | - |
| 42010 | N/A | Point | - | - | - | - | S102531 | NATOMA ST: 5TH ST | - | F | F | - | F | 23945000 | 23945000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | NATOMA ST | 05TH ST | 6138 | 6138 | 37.78192502 | -122.40546628 | 5TH ST \ NATOMA ST | NATOMA ST \ 05TH ST | 1710539427000 | MTA | STOP | 05TH ST intersection | - | 0 / 0 | - | - | - | - | - | 59100 | -387763200000 | -122.40546628 | 37.78192502 | - | 1488758400000 | - | D6 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1373568300000 | NATOMA ST | - | - | - | - | - | - |
| 42011 | N/A | Point | - | - | - | - | S102532 | STEVENSON ST: 5TH ST | - | F | F | - | F | 24888000 | 24888000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | STEVENSON ST | 05TH ST | 6139 | 6139 | 37.78352892 | -122.40748281 | 5TH ST \ STEVENSON ST | STEVENSON ST \ 05TH ST | 1752780270000 | middleware_editor | STOP | 05TH ST intersection | - | 0 / 0 | - | - | - | - | - | 59101 | -387738000000 | -122.40748281 | 37.78352892 | - | 1678176000000 | - | D6 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373568300000 | STEVENSON ST | - | - | - | - | - | - |
| 42012 | N/A | Point | - | - | - | - | S102533 | JESSIE ST: MINT PLZ \ MINT ST | - | F | F | - | F | 24866000 | 24866000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | JESSIE ST \ MINT PLZ | MINT PLZ \ MINT ST | 6140 | 6140 | 37.78261211 | -122.40769634 | MINT ST \ JESSIE ST \ MINT PLZ | JESSIE ST \ MINT PLZ \ MINT ST | 1710539427000 | MTA | STOP | MINT PLZ \ MINT ST intersection | - | - | - | - | - | - | - | 59102 | -387763200000 | -122.40769634 | 37.78261211 | - | 1554768000000 | - | D6 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1373568300000 | JESSIE ST | - | - | - | - | - | - |
| 42013 | N/A | Point | - | - | - | - | S102536 | NATOMA ST: 7TH ST | - | F | F | - | F | 24289000 | 24289000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 7TH ST | 07TH ST | 6143 | 6143 | 37.77841628 | -122.40993824 | NATOMA ST \ 7TH ST | NATOMA ST \ 07TH ST | 1733940535000 | middleware_editor | STOP | 07TH ST intersection | - | 0 / 0 | - | - | - | - | - | 59103 | -387763200000 | -122.40993824 | 37.77841628 | - | 1487894400000 | - | D6 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373568300000 | NATOMA ST | - | - | - | - | - | - |
| 42014 | N/A | Point | - | - | - | - | S102539 | JESSIE ST: 10TH ST | - | F | F | - | F | 24423000 | 24423000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 10TH ST | 10TH ST | 6146 | 6146 | 37.77576415 | -122.41652514 | JESSIE ST \ 10TH ST | JESSIE ST \ 10TH ST | 1710539427000 | MTA | STOP | 10TH ST intersection | - | 0 / 0 | - | - | - | - | - | 59104 | -387763200000 | -122.41652514 | 37.77576415 | - | - | - | D6 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373568300000 | JESSIE ST | - | - | - | - | - | - |
| 42015 | N/A | Point | - | - | - | - | S107043 | GODEUS ST: MISSION ST | - | F | F | - | F | 21330000 | 21330000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MISSION ST | GODEUS ST | 6170 | 6170 | 37.74282117 | -122.42168045 | GODEUS ST \ MISSION ST | MISSION ST \ GODEUS ST | 1747070051000 | middleware_editor | STOP | GODEUS ST intersection | - | 0 / 0 | - | - | - | - | - | 59105 | 186739200000 | -122.42168045 | 37.74282117 | - | 1574150400000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569740000 | MISSION ST | - | - | - | - | - | - |
| 42016 | N/A | Point | - | - | - | - | S101592 | WEBSTER ST: PACIFIC AVE | - | F | F | - | F | 26656000 | 26656000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | WEBSTER ST | WEBSTER ST | 6214 | 6214 | 37.79355755 | -122.43308842 | PACIFIC AVE \ WEBSTER ST | PACIFIC AVE \ WEBSTER ST | 1710539427000 | MTA | STOP | WEBSTER ST intersection | - | 0 / 0 | - | - | - | - | - | 59106 | -395712000000 | -122.43308842 | 37.79355755 | - | 1570147200000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373566800000 | PACIFIC AVE | - | - | - | - | - | - |
| 42017 | N/A | Point | - | - | - | - | S106735 | CONGDON ST: NEY ST | - | F | F | - | F | 21667000 | 21667000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | NEY ST | CONGDON ST | 6223 | 6223 | 37.73013563 | -122.42608431 | CONGDON ST \ NEY ST | NEY ST \ CONGDON ST | 1741114484000 | middleware_editor | STOP | CONGDON ST intersection | - | 0 / 0 | - | - | - | - | - | 59107 | 163666800000 | -122.42608431 | 37.73013563 | - | 1443682800000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569620000 | NEY ST | - | - | - | - | - | - |
| 42018 | N/A | Point | - | - | - | - | S106736 | CONGDON ST: NEY ST | - | F | F | - | F | 21667000 | 21667000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | NEY ST | CONGDON ST | 6224 | 6224 | 37.73013563 | -122.42608431 | CONGDON ST \ NEY ST | NEY ST \ CONGDON ST | 1741114543000 | middleware_editor | STOP | CONGDON ST intersection | - | 0 / 0 | - | - | - | - | - | 59108 | 163666800000 | -122.42608431 | 37.73013563 | - | 1582272000000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569620000 | NEY ST | - | - | - | - | - | - |
| 42019 | N/A | Point | 1 | 1 | 1 - 63 | - | S116619 | 12-63 TOWNSEND ST | 1-63 TOWNSEND ST | F | F | - | F | 12654000 | 12654000 | - | - | NORTH SIDE | - | - | - | - | KING ST \ THE EMBARCADERO | KING ST \ THE EMBARCADERO | 15451 | 15451 | 37.78161078 | -122.38908566 | - | - | 1710539427000 | MTA | NPRK 12MN-6AM MON STCL | KING ST \ THE EMBARCADERO to COLIN P KELLY JR ST (1 - 63) | - | 120' W THE EMBARCADERO | - | - | - | - | - | 59109 | 1051228800000 | -122.38908566 | 37.78161078 | - | 1505865600000 | - | D6 | - | STREET CLEANING | REG | R30B(CA).0048 | 18X18 | SUP1 | LIGHT POLE | IS | 1373572740000 | TOWNSEND ST | 1 - 63 TOWNSEND ST | 1 - 63 TOWNSEND ST | 1 TOWNSEND ST | - | COLIN P KELLY JR ST | COLIN P KELLY JR ST |
| 42020 | N/A | Point | - | - | - | - | S116403 | 17TH ST: SHOTWELL ST | - | F | F | - | F | 24135000 | 24135000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | SHOTWELL ST | 17TH ST | 15497 | 15497 | 37.76363514 | -122.41622727 | 17TH ST \ SHOTWELL ST | SHOTWELL ST \ 17TH ST | 1710539427000 | MTA | STOP | 17TH ST intersection | - | SWCORNER | - | - | - | - | - | 59110 | 1049241600000 | -122.41622727 | 37.76363514 | - | - | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 3IN IRON POST | IS | 1373572680000 | SHOTWELL ST | - | - | - | - | - | - |
| 42021 | N/A | Point | - | - | - | - | S116409 | 17TH ST: SHOTWELL ST | - | F | F | - | F | 24135000 | 24135000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | SHOTWELL ST | 17TH ST | 15500 | 15500 | 37.76363514 | -122.41622727 | 17TH ST \ SHOTWELL ST | SHOTWELL ST \ 17TH ST | 1710539427000 | MTA | ALL WAY | 17TH ST intersection | - | SWCORNER | - | - | - | - | - | 59111 | 1049241600000 | -122.41622727 | 37.76363514 | - | 1575936000000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 3IN IRON POST | IS | 1373572680000 | SHOTWELL ST | - | - | - | - | - | - |
| 42022 | N/A | Point | - | - | - | - | S116411 | SHOTWELL ST: 17TH ST | - | F | F | - | F | 24135000 | 24135000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SHOTWELL ST | 17TH ST | 15501 | 15501 | 37.76363514 | -122.41622727 | 17TH ST \ SHOTWELL ST | SHOTWELL ST \ 17TH ST | 1713910501000 | middleware_editor | ALL WAY | 17TH ST intersection | - | SECORNER | - | - | - | - | - | 59112 | 1049245200000 | -122.41622727 | 37.76363514 | - | 1624838400000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373572680000 | SHOTWELL ST | - | - | - | - | - | - |
| 42023 | N/A | Point | - | - | - | - | S116672 | DIAMOND ST: 23RD ST | - | F | F | - | F | 25762000 | 25762000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | DIAMOND ST | DIAMOND ST | 15502 | 15502 | 37.75275957 | -122.43645427 | 23RD ST \ DIAMOND ST | 23RD ST \ DIAMOND ST | 1710539427000 | MTA | ALL WAY | DIAMOND ST intersection | - | SECORNER | - | - | - | - | - | 59113 | 1051660800000 | -122.43645427 | 37.75275957 | - | 1575331200000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | UTILITY POLE | IS | 1373572740000 | 23RD ST | - | - | - | - | - | - |
| 42024 | N/A | Point | - | - | - | - | S120471 | NEWCOMB AVE: TOLAND ST | - | F | F | - | F | 20802000 | 20802000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | TOLAND ST | TOLAND ST | 15504 | 15504 | 37.7415190722288 | -122.400955184621 | NEWCOMB AVE \ TOLAND ST | NEWCOMB AVE \ TOLAND ST | 1749838230000 | middleware_editor | STOP | TOLAND ST intersection | - | - | - | - | - | - | - | 59114 | 1109750400000 | -122.40099318 | 37.74158785 | - | 1749834000000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 3IN IRON POST | IS | 1373573940000 | NEWCOMB AVE | - | - | - | - | - | - |
| 42025 | N/A | Point | - | 1 | 1 - 99 | - | S119204 | 1-99 STILLMAN ST | 1-99 STILLMAN ST | F | F | - | F | 12193000 | 12193000 | - | - | NORTH SIDE | - | - | - | - | 2ND ST | 02ND ST | 15505 | 15505 | 37.7826269 | -122.39526502 | - | - | 1710539427000 | MTA | NPRK 4AM-6AM TUE THUR SUN STCL | 02ND ST to 03RD ST (1 - 99) | - | 120' WEST | - | - | - | - | - | 59115 | 1089763200000 | -122.39526502 | 37.7826269 | - | 1544400000000 | - | D6 | - | STREET CLEANING | REG | R30B(CA).0326 | 18X18 | SUP1 | 2IN IRON POST | IS | 1373573580000 | STILLMAN ST | 1 - 99 STILLMAN ST | 1 - 99 STILLMAN ST | 1 STILLMAN ST | - | 03RD ST | 03RD ST |
| 42026 | N/A | Point | - | 1 | 1 - 99 | - | S119206 | 1-99 STILLMAN ST | 1-99 STILLMAN ST | F | F | - | F | 12193000 | 12193000 | - | - | NORTH SIDE | - | - | - | - | 2ND ST | 02ND ST | 15506 | 15506 | 37.7826269 | -122.39526502 | - | - | 1710539427000 | MTA | NPRK 4AM-6AM TUE THUR SUN STCL | 02ND ST to 03RD ST (1 - 99) | - | OPPOSITE EPL # 55 | - | - | - | - | - | 59116 | 1089763200000 | -122.39526502 | 37.7826269 | - | 1544400000000 | - | D6 | - | STREET CLEANING | REG | R30B(CA).0326 | 18X18 | SUP1 | 2IN IRON POST | IS | 1373573580000 | STILLMAN ST | 1 - 99 STILLMAN ST | 1 - 99 STILLMAN ST | 1 STILLMAN ST | - | 03RD ST | 03RD ST |
| 42027 | N/A | Point | - | 1 | 1 - 99 | - | S119207 | 1-99 STILLMAN ST | 1-99 STILLMAN ST | F | F | - | F | 12193000 | 12193000 | - | - | NORTH SIDE | - | - | - | - | 2ND ST | 02ND ST | 15507 | 15507 | 37.7826269 | -122.39526502 | - | - | 1710539427000 | MTA | NPRK 4AM-6AM TUE THUR SUN STCL | 02ND ST to 03RD ST (1 - 99) | - | OPPOSITE EPL # 87 | - | - | - | - | - | 59117 | 1089763200000 | -122.39526502 | 37.7826269 | - | 1544400000000 | - | D6 | - | STREET CLEANING | REG | R30B(CA).0326 | 18X18 | SUP1 | 2IN IRON POST | IS | 1373573580000 | STILLMAN ST | 1 - 99 STILLMAN ST | 1 - 99 STILLMAN ST | 1 STILLMAN ST | - | 03RD ST | 03RD ST |
| 42028 | N/A | Point | 1 | 1 | 100 - 199 | - | S119208 | 100-199 STILLMAN ST | 100-199 STILLMAN ST | F | F | - | F | 12192000 | 12192000 | - | - | NORTH SIDE | - | - | - | - | 3RD ST | 03RD ST | 15508 | 15508 | 37.78086485 | -122.39748952 | - | - | 1710539427000 | MTA | NPRK 4AM-6AM TUE WED SUN STCL | 03RD ST to 04TH ST (100 - 199) | - | 350W / OPPOSITE EPL # 145 | - | - | - | - | - | 59118 | 1089763200000 | -122.39748952 | 37.78086485 | - | - | - | D6 | - | STREET CLEANING | REG | R30B(CA).0151 | 18X18 | SUP1 | 2IN IRON POST | IS | 1373573580000 | STILLMAN ST | 100 - 199 STILLMAN ST | 100 - 199 STILLMAN ST | 100 STILLMAN ST | - | 04TH ST | 04TH ST |
| 42029 | N/A | Point | 1 | 1 | 100 - 199 | - | S119209 | 100-199 STILLMAN ST | 100-199 STILLMAN ST | F | F | - | F | 12192000 | 12192000 | - | - | NORTH SIDE | - | - | - | - | 3RD ST | 03RD ST | 15509 | 15509 | 37.78086485 | -122.39748952 | - | - | 1710539427000 | MTA | NPRK 4AM-6AM TUE WED SUN STCL | 03RD ST to 04TH ST (100 - 199) | - | 75' WEST | - | - | - | - | - | 59119 | 1089763200000 | -122.39748952 | 37.78086485 | - | - | - | D6 | - | STREET CLEANING | REG | R30B(CA).0151 | 18X18 | SUP1 | 2IN IRON POST | IS | 1373573580000 | STILLMAN ST | 100 - 199 STILLMAN ST | 100 - 199 STILLMAN ST | 100 STILLMAN ST | - | 04TH ST | 04TH ST |
| 42030 | N/A | Point | 1 | 1 | 100 - 199 | - | S119210 | 100-199 STILLMAN ST | 100-199 STILLMAN ST | F | F | - | F | 12192000 | 12192000 | - | - | NORTH SIDE | - | - | - | - | 3RD ST | 03RD ST | 15510 | 15510 | 37.78086485 | -122.39748952 | - | - | 1710539427000 | MTA | NPRK 4AM-6AM TUE WED SUN STCL | 03RD ST to 04TH ST (100 - 199) | - | OPPOSITE WPL # 171 | - | - | - | - | - | 59120 | 1089763200000 | -122.39748952 | 37.78086485 | - | - | - | D6 | - | STREET CLEANING | REG | R30B(CA).0151 | 18X18 | SUP1 | 2IN IRON POST | IS | 1373573580000 | STILLMAN ST | 100 - 199 STILLMAN ST | 100 - 199 STILLMAN ST | 100 STILLMAN ST | - | 04TH ST | 04TH ST |
| 42031 | N/A | Point | - | - | - | - | S119477 | MISSION ST: 25TH ST | - | F | F | - | F | 24073000 | 24073000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | MISSION ST | 25TH ST | 15511 | 15511 | 37.75063965 | -122.41828787 | 25TH ST \ MISSION ST | MISSION ST \ 25TH ST | 1717031269000 | middleware_editor | NO LEFT TURN (SYM) 4PM-6PM EXC SUN | 25TH ST intersection | - | SECORNER | - | - | - | - | - | 59121 | 1096588800000 | -122.41828787 | 37.75063965 | - | - | - | D9 | - | NO LEFT TURN | REG | R33(CA).0015 | 24X36 | SUP2 | 2IN IRON POST | IS | 1373573640000 | MISSION ST | - | - | - | - | - | - |
| 42032 | N/A | Point | 1 | 1 | 1 - 48 | - | S120401 | 1-48 OCEAN AVE | 1-48 OCEAN AVE | F | F | - | F | 9804000 | 9804000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | MISSION ST | MISSION ST | 15544 | 15544 | 37.72384863 | -122.4359172 | - | - | 1715822553000 | middleware_editor | PEDESTRIAN (SYM) | MISSION ST to PERSIA AVE (1 - 48) | - | 60`WEST | - | - | - | - | - | 59122 | 1109116800000 | -122.4359172 | 37.72384863 | - | 1580083200000 | - | D11 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373573940000 | OCEAN AVE | 1 - 48 OCEAN AVE | 1 - 48 OCEAN AVE | 1 OCEAN AVE | - | PERSIA AVE | PERSIA AVE |
| 42033 | N/A | Point | - | - | - | - | S120404 | 3RD ST: KEY AVE | - | T | T | - | F | 20466000 | 20466000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | KEY AVE | 03RD ST | 15546 | 15546 | 37.71947658 | -122.39695435 | 3RD ST \ KEY AVE | KEY AVE \ 03RD ST | 1710539427000 | MTA | KEY AVE | 03RD ST intersection | - | - | - | - | - | - | - | 59123 | 1109203200000 | -122.39695435 | 37.71947658 | - | 1658707200000 | - | D10 | - | STREET NAME | GUIDE | D3-2.0212 | 72X18 | SUP1 | OVERHEAD MAST ARM | IS | 1373573940000 | KEY AVE | - | - | - | - | - | - |
| 42034 | N/A | Point | 1 | 1 | 900 - 1099 | - | S121276 | 900-1099 TURK ST | 900-1099 TURK ST | F | F | - | F | 12726000 | 12726000 | - | - | SOUTH SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | GOUGH ST | GOUGH ST | 15547 | 15547 | 37.78132637 | -122.42556029 | - | - | 1710539427000 | MTA | STORM READY COMMUNITY | GOUGH ST to LAGUNA ST (900 - 1099) | - | ON LP IN FRONT OF EMERGENCY OPERATI..... | - | - | - | - | - | 59124 | 1121126400000 | -122.42556029 | 37.78132637 | - | - | - | D5 | - | OTHER GUIDE | GUIDE | G-S(SF).0037 | 24X24 | SUP1 | LIGHT POLE | IS | 1373574240000 | TURK ST | 900 - 1099 TURK ST | 900 - 1099 TURK ST | 900 TURK ST | - | LAGUNA ST | LAGUNA ST |
| 42035 | N/A | Point | - | - | - | - | S120414 | 3RD ST: KEY AVE | - | F | F | - | F | 20466000 | 20466000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | KEY AVE | 03RD ST | 15858 | 15858 | 37.71947658 | -122.39695435 | 3RD ST \ KEY AVE | KEY AVE \ 03RD ST | 1736524365000 | middleware_editor | ONE WAY (LA) | 03RD ST intersection | - | - | - | - | - | - | - | 59125 | 1109203200000 | -122.39695435 | 37.71947658 | - | 1736509500000 | - | D10 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | LIGHT POLE | IS | 1373573940000 | KEY AVE | - | - | - | - | - | - |
| 42036 | N/A | Point | 1 | 1 | 400 - 498 | - | S120415 | 398-498 JUSTIN DR | 400-498 JUSTIN DR | F | F | - | F | 7725000 | 7725000 | - | - | CENTER ISLAND, SOUTHBOUND TRAFFIC | - | - | - | - | COLLEGE AVE | COLLEGE AVE | 15859 | 15859 | 37.7321528 | -122.42425596 | - | - | 1723669027000 | middleware_editor | ROUNDABOUT ARROWS | COLLEGE AVE to GENEBERN WAY (400 - 498) | - | CENTER ISLAND OF NORTH LINE | - | - | - | - | - | 59126 | 1109203200000 | -122.42425596 | 37.7321528 | - | 1636934400000 | - | D9 | - | OTHER REGULATORY | REG | R7(SF).0001 | 18X24 | SUP2 | 2IN IRON POST | IS | 1373573940000 | JUSTIN DR | 400 - 498 JUSTIN DR | 400 - 498 JUSTIN DR | 400 JUSTIN DR | - | GENEBERN WAY | GENEBERN WAY |
| 42037 | N/A | Point | - | - | - | - | S120339 | 20TH ST: CHURCH ST | - | F | F | - | F | 25708000 | 25708000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CHURCH ST | CHURCH ST | 15860 | 15860 | 37.75808876 | -122.42805019 | 20TH ST \ CHURCH ST | 20TH ST \ CHURCH ST | 1736972260000 | middleware_editor | NO TURNS | CHURCH ST intersection | - | NECORNER OF INTERSECTION TO MUNI TRACKS | - | - | - | - | - | 59127 | 1107993600000 | -122.42805019 | 37.75808876 | - | - | - | D8 | - | OTHER REGULATORY | REG | R3-3.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373573940000 | 20TH ST | - | - | - | - | - | - |
| 42038 | N/A | Point | - | - | - | - | S120417 | 3RD ST: BANCROFT AVE | - | F | T | - | F | 20517000 | 20517000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BANCROFT AVE | 03RD ST | 15861 | 15861 | 37.7262374 | -122.39390251 | 3RD ST \ BANCROFT AVE | BANCROFT AVE \ 03RD ST | 1755019523000 | middleware_editor | ONE WAY (LA) | 03RD ST intersection | - | - | - | - | - | - | - | 59128 | 1109318400000 | -122.39390251 | 37.7262374 | - | - | - | D10 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | LIGHT POLE | IS | 1373573940000 | BANCROFT AVE | - | - | - | - | - | - |
| 42039 | N/A | Point | - | - | - | - | S120418 | HAVELOCK ST: SAN JOSE AVE | - | F | F | - | F | 22116000 | 22116000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | SAN JOSE AVE | SAN JOSE AVE | 15862 | 15862 | 37.72675888 | -122.44158192 | HAVELOCK ST \ SAN JOSE AVE | HAVELOCK ST \ SAN JOSE AVE | 1713921836000 | middleware_editor | NO OUTLET | SAN JOSE AVE intersection | - | BACK TO BACK WITH R1 | - | - | - | - | - | 59129 | 1109289600000 | -122.44158192 | 37.72675888 | - | - | - | D11 | - | OTHER WARNING | WARNING | W14-2.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373573940000 | HAVELOCK ST | - | - | - | - | - | - |
| 42040 | N/A | Point | - | - | - | - | S120419 | 3RD ST: BAY VIEW ST \ REVERE A | - | F | F | - | F | 20498000 | 20498000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 3RD ST \ BAY VIEW ST | 03RD ST \ BAY VIEW ST | 15863 | 15863 | 37.73243191 | -122.39152135 | REVERE AVE \ 3RD ST \ BAY VIEW ST | REVERE AVE \ 03RD ST \ BAY VIEW ST | 1710539427000 | MTA | (LA) TRAIN COMING WHEN FLASHING | 03RD ST \ BAY VIEW ST intersection | - | - | - | - | - | - | - | 59130 | 1109289600000 | -122.39152135 | 37.73243191 | - | - | - | D10 | - | OTHER WARNING | WARNING | W47(SF).0001 | 24X08 | SUP1 | OVERHEAD MAST ARM | IS | 1373573940000 | REVERE AVE | - | - | - | - | - | - |
| 42041 | N/A | Point | 1 | 1 | 100 - 199 | - | S120421 | 100-199 YALE ST | 100-199 YALE ST | T | T | - | F | 13741000 | 13741000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | SILLIMAN ST | SILLIMAN ST | 15864 | 15864 | 37.72728605 | -122.41765761 | - | - | 1749070778000 | middleware_editor | SCHOOL (SYM)/SCHOOL | SILLIMAN ST to FELTON ST (100 - 199) | 097285 | NPL# 129 | - | - | - | - | - | 59131 | 1109318400000 | -122.41765761 | 37.72728605 | - | 1749060360000 | - | D9 | - | SCHOOL | WARNING | SW24-1(CA).0001 | 30X42 | SUP2 | LIGHT POLE | IS | 1373573940000 | YALE ST | 100 - 199 YALE ST | 100 - 199 YALE ST | 100 YALE ST | - | FELTON ST | FELTON ST |
| 42042 | N/A | Point | - | - | - | - | S122562 | FILBERT ST: BUCHANAN ST | - | F | F | - | F | 26730000 | 26730000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BUCHANAN ST | BUCHANAN ST | 15866 | 15866 | 37.79843906 | -122.43239267 | FILBERT ST \ BUCHANAN ST | FILBERT ST \ BUCHANAN ST | 1710539427000 | MTA | ALL WAY | BUCHANAN ST intersection | - | - | - | - | - | - | - | 59132 | 1138233600000 | -122.43239267 | 37.79843906 | - | 1583366400000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373574600000 | FILBERT ST | - | - | - | - | - | - |
| 42043 | N/A | Point | - | - | - | - | S119178 | POWELL ST: CHESTNUT ST | - | F | F | - | F | 25455000 | 25455000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CHESTNUT ST | CHESTNUT ST | 15867 | 15867 | 37.80396348 | -122.41158124 | POWELL ST \ CHESTNUT ST | POWELL ST \ CHESTNUT ST | 1712095829000 | middleware_editor | STOP | CHESTNUT ST intersection | - | - | - | - | - | - | - | 59133 | 1089676800000 | -122.41158124 | 37.80396348 | - | - | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373573580000 | POWELL ST | - | - | - | - | - | - |
| 42044 | N/A | Point | - | - | - | - | S120491 | 3RD ST: KEY AVE | - | T | T | - | F | 20466000 | 20466000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | KEY AVE | 03RD ST | 15882 | 15882 | 37.71947658 | -122.39695435 | 3RD ST \ KEY AVE | KEY AVE \ 03RD ST | 1710539427000 | MTA | KEY AVE | 03RD ST intersection | - | - | - | - | - | - | - | 59134 | 1109808000000 | -122.39695435 | 37.71947658 | - | - | - | D10 | - | STREET NAME | GUIDE | D3-2.0212 | 72X18 | SUP1 | SIGNAL POLE | IS | 1373573940000 | KEY AVE | - | - | - | - | - | - |
| 42045 | N/A | Point | 1 | 1 | 3800 - 3899 | - | S119898 | 3800-3899 PACHECO ST | 3800-3899 PACHECO ST | F | F | - | F | 10111000 | 10111000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | 42ND AVE | 42ND AVE | 15890 | 15890 | 37.74940116 | -122.50139369 | - | - | 1710539427000 | MTA | SCHOOL (SYM) AHEAD | 42ND AVE to 43RD AVE (3800 - 3899) | 095612 | EPL 3821 | - | - | - | - | - | 59135 | 1102291200000 | -122.50139369 | 37.74940116 | - | 1651622400000 | - | D4 | - | SCHOOL AHEAD | WARNING | SW24-3(CA).0001 | 30X42 | SUP2 | 2IN IRON POST | IS | 1373573760000 | PACHECO ST | 3800 - 3899 PACHECO ST | 3800 - 3899 PACHECO ST | 3800 PACHECO ST | - | 43RD AVE | 43RD AVE |
| 42046 | N/A | Point | 1 | 1 | 451 - 599 | - | S119900 | 451-599 UPLAND DR | 451-599 UPLAND DR | F | F | - | F | 13011000 | 13011000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | SAN ALESO AVE | SAN ALESO AVE | 15891 | 15891 | 37.73024864 | -122.46583868 | - | - | 1717549749000 | middleware_editor | SCHOOL (SYM) | SAN ALESO AVE to APTOS AVE (451 - 599) | - | OPP.NW CORNOR | - | - | - | - | - | 59136 | 1102291200000 | -122.46583868 | 37.73024864 | - | - | 1643932800000 | D7 | - | SCHOOL | WARNING | S1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | RETD | 1373573760000 | UPLAND DR | 451 - 599 UPLAND DR | 451 - 599 UPLAND DR | 451 UPLAND DR | - | APTOS AVE | APTOS AVE |
| 42047 | N/A | Point | 1 | 1 | 947 - 999 | - | S119903 | 947-999 BROADWAY | 947-999 BROADWAY | F | F | - | F | 3160000 | 3160000 | - | - | SOUTH SIDE | - | - | - | - | HIMMELMANN PL | HIMMELMANN PL | 15892 | 15892 | 37.79710028 | -122.41328251 | - | - | 1738183476000 | middleware_editor | PARK AT 90 DEGREES (SYM) | HIMMELMANN PL to TAYLOR ST (947 - 999) -- NORTH -- | - | 25 EAST OF TAYLOR | - | - | - | - | - | 59137 | 1102377600000 | -122.41328251 | 37.79710028 | - | - | - | D3 | - | PARKING:PARK AT 90 | REG | R(SF).0182 | 18X18 | SUP1 | 2IN IRON POST | IS | 1373573760000 | BROADWAY | 947 - 999 BROADWAY | 947 - 999 BROADWAY | 947 BROADWAY | - | TAYLOR ST | TAYLOR ST |
| 42048 | N/A | Point | - | - | - | - | S119904 | BAKER ST: BROADWAY | - | F | F | - | F | 26883000 | 26883000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BROADWAY | BROADWAY | 15893 | 15893 | 37.79301452 | -122.44484314 | BAKER ST \ BROADWAY | BAKER ST \ BROADWAY | 1710539427000 | MTA | STOP | BROADWAY intersection | - | - | - | - | - | - | - | 59138 | 1102377600000 | -122.44484314 | 37.79301452 | - | - | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373573760000 | BAKER ST | - | - | - | - | - | - |
| 42049 | N/A | Point | - | - | - | - | S119909 | RIDGEWOOD AVE: MONTEREY BLVD | - | F | F | - | F | 22256000 | 22256000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | MONTEREY BLVD | MONTEREY BLVD | 15896 | 15896 | 37.73153065 | -122.45341134 | RIDGEWOOD AVE \ MONTEREY BLVD | RIDGEWOOD AVE \ MONTEREY BLVD | 1710539427000 | MTA | ALL WAY | MONTEREY BLVD intersection | - | - | - | - | - | - | - | 59139 | 1102377600000 | -122.45341134 | 37.73153065 | - | - | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373573760000 | RIDGEWOOD AVE | - | - | - | - | - | - |
| 42050 | N/A | Point | - | - | - | - | S119313 | JEFFERSON ST: BRODERICK ST | - | F | F | - | F | 27013000 | 27013000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | JEFFERSON ST | BRODERICK ST | 16104 | 16104 | 37.8044257 | -122.44545923 | BRODERICK ST \ JEFFERSON ST | JEFFERSON ST \ BRODERICK ST | 1710539427000 | MTA | ALL WAY | BRODERICK ST intersection | - | - | - | - | - | - | - | 59140 | 1091577600000 | -122.44545923 | 37.8044257 | - | - | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | MUNI POLE | IS | 1373573580000 | JEFFERSON ST | - | - | - | - | - | - |
| 42051 | N/A | Point | - | - | - | - | S119315 | BRODERICK ST: JEFFERSON ST | - | F | F | - | F | 27013000 | 27013000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | JEFFERSON ST | BRODERICK ST | 16105 | 16105 | 37.8044257 | -122.44545923 | BRODERICK ST \ JEFFERSON ST | JEFFERSON ST \ BRODERICK ST | 1710539427000 | MTA | ALL WAY | BRODERICK ST intersection | - | - | - | - | - | - | - | 59141 | 1091577600000 | -122.44545923 | 37.8044257 | - | - | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373573580000 | JEFFERSON ST | - | - | - | - | - | - |
| 42052 | N/A | Point | - | 1 | 1300 - 1319 | - | S119316 | 1300-1349 DE HARO ST | 1300-1319 DE HARO ST | F | F | - | F | 4639000 | 4639000 | - | - | UNKNOWN | - | - | - | - | 24TH ST | 24TH ST | 16106 | 16106 | 37.75321683 | -122.40058303 | - | - | 1710539427000 | MTA | TANP ANY TIME (LA) | 24TH ST to DE HARO ST (1300 - 1319) | - | 0 / OPPOSITE NPL# 1351-55/-SEE PHOTO- | - | - | - | - | - | 59142 | 1091577600000 | -122.40058303 | 37.75321683 | - | - | - | D10 | - | TOW (TANP ANY TIME) | REG | R26K(CA).0042 | 18X21 | SUP1 | 2IN IRON POST | IS | 1373573580000 | DE HARO ST | 1300 - 1319 DE HARO ST | 1300 - 1319 DE HARO ST | 1300 DE HARO ST | - | DE HARO ST | DE HARO ST |
| 42053 | N/A | Point | 1 | 1 | 1 - 199 | - | S119317 | 1-197 MUSEUM WAY | 1-199 MUSEUM WAY | F | F | - | F | 9463000 | 9463000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | FAIRBANKS ST \ ROOSEVELT WAY | FAIRBANKS ST \ ROOSEVELT WAY | 16107 | 16107 | 37.76458979 | -122.44015692 | - | - | 1710539427000 | MTA | SPEED LIMIT 15 | FAIRBANKS ST \ ROOSEVELT WAY to END: 1-197 BLOCK (1 - 199) | - | 84' S OF SPL #118 | - | - | - | - | - | 59143 | 1091664000000 | -122.44015692 | 37.76458979 | - | - | - | D8 | - | SPEED LIMIT | REG | R2-1.0003 | 24X30 | SUP2 | LIGHT POLE | IS | 1373573580000 | MUSEUM WAY | 1 - 199 MUSEUM WAY | 1 - 199 MUSEUM WAY | 1 MUSEUM WAY | - | END: 1-197 BLOCK | END: 1-197 BLOCK |
| 42054 | N/A | Point | - | - | - | - | S119320 | 43RD AVE: JUDAH ST | - | F | F | - | F | 27800000 | 27800000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | JUDAH ST | 43RD AVE | 16108 | 16108 | 37.76056653 | -122.50271299 | 43RD AVE \ JUDAH ST | JUDAH ST \ 43RD AVE | 1718047645000 | middleware_editor | ALL WAY | 43RD AVE intersection | - | - | - | - | - | - | - | 59144 | 1092009600000 | -122.50271299 | 37.76056653 | - | 1453680000000 | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373573580000 | JUDAH ST | - | - | - | - | - | - |
| 42055 | N/A | Point | - | - | - | - | S119321 | 43RD AVE: JUDAH ST | - | F | F | - | F | 27800000 | 27800000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | JUDAH ST | 43RD AVE | 16109 | 16109 | 37.76056653 | -122.50271299 | 43RD AVE \ JUDAH ST | JUDAH ST \ 43RD AVE | 1710539427000 | MTA | ALL WAY | 43RD AVE intersection | - | - | - | - | - | - | - | 59145 | 1092009600000 | -122.50271299 | 37.76056653 | - | - | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373573580000 | JUDAH ST | - | - | - | - | - | - |
| 42056 | N/A | Point | 1 | 1 | 1 - 99 | LEFT ARROW | S118415 | 1-99 VERMONT ST | 1-99 VERMONT ST | F | F | - | F | 13208000 | 13208000 | - | - | EAST SIDE | - | - | - | - | DIVISION ST | DIVISION ST | 16113 | 16113 | 37.76912266 | -122.4049324 | - | - | 1710539427000 | MTA | TANS EXC 30 MIN 6 WHEEL TL 8AM-6PM MON-FRI | DIVISION ST to ALAMEDA ST (1 - 99) | - | 190' SOUTH OF DIVISION | - | - | - | - | - | 59146 | 1077753600000 | -122.4049324 | 37.76912266 | - | - | - | D10 | - | OTHER REGULATORY | REG | R37(SF).0159 | 10X15 | SUP1 | 2IN IRON POST | IS | 1373573280000 | VERMONT ST | 1 - 99 VERMONT ST | 1 - 99 VERMONT ST | 1 VERMONT ST | - | ALAMEDA ST | ALAMEDA ST |
| 42057 | N/A | Point | - | - | - | RIGHT ARROW | S118416 | VERMONT ST: DIVISION ST | - | F | F | - | F | 23879000 | 23879000 | - | - | SOUTH EAST CORNER | - | - | - | - | VERMONT ST | DIVISION ST | 16114 | 16114 | 37.76971451 | -122.40499021 | DIVISION ST \ VERMONT ST | VERMONT ST \ DIVISION ST | 1753734903000 | middleware_editor | TANS EXC 30 MIN COMMERCIAL VEH 8AM-6PM MON-FRI | DIVISION ST intersection | - | BELOW R1 | - | - | - | - | - | 59147 | 1077782400000 | -122.40499021 | 37.76971451 | - | - | - | D10 | - | OTHER REGULATORY | REG | R37(SF).0185 | 10X15 | SUP1 | 2IN IRON POST | IS | 1373573280000 | VERMONT ST | - | - | - | - | - | - |
| 42058 | N/A | Point | - | - | - | - | S118417 | QUINTARA ST: 22ND AVE | - | F | F | - | F | 23210000 | 23210000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | QUINTARA ST | 22ND AVE | 16115 | 16115 | 37.74850364 | -122.47929591 | 22ND AVE \ QUINTARA ST | QUINTARA ST \ 22ND AVE | 1735281575000 | middleware_editor | ALL WAY | 22ND AVE intersection | - | - | - | - | - | - | - | 59148 | 1077840000000 | -122.47929591 | 37.74850364 | - | 1735224240000 | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373573280000 | QUINTARA ST | - | - | - | - | - | - |
| 42059 | N/A | Point | - | - | - | - | S118418 | 22ND AVE: QUINTARA ST | - | F | F | - | F | 23210000 | 23210000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | QUINTARA ST | 22ND AVE | 16116 | 16116 | 37.74850364 | -122.47929591 | 22ND AVE \ QUINTARA ST | QUINTARA ST \ 22ND AVE | 1730912321000 | middleware_editor | ALL WAY | 22ND AVE intersection | - | - | - | - | - | - | - | 59149 | 1077840000000 | -122.47929591 | 37.74850364 | - | - | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | LIGHT POLE | IS | 1373573280000 | QUINTARA ST | - | - | - | - | - | - |
| 42060 | N/A | Point | - | - | - | - | S118419 | 22ND AVE: QUINTARA ST | - | F | F | - | F | 23210000 | 23210000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | QUINTARA ST | 22ND AVE | 16117 | 16117 | 37.74850364 | -122.47929591 | 22ND AVE \ QUINTARA ST | QUINTARA ST \ 22ND AVE | 1730912310000 | middleware_editor | ALL WAY | 22ND AVE intersection | - | - | - | - | - | - | - | 59150 | 1077840000000 | -122.47929591 | 37.74850364 | - | - | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373573280000 | QUINTARA ST | - | - | - | - | - | - |
| 42061 | N/A | Point | - | - | - | - | S120151 | LAWTON ST: 34TH AVE | - | F | F | - | F | 27701000 | 27701000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 34TH AVE | 34TH AVE | 16118 | 16118 | 37.75725859 | -122.49280598 | LAWTON ST \ 34TH AVE | LAWTON ST \ 34TH AVE | 1710539427000 | MTA | ALL WAY | 34TH AVE intersection | - | - | - | - | - | - | - | 59151 | 1106006400000 | -122.49280598 | 37.75725859 | - | - | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373573880000 | LAWTON ST | - | - | - | - | - | - |
| 42062 | N/A | Point | - | - | - | - | S120152 | LAWTON ST: 34TH AVE | - | F | F | - | F | 27701000 | 27701000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 34TH AVE | 34TH AVE | 16119 | 16119 | 37.75725859 | -122.49280598 | LAWTON ST \ 34TH AVE | LAWTON ST \ 34TH AVE | 1710539427000 | MTA | ALL WAY | 34TH AVE intersection | - | - | - | - | - | - | - | 59152 | 1106006400000 | -122.49280598 | 37.75725859 | - | - | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373573880000 | LAWTON ST | - | - | - | - | - | - |
| 42063 | N/A | Point | 1 | 1 | 200 - 299 | - | S120153 | 200-299 MYRTLE ST | 200-299 MYRTLE ST | F | F | - | F | 9473000 | 9473000 | - | - | NORTH SIDE | - | - | - | - | VAN NESS AVE | VAN NESS AVE | 16120 | 16120 | 37.7851144 | -122.42214694 | - | - | 1710539427000 | MTA | NPRK ANY TIME | VAN NESS AVE to FRANKLIN ST (200 - 299) | - | 85'WEST OF VAN NESS | - | - | - | - | - | 59153 | 1106006400000 | -122.42214694 | 37.7851144 | - | 1432080000000 | - | D5 | - | PARKING:NPRK ANY TIME | REG | R26(CA).0001 | 12X18 | SUP1 | 2IN IRON POST | IS | 1373573880000 | MYRTLE ST | 200 - 299 MYRTLE ST | 200 - 299 MYRTLE ST | 200 MYRTLE ST | - | FRANKLIN ST | FRANKLIN ST |
| 42064 | N/A | Point | 1 | 1 | 300 - 399 | - | S116485 | 300-399 KANSAS ST | 300-399 KANSAS ST | F | F | - | F | 7727000 | 7727000 | - | - | EAST SIDE | - | - | - | - | 16TH ST | 16TH ST | 16133 | 16133 | 37.76536997 | -122.40358504 | - | - | 1710539427000 | MTA | NPPZ 6AM-6PM EVERYDAY | 16TH ST to 17TH ST (300 - 399) | - | 196' NORTH OF 17TH ST @ PM | - | - | - | - | - | 59154 | 1050278400000 | -122.40358504 | 37.76536997 | - | - | - | D10 | - | OTHER REGULATORY | REG | R30(SF).0156 | 12X18 | SUP1 | MUNI POLE | IS | 1373572680000 | KANSAS ST | 300 - 399 KANSAS ST | 300 - 399 KANSAS ST | 300 KANSAS ST | - | 17TH ST | 17TH ST |
| 42065 | N/A | Point | 1 | 1 | 400 - 499 | - | S117012 | 400-499 PHELPS ST | 400-499 PHELPS ST | F | F | - | F | 10396000 | 10396000 | - | - | WEST SIDE | - | - | - | - | EVANS AVE | EVANS AVE | 16188 | 16188 | 37.742669 | -122.38873572 | - | - | 1710539427000 | MTA | HABITTN IN VEH PROH 10PM6AM EVRYDY/VLTRS SUBJ FINE OR ARRST | EVANS AVE to FAIRFAX AVE (400 - 499) | - | 50' SOUTH | - | - | - | - | - | 59155 | 1055203200000 | -122.38873572 | 37.742669 | - | - | - | D10 | - | OTHER REGULATORY | REG | R(SF).0091 | 18X18 | SUP1 | 2IN IRON POST | IS | 1373572860000 | PHELPS ST | 400 - 499 PHELPS ST | 400 - 499 PHELPS ST | 400 PHELPS ST | - | FAIRFAX AVE | FAIRFAX AVE |
| 42066 | N/A | Point | 1 | 1 | 500 - 599 | - | S117013 | 500-599 PHELPS ST | 500-599 PHELPS ST | F | F | - | F | 10397000 | 10397000 | - | - | WEST SIDE | - | - | - | - | FAIRFAX AVE | FAIRFAX AVE | 16189 | 16189 | 37.74204348 | -122.38929873 | - | - | 1710539427000 | MTA | HABITTN IN VEH PROH 10PM6AM EVRYDY/VLTRS SUBJ FINE OR ARRST | FAIRFAX AVE to SAM JORDANS WAY (500 - 599) | - | 100' S OF FAIRFAX | - | - | - | - | - | 59156 | 1055203200000 | -122.38929873 | 37.74204348 | - | - | - | D10 | - | OTHER REGULATORY | REG | R(SF).0091 | 18X18 | SUP1 | 2IN IRON POST | IS | 1373572860000 | PHELPS ST | 500 - 599 PHELPS ST | 500 - 599 PHELPS ST | 500 PHELPS ST | - | SAM JORDANS WAY | SAM JORDANS WAY |
| 42067 | N/A | Point | 1 | 1 | 700 - 799 | - | S117014 | 700-799 PHELPS ST | 700-799 PHELPS ST | F | F | - | F | 10399000 | 10399000 | - | - | WEST SIDE | - | - | - | - | HUDSON AVE | HUDSON AVE | 16190 | 16190 | 37.74079372 | -122.39042264 | - | - | 1710539427000 | MTA | HABITTN IN VEH PROH 10PM6AM EVRYDY/VLTRS SUBJ FINE OR ARRST | HUDSON AVE to INNES AVE (700 - 799) | - | OPPOSITE SPL # 701 | - | - | - | - | - | 59157 | 1055203200000 | -122.39042264 | 37.74079372 | - | - | - | D10 | - | OTHER REGULATORY | REG | R(SF).0091 | 18X18 | SUP1 | LIGHT POLE | IS | 1373572860000 | PHELPS ST | 700 - 799 PHELPS ST | 700 - 799 PHELPS ST | 700 PHELPS ST | - | INNES AVE | INNES AVE |
| 42068 | N/A | Point | 1 | 1 | 1500 - 1599 | - | S117015 | 1500-1599 SOUTH VAN NESS AVE | 1500-1599 SOUTH VAN NESS AVE | F | F | - | F | 12033000 | 12033000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | 26TH ST | 26TH ST | 16191 | 16191 | 37.74869217 | -122.41590872 | - | - | 1715873229000 | middleware_editor | FREEWAY (LA) | 26TH ST to CESAR CHAVEZ ST (1500 - 1599) | - | 100S / 100' SOUTH | - | - | - | - | - | 59158 | 1055289600000 | -122.41590872 | 37.74869217 | - | - | - | D9 | - | OTHER GUIDE | GUIDE | G-F(SF).0052 | 48X16 | SUP2 | LIGHT POLE | IS | 1373572860000 | SOUTH VAN NESS AVE | 1500 - 1599 SOUTH VAN NESS AVE | 1500 - 1599 SOUTH VAN NESS AVE | 1500 SOUTH VAN NESS AVE | - | CESAR CHAVEZ ST | CESAR CHAVEZ ST |
| 42069 | N/A | Point | 1 | 1 | 1000 - 1099 | - | S116748 | 1000-1099 CASTRO ST | 1000-1099 CASTRO ST | F | F | - | F | 3798000 | 3798000 | - | - | EAST SIDE | - | - | - | - | ALVARADO ST | ALVARADO ST | 16192 | 16192 | 37.75329048 | -122.43427821 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-9PM MON-FRI EXC "S" PERMITS | ALVARADO ST to 23RD ST (1000 - 1099) | - | INFO #1005 | - | - | - | - | - | 59159 | 1052352000000 | -122.43427821 | 37.75329048 | - | - | - | D8 | - | PARKING:RPP | REG | R32C(CA).0126 | 18X21 | SUP2 | 2IN IRON POST | IS | 1373572800000 | CASTRO ST | 1000 - 1099 CASTRO ST | 1000 - 1099 CASTRO ST | 1000 CASTRO ST | - | 23RD ST | 23RD ST |
| 42070 | N/A | Point | 1 | 1 | 600 - 625 | - | S116751 | 600-625 WEBSTER ST | 600-625 WEBSTER ST | F | F | - | F | 13529000 | 13529000 | - | - | CENTER ISLAND, NORTHBOUND TRAFFIC | - | - | - | - | HAYES ST | HAYES ST | 16194 | 16194 | 37.77627776 | -122.42960217 | - | - | 1710539427000 | MTA | LEFT TURN YIELD ON GREEN (SYM) | HAYES ST to IVY ST (600 - 625) | - | CENTER ISLAND | - | - | - | - | - | 59160 | 1052438400000 | -122.42960217 | 37.77627776 | - | - | - | D5 | - | OTHER REGULATORY | REG | R10-12.0001 | 30X36 | SUP1 | SIGNAL POLE | IS | 1373572800000 | WEBSTER ST | 600 - 625 WEBSTER ST | 600 - 625 WEBSTER ST | 600 WEBSTER ST | - | IVY ST | IVY ST |
| 42071 | N/A | Point | 1 | 1 | 100 - 199 | - | S116752 | 100-199 ELLINGTON AVE | 100-199 ELLINGTON AVE | F | F | - | F | 5158000 | 5158000 | - | - | WEST SIDE | - | - | - | - | MOUNT VERNON AVE | MOUNT VERNON AVE | 16195 | 16195 | 37.71454932 | -122.44374462 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "V" PERMITS | MOUNT VERNON AVE to OTTAWA AVE (100 - 199) | - | IFO#38 | - | - | - | - | - | 59161 | 1052438400000 | -122.44374462 | 37.71454932 | - | 1601942400000 | - | D11 | - | PARKING:RPP | REG | R32C(CA).0102 | 18X21 | SUP2 | LIGHT POLE | IS | 1373572800000 | ELLINGTON AVE | 100 - 199 ELLINGTON AVE | 100 - 199 ELLINGTON AVE | 100 ELLINGTON AVE | - | OTTAWA AVE | OTTAWA AVE |
| 42072 | N/A | Point | 1 | 1 | 200 - 299 | - | S116753 | 200-299 CLAYTON ST | 200-299 CLAYTON ST | F | F | - | F | 4129000 | 4129000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | HAYES ST | HAYES ST | 16196 | 16196 | 37.77305189 | -122.44923453 | - | - | 1755538754000 | middleware_editor | PLAYGROUND (SYM) | HAYES ST to FELL ST (200 - 299) | - | INFO #239 | - | - | - | - | - | 59162 | 1052463600000 | -122.44923453 | 37.77305189 | - | - | - | D5 | - | OTHER WARNING | WARNING | W15-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373572800000 | CLAYTON ST | 200 - 299 CLAYTON ST | 200 - 299 CLAYTON ST | 200 CLAYTON ST | - | FELL ST | FELL ST |
| 42073 | N/A | Point | 1 | 1 | 600 - 625 | - | S116754 | 600-625 WEBSTER ST | 600-625 WEBSTER ST | F | F | - | F | 13529000 | 13529000 | - | - | CENTER ISLAND, SOUTHBOUND TRAFFIC | - | - | - | - | HAYES ST | HAYES ST | 16197 | 16197 | 37.77627776 | -122.42960217 | - | - | 1710539427000 | MTA | LANE REDUCTION (SYM) LEFT | HAYES ST to IVY ST (600 - 625) | - | WEST SIDE OF CENTER ISLAND | - | - | - | - | - | 59163 | 1052438400000 | -122.42960217 | 37.77627776 | - | - | - | D5 | - | OTHER WARNING | WARNING | W4-2.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373572800000 | WEBSTER ST | 600 - 625 WEBSTER ST | 600 - 625 WEBSTER ST | 600 WEBSTER ST | - | IVY ST | IVY ST |
| 42074 | N/A | Point | - | - | - | - | S119918 | MONTEREY BLVD: RIDGEWOOD AVE | - | F | F | - | F | 22256000 | 22256000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | MONTEREY BLVD | MONTEREY BLVD | 16198 | 16198 | 37.73153065 | -122.45341134 | RIDGEWOOD AVE \ MONTEREY BLVD | RIDGEWOOD AVE \ MONTEREY BLVD | 1710539427000 | MTA | ALL WAY | MONTEREY BLVD intersection | - | - | - | - | - | - | - | 59164 | 1102377600000 | -122.45341134 | 37.73153065 | - | - | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373573760000 | RIDGEWOOD AVE | - | - | - | - | - | - |
| 42075 | N/A | Point | 1 | 1 | 10 - 19 | - | S119919 | 0-0 MONTEREY BLVD | 10-19 MONTEREY BLVD | F | F | - | F | 4042000 | 4042000 | - | - | WEST SIDE | - | - | - | - | JOOST AVE | JOOST AVE | 16199 | 16199 | 37.73219439 | -122.43522524 | - | - | 1743777980000 | middleware_editor | TANSAT | JOOST AVE to SAN JOSE AV ON RAMP (10 - 19) | - | IFO#76 | - | - | - | - | - | 59165 | 1102406400000 | -122.43522524 | 37.73219439 | - | - | - | D7 | - | TOW (TANSAT) | REG | R37(CA).0089 | 14X21 | SUP2 | 2IN IRON POST | IS | 1373573760000 | MONTEREY BLVD | 0-0 MONTEREY BLVD | 10 - 19 MONTEREY BLVD | - | - | SAN JOSE AV ON RAMP | SAN JOSE AV ON RAMP |
Download data as a comma-separated values file with coordinates and properties.
Download CSVDownload data in GeoJSON format, compatible with most GIS applications.
Download GeoJSONDownload data in KML format for use with Google Earth and other mapping applications.
Download KMLDownload data as a shapefile (ZIP format) for use with ArcGIS and other GIS software.
Download ShapefileGet detailed information about this dataset including metadata and available properties.
page - Page number (default: 1)limit - Results per page (max: 1000, default: 100)properties - JSON object for property filteringgeometry_type - Filter by geometry type (Point, LineString, Polygon, etc.)bbox - Bounding box (minX,minY,maxX,maxY)lat - Center latitude for radius searchlon - Center longitude for radius searchradius - Search radius in metersMetadata automatically harvested from the ESRI service during import.