trees
8,298 rows where qLegalStatus_id = 4 sorted by Location descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );