trees
861 rows where qSpecies_id = 18 sorted by qCareAssistant 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 30 | 254372 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 62 Tioga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/2020 12:00:00 AM | 3 | 3x3 | Permit Number 778036 | 6010859.22958 | 2088882.34048 | 37.7162855403434 | -122.404393121162 | (37.7162855403434, -122.404393121162) | 9 | 7 | 8 | 309 | 39 |
| 629 | 259747 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1674 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 6014811.75538 | 2097073.30447 | 37.7389963714409 | -122.391303417459 | (37.7389963714409, -122.391303417459) | 10 | 3 | 8 | 58 | 1 | ||
| 1422 | 259801 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1180x Brussels St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 2930 | 31151 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 666 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/04/2019 02:39:00 PM | 3 | Permit Number 34854 | 5997015.55395 | 2094425.74026 | 37.7307230695921 | -122.452643159453 | (37.7307230695921, -122.452643159453) | 9 | 7 | 4 | 59 | 40 | |
| 3046 | 258383 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 101 University St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6007919.90114 | 2093441.26607 | 37.7286386864609 | -122.414875367562 | (37.7286386864609, -122.414875367562) | 9 | 3 | 7 | 309 | 28 | |||
| 3342 | 258384 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 101 University St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6007919.90114 | 2093441.26607 | 37.7286386864609 | -122.414875367562 | (37.7286386864609, -122.414875367562) | 9 | 3 | 7 | 309 | 28 | |||
| 3361 | 261454 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
| 3379 | 258367 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 901 Silliman St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | ||||||||||||||
| 3785 | 258385 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 101 University St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6007919.90114 | 2093441.26607 | 37.7286386864609 | -122.414875367562 | (37.7286386864609, -122.414875367562) | 9 | 3 | 7 | 309 | 28 | ||||
| 4492 | 260884 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 195 26th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5987712.04911 | 2114688.49303 | 37.7858216131413 | -122.486293421393 | (37.7858216131413, -122.486293421393) | 11 | 6 | 1 | 55 | 33 | |||
| 4788 | 71255 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1392 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6007494.44606 | 2117816.87319 | 37.7955445300156 | -122.418073553678 | (37.7955445300156, -122.418073553678) | 5 | 1 | 10 | 28858 | 32 | |||
| 5176 | 260916 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1726 Page St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 5998303.71415 | 2108967.89528 | 37.7707259785013 | -122.449237098474 | (37.7707259785013, -122.449237098474) | 15 | 5 | 11 | 29492 | 9 | |||
| 6189 | 260917 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1740 Page St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/21/2019 12:00:00 AM | 3 | 5998239.87383 | 2108958.8784 | 37.7706975687071 | -122.44945727244 | (37.7706975687071, -122.44945727244) | 15 | 5 | 11 | 29492 | 9 | |||
| 8479 | 204048 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
| 8854 | 75284 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1335 Griffith St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6017835.3471 | 2092484.583 | 37.7265639860027 | -122.380530259866 | (37.7265639860027, -122.380530259866) | 10 | 3 | 8 | 58 | 1 | |||
| 8858 | 261455 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
| 9474 | 35363 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1000 Rhode Island St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 5 | Permit Number 38825 | 6011873.19867 | 2103659.86628 | 37.7569181237816 | -122.401926543791 | (37.7569181237816, -122.401926543791) | 10 | 3 | 8 | 28856 | 29 | |
| 10747 | 260852 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 629 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/13/2020 12:00:00 AM | 3 | 5985649.89934 | 2111597.68044 | 37.7772147235644 | -122.493199999111 | (37.7772147235644, -122.493199999111) | 11 | 6 | 2 | 55 | 26 | |||
| 11157 | 261456 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
| 11502 | 259802 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1180x Brussels St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 11866 | 171812 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 825 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 0 | 4x5 | 6008354.35996 | 2093563.17483 | 37.7289978245749 | -122.413382030664 | (37.7289978245749, -122.413382030664) | 9 | 3 | 7 | 309 | 28 | ||
| 15121 | 261452 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
| 15176 | 31150 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 666 Hearst Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/04/2019 02:41:00 PM | 3 | Permit Number 34854 | 5996999.96036 | 2094426.52258 | 37.7307243241567 | -122.452697125077 | (37.7307243241567, -122.452697125077) | 9 | 7 | 4 | 59 | 40 | |
| 15415 | 261457 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
| 16566 | 261453 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
| 16722 | 258368 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 910 Silliman St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6008141.55513 | 2093544.59332 | 37.7289348532082 | -122.414116401333 | (37.7289348532082, -122.414116401333) | 9 | 3 | 7 | 309 | 28 | ||||
| 16942 | 171730 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 101 University St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 0 | 4x5 | 6007892.79548 | 2093379.38085 | 37.7284672398478 | -122.414964695362 | (37.7284672398478, -122.414964695362) | 9 | 3 | 7 | 309 | 5 | ||
| 17942 | 258365 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 811 Silliman St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6008440.06545 | 2093594.26657 | 37.7290880075188 | -122.413087936875 | (37.7290880075188, -122.413087936875) | 9 | 3 | 7 | 309 | 28 | ||||
| 18349 | 171813 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 100 Dartmouth St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | Width 3ft | 6008462.06709 | 2093570.22923 | 37.7290232412306 | -122.413010176287 | (37.7290232412306, -122.413010176287) | 9 | 3 | 7 | 309 | 28 | ||
| 18615 | 259800 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1180x Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 20425 | 44213 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1601 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/11/2006 12:00:00 AM | Permit Number 43660 | 5993363.56248215 | 2104576.56937915 | 37.7583847466967 | -122.466005883185 | (37.7583847466967, -122.466005883185) | 1 | 8 | 4 | 56 | 12 | ||
| 23268 | 36880 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2515 Fillmore St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/04/2015 12:00:00 AM | 2 | 3x3 | Permit Number 776215 | 6002666.11082 | 2116940.62149 | 37.7928656304089 | -122.434717718651 | (37.7928656304089, -122.434717718651) | 13 | 9 | 1 | 29490 | 27 |
| 25393 | 31771 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2000 Ulloa St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.7411604150808 | -122.477740406961 | (37.7411604150808, -122.477740406961) | 1 | 8 | 3 | 29491 | 35 | ||
| 25613 | 37524 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1154 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779577 | 6007313.66795 | 2115327.60271 | 37.7886994328701 | -122.418522478123 | (37.7886994328701, -122.418522478123) | 13 | 9 | 10 | 28858 | 21 |
| 26449 | 37034 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 266 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/2005 12:00:00 AM | Permit Number 48449 | 6004870.65820445 | 2098448.14678483 | 37.7422146471398 | -122.425773019549 | (37.7422146471398, -122.425773019549) | 2 | 7 | 5 | 63 | 22 | ||
| 31268 | 30586 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 800 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1995 12:00:00 AM | 8 | Permit Number 34556 | 6002690.739 | 2109580.279 | 37.7726573855875 | -122.43410610481 | (37.7726573855875, -122.43410610481) | 15 | 5 | 11 | 29492 | 9 | |
| 31466 | 45705 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2919 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/2002 12:00:00 AM | Permit Number 44379 | 6009358.73784624 | 2102738.93586586 | 37.754248802934 | -122.410557495705 | (37.754248802934, -122.410557495705) | 2 | 4 | 7 | 28859 | 19 | ||
| 40637 | 31733 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2495 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 3 | 3x3 | Permit Number 35227 | 5990132.7438 | 2098427.0161 | 37.7413127725673 | -122.476730077237 | (37.7413127725673, -122.476730077237) | 1 | 8 | 3 | 29491 | 35 |
| 42904 | 31734 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1900x ULLOA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35227 | 5990005 | 2098357 | 37.7411131158778 | -122.477166650257 | (37.7411131158778, -122.477166650257) | 1 | 8 | 3 | 29491 | 35 | ||
| 44408 | 37644 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2732 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | 2 | Permit Number 40059 | 5990120.46053 | 2111993.16181 | 37.7785610650821 | -122.477763984945 | (37.7785610650821, -122.477763984945) | 11 | 6 | 2 | 55 | 26 | |
| 44928 | 38574 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1507 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/2012 12:00:00 AM | 1 | Permit Number 769237 | 6015357.8476 | 2094862.6046 | 37.7329565309935 | -122.389260937031 | (37.7329565309935, -122.389260937031) | 10 | 3 | 8 | 58 | 1 | |
| 48165 | 50231 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1255 29th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/2003 12:00:00 AM | 8 | Permit Number 46939 | 5987056.8298 | 2106727.188 | 37.7639239004312 | -122.487975087347 | (37.7639239004312, -122.487975087347) | 1 | 8 | 3 | 56 | 35 | |
| 49256 | 37224 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1340 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | 5 | Permit Number 39788 | 5985571.0917 | 2106094.9849 | 37.7621012650414 | -122.493067162611 | (37.7621012650414, -122.493067162611) | 1 | 8 | 3 | 56 | 35 | |
| 50574 | 43807 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 530 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | 3 | Permit Number 43437 | 5988458.678 | 2112363.29745 | 37.7794807721264 | -122.483539798259 | (37.7794807721264, -122.483539798259) | 11 | 6 | 2 | 55 | 26 | |
| 50974 | 36881 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2515 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 11/23/2016 12:00:00 AM | 3 | Permit Number 779178 | 6002658.18112 | 2116991.83839 | 37.7930058086339 | -122.434748819925 | (37.7930058086339, -122.434748819925) | 13 | 9 | 1 | 29490 | 27 | |
| 52831 | 30703 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 361 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 2 | Permit Number 34614 | 6005258.9715 | 2110239.8029 | 37.7746137012839 | -122.425269246 | (37.7746137012839, -122.425269246) | 7 | 9 | 11 | 28852 | 10 | |
| 56833 | 38678 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1377 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/02/1998 12:00:00 AM | Permit Number 40596 | 6001182.75800309 | 2111056.33200795 | 37.7766245566345 | -122.439428187036 | (37.7766245566345, -122.439428187036) | 15 | 5 | 11 | 29492 | 10 | ||
| 58845 | 46819 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 366 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/25/2002 12:00:00 AM | 10 | Permit Number 44897 | 6004049.02082 | 2091179.47735 | 37.7222100502291 | -122.428096112963 | (37.7222100502291, -122.428096112963) | 9 | 7 | 6 | 28861 | 5 | |
| 59713 | 35365 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1000 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 7 | Permit Number 38825 | 6011873.18705 | 2103679.58539 | 37.7569722674636 | -122.401927970125 | (37.7569722674636, -122.401927970125) | 10 | 3 | 8 | 28856 | 29 | |
| 60328 | 37630 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 546 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | 4 | Permit Number 40048 | 5990347.69452 | 2111641.30179 | 37.777608139525 | -122.476952187306 | (37.777608139525, -122.476952187306) | 11 | 6 | 2 | 55 | 26 | |
| 60579 | 79264 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 180 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5989943.75827 | 2114181.74363 | 37.7845600440954 | -122.478535346694 | (37.7845600440954, -122.478535346694) | 11 | 6 | 2 | 55 | 26 | |||
| 60743 | 37092 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1422 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/01/1998 12:00:00 AM | 0 | Permit Number 39692 | 5981562.80857566 | 2105390.4854708 | 37.7599316756927 | -122.506877772277 | (37.7599316756927, -122.506877772277) | 1 | 8 | 3 | 56 | 35 | |
| 62109 | 39858 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 514 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | 5 | Permit Number 41164 | 5992538.39814 | 2111929.42262 | 37.7785260826754 | -122.469394849438 | (37.7785260826754, -122.469394849438) | 11 | 6 | 2 | 54 | 11 | |
| 62609 | 52479 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 119POWHATTAN Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48589 | 6009084.88956475 | 2097947.60140706 | 37.7410775038925 | -122.411166106845 | (37.7410775038925, -122.411166106845) | 10 | 7 | 7 | 28859 | 2 | ||
| 62659 | 31774 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2000 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 0 | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.7411604150808 | -122.477740406961 | (37.7411604150808, -122.477740406961) | 1 | 8 | 3 | 29491 | 35 | |
| 64446 | 35364 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1000 Rhode Island St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 7 | Permit Number 38825 | 6011875.91601 | 2103641.32434 | 37.7568673633546 | -122.401915842767 | (37.7568673633546, -122.401915842767) | 10 | 3 | 8 | 28856 | 29 | |
| 70900 | 30508 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 363 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/06/1998 12:00:00 AM | Permit Number 40123 | 6009708.62861324 | 2092740.2698514 | 37.7268142455477 | -122.408642172932 | (37.7268142455477, -122.408642172932) | 10 | 3 | 7 | 309 | 28 | ||
| 83215 | 32892 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1235 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/01/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778801 | 5993897.25914467 | 2107077.09548698 | 37.7652813146396 | -122.464341682773 | (37.7652813146396, -122.464341682773) | 11 | 5 | 11 | 56 | 12 |
| 84169 | 42428 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 769 Joost Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42578 | 5997011.02141138 | 2094977.36766372 | 37.7322374467316 | -122.452698626411 | (37.7322374467316, -122.452698626411) | 9 | 7 | 4 | 59 | 40 | ||
| 87832 | 176961 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 41 Teddy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781344 | 6011207.15899 | 2087778.71194 | 37.7132746363936 | -122.403112916852 | (37.7132746363936, -122.403112916852) | 9 | 7 | 8 | 309 | 39 |
| 90924 | 31792 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 111 Buena Vista East Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35262 | 6001241.81019665 | 2108627.72464151 | 37.7699595699392 | -122.439049813001 | (37.7699595699392, -122.439049813001) | 15 | 5 | 5 | 29492 | 9 | ||
| 97739 | 31728 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2460 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767614 | 5990177.7474 | 2098625.5077 | 37.7418603894955 | -122.476588969759 | (37.7418603894955, -122.476588969759) | 1 | 8 | 3 | 29491 | 35 |
| 98941 | 34270 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 114 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38072 | 5987122.50109111 | 2115231.37554308 | 37.7872778329962 | -122.488372976967 | (37.7872778329962, -122.488372976967) | 11 | 6 | 1 | 55 | 33 | ||
| 102523 | 31731 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1900x ULLOA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35227 | 5990005 | 2098357 | 37.7411131158778 | -122.477166650257 | (37.7411131158778, -122.477166650257) | 1 | 8 | 3 | 29491 | 35 | ||
| 102588 | 36883 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2515 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 11/23/2016 12:00:00 AM | 3 | Permit Number 779178 | 6002662.87522 | 2116961.24208 | 37.7929220655455 | -122.434730389195 | (37.7929220655455, -122.434730389195) | 13 | 9 | 1 | 29490 | 27 | |
| 104978 | 48988 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 134 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/2002 12:00:00 AM | Permit Number 46175 | 6005014.67029629 | 2099626.41666977 | 37.7454580443014 | -122.4253588996 | (37.7454580443014, -122.4253588996) | 2 | 7 | 5 | 63 | 22 | ||
| 105235 | 37645 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2732 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | 2 | Permit Number 40059 | 5990141.86983 | 2111994.48348 | 37.7785659364855 | -122.477690019436 | (37.7785659364855, -122.477690019436) | 11 | 6 | 2 | 55 | 26 | |
| 105451 | 31795 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 141 Buena Vista East Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35265 | 6001336.75578377 | 2108526.84088843 | 37.7696879701055 | -122.438714168685 | (37.7696879701055, -122.438714168685) | 15 | 5 | 5 | 29492 | 9 | ||
| 106589 | 65445 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 922 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1989 12:00:00 AM | Permit Number 28319 | 6007730.56095344 | 2114797.09154755 | 37.7872662397984 | -122.417042480837 | (37.7872662397984, -122.417042480837) | 13 | 1 | 10 | 28858 | 21 | ||
| 106718 | 31776 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2000 Ulloa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.7411604150808 | -122.477740406961 | (37.7411604150808, -122.477740406961) | 1 | 8 | 3 | 29491 | 35 | ||
| 109190 | 34272 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 118 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38073 | 5987121.09736721 | 2115203.94287654 | 37.7872024288867 | -122.488375816661 | (37.7872024288867, -122.488375816661) | 11 | 6 | 1 | 55 | 33 | ||
| 114745 | 31727 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2460 20th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767614 | 5990175.918 | 2098661.7302 | 37.7419597410001 | -122.476597940821 | (37.7419597410001, -122.476597940821) | 1 | 8 | 3 | 29491 | 35 |
| 118708 | 34269 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 114 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38072 | 5987122.50109111 | 2115231.37554308 | 37.7872778329962 | -122.488372976967 | (37.7872778329962, -122.488372976967) | 11 | 6 | 1 | 55 | 33 | ||
| 121397 | 31773 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2000 Ulloa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.7411604150808 | -122.477740406961 | (37.7411604150808, -122.477740406961) | 1 | 8 | 3 | 29491 | 35 | ||
| 121828 | 36882 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2515 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/04/2015 12:00:00 AM | 2 | Permit Number 776215 | 6002659.25886 | 2116979.55031 | 37.7929721299187 | -122.434744211776 | (37.7929721299187, -122.434744211776) | 13 | 9 | 1 | 29490 | 27 | |
| 126639 | 51275 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 744 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/18/2004 12:00:00 AM | 3 | Permit Number 47650 | 5990394.326 | 2110291.56377 | 37.7739048349937 | -122.476692239116 | (37.7739048349937, -122.476692239116) | 11 | 6 | 2 | 55 | 26 | |
| 127314 | 34595 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 224 Presidio Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | 3 | Permit Number 38290 | 5999049.11331 | 2115811.89276 | 37.7895604321171 | -122.447151385541 | (37.7895604321171, -122.447151385541) | 13 | 6 | 1 | 29490 | 31 | |
| 133271 | 62984 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1235 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1994 12:00:00 AM | 7 | Permit Number 33034 | 5984571.8482 | 2106766.3839 | 37.7638862475145 | -122.496572656852 | (37.7638862475145, -122.496572656852) | 1 | 8 | 3 | 56 | 35 | |
| 140002 | 45704 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2923 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/2002 12:00:00 AM | Permit Number 44378 | 6009338.32453862 | 2102737.8165792 | 37.7542445851646 | -122.410628011277 | (37.7542445851646, -122.410628011277) | 2 | 4 | 7 | 28859 | 19 | ||
| 141908 | 50485 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 118 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/2003 12:00:00 AM | Permit Number 47121 | 5996542.39678919 | 2090678.14826944 | 37.7204059497171 | -122.454008375647 | (37.7204059497171, -122.454008375647) | 9 | 8 | 6 | 28861 | 24 | ||
| 150513 | 37577 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 144 Danvers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1998 12:00:00 AM | Permit Number 40010 | 5999933.60679892 | 2105019.65180732 | 37.759978178597 | -122.443315658152 | (37.759978178597, -122.443315658152) | 2 | 4 | 5 | 28862 | 3 | ||
| 153284 | 30569 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 248 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1995 12:00:00 AM | Permit Number 34546 | 6003788.00361454 | 2109234.47759535 | 37.771770112694 | -122.430285874486 | (37.771770112694, -122.430285874486) | 7 | 9 | 11 | 29492 | 10 | ||
| 163187 | 38679 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1377 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/02/1998 12:00:00 AM | Permit Number 40596 | 6001182.75800309 | 2111056.33200795 | 37.7766245566345 | -122.439428187036 | (37.7766245566345, -122.439428187036) | 15 | 5 | 11 | 29492 | 10 | ||
| 164798 | 37466 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 115 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1998 12:00:00 AM | Permit Number 39937 | 6009086.92753477 | 2097969.49395992 | 37.7411377303504 | -122.411160606325 | (37.7411377303504, -122.411160606325) | 10 | 7 | 7 | 28859 | 2 | ||
| 165903 | 31772 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2000 Ulloa St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.7411604150808 | -122.477740406961 | (37.7411604150808, -122.477740406961) | 1 | 8 | 3 | 29491 | 35 | ||
| 166939 | 35235 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1077 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 6 | Permit Number 38732 | 6007771.26508 | 2119552.1201 | 37.8003246614186 | -122.417238733675 | (37.8003246614186, -122.417238733675) | 5 | 1 | 1 | 308 | 32 | |
| 167903 | 35838 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 524 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1998 12:00:00 AM | 6 | Permit Number 39065 | 6001524.77874 | 2090714.46307 | 37.7207900854698 | -122.436788524592 | (37.7207900854698, -122.436788524592) | 9 | 7 | 6 | 28861 | 5 | |
| 170331 | 36895 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 4118 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/27/1998 12:00:00 AM | Permit Number 39548 | 6001738.91463484 | 2103541.42716619 | 37.7560221127265 | -122.436966152078 | (37.7560221127265, -122.436966152078) | 2 | 4 | 5 | 28862 | 3 | ||
| 170885 | 109806 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1264 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775061 | 5992117.2 | 2106823.9 | 37.764483341532 | -122.470479988054 | (37.764483341532, -122.470479988054) | 11 | 8 | 11 | 56 | 12 |
| 177495 | 42710 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1600 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/15/2010 12:00:00 AM | 10 | 3x3 | Permit Number 53744 | 6005271.11771 | 2118900.89126 | 37.7983955805457 | -122.42584385893 | (37.7983955805457, -122.42584385893) | 13 | 9 | 1 | 57 | 17 |
| 180161 | 34271 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 118 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38073 | 5987121.09736721 | 2115203.94287654 | 37.7872024288867 | -122.488375816661 | (37.7872024288867, -122.488375816661) | 11 | 6 | 1 | 55 | 33 | ||
| 181301 | 108995 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 55 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772985 | 5993924.20809 | 2115202.12337 | 37.7875920194037 | -122.464838574554 | (37.7875920194037, -122.464838574554) | 11 | 6 | 1 | 54 | 11 |
| 187695 | 49756 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1171 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 1 | Permit Number 46552 | 6011373.3818 | 2089351.75942 | 37.7176031885257 | -122.402648943989 | (37.7176031885257, -122.402648943989) | 10 | 7 | 8 | 309 | 39 | |
| 194237 | 31775 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2000 Ulloa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | Permit Number 35250 | 5989839.49734774 | 2098377.72398218 | 37.7411604150808 | -122.477740406961 | (37.7411604150808, -122.477740406961) | 1 | 8 | 3 | 29491 | 35 | ||
| 330 | 250773 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 259 32nd Ave | 1 | : | Tree | Private 2 | 14 | Width 3ft | 5985865.92055 | 2114194.89594 | 37.7843585636424 | -122.492644052605 | (37.7843585636424, -122.492644052605) | 11 | 6 | 1 | 55 | 33 | |||
| 697 | 19206 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 630 Sansome St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6012230.08543 | 2117977.14861 | 37.7962500076802 | -122.401698594427 | (37.7962500076802, -122.401698594427) | 3 | 1 | 10 | 28860 | 4 | |||
| 943 | 103518 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 5234 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770228 | 5999957.27012 | 2088737.63684 | 37.7152729578673 | -122.442065082634 | (37.7152729578673, -122.442065082634) | 9 | 7 | 6 | 28861 | 25 | |
| 1319 | 227653 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 3750 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003384.06107 | 2103624.93542 | 37.7563447763019 | -122.431282651989 | (37.7563447763019, -122.431282651989) | 2 | 4 | 5 | 28862 | 3 | |||
| 2229 | 227630 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 10 Arbor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6002176.82031 | 2096986.40745 | 37.7380484541639 | -122.43498294672 | (37.7380484541639, -122.43498294672) | 2 | 7 | 5 | 63 | 7 | |||
| 2463 | 227603 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1201 San Jose Ave | 55 | Front Yard : Yard | Tree | Private 2 | 2 | 6004504.07862 | 2096101.18791 | 37.7357497087738 | -122.42687342979 | (37.7357497087738, -122.42687342979) | 2 | 7 | 5 | 28861 | 2 |
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) );