trees
349 rows where qSpecies_id = 155 sorted by Supervisor Districts
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts ▼ | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1476 | 20456 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 495X Sunset Blvd | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | |||||||||||||
| 3222 | 20014 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 STAIRWAY47 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 100ST | |||||||||||||
| 3904 | 121227 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 4299x 17th St | 3 | Front Yard : Yard | Tree | DPW 1 | |||||||||||||||
| 7510 | 20015 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 STAIRWAY47 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 100ST | |||||||||||||
| 8551 | 19592 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 STAIRWAY4 | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | |||||||||||||
| 8687 | 19815 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 STAIRWAY24 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 100ST | |||||||||||||
| 11754 | 20074 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 STAIRWAY55 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 27X | |||||||||||||
| 16052 | 19578 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 STAIRWAY4 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 8 | |||||||||||||
| 16197 | 19811 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 STAIRWAY24 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 100ST | |||||||||||||
| 16768 | 19816 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 STAIRWAY24 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 100ST | |||||||||||||
| 17000 | 19593 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 STAIRWAY4 | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | |||||||||||||
| 19465 | 96173 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | Unaccepted Street : Cutout | Tree | Private 2 | 04/04/2011 12:00:00 AM | 3x3 | Permit Number 767806 | ||||||||||||||
| 1427 | 260648 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 3891 Sacramento St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 7ft | 5996301.11796 | 2114890.85877 | 37.7868741256738 | -122.456592467462 | (37.7868741256738, -122.456592467462) | 11 | 6 | 1 | 54 | 31 | ||||
| 4071 | 260649 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 3891 Sacramento St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | Width 7ft | 5996301.11796 | 2114890.85877 | 37.7868741256738 | -122.456592467462 | (37.7868741256738, -122.456592467462) | 11 | 6 | 1 | 54 | 31 | ||||
| 9964 | 262274 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 4 Montclair Ter | 1 | Side Yard : Yard | Tree | Private 2 | 6007298.70359 | 2120216.09204 | 37.8021211637502 | -122.418921105258 | (37.8021211637502, -122.418921105258) | 5 | 1 | 1 | 28858 | 32 | |||||
| 18013 | 120281 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 129 24th Ave | 11 | Front Yard : Yard | Tree | Private 2 | 15 | 5988339.23027 | 2115128.35436 | 37.7870658824376 | -122.484155845816 | (37.7870658824376, -122.484155845816) | 11 | 6 | 1 | 55 | 33 | ||||
| 21279 | 122585 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 2500X Lyon St | 5 | Median : Cutout | Tree | Private 2 | 70 | 10x20 | 5999276 | 2117538 | 37.7943128273924 | -122.446490617691 | (37.7943128273924, -122.446490617691) | 13 | 9 | 1 | 57 | 27 | |||
| 27029 | 120269 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 107 24th Ave | 2 | Front Yard : Yard | Tree | Private 2 | 15 | 5988324.11159 | 2115191.86053 | 37.7872393720152 | -122.484212811587 | (37.7872393720152, -122.484212811587) | 11 | 6 | 1 | 55 | 33 | ||||
| 27519 | 120272 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 129 24th Ave | 2 | Front Yard : Yard | Tree | Private 2 | 13 | 5988314.62217 | 2115170.46659 | 37.7871800778407 | -122.484244072949 | (37.7871800778407, -122.484244072949) | 11 | 6 | 1 | 55 | 33 | ||||
| 37051 | 120275 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 129 24th Ave | 5 | Front Yard : Yard | Tree | Private 2 | 11 | 5988318.18285 | 2115148.99603 | 37.7871213331252 | -122.484230178713 | (37.7871213331252, -122.484230178713) | 11 | 6 | 1 | 55 | 33 | ||||
| 38334 | 250138 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2550x Lyon St | 6 | Median : Yard | Tree | DPW 1 | 101 | 5999227.62567 | 2117605.22496 | 37.7944946461503 | -122.446662836939 | (37.7944946461503, -122.446662836939) | 13 | 9 | 1 | 57 | 27 | ||||
| 49215 | 120268 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 107 24th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 15 | 5988313.3781 | 2115206.48473 | 37.7872789009445 | -122.484251019639 | (37.7872789009445, -122.484251019639) | 11 | 6 | 1 | 55 | 33 | ||||
| 53373 | 250136 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2550x Lyon St | 3 | Median : Yard | Tree | DPW 1 | 100 | 5999230.19408 | 2117561.109 | 37.7943736621563 | -122.446650774326 | (37.7943736621563, -122.446650774326) | 13 | 9 | 1 | 57 | 27 | ||||
| 66718 | 120273 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 129 24th Ave | 3 | Front Yard : Yard | Tree | Private 2 | 16 | 5988307.3728 | 2115160.02273 | 37.7871509798828 | -122.484268387653 | (37.7871509798828, -122.484268387653) | 11 | 6 | 1 | 55 | 33 | ||||
| 68769 | 120270 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 107 24th Ave | 3 | Front Yard : Yard | Tree | Private 2 | 11 | 5988338.64874 | 2115186.15354 | 37.7872245486486 | -122.484162098091 | (37.7872245486486, -122.484162098091) | 11 | 6 | 1 | 55 | 33 | ||||
| 72541 | 120276 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 129 24th Ave | 6 | Front Yard : Yard | Tree | Private 2 | 13 | 5988325.261 | 2115160.84311 | 37.7871542739482 | -122.484206559328 | (37.7871542739482, -122.484206559328) | 11 | 6 | 1 | 55 | 33 | ||||
| 74028 | 136430 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1101 Greenwich St | 15 | Front Yard : Yard | Tree | Private 2 | 20 | 6007579.05475 | 2119893.16835 | 37.8012502787406 | -122.417928048762 | (37.8012502787406, -122.417928048762) | 5 | 1 | 1 | 28858 | 32 | ||||
| 89099 | 120280 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 129 24th Ave | 10 | Front Yard : Yard | Tree | Private 2 | 15 | 5988322.23801 | 2115131.91384 | 37.7870746664109 | -122.484214895682 | (37.7870746664109, -122.484214895682) | 11 | 6 | 1 | 55 | 33 | ||||
| 101348 | 120278 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 129 24th Ave | 8 | Front Yard : Yard | Tree | Private 2 | 14 | 5988337.84774 | 2115148.37916 | 37.7871207843354 | -122.484162098088 | (37.7871207843354, -122.484162098088) | 11 | 6 | 1 | 55 | 33 | ||||
| 102757 | 120263 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 24th Ave | 5 | Side Yard : Yard | Tree | Private 2 | 8 | 5988364.34066 | 2115176.21089 | 37.7871987447814 | -122.484072481257 | (37.7871987447814, -122.484072481257) | 11 | 6 | 1 | 55 | 33 | ||||
| 111707 | 2580 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1668 Bush St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6005450.60125 | 2115176.64636 | 37.7881798837348 | -122.424957678647 | (37.7881798837348, -122.424957678647) | 13 | 9 | 1 | 28858 | 41 | |||
| 127099 | 120274 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 129 24th Ave | 4 | Front Yard : Yard | Tree | Private 2 | 9 | 5988307.12698 | 2115148.43075 | 37.7871191372985 | -122.484268387654 | (37.7871191372985, -122.484268387654) | 11 | 6 | 1 | 55 | 33 | ||||
| 140694 | 120279 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 129 24th Ave | 9 | Front Yard : Yard | Tree | Private 2 | 14 | 5988331.03377 | 2115139.52576 | 37.7870960786942 | -122.484185023117 | (37.7870960786942, -122.484185023117) | 11 | 6 | 1 | 55 | 33 | ||||
| 140982 | 136433 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2671 Leavenworth St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 32 | 6007318.56693 | 2121838.23641 | 37.8065762788357 | -122.418967487863 | (37.8065762788357, -122.418967487863) | 5 | 1 | 1 | 28858 | 32 | ||||
| 142590 | 120277 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 129 24th Ave | 7 | Front Yard : Yard | Tree | Private 2 | 3 | 5988335.64695 | 2115158.22344 | 37.7871476857857 | -122.484170434457 | (37.7871476857857, -122.484170434457) | 11 | 6 | 1 | 55 | 33 | ||||
| 148270 | 120271 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 129 24th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 16 | 5988306.39603 | 2115180.23903 | 37.7872064312039 | -122.48427325024 | (37.7872064312039, -122.48427325024) | 11 | 6 | 1 | 55 | 33 | ||||
| 149436 | 122587 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 2500X Lyon St | 7 | Median : Cutout | Tree | Private 2 | 45 | 10x20 | 5999276 | 2117538 | 37.7943128273924 | -122.446490617691 | (37.7943128273924, -122.446490617691) | 13 | 9 | 1 | 57 | 27 | |||
| 167150 | 136429 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1101 Greenwich St | 11 | Front Yard : Yard | Tree | Private 2 | 14 | 6007562.30318 | 2119880.18015 | 37.801213673635 | -122.417985095433 | (37.801213673635, -122.417985095433) | 5 | 1 | 1 | 28858 | 32 | ||||
| 170932 | 102752 | Property Tree 8 | Sequoia sempervirens :: Coast Redwood 155 | 2452 Green St | Back Yard : Yard | Tree | Private 2 | 6001313 | 2117994 | 37.7956810212331 | -122.43947508164 | (37.7956810212331, -122.43947508164) | 13 | 9 | 1 | 57 | 17 | ||||||
| 190820 | 53580 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 148 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1973 12:00:00 AM | 34 | Permit Number 12426 | 5993993.68572 | 2114568.59854 | 37.7858565385613 | -122.464552179077 | (37.7858565385613, -122.464552179077) | 11 | 6 | 1 | 54 | 11 | ||
| 22478 | 249959 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 273 Filbert St | 1 | Front Yard : Yard | Tree | Private 2 | 23 | Width 0ft | 6011558.55656 | 2120064.53903 | 37.8019439797819 | -122.404169218243 | (37.8019439797819, -122.404169218243) | 3 | 1 | 10 | 308 | 23 | |||
| 34175 | 87149 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 4 Bellair Pl | 2 | Back Yard : Yard | Tree | Private 2 | 6010093 | 2120950 | 37.8042932388788 | -122.409303278994 | (37.8042932388788, -122.409303278994) | 3 | 1 | 10 | 308 | 23 | |||||
| 55580 | 136442 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3 Broadway | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6013378.37764 | 2118933.3014 | 37.7989393870992 | -122.397792341438 | (37.7989393870992, -122.397792341438) | 3 | 1 | 10 | 28860 | 6 | ||||
| 57200 | 136428 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 7 Kimball Pl | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 0ft | 6007991.83691 | 2116437.43612 | 37.791784918695 | -122.416254742289 | (37.791784918695, -122.416254742289) | 5 | 1 | 10 | 28858 | 21 | |||
| 62568 | 136431 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 13 MacOndray Ln | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | 6008632.90068 | 2119166.62302 | 37.799314619318 | -122.414229834152 | (37.799314619318, -122.414229834152) | 5 | 1 | 10 | 308 | 32 | ||||
| 63647 | 136440 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3 Broadway | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | 6013367.06255 | 2118933.37204 | 37.7989389509345 | -122.397831500623 | (37.7989389509345, -122.397831500623) | 3 | 1 | 10 | 28860 | 6 | ||||
| 65969 | 87150 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 4 Bellair Pl | 2 | Back Yard : Yard | Tree | Private 2 | Permit Number 50135 | 6010093 | 2120950 | 37.8042932388788 | -122.409303278994 | (37.8042932388788, -122.409303278994) | 3 | 1 | 10 | 308 | 23 | ||||
| 72665 | 136438 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3 Broadway | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6013355.98644 | 2118932.37336 | 37.798935591968 | -122.397869757803 | (37.798935591968, -122.397869757803) | 3 | 1 | 10 | 28860 | 6 | ||||
| 80811 | 136443 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3 Broadway | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6013384.0493 | 2118922.93531 | 37.7989112401317 | -122.397771987982 | (37.7989112401317, -122.397771987982) | 3 | 1 | 10 | 28860 | 6 | ||||
| 126433 | 136435 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3 Broadway | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6013344.90953 | 2118921.0971 | 37.7989040131614 | -122.397907296408 | (37.7989040131614, -122.397907296408) | 3 | 1 | 10 | 28860 | 6 | ||||
| 126966 | 136434 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 12 Greenwich St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 6012298.4076 | 2120549.33954 | 37.8033164360554 | -122.401643063984 | (37.8033164360554, -122.401643063984) | 3 | 1 | 10 | 28860 | 6 | ||||
| 132983 | 136445 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3 Broadway | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | 6013392.00591 | 2118921.55061 | 37.7989078811583 | -122.397744358119 | (37.7989078811583, -122.397744358119) | 3 | 1 | 10 | 28860 | 6 | ||||
| 135411 | 250201 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 203 Union St | 2 | Side Yard : Yard | Tree | Private 2 | 29 | Width 0ft | 6011763.02504 | 2119743.52194 | 37.8010739675505 | -122.403439059581 | (37.8010739675505, -122.403439059581) | 3 | 1 | 10 | 308 | 23 | |||
| 136125 | 136437 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3 Broadway | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | 6013352.957 | 2118919.28443 | 37.7988994841762 | -122.397879322098 | (37.7988994841762, -122.397879322098) | 3 | 1 | 10 | 28860 | 6 | ||||
| 138407 | 136436 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3 Broadway | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6013350.43599 | 2118931.26261 | 37.7989322330038 | -122.397888886371 | (37.7989322330038, -122.397888886371) | 3 | 1 | 10 | 28860 | 6 | ||||
| 142994 | 112559 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 1735x GRANT AVE | 1 | Back Yard : Yard | Tree | Private 2 | 6010373 | 2120454 | 37.8029470287696 | -122.408299306743 | (37.8029470287696, -122.408299306743) | 3 | 1 | 10 | 308 | 23 | |||||
| 148030 | 136432 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 13 MacOndray Ln | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6008638.14667 | 2119166.05389 | 37.7993133512976 | -122.414211640849 | (37.7993133512976, -122.414211640849) | 5 | 1 | 10 | 308 | 32 | ||||
| 154245 | 136439 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3 Broadway | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6013363.76971 | 2118922.4292 | 37.7989087211284 | -122.397842127014 | (37.7989087211284, -122.397842127014) | 3 | 1 | 10 | 28860 | 6 | ||||
| 157512 | 250200 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 203 Union St | 1 | Side Yard : Yard | Tree | Private 2 | 33 | Width 0ft | 6011776.4013 | 2119745.07747 | 37.8010789857668 | -122.403392881194 | (37.8010789857668, -122.403392881194) | 3 | 1 | 10 | 308 | 23 | |||
| 175737 | 136441 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3 Broadway | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6013371.77292 | 2118938.4754 | 37.798953225861 | -122.397815559237 | (37.798953225861, -122.397815559237) | 3 | 1 | 10 | 28860 | 6 | ||||
| 177141 | 136444 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3 Broadway | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | 6013387.59339 | 2118931.12048 | 37.7989339120187 | -122.397760298614 | (37.7989339120187, -122.397760298614) | 3 | 1 | 10 | 28860 | 6 | ||||
| 22018 | 106361 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 1645 WEBSTER ST | 2 | Front Yard : Yard | Tree | Private 2 | 30 | 6003301.2 | 2114333.7 | 37.7857437219688 | -122.432334009178 | (37.7857437219688, -122.432334009178) | 13 | 9 | 11 | 29490 | 13 | ||||
| 82071 | 106360 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 1820 POST ST | 1 | Front Yard : Yard | Tree | Private 2 | 30 | 6003351.1 | 2114201.6 | 37.785383838011 | -122.432151932321 | (37.785383838011, -122.432151932321) | 13 | 9 | 11 | 29490 | 13 | ||||
| 82381 | 98597 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 400X Steiner St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | Permit Number 768529 | 6004639 | 2109849 | 37.7735056071657 | -122.427386005439 | (37.7735056071657, -122.427386005439) | 7 | 9 | 11 | 28852 | 10 | ||||
| 85142 | 255249 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 209x Willow St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6006475 | 2113325 | 37.7831535286214 | -122.421281886667 | (37.7831535286214, -122.421281886667) | 7 | 9 | 11 | 28858 | 41 | ||||
| 109809 | 106362 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 1645 WEBSTER ST | 1 | Front Yard : Yard | Tree | Private 2 | 12 | 6003301.2 | 2114333.7 | 37.7857437219688 | -122.432334009178 | (37.7857437219688, -122.432334009178) | 13 | 9 | 11 | 29490 | 13 | ||||
| 119143 | 113163 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 1300X STANYAN ST | 2 | Front Yard : Yard | Tree | Private 2 | 40 | 3x3 | 5997565 | 2104877 | 37.7594511396077 | -122.451497194349 | (37.7594511396077, -122.451497194349) | 15 | 5 | 11 | 28862 | 12 | |||
| 145840 | 113162 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 1300X STANYAN ST | 1 | Front Yard : Yard | Tree | Private 2 | 40 | 3x3 | 5997565 | 2104877 | 37.7594511396077 | -122.451497194349 | (37.7594511396077, -122.451497194349) | 15 | 5 | 11 | 28862 | 12 | |||
| 22789 | 118610 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 349 Point Lobos Ave | 2 | Side Yard : Yard | Tree | Private 2 | 5 | 5981717.62769 | 2112632.61479 | 37.7798255733952 | -122.506879529548 | (37.7798255733952, -122.506879529548) | 11 | 6 | 2 | 55 | 26 | ||||
| 26627 | 24794 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 7633 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 5983299.41691 | 2112375.19824 | 37.7792118059508 | -122.50138846509 | (37.7792118059508, -122.50138846509) | 11 | 6 | 2 | 55 | 26 | |||
| 29828 | 118443 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 5201 Anza St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5982458.0361 | 2111659.95745 | 37.7771985159381 | -122.504246101222 | (37.7771985159381, -122.504246101222) | 11 | 6 | 2 | 55 | 26 | |||
| 62301 | 118611 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 349 Point Lobos Ave | 3 | Side Yard : Yard | Tree | Private 2 | 6 | 5981718.68572 | 2112644.15815 | 37.7798573303546 | -122.506876725888 | (37.7798573303546, -122.506876725888) | 11 | 6 | 2 | 55 | 26 | ||||
| 85509 | 119951 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 300 28th Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 30 | Width 3ft | 5987162.07649 | 2113890.44215 | 37.783598323431 | -122.488137483705 | (37.783598323431, -122.488137483705) | 11 | 6 | 2 | 55 | 26 | |||
| 148985 | 120239 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 288 24th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5988397.09206 | 2114077.36637 | 37.7841835367937 | -122.483878566436 | (37.7841835367937, -122.483878566436) | 11 | 6 | 2 | 55 | 26 | |||
| 185931 | 118442 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 5201 Anza St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 5982468.47607 | 2111659.73383 | 37.7771985159318 | -122.504209970081 | (37.7771985159318, -122.504209970081) | 11 | 6 | 2 | 55 | 26 | |||
| 5806 | 186727 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1300 Sunset Blvd | 61 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984865.5297 | 2106265.0899 | 37.7625270363386 | -122.49551994066 | (37.7625270363386, -122.49551994066) | 1 | 8 | 3 | 56 | 35 | |||
| 5904 | 181484 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1400 Sunset Blvd | 44 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984898.4123 | 2105356.9862 | 37.7600355628364 | -122.495339238882 | (37.7600355628364, -122.495339238882) | 1 | 8 | 3 | 56 | 35 | |||
| 6540 | 181386 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1500 Sunset Blvd | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984899.2058 | 2104514.6528 | 37.7577227962381 | -122.495274374844 | (37.7577227962381, -122.495274374844) | 1 | 8 | 3 | 56 | 35 | |||
| 8497 | 186967 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2800 Sunset Blvd | 41 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985210.5401 | 2096146.418 | 37.7347641193316 | -122.493581077021 | (37.7347641193316, -122.493581077021) | 1 | 8 | 3 | 29491 | 35 | |||
| 10552 | 185214 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2500 Sunset Blvd | 70 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985123.3973 | 2098105.6751 | 37.7401386169566 | -122.494026705548 | (37.7401386169566, -122.494026705548) | 1 | 8 | 3 | 29491 | 35 | |||
| 24751 | 185875 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2000 Sunset Blvd | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985024.3241 | 2101081.1994 | 37.7483028028797 | -122.494588557862 | (37.7483028028797, -122.494588557862) | 1 | 8 | 3 | 29491 | 35 | |||
| 26601 | 258075 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 1300X Wawona St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | 5988924 | 2097013 | 37.7373600650942 | -122.480805942066 | (37.7373600650942, -122.480805942066) | 1 | 8 | 3 | 29491 | 35 | ||||
| 29707 | 185566 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2201 Sunset Blvd | 50 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984882.0949 | 2099749.7079 | 37.744638564328 | -122.494982211469 | (37.744638564328, -122.494982211469) | 1 | 8 | 3 | 29491 | 35 | |||
| 30089 | 187307 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2401 Sunset Blvd | 90 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984946.0227 | 2098230.3328 | 37.7404705132188 | -122.494649173616 | (37.7404705132188, -122.494649173616) | 1 | 8 | 3 | 29491 | 35 | |||
| 30831 | 186891 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2700 Sunset Blvd | 40 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985178.2577 | 2096509.7223 | 37.7357597676042 | -122.493719449451 | (37.7357597676042, -122.493719449451) | 1 | 8 | 3 | 29491 | 35 | |||
| 31619 | 181387 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1500 Sunset Blvd | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984939.8638 | 2104520.2223 | 37.7577404689343 | -122.495134175513 | (37.7577404689343, -122.495134175513) | 1 | 8 | 3 | 56 | 35 | |||
| 31897 | 187392 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2100 Sunset Blvd | 45 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985024.2566 | 2100630.9061 | 37.7470664162932 | -122.494555600597 | (37.7470664162932, -122.494555600597) | 1 | 8 | 3 | 29491 | 35 | |||
| 33270 | 187127 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2600 Sunset Blvd | 63 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985167.6891 | 2097369.3231 | 37.7381193834059 | -122.493819314943 | (37.7381193834059, -122.493819314943) | 1 | 8 | 3 | 29491 | 35 | |||
| 33753 | 186376 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1801 Sunset Blvd | 43 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984798.5659 | 2102512.3907 | 37.7522192455734 | -122.495474752392 | (37.7522192455734, -122.495474752392) | 1 | 8 | 3 | 56 | 35 | |||
| 35596 | 254587 | Property Tree 8 | Sequoia sempervirens :: Coast Redwood 155 | 1270 24th Ave | 1 | Back Yard : Cutout | Tree | Private 2 | 3x3 | 5988678 | 2106679 | 37.7638860263594 | -122.482364481098 | (37.7638860263594, -122.482364481098) | 1 | 8 | 3 | 56 | 35 | ||||
| 40752 | 186924 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2700 Sunset Blvd | 73 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985155.3367 | 2096781.1077 | 37.7365035785089 | -122.493818687918 | (37.7365035785089, -122.493818687918) | 1 | 8 | 3 | 29491 | 35 | |||
| 41329 | 181391 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1500 Sunset Blvd | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984921.4841 | 2104558.6525 | 37.757844911537 | -122.495200573085 | (37.757844911537, -122.495200573085) | 1 | 8 | 3 | 56 | 35 | |||
| 44152 | 185095 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2801 Sunset Blvd | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985029.9671 | 2095999.845 | 37.7343511038502 | -122.494194570965 | (37.7343511038502, -122.494194570965) | 1 | 8 | 3 | 29491 | 35 | |||
| 45627 | 185725 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2101 Sunset Blvd | 57 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984855.2039 | 2100321.3236 | 37.7462064913622 | -122.495117336885 | (37.7462064913622, -122.495117336885) | 1 | 8 | 3 | 29491 | 35 | |||
| 47009 | 185730 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2101 Sunset Blvd | 62 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984911.7584 | 2100300.7286 | 37.7461532538825 | -122.494920263061 | (37.7461532538825, -122.494920263061) | 1 | 8 | 3 | 29491 | 35 | |||
| 48099 | 181395 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1500 Sunset Blvd | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984933.1803 | 2104579.26 | 37.7579021787746 | -122.495161642957 | (37.7579021787746, -122.495161642957) | 1 | 8 | 3 | 56 | 35 | |||
| 49510 | 186481 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1601 Sunset Blvd | 69 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984737.1745 | 2103681.0182 | 37.7554243789331 | -122.495773245735 | (37.7554243789331, -122.495773245735) | 1 | 8 | 3 | 56 | 35 | |||
| 51649 | 181435 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1500 Sunset Blvd | 68 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984924.5894 | 2104933.1403 | 37.7588733327201 | -122.495217449651 | (37.7588733327201, -122.495217449651) | 1 | 8 | 3 | 56 | 35 | |||
| 52720 | 181542 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1300 Sunset Blvd | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984868.615 | 2105905.3126 | 37.7615393692586 | -122.495482733656 | (37.7615393692586, -122.495482733656) | 1 | 8 | 3 | 56 | 35 | |||
| 53710 | 185092 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2801 Sunset Blvd | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985016.1492 | 2096009.4757 | 37.7343767385902 | -122.494243052853 | (37.7343767385902, -122.494243052853) | 1 | 8 | 3 | 29491 | 35 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );