trees
218 rows where qSpecies_id = 175 sorted by Fire Prevention Districts
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts ▼ | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 86458 | 214143 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1374 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5991484.96158 | 2106064.67269 | 37.7623621284382 | -122.472611348256 | (37.7623621284382, -122.472611348256) | 1 | 8 | 11 | 56 | 12 | |||
| 97798 | 36119 | Permitted Site 7 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1374 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2016 12:00:00 AM | 3 | 5x3 | Permit Number 43440 | 5991487.33915366 | 2106070.76020768 | 37.7623789807661 | -122.472603569045 | (37.7623789807661, -122.472603569045) | 1 | 8 | 11 | 56 | 12 |
| 167877 | 214144 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1349 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5991798.36054 | 2098388.78808 | 37.7413042814624 | -122.470968230225 | (37.7413042814624, -122.470968230225) | 1 | 8 | 4 | 59 | 40 | |||
| 12553 | 58942 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1372 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/1980 12:00:00 AM | 10 | Permit Number 18220 | 6011965.36067 | 2101992.52974 | 37.752345126031 | -122.401490633396 | (37.752345126031, -122.401490633396) | 10 | 3 | 8 | 28856 | 29 | |
| 29247 | 197378 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1401 25th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6014417.43137 | 2101975.95141 | 37.7524361194401 | -122.393009750404 | (37.7524361194401, -122.393009750404) | 10 | 3 | 8 | 28856 | 1 | ||||
| 35995 | 179418 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 416 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6012204.41611 | 2086714.82751 | 37.7104090627014 | -122.399591381259 | (37.7104090627014, -122.399591381259) | 10 | 3 | 8 | 309 | 1 | |||
| 52874 | 96395 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 800 Tennessee St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2011 12:00:00 AM | 7 | 3x3 | Permit Number 767136 | 6015448.2444 | 2105163.74172 | 37.761246318881 | -122.389667624156 | (37.761246318881, -122.389667624156) | 10 | 3 | 8 | 28856 | 29 | |
| 52999 | 179419 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 416 Peninsula Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6012202.51453 | 2086708.25139 | 37.7103908999794 | -122.399597492152 | (37.7103908999794, -122.399597492152) | 10 | 3 | 8 | 309 | 1 | |||
| 78922 | 96394 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 800 Tennessee St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2011 12:00:00 AM | 8 | 3x3 | Permit Number 767136 | 6015448.02055 | 2105186.64964 | 37.7613092066883 | -122.389669998384 | (37.7613092066883, -122.389669998384) | 10 | 3 | 8 | 28856 | 29 | |
| 86143 | 248020 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 525 Franconia St | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 6009961.95945 | 2098221.90279 | 37.7418798242092 | -122.408152844395 | (37.7418798242092, -122.408152844395) | 10 | 7 | 7 | 28859 | 2 | |||
| 96873 | 248013 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 525 Franconia St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6009922.12667 | 2098078.01565 | 37.7414825109224 | -122.408280427599 | (37.7414825109224, -122.408280427599) | 10 | 7 | 7 | 28859 | 2 | |||
| 99376 | 197377 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 800 Tennessee St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 6ft | 6015450.47515 | 2105104.21656 | 37.7610829992901 | -122.389655751329 | (37.7610829992901, -122.389655751329) | 10 | 3 | 8 | 28856 | 29 | |||
| 113142 | 96393 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 800 Tennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767136 | 6015446.34816 | 2105205.82612 | 37.7613617684412 | -122.389677121926 | (37.7613617684412, -122.389677121926) | 10 | 3 | 8 | 28856 | 29 | |
| 116990 | 96391 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 800 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2011 12:00:00 AM | 6 | 3x3 | Permit Number 767136 | 6015443.33438 | 2105260.58125 | 37.7615119471268 | -122.389691369876 | (37.7615119471268, -122.389691369876) | 10 | 3 | 8 | 28856 | 29 | |
| 119846 | 248016 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 525 Franconia St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 6009938.8027 | 2098138.85559 | 37.7416504979844 | -122.408227057349 | (37.7416504979844, -122.408227057349) | 10 | 7 | 7 | 28859 | 2 | |||
| 151879 | 248011 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 525 Franconia St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 6009911.76805 | 2098028.06886 | 37.7413447878202 | -122.408312722264 | (37.7413447878202, -122.408312722264) | 10 | 7 | 7 | 28859 | 2 | |||
| 159435 | 197379 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1516 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6014025.29232 | 2102006.07579 | 37.7524970440096 | -122.394367951529 | (37.7524970440096, -122.394367951529) | 10 | 3 | 8 | 28856 | 29 | |||
| 175533 | 96392 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 800 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2011 12:00:00 AM | 6 | 3x3 | Permit Number 767136 | 6015444.53946 | 2105235.26093 | 37.7614424898011 | -122.389685433429 | (37.7614424898011, -122.389685433429) | 10 | 3 | 8 | 28856 | 29 | |
| 179619 | 197380 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 2251 Silver Ave | 2 | : | Tree | Private 2 | 11 | Width 3ft | 6012873.30802 | 2096314.08493 | 37.7368039417418 | -122.397952478343 | (37.7368039417418, -122.397952478343) | 10 | 3 | 8 | 58 | 1 | |||
| 179641 | 248018 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 525 Franconia St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 6009957.63664 | 2098204.23496 | 37.7418310701357 | -122.408166545559 | (37.7418310701357, -122.408166545559) | 10 | 7 | 7 | 28859 | 2 | |||
| 191824 | 248014 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 525 Franconia St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | Width 4ft | 6009926.50706 | 2098096.52796 | 37.7415335869952 | -122.408266587028 | (37.7415335869952, -122.408266587028) | 10 | 7 | 7 | 28859 | 2 | |||
| 39779 | 124080 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 701 Funston Ave | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5991937.65647 | 2110107.38371 | 37.7734885240998 | -122.471340232044 | (37.7734885240998, -122.471340232044) | 11 | 6 | 2 | 54 | 11 | |||
| 62406 | 119522 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 790 31st Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5986359.69309 | 2110558.27509 | 37.7744022999761 | -122.490668135755 | (37.7744022999761, -122.490668135755) | 11 | 6 | 2 | 55 | 26 | |||
| 7663 | 36879 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 2400 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 6 | Permit Number 39539 | 6000815.69964 | 2116580.40998 | 37.7917713587016 | -122.441094358926 | (37.7917713587016, -122.441094358926) | 13 | 6 | 1 | 29490 | 27 | |
| 37868 | 136353 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1508 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005781.66694 | 2118620.21558 | 37.7976537549681 | -122.424057229776 | (37.7976537549681, -122.424057229776) | 13 | 9 | 1 | 57 | 17 | |||
| 48408 | 38390 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 2435 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1998 12:00:00 AM | 5 | 3x5 | Permit Number 40447 | 6006235.29717 | 2119188.71841 | 37.7992403209449 | -122.422527961414 | (37.7992403209449, -122.422527961414) | 13 | 9 | 1 | 28858 | 32 | |
| 59498 | 38389 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 2435 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1998 12:00:00 AM | 6 | 6x5 | Permit Number 40447 | 6006233.73845 | 2119201.43676 | 37.7992751543766 | -122.422534259363 | (37.7992751543766, -122.422534259363) | 13 | 9 | 1 | 28858 | 32 | |
| 72435 | 36875 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 2400 Divisadero St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 6 | Permit Number 39539 | 6000811.56481 | 2116611.03172 | 37.7918552024927 | -122.441110863301 | (37.7918552024927, -122.441110863301) | 13 | 6 | 1 | 29490 | 27 | |
| 76271 | 36878 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 2400 Divisadero St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 6 | Permit Number 39539 | 6000806.76312 | 2116642.34595 | 37.7919409096927 | -122.441129724752 | (37.7919409096927, -122.441129724752) | 13 | 6 | 1 | 29490 | 27 | |
| 91741 | 36877 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 2400 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 7 | Permit Number 39539 | 6000814.63294 | 2116594.68212 | 37.7918104855159 | -122.441099074089 | (37.7918104855159, -122.441099074089) | 13 | 6 | 1 | 29490 | 27 | |
| 116430 | 36876 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 2400 Divisadero St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 6 | Permit Number 39539 | 6000808.4477 | 2116625.0074 | 37.7918933985134 | -122.441122651606 | (37.7918933985134, -122.441122651606) | 13 | 6 | 1 | 29490 | 27 | |
| 117972 | 136355 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1639 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6002367.63804 | 2121224.4246 | 37.8046108851334 | -122.436057126653 | (37.8046108851334, -122.436057126653) | 13 | 9 | 1 | 57 | 17 | |||
| 154144 | 38496 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1520 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1998 12:00:00 AM | 7 | Permit Number 40490 | 6005695.28325 | 2118608.46159 | 37.79761660398 | -122.424355304657 | (37.79761660398, -122.424355304657) | 13 | 9 | 1 | 57 | 17 | |
| 181174 | 136354 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1508 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005758.24578 | 2118617.72057 | 37.7976455819407 | -122.424138095904 | (37.7976455819407, -122.424138095904) | 13 | 9 | 1 | 57 | 17 | |||
| 1154 | 197414 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1110 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6014981.73944 | 2109803.00942 | 37.7739588520651 | -122.391605444662 | (37.7739588520651, -122.391605444662) | 14 | 3 | 9 | 310 | 20 | |||
| 4747 | 197441 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1300 04th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015039.64568 | 2108796.242 | 37.7711977058453 | -122.391334743299 | (37.7711977058453, -122.391334743299) | 14 | 3 | 9 | 310 | 20 | |||
| 8409 | 197436 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1300 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015031.80159 | 2108941.72055 | 37.7715967224486 | -122.391372048095 | (37.7715967224486, -122.391372048095) | 14 | 3 | 9 | 310 | 20 | |||
| 8818 | 197404 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1155 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015051.04014 | 2109607.02256 | 37.7734245621155 | -122.39135201659 | (37.7734245621155, -122.39135201659) | 14 | 3 | 9 | 310 | 20 | |||
| 12310 | 197401 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1155 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015056.14247 | 2109498.92263 | 37.7731280268706 | -122.391326808588 | (37.7731280268706, -122.391326808588) | 14 | 3 | 9 | 310 | 20 | |||
| 17902 | 113640 | Significant Tree 6 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 545X Minna St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6010081.18772 | 2112137.85468 | 37.7800965567953 | -122.408722101319 | (37.7800965567953, -122.408722101319) | 14 | 2 | 9 | 28853 | 34 | |||||
| 19057 | 251711 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 902 Market St | 3 | Front Yard : Cutout | Tree | DPW 1 | 3x3 | 6010270 | 2113565 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | 14 | 2 | 9 | 28852 | 36 | ||||
| 22296 | 113639 | Significant Tree 6 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1X Russ St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6009949.39418 | 2111947.85897 | 37.7795674908256 | -122.409164626268 | (37.7795674908256, -122.409164626268) | 14 | 2 | 9 | 28853 | 34 | |||||
| 24106 | 197438 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1300 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015034.67097 | 2108883.60182 | 37.7714373005145 | -122.391358059129 | (37.7714373005145, -122.391358059129) | 14 | 3 | 9 | 310 | 20 | |||
| 27319 | 197432 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1200 04th St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015019.54428 | 2109161.1913 | 37.7721986602722 | -122.391429792676 | (37.7721986602722, -122.391429792676) | 14 | 3 | 9 | 310 | 20 | |||
| 27914 | 197445 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 577 Nelson Rising Ln | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6013675.59633 | 2108064.32122 | 37.7691122166786 | -122.396001777755 | (37.7691122166786, -122.396001777755) | 14 | 3 | 9 | 310 | 20 | |||
| 36023 | 197442 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1300 04th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015041.42072 | 2108767.34362 | 37.7711184557895 | -122.391326582849 | (37.7711184557895, -122.391326582849) | 14 | 3 | 9 | 310 | 20 | |||
| 36594 | 251713 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 902 Market St | 5 | Front Yard : Cutout | Tree | DPW 1 | 3x3 | 6010270 | 2113565 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | 14 | 2 | 9 | 28852 | 36 | ||||
| 37111 | 197402 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1155 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015055.01936 | 2109528.18581 | 37.7732083147396 | -122.391332739634 | (37.7732083147396, -122.391332739634) | 14 | 3 | 9 | 310 | 20 | |||
| 45343 | 197431 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1200 04th St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015017.15645 | 2109191.48818 | 37.7722817162658 | -122.391440170853 | (37.7722817162658, -122.391440170853) | 14 | 3 | 9 | 310 | 20 | |||
| 46626 | 197412 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1110 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6014968.08623 | 2109861.17095 | 37.7741177928286 | -122.391656741087 | (37.7741177928286, -122.391656741087) | 14 | 3 | 9 | 310 | 20 | |||
| 48454 | 197398 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1255 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015068.90313 | 2109281.03348 | 37.7725304597531 | -122.391267433543 | (37.7725304597531, -122.391267433543) | 14 | 3 | 9 | 310 | 20 | |||
| 49544 | 197434 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1300 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015028.191 | 2108995.68449 | 37.7717446951044 | -122.391388310536 | (37.7717446951044, -122.391388310536) | 14 | 3 | 9 | 310 | 20 | |||
| 50420 | 197403 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1155 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015051.73928 | 2109577.98183 | 37.7733448615187 | -122.391347567643 | (37.7733448615187, -122.391347567643) | 14 | 3 | 9 | 310 | 20 | |||
| 52533 | 251712 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 902 Market St | 4 | Front Yard : Cutout | Tree | DPW 1 | 3x3 | 6010270 | 2113565 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | 14 | 2 | 9 | 28852 | 36 | ||||
| 54092 | 197405 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1145 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015047.0197 | 2109662.59609 | 37.7735769315563 | -122.391369809678 | (37.7735769315563, -122.391369809678) | 14 | 3 | 9 | 310 | 20 | |||
| 54464 | 251710 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 902 Market St | 2 | Front Yard : Cutout | Tree | DPW 1 | 3x3 | 6010270 | 2113565 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | 14 | 2 | 9 | 28852 | 36 | ||||
| 56514 | 197407 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1101 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015042.44961 | 2109744.00575 | 37.7738002107574 | -122.39139131067 | (37.7738002107574, -122.39139131067) | 14 | 3 | 9 | 310 | 20 | |||
| 56632 | 197385 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1350 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015094.6551 | 2108827.79856 | 37.7712874060154 | -122.391146668097 | (37.7712874060154, -122.391146668097) | 14 | 3 | 9 | 310 | 20 | |||
| 59075 | 197429 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1200 04th St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6015013.85039 | 2109250.55837 | 37.7724437264277 | -122.391455737212 | (37.7724437264277, -122.391455737212) | 14 | 3 | 9 | 310 | 20 | |||
| 66029 | 197424 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1200 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015005.72101 | 2109404.95283 | 37.7728672081818 | -122.39149465358 | (37.7728672081818, -122.39149465358) | 14 | 3 | 9 | 310 | 20 | |||
| 66426 | 197387 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1350 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015092.10625 | 2108889.4468 | 37.771456537021 | -122.391159794592 | (37.771456537021, -122.391159794592) | 14 | 3 | 9 | 310 | 20 | |||
| 67503 | 197388 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1350 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6015090.38751 | 2108917.06799 | 37.7715322833264 | -122.391167670865 | (37.7715322833264, -122.391167670865) | 14 | 3 | 9 | 310 | 20 | |||
| 72739 | 197426 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1200 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015010.27752 | 2109333.53408 | 37.772671361033 | -122.391473898118 | (37.772671361033, -122.391473898118) | 14 | 3 | 9 | 310 | 20 | |||
| 75853 | 197410 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1101 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015033.4092 | 2109848.12885 | 37.7740856078918 | -122.391429863703 | (37.7740856078918, -122.391429863703) | 14 | 3 | 9 | 310 | 20 | |||
| 78467 | 197433 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1200 04th St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015022.47536 | 2109102.12836 | 37.7720366491947 | -122.391415524027 | (37.7720366491947, -122.391415524027) | 14 | 3 | 9 | 310 | 20 | |||
| 82466 | 197381 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 500 Berry St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 6012346.20487 | 2108477.39645 | 37.770172376184 | -122.400629116167 | (37.770172376184, -122.400629116167) | 14 | 2 | 8 | 28856 | 20 | |||
| 84846 | 197392 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1255 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015078.69031 | 2109108.13979 | 37.7720562751075 | -122.391221490795 | (37.7720562751075, -122.391221490795) | 14 | 3 | 9 | 310 | 20 | |||
| 85941 | 197417 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1110 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6014986.84616 | 2109711.37392 | 37.7737075248119 | -122.391581371605 | (37.7737075248119, -122.391581371605) | 14 | 3 | 9 | 310 | 20 | |||
| 87741 | 197447 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 577 Nelson Rising Ln | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6013720.003 | 2108087.26166 | 37.769177676536 | -122.395849784245 | (37.769177676536, -122.395849784245) | 14 | 3 | 9 | 310 | 20 | |||
| 92144 | 197391 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1350 04th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6015083.72176 | 2109000.33905 | 37.7717605573392 | -122.391196549875 | (37.7717605573392, -122.391196549875) | 14 | 3 | 9 | 310 | 20 | |||
| 95096 | 251715 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 902 Market St | 7 | Front Yard : Cutout | Tree | DPW 1 | 3x3 | 6010270 | 2113565 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | 14 | 2 | 9 | 28852 | 36 | ||||
| 99300 | 197425 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1200 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015006.55649 | 2109372.07332 | 37.7727769747112 | -122.391489464471 | (37.7727769747112, -122.391489464471) | 14 | 3 | 9 | 310 | 20 | |||
| 99793 | 197443 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 577 Nelson Rising Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6013632.06784 | 2108039.85381 | 37.7690426127674 | -122.396150626374 | (37.7690426127674, -122.396150626374) | 14 | 3 | 9 | 310 | 20 | |||
| 100335 | 251709 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 902 Market St | 1 | Front Yard : Cutout | Tree | DPW 1 | 3x3 | 6010270 | 2113565 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | 14 | 2 | 9 | 28852 | 36 | ||||
| 102703 | 197399 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1255 04th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015067.88959 | 2109305.99464 | 37.7725989413206 | -122.391272684682 | (37.7725989413206, -122.391272684682) | 14 | 3 | 9 | 310 | 20 | |||
| 106042 | 197406 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1101 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015045.28656 | 2109714.70824 | 37.7737199237562 | -122.391379448623 | (37.7737199237562, -122.391379448623) | 14 | 3 | 9 | 310 | 20 | |||
| 109547 | 197389 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1350 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015087.56892 | 2108946.60059 | 37.7716132169039 | -122.39117948526 | (37.7716132169039, -122.39117948526) | 14 | 3 | 9 | 310 | 20 | |||
| 113295 | 113637 | Significant Tree 6 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1X Russ St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6009949.39418 | 2111947.85897 | 37.7795674908256 | -122.409164626268 | (37.7795674908256, -122.409164626268) | 14 | 2 | 9 | 28853 | 34 | |||||
| 115499 | 113638 | Significant Tree 6 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1X Russ St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6009949.39418 | 2111947.85897 | 37.7795674908256 | -122.409164626268 | (37.7795674908256, -122.409164626268) | 14 | 2 | 9 | 28853 | 34 | |||||
| 119933 | 197444 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 577 Nelson Rising Ln | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6013653.6839 | 2108052.2415 | 37.7690778293104 | -122.396076725459 | (37.7690778293104, -122.396076725459) | 14 | 3 | 9 | 310 | 20 | |||
| 125503 | 197394 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1255 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015074.87374 | 2109163.38918 | 37.7722077659022 | -122.391238555416 | (37.7722077659022, -122.391238555416) | 14 | 3 | 9 | 310 | 20 | |||
| 126654 | 197393 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1255 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6015077.38157 | 2109137.26391 | 37.7721361708673 | -122.391228054034 | (37.7721361708673, -122.391228054034) | 14 | 3 | 9 | 310 | 20 | |||
| 130383 | 251714 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 902 Market St | 6 | Front Yard : Cutout | Tree | DPW 1 | 3x3 | 6010270 | 2113565 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | 14 | 2 | 9 | 28852 | 36 | ||||
| 135480 | 197416 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1110 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6014985.69638 | 2109740.56035 | 37.773787600441 | -122.391587389862 | (37.773787600441, -122.391587389862) | 14 | 3 | 9 | 310 | 20 | |||
| 136671 | 197408 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1101 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015042.21783 | 2109774.95767 | 37.773885184988 | -122.391394276636 | (37.773885184988, -122.391394276636) | 14 | 3 | 9 | 310 | 20 | |||
| 138292 | 197409 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1101 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015038.49943 | 2109813.6639 | 37.7739912573174 | -122.391409845709 | (37.7739912573174, -122.391409845709) | 14 | 3 | 9 | 310 | 20 | |||
| 142946 | 197390 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1350 04th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015085.78148 | 2108970.82178 | 37.7716796237449 | -122.39118736151 | (37.7716796237449, -122.39118736151) | 14 | 3 | 9 | 310 | 20 | |||
| 143500 | 197422 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1200 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015001.02116 | 2109469.2789 | 37.7730435724386 | -122.391515409031 | (37.7730435724386, -122.391515409031) | 14 | 3 | 9 | 310 | 20 | |||
| 143573 | 197383 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1350 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6015097.30322 | 2108771.06093 | 37.7711317639632 | -122.391133541578 | (37.7711317639632, -122.391133541578) | 14 | 3 | 9 | 310 | 20 | |||
| 145732 | 197386 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1350 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015093.74839 | 2108858.04846 | 37.7713704152436 | -122.391151919239 | (37.7713704152436, -122.391151919239) | 14 | 3 | 9 | 310 | 20 | |||
| 148718 | 197418 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1110 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6014989.55587 | 2109687.64207 | 37.7736425128315 | -122.391570338707 | (37.7736425128315, -122.391570338707) | 14 | 3 | 9 | 310 | 20 | |||
| 149133 | 197435 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1300 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015029.61492 | 2108966.93535 | 37.7716658353527 | -122.391381374959 | (37.7716658353527, -122.391381374959) | 14 | 3 | 9 | 310 | 20 | |||
| 149465 | 197400 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1155 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015059.96176 | 2109443.99349 | 37.7729774155998 | -122.391309756557 | (37.7729774155998, -122.391309756557) | 14 | 3 | 9 | 310 | 20 | |||
| 153109 | 197397 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1255 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015070.62155 | 2109253.41262 | 37.7724547143562 | -122.391259558193 | (37.7724547143562, -122.391259558193) | 14 | 3 | 9 | 310 | 20 | |||
| 157744 | 197421 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1200 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6015000.43242 | 2109495.8046 | 37.7731163734468 | -122.391519300385 | (37.7731163734468, -122.391519300385) | 14 | 3 | 9 | 310 | 20 | |||
| 159316 | 197423 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1200 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015003.80632 | 2109440.09446 | 37.7729635930298 | -122.391503734027 | (37.7729635930298, -122.391503734027) | 14 | 3 | 9 | 310 | 20 | |||
| 161828 | 197446 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 577 Nelson Rising Ln | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6013697.34857 | 2108075.95156 | 37.7691453611896 | -122.395927352578 | (37.7691453611896, -122.395927352578) | 14 | 3 | 9 | 310 | 20 | |||
| 167371 | 197428 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1200 04th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015013.65902 | 2109278.19684 | 37.7725196049206 | -122.39145833173 | (37.7725196049206, -122.39145833173) | 14 | 3 | 9 | 310 | 20 | |||
| 171946 | 197420 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1200 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6014998.57837 | 2109523.60508 | 37.7731926044861 | -122.391527657797 | (37.7731926044861, -122.391527657797) | 14 | 3 | 9 | 310 | 20 | |||
| 173099 | 197440 | DPW Maintained 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 175 | 1300 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6015037.52027 | 2108824.47635 | 37.7712751131743 | -122.391344069293 | (37.7712751131743, -122.391344069293) | 14 | 3 | 9 | 310 | 20 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );