trees
563 rows where qSpecies_id = 52 sorted by PlotSize
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2604 | 224449 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1201 San Jose Ave | 62 | Front Yard : Yard | Tree | Private 2 | 22 | 6004503.55801 | 2096138.79869 | 37.7358529500558 | -122.426877907491 | (37.7358529500558, -122.426877907491) | 2 | 7 | 5 | 28861 | 2 | ||||
| 3070 | 52712 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 53@ FAIR AVE Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/31/2006 12:00:00 AM | Permit Number 48768 | 6006913.27477728 | 2099421.81000315 | 37.7450033243522 | -122.418779304454 | (37.7450033243522, -122.418779304454) | 2 | 7 | 7 | 28859 | 2 | ||
| 3174 | 224198 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1001 San Jose Ave | 30 | Front Yard : Yard | Tree | Private 2 | 9 | 6005259.16763 | 2097058.51402 | 37.7384209767501 | -122.424330858406 | (37.7384209767501, -122.424330858406) | 2 | 7 | 5 | 28859 | 2 | ||||
| 3480 | 40261 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 3543 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/2005 12:00:00 AM | Permit Number 47928 | 6005992.45992589 | 2101968.12777251 | 37.7519430420387 | -122.422144186794 | (37.7519430420387, -122.422144186794) | 2 | 4 | 5 | 28859 | 19 | ||
| 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 | ||
| 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 | ||
| 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 | ||||
| 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 | ||
| 8705 | 224209 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1001 San Jose Ave | 70 | Front Yard : Yard | Tree | Private 2 | 20 | 6005356.45271 | 2097454.81484 | 37.7395146225008 | -122.424022667913 | (37.7395146225008, -122.424022667913) | 2 | 7 | 5 | 28859 | 2 | ||||
| 16913 | 34491 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1723 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | Permit Number 38214 | 6009344.79247114 | 2099429.66611089 | 37.7451615013423 | -122.410372074504 | (37.7451615013423, -122.410372074504) | 2 | 7 | 7 | 28859 | 2 | ||
| 18337 | 113889 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 1x STORRIE ST | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | 90 | 6000722 | 2105303 | 37.7608011093363 | -122.440609317727 | (37.7608011093363, -122.440609317727) | 15 | 4 | 5 | 28862 | 3 | ||||
| 21497 | 106463 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 3500X MISSION ST | 3 | Median : Cutout | Tree | DPW 1 | 28 | 6005565.6 | 2097823.9 | 37.7405398531137 | -122.42332575716 | (37.7405398531137, -122.42332575716) | 2 | 7 | 7 | 28859 | 2 | ||||
| 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 | ||
| 24093 | 94378 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1001 Potrero Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | ||||
| 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 | ||
| 27402 | 106587 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1001X SAN JOSE AVE | 8 | Median : Yard | Tree | DPW 1 | 25 | 6004855 | 2096548 | 37.7369963898236 | -122.425691948858 | (37.7369963898236, -122.425691948858) | 2 | 7 | 5 | 28859 | 2 | ||||
| 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 | ||
| 29824 | 60301 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 158 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2015 12:00:00 AM | 3 | Permit Number 775317 | 6004878.91046715 | 2099326.15693939 | 37.744625928835 | -122.425806967542 | (37.744625928835, -122.425806967542) | 2 | 7 | 5 | 63 | 22 | ||
| 29973 | 64888 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 2418 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/1989 12:00:00 AM | Permit Number 25914 | 5989547.06003251 | 2098884.34921412 | 37.7425345003811 | -122.478788583135 | (37.7425345003811, -122.478788583135) | 1 | 8 | 3 | 29491 | 35 | ||
| 30003 | 63363 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 339 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/1991 12:00:00 AM | Permit Number 30042 | 6006824.56139145 | 2096444.26906016 | 37.736822665934 | -122.418874924172 | (37.736822665934, -122.418874924172) | 2 | 7 | 7 | 28859 | 2 | ||
| 30070 | 199407 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 301x Cashmere St | 7 | Median : Yard | Tree | DPW 1 | 18 | 6016184.13642 | 2096191.07332 | 37.736650012889 | -122.386496812495 | (37.736650012889, -122.386496812495) | 10 | 3 | 8 | 58 | 1 | ||||
| 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 | |||||
| 32280 | 224216 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1000 San Jose Ave | 23 | Front Yard : Yard | Tree | Private 2 | 30 | 6005148.6559 | 2097255.37057 | 37.7389552594803 | -122.424726954897 | (37.7389552594803, -122.424726954897) | 2 | 7 | 5 | 28859 | 7 | ||||
| 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 | ||||
| 33601 | 67497 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 143 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/18/1999 12:00:00 AM | Permit Number 31025 | 5999134.28418924 | 2093760.51474913 | 37.7290176881307 | -122.445270595435 | (37.7290176881307, -122.445270595435) | 9 | 7 | 4 | 28861 | 40 | ||
| 36101 | 106466 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 3500X MISSION ST | 6 | Median : Cutout | Tree | DPW 1 | 26 | 6005565.6 | 2097823.9 | 37.7405398531137 | -122.42332575716 | (37.7405398531137, -122.42332575716) | 2 | 7 | 7 | 28859 | 2 | ||||
| 36976 | 94387 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1001 Potrero Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | ||||
| 38341 | 107538 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 198X JENNINGS ST | 2 | Front Yard : Yard | Tree | DPW 1 | 6018784 | 2097136 | 37.739388174499 | -122.377573417349 | (37.739388174499, -122.377573417349) | 10 | 3 | 8 | 58 | 1 | |||||
| 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 | ||
| 38709 | 94383 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1001 Potrero Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | ||||
| 38905 | 54758 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 324 Lathrop Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/08/1972 12:00:00 AM | 8 | Permit Number 10607 | 6012398.45595 | 2086740.40831 | 37.710490116783 | -122.398922528457 | (37.710490116783, -122.398922528457) | 10 | 3 | 8 | 309 | 1 | ||
| 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 | ||
| 44136 | 224450 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1300 San Jose Ave | 55 | Front Yard : Yard | Tree | Private 2 | 21 | 6003275.39086 | 2095494.74346 | 37.7340150010873 | -122.431078209119 | (37.7340150010873, -122.431078209119) | 2 | 7 | 5 | 63 | 7 | ||||
| 45415 | 35531 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 90 Bartlett St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/1998 12:00:00 AM | Permit Number 38922 | 6006649.40506175 | 2103262.44015502 | 37.7555339585812 | -122.419964211868 | (37.7555339585812, -122.419964211868) | 2 | 4 | 7 | 28859 | 19 | ||
| 46078 | 224197 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1001 San Jose Ave | 28 | Front Yard : Yard | Tree | Private 2 | 13 | 6005251.17489 | 2097047.32393 | 37.7383897999491 | -122.424357697761 | (37.7383897999491, -122.424357697761) | 2 | 7 | 5 | 28859 | 2 | ||||
| 47929 | 63452 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 425 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/1991 12:00:00 AM | Permit Number 30038 | 6006658.37862364 | 2096248.30501412 | 37.7362752333103 | -122.419435593969 | (37.7362752333103, -122.419435593969) | 2 | 7 | 7 | 28859 | 2 | ||
| 48424 | 94380 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1001 Potrero Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | ||||
| 49435 | 67842 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 3854 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1993 12:00:00 AM | Permit Number 31510 | 6004840.52212153 | 2100493.06857021 | 37.7478278305843 | -122.426022759795 | (37.7478278305843, -122.426022759795) | 2 | 4 | 5 | 63 | 22 | ||
| 49613 | 94388 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1001 Potrero Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | ||||
| 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 | ||
| 52822 | 199404 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 299x Cashmere St | 24 | Median : Yard | Tree | DPW 1 | 31 | 6016629.65755 | 2096008.94769 | 37.7361745853726 | -122.38494375437 | (37.7361745853726, -122.38494375437) | 10 | 3 | 8 | 58 | 1 | ||||
| 53053 | 63362 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 401 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/1991 12:00:00 AM | Permit Number 30039 | 6006709.37395927 | 2096284.55563078 | 37.7363776416136 | -122.419261852343 | (37.7363776416136, -122.419261852343) | 2 | 7 | 7 | 28859 | 2 | ||
| 53590 | 106462 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 3500X MISSION ST | 2 | Median : Cutout | Tree | DPW 1 | 36 | 6005565.6 | 2097823.9 | 37.7405398531137 | -122.42332575716 | (37.7405398531137, -122.42332575716) | 2 | 7 | 7 | 28859 | 2 | ||||
| 55395 | 67118 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 35 Carmel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/1992 12:00:00 AM | Permit Number 30538 | 5998791.80760997 | 2105372.50995466 | 37.7608818625197 | -122.44728997041 | (37.7608818625197, -122.44728997041) | 15 | 5 | 11 | 29492 | 12 | ||
| 56075 | 94645 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 30 Middle Point Rd | 34 | : | Tree | Private 2 | 6018215 | 2095138 | 37.7338706954973 | -122.379402036794 | (37.7338706954973, -122.379402036794) | 10 | 3 | 8 | 58 | 1 | |||||
| 56565 | 113195 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 699X Noe St | 2 | Median : Yard | Tree | Private 2 | 6003039.77971 | 2104315.51778 | 37.7582214335608 | -122.432522620301 | (37.7582214335608, -122.432522620301) | 2 | 4 | 5 | 28862 | 3 | |||||
| 60624 | 33221 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 130 Vasquez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1996 12:00:00 AM | Permit Number 37412 | 5995037.97859853 | 2099619.33373801 | 37.7448698872964 | -122.459855964981 | (37.7448698872964, -122.459855964981) | 1 | 8 | 4 | 59 | 40 | ||
| 60896 | 60659 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 230 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20293 | 6004386.7781208 | 2097051.60858115 | 37.7383527156426 | -122.42734666634 | (37.7383527156426, -122.42734666634) | 2 | 7 | 5 | 63 | 7 | ||
| 61285 | 106578 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1001X SAN JOSE AVE | 2 | Median : Yard | Tree | DPW 1 | 24 | 6004855 | 2096548 | 37.7369963898236 | -122.425691948858 | (37.7369963898236, -122.425691948858) | 2 | 7 | 5 | 28859 | 2 | ||||
| 61928 | 224212 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1000 San Jose Ave | 2 | Front Yard : Yard | Tree | Private 2 | 9 | 6005187.14297 | 2097371.87478 | 37.7392773273908 | -122.424602169475 | (37.7392773273908, -122.424602169475) | 2 | 7 | 5 | 28859 | 7 | ||||
| 63002 | 199405 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 301x Cashmere St | 4 | Median : Yard | Tree | DPW 1 | 25 | 6016273.90453 | 2096214.73214 | 37.736719944173 | -122.386188091409 | (37.736719944173, -122.386188091409) | 10 | 3 | 8 | 58 | 1 | ||||
| 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 | ||||
| 64610 | 56525 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1645 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1987 12:00:00 AM | Permit Number 24366 | 5993992.30583295 | 2104307.94730884 | 37.7576834321386 | -122.463811929837 | (37.7576834321386, -122.463811929837) | 1 | 5 | 4 | 56 | 12 | ||
| 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 | ||
| 65900 | 69470 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1570 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/16/1994 12:00:00 AM | Permit Number 33586 | 5991155.36555461 | 2104799.07062441 | 37.7588680376507 | -122.47365896033 | (37.7588680376507, -122.47365896033) | 1 | 8 | 4 | 56 | 12 | ||
| 66164 | 94384 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1001 Potrero Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | ||||
| 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 | ||
| 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 | ||
| 69541 | 224453 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1300 San Jose Ave | 58 | Front Yard : Yard | Tree | Private 2 | 35 | 6003249.48151 | 2095473.62453 | 37.7339555451035 | -122.431166278795 | (37.7339555451035, -122.431166278795) | 2 | 7 | 5 | 63 | 7 | ||||
| 70229 | 68834 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 213 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1993 12:00:00 AM | Permit Number 32785 | 5999328.0521661 | 2094050.43857188 | 37.7298248100363 | -122.444621556754 | (37.7298248100363, -122.444621556754) | 9 | 7 | 4 | 28861 | 40 | ||
| 71651 | 61680 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 67 Ceres St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/1985 12:00:00 AM | Permit Number 21677 | 6013883.88231185 | 2093810.46965069 | 37.7299857582394 | -122.39428321764 | (37.7299857582394, -122.39428321764) | 10 | 3 | 8 | 58 | 1 | ||
| 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 | ||||
| 75000 | 94379 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1001 Potrero Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | ||||
| 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 | ||
| 79337 | 66246 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 50 De Montfort Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/24/1990 12:00:00 AM | Permit Number 29346 | 5995210.96497601 | 2091915.27509183 | 37.7237263724293 | -122.458700188143 | (37.7237263724293, -122.458700188143) | 9 | 8 | 4 | 28861 | 24 | ||
| 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 | ||
| 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 | ||
| 82563 | 104649 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 200 Wheeler Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6012242.2 | 2087732.7 | 37.7132060446128 | -122.399532207425 | (37.7132060446128, -122.399532207425) | 10 | 3 | 8 | 309 | 1 | |||||
| 83057 | 40165 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 556 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/1999 12:00:00 AM | Permit Number 41358 | 6002795.8683083 | 2102135.2617094 | 37.7522211355172 | -122.433210387902 | (37.7522211355172, -122.433210387902) | 2 | 4 | 5 | 28862 | 22 | ||
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | |
| 87365 | 61114 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1116 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/10/1983 12:00:00 AM | Permit Number 20961 | 6007611.65468316 | 2103146.29299754 | 37.7552692105316 | -122.416628217941 | (37.7552692105316, -122.416628217941) | 2 | 4 | 7 | 28859 | 19 | ||
| 88183 | 224451 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1300 San Jose Ave | 56 | Front Yard : Yard | Tree | Private 2 | 22 | 6003260.74151 | 2095484.49376 | 37.7339860276158 | -122.431128125086 | (37.7339860276158, -122.431128125086) | 2 | 7 | 5 | 63 | 7 | ||||
| 89531 | 60776 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1619 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1993 12:00:00 AM | Permit Number 31531 | 6003372.01868235 | 2098812.50590148 | 37.7431302912001 | -122.430980846877 | (37.7431302912001, -122.430980846877) | 2 | 7 | 5 | 63 | 22 | ||
| 89547 | 56208 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 232 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/04/1995 12:00:00 AM | Permit Number 12328 | 6007936.60722908 | 2100249.03484728 | 37.7473322642805 | -122.415299343316 | (37.7473322642805, -122.415299343316) | 2 | 7 | 7 | 28859 | 2 | ||
| 90216 | 247091 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 2301 Castro St | 9 | Front Yard : Yard | Tree | Private 2 | 15 | 6002747.91128 | 2098608.69961 | 37.7425353031757 | -122.433124282771 | (37.7425353031757, -122.433124282771) | 2 | 7 | 5 | 63 | 22 | ||||
| 90952 | 224204 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1300 San Jose Ave | 35 | Front Yard : Yard | Tree | Private 2 | 11 | 6003450.74753 | 2095594.0107 | 37.7342975015273 | -122.430479027684 | (37.7342975015273, -122.430479027684) | 2 | 7 | 5 | 63 | 7 | ||||
| 91041 | 106583 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1001X SAN JOSE AVE | 5 | Median : Yard | Tree | DPW 1 | 22 | 6004855 | 2096548 | 37.7369963898236 | -122.425691948858 | (37.7369963898236, -122.425691948858) | 2 | 7 | 5 | 28859 | 2 | ||||
| 91209 | 199399 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 299x Cashmere St | 14 | Median : Yard | Tree | DPW 1 | 22 | 6016725.29246 | 2095937.31293 | 37.7359831799735 | -122.38460811387 | (37.7359831799735, -122.38460811387) | 10 | 3 | 8 | 58 | 1 | ||||
| 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 | ||
| 92922 | 94385 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1001 Potrero Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | ||||
| 93151 | 53072 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 530@ CAPITOL Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2006 12:00:00 AM | Permit Number 49042 | 5995240.54795335 | 2090593.06935713 | 37.7200976112635 | -122.458502260031 | (37.7200976112635, -122.458502260031) | 9 | 8 | 6 | 28861 | 24 | ||
| 94023 | 65615 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 907 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1990 12:00:00 AM | Permit Number 28522 | 6001416.70920324 | 2088928.18069936 | 37.7158792115697 | -122.437034265981 | (37.7158792115697, -122.437034265981) | 9 | 7 | 6 | 28861 | 5 | ||
| 101740 | 63361 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 431 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/1991 12:00:00 AM | Permit Number 30041 | 6006645.62978775 | 2096239.24235854 | 37.7362496311902 | -122.419479029307 | (37.7362496311902, -122.419479029307) | 2 | 7 | 7 | 28859 | 2 | ||
| 102135 | 63496 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1665 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1993 12:00:00 AM | Permit Number 31923 | 5993996.85139129 | 2104175.81914419 | 37.7573209042452 | -122.463786619524 | (37.7573209042452, -122.463786619524) | 1 | 5 | 4 | 56 | 12 | ||
| 103774 | 106579 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1001X SAN JOSE AVE | 3 | Median : Yard | Tree | DPW 1 | 26 | 6004855 | 2096548 | 37.7369963898236 | -122.425691948858 | (37.7369963898236, -122.425691948858) | 2 | 7 | 5 | 28859 | 2 | ||||
| 104015 | 64118 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 402 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24889 | 6003939.69845123 | 2098396.37778582 | 37.7420198489818 | -122.428988299782 | (37.7420198489818, -122.428988299782) | 2 | 7 | 5 | 63 | 22 | ||
| 104871 | 94381 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 1001 Potrero Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | ||||
| 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 | ||
| 105059 | 224211 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1000 San Jose Ave | 1 | Front Yard : Yard | Tree | Private 2 | 32 | 6005190.34912 | 2097382.93272 | 37.739307871066 | -122.424591870417 | (37.739307871066, -122.424591870417) | 2 | 7 | 5 | 28859 | 7 | ||||
| 105108 | 29918 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 810 Junipero Serra Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 5991252.04535388 | 2092080.81829703 | 37.7239525748811 | -122.472397431071 | (37.7239525748811, -122.472397431071) | 9 | 8 | 4 | 64 | 40 | ||||
| 105866 | 63269 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 39 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1987 12:00:00 AM | Permit Number 23826 | 6006964.49512199 | 2099515.87189553 | 37.7452644809694 | -122.418608862279 | (37.7452644809694, -122.418608862279) | 2 | 7 | 7 | 28859 | 2 | ||
| 106472 | 67812 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 950 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/1995 12:00:00 AM | Permit Number 31466 | 6003745.95469336 | 2102716.06929971 | 37.7538697471416 | -122.429966268708 | (37.7538697471416, -122.429966268708) | 2 | 4 | 5 | 28862 | 22 | ||
| 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 | ||
| 107255 | 106599 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1001X SAN JOSE AVE | 12 | Median : Yard | Tree | DPW 1 | 42 | 6004855 | 2096548 | 37.7369963898236 | -122.425691948858 | (37.7369963898236, -122.425691948858) | 2 | 7 | 5 | 28859 | 2 | ||||
| 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 | |||
| 108653 | 224196 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1001 San Jose Ave | 16 | Front Yard : Yard | Tree | Private 2 | 15 | 6005192.42807 | 2096936.6445 | 37.7380825816538 | -122.424552945066 | (37.7380825816538, -122.424552945066) | 2 | 7 | 5 | 28859 | 2 | ||||
| 108671 | 33222 | Permitted Site 7 | Eucalyptus Spp :: Eucalyptus 52 | 130 Vasquez Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1996 12:00:00 AM | Permit Number 37412 | 5995037.97859853 | 2099619.33373801 | 37.7448698872964 | -122.459855964981 | (37.7448698872964, -122.459855964981) | 1 | 8 | 4 | 59 | 40 |
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) );