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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
140384 | 140384 | 104978 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 66X San Lorenzo Way | 1 | Median : Yard 3 | Tree 1 | Private 1 | Permit Number 770332 | 5993690.5 | 2097533.7 | 37.7390656757525 | -122.46436386193301 | (37.7390656757525, -122.464363861933) | ||||
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) | ||||||
142904 | 142904 | 112920 | 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) | ||||
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) | |||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | |
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) | ||||
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) | ||||
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) | |
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) | ||||
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) | |
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) | ||||
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) | ||||
838 | 838 | 19815 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 100 STAIRWAY24 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 100ST | ||||||||
7219 | 7219 | 20014 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 100 STAIRWAY47 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 100ST | ||||||||
7290 | 7290 | 19816 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 100 STAIRWAY24 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 100ST | ||||||||
12451 | 12451 | 20015 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 100 STAIRWAY47 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 100ST | ||||||||
15735 | 15735 | 19811 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 100 STAIRWAY24 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 100ST | ||||||||
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) | |||
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) | |||
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) | |||
5737 | 5737 | 20074 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 100 STAIRWAY55 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 27X | ||||||||
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) | ||
21212 | 21212 | 11673 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 700X Junipero Serra Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991295.1451900005 | 2092921.61878 | 37.7262636985024 | -122.47230970662399 | (37.7262636985024, -122.472309706624) | ||
104910 | 104910 | 24794 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 7633 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5983299.41691 | 2112375.1982400003 | 37.7792118059508 | -122.50138846508999 | (37.7792118059508, -122.50138846509) | |||
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) | ||||
3355 | 3355 | 253433 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3 Vulcan Stwy | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 3x3 | 6000640.0 | 2106231.0 | 37.7633444989385 | -122.440959493883 | (37.7633444989385, -122.440959493883) | ||||
11264 | 11264 | 117179 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 350x Winding Way | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 3x3 | 6001167.67306 | 2086580.24641 | 37.7094181465037 | -122.43772698870701 | (37.7094181465037, -122.437726988707) | |||
14101 | 14101 | 96173 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | Unaccepted Street : Cutout 20 | Tree 1 | Private 1 | 04/04/2011 12:00:00 AM | 3x3 | Permit Number 767806 | |||||||||
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) | |||
50092 | 50092 | 372 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
86905 | 86905 | 88838 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711 19th Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 3x3 | Permit Number 51718 | 5990297.3 | 2090806.0 | 37.7203969366505 | -122.475604756889 | (37.7203969366505, -122.475604756889) | ||
88885 | 88885 | 370 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
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) | ||||
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) | |||
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) | ||||
92695 | 92695 | 375 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
96847 | 96847 | 376 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
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) | ||||
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) | |||
101507 | 101507 | 381 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 16 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
102899 | 102899 | 373 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
105060 | 105060 | 380 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 16 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
106535 | 106535 | 113163 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 1300X STANYAN ST | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 3x3 | 5997565.0 | 2104877.0 | 37.7594511396077 | -122.451497194349 | (37.7594511396077, -122.451497194349) | |||
112251 | 112251 | 113162 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 1300X STANYAN ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 3x3 | 5997565.0 | 2104877.0 | 37.7594511396077 | -122.451497194349 | (37.7594511396077, -122.451497194349) | |||
115004 | 115004 | 88839 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711 19th Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 3x3 | Permit Number 51718 | 5990297.3 | 2090806.0 | 37.7203969366505 | -122.475604756889 | (37.7203969366505, -122.475604756889) | ||
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) | ||
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) | |||
116977 | 116977 | 371 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
117092 | 117092 | 113150 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 45 BRONTE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6009384.0 | 2097185.0 | 37.7390003361927 | -122.410078062228 | (37.7390003361927, -122.410078062228) | |||
117801 | 117801 | 27532 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
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) | |||
122391 | 122391 | 374 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
124243 | 124243 | 378 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
125133 | 125133 | 377 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 12 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
129416 | 129416 | 379 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
140824 | 140824 | 112927 | 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) | |||
141641 | 141641 | 112926 | 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) | |||
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) | ||||
105545 | 105545 | 54448 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 425 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/2015 12:00:00 AM | 3x5 | Permit Number 10233 | 6011220.56042251 | 2106374.73270267 | 37.764336094761 | -122.40437470921499 | (37.764336094761, -122.404374709215) | ||
22599 | 22599 | 2580 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 1668 Bush St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6005450.60125 | 2115176.6463599997 | 37.7881798837348 | -122.424957678647 | (37.7881798837348, -122.424957678647) | |||
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) | |||
4452 | 4452 | 19593 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 100 STAIRWAY4 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | ||||||||
6387 | 6387 | 19592 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 100 STAIRWAY4 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | ||||||||
13822 | 13822 | 20456 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 495X Sunset Blvd | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | ||||||||
119676 | 119676 | 6389 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 40 Entrada Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60M | 5992282.41809 | 2092443.27672 | 37.725007378570105 | -122.468861992007 | (37.7250073785701, -122.468861992007) | |||
12707 | 12707 | 107222 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 327 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2014 12:00:00 AM | 3 | 6x5 | Permit Number 773943 | 6003989.6035400005 | 2091508.12122 | 37.7231090719178 | -122.42832491578301 | (37.7231090719178, -122.428324915783) | |
10060 | 10060 | 19578 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 100 STAIRWAY4 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 8 | ||||||||
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) | |||
26484 | 26484 | 184736 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1301 Sunset Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984658.5537 | 2106283.3352 | 37.762565010947704 | -122.49623713063801 | (37.7625650109477, -122.496237130638) | |||
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) | |||
29043 | 29043 | 181547 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1300 Sunset Blvd | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984881.425 | 2105994.983 | 37.761786329172104 | -122.495445043427 | (37.7617863291721, -122.495445043427) |
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");