861 rows where qSpecies_id = 18 sorted by DBH

View and edit SQL

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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);