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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 36151 | N/A | Point | 1 | 1 | 4000 - 4099 | - | S259081 | 4000-4099 JUDAH ST | 4000-4099 JUDAH ST | F | F | - | F | 7682000 | 7682000 | - | - | NORTH SIDE | - | - | - | - | 45TH AVE | 45TH AVE | 87784 | 87784 | 37.76044811 | -122.50539242 | - | - | 1712970755000 | middleware_editor | BIKE RACK | 45TH AVE to 46TH AVE (4000 - 4099) | 71391 | 42' W OF EPL#4038/3' IN FROM CURB | - | - | - | - | - | 53233 | 1575639300000 | -122.50539242 | 37.76044811 | - | - | - | D4 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1573138200000 | JUDAH ST | 4000 - 4099 JUDAH ST | 4000 - 4099 JUDAH ST | 4000 JUDAH ST | - | 46TH AVE | 46TH AVE |
| 36152 | N/A | Point | 1 | 1 | 4000 - 4099 | - | S259082 | 4000-4099 JUDAH ST | 4000-4099 JUDAH ST | F | F | - | F | 7682000 | 7682000 | - | - | NORTH SIDE | - | - | - | - | 45TH AVE | 45TH AVE | 87785 | 87785 | 37.76044811 | -122.50539242 | - | - | 1712970759000 | middleware_editor | BIKE RACK | 45TH AVE to 46TH AVE (4000 - 4099) | 71391 | 69' W OF EPL#4038/3' IN FROM CURB | - | - | - | - | - | 53234 | 1575644040000 | -122.50539242 | 37.76044811 | - | - | - | D4 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1573138200000 | JUDAH ST | 4000 - 4099 JUDAH ST | 4000 - 4099 JUDAH ST | 4000 JUDAH ST | - | 46TH AVE | 46TH AVE |
| 36153 | N/A | Point | 1 | 1 | 1600 - 1699 | - | S259083 | 1600-1699 NORIEGA ST | 1600-1699 NORIEGA ST | F | F | - | F | 9657000 | 9657000 | - | - | NORTH SIDE | - | - | - | - | 23RD AVE | 23RD AVE | 87786 | 87786 | 37.75402785 | -122.48129521 | - | - | 1745603487000 | middleware_editor | BIKE RACK | 23RD AVE to 24TH AVE (1600 - 1699) | 72902 | 8' E OF WPL 1618//3' IN FROM CURB | - | - | - | - | - | 53235 | 1575668040000 | -122.48129521 | 37.75402785 | - | - | - | D4 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1573138500000 | NORIEGA ST | 1600 - 1699 NORIEGA ST | 1600 - 1699 NORIEGA ST | 1600 NORIEGA ST | - | 24TH AVE | 24TH AVE |
| 36154 | N/A | Point | 1 | 1 | 300 - 353 | - | S254162 | 300-353 2ND ST | 300-353 02ND ST | F | F | - | F | 138000 | 138000 | - | - | WEST SIDE | - | - | - | - | FOLSOM ST | FOLSOM ST | 87787 | 87787 | 37.78521953 | -122.39630044 | - | - | 1710539427000 | MTA | TANSAT | FOLSOM ST to DOW PL (300 - 353) | - | 300' SOUTH OF FOLSOM | - | - | - | - | - | 53236 | 1557224820000 | -122.39630044 | 37.78521953 | - | - | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0089 | 14X21 | SUP1 | LIGHT POLE | IS | 1557220920000 | 02ND ST | 300 - 353 2ND ST | 300 - 353 02ND ST | 300 2ND ST | - | DOW PL | DOW PL |
| 36155 | N/A | Point | - | 1 | 150 - 189 | - | S254163 | 150-189 FAIR AVE | 150-189 FAIR AVE | F | F | - | F | 5379000 | 5379000 | - | - | NORTH SIDE | - | - | - | - | LUNDYS LN | LUNDYS LN | 87788 | 87788 | 37.74488702 | -122.41813804 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "AA" PERMITS | LUNDYS LN to FAIR AVE (150 - 189) | - | DEAD END TURN AROUND | - | - | - | - | - | 53237 | 1557410400000 | -122.41813804 | 37.74488702 | - | - | - | D9 | - | PARKING:RPP | REG | R32C(CA).0239 | 18X21 | SUP2 | 2IN IRON POST | IS | 1557221760000 | FAIR AVE | 150 - 189 FAIR AVE | 150 - 189 FAIR AVE | 150 FAIR AVE | - | FAIR AVE | FAIR AVE |
| 36156 | N/A | Point | - | - | - | - | S254166 | 2ND ST: MINNA ST | - | T | T | - | F | 24594000 | 24594000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 2ND ST | 02ND ST | 87790 | 87790 | 37.78757928 | -122.39925505 | MINNA ST \ 2ND ST | MINNA ST \ 02ND ST | 1710539427000 | MTA | ONE WAY (RA) | 02ND ST intersection | - | - | - | - | - | - | - | 53238 | 1537747200000 | -122.39925505 | 37.78757928 | - | 1558483200000 | - | D6 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP1 | SIGNAL POLE | IS | 1557222480000 | MINNA ST | - | - | - | - | - | - |
| 36157 | N/A | Point | - | 1 | 150 - 189 | - | S254167 | 150-189 FAIR AVE | 150-189 FAIR AVE | F | F | - | F | 5379000 | 5379000 | - | - | EAST SIDE, EASTBOUND TRAFFIC | - | - | - | - | LUNDYS LN | LUNDYS LN | 87791 | 87791 | 37.74488702 | -122.41813804 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "AA" PERMITS | LUNDYS LN to FAIR AVE (150 - 189) | - | INSTALL FACING EASTBOUND TRAFFIC | - | - | - | - | - | 53239 | 1557478500000 | -122.41813804 | 37.74488702 | - | - | - | D9 | - | PARKING:RPP | REG | R32C(CA).0239 | 18X21 | SUP2 | 2IN IRON POST | IS | 1557222780000 | FAIR AVE | 150 - 189 FAIR AVE | 150 - 189 FAIR AVE | 150 FAIR AVE | - | FAIR AVE | FAIR AVE |
| 36158 | N/A | Point | - | - | - | - | S254168 | 2ND ST: NATOMA ST | - | T | T | - | F | 24543000 | 24543000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 2ND ST | 02ND ST | 87792 | 87792 | 37.78720346 | -122.3987896 | NATOMA ST \ 2ND ST | NATOMA ST \ 02ND ST | 1710539427000 | MTA | NATOMA ST | 02ND ST intersection | - | - | - | - | - | - | - | 53240 | 1059091200000 | -122.3987896 | 37.78720346 | - | 1558483200000 | - | D6 | - | STREET NAME | GUIDE | D3-2.0419 | 72X18 | SUP1 | OVERHEAD MAST ARM | IS | 1557222780000 | NATOMA ST | - | - | - | - | - | - |
| 36159 | N/A | Point | 1 | 1 | 500 - 599 | - | S259198 | 500-599 BRODERICK ST | 500-599 BRODERICK ST | F | F | - | F | 3192000 | 3192000 | - | - | EAST SIDE | - | - | - | - | HAYES ST | HAYES ST | 87849 | 87849 | 37.77524592 | -122.43956136 | - | - | 1720634996000 | middleware_editor | BIKE RACK | HAYES ST to GROVE ST (500 - 599) | 71144 | 17' S OF SPL 528//3' IN FROM CURB | - | - | - | - | - | 53241 | 1573818180000 | -122.43956136 | 37.77524592 | - | - | - | D5 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1573721100000 | BRODERICK ST | 500 - 599 BRODERICK ST | 500 - 599 BRODERICK ST | 500 BRODERICK ST | - | GROVE ST | GROVE ST |
| 36160 | N/A | Point | - | - | - | - | S271565 | GROVE ST: VAN NESS AVE | - | T | T | - | F | 24459000 | 24459000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | VAN NESS AVE | VAN NESS AVE | 90798 | 90798 | 37.77825102 | -122.41988323 | GROVE ST \ VAN NESS AVE | GROVE ST \ VAN NESS AVE | 1710539427000 | MTA | SPEED LIMIT 25 | VAN NESS AVE intersection | - | - | - | - | - | - | - | 53242 | 1328486400000 | -122.41988323 | 37.77825102 | - | 1623196800000 | - | D5 | - | SPEED LIMIT | REG | R2-1.0005 | 24X30 | SUP1 | LIGHT POLE | IS | 1610704800000 | GROVE ST | - | - | - | - | - | - |
| 36161 | N/A | Point | 1 | 1 | 1 - 55 | - | S271568 | 1-55 GROVE ST | 1-55 GROVE ST | T | T | - | F | 6552000 | 6552000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | 8TH ST \ HYDE ST \ MARKET ST | 08TH ST \ HYDE ST \ MARKET ST | 90799 | 90799 | 37.77876455 | -122.41563582 | - | - | 1726622167000 | middleware_editor | SPEED LIMIT 20 | 08TH ST \ HYDE ST \ MARKET ST to LARKIN ST (1 - 55) | - | 150 FT EAST OF LARKIN | - | - | - | - | - | 53243 | 1328486400000 | -122.41563582 | 37.77876455 | - | 1623196800000 | - | D6 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP1 | LIGHT POLE | IS | 1610705220000 | GROVE ST | 1 - 55 GROVE ST | 1 - 55 GROVE ST | 1 GROVE ST | - | LARKIN ST | LARKIN ST |
| 36162 | N/A | Point | - | - | - | - | S271571 | LARKIN ST: FULTON ST | - | T | T | - | F | 24435000 | 24435000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LARKIN ST | FULTON ST | 90802 | 90802 | 37.77958444 | -122.41676809 | FULTON ST \ LARKIN ST | LARKIN ST \ FULTON ST | 1710539427000 | MTA | SPEED LIMIT 20 | FULTON ST intersection | - | - | - | - | - | - | - | 53244 | -403401600000 | -122.41676809 | 37.77958444 | - | 1618531200000 | - | D6 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP1 | LIGHT POLE | IS | 1610705760000 | LARKIN ST | - | - | - | - | - | - |
| 36163 | N/A | Point | 1 | 1 | 300 - 399 | - | S271577 | 300-399 LARKIN ST | 300-399 LARKIN ST | T | T | - | F | 8123000 | 8123000 | - | - | WEST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | MCALLISTER ST | MCALLISTER ST | 90803 | 90803 | 37.78095892 | -122.41704661 | - | - | 1710539427000 | MTA | SPEED LIMIT 20 | MCALLISTER ST to GOLDEN GATE AVE (300 - 399) | - | 100 FT NORTH | - | - | - | - | - | 53245 | 1191456000000 | -122.41704661 | 37.78095892 | - | 1618531200000 | - | D6 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP1 | LIGHT POLE | IS | 1610706180000 | LARKIN ST | 300 - 399 LARKIN ST | 300 - 399 LARKIN ST | 300 LARKIN ST | - | GOLDEN GATE AVE | GOLDEN GATE AVE |
| 36164 | N/A | Point | 1 | 1 | 400 - 499 | - | S271579 | 400-499 LARKIN ST | 400-499 LARKIN ST | F | F | - | F | 8124000 | 8124000 | - | - | WEST SIDE | - | - | - | - | GOLDEN GATE AVE | GOLDEN GATE AVE | 90804 | 90804 | 37.78191322 | -122.41724225 | - | - | 1710539427000 | MTA | SPEED LIMIT 20 | GOLDEN GATE AVE to TURK ST (400 - 499) | - | 50' NORTH OF GOLDEN GATE | - | - | - | - | - | 53246 | 1510185600000 | -122.41724225 | 37.78191322 | - | 1618531200000 | - | D6 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP1 | 2IN IRON POST | IS | 1610706480000 | LARKIN ST | 400 - 499 LARKIN ST | 400 - 499 LARKIN ST | 400 LARKIN ST | - | TURK ST | TURK ST |
| 36165 | N/A | Point | - | - | - | - | S271580 | LARKIN ST: GOLDEN GATE AVE | - | T | T | - | F | 24440000 | 24440000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | GOLDEN GATE AVE | GOLDEN GATE AVE | 90805 | 90805 | 37.7814475 | -122.41714561 | LARKIN ST \ GOLDEN GATE AVE | LARKIN ST \ GOLDEN GATE AVE | 1753393193000 | middleware_editor | SPEED LIMIT 20 | GOLDEN GATE AVE intersection | - | - | - | - | - | - | - | 53247 | 1510214400000 | -122.41714561 | 37.7814475 | - | 1618556400000 | - | D6 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP1 | LIGHT POLE | IS | 1610706540000 | LARKIN ST | - | - | - | - | - | - |
| 36166 | N/A | Point | 1 | 1 | 1332 - 1362 | - | S267545 | 1332-1362 MISSION ST | 1332-1362 MISSION ST | F | F | - | F | 9106000 | 9106000 | - | - | SOUTH SIDE | - | - | - | - | WASHBURN ST | WASHBURN ST | 90806 | 90806 | 37.77574848 | -122.41530635 | - | - | 1710539427000 | MTA | NPRK 2AM-6AM EVERYDAY INCLUDING HOLIDAY STCL | WASHBURN ST to GRACE ST (1332 - 1362) | - | INFO #1345 | - | - | - | - | - | 53248 | 1394668800000 | -122.41530635 | 37.77574848 | - | 1394668800000 | - | D6 | - | STREET CLEANING | REG | R30B(CA).0113 | 18X18 | SUP1 | LIGHT POLE | IS | 1598437680000 | MISSION ST | 1332 - 1362 MISSION ST | 1332 - 1362 MISSION ST | 1332 MISSION ST | - | GRACE ST | GRACE ST |
| 36167 | N/A | Point | 1 | 1 | 1332 - 1362 | - | S267546 | 1332-1362 MISSION ST | 1332-1362 MISSION ST | F | F | - | F | 9106000 | 9106000 | - | - | SOUTH SIDE | - | - | - | - | WASHBURN ST | WASHBURN ST | 90807 | 90807 | 37.77574848 | -122.41530635 | - | - | 1710539427000 | MTA | TANS 7AM-9AM/4PM-6PM EXC SAT & SUN | WASHBURN ST to GRACE ST (1332 - 1362) | - | INFO #1345 | - | - | - | - | - | 53249 | 1394668800000 | -122.41530635 | 37.77574848 | - | 1394668800000 | - | D6 | - | OTHER REGULATORY | REG | R37(SF).0116 | 18X21 | SUP1 | LIGHT POLE | IS | 1598437740000 | MISSION ST | 1332 - 1362 MISSION ST | 1332 - 1362 MISSION ST | 1332 MISSION ST | - | GRACE ST | GRACE ST |
| 36168 | N/A | Point | 1 | 1 | 1332 - 1362 | - | S267547 | 1332-1362 MISSION ST | 1332-1362 MISSION ST | F | F | - | F | 9106000 | 9106000 | - | - | SOUTH SIDE | - | - | - | - | WASHBURN ST | WASHBURN ST | 90808 | 90808 | 37.77574848 | -122.41530635 | - | - | 1710539427000 | MTA | TANSAT | WASHBURN ST to GRACE ST (1332 - 1362) | - | INFO #1345 | - | - | - | - | - | 53250 | 1394668800000 | -122.41530635 | 37.77574848 | - | 1600214400000 | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | LIGHT POLE | IS | 1598437740000 | MISSION ST | 1332 - 1362 MISSION ST | 1332 - 1362 MISSION ST | 1332 MISSION ST | - | GRACE ST | GRACE ST |
| 36169 | N/A | Point | - | - | - | - | S271865 | HYDE ST: MCALLISTER ST | - | T | T | - | F | 24333000 | 24333000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | HYDE ST | MCALLISTER ST | 90817 | 90817 | 37.78071918 | -122.41531562 | MCALLISTER ST \ HYDE ST | HYDE ST \ MCALLISTER ST | 1710539427000 | MTA | SPEED LIMIT 20 | MCALLISTER ST intersection | - | - | - | - | - | - | - | 53251 | 1315526400000 | -122.41531562 | 37.78071918 | - | 1621814400000 | - | D6 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP1 | LIGHT POLE | IS | 1611662280000 | HYDE ST | - | - | - | - | - | - |
| 36170 | N/A | Point | - | - | - | - | S272039 | 18TH AVE: VICENTE ST | - | F | F | - | F | 23158000 | 23158000 | - | - | NORTH WEST CORNER | - | - | - | - | 18TH AVE | 18TH AVE | 90819 | 90819 | 37.73937137 | -122.47436459 | VICENTE ST \ 18TH AVE | VICENTE ST \ 18TH AVE | 1710539427000 | MTA | 18TH AVE | 18TH AVE intersection | - | - | - | - | - | - | - | 53252 | 1618920000000 | -122.47436459 | 37.73937137 | - | - | - | D7 | - | STREET NAME | GUIDE | D3-1.0009 | 36X08 | SUP2 | 3IN IRON POST | IS | 1612172460000 | VICENTE ST | - | - | - | - | - | - |
| 36171 | N/A | Point | 1 | 1 | 1 - 99 | RIGHT ARROW | S282144 | 1-99 JONES ST | 1-99 JONES ST | F | F | - | F | 7563000 | 7563000 | - | - | WEST SIDE | - | - | - | - | MCALLISTER ST | MCALLISTER ST | 90820 | 90820 | 37.78160462 | -122.41212241 | - | - | 1710539427000 | MTA | TANSAT | MCALLISTER ST to GOLDEN GATE AVE (1 - 99) | - | 142' N OF MCALLISTER | - | - | - | - | - | 53253 | 1649980800000 | -122.41212241 | 37.78160462 | - | 1651104000000 | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | 2IN IRON POST | IS | 1649416620000 | JONES ST | 1 - 99 JONES ST | 1 - 99 JONES ST | 1 JONES ST | - | GOLDEN GATE AVE | GOLDEN GATE AVE |
| 36172 | N/A | Point | - | - | - | - | S284141 | HARBOR RD: NORTHRIDGE RD | - | F | F | - | F | 20060000 | 20060000 | - | - | NORTH EAST CORNER | - | - | - | - | NORTHRIDGE RD | NORTHRIDGE RD | 91482 | 91482 | 37.73100987 | -122.37699955 | HARBOR RD \ NORTHRIDGE RD | HARBOR RD \ NORTHRIDGE RD | 1710539427000 | MTA | HARBOR RD | NORTHRIDGE RD intersection | - | ST. NAMES 3' POST S. OF BLDG # 37 | - | - | - | - | - | 53254 | - | -122.37699955 | 37.73100987 | - | - | - | D10 | - | STREET NAME | GUIDE | D3-1.0795 | 36X08 | SUP1 | 3IN IRON POST | IS | 1658915160000 | HARBOR RD | - | - | - | - | - | - |
| 36173 | N/A | Point | - | - | - | - | S284142 | 3RD ST: LA SALLE AVE | - | T | T | - | F | 20224000 | 20224000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | LA SALLE AVE | 03RD ST | 91483 | 91483 | 37.73716953 | -122.38986446 | 3RD ST \ LA SALLE AVE | LA SALLE AVE \ 03RD ST | 1710539427000 | MTA | LA SALLE AVE | 03RD ST intersection | - | - | - | - | - | - | - | 53255 | - | -122.38986446 | 37.73716953 | - | - | - | D10 | - | STREET NAME | GUIDE | D3-2.0216 | 72X18 | SUP1 | OVERHEAD MAST ARM | IS | 1658917260000 | LA SALLE AVE | - | - | - | - | - | - |
| 36174 | N/A | Point | - | - | - | - | S284143 | 3RD ST: LA SALLE AVE | - | F | F | - | F | 20224000 | 20224000 | - | - | CENTER ISLAND, N LINE, NORTHBOUND | - | - | - | - | LA SALLE AVE | 03RD ST | 91484 | 91484 | 37.73716953 | -122.38986446 | 3RD ST \ LA SALLE AVE | LA SALLE AVE \ 03RD ST | 1710539427000 | MTA | NO LEFT TURN (SYM)/NO U TURN (SYM) | 03RD ST intersection | - | - | - | - | - | - | - | 53256 | 1119052800000 | -122.38986446 | 37.73716953 | - | - | - | D10 | - | NO LEFT TURN | REG | R3-18.0002 | 30X30 | SUP1 | SIGNAL POLE | IS | 1658918520000 | LA SALLE AVE | - | - | - | - | - | - |
| 36175 | N/A | Point | - | - | - | - | S284145 | 3RD ST: LA SALLE AVE | - | F | F | - | F | 20224000 | 20224000 | - | - | CENTER ISLAND, N LINE, SOUTHBOUND | - | - | - | - | LA SALLE AVE | 03RD ST | 91485 | 91485 | 37.73716953 | -122.38986446 | 3RD ST \ LA SALLE AVE | LA SALLE AVE \ 03RD ST | 1710539427000 | MTA | NO LEFT TURN (SYM)/NO U TURN (SYM) | 03RD ST intersection | - | - | - | - | - | - | - | 53257 | - | -122.38986446 | 37.73716953 | - | - | - | D10 | - | NO LEFT TURN | REG | R3-18.0002 | 30X30 | SUP1 | SIGNAL POLE | IS | 1658919000000 | LA SALLE AVE | - | - | - | - | - | - |
| 36176 | N/A | Point | 1 | 1 | 1929 - 1999 | - | S284148 | 1929-1999 JONES ST | 1929-1999 JONES ST | F | F | - | F | 7590000 | 7590000 | - | - | EAST SIDE | - | - | - | - | MACONDRAY LN | MACONDRAY LN | 91486 | 91486 | 37.7993836 | -122.41571451 | - | - | 1710539427000 | MTA | NPRK 12PM-2PM 1ST WED OF MONTH STCL | MACONDRAY LN to UNION ST (1929 - 1999) | - | 35' SOUTH OF UNION ST. | - | - | - | - | - | 53258 | 1130371200000 | -122.41571451 | 37.7993836 | - | 1631750400000 | - | D3 | - | STREET CLEANING | REG | R30B(CA).0335 | 18X18 | SUP1 | LIGHT POLE | IS | 1658922900000 | JONES ST | 1929 - 1999 JONES ST | 1929 - 1999 JONES ST | 1929 JONES ST | - | UNION ST | UNION ST |
| 36177 | N/A | Point | 1 | 1 | 1929 - 1999 | - | S284150 | 1929-1999 JONES ST | 1929-1999 JONES ST | F | F | - | F | 7590000 | 7590000 | - | - | EAST SIDE | - | - | - | - | MACONDRAY LN | MACONDRAY LN | 91487 | 91487 | 37.7993836 | -122.41571451 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-7PM MON-FRI EXC ""A"" PERMITS | MACONDRAY LN to UNION ST (1929 - 1999) | - | 35' SOUTH OF UNION ST. | - | - | - | - | - | 53259 | 1703233800000 | -122.41571451 | 37.7993836 | - | - | - | D3 | - | PARKING:RPP | REG | R32C(CA).0112 | 18X21 | SUP1 | LIGHT POLE | IS | 1658923080000 | JONES ST | 1929 - 1999 JONES ST | 1929 - 1999 JONES ST | 1929 JONES ST | - | UNION ST | UNION ST |
| 36178 | N/A | Point | 1 | 1 | 1929 - 1999 | - | S284151 | 1929-1999 JONES ST | 1929-1999 JONES ST | F | F | - | F | 7590000 | 7590000 | - | - | EAST SIDE | - | - | - | - | MACONDRAY LN | MACONDRAY LN | 91488 | 91488 | 37.7993836 | -122.41571451 | - | - | 1710539427000 | MTA | PARK AT 90 DEGREES | MACONDRAY LN to UNION ST (1929 - 1999) | - | 35' SOUTH OF UNION ST. | - | - | - | - | - | 53260 | - | -122.41571451 | 37.7993836 | - | - | - | D3 | - | PARKING:PARK AT 90 | REG | R(SF).0372 | 18X18 | SUP1 | LIGHT POLE | IS | 1658923560000 | JONES ST | 1929 - 1999 JONES ST | 1929 - 1999 JONES ST | 1929 JONES ST | - | UNION ST | UNION ST |
| 36179 | N/A | Point | - | - | - | - | S284152 | JONES ST: FILBERT ST | - | F | F | - | F | 25493000 | 25493000 | - | - | SOUTH EAST CORNER | - | - | - | - | FILBERT ST | FILBERT ST | 91489 | 91489 | 37.80054721 | -122.41594335 | JONES ST \ FILBERT ST | JONES ST \ FILBERT ST | 1710539427000 | MTA | NPRK 12PM-2PM 1ST WED OF MONTH STCL | FILBERT ST intersection | - | 0 / 0 | - | - | - | - | - | 53261 | 1658880000000 | -122.41594335 | 37.80054721 | - | - | - | D2 | - | STREET CLEANING | REG | R30B(CA).0335 | 18X18 | SUP1 | 2IN IRON POST | IS | 1658927040000 | JONES ST | - | - | - | - | - | - |
| 36180 | N/A | Point | - | - | - | - | S284153 | JONES ST: FILBERT ST | - | F | F | - | F | 25493000 | 25493000 | - | - | SOUTH EAST CORNER | - | - | - | - | FILBERT ST | FILBERT ST | 91490 | 91490 | 37.80054721 | -122.41594335 | JONES ST \ FILBERT ST | JONES ST \ FILBERT ST | 1710539427000 | MTA | 2 HR PRK 8AM-7PM MON-FRI EXC "A" PERMITS | FILBERT ST intersection | - | BELOW STREET CLEANING SIGN. | - | - | - | - | - | 53262 | 1658966400000 | -122.41594335 | 37.80054721 | - | - | - | D2 | - | PARKING:RPP | REG | R32C(CA).0112 | 18X21 | SUP1 | 2IN IRON POST | IS | 1658927580000 | JONES ST | - | - | - | - | - | - |
| 36181 | N/A | Point | 1 | 1 | 1300 - 1399 | - | S284155 | 1300-1399 HAYES ST | 1300-1399 HAYES ST | F | F | - | F | 6825000 | 6825000 | - | - | SOUTH SIDE | - | - | - | - | DIVISADERO ST | DIVISADERO ST | 91492 | 91492 | 37.77488509 | -122.43863248 | - | - | 1710539427000 | MTA | TANP ANY TIME EXC MOTORCYCLES | DIVISADERO ST to BRODERICK ST (1300 - 1399) | - | #1377 WPL. | - | - | - | - | - | 53263 | 1043971200000 | -122.43863248 | 37.77488509 | - | - | - | D5 | - | TOW (TANP ANY TIME) | REG | R26K(SF).0020 | 18X21 | SUP1 | 2IN IRON POST | IS | 1658931300000 | HAYES ST | 1300 - 1399 HAYES ST | 1300 - 1399 HAYES ST | 1300 HAYES ST | - | BRODERICK ST | BRODERICK ST |
| 36182 | N/A | Point | - | 1 | 2700 - 2799 | LEFT ARROW | S271412 | 2601-2699 ARELIOUS WALKER DR | 2700-2799 ARELIOUS WALKER DR | F | F | - | F | 5588000 | 5588000 | - | - | WEST SIDE | - | - | - | - | EGBERT AVE | EGBERT AVE | 91494 | 91494 | 37.71810222 | -122.3854268 | - | - | 1710539427000 | MTA | NO STOPPING FIRE LANE | EGBERT AVE to FITZGERALD AVE (2700 - 2799) | - | 60' NORTH OF FITZGERALD AVE. | - | - | - | - | - | 53264 | 1615897140000 | -122.3854268 | 37.71810222 | - | - | - | D10 | - | OTHER REGULATORY | REG | R26F.0003 | 12X18 | SUP1 | 2IN IRON POST | IS | 1610327160000 | ARELIOUS WALKER DR | 2700 - 2799 ARELIOUS WALKER DR | 2700 - 2799 ARELIOUS WALKER DR | 2700 ARELIOUS WALKER DR | - | FITZGERALD AVE | FITZGERALD AVE |
| 36183 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S269665 | 1200-1299 FRANCISCO ST | 1200-1299 FRANCISCO ST | F | F | - | F | 5771000 | 5771000 | - | - | SOUTH SIDE | - | - | - | - | VAN NESS AVE | VAN NESS AVE | 91497 | 91497 | 37.80310177 | -122.425742 | - | - | 1724353951000 | middleware_editor | BIKE RACK | VAN NESS AVE to FRANKLIN ST (1200 - 1299) | 241827 | 18' W OF WPL 1251/3.5' IN FROM CURB | - | - | - | - | - | 53265 | 1604361600000 | -122.425742 | 37.80310177 | - | - | - | D2 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1604048640000 | FRANCISCO ST | 1200 - 1299 FRANCISCO ST | 1200 - 1299 FRANCISCO ST | 1200 FRANCISCO ST | - | FRANKLIN ST | FRANKLIN ST |
| 36184 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S269666 | 1200-1299 FRANCISCO ST | 1200-1299 FRANCISCO ST | F | F | - | F | 5771000 | 5771000 | - | - | SOUTH SIDE | - | - | - | - | VAN NESS AVE | VAN NESS AVE | 91498 | 91498 | 37.80310177 | -122.425742 | - | - | 1710539427000 | MTA | BIKE RACK | VAN NESS AVE to FRANKLIN ST (1200 - 1299) | 241827 | 65' W OF WPL 1251/3.5' IN FROM CURB | - | - | - | - | - | 53266 | 1604361600000 | -122.425742 | 37.80310177 | - | - | - | D2 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1604048700000 | FRANCISCO ST | 1200 - 1299 FRANCISCO ST | 1200 - 1299 FRANCISCO ST | 1200 FRANCISCO ST | - | FRANKLIN ST | FRANKLIN ST |
| 36185 | N/A | Point | 1 | 1 | 40 - 99 | - | S267981 | 40-99 FOLSOM ST | 40-99 FOLSOM ST | F | F | - | F | 5650000 | 5650000 | - | - | NORTH SIDE | - | - | - | - | THE EMBARCADERO | THE EMBARCADERO | 91744 | 91744 | 37.79044838 | -122.39049168 | - | - | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | THE EMBARCADERO to SPEAR ST (40 - 99) | - | 26' WEST OF THE EMBARCADERO | - | - | - | - | - | 53267 | 1608729540000 | -122.39049168 | 37.79044838 | - | - | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1599649260000 | FOLSOM ST | 40 - 99 FOLSOM ST | 40 - 99 FOLSOM ST | 40 FOLSOM ST | - | SPEAR ST | SPEAR ST |
| 36186 | N/A | Point | 1 | 1 | 40 - 99 | - | S267982 | 40-99 FOLSOM ST | 40-99 FOLSOM ST | F | F | - | F | 5650000 | 5650000 | - | - | NORTH SIDE | - | - | - | - | THE EMBARCADERO | THE EMBARCADERO | 91745 | 91745 | 37.79044838 | -122.39049168 | - | - | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | THE EMBARCADERO to SPEAR ST (40 - 99) | - | 146' WEST OF THE EMBARCADERO | - | - | - | - | - | 53268 | 1608729660000 | -122.39049168 | 37.79044838 | - | 1675900800000 | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1599649500000 | FOLSOM ST | 40 - 99 FOLSOM ST | 40 - 99 FOLSOM ST | 40 FOLSOM ST | - | SPEAR ST | SPEAR ST |
| 36187 | N/A | Point | 1 | 1 | 1300 - 1399 | - | S259581 | 1300-1349 STEVENSON ST | 1300-1399 STEVENSON ST | F | F | - | F | 12178000 | 12178000 | - | - | EAST SIDE | - | - | - | - | MCCOPPIN ST | MCCOPPIN ST | 93696 | 93696 | 37.7707798 | -122.4216651 | - | - | 1710886823000 | middleware_editor | BIKE RACK | MCCOPPIN ST to DUBOCE AVE (1300 - 1399) | 86311 | 16' S OF NPL #1307/ 3' IN FROM CURB | - | - | - | - | - | 53269 | 1575899280000 | -122.4216651 | 37.7707798 | - | - | - | D6 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1575457260000 | STEVENSON ST | 1300 - 1399 STEVENSON ST | 1300 - 1399 STEVENSON ST | 1300 STEVENSON ST | - | DUBOCE AVE | DUBOCE AVE |
| 36188 | N/A | Point | - | - | - | - | S260178 | HYDE ST: 8TH ST \ GROVE ST \ M | - | T | T | - | F | 24429000 | 24429000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | 8TH ST \ GROVE ST \ HYDE ST | 08TH ST \ GROVE ST \ MARKET ST | 93697 | 93697 | 37.77871943 | -122.41474122 | MARKET ST \ 8TH ST \ GROVE ST \ HYDE ST | HYDE ST \ 08TH ST \ GROVE ST \ MARKET ST | 1742415293000 | middleware_editor | NO RIGHT TURN (SYM) | 08TH ST \ GROVE ST \ MARKET ST intersection | - | 10' NORTH OF MARKET ST. | - | - | - | - | - | 53270 | 1465196400000 | -122.41474122 | 37.77871943 | - | 1583222400000 | 1742415240000 | D6 | - | NO RIGHT TURN | REG | R3-1.0002 | 30X30 | SUP1 | MUNI POLE | RETD | 1578571080000 | HYDE ST | - | - | - | - | - | - |
| 36189 | N/A | Point | 1 | 1 | 951 - 999 | - | S271497 | 951-999 GILMAN AVE | 951-999 GILMAN AVE | F | F | - | F | 6187000 | 6187000 | - | - | NORTH SIDE | - | - | - | - | GIANTS DR | GIANTS DR | 93700 | 93700 | 37.71787232 | -122.38749327 | - | - | 1745354473000 | middleware_editor | PARK AT 90 DEGREES | GIANTS DR to GRIFFITH ST (951 - 999) | - | 65FT EAST OF GRIFFITH/INFO #994 | - | - | - | - | - | 53271 | 1615841640000 | -122.38749327 | 37.71787232 | - | - | - | D10 | - | PARKING:PARK AT 90 | REG | R(SF).0372 | 18X18 | SUP1 | 2IN IRON POST | IS | 1610553660000 | GILMAN AVE | 951 - 999 GILMAN AVE | 951 - 999 GILMAN AVE | 951 GILMAN AVE | - | GRIFFITH ST | GRIFFITH ST |
| 36190 | N/A | Point | 1 | 1 | 2100 - 2199 | - | S260382 | 2100-2199 NORTH POINT ST | 2100-2199 NORTH POINT ST | F | F | - | F | 9701000 | 9701000 | - | - | SOUTH SIDE | - | - | - | - | SCOTT ST | SCOTT ST | 93702 | 93702 | 37.80287972 | -122.44258373 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "M" PERMITS | SCOTT ST to DIVISADERO ST (2100 - 2199) | - | 4 FEET EAST OF DIVISADERO | - | - | - | - | - | 53272 | 1219795200000 | -122.44258373 | 37.80287972 | - | 1473724800000 | - | D2 | - | PARKING:RPP | REG | R32C(CA).0096 | 18X21 | SUP1 | LIGHT POLE | IS | 1579090920000 | NORTH POINT ST | 2100 - 2199 NORTH POINT ST | 2100 - 2199 NORTH POINT ST | 2100 NORTH POINT ST | - | DIVISADERO ST | DIVISADERO ST |
| 36191 | N/A | Point | - | 1 | 436 - 499 | - | S284101 | 436-499 6TH ST | 436-499 06TH ST | F | F | - | F | 339000 | 339000 | - | - | WEST SIDE | - | - | - | - | AHERN WAY | AHERN WAY | 93703 | 93703 | 37.77637701 | -122.40294742 | - | - | 1745858680000 | middleware_editor | NPRK 4AM-6AM MON TUE WED THUR FRI STCL | AHERN WAY to BRYANT ST (436 - 499) | - | NPL #480 | - | - | - | - | - | 53273 | - | -122.40294742 | 37.77637701 | - | 1745857800000 | - | D6 | - | STREET CLEANING | REG | R30B(CA).0141 | 18X18 | SUP1 | LIGHT POLE | IS | 1658749080000 | 06TH ST | 436 - 499 6TH ST | 436 - 499 06TH ST | 436 6TH ST | - | BRYANT ST | BRYANT ST |
| 36192 | N/A | Point | 1 | 1 | 1000 - 1099 | - | S284103 | 1000-1099 POWELL ST | 1000-1099 POWELL ST | F | F | - | F | 10687000 | 10687000 | - | - | EAST SIDE | - | - | - | - | CLAY ST | CLAY ST | 93704 | 93704 | 37.79429438 | -122.40963131 | - | - | 1710539427000 | MTA | NPRK ANY TIME | CLAY ST to WASHINGTON ST (1000 - 1099) | - | SPL #1042 | - | - | - | - | - | 53274 | 1429660800000 | -122.40963131 | 37.79429438 | - | 1658707200000 | - | D3 | - | PARKING:NPRK ANY TIME | REG | R26(CA).0001 | 12X18 | SUP1 | 2IN IRON POST | IS | 1658750340000 | POWELL ST | 1000 - 1099 POWELL ST | 1000 - 1099 POWELL ST | 1000 POWELL ST | - | WASHINGTON ST | WASHINGTON ST |
| 36193 | N/A | Point | 1 | 1 | 1 - 99 | - | S284105 | 1-99 DR CARLTON B GOODLETT PL | 1-99 DR CARLTON B GOODLETT PL | F | F | - | F | 10549000 | 10549000 | - | - | WEST SIDE | - | - | - | - | GROVE ST \ POLK ST | GROVE ST \ POLK ST | 93705 | 93705 | 37.77937463 | -122.41841255 | - | - | 1733181943000 | 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) | #36 | 88' S MCALLISTER SPACE #36 | - | - | - | - | - | 53275 | 1496102400000 | -122.41841255 | 37.77937463 | - | 1658793600000 | - | D6 | - | OTHER REGULATORY | REG | R32C(SF).0066 | 12X18 | SUP1 | 2IN IRON POST | IS | 1658760360000 | 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 |
| 36194 | N/A | Point | 1 | 1 | 450 - 499 | - | S281286 | 450-499 SANCHEZ ST | 450-499 SANCHEZ ST | F | F | - | F | 11515000 | 11515000 | - | - | EAST SIDE | - | - | - | - | FORD ST | FORD ST | 93706 | 93706 | 37.76155494 | -122.43061187 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM FRI STCL | FORD ST to 18TH ST (450 - 499) | - | SPL 483 | - | - | - | - | - | 53276 | - | -122.43061187 | 37.76155494 | - | - | - | D8 | - | STREET CLEANING | REG | R30B(CA).0298 | 18X18 | SUP2 | 2IN IRON POST | IS | 1646391840000 | SANCHEZ ST | 450 - 499 SANCHEZ ST | 450 - 499 SANCHEZ ST | 450 SANCHEZ ST | - | 18TH ST | 18TH ST |
| 36195 | N/A | Point | 1 | 1 | 450 - 499 | - | S281287 | 450-499 SANCHEZ ST | 450-499 SANCHEZ ST | F | F | - | F | 11515000 | 11515000 | - | - | EAST SIDE | - | - | - | - | FORD ST | FORD ST | 93707 | 93707 | 37.76155494 | -122.43061187 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-9PM MON-FRI EXC "S" PERMITS | FORD ST to 18TH ST (450 - 499) | - | SPL 483 | - | - | - | - | - | 53277 | - | -122.43061187 | 37.76155494 | - | - | - | D8 | - | PARKING:RPP | REG | R32C(CA).0126 | 18X21 | SUP2 | 2IN IRON POST | IS | 1646391900000 | SANCHEZ ST | 450 - 499 SANCHEZ ST | 450 - 499 SANCHEZ ST | 450 SANCHEZ ST | - | 18TH ST | 18TH ST |
| 36196 | N/A | Point | 1 | 1 | 450 - 499 | - | S281289 | 450-499 SANCHEZ ST | 450-499 SANCHEZ ST | F | F | - | F | 11515000 | 11515000 | - | - | WEST SIDE | - | - | - | - | FORD ST | FORD ST | 93709 | 93709 | 37.76155494 | -122.43061187 | - | - | 1746624952000 | middleware_editor | 2 HR PRK 8AM-9PM MON-FRI EXC "S" PERMITS | FORD ST to 18TH ST (450 - 499) | - | SPL 490 | - | - | - | - | - | 53278 | 1626246000000 | -122.43061187 | 37.76155494 | - | 1746482100000 | - | D8 | - | PARKING:RPP | REG | R32C(CA).0126 | 18X21 | SUP2 | 2 POST ALUMINUM | IS | 1646392080000 | SANCHEZ ST | 450 - 499 SANCHEZ ST | 450 - 499 SANCHEZ ST | 450 SANCHEZ ST | - | 18TH ST | 18TH ST |
| 36197 | N/A | Point | 1 | 1 | 200 - 299 | - | S281292 | 200-299 DORLAND ST | 200-299 DORLAND ST | F | F | - | F | 4935000 | 4935000 | - | - | SOUTH SIDE | - | - | - | - | CHURCH ST | CHURCH ST | 93710 | 93710 | 37.76208429 | -122.42954676 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-9PM MON-FRI EXC "S" PERMITS | CHURCH ST to SANCHEZ ST (200 - 299) | - | IFO 255 | - | - | - | - | - | 53279 | 1406073600000 | -122.42954676 | 37.76208429 | - | 1579737600000 | - | D8 | - | PARKING:RPP | REG | R32C(CA).0126 | 18X21 | SUP2 | 2IN IRON POST | IS | 1646392800000 | DORLAND ST | 200 - 299 DORLAND ST | 200 - 299 DORLAND ST | 200 DORLAND ST | - | SANCHEZ ST | SANCHEZ ST |
| 36198 | N/A | Point | 1 | 1 | 200 - 299 | - | S281293 | 200-299 DORLAND ST | 200-299 DORLAND ST | F | F | - | F | 4935000 | 4935000 | - | - | SOUTH SIDE | - | - | - | - | CHURCH ST | CHURCH ST | 93711 | 93711 | 37.76208429 | -122.42954676 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM THUR STCL | CHURCH ST to SANCHEZ ST (200 - 299) | - | IFO 255 | - | - | - | - | - | 53280 | 1406073600000 | -122.42954676 | 37.76208429 | - | 1579564800000 | - | D8 | - | STREET CLEANING | REG | R30B(CA).0080 | 18X18 | SUP2 | 2IN IRON POST | IS | 1646392860000 | DORLAND ST | 200 - 299 DORLAND ST | 200 - 299 DORLAND ST | 200 DORLAND ST | - | SANCHEZ ST | SANCHEZ ST |
| 36199 | N/A | Point | 1 | 1 | 200 - 299 | - | S281294 | 200-299 DORLAND ST | 200-299 DORLAND ST | F | F | - | F | 4935000 | 4935000 | - | - | SOUTH SIDE | - | - | - | - | CHURCH ST | CHURCH ST | 93712 | 93712 | 37.76208429 | -122.42954676 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM THUR STCL | CHURCH ST to SANCHEZ ST (200 - 299) | - | 25 FT EAST OF SANCHEZ | - | - | - | - | - | 53281 | 1406073600000 | -122.42954676 | 37.76208429 | - | 1579564800000 | - | D8 | - | STREET CLEANING | REG | R30B(CA).0080 | 18X18 | SUP2 | 2IN IRON POST | IS | 1646392980000 | DORLAND ST | 200 - 299 DORLAND ST | 200 - 299 DORLAND ST | 200 DORLAND ST | - | SANCHEZ ST | SANCHEZ ST |
| 36200 | N/A | Point | 1 | 1 | 1439 - 1499 | - | S284992 | 1439-1499 15TH ST | 1439-1499 15TH ST | F | F | - | F | 646000 | 646000 | - | - | SOUTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | SHOTWELL ST | SHOTWELL ST | 96070 | 96070 | 37.76683836 | -122.417097 | - | - | 1710539427000 | MTA | WARNING-SUSPICIOUS ACTIVITIES IMMEDIATELY RPTD TO POLICE ETC | SHOTWELL ST to SOUTH VAN NESS AVE (1439 - 1499) | - | EPL 1455 UNDER SIGN | - | - | - | - | - | 53282 | 1663286400000 | -122.417097 | 37.76683836 | - | - | - | D9 | - | OTHER WARNING | WARNING | SW(SF).0007 | 18X24 | SUP2 | LIGHT POLE | IS | 1662973800000 | 15TH ST | 1439 - 1499 15TH ST | 1439 - 1499 15TH ST | 1439 15TH ST | - | SOUTH VAN NESS AVE | SOUTH VAN NESS AVE |
| 36201 | N/A | Point | - | - | - | - | S285245 | CALIFORNIA ST: 15TH AVE | - | F | F | - | F | 27623000 | 27623000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CALIFORNIA ST | CALIFORNIA ST | 96773 | 96773 | 37.78437046 | -122.47424554 | 15TH AVE \ CALIFORNIA ST | 15TH AVE \ CALIFORNIA ST | 1710539427000 | MTA | ALL WAY | CALIFORNIA ST intersection | - | 25FT EAST OF 15TH AVE | - | - | - | - | - | 53283 | 1665014400000 | -122.47424554 | 37.78437046 | - | 1666137600000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | LIGHT POLE | IS | 1664271900000 | 15TH AVE | - | - | - | - | - | - |
| 36202 | N/A | Point | - | - | - | - | S285246 | CALIFORNIA ST: 15TH AVE | - | F | F | - | F | 27623000 | 27623000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CALIFORNIA ST | CALIFORNIA ST | 96774 | 96774 | 37.78437046 | -122.47424554 | 15TH AVE \ CALIFORNIA ST | 15TH AVE \ CALIFORNIA ST | 1710539427000 | MTA | ALL WAY | CALIFORNIA ST intersection | - | - | - | - | - | - | - | 53284 | 1665014400000 | -122.47424554 | 37.78437046 | - | - | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1664272020000 | 15TH AVE | - | - | - | - | - | - |
| 36203 | N/A | Point | - | - | - | - | S285247 | CALIFORNIA ST: 15TH AVE | - | F | F | - | F | 27623000 | 27623000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CALIFORNIA ST | CALIFORNIA ST | 96775 | 96775 | 37.78437046 | -122.47424554 | 15TH AVE \ CALIFORNIA ST | 15TH AVE \ CALIFORNIA ST | 1710539427000 | MTA | STOP | CALIFORNIA ST intersection | - | - | - | - | - | - | - | 53285 | 1665014400000 | -122.47424554 | 37.78437046 | - | - | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1664272140000 | 15TH AVE | - | - | - | - | - | - |
| 36204 | N/A | Point | 1 | 1 | 100 - 140 | - | S266592 | 100-140 POST ST | 100-140 POST ST | F | F | - | F | 10625000 | 10625000 | - | - | SOUTH SIDE | - | - | - | - | KEARNY ST | KEARNY ST | 96777 | 96777 | 37.78885055 | -122.40400233 | - | - | 1710539427000 | MTA | NPRK 2AM-6AM TUE THUR STCL | KEARNY ST to ROBERT KIRK LN (100 - 140) | - | 40' W OF KEARNY | - | - | - | - | - | 53286 | 1595936520000 | -122.40400233 | 37.78885055 | - | - | - | D3 | - | STREET CLEANING | REG | R30B(CA).0133 | 18X18 | SUP1 | LIGHT POLE | IS | 1595857740000 | POST ST | 100 - 140 POST ST | 100 - 140 POST ST | 100 POST ST | - | ROBERT KIRK LN | ROBERT KIRK LN |
| 36205 | N/A | Point | 1 | 1 | 800 - 929 | - | S266830 | 800-929 ASHBURY ST | 800-929 ASHBURY ST | T | T | - | F | 2515000 | 2515000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | FREDERICK ST | FREDERICK ST | 96778 | 96778 | 37.76621823 | -122.44616595 | - | - | 1710539427000 | MTA | AHEAD | FREDERICK ST to PIEDMONT ST (800 - 929) | 135957 | NPL#880 ASHBURY | - | - | - | - | - | 53287 | 1329350400000 | -122.44616595 | 37.76621823 | - | 1596585600000 | - | D8 | - | OTHER WARNING | WARNING | W16-9P.0001 | 24X12 | SUP2 | 2IN IRON POST | IS | 1596534000000 | ASHBURY ST | 800 - 929 ASHBURY ST | 800 - 929 ASHBURY ST | 800 ASHBURY ST | - | PIEDMONT ST | PIEDMONT ST |
| 36206 | N/A | Point | - | - | - | - | S285357 | JOOST AVE: CONGO ST | - | F | F | - | F | 22142000 | 22142000 | - | SHOULD BE RETIRED | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CONGO ST | JOOST AVE | 96827 | 96827 | 37.73235684 | -122.44202705 | JOOST AVE \ CONGO ST | CONGO ST \ JOOST AVE | 1710539427000 | MTA | ALL WAY | JOOST AVE intersection | - | - | - | - | - | - | - | 53288 | - | -122.44202705 | 37.73235684 | - | - | 1710165660000 | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | RETD | 1664892180000 | CONGO ST | - | - | - | - | - | - |
| 36207 | N/A | Point | - | - | - | - | S285358 | JOOST AVE: CONGO ST | - | F | F | - | F | 22142000 | 22142000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CONGO ST | JOOST AVE | 96828 | 96828 | 37.73235684 | -122.44202705 | JOOST AVE \ CONGO ST | CONGO ST \ JOOST AVE | 1710539427000 | MTA | ALL WAY | JOOST AVE intersection | - | - | - | - | - | - | - | 53289 | - | -122.44202705 | 37.73235684 | - | 1664928000000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1664892240000 | CONGO ST | - | - | - | - | - | - |
| 36208 | N/A | Point | - | - | - | - | S285359 | JOOST AVE: CONGO ST | - | F | F | - | F | 22142000 | 22142000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CONGO ST | JOOST AVE | 96829 | 96829 | 37.73235684 | -122.44202705 | JOOST AVE \ CONGO ST | CONGO ST \ JOOST AVE | 1710539427000 | MTA | STOP | JOOST AVE intersection | - | - | - | - | - | - | - | 53290 | - | -122.44202705 | 37.73235684 | - | 1664928000000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1664892420000 | CONGO ST | - | - | - | - | - | - |
| 36209 | N/A | Point | - | - | - | - | S286504 | LAKE ST: 6TH AVE | - | F | F | - | F | 27598000 | 27598000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | LAKE ST | 06TH AVE | 96833 | 96833 | 37.78667044 | -122.46469346 | 6TH AVE \ LAKE ST | LAKE ST \ 06TH AVE | 1714785553000 | middleware_editor | FG 300 UR DELINEATOR (W) | 06TH AVE intersection | - | 9 FT AND 24 FT FROM CURB | - | - | - | - | - | 53291 | 1670803200000 | -122.46469346 | 37.78667044 | - | - | - | D1 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | STANDARD BASE | IS | 1670839920000 | LAKE ST | - | - | - | - | - | - |
| 36210 | N/A | Point | - | - | - | - | S286506 | LAKE ST: 4TH AVE | - | F | F | - | F | 27588000 | 27588000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 4TH AVE | 04TH AVE | 96835 | 96835 | 37.78676805 | -122.46254656 | LAKE ST \ 4TH AVE | LAKE ST \ 04TH AVE | 1725411689000 | middleware_editor | FG 300 UR DELINEATOR (W) | 04TH AVE intersection | - | 8 FT AND 22 FT FROM CURB | - | - | - | - | - | 53292 | 1670803200000 | -122.46254656 | 37.78676805 | - | - | - | D2 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1670840340000 | LAKE ST | - | - | - | - | - | - |
| 36211 | N/A | Point | - | - | - | - | S272867 | ELLIS ST: LEAVENWORTH ST | - | T | T | - | F | 25139000 | 25139000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | ELLIS ST | ELLIS ST | 96836 | 96836 | 37.78465714 | -122.4144302 | LEAVENWORTH ST \ ELLIS ST | LEAVENWORTH ST \ ELLIS ST | 1710539427000 | MTA | NO RIGHT TURN (SYM) ON RED | ELLIS ST intersection | - | - | - | - | - | - | - | 53293 | 1601856000000 | -122.4144302 | 37.78465714 | - | 1620086400000 | - | D6 | - | NO RIGHT TURN | REG | R13A(CA).0003 | 24X36 | SUP1 | 2IN FLANGE POST | IS | 1614776820000 | LEAVENWORTH ST | - | - | - | - | - | - |
| 36212 | N/A | Point | - | - | - | - | S272767 | MASON ST: GEARY ST | - | T | T | - | F | 24917000 | 24917000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | GEARY ST | GEARY ST | 96850 | 96850 | 37.78714914 | -122.40987402 | MASON ST \ GEARY ST | MASON ST \ GEARY ST | 1710539427000 | MTA | NO RIGHT TURN (SYM) ON RED | GEARY ST intersection | - | - | - | - | - | - | - | 53294 | 1593648000000 | -122.40987402 | 37.78714914 | - | 1617148800000 | - | D3 | - | NO RIGHT TURN | REG | R13A(CA).0003 | 24X36 | SUP1 | 2IN IRON POST | IS | 1614676740000 | MASON ST | - | - | - | - | - | - |
| 36213 | N/A | Point | - | - | - | - | S272770 | GEARY ST: TAYLOR ST | - | T | T | - | F | 24941000 | 24941000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | TAYLOR ST | GEARY ST | 96851 | 96851 | 37.78693971 | -122.41151577 | GEARY ST \ TAYLOR ST | TAYLOR ST \ GEARY ST | 1710539427000 | MTA | NO RIGHT TURN (SYM) ON RED | GEARY ST intersection | - | - | - | - | - | - | - | 53295 | 1126656000000 | -122.41151577 | 37.78693971 | - | 1617235200000 | - | D3 | - | NO RIGHT TURN | REG | R13A(CA).0003 | 24X36 | SUP1 | LIGHT POLE | IS | 1614677700000 | TAYLOR ST | - | - | - | - | - | - |
| 36214 | N/A | Point | - | - | - | - | S272771 | GEARY ST: TAYLOR ST | - | T | T | - | F | 24941000 | 24941000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | TAYLOR ST | GEARY ST | 96852 | 96852 | 37.78693971 | -122.41151577 | GEARY ST \ TAYLOR ST | TAYLOR ST \ GEARY ST | 1710539427000 | MTA | NO RIGHT TURN (SYM) ON RED | GEARY ST intersection | - | - | - | - | - | - | - | 53296 | 1126656000000 | -122.41151577 | 37.78693971 | - | 1617235200000 | - | D3 | - | NO RIGHT TURN | REG | R13A(CA).0003 | 24X36 | SUP1 | 2IN FLANGE POST | IS | 1614678120000 | TAYLOR ST | - | - | - | - | - | - |
| 36215 | N/A | Point | 1 | 1 | 45 - 82 | - | S267348 | 45-82 5TH ST | 45-82 05TH ST | F | F | - | F | 291000 | 291000 | - | - | WEST SIDE | - | - | - | - | MINT PLZ | MINT PLZ | 99242 | 99242 | 37.78322487 | -122.40710016 | - | - | 1710539427000 | MTA | BIKE RACK | MINT PLZ to JESSIE ST (45 - 82) | - | 145' N OF MISSION/3' IN FROM CURB | - | - | - | - | - | 53297 | 1598624820000 | -122.40710016 | 37.78322487 | - | - | - | D6 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1597924380000 | 05TH ST | 45 - 82 5TH ST | 45 - 82 05TH ST | 45 5TH ST | - | JESSIE ST | JESSIE ST |
| 36216 | N/A | Point | 1 | 1 | 3000 - 3223 | - | S263469 | 3000-3223 FULTON ST | 3000-3223 FULTON ST | F | F | - | F | 5912000 | 5912000 | - | - | SOUTH SIDE | - | - | - | - | 06TH AVE | 06TH AVE | 99243 | 99243 | 37.7735564 | -122.46428044 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM WED STCL | 06TH AVE to 07TH AVE (3000 - 3223) | - | 50 FT WEST OF 6TH AVE OPP 3010 | - | - | - | - | - | 53298 | 1460937600000 | -122.46428044 | 37.7735564 | - | 1588118400000 | - | D1 | - | STREET CLEANING | REG | R30B(CA).0312 | 18X18 | SUP2 | LIGHT POLE | IS | 1587559680000 | FULTON ST | 3000 - 3223 FULTON ST | 3000 - 3223 FULTON ST | 3000 FULTON ST | - | 07TH AVE | 07TH AVE |
| 36217 | N/A | Point | 1 | 1 | 500 - 599 | - | S263604 | 500-599 WISCONSIN ST | 500-599 WISCONSIN ST | F | F | - | F | 13694000 | 13694000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | 19TH ST | 19TH ST | 99244 | 99244 | 37.76048825 | -122.39924234 | - | - | 1710539427000 | MTA | SCHOOL (SYM)/SCHOOL | 19TH ST to 20TH ST (500 - 599) | 100438 | NPL# 517 | - | - | - | - | - | 53299 | 1123632000000 | -122.39924234 | 37.76048825 | - | 1637020800000 | - | D10 | - | SCHOOL | WARNING | SW24-1(CA).0001 | 30X42 | SUP1 | 2IN IRON POST | IS | 1588068120000 | WISCONSIN ST | 500 - 599 WISCONSIN ST | 500 - 599 WISCONSIN ST | 500 WISCONSIN ST | - | 20TH ST | 20TH ST |
| 36218 | N/A | Point | 1 | 1 | 400 - 499 | - | S263605 | 400-499 CAROLINA ST | 400-499 CAROLINA ST | F | F | - | F | 3709000 | 3709000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | MARIPOSA ST | MARIPOSA ST | 99245 | 99245 | 37.7629828 | -122.4004517 | - | - | 1710539427000 | MTA | SCHOOL (SYM)/SCHOOL | MARIPOSA ST to 18TH ST (400 - 499) | 100432 | 90' NORTH OF 18TH ST. | - | - | - | - | - | 53300 | 1123632000000 | -122.4004517 | 37.7629828 | - | 1624492800000 | - | D10 | - | SCHOOL | WARNING | SW24-1(CA).0001 | 30X42 | SUP1 | 2IN IRON POST | IS | 1588068300000 | CAROLINA ST | 400 - 499 CAROLINA ST | 400 - 499 CAROLINA ST | 400 CAROLINA ST | - | 18TH ST | 18TH ST |
| 36219 | N/A | Point | 1 | 1 | 2300 - 2349 | - | S263606 | 2300-2349 19TH ST | 2300-2349 19TH ST | F | F | - | F | 956000 | 956000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | SAN BRUNO AVE | SAN BRUNO AVE | 99246 | 99246 | 37.76077036 | -122.40546613 | - | - | 1746553309000 | middleware_editor | SCHOOL (SYM)/SCHOOL | SAN BRUNO AVE to 19TH ST (2300 - 2349) | - | WPL# 2203 | - | - | - | - | - | 53301 | - | -122.40546613 | 37.76077036 | - | 1745873100000 | - | D10 | - | SCHOOL | WARNING | SW24-1(CA).0001 | 30X42 | SUP1 | 2IN IRON POST | IS | 1588068780000 | 19TH ST | 2300 - 2349 19TH ST | 2300 - 2349 19TH ST | 2300 19TH ST | - | 19TH ST | 19TH ST |
| 36220 | N/A | Point | 1 | 1 | 1500 - 1599 | - | S263614 | 1500-1599 20TH ST | 1500-1599 20TH ST | F | F | - | F | 1034000 | 1034000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | MISSOURI ST | MISSOURI ST | 99247 | 99247 | 37.75999655 | -122.3967664 | - | - | 1710539427000 | MTA | SCHOOL (SYM)/SCHOOL | MISSOURI ST to CONNECTICUT ST (1500 - 1599) | 100421 | WPL# 1529 | - | - | - | - | - | 53302 | 1124236800000 | -122.3967664 | 37.75999655 | - | - | - | D10 | - | SCHOOL | WARNING | SW24-1(CA).0001 | 30X42 | SUP1 | 2IN IRON POST | IS | 1588075560000 | 20TH ST | 1500 - 1599 20TH ST | 1500 - 1599 20TH ST | 1500 20TH ST | - | CONNECTICUT ST | CONNECTICUT ST |
| 36221 | N/A | Point | 1 | 1 | 1100 - 1199 | - | S263627 | 1100-1199 GILMAN AVE | 1100-1199 GILMAN AVE | F | F | - | F | 6189000 | 6189000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | HAWES ST | HAWES ST | 99248 | 99248 | 37.71982378 | -122.39094501 | - | - | 1745605247000 | middleware_editor | SCHOOL (SYM)/SCHOOL | HAWES ST to INGALLS ST (1100 - 1199) | 191456 | WPL# 1115 | - | - | - | - | - | 53303 | 1142496000000 | -122.39094501 | 37.71982378 | - | 1745604900000 | - | D10 | - | SCHOOL | WARNING | SW24-1(CA).0001 | 30X42 | SUP1 | 2IN IRON POST | IS | 1588089240000 | GILMAN AVE | 1100 - 1199 GILMAN AVE | 1100 - 1199 GILMAN AVE | 1100 GILMAN AVE | - | INGALLS ST | INGALLS ST |
| 36222 | N/A | Point | - | - | - | - | S263958 | SOUTHERN HEIGHTS AVE: DE HARO | - | F | F | - | F | 23739000 | 23739000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | DE HARO ST | DE HARO ST | 99249 | 99249 | 37.75813209 | -122.40095977 | \SOUTHERN HEIGHTS AVE: DE HARO | SOUTHERN HEIGHTS AVE \ DE HARO ST | 1710539427000 | MTA | ALL WAY | DE HARO ST intersection | - | - | - | - | - | - | - | 53304 | 802396800000 | -122.40095977 | 37.75813209 | - | 1145923200000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1588683660000 | SOUTHERN HEIGHTS AVE | - | - | - | - | - | - |
| 36223 | N/A | Point | - | - | - | - | S285999 | MANGELS AVE: CONGO ST | - | F | F | - | F | 22272000 | 22272000 | - | - | NORTH WEST CORNER | - | - | - | - | CONGO ST | CONGO ST | 99250 | 99250 | 37.73309796 | -122.44200232 | MANGELS AVE \ CONGO ST | MANGELS AVE \ CONGO ST | 1713575169000 | middleware_editor | MANGELS AVE | CONGO ST intersection | - | 200 | - | - | - | - | - | 53305 | - | -122.44200232 | 37.73309796 | - | 1684972800000 | - | D7 | - | STREET NAME | GUIDE | D3-1.1108 | 36X08 | SUP2 | 3IN IRON POST | IS | 1668606600000 | MANGELS AVE | - | - | - | - | - | - |
| 36224 | N/A | Point | - | - | - | - | S286111 | 19TH AVE: BYXBEE ST \ RANDOLPH | - | F | F | - | F | 22543000 | 22543000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 19TH AVE \ BYXBEE ST | 19TH AVE \ BYXBEE ST | 99251 | 99251 | 37.71428168 | -122.46979824 | RANDOLPH ST \ 19TH AVE \ BYXBEE ST | RANDOLPH ST \ 19TH AVE \ BYXBEE ST | 1710539427000 | MTA | DEAD END | 19TH AVE \ BYXBEE ST intersection | - | - | - | - | - | - | - | 53306 | 1671580800000 | -122.46979824 | 37.71428168 | - | - | - | D11 | - | OTHER WARNING | WARNING | W14-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1669110180000 | RANDOLPH ST | - | - | - | - | - | - |
| 36225 | N/A | Point | - | - | - | - | S286113 | 19TH AVE: BYXBEE ST \ RANDOLPH | - | F | F | - | F | 22543000 | 22543000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 19TH AVE \ BYXBEE ST | 19TH AVE \ BYXBEE ST | 99252 | 99252 | 37.71428168 | -122.46979824 | RANDOLPH ST \ 19TH AVE \ BYXBEE ST | RANDOLPH ST \ 19TH AVE \ BYXBEE ST | 1710539427000 | MTA | DEAD END | 19TH AVE \ BYXBEE ST intersection | - | - | - | - | - | - | - | 53307 | 1671580800000 | -122.46979824 | 37.71428168 | - | - | - | D11 | - | OTHER WARNING | WARNING | W14-1.0002 | 30X30 | SUP2 | MUNI POLE | IS | 1669110300000 | RANDOLPH 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.