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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||||||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 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) | |||||
| 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) | ||||
| 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) | |||
| 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) | |
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 45421 | 45421 | 240621 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 219 Upper Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 52 | Width 3ft | 5999599.462169999 | 2106267.78648 | 37.7633861864367 | -122.444561006196 | (37.7633861864367, -122.444561006196) | |||
| 47961 | 47961 | 136435 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3 Broadway | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6013344.909530001 | 2118921.0971 | 37.7989040131614 | -122.39790729640801 | (37.7989040131614, -122.397907296408) | ||||
| 51336 | 51336 | 197580 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2151 17th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6010976.50521 | 2106453.15639 | 37.764537787215 | -122.405224355037 | (37.764537787215, -122.405224355037) | ||||
| 57311 | 57311 | 197586 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 1 Jack Balestreri Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 45 | Width 10ft | 6012374.628719999 | 2104733.59825 | 37.7598943275787 | -122.400267811735 | (37.7598943275787, -122.400267811735) | |||
| 58796 | 58796 | 240619 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 104 Saturn St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 6000003.92034 | 2105982.96119 | 37.762627197305605 | -122.443141663776 | (37.7626271973056, -122.443141663776) | |||
| 60533 | 60533 | 250200 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 203 Union St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 33 | Width 0ft | 6011776.4013 | 2119745.07747 | 37.8010789857668 | -122.403392881194 | (37.8010789857668, -122.403392881194) | |||
| 60930 | 60930 | 52819 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 1327@ JUDAH 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Permit Number 48844 | 5987385.2929 | 2106232.8495 | 37.7625857382219 | -122.48680274332399 | (37.7625857382219, -122.486802743324) | |||
| 62574 | 62574 | 240606 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2112 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 35 | Width 10ft | 6002638.80724 | 2099263.13099 | 37.7443260296246 | -122.43354829062099 | (37.7443260296246, -122.433548290621) | |||
| 64230 | 64230 | 118443 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 5201 Anza St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5982458.0361 | 2111659.95745 | 37.7771985159381 | -122.504246101222 | (37.7771985159381, -122.504246101222) | |||
| 65616 | 65616 | 247596 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 900 Tompkins Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 6009145.02453 | 2096408.71868 | 37.73685543873 | -122.410849521814 | (37.73685543873, -122.410849521814) | |||
| 69856 | 69856 | 136428 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 7 Kimball Pl | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 0ft | 6007991.83691 | 2116437.43612 | 37.791784918695 | -122.41625474228901 | (37.791784918695, -122.416254742289) | |||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||||
| 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) | ||
| 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) | |||
| 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) | |||||
| 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) | ||||
| 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) | ||||
| 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) | ||
| 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) | ||||
| 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) | ||||
| 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) | |||||
| 147227 | 147227 | 240599 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3229 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6006780.56286 | 2103771.69804 | 37.75693965177221 | -122.41954675558 | (37.7569396517722, -122.41954675558) | |||
| 147246 | 147246 | 215043 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 798 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 5996915.73734 | 2095029.5626400001 | 37.732375301382 | -122.453031809567 | (37.732375301382, -122.453031809567) | ||||
| 154175 | 154175 | 246775 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 925 Esmeralda Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6009505.54739 | 2098718.43829 | 37.743217635879205 | -122.409766015896 | (37.7432176358792, -122.409766015896) | ||||
| 162555 | 162555 | 120268 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 107 24th Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 5988313.3781 | 2115206.48473 | 37.7872789009445 | -122.48425101963899 | (37.7872789009445, -122.484251019639) | ||||
| 164767 | 164767 | 240612 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3637 22nd St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 6003932.88521 | 2103022.72642 | 37.7547223399723 | -122.429341685671 | (37.7547223399723, -122.429341685671) | |||
| 170379 | 170379 | 240622 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 5413 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6002024.955080001 | 2097832.75898 | 37.740363714714896 | -122.43556855014099 | (37.7403637147149, -122.435568550141) | ||||
| 173006 | 173006 | 240604 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 500 Grand View Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 5999982.42979 | 2101700.47656 | 37.750867318677 | -122.44290844709299 | (37.750867318677, -122.442908447093) | ||||
| 174768 | 174768 | 240608 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 3932 22nd St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 4ft | 6002275.446690001 | 2102986.9903700002 | 37.7545302429786 | -122.435070995746 | (37.7545302429786, -122.435070995746) | |||
| 178655 | 178655 | 197579 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 428 08th St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6010214.98706 | 2109650.78059 | 37.773275125388 | -122.408083778259 | (37.773275125388, -122.408083778259) | |||
| 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) | |
| 186205 | 186205 | 240616 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 685 Sanchez St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 5ft | 6003715.87711 | 2104249.40994 | 37.758078233932096 | -122.430179665856 | (37.7580782339321, -122.430179665856) | |||
| 187882 | 187882 | 215035 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 639 Hearst Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | 5997171.50868 | 2094376.6234 | 37.7305971411271 | -122.452100459987 | (37.7305971411271, -122.452100459987) | ||||
| 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) | ||||
| 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 | ||||||||
| 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 | ||||||||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 40766 | 40766 | 120272 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 129 24th Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 5988314.622169999 | 2115170.4665900003 | 37.7871800778407 | -122.48424407294901 | (37.7871800778407, -122.484244072949) | ||||
| 57707 | 57707 | 120269 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 107 24th Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 5988324.11159 | 2115191.8605299997 | 37.78723937201521 | -122.48421281158701 | (37.7872393720152, -122.484212811587) | ||||
| 65961 | 65961 | 250201 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 203 Union St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 29 | Width 0ft | 6011763.02504 | 2119743.5219400004 | 37.8010739675505 | -122.40343905958099 | (37.8010739675505, -122.403439059581) | |||
| 70280 | 70280 | 248053 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 19 Rutledge St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6010622.547590001 | 2099378.6850900003 | 37.7450930640901 | -122.405950205054 | (37.7450930640901, -122.405950205054) | ||||
| 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) |
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");