trees
861 rows where qSpecies_id = 18 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | ||||
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 | ||||
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 | ||||
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 | |||||
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 | ||
22042 | 102557 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1755X 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015173.7 | 2107354.9 | 37.7672475362702 | -122.390770296702 | (37.7672475362702, -122.390770296702) | 14 | 3 | 9 | 310 | 20 | ||||
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 | ||
25784 | 99395 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1590 Yosemite Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
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 | ||
28352 | 102555 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1755X 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015173.7 | 2107354.9 | 37.7672475362702 | -122.390770296702 | (37.7672475362702, -122.390770296702) | 14 | 3 | 9 | 310 | 20 | ||||
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 | ||
32862 | 102563 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1655X 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015154.2 | 2107704.9 | 37.7682074777149 | -122.390862208319 | (37.7682074777149, -122.390862208319) | 14 | 3 | 9 | 310 | 20 | ||||
35863 | 99398 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1590 Yosemite Ave | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
36210 | 102562 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1655X 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015154.2 | 2107704.9 | 37.7682074777149 | -122.390862208319 | (37.7682074777149, -122.390862208319) | 14 | 3 | 9 | 310 | 20 | ||||
36272 | 108295 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 55x DIVISION ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011511.3 | 2108309.6 | 37.7696650457173 | -122.40350525397 | (37.7696650457173, -122.40350525397) | 8 | 2 | 8 | 28853 | 20 | ||||
42693 | 105034 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1550 04th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6015094.5 | 2108059.1 | 37.7691767205026 | -122.391093466638 | (37.7691767205026, -122.391093466638) | 14 | 3 | 9 | 310 | 20 | ||||
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 | ||
46272 | 112621 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 226x HESTER AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012667 | 2087636 | 37.7129641948773 | -122.398057164184 | (37.7129641948773, -122.398057164184) | 10 | 3 | 8 | 309 | 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 | ||||
49133 | 81638 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 611 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52388 | 6011631.16657043 | 2091602.57917757 | 37.7237978701092 | -122.401916029713 | (37.7237978701092, -122.401916029713) | 10 | 3 | 7 | 309 | 28 | ||
51411 | 99394 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1590 Yosemite Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
54279 | 102559 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1755X 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015173.7 | 2107354.9 | 37.7672475362702 | -122.390770296702 | (37.7672475362702, -122.390770296702) | 14 | 3 | 9 | 310 | 20 | ||||
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 | ||
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 | ||
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 | ||
71036 | 99387 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1590 Yosemite Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
72314 | 102564 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1655X 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015154.2 | 2107704.9 | 37.7682074777149 | -122.390862208319 | (37.7682074777149, -122.390862208319) | 14 | 3 | 9 | 310 | 20 | ||||
74332 | 99393 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1590 Yosemite Ave | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
75100 | 99759 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 4295x 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001974.5 | 2101167.2 | 37.7495164396885 | -122.435981539714 | (37.7495164396885, -122.435981539714) | 2 | 4 | 5 | 28862 | 22 | ||||
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 | |||
80923 | 83341 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 422-24 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50786 | 6002931.20131858 | 2105783.16408091 | 37.762245079378 | -122.433002986091 | (37.762245079378, -122.433002986091) | 15 | 4 | 5 | 28862 | 3 | ||
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 | ||
86958 | 112623 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 228 HESTER AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x2 | 6012539 | 2087662 | 37.7130284556779 | -122.398501400627 | (37.7130284556779, -122.398501400627) | 10 | 3 | 8 | 309 | 1 | ||||
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 | |||
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 | ||
91278 | 102561 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1655X 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015154.2 | 2107704.9 | 37.7682074777149 | -122.390862208319 | (37.7682074777149, -122.390862208319) | 14 | 3 | 9 | 310 | 20 | ||||
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 | |||||
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 | |||
98008 | 99758 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 4295x 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001974.5 | 2101167.2 | 37.7495164396885 | -122.435981539714 | (37.7495164396885, -122.435981539714) | 2 | 4 | 5 | 28862 | 22 | ||||
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 | ||
104464 | 102565 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1655X 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015154.2 | 2107704.9 | 37.7682074777149 | -122.390862208319 | (37.7682074777149, -122.390862208319) | 14 | 3 | 9 | 310 | 20 | ||||
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 | ||
105414 | 104725 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2747 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2013 12:00:00 AM | 3x3 | Permit Number 770749 | 5999893.3 | 2117731.9 | 37.7948804646429 | -122.444368636719 | (37.7948804646429, -122.444368636719) | 13 | 9 | 1 | 57 | 27 | ||
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 | ||
107011 | 105032 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1550 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6015094.5 | 2108059.1 | 37.7691767205026 | -122.391093466638 | (37.7691767205026, -122.391093466638) | 14 | 3 | 9 | 310 | 20 | ||||
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 | |||||
108911 | 105033 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1550 04th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6015094.5 | 2108059.1 | 37.7691767205026 | -122.391093466638 | (37.7691767205026, -122.391093466638) | 14 | 3 | 9 | 310 | 20 | ||||
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 | ||
112886 | 101353 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 600 Chestnut St | 17 | 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 | |||
115276 | 122590 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 100 MacOndray Ln | 1 | Unaccepted Street : Yard | Tree | Private 2 | 6008161 | 2119143 | 37.7992232381339 | -122.415861106147 | (37.7992232381339, -122.415861106147) | 5 | 1 | 10 | 308 | 32 | |||||
115855 | 39927 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 100 Arleta Ave | 1 | 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 | |||
117570 | 96626 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 145 Sutro Heights Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/10/2011 12:00:00 AM | Permit Number 767986 | 5981103.1 | 2111247.3 | 37.7759857009664 | -122.50890252539 | (37.7759857009664, -122.50890252539) | 11 | 6 | 2 | 55 | 26 | |||
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 | ||
125863 | 92049 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2323 Cesar Chavez St | Front Yard : Yard | Tree | DPW 1 | 05/16/2009 12:00:00 AM | 6012395.863444 | 2100936.77011 | 37.7494702500338 | -122.399927744224 | (37.7494702500338, -122.399927744224) | 10 | 3 | 8 | 58 | 1 | |||||
128101 | 55533 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 20 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50807 | 6000967.89961965 | 2104951.08442142 | 37.7598488349738 | -122.439733631625 | (37.7598488349738, -122.439733631625) | 2 | 4 | 5 | 28862 | 3 | ||
128245 | 55357 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1001 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1972 12:00:00 AM | Permit Number 11290 | 6001956.10378782 | 2101177.25372795 | 37.749542999745 | -122.436045873593 | (37.749542999745, -122.436045873593) | 2 | 4 | 5 | 28862 | 22 | |||
131073 | 102554 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1755X 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015173.7 | 2107354.9 | 37.7672475362702 | -122.390770296702 | (37.7672475362702, -122.390770296702) | 14 | 3 | 9 | 310 | 20 | ||||
135442 | 30583 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 800 Page St | 3 | 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 | |||
135449 | 99385 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1590 Yosemite Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
138410 | 101359 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2201X Mason St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | 5x5 | Permit Number 32655 | 6008936.1 | 2120783.7 | 37.803771736238 | -122.413295071436 | (37.803771736238, -122.413295071436) | 3 | 1 | 10 | 308 | 23 | ||
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 | ||
142412 | 63101 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 18 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50807 | 6000981.26282803 | 2104951.87977531 | 37.7598517794365 | -122.439687471955 | (37.7598517794365, -122.439687471955) | 2 | 4 | 5 | 28862 | 3 | ||
144937 | 93854 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1109 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/2010 12:00:00 AM | 3x3 | Permit Number 53359 | 5990875 | 2103807 | 37.7561278331456 | -122.474556183246 | (37.7561278331456, -122.474556183246) | 1 | 8 | 4 | 56 | 12 | ||
145623 | 102566 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1655X 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015154.2 | 2107704.9 | 37.7682074777149 | -122.390862208319 | (37.7682074777149, -122.390862208319) | 14 | 3 | 9 | 310 | 20 | ||||
148005 | 97286 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 80 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 768450 | 5993053 | 2098535 | 37.7417782258334 | -122.466640790543 | (37.7417782258334, -122.466640790543) | 1 | 8 | 4 | 59 | 40 | |||
150193 | 30585 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 800 Page St | 5 | 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 | |||
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 | ||
151040 | 99386 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1590 Yosemite Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
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 | ||
153462 | 108297 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 55x DIVISION ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011511.3 | 2108309.6 | 37.7696650457173 | -122.40350525397 | (37.7696650457173, -122.40350525397) | 8 | 2 | 8 | 28853 | 20 | ||||
154792 | 108296 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 55x DIVISION ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011511.3 | 2108309.6 | 37.7696650457173 | -122.40350525397 | (37.7696650457173, -122.40350525397) | 8 | 2 | 8 | 28853 | 20 | ||||
157982 | 102560 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1755X 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015173.7 | 2107354.9 | 37.7672475362702 | -122.390770296702 | (37.7672475362702, -122.390770296702) | 14 | 3 | 9 | 310 | 20 | ||||
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 | ||
165931 | 102568 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1655X 04th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015154.2 | 2107704.9 | 37.7682074777149 | -122.390862208319 | (37.7682074777149, -122.390862208319) | 14 | 3 | 9 | 310 | 20 | ||||
167223 | 104724 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2747 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 770749 | 5999893.3 | 2117731.9 | 37.7948804646429 | -122.444368636719 | (37.7948804646429, -122.444368636719) | 13 | 9 | 1 | 57 | 27 | |||
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 | ||
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 | ||
180619 | 99381 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1590 Yosemite Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
184748 | 102567 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1655X 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2013 12:00:00 AM | 3x3 | Permit Number 769962 | 6015154.2 | 2107704.9 | 37.7682074777149 | -122.390862208319 | (37.7682074777149, -122.390862208319) | 14 | 3 | 9 | 310 | 20 | ||
184935 | 92050 | 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 | |||||
188829 | 102556 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1755X 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015173.7 | 2107354.9 | 37.7672475362702 | -122.390770296702 | (37.7672475362702, -122.390770296702) | 14 | 3 | 9 | 310 | 20 | ||||
191047 | 99399 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1590 Yosemite Ave | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980856 | -122.390639783135 | (37.726418980856, -122.390639783135) | 10 | 3 | 8 | 58 | 1 | ||
192681 | 102558 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1755X 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015173.7 | 2107354.9 | 37.7672475362702 | -122.390770296702 | (37.7672475362702, -122.390770296702) | 14 | 3 | 9 | 310 | 20 | ||||
192751 | 64085 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 850 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2010 12:00:00 AM | Permit Number 54033 | 5990603.92265969 | 2099084.38866457 | 37.7431450674581 | -122.475148901667 | (37.7431450674581, -122.475148901667) | 1 | 8 | 4 | 29491 | 40 | |||
194062 | 96627 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 145 Sutro Heights Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 06/10/2011 12:00:00 AM | Permit Number 767986 | 5981103.1 | 2111247.3 | 37.7759857009664 | -122.50890252539 | (37.7759857009664, -122.50890252539) | 11 | 6 | 2 | 55 | 26 | |||
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 |
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) );