1,985 rows where qSpecies_id = 83 sorted by qCareAssistant

View and edit SQL

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)
281 136194 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2914 Fillmore St 6 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6002528.73575 2118269.03723 37.7965053162169 -122.435288106477 (37.7965053162169, -122.435288106477) 13 9 1 57 17
328 197129 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 400 Newhall St 11 : Tree Private 2     5 Width 3ft   6015974.4503 2097856.83037 37.7412122331485 -122.387337958305 (37.7412122331485, -122.387337958305) 10 3 8 58 1
381 136202 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1337 Francisco St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6004913.0684 2120534.02336 37.8028595013299 -122.427199210075 (37.8028595013299, -122.427199210075) 13 9 1 57 17
449 252970 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 101X Whipple Ave 2 Sidewalk: Curb side : Yard Tree Private 2   04/26/2019 12:00:00 AM 3                        
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
670 197144 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 67 Jennings Ct 7 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6012875.71849 2089235.92195 37.7173688854414 -122.397447893917 (37.7173688854414, -122.397447893917) 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
737 8938 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 4649X Geary Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   5992558.61151 2112698.79101 37.7806397269512 -122.469380940837 (37.7806397269512, -122.469380940837) 11 6 2 54 11
971 16508 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 325 Newhall St 10 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6016639.93914 2098306.03692 37.7424824967653 -122.385068203435 (37.7424824967653, -122.385068203435) 10 3 8 58 1
1044 139272 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 765 FULTON ST 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6004185.2644 2111476.3212 37.7779481591061 -122.429071593475 (37.7779481591061, -122.429071593475) 7 9 11 28852 10
1241 140612 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 880 Fillmore St 5 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6003492.8085 2111354.3072 37.777573917235 -122.431458329369 (37.777573917235, -122.431458329369) 7 9 11 29492 10
1294 136237 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1340 Clay St 6 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6008274 2116946 37.7931971721852 -122.415314473397 (37.7931971721852, -122.415314473397) 5 1 10 28858 21
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
1477 112866 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 750 VICENTE ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5990595 2097751 37.7394834085128 -122.475082436927 (37.7394834085128, -122.475082436927) 1 8 4 29491 40
1561 24107 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 105X Whitney Young Cir 14 Sidewalk: Curb side : Cutout Tree Private 2   03/11/2006 12:00:00 AM 3 3x3   6016397.2233978 2096041.081358 37.7362499588234 -122.385749620885 (37.7362499588234, -122.385749620885) 10 3 8 58 1
1699 5933 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1355 Eddy St 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/28/1990 12:00:00 AM 3 4X4   6004029.33456 2112693.29822 37.781280848415 -122.429697830179 (37.781280848415, -122.429697830179) 7 9 11 29490 41
1920 213973 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1061 Capitol Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   5995027.24606 2091045.40909 37.7213273674346 -122.459272306869 (37.7213273674346, -122.459272306869) 9 8 6 28861 24
1933 193325 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1398 Tennessee St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 5ft   6015584.15702 2102639.39931 37.7543225481714 -122.389021302106 (37.7543225481714, -122.389021302106) 10 3 8 28856 29
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
2453 49617 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1626 Folsom St 7 Sidewalk: Curb side : Cutout Tree Private 2   05/13/2003 12:00:00 AM     Permit Number 46477 6008114.57908688 2108709.83276472 37.7705736773564 -122.415282774124 (37.7705736773564, -122.415282774124) 8 2 9 28853 19
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
2621 202038 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 75 Crane St 2 : Tree Private 2     2 Width 3ft   6012275.87253 2090920.17769 37.7219600944649 -122.399639484201 (37.7219600944649, -122.399639484201) 10 3 8 58 1
2762 46200 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83   2 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2001 12:00:00 AM     Permit Number 44518                    
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
3450 52146 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 145 Hawes St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2005 12:00:00 AM     Permit Number 48337                    
3492 30592 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 269 Walter St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/26/1995 12:00:00 AM     Permit Number 34561                    
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
3973 138376 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1805 FILLMORE ST 2 Sidewalk: Curb side : Cutout Tree Private 2   02/04/2020 02:07:00 PM 3 Width 0ft   6002992.9152 2114550.4079 37.786321261782 -122.43341607774 (37.786321261782, -122.43341607774) 13 9 11 29490 27
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
4611 238852 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 299x Tompkins Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6007968.84006 2096563.6752 37.7372148941494 -122.414927086625 (37.7372148941494, -122.414927086625) 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
5043 238851 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 299x Tompkins Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6007952.96662 2096564.19788 37.7372154373458 -122.414982005523 (37.7372154373458, -122.414982005523) 2 7 7 28859 2
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
5604 197168 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2 Baldwin Ct 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6017908.19776 2093591.9406 37.729608594643 -122.380355342249 (37.729608594643, -122.380355342249) 10 3 8 58 1
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
5790 136106 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2362 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   6002236.43409 2117779.37436 37.7951442255914 -122.436264471651 (37.7951442255914, -122.436264471651) 13 9 1 57 17
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
5972 136242 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 1679 Washington St 4 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6006678.63942 2116999.88567 37.7932553363267 -122.420838360099 (37.7932553363267, -122.420838360099) 13 9 10 28858 32
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
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
6386 238848 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 199x Tompkins Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6007787.51207 2096580.63387 37.7372512681409 -122.415555222622 (37.7372512681409, -122.415555222622) 2 7 7 28859 2
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
7217 138378 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1805 FILLMORE ST 4 Sidewalk: Curb side : Cutout Tree Private 2   01/08/2020 10:23:00 AM 3 Width 0ft   6002996.8797 2114513.7365 37.7862207963337 -122.433399740113 (37.7862207963337, -122.433399740113) 13 9 11 29490 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
7988 24147 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 100X Whitney Young Cir 7 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6016689.05107 2095205.54183 37.7339718785836 -122.384682457242 (37.7339718785836, -122.384682457242) 10 3 8 58 1
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
8128 90393 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 98 12th St 2 Sidewalk: Curb side : Cutout Tree DPW 1   10/31/2016 12:00:00 AM 3 3x3   6007146.175112 2109626.370927 37.7730357998282 -122.418697508419 (37.7730357998282, -122.418697508419) 8 2 9 28853 19
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
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
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
9017 239285 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2750 18th St 5 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6009605.36999 2105497.87366 37.7618380476199 -122.409899320599 (37.7618380476199, -122.409899320599) 8 4 8 28859 19
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
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
9515 239254 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 3715 26th St 6 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6005705.30849 2100786.77225 37.748683110957 -122.423053239242 (37.748683110957, -122.423053239242) 2 4 5 28859 19
9559 90383 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 20 12th St 3 Sidewalk: Curb side : Cutout Tree DPW 1   02/21/2008 12:00:00 AM 3 3x3   6006777.292282 2110019.638696 37.7740948433326 -122.420001435971 (37.7740948433326, -122.420001435971) 8 2 9 28853 19
9907 30593 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 269 Walter St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/26/1995 12:00:00 AM     Permit Number 34561                    
10498 41462 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 454 Ramsell St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/31/2000 12:00:00 AM     Permit Number 42047 5993018.04440435 2090196.48136289 37.7188806981616 -122.466155833772 (37.7188806981616, -122.466155833772) 9 8 6 64 24
10522 31312 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 709 Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/12/1995 12:00:00 AM     Permit Number 34949 6004473.77987727 2110903.29372292 37.7763910940647 -122.428032671161 (37.7763910940647, -122.428032671161) 7 9 11 28852 10
10757 238849 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 199X Tompkins Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6007801.00794 2096580.35759 37.737251268132 -122.41550854151 (37.737251268132, -122.41550854151) 2 7 7 28859 2
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
10982 96718 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1340 Clay St 5 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2011 12:00:00 AM 8   Permit Number 767223 6008274 2116946 37.7931971721852 -122.415314473397 (37.7931971721852, -122.415314473397) 5 1 10 28858 21
10984 138446 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1820 POST ST 8 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6003295.7109 2114182.3135 37.7853277416205 -122.432342183898 (37.7853277416205, -122.432342183898) 13 9 11 29490 13
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
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
11540 102493 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2001 McAllister St 9 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   5999461.6709 2111166.2585 37.7768282889466 -122.445389813922 (37.7768282889466, -122.445389813922) 15 5 11 29492 16
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
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
11688 141943 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1101 GOLDEN GATE AVE 8 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6004162.7275 2112162.4936 37.77983094307 -122.429198496132 (37.77983094307, -122.429198496132) 7 9 11 29490 41
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
12061 239335 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 3206 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6008987.26449 2099969.0979 37.7466226130369 -122.411646456035 (37.7466226130369, -122.411646456035) 2 7 7 28859 2
12071 81939 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1567 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/04/2008 12:00:00 AM   3x3 Permit Number 50642 6006641.29456006 2117646.14573466 37.7950276999422 -122.421013482861 (37.7950276999422, -122.421013482861) 13 9 10 28858 32
12162 239887 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 190X Tompkins Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007798.48319 2096533.32571 37.7371219869923 -122.415513941937 (37.7371219869923, -122.415513941937) 2 7 7 28859 2
12316 124412 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 3900 Clay St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   5996120.28006 2115251.26489 37.7878533198568 -122.45724420279 (37.7878533198568, -122.45724420279) 11 6 1 54 31
12336 85628 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1470 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6015957.8963 2094137.5833 37.7309990152261 -122.387135841638 (37.7309990152261, -122.387135841638) 10 3 8 58 1
12876 138454 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1901 FILLMORE ST 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6002945.3416 2114886.8927 37.7872424644786 -122.433604726492 (37.7872424644786, -122.433604726492) 13 9 11 29490 27
13336 136240 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 1679 Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6006640.65595 2116994.76492 37.7932391350289 -122.420969421921 (37.7932391350289, -122.420969421921) 13 9 10 28858 32
13381 238854 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 299x Tompkins Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6007995.79542 2096561.34412 37.7372100081447 -122.414833724393 (37.7372100081447, -122.414833724393) 2 7 7 28859 2
13481 261122 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 56 Bay View St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/19/2019 12:00:00 AM 3 5x5   6014135.16378 2094796.13766 37.7327061665323 -122.393483454939 (37.7327061665323, -122.393483454939) 10 3 8 58 1
13494 83178 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 743 19th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2019 12:00:00 AM 3 3x3 Permit Number 51518 5990037.32656 2110290.06846 37.7738800155956 -122.477927036337 (37.7738800155956, -122.477927036337) 11 6 2 55 26
13512 259080 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1001 Visitacion Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/01/2019 12:00:00 AM 3                        
13556 264663 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1078 Hollister Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   09/10/2020 12:00:00 AM   3x3   6014476.86082 2089998.27904 37.7195511879651 -122.391966726039 (37.7195511879651, -122.391966726039) 10 3 8 58 1
13606 264731 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1515 Van Dyke Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014824 2093132 37.7281750296252 -122.390985688648 (37.7281750296252, -122.390985688648) 10 3 8 58 1
13618 143549 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2245 UNION ST 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6002240.1517 2118427.2493 37.7969233328664 -122.436297997013 (37.7969233328664, -122.436297997013) 13 9 1 57 17
14031 213996 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 146 Flood Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5999758.63525 2094089.70358 37.7299571835696 -122.443135805584 (37.7299571835696, -122.443135805584) 9 7 4 63 40
14032 49886 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 59@ WILDWOOD Eastwood Dr 3 Sidewalk: Curb side : Cutout Tree Private 2   07/01/2003 12:00:00 AM     Permit Number 46658 5995617.4906106 2092991.57857678 37.726705001322 -122.457372735726 (37.726705001322, -122.457372735726) 9 7 4 28861 40
14166 197170 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1510X Galvez Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6016200.17093 2097456.77974 37.740126273917 -122.386529601766 (37.740126273917, -122.386529601766) 10 3 8 58 1
14223 34240 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 9 Chattanooga St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/07/1997 12:00:00 AM     Permit Number 38051 6004714.42221556 2103615.95230322 37.7563954143949 -122.426681158586 (37.7563954143949, -122.426681158586) 2 4 5 28862 22
14662 248025 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 439 Franconia St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 2ft   6010001 2098476 37.7425797058833 -122.408035769643 (37.7425797058833, -122.408035769643) 10 7 7 28859 2

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