trees
1,650 rows where qSpecies_id = 64 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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) );