Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 188847 | 188847 | 186087 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1901 Sunset Blvd | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984862.8194 | 2101833.0892 | 37.7503578324165 | -122.495202467563 | (37.7503578324165, -122.495202467563) | |||
| 187882 | 187882 | 215035 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 639 Hearst Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | 5997171.50868 | 2094376.6234 | 37.7305971411271 | -122.452100459987 | (37.7305971411271, -122.452100459987) | ||||
| 187854 | 187854 | 197590 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 200 Kansas St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | Width 4ft | 6011401.81383 | 2107103.92491 | 37.7663484192558 | -122.403799114839 | (37.7663484192558, -122.403799114839) | |||
| 187185 | 187185 | 186923 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2700 Sunset Blvd | 72 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985171.3814 | 2096790.2761 | 37.73652969119129 | -122.493763890804 | (37.7365296911913, -122.493763890804) | |||
| 187074 | 187074 | 247597 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 900 Tompkins Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 8ft | 6009155.970980001 | 2096407.45458 | 37.7368525815689 | -122.41081158571001 | (37.7368525815689, -122.41081158571) | |||
| 186205 | 186205 | 240616 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 685 Sanchez St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 5ft | 6003715.87711 | 2104249.40994 | 37.758078233932096 | -122.430179665856 | (37.7580782339321, -122.430179665856) | |||
| 185835 | 185835 | 186726 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1300 Sunset Blvd | 60 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984877.9354 | 2106257.1953 | 37.7625060863994 | -122.49547645222201 | (37.7625060863994, -122.495476452222) | |||
| 184520 | 184520 | 181386 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1500 Sunset Blvd | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984899.2058 | 2104514.6528 | 37.757722796238106 | -122.495274374844 | (37.7577227962381, -122.495274374844) | |||
| 184462 | 184462 | 185721 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2101 Sunset Blvd | 53 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984915.0274 | 2100334.3998 | 37.7462458971959 | -122.49491144168199 | (37.7462458971959, -122.494911441682) | |||
| 183935 | 183935 | 186666 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1401 Sunset Blvd | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984702.5251 | 2105541.6172 | 37.76053103667871 | -122.49603032958001 | (37.7605310366787, -122.49603032958) | |||
| 183846 | 183846 | 136437 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3 Broadway | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | 6013352.957 | 2118919.28443 | 37.798899484176204 | -122.397879322098 | (37.7988994841762, -122.397879322098) | ||||
| 183468 | 183468 | 187562 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 136 Alpha St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6010924.81275 | 2088138.49847 | 37.714246765754105 | -122.40411411319401 | (37.7142467657541, -122.404114113194) | |||
| 182897 | 182897 | 185734 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2101 Sunset Blvd | 66 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984861.0881 | 2100291.2484 | 37.7461242575362 | -122.495094773004 | (37.7461242575362, -122.495094773004) | |||
| 182822 | 182822 | 39824 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 2190 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | 1 | Permit Number 41149 | 5982047.2464 | 2100175.5874 | 37.745641550250895 | -122.504815942994 | (37.7456415502509, -122.504815942994) | |
| 180000 | 180000 | 240618 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 69 Levant St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | Width 3ft | 6000370.536280001 | 2106394.5334900003 | 37.7637781703576 | -122.441903216369 | (37.7637781703576, -122.441903216369) | |||
| 178655 | 178655 | 197579 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 428 08th St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6010214.98706 | 2109650.78059 | 37.773275125388 | -122.408083778259 | (37.773275125388, -122.408083778259) | |||
| 178388 | 178388 | 184997 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2701 Sunset Blvd | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985027.6641 | 2096515.5033 | 37.7357668292904 | -122.49424052859399 | (37.7357668292904, -122.494240528594) | |||
| 178035 | 178035 | 240623 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 5413 Diamond Heights Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6002032.85746 | 2097853.11791 | 37.7404200644256 | -122.435542682968 | (37.7404200644256, -122.435542682968) | ||||
| 177279 | 177279 | 186668 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1401 Sunset Blvd | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984695.4068 | 2105524.4495 | 37.7604834820457 | -122.49605368158001 | (37.7604834820457, -122.49605368158) | |||
| 177016 | 177016 | 39822 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 2190 46th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | 1 | Permit Number 41149 | 5982045.5543 | 2100206.3838 | 37.7457260090551 | -122.504824075497 | (37.7457260090551, -122.504824075497) | |
| 176998 | 176998 | 136430 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1101 Greenwich St | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6007579.05475 | 2119893.16835 | 37.8012502787406 | -122.417928048762 | (37.8012502787406, -122.417928048762) | ||||
| 176415 | 176415 | 118442 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 5201 Anza St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5982468.47607 | 2111659.73383 | 37.777198515931794 | -122.504209970081 | (37.7771985159318, -122.504209970081) | |||
| 175766 | 175766 | 215022 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 100 Terrace Dr | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 5993608.12799 | 2096720.10438 | 37.7368269967784 | -122.464589603347 | (37.7368269967784, -122.464589603347) | ||||
| 175662 | 175662 | 215033 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 300x Marietta Dr | 28 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 5ft | 5999299.88675 | 2097560.85432 | 37.739461976177395 | -122.44497118247699 | (37.7394619761774, -122.444971182477) | |||
| 175534 | 175534 | 39823 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 2190 46th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | 1 | Permit Number 41149 | 5982046.2311 | 2100191.8316 | 37.7456860925771 | -122.50482065715099 | (37.7456860925771, -122.504820657151) | |
| 174989 | 174989 | 185220 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2500 Sunset Blvd | 77 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985128.7096 | 2098140.8692 | 37.7402355613282 | -122.49401093116998 | (37.7402355613282, -122.49401093117) | |||
| 174768 | 174768 | 240608 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3932 22nd St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 4ft | 6002275.446690001 | 2102986.9903700002 | 37.7545302429786 | -122.435070995746 | (37.7545302429786, -122.435070995746) | |||
| 174597 | 174597 | 197587 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1 Jack Balestreri Way | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6012433.76366 | 2104761.3607799998 | 37.7599738546281 | -122.400065241211 | (37.7599738546281, -122.400065241211) | ||||
| 173006 | 173006 | 240604 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 500 Grand View Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 5999982.42979 | 2101700.47656 | 37.750867318677 | -122.44290844709299 | (37.750867318677, -122.442908447093) | ||||
| 172692 | 172692 | 248065 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 18 Rutledge St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6010648.08166 | 2099392.5913299997 | 37.7451326756473 | -122.405862891685 | (37.7451326756473, -122.405862891685) | ||||
| 172592 | 172592 | 240600 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 237 Murray St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 6005707.57123 | 2095372.66085 | 37.7338173103055 | -122.422660726511 | (37.7338173103055, -122.422660726511) | |||
| 172139 | 172139 | 186477 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1601 Sunset Blvd | 65 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984748.0613 | 2103717.4471 | 37.7555250401648 | -122.49573828341299 | (37.7555250401648, -122.495738283413) | |||
| 171909 | 171909 | 186922 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2700 Sunset Blvd | 71 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985180.0914 | 2096773.3145 | 37.736483628738604 | -122.493732527554 | (37.7364836287386, -122.493732527554) | |||
| 171617 | 171617 | 187295 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2401 Sunset Blvd | 78 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984937.4924 | 2098259.4132 | 37.7405498608751 | -122.49468081101999 | (37.7405498608751, -122.49468081102) | |||
| 171538 | 171538 | 186924 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2700 Sunset Blvd | 73 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985155.3367 | 2096781.1077 | 37.736503578508895 | -122.493818687918 | (37.7365035785089, -122.493818687918) | |||
| 171498 | 171498 | 215042 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 689 Mangels Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 34 | Width 10ft | 5996876.31142 | 2095244.7341099998 | 37.732963851 | -122.453183641224 | (37.732963851, -122.453183641224) | |||
| 171352 | 171352 | 185725 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2101 Sunset Blvd | 57 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984855.2039 | 2100321.3236 | 37.7462064913622 | -122.49511733688499 | (37.7462064913622, -122.495117336885) | |||
| 170379 | 170379 | 240622 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 5413 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6002024.955080001 | 2097832.75898 | 37.740363714714896 | -122.43556855014099 | (37.7403637147149, -122.435568550141) | ||||
| 170341 | 170341 | 186034 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1900 Sunset Blvd | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984985.7569 | 2102048.9979 | 37.7509578553481 | -122.494793264221 | (37.7509578553481, -122.494793264221) | |||
| 170029 | 170029 | 197583 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 851 Indiana St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | Width 8ft | 6014993.182580001 | 2104474.00413 | 37.7593272043051 | -122.39119328893801 | (37.7593272043051, -122.391193288938) | |||
| 169778 | 169778 | 197588 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1 Jack Balestreri Way | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6012433.89716 | 2104751.224 | 37.7599460287107 | -122.400064067605 | (37.7599460287107, -122.400064067605) | ||||
| 169462 | 169462 | 215032 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 300x Marietta Dr | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 5ft | 5999291.25805 | 2097565.13306 | 37.739473232107 | -122.44500132414801 | (37.739473232107, -122.445001324148) | |||
| 169341 | 169341 | 197582 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 851 Indiana St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 31 | Width 10ft | 6014984.28202 | 2104444.32589 | 37.7592452203005 | -122.39122199711399 | (37.7592452203005, -122.391221997114) | |||
| 168787 | 168787 | 181548 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1300 Sunset Blvd | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984846.3366 | 2105995.5399 | 37.761785803641 | -122.495566439468 | (37.761785803641, -122.495566439468) | |||
| 168319 | 168319 | 215026 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 100 Terrace Dr | 21 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5993767.12006 | 2096575.58918 | 37.7364393583851 | -122.46402941471901 | (37.7364393583851, -122.464029414719) | ||||
| 167940 | 167940 | 240620 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 272 Corbett Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 21 | Width 3ft | 5999634.90147 | 2105345.61253 | 37.7608561480145 | -122.44437215754401 | (37.7608561480145, -122.444372157544) | |||
| 167499 | 167499 | 186728 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1300 Sunset Blvd | 63 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984834.3273 | 2106260.9546 | 37.7625138548261 | -122.49562755174401 | (37.7625138548261, -122.495627551744) | |||
| 167471 | 167471 | 181542 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1300 Sunset Blvd | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984868.615 | 2105905.3126 | 37.7615393692586 | -122.495482733656 | (37.7615393692586, -122.495482733656) | |||
| 167123 | 167123 | 185567 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2201 Sunset Blvd | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984881.8296 | 2099726.3595 | 37.7445744404291 | -122.49498140754 | (37.7445744404291, -122.49498140754) | |||
| 167020 | 167020 | 179495 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 350x Winding Way | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6001141.4285699995 | 2086583.09342 | 37.7094244714452 | -122.43781789759 | (37.7094244714452, -122.43781789759) | |||
| 166697 | 166697 | 136434 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 12 Greenwich St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 6012298.4076 | 2120549.33954 | 37.8033164360554 | -122.401643063984 | (37.8033164360554, -122.401643063984) | ||||
| 166588 | 166588 | 248068 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 20 Rutledge St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6010623.83336 | 2099392.33092 | 37.7451306044855 | -122.40594672016701 | (37.7451306044855, -122.405946720167) | ||||
| 165892 | 165892 | 247905 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 582 Esmeralda Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6009839.52244 | 2098719.28889 | 37.7432386818184 | -122.40861127291099 | (37.7432386818184, -122.408611272911) | ||||
| 165286 | 165286 | 247908 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 582 Esmeralda Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6009856.31482 | 2098721.18962 | 37.7432448412741 | -122.408553343056 | (37.7432448412741, -122.408553343056) | ||||
| 164767 | 164767 | 240612 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3637 22nd St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 6003932.88521 | 2103022.72642 | 37.7547223399723 | -122.429341685671 | (37.7547223399723, -122.429341685671) | |||
| 164614 | 164614 | 215027 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 100 Terrace Dr | 22 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 5993761.26762 | 2096568.1489799998 | 37.7364185921533 | -122.464049108976 | (37.7364185921533, -122.464049108976) | ||||
| 164278 | 164278 | 185092 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2801 Sunset Blvd | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985016.1492 | 2096009.4757 | 37.7343767385902 | -122.494243052853 | (37.7343767385902, -122.494243052853) | |||
| 163684 | 163684 | 120263 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 100 24th Ave | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 5988364.34066 | 2115176.21089 | 37.7871987447814 | -122.484072481257 | (37.7871987447814, -122.484072481257) | ||||
| 163436 | 163436 | 186481 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1601 Sunset Blvd | 69 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984737.1745 | 2103681.0182 | 37.7554243789331 | -122.495773245735 | (37.7554243789331, -122.495773245735) | |||
| 163231 | 163231 | 185218 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2500 Sunset Blvd | 75 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985145.9746 | 2098136.8849 | 37.7402256317054 | -122.49395094305099 | (37.7402256317054, -122.493950943051) | |||
| 162708 | 162708 | 186727 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1300 Sunset Blvd | 61 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984865.5297 | 2106265.0899 | 37.762527036338604 | -122.49551994066002 | (37.7625270363386, -122.49551994066) | |||
| 162555 | 162555 | 120268 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 107 24th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 5988313.3781 | 2115206.48473 | 37.7872789009445 | -122.48425101963899 | (37.7872789009445, -122.484251019639) | ||||
| 162095 | 162095 | 184091 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1600 Sunset Blvd | 94 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984954.5787 | 2104192.9608 | 37.756842761121895 | -122.495059154794 | (37.7568427611219, -122.495059154794) | |||
| 161479 | 161479 | 136432 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 13 MacOndray Ln | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6008638.14667 | 2119166.05389 | 37.799313351297606 | -122.414211640849 | (37.7993133512976, -122.414211640849) | ||||
| 161471 | 161471 | 185566 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2201 Sunset Blvd | 50 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984882.0949 | 2099749.7079 | 37.744638564328 | -122.49498221146901 | (37.744638564328, -122.494982211469) | |||
| 161342 | 161342 | 240629 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 32 Harry St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6003236.62583 | 2097684.70359 | 37.740025933855705 | -122.431368508471 | (37.7400259338557, -122.431368508471) | ||||
| 160179 | 160179 | 186729 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1300 Sunset Blvd | 64 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984871.1686 | 2106270.3529 | 37.762541817251794 | -122.49550082623999 | (37.7625418172518, -122.49550082624) | |||
| 159687 | 159687 | 185874 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2000 Sunset Blvd | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985052.1017 | 2101064.154 | 37.7482576266138 | -122.494491248711 | (37.7482576266138, -122.494491248711) | |||
| 159093 | 159093 | 179494 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 861 Lisbon St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 6001008.19959 | 2088780.1734200001 | 37.715449588312104 | -122.43843566438998 | (37.7154495883121, -122.43843566439) | |||
| 157277 | 157277 | 197589 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1 Jack Balestreri Way | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6012441.30894 | 2104748.70907 | 37.7599395365119 | -122.40003825707 | (37.7599395365119, -122.40003825707) | ||||
| 156845 | 156845 | 186677 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1401 Sunset Blvd | 34 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984721.4724 | 2105427.5149 | 37.760218853394605 | -122.49595638286101 | (37.7602188533946, -122.495956382861) | |||
| 155040 | 155040 | 120274 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 129 24th Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 5988307.12698 | 2115148.43075 | 37.7871191372985 | -122.484268387654 | (37.7871191372985, -122.484268387654) | ||||
| 154917 | 154917 | 215038 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 314 Staples Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 5997989.53732 | 2093829.39983 | 37.7291414193406 | -122.449233015693 | (37.7291414193406, -122.449233015693) | ||||
| 154850 | 154850 | 187128 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2600 Sunset Blvd | 64 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985172.8615 | 2097384.8403 | 37.738162292099204 | -122.49380257480101 | (37.7381622920992, -122.493802574801) | |||
| 154758 | 154758 | 185095 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2801 Sunset Blvd | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985029.9671 | 2095999.845 | 37.7343511038502 | -122.494194570965 | (37.7343511038502, -122.494194570965) | |||
| 154287 | 154287 | 215034 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 300x Marietta Dr | 32 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | Width 5ft | 5999319.41307 | 2097556.59014 | 37.7394513821643 | -122.444903362803 | (37.7394513821643, -122.444903362803) | |||
| 154175 | 154175 | 246775 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 925 Esmeralda Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6009505.54739 | 2098718.43829 | 37.743217635879205 | -122.409766015896 | (37.7432176358792, -122.409766015896) | ||||
| 153969 | 153969 | 215031 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 300x Marietta Dr | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 5ft | 5999287.157930001 | 2097565.9418 | 37.739475218703106 | -122.445015558643 | (37.7394752187031, -122.445015558643) | |||
| 153678 | 153678 | 187305 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2401 Sunset Blvd | 88 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984977.8173 | 2098236.5366 | 37.740489408091605 | -122.49453969916 | (37.7404894080916, -122.49453969916) | |||
| 153412 | 153412 | 179499 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1151 Felton St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6007548.787880001 | 2092831.16716 | 37.7269426263769 | -122.416115141404 | (37.7269426263769, -122.416115141404) | |||
| 153291 | 153291 | 136440 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3 Broadway | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | 6013367.06255 | 2118933.3720400003 | 37.7989389509345 | -122.397831500623 | (37.7989389509345, -122.397831500623) | ||||
| 152219 | 152219 | 184995 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2701 Sunset Blvd | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985022.2207 | 2096528.9025 | 37.7358033013739 | -122.494260335606 | (37.7358033013739, -122.494260335606) | |||
| 152027 | 152027 | 136436 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3 Broadway | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6013350.43599 | 2118931.2626099996 | 37.7989322330038 | -122.397888886371 | (37.7989322330038, -122.397888886371) | ||||
| 151692 | 151692 | 240595 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1300 San Jose Ave | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | 6003654.00301 | 2095729.23304 | 37.7346803033401 | -122.429785949874 | (37.7346803033401, -122.429785949874) | ||||
| 150892 | 150892 | 240609 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3944 22nd St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6002189.659030001 | 2102971.08087 | 37.7544816876836 | -122.435366533665 | (37.7544816876836, -122.435366533665) | ||||
| 150118 | 150118 | 240628 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 32 Harry St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 35 | 6003238.63031 | 2097694.69053 | 37.740053469295795 | -122.431362290536 | (37.7400534692958, -122.431362290536) | ||||
| 149792 | 149792 | 240605 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 500 Grand View Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 5999980.41761 | 2101731.1965799998 | 37.75095155369029 | -122.44291761118099 | (37.7509515536903, -122.442917611181) | ||||
| 149664 | 149664 | 240613 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3637 22nd St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 6003938.94874 | 2103022.28304 | 37.754721465836894 | -122.42932068472 | (37.7547214658369, -122.42932068472) | |||
| 149631 | 149631 | 197584 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 851 Indiana St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 29 | Width 10ft | 6014983.28625 | 2104495.6281 | 37.7593860298711 | -122.391229027092 | (37.7593860298711, -122.391229027092) | |||
| 149148 | 149148 | 185877 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2000 Sunset Blvd | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985055.2583 | 2101098.876 | 37.7483531484939 | -122.494482892668 | (37.7483531484939, -122.494482892668) | |||
| 148971 | 148971 | 215030 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 300x Marietta Dr | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 5ft | 5999282.59402 | 2097567.7247599997 | 37.7394798538026 | -122.44503146673401 | (37.7394798538026, -122.445031466734) | |||
| 148844 | 148844 | 240603 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 609 28th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6001924.96846 | 2099400.16705 | 37.7446617708161 | -122.43602639412799 | (37.7446617708161, -122.436026394128) | |||
| 148759 | 148759 | 119951 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 300 28th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | Width 3ft | 5987162.07649 | 2113890.44215 | 37.783598323431 | -122.488137483705 | (37.783598323431, -122.488137483705) | |||
| 148152 | 148152 | 186376 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1801 Sunset Blvd | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984798.5659 | 2102512.3907 | 37.7522192455734 | -122.495474752392 | (37.7522192455734, -122.495474752392) | |||
| 148033 | 148033 | 120277 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 129 24th Ave | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 5988335.64695 | 2115158.2234400003 | 37.787147685785705 | -122.484170434457 | (37.7871476857857, -122.484170434457) | ||||
| 147246 | 147246 | 215043 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 798 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 5996915.73734 | 2095029.5626400001 | 37.732375301382 | -122.453031809567 | (37.732375301382, -122.453031809567) | ||||
| 147227 | 147227 | 240599 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3229 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6006780.56286 | 2103771.69804 | 37.75693965177221 | -122.41954675558 | (37.7569396517722, -122.41954675558) | |||
| 146584 | 146584 | 248054 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 19 Rutledge St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6010623.789469999 | 2099366.66931 | 37.7450601408245 | -122.405945064536 | (37.7450601408245, -122.405945064536) | ||||
| 146439 | 146439 | 187127 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2600 Sunset Blvd | 63 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985167.6891 | 2097369.3231 | 37.7381193834059 | -122.49381931494301 | (37.7381193834059, -122.493819314943) | |||
| 143568 | 143568 | 96273 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 55@ Alemany Trumbull St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6004020.1 | 2094407.4 | 37.7310715719205 | -122.428426044208 | (37.7310715719205, -122.428426044208) |
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");