Street_Tree_List

Data source: data.sfgov.org

180 rows where qSpecies = 190 sorted by DBH descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH ▲ PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
14534 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)
21420 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)
175044 175044 207732 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 400 Congo St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     19 Width 10ft   6000124.6238 2095012.3046900001 37.7325112932663 -122.441936736802 (37.7325112932663, -122.441936736802)
17577 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)
64704 64704 191708 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 979 Le Conte Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18     6013251.209530001 2089459.918 37.7180048338374 -122.396165676526 (37.7180048338374, -122.396165676526)
73220 73220 246771 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1850 Alabama St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     18     6009333.37029 2098874.50038 37.743636497837 -122.410372378408 (37.743636497837, -122.410372378408)
180825 180825 224130 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 840 Castro St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18     6002416.06064 2103301.09689 37.7554006877977 -122.434607174889 (37.7554006877977, -122.434607174889)
35128 35128 249903 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 300 Greenwich St 4 Front Yard : Yard 7 Tree 1 Private 1     17 Width 0ft   6011307.54061 2120412.72536 37.8028859854681 -122.40506238711399 (37.8028859854681, -122.405062387114)
27037 27037 207730 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 740 Foerster St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 3ft   5998158.00142 2095945.9651099998 37.7349626400957 -122.44880301654 (37.7349626400957, -122.44880301654)
61536 61536 246754 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1838 Alabama St 1 Front Yard : Yard 7 Tree 1 Private 1     16     6009313.62627 2099009.8875700003 37.7440071345341 -122.410450206611 (37.7440071345341, -122.410450206611)
186894 186894 246755 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1838 Alabama St 2 Front Yard : Yard 7 Tree 1 Private 1     16     6009311.20113 2098998.06122 37.7439745260177 -122.410457757318 (37.7439745260177, -122.410457757318)
122151 122151 207726 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 416 Ralston St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 10ft   5992237.92359 2090619.0138400001 37.719995829436 -122.468883110676 (37.719995829436, -122.468883110676)
25968 25968 249846 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 289 Greenwich St 3 Side Yard : Yard 17 Tree 1 Private 1     14 Width 0ft   6011427.16735 2120382.55668 37.8028098362532 -122.40464628970601 (37.8028098362532, -122.404646289706)
34978 34978 249883 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 230 Greenwich St 19 Back Yard : Yard 13 Tree 1 Private 1     14 Width 0ft   6011507.08304 2120427.1107900003 37.802936637067496 -122.40437287690901 (37.8029366370675, -122.404372876909)
27406 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)
41768 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)
42410 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)
7267 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 8172 19836 DPW Maintained 3 Eriobotrya japonica :: Edible Loquat 190 100 STAIRWAY25 20 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 60X            
16686 16686 19817 DPW Maintained 3 Eriobotrya japonica :: Edible Loquat 190 100 STAIRWAY25 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 100ST            
35240 35240 207714 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 298 Staples Ave 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12     5998133.74364 2093826.5868 37.7291419427263 -122.448734282271 (37.7291419427263, -122.448734282271)
135662 135662 191707 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 2187 Revere Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12     6011937.92175 2096699.9343299998 37.7378112633764 -122.401213644004 (37.7378112633764, -122.401213644004)
160633 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)
172289 172289 207711 DPW Maintained 3 Eriobotrya japonica :: Edible Loquat 190 200x Terrace Dr 31 Median : Yard 3 Tree 1 DPW 2     12     5993844.07189 2096487.62875 37.7362022754996 -122.463756979508 (37.7362022754996, -122.463756979508)
34006 34006 207717 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1180 Plymouth Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 3ft   5995974.63238 2091762.70234 37.723351307004705 -122.456049310222 (37.7233513070047, -122.456049310222)
73834 73834 207713 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 171 Flood Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11     5999625.5730099995 2094046.65577 37.7298313962868 -122.443592725033 (37.7298313962868, -122.443592725033)
133186 133186 249880 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 230 Greenwich St 16 Back Yard : Yard 13 Tree 1 Private 1     11 Width 0ft   6011523.78476 2120446.01272 37.8029894704488 -122.404316411196 (37.8029894704488, -122.404316411196)
158045 158045 249890 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 230 Greenwich St 26 Back Yard : Yard 13 Tree 1 Private 1     11 Width 0ft   6011458.55673 2120431.8571900004 37.8029469576839 -122.40454113827101 (37.8029469576839, -122.404541138271)
2713 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)
46503 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)
66405 66405 249910 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 308 Greenwich St 2 Front Yard : Yard 7 Tree 1 Private 1     10 Width 0ft   6011272.31007 2120413.3018099996 37.8028855987512 -122.40518434418699 (37.8028855987512, -122.405184344187)
94834 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)
160122 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)
29901 29901 191709 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 3535 Jennings St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9     6013020.366769999 2089365.2626599998 37.717732082047895 -122.39695697201 (37.7177320820479, -122.39695697201)
33648 33648 224127 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 950 Corbett Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   5999802.0318599995 2102082.0449599996 37.7519047262434 -122.443559684852 (37.7519047262434, -122.443559684852)
37458 37458 246770 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 99 Waltham St 3 Side Yard : Yard 17 Tree 1 Private 1     9     6009309.01668 2098932.20278 37.7437935707282 -122.410460661231 (37.7437935707282, -122.410460661231)
64078 64078 247873 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 388 Mayflower St 1 Side Yard : Yard 17 Tree 1 Private 1     9     6009888.01932 2098399.59712 37.7423635938187 -122.40842103750299 (37.7423635938187, -122.408421037503)
75891 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)
150484 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)
157517 157517 224132 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 310 Liberty St 26 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 3ft   6004003.018680001 2103934.91108 37.7572309538551 -122.42916418288401 (37.7572309538551, -122.429164182884)
158587 158587 249981 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 224 Filbert St 2 Front Yard : Yard 7 Tree 1 Private 1     9 Width 0ft   6011659.45074 2120118.51197 37.8020978133144 -122.403823874987 (37.8020978133144, -122.403823874987)
172510 172510 224129 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 26 Portola Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   5999702.07185 2101445.78437 37.7501520078164 -122.44385965101499 (37.7501520078164, -122.443859651015)
177554 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)
184764 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)
184788 184788 224119 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 410 Valley St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 2ft   6003252.6682 2099235.68131 37.744285469291896 -122.43142373132099 (37.7442854692919, -122.431423731321)
34794 34794 224120 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1350 Noe St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8     6003219.3903 2100351.64414 37.7473477571063 -122.431618456154 (37.7473477571063, -122.431618456154)
54742 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)
72600 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)
77276 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)
129729 129729 207722 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 300 Louisburg St 1 : 4 Tree 1 Private 1     8 Width 3ft   5997412.90563 2090249.0512400002 37.7192776245304 -122.45096839786801 (37.7192776245304, -122.450968397868)
135288 135288 246764 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 70 Waltham St 8 Front Yard : Yard 7 Tree 1 Private 1     8     6009279.96949 2098891.64841 37.7436805888792 -122.410558236772 (37.7436805888792, -122.410558236772)
153779 153779 207734 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 301 Joost Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 10ft   6000042.84201 2094939.4846400002 37.7323066857905 -122.442214249597 (37.7323066857905, -122.442214249597)
159049 159049 224115 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1100 San Jose Ave 71 Front Yard : Yard 7 Tree 1 Private 1     8     6004680.7613 2096547.43611 37.7369849941684 -122.426294330213 (37.7369849941684, -122.426294330213)
161021 161021 207707 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1254 18th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 3ft   5990519.642630001 2106849.6628099997 37.7644615768749 -122.476007325895 (37.7644615768749, -122.476007325895)
161284 161284 207731 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 32 Malta Dr 19 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5999573.254930001 2096045.34694 37.735316349769704 -122.443917140176 (37.7353163497697, -122.443917140176)
163114 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)
165090 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)
166383 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)
180758 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)
23535 23535 207712 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 579 Hearst Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7     5997579.44084 2094367.86788 37.730596459453395 -122.450689553205 (37.7305964594534, -122.450689553205)
23748 23748 224117 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 2818 23rd St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6009831.98095 2102814.76339 37.754483528604396 -122.40892624516701 (37.7544835286044, -122.408926245167)
25572 25572 191703 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1501 Quint St 2 Front Yard : Yard 7 Tree 1 Private 1     7 Width 4ft   6013259.66608 2096346.4213299998 37.7369142408999 -122.396618925818 (37.7369142408999, -122.396618925818)
34441 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)
45069 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)
56447 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)
57318 57318 218344 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 385 Castenada Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 0ft   5993369.339269999 2100022.3312 37.745880311731 -122.46565503467501 (37.745880311731, -122.465655034675)
68300 68300 224116 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 400 Prospect Ave 15 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7     6006205.79839 2097605.42741 37.7399760871276 -122.421096686769 (37.7399760871276, -122.421096686769)
74925 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)
75558 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)
153224 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)
153997 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)
154589 154589 201358 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 245 Kalmanovitz St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 2ft   6013008.61874 2092664.0279400002 37.726789172374794 -122.39722877051001 (37.7267891723748, -122.39722877051)
154781 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)
162191 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)
167274 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)
168183 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)
171139 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)
177598 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 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)
185039 185039 224123 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 523 Powhattan Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7     6008526.38321 2098121.4064599997 37.7415233967761 -122.413109512687 (37.7415233967761, -122.413109512687)
15209 15209 19838 DPW Maintained 3 Eriobotrya japonica :: Edible Loquat 190 100 STAIRWAY25 22 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 60X            
17045 17045 19792 DPW Maintained 3 Eriobotrya japonica :: Edible Loquat 190 100 STAIRWAY19 14 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 20ST            
32095 32095 224121 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 211 Ogden Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   6008290.10508 2096093.22608 37.7359411906366 -122.413783055452 (37.7359411906366, -122.413783055452)
36817 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)
37182 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)
37671 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)
39445 39445 224131 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1340 Alabama St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   6009255.1331 2101276.97976 37.7502287892492 -122.41081254437799 (37.7502287892492, -122.410812544378)
47316 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)
50631 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)
55102 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)
67005 67005 191705 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1700 Armstrong Ave 3 Side Yard : Yard 17 Tree 1 Private 1     6     6013900.77828 2092879.68746 37.727430958252604 -122.394159667654 (37.7274309582526, -122.394159667654)
72590 72590 249863 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 233 Greenwich St 4 Front Yard : Yard 7 Tree 1 Private 1     6 Width 0ft   6011630.0308300005 2120434.01589 37.8029624665125 -122.40394789778799 (37.8029624665125, -122.403947897788)
133017 133017 224114 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1100 San Jose Ave 70 Front Yard : Yard 7 Tree 1 Private 1     6     6004687.50549 2096549.1812200001 37.736990167061 -122.42627113673001 (37.736990167061, -122.42627113673)
154979 154979 224128 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 18 Portola Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5999679.40978 2101490.53022 37.750273576386704 -122.443941232111 (37.7502735763867, -122.443941232111)
170332 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)
186390 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)
187509 187509 191704 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1501 Quint St 3 Front Yard : Yard 7 Tree 1 Private 1     6 Width 4ft   6013263.69136 2096352.02038 37.736929838751294 -122.396605400918 (37.7369298387513, -122.396605400918)
35482 35482 207723 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 301 Byxbee St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 10ft   5991929.884269999 2090544.1507700002 37.719772472009204 -122.469942439216 (37.7197724720092, -122.469942439216)
37208 37208 224118 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1525 Florida St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6009611.07907 2100364.72243 37.7477438841853 -122.409517278718 (37.7477438841853, -122.409517278718)
41072 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)

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 79.044ms · Data source: data.sfgov.org