trees
3,965 rows where qSpecies_id = 70 sorted by Supervisor Districts descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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) );