Street_Tree_List

Data source: data.sfgov.org

180 rows where qSpecies = 190 sorted by qAddress descending

✎ View and edit SQL

This data as json, CSV (advanced)

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
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)
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)
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)
64747 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)
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)
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)
80361 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)
100949 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)
157462 157462 207708 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 916 Ortega St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 1ft   5991151.901959999 2102512.9309 37.7525906994144 -122.473504184373 (37.7525906994144, -122.473504184373)
167474 167474 207709 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 916 Ortega St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 1ft   5991129.27817 2102510.74063 37.752583375332605 -122.47358226082 (37.7525833753326, -122.47358226082)
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)
67780 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)
65151 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)
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)
143567 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)
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)
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)
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)
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)
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)
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)
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)
168654 168654 207720 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 750 Grafton Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5994515.7556300005 2090598.91337 37.7200719768186 -122.46100802721901 (37.7200719768186, -122.461008027219)
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)
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)
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)
55093 55093 202013 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 7 Wheat St 2 : 4 Tree 1 Private 1     3 Width 3ft   6012149.42791 2091374.5561400002 37.723200675946394 -122.40010846893601 (37.7232006759464, -122.400108468936)
71579 71579 248210 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 69 Fair Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 6ft   6007064.668 2099422.3589 37.7450133544796 -122.418255851634 (37.7450133544796, -122.418255851634)
79512 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)
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)
26210 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)
158994 158994 207710 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 641 Moraga St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5992286.81518 2103851.81856 37.7563325940936 -122.46967695664 (37.7563325940936, -122.46967695664)
16066 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)
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)
182683 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)
148462 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 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)
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)
138223 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)
172227 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)
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)
57409 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)
172056 172056 207733 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 500 Joost Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4     5998757.70005 2094996.74516 37.732390582643205 -122.446661380942 (37.7323905826432, -122.446661380942)
141580 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)
184746 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)
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)
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)
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)
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)
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)
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)
182532 182532 247879 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 388 Mayflower St 8 Side Yard : Yard 17 Tree 1 Private 1     3     6009924.148030001 2098382.32436 37.7423181897436 -122.408294896795 (37.7423181897436, -122.408294896795)
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)
179929 179929 207728 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 3802 19th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 4ft   5990564.76109 2090542.95021 37.7196901687566 -122.47466105158199 (37.7196901687566, -122.474661051582)
29285 29285 207725 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 380 Ralston St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 6ft   5992234.508719999 2090438.5826599998 37.7195002121526 -122.468881791362 (37.7195002121526, -122.468881791362)
69216 69216 207727 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 378 Victoria St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 6ft   5993265.77465 2089711.0849799998 37.717562206406 -122.46526429632601 (37.717562206406, -122.465264296326)
70263 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)
73148 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)
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)
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)
115840 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)
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)
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)
49466 49466 224126 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 3213 21st St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6006857.14128 2103777.70396 37.7569604557817 -122.41928234412902 (37.7569604557817, -122.419282344129)
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)
154658 154658 207718 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 315 Faxon Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5994723.84306 2090686.3460799998 37.7203240181088 -122.46029507616998 (37.7203240181088, -122.46029507617)
186212 186212 200198 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 3125 Jennings St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 0ft   6013701.6232 2090281.2208 37.720285019418505 -122.394666263771 (37.7202850194185, -122.394666263771)
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)
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)
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)
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)
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)
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)
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)
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)
165907 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)
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)
25243 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 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)
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)
63802 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)
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)
172703 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)
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)
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)
172414 172414 249620 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 2400 Golden Gate Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 7ft   5997953.57215 2111367.44178 37.7772944806811 -122.45062126495199 (37.7772944806811, -122.450621264952)
2765 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)
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)
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)
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)
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)
158863 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)
174539 174539 207721 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 228 Montana St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5     5994631.9391 2089350.3088 37.7166502911674 -122.460515994629 (37.7166502911674, -122.460515994629)
177760 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)
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)
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)
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)
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)
24799 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)

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