Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qCareAssistant, PlantDate, DBH, PlotSize
qSiteInfo ✖
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||
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) | ||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||
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) | ||||
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) | ||||
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) | |
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) | |
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) | |||||
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) | ||||
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) | ||
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) | ||||
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) | ||||
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) | ||||
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) | ||
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) | |||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | |
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) | ||||
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 | ||||||||
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) | |||
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 | ||||||||
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 | ||||||||
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 | ||||||||
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) | ||
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) | |||
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) | |||||
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) | ||||
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) | |||
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) | |||
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) | ||
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) | ||||
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) | |
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) | |||
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) | ||||
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) | ||
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) | |||
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 | ||||||||
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 | ||||||||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) |
JSON shape: default, array, newline-delimited
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");