Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: PlantType, qCaretaker, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19459 | 19459 | 15076 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1 Minerva St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 11 | 5995952.59829 | 2089005.6317099999 | 37.7157797770894 | -122.455926258705 | (37.7157797770894, -122.455926258705) | |||
| 21404 | 21404 | 15067 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1 Minerva St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 11 | 5996019.74584 | 2089003.9616 | 37.7157790450506 | -122.455694046564 | (37.7157790450506, -122.455694046564) | |||
| 111961 | 111961 | 1 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 10 10th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 16 | 5992719.40718 | 2114869.71245 | 37.7866097734767 | -122.46898271049601 | (37.7866097734767, -122.468982710496) | |||
| 17205 | 17205 | 26909 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 10 Caine Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 10 | 5997629.54091 | 2089680.9775599998 | 37.71773022584279 | -122.45017865014299 | (37.7177302258428, -122.450178650143) | |||
| 17237 | 17237 | 26912 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 10 Caine Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 10 | 5997598.31865 | 2089637.50605 | 37.7176090763688 | -122.450283439137 | (37.7176090763688, -122.450283439137) | |||
| 19068 | 19068 | 26911 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 10 Caine Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 10 | 5997609.86555 | 2089654.4499099997 | 37.7176562610968 | -122.450244747607 | (37.7176562610968, -122.450244747607) | |||
| 19083 | 19083 | 26913 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 10 Caine Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 10 | 5997584.35365 | 2089616.43233 | 37.717550413599795 | -122.45033019131 | (37.7175504135998, -122.45033019131) | |||
| 19195 | 19195 | 26910 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 10 Caine Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 5997620.43146 | 2089669.0920400003 | 37.7176970696553 | -122.45020928103399 | (37.7176970696553, -122.450209281034) | |||
| 19203 | 19203 | 26914 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 10 Caine Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 5997577.15723 | 2089606.82913 | 37.7175236335794 | -122.45035437405599 | (37.7175236335794, -122.450354374056) | |||
| 19342 | 19342 | 26905 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 10 Caine Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 5997683.40035 | 2089758.8108400002 | 37.7179470200262 | -122.449998089654 | (37.7179470200262, -122.449998089654) | |||
| 19833 | 19833 | 26915 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 10 Caine Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/26/1999 12:00:00 AM | 3 | 10 | 5997570.4467 | 2089598.1443599998 | 37.7174994031582 | -122.450376943463 | (37.7174994031582, -122.450376943463) | ||
| 20603 | 20603 | 26906 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 10 Caine Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 10 | 5997668.873459999 | 2089736.17467 | 37.717884035095295 | -122.450046671911 | (37.7178840350953, -122.450046671911) | |||
| 21305 | 21305 | 26908 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 10 Caine Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 10 | 5997639.65043 | 2089696.09364 | 37.7177723096208 | -122.45014479517 | (37.7177723096208, -122.45014479517) | |||
| 21645 | 21645 | 26907 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 10 Caine Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 10 | 5997653.71656 | 2089718.57825 | 37.717834852078205 | -122.45009779478701 | (37.7178348520782, -122.450097794787) | |||
| 17252 | 17252 | 24963 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004800.736959999 | 2107633.50365 | 37.7674315357679 | -122.42666873508999 | (37.7674315357679, -122.42666873509) | |||
| 19333 | 19333 | 24968 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Dolores St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004810.58196 | 2107534.1310400004 | 37.767159239034704 | -122.426627605497 | (37.7671592390347, -122.426627605497) | |||
| 19334 | 19334 | 24962 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2005 12:00:00 AM | 30 | 20 | 6004805.8872 | 2107667.07109 | 37.76752399506629 | -122.42665331171999 | (37.7675239950663, -122.42665331172) | ||
| 19826 | 19826 | 24965 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004804.04595 | 2107595.6918 | 37.767327900586 | -122.42665459683799 | (37.767327900586, -122.426654596838) | |||
| 20452 | 20452 | 24966 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Dolores St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004812.73188 | 2107584.41194 | 37.76729741985871 | -122.426623750096 | (37.7672974198587, -122.426623750096) | |||
| 22009 | 22009 | 24961 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2005 12:00:00 AM | 90 | 20 | 6004800.95891 | 2107734.51921 | 37.76770891277079 | -122.42667516163999 | (37.7677089127708, -122.42667516164) | ||
| 84722 | 84722 | 8291 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 Garcia Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 5995006.6013281 | 2099280.197711 | 37.743936899881 | -122.45993989851101 | (37.743936899881, -122.459939898511) | |||
| 87594 | 87594 | 8293 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 Garcia Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 8 | 5995006.6013281 | 2099280.197711 | 37.743936899881 | -122.45993989851101 | (37.743936899881, -122.459939898511) | |||
| 95088 | 95088 | 8292 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 Garcia Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 5995006.6013281 | 2099280.197711 | 37.743936899881 | -122.45993989851101 | (37.743936899881, -122.459939898511) | |||
| 117295 | 117295 | 8294 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 Garcia Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 8 | 5995006.6013281 | 2099280.197711 | 37.743936899881 | -122.45993989851101 | (37.743936899881, -122.459939898511) | |||
| 128632 | 128632 | 8295 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 Garcia Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 8 | 5995006.6013281 | 2099280.197711 | 37.743936899881 | -122.45993989851101 | (37.743936899881, -122.459939898511) | |||
| 9933 | 9933 | 11201 | DPW Maintained 3 | Taxus baccata :: Irish Yew 241 | 100 Idora Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8 | 5995318.65927 | 2099418.1217 | 37.7443335470614 | -122.458870864793 | (37.7443335470614, -122.458870864793) | |||
| 18799 | 18799 | 11188 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 100 Idora Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 8 | 5995291.088769999 | 2099424.10153 | 37.7443483813689 | -122.45896663000299 | (37.7443483813689, -122.458966630003) | |||
| 18983 | 18983 | 11186 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 100 Idora Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 5995298.39303 | 2099423.25523 | 37.7443464775133 | -122.458941312315 | (37.7443464775133, -122.458941312315) | |||
| 20854 | 20854 | 11187 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 Idora Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 5995309.2253 | 2099420.08132 | 37.7443383854121 | -122.458903627104 | (37.7443383854121, -122.458903627104) | |||
| 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) | |||
| 9748 | 9748 | 173655 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 100 Lawton St | 1 | Median : Cutout 11 | Tree 1 | DPW for City Agency 10 | ||||||||||
| 81526 | 81526 | 103927 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/05/2001 12:00:00 AM | 4x4 | 6014859.0 | 2117030.0 | 37.793795709183996 | -122.392535650186 | (37.793795709184, -122.392535650186) | |||
| 129305 | 129305 | 3752 | DPW Maintained 3 | Acer spp :: Maple 158 | 1000 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 18 | 6012438.0377853 | 2103297.9664682 | 37.755955933673 | -122.399947693157 | (37.755955933673, -122.399947693157) | |||
| 17834 | 17834 | 16381 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1000 Moraga St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 12 | 5991038.119519999 | 2103837.44782 | 37.7562208847883 | -122.47399428791799 | (37.7562208847883, -122.473994287918) | |||
| 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) | |||
| 1529 | 1529 | 251578 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000X Columbus Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | ||||||||||
| 1851 | 1851 | 4718 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000X Columbus Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 3 | 6008205.1504 | 2120957.4944 | 37.804207866952204 | -122.415836885075 | (37.8042078669522, -122.415836885075) | |||
| 5299 | 5299 | 4716 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000X Columbus Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 3 | 6008306.8566 | 2120868.0824 | 37.803968081269204 | -122.415478587922 | (37.8039680812692, -122.415478587922) | |||
| 6099 | 6099 | 4714 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000X Columbus Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 80 | 3 | 6008373.9156 | 2120808.2881 | 37.8038076701269 | -122.415242289828 | (37.8038076701269, -122.415242289828) | |||
| 6383 | 6383 | 4717 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000X Columbus Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/19/2006 12:00:00 AM | 6 | 3 | 6008242.0329 | 2120925.0825 | 37.804120945419 | -122.415706953629 | (37.804120945419, -122.415706953629) | ||
| 8454 | 8454 | 4715 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000X Columbus Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/19/2006 12:00:00 AM | 6 | 3 | 6008330.3273 | 2120843.4941 | 37.803901887177204 | -122.415395624015 | (37.8039018871772, -122.415395624015) | ||
| 124851 | 124851 | 4719 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 1000X Columbus Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 3 | 6008486.129587 | 2120728.7244 | 37.803595514004 | -122.41484833114401 | (37.803595514004, -122.414848331144) | |||
| 17056 | 17056 | 25058 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000X Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005092.48697 | 2102458.1018 | 37.753237594341996 | -122.425291287561 | (37.753237594342, -122.425291287561) | |||
| 17162 | 17162 | 25069 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000X Dolores St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005114.64614 | 2102050.12648 | 37.752118640770995 | -122.42518562892599 | (37.752118640771, -122.425185628926) | |||
| 17262 | 17262 | 25065 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000X Dolores St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 20 | 6005108.04672 | 2102186.2977 | 37.7524921625065 | -122.42521813940901 | (37.7524921625065, -122.425218139409) | |||
| 17722 | 17722 | 25061 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000X Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005097.79962 | 2102345.06954 | 37.7529275341834 | -122.425264872687 | (37.7529275341834, -122.425264872687) | |||
| 17966 | 17966 | 25063 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000X Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005101.20924 | 2102268.05958 | 37.7527162753581 | -122.42524760211501 | (37.7527162753581, -122.425247602115) | |||
| 18277 | 18277 | 25059 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 20 | 6005094.91106 | 2102418.8508099997 | 37.7531299572042 | -122.425280111693 | (37.7531299572042, -122.425280111693) | |||
| 18812 | 18812 | 25066 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000X Dolores St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6005105.419480001 | 2102158.55982 | 37.7524158523077 | -122.425225251269 | (37.7524158523077, -122.425225251269) | |||
| 20631 | 20631 | 25060 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1000X Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 20 | 6005096.113419999 | 2102391.61943 | 37.7530552540956 | -122.425274016077 | (37.7530552540956, -122.425274016077) | |||
| 21757 | 21757 | 25064 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000X Dolores St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 20 | 6005102.4225699995 | 2102227.07793 | 37.7526038178156 | -122.425240490271 | (37.7526038178156, -122.425240490271) | |||
| 22227 | 22227 | 25067 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 1000X Dolores St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 20 | 6005110.57075 | 2102123.34784 | 37.7523194593995 | -122.425204931964 | (37.7523194593995, -122.425204931964) | |||
| 18919 | 18919 | 110775 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000X GUERRERO ST | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/26/2015 02:57:00 PM | 3 | 3x3 | 6005663.0 | 2103080.0 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | ||
| 80233 | 80233 | 110778 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000X GUERRERO ST | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/26/2015 02:43:00 PM | 3 | 3x3 | 6005663.0 | 2103080.0 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | ||
| 80584 | 80584 | 110774 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000X GUERRERO ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/26/2015 03:02:00 PM | 3 | 3x3 | 6005663.0 | 2103080.0 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | ||
| 82047 | 82047 | 110777 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000X GUERRERO ST | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/26/2015 02:47:00 PM | 3 | 3x3 | 6005663.0 | 2103080.0 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | ||
| 93547 | 93547 | 110779 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000X GUERRERO ST | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/26/2015 02:35:00 PM | 3 | 3x3 | 6005663.0 | 2103080.0 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | ||
| 97980 | 97980 | 110776 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000X GUERRERO ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/26/2015 02:53:00 PM | 3 | 3x3 | 6005663.0 | 2103080.0 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | ||
| 102576 | 102576 | 110781 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000X GUERRERO ST | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/26/2015 02:26:00 PM | 3 | 3x3 | 6005663.0 | 2103080.0 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | ||
| 114885 | 114885 | 110772 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000X GUERRERO ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/26/2015 03:10:00 PM | 3 | 3x3 | 6005663.0 | 2103080.0 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | ||
| 121580 | 121580 | 110782 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000X GUERRERO ST | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/26/2015 02:21:00 PM | 3 | 3x3 | 6005663.0 | 2103080.0 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | ||
| 124792 | 124792 | 110780 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000X GUERRERO ST | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/26/2015 02:30:00 PM | 3 | 3x3 | 6005663.0 | 2103080.0 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | ||
| 139744 | 139744 | 110783 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000X GUERRERO ST | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/26/2015 02:16:00 PM | 3 | 3x3 | 6005663.0 | 2103080.0 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | ||
| 141015 | 141015 | 110784 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000X GUERRERO ST | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/26/2015 02:11:00 PM | 3 | 3x3 | 6005663.0 | 2103080.0 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | ||
| 144929 | 144929 | 110773 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000X GUERRERO ST | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/26/2015 03:06:00 PM | 3 | 3x3 | 6005663.0 | 2103080.0 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | ||
| 113490 | 113490 | 114590 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1000X MORAGA ST | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 12 | 5991075.0 | 2103884.0 | 37.7563508410106 | -122.47387013998001 | (37.7563508410106, -122.47387013998) | |||
| 17715 | 17715 | 16378 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000X Moraga St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 12 | 5991088.16435 | 2103840.65792 | 37.756232597572605 | -122.473821451692 | (37.7562325975726, -122.473821451692) | |||
| 80270 | 80270 | 29312 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000X Portola Dr | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/27/2016 01:16:00 PM | 3 | 3X3 | 5995989.04111 | 2098439.8270093002 | 37.74168590277029 | -122.456482111076 | (37.7416859027703, -122.456482111076) | ||
| 81096 | 81096 | 29303 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000X Portola Dr | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/23/2014 12:00:00 AM | 3 | 3X3 | 5995989.04111 | 2098439.8270093002 | 37.74168590277029 | -122.456482111076 | (37.7416859027703, -122.456482111076) | ||
| 87052 | 87052 | 29305 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000X Portola Dr | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5995989.04111 | 2098439.8270093002 | 37.74168590277029 | -122.456482111076 | (37.7416859027703, -122.456482111076) | ||
| 91761 | 91761 | 29302 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000X Portola Dr | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5995989.04111 | 2098439.8270093002 | 37.74168590277029 | -122.456482111076 | (37.7416859027703, -122.456482111076) | ||
| 95836 | 95836 | 29310 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000X Portola Dr | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5995989.04111 | 2098439.8270093002 | 37.74168590277029 | -122.456482111076 | (37.7416859027703, -122.456482111076) | ||
| 100870 | 100870 | 29309 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000X Portola Dr | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/25/2014 12:00:00 AM | 3 | 3X3 | 5995989.04111 | 2098439.8270093002 | 37.74168590277029 | -122.456482111076 | (37.7416859027703, -122.456482111076) | ||
| 108929 | 108929 | 29308 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000X Portola Dr | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5995989.04111 | 2098439.8270093002 | 37.74168590277029 | -122.456482111076 | (37.7416859027703, -122.456482111076) | ||
| 110045 | 110045 | 29301 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000X Portola Dr | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5995989.04111 | 2098439.8270093002 | 37.74168590277029 | -122.456482111076 | (37.7416859027703, -122.456482111076) | ||
| 112838 | 112838 | 29307 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000X Portola Dr | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5995989.04111 | 2098439.8270093002 | 37.74168590277029 | -122.456482111076 | (37.7416859027703, -122.456482111076) | ||
| 117140 | 117140 | 29298 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000X Portola Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/27/2016 01:33:00 PM | 3 | 3X3 | 5995989.04111 | 2098439.8270093002 | 37.74168590277029 | -122.456482111076 | (37.7416859027703, -122.456482111076) | ||
| 119457 | 119457 | 29300 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000X Portola Dr | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5995989.04111 | 2098439.8270093002 | 37.74168590277029 | -122.456482111076 | (37.7416859027703, -122.456482111076) | ||
| 139242 | 139242 | 29304 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000X Portola Dr | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/23/2014 12:00:00 AM | 3 | 3X3 | 5995989.04111 | 2098439.8270093002 | 37.74168590277029 | -122.456482111076 | (37.7416859027703, -122.456482111076) | ||
| 139984 | 139984 | 29306 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000X Portola Dr | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/27/2016 01:19:00 PM | 3 | 3X3 | 5995989.04111 | 2098439.8270093002 | 37.74168590277029 | -122.456482111076 | (37.7416859027703, -122.456482111076) | ||
| 140081 | 140081 | 29311 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000X Portola Dr | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/03/2014 12:00:00 AM | 3 | 3X3 | 5995989.04111 | 2098439.8270093002 | 37.74168590277029 | -122.456482111076 | (37.7416859027703, -122.456482111076) | ||
| 146106 | 146106 | 29299 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000X Portola Dr | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/27/2016 01:24:00 PM | 3 | 3X3 | 5995989.04111 | 2098439.8270093002 | 37.74168590277029 | -122.456482111076 | (37.7416859027703, -122.456482111076) | ||
| 83861 | 83861 | 19426 | DPW Maintained 3 | Eucalyptus lehmanni :: Bushy Yate 267 | 1000X Sloat Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5988569.2838063 | 2095968.4634055 | 37.7344714144349 | -122.481955851921 | (37.7344714144349, -122.481955851921) | |||
| 104159 | 104159 | 19424 | DPW Maintained 3 | Eucalyptus lehmanni :: Bushy Yate 267 | 1000X Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 20 | 5988569.2838063 | 2095968.4634055 | 37.7344714144349 | -122.481955851921 | (37.7344714144349, -122.481955851921) | |||
| 122200 | 122200 | 19427 | DPW Maintained 3 | Eucalyptus lehmanni :: Bushy Yate 267 | 1000X Sloat Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5988569.2838063 | 2095968.4634055 | 37.7344714144349 | -122.481955851921 | (37.7344714144349, -122.481955851921) | |||
| 122760 | 122760 | 19425 | DPW Maintained 3 | Eucalyptus lehmanni :: Bushy Yate 267 | 1000X Sloat Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5988569.2838063 | 2095968.4634055 | 37.7344714144349 | -122.481955851921 | (37.7344714144349, -122.481955851921) | |||
| 115847 | 115847 | 23311 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | Private 1 | 11/18/2010 12:00:00 AM | 6 | 3X3 | 6006537.8278087005 | 2113902.4302931 | 37.7847425526754 | -122.421105541385 | (37.7847425526754, -122.421105541385) | ||
| 127717 | 127717 | 23312 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/18/2010 12:00:00 AM | 6 | 3X3 | 6006537.8278087005 | 2113902.4302931 | 37.7847425526754 | -122.421105541385 | (37.7847425526754, -122.421105541385) | ||
| 53388 | 53388 | 137760 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1000x DIVISADERO ST | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001423.7559 | 2112018.8276 | 37.7792810387103 | -122.438663489904 | (37.7792810387103, -122.438663489904) | |||
| 63089 | 63089 | 137761 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1000x DIVISADERO ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001442.3691 | 2111886.1663 | 37.7789178432038 | -122.43858959128299 | (37.7789178432038, -122.438589591283) | |||
| 67396 | 67396 | 137764 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1000x DIVISADERO ST | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001436.616 | 2111937.2679 | 37.7790578279952 | -122.438613156035 | (37.7790578279952, -122.438613156035) | |||
| 138085 | 138085 | 137763 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1000x DIVISADERO ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001437.9696 | 2111922.039 | 37.77901609029121 | -122.438607381917 | (37.7790160902912, -122.438607381917) | |||
| 154554 | 154554 | 137759 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1000x DIVISADERO ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001427.817000001 | 2112000.5528 | 37.7792310917629 | -122.438648131089 | (37.7792310917629, -122.438648131089) | |||
| 165225 | 165225 | 137749 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1000x DIVISADERO ST | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001417.6643 | 2112072.2982 | 37.7794275088949 | -122.438688395719 | (37.7794275088949, -122.438688395719) | |||
| 172170 | 172170 | 137762 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1000x DIVISADERO ST | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001439.6617 | 2111903.7642 | 37.7789660085719 | -122.438600218498 | (37.7789660085719, -122.438600218498) | |||
| 179995 | 179995 | 137750 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1000x DIVISADERO ST | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001422.0638 | 2112046.2398 | 37.779356209408995 | -122.43867130831 | (37.779356209409, -122.43867130831) | |||
| 34286 | 34286 | 221545 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005721.87722 | 2103062.7074700003 | 37.754933239094704 | -122.423157698184 | (37.7549332390947, -122.423157698184) | |||
| 67326 | 67326 | 221557 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005743.02813 | 2102638.73526 | 37.7537703032837 | -122.42305441913099 | (37.7537703032837, -122.423054419131) | |||
| 68227 | 68227 | 221553 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6005734.111409999 | 2102791.4847 | 37.7541892146839 | -122.42309611170799 | (37.7541892146839, -122.423096111708) | |||
| 76663 | 76663 | 221554 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1000x Guerrero St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 6005736.5559 | 2102753.56312 | 37.754085228758505 | -122.423084962814 | (37.7540852287585, -122.423084962814) |
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");