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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189123 | 189123 | 84613 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2029-22031 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50833 | 6000517.3597800005 | 2120966.99196 | 37.8037987541811 | -122.442441679147 | (37.8037987541811, -122.442441679147) | |
| 184974 | 184974 | 42710 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1600 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/2010 12:00:00 AM | 10 | 3x3 | Permit Number 53744 | 6005271.11771 | 2118900.89126 | 37.7983955805457 | -122.42584385893 | (37.7983955805457, -122.42584385893) |
| 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) | |||
| 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) | |
| 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) | |
| 170548 | 170548 | 103458 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 212 Presidio Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769919 | 5999039.39992 | 2115859.35215 | 37.789690188098504 | -122.447188409728 | (37.7896901880985, -122.447188409728) | |
| 167301 | 167301 | 35008 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1652 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50542 | 5999619.6658 | 2114602.5127 | 37.7862723736076 | -122.445090361129 | (37.7862723736076, -122.445090361129) | |
| 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) | |||
| 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) | |
| 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) | |||
| 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) |
| 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) | ||||
| 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) | ||
| 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) | ||||
| 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) | ||
| 144383 | 144383 | 89434 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2750X Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5990083.37165 | 2111991.81654 | 37.7785552188238 | -122.47789218978001 | (37.7785552188238, -122.47789218978) | ||
| 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) | |||
| 142878 | 142878 | 89076 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 550 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990345.59029 | 2111614.5302 | 37.777534510056704 | -122.476957509799 | (37.7775345100567, -122.476957509799) | ||
| 142751 | 142751 | 89422 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2400X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5991198.491359999 | 2112030.01361 | 37.7787247544447 | -122.474037391358 | (37.7787247544447, -122.474037391358) | ||
| 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) | ||
| 141554 | 141554 | 89689 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2405 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/08/2008 12:00:00 AM | 3 | 3x3 | 5991196.08416 | 2111975.00544 | 37.7785735776786 | -122.47404170417101 | (37.7785735776786, -122.474041704171) | ||
| 140359 | 140359 | 89421 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2300 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5991477.6623 | 2112038.61858 | 37.778764548514 | -122.47307226747 | (37.778764548514, -122.47307226747) | ||
| 140061 | 140061 | 89688 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2405 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/08/2008 12:00:00 AM | 3 | 3x3 | 5991173.67465 | 2111973.9047 | 37.7785692572369 | -122.474119146124 | (37.7785692572369, -122.474119146124) | ||
| 139838 | 139838 | 89690 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2351 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5991335.21973 | 2111978.62727 | 37.7785915807726 | -122.473560650038 | (37.7785915807726, -122.473560650038) | ||
| 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) | ||
| 138916 | 138916 | 89082 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 466 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990324.88294 | 2112207.2474 | 37.7791607464072 | -122.477072465426 | (37.7791607464072, -122.477072465426) | ||
| 138679 | 138679 | 89683 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2439X Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/08/2008 12:00:00 AM | 3 | 3x3 | 5991013.77238 | 2111967.7388400002 | 37.778543063369604 | -122.474671853461 | (37.7785430633696, -122.474671853461) | ||
| 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) |
| 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) |
| 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) | |
| 130376 | 130376 | 84614 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2034 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50834 | 6000478.89565 | 2121006.72285 | 37.8039056520943 | -122.442577640443 | (37.8039056520943, -122.442577640443) | |
| 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) | |||
| 128881 | 128881 | 89090 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 411 18th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990267.41171 | 2112525.37211 | 37.780030894366895 | -122.477294535249 | (37.7800308943669, -122.477294535249) | ||
| 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) | ||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 127523 | 127523 | 89427 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2550 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5990691.39312 | 2112012.68258 | 37.7786477812116 | -122.47579035750799 | (37.7786477812116, -122.475790357508) | ||
| 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) | ||||
| 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) | ||
| 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) | ||||
| 125089 | 125089 | 89673 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2605 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5990503.983109999 | 2111947.71017 | 37.77845851765821 | -122.476433926742 | (37.7784585176582, -122.476433926742) | ||
| 124122 | 124122 | 89664 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2801X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5989889.68723 | 2111928.16653 | 37.77836921045999 | -122.478557554871 | (37.77836921046, -122.478557554871) | ||
| 122678 | 122678 | 89089 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 409 18th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990266.49746 | 2112545.35592 | 37.78008571132089 | -122.477299158886 | (37.7800857113209, -122.477299158886) | ||
| 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) | ||
| 121725 | 121725 | 89425 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2444 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5990997.351480001 | 2112022.54755 | 37.7786926015029 | -122.474732660414 | (37.7786926015029, -122.474732660414) | ||
| 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) | ||||
| 121223 | 121223 | 89083 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 434 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990318.24185 | 2112394.83116 | 37.779675414185704 | -122.477109150816 | (37.7796754141857, -122.477109150816) | ||
| 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) | ||
| 120780 | 120780 | 89668 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2701 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5990200.3423 | 2111939.7439900003 | 37.778419030136 | -122.477483741104 | (37.778419030136, -122.477483741104) | ||
| 120732 | 120732 | 89098 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 567 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990305.127830001 | 2111522.32055 | 37.7772789804391 | -122.477090741641 | (37.7772789804391, -122.477090741641) | ||
| 120563 | 120563 | 34888 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 252 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774542 | 5990895.02345 | 2113704.92636 | 37.7833060185493 | -122.475209503253 | (37.7833060185493, -122.475209503253) | |
| 120327 | 120327 | 89424 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2444 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5991014.1073900005 | 2112022.9035099996 | 37.778694549794295 | -122.47467472179501 | (37.7786945497943, -122.474674721795) | ||
| 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) | ||||
| 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) | ||
| 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) | ||
| 119426 | 119426 | 89657 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2901X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/2008 12:00:00 AM | 3 | 3x3 | 5989634.1250599995 | 2111919.8960599997 | 37.778331661255606 | -122.47944102458 | (37.7783316612556, -122.47944102458) | ||
| 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) | ||||
| 119218 | 119218 | 89092 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 483 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/20/2008 12:00:00 AM | 3 | 3x3 | 5990282.36221 | 2112092.5227900003 | 37.778843277465796 | -122.477211174284 | (37.7788432774658, -122.477211174284) | ||
| 118595 | 118595 | 104724 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2747 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 770749 | 5999893.3 | 2117731.9 | 37.794880464642894 | -122.44436863671899 | (37.7948804646429, -122.444368636719) | |||
| 118581 | 118581 | 89074 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 568 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990349.6336900005 | 2111514.5867 | 37.777260327334 | -122.47693621793199 | (37.777260327334, -122.476936217932) | ||
| 118494 | 118494 | 89078 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 526 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990340.85231 | 2111766.5874799998 | 37.7779517425204 | -122.47698501352501 | (37.7779517425204, -122.476985013525) | ||
| 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) | ||
| 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) | ||
| 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) | ||||
| 116787 | 116787 | 89682 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2439X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/08/2008 12:00:00 AM | 3 | 3x3 | 5990978.9280199995 | 2111966.0770799997 | 37.7785364815441 | -122.474792270832 | (37.7785364815441, -122.474792270832) | ||
| 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) | ||
| 116257 | 116257 | 89423 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2400 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5991174.61875 | 2112030.16247 | 37.778723780309996 | -122.474119986052 | (37.77872378031, -122.474119986052) | ||
| 116013 | 116013 | 89430 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2626 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5990477.756159999 | 2112004.06486 | 37.778611730986206 | -122.476528772678 | (37.7786117309862, -122.476528772678) | ||
| 115691 | 115691 | 89075 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 554 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990347.66295 | 2111591.2456400003 | 37.777470697316 | -122.476948638049 | (37.777470697316, -122.476948638049) | ||
| 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) | ||
| 115246 | 115246 | 89686 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2435 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5991074.90155 | 2111969.0301099997 | 37.7785501507324 | -122.474460480761 | (37.7785501507324, -122.474460480761) | ||
| 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) | ||
| 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) | ||
| 113805 | 113805 | 89087 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 401 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990264.81657 | 2112592.30835 | 37.780214532141706 | -122.477308406147 | (37.7802145321417, -122.477308406147) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||||
| 110944 | 110944 | 89687 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2405 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5991137.52605 | 2111970.73345 | 37.778558455774295 | -122.474243965231 | (37.7785584557743, -122.474243965231) | ||
| 110683 | 110683 | 89091 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 467 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990279.30017 | 2112189.56022 | 37.7791095377355 | -122.4772288603 | (37.7791095377355, -122.4772288603) | ||
| 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) | ||
| 109705 | 109705 | 102257 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1933 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2013 12:00:00 AM | 2 | 3x3 | Permit Number 58594 | 6000840.6 | 2115080.7 | 37.787654962994104 | -122.440900572101 | (37.7876549629941, -122.440900572101) | |
| 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) | ||
| 109044 | 109044 | 89081 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 482 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/20/2008 12:00:00 AM | 3 | 3x3 | 5990329.59035 | 2112107.51338 | 37.778887177480705 | -122.477048890931 | (37.7788871774807, -122.477048890931) | ||
| 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) | ||
| 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) | ||
| 108532 | 108532 | 89077 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 546 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2008 12:00:00 AM | 3 | 3x3 | 5990343.546375 | 2111649.81696 | 37.777631279192796 | -122.47696715934299 | (37.7776312791928, -122.476967159343) | ||
| 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) | ||
| 107613 | 107613 | 89669 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2701 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/29/2008 12:00:00 AM | 3 | 3x3 | 5990256.0353 | 2111940.3234 | 37.7784238525584 | -122.477291122539 | (37.7784238525584, -122.477291122539) | ||
| 107023 | 107023 | 89094 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 543 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/20/2008 12:00:00 AM | 3 | 3x3 | 5990300.0620099995 | 2111662.7982900003 | 37.777664399650604 | -122.477118533728 | (37.7776643996506, -122.477118533728) | ||
| 106957 | 106957 | 89684 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2439X Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/08/2008 12:00:00 AM | 3 | 3x3 | 5991029.88573 | 2111967.95192 | 37.778544582090504 | -122.47461612736299 | (37.7785445820905, -122.474616127363) | ||
| 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) | ||||
| 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) | ||
| 106037 | 106037 | 89088 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 401 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2008 12:00:00 AM | 3 | 3x3 | 5990265.0064900005 | 2112569.67776 | 37.780152405839 | -122.477306094769 | (37.780152405839, -122.477306094769) |
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");