trees
1,985 rows where qSpecies_id = 83 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1477 | 112866 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 750 VICENTE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990595 | 2097751 | 37.7394834085128 | -122.475082436927 | (37.7394834085128, -122.475082436927) | 1 | 8 | 4 | 29491 | 40 | ||||
2453 | 49617 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1626 Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2003 12:00:00 AM | Permit Number 46477 | 6008114.57908688 | 2108709.83276472 | 37.7705736773564 | -122.415282774124 | (37.7705736773564, -122.415282774124) | 8 | 2 | 9 | 28853 | 19 | |||
2641 | 262546 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 131 Apollo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/18/2020 12:00:00 AM | 6012643 | 2094250 | 37.731123564074 | -122.398603958182 | (37.731123564074, -122.398603958182) | 10 | 3 | 8 | 58 | 1 | |||
2762 | 46200 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
3450 | 52146 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 145 Hawes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2005 12:00:00 AM | Permit Number 48337 | |||||||||||||
3492 | 30592 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 269 Walter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1995 12:00:00 AM | Permit Number 34561 | |||||||||||||
3900 | 36339 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 59 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/01/2003 12:00:00 AM | Permit Number 46658 | 5995617.4906106 | 2092991.57857678 | 37.726705001322 | -122.457372735726 | (37.726705001322, -122.457372735726) | 9 | 7 | 4 | 28861 | 40 | ||
4690 | 66408 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 632 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/1991 12:00:00 AM | Permit Number 29535 | 6007948.77791486 | 2095967.06920677 | 37.7355756171998 | -122.414954236685 | (37.7355756171998, -122.414954236685) | 2 | 7 | 7 | 28859 | 2 | ||
5967 | 252969 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 101 Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 5998071 | 2087307 | 37.7112370808248 | -122.448481858962 | (37.7112370808248, -122.448481858962) | 9 | 7 | 6 | 28861 | 25 | ||||
6409 | 61556 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2098X 23RD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/25/1984 12:00:00 AM | Permit Number 21516 | 6012360 | 2102825 | 37.7546529200548 | -122.400184359163 | (37.7546529200548, -122.400184359163) | 10 | 3 | 8 | 28856 | 29 | ||
8679 | 63303 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3270 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1987 12:00:00 AM | Permit Number 23869 | 6008997.33415907 | 2099641.55348585 | 37.7457238133599 | -122.411588497717 | (37.7457238133599, -122.411588497717) | 2 | 7 | 7 | 28859 | 2 | ||
8966 | 38869 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2439 29th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40694 | 5987327.75302366 | 2098677.68678111 | 37.7418379454862 | -122.486447023752 | (37.7418379454862, -122.486447023752) | 1 | 8 | 3 | 29491 | 35 | ||
9184 | 88476 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1531 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51429 | 6015551.7 | 2096433.9 | 37.7372817351758 | -122.388700383218 | (37.7372817351758, -122.388700383218) | 10 | 3 | 8 | 58 | 1 | ||
9712 | 63295 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 29 Bessie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1987 12:00:00 AM | Permit Number 23861 | 6008153.74699222 | 2100060.03492719 | 37.7468255141172 | -122.414535115214 | (37.7468255141172, -122.414535115214) | 2 | 7 | 7 | 28859 | 2 | ||
9907 | 30593 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 269 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1995 12:00:00 AM | Permit Number 34561 | |||||||||||||
10498 | 41462 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 454 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2000 12:00:00 AM | Permit Number 42047 | 5993018.04440435 | 2090196.48136289 | 37.7188806981616 | -122.466155833772 | (37.7188806981616, -122.466155833772) | 9 | 8 | 6 | 64 | 24 | |||
10522 | 31312 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 709 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/1995 12:00:00 AM | Permit Number 34949 | 6004473.77987727 | 2110903.29372292 | 37.7763910940647 | -122.428032671161 | (37.7763910940647, -122.428032671161) | 7 | 9 | 11 | 28852 | 10 | |||
10528 | 96053 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 130 Coso Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767681 | 6007306.3 | 2099659 | 37.745676716208 | -122.417437096994 | (37.745676716208, -122.417437096994) | 2 | 7 | 7 | 28859 | 2 | |
11660 | 120676 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1 Ford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003502 | 2105614 | 37.7618129556584 | -122.431016735878 | (37.7618129556584, -122.431016735878) | 15 | 4 | 5 | 28862 | 3 | ||||
11682 | 89044 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 44 Surrey St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 51783 | 6002618 | 2096049 | 37.7354995892493 | -122.433390603486 | (37.7354995892493, -122.433390603486) | 2 | 7 | 5 | 63 | 7 | ||||
12071 | 81939 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1567 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50642 | 6006641.29456006 | 2117646.14573466 | 37.7950276999422 | -122.421013482861 | (37.7950276999422, -122.421013482861) | 13 | 9 | 10 | 28858 | 32 | ||
13059 | 58732 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2385 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/29/2005 12:00:00 AM | Permit Number 17967 | 6002968.76813263 | 2115478.70521399 | 37.7888687602145 | -122.433565986183 | (37.7888687602145, -122.433565986183) | 13 | 9 | 1 | 29490 | 27 | ||
13556 | 264663 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1078 Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/10/2020 12:00:00 AM | 3x3 | 6014476.86082 | 2089998.27904 | 37.7195511879651 | -122.391966726039 | (37.7195511879651, -122.391966726039) | 10 | 3 | 8 | 58 | 1 | |||
13606 | 264731 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1515 Van Dyke Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014824 | 2093132 | 37.7281750296252 | -122.390985688648 | (37.7281750296252, -122.390985688648) | 10 | 3 | 8 | 58 | 1 | ||||
14032 | 49886 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 59@ WILDWOOD Eastwood Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2003 12:00:00 AM | Permit Number 46658 | 5995617.4906106 | 2092991.57857678 | 37.726705001322 | -122.457372735726 | (37.726705001322, -122.457372735726) | 9 | 7 | 4 | 28861 | 40 | |||
14223 | 34240 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 9 Chattanooga St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/1997 12:00:00 AM | Permit Number 38051 | 6004714.42221556 | 2103615.95230322 | 37.7563954143949 | -122.426681158586 | (37.7563954143949, -122.426681158586) | 2 | 4 | 5 | 28862 | 22 | |||
14546 | 63665 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3975 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/02/1987 12:00:00 AM | Permit Number 24314 | 6004068.8441765 | 2100399.56050654 | 37.7475274359015 | -122.428684519984 | (37.7475274359015, -122.428684519984) | 2 | 4 | 5 | 63 | 22 | ||
14804 | 264658 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2845X Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2020 04:59:00 PM | 3X3 | 6014746.9934 | 2090564.9462 | 37.7211221378179 | -122.391072554716 | (37.7211221378179, -122.391072554716) | 10 | 3 | 8 | 58 | 1 | |||
15005 | 261438 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 384 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007303 | 2095696 | 37.7347950116026 | -122.417167741106 | (37.7347950116026, -122.417167741106) | 2 | 7 | 7 | 28859 | 2 | ||||
15242 | 49368 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 448 Campbell Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2003 12:00:00 AM | Permit Number 46341 | 6010694.36763099 | 2088383.30285889 | 37.7149060701976 | -122.404927851118 | (37.7149060701976, -122.404927851118) | 9 | 7 | 8 | 309 | 39 | |||
15862 | 99761 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 4212 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 4212-4216 25th St (4214 is visible address) | 6002485 | 2101232 | 37.7497233531083 | -122.434220849449 | (37.7497233531083, -122.434220849449) | 2 | 4 | 5 | 28862 | 22 | |||
16204 | 114507 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 10 LOMBARD ST | 2 | Back Yard : Cutout | Tree | Port 6 | 4x4 | 6011932 | 2120995 | 37.8045196580749 | -122.402942401468 | (37.8045196580749, -122.402942401468) | 3 | 1 | 10 | 28860 | 6 | ||||
16496 | 60642 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 101 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20270 | 6004901.36876785 | 2097539.55337894 | 37.7397215914528 | -122.425602180558 | (37.7397215914528, -122.425602180558) | 2 | 7 | 5 | 63 | 7 | ||
16573 | 33529 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 171 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37639 | 6007349.55714183 | 2098075.84761469 | 37.7413321670111 | -122.417175357737 | (37.7413321670111, -122.417175357737) | 2 | 7 | 7 | 28859 | 2 | |||
17139 | 261451 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 295 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006893 | 2095807 | 37.7350767190782 | -122.41859312449 | (37.7350767190782, -122.41859312449) | 2 | 7 | 7 | 28859 | 2 | ||||
17262 | 258984 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 220 Mullen Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 784344 | 6010137 | 2099925 | 37.7465659576292 | -122.407667663761 | (37.7465659576292, -122.407667663761) | 2 | 7 | 7 | 28859 | 2 | |||
17354 | 88467 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 119 Augusta St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51421 | 6011176 | 2095454 | 37.7343476550611 | -122.403760347511 | (37.7343476550611, -122.403760347511) | 10 | 3 | 8 | 58 | 1 | |||
18235 | 42453 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 550 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51619 | 5997786.60898589 | 2095288.02825485 | 37.7331348573333 | -122.45003964005 | (37.7331348573333, -122.45003964005) | 9 | 7 | 4 | 59 | 40 | ||
19440 | 262431 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 231 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/2019 12:00:00 AM | 3x3 | 6002625 | 2092333 | 37.7252966937933 | -122.433100982945 | (37.7252966937933, -122.433100982945) | 9 | 7 | 6 | 28861 | 5 | ||
19620 | 46201 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2001 12:00:00 AM | Permit Number 44518 | ||||||||||||||
19630 | 69390 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1124 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | Permit Number 33493 | 6001914.6702364 | 2087745.37882292 | 37.7126597908787 | -122.435228529911 | (37.7126597908787, -122.435228529911) | 9 | 7 | 6 | 28861 | 5 | ||
20763 | 59417 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 44 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/25/1988 12:00:00 AM | Permit Number 25158 | 6004255.489826 | 2098009.09356154 | 37.7409743251647 | -122.427868803942 | (37.7409743251647, -122.427868803942) | 2 | 7 | 5 | 63 | 7 | ||
21197 | 63882 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3533 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24589 | 6004803.22751205 | 2103657.20146126 | 37.7565136952268 | -122.426376975449 | (37.7565136952268, -122.426376975449) | 2 | 4 | 5 | 28862 | 22 | ||
22264 | 60143 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1610 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1982 12:00:00 AM | Permit Number 19673 | 5990907.91625844 | 2104426.54438296 | 37.7578308453136 | -122.474487560238 | (37.7578308453136, -122.474487560238) | 1 | 8 | 4 | 56 | 12 | ||
22366 | 108443 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 559 05th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 773772 | 5994363.45802 | 2111716.68858 | 37.7780472719646 | -122.463065881676 | (37.7780472719646, -122.463065881676) | 11 | 6 | 2 | 54 | 11 | |||
22517 | 41240 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 270 Masonic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1999 12:00:00 AM | Permit Number 41940 | 5999013.40299918 | 2112000.64122659 | 37.7790936893244 | -122.447000559943 | (37.7790936893244, -122.447000559943) | 15 | 5 | 1 | 54 | 16 | |||
22631 | 52058 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3165 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2005 12:00:00 AM | Permit Number 48256 | 6006783.78749917 | 2099933.06553583 | 37.746399825173 | -122.419263309296 | (37.746399825173, -122.419263309296) | 2 | 7 | 7 | 28859 | 2 | |||
23197 | 95639 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 252 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767405 | 6006489 | 2104635 | 37.7592936513862 | -122.420616372933 | (37.7592936513862, -122.420616372933) | 2 | 4 | 7 | 28859 | 19 | |
23281 | 43506 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 161 Newman St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2000 12:00:00 AM | Permit Number 43184 | 6007338.4828929 | 2096787.18196624 | 37.7377931534639 | -122.417122358052 | (37.7377931534639, -122.417122358052) | 2 | 7 | 7 | 28859 | 2 | |||
23362 | 93821 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
23539 | 61014 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 55 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/27/1983 12:00:00 AM | Permit Number 20830 | 6002575.62506459 | 2096039.73920056 | 37.7354717570522 | -122.433536447887 | (37.7354717570522, -122.433536447887) | 2 | 7 | 5 | 63 | 7 | ||
23859 | 55920 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2480 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2006 12:00:00 AM | 3x3 | Permit Number 50600 | 6006935.48968262 | 2103919.31295705 | 37.7573536936319 | -122.419021429077 | (37.7573536936319, -122.419021429077) | 2 | 4 | 7 | 28859 | 19 | ||
25132 | 63326 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 17 Bessie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/1987 12:00:00 AM | Permit Number 23899 | 6008102.76980253 | 2100057.0858479 | 37.746814552568 | -122.41471118136 | (37.746814552568, -122.41471118136) | 2 | 7 | 7 | 28859 | 2 | ||
25494 | 48801 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1082Street Pennsylvania Ave | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.392746446916 | (37.7527205135809, -122.392746446916) | 10 | 3 | 8 | 28856 | 29 | |||
25796 | 95782 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3619 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767526 | 6005487 | 2104873 | 37.7598906214089 | -122.424098704222 | (37.7598906214089, -122.424098704222) | 2 | 4 | 5 | 28859 | 19 | |
26224 | 111868 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3399x 16TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004303 | 2106535 | 37.7643871563547 | -122.428312038708 | (37.7643871563547, -122.428312038708) | 8 | 4 | 5 | 28862 | 3 | ||||
26265 | 120516 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 888 Brannan St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011018 | 2109170 | 37.7719999408521 | -122.405272169822 | (37.7719999408521, -122.405272169822) | 14 | 2 | 9 | 28853 | 34 | ||||
26378 | 96719 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1340 Clay St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008320 | 2116937 | 37.7931750456071 | -122.415154672616 | (37.7931750456071, -122.415154672616) | 5 | 1 | 10 | 28858 | 21 | |||||
26416 | 48800 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1082Street Pennsylvania Ave | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.392746446916 | (37.7527205135809, -122.392746446916) | 10 | 3 | 8 | 28856 | 29 | |||
26731 | 88124 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 266 Lexington St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2008 12:00:00 AM | 3x3 | Permit Number 51128 | 6006494 | 2104554 | 37.7590715260193 | -122.42059333056 | (37.7590715260193, -122.42059333056) | 2 | 4 | 7 | 28859 | 19 | |||
26993 | 34292 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2758 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/28/2003 12:00:00 AM | Permit Number 46984 | 6010209.51678065 | 2102837.66319596 | 37.7545675469901 | -122.407622236094 | (37.7545675469901, -122.407622236094) | 2 | 4 | 7 | 28859 | 19 | ||
27967 | 30728 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 45 Rose St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | Permit Number 34624 | 6006303.86733164 | 2109861.47838862 | 37.7736338888904 | -122.421627862373 | (37.7736338888904, -122.421627862373) | 7 | 9 | 11 | 28852 | 10 | ||
28368 | 255602 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 317 San Carlos St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006745 | 2104248 | 37.7582454635603 | -122.419703539884 | (37.7582454635603, -122.419703539884) | 2 | 4 | 7 | 28859 | 19 | ||||
28645 | 111869 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 3399x 16TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004303 | 2106535 | 37.7643871563547 | -122.428312038708 | (37.7643871563547, -122.428312038708) | 8 | 4 | 5 | 28862 | 3 | ||||
29084 | 95303 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 701 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2011 12:00:00 AM | 3x3 | Permit Number 767203 | 6006127.5 | 2112421.2 | 37.780652317617 | -122.422419858646 | (37.780652317617, -122.422419858646) | 7 | 9 | 11 | 28852 | 41 | ||
29106 | 47638 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 301 Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/2002 12:00:00 AM | Permit Number 45452 | 5998206.68830303 | 2112594.29479697 | 37.7806775849758 | -122.449834095773 | (37.7806775849758, -122.449834095773) | 15 | 6 | 2 | 54 | 16 | |||
29594 | 96720 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1340 Clay St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6008320 | 2116937 | 37.7931750456071 | -122.415154672616 | (37.7931750456071, -122.415154672616) | 5 | 1 | 10 | 28858 | 21 | |||||
30035 | 53150 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1499@ LANE Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/02/2006 12:00:00 AM | Permit Number 49076 | 6015286.17606683 | 2093519.24782482 | 37.7292639697355 | -122.389414946979 | (37.7292639697355, -122.389414946979) | 10 | 3 | 8 | 58 | 1 | |||
30163 | 96054 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1261 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767682 | 6009524 | 2101832 | 37.7517678233481 | -122.409921957152 | (37.7517678233481, -122.409921957152) | 2 | 4 | 7 | 28859 | 19 | |
30900 | 59896 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 906 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1981 12:00:00 AM | Permit Number 19363 | 6009911.82950519 | 2103913.88861057 | 37.7575059527221 | -122.408727642987 | (37.7575059527221, -122.408727642987) | 2 | 4 | 7 | 28859 | 19 | ||
30981 | 69392 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1139 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | Permit Number 33495 | 6001921.70531705 | 2087676.61824048 | 37.7124713889678 | -122.435199299374 | (37.7124713889678, -122.435199299374) | 9 | 7 | 6 | 28861 | 5 | ||
32099 | 41461 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 460 Ramsell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2000 12:00:00 AM | Permit Number 42046 | 5993018.50469486 | 2090233.49581681 | 37.7189823574514 | -122.466156931137 | (37.7189823574514, -122.466156931137) | 9 | 8 | 6 | 64 | 24 | |||
32777 | 68466 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 60 Badger St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/04/1993 12:00:00 AM | Permit Number 32328 | 6002354.04049623 | 2094409.88800929 | 37.7309839839817 | -122.434186069273 | (37.7309839839817, -122.434186069273) | 9 | 7 | 5 | 28861 | 25 | ||
34051 | 52167 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1614 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/2005 12:00:00 AM | Permit Number 48360 | 6009265.56204047 | 2099978.30779957 | 37.7466635086597 | -122.410684778697 | (37.7466635086597, -122.410684778697) | 2 | 7 | 7 | 28859 | 2 | ||
34547 | 93825 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
34803 | 47635 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 301 Anza St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/2002 12:00:00 AM | Permit Number 45452 | 5998206.68830303 | 2112594.29479697 | 37.7806775849758 | -122.449834095773 | (37.7806775849758, -122.449834095773) | 15 | 6 | 2 | 54 | 16 | |||
35054 | 69098 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1658 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33113 | 5992499.06205436 | 2104168.35309074 | 37.757213980438 | -122.468965974451 | (37.757213980438, -122.468965974451) | 1 | 8 | 4 | 56 | 12 | ||
35078 | 39115 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 501 Bartlett St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50596 | 6006834.26665835 | 2100862.7419909 | 37.7489553490953 | -122.419154691519 | (37.7489553490953, -122.419154691519) | 2 | 4 | 7 | 28859 | 19 | ||
35148 | 69289 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1900 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/09/1994 12:00:00 AM | Permit Number 33361 | 5990665.04614057 | 2102443.50433652 | 37.7523718663796 | -122.475182730707 | (37.7523718663796, -122.475182730707) | 1 | 8 | 4 | 29491 | 12 | ||
35311 | 63346 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 149 Mullen Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1987 12:00:00 AM | Permit Number 23920 | 6009928.22027252 | 2099880.94738001 | 37.746433309385 | -122.408386498152 | (37.746433309385, -122.408386498152) | 2 | 7 | 7 | 28859 | 2 | ||
35410 | 87680 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2998 Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2008 12:00:00 AM | 3x3 | Permit Number 50399 | 6006514.3 | 2121415.1 | 37.8053691339868 | -122.421720734847 | (37.8053691339868, -122.421720734847) | 5 | 1 | 1 | 28858 | 32 | ||
35420 | 93812 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 178 Bluxome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426 | (37.7744697656056, -122.40000821426) | 14 | 2 | 9 | 28856 | 20 | ||
35647 | 34349 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 406 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51609 | 6004013.55416632 | 2096149.85411864 | 37.7358555876111 | -122.428572831878 | (37.7358555876111, -122.428572831878) | 2 | 7 | 5 | 63 | 7 | ||
35936 | 63312 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 220 Mullen Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/29/1987 12:00:00 AM | Permit Number 23878 | 6010125.57376989 | 2099924.9230182 | 37.7465651066228 | -122.407707169195 | (37.7465651066228, -122.407707169195) | 2 | 7 | 7 | 28859 | 2 | ||
36675 | 59905 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 925 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1981 12:00:00 AM | Permit Number 19373 | 6009969.2907688 | 2103816.25695251 | 37.7572410963252 | -122.40852203114 | (37.7572410963252, -122.40852203114) | 2 | 4 | 7 | 28859 | 19 | ||
37445 | 118287 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 240 IVY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x2.5 | 6006177 | 2111293 | 37.7775573470216 | -122.422168438332 | (37.7775573470216, -122.422168438332) | 7 | 9 | 11 | 28852 | 10 | ||||
37483 | 85089 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Chestnut St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | 13 | 9 | 1 | 57 | 17 | |||||
38546 | 63256 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 317 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/1987 12:00:00 AM | 3x3 | Permit Number 23809 | 6006547.75913435 | 2104256.57264854 | 37.7582578891884 | -122.420386294584 | (37.7582578891884, -122.420386294584) | 2 | 4 | 7 | 28859 | 19 | |
38701 | 258325 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 115X Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997933 | 2087452 | 37.7116273264288 | -122.448969257639 | (37.7116273264288, -122.448969257639) | 9 | 7 | 6 | 28861 | 25 | ||||
39181 | 67145 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 9 Massasoit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1992 12:00:00 AM | Permit Number 775821 | 6010104.62054101 | 2099298.30623793 | 37.7448433809463 | -122.407735447457 | (37.7448433809463, -122.407735447457) | 2 | 7 | 7 | 28859 | 2 | ||
39596 | 47559 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 309 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45421 | 6004167.03194558 | 2101865.16274932 | 37.7515571949372 | -122.428449439906 | (37.7515571949372, -122.428449439906) | 2 | 4 | 5 | 28862 | 22 | ||
39932 | 49616 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1626 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/2003 12:00:00 AM | Permit Number 46477 | 6008114.57908688 | 2108709.83276472 | 37.7705736773564 | -122.415282774124 | (37.7705736773564, -122.415282774124) | 8 | 2 | 9 | 28853 | 19 | |||
40024 | 63520 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 821 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/08/1987 12:00:00 AM | Permit Number 24130 | 6009935.53523311 | 2104433.5559768 | 37.7589341701034 | -122.408682318494 | (37.7589341701034, -122.408682318494) | 2 | 4 | 7 | 28859 | 19 | ||
40067 | 56371 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 335 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50607 | 6006779.82308141 | 2101829.7996809 | 37.7516076031359 | -122.419411554389 | (37.7516076031359, -122.419411554389) | 2 | 4 | 7 | 28859 | 19 | ||
40583 | 96102 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 2780X 18th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/26/2011 12:00:00 AM | 3x3 | Permit Number 767752 | 6009596.8 | 2105493.6 | 37.7618258328219 | -122.40992865922 | (37.7618258328219, -122.40992865922) | 8 | 4 | 8 | 28859 | 19 | ||
40942 | 53148 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1499@ LANE Thomas Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/02/2006 12:00:00 AM | Permit Number 49076 | 6015286.17606683 | 2093519.24782482 | 37.7292639697355 | -122.389414946979 | (37.7292639697355, -122.389414946979) | 10 | 3 | 8 | 58 | 1 | |||
41167 | 87679 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2998 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/23/2008 12:00:00 AM | 3x3 | Permit Number 50399 | 6006514.3 | 2121415.1 | 37.8053691339868 | -122.421720734847 | (37.8053691339868, -122.421720734847) | 5 | 1 | 1 | 28858 | 32 | ||
41295 | 33436 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 131 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/1996 12:00:00 AM | Permit Number 37539 | 6006637.52258219 | 2098912.24250349 | 37.7435886367267 | -122.419696659188 | (37.7435886367267, -122.419696659188) | 2 | 7 | 7 | 28859 | 2 | |||
41317 | 96048 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1653 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767679 | 6009324 | 2099841 | 37.7462897680072 | -122.410473011409 | (37.7462897680072, -122.410473011409) | 2 | 7 | 7 | 28859 | 2 | |
42480 | 32818 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 4221 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37177 | 6001720.00837009 | 2102316.78849399 | 37.7526584745372 | -122.436943867037 | (37.7526584745372, -122.436943867037) | 2 | 4 | 5 | 28862 | 22 |
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) );