Street_Tree_List

Data source: data.sfgov.org

21,950 rows where qCareAssistant = 1

View and edit SQL

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
73 65479 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1051 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/01/1997 12:00:00 AM 10 3x3 Permit Number 28361 6008468.497880001 2115537.43749 37.789340533487795 -122.41454177659901 (37.7893405334878, -122.414541776599)
77 49739 Permitted Site 1 Tree(s) :: 17 145 Missouri St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/22/2017 12:00:00 AM 3   Permit Number 779552 6013462.1222 2106403.54987 37.764540227980206 -122.396623740816 (37.7645402279802, -122.396623740816)
121 59839 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 1201 Palou Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/10/1981 12:00:00 AM 3   Permit Number 19293 6016946.5018 2093669.1216 37.729767407645895 -122.383685429115 (37.7297674076459, -122.383685429115)
130 66855 Permitted Site 1 Maytenus boaria :: Mayten 22 2041 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/15/1991 12:00:00 AM 8   Permit Number 30161 5998071.2779 2109932.9259 37.7733624072524 -122.450110663343 (37.7733624072524, -122.450110663343)
268 46773 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 35 San Juan Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/03/2017 12:00:00 AM 3   Permit Number 779460 6001741.72526 2092006.08473 37.7243489150655 -122.43613098976101 (37.7243489150655, -122.436130989761)
310 30658 Permitted Site 1 Jacaranda mimosifolia :: Jacaranda 52 47 Lafayette St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/30/1995 12:00:00 AM 6 3x3 Permit Number 34591 6007577.417719999 2109608.9608 37.7730122661246 -122.41720454865299 (37.7730122661246, -122.417204548653)
403 65940 Planning Code 138.1 required 4 Liquidambar styraciflua :: American Sweet Gum 62 620 Eddy St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/04/1990 12:00:00 AM 8   Permit Number 28961 6007431.46715 2113367.23378 37.78332336932171 -122.41797588370702 (37.7833233693217, -122.417975883707)
554 31894 Permitted Site 1 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 333 12th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/26/1995 12:00:00 AM 6   Permit Number 35323 6008421.36423 2108725.6861900003 37.7706344442547 -122.41422271959999 (37.7706344442547, -122.4142227196)
624 70356 Undocumented 2 Pyrus calleryana :: Ornamental Pear 9 1912 Polk St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/07/1994 12:00:00 AM 5     6006535.5562 2117410.9094 37.7943758388735 -122.42136264060801 (37.7943758388735, -122.421362640608)
802 64866 Permitted Site 1 Metrosideros excelsa :: New Zealand Xmas Tree 2 2185 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/02/1989 12:00:00 AM 13   Permit Number 25884 5997401.9097 2109840.7512 37.773070992957 -122.45241943675501 (37.773070992957, -122.452419436755)
878 108700 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 3024 Pierce St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 772805 6001479.41501 2118822.32035 37.7979648412708 -122.438958648025 (37.7979648412708, -122.438958648025)
959 83601 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 1 Jones St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/22/2008 12:00:00 AM 5     6009088.96788 2112689.1650900003 37.7815547005346 -122.41219362785499 (37.7815547005346, -122.412193627855)
1060 71174 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 1432 Santiago St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/22/1995 12:00:00 AM 3     5988368.0802 2099689.3718 37.7446763519612 -122.48292408536301 (37.7446763519612, -122.482924085363)
1069 80004 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 881 44th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/01/2017 12:00:00 AM 3   Permit Number 779791 5982299.17664 2109781.12407 37.772030443625795 -122.504656395048 (37.7720304436258, -122.504656395048)
1107 52527 Permitted Site 1 Dodonaea viscosa :: Hop Bush 132 123 San Juan Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/28/2005 12:00:00 AM 5 2x3 Permit Number 779986 6001343.89555 2092234.3638799998 37.7249531074958 -122.437522568322 (37.7249531074958, -122.437522568322)
1112 38268 Permitted Site 1 Acer rubrum 'Armstrong' :: Armstrong Red Maple 87 1300 22nd St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/03/2017 12:00:00 AM 3 3x3 Permit Number 42733 6014084.1716 2103880.9585 37.757648341819205 -122.39429559298401 (37.7576483418192, -122.394295592984)
1184 59673 Permitted Site 1 Crataegus phaenopyrum :: Washington Hawthorn 135 531 Grove St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/31/1994 12:00:00 AM 3 3x3 Permit Number 33280 6005241.131 2111282.5171 37.777475732552205 -122.425405179356 (37.7774757325522, -122.425405179356)
1250 31791 Permitted Site 1 Schinus terebinthifolius :: Brazilian Pepper 25 186 Alpine Ter 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/08/2017 12:00:00 AM 3   Permit Number 779904 6001704.83909 2107714.56044 37.767478581987206 -122.437382809181 (37.7674785819872, -122.437382809181)
1252 61532 Permitted Site 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 347 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/08/2017 12:00:00 AM 3   Permit Number 772896 5991195.07104 2113068.5037599998 37.781575964268896 -122.474125016615 (37.7815759642689, -122.474125016615)
1255 65778 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 3101 Scott St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/23/1990 12:00:00 AM 5   Permit Number 28743 6000913.14979 2119077.92932 37.7986344413927 -122.440936428972 (37.7986344413927, -122.440936428972)
1339 66377 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 621 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/04/1991 12:00:00 AM 12   Permit Number 29502 6003558.1677 2110522.6128 37.775293994216 -122.431172851087 (37.775293994216, -122.431172851087)
1356 36153 Permitted Site 1 Rhaphiolepis indica :: India Hawthorn 144 51 Commonwealth Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/01/1998 12:00:00 AM 8   Permit Number 39237 5996490.2429 2114232.4446 37.7850771527555 -122.455890527593 (37.7850771527555, -122.455890527593)
1362 36186 Permitted Site 1 Acacia baileyana :: Bailey's Acacia 42 133 Palm Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/04/1998 12:00:00 AM 8   Permit Number 39255 5995881.41756 2113499.8369 37.783030646722004 -122.45794382331002 (37.783030646722, -122.45794382331)
1366 81793 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 435 Hayes St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/17/2004 12:00:00 AM 5 3x3   6005759.2342 2111006.7416 37.7767477786156 -122.42359327476801 (37.7767477786156, -122.423593274768)
1367 36152 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 51 Commonwealth Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/01/1998 12:00:00 AM 4   Permit Number 39237 5996489.9045 2114249.7041 37.7851245233187 -122.455892946486 (37.7851245233187, -122.455892946486)
1382 43084 Permitted Site 1 Grevillea robusta :: Silk Oak Tree 145 240 Jones St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/07/2000 12:00:00 AM 9   Permit Number 42924 6009033.5618199995 2113426.61378 37.783576449329296 -122.412437449347 (37.7835764493293, -122.412437449347)
1402 108699 Permitted Site 1 Melaleuca quinquenervia :: Cajeput 50 2956 Scott St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 774624 6001032.64864 2118516.20126 37.797098889465 -122.4404826167 (37.797098889465, -122.4404826167)
1582 45051 DPW Maintained 3 Tristaniopsis laurina :: Swamp Myrtle 37 2243 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/08/2001 12:00:00 AM 3   Permit Number 43936 5988218.295 2100043.5647 37.7456401553342 -122.483467967859 (37.7456401553342, -122.483467967859)
1659 251643 Undocumented 2 Tree(s) :: 17 2701 Leavenworth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1     3x3   6007328.0 2121670.0 37.8061148757045 -122.418922903139 (37.8061148757045, -122.418922903139)
1696 108698 Permitted Site 1 Ginkgo biloba :: Maidenhair Tree 44 2922 Lyon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 774622 5999117.98057 2118844.23155 37.7978903639015 -122.447131431372 (37.7978903639015, -122.447131431372)
1767 108696 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 3219 Laguna St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 774620 6003723.121830001 2119813.07153 37.8008125903965 -122.431265542364 (37.8008125903965, -122.431265542364)
1788 108703 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 2436 Greenwich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 772910 6001246.11089 2119029.77225 37.798521172675294 -122.439780826226 (37.7985211726753, -122.439780826226)
1801 251699 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 1230 Chestnut St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/05/2017 12:00:00 AM 3 4x3 Permit Number 778360 6005943.79297 2120373.7363400003 37.8024776288704 -122.423620966152 (37.8024776288704, -122.423620966152)
1809 172747 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 1230 Chestnut St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/05/2017 12:00:00 AM 3 4x3 Permit Number 778360 6006022.78943 2120387.12776 37.802518857014704 -122.423348551388 (37.8025188570147, -122.423348551388)
1812 172746 Planning Code 138.1 required 4 Lophostemon confertus :: Brisbane Box 11 1230 Chestnut St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/05/2017 12:00:00 AM 3 4x3 Permit Number 778360 6006038.86692 2120389.38612 37.8025259652646 -122.423293075825 (37.8025259652646, -122.423293075825)
1815 71427 Undocumented 2 Acacia baileyana :: Bailey's Acacia 42 1852 Stockton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/06/2017 12:00:00 AM 3 4x4   6009993.7542 2120480.0499 37.802997311571104 -122.409613538987 (37.8029973115711, -122.409613538987)
1846 251738 Permitted Site 1 Pittosporum crassifolium :: Karo Tree 108 859 Prague St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1         6002345.06488 2087027.78932 37.7107138789231 -122.433689697349 (37.7107138789231, -122.433689697349)
1863 33121 Permitted Site 1 Tree(s) :: 17 2360 Greenwich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/08/2017 12:00:00 AM 3   Permit Number 780047 6001597.15977 2119079.49 37.7986776600995 -122.438569654391 (37.7986776600995, -122.438569654391)
1977 35358 Permitted Site 1 Melaleuca quinquenervia :: Cajeput 50 861 Rhode Island St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/14/2017 12:00:00 AM 3   Permit Number 779956 6011891.4551800005 2104381.4501400003 37.758900452609794 -122.401914128638 (37.7589004526098, -122.401914128638)
2039 45572 Permitted Site 1 Tree(s) :: 17 1951 Lyon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/19/2017 12:00:00 AM 3   Permit Number 779446 5999433.18152 2115607.6653299998 37.7890216140951 -122.44580786133999 (37.7890216140951, -122.44580786134)
2166 43082 Permitted Site 1 Grevillea 'Red Hooks' :: Silk Oak Tree 'Red Hooks' 171 205 Jones St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/28/2003 12:00:00 AM 21   Permit Number 46999 6009001.971030001 2113315.3872700003 37.783269275104104 -122.412538876675 (37.7832692751041, -122.412538876675)
2171 43085 Permitted Site 1 Grevillea 'Red Hooks' :: Silk Oak Tree 'Red Hooks' 171 240 Jones St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/07/2000 12:00:00 AM 15   Permit Number 42924 6009019.84513 2113517.34513 37.7838248061099 -122.412491319636 (37.7838248061099, -122.412491319636)
2172 43089 Permitted Site 1 Grevillea 'Red Hooks' :: Silk Oak Tree 'Red Hooks' 171 240 Jones St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/07/2000 12:00:00 AM 15   Permit Number 42924 6009028.16004 2113458.59755 37.783663965959995 -122.41245839903999 (37.78366396596, -122.41245839904)
2177 43088 Permitted Site 1 Grevillea 'Red Hooks' :: Silk Oak Tree 'Red Hooks' 171 240 Jones St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/07/2000 12:00:00 AM 14   Permit Number 42924 6009031.2139800005 2113438.72212 37.7836095641737 -122.412446428164 (37.7836095641737, -122.412446428164)
2185 43087 Permitted Site 1 Grevillea 'Red Hooks' :: Silk Oak Tree 'Red Hooks' 171 240 Jones St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/07/2000 12:00:00 AM 16   Permit Number 42924 6009022.06951 2113499.20947 37.7837751347655 -122.41248234170601 (37.7837751347655, -122.412482341706)
2215 62177 Permitted Site 1 Tree(s) :: 17 33 Meda Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/24/1985 12:00:00 AM 15 3x3 Permit Number 780357 6000151.498869999 2091775.04378 37.723624054296295 -122.44161159051599 (37.7236240542963, -122.441611590516)
2226 61613 Permitted Site 1 Syagrus romanzoffianum :: Queen Palm 142 1546 Polk St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/12/1995 12:00:00 AM 17   Permit Number 21590 6006691.8914 2116275.8765 37.7912681342545 -122.42074108486 (37.7912681342545, -122.42074108486)
2260 49946 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 2865 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/02/2003 12:00:00 AM 5 3x9 Permit Number 46704 5985860.2058 2096036.9196 37.7345014493544 -122.491326934377 (37.7345014493544, -122.491326934377)
2261 49948 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 2875@ SLOAT 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/02/2003 12:00:00 AM 6 3x9 Permit Number 46705 5985861.2671 2096018.8777 37.7344519730851 -122.491321937714 (37.7344519730851, -122.491321937714)
2262 49949 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 2875@ SLOAT 34th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/02/2003 12:00:00 AM 5 10x3 Permit Number 46705 5985862.3284 2096008.2648 37.7344228948841 -122.491317487651 (37.7344228948841, -122.491317487651)
2368 68207 Permitted Site 1 Pittosporum undulatum :: Victorian Box 26 2048 Stockton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/26/1995 12:00:00 AM 10   Permit Number 31989 6009891.7858 2121179.0457 37.80491086613029 -122.41001577934601 (37.8049108661303, -122.410015779346)
2487 33316 Permitted Site 1 Ginkgo biloba :: Maidenhair Tree 44 1443-1443X Francisco St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/02/2015 12:00:00 AM 3   Permit Number 774619 6004409.7027 2120463.36257 37.8026370063559 -122.42893607346001 (37.8026370063559, -122.42893607346)
2598 110677 Permitted Site 1 Melaleuca quinquenervia :: Cajeput 50 1717 Mason St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/07/2015 12:00:00 AM 3     6009154.39159 2119176.95818 37.7993722757787 -122.412426018055 (37.7993722757787, -122.412426018055)
2683 71631 Undocumented 2 Schinus terebinthifolius :: Brazilian Pepper 25 678 36th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/26/2017 12:00:00 AM 3   Permit Number 780356 5984775.35157 2111233.16415 37.776162677429205 -122.496198392825 (37.7761626774292, -122.496198392825)
2731 49968 Permitted Site 1 Ginkgo biloba :: Maidenhair Tree 44 250 McAllister St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/10/2016 12:00:00 AM 3   Permit Number 773269 6007921.5580400005 2112390.20722 37.7806682603601 -122.416211138647 (37.7806682603601, -122.416211138647)
2748 30802 Permitted Site 1 Ulmus parvifolia :: Chinese Elm 46 109 Chilton Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/06/1995 12:00:00 AM 10 4x6 Permit Number 34667 6001649.83524 2095450.8302099998 37.733802178321 -122.43669510478998 (37.733802178321, -122.43669510479)
2875 53666 Permitted Site 1 Ficus nitida :: Laurel Fig 43 1630 Polk St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/07/1994 12:00:00 AM 17 3x3 Permit Number 772472 6006654.5213 2116532.6022 37.7919709328888 -122.420888619402 (37.7919709328888, -122.420888619402)
2900 70091 Permitted Site 1 :: 54 752 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/12/1992 12:00:00 AM 6 3x3   5988512.5089 2110855.81451 37.7753447787774 -122.483243045223 (37.7753447787774, -122.483243045223)
2938 60590 Permitted Site 1 Magnolia grandiflora :: Southern Magnolia 21 601 Baker St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/07/1983 12:00:00 AM 14 4x4 Permit Number 20209 6000481.0 2111039.0 37.77653700517929 -122.441854521628 (37.7765370051793, -122.441854521628)
2949 32064 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 3650 17th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/09/1995 12:00:00 AM 6   Permit Number 35439 6004539.0 2106054.0 37.76307979631979 -122.427461511029 (37.7630797963198, -122.427461511029)
2974 68083 Permitted Site 1 Syagrus romanzoffianum :: Queen Palm 142 406 Capistrano Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/24/1994 12:00:00 AM 14   Permit Number 780238 6000946.91691 2092398.9049099998 37.725382321520705 -122.438906661816 (37.7253823215207, -122.438906661816)
3061 61313 Permitted Site 1 Tree(s) :: 17 1355 Kansas St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/18/2017 12:00:00 AM 3   Permit Number 780590 6011741.38821 2102064.0767099997 37.752529078769896 -122.402270200829 (37.7525290787699, -122.402270200829)
3291 41799 Permitted Site 1 Tree(s) :: 17 101 Henry Adams St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/30/2017 12:00:00 AM 3 3x3 Permit Number 780552 6011423.81805 2107722.81991 37.7680489940823 -122.403766558473 (37.7680489940823, -122.403766558473)
3387 161273 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 566 Naples St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1   0 Width 0ft   6002889.180369999 2090346.5289900003 37.719857269085104 -122.432045948864 (37.7198572690851, -122.432045948864)
3441 32703 Permitted Site 1 Arbutus unedo :: Strawberry Tree 61 890 Geary St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/29/1996 12:00:00 AM 8 3x3 Permit Number 37106 6007477.85623 2114415.95786 37.7862055211206 -122.417889760126 (37.7862055211206, -122.417889760126)
3455 160606 Undocumented 2 Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 745 Vienna St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1   0 Width 0ft   6002538.27018 2089198.0058799998 37.716683778298 -122.43317690119301 (37.716683778298, -122.433176901193)
3472 47233 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 260 Holyoke St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/09/2002 12:00:00 AM 9 3x3 Permit Number 45176 6009527.90676 2093167.0180900001 37.7279758826708 -122.40929702843701 (37.7279758826708, -122.409297028437)
3489 74967 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 998 Sansome St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/07/1995 12:00:00 AM 8 3x3   6012084.12824 2119041.9172900002 37.799165460472295 -122.40227854024401 (37.7991654604723, -122.402278540244)
3502 35369 Permitted Site 1 Liquidambar styraciflua :: American Sweet Gum 62 628 San Bruno Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/16/2005 12:00:00 AM 8 5x9 Permit Number 780712 6010944.29074 2105222.09895 37.76115577964 -122.40524908009199 (37.76115577964, -122.405249080092)
3517 33317 Permitted Site 1 Ginkgo biloba :: Maidenhair Tree 44 1443-1443X Francisco St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/02/2015 12:00:00 AM 3   Permit Number 774619 6004424.04227 2120465.37019 37.8026433303993 -122.42888659453699 (37.8026433303993, -122.428886594537)
3674 32468 Permitted Site 1 Prunus cerasifera :: Cherry Plum 16 120 Corbett Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/15/2017 12:00:00 AM 3   Permit Number 36977 6000626.3294 2105651.6556 37.7617529834407 -122.44096521177099 (37.7617529834407, -122.440965211771)
3735 63212 Permitted Site 1 Maytenus boaria :: Mayten 22 450 38th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/18/1986 12:00:00 AM 10   Permit Number 23755 5984123.0 2112760.0 37.7803166927985 -122.498567828267 (37.7803166927985, -122.498567828267)
3759 253555 Permitted Site 1 Pinus canariensis :: Canary Island Pine 71 27 Ceres St 1 Front Yard : Yard 7 Tree 1 Private 1 FUF 1         6013919.66127 2093997.4229599999 37.730501082737604 -122.394172607985 (37.7305010827376, -122.394172607985)
3779 61682 Permitted Site 1 Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 27 Ceres St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/12/1985 12:00:00 AM 4   Permit Number 21679 6013919.66127 2093997.4229599999 37.730501082737604 -122.394172607985 (37.7305010827376, -122.394172607985)
3813 43299 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 615 Rhode Island St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/12/2000 12:00:00 AM 7   Permit Number 43068 6011854.0 2105476.0 37.761903752987706 -122.402120617661 (37.7619037529877, -122.402120617661)
3815 43300 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 615 Rhode Island St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/12/2000 12:00:00 AM 10   Permit Number 43068 6011854.0 2105476.0 37.761903752987706 -122.402120617661 (37.7619037529877, -122.402120617661)
3877 38690 Permitted Site 1 Pyrus calleryana :: Ornamental Pear 9 1529 Grove St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/02/2013 12:00:00 AM 8 6x5 Permit Number 40603 6000458.9819 2110614.4446 37.7753700290705 -122.441900209231 (37.7753700290705, -122.441900209231)
3894 52352 Permitted Site 1 Lophostemon confertus :: Brisbane Box 11 1078 Clay St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/14/2005 12:00:00 AM 11 3x3 Permit Number 48492 6009562.81073 2117112.1754400004 37.793725799570396 -122.41086683016701 (37.7937257995704, -122.410866830167)
3912 38150 Permitted Site 1 Tree(s) :: 17 200 Felton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/04/2017 12:00:00 AM 3   Permit Number 780230 6010281.37407 2093721.8548299999 37.7295415331127 -122.40673134359899 (37.7295415331127, -122.406731343599)
3931 179081 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 72 Edinburgh St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/04/2017 10:13:00 AM 3 Width 3ft   6004328.31139 2093147.65709 37.7276300348981 -122.42727080240499 (37.7276300348981, -122.427270802405)
3942 179080 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 72X Edinburgh St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/04/2017 10:09:00 AM 3 Width 3ft   6004338.45578 2093161.16244 37.7276676912897 -122.42723669472099 (37.7276676912897, -122.427236694721)
3953 44431 Permitted Site 1 Eriobotrya deflexa :: Bronze Loquat 49 859 Prague St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/04/2017 11:19:00 AM 3   Permit Number 43768 6002228.37284 2086951.06128 37.71049657842789 -122.434087529513 (37.7104965784279, -122.434087529513)
3957 83233 Permitted Site 1 Magnolia grandiflora 'Majestic Beauty' :: Majestic Beauty Magnolia 219 111 Madrid St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/04/2017 10:33:00 AM 3 3x3 Permit Number 54417 6004063.6553 2093143.5871700002 37.7276038889037 -122.428185431836 (37.7276038889037, -122.428185431836)
3986 65721 Permitted Site 1 Tristaniopsis laurina :: Swamp Myrtle 37 275 Pope St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/05/2017 04:32:00 PM 3   Permit Number 28655 6000475.14424 2087458.3820900002 37.711789909637794 -122.44018340596399 (37.7117899096378, -122.440183405964)
3991 44420 Permitted Site 1 Eriobotrya deflexa :: Bronze Loquat 49 859 Prague St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/05/2017 08:03:00 AM 3   Permit Number 43768 6002331.23577 2087017.31055 37.710684321803896 -122.433736745364 (37.7106843218039, -122.433736745364)
4005 30928 Permitted Site 1 Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 237 Holloway Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/05/2017 07:41:00 AM 3   Permit Number 34741 5996039.79065 2091194.75582 37.7217956003579 -122.455783036285 (37.7217956003579, -122.455783036285)
4088 30930 Permitted Site 1 Eriobotrya deflexa :: Bronze Loquat 49 342 Holloway Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/05/2017 02:15:00 PM 3 4.5x9 Permit Number 779282 5995716.95289 2091237.86508 37.7218954350219 -122.45690211214199 (37.7218954350219, -122.456902112142)
4164 57912 Permitted Site 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1653 Polk St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/07/1994 12:00:00 AM 6   Permit Number 16870 6006600.1246 2116572.8469 37.7920783685385 -122.42107969148998 (37.7920783685385, -122.42107969149)
4189 44396 Permitted Site 1 Platanus occidentalis :: American sycamore 222 559 Cordova St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/10/2017 01:07:00 PM 3   Permit Number 43752 6002175.43694 2086285.4696900002 37.708666004812606 -122.43422293503599 (37.7086660048126, -122.434222935036)
4279 78830 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 35 Laura St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/10/2017 04:01:00 PM 3     5997431.0713 2086896.39523 37.7100730444948 -122.450664016958 (37.7100730444948, -122.450664016958)
4318 160894 Undocumented 2 Agonis flexuosa :: Peppermint Willow 7 642 Edinburgh St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/11/2017 08:21:00 AM 3 Width 0ft   6002380.66916 2090044.6321900003 37.7189994849067 -122.43378212606702 (37.7189994849067, -122.433782126067)
4330 70503 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 193 Naples St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/25/1994 12:00:00 AM 7     6004252.47977 2092436.6780400001 37.725673555265395 -122.42748232385901 (37.7256735552654, -122.427482323859)
4333 160542 Undocumented 2 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 787 Edinburgh St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/11/2017 08:58:00 AM 3 Width 0ft   6001926.33849 2089244.2387299999 37.716775991190794 -122.435295346912 (37.7167759911908, -122.435295346912)
4342 53050 Permitted Site 1 Ginkgo biloba :: Maidenhair Tree 44 1024 Pacific Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/02/2011 12:00:00 AM 3 3x3 Permit Number 767676 6009180.15933 2118047.86674 37.79627351507779 -122.412257006676 (37.7962735150778, -122.412257006676)
4345 109580 Permitted Site 1 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 822 Brazil Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/11/2017 10:16:00 AM 3 3x3 Permit Number 775019 6004058.45374 2090883.76652 37.7213986270377 -122.428042443214 (37.7213986270377, -122.428042443214)
4350 178825 Undocumented 2 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 927 Brazil Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/11/2017 09:33:00 AM 3 Width 3ft   6004370.89542 2090731.88415 37.7209992632754 -122.42695160693998 (37.7209992632754, -122.42695160694)
4356 161318 Undocumented 2 Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 134 530 Edinburgh St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/11/2017 08:04:00 AM 3 Width 0ft   6002775.65928 2090671.8623400002 37.7207441256113 -122.432461575944 (37.7207441256113, -122.432461575944)
4363 160546 Undocumented 2 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 755 Edinburgh St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/11/2017 08:38:00 AM 3 Width 0ft   6002026.63127 2089400.9055 37.7172118584185 -122.434959882691 (37.7172118584185, -122.434959882691)
4376 160888 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 679 Edinburgh St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/11/2017 08:26:00 AM 3 Width 0ft   6002304.816330001 2089843.73714 37.7184435671833 -122.43402996661999 (37.7184435671833, -122.43402996662)
4391 43330 Permitted Site 1 Melaleuca linariifolia :: Flaxleaf Paperbark 155 345 Madrid St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/11/2017 10:55:00 AM 3 3x3 Permit Number 43087 6003248.07835 2091845.00305 37.723992087443904 -122.430912250911 (37.7239920874439, -122.430912250911)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 2584.769ms · Data source: data.sfgov.org