Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, PlantType, qCaretaker, DBH
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2250 | 2250 | 200335 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 7 | : 4 | Tree 1 | Purchasing Dept 15 | 4 | Width 2ft | 6015505.4551 | 2098329.2709 | 37.7424834725483 | -122.388992567847 | (37.7424834725483, -122.388992567847) | |||
| 23436 | 23436 | 187515 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 299 Lauren Ct | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6012570.47183 | 2088125.85933 | 37.7143038745038 | -122.398425150324 | (37.7143038745038, -122.398425150324) | |||
| 23467 | 23467 | 205659 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1598 10th Ave | 7 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 5993106.7424 | 2104692.3682 | 37.7586878807581 | -122.466902491455 | (37.7586878807581, -122.466902491455) | |||
| 23501 | 23501 | 187800 | Undocumented 2 | Acer buergeranum :: Trident Maple 120 | 2 Heron St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6009988.42633 | 2110014.66553 | 37.7742615809293 | -122.40889316451499 | (37.7742615809293, -122.408893164515) | |||
| 23687 | 23687 | 235690 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 63 Laussat St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6004411.60055 | 2109266.67882 | 37.7718938314631 | -122.428131106459 | (37.7718938314631, -122.428131106459) | |||
| 23714 | 23714 | 234376 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1750 Harrison St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6008587.75214 | 2108113.66978 | 37.7689633348285 | -122.41360388622499 | (37.7689633348285, -122.413603886225) | |||
| 24128 | 24128 | 198134 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 131 Bridgeview Dr | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6013337.1330699995 | 2095632.7165299999 | 37.7349588665628 | -122.396301078452 | (37.7349588665628, -122.396301078452) | |||
| 24340 | 24340 | 241638 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 200 Guerrero St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6005425.11854 | 2107744.6412400003 | 37.767771973225 | -122.424516988391 | (37.767771973225, -122.424516988391) | |||
| 24506 | 24506 | 213803 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 216 Byxbee St | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 5991962.814730001 | 2089977.4457200002 | 37.7182183418945 | -122.469787374494 | (37.7182183418945, -122.469787374494) | |||
| 24724 | 24724 | 203893 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 171 Eucalyptus Dr | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 5991106.51635 | 2094658.68815 | 37.7310223370083 | -122.473088402602 | (37.7310223370083, -122.473088402602) | |||
| 24913 | 24913 | 191583 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 750 Phelps St | 31 | : 4 | Tree 1 | Private 1 | 10 | Width 2ft | 6015226.42584 | 2097953.59483 | 37.741436472805 | -122.389931139928 | (37.741436472805, -122.389931139928) | |||
| 24956 | 24956 | 198140 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 152 Bridgeview Dr | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 2ft | 6013267.76129 | 2095794.5918400001 | 37.7353994821874 | -122.396552266301 | (37.7353994821874, -122.396552266301) | |||
| 25220 | 25220 | 235688 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 242 Church St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6004123.15327 | 2107397.4194400003 | 37.766744974426395 | -122.428995570805 | (37.7667449744264, -122.428995570805) | |||
| 25301 | 25301 | 190759 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 960 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6011851.68946 | 2103937.20655 | 37.757678438529894 | -122.40202042759701 | (37.7576784385299, -122.402020427597) | |||
| 25360 | 25360 | 188327 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1810 23rd St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6012968.79067 | 2102886.92272 | 37.754856873149706 | -122.398083326981 | (37.7548568731497, -122.398083326981) | |||
| 25698 | 25698 | 202267 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 28 Orsi Cir | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6013033.98272 | 2093207.99375 | 37.728284203554395 | -122.397179214247 | (37.7282842035544, -122.397179214247) | |||
| 25735 | 25735 | 246806 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 132 Brewster St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6010286.59808 | 2099166.12262 | 37.744490619049294 | -122.407096884714 | (37.7444906190493, -122.407096884714) | |||
| 26295 | 26295 | 201309 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 11 Lydia Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6012928.97985 | 2092740.84393 | 37.7269956593979 | -122.397509466884 | (37.7269956593979, -122.397509466884) | |||
| 26377 | 26377 | 225990 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2 Pearl St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6005601.0883599995 | 2108893.1022200002 | 37.7709353079426 | -122.42399000814 | (37.7709353079426, -122.42399000814) | |||
| 26446 | 26446 | 238580 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 519 Hickory St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6004286.86456 | 2110289.10974 | 37.7746941188733 | -122.428635472355 | (37.7746941188733, -122.428635472355) | |||
| 26506 | 26506 | 191237 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1600 Newhall St | 6 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6014127.4828 | 2095367.51286 | 37.7342746191851 | -122.39354998485001 | (37.7342746191851, -122.39354998485) | |||
| 26563 | 26563 | 246795 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 195 Brewster St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6010198.18555 | 2098814.08058 | 37.7435190400824 | -122.407377785258 | (37.7435190400824, -122.407377785258) | |||
| 26634 | 26634 | 190806 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1924 22nd St | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6012287.449569999 | 2103786.76177 | 37.7572896615996 | -122.400502813555 | (37.7572896615996, -122.400502813555) | |||
| 27087 | 27087 | 191234 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1600 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6014153.116769999 | 2095403.12134 | 37.734373817081796 | -122.39346385049299 | (37.7343738170818, -122.393463850493) | |||
| 27358 | 27358 | 202320 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 155 Orsi Cir | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6012974.90873 | 2093002.4411400002 | 37.727716509204 | -122.397369027877 | (37.727716509204, -122.397369027877) | |||
| 27486 | 27486 | 192817 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 666 Harrison St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6013574.47554 | 2113201.19226 | 37.783211275117104 | -122.39671171428101 | (37.7832112751171, -122.396711714281) | |||
| 27836 | 27836 | 201298 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 65 Lydia Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6012703.34992 | 2092907.69585 | 37.727441234813 | -122.398301172475 | (37.727441234813, -122.398301172475) | |||
| 27858 | 27858 | 198136 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 27 Bridgeview Dr | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 2ft | 6014000.75949 | 2095429.8898900002 | 37.7344388515748 | -122.393992476471 | (37.7344388515748, -122.393992476471) | |||
| 29298 | 29298 | 191239 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1600 Newhall St | 9 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6014110.40607 | 2095343.3649799998 | 37.7342073651799 | -122.39360733551399 | (37.7342073651799, -122.393607335514) | |||
| 29547 | 29547 | 218232 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 371 Wawona St | 1 | : 4 | Tree 1 | Private 1 | 33 | Width 2ft | 5991901.5455 | 2097060.86466 | 37.7376641082099 | -122.47051476505 | (37.7376641082099, -122.47051476505) | |||
| 29562 | 29562 | 193317 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 136 Hawthorne St | 3 | : 4 | Tree 1 | Private 1 | 9 | Width 2ft | 6013319.34244 | 2113654.62795 | 37.7844421016727 | -122.397626191699 | (37.7844421016727, -122.397626191699) | |||
| 30393 | 30393 | 175390 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3087 22nd Ave | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 2ft | 5989889.400330001 | 2094791.98233 | 37.7313177849745 | -122.477305871364 | (37.7313177849745, -122.477305871364) | |||
| 30441 | 30441 | 196549 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 40 Ledyard St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6011616.35938 | 2095078.6456799998 | 37.7333416013201 | -122.402211492182 | (37.7333416013201, -122.402211492182) | |||
| 30518 | 30518 | 179954 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 40 Tomaso Ct | 1 | : 4 | Tree 1 | Private 1 | 23 | Width 2ft | 6009197.20014 | 2086405.9588 | 37.709392885454 | -122.409963207553 | (37.709392885454, -122.409963207553) | |||
| 30558 | 30558 | 194730 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 247 Missouri St | 2 | : 4 | Tree 1 | Private 1 | 13 | Width 2ft | 6013489.8899 | 2105941.80218 | 37.763273915975205 | -122.39649533019899 | (37.7632739159752, -122.396495330199) | |||
| 30783 | 30783 | 202270 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 38 Orsi Cir | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6012994.98381 | 2093237.0284400003 | 37.728361755688894 | -122.39731607130301 | (37.7283617556889, -122.397316071303) | |||
| 31006 | 31006 | 202273 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 50 Orsi Cir | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6012938.89237 | 2093280.23143 | 37.7284772592045 | -122.397513012032 | (37.7284772592045, -122.397513012032) | |||
| 31272 | 31272 | 246733 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 100 Ripley St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6008547.21994 | 2099053.14495 | 37.7440829149855 | -122.413103333461 | (37.7440829149855, -122.413103333461) | |||
| 31277 | 31277 | 201299 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 61 Lydia Ave | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 2ft | 6012712.67575 | 2092900.9099400002 | 37.727423121574205 | -122.398268456931 | (37.7274231215742, -122.398268456931) | |||
| 31534 | 31534 | 202322 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 149 Orsi Cir | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6012943.5875699995 | 2093025.90325 | 37.727779187458296 | -122.39747895112 | (37.7277791874583, -122.39747895112) | |||
| 31599 | 31599 | 218216 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 130 Lenox Way | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 5993396.63989 | 2098589.94545 | 37.7419489172986 | -122.465456597447 | (37.7419489172986, -122.465456597447) | |||
| 31801 | 31801 | 213330 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 217 Byxbee St | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 5991929.42464 | 2089936.9124 | 37.7181051172336 | -122.46989983921101 | (37.7181051172336, -122.469899839211) | |||
| 32573 | 32573 | 201331 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 95 Bitting Ave | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6012535.62971 | 2092785.01018 | 37.7270950209928 | -122.39887237867599 | (37.7270950209928, -122.398872378676) | |||
| 32956 | 32956 | 187513 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 298 Lauren Ct | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6012575.74065 | 2088161.92149 | 37.7144031875338 | -122.39840946793001 | (37.7144031875338, -122.39840946793) | |||
| 33181 | 33181 | 218540 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 Rossmoor Dr | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 5991304.84344 | 2094334.7083700001 | 37.7301442506463 | -122.472379149601 | (37.7301442506463, -122.472379149601) | |||
| 33542 | 33542 | 190139 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 401 Barneveld Ave | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6011347.78295 | 2098111.56945 | 37.741654371349604 | -122.40335333078501 | (37.7416543713496, -122.403353330785) | |||
| 33587 | 33587 | 198007 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 274 Shipley St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 6011297.08858 | 2111564.84003 | 37.7785912185545 | -122.404475379844 | (37.7785912185545, -122.404475379844) | |||
| 33686 | 33686 | 241242 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1320 Stevenson St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6006249.62904 | 2109085.1733 | 37.771499282705605 | -122.421760329799 | (37.7714992827056, -122.421760329799) | |||
| 33705 | 33705 | 202264 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 12 Orsi Cir | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6013090.69479 | 2093165.6197900001 | 37.728171010371796 | -122.396980187094 | (37.7281710103718, -122.396980187094) | |||
| 33831 | 33831 | 201522 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 863 Innes Ave | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6019436.4693599995 | 2094253.9637900002 | 37.7315105906351 | -122.375117750879 | (37.7315105906351, -122.375117750879) | |||
| 33902 | 33902 | 201660 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 130 Dore St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6009127.89234 | 2109540.91695 | 37.7729125385177 | -122.411836435997 | (37.7729125385177, -122.411836435997) | |||
| 34332 | 34332 | 189296 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 621 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6011838.19125 | 2105389.54808 | 37.7616654928887 | -122.402169215947 | (37.7616654928887, -122.402169215947) | |||
| 34756 | 34756 | 210594 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1598 10th Ave | 8 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 5993107.5867 | 2104697.22808 | 37.758701273452 | -122.46689992480499 | (37.758701273452, -122.466899924805) | |||
| 34925 | 34925 | 202296 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 106 Orsi Cir | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 2ft | 6012783.083 | 2093197.04815 | 37.7282401781334 | -122.39804582346001 | (37.7282401781334, -122.39804582346) | |||
| 35414 | 35414 | 249328 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 800 Post St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6008263.17987 | 2114872.90774 | 37.7875043597946 | -122.415205095847 | (37.7875043597946, -122.415205095847) | |||
| 35687 | 35687 | 191236 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1600 Newhall St | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6014135.07988 | 2095376.9884099998 | 37.734301059229104 | -122.39352438203998 | (37.7343010592291, -122.39352438204) | |||
| 35770 | 35770 | 194078 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 551 Barneveld Ave | 5 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6011051.92232 | 2097388.39433 | 37.7396521585296 | -122.404325434065 | (37.7396521585296, -122.404325434065) | |||
| 36475 | 36475 | 194729 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 325 Missouri St | 1 | : 4 | Tree 1 | Private 1 | 18 | Width 2ft | 6013511.17143 | 2105538.56581 | 37.762167901854504 | -122.396393458603 | (37.7621679018545, -122.396393458603) | |||
| 37156 | 37156 | 189173 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1960 Quesada Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6013345.84088 | 2096070.7044 | 37.73616197508429 | -122.396301660307 | (37.7361619750843, -122.396301660307) | |||
| 37222 | 37222 | 200382 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 190 Shipley St | 4 | : 4 | Tree 1 | Private 1 | 9 | Width 2ft | 6011901.48049 | 2112104.64879 | 37.7801071661611 | -122.40242251089701 | (37.7801071661611, -122.402422510897) | |||
| 37576 | 37576 | 175870 | Undocumented 2 | Citrus spp :: Lemon: Orange: Lime 278 | 24 Tomaso Ct | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6009222.043409999 | 2086480.3970700002 | 37.7095986701246 | -122.409882595915 | (37.7095986701246, -122.409882595915) | |||
| 37637 | 37637 | 129196 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 75 Cervantes Blvd | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 2ft | 6001591.38038 | 2120905.5251 | 37.8036911413025 | -122.438720569603 | (37.8036911413025, -122.438720569603) | |||
| 37870 | 37870 | 247053 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 507 Valley St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6002585.442419999 | 2099146.1836099997 | 37.744001891474 | -122.43372445791599 | (37.744001891474, -122.433724457916) | |||
| 38123 | 38123 | 205658 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1598 10th Ave | 6 | : 4 | Tree 1 | Private 1 | 9 | Width 2ft | 5993107.26748 | 2104689.10541 | 37.7586789522928 | -122.46690043830799 | (37.7586789522928, -122.466900438308) | |||
| 38212 | 38212 | 241051 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 961 San Bruno Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6011090.2221 | 2103848.38169 | 37.757392016143996 | -122.40464765488001 | (37.757392016144, -122.40464765488) | |||
| 38214 | 38214 | 212630 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 186 Byxbee St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 5991963.5826 | 2089803.15651 | 37.7177398306004 | -122.46977203837099 | (37.7177398306004, -122.469772038371) | |||
| 38407 | 38407 | 250069 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 307 Austin St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6005709.21572 | 2115345.18544 | 37.7886572546664 | -122.424074905926 | (37.7886572546664, -122.424074905926) | |||
| 38834 | 38834 | 202325 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 135 Orsi Cir | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6012883.64623 | 2093069.27547 | 37.7278949409987 | -122.39768921171199 | (37.7278949409987, -122.397689211712) | |||
| 39164 | 39164 | 238056 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 439 Lily St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 2ft | 6004411.75821 | 2109960.94242 | 37.773800119011895 | -122.428180047573 | (37.7738001190119, -122.428180047573) | |||
| 39264 | 39264 | 204069 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 161 Byxbee St | 8 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 5991925.79364 | 2089647.35065 | 37.7173098413624 | -122.469891319037 | (37.7173098413624, -122.469891319037) | |||
| 39285 | 39285 | 221786 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 65 Scott St | 1 | : 4 | Tree 1 | Private 1 | 20 | Width 2ft | 6002363.3837 | 2108638.99661 | 37.7700542727214 | -122.435171122647 | (37.7700542727214, -122.435171122647) | |||
| 39356 | 39356 | 204071 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 161 Byxbee St | 10 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 5991926.528080001 | 2089611.9892799999 | 37.7172127901068 | -122.469886207299 | (37.7172127901068, -122.469886207299) | |||
| 39527 | 39527 | 206980 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 401 Victoria St | 10 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 5993229.06721 | 2089889.6330900001 | 37.718050339540206 | -122.465404139084 | (37.7180503395402, -122.465404139084) | |||
| 39691 | 39691 | 201303 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 41 Lydia Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6012776.27205 | 2092854.38642 | 37.7272989198021 | -122.398045340523 | (37.7272989198021, -122.398045340523) | |||
| 40286 | 40286 | 178844 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 52 Tomaso Ct | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 2ft | 6009171.05644 | 2086338.49099 | 37.7092061672978 | -122.410048805012 | (37.7092061672978, -122.410048805012) | |||
| 40508 | 40508 | 200389 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 187 Clara St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6012048.11431 | 2112010.00275 | 37.7798554746967 | -122.401908579817 | (37.7798554746967, -122.401908579817) | |||
| 40698 | 40698 | 246801 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 125 Brewster St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6010345.51776 | 2099245.26098 | 37.744711212847704 | -122.406898728095 | (37.7447112128477, -122.406898728095) | |||
| 40822 | 40822 | 187972 | Undocumented 2 | Albizia julibrissin :: Mimosa Silk Tree 126 | 75 Bridgeview Dr | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 6013703.3858900005 | 2095554.5779799998 | 37.734764687625706 | -122.395029332752 | (37.7347646876257, -122.395029332752) | |||
| 40843 | 40843 | 192425 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 187 Clara St | 6 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 6011952.39777 | 2111919.37561 | 37.779601291212394 | -122.402233334018 | (37.7796012912124, -122.402233334018) | |||
| 40920 | 40920 | 242375 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 130 Church St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6004079.07598 | 2108183.78189 | 37.7689016404155 | -122.429204103801 | (37.7689016404155, -122.429204103801) | |||
| 40929 | 40929 | 249550 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 380 Fern St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6005507.2276099995 | 2114996.10092 | 37.7876873493358 | -122.424748911848 | (37.7876873493358, -122.424748911848) | |||
| 40989 | 40989 | 241240 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1301 Jessie St | 5 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6006461.320719999 | 2109025.58866 | 37.771347612922604 | -122.42102384438101 | (37.7713476129226, -122.421023844381) | |||
| 41022 | 41022 | 191235 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1600 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6014141.54444 | 2095385.83675 | 37.7343257141509 | -122.393502650848 | (37.7343257141509, -122.393502650848) | |||
| 41290 | 41290 | 218537 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 169 Eucalyptus Dr | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 5991155.07657 | 2094656.4445 | 37.7310189879395 | -122.47292035978901 | (37.7310189879395, -122.472920359789) | |||
| 41382 | 41382 | 201297 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 69 Lydia Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6012679.277000001 | 2092924.5812099997 | 37.7274862575679 | -122.398385577456 | (37.7274862575679, -122.398385577456) | |||
| 41406 | 41406 | 193651 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2193 Oakdale Ave | 16 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6011954.61979 | 2097740.3314099996 | 37.7406689050515 | -122.40122899903601 | (37.7406689050515, -122.401228999036) | |||
| 41456 | 41456 | 218233 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 365 Wawona St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 5991919.11048 | 2097078.05412 | 37.737712321755 | -122.470455286603 | (37.737712321755, -122.470455286603) | |||
| 41483 | 41483 | 224478 | Undocumented 2 | Ficus Spp. :: 253 | 1320 Stevenson St | 5 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6006256.605719999 | 2108994.8158299997 | 37.7712515761271 | -122.421729778032 | (37.7712515761271, -122.421729778032) | |||
| 41573 | 41573 | 189255 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2249 Quesada Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6011757.211209999 | 2097196.1976799998 | 37.739163814067396 | -122.40187332639499 | (37.7391638140674, -122.401873326395) | |||
| 41983 | 41983 | 212629 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 186 Byxbee St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 5991963.2488 | 2089763.89053 | 37.717631996493395 | -122.46977033503599 | (37.7176319964934, -122.469770335036) | |||
| 42207 | 42207 | 203193 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 47 Ceres St | 2 | : 4 | Tree 1 | Private 1 | 17 | Width 2ft | 6013909.9694300005 | 2093925.2511200001 | 37.7303023748506 | -122.39420106345301 | (37.7303023748506, -122.394201063453) | |||
| 42251 | 42251 | 192828 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 341 03rd St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6013176.42141 | 2113220.71847 | 37.7832427271154 | -122.398090201402 | (37.7832427271154, -122.398090201402) | |||
| 42863 | 42863 | 246813 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 174 Brewster St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6010206.83584 | 2098924.9753900003 | 37.7438240172737 | -122.40735569070699 | (37.7438240172737, -122.407355690707) | |||
| 42961 | 42961 | 193318 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 136 Hawthorne St | 4 | : 4 | Tree 1 | Private 1 | 10 | Width 2ft | 6013332.96782 | 2113640.4980900004 | 37.7844040630434 | -122.397578060899 | (37.7844040630434, -122.397578060899) | |||
| 42998 | 42998 | 200342 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 25 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6015273.793930001 | 2098017.0765 | 37.7416134072345 | -122.389771789042 | (37.7416134072345, -122.389771789042) | |||
| 44252 | 44252 | 218541 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2 Rossmoor Dr | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 5991287.109209999 | 2094336.12276 | 37.730147107779395 | -122.47244056159401 | (37.7301471077794, -122.472440561594) | |||
| 44306 | 44306 | 187516 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 299 Lauren Ct | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6012587.97083 | 2088132.1806 | 37.7143222062682 | -122.39836510978 | (37.7143222062682, -122.39836510978) | |||
| 44387 | 44387 | 202306 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 160 Orsi Cir | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6012951.54895 | 2092971.8033599998 | 37.7276310834963 | -122.397447635807 | (37.7276310834963, -122.397447635807) | |||
| 44478 | 44478 | 202303 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 150 Orsi Cir | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 2ft | 6012894.364519999 | 2093014.3833700002 | 37.7277448153672 | -122.39764830963999 | (37.7277448153672, -122.39764830964) | |||
| 44898 | 44898 | 200384 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 190 Shipley St | 6 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6011937.7849 | 2112142.029 | 37.7802118301589 | -122.40229954568599 | (37.7802118301589, -122.402299545686) |
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");