trees

8,298 rows where qLegalStatus_id = 4 sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

rowid ▲ TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
191884 109027 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 1800x FOLSOM ST 27 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007970.1 2107738.8 37.7678993280557 -122.415713764528 (37.7678993280557, -122.415713764528) 8 4 7 28853 19
191873 256046 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 200 The Embarcadero 3 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6015452 2116243 37.7916677028969 -122.390428783846 (37.7916677028969, -122.390428783846) 6 2 9 28855 6
191845 113244 Undocumented 4 Gleditsia triacanthos :: Honey Locust 182 1301X 04TH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       5x5   5994883 2106671 37.7642230519674 -122.46090282761 (37.7642230519674, -122.46090282761) 15 5 11 56 12
191826 109304 Undocumented 4 Tree(s) :: 17 251 RHODE ISLAND ST 9 Sidewalk: Curb side : Cutout Tree Private 2   03/05/2015 12:00:00 AM 3 3x3 Permit Number 774538 6011759.4 2107238.5 37.7667379021668 -122.402571748171 (37.7667379021668, -122.402571748171) 8 2 8 28853 20
191821 104940 Undocumented 4 Pinus radiata :: Monterey Pine 15 111X Gonzalez Dr   Sidewalk: Curb side : Yard Tree Private 2           5990327.80869 2090136.76282 37.718561145924 -122.475450461306 (37.718561145924, -122.475450461306) 1 8 4 64 14
191777 110220 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 600X QUINTARA ST 2 Sidewalk: Curb side : Cutout Tree Private 2       6x20   5991588 2101192 37.7489890115011 -122.471899832047 (37.7489890115011, -122.471899832047) 1 8 4 29491 12
191751 115547 Undocumented 4 Grevillea robusta :: Silk Oak Tree 76 780 DOUGLASS ST 7 Sidewalk: Property side : Yard Tree Rec/Park 5       3x3   6001139 2101871 37.7514014062737 -122.438921147793 (37.7514014062737, -122.438921147793) 2 4 5 28862 22
191744 122810 Undocumented 4 Hymenosporum flavum :: Sweet Shade 125 1801 15th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005422 2107198 37.7662708507612 -122.424488887708 (37.7662708507612, -122.424488887708) 8 4 5 28853 19
191724 104336 Undocumented 4 Syagrus romanzoffianum :: Queen Palm 85 1X Beaver St 5 Sidewalk: Property side : Cutout Tree Private 2       3x3   6002844 2106791 37.7650074058753 -122.433376604069 (37.7650074058753, -122.433376604069) 15 5 5 28862 3
191718 239535 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 5 Bennington St 1 Sidewalk: Curb side : Cutout Tree Private 2       Width 3ft   6007214.41178 2097683.04521 37.7402460150284 -122.417614810389 (37.7402460150284, -122.417614810389) 2 7 7 28859 2
191717 255636 Undocumented 4 Fraxinus oxycarpa :: Ash 213 590 Masonic Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   5999354 2110868 37.7760032005164 -122.445740824021 (37.7760032005164, -122.445740824021) 15 5 11 29492 16
191692 121621 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 298X Staples Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5998141 2093851 37.7292093905587 -122.448710954214 (37.7292093905587, -122.448710954214) 9 7 4 28861 40
191685 193733 Undocumented 4 Melaleuca quinquenervia :: Cajeput 10 210 Channel 8 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 5ft   6014775.46671 2109801.19254 37.7739424115586 -122.392318855239 (37.7739424115586, -122.392318855239) 14 3 9 310 20
191660 256163 Undocumented 4 Prunus caroliniana :: Carolina Cherry Laurel 315 300X Peralta Ave 2 Sidewalk: Property side : Yard Tree Private 2       3x3   6009722 2099567 37.7455597283682 -122.409077438923 (37.7455597283682, -122.409077438923) 2 7 7 28859 2
191648 121037 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1830 Polk St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006566 2117108 37.7935458417616 -122.421235781398 (37.7935458417616, -122.421235781398) 13 9 10 28858 32
191586 98496 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1X Miley St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000842 2108958 37.7708436665375 -122.44045643654 (37.7708436665375, -122.44045643654) 15 5 11 29492 9
191570 116847 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 987 ALABAMA ST 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6009201 2103425 37.7561237360793 -122.411151453462 (37.7561237360793, -122.411151453462) 2 4 7 28859 19
191540 112616 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 2399X DIVISADERO ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000719 2116473 37.7914709305552 -122.441421227792 (37.7914709305552, -122.441421227792) 13 6 1 29490 27
191476 121091 Undocumented 4 Cedrus deodara :: Deodar Cedar 109 30X Grand View Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000475 2103841 37.7567727470696 -122.441358672007 (37.7567727470696, -122.441358672007) 2 4 5 28862 38
191471 111909 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 1699x WASHINGTON ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006657 2116952 37.7931226344993 -122.420909832708 (37.7931226344993, -122.420909832708) 13 9 10 28858 32
191446 112687 Undocumented 4 Tree(s) :: 17 180 11th St 1 Sidewalk: Curb side : Cutout Tree Private 2           6007870.8 2109792.5 37.7735327221011 -122.416202701672 (37.7735327221011, -122.416202701672) 8 2 9 28853 19
191440 102008 Undocumented 4 Tree(s) :: 17 1703 Castro St 5 Sidewalk: Property side : Cutout Tree Private 2       3x3   6002624 2100623.7 37.7480609930318 -122.433696712327 (37.7480609930318, -122.433696712327) 2 4 5 63 22
191406 256241 Undocumented 4 Pyrus calleryana :: Ornamental Pear 44 132 Shipley St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012189 2112453 37.7810797043555 -122.401452333097 (37.7810797043555, -122.401452333097) 6 2 9 28856 34
191350 102665 Undocumented 4 Pittosporum crassifolium :: Karo Tree 95 3399X Wawona St 6 Sidewalk: Property side : Cutout Tree Private 2       3x3   5982463.4 2096719.2 37.7361757338901 -122.503121118731 (37.7361757338901, -122.503121118731) 1 8 3 29491 35
191343 254839 Undocumented 4 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 673 03rd Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/29/2018 12:00:00 AM 3 3x3   5994992 2110964 37.776016775414 -122.460836981253 (37.776016775414, -122.460836981253) 11 6 2 54 11
191231 101261 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 1945 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5989742 2106485 37.7634151902649 -122.478670277794 (37.7634151902649, -122.478670277794) 1 8 3 56 35
191185 256586 Undocumented 4 Ginkgo biloba :: Maidenhair Tree 22 2x Stillman St 13 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014165 2112908 37.7824390851954 -122.394648183134 (37.7824390851954, -122.394648183134) 6 2 9 28856 6
191181 116120 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 1649x NEWHALL ST 2 Sidewalk: Curb side : Cutout Tree Private 2       2x2   6014119 2095297 37.7340805339716 -122.393574379436 (37.7340805339716, -122.393574379436) 10 3 8 58 1
191154 113979 Undocumented 4 Prunus cerasifera :: Cherry Plum 7 1180 STANYAN ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997407 2106053 37.7626710894654 -122.452128484278 (37.7626710894654, -122.452128484278) 15 5 11 29492 9
191113 117175 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 1035 ASHBURY ST 1 Sidewalk: Curb side : Cutout Tree Private 2       4x4   5999075 2106504 37.7640048293756 -122.446391937786 (37.7640048293756, -122.446391937786) 15 5 11 29492 9
191099 100527 Undocumented 4 Ficus nitida :: Laurel Fig 53 1728 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2       4.5x6   6008341 2118363 37.7970916696404 -122.415182998934 (37.7970916696404, -122.415182998934) 5 1 10 308 21
191098 255052 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 199x 09th St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008753 2110574 37.7757281025158 -122.413206304146 (37.7757281025158, -122.413206304146) 8 2 9 28853 34
191059 258059 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 600 California St 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011288 2116842 37.793080546408 -122.404878460446 (37.793080546408, -122.404878460446) 3 1 10 28857 4
191057 100769 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 3701 21st St   Front Yard : Yard Tree Private 2     55   Street tree w/in RoW 6003717 2103606 37.7563116466144 -122.43012988292 (37.7563116466144, -122.43012988292) 2 4 5 28862 22
191048 105827 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 930 ELIZABETH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     6     6000439.7 2102016.1 37.7517600039536 -122.441349813189 (37.7517600039536, -122.441349813189) 2 4 5 28862 22
191026 115633 Undocumented 4 New Zealand Tea Tree :: New Zealand Tea Tree 448 4567 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2       4x9   6000786.8 2104618.2 37.7589245060719 -122.44033609165 (37.7589245060719, -122.44033609165) 2 4 5 28862 38
191011 112671 Undocumented 4 Myoporum laetum :: Myoporum 62 556 LAIDLEY ST 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6002981 2095978 37.7353252270309 -122.432130507541 (37.7353252270309, -122.432130507541) 2 7 5 63 7
190979 104758 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 50 Walnut St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5998501.2 2116298 37.790863832623 -122.449082132455 (37.790863832623, -122.449082132455) 13 6 1 54 31
190973 114057 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 700X LAKE MERCED BLVD 3 Median : Cutout Tree Private 2     46     5987837 2092819 37.7257811856502 -122.484256664993 (37.7257811856502, -122.484256664993) 1 8 4 64 14
190925 92919 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 362 West Portal Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9     5991957 2096928 37.7373025018195 -122.470313361151 (37.7373025018195, -122.470313361151) 1 8 4 59 40
190900 112191 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 399X 05TH ST 2 Sidewalk: Property side : Cutout Tree Private 2     15     6012019 2111820 37.7793321462044 -122.401995938922 (37.7793321462044, -122.401995938922) 6 2 9 28856 34
190879 71596 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 75 Rice St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/30/1995 12:00:00 AM 12 2x3   5995358.56494273 2086411.36688337 37.7086224204841 -122.457791883945 (37.7086224204841, -122.457791883945) 9 7 6 28861 25
190860 112675 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 500x FILBERT ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010481 2120003 37.8017147408613 -122.407893747059 (37.8017147408613, -122.407893747059) 3 1 10 308 23
190859 105687 Undocumented 4 Tree(s) :: 17 635 08TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     15 4x4 Permit Number 771004 6011418.5 2109097.9 37.7718243537934 -122.403881727597 (37.7718243537934, -122.403881727597) 14 2 9 28853 34
190854 97981 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 325 Bowdoin St 11 Front Yard : Yard Tree Private 2       3x105   6008582.5 2094142.5 37.7306013339748 -122.412634267782 (37.7306013339748, -122.412634267782) 9 3 7 309 28
190709 108418 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 270X HAYES ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006095.6 2111028.7 37.7768270516853 -122.422431244298 (37.7768270516853, -122.422431244298) 7 9 11 28852 10
190688 34955 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 11 16th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 38552 5990784 2114938 37.786685259507 -122.475683667555 (37.786685259507, -122.475683667555) 11 6 1 54 33
190638 106655 Undocumented 4 Ginkgo biloba :: Maidenhair Tree 22 899X BRODERICK ST 2 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6000958 2111726 37.7784505017056 -122.440253723857 (37.7784505017056, -122.440253723857) 15 5 11 29490 41
190636 114113 Undocumented 4 Pinus radiata :: Monterey Pine 15 1200X JUNIPERO SERRA BLVD 4 Sidewalk: Property side : Yard Tree Private 2     40     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
190627 108795 Undocumented 4 :: 45 501-599 University St 2 Sidewalk: Curb side : Cutout Tree Private 2           6008503.45306 2091469.83252 37.7232583218261 -122.412718672961 (37.7232583218261, -122.412718672961) 9 3 7 309 18
190599 107254 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 185 Channel St 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015121.46625 2109958.82043 37.7743944293137 -122.391132995212 (37.7743944293137, -122.391132995212) 14 3 9 310 20
190582 112276 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 3410 17TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6006056 2106092 37.7632698189292 -122.422217414098 (37.7632698189292, -122.422217414098) 8 4 5 28859 19
190560 108342 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 390x JERSEY ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002599 2101610 37.7507677214535 -122.433853648065 (37.7507677214535, -122.433853648065) 2 4 5 28862 22
190551 99776 Undocumented 4 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 800x Diamond St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 4205 24th St corner property 6001819.1 2101713.8 37.7510084437682 -122.436558035286 (37.7510084437682, -122.436558035286) 2 4 5 28862 22
190547 257948 Undocumented 4 Tristania conferta :: 61 901x Gough St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005635 2113075 37.782419697088 -122.42417016492 (37.782419697088, -122.42417016492) 7 9 11 28852 41
190527 106859 Undocumented 4 Prunus cerasifera :: Cherry Plum 7 946 RHODE ISLAND ST   Sidewalk: Curb side : Cutout Tree Private 2   12/02/2015 12:00:00 AM 14 3x3 Permit Number 773008 6011839.2 2104029.4 37.7579308843014 -122.402070102772 (37.7579308843014, -122.402070102772) 10 3 8 28856 29
190477 122358 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 155 Appleton Ave 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006071 2097171 37.7387756468895 -122.421531918974 (37.7387756468895, -122.421531918974) 2 7 7 28859 2
190459 114808 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1794 FILBERT ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004381 2119146 37.7990182441371 -122.428941422903 (37.7990182441371, -122.428941422903) 13 9 1 57 17
190456 103270 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 350 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004879 2109882 37.7736097878739 -122.426558160091 (37.7736097878739, -122.426558160091) 7 9 11 28852 10
190393 105665 Undocumented 4 Eucalyptus Spp :: Eucalyptus 52 317X DORADO TER 2 unknown : Yard Tree Private 2     24     5994307.4 2093021.4 37.7267115488018 -122.461903806308 (37.7267115488018, -122.461903806308) 9 8 4 28861 40
190388 103353 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 1000X Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2 Rec/Park   10 3x3   6009105.1 2116370.5 37.7916636644225 -122.412398106821 (37.7916636644225, -122.412398106821) 5 1 10 28857 21
190384 111138 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 307 05TH ST 3 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6011748 2112130 37.780168205546 -122.402955256196 (37.780168205546, -122.402955256196) 6 2 9 28856 34
190351 110732 Undocumented 4 Ficus nitida :: Laurel Fig 53 3515 25TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006381 2101411 37.7504352040325 -122.420761009138 (37.7504352040325, -122.420761009138) 2 4 5 28859 19
190333 120920 Undocumented 4 Cupressus macrocarpa :: Monterey Cypress 41 198X Miraloma Dr 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3x10   5994595 2096392 37.7359829456919 -122.461153801837 (37.7359829456919, -122.461153801837) 9 8 4 59 40
190302 108423 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 270X HAYES ST 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006095.6 2111028.7 37.7768270516853 -122.422431244298 (37.7768270516853, -122.422431244298) 7 9 11 28852 10
190284 110164 Undocumented 4 Tree(s) :: 17 121x GARCES DR 1 Front Yard : Yard Tree Private 2   06/06/2016 12:00:00 AM 3   Permit Number 777996 5989202 2088902 37.7151054701837 -122.479251597893 (37.7151054701837, -122.479251597893) 1 8 4 64 14
190244 101177 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 408 IRVING ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5994501 2106722 37.7643410968681 -122.462227745791 (37.7643410968681, -122.462227745791) 11 5 11 56 12
190210 117241 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 635 GROVE ST 13 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004711 2111132 37.7770324835269 -122.427228354699 (37.7770324835269, -122.427228354699) 7 9 11 28852 10
190202 99163 Undocumented 4 Pinus radiata :: Monterey Pine 15 302X Pacheco St 47 Median : Cutout Tree Private 2     18     5994341.5 2100725.2 37.7478662384021 -122.46234443277 (37.7478662384021, -122.46234443277) 1 8 4 29491 40
190196 101232 Undocumented 4 Tree(s) :: 17 3575 Sacramento St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/28/2016 12:00:00 AM 3 3x3 Permit Number 779254 5997770 2115107 37.7875518165957 -122.451526095937 (37.7875518165957, -122.451526095937) 11 6 1 54 31
190171 98321 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 1899X Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2     48 3x3   6001966.9 2114999.4 37.7874958161075 -122.4369979772 (37.7874958161075, -122.4369979772) 13 6 11 29490 27
190127 122355 Undocumented 4 Quercus agrifolia :: Coast Live Oak 172 155 Appleton Ave 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006071 2097171 37.7387756468895 -122.421531918974 (37.7387756468895, -122.421531918974) 2 7 7 28859 2
190111 110801 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 950 CALIFORNIA ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009776 2116634 37.7924247975925 -122.410095399183 (37.7924247975925, -122.410095399183) 5 1 10 28857 21
190092 117275 Undocumented 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 3431 19TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x6   6006713 2104938 37.7601382406988 -122.419863171522 (37.7601382406988, -122.419863171522) 2 4 7 28859 19
190068 122360 Undocumented 4 Quercus agrifolia :: Coast Live Oak 172 155 Appleton Ave 11 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006071 2097171 37.7387756468895 -122.421531918974 (37.7387756468895, -122.421531918974) 2 7 7 28859 2
190051 112678 Undocumented 4 Pyrus calleryana :: Ornamental Pear 44 490x GREEN ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010628 2119373 37.7999931439643 -122.40734061853 (37.7999931439643, -122.40734061853) 3 1 10 308 23
190036 106719 Undocumented 4 Tree(s) :: 17 250 LOBOS ST 1 Sidewalk: Curb side : Cutout Tree Private 2           5994500.7 2088749 37.7149916889742 -122.460926063368 (37.7149916889742, -122.460926063368) 9 8 6 28861 24
189944 116195 Undocumented 4 Crataegus laevigata :: English Hawthorn 133 3751 CLAY ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996888 2115293 37.7880119756846 -122.454591065245 (37.7880119756846, -122.454591065245) 11 6 1 54 31
189932 114531 Undocumented 4 Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 31 BAY VIEW ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014415 2094670 37.7323753626402 -122.392507164078 (37.7323753626402, -122.392507164078) 10 3 8 58 1
189858 108154 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 350 HILL ST 1 Sidewalk: Curb side : Cutout Tree Private 2     20 3x3   6004022.3 2103383.2 37.7557171771691 -122.42905816498 (37.7557171771691, -122.42905816498) 2 4 5 28862 22
189834 115103 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 98X HEMLOCK ST 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6006944 2114961 37.7876720140792 -122.419775454842 (37.7876720140792, -122.419775454842) 13 9 10 28858 21
189824 184385 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2243 26th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   5988218.295 2100024.3615 37.7455874284311 -122.483466560329 (37.7455874284311, -122.483466560329) 1 8 3 29491 35
189821 99958 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 4204 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6003489 2093971 37.7298432476922 -122.430231025456 (37.7298432476922, -122.430231025456) 9 7 6 28861 25
189793 111944 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 95 SEACLIFF AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     24     5987570 2115773 37.7887910778243 -122.486864535179 (37.7887910778243, -122.486864535179) 11 6 1 55 33
189758 106480 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 310X LAWTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2           5993233 2104592 37.7584195821345 -122.466458543785 (37.7584195821345, -122.466458543785) 1 8 4 56 12
189757 98741 Undocumented 4 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 1150 Scott St 5 Sidewalk: Curb side : Cutout Tree Housing Authority 15 DPW for City Agency 03/21/2012 12:00:00 AM 3 4X4   6002360 2112467 37.7805648236525 -122.435456706153 (37.7805648236525, -122.435456706153) 15 5 11 29490 41
189733 211088 Undocumented 4 Pinus radiata :: Monterey Pine 15 1888 Funston Ave 1 Sidewalk: Curb side : Yard Tree Private 2     56   Permit Number 777893 5992224.94282 2102558.27283 37.7527772781709 -122.469796758012 (37.7527772781709, -122.469796758012) 1 8 4 56 12
189727 104625 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 250 04th St 3 Sidewalk: Curb side : Cutout Tree Private 2 MTA     3x3 Permit Number 770961 6012050.5 2112960.1 37.7824643544146 -122.401967135301 (37.7824643544146, -122.401967135301) 6 2 9 28853 34
189678 113157 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 10x IRVING ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5995755 2106778 37.7645669829926 -122.457894591569 (37.7645669829926, -122.457894591569) 15 5 11 56 12
189615 111902 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 2298X GOUGH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005117 2117413 37.7943014988514 -122.426271165337 (37.7943014988514, -122.426271165337) 13 9 1 28858 27
189599 102464 Undocumented 4 Tree(s) :: 17 280 Casitas Ave 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5994944.5 2096334.7 37.735845720803 -122.459941299214 (37.735845720803, -122.459941299214) 9 7 4 59 40
189579 113421 Undocumented 4 Prunus cerasifera :: Cherry Plum 7 598X BENTON AVE 4 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6007207 2095355 37.7338532991757 -122.417475487879 (37.7338532991757, -122.417475487879) 2 7 7 28859 2
189554 102527 Undocumented 4 Tree(s) :: 17 317 Precita Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6008588.7 2100219.6 37.7472880704307 -122.41304236448 (37.7472880704307, -122.41304236448) 2 7 7 28859 2
189547 115246 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 990 Pacific Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   01/20/2016 12:00:00 AM   3x3   6009439.8 2118094.4 37.7964158497349 -122.411361881702 (37.7964158497349, -122.411361881702) 3 1 10 308 4
189540 107247 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 185 Channel St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015121.46625 2109958.82043 37.7743944293137 -122.391132995212 (37.7743944293137, -122.391132995212) 14 3 9 310 20
189496 255885 Undocumented 4 Ficus nitida :: Laurel Fig 53 50 Columbia Square St 6 Sidewalk: Curb side : Cutout Tree Rec/Park 5 Private     3x3   6010942 2111079 37.7772373644855 -122.405669544588 (37.7772373644855, -122.405669544588) 14 2 9 28853 34
189482 97895 Undocumented 4 Eriobotrya deflexa :: Bronze Loquat 8 375X Precita Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW   3 3x3   6008901.5 2100225.6 37.7473220995732 -122.411961145064 (37.7473220995732, -122.411961145064) 2 7 7 28859 2
189477 102617 Undocumented 4 Ulmus spp :: Elm Spp 98 2000X Stockton St 2 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6009928.4 2120915.8 37.8041901109125 -122.409870477339 (37.8041901109125, -122.409870477339) 3 1 10 308 23
189475 105446 Undocumented 4 Tree(s) :: 17 44 MUSEUM WAY 1 Sidewalk: Curb side : Cutout Tree Private 2   11/17/2015 12:00:00 AM 22 4x4 Permit Number 776880 6000683.8 2106710.7 37.7646641311164 -122.440842417505 (37.7646641311164, -122.440842417505) 15 5 5 28862 3
189460 227971 Undocumented 4 Liquidambar styraciflua :: American Sweet Gum 37 355 Precita Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6008783.05116 2100218.42191 37.7472957438977 -122.412370226806 (37.7472957438977, -122.412370226806) 2 7 7 28859 2

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);