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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 100426 | N/A | Point | 1 | 1 | 2300 - 2399 | - | S212793 | 2300-2399 OFARRELL ST | 2300-2399 OFARRELL ST | T | T | - | F | 9744000 | 9744000 | - | - | NORTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | SAINT JOSEPHS AVE | SAINT JOSEPHS AVE | 52676 | 52676 | 37.78199568 | -122.4427148 | - | - | 1710539427000 | MTA | TWO WAY TRAFFIC AHEAD | SAINT JOSEPHS AVE to LYON ST \ VICHA RATANAPAKDEE WAY (2300 - 2399) | - | 120'W OF ST JOSEPHS | - | - | - | - | - | 117694 | - | -122.4427148 | 37.78199568 | - | - | - | D2 | - | OTHER REGULATORY | REG | R40(CA).0001 | 24X30 | SUP1 | LIGHT POLE | IS | 1421923800000 | OFARRELL ST | 2300 - 2399 OFARRELL ST | 2300 - 2399 OFARRELL ST | 2300 OFARRELL ST | - | LYON ST \ VICHA RATANAPAKDEE WAY | LYON ST \ VICHA RATANAPAKDEE WAY |
| 100427 | N/A | Point | 1 | 1 | 2300 - 2399 | - | S222665 | 2300-2399 OFARRELL ST | 2300-2399 OFARRELL ST | F | F | - | F | 9744000 | 9744000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | SAINT JOSEPHS AVE | SAINT JOSEPHS AVE | 58665 | 58665 | 37.78199568 | -122.4427148 | - | - | 1710539427000 | MTA | ALL WAY | SAINT JOSEPHS AVE to LYON ST \ VICHA RATANAPAKDEE WAY (2300 - 2399) | - | OPP SEC | - | - | - | - | - | 117695 | 340502400000 | -122.4427148 | 37.78199568 | - | - | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1453740840000 | OFARRELL ST | 2300 - 2399 OFARRELL ST | 2300 - 2399 OFARRELL ST | 2300 OFARRELL ST | - | LYON ST \ VICHA RATANAPAKDEE WAY | LYON ST \ VICHA RATANAPAKDEE WAY |
| 100428 | N/A | Point | - | - | - | - | S103557 | ANZA ST: 3RD AVE | - | F | F | - | F | 27236000 | 27236000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 03RD AVE | 03RD AVE | 115622 | 115622 | 37.77923468 | -122.46093127 | ANZA ST \ 03RD AVE | ANZA ST \ 03RD AVE | 1710539427000 | MTA | STOP | 03RD AVE intersection | - | 0 / 00 | - | - | - | - | - | 117696 | -160185600000 | -122.46093127 | 37.77923468 | - | 1149206400000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373568660000 | ANZA ST | - | - | - | - | - | - |
| 100429 | N/A | Point | - | - | - | - | S217139 | 3RD AVE: ANZA ST | - | F | F | - | F | 156000 | 27236000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | ANZA ST | 03RD AVE | 54848 | 54848 | 37.77923468 | -122.46093127 | - | ANZA ST \ 03RD AVE | 1710539427000 | MTA | SPEED HUMPS | 03RD AVE intersection | - | AT NPL# 511 | - | - | - | - | - | 117697 | 1435675200000 | -122.46093127 | 37.77923468 | - | 1435622400000 | - | D1 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1434545460000 | ANZA ST | 500 - 599 03RD AVE | - | - | - | BALBOA ST | - |
| 100430 | N/A | Point | - | - | - | - | S217143 | 3RD AVE: ANZA ST | - | F | F | - | F | 156000 | 27236000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | ANZA ST | 03RD AVE | 54902 | 54902 | 37.77923468 | -122.46093127 | - | ANZA ST \ 03RD AVE | 1710539427000 | MTA | SPEED HUMPS | 03RD AVE intersection | - | AT NPL# 582 | - | - | - | - | - | 117698 | 1438068780000 | -122.46093127 | 37.77923468 | - | 1438041600000 | - | D1 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1434546060000 | ANZA ST | 500 - 599 03RD AVE | - | - | - | BALBOA ST | - |
| 100431 | N/A | Point | - | - | - | - | 25199 | - | - | F | F | - | F | 8049101 | - | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | 1699374957000 | jsanfel | - | - | FONT BLVD | - | 167701 | 167701 | 37.7235580252125 | -122.484967272126 | - | - | 1722531702000 | middleware_editor | FG 300 UR DELINEATOR (W) | - | - | BETWEEN HASHMARKS AND BIKE LANE | - | - | - | - | 9 | 117699 | - | - | - | - | - | - | 07 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP3 | INTERSTATE BASE | IS | - | LAKE MERCED BLVD | 724 - 748 LAKE MERCED BLVD | - | - | - | HIGUERA AVE | - |
| 100432 | N/A | Point | 1 | 1 | 1 - 99 | - | S259573 | 1-99 DR CARLTON B GOODLETT PL | 1-99 DR CARLTON B GOODLETT PL | F | F | - | F | 10549000 | 10549000 | - | - | EAST SIDE | - | - | - | - | GROVE ST \ POLK ST | GROVE ST \ POLK ST | 89089 | 89089 | 37.77937463 | -122.41841255 | - | - | 1729537645000 | middleware_editor | PERMIT PKG ONLY AT ALL TIMES VEH W/PERMIT ISSUED BY SFMTA | GROVE ST \ POLK ST to MCALLISTER ST \ POLK ST (1 - 99) | - | SPACE # 65 (93' S OF CITY HALL XWALK) | - | - | - | - | - | 117700 | 1575900660000 | -122.41841255 | 37.77937463 | - | 1701388800000 | - | D6 | - | OTHER REGULATORY | REG | R32C(SF).0066 | 12X18 | SUP1 | 2IN IRON POST | IS | 1575456180000 | DR CARLTON B GOODLETT PL | 1 - 99 DR CARLTON B GOODLETT PL | 1 - 99 DR CARLTON B GOODLETT PL | 1 DR CARLTON B GOODLETT PL | - | MCALLISTER ST \ POLK ST | MCALLISTER ST \ POLK ST |
| 100433 | N/A | Point | - | - | - | - | S101288 | MISSISSIPPI ST: MARIPOSA ST | - | F | F | - | F | 23674000 | 23674000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | MARIPOSA ST | MARIPOSA ST | 967 | 967 | 37.76396402 | -122.39470864 | MISSISSIPPI ST \ MARIPOSA ST | MISSISSIPPI ST \ MARIPOSA ST | 1711748317000 | middleware_editor | STOP | MARIPOSA ST intersection | - | - | - | - | - | - | - | 117701 | -399366000000 | -122.39470864 | 37.76396402 | - | 1702302000000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373566740000 | MISSISSIPPI ST | - | - | - | - | - | - |
| 100434 | N/A | Point | - | - | - | - | S115657 | MARIPOSA ST: MISSISSIPPI ST | - | F | F | - | F | 23674000 | 23674000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MARIPOSA ST | MARIPOSA ST | 9401 | 9401 | 37.76396402 | -122.39470864 | MISSISSIPPI ST \ MARIPOSA ST | MISSISSIPPI ST \ MARIPOSA ST | 1726264406000 | middleware_editor | NO TRUCKS (SYM) OVER 3 TONS | MARIPOSA ST intersection | - | @ PM | - | - | - | - | - | 117702 | 1037059200000 | -122.39470864 | 37.76396402 | - | 1726221600000 | - | D10 | - | OTHER REGULATORY | REG | R5-2.0005 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373572440000 | MISSISSIPPI ST | - | - | - | - | - | - |
| 100435 | N/A | Point | 1 | 1 | 100 - 171 | - | S250171 | 100-171 CLARA ST | 100-171 CLARA ST | F | F | - | F | 4057000 | 4057000 | - | - | SOUTH SIDE | - | - | - | - | 04TH ST | 04TH ST | 82670 | 82670 | 37.78046122 | -122.40110765 | - | - | 1710539427000 | MTA | 2 HR PRK 9AM-5PM MON-FRI EXC "U" PERMITS | 04TH ST to HULBERT ALY (100 - 171) | - | 135' EAST OF 5TH ST | - | - | - | - | - | 117703 | 1298851200000 | -122.40110765 | 37.78046122 | - | - | - | D6 | - | PARKING:RPP | REG | R32C(CA).0160 | 18X21 | SUP1 | LIGHT POLE | IS | 1544528040000 | CLARA ST | 100 - 171 CLARA ST | 100 - 171 CLARA ST | 100 CLARA ST | - | HULBERT ALY | HULBERT ALY |
| 100436 | N/A | Point | - | - | - | - | S124879 | SANTIAGO ST: 15TH AVE | - | F | F | - | F | 22994000 | 22994000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 15TH AVE | 15TH AVE | 19655 | 19655 | 37.74510911 | -122.4714886 | SANTIAGO ST \ 15TH AVE | SANTIAGO ST \ 15TH AVE | 1756421801000 | middleware_editor | STOP | 15TH AVE intersection | - | - | - | - | - | - | - | 117704 | 1155193200000 | -122.4714886 | 37.74510911 | - | 1521097200000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373575320000 | SANTIAGO ST | - | - | - | - | - | - |
| 100437 | N/A | Point | - | - | - | - | S124880 | SANTIAGO ST: 15TH AVE | - | F | F | - | F | 22994000 | 22994000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 15TH AVE | 15TH AVE | 19656 | 19656 | 37.74510911 | -122.4714886 | SANTIAGO ST \ 15TH AVE | SANTIAGO ST \ 15TH AVE | 1710539427000 | MTA | STOP | 15TH AVE intersection | - | - | - | - | - | - | - | 117705 | 1155168000000 | -122.4714886 | 37.74510911 | - | 1521072000000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373575320000 | SANTIAGO ST | - | - | - | - | - | - |
| 100438 | N/A | Point | - | - | - | - | S106602 | 15TH AVE: SANTIAGO ST | - | F | F | - | F | 22994000 | 22994000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 15TH AVE | 15TH AVE | 113153 | 113153 | 37.74510911 | -122.4714886 | SANTIAGO ST \ 15TH AVE | SANTIAGO ST \ 15TH AVE | 1710539427000 | MTA | STOP | 15TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 117706 | 152755200000 | -122.4714886 | 37.74510911 | - | - | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 3IN IRON POST | IS | 1373569620000 | SANTIAGO ST | - | - | - | - | - | - |
| 100439 | N/A | Point | - | - | - | - | S124891 | SANTIAGO ST: 15TH AVE | - | F | F | - | F | 22994000 | 22994000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 15TH AVE | 15TH AVE | 19958 | 19958 | 37.74510911 | -122.4714886 | SANTIAGO ST \ 15TH AVE | SANTIAGO ST \ 15TH AVE | 1710539427000 | MTA | ALL WAY | 15TH AVE intersection | - | - | - | - | - | - | - | 117707 | 1155168000000 | -122.4714886 | 37.74510911 | - | 1521072000000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373575320000 | SANTIAGO ST | - | - | - | - | - | - |
| 100440 | N/A | Point | - | - | - | - | S219167 | 15TH AVE: SANTIAGO ST | - | F | F | - | F | 22994000 | 22994000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 15TH AVE | 15TH AVE | 59367 | 59367 | 37.74510911 | -122.4714886 | SANTIAGO ST \ 15TH AVE | SANTIAGO ST \ 15TH AVE | 1710539427000 | MTA | ONE WAY (LA) | 15TH AVE intersection | - | - | - | - | - | - | - | 117708 | 489628800000 | -122.4714886 | 37.74510911 | - | 1441843200000 | - | D7 | - | ONE WAY(LA) | REG | R6-1.0004 | 36X12 | SUP2 | 3IN IRON POST | IS | 1441805820000 | SANTIAGO ST | - | - | - | - | - | - |
| 100441 | N/A | Point | 1 | 1 | 2500 - 2599 | LEFT ARROW | S127610 | 2500-2599 HARRISON ST | 2500-2599 HARRISON ST | F | F | - | F | 6754000 | 6754000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | 21ST ST | 21ST ST | 20861 | 20861 | 37.75663102 | -122.41227297 | - | - | 1710539427000 | MTA | TA (SYM) PLO 7AM-5PM SCHOOL DAYS (H/C SYM) | 21ST ST to 22ND ST (2500 - 2599) | - | OPP#2525 UNDER STOP AHEAD | - | - | - | - | - | 117709 | 1180569600000 | -122.41227297 | 37.75663102 | - | 1537228800000 | - | D9 | - | OTHER REGULATORY | REG | R38(SF)6.0021 | 14X21 | SUP2 | LIGHT POLE | IS | 1373576160000 | HARRISON ST | 2500 - 2599 HARRISON ST | 2500 - 2599 HARRISON ST | 2500 HARRISON ST | - | 22ND ST | 22ND ST |
| 100442 | N/A | Point | 1 | 1 | 2500 - 2599 | - | S128250 | 2500-2599 HARRISON ST | 2500-2599 HARRISON ST | F | F | - | F | 6754000 | 6754000 | - | - | WEST SIDE | - | - | - | - | 21ST ST | 21ST ST | 23172 | 23172 | 37.75663102 | -122.41227297 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM MON WED FRI STCL | 21ST ST to 22ND ST (2500 - 2599) | - | OPP #2513 | - | - | - | - | - | 117710 | 1196726400000 | -122.41227297 | 37.75663102 | - | - | - | D9 | - | STREET CLEANING | REG | R30B(CA).0265 | 18X18 | SUP2 | LIGHT POLE | IS | 1373576400000 | HARRISON ST | 2500 - 2599 HARRISON ST | 2500 - 2599 HARRISON ST | 2500 HARRISON ST | - | 22ND ST | 22ND ST |
| 100443 | N/A | Point | 1 | 1 | 2500 - 2599 | RIGHT ARROW | S127611 | 2500-2599 HARRISON ST | 2500-2599 HARRISON ST | F | F | - | F | 6754000 | 6754000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | 21ST ST | 21ST ST | 20923 | 20923 | 37.75663102 | -122.41227297 | - | - | 1710539427000 | MTA | TA (SYM) PLO 7AM-5PM SCHOOL DAYS (H/C SYM) | 21ST ST to 22ND ST (2500 - 2599) | - | OPP#2527 | - | - | - | - | - | 117711 | 1180569600000 | -122.41227297 | 37.75663102 | - | - | - | D9 | - | OTHER REGULATORY | REG | R38(SF)6.0021 | 14X21 | SUP2 | 2IN IRON POST | IS | 1373576160000 | HARRISON ST | 2500 - 2599 HARRISON ST | 2500 - 2599 HARRISON ST | 2500 HARRISON ST | - | 22ND ST | 22ND ST |
| 100444 | N/A | Point | - | - | - | - | 23633 | - | - | - | T | - | - | - | - | - | - | - | 1693493002000 | wdwilli | - | - | - | - | 152881 | 152881 | 37.7383216163759 | -122.40536487501 | - | - | 1710539427000 | MTA | NO IDLING BUSES AND TRUCKS (SYM) | - | - | 60 ' E. BOUTWELL | - | - | - | - | - | 117712 | - | - | - | - | 1704708000000 | - | 10 | - | OTHER REGULATORY | REG | SR62(SF).0002 | 24X30 | SUP1 | LIGHT POLE | IS | - | - | - | - | - | - | - | - |
| 100445 | N/A | Point | 1 | 1 | 2500 - 2599 | - | S113819 | 2500-2599 GOLDEN GATE AVE | 2500-2599 GOLDEN GATE AVE | F | F | - | F | 6287000 | 6287000 | - | - | NORTH SIDE | - | - | - | - | TEMESCAL TER | TEMESCAL TER | 11000 | 11000 | 37.77691482 | -122.45271105 | - | - | 1727719462000 | middleware_editor | 2 HR PRK 8AM-8PM MON-FRI EXC AREA "BB" PERMITS | TEMESCAL TER to PARKER AVE (2500 - 2599) | - | 105' E / OF PARKER BELOW ST.CLEANING T..... | - | - | - | - | - | 117713 | 996624000000 | -122.45271105 | 37.77691482 | - | - | - | D1 | - | PARKING:RPP | REG | R32C(CA).0118 | 18X21 | SUP2 | 2IN IRON POST | IS | 1373571840000 | GOLDEN GATE AVE | 2500 - 2599 GOLDEN GATE AVE | 2500 - 2599 GOLDEN GATE AVE | 2500 GOLDEN GATE AVE | - | PARKER AVE | PARKER AVE |
| 100446 | N/A | Point | 1 | 1 | 2500 - 2599 | - | S201753 | 2500-2599 GOLDEN GATE AVE | 2500-2599 GOLDEN GATE AVE | F | F | - | F | 6287000 | 6287000 | - | - | SOUTH SIDE | - | - | - | - | TEMESCAL TER | TEMESCAL TER | 44649 | 44649 | 37.77691482 | -122.45271105 | - | - | 1710539427000 | MTA | NPRK 6AM-7AM WED STCL | TEMESCAL TER to PARKER AVE (2500 - 2599) | - | 50'E | - | - | - | - | - | 117714 | 1409234880000 | -122.45271105 | 37.77691482 | - | 1409184000000 | - | D1 | - | STREET CLEANING | REG | R30B(CA).0179 | 18X18 | SUP2 | LIGHT POLE | IS | 1389012300000 | GOLDEN GATE AVE | 2500 - 2599 GOLDEN GATE AVE | 2500 - 2599 GOLDEN GATE AVE | 2500 GOLDEN GATE AVE | - | PARKER AVE | PARKER AVE |
| 100447 | N/A | Point | 1 | 1 | 2500 - 2599 | - | S227546 | 2500-2599 GOLDEN GATE AVE | 2500-2599 GOLDEN GATE AVE | F | F | - | F | 6287000 | 6287000 | - | - | SOUTH SIDE | - | - | - | - | TEMESCAL TER | TEMESCAL TER | 61413 | 61413 | 37.77691482 | -122.45271105 | - | - | 1710539427000 | MTA | 4HR PRK 8AM-6PM MON-FRI EXC "L" OR" BB" PERMITS | TEMESCAL TER to PARKER AVE (2500 - 2599) | - | OPP.#2550 | - | - | - | - | - | 117715 | 1471010760000 | -122.45271105 | 37.77691482 | - | 1470960000000 | - | D1 | - | PARKING:RPP | REG | R32C(CA).0233 | 18X21 | SUP2 | LIGHT POLE | IS | 1469627520000 | GOLDEN GATE AVE | 2500 - 2599 GOLDEN GATE AVE | 2500 - 2599 GOLDEN GATE AVE | 2500 GOLDEN GATE AVE | - | PARKER AVE | PARKER AVE |
| 100448 | N/A | Point | 1 | 1 | 2500 - 2599 | - | S220073 | 2500-2599 GOLDEN GATE AVE | 2500-2599 GOLDEN GATE AVE | F | F | - | F | 6287000 | 6287000 | - | - | SOUTH SIDE | - | - | - | - | TEMESCAL TER | TEMESCAL TER | 59196 | 59196 | 37.77691482 | -122.45271105 | - | - | 1714599266000 | middleware_editor | NPRK 6AM-7AM WED STCL | TEMESCAL TER to PARKER AVE (2500 - 2599) | - | 25FT. EAST OF PARKER AVE | - | - | - | - | - | 117716 | 1445866200000 | -122.45271105 | 37.77691482 | - | 1714401120000 | - | D1 | - | STREET CLEANING | REG | R30B(CA).0179 | 18X18 | SUP2 | LIGHT POLE | IS | 1445270460000 | GOLDEN GATE AVE | 2500 - 2599 GOLDEN GATE AVE | 2500 - 2599 GOLDEN GATE AVE | 2500 GOLDEN GATE AVE | - | PARKER AVE | PARKER AVE |
| 100449 | N/A | Point | 1 | 1 | 5420 - 5499 | - | S284754 | 5420-5499 MISSION ST | 5420-5499 MISSION ST | T | T | - | F | 21510000 | 9186000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | MISSION ST | FLORENTINE AVE | 120453 | 120453 | 37.7135717469041 | -122.443611371136 | OTTAWA AVE \ MISSION ST | - | 1750181542000 | middleware_editor | SPEED LIMIT 20 | FLORENTINE AVE to GUTTENBERG ST (5420 - 5499) | - | IFO# 5419 | - | - | - | - | - | 117717 | 1666594800000 | -122.44426136 | 37.71307276 | - | - | 1750181460000 | D11 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP2 | LIGHT POLE | RETD | 1661424720000 | MISSION ST | - | 5420 - 5499 MISSION ST | 5420 MISSION ST | - | - | GUTTENBERG ST |
| 100450 | N/A | Point | - | - | - | - | S247440 | 18TH ST: PENNSYLVANIA AVE | - | F | F | - | F | 23654000 | 23654000 | - | - | NORTH EAST CORNER | - | - | - | - | PENNSYLVANIA AVE | 18TH ST | 79352 | 79352 | 37.76275553 | -122.39361254 | 18TH ST \ PENNSYLVANIA AVE | PENNSYLVANIA AVE \ 18TH ST | 1729102521000 | middleware_editor | 18TH ST | 18TH ST intersection | - | II <--1100 W | - | - | - | - | - | 117718 | 1546594320000 | -122.39361254 | 37.76275553 | - | - | - | D10 | - | STREET NAME | GUIDE | D3-1.1922 | 36X08 | SUP1 | MUNI POLE | IS | 1533116100000 | PENNSYLVANIA AVE | - | - | - | - | - | - |
| 100451 | N/A | Point | - | - | - | - | S226832 | PENNSYLVANIA AVE: 18TH ST | - | F | F | - | F | 23654000 | 23654000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | PENNSYLVANIA AVE | 18TH ST | 68105 | 68105 | 37.76275553 | -122.39361254 | 18TH ST \ PENNSYLVANIA AVE | PENNSYLVANIA AVE \ 18TH ST | 1729102579000 | middleware_editor | NO TRUCKS (SYM) OVER 3T EXC 1 BLOCK FOR DELIVERIES | 18TH ST intersection | - | - | - | - | - | - | - | 117719 | 1466692740000 | -122.39361254 | 37.76275553 | - | 1466640000000 | - | D10 | - | OTHER REGULATORY | REG | R5-2.0012 | 30X42 | SUP1 | 2IN IRON POST | IS | 1466584020000 | PENNSYLVANIA AVE | - | - | - | - | - | - |
| 100452 | N/A | Point | - | - | - | - | S115649 | 18TH ST: PENNSYLVANIA AVE | - | F | F | - | F | 23654000 | 23654000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | PENNSYLVANIA AVE | 18TH ST | 106814 | 106814 | 37.76275553 | -122.39361254 | 18TH ST \ PENNSYLVANIA AVE | PENNSYLVANIA AVE \ 18TH ST | 1729102641000 | middleware_editor | (LA) I-280 NORTH | 18TH ST intersection | - | - | - | - | - | - | - | 117720 | 1036540800000 | -122.39361254 | 37.76275553 | - | - | - | D10 | - | OTHER GUIDE | GUIDE | G-I(SF).0008 | 48X48 | SUP1 | LIGHT POLE | IS | 1373572440000 | PENNSYLVANIA AVE | - | - | - | - | - | - |
| 100453 | N/A | Point | - | - | - | - | S247438 | 18TH ST: PENNSYLVANIA AVE | - | F | F | - | F | 23654000 | 23654000 | - | - | SOUTH WEST CORNER | - | - | - | - | PENNSYLVANIA AVE | 18TH ST | 79351 | 79351 | 37.76275553 | -122.39361254 | 18TH ST \ PENNSYLVANIA AVE | PENNSYLVANIA AVE \ 18TH ST | 1729102523000 | middleware_editor | 18TH ST | 18TH ST intersection | - | II 1100-->W | - | - | - | - | - | 117721 | 1546594260000 | -122.39361254 | 37.76275553 | - | - | - | D10 | - | STREET NAME | GUIDE | D3-1.1922 | 36X08 | SUP1 | MUNI POLE | IS | 1533116040000 | PENNSYLVANIA AVE | - | - | - | - | - | - |
| 100454 | N/A | Point | - | - | - | - | S226830 | PENNSYLVANIA AVE: 18TH ST | - | T | T | - | F | 23654000 | 23654000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | PENNSYLVANIA AVE | 18TH ST | 68104 | 68104 | 37.76275553 | -122.39361254 | 18TH ST \ PENNSYLVANIA AVE | PENNSYLVANIA AVE \ 18TH ST | 1729102579000 | middleware_editor | NO TRUCKS (SYM) OVER 3 TONS | 18TH ST intersection | - | - | - | - | - | - | - | 117722 | - | -122.39361254 | 37.76275553 | - | - | - | D10 | - | OTHER REGULATORY | REG | R5-2.0004 | 24X24 | SUP1 | LIGHT POLE | IS | 1466583660000 | PENNSYLVANIA AVE | - | - | - | - | - | - |
| 100455 | N/A | Point | - | - | - | - | S247442 | 18TH ST: PENNSYLVANIA AVE | - | F | F | - | F | 23654000 | 23654000 | - | - | NORTH WEST CORNER | - | - | - | - | PENNSYLVANIA AVE | 18TH ST | 79354 | 79354 | 37.76275553 | -122.39361254 | 18TH ST \ PENNSYLVANIA AVE | PENNSYLVANIA AVE \ 18TH ST | 1729102523000 | middleware_editor | PENNSYLVANIA AVE | 18TH ST intersection | - | 300--> II S | - | - | - | - | - | 117723 | 1545839520000 | -122.39361254 | 37.76275553 | - | - | - | D10 | - | STREET NAME | GUIDE | D3-1.1369 | 36X08 | SUP1 | LIGHT POLE | IS | 1533116460000 | PENNSYLVANIA AVE | - | - | - | - | - | - |
| 100456 | N/A | Point | - | - | - | - | S247441 | 18TH ST: PENNSYLVANIA AVE | - | F | F | - | F | 23654000 | 23654000 | - | - | SOUTH EAST CORNER | - | - | - | - | PENNSYLVANIA AVE | 18TH ST | 79353 | 79353 | 37.76275553 | -122.39361254 | 18TH ST \ PENNSYLVANIA AVE | PENNSYLVANIA AVE \ 18TH ST | 1729102529000 | middleware_editor | PENNSYLVANIA AVE | 18TH ST intersection | - | II 300--> S | - | - | - | - | - | 117724 | 1546594380000 | -122.39361254 | 37.76275553 | - | - | - | D10 | - | STREET NAME | GUIDE | D3-1.1369 | 36X08 | SUP1 | LIGHT POLE | IS | 1533116400000 | PENNSYLVANIA AVE | - | - | - | - | - | - |
| 100457 | N/A | Point | - | - | - | - | 22216 | - | - | F | F | - | F | 24133000 | - | - | - | NORTH WEST CORNER | 1692223496000 | elclark | - | - | 18TH ST | - | 147041 | 147041 | 37.7619416174288 | -122.418331802056 | CAPP ST \ 18TH ST | - | 1743631030000 | middleware_editor | CAPP ST | - | - | NWC |<300 | - | - | - | - | - | 117725 | - | - | - | - | 1697221800000 | - | 09 | HIGH INTENSITY PRISMATIC (TYPE IV WITH OL-1000 ANTI GRAFFITI OVERLAY FILM) | STREET NAME | GUIDE | D3-1.0316 | 36X08 | SUP3 | SIGNAL POLE | IS | - | - | - | - | - | - | - | - |
| 100458 | N/A | Point | - | - | - | - | 22217 | - | - | F | F | - | F | 24133000 | - | - | - | SOUTH EAST CORNER | 1692223578000 | elclark | - | - | 18TH ST | - | 147057 | 147057 | 37.761973954321 | -122.4183002861 | CAPP ST \ 18TH ST | - | 1710539427000 | MTA | CAPP ST | - | - | SEC |<300 SOUTH | - | - | - | - | - | 117726 | - | - | - | - | 1697199300000 | - | 09 | HIGH INTENSITY PRISMATIC (TYPE IV WITH OL-1000 ANTI GRAFFITI OVERLAY FILM) | STREET NAME | GUIDE | D3-1.0316 | 36X08 | SUP3 | SIGNAL POLE | IS | - | - | - | - | - | - | - | - |
| 100459 | N/A | Point | - | - | - | - | S267220 | - | - | F | F | - | F | 8753000 | - | TYPE-DL.0001-None-37.736671--122.359657 | - | NORTH SIDE | 1689201652000 | MTA | - | - | - | - | 140689 | 140689 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | DELINEATOR (W) (SAFE HIT) | - | - | - | - | - | - | - | - | 117727 | - | - | - | - | 1684195200000 | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0001 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | - | - | 1300-1399 MARKET ST | - | - | - | - | - |
| 100460 | N/A | Point | - | - | - | - | S216720 | MARKET ST: 8TH ST \ GROVE ST \ | - | F | F | - | F | 8752201 | 24429000 | - | - | NORTH SIDE | - | - | - | - | 08TH ST \ GROVE ST \ HYDE ST | 08TH ST \ GROVE ST \ MARKET ST | 56570 | 56570 | 37.77871943 | -122.41474122 | - | HYDE ST \ 08TH ST \ GROVE ST \ MARKET ST | 1756326801000 | middleware_editor | FG 300 UR DELINEATOR (W) | 08TH ST \ GROVE ST \ MARKET ST intersection | - | FROM 15' W TO 297' W OF HYDE/TOTAL OF 25/10' O.C. | - | - | - | - | - | 117728 | - | -122.41474122 | 37.77871943 | - | 1756327500000 | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1433243160000 | HYDE ST | 1200 - 1298 MARKET ST | - | - | - | HAYES ST | - |
| 100461 | N/A | Point | 1 | 1 | 2100 - 2199 | - | S211282 | 2100-2199 FRANKLIN ST | 2100-2199 FRANKLIN ST | F | F | - | F | 5830000 | 5830000 | - | - | EAST SIDE | - | - | - | - | JACKSON ST | JACKSON ST | 52915 | 52915 | 37.793956826 | -122.424655615 | - | - | 1711041475000 | MALOPEZ | NPRK 9AM-11AM TUE STCL | JACKSON ST to PACIFIC AVE (2100 - 2199) | - | 93 FT. NORTH OF JACKSON ST. | - | - | - | - | - | 117729 | - | -122.42478302 | 37.79416666 | - | 1697202180000 | - | D2 | - | STREET CLEANING | REG | R30B(CA).0308 | 18X18 | SUP1 | 2IN IRON POST | IS | 1417518000000 | FRANKLIN ST | 2100 - 2199 FRANKLIN ST | 2100 - 2199 FRANKLIN ST | 2100 FRANKLIN ST | - | PACIFIC AVE | PACIFIC AVE |
| 100462 | N/A | Point | - | - | - | - | S254185 | - | - | F | F | - | F | 2177000 | - | - | - | NORTH SIDE | 1689201376000 | MTA | - | - | - | - | 131927 | 131927 | 37.71058004 | -122.45442134 | - | - | 1710539427000 | MTA | BIKE WAYFINDING SIGN | - | 0742 | 30' W OF DE WOLF ST/ E OF SICKLES | - | - | - | - | - | 117730 | 1562578080000 | - | - | - | - | - | D11 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP2 | 2IN IRON POST | IS | - | - | 3053 - 3099 ALEMANY BLVD | - | - | - | - | - |
| 100463 | N/A | Point | - | - | - | - | S132792 | - | - | F | F | - | F | 2177000 | - | - | - | EAST SIDE, NORTHBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 131558 | 131558 | 37.71058004 | -122.45442134 | - | - | 1722531942000 | middleware_editor | YIELD HERE TO PED (SYM) (LA) | - | - | OPP#3000 | - | - | - | - | - | 117731 | 1282694400000 | - | - | - | - | - | D11 | - | PEDESTRIAN | REG | R1-5A.0002 | 30X30 | SUP2 | 2IN IRON POST | RETD | - | - | 3053 - 3099 ALEMANY BLVD | - | - | - | - | - |
| 100464 | N/A | Point | - | - | - | - | S255591 | PEARL ST: MARKET ST \ MCCOPPIN | - | F | F | - | F | 30759000 | 30759000 | - | - | EAST SIDE | - | - | - | - | MCCOPPIN ST \ PEARL ST | MCCOPPIN ST \ PEARL ST | 88568 | 88568 | 37.77136901 | -122.42397338 | MARKET ST \ MCCOPPIN ST \ PEARL ST | MARKET ST \ MCCOPPIN ST \ PEARL ST | 1710539427000 | MTA | GETAROUND | MCCOPPIN ST \ PEARL ST intersection | - | INTERSECTION OF MARKET/ 38 FT SOUTH | - | - | - | - | - | 117732 | 1523577600000 | -122.42397338 | 37.77136901 | - | 1562889600000 | - | D8 | - | OTHER GUIDE | GUIDE | G-G(SF).0037 | 05X12 | SUP2 | 2IN IRON POST | IS | 1561375440000 | MARKET ST | - | - | - | - | - | - |
| 100465 | N/A | Point | - | - | - | - | S244004 | PEARL ST: MARKET ST \ MCCOPPIN | - | F | F | - | F | 30759000 | 30759000 | - | - | EAST SIDE | - | - | - | - | MCCOPPIN ST \ PEARL ST | MCCOPPIN ST \ PEARL ST | 84210 | 84210 | 37.77136901 | -122.42397338 | MARKET ST \ MCCOPPIN ST \ PEARL ST | MARKET ST \ MCCOPPIN ST \ PEARL ST | 1710539427000 | MTA | TA (SYM) NO STOPPING EXC PERMITTED CSV -CITY CAR SHARE | MCCOPPIN ST \ PEARL ST intersection | - | INTERSECTION OF MARKET/ 38 FT SOUTH | - | - | - | - | - | 117733 | 1523631660000 | -122.42397338 | 37.77136901 | - | 1523577600000 | - | D8 | - | OTHER REGULATORY | REG | R37(SF).0292 | 05X12 | SUP2 | 2IN IRON POST | IS | 1521803940000 | MARKET ST | - | - | - | - | - | - |
| 100466 | N/A | Point | - | - | - | - | S244008 | PEARL ST: MARKET ST \ MCCOPPIN | - | F | F | - | F | 30759000 | 30759000 | - | - | SOUTH EAST CORNER | - | - | - | - | MCCOPPIN ST \ PEARL ST | MCCOPPIN ST \ PEARL ST | 126212 | 126212 | 37.77136901 | -122.42397338 | MARKET ST \ MCCOPPIN ST \ PEARL ST | MARKET ST \ MCCOPPIN ST \ PEARL ST | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | MCCOPPIN ST \ PEARL ST intersection | - | INTERSECTION OF MARKET/ 38 FT SOUTH | - | - | - | - | - | 117734 | 1523972940000 | -122.42397338 | 37.77136901 | - | 1523923200000 | - | D8 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | 2IN IRON POST | IS | 1521804480000 | MARKET ST | - | - | - | - | - | - |
| 100467 | N/A | Point | - | - | - | - | S225502 | MCKINNON AVE: BARNEVELD AVE \ | - | F | F | - | F | 20812000 | 20812000 | - | - | NORTH EAST CORNER | - | - | - | - | BARNEVELD AVE \ LOOMIS ST | BARNEVELD AVE \ LOOMIS ST | 120111 | 120111 | 37.74379436 | -122.40324329 | MCKINNON AVE \ BARNEVELD AVE \ LOOMIS ST | MCKINNON AVE \ BARNEVELD AVE \ LOOMIS ST | 1753818908000 | middleware_editor | STOP | BARNEVELD AVE \ LOOMIS ST intersection | - | OF MCKINNON AVE & BARNEVELD-F/W/B/T | - | - | - | - | - | 117735 | - | -122.40324329 | 37.74379436 | - | - | - | D10 | - | STOP | REG | R1-1.0001 | 24X24 | SUP1 | 2IN IRON POST | IS | 1462875420000 | MCKINNON AVE | - | - | - | - | - | - |
| 100468 | N/A | Point | - | - | - | - | S288398 | MARKET ST: MCCOPPIN ST \ PEARL | - | F | F | - | F | 30759000 | 30759000 | - | - | CENTER ISLAND, E LINE, EASTBOUND | - | - | - | - | MCCOPPIN ST \ PEARL ST | MCCOPPIN ST \ PEARL ST | 120085 | 120085 | 37.77136901 | -122.42397338 | MARKET ST \ MCCOPPIN ST \ PEARL ST | MARKET ST \ MCCOPPIN ST \ PEARL ST | 1730921071000 | middleware_editor | TYPE Q DELINEATOR (W) | MCCOPPIN ST \ PEARL ST intersection | - | - | - | - | - | - | - | 117736 | 1730108700000 | -122.42397338 | 37.77136901 | - | - | - | D8 | - | DELINEATOR 5 | WARNING | TYPE-DL.0004 | 03X36 | SUP2 | ANCHORS | IS | 1680605520000 | MARKET ST | - | - | - | - | - | - |
| 100469 | N/A | Point | - | - | - | - | S271380 | BARNEVELD AVE: LOOMIS ST \ MCK | - | F | F | - | F | 20812000 | 20812000 | - | - | EAST SIDE | - | - | - | - | BARNEVELD AVE \ MCKINNON AVE | BARNEVELD AVE \ LOOMIS ST | 127874 | 127874 | 37.74379436 | -122.40324329 | LOOMIS ST \ BARNEVELD AVE \ MCKINNON AVE | MCKINNON AVE \ BARNEVELD AVE \ LOOMIS ST | 1710539427000 | MTA | NPRK 12MN-6AM TUE STCL | BARNEVELD AVE \ LOOMIS ST intersection | - | 120' S OF JERROLD | - | - | - | - | - | 117737 | 748051200000 | -122.40324329 | 37.74379436 | - | - | - | D10 | - | STREET CLEANING | REG | R30B(CA).0056 | 18X18 | SUP1 | 2IN IRON POST | IS | 1610104500000 | MCKINNON AVE | - | - | - | - | - | - |
| 100470 | N/A | Point | - | - | - | - | S273655 | BARNEVELD AVE: LOOMIS ST \ MCK | - | F | F | - | F | 20812000 | 20812000 | - | - | WEST SIDE | - | - | - | - | BARNEVELD AVE \ MCKINNON AVE | BARNEVELD AVE \ LOOMIS ST | 119951 | 119951 | 37.74379436 | -122.40324329 | LOOMIS ST \ BARNEVELD AVE \ MCKINNON AVE | MCKINNON AVE \ BARNEVELD AVE \ LOOMIS ST | 1710539427000 | MTA | (VA-UP) WHITE ON GREEN | BARNEVELD AVE \ LOOMIS ST intersection | 1160 | ABOVE STOP @ MCKINNON | - | - | - | - | - | 117738 | 748051200000 | -122.40324329 | 37.74379436 | - | 1611100800000 | - | D10 | - | OTHER GUIDE | GUIDE | M7-1.0005 | 12X09 | SUP1 | 2IN IRON POST | IS | 1617017580000 | MCKINNON AVE | - | - | - | - | - | - |
| 100471 | N/A | Point | 1 | 1 | 1500 - 1599 | - | S276665 | 1500-1599 LOWER GREAT HWY | 1500-1599 GREAT HWY | F | F | - | F | 8511000 | 8511000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | KIRKHAM ST \ LA PLAYA | KIRKHAM ST \ LA PLAYA | 122697 | 122697 | 37.75748285 | -122.50900692 | - | - | 1710539427000 | MTA | SPEED HUMPS AHEAD | KIRKHAM ST \ LA PLAYA to LA PLAYA \ LAWTON ST (1500 - 1599) | - | SPL 1590 | - | - | - | - | - | 117739 | 1228176000000 | -122.50900692 | 37.75748285 | - | 1628035200000 | - | D4 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1627556220000 | GREAT HWY | 1500 - 1599 GREAT HWY | 1500 - 1599 GREAT HWY | 1500 GREAT HWY | - | LA PLAYA \ LAWTON ST | LA PLAYA \ LAWTON ST |
| 100472 | N/A | Point | - | - | - | - | 21058 | - | - | F | F | - | F | 8044000 | - | - | - | CENTER ISLAND, W LINE, EASTBOUND | 1689272591000 | malopez | - | - | BERKSHIRE WAY \ LAKESHORE DR | - | 141461 | 141461 | 37.729413812 | -122.494245514 | - | - | 1738253148000 | middleware_editor | BICYCLES (SYM) PEDESTRIAN (SYM) | - | - | CNTR ISLAND @ CROSSWALK OPP.#117 | - | - | - | - | 1 | 117740 | 1691406840000 | - | - | - | - | - | 07 | 1160 PROTECTIVE OVERLAY -CLEAR, 30X50 | OTHER WARNING | WARNING | W11-1(SF).0008 | 30X30 | SUP3 | 2IN IRON POST | IS | - | LAKE MERCED BLVD | 200 - 299 LAKE MERCED BLVD | - | - | - | SUNSET BLVD | - |
| 100473 | N/A | Point | - | - | - | - | S264671 | FRANCISCO ST: POLK ST | - | T | T | - | F | 26702000 | 26702000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | FRANCISCO ST | FRANCISCO ST | 101965 | 101965 | 37.80341264 | -122.42327496 | POLK ST \ FRANCISCO ST | POLK ST \ FRANCISCO ST | 1710539427000 | MTA | AHEAD | FRANCISCO ST intersection | - | - | - | - | - | - | - | 117741 | 1591700040000 | -122.42327496 | 37.80341264 | - | - | - | D2 | - | OTHER WARNING | WARNING | W(SF).0106 | 18X06 | SUP1 | LIGHT POLE | IS | 1590672240000 | POLK ST | - | - | - | - | - | - |
| 100474 | N/A | Point | - | - | - | - | S221892 | GEARY BLVD: 22ND AVE | - | F | F | - | F | 27538000 | 27538000 | - | SHOULD BE RETIRED | CENTER ISLAND, E LINE, WESTBOUND | - | - | - | - | 22ND AVE | GEARY BLVD | 56335 | 56335 | 37.78022582 | -122.48151572 | GEARY BLVD \ 22ND AVE | 22ND AVE \ GEARY BLVD | 1710539427000 | MTA | PEDESTRIAN (SYM) | GEARY BLVD intersection | - | - | - | - | - | - | - | 117742 | - | -122.48151572 | 37.78022582 | - | - | - | D1 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP2 | SIGNAL POLE | RETD | 1452158640000 | 22ND AVE | - | - | - | - | - | - |
| 100475 | N/A | Point | - | - | - | - | S108618 | MARKET ST: CHURCH ST | - | F | F | - | F | 25881000 | 25881000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | MARKET ST | CHURCH ST | 112875 | 112875 | 37.76750446 | -122.42894857 | CHURCH ST \ MARKET ST | MARKET ST \ CHURCH ST | 1747067496000 | middleware_editor | NO LEFT TURN (SYM) | CHURCH ST intersection | - | 0 / 0 | - | - | - | - | - | 117743 | 322556400000 | -122.42894857 | 37.76750446 | - | - | - | D8 | - | NO LEFT TURN | REG | R3-2.0001 | 24X24 | SUP2 | SIGNAL POLE | IS | 1373570220000 | MARKET ST | - | - | - | - | - | - |
| 100476 | N/A | Point | - | - | - | - | S267339 | CHURCH ST: MARKET ST | - | F | F | - | F | 25881000 | 25881000 | - | - | SOUTH WEST CORNER | - | - | - | - | MARKET ST | CHURCH ST | 98869 | 98869 | 37.76750446 | -122.42894857 | CHURCH ST \ MARKET ST | MARKET ST \ CHURCH ST | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | CHURCH ST intersection | - | IN MIDDLE OF LANE | - | - | - | - | - | 117744 | 1115856000000 | -122.42894857 | 37.76750446 | - | 1608163200000 | - | D8 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | INTERSTATE BASE | IS | 1597921080000 | MARKET ST | - | - | - | - | - | - |
| 100477 | N/A | Point | - | - | - | - | S118736 | MARKET ST: CHURCH ST | - | T | T | - | F | 25881000 | 25881000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | MARKET ST | CHURCH ST | 124357 | 124357 | 37.76750446 | -122.42894857 | CHURCH ST \ MARKET ST | MARKET ST \ CHURCH ST | 1710539427000 | MTA | NO TURN ON RED | CHURCH ST intersection | - | NWCORNER | - | - | - | - | - | 117745 | 1081728000000 | -122.42894857 | 37.76750446 | - | - | - | D8 | - | OTHER REGULATORY | REG | R10-11A.0001 | 24X30 | SUP2 | MUNI POLE | IS | 1373573400000 | MARKET ST | - | - | - | - | - | - |
| 100478 | N/A | Point | - | 1 | 300 - 399 | - | S259055 | 0-299 16TH ST | 300-399 16TH ST | F | F | - | F | 15049000 | 15049000 | - | - | SOUTH SIDE | - | - | - | - | TERRY A FRANCOIS BLVD | TERRY A FRANCOIS BLVD | 87571 | 87571 | 37.76701694 | -122.38714988 | - | - | 1744121619000 | middleware_editor | FG 300 UR DELINEATOR (W) | TERRY A FRANCOIS BLVD to ILLINOIS ST (300 - 399) | - | START 145' WEST OF TERRY FRANCOIS | - | - | - | - | - | 117746 | 1573772280000 | -122.38714988 | 37.76701694 | - | 1740089220000 | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | TURNPIKE BASE | IS | 1573126140000 | 16TH ST | 300 - 399 16TH ST | 300 - 399 16TH ST | 300 16TH ST | - | ILLINOIS ST | ILLINOIS ST |
| 100479 | N/A | Point | - | 1 | 300 - 399 | - | S259045 | 0-299 16TH ST | 300-399 16TH ST | F | F | - | F | 15049000 | 15049000 | - | - | SOUTH SIDE | - | - | - | - | TERRY A FRANCOIS BLVD | TERRY A FRANCOIS BLVD | 86979 | 86979 | 37.76701694 | -122.38714988 | - | - | 1744121636000 | middleware_editor | FG 300 UR DELINEATOR (W) | TERRY A FRANCOIS BLVD to ILLINOIS ST (300 - 399) | - | START 30' EAST OF XWALK @ ILLINOIS ST. | - | - | - | - | - | 117747 | 1573769280000 | -122.38714988 | 37.76701694 | - | 1740088980000 | 1653289200000 | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1573124580000 | 16TH ST | 300 - 399 16TH ST | 300 - 399 16TH ST | 300 16TH ST | - | ILLINOIS ST | ILLINOIS ST |
| 100480 | N/A | Point | - | 1 | 300 - 399 | - | S259046 | 0-299 16TH ST | 300-399 16TH ST | F | F | - | F | 15049000 | 15049000 | - | - | SOUTH SIDE | - | - | - | - | TERRY A FRANCOIS BLVD | TERRY A FRANCOIS BLVD | 87262 | 87262 | 37.76701694 | -122.38714988 | - | - | 1740080631000 | middleware_editor | FG 300 UR DELINEATOR (W) | TERRY A FRANCOIS BLVD to ILLINOIS ST (300 - 399) | - | 108' EAST OF E-LINE X-WALK @ ILLINOIS | - | - | - | - | - | 117748 | 1573741080000 | -122.38714988 | 37.76701694 | - | 1738577820000 | 1653264000000 | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | TURNPIKE BASE | IS | 1573124760000 | 16TH ST | 300 - 399 16TH ST | 300 - 399 16TH ST | 300 16TH ST | - | ILLINOIS ST | ILLINOIS ST |
| 100481 | N/A | Point | - | - | - | - | S109911 | PIERCE ST: PAGE ST | - | F | F | - | F | 26003000 | 26003000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | PIERCE ST | PAGE ST | 10130 | 10130 | 37.77262031 | -122.43392219 | PAGE ST \ PIERCE ST | PIERCE ST \ PAGE ST | 1710539427000 | MTA | STOP | PAGE ST intersection | - | - | - | - | - | - | - | 117749 | 567129600000 | -122.43392219 | 37.77262031 | - | 1178841600000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570640000 | PIERCE ST | - | - | - | - | - | - |
| 100482 | N/A | Point | - | - | - | - | S275805 | PACHECO ST: MAGELLAN AVE | - | F | F | - | F | 22894000 | 22894000 | - | - | CENTER ISLAND, W LINE, EASTBOUND | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | PACHECO ST | PACHECO ST | 122828 | 122828 | 37.74636151 | -122.46171004 | MAGELLAN AVE \ PACHECO ST | MAGELLAN AVE \ PACHECO ST | 1717084331000 | middleware_editor | OBJECT MARKER - YELLOW | PACHECO ST intersection | - | WEST TIP OF ISLAND | - | - | - | - | - | 117750 | 811987200000 | -122.46171004 | 37.74636151 | - | 1625011200000 | - | D7 | - | OTHER WARNING | WARNING | TYPE-N(CA).0004 | 30X30 | SUP2 | 2IN IRON POST | IS | 1624884600000 | MAGELLAN AVE | - | - | - | - | - | - |
| 100483 | N/A | Point | - | - | - | - | S212502 | - | - | F | F | - | F | 3031000 | - | - | - | WEST SIDE, WESTBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | - | - | 136953 | 136953 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | OBJECT MARKER - YELLOW | - | - | OPP.C-LINE | - | - | - | - | - | 117751 | 1516320000000 | - | - | - | 1516320000000 | - | D7 | - | OTHER WARNING | WARNING | TYPE-N(CA).0004 | 30X30 | SUP2 | 2IN IRON POST | IS | - | - | 1200-1299 BOSWORTH ST | - | - | - | - | - |
| 100484 | N/A | Point | - | - | - | - | S273912 | DIGBY ST: EVERSON ST | - | F | F | - | F | 33494000 | 33494000 | - | - | CENTER ISLAND, WESTBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | EVERSON ST | DIGBY ST | 120379 | 120379 | 37.74004786 | -122.4330599 | DIGBY ST \ EVERSON ST | EVERSON ST \ DIGBY ST | 1710539427000 | MTA | OBJECT MARKER - YELLOW | DIGBY ST intersection | - | IFO 79 BELOW RIGHT TURN ONLY | - | - | - | - | - | 117752 | 1502236800000 | -122.4330599 | 37.74004786 | - | 1665100800000 | - | D8 | - | OTHER WARNING | WARNING | TYPE-N(CA).0004 | 30X30 | SUP2 | 2IN IRON POST | IS | 1618231920000 | EVERSON ST | - | - | - | - | - | - |
| 100485 | N/A | Point | 1 | 1 | 2900 - 2999 | - | S275919 | 2900-2999 VALLEJO ST | 2900-2999 VALLEJO ST | F | F | - | F | 30821000 | 13123000 | - | - | WEST SIDE | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | VALLEJO ST | BAKER ST | 120923 | 120923 | 37.79386393 | -122.44581161 | LYON ST \ VALLEJO ST | - | 1721761979000 | middleware_editor | OBJECT MARKER - YELLOW | BAKER ST to LYON ST (2900 - 2999) | - | CJOENTER LINE VALLEJO AT W END | - | - | - | - | - | 117753 | 1625565240000 | -122.44581161 | 37.79386393 | - | - | - | D2 | - | OTHER WARNING | WARNING | TYPE-N(CA).0004 | 30X30 | SUP1 | LIGHT POLE | IS | 1625059440000 | VALLEJO ST | - | 2900 - 2999 VALLEJO ST | 2900 VALLEJO ST | - | - | LYON ST |
| 100486 | N/A | Point | - | - | - | - | S275378 | COLLEGE AVE: MURRAY ST | - | F | F | - | F | 21816000 | 21816000 | - | - | CENTER ISLAND, S LINE, SOUTHBOUND | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | COLLEGE AVE | COLLEGE AVE | 123611 | 123611 | 37.73358244 | -122.4236943 | MURRAY ST \ COLLEGE AVE | MURRAY ST \ COLLEGE AVE | 1710539427000 | MTA | OBJECT MARKER - YELLOW | COLLEGE AVE intersection | - | - | - | - | - | - | - | 117754 | 1626705600000 | -122.4236943 | 37.73358244 | - | - | - | D9 | - | OTHER WARNING | WARNING | TYPE-N(CA).0004 | 30X30 | SUP2 | 2IN IRON POST | IS | 1623315600000 | MURRAY ST | - | - | - | - | - | - |
| 100487 | N/A | Point | - | - | - | - | S255429 | ALEMANY BLVD: INDUSTRIAL ST ON | - | F | F | - | F | 33691000 | 33691000 | - | - | CENTER ISLAND, NORTHBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | ALEMANY BLVD | ALEMANY BLVD | 127677 | 127677 | 37.73756582 | -122.40725235 | INDUSTRIAL ST ON RAMP \ ALEMANY BLVD | INDUSTRIAL ST ON RAMP \ ALEMANY BLVD | 1710539427000 | MTA | OBJECT MARKER - YELLOW | ALEMANY BLVD intersection | - | 70 FT WEST OF INDUSTRIAL | - | - | - | - | - | 117755 | - | -122.40725235 | 37.73756582 | - | - | - | D9 | - | OTHER WARNING | WARNING | TYPE-N(CA).0004 | 30X30 | SUP2 | 2IN IRON POST | IS | 1560939720000 | INDUSTRIAL ST ON RAMP | - | - | - | - | - | - |
| 100488 | N/A | Point | - | - | - | - | S243514 | - | - | F | F | - | F | - | - | - | - | CENTER ISLAND | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | - | - | 133011 | 133011 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | OBJECT MARKER - YELLOW | - | - | BEFORE ENTERANCE TO GG PARK | - | - | - | - | - | 117756 | 1520553600000 | - | - | - | 1520553600000 | - | D5 | - | OTHER WARNING | WARNING | TYPE-N(CA).0004 | 30X30 | SUP1 | 2IN IRON POST | IS | - | - | 0-0 KEZAR DR (GGP) | - | - | - | - | - |
| 100489 | N/A | Point | 1 | 1 | 100 - 199 | - | S113901 | 1-199 BUSH ST | 100-199 BUSH ST | F | F | - | F | 3420000 | 3420000 | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | BATTERY ST | BATTERY ST | 11058 | 11058 | 37.79125185 | -122.40015803 | - | - | 1757022599000 | middleware_editor | OBJECT MARKER - YELLOW | BATTERY ST to SANSOME ST (100 - 199) | - | WEST END OF BOARDING ISLAND BEHIND ..... | - | - | - | - | - | 117757 | 997858800000 | -122.40015803 | 37.79125185 | - | 1757021400000 | - | D3 | - | OTHER WARNING | WARNING | TYPE-N(CA).0004 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373571900000 | BUSH ST | 100 - 199 BUSH ST | 100 - 199 BUSH ST | 100 BUSH ST | - | SANSOME ST | SANSOME ST |
| 100490 | N/A | Point | 1 | 1 | 1 - 99 | - | S210207 | 1-99 RADIO TER | 1-99 RADIO TER | F | F | - | F | 10887000 | 10887000 | - | - | SOUTH SIDE | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | 14TH AVE | 14TH AVE | 47761 | 47761 | 37.75070337 | -122.47062877 | - | - | 1710539427000 | MTA | OBJECT MARKER - YELLOW | 14TH AVE to ROCKRIDGE DR (1 - 99) | - | 100FT EAST OF 14TH AVE | - | - | - | - | - | 117758 | 1224547200000 | -122.47062877 | 37.75070337 | - | - | - | D7 | - | OTHER WARNING | WARNING | TYPE-N(CA).0004 | 30X30 | SUP2 | 3IN IRON POST | IS | 1413888660000 | RADIO TER | 1 - 99 RADIO TER | 1 - 99 RADIO TER | 1 RADIO TER | - | ROCKRIDGE DR | ROCKRIDGE DR |
| 100491 | N/A | Point | - | - | - | - | S210696 | GEARY BLVD: STEINER ST | - | F | F | - | F | 26594000 | 26594000 | - | - | CENTER ISLAND, W LINE, EASTBOUND | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | GEARY BLVD | STEINER ST | 53047 | 53047 | 37.78415186 | -122.4345621 | STEINER ST \ GEARY BLVD | GEARY BLVD \ STEINER ST | 1710539427000 | MTA | OBJECT MARKER - YELLOW | STEINER ST intersection | - | SOUTH C/I | - | - | - | - | - | 117759 | - | -122.4345621 | 37.78415186 | - | 1682467200000 | - | D5 | - | OTHER WARNING | WARNING | TYPE-N(CA).0004 | 30X30 | SUP1 | SIGNAL POLE | IS | 1415621640000 | GEARY BLVD | - | - | - | - | - | - |
| 100492 | N/A | Point | - | - | - | - | S215824 | CLARENDON AVE: OAK PARK DR | - | F | F | - | F | 4072000 | 26253000 | - | - | CENTER ISLAND, W LINE, EASTBOUND | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | OAK PARK DR | CLARENDON AVE | 56883 | 56883 | 37.755160824 | -122.455001428 | - | CLARENDON AVE intersection | 1714774274000 | middleware_editor | OBJECT MARKER - YELLOW | CLARENDON AVE intersection | - | CENTER ISLAND AT OAK PARK | - | - | - | - | - | 117760 | 1461542400000 | -122.45505239 | 37.75511629 | - | 1714726800000 | - | D7 | - | OTHER WARNING | WARNING | TYPE-N(CA).0003 | 24X24 | SUP2 | 2IN BREAK-AWAY SYSTEM | IS | 1430488800000 | OAK PARK DR | 400 - 450 CLARENDON AVE | - | - | - | PANORAMA DR | - |
| 100493 | N/A | Point | 1 | 1 | 19 - 99 | - | S273685 | 19-99 CHILD ST | 19-99 CHILD ST | F | F | - | F | 3992000 | 3992000 | - | - | WEST SIDE | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | TELEGRAPH PL | TELEGRAPH PL | 101896 | 101896 | 37.80318836 | -122.40756755 | - | - | 1751573630000 | middleware_editor | OBJECT MARKER - YELLOW | TELEGRAPH PL to LOMBARD ST (19 - 99) | - | @ TELEGRAPH PLACE | - | - | - | - | - | 117761 | 1575273600000 | -122.40756755 | 37.80318836 | - | 1623394800000 | - | D3 | - | OTHER WARNING | WARNING | TYPE-N(CA).0004 | 30X30 | SUP1 | 2IN IRON POST | IS | 1617095760000 | CHILD ST | 19 - 99 CHILD ST | 19 - 99 CHILD ST | 19 CHILD ST | - | LOMBARD ST | LOMBARD ST |
| 100494 | N/A | Point | - | - | - | - | S267668 | FOLSOM ST: ESSEX ST | - | F | F | - | F | 24524000 | 24524000 | - | - | CENTER ISLAND, S LINE, EASTBOUND | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | FOLSOM ST | FOLSOM ST | 110024 | 110024 | 37.78637894 | -122.39564547 | ESSEX ST \ FOLSOM ST | ESSEX ST \ FOLSOM ST | 1721338894000 | middleware_editor | OBJECT MARKER - YELLOW | FOLSOM ST intersection | - | WEST SIDE OF ISLAND | - | - | - | - | - | 117762 | 1606829760000 | -122.39564547 | 37.78637894 | - | 1721311200000 | - | D6 | - | OTHER WARNING | WARNING | TYPE-N(CA).0004 | 30X30 | SUP1 | 2IN IRON POST | IS | 1598610240000 | ESSEX ST | - | - | - | - | - | - |
| 100495 | N/A | Point | 1 | 1 | 4005 - 4099 | - | S265757 | PNDG 20TH ST | 4005-4099 20TH ST | F | F | - | F | 1064000 | 1064000 | - | - | EAST SIDE | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | 20TH ST | 20TH ST | 100372 | 100372 | 37.75777804 | -122.43166676 | - | - | 1710539427000 | MTA | OBJECT MARKER - YELLOW | 20TH ST to NOE ST (4005 - 4099) | - | BEGING OF BLOCK 4004 | - | - | - | - | - | 117763 | 1474848000000 | -122.43166676 | 37.75777804 | - | 1594598400000 | - | D8 | - | OTHER WARNING | WARNING | TYPE-N(CA).0004 | 30X30 | SUP2 | 2IN IRON POST | IS | 1593682260000 | 20TH ST | PNDG 20TH ST | 4005 - 4099 20TH ST | - | - | NOE ST | NOE ST |
| 100496 | N/A | Point | 1 | - | - | - | S116377 | 3200-3299 VAN NESS AVE | - | F | F | - | F | 13174000 | 13174000 | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | - | - | 16404 | 16404 | 37.80663475 | -122.42588422 | - | - | 1710539427000 | MTA | OBJECT MARKER - YELLOW | - | - | 90N / BELOW R32(4) 8A6P | - | - | - | - | - | 117764 | 1048723200000 | -122.42588422 | 37.80663475 | - | - | - | D2 | - | OTHER WARNING | WARNING | TYPE-N(CA).0004 | 30X30 | SUP1 | UNKNOWN | IS | 1373572680000 | VAN NESS AVE | 3200-3299 VAN NESS AVE | VAN NESS AVE | - | - | - | - |
| 100497 | N/A | Point | - | - | - | - | S223335 | BAY ST: LAGUNA ST | - | F | F | - | F | 26754000 | 26754000 | - | - | CENTER ISLAND, W LINE, WESTBOUND | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | BAY ST | BAY ST | 63148 | 63148 | 37.80326674 | -122.43167937 | LAGUNA ST \ BAY ST | LAGUNA ST \ BAY ST | 1710539427000 | MTA | OBJECT MARKER - YELLOW | BAY ST intersection | - | - | - | - | - | - | - | 117765 | - | -122.43167937 | 37.80326674 | - | 1684800000000 | - | D2 | - | OTHER WARNING | WARNING | TYPE-N(CA).0004 | 30X30 | SUP1 | 2IN BREAK-AWAY SYSTEM | IS | 1455117600000 | LAGUNA ST | - | - | - | - | - | - |
| 100498 | N/A | Point | - | - | - | - | S100943 | EUCLID AVE: JORDAN AVE | - | F | F | - | F | 27222000 | 27222000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | EUCLID AVE | EUCLID AVE | 406 | 406 | 37.78392891 | -122.45681322 | JORDAN AVE \ EUCLID AVE | JORDAN AVE \ EUCLID AVE | 1710539427000 | MTA | STOP | EUCLID AVE intersection | - | 00 / 00 | - | - | - | - | - | 117766 | -401846400000 | -122.45681322 | 37.78392891 | - | 1556582400000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373566620000 | JORDAN AVE | - | - | - | - | - | - |
| 100499 | N/A | Point | - | - | - | - | S100931 | EUCLID AVE: JORDAN AVE | - | F | F | - | F | 27222000 | 27222000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | EUCLID AVE | EUCLID AVE | 395 | 395 | 37.78392891 | -122.45681322 | JORDAN AVE \ EUCLID AVE | JORDAN AVE \ EUCLID AVE | 1710539427000 | MTA | STOP | EUCLID AVE intersection | - | 00 / 00 | - | - | - | - | - | 117767 | -401846400000 | -122.45681322 | 37.78392891 | - | 1556582400000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 3IN IRON POST | IS | 1373566620000 | JORDAN AVE | - | - | - | - | - | - |
| 100500 | N/A | Point | - | - | - | - | S128077 | EUCLID AVE: JORDAN AVE | - | F | F | - | F | 27222000 | 27222000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | EUCLID AVE | EUCLID AVE | 22137 | 22137 | 37.78392891 | -122.45681322 | JORDAN AVE \ EUCLID AVE | JORDAN AVE \ EUCLID AVE | 1710539427000 | MTA | ALL WAY | EUCLID AVE intersection | - | - | - | - | - | - | - | 117768 | 1192406400000 | -122.45681322 | 37.78392891 | - | 1523404800000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373576340000 | JORDAN AVE | - | - | - | - | - | - |
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.