Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
38197 | 38197 | 218300 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 1 Ardenwood Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 8ft | 5991308.149669999 | 2096394.11086 | 37.7357990419939 | -122.472517802556 | (37.7357990419939, -122.472517802556) | |||
64746 | 64746 | 218299 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1 Ardenwood Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 8ft | 5991311.902419999 | 2096390.21304 | 37.7357885567818 | -122.472504543874 | (37.7357885567818, -122.472504543874) | |||
52332 | 52332 | 201344 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Bitting Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 2ft | 6012750.594330001 | 2092624.2153200002 | 37.7266654868035 | -122.39811796796499 | (37.7266654868035, -122.398117967965) | |||
64584 | 64584 | 201341 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Bitting Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 2ft | 6012735.10181 | 2092634.8954900003 | 37.726693949445 | -122.398172274424 | (37.726693949445, -122.398172274424) | |||
151860 | 151860 | 201339 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Bitting Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 2ft | 6012722.61322 | 2092644.3841099998 | 37.7267193076322 | -122.39821611279899 | (37.7267193076322, -122.398216112799) | |||
28431 | 28431 | 246705 | Undocumented 2 | Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 362 | 1 Bonview St | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6007711.520280001 | 2099134.96568 | 37.7442606264379 | -122.41599879791201 | (37.7442606264379, -122.415998797912) | ||||
38586 | 38586 | 246713 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1 Bonview St | 19 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | 6007763.89494 | 2099225.75212 | 37.7445128502976 | -122.415824124379 | (37.7445128502976, -122.415824124379) | ||||
45983 | 45983 | 246695 | Undocumented 2 | Persea americana :: Avocado 113 | 1 Bonview St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6007634.96405 | 2098994.37065 | 37.7438702793061 | -122.41625355785801 | (37.7438702793061, -122.416253557858) | ||||
59417 | 59417 | 246703 | Undocumented 2 | Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 362 | 1 Bonview St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6007703.57405 | 2099117.4326400002 | 37.7442120378532 | -122.416025032948 | (37.7442120378532, -122.416025032948) | ||||
60219 | 60219 | 246698 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1 Bonview St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6007671.81678 | 2099058.43431 | 37.7440482560225 | -122.41613066549401 | (37.7440482560225, -122.416130665494) | ||||
66116 | 66116 | 246710 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1 Bonview St | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6007732.83024 | 2099171.3128299997 | 37.7443616257 | -122.41592768580799 | (37.7443616257, -122.415927685808) | ||||
69716 | 69716 | 246697 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1 Bonview St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | 6007653.370080001 | 2099025.4086700003 | 37.743956537756794 | -122.41619211169201 | (37.7439565377568, -122.416192111692) | ||||
72883 | 72883 | 246708 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Bonview St | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6007726.70462 | 2099154.93537 | 37.7443163124548 | -122.41594770744 | (37.7443163124548, -122.41594770744) | ||||
74332 | 74332 | 246701 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1 Bonview St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 6007685.33931 | 2099084.9994 | 37.744121958161 | -122.41608578844401 | (37.744121958161, -122.416085788444) | ||||
115834 | 115834 | 246707 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1 Bonview St | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6007720.78655 | 2099148.69396 | 37.744298842209 | -122.415967729029 | (37.744298842209, -122.415967729029) | ||||
131406 | 131406 | 246712 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1 Bonview St | 18 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6007754.64499 | 2099212.81872 | 37.7444768180465 | -122.41585519326999 | (37.7444768180465, -122.41585519327) | ||||
147026 | 147026 | 246702 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1 Bonview St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 6007696.68665 | 2099102.8604099997 | 37.74417163851889 | -122.416047816374 | (37.7441716385189, -122.416047816374) | ||||
164784 | 164784 | 246716 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Bonview St | 22 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 45 | 6007832.06726 | 2099366.51815 | 37.744903194719704 | -122.415598362177 | (37.7449031947197, -122.415598362177) | ||||
166002 | 166002 | 246711 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Bonview St | 17 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 6007747.55824 | 2099198.25056 | 37.7444364187148 | -122.415878666471 | (37.7444364187148, -122.415878666471) | ||||
166047 | 166047 | 246709 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1 Bonview St | 15 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6007728.6595 | 2099162.64959 | 37.744337603889896 | -122.41594149403 | (37.7443376038899, -122.41594149403) | ||||
168089 | 168089 | 246700 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 Bonview St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 23 | 6007679.27037 | 2099071.40446 | 37.744084288253795 | -122.41610581094801 | (37.7440842882538, -122.416105810948) | ||||
172555 | 172555 | 246696 | Undocumented 2 | Persea americana :: Avocado 113 | 1 Bonview St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6007645.436000001 | 2099008.4718400002 | 37.7439095868695 | -122.4162183467 | (37.7439095868695, -122.4162183467) | ||||
177134 | 177134 | 246704 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Bonview St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6007707.12573 | 2099125.1145 | 37.7442333302171 | -122.416013295873 | (37.7442333302171, -122.416013295873) | ||||
182369 | 182369 | 246706 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1 Bonview St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 6007716.07 | 2099142.6271 | 37.7442819187879 | -122.415983608356 | (37.7442819187879, -122.415983608356) | ||||
2702 | 2702 | 175365 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 18 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 5ft | 5993296.25394 | 2087788.76232 | 37.712285726578 | -122.465019407322 | (37.712285726578, -122.465019407322) | |||
2703 | 2703 | 175367 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 23 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 5993394.31846 | 2087754.15211 | 37.7121963492565 | -122.464677958129 | (37.7121963492565, -122.464677958129) | |||
2705 | 2705 | 175366 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 22 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 5ft | 5993316.47827 | 2087783.2739799998 | 37.7122718230516 | -122.464949108223 | (37.7122718230516, -122.464949108223) | |||
2708 | 2708 | 175370 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 26 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 5993448.13741 | 2087722.6413599998 | 37.712112930839 | -122.464489658971 | (37.712112930839, -122.464489658971) | |||
2709 | 2709 | 175364 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 15 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 5ft | 5993263.021319999 | 2087797.41727 | 37.7123075747038 | -122.465134896479 | (37.7123075747038, -122.465134896479) | |||
2716 | 2716 | 175362 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 5993185.52762 | 2087808.44828 | 37.7123333942447 | -122.46540353654 | (37.7123333942447, -122.46540353654) | |||
2720 | 2720 | 175369 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 25 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 5ft | 5993431.63462 | 2087732.39125 | 37.7121387503812 | -122.46454740445101 | (37.7121387503812, -122.464547404451) | |||
2721 | 2721 | 175371 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 27 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 5ft | 5993471.88559 | 2087712.01586 | 37.712085124705204 | -122.464406808033 | (37.7120851247052, -122.464406808033) | |||
2722 | 2722 | 175368 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 24 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 5ft | 5993415.10175 | 2087740.6954 | 37.7121605985029 | -122.464605149022 | (37.7121605985029, -122.464605149022) | |||
49972 | 49972 | 220283 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Clarendon Ave | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 2ft | 5998403.60495 | 2104683.4410599996 | 37.7589676616433 | -122.448582957854 | (37.7589676616433, -122.448582957854) | |||
70407 | 70407 | 228111 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Clarendon Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 2ft | 5998337.908430001 | 2104673.37607 | 37.7589362690164 | -122.448809441314 | (37.7589362690164, -122.448809441314) | |||
123826 | 123826 | 228114 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Clarendon Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 2ft | 5998381.85659 | 2104680.5063 | 37.758958359952295 | -122.448657962201 | (37.7589583599523, -122.448657962201) | |||
136765 | 136765 | 228112 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Clarendon Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 2ft | 5998354.55607 | 2104676.41702 | 37.7589455706972 | -122.448752085261 | (37.7589455706972, -122.448752085261) | |||
150933 | 150933 | 228115 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Clarendon Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 2ft | 5998394.20963 | 2104681.51955 | 37.758961848437295 | -122.448615312752 | (37.7589618484373, -122.448615312752) | |||
169481 | 169481 | 228109 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Clarendon Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 2ft | 5998303.37296 | 2104669.01402 | 37.7589223169244 | -122.448928566402 | (37.7589223169244, -122.448928566402) | |||
177915 | 177915 | 228113 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Clarendon Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 2ft | 5998368.6269 | 2104678.24115 | 37.758951383917996 | -122.44870355333 | (37.758951383918, -122.44870355333) | |||
180113 | 180113 | 228110 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Clarendon Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 2ft | 5998319.578 | 2104671.21717 | 37.7589292929624 | -122.448872680737 | (37.7589292929624, -122.448872680737) | |||
2611 | 2611 | 248770 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 Cuesta Ct | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 8ft | 5999726.1375 | 2101744.56242 | 37.7509737525388 | -122.44379789365499 | (37.7509737525388, -122.443797893655) | |||
2614 | 2614 | 248773 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 Cuesta Ct | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 8ft | 5999776.82694 | 2101824.96428 | 37.751197407653706 | -122.44362838043999 | (37.7511974076537, -122.44362838044) | |||
2625 | 2625 | 248771 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 Cuesta Ct | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 8ft | 5999742.36883 | 2101773.9828 | 37.751055459558394 | -122.4437438777 | (37.7510554595584, -122.4437438777) | |||
2626 | 2626 | 248769 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 Cuesta Ct | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 8ft | 5999705.100819999 | 2101709.8291 | 37.7508771833507 | -122.443868145114 | (37.7508771833507, -122.443868145114) | |||
2629 | 2629 | 248772 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 Cuesta Ct | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | Width 8ft | 5999759.8487 | 2101799.49731 | 37.7511265131926 | -122.443685263491 | (37.7511265131926, -122.443685263491) | |||
132382 | 132382 | 132365 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1 Dicha Aly | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5998327.23711 | 2113735.99188 | 37.7838192833694 | -122.449499349909 | (37.7838192833694, -122.449499349909) | |||
31795 | 31795 | 202089 | Undocumented 2 | Prunus armeniaca :: Apricot 259 | 1 Gould St | 17 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6012847.10312 | 2091145.2908299998 | 37.722610035407904 | -122.39768065196199 | (37.7226100354079, -122.397680651962) | ||||
34346 | 34346 | 202086 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1 Gould St | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6012832.48602 | 2091118.85258 | 37.722536627341796 | -122.39772932687299 | (37.7225366273418, -122.397729326873) | ||||
47999 | 47999 | 202087 | Undocumented 2 | Prunus persica :: Peach 330 | 1 Gould St | 15 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6012840.7018099995 | 2091116.6294200001 | 37.7225309805051 | -122.397700770686 | (37.7225309805051, -122.397700770686) | ||||
62511 | 62511 | 202088 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 1 Gould St | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6012849.75876 | 2091137.38485 | 37.722588475066 | -122.397670917693 | (37.722588475066, -122.397670917693) | ||||
155235 | 155235 | 202090 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1 Gould St | 18 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | 6012861.1738 | 2091181.8351900002 | 37.7227111623612 | -122.397634574298 | (37.7227111623612, -122.397634574298) | ||||
164903 | 164903 | 201371 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1 Hare St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6018297.03999 | 2095334.9344400002 | 37.7344159629251 | -122.379132069983 | (37.7344159629251, -122.379132069983) | ||||
153281 | 153281 | 202068 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1 Hwy 101 S On Ramp | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6013001.93809 | 2090218.0162799999 | 37.7200725469917 | -122.39708043181601 | (37.7200725469917, -122.397080431816) | ||||
38273 | 38273 | 202293 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Issleib Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 2ft | 6012754.8343 | 2093244.37958 | 37.7283685671459 | -122.39814680025499 | (37.7283685671459, -122.398146800255) | |||
73712 | 73712 | 202295 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Issleib Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 2ft | 6012780.58541 | 2093228.85419 | 37.7283273718953 | -122.398056688169 | (37.7283273718953, -122.398056688169) | |||
132706 | 132706 | 202294 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Issleib Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 2ft | 6012769.019119999 | 2093237.37262 | 37.7283501175462 | -122.398097270977 | (37.7283501175462, -122.398097270977) | |||
147991 | 147991 | 202291 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Issleib Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 2ft | 6012719.32075 | 2093257.8431 | 37.728403557061895 | -122.398270517286 | (37.7284035570619, -122.398270517286) | |||
70973 | 70973 | 205373 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 Laguna Honda Blvd | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5995425.30717 | 2100166.2719900003 | 37.7463939109446 | -122.458556248673 | (37.7463939109446, -122.458556248673) | |||
147032 | 147032 | 205374 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 Laguna Honda Blvd | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 5995428.94316 | 2100162.07553 | 37.7463825974791 | -122.458543372197 | (37.7463825974791, -122.458543372197) | |||
150404 | 150404 | 237804 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Loma Vista Ter | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 6000006.51649 | 2106939.02785 | 37.7652524667463 | -122.443201354463 | (37.7652524667463, -122.443201354463) | |||
170839 | 170839 | 237803 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Loma Vista Ter | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 6000002.45309 | 2106902.83574 | 37.765152860531 | -122.44321280913601 | (37.765152860531, -122.443212809136) | |||
176936 | 176936 | 237802 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 Loma Vista Ter | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 6000002.6635 | 2106881.0655400003 | 37.765093096983705 | -122.44321051766899 | (37.7650930969837, -122.443210517669) | |||
67295 | 67295 | 250709 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 McLaren Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 4ft | 5987014.24531 | 2114847.8204200002 | 37.7862183841057 | -122.488719310471 | (37.7862183841057, -122.488719310471) | |||
178087 | 178087 | 250710 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 McLaren Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 4ft | 5987057.03847 | 2114843.86093 | 37.7862100096394 | -122.488570968169 | (37.7862100096394, -122.488570968169) | |||
35744 | 35744 | 207933 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Merced Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5995331.00373 | 2100187.61073 | 37.746447081563 | -122.458883881613 | (37.746447081563, -122.458883881613) | |||
56259 | 56259 | 207934 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Merced Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5995381.25357 | 2100216.22441 | 37.7465285358768 | -122.45871219562599 | (37.7465285358768, -122.458712195626) | |||
131145 | 131145 | 213991 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1 Merced Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 5995344.90173 | 2100199.2685 | 37.7464798897511 | -122.458836668093 | (37.7464798897511, -122.458836668093) | |||
119485 | 119485 | 250243 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1 Mulford Aly | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 0ft | 6009270.11228 | 2115820.15514 | 37.7901618096679 | -122.41178825844601 | (37.7901618096679, -122.411788258446) | |||
59248 | 59248 | 175001 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Newton St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 5ft | 6000856.019180001 | 2088342.93848 | 37.714240381459 | -122.438930350851 | (37.714240381459, -122.438930350851) | |||
148080 | 148080 | 175002 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Newton St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 5ft | 6000849.25835 | 2088363.04115 | 37.7142951942344 | -122.438955158647 | (37.7142951942344, -122.438955158647) | |||
158447 | 158447 | 175003 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Newton St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 5ft | 6000843.24005 | 2088383.1284400001 | 37.7143500070223 | -122.43897739890801 | (37.7143500070223, -122.438977398908) | |||
26075 | 26075 | 206897 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Pizarro Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5995088.9482 | 2093956.7124599998 | 37.729324653504 | -122.459269738418 | (37.729324653504, -122.459269738418) | |||
48708 | 48708 | 210982 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1 Pizarro Way | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5995118.54931 | 2093932.6722 | 37.7292603465805 | -122.459165665284 | (37.7292603465805, -122.459165665284) | |||
72425 | 72425 | 210984 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1 Pizarro Way | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5995106.2955 | 2093942.7655200001 | 37.7292873559157 | -122.459208758092 | (37.7292873559157, -122.459208758092) | |||
76009 | 76009 | 206898 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Pizarro Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5995090.77505 | 2093954.0978400002 | 37.7293175794217 | -122.459263233611 | (37.7293175794217, -122.459263233611) | |||
130353 | 130353 | 206896 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Pizarro Way | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5995094.72754 | 2093951.90742 | 37.729311792297395 | -122.459249411033 | (37.7293117922974, -122.459249411033) | |||
135763 | 135763 | 210983 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1 Pizarro Way | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5995109.5477 | 2093940.8236200002 | 37.7292822109006 | -122.459197374461 | (37.7292822109006, -122.459197374461) | |||
147202 | 147202 | 210985 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1 Pizarro Way | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5995102.57343 | 2093944.7169299999 | 37.7292925000285 | -122.45922176678499 | (37.7292925000285, -122.459221766785) | |||
152147 | 152147 | 210964 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1 Pizarro Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5995081.73888 | 2093960.6107 | 37.7293349426397 | -122.459294943706 | (37.7293349426397, -122.459294943706) | |||
158242 | 158242 | 210986 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1 Pizarro Way | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5995099.57616 | 2093947.59024 | 37.7293002171239 | -122.45923233653 | (37.7293002171239, -122.45923233653) | |||
182357 | 182357 | 206895 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Pizarro Way | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5995113.71049 | 2093937.45787 | 37.729273208687204 | -122.459182739799 | (37.7292732086872, -122.459182739799) | |||
25380 | 25380 | 124656 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1 Presidio Ter | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 7ft | 5995441.43994 | 2115441.36584 | 37.7883362746058 | -122.45960662195401 | (37.7883362746058, -122.459606621954) | |||
27474 | 27474 | 183607 | Undocumented 2 | :: 54 | 1 Quintara St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989903.61 | 2101103.2452 | 37.748647706091596 | -122.477717911497 | (37.7486477060916, -122.477717911497) | |||
29003 | 29003 | 211592 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1 San Fernando Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 8ft | 5992116.4659 | 2096423.88969 | 37.7359275605095 | -122.46972532938801 | (37.7359275605095, -122.469725329388) | |||
48143 | 48143 | 208054 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1 San Fernando Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 8ft | 5992102.39322 | 2096463.5019599998 | 37.736035512423 | -122.46977686683 | (37.736035512423, -122.46977686683) | |||
168332 | 168332 | 211593 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1 San Fernando Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 8ft | 5992107.01458 | 2096453.37497 | 37.736007973377205 | -122.469760152022 | (37.7360079733772, -122.469760152022) | |||
24641 | 24641 | 203805 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 San Marcos Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 4ft | 5993891.16391 | 2100082.05221 | 37.7460743755414 | -122.463854985838 | (37.7460743755414, -122.463854985838) | |||
30886 | 30886 | 203804 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 San Marcos Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 4ft | 5993878.73057 | 2100098.05602 | 37.746117601451104 | -122.463899139836 | (37.7461176014511, -122.463899139836) | |||
39955 | 39955 | 203806 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 San Marcos Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | Width 4ft | 5993903.6097099995 | 2100066.65342 | 37.746032811564795 | -122.463810832713 | (37.7460328115648, -122.463810832713) | |||
176940 | 176940 | 212100 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 San Marcos Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 4ft | 5993916.201859999 | 2100058.21492 | 37.746010367202004 | -122.46376667868499 | (37.746010367202, -122.463766678685) | |||
69786 | 69786 | 212402 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 San Rafael Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5991904.19278 | 2095912.91043 | 37.734512268621295 | -122.470422033273 | (37.7345122686213, -122.470422033273) | |||
172302 | 172302 | 212403 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 San Rafael Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 5991902.57817 | 2095944.2843799999 | 37.734598320237296 | -122.470429899615 | (37.7345983202373, -122.470429899615) | |||
174012 | 174012 | 212401 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1 San Rafael Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5991904.4182 | 2095887.6067400002 | 37.7344428040878 | -122.470419411726 | (37.7344428040878, -122.470419411726) | |||
36481 | 36481 | 208402 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Santa Monica Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993357.048219999 | 2097424.8281 | 37.7387475142763 | -122.465508869638 | (37.7387475142763, -122.465508869638) | |||
45777 | 45777 | 208399 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Santa Monica Way | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993307.585030001 | 2097392.18535 | 37.7386550325134 | -122.465677517719 | (37.7386550325134, -122.465677517719) | |||
56803 | 56803 | 208398 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Santa Monica Way | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993287.0539 | 2097380.91654 | 37.7386229069136 | -122.46574768551201 | (37.7386229069136, -122.465747685512) | |||
69095 | 69095 | 208401 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Santa Monica Way | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993334.34485 | 2097411.8322900003 | 37.738710521577794 | -122.46558642267901 | (37.7387105215778, -122.465586422679) | |||
172090 | 172090 | 208400 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Santa Monica Way | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993318.88533 | 2097404.7115700003 | 37.738690078178 | -122.46563935676599 | (37.738690078178, -122.465639356766) | |||
35801 | 35801 | 215481 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5994138.58821 | 2097841.54459 | 37.739936758872204 | -122.462836916405 | (37.7399367588722, -122.462836916405) |
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");