trees
261 rows where qSpecies_id = 177 sorted by Police Districts 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1199 | 116255 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
3302 | 256186 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1598 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | 6003155.82812 | 2120664.19895 | 37.8031173987704 | -122.433289466249 | (37.8031173987704, -122.433289466249) | 13 | 9 | 1 | 57 | 17 | |||
4989 | 256185 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1598 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | 6003155.82812 | 2120664.19895 | 37.8031173987704 | -122.433289466249 | (37.8031173987704, -122.433289466249) | 13 | 9 | 1 | 57 | 17 | |||
6215 | 256187 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1598 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | 6003155.82812 | 2120664.19895 | 37.8031173987704 | -122.433289466249 | (37.8031173987704, -122.433289466249) | 13 | 9 | 1 | 57 | 17 | |||
11136 | 131782 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2646 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | Permit Number 779549 | 6000337.27442 | 2118211.39807 | 37.7962223607332 | -122.442866875924 | (37.7962223607332, -122.442866875924) | 13 | 9 | 1 | 57 | 17 | ||
12471 | 76775 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
12604 | 116259 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
16011 | 131781 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2758 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2020 12:00:00 AM | 3 | Width 3ft | 5999580.2108 | 2118368.89391 | 37.7966116124855 | -122.445497792185 | (37.7966116124855, -122.445497792185) | 13 | 9 | 1 | 57 | 17 | ||
18862 | 256188 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1598 Bay St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | 6003155.82812 | 2120664.19895 | 37.8031173987704 | -122.433289466249 | (37.8031173987704, -122.433289466249) | 13 | 9 | 1 | 57 | 17 | |||
20378 | 116241 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229x HAIGHT ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
30042 | 258516 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 50 Hermann St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | ||||
30538 | 258520 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 50 Hermann St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | ||||
31119 | 255523 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2461 Sacramento St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/09/2018 12:00:00 AM | 3 | 3x3 | 6002905 | 2115842 | 37.7898626566676 | -122.433812591785 | (37.7898626566676, -122.433812591785) | 13 | 9 | 1 | 29490 | 27 | ||
36912 | 46881 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2300@Green Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/2012 12:00:00 AM | Permit Number 768822 | 6006358.85800747 | 2118685.04678939 | 37.7978643358127 | -122.422064597009 | (37.7978643358127, -122.422064597009) | 13 | 9 | 10 | 28858 | 32 | |||
38919 | 84742 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 147 Alhambra St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 03/27/2007 12:00:00 AM | 4x6 | Permit Number 49255 | 6001618 | 2120311 | 37.8020602472718 | -122.438585827087 | (37.8020602472718, -122.438585827087) | 13 | 9 | 1 | 57 | 17 | ||
42496 | 116243 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229x HAIGHT ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
46430 | 76789 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
49933 | 258519 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 50 Hermann St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | ||||
51070 | 76761 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
53958 | 76804 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
54873 | 98330 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 147 Alhambra St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 03/27/2007 12:00:00 AM | 4x6 | Permit Number 49255 | 6001593.9 | 2120254.3 | 37.801903193112 | -122.438665159251 | (37.801903193112, -122.438665159251) | 13 | 9 | 1 | 57 | 17 | ||
56227 | 116244 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229x HAIGHT ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
59182 | 116252 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229 HAIGHT ST | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
69531 | 116248 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229 HAIGHT ST | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
70345 | 255525 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2461 Sacramento St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/09/2018 12:00:00 AM | 3 | 3x3 | 6002905 | 2115842 | 37.7898626566676 | -122.433812591785 | (37.7898626566676, -122.433812591785) | 13 | 9 | 1 | 29490 | 27 | ||
74050 | 103596 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 10X Hermann St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2014 12:00:00 AM | 3x3 | Permit Number 771143 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.425958137982 | (37.7707643495235, -122.425958137982) | 7 | 9 | 5 | 28852 | 10 | ||
74249 | 116261 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
74355 | 115438 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2500X Larkin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/01/2016 12:00:00 AM | 3 | Permit Number 777506 | 6006688.6 | 2119773.1 | 37.8008704472237 | -122.421000888697 | (37.8008704472237, -122.421000888697) | 5 | 9 | 1 | 28858 | 32 | ||
74650 | 84929 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1500@Polk Broadway | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2007 12:00:00 AM | Permit Number 49344 | 6006413.8 | 2117997.6 | 37.795979878671 | -122.421825625767 | (37.795979878671, -122.421825625767) | 13 | 9 | 10 | 28858 | 32 | |||
77164 | 17862 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2121 Pine St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/31/2017 11:37:00 AM | 3 | 3X3 | 6003706.1864 | 2115222.5689 | 37.7882072868246 | -122.430996333749 | (37.7882072868246, -122.430996333749) | 13 | 9 | 11 | 29490 | 27 | ||
80914 | 255524 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2461 Sacramento St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/09/2018 12:00:00 AM | 3 | 3x3 | 6002905 | 2115842 | 37.7898626566676 | -122.433812591785 | (37.7898626566676, -122.433812591785) | 13 | 9 | 1 | 29490 | 27 | ||
83740 | 116253 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
85994 | 76813 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
90969 | 115004 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1050 MCALLISTER ST | 5 | Front Yard : Cutout | Tree | Office of Mayor 9 | DPW | 01/19/2016 09:19:00 AM | 3 | 3x3 | 6004148 | 2111858 | 37.7789940453007 | -122.429227726914 | (37.7789940453007, -122.429227726914) | 7 | 9 | 11 | 29490 | 41 | |
91107 | 102914 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2848 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2013 12:00:00 AM | 3x3 | Permit Number 770041 | 5999369.2 | 2118090.3 | 37.7958346193373 | -122.446207883579 | (37.7958346193373, -122.446207883579) | 13 | 9 | 1 | 57 | 17 | ||
91598 | 76793 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
92392 | 116250 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229 HAIGHT ST | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
93318 | 111178 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2109 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006363 | 2118096 | 37.7962471953974 | -122.422008397548 | (37.7962471953974, -122.422008397548) | 13 | 9 | 10 | 28858 | 32 | ||||
94231 | 258514 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 50 Hermann St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | ||||
95489 | 103593 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 10X Hermann St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2014 12:00:00 AM | 3x3 | Permit Number 771143 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.425958137982 | (37.7707643495235, -122.425958137982) | 7 | 9 | 5 | 28852 | 10 | ||
102477 | 116246 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229 HAIGHT ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
102669 | 255526 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2461 Sacramento St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/09/2018 12:00:00 AM | 3 | 3x3 | 6002905 | 2115842 | 37.7898626566676 | -122.433812591785 | (37.7898626566676, -122.433812591785) | 13 | 9 | 1 | 29490 | 27 | ||
102780 | 116254 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
102904 | 258517 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 50 Hermann St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | ||||
103816 | 116240 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229x HAIGHT ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
106404 | 76809 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
113350 | 116238 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229x HAIGHT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
114926 | 116249 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229 HAIGHT ST | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
120038 | 116245 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229 HAIGHT ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
120178 | 116251 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229 HAIGHT ST | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
120674 | 124797 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2898 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/28/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780062 | 5999308.846 | 2118065.45598 | 37.7957629573367 | -122.446414930702 | (37.7957629573367, -122.446414930702) | 13 | 9 | 1 | 57 | 17 | |
123771 | 116260 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
124462 | 17911 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2321 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/12/2016 10:58:00 AM | 3 | 3X3 | 6002821.483 | 2115107.812 | 37.7878420242306 | -122.434049048426 | (37.7878420242306, -122.434049048426) | 13 | 9 | 11 | 29490 | 27 | ||
125035 | 255253 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2178 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/2018 12:00:00 AM | 3 | 3x3 | 6003537 | 2115267 | 37.7883196953611 | -122.43158486312 | (37.7883196953611, -122.43158486312) | 13 | 9 | 1 | 29490 | 27 | ||
133250 | 76766 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
148384 | 116242 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229x HAIGHT ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
150109 | 116239 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229x HAIGHT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
153151 | 103584 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 55X Laguna St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2014 12:00:00 AM | 3x3 | Permit Number 771143 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.425234826708 | (37.7711001201992, -122.425234826708) | 7 | 9 | 5 | 28852 | 10 | ||
156289 | 76753 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
158445 | 76746 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
159702 | 258515 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 50 Hermann St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | ||||
170457 | 116247 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 229 HAIGHT ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005035 | 2109517 | 37.7726164042624 | -122.425992544154 | (37.7726164042624, -122.425992544154) | 7 | 9 | 5 | 28852 | 10 | ||||
170762 | 256228 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2461 Sacramento St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6002905 | 2115842 | 37.7898626566676 | -122.433812591785 | (37.7898626566676, -122.433812591785) | 13 | 9 | 1 | 29490 | 27 | ||||
172681 | 116256 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
172881 | 121042 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2101 Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006363 | 2118098 | 37.7962526868942 | -122.422008539697 | (37.7962526868942, -122.422008539697) | 13 | 9 | 10 | 28858 | 32 | ||||
173794 | 103586 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 55X Laguna St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2014 12:00:00 AM | 3x3 | Permit Number 771143 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.425234826708 | (37.7711001201992, -122.425234826708) | 7 | 9 | 5 | 28852 | 10 | ||
178606 | 76782 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
179281 | 76817 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | 3x3 | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | ||
181198 | 118312 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2410 STEINER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002301 | 2116562 | 37.7918052987456 | -122.435953913571 | (37.7918052987456, -122.435953913571) | 13 | 9 | 1 | 29490 | 27 | ||||
185355 | 76799 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1320 Lombard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2012 12:00:00 AM | Permit Number 768047 | 6006034.8249105 | 2120045.34367344 | 37.8015810844337 | -122.423282592369 | (37.8015810844337, -122.423282592369) | 5 | 9 | 1 | 28858 | 32 | |||
185678 | 116258 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
185917 | 103585 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 55X Laguna St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2014 12:00:00 AM | 3x3 | Permit Number 771143 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.425234826708 | (37.7711001201992, -122.425234826708) | 7 | 9 | 5 | 28852 | 10 | ||
188472 | 116257 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
191012 | 137900 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2191 PINE ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/19/2013 12:00:00 AM | 11 | Width 0ft | 6003458.0512 | 2115193.5788 | 37.7881136242314 | -122.431852768372 | (37.7881136242314, -122.431852768372) | 13 | 9 | 11 | 29490 | 27 | ||
5376 | 203267 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2 Garcia Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 06/08/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 781591 | 5995210.8831 | 2099639.94271 | 37.7449364165845 | -122.45925958957 | (37.7449364165845, -122.45925958957) | 1 | 8 | 4 | 59 | 40 | |
6587 | 261546 | Planning Code 138.1 required 2 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1955 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2020 12:00:00 AM | 3 | 3X3 | Permit Number 783144 | 5985360.77923 | 2101907.46183 | 37.750591180724 | -122.493485992107 | (37.750591180724, -122.493485992107) | 1 | 8 | 3 | 29491 | 35 | |
10940 | 92249 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1382 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2020 12:00:00 AM | 3 | 3x3 | Permit Number 52698 | 5985580.0638 | 2105823.8988 | 37.7613574627672 | -122.493016162233 | (37.7613574627672, -122.493016162233) | 1 | 8 | 3 | 56 | 35 | |
11531 | 203268 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2 Garcia Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 06/08/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 781591 | 5995209.06254 | 2099610.1708 | 37.7448545656781 | -122.459263729153 | (37.7448545656781, -122.459263729153) | 1 | 8 | 4 | 59 | 40 | |
14369 | 203266 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2 Garcia Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 06/08/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 781591 | 5995196 | 2099610 | 37.7448533456978 | -122.459308884303 | (37.7448533456978, -122.459308884303) | 1 | 8 | 4 | 59 | 40 | |
20330 | 115297 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 84 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 775683 | 5992506.3 | 2098571.2 | 37.7418460572185 | -122.468533715231 | (37.7418460572185, -122.468533715231) | 1 | 8 | 4 | 29491 | 40 | |||
35798 | 210473 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 855 Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/2016 12:00:00 AM | 14 | Width 3ft | Permit Number 41828 | 5993066.85825 | 2107284.57434 | 37.765803096459 | -122.467228905809 | (37.765803096459, -122.467228905809) | 11 | 8 | 11 | 56 | 12 | |
44103 | 115287 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1526 12th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 776185 | 5992489.2 | 2105046.7 | 37.7596251212978 | -122.469064003389 | (37.7596251212978, -122.469064003389) | 1 | 8 | 4 | 56 | 12 | |||
45994 | 56898 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1886 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | Permit Number 775792 | 5985700.55899725 | 2102390.4838018 | 37.7519372972974 | -122.492346587933 | (37.7519372972974, -122.492346587933) | 1 | 8 | 3 | 56 | 35 | |||
51392 | 37127 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1501 46th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/01/1998 12:00:00 AM | 2x2 | Permit Number 39712 | 5981856.07887628 | 2104857.97095308 | 37.7584868087664 | -122.50582403114 | (37.7584868087664, -122.50582403114) | 1 | 8 | 3 | 56 | 35 | ||
53752 | 121107 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1391 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2016 12:00:00 AM | 3 | 3x3 | 5993608 | 2106030 | 37.7623895873424 | -122.465266089176 | (37.7623895873424, -122.465266089176) | 1 | 8 | 11 | 56 | 12 | ||
60053 | 93574 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2998 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/2010 12:00:00 AM | 3x3 | Permit Number 53727 | 5995937.7 | 2087355.5 | 37.711248045329 | -122.455858535778 | (37.711248045329, -122.455858535778) | 9 | 8 | 6 | 28861 | 24 | ||
66436 | 98847 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2400 Noriega St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768753 | 5986497.5 | 2103053.8 | 37.753805142535 | -122.489639464015 | (37.753805142535, -122.489639464015) | 1 | 8 | 3 | 56 | 35 | |
77723 | 55923 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 530 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/1973 12:00:00 AM | 3 | 3x3 | Permit Number 774578 | 5992693.0422579 | 2103919.63429657 | 37.7565422691319 | -122.468277027995 | (37.7565422691319, -122.468277027995) | 1 | 8 | 4 | 56 | 12 | |
77781 | 115289 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1425 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 775512 | 5991747.8 | 2105705.5 | 37.7613911460485 | -122.47167612106 | (37.7613911460485, -122.47167612106) | 1 | 8 | 4 | 56 | 12 | |||
102162 | 216685 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 111 Ashton Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/06/2017 08:11:00 AM | 3 | Width 3ft | 5994133.1609 | 2090669.87199 | 37.7202447887441 | -122.462335661261 | (37.7202447887441, -122.462335661261) | 9 | 8 | 6 | 28861 | 24 | ||
105519 | 97293 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2154 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2011 12:00:00 AM | 3x3 | Permit Number 768386 | 5989030.8 | 2106542.7 | 37.7635322996796 | -122.481134285356 | (37.7635322996796, -122.481134285356) | 1 | 8 | 3 | 56 | 35 | ||
108273 | 93575 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2998 San Jose Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/2010 12:00:00 AM | 3x3 | Permit Number 53727 | 5995937.7 | 2087355.5 | 37.711248045329 | -122.455858535778 | (37.711248045329, -122.455858535778) | 9 | 8 | 6 | 28861 | 24 | ||
109612 | 55389 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1386 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1972 12:00:00 AM | 3x3 | Permit Number 11326 | 5993364.66899649 | 2106056.80614716 | 37.762449154491 | -122.466109621957 | (37.762449154491, -122.466109621957) | 1 | 8 | 11 | 56 | 12 | ||
114886 | 50468 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 10 Merced Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/30/2016 12:00:00 AM | 3 | Permit Number 778534 | 5995312.36828974 | 2100223.18422456 | 37.7465436862786 | -122.458950895655 | (37.7465436862786, -122.458950895655) | 1 | 8 | 4 | 59 | 40 | |
116618 | 43627 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2230 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2016 12:00:00 AM | 0 | 3x3 | Permit Number 775700 | 5985470.85834553 | 2100027.42958295 | 37.7454355618475 | -122.492966865959 | (37.7454355618475, -122.492966865959) | 1 | 8 | 3 | 29491 | 35 |
119291 | 93577 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2998 San Jose Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53727 | 5995937.7 | 2087355.5 | 37.711248045329 | -122.455858535778 | (37.711248045329, -122.455858535778) | 9 | 8 | 6 | 28861 | 24 | |
123252 | 162764 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 919 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/2017 10:56:00 AM | 3 | Width 0ft | 5995008.1104 | 2090049.40289 | 37.7185914714977 | -122.459266363268 | (37.7185914714977, -122.459266363268) | 9 | 8 | 6 | 28861 | 24 | ||
143392 | 100949 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1561 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 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 | |
143629 | 98845 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2400 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2012 12:00:00 AM | 2 | 3x3 | Permit Number 768753 | 5986497.5 | 2103053.8 | 37.753805142535 | -122.489639464015 | (37.753805142535, -122.489639464015) | 1 | 8 | 3 | 56 | 35 | |
147693 | 121108 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1391 08th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2016 12:00:00 AM | 3 | 3x3 | 5993608 | 2106030 | 37.7623895873424 | -122.465266089176 | (37.7623895873424, -122.465266089176) | 1 | 8 | 11 | 56 | 12 |
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) );