trees
349 rows where qSpecies_id = 155 sorted by TreeID
This data as json, CSV (advanced)
| rowid | TreeID ▼ | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 58774 | 102106 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 50X Noe St | 8 | Front Yard : Yard | Tree | Private 2 | 12/19/2012 12:00:00 AM | 25 | Permit Number 769282 | 6002816.1 | 2107996.5 | 37.7683158318555 | -122.433559261751 | (37.7683158318555, -122.433559261751) | 15 | 5 | 5 | 28862 | 3 | ||
| 170932 | 102752 | Property Tree 8 | Sequoia sempervirens :: Coast Redwood 155 | 2452 Green St | Back Yard : Yard | Tree | Private 2 | 6001313 | 2117994 | 37.7956810212331 | -122.43947508164 | (37.7956810212331, -122.43947508164) | 13 | 9 | 1 | 57 | 17 | ||||||
| 70534 | 104510 | Private 9 | Sequoia sempervirens :: Coast Redwood 155 | 254 ALLISON ST | 1 | Back Yard : Yard | Tree | Private 2 | 40 | 6000052 | 2087408 | 37.7116274717654 | -122.441642291463 | (37.7116274717654, -122.441642291463) | 9 | 7 | 6 | 28861 | 5 | ||||
| 175188 | 104978 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 66X San Lorenzo Way | 1 | Median : Yard | Tree | Private 2 | Permit Number 770332 | 5993690.5 | 2097533.7 | 37.7390656757525 | -122.464363861933 | (37.7390656757525, -122.464363861933) | 1 | 8 | 4 | 59 | 40 | ||||
| 120109 | 105769 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 1 Gonzalez Dr | 1 | Front Yard : Yard | Tree | Private 2 | 02/24/2014 12:00:00 AM | Permit Number 772589 | 5990111.8 | 2090190.8 | 37.7186969947407 | -122.476201051717 | (37.7186969947407, -122.476201051717) | 1 | 8 | 4 | 64 | 14 | |||
| 82071 | 106360 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 1820 POST ST | 1 | Front Yard : Yard | Tree | Private 2 | 30 | 6003351.1 | 2114201.6 | 37.785383838011 | -122.432151932321 | (37.785383838011, -122.432151932321) | 13 | 9 | 11 | 29490 | 13 | ||||
| 22018 | 106361 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 1645 WEBSTER ST | 2 | Front Yard : Yard | Tree | Private 2 | 30 | 6003301.2 | 2114333.7 | 37.7857437219688 | -122.432334009178 | (37.7857437219688, -122.432334009178) | 13 | 9 | 11 | 29490 | 13 | ||||
| 109809 | 106362 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 1645 WEBSTER ST | 1 | Front Yard : Yard | Tree | Private 2 | 12 | 6003301.2 | 2114333.7 | 37.7857437219688 | -122.432334009178 | (37.7857437219688, -122.432334009178) | 13 | 9 | 11 | 29490 | 13 | ||||
| 166770 | 107222 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 327 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2014 12:00:00 AM | 3 | 6x5 | Permit Number 773943 | 6003989.60354 | 2091508.12122 | 37.7231090719178 | -122.428324915783 | (37.7231090719178, -122.428324915783) | 9 | 7 | 6 | 28861 | 5 | |
| 146386 | 107343 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 110 JULIAN AVE | 2 | Back Yard : Yard | Tree | Private 2 | 15 | 6006340.8 | 2107214.1 | 37.7663669011591 | -122.421312071366 | (37.7663669011591, -122.421312071366) | 8 | 4 | 7 | 28853 | 19 | ||||
| 22679 | 108026 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 862 Kansas St | Front Yard : Yard | Tree | Private 2 | Permit Number 774734 | 6011570 | 2104296 | 37.7586478799274 | -122.403019866682 | (37.7586478799274, -122.403019866682) | 10 | 3 | 8 | 28856 | 29 | |||||
| 4559 | 109532 | - 12 | Sequoia sempervirens :: Coast Redwood 155 | 818 Goettingen St | 1 | Back Yard : Yard | Tree | Private 2 | 6010847.3 | 2090865.3 | 37.7217296747854 | -122.404573864697 | (37.7217296747854, -122.404573864697) | 10 | 3 | 7 | 309 | 28 | |||||
| 3054 | 109568 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 95 Nordhoff St | 1 | Back Yard : Yard | Tree | Private 2 | Permit Number 777169 | 6000348.8 | 2095645.6 | 37.7342629464917 | -122.441207129815 | (37.7342629464917, -122.441207129815) | 9 | 7 | 5 | 63 | 40 | ||||
| 184053 | 109576 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 21X STILLINGS AVE | 1 | Back Yard : Yard | Tree | Private 2 | 60 | 6000417 | 2095694 | 37.7343997262189 | -122.44097481224 | (37.7343997262189, -122.44097481224) | 9 | 7 | 5 | 63 | 40 | ||||
| 8504 | 109669 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 200X GELLERT DR | 33 | Median : Cutout | Tree | DPW 1 | 02/26/2015 01:37:00 PM | 3 | 30x200 | 5985380 | 2094516.3 | 37.730298158605 | -122.492875173009 | (37.730298158605, -122.492875173009) | 1 | 8 | 4 | 64 | 35 | ||
| 14234 | 111268 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 700X BOSWORTH ST | 6 | Front Yard : Yard | Tree | DPW 1 | 3 | 6002150 | 2095428 | 37.7337679036822 | -122.434964255854 | (37.7337679036822, -122.434964255854) | 2 | 7 | 5 | 63 | 7 | ||||
| 72583 | 111269 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 700X BOSWORTH ST | 7 | Front Yard : Yard | Tree | DPW 1 | 3 | 6002150 | 2095428 | 37.7337679036822 | -122.434964255854 | (37.7337679036822, -122.434964255854) | 2 | 7 | 5 | 63 | 7 | ||||
| 139560 | 112145 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 401X ROOSEVELT WAY | 2 | Median : Yard | Tree | DPW 1 | 24 | 6000065 | 2106738 | 37.7647038289299 | -122.442984636734 | (37.7647038289299, -122.442984636734) | 15 | 5 | 5 | 28862 | 3 | ||||
| 142994 | 112559 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 1735x GRANT AVE | 1 | Back Yard : Yard | Tree | Private 2 | 6010373 | 2120454 | 37.8029470287696 | -122.408299306743 | (37.8029470287696, -122.408299306743) | 3 | 1 | 10 | 308 | 23 | |||||
| 85632 | 112804 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 219 UPPER TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3x3 | 5999620 | 2106355 | 37.7636268249183 | -122.444496241129 | (37.7636268249183, -122.444496241129) | 15 | 5 | 5 | 29492 | 3 | |||
| 53110 | 112918 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | ||||
| 56286 | 112919 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | ||||
| 179756 | 112920 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | ||||
| 74096 | 112921 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | ||||
| 65651 | 112922 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | ||||
| 23199 | 112923 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | ||||
| 148103 | 112925 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | 3x3 | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | |||
| 186584 | 112926 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | 3x3 | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | |||
| 176305 | 112927 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | 3x3 | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | |||
| 166722 | 112928 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | 3x3 | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | |||
| 5239 | 112929 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | 3x3 | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | |||
| 106523 | 112930 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | 3x3 | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | |||
| 155030 | 113150 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 45 BRONTE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6009384 | 2097185 | 37.7390003361927 | -122.410078062228 | (37.7390003361927, -122.410078062228) | 10 | 7 | 7 | 28859 | 2 | |||
| 145840 | 113162 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 1300X STANYAN ST | 1 | Front Yard : Yard | Tree | Private 2 | 40 | 3x3 | 5997565 | 2104877 | 37.7594511396077 | -122.451497194349 | (37.7594511396077, -122.451497194349) | 15 | 5 | 11 | 28862 | 12 | |||
| 119143 | 113163 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 1300X STANYAN ST | 2 | Front Yard : Yard | Tree | Private 2 | 40 | 3x3 | 5997565 | 2104877 | 37.7594511396077 | -122.451497194349 | (37.7594511396077, -122.451497194349) | 15 | 5 | 11 | 28862 | 12 | |||
| 47483 | 113358 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 702 Foerster St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5998153.40008835 | 2095558.62470631 | 37.7338988325043 | -122.448791034412 | (37.7338988325043, -122.448791034412) | 9 | 7 | 4 | 59 | 40 | |||||
| 110581 | 113359 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 702 Foerster St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5998153.40008835 | 2095558.62470631 | 37.7338988325043 | -122.448791034412 | (37.7338988325043, -122.448791034412) | 9 | 7 | 4 | 59 | 40 | |||||
| 20335 | 114509 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 3X VULCAN STWY | 1 | Front Yard : Yard | Tree | Private 2 | 56 | 6000640 | 2106231 | 37.7633444989385 | -122.440959493883 | (37.7633444989385, -122.440959493883) | 15 | 5 | 5 | 28862 | 3 | ||||
| 63157 | 116234 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 450 PERALTA AVE | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6009750 | 2099218 | 37.744603019334 | -122.408955999129 | (37.744603019334, -122.408955999129) | 2 | 7 | 7 | 28859 | 2 | ||||
| 82049 | 116660 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 199x Esmeralda Ave | 13 | Unaccepted Street : Yard | Tree | DPW 1 | 8 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 2 | 7 | 7 | 28859 | 2 | ||||
| 152740 | 11673 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 700X Junipero Serra Blvd | 10 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991295.14519 | 2092921.61878 | 37.7262636985024 | -122.472309706624 | (37.7262636985024, -122.472309706624) | 9 | 8 | 4 | 64 | 40 | ||
| 69156 | 117179 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 350x Winding Way | 1 | Median : Cutout | Tree | DPW 1 | 30 | 3x3 | 6001167.67306 | 2086580.24641 | 37.7094181465037 | -122.437726988707 | (37.7094181465037, -122.437726988707) | 9 | 7 | 6 | 28861 | 5 | |||
| 84644 | 118371 | Property Tree 8 | Sequoia sempervirens :: Coast Redwood 155 | 4808 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999981 | 2101110 | 37.7492459313263 | -122.442870994168 | (37.7492459313263, -122.442870994168) | 2 | 4 | 5 | 28862 | 22 | ||||
| 185931 | 118442 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 5201 Anza St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5982468.47607 | 2111659.73383 | 37.7771985159318 | -122.504209970081 | (37.7771985159318, -122.504209970081) | 11 | 6 | 2 | 55 | 26 | |||
| 29828 | 118443 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 5201 Anza St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5982458.0361 | 2111659.95745 | 37.7771985159381 | -122.504246101222 | (37.7771985159381, -122.504246101222) | 11 | 6 | 2 | 55 | 26 | |||
| 22789 | 118610 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 349 Point Lobos Ave | 2 | Side Yard : Yard | Tree | Private 2 | 5 | 5981717.62769 | 2112632.61479 | 37.7798255733952 | -122.506879529548 | (37.7798255733952, -122.506879529548) | 11 | 6 | 2 | 55 | 26 | ||||
| 62301 | 118611 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 349 Point Lobos Ave | 3 | Side Yard : Yard | Tree | Private 2 | 6 | 5981718.68572 | 2112644.15815 | 37.7798573303546 | -122.506876725888 | (37.7798573303546, -122.506876725888) | 11 | 6 | 2 | 55 | 26 | ||||
| 85509 | 119951 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 300 28th Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 30 | Width 3ft | 5987162.07649 | 2113890.44215 | 37.783598323431 | -122.488137483705 | (37.783598323431, -122.488137483705) | 11 | 6 | 2 | 55 | 26 | |||
| 148985 | 120239 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 288 24th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5988397.09206 | 2114077.36637 | 37.7841835367937 | -122.483878566436 | (37.7841835367937, -122.483878566436) | 11 | 6 | 2 | 55 | 26 | |||
| 102757 | 120263 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 24th Ave | 5 | Side Yard : Yard | Tree | Private 2 | 8 | 5988364.34066 | 2115176.21089 | 37.7871987447814 | -122.484072481257 | (37.7871987447814, -122.484072481257) | 11 | 6 | 1 | 55 | 33 | ||||
| 49215 | 120268 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 107 24th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 15 | 5988313.3781 | 2115206.48473 | 37.7872789009445 | -122.484251019639 | (37.7872789009445, -122.484251019639) | 11 | 6 | 1 | 55 | 33 | ||||
| 27029 | 120269 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 107 24th Ave | 2 | Front Yard : Yard | Tree | Private 2 | 15 | 5988324.11159 | 2115191.86053 | 37.7872393720152 | -122.484212811587 | (37.7872393720152, -122.484212811587) | 11 | 6 | 1 | 55 | 33 | ||||
| 68769 | 120270 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 107 24th Ave | 3 | Front Yard : Yard | Tree | Private 2 | 11 | 5988338.64874 | 2115186.15354 | 37.7872245486486 | -122.484162098091 | (37.7872245486486, -122.484162098091) | 11 | 6 | 1 | 55 | 33 | ||||
| 148270 | 120271 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 129 24th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 16 | 5988306.39603 | 2115180.23903 | 37.7872064312039 | -122.48427325024 | (37.7872064312039, -122.48427325024) | 11 | 6 | 1 | 55 | 33 | ||||
| 27519 | 120272 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 129 24th Ave | 2 | Front Yard : Yard | Tree | Private 2 | 13 | 5988314.62217 | 2115170.46659 | 37.7871800778407 | -122.484244072949 | (37.7871800778407, -122.484244072949) | 11 | 6 | 1 | 55 | 33 | ||||
| 66718 | 120273 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 129 24th Ave | 3 | Front Yard : Yard | Tree | Private 2 | 16 | 5988307.3728 | 2115160.02273 | 37.7871509798828 | -122.484268387653 | (37.7871509798828, -122.484268387653) | 11 | 6 | 1 | 55 | 33 | ||||
| 127099 | 120274 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 129 24th Ave | 4 | Front Yard : Yard | Tree | Private 2 | 9 | 5988307.12698 | 2115148.43075 | 37.7871191372985 | -122.484268387654 | (37.7871191372985, -122.484268387654) | 11 | 6 | 1 | 55 | 33 | ||||
| 37051 | 120275 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 129 24th Ave | 5 | Front Yard : Yard | Tree | Private 2 | 11 | 5988318.18285 | 2115148.99603 | 37.7871213331252 | -122.484230178713 | (37.7871213331252, -122.484230178713) | 11 | 6 | 1 | 55 | 33 | ||||
| 72541 | 120276 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 129 24th Ave | 6 | Front Yard : Yard | Tree | Private 2 | 13 | 5988325.261 | 2115160.84311 | 37.7871542739482 | -122.484206559328 | (37.7871542739482, -122.484206559328) | 11 | 6 | 1 | 55 | 33 | ||||
| 142590 | 120277 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 129 24th Ave | 7 | Front Yard : Yard | Tree | Private 2 | 3 | 5988335.64695 | 2115158.22344 | 37.7871476857857 | -122.484170434457 | (37.7871476857857, -122.484170434457) | 11 | 6 | 1 | 55 | 33 | ||||
| 101348 | 120278 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 129 24th Ave | 8 | Front Yard : Yard | Tree | Private 2 | 14 | 5988337.84774 | 2115148.37916 | 37.7871207843354 | -122.484162098088 | (37.7871207843354, -122.484162098088) | 11 | 6 | 1 | 55 | 33 | ||||
| 140694 | 120279 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 129 24th Ave | 9 | Front Yard : Yard | Tree | Private 2 | 14 | 5988331.03377 | 2115139.52576 | 37.7870960786942 | -122.484185023117 | (37.7870960786942, -122.484185023117) | 11 | 6 | 1 | 55 | 33 | ||||
| 89099 | 120280 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 129 24th Ave | 10 | Front Yard : Yard | Tree | Private 2 | 15 | 5988322.23801 | 2115131.91384 | 37.7870746664109 | -122.484214895682 | (37.7870746664109, -122.484214895682) | 11 | 6 | 1 | 55 | 33 | ||||
| 18013 | 120281 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 129 24th Ave | 11 | Front Yard : Yard | Tree | Private 2 | 15 | 5988339.23027 | 2115128.35436 | 37.7870658824376 | -122.484155845816 | (37.7870658824376, -122.484155845816) | 11 | 6 | 1 | 55 | 33 | ||||
| 188164 | 121092 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 30X Grand View Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6000475 | 2103841 | 37.7567727470696 | -122.441358672007 | (37.7567727470696, -122.441358672007) | 2 | 4 | 5 | 28862 | 38 | ||||
| 3904 | 121227 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 4299x 17th St | 3 | Front Yard : Yard | Tree | DPW 1 | |||||||||||||||
| 55834 | 121404 | Property Tree 8 | Sequoia sempervirens :: Coast Redwood 155 | 1900 08th Ave | 1 | Back Yard : Yard | Tree | Private 2 | 3 | 10x10 | 5993817 | 2102486 | 37.7526707300666 | -122.464285931649 | (37.7526707300666, -122.464285931649) | 1 | 8 | 4 | 29491 | 40 | |||
| 97217 | 122496 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 69x Bonview St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007716 | 2099172 | 37.7443625662885 | -122.415985930063 | (37.7443625662885, -122.415985930063) | 2 | 7 | 7 | 28859 | 2 | ||||
| 21279 | 122585 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 2500X Lyon St | 5 | Median : Cutout | Tree | Private 2 | 70 | 10x20 | 5999276 | 2117538 | 37.7943128273924 | -122.446490617691 | (37.7943128273924, -122.446490617691) | 13 | 9 | 1 | 57 | 27 | |||
| 149436 | 122587 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 2500X Lyon St | 7 | Median : Cutout | Tree | Private 2 | 45 | 10x20 | 5999276 | 2117538 | 37.7943128273924 | -122.446490617691 | (37.7943128273924, -122.446490617691) | 13 | 9 | 1 | 57 | 27 | |||
| 57200 | 136428 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 7 Kimball Pl | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 0ft | 6007991.83691 | 2116437.43612 | 37.791784918695 | -122.416254742289 | (37.791784918695, -122.416254742289) | 5 | 1 | 10 | 28858 | 21 | |||
| 167150 | 136429 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1101 Greenwich St | 11 | Front Yard : Yard | Tree | Private 2 | 14 | 6007562.30318 | 2119880.18015 | 37.801213673635 | -122.417985095433 | (37.801213673635, -122.417985095433) | 5 | 1 | 1 | 28858 | 32 | ||||
| 74028 | 136430 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1101 Greenwich St | 15 | Front Yard : Yard | Tree | Private 2 | 20 | 6007579.05475 | 2119893.16835 | 37.8012502787406 | -122.417928048762 | (37.8012502787406, -122.417928048762) | 5 | 1 | 1 | 28858 | 32 | ||||
| 62568 | 136431 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 13 MacOndray Ln | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | 6008632.90068 | 2119166.62302 | 37.799314619318 | -122.414229834152 | (37.799314619318, -122.414229834152) | 5 | 1 | 10 | 308 | 32 | ||||
| 148030 | 136432 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 13 MacOndray Ln | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6008638.14667 | 2119166.05389 | 37.7993133512976 | -122.414211640849 | (37.7993133512976, -122.414211640849) | 5 | 1 | 10 | 308 | 32 | ||||
| 140982 | 136433 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2671 Leavenworth St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 32 | 6007318.56693 | 2121838.23641 | 37.8065762788357 | -122.418967487863 | (37.8065762788357, -122.418967487863) | 5 | 1 | 1 | 28858 | 32 | ||||
| 126966 | 136434 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 12 Greenwich St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 6012298.4076 | 2120549.33954 | 37.8033164360554 | -122.401643063984 | (37.8033164360554, -122.401643063984) | 3 | 1 | 10 | 28860 | 6 | ||||
| 126433 | 136435 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3 Broadway | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6013344.90953 | 2118921.0971 | 37.7989040131614 | -122.397907296408 | (37.7989040131614, -122.397907296408) | 3 | 1 | 10 | 28860 | 6 | ||||
| 138407 | 136436 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3 Broadway | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6013350.43599 | 2118931.26261 | 37.7989322330038 | -122.397888886371 | (37.7989322330038, -122.397888886371) | 3 | 1 | 10 | 28860 | 6 | ||||
| 136125 | 136437 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3 Broadway | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | 6013352.957 | 2118919.28443 | 37.7988994841762 | -122.397879322098 | (37.7988994841762, -122.397879322098) | 3 | 1 | 10 | 28860 | 6 | ||||
| 72665 | 136438 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3 Broadway | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6013355.98644 | 2118932.37336 | 37.798935591968 | -122.397869757803 | (37.798935591968, -122.397869757803) | 3 | 1 | 10 | 28860 | 6 | ||||
| 154245 | 136439 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3 Broadway | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6013363.76971 | 2118922.4292 | 37.7989087211284 | -122.397842127014 | (37.7989087211284, -122.397842127014) | 3 | 1 | 10 | 28860 | 6 | ||||
| 63647 | 136440 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3 Broadway | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | 6013367.06255 | 2118933.37204 | 37.7989389509345 | -122.397831500623 | (37.7989389509345, -122.397831500623) | 3 | 1 | 10 | 28860 | 6 | ||||
| 175737 | 136441 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3 Broadway | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6013371.77292 | 2118938.4754 | 37.798953225861 | -122.397815559237 | (37.798953225861, -122.397815559237) | 3 | 1 | 10 | 28860 | 6 | ||||
| 55580 | 136442 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3 Broadway | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6013378.37764 | 2118933.3014 | 37.7989393870992 | -122.397792341438 | (37.7989393870992, -122.397792341438) | 3 | 1 | 10 | 28860 | 6 | ||||
| 80811 | 136443 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3 Broadway | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6013384.0493 | 2118922.93531 | 37.7989112401317 | -122.397771987982 | (37.7989112401317, -122.397771987982) | 3 | 1 | 10 | 28860 | 6 | ||||
| 177141 | 136444 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3 Broadway | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | 6013387.59339 | 2118931.12048 | 37.7989339120187 | -122.397760298614 | (37.7989339120187, -122.397760298614) | 3 | 1 | 10 | 28860 | 6 | ||||
| 132983 | 136445 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3 Broadway | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | 6013392.00591 | 2118921.55061 | 37.7989078811583 | -122.397744358119 | (37.7989078811583, -122.397744358119) | 3 | 1 | 10 | 28860 | 6 | ||||
| 152363 | 179494 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 861 Lisbon St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 6001008.19959 | 2088780.17342 | 37.7154495883121 | -122.43843566439 | (37.7154495883121, -122.43843566439) | 9 | 7 | 6 | 28861 | 5 | |||
| 166518 | 179495 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 350x Winding Way | 3 | Median : Cutout | Tree | DPW 1 | 13 | Width 0ft | 6001141.42857 | 2086583.09342 | 37.7094244714452 | -122.43781789759 | (37.7094244714452, -122.43781789759) | 9 | 7 | 6 | 28861 | 5 | |||
| 111807 | 179496 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 653 Peru Ave | 8 | Side Yard : Yard | Tree | Private 2 | 6 | 6005058.40423 | 2092646.41058 | 37.7262949850043 | -122.424711217658 | (37.7262949850043, -122.424711217658) | 9 | 7 | 6 | 28861 | 5 | ||||
| 41875 | 179497 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 653 Peru Ave | 9 | Side Yard : Yard | Tree | Private 2 | 8 | 6005046.66321 | 2092646.92983 | 37.7262957476241 | -122.424751842734 | (37.7262957476241, -122.424751842734) | 9 | 7 | 6 | 28861 | 5 | ||||
| 22779 | 179498 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 892 Peru Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 35 | 6005545.45161 | 2091807.84398 | 37.7240199601485 | -122.422967943043 | (37.7240199601485, -122.422967943043) | 9 | 7 | 6 | 309 | 5 | ||||
| 114785 | 179499 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1151 Felton St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6007548.78788 | 2092831.16716 | 37.7269426263769 | -122.416115141404 | (37.7269426263769, -122.416115141404) | 9 | 3 | 7 | 309 | 28 | |||
| 6540 | 181386 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1500 Sunset Blvd | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984899.2058 | 2104514.6528 | 37.7577227962381 | -122.495274374844 | (37.7577227962381, -122.495274374844) | 1 | 8 | 3 | 56 | 35 | |||
| 31619 | 181387 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1500 Sunset Blvd | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984939.8638 | 2104520.2223 | 37.7577404689343 | -122.495134175513 | (37.7577404689343, -122.495134175513) | 1 | 8 | 3 | 56 | 35 | |||
| 41329 | 181391 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1500 Sunset Blvd | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984921.4841 | 2104558.6525 | 37.757844911537 | -122.495200573085 | (37.757844911537, -122.495200573085) | 1 | 8 | 3 | 56 | 35 | |||
| 48099 | 181395 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1500 Sunset Blvd | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984933.1803 | 2104579.26 | 37.7579021787746 | -122.495161642957 | (37.7579021787746, -122.495161642957) | 1 | 8 | 3 | 56 | 35 | |||
| 51649 | 181435 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1500 Sunset Blvd | 68 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984924.5894 | 2104933.1403 | 37.7588733327201 | -122.495217449651 | (37.7588733327201, -122.495217449651) | 1 | 8 | 3 | 56 | 35 | |||
| 161155 | 181478 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1400 Sunset Blvd | 38 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984917.9059 | 2105334.1509 | 37.7599740048158 | -122.495270136852 | (37.7599740048158, -122.495270136852) | 1 | 8 | 3 | 56 | 35 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );