trees
261 rows where qSpecies_id = 177 sorted by qCaretaker_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5671 | 13046 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 534 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x3 | 6009764.2975 | 2120561.184 | 37.8032072253646 | -122.410413314112 | (37.8032072253646, -122.410413314112) | 3 | 1 | 10 | 308 | 23 | |||
| 6110 | 13007 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 373 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/24/2015 10:56:00 AM | 3 | 3x3 | 6010526.1986 | 2120617.8557 | 37.8034055135257 | -122.407780718516 | (37.8034055135257, -122.407780718516) | 3 | 1 | 10 | 308 | 23 | ||
| 9548 | 13006 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 383 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/24/2015 10:51:00 AM | 3 | 3X3 | 6010482.094 | 2120612.9552 | 37.8033895888272 | -122.407932999148 | (37.8033895888272, -122.407932999148) | 3 | 1 | 10 | 308 | 23 | ||
| 10133 | 12999 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 349 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/10/2017 09:03:00 AM | 3 | 3X3 | 6010644.3554 | 2120634.1907 | 37.8034569792808 | -122.407372982577 | (37.8034569792808, -122.407372982577) | 3 | 1 | 10 | 308 | 23 | ||
| 11154 | 13008 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 373 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/27/2015 10:06:00 AM | 3 | 3X3 | 6010552.8791 | 2120622.2117 | 37.8034189676022 | -122.407688696484 | (37.8034189676022, -122.407688696484) | 3 | 1 | 10 | 308 | 23 | ||
| 11709 | 13039 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 515-519 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6009909.1781 | 2120541.7464 | 37.8031619752733 | -122.409910575369 | (37.8031619752733, -122.409910575369) | 3 | 1 | 10 | 308 | 23 | |||
| 13736 | 90469 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 578 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988158.072517 | 2112047.558198 | 37.778596339842 | -122.484556541536 | (37.778596339842, -122.484556541536) | 11 | 6 | 2 | 55 | 26 | |
| 14797 | 264653 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 982 Ingerson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/08/2020 04:50:00 PM | 3x3 | 6014279.95597 | 2089795.48577 | 37.71898342396 | -122.39263318135 | (37.71898342396, -122.39263318135) | 10 | 3 | 8 | 58 | 1 | |||
| 16151 | 13005 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 383 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/24/2015 10:59:00 AM | 3 | 3X3 | 6010464.6699 | 2120611.8662 | 37.8033856231837 | -122.407993219356 | (37.8033856231837, -122.407993219356) | 3 | 1 | 10 | 308 | 23 | ||
| 16520 | 121489 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2 Judah St | 1 | Median : Cutout | Tree | DPW 1 | 3x3 | ||||||||||||||
| 17402 | 12986 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 312 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2016 06:43:00 AM | 3 | 3X3 | 6010791.3462 | 2120702.976 | 37.8036540726688 | -122.406869163124 | (37.8036540726688, -122.406869163124) | 3 | 1 | 10 | 308 | 23 | ||
| 17536 | 264654 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 999 Ingerson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/08/2020 04:51:00 PM | 3x3 | |||||||||||||
| 19019 | 13004 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 368 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2016 06:38:00 AM | 3 | 4X4 | 6010562.3418 | 2120670.5672 | 37.8035522695821 | -122.407659361785 | (37.8035522695821, -122.407659361785) | 3 | 1 | 10 | 308 | 23 | ||
| 35355 | 13022 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 431 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/28/2015 07:20:00 AM | 3 | 3X3 | 6010276.62799 | 2120585.425 | 37.8033024923724 | -122.408642082138 | (37.8033024923724, -122.408642082138) | 3 | 1 | 10 | 308 | 23 | ||
| 45752 | 143037 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 510 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/16/2015 07:44:00 AM | 19 | Width 0ft | 6009884.4437 | 2120577.0857 | 37.8032576219869 | -122.409998666067 | (37.8032576219869, -122.409998666067) | 3 | 1 | 10 | 308 | 23 | ||
| 53358 | 12988 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 324 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2016 06:56:00 AM | 3 | 3X3 | 6010748.7594 | 2120699.4941 | 37.8036421292086 | -122.407016292062 | (37.8036421292086, -122.407016292062) | 3 | 1 | 10 | 308 | 23 | ||
| 54561 | 16816 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2105 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/13/2015 01:25:00 PM | 3 | 4x4 | 6001234.7809998 | 2113147.0836075 | 37.7823681904894 | -122.439398128028 | (37.7823681904894, -122.439398128028) | 15 | 5 | 11 | 29490 | 41 | ||
| 63720 | 13009 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 378 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/09/2016 02:11:00 PM | 3 | 4X4 | 6010539.0395 | 2120665.4782 | 37.8035369920045 | -122.407739641802 | (37.8035369920045, -122.407739641802) | 3 | 1 | 10 | 308 | 23 | ||
| 68114 | 8974 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 5045 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/12/2011 12:00:00 AM | 3 | 3x3 | 5991343.5266 | 2112609.97523 | 37.7803255698787 | -122.473577979119 | (37.7803255698787, -122.473577979119) | 11 | 6 | 2 | 54 | 26 | ||
| 70827 | 13016 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 407 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/16/2016 02:31:00 PM | 3 | 3X3 | 6010356.171 | 2120603.3463 | 37.8033561544514 | -122.408368084374 | (37.8033561544514, -122.408368084374) | 3 | 1 | 10 | 308 | 23 | ||
| 72042 | 13024 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 445 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/04/2014 02:58:00 PM | 3 | 3X3 | 6010214.1933 | 2120583.5975 | 37.8032939775537 | -122.40885801149 | (37.8032939775537, -122.40885801149) | 3 | 1 | 10 | 308 | 23 | ||
| 72719 | 90526 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 705 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/18/2008 12:00:00 AM | 3 | 3x3 | 5988149.756261 | 2111164.589328 | 37.7761714707406 | -122.484520528522 | (37.7761714707406, -122.484520528522) | 11 | 6 | 2 | 55 | 26 | |
| 72976 | 13010 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 396 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/28/2015 07:16:00 AM | 3 | 3X3 | 6010502.3453 | 2120665.4782 | 37.8035349377887 | -122.407866624342 | (37.8035349377887, -122.407866624342) | 3 | 1 | 10 | 308 | 23 | ||
| 76872 | 13011 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 396 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/28/2015 07:12:00 AM | 3 | 3X3 | 6010476.6325 | 2120660.3892 | 37.8035195251148 | -122.40795524598 | (37.8035195251148, -122.40795524598) | 3 | 1 | 10 | 308 | 23 | ||
| 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 | ||
| 91501 | 12995 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 336 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6010707.244 | 2120695.2086 | 37.8036280390364 | -122.407159656622 | (37.8036280390364, -122.407159656622) | 3 | 1 | 10 | 308 | 23 | |||
| 99264 | 90510 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 555 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5988112.407888 | 2112207.812683 | 37.7790336942222 | -122.484726269831 | (37.7790336942222, -122.484726269831) | 11 | 6 | 2 | 55 | 26 | |
| 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 | |
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | ||
| 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 | |||||
| 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 | |
| 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 | ||
| 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 | ||
| 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 | ||
| 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 | |
| 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 | ||
| 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 | ||
| 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 | ||||
| 1346 | 260123 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 3195X Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/2019 12:00:00 AM | 3 | 3x3 | ||||||||||||
| 2233 | 256484 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1047 Hollister Ave | 2 | unknown : Yard | Tree | Private 2 | Width 0ft | 6014610.748 | 2089844.7127 | 37.7191369573176 | -122.391493192738 | (37.7191369573176, -122.391493192738) | 10 | 3 | 8 | 58 | 1 | ||||
| 2551 | 256191 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 3600 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | |||||||||||||
| 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 | |||
| 4599 | 172187 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 721 Brazil Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 3 | Width 3ft | 6003854.60179 | 2091058.27085 | 37.7218662421102 | -122.428759536545 | (37.7218662421102, -122.428759536545) | 9 | 7 | 6 | 28861 | 5 | ||
| 4868 | 256192 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 3600 Buchanan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | |||||||||||||
| 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 | |||
| 5224 | 229828 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1456 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2020 12:00:00 AM | 3 | 3x3 | 6010092.99129 | 2100772.65012 | 37.7488909550714 | -122.407879605175 | (37.7488909550714, -122.407879605175) | 2 | 4 | 7 | 28859 | 19 | ||
| 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 | |
| 5804 | 253280 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2335 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007032 | 2120361 | 37.8025040230696 | -122.419854317954 | (37.8025040230696, -122.419854317954) | 5 | 1 | 1 | 28858 | 32 | ||||
| 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 | |||
| 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 | |
| 6907 | 108593 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 530 Moraga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774578 | ||||||||||
| 7066 | 115194 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 4150 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2016 12:00:00 AM | Permit Number 777365 | 6002684.1 | 2104186.2 | 37.7578461817613 | -122.433743471638 | (37.7578461817613, -122.433743471638) | 2 | 4 | 5 | 28862 | 3 | |||
| 8112 | 172239 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 285 London St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 3ft | 6002395.65434 | 2092018.35321 | 37.7244197321571 | -122.433871328009 | (37.7244197321571, -122.433871328009) | 9 | 7 | 6 | 28861 | 5 | ||
| 8763 | 13089 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 722 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3X3 | 6008909.0684 | 2120447.731 | 37.8028477316821 | -122.41336484235 | (37.8028477316821, -122.41336484235) | 3 | 1 | 10 | 308 | 23 | |||
| 9500 | 256189 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 3600 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | |||||||||||||
| 9697 | 172238 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 285 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 3ft | 6002385.64302 | 2092003.99063 | 37.7243797276157 | -122.433904909592 | (37.7243797276157, -122.433904909592) | 9 | 7 | 6 | 28861 | 5 | ||
| 10093 | 172178 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 350 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 3 | Width 2ft | 6004331.00068 | 2091119.78411 | 37.7220620955851 | -122.427117126271 | (37.7220620955851, -122.427117126271) | 9 | 7 | 6 | 28861 | 5 | ||
| 10237 | 243286 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 552 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | 4x5 | 6005074.488 | 2107832.11687 | 37.7679923530051 | -122.425736005029 | (37.7679923530051, -122.425736005029) | 8 | 4 | 5 | 28853 | 19 | ||
| 10503 | 233771 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 35 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/2019 03:11:00 PM | 3 | Width 3ft | 6003168.16978 | 2108097.17278 | 37.7686122241979 | -122.432348677773 | (37.7686122241979, -122.432348677773) | 15 | 5 | 5 | 28862 | 3 | ||
| 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 | |
| 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 | ||
| 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 | |
| 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 | ||||
| 13429 | 105011 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 11 Commonwealth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/2013 12:00:00 AM | 5 | Permit Number 770953 | 5996464.5 | 2114492.5 | 37.7857897179877 | -122.455998396638 | (37.7857897179877, -122.455998396638) | 11 | 6 | 1 | 54 | 31 | ||
| 13587 | 13088 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 722 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2019 06:03:00 AM | 3 | 3X3 | 6008925.6016 | 2120449.3844 | 37.8028531997518 | -122.413307745784 | (37.8028531997518, -122.413307745784) | 3 | 1 | 10 | 308 | 23 | ||
| 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 | |
| 15675 | 256190 | Section 806 (d) 5 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 3600 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/2018 12:00:00 AM | 3 | |||||||||||||
| 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 | ||
| 16281 | 13043 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 526 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 11:51:00 AM | 3 | 3x3 | 6009812.0026 | 2120568.2515 | 37.8032293051326 | -122.410248727784 | (37.8032293051326, -122.410248727784) | 3 | 1 | 10 | 308 | 23 | ||
| 17835 | 146870 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 747 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:07:00 PM | 0 | Width 3ft | 5983198.23429 | 2110712.37785 | 37.7746402422966 | -122.501615441996 | (37.7746402422966, -122.501615441996) | 11 | 6 | 2 | 55 | 26 | ||
| 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 | |||
| 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 | |||
| 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 | ||||
| 22838 | 143258 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 661 LOMBARD ST | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 6009397.1671 | 2120467.3833 | 37.8029290843214 | -122.411677153186 | (37.8029290843214, -122.411677153186) | 3 | 1 | 10 | 308 | 23 | |||
| 24212 | 115769 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 210 Drake St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 775810 | 6001697.3 | 2086437.3 | 37.7090557478467 | -122.435886292244 | (37.7090557478467, -122.435886292244) | 9 | 7 | 6 | 28861 | 5 | ||
| 25056 | 105010 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 11 Commonwealth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/2013 12:00:00 AM | 5 | Permit Number 770953 | 5996464.5 | 2114492.5 | 37.7857897179877 | -122.455998396638 | (37.7857897179877, -122.455998396638) | 11 | 6 | 1 | 54 | 31 | ||
| 27136 | 114680 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 54 Colby St | 1 | Front Yard : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | Permit Number 774571 | 6007954.9 | 2093861 | 37.7297931519994 | -122.414784067206 | (37.7297931519994, -122.414784067206) | 9 | 3 | 7 | 309 | 28 | |||
| 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 | ||
| 34396 | 116471 | Section 143 10 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 882 Carolina St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/2016 12:00:00 AM | 3 | 3x3 | 6012399.9 | 2103853.8 | 37.757480004392 | -122.400118621436 | (37.757480004392, -122.400118621436) | 10 | 3 | 8 | 28856 | 29 | |||
| 35337 | 143011 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 650-654 LOMBARD ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/11/2017 12:26:00 PM | 3 | Width 0ft | 6009188.4253 | 2120483.2963 | 37.8029610657241 | -122.412400635876 | (37.8029610657241, -122.412400635876) | 3 | 1 | 10 | 308 | 23 | ||
| 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 | |
| 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 | |||
| 37778 | 104607 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 1839 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2013 12:00:00 AM | 3x3 | Permit Number 770939 | 6009882.8 | 2120354 | 37.8026449918113 | -122.409988596173 | (37.8026449918113, -122.409988596173) | 3 | 1 | 10 | 308 | 23 | ||
| 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 | ||
| 42180 | 114695 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 799x TAYLOR ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009121 | 2115613 | 37.7895846457112 | -122.412289529495 | (37.7895846457112, -122.412289529495) | 5 | 1 | 10 | 28858 | 21 | ||||
| 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 | ||||
| 42853 | 113802 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 806 SHOTWELL ST | 4 | Front Yard : Yard | Tree | Private 2 | 6007931 | 2103220 | 37.755489548438 | -122.415529041662 | (37.755489548438, -122.415529041662) | 2 | 4 | 7 | 28859 | 19 | |||||
| 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 | |||
| 45539 | 683 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2340X Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/2010 12:00:00 AM | 0 | 3X3 | Permit Number 53450 | 5988222.7193 | 2114685.44657 | 37.7858429996456 | -122.484526443804 | (37.7858429996456, -122.484526443804) | 11 | 6 | 1 | 55 | 33 | |
| 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 | |||
| 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 | |||
| 48637 | 114696 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 799x TAYLOR ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009121 | 2115613 | 37.7895846457112 | -122.412289529495 | (37.7895846457112, -122.412289529495) | 5 | 1 | 10 | 28858 | 21 |
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) );