Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▲ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15073 | 15073 | 86684 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 855 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778066 | 6011500.82378 | 2110252.42097 | 37.7749990025284 | -122.403678209983 | (37.7749990025284, -122.403678209983) | |
| 350 | 350 | 85805 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 210X Shipley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011627.0 | 2111882.0 | 37.77948049775679 | -122.40335640121799 | (37.7794804977568, -122.403356401218) | |
| 351 | 351 | 251213 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 210X Shipley St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011604.0 | 2111950.0 | 37.779665925350706 | -122.40344075372101 | (37.7796659253507, -122.403440753721) | |
| 365 | 365 | 251211 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 210X Shipley St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011604.0 | 2111950.0 | 37.779665925350706 | -122.40344075372101 | (37.7796659253507, -122.403440753721) | |
| 384 | 384 | 85806 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 210X Shipley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011627.0 | 2111882.0 | 37.77948049775679 | -122.40335640121799 | (37.7794804977568, -122.403356401218) | |
| 387 | 387 | 85807 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 210X Shipley St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011604.0 | 2111950.0 | 37.779665925350706 | -122.40344075372101 | (37.7796659253507, -122.403440753721) | |
| 396 | 396 | 251212 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 210X Shipley St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | 2.5x6 | Permit Number 778048 | 6011604.0 | 2111950.0 | 37.779665925350706 | -122.40344075372101 | (37.7796659253507, -122.403440753721) | |
| 83228 | 83228 | 116467 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777920 | 5993792.2 | 2102201.1 | 37.751887038112 | -122.46435101080601 | (37.751887038112, -122.464351010806) | |
| 85504 | 85504 | 116466 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777920 | 5993792.2 | 2102201.1 | 37.751887038112 | -122.46435101080601 | (37.751887038112, -122.464351010806) | |
| 88800 | 88800 | 116464 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777920 | 5993792.2 | 2102201.1 | 37.751887038112 | -122.46435101080601 | (37.751887038112, -122.464351010806) | |
| 99224 | 99224 | 116470 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777920 | 5993792.2 | 2102201.1 | 37.751887038112 | -122.46435101080601 | (37.751887038112, -122.464351010806) | |
| 101818 | 101818 | 116469 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777920 | 5993792.2 | 2102201.1 | 37.751887038112 | -122.46435101080601 | (37.751887038112, -122.464351010806) | |
| 105171 | 105171 | 116465 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777920 | 5993792.2 | 2102201.1 | 37.751887038112 | -122.46435101080601 | (37.751887038112, -122.464351010806) | |
| 129159 | 129159 | 116468 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777920 | 5993792.2 | 2102201.1 | 37.751887038112 | -122.46435101080601 | (37.751887038112, -122.464351010806) | |
| 117245 | 117245 | 116958 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 10x Yerba Buena Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/2016 12:00:00 AM | 3 | Permit Number 777762 | 5993642.277480001 | 2097056.1949900002 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | ||
| 15765 | 15765 | 116155 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 167X Jessie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777681 | 6011953.87529 | 2114523.8963900004 | 37.7867527801633 | -122.402411408766 | (37.7867527801633, -122.402411408766) | |
| 20896 | 20896 | 523 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2813 24th St | 1 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 07/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777511 | 6009929.7366 | 2102188.669 | 37.752769888235704 | -122.408544016423 | (37.7527698882357, -122.408544016423) | |
| 105346 | 105346 | 115752 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 100 Yerba Buena Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776558 | 5994139.5 | 2096643.4 | 37.7366470041966 | -122.462746867769 | (37.7366470041966, -122.462746867769) | ||
| 143813 | 143813 | 115751 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 100 Yerba Buena Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/2016 12:00:00 AM | 3 | Permit Number 776558 | 5994139.5 | 2096643.4 | 37.7366470041966 | -122.462746867769 | (37.7366470041966, -122.462746867769) | ||
| 92394 | 92394 | 115737 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 9x Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776557 | 5993642.277480001 | 2097056.1949900002 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | ||
| 103313 | 103313 | 115731 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 15 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776556 | 5993468.8 | 2097225.0 | 37.7382052810266 | -122.465107977902 | (37.7382052810266, -122.465107977902) | ||
| 139076 | 139076 | 115734 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 55 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 776555 | 5993732.7 | 2097034.0 | 37.7376960566374 | -122.464181687663 | (37.7376960566374, -122.464181687663) | ||||
| 146206 | 146206 | 115735 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 57 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776554 | 5993777.6 | 2097002.8 | 37.737612976998896 | -122.464024183823 | (37.7376129769989, -122.464024183823) | ||
| 144044 | 144044 | 115738 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 95x Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776553 | 5993642.277480001 | 2097056.1949900002 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | ||
| 138380 | 138380 | 115753 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 135x Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776552 | 5994185.89401 | 2096656.23912 | 37.7366849291808 | -122.46258739592 | (37.7366849291808, -122.46258739592) | ||
| 83319 | 83319 | 115736 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 66 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776551 | 5993801.4 | 2096894.7 | 37.7373175329251 | -122.463934052027 | (37.7373175329251, -122.463934052027) | ||
| 112912 | 112912 | 115733 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 50 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776548 | 5993693.2 | 2096969.0 | 37.7375153061033 | -122.46431353926701 | (37.7375153061033, -122.464313539267) | ||
| 115585 | 115585 | 112290 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 34 YERBA BUENA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776546 | 5993584.0 | 2097045.0 | 37.7377176881769 | -122.464696609393 | (37.7377176881769, -122.464696609393) | |
| 85039 | 85039 | 115729 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 10x Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Permit Number 776540 | 5993642.277480001 | 2097056.1949900002 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | |||
| 86745 | 86745 | 115730 | Significant Tree 6 | Acer rubrum :: Red Maple 6 | 10x Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 776540 | 5993642.277480001 | 2097056.1949900002 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | ||
| 6538 | 6538 | 71898 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 455 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2015 12:00:00 AM | 3 | Permit Number 775644 | 6007926.40343 | 2114015.89838 | 37.7851322881578 | -122.416309554165 | (37.7851322881578, -122.416309554165) | |
| 20380 | 20380 | 112084 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 99X Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2015 12:00:00 AM | Permit Number 775592 | 6013631.8 | 2115864.7 | 37.790527840543795 | -122.396700174955 | (37.7905278405438, -122.396700174955) | |||
| 104211 | 104211 | 112085 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 99X Fremont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2015 12:00:00 AM | Permit Number 775592 | 6013631.8 | 2115864.7 | 37.790527840543795 | -122.396700174955 | (37.7905278405438, -122.396700174955) | |||
| 13744 | 13744 | 115348 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 399 Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014915.48611 | 2114547.7853200003 | 37.7869832575075 | -122.39216652446001 | (37.7869832575075, -122.39216652446) | |
| 13813 | 13813 | 115356 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 399 Fremont St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014763.69701 | 2114705.74438 | 37.7874085478076 | -122.39270273893801 | (37.7874085478076, -122.392702738938) | |
| 13917 | 13917 | 115353 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 399 Fremont St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014819.91687 | 2114646.3157900004 | 37.787248492781295 | -122.39250406973 | (37.7872484927813, -122.39250406973) | |
| 14382 | 14382 | 115352 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 399 Fremont St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014845.33617 | 2114621.37484 | 37.7871814222392 | -122.392414378515 | (37.7871814222392, -122.392414378515) | |
| 14429 | 14429 | 115355 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 399 Fremont St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014786.34664 | 2114681.69198 | 37.7873437633547 | -122.392622692086 | (37.7873437633547, -122.392622692086) | |
| 15102 | 15102 | 115350 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 399 Fremont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014880.23802 | 2114582.9179 | 37.7870777663613 | -122.39229093398599 | (37.7870777663613, -122.392290933986) | |
| 15478 | 15478 | 115354 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 399 Fremont St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014804.627730001 | 2114662.16926 | 37.7872911737029 | -122.39255807669 | (37.7872911737029, -122.39255807669) | |
| 16266 | 16266 | 115349 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 399 Fremont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014896.08459 | 2114567.05321 | 37.787035085459706 | -122.392234997951 | (37.7870350854597, -122.392234997951) | |
| 16337 | 16337 | 115351 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 399 Fremont St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/28/2016 12:00:00 AM | 3 | 4x10 | Permit Number 773314 | 6014858.418740001 | 2114606.67601 | 37.7871417890985 | -122.39236808681801 | (37.7871417890985, -122.392368086818) | |
| 79061 | 79061 | 88150 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300X Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 770961 | 6012270.0 | 2112782.0 | 37.7819875812332 | -122.401195237476 | (37.7819875812332, -122.401195237476) | ||
| 96690 | 96690 | 88153 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300X Clementina St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 770961 | 6012270.0 | 2112782.0 | 37.7819875812332 | -122.401195237476 | (37.7819875812332, -122.401195237476) | ||
| 108943 | 108943 | 88154 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300X Clementina St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 770961 | 6012270.0 | 2112782.0 | 37.7819875812332 | -122.401195237476 | (37.7819875812332, -122.401195237476) | ||
| 127997 | 127997 | 88152 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300X Clementina St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 770961 | 6012270.0 | 2112782.0 | 37.7819875812332 | -122.401195237476 | (37.7819875812332, -122.401195237476) | ||
| 143879 | 143879 | 88151 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 300X Clementina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 770961 | 6012270.0 | 2112782.0 | 37.7819875812332 | -122.401195237476 | (37.7819875812332, -122.401195237476) | ||
| 56267 | 56267 | 104201 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3135 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/30/2015 12:00:00 AM | 1 | 3x3 | Permit Number 770708 | 6008143.9 | 2102068.3 | 37.7523392058798 | -122.41471126484 | (37.7523392058798, -122.41471126484) | |
| 113409 | 113409 | 104203 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3135 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/30/2015 12:00:00 AM | 2 | 3x3 | Permit Number 770708 | 6008143.9 | 2102068.3 | 37.7523392058798 | -122.41471126484 | (37.7523392058798, -122.41471126484) | |
| 122330 | 122330 | 104202 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3135 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/30/2015 12:00:00 AM | 2 | 3x3 | Permit Number 770708 | 6008143.9 | 2102068.3 | 37.7523392058798 | -122.41471126484 | (37.7523392058798, -122.41471126484) | |
| 14670 | 14670 | 108060 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 333 Fremont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2014 12:00:00 AM | 3 | Permit Number 770030 | 6014722.47105 | 2114748.4926400003 | 37.7875236349662 | -122.39284836525299 | (37.7875236349662, -122.392848365253) | ||
| 16307 | 16307 | 108061 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 333 Fremont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2014 12:00:00 AM | 3 | Permit Number 770030 | 6014711.31667 | 2114762.0418700003 | 37.7875602184789 | -122.392887905777 | (37.7875602184789, -122.392887905777) | ||
| 16382 | 16382 | 108062 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 333 Fremont St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2014 12:00:00 AM | 3 | Permit Number 770030 | 6014690.02107 | 2114784.12371 | 37.787619667256706 | -122.392963130455 | (37.7876196672567, -122.392963130455) | ||
| 72529 | 72529 | 56057 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2857 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/28/2012 12:00:00 AM | Permit Number 769384 | 6009126.12851397 | 2103311.62297626 | 37.7558082292146 | -122.41140237591999 | (37.7558082292146, -122.41140237592) | |||
| 83002 | 83002 | 100776 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 450 Hayes St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/2012 12:00:00 AM | 3x4 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | ||
| 84055 | 84055 | 100778 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 450 Hayes St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/2012 12:00:00 AM | 3x4 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | ||
| 96231 | 96231 | 100775 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 450 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/2012 12:00:00 AM | 3x4 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | ||
| 101129 | 101129 | 100774 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 450 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/2012 12:00:00 AM | 3x4 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | ||
| 101153 | 101153 | 100779 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 450 Hayes St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/2012 12:00:00 AM | 3x4 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | ||
| 108969 | 108969 | 100773 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 450 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/2012 12:00:00 AM | 3x4 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | ||
| 117985 | 117985 | 100777 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 450 Hayes St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/2012 12:00:00 AM | 4x3 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | ||
| 99429 | 99429 | 6293 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1700X Ellis St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/28/2013 12:00:00 AM | 24 | 5x7 | Permit Number 768629 | 6002728.2699376 | 2113059.4201816004 | 37.7822123689276 | -122.43422505132601 | (37.7822123689276, -122.434225051326) | |
| 99469 | 99469 | 102507 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1700X Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/28/2013 12:00:00 AM | 4x3 | Permit Number 768629 | 6002473.3 | 2113331.2 | 37.782944132882 | -122.43512657661199 | (37.782944132882, -122.435126576612) | ||
| 104497 | 104497 | 102508 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1700X Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/28/2013 12:00:00 AM | 4x3 | Permit Number 768629 | 6002473.3 | 2113331.2 | 37.782944132882 | -122.43512657661199 | (37.782944132882, -122.435126576612) | ||
| 123177 | 123177 | 6288 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1700X Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/28/2013 12:00:00 AM | 4x3 | Permit Number 768629 | 6002728.2699376 | 2113059.4201816004 | 37.7822123689276 | -122.43422505132601 | (37.7822123689276, -122.434225051326) | ||
| 90357 | 90357 | 96783 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 219 Prentiss St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2011 12:00:00 AM | Permit Number 767237 | 6008840.4 | 2097503.1 | 37.7398432859238 | -122.411980061754 | (37.7398432859238, -122.411980061754) | |||
| 93788 | 93788 | 96781 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 219 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2011 12:00:00 AM | Permit Number 767237 | 6008840.4 | 2097503.1 | 37.7398432859238 | -122.411980061754 | (37.7398432859238, -122.411980061754) | |||
| 106147 | 106147 | 96782 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 219 Prentiss St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2011 12:00:00 AM | Permit Number 767237 | 6008840.4 | 2097503.1 | 37.7398432859238 | -122.411980061754 | (37.7398432859238, -122.411980061754) | |||
| 41167 | 41167 | 53357 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 333 Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/1969 12:00:00 AM | 3 | Permit Number 6250 | 6014738.317419999 | 2114732.62752 | 37.7874809531407 | -122.392792429224 | (37.7874809531407, -122.392792429224) | ||
| 33913 | 33913 | 96284 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3237 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/2011 12:00:00 AM | 1 | 2x2 | Permit Number 58767 | 6011926.62111 | 2090638.16357 | 37.7211662664813 | -122.400826962515 | (37.7211662664813, -122.400826962515) | |
| 72048 | 72048 | 96285 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3237 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/2011 12:00:00 AM | 1 | 2x2 | Permit Number 58767 | 6011917.425009999 | 2090666.70864 | 37.721244132491606 | -122.40086075544501 | (37.7212441324916, -122.400860755445) | |
| 188625 | 188625 | 96283 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3229 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/2011 12:00:00 AM | 1 | 2x2 | Permit Number 58766 | 6011911.44714 | 2090686.2999099998 | 37.721297592691 | -122.40088279510599 | (37.721297592691, -122.400882795106) | |
| 76923 | 76923 | 96282 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 3219 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/2011 12:00:00 AM | 1 | 2x2 | Permit Number 58765 | 6011894.72872 | 2090742.0865599997 | 37.7214498389136 | -122.400944503905 | (37.7214498389136, -122.400944503905) | |
| 100125 | 100125 | 94790 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1985 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/2010 12:00:00 AM | Permit Number 53888 | 5993755.4 | 2101986.9 | 37.751296778417 | -122.464462718314 | (37.751296778417, -122.464462718314) | |||
| 103876 | 103876 | 94416 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 5800 03rd St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
| 119759 | 119759 | 94415 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 5800 03rd St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
| 55303 | 55303 | 50676 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 320 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2009 12:00:00 AM | 2 | 3x3 | Permit Number 53102 | 6011983.41914 | 2112836.30852 | 37.7821207077455 | -122.402190501114 | (37.7821207077455, -122.402190501114) | |
| 106998 | 106998 | 92755 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 124823 | 124823 | 92756 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 140658 | 140658 | 92758 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 144843 | 144843 | 92757 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 528 Carter St | Front Yard : Yard 7 | Tree 1 | Private 1 | 10/09/2009 12:00:00 AM | Permit Number 52985 | 6005271.9 | 2086340.9 | 37.708993467942 | -122.423525081608 | (37.708993467942, -122.423525081608) | ||||
| 74041 | 74041 | 82635 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1363 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52502 | 6016495.7737 | 2093658.9613 | 37.7297145851124 | -122.385242953388 | (37.7297145851124, -122.385242953388) | |
| 80390 | 80390 | 91046 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2574 San Bruno Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2008 12:00:00 AM | 3x3 | Permit Number 51958 | 6010972.0 | 2093540.2 | 37.7290813641679 | -122.404330986626 | (37.7290813641679, -122.404330986626) | ||
| 153828 | 153828 | 88582 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 572 24th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51525 | 5988469.856980001 | 2112085.5473 | 37.7787187988439 | -122.483480758311 | (37.7787187988439, -122.483480758311) | ||
| 100904 | 100904 | 88193 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 364 Tehama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51197 | 6011427.8 | 2112687.4 | 37.781680810769295 | -122.40410221959 | (37.7816808107693, -122.40410221959) | ||
| 115363 | 115363 | 88192 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 364 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51197 | 6011427.8 | 2112687.4 | 37.781680810769295 | -122.40410221959 | (37.7816808107693, -122.40410221959) | ||
| 34143 | 34143 | 88173 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 360 Clementina St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51186 | 6011687.76515 | 2112550.16033 | 37.781318504386604 | -122.40319320113001 | (37.7813185043866, -122.40319320113) | |
| 40467 | 40467 | 88171 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 360 Clementina St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51186 | 6011722.12263 | 2112583.0098200003 | 37.78141062014 | -122.40307665168899 | (37.78141062014, -122.403076651689) | |
| 76989 | 76989 | 88169 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 360 Clementina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51186 | 6011742.09911 | 2112601.7739 | 37.781463257472794 | -122.403008862566 | (37.7814632574728, -122.403008862566) | |
| 83994 | 83994 | 88168 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 366 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51186 | 6011675.0 | 2112537.0 | 37.7812816562818 | -122.40323643650801 | (37.7812816562818, -122.403236436508) | ||
| 102214 | 102214 | 88176 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 366 Clementina St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51186 | 6011675.0 | 2112537.0 | 37.7812816562818 | -122.40323643650801 | (37.7812816562818, -122.403236436508) | ||
| 133603 | 133603 | 88175 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 360 Clementina St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51186 | 6011658.68026 | 2112523.0235200003 | 37.781242368680296 | -122.403291911611 | (37.7812423686803, -122.403291911611) | |
| 137715 | 137715 | 88170 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 360 Clementina St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51186 | 6011731.581680001 | 2112591.71808 | 37.781435059217 | -122.403044540485 | (37.781435059217, -122.403044540485) | |
| 154828 | 154828 | 88174 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 360 Clementina St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51186 | 6011666.30434 | 2112532.5502400002 | 37.7812689526358 | -122.403266206273 | (37.7812689526358, -122.403266206273) | |
| 169888 | 169888 | 88172 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 360 Clementina St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51186 | 6011709.51547 | 2112571.62711 | 37.7813786618321 | -122.403119465684 | (37.7813786618321, -122.403119465684) | |
| 103316 | 103316 | 87277 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2417 Bryant St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/2008 12:00:00 AM | 3x3 | Permit Number 50297 | 6009714.0 | 2103272.0 | 37.7557323884753 | -122.409366521735 | (37.7557323884753, -122.409366521735) | |||
| 131057 | 131057 | 53151 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1397@ JENNINGS Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/02/2006 12:00:00 AM | 3 | Permit Number 49077 | 6016183.7166 | 2093547.2272 | 37.7293905172533 | -122.38631399173599 | (37.7293905172533, -122.386313991736) | ||
| 145230 | 145230 | 53153 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1397@ JENNINGS Revere Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/2006 12:00:00 AM | Permit Number 49077 | 6016165.18448304 | 2093562.93446239 | 37.729432620466596 | -122.386379154297 | (37.7294326204666, -122.386379154297) | ||
| 14524 | 14524 | 52852 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 50 Lansing St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48860 | 6014360.0420699995 | 2114216.81563 | 37.7860436350529 | -122.394065071555 | (37.7860436350529, -122.394065071555) | |
| 14673 | 14673 | 52844 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 50 Lansing St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48860 | 6014342.2793 | 2114200.39615 | 37.785997563678706 | -122.39412537650401 | (37.7859975636787, -122.394125376504) |
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");