Street_Tree_List

Data source: data.sfgov.org

180 rows where qSpecies = 190 sorted by DBH

✎ View and edit SQL

This data as json, CSV (advanced)

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

DBH ✖

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH ▼ PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
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)
78574 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)
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)
84522 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)
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)
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)
141988 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)
26546 26546 191706 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1499 Rankin St 7 Side Yard : Yard 17 Tree 1 Private 1     1 Width 3ft   6012685.03055 2096691.5436200001 37.7378298766422 -122.39862992054701 (37.7378298766422, -122.398629920547)
48766 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)
51044 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)
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)
58281 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 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)
133319 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)
151623 151623 207729 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 10 Mendosa Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5993528.0302800005 2101159.3791400003 37.749011508281995 -122.46518888187799 (37.749011508282, -122.465188881878)
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)
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)
173225 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)
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)
15545 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)
41649 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)
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)
56636 56636 207715 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 117 Judson Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2     5999294.96193 2093458.5663400001 37.7281977787 -122.444693427785 (37.7281977787, -122.444693427785)
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)
155390 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)
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)
161098 161098 207716 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 115 Judson Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 8ft   5999335.92351 2093459.52729 37.72820275463761 -122.44455189156601 (37.7282027546376, -122.444551891566)
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)
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)
6018 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 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 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)
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)
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)
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)
38723 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)
50134 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)
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)
55948 55948 207724 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 132 Ralston St 1 : 4 Tree 1 Private 1     3 Width 3ft   5992208.616230001 2088772.7459099998 37.71492473315389 -122.46885013341999 (37.7149247331539, -122.46885013342)
59361 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)
65580 65580 191710 DPW Maintained 3 Eriobotrya japonica :: Edible Loquat 190 1427x Innes Ave 28 Median : Yard 3 Tree 1 DPW 2     3     6016141.2133599995 2096757.17707 37.7382020430791 -122.386684681762 (37.7382020430791, -122.386684681762)
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)
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)
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)
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)
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)
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)
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)
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)
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)
180486 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)
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)
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)
36917 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)
48398 48398 224111 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1100 San Jose Ave 50 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4     6004733.53405 2096634.51546 37.7372270772601 -122.42611806850799 (37.7372270772601, -122.426118068508)
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)
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)
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)
133784 133784 224113 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1100 San Jose Ave 69 Front Yard : Yard 7 Tree 1 Private 1     4     6004690.02185 2096554.43933 37.7370047468799 -122.426262810788 (37.7370047468799, -122.426262810788)
135365 135365 224124 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1244 Treat Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6008668.58024 2101297.73586 37.7502528748804 -122.412842355611 (37.7502528748804, -122.412842355611)
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)
151773 151773 224122 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 211 Ogden Ave 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   6008272.03754 2096094.4851799998 37.73594363319479 -122.41384561137899 (37.7359436331948, -122.413845611379)
162057 162057 247967 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 16 Joy St 3 Front Yard : Yard 7 Tree 1 Private 1     4     6010333.495709999 2098927.4961099997 37.743838026898295 -122.40691790615 (37.7438380268983, -122.40691790615)
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)
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)
181257 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)
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)
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)
62610 62610 224125 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1745 Folsom St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6008033.82801 2108179.5959900003 37.7691132329216 -122.415524547646 (37.7691132329216, -122.415524547646)
71206 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)
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)
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)
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)
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)
155016 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)
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)
165369 165369 224112 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1100 San Jose Ave 51 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5     6004737.84332 2096628.1853599998 37.7372099397936 -122.42610271887101 (37.7372099397936, -122.426102718871)
169472 169472 207719 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 126 Brighton Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 1ft   5996251.42646 2090752.11635 37.7205923605284 -122.455019501973 (37.7205923605284, -122.455019501973)
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)
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)
177924 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)
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)

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