Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1817 | 1817 | 251719 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 1301 Clayton St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5999055.0 | 2105304.0 | 37.7607087868046 | -122.446374778866 | (37.7607087868046, -122.446374778866) | |||||
| 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) | ||||
| 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 | |||||||||
| 20974 | 20974 | 109568 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 95 Nordhoff St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | Permit Number 777169 | 6000348.8 | 2095645.6 | 37.734262946491704 | -122.44120712981501 | (37.7342629464917, -122.441207129815) | ||||
| 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) | |||
| 77818 | 77818 | 108026 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 862 Kansas St | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 774734 | 6011570.0 | 2104296.0 | 37.758647879927395 | -122.403019866682 | (37.7586478799274, -122.403019866682) | |||||
| 78522 | 78522 | 112919 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 2X Noe St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.43349023202299 | (37.7683199626551, -122.433490232023) | ||||
| 81040 | 81040 | 112918 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 2X Noe St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.43349023202299 | (37.7683199626551, -122.433490232023) | ||||
| 81067 | 81067 | 113358 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 702 Foerster St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5998153.40008835 | 2095558.62470631 | 37.733898832504295 | -122.448791034412 | (37.7338988325043, -122.448791034412) | |||||
| 82219 | 82219 | 97945 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 2 Mendosa Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 768165 | 5993624.4 | 2101138.5 | 37.748959736293294 | -122.464854121346 | (37.7489597362933, -122.464854121346) | ||||
| 85824 | 85824 | 112921 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 2X Noe St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.43349023202299 | (37.7683199626551, -122.433490232023) | ||||
| 86068 | 86068 | 121227 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 4299x 17th St | 3 | Front Yard : Yard 7 | Tree 1 | DPW 2 | ||||||||||
| 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) | ||
| 86911 | 86911 | 87150 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 4 Bellair Pl | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | Permit Number 50135 | 6010093.0 | 2120950.0 | 37.8042932388788 | -122.409303278994 | (37.8042932388788, -122.409303278994) | ||||
| 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) | ||||
| 89530 | 89530 | 112922 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 2X Noe St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.43349023202299 | (37.7683199626551, -122.433490232023) | ||||
| 91222 | 91222 | 98597 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 400X Steiner St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 768529 | 6004639.0 | 2109849.0 | 37.7735056071657 | -122.42738600543899 | (37.7735056071657, -122.427386005439) | ||||
| 91679 | 91679 | 94535 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 265 Dorland St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6003831.0 | 2105693.0 | 37.7620485075454 | -122.42988449123301 | (37.7620485075454, -122.429884491233) | |||||
| 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) | ||||
| 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) | ||||
| 100317 | 100317 | 113359 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 702 Foerster St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5998153.40008835 | 2095558.62470631 | 37.733898832504295 | -122.448791034412 | (37.7338988325043, -122.448791034412) | |||||
| 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) | |||
| 102307 | 102307 | 99256 | Property Tree 7 | Sequoia sempervirens :: Coast Redwood 116 | 1466 York St | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010099.0 | 2100741.0 | 37.7488043872035 | -122.407856595429 | (37.7488043872035, -122.407856595429) | ||||||
| 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) | ||
| 106132 | 106132 | 97857 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 895 Indiana St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
| 106519 | 106519 | 105769 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/24/2014 12:00:00 AM | Permit Number 772589 | 5990111.8 | 2090190.8 | 37.718696994740704 | -122.476201051717 | (37.7186969947407, -122.476201051717) | |||
| 114761 | 114761 | 112559 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 1735x GRANT AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010373.0 | 2120454.0 | 37.8029470287696 | -122.40829930674299 | (37.8029470287696, -122.408299306743) | |||||
| 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) | |||
| 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) | |||
| 121387 | 121387 | 97856 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 895 Indiana St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
| 123320 | 123320 | 109532 | Sequoia sempervirens :: Coast Redwood 116 | 818 Goettingen St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010847.3 | 2090865.3 | 37.7217296747854 | -122.404573864697 | (37.7217296747854, -122.404573864697) | ||||||
| 123802 | 123802 | 97853 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 895 Indiana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
| 124987 | 124987 | 98548 | Property Tree 7 | Sequoia sempervirens :: Coast Redwood 116 | 132 Hamerton Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6001332.8 | 2095440.7 | 37.7337563407686 | -122.437790462907 | (37.7337563407686, -122.437790462907) | |||||
| 125077 | 125077 | 87149 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 4 Bellair Pl | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010093.0 | 2120950.0 | 37.8042932388788 | -122.409303278994 | (37.8042932388788, -122.409303278994) | |||||
| 128076 | 128076 | 112923 | 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) | ||||
| 139938 | 139938 | 97854 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 895 Indiana St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
| 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) | ||||
| 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) | ||||
| 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) | |||||
| 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) | |||
| 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) | |||
| 29532 | 29532 | 186369 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1801 Sunset Blvd | 36 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984816.0737 | 2102538.2484 | 37.7522912688492 | -122.495416115464 | (37.7522912688492, -122.495416115464) | |||
| 35177 | 35177 | 184804 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1301 Sunset Blvd | 65 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984679.0585 | 2105723.8188 | 37.7610299368102 | -122.496124931271 | (37.7610299368102, -122.496124931271) | |||
| 36125 | 36125 | 186472 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1601 Sunset Blvd | 60 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984790.3524 | 2103740.0582 | 37.755589600564704 | -122.495593697553 | (37.7555896005647, -122.495593697553) | |||
| 40656 | 40656 | 186033 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1900 Sunset Blvd | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985025.9241 | 2102045.6103 | 37.7509509050251 | -122.49465411447399 | (37.7509509050251, -122.494654114474) | |||
| 40898 | 40898 | 185564 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2201 Sunset Blvd | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984920.5667 | 2099758.7289 | 37.744665585625896 | -122.494849850524 | (37.7446655856259, -122.494849850524) | |||
| 44202 | 44202 | 186673 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1401 Sunset Blvd | 30 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984739.5822 | 2105465.3048 | 37.7603236745559 | -122.495896538326 | (37.7603236745559, -122.495896538326) | |||
| 47580 | 47580 | 186579 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1501 Sunset Blvd | 50 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5984739.2681 | 2104595.0921 | 37.7579342947119 | -122.495833430643 | (37.7579342947119, -122.495833430643) | |||
| 50233 | 50233 | 187392 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2100 Sunset Blvd | 45 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985024.2566 | 2100630.9061 | 37.7470664162932 | -122.494555600597 | (37.7470664162932, -122.494555600597) | |||
| 51589 | 51589 | 184745 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1301 Sunset Blvd | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984671.0844 | 2106181.5705 | 37.7622863276384 | -122.496186283596 | (37.7622863276384, -122.496186283596) | |||
| 55573 | 55573 | 184741 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1301 Sunset Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984704.12 | 2106224.4787 | 37.76240607654479 | -122.496075193313 | (37.7624060765448, -122.496075193313) | |||
| 57134 | 57134 | 186036 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1900 Sunset Blvd | 31 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985023.9883 | 2102086.2614 | 37.7510624084937 | -122.49466380518 | (37.7510624084937, -122.49466380518) | |||
| 63429 | 63429 | 181539 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1300 Sunset Blvd | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984878.0833 | 2105873.5659 | 37.761452756110394 | -122.4954476457 | (37.7614527561104, -122.4954476457) | |||
| 63967 | 63967 | 185633 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2100 Sunset Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985076.9465 | 2100353.2830000003 | 37.7463072224732 | -122.494352945117 | (37.7463072224732, -122.494352945117) | |||
| 64455 | 64455 | 181395 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1500 Sunset Blvd | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984933.1803 | 2104579.26 | 37.7579021787746 | -122.495161642957 | (37.7579021787746, -122.495161642957) | |||
| 66493 | 66493 | 185214 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2500 Sunset Blvd | 70 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985123.3973 | 2098105.6751 | 37.7401386169566 | -122.494026705548 | (37.7401386169566, -122.494026705548) | |||
| 69472 | 69472 | 181545 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1300 Sunset Blvd | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984885.3237 | 2105962.1224 | 37.7616963314413 | -122.495429135957 | (37.7616963314413, -122.495429135957) | |||
| 71910 | 71910 | 186966 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2800 Sunset Blvd | 40 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985198.0961 | 2096141.0368 | 37.734748616014 | -122.493623703195 | (37.734748616014, -122.493623703195) | |||
| 74058 | 74058 | 186679 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1401 Sunset Blvd | 36 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984735.2903 | 2105403.2290000003 | 37.760152980386 | -122.495906802394 | (37.760152980386, -122.495906802394) | |||
| 74083 | 74083 | 187107 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2600 Sunset Blvd | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985143.7078 | 2097238.6019 | 37.73775905490071 | -122.49389259826401 | (37.7377590549007, -122.493892598264) | |||
| 132343 | 132343 | 185730 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2101 Sunset Blvd | 62 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984911.7584 | 2100300.7286 | 37.7461532538825 | -122.494920263061 | (37.7461532538825, -122.494920263061) | |||
| 134037 | 134037 | 186968 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2800 Sunset Blvd | 42 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985205.8316 | 2096154.4897 | 37.73478600662639 | -122.49359795024999 | (37.7347860066264, -122.49359795025) | |||
| 136491 | 136491 | 185568 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2201 Sunset Blvd | 52 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984938.6086 | 2099724.7676 | 37.74457339320529 | -122.49478496266701 | (37.7445733932053, -122.494784962667) | |||
| 146439 | 146439 | 187127 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2600 Sunset Blvd | 63 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985167.6891 | 2097369.3231 | 37.7381193834059 | -122.49381931494301 | (37.7381193834059, -122.493819314943) | |||
| 148152 | 148152 | 186376 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1801 Sunset Blvd | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984798.5659 | 2102512.3907 | 37.7522192455734 | -122.495474752392 | (37.7522192455734, -122.495474752392) | |||
| 149148 | 149148 | 185877 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2000 Sunset Blvd | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985055.2583 | 2101098.876 | 37.7483531484939 | -122.494482892668 | (37.7483531484939, -122.494482892668) | |||
| 152219 | 152219 | 184995 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2701 Sunset Blvd | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985022.2207 | 2096528.9025 | 37.7358033013739 | -122.494260335606 | (37.7358033013739, -122.494260335606) | |||
| 153678 | 153678 | 187305 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2401 Sunset Blvd | 88 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984977.8173 | 2098236.5366 | 37.740489408091605 | -122.49453969916 | (37.7404894080916, -122.49453969916) | |||
| 156845 | 156845 | 186677 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1401 Sunset Blvd | 34 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984721.4724 | 2105427.5149 | 37.760218853394605 | -122.49595638286101 | (37.7602188533946, -122.495956382861) | |||
| 159687 | 159687 | 185874 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2000 Sunset Blvd | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985052.1017 | 2101064.154 | 37.7482576266138 | -122.494491248711 | (37.7482576266138, -122.494491248711) | |||
| 161471 | 161471 | 185566 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2201 Sunset Blvd | 50 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984882.0949 | 2099749.7079 | 37.744638564328 | -122.49498221146901 | (37.744638564328, -122.494982211469) | |||
| 163231 | 163231 | 185218 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2500 Sunset Blvd | 75 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985145.9746 | 2098136.8849 | 37.7402256317054 | -122.49395094305099 | (37.7402256317054, -122.493950943051) | |||
| 167123 | 167123 | 185567 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2201 Sunset Blvd | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984881.8296 | 2099726.3595 | 37.7445744404291 | -122.49498140754 | (37.7445744404291, -122.49498140754) | |||
| 167471 | 167471 | 181542 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1300 Sunset Blvd | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984868.615 | 2105905.3126 | 37.7615393692586 | -122.495482733656 | (37.7615393692586, -122.495482733656) | |||
| 168787 | 168787 | 181548 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1300 Sunset Blvd | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984846.3366 | 2105995.5399 | 37.761785803641 | -122.495566439468 | (37.761785803641, -122.495566439468) | |||
| 170341 | 170341 | 186034 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1900 Sunset Blvd | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984985.7569 | 2102048.9979 | 37.7509578553481 | -122.494793264221 | (37.7509578553481, -122.494793264221) | |||
| 171352 | 171352 | 185725 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2101 Sunset Blvd | 57 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984855.2039 | 2100321.3236 | 37.7462064913622 | -122.49511733688499 | (37.7462064913622, -122.495117336885) | |||
| 171538 | 171538 | 186924 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2700 Sunset Blvd | 73 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985155.3367 | 2096781.1077 | 37.736503578508895 | -122.493818687918 | (37.7365035785089, -122.493818687918) | |||
| 171617 | 171617 | 187295 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2401 Sunset Blvd | 78 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984937.4924 | 2098259.4132 | 37.7405498608751 | -122.49468081101999 | (37.7405498608751, -122.49468081102) | |||
| 172139 | 172139 | 186477 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1601 Sunset Blvd | 65 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984748.0613 | 2103717.4471 | 37.7555250401648 | -122.49573828341299 | (37.7555250401648, -122.495738283413) | |||
| 174989 | 174989 | 185220 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2500 Sunset Blvd | 77 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985128.7096 | 2098140.8692 | 37.7402355613282 | -122.49401093116998 | (37.7402355613282, -122.49401093117) | |||
| 175534 | 175534 | 39823 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 2190 46th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | 1 | Permit Number 41149 | 5982046.2311 | 2100191.8316 | 37.7456860925771 | -122.50482065715099 | (37.7456860925771, -122.504820657151) | |
| 177016 | 177016 | 39822 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 2190 46th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | 1 | Permit Number 41149 | 5982045.5543 | 2100206.3838 | 37.7457260090551 | -122.504824075497 | (37.7457260090551, -122.504824075497) | |
| 177279 | 177279 | 186668 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1401 Sunset Blvd | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984695.4068 | 2105524.4495 | 37.7604834820457 | -122.49605368158001 | (37.7604834820457, -122.49605368158) | |||
| 178388 | 178388 | 184997 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2701 Sunset Blvd | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985027.6641 | 2096515.5033 | 37.7357668292904 | -122.49424052859399 | (37.7357668292904, -122.494240528594) | |||
| 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) | |
| 182897 | 182897 | 185734 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2101 Sunset Blvd | 66 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984861.0881 | 2100291.2484 | 37.7461242575362 | -122.495094773004 | (37.7461242575362, -122.495094773004) | |||
| 183935 | 183935 | 186666 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1401 Sunset Blvd | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984702.5251 | 2105541.6172 | 37.76053103667871 | -122.49603032958001 | (37.7605310366787, -122.49603032958) | |||
| 184462 | 184462 | 185721 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2101 Sunset Blvd | 53 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984915.0274 | 2100334.3998 | 37.7462458971959 | -122.49491144168199 | (37.7462458971959, -122.494911441682) | |||
| 187185 | 187185 | 186923 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2700 Sunset Blvd | 72 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985171.3814 | 2096790.2761 | 37.73652969119129 | -122.493763890804 | (37.7365296911913, -122.493763890804) | |||
| 188847 | 188847 | 186087 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1901 Sunset Blvd | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984862.8194 | 2101833.0892 | 37.7503578324165 | -122.495202467563 | (37.7503578324165, -122.495202467563) | |||
| 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) |
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");