locations
169 rows where category_id = 51149 sorted by added descending
This data as json, CSV (advanced)
Suggested facets: ward, active, added (date), removed (date)
| Link | rowid | location | ward | category | category_id | active | added ▲ | removed | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|
| 23282 | 23282 | 70 COUNTRYSIDE RD | 8 | Street Signs | 51149 | 2025-12-23 | 2025-12-23 | 42.306894 | -71.201304 | |
| 23293 | 23293 | 65 RACHEL ROAD | 8 | Street Signs | 51149 | 2025-12-23 | 2025-12-23 | 42.307516 | -71.202934 | |
| 23294 | 23294 | 274 NEWTONVILLE AVENUE | 2 | Street Signs | 51149 | 2025-12-23 | 2025-12-23 | 42.352298 | -71.198385 | |
| 23301 | 23301 | 182 HOMER ST | 6 | Street Signs | 51149 | active | 2025-12-23 | 42.334749 | -71.201088 | |
| 23264 | 23264 | 40 ALBEMARLE RD | 2 | Street Signs | 51149 | active | 2025-12-22 | 42.363639 | -71.21367 | |
| 23155 | 23155 | 592 CHESTNUT ST | 5 | Street Signs | 51149 | 2025-12-19 | 2025-12-22 | 42.329592 | -71.225546 | |
| 23080 | 23080 | 77 DAVIS AVE | 3 | Street Signs | 51149 | 2025-12-18 | 2025-12-23 | 42.350508 | -71.224043 | |
| 23017 | 23017 | 274 CALIFORNIA ST | 1 | Street Signs | 51149 | 2025-12-17 | 2025-12-18 | 42.36471 | -71.19941 | |
| 22966 | 22966 | 30 NORTH STREET | 2 | Street Signs | 51149 | 2025-12-16 | 2025-12-19 | 42.360326 | -71.216592 | |
| 22888 | 22888 | 3 BRIDGE STREET | 1 | Street Signs | 51149 | active | 2025-12-13 | 42.364975 | -71.204619 | |
| 22757 | 22757 | 188 EAST SIDE PKWY | 2 | Street Signs | 51149 | 2025-12-10 | 2025-12-12 | 42.348033 | -71.197236 | |
| 22768 | 22768 | 35 KINGSWOOD RD | 4 | Street Signs | 51149 | 2025-12-10 | 2025-12-11 | 42.35247 | -71.254584 | |
| 22494 | 22494 | 80 MANEMET RD | 6 | Street Signs | 51149 | 2025-12-02 | 2025-12-04 | 42.335478 | -71.203523 | |
| 22480 | 22480 | 6 ISLINGTON RD | 4 | Street Signs | 51149 | 2025-12-01 | 2025-12-01 | 42.347493 | -71.25354 | |
| 22348 | 22348 | 321 WALTHAM ST | 3 | Street Signs | 51149 | 2025-11-26 | 2025-12-01 | 42.356133 | -71.223777 | |
| 22234 | 22234 | 73 COUNTRYSIDE RD | 8 | Street Signs | 51149 | 2025-11-24 | 2025-11-25 | 42.307146 | -71.201871 | |
| 22113 | 22113 | 535 BEACON ST | 7 | Street Signs | 51149 | 2025-11-20 | 2025-11-20 | 42.332265 | -71.18186 | |
| 22118 | 22118 | 429 WOLCOTT ST | 4 | Street Signs | 51149 | 2025-11-20 | 2025-11-20 | 42.349239 | -71.245175 | |
| 21785 | 21785 | 712 WATERTOWN ST | 3 | Street Signs | 51149 | 2025-11-12 | 2025-11-28 | 42.35373 | -71.214188 | |
| 21225 | 21225 | 261 WALNUT STREET | 2 | Street Signs | 51149 | 2025-10-30 | 2025-10-31 | 42.351799 | -71.207698 | |
| 21229 | 21229 | 911 WASHINGTON STREET | 2 | Street Signs | 51149 | 2025-10-30 | 2025-10-31 | 42.35124 | -71.210058 | |
| 21184 | 21184 | 24 HICKORY CLIFF RD | 5 | Street Signs | 51149 | 2025-10-29 | 2025-10-30 | 42.316992 | -71.219763 | |
| 20526 | 20526 | 568 CALIFORNIA STREET | 1 | Street Signs | 51149 | 2025-10-12 | 2025-10-26 | 42.360615 | -71.210638 | |
| 20276 | 20276 | 57 OLD COLONY RD | 7 | Street Signs | 51149 | 2025-10-03 | 2025-10-07 | 42.33537 | -71.173598 | |
| 20277 | 20277 | 122 COLLEGE RD | 7 | Street Signs | 51149 | 2025-10-03 | 2025-10-07 | 42.336567 | -71.172005 | |
| 20112 | 20112 | 21 NEWTONVILLE AVE | 1 | Street Signs | 51149 | 2025-09-30 | 2025-10-01 | 42.352155 | -71.186981 | |
| 19783 | 19783 | 108 JACKSON RD | 1 | Street Signs | 51149 | 2025-09-22 | 2025-09-22 | 42.359274 | -71.194658 | |
| 19784 | 19784 | 71 BEETHOVEN AVE | 5 | Street Signs | 51149 | 2025-09-22 | 2025-09-22 | 42.328179 | -71.218692 | |
| 19785 | 19785 | 293 CABOT ST | 2 | Street Signs | 51149 | 2025-09-22 | 2025-09-22 | 42.348195 | -71.202218 | |
| 19684 | 19684 | 23 BRANDEIS CIR | 8 | Street Signs | 51149 | 2025-09-18 | 2025-10-02 | 42.311259 | -71.194437 | |
| 19702 | 19702 | 978 CENTRE STREET | 7 | Street Signs | 51149 | 2025-09-18 | 2025-09-22 | 42.336256 | -71.193064 | |
| 19662 | 19662 | 30 BEETHOVEN AVE | 5 | Street Signs | 51149 | 2025-09-17 | 2025-09-18 | 42.329682 | -71.217707 | |
| 19596 | 19596 | 36 MANDALAY ROAD | 7 | Street Signs | 51149 | 2025-09-16 | 2025-09-17 | 42.340618 | -71.181552 | |
| 19563 | 19563 | 294 ELLIOT ST | 5 | Street Signs | 51149 | 2025-09-15 | 2025-09-17 | 42.312528 | -71.221568 | |
| 19352 | 19352 | 230 WOODWARD ST | 5 | Street Signs | 51149 | 2025-09-10 | 2025-09-10 | 42.322995 | -71.221046 | |
| 19176 | 19176 | 5 HAMLIN RD | 2 | Street Signs | 51149 | 2025-09-05 | 2025-09-11 | 42.339906 | -71.199045 | |
| 19078 | 19078 | 115 WABAN STREET | 1 | Street Signs | 51149 | 2025-09-03 | 2025-09-22 | 42.358644 | -71.19445 | |
| 19037 | 19037 | 20 HARTFORD ST | 6 | Street Signs | 51149 | 2025-09-02 | 2025-09-03 | 42.320898 | -71.207735 | |
| 18822 | 18822 | 5 COCHITUATE RD | 5 | Street Signs | 51149 | 2025-08-26 | 2025-08-28 | 42.32322 | -71.214741 | |
| 18661 | 18661 | 41 LEE RD | 7 | Street Signs | 51149 | 2025-08-20 | 2025-08-25 | 42.33213 | -71.168346 | |
| 18591 | 18591 | 330 HOMER ST | 2 | Street Signs | 51149 | 2025-08-18 | 2025-08-19 | 42.336045 | -71.207843 | |
| 18533 | 18533 | 38 WABAN ST | 1 | Street Signs | 51149 | 2025-08-15 | 2025-08-19 | 42.357276 | -71.19072 | |
| 18539 | 18539 | 558 BEACON ST | 7 | Street Signs | 51149 | 2025-08-15 | 2025-08-20 | 42.331572 | -71.182769 | |
| 18456 | 18456 | 15 LOTHROP ST | 1 | Street Signs | 51149 | 2025-08-14 | 2025-08-14 | 42.357276 | -71.203446 | |
| 18463 | 18463 | 325 BEACON ST | 7 | Street Signs | 51149 | 2025-08-14 | 2025-08-14 | 42.333273 | -71.171924 | |
| 18217 | 18217 | 94 GROVE ST | 4 | Street Signs | 51149 | 2025-08-07 | 2025-08-11 | 42.343308 | -71.248226 | |
| 18025 | 18025 | 361 WASHINGTON ST | 1 | Street Signs | 51149 | 2025-08-04 | 2025-08-05 | 42.356655 | -71.188191 | |
| 17728 | 17728 | 582 BEACON ST | 7 | Street Signs | 51149 | 2025-07-26 | 2025-07-29 | 42.331518 | -71.183867 | |
| 17413 | 17413 | 362 WATERTOWN STREET | 1 | Street Signs | 51149 | 2025-07-20 | 2025-07-31 | 42.360599 | -71.201008 | |
| 17404 | 17404 | 905 WASHINGTON ST | 2 | Street Signs | 51149 | 2025-07-19 | 2025-07-21 | 42.351318 | -71.209971 | |
| 17405 | 17405 | 1483 CENTRE ST | 6 | Street Signs | 51149 | 2025-07-19 | 2025-07-23 | 42.324336 | -71.200431 | |
| 16997 | 16997 | 130 RACHEL RD | 8 | Street Signs | 51149 | 2025-07-14 | 2025-07-23 | 42.306354 | -71.205314 | |
| 16868 | 16868 | 85 FAXON ST | 1 | Street Signs | 51149 | 2025-07-10 | 2025-07-11 | 42.362109 | -71.198861 | |
| 16385 | 16385 | 228 RIVER ST | 4 | Street Signs | 51149 | 2025-06-30 | 2025-07-02 | 42.35508 | -71.235576 | |
| 16222 | 16222 | 466 WOODWARD ST | 5 | Street Signs | 51149 | 2025-06-26 | 2025-06-30 | 42.326577 | -71.229902 | |
| 15918 | 15918 | 2077 WASHINGTON ST | 4 | Street Signs | 51149 | 2025-06-22 | 2025-06-23 | 42.330321 | -71.248617 | |
| 15772 | 15772 | 95 DORSET RD | 5 | Street Signs | 51149 | 2025-06-18 | 2025-06-18 | 42.329151 | -71.237106 | |
| 15154 | 15154 | 77 PAUL STREET | 6 | Street Signs | 51149 | 2025-06-06 | 2025-06-11 | 42.327002 | -71.197381 | |
| 14830 | 14830 | 409 CRAFTS ST | 2 | Street Signs | 51149 | 2025-06-02 | 2025-06-03 | 42.360039 | -71.216343 | |
| 14645 | 14645 | 3 PARMENTER TER | 3 | Street Signs | 51149 | 2025-05-29 | 2025-06-05 | 42.361047 | -71.231733 | |
| 14410 | 14410 | 87 DERBY ST | 3 | Street Signs | 51149 | 2025-05-23 | 2025-05-27 | 42.357582 | -71.227125 | |
| 14187 | 14187 | 1 WABAN STREET | 1 | Street Signs | 51149 | 2025-05-19 | 2025-05-21 | 42.357738 | -71.189015 | |
| 13927 | 13927 | 16 BRIDGE ST | 1 | Street Signs | 51149 | 2025-05-13 | 2025-05-22 | 42.364782 | -71.203986 | |
| 13931 | 13931 | 15 CYPRESS ST | 6 | Street Signs | 51149 | 2025-05-13 | 2025-05-19 | 42.328656 | -71.194991 | |
| 13879 | 13879 | 670 WALNUT ST | 2 | Street Signs | 51149 | 2025-05-12 | 2025-05-13 | 42.338475 | -71.206736 | |
| 13727 | 13727 | 256 PARKER ST | 8 | Street Signs | 51149 | 2025-05-08 | 2025-05-12 | 42.318558 | -71.194244 | |
| 13681 | 13681 | 150 LOWELL AVE | 2 | Street Signs | 51149 | 2025-05-07 | 2025-05-12 | 42.351867 | -71.210106 | |
| 13520 | 13520 | 12 HILLCREST CIR | 5 | Street Signs | 51149 | 2025-05-04 | 2025-05-05 | 42.324291 | -71.228831 | |
| 13498 | 13498 | 72 WESTMINSTER RD | 7 | Street Signs | 51149 | 2025-05-02 | 2025-05-05 | 42.326325 | -71.185577 | |
| 13387 | 13387 | 49 ASH ST | 4 | Street Signs | 51149 | active | 2025-04-30 | 42.347376 | -71.250836 | |
| 13287 | 13287 | 624 WASHINGTON ST | 2 | Street Signs | 51149 | 2025-04-28 | 2025-04-30 | 42.353685 | -71.199158 | |
| 13178 | 13178 | 10 NONANTUM ST | 1 | Street Signs | 51149 | 2025-04-25 | 2025-04-25 | 42.350175 | -71.175164 | |
| 13170 | 13170 | 126 GLEN AVENUE | 7 | Street Signs | 51149 | 2025-04-24 | 2025-04-25 | 42.327714 | -71.188086 | |
| 12474 | 12474 | 394 ELLIOT ST | 5 | Street Signs | 51149 | 2025-04-04 | 2025-04-07 | 42.31215 | -71.226239 | |
| 12035 | 12035 | 29 GREENWOOD ST | 8 | Street Signs | 51149 | 2025-03-24 | 2025-03-24 | 42.310377 | -71.182724 | |
| 12014 | 12014 | 160 VARICK ROAD | 5 | Street Signs | 51149 | 2025-03-23 | 2025-03-24 | 42.324847 | -71.244889 | |
| 12016 | 12016 | 986 WALNUT ST | 6 | Street Signs | 51149 | 2025-03-23 | 2025-03-24 | 42.327657 | -71.205944 | |
| 11967 | 11967 | 33 ALDEN ST | 7 | Street Signs | 51149 | 2025-03-21 | 2025-03-21 | 42.337242 | -71.193006 | |
| 11968 | 11968 | 962 CENTRE ST | 7 | Street Signs | 51149 | 2025-03-21 | 2025-03-21 | 42.339321 | -71.192493 | |
| 11969 | 11969 | 32 WARE RD | 4 | Street Signs | 51149 | 2025-03-21 | 2025-03-21 | 42.349266 | -71.25075 | |
| 11762 | 11762 | 20 HOVEY STREET | 1 | Street Signs | 51149 | active | 2025-03-14 | 42.356585 | -71.190104 | |
| 11789 | 11789 | 94 WINCHESTER ST | 5 | Street Signs | 51149 | 2025-03-14 | 2025-03-24 | 42.316785 | -71.208648 | |
| 11747 | 11747 | 169 FLORENCE STREET | 8 | Street Signs | 51149 | 2025-03-13 | 2025-03-14 | 42.317759 | -71.174932 | |
| 11731 | 11731 | 833 WASHINGTON ST | 2 | Street Signs | 51149 | 2025-03-12 | 2025-03-13 | 42.351795 | -71.207204 | |
| 11659 | 11659 | 6 CAULFIELD CIRCLE | 8 | Street Signs | 51149 | 2025-03-11 | 2025-03-17 | 42.288676 | -71.185669 | |
| 11691 | 11691 | 100 NEEDHAM ST | 8 | Street Signs | 51149 | 2025-03-11 | 2025-03-24 | 42.313905 | -71.211213 | |
| 11585 | 11585 | 793 WASHINGTON ST | 2 | Street Signs | 51149 | 2025-03-10 | 2025-03-11 | 42.352029 | -71.206083 | |
| 11594 | 11594 | 232 BROOKLINE ST | 8 | Street Signs | 51149 | 2025-03-10 | 2025-03-11 | 42.30261 | -71.176955 | |
| 11418 | 11418 | 27 CHESTER STREET | 6 | Street Signs | 51149 | 2025-03-07 | 2025-03-10 | 42.322921 | -71.20992 | |
| 11469 | 11469 | 77 FAIR OAKS AVE | 2 | Street Signs | 51149 | 2025-03-07 | 2025-03-19 | 42.360444 | -71.212334 | |
| 11493 | 11493 | 153 WESTCHESTER RD | 2 | Street Signs | 51149 | 2025-03-07 | 2025-03-11 | 42.345135 | -71.194095 | |
| 11308 | 11308 | 79 NEWELL RD | 4 | Street Signs | 51149 | 2025-03-03 | 2025-03-06 | 42.351192 | -71.243793 | |
| 11243 | 11243 | 701 WASHINGTON ST | 2 | Street Signs | 51149 | 2025-02-28 | 2025-02-28 | 42.352911 | -71.202434 | |
| 11215 | 11215 | 4 HUNNEWELL CIR | 1 | Street Signs | 51149 | 2025-02-27 | 2025-03-05 | 42.355845 | -71.179232 | |
| 11027 | 11027 | 147 BROOKLINE ST | 8 | Street Signs | 51149 | 2025-02-24 | 2025-02-24 | 42.305022 | -71.174907 | |
| 10848 | 10848 | 12 FURBER LN | 6 | Street Signs | 51149 | 2025-02-19 | 2025-02-20 | 42.335316 | -71.194032 | |
| 10674 | 10674 | 125 MCCARTHY RD | 8 | Street Signs | 51149 | 2025-02-18 | 2025-02-18 | 42.296121 | -71.186391 | |
| 10738 | 10738 | 1005 CHESTNUT ST | 5 | Street Signs | 51149 | 2025-02-18 | 2025-02-20 | 42.314715 | -71.225375 | |
| 10789 | 10789 | 823 WASHINGTON ST | 2 | Street Signs | 51149 | 2025-02-18 | 2025-02-19 | 42.351876 | -71.206866 | |
| 10492 | 10492 | 197 TREMONT ST | 1 | Street Signs | 51149 | 2025-02-14 | 2025-02-25 | 42.352956 | -71.176302 | |
| 10343 | 10343 | 110 HULL ST | 2 | Street Signs | 51149 | 2025-02-11 | 2025-02-12 | 42.343992 | -71.210997 | |
| 10299 | 10299 | 59 WOODLAND RD | 4 | Street Signs | 51149 | 2025-02-10 | 2025-02-11 | 42.343677 | -71.250557 | |
| 10232 | 10232 | 111 LINCOLN ST | 6 | Street Signs | 51149 | 2025-02-09 | 2025-02-12 | 42.321258 | -71.210912 | |
| 10179 | 10179 | 151 TREMONT ST | 1 | Street Signs | 51149 | 2025-02-07 | 2025-02-12 | 42.352101 | -71.174525 | |
| 10106 | 10106 | 4 HUNNEWELL CIR | 1 | Street Signs | 51149 | 2025-02-05 | 2025-02-09 | 42.355845 | -71.179232 | |
| 9908 | 9908 | 37 OAKWOOD RD | 2 | Street Signs | 51149 | 2025-01-31 | 2025-01-31 | 42.343204 | -71.202744 | |
| 9809 | 9809 | 8 SHORNECLIFFE RD | 7 | Street Signs | 51149 | 2025-01-28 | 2025-01-31 | 42.350031 | -71.175699 | |
| 9730 | 9730 | 2220 COMMONWEALTH AVE | 4 | Street Signs | 51149 | 2025-01-27 | 2025-01-27 | 42.346919 | -71.252681 | |
| 9695 | 9695 | 6 MASSACHUSETTS 128 | 4 | Street Signs | 51149 | 2025-01-25 | 2025-01-27 | 42.330649 | -71.254637 | |
| 9526 | 9526 | 99 WABAN STREET | 1 | Street Signs | 51149 | 2025-01-22 | 2025-01-31 | 42.358229 | -71.193429 | |
| 9474 | 9474 | 131 BISHOPSGATE ROAD | 7 | Street Signs | 51149 | 2025-01-21 | 2025-01-21 | 42.332029 | -71.184845 | |
| 9354 | 9354 | 87 LINCOLN ST | 6 | Street Signs | 51149 | 2025-01-17 | 2025-01-21 | 42.321444 | -71.209702 | |
| 9132 | 9132 | 110 HULL ST | 2 | Street Signs | 51149 | 2025-01-09 | 2025-01-13 | 42.343994 | -71.210998 | |
| 8812 | 8812 | 550 BEACON ST | 7 | Street Signs | 51149 | 2025-01-02 | 2025-01-03 | 42.33181 | -71.182238 | |
| 8678 | 8678 | 9 CEDAR ST | 2 | Street Signs | 51149 | 2024-12-30 | 2025-01-02 | 42.340614 | -71.199094 | |
| 8320 | 8320 | 105 HANCOCK ST | 4 | Street Signs | 51149 | 2024-12-20 | 2024-12-23 | 42.342944 | -71.251216 | |
| 8217 | 8217 | 394 DUDLEY ROAD | 8 | Street Signs | 51149 | 2024-12-17 | 2024-12-19 | 42.30823 | -71.181026 | |
| 7980 | 7980 | 525 HAMMOND STREET | 7 | Street Signs | 51149 | 2024-12-11 | 2024-12-11 | 42.325969 | -71.165292 | |
| 7844 | 7844 | 53–99 PRAIRIE AVE | 4 | Street Signs | 51149 | 2024-12-09 | 2024-12-10 | 42.350515 | -71.239863 | |
| 7446 | 7446 | 254 CHURCH STREET | 1 | Street Signs | 51149 | 2024-11-30 | 2024-12-02 | 42.354621 | -71.189598 | |
| 7370 | 7370 | 283 BROOKLINE ST | 8 | Street Signs | 51149 | 2024-11-26 | 2024-11-26 | 42.300942 | -71.178217 | |
| 7308 | 7308 | 173 LANGLEY RD | 6 | Street Signs | 51149 | 2024-11-25 | 2024-12-04 | 42.326991 | -71.188675 | |
| 7183 | 7183 | 1479 WASHINGTON STREET | 3 | Street Signs | 51149 | 2024-11-22 | 2024-11-26 | 42.347128 | -71.231967 | |
| 7204 | 7204 | 89 CHESTNUT ST | 3 | Street Signs | 51149 | 2024-11-22 | 2024-12-09 | 42.347082 | -71.224676 | |
| 7126 | 7126 | 47 R SARGENT STREET | 7 | Street Signs | 51149 | 2024-11-20 | 2024-11-22 | 42.347128 | -71.183472 | |
| 7051 | 7051 | 138 HANCOCK STREET | 4 | Street Signs | 51149 | 2024-11-18 | 2024-11-25 | 42.341978 | -71.251246 | |
| 7052 | 7052 | 107 HANCOCK STREET | 4 | Street Signs | 51149 | 2024-11-18 | 2024-12-04 | 42.342684 | -71.251107 | |
| 7053 | 7053 | 99 HANCOCK STREET | 4 | Street Signs | 51149 | 2024-11-18 | 2024-11-25 | 42.3431 | -71.25078 | |
| 6979 | 6979 | 3 EMERALD STREET | 1 | Street Signs | 51149 | 2024-11-15 | 2024-11-19 | 42.356802 | -71.200638 | |
| 6692 | 6692 | 249 HOMER ST | 2 | Street Signs | 51149 | active | 2024-11-07 | 42.335621 | -71.204088 | |
| 6699 | 6699 | 87 HOBART ROAD | 7 | Street Signs | 51149 | 2024-11-07 | 2024-11-21 | 42.335979 | -71.18241 | |
| 6707 | 6707 | 27 WINCHESTER STREET | 5 | Street Signs | 51149 | 2024-11-07 | 2024-11-07 | 42.318885 | -71.207644 | |
| 6732 | 6732 | 179 KIRKSTALL RD | 2 | Street Signs | 51149 | 2024-11-07 | 2024-11-08 | 42.344097 | -71.199356 | |
| 6746 | 6746 | 171 PINE ST | 4 | Street Signs | 51149 | 2024-11-07 | 2024-11-08 | 42.352196 | -71.242018 | |
| 5772 | 5772 | 188 EAST SIDE PKWY | 2 | Street Signs | 51149 | 2024-10-23 | 2024-10-28 | 42.348037 | -71.197238 | |
| 5029 | 5029 | 122 AUBURN ST | 4 | Street Signs | 51149 | 2024-10-09 | 2024-10-09 | 42.344528 | -71.240223 | |
| 4899 | 4899 | 40 BEACONWOOD RD | 6 | Street Signs | 51149 | 2024-10-03 | 2024-10-08 | 42.329654 | -71.209759 | |
| 4672 | 4672 | 11 HULL STREET | 2 | Street Signs | 51149 | 2024-09-25 | 2024-09-29 | 42.34402 | -71.205981 | |
| 4359 | 4359 | 6 HYDE AVE | 7 | Street Signs | 51149 | 2024-09-17 | 2024-10-01 | 42.349728 | -71.186453 | |
| 4284 | 4284 | 194 WINCHESTER STREET | 8 | Street Signs | 51149 | 2024-09-15 | 2024-09-16 | 42.31355 | -71.209055 | |
| 4220 | 4220 | 221 WASHINGTON STREET | 1 | Street Signs | 51149 | 2024-09-12 | 2024-09-12 | 42.356698 | -71.18359 | |
| 4171 | 4171 | 170 BOYLSTON STREET | 7 | Street Signs | 51149 | 2024-09-11 | 2024-09-11 | 42.319909 | -71.174546 | |
| 4097 | 4097 | 97 CYPRESS STREET | 6 | Street Signs | 51149 | 2024-09-10 | 2024-09-11 | 42.32654 | -71.193708 | |
| 4119 | 4119 | 443–473 HAMMOND ST | 7 | Street Signs | 51149 | 2024-09-10 | 2024-09-11 | 42.328562 | -71.165742 | |
| 4126 | 4126 | 1545 BEACON STREET | 5 | Street Signs | 51149 | 2024-09-10 | 2024-09-11 | 42.328924 | -71.227758 | |
| 4127 | 4127 | 7 BEETHOVEN AVENUE | 5 | Street Signs | 51149 | 2024-09-10 | 2024-09-11 | 42.33051 | -71.218789 | |
| 4154 | 4154 | 360 HAMMOND ST | 7 | Street Signs | 51149 | 2024-09-10 | 2024-09-11 | 42.330148 | -71.16776 | |
| 4026 | 4026 | 291 LAKE AVENUE | 6 | Street Signs | 51149 | 2024-09-07 | 2024-09-11 | 42.323861 | -71.204686 | |
| 3964 | 3964 | 544 WALNUT ST | 2 | Street Signs | 51149 | 2024-09-05 | 2024-09-09 | 42.342118 | -71.206393 | |
| 3876 | 3876 | 423–433 WOLCOTT ST | 4 | Street Signs | 51149 | 2024-09-03 | 2024-09-24 | 42.348947 | -71.245129 | |
| 3806 | 3806 | 63 HARVARD STREET | 2 | Street Signs | 51149 | 2024-09-01 | 2024-09-03 | 42.350294 | -71.201446 | |
| 3785 | 3785 | 442 WALNUT ST | 2 | Street Signs | 51149 | 2024-08-30 | 2024-09-04 | 42.346144 | -71.205847 | |
| 3347 | 3347 | 27 NEEDHAM STREET | 5 | Street Signs | 51149 | 2024-08-17 | 2024-08-19 | 42.316331 | -71.210031 | |
| 3262 | 3262 | 153 WESTCHESTER RD | 2 | Street Signs | 51149 | 2024-08-15 | 2024-08-20 | 42.345137 | -71.194094 | |
| 3031 | 3031 | 75 HIGHLAND ST | 3 | Street Signs | 51149 | 2024-08-10 | 2024-08-20 | 42.346666 | -71.226477 | |
| 2785 | 2785 | 31 CRESCENT AVENUE | 6 | Street Signs | 51149 | 2024-08-06 | 2024-08-07 | 42.330221 | -71.198278 | |
| 2634 | 2634 | 661 WATERTOWN STREET | 2 | Street Signs | 51149 | 2024-08-02 | 2024-08-05 | 42.35493 | -71.212054 | |
| 2407 | 2407 | 887 MAIN STREET | Street Signs | 51149 | 2024-07-28 | 2024-07-31 | ||||
| 2210 | 2210 | 676 GROVE ST | 4 | Street Signs | 51149 | 2024-07-22 | 2024-07-24 | 42.326478 | -71.256901 | |
| 2216 | 2216 | 212 NEEDHAM STREET | 5 | Street Signs | 51149 | 2024-07-22 | 2024-07-22 | 42.31074 | -71.214087 | |
| 1917 | 1917 | 25 LINCOLN RD | 1 | Street Signs | 51149 | 2024-07-15 | 2024-07-16 | 42.356219 | -71.199133 | |
| 1612 | 1612 | 25 LINCOLN RD | 1 | Street Signs | 51149 | 2024-07-08 | 2024-07-11 | 42.356219 | -71.199133 | |
| 1322 | 1322 | 729 DEDHAM STREET | 8 | Street Signs | 51149 | 2024-07-01 | 2024-07-01 | 42.300327 | -71.188311 | |
| 1315 | 1315 | 580 WALNUT STREET | 2 | Street Signs | 51149 | 2024-06-30 | 2024-07-01 | 42.34149 | -71.206518 | |
| 1317 | 1317 | 442 WALNUT STREET | 2 | Street Signs | 51149 | 2024-06-30 | 2024-07-01 | 42.346145 | -71.20626 | |
| 1264 | 1264 | 63 COLUMBUS ST | 6 | Street Signs | 51149 | 2024-06-28 | 2024-07-01 | 42.322057 | -71.208534 | |
| 943 | 943 | 483 CENTRE STREET | 1 | Street Signs | 51149 | 2024-06-24 | 2024-06-25 | 42.353874 | -71.186525 | |
| 512 | 512 | 102 HERRICK RD | 6 | Street Signs | 51149 | 2024-06-15 | 2024-06-17 | 42.327534 | -71.192165 | |
| 431 | 431 | 29 ARLINGTON ST | 1 | Street Signs | 51149 | 2024-06-17 | 42.351248 | -71.176621 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "locations" ( [location] TEXT, [ward] INTEGER, [category] TEXT, [category_id] TEXT REFERENCES [categories]([id]), [active] TEXT, [added] TEXT, [removed] TEXT, [latitude] FLOAT, [longitude] FLOAT );