trees
339 rows where qSpecies_id = 30 sorted by Fire Prevention 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 54220 | 221505 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6005615.32825 | 2104975.43597 | 37.7601791311748 | -122.423662162075 | (37.7601791311748, -122.423662162075) | 2 | 4 | 5 | 28859 | 19 | |||
| 57039 | 152414 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005626.99355 | 2104746.96336 | 37.7595524574982 | -122.423605573157 | (37.7595524574982, -122.423605573157) | 2 | 4 | 5 | 28859 | 19 | |||
| 57081 | 91242 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 842x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 11/20/2009 12:00:00 AM | 3 | 6005622 | 2104059 | 37.7576631893365 | -122.423573931211 | (37.7576631893365, -122.423573931211) | 2 | 4 | 5 | 28859 | 19 | |||
| 57604 | 91292 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1286x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005762 | 2101471 | 37.7505650422621 | -122.422905822788 | (37.7505650422621, -122.422905822788) | 2 | 4 | 5 | 28859 | 19 | |||
| 57813 | 91247 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 880x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 01/20/2016 07:29:00 AM | 3 | 6005634 | 2103838 | 37.7570570522806 | -122.423516718678 | (37.7570570522806, -122.423516718678) | 2 | 4 | 5 | 28859 | 19 | |||
| 58618 | 152419 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005637.90033 | 2104551.94757 | 37.7590176055009 | -122.423553987148 | (37.7590176055009, -122.423553987148) | 2 | 4 | 5 | 28859 | 19 | |||
| 59561 | 109696 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x GUERRERO ST | 4 | Median : Cutout | Tree | DPW 1 | 02/21/2015 10:57:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.424312736622 | (37.7613144297161, -122.424312736622) | 2 | 4 | 5 | 28859 | 19 | ||
| 59581 | 91291 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1282x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005761 | 2101495 | 37.7506308843168 | -122.422910986406 | (37.7506308843168, -122.422910986406) | 2 | 4 | 5 | 28859 | 19 | |||
| 60014 | 221500 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 02/28/2015 11:10:00 PM | 2 | Width 3ft | 6005602.08318 | 2105171.20834 | 37.7607159284129 | -122.423721890569 | (37.7607159284129, -122.423721890569) | 2 | 4 | 5 | 28859 | 19 | ||
| 61134 | 152423 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005645.11359 | 2104396.78205 | 37.7585919644709 | -122.423518008854 | (37.7585919644709, -122.423518008854) | 2 | 4 | 5 | 28859 | 19 | |||
| 62629 | 221502 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 02/21/2015 11:07:00 PM | 2 | Width 3ft | 6005607.7078 | 2105081.85863 | 37.7604709126263 | -122.42369608451 | (37.7604709126263, -122.42369608451) | 2 | 4 | 5 | 28859 | 19 | ||
| 63104 | 221529 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1200x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 10 | Width 3ft | 6005786.9094 | 2101880.52554 | 37.751690910628 | -122.422848785557 | (37.751690910628, -122.422848785557) | 2 | 4 | 5 | 28859 | 19 | |||
| 63230 | 91280 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1180x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005731 | 2102090 | 37.7522629243783 | -122.423057015276 | (37.7522629243783, -122.423057015276) | 2 | 4 | 5 | 28859 | 19 | |||
| 63393 | 91276 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1156x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2009 12:00:00 AM | 3 | 6005723 | 2102230 | 37.7526468806007 | -122.4230946307 | (37.7526468806007, -122.4230946307) | 2 | 4 | 5 | 28859 | 19 | |||
| 63421 | 91285 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1212x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005738 | 2101906 | 37.7517580978369 | -122.42301973134 | (37.7517580978369, -122.42301973134) | 2 | 4 | 5 | 28859 | 19 | |||
| 66526 | 221504 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x Guerrero St | 11 | Median : Cutout | Tree | DPW 1 | 02/21/2015 11:05:00 PM | 2 | Width 3ft | 6005611.75297 | 2105011.45268 | 37.7602778227802 | -122.423677088129 | (37.7602778227802, -122.423677088129) | 2 | 4 | 5 | 28859 | 19 | ||
| 67854 | 91236 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 804 Guerrero St | 1 | Median : | Tree | DPW 1 | 11/20/2009 12:00:00 AM | 3 | 3x100 | 6005614 | 2104300 | 37.7583244674077 | -122.423618732861 | (37.7583244674077, -122.423618732861) | 2 | 4 | 5 | 28859 | 19 | ||
| 68150 | 221564 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 4286 23rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001316.91777 | 2102341.73596 | 37.7527040553705 | -122.438339609582 | (37.7527040553705, -122.438339609582) | 2 | 4 | 5 | 28862 | 22 | |||
| 68247 | 221515 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005828.19442 | 2101110.33186 | 37.7495784651962 | -122.422651289924 | (37.7495784651962, -122.422651289924) | 2 | 4 | 5 | 28859 | 19 | |||
| 68623 | 91249 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 870x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 01/20/2016 07:26:00 AM | 3 | 6005631 | 2103898 | 37.7572216289442 | -122.423531359417 | (37.7572216289442, -122.423531359417) | 2 | 4 | 5 | 28859 | 19 | |||
| 73744 | 221562 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100 San Jose Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006161.28805 | 2102498.92878 | 37.75341002046 | -122.421598049829 | (37.75341002046, -122.421598049829) | 2 | 4 | 5 | 28859 | 19 | |||
| 75109 | 221524 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1200x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 8 | Width 3ft | 6005795.8556 | 2101693.96335 | 37.7511791585977 | -122.422804591074 | (37.7511791585977, -122.422804591074) | 2 | 4 | 5 | 28859 | 19 | |||
| 75467 | 91279 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1170x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005728 | 2102148 | 37.752422009696 | -122.423071511908 | (37.752422009696, -122.423071511908) | 2 | 4 | 5 | 28859 | 19 | |||
| 76998 | 109698 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x GUERRERO ST | 6 | Median : Cutout | Tree | DPW 1 | 02/28/2015 11:01:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.424312736622 | (37.7613144297161, -122.424312736622) | 2 | 4 | 5 | 28859 | 19 | ||
| 77452 | 221561 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 100 San Jose Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006161.81341 | 2102510.42937 | 37.7534416280528 | -122.42159704977 | (37.7534416280528, -122.42159704977) | 2 | 4 | 5 | 28859 | 19 | |||
| 79544 | 91239 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 842x Guerrero St | 1 | Median : Hanging Pot | Tree | DPW 1 | 11/20/1989 12:00:00 AM | 3 | 6005622 | 2104059 | 37.7576631893365 | -122.423573931211 | (37.7576631893365, -122.423573931211) | 2 | 4 | 5 | 28859 | 19 | |||
| 80816 | 221527 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1200x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005790.21854 | 2101800.81566 | 37.7514722323764 | -122.422831677752 | (37.7514722323764, -122.422831677752) | 2 | 4 | 5 | 28859 | 19 | |||
| 81807 | 243240 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005663.74872 | 2104041.4182 | 37.7576172702474 | -122.423428296996 | (37.7576172702474, -122.423428296996) | 2 | 4 | 5 | 28859 | 19 | |||
| 83337 | 221569 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 616 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003001.08037 | 2104529.5167 | 37.7588068286936 | -122.432671745707 | (37.7588068286936, -122.432671745707) | 2 | 4 | 5 | 28862 | 3 | |||
| 84262 | 221514 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 8 | Width 3ft | 6005830.22915 | 2101083.18072 | 37.7495040291878 | -122.42264232458 | (37.7495040291878, -122.42264232458) | 2 | 4 | 5 | 28859 | 19 | |||
| 84453 | 152418 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005636.4507 | 2104585.07924 | 37.7591084954784 | -122.42356135619 | (37.7591084954784, -122.42356135619) | 2 | 4 | 5 | 28859 | 19 | |||
| 89953 | 109700 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x GUERRERO ST | 8 | Median : Cutout | Tree | DPW 1 | 02/21/2015 11:08:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.424312736622 | (37.7613144297161, -122.424312736622) | 2 | 4 | 5 | 28859 | 19 | ||
| 90377 | 91287 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1212x Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005738 | 2101906 | 37.7517580978369 | -122.42301973134 | (37.7517580978369, -122.42301973134) | 2 | 4 | 5 | 28859 | 19 | |||
| 92341 | 221565 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 4286 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001328.91667 | 2102339.67059 | 37.7526990668325 | -122.438297967381 | (37.7526990668325, -122.438297967381) | 2 | 4 | 5 | 28862 | 22 | |||
| 94316 | 110779 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000X GUERRERO ST | 8 | Median : Cutout | Tree | DPW 1 | 05/26/2015 02:35:00 PM | 3 | 3x3 | 6005663 | 2103080 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | 2 | 4 | 5 | 28859 | 19 | ||
| 94820 | 91289 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1258x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005785.088369 | 2101640.018452 | 37.7510304308024 | -122.422837991942 | (37.7510304308024, -122.422837991942) | 2 | 4 | 5 | 28859 | 19 | |||
| 94933 | 91269 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1120x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005712 | 2102441 | 37.7532256170659 | -122.423147667433 | (37.7532256170659, -122.423147667433) | 2 | 4 | 5 | 28859 | 19 | |||
| 95085 | 109697 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x GUERRERO ST | 5 | Median : Cutout | Tree | DPW 1 | 02/21/2015 10:59:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.424312736622 | (37.7613144297161, -122.424312736622) | 2 | 4 | 5 | 28859 | 19 | ||
| 95760 | 110776 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000X GUERRERO ST | 5 | Median : Cutout | Tree | DPW 1 | 05/26/2015 02:53:00 PM | 3 | 3x3 | 6005663 | 2103080 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | 2 | 4 | 5 | 28859 | 19 | ||
| 96242 | 221567 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 324 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004154.58593 | 2103373.98314 | 37.7556993571514 | -122.428600021096 | (37.7556993571514, -122.428600021096) | 2 | 4 | 5 | 28862 | 22 | |||
| 96256 | 221499 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 02/28/2015 11:01:00 PM | 2 | Width 3ft | 6005601.09047 | 2105206.48742 | 37.7608127404289 | -122.423727832389 | (37.7608127404289, -122.423727832389) | 2 | 4 | 5 | 28859 | 19 | ||
| 96333 | 152415 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005628.48676 | 2104715.95286 | 37.7594673942256 | -122.423598204106 | (37.7594673942256, -122.423598204106) | 2 | 4 | 5 | 28859 | 19 | |||
| 98803 | 221497 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 02/21/2015 10:57:00 PM | 2 | Width 3ft | 6005595.06917 | 2105295.44768 | 37.7610566644632 | -122.423754982925 | (37.7610566644632, -122.423754982925) | 2 | 4 | 5 | 28859 | 19 | ||
| 100554 | 221519 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005822.79049 | 2101267.93468 | 37.7500109014944 | -122.422681175305 | (37.7500109014944, -122.422681175305) | 2 | 4 | 5 | 28859 | 19 | |||
| 102302 | 91258 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 948x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005688.196047 | 2103445.549621 | 37.7559825338488 | -122.423301390711 | (37.7559825338488, -122.423301390711) | 2 | 4 | 5 | 28859 | 19 | ||
| 103645 | 221420 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 11/20/2009 12:00:00 AM | 5 | Width 3ft | 6005663.71373 | 2104068.90036 | 37.7576927278639 | -122.423430371709 | (37.7576927278639, -122.423430371709) | 2 | 4 | 5 | 28859 | 19 | ||
| 106244 | 152412 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005623.17605 | 2104812.38517 | 37.7597318749526 | -122.4236234274 | (37.7597318749526, -122.4236234274) | 2 | 4 | 5 | 28859 | 19 | |||
| 106309 | 221537 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1100x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 6 | Width 3ft | 6005757.84067 | 2102377.37522 | 37.753053504939 | -122.422984619142 | (37.753053504939, -122.422984619142) | 2 | 4 | 5 | 28859 | 19 | |||
| 106696 | 110781 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000X GUERRERO ST | 10 | Median : Cutout | Tree | DPW 1 | 05/26/2015 02:26:00 PM | 3 | 3x3 | 6005663 | 2103080 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | 2 | 4 | 5 | 28859 | 19 | ||
| 107424 | 152417 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 700x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005634.27087 | 2104624.16733 | 37.7592156991708 | -122.423571674116 | (37.7592156991708, -122.423571674116) | 2 | 4 | 5 | 28859 | 19 | |||
| 109163 | 221526 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1200x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 8 | Width 3ft | 6005792.85635 | 2101748.62489 | 37.7513290773756 | -122.422818847126 | (37.7513290773756, -122.422818847126) | 2 | 4 | 5 | 28859 | 19 | |||
| 109528 | 91246 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 876x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005633 | 2103862 | 37.7571228942355 | -122.423521883288 | (37.7571228942355, -122.423521883288) | 2 | 4 | 5 | 28859 | 19 | |||
| 110959 | 221423 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 12 | Median : Cutout | Tree | DPW 1 | 6 | Width 3ft | 6005658.05131 | 2104209.23909 | 37.7580777456208 | -122.423459931529 | (37.7580777456208, -122.423459931529) | 2 | 4 | 5 | 28859 | 19 | |||
| 112972 | 88538 | Undocumented 4 | Acacia stenophylla :: Shoestring Acacia 30 | 1306 York St | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/26/2009 12:00:00 AM | 3x12 | Permit Number 52223 | 6010027.5 | 2101589.4 | 37.7511299031436 | -122.40816367022 | (37.7511299031436, -122.40816367022) | 2 | 4 | 7 | 28859 | 19 | |||
| 115886 | 91243 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 850x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 02/10/2009 12:00:00 AM | 3 | 6005625 | 2104018 | 37.7575507822519 | -122.423560641088 | (37.7575507822519, -122.423560641088) | 2 | 4 | 5 | 28859 | 19 | |||
| 116250 | 221507 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 900x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 5 | Width 3ft | 6005699.48542 | 2103446.59299 | 37.7559860358317 | -122.42326242244 | (37.7559860358317, -122.42326242244) | 2 | 4 | 5 | 28859 | 19 | |||
| 118210 | 221517 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 4 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005823.4134 | 2101214.1336 | 37.7498632112216 | -122.422675198428 | (37.7498632112216, -122.422675198428) | 2 | 4 | 5 | 28859 | 19 | |||
| 120577 | 221531 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1100x Guerrero St | 11 | Median : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6005769.92765 | 2102140.767 | 37.7524045154572 | -122.422926004956 | (37.7524045154572, -122.422926004956) | 2 | 4 | 5 | 28859 | 19 | |||
| 120886 | 221547 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6005723.41397 | 2102999.7023 | 37.7547603282456 | -122.423147905453 | (37.7547603282456, -122.423147905453) | 2 | 4 | 5 | 28859 | 19 | |||
| 121825 | 91294 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1286x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005762 | 2101471 | 37.7505650422621 | -122.422905822788 | (37.7505650422621, -122.422905822788) | 2 | 4 | 5 | 28859 | 19 | |||
| 122027 | 109703 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x GUERRERO ST | 11 | Median : Cutout | Tree | DPW 1 | 02/21/2015 11:05:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.424312736622 | (37.7613144297161, -122.424312736622) | 2 | 4 | 5 | 28859 | 19 | ||
| 122448 | 91275 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1150x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2009 12:00:00 AM | 3 | 6005721 | 2102265 | 37.7527428696504 | -122.423104034617 | (37.7527428696504, -122.423104034617) | 2 | 4 | 5 | 28859 | 19 | |||
| 123034 | 91255 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 940x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005685.709261 | 2103490.611554 | 37.75610612308 | -122.423313194032 | (37.75610612308, -122.423313194032) | 2 | 4 | 5 | 28859 | 19 | ||
| 124826 | 221551 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6005731.5319 | 2102850.00284 | 37.7543497463656 | -122.423109191463 | (37.7543497463656, -122.423109191463) | 2 | 4 | 5 | 28859 | 19 | |||
| 126324 | 221520 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1200x Guerrero St | 13 | Median : Cutout | Tree | DPW 1 | 6 | Width 3ft | 6005805.49109 | 2101500.8171 | 37.7506493670819 | -122.422757545722 | (37.7506493670819, -122.422757545722) | 2 | 4 | 5 | 28859 | 19 | |||
| 127657 | 91271 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1130x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2009 12:00:00 AM | 3 | 6005715 | 2102383 | 37.7530665317795 | -122.423133170481 | (37.7530665317795, -122.423133170481) | 2 | 4 | 5 | 28859 | 19 | |||
| 128979 | 221516 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 9 | Width 3ft | 6005827.473 | 2101138.31675 | 37.749655264584 | -122.422655773047 | (37.749655264584, -122.422655773047) | 2 | 4 | 5 | 28859 | 19 | |||
| 129565 | 109701 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x GUERRERO ST | 9 | Median : Cutout | Tree | DPW 1 | 02/21/2015 11:07:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.424312736622 | (37.7613144297161, -122.424312736622) | 2 | 4 | 5 | 28859 | 19 | ||
| 133232 | 109704 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x GUERRERO ST | 12 | Median : Cutout | Tree | DPW 1 | 02/28/2015 10:40:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.424312736622 | (37.7613144297161, -122.424312736622) | 2 | 4 | 5 | 28859 | 19 | ||
| 136051 | 221508 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1201 San Jose Ave | 15 | Front Yard : Yard | Tree | Private 2 | 1 | 6004291.81357 | 2095940.5809 | 37.7352967139782 | -122.427595874056 | (37.7352967139782, -122.427595874056) | 2 | 7 | 5 | 28861 | 2 | ||||
| 140454 | 91265 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 986x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005700.008282 | 2103231.505425 | 37.7553954849101 | -122.423245325469 | (37.7553954849101, -122.423245325469) | 2 | 4 | 5 | 28859 | 19 | ||
| 140820 | 221534 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1100x Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6005765.63484 | 2102254.12398 | 37.7527155253202 | -122.422948906168 | (37.7527155253202, -122.422948906168) | 2 | 4 | 5 | 28859 | 19 | |||
| 141491 | 110772 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000X GUERRERO ST | 1 | Median : Cutout | Tree | DPW 1 | 05/26/2015 03:10:00 PM | 3 | 3x3 | 6005663 | 2103080 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | 2 | 4 | 5 | 28859 | 19 | ||
| 142437 | 221532 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1100x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 8 | Width 3ft | 6005770.104 | 2102168.30473 | 37.7524801376575 | -122.422927352112 | (37.7524801376575, -122.422927352112) | 2 | 4 | 5 | 28859 | 19 | |||
| 143846 | 221417 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 1 | Width 3ft | 6005673.16306 | 2103886.4908 | 37.7571924071266 | -122.423384724831 | (37.7571924071266, -122.423384724831) | 2 | 4 | 5 | 28859 | 19 | |||
| 145226 | 91283 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1212x Guerrero St | 3 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005738 | 2101906 | 37.7517580978369 | -122.42301973134 | (37.7517580978369, -122.42301973134) | 2 | 4 | 5 | 28859 | 19 | |||
| 145933 | 221566 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 4286 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001342.88204 | 2102344.46852 | 37.7527130350975 | -122.438250016433 | (37.7527130350975, -122.438250016433) | 2 | 4 | 5 | 28862 | 22 | |||
| 147940 | 91288 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1250x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005751 | 2101683 | 37.7511465247873 | -122.422958927632 | (37.7511465247873, -122.422958927632) | 2 | 4 | 5 | 28859 | 19 | |||
| 148907 | 91252 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 908x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005675.762116 | 2103670.859284 | 37.7566004799608 | -122.423360407709 | (37.7566004799608, -122.423360407709) | 2 | 4 | 5 | 28859 | 19 | ||
| 150645 | 91274 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1144x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2009 12:00:00 AM | 3 | 6005719 | 2102300 | 37.7528388586979 | -122.423113438558 | (37.7528388586979, -122.423113438558) | 2 | 4 | 5 | 28859 | 19 | |||
| 151302 | 91263 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 970x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005695.03471 | 2103321.62929 | 37.7556426634019 | -122.423268931776 | (37.7556426634019, -122.423268931776) | 2 | 4 | 5 | 28859 | 19 | ||
| 152652 | 109694 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x GUERRERO ST | 2 | Median : Cutout | Tree | DPW 1 | 02/21/2015 10:54:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.424312736622 | (37.7613144297161, -122.424312736622) | 2 | 4 | 5 | 28859 | 19 | ||
| 152774 | 221559 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1306 York St | 4 | : | Tree | Private 2 | 7 | Width 3ft | 6010039.89073 | 2101557.14399 | 37.7510420290671 | -122.408118546954 | (37.7510420290671, -122.408118546954) | 2 | 4 | 7 | 28859 | 19 | |||
| 154018 | 221558 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000x Guerrero St | 5 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6005728.5881 | 2102926.21051 | 37.7545588288301 | -122.423124788381 | (37.7545588288301, -122.423124788381) | 2 | 4 | 5 | 28859 | 19 | |||
| 156067 | 221563 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 4286 23rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001305.60339 | 2102341.6071 | 37.7527030580007 | -122.438378727412 | (37.7527030580007, -122.438378727412) | 2 | 4 | 5 | 28862 | 22 | |||
| 157919 | 91293 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 812x Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 11/20/2001 12:00:00 AM | 3 | 6005612 | 2104238 | 37.7581541170225 | -122.423621241698 | (37.7581541170225, -122.423621241698) | 2 | 4 | 5 | 28859 | 19 | |||
| 159092 | 91256 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 940X Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005685.709261 | 2103490.611554 | 37.75610612308 | -122.423313194032 | (37.75610612308, -122.423313194032) | 2 | 4 | 5 | 28859 | 19 | ||
| 159812 | 91238 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 812x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005612 | 2104238 | 37.7581541170225 | -122.423621241698 | (37.7581541170225, -122.423621241698) | 2 | 4 | 5 | 28859 | 19 | |||
| 160656 | 221503 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 02/21/2015 11:06:00 PM | 2 | Width 3ft | 6005610.53101 | 2105047.42068 | 37.7603765134773 | -122.423683871708 | (37.7603765134773, -122.423683871708) | 2 | 4 | 5 | 28859 | 19 | ||
| 162764 | 91266 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1100X Guerrero St | 2 | Median : Cutout | Tree | DPW 1 | 06/21/2016 01:48:00 PM | 3 | 3x500 | 6005744.445578 | 2102548.346221 | 37.7535221958931 | -122.423043093148 | (37.7535221958931, -122.423043093148) | 2 | 4 | 5 | 28859 | 19 | ||
| 162959 | 91286 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1212x Guerrero St | 6 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005738 | 2101906 | 37.7517580978369 | -122.42301973134 | (37.7517580978369, -122.42301973134) | 2 | 4 | 5 | 28859 | 19 | |||
| 163402 | 110782 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000X GUERRERO ST | 11 | Median : Cutout | Tree | DPW 1 | 05/26/2015 02:21:00 PM | 3 | 3x3 | 6005663 | 2103080 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | 2 | 4 | 5 | 28859 | 19 | ||
| 165700 | 221422 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 800x Guerrero St | 10 | Median : Cutout | Tree | DPW 1 | 6 | Width 3ft | 6005661.88318 | 2104154.96713 | 37.7579289437835 | -122.42344282103 | (37.7579289437835, -122.42344282103) | 2 | 4 | 5 | 28859 | 19 | |||
| 170354 | 91272 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1136x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2009 12:00:00 AM | 3 | 6005717 | 2102348 | 37.7529705427373 | -122.423123766486 | (37.7529705427373, -122.423123766486) | 2 | 4 | 5 | 28859 | 19 | |||
| 170754 | 91277 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1170x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005728 | 2102148 | 37.752422009696 | -122.423071511908 | (37.752422009696, -122.423071511908) | 2 | 4 | 5 | 28859 | 19 | |||
| 171275 | 109699 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 600x GUERRERO ST | 7 | Median : Cutout | Tree | DPW 1 | 02/28/2015 11:10:00 PM | 3 | 3x3 | 6005435.8 | 2105392.6 | 37.7613144297161 | -122.424312736622 | (37.7613144297161, -122.424312736622) | 2 | 4 | 5 | 28859 | 19 | ||
| 172006 | 110783 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1000X GUERRERO ST | 12 | Median : Cutout | Tree | DPW 1 | 05/26/2015 02:16:00 PM | 3 | 3x3 | 6005663 | 2103080 | 37.7549773975701 | -122.423362541701 | (37.7549773975701, -122.423362541701) | 2 | 4 | 5 | 28859 | 19 | ||
| 173380 | 91281 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1212x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2008 12:00:00 AM | 3 | 6005738 | 2101906 | 37.7517580978369 | -122.42301973134 | (37.7517580978369, -122.42301973134) | 2 | 4 | 5 | 28859 | 19 | |||
| 174532 | 91273 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1140x Guerrero St | 1 | Median : Cutout | Tree | DPW 1 | 11/20/2009 12:00:00 AM | 3 | 6005718 | 2102324 | 37.7529047007181 | -122.423118602517 | (37.7529047007181, -122.423118602517) | 2 | 4 | 5 | 28859 | 19 | |||
| 174659 | 221511 | DPW Maintained 1 | Acacia stenophylla :: Shoestring Acacia 30 | 1300x Guerrero St | 11 | Median : Cutout | Tree | DPW 1 | 6 | Width 3ft | 6005835.54562 | 2100976.57743 | 37.7492116209326 | -122.422616365666 | (37.7492116209326, -122.422616365666) | 2 | 4 | 5 | 28859 | 19 |
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) );