Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 137888 | 137888 | 214039 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 57 Nordhoff St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6000414.26094 | 2095519.5651200002 | 37.7339206127394 | -122.440971772322 | (37.7339206127394, -122.440971772322) | |||
| 56835 | 56835 | 240403 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 557 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002931.13898 | 2099759.29881 | 37.7457049727185 | -122.43257290392799 | (37.7457049727185, -122.432572903928) | |||
| 124738 | 124738 | 37419 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 557 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39897 | 6002931.14322816 | 2099749.14332352 | 37.7456770883652 | -122.432572163971 | (37.7456770883652, -122.432572163971) | ||
| 17788 | 17788 | 18608 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 550 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/1997 12:00:00 AM | 6 | 3X3 | 5992502.2173 | 2088557.38 | 37.7143503484358 | -122.467819678694 | (37.7143503484358, -122.467819678694) | ||
| 117895 | 117895 | 40701 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 547 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | Permit Number 41680 | 6005025.18813412 | 2093548.59411277 | 37.7287703058889 | -122.424890201858 | (37.7287703058889, -122.424890201858) | ||
| 15769 | 15769 | 30659 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 54 Lafayette St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/2015 12:00:00 AM | 3 | 3x3 | Permit Number 34592 | 6007591.74325 | 2109572.72569 | 37.7729135790239 | -122.41715242667 | (37.7729135790239, -122.41715242667) |
| 125273 | 125273 | 41593 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 538 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | Permit Number 43228 | 6003084.80949648 | 2098934.42438565 | 37.7434487728436 | -122.431982642828 | (37.7434487728436, -122.431982642828) | ||
| 112273 | 112273 | 66617 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 537 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/24/1994 12:00:00 AM | Permit Number 29820 | 6003370.78769204 | 2095896.23030716 | 37.7351227979483 | -122.430777034501 | (37.7351227979483, -122.430777034501) | ||
| 21649 | 21649 | 18607 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 530 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/26/1996 12:00:00 AM | 6 | 3x3 | 5992558.0676 | 2088557.0731 | 37.7143527306111 | -122.467626617395 | (37.7143527306111, -122.467626617395) | ||
| 113563 | 113563 | 18603 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 520 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/25/1996 12:00:00 AM | 6 | 3X3 | 5992619.61154 | 2088559.40218 | 37.7143626789426 | -122.467414068351 | (37.7143626789426, -122.467414068351) | ||
| 25889 | 25889 | 48457 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 520 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2002 12:00:00 AM | 6 | Permit Number 45824 | 6011919.3472 | 2110495.26684 | 37.7756891719521 | -122.402247516312 | (37.7756891719521, -122.402247516312) | ||
| 147458 | 147458 | 48456 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 520 06th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2002 12:00:00 AM | 7 | Permit Number 45824 | 6011955.4839699995 | 2110455.52014 | 37.7755820536976 | -122.402119714552 | (37.7755820536976, -122.402119714552) | ||
| 148570 | 148570 | 48459 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 520 06th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2002 12:00:00 AM | 2 | Permit Number 45824 | 6011943.63031 | 2110470.08202 | 37.775621375652705 | -122.40216174348998 | (37.7756213756527, -122.40216174349) | ||
| 174499 | 174499 | 48458 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 520 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2002 12:00:00 AM | 3 | Permit Number 45824 | 6011932.18219 | 2110480.19141 | 37.7756484947135 | -122.402202056493 | (37.7756484947135, -122.402202056493) | ||
| 11876 | 11876 | 38200 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 514 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 12 | 3x3 | Permit Number 45184 | 6010449.69037 | 2092207.2371 | 37.7253921259422 | -122.406042793857 | (37.7253921259422, -122.406042793857) |
| 99236 | 99236 | 101956 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 510X Berry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6x6 | 6012441.7 | 2108540.8 | 37.7703517934984 | -122.400303251175 | (37.7703517934984, -122.400303251175) | |||
| 135936 | 135936 | 214037 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 510 Ramsell St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5993017.248790001 | 2090566.81293 | 37.719897493047704 | -122.466185481793 | (37.7198974930477, -122.466185481793) | |||
| 83362 | 83362 | 63013 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 51 Wool St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767771 | 6007430.33105591 | 2097971.50142259 | 37.7410501993506 | -122.416888678035 | (37.7410501993506, -122.416888678035) | |
| 59339 | 59339 | 197337 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 501 Amador St | 8 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6017571.01278 | 2099537.71438 | 37.7459158925037 | -122.381934448315 | (37.7459158925037, -122.381934448315) | |||
| 146955 | 146955 | 197338 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 501 Amador St | 9 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6017587.31479 | 2099538.4559 | 37.745918828809295 | -122.381878129198 | (37.7459188288093, -122.381878129198) | |||
| 188758 | 188758 | 217581 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 500 Randolph St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5992611.7697 | 2088555.8456 | 37.714352460703104 | -122.467440914144 | (37.7143524607031, -122.467440914144) | |||
| 29920 | 29920 | 240423 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 5 Penny Ln | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | Width 2ft | 6002449.92079 | 2096381.9214299999 | 37.7364041778047 | -122.433995506402 | (37.7364041778047, -122.433995506402) | |||
| 35387 | 35387 | 240421 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 5 Penny Ln | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | Width 2ft | 6002440.8921300005 | 2096392.57557 | 37.736432919229706 | -122.43402748359101 | (37.7364329192297, -122.434027483591) | |||
| 71286 | 71286 | 240425 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 5 Penny Ln | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | Width 2ft | 6002456.8751300005 | 2096374.3168900001 | 37.736383692152295 | -122.433970918943 | (37.7363836921523, -122.433970918943) | |||
| 73730 | 73730 | 240424 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 5 Penny Ln | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 2ft | 6002452.23233 | 2096379.1355 | 37.7363966594644 | -122.43398731536502 | (37.7363966594644, -122.433987315365) | |||
| 188488 | 188488 | 240422 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 5 Penny Ln | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 2ft | 6002442.71855 | 2096389.33655 | 37.7364241292793 | -122.43402093743201 | (37.7364241292793, -122.434020937432) | |||
| 54599 | 54599 | 240401 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 499 Hoffman Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000694.66286 | 2101176.32982 | 37.749468718214004 | -122.440407898332 | (37.749468718214, -122.440407898332) | |||
| 126641 | 126641 | 32859 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 499 Hoffman Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/1996 12:00:00 AM | Permit Number 37207 | 6000703.6978076 | 2101134.48618072 | 37.7493543400616 | -122.440373654783 | (37.7493543400616, -122.440373654783) | |||
| 141851 | 141851 | 32857 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 499 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/1996 12:00:00 AM | Permit Number 37207 | 6000703.6978076 | 2101134.48618072 | 37.7493543400616 | -122.440373654783 | (37.7493543400616, -122.440373654783) | |||
| 142436 | 142436 | 32858 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 499 Hoffman Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/30/1996 12:00:00 AM | Permit Number 37207 | 6000703.6978076 | 2101134.48618072 | 37.7493543400616 | -122.440373654783 | (37.7493543400616, -122.440373654783) | |||
| 179090 | 179090 | 240400 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 499 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000695.68287 | 2101155.78818 | 37.74941237387971 | -122.440402898093 | (37.7494123738797, -122.440402898093) | |||
| 178929 | 178929 | 247983 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 497 Peralta Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6009757.51939 | 2099637.18115 | 37.74575442014729 | -122.408959568646 | (37.7457544201473, -122.408959568646) | ||||
| 187182 | 187182 | 247984 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 497 Peralta Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6009751.76686 | 2099644.8640900003 | 37.745775193576705 | -122.408980002136 | (37.7457751935767, -122.408980002136) | ||||
| 115972 | 115972 | 74680 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 493 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/2013 12:00:00 AM | 3x3 | Permit Number 769961 | 6011188.26118785 | 2118621.30079081 | 37.79796050165611 | -122.405348925503 | (37.7979605016561, -122.405348925503) | ||
| 10245 | 10245 | 43062 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 490 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2017 12:00:00 AM | 3 | 3x3 | Permit Number 51464 | 5985348.18764 | 2112571.6735099996 | 37.779871377757296 | -122.49431551232401 | (37.7798713777573, -122.494315512324) | |
| 30553 | 30553 | 240407 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 489 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6003411.63679 | 2096255.36709 | 37.7361112200507 | -122.430661423705 | (37.7361112200507, -122.430661423705) | |||
| 116144 | 116144 | 87465 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 485 Scott St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2008 12:00:00 AM | 3x3 | Permit Number 50381 | 6002157.0 | 2110126.0 | 37.77412549340271 | -122.43599141878201 | (37.7741254934027, -122.435991418782) | |||
| 75380 | 75380 | 40197 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 4845 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1999 12:00:00 AM | 5 | Permit Number 41381 | 5983545.15866 | 2111697.12052 | 37.7773644306872 | -122.50048820674401 | (37.7773644306872, -122.500488206744) | |
| 119499 | 119499 | 40199 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 4845 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1999 12:00:00 AM | 5 | Permit Number 41381 | 5983584.60152 | 2111699.05511 | 37.7773720577908 | -122.500351906273 | (37.7773720577908, -122.500351906273) | |
| 156274 | 156274 | 40198 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 4845 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1999 12:00:00 AM | 4 | Permit Number 41381 | 5983564.00887 | 2111698.1064299997 | 37.7773682442298 | -122.500423071675 | (37.7773682442298, -122.500423071675) | |
| 76501 | 76501 | 240390 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 48 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6005917.96775 | 2097681.76661 | 37.740169467433894 | -122.42209730935801 | (37.7401694674339, -122.422097309358) | |||
| 79913 | 79913 | 179372 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 479 Goettingen St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010444.86472 | 2092384.67512 | 37.72587906384779 | -122.40607197057 | (37.7258790638478, -122.40607197057) | |||
| 173397 | 173397 | 179371 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 479 Goettingen St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010448.30169 | 2092366.9553099999 | 37.7258306011814 | -122.40605884135401 | (37.7258306011814, -122.406058841354) | |||
| 97680 | 97680 | 112525 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 471 BROADWAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6011292.0 | 2118586.0 | 37.7978693737352 | -122.40498747086399 | (37.7978693737352, -122.404987470864) | ||||
| 140610 | 140610 | 112526 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 471 BROADWAY | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6011292.0 | 2118586.0 | 37.7978693737352 | -122.40498747086399 | (37.7978693737352, -122.404987470864) | ||||
| 147943 | 147943 | 95925 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 467 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767622 | 5988731.71404 | 2112146.6899 | 37.7789019165926 | -122.482579385158 | (37.7789019165926, -122.482579385158) |
| 130254 | 130254 | 136325 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 464 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6011322.0 | 2118712.0 | 37.7982170161506 | -122.404892537684 | (37.7982170161506, -122.404892537684) | |||
| 177684 | 177684 | 112546 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 464 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 6011322.0 | 2118712.0 | 37.7982170161506 | -122.404892537684 | (37.7982170161506, -122.404892537684) | |||
| 27782 | 27782 | 136327 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 463 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6011305.85301 | 2118630.68117 | 37.797992831771495 | -122.404942682854 | (37.7979928317715, -122.404942682854) | |||
| 42442 | 42442 | 136326 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 463 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6011288.49181 | 2118628.67213 | 37.797986344959995 | -122.405002616378 | (37.79798634496, -122.405002616378) | |||
| 26432 | 26432 | 141346 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 463 BRODERICK ST | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 6001145.1037 | 2110334.7664 | 37.774641176317104 | -122.439506706044 | (37.7746411763171, -122.439506706044) | |||
| 81181 | 81181 | 112547 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 462 BROADWAY | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6011324.0 | 2118723.0 | 37.798247331278 | -122.404886391926 | (37.798247331278, -122.404886391926) | ||||
| 90622 | 90622 | 112528 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 459 BROADWAY | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6011361.0 | 2118561.0 | 37.797804586609004 | -122.40474694923401 | (37.797804586609, -122.404746949234) | ||||
| 102926 | 102926 | 112527 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 459 BROADWAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6011361.0 | 2118561.0 | 37.797804586609004 | -122.40474694923401 | (37.797804586609, -122.404746949234) | ||||
| 103341 | 103341 | 112529 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 459 BROADWAY | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6011361.0 | 2118561.0 | 37.797804586609004 | -122.40474694923401 | (37.797804586609, -122.404746949234) | ||||
| 81988 | 81988 | 69511 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 457 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/24/1994 12:00:00 AM | Permit Number 33638 | 6008927.18415449 | 2096207.51304953 | 37.736290754505 | -122.41158848323201 | (37.736290754505, -122.411588483232) | ||
| 157900 | 157900 | 240389 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 457 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6008913.61949 | 2096192.37009 | 37.7362484143157 | -122.41163431247601 | (37.7362484143157, -122.411634312476) | |||
| 113228 | 113228 | 46365 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 4529 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2016 12:00:00 AM | 3 | Permit Number 777876 | 6000886.82649096 | 2105194.29533435 | 37.7605120176306 | -122.44003146279199 | (37.7605120176306, -122.440031462792) | ||
| 38309 | 38309 | 120769 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 4500 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5989405.82896 | 2109925.10593 | 37.7728412569544 | -122.48008475013701 | (37.7728412569544, -122.480084750137) | |||
| 137736 | 137736 | 136324 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 448 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6011401.0 | 2118734.0 | 37.798281838344 | -122.404620722239 | (37.798281838344, -122.404620722239) | |||
| 140802 | 140802 | 112543 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 448 BROADWAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6011394.0 | 2118786.0 | 37.798424226523 | -122.404648607058 | (37.798424226523, -122.404648607058) | ||||
| 35219 | 35219 | 136329 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 447 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | Width 3ft | 6011341.08824 | 2118636.57968 | 37.7980109971731 | -122.404821173685 | (37.7980109971731, -122.404821173685) | |||
| 135504 | 135504 | 136328 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 447 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | Width 3ft | 6011327.03299 | 2118633.79421 | 37.7980025633245 | -122.40486961294201 | (37.7980025633245, -122.404869612942) | |||
| 187146 | 187146 | 136330 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 447 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | Width 3ft | 6011365.830569999 | 2118639.8560599997 | 37.7980213762507 | -122.40473578841998 | (37.7980213762507, -122.40473578842) | |||
| 70628 | 70628 | 240402 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 4440 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6000362.39575 | 2102290.8235 | 37.7525099241126 | -122.441636854259 | (37.7525099241126, -122.441636854259) | |||
| 119575 | 119575 | 88274 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 4440 23rd St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51264 | 6000402.0 | 2102285.0 | 37.7524961905728 | -122.441499478589 | (37.7524961905728, -122.441499478589) | |||
| 78865 | 78865 | 41694 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 444 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42146 | 6003561.9148943005 | 2096429.88916823 | 37.7365989305362 | -122.430154297904 | (37.7365989305362, -122.430154297904) | ||
| 160691 | 160691 | 81886 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 44 Toledo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50856 | 6001667.32434 | 2120063.59572 | 37.801383746212295 | -122.43839740632299 | (37.8013837462123, -122.438397406323) | |
| 2370 | 2370 | 112542 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 438 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/24/2016 12:00:00 AM | 3 | 3x3 | 6011405.06525 | 2118709.9257400003 | 37.7982159634572 | -122.40460495956002 | (37.7982159634572, -122.40460495956) | ||
| 46584 | 46584 | 112541 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 438 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 6011421.73685 | 2118713.41459 | 37.798226474727 | -122.404547516275 | (37.798226474727, -122.404547516275) | |||
| 18385 | 18385 | 25468 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 437 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/26/1996 12:00:00 AM | 6 | 3X3 | 5992774.4094 | 2088493.0908 | 37.7141895393891 | -122.466874212626 | (37.7141895393891, -122.466874212626) | ||
| 26763 | 26763 | 240404 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 4362 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6000898.63467 | 2103311.26449 | 37.7553423460847 | -122.439855611169 | (37.7553423460847, -122.439855611169) | |||
| 6998 | 6998 | 112530 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 435 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/24/2016 07:26:00 AM | 3 | 3x3 | 6011409.86951 | 2118646.99301 | 37.7980434339179 | -122.40458390283199 | (37.7980434339179, -122.404583902832) | ||
| 173900 | 173900 | 112532 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 435 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6011441.2715 | 2118651.0791599997 | 37.7980564084299 | -122.404475530047 | (37.7980564084299, -122.404475530047) | |||
| 115976 | 115976 | 112531 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 435 BROADWAY | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6011430.0 | 2118629.0 | 37.79799515449189 | -122.404512977901 | (37.7979951544919, -122.404512977901) | ||||
| 135840 | 135840 | 117962 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 4340 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5985111.43248 | 2111810.6865 | 37.7777680685843 | -122.495078411045 | (37.7777680685843, -122.495078411045) | |||
| 157979 | 157979 | 89252 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 433 34th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/14/2008 12:00:00 AM | 4 | 4x4 | Permit Number 51885 | 5985288.27991 | 2112944.4922700003 | 37.780891524599 | -122.49455024837 | (37.780891524599, -122.49455024837) | ||
| 68016 | 68016 | 112540 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 432 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 6011444.64707 | 2118714.34063 | 37.7982302977556 | -122.404468304876 | (37.7982302977556, -122.404468304876) | |||
| 46883 | 46883 | 214041 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 431 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5997281.4748599995 | 2093791.4004 | 37.7289965565343 | -122.451678093372 | (37.7289965565343, -122.451678093372) | |||
| 108862 | 108862 | 48965 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 4287 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/02/2002 12:00:00 AM | Permit Number 46152 | 6001312.92675412 | 2102294.38376547 | 37.7525738106184 | -122.438350019053 | (37.7525738106184, -122.438350019053) | ||
| 6247 | 6247 | 112539 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 426 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/12/2016 11:10:00 AM | 3 | 3x3 | 6011460.82325 | 2118719.23159 | 37.7982446311281 | -122.404412674615 | (37.7982446311281, -122.404412674615) | ||
| 27615 | 27615 | 47743 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 4201 Clement St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/2002 12:00:00 AM | 6 | Permit Number 45527 | 5982418.5702 | 2113061.40286 | 37.78104415210971 | -122.50448647782 | (37.7810441521097, -122.50448647782) | |
| 63294 | 63294 | 47746 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 4201 Clement St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/2002 12:00:00 AM | 6 | Permit Number 45527 | 5982405.06542 | 2113061.4232400004 | 37.781043413721704 | -122.50453319829201 | (37.7810434137217, -122.504533198292) | |
| 68181 | 68181 | 47745 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 4201 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/2002 12:00:00 AM | 5 | Permit Number 45527 | 5982377.51547 | 2113061.47559 | 37.7810419369254 | -122.50462850953998 | (37.7810419369254, -122.50462850954) | |
| 161972 | 161972 | 47744 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 4201 Clement St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/30/2002 12:00:00 AM | 5 | Permit Number 45527 | 5982434.29257 | 2113064.02501 | 37.7810522765206 | -122.504432281557 | (37.7810522765206, -122.504432281557) | |
| 45898 | 45898 | 78303 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 4200 Anza St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 8 | 5985601.84615 | 2111830.0583200003 | 37.7778499560934 | -122.493383352985 | (37.7778499560934, -122.493383352985) | ||
| 175872 | 175872 | 78389 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 4200 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 8 | 5985613.90998 | 2111830.68363 | 37.77785237866 | -122.49334166667101 | (37.77785237866, -122.493341666671) | ||
| 131736 | 131736 | 112538 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 412 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/10/2016 12:00:00 AM | 2 | 3x3 | 6011488.50983 | 2118723.0183900003 | 37.7982565759239 | -122.40431713692699 | (37.7982565759239, -122.404317136927) | ||
| 176846 | 176846 | 112537 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 412 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 6011527.0722 | 2118728.8461599997 | 37.7982747323527 | -122.404184109226 | (37.7982747323527, -122.404184109226) | |||
| 78673 | 78673 | 40783 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 410 Monticello St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/1999 12:00:00 AM | Permit Number 41739 | 5991762.23808711 | 2091284.45671221 | 37.7217954779898 | -122.470575817994 | (37.7217954779898, -122.470575817994) | ||
| 89337 | 89337 | 40785 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 410 Monticello St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/1999 12:00:00 AM | Permit Number 41739 | 5991762.23808711 | 2091284.45671221 | 37.7217954779898 | -122.470575817994 | (37.7217954779898, -122.470575817994) | ||
| 96644 | 96644 | 40784 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 410 Monticello St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/1999 12:00:00 AM | Permit Number 41739 | 5991762.23808711 | 2091284.45671221 | 37.7217954779898 | -122.470575817994 | (37.7217954779898, -122.470575817994) | ||
| 122873 | 122873 | 40786 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 410 Monticello St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/1999 12:00:00 AM | Permit Number 41739 | 5991762.23808711 | 2091284.45671221 | 37.7217954779898 | -122.470575817994 | (37.7217954779898, -122.470575817994) | ||
| 17486 | 17486 | 18596 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 409 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/26/1996 12:00:00 AM | 6 | 3X3 | 5992903.2652 | 2088492.7734 | 37.7141961040887 | -122.46642881780501 | (37.7141961040887, -122.466428817805) | ||
| 84564 | 84564 | 82884 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 398 11th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52426 | 6008893.02169344 | 2108709.50255899 | 37.770616489827106 | -122.412590100264 | (37.7706164898271, -122.412590100264) | ||
| 95116 | 95116 | 82767 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 398 11th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52426 | 6008893.02169344 | 2108709.50255899 | 37.770616489827106 | -122.412590100264 | (37.7706164898271, -122.412590100264) | ||
| 106143 | 106143 | 87075 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 395 Byxbee St | 6 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947.0 | 2091188.0 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | |||
| 111937 | 111937 | 87074 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 395 Byxbee St | 5 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 12/18/2007 12:00:00 AM | Permit Number 50011 | 5991947.0 | 2091188.0 | 37.7215413135876 | -122.469930130394 | (37.7215413135876, -122.469930130394) | |||
| 84367 | 84367 | 97195 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 390X Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2015 12:00:00 AM | 3 | Permit Number 775228 | 6011720.2 | 2118742.9 | 37.7983241100995 | -122.403516814582 | (37.7983241100995, -122.403516814582) | ||
| 43449 | 43449 | 69150 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 3826 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/18/1994 12:00:00 AM | 4 | Permit Number 33185 | 5984181.23627049 | 2098183.21295551 | 37.7402963417492 | -122.49728998800501 | (37.7402963417492, -122.497289988005) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");