Street_Tree_List

Data source: data.sfgov.org

180 rows where qSpecies = 190 sorted by TreeID

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, DBH, PlotSize

Link rowid TreeID ▼ qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
79512 804 DPW Maintained 3 Eriobotrya japonica :: Edible Loquat 190 680X 39th Ave 2 Median : Cutout 11 Tree 1 DPW 2     3 6-HOA   5983823.94935 2111143.69789 37.7758612538886 -122.499482885033 (37.7758612538886, -122.499482885033)
17577 5550 Permitted Site 1 Eriobotrya japonica :: Edible Loquat 190 951 Dolores St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/27/1998 12:00:00 AM 18 6   6005117.32575 2102805.17707 37.7541919854752 -122.425230085106 (37.7541919854752, -122.425230085106)
21420 7445 Permitted Site 1 Eriobotrya japonica :: Edible Loquat 190 2548 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     30 3X3   6008209.4393 2103591.6656299997 37.7565257046152 -122.41459240931201 (37.7565257046152, -122.414592409312)
15545 17442 Permitted Site 1 Eriobotrya japonica :: Edible Loquat 190 1944 Palou Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 3x3   6013068.40824 2096637.6125599998 37.73770314508 -122.39730060745501 (37.73770314508, -122.397300607455)
14534 18564 DPW Maintained 3 Eriobotrya japonica :: Edible Loquat 190 1700X Quesada Ave 19 Median : Cutout 11 Tree 1 DPW 2     30 19   6014511.59225 2095170.6430400002 37.7337553901961 -122.392208220649 (37.7337553901961, -122.392208220649)
17045 19792 DPW Maintained 3 Eriobotrya japonica :: Edible Loquat 190 100 STAIRWAY19 14 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 20ST            
16686 19817 DPW Maintained 3 Eriobotrya japonica :: Edible Loquat 190 100 STAIRWAY25 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 100ST            
7267 19835 DPW Maintained 3 Eriobotrya japonica :: Edible Loquat 190 100 STAIRWAY25 19 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 60X            
8172 19836 DPW Maintained 3 Eriobotrya japonica :: Edible Loquat 190 100 STAIRWAY25 20 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 60X            
15209 19838 DPW Maintained 3 Eriobotrya japonica :: Edible Loquat 190 100 STAIRWAY25 22 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 60X            
6018 19926 DPW Maintained 3 Eriobotrya japonica :: Edible Loquat 190 100 STAIRWAY37 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 20ST            
11287 20003 DPW Maintained 3 Eriobotrya japonica :: Edible Loquat 190 100 STAIRWAY46 23 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 2            
16066 22498 Permitted Site 1 Eriobotrya japonica :: Edible Loquat 190 6404 03rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/20/2003 12:00:00 AM 3 3X3   6013069.4059 2090221.21293 37.720085079934705 -122.39684744087799 (37.7200850799347, -122.396847440878)
41072 32329 Permitted Site 1 Eriobotrya japonica :: Edible Loquat 190 1884 08th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/02/1996 12:00:00 AM 5   Permit Number 36893 5993786.54543 2102682.50055 37.7532085147622 -122.46440551389601 (37.7532085147622, -122.464405513896)
70263 48553 Permitted Site 1 Eriobotrya japonica :: Edible Loquat 190 378 18th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/22/2002 12:00:00 AM 3   Permit Number 45869 5990302.44703 2112853.20794 37.780933073312504 -122.477197298017 (37.7809330733125, -122.477197298017)
133319 54637 Permitted Site 1 Eriobotrya japonica :: Edible Loquat 190 1747 Quint St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/27/1972 12:00:00 AM 1   Permit Number 10460 6012648.74415 2095666.1739599998 37.7350124040996 -122.39868344459299 (37.7350124040996, -122.398683444593)
138223 57922 Permitted Site 1 Eriobotrya japonica :: Edible Loquat 190 539 Brunswick St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/24/1977 12:00:00 AM 5   Permit Number 16880 5999313.15008 2086900.5185900002 37.7101919177852 -122.444159502961 (37.7101919177852, -122.444159502961)
75891 61497 Permitted Site 1 Eriobotrya japonica :: Edible Loquat 190 137 20th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/20/1984 12:00:00 AM 9   Permit Number 21447 5989576.46395 2114470.4752700003 37.7853314889271 -122.479827181582 (37.7853314889271, -122.479827181582)
74925 61499 Permitted Site 1 Eriobotrya japonica :: Edible Loquat 190 154 20th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/27/1984 12:00:00 AM 7   Permit Number 21452 5989629.6033 2114330.31946 37.7849497475064 -122.47963307901001 (37.7849497475064, -122.47963307901)
186390 62603 Permitted Site 1 Eriobotrya japonica :: Edible Loquat 190 792 37th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/22/1986 12:00:00 AM 6   Permit Number 22911 5984491.42084 2110500.08946 37.7741332293959 -122.497126446837 (37.7741332293959, -122.497126446837)
177598 65002 Permitted Site 1 Eriobotrya japonica :: Edible Loquat 190 1628 Visitacion Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/31/1989 12:00:00 AM 7   Permit Number 26041 6007789.57951 2087924.3929599999 37.713483198176796 -122.414935588817 (37.7134831981768, -122.414935588817)
179174 71359 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1620 La Salle Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/21/1988 12:00:00 AM 7     6015449.34332 2096256.73769 37.7367896101585 -122.389041914574 (37.7367896101585, -122.389041914574)
54742 72881 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 130 Alpha St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/21/1998 12:00:00 AM 8     6010899.06821 2088108.5640200002 37.714163133309896 -122.40420099129601 (37.7141631333099, -122.404200991296)
165090 73562 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1620 La Salle Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/21/1988 12:00:00 AM 8     6015449.230359999 2096256.56638 37.7367891335144 -122.389042293172 (37.7367891335144, -122.389042293172)
41649 73939 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1450 Santiago St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/22/1995 12:00:00 AM 2     5988330.9539 2099688.5183 37.744671848150894 -122.483052396761 (37.7446718481509, -122.483052396761)
150484 88782 Permitted Site 1 Eriobotrya japonica :: Edible Loquat 190 166 Havelock St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/02/2008 12:00:00 AM 9 3x3 Permit Number 51699 5999327.1574099995 2092949.02389 37.7268005308142 -122.444545520761 (37.7268005308142, -122.444545520761)
94834 99679 DPW Maintained 3 Eriobotrya japonica :: Edible Loquat 190 165 Grattan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   10 3x3   5997880.8 2106478.8 37.7638673579207 -122.45052048585899 (37.7638673579207, -122.450520485859)
78574 109626 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 117 JUDSON AVE   Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x12   5999286.5 2093444.4 37.728158398345705 -122.44472166307101 (37.7281583983457, -122.444721663071)
141580 109627 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 500 CIRCULAR AVE 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   5999334.0 2093430.0 37.728121569817 -122.444556419888 (37.728121569817, -122.444556419888)
2713 109887 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1024 Pacific Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10     6009193.94635 2118049.36414 37.796278400188704 -122.412209406439 (37.7962784001887, -122.412209406439)
153997 111169 Permitted Site 1 Eriobotrya japonica :: Edible Loquat 190 1469 Pacific Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 3x3   6007081.20428 2117722.0309900003 37.795260849674705 -122.41949671281701 (37.7952608496747, -122.419496712817)
143567 111509 DPW Maintained 3 Eriobotrya japonica :: Edible Loquat 190 800x BOSWORTH ST 4 Front Yard : Yard 7 Tree 1 DPW 2     4     6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
27406 111563 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1498x Kansas St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 3x3   6011720.06091 2101415.9054400004 37.750748151322604 -122.40229838558001 (37.7507481513226, -122.40229838558)
141988 113120 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1x TOMASO CT 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1           6009323.0 2086334.0 37.70920235104 -122.40952334552 (37.70920235104, -122.40952334552)
84522 113121 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1x TOMASO CT 9 Sidewalk: Property side : Yard 9 Tree 1 Private 1           6009323.0 2086334.0 37.70920235104 -122.40952334552 (37.70920235104, -122.40952334552)
80361 115303 Permitted Site 1 Eriobotrya japonica :: Edible Loquat 190 916 Ortega St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/25/2016 12:00:00 AM   4x4 Permit Number 775645 5991143.3 2102523.7 37.7526197703983 -122.473534716603 (37.7526197703983, -122.473534716603)
168183 118733 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 706 44th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5982303.905590001 2110925.66237 37.7751732905824 -122.504724857451 (37.7751732905824, -122.504724857451)
26210 118831 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 662 46th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5981671.941000001 2111218.67307 37.775940615740105 -122.50693266579799 (37.7759406157401, -122.506932665798)
24799 120350 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 2122 Lake St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   5988813.63616 2114710.28976 37.7859456052821 -122.482483881641 (37.7859456052821, -122.482483881641)
172227 120404 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 527 23rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5988748.3356 2111702.11927 37.777682216959704 -122.482489301184 (37.7776822169597, -122.482489301184)
100949 121598 Permitted Site 1 Eriobotrya japonica :: Edible Loquat 190 916 Ortega St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4x4   5991143.3 2102523.7 37.7526197703983 -122.473534716603 (37.7526197703983, -122.473534716603)
162191 123640 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 345 Arguello Blvd 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 6ft   5995501.56716 2113883.85045 37.784063214039605 -122.459285759007 (37.7840632140396, -122.459285759007)
45069 126561 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 8 Codman Pl 2 Back Yard : Yard 13 Tree 1 Private 1     7     6009832.93804 2117260.0663900003 37.7941470150322 -122.40994260678998 (37.7941470150322, -122.40994260679)
184764 126562 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 8 Codman Pl 1 Back Yard : Yard 13 Tree 1 Private 1     9     6009829.32931 2117256.5326099996 37.7941371098806 -122.40995484385901 (37.7941371098806, -122.409954843859)
171139 126563 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1519 Pacific Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6006819.81222 2117673.20836 37.795112068514705 -122.420397705787 (37.7951120685147, -122.420397705787)
154781 126564 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1519 Pacific Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6006833.89403 2117675.37487 37.7951188107324 -122.42034913432501 (37.7951188107324, -122.420349134325)
177924 126565 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1519 Pacific Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6006864.87455 2117678.3281900003 37.795128665521 -122.420242146478 (37.795128665521, -122.420242146478)
71206 126566 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1519 Pacific Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6006877.845840001 2117681.84008 37.79513903917879 -122.420197513099 (37.7951390391788, -122.420197513099)
165907 126567 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 2843 Larkin St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 5ft   6006455.5801099995 2121070.56705 37.8044198232789 -122.42189945398998 (37.8044198232789, -122.42189945399)
25243 126568 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 2745 Larkin St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4     6006520.94056 2120654.06544 37.8032799020007 -122.421643667929 (37.8032799020007, -122.421643667929)
163114 126569 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 2745 Larkin St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8     6006516.40415 2120646.68987 37.8032593947653 -122.42165884218599 (37.8032593947653, -122.421658842186)
167274 126570 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 94 MacOndray Ln 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7     6008053.53116 2119101.30283 37.7991027057905 -122.41623003160299 (37.7991027057905, -122.416230031603)
42410 126571 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1013 Vallejo St 2 Front Yard : Yard 7 Tree 1 Private 1     13     6008640.83285 2118637.5271099997 37.7978622987641 -122.414164932777 (37.7978622987641, -122.414164932777)
47316 126572 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1001 Vallejo St 5 Front Yard : Yard 7 Tree 1 Private 1     6     6008680.36365 2118649.32289 37.7978969073709 -122.414028979559 (37.7978969073709, -122.414028979559)
37182 143060 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 444 GREENWICH ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   6010718.0238 2120346.7181 37.80267177317779 -122.407097773383 (37.8026717731778, -122.407097773383)
2765 173854 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 240 Missouri St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6013446.0 2105960.0 37.763321440581 -122.396648407729 (37.763321440581, -122.396648407729)
59361 176270 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 195 Rome St 1 Front Yard : Yard 7 Tree 1 Private 1     3 Width 0ft   5998756.35201 2088943.21744 37.7157689240671 -122.44623074418001 (37.7157689240671, -122.44623074418)
180486 176271 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 195 Rome St 2 Front Yard : Yard 7 Tree 1 Private 1     3 Width 0ft   5998766.3474 2088951.7637599998 37.715792961145205 -122.446196810045 (37.7157929611452, -122.446196810045)
155016 176272 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 179 Niagara Ave 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 0ft   5999311.03211 2089604.94508 37.717617539904296 -122.444361048235 (37.7176175399043, -122.444361048235)
155390 176273 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 179 Niagara Ave 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     2 Width 0ft   5999314.98259 2089602.87456 37.717612080124205 -122.444347244552 (37.7176120801242, -122.444347244552)
37671 176274 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 775 London St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6     6000713.865119999 2089358.3764799999 37.7170204575094 -122.439494437135 (37.7170204575094, -122.439494437135)
158863 176275 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 23 Byron Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5999165.787269999 2086612.0753799998 37.7093915094837 -122.444648098339 (37.7093915094837, -122.444648098339)
160633 176276 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 62 Tomaso Ct 7 Front Yard : Yard 7 Tree 1 Private 1     12 Width 8ft   6009192.32266 2086308.3659400002 37.7091246419674 -122.40997318013201 (37.7091246419674, -122.409973180132)
58281 176277 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 190 Foote Ave 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 8ft   5998652.47444 2088356.09646 37.7141508908239 -122.44654757532301 (37.7141508908239, -122.446547575323)
65151 176278 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 87 Seneca Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 1ft   6000216.84897 2089896.4695599999 37.7184696403425 -122.441250964156 (37.7184696403425, -122.441250964156)
153224 176279 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 671 London St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7     6001065.40936 2089903.8077599998 37.7185380904529 -122.43831837391001 (37.7185380904529, -122.43831837391)
148462 176280 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 600 Blanken Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 5ft   6013180.81524 2086857.6738099998 37.7108556687339 -122.39622672069599 (37.7108556687339, -122.396226720696)
177778 176281 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 600 Blanken Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 5ft   6013188.37125 2086854.32403 37.710846891333105 -122.39620037057101 (37.7108468913331, -122.396200370571)
115840 176282 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 35 Tomaso Ct 8 Side Yard : Yard 17 Tree 1 Private 1     3 Width 3ft   6009202.48899 2086331.0577900002 37.709187518951296 -122.40993964441401 (37.7091875189513, -122.409939644414)
77276 176283 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 35 Tomaso Ct 9 Side Yard : Yard 17 Tree 1 Private 1     8 Width 3ft   6009206.42472 2086339.2337599997 37.7092101890802 -122.40992661863999 (37.7092101890802, -122.40992661864)
172703 176284 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 251 De Long St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 10ft   5993742.60383 2086796.45358 37.7095868089467 -122.46340473574101 (37.7095868089467, -122.463404735741)
51044 176285 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1 Santa Barbara Ave 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 8ft   5993431.64495 2086606.10767 37.7090462435678 -122.464465643484 (37.7090462435678, -122.464465643484)
36817 176286 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 901 Delano Ave 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 6ft   5998666.60141 2089601.1299700001 37.7175702751322 -122.446588269645 (37.7175702751322, -122.446588269645)
181257 176287 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1565 Bacon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6006970.59339 2091697.7707099998 37.723798037137 -122.418033639041 (37.723798037137, -122.418033639041)
57409 176288 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 51 Tulane St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   6007278.5163199995 2093753.93468 37.7294611462914 -122.41711482421199 (37.7294611462914, -122.417114824212)
46503 176289 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 140 South Hill Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 6ft   6003155.69301 2086832.03957 37.710222356236 -122.430874024341 (37.710222356236, -122.430874024341)
166383 176290 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 324 Naylor St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 2ft   6002773.326830001 2086530.28935 37.7093721434675 -122.43217402313101 (37.7093721434675, -122.432174023131)
160122 181986 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 2475 34th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 0ft   5985788.161 2098383.3055 37.7409397902725 -122.491748687988 (37.7409397902725, -122.491748687988)
63802 183573 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 2587 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5988295.3826 2097727.4025 37.7392850696685 -122.483031684036 (37.7392850696685, -122.483031684036)
73148 183678 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 3623 Irving St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   5984470.6439 2106306.3709 37.7626172515097 -122.49688873282601 (37.7626172515097, -122.496888732826)
177760 184363 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 2251 47th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 0ft   5981706.71 2099767.9271 37.7445021893581 -122.50596322728998 (37.7445021893581, -122.50596322729)
72600 187568 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 138 Alpha St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 10ft   6010896.54149 2088103.23155 37.714148350239704 -122.40420934958401 (37.7141483502397, -122.404209349584)
36917 191685 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1301 Minnesota St 13 Front Yard : Yard 7 Tree 1 Private 1     4     6015385.022890001 2102351.0583099998 37.7535197845136 -122.38968982661801 (37.7535197845136, -122.389689826618)
55102 191686 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1301 Minnesota St 14 Front Yard : Yard 7 Tree 1 Private 1     6     6015385.377169999 2102357.3727700002 37.7535371423304 -122.38968904242701 (37.7535371423304, -122.389689042427)
75558 191687 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 800 19th St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 10ft   6015123.17396 2105339.16037 37.7617099499859 -122.390804173874 (37.7617099499859, -122.390804173874)
170332 191688 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 800 19th St 18 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 10ft   6014977.94549 2105331.22601 37.761680105066105 -122.39130591015 (37.7616801050661, -122.39130591015)
38723 191689 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1 01st St 27 : Yard 23 Tree 1 Private 1     3     6014402.09171 2105890.67407 37.7631842517621 -122.393336722306 (37.7631842517621, -122.393336722306)
67780 191690 DPW Maintained 3 Eriobotrya japonica :: Edible Loquat 190 900x Carolina St 22 Median : Yard 3 Tree 1 DPW 2     2     6012468.62754 2103498.74867 37.756508943061206 -122.39985600137399 (37.7565089430612, -122.399856001374)
56447 191691 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 2301 19th St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7     6010894.94565 2105057.58809 37.7607013108401 -122.405408158461 (37.7607013108401, -122.405408158461)
177554 191692 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 764 De Haro St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9     6012093.5937 2104845.22166 37.7601851458373 -122.401247624904 (37.7601851458373, -122.401247624904)
50631 191693 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 2212 25th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6012143.16846 2101895.7398 37.752089281506706 -122.400868941954 (37.7520892815067, -122.400868941954)
180758 191694 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 2250 25th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 2ft   6012110.050319999 2101893.7239200003 37.7520818989832 -122.400983328513 (37.7520818989832, -122.400983328513)
64747 191695 DPW Maintained 3 Eriobotrya japonica :: Edible Loquat 190 950x Kansas St 4 Median : Yard 3 Tree 1 DPW 2     4     6011603.94241 2103847.92507 37.7574194607598 -122.40287096412901 (37.7574194607598, -122.402870964129)
34441 191696 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1700 22nd St 3 Front Yard : Yard 7 Tree 1 Private 1     7     6012930.9536 2103804.38992 37.7573739307682 -122.398278546439 (37.7573739307682, -122.398278546439)
41768 191697 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1700 22nd St 7 Front Yard : Yard 7 Tree 1 Private 1     13     6012906.9277800005 2103803.94978 37.7573713838993 -122.398361606903 (37.7573713838993, -122.398361606903)
182683 191698 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 602 Arthur Ave 35 Front Yard : Yard 7 Tree 1 Private 1     2     6015659.044530001 2099869.60737 37.7467214305684 -122.38856899259 (37.7467214305684, -122.38856899259)
184746 191699 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 50 Quint St 4 Front Yard : Yard 7 Tree 1 Private 1     4 Width 6ft   6015737.97927 2099766.7157099997 37.7464432855229 -122.388288861864 (37.7464432855229, -122.388288861864)
50134 191700 DPW Maintained 3 Eriobotrya japonica :: Edible Loquat 190 1700x Quesada Ave 39 Median : Yard 3 Tree 1 DPW 2     3     6014384.30677 2095263.8272900002 37.7340041867507 -122.39265480417801 (37.7340041867507, -122.392654804178)
173225 191701 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 2025 Revere Ave 1 : 4 Tree 1 Private 1     1 Width 2ft   6012750.04967 2096000.3617900002 37.7359356579989 -122.398356633674 (37.7359356579989, -122.398356633674)
48766 191702 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1998 Revere Ave 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1     6013024.54675 2095962.65305 37.7358474048249 -122.397404937794 (37.7358474048249, -122.397404937794)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 136.247ms · Data source: data.sfgov.org