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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | ||||
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) | ||
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) | |||
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) | |||
97021 | 97021 | 106360 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 1820 POST ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6003351.1 | 2114201.6 | 37.785383838011 | -122.43215193232099 | (37.785383838011, -122.432151932321) | ||||
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) | ||||
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) | ||||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | |||
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) | |||
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) | |||
45602 | 45602 | 109669 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 200X GELLERT DR | 33 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/26/2015 01:37:00 PM | 3 | 30x200 | 5985380.0 | 2094516.3 | 37.730298158604995 | -122.492875173009 | (37.730298158605, -122.492875173009) | ||
60533 | 60533 | 250200 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 203 Union St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 33 | Width 0ft | 6011776.4013 | 2119745.07747 | 37.8010789857668 | -122.403392881194 | (37.8010789857668, -122.403392881194) | |||
65961 | 65961 | 250201 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 203 Union St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 29 | Width 0ft | 6011763.02504 | 2119743.5219400004 | 37.8010739675505 | -122.40343905958099 | (37.8010739675505, -122.403439059581) | |||
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) | |||
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) | |||
104001 | 104001 | 197581 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2101 17th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 35 | 6011118.65336 | 2106461.14792 | 37.7645676761706 | -122.40473326313601 | (37.7645676761706, -122.404733263136) | ||||
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) | |||
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) | |||
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) | |||
54165 | 54165 | 240598 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2106 Folsom St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 2ft | 6008077.42241 | 2106097.35182 | 37.763398325498 | -122.415226338718 | (37.763398325498, -122.415226338718) | |||
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) | |||
51336 | 51336 | 197580 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2151 17th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6010976.50521 | 2106453.15639 | 37.764537787215 | -122.405224355037 | (37.764537787215, -122.405224355037) | ||||
135635 | 135635 | 240594 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 216 Bemis St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 47 | 6003152.3623 | 2096416.5644900003 | 37.736539139077394 | -122.43156934507401 | (37.7365391390774, -122.431569345074) | ||||
91300 | 91300 | 112804 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 219 UPPER TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3x3 | 5999620.0 | 2106355.0 | 37.7636268249183 | -122.444496241129 | (37.7636268249183, -122.444496241129) | |||
45421 | 45421 | 240621 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 219 Upper Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 52 | Width 3ft | 5999599.462169999 | 2106267.78648 | 37.7633861864367 | -122.444561006196 | (37.7633861864367, -122.444561006196) | |||
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) | |
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) | |
139589 | 139589 | 109576 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 21X STILLINGS AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 60 | 6000417.0 | 2095694.0 | 37.7343997262189 | -122.44097481223999 | (37.7343997262189, -122.44097481224) | ||||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
142682 | 142682 | 102752 | Property Tree 7 | Sequoia sempervirens :: Coast Redwood 116 | 2452 Green St | Back Yard : Yard 13 | Tree 1 | Private 1 | 6001313.0 | 2117994.0 | 37.7956810212331 | -122.43947508164 | (37.7956810212331, -122.43947508164) | ||||||
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) | |||
116259 | 116259 | 122587 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2500X Lyon St | 7 | Median : Cutout 11 | Tree 1 | Private 1 | 45 | 10x20 | 5999276.0 | 2117538.0 | 37.794312827392396 | -122.446490617691 | (37.7943128273924, -122.446490617691) | |||
127993 | 127993 | 122585 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2500X Lyon St | 5 | Median : Cutout 11 | Tree 1 | Private 1 | 70 | 10x20 | 5999276.0 | 2117538.0 | 37.794312827392396 | -122.446490617691 | (37.7943128273924, -122.446490617691) | |||
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) | |||
85994 | 85994 | 104510 | Private 5 | Sequoia sempervirens :: Coast Redwood 116 | 254 ALLISON ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 40 | 6000052.0 | 2087408.0 | 37.7116274717654 | -122.441642291463 | (37.7116274717654, -122.441642291463) | ||||
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) | |||
29906 | 29906 | 250138 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 2550x Lyon St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 101 | 5999227.62567 | 2117605.22496 | 37.7944946461503 | -122.446662836939 | (37.7944946461503, -122.446662836939) | ||||
41136 | 41136 | 250136 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 2550x Lyon St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 100 | 5999230.194080001 | 2117561.109 | 37.794373662156296 | -122.446650774326 | (37.7943736621563, -122.446650774326) | ||||
27330 | 27330 | 187124 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2600 Sunset Blvd | 60 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985135.2439 | 2097353.8058 | 37.738074878751895 | -122.493930349328 | (37.7380748787519, -122.493930349328) | |||
74083 | 74083 | 187107 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2600 Sunset Blvd | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985143.7078 | 2097238.6019 | 37.73775905490071 | -122.49389259826401 | (37.7377590549007, -122.493892598264) | |||
74839 | 74839 | 187109 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2600 Sunset Blvd | 45 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985172.8615 | 2097253.1787 | 37.7378007845896 | -122.493792875188 | (37.7378007845896, -122.493792875188) | |||
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) | |||
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) | |||
74221 | 74221 | 215021 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2624 14th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5992112.26225 | 2097456.03758 | 37.7387613350595 | -122.469814985494 | (37.7387613350595, -122.469814985494) | |||
91679 | 91679 | 94535 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 265 Dorland St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6003831.0 | 2105693.0 | 37.7620485075454 | -122.42988449123301 | (37.7620485075454, -122.429884491233) | |||||
41820 | 41820 | 136433 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2671 Leavenworth St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 32 | 6007318.566930001 | 2121838.23641 | 37.8065762788357 | -122.418967487863 | (37.8065762788357, -122.418967487863) | ||||
114267 | 114267 | 95432 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2675 25th Ave | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 12 | 5988610.0 | 2097126.3 | 37.7376529013161 | -122.48189987005101 | (37.7376529013161, -122.481899870051) | ||||
115606 | 115606 | 95435 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2675 25th Ave | 2 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 12 | 5988610.0 | 2097126.3 | 37.7376529013161 | -122.48189987005101 | (37.7376529013161, -122.481899870051) | ||||
60464 | 60464 | 186891 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2700 Sunset Blvd | 40 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985178.2577 | 2096509.7223 | 37.7357597676042 | -122.493719449451 | (37.7357597676042, -122.493719449451) | |||
70926 | 70926 | 186856 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2700 Sunset Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985217.4528 | 2096293.5766 | 37.735168582064794 | -122.49356801735901 | (37.7351685820648, -122.493568017359) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
29908 | 29908 | 249959 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 273 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | Width 0ft | 6011558.5565599995 | 2120064.53903 | 37.801943979781896 | -122.40416921824301 | (37.8019439797819, -122.404169218243) | |||
71910 | 71910 | 186966 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2800 Sunset Blvd | 40 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985198.0961 | 2096141.0368 | 37.734748616014 | -122.493623703195 | (37.734748616014, -122.493623703195) | |||
73058 | 73058 | 186967 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2800 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985210.5401 | 2096146.418 | 37.7347641193316 | -122.493581077021 | (37.7347641193316, -122.493581077021) | |||
134037 | 134037 | 186968 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2800 Sunset Blvd | 42 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985205.8316 | 2096154.4897 | 37.73478600662639 | -122.49359795024999 | (37.7347860066264, -122.49359795025) | |||
65956 | 65956 | 185096 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2801 Sunset Blvd | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985018.6615 | 2095986.0271 | 37.7343125019956 | -122.494232639372 | (37.7343125019956, -122.494232639372) | |||
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) | |||
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) | |||
50051 | 50051 | 120239 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 288 24th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5988397.09206 | 2114077.36637 | 37.784183536793705 | -122.483878566436 | (37.7841835367937, -122.483878566436) | |||
74195 | 74195 | 240615 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 297 Cumberland St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6003715.872169999 | 2104475.4119700002 | 37.75869878143 | -122.430195805998 | (37.75869878143, -122.430195805998) | |||
43173 | 43173 | 112929 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 2X Noe St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/27/2015 12:00:00 AM | 3x3 | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.43349023202299 | (37.7683199626551, -122.433490232023) | |||
78522 | 78522 | 112919 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 2X Noe St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.43349023202299 | (37.7683199626551, -122.433490232023) | ||||
81040 | 81040 | 112918 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 2X Noe St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.43349023202299 | (37.7683199626551, -122.433490232023) | ||||
85824 | 85824 | 112921 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 2X Noe St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.43349023202299 | (37.7683199626551, -122.433490232023) | ||||
89530 | 89530 | 112922 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 2X Noe St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.43349023202299 | (37.7683199626551, -122.433490232023) | ||||
100331 | 100331 | 112930 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 2X Noe St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/27/2015 12:00:00 AM | 3x3 | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.43349023202299 | (37.7683199626551, -122.433490232023) | |||
115520 | 115520 | 112925 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 2X Noe St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/27/2015 12:00:00 AM | 3x3 | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.43349023202299 | (37.7683199626551, -122.433490232023) | |||
117865 | 117865 | 112928 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 2X Noe St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/27/2015 12:00:00 AM | 3x3 | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.43349023202299 | (37.7683199626551, -122.433490232023) |
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");