1,650 rows where qSpecies_id = 64 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)
683 38304 Permitted Site 7 Cordyline australis :: Dracena Palm 64 2000 Folsom St 12 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/27/1998 12:00:00 AM     Permit Number 40376 6008042.39215173 2106787.37094181 37.7652909891949 -122.415396349695 (37.7652909891949, -122.415396349695) 8 4 7 28859 19
1819 259562 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 200 Public Park 1 Unaccepted Street : Cutout Tree Private 2       5x10   5994204 2098512 37.741781429361 -122.462659374294 (37.741781429361, -122.462659374294) 1 8 4 59 40
1995 87953 Permitted Site 7 Cordyline australis :: Dracena Palm 64 495 Harkness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2008 12:00:00 AM   3x3 Permit Number 50978 6010151 2089645.9 37.7183425147467 -122.406894902171 (37.7183425147467, -122.406894902171) 10 7 8 309 39
3002 43637 Permitted Site 7 Cordyline australis :: Dracena Palm 64 464 Bartlett St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/24/2000 12:00:00 AM     Permit Number 43287 6006770.36235207 2101076.15554315 37.7495377351989 -122.419390811234 (37.7495377351989, -122.419390811234) 2 4 7 28859 19
3380 261217 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 3400 Vicente St   : Cutout Tree Private 2 FUF     3x3   5982420.06104 2097439.60235 37.738151214353 -122.503324281602 (37.738151214353, -122.503324281602) 1 8 3 29491 35
3410 47847 Permitted Site 7 Cordyline australis :: Dracena Palm 64 8250on Geary 47th Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   06/14/2002 12:00:00 AM     Permit Number 45605                    
3946 52915 Permitted Site 7 Cordyline australis :: Dracena Palm 64 3017th ST Ord St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/26/2006 12:00:00 AM     Permit Number 48903 6000815.25066305 2106175.88788155 37.7632031545323 -122.440349407902 (37.7632031545323, -122.440349407902) 15 5 5 28862 3
4272 47849 Permitted Site 7 Cordyline australis :: Dracena Palm 64 8250on Geary 47th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   06/14/2002 12:00:00 AM     Permit Number 45605                    
4396 260248 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 100 Copper Aly 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999810 2103933 37.7569874509855 -122.443665087987 (37.7569874509855, -122.443665087987) 2 5 5 28862 3
8187 37494 Permitted Site 7 Cordyline australis :: Dracena Palm 64 1050 Kirkham St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/22/1998 12:00:00 AM     Permit Number 39963 5991661.12122197 2105245.54821547 37.7601232248942 -122.471942379719 (37.7601232248942, -122.471942379719) 1 8 4 56 12
8350 47846 Permitted Site 7 Cordyline australis :: Dracena Palm 64 8250on Geary 47th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/14/2002 12:00:00 AM     Permit Number 45605                    
9042 122353 Undocumented 4 Cordyline australis :: Dracena Palm 64 155 Appleton Ave 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006071 2097171 37.7387756468895 -122.421531918974 (37.7387756468895, -122.421531918974) 2 7 7 28859 2
9532 261191 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 599x Benton Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007159 2095436 37.7340730065148 -122.41764717788 (37.7340730065148, -122.41764717788) 2 7 7 28859 2
9818 47845 Permitted Site 7 Cordyline australis :: Dracena Palm 64 8250on Geary 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/14/2002 12:00:00 AM     Permit Number 45605                    
10077 264701 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 88 Entrada Ct 1 Sidewalk: Property side : Yard Tree Private 2       8x20   5992483 2092113 37.724112106281 -122.468144593972 (37.724112106281, -122.468144593972) 9 8 4 59 40
14890 261368 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 48 Bache St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007159 2095436 37.7340730065148 -122.41764717788 (37.7340730065148, -122.41764717788) 2 7 7 28859 2
15628 47848 Permitted Site 7 Cordyline australis :: Dracena Palm 64 8250on Geary 47th Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   06/14/2002 12:00:00 AM     Permit Number 45605                    
16372 96327 Significant Tree 6 Cordyline australis :: Dracena Palm 64 296 Randall St 1 Sidewalk: Property side : Yard Tree Private 2         Permit Number 767829 6003708 2097940 37.7407536226533 -122.429756895294 (37.7407536226533, -122.429756895294) 2 7 5 63 7
16797 47844 Permitted Site 7 Cordyline australis :: Dracena Palm 64 8250on Geary 47th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   06/14/2002 12:00:00 AM     Permit Number 45605                    
17004 259318 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 601 Wisconsin St   Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6012713 2104246 37.7585743521834 -122.399063317374 (37.7585743521834, -122.399063317374) 10 3 8 28856 29
18190 261630 Undocumented 4 Cordyline australis :: Dracena Palm 64 15 Noe St 1 Sidewalk: Curb side : Pot Landscaping Private 2       3x3   6002878 2108185 37.7688369185992 -122.433358627279 (37.7688369185992, -122.433358627279) 15 5 5 28862 3
22362 104523 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 51X BONVIEW ST 1 Front Yard : Yard Tree DPW 1           6007716 2099172 37.7443625662885 -122.415985930063 (37.7443625662885, -122.415985930063) 2 7 7 28859 2
22498 92364 Permitted Site 7 Cordyline australis :: Dracena Palm 64 1910 33rd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/2009 12:00:00 AM   3x3 Permit Number 52777 5986038.6 2102202.7 37.7514414512274 -122.491163791724 (37.7514414512274, -122.491163791724) 1 8 3 29491 35
24636 48634 Permitted Site 7 Cordyline australis :: Dracena Palm 64 1436 17th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/30/2002 12:00:00 AM     Permit Number 45929 5990866.95707843 2105617.12188587 37.761097481488 -122.474716107382 (37.761097481488, -122.474716107382) 1 8 4 56 12
24823 38314 Permitted Site 7 Cordyline australis :: Dracena Palm 64 2000 Folsom St 17 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/27/1998 12:00:00 AM     Permit Number 40376 6008042.39215173 2106787.37094181 37.7652909891949 -122.415396349695 (37.7652909891949, -122.415396349695) 8 4 7 28859 19
26211 31637 Permitted Site 7 Cordyline australis :: Dracena Palm 64 2550 Great Hwy 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/25/2011 12:00:00 AM   3x3 Permit Number 767125 5981518.05011446 2097722.76963447 37.7388756474124 -122.506463924771 (37.7388756474124, -122.506463924771) 1 8 3 29491 35
27224 95764 Permitted Site 7 Cordyline australis :: Dracena Palm 64 425 Moscow St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/2011 12:00:00 AM   3x3 Permit Number 767500 6004118.7 2090668.4 37.7208106862046 -122.427818850767 (37.7208106862046, -122.427818850767) 9 7 6 28861 5
27710 39820 Permitted Site 7 Cordyline australis :: Dracena Palm 64 2101 46th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   01/06/1999 12:00:00 AM     Permit Number 41148 5981978.01419846 2100783.80216684 37.7473074654157 -122.505100399713 (37.7473074654157, -122.505100399713) 1 8 3 29491 35
29379 254551 Significant Tree 6 Cordyline australis :: Dracena Palm 64 1433 Cayuga Ave 1 Front Yard : Cutout Tree Private 2       6x6   5999129 2089595 37.7175798453783 -122.444989533853 (37.7175798453783, -122.444989533853) 9 7 6 28861 25
31661 34649 Permitted Site 7 Cordyline australis :: Dracena Palm 64 1735 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM     Permit Number 40399 5987784.82467276 2103483.81569075 37.7550609240819 -122.485219205847 (37.7550609240819, -122.485219205847) 1 8 3 56 35
32003 59294 Permitted Site 7 Cordyline australis :: Dracena Palm 64 357 Frederick St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/20/1980 12:00:00 AM     Permit Number 18631 5998269.35755712 2107529.98911826 37.7667758890994 -122.449252327047 (37.7667758890994, -122.449252327047) 15 5 11 29492 9
33188 39188 Permitted Site 7 Cordyline australis :: Dracena Palm 64 1189 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/19/1998 12:00:00 AM     Permit Number 40841 6007685.90483064 2102746.1551156 37.7541746987817 -122.416343098068 (37.7541746987817, -122.416343098068) 2 4 7 28859 19
36282 38313 Permitted Site 7 Cordyline australis :: Dracena Palm 64 2000 Folsom St 15 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/27/1998 12:00:00 AM     Permit Number 40376 6008042.39215173 2106787.37094181 37.7652909891949 -122.415396349695 (37.7652909891949, -122.415396349695) 8 4 7 28859 19
37481 39818 Permitted Site 7 Cordyline australis :: Dracena Palm 64 2101 46th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   01/06/1999 12:00:00 AM     Permit Number 41148 5981978.01419846 2100783.80216684 37.7473074654157 -122.505100399713 (37.7473074654157, -122.505100399713) 1 8 3 29491 35
37881 87091 Permitted Site 7 Cordyline australis :: Dracena Palm 64 2533 Baker St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 50041 5999658 2117512 37.7942632496373 -122.445166988043 (37.7942632496373, -122.445166988043) 13 9 1 57 27
38273 111768 Undocumented 4 Cordyline australis :: Dracena Palm 64 4966 17th St 3 Sidewalk: Curb side : Pot Tree Private 2           5997580.2349427 2105651.04183436 37.7615773358373 -122.45150033551 (37.7615773358373, -122.45150033551) 15 5 11 29492 9
39702 39841 Permitted Site 7 Cordyline australis :: Dracena Palm 64 3151 Ortega St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/1999 12:00:00 AM     Permit Number 41160 5984281.43555925 2102217.56111428 37.7513794309419 -122.49724128025 (37.7513794309419, -122.49724128025) 1 8 3 29491 35
42741 85021 Permitted Site 7 Cordyline australis :: Dracena Palm 64 299 Maywood Dr 2 Sidewalk: Curb side : Cutout Tree Private 2           5994525 2094707 37.7313523209144 -122.461273710807 (37.7313523209144, -122.461273710807) 9 8 4 59 40
42780 84884 Permitted Site 7 Cordyline australis :: Dracena Palm 64 2895 HARRISON St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/03/2007 12:00:00 AM     Permit No. 49261 6009003 2101605 37.7511153190475 -122.411707614344 (37.7511153190475, -122.411707614344) 2 4 7 28859 19
43795 31943 Permitted Site 7 Cordyline australis :: Dracena Palm 64 1300 La Playa St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/25/2011 12:00:00 AM   3x3 Permit Number 767126 5980916.9213303 2106151.77480086 37.761983899941 -122.50916807627 (37.761983899941, -122.50916807627) 1 8 3 56 35
43857 43115 Permitted Site 7 Cordyline australis :: Dracena Palm 64 200 Appleton Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/13/2003 12:00:00 AM     Permit Number 42938 6005863.014 2096788.574 37.7377138611244 -122.422223875233 (37.7377138611244, -122.422223875233) 2 7 7 28859 2
48630 45274 Permitted Site 7 Cordyline australis :: Dracena Palm 64 635 Crescent Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/12/2001 12:00:00 AM     Permit Number 44117 6007835.54663504 2095717.89639114 37.734885079654 -122.415328087742 (37.734885079654, -122.415328087742) 2 7 7 28859 2
48775 100847 Undocumented 4 Cordyline australis :: Dracena Palm 64 1 Estero Ave 5 Sidewalk: Property side : Yard Tree Private 2           5992057.7 2091642.6 37.7227959320346 -122.469580550695 (37.7227959320346, -122.469580550695) 9 8 4 59 40
50937 95708 Permitted Site 7 Cordyline australis :: Dracena Palm 64 277 Athens St   Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/2011 12:00:00 AM   3x3 Permit Number 767467 6004392 2091652 37.7235268927559 -122.426944152742 (37.7235268927559, -122.426944152742) 9 7 6 28861 5
54753 100531 Undocumented 4 Cordyline australis :: Dracena Palm 64 689 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003067 2104228 37.7579826742399 -122.432422230009 (37.7579826742399, -122.432422230009) 2 4 5 28862 3
60901 84911 Permitted Site 7 Cordyline australis :: Dracena Palm 64 5546 Anza St 5 Sidewalk: Curb side : Cutout Tree Private 2   04/03/2007 12:00:00 AM     Permit No. 49266 5981488 2111676 37.7771854666478 -122.507602896513 (37.7771854666478, -122.507602896513) 11 6 2 55 26
63427 105002 Permitted Site 7 Cordyline australis :: Dracena Palm 64 3418 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2       4x6 Permit Number 768912 6006889.6 2100911.6 37.7490926180804 -122.418966813039 (37.7490926180804, -122.418966813039) 2 4 7 28859 19
64400 48360 Permitted Site 7 Cordyline australis :: Dracena Palm 64 246 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2002 12:00:00 AM     Permit Number 45771 6003531.3283676 2101591.65736703 37.7507702195134 -122.430628266841 (37.7507702195134, -122.430628266841) 2 4 5 28862 22
69366 101171 Undocumented 4 Cordyline australis :: Dracena Palm 64 420 Noe St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002934 2105795 37.7622777366985 -122.432994152167 (37.7622777366985, -122.432994152167) 15 4 5 28862 3
69856 112572 Significant Tree 6 Cordyline australis :: Dracena Palm 64 162 GRAND VIEW AVE 4 Front Yard : Cutout Tree Private 2       3x3   6000754 2103380 37.7555228430156 -122.440360729392 (37.7555228430156, -122.440360729392) 2 4 5 63 38
70945 48635 Permitted Site 7 Cordyline australis :: Dracena Palm 64 1436 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/30/2002 12:00:00 AM     Permit Number 45929 5990866.95707843 2105617.12188587 37.761097481488 -122.474716107382 (37.761097481488, -122.474716107382) 1 8 4 56 12
71187 34375 Permitted Site 7 Cordyline australis :: Dracena Palm 64 157 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/14/1997 12:00:00 AM     Permit Number 38127 6003918.97921609 2097483.80532691 37.7395129612854 -122.428994891637 (37.7395129612854, -122.428994891637) 2 7 5 63 7
72642 87089 Permitted Site 7 Cordyline australis :: Dracena Palm 64 2533 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 50041 5999658 2117512 37.7942632496373 -122.445166988043 (37.7942632496373, -122.445166988043) 13 9 1 57 27
75177 39819 Permitted Site 7 Cordyline australis :: Dracena Palm 64 2101 46th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   01/06/1999 12:00:00 AM     Permit Number 41148 5981978.01419846 2100783.80216684 37.7473074654157 -122.505100399713 (37.7473074654157, -122.505100399713) 1 8 3 29491 35
75577 253425 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 2 09th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 780637 5993083 2114893 37.7866947153523 -122.46772647285 (37.7866947153523, -122.46772647285) 11 6 1 54 11
78225 84597 Permitted Site 7 Cordyline australis :: Dracena Palm 64 495 Harkness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2008 12:00:00 AM   3x3 Permit Number 50978 6010148.19523638 2089662.82896813 37.7183888412655 -122.406905789617 (37.7183888412655, -122.406905789617) 10 7 8 309 39
79006 44342 Permitted Site 7 Cordyline australis :: Dracena Palm 64 187 Peralta Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/11/2010 12:00:00 AM   3x3 Permit Number 53500 6009836.45355968 2099988.51839254 37.7467235364285 -122.408711405987 (37.7467235364285, -122.408711405987) 2 7 7 28859 2
79271 94199 Permitted Site 7 Cordyline australis :: Dracena Palm 64 355 Ocean Ave 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 53723 5999419.6 2091436.9 37.7226538624451 -122.444117342662 (37.7226538624451, -122.444117342662) 9 7 6 28861 25
82007 96910 Permitted Site 7 Cordyline australis :: Dracena Palm 64 1399X 48TH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2   08/08/2011 12:00:00 AM   3x3 Permit Number 768110 5981210 2105881 37.7612577047615 -122.508134351337 (37.7612577047615, -122.508134351337) 1 8 3 56 35
84064 52914 Permitted Site 7 Cordyline australis :: Dracena Palm 64 3017th ST Ord St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/26/2006 12:00:00 AM     Permit Number 48903 6000815.25066305 2106175.88788155 37.7632031545323 -122.440349407902 (37.7632031545323, -122.440349407902) 15 5 5 28862 3
84819 92433 Permitted Site 7 Cordyline australis :: Dracena Palm 64 2367 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/30/2009 12:00:00 AM   3x3 Permit Number 52823 5983266.6 2099037.7 37.7425888819276 -122.500515549194 (37.7425888819276, -122.500515549194) 1 8 3 29491 35
85384 92427 Permitted Site 7 Cordyline australis :: Dracena Palm 64 1601 39th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/2009 12:00:00 AM   3x3 Permit Number 52817 5984021 2104223.4 37.7568716403648 -122.498290014097 (37.7568716403648, -122.498290014097) 1 8 3 56 35
88354 39743 Permitted Site 7 Cordyline australis :: Dracena Palm 64 3944 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/1999 12:00:00 AM     Permit Number 41110 6002294.13129656 2103577.97626079 37.7561540096169 -122.435048644634 (37.7561540096169, -122.435048644634) 2 4 5 28862 3
89746 58598 Undocumented 4 Cordyline australis :: Dracena Palm 64 4966 17th St 1 Sidewalk: Curb side : Pot Tree Private 2   04/19/1979 12:00:00 AM     Permit Number 17804 5997580.2349427 2105651.04183436 37.7615773358373 -122.45150033551 (37.7615773358373, -122.45150033551) 15 5 11 29492 9
93049 52308 Permitted Site 7 Cordyline australis :: Dracena Palm 64 464@ NOE 30th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/2005 12:00:00 AM     Permit Number 48468 6003585.05710238 2098376.65012733 37.7419456008039 -122.430213129043 (37.7419456008039, -122.430213129043) 2 7 5 63 22
94357 92495 Permitted Site 7 Cordyline australis :: Dracena Palm 64 3626 Vicente St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/31/2009 12:00:00 AM   3x3 Permit Number 52865 5981730 2097424 37.7380677850415 -122.505708970967 (37.7380677850415, -122.505708970967) 1 8 3 29491 35
96146 112571 Undocumented 4 Cordyline australis :: Dracena Palm 64 162 GRAND VIEW AVE 3 Front Yard : Cutout Tree Private 2       3x3   6000754 2103380 37.7555228430156 -122.440360729392 (37.7555228430156, -122.440360729392) 2 4 5 63 38
97807 39840 Permitted Site 7 Cordyline australis :: Dracena Palm 64 3151 Ortega St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/1999 12:00:00 AM     Permit Number 41160 5984281.43555925 2102217.56111428 37.7513794309419 -122.49724128025 (37.7513794309419, -122.49724128025) 1 8 3 29491 35
102031 94194 Permitted Site 7 Cordyline australis :: Dracena Palm 64 355 Ocean Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999419.6 2091436.9 37.7226538624451 -122.444117342662 (37.7226538624451, -122.444117342662) 9 7 6 28861 25
103902 94195 Permitted Site 7 Cordyline australis :: Dracena Palm 64 355 Ocean Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999419.6 2091436.9 37.7226538624451 -122.444117342662 (37.7226538624451, -122.444117342662) 9 7 6 28861 25
103931 34376 Permitted Site 7 Cordyline australis :: Dracena Palm 64 159 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/14/1997 12:00:00 AM     Permit Number 38128 6003933.5588278 2097472.84374368 37.7394836885423 -122.42894370039 (37.7394836885423, -122.42894370039) 2 7 5 63 7
105038 87951 Permitted Site 7 Cordyline australis :: Dracena Palm 64 495 Harkness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2008 12:00:00 AM   3x3 Permit Number 50978 6010151 2089645.9 37.7183425147467 -122.406894902171 (37.7183425147467, -122.406894902171) 10 7 8 309 39
107427 105004 Permitted Site 7 Cordyline australis :: Dracena Palm 64 3418 26th St 2 Sidewalk: Curb side : Cutout Tree Private 2       16x4 Permit Number 768912 6006889.6 2100911.6 37.7490926180804 -122.418966813039 (37.7490926180804, -122.418966813039) 2 4 7 28859 19
107889 38373 Permitted Site 7 Cordyline australis :: Dracena Palm 64 3741 Noriega St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2014 12:00:00 AM     Permit Number 40432 5982426.74388672 2102835.76429046 37.7529679717779 -122.503700690636 (37.7529679717779, -122.503700690636) 1 8 3 56 35
108055 101029 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1010X Portola Dr 3 Front Yard : Yard Tree DPW 1           5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
109633 37495 Permitted Site 7 Cordyline australis :: Dracena Palm 64 1050 Kirkham St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM     Permit Number 42243 5991661.12122197 2105245.54821547 37.7601232248942 -122.471942379719 (37.7601232248942, -122.471942379719) 1 8 4 56 12
111048 113744 Significant Tree 6 Cordyline australis :: Dracena Palm 64 909 ASHBURY ST 1 Front Yard : Cutout Tree Private 2       3x3   5999156 2107025 37.7654399906909 -122.44614926226 (37.7654399906909, -122.44614926226) 15 5 11 29492 9
111459 91387 Permitted Site 7 Cordyline australis :: Dracena Palm 64 45 Rosewood Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2009 12:00:00 AM   3x3 Permit Number 52084 5994820 2095684 37.7340518973123 -122.460324610216 (37.7340518973123, -122.460324610216) 9 8 4 59 40
113071 254264 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 4650 Balboa St 2 Sidewalk: Curb side : Cutout Tree Private 2           5981096.26906 2110986.58772 37.7752694592632 -122.508906792671 (37.7752694592632, -122.508906792671) 11 6 2 55 26
113814 116969 Undocumented 4 Cordyline australis :: Dracena Palm 64 2648 BRYANT ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009729 2101911 37.7519962268163 -122.409218610644 (37.7519962268163, -122.409218610644) 2 4 7 28859 19
114198 122403 Undocumented 4 Cordyline australis :: Dracena Palm 64 400X Circular Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5999746 2093731 37.7289715465039 -122.443153734972 (37.7289715465039, -122.443153734972) 9 7 4 63 40
116665 38307 Permitted Site 7 Cordyline australis :: Dracena Palm 64 2000 Folsom St 10 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/27/1998 12:00:00 AM     Permit Number 40376 6008042.39215173 2106787.37094181 37.7652909891949 -122.415396349695 (37.7652909891949, -122.415396349695) 8 4 7 28859 19
118008 82985 Permitted Site 7 Cordyline australis :: Dracena Palm 64 460 Ellsworth St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2008 12:00:00 AM   3x3 Permit Number 50922 6008017.64496893 2096716.02509924 37.7376359559176 -122.414769124009 (37.7376359559176, -122.414769124009) 2 7 7 28859 2
119443 51417 Permitted Site 7 Cordyline australis :: Dracena Palm 64 5 Parnassus Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/18/2004 12:00:00 AM     Permit Number 47742 5998697.89125775 2106894.30410502 37.7650549606092 -122.447724339473 (37.7650549606092, -122.447724339473) 15 5 11 29492 9
119729 88115 Permitted Site 7 Cordyline australis :: Dracena Palm 64 4133 Kirkham St   Sidewalk: Curb side : Cutout Tree Private 2   07/01/2008 12:00:00 AM   3x3 Permit Number 51116 5982072 2104866 37.7585215606474 -122.505077887073 (37.7585215606474, -122.505077887073) 1 8 3 56 35
120702 87952 Permitted Site 7 Cordyline australis :: Dracena Palm 64 495 Harkness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2008 12:00:00 AM   3x3 Permit Number 50978 6010151 2089645.9 37.7183425147467 -122.406894902171 (37.7183425147467, -122.406894902171) 10 7 8 309 39
120739 97301 Permitted Site 7 Cordyline australis :: Dracena Palm 64 1051 Portola Dr 4 Sidewalk: Property side : Yard Tree Private 2   09/20/2011 12:00:00 AM     Permit Number 768134 5995688.7 2098126.6 37.7408086112536 -122.457497926865 (37.7408086112536, -122.457497926865) 9 7 4 59 40
123422 52483 Permitted Site 7 Cordyline australis :: Dracena Palm 64 650MAYFLOWER Peralta Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/2005 12:00:00 AM     Permit Number 48593 6009757.2999459 2098381.34570201 37.7423061581468 -122.408871740084 (37.7423061581468, -122.408871740084) 10 7 7 28859 2
125371 92405 Permitted Site 7 Cordyline australis :: Dracena Palm 64 1549 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/2009 12:00:00 AM   3x3 Permit Number 52804 5985246.8 2104672.6 37.7581768205908 -122.494083909336 (37.7581768205908, -122.494083909336) 1 8 3 56 35
125598 100846 Undocumented 4 Cordyline australis :: Dracena Palm 64 1 Estero Ave 4 Sidewalk: Property side : Yard Tree Private 2           5992057.7 2091642.6 37.7227959320346 -122.469580550695 (37.7227959320346, -122.469580550695) 9 8 4 59 40
127709 80063 Permitted Site 7 Cordyline australis :: Dracena Palm 64 830 Teresita Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   10/25/2007 12:00:00 AM   3x3 Permit Number 49842 5999067.87770464 2095624.46606775 37.7341318695922 -122.44563415277 (37.7341318695922, -122.44563415277) 9 7 4 59 40
129169 51283 Permitted Site 7 Cordyline australis :: Dracena Palm 64 3999 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/24/2004 12:00:00 AM     Permit Number 47655 6004645.53227808 2095323.45859057 37.7336222359392 -122.426329013444 (37.7336222359392, -122.426329013444) 2 7 7 28861 2
130197 51282 Permitted Site 7 Cordyline australis :: Dracena Palm 64 3999 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/24/2004 12:00:00 AM     Permit Number 47655 6004645.53227808 2095323.45859057 37.7336222359392 -122.426329013444 (37.7336222359392, -122.426329013444) 2 7 7 28861 2
133956 121655 Undocumented 4 Cordyline australis :: Dracena Palm 64 472 Dewey Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5994766 2100099 37.7461712854061 -122.460831166054 (37.7461712854061, -122.460831166054) 1 8 4 29491 40
134128 43116 Permitted Site 7 Cordyline australis :: Dracena Palm 64 200 Appleton Ave 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/13/2003 12:00:00 AM     Permit Number 42938 6005863.014 2096788.574 37.7377138611244 -122.422223875233 (37.7377138611244, -122.422223875233) 2 7 7 28859 2
134887 92426 Permitted Site 7 Cordyline australis :: Dracena Palm 64 1601 39th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/2009 12:00:00 AM   3x3 Permit Number 52817 5984021 2104223.4 37.7568716403648 -122.498290014097 (37.7568716403648, -122.498290014097) 1 8 3 56 35
135439 105001 Permitted Site 7 Cordyline australis :: Dracena Palm 64 3418 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2       4x6   6006889.6 2100911.6 37.7490926180804 -122.418966813039 (37.7490926180804, -122.418966813039) 2 4 7 28859 19
136098 88275 Permitted Site 7 Cordyline australis :: Dracena Palm 64 1910 33rd Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/09/2008 12:00:00 AM   3x3 Permit Number 51266 5986038.6 2102202.7 37.7514414512274 -122.491163791724 (37.7514414512274, -122.491163791724) 1 8 3 29491 35
136881 94193 Permitted Site 7 Cordyline australis :: Dracena Palm 64 355@ Delano Ave Ocean Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999419.6 2091436.9 37.7226538624451 -122.444117342662 (37.7226538624451, -122.444117342662) 9 7 6 28861 25
139137 37496 Permitted Site 7 Cordyline australis :: Dracena Palm 64 1050 Kirkham St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/22/1998 12:00:00 AM     Permit Number 39963 5991661.12122197 2105245.54821547 37.7601232248942 -122.471942379719 (37.7601232248942, -122.471942379719) 1 8 4 56 12

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