trees

39,840 rows where qLegalStatus_id = 7 sorted by qAddress 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)
53527 96014 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 999 California St 9 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/02/2011 12:00:00 AM   3x3 Permit Number 767660 6009569 2116409 37.7917953978204 -122.410795730189 (37.7917953978204, -122.410795730189) 5 1 10 28857 21
53962 96013 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 999 California St 8 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/02/2011 12:00:00 AM   3x3 Permit Number 767660 6009569 2116409 37.7917953978204 -122.410795730189 (37.7917953978204, -122.410795730189) 5 1 10 28857 21
161466 96015 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 999 California St 10 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/02/2011 12:00:00 AM   3x3 Permit Number 767660 6009569 2116409 37.7917953978204 -122.410795730189 (37.7917953978204, -122.410795730189) 5 1 10 28857 21
98272 88425 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 999 Bush St   Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM   3x3 Permit Number 51391 6001075 2114514 37.7861122979784 -122.440048944558 (37.7861122979784, -122.440048944558) 15 6 1 29490 27
54856 109630 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 998 SUTTER ST 1 Sidewalk: Curb side : Cutout Tree Private 2   03/24/2015 12:00:00 AM 3 1x1 Permit Number 775136 6007840.9 2115211.2 37.7884094868041 -122.416690077626 (37.7884094868041, -122.416690077626) 13 1 10 28858 21
89783 62806 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 998 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/08/1986 12:00:00 AM     Permit Number 23165 6001478.75963757 2111822.72775324 37.7787457270266 -122.438459155796 (37.7787457270266, -122.438459155796) 15 5 11 29490 41
50182 107502 Permitted Site 7 Podocarpus gracilor :: Fern Pine 51 998 CHESTNUT ST 3 Sidewalk: Property side : Cutout Tree Private 2     3 3x3 Permit Number 773456 6007102 2120561.3 37.8030579393401 -122.419626302363 (37.8030579393401, -122.419626302363) 5 1 1 28858 32
122900 107501 Permitted Site 7 Podocarpus gracilor :: Fern Pine 51 998 CHESTNUT ST 2 Sidewalk: Property side : Cutout Tree Private 2     3 3x3 Permit Number 773456 6007102 2120561.3 37.8030579393401 -122.419626302363 (37.8030579393401, -122.419626302363) 5 1 1 28858 32
633 9792 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 997X Gough St 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5     36 3x3   6005630.9126204 2113075.2727517 37.7824202152127 -122.424184324881 (37.7824202152127, -122.424184324881) 7 9 11 28852 41
32890 9796 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 997X Gough St 7 Sidewalk: Curb side : Cutout Tree Rec/Park 5   03/08/2006 12:00:00 AM   3X3   6005630.9126204 2113075.2727517 37.7824202152127 -122.424184324881 (37.7824202152127, -122.424184324881) 7 9 11 28852 41
94516 9794 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 997X Gough St 5 Sidewalk: Curb side : Cutout Tree Rec/Park 5     26 3x3   6005630.9126204 2113075.2727517 37.7824202152127 -122.424184324881 (37.7824202152127, -122.424184324881) 7 9 11 28852 41
111531 9800 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 997X Gough St 11 Sidewalk: Curb side : Cutout Tree Rec/Park 5   03/30/2006 12:00:00 AM 3 3X3   6005630.9126204 2113075.2727517 37.7824202152127 -122.424184324881 (37.7824202152127, -122.424184324881) 7 9 11 28852 41
132578 9791 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 997X Gough St 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5     24 3x3   6005630.9126204 2113075.2727517 37.7824202152127 -122.424184324881 (37.7824202152127, -122.424184324881) 7 9 11 28852 41
139725 9793 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 997X Gough St 4 Sidewalk: Curb side : Cutout Tree Rec/Park 5     40 3x3   6005630.9126204 2113075.2727517 37.7824202152127 -122.424184324881 (37.7824202152127, -122.424184324881) 7 9 11 28852 41
147003 9799 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 997X Gough St 10 Sidewalk: Curb side : Cutout Tree Rec/Park 5   03/30/2006 12:00:00 AM 30 3x3   6005630.9126204 2113075.2727517 37.7824202152127 -122.424184324881 (37.7824202152127, -122.424184324881) 7 9 11 28852 41
152187 9795 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 997X Gough St 6 Sidewalk: Curb side : Cutout Tree Rec/Park 5     26 3x3   6005630.9126204 2113075.2727517 37.7824202152127 -122.424184324881 (37.7824202152127, -122.424184324881) 7 9 11 28852 41
173276 9797 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 997X Gough St 8 Sidewalk: Curb side : Cutout Tree Rec/Park 5   03/08/2006 12:00:00 AM 3 3X3   6005630.9126204 2113075.2727517 37.7824202152127 -122.424184324881 (37.7824202152127, -122.424184324881) 7 9 11 28852 41
175880 9790 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 997X Gough St 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5     40 3x3   6005630.9126204 2113075.2727517 37.7824202152127 -122.424184324881 (37.7824202152127, -122.424184324881) 7 9 11 28852 41
188191 140047 Permitted Site 7 Ficus retusa nitida :: Banyan Fig 54 997 STEINER ST 1 Sidewalk: Curb side : Cutout Tree Private 2   03/30/1981 12:00:00 AM 17 Width 0ft Permit Number 19087 6002926.2641 2111608.0681 37.778238555435 -122.433436333455 (37.778238555435, -122.433436333455) 15 9 11 29492 41
108014 96969 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 996X Pine St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 17188 6009608 2116096 37.7909381623214 -122.410638676365 (37.7909381623214, -122.410638676365) 5 1 10 28857 21
48589 49775 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 996@ ORDWAY Somerset St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/09/2003 12:00:00 AM     Permit Number 46561 6010806.40404101 2090031.53281179 37.7194380356715 -122.404656566431 (37.7194380356715, -122.404656566431) 10 7 8 309 28
78637 49774 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 996@ ORDWAY Somerset St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/09/2003 12:00:00 AM     Permit Number 46561 6010806.40404101 2090031.53281179 37.7194380356715 -122.404656566431 (37.7194380356715, -122.404656566431) 10 7 8 309 28
30736 42949 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 996 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2000 12:00:00 AM     Permit Number 42843 6007571.84518521 2103864.78808287 37.7572397945138 -122.416816791906 (37.7572397945138, -122.416816791906) 2 4 7 28859 19
43052 42950 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 996 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2000 12:00:00 AM     Permit Number 42843 6007571.84518521 2103864.78808287 37.7572397945138 -122.416816791906 (37.7572397945138, -122.416816791906) 2 4 7 28859 19
30589 46576 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 996 Sanchez St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/05/2002 12:00:00 AM     Permit Number 44710 6003759.39576103 2102474.00246404 37.7532058498338 -122.429902520856 (37.7532058498338, -122.429902520856) 2 4 5 28862 22
75439 46574 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 996 Sanchez St 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/05/2002 12:00:00 AM     Permit Number 44710 6003759.39576103 2102474.00246404 37.7532058498338 -122.429902520856 (37.7532058498338, -122.429902520856) 2 4 5 28862 22
94724 46578 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 996 Sanchez St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/05/2002 12:00:00 AM     Permit Number 44710 6003759.39576103 2102474.00246404 37.7532058498338 -122.429902520856 (37.7532058498338, -122.429902520856) 2 4 5 28862 22
134425 46575 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 996 Sanchez St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/05/2002 12:00:00 AM     Permit Number 44710 6003759.39576103 2102474.00246404 37.7532058498338 -122.429902520856 (37.7532058498338, -122.429902520856) 2 4 5 28862 22
167107 46577 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 996 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/05/2002 12:00:00 AM 4   Permit Number 44710 6003759.39576103 2102474.00246404 37.7532058498338 -122.429902520856 (37.7532058498338, -122.429902520856) 2 4 5 28862 22
97951 110542 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 996 SOUTH VAN NESS AVE 3 Sidewalk: Curb side : Yard Tree Private 2           6007549 2103894 37.7573187187357 -122.41689786927 (37.7573187187357, -122.41689786927) 2 4 7 28859 19
127850 25366 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 996 Geneva Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3X3   6000654.63163 2088858.47925 37.715644480695 -122.439663360361 (37.715644480695, -122.439663360361) 9 7 6 28861 5
34308 105924 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 995 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2014 12:00:00 AM   3x3 Permit Number 769111 6007873.5 2115092.6 37.7880856736468 -122.416568881841 (37.7880856736468, -122.416568881841) 13 1 10 28858 21
110827 56768 Permitted Site 7 Tree(s) :: 17 994 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/21/1974 12:00:00 AM     Permit Number 13987 6003117.251443 2102450.87538679 37.7531059622083 -122.432121532394 (37.7531059622083, -122.432121532394) 2 4 5 28862 22
128417 35560 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 994 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM     Permit Number 38933 6005676.53456798 2103185.0108578 37.7552664968553 -122.423323199789 (37.7552664968553, -122.423323199789) 2 4 5 28859 19
78520 57292 Permitted Site 7 Tree(s) :: 17 994 Geneva Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/27/1976 12:00:00 AM     Permit Number 16113 6000688.67615408 2088842.44530642 37.7156023927573 -122.439544538542 (37.7156023927573, -122.439544538542) 9 7 6 28861 5
103160 91113 Permitted Site 7 Tree(s) :: 17 994 Corbett Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 51999 5999620.1 2101651.4 37.7507119023651 -122.444157886796 (37.7507119023651, -122.444157886796) 2 5 5 63 38
78461 67116 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 994 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/29/1992 12:00:00 AM     Permit Number 30535 5998844.26522705 2106564.92896199 37.7641589439786 -122.447194363227 (37.7641589439786, -122.447194363227) 15 5 11 29492 9
67227 47749 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 993 Tennessee St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/31/2002 12:00:00 AM     Permit Number 45529 6015544.08915786 2104434.58222781 37.7592495174377 -122.389285216664 (37.7592495174377, -122.389285216664) 10 3 8 28856 29
88732 47750 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 993 Tennessee St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/31/2002 12:00:00 AM     Permit Number 45529 6015544.08915786 2104434.58222781 37.7592495174377 -122.389285216664 (37.7592495174377, -122.389285216664) 10 3 8 28856 29
106301 98984 Permitted Site 7 Ficus nitida :: Laurel Fig 53 993 Steiner St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Permit Number 19087 6002920 2111648 37.7783478430736 -122.433460857601 (37.7783478430736, -122.433460857601) 15 9 11 29492 41
178705 59665 Permitted Site 7 Ficus nitida :: Laurel Fig 53 993 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/30/1981 12:00:00 AM 12 2x2 Permit Number 19087 6002914.43276984 2111641.44659541 37.7783295332017 -122.433479648258 (37.7783295332017, -122.433479648258) 15 9 11 29492 41
48914 61170 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 993 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/29/1983 12:00:00 AM     Permit Number 21029 6007622.52723732 2103890.01374739 37.757311908984 -122.416643300115 (37.757311908984, -122.416643300115) 2 4 7 28859 19
187722 140048 Permitted Site 7 Ficus retusa nitida :: Banyan Fig 54 993 STEINER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft Permit Number 19087 6002927.2794 2111591.8239 37.7781940105178 -122.433431660039 (37.7781940105178, -122.433431660039) 15 9 11 29492 41
106722 65252 Permitted Site 7 Liquidambar orientalis :: Oriental Sweet Gum 269 992 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/26/1989 12:00:00 AM     Permit Number 28051 6009395.74802139 2103403.69283522 37.7560761510907 -122.41047644187 (37.7560761510907, -122.41047644187) 2 4 7 28859 19
69792 38453 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 991 Palou Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/20/1998 12:00:00 AM     Permit Number 40471 6018116.72112672 2092806.63595359 37.7274638040704 -122.379579913535 (37.7274638040704, -122.379579913535) 10 3 8 58 1
142162 38456 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 991 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/20/1998 12:00:00 AM     Permit Number 40471 6018116.72112672 2092806.63595359 37.7274638040704 -122.379579913535 (37.7274638040704, -122.379579913535) 10 3 8 58 1
142867 38454 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 991 Palou Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/20/1998 12:00:00 AM     Permit Number 40471 6018116.72112672 2092806.63595359 37.7274638040704 -122.379579913535 (37.7274638040704, -122.379579913535) 10 3 8 58 1
167615 38455 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 991 Palou Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/20/1998 12:00:00 AM     Permit Number 40471 6018116.72112672 2092806.63595359 37.7274638040704 -122.379579913535 (37.7274638040704, -122.379579913535) 10 3 8 58 1
118194 98271 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 990X York St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/20/2012 12:00:00 AM   within landscaping plot Permit Number 768491 6009943.7 2103445.2 37.7562208239384 -122.408584359698 (37.7562208239384, -122.408584359698) 2 4 7 28859 19
119476 98272 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 990X York St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/20/2012 12:00:00 AM   within landscaping plot Permit Number 768491 6009943.7 2103445.2 37.7562208239384 -122.408584359698 (37.7562208239384, -122.408584359698) 2 4 7 28859 19
128168 98270 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 990X York St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/20/2012 12:00:00 AM   witin landscaping plot Permit Number 768491 6009943.7 2103445.2 37.7562208239384 -122.408584359698 (37.7562208239384, -122.408584359698) 2 4 7 28859 19
164216 98273 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 990X York St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/20/2012 12:00:00 AM   within landscaping plot Permit Number 768491 6009943.7 2103445.2 37.7562208239384 -122.408584359698 (37.7562208239384, -122.408584359698) 2 4 7 28859 19
110189 20132 Permitted Site 7 Eucalyptus sideroxylon :: Red Ironbark 127 990X Hayes St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6003116.52257 2110682.58178 37.7757081923636 -122.432712031629 (37.7757081923636, -122.432712031629) 15 9 11 29492 10
75555 34486 Permitted Site 7 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 990 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM     Permit Number 38212 6008234.44982697 2119317.66608687 37.7997069566126 -122.415619317188 (37.7997069566126, -122.415619317188) 5 1 10 308 32
77342 34487 Permitted Site 7 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 990 Union St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM     Permit Number 38212 6008234.44982697 2119317.66608687 37.7997069566126 -122.415619317188 (37.7997069566126, -122.415619317188) 5 1 10 308 32
175174 34488 Permitted Site 7 Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 171 990 Union St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM     Permit Number 38212 6008234.44982697 2119317.66608687 37.7997069566126 -122.415619317188 (37.7997069566126, -122.415619317188) 5 1 10 308 32
109384 69409 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 990 Prague St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/09/1994 12:00:00 AM     Permit Number 33514 6001528.72905075 2086815.30428152 37.7100840871049 -122.436495934551 (37.7100840871049, -122.436495934551) 9 7 6 28861 5
33153 88751 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 990 Polk St 8 Sidewalk: Curb side : Cutout Tree Private 2   08/19/2008 12:00:00 AM   3x3 Permit Number 51679 6006960.9 2114284 37.7858140902738 -122.419668930825 (37.7858140902738, -122.419668930825) 13 9 9 28858 36
36730 88755 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 990 Polk St 12 Sidewalk: Curb side : Cutout Tree Private 2   08/19/2008 12:00:00 AM   3x3 Permit Number 51679 6006960.9 2114284 37.7858140902738 -122.419668930825 (37.7858140902738, -122.419668930825) 13 9 9 28858 36
41061 88754 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 990 Polk St 11 Sidewalk: Curb side : Cutout Tree Private 2   08/19/2008 12:00:00 AM   3x3 Permit Number 51679 6006960.9 2114284 37.7858140902738 -122.419668930825 (37.7858140902738, -122.419668930825) 13 9 9 28858 36
41333 88753 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 990 Polk St 10 Sidewalk: Curb side : Cutout Tree Private 2   08/19/2008 12:00:00 AM   3x3 Permit Number 51679 6006960.9 2114284 37.7858140902738 -122.419668930825 (37.7858140902738, -122.419668930825) 13 9 9 28858 36
61126 88757 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 990 Polk St 14 Sidewalk: Curb side : Cutout Tree Private 2   08/19/2008 12:00:00 AM   3x3 Permit Number 51679 6006960.9 2114284 37.7858140902738 -122.419668930825 (37.7858140902738, -122.419668930825) 13 9 9 28858 36
67107 88756 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 990 Polk St 13 Sidewalk: Curb side : Cutout Tree Private 2   08/19/2008 12:00:00 AM   3x3 Permit Number 51679 6006960.9 2114284 37.7858140902738 -122.419668930825 (37.7858140902738, -122.419668930825) 13 9 9 28858 36
87848 88749 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 990 Polk St 6 Sidewalk: Curb side : Cutout Tree Private 2   08/19/2008 12:00:00 AM   3x3 Permit Number 51679 6006960.9 2114284 37.7858140902738 -122.419668930825 (37.7858140902738, -122.419668930825) 13 9 9 28858 36
98572 88750 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 990 Polk St 7 Sidewalk: Curb side : Cutout Tree Private 2   08/19/2008 12:00:00 AM   3x3 Permit Number 51679 6006960.9 2114284 37.7858140902738 -122.419668930825 (37.7858140902738, -122.419668930825) 13 9 9 28858 36
159193 88752 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 990 Polk St 9 Sidewalk: Curb side : Cutout Tree Private 2   08/19/2008 12:00:00 AM   3x3 Permit Number 51679 6006960.9 2114284 37.7858140902738 -122.419668930825 (37.7858140902738, -122.419668930825) 13 9 9 28858 36
168965 88758 Permitted Site 7 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 990 Polk St 15 Sidewalk: Curb side : Cutout Tree Private 2   08/19/2008 12:00:00 AM   3x3 Permit Number 51679 6006960.9 2114284 37.7858140902738 -122.419668930825 (37.7858140902738, -122.419668930825) 13 9 9 28858 36
186254 53554 Permitted Site 7 Tree(s) :: 17 990 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/20/2016 12:00:00 AM     Permit Number 6466 6009376.89757939 2118082.87777148 37.7963806843446 -122.411578723863 (37.7963806843446, -122.411578723863) 3 1 10 308 4
7482 30852 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 99 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/16/1995 12:00:00 AM     Permit Number 34698 6007267.59353144 2109330.19931681 37.772229418327 -122.418256503442 (37.772229418327, -122.418256503442) 8 2 9 28853 19
7907 91707 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 99 South Van Ness Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   03/01/2007 12:00:00 AM 3 3x3   6007261.828778 2109331.862933 37.7722336617279 -122.418276562246 (37.7722336617279, -122.418276562246) 8 2 9 28853 19
24904 91704 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 99 South Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   03/01/2007 12:00:00 AM 3 3x3   6007261.828778 2109331.862933 37.7722336617279 -122.418276562246 (37.7722336617279, -122.418276562246) 8 2 9 28853 19
46855 91705 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 99 South Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   03/01/2007 12:00:00 AM 3 3x3   6007261.828778 2109331.862933 37.7722336617279 -122.418276562246 (37.7722336617279, -122.418276562246) 8 2 9 28853 19
103924 30856 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 99 South Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   02/16/1995 12:00:00 AM     Permit Number 34698 6007267.59353144 2109330.19931681 37.772229418327 -122.418256503442 (37.772229418327, -122.418256503442) 8 2 9 28853 19
106489 91706 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 99 South Van Ness Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   03/01/2007 12:00:00 AM 3 3x3   6007261.828778 2109331.862933 37.7722336617279 -122.418276562246 (37.7722336617279, -122.418276562246) 8 2 9 28853 19
117900 30855 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 99 South Van Ness Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   02/16/1995 12:00:00 AM     Permit Number 34698 6007267.59353144 2109330.19931681 37.772229418327 -122.418256503442 (37.772229418327, -122.418256503442) 8 2 9 28853 19
144571 91703 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 99 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   03/01/2007 12:00:00 AM 3 3x3   6007261.828778 2109331.862933 37.7722336617279 -122.418276562246 (37.7722336617279, -122.418276562246) 8 2 9 28853 19
175870 30854 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 99 South Van Ness Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   02/16/1995 12:00:00 AM     Permit Number 34698 6007267.59353144 2109330.19931681 37.772229418327 -122.418256503442 (37.772229418327, -122.418256503442) 8 2 9 28853 19
176053 30858 Permitted Site 7 Washingtonia robusta :: Mexican Fan Palm 72 99 South Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   02/16/1995 12:00:00 AM     Permit Number 34698 6007267.59353144 2109330.19931681 37.772229418327 -122.418256503442 (37.772229418327, -122.418256503442) 8 2 9 28853 19
176816 91702 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 99 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/01/2007 12:00:00 AM 3 3x3   6007261.828778 2109331.862933 37.7722336617279 -122.418276562246 (37.7722336617279, -122.418276562246) 8 2 9 28853 19
182952 30857 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 99 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/16/1995 12:00:00 AM     Permit Number 34698 6007267.59353144 2109330.19931681 37.772229418327 -122.418256503442 (37.772229418327, -122.418256503442) 8 2 9 28853 19
186981 30853 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 99 South Van Ness Ave 7 Sidewalk: Curb side : Cutout Tree Private 2   02/16/1995 12:00:00 AM     Permit Number 34698 6007267.59353144 2109330.19931681 37.772229418327 -122.418256503442 (37.772229418327, -122.418256503442) 8 2 9 28853 19
53565 92547 Permitted Site 7 Fraxinus spp :: Ash Spp 121 99 Santa Marina St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3 Permit Number 52890 6006207.5 2097640.2 37.740071660795 -122.421093271685 (37.740071660795, -122.421093271685) 2 7 7 28859 2
32029 19171 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 99 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6003518.9611891 2107740.2951253 37.7676522094925 -122.431109843922 (37.7676522094925, -122.431109843922) 7 9 5 28862 3
12315 56545 Permitted Site 7 Tree(s) :: 17 99 Prospect Ave 1 Sidewalk: Curb side : Cutout Tree Private 2           6006997.81069025 2098938.41719823 37.7436807955871 -122.418452724226 (37.7436807955871, -122.418452724226) 2 7 7 28859 2
106747 115732 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 99 ORD ST 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   22 3x3   6000874 2105811 37.7622046070719 -122.440120047168 (37.7622046070719, -122.440120047168) 15 5 5 28862 3
187282 108632 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 99 ORD ST 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/30/2014 12:00:00 AM 3 3x3 Permit Number 774601 6000898 2105859 37.7623377695764 -122.440040482469 (37.7623377695764, -122.440040482469) 15 5 5 28862 3
156444 68112 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 99 Manchester St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/03/2011 12:00:00 AM   3x3 Permit Number 767697 6008270.46985677 2099447.7930484 37.7451509909812 -122.414088190825 (37.7451509909812, -122.414088190825) 2 7 7 28859 2
13239 35575 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 99 Hill St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM   7X6 Permit Number 38943 6005733.52150857 2103415.89933022 37.7559036789868 -122.423142532595 (37.7559036789868, -122.423142532595) 2 4 5 28859 19
181671 62893 Permitted Site 7 Tree(s) :: 17 99 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/25/1986 12:00:00 AM     Permit Number 23267 6012353.11575448 2119483.32983433 37.8003924841325 -122.401378783456 (37.8003924841325, -122.401378783456) 3 1 10 28860 6
145428 52388 Permitted Site 7 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 99 Esmeralda Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/14/2005 12:00:00 AM     Permit Number 48513 6006895.43343812 2098993.06991313 37.7438250958144 -122.418810596013 (37.7438250958144, -122.418810596013) 2 7 7 28859 2
45866 183403 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 99 Escolta Way 4 Sidewalk: Curb side : Cutout Tree Private 2     25 Width 0ft Permit Number 18001 5986843.3946 2097135.0609 37.7375740582752 -122.488008432108 (37.7375740582752, -122.488008432108) 1 8 3 29491 35
21560 34089 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 99 Eastwood Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37971 5995595.84819231 2093296.84467021 37.7275419455651 -122.457469628551 (37.7275419455651, -122.457469628551) 9 7 4 28861 40
141649 34087 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 99 Eastwood Dr 2 Sidewalk: Curb side : Cutout Tree Private 2   07/05/1997 12:00:00 AM     Permit Number 37971 5995595.84819231 2093296.84467021 37.7275419455651 -122.457469628551 (37.7275419455651, -122.457469628551) 9 7 4 28861 40
174873 34088 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 99 Eastwood Dr 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/22/2002 12:00:00 AM     Permit Number 39308 5995595.84819231 2093296.84467021 37.7275419455651 -122.457469628551 (37.7275419455651, -122.457469628551) 9 7 4 28861 40
39332 31810 Permitted Site 7 Tree(s) :: 17 99 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/2015 12:00:00 AM     Permit Number 776677 6001914.86865911 2108255.52596642 37.7689758778799 -122.436695073767 (37.7689758778799, -122.436695073767) 15 5 5 29492 3
49341 31812 Permitted Site 7 Tree(s) :: 17 99 Divisadero St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/2015 12:00:00 AM     Permit Number 776677 6001914.86865911 2108255.52596642 37.7689758778799 -122.436695073767 (37.7689758778799, -122.436695073767) 15 5 5 29492 3
102874 31811 Permitted Site 7 Tree(s) :: 17 99 Divisadero St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/2015 12:00:00 AM     Permit Number 776677 6001914.86865911 2108255.52596642 37.7689758778799 -122.436695073767 (37.7689758778799, -122.436695073767) 15 5 5 29492 3
30584 37350 Permitted Site 7 Maytenus boaria :: Mayten 58 99 Curtis St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/15/1998 12:00:00 AM     Permit Number 39857 6000722.91615892 2087924.83898491 37.7130847996496 -122.439360454344 (37.7130847996496, -122.439360454344) 9 7 6 28861 5
153308 37349 Permitted Site 7 Maytenus boaria :: Mayten 58 99 Curtis St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/15/1998 12:00:00 AM     Permit Number 39857 6000722.91615892 2087924.83898491 37.7130847996496 -122.439360454344 (37.7130847996496, -122.439360454344) 9 7 6 28861 5
157712 37351 Permitted Site 7 Maytenus boaria :: Mayten 58 99 Curtis St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/15/1998 12:00:00 AM     Permit Number 39857 6000722.91615892 2087924.83898491 37.7130847996496 -122.439360454344 (37.7130847996496, -122.439360454344) 9 7 6 28861 5

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)
);