Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9593 | 9593 | 94859 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 53932 | |||||||||
| 14837 | 14837 | 94862 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 53932 | |||||||||
| 24871 | 24871 | 178331 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Crespi Dr | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 5990248.62782 | 2090529.4940400003 | 37.719634898219205 | -122.47575281776001 | (37.7196348982192, -122.47575281776) | ||||
| 39653 | 39653 | 178330 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Crespi Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 5990231.62588 | 2090527.9032400001 | 37.7196295445501 | -122.47581147062 | (37.7196295445501, -122.47581147062) | ||||
| 154609 | 154609 | 178329 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Crespi Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 5990213.26487 | 2090523.74185 | 37.719617053850996 | -122.47587463361 | (37.719617053851, -122.47587463361) | ||||
| 25725 | 25725 | 178308 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Font Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | 5990210.12045 | 2089417.27348 | 37.716578783365605 | -122.47580474370501 | (37.7165787833656, -122.475804743705) | ||||
| 27306 | 27306 | 178328 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 29 | 5990317.34225 | 2090043.8786900002 | 37.718305502374704 | -122.47547986090599 | (37.7183055023747, -122.475479860906) | ||||
| 31497 | 31497 | 178323 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | 5990245.32384 | 2089538.4798299999 | 37.7169136270349 | -122.475691910275 | (37.7169136270349, -122.475691910275) | ||||
| 67578 | 67578 | 178320 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | 5988848.05481 | 2089780.78106 | 37.7174978203386 | -122.480539260585 | (37.7174978203386, -122.480539260585) | ||||
| 69442 | 69442 | 178322 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | 5989407.26888 | 2089196.13882 | 37.7159250221006 | -122.478563605643 | (37.7159250221006, -122.478563605643) | ||||
| 90725 | 90725 | 178324 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | 5990257.3816599995 | 2089553.17282 | 37.7169546693979 | -122.475651304982 | (37.7169546693979, -122.475651304982) | ||||
| 130676 | 130676 | 178327 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | 5990329.946140001 | 2089929.88135 | 37.7179932244997 | -122.475427976322 | (37.7179932244997, -122.475427976322) | ||||
| 134179 | 134179 | 178325 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | 5990390.33795 | 2089760.9336299999 | 37.7175328363477 | -122.47520690318599 | (37.7175328363477, -122.475206903186) | ||||
| 135161 | 135161 | 178321 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | 5989145.21541 | 2089457.7452900002 | 37.716628110272005 | -122.479488503489 | (37.716628110272, -122.479488503489) | ||||
| 152019 | 152019 | 178326 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | 5990372.2115400005 | 2089922.4902 | 37.7179753801352 | -122.475281345478 | (37.7179753801352, -122.475281345478) | ||||
| 39006 | 39006 | 218138 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Noriega St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 0ft | 5992012.7807599995 | 2103568.58372 | 37.7555390629029 | -122.47060402547899 | (37.7555390629029, -122.470604025479) | |||
| 43295 | 43295 | 218137 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Noriega St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5992341.41081 | 2103487.78695 | 37.755336213609795 | -122.469461649962 | (37.7553362136098, -122.469461649962) | |||
| 148741 | 148741 | 218136 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Noriega St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 0ft | 5992370.84065 | 2103479.76822 | 37.755315897018704 | -122.46935928999599 | (37.7553158970187, -122.469359289996) | |||
| 43642 | 43642 | 234528 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 San Jose Av Off Ramp | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 46 | 6002924.2654 | 2095295.03485 | 37.733446743766606 | -122.432277899312 | (37.7334467437666, -122.432277899312) | ||||
| 44844 | 44844 | 234526 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 San Jose Av Off Ramp | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 36 | 6002889.3394 | 2095280.36515 | 37.733404483718296 | -122.43239760087299 | (37.7334044837183, -122.432397600873) | ||||
| 157797 | 157797 | 234527 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 San Jose Av Off Ramp | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 39 | 6002909.37025 | 2095287.3929700002 | 37.733424916326605 | -122.432328850416 | (37.7334249163266, -122.432328850416) | ||||
| 167027 | 167027 | 234529 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 San Jose Av Off Ramp | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6002999.6248699995 | 2095331.3906599998 | 37.7335508412 | -122.432019955754 | (37.7335508412, -122.432019955754) | ||||
| 172904 | 172904 | 234530 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 San Jose Av Off Ramp | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6003016.336130001 | 2095337.77177 | 37.7335693096769 | -122.431962635665 | (37.7335693096769, -122.431962635665) | ||||
| 26554 | 26554 | 178310 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Serrano Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 34 | 5989465.34816 | 2090743.3229599998 | 37.7201765760646 | -122.478475931633 | (37.7201765760646, -122.478475931633) | ||||
| 50016 | 50016 | 178316 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Serrano Dr | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | 5988657.395 | 2090367.41703 | 37.719097493043 | -122.48124121021601 | (37.719097493043, -122.481241210216) | ||||
| 54341 | 54341 | 178317 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Serrano Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | 5988563.85117 | 2090373.5250900001 | 37.719108825389796 | -122.481564998528 | (37.7191088253898, -122.481564998528) | ||||
| 58577 | 58577 | 178312 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Serrano Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | 5989196.07168 | 2090595.4058400001 | 37.7197547958347 | -122.479395903892 | (37.7197547958347, -122.479395903892) | ||||
| 69790 | 69790 | 178318 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Serrano Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 32 | 5988183.85887 | 2090397.25913 | 37.7191518903345 | -122.48288020845699 | (37.7191518903345, -122.482880208457) | ||||
| 156413 | 156413 | 178315 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Serrano Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 38 | 5988883.66138 | 2090326.3057 | 37.718997763613295 | -122.48045609578399 | (37.7189977636133, -122.480456095784) | ||||
| 164567 | 164567 | 178311 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Serrano Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 38 | 5989539.14496 | 2090698.0698799998 | 37.7200566065169 | -122.478217536623 | (37.7200566065169, -122.478217536623) | ||||
| 167684 | 167684 | 178313 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Serrano Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 43 | 5989165.0392 | 2090617.5248599998 | 37.7198137266005 | -122.479504788413 | (37.7198137266005, -122.479504788413) | ||||
| 172768 | 172768 | 178314 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Serrano Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 36 | 5989006.41886 | 2090486.3279799998 | 37.7194442778983 | -122.48004348051501 | (37.7194442778983, -122.480043480515) | ||||
| 174176 | 174176 | 178309 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Serrano Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | 5989840.96696 | 2090677.1262700001 | 37.720016616367005 | -122.477172722251 | (37.720016616367, -122.477172722251) | ||||
| 181525 | 181525 | 178319 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Serrano Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | 5988184.71166 | 2090359.2688799999 | 37.7190476283173 | -122.48287447798799 | (37.7190476283173, -122.482874477988) | ||||
| 1620 | 1620 | 251543 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0X Bay Shore Blvd Off Ramp | Side Yard : Yard 17 | Tree 1 | Private 1 | |||||||||||
| 69716 | 69716 | 246697 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1 Bonview St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | 6007653.370080001 | 2099025.4086700003 | 37.743956537756794 | -122.41619211169201 | (37.7439565377568, -122.416192111692) | ||||
| 74332 | 74332 | 246701 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1 Bonview St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 6007685.33931 | 2099084.9994 | 37.744121958161 | -122.41608578844401 | (37.744121958161, -122.416085788444) | ||||
| 122520 | 122520 | 100850 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1 Estero Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | |||||
| 32160 | 32160 | 211179 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1 Geneva Ave | 4 | : 4 | Tree 1 | Private 1 | 18 | Width 0ft | 5997208.95655 | 2091525.75307 | 37.7227714708997 | -122.451765419354 | (37.7227714708997, -122.451765419354) | |||
| 112832 | 112832 | 108978 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1 MIGUEL ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 44 | 6003334.2 | 2097391.9 | 37.739227491928894 | -122.431010244874 | (37.7392274919289, -122.431010244874) | ||||
| 92845 | 92845 | 114978 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1 PETER YORKE WAY | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6005775.0 | 2114336.0 | 37.7858899958642 | -122.423775516058 | (37.7858899958642, -122.423775516058) | ||||
| 118399 | 118399 | 115436 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1 PETER YORKE WAY | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6005775.0 | 2114336.0 | 37.7858899958642 | -122.423775516058 | (37.7858899958642, -122.423775516058) | ||||
| 144359 | 144359 | 115437 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1 PETER YORKE WAY | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6005775.0 | 2114336.0 | 37.7858899958642 | -122.423775516058 | (37.7858899958642, -122.423775516058) | ||||
| 156257 | 156257 | 250021 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1 Peter Yorke Way | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 6005906.53716 | 2114478.7126700003 | 37.7862892740647 | -122.423330582061 | (37.7862892740647, -122.423330582061) | ||||
| 18835 | 18835 | 114526 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1 TIOGA AVE | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6011351.0 | 2088602.0 | 37.715543251319204 | -122.402673611341 | (37.7155432513192, -122.402673611341) | |||||
| 88169 | 88169 | 114525 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1 TIOGA AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6011351.0 | 2088602.0 | 37.715543251319204 | -122.402673611341 | (37.7155432513192, -122.402673611341) | |||||
| 78391 | 78391 | 108038 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1 Twin Peaks Blvd | Front Yard : Yard 7 | Tree 1 | Private 1 | 5998985.485719999 | 2105240.3128 | 37.760529947122706 | -122.446610614338 | (37.7605299471227, -122.446610614338) | ||||||
| 136687 | 136687 | 217848 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1 Woodacre Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 40 | 5991432.090890001 | 2095719.97643 | 37.7339552123593 | -122.472040172642 | (37.7339552123593, -122.472040172642) | ||||
| 111961 | 111961 | 1 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 10 10th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 16 | 5992719.40718 | 2114869.71245 | 37.7866097734767 | -122.46898271049601 | (37.7866097734767, -122.468982710496) | |||
| 116003 | 116003 | 114410 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 10 GARDENSIDE DR | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999306.0 | 2102458.0 | 37.752908704913395 | -122.445302055175 | (37.7529087049134, -122.445302055175) | ||||||
| 49756 | 49756 | 178276 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 10 Lake Merced Blvd | 3 | : 4 | Tree 1 | Private 1 | 21 | Width 0ft | 5987587.7101300005 | 2089755.9926900002 | 37.7173564298339 | -122.4848938211 | (37.7173564298339, -122.4848938211) | |||
| 109312 | 109312 | 110236 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 100 BUCHANAN ST | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 05/12/2015 12:00:00 AM | 3 | 3x20 | 6004868.5 | 2109011.4 | 37.771218737852294 | -122.426532477218 | (37.7712187378523, -122.426532477218) | ||
| 89602 | 89602 | 116672 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 Esmeralda Ave | 9 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6006917.389830001 | 2098966.37493 | 37.7437530336215 | -122.41873278303999 | (37.7437530336215, -122.41873278304) | |||||
| 84722 | 84722 | 8291 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 Garcia Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 5995006.6013281 | 2099280.197711 | 37.743936899881 | -122.45993989851101 | (37.743936899881, -122.459939898511) | |||
| 87594 | 87594 | 8293 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 Garcia Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 8 | 5995006.6013281 | 2099280.197711 | 37.743936899881 | -122.45993989851101 | (37.743936899881, -122.459939898511) | |||
| 95088 | 95088 | 8292 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 Garcia Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 5995006.6013281 | 2099280.197711 | 37.743936899881 | -122.45993989851101 | (37.743936899881, -122.459939898511) | |||
| 117295 | 117295 | 8294 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 Garcia Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 8 | 5995006.6013281 | 2099280.197711 | 37.743936899881 | -122.45993989851101 | (37.743936899881, -122.459939898511) | |||
| 128632 | 128632 | 8295 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 Garcia Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 8 | 5995006.6013281 | 2099280.197711 | 37.743936899881 | -122.45993989851101 | (37.743936899881, -122.459939898511) | |||
| 78510 | 78510 | 114817 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 100 RACCOON DR | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 5998725.0 | 2104028.0 | 37.757186355085004 | -122.447424250084 | (37.757186355085, -122.447424250084) | |||||
| 12711 | 12711 | 19749 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 STAIRWAY15 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10ST | ||||||||
| 13681 | 13681 | 19775 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 STAIRWAY18 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 50ST | ||||||||
| 7092 | 7092 | 19853 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 STAIRWAY29 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 100ST | ||||||||
| 4528 | 4528 | 19968 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 STAIRWAY43 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15 | ||||||||
| 16297 | 16297 | 19969 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 STAIRWAY43 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 15 | ||||||||
| 7176 | 7176 | 19977 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 STAIRWAY45 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 30ST | ||||||||
| 4260 | 4260 | 20045 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 STAIRWAY52 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10 | ||||||||
| 2700 | 2700 | 20053 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 STAIRWAY53 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 30 | ||||||||
| 15072 | 15072 | 20052 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 STAIRWAY53 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 30 | ||||||||
| 7096 | 7096 | 20070 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 STAIRWAY55 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 40ST | ||||||||
| 13180 | 13180 | 20069 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 STAIRWAY55 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 40ST | ||||||||
| 23936 | 23936 | 211142 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 100 Terrace Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | 5993344.399119999 | 2096880.05499 | 37.7372509740365 | -122.465513038912 | (37.7372509740365, -122.465513038912) | ||||
| 53339 | 53339 | 211144 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 100 Terrace Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 33 | 5993373.46569 | 2096862.7426 | 37.7372051149341 | -122.465411285997 | (37.7372051149341, -122.465411285997) | ||||
| 63930 | 63930 | 211148 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 100 Terrace Dr | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | 5993527.53053 | 2096770.0110799999 | 37.7369593814624 | -122.46487188523999 | (37.7369593814624, -122.46487188524) | ||||
| 74537 | 74537 | 211146 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 100 Terrace Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 45 | 5993485.1199 | 2096799.89353 | 37.7370389858541 | -122.465020686177 | (37.7370389858541, -122.465020686177) | ||||
| 121080 | 121080 | 211147 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 100 Terrace Dr | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | 5993511.61003 | 2096780.4294599998 | 37.7369870697942 | -122.46492768547199 | (37.7369870697942, -122.464927685472) | ||||
| 151603 | 151603 | 211152 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 100 Terrace Dr | 25 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 34 | 5993733.1055 | 2096523.04642 | 37.7362931286276 | -122.464143203246 | (37.7362931286276, -122.464143203246) | ||||
| 158314 | 158314 | 211143 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 100 Terrace Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | 5993358.77763 | 2096871.55975 | 37.737228477512005 | -122.465462709251 | (37.737228477512, -122.465462709251) | ||||
| 159408 | 159408 | 211150 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 100 Terrace Dr | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 46 | 5993560.03035 | 2096750.4211900001 | 37.7369074662969 | -122.464758097607 | (37.7369074662969, -122.464758097607) | ||||
| 174717 | 174717 | 211151 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 100 Terrace Dr | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 39 | 5993575.924430001 | 2096738.7427299998 | 37.7368763164955 | -122.464702297369 | (37.7368763164955, -122.464702297369) | ||||
| 179164 | 179164 | 211145 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 100 Terrace Dr | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 38 | 5993430.72958 | 2096831.91816 | 37.7371237811228 | -122.46521106186701 | (37.7371237811228, -122.465211061867) | ||||
| 182618 | 182618 | 211149 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 100 Terrace Dr | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 41 | 5993545.6652 | 2096759.5462200001 | 37.7369316931402 | -122.46480842636801 | (37.7369316931402, -122.464808426368) | ||||
| 17834 | 17834 | 16381 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1000 Moraga St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 12 | 5991038.119519999 | 2103837.44782 | 37.7562208847883 | -122.47399428791799 | (37.7562208847883, -122.473994287918) | |||
| 171542 | 171542 | 233283 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1000 San Jose Ave | 76 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6005053.15059 | 2097036.60001 | 37.738349170383394 | -122.425041606983 | (37.7383491703834, -122.425041606983) | ||||
| 33782 | 33782 | 194477 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1000 Texas St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 37 | 6013908.27444 | 2102233.75002 | 37.7531156831575 | -122.394788565357 | (37.7531156831575, -122.394788565357) | ||||
| 162681 | 162681 | 194478 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1000 Texas St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 36 | 6013925.61111 | 2102123.6200599996 | 37.7528142537945 | -122.394720899468 | (37.7528142537945, -122.394720899468) | ||||
| 102685 | 102685 | 110629 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1000X MANDALAY LN | 1 | Unaccepted Street : Cutout 20 | Tree 1 | Private 1 | 5991616.0 | 2101838.0 | 37.75076437998511 | -122.47185008331101 | (37.7507643799851, -122.471850083311) | |||||
| 113490 | 113490 | 114590 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1000X MORAGA ST | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 12 | 5991075.0 | 2103884.0 | 37.7563508410106 | -122.47387013998001 | (37.7563508410106, -122.47387013998) | |||
| 116529 | 116529 | 108208 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 100X Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000799.34617 | 2109469.60329 | 37.7722459721119 | -122.44064067844499 | (37.7722459721119, -122.440640678445) | |||||
| 40010 | 40010 | 113539 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100X CASHMERE ST | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | 6017054.0 | 2095889.0 | 37.7358686950692 | -122.38346826685301 | (37.7358686950692, -122.383468266853) | ||||
| 88481 | 88481 | 113536 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100X CASHMERE ST | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 6017054.0 | 2095889.0 | 37.7358686950692 | -122.38346826685301 | (37.7358686950692, -122.383468266853) | |||||
| 96850 | 96850 | 113535 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100X CASHMERE ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12/05/2015 12:49:00 PM | 3 | 6017054.0 | 2095889.0 | 37.7358686950692 | -122.38346826685301 | (37.7358686950692, -122.383468266853) | |||
| 103732 | 103732 | 113537 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100X CASHMERE ST | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 6017054.0 | 2095889.0 | 37.7358686950692 | -122.38346826685301 | (37.7358686950692, -122.383468266853) | |||||
| 104927 | 104927 | 113538 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100X CASHMERE ST | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 6017054.0 | 2095889.0 | 37.7358686950692 | -122.38346826685301 | (37.7358686950692, -122.383468266853) | |||||
| 110524 | 110524 | 102270 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100X Casitas Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6x100 | 5995287.9 | 2097019.1 | 37.7377446590015 | -122.458803572065 | (37.7377446590015, -122.458803572065) | |||
| 173550 | 173550 | 211257 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100x Casitas Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 3ft | 5995466.651769999 | 2096989.01448 | 37.737672324406 | -122.45818336818 | (37.737672324406, -122.45818336818) | |||
| 97063 | 97063 | 116666 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100x Esmeralda Ave | 2 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6006917.389830001 | 2098966.37493 | 37.7437530336215 | -122.41873278303999 | (37.7437530336215, -122.41873278304) | |||||
| 110832 | 110832 | 116665 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100x Esmeralda Ave | 1 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 25 | 6006917.389830001 | 2098966.37493 | 37.7437530336215 | -122.41873278303999 | (37.7437530336215, -122.41873278304) | ||||
| 144028 | 144028 | 113477 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100x Esmeralda Ave | 10 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 24 | 6006917.389830001 | 2098966.37493 | 37.7437530336215 | -122.41873278303999 | (37.7437530336215, -122.41873278304) | ||||
| 113606 | 113606 | 111093 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 100x FONT BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/2015 12:00:00 AM | 50 | 3x3 | Permit Number 775594 | 5990916.0 | 2088996.0 | 37.715462969911 | -122.473334188491 | (37.715462969911, -122.473334188491) | |
| 37375 | 37375 | 211161 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100x Idora Ave | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 41 | Width 9ft | 5995684.4738300005 | 2099331.0800900003 | 37.7441155729727 | -122.45759966680599 | (37.7441155729727, -122.457599666806) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");