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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 86626 | N/A | Point | - | - | - | - | S124999 | - | - | NO | NO | - | - | - | - | - | - | EAST SIDE | 1691445421000 | MTA | - | - | 19TH ST | - | 145371 | 145371 | 37.759434 | -122.419129 | - | - | 1736534602000 | middleware_editor | NO DBL PRK ANY TIME DBL FINE ZONE $135 6AM-9AM/ETC | - | - | - | - | - | - | - | - | 103805 | 1155600000000 | -122.419129 | 37.759434 | - | - | - | 09 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0003 | 18X21 | SUP3 | LIGHT POLE | IS | - | - | - | - | - | - | 20TH ST | - |
| 86627 | N/A | Point | - | - | - | - | S125000 | - | - | NO | NO | - | - | - | - | - | - | EAST SIDE | 1691445421000 | MTA | - | - | 19TH ST | - | 145372 | 145372 | 37.759434 | -122.419129 | - | - | 1736534600000 | middleware_editor | NO DBL PRK ANY TIME DBL FINE ZONE $135 6AM-9AM/ETC | - | - | - | - | - | - | - | - | 103806 | 1155600000000 | -122.419129 | 37.759434 | - | - | - | 09 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0003 | 18X21 | SUP3 | LIGHT POLE | IS | - | - | - | - | - | - | 20TH ST | - |
| 86628 | N/A | Point | - | - | - | - | S125001 | - | - | NO | NO | - | - | - | - | - | - | EAST SIDE | 1691445421000 | MTA | - | - | - | - | 145373 | 145373 | 37.757834 | -122.418977 | - | - | 1710539427000 | MTA | NO DBL PRK ANY TIME DBL FINE ZONE $135 6AM-9AM/ETC | - | - | - | - | - | - | - | - | 103807 | - | -122.418977 | 37.757834 | - | - | - | 09 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0003 | 18X21 | SUP3 | LIGHT POLE | In Service | - | - | - | - | - | - | - | - |
| 86629 | N/A | Point | - | - | - | - | S125002 | - | - | NO | NO | - | - | - | - | - | - | EAST SIDE | 1691445421000 | MTA | - | - | - | - | 145374 | 145374 | 37.757834 | -122.418977 | - | - | 1710539427000 | MTA | NO DBL PRK ANY TIME DBL FINE ZONE $135 6AM-9AM/ETC | - | - | - | - | - | - | - | - | 103808 | - | -122.418977 | 37.757834 | - | - | - | 09 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0003 | 18X21 | SUP3 | 2IN IRON POST | In Service | - | - | - | - | - | - | - | - |
| 86630 | N/A | Point | - | - | - | - | S125003 | - | - | NO | NO | - | - | - | - | - | - | EAST SIDE | 1691445421000 | MTA | - | - | - | - | 145375 | 145375 | 37.757834 | -122.418977 | - | - | 1710539427000 | MTA | NO DBL PRK ANY TIME DBL FINE ZONE $135 6AM-9AM/ETC | - | - | - | - | - | - | - | - | 103809 | - | -122.418977 | 37.757834 | - | - | - | 09 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0003 | 18X21 | SUP3 | LIGHT POLE | In Service | - | - | - | - | - | - | - | - |
| 86631 | N/A | Point | - | - | - | - | S249071 | - | - | NO | NO | - | - | - | - | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | 1691445421000 | MTA | - | - | CORAL RD | - | 145384 | 145384 | 37.753863 | -122.399524 | CAROLINA ST \ CORAL RD | - | 1710539427000 | MTA | SCHOOL (SYM) | - | - | - | - | - | - | - | - | 103810 | - | -122.399524 | 37.753863 | - | - | - | 10 | - | SCHOOL | WARNING | S1-1.0002 | 30X30 | SUP1 | LIGHT POLE | In Service | - | - | - | - | - | - | - | - |
| 86632 | N/A | Point | - | - | - | - | S100006 | - | - | NO | NO | - | - | - | - | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | 1691445421000 | MTA | - | - | DENSLOWE DR | - | 145420 | 145420 | 37.724906 | -122.474848 | 19TH AVE \ DENSLOWE DR | - | 1710539427000 | MTA | STOP | - | - | - | - | - | - | - | - | 103811 | - | -122.474848 | 37.724906 | - | - | - | 07 | - | STOP | REG | R1-1.0002 | 30X30 | SUP3 | UNKNOWN | In Service | - | - | - | - | - | - | - | - |
| 86633 | N/A | Point | - | - | - | - | S119469 | - | - | NO | NO | - | - | - | - | - | - | WEST SIDE | 1691445421000 | MTA | - | - | 18TH ST | - | 145428 | 145428 | 37.761036 | -122.419283 | - | - | 1710539427000 | MTA | NO DBL PRK ANY TIME DBL FINE ZONE $100 FINE IMPOSED ETC | - | - | - | - | - | - | - | - | 103812 | - | -122.419283 | 37.761036 | - | - | - | 09 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0001 | 18X21 | SUP3 | LIGHT POLE | In Service | - | - | - | - | - | - | 19TH ST | - |
| 86634 | N/A | Point | - | - | - | - | S119531 | - | - | NO | NO | - | - | - | - | - | - | EAST SIDE | 1691445421000 | MTA | - | - | 14TH ST | - | 145430 | 145430 | 37.767474 | -122.419903 | - | - | 1710539427000 | MTA | NO DBL PRK ANY TIME DBL FINE ZONE $100 FINE IMPOSED ETC | - | - | - | - | - | - | - | - | 103813 | - | -122.419903 | 37.767474 | - | - | - | 09 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0001 | 18X21 | SUP3 | LIGHT POLE | In Service | - | - | - | - | - | - | 15TH ST | - |
| 86635 | N/A | Point | - | - | - | - | 21966 | - | - | - | - | - | - | 12222000 | - | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | 1691095855000 | APADILLA | - | - | BAY ST | - | 144503 | 144503 | 37.806131472 | -122.410258011 | - | - | 1710539427000 | MTA | FREEWAY (RA) | - | - | - | - | - | - | - | - | 103814 | - | - | - | - | 1691148600000 | - | 03 | - | OTHER GUIDE | GUIDE | G-F(SF).0054 | 48X16 | SUP1 | SIGNAL POLE | IS | - | STOCKTON ST | 2200 - 2299 STOCKTON ST | - | - | - | NORTH POINT ST | - |
| 86636 | N/A | Point | - | - | - | - | 21974 | - | - | - | - | - | - | 8994000 | - | - | - | NORTH SIDE | 1691161418000 | jsanfel | - | - | MARKET ST | - | 144641 | 144641 | 37.761031629 | -122.443114653 | - | - | 1710539427000 | MTA | SPEED HUMP | - | - | ifo 3084 market st | - | - | - | - | - | 103815 | 1706002200000 | - | - | - | - | - | 08 | FLUORESCENT YELLOW GREEN | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP3 | LIGHT POLE | IS | - | MERRITT ST | 1 - 99 MERRITT ST | - | - | - | DANVERS ST | - |
| 86637 | N/A | Point | - | - | - | - | 22005 | - | - | F | F | - | F | 1078000 | - | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | 1691182116000 | MMENDIET | - | - | CABRILLO ST | - | 144769 | 144769 | 37.774522094 | -122.480111801 | - | - | 1710539427000 | MTA | SPEED HUMPS AHEAD | - | - | #703 NPL. | - | - | - | - | - | 103816 | 1704282300000 | - | - | - | - | - | 01 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | - | 21ST AVE | 700 - 799 21ST AVE | - | - | - | FULTON ST | - |
| 86638 | N/A | Point | 1 | 1 | 10 - 54 | LEFT ARROW | S239435 | 10-54 MCALLISTER ST | 10-54 MCALLISTER ST | F | F | - | F | 8888000 | 8888000 | - | - | SOUTH SIDE | - | - | - | - | JONES ST | JONES ST | 85037 | 85037 | 37.78106497 | -122.41258606 | - | - | 1741884391000 | middleware_editor | TANS EXC 30 MIN 6 WHEEL TL AT ALL TIMES | JONES ST to CHARLES J BRENHAM PL (10 - 54) | - | 103' W OF MARKET | - | - | - | - | - | 103817 | 1507839660000 | -122.41258606 | 37.78106497 | - | 1591599600000 | 1741880700000 | D6 | - | OTHER REGULATORY | REG | R37(SF).0340 | 18X21 | SUP1 | 2IN FLANGE POST | RETD | 1507801440000 | MCALLISTER ST | 10 - 54 MCALLISTER ST | 10 - 54 MCALLISTER ST | 10 MCALLISTER ST | - | CHARLES J BRENHAM PL | CHARLES J BRENHAM PL |
| 86639 | N/A | Point | 1 | 1 | 25 - 299 | RIGHT ARROW | S252294 | 25-299 NAPOLEON ST | 25-299 NAPOLEON ST | F | F | - | F | 9504000 | 9504000 | - | - | SOUTH SIDE | - | - | - | - | EVANS AVE \ TOLAND ST | EVANS AVE \ TOLAND ST | 87033 | 87033 | 37.747057057 | -122.39740835 | - | - | 1753820133000 | middleware_editor | NPRK 12MN-6AM DAILY | EVANS AVE \ TOLAND ST to JERROLD AVE (25 - 299) | - | 340 WEST OF EVANS ST. | - | - | - | - | - | 103818 | 1557171840000 | -122.39907132 | 37.7467771 | - | 1573113600000 | - | D10 | - | PARKING | REG | R30(CA).0045 | 18X18 | SUP1 | 2IN IRON POST | IS | 1552311480000 | NAPOLEON ST | 25 - 299 NAPOLEON ST | 25 - 299 NAPOLEON ST | 25 NAPOLEON ST | - | JERROLD AVE | JERROLD AVE |
| 86640 | N/A | Point | - | - | - | - | S240055 | FREDERICK ST: SHRADER ST | - | F | F | - | F | 26426000 | 26426000 | - | - | NORTH WEST CORNER | - | - | - | - | SHRADER ST | FREDERICK ST | 71969 | 71969 | 37.7665915 | -122.45129553 | FREDERICK ST \ SHRADER ST | SHRADER ST \ FREDERICK ST | 1710539427000 | MTA | SHRADER ST | FREDERICK ST intersection | - | 900 <-- SOUTH | - | - | - | - | - | 103819 | 1512489300000 | -122.45129553 | 37.7665915 | - | 1512432000000 | - | D5 | - | STREET NAME | GUIDE | D3-1.1631 | 36X08 | SUP1 | 3IN IRON POST | IS | 1509449520000 | SHRADER ST | - | - | - | - | - | - |
| 86641 | N/A | Point | - | - | - | - | S229849 | SHRADER ST: FREDERICK ST | - | F | F | - | F | 26426000 | 26426000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | SHRADER ST | FREDERICK ST | 66420 | 66420 | 37.7665915 | -122.45129553 | FREDERICK ST \ SHRADER ST | SHRADER ST \ FREDERICK ST | 1710539427000 | MTA | ALL WAY | FREDERICK ST intersection | - | X ST IS FREDERICK | - | - | - | - | - | 103820 | 1477316460000 | -122.45129553 | 37.7665915 | - | 1477267200000 | - | D5 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1476443640000 | SHRADER ST | - | - | - | - | - | - |
| 86642 | N/A | Point | 1 | 1 | 2000 - 2099 | - | S114550 | 2000-2099 37TH AVE | 2000-2099 37TH AVE | F | F | - | F | 1834000 | 1834000 | - | - | EAST SIDE | - | - | - | - | PACHECO ST | PACHECO ST | 10914 | 10914 | 37.7487616330562 | -122.495372488868 | - | - | 1743791741000 | middleware_editor | NPRK 2AM-6AM TUE THUR STCL | PACHECO ST to QUINTARA ST (2000 - 2099) | - | 250 FT SOUTH OF PACHECO | - | - | - | - | - | 103821 | 1010476800000 | -122.49543495 | 37.74872781 | - | - | - | D4 | - | STREET CLEANING | REG | R30B(CA).0133 | 18X18 | SUP2 | 2IN IRON POST | IS | 1373572080000 | 37TH AVE | 2000 - 2099 37TH AVE | 2000 - 2099 37TH AVE | 2000 37TH AVE | - | QUINTARA ST | QUINTARA ST |
| 86643 | N/A | Point | - | - | - | - | S114564 | 37TH AVE: PACHECO ST | - | F | F | - | F | 23422000 | 23422000 | - | - | WEST SIDE | - | - | - | - | 37TH AVE | 37TH AVE | 11052 | 11052 | 37.7496644116825 | -122.49559179816 | PACHECO ST \ 37TH AVE | PACHECO ST \ 37TH AVE | 1740168201000 | middleware_editor | NPRK 2AM-6AM TUE THUR STCL | 37TH AVE intersection | - | AT INTERSECTION | - | - | - | - | - | 103822 | 1010534400000 | -122.49550014 | 37.74966208 | - | - | - | D4 | - | STREET CLEANING | REG | R30B(CA).0133 | 18X18 | SUP2 | LIGHT POLE | IS | 1373572080000 | PACHECO ST | - | - | - | - | - | - |
| 86644 | N/A | Point | 1 | 1 | 2000 - 2099 | - | S205831 | 2000-2099 37TH AVE | 2000-2099 37TH AVE | T | T | - | F | 1834000 | 1834000 | - | - | WEST SIDE | - | - | - | - | PACHECO ST | PACHECO ST | 44615 | 44615 | 37.7492048010025 | -122.495559803327 | - | - | 1743792044000 | middleware_editor | NPRK ANY TIME VEH OVER 22' LONG OR 7' HIGH 12AM-6AM EVERYDAY | PACHECO ST to QUINTARA ST (2000 - 2099) | - | 100`SOUTH OF PACHECO | - | - | - | - | - | 103823 | 1010563200000 | -122.49543495 | 37.74872781 | - | 1402556400000 | - | D4 | - | PARKING:NPRK ANY TIME | REG | R30(SF).0572 | 18X18 | SUP2 | LIGHT POLE | IS | 1400234700000 | 37TH AVE | 2000 - 2099 37TH AVE | 2000 - 2099 37TH AVE | 2000 37TH AVE | - | QUINTARA ST | QUINTARA ST |
| 86645 | N/A | Point | 1 | 1 | 2000 - 2099 | - | S220942 | 2000-2099 37TH AVE | 2000-2099 37TH AVE | F | F | - | F | 1834000 | 1834000 | - | - | EAST SIDE | - | - | - | - | PACHECO ST | PACHECO ST | 61625 | 61625 | 37.7493620329993 | -122.49541532038 | - | - | 1743700689000 | middleware_editor | NPRK ANY TIME VEH OVER 22' LONG OR 7' HIGH 12AM-6AM EVERYDAY | PACHECO ST to QUINTARA ST (2000 - 2099) | - | 70 FT `SOUTH OF PACHECO | - | - | - | - | - | 103824 | 1010476800000 | -122.49543495 | 37.74872781 | - | - | - | D4 | - | PARKING:NPRK ANY TIME | REG | R30(SF).0572 | 18X18 | SUP2 | 2IN IRON POST | IS | 1448450280000 | 37TH AVE | 2000 - 2099 37TH AVE | 2000 - 2099 37TH AVE | 2000 37TH AVE | - | QUINTARA ST | QUINTARA ST |
| 86646 | N/A | Point | 1 | 1 | 3250 - 3299 | - | S151460 | 3250-3299 PACHECO ST | 3250-3299 PACHECO ST | F | F | - | F | 10109000 | 10109000 | - | - | SOUTH SIDE | - | - | - | - | SUNSET BLVD | SUNSET BLVD | 41582 | 41582 | 37.7496077492045 | -122.495210202959 | - | - | 1740168511000 | middleware_editor | NPRK 9AM-11AM 2ND & 4TH MON OF MONTH STCL | SUNSET BLVD to 37TH AVE (3250 - 3299) | - | 25`WEST | - | - | - | - | - | 103825 | 1228867200000 | -122.49523445 | 37.7496729 | - | 1465344000000 | - | D4 | - | STREET CLEANING | REG | R30B(CA).0294 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375730280000 | PACHECO ST | 3250 - 3299 PACHECO ST | 3250 - 3299 PACHECO ST | 3250 PACHECO ST | - | 37TH AVE | 37TH AVE |
| 86647 | N/A | Point | 1 | 1 | 2000 - 2099 | - | S260844 | 2000-2099 37TH AVE | 2000-2099 37TH AVE | T | T | - | F | 1834000 | 1834000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | PACHECO ST | PACHECO ST | 113605 | 113605 | 37.7481511775598 | -122.495486220699 | - | - | 1743700417000 | middleware_editor | SCHOOL/SPEED LIMIT 15/WHEN CHILDREN ARE PRESENT | PACHECO ST to QUINTARA ST (2000 - 2099) | - | 100 FT NORTH OF QUINTARA ST. | - | - | - | - | - | 103826 | 1317106800000 | -122.49543495 | 37.74872781 | - | - | - | D4 | - | OTHER REGULATORY | REG | SR4-1(CA).0001 | 24X48 | SUP2 | LIGHT POLE | IS | 1580308260000 | 37TH AVE | 2000 - 2099 37TH AVE | 2000 - 2099 37TH AVE | 2000 37TH AVE | - | QUINTARA ST | QUINTARA ST |
| 86648 | N/A | Point | 1 | 1 | 100 - 199 | - | S226227 | 100-199 GROVE ST | 100-199 GROVE ST | F | F | - | F | 6554000 | 6554000 | - | - | NORTH SIDE | - | - | - | - | DR CARLTON B GOODLETT PL \ POLK ST | DR CARLTON B GOODLETT PL \ POLK ST | 61257 | 61257 | 37.77838141 | -122.41905837 | - | - | 1710539427000 | MTA | BIKE RACK | DR CARLTON B GOODLETT PL \ POLK ST to VAN NESS AVE (100 - 199) | - | 205' WEST OF POLK | - | - | - | - | - | 103827 | 1469543040000 | -122.41905837 | 37.77838141 | - | 1469491200000 | - | D6 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1465034100000 | GROVE ST | 100 - 199 GROVE ST | 100 - 199 GROVE ST | 100 GROVE ST | - | VAN NESS AVE | VAN NESS AVE |
| 86649 | N/A | Point | - | 1 | 1049 - 1099 | - | S255568 | 1049-1099 BRANNAN ST | 1049-1099 BRANNAN ST | F | F | - | F | 3091000 | 3091000 | - | - | SOUTH SIDE | - | - | - | - | DORE ST | DORE ST | 124483 | 124483 | 37.76941676 | -122.40779959 | - | - | 1710539427000 | MTA | NPRK ANY TIME | DORE ST to 10TH ST \ DIVISION ST \ POTRERO AVE (1049 - 1099) | - | 10 FT EAST OF DIVISION | - | - | - | - | - | 103828 | 1466035200000 | -122.40779959 | 37.76941676 | - | 1466035200000 | - | D6 | - | PARKING:NPRK ANY TIME | REG | R26(CA).0001 | 12X18 | SUP1 | 2IN IRON POST | IS | 1561369080000 | BRANNAN ST | 1049 - 1099 BRANNAN ST | 1049 - 1099 BRANNAN ST | 1049 BRANNAN ST | - | 10TH ST \ DIVISION ST \ POTRERO AVE | 10TH ST \ DIVISION ST \ POTRERO AVE |
| 86650 | N/A | Point | - | - | - | - | S214789 | RIVERA ST: 22ND AVE | - | F | F | - | F | 23209000 | 23209000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | RIVERA ST | 22ND AVE | 115994 | 115994 | 37.74663793 | -122.47916614 | 22ND AVE \ RIVERA ST | RIVERA ST \ 22ND AVE | 1710539427000 | MTA | ALL WAY | 22ND AVE intersection | - | NE ON 22ND AVE | - | - | - | - | - | 103830 | 1430305740000 | -122.47916614 | 37.74663793 | - | 1639526400000 | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 3IN IRON POST | IS | 1427801160000 | RIVERA ST | - | - | - | - | - | - |
| 86651 | N/A | Point | 1 | 1 | 2200 - 2299 | - | S214782 | 2200-2299 22ND AVE | 2200-2299 22ND AVE | F | F | - | F | 1148000 | 1149000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | QUINTARA ST | RIVERA ST | 54099 | 54099 | 37.7457067 | -122.47910072 | - | - | 1710539427000 | MTA | (45 LA-DN) | RIVERA ST to SANTIAGO ST (2200 - 2299) | - | OPP.NE CORNOR (N-LINE OF CROSSWALK) | - | - | - | - | - | 103831 | 1133827200000 | -122.47910072 | 37.7457067 | - | - | - | D4 | - | OTHER WARNING | WARNING | W16-7P.0002 | 24X24 | SUP2 | 2IN IRON POST | IS | 1427800620000 | 22ND AVE | 2100 - 2199 22ND AVE | 2200 - 2299 22ND AVE | 2200 22ND AVE | - | RIVERA ST | SANTIAGO ST |
| 86652 | N/A | Point | - | - | - | - | S214774 | 22ND AVE: RIVERA ST | - | F | F | - | F | 1149000 | 23209000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | RIVERA ST | 22ND AVE | 52085 | 52085 | 37.74663793 | -122.47916614 | - | RIVERA ST \ 22ND AVE | 1710539427000 | MTA | (45 LA-DN) | 22ND AVE intersection | - | - | - | - | - | - | - | 103832 | 1133827200000 | -122.47916614 | 37.74663793 | - | - | - | D4 | - | OTHER WARNING | WARNING | W16-7P.0002 | 24X24 | SUP2 | 2IN IRON POST | IS | 1427800080000 | RIVERA ST | 2200 - 2299 22ND AVE | - | - | - | SANTIAGO ST | - |
| 86653 | N/A | Point | 1 | 1 | 2200 - 2299 | - | S151948 | 2200-2299 22ND AVE | 2200-2299 22ND AVE | F | F | - | F | 1149000 | 1149000 | - | - | EAST SIDE | - | - | - | - | RIVERA ST | RIVERA ST | 130252 | 130252 | 37.7457067 | -122.47910072 | - | - | 1738952697000 | middleware_editor | NPRK 8AM-10AM 2ND & 4TH THUR OF MONTH STCL | RIVERA ST to SANTIAGO ST (2200 - 2299) | - | 80' SOUTH OF RIVERA | - | - | - | - | - | 103833 | 1228953600000 | -122.47910072 | 37.7457067 | - | 1713263880000 | - | D4 | - | STREET CLEANING | REG | R30B(CA).0256 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375730460000 | 22ND AVE | 2200 - 2299 22ND AVE | 2200 - 2299 22ND AVE | 2200 22ND AVE | - | SANTIAGO ST | SANTIAGO ST |
| 86654 | N/A | Point | 1 | 1 | 2200 - 2299 | - | S151949 | 2200-2299 22ND AVE | 2200-2299 22ND AVE | F | F | - | F | 1149000 | 1149000 | - | - | EAST SIDE | - | - | - | - | RIVERA ST | RIVERA ST | 41344 | 41344 | 37.7457067 | -122.47910072 | - | - | 1739923923000 | middleware_editor | NPRK 8AM-10AM 2ND & 4TH THUR OF MONTH STCL | RIVERA ST to SANTIAGO ST (2200 - 2299) | - | 2294 22ND AVE | - | - | - | - | - | 103834 | 1228953600000 | -122.47910072 | 37.7457067 | - | 1739877720000 | - | D4 | - | STREET CLEANING | REG | R30B(CA).0256 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375730460000 | 22ND AVE | 2200 - 2299 22ND AVE | 2200 - 2299 22ND AVE | 2200 22ND AVE | - | SANTIAGO ST | SANTIAGO ST |
| 86655 | N/A | Point | - | - | - | - | S222830 | SHRADER ST: FREDERICK ST | - | F | F | - | F | 26426000 | 26426000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | SHRADER ST | FREDERICK ST | 58672 | 58672 | 37.7665915 | -122.45129553 | FREDERICK ST \ SHRADER ST | SHRADER ST \ FREDERICK ST | 1710539427000 | MTA | STOP | FREDERICK ST intersection | - | X ST IS FREDERICK | - | - | - | - | - | 103835 | 1477318080000 | -122.45129553 | 37.7665915 | - | 1477267200000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1453976880000 | SHRADER ST | - | - | - | - | - | - |
| 86656 | N/A | Point | - | - | - | - | S107211 | 17TH AVE: ORTEGA ST | - | F | F | - | F | 27315000 | 27315000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 17TH AVE | ORTEGA ST | 7562 | 7562 | 37.75247176 | -122.47420518 | ORTEGA ST \ 17TH AVE | 17TH AVE \ ORTEGA ST | 1710539427000 | MTA | STOP | ORTEGA ST intersection | - | 0 / 0 | - | - | - | - | - | 103836 | 208483200000 | -122.47420518 | 37.75247176 | - | 1012608000000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569800000 | 17TH AVE | - | - | - | - | - | - |
| 86657 | N/A | Point | - | - | - | - | S107217 | 17TH AVE: ORTEGA ST | - | F | F | - | F | 27315000 | 27315000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 17TH AVE | ORTEGA ST | 113155 | 113155 | 37.75247176 | -122.47420518 | ORTEGA ST \ 17TH AVE | 17TH AVE \ ORTEGA ST | 1712158986000 | middleware_editor | STOP | ORTEGA ST intersection | - | 0 / 0 | - | - | - | - | - | 103837 | 208483200000 | -122.47420518 | 37.75247176 | - | 1711980900000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569800000 | 17TH AVE | - | - | - | - | - | - |
| 86658 | N/A | Point | - | - | - | - | S111296 | 17TH AVE: ORTEGA ST | - | F | F | - | F | 27315000 | 27315000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 17TH AVE | ORTEGA ST | 127968 | 127968 | 37.75247176 | -122.47420518 | ORTEGA ST \ 17TH AVE | 17TH AVE \ ORTEGA ST | 1710539427000 | MTA | STOP | ORTEGA ST intersection | - | SEE PAINT MARK | - | - | - | - | - | 103838 | 772156800000 | -122.47420518 | 37.75247176 | - | - | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571060000 | 17TH AVE | - | - | - | - | - | - |
| 86659 | N/A | Point | - | - | - | - | S110102 | ELLIS ST: CYRIL MAGNIN ST | - | F | F | - | F | 4571000 | 24895000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ELLIS ST | ELLIS ST | 5383 | 5383 | 37.78538825 | -122.40866708 | - | CYRIL MAGNIN ST \ ELLIS ST | 1710539427000 | MTA | ONE WAY (LA) | ELLIS ST intersection | - | 0 / 0 | - | - | - | - | - | 103839 | 593740800000 | -122.40866708 | 37.78538825 | - | - | - | D6 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | LIGHT POLE | IS | 1373570700000 | CYRIL MAGNIN ST | 200 - 299 CYRIL MAGNIN ST | - | - | - | OFARRELL ST | - |
| 86660 | N/A | Point | - | - | - | - | S209884 | ELLIS ST: CYRIL MAGNIN ST | - | F | F | - | F | 5171000 | 24895000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CYRIL MAGNIN ST | ELLIS ST | 48568 | 48568 | 37.78538825 | -122.40866708 | - | CYRIL MAGNIN ST \ ELLIS ST | 1710539427000 | MTA | NO PED XING-USE CROSSWALK (LA) | ELLIS ST intersection | - | (LA) (RA) | - | - | - | - | - | 103840 | - | -122.40866708 | 37.78538825 | - | - | - | D6 | - | PEDESTRIAN | REG | R49(CA).0004 | 36X18 | SUP1 | 2 POST ALUMINUM | IS | 1412852340000 | CYRIL MAGNIN ST | 141 - 199 ELLIS ST | - | - | - | MASON ST | - |
| 86661 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S128364 | 1200-1299 POTRERO AVE | 1200-1299 POTRERO AVE | F | F | - | F | 10672000 | 10672000 | - | - | EAST SIDE | - | - | - | - | 24TH ST | 24TH ST | 22186 | 22186 | 37.75236512 | -122.40627783 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM THUR STCL | 24TH ST to 25TH ST (1200 - 1299) | - | IFO #1249 | - | - | - | - | - | 103841 | 1196812800000 | -122.40627783 | 37.75236512 | - | - | - | D9 | - | STREET CLEANING | REG | R30B(CA).0304 | 18X18 | SUP2 | LIGHT POLE | IS | 1373576400000 | POTRERO AVE | 1200 - 1299 POTRERO AVE | 1200 - 1299 POTRERO AVE | 1200 POTRERO AVE | - | 25TH ST | 25TH ST |
| 86662 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S135829 | 1200-1299 POTRERO AVE | 1200-1299 POTRERO AVE | F | F | - | F | 10672000 | 10672000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | 24TH ST | 24TH ST | 29685 | 29685 | 37.75236512 | -122.40627783 | - | - | 1710539427000 | MTA | (VA) BAYSHORE US-101 SOUTH/(VA) CESAR CHAVEZ WEST | 24TH ST to 25TH ST (1200 - 1299) | - | NPL #1246 | - | - | - | - | - | 103842 | 1327536000000 | -122.40627783 | 37.75236512 | - | - | - | D9 | - | OTHER GUIDE | GUIDE | G-B(SF).0007 | 30X36 | SUP2 | LIGHT POLE | IS | 1373578740000 | POTRERO AVE | 1200 - 1299 POTRERO AVE | 1200 - 1299 POTRERO AVE | 1200 POTRERO AVE | - | 25TH ST | 25TH ST |
| 86663 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S128196 | 1200-1299 POTRERO AVE | 1200-1299 POTRERO AVE | F | F | - | F | 10672000 | 10672000 | - | - | WEST SIDE | - | - | - | - | 24TH ST | 24TH ST | 23773 | 23773 | 37.75236512 | -122.40627783 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM MON WED FRI STCL | 24TH ST to 25TH ST (1200 - 1299) | - | OPP#1237 | - | - | - | - | - | 103843 | 1196380800000 | -122.40627783 | 37.75236512 | - | - | - | D9 | - | STREET CLEANING | REG | R30B(CA).0265 | 18X18 | SUP2 | LIGHT POLE | IS | 1373576340000 | POTRERO AVE | 1200 - 1299 POTRERO AVE | 1200 - 1299 POTRERO AVE | 1200 POTRERO AVE | - | 25TH ST | 25TH ST |
| 86664 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S225774 | 1200-1299 POTRERO AVE | 1200-1299 POTRERO AVE | F | F | - | F | 10672000 | 10672000 | - | - | WEST SIDE | - | - | - | - | 24TH ST | 24TH ST | 61221 | 61221 | 37.75236512 | -122.40627783 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM MON WED FRI STCL | 24TH ST to 25TH ST (1200 - 1299) | - | @ 1223 POTRERO AVE. | - | - | - | - | - | 103844 | 1196380800000 | -122.40627783 | 37.75236512 | - | 1463616000000 | - | D9 | - | STREET CLEANING | REG | R30B(CA).0265 | 18X18 | SUP2 | LIGHT POLE | IS | 1463585100000 | POTRERO AVE | 1200 - 1299 POTRERO AVE | 1200 - 1299 POTRERO AVE | 1200 POTRERO AVE | - | 25TH ST | 25TH ST |
| 86665 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S136046 | 1200-1299 POTRERO AVE | 1200-1299 POTRERO AVE | F | F | - | F | 10672000 | 10672000 | - | - | WEST SIDE | - | - | - | - | 24TH ST | 24TH ST | 30242 | 30242 | 37.75236512 | -122.40627783 | - | - | 1710539427000 | MTA | BIKE RACK | 24TH ST to 25TH ST (1200 - 1299) | - | 25N / INSTALL 1-BIKE RACK 25FT. NOR..... | - | - | - | - | - | 103845 | 1330473600000 | -122.40627783 | 37.75236512 | - | - | - | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BARRICADE | IS | 1373578800000 | POTRERO AVE | 1200 - 1299 POTRERO AVE | 1200 - 1299 POTRERO AVE | 1200 POTRERO AVE | - | 25TH ST | 25TH ST |
| 86666 | N/A | Point | - | - | - | - | S235444 | EGBERT AVE: END | - | F | F | - | F | 50878000 | 50878000 | - | - | NORTH EAST CORNER | - | - | - | - | START: 1700-1798 BLOCK | START: 1700-1798 BLOCK | 70866 | 70866 | 37.72619352 | -122.39657588 | EGBERT AVE \ START: 1700-1798 BLOCK | EGBERT AVE \ START: 1700-1798 BLOCK | 1710539427000 | MTA | G ST (TI) | START: 1700-1798 BLOCK intersection | - | EGBERT (SOUTH) CROSS ST IS G ST | - | - | - | - | - | 103846 | 1492505880000 | -122.39657588 | 37.72619352 | - | 1492473600000 | - | 10 | - | STREET NAME | GUIDE | D3-1.1921 | 36X08 | SUP1 | LIGHT POLE | IS | 1492698420000 | EGBERT AVE | - | - | - | - | - | - |
| 86667 | N/A | Point | - | - | - | - | S232821 | MANSELL ST: VISITACION AVE | - | F | F | - | F | 33350000 | 33350000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | VISITACION AVE | VISITACION AVE | 70874 | 70874 | 37.7187541 | -122.41167332 | MANSELL ST \ VISITACION AVE | MANSELL ST \ VISITACION AVE | 1730737798000 | middleware_editor | EXCEPT BICYCLES & AUTHORIZED VEHICLES | VISITACION AVE intersection | - | @INTERSECTION/OPP. EAST LINE CI | - | - | - | - | - | 103847 | 893116800000 | -122.41167332 | 37.7187541 | - | 1485820800000 | - | 09 | - | OTHER REGULATORY | REG | R(SF).0368 | 30X24 | SUP3 | 2IN IRON POST | IS | 1485176580000 | MANSELL ST | - | - | - | - | - | - |
| 86668 | N/A | Point | - | - | - | - | S235102 | MANSELL ST: VISITACION AVE | - | F | F | - | F | 8671204 | 33350000 | - | - | CENTER ISLAND, E LINE, SOUTHBOUND | - | - | - | - | UNIVERSITY ST | VISITACION AVE | 70903 | 70903 | 37.7187541 | -122.41167332 | - | MANSELL ST \ VISITACION AVE | 1730738196000 | middleware_editor | ALL WAY | VISITACION AVE intersection | - | - | - | - | - | - | - | 103848 | 182476800000 | -122.41167332 | 37.7187541 | - | 1495584000000 | - | 09 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP3 | LIGHT POLE | IS | 1491917520000 | MANSELL ST | 1000 - 1098 MANSELL ST | - | - | - | VISITACION AVE | - |
| 86669 | N/A | Point | - | - | - | - | S235104 | VISITACION AVE: MANSELL ST | - | F | F | - | F | 13332000 | 33350000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | HAHN ST \ MRS. JACKSON WAY | VISITACION AVE | 70905 | 70905 | 37.7187541 | -122.41167332 | - | MANSELL ST \ VISITACION AVE | 1730737956000 | middleware_editor | ALL WAY | VISITACION AVE intersection | - | X ST IS MANSELL | - | - | - | - | - | 103849 | 182476800000 | -122.41167332 | 37.7187541 | - | 1495584000000 | - | 09 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP3 | 2IN IRON POST | IS | 1491917940000 | MANSELL ST | 1700 - 2499 VISITACION AVE | - | - | - | MANSELL ST | - |
| 86670 | N/A | Point | - | - | - | - | S232696 | DE FOREST WAY: FLINT ST | - | F | F | - | F | 33565000 | 33565000 | - | - | NORTH EAST CORNER | - | - | - | - | FLINT ST | FLINT ST | 70926 | 70926 | 37.76475883 | -122.43696482 | DE FOREST WAY \ FLINT ST | DE FOREST WAY \ FLINT ST | 1710539427000 | MTA | DE FOREST WAY | FLINT ST intersection | - | OF DE FOREST WAY & FLINT ST. | - | - | - | - | - | 103850 | 1490713320000 | -122.43696482 | 37.76475883 | - | 1490659200000 | - | 08 | - | STREET NAME | GUIDE | D3-1.0505 | 36X08 | SUP3 | LIGHT POLE | IS | 1484739060000 | DE FOREST WAY | - | - | - | - | - | - |
| 86671 | N/A | Point | - | - | - | - | S235854 | FITZGERALD AVE: END | - | F | F | - | F | 50879000 | 50879000 | - | - | SOUTH EAST CORNER | - | - | - | - | START: 1700-1799 BLOCK | START: 1700-1799 BLOCK | 70956 | 70956 | 37.72656069 | -122.40116087 | FITZGERALD AVE \ START: 1700-1799 BLOCK | FITZGERALD AVE \ START: 1700-1799 BLOCK | 1710539427000 | MTA | GIANTS DR | START: 1700-1799 BLOCK intersection | - | CROSS ST IS G ST | - | - | - | - | - | 103851 | 1493910360000 | -122.40116087 | 37.72656069 | - | 1493856000000 | - | 10 | - | STREET NAME | GUIDE | D3-1.0728 | 36X08 | SUP1 | LIGHT POLE | IS | 1493894700000 | FITZGERALD AVE | - | - | - | - | - | - |
| 86672 | N/A | Point | - | - | - | - | S232721 | CHANNEL ST: 4TH ST | - | F | F | - | F | 34167000 | 34167000 | - | - | NORTH WEST CORNER | - | - | - | - | 4TH ST | CHANNEL ST | 71195 | 71195 | 37.77432755 | -122.39163414 | CHANNEL ST \ 4TH ST | 04TH ST \ CHANNEL ST | 1710539427000 | MTA | SPECIAL EVENT AREA CHECK YOUR METER (SFPARK) | CHANNEL ST intersection | - | - | - | - | - | - | - | 103852 | 1280707200000 | -122.39163414 | 37.77432755 | - | 1485820800000 | - | 06 | - | OTHER GUIDE | GUIDE | G-S(SF).0058 | 18X18 | SUP1 | 2IN IRON POST | IS | 1484751960000 | 04TH ST | - | - | - | - | - | - |
| 86673 | N/A | Point | - | - | - | - | S238603 | MONTEREY BLVD: DETROIT ST | - | F | F | - | F | 22156000 | 22156000 | - | - | CENTER ISLAND, W LINE, WESTBOUND | - | - | - | - | MONTEREY BLVD | DETROIT ST | 71896 | 71896 | 37.73160482 | -122.44430217 | DETROIT ST \ MONTEREY BLVD | MONTEREY BLVD \ DETROIT ST | 1710539427000 | MTA | (45 RA-DN) | DETROIT ST intersection | - | UNDER BEACON | - | - | - | - | - | 103853 | 1504181700000 | -122.44430217 | 37.73160482 | - | 1504137600000 | - | 07 | - | OTHER WARNING | WARNING | W16-7P.0005 | 18X18 | SUP3 | LIGHT POLE | IS | 1504097160000 | MONTEREY BLVD | - | - | - | - | - | - |
| 86674 | N/A | Point | - | - | - | - | S238786 | MONTEREY BLVD: DETROIT ST | - | F | F | - | F | 22156000 | 22156000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MONTEREY BLVD | DETROIT ST | 71989 | 71989 | 37.73160482 | -122.44430217 | DETROIT ST \ MONTEREY BLVD | MONTEREY BLVD \ DETROIT ST | 1710539427000 | MTA | PEDESTRIAN (SYM) | DETROIT ST intersection | - | ABOVE NEW BEACON | - | - | - | - | - | 103854 | 1504137600000 | -122.44430217 | 37.73160482 | - | 1504828800000 | - | 07 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP3 | LIGHT POLE | IS | 1504792200000 | MONTEREY BLVD | - | - | - | - | - | - |
| 86675 | N/A | Point | - | - | - | - | S238788 | MONTEREY BLVD: DETROIT ST | - | F | F | - | F | 22156000 | 22156000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MONTEREY BLVD | DETROIT ST | 71991 | 71991 | 37.73160482 | -122.44430217 | DETROIT ST \ MONTEREY BLVD | MONTEREY BLVD \ DETROIT ST | 1710539427000 | MTA | (45 RA-DN) | DETROIT ST intersection | - | UNDER NEW BEACON | - | - | - | - | - | 103855 | 1504137600000 | -122.44430217 | 37.73160482 | - | 1504828800000 | - | 07 | - | OTHER WARNING | WARNING | W16-7P.0005 | 18X18 | SUP3 | LIGHT POLE | IS | 1504792800000 | MONTEREY BLVD | - | - | - | - | - | - |
| 86676 | N/A | Point | - | - | - | - | S241211 | LOMBARD ST: LETTERMAN DR | - | T | T | - | F | 51240000 | 51240000 | - | - | NORTH EAST CORNER | - | - | - | - | LOMBARD ST | LOMBARD ST | 72687 | 72687 | 37.7975576 | -122.44897625 | LETTERMAN DR \ LOMBARD ST | LETTERMAN DR \ LOMBARD ST | 1710539427000 | MTA | 49 MILE SCENIC DRIVE | LOMBARD ST intersection | 54 | @LETTERMAN DR. (PRESIDIO) | - | - | - | - | - | 103856 | 1577970480000 | -122.44897625 | 37.7975576 | - | - | - | 02 | - | OTHER GUIDE | GUIDE | G-X(SF).0045 | 24X30 | SUP2 | LIGHT POLE | IS | 1512479220000 | LETTERMAN DR | - | - | - | - | - | - |
| 86677 | N/A | Point | - | - | - | - | S245685 | BAY SHORE BLVD: BAY SHORE BLVD | - | T | T | - | F | 33757000 | 33757000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BAY SHORE BLVD | BAY SHORE BLVD | 74259 | 74259 | 37.74556808 | -122.40422824 | BAY SHORE BLVD \ BAY SHORE BLVD | BAY SHORE BLVD \ BAY SHORE BLVD | 1710539427000 | MTA | EXCEPT BIKE (SYM) | BAY SHORE BLVD intersection | - | SEC OF MARIN AND BAYSHORE | - | - | - | - | - | 103857 | 1526985420000 | -122.40422824 | 37.74556808 | - | - | - | 10 | - | OTHER REGULATORY | REG | R(SF).0362 | 24X18 | SUP1 | LIGHT POLE | IS | 1526909160000 | BAY SHORE BLVD | - | - | - | - | - | - |
| 86678 | N/A | Point | - | - | - | - | S242413 | PENNSYLVANIA AVE: I-280 S OFF | - | F | F | - | F | 52251000 | 52251000 | - | - | CENTER ISLAND, SOUTHBOUND TRAFFIC | - | - | - | - | PENNSYLVANIA AVE | PENNSYLVANIA AVE | 74994 | 74994 | 37.76329621 | -122.39366263 | \PENNSYLVANIA AVE: I-280 S OFF | I-280 S OFF RAMP \ PENNSYLVANIA AVE | 1710539427000 | MTA | ALL WAY | PENNSYLVANIA AVE intersection | - | X ST IS I-280 OFF- RAMP (N-LINE)_ | - | - | - | - | - | 103858 | 1516881060000 | -122.39366263 | 37.76329621 | - | 1516838400000 | - | 10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1516356240000 | I-280 S OFF RAMP | - | - | - | - | - | - |
| 86679 | N/A | Point | - | - | - | - | S242414 | PENNSYLVANIA AVE: I-280 S OFF | - | F | F | - | F | 52251000 | 52251000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | PENNSYLVANIA AVE | PENNSYLVANIA AVE | 74995 | 74995 | 37.76329621 | -122.39366263 | \PENNSYLVANIA AVE: I-280 S OFF | I-280 S OFF RAMP \ PENNSYLVANIA AVE | 1710539427000 | MTA | STOP | PENNSYLVANIA AVE intersection | - | X ST IS I-280 OFF- RAMP | - | - | - | - | - | 103859 | 1516881240000 | -122.39366263 | 37.76329621 | - | 1516838400000 | - | 10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1516356420000 | I-280 S OFF RAMP | - | - | - | - | - | - |
| 86680 | N/A | Point | - | - | - | - | S239996 | OLIVER ST: BRUNSWICK ST | - | F | F | - | F | 21531000 | 21531000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | OLIVER ST | BRUNSWICK ST | 75328 | 75328 | 37.70832812 | -122.4498466 | BRUNSWICK ST \ OLIVER ST | OLIVER ST \ BRUNSWICK ST | 1710539427000 | MTA | ALL WAY | BRUNSWICK ST intersection | - | @BRUNSWICK ST | - | - | - | - | - | 103860 | 614822400000 | -122.4498466 | 37.70832812 | - | 1516838400000 | - | 11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP3 | 2IN IRON POST | IS | 1509370860000 | OLIVER ST | - | - | - | - | - | - |
| 86681 | N/A | Point | - | - | - | - | S242727 | 3RD ST: CHINA BASIN ST | - | F | F | - | F | 34157000 | 34157000 | - | - | NORTH WEST CORNER | - | - | - | - | 3RD ST | CHINA BASIN ST | 75882 | 75882 | 37.77199794 | -122.38961148 | CHINA BASIN ST \ 3RD ST | 03RD ST \ CHINA BASIN ST | 1710539427000 | MTA | LONG BRIDGE ST | CHINA BASIN ST intersection | - | PRIVATE X IS 3RD ST | - | - | - | - | - | 103861 | 1523453400000 | -122.38961148 | 37.77199794 | - | 1523404800000 | - | 06 | - | STREET NAME | GUIDE | D3-1.1062 | 36X08 | SUP1 | 3IN IRON POST | IS | 1517490060000 | 03RD ST | - | - | - | - | - | - |
| 86682 | N/A | Point | - | - | - | - | S242731 | 3RD ST: CHINA BASIN ST | - | F | F | - | F | 34157000 | 34157000 | - | - | NORTH WEST CORNER | - | - | - | - | 3RD ST | CHINA BASIN ST | 75883 | 75883 | 37.77199794 | -122.38961148 | CHINA BASIN ST \ 3RD ST | 03RD ST \ CHINA BASIN ST | 1710539427000 | MTA | 3RD ST | CHINA BASIN ST intersection | - | 1100 --> SOUTH (AT LONGBRIDGE) | - | - | - | - | - | 103862 | 1523453220000 | -122.38961148 | 37.77199794 | - | 1523404800000 | - | 06 | - | STREET NAME | GUIDE | D3-1.0030 | 36X08 | SUP1 | 3IN IRON POST | IS | 1517490360000 | 03RD ST | - | - | - | - | - | - |
| 86683 | N/A | Point | - | - | - | - | 22007 | - | - | F | F | - | F | 1078000 | - | - | - | EAST SIDE, NORTHBOUND TRAFFIC | 1691182357000 | MMENDIET | - | - | CABRILLO ST | - | 144736 | 144736 | 37.772970878 | -122.479859673 | - | - | 1710539427000 | MTA | SPEED HUMPS AHEAD | - | - | 33' NORTH OF FULTON ST @ PAINT MARK. | - | - | - | - | - | 103864 | 1704285900000 | - | - | - | - | - | 01 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | - | IS | - | 21ST AVE | 700 - 799 21ST AVE | - | - | - | FULTON ST | - |
| 86684 | N/A | Point | - | - | - | - | S214707 | - | - | NO | NO | - | - | - | - | - | - | SOUTH SIDE | 1691445421000 | MTA | - | - | SCOTT ST | - | 145200 | 145200 | 37.772311 | -122.436399 | - | - | 1710539427000 | MTA | 2 HR PRK 9AM-8PM MON-FRI EXC "Q' PERMITS | - | - | - | - | - | - | - | - | 103865 | - | -122.436399 | 37.772311 | - | - | 1687737600000 | 05 | - | PARKING:RPP | REG | R32C(CA).0216 | 18X21 | SUP2 | 2IN IRON POST | RETD | - | - | - | - | - | - | DIVISADERO ST | - |
| 86685 | N/A | Point | 1 | 1 | 801 - 863 | - | S286736 | 800-899 MARKET ST | 801-863 MARKET ST | F | F | - | F | 8747102 | 8747102 | - | - | NORTH SIDE | - | - | - | - | 4TH ST \ ELLIS ST \ STOCKTON ST | 04TH ST \ ELLIS ST \ STOCKTON ST | 99105 | 99105 | 37.78512171 | -122.40654805 | - | - | 1710539427000 | MTA | BIKE RACK | 04TH ST \ ELLIS ST \ STOCKTON ST to POWELL ST (801 - 863) -- SOUTH -- | 556097 | 42' E OF EPL 856/3.5' IN FROM CURB | - | - | - | - | - | 103866 | 1678924800000 | -122.40654805 | 37.78512171 | - | - | - | 06 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1671702600000 | MARKET ST | 801 - 863 MARKET ST | 801 - 863 MARKET ST | 801 MARKET ST | - | POWELL ST | POWELL ST |
| 86686 | N/A | Point | 1 | 1 | 400 - 499 | - | S259993 | 400-499 HANOVER ST | 400-499 HANOVER ST | F | F | - | F | 6670000 | 6670000 | - | - | EAST SIDE | - | - | - | - | LOWELL ST | LOWELL ST | 99311 | 99311 | 37.708418731 | -122.445219545 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM TUE STCL | LOWELL ST to WHITTIER ST (400 - 499) | - | 45 FT SOUTH OF LOWELL OPP 412 | - | - | - | - | - | 103867 | - | -122.44592586 | 37.70821502 | - | - | - | 11 | - | STREET CLEANING | REG | R30B(CA).0308 | 18X18 | SUP3 | 2IN IRON POST | IS | 1577699280000 | HANOVER ST | 400 - 499 HANOVER ST | 400 - 499 HANOVER ST | 400 HANOVER ST | - | WHITTIER ST | WHITTIER ST |
| 86687 | N/A | Point | - | - | - | - | S285561 | TAPIA DR: HOLLOWAY AVE | - | F | F | - | F | 23102000 | 23102000 | - | - | NORTH WEST CORNER | - | - | - | - | HOLLOWAY AVE | TAPIA DR | 99470 | 99470 | 37.72097222 | -122.48066941 | TAPIA DR \ HOLLOWAY AVE | HOLLOWAY AVE \ TAPIA DR | 1710539427000 | MTA | TAPIA DR | TAPIA DR intersection | - | 100 | - | - | - | - | - | 103868 | - | -122.48066941 | 37.72097222 | - | 1670889600000 | - | 07 | - | STREET NAME | GUIDE | D3-1.1704 | 36X08 | SUP3 | LIGHT POLE | IS | 1666171440000 | HOLLOWAY AVE | - | - | - | - | - | - |
| 86688 | N/A | Point | - | - | - | - | S253652 | MARIPOSA ST: I-280 S ON RAMP | - | T | T | - | F | 52249000 | 52249000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | I-280 S ON RAMP | I-280 S ON RAMP | 100914 | 100914 | 37.7640556 | -122.39317381 | MARIPOSA ST: I-280 S ON RAMP | MARIPOSA ST \ I-280 S ON RAMP | 1710539427000 | MTA | (VA-RA) (RA) ONLY | I-280 S ON RAMP intersection | - | - | - | - | - | - | - | 103869 | 1556806320000 | -122.39317381 | 37.7640556 | - | - | - | 10 | - | OTHER REGULATORY | REG | R61-3(CA).0002 | 36X30 | SUP1 | LIGHT POLE | IS | 1555680660000 | MARIPOSA ST | - | - | - | - | - | - |
| 86689 | N/A | Point | - | - | - | - | S254048 | 0-0 MISSION BAY CIR | - | F | F | - | F | 347000 | 347000 | - | - | NORTH SIDE | - | - | - | - | - | - | 101197 | 101197 | 37.77044361 | -122.39551481 | - | - | 1710539427000 | MTA | TANSAT | - | - | - | - | - | - | - | - | 103870 | - | -122.39551481 | 37.77044361 | - | - | - | 06 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | LIGHT POLE | IS | 1556879520000 | 06TH ST | 0-0 MISSION BAY CIR | 06TH ST | - | - | - | - |
| 86690 | N/A | Point | - | - | - | - | S254075 | MISSION BAY CIR: END | - | F | F | - | F | 35053000 | 35053000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CHANNEL | CHANNEL | 101204 | 101204 | 37.77070119 | -122.39597958 | MISSION BAY CIR \ CHANNEL | MISSION BAY CIR \ CHANNEL | 1744057163000 | middleware_editor | (45 LA-DN) | CHANNEL intersection | - | X-WALK @ OWENS ST | - | - | - | - | - | 103871 | 1557172740000 | -122.39597958 | 37.77070119 | - | - | - | 06 | - | OTHER WARNING | WARNING | W16-7P.0004 | 24X12 | SUP1 | 2IN IRON POST | IS | 1556885580000 | MISSION BAY CIR | - | - | - | - | - | - |
| 86691 | N/A | Point | - | 1 | 600 - 699 | - | S286622 | 600-699 TERRY A FRANCOIS BLVD | 600-699 TERRY A FRANCOIS BLVD | T | T | - | F | 12532005 | 12532005 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | WARRIORS WAY | WARRIORS WAY | 101320 | 101320 | 37.76803863 | -122.386216 | - | - | 1710539427000 | MTA | SPECIAL EVENT AREA.... TOW AWAY MAY APPLY/CHECK THE METER | WARRIORS WAY to 16TH ST (600 - 699) | - | 436FT SOUTH | - | - | - | - | - | 103872 | 1395705600000 | -122.386216 | 37.76803863 | - | 1566432000000 | - | 06 | - | OTHER REGULATORY | REG | G-S(SF).0079 | 18X18 | SUP1 | LIGHT POLE | IS | 1671099540000 | TERRY A FRANCOIS BLVD | 600 - 699 TERRY A FRANCOIS BLVD | 600 - 699 TERRY A FRANCOIS BLVD | 600 TERRY A FRANCOIS BLVD | - | 16TH ST | 16TH ST |
| 86692 | N/A | Point | - | - | - | - | S287126 | MANSELL ST: JOHN F SHELLEY DR | - | F | F | - | F | 20945000 | 20945000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | MANSELL ST | JOHN F SHELLEY DR | 101437 | 101437 | 37.71876609 | -122.41851237 | JOHN F SHELLEY DR \ MANSELL ST | MANSELL ST \ JOHN F SHELLEY DR | 1710539427000 | MTA | SPEED LIMIT 30 | JOHN F SHELLEY DR intersection | - | 200 FT EAST OF JOHN F SHELLY WEST | - | - | - | - | - | 103873 | 1674086400000 | -122.41851237 | 37.71876609 | - | - | - | 09 | - | SPEED LIMIT | REG | R2-1.0009 | 36X45 | SUP3 | 2IN IRON POST | IS | 1674138720000 | MANSELL ST | - | - | - | - | - | - |
| 86693 | N/A | Point | - | - | - | - | S287130 | MANSELL ST: BRAZIL AVE | - | T | T | - | F | 33338000 | 33338000 | - | - | NORTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | MANSELL ST | BRAZIL AVE | 101439 | 101439 | 37.71788738 | -122.42247299 | BRAZIL AVE \ MANSELL ST | MANSELL ST \ BRAZIL AVE | 1710539427000 | MTA | SPEED LIMIT 40 | BRAZIL AVE intersection | - | 250FT EAST OF BRAZIL/PERSIA | - | - | - | - | - | 103874 | 1490140800000 | -122.42247299 | 37.71788738 | - | - | - | 10 | - | SPEED LIMIT | REG | R2-1.0012 | 36X45 | SUP1 | LIGHT POLE | IS | 1674139800000 | MANSELL ST | - | - | - | - | - | - |
| 86694 | N/A | Point | - | - | - | - | S287131 | MANSELL ST: BRAZIL AVE | - | F | F | - | F | 33338000 | 33338000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | MANSELL ST | BRAZIL AVE | 101440 | 101440 | 37.71788738 | -122.42247299 | BRAZIL AVE \ MANSELL ST | MANSELL ST \ BRAZIL AVE | 1710539427000 | MTA | DO NOT PASS | BRAZIL AVE intersection | - | 400FT EAST OF BRAZIL/PERSIA | - | - | - | - | - | 103875 | 1490140800000 | -122.42247299 | 37.71788738 | - | - | - | 10 | - | OTHER REGULATORY | REG | R4-1.0001 | 24X30 | SUP1 | 2IN IRON POST | IS | 1674140160000 | MANSELL ST | - | - | - | - | - | - |
| 86695 | N/A | Point | - | - | - | - | S256139 | ILLINOIS ST: AMADOR ST | - | F | F | - | F | 54330000 | 54330000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | ILLINOIS ST | AMADOR ST | 101853 | 101853 | 37.74575699 | -122.38606019 | AMADOR ST \ ILLINOIS ST | ILLINOIS ST \ AMADOR ST | 1710539427000 | MTA | (RA) TURNING VEHICLES YIELD (SYM) TO PED & BIKE (SYM) | AMADOR ST intersection | - | NEC OF PARKING LOT | - | - | - | - | - | 103876 | 1489449600000 | -122.38606019 | 37.74575699 | - | 1567728000000 | - | 10 | - | PEDESTRIAN | REG | R10-15.0003 | 30X30 | SUP1 | 2IN IRON POST | IS | 1563283860000 | ILLINOIS ST | - | - | - | - | - | - |
| 86696 | N/A | Point | - | - | - | - | S263972 | AMADOR ST: ILLINOIS ST | - | F | F | - | F | 54330000 | 54330000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | ILLINOIS ST | AMADOR ST | 102891 | 102891 | 37.74575699 | -122.38606019 | AMADOR ST \ ILLINOIS ST | ILLINOIS ST \ AMADOR ST | 1710539427000 | MTA | STOP | AMADOR ST intersection | - | SWITCH ST (PIER 94) AND ACCESS RD | - | - | - | - | - | 103877 | 1495584000000 | -122.38606019 | 37.74575699 | - | 1588896000000 | - | 10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1588840740000 | ILLINOIS ST | - | - | - | - | - | - |
| 86697 | N/A | Point | - | - | - | - | S257234 | ILLINOIS ST: AMADOR ST | - | F | F | - | F | 54330000 | 54330000 | - | - | EAST SIDE | - | - | - | - | ILLINOIS ST | AMADOR ST | 102965 | 102965 | 37.74575699 | -122.38606019 | AMADOR ST \ ILLINOIS ST | ILLINOIS ST \ AMADOR ST | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | AMADOR ST intersection | - | IN S-LINE, X-WALK BTWN CEMENT ISLANDS | - | - | - | - | - | 103878 | 1489449600000 | -122.38606019 | 37.74575699 | - | 1566432000000 | - | 10 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | TURNPIKE BASE | IS | 1566466980000 | ILLINOIS ST | - | - | - | - | - | - |
| 86698 | N/A | Point | 1 | 1 | 801 - 863 | - | S264134 | 800-899 MARKET ST | 801-863 MARKET ST | F | F | - | T | 8747102 | 8747102 | - | - | SOUTH SIDE | - | - | - | - | 4TH ST \ ELLIS ST \ STOCKTON ST | 04TH ST \ ELLIS ST \ STOCKTON ST | 103333 | 103333 | 37.78512171 | -122.40654805 | - | - | 1710539427000 | MTA | MUNI LANDOR FLAG - TYPE 6 | 04TH ST \ ELLIS ST \ STOCKTON ST to POWELL ST (801 - 863) -- SOUTH -- | 15644 | WESTFIELD MALL | - | - | - | - | - | 103879 | 1431475200000 | -122.40654805 | 37.78512171 | - | 1431475200000 | - | 06 | - | OTHER REGULATORY | REG | R(SF).0334 | 15X39 | SUP1 | UNISTRUT | IS | 1589283420000 | MARKET ST | 801 - 863 MARKET ST | 801 - 863 MARKET ST | 801 MARKET ST | - | POWELL ST | POWELL ST |
| 86699 | N/A | Point | 1 | 1 | 701 - 749 | - | S264143 | PNDG MARKET ST | 701-749 MARKET ST | F | F | - | T | 8745101 | 8745101 | - | - | CENTER ISLAND | - | - | - | - | 03RD ST \ KEARNY ST | 03RD ST \ KEARNY ST | 103658 | 103658 | 37.7871571 | -122.40397034 | - | - | 1710539427000 | MTA | PROVISIONAL-ASSIGN NEW SIGN CODE WHEN CREATED IN SHOPS | 03RD ST \ KEARNY ST to GRANT AVE \ OFARRELL ST (701 - 749) -- SOUTH -- | 15640 | BUS ISLAND | - | - | - | - | - | 103880 | 1431475200000 | -122.40397034 | 37.7871571 | - | 1431475200000 | - | 06 | - | PROVISIONAL | MISC | PROVISIONAL CODE | N/A | SUP1 | UNISTRUT | IS | 1589284500000 | MARKET ST | PNDG MARKET ST | 701 - 749 MARKET ST | - | - | GRANT AVE \ OFARRELL ST | GRANT AVE \ OFARRELL ST |
| 86700 | N/A | Point | - | - | - | - | 21071 | - | - | F | F | - | F | - | - | - | - | - | 1689276305000 | evillan | - | - | - | - | 141489 | 141489 | 37.767929396 | -122.48014253 | - | - | 1747253317000 | middleware_editor | REMOVE (SF BIKE ROUTE) GREEN (SYM) # | - | - | SWC SB | - | - | - | - | - | 103881 | - | - | - | - | - | - | 04 | - | BIKE REG | REG | R(SF).0388 | 12X24 | SUP2 | LIGHT POLE | RETD | - | - | - | - | - | - | - | - |
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