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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | |
| 14383 | 14383 | 118374 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 4x6 | 6014693.17098 | 2114681.8097099997 | 37.787338911495 | -122.392945071183 | (37.787338911495, -122.392945071183) | |||
| 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) | |
| 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) | |||
| 26030 | 26030 | 118375 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 4x6 | 6014712.487269999 | 2114662.02755 | 37.7872856671566 | -122.392876855803 | (37.7872856671566, -122.392876855803) | |||
| 35251 | 35251 | 121502 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4 | 10x4 | 6014428.99687 | 2115060.94265 | 37.7883652457059 | -122.393885614549 | (37.7883652457059, -122.393885614549) | |||
| 38160 | 38160 | 121504 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5 | 10x4 | 6014396.4001 | 2115093.29031 | 37.7884522533286 | -122.39400066032499 | (37.7884522533286, -122.394000660325) | |||
| 46572 | 46572 | 121505 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5 | 10x4 | 6014377.50413 | 2115113.61118 | 37.7885069995398 | -122.394067461056 | (37.7885069995398, -122.394067461056) | |||
| 60824 | 60824 | 121501 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4 | 10x4 | 6014441.60375 | 2115047.86993 | 37.7883300516388 | -122.39384108102101 | (37.7883300516388, -122.393841081021) | |||
| 78293 | 78293 | 118379 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 6014683.0 | 2114666.0 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | ||||
| 78470 | 78470 | 121547 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 79273 | 79273 | 121543 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 83570 | 83570 | 118377 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 6014683.0 | 2114666.0 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | ||||
| 86944 | 86944 | 118378 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 6014683.0 | 2114666.0 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | ||||
| 89450 | 89450 | 118380 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 6014683.0 | 2114666.0 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | ||||
| 90872 | 90872 | 121545 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 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) | |||
| 106586 | 106586 | 121542 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 109208 | 109208 | 118376 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x6 | 6014683.0 | 2114666.0 | 37.7872949366988 | -122.392979154362 | (37.7872949366988, -122.392979154362) | ||||
| 115120 | 115120 | 121546 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 126027 | 126027 | 121544 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 128007 | 128007 | 122701 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 2895 San Bruno Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/2016 12:00:00 AM | 3 | 3x9 | 6011453.69513 | 2092165.7679400002 | 37.7253343641976 | -122.40256910729201 | (37.7253343641976, -122.402569107292) | ||
| 129011 | 129011 | 121540 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 144636 | 144636 | 121541 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 318 Main St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8x15 | 6015095.0 | 2115307.0 | 37.7890778525244 | -122.391598542205 | (37.7890778525244, -122.391598542205) | ||||
| 145746 | 145746 | 122700 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 2895 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/2016 12:00:00 AM | 3 | 3x9 | 6011453.69513 | 2092165.7679400002 | 37.7253343641976 | -122.40256910729201 | (37.7253343641976, -122.402569107292) | ||
| 151686 | 151686 | 121503 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5 | 10x4 | 6014412.49464 | 2115075.87435 | 37.7884053276005 | -122.39394375569401 | (37.7884053276005, -122.393943755694) | |||
| 1577 | 1577 | 220490 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 3040 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/26/2012 12:00:00 AM | 3 | Width 3ft | 6008734.34434 | 2102169.4736599997 | 37.75265016257671 | -122.41267655749901 | (37.7526501625767, -122.412676557499) | ||
| 2522 | 2522 | 141925 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 900 MCALLISTER ST | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/23/2013 12:00:00 AM | 2 | Width 0ft | 6004344.9249 | 2111897.598 | 37.7791139177501 | -122.42854930773399 | (37.7791139177501, -122.428549307734) | ||
| 6537 | 6537 | 22773 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1741 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001679.7734 | 2112097.4839 | 37.7795115699514 | -122.43778345572599 | (37.7795115699514, -122.437783455726) | |||
| 10347 | 10347 | 87548 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2809 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/19/2015 12:00:00 AM | 3 | 3x3 | 6011363.6591 | 2092480.1221 | 37.726192488710105 | -122.40290245438601 | (37.7261924887101, -122.402902454386) | ||
| 10401 | 10401 | 24863 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2636 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/11/2015 12:00:00 AM | 5 | 4x4 | 6011074.2033 | 2093259.325 | 37.7283158506885 | -122.40395790213002 | (37.7283158506885, -122.40395790213) | ||
| 10649 | 10649 | 87528 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2684 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/10/2012 12:00:00 AM | 3 | 4x4 | 6011133.0386 | 2093058.8298 | 37.727768619555896 | -122.403740403083 | (37.7277686195559, -122.403740403083) | ||
| 10876 | 10876 | 28683 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2961 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/26/2012 12:00:00 AM | 3 | 3X3 | 6011553.9607 | 2091855.0708 | 37.7244868510493 | -122.402200662543 | (37.7244868510493, -122.402200662543) | ||
| 11049 | 11049 | 24848 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2354 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/06/2013 12:00:00 AM | 3 | 3x3 | 6010497.60503 | 2095014.35127 | 37.7331025516429 | -122.406074827698 | (37.7331025516429, -122.406074827698) | ||
| 11321 | 11321 | 24880 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2473 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/11/2015 12:00:00 AM | 5 | 3X3 | 6010833.7586 | 2094203.8757 | 37.73089595245371 | -122.40485560772899 | (37.7308959524537, -122.404855607729) | ||
| 14664 | 14664 | 27459 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1601 Indiana St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 6X6 | 6015175.2959199995 | 2101002.60795 | 37.749805592554104 | -122.39032090789 | (37.7498055925541, -122.39032090789) | |||
| 14738 | 14738 | 8260 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1555 Galvez Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2004 12:00:00 AM | 3 | 3x3 | 6015944.99866 | 2097559.42208 | 37.74039397959 | -122.38741905015301 | (37.74039397959, -122.387419050153) | ||
| 14909 | 14909 | 86671 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1155 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6009854.63379 | 2108677.64485 | 37.7705829373798 | -122.409261609551 | (37.7705829373798, -122.409261609551) | ||
| 15322 | 15322 | 27454 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1635 Indiana St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6X6 | 6015187.13368 | 2100745.31925 | 37.7490997884263 | -122.390261998696 | (37.7490997884263, -122.390261998696) | |||
| 15617 | 15617 | 27455 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1635 Indiana St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6X6 | 6015186.58653 | 2100768.66108 | 37.7491638498456 | -122.390265521335 | (37.7491638498456, -122.390265521335) | |||
| 15760 | 15760 | 8264 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1555 Galvez Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2004 12:00:00 AM | 3 | 3x3 | 6016042.026869999 | 2097486.66692 | 37.74019958213879 | -122.38707848858401 | (37.7401995821388, -122.387078488584) | ||
| 16419 | 16419 | 86689 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 833 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/09/2007 12:00:00 AM | 3 | 3x3 | 6011647.231000001 | 2110392.1587400003 | 37.775390867731794 | -122.40318158457701 | (37.7753908677318, -122.403181584577) | ||
| 17188 | 17188 | 28843 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 338 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/2008 12:00:00 AM | 3 | 3X3 | 5993062.32103 | 2089859.0124700002 | 37.7179566445716 | -122.465978279778 | (37.7179566445716, -122.465978279778) | ||
| 17525 | 17525 | 654 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 3255X 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/26/2012 12:00:00 AM | 3 | 3x3 | 6007301.1492800005 | 2102040.7128 | 37.7522160715366 | -122.417623684893 | (37.7522160715366, -122.417623684893) | ||
| 18132 | 18132 | 25478 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2451X Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/27/2002 12:00:00 AM | 6 | 3X3 | 6009740.95146 | 2103104.50441 | 37.7552739931277 | -122.40926149534401 | (37.7552739931277, -122.409261495344) | ||
| 18469 | 18469 | 28373 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1008X Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/14/2003 12:00:00 AM | 3 | 3X3 | 6004368.57651 | 2102993.46907 | 37.7546666629566 | -122.42783286161001 | (37.7546666629566, -122.42783286161) | ||
| 18757 | 18757 | 25477 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2451X Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/14/2006 12:00:00 AM | 3 | 3X3 | 6009744.3885699995 | 2103075.41158 | 37.7551943032962 | -122.40924755584999 | (37.7551943032962, -122.40924755585) | ||
| 19003 | 19003 | 658 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 3266 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/26/2012 12:00:00 AM | 3 | 3x3 | 6007255.021480001 | 2102083.69856 | 37.7523315048963 | -122.417786249056 | (37.7523315048963, -122.417786249056) | ||
| 21229 | 21229 | 2361 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2451X Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/14/2006 12:00:00 AM | 3 | 3X3 | 6009745.3225 | 2103030.00614 | 37.7550696824471 | -122.409241122079 | (37.7550696824471, -122.409241122079) | ||
| 21317 | 21317 | 862 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 400X Alemany Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4x4 | 6008011.36344 | 2095005.6880599998 | 37.732939390338004 | -122.414669840947 | (37.732939390338, -122.414669840947) | |||
| 21659 | 21659 | 853 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 370 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/06/2006 12:00:00 AM | 3 | 3X3 | 6008364.22406 | 2095210.3079400002 | 37.7335210511394 | -122.4134643726 | (37.7335210511394, -122.4134643726) | ||
| 21770 | 21770 | 2424 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2843 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/27/1994 12:00:00 AM | 3 | 3X3 | 6009873.38674 | 2100822.7763099996 | 37.7490162935621 | -122.408642536922 | (37.7490162935621, -122.408642536922) | ||
| 21927 | 21927 | 861 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 400X Alemany Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/02/2013 12:00:00 AM | 3 | 4x4 | 6008036.03862 | 2095018.0701 | 37.7329747750588 | -122.41458540809799 | (37.7329747750588, -122.414585408098) | ||
| 21941 | 21941 | 28285 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1010 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/28/2003 12:00:00 AM | 3 | 3x3 | 6004371.7708 | 2102969.95862 | 37.7546022894831 | -122.427820139789 | (37.7546022894831, -122.427820139789) | ||
| 22267 | 22267 | 2366 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2500 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6009707.81579 | 2102741.7783 | 37.754276171914704 | -122.40935049224501 | (37.7542761719147, -122.409350492245) | |||
| 23108 | 23108 | 2426 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2855 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 3X3 | 6009874.246230001 | 2100776.83629 | 37.748890200541 | -122.408636324408 | (37.748890200541, -122.408636324408) | |||
| 23161 | 23161 | 2363 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2478 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 6009688.22905 | 2102936.69302 | 37.754810266704794 | -122.409431983418 | (37.7548102667048, -122.409431983418) | ||||
| 23350 | 23350 | 14857 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1365 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/1992 12:00:00 AM | 3 | 3x3 | 6002635.4903 | 2111607.9304 | 37.7782216761893 | -122.43444221569099 | (37.7782216761893, -122.434442215691) | ||
| 25058 | 25058 | 141590 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 700x DIVISADERO ST | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 0ft | 6001558.8965 | 2111018.1096 | 37.776541006446706 | -122.438124278141 | (37.7765410064467, -122.438124278141) | |||
| 27237 | 27237 | 141321 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 600x DIVISADERO ST | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001606.879 | 2110711.3642 | 37.7757014893927 | -122.437936316665 | (37.7757014893927, -122.437936316665) | |||
| 29792 | 29792 | 112595 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1200X Divisadero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 3x3 | 6001326.7981 | 2112711.2386 | 37.781176707308504 | -122.43904854399099 | (37.7811767073085, -122.439048543991) | |||
| 30082 | 30082 | 141368 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 500x DIVISADERO ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001677.0206 | 2110226.585 | 37.774374395633394 | -122.43765895363701 | (37.7743743956334, -122.437658953637) | |||
| 30804 | 30804 | 141336 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 500x DIVISADERO ST | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001660.0118 | 2110350.0832 | 37.7747125236659 | -122.437726636856 | (37.7747125236659, -122.437726636856) | |||
| 31078 | 31078 | 141345 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 500x DIVISADERO ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001662.4769 | 2110310.1497 | 37.7746030164406 | -122.437715248986 | (37.7746030164406, -122.437715248986) | |||
| 31263 | 31263 | 137681 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 900x DIVISADERO ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001487.0408 | 2111552.8208 | 37.7780051017696 | -122.438411165508 | (37.7780051017696, -122.438411165508) | |||
| 31777 | 31777 | 247369 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 400x Divisadero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001726.9821 | 2109863.6289 | 37.773380649478504 | -122.437460131244 | (37.7733806494785, -122.437460131244) | |||
| 31984 | 31984 | 137765 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 900x DIVISADERO ST | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001461.6592 | 2111740.6449 | 37.7785193755481 | -122.438512430085 | (37.7785193755481, -122.438512430085) | |||
| 32188 | 32188 | 141618 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 700x DIVISADERO ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001576.0331 | 2110923.0014 | 37.77628083782329 | -122.438058183449 | (37.7762808378233, -122.438058183449) | |||
| 32664 | 32664 | 247514 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 300x Divisadero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001758.7748 | 2109713.6816 | 37.7729707390414 | -122.43733941693701 | (37.7729707390414, -122.437339416937) | |||
| 38131 | 38131 | 140748 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1300x DIVISADERO ST | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001272.3122 | 2113103.8079 | 37.782251502236704 | -122.439265184087 | (37.7822515022367, -122.439265184087) | |||
| 41056 | 41056 | 138174 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 900x DIVISADERO ST | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001486.0255 | 2111568.0498 | 37.778046859007894 | -122.438415769146 | (37.7780468590079, -122.438415769146) | |||
| 41565 | 41565 | 244890 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 300x Divisadero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001780.4834 | 2109546.7964 | 37.772513747957 | -122.43725237282601 | (37.772513747957, -122.437252372826) | |||
| 42109 | 42109 | 247508 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 400x Divisadero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001724.0539 | 2109895.2534 | 37.7734673159842 | -122.43747252535401 | (37.7734673159842, -122.437472525354) |
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");