trees
261 rows where qSpecies_id = 177 sorted by rowid 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 191399 | 25159 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2600X Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2015 12:55:00 PM | 3 | 3X3 | 6001683.708124 | 2105708.1424059 | 37.7619682491468 | -122.437312213886 | (37.7619682491468, -122.437312213886) | 15 | 4 | 5 | 28862 | 3 | ||
| 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 | ||
| 190939 | 13063 | Planning Code 138.1 required 2 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 590 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/29/2017 12:00:00 AM | 3 | 2X2 | Permit Number 780933 | 6009554.3361 | 2120533.7978 | 37.803120257284 | -122.411137959105 | (37.803120257284, -122.411137959105) | 3 | 1 | 10 | 308 | 23 | |
| 189227 | 109745 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2730 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 769296 | 6008568.6 | 2106948.2 | 37.7657621501348 | -122.413587690705 | (37.7657621501348, -122.413587690705) | 8 | 4 | 7 | 28853 | 19 |
| 189069 | 104606 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 30 Russell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2013 12:00:00 AM | 2x3 | Permit Number 770083 | 6007173 | 2118980 | 37.7987200876771 | -122.419268364856 | (37.7987200876771, -122.419268364856) | 5 | 1 | 10 | 28858 | 32 | ||
| 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 | ||||
| 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 | ||
| 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 | ||||
| 185404 | 107849 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1300x ANZA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5994625 | 2112199 | 37.7793866324847 | -122.462196108999 | (37.7793866324847, -122.462196108999) | 11 | 6 | 2 | 54 | 11 | |||
| 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 | |||
| 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 | ||||
| 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 | ||
| 178780 | 112777 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1899X Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2015 12:00:00 AM | Permit Number 774327 | 5992976.20102 | 2112064.24796 | 37.7789215671599 | -122.467890144832 | (37.7789215671599, -122.467890144832) | 11 | 6 | 2 | 54 | 11 | |||
| 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 | |||
| 178223 | 256896 | Planning Code 138.1 required 2 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 470 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780643 | 5985651.17942 | 2112710.44444 | 37.7802701294342 | -122.493277571063 | (37.7802701294342, -122.493277571063) | 11 | 6 | 2 | 55 | 26 | |
| 177950 | 113397 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 603 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998367 | 2108846 | 37.7703949048055 | -122.449009410311 | (37.7703949048055, -122.449009410311) | 15 | 5 | 11 | 29492 | 9 | ||||
| 177836 | 13081 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 650-654 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2017 12:08:00 PM | 3 | 3x3 | 6009251.0552 | 2120493.5635 | 37.8029927712959 | -122.412184629201 | (37.8029927712959, -122.412184629201) | 3 | 1 | 10 | 308 | 23 | ||
| 177248 | 103086 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 99 Colton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2x3 | See 55 Brady St; trees planted at same time with permits/FUF | 6006671.4 | 2109566.7 | 37.7728452155106 | -122.420335581823 | (37.7728452155106, -122.420335581823) | 8 | 2 | 9 | 28853 | 19 | ||
| 177143 | 140885 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 112 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 05/04/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781739 | 5996566.0494 | 2113683.186 | 37.7835733852629 | -122.455588548359 | (37.7835733852629, -122.455588548359) | 11 | 6 | 1 | 54 | 31 | |
| 176540 | 37129 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1501 46th Ave | 4 | 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 | ||
| 175524 | 103085 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 99 Colton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2x3 | See 55 Brady St; trees planted at same time with permits/FUF | 6006671.4 | 2109566.7 | 37.7728452155106 | -122.420335581823 | (37.7728452155106, -122.420335581823) | 8 | 2 | 9 | 28853 | 19 | ||
| 175464 | 54377 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1454 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774580 | 5984357.5042 | 2105265.8509 | 37.7597536454069 | -122.497203224003 | (37.7597536454069, -122.497203224003) | 1 | 8 | 3 | 56 | 35 |
| 175454 | 29909 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 515-519 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2016 07:29:00 AM | 3 | 3x3 | 6009867.8709 | 2120537.6157 | 37.8031483182934 | -122.410053228903 | (37.8031483182934, -122.410053228903) | 3 | 1 | 10 | 308 | 23 | ||
| 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 | ||
| 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 | ||||
| 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 | ||||
| 171538 | 54801 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1301X 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/07/1982 12:00:00 AM | 3x3 | Permit Number 20098 | 5994223.60304226 | 2106594.5281627 | 37.7639751162558 | -122.463177926852 | (37.7639751162558, -122.463177926852) | 1 | 5 | 11 | 56 | 12 | ||
| 170987 | 9125 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 5827 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/10/2017 11:55:00 AM | 3 | 3X3 | 5988965.7697498 | 2112572.6420628 | 37.7800850757133 | -122.481800911494 | (37.7800850757133, -122.481800911494) | 11 | 6 | 2 | 55 | 26 | ||
| 170941 | 98846 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2400 Noriega St | 3 | 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 | |
| 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 | ||||
| 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 | ||||
| 168854 | 102006 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1703 Castro St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776283 | 6002624 | 2100623.7 | 37.7480609930318 | -122.433696712327 | (37.7480609930318, -122.433696712327) | 2 | 4 | 5 | 63 | 22 | |
| 168214 | 108636 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 68 Mangels Ave | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774603 | 6000942.00546 | 2095224.20835 | 37.7331396755893 | -122.439126041581 | (37.7331396755893, -122.439126041581) | 9 | 7 | 5 | 63 | 40 | |
| 167690 | 256776 | Planning Code 138.1 required 2 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 244 Ashton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/13/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781951 | 5994190.23703 | 2091515.08881 | 37.7225688371899 | -122.462199635944 | (37.7225688371899, -122.462199635944) | 9 | 8 | 4 | 28861 | 24 | |
| 167508 | 256485 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1047 Hollister Ave | 3 | unknown : Yard | Tree | Private 2 | Width 0ft | 6014610.748 | 2089844.7127 | 37.7191369573176 | -122.391493192738 | (37.7191369573176, -122.391493192738) | 10 | 3 | 8 | 58 | 1 | ||||
| 167419 | 254751 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 701 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008942 | 2120384 | 37.8026745911634 | -122.413246372322 | (37.8026745911634, -122.413246372322) | 3 | 1 | 10 | 308 | 23 | ||||
| 166626 | 115253 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 20 Edgar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | Permit Number 772988 | 5997135.3 | 2090888.7 | 37.7210180538388 | -122.451974094521 | (37.7210180538388, -122.451974094521) | 9 | 8 | 6 | 28861 | 24 | |||
| 164090 | 18540 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 60 Quartz Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 75 | 2x2 | Permit Number 778371 | 5999060.6585186 | 2099832.0947892 | 37.7456846005578 | -122.445961639207 | (37.7456846005578, -122.445961639207) | 2 | 7 | 5 | 63 | 22 | ||
| 163779 | 116372 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1306 10TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x8 | 5993057 | 2106542 | 37.7637636140689 | -122.467209006309 | (37.7637636140689, -122.467209006309) | 1 | 8 | 11 | 56 | 12 | ||||
| 162511 | 104603 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 10X Russell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2013 12:00:00 AM | 2x3 | Permit Number 770083 | 6007114.43488 | 2118959.67619 | 37.7986609851308 | -122.419469576763 | (37.7986609851308, -122.419469576763) | 5 | 1 | 10 | 28858 | 32 | ||
| 162432 | 92388 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 170 Park St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2009 12:00:00 AM | 3x3 | Permit Number 52791 | 6005986 | 2096352 | 37.7365220626686 | -122.421767651977 | (37.7365220626686, -122.421767651977) | 2 | 7 | 7 | 28859 | 2 | |||
| 161101 | 113398 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 603 CLAYTON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998367 | 2108846 | 37.7703949048055 | -122.449009410311 | (37.7703949048055, -122.449009410311) | 15 | 5 | 11 | 29492 | 9 | ||||
| 160746 | 105053 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 501X 27th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2013 12:00:00 AM | 3x3 | Permit Number 770390 | 5987510.95423 | 2112219.64233 | 37.7790311285688 | -122.48680778308 | (37.7790311285688, -122.48680778308) | 11 | 6 | 2 | 55 | 26 | ||
| 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 | ||||
| 159293 | 9031 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 5351 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5990365.52035 | 2112599.40799 | 37.7802398682569 | -122.476960548186 | (37.7802398682569, -122.476960548186) | 11 | 6 | 2 | 55 | 26 | ||
| 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 | |||
| 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 | |||
| 154970 | 139362 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2869 BUSH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5999793.3033 | 2114332.6333 | 37.7855412639984 | -122.444470219362 | (37.7855412639984, -122.444470219362) | 15 | 6 | 1 | 29490 | 31 | |||
| 154814 | 13082 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 650 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2016 10:37:00 AM | 3 | 3x3 | 6009219.60633 | 2120572.31429 | 37.8032072366716 | -122.412299028441 | (37.8032072366716, -122.412299028441) | 3 | 1 | 10 | 308 | 23 | ||
| 153634 | 90471 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 534 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/20/2008 12:00:00 AM | 3 | 3x3 | 5988147.641992 | 2112343.937312 | 37.7794095060794 | -122.484614370085 | (37.7794095060794, -122.484614370085) | 11 | 6 | 2 | 55 | 26 | |
| 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 | ||
| 151386 | 106547 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 4509A 25th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/2014 12:00:00 AM | 3x3 | Permit Number 772697 | 6000984.2 | 2101089.3 | 37.7492462369191 | -122.439400435576 | (37.7492462369191, -122.439400435576) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 | ||||
| 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 | ||||
| 148366 | 30786 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 477 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2011 12:00:00 AM | Permit Number 768077 | 6013986.79222779 | 2112639.44439925 | 37.781691783585 | -122.395245890478 | (37.781691783585, -122.395245890478) | 6 | 2 | 9 | 28856 | 6 | ||
| 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 | ||
| 146054 | 92047 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2323 Cesar Chavez St | Sidewalk: Property side : Yard | Tree | DPW 1 | 05/16/2009 12:00:00 AM | 6012395.863444 | 2100936.77011 | 37.7494702500338 | -122.399927744224 | (37.7494702500338, -122.399927744224) | 10 | 3 | 8 | 58 | 1 | |||||
| 145113 | 56806 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 806 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/02/1974 12:00:00 AM | Permit Number 14035 | 5999139.37670373 | 2107622.75358893 | 37.7670803223615 | -122.446249761039 | (37.7670803223615, -122.446249761039) | 15 | 5 | 5 | 29492 | 9 | |||
| 144072 | 252852 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 100X Langton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x4 | 6010166 | 2110701 | 37.776156040571 | -122.408327321329 | (37.776156040571, -122.408327321329) | 8 | 2 | 9 | 28853 | 34 | ||||
| 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 | |
| 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 | |
| 142116 | 99931 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 801X Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2012 12:00:00 AM | 3x3 | Permit Number 768924 | 6003100.6 | 2103580.4 | 37.7562064244422 | -122.432259777723 | (37.7562064244422, -122.432259777723) | 2 | 4 | 5 | 28862 | 22 | ||
| 141100 | 55048 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 3791 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2012 12:00:00 AM | Permit Number 768924 | 6003127.14535424 | 2103564.68904381 | 37.7561647909862 | -122.432166852953 | (37.7561647909862, -122.432166852953) | 2 | 4 | 5 | 28862 | 22 | |||
| 138508 | 13083 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 660 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/24/2015 11:06:00 AM | 3 | 3X3 | 6009215.12 | 2120489.4566 | 37.8029794783612 | -122.412308693696 | (37.8029794783612, -122.412308693696) | 3 | 1 | 10 | 308 | 23 | ||
| 137970 | 121488 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 750 Parnassus Ave | 1 | Median : Cutout | Tree | DPW 1 | 3x3 | 5994725.72352 | 2106063.15709 | 37.7625450220518 | -122.461402729778 | (37.7625450220518, -122.461402729778) | 15 | 5 | 11 | 56 | 12 | ||||
| 137875 | 13025 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 451 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/2016 07:02:00 AM | 3 | 3X3 | 6010198.7145 | 2120581.4625 | 37.8032872483458 | -122.40891142592 | (37.8032872483458, -122.40891142592) | 3 | 1 | 10 | 308 | 23 | ||
| 135717 | 112521 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 146x ARLETA AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010471 | 2087928 | 37.7136434126305 | -122.405667857285 | (37.7136434126305, -122.405667857285) | 9 | 7 | 8 | 309 | 39 | ||||
| 134325 | 60027 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 41 South Park | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/18/2013 12:00:00 AM | Permit Number 769856 | 6014655.81368733 | 2112837.99803451 | 37.7822741509003 | -122.392945269869 | (37.7822741509003, -122.392945269869) | 6 | 2 | 9 | 28856 | 6 | ||
| 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 | |||
| 132603 | 74892 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 141X Arleta Ave | 2 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | FUF | 02/24/2016 12:00:00 AM | 3 | This is for the trees adjacent to the lot between 141-143 Arleta | 6010470.01061258 | 2087860.00753073 | 37.7134566637798 | -122.405666490875 | (37.7134566637798, -122.405666490875) | 9 | 7 | 8 | 309 | 39 | |
| 132601 | 39630 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1568 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2010 12:00:00 AM | 5x3 | Permit Number 53204 | 5997924.75387781 | 2105264.0077583 | 37.7605343603066 | -122.450280891235 | (37.7605343603066, -122.450280891235) | 15 | 5 | 11 | 29492 | 12 | ||
| 131941 | 9116 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 5757 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/23/2015 12:00:00 AM | 3 | 3x3 | 5989143.6236 | 2112579.8502 | 37.7801152084298 | -122.481186169595 | (37.7801152084298, -122.481186169595) | 11 | 6 | 2 | 55 | 26 | ||
| 129328 | 92913 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 87 Ramona Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/18/2009 12:00:00 AM | 3 | 6x12 | Permit Number 53113 | 6005252.7 | 2107310.7 | 37.7665707358936 | -122.425082484344 | (37.7665707358936, -122.425082484344) | 8 | 4 | 5 | 28853 | 19 | |
| 128713 | 255394 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1385 Clay St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/2018 12:00:00 AM | 3 | 3x3 | 6008122.9402 | 2116875.02037 | 37.7929937885047 | -122.415832123045 | (37.7929937885047, -122.415832123045) | 5 | 1 | 10 | 28858 | 21 | ||
| 128671 | 13042 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 515-519 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2016 07:23:00 AM | 3 | 3x3 | 6009844.8077 | 2120534.1734 | 37.8031375739168 | -122.410132796901 | (37.8031375739168, -122.410132796901) | 3 | 1 | 10 | 308 | 23 | ||
| 128647 | 255530 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 301 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6010757.6116 | 2120655.4263 | 37.8035216252403 | -122.406982550515 | (37.8035216252403, -122.406982550515) | 3 | 1 | 10 | 308 | 23 | ||||
| 126183 | 13014 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 408 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2016 02:25:00 PM | 3 | 3X3 | 6010352 | 2120661 | 37.8035142236954 | -122.408386587386 | (37.8035142236954, -122.408386587386) | 3 | 1 | 10 | 308 | 23 | ||
| 125406 | 104605 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 10X Russell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2013 12:00:00 AM | 2x3 | Permit Number 770083 | 6007114.43488 | 2118959.67619 | 37.7986609851308 | -122.419469576763 | (37.7986609851308, -122.419469576763) | 5 | 1 | 10 | 28858 | 32 | ||
| 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 | ||
| 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 | ||
| 124246 | 1444 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 151X Arguello Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/17/2009 12:00:00 AM | 3 | 3X5 | 5995492.27499 | 2115135.20138 | 37.7874985527143 | -122.459408560713 | (37.7874985527143, -122.459408560713) | 11 | 6 | 1 | 54 | 11 | ||
| 123948 | 75029 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 141X Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | FUF | 02/24/2016 12:00:00 AM | 3 | This record is for lthe ot between 141-143 Arleta Ave. | 6010470.01061258 | 2087860.00753073 | 37.7134566637798 | -122.405666490875 | (37.7134566637798, -122.405666490875) | 9 | 7 | 8 | 309 | 39 | |
| 123811 | 13034 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 490 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/16/2016 02:07:00 PM | 3 | 3x3 | 6010037.8987 | 2120598.0598 | 37.8033238110836 | -122.409469108899 | (37.8033238110836, -122.409469108899) | 3 | 1 | 10 | 308 | 23 | ||
| 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 | ||||
| 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 | ||
| 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 | |
| 120504 | 254750 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 701 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008942 | 2120384 | 37.8026745911634 | -122.413246372322 | (37.8026745911634, -122.413246372322) | 3 | 1 | 10 | 308 | 23 | ||||
| 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 | ||||
| 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 | ||||
| 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 | |
| 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 |
| 116521 | 143019 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 410 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6010368.5125 | 2120644.4743 | 37.8034697728784 | -122.408328278578 | (37.8034697728784, -122.408328278578) | 3 | 1 | 10 | 308 | 23 | |||
| 115031 | 122520 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 250 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004004.54241313 | 2097731.78472111 | 37.740198698919 | -122.428716724311 | (37.740198698919, -122.428716724311) | 2 | 7 | 5 | 63 | 7 | ||||
| 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 | ||||
| 114910 | 102005 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1703 CASTRO ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776283 | 6002624 | 2100623.7 | 37.7480609930318 | -122.433696712327 | (37.7480609930318, -122.433696712327) | 2 | 4 | 5 | 63 | 22 | |
| 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 | |
| 114150 | 104604 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 10X Russell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2013 12:00:00 AM | 2x3 | Permit Number 770083 | 6007114.43488 | 2118959.67619 | 37.7986609851308 | -122.419469576763 | (37.7986609851308, -122.419469576763) | 5 | 1 | 10 | 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 | ||||
| 111732 | 12989 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 325 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2017 12:00:00 AM | 3 | 3X3 | Permit Number 780097 | 6010757.6116 | 2120655.4263 | 37.8035216252403 | -122.406982550515 | (37.8035216252403, -122.406982550515) | 3 | 1 | 10 | 308 | 23 | |
| 110398 | 90511 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 569 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5988115.726692 | 2112113.510215 | 37.7787749594642 | -122.484707869401 | (37.7787749594642, -122.484707869401) | 11 | 6 | 2 | 55 | 26 |
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) );