Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qCaretaker, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▼ | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 78926 | 78926 | 112621 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 226x HESTER AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012667.0 | 2087636.0 | 37.712964194877294 | -122.398057164184 | (37.7129641948773, -122.398057164184) | ||||
| 29524 | 29524 | 108754 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 200x Hester Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6012760.63999 | 2087707.7823400002 | 37.7131665099896 | -122.397738543111 | (37.7131665099896, -122.397738543111) | |||
| 62932 | 62932 | 108753 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 200x Hester Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6012766.4768 | 2087726.3545799998 | 37.713217830719294 | -122.397719670851 | (37.7132178307193, -122.397719670851) | |||
| 161305 | 161305 | 114220 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 31 Lois Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6012353.592019999 | 2087846.1951099997 | 37.713523887993105 | -122.39915515788799 | (37.7135238879931, -122.399155157888) | |||
| 149495 | 149495 | 114219 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 31 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6012347.17965 | 2087849.72367 | 37.713533219358396 | -122.399177569 | (37.7135332193584, -122.399177569) | |||
| 182745 | 182745 | 114221 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 28 Lois Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6012377.24762 | 2087856.00195 | 37.7135521339029 | -122.39907408311599 | (37.7135521339029, -122.399074083116) | |||
| 131178 | 131178 | 66298 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2920 Hawes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/1990 12:00:00 AM | 6 | 3x3 | Permit Number 29409 | 6014606.2975 | 2089345.5816 | 37.7177661944335 | -122.391473700889 | (37.7177661944335, -122.391473700889) | |
| 59444 | 59444 | 80749 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 375 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52325 | 6004167.50654 | 2090267.3011900003 | 37.719712117607 | -122.42762157938101 | (37.719712117607, -122.427621579381) | |
| 80995 | 80995 | 81638 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 611 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52388 | 6011631.16657043 | 2091602.57917757 | 37.7237978701092 | -122.40191602971301 | (37.7237978701092, -122.401916029713) | ||
| 10378 | 10378 | 98180 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 622 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2011 12:00:00 AM | 3 | 3x3 | Permit Number 768099 | 6007169.16242 | 2091641.99398 | 37.7236560602499 | -122.417343266399 | (37.7236560602499, -122.417343266399) | |
| 67146 | 67146 | 105243 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 616 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2014 12:00:00 AM | 2 | 3x3 | Permit Number 770335 | 6007163.0512 | 2091665.3874599999 | 37.723719949895 | -122.417366048922 | (37.723719949895, -122.417366048922) | |
| 28685 | 28685 | 99380 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | |
| 89315 | 89315 | 99393 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 89862 | 89862 | 99399 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 108977 | 108977 | 99385 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 110341 | 110341 | 99386 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 112798 | 112798 | 99381 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 113044 | 113044 | 99398 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 114337 | 114337 | 99387 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 115661 | 115661 | 99395 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 142142 | 142142 | 99394 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | ||
| 148905 | 148905 | 99379 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1590 Yosemite Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/09/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768917 | 6014911.1 | 2092490.7 | 37.726418980855996 | -122.390639783135 | (37.726418980856, -122.390639783135) | |
| 147585 | 147585 | 31733 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2495 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 3 | 3x3 | Permit Number 35227 | 5990132.7438 | 2098427.0161 | 37.7413127725673 | -122.476730077237 | (37.7413127725673, -122.476730077237) |
| 113645 | 113645 | 97286 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 80 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 768450 | 5993053.0 | 2098535.0 | 37.7417782258334 | -122.466640790543 | (37.7417782258334, -122.466640790543) | |||
| 131574 | 131574 | 31728 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2460 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767614 | 5990177.7474 | 2098625.5077 | 37.7418603894955 | -122.476588969759 | (37.7418603894955, -122.476588969759) |
| 70774 | 70774 | 31727 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2460 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767614 | 5990175.918 | 2098661.7302 | 37.7419597410001 | -122.476597940821 | (37.7419597410001, -122.476597940821) |
| 3030 | 3030 | 224462 | Planning Code 138.1 required 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2810 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775960 | 6010311.37562 | 2101086.64633 | 37.7497653433983 | -122.40714655877301 | (37.7497653433983, -122.407146558773) | |
| 3035 | 3035 | 240686 | Planning Code 138.1 required 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2810 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/2017 12:00:00 AM | 3 | 3x3 | Permit Number 775960 | 6010325.27315 | 2101087.17666 | 37.749767577309605 | -122.40709853768499 | (37.7497675773096, -122.407098537685) | |
| 88071 | 88071 | 99759 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 4295x 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001974.5 | 2101167.2 | 37.7495164396885 | -122.43598153971399 | (37.7495164396885, -122.435981539714) | ||||
| 102309 | 102309 | 99758 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 4295x 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001974.5 | 2101167.2 | 37.7495164396885 | -122.43598153971399 | (37.7495164396885, -122.435981539714) | ||||
| 33248 | 33248 | 94086 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1727 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53469 | 5987161.9603 | 2103493.9012 | 37.7550523122054 | -122.48737396285101 | (37.7550523122054, -122.487373962851) | |
| 111793 | 111793 | 93854 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1109 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/2010 12:00:00 AM | 3x3 | Permit Number 53359 | 5990875.0 | 2103807.0 | 37.7561278331456 | -122.47455618324601 | (37.7561278331456, -122.474556183246) | ||
| 14017 | 14017 | 104025 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 716 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6012687.87968 | 2104149.7182 | 37.7583085835989 | -122.399143437016 | (37.7583085835989, -122.399143437016) | |||
| 62074 | 62074 | 94211 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 465 Missouri St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53589 | 6013546.79092 | 2104912.40006 | 37.760450569952205 | -122.39622637625799 | (37.7604505699522, -122.396226376258) | |
| 105851 | 105851 | 55533 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 20 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50807 | 6000967.89961965 | 2104951.08442142 | 37.759848834973795 | -122.439733631625 | (37.7598488349738, -122.439733631625) | ||
| 111896 | 111896 | 63101 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 18 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50807 | 6000981.26282803 | 2104951.87977531 | 37.759851779436495 | -122.439687471955 | (37.7598517794365, -122.439687471955) | ||
| 172150 | 172150 | 94214 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 465 Missouri St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53589 | 6013545.016969999 | 2104957.62874 | 37.7605746593094 | -122.396235681545 | (37.7605746593094, -122.396235681545) | |
| 91731 | 91731 | 83341 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 422-24 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50786 | 6002931.20131858 | 2105783.16408091 | 37.762245079378 | -122.433002986091 | (37.762245079378, -122.433002986091) | ||
| 68229 | 68229 | 101282 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2001 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 5989468.7375 | 2106475.7724 | 37.7633739839128 | -122.479614718585 | (37.7633739839128, -122.479614718585) | |||
| 66258 | 66258 | 101283 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2001 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5989499.782000001 | 2106476.1919 | 37.7633769390525 | -122.479507377657 | (37.7633769390525, -122.479507377657) | |||
| 47584 | 47584 | 97338 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1917 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5989797.6411 | 2106487.0994 | 37.763424185107496 | -122.478477988866 | (37.7634241851075, -122.478477988866) | |||
| 138266 | 138266 | 109806 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1264 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775061 | 5992117.2 | 2106823.9 | 37.764483341532 | -122.47047998805401 | (37.764483341532, -122.470479988054) |
| 93936 | 93936 | 32892 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1235 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/01/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778801 | 5993897.25914467 | 2107077.09548698 | 37.7652813146396 | -122.464341682773 | (37.7652813146396, -122.464341682773) |
| 82821 | 82821 | 102559 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1755X 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015173.7 | 2107354.9 | 37.767247536270204 | -122.390770296702 | (37.7672475362702, -122.390770296702) | ||||
| 106668 | 106668 | 102554 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1755X 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015173.7 | 2107354.9 | 37.767247536270204 | -122.390770296702 | (37.7672475362702, -122.390770296702) | ||||
| 121400 | 121400 | 102560 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1755X 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015173.7 | 2107354.9 | 37.767247536270204 | -122.390770296702 | (37.7672475362702, -122.390770296702) | ||||
| 127963 | 127963 | 102555 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1755X 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015173.7 | 2107354.9 | 37.767247536270204 | -122.390770296702 | (37.7672475362702, -122.390770296702) | ||||
| 128253 | 128253 | 102557 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1755X 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015173.7 | 2107354.9 | 37.767247536270204 | -122.390770296702 | (37.7672475362702, -122.390770296702) | ||||
| 144570 | 144570 | 102556 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1755X 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015173.7 | 2107354.9 | 37.767247536270204 | -122.390770296702 | (37.7672475362702, -122.390770296702) | ||||
| 145327 | 145327 | 102558 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1755X 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015173.7 | 2107354.9 | 37.767247536270204 | -122.390770296702 | (37.7672475362702, -122.390770296702) | ||||
| 87060 | 87060 | 102564 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1655X 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015154.2 | 2107704.9 | 37.768207477714896 | -122.39086220831899 | (37.7682074777149, -122.390862208319) | ||||
| 92389 | 92389 | 102561 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1655X 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015154.2 | 2107704.9 | 37.768207477714896 | -122.39086220831899 | (37.7682074777149, -122.390862208319) | ||||
| 101687 | 101687 | 102565 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1655X 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015154.2 | 2107704.9 | 37.768207477714896 | -122.39086220831899 | (37.7682074777149, -122.390862208319) | ||||
| 111006 | 111006 | 102566 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1655X 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015154.2 | 2107704.9 | 37.768207477714896 | -122.39086220831899 | (37.7682074777149, -122.390862208319) | ||||
| 120116 | 120116 | 102568 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1655X 04th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015154.2 | 2107704.9 | 37.768207477714896 | -122.39086220831899 | (37.7682074777149, -122.390862208319) | ||||
| 127314 | 127314 | 102562 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1655X 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015154.2 | 2107704.9 | 37.768207477714896 | -122.39086220831899 | (37.7682074777149, -122.390862208319) | ||||
| 127598 | 127598 | 102563 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1655X 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015154.2 | 2107704.9 | 37.768207477714896 | -122.39086220831899 | (37.7682074777149, -122.390862208319) | ||||
| 144534 | 144534 | 102567 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1655X 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2013 12:00:00 AM | 3x3 | Permit Number 769962 | 6015154.2 | 2107704.9 | 37.768207477714896 | -122.39086220831899 | (37.7682074777149, -122.390862208319) | ||
| 117450 | 117450 | 108296 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 55x DIVISION ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011511.3 | 2108309.6 | 37.769665045717296 | -122.40350525397 | (37.7696650457173, -122.40350525397) | ||||
| 119383 | 119383 | 108297 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 55x DIVISION ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011511.3 | 2108309.6 | 37.769665045717296 | -122.40350525397 | (37.7696650457173, -122.40350525397) | ||||
| 125957 | 125957 | 108295 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 55x DIVISION ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011511.3 | 2108309.6 | 37.769665045717296 | -122.40350525397 | (37.7696650457173, -122.40350525397) | ||||
| 128972 | 128972 | 108294 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 55x DIVISION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6011511.3 | 2108309.6 | 37.769665045717296 | -122.40350525397 | (37.7696650457173, -122.40350525397) | |||
| 83665 | 83665 | 89055 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 788 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990404.298780001 | 2110035.18225 | 37.773201459979404 | -122.476639007633 | (37.7732014599794, -122.476639007633) | ||
| 101833 | 101833 | 89054 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 788 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990404.14743 | 2110052.29751 | 37.773248445022 | -122.476640781805 | (37.773248445022, -122.476640781805) | ||
| 86108 | 86108 | 89056 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 774 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990401.329059999 | 2110113.1437 | 37.7734153485371 | -122.476654976983 | (37.7734153485371, -122.476654976983) | ||
| 88935 | 88935 | 89118 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 767 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990353.59701 | 2110151.97769 | 37.7735192073496 | -122.47682292511001 | (37.7735192073496, -122.47682292511) | ||
| 103093 | 103093 | 89057 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 768 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990399.549819999 | 2110162.4742900003 | 37.773550693633 | -122.47666473627899 | (37.773550693633, -122.476664736279) | ||
| 113266 | 113266 | 89058 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 746 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990395.0930699995 | 2110255.0249900003 | 37.7738045540059 | -122.47668691568899 | (37.7738045540059, -122.476686915689) | ||
| 111180 | 111180 | 89059 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 746 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990397.15719 | 2110267.75159 | 37.7738396174891 | -122.476680705622 | (37.7738396174891, -122.476680705622) | ||
| 145001 | 145001 | 89060 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 744 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990392.548057 | 2110303.8535700003 | 37.7739384762903 | -122.476699287319 | (37.7739384762903, -122.476699287319) | ||
| 84911 | 84911 | 89061 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 740 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990394.60611 | 2110329.10213 | 37.7740079212926 | -122.476694013266 | (37.7740079212926, -122.476694013266) | ||
| 83557 | 83557 | 89117 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 727 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5990344.4993 | 2110412.80162 | 37.774234830642705 | -122.476873456227 | (37.7742348306427, -122.476873456227) | ||
| 16738 | 16738 | 28934 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 260 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/11/2006 12:00:00 AM | 3 | 3x3 | 6009412.25627 | 2110486.9627400003 | 37.775526107775704 | -122.41091961406299 | (37.7755261077757, -122.410919614063) | ||
| 103146 | 103146 | 89063 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 710 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990388.49369 | 2110501.1170799998 | 37.774479872644 | -122.476727727029 | (37.774479872644, -122.476727727029) | ||
| 179336 | 179336 | 82943 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 230 08th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52427 | 6009392.50715 | 2110510.5860099997 | 37.7755898643032 | -122.410989600209 | (37.7755898643032, -122.410989600209) | |
| 118487 | 118487 | 89064 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 706 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990387.44621 | 2110524.3809 | 37.7745436879542 | -122.476733050457 | (37.7745436879542, -122.476733050457) | ||
| 156592 | 156592 | 82944 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 230 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52427 | 6009357.52887 | 2110544.0816099998 | 37.775679873857605 | -122.4111129656 | (37.7756798738576, -122.4111129656) | |
| 92694 | 92694 | 89112 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 691 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990332.54501 | 2110711.2620900003 | 37.7750536277141 | -122.476936620369 | (37.7750536277141, -122.476936620369) | ||
| 106267 | 106267 | 89111 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 691 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990331.56334 | 2110745.46757 | 37.775147489618504 | -122.47694251603501 | (37.7751474896185, -122.476942516035) | ||
| 91083 | 91083 | 89110 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 675 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990329.58522 | 2110790.11902 | 37.7752699754793 | -122.476952622071 | (37.7752699754793, -122.476952622071) | ||
| 24787 | 24787 | 56080 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 723 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/2011 12:00:00 AM | 2 | 3x3 | Permit Number 51743 | 5981333.03596 | 2110794.79787 | 37.774756814986794 | -122.50807353876199 | (37.7747568149868, -122.508073538762) | |
| 116465 | 116465 | 89109 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 667 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2008 12:00:00 AM | 3 | 3x3 | 5990327.355930001 | 2110845.92809 | 37.775423082523396 | -122.47696441245 | (37.7754230825234, -122.47696441245) | ||
| 119685 | 119685 | 89108 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 663 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990326.43317 | 2110871.40415 | 37.775492979250295 | -122.47696946639999 | (37.7754929792503, -122.4769694664) | ||
| 83916 | 83916 | 89107 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 659 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990326.6354 | 2110892.4923 | 37.775550893244294 | -122.47697030809401 | (37.7755508932443, -122.476970308094) | ||
| 108240 | 108240 | 89065 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 664 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990373.51835 | 2110921.31055 | 37.775632739883704 | -122.476810236402 | (37.7756327398837, -122.476810236402) | ||
| 120824 | 120824 | 89066 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 656 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990372.2384 | 2110982.1220400003 | 37.7757996372707 | -122.476819108153 | (37.7757996372707, -122.476819108153) | ||
| 143981 | 143981 | 116237 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 639 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5990321.779490001 | 2111019.87703 | 37.775900374977 | -122.47699641585 | (37.775900374977, -122.47699641585) | |||
| 108932 | 108932 | 89105 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 635 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990321.35395 | 2111045.8273 | 37.775971602591795 | -122.476999784527 | (37.7759716025918, -122.476999784527) | ||
| 119909 | 119909 | 89067 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 630 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5990364.470407 | 2111075.081065 | 37.776054426582704 | -122.47685277294902 | (37.7760544265827, -122.476852772949) | ||
| 138922 | 138922 | 89104 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 627 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990323.547333 | 2111099.7078 | 37.77611967086071 | -122.476996135109 | (37.7761196708607, -122.476996135109) | ||
| 105058 | 105058 | 89068 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 622 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/20/2008 12:00:00 AM | 3 | 3x3 | 5990367.60069 | 2111102.5118400003 | 37.7761299255256 | -122.476843949277 | (37.7761299255256, -122.476843949277) | ||
| 126204 | 126204 | 89103 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 625 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990317.85123 | 2111122.02756 | 37.7761806243316 | -122.47701747056101 | (37.7761806243316, -122.477017470561) | ||
| 128398 | 128398 | 89069 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 622 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/20/2008 12:00:00 AM | 3 | 3x3 | 5990366.5532599995 | 2111125.77489 | 37.7761937387005 | -122.476849272694 | (37.7761937387005, -122.476849272694) | ||
| 121968 | 121968 | 89102 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 621 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5990317.40522 | 2111147.00842 | 37.7762491890218 | -122.477020839229 | (37.7762491890218, -122.477020839229) | ||
| 103217 | 103217 | 89101 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 617 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990317.59695 | 2111167.61171 | 37.7763057711064 | -122.477021681856 | (37.7763057711064, -122.477021681856) | ||
| 109677 | 109677 | 89070 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 610 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 2 | 3x3 | 5990363.96165 | 2111197.3405 | 37.776390087833796 | -122.476863467892 | (37.7763900878338, -122.476863467892) | ||
| 114490 | 114490 | 89100 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 601X 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990315.52162 | 2111207.6584 | 37.7764156078929 | -122.47703178789499 | (37.7764156078929, -122.477031787895) | ||
| 81167 | 81167 | 89071 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 606 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990364.94891 | 2111219.79426 | 37.776451796946795 | -122.476861693703 | (37.7764517969468, -122.476861693703) | ||
| 118373 | 118373 | 89099 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 583 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990307.45252 | 2111413.41703 | 37.776980096273 | -122.477074739943 | (37.776980096273, -122.477074739943) | ||
| 79152 | 79152 | 89072 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 578 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990352.95655 | 2111441.21881 | 37.7770590720957 | -122.47691936106001 | (37.7770590720957, -122.47691936106) |
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");