Import ISO
No additional information has been provided for this dataset.
Between for ranges (e.g., 10,100)Regex for pattern matchingCase sensitive for exact matches
| ID | Feature ID | Geometry Type | ACCEPTED | ACTIVE | ADDRANGE | ARROW DIR | ASSET ID | ASSET NAME | ASSET NAME 1 | BAPA | BOOM TRUCK | CANCEL | CLEARANCE PERMIT | CNN | CNN 1 | COMBOKEY | CONDITION | CORNER SIDE FACING | CREATED DATE | CREATED USER | CURLYIDS | ETL | FROM ST | FROM ST 1 | GISOBJID | GLOBALID UDFCHAR44 | GPS LATITUDE | GPS LONGITUDE | INTERSECTION | INTERSECTION 1 | LAST EDITED DATE | LAST EDITED USER | LEGEND | LIMITS | LOCATION TRACK ID | LOC SPEC | NEW PURPOSE | NEW SIGN CODE | NEW SIGN LEGEND | NEW SIGN SIZE | NUM OF ASSETS | OBJECTID 1 | ORIG INSTALL DATE | POINT X | POINT Y | PURPOSE | REPLACEMENT DATE | RETIREMENT DATE | SF SUP DISTRICT | SHEETING | SIGN CATEGORY | SIGN CLASS | SIGN CODE | SIGN SIZE | SIGN SUPERVISOR | SIGN SUPPORT | STATUS CODE | STATUS DATE | STREETNAME | STREET ADDRESS RANGE | STREET ADDRESS RANGE 1 | STREET BLOCK | STREET VIEW | TO ST | TO ST 1 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 66451 | N/A | Point | - | - | - | - | S257034 | LYELL ST: STILL ST | - | F | F | - | F | 33700000 | 33700000 | - | - | CENTER ISLAND, E LINE, EASTBOUND | - | - | - | - | STILL ST | STILL ST | 100657 | 100657 | 37.73173713 | -122.43139031 | LYELL ST \ STILL ST | LYELL ST \ STILL ST | 1710539427000 | MTA | KEEP RIGHT (SYM) | STILL ST intersection | - | 30 FT WEST OF 66 UNDER YIELD SIGN | - | - | - | - | - | 83567 | 1569075960000 | -122.43139031 | 37.73173713 | - | - | - | D8 | - | OTHER REGULATORY | REG | R4-7A.0002 | 24X30 | SUP2 | 2IN IRON POST | IS | 1565861940000 | LYELL ST | - | - | - | - | - | - |
| 66452 | N/A | Point | 1 | 1 | 100 - 149 | RIGHT ARROW | S257036 | 100-149 STILL ST | 100-149 STILL ST | F | F | - | F | 12181000 | 12181000 | - | - | WEST SIDE | - | - | - | - | ROTTECK ST | ROTTECK ST | 100658 | 100658 | 37.73178972 | -122.43112058 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM MON STCL | ROTTECK ST to LYELL ST (100 - 149) | - | 10 FT NORTH OF LYELL AT CROOSSWALK | - | - | - | - | - | 83568 | 1569233160000 | -122.43112058 | 37.73178972 | - | - | - | D8 | - | STREET CLEANING | REG | R30B(CA).0300 | 18X18 | SUP2 | 2IN IRON POST | IS | 1565862300000 | STILL ST | 100 - 149 STILL ST | 100 - 149 STILL ST | 100 STILL ST | - | LYELL ST | LYELL ST |
| 66453 | N/A | Point | 1 | 1 | 100 - 149 | LEFT ARROW | S257037 | 100-149 STILL ST | 100-149 STILL ST | F | F | - | F | 12181000 | 12181000 | - | - | WEST SIDE | - | - | - | - | ROTTECK ST | ROTTECK ST | 100659 | 100659 | 37.73178972 | -122.43112058 | - | - | 1710539427000 | MTA | NPRK 7AM-8AM FRI STCL | ROTTECK ST to LYELL ST (100 - 149) | - | 10 FT NORTH OF LYELL AT CROOSSWALK | - | - | - | - | - | 83569 | 1569233280000 | -122.43112058 | 37.73178972 | - | - | - | D8 | - | STREET CLEANING | REG | R30B(CA).0209 | 18X18 | SUP2 | 2IN IRON POST | IS | 1565862480000 | STILL ST | 100 - 149 STILL ST | 100 - 149 STILL ST | 100 STILL ST | - | LYELL ST | LYELL ST |
| 66454 | N/A | Point | - | - | - | - | S257042 | 29TH ST: SAN JOSE AVE | - | F | F | - | F | 21349000 | 21349000 | - | - | SOUTH WEST CORNER | - | - | - | - | 29TH ST | 29TH ST | 100660 | 100660 | 37.74394224 | -122.42266945 | SAN JOSE AVE \ 29TH ST | SAN JOSE AVE \ 29TH ST | 1710539427000 | MTA | 29TH ST | 29TH ST intersection | - | - | - | - | - | - | - | 83570 | 1454630400000 | -122.42266945 | 37.74394224 | - | 1571616000000 | - | D8 | - | STREET NAME | GUIDE | D3-1.0022 | 36X08 | SUP2 | SIGNAL POLE | IS | 1565863560000 | SAN JOSE AVE | - | - | - | - | - | - |
| 66455 | N/A | Point | 1 | 1 | 400 - 442 | - | S257045 | 400-442 SANCHEZ ST | 400-442 SANCHEZ ST | F | F | - | F | 11513000 | 11513000 | - | - | EAST SIDE | - | - | - | - | 17TH ST | 17TH ST | 100661 | 100661 | 37.76241678 | -122.43069451 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM FRI STCL | 17TH ST to DORLAND ST (400 - 442) | - | 30 FT SOUTH OF 17TH ST | - | - | - | - | - | 83571 | 1578300600000 | -122.43069451 | 37.76241678 | - | 1631145600000 | - | D8 | - | STREET CLEANING | REG | R30B(CA).0298 | 18X18 | SUP2 | 2 POST ALUMINUM | IS | 1565865000000 | SANCHEZ ST | 400 - 442 SANCHEZ ST | 400 - 442 SANCHEZ ST | 400 SANCHEZ ST | - | DORLAND ST | DORLAND ST |
| 66456 | N/A | Point | 1 | 1 | 400 - 442 | - | S257046 | 400-442 SANCHEZ ST | 400-442 SANCHEZ ST | F | F | - | F | 11513000 | 11513000 | - | - | EAST SIDE | - | - | - | - | 17TH ST | 17TH ST | 100662 | 100662 | 37.76241678 | -122.43069451 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-9PM MON-FRI EXC "S" PERMITS | 17TH ST to DORLAND ST (400 - 442) | - | 30 FT SOUTH OF 17TH ST | - | - | - | - | - | 83572 | 1626252600000 | -122.43069451 | 37.76241678 | - | 1631145600000 | - | D8 | - | PARKING:RPP | REG | R32C(CA).0126 | 18X21 | SUP2 | 2 POST ALUMINUM | IS | 1565865120000 | SANCHEZ ST | 400 - 442 SANCHEZ ST | 400 - 442 SANCHEZ ST | 400 SANCHEZ ST | - | DORLAND ST | DORLAND ST |
| 66457 | N/A | Point | 1 | 1 | 400 - 442 | - | S257047 | 400-442 SANCHEZ ST | 400-442 SANCHEZ ST | F | F | - | F | 11513000 | 11513000 | - | - | EAST SIDE | - | - | - | - | 17TH ST | 17TH ST | 100663 | 100663 | 37.76241678 | -122.43069451 | - | - | 1710539427000 | MTA | PARK AT 90 DEGREES | 17TH ST to DORLAND ST (400 - 442) | - | 30FT SOUTH OF 17TH ST | - | - | - | - | - | 83573 | 1578303000000 | -122.43069451 | 37.76241678 | - | 1643241600000 | - | D8 | - | PARKING:PARK AT 90 | REG | R(SF).0372 | 18X18 | SUP2 | 2 POST ALUMINUM | IS | 1565865300000 | SANCHEZ ST | 400 - 442 SANCHEZ ST | 400 - 442 SANCHEZ ST | 400 SANCHEZ ST | - | DORLAND ST | DORLAND ST |
| 66458 | N/A | Point | 1 | 1 | 700 - 799 | - | S254226 | 700-799 23RD AVE | 700-799 23RD AVE | F | F | - | F | 1217000 | 1217000 | - | - | WEST SIDE | - | - | - | - | CABRILLO ST | CABRILLO ST | 100664 | 100664 | 37.77360083 | -122.48211637 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM 2ND & 4TH THUR OF MONTH STCL | CABRILLO ST to FULTON ST (700 - 799) | - | NPL 707 | - | - | - | - | - | 83574 | 1221091200000 | -122.48211637 | 37.77360083 | - | 1577664000000 | - | D1 | - | STREET CLEANING | REG | R30B(CA).0256 | 18X18 | SUP2 | 2IN IRON POST | IS | 1557318540000 | 23RD AVE | 700 - 799 23RD AVE | 700 - 799 23RD AVE | 700 23RD AVE | - | FULTON ST | FULTON ST |
| 66459 | N/A | Point | - | - | - | - | S254402 | NATOMA ST: 5TH ST | - | F | F | - | F | 23945000 | 23945000 | - | - | SOUTH SIDE | - | - | - | - | NATOMA ST | 05TH ST | 100665 | 100665 | 37.78192502 | -122.40546628 | 5TH ST \ NATOMA ST | NATOMA ST \ 05TH ST | 1710539427000 | MTA | 1 HR PRK 7AM-6PM EXC SUN | 05TH ST intersection | - | WPL #411 | - | - | - | - | - | 83575 | 1388016000000 | -122.40546628 | 37.78192502 | - | 1551830400000 | - | D6 | - | PARKING | REG | R32(CA).0005 | 18X18 | SUP1 | 2IN IRON POST | IS | 1558091160000 | NATOMA ST | - | - | - | - | - | - |
| 66460 | N/A | Point | - | - | - | - | S254405 | 4TH ST: HOWARD ST | - | F | F | - | F | 24627000 | 24627000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | HOWARD ST | 04TH ST | 100667 | 100667 | 37.78325924 | -122.40270815 | 4TH ST \ HOWARD ST | HOWARD ST \ 04TH ST | 1710539427000 | MTA | (RA) EXC MUNI/(RA) ONLY | 04TH ST intersection | - | 3' NORTH OF HOWARD ST | - | - | - | - | - | 83576 | 1558347840000 | -122.40270815 | 37.78325924 | - | - | - | D6 | - | OTHER REGULATORY | REG | R61(SF).0084 | 48X30 | SUP1 | 2IN IRON POST | IS | 1558092900000 | HOWARD ST | - | - | - | - | - | - |
| 66461 | N/A | Point | - | - | - | - | S266772 | HOLYOKE ST: WOOLSEY ST | - | F | F | - | F | 20861000 | 20861000 | - | - | EAST SIDE | - | - | - | - | HOLYOKE ST | WOOLSEY ST | 100759 | 100759 | 37.72394098 | -122.40754149 | WOOLSEY ST \ HOLYOKE ST | HOLYOKE ST \ WOOLSEY ST | 1754683300000 | middleware_editor | NPRK 8AM-11AM THUR STCL | WOOLSEY ST intersection | - | SPL 273 | - | - | - | - | - | 83577 | 1504076400000 | -122.40754149 | 37.72394098 | - | 1596438000000 | - | D9 | - | STREET CLEANING | REG | R30B(CA).0276 | 18X18 | SUP2 | 2IN IRON POST | IS | 1596203340000 | HOLYOKE ST | - | - | - | - | - | - |
| 66462 | N/A | Point | 1 | 1 | 4438 - 4499 | - | S287516 | 4438-4499 MISSION ST | 4438-4499 MISSION ST | F | F | - | F | 9160000 | 9160000 | - | - | EAST SIDE | - | - | - | - | FRANCIS ST | FRANCIS ST | 100792 | 100792 | 37.72641222 | -122.43349052 | - | - | 1710539427000 | MTA | NPRK 5AM-7AM EVERYDAY INCL HOLIDAY STCL | FRANCIS ST to EXCELSIOR AVE (4438 - 4499) | - | NPL #4441 | - | - | - | - | - | 83578 | 1439510400000 | -122.43349052 | 37.72641222 | - | 1677196800000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0154 | 18X18 | SUP2 | LIGHT POLE | IS | 1676365560000 | MISSION ST | 4438 - 4499 MISSION ST | 4438 - 4499 MISSION ST | 4438 MISSION ST | - | EXCELSIOR AVE | EXCELSIOR AVE |
| 66463 | N/A | Point | - | - | - | - | S286421 | VICENTE ST: 37TH AVE | - | F | F | - | F | 23379000 | 23379000 | - | - | NORTH WEST CORNER | - | - | - | - | 37TH AVE | VICENTE ST | 100819 | 100819 | 37.73847287 | -122.49472055 | VICENTE ST \ 37TH AVE | 37TH AVE \ VICENTE ST | 1710539427000 | MTA | VICENTE ST | VICENTE ST intersection | - | 2600 WEST ---> | - | - | - | - | - | 83579 | - | -122.49472055 | 37.73847287 | - | - | - | D4 | - | STREET NAME | GUIDE | D3-1.1802 | 36X08 | SUP2 | 3IN IRON POST | IS | 1670500920000 | 37TH AVE | - | - | - | - | - | - |
| 66464 | N/A | Point | 1 | 1 | 100 - 699 | - | S284586 | 100-699 23RD ST | 100-699 23RD ST | F | F | - | F | 1232000 | 1232000 | - | - | NORTH SIDE | - | - | - | - | START: 100-699 BLOCK | START: 100-699 BLOCK | 102557 | 102557 | 37.75557489 | -122.38499884 | - | - | 1710539427000 | MTA | PARK AT 90 DEGREES (SYM) | START: 100-699 BLOCK to ILLINOIS ST (100 - 699) | - | 50' EAST OF ILLINOIS. | - | - | - | - | - | 83580 | - | -122.38499884 | 37.75557489 | - | 1666569600000 | - | D10 | - | PARKING:PARK AT 90 | REG | R(SF).0182 | 18X18 | SUP1 | LIGHT POLE | IS | 1660815360000 | 23RD ST | 100 - 699 23RD ST | 100 - 699 23RD ST | 100 23RD ST | - | ILLINOIS ST | ILLINOIS ST |
| 66465 | N/A | Point | - | - | - | - | S265943 | LAKE ST: ARGUELLO BLVD | - | T | T | - | F | 27578000 | 27578000 | - | - | NORTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | LAKE ST | ARGUELLO BLVD | 102567 | 102567 | 37.78691387 | -122.45927953 | ARGUELLO BLVD \ LAKE ST | LAKE ST \ ARGUELLO BLVD | 1755185058000 | middleware_editor | ARGUELLO BLVD | ARGUELLO BLVD intersection | - | 10' W OF ARGUELLO | - | - | - | - | - | 83581 | 1598636280000 | -122.45927953 | 37.78691387 | - | - | - | D2 | - | STREET NAME | GUIDE | D3-2.0072 | 72X18 | SUP1 | LIGHT POLE | IS | 1594203360000 | LAKE ST | - | - | - | - | - | - |
| 66466 | N/A | Point | - | - | - | - | S284604 | OCTAVIA ST: FELL ST | - | F | F | - | F | 25914000 | 25914000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | OCTAVIA ST | FELL ST | 102587 | 102587 | 37.77575396 | -122.42432465 | FELL ST \ OCTAVIA ST | OCTAVIA ST \ FELL ST | 1710539427000 | MTA | PROVISIONAL-ASSIGN NEW SIGN CODE WHEN CREATED IN SHOPS | FELL ST intersection | - | - | - | - | - | - | - | 83582 | 1665014400000 | -122.42432465 | 37.77575396 | - | - | - | D5 | - | PROVISIONAL | MISC | PROVISIONAL CODE | N/A | SUP1 | LIGHT POLE | IS | 1660823340000 | OCTAVIA ST | - | - | - | - | - | - |
| 66467 | N/A | Point | 1 | - | - | - | S284605 | 331-399 OCTAVIA ST | - | F | F | - | F | 9881000 | 9881000 | - | - | WEST SIDE | - | - | - | - | - | - | 102588 | 102588 | 37.77550844 | -122.42438724 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM WED STCL | - | - | 35' SOUTH OF FELL ST | - | - | - | - | - | 83583 | 1124841600000 | -122.42438724 | 37.77550844 | - | 1665014400000 | - | D5 | - | STREET CLEANING | REG | R30B(CA).0086 | 18X18 | SUP1 | 2IN IRON POST | IS | 1660823640000 | OCTAVIA ST | 331-399 OCTAVIA ST | OCTAVIA ST | - | - | - | - |
| 66468 | N/A | Point | - | - | - | - | S284607 | OCTAVIA ST: FELL ST | - | F | T | - | F | 25914000 | 25914000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | OCTAVIA ST | FELL ST | 102589 | 102589 | 37.77575396 | -122.42432465 | FELL ST \ OCTAVIA ST | OCTAVIA ST \ FELL ST | 1729106331000 | middleware_editor | RIGHT TURN ONLY(SYM) | FELL ST intersection | - | - | - | - | - | - | - | 83584 | - | -122.42432465 | 37.77575396 | - | 1665014400000 | - | D5 | - | OTHER REGULATORY | REG | R3-5.0002 | 30X36 | SUP1 | SIGNAL POLE | IS | 1660823820000 | OCTAVIA ST | - | - | - | - | - | - |
| 66469 | N/A | Point | - | - | - | - | S284626 | OCTAVIA ST: FELL ST | - | F | F | - | F | 25914000 | 25914000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | OCTAVIA ST | FELL ST | 102590 | 102590 | 37.77575396 | -122.42432465 | FELL ST \ OCTAVIA ST | OCTAVIA ST \ FELL ST | 1710539427000 | MTA | NO RIGHT TURN (SYM) | FELL ST intersection | - | - | - | - | - | - | - | 83585 | 1665014400000 | -122.42432465 | 37.77575396 | - | - | - | D5 | - | NO RIGHT TURN | REG | R3-1.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1660830120000 | OCTAVIA ST | - | - | - | - | - | - |
| 66470 | N/A | Point | 1 | 1 | 400 - 499 | - | S284672 | 400-499 GOLDEN GATE AVE | 400-499 GOLDEN GATE AVE | F | F | - | F | 6264000 | 6264000 | - | - | NORTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | LARKIN ST | LARKIN ST | 102591 | 102591 | 37.78134163 | -122.41797703 | - | - | 1720662714000 | middleware_editor | TA (SYM) PLO AT ALL TIMES (5 MIN) | LARKIN ST to POLK ST (400 - 499) | - | 25' EAST OF POLK ST. | - | - | - | - | - | 83586 | 1664236800000 | -122.41797703 | 37.78134163 | - | - | - | D6 | - | OTHER REGULATORY | REG | R38(SF)1.0001 | 14X21 | SUP1 | LIGHT POLE | IS | 1661329980000 | GOLDEN GATE AVE | 400 - 499 GOLDEN GATE AVE | 400 - 499 GOLDEN GATE AVE | 400 GOLDEN GATE AVE | - | POLK ST | POLK ST |
| 66471 | N/A | Point | - | - | - | - | S266572 | BRYANT ST: JACK LONDON ALY | - | F | F | - | F | 24508000 | 24508000 | - | - | NORTH SIDE | - | - | - | - | JACK LONDON ALY | BRYANT ST | 102592 | 102592 | 37.78219955 | -122.39472956 | BRYANT ST \ JACK LONDON ALY | JACK LONDON ALY \ BRYANT ST | 1710539427000 | MTA | NPRK 12MN-2AM MON WED FRI STCL | BRYANT ST intersection | - | 415' EAST OF 3RD ST/ OPPO CL- JACK L A | - | - | - | - | - | 83587 | 1597248540000 | -122.39472956 | 37.78219955 | - | - | - | D6 | - | STREET CLEANING | REG | R30B(CA).0034 | 18X18 | SUP1 | LIGHT POLE | IS | 1595850720000 | JACK LONDON ALY | - | - | - | - | - | - |
| 66472 | N/A | Point | - | - | - | - | S266728 | LINCOLN WAY: LA PLAYA \ MARTIN | - | T | T | - | F | 8386101 | 27964000 | - | - | CENTER ISLAND, E LINE, EASTBOUND | - | - | - | - | 48TH AVE | LA PLAYA \ MARTIN LUTHER KING JR DR | 102597 | 102597 | 37.7640342800433 | -122.509241194618 | - | LINCOLN WAY \ LA PLAYA \ MARTIN LUTHER KING JR DR | 1738257388000 | middleware_editor | DETOUR (VA) | LA PLAYA \ MARTIN LUTHER KING JR DR intersection | - | - | - | - | - | - | - | 83588 | 1596203880000 | -122.50940219 | 37.76403274 | - | 1604275200000 | - | D4 | - | OTHER GUIDE | GUIDE | M4-10.0003 | 48X16 | SUP2 | LIGHT POLE | IS | 1596115320000 | LINCOLN WAY | 4701 - 4799 LINCOLN WAY | - | - | - | LA PLAYA \ MARTIN LUTHER KING JR DR | - |
| 66473 | N/A | Point | - | - | - | - | S266731 | LINCOLN WAY: LA PLAYA \ MARTIN | - | F | F | - | F | 27964000 | 27964000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | LA PLAYA \ LINCOLN WAY | LA PLAYA \ MARTIN LUTHER KING JR DR | 102598 | 102598 | 37.7639122911719 | -122.509472295637 | MARTIN LUTHER KING JR DR \ LA PLAYA \ LINCOLN WAY | LINCOLN WAY \ LA PLAYA \ MARTIN LUTHER KING JR DR | 1738257384000 | middleware_editor | DETOUR (RA) | LA PLAYA \ MARTIN LUTHER KING JR DR intersection | - | UNDER ONE WAY SIGN | - | - | - | - | - | 83589 | 1596205680000 | -122.50940219 | 37.76403274 | - | - | - | D4 | - | OTHER GUIDE | GUIDE | M4-10.0001 | 48X16 | SUP2 | SIGNAL POLE | IS | 1596115500000 | LINCOLN WAY | - | - | - | - | - | - |
| 66474 | N/A | Point | 1 | 1 | 4000 - 4099 | - | S266902 | 4000-4099 NORIEGA ST | 4000-4099 NORIEGA ST | F | F | - | F | 9682000 | 9682000 | - | - | SOUTH SIDE | - | - | - | - | 47TH AVE | 47TH AVE | 102599 | 102599 | 37.75289311 | -122.50701106 | - | - | 1728567309000 | middleware_editor | NPRK 7AM-8AM MON THUR STCL | 47TH AVE to 48TH AVE (4000 - 4099) | - | 40 FT WEST | - | - | - | - | - | 83590 | 1597156080000 | -122.50701106 | 37.75289311 | - | - | - | D4 | - | STREET CLEANING | REG | R30B(CA).0212 | 18X18 | SUP2 | 2IN IRON POST | IS | 1596631320000 | NORIEGA ST | 4000 - 4099 NORIEGA ST | 4000 - 4099 NORIEGA ST | 4000 NORIEGA ST | - | 48TH AVE | 48TH AVE |
| 66475 | N/A | Point | 1 | 1 | 600 - 699 | - | S266925 | 600-699 24TH AVE | 600-699 24TH AVE | F | F | - | F | 1295000 | 1295000 | - | - | EAST SIDE | - | - | - | - | ANZA ST | ANZA ST | 102600 | 102600 | 37.77728266 | -122.48345776 | - | - | 1732049567000 | middleware_editor | NPRK 8AM-10AM 2ND & 4TH WED OF MONTH STCL | ANZA ST to BALBOA ST (600 - 699) | - | 690 | - | - | - | - | - | 83591 | 1221004800000 | -122.48345776 | 37.77728266 | - | - | - | D1 | - | STREET CLEANING | REG | R30B(CA).0258 | 18X18 | SUP2 | 2IN IRON POST | IS | 1596720300000 | 24TH AVE | 600 - 699 24TH AVE | 600 - 699 24TH AVE | 600 24TH AVE | - | BALBOA ST | BALBOA ST |
| 66476 | N/A | Point | - | - | - | - | S286784 | FRANKLIN ST: FILBERT ST | - | F | F | - | F | 26698000 | 26698000 | - | - | SOUTH WEST CORNER | - | - | - | - | FILBERT ST | FRANKLIN ST | 102633 | 102633 | 37.79927567 | -122.42581353 | FRANKLIN ST \ FILBERT ST | FILBERT ST \ FRANKLIN ST | 1710539427000 | MTA | TREE TOP 6FT SPEED BUMP | FRANKLIN ST intersection | - | 0 / 0 | - | - | - | - | - | 83592 | 1673913600000 | -122.42581353 | 37.79927567 | - | - | - | D2 | - | OTHER WARNING | WARNING | W(SF).0109 | 72X18 | SUP1 | STANDARD BASE | IS | 1672147380000 | FILBERT ST | - | - | - | - | - | - |
| 66477 | N/A | Point | - | - | - | - | S286785 | FRANKLIN ST: FILBERT ST | - | F | F | - | F | 26698000 | 26698000 | - | - | NORTH EAST CORNER | - | - | - | - | FILBERT ST | FRANKLIN ST | 102634 | 102634 | 37.79927567 | -122.42581353 | FRANKLIN ST \ FILBERT ST | FILBERT ST \ FRANKLIN ST | 1731697177000 | middleware_editor | TREE TOP 6FT SPEED BUMP | FRANKLIN ST intersection | - | 0 / 0 | - | - | - | - | - | 83593 | 1673913600000 | -122.42581353 | 37.79927567 | - | - | - | D2 | - | OTHER WARNING | WARNING | W(SF).0109 | 72X18 | SUP1 | STANDARD BASE | IS | 1672147620000 | FILBERT ST | - | - | - | - | - | - |
| 66478 | N/A | Point | - | - | - | - | S284482 | STANYAN ST: PAGE ST | - | T | T | - | F | 26440000 | 26440000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | STANYAN ST | STANYAN ST | 103722 | 103722 | 37.77009808 | -122.45372623 | PAGE ST \ STANYAN ST | PAGE ST \ STANYAN ST | 1710539427000 | MTA | NO LEFT TURN (SYM) | STANYAN ST intersection | - | - | - | - | - | - | - | 83594 | 1662595200000 | -122.45372623 | 37.77009808 | - | - | - | D5 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP1 | MUNI POLE | IS | 1660295520000 | PAGE ST | - | - | - | - | - | - |
| 66479 | N/A | Point | 1 | 1 | 2300 - 2399 | - | S286905 | 2300-2399 FOLSOM ST | 2300-2399 FOLSOM ST | F | F | - | F | 5694000 | 5694000 | - | - | EAST SIDE | - | - | - | - | 19TH ST | 19TH ST | 103727 | 103727 | 37.75969744 | -122.41476596 | - | - | 1710539427000 | MTA | BIKE RACK | 19TH ST to 20TH ST (2300 - 2399) | 639168 | 5' N OF SPL 2341/3.5' IN FROM CURB | - | - | - | - | - | 83595 | 1674086400000 | -122.41476596 | 37.75969744 | - | - | - | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1672935540000 | FOLSOM ST | 2300 - 2399 FOLSOM ST | 2300 - 2399 FOLSOM ST | 2300 FOLSOM ST | - | 20TH ST | 20TH ST |
| 66480 | N/A | Point | - | - | - | - | S286964 | CAPP ST: 21ST ST | - | F | F | - | F | 24084000 | 24084000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CAPP ST | 21ST ST | 103728 | 103728 | 37.75710093 | -122.4178119 | 21ST ST \ CAPP ST | CAPP ST \ 21ST ST | 1718224701000 | middleware_editor | WARNING-SUSPICIOUS ACTIVITIES IMMEDIATELY RPTD TO POLICE ETC | 21ST ST intersection | - | - | - | - | - | - | - | 83596 | 1677024000000 | -122.4178119 | 37.75710093 | - | - | - | D9 | - | OTHER WARNING | WARNING | SW(SF).0007 | 18X24 | SUP2 | 2IN IRON POST | IS | 1673346840000 | CAPP ST | - | - | - | - | - | - |
| 66481 | N/A | Point | 1 | 1 | 600 - 699 | - | S286968 | 600-699 CAPP ST | 600-699 CAPP ST | T | T | - | F | 3678000 | 3678000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | 21ST ST | 21ST ST | 103729 | 103729 | 37.75630172 | -122.41773545 | - | - | 1718223818000 | middleware_editor | WARNING-SUSPICIOUS ACTIVITIES IMMEDIATELY RPTD TO POLICE ETC | 21ST ST to 22ND ST (600 - 699) | - | 85' SOUTH OF 21 ST ST. | - | - | - | - | - | 83597 | 1677024000000 | -122.41773545 | 37.75630172 | - | - | - | D9 | - | OTHER WARNING | WARNING | SW(SF).0007 | 18X24 | SUP2 | LIGHT POLE | IS | 1673347440000 | CAPP ST | 600 - 699 CAPP ST | 600 - 699 CAPP ST | 600 CAPP ST | - | 22ND ST | 22ND ST |
| 66482 | N/A | Point | 1 | 1 | 1600 - 1699 | - | S289739 | 1600-1699 QUESADA AVE | 1600-1699 QUESADA AVE | F | F | - | F | 10815000 | 10815000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | LANE ST | LANE ST | 103730 | 103730 | 37.73275661 | -122.39042255 | - | - | 1710539427000 | MTA | TYPE P RIGHT | LANE ST to 03RD ST (1600 - 1699) | - | 10' EAST OF 3RD ST, ON WESTEND K-RAIL | - | - | - | - | - | 83598 | 1686268800000 | -122.39042255 | 37.73275661 | - | - | - | D10 | - | OTHER WARNING | WARNING | TYPE-P(CA).0002 | 12X36 | SUP1 | 2IN FLANGE POST | IS | 1684831020000 | QUESADA AVE | 1600 - 1699 QUESADA AVE | 1600 - 1699 QUESADA AVE | 1600 QUESADA AVE | - | 03RD ST | 03RD ST |
| 66483 | N/A | Point | - | - | - | - | S290038 | SAN JOSE AVE: HAVELOCK ST | - | F | F | - | F | 22116000 | 22116000 | - | - | SOUTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SAN JOSE AVE | SAN JOSE AVE | 103732 | 103732 | 37.72675888 | -122.44158192 | HAVELOCK ST \ SAN JOSE AVE | HAVELOCK ST \ SAN JOSE AVE | 1713922687000 | middleware_editor | PEDESTRIAN (SYM) | SAN JOSE AVE intersection | - | - | - | - | - | - | - | 83599 | 1689257880000 | -122.44158192 | 37.72675888 | - | - | - | D11 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP2 | LIGHT POLE | IS | 1686646980000 | HAVELOCK ST | - | - | - | - | - | - |
| 66484 | N/A | Point | - | - | - | - | S290039 | SAN JOSE AVE: HAVELOCK ST | - | F | F | - | F | 22116000 | 22116000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | SAN JOSE AVE | SAN JOSE AVE | 103733 | 103733 | 37.72675888 | -122.44158192 | HAVELOCK ST \ SAN JOSE AVE | HAVELOCK ST \ SAN JOSE AVE | 1713923270000 | middleware_editor | PEDESTRIAN (SYM) | SAN JOSE AVE intersection | - | - | - | - | - | - | - | 83600 | 1689779820000 | -122.44158192 | 37.72675888 | - | - | - | D11 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP2 | LIGHT POLE | IS | 1686647040000 | HAVELOCK ST | - | - | - | - | - | - |
| 66485 | N/A | Point | - | - | - | - | S290040 | SAN JOSE AVE: HAVELOCK ST | - | F | F | - | F | 22116000 | 22116000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SAN JOSE AVE | SAN JOSE AVE | 103734 | 103734 | 37.72675888 | -122.44158192 | HAVELOCK ST \ SAN JOSE AVE | HAVELOCK ST \ SAN JOSE AVE | 1713922717000 | middleware_editor | PEDESTRIAN (SYM) | SAN JOSE AVE intersection | - | - | - | - | - | - | - | 83601 | 1690195500000 | -122.44158192 | 37.72675888 | - | - | - | D11 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP2 | LIGHT POLE | IS | 1686647160000 | HAVELOCK ST | - | - | - | - | - | - |
| 66486 | N/A | Point | - | - | - | - | S290041 | SAN JOSE AVE: HAVELOCK ST | - | F | F | - | F | 22116000 | 22116000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SAN JOSE AVE | SAN JOSE AVE | 103735 | 103735 | 37.72675888 | -122.44158192 | HAVELOCK ST \ SAN JOSE AVE | HAVELOCK ST \ SAN JOSE AVE | 1713922750000 | middleware_editor | (45 LA-DN) | SAN JOSE AVE intersection | - | - | - | - | - | - | - | 83602 | 1690195380000 | -122.44158192 | 37.72675888 | - | - | - | D11 | - | OTHER WARNING | WARNING | W16-7P.0004 | 24X12 | SUP2 | LIGHT POLE | IS | 1686647280000 | HAVELOCK ST | - | - | - | - | - | - |
| 66487 | N/A | Point | - | - | - | - | S290043 | SAN JOSE AVE: HAVELOCK ST | - | F | F | - | F | 22116000 | 22116000 | - | - | SOUTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SAN JOSE AVE | SAN JOSE AVE | 103736 | 103736 | 37.72675888 | -122.44158192 | HAVELOCK ST \ SAN JOSE AVE | HAVELOCK ST \ SAN JOSE AVE | 1713922747000 | middleware_editor | (45 RA-DN) | SAN JOSE AVE intersection | - | - | - | - | - | - | - | 83603 | 1689777660000 | -122.44158192 | 37.72675888 | - | - | - | D11 | - | OTHER WARNING | WARNING | W16-7P.0006 | 24X12 | SUP2 | LIGHT POLE | IS | 1686647460000 | HAVELOCK ST | - | - | - | - | - | - |
| 66488 | N/A | Point | - | - | - | - | S231573 | BALBOA ST: 43RD AVE | - | F | F | - | F | 27908000 | 27908000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 43RD AVE | BALBOA ST | 106514 | 106514 | 37.775348328 | -122.503843892 | BALBOA ST \ 43RD AVE | 43RD AVE \ BALBOA ST | 1710539427000 | MTA | ALL WAY | BALBOA ST intersection | - | - | - | - | - | - | - | 83604 | 25488000000 | -122.50374465 | 37.77542147 | - | 1490832000000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | LIGHT POLE | IS | 1481099760000 | 43RD AVE | - | - | - | - | - | - |
| 66489 | N/A | Point | - | - | - | - | S273013 | QUESADA AVE: JENNINGS ST | - | T | T | - | F | 20153000 | 20153000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | QUESADA AVE | QUESADA AVE | 106578 | 106578 | 37.73016676 | -122.38585274 | JENNINGS ST \ QUESADA AVE | JENNINGS ST \ QUESADA AVE | 1710539427000 | MTA | SPEED HUMPS AHEAD | QUESADA AVE intersection | - | ABOVE STREET NAMES | - | - | - | - | - | 83605 | 1390435200000 | -122.38585274 | 37.73016676 | - | 1619049600000 | - | D10 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1615192800000 | JENNINGS ST | - | - | - | - | - | - |
| 66490 | N/A | Point | - | - | - | - | S273014 | BURROWS ST: BRUSSELS ST | - | F | F | - | F | 20653000 | 20653000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BURROWS ST | BRUSSELS ST | 106579 | 106579 | 37.72831524 | -122.40608137 | BRUSSELS ST \ BURROWS ST | BURROWS ST \ BRUSSELS ST | 1716254245000 | middleware_editor | SPEED HUMP | BRUSSELS ST intersection | - | ABOVE SIGN | - | - | - | - | - | 83606 | 1107475200000 | -122.40608137 | 37.72831524 | - | 1620000000000 | - | D9 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1615194000000 | BURROWS ST | - | - | - | - | - | - |
| 66491 | N/A | Point | - | - | - | - | S273015 | BURROWS ST: BRUSSELS ST | - | F | F | - | F | 20653000 | 20653000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BURROWS ST | BRUSSELS ST | 106580 | 106580 | 37.72831524 | -122.40608137 | BRUSSELS ST \ BURROWS ST | BURROWS ST \ BRUSSELS ST | 1716254248000 | middleware_editor | SPEED HUMP | BRUSSELS ST intersection | - | - | - | - | - | - | - | 83607 | 1107475200000 | -122.40608137 | 37.72831524 | - | 1620000000000 | - | D9 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1615194060000 | BURROWS ST | - | - | - | - | - | - |
| 66492 | N/A | Point | - | - | - | - | S273030 | ALVISO ST: HOLLOWAY AVE | - | F | F | - | F | 22732000 | 22732000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | HOLLOWAY AVE | HOLLOWAY AVE | 106581 | 106581 | 37.72164438 | -122.46973969 | ALVISO ST \ HOLLOWAY AVE | ALVISO ST \ HOLLOWAY AVE | 1710539427000 | MTA | SPEED HUMPS AHEAD | HOLLOWAY AVE intersection | - | - | - | - | - | - | - | 83608 | 1340064000000 | -122.46973969 | 37.72164438 | - | 1615852800000 | - | D7 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1615199760000 | ALVISO ST | - | - | - | - | - | - |
| 66493 | N/A | Point | - | - | - | - | S273031 | ALVISO ST: URBANO DR | - | F | F | - | F | 22733000 | 22733000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | ALVISO ST | URBANO DR | 106582 | 106582 | 37.72362554 | -122.46873023 | URBANO DR \ ALVISO ST | ALVISO ST \ URBANO DR | 1710539427000 | MTA | SPEED HUMPS AHEAD | URBANO DR intersection | - | X IS URBANO | - | - | - | - | - | 83609 | 1340064000000 | -122.46873023 | 37.72362554 | - | 1615852800000 | - | D7 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1615200060000 | ALVISO ST | - | - | - | - | - | - |
| 66494 | N/A | Point | - | - | - | - | S273034 | 14TH AVE: ULLOA ST | - | F | F | - | F | 22954000 | 22954000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ULLOA ST | ULLOA ST | 106583 | 106583 | 37.74142511 | -122.47010494 | 14TH AVE \ ULLOA ST | 14TH AVE \ ULLOA ST | 1719958338000 | middleware_editor | SPEED HUMPS AHEAD | ULLOA ST intersection | - | - | - | - | - | - | - | 83610 | 98409600000 | -122.47010494 | 37.74142511 | - | 1719846000000 | - | D7 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1615200720000 | 14TH AVE | - | - | - | - | - | - |
| 66495 | N/A | Point | - | - | - | - | S273038 | 14TH AVE: TARAVAL ST | - | F | F | - | F | 22990000 | 22990000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | TARAVAL ST | 14TH AVE | 106584 | 106584 | 37.74328917 | -122.47023492 | 14TH AVE \ TARAVAL ST | TARAVAL ST \ 14TH AVE | 1710539427000 | MTA | SPEED HUMPS AHEAD | 14TH AVE intersection | - | - | - | - | - | - | - | 83611 | 98409600000 | -122.47023492 | 37.74328917 | - | 1615852800000 | - | D7 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1615201020000 | TARAVAL ST | - | - | - | - | - | - |
| 66496 | N/A | Point | - | - | - | - | S273052 | 25TH AVE: ULLOA ST | - | F | F | - | F | 23239000 | 23239000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 25TH AVE | 25TH AVE | 106585 | 106585 | 37.7409001 | -122.48198944 | ULLOA ST \ 25TH AVE | ULLOA ST \ 25TH AVE | 1721956588000 | middleware_editor | SPEED HUMPS AHEAD | 25TH AVE intersection | - | - | - | - | - | - | - | 83612 | 1319500800000 | -122.48198944 | 37.7409001 | - | 1615939200000 | - | D4 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1615202580000 | ULLOA ST | - | - | - | - | - | - |
| 66497 | N/A | Point | - | - | - | - | S273058 | 4TH AVE: CABRILLO ST | - | F | F | - | F | 27238000 | 27238000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CABRILLO ST | CABRILLO ST | 106586 | 106586 | 37.7754674 | -122.46173343 | 4TH AVE \ CABRILLO ST | 04TH AVE \ CABRILLO ST | 1710539427000 | MTA | SPEED HUMPS AHEAD | CABRILLO ST intersection | - | - | - | - | - | - | - | 83613 | 1615987800000 | -122.46173343 | 37.7754674 | - | 1615939200000 | - | D1 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1615208880000 | 04TH AVE | - | - | - | - | - | - |
| 66498 | N/A | Point | - | - | - | - | S271697 | BURROWS ST: GIRARD ST | - | F | F | - | F | 20652000 | 20652000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | GIRARD ST | BURROWS ST | 106841 | 106841 | 37.72857432 | -122.40509102 | BURROWS ST \ GIRARD ST | GIRARD ST \ BURROWS ST | 1726154168000 | middleware_editor | SPEED HUMP | BURROWS ST intersection | - | ABOVE NO TRUCKS SIGN | - | - | - | - | - | 83614 | 137289600000 | -122.40509102 | 37.72857432 | - | 1615161600000 | - | D9 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1611218880000 | GIRARD ST | - | - | - | - | - | - |
| 66499 | N/A | Point | - | - | - | - | S283821 | MISSION ST: 18TH ST | - | T | T | - | F | 24149000 | 24149000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | MISSION ST | 18TH ST | 106843 | 106843 | 37.761744327 | -122.4194527 | 18TH ST \ MISSION ST | MISSION ST \ 18TH ST | 1710539427000 | MTA | SPEED LIMIT 20 | 18TH ST intersection | - | - | - | - | - | - | - | 83615 | 1659312000000 | -122.41935927 | 37.76183586 | - | - | - | D9 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP2 | OVERHEAD MAST ARM | IS | 1656666600000 | MISSION ST | - | - | - | - | - | - |
| 66500 | N/A | Point | 1 | 1 | 600 - 699 | - | S277292 | 600-699 CLARENDON AVE | 600-699 CLARENDON AVE | T | T | - | F | 4076000 | 4076000 | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | - | - | - | - | OLYMPIA WAY | OLYMPIA WAY | 106858 | 106858 | 37.751852362 | -122.458539022 | - | - | 1710539427000 | MTA | (45 LA-DN) | OLYMPIA WAY to LAGUNA HONDA BLVD (600 - 699) | - | WEST CI 400' EAST OF 7TH AVE IFO 600 | - | - | - | - | - | 83616 | 1135814400000 | -122.45900215 | 37.75171522 | - | 1632960000000 | - | D7 | - | OTHER WARNING | WARNING | W16-7P.0004 | 24X12 | SUP2 | LIGHT POLE | IS | 1630417260000 | CLARENDON AVE | 600 - 699 CLARENDON AVE | 600 - 699 CLARENDON AVE | 600 CLARENDON AVE | - | LAGUNA HONDA BLVD | LAGUNA HONDA BLVD |
| 66501 | N/A | Point | 1 | 1 | 600 - 699 | - | S277293 | 600-699 CLARENDON AVE | 600-699 CLARENDON AVE | T | T | - | F | 4076000 | 4076000 | - | - | CENTER ISLAND, WESTBOUND TRAFFIC | - | - | - | - | OLYMPIA WAY | OLYMPIA WAY | 106859 | 106859 | 37.751852361 | -122.458535445 | - | - | 1710539427000 | MTA | (45 RA-DN) | OLYMPIA WAY to LAGUNA HONDA BLVD (600 - 699) | - | WEST CI 400' EAST OF 7TH AVE IFO 600 | - | - | - | - | - | 83617 | 1135814400000 | -122.45900215 | 37.75171522 | - | 1632960000000 | - | D7 | - | OTHER WARNING | WARNING | W16-7P.0006 | 24X12 | SUP2 | LIGHT POLE | IS | 1630417440000 | CLARENDON AVE | 600 - 699 CLARENDON AVE | 600 - 699 CLARENDON AVE | 600 CLARENDON AVE | - | LAGUNA HONDA BLVD | LAGUNA HONDA BLVD |
| 66502 | N/A | Point | 1 | 1 | 400 - 499 | - | S280674 | 400-499 2ND AVE | 400-499 02ND AVE | F | F | - | F | 123000 | 123000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | GEARY BLVD | GEARY BLVD | 106888 | 106888 | 37.78024806 | -122.45993002 | - | - | 1726880572000 | middleware_editor | SPEED HUMPS AHEAD | GEARY BLVD to ANZA ST (400 - 499) | - | IFO 405 ABOVE SIGN | - | - | - | - | - | 83618 | 1646092800000 | -122.45993002 | 37.78024806 | - | - | - | D1 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1643629680000 | 02ND AVE | 400 - 499 2ND AVE | 400 - 499 02ND AVE | 400 2ND AVE | - | ANZA ST | ANZA ST |
| 66503 | N/A | Point | - | - | - | - | S280679 | SANTIAGO ST: 18TH AVE | - | F | F | - | F | 23185000 | 23185000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 18TH AVE | 18TH AVE | 106890 | 106890 | 37.74496403 | -122.4747538 | SANTIAGO ST \ 18TH AVE | SANTIAGO ST \ 18TH AVE | 1711768575000 | middleware_editor | SPEED HUMPS AHEAD | 18TH AVE intersection | - | - | - | - | - | - | - | 83619 | 1646870400000 | -122.4747538 | 37.74496403 | - | - | - | D7 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1643635440000 | SANTIAGO ST | - | - | - | - | - | - |
| 66504 | N/A | Point | - | - | - | - | S273019 | CHANNEL ST: 7TH ST | - | T | T | - | F | 23847000 | 23847000 | - | - | SOUTH WEST CORNER | - | - | - | - | 07TH ST | CHANNEL ST | 106922 | 106922 | 37.76973233 | -122.39904571 | CHANNEL ST \ 07TH ST | 07TH ST \ CHANNEL ST | 1722353384000 | middleware_editor | CHANNEL ST | CHANNEL ST intersection | - | SWC 300>| WEST | - | - | - | - | - | 83620 | 1616578500000 | -122.39904571 | 37.76973233 | - | 1721986200000 | - | D10 | - | STREET NAME | GUIDE | D3-1.0356 | 36X08 | SUP1 | LIGHT POLE | IS | 1615195140000 | 07TH ST | - | - | - | - | - | - |
| 66505 | N/A | Point | - | - | - | - | S102819 | MONTECITO AVE: HAZELWOOD AVE | - | F | F | - | F | 22253000 | 22253000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | MONTECITO AVE | MONTECITO AVE | 106924 | 106924 | 37.73047746 | -122.45428542 | HAZELWOOD AVE \ MONTECITO AVE | HAZELWOOD AVE \ MONTECITO AVE | 1723245638000 | middleware_editor | STOP | MONTECITO AVE intersection | - | 0 / 00 | - | - | - | - | - | 83621 | -384566400000 | -122.45428542 | 37.73047746 | - | 1723200000000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373568420000 | HAZELWOOD AVE | - | - | - | - | - | - |
| 66506 | N/A | Point | 1 | 1 | 2000 - 2099 | - | S239760 | 2000-2099 41ST AVE | 2000-2099 41ST AVE | F | F | - | F | 1918000 | 1918000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | PACHECO ST | PACHECO ST | 107657 | 107657 | 37.7489421945117 | -122.499685100573 | - | - | 1747942911000 | middleware_editor | TA (SYM) PLO 9AM-6PM EVERYDAY (5 MIN) | PACHECO ST to QUINTARA ST (2000 - 2099) | - | 170' SOUTH OF PACHECO | - | - | - | - | - | 83622 | 1509382800000 | -122.49971931 | 37.74853856 | - | 1509346800000 | - | D4 | - | OTHER REGULATORY | REG | R38(SF)1.0061 | 14X21 | SUP2 | 2IN IRON POST | IS | 1508766960000 | 41ST AVE | 2000 - 2099 41ST AVE | 2000 - 2099 41ST AVE | 2000 41ST AVE | - | QUINTARA ST | QUINTARA ST |
| 66507 | N/A | Point | - | - | - | - | S241004 | CHESTNUT ST: COLUMBUS AVE \ TA | - | F | F | - | F | 25468000 | 25468000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CHESTNUT ST \ TAYLOR ST | CHESTNUT ST \ COLUMBUS AVE | 107658 | 107658 | 37.80354233 | -122.41487679 | COLUMBUS AVE \ CHESTNUT ST \ TAYLOR ST | TAYLOR ST \ CHESTNUT ST \ COLUMBUS AVE | 1712626845000 | middleware_editor | NO RIGHT TURN (SYM) ON RED | CHESTNUT ST \ COLUMBUS AVE intersection | - | - | - | - | - | - | - | 83623 | 1513089960000 | -122.41487679 | 37.80354233 | - | 1513036800000 | - | D3 | - | NO RIGHT TURN | REG | R13A(CA).0002 | 24X30 | SUP1 | 2IN IRON POST | IS | 1511963340000 | TAYLOR ST | - | - | - | - | - | - |
| 66508 | N/A | Point | - | - | - | - | S277689 | PAGE ST: BUCHANAN ST | - | F | F | - | F | 25903000 | 25903000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | PAGE ST | BUCHANAN ST | 107659 | 107659 | 37.77345546 | -122.42735744 | BUCHANAN ST \ PAGE ST | PAGE ST \ BUCHANAN ST | 1744121381000 | middleware_editor | SCHOOL (SYM)/SCHOOL | BUCHANAN ST intersection | - | - | - | - | - | - | - | 83624 | 1110182400000 | -122.42735744 | 37.77345546 | - | 1742400900000 | - | D5 | - | SCHOOL | WARNING | SW24-1(CA).0001 | 30X42 | SUP1 | UTILITY POLE | IS | 1631888460000 | PAGE ST | - | - | - | - | - | - |
| 66509 | N/A | Point | - | - | - | - | S274432 | POST ST: LARKIN ST | - | T | T | - | F | 25167000 | 25167000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | POST ST | POST ST | 107660 | 107660 | 37.78703795 | -122.41827098 | LARKIN ST \ POST ST | LARKIN ST \ POST ST | 1710539427000 | MTA | SPEED LIMIT 20 | POST ST intersection | - | - | - | - | - | - | - | 83625 | 28080000000 | -122.41827098 | 37.78703795 | - | 1622678400000 | - | D3 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP1 | MUNI POLE | IS | 1620120840000 | LARKIN ST | - | - | - | - | - | - |
| 66510 | N/A | Point | 1 | 1 | 4900 - 5217 | - | S290213 | 4900-5217 FULTON ST | 4900-5217 FULTON ST | F | F | - | F | 5932000 | 5932000 | - | - | SOUTH SIDE | - | - | - | - | 25TH AVE \ CROSSOVER DR | 25TH AVE \ CROSSOVER DR | 107662 | 107662 | 37.77254474 | -122.48472811 | - | - | 1710539427000 | MTA | NPRK 1PM-3PM THUR STCL | 25TH AVE \ CROSSOVER DR to 26TH AVE (4900 - 5217) | - | 75' WEST OF 25 TH AVE. | - | - | - | - | - | 83626 | - | -122.48472811 | 37.77254474 | - | 1689292800000 | - | D1 | - | STREET CLEANING | REG | R30B(CA).0105 | 18X18 | SUP2 | LIGHT POLE | IS | 1687774440000 | FULTON ST | 4900 - 5217 FULTON ST | 4900 - 5217 FULTON ST | 4900 FULTON ST | - | 26TH AVE | 26TH AVE |
| 66511 | N/A | Point | 1 | 1 | 2800 - 2851 | - | S278717 | 2800-2851 16TH ST | 2800-2851 16TH ST | F | F | - | F | 721000 | 721000 | - | - | NORTH SIDE | - | - | - | - | FOLSOM ST | FOLSOM ST | 107772 | 107772 | 37.765359994 | -122.415842148 | - | - | 1710539427000 | MTA | NPRK 2AM-6AM TUE THUR SUN STCL | FOLSOM ST to SHOTWELL ST (2800 - 2851) | - | 110 FT EAST OF FOLSOM IFO 2840 | - | - | - | - | - | 83627 | 1151625600000 | -122.41584796 | 37.76528207 | - | - | - | D9 | - | STREET CLEANING | REG | R30B(CA).0134 | 18X18 | SUP2 | MUNI POLE | IS | 1636454400000 | 16TH ST | 2800 - 2851 16TH ST | 2800 - 2851 16TH ST | 2800 16TH ST | - | SHOTWELL ST | SHOTWELL ST |
| 66512 | N/A | Point | - | - | - | - | S100813 | OFARRELL ST: GRANT AVE \ MARKE | - | F | F | - | F | 30768000 | 30768000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MARKET ST \ OFARRELL ST | GRANT AVE \ MARKET ST | 107833 | 107833 | 37.78673057 | -122.40458332 | GRANT AVE \ MARKET ST \ OFARRELL ST | OFARRELL ST \ GRANT AVE \ MARKET ST | 1710539427000 | MTA | DO NOT ENTER | GRANT AVE \ MARKET ST intersection | - | - | - | - | - | - | - | 83628 | -402476400000 | -122.40458332 | 37.78673057 | - | 1413782580000 | - | D3 | - | OTHER REGULATORY | REG | R5-1.0003 | 36X36 | SUP1 | LIGHT POLE | IS | 1373566560000 | OFARRELL ST | - | - | - | - | - | - |
| 66513 | N/A | Point | - | - | - | - | S100072 | CAYUGA AVE: THERESA ST | - | F | F | - | F | 21804000 | 21804000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | THERESA ST | CAYUGA AVE | 107835 | 107835 | 37.72912735 | -122.43521544 | CAYUGA AVE \ THERESA ST | THERESA ST \ CAYUGA AVE | 1710539427000 | MTA | STOP | CAYUGA AVE intersection | - | 0 / 0 | - | - | - | - | - | 83629 | -406425600000 | -122.43519577 | 37.72929989 | - | 1393200000000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566320000 | THERESA ST | - | - | - | - | - | - |
| 66514 | N/A | Point | - | - | - | - | S106003 | QUINTARA ST: 35TH AVE | - | F | F | - | F | 23414000 | 23414000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 35TH AVE | 35TH AVE | 107860 | 107860 | 37.747812282 | -122.493331008 | QUINTARA ST \ 35TH AVE | QUINTARA ST \ 35TH AVE | 1710539427000 | MTA | STOP | 35TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 83630 | 113788800000 | -122.49322819 | 37.74788828 | - | 1508457600000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 3IN IRON POST | IS | 1373569440000 | QUINTARA ST | - | - | - | - | - | - |
| 66515 | N/A | Point | - | - | - | - | S122184 | DIVISADERO ST: NORTH POINT ST | - | F | F | - | F | 26994000 | 26994000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | DIVISADERO ST | DIVISADERO ST | 107886 | 107886 | 37.80277414 | -122.44341351 | NORTH POINT ST \ DIVISADERO ST | NORTH POINT ST \ DIVISADERO ST | 1710539427000 | MTA | ALL WAY | DIVISADERO ST intersection | - | - | - | - | - | - | - | 83631 | 1134086400000 | -122.44341351 | 37.80277414 | - | - | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | MUNI POLE | IS | 1373574480000 | NORTH POINT ST | - | - | - | - | - | - |
| 66516 | N/A | Point | - | - | - | - | S116410 | SHOTWELL ST: 17TH ST | - | F | F | - | F | 24135000 | 24135000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | SHOTWELL ST | 17TH ST | 107887 | 107887 | 37.76363514 | -122.41622727 | 17TH ST \ SHOTWELL ST | SHOTWELL ST \ 17TH ST | 1710539427000 | MTA | ALL WAY | 17TH ST intersection | - | - | - | - | - | - | - | 83632 | 1049241600000 | -122.41622727 | 37.76363514 | - | 1624838400000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373572680000 | SHOTWELL ST | - | - | - | - | - | - |
| 66517 | N/A | Point | - | - | - | - | S119906 | BROADWAY: BAKER ST | - | F | F | - | F | 26883000 | 26883000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BROADWAY | BROADWAY | 107888 | 107888 | 37.79301452 | -122.44484314 | BAKER ST \ BROADWAY | BAKER ST \ BROADWAY | 1710539427000 | MTA | STOP | BROADWAY intersection | - | EPL #2901 | - | - | - | - | - | 83633 | 1102377600000 | -122.44484314 | 37.79301452 | - | - | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373573760000 | BAKER ST | - | - | - | - | - | - |
| 66518 | N/A | Point | - | - | - | - | S118990 | 2ND ST: FEDERAL ST | - | F | F | - | F | 24486000 | 24486000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 2ND ST | FEDERAL ST | 107890 | 107890 | 37.78264967 | -122.39308248 | FEDERAL ST \ 2ND ST | 02ND ST \ FEDERAL ST | 1710539427000 | MTA | BICYCLE (SYM) ALLOWED USE OF FULL LANE CVC 21202 | FEDERAL ST intersection | - | 0 / SEE PHOTO ATTACHED | - | - | - | - | - | 83634 | 1086134400000 | -122.39308248 | 37.78264967 | - | - | - | D6 | - | OTHER WARNING | WARNING | W11-1(SF).0001 | 30X30 | SUP1 | 3IN IRON POST | IS | 1373573520000 | 02ND ST | - | - | - | - | - | - |
| 66519 | N/A | Point | - | - | - | - | S119293 | PACHECO ST: 22ND AVE | - | F | F | - | F | 23213000 | 23213000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | PACHECO ST | 22ND AVE | 107891 | 107891 | 37.75036842 | -122.47942562 | 22ND AVE \ PACHECO ST | PACHECO ST \ 22ND AVE | 1748554329000 | middleware_editor | ALL WAY | 22ND AVE intersection | - | - | - | - | - | - | - | 83635 | 1091170800000 | -122.47942562 | 37.75036842 | - | 1748551140000 | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373573580000 | PACHECO ST | - | - | - | - | - | - |
| 66520 | N/A | Point | - | - | - | - | S107402 | IRVING ST: 16TH AVE | - | F | F | - | F | 27359000 | 27359000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | IRVING ST | 16TH AVE | 107892 | 107892 | 37.76370294 | -122.47391309 | 16TH AVE \ IRVING ST | IRVING ST \ 16TH AVE | 1710539427000 | MTA | STOP | 16TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 83636 | 223603200000 | -122.47391309 | 37.76370294 | - | 1705934280000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569860000 | IRVING ST | - | - | - | - | - | - |
| 66521 | N/A | Point | 1 | 1 | 2200 - 2299 | - | S131882 | 2200-2299 BROADWAY | 2200-2299 BROADWAY | F | F | - | F | 3177000 | 3177000 | - | - | NORTH SIDE | - | - | - | - | WEBSTER ST | WEBSTER ST | 108784 | 108784 | 37.79437007 | -122.43409678 | - | - | 1710539427000 | MTA | (H/C SYM) PARK ONLY/MIN FINE $250 | WEBSTER ST to FILLMORE ST (2200 - 2299) | - | 95E / OF FILLMORE ST. | - | - | - | - | - | 83637 | 1262131200000 | -122.43409678 | 37.79437007 | - | - | - | D2 | - | OTHER REGULATORY | REG | R99C(CA).0001 | 12X24 | SUP1 | 2IN IRON POST | IS | 1373577540000 | BROADWAY | 2200 - 2299 BROADWAY | 2200 - 2299 BROADWAY | 2200 BROADWAY | - | FILLMORE ST | FILLMORE ST |
| 66522 | N/A | Point | 1 | 1 | 1 - 199 | - | S130550 | 1-199 PHELAN AVE | 1-199 FRIDA KAHLO WAY | F | F | - | F | 10390000 | 10390000 | - | SHOULD BE RETIRED | CENTER ISLAND, NORTHBOUND TRAFFIC | - | - | - | - | GENEVA AVE \ OCEAN AVE | GENEVA AVE \ OCEAN AVE | 108785 | 108785 | 37.72569285 | -122.45235638 | - | - | 1719582896000 | middleware_editor | STATE LAW YIELD TO PEDS (SYM) | GENEVA AVE \ OCEAN AVE to JUDSON AVE (1 - 199) | - | 8`NORTH OF OLD CROSSWALK (IFO BOOKS..... | - | - | - | - | - | 83638 | 1239235200000 | -122.45235638 | 37.72569285 | - | - | - | D7 | - | OTHER REGULATORY | REG | R1-6.0001 | 12X36 | SUP2 | UNKNOWN | RETD | 1373577120000 | FRIDA KAHLO WAY | 1 - 199 FRIDA KAHLO WAY | 1 - 199 FRIDA KAHLO WAY | 1 FRIDA KAHLO WAY | - | JUDSON AVE | JUDSON AVE |
| 66523 | N/A | Point | 1 | 1 | 1226 - 1299 | - | S134057 | 1226-1299 STANYAN ST | 1226-1299 STANYAN ST | F | F | - | F | 12100000 | 12100000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | 17TH ST | 17TH ST | 108786 | 108786 | 37.76047529 | -122.45175543 | - | - | 1710539427000 | MTA | TWIN PEAKS MARKET ST (LA) | 17TH ST to BELGRAVE AVE (1226 - 1299) | - | NPL #1225 | - | - | - | - | - | 83639 | 1300233600000 | -122.45175543 | 37.76047529 | - | - | - | D5 | - | OTHER GUIDE | GUIDE | G-T(SF).0044 | 36X24 | SUP1 | LIGHT POLE | IS | 1373578200000 | STANYAN ST | 1226 - 1299 STANYAN ST | 1226 - 1299 STANYAN ST | 1226 STANYAN ST | - | BELGRAVE AVE | BELGRAVE AVE |
| 66524 | N/A | Point | 1 | 1 | 1 - 63 | - | S133115 | 12-63 TOWNSEND ST | 1-63 TOWNSEND ST | F | F | - | F | 12654000 | 12654000 | - | - | NORTH SIDE | - | - | - | - | KING ST \ THE EMBARCADERO | KING ST \ THE EMBARCADERO | 108787 | 108787 | 37.78161078 | -122.38908566 | - | - | 1710539427000 | MTA | BACK IN ANGLE PARKING ONLY | KING ST \ THE EMBARCADERO to COLIN P KELLY JR ST (1 - 63) | - | 120FT WEST | - | - | - | - | - | 83640 | 1286236800000 | -122.38908566 | 37.78161078 | - | - | - | D6 | - | PARKING | REG | R(SF).0009 | 18X21 | SUP1 | LIGHT POLE | IS | 1373577900000 | TOWNSEND ST | 1 - 63 TOWNSEND ST | 1 - 63 TOWNSEND ST | 1 TOWNSEND ST | - | COLIN P KELLY JR ST | COLIN P KELLY JR ST |
| 66525 | N/A | Point | 1 | 1 | 800 - 899 | - | S133133 | 800-899 JESSIE ST | 800-899 JESSIE ST | F | F | - | F | 7525000 | 7525000 | - | - | SOUTH SIDE | - | - | - | - | 9TH ST | 09TH ST | 108788 | 108788 | 37.77624093 | -122.41592285 | - | - | 1710539427000 | MTA | TANP ANY TIME | 09TH ST to 10TH ST (800 - 899) | - | 68FT EAST OF 10TH ST | - | - | - | - | - | 83641 | 1286323200000 | -122.41592285 | 37.77624093 | - | - | - | D6 | - | TOW (TANP ANY TIME) | REG | R26K(CA).0038 | 18X21 | SUP1 | 2IN IRON POST | IS | 1373577900000 | JESSIE ST | 800 - 899 JESSIE ST | 800 - 899 JESSIE ST | 800 JESSIE ST | - | 10TH ST | 10TH 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 metersMetadata automatically harvested from the ESRI service during import.