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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23483 | 23483 | 234406 | Undocumented 2 | Phoenix dactylifera :: Date Palm 65 | 147 Valencia St | 1 | : 4 | Tree 1 | Private 1 | 20 | Width 8ft | 6006058.10348 | 2108951.831 | 37.7711223543454 | -122.422413351811 | (37.7711223543454, -122.422413351811) | |||
23494 | 23494 | 219849 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 72 Skyview Way | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5997939.73785 | 2101790.86322 | 37.7509988274335 | -122.449978746126 | (37.7509988274335, -122.449978746126) | |||
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) | |||
23509 | 23509 | 188616 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3601 03rd St | 13 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6015976.85216 | 2098785.54996 | 37.7437624397877 | -122.38739442491999 | (37.7437624397877, -122.38739442492) | |||
23518 | 23518 | 247709 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 848 Waller St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 4ft | 6001610.36211 | 2108740.78692 | 37.7702909742819 | -122.437783100124 | (37.7702909742819, -122.437783100124) | |||
23554 | 23554 | 193631 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2 Industrial St | 4 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6012126.8471099995 | 2097436.10996 | 37.7398431844134 | -122.400612133368 | (37.7398431844134, -122.400612133368) | |||
23570 | 23570 | 250043 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 50 Daniel Burnham Ct | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6006138.25466 | 2114733.68143 | 37.787002430166396 | -122.422547022523 | (37.7870024301664, -122.422547022523) | |||
23580 | 23580 | 212649 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 321 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5992450.10328 | 2090020.5964400002 | 37.7183649772426 | -122.468106177365 | (37.7183649772426, -122.468106177365) | |||
23603 | 23603 | 231527 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 127 Scott St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6002315.440669999 | 2108966.67057 | 37.7709512619163 | -122.435360399361 | (37.7709512619163, -122.435360399361) | |||
23608 | 23608 | 210892 | Undocumented 2 | Paulownia tomentosa :: Empress Tree 332 | 210 Vernon St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5992474.84263 | 2089237.23886 | 37.7162154959333 | -122.467963716667 | (37.7162154959333, -122.467963716667) | |||
23657 | 23657 | 196979 | Undocumented 2 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1551 20th St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6013315.21298 | 2104723.80911 | 37.7599198521353 | -122.39701407983802 | (37.7599198521353, -122.397014079838) | |||
23679 | 23679 | 191569 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1610 Innes Ave | 8 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6015206.39657 | 2097489.64193 | 37.7401614427971 | -122.38996799323401 | (37.7401614427971, -122.389967993234) | |||
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) | |||
23710 | 23710 | 199357 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 929 Rhode Island St | 2 | : 4 | Tree 1 | Private 1 | 23 | Width 7ft | 6011910.785069999 | 2104052.6476 | 37.757998712287204 | -122.401824164069 | (37.7579987122872, -122.401824164069) | |||
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) | |||
23726 | 23726 | 192170 | Undocumented 2 | Ficus rubiginosa :: Port Jackson Fig 188 | 1601 Kansas St | 9 | : 4 | Tree 1 | Private 1 | 51 | Width 7ft | 6011813.79085 | 2100866.0430099997 | 37.749243580141204 | -122.40193560806001 | (37.7492435801412, -122.40193560806) | |||
23741 | 23741 | 234546 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 390 Valencia St | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6006093.30748 | 2107339.39133 | 37.7666969650198 | -122.422177005484 | (37.7666969650198, -122.422177005484) | |||
23764 | 23764 | 197793 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 66 Ceres St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6013832.07065 | 2093815.87712 | 37.7299977259065 | -122.394462716674 | (37.7299977259065, -122.394462716674) | |||
23814 | 23814 | 247646 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 900 Duboce Ave | 2 | : 4 | Tree 1 | Private 1 | 13 | Width 5ft | 6001616.30949 | 2108303.20625 | 37.769089824469496 | -122.43773118404499 | (37.7690898244695, -122.437731184045) | |||
23825 | 23825 | 247187 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Buena Vista Ave East | 4 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6000970.93564 | 2108908.88323 | 37.770716144966 | -122.440006923906 | (37.770716144966, -122.440006923906) | |||
23828 | 23828 | 177148 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 1100 Junipero Serra Blvd | 11 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991345.1062 | 2088786.2704900003 | 37.7149119421181 | -122.47183574413401 | (37.7149119421181, -122.471835744134) | |||
23879 | 23879 | 193824 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1550 Fairfax Ave | 3 | : 4 | Tree 1 | Private 1 | 14 | Width 6ft | 6015655.00087 | 2098203.32161 | 37.742145929985796 | -122.388466689285 | (37.7421459299858, -122.388466689285) | |||
23924 | 23924 | 215624 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 66 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991139.11135 | 2090614.21248 | 37.7199191010706 | -122.47268094048201 | (37.7199191010706, -122.472680940482) | |||
23930 | 23930 | 246508 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 241 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 6ft | 6004932.15845 | 2099866.5422 | 37.7461127118493 | -122.425661300149 | (37.7461127118493, -122.425661300149) | |||
23940 | 23940 | 190941 | Undocumented 2 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 1701 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6013964.79274 | 2095080.10635 | 37.733476418703496 | -122.39409234708599 | (37.7334764187035, -122.394092347086) | |||
23951 | 23951 | 222885 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1 Valencia St | 3 | : 4 | Tree 1 | Private 1 | 18 | Width 5ft | 6006051.02822 | 2109339.24494 | 37.7721857010308 | -122.422465357814 | (37.7721857010308, -122.422465357814) | |||
23966 | 23966 | 221105 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 2815 18th St | 8 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6009452.05657 | 2105439.4087799997 | 37.761668922891296 | -122.41042544467301 | (37.7616689228913, -122.410425444673) | |||
24000 | 24000 | 246500 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 273 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 5ft | 6004745.35521 | 2099854.76299 | 37.746069811469 | -122.426306403626 | (37.746069811469, -122.426306403626) | |||
24013 | 24013 | 232628 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 151 Starview Way | 3 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5997489.976480001 | 2102197.32823 | 37.7520891340271 | -122.451563373145 | (37.7520891340271, -122.451563373145) | |||
24033 | 24033 | 189426 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 553 Arkansas St | 1 | : 4 | Tree 1 | Private 1 | 23 | Width 7ft | 6013011.23422 | 2104452.4501799997 | 37.759157834075204 | -122.398046364864 | (37.7591578340752, -122.398046364864) | |||
24055 | 24055 | 188977 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2000 Thomas Ave | 2 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6012688.07294 | 2095454.3657900002 | 37.7344330140672 | -122.398532612087 | (37.7344330140672, -122.398532612087) | |||
24067 | 24067 | 201949 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1650 Carroll Ave | 18 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6013468.57071 | 2092447.06427 | 37.7262190300648 | -122.395623522912 | (37.7262190300648, -122.395623522912) | |||
24071 | 24071 | 250790 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 284 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5985915.81821 | 2114007.58209 | 37.7838471713633 | -122.49245762762101 | (37.7838471713633, -122.492457627621) | |||
24091 | 24091 | 193642 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 2000 Oakdale Ave | 6 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6012823.32202 | 2097168.087 | 37.739146068631705 | -122.398185200408 | (37.7391460686317, -122.398185200408) | |||
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) | |||
24147 | 24147 | 210947 | Undocumented 2 | Photinia fraseri :: Photinia: Chinese photinia 104 | 171 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5992177.81487 | 2089015.3385599998 | 37.715589054271 | -122.468974238973 | (37.715589054271, -122.468974238973) | |||
24219 | 24219 | 189857 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 102 Newhall St | 7 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6017207.28329 | 2098227.98563 | 37.7422995503725 | -122.383101045278 | (37.7422995503725, -122.383101045278) | |||
24236 | 24236 | 213361 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 25 Elmhurst Dr | 6 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5991216.12738 | 2094471.85178 | 37.730515676960394 | -122.47269584493701 | (37.7305156769604, -122.472695844937) | |||
24261 | 24261 | 250049 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 50 Daniel Burnham Ct | 8 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6005972.08253 | 2114712.11265 | 37.7869338316717 | -122.42312040780199 | (37.7869338316717, -122.423120407802) | |||
24285 | 24285 | 211375 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 462 Head St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5993511.66198 | 2088947.80239 | 37.7154805924354 | -122.46435899649201 | (37.7154805924354, -122.464358996492) | |||
24295 | 24295 | 249534 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 201 Myrtle St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6006252.357009999 | 2114034.72493 | 37.785089704362704 | -122.422102579373 | (37.7850897043627, -122.422102579373) | |||
24309 | 24309 | 191424 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 743 Wisconsin St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6012751.8613599995 | 2104046.56843 | 37.758028922326496 | -122.398914919298 | (37.7580289223265, -122.398914919298) | |||
24318 | 24318 | 195049 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 425 07th St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6011046.10585 | 2110191.14121 | 37.7748053308349 | -122.405246869567 | (37.7748053308349, -122.405246869567) | |||
24332 | 24332 | 246923 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 411 Frederick St | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 6ft | 5997906.77047 | 2107481.56832 | 37.7666221917918 | -122.450502958247 | (37.7666221917918, -122.450502958247) | |||
24334 | 24334 | 246922 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 417 Frederick St | 2 | : 4 | Tree 1 | Private 1 | 15 | Width 4ft | 5997854.3485 | 2107475.00928 | 37.7666011818151 | -122.45068380291 | (37.7666011818151, -122.45068380291) | |||
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) | |||
24358 | 24358 | 211712 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 418 San Miguel St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5997865.28032 | 2089936.92549 | 37.7184464872957 | -122.449382239324 | (37.7184464872957, -122.449382239324) | |||
24372 | 24372 | 246497 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 319 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 6ft | 6004279.93355 | 2099832.71811 | 37.7459829621447 | -122.427914200798 | (37.7459829621447, -122.427914200798) | |||
24373 | 24373 | 201122 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 3401 03rd St | 11 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6016102.9288 | 2099545.92892 | 37.7458572657 | -122.387011499888 | (37.7458572657, -122.387011499888) | |||
24374 | 24374 | 192945 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 238 11th St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6008246.27864 | 2109382.4071299997 | 37.7724278093356 | -122.41487483150401 | (37.7724278093356, -122.414874831504) | |||
24404 | 24404 | 246777 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 999 Esmeralda Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6009797.217759999 | 2098767.51115 | 37.743368720206206 | -122.408760953364 | (37.7433687202062, -122.408760953364) | |||
24435 | 24435 | 189790 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 671 Connecticut St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6013319.6658 | 2103964.90842 | 37.7578363244071 | -122.39694547056601 | (37.7578363244071, -122.396945470566) | |||
24466 | 24466 | 207106 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 100 Tara St | 2 | : 4 | Tree 1 | Private 1 | 20 | Width 0ft | 5998100.60654 | 2090923.0946 | 37.7211677377768 | -122.448639805789 | (37.7211677377768, -122.448639805789) | |||
24505 | 24505 | 195054 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 820 Bryant St | 1 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6011686.5663 | 2110516.6477900003 | 37.775734882702295 | -122.403054272047 | (37.7757348827023, -122.403054272047) | |||
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) | |||
24550 | 24550 | 200288 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 450 Texas St | 6 | : 4 | Tree 1 | Private 1 | 2 | Width 5ft | 6013765.39611 | 2104962.6941 | 37.7606008277911 | -122.39547383976499 | (37.7606008277911, -122.395473839765) | |||
24574 | 24574 | 250326 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 161 27th Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5987393.53331 | 2114913.8058 | 37.786421687562104 | -122.487411939018 | (37.7864216875621, -122.487411939018) | |||
24599 | 24599 | 225999 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 700 Duboce Ave | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6002335.19401 | 2108315.06979 | 37.7691632487104 | -122.435245457027 | (37.7691632487104, -122.435245457027) | |||
24622 | 24622 | 247221 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 187 Divisadero St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6001849.330080001 | 2108668.89946 | 37.770107174421796 | -122.436951364836 | (37.7701071744218, -122.436951364836) | |||
24628 | 24628 | 193040 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1890 Evans Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6014266.5091 | 2099591.88048 | 37.745881580665 | -122.393364845912 | (37.745881580665, -122.393364845912) | |||
24639 | 24639 | 229283 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 995 Potrero Ave | 12 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6010503.18066 | 2104324.48808 | 37.758666470594896 | -122.40671143888099 | (37.7586664705949, -122.406711438881) | |||
24687 | 24687 | 188070 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2001 Revere Ave | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 6012192.04216 | 2096531.53608 | 37.737363051155796 | -122.400323196466 | (37.7373630511558, -122.400323196466) | |||
24712 | 24712 | 189244 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 690 Texas St | 5 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6013923.095430001 | 2103892.83973 | 37.757672010179206 | -122.394853496397 | (37.7576720101792, -122.394853496397) | |||
24717 | 24717 | 189454 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 110 Mendell St | 6 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6016981.3442400005 | 2098379.09321 | 37.742701973620704 | -122.38389280032801 | (37.7427019736207, -122.383892800328) | |||
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) | |||
24738 | 24738 | 207248 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 574 Arch St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5992756.55156 | 2091026.1972 | 37.7211438059241 | -122.46711999608401 | (37.7211438059241, -122.467119996084) | |||
24744 | 24744 | 201156 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 3450 03rd St | 9 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6016026.4688099995 | 2099308.87493 | 37.745202130272204 | -122.387259357554 | (37.7452021302722, -122.387259357554) | |||
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) | |||
24967 | 24967 | 241232 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 127 Duboce Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6005861.10215 | 2108452.80959 | 37.7697410460526 | -122.42305931235201 | (37.7697410460526, -122.423059312352) | |||
25051 | 25051 | 204106 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 400 Junipero Serra Blvd | 15 | : 4 | Tree 1 | Private 1 | 2 | Width 0ft | 5991380.91771 | 2094122.22642 | 37.7295652311304 | -122.47210067183399 | (37.7295652311304, -122.472100671834) | |||
25052 | 25052 | 196384 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 99 Stillman St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 0ft | 6013750.52811 | 2112736.60264 | 37.781945415491705 | -122.396070069587 | (37.7819454154917, -122.396070069587) | |||
25060 | 25060 | 85220 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 603 22nd Ave | 3 | : 4 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 3 | Permit Number 49541 | 5989076.71677 | 2111162.9995 | 37.776221041753296 | -122.48131384215401 | (37.7762210417533, -122.481313842154) | ||
25088 | 25088 | 189157 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2 Shipley St | 5 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6012230.29612 | 2112453.73281 | 37.78108402055079 | -122.40130951984501 | (37.7810840205508, -122.401309519845) | |||
25109 | 25109 | 241253 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 398 Guerrero St | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6005480.91961 | 2106731.68653 | 37.764993792043 | -122.424251927594 | (37.764993792043, -122.424251927594) | |||
25112 | 25112 | 192821 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 674 Harrison St | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6013431.41739 | 2113070.8325900002 | 37.782845374266 | -122.39719749747101 | (37.782845374266, -122.397197497471) | |||
25118 | 25118 | 249530 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 236 Myrtle St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6006266.61639 | 2114058.0965400003 | 37.7851546812964 | -122.422054907229 | (37.7851546812964, -122.422054907229) | |||
25127 | 25127 | 200366 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1300 Phelps St | 8 | : 4 | Tree 1 | Private 1 | 12 | Width 5ft | 6014047.106269999 | 2096372.4575200002 | 37.7370295240776 | -122.393898196954 | (37.7370295240776, -122.393898196954) | |||
25148 | 25148 | 220775 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2800 Mariposa St | 6 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6009066.85397 | 2105930.68426 | 37.762996251197706 | -122.411792424993 | (37.7629962511977, -122.411792424993) | |||
25166 | 25166 | 188682 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 Evans Ave | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6018053.21017 | 2096769.99546 | 37.738342908392504 | -122.38007476635299 | (37.7383429083925, -122.380074766353) | |||
25171 | 25171 | 211740 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 700 Junipero Serra Blvd | 63 | : 4 | Tree 1 | Private 1 | 9 | Width 0ft | 5991241.75535 | 2092369.0008200002 | 37.72474325697279 | -122.47245400105601 | (37.7247432569728, -122.472454001056) | |||
25174 | 25174 | 190061 | Undocumented 2 | Cinnamomum camphora :: Camphor Tree 230 | 601 Amador St | 13 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6017204.2758599995 | 2099516.9489700003 | 37.74583861556479 | -122.38320114162902 | (37.7458386155648, -122.383201141629) | |||
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) | |||
25248 | 25248 | 188298 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1022 Minna St | 3 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6007537.97287 | 2109701.89036 | 37.7732652094644 | -122.41734758044 | (37.7732652094644, -122.41734758044) | |||
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) | |||
25324 | 25324 | 204254 | Undocumented 2 | Arbutus unedo :: Strawberry Tree 61 | 81 Elmhurst Dr | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5991110.1119800005 | 2094515.36236 | 37.7306290086229 | -122.473065523856 | (37.7306290086229, -122.473065523856) | |||
25347 | 25347 | 235710 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2800 18th St | 3 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6009444.36409 | 2105489.04346 | 37.7618047771799 | -122.41045555487301 | (37.7618047771799, -122.410455554873) | |||
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) | |||
25370 | 25370 | 191599 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2091 Bancroft Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6011675.2321 | 2094112.7806 | 37.730692823599 | -122.40194007767799 | (37.730692823599, -122.401940077678) | |||
25454 | 25454 | 227130 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 200 Portola Dr | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5999573.3022300005 | 2100550.7346900003 | 37.747687072210105 | -122.44424063169599 | (37.7476870722101, -122.444240631696) | |||
25479 | 25479 | 246475 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 318 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6004316.48172 | 2099879.2195200003 | 37.7461127118429 | -122.427791134863 | (37.7461127118429, -122.427791134863) | |||
25486 | 25486 | 191565 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1610 Innes Ave | 4 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6015282.07976 | 2097432.30639 | 37.7400082082253 | -122.389702305632 | (37.7400082082253, -122.389702305632) | |||
25521 | 25521 | 192172 | Undocumented 2 | Ficus rubiginosa :: Port Jackson Fig 188 | 1601 Kansas St | 9 | : 4 | Tree 1 | Private 1 | 51 | Width 7ft | 6011813.79085 | 2100866.0430099997 | 37.749243580141204 | -122.40193560806001 | (37.7492435801412, -122.40193560806) | |||
25562 | 25562 | 204156 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 900 Junipero Serra Blvd | 106 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991140.12525 | 2090380.53407 | 37.719277536403496 | -122.472660407165 | (37.7192775364035, -122.472660407165) | |||
25564 | 25564 | 197127 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 101 Newhall St | 13 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6017303.080490001 | 2098110.9339400004 | 37.7419834431736 | -122.382761660942 | (37.7419834431736, -122.382761660942) | |||
25615 | 25615 | 178137 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 20 Brotherhood Way | 8 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5992316.61451 | 2087859.0919400002 | 37.712422298533895 | -122.46841041712901 | (37.7124222985339, -122.468410417129) | |||
25645 | 25645 | 188622 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 3601 03rd St | 20 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6016025.72974 | 2098951.35828 | 37.744220422250294 | -122.387236979699 | (37.7442204222503, -122.387236979699) | |||
25659 | 25659 | 194764 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1101 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 6ft | 6014997.18752 | 2096468.24359 | 37.737345287747395 | -122.390620003515 | (37.7373452877474, -122.390620003515) | |||
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) |
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");