349 rows where qSpecies_id = 155

View and edit SQL

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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);