Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▲ | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 107396 | 107396 | 112485 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 1275 Columbus Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/03/2015 12:00:00 AM | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | ||||
| 109824 | 109824 | 112486 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1275 Columbus Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/03/2015 12:00:00 AM | Permit Number 774532 | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | |||
| 122611 | 122611 | 112487 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 1275 Columbus Ave | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | |||||
| 122658 | 122658 | 112488 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 1275 Columbus Ave | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | |||||
| 124450 | 124450 | 112484 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 1275 Columbus Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 08/03/2015 12:00:00 AM | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | ||||
| 81490 | 81490 | 62008 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 3400 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/31/1985 12:00:00 AM | Permit Number 22077 | 6003692.18423041 | 2120397.09224754 | 37.8024144061446 | -122.431414313869 | (37.8024144061446, -122.431414313869) | ||
| 87121 | 87121 | 109844 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 535 CLAY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 5x5 | 6012019.0 | 2117742.0 | 37.7955925645 | -122.402412455116 | (37.7955925645, -122.402412455116) | |||
| 145422 | 145422 | 61359 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1234 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/2016 12:00:00 AM | 3x3 | Permit Number 21268 | 6008775.22346441 | 2117343.22168335 | 37.7943160027564 | -122.413608310086 | (37.7943160027564, -122.413608310086) | ||
| 79746 | 79746 | 23414 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1800X VAN NESS AVE | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006192.0 | 2116736.0 | 37.7925033310543 | -122.422503407712 | (37.7925033310543, -122.422503407712) | |||
| 49634 | 49634 | 112391 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 2201X LYON ST | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x12 | 5999307.0 | 2116423.0 | 37.7912531030346 | -122.446303107227 | (37.7912531030346, -122.446303107227) | ||||
| 139051 | 139051 | 112390 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 2201X LYON ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x12 | 5999307.0 | 2116423.0 | 37.7912531030346 | -122.446303107227 | (37.7912531030346, -122.446303107227) | ||||
| 29001 | 29001 | 137844 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1957 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003342.7396 | 2115504.846 | 37.7889617474845 | -122.43227396506398 | (37.7889617474845, -122.432273965064) | |||
| 109 | 109 | 9895 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1800X Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005051.0377 | 2115464.4068 | 37.7889474242075 | -122.426360597873 | (37.7889474242075, -122.426360597873) | |||
| 139868 | 139868 | 52193 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 2050x Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/1982 12:00:00 AM | 14 | Permit Number 48383 | 6003893.10220549 | 2115458.97047215 | 37.788866975157205 | -122.430366510079 | (37.7888669751572, -122.430366510079) | |
| 97302 | 97302 | 44123 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 2007 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/1982 12:00:00 AM | Permit Number 43625 | 6003862.36561668 | 2115304.31925422 | 37.7884406009287 | -122.43046181544099 | (37.7884406009287, -122.430461815441) | ||
| 94650 | 94650 | 61652 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1984 12:00:00 AM | Permit Number 21641 | 5993002.2450542 | 2114941.18121592 | 37.7868223445778 | -122.468009369168 | (37.7868223445778, -122.468009369168) | ||
| 113211 | 113211 | 19366 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 500X Lake St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 3X3 | 5993786.07945 | 2114905.6520700003 | 37.7867700254284 | -122.465294925074 | (37.7867700254284, -122.465294925074) | |||
| 127079 | 127079 | 31998 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 501#302 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/30/1995 12:00:00 AM | Permit Number 35397 | 5993950.60803177 | 2114839.47908066 | 37.7865978192777 | -122.464720892381 | (37.7865978192777, -122.464720892381) | ||
| 114187 | 114187 | 32724 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1082 Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37114 | 6006978.17320306 | 2114692.47231461 | 37.786936628069796 | -122.419638162258 | (37.7869366280698, -122.419638162258) | ||
| 96365 | 96365 | 32699 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 665 Geary St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37104 | 6008544.39382175 | 2114510.13304212 | 37.7865240684083 | -122.41420647278099 | (37.7865240684083, -122.414206472781) | ||
| 85830 | 85830 | 32711 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 920 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2002 12:00:00 AM | Permit Number 44986 | 6007431.49416975 | 2114487.39461752 | 37.786399059728396 | -122.41805522728599 | (37.7863990597284, -122.418055227286) | ||
| 141990 | 141990 | 61657 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 162 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1984 12:00:00 AM | Permit Number 21649 | 5993073.36079419 | 2114411.6730158003 | 37.785372566948 | -122.467724802862 | (37.785372566948, -122.467724802862) | ||
| 108589 | 108589 | 61664 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 4900 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/1994 12:00:00 AM | Permit Number 21660 | 5992426.26787439 | 2114159.4357735002 | 37.7846426083195 | -122.46994515741699 | (37.7846426083195, -122.469945157417) | ||
| 187769 | 187769 | 122180 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 100 14th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 3ft | 5991527.0848 | 2114155.02215 | 37.784578471021 | -122.47305567737601 | (37.784578471021, -122.473055677376) | |||
| 90102 | 90102 | 92012 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1900 Geary Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52162 | 6002138.3 | 2113859.7 | 37.784376231358706 | -122.436323371803 | (37.7843762313587, -122.436323371803) | ||||
| 105328 | 105328 | 92011 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1900 Geary Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 52162 | 6002138.3 | 2113859.7 | 37.784376231358706 | -122.436323371803 | (37.7843762313587, -122.436323371803) | ||||
| 179665 | 179665 | 139099 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2600 POST ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5999616.6518 | 2113666.4004 | 37.7837018805543 | -122.44503346736401 | (37.7837018805543, -122.445033467364) | |||
| 92852 | 92852 | 32999 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 666 Folsom St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | Permit Number 37299 | 6013145.25876593 | 2113656.86996444 | 37.784438562575204 | -122.39822862272 | (37.7844385625752, -122.39822862272) | ||
| 142804 | 142804 | 32992 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 666 Folsom St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | Permit Number 37299 | 6013145.25876593 | 2113656.86996444 | 37.784438562575204 | -122.39822862272 | (37.7844385625752, -122.39822862272) | ||
| 142893 | 142893 | 32990 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 666 Folsom St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | Permit Number 37299 | 6013145.25876593 | 2113656.86996444 | 37.784438562575204 | -122.39822862272 | (37.7844385625752, -122.39822862272) | ||
| 143352 | 143352 | 32991 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 666 Folsom St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | Permit Number 37299 | 6013145.25876593 | 2113656.86996444 | 37.784438562575204 | -122.39822862272 | (37.7844385625752, -122.39822862272) | ||
| 68584 | 68584 | 139748 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1330 Laguna St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6004640.4611 | 2113601.4606 | 37.783809022804206 | -122.427648355277 | (37.7838090228042, -122.427648355277) | |||
| 105845 | 105845 | 6173 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1075 Ellis St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005893.15301 | 2113273.27935 | 37.782978696051 | -122.423291166859 | (37.782978696051, -122.423291166859) | |||
| 164248 | 164248 | 122943 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 300 09th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 29 | Width 3ft | 5993109.61739 | 2113257.70524 | 37.7822061800557 | -122.467515420271 | (37.7822061800557, -122.467515420271) | |||
| 82194 | 82194 | 109085 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 370 09TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 5993248.4 | 2113128.2 | 37.781858605411294 | -122.467025880438 | (37.7818586054113, -122.467025880438) | |||
| 91579 | 91579 | 109086 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 370 09TH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | 3x3 | 5993248.4 | 2113128.2 | 37.781858605411294 | -122.467025880438 | (37.7818586054113, -122.467025880438) | |||
| 104919 | 104919 | 63183 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1335 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1986 12:00:00 AM | Permit Number 23722 | 6002224.85030351 | 2113085.27883033 | 37.7822547845521 | -122.435968505977 | (37.7822547845521, -122.435968505977) | ||
| 81453 | 81453 | 114249 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 499x 24TH AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5988415.0 | 2112957.0 | 37.78110836988721 | -122.483734439284 | (37.7811083698872, -122.483734439284) | ||||
| 85692 | 85692 | 63202 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 7 Shore View Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | Permit Number 23744 | 5984650.094069201 | 2112837.90974399 | 37.78056150785579 | -122.496750144554 | (37.7805615078558, -122.496750144554) | ||
| 109026 | 109026 | 94201 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1227 Pierce St | 2 | Sidewalk: Property side : 26 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | Permit Number 53604 | 6002086.0 | 2112766.6 | 37.7813718842821 | -122.436426049876 | (37.7813718842821, -122.436426049876) | |||
| 120422 | 120422 | 30787 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 488 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/1995 12:00:00 AM | 3x3 | Permit Number 51964 | 6013865.01842582 | 2112595.14259648 | 37.7815633679001 | -122.39566406844601 | (37.7815633679001, -122.395664068446) | ||
| 80436 | 80436 | 87674 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 770 Golden Gate Ave | 10 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 05/22/2008 12:00:00 AM | 3x3 | Permit Number 50396 | 6005860.1 | 2112469.5 | 37.7807698496384 | -122.42334835915399 | (37.7807698496384, -122.423348359154) | ||
| 113089 | 113089 | 87675 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 770 Golden Gate Ave | 11 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 05/22/2008 12:00:00 AM | 3x3 | Permit Number 50396 | 6005860.1 | 2112469.5 | 37.7807698496384 | -122.42334835915399 | (37.7807698496384, -122.423348359154) | ||
| 123487 | 123487 | 62308 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 930@ Lorraine Ct Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/1985 12:00:00 AM | Permit Number 22446 | 5996162.7133263005 | 2112267.41531283 | 37.77966290152 | -122.456881494589 | (37.77966290152, -122.456881494589) | ||
| 111909 | 111909 | 60551 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 539 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | Permit Number 20161 | 5985003.93496372 | 2112200.51497155 | 37.7788321315722 | -122.49547903508801 | (37.7788321315722, -122.495479035088) | ||
| 93083 | 93083 | 34702 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 546 46th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38359 | 5981647.34162822 | 2112027.92469202 | 37.7781611337001 | -122.50707780583099 | (37.7781611337001, -122.507077805831) | ||
| 152160 | 152160 | 51577 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 584 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/2005 12:00:00 AM | 28 | Permit Number 47871 | 5982583.51771 | 2111812.9357 | 37.7776259284617 | -122.50382336032 | (37.7776259284617, -122.50382336032) | |
| 26478 | 26478 | 63265 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1760 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1987 12:00:00 AM | 25 | Permit Number 24158 | 6001156.49330664 | 2111800.30825294 | 37.7786658324282 | -122.439572390689 | (37.7786658324282, -122.439572390689) | |
| 82837 | 82837 | 62309 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 197 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/1985 12:00:00 AM | Permit Number 22447 | 5996603.44612338 | 2111537.89783115 | 37.7776851364685 | -122.45530408152 | (37.7776851364685, -122.45530408152) | ||
| 126005 | 126005 | 60557 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 646 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1982 12:00:00 AM | Permit Number 20167 | 5985081.30797731 | 2111459.74994128 | 37.776802733932 | -122.495156735304 | (37.776802733932, -122.495156735304) | ||
| 112521 | 112521 | 98951 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 401 Grove St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005778.2 | 2111279.0 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | |||||
| 67534 | 67534 | 121262 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 505 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6005321.0 | 2111256.0 | 37.7774074352434 | -122.42512699851002 | (37.7774074352434, -122.42512699851) | |||
| 39778 | 39778 | 122380 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 557 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6005149.0 | 2111246.0 | 37.777370259808 | -122.42572129147301 | (37.777370259808, -122.425721291473) | |||
| 53591 | 53591 | 113159 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 555 GROVE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005146.0 | 2111243.0 | 37.777361853017 | -122.425731455878 | (37.777361853017, -122.425731455878) | ||||
| 126530 | 126530 | 98952 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 302 Ivy St | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | |||||
| 35856 | 35856 | 142225 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 641 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6004777.6628 | 2110866.818 | 37.7763081284007 | -122.42697885578698 | (37.7763081284007, -122.426978855787) | |||
| 127914 | 127914 | 60604 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 526 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/17/1983 12:00:00 AM | Permit Number 20226 | 6000645.93118316 | 2110758.39288593 | 37.7757759257469 | -122.441263840373 | (37.7757759257469, -122.441263840373) | ||
| 160277 | 160277 | 66846 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 25 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/15/1991 12:00:00 AM | 14 | Permit Number 30150 | 5998189.80412132 | 2110576.56755949 | 37.7751364632784 | -122.449747058625 | (37.7751364632784, -122.449747058625) | |
| 112059 | 112059 | 66850 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1880 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/15/1991 12:00:00 AM | Permit Number 30155 | 5998816.45099957 | 2110433.37978637 | 37.77477913877421 | -122.447569047166 | (37.7747791387742, -122.447569047166) | ||
| 117345 | 117345 | 51287 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 726 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 47659 | 5989465.45229129 | 2110387.70383509 | 37.774114887360504 | -122.479912367003 | (37.7741148873605, -122.479912367003) | ||
| 126825 | 126825 | 58101 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 535 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/15/1990 12:00:00 AM | Permit Number 29160 | 6004548.41463352 | 2110369.10321649 | 37.774928559979 | -122.427736418344 | (37.774928559979, -122.427736418344) | ||
| 72418 | 72418 | 54847 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 2056 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/1972 12:00:00 AM | 20 | 3x3 | Permit Number 10705 | 5997976.78501928 | 2110316.64994342 | 37.7744106068743 | -122.45046519400199 | (37.7744106068743, -122.450465194002) | |
| 32548 | 32548 | 244479 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 124 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005906.1302 | 2110197.2252 | 37.7745333330343 | -122.423027565946 | (37.7745333330343, -122.423027565946) | |||
| 94524 | 94524 | 112418 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 268X Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x3 | 6005334.87738 | 2110100.0463 | 37.7742342515583 | -122.42499672664302 | (37.7742342515583, -122.424996726643) | ||||
| 81628 | 81628 | 6104 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 500X 08th St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 18 | 6010526.812454099 | 2109340.6023904 | 37.772440902057795 | -122.406983260044 | (37.7724409020578, -122.406983260044) | |||
| 84076 | 84076 | 6103 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 500X 08th St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 18 | 6010526.812454099 | 2109340.6023904 | 37.772440902057795 | -122.406983260044 | (37.7724409020578, -122.406983260044) | |||
| 93222 | 93222 | 6106 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 500X 08th St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 18 | 6010526.812454099 | 2109340.6023904 | 37.772440902057795 | -122.406983260044 | (37.7724409020578, -122.406983260044) | |||
| 94353 | 94353 | 6101 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 500X 08th St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 18 | 6010526.812454099 | 2109340.6023904 | 37.772440902057795 | -122.406983260044 | (37.7724409020578, -122.406983260044) | |||
| 99878 | 99878 | 6102 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 500X 08th St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 6 | 18 | 6010526.812454099 | 2109340.6023904 | 37.772440902057795 | -122.406983260044 | (37.7724409020578, -122.406983260044) | |||
| 111282 | 111282 | 6100 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 500X 08th St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 18 | 6010526.812454099 | 2109340.6023904 | 37.772440902057795 | -122.406983260044 | (37.7724409020578, -122.406983260044) | |||
| 119405 | 119405 | 6105 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 500X 08th St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3 | 18 | 6010526.812454099 | 2109340.6023904 | 37.772440902057795 | -122.406983260044 | (37.7724409020578, -122.406983260044) | |||
| 140157 | 140157 | 6099 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 500X 08th St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 18 | 18 | 6010526.812454099 | 2109340.6023904 | 37.772440902057795 | -122.406983260044 | (37.7724409020578, -122.406983260044) | |||
| 122165 | 122165 | 62017 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 53 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1986 12:00:00 AM | Permit Number 22088 | 6004287.33949957 | 2108757.29100043 | 37.7704881450556 | -122.428524619186 | (37.7704881450556, -122.428524619186) | ||
| 100586 | 100586 | 66384 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 289 Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1991 12:00:00 AM | Permit Number 29510 | 6003897.0288205 | 2108659.24127875 | 37.7701968288604 | -122.429867711068 | (37.7701968288604, -122.429867711068) | ||
| 87247 | 87247 | 95380 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 20 Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 6003883.1 | 2108496.4 | 37.7697489175502 | -122.42990427345501 | (37.7697489175502, -122.429904273455) | ||||
| 89065 | 89065 | 95379 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 20 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 6003883.1 | 2108496.4 | 37.7697489175502 | -122.42990427345501 | (37.7697489175502, -122.429904273455) | ||||
| 107433 | 107433 | 95381 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 20 Fillmore St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 6003883.1 | 2108496.4 | 37.7697489175502 | -122.42990427345501 | (37.7697489175502, -122.429904273455) | ||||
| 107885 | 107885 | 95378 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 20 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 6003883.1 | 2108496.4 | 37.7697489175502 | -122.42990427345501 | (37.7697489175502, -122.429904273455) | ||||
| 98604 | 98604 | 58502 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1275 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/1979 12:00:00 AM | Permit Number 17675 | 5999614.32190404 | 2108410.03271869 | 37.7692691057292 | -122.444663596269 | (37.7692691057292, -122.444663596269) | |||
| 117856 | 117856 | 75663 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 400 Duboce Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/20/1990 12:00:00 AM | 25 | 6003991.19971734 | 2108404.68072341 | 37.769503199887296 | -122.429523817606 | (37.7695031998873, -122.429523817606) | |||
| 88193 | 88193 | 66803 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 42 Woodward St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/1991 12:00:00 AM | Permit Number 30083 | 6006463.70585844 | 2108242.90937755 | 37.769198696470006 | -122.42096001468201 | (37.76919869647, -122.420960014682) | ||
| 46601 | 46601 | 84938 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 145 Guerrero St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 49347 | 6005480.0 | 2108218.0 | 37.769074802262395 | -122.42436083172 | (37.7690748022624, -122.42436083172) | ||||
| 118459 | 118459 | 94599 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1709 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5997540.0 | 2108126.0 | 37.7683706375079 | -122.451818041345 | (37.7683706375079, -122.451818041345) | |||||
| 91742 | 91742 | 67301 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 110 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/1992 12:00:00 AM | Permit Number 30782 | 5997564.33795756 | 2107830.91613748 | 37.7675618065748 | -122.451712570063 | (37.7675618065748, -122.451712570063) | |||
| 111480 | 111480 | 67105 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1205 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/28/1992 12:00:00 AM | Permit Number 30520 | 5992960.34916512 | 2107265.37958459 | 37.765744243823 | -122.46759589895201 | (37.765744243823, -122.467595898952) | ||
| 159794 | 159794 | 218792 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1259 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 5995767.3383 | 2106956.01161 | 37.7650564658073 | -122.457864799536 | (37.7650564658073, -122.457864799536) | |||
| 69668 | 69668 | 66337 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1230 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/10/1990 12:00:00 AM | 12 | Permit Number 29458 | 5986478.94641131 | 2106871.16119587 | 37.7642854833106 | -122.489984375656 | (37.7642854833106, -122.489984375656) | |
| 182351 | 182351 | 181588 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1227 37th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5984569.5881 | 2106811.9615 | 37.764011258359105 | -122.496583837339 | (37.7640112583591, -122.496583837339) | |||
| 166229 | 166229 | 183716 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1231 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5984571.0948 | 2106790.8677 | 37.7639534289968 | -122.49657706948 | (37.7639534289968, -122.49657706948) | |||
| 165342 | 165342 | 62644 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1255 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2008 12:00:00 AM | 1 | 3x3 | Permit Number 50627 | 5983022.3246657 | 2106594.48040873 | 37.763323345885404 | -122.50191918393699 | (37.7633233458854, -122.501919183937) | |
| 95843 | 95843 | 101217 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 444 De Haro St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011994.2 | 2106304.5 | 37.764186453503605 | -122.401693953948 | (37.7641864535036, -122.401693953948) | ||||
| 50313 | 50313 | 69180 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1310 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1994 12:00:00 AM | 8 | Permit Number 33219 | 5982156.72464205 | 2106168.22486515 | 37.7621020835294 | -122.504881372035 | (37.7621020835294, -122.504881372035) | |
| 108418 | 108418 | 110145 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 64 WOODLAND AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 3x15 | 5997139.6 | 2106104.1 | 37.76279607600021 | -122.45305700914801 | (37.7627960760002, -122.453057009148) | |||
| 122660 | 122660 | 66751 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1126 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/12/1991 12:00:00 AM | Permit Number 30003 | 5998922.20523511 | 2106051.2337001 | 37.7627529185657 | -122.446887825215 | (37.7627529185657, -122.446887825215) | ||
| 97012 | 97012 | 68706 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 3727 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/1993 12:00:00 AM | Permit Number 32714 | 6004057.02264849 | 2105954.86981245 | 37.7627803365256 | -122.42912143882099 | (37.7627803365256, -122.429121438821) | ||
| 170536 | 170536 | 32593 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1375 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1996 12:00:00 AM | 1 | Permit Number 37061 | 5985530.158172799 | 2105866.8789552 | 37.7614725555795 | -122.49319192882099 | (37.7614725555795, -122.493191928821) | |
| 177574 | 177574 | 191717 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 554 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 6ft | 6011757.49983 | 2105782.3491 | 37.762739532526005 | -122.40247591803801 | (37.762739532526, -122.402475918038) | |||
| 103815 | 103815 | 62431 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 4402 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/07/1985 12:00:00 AM | Permit Number 22591 | 5999916.26807627 | 2105779.65094566 | 37.76206395953 | -122.443430215898 | (37.76206395953, -122.443430215898) | ||
| 48344 | 48344 | 191716 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 561 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6011818.5901 | 2105765.65198 | 37.7626970962079 | -122.40226345320801 | (37.7626970962079, -122.402263453208) | |||
| 82914 | 82914 | 67118 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 35 Carmel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1992 12:00:00 AM | Permit Number 30538 | 5998791.80760997 | 2105372.50995466 | 37.7608818625197 | -122.44728997041 | (37.7608818625197, -122.44728997041) |
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");