home / trees

Street_Tree_List

Data source: data.sfgov.org

22,424 rows where qCareAssistant = 2

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, Fire Prevention Districts, Police Districts, Supervisor Districts, Zip Codes

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods
223 100223 Permitted Site 2 Tree(s) :: 13 3841 23rd St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 07/25/2012 12:00:00 AM   3x3 Permit Number 769110 6004154.3 2102433.2 37.75311617172 -122.428533954088 (37.75311617172, -122.428533954088) 2 4 5 28862 22
224 100224 Permitted Site 2 Tree(s) :: 13 101X Vicksburg St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 07/25/2012 12:00:00 AM   3x3 Permit Number 769110 6004128.9 2102465.7 37.7532039716563 -122.428624108827 (37.7532039716563, -122.428624108827) 2 4 5 28862 22
225 100225 Permitted Site 2 Tree(s) :: 13 101X Vicksburg St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 07/25/2012 12:00:00 AM   3x3 Permit Number 769110 6004128.9 2102465.7 37.7532039716563 -122.428624108827 (37.7532039716563, -122.428624108827) 2 4 5 28862 22
599 100665 Permitted Site 2 Tree(s) :: 13 63 Walter St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1 FUF 2 09/04/2012 12:00:00 AM   3x3 Permit Number 769258 6003201.8 2107946.7 37.768200969529204 -122.432221606092 (37.7682009695292, -122.432221606092) 15 5 5 28862 3
817 100949 DPW Maintained 1 Olea europaea 'Fruitless' :: Fruitless Olive 14 1561 45th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 09/20/2012 12:00:00 AM 1   Permit Number 769342 5982149.6 2104456.5 37.7574017552939 -122.504779173294 (37.7574017552939, -122.504779173294) 1 8 3 56 35
860 101000 Permitted Site 2 Crataegus phaenopyrum :: Washington Hawthorn 105 500X Ogden Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2       Permit Number 44123 6008398.5 2096033.1 37.7357821841588 -122.413404038925 (37.7357821841588, -122.413404038925) 10 7 7 28859 2
861 101001 Undocumented 3 Tree(s) :: 13 500X Ogden Ave 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 11/30/2012 12:00:00 AM     Permit Number 769389 6008398.5 2096033.1 37.7357821841588 -122.413404038925 (37.7357821841588, -122.413404038925) 10 7 7 28859 2
1237 101407 Permitted Site 2 Magnolia spp :: Magnolia 37 395X Shotwell St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 10/22/2012 12:00:00 AM   3x3 Permit Number 768634 6007839.0 2105646.7 37.7621475376843 -122.41601905110501 (37.7621475376843, -122.416019051105) 8 4 7 28859 19
1238 101408 Permitted Site 2 Magnolia spp :: Magnolia 37 395X Shotwell St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 10/22/2012 12:00:00 AM   3x3 Permit Number 768634 6007839.0 2105646.7 37.7621475376843 -122.41601905110501 (37.7621475376843, -122.416019051105) 8 4 7 28859 19
1239 101409 Permitted Site 2 Magnolia spp :: Magnolia 37 395X Shotwell St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 10/22/2012 12:00:00 AM   3x3 Permit Number 768634 6007839.0 2105646.7 37.7621475376843 -122.41601905110501 (37.7621475376843, -122.416019051105) 8 4 7 28859 19
1283 101450 Permitted Site 2 Pyrus spp :: Pear Tree 61 331X 08th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2         5993377.6 2113262.5 37.7822348132756 -122.46658867692301 (37.7822348132756, -122.466588676923) 11 6 2 54 11
1284 101451 Permitted Site 2 Pyrus spp :: Pear Tree 61 331X 08th Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2     3x3   5993377.6 2113262.5 37.7822348132756 -122.46658867692301 (37.7822348132756, -122.466588676923) 11 6 2 54 11
1435 101623 Permitted Site 2 Prunus cerasifera :: Cherry Plum 43 80 Homestead St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 11/05/2012 12:00:00 AM   4x4 Permit Number 769409 6000945.5 2101263.6 37.749722620490395 -122.43954675389901 (37.7497226204904, -122.439546753899) 2 4 5 28862 22
1571 101775 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 1700 Yosemite Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2   10 3x3 Permit Number 19103 6014052.75296 2093112.8912 37.728079734566606 -122.393650601914 (37.7280797345666, -122.393650601914) 10 3 8 58 1
1601 101834 Permitted Site 2 Tree(s) :: 13 178 Precita Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 11/26/2012 12:00:00 AM   3x3 Permit Number 769564 6007595.3 2100188.6 37.7471471355217 -122.41647528228998 (37.7471471355217, -122.41647528229) 2 7 7 28859 2
1782 102062 Permitted Site 2 Callistemon citrinus :: Lemon Bottlebrush 45 26 Bennington St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/18/2012 12:00:00 AM 4 3x3 Permit Number 769724 6007185.0 2097679.0 37.740233252719705 -122.41771621811701 (37.7402332527197, -122.417716218117) 2 7 7 28859 2
1783 102063 Permitted Site 2 Pyrus kawakamii :: Evergreen Pear 65 284 Coleridge St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/18/2012 12:00:00 AM 3 3x3 Permit Number 769726 6006232.8 2098354.9 37.742035492788204 -122.42105652774099 (37.7420354927882, -122.421056527741) 2 7 7 28859 2
1784 102064 Permitted Site 2 Lagunaria patersonii :: Primrose Tree 80 102 Anderson St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 07/10/2009 12:00:00 AM   3x3 Permit Number 52559 6007929.8 2098099.2 37.7414289135067 -122.415170728099 (37.7414289135067, -122.415170728099) 2 7 7 28859 2
1785 102065 Permitted Site 2 Tree(s) :: 13 383 Coleridge St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 07/10/2009 12:00:00 AM 3 3x3 Permit Number 52558 6006113.2 2097907.9 37.7408013885407 -122.421438329564 (37.7408013885407, -122.421438329564) 2 7 7 28859 2
1786 102066 Permitted Site 2 Cordyline australis :: Dracena Palm 82 229 Bonview St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/18/2012 12:00:00 AM 3 3x3 Permit Number 769725 6006956.6 2097728.3 37.7403557640328 -122.418509430253 (37.7403557640328, -122.418509430253) 2 7 7 28859 2
1787 102067 Permitted Site 2 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 24 Coso Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/18/2012 12:00:00 AM 3 3x3 Permit Number 769727 6007035.7 2099866.2 37.7462304116746 -122.418387482558 (37.7462304116746, -122.418387482558) 2 7 7 28859 2
1788 102068 Permitted Site 2 Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 152 50X Coleridge St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/18/2012 12:00:00 AM   3x3 Permit Number 52614 6006867.4 2099433.7 37.745033388538204 -122.41893877466299 (37.7450333885382, -122.418938774663) 2 7 7 28859 2
1789 102069 Permitted Site 2 Cercis occidentalis :: Western Redbud 62 50X Coleridge St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/18/2012 12:00:00 AM   3x3 Permit Number 52614 6006867.4 2099433.7 37.745033388538204 -122.41893877466299 (37.7450333885382, -122.418938774663) 2 7 7 28859 2
1791 102070 Permitted Site 2 Pittosporum undulatum :: Victorian Box 38 50X Coleridge St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/18/2012 12:00:00 AM   3x3 Permit Number 52614 6006867.4 2099433.7 37.745033388538204 -122.41893877466299 (37.7450333885382, -122.418938774663) 2 7 7 28859 2
1792 102071 Permitted Site 2 Cercis occidentalis :: Western Redbud 62 50X Coleridge St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/18/2012 12:00:00 AM   3x3 Permit Number 52614 6006867.4 2099433.7 37.745033388538204 -122.41893877466299 (37.7450333885382, -122.418938774663) 2 7 7 28859 2
1793 102072 Permitted Site 2 Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 152 50X Coleridge St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/18/2012 12:00:00 AM   3x3 Permit Number 52614 6006867.4 2099433.7 37.745033388538204 -122.41893877466299 (37.7450333885382, -122.418938774663) 2 7 7 28859 2
1798 102078 Permitted Site 2 Rhamnus alaternus :: Italian Buckthorn 53 35 Highland Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/18/2012 12:00:00 AM 3 3x3 Permit Number 769728 6005184.6 2096720.6 37.737488929995706 -122.42456464703699 (37.7374889299957, -122.424564647037) 2 7 5 28859 2
1799 102079 Property Tree 5 Arbutus 'Marina' :: Hybrid Strawberry Tree 20 76 Manchester St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/18/2012 12:00:00 AM   3x3 Permit Number 769729 6008162.3 2099676.4 37.7457726186307 -122.414478397936 (37.7457726186307, -122.414478397936) 2 7 7 28859 2
1801 102080 Permitted Site 2 Acer buergeranum :: Trident Maple 155 27 Mirabel Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/18/2012 12:00:00 AM   3x3 Permit Number 769730 6007460.8 2099922.6 37.7464091944673 -122.416921530448 (37.7464091944673, -122.416921530448) 2 7 7 28859 2
1802 102081 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 110 525 14th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 07/09/2009 12:00:00 AM 2 3x3 Permit Number 52509 5991566.610309999 2111852.8346 37.778259586012204 -122.472751014651 (37.7782595860122, -122.472751014651) 11 6 2 54 26
1803 102082 Permitted Site 2 Agonis flexuosa :: Peppermint Willow 102 577 04th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 07/09/2009 12:00:00 AM   3x3 Permit Number 52510 5994678.1 2111611.2 37.7777757479831 -122.46196977885499 (37.7777757479831, -122.461969778855) 11 6 2 54 11
1804 102083 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 45 714 15th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 07/09/2009 12:00:00 AM 3 3x3 Permit Number 52511 5991334.07902 2110523.03796 37.7745948642856 -122.47345839749201 (37.7745948642856, -122.473458397492) 11 6 2 54 26
1805 102084 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 201 15th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 07/09/2009 12:00:00 AM 1 3x3 Permit Number 52515 5991161.35766 2114023.19945 37.7841953413 -122.474311334384 (37.7841953413, -122.474311334384) 11 6 2 54 26
1806 102085 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 43 475 20th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 07/09/2009 12:00:00 AM 4   Permit Number 52516 5989662.20818 2112129.83383 37.7789097231702 -122.47935923836599 (37.7789097231702, -122.479359238366) 11 6 2 55 26
1807 102086 Permitted Site 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 20 43 Prospect Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/19/2012 12:00:00 AM   3x3 Permit Number 769732 6007144.2 2099182.9 37.744360330521005 -122.417963871752 (37.744360330521, -122.417963871752) 2 7 7 28859 2
1808 102087 Permitted Site 2 Magnolia grandiflora :: Southern Magnolia 39 212 Prospect Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/19/2012 12:00:00 AM   3x3 Permit Number 769733 6006591.9 2098371.2 37.74210048539621 -122.41981602805001 (37.7421004853962, -122.41981602805) 2 7 7 28859 2
1809 102089 Permitted Site 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 135 27 Santa Ana Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/18/2012 12:00:00 AM   3x3 Permit Number 769734 5992609.4 2096703.2 37.7367229555432 -122.468041385671 (37.7367229555432, -122.468041385671) 1 8 4 59 40
1811 102090 Permitted Site 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 135 27 Santa Ana Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/18/2012 12:00:00 AM   3x3 Permit Number 769734 5992609.4 2096703.2 37.7367229555432 -122.468041385671 (37.7367229555432, -122.468041385671) 1 8 4 59 40
1812 102091 Permitted Site 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 135 27 Santa Ana Ave 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/18/2012 12:00:00 AM   3x3 Permit Number 769734 5992609.4 2096703.2 37.7367229555432 -122.468041385671 (37.7367229555432, -122.468041385671) 1 8 4 59 40
1813 102092 Permitted Site 2 Lagunaria patersonii :: Primrose Tree 80 19 Stoneman St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/18/2012 12:00:00 AM   3x3 Permit Number 769735 6008292.3 2099391.0 37.744996275991504 -122.414008688761 (37.7449962759915, -122.414008688761) 2 7 7 28859 2
1814 102093 Permitted Site 2 Lagunaria patersonii :: Primrose Tree 80 19 Stoneman St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/18/2012 12:00:00 AM   3x3 Permit Number 769735 6008292.3 2099391.0 37.744996275991504 -122.414008688761 (37.7449962759915, -122.414008688761) 2 7 7 28859 2
1816 102099 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 28 236 Linden St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2   4 6   6006248.049 2110932.5353900003 37.776571605618 -122.421897043808 (37.776571605618, -122.421897043808) 7 9 11 28852 10
1818 102100 Permitted Site 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 151 234 Linden St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2     6   6006253.0 2110945.0 37.776606109637896 -122.42188080245899 (37.7766061096379, -122.421880802459) 7 9 11 28852 10
1819 102101 Property Tree 5 Cordyline australis :: Dracena Palm 82 331 Vernon St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/19/2012 12:00:00 AM 12 3x3 Permit Number 769722 5992434.3 2090067.3 37.718492301183204 -122.468164197766 (37.7184923011832, -122.468164197766) 9 8 6 64 24
1832 102118 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 20 4010 24th St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/27/2012 12:00:00 AM 5 4x4 Permit Number 769743 6003103.5 2101879.6 37.7515365953655 -122.432128294524 (37.7515365953655, -122.432128294524) 2 4 5 28862 22
1833 102119 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 20 4040 24th St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/27/2012 12:00:00 AM 5 3x3 Permit Number 769743 6002911.0 2101847.0 37.751436167563895 -122.4327916542 (37.7514361675639, -122.4327916542) 2 4 5 28862 22
1834 102120 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 151 3906 24th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/27/2012 12:00:00 AM 3 3x3 Permit Number 769743 6003747.7 2101944.5 37.751751298202 -122.429905200436 (37.751751298202, -122.429905200436) 2 4 5 28862 22
1835 102121 Permitted Site 2 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 69 1090X Sanchez St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/27/2012 12:00:00 AM 5 3x3 Permit Number 769743 6003794.9 2101928.3 37.7517094896741 -122.429740821201 (37.7517094896741, -122.429740821201) 2 4 5 28862 22
1836 102122 Permitted Site 2 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 69 1090X Sanchez St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/27/2012 12:00:00 AM 5 3x3 Permit Number 769743 6003794.9 2101928.3 37.7517094896741 -122.429740821201 (37.7517094896741, -122.429740821201) 2 4 5 28862 22
1837 102123 Permitted Site 2 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 69 1090X Sanchez St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/27/2012 12:00:00 AM 5 3x3 Permit Number 769743 6003794.9 2101928.3 37.7517094896741 -122.429740821201 (37.7517094896741, -122.429740821201) 2 4 5 28862 22
1869 102158 Permitted Site 2 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 69 4300X 24th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/27/2012 12:00:00 AM 3 3x3 Permit Number 769743 6001255.1 2101750.3 37.751076597898 -122.438511014093 (37.751076597898, -122.438511014093) 2 4 5 28862 22
1872 102160 Permitted Site 2 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 69 4300X 24th St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/27/2012 12:00:00 AM 3 3x3 Permit Number 769743 6001255.1 2101750.3 37.751076597898 -122.438511014093 (37.751076597898, -122.438511014093) 2 4 5 28862 22
1876 102165 Permitted Site 2 Ligustrum lucidum :: Glossy Privet 12 3988 20th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/31/2012 12:00:00 AM 3 3x3 Permit Number 769758 6003795.7 2104247.9 37.7580786087619 -122.429903496461 (37.7580786087619, -122.429903496461) 2 4 5 28862 3
1877 102166 Permitted Site 2 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 627 Castro St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/31/2012 12:00:00 AM 4 3x3 Permit Number 769759 6002435.1 2104542.4 37.7588100889329 -122.434630086253 (37.7588100889329, -122.434630086253) 2 4 5 28862 3
1878 102167 Permitted Site 2 Jacaranda mimosifolia :: Jacaranda 29 677 Castro St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/31/2012 12:00:00 AM 4 3x3 Permit Number 769761 6002448.6 2104297.1 37.7581373205651 -122.4345658575 (37.7581373205651, -122.4345658575) 2 4 5 28862 3
1879 102168 Permitted Site 2 Pyrus kawakamii :: Evergreen Pear 65 235 Collingwood St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/31/2012 12:00:00 AM 3 3x3 Permit Number 769763 6002117.1 2104495.4 37.758662980429996 -122.435726513037 (37.75866298043, -122.435726513037) 2 4 5 28862 3
1880 102169 Permitted Site 2 Pyrus kawakamii :: Evergreen Pear 65 235 Collingwood St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/31/2012 12:00:00 AM 3 3x3 Permit Number 769763 6002117.1 2104495.4 37.758662980429996 -122.435726513037 (37.75866298043, -122.435726513037) 2 4 5 28862 3
1882 102170 Permitted Site 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 151 270 Collingwood St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/31/2012 12:00:00 AM 3 3x3   6001983.1 2104294.8 37.758104568963105 -122.436175590041 (37.7581045689631, -122.436175590041) 2 4 5 28862 3
1883 102171 Permitted Site 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 10 9X Hattie St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/31/2012 12:00:00 AM 4 3x3 Permit Number 769765 6000621.0 2105580.9 37.7615584024391 -122.440978567809 (37.7615584024391, -122.440978567809) 15 5 5 28862 3
1884 102172 Permitted Site 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 10 9X Hattie St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/31/2012 12:00:00 AM 4 3x3 Permit Number 769765 6000621.0 2105580.9 37.7615584024391 -122.440978567809 (37.7615584024391, -122.440978567809) 15 5 5 28862 3
1885 102173 Permitted Site 2 Lophostemon confertus :: Brisbane Box 9 10X Hattie St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/31/2012 12:00:00 AM   3x3 Permit Number 769766 6000586.1 2105578.9 37.7615509231117 -122.44109912879699 (37.7615509231117, -122.441099128797) 15 5 5 28862 3
1886 102174 Permitted Site 2 Lophostemon confertus :: Brisbane Box 9 10X Hattie St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/31/2012 12:00:00 AM   3x3 Permit Number 769766 6000586.1 2105578.9 37.7615509231117 -122.44109912879699 (37.7615509231117, -122.441099128797) 15 5 5 28862 3
1887 102175 Permitted Site 2 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 151 484 Corbett Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/31/2012 12:00:00 AM 3 3x3 Permit Number 769767 5999426.4 2104189.2 37.7576690270565 -122.445010134311 (37.7576690270565, -122.445010134311) 2 5 5 28862 3
1888 102176 Permitted Site 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 20 488 Corbett Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/31/2012 12:00:00 AM 4 3x3 Permit Number 769768 5999452.4 2104200.8 37.7577023616885 -122.444921049841 (37.7577023616885, -122.444921049841) 2 5 5 28862 3
1889 102177 Permitted Site 2 Jacaranda mimosifolia :: Jacaranda 29 267 Diamond St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/31/2012 12:00:00 AM 5 6x9 Permit Number 769769 6001804.7 2104316.3 37.758153465363996 -122.436794111878 (37.758153465364, -122.436794111878) 2 4 5 28862 3
1892 102180 Permitted Site 2 Lagunaria patersonii :: Primrose Tree 80 308 Diamond St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/31/2012 12:00:00 AM 3 3x3 Permit Number 769770 6001747.5 2103909.1 37.7570321415971 -122.436962782195 (37.7570321415971, -122.436962782195) 2 4 5 28862 3
1907 102196 Permitted Site 2 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 195 Eureka St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/02/2013 12:00:00 AM 3 3x3 Permit Number 769771 6001469.4 2104733.4 37.7592796588141 -122.43798359789801 (37.7592796588141, -122.437983597898) 2 4 5 28862 3
1908 102197 Permitted Site 2 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 195 Eureka St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/02/2013 12:00:00 AM 3 3x3 Permit Number 769771 6001469.4 2104733.4 37.7592796588141 -122.43798359789801 (37.7592796588141, -122.437983597898) 2 4 5 28862 3
1909 102198 Permitted Site 2 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 195 Eureka St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/02/2013 12:00:00 AM 3 3x3 Permit Number 769771 6001469.4 2104733.4 37.7592796588141 -122.43798359789801 (37.7592796588141, -122.437983597898) 2 4 5 28862 3
1910 102199 Permitted Site 2 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 56 195 Eureka St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/02/2013 12:00:00 AM 3 3x3 Permit Number 769771 6001469.4 2104733.4 37.7592796588141 -122.43798359789801 (37.7592796588141, -122.437983597898) 2 4 5 28862 3
1913 102200 Permitted Site 2 Lagunaria patersonii :: Primrose Tree 80 579 Liberty St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/02/2013 12:00:00 AM 4 3x3 Permit Number 769774 6002583.2 2103808.0 37.7568020093443 -122.43406539067301 (37.7568020093443, -122.434065390673) 2 4 5 28862 3
1914 102201 Permitted Site 2 Ulmus parvifolia 'Sempervirens' :: Weeping Chinese Elm 160 442 Noe St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/02/2013 12:00:00 AM 3 3x3 Permit Number 769775 6002908.2 2105655.8 37.7618940636715 -122.433073438645 (37.7618940636715, -122.433073438645) 15 4 5 28862 3
1915 102202 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 408 Roosevelt Way 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/02/2013 12:00:00 AM 3 3x3 Permit Number 769776 5999992.4 2106715.5 37.764637910001 -122.443234124093 (37.764637910001, -122.443234124093) 15 5 5 29492 3
1916 102203 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 408 Roosevelt Way 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/02/2013 12:00:00 AM 3 3x3 Permit Number 769776 5999992.4 2106715.5 37.764637910001 -122.443234124093 (37.764637910001, -122.443234124093) 15 5 5 29492 3
1917 102204 Permitted Site 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 42 Upper Ter 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/03/2013 12:00:00 AM 3 3x3 Permit Number 769777 5999985.2 2107061.7 37.7655880783734 -122.443283894556 (37.7655880783734, -122.443283894556) 15 5 5 29492 9
1920 102207 Permitted Site 2 Prunus serrulata :: Ornamental Cherry 132 89X Elgin Park 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2   5 3x3 Permit Number 30082 6005852.4 2108559.9 37.7700345996314 -122.42309702584299 (37.7700345996314, -122.423097025843) 8 2 5 28853 19
1921 102208 Permitted Site 2 Prunus serrulata :: Ornamental Cherry 132 89X Elgin Park 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2   5 3x3 Permit Number 30082 6005852.4 2108559.9 37.7700345996314 -122.42309702584299 (37.7700345996314, -122.423097025843) 8 2 5 28853 19
1922 102209 Permitted Site 2 Prunus serrulata :: Ornamental Cherry 132 89X Elgin Park 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2   5 3x3 Permit Number 30082 6005852.4 2108559.9 37.7700345996314 -122.42309702584299 (37.7700345996314, -122.423097025843) 8 2 5 28853 19
1972 102258 Permitted Site 2 Maytenus boaria :: Mayten 51 4334 19th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/08/2013 12:00:00 AM 3 4x4 Permit Number 54710 6001495.3 2104706.4 37.7592069962244 -122.437892089432 (37.7592069962244, -122.437892089432) 2 4 5 28862 3
2025 102317 Permitted Site 2 Tree(s) :: 13 51 Arnold Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2     3x3   6006607.7 2095553.8 37.7343654214358 -122.419561552483 (37.7343654214358, -122.419561552483) 2 7 7 28859 2
2063 102353 DPW Maintained 1 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 50 662 12th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 07/10/2009 12:00:00 AM 2 3x3 Permit Number 52560 5992263.7285400005 2110921.14049 37.775741736970204 -122.470271582701 (37.7757417369702, -122.470271582701) 11 6 2 54 11
2066 102357 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 3551 Scott St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/16/2013 12:00:00 AM 3 3x3 Permit Number 769877 6000702.4264400005 2120580.06982 37.802746916103295 -122.441773461287 (37.8027469161033, -122.441773461287) 13 9 1 57 17
2067 102358 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 3551 Scott St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/16/2013 12:00:00 AM 4 3x3 Permit Number 769877 6000705.04573 2120562.7593099996 37.8026995353058 -122.441763154152 (37.8026995353058, -122.441763154152) 13 9 1 57 17
2070 102360 Permitted Site 2 Pittosporum undulatum :: Victorian Box 38 399 Steiner St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 11/08/2008 12:00:00 AM 3 3x3 Permit 769887 6003188.9 2109566.9 37.7726489102167 -122.43238195811001 (37.7726489102167, -122.43238195811) 15 5 11 29492 9
2291 102592 Permitted Site 2 Rhamnus alaternus :: Italian Buckthorn 53 124 Baden St 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2 FUF 2 04/17/2010 12:00:00 AM 3 6x6   6000765.0 2094428.0 37.7309433983829 -122.439680933747 (37.7309433983829, -122.439680933747) 9 7 4 63 40
2294 102595 Permitted Site 2 Rhamnus alaternus :: Italian Buckthorn 53 133 Baden St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 02/06/2013 12:00:00 AM 3 3x3 Permit Number 769795 6000714.8 2094523.9 37.7312038601891 -122.439861356334 (37.7312038601891, -122.439861356334) 9 7 4 63 40
2295 102596 Permitted Site 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 20 108 Chaves Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 04/17/2010 12:00:00 AM 3 3x4   5996733.6 2098580.3 37.7421143248718 -122.453917831989 (37.7421143248718, -122.453917831989) 9 7 4 59 40
2329 102628 Permitted Site 2 Prunus cerasifera :: Cherry Plum 43 100 Freelon St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 02/07/2013 12:00:00 AM   3x3 Permit Number 769972 6013417.4 2111578.2 37.778746166691 -122.397141295625 (37.778746166691, -122.397141295625) 6 2 9 28856 34
2340 102646 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 650X Jones St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2   15 3x3 Permit Number 28309 6008830.0317 2114874.50645 37.7875405898706 -122.413244009 (37.7875405898706, -122.413244009) 5 1 10 28852 36
2448 102761 Permitted Site 2 Ulmus parvifolia :: Chinese Elm 26 100X Russ St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 02/26/2013 12:00:00 AM 3 3x3 Permit Number 54619 6010215.5 2111581.3 37.7785759102049 -122.40821818771099 (37.7785759102049, -122.408218187711) 14 2 9 28853 34
2449 102762 Permitted Site 2 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 100X Russ St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 02/26/2013 12:00:00 AM 3 3x3 Permit Number 54619 6010215.5 2111581.3 37.7785759102049 -122.40821818771099 (37.7785759102049, -122.408218187711) 14 2 9 28853 34
2450 102763 Permitted Site 2 Pyrus kawakamii :: Evergreen Pear 65 50X Hill Point Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 02/26/2013 12:00:00 AM   3x3 Permit Number 769605 5996378.1 2106680.6 37.7643353262738 -122.45573242834699 (37.7643353262738, -122.455732428347) 15 5 11 29492 12
2451 102764 Permitted Site 2 Olea europaea :: Olive Tree 42 1X Mirabel Ave 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2   6 3x3   6007238.4 2099828.6 37.746138579062396 -122.41768390456801 (37.7461385790624, -122.417683904568) 2 7 7 28859 2
2689 103020 Permitted Site 2 Corymbia ficifolia :: Red Flowering Gum 5 40X Coleridge St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2   12 3x3 See 61 Fair Ave property permits 6006901.0 2099544.2 37.745338688611206 -122.41883042692801 (37.7453386886112, -122.418830426928) 2 7 7 28859 2
2690 103021 Permitted Site 2 Magnolia grandiflora :: Southern Magnolia 39 40X Coleridge St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2   12 3x3 See 61 Fair Ave for old permit records 6006901.0 2099544.2 37.745338688611206 -122.41883042692801 (37.7453386886112, -122.418830426928) 2 7 7 28859 2
2691 103022 Permitted Site 2 Agonis flexuosa :: Peppermint Willow 102 40X Coleridge St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 03/15/2013 12:00:00 AM 3 3x3 Permit Number 770067 6006901.0 2099544.2 37.745338688611206 -122.41883042692801 (37.7453386886112, -122.418830426928) 2 7 7 28859 2
2692 103023 Permitted Site 2 Magnolia grandiflora :: Southern Magnolia 39 40X Coleridge St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2     3x3   6006901.0 2099544.2 37.745338688611206 -122.41883042692801 (37.7453386886112, -122.418830426928) 2 7 7 28859 2
2744 103085 Permitted Site 2 Olea europaea 'Fruitless' :: Fruitless Olive 14 99 Colton St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2     2x3 See 55 Brady St; trees planted at same time with permits/FUF 6006671.4 2109566.7 37.7728452155106 -122.42033558182301 (37.7728452155106, -122.420335581823) 8 2 9 28853 19
2745 103086 Permitted Site 2 Olea europaea 'Fruitless' :: Fruitless Olive 14 99 Colton St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2     2x3 See 55 Brady St; trees planted at same time with permits/FUF 6006671.4 2109566.7 37.7728452155106 -122.42033558182301 (37.7728452155106, -122.420335581823) 8 2 9 28853 19
2923 103273 Permitted Site 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 10 76-78 Diamond St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 03/28/2013 12:00:00 AM   3x3 Permit Number 768961 6001664.7 2105412.5 37.7611554066092 -122.437356784873 (37.7611554066092, -122.437356784873) 15 4 5 28862 3

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" REAL,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" REAL,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT,
  "Fire Prevention Districts" INTEGER,
  "Police Districts" INTEGER,
  "Supervisor Districts" INTEGER,
  "Zip Codes" INTEGER,
  "Neighborhoods" INTEGER
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id))
Powered by Datasette · Query took 280.341ms · Data source: data.sfgov.org