trees
11,761 rows where qSpecies_id = 17 sorted by PlantDate 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 134667 | 55412 | Permitted Site 7 | Tree(s) :: 17 | 3738 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | 3 | 9x6 | Permit Number 777221 | 6003499.49370932 | 2103052.56810363 | 37.7547797324185 | -122.430842600357 | (37.7547797324185, -122.430842600357) | 2 | 4 | 5 | 28862 | 22 | |
| 190382 | 106925 | Permitted Site 7 | Tree(s) :: 17 | 4530 18th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2014 12:00:00 AM | Permit Number 773337 | 6000944.17505 | 2105238.64712 | 37.7606370613449 | -122.439836300862 | (37.7606370613449, -122.439836300862) | 15 | 4 | 5 | 28862 | 3 | ||||
| 134049 | 57610 | Permitted Site 7 | Tree(s) :: 17 | 350 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2009 12:00:00 AM | Permit Number 53125 | 6013182.80165221 | 2105434.53689469 | 37.7618639828655 | -122.397521876032 | (37.7618639828655, -122.397521876032) | 10 | 3 | 8 | 28856 | 29 | ||
| 130924 | 49015 | Permitted Site 7 | Tree(s) :: 17 | 4378 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2002 12:00:00 AM | Permit Number 46200 | 6000173.9744919 | 2105793.6078214 | 37.7621169747035 | -122.442539913685 | (37.7621169747035, -122.442539913685) | 15 | 5 | 5 | 28862 | 3 | |||
| 134634 | 66365 | Permitted Site 7 | Tree(s) :: 17 | 5522 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/1990 12:00:00 AM | Permit Number 29487 | 5990472.1348999 | 2114087.04095849 | 37.7843306790394 | -122.476700440548 | (37.7843306790394, -122.476700440548) | 11 | 6 | 2 | 55 | 26 | |||
| 5267 | 121644 | Undocumented 4 | Tree(s) :: 17 | 362 Teresita Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2016 12:00:00 AM | 3 | 2x4 | Permit Number 779268 | 5997955 | 2098188 | 37.741107118117 | -122.449666371295 | (37.741107118117, -122.449666371295) | 9 | 7 | 4 | 59 | 40 | |
| 24608 | 36377 | Permitted Site 7 | Tree(s) :: 17 | 160 Eastwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2016 12:00:00 AM | 3 | 2x2 | Permit Number 779212 | 5995686.54623224 | 2093789.64060756 | 37.7289002539239 | -122.457191719902 | (37.7289002539239, -122.457191719902) | 9 | 7 | 4 | 28861 | 40 |
| 88018 | 57473 | DPW Maintained 1 | Tree(s) :: 17 | 51 Presidio Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778400 | 5998920.48261 | 2116370.17499 | 37.7910859772748 | -122.447636637234 | (37.7910859772748, -122.447636637234) | 13 | 6 | 1 | 54 | 31 | |
| 160120 | 36376 | Permitted Site 7 | Tree(s) :: 17 | 160 Eastwood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2016 12:00:00 AM | 3 | Permit Number 779212 | 5995686.54623224 | 2093789.64060756 | 37.7289002539239 | -122.457191719902 | (37.7289002539239, -122.457191719902) | 9 | 7 | 4 | 28861 | 40 | |
| 5664 | 50654 | Permitted Site 7 | Tree(s) :: 17 | 2824 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2003 12:00:00 AM | Permit Number 47236 | 6004394.14845271 | 2118840.16150037 | 37.7981792344265 | -122.428874109151 | (37.7981792344265, -122.428874109151) | 13 | 9 | 1 | 57 | 17 | |||
| 47587 | 50309 | Permitted Site 7 | Tree(s) :: 17 | 701 (REVISED) Grafton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2003 12:00:00 AM | Permit Number 47019 | 5994734.51143453 | 2090549.74162157 | 37.7199495485694 | -122.460248307265 | (37.7199495485694, -122.460248307265) | 9 | 8 | 6 | 28861 | 24 | |||
| 145049 | 50642 | Permitted Site 7 | Tree(s) :: 17 | 37 (REVISED) Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/2003 12:00:00 AM | Permit Number 47230 | 6002603.72466291 | 2096337.22406414 | 37.7362901764597 | -122.433460549184 | (37.7362901764597, -122.433460549184) | 2 | 7 | 5 | 63 | 7 | |||
| 41815 | 57301 | Permitted Site 7 | Tree(s) :: 17 | 3186 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/1985 12:00:00 AM | Permit Number 22637 | 6005614.71991822 | 2106685.37974416 | 37.7648741987262 | -122.42378585233 | (37.7648741987262, -122.42378585233) | 8 | 4 | 5 | 28853 | 19 | |||
| 97188 | 57197 | Permitted Site 7 | Tree(s) :: 17 | 482 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/1974 12:00:00 AM | Permit Number 14478 | 6011757.89685552 | 2110674.77225553 | 37.7761730391644 | -122.402818643695 | (37.7761730391644, -122.402818643695) | 14 | 2 | 9 | 28853 | 34 | |||
| 7408 | 53652 | Permitted Site 7 | Tree(s) :: 17 | 831 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/1969 12:00:00 AM | Permit Number 6588 | 6012089.84873388 | 2112576.989681 | 37.781414618516 | -122.401804066947 | (37.781414618516, -122.401804066947) | 6 | 2 | 9 | 28856 | 34 | |||
| 47060 | 53660 | Permitted Site 7 | Tree(s) :: 17 | 1501 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/1969 12:00:00 AM | Permit Number 6598 | 6006675.09594553 | 2116030.8641893 | 37.790594444627 | -122.420781795009 | (37.790594444627, -122.420781795009) | 13 | 9 | 10 | 28858 | 21 | |||
| 55385 | 53662 | Permitted Site 7 | Tree(s) :: 17 | 1540 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/1969 12:00:00 AM | Permit Number 6600 | 6006708.6321067 | 2116166.6463426 | 37.7909691588781 | -122.420675404796 | (37.7909691588781, -122.420675404796) | 13 | 9 | 10 | 28858 | 21 | |||
| 78194 | 53605 | Permitted Site 7 | Tree(s) :: 17 | 46 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/1969 12:00:00 AM | Permit Number 6535 | 6001976.08337653 | 2107927.03987803 | 37.7680774147604 | -122.436459822555 | (37.7680774147604, -122.436459822555) | 15 | 5 | 5 | 29492 | 3 | |||
| 100648 | 53653 | Permitted Site 7 | Tree(s) :: 17 | 1222 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/30/1969 12:00:00 AM | Permit Number 6589 | 6006853.69634946 | 2115128.25140491 | 37.7881261577171 | -122.420099762698 | (37.7881261577171, -122.420099762698) | 13 | 9 | 10 | 28858 | 21 | |||
| 136443 | 94913 | Permitted Site 7 | Tree(s) :: 17 | 1468 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2010 12:00:00 AM | 3x3 | Permit Number 54063 | 5999646 | 2107504.1 | 37.7667834498072 | -122.444488905866 | (37.7667834498072, -122.444488905866) | 15 | 5 | 5 | 29492 | 9 | ||
| 104919 | 91086 | Permitted Site 7 | Tree(s) :: 17 | 3555 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/2008 12:00:00 AM | 3x3 | Permit Number 51981 | 6003250.7 | 2106477.1 | 37.7641685772715 | -122.431947514847 | (37.7641685772715, -122.431947514847) | 15 | 4 | 5 | 28862 | 3 | ||
| 29746 | 69535 | Permitted Site 7 | Tree(s) :: 17 | 3433 Rivera St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1997 12:00:00 AM | Permit Number 38591 | 5982542.89726197 | 2100117.33230625 | 37.7455107440467 | -122.503097773227 | (37.7455107440467, -122.503097773227) | 1 | 8 | 3 | 29491 | 35 | |||
| 20663 | 68923 | Permitted Site 7 | Tree(s) :: 17 | 1101 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1993 12:00:00 AM | Permit Number 32907 | 5992754.56653249 | 2098415.60959265 | 37.7414331832018 | -122.467663985303 | (37.7414331832018, -122.467663985303) | 1 | 8 | 4 | 59 | 40 | |||
| 96241 | 68893 | Permitted Site 7 | Tree(s) :: 17 | 46 Exeter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1993 12:00:00 AM | Permit Number 32865 | 6012538.81547184 | 2091023.28624118 | 37.7222578634642 | -122.398737783114 | (37.7222578634642, -122.398737783114) | 10 | 3 | 8 | 58 | 1 | |||
| 122330 | 68900 | Permitted Site 7 | Tree(s) :: 17 | 4418 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1993 12:00:00 AM | Permit Number 32873 | 6001367.41605988 | 2104688.53855525 | 37.759150680058 | -122.438333093053 | (37.759150680058, -122.438333093053) | 2 | 4 | 5 | 28862 | 3 | |||
| 135970 | 68872 | Permitted Site 7 | Tree(s) :: 17 | 4553 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1993 12:00:00 AM | Permit Number 32843 | 5993514.7519316 | 2114160.93800174 | 37.784709593201 | -122.466179507253 | (37.784709593201, -122.466179507253) | 11 | 6 | 2 | 54 | 11 | |||
| 140335 | 68877 | Permitted Site 7 | Tree(s) :: 17 | 779 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1993 12:00:00 AM | Permit Number 32848 | 5994101.09719176 | 2110250.7349584 | 37.7740070384394 | -122.46386704039 | (37.7740070384394, -122.46386704039) | 11 | 6 | 2 | 54 | 11 | |||
| 168889 | 68905 | Permitted Site 7 | Tree(s) :: 17 | 118 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1993 12:00:00 AM | Permit Number 32879 | 6000385.55141996 | 2104916.55291942 | 37.7597208558942 | -122.441745205191 | (37.7597208558942, -122.441745205191) | 2 | 4 | 5 | 28862 | 3 | |||
| 4361 | 54796 | Permitted Site 7 | Tree(s) :: 17 | 360 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1992 12:00:00 AM | Permit Number 31483 | 6012521.21402169 | 2086869.00643816 | 37.7108500614651 | -122.398507265236 | (37.7108500614651, -122.398507265236) | 10 | 3 | 8 | 309 | 1 | |||
| 33851 | 67825 | Permitted Site 7 | Tree(s) :: 17 | 123 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1992 12:00:00 AM | Permit Number 31485 | 6010689.96923116 | 2114455.82074685 | 37.7864952232398 | -122.406779446721 | (37.7864952232398, -122.406779446721) | 14 | 10 | 10 | 28852 | 6 | |||
| 70323 | 67830 | Permitted Site 7 | Tree(s) :: 17 | 91 Randolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1992 12:00:00 AM | Permit Number 31491 | 5993778.56829124 | 2088486.77332475 | 37.714230098048 | -122.46340301955 | (37.714230098048, -122.46340301955) | 9 | 8 | 6 | 64 | 24 | |||
| 125842 | 67829 | Permitted Site 7 | Tree(s) :: 17 | 1506 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1992 12:00:00 AM | Permit Number 31490 | 5999703.57458598 | 2114031.71118585 | 37.7847098899151 | -122.444759015525 | (37.7847098899151, -122.444759015525) | 15 | 6 | 1 | 29490 | 31 | |||
| 141154 | 67824 | Permitted Site 7 | Tree(s) :: 17 | 431 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1992 12:00:00 AM | Permit Number 31480 | 6003968.72349135 | 2096047.7368688 | 37.7355726596235 | -122.428720551873 | (37.7355726596235, -122.428720551873) | 2 | 7 | 5 | 63 | 7 | |||
| 170531 | 60489 | Permitted Site 7 | Tree(s) :: 17 | 1968 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1982 12:00:00 AM | Permit Number 20218 | 6001025.04086554 | 2112475.31241126 | 37.7805117398227 | -122.440075549304 | (37.7805117398227, -122.440075549304) | 15 | 5 | 11 | 29490 | 41 | |||
| 5860 | 59490 | Permitted Site 7 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1980 12:00:00 AM | Permit Number 18865 | ||||||||||||||
| 80057 | 59485 | Permitted Site 7 | Tree(s) :: 17 | 707 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1980 12:00:00 AM | Permit Number 18859 | 6002435.52996472 | 2104090.70643026 | 37.7575698714872 | -122.434596301502 | (37.7575698714872, -122.434596301502) | 2 | 4 | 5 | 28862 | 3 | |||
| 83844 | 59491 | Permitted Site 7 | Tree(s) :: 17 | 782 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1980 12:00:00 AM | Permit Number 18866 | 5982635.2772236 | 2110455.19015972 | 37.7739009985001 | -122.503543740953 | (37.7739009985001, -122.503543740953) | 11 | 6 | 2 | 55 | 26 | |||
| 126998 | 59487 | Permitted Site 7 | Tree(s) :: 17 | 1216 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1980 12:00:00 AM | Permit Number 18862 | 5994873.90721988 | 2107259.44729119 | 37.765838252046 | -122.460976929625 | (37.765838252046, -122.460976929625) | 15 | 5 | 11 | 56 | 12 | |||
| 6445 | 58108 | Permitted Site 7 | Tree(s) :: 17 | 450 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1977 12:00:00 AM | Permit Number 17085 | 5991675.96205785 | 2096348.02453461 | 37.735693783227 | -122.471242786325 | (37.735693783227, -122.471242786325) | 1 | 8 | 4 | 29491 | 40 | |||
| 96908 | 58106 | Permitted Site 7 | Tree(s) :: 17 | 668 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1977 12:00:00 AM | Permit Number 17083 | 6007935.19422336 | 2095820.04857176 | 37.7351711673062 | -122.414990798092 | (37.7351711673062, -122.414990798092) | 2 | 7 | 7 | 28859 | 2 | |||
| 30400 | 55541 | Permitted Site 7 | Tree(s) :: 17 | 72 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1972 12:00:00 AM | Permit Number 11509 | 6000620.45604142 | 2104930.40521075 | 37.7597722725614 | -122.440933782313 | (37.7597722725614, -122.440933782313) | 2 | 4 | 5 | 28862 | 3 | |||
| 37794 | 55553 | Permitted Site 7 | Tree(s) :: 17 | 155 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1972 12:00:00 AM | Permit Number 11521 | 6000283.8481247 | 2104858.5963679 | 37.7595559260447 | -122.442092785298 | (37.7595559260447, -122.442092785298) | 2 | 4 | 5 | 28862 | 3 | |||
| 43042 | 55539 | Permitted Site 7 | Tree(s) :: 17 | 61 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1972 12:00:00 AM | Permit Number 11506 | 6000775.6587066 | 2104887.55057012 | 37.7596634424822 | -122.440393940643 | (37.7596634424822, -122.440393940643) | 2 | 4 | 5 | 28862 | 3 | |||
| 100148 | 55544 | Permitted Site 7 | Tree(s) :: 17 | 82 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1972 12:00:00 AM | Permit Number 11512 | 6000551.59293325 | 2104926.30660086 | 37.7597570964786 | -122.441171651164 | (37.7597570964786, -122.441171651164) | 2 | 4 | 5 | 28862 | 3 | |||
| 126122 | 55552 | Permitted Site 7 | Tree(s) :: 17 | 135 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1972 12:00:00 AM | Permit Number 11520 | 6000389.57084409 | 2104864.698368 | 37.7595787050528 | -122.441727582532 | (37.7595787050528, -122.441727582532) | 2 | 4 | 5 | 28862 | 3 | |||
| 156005 | 55538 | Permitted Site 7 | Tree(s) :: 17 | 55 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1972 12:00:00 AM | Permit Number 11505 | 6000807.21864554 | 2104889.42896036 | 37.7596703970127 | -122.440284925507 | (37.7596703970127, -122.440284925507) | 2 | 4 | 5 | 28862 | 3 | |||
| 157843 | 55548 | Permitted Site 7 | Tree(s) :: 17 | 95 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1972 12:00:00 AM | Permit Number 11516 | 6000596.81910293 | 2104876.90636176 | 37.7596240315827 | -122.441011692523 | (37.7596240315827, -122.441011692523) | 2 | 4 | 5 | 28862 | 3 | |||
| 158014 | 55542 | Permitted Site 7 | Tree(s) :: 17 | 76 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1972 12:00:00 AM | Permit Number 11510 | 6000593.72962466 | 2104928.81450297 | 37.7597663826416 | -122.441026101452 | (37.7597663826416, -122.441026101452) | 2 | 4 | 5 | 28862 | 3 | |||
| 167635 | 55546 | Permitted Site 7 | Tree(s) :: 17 | 91 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1972 12:00:00 AM | Permit Number 11514 | 6000617.85904965 | 2104878.15862117 | 37.7596286683257 | -122.440939015888 | (37.7596286683257, -122.440939015888) | 2 | 4 | 5 | 28862 | 3 | |||
| 185831 | 55540 | Permitted Site 7 | Tree(s) :: 17 | 67 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1972 12:00:00 AM | Permit Number 11507 | 6000744.09876767 | 2104885.67217988 | 37.7596564878509 | -122.440502955759 | (37.7596564878509, -122.440502955759) | 2 | 4 | 5 | 28862 | 3 | |||
| 191776 | 55543 | Permitted Site 7 | Tree(s) :: 17 | 80 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1972 12:00:00 AM | Permit Number 11511 | 6000562.95775886 | 2104926.98301583 | 37.7597596010991 | -122.441132394476 | (37.7597596010991, -122.441132394476) | 2 | 4 | 5 | 28862 | 3 | |||
| 15755 | 53603 | Permitted Site 7 | Tree(s) :: 17 | 35 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1969 12:00:00 AM | Permit Number 6532 | 6001927.46501567 | 2107858.3514725 | 37.7678860505623 | -122.436623070792 | (37.7678860505623, -122.436623070792) | 15 | 5 | 5 | 29492 | 3 | |||
| 31217 | 53617 | Permitted Site 7 | Tree(s) :: 17 | 30 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1969 12:00:00 AM | Permit Number 6548 | 6001981.04514346 | 2107828.16893225 | 37.7678062214456 | -122.436435583122 | (37.7678062214456, -122.436435583122) | 15 | 5 | 5 | 29492 | 3 | |||
| 34664 | 53601 | Permitted Site 7 | Tree(s) :: 17 | 27 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1969 12:00:00 AM | Permit Number 6530 | 6001929.89526893 | 2107809.92488542 | 37.7677532211941 | -122.436611198133 | (37.7677532211941, -122.436611198133) | 15 | 5 | 5 | 29492 | 3 | |||
| 42713 | 53602 | Permitted Site 7 | Tree(s) :: 17 | 29 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1969 12:00:00 AM | Permit Number 6531 | 6001929.2877059 | 2107822.03152654 | 37.767786428521 | -122.436614166292 | (37.767786428521, -122.436614166292) | 15 | 5 | 5 | 29492 | 3 | |||
| 70807 | 53597 | Permitted Site 7 | Tree(s) :: 17 | 7 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1969 12:00:00 AM | Permit Number 6526 | 6001935.97090236 | 2107688.85841209 | 37.7674211477392 | -122.436581516669 | (37.7674211477392, -122.436581516669) | 15 | 5 | 5 | 29492 | 3 | |||
| 79222 | 53598 | Permitted Site 7 | Tree(s) :: 17 | 15 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1969 12:00:00 AM | Permit Number 6527 | 6001933.5406491 | 2107737.28499916 | 37.7675539771182 | -122.436593389222 | (37.7675539771182, -122.436593389222) | 15 | 5 | 5 | 29492 | 3 | |||
| 88974 | 53599 | Permitted Site 7 | Tree(s) :: 17 | 19 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1969 12:00:00 AM | Permit Number 6528 | 6001932.32552219 | 2107761.49829835 | 37.7676203918216 | -122.436599325516 | (37.7676203918216, -122.436599325516) | 15 | 5 | 5 | 29492 | 3 | |||
| 172146 | 53604 | Permitted Site 7 | Tree(s) :: 17 | 42 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/29/1969 12:00:00 AM | Permit Number 6534 | 6001977.32381756 | 2107902.32215573 | 37.7680096164722 | -122.436453762683 | (37.7680096164722, -122.436453762683) | 15 | 5 | 5 | 29492 | 3 | |||
| 169778 | 255656 | Significant Tree 6 | Tree(s) :: 17 | 5827 Diamond Heights Blvd | 1 | Front Yard : Yard | Tree | Private 2 | 12/28/2018 12:00:00 AM | 3 | 12x12 | Permit Number 781981 | 6000844 | 2096795 | 37.7374471263095 | -122.439577439508 | (37.7374471263095, -122.439577439508) | 2 | 7 | 5 | 63 | 7 | |
| 86433 | 53866 | DPW Maintained 1 | Tree(s) :: 17 | 1746 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2017 12:00:00 AM | 3 | 3x9 | Permit Number 781116 | 5983496.0301 | 2103256.2411 | 37.7541852957533 | -122.500034034122 | (37.7541852957533, -122.500034034122) | 1 | 8 | 3 | 56 | 35 | |
| 56002 | 45833 | Permitted Site 7 | Tree(s) :: 17 | 680 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2016 12:00:00 AM | 3 | 4x4 | Permit Number 779272 | 6012169.50994414 | 2114476.97613275 | 37.7866359833773 | -122.401662060279 | (37.7866359833773, -122.401662060279) | 12 | 2 | 9 | 28855 | 6 | |
| 23461 | 39475 | Permitted Site 7 | Tree(s) :: 17 | 30 Ashbury Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | Permit Number 40936 | 5999587.55794715 | 2106838.29242396 | 37.7649519741137 | -122.444643186495 | (37.7649519741137, -122.444643186495) | 15 | 5 | 5 | 29492 | 9 | |||
| 89011 | 39474 | Permitted Site 7 | Tree(s) :: 17 | 30 Ashbury Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | Permit Number 40936 | 5999587.55794715 | 2106838.29242396 | 37.7649519741137 | -122.444643186495 | (37.7649519741137, -122.444643186495) | 15 | 5 | 5 | 29492 | 9 | |||
| 90490 | 39540 | Permitted Site 7 | Tree(s) :: 17 | 1700 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 769956 | 6012296.15591625 | 2106582.61675328 | 37.764966945494 | -122.40066910779 | (37.764966945494, -122.40066910779) | 14 | 3 | 8 | 28856 | 20 | ||
| 104799 | 39538 | Permitted Site 7 | Tree(s) :: 17 | 1700 17th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 769956 | 6012296.15591625 | 2106582.61675328 | 37.764966945494 | -122.40066910779 | (37.764966945494, -122.40066910779) | 14 | 3 | 8 | 28856 | 20 | ||
| 143458 | 39537 | Permitted Site 7 | Tree(s) :: 17 | 1700 17th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 769956 | 6012296.15591625 | 2106582.61675328 | 37.764966945494 | -122.40066910779 | (37.764966945494, -122.40066910779) | 14 | 3 | 8 | 28856 | 20 | ||
| 159347 | 39536 | Permitted Site 7 | Tree(s) :: 17 | 1700 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 769956 | 6012296.15591625 | 2106582.61675328 | 37.764966945494 | -122.40066910779 | (37.764966945494, -122.40066910779) | 14 | 3 | 8 | 28856 | 20 | ||
| 161114 | 39477 | Permitted Site 7 | Tree(s) :: 17 | 846 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | Permit Number 40938 | 5998712.42494386 | 2107198.49114158 | 37.7658910121853 | -122.447695970828 | (37.7658910121853, -122.447695970828) | 15 | 5 | 11 | 29492 | 9 | |||
| 171208 | 39473 | Permitted Site 7 | Tree(s) :: 17 | 30 Ashbury Ter | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | Permit Number 40936 | 5999587.55794715 | 2106838.29242396 | 37.7649519741137 | -122.444643186495 | (37.7649519741137, -122.444643186495) | 15 | 5 | 5 | 29492 | 9 | |||
| 184101 | 39472 | Permitted Site 7 | Tree(s) :: 17 | 30 Ashbury Ter | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1998 12:00:00 AM | Permit Number 40936 | 5999587.55794715 | 2106838.29242396 | 37.7649519741137 | -122.444643186495 | (37.7649519741137, -122.444643186495) | 15 | 5 | 5 | 29492 | 9 | |||
| 192780 | 39539 | Permitted Site 7 | Tree(s) :: 17 | 1700 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | Permit Number 769956 | 6012296.15591625 | 2106582.61675328 | 37.764966945494 | -122.40066910779 | (37.764966945494, -122.40066910779) | 14 | 3 | 8 | 28856 | 20 | ||
| 1802 | 68847 | Permitted Site 7 | Tree(s) :: 17 | 2118 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1993 12:00:00 AM | Permit Number 32810 | |||||||||||||
| 35077 | 58599 | Permitted Site 7 | Tree(s) :: 17 | 707 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1993 12:00:00 AM | Permit Number 32841 | 5997897.47170314 | 2108145.46816306 | 37.7684445593829 | -122.450582989427 | (37.7684445593829, -122.450582989427) | 15 | 5 | 11 | 29492 | 9 | |||
| 66386 | 68870 | Permitted Site 7 | Tree(s) :: 17 | 1143 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1993 12:00:00 AM | Permit Number 32840 | 6000828.54202009 | 2112572.29304687 | 37.7807668354327 | -122.440762288564 | (37.7807668354327, -122.440762288564) | 15 | 5 | 1 | 29490 | 41 | |||
| 111841 | 68871 | Permitted Site 7 | Tree(s) :: 17 | 2 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1993 12:00:00 AM | Permit Number 32842 | 6011012.91069377 | 2110216.19153104 | 37.7748722573215 | -122.405363463589 | (37.7748722573215, -122.405363463589) | 14 | 2 | 9 | 28853 | 34 | |||
| 19503 | 57738 | Permitted Site 7 | Tree(s) :: 17 | 1999 So. Bascom Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/1976 12:00:00 AM | Permit Number 16656 | |||||||||||||
| 121 | 120916 | Undocumented 4 | Tree(s) :: 17 | 1430 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778800 | 5990886 | 2105639 | 37.7611586563939 | -122.474651843595 | (37.7611586563939, -122.474651843595) | 1 | 8 | 4 | 56 | 12 | |
| 167071 | 120917 | Undocumented 4 | Tree(s) :: 17 | 1430 17th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778800 | 5990886 | 2105639 | 37.7611586563939 | -122.474651843595 | (37.7611586563939, -122.474651843595) | 1 | 8 | 4 | 56 | 12 | |
| 1917 | 46148 | Permitted Site 7 | Tree(s) :: 17 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2001 12:00:00 AM | Permit Number 44491 | ||||||||||||||
| 3573 | 46144 | Permitted Site 7 | Tree(s) :: 17 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2001 12:00:00 AM | Permit Number 44490 | ||||||||||||||
| 3659 | 46140 | Permitted Site 7 | Tree(s) :: 17 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2001 12:00:00 AM | Permit Number 44490 | ||||||||||||||
| 7318 | 46146 | Permitted Site 7 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2001 12:00:00 AM | Permit Number 44490 | ||||||||||||||
| 13908 | 46145 | Permitted Site 7 | Tree(s) :: 17 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2001 12:00:00 AM | Permit Number 44490 | ||||||||||||||
| 16983 | 46151 | Permitted Site 7 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2001 12:00:00 AM | Permit Number 44491 | ||||||||||||||
| 39140 | 66932 | Permitted Site 7 | Tree(s) :: 17 | 227 Sadowa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/1991 12:00:00 AM | Permit Number 30257 | 5994744.24759315 | 2087733.77191821 | 37.7122181232413 | -122.460010762764 | (37.7122181232413, -122.460010762764) | 9 | 8 | 6 | 28861 | 24 | |||
| 98981 | 61773 | Permitted Site 7 | Tree(s) :: 17 | 750 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/1984 12:00:00 AM | Permit Number 21792 | 5994724.03820643 | 2106068.91516158 | 37.7625607352262 | -122.461408976072 | (37.7625607352262, -122.461408976072) | 15 | 5 | 11 | 56 | 12 | |||
| 134515 | 61284 | Permitted Site 7 | Tree(s) :: 17 | 2400 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/1983 12:00:00 AM | Permit Number 21176 | 6002122.95752689 | 2117409.37301953 | 37.7941218499112 | -122.436630620215 | (37.7941218499112, -122.436630620215) | 13 | 9 | 1 | 57 | 27 | |||
| 972 | 58852 | Permitted Site 7 | Tree(s) :: 17 | 198 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/1979 12:00:00 AM | Permit Number 18111 | 6007897.70750463 | 2097731.51362688 | 37.7404175243374 | -122.415255671137 | (37.7404175243374, -122.415255671137) | 2 | 7 | 7 | 28859 | 2 | |||
| 32064 | 58854 | Permitted Site 7 | Tree(s) :: 17 | 287 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/1979 12:00:00 AM | Permit Number 18113 | 6007774.98002887 | 2097792.02872979 | 37.7405767872297 | -122.415684299392 | (37.7405767872297, -122.415684299392) | 2 | 7 | 7 | 28859 | 2 | |||
| 72401 | 58853 | Permitted Site 7 | Tree(s) :: 17 | 281 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/1979 12:00:00 AM | Permit Number 18112 | 6007777.08402884 | 2097817.17998477 | 37.7406459652911 | -122.415678804938 | (37.7406459652911, -122.415678804938) | 2 | 7 | 7 | 28859 | 2 | |||
| 76907 | 58858 | Permitted Site 7 | Tree(s) :: 17 | 306 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/1979 12:00:00 AM | Permit Number 18117 | 6007714.1149978 | 2097688.22730679 | 37.74028834982 | -122.415887399168 | (37.74028834982, -122.415887399168) | 2 | 7 | 7 | 28859 | 2 | |||
| 91347 | 58860 | Permitted Site 7 | Tree(s) :: 17 | 319 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/1979 12:00:00 AM | Permit Number 18119 | 6007761.0154104 | 2097625.09568631 | 37.7401176409551 | -122.415720766816 | (37.7401176409551, -122.415720766816) | 2 | 7 | 7 | 28859 | 2 | |||
| 105772 | 58856 | Permitted Site 7 | Tree(s) :: 17 | 300-302 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/1979 12:00:00 AM | Permit Number 18115 | 6007716.57429193 | 2097717.62567901 | 37.7403692095139 | -122.415880977126 | (37.7403692095139, -122.415880977126) | 2 | 7 | 7 | 28859 | 2 | |||
| 126126 | 58861 | Permitted Site 7 | Tree(s) :: 17 | 323 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/1979 12:00:00 AM | Permit Number 18120 | 6007759.37588099 | 2097605.4967715 | 37.7400637344962 | -122.41572504828 | (37.7400637344962, -122.41572504828) | 2 | 7 | 7 | 28859 | 2 | |||
| 139831 | 58862 | Permitted Site 7 | Tree(s) :: 17 | 324 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/1979 12:00:00 AM | Permit Number 18121 | 6007706.73711542 | 2097600.03219015 | 37.7400457707297 | -122.41590666521 | (37.7400457707297, -122.41590666521) | 2 | 7 | 7 | 28859 | 2 | |||
| 183832 | 58859 | Permitted Site 7 | Tree(s) :: 17 | 307 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/1979 12:00:00 AM | Permit Number 18118 | 6007765.93399904 | 2097683.89243531 | 37.7402793603405 | -122.415707922384 | (37.7402793603405, -122.415707922384) | 2 | 7 | 7 | 28859 | 2 | |||
| 187244 | 58855 | Permitted Site 7 | Tree(s) :: 17 | 200 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/1979 12:00:00 AM | Permit Number 18114 | 6007895.27421541 | 2097702.23885641 | 37.7403370055228 | -122.415262012696 | (37.7403370055228, -122.415262012696) | 2 | 7 | 7 | 28859 | 2 | |||
| 47494 | 57734 | Permitted Site 7 | Tree(s) :: 17 | 346 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/1976 12:00:00 AM | Permit Number 16650 | 6005449.12408773 | 2101689.9375009 | 37.7511485349208 | -122.424003340895 | (37.7511485349208, -122.424003340895) | 2 | 4 | 5 | 28859 | 19 | |||
| 84380 | 55537 | Permitted Site 7 | Tree(s) :: 17 | 40 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/1972 12:00:00 AM | Permit Number 11503 | 6000834.26746982 | 2104943.1308786 | 37.7598193893373 | -122.440195228351 | (37.7598193893373, -122.440195228351) | 2 | 4 | 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) );