trees
455 rows where SiteOrder = 1, qLegalStatus_id = 1 and qSpecies_id = 65 sorted by YCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6446 | 262161 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 8 Mill St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | ||||||||||||
108759 | 175185 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 526 Lathrop Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6012801.34824 | 2086611.11374 | 37.7101575412033 | -122.397520974627 | (37.7101575412033, -122.397520974627) | 10 | 3 | 8 | 309 | 1 | |||
167603 | 108846 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 970 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 772762 | 6001611.41863 | 2086816.80035 | 37.7100928934503 | -122.436210250619 | (37.7100928934503, -122.436210250619) | 9 | 7 | 6 | 28861 | 5 | |
83894 | 108683 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 384 Allison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774613 | 6000302.20846 | 2086863.37515 | 37.7101463059777 | -122.440738464824 | (37.7101463059777, -122.440738464824) | 9 | 7 | 6 | 28861 | 5 |
69898 | 175184 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 190 Newton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001047.00422 | 2087602.25445 | 37.7122174923141 | -122.438217204682 | (37.7122174923141, -122.438217204682) | 9 | 7 | 6 | 28861 | 5 | |||
169503 | 65718 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 206 Pope St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1990 12:00:00 AM | 22 | Permit Number 28650 | 6000369.4893 | 2087691.53319 | 37.7124240746766 | -122.440565289581 | (37.7124240746766, -122.440565289581) | 9 | 7 | 6 | 28861 | 5 | |
190685 | 39931 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 175 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1999 12:00:00 AM | 16 | Permit Number 41202 | 6010293.70332 | 2087956.69983 | 37.7137123004597 | -122.406282682604 | (37.7137123004597, -122.406282682604) | 9 | 7 | 8 | 309 | 39 | |
164548 | 175191 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 193 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6010202.71269 | 2087988.02388 | 37.7137932196449 | -122.406599386967 | (37.7137932196449, -122.406599386967) | 9 | 7 | 8 | 309 | 39 | |||
83049 | 39933 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 180 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1999 12:00:00 AM | 17 | Permit Number 41204 | 6010299.07366 | 2087996.8284 | 37.7138227857583 | -122.406266946271 | (37.7138227857583, -122.406266946271) | 9 | 7 | 8 | 309 | 39 | |
13677 | 73831 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 102 Teddy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 19 | 6010808.25129 | 2088026.19044 | 37.713931877121 | -122.404509096323 | (37.713931877121, -122.404509096323) | 9 | 7 | 8 | 309 | 39 | |||
127600 | 39936 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 262 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1999 12:00:00 AM | 11 | Permit Number 41207 | 6009779.33678 | 2088185.9421 | 37.7143129666441 | -122.408076686195 | (37.7143129666441, -122.408076686195) | 9 | 7 | 8 | 309 | 39 | |
50392 | 203557 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 377 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5995020.43667 | 2088328.90175 | 37.7138680909275 | -122.459099244044 | (37.7138680909275, -122.459099244044) | 9 | 8 | 6 | 28861 | 24 | |||
119492 | 203554 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 209 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5994942.92929 | 2088379.09284 | 37.7140014477918 | -122.459370769157 | (37.7140014477918, -122.459370769157) | 9 | 8 | 6 | 28861 | 24 | |||
156178 | 175175 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 231 Rome St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 3ft | 5998599.64276 | 2088795.69735 | 37.7153549166607 | -122.446761792925 | (37.7153549166607, -122.446761792925) | 9 | 7 | 6 | 28861 | 25 | |||
87773 | 203558 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 179 Caine Ave | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5997048.33435 | 2088809.54157 | 37.7153041877202 | -122.45212476956 | (37.7153041877202, -122.45212476956) | 9 | 8 | 6 | 28861 | 24 | |||
69909 | 175176 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 226 Rome St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | 5998630.92665 | 2088821.65601 | 37.7154279802818 | -122.446655529047 | (37.7154279802818, -122.446655529047) | 9 | 7 | 6 | 28861 | 25 | |||
1937 | 78248 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 734 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 6002539.24351 | 2089283.26415 | 37.716917933889 | -122.433179625239 | (37.716917933889, -122.433179625239) | 9 | 7 | 6 | 28861 | 5 | |||
50747 | 65523 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 721 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1990 12:00:00 AM | 21 | Permit Number 28410 | 6001369.75843 | 2089371.25057 | 37.7170931137224 | -122.437228255287 | (37.7170931137224, -122.437228255287) | 9 | 7 | 6 | 28861 | 5 | |
138 | 203559 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 145 Lakeview Ave | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5997146.51683 | 2089373.33367 | 37.7168578537955 | -122.45182605794 | (37.7168578537955, -122.45182605794) | 9 | 8 | 6 | 28861 | 24 | |||
31637 | 117427 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 690 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2016 12:00:00 AM | 3 | Permit Number 776915 | 6002940.91679 | 2089412.44819 | 37.7172954225231 | -122.431800455543 | (37.7172954225231, -122.431800455543) | 9 | 7 | 6 | 28861 | 5 | ||
168312 | 175182 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 647 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6002406.62971 | 2090005.70634 | 37.718894076269 | -122.433689610108 | (37.718894076269, -122.433689610108) | 9 | 7 | 6 | 28861 | 5 | |||
186672 | 160894 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 642 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/11/2017 08:21:00 AM | 3 | Width 0ft | 6002380.66916 | 2090044.63219 | 37.7189994849067 | -122.433782126067 | (37.7189994849067, -122.433782126067) | 9 | 7 | 6 | 28861 | 5 | |
133303 | 160893 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 634 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/11/2017 08:15:00 AM | 3 | Width 0ft | 6002406.55833 | 2090085.42086 | 37.7191129505803 | -122.433695551007 | (37.7191129505803, -122.433695551007) | 9 | 7 | 6 | 28861 | 5 | |
105309 | 35840 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 621 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1998 12:00:00 AM | 18 | 6x7 | Permit Number 39067 | 6002271.78016 | 2090299.14404 | 37.7196921382746 | -122.434176697315 | (37.7196921382746, -122.434176697315) | 9 | 7 | 6 | 28861 | 5 |
182887 | 203553 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 259 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5994715.67756 | 2090305.5088 | 37.7192778601644 | -122.46029572277 | (37.7192778601644, -122.46029572277) | 9 | 8 | 6 | 28861 | 24 | |||
16813 | 160908 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 615 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/2019 12:00:00 AM | 3 | Width 0ft | 6002284.55838 | 2090317.50092 | 37.7197432674186 | -122.434133839205 | (37.7197432674186, -122.434133839205) | 9 | 7 | 6 | 28861 | 5 | |
6929 | 160451 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 99 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2020 12:00:00 AM | 3 | Width 0ft | 6001258.21118 | 2090347.83316 | 37.7197682487796 | -122.437683721428 | (37.7197682487796, -122.437683721428) | 9 | 7 | 6 | 28861 | 5 | ||
730 | 160454 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 11 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 0ft | 6001177.46897 | 2090398.6691 | 37.7199032415307 | -122.437966457494 | (37.7199032415307, -122.437966457494) | 9 | 7 | 6 | 28861 | 5 | ||
9080 | 160643 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 556 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 0ft | 6001401.85862 | 2090517.84189 | 37.7202432212254 | -122.437199350171 | (37.7202432212254, -122.437199350171) | 9 | 7 | 6 | 28861 | 5 | ||
191642 | 202091 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 82 Carr St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6012965.80047 | 2090628.94188 | 37.7211988543156 | -122.397234148441 | (37.7211988543156, -122.397234148441) | 10 | 3 | 8 | 58 | 1 | |||
143006 | 161013 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 46 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781526 | 6004792.42669 | 2090835.59849 | 37.7213078665529 | -122.425501874617 | (37.7213078665529, -122.425501874617) | 9 | 7 | 6 | 28861 | 5 | |
13433 | 161215 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 800 Brazil Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 3 | Width 0ft | 6003987.70302 | 2090927.51887 | 37.7215147582736 | -122.428290125502 | (37.7215147582736, -122.428290125502) | 9 | 7 | 6 | 28861 | 5 | ||
3053 | 262433 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 470 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 3x3 | 6001714 | 2091050 | 37.7217221467453 | -122.43615844491 | (37.7217221467453, -122.43615844491) | 9 | 7 | 6 | 28861 | 5 | |||
59999 | 38206 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 756 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | 11 | Permit Number 40330 | 6010781.48445 | 2091161.67808 | 37.7225397893635 | -122.404822228563 | (37.7225397893635, -122.404822228563) | 10 | 3 | 7 | 309 | 28 | |
80295 | 175183 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 404 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6003446.11855 | 2091231.22966 | 37.7223180210418 | -122.430183890869 | (37.7223180210418, -122.430183890869) | 9 | 7 | 6 | 28861 | 5 | |||
77457 | 175216 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 240 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6010752.32605 | 2091460.28671 | 37.7233580771044 | -122.404944037249 | (37.7233580771044, -122.404944037249) | 10 | 3 | 7 | 309 | 28 | |||
21642 | 38204 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 691 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | 14 | Permit Number 40328 | 6010720.89935 | 2091470.20831 | 37.7233835629968 | -122.405053372309 | (37.7233835629968, -122.405053372309) | 10 | 3 | 7 | 309 | 28 | |
18137 | 70176 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 307 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 3.5x4 to 3.5x7 | 6004287.81152 | 2091470.53201 | 37.7230227297861 | -122.42729139329 | (37.7230227297861, -122.42729139329) | 9 | 7 | 6 | 28861 | 5 | ||
4665 | 255219 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 668 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x5 | 6010649.61655 | 2091566.6998 | 37.7236445235288 | -122.405306576793 | (37.7236445235288, -122.405306576793) | 10 | 3 | 7 | 309 | 28 | ||
13672 | 70491 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 26 Ina Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 18 | 6005035.04728 | 2091735.87999 | 37.7237935486115 | -122.424727215697 | (37.7237935486115, -122.424727215697) | 9 | 7 | 6 | 28861 | 5 | |||
60136 | 108565 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 521 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772537 | 6010495.60195 | 2092202.94019 | 37.7253828953025 | -122.405883778414 | (37.7253828953025, -122.405883778414) | 10 | 3 | 7 | 309 | 28 |
45102 | 52520 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 54 Norton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | 30 | Permit Number 48621 | 6001810.81862 | 2092293.71669 | 37.7251426126309 | -122.4359127153 | (37.7251426126309, -122.4359127153) | 9 | 7 | 6 | 28861 | 25 | |
43315 | 38214 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 331 Wayland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | 11 | Permit Number 40337 | 6010588.27199 | 2092325.30166 | 37.7257240567036 | -122.405572039215 | (37.7257240567036, -122.405572039215) | 10 | 3 | 7 | 309 | 28 | |
93508 | 203530 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 355 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 5995608.47907 | 2092372.56646 | 37.7250048247995 | -122.457359125149 | (37.7250048247995, -122.457359125149) | 9 | 7 | 4 | 28861 | 40 | |||
172010 | 175193 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 28 Harrington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002083.86995 | 2092418.47999 | 37.7255006920777 | -122.434977725241 | (37.7255006920777, -122.434977725241) | 9 | 7 | 6 | 28861 | 25 | |||
33233 | 67291 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 701 Peru Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1992 12:00:00 AM | 19 | Permit Number 30767 | 6005304.50618 | 2092488.24493 | 37.725874593313 | -122.423849212975 | (37.725874593313, -122.423849212975) | 9 | 7 | 7 | 309 | 5 | |
15089 | 175203 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 655 Peru Ave | 1 | Side Yard : Yard | Tree | Private 2 | 52 | 6005189.8347 | 2092537.12043 | 37.7260023204239 | -122.424249099221 | (37.7260023204239, -122.424249099221) | 9 | 7 | 6 | 28861 | 5 | ||||
21664 | 175212 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 87x Valmar Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6005258.73549 | 2092540.80848 | 37.7260163372638 | -122.424011175489 | (37.7260163372638, -122.424011175489) | 9 | 7 | 7 | 309 | 5 | |||
69194 | 175204 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 653 Peru Ave | 1 | Side Yard : Yard | Tree | Private 2 | 7 | 6005107.43376 | 2092594.03644 | 37.72615394614 | -122.424538001034 | (37.72615394614, -122.424538001034) | 9 | 7 | 6 | 28861 | 5 | ||||
63890 | 35857 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 28 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1998 12:00:00 AM | 28 | 4x6 | Permit Number 39076 | 6002203.07861 | 2092639.23336 | 37.7261135989609 | -122.434581409299 | (37.7261135989609, -122.434581409299) | 9 | 7 | 6 | 28861 | 25 |
16252 | 203564 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 202 Elmwood Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 3ft | 5994856.42725 | 2092686.28381 | 37.7258229929193 | -122.459981583277 | (37.7258229929193, -122.459981583277) | 9 | 8 | 4 | 28861 | 40 | |||
53408 | 37793 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 347 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/06/1998 12:00:00 AM | 15 | Permit Number 40121 | 6009401.77176 | 2092702.5768 | 37.7266935573585 | -122.409700314138 | (37.7266935573585, -122.409700314138) | 10 | 3 | 7 | 309 | 28 | |
76373 | 175196 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 149 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6002904.02638 | 2092823.59155 | 37.7266595719653 | -122.432171435767 | (37.7266595719653, -122.432171435767) | 9 | 7 | 6 | 28861 | 5 | |||
110481 | 175078 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1584 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6001809.64472 | 2092991.82578 | 37.7270593952569 | -122.435966703417 | (37.7270593952569, -122.435966703417) | 9 | 7 | 6 | 28861 | 25 | |||
94208 | 52929 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 22 Cotter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2006 12:00:00 AM | 3 | 3x3 | Permit Number 48913 | 6002555.71096 | 2093126.63865 | 37.7274719160952 | -122.433397195531 | (37.7274719160952, -122.433397195531) | 9 | 7 | 6 | 28861 | 25 |
186585 | 175207 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 9 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6005359.84242 | 2093211.49837 | 37.7278636122004 | -122.423709320725 | (37.7278636122004, -122.423709320725) | 9 | 7 | 6 | 28861 | 5 | |||
65829 | 68256 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 243 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 16 | Permit Number 32061 | 6009551.9423 | 2093241.4503 | 37.7281816043806 | -122.409219186739 | (37.7281816043806, -122.409219186739) | 10 | 3 | 7 | 309 | 28 | |
7022 | 70397 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 130 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 21 | 6006350.25387 | 2093285.00079 | 37.7281212922586 | -122.420290654116 | (37.7281212922586, -122.420290654116) | 9 | 7 | 7 | 309 | 5 | |||
3223 | 70495 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 41 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6004160.99444 | 2093317.30941 | 37.7280863985552 | -122.427861302663 | (37.7280863985552, -122.427861302663) | 9 | 7 | 6 | 28861 | 5 | |||
2206 | 70527 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 25 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6004201.75826 | 2093380.33154 | 37.7282617492704 | -122.427724869209 | (37.7282617492704, -122.427724869209) | 9 | 7 | 6 | 28861 | 5 | |||
172987 | 95109 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 615 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2010 12:00:00 AM | 9 | 3x3 | Permit Number 54038 | 6001824.30736 | 2093468.52552 | 37.7283691373029 | -122.435950110013 | (37.7283691373029, -122.435950110013) | 9 | 7 | 6 | 28861 | 25 |
172281 | 203590 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 120 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5999238.54402 | 2093513.75556 | 37.7283460957772 | -122.444892431558 | (37.7283460957772, -122.444892431558) | 9 | 7 | 4 | 28861 | 40 | |||
76757 | 203585 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 122 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 5999428.77785 | 2093578.76175 | 37.7285354426355 | -122.444239456297 | (37.7285354426355, -122.444239456297) | 9 | 7 | 4 | 63 | 40 | |||
21660 | 65231 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 812 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1989 12:00:00 AM | 10 | Permit Number 28018 | 6008328.075 | 2093605.15348 | 37.7291116131036 | -122.41347586773 | (37.7291116131036, -122.41347586773) | 9 | 3 | 7 | 309 | 28 | ||
165874 | 38552 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1820 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 16 | Permit Number 40520 | 6015364.9925 | 2093693.5794 | 37.7297470188732 | -122.389154637038 | (37.7297470188732, -122.389154637038) | 10 | 3 | 8 | 58 | 1 | |
148858 | 203581 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 24 Gennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 5997456.8868 | 2093709.98189 | 37.7287830449036 | -122.451065815142 | (37.7287830449036, -122.451065815142) | 9 | 7 | 4 | 28861 | 40 | |||
175391 | 203584 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 391 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 5ft | 5997518.2723 | 2093790.63155 | 37.729008004011 | -122.450859415354 | (37.729008004011, -122.450859415354) | 9 | 7 | 4 | 28861 | 40 | |||
146650 | 170415 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 216 Theresa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 779296 | 6001929.08412 | 2093967.91374 | 37.7297462952572 | -122.435623604862 | (37.7297462952572, -122.435623604862) | 9 | 7 | 6 | 28861 | 25 | |
142087 | 203547 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 181 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 5999467.73526 | 2094058.60837 | 37.7298552121426 | -122.444139244847 | (37.7298552121426, -122.444139244847) | 9 | 7 | 4 | 63 | 40 | |||
38029 | 203546 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 431 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 2ft | 5997874.7531 | 2094083.70134 | 37.7298331050033 | -122.449648149961 | (37.7298331050033, -122.449648149961) | 9 | 7 | 4 | 28861 | 40 | |||
53331 | 203580 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 118 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 3ft | 5999938.98985 | 2094086.49898 | 37.7299586665457 | -122.442512069977 | (37.7299586665457, -122.442512069977) | 9 | 7 | 4 | 63 | 40 | |||
3760 | 203545 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 521 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5997305.75976 | 2094091.3285 | 37.7298214785687 | -122.451615764982 | (37.7298214785687, -122.451615764982) | 9 | 7 | 4 | 28861 | 40 | |||
88150 | 82830 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1475 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2009 12:00:00 AM | 9 | 3x3 | Permit Number 52467 | 6015906.1825 | 2094100.414 | 37.7308940918936 | -122.387312034756 | (37.7308940918936, -122.387312034756) | 10 | 3 | 8 | 58 | 1 | |
60145 | 38581 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1483 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 15 | Permit Number 40541 | 6015866.8585 | 2094128.4257 | 37.7309688285238 | -122.387449938884 | (37.7309688285238, -122.387449938884) | 10 | 3 | 8 | 58 | 1 | |
104017 | 35736 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 351 Hale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/14/1998 12:00:00 AM | 9 | Permit Number 39011 | 6008805.61164 | 2094302.44729 | 37.731053034462 | -122.411874232722 | (37.731053034462, -122.411874232722) | 9 | 3 | 7 | 309 | 28 | |
20955 | 203536 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 347 Hearst Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 6ft | 5999101.32072 | 2094349.11818 | 37.7306319736778 | -122.445426858158 | (37.7306319736778, -122.445426858158) | 9 | 7 | 4 | 28861 | 40 | |||
111548 | 203537 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 313 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 2X2 | 5999311.41277 | 2094355.91227 | 37.7306626198655 | -122.44470102883 | (37.7306626198655, -122.44470102883) | 9 | 7 | 4 | 28861 | 40 | |||
20470 | 203539 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 350 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5999078.20964 | 2094394.83884 | 37.7307561925253 | -122.445510042754 | (37.7307561925253, -122.445510042754) | 9 | 7 | 4 | 59 | 40 | |||
124142 | 203542 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 518 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 5997986.70851 | 2094410.29201 | 37.7307362500736 | -122.449284629593 | (37.7307362500736, -122.449284629593) | 9 | 7 | 4 | 59 | 40 | |||
39358 | 203544 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 522 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 2ft | 5997938.28847 | 2094411.07212 | 37.730735622335 | -122.449452080662 | (37.730735622335, -122.449452080662) | 9 | 7 | 4 | 59 | 40 | |||
171216 | 203540 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 305 Foerster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5998091.57112 | 2094441.2535 | 37.7308272605603 | -122.448924334186 | (37.7308272605603, -122.448924334186) | 9 | 7 | 4 | 59 | 40 | |||
3392 | 70645 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 67 Lamartine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6002626.20323 | 2094469.32888 | 37.7311626384362 | -122.433249403638 | (37.7311626384362, -122.433249403638) | 9 | 7 | 5 | 28861 | 25 | |||
133146 | 175192 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 63 Lamartine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6002620.39107 | 2094490.53041 | 37.7312205232959 | -122.433271011664 | (37.7312205232959, -122.433271011664) | 9 | 7 | 5 | 28861 | 25 | |||
146627 | 175215 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 857 Barneveld Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 33 | Width 8ft | 6010301.67863 | 2094727.33157 | 37.7323034959049 | -122.406731980322 | (37.7323034959049, -122.406731980322) | 10 | 3 | 7 | 309 | 28 | |||
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 | ||
99091 | 203574 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 32 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6001891.78226 | 2094951.97424 | 37.7324461814313 | -122.435822942293 | (37.7324461814313, -122.435822942293) | 9 | 7 | 5 | 63 | 40 | |||
105355 | 203573 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 22 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6001918.41123 | 2094952.28541 | 37.7324485484508 | -122.435730902059 | (37.7324485484508, -122.435730902059) | 9 | 7 | 5 | 63 | 40 | |||
102685 | 203577 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 268 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 4ft | 6000290.88836 | 2094968.30244 | 37.7323999463844 | -122.441358765897 | (37.7323999463844, -122.441358765897) | 9 | 7 | 5 | 63 | 40 | |||
139320 | 203578 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 312 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5999939.80462 | 2094974.46238 | 37.7323968536154 | -122.442572982852 | (37.7323968536154, -122.442572982852) | 9 | 7 | 4 | 63 | 40 | |||
160888 | 97263 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 220 Gaven St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773740 | 6009330.61336 | 2094994.97082 | 37.7329839958128 | -122.410108077526 | (37.7329839958128, -122.410108077526) | 10 | 3 | 7 | 309 | 28 | |
152880 | 221838 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 115 Cuvier St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004035.03303 | 2095100.17103 | 37.7329746104714 | -122.42842377735 | (37.7329746104714, -122.42842377735) | 9 | 7 | 5 | 28861 | 25 | |||
3939 | 53160 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1747@ 3RD ST Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2006 12:00:00 AM | 8 | Permit Number 49080 | 6014477.38224 | 2095160.1105 | 37.7337245704136 | -122.392325759332 | (37.7337245704136, -122.392325759332) | 10 | 3 | 8 | 58 | 1 | |
33222 | 203575 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 60 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 5ft | 6001009.56246 | 2095231.0134 | 37.7331622045591 | -122.438892966938 | (37.7331622045591, -122.438892966938) | 9 | 7 | 5 | 63 | 40 | |||
58364 | 27336 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 615 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/2000 12:00:00 AM | 3 | 2X3 | 6002282.10236 | 2095328.35794 | 37.7335018092598 | -122.434500417276 | (37.7335018092598, -122.434500417276) | 9 | 7 | 5 | 63 | 40 | ||
177042 | 221839 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 98 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6004329.20117 | 2095336.95284 | 37.7336414020218 | -122.42742362331 | (37.7336414020218, -122.42742362331) | 2 | 7 | 5 | 28861 | 25 | |||
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 | |||
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 | |||
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 | |||
23728 | 225 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2962 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/17/1991 12:00:00 AM | 40 | 3X4 | 5990608.66265 | 2095460.33335 | 37.7331946143326 | -122.474868041333 | (37.7331946143326, -122.474868041333) | 1 | 8 | 4 | 64 | 40 | ||
98589 | 203535 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 68 Rosewood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5994859.58645 | 2095502.43187 | 37.7335556327814 | -122.460174598491 | (37.7335556327814, -122.460174598491) | 9 | 8 | 4 | 59 | 40 |
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) );