trees
349 rows where qSpecies_id = 155 sorted by DBH
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1427 | 260648 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 3891 Sacramento St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 7ft | 5996301.11796 | 2114890.85877 | 37.7868741256738 | -122.456592467462 | (37.7868741256738, -122.456592467462) | 11 | 6 | 1 | 54 | 31 | ||||
| 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 | ||||
| 3904 | 121227 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 4299x 17th St | 3 | Front Yard : Yard | Tree | DPW 1 | |||||||||||||||
| 4006 | 261988 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1599x Armstrong Ave | 2 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3x3 | 6014700 | 2092264 | 37.7257847940592 | -122.391353711711 | (37.7257847940592, -122.391353711711) | 10 | 3 | 8 | 58 | 1 | ||||
| 4071 | 260649 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 3891 Sacramento St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 7ft | 5996301.11796 | 2114890.85877 | 37.7868741256738 | -122.456592467462 | (37.7868741256738, -122.456592467462) | 11 | 6 | 1 | 54 | 31 | ||||
| 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 | |||||
| 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 | |||
| 7906 | 262219 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 21X Stillings Ave | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6000348 | 2095645 | 37.7342612534616 | -122.441209852629 | (37.7342612534616, -122.441209852629) | 9 | 7 | 5 | 63 | 40 | ||||
| 9964 | 262274 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 4 Montclair Ter | 1 | Side Yard : Yard | Tree | Private 2 | 6007298.70359 | 2120216.09204 | 37.8021211637502 | -122.418921105258 | (37.8021211637502, -122.418921105258) | 5 | 1 | 1 | 28858 | 32 | |||||
| 10029 | 260896 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 866 Kansas St | 1 | Front Yard : Cutout | Tree | DPW 1 | Private | 3x3 | 6011543 | 2104306 | 37.7586738299336 | -122.403113948893 | (37.7586738299336, -122.403113948893) | 10 | 3 | 8 | 28856 | 29 | |||
| 10658 | 97853 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 895 Indiana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | 10 | 3 | 8 | 28856 | 29 | |||||
| 12165 | 260922 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 866 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 774734 | 6011543 | 2104306 | 37.7586738299336 | -122.403113948893 | (37.7586738299336, -122.403113948893) | 10 | 3 | 8 | 28856 | 29 | |||
| 13310 | 263635 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 702 Foerster St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6x10 | 5998173 | 2095582 | 37.733964136305 | -122.448724954929 | (37.733964136305, -122.448724954929) | 9 | 7 | 4 | 59 | 40 | ||||
| 14046 | 262297 | Private 9 | Sequoia sempervirens :: Coast Redwood 155 | 666 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009767 | 2091318 | 37.722912259595 | -122.408340109411 | (37.722912259595, -122.408340109411) | 9 | 3 | 7 | 309 | 28 | ||||
| 17522 | 261989 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1501x Armstrong Ave | 3 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 3x3 | 6014836 | 2092075 | 37.7252733848281 | -122.390870362971 | (37.7252733848281, -122.390870362971) | 10 | 3 | 8 | 58 | 1 | ||||
| 18463 | 262218 | Landmark tree 11 | Sequoia sempervirens :: Coast Redwood 155 | 46 Stillings Ave | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6000246 | 2095728 | 37.7344833413152 | -122.441568452522 | (37.7344833413152, -122.441568452522) | 9 | 7 | 5 | 63 | 40 | ||||
| 19465 | 96173 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | Unaccepted Street : Cutout | Tree | Private 2 | 04/04/2011 12:00:00 AM | 3x3 | Permit Number 767806 | ||||||||||||||
| 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 | |||||
| 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 | ||||
| 26601 | 258075 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 1300X Wawona St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | 5988924 | 2097013 | 37.7373600650942 | -122.480805942066 | (37.7373600650942, -122.480805942066) | 1 | 8 | 3 | 29491 | 35 | ||||
| 30542 | 98548 | Property Tree 8 | Sequoia sempervirens :: Coast Redwood 155 | 132 Hamerton Ave | 1 | Front Yard : Yard | Tree | Private 2 | 6001332.8 | 2095440.7 | 37.7337563407686 | -122.437790462907 | (37.7337563407686, -122.437790462907) | 9 | 7 | 5 | 63 | 40 | |||||
| 34175 | 87149 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 4 Bellair Pl | 2 | Back Yard : Yard | Tree | Private 2 | 6010093 | 2120950 | 37.8042932388788 | -122.409303278994 | (37.8042932388788, -122.409303278994) | 3 | 1 | 10 | 308 | 23 | |||||
| 35596 | 254587 | Property Tree 8 | Sequoia sempervirens :: Coast Redwood 155 | 1270 24th Ave | 1 | Back Yard : Cutout | Tree | Private 2 | 3x3 | 5988678 | 2106679 | 37.7638860263594 | -122.482364481098 | (37.7638860263594, -122.482364481098) | 1 | 8 | 3 | 56 | 35 | ||||
| 38735 | 253433 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3 Vulcan Stwy | 1 | Unaccepted Street : Yard | Tree | Private 2 | 3x3 | 6000640 | 2106231 | 37.7633444989385 | -122.440959493883 | (37.7633444989385, -122.440959493883) | 15 | 5 | 5 | 28862 | 3 | ||||
| 39128 | 251719 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 1301 Clayton St | 1 | Side Yard : Yard | Tree | Private 2 | 5999055 | 2105304 | 37.7607087868046 | -122.446374778866 | (37.7607087868046, -122.446374778866) | 15 | 5 | 5 | 28862 | 12 | |||||
| 42536 | 97945 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2 Mendosa Ave | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 768165 | 5993624.4 | 2101138.5 | 37.7489597362933 | -122.464854121346 | (37.7489597362933, -122.464854121346) | 1 | 8 | 4 | 29491 | 40 | ||||
| 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 | |||||
| 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 | ||||
| 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 | ||||
| 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 | ||||
| 65969 | 87150 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 4 Bellair Pl | 2 | Back Yard : Yard | Tree | Private 2 | Permit Number 50135 | 6010093 | 2120950 | 37.8042932388788 | -122.409303278994 | (37.8042932388788, -122.409303278994) | 3 | 1 | 10 | 308 | 23 | ||||
| 71693 | 88838 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 3711 19th Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2008 12:00:00 AM | 3x3 | Permit Number 51718 | 5990297.3 | 2090806 | 37.7203969366505 | -122.475604756889 | (37.7203969366505, -122.475604756889) | 1 | 8 | 4 | 64 | 14 | ||
| 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 | ||||
| 76481 | 94535 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 265 Dorland St | 1 | Back Yard : Yard | Tree | Private 2 | 6003831 | 2105693 | 37.7620485075454 | -122.429884491233 | (37.7620485075454, -122.429884491233) | 8 | 4 | 5 | 28862 | 3 | |||||
| 82381 | 98597 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 400X Steiner St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | Permit Number 768529 | 6004639 | 2109849 | 37.7735056071657 | -122.427386005439 | (37.7735056071657, -122.427386005439) | 7 | 9 | 11 | 28852 | 10 | ||||
| 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 | ||||
| 85142 | 255249 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 209x Willow St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6006475 | 2113325 | 37.7831535286214 | -122.421281886667 | (37.7831535286214, -122.421281886667) | 7 | 9 | 11 | 28858 | 41 | ||||
| 92802 | 256419 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 3001 Sunset Blvd | 7 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
| 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 | ||||
| 101955 | 256418 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 3001 Sunset Blvd | 6 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
| 104626 | 253389 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 30X Grand View Ave | 2 | Side Yard : Yard | Tree | Private 2 | 3x3 | 6000475 | 2103841 | 37.7567727470696 | -122.441358672007 | (37.7567727470696, -122.441358672007) | 2 | 4 | 5 | 28862 | 38 | ||||
| 105934 | 99256 | Property Tree 8 | Sequoia sempervirens :: Coast Redwood 155 | 1466 York St | Back Yard : Yard | Tree | Private 2 | 6010099 | 2100741 | 37.7488043872035 | -122.407856595429 | (37.7488043872035, -122.407856595429) | 2 | 4 | 7 | 28859 | 19 | ||||||
| 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 | |||
| 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 | |||||
| 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 | |||
| 121121 | 97857 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 895 Indiana St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | 10 | 3 | 8 | 28856 | 29 | |||||
| 130762 | 54448 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 425 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/16/2015 12:00:00 AM | 3x5 | Permit Number 10233 | 6011220.56042251 | 2106374.73270267 | 37.764336094761 | -122.404374709215 | (37.764336094761, -122.404374709215) | 8 | 3 | 8 | 28856 | 29 | ||
| 133327 | 255538 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 700x Folsom St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6012646 | 2113072 | 37.7828048233647 | -122.399914812284 | (37.7828048233647, -122.399914812284) | 6 | 2 | 9 | 28856 | 34 | ||||
| 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 | |||||
| 144579 | 88839 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 3711 19th Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2008 12:00:00 AM | 3x3 | Permit Number 51718 | 5990297.3 | 2090806 | 37.7203969366505 | -122.475604756889 | (37.7203969366505, -122.475604756889) | 1 | 8 | 4 | 64 | 14 | ||
| 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 | |||
| 148790 | 87450 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 180 Castenada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2008 12:00:00 AM | 3x3 | Permit Number 50376 | 5994470.9 | 2100852.3 | 37.7482226732709 | -122.461906191942 | (37.7482226732709, -122.461906191942) | 1 | 8 | 4 | 29491 | 40 | ||
| 160085 | 97856 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 895 Indiana St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | 10 | 3 | 8 | 28856 | 29 | |||||
| 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 | |||
| 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 | ||||||
| 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 | ||||
| 175625 | 97854 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 895 Indiana St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | 10 | 3 | 8 | 28856 | 29 | |||||
| 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 | |||
| 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 | ||||
| 180754 | 96273 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 55@ Alemany Trumbull St | 1 | Back Yard : Yard | Tree | Private 2 | 6004020.1 | 2094407.4 | 37.7310715719205 | -122.428426044208 | (37.7310715719205, -122.428426044208) | 9 | 7 | 6 | 28861 | 5 | |||||
| 185174 | 255539 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 700x Folsom St | 17 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6012646 | 2113072 | 37.7828048233647 | -122.399914812284 | (37.7828048233647, -122.399914812284) | 6 | 2 | 9 | 28856 | 34 | ||||
| 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 | |||
| 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 | ||||
| 194374 | 265048 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 959 Kirkham St | 1 | Front Yard : Yard | Tree | Private 2 | 20x20 | 5991956 | 2105209 | 37.7600399316741 | -122.470919881603 | (37.7600399316741, -122.470919881603) | 1 | 8 | 4 | 56 | 12 | ||||
| 10552 | 185214 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2500 Sunset Blvd | 70 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985123.3973 | 2098105.6751 | 37.7401386169566 | -122.494026705548 | (37.7401386169566, -122.494026705548) | 1 | 8 | 3 | 29491 | 35 | |||
| 29707 | 185566 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2201 Sunset Blvd | 50 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984882.0949 | 2099749.7079 | 37.744638564328 | -122.494982211469 | (37.744638564328, -122.494982211469) | 1 | 8 | 3 | 29491 | 35 | |||
| 31897 | 187392 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2100 Sunset Blvd | 45 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985024.2566 | 2100630.9061 | 37.7470664162932 | -122.494555600597 | (37.7470664162932, -122.494555600597) | 1 | 8 | 3 | 29491 | 35 | |||
| 33270 | 187127 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2600 Sunset Blvd | 63 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985167.6891 | 2097369.3231 | 37.7381193834059 | -122.493819314943 | (37.7381193834059, -122.493819314943) | 1 | 8 | 3 | 29491 | 35 | |||
| 33753 | 186376 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1801 Sunset Blvd | 43 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984798.5659 | 2102512.3907 | 37.7522192455734 | -122.495474752392 | (37.7522192455734, -122.495474752392) | 1 | 8 | 3 | 56 | 35 | |||
| 40752 | 186924 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2700 Sunset Blvd | 73 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985155.3367 | 2096781.1077 | 37.7365035785089 | -122.493818687918 | (37.7365035785089, -122.493818687918) | 1 | 8 | 3 | 29491 | 35 | |||
| 45627 | 185725 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2101 Sunset Blvd | 57 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984855.2039 | 2100321.3236 | 37.7462064913622 | -122.495117336885 | (37.7462064913622, -122.495117336885) | 1 | 8 | 3 | 29491 | 35 | |||
| 47009 | 185730 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2101 Sunset Blvd | 62 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984911.7584 | 2100300.7286 | 37.7461532538825 | -122.494920263061 | (37.7461532538825, -122.494920263061) | 1 | 8 | 3 | 29491 | 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 | |||
| 52720 | 181542 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1300 Sunset Blvd | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984868.615 | 2105905.3126 | 37.7615393692586 | -122.495482733656 | (37.7615393692586, -122.495482733656) | 1 | 8 | 3 | 56 | 35 | |||
| 56534 | 185567 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2201 Sunset Blvd | 51 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984881.8296 | 2099726.3595 | 37.7445744404291 | -122.49498140754 | (37.7445744404291, -122.49498140754) | 1 | 8 | 3 | 29491 | 35 | |||
| 57141 | 185213 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2500 Sunset Blvd | 68 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985153.279 | 2098105.011 | 37.740138541922 | -122.493923339348 | (37.740138541922, -122.493923339348) | 1 | 8 | 3 | 29491 | 35 | |||
| 58049 | 39822 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2190 46th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | 1 | Permit Number 41149 | 5982045.5543 | 2100206.3838 | 37.7457260090551 | -122.504824075497 | (37.7457260090551, -122.504824075497) | 1 | 8 | 3 | 29491 | 35 | |
| 60359 | 181539 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1300 Sunset Blvd | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984878.0833 | 2105873.5659 | 37.7614527561104 | -122.4954476457 | (37.7614527561104, -122.4954476457) | 1 | 8 | 3 | 56 | 35 | |||
| 62055 | 186033 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1900 Sunset Blvd | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985025.9241 | 2102045.6103 | 37.7509509050251 | -122.494654114474 | (37.7509509050251, -122.494654114474) | 1 | 8 | 3 | 29491 | 35 | |||
| 65736 | 181548 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1300 Sunset Blvd | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984846.3366 | 2105995.5399 | 37.761785803641 | -122.495566439468 | (37.761785803641, -122.495566439468) | 1 | 8 | 3 | 56 | 35 | |||
| 67367 | 185877 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2000 Sunset Blvd | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985055.2583 | 2101098.876 | 37.7483531484939 | -122.494482892668 | (37.7483531484939, -122.494482892668) | 1 | 8 | 3 | 29491 | 35 | |||
| 67645 | 186087 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1901 Sunset Blvd | 33 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984862.8194 | 2101833.0892 | 37.7503578324165 | -122.495202467563 | (37.7503578324165, -122.495202467563) | 1 | 8 | 3 | 29491 | 35 | |||
| 68133 | 184745 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1301 Sunset Blvd | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984671.0844 | 2106181.5705 | 37.7622863276384 | -122.496186283596 | (37.7622863276384, -122.496186283596) | 1 | 8 | 3 | 56 | 35 | |||
| 70709 | 185874 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2000 Sunset Blvd | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985052.1017 | 2101064.154 | 37.7482576266138 | -122.494491248711 | (37.7482576266138, -122.494491248711) | 1 | 8 | 3 | 29491 | 35 | |||
| 71263 | 184997 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2701 Sunset Blvd | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985027.6641 | 2096515.5033 | 37.7357668292904 | -122.494240528594 | (37.7357668292904, -122.494240528594) | 1 | 8 | 3 | 29491 | 35 | |||
| 74838 | 186679 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1401 Sunset Blvd | 36 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984735.2903 | 2105403.229 | 37.760152980386 | -122.495906802394 | (37.760152980386, -122.495906802394) | 1 | 8 | 3 | 56 | 35 | |||
| 85976 | 186968 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2800 Sunset Blvd | 42 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985205.8316 | 2096154.4897 | 37.7347860066264 | -122.49359795025 | (37.7347860066264, -122.49359795025) | 1 | 8 | 3 | 29491 | 35 | |||
| 91101 | 187295 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2401 Sunset Blvd | 78 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984937.4924 | 2098259.4132 | 37.7405498608751 | -122.49468081102 | (37.7405498608751, -122.49468081102) | 1 | 8 | 3 | 29491 | 35 | |||
| 92132 | 186472 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1601 Sunset Blvd | 60 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984790.3524 | 2103740.0582 | 37.7555896005647 | -122.495593697553 | (37.7555896005647, -122.495593697553) | 1 | 8 | 3 | 56 | 35 | |||
| 93217 | 185721 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2101 Sunset Blvd | 53 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984915.0274 | 2100334.3998 | 37.7462458971959 | -122.494911441682 | (37.7462458971959, -122.494911441682) | 1 | 8 | 3 | 29491 | 35 | |||
| 94069 | 185734 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2101 Sunset Blvd | 66 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984861.0881 | 2100291.2484 | 37.7461242575362 | -122.495094773004 | (37.7461242575362, -122.495094773004) | 1 | 8 | 3 | 29491 | 35 | |||
| 95121 | 187305 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2401 Sunset Blvd | 88 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984977.8173 | 2098236.5366 | 37.7404894080916 | -122.49453969916 | (37.7404894080916, -122.49453969916) | 1 | 8 | 3 | 29491 | 35 | |||
| 95966 | 185218 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2500 Sunset Blvd | 75 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985145.9746 | 2098136.8849 | 37.7402256317054 | -122.493950943051 | (37.7402256317054, -122.493950943051) | 1 | 8 | 3 | 29491 | 35 | |||
| 106335 | 184804 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1301 Sunset Blvd | 65 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984679.0585 | 2105723.8188 | 37.7610299368102 | -122.496124931271 | (37.7610299368102, -122.496124931271) | 1 | 8 | 3 | 56 | 35 | |||
| 110842 | 39823 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2190 46th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | 1 | Permit Number 41149 | 5982046.2311 | 2100191.8316 | 37.7456860925771 | -122.504820657151 | (37.7456860925771, -122.504820657151) | 1 | 8 | 3 | 29491 | 35 | |
| 111475 | 184995 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2701 Sunset Blvd | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985022.2207 | 2096528.9025 | 37.7358033013739 | -122.494260335606 | (37.7358033013739, -122.494260335606) | 1 | 8 | 3 | 29491 | 35 | |||
| 115150 | 184741 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1301 Sunset Blvd | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984704.12 | 2106224.4787 | 37.7624060765448 | -122.496075193313 | (37.7624060765448, -122.496075193313) | 1 | 8 | 3 | 56 | 35 | |||
| 117659 | 186666 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1401 Sunset Blvd | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984702.5251 | 2105541.6172 | 37.7605310366787 | -122.49603032958 | (37.7605310366787, -122.49603032958) | 1 | 8 | 3 | 56 | 35 | |||
| 118078 | 185633 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2100 Sunset Blvd | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985076.9465 | 2100353.283 | 37.7463072224732 | -122.494352945117 | (37.7463072224732, -122.494352945117) | 1 | 8 | 3 | 29491 | 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) );