Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 127904 | 127904 | 105121 | Undocumented 2 | :: 54 | 721 BEACH ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 6006739.7 | 2121813.5 | 37.8064757462399 | -122.42096901139601 | (37.8064757462399, -122.420969011396) | |||||
| 128256 | 128256 | 37520 | Permitted Site 1 | :: 54 | 649 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | Permit Number 39973 | 6008796.59183246 | 2114756.17350418 | 37.787213798801396 | -122.41335133309099 | (37.7872137988014, -122.413351333091) | ||
| 129236 | 129236 | 41854 | Permitted Site 1 | :: 54 | 942 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42241 | 5991990.35837611 | 2105257.12694546 | 37.7601740626082 | -122.47080455929701 | (37.7601740626082, -122.470804559297) | ||
| 129313 | 129313 | 117320 | Permitted Site 1 | :: 54 | 1935 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2016 12:00:00 AM | 3 | Permit Number 778503 | 5993426.4 | 2102307.1 | 37.7521569948021 | -122.465623688401 | (37.7521569948021, -122.465623688401) | ||
| 138269 | 138269 | 116274 | Undocumented 2 | :: 54 | 700X Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 138290 | 138290 | 39089 | Permitted Site 1 | :: 54 | 3140102 21st St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40782 | 6007340.78433039 | 2103849.3427132 | 37.757184385901496 | -122.41761479761601 | (37.7571843859015, -122.417614797616) | ||
| 138579 | 138579 | 116278 | Undocumented 2 | :: 54 | 700X Greenwich St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 138801 | 138801 | 115762 | Undocumented 2 | :: 54 | 84X Cordova St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | on Athens Street frontage | 6001679.7 | 2087642.4 | 37.712363687575795 | -122.43603329568501 | (37.7123636875758, -122.436033295685) | |||
| 138812 | 138812 | 108798 | Undocumented 2 | :: 54 | 501-599 University St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008503.45306 | 2091469.8325200002 | 37.7232583218261 | -122.412718672961 | (37.7232583218261, -122.412718672961) | |||||
| 139188 | 139188 | 108993 | Undocumented 2 | :: 54 | 2073-2099X Jefferson St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999311.1 | 2121145.9 | 37.8042211586385 | -122.446628874501 | (37.8042211586385, -122.446628874501) | |||||
| 139436 | 139436 | 35137 | Permitted Site 1 | :: 54 | 832 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38668 | 6002000.93226273 | 2088942.9752097 | 37.7159530242515 | -122.435015979431 | (37.7159530242515, -122.435015979431) | ||
| 140174 | 140174 | 31188 | Permitted Site 1 | :: 54 | 744 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34885 | 5992088.16257343 | 2089881.74957895 | 37.7179628280945 | -122.469347142572 | (37.7179628280945, -122.469347142572) | ||
| 140188 | 140188 | 116280 | Undocumented 2 | :: 54 | 700X Greenwich St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 140197 | 140197 | 33406 | Permitted Site 1 | :: 54 | 100 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | Permit Number 37523 | 5996457.34152631 | 2099451.4193202 | 37.7444903608651 | -122.454935970247 | (37.7444903608651, -122.454935970247) | ||
| 141077 | 141077 | 39090 | Permitted Site 1 | :: 54 | 3140102 21st St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/1998 12:00:00 AM | Permit Number 40782 | 6007340.78433039 | 2103849.3427132 | 37.757184385901496 | -122.41761479761601 | (37.7571843859015, -122.417614797616) | ||
| 141239 | 141239 | 116275 | Undocumented 2 | :: 54 | 700X Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 141787 | 141787 | 103673 | Property Tree 7 | :: 54 | 64 Henry St | Back Yard : Yard 13 | Tree 1 | Private 1 | 6003097.0 | 2107420.0 | 37.7667488371496 | -122.432546472662 | (37.7667488371496, -122.432546472662) | ||||||
| 141810 | 141810 | 33041 | Permitted Site 1 | :: 54 | 322 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1998 12:00:00 AM | Permit Number 39744 | 6005441.34293998 | 2101824.8118286 | 37.751518429358605 | -122.424039839357 | (37.7515184293586, -122.424039839357) | ||
| 141862 | 141862 | 105088 | Significant Tree 6 | :: 54 | 344 Fulton St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 142035 | 142035 | 31191 | Permitted Site 1 | :: 54 | 744 Shields St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34885 | 5992088.16257343 | 2089881.74957895 | 37.7179628280945 | -122.469347142572 | (37.7179628280945, -122.469347142572) | ||
| 142347 | 142347 | 109178 | Permitted Site 1 | :: 54 | 2832 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2015 12:00:00 AM | 3 | 6001592.1 | 2118171.6 | 37.796184544404895 | -122.438522078694 | (37.7961845444049, -122.438522078694) | |||
| 143047 | 143047 | 115869 | Undocumented 2 | :: 54 | 84X Cordova St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | on Athens St frontage | 6001679.7 | 2087642.4 | 37.712363687575795 | -122.43603329568501 | (37.7123636875758, -122.436033295685) | ||||
| 143116 | 143116 | 37316 | Permitted Site 1 | :: 54 | 572 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39831 | 6002632.74186614 | 2103295.45378084 | 37.755397491549 | -122.433857422868 | (37.755397491549, -122.433857422868) | ||
| 143390 | 143390 | 36528 | Permitted Site 1 | :: 54 | 619 Eugenia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39400 | 6007328.0 | 2097732.0 | 37.74038682503829 | -122.41722553506399 | (37.7403868250383, -122.417225535064) | ||
| 143572 | 143572 | 116337 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 144086 | 144086 | 115893 | Permitted Site 1 | :: 54 | 1900X Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2016 12:00:00 AM | 3 | 5988841.66469 | 2105121.6083400003 | 37.75961937033 | -122.48168434385401 | (37.75961937033, -122.481684343854) | |||
| 144301 | 144301 | 116336 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 144770 | 144770 | 115064 | DPW Maintained 3 | :: 54 | 70 Coral Rd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.39906901845501 | (37.7538392609312, -122.399069018455) | |||||
| 145190 | 145190 | 33509 | Permitted Site 1 | :: 54 | 24 Coleridge St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37605 | 6006962.93911675 | 2099621.40648906 | 37.745554167617 | -122.418621725138 | (37.745554167617, -122.418621725138) | |||
| 145300 | 145300 | 34738 | Permitted Site 1 | :: 54 | 577 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38388 | 6007301.38154642 | 2103961.93369164 | 37.7574913175401 | -122.417759048452 | (37.7574913175401, -122.417759048452) | ||
| 145417 | 145417 | 115870 | Undocumented 2 | :: 54 | 84X Cordova St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | on Athens St. Frontage | 6001679.7 | 2087642.4 | 37.712363687575795 | -122.43603329568501 | (37.7123636875758, -122.436033295685) | ||||
| 145496 | 145496 | 108795 | Undocumented 2 | :: 54 | 501-599 University St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008503.45306 | 2091469.8325200002 | 37.7232583218261 | -122.412718672961 | (37.7232583218261, -122.412718672961) | |||||
| 146146 | 146146 | 31190 | Permitted Site 1 | :: 54 | 744 Shields St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34885 | 5992088.16257343 | 2089881.74957895 | 37.7179628280945 | -122.469347142572 | (37.7179628280945, -122.469347142572) | ||
| 146223 | 146223 | 115063 | DPW Maintained 3 | :: 54 | 70 Coral Rd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.39906901845501 | (37.7538392609312, -122.399069018455) | |||||
| 96541 | 96541 | 110246 | Permitted Site 1 | :: 54 | 1706 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 04/01/2015 12:00:00 AM | 3 | 1.5x12 | 5987540.7 | 2103643.4 | 37.755484875136204 | -122.486075162345 | (37.7554848751362, -122.486075162345) | ||
| 20483 | 20483 | 109769 | Permitted Site 1 | :: 54 | 2502X Bush St | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 1.5x12.75 | 6001313.62368 | 2114572.17699 | 37.786285618589204 | -122.43922754338101 | (37.7862856185892, -122.439227543381) | ||||
| 106864 | 106864 | 109768 | Permitted Site 1 | :: 54 | 2502X Bush St | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 1.5x13 | 6001313.62368 | 2114572.17699 | 37.786285618589204 | -122.43922754338101 | (37.7862856185892, -122.439227543381) | ||||
| 101235 | 101235 | 109535 | Permitted Site 1 | :: 54 | 1234 Filbert St | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | FUF 1 | 02/23/2015 12:00:00 AM | 3 | 1.5x2.4 | 6007007.9 | 2119506.8 | 37.800157248198296 | -122.419877066677 | (37.8001572481983, -122.419877066677) | |
| 112218 | 112218 | 109536 | Permitted Site 1 | :: 54 | 1234 Filbert St | 4 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | FUF 1 | 02/23/2015 12:00:00 AM | 3 | 1.5x2.4 | 6007007.9 | 2119506.8 | 37.800157248198296 | -122.419877066677 | (37.8001572481983, -122.419877066677) | |
| 126302 | 126302 | 109534 | Permitted Site 1 | :: 54 | 1234 Filbert St | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | FUF 1 | 02/23/2015 12:00:00 AM | 3 | 1.5x2.6 | 6007007.9 | 2119506.8 | 37.800157248198296 | -122.419877066677 | (37.8001572481983, -122.419877066677) | |
| 88689 | 88689 | 109762 | Permitted Site 1 | :: 54 | 1801 Scott St | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 1.5x6.5 | 6001511.7 | 2114646.3 | 37.786500410729104 | -122.43854756475099 | (37.7865004107291, -122.438547564751) | ||||
| 97786 | 97786 | 109767 | Permitted Site 1 | :: 54 | 1801 Scott St | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 11.75x1.5+3.6x3.6 | 6001511.7 | 2114646.3 | 37.786500410729104 | -122.43854756475099 | (37.7865004107291, -122.438547564751) | ||||
| 10104 | 10104 | 173847 | Permitted Site 1 | :: 54 | 450 Toland St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 11.85x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 2270 | 2270 | 253008 | Permitted Site 1 | :: 54 | 1201 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 11x477 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | ||
| 111918 | 111918 | 109831 | Permitted Site 1 | :: 54 | 146 Staples Ave | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 12x15.3 | 5999109.5 | 2093827.3 | 37.7291996500545 | -122.445361075989 | (37.7291996500545, -122.445361075989) | ||||
| 61493 | 61493 | 105361 | Permitted Site 1 | :: 54 | 850 Guerrero St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12x2.75 | 6005583.5 | 2103975.8 | 37.7574325683666 | -122.423701164602 | (37.7574325683666, -122.423701164602) | ||||
| 83497 | 83497 | 105359 | Permitted Site 1 | :: 54 | 850 Guerrero St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12x2.75 | 6005583.5 | 2103975.8 | 37.7574325683666 | -122.423701164602 | (37.7574325683666, -122.423701164602) | ||||
| 91070 | 91070 | 105360 | Permitted Site 1 | :: 54 | 850 Guerrero St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12x2.75 | 6005583.5 | 2103975.8 | 37.7574325683666 | -122.423701164602 | (37.7574325683666, -122.423701164602) | ||||
| 10096 | 10096 | 173850 | Permitted Site 1 | :: 54 | 450 Toland St | 5 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 13.9x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 125946 | 125946 | 109370 | Permitted Site 1 | :: 54 | 2061 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 13x6 | 6007159.6 | 2119443.7 | 37.799992536546505 | -122.41934764587201 | (37.7999925365465, -122.419347645872) | |
| 10101 | 10101 | 173846 | Permitted Site 1 | :: 54 | 450 Toland St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 15x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 94853 | 94853 | 104637 | Permitted Site 1 | :: 54 | 217 Montcalm St | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 16x16 | 6010036.0 | 2099691.0 | 37.7459177905176 | -122.40800041337499 | (37.7459177905176, -122.408000413375) | |||||
| 111744 | 111744 | 104636 | Permitted Site 1 | :: 54 | 217 Montcalm St | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 16x16 | 6010036.0 | 2099691.0 | 37.7459177905176 | -122.40800041337499 | (37.7459177905176, -122.408000413375) | |||||
| 118218 | 118218 | 104635 | Permitted Site 1 | :: 54 | 217 Montcalm St | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 16x16 | 6009833.3 | 2099565.6 | 37.7455621186719 | -122.40869248022899 | (37.7455621186719, -122.408692480229) | |||||
| 141674 | 141674 | 104634 | Permitted Site 1 | :: 54 | 217 Montcalm St | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 16x16 | 6009833.3 | 2099565.6 | 37.7455621186719 | -122.40869248022899 | (37.7455621186719, -122.408692480229) | |||||
| 10093 | 10093 | 173849 | Permitted Site 1 | :: 54 | 450 Toland St | 4 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 17.6x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 10098 | 10098 | 173848 | Permitted Site 1 | :: 54 | 450 Toland St | 3 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 19.5x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 88984 | 88984 | 109756 | Permitted Site 1 | :: 54 | 601 Steiner St | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 1x12 | 6003025.4 | 2110381.6 | 37.774876602731204 | -122.433005738531 | (37.7748766027312, -122.433005738531) | ||||
| 118010 | 118010 | 109755 | Permitted Site 1 | :: 54 | 601 Steiner St | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 1x12 | 6003025.4 | 2110381.6 | 37.774876602731204 | -122.433005738531 | (37.7748766027312, -122.433005738531) | ||||
| 121197 | 121197 | 109754 | Permitted Site 1 | :: 54 | 601 Steiner St | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 1x12 | 6003025.4 | 2110381.6 | 37.774876602731204 | -122.433005738531 | (37.7748766027312, -122.433005738531) | ||||
| 140543 | 140543 | 109342 | Permitted Site 1 | :: 54 | 3211 Baker St | 1 | Sidewalk: Property side : Yard 9 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | 1x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | ||
| 143440 | 143440 | 117372 | Permitted Site 1 | :: 54 | 1533 McAllister St | 5 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 06/08/2016 12:00:00 AM | 3 | 1x2.75 | 6001806.7 | 2111472.8 | 37.777803561930206 | -122.437299621265 | (37.7778035619302, -122.437299621265) | ||
| 10106 | 10106 | 173853 | Permitted Site 1 | :: 54 | 450 Toland St | 8 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 26.75x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 10097 | 10097 | 173851 | Permitted Site 1 | :: 54 | 450 Toland St | 6 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 01/27/2017 12:00:00 AM | 3 | 27.75x4 | 6012768.71675 | 2099101.44192 | 37.74445161113729 | -122.39850962968201 | (37.7444516111373, -122.398509629682) | ||
| 3650 | 3650 | 253518 | Permitted Site 1 | :: 54 | 559 24th Ave | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 09/15/2017 12:00:00 AM | 3 | 2x1 | 5988391.0 | 2112180.0 | 37.7789735494402 | -122.483760479148 | (37.7789735494402, -122.483760479148) | ||
| 106819 | 106819 | 105042 | Permitted Site 1 | :: 54 | 2660 Harrison St | 4 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 2x10 | 6008868.4 | 2102978.1 | 37.7548779915591 | -122.412270115586 | (37.7548779915591, -122.412270115586) | ||||
| 3660 | 3660 | 253516 | Permitted Site 1 | :: 54 | 559 24th Ave | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 09/15/2017 12:00:00 AM | 3 | 2x2 | 5988392.0 | 2112177.0 | 37.778965370493495 | -122.483756799769 | (37.7789653704935, -122.483756799769) | ||
| 140829 | 140829 | 105041 | Permitted Site 1 | :: 54 | 2660 Harrison St | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 2x2 | 6008868.4 | 2102978.1 | 37.7548779915591 | -122.412270115586 | (37.7548779915591, -122.412270115586) | ||||
| 85310 | 85310 | 105043 | Permitted Site 1 | :: 54 | 2660 Harrison St | 5 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 2x4 | 6008902.0 | 2102968.0 | 37.754852144595795 | -122.41215320319701 | (37.7548521445958, -122.412153203197) | ||||
| 3639 | 3639 | 253517 | Permitted Site 1 | :: 54 | 559 24th Ave | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 09/15/2017 12:00:00 AM | 3 | 2x4.5 | 5988391.0 | 2112180.0 | 37.7789735494402 | -122.483760479148 | (37.7789735494402, -122.483760479148) | ||
| 95495 | 95495 | 104151 | Permitted Site 1 | :: 54 | 525X Church St | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | SFUSD 4 | DPW 4 | 2x58 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
| 81163 | 81163 | 104152 | Permitted Site 1 | :: 54 | 525X Church St | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | SFUSD 4 | DPW 4 | 2x68 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
| 85839 | 85839 | 105039 | Permitted Site 1 | :: 54 | 2660 Harrison St | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 2x7 | 6008868.4 | 2102978.1 | 37.7548779915591 | -122.412270115586 | (37.7548779915591, -122.412270115586) | ||||
| 122806 | 122806 | 105040 | Permitted Site 1 | :: 54 | 2660 Harrison St | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 2x7 | 6008868.4 | 2102978.1 | 37.7548779915591 | -122.412270115586 | (37.7548779915591, -122.412270115586) | ||||
| 83041 | 83041 | 109366 | Permitted Site 1 | :: 54 | 1205 Filbert St | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 3.125x22 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | |
| 4726 | 4726 | 253675 | Permitted Site 1 | :: 54 | 2975 Van Ness Ave | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 10/24/2017 12:00:00 AM | 3 | 3.2x14.2 | 6005536.30746 | 2120557.52588 | 37.8029592583559 | -122.42504415389 | (37.8029592583559, -122.42504415389) | ||
| 4723 | 4723 | 253676 | Permitted Site 1 | :: 54 | 2975 Van Ness Ave | 6 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 10/24/2017 12:00:00 AM | 3 | 3.2x3.75 | 6005536.30746 | 2120557.52588 | 37.8029592583559 | -122.42504415389 | (37.8029592583559, -122.42504415389) | ||
| 98437 | 98437 | 113995 | Permitted Site 1 | :: 54 | 3221 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 10/27/2015 12:00:00 AM | 39x3 | 5999265.7 | 2115942.6 | 37.789931692456996 | -122.44641142836599 | (37.789931692457, -122.446411428366) | |||
| 89307 | 89307 | 105925 | Permitted Site 1 | :: 54 | 4166 20th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | 6002608.6 | 2104160.0 | 37.7577699584222 | -122.434002709079 | (37.7577699584222, -122.434002709079) | |||||
| 125370 | 125370 | 3826 | DPW Maintained 3 | :: 54 | 120 Cashmere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/16/1992 12:00:00 AM | 3 | 3X3 | 6016868.5122165 | 2095917.6664165 | 37.7359371538987 | -122.384111573291 | (37.7359371538987, -122.384111573291) | ||
| 125788 | 125788 | 104827 | Permitted Site 1 | :: 54 | 4366 26th St | : Cutout 24 | Tree 1 | Private 1 | 3X3 | 6001535.3 | 2100615.2 | 37.7479758185871 | -122.437460780102 | (37.7479758185871, -122.437460780102) | |||||
| 116207 | 116207 | 109368 | Permitted Site 1 | :: 54 | 1205 Filbert St | 5 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 3x22 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | |
| 443 | 443 | 251293 | Undocumented 2 | :: 54 | 3789 Market St | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 3x3 | 6000208.0 | 2102740.0 | 37.753734455764 | -122.44220302061701 | (37.753734455764, -122.442203020617) | ||||
| 514 | 514 | 251312 | Undocumented 2 | :: 54 | 1499 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003369.0 | 2099547.0 | 37.7451468706327 | -122.431043696183 | (37.7451468706327, -122.431043696183) | ||||
| 518 | 518 | 251314 | Planning Code 138.1 required 4 | :: 54 | 1108 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001901.0 | 2100825.0 | 37.7485726639367 | -122.43621121860001 | (37.7485726639367, -122.4362112186) | ||||
| 533 | 533 | 251313 | Planning Code 138.1 required 4 | :: 54 | 390 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003369.0 | 2099547.0 | 37.7451468706327 | -122.431043696183 | (37.7451468706327, -122.431043696183) | ||||
| 631 | 631 | 251294 | Property Tree 7 | :: 54 | 7126 Geary Blvd | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 3x3 | 5984860.0 | 2112552.0 | 37.779788778901796 | -122.49600289252199 | (37.7797887789018, -122.496002892522) | ||||
| 667 | 667 | 251356 | Undocumented 2 | :: 54 | 519 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5989039.0 | 2111772.0 | 37.777890994652296 | -122.481488924787 | (37.7778909946523, -122.481488924787) | ||||
| 1824 | 1824 | 251724 | Permitted Site 1 | :: 54 | 1630 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2017 12:00:00 AM | 3 | 3x3 | 6006933.88533 | 2116748.92044 | 37.792580631742204 | -122.419937373279 | (37.7925806317422, -122.419937373279) | ||
| 1988 | 1988 | 252845 | DPW Maintained 3 | :: 54 | 544 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/2014 12:00:00 AM | 3x3 | 5993963.0 | 2110797.0 | 37.7754989773977 | -122.46438440768401 | (37.7754989773977, -122.464384407684) | |||
| 2865 | 2865 | 253261 | Permitted Site 1 | :: 54 | 339 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990256.0 | 2113097.0 | 37.78159976365421 | -122.477375802178 | (37.7815997636542, -122.477375802178) | ||||
| 2881 | 2881 | 253260 | Permitted Site 1 | :: 54 | 734 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993234.0 | 2110465.0 | 37.7745453462497 | -122.46688203122801 | (37.7745453462497, -122.466882031228) | ||||
| 2900 | 2900 | 70091 | Permitted Site 1 | :: 54 | 752 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/12/1992 12:00:00 AM | 6 | 3x3 | 5988512.5089 | 2110855.81451 | 37.7753447787774 | -122.483243045223 | (37.7753447787774, -122.483243045223) | |
| 3255 | 3255 | 253377 | Planning Code 138.1 required 4 | :: 54 | 2 Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001556.0 | 2108661.0 | 37.7700688079313 | -122.43796542225 | (37.7700688079313, -122.43796542225) | ||||
| 3275 | 3275 | 253378 | Planning Code 138.1 required 4 | :: 54 | 2 Alpine Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001556.0 | 2108661.0 | 37.7700688079313 | -122.43796542225 | (37.7700688079313, -122.43796542225) | ||||
| 3345 | 3345 | 253419 | Planning Code 138.1 required 4 | :: 54 | 3499 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997570.0 | 2115996.0 | 37.78998131889129 | -122.452282225129 | (37.7899813188913, -122.452282225129) | ||||
| 5050 | 5050 | 253762 | Planning Code 138.1 required 4 | :: 54 | 520 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993490.0 | 2111935.0 | 37.778596343165496 | -122.46610332918101 | (37.7785963431655, -122.466103329181) | ||||
| 5211 | 5211 | 253829 | Permitted Site 1 | :: 54 | 869 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6006713.1749 | 2113568.2957099997 | 37.7838349840749 | -122.420475171434 | (37.7838349840749, -122.420475171434) | |||
| 5216 | 5216 | 253831 | Permitted Site 1 | :: 54 | 651X Polk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | ||||||||
| 5222 | 5222 | 253825 | Permitted Site 1 | :: 54 | 725 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6007393.727109999 | 2113660.9435900003 | 37.784127700976896 | -122.418127279043 | (37.7841277009769, -122.418127279043) |
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");