Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3419 | 3419 | 252969 | Private 5 | Pyrus kawakamii :: Evergreen Pear 82 | 101 Whipple Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5998180.94106 | 2087280.50358 | 37.711170613109104 | -122.448099970249 | (37.7111706131091, -122.448099970249) | |||||
| 3825 | 3825 | 253557 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 1398 Tennessee St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 5ft | 6015583.67362 | 2102658.4010900003 | 37.7543746962452 | -122.38902430045499 | (37.7543746962452, -122.389024300455) | ||||
| 5893 | 5893 | 46201 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 6305 | 6305 | 52146 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 145 Hawes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2005 12:00:00 AM | Permit Number 48337 | ||||||||
| 6751 | 6751 | 137889 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2034 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6002935.6901 | 2115351.8703 | 37.7885186270288 | -122.433671363006 | (37.7885186270288, -122.433671363006) | ||||
| 9250 | 9250 | 46200 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/2001 12:00:00 AM | Permit Number 44518 | |||||||||
| 9726 | 9726 | 173663 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 3878 17th St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6003109.0 | 2105964.0 | 37.7627516946294 | -122.432400964417 | (37.7627516946294, -122.432400964417) | ||||
| 11507 | 11507 | 30593 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 269 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1995 12:00:00 AM | Permit Number 34561 | ||||||||
| 13405 | 13405 | 30592 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 269 Walter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1995 12:00:00 AM | Permit Number 34561 | ||||||||
| 18016 | 18016 | 49368 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 448 Campbell Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2003 12:00:00 AM | Permit Number 46341 | 6010694.36763099 | 2088383.30285889 | 37.7149060701976 | -122.40492785111799 | (37.7149060701976, -122.404927851118) | |||
| 18483 | 18483 | 66408 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 632 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/1991 12:00:00 AM | Permit Number 29535 | 6007948.77791486 | 2095967.06920677 | 37.7355756171998 | -122.414954236685 | (37.7355756171998, -122.414954236685) | ||
| 19275 | 19275 | 34240 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 9 Chattanooga St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/1997 12:00:00 AM | Permit Number 38051 | 6004714.42221556 | 2103615.95230322 | 37.7563954143949 | -122.426681158586 | (37.7563954143949, -122.426681158586) | |||
| 19622 | 19622 | 63665 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3975 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/02/1987 12:00:00 AM | Permit Number 24314 | 6004068.8441765 | 2100399.56050654 | 37.747527435901496 | -122.428684519984 | (37.7475274359015, -122.428684519984) | ||
| 19725 | 19725 | 114507 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 10 LOMBARD ST | 2 | Back Yard : Cutout 16 | Tree 1 | Port 9 | 4x4 | 6011932.0 | 2120995.0 | 37.8045196580749 | -122.402942401468 | (37.8045196580749, -122.402942401468) | ||||
| 20299 | 20299 | 63295 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 29 Bessie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1987 12:00:00 AM | Permit Number 23861 | 6008153.74699222 | 2100060.03492719 | 37.746825514117205 | -122.41453511521401 | (37.7468255141172, -122.414535115214) | ||
| 20863 | 20863 | 112866 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 750 VICENTE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990595.0 | 2097751.0 | 37.7394834085128 | -122.475082436927 | (37.7394834085128, -122.475082436927) | ||||
| 24671 | 24671 | 58732 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2385 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2005 12:00:00 AM | Permit Number 17967 | 6002968.76813263 | 2115478.70521399 | 37.7888687602145 | -122.433565986183 | (37.7888687602145, -122.433565986183) | ||
| 28416 | 28416 | 99761 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 4212 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 4212-4216 25th St (4214 is visible address) | 6002485.0 | 2101232.0 | 37.749723353108294 | -122.434220849449 | (37.7497233531083, -122.434220849449) | |||
| 41805 | 41805 | 81939 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1567 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50642 | 6006641.29456006 | 2117646.14573466 | 37.7950276999422 | -122.421013482861 | (37.7950276999422, -122.421013482861) | ||
| 42748 | 42748 | 89044 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 44 Surrey St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51783 | 6002618.0 | 2096049.0 | 37.735499589249294 | -122.433390603486 | (37.7354995892493, -122.433390603486) | ||||
| 45610 | 45610 | 42453 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 550 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51619 | 5997786.60898589 | 2095288.02825485 | 37.7331348573333 | -122.45003964005 | (37.7331348573333, -122.45003964005) | ||
| 47443 | 47443 | 96053 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 130 Coso Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767681 | 6007306.3 | 2099659.0 | 37.745676716208 | -122.417437096994 | (37.745676716208, -122.417437096994) | |
| 48558 | 48558 | 31312 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 709 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/1995 12:00:00 AM | Permit Number 34949 | 6004473.77987727 | 2110903.29372292 | 37.77639109406471 | -122.428032671161 | (37.7763910940647, -122.428032671161) | |||
| 49629 | 49629 | 88476 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1531 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51429 | 6015551.7 | 2096433.9 | 37.7372817351758 | -122.38870038321801 | (37.7372817351758, -122.388700383218) | ||
| 50173 | 50173 | 49617 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1626 Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2003 12:00:00 AM | Permit Number 46477 | 6008114.57908688 | 2108709.83276472 | 37.7705736773564 | -122.415282774124 | (37.7705736773564, -122.415282774124) | |||
| 51549 | 51549 | 61556 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2098X 23RD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | Permit Number 21516 | 6012360.0 | 2102825.0 | 37.754652920054795 | -122.40018435916299 | (37.7546529200548, -122.400184359163) | ||
| 63414 | 63414 | 49886 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 59@ WILDWOOD Eastwood Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2003 12:00:00 AM | Permit Number 46658 | 5995617.4906105995 | 2092991.57857678 | 37.726705001321996 | -122.457372735726 | (37.726705001322, -122.457372735726) | |||
| 66013 | 66013 | 36339 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 59 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/01/2003 12:00:00 AM | Permit Number 46658 | 5995617.4906105995 | 2092991.57857678 | 37.726705001321996 | -122.457372735726 | (37.726705001322, -122.457372735726) | ||
| 71194 | 71194 | 60642 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 101 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1983 12:00:00 AM | Permit Number 20270 | 6004901.36876785 | 2097539.55337894 | 37.7397215914528 | -122.425602180558 | (37.7397215914528, -122.425602180558) | ||
| 77592 | 77592 | 120516 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 888 Brannan St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011018.0 | 2109170.0 | 37.771999940852105 | -122.40527216982201 | (37.7719999408521, -122.405272169822) | ||||
| 77757 | 77757 | 118287 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 240 IVY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2.5 | 6006177.0 | 2111293.0 | 37.777557347021606 | -122.42216843833201 | (37.7775573470216, -122.422168438332) | ||||
| 78062 | 78062 | 47635 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 301 Anza St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/2002 12:00:00 AM | Permit Number 45452 | 5998206.68830303 | 2112594.29479697 | 37.7806775849758 | -122.44983409577299 | (37.7806775849758, -122.449834095773) | |||
| 78128 | 78128 | 61014 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 55 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/1983 12:00:00 AM | Permit Number 20830 | 6002575.62506459 | 2096039.73920056 | 37.7354717570522 | -122.43353644788701 | (37.7354717570522, -122.433536447887) | ||
| 78261 | 78261 | 63886 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3547 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | Permit Number 24593 | 6004709.97412141 | 2103652.05428606 | 37.756494290475395 | -122.42669911246401 | (37.7564942904754, -122.426699112464) | ||
| 78280 | 78280 | 33439 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 193 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | Permit Number 37541 | 6006477.65745838 | 2098616.29315883 | 37.74276701964221 | -122.420228434519 | (37.7427670196422, -122.420228434519) | |||
| 78545 | 78545 | 61239 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3990 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/1984 12:00:00 AM | Permit Number 21111 | 6003756.36871106 | 2104234.67606304 | 37.7580400715305 | -122.430038577553 | (37.7580400715305, -122.430038577553) | ||
| 78598 | 78598 | 69390 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1124 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | Permit Number 33493 | 6001914.6702364 | 2087745.37882292 | 37.7126597908787 | -122.435228529911 | (37.7126597908787, -122.435228529911) | ||
| 78764 | 78764 | 111862 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 201x LOBOS ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x3 | 5994528.0 | 2088713.0 | 37.714894412350205 | -122.460829096166 | (37.7148944123502, -122.460829096166) | ||||
| 78783 | 78783 | 47559 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 309 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | Permit Number 45421 | 6004167.03194558 | 2101865.16274932 | 37.751557194937206 | -122.428449439906 | (37.7515571949372, -122.428449439906) | ||
| 78938 | 78938 | 59900 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 938 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1981 12:00:00 AM | Permit Number 19367 | 6009921.67857589 | 2103735.23260959 | 37.7570159551008 | -122.408680977559 | (37.7570159551008, -122.408680977559) | ||
| 78955 | 78955 | 82630 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 160 Julian Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52216 | 6006410.24181442 | 2106937.54473832 | 37.765611460516894 | -122.42105224632799 | (37.7656114605169, -122.421052246328) | ||
| 79160 | 79160 | 49616 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1626 Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2003 12:00:00 AM | Permit Number 46477 | 6008114.57908688 | 2108709.83276472 | 37.7705736773564 | -122.415282774124 | (37.7705736773564, -122.415282774124) | |||
| 79184 | 79184 | 93818 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 178 Bluxome St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426001 | (37.7744697656056, -122.40000821426) | ||
| 79247 | 79247 | 87679 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2998 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2008 12:00:00 AM | 3x3 | Permit Number 50399 | 6006514.3 | 2121415.1 | 37.805369133986794 | -122.42172073484699 | (37.8053691339868, -122.421720734847) | ||
| 79289 | 79289 | 95302 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 701 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2011 12:00:00 AM | 3x3 | Permit Number 767203 | 6006127.5 | 2112421.2 | 37.780652317617005 | -122.422419858646 | (37.780652317617, -122.422419858646) | ||
| 79383 | 79383 | 43386 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 847 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | Permit Number 43133 | 6001928.68244613 | 2101630.19955263 | 37.75078512339571 | -122.436173106924 | (37.7507851233957, -122.436173106924) | ||
| 79427 | 79427 | 84015 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3448-3450 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50576 | 6006542.73215475 | 2105560.66804706 | 37.761838348091004 | -122.420496247464 | (37.761838348091, -122.420496247464) | ||
| 79486 | 79486 | 48797 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.39274644691601 | (37.7527205135809, -122.392746446916) | |||
| 79618 | 79618 | 86844 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 316 Alemany Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2007 12:00:00 AM | 3x3 | Permit Number 49783 | 6008748.0 | 2095475.9 | 37.7342718507077 | -122.412156308798 | (37.7342718507077, -122.412156308798) | |||
| 79651 | 79651 | 96102 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 2780X 18th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/2011 12:00:00 AM | 3x3 | Permit Number 767752 | 6009596.8 | 2105493.6 | 37.7618258328219 | -122.40992865921999 | (37.7618258328219, -122.40992865922) | ||
| 79749 | 79749 | 48808 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.39274644691601 | (37.7527205135809, -122.392746446916) | |||
| 79805 | 79805 | 63307 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3284 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1987 12:00:00 AM | Permit Number 23873 | 6009001.83575964 | 2099561.12656766 | 37.7455032313147 | -122.411567250412 | (37.7455032313147, -122.411567250412) | ||
| 80101 | 80101 | 63538 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 263 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/10/1987 12:00:00 AM | Permit Number 24153 | 6006528.95547818 | 2104582.46189303 | 37.7591516457095 | -122.420474457983 | (37.7591516457095, -122.420474457983) | ||
| 80418 | 80418 | 87678 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2998 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2008 12:00:00 AM | 3x3 | Permit Number 50399 | 6006514.3 | 2121415.1 | 37.805369133986794 | -122.42172073484699 | (37.8053691339868, -122.421720734847) | ||
| 80482 | 80482 | 48805 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1082Street Pennsylvania Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/2002 12:00:00 AM | Permit Number 46042 | 6014495.63347758 | 2102077.94418173 | 37.7527205135809 | -122.39274644691601 | (37.7527205135809, -122.392746446916) | |||
| 80568 | 80568 | 68465 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 56 Badger St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/04/1993 12:00:00 AM | Permit Number 32327 | 6002348.42397311 | 2094432.09629198 | 37.731044644088605 | -122.43420707357201 | (37.7310446440886, -122.434207073572) | ||
| 80618 | 80618 | 63782 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3865 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/09/1987 12:00:00 AM | Permit Number 24466 | 6004731.1418531 | 2101313.40519991 | 37.7500741027298 | -122.42645939339701 | (37.7500741027298, -122.426459393397) | ||
| 80674 | 80674 | 56371 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 335 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50607 | 6006779.82308141 | 2101829.7996809 | 37.7516076031359 | -122.419411554389 | (37.7516076031359, -122.419411554389) | ||
| 80705 | 80705 | 62440 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 32 Danvers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1985 12:00:00 AM | Permit Number 22603 | 5999780.61180369 | 2105360.37553229 | 37.7609049960466 | -122.443869272306 | (37.7609049960466, -122.443869272306) | ||
| 80787 | 80787 | 94914 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3600 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2010 12:00:00 AM | 3x3 | Permit Number 53781 | 6002902.0 | 2106490.0 | 37.764184223284396 | -122.433154488347 | (37.7641842232844, -122.433154488347) | ||
| 80946 | 80946 | 88494 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2617 Quint St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51436 | 6011452.0 | 2093927.0 | 37.7301702475564 | -122.402698769845 | (37.7301702475564, -122.402698769845) | |||
| 80993 | 80993 | 85086 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49476 | 6004108.1 | 2120157.9 | 37.8017812094321 | -122.429957968303 | (37.8017812094321, -122.429957968303) | ||||
| 81029 | 81029 | 63256 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 317 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/1987 12:00:00 AM | 3x3 | Permit Number 23809 | 6006547.75913435 | 2104256.57264854 | 37.7582578891884 | -122.420386294584 | (37.7582578891884, -122.420386294584) | |
| 81623 | 81623 | 33440 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 197 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/20/1996 12:00:00 AM | Permit Number 37542 | 6006467.34357413 | 2098597.19964294 | 37.7427140119749 | -122.420262742218 | (37.7427140119749, -122.420262742218) | ||
| 81749 | 81749 | 33436 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 131 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | Permit Number 37539 | 6006637.52258219 | 2098912.24250349 | 37.743588636726706 | -122.419696659188 | (37.7435886367267, -122.419696659188) | |||
| 81875 | 81875 | 89298 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 850 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/2008 12:00:00 AM | 3x3 | Permit Number 51901 | 6001012.0 | 2111585.0 | 37.778066425770895 | -122.440056804822 | (37.7780664257709, -122.440056804822) | ||
| 81885 | 81885 | 61001 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2725 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/1983 12:00:00 AM | Permit Number 20814 | 6002393.98738915 | 2096184.72110879 | 37.7358595366597 | -122.434174798209 | (37.7358595366597, -122.434174798209) | ||
| 81949 | 81949 | 59899 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 981 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1993 12:00:00 AM | Permit Number 29266 | 6009986.52664303 | 2103503.60894166 | 37.7563836002421 | -122.408440369707 | (37.7563836002421, -122.408440369707) | ||
| 82224 | 82224 | 67145 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 9 Massasoit St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1992 12:00:00 AM | Permit Number 775821 | 6010104.62054101 | 2099298.30623793 | 37.7448433809463 | -122.40773544745701 | (37.7448433809463, -122.407735447457) | ||
| 82307 | 82307 | 63520 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 821 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/08/1987 12:00:00 AM | Permit Number 24130 | 6009935.53523311 | 2104433.5559768 | 37.758934170103394 | -122.408682318494 | (37.7589341701034, -122.408682318494) | ||
| 82719 | 82719 | 95625 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3562 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2011 12:00:00 AM | 3x3 | Permit Number 767392 | 6005880.0 | 2105517.0 | 37.7616810754377 | -122.422785274783 | (37.7616810754377, -122.422785274783) | |
| 82753 | 82753 | 96048 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1653 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767679 | 6009324.0 | 2099841.0 | 37.7462897680072 | -122.410473011409 | (37.7462897680072, -122.410473011409) | |
| 82900 | 82900 | 37011 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1133 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | Permit Number 39625 | 6009493.89299858 | 2102575.04875629 | 37.753806381943896 | -122.41007852412201 | (37.7538063819439, -122.410078524122) | ||
| 83257 | 83257 | 87846 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2480 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50600 | 6006948.0 | 2103912.0 | 37.757334318408 | -122.41897764469499 | (37.757334318408, -122.418977644695) | ||
| 83425 | 83425 | 63297 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 41 Bessie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/1987 12:00:00 AM | Permit Number 23889 | 6008204.7241819 | 2100062.98400649 | 37.74683647540329 | -122.414359049017 | (37.7468364754033, -122.414359049017) | ||
| 83502 | 83502 | 48864 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 141 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2003 12:00:00 AM | Permit Number 46854 | 5992914.37939707 | 2098147.89875638 | 37.740707342979995 | -122.467091953195 | (37.74070734298, -122.467091953195) | ||
| 83567 | 83567 | 63869 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 415 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | Permit Number 24572 | 6003633.93277578 | 2103298.63600494 | 37.7554629928496 | -122.43039522885599 | (37.7554629928496, -122.430395228856) | ||
| 83625 | 83625 | 58781 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2064 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/12/1995 12:00:00 AM | Permit Number 18024 | 6006472.52256241 | 2117868.87652577 | 37.7956297477373 | -122.42161328699801 | (37.7956297477373, -122.421613286998) | ||
| 83756 | 83756 | 120515 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 888 Brannan St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011018.0 | 2109170.0 | 37.771999940852105 | -122.40527216982201 | (37.7719999408521, -122.405272169822) | ||||
| 83802 | 83802 | 88262 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1630 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51249 | 5998765.0 | 2109030.0 | 37.7709228760915 | -122.44764598076401 | (37.7709228760915, -122.447645980764) | ||
| 84009 | 84009 | 32818 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 4221 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37177 | 6001720.00837009 | 2102316.78849399 | 37.7526584745372 | -122.43694386703699 | (37.7526584745372, -122.436943867037) | ||
| 84194 | 84194 | 49614 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1626 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2003 12:00:00 AM | Permit Number 46477 | 6008114.57908688 | 2108709.83276472 | 37.7705736773564 | -122.415282774124 | (37.7705736773564, -122.415282774124) | |||
| 84247 | 84247 | 34239 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 9 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/1997 12:00:00 AM | Permit Number 38051 | 6004714.42221556 | 2103615.95230322 | 37.7563954143949 | -122.426681158586 | (37.7563954143949, -122.426681158586) | |||
| 84350 | 84350 | 63529 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 650 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/10/1987 12:00:00 AM | 3x3 | Permit Number 24141 | 6007874.08689161 | 2104139.31003907 | 37.7580105644827 | -122.415790957509 | (37.7580105644827, -122.415790957509) | |
| 84475 | 84475 | 60841 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 333 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51272 | 6004812.33980893 | 2101832.66839606 | 37.7515044687506 | -122.426215570202 | (37.7515044687506, -122.426215570202) | ||
| 84861 | 84861 | 53148 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1499@ LANE Thomas Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/2006 12:00:00 AM | Permit Number 49076 | 6015286.17606683 | 2093519.24782482 | 37.7292639697355 | -122.389414946979 | (37.7292639697355, -122.389414946979) | |||
| 84924 | 84924 | 88489 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Quesada Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51434 | 6015245.7 | 2094684.2 | 37.732460450023495 | -122.38963620788401 | (37.7324604500235, -122.389636207884) | ||
| 84970 | 84970 | 93820 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 178 Bluxome St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2010 12:00:00 AM | 3x3 | Permit Number 53343 | 6012557.4 | 2110038.2 | 37.7744697656056 | -122.40000821426001 | (37.7744697656056, -122.40000821426) | ||
| 85034 | 85034 | 63518 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2720 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/08/1987 12:00:00 AM | Permit Number 24128 | 6010089.4904363 | 2104586.73017727 | 37.759363373534796 | -122.408160669778 | (37.7593633735348, -122.408160669778) | ||
| 85171 | 85171 | 60613 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 106 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1983 12:00:00 AM | Permit Number 20237 | 6004863.02785957 | 2097589.48802411 | 37.7398565341458 | -122.425738300436 | (37.7398565341458, -122.425738300436) | ||
| 85628 | 85628 | 49615 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1626 Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2003 12:00:00 AM | Permit Number 46477 | 6008114.57908688 | 2108709.83276472 | 37.7705736773564 | -122.415282774124 | (37.7705736773564, -122.415282774124) | |||
| 85689 | 85689 | 41239 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 270 Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1999 12:00:00 AM | Permit Number 41940 | 5999013.40299918 | 2112000.64122659 | 37.7790936893244 | -122.447000559943 | (37.7790936893244, -122.447000559943) | |||
| 85789 | 85789 | 96047 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1653 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767679 | 6009324.0 | 2099841.0 | 37.7462897680072 | -122.410473011409 | (37.7462897680072, -122.410473011409) | |
| 85981 | 85981 | 86840 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 320 Alemany Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/16/2007 12:00:00 AM | 3x3 | Permit Number 49780 | 6008706.2 | 2095448.4 | 37.734193996145 | -122.41229888228001 | (37.734193996145, -122.41229888228) | |||
| 85984 | 85984 | 57721 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 231 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2010 12:00:00 AM | Permit Number 53634 | 6004597.07146519 | 2109103.26366214 | 37.7714556250816 | -122.42747790523701 | (37.7714556250816, -122.427477905237) | ||
| 86258 | 86258 | 60128 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 415 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/1982 12:00:00 AM | Permit Number 19656 | 6003855.48725366 | 2096277.36434342 | 37.736196755139 | -122.429128420374 | (37.736196755139, -122.429128420374) | ||
| 86345 | 86345 | 63294 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 28 Bessie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1987 12:00:00 AM | 3x3 | Permit Number 53019 | 6008133.84742681 | 2100006.79677587 | 37.746678216056104 | -122.414600159459 | (37.7466782160561, -122.414600159459) | ||
| 86446 | 86446 | 52060 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 3165 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2005 12:00:00 AM | Permit Number 48256 | 6006783.78749917 | 2099933.06553583 | 37.746399825173 | -122.419263309296 | (37.746399825173, -122.419263309296) | |||
| 86519 | 86519 | 55733 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 2252 15TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/05/1973 12:00:00 AM | Permit Number 11759 | 6002543.0 | 2107122.0 | 37.76589916997111 | -122.434441354631 | (37.7658991699711, -122.434441354631) | |||
| 86534 | 86534 | 41236 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 270 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/1999 12:00:00 AM | Permit Number 41940 | 5999013.40299918 | 2112000.64122659 | 37.7790936893244 | -122.447000559943 | (37.7790936893244, -122.447000559943) |
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");