Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 70873 | 70873 | 240602 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 609 28th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6001920.90533 | 2099400.25112 | 37.7446617708226 | -122.436040449628 | (37.7446617708226, -122.436040449628) | |||
| 70926 | 70926 | 186856 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2700 Sunset Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985217.4528 | 2096293.5766 | 37.735168582064794 | -122.49356801735901 | (37.7351685820648, -122.493568017359) | |||
| 71023 | 71023 | 240631 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 57 Poppy Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002629.35658 | 2096548.6301400003 | 37.7368721031581 | -122.433387031387 | (37.7368721031581, -122.433387031387) | |||
| 71275 | 71275 | 187306 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2401 Sunset Blvd | 89 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984963.8587 | 2098228.7818 | 37.7404672985278 | -122.494587390296 | (37.7404672985278, -122.494587390296) | |||
| 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) | |||
| 72190 | 72190 | 179498 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 892 Peru Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 35 | 6005545.45161 | 2091807.84398 | 37.7240199601485 | -122.422967943043 | (37.7240199601485, -122.422967943043) | ||||
| 72927 | 72927 | 120273 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 129 24th Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 5988307.3728 | 2115160.02273 | 37.787150979882796 | -122.484268387653 | (37.7871509798828, -122.484268387653) | ||||
| 73058 | 73058 | 186967 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2800 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985210.5401 | 2096146.418 | 37.7347641193316 | -122.493581077021 | (37.7347641193316, -122.493581077021) | |||
| 73308 | 73308 | 187590 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 700 Goettingen St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6010709.76883 | 2091388.9815099998 | 37.7231599087791 | -122.40508613194599 | (37.7231599087791, -122.405086131946) | ||||
| 73560 | 73560 | 120270 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 107 24th Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 5988338.64874 | 2115186.1535400003 | 37.7872245486486 | -122.48416209809099 | (37.7872245486486, -122.484162098091) | ||||
| 73907 | 73907 | 186731 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1300 Sunset Blvd | 66 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984870.0408 | 2106303.059 | 37.7626315529982 | -122.495507139178 | (37.7626315529982, -122.495507139178) | |||
| 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) | |||
| 74195 | 74195 | 240615 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 297 Cumberland St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6003715.872169999 | 2104475.4119700002 | 37.75869878143 | -122.430195805998 | (37.75869878143, -122.430195805998) | |||
| 74221 | 74221 | 215021 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2624 14th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5992112.26225 | 2097456.03758 | 37.7387613350595 | -122.469814985494 | (37.7387613350595, -122.469814985494) | |||
| 74839 | 74839 | 187109 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2600 Sunset Blvd | 45 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985172.8615 | 2097253.1787 | 37.7378007845896 | -122.493792875188 | (37.7378007845896, -122.493792875188) | |||
| 75550 | 75550 | 186581 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1501 Sunset Blvd | 52 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5984771.5099 | 2104576.6683 | 37.75788559627829 | -122.495720567601 | (37.7578855962783, -122.495720567601) | |||
| 75777 | 75777 | 240625 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 5413 Diamond Heights Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6002051.53836 | 2097889.55934 | 37.7405211850978 | -122.43548069809799 | (37.7405211850978, -122.435480698098) | ||||
| 75876 | 75876 | 240607 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 888 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 6000718.67811 | 2102015.72187 | 37.751774854241795 | -122.44038504473 | (37.7517748542418, -122.44038504473) | |||
| 77228 | 77228 | 136442 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3 Broadway | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6013378.377640001 | 2118933.3014 | 37.7989393870992 | -122.397792341438 | (37.7989393870992, -122.397792341438) | ||||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 83100 | 83100 | 240610 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3944 22nd St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6002190.86574 | 2102965.81607 | 37.754467300333296 | -122.43536198397301 | (37.7544673003333, -122.435361983973) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||
| 88885 | 88885 | 370 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
| 89351 | 89351 | 116234 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 450 PERALTA AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6009750.0 | 2099218.0 | 37.744603019334 | -122.408955999129 | (37.744603019334, -122.408955999129) | ||||
| 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) | ||||
| 91300 | 91300 | 112804 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 219 UPPER TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3x3 | 5999620.0 | 2106355.0 | 37.7636268249183 | -122.444496241129 | (37.7636268249183, -122.444496241129) | |||
| 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) | ||||
| 92695 | 92695 | 375 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
| 96847 | 96847 | 376 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
| 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) | |||
| 101507 | 101507 | 381 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 16 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
| 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) | ||||||
| 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) | ||||
| 102899 | 102899 | 373 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
| 104001 | 104001 | 197581 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2101 17th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 35 | 6011118.65336 | 2106461.14792 | 37.7645676761706 | -122.40473326313601 | (37.7645676761706, -122.404733263136) | ||||
| 104910 | 104910 | 24794 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 7633 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5983299.41691 | 2112375.1982400003 | 37.7792118059508 | -122.50138846508999 | (37.7792118059508, -122.50138846509) | |||
| 105060 | 105060 | 380 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 16 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
| 105322 | 105322 | 181478 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1400 Sunset Blvd | 38 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984917.9059 | 2105334.1509 | 37.759974004815795 | -122.495270136852 | (37.7599740048158, -122.495270136852) | |||
| 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) | |||
| 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) | |||
| 107500 | 107500 | 54927 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 485 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/1972 12:00:00 AM | 10 | Permit Number 10801 | 6003402.69319537 | 2099776.66443458 | 37.745779384936206 | -122.43094357883498 | (37.7457793849362, -122.430943578835) | ||
| 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) | |||
| 114267 | 114267 | 95432 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2675 25th Ave | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 12 | 5988610.0 | 2097126.3 | 37.7376529013161 | -122.48189987005101 | (37.7376529013161, -122.481899870051) | ||||
| 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) | |||
| 115606 | 115606 | 95435 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2675 25th Ave | 2 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 12 | 5988610.0 | 2097126.3 | 37.7376529013161 | -122.48189987005101 | (37.7376529013161, -122.481899870051) | ||||
| 116259 | 116259 | 122587 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2500X Lyon St | 7 | Median : Cutout 11 | Tree 1 | Private 1 | 45 | 10x20 | 5999276.0 | 2117538.0 | 37.794312827392396 | -122.446490617691 | (37.7943128273924, -122.446490617691) | |||
| 116977 | 116977 | 371 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
| 117092 | 117092 | 113150 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 45 BRONTE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6009384.0 | 2097185.0 | 37.7390003361927 | -122.410078062228 | (37.7390003361927, -122.410078062228) | |||
| 117801 | 117801 | 27532 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
| 117865 | 117865 | 112928 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 2X Noe St | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 08/27/2015 12:00:00 AM | 3x3 | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.43349023202299 | (37.7683199626551, -122.433490232023) | |||
| 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) | |||||
| 122391 | 122391 | 374 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
| 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) | |||||
| 124243 | 124243 | 378 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
| 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) | |||||
| 125133 | 125133 | 377 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 12 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
| 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) | ||||
| 127597 | 127597 | 114509 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3X VULCAN STWY | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 56 | 6000640.0 | 2106231.0 | 37.7633444989385 | -122.440959493883 | (37.7633444989385, -122.440959493883) | ||||
| 127993 | 127993 | 122585 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2500X Lyon St | 5 | Median : Cutout 11 | Tree 1 | Private 1 | 70 | 10x20 | 5999276.0 | 2117538.0 | 37.794312827392396 | -122.446490617691 | (37.7943128273924, -122.446490617691) | |||
| 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) | ||||
| 129416 | 129416 | 379 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
| 131189 | 131189 | 179497 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 653 Peru Ave | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 8 | 6005046.66321 | 2092646.92983 | 37.7262957476241 | -122.424751842734 | (37.7262957476241, -122.424751842734) | ||||
| 131190 | 131190 | 246442 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 485 Duncan St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 6003379.46073 | 2099778.50621 | 37.7457831256083 | -122.431024044746 | (37.7457831256083, -122.431024044746) | ||||
| 131451 | 131451 | 136444 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3 Broadway | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | 6013387.59339 | 2118931.12048 | 37.798933912018704 | -122.397760298614 | (37.7989339120187, -122.397760298614) | ||||
| 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) | |||
| 134244 | 134244 | 120280 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 129 24th Ave | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 5988322.2380099995 | 2115131.91384 | 37.7870746664109 | -122.48421489568199 | (37.7870746664109, -122.484214895682) | ||||
| 134490 | 134490 | 215036 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 694 Hearst Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 5996922.84392 | 2094438.19015 | 37.7307519414457 | -122.45296456906901 | (37.7307519414457, -122.452964569069) | ||||
| 134633 | 134633 | 187307 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2401 Sunset Blvd | 90 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984946.0227 | 2098230.3328 | 37.740470513218796 | -122.49464917361601 | (37.7404705132188, -122.494649173616) | |||
| 135178 | 135178 | 215025 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 100 Terrace Dr | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 5993646.76934 | 2096691.5619299999 | 37.7367508538673 | -122.464453932502 | (37.7367508538673, -122.464453932502) | ||||
| 135635 | 135635 | 240594 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 216 Bemis St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 47 | 6003152.3623 | 2096416.5644900003 | 37.736539139077394 | -122.43156934507401 | (37.7365391390774, -122.431569345074) | ||||
| 136288 | 136288 | 181391 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1500 Sunset Blvd | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984921.4841 | 2104558.6525 | 37.757844911537 | -122.495200573085 | (37.757844911537, -122.495200573085) | |||
| 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) | |||
| 136684 | 136684 | 120271 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 129 24th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 5988306.39603 | 2115180.23903 | 37.7872064312039 | -122.48427325023998 | (37.7872064312039, -122.48427325024) | ||||
| 137793 | 137793 | 53580 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 148 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1973 12:00:00 AM | 34 | Permit Number 12426 | 5993993.6857199995 | 2114568.59854 | 37.7858565385613 | -122.46455217907699 | (37.7858565385613, -122.464552179077) | ||
| 137797 | 137797 | 118610 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 349 Point Lobos Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 5981717.62769 | 2112632.61479 | 37.77982557339521 | -122.506879529548 | (37.7798255733952, -122.506879529548) | ||||
| 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) | ||||
| 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) |
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");