trees
254 rows where qSpecies_id = 78 sorted by PlotSize 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 97214 | 136295 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2600x Van Ness Ave | 4 | Median : Yard | Tree | DPW 1 | 16 | Width 8ft | 6005728.53037 | 2119520.31629 | 37.8001222024312 | -122.424305148569 | (37.8001222024312, -122.424305148569) | 13 | 9 | 1 | 28858 | 32 | |||
| 45458 | 136290 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 401 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6006768.37866 | 2112062.50938 | 37.7797035719992 | -122.420177283766 | (37.7797035719992, -122.420177283766) | 7 | 9 | 9 | 28852 | 36 | |||
| 67441 | 136291 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 401 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6006783.12153 | 2111963.42533 | 37.779432341874 | -122.420119247825 | (37.779432341874, -122.420119247825) | 7 | 9 | 9 | 28852 | 36 | |||
| 72255 | 240350 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 4746 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5998436.06596 | 2105691.7221 | 37.7617380052332 | -122.448543308522 | (37.7617380052332, -122.448543308522) | 15 | 5 | 11 | 29492 | 9 | |||
| 77040 | 240349 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 4736 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 4ft | 5998465.34509 | 2105692.76775 | 37.7617425503974 | -122.448442119502 | (37.7617425503974, -122.448442119502) | 15 | 5 | 11 | 29492 | 9 | |||
| 97907 | 136292 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 401 Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6006812.66695 | 2111768.16026 | 37.7788978558793 | -122.420003176823 | (37.7788978558793, -122.420003176823) | 7 | 9 | 9 | 28852 | 36 | |||
| 160117 | 197267 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 822 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6015954.57272 | 2096709.3738 | 37.7380604502387 | -122.387326664599 | (37.7380604502387, -122.387326664599) | 10 | 3 | 8 | 58 | 1 | |||
| 565 | 170476 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 46 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 3ft | 6003788.04729 | 2094625.21712 | 37.7316565146416 | -122.429243816075 | (37.7316565146416, -122.429243816075) | 9 | 7 | 5 | 28861 | 25 | ||
| 1983 | 197256 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1320 Hudson Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6018044.32152 | 2094632.22344 | 37.732472518087 | -122.379956998329 | (37.732472518087, -122.379956998329) | 10 | 3 | 8 | 58 | 1 | |||
| 3911 | 197246 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1339 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017203.85974 | 2095339.70133 | 37.7343687116489 | -122.382911921471 | (37.7343687116489, -122.382911921471) | 10 | 3 | 8 | 58 | 1 | |||
| 14458 | 197268 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 623 Mendell St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6016457.45945 | 2097300.20103 | 37.7397105802781 | -122.385629084527 | (37.7397105802781, -122.385629084527) | 10 | 3 | 8 | 58 | 1 | |||
| 17414 | 197269 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 623 Mendell St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6016467.03521 | 2097318.03546 | 37.7397600798502 | -122.385597217932 | (37.7397600798502, -122.385597217932) | 10 | 3 | 8 | 58 | 1 | |||
| 20280 | 197247 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1339 Hudson Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017256.12018 | 2095247.45205 | 37.7341183008123 | -122.382724821107 | (37.7341183008123, -122.382724821107) | 10 | 3 | 8 | 58 | 1 | |||
| 21876 | 240353 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 671 Church St | 10 | Front Yard : Yard | Tree | Private 2 | 29 | Width 3ft | 6004318.10753 | 2104946.36781 | 37.7600260063222 | -122.428146563117 | (37.7600260063222, -122.428146563117) | 2 | 4 | 5 | 28862 | 3 | |||
| 23991 | 197244 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 401 Mendell St | 3 | : | Tree | Private 2 | 3 | Width 3ft | 6016639.49339 | 2097549.35813 | 37.7404047858594 | -122.385017037417 | (37.7404047858594, -122.385017037417) | 10 | 3 | 8 | 58 | 1 | |||
| 29767 | 240355 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 671 Church St | 18 | Front Yard : Yard | Tree | Private 2 | 19 | Width 3ft | 6004321.65497 | 2104972.99929 | 37.7600993307501 | -122.428136192147 | (37.7600993307501, -122.428136192147) | 2 | 4 | 5 | 28862 | 3 | |||
| 30444 | 240358 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 671 Church St | 23 | Front Yard : Yard | Tree | Private 2 | 8 | Width 3ft | 6004302.67089 | 2105008.50736 | 37.760195753352 | -122.428204379638 | (37.760195753352, -122.428204379638) | 2 | 4 | 5 | 28862 | 3 | |||
| 30660 | 240354 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 671 Church St | 17 | Front Yard : Yard | Tree | Private 2 | 13 | Width 3ft | 6004324.4915 | 2104963.90622 | 37.7600745238281 | -122.428125733918 | (37.7600745238281, -122.428125733918) | 2 | 4 | 5 | 28862 | 3 | |||
| 33129 | 240361 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 138 Laidley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6003708.02517 | 2097591.62928 | 37.7397970779748 | -122.429731967151 | (37.7397970779748, -122.429731967151) | 2 | 7 | 5 | 63 | 7 | |||
| 36362 | 197234 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1201 Illinois St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6016171.82655 | 2103275.37534 | 37.7561013622073 | -122.387033327344 | (37.7561013622073, -122.387033327344) | 10 | 3 | 8 | 28856 | 29 | |||
| 38770 | 197242 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 151 Mendell St | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6017080.03361 | 2098493.68243 | 37.7430220675307 | -122.383559533147 | (37.7430220675307, -122.383559533147) | 10 | 3 | 8 | 58 | 1 | |||
| 39591 | 197240 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 301 Mendell St | 8 | : | Tree | Private 2 | 3 | Width 3ft | 6016921.73157 | 2097930.91265 | 37.7414680650873 | -122.384067722948 | (37.7414680650873, -122.384067722948) | 10 | 3 | 8 | 58 | 1 | |||
| 45179 | 197263 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1322 Hudson Ave | 54 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017252.47245 | 2095336.30143 | 37.7343620620475 | -122.382743613324 | (37.7343620620475, -122.382743613324) | 10 | 3 | 8 | 58 | 1 | |||
| 49522 | 197273 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 618 Mendell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6016318.01168 | 2097190.59348 | 37.7394019032644 | -122.386103601013 | (37.7394019032644, -122.386103601013) | 10 | 3 | 8 | 58 | 1 | |||
| 50113 | 197251 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1333 Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017752.42929 | 2094673.2277 | 37.7325690009549 | -122.380968999147 | (37.7325690009549, -122.380968999147) | 10 | 3 | 8 | 58 | 1 | |||
| 51144 | 197259 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1322 Hudson Ave | 31 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017468.44354 | 2094985.48685 | 37.7334107241212 | -122.381972529223 | (37.7334107241212, -122.381972529223) | 10 | 3 | 8 | 58 | 1 | |||
| 52056 | 197248 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1339 Hudson Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017268.43044 | 2095223.81244 | 37.7340540712292 | -122.382680615833 | (37.7340540712292, -122.382680615833) | 10 | 3 | 8 | 58 | 1 | |||
| 52600 | 179364 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2300 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6010224.85869 | 2095626.21613 | 37.7347673433273 | -122.407060901965 | (37.7347673433273, -122.407060901965) | 10 | 3 | 7 | 309 | 28 | |||
| 60358 | 179368 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2302 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6010304.52848 | 2095452.39798 | 37.7342945337677 | -122.406773208834 | (37.7342945337677, -122.406773208834) | 10 | 3 | 7 | 309 | 28 | |||
| 65290 | 197236 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1101 Illinois St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6016150.08513 | 2103652.13569 | 37.7571346625573 | -122.38713479513 | (37.7571346625573, -122.38713479513) | 10 | 3 | 8 | 28856 | 29 | |||
| 65712 | 197270 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 621 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6016507.88272 | 2097368.67206 | 37.7399013777473 | -122.385459511073 | (37.7399013777473, -122.385459511073) | 10 | 3 | 8 | 58 | 1 | |||
| 66294 | 197233 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1201 Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6016183.78444 | 2103092.78575 | 37.7556006718551 | -122.386979238508 | (37.7556006718551, -122.386979238508) | 10 | 3 | 8 | 28856 | 29 | |||
| 70692 | 240357 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 671 Church St | 20 | Front Yard : Yard | Tree | Private 2 | 12 | Width 3ft | 6004316.61445 | 2104979.98621 | 37.7601182299832 | -122.428154122837 | (37.7601182299832, -122.428154122837) | 2 | 4 | 5 | 28862 | 3 | |||
| 71515 | 197261 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1322 Hudson Ave | 41 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6017380.57172 | 2095099.80246 | 37.7337197590624 | -122.382284280115 | (37.7337197590624, -122.382284280115) | 10 | 3 | 8 | 58 | 1 | |||
| 75037 | 214008 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 222 Sadowa St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5994773.56041 | 2087779.1496 | 37.7123444055547 | -122.459912734779 | (37.7123444055547, -122.459912734779) | 9 | 8 | 6 | 28861 | 24 | |||
| 75684 | 197245 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 401 Mendell St | 5 | : | Tree | Private 2 | 6 | Width 3ft | 6016656.39457 | 2097572.22784 | 37.7404685163083 | -122.38496019216 | (37.7404685163083, -122.38496019216) | 10 | 3 | 8 | 58 | 1 | |||
| 75830 | 197264 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1322 Hudson Ave | 55 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017243.9601 | 2095358.62855 | 37.734422897596 | -122.382774596779 | (37.734422897596, -122.382774596779) | 10 | 3 | 8 | 58 | 1 | |||
| 77159 | 240356 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 671 Church St | 19 | Front Yard : Yard | Tree | Private 2 | 18 | Width 3ft | 6004321.88535 | 2104984.17972 | 37.760130042589 | -122.428136192158 | (37.760130042589, -122.428136192158) | 2 | 4 | 5 | 28862 | 3 | |||
| 77492 | 197255 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1320 Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6018070.99696 | 2094637.60558 | 37.7324887679223 | -122.379865147852 | (37.7324887679223, -122.379865147852) | 10 | 3 | 8 | 58 | 1 | |||
| 81664 | 197243 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 401 Mendell St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6016629.41985 | 2097534.84725 | 37.7403643847096 | -122.385050857321 | (37.7403643847096, -122.385050857321) | 10 | 3 | 8 | 58 | 1 | |||
| 82383 | 197225 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 670 Illinois St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6015963.59101 | 2106011.38061 | 37.7636023160031 | -122.387944392722 | (37.7636023160031, -122.387944392722) | 14 | 3 | 8 | 28856 | 29 | |||
| 90584 | 197232 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 670 Illinois St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015969.52981 | 2105893.92675 | 37.7632801419786 | -122.38791565581 | (37.7632801419786, -122.38791565581) | 14 | 3 | 8 | 28856 | 29 | |||
| 92011 | 179362 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2300 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6010207.20881 | 2095669.3235 | 37.7348847192535 | -122.407124961546 | (37.7348847192535, -122.407124961546) | 10 | 3 | 7 | 309 | 28 | |||
| 92029 | 197235 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1101 Illinois St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6016151.23089 | 2103629.88261 | 37.7570736237573 | -122.387129280509 | (37.7570736237573, -122.387129280509) | 10 | 3 | 8 | 28856 | 29 | |||
| 95650 | 240351 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 4090 20th St | 1 | : Yard | Tree | Private 2 | 22 | Width 3ft | 6003153.88022 | 2104182.56452 | 37.7578628454134 | -122.432118516979 | (37.7578628454134, -122.432118516979) | 2 | 4 | 5 | 28862 | 3 | |||
| 96726 | 197266 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 818 Mendell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6015992.31531 | 2096760.75352 | 37.738203618709 | -122.387199751367 | (37.738203618709, -122.387199751367) | 10 | 3 | 8 | 58 | 1 | |||
| 100005 | 179370 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2302 San Bruno Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010321.94566 | 2095411.61629 | 37.7341835304417 | -122.406710118682 | (37.7341835304417, -122.406710118682) | 10 | 3 | 7 | 309 | 28 | |||
| 103538 | 197252 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1333 Hudson Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017782.90663 | 2094656.28102 | 37.7325241508658 | -122.38086245284 | (37.7325241508658, -122.38086245284) | 10 | 3 | 8 | 58 | 1 | |||
| 109059 | 197227 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 670 Illinois St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6015965.05283 | 2105966.21151 | 37.7634783723591 | -122.38793618463 | (37.7634783723591, -122.38793618463) | 14 | 3 | 8 | 28856 | 29 | |||
| 109788 | 197230 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 670 Illinois St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6015968.5174 | 2105926.2015 | 37.7633687054139 | -122.387921409661 | (37.7633687054139, -122.387921409661) | 14 | 3 | 8 | 28856 | 29 | |||
| 110571 | 240362 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 138 Laidley St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003721.38231 | 2097581.21775 | 37.7397692466514 | -122.429685041427 | (37.7397692466514, -122.429685041427) | 2 | 7 | 5 | 63 | 7 | |||
| 115457 | 197257 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1322 Hudson Ave | 26 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017533.22144 | 2094905.154 | 37.733193723116 | -122.381742986272 | (37.733193723116, -122.381742986272) | 10 | 3 | 8 | 58 | 1 | |||
| 119990 | 179367 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2302 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010293.44641 | 2095472.02067 | 37.7343477934225 | -122.406812905791 | (37.7343477934225, -122.406812905791) | 10 | 3 | 7 | 309 | 28 | |||
| 125089 | 197271 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 621 Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6016522.12387 | 2097389.36221 | 37.7399589766173 | -122.385411712102 | (37.7399589766173, -122.385411712102) | 10 | 3 | 8 | 58 | 1 | |||
| 129947 | 240359 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 671 Church St | 24 | Front Yard : Yard | Tree | Private 2 | 12 | Width 3ft | 6004303.32084 | 2105026.7227 | 37.7602458051206 | -122.428203429952 | (37.7602458051206, -122.428203429952) | 2 | 4 | 5 | 28862 | 3 | |||
| 131145 | 197237 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1101 Illinois St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6016149.20682 | 2103671.84274 | 37.7571887253073 | -122.387139207224 | (37.7571887253073, -122.387139207224) | 10 | 3 | 8 | 28856 | 29 | |||
| 131442 | 197258 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1322 Hudson Ave | 27 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6017525.05376 | 2094913.62104 | 37.7332165209287 | -122.381771813133 | (37.7332165209287, -122.381771813133) | 10 | 3 | 8 | 58 | 1 | |||
| 132053 | 179369 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2302 San Bruno Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010313.94209 | 2095431.38029 | 37.7342373503731 | -122.406739182082 | (37.7342373503731, -122.406739182082) | 10 | 3 | 7 | 309 | 28 | |||
| 135673 | 197272 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 621 Mendell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6016550.5665 | 2097428.77687 | 37.7400687748538 | -122.385316114164 | (37.7400687748538, -122.385316114164) | 10 | 3 | 8 | 58 | 1 | |||
| 141560 | 197253 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1333 Hudson Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017800.41079 | 2094649.24699 | 37.7325058028811 | -122.380801447334 | (37.7325058028811, -122.380801447334) | 10 | 3 | 8 | 58 | 1 | |||
| 144852 | 179366 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2300 San Bruno Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010245.15068 | 2095586.70884 | 37.7346600002662 | -122.406987961537 | (37.7346600002662, -122.406987961537) | 10 | 3 | 7 | 309 | 28 | |||
| 146620 | 197228 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 670 Illinois St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6015966.4036 | 2105950.82285 | 37.7634361932415 | -122.387930438833 | (37.7634361932415, -122.387930438833) | 14 | 3 | 8 | 28856 | 29 | |||
| 147723 | 197229 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 670 Illinois St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015967.79725 | 2105937.55997 | 37.7633998534335 | -122.387924693077 | (37.7633998534335, -122.387924693077) | 14 | 3 | 8 | 28856 | 29 | |||
| 147785 | 197260 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1322 Hudson Ave | 40 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6017393.35703 | 2095090.62772 | 37.7336952732179 | -122.382239439017 | (37.7336952732179, -122.382239439017) | 10 | 3 | 8 | 58 | 1 | |||
| 148351 | 179365 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2300 San Bruno Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010237.42069 | 2095603.49038 | 37.7347056462347 | -122.407015869312 | (37.7347056462347, -122.407015869312) | 10 | 3 | 7 | 309 | 28 | |||
| 148755 | 197250 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1337 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017426.32364 | 2094968.1062 | 37.7333606741381 | -122.382116942362 | (37.7333606741381, -122.382116942362) | 10 | 3 | 8 | 58 | 1 | |||
| 154453 | 197238 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1101 Illinois St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6016145.70434 | 2103719.54836 | 37.7573195208837 | -122.387154647679 | (37.7573195208837, -122.387154647679) | 10 | 3 | 8 | 28856 | 29 | |||
| 154737 | 179363 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2300 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010218.26631 | 2095644.80145 | 37.7348180057356 | -122.407085003796 | (37.7348180057356, -122.407085003796) | 10 | 3 | 7 | 309 | 28 | |||
| 158925 | 197241 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 201 Mendell St | 3 | : | Tree | Private 2 | 3 | Width 3ft | 6016985.47526 | 2098058.34628 | 37.7418214959701 | -122.383856188014 | (37.7418214959701, -122.383856188014) | 10 | 3 | 8 | 58 | 1 | |||
| 158965 | 197249 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1339 Hudson Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017286.5777 | 2095179.92105 | 37.733934556716 | -122.382614821425 | (37.733934556716, -122.382614821425) | 10 | 3 | 8 | 58 | 1 | |||
| 160784 | 197265 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1328 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017187.84442 | 2095472.38417 | 37.7347321474566 | -122.382976523354 | (37.7347321474566, -122.382976523354) | 10 | 3 | 8 | 58 | 1 | |||
| 163343 | 197226 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 670 Illinois St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015965.03581 | 2105988.90006 | 37.7635406692923 | -122.387937826789 | (37.7635406692923, -122.387937826789) | 14 | 3 | 8 | 28856 | 29 | |||
| 166337 | 240360 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 138 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6003696.80727 | 2097599.26117 | 37.7398173981643 | -122.429771298113 | (37.7398173981643, -122.429771298113) | 2 | 7 | 5 | 63 | 7 | |||
| 166919 | 197231 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 670 Illinois St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015968.40199 | 2105908.71514 | 37.7633206852369 | -122.387920588579 | (37.7633206852369, -122.387920588579) | 14 | 3 | 8 | 28856 | 29 | |||
| 172174 | 214009 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1298x Plymouth Ave | 1 | Median : Cutout | Tree | DPW 1 | 7 | Width 3ft | 5995820.98998 | 2092615.99547 | 37.7256854263362 | -122.456642099278 | (37.7256854263362, -122.456642099278) | 9 | 7 | 4 | 28861 | 40 | |||
| 181525 | 197254 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1333 Hudson Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017901.24331 | 2094608.61235 | 37.7323997926186 | -122.380450018371 | (37.7323997926186, -122.380450018371) | 10 | 3 | 8 | 58 | 1 | |||
| 185478 | 240352 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 671 Church St | 9 | Front Yard : Yard | Tree | Private 2 | 18 | Width 3ft | 6004316.09652 | 2104917.27177 | 37.7599460017266 | -122.428151444657 | (37.7599460017266, -122.428151444657) | 2 | 4 | 5 | 28862 | 3 | |||
| 191501 | 197262 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1322 Hudson Ave | 46 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017335.88738 | 2095181.6845 | 37.7339421227254 | -122.382444463752 | (37.7339421227254, -122.382444463752) | 10 | 3 | 8 | 58 | 1 | |||
| 149866 | 240363 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 19 Ohlone Way | 1 | Back Yard : Yard | Tree | Private 2 | 3 | Width 2ft | 6002113.49716 | 2096265.44164 | 37.7360652530044 | -122.435150333941 | (37.7360652530044, -122.435150333941) | 2 | 7 | 5 | 63 | 7 | |||
| 94362 | 179342 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 700x Mansell St | 45 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 6009054.2584 | 2089931.43239 | 37.7190650967554 | -122.410706045769 | (37.7190650967554, -122.410706045769) | 9 | 3 | 8 | 309 | 18 | |||
| 20823 | 23388 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1500X Van Ness Ave | 1 | Median : Cutout | Tree | DPW 1 | 06/09/2005 12:00:00 AM | 6 | G | 6006302.3156668 | 2115604.1529311 | 37.789401783497 | -122.42204126893 | (37.789401783497, -122.42204126893) | 13 | 9 | 10 | 28858 | 21 | ||
| 48159 | 23340 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1202X Van Ness Ave | 3 | Median : Cutout | Tree | DPW 1 | 06/09/2005 12:00:00 AM | 8 | 9x5 | 6006445.1571238 | 2114583.3806769 | 37.7866070504124 | -122.42147452901 | (37.7866070504124, -122.42147452901) | 13 | 9 | 10 | 28858 | 36 | ||
| 108620 | 23339 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1202X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 06/09/2005 12:00:00 AM | 6 | 9x5 | 6006445.1571238 | 2114583.3806769 | 37.7866070504124 | -122.42147452901 | (37.7866070504124, -122.42147452901) | 13 | 9 | 10 | 28858 | 36 | ||
| 165987 | 99962 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1202X Van Ness Ave | 4 | Median : Cutout | Tree | DPW 1 | 8 | 9x5 | 6006588.9 | 2114703 | 37.7869435992692 | -122.420985708971 | (37.7869435992692, -122.420985708971) | 13 | 9 | 10 | 28858 | 21 | |||
| 56994 | 23390 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1500X Van Ness Ave | 3 | Median : Cutout | Tree | DPW 1 | 12/09/2003 12:00:00 AM | 6 | 9 | 6006302.3156668 | 2115604.1529311 | 37.789401783497 | -122.42204126893 | (37.789401783497, -122.42204126893) | 13 | 9 | 10 | 28858 | 21 | ||
| 57758 | 23507 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2600X Van Ness Ave | 1 | Median : Cutout | Tree | DPW 1 | 3 | 9 | 6005789.5650879 | 2119282.8766016 | 37.799473699725 | -122.424077049734 | (37.799473699725, -122.424077049734) | 13 | 9 | 1 | 28858 | 32 | |||
| 68597 | 23583 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 3100X Van Ness Ave | 6 | Median : Cutout | Tree | DPW 1 | 24 | 9 | 6005493.5455 | 2121226.72691 | 37.8047942964921 | -122.425239779807 | (37.8047942964921, -122.425239779807) | 5 | 1 | 1 | 28858 | 32 | |||
| 70792 | 23332 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1142X Van Ness Ave | 1 | Median : Cutout | Tree | DPW 1 | 12/01/2003 12:00:00 AM | 3 | 9 | 6006495.0913449 | 2114431.1382441 | 37.7861918455124 | -122.42129095338 | (37.7861918455124, -122.42129095338) | 13 | 9 | 10 | 28858 | 36 | ||
| 72754 | 23582 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 3100X Van Ness Ave | 5 | Median : Cutout | Tree | DPW 1 | 01/25/2008 12:00:00 AM | 3 | 9 | 6005497.77155 | 2121198.52122 | 37.8047170896849 | -122.425223146826 | (37.8047170896849, -122.425223146826) | 5 | 1 | 1 | 28858 | 32 | ||
| 74430 | 23333 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1142X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 12/01/2003 12:00:00 AM | 3 | 9 | 6006495.0913449 | 2114431.1382441 | 37.7861918455124 | -122.42129095338 | (37.7861918455124, -122.42129095338) | 13 | 9 | 10 | 28858 | 36 | ||
| 77034 | 23354 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1250X Van Ness Ave | 1 | Median : Cutout | Tree | DPW 1 | 12/01/2003 12:00:00 AM | 3 | 9 | 6006448.1236467 | 2114767.6788933 | 37.7871132551315 | -122.421477359088 | (37.7871132551315, -122.421477359088) | 13 | 9 | 10 | 28858 | 21 | ||
| 101457 | 23180 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 300X Van Ness Ave | 6 | Median : Cutout | Tree | DPW 1 | 3 | 9 | 6006874.5373229 | 2111536.5864673 | 37.778265495762 | -122.419772706207 | (37.778265495762, -122.419772706207) | 7 | 9 | 9 | 28852 | 36 | |||
| 119078 | 23581 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 3100X Van Ness Ave | 4 | Median : Cutout | Tree | DPW 1 | 01/25/2008 12:00:00 AM | 3 | 9 | 6005553.2513401 | 2120985.4040713 | 37.8041350589608 | -122.425015980687 | (37.8041350589608, -122.425015980687) | 5 | 1 | 1 | 28858 | 32 | ||
| 137610 | 23355 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1250X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 12/10/2003 12:00:00 AM | 3 | 9 | 6006448.1236467 | 2114767.6788933 | 37.7871132551315 | -122.421477359088 | (37.7871132551315, -122.421477359088) | 13 | 9 | 10 | 28858 | 21 | ||
| 153438 | 23389 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1500X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 30 | 9 | 6006261.55669 | 2115711.13882 | 37.7896932412903 | -122.422189894555 | (37.7896932412903, -122.422189894555) | 13 | 9 | 1 | 28858 | 21 | |||
| 191304 | 23366 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 1356X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 12/01/2003 12:00:00 AM | 6 | 9 | 6006391.3825894 | 2115174.2493055 | 37.7882263975959 | -122.421702559542 | (37.7882263975959, -122.421702559542) | 13 | 9 | 10 | 28858 | 21 | ||
| 13875 | 226227 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 2955 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2020 12:00:00 AM | 3 | 6x6 | Permit Number 787786 | 6008507.27789 | 2103281.70589 | 37.755691354088 | -122.413540452526 | (37.755691354088, -122.413540452526) | 2 | 4 | 7 | 28859 | 19 | |
| 87659 | 21043 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 2101X Sunset Blvd | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 60 | 5984980.9284488 | 2100900.997098 | 37.7478054765444 | -122.494725332997 | (37.7478054765444, -122.494725332997) | 1 | 8 | 3 | 29491 | 35 | |||
| 1709 | 224383 | Permitted Site 7 | Quercus suber :: Cork Oak 78 | 125 Julian Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2019 12:00:00 AM | 3 | 5x5 | Permit Number 778492 | 6006444.85004 | 2107119.85754 | 37.7661139992865 | -122.420945489154 | (37.7661139992865, -122.420945489154) | 8 | 4 | 7 | 28853 | 19 | |
| 13584 | 170477 | DPW Maintained 1 | Quercus suber :: Cork Oak 78 | 17 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 6003910.26031 | 2094625.94541 | 37.7316654323041 | -122.428821353234 | (37.7316654323041, -122.428821353234) | 9 | 7 | 5 | 28861 | 25 |
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) );