trees
1,377 rows where qSpecies_id = 61
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 31977 | 141270 | DPW Maintained 1 | Tristania conferta :: 61 | 387 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5997821.2558 | 2112535.5977 | 37.7804943578687 | -122.451163251255 | (37.7804943578687, -122.451163251255) | 15 | 6 | 2 | 54 | 16 | |||
| 31982 | 141354 | DPW Maintained 1 | Tristania conferta :: 61 | 501 SCOTT ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6002138.2285 | 2110254.9329 | 37.774478444597 | -122.436065580668 | (37.774478444597, -122.436065580668) | 15 | 5 | 11 | 29492 | 10 | |||
| 32039 | 245197 | DPW Maintained 1 | Tristania conferta :: 61 | 121 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6001305.0532 | 2109199.3117 | 37.7715326038297 | -122.438872024121 | (37.7715326038297, -122.438872024121) | 15 | 5 | 11 | 29492 | 9 | |||
| 32120 | 137838 | DPW Maintained 1 | Tristania conferta :: 61 | 1800X Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6005085 | 2115443 | 37.7888905662133 | -122.426241568128 | (37.7888905662133, -122.426241568128) | 13 | 9 | 11 | 28858 | 27 | |||
| 32140 | 140396 | DPW Maintained 1 | Tristania conferta :: 61 | 1260 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6004649.1654 | 2113184.6997 | 37.7826651932841 | -122.427588539655 | (37.7826651932841, -122.427588539655) | 7 | 9 | 11 | 29490 | 41 | |||
| 32386 | 200922 | DPW Maintained 1 | Tristania conferta :: 61 | 4049 03rd St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6015633.332 | 2097648.3868 | 37.7406209920403 | -122.388502888217 | (37.7406209920403, -122.388502888217) | 10 | 3 | 8 | 58 | 1 | |||
| 32653 | 141068 | DPW Maintained 1 | Tristania conferta :: 61 | 516 Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5997528.6902 | 2112557.7643 | 37.7805384665203 | -122.45217696844 | (37.7805384665203, -122.45217696844) | 15 | 6 | 2 | 54 | 16 | |||
| 32762 | 141976 | DPW Maintained 1 | Tristania conferta :: 61 | 632 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6004632.3853 | 2111592.8247 | 37.7782933487801 | -122.427533145885 | (37.7782933487801, -122.427533145885) | 7 | 9 | 11 | 28852 | 41 | |||
| 32803 | 61380 | DPW Maintained 1 | Tristania conferta :: 61 | 200 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/1984 12:00:00 AM | 4 | Permit Number 21292 | 6014918.427 | 2115358.6091 | 37.7892097566572 | -122.392213077943 | (37.7892097566572, -122.392213077943) | 6 | 2 | 9 | 28855 | 6 | ||
| 32812 | 99009 | DPW Maintained 1 | Tristania conferta :: 61 | 2099X Beach St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 01/20/2015 12:00:00 AM | 3 | Permit Number 771149 | 6000381.4 | 2120794.3 | 37.8033168379221 | -122.442899765771 | (37.8033168379221, -122.442899765771) | 13 | 9 | 1 | 57 | 17 | ||
| 32919 | 137939 | DPW Maintained 1 | Tristania conferta :: 61 | 1788 SUTTER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6004036.2031 | 2114629.3704 | 37.7865972072742 | -122.429812204107 | (37.7865972072742, -122.429812204107) | 13 | 9 | 11 | 29490 | 27 | |||
| 32994 | 257945 | Undocumented 4 | Tristania conferta :: 61 | 901x Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005635 | 2113075 | 37.782419697088 | -122.42417016492 | (37.782419697088, -122.42417016492) | 7 | 9 | 11 | 28852 | 41 | ||||
| 33197 | 200150 | DPW Maintained 1 | Tristania conferta :: 61 | 6199 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6013507.0577 | 2091126.6395 | 37.7225955506276 | -122.395398012615 | (37.7225955506276, -122.395398012615) | 10 | 3 | 8 | 58 | 1 | |||
| 33383 | 15283 | DPW Maintained 1 | Tristania conferta :: 61 | 1600 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/12/1995 12:00:00 AM | 6 | 3x3 | 6007077.8589 | 2109462.9776 | 37.7725833140899 | -122.418922232447 | (37.7725833140899, -122.418922232447) | 8 | 2 | 9 | 28853 | 19 | ||
| 33537 | 244129 | DPW Maintained 1 | Tristania conferta :: 61 | 312 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004596.6687 | 2109503.17 | 37.7725536479568 | -122.427507793274 | (37.7725536479568, -122.427507793274) | 7 | 9 | 11 | 28852 | 10 | |||
| 33565 | 29409 | DPW Maintained 1 | Tristania conferta :: 61 | 2715X Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2006 12:00:00 AM | 6 | 3x3 | 6014989.3241 | 2090898.8532 | 37.7220524249966 | -122.390258197539 | (37.7220524249966, -122.390258197539) | 10 | 3 | 8 | 58 | 1 | ||
| 33612 | 201232 | DPW Maintained 1 | Tristania conferta :: 61 | 405 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6014397.1053 | 2114774.0503 | 37.7875757331087 | -122.393975863907 | (37.7875757331087, -122.393975863907) | 6 | 2 | 9 | 28855 | 6 | |||
| 33638 | 27330 | DPW Maintained 1 | Tristania conferta :: 61 | 348 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/12/1998 12:00:00 AM | 25 | 4X4 | 6004421.6425 | 2109483.8508 | 37.7724907010193 | -122.4281118499 | (37.7724907010193, -122.4281118499) | 7 | 9 | 11 | 28852 | 10 | ||
| 33715 | 245201 | DPW Maintained 1 | Tristania conferta :: 61 | 101 Broderick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6001321.2048 | 2109086.6996 | 37.7712243180125 | -122.438808083889 | (37.7712243180125, -122.438808083889) | 15 | 5 | 11 | 29492 | 9 | |||
| 33724 | 12273 | DPW Maintained 1 | Tristania conferta :: 61 | 721 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1991 12:00:00 AM | 12 | 3X3 | 6004895.7756 | 2111355.1796 | 37.7776557277721 | -122.426605054269 | (37.7776557277721, -122.426605054269) | 7 | 9 | 11 | 28852 | 10 | ||
| 33782 | 137840 | DPW Maintained 1 | Tristania conferta :: 61 | 1800X Pine St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6005085 | 2115443 | 37.7888905662133 | -122.426241568128 | (37.7888905662133, -122.426241568128) | 13 | 9 | 11 | 28858 | 27 | |||
| 33793 | 7014 | DPW Maintained 1 | Tristania conferta :: 61 | 1050 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2008 12:00:00 AM | 3 | 3X3 | 6002429.2937 | 2110241.5336 | 37.7744581850143 | -122.435057773101 | (37.7744581850143, -122.435057773101) | 15 | 5 | 11 | 29492 | 10 | ||
| 34013 | 199987 | DPW Maintained 1 | Tristania conferta :: 61 | 1040 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6018098.5001 | 2092201.6353 | 37.7258015841871 | -122.379600891938 | (37.7258015841871, -122.379600891938) | 10 | 3 | 8 | 58 | 1 | |||
| 34043 | 7051 | DPW Maintained 1 | Tristania conferta :: 61 | 1350 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2008 12:00:00 AM | 3 | 3X3 | 6000969.3144 | 2110039.798 | 37.773821261144 | -122.440093639062 | (37.773821261144, -122.440093639062) | 15 | 5 | 11 | 29492 | 10 | ||
| 34473 | 200927 | DPW Maintained 1 | Tristania conferta :: 61 | 4101 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6015527.5199 | 2097301.6631 | 37.7396630954752 | -122.388844549176 | (37.7396630954752, -122.388844549176) | 10 | 3 | 8 | 58 | 1 | |||
| 34786 | 6183 | DPW Maintained 1 | Tristania conferta :: 61 | 1100 Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005506.7779 | 2113443.7591 | 37.7834249780962 | -122.424639997895 | (37.7834249780962, -122.424639997895) | 7 | 9 | 11 | 28858 | 41 | |||
| 34796 | 24416 | DPW Maintained 1 | Tristania conferta :: 61 | 1625 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/1995 12:00:00 AM | 18 | 3X3 | 6005321.0617 | 2115263.3908 | 37.7884107443518 | -122.425412039373 | (37.7884107443518, -122.425412039373) | 13 | 9 | 11 | 28858 | 27 | ||
| 34964 | 245024 | DPW Maintained 1 | Tristania conferta :: 61 | 291 Broderick St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6001247.6582 | 2109580.5442 | 37.7725761073824 | -122.439097883737 | (37.7725761073824, -122.439097883737) | 15 | 5 | 11 | 29492 | 9 | |||
| 35220 | 138524 | DPW Maintained 1 | Tristania conferta :: 61 | 1606 Scott St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6001651.0494 | 2114066.6351 | 37.7849167251316 | -122.438023914313 | (37.7849167251316, -122.438023914313) | 13 | 6 | 11 | 29490 | 13 | |||
| 36114 | 10440 | DPW Maintained 1 | Tristania conferta :: 61 | 1476 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 5999041.0219 | 2108727.6134 | 37.770108370408 | -122.44666945727 | (37.770108370408, -122.44666945727) | 15 | 5 | 11 | 29492 | 9 | |||
| 36334 | 138235 | DPW Maintained 1 | Tristania conferta :: 61 | 230 Masonic Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5998964.7831 | 2112316.4696 | 37.7799580944916 | -122.447191491368 | (37.7799580944916, -122.447191491368) | 15 | 5 | 1 | 54 | 16 | |||
| 36451 | 18237 | DPW Maintained 1 | Tristania conferta :: 61 | 1790X Post St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/27/2007 12:00:00 AM | 4 | 4X4 | 6003723.9754 | 2114242.1212 | 37.7855162327444 | -122.43086478876 | (37.7855162327444, -122.43086478876) | 13 | 9 | 11 | 29490 | 13 | ||
| 36622 | 121011 | DPW Maintained 1 | Tristania conferta :: 61 | 199X Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 4x4 | 6015164.1782 | 2115507.7051 | 37.7896327822139 | -122.391373228803 | (37.7896327822139, -122.391373228803) | 6 | 2 | 9 | 28855 | 6 | |||
| 36704 | 111994 | Permitted Site 7 | Tristania conferta :: 61 | 1244 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2015 12:00:00 AM | 3 | 3x3 | 5993400.7 | 2107017.1 | 37.7650879480266 | -122.466054789326 | (37.7650879480266, -122.466054789326) | 11 | 8 | 11 | 56 | 12 | ||
| 36821 | 140399 | DPW Maintained 1 | Tristania conferta :: 61 | 650 WILLOW ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6004395.7092 | 2113101.266 | 37.7824217656528 | -122.42845944123 | (37.7824217656528, -122.42845944123) | 7 | 9 | 11 | 29490 | 41 | |||
| 36968 | 29526 | DPW Maintained 1 | Tristania conferta :: 61 | 2200X Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2006 12:00:00 AM | 4 | 2X3 | 6015798.6366 | 2092060.1318 | 37.725285925529 | -122.387541555629 | (37.725285925529, -122.387541555629) | 10 | 3 | 8 | 58 | 1 | ||
| 37021 | 95600 | DPW Maintained 1 | Tristania conferta :: 61 | 1625 Carroll Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6014023.4144 | 2092013.9314 | 37.7250605821221 | -122.393675141136 | (37.7250605821221, -122.393675141136) | 10 | 3 | 8 | 58 | 1 | |||
| 37122 | 200506 | DPW Maintained 1 | Tristania conferta :: 61 | 5835 03rd St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6013835.4074 | 2091990.0292 | 37.7249845024722 | -122.394323393224 | (37.7249845024722, -122.394323393224) | 10 | 3 | 8 | 58 | 1 | |||
| 37205 | 200987 | DPW Maintained 1 | Tristania conferta :: 61 | 75 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6015359.5453 | 2115694.8462 | 37.790157469647 | -122.390710356157 | (37.790157469647, -122.390710356157) | 6 | 2 | 9 | 28855 | 6 | |||
| 37712 | 141066 | DPW Maintained 1 | Tristania conferta :: 61 | 516 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5997568.2855 | 2112562.8407 | 37.7805546730892 | -122.452040356585 | (37.7805546730892, -122.452040356585) | 15 | 6 | 2 | 54 | 16 | |||
| 37850 | 58330 | DPW Maintained 1 | Tristania conferta :: 61 | 61 Roselyn Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/1978 12:00:00 AM | 15 | Permit Number 17355 | 5998228.2265 | 2111432.4618 | 37.7774887258067 | -122.449675837748 | (37.7774887258067, -122.449675837748) | 15 | 6 | 2 | 54 | 16 | ||
| 37861 | 138901 | DPW Maintained 1 | Tristania conferta :: 61 | 512 WEBSTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6004073.9895 | 2110663.202 | 37.7757092346813 | -122.429398532918 | (37.7757092346813, -122.429398532918) | 7 | 9 | 11 | 28852 | 10 | |||
| 37867 | 139932 | DPW Maintained 1 | Tristania conferta :: 61 | 800 GOUGH ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6005703.8894 | 2112554.5236 | 37.7809944860981 | -122.423894815633 | (37.7809944860981, -122.423894815633) | 7 | 9 | 11 | 28852 | 41 | |||
| 37913 | 25228 | DPW Maintained 1 | Tristania conferta :: 61 | 1923 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 5994038.0508 | 2092538.029 | 37.7253688193969 | -122.462799879695 | (37.7253688193969, -122.462799879695) | 9 | 8 | 4 | 59 | 40 | |||
| 37992 | 22342 | DPW Maintained 1 | Tristania conferta :: 61 | 5256 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/23/1997 12:00:00 AM | 6 | 3X3 | 6014378.1352 | 2093759.8228 | 37.7298741534257 | -122.392570970493 | (37.7298741534257, -122.392570970493) | 10 | 3 | 8 | 58 | 1 | ||
| 38204 | 41235 | DPW Maintained 1 | Tristania conferta :: 61 | 270 Masonic Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1999 12:00:00 AM | 14 | Permit Number 41940 | 5998984.5808 | 2112167.7332 | 37.7795508339841 | -122.44711229551 | (37.7795508339841, -122.44711229551) | 15 | 5 | 1 | 54 | 16 | ||
| 38253 | 24498 | DPW Maintained 1 | Tristania conferta :: 61 | 849 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/2008 12:00:00 AM | 6 | 3X3 | 6003351.2628 | 2110317.6455 | 37.7747194775899 | -122.43187394371 | (37.7747194775899, -122.43187394371) | 15 | 9 | 11 | 29492 | 10 | ||
| 38347 | 247255 | DPW Maintained 1 | Tristania conferta :: 61 | 2027 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5997293.757 | 2109123.4893 | 37.7710953802668 | -122.452741770892 | (37.7710953802668, -122.452741770892) | 15 | 5 | 11 | 29492 | 9 | |||
| 38745 | 199701 | DPW Maintained 1 | Tristania conferta :: 61 | 1920 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6016301.5318 | 2092737.8037 | 37.7271745209486 | -122.385850293459 | (37.7271745209486, -122.385850293459) | 10 | 3 | 8 | 58 | 1 | |||
| 38816 | 12338 | DPW Maintained 1 | Tristania conferta :: 61 | 1151X Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/10/1997 12:00:00 AM | 12 | 3X3 | 6004696.7001 | 2112810.35 | 37.7816400103646 | -122.427397413482 | (37.7816400103646, -122.427397413482) | 7 | 9 | 11 | 29490 | 41 | ||
| 39132 | 143429 | DPW Maintained 1 | Tristania conferta :: 61 | 855 SACRAMENTO ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6010687.6362 | 2116910.2621 | 37.7932344012545 | -122.406960577759 | (37.7932344012545, -122.406960577759) | 3 | 1 | 10 | 28857 | 4 | |||
| 39184 | 6318 | DPW Maintained 1 | Tristania conferta :: 61 | 1860 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002006.0106 | 2112955.7484 | 37.7818866924078 | -122.436716317501 | (37.7818866924078, -122.436716317501) | 15 | 5 | 11 | 29490 | 41 | |||
| 39428 | 24489 | DPW Maintained 1 | Tristania conferta :: 61 | 840 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2006 12:00:00 AM | 3 | 3X3 | 6003385.8226 | 2110373.2704 | 37.774874168918 | -122.431758366815 | (37.774874168918, -122.431758366815) | 15 | 9 | 11 | 29492 | 10 | ||
| 39673 | 247284 | DPW Maintained 1 | Tristania conferta :: 61 | 1432 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5999197.6689 | 2108750.6497 | 37.7701805691053 | -122.446129276415 | (37.7701805691053, -122.446129276415) | 15 | 5 | 11 | 29492 | 9 | |||
| 39999 | 138914 | DPW Maintained 1 | Tristania conferta :: 61 | 715 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6004339.5104 | 2110805.84 | 37.7761159127531 | -122.428490199112 | (37.7761159127531, -122.428490199112) | 7 | 9 | 11 | 28852 | 10 | |||
| 40297 | 10406 | DPW Maintained 1 | Tristania conferta :: 61 | 1386 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2007 12:00:00 AM | 3 | 3x3 | 5999529.6926 | 2108795.3635 | 37.7703222971334 | -122.444984028084 | (37.7703222971334, -122.444984028084) | 15 | 5 | 11 | 29492 | 9 | ||
| 40506 | 200918 | DPW Maintained 1 | Tristania conferta :: 61 | 3801 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6015708.4397 | 2097905.3591 | 37.7413307472539 | -122.388261122371 | (37.7413307472539, -122.388261122371) | 10 | 3 | 8 | 58 | 1 | |||
| 40758 | 139813 | DPW Maintained 1 | Tristania conferta :: 61 | 1624 EDDY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6002704.9363 | 2112706.5853 | 37.7812422487992 | -122.434280542357 | (37.7812422487992, -122.434280542357) | 15 | 5 | 11 | 29490 | 41 | |||
| 40794 | 246029 | DPW Maintained 1 | Tristania conferta :: 61 | 1350 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5999219.3519 | 2108402.0622 | 37.7692246742742 | -122.446029198985 | (37.7692246742742, -122.446029198985) | 15 | 5 | 11 | 29492 | 9 | |||
| 40818 | 22363 | DPW Maintained 1 | Tristania conferta :: 61 | 5307X 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/29/1992 12:00:00 AM | 5 | 3x3 | 6014340.3596 | 2093332.2076 | 37.728697910554 | -122.392671664285 | (37.728697910554, -122.392671664285) | 10 | 3 | 8 | 58 | 1 | ||
| 40821 | 140557 | DPW Maintained 1 | Tristania conferta :: 61 | 1175 MCALLISTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6003583.5208 | 2111740.6921 | 37.7786399751241 | -122.43117211119 | (37.7786399751241, -122.43117211119) | 15 | 9 | 11 | 29492 | 41 | |||
| 40994 | 7057 | DPW Maintained 1 | Tristania conferta :: 61 | 1390 Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/13/1990 12:00:00 AM | 12 | 3X3 | 6000831.7617 | 2110022.9142 | 37.7737670706815 | -122.440568243599 | (37.7737670706815, -122.440568243599) | 15 | 5 | 11 | 29492 | 10 | ||
| 41026 | 138710 | DPW Maintained 1 | Tristania conferta :: 61 | 2699 BUSH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6000650.0889 | 2114452.8379 | 37.7859201640241 | -122.4415146292 | (37.7859201640241, -122.4415146292) | 15 | 6 | 1 | 29490 | 27 | |||
| 41040 | 247485 | DPW Maintained 1 | Tristania conferta :: 61 | 780 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6002841.2579 | 2109599.114 | 37.7727176432561 | -122.43358679066 | (37.7727176432561, -122.43358679066) | 15 | 5 | 11 | 29492 | 9 | |||
| 41127 | 22494 | DPW Maintained 1 | Tristania conferta :: 61 | 6315 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6013237.8961 | 2090421.2401 | 37.7206436914379 | -122.396279035367 | (37.7206436914379, -122.396279035367) | 10 | 3 | 8 | 58 | 1 | |||
| 41978 | 142365 | DPW Maintained 1 | Tristania conferta :: 61 | 1135 ELLIS ST | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6005547.6156 | 2113403.0804 | 37.7833155906951 | -122.424495820848 | (37.7833155906951, -122.424495820848) | 7 | 9 | 11 | 28858 | 41 | |||
| 42123 | 140638 | DPW Maintained 1 | Tristania conferta :: 61 | 472 Stanyan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5996864.7991 | 2109972.3061 | 37.7734014220919 | -122.454286863982 | (37.7734014220919, -122.454286863982) | 15 | 5 | 2 | 29492 | 16 | |||
| 42168 | 247484 | DPW Maintained 1 | Tristania conferta :: 61 | 314 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6002751.2637 | 2109649.3433 | 37.7728504539216 | -122.433901681113 | (37.7728504539216, -122.433901681113) | 15 | 5 | 11 | 29492 | 9 | |||
| 42383 | 200998 | DPW Maintained 1 | Tristania conferta :: 61 | 200 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6014896.8338 | 2115334.9594 | 37.7891436210461 | -122.392286133642 | (37.7891436210461, -122.392286133642) | 6 | 2 | 9 | 28855 | 6 | |||
| 42452 | 13177 | DPW Maintained 1 | Tristania conferta :: 61 | 1970 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/13/1995 12:00:00 AM | 35 | 3x3 | 6002925.1953 | 2119612.072 | 37.8002154469875 | -122.434012323171 | (37.8002154469875, -122.434012323171) | 13 | 9 | 1 | 57 | 17 | ||
| 42460 | 142016 | DPW Maintained 1 | Tristania conferta :: 61 | 721 LAGUNA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6004898.2842 | 2111330.7203 | 37.7775887103504 | -122.426594634026 | (37.7775887103504, -122.426594634026) | 7 | 9 | 11 | 28852 | 10 | |||
| 42714 | 199905 | DPW Maintained 1 | Tristania conferta :: 61 | 1298 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6016747.5421 | 2093255.8132 | 37.7286215447387 | -122.384344487326 | (37.7286215447387, -122.384344487326) | 10 | 3 | 8 | 58 | 1 | |||
| 42747 | 9669 | DPW Maintained 1 | Tristania conferta :: 61 | 203 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/07/1995 12:00:00 AM | 18 | 3X3 | 6006010.537 | 2110311.0286 | 37.7748517007261 | -122.42267449095 | (37.7748517007261, -122.42267449095) | 7 | 9 | 11 | 28852 | 10 | ||
| 42759 | 13242 | DPW Maintained 1 | Tristania conferta :: 61 | 2353 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6001124.6106 | 2119280.6018 | 37.7992029678306 | -122.440219251047 | (37.7992029678306, -122.440219251047) | 13 | 9 | 1 | 57 | 17 | |||
| 43134 | 140034 | DPW Maintained 1 | Tristania conferta :: 61 | 950 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6001975.5646 | 2111780.2801 | 37.7786574230551 | -122.436737476963 | (37.7786574230551, -122.436737476963) | 15 | 5 | 11 | 29490 | 41 | |||
| 43164 | 15285 | DPW Maintained 1 | Tristania conferta :: 61 | 1600 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/12/1995 12:00:00 AM | 6 | 3x3 | 6007055.561 | 2109424.3851 | 37.7724760926839 | -122.4189966256 | (37.7724760926839, -122.4189966256) | 8 | 2 | 9 | 28853 | 19 | ||
| 43265 | 141978 | DPW Maintained 1 | Tristania conferta :: 61 | 660 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6004530.1468 | 2111579.6326 | 37.7782513432629 | -122.427885886468 | (37.7782513432629, -122.427885886468) | 7 | 9 | 11 | 28852 | 41 | |||
| 43274 | 22409 | DPW Maintained 1 | Tristania conferta :: 61 | 5800 03rd St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53653 | 6013757.7359 | 2092026.1961 | 37.7250794916417 | -122.394594428416 | (37.7250794916417, -122.394594428416) | 10 | 3 | 8 | 58 | 1 | |
| 43598 | 138224 | DPW Maintained 1 | Tristania conferta :: 61 | 101 Anza St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5998591.1654 | 2112638.1395 | 37.7808199616553 | -122.448507168982 | (37.7808199616553, -122.448507168982) | 15 | 6 | 2 | 54 | 16 | |||
| 43808 | 115203 | DPW Maintained 1 | Tristania conferta :: 61 | 2056 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/22/2018 12:00:00 AM | 3 | Permit Number 769837 | 6001029.7 | 2112838.5 | 37.7815092255851 | -122.440085481713 | (37.7815092255851, -122.440085481713) | 15 | 5 | 11 | 29490 | 41 | ||
| 43974 | 138903 | DPW Maintained 1 | Tristania conferta :: 61 | 518 WEBSTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6004068.2974 | 2110700.7031 | 37.7758118812147 | -122.42942089821 | (37.7758118812147, -122.42942089821) | 7 | 9 | 11 | 28852 | 10 | |||
| 44104 | 138220 | DPW Maintained 1 | Tristania conferta :: 61 | 101 Anza St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5998691.3383 | 2112654.3837 | 37.7808702910352 | -122.448161793593 | (37.7808702910352, -122.448161793593) | 15 | 6 | 2 | 54 | 16 | |||
| 44284 | 200765 | DPW Maintained 1 | Tristania conferta :: 61 | 5273 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6014441.0884 | 2093674.9472 | 37.7296445981441 | -122.392347398149 | (37.7296445981441, -122.392347398149) | 10 | 3 | 8 | 58 | 1 | |||
| 44329 | 54243 | DPW Maintained 1 | Tristania conferta :: 61 | 35 Kittredge Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/1972 12:00:00 AM | 26 | Permit Number 9984 | 5997958.8776 | 2111479.5979 | 37.7776027359423 | -122.450610999735 | (37.7776027359423, -122.450610999735) | 15 | 6 | 2 | 54 | 16 | ||
| 44515 | 10687 | DPW Maintained 1 | Tristania conferta :: 61 | 1185 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6002205.7566 | 2110510.4768 | 37.7751839405685 | -122.435850276383 | (37.7751839405685, -122.435850276383) | 15 | 5 | 11 | 29492 | 10 | |||
| 44579 | 24261 | DPW Maintained 1 | Tristania conferta :: 61 | 600X Willow St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/19/2004 12:00:00 AM | 5 | 3X3 | 6004538.0187 | 2113122.6754 | 37.7824886025731 | -122.427968638693 | (37.7824886025731, -122.427968638693) | 7 | 9 | 11 | 29490 | 41 | ||
| 44590 | 22496 | DPW Maintained 1 | Tristania conferta :: 61 | 6321 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/03/2011 12:00:00 AM | 3 | 3x3 | 6013227.4986 | 2090389.3545 | 37.7205555613998 | -122.396312742847 | (37.7205555613998, -122.396312742847) | 10 | 3 | 8 | 58 | 1 | ||
| 44666 | 22384 | DPW Maintained 1 | Tristania conferta :: 61 | 5600 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/1995 12:00:00 AM | 6 | 3X3 | 6014013.8928 | 2092684.7819 | 37.7269020734593 | -122.39375499095 | (37.7269020734593, -122.39375499095) | 10 | 3 | 8 | 58 | 1 | ||
| 44853 | 22403 | DPW Maintained 1 | Tristania conferta :: 61 | 5800 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/1995 12:00:00 AM | 4 | 3X3 | 6013795.569 | 2092117.5258 | 37.7253323678743 | -122.394470034522 | (37.7253323678743, -122.394470034522) | 10 | 3 | 8 | 58 | 1 | ||
| 44887 | 29426 | DPW Maintained 1 | Tristania conferta :: 61 | 2501X Ingalls St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2006 12:00:00 AM | 6 | 3x3 | 6015353.5854 | 2091384.7495 | 37.723406798628 | -122.389032933904 | (37.723406798628, -122.389032933904) | 10 | 3 | 8 | 58 | 1 | ||
| 44914 | 199655 | DPW Maintained 1 | Tristania conferta :: 61 | 2798 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6014883.1348 | 2090822.9118 | 37.7218380142362 | -122.390619966673 | (37.7218380142362, -122.390619966673) | 10 | 3 | 8 | 58 | 1 | |||
| 44952 | 200910 | DPW Maintained 1 | Tristania conferta :: 61 | 3801 03rd St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6015813.5433 | 2098253.2638 | 37.7422918453939 | -122.387921978414 | (37.7422918453939, -122.387921978414) | 10 | 3 | 8 | 58 | 1 | |||
| 45018 | 244322 | DPW Maintained 1 | Tristania conferta :: 61 | 255 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005988.2373 | 2110510.0695 | 37.7753969608082 | -122.422765778568 | (37.7753969608082, -122.422765778568) | 7 | 9 | 11 | 28852 | 10 | |||
| 45104 | 253527 | DPW Maintained 1 | Tristania conferta :: 61 | 100 Haight St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/19/2017 09:54:00 AM | 3 | 3X3 | 6005589.149 | 2109643.5092 | 37.7729950707153 | -122.424084680793 | (37.7729950707153, -122.424084680793) | 7 | 9 | 11 | 28852 | 10 | ||
| 45358 | 18082 | DPW Maintained 1 | Tristania conferta :: 61 | 2970 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/17/2009 12:00:00 AM | 6 | 3X3 | 5999722.7619 | 2114728.5921 | 37.7866244385926 | -122.444742742308 | (37.7866244385926, -122.444742742308) | 15 | 6 | 1 | 29490 | 31 | ||
| 45411 | 199928 | DPW Maintained 1 | Tristania conferta :: 61 | 1801 Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 02/27/2008 12:00:00 AM | 4 | Width 0ft | 6016476.4427 | 2092884.9162 | 37.7275881406952 | -122.385255868852 | (37.7275881406952, -122.385255868852) | 10 | 3 | 8 | 58 | 1 | ||
| 45530 | 199910 | DPW Maintained 1 | Tristania conferta :: 61 | 1733 Ingalls St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6016580.0023 | 2093030.3404 | 37.7279931754204 | -122.384907985938 | (37.7279931754204, -122.384907985938) | 10 | 3 | 8 | 58 | 1 | |||
| 45583 | 142370 | DPW Maintained 1 | Tristania conferta :: 61 | 1041 Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6005599.4645 | 2113294.0647 | 37.7830191883263 | -122.424308687896 | (37.7830191883263, -122.424308687896) | 7 | 9 | 11 | 28858 | 41 | |||
| 45863 | 1667 | DPW Maintained 1 | Tristania conferta :: 61 | 1400X Fell St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/2006 12:00:00 AM | 3 | 3X3 | 6000310.2061 | 2109949.902 | 37.7735368845497 | -122.442367139239 | (37.7735368845497, -122.442367139239) | 15 | 5 | 11 | 29492 | 16 | ||
| 45944 | 200662 | DPW Maintained 1 | Tristania conferta :: 61 | 1532 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6015174.2771 | 2095413.8657 | 37.734460003731 | -122.389934087199 | (37.734460003731, -122.389934087199) | 10 | 3 | 8 | 58 | 1 |
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) );