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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 152037 | 125299 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 822 Pacific Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6010044.08646 | 2118168.03346 | 37.7966519030275 | -122.409276111123 | (37.7966519030275, -122.409276111123) | 3 | 1 | 10 | 308 | 4 | |||
| 153545 | 13067 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 610 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 45 | 2X2 | 6009404.55183 | 2120549.65161 | 37.803155386878 | -122.4116574143 | (37.803155386878, -122.4116574143) | 3 | 1 | 10 | 308 | 23 | |||
| 154473 | 142986 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 291 Chestnut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6010426.2416 | 2120953.9134 | 37.8043226486754 | -122.40815034039 | (37.8043226486754, -122.40815034039) | 3 | 1 | 10 | 308 | 23 | |||
| 155687 | 143328 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 771 BROADWAY | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6009985.9573 | 2118455.2859 | 37.7974373711207 | -122.409497535433 | (37.7974373711207, -122.409497535433) | 3 | 1 | 10 | 308 | 4 | |||
| 156023 | 115444 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 99x Vandewater St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5X3 | 6009122.65313 | 2121320.70167 | 37.8052566803806 | -122.412687477249 | (37.8052566803806, -122.412687477249) | 3 | 1 | 10 | 308 | 23 | ||||
| 157269 | 125301 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 822 Pacific Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010016.58615 | 2118164.86892 | 37.7966416732215 | -122.409371045347 | (37.7966416732215, -122.409371045347) | 3 | 1 | 10 | 308 | 4 | |||
| 157769 | 95358 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 775X Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Housing Authority 15 | DPW for City Agency | 25 | 3x3 | Permit Number 778058 | 6009884 | 2118395.5 | 37.7972675002992 | -122.409846113399 | (37.7972675002992, -122.409846113399) | 3 | 1 | 10 | 308 | 4 | |
| 158552 | 125280 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200 Greenwich St | 6 | Front Yard : Yard | Tree | Private 2 | 15 | 6006711.33718 | 2119778.11421 | 37.8008854966263 | -122.420922564536 | (37.8008854966263, -122.420922564536) | 5 | 1 | 1 | 28858 | 32 | ||||
| 158882 | 125320 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 640 Davis St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6013174.3915 | 2118673.3183 | 37.7982141737976 | -122.398479953184 | (37.7982141737976, -122.398479953184) | 3 | 1 | 10 | 28860 | 6 | |||
| 162767 | 249862 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 233 Greenwich St | 3 | Front Yard : Yard | Tree | Private 2 | 4 | Width 0ft | 6011661.36372 | 2120433.37836 | 37.8029624664958 | -122.403839424247 | (37.8029624664958, -122.403839424247) | 3 | 1 | 10 | 308 | 23 | |||
| 165575 | 125244 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1340 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008943.92506 | 2117535.50135 | 37.7948534271028 | -122.413038182973 | (37.7948534271028, -122.413038182973) | 3 | 1 | 10 | 28857 | 21 | |||
| 165756 | 104699 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 455 Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6011357.95285 | 2118999.80647 | 37.7990092725121 | -122.404788402388 | (37.7990092725121, -122.404788402388) | 3 | 1 | 10 | 308 | 23 | |||
| 166021 | 125305 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 10 Jackson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6013381 | 2118288 | 37.7971676890736 | -122.397737980255 | (37.7971676890736, -122.397737980255) | 3 | 1 | 10 | 28860 | 6 | |||
| 166441 | 125251 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1073 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6008484.56321 | 2118250.48158 | 37.7967907889218 | -122.414678266696 | (37.7967907889218, -122.414678266696) | 5 | 1 | 10 | 308 | 21 | |||
| 166953 | 74710 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 838 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/1988 12:00:00 AM | 3x3 | 6010100.08183161 | 2118181.67167684 | 37.7966924872417 | -122.409083316519 | (37.7966924872417, -122.409083316519) | 3 | 1 | 10 | 308 | 4 | |||
| 168817 | 125281 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200 Greenwich St | 7 | Front Yard : Yard | Tree | Private 2 | 13 | 6006708.63096 | 2119779.53165 | 37.8008892360157 | -122.42093202991 | (37.8008892360157, -122.42093202991) | 5 | 1 | 1 | 28858 | 32 | ||||
| 171800 | 249837 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 333 Greenwich St | 5 | Front Yard : Yard | Tree | Private 2 | 3 | Width 0ft | 6011222.46721 | 2120367.48226 | 37.8027570028893 | -122.405353598393 | (37.8027570028893, -122.405353598393) | 3 | 1 | 10 | 308 | 23 | |||
| 172324 | 23575 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3100X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6005553.25134 | 2120985.40407 | 37.8041350589572 | -122.425015980687 | (37.8041350589572, -122.425015980687) | 5 | 1 | 1 | 28858 | 32 | |||
| 174242 | 249860 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 233 Greenwich St | 1 | Front Yard : Yard | Tree | Private 2 | 12 | Width 0ft | 6011669.48421 | 2120431.50277 | 37.8029577702374 | -122.403811190928 | (37.8029577702374, -122.403811190928) | 3 | 1 | 10 | 308 | 23 | |||
| 175838 | 74557 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 838 Pacific Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/1988 12:00:00 AM | 3x3 | 6010100.08183161 | 2118181.67167684 | 37.7966924872417 | -122.409083316519 | (37.7966924872417, -122.409083316519) | 3 | 1 | 10 | 308 | 4 | |||
| 176030 | 142568 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2237 MASON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6008908.9878 | 2120990.33 | 37.804337568276 | -122.413403516875 | (37.804337568276, -122.413403516875) | 3 | 1 | 10 | 308 | 23 | |||
| 176083 | 125276 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1285 Greenwich St | 1 | Side Yard : Yard | Tree | Private 2 | 15 | 6006714.64641 | 2119759.73621 | 37.800835221824 | -122.420909807645 | (37.800835221824, -122.420909807645) | 5 | 1 | 1 | 28858 | 32 | ||||
| 176515 | 58355 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1340 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/1978 12:00:00 AM | 8 | Permit Number 17382 | 6008945.85978 | 2117518.13372 | 37.7948058484612 | -122.413030259943 | (37.7948058484612, -122.413030259943) | 3 | 1 | 10 | 28857 | 21 | ||
| 182164 | 125285 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1015 Vallejo St | 2 | Front Yard : Yard | Tree | Private 2 | 11 | 6008615.56594 | 2118630.81045 | 37.7978424372369 | -122.414251888207 | (37.7978424372369, -122.414251888207) | 5 | 1 | 10 | 308 | 21 | ||||
| 182300 | 125262 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1183 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 5ft | 6007915.7723 | 2118529.96145 | 37.797526197833 | -122.416666228872 | (37.797526197833, -122.416666228872) | 5 | 1 | 10 | 28858 | 21 | |||
| 182310 | 249861 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 233 Greenwich St | 2 | Front Yard : Yard | Tree | Private 2 | 8 | Width 0ft | 6011664.77155 | 2120432.02609 | 37.8029589438729 | -122.403827536111 | (37.8029589438729, -122.403827536111) | 3 | 1 | 10 | 308 | 23 | |||
| 183060 | 4749 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1255 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2015 12:00:00 AM | 8 | 3X3 | 6007516.58505 | 2121541.63395 | 37.8057730322633 | -122.418261164826 | (37.8057730322633, -122.418261164826) | 5 | 1 | 1 | 308 | 32 | ||
| 183295 | 125284 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1022 Vallejo St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 6008534.98172 | 2118654.3458 | 37.7979025326232 | -122.414532399365 | (37.7979025326232, -122.414532399365) | 5 | 1 | 10 | 308 | 21 | ||||
| 183403 | 112677 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 470 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2015 12:00:00 AM | 4x4 | 6010678 | 2119694 | 37.8008773296715 | -122.40719023879 | (37.8008773296715, -122.40719023879) | 3 | 1 | 10 | 308 | 23 | |||
| 183556 | 125312 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 550 Davis St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6013208.18659 | 2118424.48929 | 37.7975328312411 | -122.398345543235 | (37.7975328312411, -122.398345543235) | 3 | 1 | 10 | 28860 | 6 | |||
| 184527 | 104697 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 455 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6011289.75094 | 2118992.82516 | 37.7989862912418 | -122.405023913231 | (37.7989862912418, -122.405023913231) | 3 | 1 | 10 | 308 | 23 | |||
| 184531 | 142664 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 89 Vandewater St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6008968.9034 | 2121287.3605 | 37.80515650344 | -122.41321719022 | (37.80515650344, -122.41321719022) | 3 | 1 | 10 | 308 | 23 | |||
| 184677 | 142570 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2237 MASON ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6008911.8135 | 2120966.7828 | 37.8042730722163 | -122.413392071992 | (37.8042730722163, -122.413392071992) | 3 | 1 | 10 | 308 | 23 | |||
| 188011 | 125289 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 900 Green St | 7 | Front Yard : Yard | Tree | Private 2 | 3 | 6008651.45364 | 2119007.8784 | 37.7988797881271 | -122.414154397206 | (37.7988797881271, -122.414154397206) | 5 | 1 | 10 | 308 | 32 | ||||
| 189674 | 125282 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1151 Lombard St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6006775.37415 | 2120099.55836 | 37.8017717101681 | -122.420723801756 | (37.8017717101681, -122.420723801756) | 5 | 1 | 1 | 28858 | 32 | ||||
| 190153 | 125318 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 640 Davis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6013183.07782 | 2118614.70431 | 37.7980537176562 | -122.398445780741 | (37.7980537176562, -122.398445780741) | 3 | 1 | 10 | 28860 | 6 | |||
| 192314 | 125277 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1285 Greenwich St | 2 | Side Yard : Yard | Tree | Private 2 | 10 | 6006721.71386 | 2119753.35883 | 37.8008181095192 | -122.420884898228 | (37.8008181095192, -122.420884898228) | 5 | 1 | 1 | 28858 | 32 | ||||
| 7482 | 30852 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 99 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | 8 | 2 | 9 | 28853 | 19 | |||
| 46769 | 87049 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 139 Welsh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2007 12:00:00 AM | 13 | 3x3 | Permit Number 49986 | 6013117.93675 | 2111529.65612 | 37.7785962007824 | -122.398173856333 | (37.7785962007824, -122.398173856333) | 6 | 2 | 9 | 28856 | 34 | |
| 60256 | 188720 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 614 Minna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6009507.81407 | 2111614.31476 | 37.7786269090345 | -122.410668686132 | (37.7786269090345, -122.410668686132) | 8 | 2 | 9 | 28853 | 34 | |||
| 65092 | 188710 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 182 Spear St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6015012.51159 | 2115904.85579 | 37.7907148477575 | -122.391925766986 | (37.7907148477575, -122.391925766986) | 6 | 2 | 9 | 28855 | 6 | |||
| 71059 | 188719 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 614 Minna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009521.72099 | 2111625.38367 | 37.7786580813495 | -122.410621358415 | (37.7786580813495, -122.410621358415) | 8 | 2 | 9 | 28853 | 34 | |||
| 88710 | 188712 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 182 Spear St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6015047.01523 | 2115868.01492 | 37.7906156066842 | -122.39180380811 | (37.7906156066842, -122.39180380811) | 6 | 2 | 9 | 28855 | 6 | |||
| 103924 | 30856 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 99 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | 8 | 2 | 9 | 28853 | 19 | |||
| 114042 | 188718 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 614 Minna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009528.36406 | 2111634.33045 | 37.7786830195371 | -122.410599009337 | (37.7786830195371, -122.410599009337) | 8 | 2 | 9 | 28853 | 34 | |||
| 116029 | 104640 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 112 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 2.5x2.5 | 6009509.89326 | 2111697.52669 | 37.7788555059216 | -122.410667371323 | (37.7788555059216, -122.410667371323) | 8 | 2 | 9 | 28853 | 34 | |||
| 117900 | 30855 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 99 South Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | 8 | 2 | 9 | 28853 | 19 | |||
| 141202 | 188715 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 221 Main St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6014787.2921 | 2115709.23152 | 37.7901652027998 | -122.392691330139 | (37.7901652027998, -122.392691330139) | 6 | 2 | 9 | 28855 | 6 | |||
| 148650 | 42069 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 100X Ripley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | 10 | 3x3 | Permit Number 42381 | 6015269 | 2115673 | 37.7900924610766 | -122.391022110897 | (37.7900924610766, -122.391022110897) | 6 | 2 | 9 | 28855 | 6 |
| 150374 | 87050 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 139 Welsh St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | Permit Number 49986 | 6013132.69582 | 2111542.77268 | 37.7786330379242 | -122.398123719151 | (37.7786330379242, -122.398123719151) | 6 | 2 | 9 | 28856 | 34 | ||
| 154289 | 188713 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 221 Main St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6014826.65865 | 2115671.24883 | 37.7900630973959 | -122.392552465835 | (37.7900630973959, -122.392552465835) | 6 | 2 | 9 | 28855 | 6 | |||
| 157823 | 188714 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 221 Main St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6014809.60929 | 2115691.05583 | 37.7901165359975 | -122.392612841812 | (37.7901165359975, -122.392612841812) | 6 | 2 | 9 | 28855 | 6 | |||
| 168226 | 188709 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 182 Spear St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6014993.3762 | 2115925.05204 | 37.7907692396516 | -122.391993387893 | (37.7907692396516, -122.391993387893) | 6 | 2 | 9 | 28855 | 6 | |||
| 175152 | 188711 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 182 Spear St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6015034.4377 | 2115884.60313 | 37.7906604558597 | -122.391848486415 | (37.7906604558597, -122.391848486415) | 6 | 2 | 9 | 28855 | 6 | |||
| 175626 | 104641 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 112 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 2.5x2.5 | 6009525.15876 | 2111682.07782 | 37.7788139428406 | -122.410613470452 | (37.7788139428406, -122.410613470452) | 8 | 2 | 9 | 28853 | 34 | |||
| 175870 | 30854 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 99 South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | 8 | 2 | 9 | 28853 | 19 | |||
| 176729 | 15277 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1563X Mission St | 2 | Median : Cutout | Tree | DPW 1 | 10/28/2016 12:00:00 AM | 3 | 4X4 | Permit Number 777705 | 6007250.56082 | 2109703.40074 | 37.7732531819334 | -122.418341887077 | (37.7732531819334, -122.418341887077) | 8 | 2 | 9 | 28853 | 19 | |
| 182952 | 30857 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 99 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | 8 | 2 | 9 | 28853 | 19 | |||
| 184450 | 188717 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 139 Welsh St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6013144.74894 | 2111553.30162 | 37.7786626193181 | -122.398082761329 | (37.7786626193181, -122.398082761329) | 6 | 2 | 9 | 28856 | 34 | |||
| 186981 | 30853 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 99 South Van Ness Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1995 12:00:00 AM | Permit Number 34698 | 6007267.59353144 | 2109330.19931681 | 37.772229418327 | -122.418256503442 | (37.772229418327, -122.418256503442) | 8 | 2 | 9 | 28853 | 19 | |||
| 190117 | 188716 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 221 Main St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 5ft | 6014770.59198 | 2115729.03116 | 37.7902186405175 | -122.39275049743 | (37.7902186405175, -122.39275049743) | 6 | 2 | 9 | 28855 | 6 | |||
| 191472 | 34879 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 211 Main St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 38492 | 6014657.62995196 | 2115836.08195439 | 37.7905063026103 | -122.393148834356 | (37.7905063026103, -122.393148834356) | 6 | 2 | 9 | 28855 | 6 | ||||
| 1522 | 187744 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2x Dukes Ct | 2 | Median : Yard | Tree | DPW 1 | 3 | 6016140.58365 | 2096258.22676 | 37.7368319916033 | -122.386652075929 | (37.7368319916033, -122.386652075929) | 10 | 3 | 8 | 58 | 1 | ||||
| 2205 | 188729 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250 Executive Park Blvd | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | Width 3ft | 6014522.26252 | 2086936.69782 | 37.7111472046498 | -122.391595851594 | (37.7111472046498, -122.391595851594) | 10 | 3 | 8 | 58 | 1 | |||
| 2541 | 8258 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1550 Galvez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6015754 | 2097743 | 37.740887466773 | -122.388092261865 | (37.740887466773, -122.388092261865) | 10 | 3 | 8 | 58 | 1 | |||
| 3157 | 187766 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1500 Galvez Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 4ft | 6016303.05185 | 2097377.33964 | 37.7399138423363 | -122.38616834141 | (37.7399138423363, -122.38616834141) | 10 | 3 | 8 | 58 | 1 | |||
| 3224 | 188631 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 101 Charter Oak Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 27 | 6010953.30174 | 2096155.78186 | 37.7362621559727 | -122.404579676927 | (37.7362621559727, -122.404579676927) | 10 | 3 | 8 | 58 | 1 | ||||
| 3682 | 261986 | Significant Tree 6 | Acacia melanoxylon :: Blackwood Acacia 70 | 1500 Bancroft Ave | 3 | Front Yard : Yard | Tree | Private 2 | 6014696 | 2091834 | 37.7246038778524 | -122.391337493735 | (37.7246038778524, -122.391337493735) | 10 | 3 | 8 | 58 | 1 | |||||
| 4129 | 187747 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2x Dukes Ct | 5 | Median : Yard | Tree | DPW 1 | 08/26/2020 12:00:00 AM | 3 | 6016140.5122 | 2096271.0286 | 37.7368671389145 | -122.386653215398 | (37.7368671389145, -122.386653215398) | 10 | 3 | 8 | 58 | 1 | |||
| 4954 | 24213 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80X Whitney Young Cir | 14 | 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 | |||
| 5095 | 200603 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1400x La Salle Ave | 52 | Median : Cutout | Tree | DPW 1 | 17 | Width 0ft | 6016419.7448 | 2095144.9307 | 37.733790555057 | -122.385609317623 | (37.733790555057, -122.385609317623) | 10 | 3 | 8 | 58 | 1 | |||
| 5779 | 175064 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 68 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6007788.38725 | 2093731.97467 | 37.7294295189361 | -122.415350591757 | (37.7294295189361, -122.415350591757) | 9 | 3 | 7 | 309 | 28 | |||
| 5814 | 8259 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1555 Galvez Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 6015926.8812 | 2097574.6055 | 37.7404346667176 | -122.387482752719 | (37.7404346667176, -122.387482752719) | 10 | 3 | 8 | 58 | 1 | |||
| 6378 | 6740 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1300X Fairfax Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
| 7677 | 258687 | Property Tree 8 | Acacia melanoxylon :: Blackwood Acacia 70 | 100x Whitney Young Cir | 9 | Sidewalk: Curb side : Yard | Tree | SFUSD 4 | 3x3 | 6016360 | 2096059 | 37.7362970999571 | -122.385879567348 | (37.7362970999571, -122.385879567348) | 10 | 3 | 8 | 58 | 1 | ||||
| 8626 | 188622 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3601 03rd St | 20 | : | Tree | Private 2 | 16 | Width 3ft | 6016025.72974 | 2098951.35828 | 37.7442204222503 | -122.387236979699 | (37.7442204222503, -122.387236979699) | 10 | 3 | 8 | 58 | 1 | |||
| 8962 | 116061 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2100x 19th St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 16 | 3x3 | 6011385.89017 | 2105128.48272 | 37.7609234092204 | -122.403715181115 | (37.7609234092204, -122.403715181115) | 10 | 3 | 8 | 28856 | 29 | ||
| 9851 | 187722 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 65 Whitney Young Cir | 25 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 3ft | 6017248.25374 | 2094957.00254 | 37.7333203494413 | -122.382731813344 | (37.7333203494413, -122.382731813344) | 10 | 3 | 8 | 58 | 1 | |||
| 10167 | 16529 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1420X Evans Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6016649.3386754 | 2097853.1412174 | 37.7412394571821 | -122.385004155587 | (37.7412394571821, -122.385004155587) | 10 | 3 | 8 | 58 | 1 | |||
| 11343 | 200776 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1630 McKinnon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6015219 | 2096207 | 37.736640269463 | -122.389834845939 | (37.736640269463, -122.389834845939) | 10 | 3 | 8 | 58 | 1 | |||
| 11370 | 188616 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3601 03rd St | 13 | : | Tree | Private 2 | 16 | Width 3ft | 6015976.85216 | 2098785.54996 | 37.7437624397877 | -122.38739442492 | (37.7437624397877, -122.38739442492) | 10 | 3 | 8 | 58 | 1 | |||
| 11658 | 6629 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1415 Evans Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/16/2013 12:00:00 AM | 17 | 4x4 | 6016652.34226 | 2097729.17939 | 37.7408992492988 | -122.38498513575 | (37.7408992492988, -122.38498513575) | 10 | 3 | 8 | 58 | 1 | ||
| 12066 | 258686 | Property Tree 8 | Acacia melanoxylon :: Blackwood Acacia 70 | 100x Whitney Young Cir | 8 | Sidewalk: Curb side : Yard | Tree | SFUSD 4 | 3x3 | 6016360 | 2096059 | 37.7362970999571 | -122.385879567348 | (37.7362970999571, -122.385879567348) | 10 | 3 | 8 | 58 | 1 | ||||
| 12630 | 24191 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 55X Whitney Young Cir | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016412.1769872 | 2096105.6107164 | 37.736427970914 | -122.38570241579 | (37.736427970914, -122.38570241579) | 10 | 3 | 8 | 58 | 1 | |||
| 13685 | 261983 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2403 Keith St | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 6014456 | 2092405 | 37.7261584067484 | -122.392207065149 | (37.7261584067484, -122.392207065149) | 10 | 3 | 8 | 58 | 1 | |||||
| 13821 | 187767 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1500 Galvez Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 6016274.41454 | 2097399.64045 | 37.7399734907733 | -122.386268912575 | (37.7399734907733, -122.386268912575) | 10 | 3 | 8 | 58 | 1 | |||
| 14165 | 22132 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3795X 03rd St | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6015998.68116 | 2098857.5612 | 37.743961376797 | -122.387323966992 | (37.743961376797, -122.387323966992) | 10 | 3 | 8 | 58 | 1 | |||
| 14483 | 22142 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3795X 03rd St | 27 | 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 | |||
| 15006 | 6568 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1301 Evans Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6017234.1596238 | 2097288.6286052 | 37.7397217505579 | -122.382942754401 | (37.7397217505579, -122.382942754401) | 10 | 3 | 8 | 58 | 1 | |||
| 15187 | 6707 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1200X Fairfax Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017570.5024 | 2096779.609 | 37.7383426628708 | -122.381744418894 | (37.7383426628708, -122.381744418894) | 10 | 3 | 8 | 58 | 1 | |||
| 15635 | 5803 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 218X Cashmere St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/26/2020 12:00:00 AM | 3 | 3X4 | 6016111.4085 | 2096200.72161 | 37.7366724788363 | -122.386748939219 | (37.7366724788363, -122.386748939219) | 10 | 3 | 8 | 58 | 1 | ||
| 17456 | 38562 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1630 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 6 | Permit Number 40527 | 6015219 | 2096207 | 37.736640269463 | -122.389834845939 | (37.736640269463, -122.389834845939) | 10 | 3 | 8 | 58 | 1 | |
| 18268 | 262388 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1525 Galvez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6016246.49948 | 2097351.8889 | 37.739840829559 | -122.38636210374 | (37.739840829559, -122.38636210374) | 10 | 3 | 8 | 58 | 1 | |||||
| 19734 | 24211 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 80X Whitney Young Cir | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6016364.4746918 | 2096121.5533418 | 37.736469106467 | -122.385868455165 | (37.736469106467, -122.385868455165) | 10 | 3 | 8 | 58 | 1 | |||
| 19890 | 3695 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 400X Cargo Way | 2 | Median : Cutout | Tree | DPW 1 | 12 | 8 | 6017120.58643 | 2098873.01635 | 37.7440658827378 | -122.383445712243 | (37.7440658827378, -122.383445712243) | 10 | 3 | 8 | 58 | 1 | |||
| 20406 | 188744 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 250x Executive Park Blvd | 12 | Median : Yard | Tree | DPW 1 | 20 | Width 8ft | 6014566.93251 | 2086961.44697 | 37.7112176404424 | -122.391443188965 | (37.7112176404424, -122.391443188965) | 10 | 3 | 8 | 58 | 1 | |||
| 20956 | 188641 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 151 Helena St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6011091.32099 | 2096197.80071 | 37.7363852434915 | -122.404105441008 | (37.7363852434915, -122.404105441008) | 10 | 3 | 8 | 58 | 1 | ||||
| 21198 | 173686 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2211 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/12/2017 12:00:00 AM | 3 | 6011691 | 2097676 | 37.7404775538831 | -122.402135979323 | (37.7404775538831, -122.402135979323) | 10 | 3 | 8 | 58 | 1 | |||
| 22201 | 121023 | Undocumented 4 | Acacia melanoxylon :: Blackwood Acacia 70 | 200 Executive Park Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6014230 | 2086988 | 37.7112718434151 | -122.392609576957 | (37.7112718434151, -122.392609576957) | 10 | 3 | 8 | 58 | 1 | |||||
| 22211 | 8278 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 1600X Galvez Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6015786.61194 | 2097763.1602 | 37.7409446293456 | -122.387980907347 | (37.7409446293456, -122.387980907347) | 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) );