Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, qCareAssistant, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies ▲ | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 101656 | 101656 | 23365 | DPW Maintained 3 | Eucalyptus simmondsi :: Simmond's Peppermint 512 | 1356X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006391.382589401 | 2115174.2493055 | 37.7882263975959 | -122.42170255954201 | (37.7882263975959, -122.421702559542) | |||
| 113613 | 113613 | 23368 | DPW Maintained 3 | Eucalyptus simmondsi :: Simmond's Peppermint 512 | 1356X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 9 | 6006391.382589401 | 2115174.2493055 | 37.7882263975959 | -122.42170255954201 | (37.7882263975959, -122.421702559542) | |||
| 95817 | 95817 | 23447 | DPW Maintained 3 | Eucalyptus odorata :: Peppermint Box 507 | 2100X Van Ness Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006027.0678818 | 2117578.0674993 | 37.794806131309706 | -122.42313396012399 | (37.7948061313097, -122.423133960124) | |||
| 108295 | 108295 | 23405 | DPW Maintained 3 | Eucalyptus macarthuri :: Camden Wollybutt 503 | 1700X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006206.237645401 | 2116289.0241793 | 37.79127685023521 | -122.422422371222 | (37.7912768502352, -122.422422371222) | |||
| 103185 | 103185 | 4735 | DPW Maintained 3 | Liquidambar styraciflua 'Festival' :: Festival Sweet Gum 479 | 1100X Columbus Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/19/2006 12:00:00 AM | 6 | 3x3 | 6008154.5819477 | 2121037.0963081 | 37.804423590750396 | -122.41601752221001 | (37.8044235907504, -122.41601752221) | ||
| 82879 | 82879 | 2302 | DPW Maintained 3 | Cupressus arizonica :: Arizona Cypress 475 | 800X Brotherhood Way | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 14M | 5990276.209646201 | 2088591.5343604 | 37.7143153385926 | -122.47551605113199 | (37.7143153385926, -122.475516051132) | |||
| 89822 | 89822 | 2298 | DPW Maintained 3 | Cupressus arizonica :: Arizona Cypress 475 | 800X Brotherhood Way | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 45 | 14M | 5990276.209646201 | 2088591.5343604 | 37.7143153385926 | -122.47551605113199 | (37.7143153385926, -122.475516051132) | |||
| 89900 | 89900 | 2261 | DPW Maintained 3 | Cupressus arizonica :: Arizona Cypress 475 | 700X Brotherhood Way | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 14M | 5991180.7931196 | 2088069.9959996997 | 37.7129357180907 | -122.472351488932 | (37.7129357180907, -122.472351488932) | |||
| 101138 | 101138 | 2304 | DPW Maintained 3 | Cupressus arizonica :: Arizona Cypress 475 | 800X Brotherhood Way | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 45 | 14M | 5990276.209646201 | 2088591.5343604 | 37.7143153385926 | -122.47551605113199 | (37.7143153385926, -122.475516051132) | |||
| 105930 | 105930 | 2267 | DPW Maintained 3 | Cupressus arizonica :: Arizona Cypress 475 | 750X Brotherhood Way | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 45 | 14M | 5991074.042616099 | 2088106.2478104 | 37.71302907778821 | -122.47272309171998 | (37.7130290777882, -122.47272309172) | |||
| 107007 | 107007 | 2297 | DPW Maintained 3 | Cupressus arizonica :: Arizona Cypress 475 | 800X Brotherhood Way | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 14M | 5990276.209646201 | 2088591.5343604 | 37.7143153385926 | -122.47551605113199 | (37.7143153385926, -122.475516051132) | |||
| 112198 | 112198 | 2265 | DPW Maintained 3 | Cupressus arizonica :: Arizona Cypress 475 | 700X Brotherhood Way | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 14M | 5991180.7931196 | 2088069.9959996997 | 37.7129357180907 | -122.472351488932 | (37.7129357180907, -122.472351488932) | |||
| 123388 | 123388 | 2257 | DPW Maintained 3 | Cupressus arizonica :: Arizona Cypress 475 | 700X Brotherhood Way | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 45 | 14M | 5991180.7931196 | 2088069.9959996997 | 37.7129357180907 | -122.472351488932 | (37.7129357180907, -122.472351488932) | |||
| 126997 | 126997 | 2258 | DPW Maintained 3 | Cupressus arizonica :: Arizona Cypress 475 | 700X Brotherhood Way | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | 14M | 5991180.7931196 | 2088069.9959996997 | 37.7129357180907 | -122.472351488932 | (37.7129357180907, -122.472351488932) | |||
| 127206 | 127206 | 2303 | DPW Maintained 3 | Cupressus arizonica :: Arizona Cypress 475 | 800X Brotherhood Way | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 45 | 14M | 5990276.209646201 | 2088591.5343604 | 37.7143153385926 | -122.47551605113199 | (37.7143153385926, -122.475516051132) | |||
| 139834 | 139834 | 2259 | DPW Maintained 3 | Cupressus arizonica :: Arizona Cypress 475 | 700X Brotherhood Way | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 14M | 5991180.7931196 | 2088069.9959996997 | 37.7129357180907 | -122.472351488932 | (37.7129357180907, -122.472351488932) | |||
| 140483 | 140483 | 2260 | DPW Maintained 3 | Cupressus arizonica :: Arizona Cypress 475 | 700X Brotherhood Way | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | 14M | 5991180.7931196 | 2088069.9959996997 | 37.7129357180907 | -122.472351488932 | (37.7129357180907, -122.472351488932) | |||
| 127755 | 127755 | 83007 | Permitted Site 1 | Laurus x 'Saratoga' :: Hybrid Laurel 457 | 1058 De Haro St | 1 | Median : Cutout 11 | Landscaping 2 | Private 1 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52381 | 6012170.46860809 | 2103464.70975517 | 37.7563988530014 | -122.40088475581499 | (37.7563988530014, -122.400884755815) | ||
| 157453 | 157453 | 18552 | DPW Maintained 3 | Quercus engelmannii :: Engelmann oak 453 | 1700X Quesada Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | 19 | 6014642.29362 | 2095077.14438 | 37.7335059182554 | -122.39174980833201 | (37.7335059182554, -122.391749808332) | |||
| 119388 | 119388 | 23234 | DPW Maintained 3 | Eucalyptus torquata :: Coral Gum 452 | 700X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006679.199292599 | 2112885.0865653 | 37.7819571437982 | -122.42054420111201 | (37.7819571437982, -122.420544201112) | |||
| 71763 | 71763 | 240364 | DPW Maintained 3 | Quercus wislizenii :: Interior Live Oak 446 | 1x Elsie St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6006311.92268 | 2096890.82859 | 37.7380199402741 | -122.420679036208 | (37.7380199402741, -122.420679036208) | |||
| 113820 | 113820 | 28265 | DPW Maintained 3 | Prunus lusitanica :: Portugese Cherry Laurel 430 | 2X 12th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 16 | 5992095.82399 | 2114846.95109 | 37.7865112284639 | -122.47113847763 | (37.7865112284639, -122.47113847763) | |||
| 53247 | 53247 | 97256 | DPW Maintained 3 | Jubaea chilensis :: Chilean Wine Palm 425 | 198 Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/05/2011 12:00:00 AM | 6004815.0 | 2107196.0 | 37.766231062063206 | -122.426588243906 | (37.7662310620632, -122.426588243906) | ||||
| 107742 | 107742 | 23296 | DPW Maintained 3 | Eucalyptus melliodora :: Yellow Box 416 | 900X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 9 | 6006584.2678331 | 2113563.3466728 | 37.7838141299544 | -122.42092079119 | (37.7838141299544, -122.42092079119) | |||
| 113330 | 113330 | 23300 | DPW Maintained 3 | Eucalyptus melliodora :: Yellow Box 416 | 950X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006575.9602707 | 2113798.8129121 | 37.7844601942992 | -122.42096625602301 | (37.7844601942992, -122.420966256023) | |||
| 116606 | 116606 | 23301 | DPW Maintained 3 | Eucalyptus melliodora :: Yellow Box 416 | 950X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006575.9602707 | 2113798.8129121 | 37.7844601942992 | -122.42096625602301 | (37.7844601942992, -122.420966256023) | |||
| 140991 | 140991 | 23295 | DPW Maintained 3 | Eucalyptus melliodora :: Yellow Box 416 | 900X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 9 | 6006584.2678331 | 2113563.3466728 | 37.7838141299544 | -122.42092079119 | (37.7838141299544, -122.42092079119) | |||
| 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) | |||
| 92004 | 92004 | 23601 | DPW Maintained 3 | Eucalyptus viminalis :: Manna Gum 356 | 200X Vasquez Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 60 | 5994426.954874 | 2098963.765109 | 37.7430347013579 | -122.46192122709499 | (37.7430347013579, -122.461921227095) | |||
| 92914 | 92914 | 23600 | DPW Maintained 3 | Eucalyptus viminalis :: Manna Gum 356 | 200X Vasquez Ave | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 60 | 5994426.954874 | 2098963.765109 | 37.7430347013579 | -122.46192122709499 | (37.7430347013579, -122.461921227095) | |||
| 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) | |||
| 103283 | 103283 | 106793 | DPW Maintained 3 | Eucalyptus camaldulensis :: River Red Gum 340 | 199X ARLINGTON ST | 49 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | 6005045.0 | 2097131.0 | 37.7386079110333 | -122.425076502639 | (37.7386079110333, -122.425076502639) | ||||
| 122029 | 122029 | 114995 | DPW Maintained 3 | Eucalyptus camaldulensis :: River Red Gum 340 | 199x ARLINGTON ST | 44 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 3x3 | 6005045.0 | 2097131.0 | 37.7386079110333 | -122.425076502639 | (37.7386079110333, -122.425076502639) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 58464 | 58464 | 222781 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 2950x Cesar Chavez St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 5ft | 6009693.66446 | 2100583.0279099997 | 37.748347930031 | -122.40924710438401 | (37.748347930031, -122.409247104384) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 23251 | 23251 | 16380 | DPW Maintained 3 | Fremontodendron spp :: Flannel Bush Tree 331 | 1000 Moraga St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 12 | 5991061.65482 | 2103836.24058 | 37.7562189332688 | -122.47391280754499 | (37.7562189332688, -122.473912807545) | |||
| 23080 | 23080 | 18562 | DPW Maintained 3 | Prunus persica :: Peach 330 | 1700X Quesada Ave | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | 19 | 6014525.2512300005 | 2095171.8151599998 | 37.7337593670062 | -122.392161079069 | (37.7337593670062, -122.392161079069) | |||
| 22834 | 22834 | 18553 | DPW Maintained 3 | Brachychiton populneus :: Bottle Tree 329 | 1700X Quesada Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 19 | 6014639.83884 | 2095088.0927900001 | 37.7335358440919 | -122.391759060533 | (37.7335358440919, -122.391759060533) | |||
| 23604 | 23604 | 223865 | DPW Maintained 3 | Cussonia spicata :: Cabbage tree 325 | 3700x Cesar Chavez St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 5ft | 6005794.48367 | 2100533.61064 | 37.7479930188582 | -122.422726883358 | (37.7479930188582, -122.422726883358) | |||
| 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) | |||
| 183152 | 183152 | 176558 | DPW Maintained 3 | Heteromeles arbutifolia :: Toyon 322 | 300x Mansell St | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 6010777.60358 | 2090452.8911 | 37.7205933893479 | -122.404785768266 | (37.7205933893479, -122.404785768266) | |||
| 133114 | 133114 | 215371 | DPW Maintained 3 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 | 400x Marietta Dr | 45 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 5999058.22079 | 2096961.6514400002 | 37.737802912270205 | -122.445763673175 | (37.7378029122702, -122.445763673175) | |||
| 149502 | 149502 | 215370 | DPW Maintained 3 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 | 400x Marietta Dr | 46 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 3ft | 5999044.03469 | 2096956.28637 | 37.7377873710787 | -122.445812335482 | (37.7377873710787, -122.445812335482) | |||
| 166185 | 166185 | 215369 | DPW Maintained 3 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 | 400x Marietta Dr | 51 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 5998949.60068 | 2096892.4863200001 | 37.73760679890071 | -122.44613425049499 | (37.7376067989007, -122.446134250495) | |||
| 20874 | 20874 | 25029 | DPW Maintained 3 | Phoenix spp :: Date palm (species unknown) 319 | 700X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/23/1997 12:00:00 AM | 70 | 20 | 6004993.6187 | 2104177.61961 | 37.7579534017581 | -122.425755575182 | (37.7579534017581, -122.425755575182) | ||
| 21589 | 21589 | 25051 | DPW Maintained 3 | Phoenix spp :: Date palm (species unknown) 319 | 900X Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005068.020819999 | 2102892.3798700003 | 37.7544286384789 | -122.42540679920799 | (37.7544286384789, -122.425406799208) | |||
| 21814 | 21814 | 11202 | DPW Maintained 3 | Pinus thunbergii :: Japanese Black Pine 306 | 100 Idora Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8 | 5995328.17404 | 2099416.28223 | 37.744329043248 | -122.458837831796 | (37.744329043248, -122.458837831796) | |||
| 125116 | 125116 | 806 | DPW Maintained 3 | Pinus thunbergii :: Japanese Black Pine 306 | 600X 39th Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6-HOA | 5983808.23309 | 2111660.7549099997 | 37.777280020650295 | -122.499575472587 | (37.7772800206503, -122.499575472587) | |||
| 17742 | 17742 | 29583 | DPW Maintained 3 | Cedrus atlantica :: Atlas Cedar 304 | 500X Junipero Serra Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991356.34632 | 2093796.5361 | 37.7286695450513 | -122.472161885972 | (37.7286695450513, -122.472161885972) | ||
| 19000 | 19000 | 30051 | DPW Maintained 3 | Cedrus atlantica :: Atlas Cedar 304 | 700X Junipero Serra Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 3X3 | 5991309.16462 | 2093067.2657700002 | 37.7266644202262 | -122.472271855075 | (37.7266644202262, -122.472271855075) | |||
| 21379 | 21379 | 11753 | DPW Maintained 3 | Cedrus atlantica :: Atlas Cedar 304 | 700X Junipero Serra Blvd | 36 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991274.57378 | 2092596.10409 | 37.725368725576 | -122.472357100898 | (37.725368725576, -122.472357100898) | ||
| 17741 | 17741 | 25023 | DPW Maintained 3 | Phoenix rupicola :: Cliff date palm 303 | 700X Dolores St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6005002.68388 | 2104089.9673 | 37.7577132413816 | -122.425717985308 | (37.7577132413816, -122.425717985308) | |||
| 17653 | 17653 | 8211 | DPW Maintained 3 | Pinus muricata :: Bishop Pine 302 | 2189X Funston Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8X25 | 5992289.98615 | 2100521.20656 | 37.7471877793895 | -122.469423560971 | (37.7471877793895, -122.469423560971) | |||
| 125989 | 125989 | 87027 | Permitted Site 1 | Pinus muricata :: Bishop Pine 302 | 23 Magellan Ave | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 3x3 | Permit Number 49971 | 5994623.4 | 2101166.9 | 37.74909526366879 | -122.461401658799 | (37.7490952636688, -122.461401658799) | |||
| 186357 | 186357 | 211055 | DPW Maintained 3 | Pinus muricata :: Bishop Pine 302 | 300x Marietta Dr | 72 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 5999722.47175 | 2097250.7906299997 | 37.7386347240172 | -122.443487806529 | (37.7386347240172, -122.443487806529) | |||
| 17557 | 17557 | 15331 | DPW Maintained 3 | Corymbia citriodora :: Lemon Scented Gum 301 | 1700X Mission St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 4X4 | 6006725.71304 | 2108437.22279 | 37.7697470004467 | -122.42006753591002 | (37.7697470004467, -122.42006753591) | |||
| 21011 | 21011 | 15332 | DPW Maintained 3 | Corymbia citriodora :: Lemon Scented Gum 301 | 1700X Mission St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 4X4 | 6006723.99669 | 2108411.90123 | 37.7696773767498 | -122.42007167547101 | (37.7696773767498, -122.420071675471) | |||
| 21095 | 21095 | 15330 | DPW Maintained 3 | Corymbia citriodora :: Lemon Scented Gum 301 | 1700X Mission St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 4X4 | 6006727.83912 | 2108452.72313 | 37.769789680489 | -122.420061282012 | (37.769789680489, -122.420061282012) | |||
| 21983 | 21983 | 15333 | DPW Maintained 3 | Corymbia citriodora :: Lemon Scented Gum 301 | 1700X Mission St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 4X4 | 6006720.95157 | 2108390.0555 | 37.7696172219899 | -122.420080657908 | (37.7696172219899, -122.420080657908) | |||
| 103149 | 103149 | 15329 | DPW Maintained 3 | Corymbia citriodora :: Lemon Scented Gum 301 | 1700X Mission St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 4X4 | 6006717.7369932 | 2108570.5208478 | 37.7701125558687 | -122.42010458618601 | (37.7701125558687, -122.420104586186) | |||
| 118001 | 118001 | 13409 | DPW Maintained 3 | Corymbia citriodora :: Lemon Scented Gum 301 | 364 Marietta Dr | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 100 | 5 | 5999660.108164 | 2097381.7238333 | 37.738990678772396 | -122.443712833155 | (37.7389906787724, -122.443712833155) | |||
| 141531 | 141531 | 91166 | Cercis canadensis :: Eastern Redbud 299 | 1548x Quesada Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/31/2009 12:00:00 AM | 3 | 6015526.48125 | 2094420.051093 | 37.7317507154659 | -122.388647039673 | (37.7317507154659, -122.388647039673) | ||||
| 148206 | 148206 | 222972 | DPW Maintained 3 | Cotinus coggygria 'Royal Purple' :: Smoke tree 298 | 500x 27th St | 27 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 4ft | 6002994.97901 | 2100071.17381 | 37.746564928728205 | -122.432374425345 | (37.7465649287282, -122.432374425345) | |||
| 100262 | 100262 | 101656 | DPW Maintained 3 | Malus sylvestris :: Apple 281 | 200X Vasquez Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 5994672.4771300005 | 2099264.801 | 37.7438754024487 | -122.461094099214 | (37.7438754024487, -122.461094099214) | |||
| 82198 | 82198 | 18695 | DPW Maintained 3 | Eucalyptus cinerea :: Ash-colored Eucalyptus 279 | 251X Richardson Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/23/2002 12:00:00 AM | 3 | 100 | 5999064.164064 | 2119841.396854 | 37.8006252370733 | -122.44738946108299 | (37.8006252370733, -122.447389461083) | ||
| 13159 | 13159 | 24265 | DPW Maintained 3 | Ilex aquifolium :: European Holly 277 | 300X Winding Way | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 6001546.70936 | 2086492.80474 | 37.7091995959417 | -122.43641072479299 | (37.7091995959417, -122.436410724793) | |||
| 23786 | 23786 | 97361 | DPW Maintained 3 | Acer saccharinum :: Silver Maple 273 | 1351X Broadway | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | 6007149.6499 | 2118062.64447 | 37.7961999442141 | -122.41928405373999 | (37.7961999442141, -122.41928405374) | ||||
| 28086 | 28086 | 97371 | DPW Maintained 3 | Acer saccharinum :: Silver Maple 273 | 1351X Broadway | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | 6007032.43934 | 2118047.0408099997 | 37.796150498593995 | -122.419688519305 | (37.796150498594, -122.419688519305) | ||||
| 30236 | 30236 | 97380 | DPW Maintained 3 | Acer saccharinum :: Silver Maple 273 | 1401X Broadway | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006631.8373300005 | 2118013.16955 | 37.7960349222286 | -122.421072279161 | (37.7960349222286, -122.421072279161) | ||||
| 32402 | 32402 | 97365 | DPW Maintained 3 | Acer saccharinum :: Silver Maple 273 | 1263X Robert C Levy Tunl | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | 6007465.63195 | 2118105.8226099997 | 37.7963362913309 | -122.418193751644 | (37.7963362913309, -122.418193751644) | ||||
| 35792 | 35792 | 97374 | DPW Maintained 3 | Acer saccharinum :: Silver Maple 273 | 1351X Broadway | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006998.02946 | 2118043.30969 | 37.7961383154753 | -122.419807319778 | (37.7961383154753, -122.419807319778) | ||||
| 36548 | 36548 | 97369 | DPW Maintained 3 | Acer saccharinum :: Silver Maple 273 | 1351X Broadway | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | 6007107.08679 | 2118057.51485 | 37.7961834623584 | -122.41943096698601 | (37.7961834623584, -122.419430966986) | ||||
| 37825 | 37825 | 97384 | DPW Maintained 3 | Acer saccharinum :: Silver Maple 273 | 1401X Broadway | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006553.08454 | 2118002.88363 | 37.7960022399536 | -122.421344048901 | (37.7960022399536, -122.421344048901) | ||||
| 37952 | 37952 | 97382 | DPW Maintained 3 | Acer saccharinum :: Silver Maple 273 | 1401X Broadway | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006565.23555 | 2118004.957 | 37.7960086179662 | -122.42130215128 | (37.7960086179662, -122.42130215128) | ||||
| 41145 | 41145 | 97381 | DPW Maintained 3 | Acer saccharinum :: Silver Maple 273 | 1401X Broadway | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006582.71632 | 2118007.67098 | 37.796017055392205 | -122.421241857125 | (37.7960170553922, -122.421241857125) | ||||
| 49664 | 49664 | 97385 | DPW Maintained 3 | Acer saccharinum :: Silver Maple 273 | 1401X Broadway | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6006527.03038 | 2118000.68045 | 37.7959947216224 | -122.42143404497 | (37.7959947216224, -122.42143404497) | ||||
| 55992 | 55992 | 125418 | DPW Maintained 3 | Acer saccharinum :: Silver Maple 273 | 1401x Broadway | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6006653.67621 | 2118015.97458 | 37.7960438552017 | -122.42099691148199 | (37.7960438552017, -122.420996911482) | |||
| 61932 | 61932 | 97360 | DPW Maintained 3 | Acer saccharinum :: Silver Maple 273 | 1351X Broadway | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | 6007166.97772 | 2118064.11604 | 37.796204960647 | -122.419224200263 | (37.796204960647, -122.419224200263) |
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");