MTA.signshop_assets
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 68326 | N/A | Point | 1 | 1 | 900 - 999 | LEFT ARROW | S251728 | 900-999 HYDE ST | 900-999 HYDE ST | F | F | - | F | 7124000 | 7124000 | - | - | EAST SIDE | - | - | - | - | BUSH ST | BUSH ST | 86302 | 86302 | 37.78957766 | -122.41711084 | - | - | 1710539427000 | MTA | TA (SYM) SHUTTLE BUS ONLY AT ALL TIMES/ HC (SYM) (20 MIN) | BUSH ST to PINE ST (900 - 999) | - | 160 N OF BUSH | - | - | - | - | - | 85442 | 1551364200000 | -122.41711084 | 37.78957766 | - | - | - | D3 | - | OTHER REGULATORY | REG | R38(SF)2.0020 | 14X21 | SUP1 | 2IN IRON POST | IS | 1550665080000 | HYDE ST | 900 - 999 HYDE ST | 900 - 999 HYDE ST | 900 HYDE ST | - | PINE ST | PINE ST |
| 68327 | N/A | Point | 1 | 1 | 200 - 299 | - | S255989 | 200-299 8TH AVE | 200-299 08TH AVE | F | F | - | F | 388000 | 388000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | CALIFORNIA ST | CALIFORNIA ST | 86321 | 86321 | 37.78378247 | -122.46662855 | - | - | 1736983305000 | middleware_editor | SPEED HUMPS | CALIFORNIA ST to CLEMENT ST (200 - 299) | - | NPL 209 | - | - | - | - | - | 85443 | 1565704860000 | -122.46662855 | 37.78378247 | - | - | - | D1 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1562768400000 | 08TH AVE | 200 - 299 8TH AVE | 200 - 299 08TH AVE | 200 8TH AVE | - | CLEMENT ST | CLEMENT ST |
| 68328 | N/A | Point | 1 | 1 | 100 - 199 | - | S255992 | 100-199 8TH AVE | 100-199 08TH AVE | F | F | - | F | 387000 | 387000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | LAKE ST | LAKE ST | 86323 | 86323 | 37.78564184 | -122.46676239 | - | - | 1710539427000 | MTA | SPEED HUMPS | LAKE ST to CALIFORNIA ST (100 - 199) | - | NPL 115 | - | - | - | - | - | 85444 | 1565704380000 | -122.46676239 | 37.78564184 | - | - | - | D1 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1562769480000 | 08TH AVE | 100 - 199 8TH AVE | 100 - 199 08TH AVE | 100 8TH AVE | - | CALIFORNIA ST | CALIFORNIA ST |
| 68329 | N/A | Point | - | - | - | - | S258802 | FOLSOM ST: PRECITA AVE | - | F | F | - | F | 21172000 | 21172000 | - | - | WEST SIDE | - | - | - | - | FOLSOM ST | FOLSOM ST | 86333 | 86333 | 37.747151932 | -122.413704346 | PRECITA AVE \ FOLSOM ST | PRECITA AVE \ FOLSOM ST | 1710539427000 | MTA | BIKE RACK | FOLSOM ST intersection | 74034 | 10' S OF NPL #3202/3' IN FROM CURB | - | - | - | - | - | 85445 | 1572945000000 | -122.41357113 | 37.74717102 | - | - | - | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1572419520000 | PRECITA AVE | - | - | - | - | - | - |
| 68330 | N/A | Point | - | - | - | - | S265257 | RHODE ISLAND ST: 23RD ST | - | F | F | - | F | 23710000 | 23710000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | RHODE ISLAND ST | RHODE ISLAND ST | 86489 | 86489 | 37.75457056 | -122.40158939 | 23RD ST \ RHODE ISLAND ST | 23RD ST \ RHODE ISLAND ST | 1710539427000 | MTA | SPEED HUMP | RHODE ISLAND ST intersection | - | 5' NORTH OF 23RD ST. | - | - | - | - | - | 85446 | 1592909340000 | -122.40158939 | 37.75457056 | - | - | - | D10 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1592480400000 | 23RD ST | - | - | - | - | - | - |
| 68331 | N/A | Point | 1 | 1 | 300 - 399 | - | S281345 | 300-399 ITALY AVE | 300-399 ITALY AVE | F | F | - | F | 7343000 | 7343000 | - | - | SOUTH SIDE | - | - | - | - | LISBON ST | LISBON ST | 86747 | 86747 | 37.717093708 | -122.436769521 | - | - | 1754577543000 | middleware_editor | NPRK 11AM-1PM MON STCL | LISBON ST to MADRID ST (300 - 399) | - | 70 FT WEST OF MADRID | - | - | - | - | - | 85447 | - | -122.43673197 | 37.71714463 | - | - | - | D11 | - | STREET CLEANING | REG | R30B(CA).0027 | 18X18 | SUP2 | 2IN IRON POST | IS | 1646657940000 | ITALY AVE | 300 - 399 ITALY AVE | 300 - 399 ITALY AVE | 300 ITALY AVE | - | MADRID ST | MADRID ST |
| 68332 | N/A | Point | 1 | 1 | 300 - 399 | - | S281346 | 300-399 ITALY AVE | 300-399 ITALY AVE | F | F | - | F | 7343000 | 7343000 | - | - | NORTH SIDE | - | - | - | - | LISBON ST | LISBON ST | 86748 | 86748 | 37.717177163 | -122.436694419 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM FRI STCL | LISBON ST to MADRID ST (300 - 399) | - | 60 FT WEST OF MADRID | - | - | - | - | - | 85448 | 1333324800000 | -122.43673197 | 37.71714463 | - | - | - | D11 | - | STREET CLEANING | REG | R30B(CA).0298 | 18X18 | SUP2 | 2IN IRON POST | IS | 1646658000000 | ITALY AVE | 300 - 399 ITALY AVE | 300 - 399 ITALY AVE | 300 ITALY AVE | - | MADRID ST | MADRID ST |
| 68333 | N/A | Point | 1 | 1 | 200 - 299 | - | S281350 | 200-299 ITALY AVE | 200-299 ITALY AVE | F | F | - | F | 7342000 | 7342000 | - | - | NORTH SIDE | - | - | - | - | PARIS ST | PARIS ST | 86749 | 86749 | 37.71759942 | -122.437569208 | - | - | 1754577527000 | middleware_editor | NPRK 8AM-10AM MON STCL | PARIS ST to LISBON ST (200 - 299) | - | 70 FT EAST OF LISBON | - | - | - | - | - | 85449 | - | -122.43753881 | 37.71753011 | - | 1754512800000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0261 | 18X18 | SUP2 | 2IN IRON POST | IS | 1646658600000 | ITALY AVE | 200 - 299 ITALY AVE | 200 - 299 ITALY AVE | 200 ITALY AVE | - | LISBON ST | LISBON ST |
| 68334 | N/A | Point | 1 | 1 | 200 - 299 | - | S281351 | 200-299 ITALY AVE | 200-299 ITALY AVE | F | F | - | F | 7342000 | 7342000 | - | - | SOUTH SIDE | - | - | - | - | PARIS ST | PARIS ST | 86750 | 86750 | 37.717508893 | -122.437628217 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM WED STCL | PARIS ST to LISBON ST (200 - 299) | - | 70 FT EAST OF LISBON | - | - | - | - | - | 85450 | - | -122.43753881 | 37.71753011 | - | 1703590200000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0273 | 18X18 | SUP2 | 2IN IRON POST | IS | 1646658720000 | ITALY AVE | 200 - 299 ITALY AVE | 200 - 299 ITALY AVE | 200 ITALY AVE | - | LISBON ST | LISBON ST |
| 68335 | N/A | Point | - | - | - | - | S284252 | PLYMOUTH AVE: SADOWA ST | - | F | F | - | F | 21598000 | 21598000 | - | - | NORTH EAST CORNER | - | - | - | - | SADOWA ST | SADOWA ST | 86761 | 86761 | 37.71231964 | -122.45604543 | PLYMOUTH AVE \ SADOWA ST | PLYMOUTH AVE \ SADOWA ST | 1726850545000 | middleware_editor | TREE TOP 6FT SPEED BUMP | SADOWA ST intersection | - | - | - | - | - | - | - | 85451 | 1664323200000 | -122.45604543 | 37.71231964 | - | - | - | D11 | - | OTHER WARNING | WARNING | W(SF).0109 | 72X18 | SUP2 | ANCHORS | IS | 1659361740000 | PLYMOUTH AVE | - | - | - | - | - | - |
| 68336 | N/A | Point | - | - | - | - | S282960 | FAIRFAX AVE: PHELPS ST | - | F | F | - | F | 20242000 | 20242000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | FAIRFAX AVE | FAIRFAX AVE | 86790 | 86790 | 37.74235738 | -122.38901642 | PHELPS ST \ FAIRFAX AVE | PHELPS ST \ FAIRFAX AVE | 1710539427000 | MTA | STOP | FAIRFAX AVE intersection | - | - | - | - | - | - | - | 85452 | 1235952000000 | -122.38901642 | 37.74235738 | - | - | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1653296580000 | PHELPS ST | - | - | - | - | - | - |
| 68337 | N/A | Point | - | - | - | - | S282995 | LEXINGTON ST: 21ST ST | - | F | F | - | F | 24121000 | 24121000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 21ST ST | LEXINGTON ST | 86792 | 86792 | 37.757027372 | -122.420394666 | LEXINGTON ST \ 21ST ST | 21ST ST \ LEXINGTON ST | 1710539427000 | MTA | WARNING-SUSPICIOUS ACTIVITIES IMMEDIATELY RPTD TO POLICE ETC | LEXINGTON ST intersection | - | - | - | - | - | - | - | 85453 | 1591574400000 | -122.42033834 | 37.75694891 | - | - | 1657238400000 | D9 | - | OTHER WARNING | WARNING | SW(SF).0003 | 24X18 | SUP2 | 3IN IRON POST | RETD | 1653396060000 | 21ST ST | - | - | - | - | - | - |
| 68338 | N/A | Point | - | - | - | - | S284168 | FULTON ST: 10TH AVE | - | F | F | - | F | 27262000 | 27262000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | FULTON ST | FULTON ST | 86800 | 86800 | 37.773312311 | -122.468031967 | 10TH AVE \ FULTON ST | 10TH AVE \ FULTON ST | 1745008342000 | middleware_editor | BIKE (SYM) USE PED SIGNAL | FULTON ST intersection | - | OFFSET SIGN (EAST WAY). | - | - | - | - | - | 85454 | 1662966000000 | -122.46802392 | 37.77330383 | - | - | - | D1 | - | PEDESTRIAN | REG | R(SF).0429 | 18X21 | SUP2 | SIGNAL POLE | IS | 1659003780000 | 10TH AVE | - | - | - | - | - | - |
| 68339 | N/A | Point | - | - | - | - | S271996 | LOMITA AVE: 15TH AVE \ LAWTON | - | F | F | - | F | 27165000 | 27165000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 15TH AVE | 15TH AVE | 86808 | 86808 | 37.75904551 | -122.47196212 | \LOMITA AVE: 15TH AVE \ LAWTON | LAWTON ST \ 15TH AVE | 1710539427000 | MTA | SPEED HUMP | 15TH AVE intersection | - | - | - | - | - | - | - | 85455 | 226540800000 | -122.47196212 | 37.75904551 | - | 1619654400000 | - | D7 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1611913980000 | LAWTON ST | - | - | - | - | - | - |
| 68340 | N/A | Point | - | - | - | - | S272004 | LOMITA AVE: 15TH AVE \ LAWTON | - | F | F | - | F | 27165000 | 27165000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | 15TH AVE | 15TH AVE | 86809 | 86809 | 37.75904551 | -122.47196212 | \LOMITA AVE: 15TH AVE \ LAWTON | LAWTON ST \ 15TH AVE | 1710539427000 | MTA | SPEED HUMP | 15TH AVE intersection | - | NPL 50 | - | - | - | - | - | 85456 | 226540800000 | -122.47196212 | 37.75904551 | - | 1619654400000 | - | D7 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1611916320000 | LAWTON ST | - | - | - | - | - | - |
| 68341 | N/A | Point | 1 | 1 | 80 - 199 | - | S272008 | 80-199 LOMITA AVE | 80-199 LOMITA AVE | F | F | - | F | 8469000 | 8469000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | ALOHA AVE | ALOHA AVE | 86810 | 86810 | 37.75754427 | -122.47298423 | - | - | 1710539427000 | MTA | SPEED HUMPS AHEAD | ALOHA AVE to 16TH AVE (80 - 199) | - | NPL 95 ABOVE STREET CLEANING SIGN | - | - | - | - | - | 85457 | 1224201600000 | -122.47298423 | 37.75754427 | - | 1615939200000 | - | D7 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1611917520000 | LOMITA AVE | 80 - 199 LOMITA AVE | 80 - 199 LOMITA AVE | 80 LOMITA AVE | - | 16TH AVE | 16TH AVE |
| 68342 | N/A | Point | 1 | 1 | 1500 - 1599 | - | S254668 | 1500-1599 SANSOME ST | 1500-1599 SANSOME ST | T | T | - | F | 11561000 | 11561000 | - | - | WEST SIDE | - | - | - | - | LOMBARD ST | LOMBARD ST | 86830 | 86830 | 37.80460991 | -122.40344487 | - | - | 1710539427000 | MTA | LEFT LANE MUST TURN LEFT | LOMBARD ST to CHESTNUT ST \ THE EMBARCADERO (1500 - 1599) | - | 150' SOUTH OF THE EMBARCADERO | - | - | - | - | - | 85458 | 1484265600000 | -122.40344487 | 37.80460991 | - | 1564617600000 | - | D3 | - | OTHER REGULATORY | REG | R3-7.0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1559123640000 | SANSOME ST | 1500 - 1599 SANSOME ST | 1500 - 1599 SANSOME ST | 1500 SANSOME ST | - | CHESTNUT ST \ THE EMBARCADERO | CHESTNUT ST \ THE EMBARCADERO |
| 68343 | N/A | Point | 1 | 1 | 950 - 999 | - | S254353 | 950-999 VALENCIA ST | 950-999 VALENCIA ST | F | F | - | F | 13068000 | 13068000 | - | - | EAST SIDE | - | - | - | - | LIBERTY ST | LIBERTY ST | 86848 | 86848 | 37.75718875 | -122.421045995 | - | - | 1710539427000 | MTA | BIKE RACK | LIBERTY ST to 21ST ST (950 - 999) | - | 10' s of npl 985 ifo mission picnic | - | - | - | - | - | 85459 | - | -122.4211557 | 37.75730171 | - | - | 1708609500000 | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | RETD | 1558001820000 | VALENCIA ST | 950 - 999 VALENCIA ST | 950 - 999 VALENCIA ST | 950 VALENCIA ST | - | 21ST ST | 21ST ST |
| 68344 | N/A | Point | 1 | 1 | 300 - 399 | - | S254481 | 300-399 FRANCE AVE | 300-399 FRANCE AVE | F | F | - | F | 5746000 | 5746000 | - | - | NORTH SIDE | - | - | - | - | LISBON ST | LISBON ST | 86860 | 86860 | 37.718801922 | -122.435658313 | - | - | 1710539427000 | MTA | NPRK 11AM-1PM MON STCL | LISBON ST to MADRID ST (300 - 399) | - | EPL 301 | - | - | - | - | - | 85460 | 1476835200000 | -122.43555773 | 37.71869902 | - | 1579651200000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0027 | 18X18 | SUP2 | 2IN IRON POST | IS | 1558427520000 | FRANCE AVE | 300 - 399 FRANCE AVE | 300 - 399 FRANCE AVE | 300 FRANCE AVE | - | MADRID ST | MADRID ST |
| 68345 | N/A | Point | 1 | 1 | 47 - 99 | - | S257800 | 47-99 CAMBRIDGE ST | 47-99 CAMBRIDGE ST | T | T | - | F | 3618000 | 3618000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | GLADSTONE DR | GLADSTONE DR | 88677 | 88677 | 37.73142298 | -122.41962044 | - | - | 1718241963000 | middleware_editor | SPEED HUMP | GLADSTONE DR to WEST VIEW AVE (47 - 99) | - | 50 FT EAST OF GLADSTONE OPP 70 | - | - | - | - | - | 85461 | - | -122.41962044 | 37.73142298 | - | 1568937600000 | - | D9 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1568715960000 | CAMBRIDGE ST | 47 - 99 CAMBRIDGE ST | 47 - 99 CAMBRIDGE ST | 47 CAMBRIDGE ST | - | WEST VIEW AVE | WEST VIEW AVE |
| 68346 | N/A | Point | - | - | - | - | S256272 | SHAFTER AVE: KEITH ST | - | T | T | - | F | 20158000 | 20158000 | - | - | SOUTH EAST CORNER | - | - | - | - | SHAFTER AVE | KEITH ST | 88687 | 88687 | 37.729956024 | -122.388978502 | KEITH ST \ SHAFTER AVE | SHAFTER AVE \ KEITH ST | 1710539427000 | MTA | KEITH ST | KEITH ST intersection | 00935A | 0 / 0 | - | - | - | - | - | 85462 | 25747200000 | -122.38885512 | 37.72998042 | - | 1661472000000 | - | D10 | - | STREET NAME | GUIDE | D3-1.0961 | 36X08 | SUP1 | 3IN IRON POST | IS | 1563611160000 | SHAFTER AVE | - | - | - | - | - | - |
| 68347 | N/A | Point | - | - | - | - | S256273 | SHAFTER AVE: KEITH ST | - | T | T | - | F | 20158000 | 20158000 | - | - | SOUTH EAST CORNER | - | - | - | - | SHAFTER AVE | KEITH ST | 88688 | 88688 | 37.729951782 | -122.38897649 | KEITH ST \ SHAFTER AVE | SHAFTER AVE \ KEITH ST | 1710539427000 | MTA | SHAFTER AVE | KEITH ST intersection | 00935A | 0 / 0 | - | - | - | - | - | 85463 | 25747200000 | -122.38885512 | 37.72998042 | - | 1643673600000 | - | D10 | - | STREET NAME | GUIDE | D3-1.1613 | 36X08 | SUP1 | 3IN IRON POST | IS | 1563611220000 | SHAFTER AVE | - | - | - | - | - | - |
| 68348 | N/A | Point | 1 | 1 | 300 - 399 | - | S257669 | 300-399 PARIS ST | 300-399 PARIS ST | F | F | - | F | 10253000 | 10253000 | - | - | WEST SIDE | - | - | - | - | BRAZIL AVE | BRAZIL AVE | 88691 | 88691 | 37.723700178 | -122.433493659 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM WED STCL | BRAZIL AVE to PERSIA AVE (300 - 399) | - | SPL 310 | - | - | - | - | - | 85464 | 1558396800000 | -122.4338191 | 37.72315706 | - | - | - | D11 | - | STREET CLEANING | REG | R30B(CA).0273 | 18X18 | SUP2 | 2IN IRON POST | IS | 1568190540000 | PARIS ST | 300 - 399 PARIS ST | 300 - 399 PARIS ST | 300 PARIS ST | - | PERSIA AVE | PERSIA AVE |
| 68349 | N/A | Point | - | - | - | - | S251721 | 12TH AVE: BALBOA ST | - | F | F | - | F | 27297000 | 27297000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 12TH AVE | 12TH AVE | 88710 | 88710 | 37.77694147 | -122.47043297 | BALBOA ST \ 12TH AVE | BALBOA ST \ 12TH AVE | 1719945596000 | middleware_editor | SPEED HUMPS | 12TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 85465 | -402105600000 | -122.47043297 | 37.77694147 | - | 1550707200000 | - | D1 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1550660700000 | BALBOA ST | - | - | - | - | - | - |
| 68350 | N/A | Point | - | - | - | - | S251722 | 12TH AVE: CABRILLO ST | - | F | F | - | F | 27267000 | 27267000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CABRILLO ST | 12TH AVE | 88711 | 88711 | 37.77507657 | -122.4702979 | 12TH AVE \ CABRILLO ST | CABRILLO ST \ 12TH AVE | 1719945570000 | middleware_editor | SPEED HUMPS | 12TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 85466 | 188092800000 | -122.4702979 | 37.77507657 | - | 1552262400000 | - | D1 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1550660940000 | CABRILLO ST | - | - | - | - | - | - |
| 68351 | N/A | Point | 1 | 1 | 400 - 499 | - | S252593 | 400-499 ITALY AVE | 400-499 ITALY AVE | F | F | - | F | 7344000 | 7344000 | - | - | NORTH SIDE | - | - | - | - | MADRID ST | MADRID ST | 88715 | 88715 | 37.716800231 | -122.435904368 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM FRI STCL | MADRID ST to EDINBURGH ST (400 - 499) | - | 100' EAST | - | - | - | - | - | 85467 | 1333324800000 | -122.43593119 | 37.71676204 | - | - | - | D11 | - | STREET CLEANING | REG | R30B(CA).0298 | 18X18 | SUP2 | 2IN IRON POST | IS | 1552906800000 | ITALY AVE | 400 - 499 ITALY AVE | 400 - 499 ITALY AVE | 400 ITALY AVE | - | EDINBURGH ST | EDINBURGH ST |
| 68352 | N/A | Point | - | - | - | - | S136254 | 17TH ST: KANSAS ST | - | F | F | - | F | 23774000 | 23774000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | KANSAS ST | 17TH ST | 88733 | 88733 | 37.764665488 | -122.403658122 | 17TH ST \ KANSAS ST | KANSAS ST \ 17TH ST | 1715218794000 | middleware_editor | ALL WAY | 17TH ST intersection | - | BELOW EXISTING STOP SIGN | - | - | - | - | - | 85468 | 1333411200000 | -122.40352703 | 37.76472287 | - | 1560729600000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | MUNI POLE | IS | 1373578860000 | KANSAS ST | - | - | - | - | - | - |
| 68353 | N/A | Point | - | - | - | - | S253577 | CHURCH ST: 16TH ST | - | F | F | - | F | 25726000 | 25726000 | - | - | SOUTH EAST CORNER | - | - | - | - | 16TH ST | CHURCH ST | 88766 | 88766 | 37.764619283 | -122.428792088 | CHURCH ST \ 16TH ST | 16TH ST \ CHURCH ST | 1710539427000 | MTA | CHURCH ST | CHURCH ST intersection | - | - | - | - | - | - | - | 85469 | 1479686400000 | -122.42866513 | 37.76450761 | - | 1560384000000 | - | D8 | - | STREET NAME | GUIDE | D3-1.0379 | 36X08 | SUP2 | SIGNAL POLE | IS | 1555411320000 | 16TH ST | - | - | - | - | - | - |
| 68354 | N/A | Point | 1 | 1 | 4400 - 4499 | - | S259414 | 4400-4499 BALBOA ST | 4400-4499 BALBOA ST | F | F | - | F | 2690000 | 2690000 | - | - | SOUTH SIDE | - | - | - | - | 45TH AVE | 45TH AVE | 88914 | 88914 | 37.7752220658623 | -122.506767720022 | - | - | 1742340143000 | middleware_editor | TA (SYM) NO STOPPING EXC PERMITTED CSV-GETAROUND | 45TH AVE to 46TH AVE (4400 - 4499) | - | 20' E OF 46TH AVE | - | - | - | - | - | 85470 | 1581369300000 | -122.50642082 | 37.77529905 | - | - | 1742332860000 | D1 | - | OTHER REGULATORY | REG | R37(SF).0293 | 05X12 | SUP2 | 2IN IRON POST | RETD | 1574420460000 | BALBOA ST | 4400 - 4499 BALBOA ST | 4400 - 4499 BALBOA ST | 4400 BALBOA ST | - | 46TH AVE | 46TH AVE |
| 68355 | N/A | Point | 1 | 1 | 4400 - 4499 | - | S259415 | 4400-4499 BALBOA ST | 4400-4499 BALBOA ST | F | F | - | F | 2690000 | 2690000 | - | - | SOUTH SIDE | - | - | - | - | 45TH AVE | 45TH AVE | 88915 | 88915 | 37.7752223908754 | -122.506754636202 | - | - | 1742340127000 | middleware_editor | GETAROUND | 45TH AVE to 46TH AVE (4400 - 4499) | - | 20' E OF 46TH AVE | - | - | - | - | - | 85471 | 1581372300000 | -122.50642082 | 37.77529905 | - | - | 1742334240000 | D1 | - | OTHER GUIDE | GUIDE | G-G(SF).0037 | 05X12 | SUP2 | 2IN IRON POST | RETD | 1574420520000 | BALBOA ST | 4400 - 4499 BALBOA ST | 4400 - 4499 BALBOA ST | 4400 BALBOA ST | - | 46TH AVE | 46TH AVE |
| 68356 | N/A | Point | - | - | - | - | S270862 | CHENERY ST: LIPPARD AVE | - | F | F | - | F | 21967000 | 21967000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CHENERY ST | CHENERY ST | 89428 | 89428 | 37.73479699 | -122.43555053 | LIPPARD AVE \ CHENERY ST | LIPPARD AVE \ CHENERY ST | 1710539427000 | MTA | SPEED HUMPS AHEAD | CHENERY ST intersection | - | ABOVE ONE WAY | - | - | - | - | - | 85472 | 1082332800000 | -122.43555053 | 37.73479699 | - | 1616371200000 | - | D8 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1608194880000 | LIPPARD AVE | - | - | - | - | - | - |
| 68357 | N/A | Point | - | - | - | - | S270864 | CHENERY ST: LIPPARD AVE | - | T | T | - | F | 21967000 | 21967000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CHENERY ST | CHENERY ST | 89429 | 89429 | 37.73479699 | -122.43555053 | LIPPARD AVE \ CHENERY ST | LIPPARD AVE \ CHENERY ST | 1710539427000 | MTA | SPEED HUMPS AHEAD | CHENERY ST intersection | - | ABOVE SIGNS | - | - | - | - | - | 85473 | 1082332800000 | -122.43555053 | 37.73479699 | - | 1616371200000 | - | D8 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1608195180000 | LIPPARD AVE | - | - | - | - | - | - |
| 68358 | N/A | Point | - | - | - | - | S270866 | CHENERY ST: LIPPARD AVE | - | F | F | - | F | 21967000 | 21967000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CHENERY ST | CHENERY ST | 89430 | 89430 | 37.73479699 | -122.43555053 | LIPPARD AVE \ CHENERY ST | LIPPARD AVE \ CHENERY ST | 1710539427000 | MTA | SPEED HUMPS AHEAD | CHENERY ST intersection | - | - | - | - | - | - | - | 85474 | 1082332800000 | -122.43555053 | 37.73479699 | - | 1616371200000 | - | D8 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1608195600000 | LIPPARD AVE | - | - | - | - | - | - |
| 68359 | N/A | Point | 1 | 1 | 700 - 799 | - | S254100 | 700-799 EDINBURG ST | 700-799 EDINBURGH ST | F | F | - | F | 5092000 | 5092000 | - | - | EAST SIDE | - | - | - | - | FRANCE AVE | FRANCE AVE | 89482 | 89482 | 37.716799257 | -122.435284414 | - | - | 1710539427000 | MTA | NPRK 11AM-1PM FRI STCL | FRANCE AVE to ITALY AVE (700 - 799) | - | NPL 783 | - | - | - | - | - | 85475 | 1586874600000 | -122.43494288 | 37.71734808 | - | - | - | D11 | - | STREET CLEANING | REG | R30B(CA).0026 | 18X18 | SUP2 | LIGHT POLE | IS | 1557131340000 | EDINBURGH ST | 700 - 799 EDINBURGH ST | 700 - 799 EDINBURGH ST | 700 EDINBURGH ST | - | ITALY AVE | ITALY AVE |
| 68360 | N/A | Point | 1 | 1 | 700 - 799 | - | S254101 | 700-799 EDINBURG ST | 700-799 EDINBURGH ST | F | F | - | F | 5092000 | 5092000 | - | - | EAST SIDE | - | - | - | - | FRANCE AVE | FRANCE AVE | 89483 | 89483 | 37.717325448 | -122.434883871 | - | - | 1710539427000 | MTA | NPRK 11AM-1PM FRI STCL | FRANCE AVE to ITALY AVE (700 - 799) | - | NPL 747 | - | - | - | - | - | 85476 | - | -122.43494288 | 37.71734808 | - | - | - | D11 | - | STREET CLEANING | REG | R30B(CA).0026 | 18X18 | SUP2 | 2IN IRON POST | IS | 1557131520000 | EDINBURGH ST | 700 - 799 EDINBURGH ST | 700 - 799 EDINBURGH ST | 700 EDINBURGH ST | - | ITALY AVE | ITALY AVE |
| 68361 | N/A | Point | - | - | - | - | S106241 | ATHENS ST: AMAZON AVE | - | F | F | - | F | 21406000 | 21406000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | AMAZON AVE | ATHENS ST | 90297 | 90297 | 37.714665613 | -122.433631063 | ATHENS ST \ AMAZON AVE | AMAZON AVE \ ATHENS ST | 1710539427000 | MTA | STOP | ATHENS ST intersection | - | 0 / 0 | - | - | - | - | - | 85477 | 130982400000 | -122.43363911 | 37.7147519 | - | 1508457600000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569500000 | AMAZON AVE | - | - | - | - | - | - |
| 68362 | N/A | Point | - | - | - | - | S106271 | LOWELL ST: HANOVER ST | - | F | F | - | F | 21493000 | 21493000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | LOWELL ST | LOWELL ST | 90300 | 90300 | 37.708661576 | -122.444779507 | HANOVER ST \ LOWELL ST | HANOVER ST \ LOWELL ST | 1710539427000 | MTA | STOP | LOWELL ST intersection | - | 0 / 0 | - | - | - | - | - | 85478 | 132364800000 | -122.44483941 | 37.70858377 | - | 1519344000000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569500000 | HANOVER ST | - | - | - | - | - | - |
| 68363 | N/A | Point | 1 | 1 | 700 - 799 | - | S258903 | 700-799 BUENA VISTA WEST AVE | 700-799 BUENA VISTA AVE WEST | F | F | - | F | 3369000 | 3369000 | - | - | EAST SIDE | - | - | - | - | BUENA VISTA AVE \ FREDERICK ST | BUENA VISTA AVE \ FREDERICK ST | 90317 | 90317 | 37.76824005 | -122.44361094 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM THUR STCL | BUENA VISTA AVE \ FREDERICK ST to BUENA VISTA AVE \ CENTRAL AVE (700 - 799) | - | OPP. 767 75 FT SOUTH OF CENTRAL | - | - | - | - | - | 85479 | 1573128000000 | -122.44361094 | 37.76824005 | - | 1573084800000 | - | D8 | - | STREET CLEANING | REG | R30B(CA).0304 | 18X18 | SUP2 | LIGHT POLE | IS | 1572603780000 | BUENA VISTA AVE WEST | 700 - 799 BUENA VISTA AVE WEST | 700 - 799 BUENA VISTA AVE WEST | 700 BUENA VISTA AVE WEST | - | BUENA VISTA AVE \ CENTRAL AVE | BUENA VISTA AVE \ CENTRAL AVE |
| 68364 | N/A | Point | 1 | 1 | 100 - 199 | - | S271830 | 100-199 EXCELSIOR AVE | 100-199 EXCELSIOR AVE | F | F | - | F | 5360000 | 5360000 | - | - | NORTH SIDE | - | - | - | - | LONDON ST | LONDON ST | 90333 | 90333 | 37.725853462 | -122.432709356 | - | - | 1710539427000 | MTA | TA (SYM) NO STOPPING EXC PERMITTED CSV- ZIPCARS | LONDON ST to PARIS ST (100 - 199) | - | 18 FT EAST OF LONDON | - | - | - | - | - | 85480 | 1613545920000 | -122.43245544 | 37.7256795 | - | - | - | D11 | - | OTHER REGULATORY | REG | R37(SF).0291 | 05X12 | SUP2 | 2IN IRON POST | IS | 1611650160000 | EXCELSIOR AVE | 100 - 199 EXCELSIOR AVE | 100 - 199 EXCELSIOR AVE | 100 EXCELSIOR AVE | - | PARIS ST | PARIS ST |
| 68365 | N/A | Point | - | - | - | - | S257012 | PAGE ST: 12TH ST \ MARKET ST | - | F | F | - | F | 30749000 | 30749000 | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | - | - | - | - | 12TH ST \ MARKET ST | 12TH ST \ PAGE ST | 90428 | 90428 | 37.774401082 | -122.420234834 | PAGE ST \ 12TH ST \ MARKET ST | MARKET ST \ 12TH ST \ PAGE ST | 1710539427000 | MTA | SKEWED RAILROAD CROSSING (R TO L) | 12TH ST \ PAGE ST intersection | - | ABOVE NO RIGHT TURN ON RED | - | - | - | - | - | 85481 | 1566998580000 | -122.42025428 | 37.77435868 | - | - | - | D5 | - | OTHER WARNING | WARNING | W10-12.0002 | 30X30 | SUP1 | MUNI POLE | IS | 1565776980000 | MARKET ST | - | - | - | - | - | - |
| 68366 | N/A | Point | 1 | 1 | 200 - 299 | - | S255994 | 200-299 7TH AVE | 200-299 07TH AVE | F | F | - | F | 351000 | 351000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | CALIFORNIA ST \ CORNWALL ST | CALIFORNIA ST \ CORNWALL ST | 90473 | 90473 | 37.7832181110523 | -122.465448802253 | - | - | 1753384153000 | elclark | SPEED HUMPS | CALIFORNIA ST \ CORNWALL ST to CLEMENT ST (200 - 299) | - | NPL 290 | - | - | - | - | - | 85482 | 1565725980000 | -122.46556235 | 37.78387176 | - | - | - | D1 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1562829720000 | 07TH AVE | 200 - 299 07TH AVE | 200 - 299 07TH AVE | 200 7TH AVE | - | CLEMENT ST | CLEMENT ST |
| 68367 | N/A | Point | 1 | 1 | 600 - 699 | - | S255995 | 600-699 7TH AVE | 600-699 07TH AVE | F | F | - | F | 355000 | 355000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | BALBOA ST | BALBOA ST | 90474 | 90474 | 37.77625311 | -122.46501023 | - | - | 1715011839000 | middleware_editor | SPEED HUMPS | BALBOA ST to CABRILLO ST (600 - 699) | - | NPL 688 | - | - | - | - | - | 85483 | 1565266320000 | -122.46501023 | 37.77625311 | - | - | - | D1 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1562830020000 | 07TH AVE | 600 - 699 07TH AVE | 600 - 699 07TH AVE | 600 7TH AVE | - | CABRILLO ST | CABRILLO ST |
| 68368 | N/A | Point | 1 | 1 | 1 - 6 | - | S257220 | 1-9 CANYON DR | 1-6 CANYON DR | F | F | - | F | 11098000 | 3651000 | - | - | EAST SIDE | - | - | - | - | LAPHAM WAY | ROBINSON DR | 90496 | 90496 | 37.708849114 | -122.429682016 | - | - | 1721427872000 | middleware_editor | NPRK 12NN-2PM THUR STCL | ROBINSON DR to SOUTH HILL BLVD (1 - 6) | - | 30FT SOUTH OF LAPHAM | - | - | - | - | - | 85484 | 1575467340000 | -122.42959261 | 37.70886892 | - | 1721398200000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0080 | 18X18 | SUP2 | 2IN IRON POST | IS | 1566392940000 | CANYON DR | 1 - 21 ROBINSON DR | 1 - 6 CANYON DR | 1 CANYON DR | - | CANYON DR | SOUTH HILL BLVD |
| 68369 | N/A | Point | 1 | 1 | 1 - 6 | - | S257221 | 1-9 CANYON DR | 1-6 CANYON DR | F | F | - | F | 3651000 | 3651000 | - | - | NORTH SIDE | - | - | - | - | ROBINSON DR | ROBINSON DR | 90497 | 90497 | 37.708941067 | -122.429707051 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM THUR STCL | ROBINSON DR to SOUTH HILL BLVD (1 - 6) | - | 25 FT EAST OF SOUTH HILL | - | - | - | - | - | 85485 | 1575469860000 | -122.42959261 | 37.70886892 | - | 1595548800000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0080 | 18X18 | SUP2 | 2IN IRON POST | IS | 1566393180000 | CANYON DR | 1 - 6 CANYON DR | 1 - 6 CANYON DR | 1 CANYON DR | - | SOUTH HILL BLVD | SOUTH HILL BLVD |
| 68370 | N/A | Point | - | - | - | - | S256986 | ATHENS ST: BRAZIL AVE | - | F | F | - | F | 21635000 | 21635000 | - | - | SOUTH WEST CORNER | - | - | - | - | ATHENS ST | BRAZIL AVE | 90568 | 90568 | 37.721616283 | -122.428551041 | BRAZIL AVE \ ATHENS ST | ATHENS ST \ BRAZIL AVE | 1710539427000 | MTA | ATHENS ST | BRAZIL AVE intersection | - | - | - | - | - | - | - | 85486 | 127440000000 | -122.42843213 | 37.72163467 | - | 1566864000000 | - | D11 | - | STREET NAME | GUIDE | D3-1.0142 | 36X08 | SUP2 | 3IN IRON POST | IS | 1565684940000 | ATHENS ST | - | - | - | - | - | - |
| 68371 | N/A | Point | 1 | 1 | 235 - 299 | - | S259740 | 235-299 FRONT ST | 235-299 FRONT ST | F | F | - | F | 5870000 | 5870000 | - | - | WEST SIDE | - | - | - | - | HALLECK ST | HALLECK ST | 91180 | 91180 | 37.794103148 | -122.398986082 | - | - | 1710539427000 | MTA | BIKE RACK | HALLECK ST to SACRAMENTO ST (235 - 299) | 84107 | NPL 245/3.5' IN FROM CURB | - | - | - | - | - | 85487 | 1576162980000 | -122.39892534 | 37.79406405 | - | - | - | D3 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1576072200000 | FRONT ST | 235 - 299 FRONT ST | 235 - 299 FRONT ST | 235 FRONT ST | - | SACRAMENTO ST | SACRAMENTO ST |
| 68372 | N/A | Point | 1 | 1 | 235 - 299 | - | S259744 | 235-299 FRONT ST | 235-299 FRONT ST | F | F | - | F | 5870000 | 5870000 | - | - | WEST SIDE | - | - | - | - | HALLECK ST | HALLECK ST | 91181 | 91181 | 37.794063657 | -122.398978074 | - | - | 1710539427000 | MTA | BIKE RACK | HALLECK ST to SACRAMENTO ST (235 - 299) | 84107 | 21' S OF NPL 245/3.5' IN FROM CURB | - | - | - | - | - | 85488 | 1576163040000 | -122.39892534 | 37.79406405 | - | - | - | D3 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1576073760000 | FRONT ST | 235 - 299 FRONT ST | 235 - 299 FRONT ST | 235 FRONT ST | - | SACRAMENTO ST | SACRAMENTO ST |
| 68373 | N/A | Point | - | - | - | - | S260328 | MARKET ST: 12TH ST \ PAGE ST | - | T | T | - | F | 30749000 | 30749000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 12TH ST \ MARKET ST | 12TH ST \ PAGE ST | 91190 | 91190 | 37.774373289 | -122.420609096 | PAGE ST \ 12TH ST \ MARKET ST | MARKET ST \ 12TH ST \ PAGE ST | 1710539427000 | MTA | NO RIGHT TURN (SYM) | 12TH ST \ PAGE ST intersection | - | - | - | - | - | - | - | 85489 | 1580688000000 | -122.42025428 | 37.77435868 | - | - | - | D5 | - | NO RIGHT TURN | REG | R3-1.0002 | 30X30 | SUP1 | SIGNAL POLE | IS | 1579008600000 | MARKET ST | - | - | - | - | - | - |
| 68374 | N/A | Point | - | - | - | - | S260333 | PAGE ST: 12TH ST \ MARKET ST | - | T | T | - | F | 30749000 | 30749000 | - | - | NORTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 12TH ST \ MARKET ST | 12TH ST \ PAGE ST | 91193 | 91193 | 37.774265565 | -122.42067691 | PAGE ST \ 12TH ST \ MARKET ST | MARKET ST \ 12TH ST \ PAGE ST | 1710539427000 | MTA | DO NOT ENTER/ BIKE (SYM) OK | 12TH ST \ PAGE ST intersection | - | - | - | - | - | - | - | 85490 | 1580822820000 | -122.42025428 | 37.77435868 | - | - | - | D5 | - | OTHER REGULATORY | REG | R5-1(SF).0015 | 30X36 | SUP1 | SIGNAL POLE | IS | 1579010160000 | MARKET ST | - | - | - | - | - | - |
| 68375 | N/A | Point | 1 | 1 | 2800 - 2851 | - | S284290 | 2800-2851 16TH ST | 2800-2851 16TH ST | F | F | - | F | 721000 | 721000 | - | - | SOUTH SIDE | - | - | - | - | FOLSOM ST | FOLSOM ST | 92269 | 92269 | 37.765249028 | -122.415483962 | - | - | 1710539427000 | MTA | DELINEATOR (W) (SAFE HIT) | FOLSOM ST to SHOTWELL ST (2800 - 2851) | - | 10 W FOLSOM/ON E LINE/5'FROM CURB | - | - | - | - | - | 85491 | 1671148800000 | -122.41584796 | 37.76528207 | - | - | - | D9 | - | DELINEATOR 5 | WARNING | TYPE-DL.0001 | 03X36 | SUP2 | DELINEATOR BASE SAFE HIT | IS | 1659433500000 | 16TH ST | 2800 - 2851 16TH ST | 2800 - 2851 16TH ST | 2800 16TH ST | - | SHOTWELL ST | SHOTWELL ST |
| 68376 | N/A | Point | 1 | 1 | 2800 - 2851 | - | S284292 | 2800-2851 16TH ST | 2800-2851 16TH ST | F | F | - | F | 721000 | 721000 | - | - | SOUTH SIDE | - | - | - | - | FOLSOM ST | FOLSOM ST | 92271 | 92271 | 37.765248497 | -122.415482621 | - | - | 1710539427000 | MTA | DELINEATOR (W) (SAFE HIT) | FOLSOM ST to SHOTWELL ST (2800 - 2851) | - | 10 W FOLSOM/ON W LINE/5'FROM CURB | - | - | - | - | - | 85492 | 1671148800000 | -122.41584796 | 37.76528207 | - | - | - | D9 | - | DELINEATOR 5 | WARNING | TYPE-DL.0001 | 03X36 | SUP2 | DELINEATOR BASE SAFE HIT | IS | 1659433500000 | 16TH ST | 2800 - 2851 16TH ST | 2800 - 2851 16TH ST | 2800 16TH ST | - | SHOTWELL ST | SHOTWELL ST |
| 68377 | N/A | Point | 1 | 1 | 2800 - 2851 | - | S284294 | 2800-2851 16TH ST | 2800-2851 16TH ST | F | F | - | F | 721000 | 721000 | - | - | SOUTH SIDE | - | - | - | - | FOLSOM ST | FOLSOM ST | 92272 | 92272 | 37.76524894 | -122.415483962 | - | - | 1710539427000 | MTA | WHEEL STOP | FOLSOM ST to SHOTWELL ST (2800 - 2851) | - | 10 W FOLSOM/ON E LINE/6" FROM CURB | - | - | - | - | - | 85493 | 1671148800000 | -122.41584796 | 37.76528207 | - | - | - | D9 | - | OTHER WARNING | WARNING | W(SF).0072 | 36X08 | SUP2 | SPIKE | IS | 1659433560000 | 16TH ST | 2800 - 2851 16TH ST | 2800 - 2851 16TH ST | 2800 16TH ST | - | SHOTWELL ST | SHOTWELL ST |
| 68378 | N/A | Point | - | - | - | - | S260035 | SAN BRUNO AVE: BACON ST | - | T | T | - | F | 33647000 | 33647000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BACON ST | BACON ST | 92295 | 92295 | 37.727479972 | -122.40345878 | SAN BRUNO AVE \ BACON ST | SAN BRUNO AVE \ BACON ST | 1710539427000 | MTA | EXCEPT MUNI | BACON ST intersection | - | ABOVE TOW AWAY SIGN | - | - | - | - | - | 85494 | 1238371200000 | -122.40359289 | 37.72763413 | - | 1579651200000 | - | D9 | - | OTHER REGULATORY | REG | R(SF).0357 | 30X08 | SUP2 | LIGHT POLE | IS | 1577953440000 | SAN BRUNO AVE | - | - | - | - | - | - |
| 68379 | N/A | Point | 1 | 1 | 834 - 899 | - | S270612 | 834-899 CLAYTON ST | 834-899 CLAYTON ST | T | T | - | F | 4135000 | 4135000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | CARL ST | CARL ST | 92551 | 92551 | 37.76560548 | -122.44772921 | - | - | 1710539427000 | MTA | SPEED HUMPS | CARL ST to PARNASSUS AVE (834 - 899) | - | NPL # 858 CLAYTON | - | - | - | - | - | 85495 | 1608294600000 | -122.44772921 | 37.76560548 | - | - | - | D5 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1606915740000 | CLAYTON ST | 834 - 899 CLAYTON ST | 834 - 899 CLAYTON ST | 834 CLAYTON ST | - | PARNASSUS AVE | PARNASSUS AVE |
| 68380 | N/A | Point | - | - | - | - | S270613 | CLAYTON ST: FREDERICK ST | - | T | T | - | F | 26403000 | 26403000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CLAYTON ST | FREDERICK ST | 92552 | 92552 | 37.766900266 | -122.448066133 | FREDERICK ST \ CLAYTON ST | CLAYTON ST \ FREDERICK ST | 1710539427000 | MTA | SPEED HUMPS | FREDERICK ST intersection | - | - | - | - | - | - | - | 85496 | 1608293400000 | -122.44801316 | 37.76700668 | - | - | - | D5 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1606915920000 | CLAYTON ST | - | - | - | - | - | - |
| 68381 | N/A | Point | - | - | - | - | S270615 | CLAYTON ST: FREDERICK ST | - | T | T | - | F | 26403000 | 26403000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CLAYTON ST | FREDERICK ST | 92554 | 92554 | 37.766906628 | -122.448066636 | FREDERICK ST \ CLAYTON ST | CLAYTON ST \ FREDERICK ST | 1710539427000 | MTA | AHEAD | FREDERICK ST intersection | - | - | - | - | - | - | - | 85497 | 1608294480000 | -122.44801316 | 37.76700668 | - | - | - | D5 | - | OTHER WARNING | WARNING | W(SF).0106 | 18X06 | SUP1 | LIGHT POLE | IS | 1606916340000 | CLAYTON ST | - | - | - | - | - | - |
| 68382 | N/A | Point | - | - | - | - | S270735 | JUDSON AVE: EDNA ST | - | F | F | - | F | 22158000 | 22158000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | EDNA ST | EDNA ST | 92555 | 92555 | 37.72827496 | -122.44655943 | JUDSON AVE \ EDNA ST | JUDSON AVE \ EDNA ST | 1720056835000 | middleware_editor | SPEED HUMPS AHEAD | EDNA ST intersection | - | 0 / 0 | - | - | - | - | - | 85498 | 300412800000 | -122.44655943 | 37.72827496 | - | 1618358400000 | - | D7 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1607601120000 | JUDSON AVE | - | - | - | - | - | - |
| 68383 | N/A | Point | 1 | 1 | 100 - 199 | - | S270739 | 100-199 JUDSON AVE | 100-199 JUDSON AVE | F | F | - | F | 7687000 | 7687000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | CIRCULAR AVE \ DETROIT ST \ PAULDING ST | CIRCULAR AVE \ DETROIT ST \ PAULDING ST | 92556 | 92556 | 37.7282808 | -122.44541621 | - | - | 1754433705000 | middleware_editor | SPEED HUMPS AHEAD | CIRCULAR AVE \ DETROIT ST \ PAULDING ST to EDNA ST (100 - 199) | - | 116 JUDSON | - | - | - | - | - | 85499 | 1222671600000 | -122.44541621 | 37.7282808 | - | 1618470000000 | - | D7 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1607601540000 | JUDSON AVE | 100 - 199 JUDSON AVE | 100 - 199 JUDSON AVE | 100 JUDSON AVE | - | EDNA ST | EDNA ST |
| 68384 | N/A | Point | - | - | - | - | S260036 | SAN BRUNO AVE: BACON ST | - | T | T | - | F | - | 33647000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | - | BACON ST | 92576 | 92576 | 37.72755988 | -122.403481578 | - | SAN BRUNO AVE \ BACON ST | 1710539427000 | MTA | RIGHT LANE MUST TURN RIGHT | BACON ST intersection | - | ABOVE EXCEPT MUNI SIGN | - | - | - | - | - | 85500 | 1238371200000 | -122.40359289 | 37.72763413 | - | - | - | D9 | - | OTHER REGULATORY | REG | R3-7.0005 | 30X30 | SUP2 | LIGHT POLE | IS | 1577953560000 | SAN BRUNO AVE | - | - | - | - | - | - |
| 68385 | N/A | Point | - | - | - | - | S280991 | DRUMM ST: WASHINGTON ST | - | F | F | - | F | 24571000 | 24571000 | - | - | NORTH EAST CORNER | - | - | - | - | WASHINGTON ST | DRUMM ST | 92596 | 92596 | 37.79634686 | -122.39695784 | DRUMM ST \ WASHINGTON ST | WASHINGTON ST \ DRUMM ST | 1710539427000 | MTA | TREE TOP 6FT SPEED BUMP | DRUMM ST intersection | - | - | - | - | - | - | - | 85501 | 1645056000000 | -122.39695784 | 37.79634686 | - | - | - | D3 | - | OTHER WARNING | WARNING | W(SF).0109 | 72X18 | SUP1 | ANCHORS | IS | 1645109880000 | WASHINGTON ST | - | - | - | - | - | - |
| 68386 | N/A | Point | 1 | 1 | 2800 - 2851 | DOWN ARROW | S282341 | 2800-2851 16TH ST | 2800-2851 16TH ST | T | T | - | F | 721000 | 721000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | FOLSOM ST | FOLSOM ST | 92609 | 92609 | 37.765334725 | -122.416278455 | - | - | 1710539427000 | MTA | SHOTWELL SLOW ST FAMILY,H/C,PED,SKATEBORRD,BIKE (SYM)(COMBO) | FOLSOM ST to SHOTWELL ST (2800 - 2851) | - | 32' EAST OF SHOTWELL ABOVE SIGNS | - | - | - | - | - | 85502 | 1659571200000 | -122.41584796 | 37.76528207 | - | - | - | D9 | - | OTHER REGULATORY | REG | R(SF).0466 | 24X30 | SUP2 | MUNI POLE | IS | 1650451320000 | 16TH ST | 2800 - 2851 16TH ST | 2800 - 2851 16TH ST | 2800 16TH ST | - | SHOTWELL ST | SHOTWELL ST |
| 68387 | N/A | Point | 1 | 1 | 3153 - 3199 | - | S283400 | 3140-3199 16TH ST | 3153-3199 16TH ST | F | F | - | F | 734000 | 734000 | - | - | NORTH SIDE | - | - | - | - | ALBION ST | ALBION ST | 94251 | 94251 | 37.7648701 | -122.423948861 | - | - | 1710539427000 | MTA | NPRK 2AM-6AM TUE THUR SUN STCL | ALBION ST to GUERRERO ST (3153 - 3199) | - | 7 FT EAST OF GUERRERO | - | - | - | - | - | 85503 | 1657238400000 | -122.42360755 | 37.76481338 | - | - | - | D8 | - | STREET CLEANING | REG | R30B(CA).0134 | 18X18 | SUP2 | MUNI POLE | IS | 1655197020000 | 16TH ST | 3153 - 3199 16TH ST | 3153 - 3199 16TH ST | 3153 16TH ST | - | GUERRERO ST | GUERRERO ST |
| 68388 | N/A | Point | 1 | 1 | 1600 - 1699 | - | S281252 | 1600-1699 25TH ST | 1600-1699 25TH ST | F | F | - | F | 1412000 | 1412000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | DAKOTA ST \ TEXAS ST | DAKOTA ST \ TEXAS ST | 94272 | 94272 | 37.75239784 | -122.39506738 | - | - | 1711239446000 | middleware_editor | SPEED HUMP | DAKOTA ST \ TEXAS ST to MISSOURI ST (1600 - 1699) | - | 20' WEST OF DAKOTA/TEXAS ST. | - | - | - | - | - | 85504 | 1646956800000 | -122.39506738 | 37.75239784 | - | - | - | D10 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1646314920000 | 25TH ST | 1600 - 1699 25TH ST | 1600 - 1699 25TH ST | 1600 25TH ST | - | MISSOURI ST | MISSOURI ST |
| 68389 | N/A | Point | 1 | 1 | 1700 - 1799 | - | S281254 | 1700-1799 25TH ST | 1700-1799 25TH ST | T | T | - | F | 1413000 | 1413000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | MISSOURI ST | MISSOURI ST | 94273 | 94273 | 37.75233981 | -122.39603063 | - | - | 1710539427000 | MTA | SPEED HUMP | MISSOURI ST to CONNECTICUT ST (1700 - 1799) | - | 7' EAST OF CONNECTICUT ST. | - | - | - | - | - | 85505 | 1646956800000 | -122.39603063 | 37.75233981 | - | - | - | D10 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1646315040000 | 25TH ST | 1700 - 1799 25TH ST | 1700 - 1799 25TH ST | 1700 25TH ST | - | CONNECTICUT ST | CONNECTICUT ST |
| 68390 | N/A | Point | - | - | - | - | S281390 | PLYMOUTH AVE: GRAFTON AVE | - | F | F | - | F | 22576000 | 22576000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | GRAFTON AVE | GRAFTON AVE | 94278 | 94278 | 37.7200333 | -122.4561335 | PLYMOUTH AVE \ GRAFTON AVE | PLYMOUTH AVE \ GRAFTON AVE | 1718304017000 | middleware_editor | SPEED HUMPS AHEAD | GRAFTON AVE intersection | - | - | - | - | - | - | - | 85506 | 1647388800000 | -122.4561335 | 37.7200333 | - | - | - | D11 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1646822160000 | PLYMOUTH AVE | - | - | - | - | - | - |
| 68391 | N/A | Point | 1 | 1 | 1000 - 1099 | - | S281391 | 1000-1099 PLYMOUTH AVE | 1000-1099 PLYMOUTH AVE | F | F | - | F | 10521000 | 10521000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | GRAFTON AVE | GRAFTON AVE | 94279 | 94279 | 37.72093958 | -122.45613749 | - | - | 1720575800000 | middleware_editor | SPEED HUMPS AHEAD | GRAFTON AVE to HOLLOWAY AVE (1000 - 1099) | - | IFO 1095 | - | - | - | - | - | 85507 | 1647388800000 | -122.45613749 | 37.72093958 | - | - | - | D11 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1646822580000 | PLYMOUTH AVE | 1000 - 1099 PLYMOUTH AVE | 1000 - 1099 PLYMOUTH AVE | 1000 PLYMOUTH AVE | - | HOLLOWAY AVE | HOLLOWAY AVE |
| 68392 | N/A | Point | - | - | - | - | S270283 | DIAMOND HEIGHTS BLVD: DUNCAN S | - | F | F | - | F | 22038000 | 22038000 | - | - | CENTER ISLAND, E LINE, EASTBOUND | - | - | - | - | DUNCAN ST | DUNCAN ST | 94287 | 94287 | 37.745371863 | -122.440134318 | DIAMOND HEIGHTS BLVD \ DUNCAN ST | DIAMOND HEIGHTS BLVD \ DUNCAN ST | 1710539427000 | MTA | (45 RA-DN) | DUNCAN ST intersection | - | AT CROSSWALK ( END ) DUNCAN | - | - | - | - | - | 85508 | 1022716800000 | -122.44008805 | 37.74529604 | - | 1606867200000 | - | D8 | - | OTHER WARNING | WARNING | W16-7P.0006 | 24X12 | SUP2 | LIGHT POLE | IS | 1605862260000 | DIAMOND HEIGHTS BLVD | - | - | - | - | - | - |
| 68393 | N/A | Point | - | - | - | - | S270286 | DIAMOND HEIGHTS BLVD: DUNCAN S | - | F | F | - | F | 22038000 | 22038000 | - | - | CENTER ISLAND, E LINE, WESTBOUND | - | - | - | - | DUNCAN ST | DUNCAN ST | 94288 | 94288 | 37.745369742 | -122.440188633 | DIAMOND HEIGHTS BLVD \ DUNCAN ST | DIAMOND HEIGHTS BLVD \ DUNCAN ST | 1710539427000 | MTA | PEDESTRIAN (SYM) | DUNCAN ST intersection | - | AT CROSSWALK ( END ) DUNCAN | - | - | - | - | - | 85509 | 1022716800000 | -122.44008805 | 37.74529604 | - | 1606867200000 | - | D8 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP2 | LIGHT POLE | IS | 1605862980000 | DIAMOND HEIGHTS BLVD | - | - | - | - | - | - |
| 68394 | N/A | Point | - | - | - | - | S271142 | 20TH AVE: VICENTE ST | - | F | F | - | F | 23168000 | 23168000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | VICENTE ST | 20TH AVE | 96635 | 96635 | 37.73927734 | -122.47648597 | 20TH AVE \ VICENTE ST | VICENTE ST \ 20TH AVE | 1719278483000 | middleware_editor | SPEED HUMPS AHEAD | 20TH AVE intersection | - | - | - | - | - | - | - | 85510 | 139190400000 | -122.47648597 | 37.73927734 | - | 1644969600000 | - | D4 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1609248960000 | VICENTE ST | - | - | - | - | - | - |
| 68395 | N/A | Point | 1 | 1 | 700 - 799 | - | S285316 | 700-799 MOSCOW ST | 700-799 MOSCOW ST | F | F | - | F | 9403000 | 9403000 | - | - | EAST SIDE | - | - | - | - | FRANCE AVE | FRANCE AVE | 96715 | 96715 | 37.71630817 | -122.43130142 | - | - | 1710539427000 | MTA | BIKE RACK | FRANCE AVE to ITALY AVE (700 - 799) | 542900 | 78' S OF ITALY/3' IN FROM CURB | - | - | - | - | - | 85511 | 1664755200000 | -122.43173862 | 37.71581592 | - | - | - | D11 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1664465460000 | MOSCOW ST | 700 - 799 MOSCOW ST | 700 - 799 MOSCOW ST | 700 MOSCOW ST | - | ITALY AVE | ITALY AVE |
| 68396 | N/A | Point | - | - | - | - | S285419 | GENEVA AVE: LONDON ST | - | F | F | - | F | 21475000 | 21475000 | - | - | CENTER ISLAND, E LINE, EASTBOUND | - | - | - | - | LONDON ST | GENEVA AVE | 96830 | 96830 | 37.71597941 | -122.440117453 | GENEVA AVE \ LONDON ST | LONDON ST \ GENEVA AVE | 1710539427000 | MTA | NO LEFT TURN (SYM) 7AM-9AM/4PM-6PM MON-FRI | GENEVA AVE intersection | - | ABOVE NO U TURN SIGN | - | - | - | - | - | 85512 | 1671580800000 | -122.44025514 | 37.71603882 | - | - | - | D11 | - | NO LEFT TURN | REG | R33A(CA).0023 | 30X48 | SUP2 | LIGHT POLE | IS | 1665136440000 | LONDON ST | - | - | - | - | - | - |
| 68397 | N/A | Point | - | - | - | - | S285420 | GENEVA AVE: LONDON ST | - | F | F | - | F | 21475000 | 21475000 | - | - | CENTER ISLAND, W LINE, EASTBOUND | - | - | - | - | LONDON ST | GENEVA AVE | 96831 | 96831 | 37.716093986 | -122.440396403 | GENEVA AVE \ LONDON ST | LONDON ST \ GENEVA AVE | 1710539427000 | MTA | NO LEFT TURN (SYM) 7AM-9AM/4PM-6PM MON-FRI | GENEVA AVE intersection | - | ABOVE NO U TURN SIGN | - | - | - | - | - | 85513 | 1671580800000 | -122.44025514 | 37.71603882 | - | - | - | D11 | - | NO LEFT TURN | REG | R33A(CA).0023 | 30X48 | SUP2 | LIGHT POLE | IS | 1665136560000 | LONDON ST | - | - | - | - | - | - |
| 68398 | N/A | Point | - | - | - | - | S285421 | GENEVA AVE: LONDON ST | - | T | T | - | F | 21475000 | 21475000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | LONDON ST | GENEVA AVE | 96832 | 96832 | 37.715908685 | -122.440242623 | GENEVA AVE \ LONDON ST | LONDON ST \ GENEVA AVE | 1710539427000 | MTA | LONDON | GENEVA AVE intersection | - | - | - | - | - | - | - | 85514 | 1678060800000 | -122.44025514 | 37.71603882 | - | - | - | D11 | - | STREET NAME | GUIDE | D3-2.0497 | 72X18 | SUP2 | OVERHEAD MAST ARM | IS | 1665136920000 | LONDON ST | - | - | - | - | - | - |
| 68399 | N/A | Point | 1 | 1 | 1100 - 1199 | - | S287791 | 1100-1199 VALENCIA ST | 1100-1199 VALENCIA ST | F | F | - | F | 13071000 | 13071000 | - | - | EAST SIDE | - | - | - | - | 22ND ST | 22ND ST | 99453 | 99453 | 37.754544534 | -122.420872027 | - | - | 1710539427000 | MTA | BIKE RACK | 22ND ST to 23RD ST (1100 - 1199) | - | 30' S OF 22ND ST/ 1.5' IN FROM CURB | - | - | - | - | - | 85515 | 1677801600000 | -122.42088812 | 37.75449894 | - | - | - | D8 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1677661020000 | VALENCIA ST | 1100 - 1199 VALENCIA ST | 1100 - 1199 VALENCIA ST | 1100 VALENCIA ST | - | 23RD ST | 23RD ST |
| 68400 | N/A | Point | 1 | 1 | 1100 - 1199 | - | S287792 | 1100-1199 VALENCIA ST | 1100-1199 VALENCIA ST | F | F | - | F | 13071000 | 13071000 | - | - | EAST SIDE | - | - | - | - | 22ND ST | 22ND ST | 99454 | 99454 | 37.754544534 | -122.420837158 | - | - | 1710539427000 | MTA | BIKE RACK | 22ND ST to 23RD ST (1100 - 1199) | - | 38.5' S OF 22ND ST/ 1.5' IN FROM CURB | - | - | - | - | - | 85516 | 1677801600000 | -122.42088812 | 37.75449894 | - | - | - | D8 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1677661200000 | VALENCIA ST | 1100 - 1199 VALENCIA ST | 1100 - 1199 VALENCIA ST | 1100 VALENCIA ST | - | 23RD ST | 23RD ST |
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 meters