3,965 rows where qSpecies_id = 70 sorted by Supervisor Districts descending

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)
29162 188675 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1298 Fairfax Ave 5 : Tree Private 2     21 Width 4ft   6017168.99246 2097078.35566 37.739140782423 -122.383153445176 (37.739140782423, -122.383153445176) 10 3 8 58 1
29177 187712 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 51x Executive Park Blvd 3 Median : Yard Tree DPW 1     10 Width 8ft   6013733.01886 2087017.85621 37.7113262093072 -122.394329370613 (37.7113262093072, -122.394329370613) 10 3 8 58 1
29316 200553 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1400x La Salle Ave 29 Median : Cutout Tree DPW 1     6 Width 0ft   6016224.313 2095613.1578 37.7350653972301 -122.386317623483 (37.7350653972301, -122.386317623483) 10 3 8 58 1
29679 187742 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 200 Cashmere St 3 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 4ft   6016301.16013 2096254.5278 37.7368307235506 -122.38609662946 (37.7368307235506, -122.38609662946) 10 3 8 58 1
29769 200551 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1400x La Salle Ave 27 Median : Cutout Tree DPW 1     15 Width 0ft   6016216.4893 2095621.6927 37.735088399287 -122.38634526793 (37.735088399287, -122.38634526793) 10 3 8 58 1
30644 188724 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 961 Le Conte Ave 3 Sidewalk: Curb side : Yard Tree Private 2     8     6013382.05808 2089359.66984 37.7177368520568 -122.395706366661 (37.7177368520568, -122.395706366661) 10 3 8 58 1
30744 187733 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 97 Whitney Young Cir 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 4ft   6016669.55687 2095074.42086 37.7336107684215 -122.384740724326 (37.7336107684215, -122.384740724326) 10 3 8 58 1
30838 188697 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1301 Evans Ave 13 : Tree DPW 1     15 Width 3ft   6017236.81305 2097292.98379 37.7397338556296 -122.38293388291 (37.7397338556296, -122.38293388291) 10 3 8 58 1
30846 220142 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2300 22nd St 4 Sidewalk: Curb side : Yard Tree Private 2     7     6011259.06651 2103712.6119 37.7570286576638 -122.40405416618 (37.7570286576638, -122.40405416618) 10 4 8 28859 19
31144 187736 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 301x Cashmere St 2 Median : Yard Tree DPW 1     15     6016350.44721 2096194.42304 37.7366684157019 -122.385922032401 (37.7366684157019, -122.385922032401) 10 3 8 58 1
31158 117161 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 1383X VERMONT ST 1 Front Yard : Cutout Tree Private 2           6011571 2102081 37.7525660338429 -122.402860625738 (37.7525660338429, -122.402860625738) 10 3 8 28856 29
31259 187699 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 150x Executive Park Blvd 8 Median : Yard Tree DPW 1     24 Width 8ft   6014113.89856 2087000.13929 37.7112987269205 -122.393011704639 (37.7112987269205, -122.393011704639) 10 3 8 58 1
31471 6631 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1415 Evans Ave 14 Sidewalk: Curb side : Cutout Tree Fire Dept 16   02/15/2001 12:00:00 AM 18 3x3   6016617.7688071 2097746.8662364 37.740945901362 -122.385105911093 (37.740945901362, -122.385105911093) 10 3 8 58 1
32089 106242 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 580 De Haro St 5 Sidewalk: Property side : Yard Tree Private 2     6   Permit Number 770844 6012041.04445 2105749.16688 37.7626642466674 -122.401492899679 (37.7626642466674, -122.401492899679) 8 3 8 28856 29
32225 121022 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 200 Executive Park Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2           6014230 2086988 37.7112718434151 -122.392609576957 (37.7112718434151, -122.392609576957) 10 3 8 58 1
32259 22143 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3795X 03rd St 28 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6015845.49183 2098416.12541 37.7427407998196 -122.387822870352 (37.7427407998196, -122.387822870352) 10 3 8 58 1
32513 187739 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 301x Cashmere St 18 Median : Yard Tree DPW 1     26     6016069.71075 2096081.97327 37.736344111196 -122.386884828594 (37.736344111196, -122.386884828594) 10 3 8 58 1
32564 187777 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1215 Fairfax Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     26 Width 4ft   6017388.24402 2096830.64368 37.7384727282386 -122.382378135159 (37.7384727282386, -122.382378135159) 10 3 8 58 1
32807 175020 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 500x Mansell St 11 Median : Cutout Tree DPW 1     12 Width 0ft   6010396.84323 2090323.76583 37.7202175482911 -122.406092851014 (37.7202175482911, -122.406092851014) 10 3 8 309 28
33047 22138 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3795X 03rd St 23 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016046.66974 2099009.45744 37.7443811102106 -122.387168624728 (37.7443811102106, -122.387168624728) 10 3 8 58 1
33139 188693 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1350 Evans Ave 2 : Tree Private 2     20 Width 4ft   6016935.69851 2097636.39062 37.7406601393594 -122.383998925709 (37.7406601393594, -122.383998925709) 10 3 8 58 1
33296 24143 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 100X Whitney Young Cir 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6016705.20951 2095147.06572 37.7338122084672 -122.38462252012 (37.7338122084672, -122.38462252012) 10 3 8 58 1
33615 188702 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1501 Evans Ave 2 : Tree DPW 1     17 Width 4ft   6015994.71985 2098219.31717 37.7422086702947 -122.387293152263 (37.7422086702947, -122.387293152263) 10 3 8 58 1
33714 188705 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1998 Revere Ave 2 Side Yard : Yard Tree Private 2     3     6013030.362 2095929.4873 37.7357566623473 -122.397382506903 (37.7357566623473, -122.397382506903) 10 3 8 58 1
34562 187770 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 600 Newhall St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6015810.36395 2097629.59128 37.7405791922653 -122.387889463049 (37.7405791922653, -122.387889463049) 10 3 8 58 1
34698 188634 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 151 Helena St 2 Sidewalk: Curb side : Yard Tree Private 2     5     6010981.22837 2096191.91786 37.7363629384827 -122.404485665384 (37.7363629384827, -122.404485665384) 10 3 8 58 1
34893 200562 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1400x La Salle Ave 38 Median : Cutout Tree DPW 1     13 Width 0ft   6016315.2256 2095489.7997 37.7347317124513 -122.385994706933 (37.7347317124513, -122.385994706933) 10 3 8 58 1
35108 3688 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 200X Cargo Way 2 Median : Cutout Tree Port 6     18 8   6017218.5539168 2098854.5663776 37.7440206368399 -122.383105675332 (37.7440206368399, -122.383105675332) 10 3 8 58 1
35242 24203 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 80X Whitney Young Cir 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6016364.4746918 2096121.5533418 37.736469106467 -122.385868455165 (37.736469106467, -122.385868455165) 10 3 8 58 1
35347 3691 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 200X Cargo Way 5 Median : Cutout Tree Port 6     12 8   6017218.5539168 2098854.5663776 37.7440206368399 -122.383105675332 (37.7440206368399, -122.383105675332) 10 3 8 58 1
35458 115141 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 101 EXECUTIVE PARK BLVD 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013586 2086931 37.7110795456085 -122.394831429854 (37.7110795456085, -122.394831429854) 10 3 8 58 1
35467 24214 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 80X Whitney Young Cir 15 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6016364.4746918 2096121.5533418 37.736469106467 -122.385868455165 (37.736469106467, -122.385868455165) 10 3 8 58 1
35762 3690 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 200X Cargo Way 4 Median : Cutout Tree Port 6     12 8   6017218.5539168 2098854.5663776 37.7440206368399 -122.383105675332 (37.7440206368399, -122.383105675332) 10 3 8 58 1
35903 105966 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 290X Arkansas St 11 Sidewalk: Curb side : Cutout Tree Private 2           6012903.22107 2105890.09903 37.7630992845925 -122.398520809474 (37.7630992845925, -122.398520809474) 14 3 8 28856 29
36319 188754 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 151 Executive Park Blvd 3 Sidewalk: Curb side : Yard Tree Private 2     13 Width 3ft   6014012.04613 2087036.35407 37.7113925073379 -122.393366267763 (37.7113925073379, -122.393366267763) 10 3 8 58 1
36882 96532 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 1X Raymond Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     16 5x5   6011122.2 2087240.2 37.7117912459807 -122.403368705104 (37.7117912459807, -122.403368705104) 9 7 8 309 39
37172 188573 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 101 Pennsylvania Ave 23 Front Yard : Yard Tree Private 2     2     6014313.95748 2106525.31857 37.7649219497227 -122.393685974041 (37.7649219497227, -122.393685974041) 14 3 8 310 29
37307 1710 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 5 Bass Ct 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6016578.92227 2095125.73941 37.7337466658568 -122.385057651709 (37.7337466658568, -122.385057651709) 10 3 8 58 1
37495 18550 Landmark tree 11 Acacia melanoxylon :: Blackwood Acacia 70 1700X Quesada Ave 5 Median : Cutout Tree DPW 1     30 19   6014656.2717 2095062.29209 37.733465912826 -122.391700443637 (37.733465912826, -122.391700443637) 10 3 8 58 1
38134 175024 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 11 Raymond Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6011045.77873 2087277.95122 37.7118906346058 -122.403635493987 (37.7118906346058, -122.403635493987) 9 7 8 309 39
38350 24195 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 55X Whitney Young Cir 11 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6016412.1769872 2096105.6107164 37.736427970914 -122.38570241579 (37.736427970914, -122.38570241579) 10 3 8 58 1
38820 16539 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1420X Evans Ave 12 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016303.7553 2098109.62008 37.7419245742859 -122.38621694766 (37.7419245742859, -122.38621694766) 10 3 8 58 1
38953 3694 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 400X Cargo Way 1 Median : Cutout Tree DPW 1     12 8   6017199.673909 2098835.752969 37.7439679357533 -122.383169649574 (37.7439679357533, -122.383169649574) 10 3 8 58 1
39243 110886 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 800 INDIANA ST 20 Sidewalk: Property side : Yard Tree Private 2           6014913.4 2104437.2 37.7592217202179 -122.391466645187 (37.7592217202179, -122.391466645187) 10 3 8 28856 29
39400 97226 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1301X Newcomb Ave 6 Median : Cutout Tree DPW 1   09/30/2011 12:00:00 AM 3 15x200   6016643.51258 2094941.12769 37.7332433315076 -122.384821485239 (37.7332433315076, -122.384821485239) 10 3 8 58 1
39608 24202 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 80X Whitney Young Cir 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x5   6016364.4746918 2096121.5533418 37.736469106467 -122.385868455165 (37.736469106467, -122.385868455165) 10 3 8 58 1
39635 175016 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 81 Gillette Ave 6 Front Yard : Yard Tree Private 2     12 Width 8ft   6013191.1859 2087080.9939 37.7114694389303 -122.396206518314 (37.7114694389303, -122.396206518314) 10 3 8 309 1
39780 200548 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1400x La Salle Ave 24 Median : Cutout Tree DPW 1     13 Width 0ft   6016205.9984 2095634.3174 37.7351224834655 -122.386382419007 (37.7351224834655, -122.386382419007) 10 3 8 58 1
40170 24108 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 101X Whitney Young Cir 15 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6016610.88324 2095264.18914 37.7341285890533 -122.384956794538 (37.7341285890533, -122.384956794538) 10 3 8 58 1
40300 6598 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1400 Evans Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016617.02929 2097872.24997 37.7412901387305 -122.385117202121 (37.7412901387305, -122.385117202121) 10 3 8 58 1
40334 22136 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3795X 03rd St 21 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016035.60199 2098975.53182 37.7442873445309 -122.387204529113 (37.7442873445309, -122.387204529113) 10 3 8 58 1
40581 6463 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1200X Evans Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6017761.74901 2097023.16401 37.7390219747502 -122.381100103845 (37.7390219747502, -122.381100103845) 10 3 8 58 1
40653 6493 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1200X Evans Ave 35 Sidewalk: Curb side : Cutout Tree DPW 1   02/15/2001 12:00:00 AM 12 3x3   6017084.24401 2097528.90701 37.7403732221604 -122.38347782646 (37.7403732221604, -122.38347782646) 10 3 8 58 1
41490 6632 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1415 Evans Ave 15 Sidewalk: Curb side : Cutout Tree Fire Dept 16     18 3x3   6016617.7688071 2097746.8662364 37.740945901362 -122.385105911093 (37.740945901362, -122.385105911093) 10 3 8 58 1
42027 188598 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1050 Wisconsin St 4 : Tree Private 2     18 Width 5ft   6012781.12633 2102535.65122 37.7538819037331 -122.398707676819 (37.7538819037331, -122.398707676819) 10 3 8 28856 29
42718 6479 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1200X Evans Ave 21 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6017436.11701 2097265.30001 37.7396688516514 -122.382242842132 (37.7396688516514, -122.382242842132) 10 3 8 58 1
43206 187735 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 299x Cashmere St 23 Median : Yard Tree DPW 1     21     6016637.03713 2096003.63788 37.7361604138763 -122.384917870088 (37.7361604138763, -122.384917870088) 10 3 8 58 1
43411 6580 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1337 Evans Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6017048.7081546 2097427.5062586 37.7400928320588 -122.383593638958 (37.7400928320588, -122.383593638958) 10 3 8 58 1
43641 200538 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1400x La Salle Ave 14 Median : Cutout Tree DPW 1     7 Width 0ft   6016175.1953 2095654.7768 37.7351769557335 -122.386490343499 (37.7351769557335, -122.386490343499) 10 3 8 58 1
43870 188564 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 300 Vermont St 4 Back Yard : Yard Tree Private 2     21     6011131.87643 2106822.77201 37.7655613532939 -122.404712987912 (37.7655613532939, -122.404712987912) 8 3 8 28853 19
44010 8228 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1500X Galvez Ave 7 Sidewalk: Curb side : Cutout Tree DPW 1     24 3x3   6016396.247314 2097296.3974116 37.7396967491289 -122.385840466933 (37.7396967491289, -122.385840466933) 10 3 8 58 1
44618 175041 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2 Burr Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 2ft   6007781.09007 2086643.56012 37.7099658201356 -122.414874335982 (37.7099658201356, -122.414874335982) 9 7 8 309 39
44628 188723 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 961 Le Conte Ave 1 Sidewalk: Curb side : Yard Tree Private 2     7     6013346.44573 2089388.27628 37.7178134185452 -122.395831466855 (37.7178134185452, -122.395831466855) 10 3 8 58 1
44642 187763 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 135 Reardon Rd 2 Sidewalk: Property side : Yard Tree Private 2     25     6018954.68397 2093453.67115 37.7292866202724 -122.376727902495 (37.7292866202724, -122.376727902495) 10 3 8 58 1
45493 200568 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1400x La Salle Ave 40 Median : Cutout Tree DPW 1     13 Width 0ft   6016324.0126 2095472.2809 37.7346840956345 -122.385963106208 (37.7346840956345, -122.385963106208) 10 3 8 58 1
45747 201375 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2 Fairfax Ave 1 Sidewalk: Property side : Yard Tree Private 2     26     6018327.36542 2095666.89439 37.7353291318294 -122.379050271262 (37.7353291318294, -122.379050271262) 10 3 8 58 1
46007 6753 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1215 Fairfax Ave 7 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6017521.0990665 2096743.3718322 37.7382404347673 -122.381912713319 (37.7382404347673, -122.381912713319) 10 3 8 58 1
47175 24120 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 99X Whitney Young Cir 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3x3   6016647.77235 2095170.83896 37.7338743084492 -122.384822755067 (37.7338743084492, -122.384822755067) 10 3 8 58 1
47669 200540 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1400x La Salle Ave 16 Median : Cutout Tree DPW 1     3 Width 0ft   6016179.8101 2095650.1621 37.7351645401576 -122.386474066655 (37.7351645401576, -122.386474066655) 10 3 8 58 1
48195 24226 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 60 Whitney Young Cir 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 4X4   6017135.66368 2094974.09134 37.7333610509772 -122.383122261179 (37.7333610509772, -122.383122261179) 10 3 8 58 1
48525 188644 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 150x Cargo Way 4 Median : Yard Tree DPW 1     27     6018318.49597 2097930.97465 37.7415453582258 -122.379238145042 (37.7415453582258, -122.379238145042) 10 3 8 58 1
49122 175035 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 177 Desmond St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6010415.17043 2086409.01493 37.7094694645007 -122.405753896527 (37.7094694645007, -122.405753896527) 9 7 8 309 39
49272 6597 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1400 Evans Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016636.56192 2097857.72926 37.7412513482773 -122.385048653076 (37.7412513482773, -122.385048653076) 10 3 8 58 1
49519 188657 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 100 Cargo Way 123 Sidewalk: Curb side : Yard Tree Private 2     12     6016750.16767 2099204.87087 37.7449566081772 -122.384749662688 (37.7449566081772, -122.384749662688) 10 3 8 58 1
49610 6423 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1100X Evans Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1     10 3x3   6018250.03314 2096623.41897 37.7379512950012 -122.379384062749 (37.7379512950012, -122.379384062749) 10 3 8 58 1
49681 116977 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 100x CARGO WAY 117 Front Yard : Yard Tree PUC 8 DPW for City Agency         6019010 2097405 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394) 10 3 8 58 1
49985 22122 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3795X 03rd St 7 Sidewalk: Curb side : Cutout Tree DPW 1   02/04/1992 12:00:00 AM 12 3X3   6015918.06732 2098587.02802 37.743214083448 -122.387583843416 (37.743214083448, -122.387583843416) 10 3 8 58 1
50488 188621 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3601 03rd St 19 : Tree Private 2     13 Width 3ft   6016020.78117 2098934.45484 37.7441737348321 -122.387252912086 (37.7441737348321, -122.387252912086) 10 3 8 58 1
51248 188655 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 300x Cargo Way 5 Median : Yard Tree DPW 1     22     6017659.9469 2098420.67777 37.7428536469791 -122.381549254301 (37.7428536469791, -122.381549254301) 10 3 8 58 1
51401 107045 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 1622X MCKINNON AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6015259 2096017 37.7361207862805 -122.389683281146 (37.7361207862805, -122.389683281146) 10 3 8 58 1
51410 187757 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1040 Palou Ave 8 Sidewalk: Property side : Yard Tree Private 2     23     6017577.45499 2093289.42876 37.7287597011768 -122.38147773753 (37.7287597011768, -122.38147773753) 10 3 8 58 1
51426 188679 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 2 Middle Point Rd 2 Sidewalk: Curb side : Yard Tree Private 2     8     6018264.75043 2096477.95592 37.7375526939091 -122.379323076118 (37.7375526939091, -122.379323076118) 10 3 8 58 1
51613 200518 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1400x La Salle Ave 1 Median : Cutout Tree DPW 1     18 Width 0ft   6016087.5147 2095748.7503 37.7354301338826 -122.386800041299 (37.7354301338826, -122.386800041299) 10 3 8 58 1
52580 187748 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1322 Hudson Ave 49 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6017296.56701 2095239.40453 37.734098438398 -122.382584422552 (37.734098438398, -122.382584422552) 10 3 8 58 1
53098 188733 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 250 Executive Park Blvd 1 : Tree Private 2     8 Width 8ft   6014289.08954 2086985.67825 37.7112687498269 -122.392405184751 (37.7112687498269, -122.392405184751) 10 3 8 58 1
53428 188617 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3601 03rd St 14 : Tree Private 2     10 Width 3ft   6015982.63525 2098803.51641 37.7438120922536 -122.387375681249 (37.7438120922536, -122.387375681249) 10 3 8 58 1
53567 188668 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1401 Fairfax Ave 4 : Tree Private 2     20 Width 3ft   6016461.41384 2097522.46714 37.7403210967391 -122.38563089846 (37.7403210967391, -122.38563089846) 10 3 8 58 1
54214 188603 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1801 22nd St 6 : Tree Private 2     11 Width 3ft   6012672.24718 2103750.00011 37.7572101741252 -122.399169443623 (37.7572101741252, -122.399169443623) 10 3 8 28856 29
54401 28708 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1200X Evans Ave 14 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6017551.81801 2097178.22601 37.7394361536971 -122.38183673875 (37.7394361536971, -122.38183673875) 10 3 8 58 1
54548 28654 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1275 Evans Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   03/25/2004 12:00:00 AM 3 6x3   6017442.42343 2097139.52518 37.739323847514 -122.38221228939 (37.739323847514, -122.38221228939) 10 3 8 58 1
54987 187761 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1040 Palou Ave 12 Sidewalk: Property side : Yard Tree Private 2     24     6017511.07328 2093334.48306 37.7288797462969 -122.381710357951 (37.7288797462969, -122.381710357951) 10 3 8 58 1
55185 187706 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 51 Executive Park Blvd 5 Sidewalk: Curb side : Yard Tree Private 2     8 Width 4ft   6013695.62833 2087031.11322 37.7113605319472 -122.394459530409 (37.7113605319472, -122.394459530409) 10 3 8 58 1
55387 3865 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 220 Cashmere St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3X4   6016069.3729239 2096169.6764515 37.7365849077155 -122.386892111244 (37.7365849077155, -122.386892111244) 10 3 8 58 1
56156 187741 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 198 Cashmere St 1 Sidewalk: Curb side : Cutout Tree Private 2     25 Width 4ft   6016390.28523 2096223.19416 37.7367496199859 -122.385786298601 (37.7367496199859, -122.385786298601) 10 3 8 58 1
56174 22129 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 3795X 03rd St 14 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6015845.49183 2098416.12541 37.7427407998196 -122.387822870352 (37.7427407998196, -122.387822870352) 10 3 8 58 1
56232 6621 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 1415 Evans Ave 4 Sidewalk: Curb side : Cutout Tree Fire Dept 16     18 3x3   6016617.7688071 2097746.8662364 37.740945901362 -122.385105911093 (37.740945901362, -122.385105911093) 10 3 8 58 1
56627 111324 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1X Peabody St 4 Sidewalk: Curb side : Cutout Tree Private 2     13     6010207.43823 2087366.89683 37.7120879953496 -122.406539311355 (37.7120879953496, -122.406539311355) 9 7 8 309 39
57020 188589 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 580 De Haro St 11 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 3ft   6012060.54912 2105668.61761 37.7624441646018 -122.401419778502 (37.7624441646018, -122.401419778502) 8 3 8 28856 29
57172 6797 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1375 Fairfax Ave 6 Sidewalk: Curb side : Cutout Tree DPW 1   06/30/2011 12:00:00 AM 3     6016896.75135 2097199.75019 37.7394590596789 -122.384103192232 (37.7394590596789, -122.384103192232) 10 3 8 58 1
57249 187780 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 230 Middle Point Rd 3 Side Yard : Yard Tree Private 2     4 Width 6ft   6018250.04699 2096453.90064 37.7374858320104 -122.379372242948 (37.7374858320104, -122.379372242948) 10 3 8 58 1

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