trees
563 rows where qSpecies_id = 52 sorted by YCoord descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▲ | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32951 | 112484 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 1275 Columbus Ave | 4 | Front Yard : Yard | Tree | Private 2 | 08/03/2015 12:00:00 AM | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | 5 | 1 | 1 | 308 | 32 | ||||
115879 | 112485 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 1275 Columbus Ave | 5 | Front Yard : Yard | Tree | Private 2 | 08/03/2015 12:00:00 AM | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | 5 | 1 | 1 | 308 | 32 | ||||
131448 | 112486 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1275 Columbus Ave | 6 | Front Yard : Yard | Tree | Private 2 | 08/03/2015 12:00:00 AM | Permit Number 774532 | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | 5 | 1 | 1 | 308 | 32 | |||
157517 | 112488 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 1275 Columbus Ave | 8 | Front Yard : Yard | Tree | Private 2 | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | 5 | 1 | 1 | 308 | 32 | |||||
167115 | 112487 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 1275 Columbus Ave | 7 | Front Yard : Yard | Tree | Private 2 | 6007539.6 | 2121483.9 | 37.8056158049656 | -122.418177422209 | (37.8056158049656, -122.418177422209) | 5 | 1 | 1 | 308 | 32 | |||||
40206 | 62008 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 3400 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/31/1985 12:00:00 AM | Permit Number 22077 | 6003692.18423041 | 2120397.09224754 | 37.8024144061446 | -122.431414313869 | (37.8024144061446, -122.431414313869) | 13 | 9 | 1 | 57 | 17 | ||
64346 | 109844 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 535 CLAY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 5x5 | 6012019 | 2117742 | 37.7955925645 | -122.402412455116 | (37.7955925645, -122.402412455116) | 3 | 1 | 10 | 28860 | 4 | |||
192906 | 61359 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1234 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/12/2016 12:00:00 AM | 3x3 | Permit Number 21268 | 6008775.22346441 | 2117343.22168335 | 37.7943160027564 | -122.413608310086 | (37.7943160027564, -122.413608310086) | 5 | 1 | 10 | 28857 | 21 | ||
40971 | 23414 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1800X VAN NESS AVE | 2 | Median : Cutout | Tree | DPW 1 | 30 | 9 | 6006192 | 2116736 | 37.7925033310543 | -122.422503407712 | (37.7925033310543, -122.422503407712) | 13 | 9 | 10 | 28858 | 32 | |||
14136 | 112391 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 2201X LYON ST | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x12 | 5999307 | 2116423 | 37.7912531030346 | -122.446303107227 | (37.7912531030346, -122.446303107227) | 13 | 6 | 1 | 29490 | 31 | ||||
189234 | 112390 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 2201X LYON ST | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x12 | 5999307 | 2116423 | 37.7912531030346 | -122.446303107227 | (37.7912531030346, -122.446303107227) | 13 | 6 | 1 | 29490 | 31 | ||||
45645 | 137844 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1957 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003342.7396 | 2115504.846 | 37.7889617474845 | -122.432273965064 | (37.7889617474845, -122.432273965064) | 13 | 9 | 1 | 29490 | 27 | |||
46714 | 9895 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1800X Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005051.0377 | 2115464.4068 | 37.7889474242075 | -122.426360597873 | (37.7889474242075, -122.426360597873) | 13 | 9 | 1 | 28858 | 27 | |||
8624 | 52193 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 2050x Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | Permit Number 48383 | 6003893.10220549 | 2115458.97047215 | 37.7888669751572 | -122.430366510079 | (37.7888669751572, -122.430366510079) | 13 | 9 | 11 | 29490 | 27 | ||
81701 | 44123 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 2007 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/1982 12:00:00 AM | Permit Number 43625 | 6003862.36561668 | 2115304.31925422 | 37.7884406009287 | -122.430461815441 | (37.7884406009287, -122.430461815441) | 13 | 9 | 1 | 29490 | 27 | ||
81235 | 61652 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1984 12:00:00 AM | Permit Number 21641 | 5993002.2450542 | 2114941.18121592 | 37.7868223445778 | -122.468009369168 | (37.7868223445778, -122.468009369168) | 11 | 6 | 1 | 54 | 11 | ||
146044 | 19366 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 500X Lake St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 125 | 3X3 | 5993786.07945 | 2114905.65207 | 37.7867700254284 | -122.465294925074 | (37.7867700254284, -122.465294925074) | 11 | 6 | 1 | 54 | 11 | |||
26156 | 31998 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 501#302 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/30/1995 12:00:00 AM | Permit Number 35397 | 5993950.60803177 | 2114839.47908066 | 37.7865978192777 | -122.464720892381 | (37.7865978192777, -122.464720892381) | 11 | 6 | 2 | 54 | 11 | ||
146550 | 32724 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1082 Post St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37114 | 6006978.17320306 | 2114692.47231461 | 37.7869366280698 | -122.419638162258 | (37.7869366280698, -122.419638162258) | 13 | 9 | 10 | 28858 | 21 | ||
77919 | 32699 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 665 Geary St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37104 | 6008544.39382175 | 2114510.13304212 | 37.7865240684083 | -122.414206472781 | (37.7865240684083, -122.414206472781) | 5 | 1 | 9 | 28852 | 36 | ||
65566 | 32711 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 920 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/2002 12:00:00 AM | Permit Number 44986 | 6007431.49416975 | 2114487.39461752 | 37.7863990597284 | -122.418055227286 | (37.7863990597284, -122.418055227286) | 13 | 9 | 9 | 28858 | 36 | ||
189275 | 61657 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 162 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1984 12:00:00 AM | Permit Number 21649 | 5993073.36079419 | 2114411.6730158 | 37.785372566948 | -122.467724802862 | (37.785372566948, -122.467724802862) | 11 | 6 | 2 | 54 | 11 | ||
117098 | 61664 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 4900 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/30/1994 12:00:00 AM | Permit Number 21660 | 5992426.26787439 | 2114159.4357735 | 37.7846426083195 | -122.469945157417 | (37.7846426083195, -122.469945157417) | 11 | 6 | 2 | 54 | 11 | ||
194035 | 122180 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 100 14th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | Width 3ft | 5991527.0848 | 2114155.02215 | 37.784578471021 | -122.473055677376 | (37.784578471021, -122.473055677376) | 11 | 6 | 2 | 54 | 26 | |||
111489 | 252877 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1400 Baker St | 2 | Front Yard : Yard | Tree | Private 2 | 01/30/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779185 | 6000422 | 2113928 | 37.7844660975886 | -122.442266061376 | (37.7844660975886, -122.442266061376) | 15 | 6 | 11 | 29490 | 13 | |
58852 | 92012 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1900 Geary Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52162 | 6002138.3 | 2113859.7 | 37.7843762313587 | -122.436323371803 | (37.7843762313587, -122.436323371803) | 13 | 6 | 11 | 29490 | 13 | ||||
131970 | 92011 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1900 Geary Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52162 | 6002138.3 | 2113859.7 | 37.7843762313587 | -122.436323371803 | (37.7843762313587, -122.436323371803) | 13 | 6 | 11 | 29490 | 13 | ||||
80810 | 139099 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 2600 POST ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5999616.6518 | 2113666.4004 | 37.7837018805543 | -122.445033467364 | (37.7837018805543, -122.445033467364) | 15 | 6 | 11 | 29490 | 31 | |||
92481 | 32999 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 666 Folsom St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | Permit Number 37299 | 6013145.25876593 | 2113656.86996444 | 37.7844385625752 | -122.39822862272 | (37.7844385625752, -122.39822862272) | 6 | 2 | 9 | 28853 | 6 | ||
180688 | 32992 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 666 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | Permit Number 37299 | 6013145.25876593 | 2113656.86996444 | 37.7844385625752 | -122.39822862272 | (37.7844385625752, -122.39822862272) | 6 | 2 | 9 | 28853 | 6 | ||
184426 | 32990 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 666 Folsom St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | Permit Number 37299 | 6013145.25876593 | 2113656.86996444 | 37.7844385625752 | -122.39822862272 | (37.7844385625752, -122.39822862272) | 6 | 2 | 9 | 28853 | 6 | ||
186774 | 32991 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 666 Folsom St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | Permit Number 37299 | 6013145.25876593 | 2113656.86996444 | 37.7844385625752 | -122.39822862272 | (37.7844385625752, -122.39822862272) | 6 | 2 | 9 | 28853 | 6 | ||
184342 | 139748 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1330 Laguna St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6004640.4611 | 2113601.4606 | 37.7838090228042 | -122.427648355277 | (37.7838090228042, -122.427648355277) | 7 | 9 | 11 | 28858 | 41 | |||
124647 | 6173 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1075 Ellis St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005893.15301 | 2113273.27935 | 37.782978696051 | -122.423291166859 | (37.782978696051, -122.423291166859) | 7 | 9 | 11 | 28858 | 41 | |||
45600 | 109085 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 370 09TH AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 5993248.4 | 2113128.2 | 37.7818586054113 | -122.467025880438 | (37.7818586054113, -122.467025880438) | 11 | 6 | 2 | 54 | 11 | |||
90026 | 109086 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 370 09TH AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | 3x3 | 5993248.4 | 2113128.2 | 37.7818586054113 | -122.467025880438 | (37.7818586054113, -122.467025880438) | 11 | 6 | 2 | 54 | 11 | |||
12925 | 122943 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 300 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 29 | Width 3ft | 5993094 | 2113125 | 37.7818409059319 | -122.467559795372 | (37.7818409059319, -122.467559795372) | 11 | 6 | 2 | 54 | 11 | |||
130215 | 63183 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1335 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1986 12:00:00 AM | Permit Number 23722 | 6002224.85030351 | 2113085.27883033 | 37.7822547845521 | -122.435968505977 | (37.7822547845521, -122.435968505977) | 15 | 5 | 11 | 29490 | 41 | ||
45774 | 114249 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 499x 24TH AVE | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5988415 | 2112957 | 37.7811083698872 | -122.483734439284 | (37.7811083698872, -122.483734439284) | 11 | 6 | 2 | 55 | 26 | ||||
68180 | 63202 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 7 Shore View Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1986 12:00:00 AM | Permit Number 23744 | 5984650.0940692 | 2112837.90974399 | 37.7805615078558 | -122.496750144554 | (37.7805615078558, -122.496750144554) | 11 | 6 | 2 | 55 | 26 | ||
128188 | 94201 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1227 Pierce St | 2 | Sidewalk: Property side : | Tree | Private 2 | 06/22/2010 12:00:00 AM | Permit Number 53604 | 6002086 | 2112766.6 | 37.7813718842821 | -122.436426049876 | (37.7813718842821, -122.436426049876) | 15 | 5 | 11 | 29490 | 41 | |||
158313 | 30787 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 488 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/1995 12:00:00 AM | 3x3 | Permit Number 51964 | 6013865.01842582 | 2112595.14259648 | 37.7815633679001 | -122.395664068446 | (37.7815633679001, -122.395664068446) | 6 | 2 | 9 | 28856 | 6 | ||
42746 | 87674 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 770 Golden Gate Ave | 10 | Front Yard : Cutout | Tree | Private 2 | 05/22/2008 12:00:00 AM | 3x3 | Permit Number 50396 | 6005860.1 | 2112469.5 | 37.7807698496384 | -122.423348359154 | (37.7807698496384, -122.423348359154) | 7 | 9 | 11 | 28852 | 41 | ||
150229 | 87675 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 770 Golden Gate Ave | 11 | Front Yard : Cutout | Tree | Private 2 | 05/22/2008 12:00:00 AM | 3x3 | Permit Number 50396 | 6005860.1 | 2112469.5 | 37.7807698496384 | -122.423348359154 | (37.7807698496384, -122.423348359154) | 7 | 9 | 11 | 28852 | 41 | ||
4982 | 62308 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 930@ Lorraine Ct Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/11/1985 12:00:00 AM | Permit Number 22446 | 5996162.7133263 | 2112267.41531283 | 37.77966290152 | -122.456881494589 | (37.77966290152, -122.456881494589) | 11 | 6 | 2 | 54 | 16 | ||
137503 | 60551 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 539 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1982 12:00:00 AM | Permit Number 20161 | 5985003.93496372 | 2112200.51497155 | 37.7788321315722 | -122.495479035088 | (37.7788321315722, -122.495479035088) | 11 | 6 | 2 | 55 | 26 | ||
86760 | 34702 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 546 46th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1997 12:00:00 AM | Permit Number 38359 | 5981647.34162822 | 2112027.92469202 | 37.7781611337001 | -122.507077805831 | (37.7781611337001, -122.507077805831) | 11 | 6 | 2 | 55 | 26 | ||
3737 | 51577 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 584 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 28 | Permit Number 47871 | 5982583.51771 | 2111812.9357 | 37.7776259284617 | -122.50382336032 | (37.7776259284617, -122.50382336032) | 11 | 6 | 2 | 55 | 26 | ||
183690 | 63265 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1760 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/1987 12:00:00 AM | 25 | Permit Number 24158 | 6001156.49330664 | 2111800.30825294 | 37.7786658324282 | -122.439572390689 | (37.7786658324282, -122.439572390689) | 15 | 5 | 11 | 29490 | 41 | |
52378 | 62309 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 197 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/11/1985 12:00:00 AM | Permit Number 22447 | 5996603.44612338 | 2111537.89783115 | 37.7776851364685 | -122.45530408152 | (37.7776851364685, -122.45530408152) | 11 | 6 | 2 | 54 | 16 | ||
21959 | 60557 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 646 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1982 12:00:00 AM | Permit Number 20167 | 5985081.30797731 | 2111459.74994128 | 37.776802733932 | -122.495156735304 | (37.776802733932, -122.495156735304) | 11 | 6 | 2 | 55 | 26 | ||
140823 | 98951 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 401 Grove St | 11 | Front Yard : Yard | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 | |||||
3823 | 121262 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 505 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6005321 | 2111256 | 37.7774074352434 | -122.42512699851 | (37.7774074352434, -122.42512699851) | 7 | 9 | 11 | 28852 | 10 | |||
146575 | 122380 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 557 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6005149 | 2111246 | 37.777370259808 | -122.425721291473 | (37.777370259808, -122.425721291473) | 7 | 9 | 11 | 28852 | 10 | |||
116 | 113159 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 555 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005146 | 2111243 | 37.777361853017 | -122.425731455878 | (37.777361853017, -122.425731455878) | 7 | 9 | 11 | 28852 | 10 | ||||
31523 | 98952 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 302 Ivy St | 18 | Front Yard : Yard | Tree | Private 2 | 6005888.5 | 2111234.3 | 37.7773798943726 | -122.42316228433 | (37.7773798943726, -122.42316228433) | 7 | 9 | 11 | 28852 | 10 | |||||
35379 | 254803 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 525 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005345 | 2110923 | 37.7764944541895 | -122.425020275756 | (37.7764944541895, -122.425020275756) | 7 | 9 | 11 | 28852 | 10 | ||||
70602 | 142225 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 641 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6004777.6628 | 2110866.818 | 37.7763081284007 | -122.426978855787 | (37.7763081284007, -122.426978855787) | 7 | 9 | 11 | 28852 | 10 | |||
29319 | 60604 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 526 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/17/1983 12:00:00 AM | Permit Number 20226 | 6000645.93118316 | 2110758.39288593 | 37.7757759257469 | -122.441263840373 | (37.7757759257469, -122.441263840373) | 15 | 5 | 11 | 29492 | 10 | ||
177890 | 66846 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 25 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/15/1991 12:00:00 AM | 14 | Permit Number 30150 | 5998189.80412132 | 2110576.56755949 | 37.7751364632784 | -122.449747058625 | (37.7751364632784, -122.449747058625) | 15 | 5 | 11 | 29492 | 16 | |
148069 | 66850 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1880 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/15/1991 12:00:00 AM | Permit Number 30155 | 5998816.45099957 | 2110433.37978637 | 37.7747791387742 | -122.447569047166 | (37.7747791387742, -122.447569047166) | 15 | 5 | 11 | 29492 | 16 | ||
167497 | 51287 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 726 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 47659 | 5989465.45229129 | 2110387.70383509 | 37.7741148873605 | -122.479912367003 | (37.7741148873605, -122.479912367003) | 11 | 6 | 2 | 55 | 26 | ||
38428 | 58101 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 535 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1990 12:00:00 AM | Permit Number 29160 | 6004548.41463352 | 2110369.10321649 | 37.774928559979 | -122.427736418344 | (37.774928559979, -122.427736418344) | 7 | 9 | 11 | 28852 | 10 | ||
105013 | 54847 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 2056 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1972 12:00:00 AM | 20 | 3x3 | Permit Number 10705 | 5997976.78501928 | 2110316.64994342 | 37.7744106068743 | -122.450465194002 | (37.7744106068743, -122.450465194002) | 15 | 5 | 11 | 29492 | 16 | |
3489 | 244479 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 124 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005906.1302 | 2110197.2252 | 37.7745333330343 | -122.423027565946 | (37.7745333330343, -122.423027565946) | 7 | 9 | 11 | 28852 | 10 | |||
137140 | 112418 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 268X Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2.5x3 | 6005334.87738 | 2110100.0463 | 37.7742342515583 | -122.424996726643 | (37.7742342515583, -122.424996726643) | 7 | 9 | 11 | 28852 | 10 | ||||
44857 | 6104 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 500X 08th St | 6 | Median : Cutout | Tree | DPW 1 | 12 | 18 | 6010526.8124541 | 2109340.6023904 | 37.7724409020578 | -122.406983260044 | (37.7724409020578, -122.406983260044) | 14 | 2 | 9 | 28853 | 34 | |||
48855 | 6103 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 500X 08th St | 5 | Median : Cutout | Tree | DPW 1 | 3 | 18 | 6010526.8124541 | 2109340.6023904 | 37.7724409020578 | -122.406983260044 | (37.7724409020578, -122.406983260044) | 14 | 2 | 9 | 28853 | 34 | |||
82519 | 6106 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 500X 08th St | 8 | Median : Cutout | Tree | DPW 1 | 18 | 18 | 6010526.8124541 | 2109340.6023904 | 37.7724409020578 | -122.406983260044 | (37.7724409020578, -122.406983260044) | 14 | 2 | 9 | 28853 | 34 | |||
83538 | 6101 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 500X 08th St | 3 | Median : Cutout | Tree | DPW 1 | 3 | 18 | 6010526.8124541 | 2109340.6023904 | 37.7724409020578 | -122.406983260044 | (37.7724409020578, -122.406983260044) | 14 | 2 | 9 | 28853 | 34 | |||
108995 | 6102 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 500X 08th St | 4 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 6 | 18 | 6010526.8124541 | 2109340.6023904 | 37.7724409020578 | -122.406983260044 | (37.7724409020578, -122.406983260044) | 14 | 2 | 9 | 28853 | 34 | |||
140238 | 6100 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 500X 08th St | 2 | Median : Cutout | Tree | DPW 1 | 24 | 18 | 6010526.8124541 | 2109340.6023904 | 37.7724409020578 | -122.406983260044 | (37.7724409020578, -122.406983260044) | 14 | 2 | 9 | 28853 | 34 | |||
152575 | 6105 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 500X 08th St | 7 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3 | 18 | 6010526.8124541 | 2109340.6023904 | 37.7724409020578 | -122.406983260044 | (37.7724409020578, -122.406983260044) | 14 | 2 | 9 | 28853 | 34 | |||
181750 | 6099 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 500X 08th St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 18 | 18 | 6010526.8124541 | 2109340.6023904 | 37.7724409020578 | -122.406983260044 | (37.7724409020578, -122.406983260044) | 14 | 2 | 9 | 28853 | 34 | |||
154893 | 62017 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 53 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1986 12:00:00 AM | Permit Number 22088 | 6004287.33949957 | 2108757.29100043 | 37.7704881450556 | -122.428524619186 | (37.7704881450556, -122.428524619186) | 7 | 9 | 11 | 29492 | 10 | ||
105041 | 66384 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 289 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1991 12:00:00 AM | Permit Number 29510 | 6003897.0288205 | 2108659.24127875 | 37.7701968288604 | -122.429867711068 | (37.7701968288604, -122.429867711068) | 7 | 9 | 5 | 29492 | 10 | ||
63332 | 95379 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 20 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 6003883.1 | 2108496.4 | 37.7697489175502 | -122.429904273455 | (37.7697489175502, -122.429904273455) | 7 | 9 | 5 | 29492 | 10 | ||||
72544 | 95380 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 20 Fillmore St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 6003883.1 | 2108496.4 | 37.7697489175502 | -122.429904273455 | (37.7697489175502, -122.429904273455) | 7 | 9 | 5 | 29492 | 10 | ||||
120835 | 95378 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 20 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 6003883.1 | 2108496.4 | 37.7697489175502 | -122.429904273455 | (37.7697489175502, -122.429904273455) | 7 | 9 | 5 | 29492 | 10 | ||||
123227 | 95381 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 20 Fillmore St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 6003883.1 | 2108496.4 | 37.7697489175502 | -122.429904273455 | (37.7697489175502, -122.429904273455) | 7 | 9 | 5 | 29492 | 10 | ||||
107404 | 58502 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1275 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/1979 12:00:00 AM | Permit Number 17675 | 5999614.32190404 | 2108410.03271869 | 37.7692691057292 | -122.444663596269 | (37.7692691057292, -122.444663596269) | 15 | 5 | 11 | 29492 | 9 | |||
165498 | 75663 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 400 Duboce Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/20/1990 12:00:00 AM | 25 | 6003991.19971734 | 2108404.68072341 | 37.7695031998873 | -122.429523817606 | (37.7695031998873, -122.429523817606) | 7 | 9 | 5 | 29492 | 10 | |||
66384 | 66803 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 42 Woodward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/1991 12:00:00 AM | Permit Number 30083 | 6006463.70585844 | 2108242.90937755 | 37.76919869647 | -122.420960014682 | (37.76919869647, -122.420960014682) | 8 | 4 | 7 | 28853 | 19 | ||
5213 | 84938 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 52 | 145 Guerrero St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 49347 | 6005480 | 2108218 | 37.7690748022624 | -122.42436083172 | (37.7690748022624, -122.42436083172) | 8 | 4 | 5 | 28853 | 19 | ||||
154879 | 94599 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1709 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5997540 | 2108126 | 37.7683706375079 | -122.451818041345 | (37.7683706375079, -122.451818041345) | 15 | 5 | 11 | 29492 | 9 | |||||
84008 | 67301 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 110 Beulah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/1992 12:00:00 AM | Permit Number 30782 | 5997564.33795756 | 2107830.91613748 | 37.7675618065748 | -122.451712570063 | (37.7675618065748, -122.451712570063) | 15 | 5 | 11 | 29492 | 9 | |||
145339 | 67105 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1205 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1992 12:00:00 AM | Permit Number 30520 | 5992960.34916512 | 2107265.37958459 | 37.765744243823 | -122.467595898952 | (37.765744243823, -122.467595898952) | 11 | 8 | 11 | 56 | 12 | ||
87134 | 66337 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1230 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/10/1990 12:00:00 AM | 12 | Permit Number 29458 | 5986478.94641131 | 2106871.16119587 | 37.7642854833106 | -122.489984375656 | (37.7642854833106, -122.489984375656) | 1 | 8 | 3 | 56 | 35 | |
136242 | 181588 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1227 37th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5984569.5881 | 2106811.9615 | 37.7640112583591 | -122.496583837339 | (37.7640112583591, -122.496583837339) | 1 | 8 | 3 | 56 | 35 | |||
77820 | 183716 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1231 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5984571.0948 | 2106790.8677 | 37.7639534289968 | -122.49657706948 | (37.7639534289968, -122.49657706948) | 1 | 8 | 3 | 56 | 35 | |||
43117 | 62644 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1255 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2008 12:00:00 AM | 1 | 3x3 | Permit Number 50627 | 5983022.3246657 | 2106594.48040873 | 37.7633233458854 | -122.501919183937 | (37.7633233458854, -122.501919183937) | 1 | 8 | 3 | 56 | 35 | |
7446 | 243531 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 2095 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x3 | 6008748.77289 | 2106455.16153 | 37.764418495754 | -122.412929646495 | (37.764418495754, -122.412929646495) | 8 | 4 | 7 | 28859 | 19 | |||
85125 | 101217 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 444 De Haro St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011994.2 | 2106304.5 | 37.7641864535036 | -122.401693953948 | (37.7641864535036, -122.401693953948) | 8 | 3 | 8 | 28856 | 29 | ||||
152370 | 69180 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1310 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1994 12:00:00 AM | 8 | Permit Number 33219 | 5982156.72464205 | 2106168.22486515 | 37.7621020835294 | -122.504881372035 | (37.7621020835294, -122.504881372035) | 1 | 8 | 3 | 56 | 35 | |
125898 | 110145 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 64 WOODLAND AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 3x15 | 5997139.6 | 2106104.1 | 37.7627960760002 | -122.453057009148 | (37.7627960760002, -122.453057009148) | 15 | 5 | 11 | 29492 | 12 | |||
170435 | 66751 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1126 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/12/1991 12:00:00 AM | Permit Number 30003 | 5998922.20523511 | 2106051.2337001 | 37.7627529185657 | -122.446887825215 | (37.7627529185657, -122.446887825215) | 15 | 5 | 5 | 29492 | 9 | ||
83066 | 68706 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 3727 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/1993 12:00:00 AM | Permit Number 32714 | 6004057.02264849 | 2105954.86981245 | 37.7627803365256 | -122.429121438821 | (37.7627803365256, -122.429121438821) | 8 | 4 | 5 | 28862 | 3 | ||
164338 | 32593 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1375 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/1996 12:00:00 AM | 1 | Permit Number 37061 | 5985530.1581728 | 2105866.8789552 | 37.7614725555795 | -122.493191928821 | (37.7614725555795, -122.493191928821) | 1 | 8 | 3 | 56 | 35 | |
53177 | 191717 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 554 Rhode Island St | 1 | : | Tree | Private 2 | 13 | Width 6ft | 6011757.49983 | 2105782.3491 | 37.762739532526 | -122.402475918038 | (37.762739532526, -122.402475918038) | 8 | 3 | 8 | 28856 | 29 | |||
106918 | 62431 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 4402 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1985 12:00:00 AM | Permit Number 22591 | 5999916.26807627 | 2105779.65094566 | 37.76206395953 | -122.443430215898 | (37.76206395953, -122.443430215898) | 15 | 5 | 5 | 28862 | 3 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );