trees
614 rows where qSpecies_id = 29 sorted by Zip Codes
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 72560 | 42675 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1097 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | 5 | Permit Number 42702 | 6007843.31475 | 2118863.44983 | 37.7984377983088 | -122.416940592258 | (37.7984377983088, -122.416940592258) | 5 | 1 | 10 | 28858 | 21 | ||
| 76211 | 41759 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1320-1360 Lombard St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2000 12:00:00 AM | 3x3 | Permit Number 42186 | 6006041 | 2120044 | 37.8015777435459 | -122.423261128156 | (37.8015777435459, -122.423261128156) | 5 | 9 | 1 | 28858 | 32 | ||
| 95310 | 42677 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1097 Green St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | 6 | Permit Number 42702 | 6007869.31291 | 2118866.95146 | 37.7984488752774 | -122.416850878593 | (37.7984488752774, -122.416850878593) | 5 | 1 | 10 | 28858 | 21 | ||
| 103428 | 41764 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1320-1360 Lombard St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2000 12:00:00 AM | 3x3 | Permit Number 42186 | 6006041 | 2120044 | 37.8015777435459 | -122.423261128156 | (37.8015777435459, -122.423261128156) | 5 | 9 | 1 | 28858 | 32 | ||
| 103637 | 41763 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1320-1360 Lombard St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2000 12:00:00 AM | 3x3 | Permit Number 42186 | 6006041 | 2120044 | 37.8015777435459 | -122.423261128156 | (37.8015777435459, -122.423261128156) | 5 | 9 | 1 | 28858 | 32 | ||
| 124697 | 67614 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1257 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52284 | 6005831.35096236 | 2120311.65664048 | 37.8023008263457 | -122.4240056545 | (37.8023008263457, -122.4240056545) | 5 | 9 | 1 | 28858 | 32 | |
| 143437 | 136314 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 107 Bernard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008318.73536 | 2118064.92593 | 37.796271980829 | -122.415238929252 | (37.796271980829, -122.415238929252) | 5 | 1 | 10 | 28858 | 21 | |||
| 147403 | 98671 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 1898@green Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007784.7 | 2118870.1 | 37.7984527607502 | -122.417143889347 | (37.7984527607502, -122.417143889347) | 5 | 1 | 10 | 28858 | 21 | ||||
| 154298 | 187666 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 107 Bernard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 2ft | 6008318.73536 | 2118064.92593 | 37.796271980829 | -122.415238929252 | (37.796271980829, -122.415238929252) | 5 | 1 | 10 | 28858 | 21 | ||||
| 156435 | 41760 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1320-1360 Lombard St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2000 12:00:00 AM | 3x3 | Permit Number 42186 | 6006041 | 2120044 | 37.8015777435459 | -122.423261128156 | (37.8015777435459, -122.423261128156) | 5 | 9 | 1 | 28858 | 32 | ||
| 162832 | 42678 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1097 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 8 | Permit Number 42702 | 6007821.24509 | 2118860.5405 | 37.7984285685682 | -122.417016754032 | (37.7984285685682, -122.417016754032) | 5 | 1 | 10 | 28858 | 21 | |
| 169726 | 41765 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1320-1360 Lombard St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2000 12:00:00 AM | 3x3 | Permit Number 42186 | 6006041 | 2120044 | 37.8015777435459 | -122.423261128156 | (37.8015777435459, -122.423261128156) | 5 | 9 | 1 | 28858 | 32 | ||
| 171137 | 41768 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1320-1360 Lombard St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2000 12:00:00 AM | 3x3 | Permit Number 42186 | 6006041 | 2120044 | 37.8015777435459 | -122.423261128156 | (37.8015777435459, -122.423261128156) | 5 | 9 | 1 | 28858 | 32 | ||
| 178825 | 42676 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1097 Green St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | 5 | Permit Number 42702 | 6007858.06857 | 2118865.16486 | 37.7984433372469 | -122.416889660934 | (37.7984433372469, -122.416889660934) | 5 | 1 | 10 | 28858 | 21 | ||
| 180058 | 98670 | Undocumented 4 | Rhamnus alaternus :: Italian Buckthorn 29 | 1898@green Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007784.7 | 2118870.1 | 37.7984527607502 | -122.417143889347 | (37.7984527607502, -122.417143889347) | 5 | 1 | 10 | 28858 | 21 | ||||
| 2771 | 240393 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 35 Hill St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 3ft | 6006109.51353 | 2103440.58038 | 37.7559926584484 | -122.421843980221 | (37.7559926584484, -122.421843980221) | 2 | 4 | 5 | 28859 | 19 | |||
| 5160 | 240388 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 65 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008348.72479 | 2098315.88712 | 37.7420474227613 | -122.413737549756 | (37.7420474227613, -122.413737549756) | 2 | 7 | 7 | 28859 | 2 | |||
| 13916 | 240385 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 310 Gates St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008245.55924 | 2097104.87481 | 37.7387164553078 | -122.41400861353 | (37.7387164553078, -122.41400861353) | 2 | 7 | 7 | 28859 | 2 | |||
| 20853 | 33056 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 328 San Jose Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37328 | 6006171.76331287 | 2101198.94449976 | 37.7498411527935 | -122.421469507825 | (37.7498411527935, -122.421469507825) | 2 | 4 | 5 | 28859 | 19 | |||
| 22308 | 33551 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 242 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37659 | 6007042.9412775 | 2097614.40669633 | 37.7400478987016 | -122.418202822848 | (37.7400478987016, -122.418202822848) | 2 | 7 | 7 | 28859 | 2 | |||
| 25866 | 32518 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 842 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/23/2007 12:00:00 AM | 9 | Permit Number 49664 | 6007548.7449 | 2095423.3131 | 37.7340600948986 | -122.41629880637 | (37.7340600948986, -122.41629880637) | 2 | 7 | 7 | 28859 | 2 | |
| 30225 | 33058 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 328 San Jose Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/2016 12:00:00 AM | 3 | Permit Number 779143 | 6006171.76331287 | 2101198.94449976 | 37.7498411527935 | -122.421469507825 | (37.7498411527935, -122.421469507825) | 2 | 4 | 5 | 28859 | 19 | ||
| 31613 | 33057 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 328 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1996 12:00:00 AM | Permit Number 37328 | 6006171.76331287 | 2101198.94449976 | 37.7498411527935 | -122.421469507825 | (37.7498411527935, -122.421469507825) | 2 | 4 | 5 | 28859 | 19 | |||
| 39191 | 63013 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 51 Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767771 | 6007430.33105591 | 2097971.50142259 | 37.7410501993506 | -122.416888678035 | (37.7410501993506, -122.416888678035) | 2 | 7 | 7 | 28859 | 2 | |
| 42393 | 69511 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 457 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/24/1994 12:00:00 AM | Permit Number 33638 | 6008927.18415449 | 2096207.51304953 | 37.736290754505 | -122.411588483232 | (37.736290754505, -122.411588483232) | 10 | 7 | 7 | 28859 | 2 | ||
| 60116 | 102078 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 35 Highland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769728 | 6005184.6 | 2096720.6 | 37.7374889299957 | -122.424564647037 | (37.7374889299957, -122.424564647037) | 2 | 7 | 5 | 28859 | 2 |
| 62872 | 240373 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1373 Utah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6010904.97586 | 2101974.91384 | 37.7522375329589 | -122.405156394162 | (37.7522375329589, -122.405156394162) | 10 | 4 | 8 | 28859 | 19 | |||
| 68958 | 246759 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 70 Waltham St | 3 | Front Yard : Yard | Tree | Private 2 | 8 | 6009196.74806 | 2098886.80636 | 37.7436626276403 | -122.410845655606 | (37.7436626276403, -122.410845655606) | 2 | 7 | 7 | 28859 | 2 | ||||
| 77469 | 248239 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 298 Esmeralda Ave | 4 | Side Yard : Yard | Tree | Private 2 | 8 | 6006759.33465 | 2099019.31967 | 37.7438895076886 | -122.419283056374 | (37.7438895076886, -122.419283056374) | 2 | 7 | 7 | 28859 | 2 | ||||
| 78352 | 247984 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 497 Peralta Ave | 2 | Side Yard : Yard | Tree | Private 2 | 5 | 6009751.76686 | 2099644.86409 | 37.7457751935767 | -122.408980002136 | (37.7457751935767, -122.408980002136) | 2 | 7 | 7 | 28859 | 2 | ||||
| 80550 | 246767 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 70 Waltham St | 11 | Front Yard : Yard | Tree | Private 2 | 13 | 6009322.26711 | 2098890.11567 | 37.7436787515713 | -122.410411873024 | (37.7436787515713, -122.410411873024) | 2 | 7 | 7 | 28859 | 2 | ||||
| 82091 | 33453 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 343 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/1996 12:00:00 AM | Permit Number 37554 | 6006165.48085512 | 2098035.43238588 | 37.7411545114342 | -122.421266615711 | (37.7411545114342, -122.421266615711) | 2 | 7 | 7 | 28859 | 2 | |||
| 87772 | 32524 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 862 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | 4 | Permit Number 37026 | 6007537.57048 | 2095302.13495 | 37.7337267377908 | -122.416328859904 | (37.7337267377908, -122.416328859904) | 2 | 7 | 7 | 28859 | 2 | |
| 101615 | 240382 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 200 Kingston St | 14 | Front Yard : Yard | Tree | Private 2 | 2 | 6006224.51109 | 2098080.7337 | 37.7412822264814 | -122.4210657258 | (37.7412822264814, -122.4210657258) | 2 | 7 | 7 | 28859 | 2 | ||||
| 107538 | 240372 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 1373 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6010906.21016 | 2101953.93145 | 37.752179988937 | -122.405150648382 | (37.752179988937, -122.405150648382) | 10 | 4 | 8 | 28859 | 19 | |||
| 109648 | 240389 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 457 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008913.61949 | 2096192.37009 | 37.7362484143157 | -122.411634312476 | (37.7362484143157, -122.411634312476) | 10 | 7 | 7 | 28859 | 2 | |||
| 119197 | 240396 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 122 Highland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005552.30713 | 2096648.4643 | 37.7373116207359 | -122.423288182623 | (37.7373116207359, -122.423288182623) | 2 | 7 | 7 | 28859 | 2 | |||
| 120646 | 247983 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 497 Peralta Ave | 1 | Side Yard : Yard | Tree | Private 2 | 8 | 6009757.51939 | 2099637.18115 | 37.7457544201473 | -122.408959568646 | (37.7457544201473, -122.408959568646) | 2 | 7 | 7 | 28859 | 2 | ||||
| 121829 | 240390 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 48 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6005917.96775 | 2097681.76661 | 37.7401694674339 | -122.422097309358 | (37.7401694674339, -122.422097309358) | 2 | 7 | 7 | 28859 | 2 | |||
| 124357 | 240395 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 37 Highland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6005177.74113 | 2096695.28031 | 37.7374190204687 | -122.424586560832 | (37.7374190204687, -122.424586560832) | 2 | 7 | 5 | 28859 | 2 | |||
| 130231 | 32520 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 848 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | 6 | Permit Number 37022 | 6007545.9989 | 2095398.06709 | 37.7339906204551 | -122.416306512649 | (37.7339906204551, -122.416306512649) | 2 | 7 | 7 | 28859 | 2 | |
| 133264 | 88439 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 837 Moultrie St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2008 12:00:00 AM | 3x3 | Permit Number 51403 | 6007580 | 2095463 | 37.7341708239465 | -122.416193557304 | (37.7341708239465, -122.416193557304) | 2 | 7 | 7 | 28859 | 2 | |||
| 145068 | 32523 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 861 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | 8 | Permit Number 37025 | 6007568.6691 | 2095324.89508 | 37.7337909808565 | -122.416222953925 | (37.7337909808565, -122.416222953925) | 2 | 7 | 7 | 28859 | 2 | |
| 145642 | 246638 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3320 Harrison St | 9 | Front Yard : Yard | Tree | Private 2 | 20 | 6009023.34848 | 2099240.78509 | 37.7446248509555 | -122.411470234758 | (37.7446248509555, -122.411470234758) | 2 | 7 | 7 | 28859 | 2 | ||||
| 148567 | 42054 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 326 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42369 | 6006171.20759912 | 2101208.97418807 | 37.74986866069 | -122.42147214172 | (37.74986866069, -122.42147214172) | 2 | 4 | 5 | 28859 | 19 | ||
| 153910 | 240386 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 310 Gates St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008247.18934 | 2097121.53396 | 37.7387622892369 | -122.41400415559 | (37.7387622892369, -122.41400415559) | 2 | 7 | 7 | 28859 | 2 | |||
| 154849 | 240387 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 310 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008249.57192 | 2097137.15027 | 37.7388053020181 | -122.41399702216 | (37.7388053020181, -122.41399702216) | 2 | 7 | 7 | 28859 | 2 | |||
| 169312 | 50015 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1373@ 24th ST Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/12/2005 12:00:00 AM | Permit Number 46746 | 6010905.44286633 | 2101942.7131649 | 37.7521491430994 | -122.405152511945 | (37.7521491430994, -122.405152511945) | 10 | 4 | 8 | 28859 | 19 | ||
| 178791 | 240391 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 346 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006743.91028 | 2097051.28536 | 37.7384848564878 | -122.419196816782 | (37.7384848564878, -122.419196816782) | 2 | 7 | 7 | 28859 | 2 | |||
| 183989 | 51741 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 700 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2005 12:00:00 AM | Permit Number 48018 | 6007951.80914494 | 2095656.00646211 | 37.7347216770682 | -122.414921747465 | (37.7347216770682, -122.414921747465) | 2 | 7 | 7 | 28859 | 2 | |||
| 184366 | 32517 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 837 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | 5 | Permit Number 39421 | 6007583.92915 | 2095468.81341 | 37.7341870072318 | -122.41618038454 | (37.7341870072318, -122.41618038454) | 2 | 7 | 7 | 28859 | 2 | |
| 193221 | 246761 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 70 Waltham St | 5 | Front Yard : Yard | Tree | Private 2 | 16 | 6009235.42267 | 2098888.8268 | 37.7436703438078 | -122.410712070303 | (37.7436703438078, -122.410712070303) | 2 | 7 | 7 | 28859 | 2 | ||||
| 12169 | 70387 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 81 Lyell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6003118.96111 | 2094567.61018 | 37.7314604381496 | -122.431552867694 | (37.7314604381496, -122.431552867694) | 9 | 7 | 5 | 28861 | 25 | |||
| 13999 | 73403 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 81 Lyell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6003121.92331 | 2094558.5911 | 37.7314358416937 | -122.43154198317 | (37.7314358416937, -122.43154198317) | 9 | 7 | 5 | 28861 | 25 | |||
| 18659 | 68867 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 123 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/08/1994 12:00:00 AM | Permit Number 32831 | 5999260.75597787 | 2093758.61799029 | 37.7290196985316 | -122.444833238065 | (37.7290196985316, -122.444833238065) | 9 | 7 | 4 | 28861 | 40 | ||
| 28524 | 34910 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 234 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/23/1997 12:00:00 AM | Permit Number 38511 | 5994034.02525385 | 2087990.46611796 | 37.712882070912 | -122.462484089909 | (37.712882070912, -122.462484089909) | 9 | 8 | 6 | 28861 | 24 | |||
| 32542 | 214022 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 659 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5997050.53703 | 2094389.33231 | 37.7306251064676 | -122.452519591711 | (37.7306251064676, -122.452519591711) | 9 | 7 | 4 | 28861 | 40 | |||
| 35401 | 26068 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 282 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2003 12:00:00 AM | 3 | 2X3 | 5994051.2236 | 2088339.7969 | 37.7138422407476 | -122.46244996961 | (37.7138422407476, -122.46244996961) | 9 | 8 | 6 | 28861 | 24 | ||
| 39553 | 214034 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 218 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 1ft | 5998609.02608 | 2093807.55818 | 37.7291168615442 | -122.447089829625 | (37.7291168615442, -122.447089829625) | 9 | 7 | 4 | 28861 | 40 | |||
| 40932 | 179375 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 778 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6001912.74857 | 2089301.24621 | 37.7169317492882 | -122.435346396016 | (37.7169317492882, -122.435346396016) | 9 | 7 | 6 | 28861 | 5 | |||
| 45902 | 67518 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 342 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/08/1994 12:00:00 AM | Permit Number 31054 | 5997814.69503285 | 2093832.35785798 | 37.7291395391527 | -122.449837670115 | (37.7291395391527, -122.449837670115) | 9 | 7 | 4 | 28861 | 40 | ||
| 51794 | 214043 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 212 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5998768.52981 | 2093586.90837 | 37.7285201208974 | -122.446522546303 | (37.7285201208974, -122.446522546303) | 9 | 7 | 4 | 28861 | 40 | |||
| 51945 | 214035 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 142 Staples Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 5999120.59989 | 2093807.09624 | 37.7291448088802 | -122.445321250796 | (37.7291448088802, -122.445321250796) | 9 | 7 | 4 | 28861 | 40 | ||||
| 57321 | 179374 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 906 Madrid St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6001350.07755 | 2088911.8778 | 37.71583065984 | -122.437263408906 | (37.71583065984, -122.437263408906) | 9 | 7 | 6 | 28861 | 5 | |||
| 69805 | 179380 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 77 Santa Cruz Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 5993077.06779 | 2086425.74691 | 37.7085305695939 | -122.465678009642 | (37.7085305695939, -122.465678009642) | 9 | 8 | 6 | 28861 | 25 | |||
| 79723 | 35102 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 778 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767512 | 6001912.66160072 | 2089308.81779253 | 37.7169525342318 | -122.435347237927 | (37.7169525342318, -122.435347237927) | 9 | 7 | 6 | 28861 | 5 | |
| 79841 | 214044 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 119 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5999274.87025 | 2093768.22401 | 37.7290468799003 | -122.444785134325 | (37.7290468799003, -122.444785134325) | 9 | 7 | 4 | 28861 | 40 | |||
| 86576 | 48460 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 102 Pope St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2002 12:00:00 AM | 2 | Permit Number 45825 | 6000209.55112 | 2088191.07942 | 37.7137866078303 | -122.44115390124 | (37.7137866078303, -122.44115390124) | 9 | 7 | 6 | 28861 | 5 | ||
| 87337 | 95740 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 61 Ina Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767486 | 6004943.22126 | 2091523.89765 | 37.7232063048111 | -122.425029567755 | (37.7232063048111, -122.425029567755) | 9 | 7 | 6 | 28861 | 5 |
| 94833 | 214031 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 119 Gennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5997420.89454 | 2093944.4368 | 37.7294247417474 | -122.451207143595 | (37.7294247417474, -122.451207143595) | 9 | 7 | 4 | 28861 | 40 | |||
| 103770 | 170499 | Planning Code 138.1 required 2 | Rhamnus alaternus :: Italian Buckthorn 29 | 1178 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2018 12:00:00 AM | 3 | 4x4 | Permit Number 779173 | 6003338.82121 | 2094328.64534 | 37.7308167537817 | -122.430775723045 | (37.7308167537817, -122.430775723045) | 9 | 7 | 5 | 28861 | 25 | |
| 104389 | 214041 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 431 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5997281.47486 | 2093791.4004 | 37.7289965565343 | -122.451678093372 | (37.7289965565343, -122.451678093372) | 9 | 7 | 4 | 28861 | 40 | |||
| 104909 | 68820 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 215 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1993 12:00:00 AM | Permit Number 32768 | 5999394.70937931 | 2093830.63611547 | 37.7292250872173 | -122.444375326018 | (37.7292250872173, -122.444375326018) | 9 | 7 | 4 | 28861 | 40 | ||
| 106836 | 214033 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 342 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5997821.19553 | 2093821.69316 | 37.7291106283447 | -122.449814429211 | (37.7291106283447, -122.449814429211) | 9 | 7 | 4 | 28861 | 40 | |||
| 113786 | 26157 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 260 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/1997 12:00:00 AM | 3 | 3X3 | 5994051.6997 | 2088243.7899 | 37.713578655736 | -122.462441364614 | (37.713578655736, -122.462441364614) | 9 | 8 | 6 | 28861 | 24 | ||
| 126417 | 214042 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 22 Gennessee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 10ft | 5997465.40478 | 2093699.47232 | 37.7287546757844 | -122.451035610522 | (37.7287546757844, -122.451035610522) | 9 | 7 | 4 | 28861 | 40 | |||
| 136625 | 179377 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 11 Cross St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6000163.43149 | 2088211.60643 | 37.7138403432439 | -122.441314779179 | (37.7138403432439, -122.441314779179) | 9 | 7 | 6 | 28861 | 5 | |||
| 147840 | 170500 | Planning Code 138.1 required 2 | Rhamnus alaternus :: Italian Buckthorn 29 | 1178 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2018 12:00:00 AM | 3 | 4x4 | Permit Number 779173 | 6003320.2391 | 2094320.37512 | 37.7307929928046 | -122.430839374365 | (37.7307929928046, -122.430839374365) | 9 | 7 | 5 | 28861 | 25 | |
| 147916 | 179376 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 11 Cross St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000146.40913 | 2088205.43619 | 37.7138224314379 | -122.441373172128 | (37.7138224314379, -122.441373172128) | 9 | 7 | 6 | 28861 | 5 | |||
| 151409 | 51254 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 258 Maynard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50492 | 6005094.58295 | 2093781.11604 | 37.7294126791284 | -122.424666833417 | (37.7294126791284, -122.424666833417) | 9 | 7 | 6 | 28861 | 5 | |
| 151446 | 170486 | Planning Code 138.1 required 2 | Rhamnus alaternus :: Italian Buckthorn 29 | 121 Cayuga Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2018 12:00:00 AM | 3 | 4x4 | Permit Number 779173 | 6003308.3245 | 2094432.02915 | 37.7310988944888 | -122.430888530379 | (37.7310988944888, -122.430888530379) | 9 | 7 | 5 | 28861 | 25 | |
| 152137 | 95106 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 134 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2010 12:00:00 AM | 3x3 | Permit Number 54035 | 6003118.7 | 2094425.3 | 37.7310696718053 | -122.431543614497 | (37.7310696718053, -122.431543614497) | 9 | 7 | 5 | 28861 | 25 | |
| 152639 | 179381 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 211 Maynard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004791.22596 | 2093805.46064 | 37.7294623864734 | -122.425717300039 | (37.7294623864734, -122.425717300039) | 9 | 7 | 6 | 28861 | 5 | |||
| 160545 | 179373 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 670 Brunswick St | 17 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | 5998557.70629 | 2086647.36142 | 37.7094536787167 | -122.446752254708 | (37.7094536787167, -122.446752254708) | 9 | 7 | 6 | 28861 | 5 | ||||
| 167906 | 40701 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 547 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/1999 12:00:00 AM | Permit Number 41680 | 6005025.18813412 | 2093548.59411277 | 37.7287703058889 | -122.424890201858 | (37.7287703058889, -122.424890201858) | 9 | 7 | 6 | 28861 | 5 | ||
| 168305 | 214032 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 342 Staples Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5997805.13378 | 2093821.66004 | 37.729109618413 | -122.449869953332 | (37.729109618413, -122.449869953332) | 9 | 7 | 4 | 28861 | 40 | |||
| 169408 | 214045 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 115 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5999297.76132 | 2093768.33781 | 37.7290484986852 | -122.444706006572 | (37.7290484986852, -122.444706006572) | 9 | 7 | 4 | 28861 | 40 | |||
| 170178 | 214019 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 112 Dorado Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5994645.41712 | 2093146.00663 | 37.7270731423102 | -122.460744326189 | (37.7270731423102, -122.460744326189) | 9 | 8 | 4 | 28861 | 40 | |||
| 9617 | 240412 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 3420 Market St | 1 | : | Tree | DPW 1 | 04/19/1996 12:00:00 AM | 7 | Width 3ft | 6000095.05977 | 2103920.26324 | 37.7569687331323 | -122.442678332141 | (37.7569687331323, -122.442678332141) | 2 | 4 | 5 | 28862 | 3 | ||
| 20719 | 32859 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 499 Hoffman Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/30/1996 12:00:00 AM | Permit Number 37207 | 6000703.6978076 | 2101134.48618072 | 37.7493543400616 | -122.440373654783 | (37.7493543400616, -122.440373654783) | 2 | 4 | 5 | 28862 | 22 | |||
| 29422 | 41661 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1376 Clayton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | 2 | Permit Number 42129 | 5999046.52257313 | 2104716.21389633 | 37.7590943881005 | -122.44636181287 | (37.7590943881005, -122.44636181287) | 15 | 5 | 5 | 28862 | 3 | |
| 33342 | 41874 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 66 Belcher St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42253 | 6003778.26782897 | 2107952.91484982 | 37.7682507021815 | -122.430228105724 | (37.7682507021815, -122.430228105724) | 7 | 9 | 5 | 28862 | 3 | ||
| 40883 | 240415 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 751 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6003800.46059 | 2107711.4253 | 37.7675888874331 | -122.430134113409 | (37.7675888874331, -122.430134113409) | 7 | 9 | 5 | 28862 | 3 | |||
| 46117 | 41663 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1376 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42129 | 5999046.52257313 | 2104716.21389633 | 37.7590943881005 | -122.44636181287 | (37.7590943881005, -122.44636181287) | 15 | 5 | 5 | 28862 | 3 | ||
| 49617 | 39731 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 3472 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1999 12:00:00 AM | Permit Number 41103 | 6003734.27078033 | 2106581.04610194 | 37.7644813903829 | -122.430282399811 | (37.7644813903829, -122.430282399811) | 8 | 4 | 5 | 28862 | 3 | ||
| 61307 | 34 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 759 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003742.09963 | 2107707.87999 | 37.7675758472752 | -122.430335723414 | (37.7675758472752, -122.430335723414) | 7 | 9 | 5 | 28862 | 3 | |||
| 67315 | 240401 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 499 Hoffman Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6000694.66286 | 2101176.32982 | 37.749468718214 | -122.440407898332 | (37.749468718214, -122.440407898332) | 2 | 4 | 5 | 28862 | 22 | |||
| 67971 | 41662 | Permitted Site 7 | Rhamnus alaternus :: Italian Buckthorn 29 | 1376 Clayton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | Permit Number 42129 | 5999046.52257313 | 2104716.21389633 | 37.7590943881005 | -122.44636181287 | (37.7590943881005, -122.44636181287) | 15 | 5 | 5 | 28862 | 3 | ||
| 88325 | 32 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 753 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/08/2016 06:10:00 AM | 3 | 3X3 | 6003820.62164 | 2107707.01694 | 37.7675779249973 | -122.43006406444 | (37.7675779249973, -122.43006406444) | 7 | 9 | 5 | 28862 | 3 | ||
| 109413 | 31 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 753 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/08/2016 06:04:00 AM | 3 | 3X3 | 6003785.60824 | 2107710.67637 | 37.7675859898405 | -122.430185432325 | (37.7675859898405, -122.430185432325) | 7 | 9 | 5 | 28862 | 3 |
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) );