1,650 rows where qSpecies_id = 64 sorted by Zip Codes

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)
1646 19899 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 100 STAIRWAY33 31 Sidewalk: Curb side : Cutout Tree DPW 1     12 25ST                      
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                    
3460 20048 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 100 STAIRWAY52 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 10                      
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                    
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                    
8653 254419 Permitted Site 7 Cordyline australis :: Dracena Palm 64 3400X Moraga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/13/2018 12:00:00 AM 3 3x3 Permit Number 781063                    
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                    
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                    
15929 20047 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 100 STAIRWAY52 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 10                      
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                    
183225 189281 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 975 Minna St 1 : Tree Private 2     7 Width 3ft   6008056.3994 2110189.2113 37.7746324316857 -122.415588777222 (37.7746324316857, -122.415588777222) 8 2 9 28853 34
1960 189303 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1345 20th St 5 Sidewalk: Property side : Yard Tree Private 2     2 Width 3ft   6013928.16034 2104751.39428 37.7600296962246 -122.394896108974 (37.7600296962246, -122.394896108974) 10 3 8 28856 29
13735 189282 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1310 Indiana St 17 : Yard Tree Private 2     2     6015006.25242 2102364.64044 37.753536067647 -122.39100065687 (37.753536067647, -122.39100065687) 10 3 8 28856 29
13800 189286 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1301 Minnesota St 70 Front Yard : Yard Tree Private 2     3     6015368.15632 2102301.56591 37.7533829535663 -122.389744698757 (37.7533829535663, -122.389744698757) 10 3 8 28856 29
15183 189306 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 499 Texas St 1 : Tree Private 2     3 Width 3ft   6013832.17688 2104822.60916 37.7602198992576 -122.395233060671 (37.7602198992576, -122.395233060671) 10 3 8 28856 29
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
18677 189308 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1500 22nd St 1 Sidewalk: Property side : Yard Tree Private 2     11 Width 5ft   6013530.98263 2103856.35073 37.7575500090417 -122.396207035432 (37.7575500090417, -122.396207035432) 10 3 8 28856 29
23277 189302 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1345 20th St 4 Sidewalk: Property side : Yard Tree Private 2     2 Width 3ft   6013921.81731 2104751.14346 37.760028654829 -122.394918029061 (37.760028654829, -122.394918029061) 10 3 8 28856 29
42791 189300 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1345 20th St 2 Sidewalk: Property side : Yard Tree Private 2     2 Width 3ft   6013904.84874 2104750.47011 37.7600258624144 -122.394976668459 (37.7600258624144, -122.394976668459) 10 3 8 28856 29
44940 49418 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 413@ 19th ST Mississippi St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/25/2003 12:00:00 AM 5   Permit Number 46364 6014094.43855 2105154.43805 37.7611456110148 -122.394349248338 (37.7611456110148, -122.394349248338) 10 3 8 28856 29
46882 189307 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1510x 22nd St 1 Median : Cutout Tree DPW 1     6 Width 6ft   6013533.7803 2103828.56548 37.7574738724493 -122.396195412608 (37.7574738724493, -122.396195412608) 10 3 8 28856 29
50934 189291 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1 01st St 31 : Yard Tree Private 2     5     6014386.77773 2105894.38958 37.7631936029157 -122.39338994869 (37.7631936029157, -122.39338994869) 14 3 8 28856 29
64737 101784 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1017 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6012216.2726 2103633.66044 37.7568653093127 -122.400738217399 (37.7568653093127, -122.400738217399) 10 3 8 28856 29
73154 189297 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1458 Rhode Island St 1 : Tree Private 2     17 Width 4ft   6011987.51457 2101577.28204 37.7512061823217 -122.401384841636 (37.7512061823217, -122.401384841636) 10 3 8 28856 29
76388 189289 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1 01st St 20 : Yard Tree Private 2     10     6014461.84726 2105889.9963 37.7631857104708 -122.393129998769 (37.7631857104708, -122.393129998769) 14 3 8 28856 29
76547 189285 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1301 Minnesota St 64 Front Yard : Yard Tree Private 2     3     6015362.87396 2102344.01113 37.7534992062408 -122.389765930873 (37.7534992062408, -122.389765930873) 10 3 8 28856 29
79813 189290 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1 01st St 23 : Yard Tree Private 2     5     6014424.75736 2105899.25329 37.7632090676603 -122.393258929155 (37.7632090676603, -122.393258929155) 14 3 8 28856 29
94508 189283 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1310 Indiana St 16 : Yard Tree Private 2     4     6015000.28938 2102358.87265 37.7535198996319 -122.391020875425 (37.7535198996319, -122.391020875425) 10 3 8 28856 29
99635 189294 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1940 20th St 2 Sidewalk: Property side : Yard Tree Private 2     3 Width 4ft   6012210.95839 2104716.11171 37.7598371855631 -122.400832642618 (37.7598371855631, -122.400832642618) 10 3 8 28856 29
106035 189295 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 670 De Haro St 1 Sidewalk: Curb side : Pot Tree Private 2     4 Width 2ft   6012074.25534 2105313.32081 37.7614693633429 -122.401347403775 (37.7614693633429, -122.401347403775) 10 3 8 28856 29
110505 189305 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 501 Texas St 2 Sidewalk: Property side : Yard Tree Private 2     2 Width 6ft   6013843.52839 2104740.21019 37.7599942809301 -122.395188028931 (37.7599942809301, -122.395188028931) 10 3 8 28856 29
118735 189293 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1 01st St 35 : Yard Tree Private 2     8     6014389.36638 2105866.30731 37.7631166389548 -122.393379030018 (37.7631166389548, -122.393379030018) 14 3 8 28856 29
124983 189301 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1345 20th St 3 Sidewalk: Property side : Yard Tree Private 2     2 Width 3ft   6013913.31542 2104750.9131 37.7600275495642 -122.394947417095 (37.7600275495642, -122.394947417095) 10 3 8 28856 29
131939 49419 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 413@ 19th ST Mississippi St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/25/2003 12:00:00 AM 5   Permit Number 46364 6014093.42123 2105165.00342 37.7611745646684 -122.394353506611 (37.7611745646684, -122.394353506611) 10 3 8 28856 29
137028 189299 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1750 22nd St 11 Side Yard : Yard Tree Private 2     2     6012797.06573 2103802.01858 37.7573599607159 -122.398741420304 (37.7573599607159, -122.398741420304) 10 3 8 28856 29
141647 189284 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1301 Minnesota St 20 Front Yard : Yard Tree Private 2     3     6015381.32425 2102392.44867 37.7536332285927 -122.389705508116 (37.7536332285927, -122.389705508116) 10 3 8 28856 29
142033 189304 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1345 20th St 6 Sidewalk: Property side : Yard Tree Private 2     2 Width 3ft   6013935.92208 2104751.61933 37.7600307457419 -122.394869280409 (37.7600307457419, -122.394869280409) 10 3 8 28856 29
142770 150735 Private 9 Cordyline australis :: Dracena Palm 64 783 Wisconsin St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/31/2019 12:00:00 AM 3 3x3 Permit Number 778950 6012760.80751 2103885.27159 37.7575865350131 -122.398872659244 (37.7575865350131, -122.398872659244) 10 3 8 28856 29
149427 189288 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 301 Pennsylvania Ave 3 Sidewalk: Property side : Yard Tree Private 2     18 Width 9ft   6014362.47484 2105695.49832 37.7626461406213 -122.393460085018 (37.7626461406213, -122.393460085018) 10 3 8 28856 29
150174 51296 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 400 Kansas St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/02/2004 12:00:00 AM 6   Permit Number 47669 6011440.29122 2106415.58211 37.764460534556 -122.403617592093 (37.764460534556, -122.403617592093) 8 3 8 28856 29
151849 51297 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 400 Kansas St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/02/2004 12:00:00 AM 10   Permit Number 47669 6011440.20199 2106438.76449 37.7645241831718 -122.403619531927 (37.7645241831718, -122.403619531927) 8 3 8 28856 29
153969 189298 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1470 Rhode Island St 1 : Tree Private 2     15 Width 4ft   6011992.06191 2101527.33948 37.7510693046196 -122.401365606962 (37.7510693046196, -122.401365606962) 10 3 8 28856 29
156100 189287 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1098 Pennsylvania Ave 14 Sidewalk: Property side : Yard Tree Private 2     7 Width 5ft   6014480.56766 2102060.80293 37.7526726105751 -122.392797348536 (37.7526726105751, -122.392797348536) 10 3 8 28856 29
163412 189292 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1 01st St 33 : Yard Tree Private 2     5     6014376.22928 2105886.6133 37.7631716648753 -122.393425888311 (37.7631716648753, -122.393425888311) 14 3 8 28856 29
192553 189296 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 621 Rhode Island St 1 : Tree Private 2     2 Width 2ft   6011838.19125 2105389.54808 37.7616654928887 -122.402169215947 (37.7616654928887, -122.402169215947) 10 3 8 28856 29
512 126120 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 2843 Larkin St 9 Sidewalk: Property side : Yard Tree Private 2     5 Width 5ft   6006458.53093 2121044.25925 37.8043477551992 -122.421887372509 (37.8043477551992, -122.421887372509) 5 9 1 28858 32
1650 126124 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1055 Lombard St 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 5ft   6007293.98833 2120181.06921 37.8020247344007 -122.418934936917 (37.8020247344007, -122.418934936917) 5 1 1 28858 32
41150 126123 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 2836 Larkin St 6 Side Yard : Yard Tree Private 2     8     6006504.36606 2120972.74597 37.8041539827815 -122.42172367341 (37.8041539827815, -122.42172367341) 5 9 1 28858 32
41814 126121 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 2843 Larkin St 10 Sidewalk: Property side : Yard Tree Private 2     2 Width 5ft   6006456.29777 2121037.52584 37.8043291410369 -122.421894621962 (37.8043291410369, -122.421894621962) 5 9 1 28858 32
57642 126117 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 2843 Larkin St 2 Sidewalk: Property side : Yard Tree Private 2     10 Width 5ft   6006450.97275 2121075.70242 37.8044336638558 -122.421915763199 (37.8044336638558, -122.421915763199) 5 9 1 28858 32
59658 126122 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 2833 Larkin St 1 Side Yard : Yard Tree Private 2     9     6006473.28428 2120942.81763 37.804070054442 -122.421829107228 (37.804070054442, -122.421829107228) 5 9 1 28858 32
61444 249419 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 730 Eddy St 2 : Tree Private 2     9 Width 3ft   6006909.7842 2113298.36761 37.7831049051094 -122.419775815624 (37.7831049051094, -122.419775815624) 7 9 9 28858 36
108639 126114 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 20 Reed St 8 Sidewalk: Property side : Yard Tree Private 2     9     6008207.05335 2117051.51427 37.7934831255889 -122.415553587621 (37.7934831255889, -122.415553587621) 5 1 10 28858 21
112752 126126 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 39 Havens St 1 Sidewalk: Property side : Yard Tree Private 2     10 Width 7ft   6007489.31877 2119355.11229 37.7997678614442 -122.418200406634 (37.7997678614442, -122.418200406634) 5 1 1 28858 32
117644 126125 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1055 Lombard St 2 Sidewalk: Curb side : Yard Tree Private 2     20 Width 5ft   6007295.75973 2120178.53611 37.8020178788931 -122.418928627254 (37.8020178788931, -122.418928627254) 5 1 1 28858 32
118002 126101 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 4 Kimball Pl 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6008010.07653 2116418.05756 37.7917327355326 -122.416190259997 (37.7917327355326, -122.416190259997) 5 1 10 28858 21
149186 126119 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 2843 Larkin St 7 Sidewalk: Property side : Yard Tree Private 2     3 Width 5ft   6006456.64037 2121054.20596 37.804374959703 -122.421894621951 (37.804374959703, -122.421894621951) 5 9 1 28858 32
164737 126118 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 2843 Larkin St 3 Sidewalk: Property side : Yard Tree Private 2     3 Width 5ft   6006454.20196 2121071.4643 37.8044222091763 -122.42190428698 (37.8044222091763, -122.42190428698) 5 9 1 28858 32
164903 126100 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 4 Kimball Pl 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6008010.60275 2116411.87051 37.7917157770027 -122.416188000891 (37.7917157770027, -122.416188000891) 5 1 10 28858 21
172280 52223 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1331 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/16/2005 12:00:00 AM 6   Permit Number 48403 6006656.01014 2118694.90131 37.7979081488955 -122.421037065315 (37.7979081488955, -122.421037065315) 13 9 10 28858 32
174766 126129 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 2800x Van Ness Ave 5 Median : Cutout Tree DPW 1     5 Width 6ft   6005644.09156 2120125.76706 37.8017798472085 -122.424640432904 (37.8017798472085, -122.424640432904) 5 9 1 28858 32
188611 126116 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 2843 Larkin St 1 Sidewalk: Property side : Yard Tree Private 2     35 Width 5ft   6006453.14496 2121079.48175 37.8044441634334 -122.421908514693 (37.8044441634334, -122.421908514693) 5 9 1 28858 32
194445 24428 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1501 Franklin St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/20/1995 12:00:00 AM 3 3X3   6005809.51077 2115255.80256 37.7884174936216 -122.42372154163 (37.7884174936216, -122.42372154163) 13 9 1 28858 41
150 247856 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 80 Bradford St 5 Side Yard : Yard Tree Private 2     32     6009566.84713 2098148.32022 37.7416556510973 -122.409513828008 (37.7416556510973, -122.409513828008) 10 7 7 28859 2
603 245637 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 111 Manchester St 2 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 3ft   6008273.00792 2099308.43984 37.7447685005688 -122.414069557873 (37.7447685005688, -122.414069557873) 2 7 7 28859 2
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
990 245607 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 263 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6007571 2097463 37.7396618784985 -122.416366286166 (37.7396618784985, -122.416366286166) 2 7 7 28859 2
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
3163 245541 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 499X Ogden Ave 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 4ft   6008320.69019 2096092.37783 37.7359405790823 -122.413677250212 (37.7359405790823, -122.413677250212) 2 7 7 28859 2
6119 245606 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 269 Andover St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 3ft   6007569 2097440 37.7395986131129 -122.416371572654 (37.7395986131129, -122.416371572654) 2 7 7 28859 2
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
9061 245544 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 2020 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6008037.51998 2106722.39009 37.7651122930328 -122.415408600746 (37.7651122930328, -122.415408600746) 8 4 7 28859 19
9111 29980 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1622X Guerrero St 1 Median : Cutout Tree DPW 1   03/24/2007 12:00:00 AM 3 3x3   6005918.53507 2099515.50587 37.7452045332674 -122.422225595834 (37.7452045332674, -122.422225595834) 2 7 5 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
11609 245630 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 53 Appleton Ave 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   6005628.85756 2097048.73767 37.7384150016563 -122.42305195408 (37.7384150016563, -122.42305195408) 2 7 7 28859 2
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
17008 29712 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1594X Guerrero St 7 Median : Cutout Tree DPW 1   03/30/2006 12:00:00 AM 6     6005909.34325 2099821.50359 37.7460442149832 -122.422279116311 (37.7460442149832, -122.422279116311) 2 7 5 28859 22
18720 245646 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 491 Bartlett St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6006820.96537 2100970.13931 37.7492494886697 -122.419208304739 (37.7492494886697, -122.419208304739) 2 4 7 28859 19
20085 30016 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 750X San Jose Ave 8 Median : Cutout Tree DPW 1   03/24/2007 12:00:00 AM 3 3x3   6005691.52892 2098774.02454 37.7431557868143 -122.422957855325 (37.7431557868143, -122.422957855325) 2 7 7 28859 2
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
23326 245667 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 33 Valley St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6005668.95498 2099318.86171 37.7446505122149 -122.423074627805 (37.7446505122149, -122.423074627805) 2 7 5 28859 22
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
26972 245608 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 669 Ellsworth St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007971.01243 2095757.87168 37.7350024558046 -122.414862562055 (37.7350024558046, -122.414862562055) 2 7 7 28859 2
26987 245560 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 2895 Harrison St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6009015.34966 2101644.53277 37.7512245599714 -122.41166770072 (37.7512245599714, -122.41166770072) 2 4 7 28859 19
27907 108600 Permitted Site 7 Cordyline australis :: Dracena Palm 64 47 Manchester St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/2014 12:00:00 AM 3 3x3 Permit Number 774588 6008247.58165 2099751.34896 37.7459832024183 -122.41418880701 (37.7459832024183, -122.41418880701) 2 7 7 28859 2
29355 245611 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 144 Bronte St 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 3ft   6009288.92711 2096649.46707 37.7375245496104 -122.410368978947 (37.7375245496104, -122.410368978947) 10 7 7 28859 2
29554 245643 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 397 San Jose Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 5ft   6006236.48715 2100897.99969 37.7490184762356 -122.421224322147 (37.7490184762356, -122.421224322147) 2 4 5 28859 19
29647 245552 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1187 South Van Ness Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6007687.51516 2102781.67448 37.7542723174215 -122.41634004478 (37.7542723174215, -122.41634004478) 2 4 7 28859 19
30956 245626 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 322 Elsie St 10 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6006348.59893 2096985.53448 37.7382820485678 -122.420558948829 (37.7382820485678, -122.420558948829) 2 7 7 28859 2
31424 245622 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 45 Aztec St 1 Sidewalk: Property side : Yard Tree Private 2     48 Width 3ft   6007740.56347 2099594.44436 37.745523885229 -122.415930903595 (37.745523885229, -122.415930903595) 2 7 7 28859 2
32281 245499 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 290 Mullen Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6010401.30335 2099970.53997 37.7467057922326 -122.406756935608 (37.7467057922326, -122.406756935608) 2 7 7 28859 2
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
33840 30007 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 750X San Jose Ave 3 Median : Cutout Tree DPW 1   03/24/2007 12:00:00 AM 3 3x3   6005678.3438 2098731.55781 37.7430384387857 -122.42300042833 (37.7430384387857, -122.42300042833) 2 7 7 28859 2
34073 29992 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 681X San Jose Ave 7 Median : Cutout Tree DPW 1   03/24/2007 12:00:00 AM 3 3x3   6005877.58141 2099371.3233 37.7448063305595 -122.422356964316 (37.7448063305595, -122.422356964316) 2 7 5 28859 2
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
37986 245636 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 105 Manchester St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6008273.01473 2099327.11999 37.7448197924968 -122.414070855604 (37.7448197924968, -122.414070855604) 2 7 7 28859 2
40523 245558 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 2895 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6009016.51977 2101624.75591 37.7511703227723 -122.411662257123 (37.7511703227723, -122.411662257123) 2 4 7 28859 19
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
43803 245562 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 2445 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6008870.65753 2104208.97793 37.7582578303569 -122.41234930408 (37.7582578303569, -122.41234930408) 2 4 7 28859 19
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

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