Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID ▲ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1162 | 1162 | 251437 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3377 Market St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5999965.0 | 2104239.0 | 37.7578364910366 | -122.443151017453 | (37.7578364910366, -122.443151017453) | ||||
| 41989 | 41989 | 251049 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5700x Geary Blvd | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 10ft | 5989182.8738 | 2112626.0902 | 37.7802444522785 | -122.481053773582 | (37.7802444522785, -122.481053773582) | |||
| 178472 | 178472 | 251037 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5317x Geary Blvd | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5990398.0172 | 2112670.1794 | 37.780436072061896 | -122.476853300249 | (37.7804360720619, -122.476853300249) | |||
| 158594 | 158594 | 251036 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5317x Geary Blvd | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5990401.2433 | 2112674.4808 | 37.780448069653296 | -122.47684245414699 | (37.7804480696533, -122.476842454147) | |||
| 162132 | 162132 | 250852 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 237 30th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5986481.270409999 | 2114308.8820599997 | 37.7847074978842 | -122.490523574402 | (37.7847074978842, -122.490523574402) | |||
| 64821 | 64821 | 250792 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 290 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5985918.61873 | 2113977.26033 | 37.7837640802965 | -122.492445705309 | (37.7837640802965, -122.492445705309) | |||
| 24071 | 24071 | 250790 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 284 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5985915.81821 | 2114007.58209 | 37.7838471713633 | -122.49245762762101 | (37.7838471713633, -122.492457627621) | |||
| 161089 | 161089 | 250788 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 281 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5985872.14911 | 2114023.45685 | 37.7838882056181 | -122.492609873852 | (37.7838882056181, -122.492609873852) | |||
| 54070 | 54070 | 250786 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 276 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5985914.65421 | 2114070.62696 | 37.7840202063211 | -122.49246629890101 | (37.7840202063211, -122.492466298901) | |||
| 48618 | 48618 | 250784 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 266 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5985911.86598 | 2114116.23526 | 37.784145270524604 | -122.49247930488501 | (37.7841452705246, -122.492479304885) | |||
| 150150 | 150150 | 250783 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 273 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5985872.78396 | 2114090.54911 | 37.7840724587071 | -122.492612620392 | (37.7840724587071, -122.492612620392) | |||
| 49844 | 49844 | 250781 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 267 32nd Ave | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5985871.01478 | 2114139.87947 | 37.784207802179296 | -122.49262237534599 | (37.7842078021793, -122.492622375346) | |||
| 45724 | 45724 | 250780 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 267 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5985869.60841 | 2114147.39692 | 37.7842283606933 | -122.49262779465401 | (37.7842283606933, -122.492627794654) | |||
| 158740 | 158740 | 250775 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 254 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5985910.66114 | 2114192.0713299997 | 37.7843534240234 | -122.49248905984699 | (37.7843534240234, -122.492489059847) | |||
| 51145 | 51145 | 250738 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2801 Lake St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5986770.52108 | 2114418.70237 | 37.7850259235546 | -122.489530954893 | (37.7850259235546, -122.489530954893) | |||
| 165677 | 165677 | 250737 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2801 Lake St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5986760.11257 | 2114418.92368 | 37.785025923553206 | -122.48956698083201 | (37.7850259235532, -122.489566980832) | |||
| 69657 | 69657 | 250736 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2801 Lake St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5986749.69109 | 2114418.5354 | 37.7850242490246 | -122.48960300679899 | (37.7850242490246, -122.489603006799) | |||
| 66504 | 66504 | 250735 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2801 Lake St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5986736.846390001 | 2114419.4183900002 | 37.785025923551295 | -122.48964750974301 | (37.7850259235513, -122.489647509743) | |||
| 57656 | 57656 | 250734 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2801 Lake St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5986725.81276 | 2114419.04313 | 37.7850242490072 | -122.489685654482 | (37.7850242490072, -122.489685654482) | |||
| 171228 | 171228 | 250733 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2801 Lake St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5986711.11836 | 2114419.3556 | 37.7850242490222 | -122.489736514746 | (37.7850242490222, -122.489736514746) | |||
| 166394 | 166394 | 250229 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 312 Filbert St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | Width 0ft | 6011206.629819999 | 2120043.6184099996 | 37.8018668665295 | -122.405385582777 | (37.8018668665295, -122.405385582777) | |||
| 67816 | 67816 | 250228 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 312 Filbert St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | Width 0ft | 6011211.1715400005 | 2120049.4002099996 | 37.8018829958704 | -122.40537027363101 | (37.8018829958704, -122.405370273631) | |||
| 172111 | 172111 | 250226 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 312 Filbert St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | Width 0ft | 6011217.042090001 | 2120062.49723 | 37.8019192853099 | -122.405350881537 | (37.8019192853099, -122.405350881537) | |||
| 69791 | 69791 | 250225 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 312 Filbert St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | Width 0ft | 6011230.02021 | 2120062.52676 | 37.8019200919915 | -122.40530597298701 | (37.8019200919915, -122.405305972987) | |||
| 165572 | 165572 | 250224 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 312 Filbert St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | Width 0ft | 6011221.34302 | 2120070.92711 | 37.8019426721638 | -122.405336592216 | (37.8019426721638, -122.405336592216) | |||
| 166321 | 166321 | 250223 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 312 Filbert St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | Width 0ft | 6011234.32087 | 2120070.9566599997 | 37.80194347887979 | -122.405291684587 | (37.8019434788798, -122.405291684587) | |||
| 157703 | 157703 | 250210 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 212 Union St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 0ft | 6011753.31095 | 2119788.98637 | 37.8011982592529 | -122.40347587511101 | (37.8011982592529, -122.403475875111) | |||
| 173590 | 173590 | 250208 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 212 Union St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 0ft | 6011783.4083 | 2119794.63457 | 37.8012154488822 | -122.403372122131 | (37.8012154488822, -122.403372122131) | |||
| 41959 | 41959 | 250203 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 203 Union St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | Width 0ft | 6011748.4940599995 | 2119742.37279 | 37.8010700006395 | -122.403489262419 | (37.8010700006395, -122.403489262419) | |||
| 32444 | 32444 | 250071 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1520 Gough St | 3 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 6005405.66402 | 2115050.94063 | 37.787832188740396 | -122.425104206101 | (37.7878321887404, -122.425104206101) | |||
| 32458 | 32458 | 250060 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1300 Sutter St | 6 | : 4 | Tree 1 | Private 1 | 2 | Width 1ft | 6006175.05227 | 2114929.06733 | 37.787540987376396 | -122.422433599133 | (37.7875409873764, -122.422433599133) | |||
| 68690 | 68690 | 250059 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1301 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6006282.17067 | 2114892.3445900003 | 37.787446197933996 | -122.42206038048799 | (37.787446197934, -122.422060380488) | |||
| 45850 | 45850 | 248601 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 462 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997503.371 | 2107472.2255 | 37.766573441884 | -122.45189756569201 | (37.766573441884, -122.451897565692) | |||
| 181774 | 181774 | 248577 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 290 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5998686.2213 | 2107637.5702 | 37.767095114717 | -122.447818216713 | (37.767095114717, -122.447818216713) | |||
| 154210 | 154210 | 248558 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 169 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997302.141 | 2107744.3175 | 37.7673090091983 | -122.45261321995399 | (37.7673090091983, -122.452613219954) | |||
| 183712 | 183712 | 248534 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 796 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999118.3584 | 2107736.2925 | 37.7673908712059 | -122.446330628456 | (37.7673908712059, -122.446330628456) | |||
| 33812 | 33812 | 248517 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 790 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999112.6047 | 2107775.9631 | 37.7674994680579 | -122.446353383792 | (37.7674994680579, -122.446353383792) | |||
| 183491 | 183491 | 248460 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 739 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5997585.8919 | 2107964.6256 | 37.76793017297379 | -122.451647664261 | (37.7679301729738, -122.451647664261) | |||
| 41676 | 41676 | 248450 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 135 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5998240.9112 | 2107988.0949 | 37.7680321040864 | -122.449383727922 | (37.7680321040864, -122.449383727922) | |||
| 177048 | 177048 | 248415 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 35 Downey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998794.3313 | 2108066.9818 | 37.7682803489291 | -122.44747519448799 | (37.7682803489291, -122.447475194488) | |||
| 44528 | 44528 | 248414 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 35 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998792.5143 | 2108086.0601 | 37.7683326292736 | -122.447482852718 | (37.7683326292736, -122.447482852718) | |||
| 74147 | 74147 | 248406 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 720 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5999070.2086 | 2108091.511 | 37.7683634614335 | -122.446522730247 | (37.7683634614335, -122.446522730247) | |||
| 180079 | 180079 | 248381 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 718 Ashbury St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5999065.969 | 2108130.2731 | 37.7684696502024 | -122.44654018367201 | (37.7684696502024, -122.446540183672) | |||
| 155092 | 155092 | 248380 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 718 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5999066.5747 | 2108111.1949 | 37.7684173008846 | -122.44653671586 | (37.7684173008846, -122.44653671586) | |||
| 168671 | 168671 | 248361 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 709 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5999005.2518 | 2108246.1052 | 37.7687842275564 | -122.446758533868 | (37.7687842275564, -122.446758533868) | |||
| 68700 | 68700 | 248280 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 105 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006841.61034 | 2098924.32173 | 37.743633298045296 | -122.418991828932 | (37.7436332980453, -122.418991828932) | |||
| 161424 | 161424 | 248143 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 51 Massasoit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009914.12622 | 2099368.67535 | 37.745025933311 | -122.408399106651 | (37.745025933311, -122.408399106651) | |||
| 57450 | 57450 | 247885 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 387 Mayflower St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6009895.877069999 | 2098407.02536 | 37.7423844301873 | -122.408394391499 | (37.7423844301873, -122.408394391499) | ||||
| 67351 | 67351 | 247884 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 387 Mayflower St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6009916.04567 | 2098399.5551400003 | 37.7423650480079 | -122.408324127476 | (37.7423650480079, -122.408324127476) | ||||
| 184037 | 184037 | 247875 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 388 Mayflower St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6009902.15427 | 2098392.46906 | 37.742344813273604 | -122.408371660244 | (37.7423448132736, -122.408371660244) | ||||
| 40885 | 40885 | 247753 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 44 Alpine Ter | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6001606.77879 | 2108574.4846099997 | 37.7698341456641 | -122.437783582143 | (37.7698341456641, -122.437783582143) | |||
| 76511 | 76511 | 247695 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 50 Central Ave | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5999979.23334 | 2108546.51702 | 37.7696646738092 | -122.443411195087 | (37.7696646738092, -122.443411195087) | |||
| 73691 | 73691 | 247694 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 50 Central Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5999980.3823 | 2108534.68823 | 37.769632260448 | -122.443406371107 | (37.769632260448, -122.443406371107) | |||
| 63142 | 63142 | 247672 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 170 Divisadero St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 7ft | 6001935.4229999995 | 2108631.3332700003 | 37.7700089198994 | -122.436650881551 | (37.7700089198994, -122.436650881551) | |||
| 174610 | 174610 | 247636 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 336 Bradford St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 5ft | 6009466.72308 | 2096666.2526099999 | 37.737580604353 | -122.409755436259 | (37.737580604353, -122.409755436259) | |||
| 156283 | 156283 | 247519 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1118 Waller St | 5 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6000008.96236 | 2108515.3221299998 | 37.76958071579789 | -122.44330612277399 | (37.7695807157979, -122.443306122774) | |||
| 160263 | 160263 | 247254 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1118 Waller St | 4 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6000018.05631 | 2108518.0633799997 | 37.7695887611508 | -122.443274864147 | (37.7695887611508, -122.443274864147) | |||
| 60767 | 60767 | 247253 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1118 Waller St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6000028.37595 | 2108519.10482 | 37.769592209135794 | -122.443239243804 | (37.7695922091358, -122.443239243804) | |||
| 45196 | 45196 | 247252 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1118 Waller St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6000037.64512 | 2108520.1677599996 | 37.769595656244796 | -122.443207258529 | (37.7695956562448, -122.443207258529) | |||
| 134269 | 134269 | 247251 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1118 Waller St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6000047.76346 | 2108521.63198 | 37.76960025357889 | -122.443172364836 | (37.7696002535789, -122.443172364836) | |||
| 181918 | 181918 | 247054 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 501 Valley St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6002623.07266 | 2099147.1540099997 | 37.74400669115239 | -122.433594410547 | (37.7440066911524, -122.433594410547) | |||
| 68136 | 68136 | 247052 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 515 Valley St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6002551.0292 | 2099143.14982 | 37.743991608620604 | -122.433843234102 | (37.7439916086206, -122.433843234102) | |||
| 72445 | 72445 | 247048 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 537 Valley St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6002432.31725 | 2099137.61339 | 37.7439696696596 | -122.434253316852 | (37.7439696696596, -122.434253316852) | |||
| 162062 | 162062 | 247047 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 537 Valley St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6002401.43844 | 2099135.75495 | 37.7439628141295 | -122.434359955762 | (37.7439628141295, -122.434359955762) | |||
| 119847 | 119847 | 247015 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 500 Valley St | 7 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6002564.17564 | 2099179.51077 | 37.744092193305605 | -122.4338003751 | (37.7440921933056, -122.4338003751) | |||
| 168810 | 168810 | 247014 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 500 Valley St | 5 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6002586.52325 | 2099180.42423 | 37.7440959695517 | -122.433723167391 | (37.7440959695517, -122.433723167391) | |||
| 51147 | 51147 | 247013 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 500 Valley St | 3 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6002616.04169 | 2099183.02337 | 37.744104781107296 | -122.433621285011 | (37.7441047811073, -122.433621285011) | |||
| 39127 | 39127 | 247002 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 401 Valley St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | Width 8ft | 6003223.72191 | 2099183.9093400002 | 37.7441416748926 | -122.431520126078 | (37.7441416748926, -122.431520126078) | |||
| 132451 | 132451 | 246937 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 301 Frederick St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5998522.81883 | 2107568.5127 | 37.766896159450795 | -122.44837842502399 | (37.7668961594508, -122.448378425024) | |||
| 177055 | 177055 | 246737 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 139 Ripley St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6008835.51496 | 2099113.48937 | 37.7442647875829 | -122.412110733722 | (37.7442647875829, -122.412110733722) | |||
| 51794 | 51794 | 246728 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 101 Ripley St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 8ft | 6008612.87637 | 2099109.67638 | 37.7442418234114 | -122.412880303405 | (37.7442418234114, -122.412880303405) | |||
| 149876 | 149876 | 246515 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 73 Waller St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6005379.43616 | 2109216.9745400003 | 37.7718120669155 | -122.424779754098 | (37.7718120669155, -122.424779754098) | |||
| 178070 | 178070 | 246485 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 342 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6004030.8329300005 | 2099862.05053 | 37.7460494067509 | -122.42877764797599 | (37.7460494067509, -122.428777647976) | |||
| 65747 | 65747 | 246468 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 250 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6004863.38148 | 2099908.9241400003 | 37.746225196330705 | -122.425902138566 | (37.7462251963307, -122.425902138566) | |||
| 185701 | 185701 | 246440 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 485 Duncan St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6003368.11948 | 2099777.56573 | 37.745779900623 | -122.431063194026 | (37.745779900623, -122.431063194026) | ||||
| 133731 | 133731 | 246044 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1436 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5998822.9487 | 2108347.5530000003 | 37.7690523616862 | -122.447396407227 | (37.7690523616862, -122.447396407227) | |||
| 3006 | 3006 | 246006 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 600 Ashbury St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998992.533 | 2108633.4236 | 37.7698469791765 | -122.446830400622 | (37.7698469791765, -122.446830400622) | |||
| 3004 | 3004 | 246005 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 600 Ashbury St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998995.5612 | 2108615.5567 | 37.7697980941931 | -122.446818640382 | (37.7697980941931, -122.446818640382) | |||
| 2935 | 2935 | 246004 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 600 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999001.0122 | 2108580.4285 | 37.7697019524613 | -122.44679725758199 | (37.7697019524613, -122.446797257582) | |||
| 184982 | 184982 | 245985 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4230 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6001857.8935 | 2105297.335 | 37.7608501726 | -122.43668036860599 | (37.7608501726, -122.436680368606) | |||
| 37815 | 37815 | 245947 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5997917.0355 | 2107832.895 | 37.7675874329446 | -122.450492783652 | (37.7675874329446, -122.450492783652) | |||
| 75367 | 75367 | 245856 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 350 Laguna St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6005110.9888 | 2110189.241 | 37.7744665092384 | -122.42577754820499 | (37.7744665092384, -122.425777548205) | |||
| 59052 | 59052 | 245853 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 350 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6005116.9518 | 2110112.3844 | 37.7742558166581 | -122.42575144947399 | (37.7742558166581, -122.425751449474) | |||
| 151272 | 151272 | 244977 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 764 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6002915.0321 | 2109610.1017 | 37.7727519983539 | -122.433332383132 | (37.7727519983539, -122.433332383132) | |||
| 56904 | 56904 | 244920 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 144 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999925.414 | 2108914.4358 | 37.7706718168219 | -122.44362378798401 | (37.7706718168219, -122.443623787984) | |||
| 133464 | 133464 | 244915 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 148 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5999914.503 | 2108981.3249 | 37.7708548551283 | -122.44366633517201 | (37.7708548551283, -122.443666335172) | |||
| 185973 | 185973 | 244125 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 514 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5998476.0616 | 2108868.3149 | 37.7704624126065 | -122.448633775108 | (37.7704624126065, -122.448633775108) | |||
| 63 | 63 | 222541 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1 Newburg St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | Permit Number 779491 | 6002580.9472199995 | 2099999.66602 | 37.7463450993615 | -122.433800991143 | (37.7463450993615, -122.433800991143) | ||
| 176202 | 176202 | 222498 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 749 Dolores St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 8ft | 6005048.62848 | 2104037.34369 | 37.7575713454444 | -122.42555534471799 | (37.7575713454444, -122.425555344718) | |||
| 178974 | 178974 | 222497 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 220 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004983.22984 | 2100204.50864 | 37.747043575808604 | -122.425508749931 | (37.7470435758086, -122.425508749931) | |||
| 57529 | 57529 | 222496 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 46 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006343.14991 | 2109555.3780400003 | 37.772795625748294 | -122.42147023457 | (37.7727956257483, -122.42147023457) | |||
| 39274 | 39274 | 222495 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 21 Harry St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6003377.3850300005 | 2097755.83349 | 37.740229216595104 | -122.43088689632401 | (37.7402292165951, -122.430886896324) | |||
| 45562 | 45562 | 222494 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 21 Harry St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 2ft | 6003368.61725 | 2097750.91511 | 37.740215215069206 | -122.430916860842 | (37.7402152150692, -122.430916860842) | |||
| 73381 | 73381 | 222493 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 265 Beacon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6002922.33421 | 2097866.2662400003 | 37.7405066457633 | -122.432468163499 | (37.7405066457633, -122.432468163499) | |||
| 23641 | 23641 | 222492 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 265 Beacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6002907.41416 | 2097886.83375 | 37.740562273319505 | -122.43252121989599 | (37.7405622733195, -122.432521219896) | |||
| 109375 | 109375 | 222491 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 270 Beacon St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 2ft | 6002967.78522 | 2097861.36319 | 37.7404957603754 | -122.432310661632 | (37.7404957603754, -122.432310661632) | |||
| 71133 | 71133 | 222490 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 235 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6004056.09987 | 2097637.96008 | 37.739943995718704 | -122.428531773318 | (37.7399439957187, -122.428531773318) | |||
| 60140 | 60140 | 222489 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 231 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6004078.33826 | 2097619.6729900003 | 37.739895042010204 | -122.428453579085 | (37.7398950420102, -122.428453579085) | |||
| 164808 | 164808 | 222488 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 195 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6004318.20624 | 2097516.6658400004 | 37.739625778703704 | -122.427616878624 | (37.7396257787037, -122.427616878624) | |||
| 155985 | 155985 | 222487 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 183 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004373.5086900005 | 2097518.96538 | 37.7396352206895 | -122.427425830257 | (37.7396352206895, -122.427425830257) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");