trees
861 rows where qSpecies_id = 18 sorted by PlotSize
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||||
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 | ||||
2588 | 101345 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 600 Chestnut St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | 22 | Permit Number 32655 | 6008773.8267 | 2120774.1665 | 37.8037364477628 | -122.413855954453 | (37.8037364477628, -122.413855954453) | 3 | 1 | 10 | 308 | 23 | ||
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 | |
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 | |||
4504 | 48452 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 740 Euclid Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2002 12:00:00 AM | 4 | Permit Number 45822 | 5996026.36682 | 2113840.43033 | 37.7839741521628 | -122.457467011011 | (37.7839741521628, -122.457467011011) | 11 | 6 | 1 | 54 | 31 | ||
4785 | 16923 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 503 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 6004556.4237 | 2110140.1804 | 37.7743004469023 | -122.427692399322 | (37.7743004469023, -122.427692399322) | 7 | 9 | 11 | 28852 | 10 | ||||
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 | |||
7878 | 259091 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1298 Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
8667 | 54838 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 215 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1972 12:00:00 AM | 6 | Permit Number 10692 | 5998766.6122 | 2109946.2443 | 37.7734387411862 | -122.447706373612 | (37.7734387411862, -122.447706373612) | 15 | 5 | 11 | 29492 | 16 | ||
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 | |||
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 | |||
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 | ||||||||||||
12600 | 31769 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1850 Ulloa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | 3 | Permit Number 35249 | 5990271.0654 | 2098396.6732 | 37.7412374811669 | -122.476249599037 | (37.7412374811669, -122.476249599037) | 1 | 8 | 3 | 29491 | 35 | ||
13366 | 259090 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1298 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
14717 | 259092 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1298 Visitacion Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
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 | |
18434 | 105315 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2101 Laguna St | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 770797 | 6004250.84301 | 2116191.67517 | 37.7908990545176 | -122.429181041856 | (37.7908990545176, -122.429181041856) | 13 | 9 | 1 | 28858 | 27 | |||||
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 | ||
20511 | 48733 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1235 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2002 12:00:00 AM | 2 | Permit Number 46013 | 5986739.234 | 2106838.4777 | 37.7642109391741 | -122.489081723593 | (37.7642109391741, -122.489081723593) | 1 | 8 | 3 | 56 | 35 | ||
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 | ||
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 | ||
27188 | 227606 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1201 San Jose Ave | 60 | Front Yard : Yard | Tree | Private 2 | 3 | 6004509.90475 | 2096122.13365 | 37.7358075504724 | -122.426854777822 | (37.7358075504724, -122.426854777822) | 2 | 7 | 5 | 28861 | 2 | ||||
27516 | 97113 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1345 Noriega St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Permit Number 18860 | 5989785.9448 | 2103084.5073 | 37.7540808992005 | -122.478269637351 | (37.7540808992005, -122.478269637351) | 1 | 8 | 3 | 56 | 35 | |||
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 | ||
35814 | 51087 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2031REVISED Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2004 12:00:00 AM | 8 | Permit Number 47544 | 6006859.53299 | 2118230.7659 | 37.7966452201661 | -122.420299857748 | (37.7966452201661, -122.420299857748) | 13 | 9 | 10 | 28858 | 32 | ||
37272 | 31363 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2295 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1995 12:00:00 AM | 2 | Permit Number 34969 | 5991013.00778 | 2099881.4668 | 37.7453573397732 | -122.473792544798 | (37.7453573397732, -122.473792544798) | 1 | 8 | 4 | 29491 | 40 | ||
37373 | 48451 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 740 Euclid Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2002 12:00:00 AM | 4 | Permit Number 45822 | 5995956.24653 | 2113838.6701 | 37.7839652911282 | -122.457709472605 | (37.7839652911282, -122.457709472605) | 11 | 6 | 1 | 54 | 31 | ||
38362 | 35009 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1652 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/1997 12:00:00 AM | 4 | Permit Number 38581 | 5999618.3524 | 2114616.3026 | 37.7863101621151 | -122.445095896882 | (37.7863101621151, -122.445095896882) | 15 | 6 | 1 | 29490 | 31 | ||
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 | |
44640 | 46211 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2244 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/2003 12:00:00 AM | 3 | Permit Number 46882 | 6003263.56021 | 2116449.57494 | 37.7915512424562 | -122.432615424763 | (37.7915512424562, -122.432615424763) | 13 | 9 | 1 | 29490 | 27 | ||
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 | |
47953 | 105316 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2101 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 770797 | 6004250.84301 | 2116191.67517 | 37.7908990545176 | -122.429181041856 | (37.7908990545176, -122.429181041856) | 13 | 9 | 1 | 28858 | 27 | ||||
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 | |
50767 | 227610 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 400 Prospect Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | 6006250.04952 | 2097648.94567 | 37.7400980729811 | -122.420946773391 | (37.7400980729811, -122.420946773391) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | ||
56859 | 227608 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1201 San Jose Ave | 73 | Front Yard : Yard | Tree | Private 2 | 3 | 6004572.06439 | 2096162.43718 | 37.7359217292935 | -122.426642736581 | (37.7359217292935, -122.426642736581) | 2 | 7 | 5 | 28861 | 2 | ||||
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 | |
58966 | 31768 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1850 Ulloa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | 3 | Permit Number 35249 | 5990284.9407 | 2098399.3806 | 37.7412457196189 | -122.47620182139 | (37.7412457196189, -122.47620182139) | 1 | 8 | 3 | 29491 | 35 | ||
59466 | 32295 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1616 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/1996 12:00:00 AM | 5 | Permit Number 36875 | 6011596.3586 | 2107020.1725 | 37.7661293203346 | -122.403120325202 | (37.7661293203346, -122.403120325202) | 8 | 3 | 8 | 28853 | 20 | ||
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 | |
62145 | 32357 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 716 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/1996 12:00:00 AM | 3 | Permit Number 36911 | 6011755.33078 | 2117880.08122 | 37.7959569797808 | -122.40333452059 | (37.7959569797808, -122.40333452059) | 3 | 1 | 10 | 28860 | 4 | ||
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 | |
63090 | 31965 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1000 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 35367 | 6008195.50256 | 2118963.54127 | 37.7987324288073 | -122.415729001311 | (37.7987324288073, -122.415729001311) | 5 | 1 | 10 | 308 | 32 | |||
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 | |
70376 | 30582 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 800 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1995 12:00:00 AM | Permit Number 34556 | 6002725.87405322 | 2109589.53141465 | 37.7726847844256 | -122.433985230527 | (37.7726847844256, -122.433985230527) | 15 | 5 | 11 | 29492 | 9 | |||
70731 | 30584 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 800 Page St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1995 12:00:00 AM | Permit Number 34556 | 6002725.87405322 | 2109589.53141465 | 37.7726847844256 | -122.433985230527 | (37.7726847844256, -122.433985230527) | 15 | 5 | 11 | 29492 | 9 | |||
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 | ||
71944 | 247957 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 8 Joy St | 1 | Front Yard : Yard | Tree | Private 2 | 41 | 6010434.99272 | 2098878.7541 | 37.743709870826 | -122.406563517506 | (37.743709870826, -122.406563517506) | 2 | 7 | 7 | 28859 | 2 | ||||
73007 | 56604 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1914 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 5999483.43623 | 2115589.87746 | 37.788975642546 | -122.445632707581 | (37.788975642546, -122.445632707581) | 13 | 6 | 1 | 29490 | 27 | ||||
73078 | 191259 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 900x Carolina St | 27 | Median : Yard | Tree | DPW 1 | 17 | 6012470.08805 | 2103421.28043 | 37.7562963136528 | -122.399845510773 | (37.7562963136528, -122.399845510773) | 10 | 3 | 8 | 28856 | 29 | ||||
76260 | 54994 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 685 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/1972 12:00:00 AM | 7 | Permit Number 10872 | 5990951.59437 | 2110751.27029 | 37.7751993713132 | -122.474798135923 | (37.7751993713132, -122.474798135923) | 11 | 6 | 2 | 54 | 26 | ||
78623 | 97442 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1900@Gough Pacific Ave | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6004943.9 | 2117474.7 | 37.7944611255838 | -122.426874507837 | (37.7944611255838, -122.426874507837) | 13 | 9 | 1 | 28858 | 27 | |||||
80345 | 41525 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1034 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/2000 12:00:00 AM | Permit Number 42065 | 6018447.62591186 | 2095068.89236301 | 37.7336937659006 | -122.37859297315 | (37.7336937659006, -122.37859297315) | 10 | 3 | 8 | 58 | 1 | |||
80856 | 97675 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2562 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 6000810.80569 | 2117928.44871 | 37.7954724412642 | -122.441208053918 | (37.7954724412642, -122.441208053918) | 13 | 9 | 1 | 57 | 17 | ||||
81506 | 227602 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1201 San Jose Ave | 54 | Front Yard : Yard | Tree | Private 2 | 1 | 6004494.61967 | 2096104.27773 | 37.735757657888 | -122.426906353066 | (37.735757657888, -122.426906353066) | 2 | 7 | 5 | 28861 | 2 | ||||
84073 | 191265 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2100 Thomas Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6012134.75084 | 2095927.24781 | 37.7357006075903 | -122.400478845738 | (37.7357006075903, -122.400478845738) | 10 | 3 | 8 | 58 | 1 | ||||
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 | ||
86778 | 176920 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 671 London St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6001061.12784 | 2089906.70665 | 37.7185458066272 | -122.438333380903 | (37.7185458066272, -122.438333380903) | 9 | 7 | 6 | 28861 | 5 | ||||
87345 | 191264 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 801 Arkansas St | 30 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | 6013055.03201 | 2103799.19748 | 37.7573665842245 | -122.397849067074 | (37.7573665842245, -122.397849067074) | 10 | 3 | 8 | 28856 | 29 | ||||
87905 | 101350 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 600 Chestnut St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | Permit Number 32655 | 6008949 | 2120797 | 37.8038089789489 | -122.413251371179 | (37.8038089789489, -122.413251371179) | 3 | 1 | 10 | 308 | 23 | |||
88043 | 191269 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 538 Delancey St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6015147.69888 | 2113724.07494 | 37.7847344271845 | -122.391305511737 | (37.7847344271845, -122.391305511737) | 6 | 2 | 9 | 28856 | 6 | ||||
88386 | 54664 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 360 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1972 12:00:00 AM | 1 | Permit Number 10488 | 6012252.97577 | 2086866.66481 | 37.7108286845682 | -122.399434200424 | (37.7108286845682, -122.399434200424) | 10 | 3 | 8 | 309 | 1 | ||
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 | ||
92073 | 98492 | Significant Tree 6 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2149 Laguna St | 1 | Front Yard : Yard | Tree | Private 2 | 6004211.7 | 2116183 | 37.7908730187591 | -122.429315856087 | (37.7908730187591, -122.429315856087) | 13 | 9 | 1 | 29490 | 27 | |||||
93391 | 227607 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1201 San Jose Ave | 61 | Front Yard : Yard | Tree | Private 2 | 2 | 6004513.17713 | 2096122.0643 | 37.7358075450783 | -122.426843458979 | (37.7358075450783, -122.426843458979) | 2 | 7 | 5 | 28861 | 2 | ||||
93851 | 39928 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 100 Arleta Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41199 | 6010702.15739083 | 2087798.94554582 | 37.7133019788898 | -122.404859809077 | (37.7133019788898, -122.404859809077) | 9 | 7 | 8 | 309 | 39 | |||
97150 | 227604 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1201 San Jose Ave | 57 | Front Yard : Yard | Tree | Private 2 | 4 | 6004502.9106 | 2096117.99556 | 37.7357957927473 | -122.426878664735 | (37.7357957927473, -122.426878664735) | 2 | 7 | 5 | 28861 | 2 | ||||
98350 | 227609 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 400 Prospect Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 33 | 6006260.17283 | 2097644.39448 | 37.740086147061 | -122.420911448013 | (37.740086147061, -122.420911448013) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | ||
101466 | 227605 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1201 San Jose Ave | 58 | Front Yard : Yard | Tree | Private 2 | 2 | 6004504.61589 | 2096121.06345 | 37.7358043129022 | -122.426872987299 | (37.7358043129022, -122.426872987299) | 2 | 7 | 5 | 28861 | 2 | ||||
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 | |
102631 | 207098 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 144 Mangels Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6000468.8354 | 2095254.59465 | 37.7331961737441 | -122.440764091915 | (37.7331961737441, -122.440764091915) | 9 | 7 | 5 | 63 | 40 | ||||
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 | ||
105695 | 98153 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 466 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | Permit Number 768787 | 5991293.7 | 2112258 | 37.7793562570144 | -122.473724666839 | (37.7793562570144, -122.473724666839) | 11 | 6 | 2 | 54 | 26 | |||
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 | ||
108600 | 92051 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2323 Cesar Chavez St | Front Yard : Cutout | 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 | |||||
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 | ||
109753 | 54086 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2405 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/1972 12:00:00 AM | 7 | Permit Number 9810 | 6003110.67405 | 2116498.63256 | 37.7916772707399 | -122.433147915142 | (37.7916772707399, -122.433147915142) | 13 | 9 | 1 | 29490 | 27 | ||
112382 | 97676 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2562 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 6000785.23545 | 2117926.05562 | 37.7954644138979 | -122.441296359259 | (37.7954644138979, -122.441296359259) | 13 | 9 | 1 | 57 | 17 |
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) );