trees
1,985 rows where qSpecies_id = 83 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3470 | 260424 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 751 Goettingen St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/17/2019 12:00:00 AM | 3 | 6010808.85842 | 2091198.73798 | 37.7226430782423 | -122.404730210147 | (37.7226430782423, -122.404730210147) | 10 | 3 | 7 | 309 | 28 | |||
11017 | 88581 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 515 21st Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51523 | 5989364.70117 | 2111797.63767 | 37.777980320812 | -122.480364100125 | (37.777980320812, -122.480364100125) | 11 | 6 | 2 | 55 | 26 | ||
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 | ||||
14084 | 258134 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 131 Woolsey St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6011357.19142 | 2092082.52958 | 37.7251004206417 | -122.402896861649 | (37.7251004206417, -122.402896861649) | 10 | 3 | 7 | 309 | 28 | |||
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 | |||
20196 | 88552 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 649 15th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51497 | 5991271.54152 | 2111000.35442 | 37.7759018234336 | -122.473709552083 | (37.7759018234336, -122.473709552083) | 11 | 6 | 2 | 54 | 26 | ||
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 | |||
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 | |||
32162 | 107809 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 174 14TH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773719 | 6007550.6 | 2107982.4 | 37.7685446055333 | -122.417182034417 | (37.7685446055333, -122.417182034417) | 8 | 4 | 7 | 28853 | 19 | ||
44076 | 88494 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2617 Quint St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51436 | 6011452 | 2093927 | 37.7301702475564 | -122.402698769845 | (37.7301702475564, -122.402698769845) | 10 | 3 | 8 | 58 | 1 | |||
46493 | 86844 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 316 Alemany Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2007 12:00:00 AM | 3x3 | Permit Number 49783 | 6008748 | 2095475.9 | 37.7342718507077 | -122.412156308798 | (37.7342718507077, -122.412156308798) | 10 | 7 | 7 | 28859 | 2 | |||
69082 | 86840 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 320 Alemany Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2007 12:00:00 AM | 3x3 | Permit Number 49780 | 6008706.2 | 2095448.4 | 37.734193996145 | -122.41229888228 | (37.734193996145, -122.41229888228) | 10 | 7 | 7 | 28859 | 2 | |||
76789 | 86846 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 316 Alemany Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2007 12:00:00 AM | 3x3 | Permit Number 49783 | 6008748 | 2095475.9 | 37.7342718507077 | -122.412156308798 | (37.7342718507077, -122.412156308798) | 10 | 7 | 7 | 28859 | 2 | |||
80870 | 88423 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1451 Taylor St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51387 | 6008861 | 2117824 | 37.7956409180501 | -122.413345528397 | (37.7956409180501, -122.413345528397) | 5 | 1 | 10 | 308 | 21 | |||
87443 | 88469 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 921 Ingerson Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51423 | 6014544.1 | 2089500.7 | 37.7181886666833 | -122.391699531232 | (37.7181886666833, -122.391699531232) | 10 | 3 | 8 | 58 | 1 | |||
90153 | 86841 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 322 Alemany Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2007 12:00:00 AM | 3x3 | Permit Number 49781 | 6008668.1 | 2095458.9 | 37.734220688835 | -122.412431348478 | (37.734220688835, -122.412431348478) | 10 | 7 | 7 | 28859 | 2 | |||
97617 | 88247 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 4348 17th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51233 | 6000427 | 2105801 | 37.7621516914162 | -122.441665328495 | (37.7621516914162, -122.441665328495) | 15 | 5 | 5 | 28862 | 3 | |||
115856 | 86842 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 326 Alemany Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2007 12:00:00 AM | 3x3 | Permit Number 49782 | 6008646.4 | 2095435 | 37.7341538468062 | -122.412504683689 | (37.7341538468062, -122.412504683689) | 10 | 7 | 7 | 28859 | 2 | |||
117804 | 254499 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1715 Octavia St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 769839 | 6004851.87126 | 2115244.61878 | 37.7883326812086 | -122.427034026756 | (37.7883326812086, -122.427034026756) | 13 | 9 | 11 | 28858 | 27 | |
129559 | 98274 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 766 Anderson St | Front Yard : Yard | Tree | Private 2 | 01/23/2012 12:00:00 AM | 18 | Permit Number 768445 | 6007723 | 2095324 | 37.7337971999422 | -122.415689321062 | (37.7337971999422, -122.415689321062) | 2 | 7 | 7 | 28859 | 2 | |||
129624 | 88251 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 4903 17th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51237 | 5997791.1 | 2105582.1 | 37.7614001117653 | -122.450766072013 | (37.7614001117653, -122.450766072013) | 15 | 5 | 11 | 29492 | 12 | |||
131724 | 86843 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 316 Alemany Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2007 12:00:00 AM | 3x3 | Permit Number 49783 | 6008748 | 2095475.9 | 37.7342718507077 | -122.412156308798 | (37.7342718507077, -122.412156308798) | 10 | 7 | 7 | 28859 | 2 | |||
132157 | 88422 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1451 Taylor St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51387 | 6008861 | 2117824 | 37.7956409180501 | -122.413345528397 | (37.7956409180501, -122.413345528397) | 5 | 1 | 10 | 308 | 21 | |||
135509 | 86845 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 316 Alemany Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2007 12:00:00 AM | 3x3 | Permit Number 49783 | 6008748 | 2095475.9 | 37.7342718507077 | -122.412156308798 | (37.7342718507077, -122.412156308798) | 10 | 7 | 7 | 28859 | 2 | |||
136183 | 95301 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 701 Golden Gate Ave | 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 | |||
142797 | 115805 | Planning Code 138.1 required 2 | Pyrus kawakamii :: Evergreen Pear 83 | 872 Kansas St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | 3x3 | 6011546.4 | 2104246.9 | 37.7585117443173 | -122.403098033012 | (37.7585117443173, -122.403098033012) | 10 | 3 | 8 | 28856 | 29 | |||
149159 | 86713 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 938 Garfield St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/24/2007 12:00:00 AM | Permit Number 49699 | 5991527 | 2090568.7 | 37.7198165808065 | -122.471336842251 | (37.7198165808065, -122.471336842251) | 9 | 8 | 6 | 64 | 24 | ||||
176900 | 88478 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1514 McKinnon Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51430 | 6015856.3 | 2095628.5 | 37.7350871465747 | -122.387591057509 | (37.7350871465747, -122.387591057509) | 10 | 3 | 8 | 58 | 1 | |||
183528 | 91610 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1068 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/19/2016 08:13:00 AM | 3 | 3x3 | 6007601.453035 | 2103438.871938 | 37.7560719916571 | -122.416684224173 | (37.7560719916571, -122.416684224173) | 2 | 4 | 7 | 28859 | 19 | |||
611 | 10613 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 34 Hawkins Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/1993 12:00:00 AM | 18 | 3X3 | 6016953.5018076 | 2095595.9312574 | 37.7350584319022 | -122.383795333225 | (37.7350584319022, -122.383795333225) | 10 | 3 | 8 | 58 | 1 | ||
691 | 199940 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1177 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6017562.0246 | 2092865.5482 | 37.7275949559017 | -122.381501616556 | (37.7275949559017, -122.381501616556) | 10 | 3 | 8 | 58 | 1 | |||
1245 | 213791 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 209 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 768064 | 5995620.63174 | 2091343.81767 | 37.7221808240739 | -122.45724272857 | (37.7221808240739, -122.45724272857) | 9 | 8 | 4 | 28861 | 24 |
1330 | 239316 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1100 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6010239.40016 | 2102763.26328 | 37.7543649341213 | -122.407513645861 | (37.7543649341213, -122.407513645861) | 2 | 4 | 7 | 28859 | 19 | |||
1601 | 39981 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 45 Bay View St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/27/1999 12:00:00 AM | 6 | Permit Number 41239 | 6014242.19126 | 2094737.80253 | 37.7325519363025 | -122.39310935122 | (37.7325519363025, -122.39310935122) | 10 | 3 | 8 | 58 | 1 | |
1758 | 73714 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2110 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6012133.53509 | 2102840.64813 | 37.7546832563417 | -122.400968639917 | (37.7546832563417, -122.400968639917) | 10 | 3 | 8 | 28856 | 29 | |||
2151 | 258135 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 988 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6010589.4479 | 2112082.95565 | 37.7799742710855 | -122.40695991983 | (37.7799742710855, -122.40695991983) | 14 | 2 | 9 | 28853 | 34 | |||
2159 | 23089 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1360 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/03/1992 12:00:00 AM | 3 | 3X3 | 6006386.45124 | 2101639.17827 | 37.751062036612 | -122.420758355385 | (37.751062036612, -122.420758355385) | 2 | 4 | 5 | 28859 | 19 | ||
2378 | 239239 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 101 Scott St | 1 | : | Tree | Private 2 | 20 | Width 6ft | 6002329.06188 | 2108869.34471 | 37.7706848027038 | -122.435306320439 | (37.7706848027038, -122.435306320439) | 15 | 5 | 11 | 29492 | 9 | |||
2522 | 239885 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 190x Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007768.4049 | 2096536.44279 | 37.7371288550961 | -122.415618157155 | (37.7371288550961, -122.415618157155) | 2 | 7 | 7 | 28859 | 2 | |||
2567 | 239301 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1277 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6010336.55809 | 2101801.57143 | 37.7517297793105 | -122.407109863745 | (37.7517297793105, -122.407109863745) | 10 | 4 | 7 | 28859 | 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 | |||
3017 | 136252 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 802 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006854.74284 | 2121556.78092 | 37.8057773454026 | -122.420552649091 | (37.8057773454026, -122.420552649091) | 5 | 1 | 1 | 28858 | 32 | |||
3095 | 28342 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3115 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/10/2004 12:00:00 AM | 3 | 3X3 | 6007068 | 2100404 | 37.7477089074097 | -122.418313917469 | (37.7477089074097, -122.418313917469) | 2 | 7 | 7 | 28859 | 2 | ||
3341 | 71320 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 326 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6004289.26563 | 2090538.00218 | 37.7204622897839 | -122.427219973626 | (37.7204622897839, -122.427219973626) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||||||||||||
3730 | 120250 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 164 24th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 5988365.5517 | 2114845.05893 | 37.7862895663335 | -122.484043998391 | (37.7862895663335, -122.484043998391) | 11 | 6 | 1 | 55 | 33 | |||
3781 | 46872 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2006 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | 6 | Permit Number 44935 | 6006916.93752 | 2118140.46696 | 37.7964005164122 | -122.420094813224 | (37.7964005164122, -122.420094813224) | 5 | 9 | 10 | 28858 | 32 | |
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 | ||
3969 | 73442 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 314 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6004223.02083 | 2091452.87155 | 37.7229705736272 | -122.427514104094 | (37.7229705736272, -122.427514104094) | 9 | 7 | 6 | 28861 | 5 | |||
4044 | 11466 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 39X Hawkins Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/1992 12:00:00 AM | 3 | 3X3 | 6016784.96757 | 2095560.66167 | 37.7349522709331 | -122.384375566285 | (37.7349522709331, -122.384375566285) | 10 | 3 | 8 | 58 | 1 | ||
4284 | 244079 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1600 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5998854.6041 | 2109046.905 | 37.7709744135065 | -122.447337256007 | (37.7709744135065, -122.447337256007) | 15 | 5 | 11 | 29492 | 9 | |||
4499 | 238850 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 199X Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6007815.26144 | 2096578.28635 | 37.7372463821225 | -122.415459113874 | (37.7372463821225, -122.415459113874) | 2 | 7 | 7 | 28859 | 2 | |||
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 | ||
4783 | 239336 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3206 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008986.81884 | 2099989.09053 | 37.7466774833742 | -122.411649409412 | (37.7466774833742, -122.411649409412) | 2 | 7 | 7 | 28859 | 2 | |||
4805 | 74096 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1133 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6001902.78384 | 2087667.72771 | 37.7124459030227 | -122.435264062185 | (37.7124459030227, -122.435264062185) | 9 | 7 | 6 | 28861 | 5 | |||
5177 | 179302 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 200 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003690.09434 | 2092638.18195 | 37.7261950154772 | -122.429440808968 | (37.7261950154772, -122.429440808968) | 9 | 7 | 6 | 28861 | 5 | |||
5553 | 70621 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 713 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6004140.66992 | 2091658.50291 | 37.7235305337986 | -122.427813419165 | (37.7235305337986, -122.427813419165) | 9 | 7 | 6 | 28861 | 5 | |||
5677 | 123020 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 152 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5993993.9147 | 2114546.78107 | 37.78579664693 | -122.464549802121 | (37.78579664693, -122.464549802121) | 11 | 6 | 1 | 54 | 11 | |||
5861 | 141599 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 30 ASHBURY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5998723.6664 | 2110574.4541 | 37.7751611896291 | -122.447900165728 | (37.7751611896291, -122.447900165728) | 15 | 5 | 11 | 29492 | 16 | |||
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 | ||||
6129 | 85658 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1643 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015004.908 | 2094769.8823 | 37.7326823614983 | -122.3904746745 | (37.7326823614983, -122.3904746745) | 10 | 3 | 8 | 58 | 1 | ||
6142 | 73715 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2012 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6012416.66148 | 2102853.00124 | 37.7547329645749 | -122.399990373555 | (37.7547329645749, -122.399990373555) | 10 | 3 | 8 | 28856 | 29 | |||
6199 | 244531 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1504 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5998919.2255 | 2108717.3892 | 37.7700733392593 | -122.44709001202 | (37.7700733392593, -122.44709001202) | 15 | 5 | 11 | 29492 | 9 | |||
6265 | 239278 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 248 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006484.02549 | 2104654.1559 | 37.7593459686731 | -122.420634937075 | (37.7593459686731, -122.420634937075) | 2 | 4 | 7 | 28859 | 19 | |||
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 | ||
6488 | 239304 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 821 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009936.73456 | 2104250.32887 | 37.7584311369078 | -122.408665244799 | (37.7584311369078, -122.408665244799) | 2 | 4 | 7 | 28859 | 19 | |||
7088 | 70592 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 312 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6004234.1327 | 2091472.60684 | 37.7230253908821 | -122.4274770979 | (37.7230253908821, -122.4274770979) | 9 | 7 | 6 | 28861 | 5 | |||
7485 | 61793 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2104 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/24/1985 12:00:00 AM | 14 | Permit Number 21816 | 6012153.01638 | 2102841.49501 | 37.7546866683749 | -122.400901327432 | (37.7546866683749, -122.400901327432) | 10 | 3 | 8 | 28856 | 29 | |
7523 | 254506 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1928 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/22/2018 12:00:00 AM | 3 | 3x3 | 6004702.10653 | 2115410.06007 | 37.7887784716518 | -122.427563979846 | (37.7887784716518, -122.427563979846) | 13 | 9 | 11 | 28858 | 27 | |
7527 | 136248 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2023 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008588.60584 | 2119742.27726 | 37.8008927343603 | -122.414423864695 | (37.8008927343603, -122.414423864695) | 5 | 1 | 10 | 308 | 32 | |||
7715 | 260428 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 745 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/17/2019 12:00:00 AM | 3 | ||||||||||||
7723 | 69741 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 93 Delta St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6010157.17597 | 2089735.57492 | 37.7185890892048 | -122.406879871126 | (37.7185890892048, -122.406879871126) | 10 | 7 | 8 | 309 | 39 | |||
7946 | 74150 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 740 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6004499.396 | 2111088.6935 | 37.7769016055642 | -122.427957272174 | (37.7769016055642, -122.427957272174) | 7 | 9 | 11 | 28852 | 10 | |||
8064 | 240144 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1207 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5998176.37667 | 2106172.12741 | 37.7630422254456 | -122.449476081756 | (37.7630422254456, -122.449476081756) | 15 | 5 | 11 | 29492 | 9 | |||
8202 | 46512 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2188 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/27/2002 12:00:00 AM | 8 | Permit Number 44678 | 6002606.94356 | 2118178.75715 | 37.7962618715428 | -122.435011030753 | (37.7962618715428, -122.435011030753) | 13 | 9 | 1 | 57 | 17 | |
8259 | 138334 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1971 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6002917.5822 | 2115096.7114 | 37.7878169981836 | -122.433715769701 | (37.7878169981836, -122.433715769701) | 13 | 9 | 11 | 29490 | 27 | |||
8293 | 69460 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 446 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/16/1994 12:00:00 AM | 3 | Permit Number 33570 | 5985026.61463 | 2112867.05169 | 37.7806635770894 | -122.495449750327 | (37.7806635770894, -122.495449750327) | 11 | 6 | 2 | 55 | 26 | |
8502 | 73401 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1733 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6006559.8799 | 2116866.9427 | 37.7928836135597 | -122.421239831973 | (37.7928836135597, -122.421239831973) | 13 | 9 | 10 | 28858 | 32 | |||
8584 | 21731 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 1963 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/1997 12:00:00 AM | 3 | 3X3 | 6003249.5114044 | 2114468.5359796 | 37.7861110165037 | -122.432522471352 | (37.7861110165037, -122.432522471352) | 13 | 9 | 11 | 29490 | 13 | ||
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 | ||
8876 | 136239 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1679 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006621.33402 | 2116991.57937 | 37.7932292991375 | -122.4210360509 | (37.7932292991375, -122.4210360509) | 13 | 9 | 10 | 28858 | 32 | |||
9038 | 239314 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2720 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6010004.35252 | 2104577.87538 | 37.7593342927654 | -122.40845449498 | (37.7593342927654, -122.40845449498) | 2 | 4 | 8 | 28859 | 19 | |||
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 | ||
9223 | 60407 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1430 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/27/1982 12:00:00 AM | 6 | Permit Number 19988 | 6016156.6712 | 2093985.1354 | 37.7305914290757 | -122.386438011678 | (37.7305914290757, -122.386438011678) | 10 | 3 | 8 | 58 | 1 | |
9288 | 85617 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1274 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017015.0778 | 2093348.1164 | 37.7288897808137 | -122.383426014631 | (37.7288897808137, -122.383426014631) | 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 | |||||||||||||
9959 | 71411 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1556 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6015495.2506 | 2094478.7004 | 37.7319100238031 | -122.388759104128 | (37.7319100238031, -122.388759104128) | 10 | 3 | 8 | 58 | 1 | |||
10024 | 35136 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 714 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | 13 | Permit Number 38666 | 6002360.3768 | 2089504.48193 | 37.7175152006551 | -122.43381368236 | (37.7175152006551, -122.43381368236) | 9 | 7 | 6 | 28861 | 5 | |
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 | |||
10805 | 38591 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1615 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 3 | Permit Number 40546 | 6015135.7246 | 2094671.1157 | 37.7324184244611 | -122.390015508372 | (37.7324184244611, -122.390015508372) | 10 | 3 | 8 | 58 | 1 | |
10812 | 58694 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 3633 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/1979 12:00:00 AM | 4 | Permit Number 17970 | 5996855.26576 | 2115960.61486 | 37.7898431897625 | -122.454752572401 | (37.7898431897625, -122.454752572401) | 11 | 6 | 1 | 54 | 31 | ||
10955 | 116918 | Undocumented 4 | Pyrus kawakamii :: Evergreen Pear 83 | 1390x TENNESSEE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 5x5 | 6015390 | 2102613 | 37.7542392969383 | -122.389690908339 | (37.7542392969383, -122.389690908339) | 10 | 3 | 8 | 28856 | 29 | ||
11012 | 7356 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 2309 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/01/2007 12:00:00 AM | 4 | 3X3 | 6002769.01195 | 2116184.22684 | 37.7907946063198 | -122.434307574482 | (37.7907946063198, -122.434307574482) | 13 | 9 | 1 | 29490 | 27 | ||
11605 | 213995 | Permitted Site 7 | Pyrus kawakamii :: Evergreen Pear 83 | 146 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/1993 12:00:00 AM | 6 | Width 3ft | Permit Number 32783 | 5999776.55649 | 2094090.41195 | 37.729960150431 | -122.443073900754 | (37.729960150431, -122.443073900754) | 9 | 7 | 4 | 63 | 40 | |
11654 | 259082 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1023 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | 6009473.49904 | 2087244.25049 | 37.7117101453965 | -122.409067379874 | (37.7117101453965, -122.409067379874) | 9 | 7 | 8 | 309 | 39 | |||
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 | ||||
11751 | 142826 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1731 POLK ST | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 0ft | 6006566.9559 | 2116825.8136 | 37.7927710822258 | -122.421212426745 | (37.7927710822258, -122.421212426745) | 13 | 9 | 10 | 28858 | 32 | |||
11829 | 259084 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1041 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | 6009428.83146 | 2087260.92835 | 37.7117534370142 | -122.409222939968 | (37.7117534370142, -122.409222939968) | 9 | 7 | 8 | 309 | 39 | |||
12053 | 72144 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 58 Meda Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6000049.527 | 2091859.62504 | 37.7238504846937 | -122.441970156497 | (37.7238504846937, -122.441970156497) | 9 | 7 | 6 | 28861 | 25 |
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) );