Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▲ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2125 | 2125 | 117673 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 7600x Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 23 | Width 6ft | 5983555.0 | 2112529.0 | 37.779649107322506 | -122.50051568716002 | (37.7796491073225, -122.50051568716) | |||
| 23784 | 23784 | 211628 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 299x Magellan Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 6ft | 5994455.12768 | 2100116.98357 | 37.7462027717556 | -122.461907419396 | (37.7462027717556, -122.461907419396) | |||
| 25039 | 25039 | 199364 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 300x Division St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 28 | Width 6ft | 6009993.3485 | 2108173.3882400002 | 37.7692061355694 | -122.408746211675 | (37.7692061355694, -122.408746211675) | |||
| 26825 | 26825 | 222784 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 2800x Cesar Chavez St | 28 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 6ft | 6010005.9068599995 | 2100575.1088400004 | 37.7483436744252 | -122.408166814455 | (37.7483436744252, -122.408166814455) | |||
| 27734 | 27734 | 181258 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400x Bay Shore Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6010956.04386 | 2086896.41565 | 37.7108380015362 | -122.403918812817 | (37.7108380015362, -122.403918812817) | |||
| 29208 | 29208 | 181257 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400x Bay Shore Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6010977.11587 | 2086929.96483 | 37.7109312981009 | -122.40384834192801 | (37.7109312981009, -122.403848341928) | |||
| 31992 | 31992 | 222782 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 2800x Cesar Chavez St | 30 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 6ft | 6009967.718280001 | 2100574.0603400003 | 37.7483386570983 | -122.408298796278 | (37.7483386570983, -122.408298796278) | |||
| 33349 | 33349 | 222797 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 2800x Cesar Chavez St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 6ft | 6010346.58719 | 2100693.6373099997 | 37.7486881975031 | -122.406997097757 | (37.7486881975031, -122.406997097757) | |||
| 33376 | 33376 | 221293 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 2800x Cesar Chavez St | 33 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 6ft | 6009914.910569999 | 2100575.90442 | 37.7483407633146 | -122.408481534905 | (37.7483407633146, -122.408481534905) | |||
| 33738 | 33738 | 181254 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6011072.17285 | 2087082.1734200001 | 37.711354542437 | -122.403530502643 | (37.711354542437, -122.403530502643) | |||
| 34635 | 34635 | 211621 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 299x Magellan Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 6ft | 5994368.11435 | 2100029.21026 | 37.7459567586067 | -122.46220193388001 | (37.7459567586067, -122.46220193388) | |||
| 35477 | 35477 | 211623 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 299x Magellan Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 6ft | 5994380.19726 | 2100040.4355900004 | 37.7459882762472 | -122.462160967071 | (37.7459882762472, -122.462160967071) | |||
| 35882 | 35882 | 181250 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6011135.05622 | 2087186.9706 | 37.7116458067799 | -122.403320528015 | (37.7116458067799, -122.403320528015) | |||
| 36606 | 36606 | 207443 | DPW Maintained 3 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 220x Vasquez Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 6ft | 5994526.33722 | 2099104.46758 | 37.743426756135996 | -122.461587791356 | (37.743426756136, -122.461587791356) | |||
| 36673 | 36673 | 222783 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 2800x Cesar Chavez St | 29 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 6ft | 6009988.4422699995 | 2100575.2331 | 37.748343037701204 | -122.40822721561399 | (37.7483430377012, -122.408227215614) | |||
| 38095 | 38095 | 199413 | DPW Maintained 3 | Euphorbia ingens :: Candelabra tree 396 | 1510x 22nd St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 6ft | 6013475.19386 | 2103827.84033 | 37.7574686213087 | -122.396397978582 | (37.7574686213087, -122.396397978582) | |||
| 38158 | 38158 | 211625 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 299x Magellan Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 6ft | 5994395.62739 | 2100058.6055 | 37.7460390546617 | -122.46210892960801 | (37.7460390546617, -122.462108929608) | |||
| 38731 | 38731 | 222803 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 2800x Cesar Chavez St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 6ft | 6010452.68948 | 2100735.7039799998 | 37.748809640151 | -122.406633159205 | (37.748809640151, -122.406633159205) | |||
| 39663 | 39663 | 189307 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1510x 22nd St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 6ft | 6013533.7803 | 2103828.56548 | 37.757473872449296 | -122.396195412608 | (37.7574738724493, -122.396195412608) | |||
| 39857 | 39857 | 199599 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 1510x 22nd St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 6ft | 6013497.509219999 | 2103827.38808 | 37.7574686213053 | -122.396320770893 | (37.7574686213053, -122.396320770893) | |||
| 40228 | 40228 | 221294 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 2800x Cesar Chavez St | 32 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 6ft | 6009933.74132 | 2100573.95707 | 37.7483364708711 | -122.408416281006 | (37.7483364708711, -122.408416281006) | |||
| 40750 | 40750 | 222786 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 2800x Cesar Chavez St | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 6ft | 6010045.33048 | 2100578.24772 | 37.7483545004769 | -122.40803070925301 | (37.7483545004769, -122.408030709253) | |||
| 40752 | 40752 | 181255 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6011058.3910300005 | 2087059.24952 | 37.71129082818 | -122.403576524557 | (37.71129082818, -122.403576524557) | |||
| 42000 | 42000 | 181235 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2100x Bay Shore Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 6ft | 6011766.34512 | 2087531.33968 | 37.7126266136928 | -122.401162793634 | (37.7126266136928, -122.401162793634) | |||
| 42101 | 42101 | 222800 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 2800x Cesar Chavez St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 6ft | 6010400.666730001 | 2100716.83589 | 37.7487549217978 | -122.406811725007 | (37.7487549217978, -122.406811725007) | |||
| 42138 | 42138 | 181261 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400x Bay Shore Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6010896.06222 | 2086791.14453 | 37.710545596879705 | -122.40411872042299 | (37.7105455968797, -122.404118720423) | |||
| 42329 | 42329 | 181252 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6011104.47177 | 2087135.7976799998 | 37.711503587981205 | -122.403422638862 | (37.7115035879812, -122.403422638862) | |||
| 43780 | 43780 | 222790 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 2800x Cesar Chavez St | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 6ft | 6010204.45395 | 2100638.0852099997 | 37.748527708997706 | -122.407484679601 | (37.7485277089977, -122.407484679601) | |||
| 44652 | 44652 | 181259 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400x Bay Shore Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6010937.034659999 | 2086861.99587 | 37.710742429686206 | -122.40398209272499 | (37.7107424296862, -122.403982092725) | |||
| 45461 | 45461 | 189994 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1150x Tennessee St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 6ft | 6015560.24014 | 2103579.83014 | 37.756903445945795 | -122.389169674966 | (37.7569034459458, -122.389169674966) | |||
| 45667 | 45667 | 222798 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 2800x Cesar Chavez St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 6ft | 6010362.72058 | 2100700.08083 | 37.7487067927886 | -122.406941762453 | (37.7487067927886, -122.406941762453) | |||
| 45836 | 45836 | 222792 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 2800x Cesar Chavez St | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 6ft | 6010247.81472 | 2100654.1398 | 37.7485742183223 | -122.40733586967801 | (37.7485742183223, -122.407335869678) | |||
| 46162 | 46162 | 222788 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 2800x Cesar Chavez St | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 6ft | 6010168.99866 | 2100623.96537 | 37.74848695440979 | -122.407606288598 | (37.7484869544098, -122.407606288598) | |||
| 48782 | 48782 | 181251 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6011120.84177 | 2087163.22682 | 37.7115798172183 | -122.40336798793999 | (37.7115798172183, -122.40336798794) | |||
| 49900 | 49900 | 211629 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 299x Magellan Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 6ft | 5994463.26259 | 2100123.19006 | 37.7462202815386 | -122.461879740062 | (37.7462202815386, -122.461879740062) | |||
| 50582 | 50582 | 222804 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 2800x Cesar Chavez St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 6ft | 6010473.5023 | 2100743.8867099998 | 37.74883327255171 | -122.406561764722 | (37.7488332725517, -122.406561764722) | |||
| 51598 | 51598 | 117842 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 620x 39th Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 6ft | 5983810.65643 | 2111554.107 | 37.7769873385843 | -122.499559205901 | (37.7769873385843, -122.499559205901) | |||
| 51690 | 51690 | 251039 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5400x Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 6ft | 5990159.2899 | 2112663.7273 | 37.780404505362 | -122.47767868930201 | (37.780404505362, -122.477678689302) | |||
| 54766 | 54766 | 117843 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 620x 39th Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 6ft | 5983810.12526 | 2111540.49138 | 37.776949922870294 | -122.49956003685301 | (37.7769499228703, -122.499560036853) | |||
| 57154 | 57154 | 212375 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 350x Kensington Way | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 6ft | 5994268.67075 | 2099029.19032 | 37.743205228833205 | -122.46247327105101 | (37.7432052288332, -122.462473271051) | |||
| 57972 | 57972 | 181260 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400x Bay Shore Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6010918.05044 | 2086828.8185599998 | 37.7106502707697 | -122.40404537351601 | (37.7106502707697, -122.404045373516) | |||
| 58860 | 58860 | 222796 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 2800x Cesar Chavez St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 6ft | 6010330.47003 | 2100687.99035 | 37.7486717902786 | -122.40705243304899 | (37.7486717902786, -122.407052433049) | |||
| 59208 | 59208 | 222795 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 2800x Cesar Chavez St | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 6ft | 6010312.60007 | 2100681.0451 | 37.748651720118296 | -122.40711373800801 | (37.7486517201183, -122.407113738008) | |||
| 60011 | 60011 | 181246 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6011206.95507 | 2087284.9541099998 | 37.711918865232 | -122.403078912559 | (37.711918865232, -122.403078912559) | |||
| 60634 | 60634 | 117841 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 600x 39th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 6ft | 5983809.68656 | 2111621.06726 | 37.7771711351486 | -122.499567510814 | (37.7771711351486, -122.499567510814) | |||
| 61625 | 61625 | 223864 | DPW Maintained 3 | Cussonia spicata :: Cabbage tree 325 | 3700x Cesar Chavez St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 6ft | 6005797.02686 | 2100532.2784 | 37.74798950431929 | -122.422717994438 | (37.7479895043193, -122.422717994438) | |||
| 64248 | 64248 | 211436 | DPW Maintained 3 | Pittosporum eugenioides :: Tarata 110 | 220x Vasquez Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 34 | Width 6ft | 5994537.09641 | 2099112.75591 | 37.7434501331166 | -122.461551189851 | (37.7434501331166, -122.461551189851) | |||
| 64857 | 64857 | 239685 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1601x Alabama St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 6ft | 6009289.0171 | 2100045.3572 | 37.7468489265392 | -122.41060840725201 | (37.7468489265392, -122.410608407252) | |||
| 66499 | 66499 | 192634 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2x Garlington Ct | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 6ft | 6016723.45145 | 2094514.5247400003 | 37.732076385599704 | -122.38451540818001 | (37.7320763855997, -122.38451540818) | |||
| 66922 | 66922 | 188419 | DPW Maintained 3 | Ceanothus Sps :: California lilac 270 | 1300x De Haro St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 6ft | 6012288.5470199995 | 2102174.31533 | 37.7528622973756 | -122.40038576319901 | (37.7528622973756, -122.400385763199) | |||
| 69761 | 69761 | 117845 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 620x 39th Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 23 | Width 6ft | 5983812.70856 | 2111515.33399 | 37.7768809995382 | -122.49954924088199 | (37.7768809995382, -122.499549240882) | |||
| 69859 | 69859 | 222802 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 2800x Cesar Chavez St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 6ft | 6010429.09117 | 2100727.82073 | 37.7487866741639 | -122.40671420700501 | (37.7487866741639, -122.406714207005) | |||
| 70163 | 70163 | 208304 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 600x Bosworth St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 6ft | 6002256.900219999 | 2095383.64067 | 37.7336521723072 | -122.43459149970501 | (37.7336521723072, -122.434591499705) | |||
| 74990 | 74990 | 221301 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 2800x Cesar Chavez St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 6ft | 6010534.61794 | 2100761.75741 | 37.7488857605716 | -122.40635168490499 | (37.7488857605716, -122.406351684905) | |||
| 76029 | 76029 | 117836 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 660x 39th Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 6ft | 5983819.78589 | 2111279.0355 | 37.776232607542504 | -122.499507291354 | (37.7762326075425, -122.499507291354) | |||
| 118106 | 118106 | 222785 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 2800x Cesar Chavez St | 27 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 6ft | 6010026.6545 | 2100576.07742 | 37.748347495638704 | -122.408095137598 | (37.7483474956387, -122.408095137598) | |||
| 130739 | 130739 | 199576 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 1300x De Haro St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 6ft | 6012291.12869 | 2102166.26661 | 37.752840341307504 | -122.40037626996 | (37.7528403413075, -122.40037626996) | |||
| 135350 | 135350 | 222791 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 2800x Cesar Chavez St | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 6ft | 6010227.86602 | 2100646.66118 | 37.7485525671486 | -122.40740432517 | (37.7485525671486, -122.40740432517) | |||
| 136337 | 136337 | 192633 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2x Garlington Ct | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 6ft | 6016736.26235 | 2094477.0250400002 | 37.7319741272952 | -122.384468506713 | (37.7319741272952, -122.384468506713) | |||
| 136431 | 136431 | 181236 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2100x Bay Shore Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 6ft | 6011740.78696 | 2087511.07022 | 37.712569531933 | -122.401249707721 | (37.712569531933, -122.401249707721) | |||
| 137086 | 137086 | 222789 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 2800x Cesar Chavez St | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 6ft | 6010186.13966 | 2100630.80552 | 37.7485066954419 | -122.40754749724199 | (37.7485066954419, -122.407547497242) | |||
| 148120 | 148120 | 117848 | DPW Maintained 3 | Bambusa spp :: Bamboo Species 346 | 640x 39th Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 6ft | 5983816.13429 | 2111394.76914 | 37.776550164373205 | -122.49952847813101 | (37.7765501643732, -122.499528478131) | |||
| 148566 | 148566 | 181253 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6011090.2657 | 2087112.4680700002 | 37.7114387360727 | -122.403470098762 | (37.7114387360727, -122.403470098762) | |||
| 148955 | 148955 | 208303 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 600x Bosworth St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 6ft | 6002276.071219999 | 2095379.68472 | 37.7336423984691 | -122.434524937286 | (37.7336423984691, -122.434524937286) | |||
| 150576 | 150576 | 208301 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 600x Bosworth St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 6ft | 6002317.80033 | 2095368.99319 | 37.7336154107143 | -122.434379903628 | (37.7336154107143, -122.434379903628) | |||
| 150612 | 150612 | 207444 | DPW Maintained 3 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 220x Vasquez Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 6ft | 5994513.07685 | 2099093.39362 | 37.743395586528294 | -122.461632839295 | (37.7433955865283, -122.461632839295) | |||
| 150822 | 150822 | 181256 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2400x Bay Shore Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6010998.20467 | 2086964.34233 | 37.7110268699605 | -122.40377787107799 | (37.7110268699605, -122.403777871078) | |||
| 150986 | 150986 | 221299 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 2800x Cesar Chavez St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 6ft | 6010495.09944 | 2100750.8681400004 | 37.7488536502806 | -122.406487573365 | (37.7488536502806, -122.406487573365) | |||
| 152253 | 152253 | 211624 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 299x Magellan Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 6ft | 5994386.77221 | 2100048.58789 | 37.7460110389775 | -122.46213882305901 | (37.7460110389775, -122.462138823059) | |||
| 152692 | 152692 | 222794 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 2800x Cesar Chavez St | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 6ft | 6010286.07268 | 2100668.6664 | 37.7486162463561 | -122.407204597414 | (37.7486162463561, -122.407204597414) | |||
| 152863 | 152863 | 192632 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2x Garlington Ct | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 6ft | 6016758.25797 | 2094440.43595 | 37.73187487720529 | -122.384389914969 | (37.7318748772053, -122.384389914969) | |||
| 153868 | 153868 | 214322 | DPW Maintained 3 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 350x Kensington Way | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 6ft | 5994251.85903 | 2099042.92229 | 37.7432419652355 | -122.462532396964 | (37.7432419652355, -122.462532396964) | |||
| 154625 | 154625 | 117847 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 640x 39th Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 6ft | 5983816.430369999 | 2111419.8653700002 | 37.7766190887274 | -122.49952930905701 | (37.7766190887274, -122.499529309057) | |||
| 154731 | 154731 | 222787 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 2800x Cesar Chavez St | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 6ft | 6010096.17882 | 2100593.44521 | 37.748399076272 | -122.40785594761499 | (37.748399076272, -122.407855947615) | |||
| 159003 | 159003 | 222801 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 2800x Cesar Chavez St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 6ft | 6010415.2689 | 2100722.39062 | 37.748770990899 | -122.406761621955 | (37.748770990899, -122.406761621955) | |||
| 159888 | 159888 | 181249 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6011154.37999 | 2087216.41128 | 37.7117277242201 | -122.40325580920602 | (37.7117277242201, -122.403255809206) | |||
| 161466 | 161466 | 193529 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2x Garlington Ct | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 6ft | 6016723.20154 | 2094502.11588 | 37.732042299514106 | -122.38451540818001 | (37.7320422995141, -122.38451540818) | |||
| 162080 | 162080 | 221296 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 2800x Cesar Chavez St | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 6ft | 6010117.571380001 | 2100603.21353 | 37.7484270955515 | -122.407782660967 | (37.7484270955515, -122.407782660967) | |||
| 163567 | 163567 | 212376 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 350x Kensington Way | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 6ft | 5994225.30573 | 2099058.0744 | 37.743282039932794 | -122.462625309526 | (37.7432820399328, -122.462625309526) | |||
| 164702 | 164702 | 246548 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 20x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 6ft | 6005741.17746 | 2109432.24964 | 37.772423585213794 | -122.423543772638 | (37.7724235852138, -122.423543772638) | |||
| 166035 | 166035 | 214700 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 200x Vasquez Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 6ft | 5994642.56982 | 2099211.09063 | 37.7437262061113 | -122.461193618499 | (37.7437262061113, -122.461193618499) | |||
| 166571 | 166571 | 221295 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 2800x Cesar Chavez St | 31 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 6ft | 6009951.63524 | 2100574.2891 | 37.7483383846059 | -122.408354427415 | (37.7483383846059, -122.408354427415) | |||
| 167503 | 167503 | 117838 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 660x 39th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 6ft | 5983820.62988 | 2111252.49481 | 37.7761597840052 | -122.499502409931 | (37.7761597840052, -122.499502409931) | |||
| 167542 | 167542 | 181237 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2100x Bay Shore Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 6ft | 6011709.60443 | 2087494.2224299998 | 37.712521531527294 | -122.40135630166 | (37.7125215315273, -122.40135630166) | |||
| 169354 | 169354 | 117837 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 660x 39th Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 6ft | 5983820.01458 | 2111273.2343900003 | 37.776216692790705 | -122.49950607144899 | (37.7762166927907, -122.499506071449) | |||
| 169623 | 169623 | 222793 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 2800x Cesar Chavez St | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 6ft | 6010266.15939 | 2100660.65315 | 37.748593129264 | -122.40727289285101 | (37.748593129264, -122.407272892851) | |||
| 169662 | 169662 | 208300 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 600x Bosworth St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 6ft | 6002335.89975 | 2095363.88492 | 37.7336024119263 | -122.434316963673 | (37.7336024119263, -122.434316963673) | |||
| 170156 | 170156 | 117839 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 600x 39th Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 5983810.52385 | 2111649.02031 | 37.7772479352498 | -122.499566680778 | (37.7772479352498, -122.499566680778) | |||
| 172193 | 172193 | 208302 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 600x Bosworth St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 6ft | 6002298.45936 | 2095373.7498299999 | 37.7336273734974 | -122.434447110867 | (37.7336273734974, -122.434447110867) | |||
| 173103 | 173103 | 221298 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 2800x Cesar Chavez St | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6010150.44695 | 2100616.45833 | 37.748465303245396 | -122.40766991113999 | (37.7484653032454, -122.40766991114) | |||
| 174456 | 174456 | 211627 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 299x Magellan Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 6ft | 5994448.55945 | 2100109.15012 | 37.7461808849383 | -122.461929563416 | (37.7461808849383, -122.461929563416) | |||
| 175620 | 175620 | 117840 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 600x 39th Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 6ft | 5983808.599090001 | 2111637.58628 | 37.777216427782896 | -122.499572493795 | (37.7772164277829, -122.499572493795) | |||
| 175756 | 175756 | 181248 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 6ft | 6011168.55226 | 2087238.084 | 37.7117880246642 | -122.403208349279 | (37.7117880246642, -122.403208349279) | |||
| 177475 | 177475 | 126129 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 2800x Van Ness Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 6ft | 6005644.09156 | 2120125.76706 | 37.8017798472085 | -122.424640432904 | (37.8017798472085, -122.424640432904) | |||
| 178685 | 178685 | 211622 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 299x Magellan Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 6ft | 5994374.65588 | 2100035.76883 | 37.745975143439104 | -122.46217978988899 | (37.7459751434391, -122.462179789889) | |||
| 180560 | 180560 | 211626 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 299x Magellan Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 6ft | 5994442.33797 | 2100102.5844900003 | 37.7461624991943 | -122.46195060033399 | (37.7461624991943, -122.461950600334) | |||
| 181946 | 181946 | 221297 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 2800x Cesar Chavez St | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 6ft | 6010135.01415 | 2100610.8980799997 | 37.7484491721017 | -122.407722885716 | (37.7484491721017, -122.407722885716) | |||
| 183126 | 183126 | 117846 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 620x 39th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 55 | Width 6ft | 5983813.41321 | 2111492.12904 | 37.7768173268114 | -122.49954508796999 | (37.7768173268114, -122.49954508797) | |||
| 183212 | 183212 | 181247 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2200x Bay Shore Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 6ft | 6011190.75371 | 2087265.8089 | 37.7118653915605 | -122.40313356348899 | (37.7118653915605, -122.403133563489) | |||
| 185709 | 185709 | 222799 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 2800x Cesar Chavez St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 6ft | 6010384.90884 | 2100709.18955 | 37.7487330449049 | -122.40686567713499 | (37.7487330449049, -122.406865677135) |
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");