trees
349 rows where qSpecies_id = 155
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
55834 | 121404 | Property Tree 8 | Sequoia sempervirens :: Coast Redwood 155 | 1900 08th Ave | 1 | Back Yard : Yard | Tree | Private 2 | 3 | 10x10 | 5993817 | 2102486 | 37.7526707300666 | -122.464285931649 | (37.7526707300666, -122.464285931649) | 1 | 8 | 4 | 29491 | 40 | |||
56286 | 112919 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | ||||
56534 | 185567 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2201 Sunset Blvd | 51 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984881.8296 | 2099726.3595 | 37.7445744404291 | -122.49498140754 | (37.7445744404291, -122.49498140754) | 1 | 8 | 3 | 29491 | 35 | |||
57141 | 185213 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2500 Sunset Blvd | 68 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985153.279 | 2098105.011 | 37.740138541922 | -122.493923339348 | (37.740138541922, -122.493923339348) | 1 | 8 | 3 | 29491 | 35 | |||
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 | |||
57451 | 240608 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3932 22nd St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 11 | Width 4ft | 6002275.44669 | 2102986.99037 | 37.7545302429786 | -122.435070995746 | (37.7545302429786, -122.435070995746) | 2 | 4 | 5 | 28862 | 22 | |||
58049 | 39822 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2190 46th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1999 12:00:00 AM | 1 | Permit Number 41149 | 5982045.5543 | 2100206.3838 | 37.7457260090551 | -122.504824075497 | (37.7457260090551, -122.504824075497) | 1 | 8 | 3 | 29491 | 35 | |
58080 | 186092 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1901 Sunset Blvd | 38 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984860.3007 | 2101794.0493 | 37.7502504920958 | -122.495208298659 | (37.7502504920958, -122.495208298659) | 1 | 8 | 3 | 29491 | 35 | |||
58260 | 240620 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 272 Corbett Ave | 3 | Side Yard : Yard | Tree | Private 2 | 21 | Width 3ft | 5999634.90147 | 2105345.61253 | 37.7608561480145 | -122.444372157544 | (37.7608561480145, -122.444372157544) | 15 | 5 | 5 | 28862 | 3 | |||
58774 | 102106 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 50X Noe St | 8 | Front Yard : Yard | Tree | Private 2 | 12/19/2012 12:00:00 AM | 25 | Permit Number 769282 | 6002816.1 | 2107996.5 | 37.7683158318555 | -122.433559261751 | (37.7683158318555, -122.433559261751) | 15 | 5 | 5 | 28862 | 3 | ||
60359 | 181539 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1300 Sunset Blvd | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984878.0833 | 2105873.5659 | 37.7614527561104 | -122.4954476457 | (37.7614527561104, -122.4954476457) | 1 | 8 | 3 | 56 | 35 | |||
61269 | 240609 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3944 22nd St | 5 | Front Yard : Yard | Tree | Private 2 | 8 | 6002189.65903 | 2102971.08087 | 37.7544816876836 | -122.435366533665 | (37.7544816876836, -122.435366533665) | 2 | 4 | 5 | 28862 | 22 | ||||
62055 | 186033 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1900 Sunset Blvd | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985025.9241 | 2102045.6103 | 37.7509509050251 | -122.494654114474 | (37.7509509050251, -122.494654114474) | 1 | 8 | 3 | 29491 | 35 | |||
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 | ||||
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 | ||||
62904 | 187562 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 136 Alpha St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6010924.81275 | 2088138.49847 | 37.7142467657541 | -122.404114113194 | (37.7142467657541, -122.404114113194) | 9 | 7 | 8 | 309 | 39 | |||
62934 | 370 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 3711X 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | 1 | 8 | 4 | 64 | 14 | |
63157 | 116234 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 450 PERALTA AVE | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6009750 | 2099218 | 37.744603019334 | -122.408955999129 | (37.744603019334, -122.408955999129) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | ||||
64503 | 240618 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 69 Levant St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 27 | Width 3ft | 6000370.53628 | 2106394.53349 | 37.7637781703576 | -122.441903216369 | (37.7637781703576, -122.441903216369) | 15 | 5 | 5 | 28862 | 3 | |||
64643 | 197582 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 851 Indiana St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 31 | Width 10ft | 6014984.28202 | 2104444.32589 | 37.7592452203005 | -122.391221997114 | (37.7592452203005, -122.391221997114) | 10 | 3 | 8 | 28856 | 29 | |||
65651 | 112922 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | ||||
65736 | 181548 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1300 Sunset Blvd | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984846.3366 | 2105995.5399 | 37.761785803641 | -122.495566439468 | (37.761785803641, -122.495566439468) | 1 | 8 | 3 | 56 | 35 | |||
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 | ||||
66311 | 247908 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 582 Esmeralda Ave | 6 | Side Yard : Yard | Tree | Private 2 | 12 | 6009856.31482 | 2098721.18962 | 37.7432448412741 | -122.408553343056 | (37.7432448412741, -122.408553343056) | 10 | 7 | 7 | 28859 | 2 | ||||
66374 | 248054 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 19 Rutledge St | 3 | Front Yard : Yard | Tree | Private 2 | 10 | 6010623.78947 | 2099366.66931 | 37.7450601408245 | -122.405945064536 | (37.7450601408245, -122.405945064536) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | ||||
67057 | 240631 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 57 Poppy Ln | 1 | Back Yard : Yard | Tree | Private 2 | 4 | Width 2ft | 6002629.35658 | 2096548.63014 | 37.7368721031581 | -122.433387031387 | (37.7368721031581, -122.433387031387) | 2 | 7 | 5 | 63 | 7 | |||
67367 | 185877 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2000 Sunset Blvd | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985055.2583 | 2101098.876 | 37.7483531484939 | -122.494482892668 | (37.7483531484939, -122.494482892668) | 1 | 8 | 3 | 29491 | 35 | |||
67645 | 186087 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1901 Sunset Blvd | 33 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984862.8194 | 2101833.0892 | 37.7503578324165 | -122.495202467563 | (37.7503578324165, -122.495202467563) | 1 | 8 | 3 | 29491 | 35 | |||
68133 | 184745 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1301 Sunset Blvd | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984671.0844 | 2106181.5705 | 37.7622863276384 | -122.496186283596 | (37.7622863276384, -122.496186283596) | 1 | 8 | 3 | 56 | 35 | |||
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 | ||||
68935 | 184091 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1600 Sunset Blvd | 94 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984954.5787 | 2104192.9608 | 37.7568427611219 | -122.495059154794 | (37.7568427611219, -122.495059154794) | 1 | 8 | 3 | 56 | 35 | |||
69156 | 117179 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 350x Winding Way | 1 | Median : Cutout | Tree | DPW 1 | 30 | 3x3 | 6001167.67306 | 2086580.24641 | 37.7094181465037 | -122.437726988707 | (37.7094181465037, -122.437726988707) | 9 | 7 | 6 | 28861 | 5 | |||
70534 | 104510 | Private 9 | Sequoia sempervirens :: Coast Redwood 155 | 254 ALLISON ST | 1 | Back Yard : Yard | Tree | Private 2 | 40 | 6000052 | 2087408 | 37.7116274717654 | -122.441642291463 | (37.7116274717654, -122.441642291463) | 9 | 7 | 6 | 28861 | 5 | ||||
70709 | 185874 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2000 Sunset Blvd | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985052.1017 | 2101064.154 | 37.7482576266138 | -122.494491248711 | (37.7482576266138, -122.494491248711) | 1 | 8 | 3 | 29491 | 35 | |||
70761 | 186730 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1300 Sunset Blvd | 65 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984855.0036 | 2106288.7736 | 37.7625914487693 | -122.495558092973 | (37.7625914487693, -122.495558092973) | 1 | 8 | 3 | 56 | 35 | |||
71263 | 184997 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2701 Sunset Blvd | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985027.6641 | 2096515.5033 | 37.7357668292904 | -122.494240528594 | (37.7357668292904, -122.494240528594) | 1 | 8 | 3 | 29491 | 35 | |||
71693 | 88838 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 3711 19th Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2008 12:00:00 AM | 3x3 | Permit Number 51718 | 5990297.3 | 2090806 | 37.7203969366505 | -122.475604756889 | (37.7203969366505, -122.475604756889) | 1 | 8 | 4 | 64 | 14 | ||
71870 | 240617 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 685 Sanchez St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 5ft | 6003712.72581 | 2104261.51662 | 37.7581112975082 | -122.430191428091 | (37.7581112975082, -122.430191428091) | 2 | 4 | 5 | 28862 | 3 | |||
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 | ||||
72583 | 111269 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 700X BOSWORTH ST | 7 | Front Yard : Yard | Tree | DPW 1 | 3 | 6002150 | 2095428 | 37.7337679036822 | -122.434964255854 | (37.7337679036822, -122.434964255854) | 2 | 7 | 5 | 63 | 7 | ||||
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 | ||||
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 | ||||
74061 | 248065 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 18 Rutledge St | 7 | Side Yard : Yard | Tree | Private 2 | 8 | 6010648.08166 | 2099392.59133 | 37.7451326756473 | -122.405862891685 | (37.7451326756473, -122.405862891685) | 2 | 7 | 7 | 28859 | 2 | ||||
74096 | 112921 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | ||||
74838 | 186679 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1401 Sunset Blvd | 36 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984735.2903 | 2105403.229 | 37.760152980386 | -122.495906802394 | (37.760152980386, -122.495906802394) | 1 | 8 | 3 | 56 | 35 | |||
75463 | 3774 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1098 Carolina St | 7 | Median : Cutout | Tree | DPW 1 | 12 | 18 | 6012462.6103665 | 2102859.9036449 | 37.754754478768 | -122.399831953417 | (37.754754478768, -122.399831953417) | 10 | 3 | 8 | 28856 | 29 | |||
75904 | 187361 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2200 Sunset Blvd | 46 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985088.1562 | 2099814.8531 | 37.7448294961486 | -122.494274503401 | (37.7448294961486, -122.494274503401) | 1 | 8 | 3 | 29491 | 35 | |||
76123 | 240596 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1300 San Jose Ave | 8 | Front Yard : Yard | Tree | Private 2 | 20 | 6003644.77453 | 2095717.83373 | 37.7346484808287 | -122.429817043043 | (37.7346484808287, -122.429817043043) | 2 | 7 | 5 | 63 | 7 | ||||
76481 | 94535 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 265 Dorland St | 1 | Back Yard : Yard | Tree | Private 2 | 6003831 | 2105693 | 37.7620485075454 | -122.429884491233 | (37.7620485075454, -122.429884491233) | 8 | 4 | 5 | 28862 | 3 | |||||
77920 | 215022 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 Terrace Dr | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 5993608.12799 | 2096720.10438 | 37.7368269967784 | -122.464589603347 | (37.7368269967784, -122.464589603347) | 1 | 8 | 4 | 59 | 40 | ||||
78542 | 375 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 3711X 19th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | 1 | 8 | 4 | 64 | 14 | |
78989 | 186922 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2700 Sunset Blvd | 71 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985180.0914 | 2096773.3145 | 37.7364836287386 | -122.493732527554 | (37.7364836287386, -122.493732527554) | 1 | 8 | 3 | 29491 | 35 | |||
80763 | 248068 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 20 Rutledge St | 2 | Side Yard : Yard | Tree | Private 2 | 6 | 6010623.83336 | 2099392.33092 | 37.7451306044855 | -122.405946720167 | (37.7451306044855, -122.405946720167) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | ||||
82049 | 116660 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 199x Esmeralda Ave | 13 | Unaccepted Street : Yard | Tree | DPW 1 | 8 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | ||||
84644 | 118371 | Property Tree 8 | Sequoia sempervirens :: Coast Redwood 155 | 4808 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999981 | 2101110 | 37.7492459313263 | -122.442870994168 | (37.7492459313263, -122.442870994168) | 2 | 4 | 5 | 28862 | 22 | ||||
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 | ||||
85358 | 246442 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 485 Duncan St | 4 | Front Yard : Yard | Tree | Private 2 | 40 | 6003379.46073 | 2099778.50621 | 37.7457831256083 | -122.431024044746 | (37.7457831256083, -122.431024044746) | 2 | 7 | 5 | 63 | 22 | ||||
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 | |||
85632 | 112804 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 219 UPPER TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3x3 | 5999620 | 2106355 | 37.7636268249183 | -122.444496241129 | (37.7636268249183, -122.444496241129) | 15 | 5 | 5 | 29492 | 3 | |||
85976 | 186968 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2800 Sunset Blvd | 42 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985205.8316 | 2096154.4897 | 37.7347860066264 | -122.49359795025 | (37.7347860066264, -122.49359795025) | 1 | 8 | 3 | 29491 | 35 | |||
87089 | 215025 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 Terrace Dr | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 5993646.76934 | 2096691.56193 | 37.7367508538673 | -122.464453932502 | (37.7367508538673, -122.464453932502) | 1 | 8 | 4 | 59 | 40 | ||||
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 | ||||
90791 | 376 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 3711X 19th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | 1 | 8 | 4 | 64 | 14 | |
91101 | 187295 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2401 Sunset Blvd | 78 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984937.4924 | 2098259.4132 | 37.7405498608751 | -122.49468081102 | (37.7405498608751, -122.49468081102) | 1 | 8 | 3 | 29491 | 35 | |||
91810 | 247598 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 900 Tompkins Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 10ft | 6009167.82306 | 2096407.90626 | 37.7368544863348 | -122.410770639572 | (37.7368544863348, -122.410770639572) | 10 | 7 | 7 | 28859 | 2 | |||
92132 | 186472 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1601 Sunset Blvd | 60 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984790.3524 | 2103740.0582 | 37.7555896005647 | -122.495593697553 | (37.7555896005647, -122.495593697553) | 1 | 8 | 3 | 56 | 35 | |||
92231 | 240614 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 3637 22nd St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003933.58317 | 2103025.57629 | 37.7547302045579 | -122.429339475147 | (37.7547302045579, -122.429339475147) | 2 | 4 | 5 | 28862 | 22 | |||
92802 | 256419 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 3001 Sunset Blvd | 7 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
93217 | 185721 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2101 Sunset Blvd | 53 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984915.0274 | 2100334.3998 | 37.7462458971959 | -122.494911441682 | (37.7462458971959, -122.494911441682) | 1 | 8 | 3 | 29491 | 35 | |||
94058 | 215043 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 798 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 5996915.73734 | 2095029.56264 | 37.732375301382 | -122.453031809567 | (37.732375301382, -122.453031809567) | 9 | 7 | 4 | 59 | 40 | ||||
94069 | 185734 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2101 Sunset Blvd | 66 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984861.0881 | 2100291.2484 | 37.7461242575362 | -122.495094773004 | (37.7461242575362, -122.495094773004) | 1 | 8 | 3 | 29491 | 35 | |||
95121 | 187305 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2401 Sunset Blvd | 88 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984977.8173 | 2098236.5366 | 37.7404894080916 | -122.49453969916 | (37.7404894080916, -122.49453969916) | 1 | 8 | 3 | 29491 | 35 | |||
95966 | 185218 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2500 Sunset Blvd | 75 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985145.9746 | 2098136.8849 | 37.7402256317054 | -122.493950943051 | (37.7402256317054, -122.493950943051) | 1 | 8 | 3 | 29491 | 35 | |||
97217 | 122496 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 69x Bonview St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007716 | 2099172 | 37.7443625662885 | -122.415985930063 | (37.7443625662885, -122.415985930063) | 2 | 7 | 7 | 28859 | 2 | ||||
98282 | 246713 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1 Bonview St | 19 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 6007763.89494 | 2099225.75212 | 37.7445128502976 | -122.415824124379 | (37.7445128502976, -122.415824124379) | 2 | 7 | 7 | 28859 | 2 | ||||
99868 | 248066 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 18 Rutledge St | 8 | Side Yard : Yard | Tree | Private 2 | 7 | 6010646.65948 | 2099397.14706 | 37.7451451051559 | -122.405868130216 | (37.7451451051559, -122.405868130216) | 2 | 7 | 7 | 28859 | 2 | ||||
101231 | 52819 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1327@ JUDAH 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Permit Number 48844 | 5987385.2929 | 2106232.8495 | 37.7625857382219 | -122.486802743324 | (37.7625857382219, -122.486802743324) | 1 | 8 | 3 | 56 | 35 | |||
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 | ||||
101955 | 256418 | Undocumented 4 | Sequoia sempervirens :: Coast Redwood 155 | 3001 Sunset Blvd | 6 | Median : Yard | Tree | Private 2 | 10x10 | 5984960 | 2094729 | 37.7308576064943 | -122.49434282122 | (37.7308576064943, -122.49434282122) | 1 | 8 | 4 | 64 | 35 | ||||
102378 | 197585 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 900x Carolina St | 75 | Median : Yard | Tree | DPW 1 | 27 | 6012517.30691 | 2102783.51804 | 37.7545477896502 | -122.399637433715 | (37.7545477896502, -122.399637433715) | 10 | 3 | 8 | 28856 | 29 | ||||
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 | ||||
103106 | 187124 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2600 Sunset Blvd | 60 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985135.2439 | 2097353.8058 | 37.7380748787519 | -122.493930349328 | (37.7380748787519, -122.493930349328) | 1 | 8 | 3 | 29491 | 35 | |||
104626 | 253389 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 30X Grand View Ave | 2 | Side Yard : Yard | Tree | Private 2 | 3x3 | 6000475 | 2103841 | 37.7567727470696 | -122.441358672007 | (37.7567727470696, -122.441358672007) | 2 | 4 | 5 | 28862 | 38 | ||||
104772 | 373 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 3711X 19th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | 1 | 8 | 4 | 64 | 14 | |
105506 | 187380 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2200 Sunset Blvd | 66 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985069.8747 | 2100065.0386 | 37.7455153678045 | -122.494356154683 | (37.7455153678045, -122.494356154683) | 1 | 8 | 3 | 29491 | 35 | |||
105817 | 187306 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 2401 Sunset Blvd | 89 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984963.8587 | 2098228.7818 | 37.7404672985278 | -122.494587390296 | (37.7404672985278, -122.494587390296) | 1 | 8 | 3 | 29491 | 35 | |||
105934 | 99256 | Property Tree 8 | Sequoia sempervirens :: Coast Redwood 155 | 1466 York St | Back Yard : Yard | Tree | Private 2 | 6010099 | 2100741 | 37.7488043872035 | -122.407856595429 | (37.7488043872035, -122.407856595429) | 2 | 4 | 7 | 28859 | 19 | ||||||
106335 | 184804 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1301 Sunset Blvd | 65 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984679.0585 | 2105723.8188 | 37.7610299368102 | -122.496124931271 | (37.7610299368102, -122.496124931271) | 1 | 8 | 3 | 56 | 35 | |||
106367 | 197586 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 1 Jack Balestreri Way | 1 | Front Yard : Yard | Tree | Private 2 | 45 | Width 10ft | 6012374.62872 | 2104733.59825 | 37.7598943275787 | -122.400267811735 | (37.7598943275787, -122.400267811735) | 10 | 3 | 8 | 28856 | 29 | |||
106523 | 112930 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 2X Noe St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/27/2015 12:00:00 AM | 3x3 | Permit Number 775129 | 6002836.07968 | 2107997.59158 | 37.7683199626551 | -122.433490232023 | (37.7683199626551, -122.433490232023) | 15 | 5 | 5 | 28862 | 3 | |||
107662 | 381 | Permitted Site 7 | Sequoia sempervirens :: Coast Redwood 155 | 3711X 19th Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2008 12:00:00 AM | 16 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | 1 | 8 | 4 | 64 | 14 | |
108685 | 215027 | DPW Maintained 1 | Sequoia sempervirens :: Coast Redwood 155 | 100 Terrace Dr | 22 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 5993761.26762 | 2096568.14898 | 37.7364185921533 | -122.464049108976 | (37.7364185921533, -122.464049108976) | 1 | 8 | 4 | 59 | 40 | ||||
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 | ||||
110581 | 113359 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 702 Foerster St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5998153.40008835 | 2095558.62470631 | 37.7338988325043 | -122.448791034412 | (37.7338988325043, -122.448791034412) | 9 | 7 | 4 | 59 | 40 |
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) );