Street_Tree_List

Data source: data.sfgov.org

331 rows where qSpecies = 116 sorted by Longitude

✎ View and edit SQL

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
838 838 19815 DPW Maintained 3 Sequoia sempervirens :: Coast Redwood 116 100 STAIRWAY24 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 100ST            
4452 4452 19593 DPW Maintained 3 Sequoia sempervirens :: Coast Redwood 116 100 STAIRWAY4 16 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 60            
5737 5737 20074 DPW Maintained 3 Sequoia sempervirens :: Coast Redwood 116 100 STAIRWAY55 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 27X            
6387 6387 19592 DPW Maintained 3 Sequoia sempervirens :: Coast Redwood 116 100 STAIRWAY4 15 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 60            
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            
7290 7290 19816 DPW Maintained 3 Sequoia sempervirens :: Coast Redwood 116 100 STAIRWAY24 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     6 100ST            
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            
12451 12451 20015 DPW Maintained 3 Sequoia sempervirens :: Coast Redwood 116 100 STAIRWAY47 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 100ST            
13822 13822 20456 DPW Maintained 3 Sequoia sempervirens :: Coast Redwood 116 495X Sunset Blvd 21 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 60            
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          
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            
86068 86068 121227 DPW Maintained 3 Sequoia sempervirens :: Coast Redwood 116 4299x 17th St 3 Front Yard : Yard 7 Tree 1 DPW 2                    
137797 137797 118610 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 349 Point Lobos Ave 2 Side Yard : Yard 17 Tree 1 Private 1     5     5981717.62769 2112632.61479 37.77982557339521 -122.506879529548 (37.7798255733952, -122.506879529548)
39303 39303 118611 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 349 Point Lobos Ave 3 Side Yard : Yard 17 Tree 1 Private 1     6     5981718.6857199995 2112644.15815 37.7798573303546 -122.506876725888 (37.7798573303546, -122.506876725888)
177016 177016 39822 Permitted Site 1 Sequoia sempervirens :: Coast Redwood 116 2190 46th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/1999 12:00:00 AM 1   Permit Number 41149 5982045.5543 2100206.3838 37.7457260090551 -122.504824075497 (37.7457260090551, -122.504824075497)
175534 175534 39823 Permitted Site 1 Sequoia sempervirens :: Coast Redwood 116 2190 46th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/1999 12:00:00 AM 1   Permit Number 41149 5982046.2311 2100191.8316 37.7456860925771 -122.50482065715099 (37.7456860925771, -122.504820657151)
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)
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)
176415 176415 118442 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 5201 Anza St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 3ft   5982468.47607 2111659.73383 37.777198515931794 -122.504209970081 (37.7771985159318, -122.504209970081)
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)
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)
51589 51589 184745 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1301 Sunset Blvd 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984671.0844 2106181.5705 37.7622863276384 -122.496186283596 (37.7622863276384, -122.496186283596)
35177 35177 184804 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1301 Sunset Blvd 65 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984679.0585 2105723.8188 37.7610299368102 -122.496124931271 (37.7610299368102, -122.496124931271)
55573 55573 184741 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1301 Sunset Blvd 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984704.12 2106224.4787 37.76240607654479 -122.496075193313 (37.7624060765448, -122.496075193313)
177279 177279 186668 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1401 Sunset Blvd 25 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984695.4068 2105524.4495 37.7604834820457 -122.49605368158001 (37.7604834820457, -122.49605368158)
183935 183935 186666 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1401 Sunset Blvd 23 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984702.5251 2105541.6172 37.76053103667871 -122.49603032958001 (37.7605310366787, -122.49603032958)
156845 156845 186677 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1401 Sunset Blvd 34 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984721.4724 2105427.5149 37.760218853394605 -122.49595638286101 (37.7602188533946, -122.495956382861)
74058 74058 186679 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1401 Sunset Blvd 36 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984735.2903 2105403.2290000003 37.760152980386 -122.495906802394 (37.760152980386, -122.495906802394)
44202 44202 186673 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1401 Sunset Blvd 30 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984739.5822 2105465.3048 37.7603236745559 -122.495896538326 (37.7603236745559, -122.495896538326)
47580 47580 186579 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1501 Sunset Blvd 50 unknown : Yard 19 Tree 1 Private 1     1 Width 0ft   5984739.2681 2104595.0921 37.7579342947119 -122.495833430643 (37.7579342947119, -122.495833430643)
163436 163436 186481 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1601 Sunset Blvd 69 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984737.1745 2103681.0182 37.7554243789331 -122.495773245735 (37.7554243789331, -122.495773245735)
172139 172139 186477 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1601 Sunset Blvd 65 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984748.0613 2103717.4471 37.7555250401648 -122.49573828341299 (37.7555250401648, -122.495738283413)
75550 75550 186581 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1501 Sunset Blvd 52 unknown : Yard 19 Tree 1 Private 1     2 Width 0ft   5984771.5099 2104576.6683 37.75788559627829 -122.495720567601 (37.7578855962783, -122.495720567601)
167499 167499 186728 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1300 Sunset Blvd 63 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984834.3273 2106260.9546 37.7625138548261 -122.49562755174401 (37.7625138548261, -122.495627551744)
36125 36125 186472 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1601 Sunset Blvd 60 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984790.3524 2103740.0582 37.755589600564704 -122.495593697553 (37.7555896005647, -122.495593697553)
168787 168787 181548 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1300 Sunset Blvd 26 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984846.3366 2105995.5399 37.761785803641 -122.495566439468 (37.761785803641, -122.495566439468)
64589 64589 186730 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1300 Sunset Blvd 65 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5984855.0036 2106288.7736 37.7625914487693 -122.495558092973 (37.7625914487693, -122.495558092973)
162708 162708 186727 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1300 Sunset Blvd 61 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984865.5297 2106265.0899 37.762527036338604 -122.49551994066002 (37.7625270363386, -122.49551994066)
73907 73907 186731 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1300 Sunset Blvd 66 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984870.0408 2106303.059 37.7626315529982 -122.495507139178 (37.7626315529982, -122.495507139178)
160179 160179 186729 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1300 Sunset Blvd 64 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984871.1686 2106270.3529 37.762541817251794 -122.49550082623999 (37.7625418172518, -122.49550082624)
167471 167471 181542 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1300 Sunset Blvd 20 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984868.615 2105905.3126 37.7615393692586 -122.495482733656 (37.7615393692586, -122.495482733656)
185835 185835 186726 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1300 Sunset Blvd 60 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5984877.9354 2106257.1953 37.7625060863994 -122.49547645222201 (37.7625060863994, -122.495476452222)
148152 148152 186376 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1801 Sunset Blvd 43 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984798.5659 2102512.3907 37.7522192455734 -122.495474752392 (37.7522192455734, -122.495474752392)
63429 63429 181539 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1300 Sunset Blvd 17 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984878.0833 2105873.5659 37.761452756110394 -122.4954476457 (37.7614527561104, -122.4954476457)
29043 29043 181547 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1300 Sunset Blvd 25 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984881.425 2105994.983 37.761786329172104 -122.495445043427 (37.7617863291721, -122.495445043427)
69472 69472 181545 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1300 Sunset Blvd 23 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984885.3237 2105962.1224 37.7616963314413 -122.495429135957 (37.7616963314413, -122.495429135957)
29532 29532 186369 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1801 Sunset Blvd 36 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984816.0737 2102538.2484 37.7522912688492 -122.495416115464 (37.7522912688492, -122.495416115464)
44071 44071 181543 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1300 Sunset Blvd 21 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984893.6781 2105927.5909 37.761602006776 -122.49539769507 (37.761602006776, -122.49539769507)
55401 55401 181491 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1400 Sunset Blvd 51 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984894.5136 2105385.9481 37.760114855862604 -122.49535485835699 (37.7601148558626, -122.495354858357)
30220 30220 181484 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1400 Sunset Blvd 44 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984898.4123 2105356.9862 37.7600355628364 -122.49533923888201 (37.7600355628364, -122.495339238882)
184520 184520 181386 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1500 Sunset Blvd 19 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984899.2058 2104514.6528 37.757722796238106 -122.495274374844 (37.7577227962381, -122.495274374844)
105322 105322 181478 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1400 Sunset Blvd 38 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984917.9059 2105334.1509 37.759974004815795 -122.495270136852 (37.7599740048158, -122.495270136852)
41346 41346 181435 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1500 Sunset Blvd 68 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984924.5894 2104933.1403 37.7588733327201 -122.495217449651 (37.7588733327201, -122.495217449651)
59035 59035 186092 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1901 Sunset Blvd 38 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984860.3007 2101794.0493 37.750250492095795 -122.495208298659 (37.7502504920958, -122.495208298659)
188847 188847 186087 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1901 Sunset Blvd 33 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984862.8194 2101833.0892 37.7503578324165 -122.495202467563 (37.7503578324165, -122.495202467563)
136288 136288 181391 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1500 Sunset Blvd 24 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984921.4841 2104558.6525 37.757844911537 -122.495200573085 (37.757844911537, -122.495200573085)
64455 64455 181395 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1500 Sunset Blvd 28 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984933.1803 2104579.26 37.7579021787746 -122.495161642957 (37.7579021787746, -122.495161642957)
48439 48439 181387 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1500 Sunset Blvd 20 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984939.8638 2104520.2223 37.757740468934294 -122.495134175513 (37.7577404689343, -122.495134175513)
171352 171352 185725 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2101 Sunset Blvd 57 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984855.2039 2100321.3236 37.7462064913622 -122.49511733688499 (37.7462064913622, -122.495117336885)
182897 182897 185734 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2101 Sunset Blvd 66 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984861.0881 2100291.2484 37.7461242575362 -122.495094773004 (37.7461242575362, -122.495094773004)
162095 162095 184091 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1600 Sunset Blvd 94 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984954.5787 2104192.9608 37.756842761121895 -122.495059154794 (37.7568427611219, -122.495059154794)
161471 161471 185566 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2201 Sunset Blvd 50 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984882.0949 2099749.7079 37.744638564328 -122.49498221146901 (37.744638564328, -122.494982211469)
167123 167123 185567 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2201 Sunset Blvd 51 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984881.8296 2099726.3595 37.7445744404291 -122.49498140754 (37.7445744404291, -122.49498140754)
132343 132343 185730 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2101 Sunset Blvd 62 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984911.7584 2100300.7286 37.7461532538825 -122.494920263061 (37.7461532538825, -122.494920263061)
184462 184462 185721 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2101 Sunset Blvd 53 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984915.0274 2100334.3998 37.7462458971959 -122.49491144168199 (37.7462458971959, -122.494911441682)
40898 40898 185564 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2201 Sunset Blvd 48 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984920.5667 2099758.7289 37.744665585625896 -122.494849850524 (37.7446655856259, -122.494849850524)
170341 170341 186034 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1900 Sunset Blvd 29 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984985.7569 2102048.9979 37.7509578553481 -122.494793264221 (37.7509578553481, -122.494793264221)
136491 136491 185568 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2201 Sunset Blvd 52 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984938.6086 2099724.7676 37.74457339320529 -122.49478496266701 (37.7445733932053, -122.494784962667)
171617 171617 187295 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2401 Sunset Blvd 78 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984937.4924 2098259.4132 37.7405498608751 -122.49468081101999 (37.7405498608751, -122.49468081102)
57134 57134 186036 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1900 Sunset Blvd 31 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985023.9883 2102086.2614 37.7510624084937 -122.49466380518 (37.7510624084937, -122.49466380518)
40656 40656 186033 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 1900 Sunset Blvd 28 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985025.9241 2102045.6103 37.7509509050251 -122.49465411447399 (37.7509509050251, -122.494654114474)
134633 134633 187307 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2401 Sunset Blvd 90 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984946.0227 2098230.3328 37.740470513218796 -122.49464917361601 (37.7404705132188, -122.494649173616)
35086 35086 185875 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2000 Sunset Blvd 19 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5985024.3241 2101081.1994 37.74830280287971 -122.494588557862 (37.7483028028797, -122.494588557862)
71275 71275 187306 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2401 Sunset Blvd 89 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5984963.8587 2098228.7818 37.7404672985278 -122.494587390296 (37.7404672985278, -122.494587390296)
50233 50233 187392 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2100 Sunset Blvd 45 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985024.2566 2100630.9061 37.7470664162932 -122.494555600597 (37.7470664162932, -122.494555600597)
153678 153678 187305 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2401 Sunset Blvd 88 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984977.8173 2098236.5366 37.740489408091605 -122.49453969916 (37.7404894080916, -122.49453969916)
159687 159687 185874 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2000 Sunset Blvd 18 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985052.1017 2101064.154 37.7482576266138 -122.494491248711 (37.7482576266138, -122.494491248711)
149148 149148 185877 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2000 Sunset Blvd 20 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985055.2583 2101098.876 37.7483531484939 -122.494482892668 (37.7483531484939, -122.494482892668)
52535 52535 187380 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2200 Sunset Blvd 66 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5985069.8747 2100065.0386 37.7455153678045 -122.494356154683 (37.7455153678045, -122.494356154683)
63967 63967 185633 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2100 Sunset Blvd 13 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985076.9465 2100353.2830000003 37.7463072224732 -122.494352945117 (37.7463072224732, -122.494352945117)
40320 40320 187361 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2200 Sunset Blvd 46 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5985088.1562 2099814.8531 37.7448294961486 -122.49427450340099 (37.7448294961486, -122.494274503401)
152219 152219 184995 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2701 Sunset Blvd 21 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985022.2207 2096528.9025 37.7358033013739 -122.494260335606 (37.7358033013739, -122.494260335606)
59256 59256 187358 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2200 Sunset Blvd 43 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5985096.2813 2099797.9258 37.7447834938464 -122.494245161303 (37.7447834938464, -122.494245161303)
164278 164278 185092 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2801 Sunset Blvd 20 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5985016.1492 2096009.4757 37.7343767385902 -122.494243052853 (37.7343767385902, -122.494243052853)
178388 178388 184997 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2701 Sunset Blvd 23 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985027.6641 2096515.5033 37.7357668292904 -122.49424052859399 (37.7357668292904, -122.494240528594)
65956 65956 185096 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2801 Sunset Blvd 24 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5985018.6615 2095986.0271 37.7343125019956 -122.494232639372 (37.7343125019956, -122.494232639372)
154758 154758 185095 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2801 Sunset Blvd 23 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5985029.9671 2095999.845 37.7343511038502 -122.494194570965 (37.7343511038502, -122.494194570965)
66493 66493 185214 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2500 Sunset Blvd 70 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985123.3973 2098105.6751 37.7401386169566 -122.494026705548 (37.7401386169566, -122.494026705548)
174989 174989 185220 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2500 Sunset Blvd 77 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985128.7096 2098140.8692 37.7402355613282 -122.49401093116998 (37.7402355613282, -122.49401093117)
163231 163231 185218 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2500 Sunset Blvd 75 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985145.9746 2098136.8849 37.7402256317054 -122.49395094305099 (37.7402256317054, -122.493950943051)
27330 27330 187124 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2600 Sunset Blvd 60 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5985135.2439 2097353.8058 37.738074878751895 -122.493930349328 (37.7380748787519, -122.493930349328)
25384 25384 185213 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2500 Sunset Blvd 68 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985153.279 2098105.011 37.740138541922 -122.49392333934799 (37.740138541922, -122.493923339348)
74083 74083 187107 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2600 Sunset Blvd 43 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985143.7078 2097238.6019 37.73775905490071 -122.49389259826401 (37.7377590549007, -122.493892598264)
146439 146439 187127 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2600 Sunset Blvd 63 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985167.6891 2097369.3231 37.7381193834059 -122.49381931494301 (37.7381193834059, -122.493819314943)
171538 171538 186924 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2700 Sunset Blvd 73 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985155.3367 2096781.1077 37.736503578508895 -122.493818687918 (37.7365035785089, -122.493818687918)
154850 154850 187128 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2600 Sunset Blvd 64 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5985172.8615 2097384.8403 37.738162292099204 -122.49380257480101 (37.7381622920992, -122.493802574801)
74839 74839 187109 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2600 Sunset Blvd 45 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5985172.8615 2097253.1787 37.7378007845896 -122.493792875188 (37.7378007845896, -122.493792875188)
187185 187185 186923 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2700 Sunset Blvd 72 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5985171.3814 2096790.2761 37.73652969119129 -122.493763890804 (37.7365296911913, -122.493763890804)
171909 171909 186922 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2700 Sunset Blvd 71 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5985180.0914 2096773.3145 37.736483628738604 -122.493732527554 (37.7364836287386, -122.493732527554)
60464 60464 186891 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 2700 Sunset Blvd 40 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5985178.2577 2096509.7223 37.7357597676042 -122.493719449451 (37.7357597676042, -122.493719449451)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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");
Powered by Datasette · Query took 120.673ms · Data source: data.sfgov.org