trees
3,965 rows where qSpecies_id = 70 sorted by Police Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22279 | 187708 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 51 Executive Park Blvd | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 4ft | 6013663.58022 | 2087013.01188 | 37.7113090475516 | -122.394569030961 | (37.7113090475516, -122.394569030961) | 10 | 3 | 8 | 58 | 1 | |||
| 22625 | 188658 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 100 Cargo Way | 124 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 6016703.96276 | 2099238.37904 | 37.7450460592258 | -122.384911766374 | (37.7450460592258, -122.384911766374) | 10 | 3 | 8 | 58 | 1 | ||||
| 22704 | 188665 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2175X Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 37 | 6011669.71313 | 2097723.45025 | 37.7406066539877 | -122.402212916691 | (37.7406066539877, -122.402212916691) | 10 | 3 | 8 | 58 | 1 | ||||
| 23652 | 6630 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1415 Evans Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x3 | 6016668.82436 | 2097716.7125 | 37.7408659294107 | -122.384927277883 | (37.7408659294107, -122.384927277883) | 10 | 3 | 8 | 58 | 1 | |||
| 24282 | 188748 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 150 Executive Park Blvd | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 3ft | 6013906.67984 | 2086991.4991 | 37.7112634896854 | -122.393727305964 | (37.7112634896854, -122.393727305964) | 10 | 3 | 8 | 58 | 1 | |||
| 25027 | 188574 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 Pennsylvania Ave | 24 | Front Yard : Yard | Tree | Private 2 | 1 | 6014321.12378 | 2106534.34369 | 37.7649471289393 | -122.39366181916 | (37.7649471289393, -122.39366181916) | 14 | 3 | 8 | 310 | 29 | ||||
| 25108 | 97979 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 9 | Front Yard : Yard | Tree | Private 2 | 17 | 3x105 | Permit Number 767976 | 6008557.48708 | 2094193.99719 | 37.730741330332 | -122.412724380735 | (37.730741330332, -122.412724380735) | 9 | 3 | 7 | 309 | 28 | ||
| 25423 | 188757 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 151 Executive Park Blvd | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 3ft | 6013913.01216 | 2087043.89659 | 37.711407714869 | -122.393709084803 | (37.711407714869, -122.393709084803) | 10 | 3 | 8 | 58 | 1 | |||
| 25505 | 188633 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 151 Helena St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6010969.7403 | 2096191.55002 | 37.7363612864506 | -122.40452535877 | (37.7363612864506, -122.40452535877) | 10 | 3 | 8 | 58 | 1 | ||||
| 25538 | 97980 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 10 | Front Yard : Yard | Tree | Private 2 | 3x105 | Permit Number 767976 | 6008582.5 | 2094142.5 | 37.7306013339748 | -122.412634267782 | (37.7306013339748, -122.412634267782) | 9 | 3 | 7 | 309 | 28 | |||
| 25600 | 188606 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1150 19th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 26 | Width 4ft | 6014179.73832 | 2105282.17122 | 37.761501079734 | -122.3940631731 | (37.761501079734, -122.3940631731) | 10 | 3 | 8 | 28856 | 29 | |||
| 25896 | 187702 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 51 Executive Park Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6013770.9191 | 2087051.91118 | 37.7114218243198 | -122.394200759471 | (37.7114218243198, -122.394200759471) | 10 | 3 | 8 | 58 | 1 | |||
| 26769 | 175069 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 Woolsey St | 6 | Side Yard : Yard | Tree | Private 2 | 20 | 6011573.1556 | 2092162.22602 | 37.7253313074768 | -122.402155892479 | (37.7253313074768, -122.402155892479) | 10 | 3 | 7 | 309 | 28 | ||||
| 27223 | 188681 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2 Middle Point Rd | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 6018210.72448 | 2096306.49238 | 37.7370789094531 | -122.379497963675 | (37.7370789094531, -122.379497963675) | 10 | 3 | 8 | 58 | 1 | ||||
| 27347 | 187768 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1442 Galvez Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6016135.99542 | 2097500.75828 | 37.740243477167 | -122.3867545627 | (37.740243477167, -122.3867545627) | 10 | 3 | 8 | 58 | 1 | |||
| 27485 | 173729 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 994 Carolina St | 2 | Median : Cutout | Tree | DPW 1 | 6 | 3x3 | 6012439 | 2103318 | 37.7560109950145 | -122.399945772243 | (37.7560109950145, -122.399945772243) | 10 | 3 | 8 | 28856 | 29 | |||
| 27962 | 110465 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1485 FAIRFAX AVE | 2 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 9 | 3x3 | 6016296 | 2097688 | 37.7407664622153 | -122.386214376382 | (37.7407664622153, -122.386214376382) | 10 | 3 | 8 | 58 | 1 | |||
| 28284 | 188619 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3601 03rd St | 17 | : | Tree | Private 2 | 18 | Width 3ft | 6015998.57647 | 2098868.23914 | 37.7439906904264 | -122.387325073699 | (37.7439906904264, -122.387325073699) | 10 | 3 | 8 | 58 | 1 | |||
| 28295 | 3742 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 450X Cargo Way | 1 | Median : Cutout | Tree | DPW 1 | 12 | 8 | 6016957.733924 | 2099023.86587 | 37.7444710828997 | -122.38401932754 | (37.7444710828997, -122.38401932754) | 10 | 3 | 8 | 58 | 1 | |||
| 28393 | 175015 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 81 Gillette Ave | 5 | Front Yard : Yard | Tree | Private 2 | 22 | Width 8ft | 6013189.92411 | 2087076.36729 | 37.7114566649583 | -122.39621055537 | (37.7114566649583, -122.39621055537) | 10 | 3 | 8 | 309 | 1 | |||
| 28632 | 188571 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 Pennsylvania Ave | 19 | Front Yard : Yard | Tree | Private 2 | 1 | 6014323.12928 | 2106506.58009 | 37.764871007621 | -122.393652939236 | (37.764871007621, -122.393652939236) | 14 | 3 | 8 | 310 | 29 | ||||
| 28712 | 97224 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301X Newcomb Ave | 4 | Median : Cutout | Tree | DPW 1 | 09/30/2011 12:00:00 AM | 6 | 15x200 | 6016653.04222 | 2094950.9325 | 37.733270780627 | -122.384789221155 | (37.733270780627, -122.384789221155) | 10 | 3 | 8 | 58 | 1 | ||
| 28824 | 188743 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250x Executive Park Blvd | 11 | Median : Yard | Tree | DPW 1 | 22 | Width 8ft | 6014538.0462 | 2086963.8159 | 37.711222541749 | -122.391543193559 | (37.711222541749, -122.391543193559) | 10 | 3 | 8 | 58 | 1 | |||
| 28825 | 30290 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 861 Bowdoin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/1956 12:00:00 AM | Permit Number 134 | 6009266.77435284 | 2092132.72070272 | 37.725121286809 | -122.410126783708 | (37.725121286809, -122.410126783708) | 9 | 3 | 7 | 309 | 28 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 37625 | 175067 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 800 Thornton Ave | 2 | Side Yard : Yard | Tree | Private 2 | 26 | 6010979.40226 | 2094033.66945 | 37.7304367416449 | -122.404340115499 | (37.7304367416449, -122.404340115499) | 10 | 3 | 7 | 309 | 28 | ||||
| 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 | |||
| 38725 | 97974 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2011 12:00:00 AM | 14 | 3x3 | Permit Number 767976 | 6008567.92648 | 2094152.82902 | 37.7306288773042 | -122.412685380727 | (37.7306288773042, -122.412685380727) | 9 | 3 | 7 | 309 | 28 | |
| 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 | |||
| 39911 | 97975 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 5 | Front Yard : Yard | Tree | Private 2 | 10 | 3x105 | Permit Number 767976 | 6008564.43786 | 2094166.6254 | 37.7306665633988 | -122.412698416414 | (37.7306665633988, -122.412698416414) | 9 | 3 | 7 | 309 | 28 | ||
| 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 | |||
| 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 | |||
| 47940 | 97971 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 325 Bowdoin St | 1 | Front Yard : Yard | Tree | Private 2 | 4 | 3x105 | 6008579.18793 | 2094106.30305 | 37.7305017590298 | -122.412643160269 | (37.7305017590298, -122.412643160269) | 9 | 3 | 7 | 309 | 28 | |||
| 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 | ||||
| 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 |
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) );