trees

1,985 rows where qSpecies_id = 83 sorted by DBH

✎ View and edit SQL

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)
42778 89298 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 850 Broderick St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/24/2008 12:00:00 AM   3x3 Permit Number 51901 6001012 2111585 37.7780664257709 -122.440056804822 (37.7780664257709, -122.440056804822) 15 5 11 29490 41
43433 120515 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 888 Brannan St 10 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011018 2109170 37.7719999408521 -122.405272169822 (37.7719999408521, -122.405272169822) 14 2 9 28853 34
43527 59900 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 938 York St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/21/1981 12:00:00 AM     Permit Number 19367 6009921.67857589 2103735.23260959 37.7570159551008 -122.408680977559 (37.7570159551008, -122.408680977559) 2 4 7 28859 19
43640 63782 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 3865 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/09/1987 12:00:00 AM     Permit Number 24466 6004731.1418531 2101313.40519991 37.7500741027298 -122.426459393397 (37.7500741027298, -122.426459393397) 2 4 5 28862 22
44032 58781 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 2064 Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/12/1995 12:00:00 AM     Permit Number 18024 6006472.52256241 2117868.87652577 37.7956297477373 -122.421613286998 (37.7956297477373, -122.421613286998) 13 9 10 28858 32
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
44358 255614 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 375X San Carlos St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006946 2103920 37.7573561719408 -122.4189851289 (37.7573561719408, -122.4189851289) 2 4 7 28859 19
44596 95625 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 3562 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/04/2011 12:00:00 AM   3x3 Permit Number 767392 6005880 2105517 37.7616810754377 -122.422785274783 (37.7616810754377, -122.422785274783) 8 4 5 28859 19
45282 63869 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 415 Hill St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/16/1987 12:00:00 AM     Permit Number 24572 6003633.93277578 2103298.63600494 37.7554629928496 -122.430395228856 (37.7554629928496, -122.430395228856) 2 4 5 28862 22
45332 63886 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 3547 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/16/1987 12:00:00 AM     Permit Number 24593 6004709.97412141 2103652.05428606 37.7564942904754 -122.426699112464 (37.7564942904754, -122.426699112464) 2 4 5 28862 22
45556 82630 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 160 Julian Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2009 12:00:00 AM   3x3 Permit Number 52216 6006410.24181442 2106937.54473832 37.7656114605169 -122.421052246328 (37.7656114605169, -122.421052246328) 8 4 7 28853 19
45599 48808 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1082Street Pennsylvania Ave 7 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
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
46495 85086 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 1600 Chestnut St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 49476 6004108.1 2120157.9 37.8017812094321 -122.429957968303 (37.8017812094321, -122.429957968303) 13 9 1 57 17
46778 61001 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 2725 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/27/1983 12:00:00 AM     Permit Number 20814 6002393.98738915 2096184.72110879 37.7358595366597 -122.434174798209 (37.7358595366597, -122.434174798209) 2 7 5 63 7
46792 95302 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 701 Golden Gate Ave 2 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
47406 62440 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 32 Danvers St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/07/1985 12:00:00 AM     Permit Number 22603 5999780.61180369 2105360.37553229 37.7609049960466 -122.443869272306 (37.7609049960466, -122.443869272306) 15 5 5 28862 3
47656 33440 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 197 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/20/1996 12:00:00 AM     Permit Number 37542 6006467.34357413 2098597.19964294 37.7427140119749 -122.420262742218 (37.7427140119749, -122.420262742218) 2 7 7 28859 2
47853 48805 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1082Street Pennsylvania Ave 10 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
48522 60841 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 333 Chattanooga St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/09/2008 12:00:00 AM   3x3 Permit Number 51272 6004812.33980893 2101832.66839606 37.7515044687506 -122.426215570202 (37.7515044687506, -122.426215570202) 2 4 5 28862 22
49301 84015 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 3448-3450 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2008 12:00:00 AM   3x3 Permit Number 50576 6006542.73215475 2105560.66804706 37.761838348091 -122.420496247464 (37.761838348091, -122.420496247464) 8 4 7 28859 19
49392 87678 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 2998 Larkin St 1 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
49393 43386 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 847 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/2000 12:00:00 AM     Permit Number 43133 6001928.68244613 2101630.19955263 37.7507851233957 -122.436173106924 (37.7507851233957, -122.436173106924) 2 4 5 28862 22
49398 68465 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 56 Badger St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/04/1993 12:00:00 AM     Permit Number 32327 6002348.42397311 2094432.09629198 37.7310446440886 -122.434207073572 (37.7310446440886, -122.434207073572) 9 7 5 28861 25
49521 88262 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1630 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM   3x3 Permit Number 51249 5998765 2109030 37.7709228760915 -122.447645980764 (37.7709228760915, -122.447645980764) 15 5 11 29492 9
49531 63529 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 650 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/10/1987 12:00:00 AM   3x3 Permit Number 24141 6007874.08689161 2104139.31003907 37.7580105644827 -122.415790957509 (37.7580105644827, -122.415790957509) 2 4 7 28859 19
50512 61239 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 3990 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/14/1984 12:00:00 AM     Permit Number 21111 6003756.36871106 2104234.67606304 37.7580400715305 -122.430038577553 (37.7580400715305, -122.430038577553) 2 4 5 28862 3
51806 63538 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 263 Lexington St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/10/1987 12:00:00 AM     Permit Number 24153 6006528.95547818 2104582.46189303 37.7591516457095 -122.420474457983 (37.7591516457095, -122.420474457983) 2 4 7 28859 19
51808 111862 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 201x LOBOS ST 4 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   5994528 2088713 37.7148944123502 -122.460829096166 (37.7148944123502, -122.460829096166) 9 8 6 28861 24
52287 93818 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 178 Bluxome St 7 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
52383 63307 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 3284 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/28/1987 12:00:00 AM     Permit Number 23873 6009001.83575964 2099561.12656766 37.7455032313147 -122.411567250412 (37.7455032313147, -122.411567250412) 2 7 7 28859 2
52413 34239 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 9 Chattanooga St 1 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
52899 173663 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 3878 17th St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   6003109 2105964 37.7627516946294 -122.432400964417 (37.7627516946294, -122.432400964417) 15 4 5 28862 3
53261 49614 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1626 Folsom St 4 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
53301 94914 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 3600 16th St 4 Sidewalk: Curb side : Cutout Tree Private 2   10/18/2010 12:00:00 AM   3x3 Permit Number 53781 6002902 2106490 37.7641842232844 -122.433154488347 (37.7641842232844, -122.433154488347) 15 4 5 28862 3
54328 37011 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1133 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/29/1998 12:00:00 AM     Permit Number 39625 6009493.89299858 2102575.04875629 37.7538063819439 -122.410078524122 (37.7538063819439, -122.410078524122) 2 4 7 28859 19
54634 48797 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1082Street Pennsylvania Ave 17 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
55493 33439 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 193 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/20/1996 12:00:00 AM     Permit Number 37541 6006477.65745838 2098616.29315883 37.7427670196422 -122.420228434519 (37.7427670196422, -122.420228434519) 2 7 7 28859 2
56241 59899 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 981 York St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/1993 12:00:00 AM     Permit Number 29266 6009986.52664303 2103503.60894166 37.7563836002421 -122.408440369707 (37.7563836002421, -122.408440369707) 2 4 7 28859 19
56408 48864 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 141 Wawona St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/2003 12:00:00 AM     Permit Number 46854 5992914.37939707 2098147.89875638 37.74070734298 -122.467091953195 (37.74070734298, -122.467091953195) 1 8 4 59 40
56538 87846 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 2480 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2008 12:00:00 AM   3x3 Permit Number 50600 6006948 2103912 37.757334318408 -122.418977644695 (37.757334318408, -122.418977644695) 2 4 7 28859 19
56992 63297 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 41 Bessie St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/29/1987 12:00:00 AM     Permit Number 23889 6008204.7241819 2100062.98400649 37.7468364754033 -122.414359049017 (37.7468364754033, -122.414359049017) 2 7 7 28859 2
57428 95614 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 35 Temescal Ter 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/10/2009 12:00:00 AM   3x3 Permit Number 52561 5997427.8 2111420 37.7774086833784 -122.45244386493 (37.7774086833784, -122.45244386493) 15 6 2 54 16
57745 63518 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 2720 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/08/1987 12:00:00 AM     Permit Number 24128 6010089.4904363 2104586.73017727 37.7593633735348 -122.408160669778 (37.7593633735348, -122.408160669778) 2 4 8 28859 19
58092 41239 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 270 Masonic Ave 3 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
58241 43924 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1100X HAMPSHIRE ST 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/10/2000 12:00:00 AM     Permit Number 43515 6010276 2102522 37.7537045273505 -122.407370066225 (37.7537045273505, -122.407370066225) 2 4 7 28859 19
58295 59898 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 956 York St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/21/1981 12:00:00 AM   9x6 Permit Number 19365. I marked for a basin expansion. 9'x 6'. SB 6009927.21867861 2103634.73860088 37.7567403313902 -122.408654728525 (37.7567403313902, -122.408654728525) 2 4 7 28859 19
58378 38663 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 840 Broderick St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/01/1998 12:00:00 AM   5x3 Permit Number 40585 6001023.37265886 2111553.49114647 37.7779805578681 -122.440015202914 (37.7779805578681, -122.440015202914) 15 5 11 29490 41
58661 96121 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 234 Bennington St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/08/2011 12:00:00 AM   3x3 Permit Number 767773 6007093 2096944 37.7382099281297 -122.417982227017 (37.7382099281297, -122.417982227017) 2 7 7 28859 2
59153 100410 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 201x Linden St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/16/2012 12:00:00 AM     Permit Number 767727 6006435 2110776 37.7761523386864 -122.421239206856 (37.7761523386864, -122.421239206856) 7 9 11 28852 10
59486 111906 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 1699x WASHINGTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006657 2116952 37.7931226344993 -122.420909832708 (37.7931226344993, -122.420909832708) 13 9 10 28858 32
60010 49885 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 59@ WILDWOOD Eastwood Dr 2 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
60043 111861 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 201x LOBOS ST 3 Sidewalk: Curb side : Cutout Tree SFUSD 4       3x3   5994528 2088713 37.7148944123502 -122.460829096166 (37.7148944123502, -122.460829096166) 9 8 6 28861 24
60779 60128 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 415 Chenery St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/03/1982 12:00:00 AM     Permit Number 19656 6003855.48725366 2096277.36434342 37.736196755139 -122.429128420374 (37.736196755139, -122.429128420374) 2 7 5 63 7
61570 67148 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 455 Gates St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/01/1992 12:00:00 AM     Permit Number 30579 6008250.85869537 2096720.89398869 37.7376624256589 -122.413963134562 (37.7376624256589, -122.413963134562) 2 7 7 28859 2
62118 41238 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 270 Masonic Ave 6 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
62119 67079 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 5 Fair Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/23/1992 12:00:00 AM     Permit Number 30476 6006639.64114826 2099650.94101578 37.7456170557754 -122.419741737079 (37.7456170557754, -122.419741737079) 2 7 7 28859 2
63014 63983 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 3931 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/06/1987 12:00:00 AM     Permit Number 24727 6004128.82081194 2104203.26376934 37.757974907555 -122.428748239953 (37.757974907555, -122.428748239953) 2 4 5 28862 3
63746 63298 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 3244 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/26/1987 12:00:00 AM     Permit Number 23864 6008988.97404286 2099790.91777784 37.7461334657396 -122.411627957335 (37.7461334657396, -122.411627957335) 2 7 7 28859 2
63799 52060 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 3165 Mission St 4 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
63861 93819 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 178 Bluxome St 8 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
64089 255613 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 375X San Carlos St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006946 2103920 37.7573561719408 -122.4189851289 (37.7573561719408, -122.4189851289) 2 4 7 28859 19
64569 69100 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1667 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/10/1994 12:00:00 AM     Permit Number 33115 5992448.84064151 2104114.43419147 37.757063031457 -122.469135733901 (37.757063031457, -122.469135733901) 1 8 4 56 12
64741 254232 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2600 Turk Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5998198 2111733 37.7783121964291 -122.449802064672 (37.7783121964291, -122.449802064672) 15 6 2 54 16
65262 93820 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 178 Bluxome St 9 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
66502 63294 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 28 Bessie St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/26/1987 12:00:00 AM   3x3 Permit Number 53019 6008133.84742681 2100006.79677587 37.7466782160561 -122.414600159459 (37.7466782160561, -122.414600159459) 2 7 7 28859 2
66911 92267 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 119 Madrone Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/24/2009 12:00:00 AM   3x3 Permit Number 52719 5992767 2098334 37.7412098217915 -122.467615061471 (37.7412098217915, -122.467615061471) 1 8 4 59 40
67121 96047 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1653 Alabama St 1 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
67397 63299 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 3250 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/26/1987 12:00:00 AM     Permit Number 23865 6008990.90330008 2099756.44910168 37.7460389305968 -122.411618851232 (37.7460389305968, -122.411618851232) 2 7 7 28859 2
67502 57721 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 231 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/19/2010 12:00:00 AM     Permit Number 53634 6004597.07146519 2109103.26366214 37.7714556250816 -122.427477905237 (37.7714556250816, -122.427477905237) 7 9 11 28852 10
67571 60613 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 106 Randall St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/12/1983 12:00:00 AM     Permit Number 20237 6004863.02785957 2097589.48802411 37.7398565341458 -122.425738300436 (37.7398565341458, -122.425738300436) 2 7 5 63 7
67889 59918 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 942 York St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/24/1981 12:00:00 AM     Permit Number 19387 6009922.90971034 2103712.90059838 37.7569547053635 -122.408675144421 (37.7569547053635, -122.408675144421) 2 4 7 28859 19
68224 49615 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1626 Folsom St 5 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
68298 256028 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1376 Shafter Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   6016144 2093317 37.7287561605437 -122.386435251043 (37.7287561605437, -122.386435251043) 10 3 8 58 1
68591 93828 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 178 Bluxome St 17 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
68863 48795 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1082Street Pennsylvania Ave 15 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
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
69265 62441 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 26 Danvers St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/07/1985 12:00:00 AM     Permit Number 22604 5999768.9190223 2105384.80396899 37.7609714035152 -122.443911467539 (37.7609714035152, -122.443911467539) 15 5 5 28862 3
69977 55733 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 2252 15TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2   03/05/1973 12:00:00 AM     Permit Number 11759 6002543 2107122 37.7658991699711 -122.434441354631 (37.7658991699711, -122.434441354631) 15 5 5 28862 3
70431 96064 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 2 Prospect Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/03/2011 12:00:00 AM   3x3 Permit Number 767689 6007344.9 2099669.6 37.7457079931938 -122.417304374627 (37.7457079931938, -122.417304374627) 2 7 7 28859 2
70828 88492 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1600 Quesada Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM   3x3 Permit Number 51434 6015245.7 2094684.2 37.7324604500235 -122.389636207884 (37.7324604500235, -122.389636207884) 10 3 8 58 1
70972 52908 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 295 Gaven St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/27/2006 12:00:00 AM   3x3 Permit Number 48898 6009070.24444642 2094849.33610342 37.7325695169323 -122.41099796146 (37.7325695169323, -122.41099796146) 10 3 7 309 28
71112 48862 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 135 Wawona St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/2003 12:00:00 AM     Permit Number 46853 5992938.7152954 2098174.1666423 37.7407808726579 -122.467009718867 (37.7407808726579, -122.467009718867) 1 8 4 59 40
72535 41236 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 270 Masonic Ave 1 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
72781 93822 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 178 Bluxome St 11 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
74283 88489 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1600 Quesada Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM   3x3 Permit Number 51434 6015245.7 2094684.2 37.7324604500235 -122.389636207884 (37.7324604500235, -122.389636207884) 10 3 8 58 1
75929 88490 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1600 Quesada Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM   3x3 Permit Number 51434 6015245.7 2094684.2 37.7324604500235 -122.389636207884 (37.7324604500235, -122.389636207884) 10 3 8 58 1
76635 95398 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1436 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/24/2011 12:00:00 AM   3x3 Permit Number 767272 6003848 2099901 37.7461460032944 -122.429412637248 (37.7461460032944, -122.429412637248) 2 7 5 63 22
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
77054 67883 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1626 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 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
77314 60150 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1767 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/28/1982 12:00:00 AM     Permit Number 19681 5990891.54356846 2103381.184277 37.754959614042 -122.474467896907 (37.754959614042, -122.474467896907) 1 8 4 56 12
78059 31405 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 4249 20th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/01/1995 12:00:00 AM     Permit Number 34995 6002250.83987816 2104099.74238816 37.7575841957248 -122.435235679993 (37.7575841957248, -122.435235679993) 2 4 5 28862 3
78354 68119 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 20 Tiffany Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/20/1993 12:00:00 AM     Permit Number 31865 6006388.61214572 2099880.1544955 37.7462322797077 -122.420626027293 (37.7462322797077, -122.420626027293) 2 7 5 28859 2
78587 65258 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1121 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/18/1994 12:00:00 AM     Permit Number 28057 6009490.15544197 2102642.26317624 37.753990728209 -122.410096194404 (37.753990728209, -122.410096194404) 2 4 7 28859 19
78648 96161 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 6 Milton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/08/2011 12:00:00 AM   3x3 Permit Number 767793 6003680 2095311.9 37.7335358734479 -122.429666314328 (37.7335358734479, -122.429666314328) 2 7 5 28861 25
78758 50131 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 131 Wawona St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/2003 12:00:00 AM     Permit Number 46852 5992954.93923014 2098191.67856897 37.7408298924183 -122.466954895883 (37.7408298924183, -122.466954895883) 1 8 4 59 40
78790 67035 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 4212 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/09/1996 12:00:00 AM     Permit Number 30409 4212-4216 25th ST 6002474.90568284 2101241.03339883 37.7497475837507 -122.434256401684 (37.7497475837507, -122.434256401684) 2 4 5 28862 22
79293 67093 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 437 Gates St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/23/1992 12:00:00 AM     Permit Number 30495 6008258.04848699 2096798.93207666 37.7378771049848 -122.413943794807 (37.7378771049848, -122.413943794807) 2 7 7 28859 2
79362 120872 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 16 Ford St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003333 2105685 37.7619983269925 -122.431606308434 (37.7619983269925, -122.431606308434) 15 4 5 28862 3
79508 48798 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1082Street Pennsylvania Ave 20 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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);