trees
3,267 rows where qSpecies_id = 67 sorted by Neighborhoods (old) descending
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) ▲ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13010 | 247253 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1118 Waller St | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6000028.37595 | 2108519.10482 | 37.7695922091358 | -122.443239243804 | (37.7695922091358, -122.443239243804) | 15 | 5 | 11 | 29492 | 9 | |||
| 23402 | 105461 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1118 WALLER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6000021.8 | 2108530.5 | 37.7696231224597 | -122.443262808274 | (37.7696231224597, -122.443262808274) | 15 | 5 | 11 | 29492 | 9 | |||
| 24983 | 220898 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 82 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5998243.00011 | 2106881.99825 | 37.7649951626328 | -122.449296801911 | (37.7649951626328, -122.449296801911) | 15 | 5 | 11 | 29492 | 9 | |||
| 26342 | 220895 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 842 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5998713.61111 | 2107159.2684 | 37.7657833842225 | -122.447689044327 | (37.7657833842225, -122.447689044327) | 15 | 5 | 11 | 29492 | 9 | |||
| 27573 | 248415 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 35 Downey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5998794.3313 | 2108066.9818 | 37.7682803489291 | -122.447475194488 | (37.7682803489291, -122.447475194488) | 15 | 5 | 11 | 29492 | 9 | |||
| 29471 | 246937 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 301 Frederick St | 2 | : | Tree | Private 2 | 5 | Width 3ft | 5998522.81883 | 2107568.5127 | 37.7668961594508 | -122.448378425024 | (37.7668961594508, -122.448378425024) | 15 | 5 | 11 | 29492 | 9 | |||
| 32205 | 117522 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 600 ASHBURY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999017 | 2108636 | 37.7698554510238 | -122.446745955589 | (37.7698554510238, -122.446745955589) | 15 | 5 | 11 | 29492 | 9 | ||||
| 36717 | 220874 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 900 Cole St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5998089.60587 | 2107124.4402 | 37.7656520715013 | -122.449844825399 | (37.7656520715013, -122.449844825399) | 15 | 5 | 11 | 29492 | 9 | |||
| 43012 | 247519 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1118 Waller St | 5 | : | Tree | Private 2 | 10 | Width 3ft | 6000008.96236 | 2108515.32213 | 37.7695807157979 | -122.443306122774 | (37.7695807157979, -122.443306122774) | 15 | 5 | 11 | 29492 | 9 | |||
| 47223 | 247252 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1118 Waller St | 2 | : | Tree | Private 2 | 8 | Width 3ft | 6000037.64512 | 2108520.16776 | 37.7695956562448 | -122.443207258529 | (37.7695956562448, -122.443207258529) | 15 | 5 | 11 | 29492 | 9 | |||
| 49094 | 248534 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 796 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999118.3584 | 2107736.2925 | 37.7673908712059 | -122.446330628456 | (37.7673908712059, -122.446330628456) | 15 | 5 | 11 | 29492 | 9 | |||
| 54924 | 220893 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 875 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5998673.41516 | 2107121.2748 | 37.7656767659939 | -122.447825337467 | (37.7656767659939, -122.447825337467) | 15 | 5 | 11 | 29492 | 9 | |||
| 55032 | 105463 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1118 WALLER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6000021.8 | 2108530.5 | 37.7696231224597 | -122.443262808274 | (37.7696231224597, -122.443262808274) | 15 | 5 | 11 | 29492 | 9 | |||
| 61627 | 117524 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 600 ASHBURY ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999017 | 2108636 | 37.7698554510238 | -122.446745955589 | (37.7698554510238, -122.446745955589) | 15 | 5 | 11 | 29492 | 9 | ||||
| 62974 | 246004 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 600 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999001.0122 | 2108580.4285 | 37.7697019524613 | -122.446797257582 | (37.7697019524613, -122.446797257582) | 15 | 5 | 11 | 29492 | 9 | |||
| 64178 | 246005 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 600 Ashbury St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5998995.5612 | 2108615.5567 | 37.7697980941931 | -122.446818640382 | (37.7697980941931, -122.446818640382) | 15 | 5 | 11 | 29492 | 9 | |||
| 64465 | 220873 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 900 Cole St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5998092.16867 | 2107104.06929 | 37.7655962847777 | -122.449834493076 | (37.7655962847777, -122.449834493076) | 15 | 5 | 11 | 29492 | 9 | |||
| 65183 | 222242 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 271 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5998995.31005 | 2106564.88538 | 37.7641674535783 | -122.44667194168 | (37.7641674535783, -122.44667194168) | 15 | 5 | 11 | 29492 | 9 | |||
| 67704 | 222244 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 289 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5999005.34816 | 2106504.31101 | 37.764001704947 | -122.446632864339 | (37.764001704947, -122.446632864339) | 15 | 5 | 11 | 29492 | 9 | |||
| 68238 | 246044 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1436 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5998822.9487 | 2108347.553 | 37.7690523616862 | -122.447396407227 | (37.7690523616862, -122.447396407227) | 15 | 5 | 11 | 29492 | 9 | |||
| 69808 | 34848 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 792 Ashbury St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38469 | 5999123.37842574 | 2107737.2945324 | 37.7673939092406 | -122.446313337038 | (37.7673939092406, -122.446313337038) | 15 | 5 | 11 | 29492 | 9 | ||||
| 73544 | 220887 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 58 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 5998263.6114 | 2106253.00585 | 37.7632692871588 | -122.449180194907 | (37.7632692871588, -122.449180194907) | 15 | 5 | 11 | 29492 | 9 | |||
| 74501 | 248406 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 720 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5999070.2086 | 2108091.511 | 37.7683634614335 | -122.446522730247 | (37.7683634614335, -122.446522730247) | 15 | 5 | 11 | 29492 | 9 | |||
| 77521 | 106628 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 875 CLAYTON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6x12 | 5998657.7 | 2107117.8 | 37.7656663268312 | -122.447879442364 | (37.7656663268312, -122.447879442364) | 15 | 5 | 11 | 29492 | 9 | |||
| 79286 | 220886 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 24 Alma St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5998451.22769 | 2106279.65937 | 37.7633532002161 | -122.448533214546 | (37.7633532002161, -122.448533214546) | 15 | 5 | 11 | 29492 | 9 | |||
| 79620 | 247251 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1118 Waller St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6000047.76346 | 2108521.63198 | 37.7696002535789 | -122.443172364836 | (37.7696002535789, -122.443172364836) | 15 | 5 | 11 | 29492 | 9 | |||
| 81899 | 248460 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 739 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5997585.8919 | 2107964.6256 | 37.7679301729738 | -122.451647664261 | (37.7679301729738, -122.451647664261) | 15 | 5 | 11 | 29492 | 9 | |||
| 86730 | 94495 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 739 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5x5 | 5997569.2 | 2107955.8 | 37.7679049841939 | -122.451704762646 | (37.7679049841939, -122.451704762646) | 15 | 5 | 11 | 29492 | 9 | ||||
| 88079 | 220875 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 760 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5997994.43805 | 2107794.59906 | 37.767486711866 | -122.450222298733 | (37.767486711866, -122.450222298733) | 15 | 5 | 11 | 29492 | 9 | |||
| 88592 | 220872 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 900 Cole St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5998095.72246 | 2107084.68783 | 37.7655432715313 | -122.449820804483 | (37.7655432715313, -122.449820804483) | 15 | 5 | 11 | 29492 | 9 | |||
| 89034 | 222243 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 275 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 5998998.37555 | 2106545.13265 | 37.764113392645 | -122.446659917739 | (37.764113392645, -122.446659917739) | 15 | 5 | 11 | 29492 | 9 | |||
| 89872 | 248380 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 718 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5999066.5747 | 2108111.1949 | 37.7684173008846 | -122.44653671586 | (37.7684173008846, -122.44653671586) | 15 | 5 | 11 | 29492 | 9 | |||
| 92303 | 222451 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 133 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002793.08079 | 2109034.20359 | 37.7711638049878 | -122.433713058133 | (37.7711638049878, -122.433713058133) | 15 | 5 | 11 | 29492 | 9 | |||
| 95443 | 222249 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 237 Rivoli St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5997618.03271 | 2105883.54007 | 37.7622178816623 | -122.451386378488 | (37.7622178816623, -122.451386378488) | 15 | 5 | 11 | 29492 | 9 | |||
| 96899 | 220889 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4612 17th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 3ft | 5998837.5301 | 2105719.51666 | 37.7618372687888 | -122.447156811134 | (37.7618372687888, -122.447156811134) | 15 | 5 | 11 | 29492 | 9 | |||
| 99654 | 220899 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 228 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5998994.27809 | 2106827.83815 | 37.7648893969392 | -122.446694431926 | (37.7648893969392, -122.446694431926) | 15 | 5 | 11 | 29492 | 9 | |||
| 105412 | 244920 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 144 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999925.414 | 2108914.4358 | 37.7706718168219 | -122.443623787984 | (37.7706718168219, -122.443623787984) | 15 | 5 | 11 | 29492 | 9 | |||
| 105454 | 248450 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 135 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5998240.9112 | 2107988.0949 | 37.7680321040864 | -122.449383727922 | (37.7680321040864, -122.449383727922) | 15 | 5 | 11 | 29492 | 9 | |||
| 108411 | 248414 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 35 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5998792.5143 | 2108086.0601 | 37.7683326292736 | -122.447482852718 | (37.7683326292736, -122.447482852718) | 15 | 5 | 11 | 29492 | 9 | |||
| 110646 | 222241 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 233 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 8ft | 5998966.85678 | 2106784.6526 | 37.7647692538279 | -122.446786167251 | (37.7647692538279, -122.446786167251) | 15 | 5 | 11 | 29492 | 9 | |||
| 115757 | 220883 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 599 Belvedere St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5998628.05066 | 2105740.47069 | 37.7618828320382 | -122.447882823036 | (37.7618828320382, -122.447882823036) | 15 | 5 | 11 | 29492 | 9 | |||
| 116881 | 247672 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 170 Divisadero St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 7ft | 6001935.423 | 2108631.33327 | 37.7700089198994 | -122.436650881551 | (37.7700089198994, -122.436650881551) | 15 | 5 | 5 | 29492 | 9 | |||
| 117210 | 220878 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 544 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5998629.08677 | 2106013.62954 | 37.7626329169992 | -122.447898906506 | (37.7626329169992, -122.447898906506) | 15 | 5 | 11 | 29492 | 9 | |||
| 119380 | 220891 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 93 Carl St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5998136.73707 | 2107165.08525 | 37.7657663690514 | -122.449684738853 | (37.7657663690514, -122.449684738853) | 15 | 5 | 11 | 29492 | 9 | |||
| 121394 | 244125 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 514 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5998476.0616 | 2108868.3149 | 37.7704624126065 | -122.448633775108 | (37.7704624126065, -122.448633775108) | 15 | 5 | 11 | 29492 | 9 | |||
| 124354 | 247254 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1118 Waller St | 4 | : | Tree | Private 2 | 9 | Width 3ft | 6000018.05631 | 2108518.06338 | 37.7695887611508 | -122.443274864147 | (37.7695887611508, -122.443274864147) | 15 | 5 | 11 | 29492 | 9 | |||
| 127836 | 248577 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 290 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5998686.2213 | 2107637.5702 | 37.767095114717 | -122.447818216713 | (37.767095114717, -122.447818216713) | 15 | 5 | 11 | 29492 | 9 | |||
| 133745 | 222245 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 89 Piedmont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5999307.74196 | 2106940.79815 | 37.7652174579546 | -122.445618367913 | (37.7652174579546, -122.445618367913) | 15 | 5 | 5 | 29492 | 9 | |||
| 133914 | 220880 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 599 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5998621.01938 | 2105800.60496 | 37.7620475437804 | -122.447911470946 | (37.7620475437804, -122.447911470946) | 15 | 5 | 11 | 29492 | 9 | |||
| 134087 | 222248 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 237 Rivoli St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5997599.93601 | 2105878.45194 | 37.7622028746887 | -122.451448600799 | (37.7622028746887, -122.451448600799) | 15 | 5 | 11 | 29492 | 9 | |||
| 135274 | 222238 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1022 Stanyan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5997287.2431 | 2106942.28914 | 37.7651059905631 | -122.452606861018 | (37.7651059905631, -122.452606861018) | 15 | 5 | 11 | 29492 | 9 | |||
| 137707 | 220897 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 82 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5998259.10547 | 2106883.17365 | 37.7649993111948 | -122.44924118243 | (37.7649993111948, -122.44924118243) | 15 | 5 | 11 | 29492 | 9 | |||
| 138590 | 113558 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 544 BELVEDERE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998649 | 2106025 | 37.7626652756279 | -122.447830852725 | (37.7626652756279, -122.447830852725) | 15 | 5 | 11 | 29492 | 9 | ||||
| 139253 | 117523 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 600 ASHBURY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999017 | 2108636 | 37.7698554510238 | -122.446745955589 | (37.7698554510238, -122.446745955589) | 15 | 5 | 11 | 29492 | 9 | ||||
| 139902 | 248517 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 790 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999112.6047 | 2107775.9631 | 37.7674994680579 | -122.446353383792 | (37.7674994680579, -122.446353383792) | 15 | 5 | 11 | 29492 | 9 | |||
| 142188 | 34847 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 792 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38469 | 5999123.37842574 | 2107737.2945324 | 37.7673939092406 | -122.446313337038 | (37.7673939092406, -122.446313337038) | 15 | 5 | 11 | 29492 | 9 | ||||
| 143095 | 220882 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 599 Belvedere St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5998626.62137 | 2105762.24598 | 37.7619425398344 | -122.44788933414 | (37.7619425398344, -122.44788933414) | 15 | 5 | 11 | 29492 | 9 | |||
| 145394 | 220900 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 171 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5999402.83892 | 2107200.75786 | 37.7659366709693 | -122.445308144057 | (37.7659366709693, -122.445308144057) | 15 | 5 | 5 | 29492 | 9 | |||
| 146319 | 220884 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 599 Belvedere St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5998629.92625 | 2105722.06035 | 37.7618323890607 | -122.447875010642 | (37.7618323890607, -122.447875010642) | 15 | 5 | 11 | 29492 | 9 | |||
| 147202 | 105462 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1118 WALLER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6000021.8 | 2108530.5 | 37.7696231224597 | -122.443262808274 | (37.7696231224597, -122.443262808274) | 15 | 5 | 11 | 29492 | 9 | |||
| 150920 | 222239 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1022 Stanyan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5997289.37279 | 2106934.09863 | 37.7650836235347 | -122.452598903829 | (37.7650836235347, -122.452598903829) | 15 | 5 | 11 | 29492 | 9 | |||
| 153864 | 105459 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1118 WALLER ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6000021.8 | 2108530.5 | 37.7696231224597 | -122.443262808274 | (37.7696231224597, -122.443262808274) | 15 | 5 | 11 | 29492 | 9 | |||
| 154700 | 113559 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 544 BELVEDERE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998649 | 2106025 | 37.7626652756279 | -122.447830852725 | (37.7626652756279, -122.447830852725) | 15 | 5 | 11 | 29492 | 9 | ||||
| 155109 | 222240 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1022 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5997291.73168 | 2106924.63054 | 37.7650577617289 | -122.452590061694 | (37.7650577617289, -122.452590061694) | 15 | 5 | 11 | 29492 | 9 | |||
| 155588 | 220890 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 93 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5998113.20124 | 2107162.18766 | 37.7657570664623 | -122.449765935051 | (37.7657570664623, -122.449765935051) | 15 | 5 | 11 | 29492 | 9 | |||
| 158122 | 248381 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 718 Ashbury St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5999065.969 | 2108130.2731 | 37.7684696502024 | -122.446540183672 | (37.7684696502024, -122.446540183672) | 15 | 5 | 11 | 29492 | 9 | |||
| 158305 | 247753 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 44 Alpine Ter | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6001606.77879 | 2108574.48461 | 37.7698341456641 | -122.437783582143 | (37.7698341456641, -122.437783582143) | 15 | 5 | 5 | 29492 | 9 | |||
| 160283 | 244977 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 764 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6002915.0321 | 2109610.1017 | 37.7727519983539 | -122.433332383132 | (37.7727519983539, -122.433332383132) | 15 | 5 | 11 | 29492 | 9 | |||
| 163735 | 220870 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1305 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2014 12:00:00 AM | 1 | Width 4ft | Permit Number 771153 | 5998204.34931 | 2105944.91927 | 37.762419969235 | -122.449362963227 | (37.762419969235, -122.449362963227) | 15 | 5 | 11 | 29492 | 9 | |
| 166132 | 105460 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1118 WALLER ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6000021.8 | 2108530.5 | 37.7696231224597 | -122.443262808274 | (37.7696231224597, -122.443262808274) | 15 | 5 | 11 | 29492 | 9 | |||
| 166640 | 222247 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 265 Rivoli St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5997490.54215 | 2105867.3732 | 37.7621661904447 | -122.451826151455 | (37.7621661904447, -122.451826151455) | 15 | 5 | 11 | 29492 | 9 | |||
| 169447 | 247695 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 50 Central Ave | 2 | : | Tree | Private 2 | 6 | Width 3ft | 5999979.23334 | 2108546.51702 | 37.7696646738092 | -122.443411195087 | (37.7696646738092, -122.443411195087) | 15 | 5 | 11 | 29492 | 9 | |||
| 170565 | 220879 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 544 Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 5998626.82623 | 2106030.80917 | 37.7626799587438 | -122.44790796179 | (37.7626799587438, -122.44790796179) | 15 | 5 | 11 | 29492 | 9 | |||
| 171601 | 222246 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1149 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 5997700.29974 | 2106538.60043 | 37.7640212220263 | -122.451149091478 | (37.7640212220263, -122.451149091478) | 15 | 5 | 11 | 29492 | 9 | |||
| 172157 | 220894 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 875 Clayton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5998674.85222 | 2107109.73211 | 37.7656451548159 | -122.447819535949 | (37.7656451548159, -122.447819535949) | 15 | 5 | 11 | 29492 | 9 | |||
| 172422 | 220869 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 120 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5998060.25576 | 2106223.73939 | 37.7631772955295 | -122.44988142239 | (37.7631772955295, -122.44988142239) | 15 | 5 | 11 | 29492 | 9 | |||
| 173576 | 220896 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 840 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5998710.10383 | 2107190.14847 | 37.765867972655 | -122.447703398415 | (37.765867972655, -122.447703398415) | 15 | 5 | 11 | 29492 | 9 | |||
| 174339 | 220892 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 51 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5998361.96951 | 2107197.9995 | 37.7658696265013 | -122.448908082538 | (37.7658696265013, -122.448908082538) | 15 | 5 | 11 | 29492 | 9 | |||
| 174757 | 244915 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 148 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5999914.503 | 2108981.3249 | 37.7708548551283 | -122.443666335172 | (37.7708548551283, -122.443666335172) | 15 | 5 | 11 | 29492 | 9 | |||
| 176399 | 10345 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 954 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6001545.3048 | 2109077.8189 | 37.7712126807777 | -122.43803227825 | (37.7712126807777, -122.43803227825) | 15 | 5 | 11 | 29492 | 9 | |||
| 180836 | 220888 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4612 17th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5998844.92581 | 2105719.65722 | 37.7618380772979 | -122.447131242526 | (37.7618380772979, -122.447131242526) | 15 | 5 | 11 | 29492 | 9 | |||
| 181250 | 222237 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1022 Stanyan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5997285.6403 | 2106951.23247 | 37.7651304548321 | -122.452613050173 | (37.7651304548321, -122.452613050173) | 15 | 5 | 11 | 29492 | 9 | |||
| 182727 | 247694 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 50 Central Ave | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5999980.3823 | 2108534.68823 | 37.769632260448 | -122.443406371107 | (37.769632260448, -122.443406371107) | 15 | 5 | 11 | 29492 | 9 | |||
| 187171 | 220881 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 599 Belvedere St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5998623.62427 | 2105781.05469 | 37.76199401253 | -122.447901054088 | (37.76199401253, -122.447901054088) | 15 | 5 | 11 | 29492 | 9 | |||
| 190497 | 248361 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 709 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5999005.2518 | 2108246.1052 | 37.7687842275564 | -122.446758533868 | (37.7687842275564, -122.446758533868) | 15 | 5 | 11 | 29492 | 9 | |||
| 190523 | 248601 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 462 Frederick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5997503.371 | 2107472.2255 | 37.766573441884 | -122.451897565692 | (37.766573441884, -122.451897565692) | 15 | 5 | 11 | 29492 | 9 | |||
| 192697 | 246006 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 600 Ashbury St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5998992.533 | 2108633.4236 | 37.7698469791765 | -122.446830400622 | (37.7698469791765, -122.446830400622) | 15 | 5 | 11 | 29492 | 9 | |||
| 193204 | 248558 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 169 Beulah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5997302.141 | 2107744.3175 | 37.7673090091983 | -122.452613219954 | (37.7673090091983, -122.452613219954) | 15 | 5 | 11 | 29492 | 9 | |||
| 193645 | 245947 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1 Beulah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5997917.0355 | 2107832.895 | 37.7675874329446 | -122.450492783652 | (37.7675874329446, -122.450492783652) | 15 | 5 | 11 | 29492 | 9 | |||
| 10430 | 220973 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 200 Berkeley Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6000866.47877 | 2097867.45006 | 37.7403931018698 | -122.439576579423 | (37.7403931018698, -122.439576579423) | 2 | 7 | 5 | 63 | 7 | |||
| 12005 | 222475 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1712 Sanchez St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 3ft | 6003947.79258 | 2098269.9182 | 37.7416730781499 | -122.428951298963 | (37.7416730781499, -122.428951298963) | 2 | 7 | 5 | 63 | 7 | |||
| 12669 | 222494 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 21 Harry St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 2ft | 6003368.61725 | 2097750.91511 | 37.7402152150692 | -122.430916860842 | (37.7402152150692, -122.430916860842) | 2 | 7 | 5 | 63 | 7 | |||
| 15665 | 222485 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 45 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002560.02403 | 2096411.24476 | 37.7364909407996 | -122.433616928699 | (37.7364909407996, -122.433616928699) | 2 | 7 | 5 | 63 | 7 | |||
| 18314 | 204568 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 61 Burnside Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6001187.03477 | 2095752.39336 | 37.7346038888419 | -122.438316738047 | (37.7346038888419, -122.438316738047) | 2 | 7 | 5 | 63 | 7 | ||||
| 19054 | 261690 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 181 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004415 | 2097502 | 37.7395909842107 | -122.427281162901 | (37.7395909842107, -122.427281162901) | 2 | 7 | 5 | 63 | 7 | ||||
| 19821 | 4865 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 32 Crags Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/14/1992 12:00:00 AM | 35 | 3X3 | 6000909.0364823 | 2098039.6345395 | 37.7408683019977 | -122.439441771578 | (37.7408683019977, -122.439441771578) | 2 | 7 | 5 | 63 | 7 | ||
| 21490 | 222211 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 998 Chenery St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001126.04303 | 2096135.59352 | 37.7356525981802 | -122.43855505387 | (37.7356525981802, -122.43855505387) | 2 | 7 | 5 | 63 | 7 | |||
| 21698 | 222228 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5735 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 6000718.4413 | 2097027.59574 | 37.7380786327218 | -122.440028227017 | (37.7380786327218, -122.440028227017) | 2 | 7 | 5 | 63 | 7 | |||
| 22190 | 222467 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 222 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6004131.97597 | 2097627.84522 | 37.7399205162221 | -122.428268704549 | (37.7399205162221, -122.428268704549) | 2 | 7 | 5 | 63 | 7 | |||
| 22832 | 4862 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 22 Crags Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 3x3 | 6000700.354 | 2098195.46944 | 37.7412843093321 | -122.440174488273 | (37.7412843093321, -122.440174488273) | 2 | 7 | 5 | 63 | 7 |
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) );