Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
34861 | 34861 | 240630 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 32 Harry St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 35 | 6003226.48563 | 2097681.33135 | 37.7400160997695 | -122.43140332841999 | (37.7400160997695, -122.43140332842) | ||||
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) | ||||
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) | ||||
25384 | 25384 | 185213 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2500 Sunset Blvd | 68 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985153.279 | 2098105.011 | 37.740138541922 | -122.49392333934799 | (37.740138541922, -122.493923339348) | |||
66493 | 66493 | 185214 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2500 Sunset Blvd | 70 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985123.3973 | 2098105.6751 | 37.7401386169566 | -122.494026705548 | (37.7401386169566, -122.494026705548) | |||
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) | |||
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) | |||
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) | ||||
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) | ||||
69595 | 69595 | 240624 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 5413 Diamond Heights Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6002039.42489 | 2097863.5246099997 | 37.7404490118051 | -122.4355207197 | (37.7404490118051, -122.4355207197) | ||||
71275 | 71275 | 187306 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2401 Sunset Blvd | 89 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984963.8587 | 2098228.7818 | 37.7404672985278 | -122.494587390296 | (37.7404672985278, -122.494587390296) | |||
134633 | 134633 | 187307 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2401 Sunset Blvd | 90 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984946.0227 | 2098230.3328 | 37.740470513218796 | -122.49464917361601 | (37.7404705132188, -122.494649173616) | |||
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) | |||
75777 | 75777 | 240625 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 5413 Diamond Heights Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6002051.53836 | 2097889.55934 | 37.7405211850978 | -122.43548069809799 | (37.7405211850978, -122.435480698098) | ||||
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) | |||
47297 | 47297 | 240626 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 5413 Diamond Heights Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6002059.772469999 | 2097912.30108 | 37.740584096269295 | -122.435453854224 | (37.7405840962693, -122.435453854224) | ||||
43258 | 43258 | 240627 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 5413 Diamond Heights Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6002066.06456 | 2097929.8821400004 | 37.7406327271153 | -122.43543335598 | (37.7406327271153, -122.43543335598) | ||||
39748 | 39748 | 240597 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 523 Powhattan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 29 | 6008567.55649 | 2098119.2319799997 | 37.741519737445294 | -122.412966995358 | (37.7415197374453, -122.412966995358) | ||||
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) | ||||
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) | ||||
93306 | 93306 | 116660 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 199x Esmeralda Ave | 13 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 8 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | ||||
62574 | 62574 | 240606 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2112 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 35 | Width 10ft | 6002638.80724 | 2099263.13099 | 37.7443260296246 | -122.43354829062099 | (37.7443260296246, -122.433548290621) | |||
99767 | 99767 | 122496 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 69x Bonview St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6007716.0 | 2099172.0 | 37.7443625662885 | -122.415985930063 | (37.7443625662885, -122.415985930063) | ||||
38586 | 38586 | 246713 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1 Bonview St | 19 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | 6007763.89494 | 2099225.75212 | 37.7445128502976 | -122.415824124379 | (37.7445128502976, -122.415824124379) | ||||
70736 | 70736 | 247974 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 346 Peralta Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 6009790.92788 | 2099185.07173 | 37.7445148980554 | -122.408812155357 | (37.7445148980554, -122.408812155357) | ||||
136491 | 136491 | 185568 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2201 Sunset Blvd | 52 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984938.6086 | 2099724.7676 | 37.74457339320529 | -122.49478496266701 | (37.7445733932053, -122.494784962667) | |||
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) | |||
89351 | 89351 | 116234 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 450 PERALTA AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6009750.0 | 2099218.0 | 37.744603019334 | -122.408955999129 | (37.744603019334, -122.408955999129) | ||||
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) | |||
30053 | 30053 | 240601 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 609 28th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6001917.090969999 | 2099400.07719 | 37.744661076553 | -122.43605362647301 | (37.744661076553, -122.436053626473) | |||
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) | |||
70873 | 70873 | 240602 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 609 28th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6001920.90533 | 2099400.25112 | 37.7446617708226 | -122.436040449628 | (37.7446617708226, -122.436040449628) | |||
40898 | 40898 | 185564 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2201 Sunset Blvd | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984920.5667 | 2099758.7289 | 37.744665585625896 | -122.494849850524 | (37.7446655856259, -122.494849850524) | |||
59256 | 59256 | 187358 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2200 Sunset Blvd | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985096.2813 | 2099797.9258 | 37.7447834938464 | -122.494245161303 | (37.7447834938464, -122.494245161303) | |||
40320 | 40320 | 187361 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2200 Sunset Blvd | 46 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985088.1562 | 2099814.8531 | 37.7448294961486 | -122.49427450340099 | (37.7448294961486, -122.494274503401) | |||
46422 | 46422 | 248058 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 17 Rutledge St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6010687.47782 | 2099346.1468700003 | 37.7450073524216 | -122.405723395139 | (37.7450073524216, -122.405723395139) | ||||
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) | ||||
70280 | 70280 | 248053 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 19 Rutledge St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6010622.547590001 | 2099378.6850900003 | 37.7450930640901 | -122.405950205054 | (37.7450930640901, -122.405950205054) | ||||
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) | ||||
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) | ||||
65505 | 65505 | 248066 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 18 Rutledge St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6010646.65948 | 2099397.14706 | 37.7451451051559 | -122.405868130216 | (37.7451451051559, -122.405868130216) | ||||
64361 | 64361 | 248069 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 20 Rutledge St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6010620.265980001 | 2099403.1540599996 | 37.7451601229588 | -122.405959817907 | (37.7451601229588, -122.405959817907) | ||||
52535 | 52535 | 187380 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2200 Sunset Blvd | 66 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985069.8747 | 2100065.0386 | 37.7455153678045 | -122.494356154683 | (37.7455153678045, -122.494356154683) | |||
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) | |
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) | |
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) | |
107500 | 107500 | 54927 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 485 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/1972 12:00:00 AM | 10 | Permit Number 10801 | 6003402.69319537 | 2099776.66443458 | 37.745779384936206 | -122.43094357883498 | (37.7457793849362, -122.430943578835) | ||
131190 | 131190 | 246442 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 485 Duncan St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 6003379.46073 | 2099778.50621 | 37.7457831256083 | -122.431024044746 | (37.7457831256083, -122.431024044746) | ||||
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) | |||
132343 | 132343 | 185730 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2101 Sunset Blvd | 62 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984911.7584 | 2100300.7286 | 37.7461532538825 | -122.494920263061 | (37.7461532538825, -122.494920263061) | |||
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) | |||
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) | |||
63967 | 63967 | 185633 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2100 Sunset Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985076.9465 | 2100353.2830000003 | 37.7463072224732 | -122.494352945117 | (37.7463072224732, -122.494352945117) | |||
50233 | 50233 | 187392 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2100 Sunset Blvd | 45 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985024.2566 | 2100630.9061 | 37.7470664162932 | -122.494555600597 | (37.7470664162932, -122.494555600597) | |||
115065 | 115065 | 87450 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 180 Castenada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/2008 12:00:00 AM | 3x3 | Permit Number 50376 | 5994470.9 | 2100852.3 | 37.748222673270895 | -122.461906191942 | (37.7482226732709, -122.461906191942) | ||
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) | |||
35086 | 35086 | 185875 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2000 Sunset Blvd | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985024.3241 | 2101081.1994 | 37.74830280287971 | -122.494588557862 | (37.7483028028797, -122.494588557862) | |||
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) | |||
102307 | 102307 | 99256 | Property Tree 7 | Sequoia sempervirens :: Coast Redwood 116 | 1466 York St | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010099.0 | 2100741.0 | 37.7488043872035 | -122.407856595429 | (37.7488043872035, -122.407856595429) | ||||||
82219 | 82219 | 97945 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 2 Mendosa Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 768165 | 5993624.4 | 2101138.5 | 37.748959736293294 | -122.464854121346 | (37.7489597362933, -122.464854121346) | ||||
92371 | 92371 | 118371 | Property Tree 7 | Sequoia sempervirens :: Coast Redwood 116 | 4808 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999981.0 | 2101110.0 | 37.7492459313263 | -122.44287099416799 | (37.7492459313263, -122.442870994168) | ||||
59035 | 59035 | 186092 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1901 Sunset Blvd | 38 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984860.3007 | 2101794.0493 | 37.750250492095795 | -122.495208298659 | (37.7502504920958, -122.495208298659) | |||
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) | |||
27359 | 27359 | 240611 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 255 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003497.9531 | 2101542.75011 | 37.750634040826796 | -122.43074019171699 | (37.7506340408268, -122.430740191717) | |||
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) | ||||
40656 | 40656 | 186033 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1900 Sunset Blvd | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985025.9241 | 2102045.6103 | 37.7509509050251 | -122.49465411447399 | (37.7509509050251, -122.494654114474) | |||
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) | ||||
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) | |||
57134 | 57134 | 186036 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1900 Sunset Blvd | 31 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985023.9883 | 2102086.2614 | 37.7510624084937 | -122.49466380518 | (37.7510624084937, -122.49466380518) | |||
75876 | 75876 | 240607 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 888 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 6000718.67811 | 2102015.72187 | 37.751774854241795 | -122.44038504473 | (37.7517748542418, -122.44038504473) | |||
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) | |||
29532 | 29532 | 186369 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1801 Sunset Blvd | 36 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984816.0737 | 2102538.2484 | 37.7522912688492 | -122.495416115464 | (37.7522912688492, -122.495416115464) | |||
79534 | 79534 | 121404 | Property Tree 7 | Sequoia sempervirens :: Coast Redwood 116 | 1900 08th Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 10x10 | 5993817.0 | 2102486.0 | 37.7526707300666 | -122.464285931649 | (37.7526707300666, -122.464285931649) | |||
20116 | 20116 | 2370 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 2516 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4PL | 6009703.1421 | 2102664.68486 | 37.7540642287015 | -122.40936121487499 | (37.7540642287015, -122.409361214875) | |||
83100 | 83100 | 240610 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3944 22nd St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6002190.86574 | 2102965.81607 | 37.754467300333296 | -122.43536198397301 | (37.7544673003333, -122.435361983973) | ||||
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) | ||||
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) | |||
76485 | 76485 | 197585 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 900x Carolina St | 75 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6012517.30691 | 2102783.51804 | 37.7545477896502 | -122.399637433715 | (37.7545477896502, -122.399637433715) | ||||
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) | |||
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) | |||
33291 | 33291 | 240614 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3637 22nd St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6003933.5831699995 | 2103025.57629 | 37.7547302045579 | -122.429339475147 | (37.7547302045579, -122.429339475147) | |||
88274 | 88274 | 3774 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 1098 Carolina St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 18 | 6012462.6103665 | 2102859.9036449 | 37.754754478768 | -122.39983195341699 | (37.754754478768, -122.399831953417) | |||
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) | |||
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) | |||
36125 | 36125 | 186472 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1601 Sunset Blvd | 60 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984790.3524 | 2103740.0582 | 37.755589600564704 | -122.495593697553 | (37.7555896005647, -122.495593697553) | |||
3280 | 3280 | 253389 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 30X Grand View Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3x3 | 6000475.0 | 2103841.0 | 37.756772747069604 | -122.44135867200701 | (37.7567727470696, -122.441358672007) | ||||
142585 | 142585 | 121092 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 30X Grand View Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000475.0 | 2103841.0 | 37.756772747069604 | -122.44135867200701 | (37.7567727470696, -122.441358672007) | ||||
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) | |||
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) | |||
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) | |||
48439 | 48439 | 181387 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1500 Sunset Blvd | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984939.8638 | 2104520.2223 | 37.757740468934294 | -122.495134175513 | (37.7577404689343, -122.495134175513) | |||
136288 | 136288 | 181391 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1500 Sunset Blvd | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984921.4841 | 2104558.6525 | 37.757844911537 | -122.495200573085 | (37.757844911537, -122.495200573085) | |||
75550 | 75550 | 186581 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1501 Sunset Blvd | 52 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5984771.5099 | 2104576.6683 | 37.75788559627829 | -122.495720567601 | (37.7578855962783, -122.495720567601) | |||
64455 | 64455 | 181395 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1500 Sunset Blvd | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984933.1803 | 2104579.26 | 37.7579021787746 | -122.495161642957 | (37.7579021787746, -122.495161642957) |
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");