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

View and edit SQL

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)
61438 107905 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 2650 Mason St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008717 2122501 37.8084747060674 -122.414174852603 (37.8084747060674, -122.414174852603) 3 1 10 308 23
88031 107908 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 2650 Mason St 4 Sidewalk: Curb side : Cutout Tree Private 2           6008717 2122501 37.8084747060674 -122.414174852603 (37.8084747060674, -122.414174852603) 3 1 10 308 23
147498 107906 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 2650 Mason St 2 Sidewalk: Curb side : Cutout Tree Private 2           6008717 2122501 37.8084747060674 -122.414174852603 (37.8084747060674, -122.414174852603) 3 1 10 308 23
175877 107907 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 2650 Mason St 3 Sidewalk: Curb side : Cutout Tree Private 2           6008717 2122501 37.8084747060674 -122.414174852603 (37.8084747060674, -122.414174852603) 3 1 10 308 23
47604 104262 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 199X Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2           6008482.28692 2122448.56477 37.8083175458446 -122.41498343065 (37.8083175458446, -122.41498343065) 3 1 10 308 23
66899 104263 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 199X Jefferson St 2 Sidewalk: Curb side : Cutout Tree Private 2           6008482.28692 2122448.56477 37.8083175458446 -122.41498343065 (37.8083175458446, -122.41498343065) 3 1 10 308 23
94320 104266 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 199X Jefferson St 5 Sidewalk: Curb side : Cutout Tree Private 2           6008482.28692 2122448.56477 37.8083175458446 -122.41498343065 (37.8083175458446, -122.41498343065) 3 1 10 308 23
108485 104265 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 199X Jefferson St 4 Sidewalk: Curb side : Cutout Tree Private 2           6008482.28692 2122448.56477 37.8083175458446 -122.41498343065 (37.8083175458446, -122.41498343065) 3 1 10 308 23
178487 104264 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 199X Jefferson St 3 Sidewalk: Curb side : Cutout Tree Private 2           6008482.28692 2122448.56477 37.8083175458446 -122.41498343065 (37.8083175458446, -122.41498343065) 3 1 10 308 23
63531 99175 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 300x BEACH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008712 2122248 37.8077797512209 -122.414174245084 (37.8077797512209, -122.414174245084) 3 1 10 308 23
125218 99176 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 300x BEACH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008712 2122248 37.8077797512209 -122.414174245084 (37.8077797512209, -122.414174245084) 3 1 10 308 23
26574 100103 Undocumented 4 Pittosporum crassifolium :: Karo Tree 95 461 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2           6007004.8 2122229.7 37.8076334645768 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
48222 100107 Undocumented 4 Ficus nitida :: Laurel Fig 53 461 Jefferson St 5 Sidewalk: Curb side : Cutout Tree Private 2           6007004.8 2122229.7 37.8076334645768 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
114077 100108 Undocumented 4 Ficus nitida :: Laurel Fig 53 461 Jefferson St 6 Sidewalk: Curb side : Cutout Tree Private 2           6007004.8 2122229.7 37.8076334645768 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
122731 100106 Undocumented 4 Ficus nitida :: Laurel Fig 53 461 Jefferson St 4 Sidewalk: Curb side : Cutout Tree Private 2           6007004.8 2122229.7 37.8076334645768 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
145774 100105 Undocumented 4 Pittosporum crassifolium :: Karo Tree 95 461 Jefferson St 3 Sidewalk: Curb side : Cutout Tree Private 2           6007004.8 2122229.7 37.8076334645768 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
181687 100104 Undocumented 4 Pittosporum crassifolium :: Karo Tree 95 461 Jefferson St 2 Sidewalk: Curb side : Cutout Tree Private 2           6007004.8 2122229.7 37.8076334645768 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
94746 100102 Undocumented 4 Ficus carica :: Edible Fig 341 495@ Beach Jefferson St 2 Sidewalk: Curb side : Cutout Tree Private 2           6006848.2 2122207.6 37.8075639592102 -122.42062152066 (37.8075639592102, -122.42062152066) 5 1 1 28858 32
3804 117402 Undocumented 4 Ficus nitida :: Laurel Fig 53 75x BEACH ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 3 1 10 308 23
12765 117400 Undocumented 4 Ficus nitida :: Laurel Fig 53 75x BEACH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 3 1 10 308 23
56447 117399 Undocumented 4 Ficus nitida :: Laurel Fig 53 75x BEACH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 3 1 10 308 23
150414 117403 Undocumented 4 Ficus nitida :: Laurel Fig 53 75x BEACH ST 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 3 1 10 308 23
158673 117398 Undocumented 4 Ficus nitida :: Laurel Fig 53 75x BEACH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 3 1 10 308 23
185775 117401 Undocumented 4 Ficus nitida :: Laurel Fig 53 75x BEACH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009846 2122112 37.8074699595292 -122.410240137563 (37.8074699595292, -122.410240137563) 3 1 10 308 23
30487 99178 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 330 Beach St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008617 2122137 37.807469636787 -122.41449515712 (37.807469636787, -122.41449515712) 3 1 10 308 23
59862 120620 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 2 North Point St 14 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010405 2122056 37.8073475155142 -122.408301628949 (37.8073475155142, -122.408301628949) 3 1 10 308 23
1444 256097 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 2 North Point St 15 Sidewalk: Curb side : Cutout Tree Private 2   01/17/2020 12:12:00 PM 3 3x3   6010298.36751 2122029.07931 37.8072676263732 -122.408668755752 (37.8072676263732, -122.408668755752) 3 1 10 308 23
102285 256096 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 2 North Point St 14 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010298.36751 2122029.07931 37.8072676263732 -122.408668755752 (37.8072676263732, -122.408668755752) 3 1 10 308 23
51202 100114 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 333 Jefferson St 6 Sidewalk: Curb side : Cutout Tree Private 2           6007662 2121967 37.8069491634687 -122.417788103441 (37.8069491634687, -122.417788103441) 5 1 10 308 23
61684 100109 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 333 Jefferson St 1 Sidewalk: Curb side : Cutout Tree Private 2           6007662 2121967 37.8069491634687 -122.417788103441 (37.8069491634687, -122.417788103441) 5 1 10 308 23
67021 100113 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 333 Jefferson St 5 Sidewalk: Curb side : Cutout Tree Private 2           6007662 2121967 37.8069491634687 -122.417788103441 (37.8069491634687, -122.417788103441) 5 1 10 308 23
67964 100110 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 333 Jefferson St 2 Sidewalk: Curb side : Cutout Tree Private 2           6007662 2121967 37.8069491634687 -122.417788103441 (37.8069491634687, -122.417788103441) 5 1 10 308 23
68742 100119 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 333 Jefferson St 11 Sidewalk: Curb side : Cutout Tree Private 2           6007662 2121967 37.8069491634687 -122.417788103441 (37.8069491634687, -122.417788103441) 5 1 10 308 23
81579 100111 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 333 Jefferson St 3 Sidewalk: Curb side : Cutout Tree Private 2           6007662 2121967 37.8069491634687 -122.417788103441 (37.8069491634687, -122.417788103441) 5 1 10 308 23
93715 100117 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 333 Jefferson St 9 Sidewalk: Curb side : Cutout Tree Private 2           6007662 2121967 37.8069491634687 -122.417788103441 (37.8069491634687, -122.417788103441) 5 1 10 308 23
97575 100112 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 333 Jefferson St 4 Sidewalk: Curb side : Cutout Tree Private 2           6007662 2121967 37.8069491634687 -122.417788103441 (37.8069491634687, -122.417788103441) 5 1 10 308 23
135501 100115 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 333 Jefferson St 7 Sidewalk: Curb side : Cutout Tree Private 2           6007662 2121967 37.8069491634687 -122.417788103441 (37.8069491634687, -122.417788103441) 5 1 10 308 23
149669 100116 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 333 Jefferson St 8 Sidewalk: Curb side : Cutout Tree Private 2           6007662 2121967 37.8069491634687 -122.417788103441 (37.8069491634687, -122.417788103441) 5 1 10 308 23
162104 100120 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 333 Jefferson St 12 Sidewalk: Curb side : Cutout Tree Private 2           6007662 2121967 37.8069491634687 -122.417788103441 (37.8069491634687, -122.417788103441) 5 1 10 308 23
181201 100118 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 333 Jefferson St 10 Sidewalk: Curb side : Cutout Tree Private 2           6007662 2121967 37.8069491634687 -122.417788103441 (37.8069491634687, -122.417788103441) 5 1 10 308 23
53543 115711 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 550 NORTH POINT ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008089 2121871 37.806709591959 -122.416303574578 (37.806709591959, -122.416303574578) 5 1 10 308 23
94303 115712 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 550 NORTH POINT ST 4 Sidewalk: Curb side : Cutout Tree Private 2   03/04/2016 12:00:00 AM 3 3x3   6008089 2121871 37.806709591959 -122.416303574578 (37.806709591959, -122.416303574578) 5 1 10 308 23
94711 115709 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 550 NORTH POINT ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008089 2121871 37.806709591959 -122.416303574578 (37.806709591959, -122.416303574578) 5 1 10 308 23
133248 115710 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 550 NORTH POINT ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008089 2121871 37.806709591959 -122.416303574578 (37.806709591959, -122.416303574578) 5 1 10 308 23
153385 115713 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 550 NORTH POINT ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008089 2121871 37.806709591959 -122.416303574578 (37.806709591959, -122.416303574578) 5 1 10 308 23
37319 105121 Undocumented 4 :: 45 721 BEACH ST   Sidewalk: Curb side : Cutout Tree Private 2     9     6006739.7 2121813.5 37.8064757462399 -122.420969011396 (37.8064757462399, -122.420969011396) 5 1 1 28858 32
231 116978 Undocumented 4 Grevillea robusta :: Silk Oak Tree 76 111 BAY ST 4 Front Yard : Yard Tree Private 2           6010550 2121704 37.8063891294227 -122.407774985143 (37.8063891294227, -122.407774985143) 3 1 10 308 23
81381 111709 Undocumented 4 Grevillea robusta :: Silk Oak Tree 76 111 BAY ST 2 Front Yard : Yard Tree Private 2           6010550 2121704 37.8063891294227 -122.407774985143 (37.8063891294227, -122.407774985143) 3 1 10 308 23
1376 263620 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 900 Beach St 3 Side Yard : Yard Tree DPW 1 Rec/Park     3x3   6005896 2121751 37.8062565433008 -122.423884345484 (37.8062565433008, -122.423884345484) 3 1 1 28858 32
10225 263619 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 900 Beach St 2 Side Yard : Yard Tree DPW 1 Rec/Park     3x3   6005896 2121751 37.8062565433008 -122.423884345484 (37.8062565433008, -122.423884345484) 3 1 1 28858 32
10567 263621 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 900 Beach St 4 Side Yard : Yard Tree DPW 1 Rec/Park     3x3   6005896 2121751 37.8062565433008 -122.423884345484 (37.8062565433008, -122.423884345484) 3 1 1 28858 32
11694 263618 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 900 Beach St 1 Side Yard : Yard Tree DPW 1 Rec/Park     3x3   6005896 2121751 37.8062565433008 -122.423884345484 (37.8062565433008, -122.423884345484) 3 1 1 28858 32
56112 112489 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2690x Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/03/2015 12:00:00 AM   3x3   6007377.71104 2121658.59908 37.8060863706979 -122.418750060411 (37.8060863706979, -122.418750060411) 5 1 1 308 32
20469 114842 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2670 LEAVENWORTH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007398 2121652 37.8060693936166 -122.418679378695 (37.8060693936166, -122.418679378695) 5 1 1 308 23
86140 114841 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2670 LEAVENWORTH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007398 2121652 37.8060693936166 -122.418679378695 (37.8060693936166, -122.418679378695) 5 1 1 308 23
42643 258040 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 1288 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007535 2121589 37.8059041239352 -122.418200797252 (37.8059041239352, -122.418200797252) 5 1 10 308 23
130948 258043 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 1288 Columbus Ave 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007535 2121589 37.8059041239352 -122.418200797252 (37.8059041239352, -122.418200797252) 5 1 10 308 23
135347 258042 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 1288 Columbus Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   05/13/2019 12:00:00 AM 3 3x3   6007535 2121589 37.8059041239352 -122.418200797252 (37.8059041239352, -122.418200797252) 5 1 10 308 23
157647 258041 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 1288 Columbus Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007535 2121589 37.8059041239352 -122.418200797252 (37.8059041239352, -122.418200797252) 5 1 10 308 23
166089 258044 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 1288 Columbus Ave 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007535 2121589 37.8059041239352 -122.418200797252 (37.8059041239352, -122.418200797252) 5 1 10 308 23
11053 116828 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 15 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
13714 116827 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 14 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
22667 116824 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 11 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
35001 116817 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 4 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
53972 116826 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 13 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
57984 116822 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 9 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
81034 116831 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 18 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
81049 116820 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 7 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
90664 116825 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 12 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
103044 116823 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 10 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
126220 116830 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 17 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
133362 116818 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 5 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
149148 116809 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 1 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
180453 116829 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 16 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
191989 116816 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 3 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
192724 116815 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 111 BAY ST 2 Front Yard : Yard Tree PUC 8           6010193 2121519 37.8058611737053 -122.408997391272 (37.8058611737053, -122.408997391272) 3 1 10 308 23
122556 98759 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 143 - 147 RETIRO WAY 1 Sidewalk: Curb side : Cutout Tree Private 2           6001834.3 2121687.2 37.805851229479 -122.437935958007 (37.805851229479, -122.437935958007) 13 9 1 57 17
58111 258045 Undocumented 4 Ficus nitida :: Laurel Fig 53 1250 Columbus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/13/2019 12:00:00 AM 3 3x3   6007719 2121534 37.805763462997 -122.417560134413 (37.805763462997, -122.417560134413) 5 1 10 308 23
97771 258048 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 1250 Columbus Ave 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007719 2121534 37.805763462997 -122.417560134413 (37.805763462997, -122.417560134413) 5 1 10 308 23
150358 258047 Undocumented 4 Ficus nitida :: Laurel Fig 53 1250 Columbus Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   05/13/2019 12:00:00 AM 3 3x3   6007719 2121534 37.805763462997 -122.417560134413 (37.805763462997, -122.417560134413) 5 1 10 308 23
168220 258046 Undocumented 4 Ficus nitida :: Laurel Fig 53 1250 Columbus Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   05/13/2019 12:00:00 AM 3 3x3   6007719 2121534 37.805763462997 -122.417560134413 (37.805763462997, -122.417560134413) 5 1 10 308 23
30032 121066 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 3199x Polk St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005931 2121567 37.8057533025265 -122.423750130533 (37.8057533025265, -122.423750130533) 5 1 1 28858 32
111525 121067 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 3199x Polk St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005931 2121567 37.8057533025265 -122.423750130533 (37.8057533025265, -122.423750130533) 5 1 1 28858 32
146631 121064 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 3199x Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005931 2121567 37.8057533025265 -122.423750130533 (37.8057533025265, -122.423750130533) 5 1 1 28858 32
153918 121065 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 3199x Polk St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005931 2121567 37.8057533025265 -122.423750130533 (37.8057533025265, -122.423750130533) 5 1 1 28858 32
119534 103297 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 50 Francisco St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011114.9 2121460 37.805750773231 -122.405802839637 (37.805750773231, -122.405802839637) 3 1 10 308 23
153770 103287 Undocumented 4 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 50 Francisco St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011114.9 2121460 37.805750773231 -122.405802839637 (37.805750773231, -122.405802839637) 3 1 10 308 23
139146 96365 Undocumented 4 Tree(s) :: 17 2017 Grant Ave 1 Median : Cutout Tree Private 2   06/07/2011 12:00:00 AM 12 3x3 Permit Number 767883 6010284.4 2121422.5 37.8056013282128 -122.408674274121 (37.8056013282128, -122.408674274121) 3 1 10 308 23
73472 103296 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 80 Francisco St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010792 2121375 37.80549932132 -122.406914293894 (37.80549932132, -122.406914293894) 3 1 10 308 23
183626 142645 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 2380 Mason St 4 Sidewalk: Curb side : Cutout Tree Private 2           6008890.0639 2121379.5977 37.805405337199 -122.41349655223 (37.805405337199, -122.41349655223) 3 1 10 308 23
117475 97938 Undocumented 4 Ficus nitida :: Laurel Fig 53 2133 Stockton St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009831.3 2121360.2 37.8054048804892 -122.410237896013 (37.8054048804892, -122.410237896013) 3 1 10 308 23
28490 111716 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 2390x MASON ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008938 2121373 37.8053899130211 -122.413330195558 (37.8053899130211, -122.413330195558) 3 1 10 308 23
43856 111715 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 2390x MASON ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008938 2121373 37.8053899130211 -122.413330195558 (37.8053899130211, -122.413330195558) 3 1 10 308 23
115497 111718 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 2390x MASON ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008938 2121373 37.8053899130211 -122.413330195558 (37.8053899130211, -122.413330195558) 3 1 10 308 23
152945 111717 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 2390x MASON ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008938 2121373 37.8053899130211 -122.413330195558 (37.8053899130211, -122.413330195558) 3 1 10 308 23
170611 104729 Undocumented 4 Ficus nitida :: Laurel Fig 53 250-252 FRANCISCO ST   Sidewalk: Curb side : Cutout Tree Private 2     22 5x5   6010061.3 2121325.4 37.805322217951 -122.409439489572 (37.805322217951, -122.409439489572) 3 1 10 308 23
92681 115442 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 99x Vandewater St 3 Sidewalk: Curb side : Cutout Tree Private 2       2.5X3   6009122.65313 2121320.70167 37.8052566803806 -122.412687477249 (37.8052566803806, -122.412687477249) 3 1 10 308 23
137554 115443 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 99x Vandewater St 4 Sidewalk: Curb side : Cutout Tree Private 2       2.5X3   6009122.65313 2121320.70167 37.8052566803806 -122.412687477249 (37.8052566803806, -122.412687477249) 3 1 10 308 23
150284 115440 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 99x Vandewater St 1 Sidewalk: Curb side : Cutout Tree Private 2       2.5X3   6009122.65313 2121320.70167 37.8052566803806 -122.412687477249 (37.8052566803806, -122.412687477249) 3 1 10 308 23
179845 116832 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 2 Midway St 7 Front Yard : Yard Tree PUC 8           6010125.275107 2121295.55695439 37.8052438606833 -122.409215987298 (37.8052438606833, -122.409215987298) 3 1 10 308 23

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