trees
218 rows where Fire Prevention Districts = 2 and qSpecies_id = 65 sorted by DBH descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
43199 | 221866 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 53 Wilder St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6002528.4957 | 2095557.08411 | 37.734143822686 | -122.433664907521 | (37.734143822686, -122.433664907521) | 2 | 7 | 5 | 63 | 7 | |||
79681 | 221871 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 619 Eugenia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007314.53376 | 2097779.75076 | 37.7405171804218 | -122.417275479073 | (37.7405171804218, -122.417275479073) | 2 | 7 | 7 | 28859 | 2 | |||
136628 | 221862 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 252 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6004616.62035 | 2096933.09811 | 37.7380403090218 | -122.426543547661 | (37.7380403090218, -122.426543547661) | 2 | 7 | 5 | 63 | 7 | |||
161078 | 221858 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 677 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6002223.92198 | 2099714.60458 | 37.7455421216803 | -122.435015156842 | (37.7455421216803, -122.435015156842) | 2 | 7 | 5 | 63 | 22 | |||
168785 | 221814 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 78 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007954.65071 | 2098276.18605 | 37.7419162746098 | -122.415097327373 | (37.7419162746098, -122.415097327373) | 2 | 7 | 7 | 28859 | 2 | |||
192333 | 221847 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Marys Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6004411.28278 | 2095593.12873 | 37.7343494454616 | -122.427158084072 | (37.7343494454616, -122.427158084072) | 2 | 7 | 5 | 28861 | 25 | |||
3673 | 221872 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 619 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007332.3833 | 2097776.98457 | 37.740510589287 | -122.417213566178 | (37.740510589287, -122.417213566178) | 2 | 7 | 7 | 28859 | 2 | |||
12895 | 221826 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 499X Tompkins Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008314.44854 | 2096531.09899 | 37.7371448612571 | -122.413729852457 | (37.7371448612571, -122.413729852457) | 2 | 7 | 7 | 28859 | 2 | |||
19306 | 221827 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 499X Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008328.718 | 2096529.81834 | 37.7371421461853 | -122.413680425731 | (37.7371421461853, -122.413680425731) | 2 | 7 | 7 | 28859 | 2 | |||
73676 | 102018 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 4252 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6001333 | 2103370 | 37.7555283353782 | -122.438357655981 | (37.7555283353782, -122.438357655981) | 2 | 4 | 5 | 28862 | 3 | |||
79694 | 221813 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 810 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007573.94838 | 2095674.48731 | 37.7347511816054 | -122.416229453325 | (37.7347511816054, -122.416229453325) | 2 | 7 | 7 | 28859 | 2 | |||
130490 | 221857 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 679 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6002187.97645 | 2099712.96384 | 37.7455355755051 | -122.435139333412 | (37.7455355755051, -122.435139333412) | 2 | 7 | 5 | 63 | 22 | |||
163060 | 221924 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 651 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003063.54599 | 2104384.44794 | 37.7584120469841 | -122.432445349468 | (37.7584120469841, -122.432445349468) | 2 | 4 | 5 | 28862 | 3 | |||
188028 | 221867 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2825 Diamond St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002454.8642 | 2095527.53959 | 37.7340585219649 | -122.43391736341 | (37.7340585219649, -122.43391736341) | 2 | 7 | 5 | 63 | 7 | |||
89515 | 221937 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 31 Fairmount St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005028.18878 | 2097255.91505 | 37.7389499498753 | -122.425143513686 | (37.7389499498753, -122.425143513686) | 2 | 7 | 5 | 63 | 7 | |||
105651 | 32556 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 233 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/1996 12:00:00 AM | 7 | Permit Number 37043 | 6004755.28395 | 2103949.67696 | 37.7573140539292 | -122.42656360702 | (37.7573140539292, -122.42656360702) | 2 | 4 | 5 | 28862 | 3 | ||
114883 | 221926 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 651 Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003063.55536 | 2104400.84265 | 37.7584570634637 | -122.432446488035 | (37.7584570634637, -122.432446488035) | 2 | 4 | 5 | 28862 | 3 | |||
191257 | 221925 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 651 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003063.11799 | 2104395.60529 | 37.7584426581259 | -122.432447626582 | (37.7584426581259, -122.432447626582) | 2 | 4 | 5 | 28862 | 3 | |||
133256 | 5134 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2815 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1992 12:00:00 AM | 6 | 3X3 | 6002450.59942 | 2095504.85865 | 37.7339960032757 | -122.433930487392 | (37.7339960032757, -122.433930487392) | 2 | 7 | 5 | 63 | 7 | ||
2752 | 221825 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 499X Tompkins Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008302.15962 | 2096532.14097 | 37.7371470321954 | -122.41377241466 | (37.7371470321954, -122.41377241466) | 2 | 7 | 7 | 28859 | 2 | |||
72933 | 221807 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3720 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6004936.8002 | 2102544.12819 | 37.7534650059101 | -122.425835807291 | (37.7534650059101, -122.425835807291) | 2 | 4 | 5 | 28862 | 22 | |||
106933 | 221895 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 47 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003758.63244 | 2095404.32352 | 37.7337940997194 | -122.429401048121 | (37.7337940997194, -122.429401048121) | 2 | 7 | 5 | 28861 | 25 | |||
120305 | 221888 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 192 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006128.60788 | 2102045.32396 | 37.7521626832758 | -122.421678849418 | (37.7521626832758, -122.421678849418) | 2 | 4 | 5 | 28859 | 19 | |||
183922 | 221794 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 63 Mullen Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009581.16571 | 2099887.27047 | 37.7464312301328 | -122.409587024721 | (37.7464312301328, -122.409587024721) | 2 | 7 | 7 | 28859 | 2 | |||
24861 | 221804 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 266 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 39 | Width 4ft | 6004140.40735 | 2099573.26288 | 37.7452626636546 | -122.42837817451 | (37.7452626636546, -122.42837817451) | 2 | 7 | 5 | 63 | 22 | |||
101047 | 221790 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3456 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | Width 5ft | 6005327.10837 | 2103145.45598 | 37.7551381613168 | -122.424528807253 | (37.7551381613168, -122.424528807253) | 2 | 4 | 5 | 28859 | 19 | |||
99862 | 221909 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1175 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | Width 5ft | 6003227.24309 | 2101470.4878 | 37.7504202845862 | -122.43167116991 | (37.7504202845862, -122.43167116991) | 2 | 4 | 5 | 28862 | 22 | |||
139150 | 221852 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4338 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | Width 4ft | 6001688.98407 | 2100608.31061 | 37.747965638118 | -122.436928854805 | (37.747965638118, -122.436928854805) | 2 | 4 | 5 | 28862 | 22 | |||
149504 | 221911 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1175 Noe St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 31 | Width 5ft | 6003226.50292 | 2101503.3413 | 37.7505104506147 | -122.431676074804 | (37.7505104506147, -122.431676074804) | 2 | 4 | 5 | 28862 | 22 | |||
69147 | 33484 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 300 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/25/1996 12:00:00 AM | 30 | 6x6 | Permit Number 37610 | 6006227.43678663 | 2098258.25526822 | 37.741769825751 | -122.421068211473 | (37.741769825751, -122.421068211473) | 2 | 7 | 7 | 28859 | 2 |
7501 | 262401 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1X Benton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/21/2020 12:00:00 AM | 3 | 3x3 | 6004556 | 2094831 | 37.732264993682 | -122.426603497453 | (37.732264993682, -122.426603497453) | 2 | 7 | 7 | 28861 | 2 | ||
10243 | 221904 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 583 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/02/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 785229 | 6001404.83719 | 2101424.58127 | 37.7501907685919 | -122.437969880314 | (37.7501907685919, -122.437969880314) | 2 | 4 | 5 | 28862 | 22 | |
18580 | 262400 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1X Benton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/21/2020 12:00:00 AM | 3 | 3x3 | 6004556 | 2094831 | 37.732264993682 | -122.426603497453 | (37.732264993682, -122.426603497453) | 2 | 7 | 7 | 28861 | 2 | ||
23185 | 241540 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 191 Fairmount St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2018 12:00:00 AM | 3 | Width 2ft | Permit Number 780010 | 6004426.52656 | 2097222.39048 | 37.7388238918993 | -122.427221397276 | (37.7388238918993, -122.427221397276) | 2 | 7 | 5 | 63 | 7 | |
25181 | 221922 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 142 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002658.74413 | 2105066.93812 | 37.7602630379377 | -122.433894115042 | (37.7602630379377, -122.433894115042) | 2 | 4 | 5 | 28862 | 3 | |||
31052 | 109288 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 274 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773379 | 6002625.7 | 2104315.8 | 37.7581987182413 | -122.433954706682 | (37.7581987182413, -122.433954706682) | 2 | 4 | 5 | 28862 | 3 |
38682 | 158242 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 225 Bemis St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778932 | 6003158.9626 | 2096376.80466 | 37.7364303417798 | -122.431543687401 | (37.7364303417798, -122.431543687401) | 2 | 7 | 5 | 63 | 7 |
60245 | 108910 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 129 Ellert St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773054 | 6007361.2 | 2097016.9 | 37.7384251864379 | -122.417060086005 | (37.7384251864379, -122.417060086005) | 2 | 7 | 7 | 28859 | 2 |
63785 | 158240 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 225 Bemis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778932 | 6003134.83556 | 2096356.78559 | 37.7363740064603 | -122.43162567588 | (37.7363740064603, -122.43162567588) | 2 | 7 | 5 | 63 | 7 |
67823 | 103022 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 40X Coleridge St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/15/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770067 | 6006901 | 2099544.2 | 37.7453386886112 | -122.418830426928 | (37.7453386886112, -122.418830426928) | 2 | 7 | 7 | 28859 | 2 |
76448 | 108926 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 36 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772355 | 6007347.4 | 2099299.8 | 37.7446927459132 | -122.417269529335 | (37.7446927459132, -122.417269529335) | 2 | 7 | 7 | 28859 | 2 |
106236 | 120108 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 3528 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778087 | 6004858 | 2103141 | 37.7550994230029 | -122.426150804554 | (37.7550994230029, -122.426150804554) | 2 | 4 | 5 | 28862 | 22 | |
108472 | 109743 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 142 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775046 | 6002641.7 | 2105066.1 | 37.7602597694278 | -122.433953002704 | (37.7602597694278, -122.433953002704) | 2 | 4 | 5 | 28862 | 3 |
117767 | 158241 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 225 Bemis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778932 | 6003145.71012 | 2096365.89505 | 37.7363996353363 | -122.431588728148 | (37.7363996353363, -122.431588728148) | 2 | 7 | 5 | 63 | 7 |
136488 | 109499 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 99 Surrey St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 02/19/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774984 | 6002392.9 | 2096233.9 | 37.7359945088656 | -122.43418207237 | (37.7359945088656, -122.43418207237) | 2 | 7 | 5 | 63 | 7 |
144794 | 32372 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 90 Leese St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/2018 12:00:00 AM | 3 | Permit Number 782452 | 6005529.07574 | 2096212.96171 | 37.7361145169719 | -122.423337554504 | (37.7361145169719, -122.423337554504) | 2 | 7 | 7 | 28859 | 2 | |
153032 | 243747 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 217 Whitney St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2018 12:00:00 AM | 3 | Width 2ft | Permit Number 780010 | 6004399.27823 | 2097187.62567 | 37.7387268946327 | -122.427313133507 | (37.7387268946327, -122.427313133507) | 2 | 7 | 5 | 63 | 7 | |
180750 | 158239 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 225 Bemis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780004 | 6003126.50979 | 2096349.74034 | 37.7363541898933 | -122.43165395869 | (37.7363541898933, -122.43165395869) | 2 | 7 | 5 | 63 | 7 |
186130 | 221808 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3720 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6004922.45206 | 2102542.08461 | 37.753458583869 | -122.425885280803 | (37.753458583869, -122.425885280803) | 2 | 4 | 5 | 28862 | 22 | |||
85505 | 221920 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 963 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 29 | 4x4 | 6003802.10196 | 2102678.82151 | 37.7537706531042 | -122.429769441907 | (37.7537706531042, -122.429769441907) | 2 | 4 | 5 | 28862 | 22 | |||
145041 | 221874 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 371 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 29 | Width 3ft | 6006129.02794 | 2097974.50861 | 37.7409851732348 | -122.421388331502 | (37.7409851732348, -122.421388331502) | 2 | 7 | 7 | 28859 | 2 | |||
53970 | 221876 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 24 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 6006954.78098 | 2099597.50642 | 37.7454880840995 | -122.418648240225 | (37.7454880840995, -122.418648240225) | 2 | 7 | 7 | 28859 | 2 | |||
93692 | 221803 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 118 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 4ft | 6005068.88763 | 2098748.30494 | 37.743050013041 | -122.42510895543 | (37.743050013041, -122.42510895543) | 2 | 7 | 5 | 63 | 22 | |||
71384 | 221875 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 319 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 4ft | 6006211.14692 | 2098216.1896 | 37.7416534045787 | -122.421121550328 | (37.7416534045787, -122.421121550328) | 2 | 7 | 7 | 28859 | 2 | |||
121688 | 4845 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 202 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/27/1992 12:00:00 AM | 24 | 3X3 | 6006694.31051 | 2097440.2331 | 37.7395500270059 | -122.41939589432 | (37.7395500270059, -122.41939589432) | 2 | 7 | 7 | 28859 | 2 | ||
157705 | 221881 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 4 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6007048.87361 | 2099774.96937 | 37.7459806544792 | -122.418335462324 | (37.7459806544792, -122.418335462324) | 2 | 7 | 7 | 28859 | 2 | |||
180514 | 221817 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 25 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6007435.65723 | 2099387.93304 | 37.7449397045122 | -122.416970595441 | (37.7449397045122, -122.416970595441) | 2 | 7 | 7 | 28859 | 2 | |||
1806 | 221820 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 368 Highland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 2ft | 6007294.28583 | 2096507.5919 | 37.7370229743371 | -122.417255362169 | (37.7370229743371, -122.417255362169) | 2 | 7 | 7 | 28859 | 2 | |||
24073 | 221906 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 879 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6002491.82292 | 2103096.81966 | 37.7548440920015 | -122.434330562332 | (37.7548440920015, -122.434330562332) | 2 | 4 | 5 | 28862 | 22 | |||
181669 | 221897 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 7 Marsily St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6004313.27155 | 2095583.983 | 37.7343187902678 | -122.427496289445 | (37.7343187902678, -122.427496289445) | 2 | 7 | 5 | 28861 | 25 | |||
109510 | 221880 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 47 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6007035.70082 | 2099744.20537 | 37.7458954419332 | -122.418378831241 | (37.7458954419332, -122.418378831241) | 2 | 7 | 7 | 28859 | 2 | |||
121889 | 221935 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 102 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 6004836.87593 | 2097581.93653 | 37.7398343216046 | -122.425828185523 | (37.7398343216046, -122.425828185523) | 2 | 7 | 5 | 63 | 7 | |||
179502 | 221830 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2451 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 6008241.38226 | 2104159.63616 | 37.7580870167112 | -122.414522128209 | (37.7580870167112, -122.414522128209) | 2 | 4 | 7 | 28859 | 19 | |||
17657 | 221821 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 368 Highland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3x5 | 6007305.19909 | 2096505.34711 | 37.7370174246124 | -122.417217471014 | (37.7370174246124, -122.417217471014) | 2 | 7 | 7 | 28859 | 2 | |||
28695 | 221842 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 5 Marsily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 2ft | 6004251.52018 | 2095424.77714 | 37.7338781539609 | -122.427698444448 | (37.7338781539609, -122.427698444448) | 2 | 7 | 5 | 28861 | 25 | |||
67738 | 221916 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 429 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6004184.08219 | 2101438.38346 | 37.7503863234716 | -122.428360063075 | (37.7503863234716, -122.428360063075) | 2 | 4 | 5 | 28862 | 22 | |||
70357 | 221879 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 43 Powers Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6006986.90322 | 2099718.335 | 37.745821660643 | -122.418545732803 | (37.745821660643, -122.418545732803) | 2 | 7 | 7 | 28859 | 2 | |||
80067 | 221843 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 124 College Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 2ft | 6004594.79724 | 2095953.61848 | 37.7353496453739 | -122.426549275423 | (37.7353496453739, -122.426549275423) | 2 | 7 | 5 | 28861 | 2 | |||
91117 | 221789 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3456 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 5ft | 6005341.04131 | 2103147.38287 | 37.7551442389361 | -122.424480760089 | (37.7551442389361, -122.424480760089) | 2 | 4 | 5 | 28859 | 19 | |||
129007 | 221787 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 124 27th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 8ft | 6005680.59891 | 2100245.58826 | 37.7471957491868 | -122.423100223394 | (37.7471957491868, -122.423100223394) | 2 | 7 | 5 | 28859 | 22 | |||
131328 | 221913 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3947 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6003448.79955 | 2102413.03039 | 37.7530208406643 | -122.430972273466 | (37.7530208406643, -122.430972273466) | 2 | 4 | 5 | 28862 | 22 | |||
152526 | 221816 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 27 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6007421.73456 | 2099361.81155 | 37.7448671975643 | -122.417016887145 | (37.7448671975643, -122.417016887145) | 2 | 7 | 7 | 28859 | 2 | |||
58635 | 63004 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 368 Highland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1986 12:00:00 AM | 20 | 4x6 | Permit Number 23414 | 6007279.07639479 | 2096499.56656681 | 37.7370000828457 | -122.417307379598 | (37.7370000828457, -122.417307379598) | 2 | 7 | 7 | 28859 | 2 |
100713 | 221919 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 80 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 5ft | 6004080.1128 | 2102611.51792 | 37.7536015922648 | -122.428803219313 | (37.7536015922648, -122.428803219313) | 2 | 4 | 5 | 28862 | 22 | |||
132523 | 115548 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 368 Highland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 20 | 4x6 | 6007279.07639479 | 2096499.56656681 | 37.7370000828457 | -122.417307379598 | (37.7370000828457, -122.417307379598) | 2 | 7 | 7 | 28859 | 2 | ||
150990 | 64607 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2451 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/18/1988 12:00:00 AM | 20 | Permit Number 25510 | 6008240.6573587 | 2104159.54552526 | 37.7580867271242 | -122.414524628823 | (37.7580867271242, -122.414524628823) | 2 | 4 | 7 | 28859 | 19 | |
153194 | 221788 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 67 Richland Ave | 1 | : | Tree | Private 2 | 20 | Width 4ft | 6005032.77253 | 2096203.58298 | 37.7360607419969 | -122.425052810752 | (37.7360607419969, -122.425052810752) | 2 | 7 | 5 | 28859 | 2 | |||
4442 | 221873 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 253 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007019.01293 | 2097474.10434 | 37.7396613127072 | -122.418275612445 | (37.7396613127072, -122.418275612445) | 2 | 7 | 7 | 28859 | 2 | |||
8855 | 221923 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 274 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002696.84533 | 2104324.2367 | 37.758225920618 | -122.433709258485 | (37.758225920618, -122.433709258485) | 2 | 4 | 5 | 28862 | 3 | |||
32001 | 221822 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 129 Ellert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6007356.42456 | 2097004.67982 | 37.7383913638823 | -122.417075731561 | (37.7383913638823, -122.417075731561) | 2 | 7 | 7 | 28859 | 2 | |||
92787 | 114424 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 724 MOULTRIE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 4x2 | 6007601 | 2096031 | 37.735731608506 | -122.416161167234 | (37.735731608506, -122.416161167234) | 2 | 7 | 7 | 28859 | 2 | |||
104584 | 221882 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 36 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007355.35831 | 2099292.63872 | 37.7446735303753 | -122.417241503608 | (37.7446735303753, -122.417241503608) | 2 | 7 | 7 | 28859 | 2 | |||
155422 | 221812 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 724 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6007603.04648 | 2096007.03362 | 37.7356659171455 | -122.416152394917 | (37.7356659171455, -122.416152394917) | 2 | 7 | 7 | 28859 | 2 | |||
22632 | 221918 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 78 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6004080.11539 | 2102633.34286 | 37.7536615185686 | -122.428804766139 | (37.7536615185686, -122.428804766139) | 2 | 4 | 5 | 28862 | 22 | |||
50598 | 221896 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 7 Marsily St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6004330.56552 | 2095607.66514 | 37.7343847942306 | -122.427438185126 | (37.7343847942306, -122.427438185126) | 2 | 7 | 5 | 28861 | 25 | |||
69139 | 221840 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 98 Bosworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 2ft | 6004312.44121 | 2095336.44977 | 37.7336390727743 | -122.427481531566 | (37.7336390727743, -122.427481531566) | 2 | 7 | 5 | 28861 | 25 | |||
72457 | 221800 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 170 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 2ft | 6004805.17774 | 2099321.48503 | 37.7446089338676 | -122.42606158838 | (37.7446089338676, -122.42606158838) | 2 | 7 | 5 | 63 | 22 | |||
140076 | 221903 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Marys Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6004552.30027 | 2095513.5436 | 37.7341388961924 | -122.426664875203 | (37.7341388961924, -122.426664875203) | 2 | 7 | 5 | 28861 | 25 | |||
1033 | 221901 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 7 Marsily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6004253.74444 | 2095482.9703 | 37.7340380650904 | -122.427694899296 | (37.7340380650904, -122.427694899296) | 2 | 7 | 5 | 28861 | 25 | |||
15498 | 221829 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2451 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6008243.92561 | 2104140.04763 | 37.7580333739666 | -122.414511946088 | (37.7580333739666, -122.414511946088) | 2 | 4 | 7 | 28859 | 19 | |||
66471 | 221841 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 5 Marsily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 2ft | 6004259.60988 | 2095362.69857 | 37.7337081577855 | -122.42766605444 | (37.7337081577855, -122.42766605444) | 2 | 7 | 5 | 28861 | 25 | |||
95845 | 221899 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 7 Marsily St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6004290.71623 | 2095557.06224 | 37.7342435961597 | -122.427572353179 | (37.7342435961597, -122.427572353179) | 2 | 7 | 5 | 28861 | 25 | |||
121593 | 221917 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1033 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6003826.31981 | 2102255.52555 | 37.7526097533439 | -122.429655503209 | (37.7526097533439, -122.429655503209) | 2 | 4 | 5 | 28862 | 22 | |||
126786 | 248223 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 70 Fair Ave | 5 | Side Yard : Yard | Tree | Private 2 | 18 | 6007150.20605 | 2099339.87769 | 37.744791694087 | -122.417954229812 | (37.744791694087, -122.417954229812) | 2 | 7 | 7 | 28859 | 2 | ||||
143450 | 221902 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 7 Marsily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6004251.61559 | 2095453.80279 | 37.7339578572562 | -122.427700181935 | (37.7339578572562, -122.427700181935) | 2 | 7 | 5 | 28861 | 25 | |||
144494 | 221905 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 572 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6002660.0308 | 2103294.31011 | 37.7553958998276 | -122.433762967812 | (37.7553958998276, -122.433762967812) | 2 | 4 | 5 | 28862 | 22 | |||
152125 | 221834 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 581 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6007293.84054 | 2103959.34746 | 37.7574837919732 | -122.417784945026 | (37.7574837919732, -122.417784945026) | 2 | 4 | 7 | 28859 | 19 | |||
183461 | 221802 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 325 Day St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 18 | Width 3ft | 6003816.24882 | 2098634.77002 | 37.7426674306639 | -122.42943214577 | (37.7426674306639, -122.42943214577) | 2 | 7 | 5 | 63 | 22 | |||
30130 | 221910 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1175 Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 6003225.80615 | 2101486.76003 | 37.7504648828526 | -122.431677300586 | (37.7504648828526, -122.431677300586) | 2 | 4 | 5 | 28862 | 22 | |||
32667 | 221878 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 18 Coleridge St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6006985.0649 | 2099647.22119 | 37.7456262946341 | -122.41854704763 | (37.7456262946341, -122.41854704763) | 2 | 7 | 7 | 28859 | 2 |
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) );