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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 79534 | 79534 | 121404 | Property Tree 7 | Sequoia sempervirens :: Coast Redwood 116 | 1900 08th Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 10x10 | 5993817.0 | 2102486.0 | 37.7526707300666 | -122.464285931649 | (37.7526707300666, -122.464285931649) | |||
| 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) | ||||
| 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) | ||||||
| 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) | |||||
| 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) | ||||||
| 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) | |||||
| 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) | ||||
| 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) | ||||
| 87470 | 87470 | 102106 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 50X Noe St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/19/2012 12:00:00 AM | 25 | Permit Number 769282 | 6002816.1 | 2107996.5 | 37.7683158318555 | -122.433559261751 | (37.7683158318555, -122.433559261751) | ||
| 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) | ||||
| 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) | |||||
| 97021 | 97021 | 106360 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 1820 POST ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6003351.1 | 2114201.6 | 37.785383838011 | -122.43215193232099 | (37.785383838011, -122.432151932321) | ||||
| 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) | |||
| 102600 | 102600 | 106362 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 1645 WEBSTER ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6003301.2 | 2114333.7 | 37.7857437219688 | -122.432334009178 | (37.7857437219688, -122.432334009178) | ||||
| 106535 | 106535 | 113163 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 1300X STANYAN ST | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 3x3 | 5997565.0 | 2104877.0 | 37.7594511396077 | -122.451497194349 | (37.7594511396077, -122.451497194349) | |||
| 111685 | 111685 | 107343 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 110 JULIAN AVE | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | 6006340.8 | 2107214.1 | 37.7663669011591 | -122.421312071366 | (37.7663669011591, -122.421312071366) | ||||
| 112251 | 112251 | 113162 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 1300X STANYAN ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 3x3 | 5997565.0 | 2104877.0 | 37.7594511396077 | -122.451497194349 | (37.7594511396077, -122.451497194349) | |||
| 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) | |||||
| 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) | |||
| 117092 | 117092 | 113150 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 45 BRONTE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6009384.0 | 2097185.0 | 37.7390003361927 | -122.410078062228 | (37.7390003361927, -122.410078062228) | |||
| 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) | |||
| 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) | |||||
| 125999 | 125999 | 106361 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 1645 WEBSTER ST | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6003301.2 | 2114333.7 | 37.7857437219688 | -122.432334009178 | (37.7857437219688, -122.432334009178) | ||||
| 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) | ||||
| 139589 | 139589 | 109576 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 21X STILLINGS AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 60 | 6000417.0 | 2095694.0 | 37.7343997262189 | -122.44097481223999 | (37.7343997262189, -122.44097481224) | ||||
| 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) | |||
| 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) | |||||
| 85994 | 85994 | 104510 | Private 5 | Sequoia sempervirens :: Coast Redwood 116 | 254 ALLISON ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 40 | 6000052.0 | 2087408.0 | 37.7116274717654 | -122.441642291463 | (37.7116274717654, -122.441642291463) | ||||
| 838 | 838 | 19815 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 100 STAIRWAY24 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 100ST | ||||||||
| 4452 | 4452 | 19593 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 100 STAIRWAY4 | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | ||||||||
| 5737 | 5737 | 20074 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 100 STAIRWAY55 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 27X | ||||||||
| 6387 | 6387 | 19592 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 100 STAIRWAY4 | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | ||||||||
| 7219 | 7219 | 20014 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 100 STAIRWAY47 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 100ST | ||||||||
| 7290 | 7290 | 19816 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 100 STAIRWAY24 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 100ST | ||||||||
| 10060 | 10060 | 19578 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 100 STAIRWAY4 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 8 | ||||||||
| 11264 | 11264 | 117179 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 350x Winding Way | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 3x3 | 6001167.67306 | 2086580.24641 | 37.7094181465037 | -122.43772698870701 | (37.7094181465037, -122.437726988707) | |||
| 12451 | 12451 | 20015 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 100 STAIRWAY47 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 100ST | ||||||||
| 13822 | 13822 | 20456 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 495X Sunset Blvd | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | ||||||||
| 15735 | 15735 | 19811 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 100 STAIRWAY24 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 100ST | ||||||||
| 20116 | 20116 | 2370 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 2516 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4PL | 6009703.1421 | 2102664.68486 | 37.7540642287015 | -122.40936121487499 | (37.7540642287015, -122.409361214875) | |||
| 21212 | 21212 | 11673 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 700X Junipero Serra Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991295.1451900005 | 2092921.61878 | 37.7262636985024 | -122.47230970662399 | (37.7262636985024, -122.472309706624) | ||
| 29906 | 29906 | 250138 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 2550x Lyon St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 101 | 5999227.62567 | 2117605.22496 | 37.7944946461503 | -122.446662836939 | (37.7944946461503, -122.446662836939) | ||||
| 41136 | 41136 | 250136 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 2550x Lyon St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 100 | 5999230.194080001 | 2117561.109 | 37.794373662156296 | -122.446650774326 | (37.7943736621563, -122.446650774326) | ||||
| 42971 | 42971 | 111268 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 700X BOSWORTH ST | 6 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3 | 6002150.0 | 2095428.0 | 37.73376790368221 | -122.434964255854 | (37.7337679036822, -122.434964255854) | ||||
| 76485 | 76485 | 197585 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 900x Carolina St | 75 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6012517.30691 | 2102783.51804 | 37.7545477896502 | -122.399637433715 | (37.7545477896502, -122.399637433715) | ||||
| 85054 | 85054 | 111269 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 700X BOSWORTH ST | 7 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3 | 6002150.0 | 2095428.0 | 37.73376790368221 | -122.434964255854 | (37.7337679036822, -122.434964255854) | ||||
| 86068 | 86068 | 121227 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 4299x 17th St | 3 | Front Yard : Yard 7 | Tree 1 | DPW 2 | ||||||||||
| 88274 | 88274 | 3774 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 1098 Carolina St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 18 | 6012462.6103665 | 2102859.9036449 | 37.754754478768 | -122.39983195341699 | (37.754754478768, -122.399831953417) | |||
| 93306 | 93306 | 116660 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 199x Esmeralda Ave | 13 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 8 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | ||||
| 114763 | 114763 | 112145 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 401X ROOSEVELT WAY | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6000065.0 | 2106738.0 | 37.764703828929896 | -122.44298463673401 | (37.7647038289299, -122.442984636734) | ||||
| 119676 | 119676 | 6389 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 40 Entrada Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60M | 5992282.41809 | 2092443.27672 | 37.725007378570105 | -122.468861992007 | (37.7250073785701, -122.468861992007) | |||
| 148971 | 148971 | 215030 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 300x Marietta Dr | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 5ft | 5999282.59402 | 2097567.7247599997 | 37.7394798538026 | -122.44503146673401 | (37.7394798538026, -122.445031466734) | |||
| 153969 | 153969 | 215031 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 300x Marietta Dr | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 5ft | 5999287.157930001 | 2097565.9418 | 37.739475218703106 | -122.445015558643 | (37.7394752187031, -122.445015558643) | |||
| 154287 | 154287 | 215034 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 300x Marietta Dr | 32 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | Width 5ft | 5999319.41307 | 2097556.59014 | 37.7394513821643 | -122.444903362803 | (37.7394513821643, -122.444903362803) | |||
| 167020 | 167020 | 179495 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 350x Winding Way | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6001141.4285699995 | 2086583.09342 | 37.7094244714452 | -122.43781789759 | (37.7094244714452, -122.43781789759) | |||
| 169462 | 169462 | 215032 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 300x Marietta Dr | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 5ft | 5999291.25805 | 2097565.13306 | 37.739473232107 | -122.44500132414801 | (37.739473232107, -122.445001324148) | |||
| 175662 | 175662 | 215033 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 300x Marietta Dr | 28 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 5ft | 5999299.88675 | 2097560.85432 | 37.739461976177395 | -122.44497118247699 | (37.7394619761774, -122.444971182477) | |||
| 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) | ||||
| 12707 | 12707 | 107222 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 327 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/29/2014 12:00:00 AM | 3 | 6x5 | Permit Number 773943 | 6003989.6035400005 | 2091508.12122 | 37.7231090719178 | -122.42832491578301 | (37.7231090719178, -122.428324915783) | |
| 24557 | 24557 | 136431 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 13 MacOndray Ln | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | 6008632.90068 | 2119166.6230200003 | 37.799314619318 | -122.414229834152 | (37.799314619318, -122.414229834152) | ||||
| 25384 | 25384 | 185213 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2500 Sunset Blvd | 68 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985153.279 | 2098105.011 | 37.740138541922 | -122.49392333934799 | (37.740138541922, -122.493923339348) | |||
| 26484 | 26484 | 184736 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1301 Sunset Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984658.5537 | 2106283.3352 | 37.762565010947704 | -122.49623713063801 | (37.7625650109477, -122.496237130638) | |||
| 27330 | 27330 | 187124 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2600 Sunset Blvd | 60 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985135.2439 | 2097353.8058 | 37.738074878751895 | -122.493930349328 | (37.7380748787519, -122.493930349328) | |||
| 27359 | 27359 | 240611 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 255 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003497.9531 | 2101542.75011 | 37.750634040826796 | -122.43074019171699 | (37.7506340408268, -122.430740191717) | |||
| 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) | |||
| 29908 | 29908 | 249959 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 273 Filbert St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | Width 0ft | 6011558.5565599995 | 2120064.53903 | 37.801943979781896 | -122.40416921824301 | (37.8019439797819, -122.404169218243) | |||
| 30053 | 30053 | 240601 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 609 28th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6001917.090969999 | 2099400.07719 | 37.744661076553 | -122.43605362647301 | (37.744661076553, -122.436053626473) | |||
| 30220 | 30220 | 181484 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1400 Sunset Blvd | 44 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984898.4123 | 2105356.9862 | 37.7600355628364 | -122.49533923888201 | (37.7600355628364, -122.495339238882) | |||
| 31261 | 31261 | 215028 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 100 Terrace Dr | 23 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5993755.12546 | 2096561.9752 | 37.7364012864951 | -122.464069896803 | (37.7364012864951, -122.464069896803) | ||||
| 33291 | 33291 | 240614 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3637 22nd St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 6003933.5831699995 | 2103025.57629 | 37.7547302045579 | -122.429339475147 | (37.7547302045579, -122.429339475147) | |||
| 34861 | 34861 | 240630 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 32 Harry St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 35 | 6003226.48563 | 2097681.33135 | 37.7400160997695 | -122.43140332841999 | (37.7400160997695, -122.43140332842) | ||||
| 35086 | 35086 | 185875 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2000 Sunset Blvd | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985024.3241 | 2101081.1994 | 37.74830280287971 | -122.494588557862 | (37.7483028028797, -122.494588557862) | |||
| 35152 | 35152 | 215041 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 497 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5998794.49638 | 2094951.64479 | 37.732268849509104 | -122.44653092436701 | (37.7322688495091, -122.446530924367) | |||
| 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) | |||
| 35570 | 35570 | 240617 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 685 Sanchez St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 5ft | 6003712.72581 | 2104261.51662 | 37.7581112975082 | -122.43019142809099 | (37.7581112975082, -122.430191428091) | |||
| 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) | |||
| 36375 | 36375 | 136443 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3 Broadway | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6013384.0493 | 2118922.9353099996 | 37.7989112401317 | -122.39777198798201 | (37.7989112401317, -122.397771987982) | ||||
| 36809 | 36809 | 215040 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 88 Ashton Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 5994178.77111 | 2090487.7098599998 | 37.71974724151371 | -122.46216479907 | (37.7197472415137, -122.46216479907) | ||||
| 37950 | 37950 | 247598 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 900 Tompkins Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 10ft | 6009167.823059999 | 2096407.9062599998 | 37.7368544863348 | -122.410770639572 | (37.7368544863348, -122.410770639572) | |||
| 38099 | 38099 | 200496 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3239 Jennings St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6013542.8885 | 2090062.874 | 37.7196766561509 | -122.39519967454399 | (37.7196766561509, -122.395199674544) | |||
| 38278 | 38278 | 215037 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 314 Staples Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 5997982.72892 | 2093830.4607099998 | 37.7291439428352 | -122.449256629186 | (37.7291439428352, -122.449256629186) | ||||
| 38586 | 38586 | 246713 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1 Bonview St | 19 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | 6007763.89494 | 2099225.75212 | 37.7445128502976 | -122.415824124379 | (37.7445128502976, -122.415824124379) | ||||
| 38662 | 38662 | 215039 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 179 Ashton Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 32 | 5994134.23715 | 2091156.84385 | 37.721581958319504 | -122.462367242757 | (37.7215819583195, -122.462367242757) | ||||
| 39303 | 39303 | 118611 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 349 Point Lobos Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 5981718.6857199995 | 2112644.15815 | 37.7798573303546 | -122.506876725888 | (37.7798573303546, -122.506876725888) | ||||
| 39748 | 39748 | 240597 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 523 Powhattan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 29 | 6008567.55649 | 2098119.2319799997 | 37.741519737445294 | -122.412966995358 | (37.7415197374453, -122.412966995358) | ||||
| 40236 | 40236 | 120278 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 129 24th Ave | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 5988337.84774 | 2115148.37916 | 37.7871207843354 | -122.48416209808799 | (37.7871207843354, -122.484162098088) | ||||
| 40320 | 40320 | 187361 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2200 Sunset Blvd | 46 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985088.1562 | 2099814.8531 | 37.7448294961486 | -122.49427450340099 | (37.7448294961486, -122.494274503401) |
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");