Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189026 | 189026 | 248177 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 218 Esmeralda Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6007380.96811 | 2098703.14115 | 37.743056342490796 | -122.417111187331 | (37.7430563424908, -122.417111187331) | ||||
| 189014 | 189014 | 209015 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 412 Baden St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6000779.78636 | 2095479.1538 | 37.73383046469421 | -122.439705146498 | (37.7338304646942, -122.439705146498) | ||||
| 188928 | 188928 | 248190 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 216 Esmeralda Ave | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6007395.06383 | 2098734.36623 | 37.7431428725527 | -122.41706466002701 | (37.7431428725527, -122.417064660027) | ||||
| 188746 | 188746 | 136606 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 3798 Webster St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 5ft | 6002550.09467 | 2121664.33857 | 37.8058291364749 | -122.43545720778799 | (37.8058291364749, -122.435457207788) | |||
| 188553 | 188553 | 246628 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 3300 Harrison St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6009031.72375 | 2099369.08818 | 37.7449776127301 | -122.411450337281 | (37.7449776127301, -122.411450337281) | ||||
| 188399 | 188399 | 187546 | Undocumented 2 | Schinus molle :: California Pepper 138 | 1399 Somerset St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6011366.67431 | 2088362.22575 | 37.7148857547405 | -122.402602582141 | (37.7148857547405, -122.402602582141) | ||||
| 188376 | 188376 | 248091 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 14 Montcalm St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 6010638.35138 | 2100271.0907099997 | 37.747544299426295 | -122.405958412248 | (37.7475442994263, -122.405958412248) | ||||
| 188250 | 188250 | 245744 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 24 Saturn St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | Width 3ft | 6000500.5382900005 | 2106017.92887 | 37.762751514198705 | -122.441426555002 | (37.7627515141987, -122.441426555002) | |||
| 188202 | 188202 | 248243 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 296 Esmeralda Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6006794.0541900005 | 2099005.53684 | 37.743853618456995 | -122.41916202653299 | (37.743853618457, -122.419162026533) | ||||
| 188108 | 188108 | 247870 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 394 Mayflower St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 6009721.06953 | 2098395.0417 | 37.74234173489771 | -122.40899798048099 | (37.7423417348977, -122.408997980481) | ||||
| 188033 | 188033 | 226640 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 10 Crescent Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 3ft | 6005282.96903 | 2095902.7994400002 | 37.7352489878562 | -122.42416639485799 | (37.7352489878562, -122.424166394858) | |||
| 188021 | 188021 | 136609 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 3798 Webster St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | Width 4ft | 6002557.10875 | 2121672.73918 | 37.805852600677795 | -122.435433535844 | (37.8058526006778, -122.435433535844) | |||
| 187893 | 187893 | 130609 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1500 Beach St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 6002918.83172 | 2121356.11513 | 37.80500377108171 | -122.43415909039699 | (37.8050037710817, -122.434159090397) | ||||
| 187806 | 187806 | 132199 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2836 Larkin St | 14 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 6006498.02761 | 2121046.57665 | 37.8043563455331 | -122.42175085543998 | (37.8043563455331, -122.42175085544) | ||||
| 187720 | 187720 | 249956 | Undocumented 2 | Phoenix dactylifera :: Date Palm 65 | 285 Filbert St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | Width 0ft | 6011495.629790001 | 2120073.57822 | 37.8019652829314 | -122.404387612316 | (37.8019652829314, -122.404387612316) | |||
| 187659 | 187659 | 203390 | Undocumented 2 | Acer palmatum 'Bloodgood' :: Bloodgood Japanese Maple 305 | 747 Detroit St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 5999418.77768 | 2095445.8952400002 | 37.733661583696396 | -122.44440815651899 | (37.7336615836964, -122.444408156519) | ||||
| 187624 | 187624 | 248183 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 216 Esmeralda Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 43 | 6007446.150909999 | 2098698.08371 | 37.743046122577894 | -122.416885444016 | (37.7430461225779, -122.416885444016) | ||||
| 187457 | 187457 | 248048 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 38 Rutledge St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6010518.28913 | 2099442.3918 | 37.7452621573156 | -122.406315202106 | (37.7452621573156, -122.406315202106) | ||||
| 187449 | 187449 | 196192 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2198 Revere Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6011951.07495 | 2096769.0187900001 | 37.7380016885201 | -122.40117301982 | (37.7380016885201, -122.40117301982) | ||||
| 187182 | 187182 | 247984 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 497 Peralta Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6009751.76686 | 2099644.8640900003 | 37.745775193576705 | -122.408980002136 | (37.7457751935767, -122.408980002136) | ||||
| 186554 | 186554 | 250195 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 201 Union St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | Width 0ft | 6011875.28376 | 2119779.56963 | 37.8011792152183 | -122.40305313080401 | (37.8011792152183, -122.403053130804) | |||
| 186431 | 186431 | 211852 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 714 Detroit St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 5999466.29609 | 2095415.22212 | 37.7335800736498 | -122.44424166861602 | (37.7335800736498, -122.444241668616) | ||||
| 186272 | 186272 | 223809 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 6 Miguel St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 34 | 6003330.909440001 | 2097346.2966299998 | 37.7391020890899 | -122.431018368229 | (37.7391020890899, -122.431018368229) | ||||
| 186195 | 186195 | 196068 | Undocumented 2 | Prunus spp :: Cherry 84 | 1700 Armstrong Ave | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6013885.20395 | 2092887.6121599998 | 37.727451852204204 | -122.39421406314399 | (37.7274518522042, -122.394214063144) | ||||
| 185900 | 185900 | 201701 | Undocumented 2 | Acacia decurrens :: Acacia: Silver Wattle 181 | 43 Gilroy St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | Width 0ft | 6015213.19192 | 2088555.8526400002 | 37.71563141862261 | -122.389320803321 | (37.7156314186226, -122.389320803321) | |||
| 185796 | 185796 | 214455 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 449 Baden St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | Width 8ft | 6000738.084840001 | 2095503.40232 | 37.733894671806 | -122.439851058803 | (37.733894671806, -122.439851058803) | |||
| 185405 | 185405 | 201614 | Undocumented 2 | Gleditsia triacanthos :: Honey Locust 67 | 98 Jerrold Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | Width 4ft | 6020747.34365 | 2092993.8196 | 37.728122515333396 | -122.370498661104 | (37.7281225153334, -122.370498661104) | |||
| 185208 | 185208 | 247934 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1099 Esmeralda Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6010311.02519 | 2098743.98721 | 37.7433328939103 | -122.406982672633 | (37.7433328939103, -122.406982672633) | ||||
| 184976 | 184976 | 214230 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 714 Detroit St | 20 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5999463.98385 | 2095461.59315 | 37.7337072656774 | -122.444252993784 | (37.7337072656774, -122.444252993784) | ||||
| 184674 | 184674 | 126416 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2836 Larkin St | 12 | Side Yard : Yard 17 | Tree 1 | Private 1 | 46 | 6006501.512069999 | 2121012.26216 | 37.804262323204895 | -122.421736358356 | (37.8042623232049, -122.421736358356) | ||||
| 184465 | 184465 | 247901 | Undocumented 2 | Robinia pseudoacacia :: Black Locust 169 | 353 Mayflower St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6009990.60603 | 2098394.2697099997 | 37.7423547103086 | -122.408065946488 | (37.7423547103086, -122.408065946488) | ||||
| 184457 | 184457 | 250222 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 312 Filbert St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | Width 0ft | 6011281.01551 | 2120075.58607 | 37.8019588006185 | -122.40513042444701 | (37.8019588006185, -122.405130424447) | |||
| 184390 | 184390 | 178694 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 184 Mount Vernon Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 5998957.82756 | 2089383.479 | 37.7169892861082 | -122.44556599497801 | (37.7169892861082, -122.445565994978) | ||||
| 184292 | 184292 | 247887 | Undocumented 2 | Cercis occidentalis :: Western Redbud 246 | 360 Mayflower St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6009991.26305 | 2098380.13852 | 37.7423159459174 | -122.408062678348 | (37.7423159459174, -122.408062678348) | ||||
| 184220 | 184220 | 247977 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 501 Peralta Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 34 | 6009780.56598 | 2099401.3305099998 | 37.7451081169387 | -122.408863239563 | (37.7451081169387, -122.408863239563) | ||||
| 184178 | 184178 | 201613 | Undocumented 2 | Gleditsia triacanthos :: Honey Locust 67 | 98 Jerrold Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | Width 4ft | 6020763.58395 | 2092982.86481 | 37.728093326933205 | -122.370441760089 | (37.7280933269332, -122.370441760089) | |||
| 184172 | 184172 | 178271 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 35 Tomaso Ct | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | Width 3ft | 6009176.170940001 | 2086260.2904299998 | 37.7089917311415 | -122.41002561149901 | (37.7089917311415, -122.410025611499) | |||
| 184037 | 184037 | 247875 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 388 Mayflower St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6009902.15427 | 2098392.46906 | 37.742344813273604 | -122.408371660244 | (37.7423448132736, -122.408371660244) | ||||
| 184006 | 184006 | 248223 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 70 Fair Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6007150.20605 | 2099339.87769 | 37.744791694087 | -122.417954229812 | (37.744791694087, -122.417954229812) | ||||
| 183929 | 183929 | 125339 | Undocumented 2 | Acer macrophyllum :: Big Leaf Maple 159 | 943 Green St | 14 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | 6008681.4461 | 2118995.9175299997 | 37.7988486311296 | -122.414049766478 | (37.7988486311296, -122.414049766478) | ||||
| 183614 | 183614 | 247888 | Undocumented 2 | Cercis occidentalis :: Western Redbud 246 | 360 Mayflower St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | 6009996.89336 | 2098378.14108 | 37.7423107766219 | -122.408043069531 | (37.7423107766219, -122.408043069531) | ||||
| 183449 | 183449 | 190390 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1750 22nd St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 6012854.72935 | 2103804.1749299997 | 37.7573690942352 | -122.39854214671699 | (37.7573690942352, -122.398542146717) | ||||
| 183364 | 183364 | 247818 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1058 Jarboe Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 46 | 6009634.533480001 | 2096844.3676599998 | 37.738079072495395 | -122.409187798594 | (37.7380790724954, -122.409187798594) | ||||
| 183336 | 183336 | 247915 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 399 Franconia St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6009998.26355 | 2098850.98079 | 37.7436091683313 | -122.40807167067899 | (37.7436091683313, -122.408071670679) | ||||
| 183252 | 183252 | 249775 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 102 Pfeiffer St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 21 | Width 0ft | 6010401.04426 | 2121152.2311400003 | 37.8048657692012 | -122.40825153418999 | (37.8048657692012, -122.40825153419) | |||
| 183132 | 183132 | 195994 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2101 Newcomb Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | Width 3ft | 6012438.11131 | 2097750.05558 | 37.74072256758821 | -122.39955794174999 | (37.7407225675882, -122.39955794175) | |||
| 182795 | 182795 | 177819 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 35 Tomaso Ct | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | Width 3ft | 6009193.28856 | 2086304.97531 | 37.709115386123 | -122.40996960262501 | (37.709115386123, -122.409969602625) | |||
| 182693 | 182693 | 187780 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 230 Middle Point Rd | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 6ft | 6018250.04699 | 2096453.9006400001 | 37.7374858320104 | -122.379372242948 | (37.7374858320104, -122.379372242948) | |||
| 182687 | 182687 | 247952 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 7 Joy St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6010434.68219 | 2098863.51365 | 37.7436680064839 | -122.40656351750799 | (37.7436680064839, -122.406563517508) | ||||
| 182626 | 182626 | 195078 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 Indiana St | 20 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | Width 4ft | 6014987.06432 | 2103267.10016 | 37.7560129651346 | -122.391130089079 | (37.7560129651346, -122.391130089079) | |||
| 182600 | 182600 | 209016 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 412 Baden St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | 6000787.61929 | 2095495.57167 | 37.7338759901863 | -122.43967924239901 | (37.7338759901863, -122.439679242399) | ||||
| 182532 | 182532 | 247879 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 388 Mayflower St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6009924.148030001 | 2098382.32436 | 37.7423181897436 | -122.408294896795 | (37.7423181897436, -122.408294896795) | ||||
| 182461 | 182461 | 205446 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 300 Melrose Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | 5998064.66474 | 2095546.64669 | 37.73386086896821 | -122.449096955455 | (37.7338608689682, -122.449096955455) | ||||
| 182436 | 182436 | 204570 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 404 Baden St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6000772.023709999 | 2095261.55097 | 37.733232536033 | -122.43971638892 | (37.733232536033, -122.43971638892) | ||||
| 182365 | 182365 | 201726 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1411 Phelps St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6013752.92787 | 2095946.3891599998 | 37.735843275152995 | -122.394885479886 | (37.735843275153, -122.394885479886) | ||||
| 182306 | 182306 | 247982 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 499 Peralta Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6009787.12522 | 2099515.94475 | 37.745423189940404 | -122.408848643548 | (37.7454231899404, -122.408848643548) | ||||
| 182180 | 182180 | 210572 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 300 Melrose Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 5998021.954 | 2095543.6754599998 | 37.7338502677764 | -122.449244404708 | (37.7338502677764, -122.449244404708) | ||||
| 181873 | 181873 | 250227 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 312 Filbert St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | Width 0ft | 6011220.88869 | 2120048.61475 | 37.8018813824768 | -122.40533659221902 | (37.8018813824768, -122.405336592219) | |||
| 181788 | 181788 | 248063 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 18 Rutledge St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | 6010655.07626 | 2099382.64168 | 37.7451057472447 | -122.40583800472 | (37.7451057472447, -122.40583800472) | ||||
| 181546 | 181546 | 125276 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1285 Greenwich St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6006714.64641 | 2119759.73621 | 37.800835221824 | -122.420909807645 | (37.800835221824, -122.420909807645) | ||||
| 181489 | 181489 | 247933 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1099 Esmeralda Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 25 | 6010316.772530001 | 2098765.05298 | 37.7433910575536 | -122.40696428417601 | (37.7433910575536, -122.406964284176) | ||||
| 181473 | 181473 | 218224 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 399 Claremont Blvd | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 22 | 5993477.431469999 | 2097858.26435 | 37.7399445640996 | -122.465124117182 | (37.7399445640996, -122.465124117182) | ||||
| 181323 | 181323 | 189132 | Undocumented 2 | Aesculus californica :: California Buckeye 338 | 1750 22nd St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6012850.6766099995 | 2103796.49604 | 37.7573477838995 | -122.398555623956 | (37.7573477838995, -122.398555623956) | ||||
| 181293 | 181293 | 247981 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 499 Peralta Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6009794.7729400005 | 2099497.71505 | 37.7453735635492 | -122.40882091295 | (37.7453735635492, -122.40882091295) | ||||
| 181186 | 181186 | 175070 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 104 Woolsey St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6011561.993480001 | 2092186.33195 | 37.725396874350096 | -122.40219617312599 | (37.7253968743501, -122.402196173126) | ||||
| 181115 | 181115 | 203656 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 232 Edna St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 5998785.56076 | 2095387.29688 | 37.733464536852395 | -122.446593149381 | (37.7334645368524, -122.446593149381) | ||||
| 181095 | 181095 | 247932 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1099 Esmeralda Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 11 | 6010369.906140001 | 2098762.7933799997 | 37.743387826290395 | -122.406780401602 | (37.7433878262904, -122.406780401602) | ||||
| 181069 | 181069 | 248060 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 18 Rutledge St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 25 | 6010688.173909999 | 2099371.0284599997 | 37.7450757107928 | -122.40572274042201 | (37.7450757107928, -122.405722740422) | ||||
| 181045 | 181045 | 223003 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 198 Corbin Pl | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 3ft | 6000086.83847 | 2105686.0969700003 | 37.761816809226 | -122.442833562346 | (37.761816809226, -122.442833562346) | |||
| 180928 | 180928 | 248055 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 17 Rutledge St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6010658.86611 | 2099354.83953 | 37.745029620524605 | -122.405822941986 | (37.7450296205246, -122.405822941986) | ||||
| 180895 | 180895 | 176096 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 184 Mount Vernon Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 5998966.43073 | 2089373.6298 | 37.7169627336137 | -122.445535550248 | (37.7169627336137, -122.445535550248) | ||||
| 180394 | 180394 | 203576 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 404 Baden St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6000769.77181 | 2095296.00897 | 37.7333270215234 | -122.439726643888 | (37.7333270215234, -122.439726643888) | ||||
| 180380 | 180380 | 203655 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 230 Edna St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 5998797.91036 | 2095380.6148 | 37.7334468948521 | -122.446549972903 | (37.7334468948521, -122.446549972903) | ||||
| 179933 | 179933 | 248234 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 299 Esmeralda Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6006807.51712 | 2099039.75283 | 37.7439483260488 | -122.419117901273 | (37.7439483260488, -122.419117901273) | ||||
| 179735 | 179735 | 250198 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 201 Union St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | Width 0ft | 6011825.11075 | 2119776.45008 | 37.8011678477679 | -122.40322653269199 | (37.8011678477679, -122.403226532692) | |||
| 179689 | 179689 | 176336 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 287 Hester Ave | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 31 | 6012249.60162 | 2087766.47281 | 37.713299190589794 | -122.39950899437001 | (37.7132991905898, -122.39950899437) | ||||
| 179610 | 179610 | 132424 | Undocumented 2 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 943 Vallejo St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6008826.962619999 | 2118671.13776 | 37.7979650382118 | -122.41352324761101 | (37.7979650382118, -122.413523247611) | ||||
| 179538 | 179538 | 176165 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 654 Peru Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 27 | 6005141.81262 | 2092533.90812 | 37.7259907884276 | -122.42441488026199 | (37.7259907884276, -122.424414880262) | ||||
| 179533 | 179533 | 249637 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2400 Lyon St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5999297.09837 | 2117106.84322 | 37.7931301902456 | -122.4463865832 | (37.7931301902456, -122.4463865832) | ||||
| 179457 | 179457 | 126275 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2836 Larkin St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 26 | 6006511.2494 | 2120976.42855 | 37.8041644823576 | -122.421700114785 | (37.8041644823576, -122.421700114785) | ||||
| 179334 | 179334 | 136052 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 1114 Greenwich St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6007569.13805 | 2119905.68389 | 37.801284085155004 | -122.41796325270201 | (37.801284085155, -122.417963252702) | ||||
| 179275 | 179275 | 225250 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 200 Corbin Pl | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | Width 3ft | 6000060.0999300005 | 2105713.56645 | 37.761890709215 | -122.442928012745 | (37.761890709215, -122.442928012745) | |||
| 179249 | 179249 | 206474 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 230 Edna St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 5998806.12443 | 2095305.20487 | 37.73324030618979 | -122.446516151203 | (37.7332403061898, -122.446516151203) | ||||
| 179229 | 179229 | 177471 | Undocumented 2 | Malus :: Crab Apple 235 | 184 Mount Vernon Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 5998983.26506 | 2089357.76175 | 37.7169201246297 | -122.44547622197399 | (37.7169201246297, -122.445476221974) | ||||
| 179179 | 179179 | 225241 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 301 Fairmount St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6004065.1857199995 | 2097137.17926 | 37.7385694799892 | -122.428464673104 | (37.7385694799892, -122.428464673104) | ||||
| 179168 | 179168 | 247007 | Undocumented 2 | Callistemon salignus :: White flowering bottlebrush 557 | 401 Valley St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10 | Width 8ft | 6003259.67301 | 2099184.77085 | 37.744146077987 | -122.431395876644 | (37.744146077987, -122.431395876644) | |||
| 179049 | 179049 | 175068 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 Woolsey St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6011564.90281 | 2092154.99462 | 37.7253109908919 | -122.402183913575 | (37.7253109908919, -122.402183913575) | ||||
| 178929 | 178929 | 247983 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 497 Peralta Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6009757.51939 | 2099637.18115 | 37.74575442014729 | -122.408959568646 | (37.7457544201473, -122.408959568646) | ||||
| 178664 | 178664 | 223860 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 20 Deming St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | Width 3ft | 5999452.08936 | 2105235.56335 | 37.7605435481615 | -122.4449965101 | (37.7605435481615, -122.4449965101) | |||
| 178613 | 178613 | 176988 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 184 Mount Vernon Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 5998975.21291 | 2089361.52774 | 37.7169300054919 | -122.445504324886 | (37.7169300054919, -122.445504324886) | ||||
| 178599 | 178599 | 250158 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 2500 Lyon St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5999254.28786 | 2117464.37854 | 37.794109442247404 | -122.446560444632 | (37.7941094422474, -122.446560444632) | ||||
| 178075 | 178075 | 178250 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 287 Hester Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6012202.6988699995 | 2087794.30309 | 37.713372992543896 | -122.39967306036199 | (37.7133729925439, -122.399673060362) | ||||
| 177957 | 177957 | 240632 | Undocumented 2 | Sequoiadendron giganteum :: Sierra Redwood 212 | 200 Corbin Pl | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | Width 3ft | 6000056.026330001 | 2105707.20258 | 37.7618730033536 | -122.442941644657 | (37.7618730033536, -122.442941644657) | |||
| 177540 | 177540 | 134519 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 18 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | Width 4ft | 6007845.81845 | 2112089.93571 | 37.779839527901295 | -122.416451883555 | (37.7798395279013, -122.416451883555) | |||
| 177530 | 177530 | 134505 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | Width 4ft | 6008123.85605 | 2112126.20986 | 37.7799547598338 | -122.41549259472299 | (37.7799547598338, -122.415492594723) | |||
| 177483 | 177483 | 196062 | Undocumented 2 | Prunus spp :: Cherry 84 | 1751 22nd St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 5ft | 6012859.76673 | 2103766.08005 | 37.757264774654395 | -122.398522052264 | (37.7572647746544, -122.398522052264) | |||
| 177427 | 177427 | 175206 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 653 Peru Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | 6005071.100819999 | 2092642.6936700002 | 37.72628549626779 | -122.42466706185199 | (37.7262854962678, -122.424667061852) | ||||
| 177265 | 177265 | 132399 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2836 Larkin St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6006512.34183 | 2120961.63143 | 37.8041239148476 | -122.421695282708 | (37.8041239148476, -122.421695282708) | ||||
| 177224 | 177224 | 201612 | Undocumented 2 | Gleditsia triacanthos :: Honey Locust 67 | 98 Jerrold Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 2 | Width 3ft | 6020781.6072 | 2092974.15888 | 37.7280704113081 | -122.370378850726 | (37.7280704113081, -122.370378850726) | |||
| 177126 | 177126 | 134515 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 Fulton St | 14 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | Width 4ft | 6007920.47696 | 2112096.9218900003 | 37.7798629084902 | -122.416194101002 | (37.7798629084902, -122.416194101002) |
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");