Street_Tree_List

Data source: data.sfgov.org

1,505 rows where qSiteInfo = 3 sorted by YCoord descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, PlantType, qCaretaker, PlantDate, PlotSize, PermitNotes

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord ▲ Latitude Longitude Location
69507 69507 132112 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1500x The Embarcadero 13 Median : Yard 3 Tree 1 DPW 2     20 Width 10ft   6011208.1934400005 2121737.88602 37.8065189965151 -122.40549956557501 (37.8065189965151, -122.405499565575)
30823 30823 132092 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1500x The Embarcadero 12 Median : Yard 3 Tree 1 DPW 2     20 Width 10ft   6011191.46105 2121714.3637599996 37.806453474602 -122.405555813649 (37.806453474602, -122.405555813649)
149311 149311 132111 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1500x The Embarcadero 11 Median : Yard 3 Tree 1 DPW 2     22 Width 10ft   6011290.22315 2121683.26622 37.806373610322105 -122.40521183646999 (37.8063736103221, -122.40521183647)
41127 41127 132091 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1500x The Embarcadero 10 Median : Yard 3 Tree 1 DPW 2     21 Width 10ft   6011272.98764 2121658.8993 37.806305741188204 -122.405269766312 (37.8063057411882, -122.405269766312)
168748 168748 132110 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1500x The Embarcadero 9 Median : Yard 3 Tree 1 DPW 2     23 Width 10ft   6011374.63029 2121626.67271 37.8062229369941 -122.404915741893 (37.8062229369941, -122.404915741893)
62222 62222 132090 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1500x The Embarcadero 8 Median : Yard 3 Tree 1 DPW 2     21 Width 10ft   6011358.77785 2121601.92287 37.8061540939119 -122.40496885853999 (37.8061540939119, -122.40496885854)
50014 50014 132109 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1500x The Embarcadero 7 Median : Yard 3 Tree 1 DPW 2     21 Width 10ft   6011459.50109 2121569.1071 37.8060696196846 -122.40461797546301 (37.8060696196846, -122.404617975463)
155474 155474 132089 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1500x The Embarcadero 6 Median : Yard 3 Tree 1 DPW 2     23 Width 10ft   6011437.6783 2121540.455 37.805989728403894 -122.404691478852 (37.8059897284039, -122.404691478852)
181994 181994 132108 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1500x The Embarcadero 5 Median : Yard 3 Tree 1 DPW 2     21 Width 10ft   6011532.668269999 2121506.48507 37.8059017639302 -122.404360356561 (37.8059017639302, -122.404360356561)
70595 70595 132088 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1500x The Embarcadero 4 Median : Yard 3 Tree 1 DPW 2     22 Width 10ft   6011509.10408 2121480.92062 37.8058302534199 -122.404440103948 (37.8058302534199, -122.404440103948)
182470 182470 132107 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1500x The Embarcadero 3 Median : Yard 3 Tree 1 DPW 2     22 Width 10ft   6011604.73213 2121437.1460700002 37.805715402812204 -122.40410608402901 (37.8057154028122, -122.404106084029)
70221 70221 132087 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1500x The Embarcadero 2 Median : Yard 3 Tree 1 DPW 2     20 Width 10ft   6011581.4658 2121414.5973099996 37.8056521894584 -122.40418501304501 (37.8056521894584, -122.404185013045)
166867 166867 132106 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1500x The Embarcadero 1 Median : Yard 3 Tree 1 DPW 2     20 Width 10ft   6011673.52168 2121373.1691 37.8055435810345 -122.40386352159099 (37.8055435810345, -122.403863521591)
168474 168474 132105 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1400x The Embarcadero 4 Median : Yard 3 Tree 1 DPW 2     20 Width 10ft   6012001.46692 2121074.30881 37.8047412994387 -122.402707584299 (37.8047412994387, -122.402707584299)
136050 136050 132086 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1400x The Embarcadero 3 Median : Yard 3 Tree 1 DPW 2     20 Width 10ft   6011972.21269 2121045.33445 37.8046601095467 -122.402806783124 (37.8046601095467, -122.402806783124)
177459 177459 132104 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1400x The Embarcadero 2 Median : Yard 3 Tree 1 DPW 2     19 Width 10ft   6012041.8343 2121038.82925 37.8046461349625 -122.402565391602 (37.8046461349625, -122.402565391602)
25048 25048 132103 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1400x The Embarcadero 1 Median : Yard 3 Tree 1 DPW 2     18 Width 10ft   6012095.78368 2120981.89347 37.8044928149639 -122.402374687645 (37.8044928149639, -122.402374687645)
153490 153490 132085 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1300x The Embarcadero 2 Median : Yard 3 Tree 1 DPW 2     23 Width 10ft   6012153.585109999 2120867.04559 37.8041806971541 -122.402166580042 (37.8041806971541, -122.402166580042)
176923 176923 132084 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1200x The Embarcadero 5 Median : Yard 3 Tree 1 DPW 2     25 Width 10ft   6012274.61558 2120706.35336 37.8037462301721 -122.401736440606 (37.8037462301721, -122.401736440606)
70617 70617 132083 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1200x The Embarcadero 3 Median : Yard 3 Tree 1 DPW 2     23 Width 10ft   6012328.94165 2120621.527 37.8035163490725 -122.401542475719 (37.8035163490725, -122.401542475719)
47529 47529 132102 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1200x The Embarcadero 2 Median : Yard 3 Tree 1 DPW 2     17 Width 10ft   6012409.883230001 2120572.1173400003 37.8033851982182 -122.401258897879 (37.8033851982182, -122.401258897879)
167812 167812 126605 DPW Maintained 3 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2900x Van Ness Ave 9 Median : Yard 3 Tree 1 DPW 2     27 Width 8ft   6005587.24482 2120569.72976 37.8029956442888 -122.424868752794 (37.8029956442888, -122.424868752794)
65398 65398 132082 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1200x The Embarcadero 1 Median : Yard 3 Tree 1 DPW 2     21 Width 10ft   6012375.04896 2120549.1986599998 37.803320325622295 -122.40137783233999 (37.8033203256223, -122.40137783234)
56654 56654 132101 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1100x The Embarcadero 17 Median : Yard 3 Tree 1 DPW 2     18 Width 10ft   6012520.61539 2120407.16114 37.802938445615 -122.40086410632 (37.802938445615, -122.40086410632)
135157 135157 132081 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1100x The Embarcadero 16 Median : Yard 3 Tree 1 DPW 2     20 Width 10ft   6012501.69351 2120366.8481099997 37.802826700352995 -122.400926752172 (37.802826700353, -122.400926752172)
48115 48115 132100 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1100x The Embarcadero 15 Median : Yard 3 Tree 1 DPW 2     24 Width 10ft   6012551.63717 2120363.68822 37.802820809805496 -122.400753698321 (37.8028208098055, -122.400753698321)
175803 175803 129354 DPW Maintained 3 Juniperus chinensis :: Juniper 19 1306x Montgomery St 52 Median : Yard 3 Tree 1 DPW 2     14 Width 8ft   6011388.89614 2120338.61388 37.8026870410416 -122.40477563290199 (37.8026870410416, -122.404775632902)
75147 75147 129353 DPW Maintained 3 Juniperus chinensis :: Juniper 19 1306x Montgomery St 51 Median : Yard 3 Tree 1 DPW 2     6 Width 8ft   6011391.406830001 2120329.06369 37.8026609588854 -122.404766271855 (37.8026609588854, -122.404766271855)
133038 133038 125868 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 1306x Montgomery St 50 Median : Yard 3 Tree 1 DPW 2     9 Width 8ft   6011397.07627 2120306.83138 37.80260023127779 -122.404745086537 (37.8026002312778, -122.404745086537)
129992 129992 132099 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1100x The Embarcadero 14 Median : Yard 3 Tree 1 DPW 2     22 Width 10ft   6012592.45443 2120302.68635 37.8026555899447 -122.40060816104099 (37.8026555899447, -122.400608161041)
131510 131510 125867 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 1306x Montgomery St 49 Median : Yard 3 Tree 1 DPW 2     7 Width 8ft   6011400.22925 2120293.8654 37.802564806093294 -122.40473326224199 (37.8025648060933, -122.404733262242)
73337 73337 125866 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 1306x Montgomery St 48 Median : Yard 3 Tree 1 DPW 2     6 Width 8ft   6011400.87154 2120290.44992 37.802555463919 -122.40473079899401 (37.802555463919, -122.404730798994)
37174 37174 132080 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1100x The Embarcadero 13 Median : Yard 3 Tree 1 DPW 2     26 Width 10ft   6012562.54875 2120282.53748 37.802598598112 -122.40071023410101 (37.802598598112, -122.400710234101)
47847 47847 125865 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 1306x Montgomery St 47 Median : Yard 3 Tree 1 DPW 2     8 Width 8ft   6011401.82838 2120281.49833 37.8025309385205 -122.404726857271 (37.8025309385205, -122.404726857271)
131755 131755 125864 DPW Maintained 3 Callistemon citrinus :: Lemon Bottlebrush 28 1306x Montgomery St 46 Median : Yard 3 Tree 1 DPW 2     11 Width 8ft   6011404.31889 2120270.9561400004 37.8025021314422 -122.404717496217 (37.8025021314422, -122.404717496217)
163136 163136 129352 DPW Maintained 3 Juniperus chinensis :: Juniper 19 1306x Montgomery St 45 Median : Yard 3 Tree 1 DPW 2     3 Width 8ft   6011406.69978 2120255.02893 37.8024585322873 -122.404708135188 (37.8024585322873, -122.404708135188)
25391 25391 132190 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 1306x Montgomery St 44 Median : Yard 3 Tree 1 DPW 2     15 Width 8ft   6011409.46246 2120250.86119 37.802447243101 -122.40469828132 (37.802447243101, -122.40469828132)
56827 56827 132189 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 1306x Montgomery St 43 Median : Yard 3 Tree 1 DPW 2     12 Width 8ft   6011411.367980001 2120233.14388 37.802398702198204 -122.404690439238 (37.8023987021982, -122.404690439238)
61544 61544 132098 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1100x The Embarcadero 12 Median : Yard 3 Tree 1 DPW 2     23 Width 10ft   6012646.4501 2120224.08688 37.802442786052396 -122.40041578348699 (37.8024427860524, -122.400415783487)
176286 176286 132079 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1100x The Embarcadero 11 Median : Yard 3 Tree 1 DPW 2     21 Width 10ft   6012611.87531 2120208.19637 37.8023972264213 -122.40053431322399 (37.8023972264213, -122.400534313224)
60923 60923 132188 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 1306x Montgomery St 42 Median : Yard 3 Tree 1 DPW 2     17 Width 8ft   6011420.08981 2120201.09522 37.802311191872896 -122.404657999787 (37.8023111918729, -122.404657999787)
36478 36478 133192 DPW Maintained 3 Pittosporum undulatum :: Victorian Box 26 1306x Montgomery St 41 Median : Yard 3 Tree 1 DPW 2     2 Width 8ft   6011420.83782 2120184.50099 37.8022656699768 -122.404654242423 (37.8022656699768, -122.404654242423)
56747 56747 132187 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 1306x Montgomery St 40 Median : Yard 3 Tree 1 DPW 2     14 Width 8ft   6011421.2833 2120182.68985 37.8022607219264 -122.404652573264 (37.8022607219264, -122.404652573264)
154652 154652 129351 DPW Maintained 3 Juniperus chinensis :: Juniper 19 1306x Montgomery St 39 Median : Yard 3 Tree 1 DPW 2     1 Width 8ft   6011425.67929 2120161.57643 37.8022029953207 -122.404635873741 (37.8022029953207, -122.404635873741)
26942 26942 129350 DPW Maintained 3 Juniperus chinensis :: Juniper 19 1306x Montgomery St 38 Median : Yard 3 Tree 1 DPW 2     1 Width 8ft   6011425.50986 2120159.17711 37.8021963979046 -122.404636291051 (37.8021963979046, -122.404636291051)
25644 25644 126371 DPW Maintained 3 Cotoneaster SPP :: Cotoneaster 234 1306x Montgomery St 37 Median : Yard 3 Tree 1 DPW 2     4 Width 8ft   6011427.3089 2120158.66 37.8021950785935 -122.404630029046 (37.8021950785935, -122.404630029046)
130411 130411 136579 DPW Maintained 3 Syringa :: Lilac Tree 422 1306x Montgomery St 36 Median : Yard 3 Tree 1 DPW 2     22 Width 8ft   6011426.53654 2120156.27295 37.8021884811707 -122.404632533662 (37.8021884811707, -122.404632533662)
59618 59618 132097 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1100x The Embarcadero 10 Median : Yard 3 Tree 1 DPW 2     22 Width 10ft   6012695.81427 2120154.0888900002 37.8022533411719 -122.400240038841 (37.8022533411719, -122.400240038841)
188999 188999 129349 DPW Maintained 3 Juniperus chinensis :: Juniper 19 1306x Montgomery St 35 Median : Yard 3 Tree 1 DPW 2     2 Width 8ft   6011426.64663 2120143.89656 37.8021545047788 -122.40463128093398 (37.8021545047788, -122.404631280934)
155841 155841 132186 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 1306x Montgomery St 34 Median : Yard 3 Tree 1 DPW 2     20 Width 8ft   6011427.6635300005 2120140.5117900004 37.8021452678603 -122.404627523539 (37.8021452678603, -122.404627523539)
27490 27490 129348 DPW Maintained 3 Juniperus chinensis :: Juniper 19 1306x Montgomery St 33 Median : Yard 3 Tree 1 DPW 2     2 Width 8ft   6011427.80927 2120135.82348 37.802132403051 -122.404626688974 (37.802132403051, -122.404626688974)
75574 75574 132078 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1100x The Embarcadero 9 Median : Yard 3 Tree 1 DPW 2     21 Width 10ft   6012663.130340001 2120132.51785 37.8021922897941 -122.40035162582899 (37.8021922897941, -122.400351625829)
136627 136627 132185 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 1306x Montgomery St 32 Median : Yard 3 Tree 1 DPW 2     31 Width 8ft   6011428.32338 2120121.70557 37.8020936674502 -122.40462391547301 (37.8020936674502, -122.404623915473)
41755 41755 126624 DPW Maintained 3 Ficus microcarpa :: Chinese Banyan 94 801x Greenwich St 1 Median : Yard 3 Tree 1 DPW 2     21 Width 10ft   6009066.28691 2120109.01558 37.801926529358504 -122.41279682292401 (37.8019265293585, -122.412796822924)
47369 47369 126370 DPW Maintained 3 Cotoneaster SPP :: Cotoneaster 234 1306x Montgomery St 31 Median : Yard 3 Tree 1 DPW 2     10 Width 8ft   6011433.37611 2120083.33032 37.801988580770995 -122.40460372750601 (37.801988580771, -122.404603727506)
150555 150555 132096 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1100x The Embarcadero 8 Median : Yard 3 Tree 1 DPW 2     21 Width 10ft   6012742.85934 2120080.46122 37.8020538004962 -122.400072065282 (37.8020538004962, -122.400072065282)
186279 186279 126369 DPW Maintained 3 Cotoneaster SPP :: Cotoneaster 234 1306x Montgomery St 30 Median : Yard 3 Tree 1 DPW 2     8 Width 8ft   6011435.17205 2120070.79941 37.801954274322206 -122.404596630044 (37.8019542743222, -122.404596630044)
25390 25390 132077 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1100x The Embarcadero 7 Median : Yard 3 Tree 1 DPW 2     23 Width 10ft   6012714.4120000005 2120058.1365799997 37.8019909162964 -122.400168938451 (37.8019909162964, -122.400168938451)
178416 178416 129103 DPW Maintained 3 Jacaranda mimosifolia :: Jacaranda 52 1306x Montgomery St 29 Median : Yard 3 Tree 1 DPW 2     2 Width 8ft   6011435.37643 2120050.37627 37.8018982087863 -122.40459448426901 (37.8018982087863, -122.404594484269)
157926 157926 125396 DPW Maintained 3 Acer palmatum :: Japanese Maple 175 1306x Montgomery St 28 Median : Yard 3 Tree 1 DPW 2     4 Width 8ft   6011438.3625300005 2120049.61228 37.8018962779427 -122.404584097094 (37.8018962779427, -122.404584097094)
25946 25946 126425 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 1306x Montgomery St 27 Median : Yard 3 Tree 1 DPW 2     13 Width 8ft   6011438.821769999 2120037.4711599997 37.8018629670555 -122.40458165273701 (37.8018629670555, -122.404581652737)
39759 39759 126424 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 1306x Montgomery St 26 Median : Yard 3 Tree 1 DPW 2     15 Width 8ft   6011439.456040001 2120033.94187 37.801853311934096 -122.404579209268 (37.8018533119341, -122.404579209268)
48107 48107 132184 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 1306x Montgomery St 25 Median : Yard 3 Tree 1 DPW 2     29 Width 8ft   6011444.3716 2120015.20461 37.8018021387065 -122.404560879294 (37.8018021387065, -122.404560879294)
76777 76777 132095 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1100x The Embarcadero 6 Median : Yard 3 Tree 1 DPW 2     23 Width 10ft   6012798.77066 2120004.26494 37.801847701082394 -122.39987323058901 (37.8018477010824, -122.399873230589)
137306 137306 125295 DPW Maintained 3 Acacia melanoxylon :: Blackwood Acacia 5 1306x Montgomery St 24 Median : Yard 3 Tree 1 DPW 2     5 Width 8ft   6011445.958380001 2119999.7387 37.801759761770604 -122.40455429893998 (37.8017597617706, -122.40455429894)
186536 186536 132183 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 1306x Montgomery St 23 Median : Yard 3 Tree 1 DPW 2     26 Width 8ft   6011446.11989 2119998.19994 37.801755545737294 -122.404553631656 (37.8017555457373, -122.404553631656)
84421 84421 96975 DPW Maintained 3 Tree(s) :: 17 399X Filbert St 4 Median : Yard 3 Tree 1 Private 1     24     6010951.1 2119992.4 37.8017119430502 -122.406266229116 (37.8017119430502, -122.406266229116)
93919 93919 96976 Undocumented 2 Pinus pinea :: Italian Stone Pine 143 390X Filbert St 1 Median : Yard 3 Tree 1 Rec/Park 3     28     6010951.1 2119992.4 37.8017119430502 -122.406266229116 (37.8017119430502, -122.406266229116)
103346 103346 95333 DPW Maintained 3 Tree(s) :: 17 399X Filbert St 5 Median : Yard 3 Tree 1 DPW 2     24     6010951.1 2119992.4 37.8017119430502 -122.406266229116 (37.8017119430502, -122.406266229116)
140619 140619 95331 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 390X Filbert St 2 Median : Yard 3 Tree 1 DPW 2     18     6010951.1 2119992.4 37.8017119430502 -122.406266229116 (37.8017119430502, -122.406266229116)
164863 164863 129537 DPW Maintained 3 Ligustrum japonicum :: Japanese Privet 4 1306x Montgomery St 22 Median : Yard 3 Tree 1 DPW 2     1 Width 8ft   6011446.5417 2119990.51434 37.801734466528 -122.404551630663 (37.801734466528, -122.404551630663)
164266 164266 132076 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1100x The Embarcadero 5 Median : Yard 3 Tree 1 DPW 2     25 Width 10ft   6012766.891340001 2119978.53875 37.8017752858665 -122.399981740966 (37.8017752858665, -122.399981740966)
49479 49479 132094 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1100x The Embarcadero 4 Median : Yard 3 Tree 1 DPW 2     24 Width 10ft   6012848.0944 2119927.2949200002 37.8016391096046 -122.39969713882601 (37.8016391096046, -122.399697138826)
32862 32862 132075 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1100x The Embarcadero 3 Median : Yard 3 Tree 1 DPW 2     23 Width 10ft   6012816.85763 2119903.53523 37.8015721299035 -122.399803563704 (37.8015721299035, -122.399803563704)
186566 186566 132093 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1100x The Embarcadero 2 Median : Yard 3 Tree 1 DPW 2     25 Width 10ft   6012902.31977 2119848.32419 37.8014252975988 -122.39950394556699 (37.8014252975988, -122.399503945567)
130689 130689 136295 DPW Maintained 3 Quercus suber :: Cork Oak 76 2600x Van Ness Ave 4 Median : Yard 3 Tree 1 DPW 2     16 Width 8ft   6005728.53037 2119520.31629 37.800122202431204 -122.42430514856899 (37.8001222024312, -122.424305148569)
137882 137882 132117 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1000x The Embarcadero 10 Median : Yard 3 Tree 1 DPW 2     17 Width 10ft   6013132.776319999 2119506.7755299998 37.800500329583 -122.398682475136 (37.800500329583, -122.398682475136)
131771 131771 132074 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1000x The Embarcadero 9 Median : Yard 3 Tree 1 DPW 2     20 Width 10ft   6013098.86351 2119482.52775 37.800431861502396 -122.39879812525601 (37.8004318615024, -122.398798125256)
68393 68393 132116 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1000x The Embarcadero 8 Median : Yard 3 Tree 1 DPW 2     23 Width 10ft   6013189.6161 2119421.22304 37.800268589579204 -122.39847977871901 (37.8002685895792, -122.398479778719)
115831 115831 132073 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1000x The Embarcadero 7 Median : Yard 3 Tree 1 DPW 2     24 Width 10ft   6013155.58738 2119398.1180000002 37.800203252927105 -122.39859590999501 (37.8002032529271, -122.398595909995)
147998 147998 132115 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1000x The Embarcadero 6 Median : Yard 3 Tree 1 DPW 2     23 Width 10ft   6013243.85901 2119336.7003900004 37.8000395322586 -122.398286142085 (37.8000395322586, -122.398286142085)
133036 133036 132072 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1000x The Embarcadero 5 Median : Yard 3 Tree 1 DPW 2     24 Width 10ft   6013209.184309999 2119314.66631 37.799977100409 -122.39840458371201 (37.799977100409, -122.398404583712)
66065 66065 132114 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1000x The Embarcadero 4 Median : Yard 3 Tree 1 DPW 2     20 Width 10ft   6013298.81612 2119255.09608 37.799818527453105 -122.39809024008001 (37.7998185274531, -122.39809024008)
62709 62709 132071 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1000x The Embarcadero 3 Median : Yard 3 Tree 1 DPW 2     23 Width 10ft   6013261.919290001 2119233.02284 37.7997558644996 -122.39821636821199 (37.7997558644996, -122.398216368212)
25072 25072 126288 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 2500x Van Ness Ave 7 Median : Yard 3 Tree 1 DPW 2     27 Width 8ft   6005772.33142 2119211.18315 37.7992758747311 -122.424131583019 (37.7992758747311, -122.424131583019)
27286 27286 132113 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 1000x The Embarcadero 2 Median : Yard 3 Tree 1 DPW 2     21 Width 10ft   6013330.52243 2119204.92075 37.7996825238869 -122.39797700193701 (37.7996825238869, -122.397977001937)
185868 185868 132133 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 500x The Embarcadero 13 Median : Yard 3 Tree 1 DPW 2     27 Width 10ft   6013516.34459 2118862.0699 37.7987514845508 -122.39730992891 (37.7987514845508, -122.39730992891)
62624 62624 132132 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 500x The Embarcadero 12 Median : Yard 3 Tree 1 DPW 2     24 Width 10ft   6013567.49669 2118786.0724 37.798545661218 -122.39712759317699 (37.798545661218, -122.397127593177)
74450 74450 132131 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 500x The Embarcadero 11 Median : Yard 3 Tree 1 DPW 2     25 Width 10ft   6013617.689669999 2118709.1573799998 37.7983372649156 -122.39694851296001 (37.7983372649156, -122.39694851296)
135993 135993 132130 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 500x The Embarcadero 10 Median : Yard 3 Tree 1 DPW 2     24 Width 10ft   6013704.00439 2118650.24995 37.79818032331121 -122.39664570406099 (37.7981803233112, -122.396645704061)
23802 23802 132129 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 500x The Embarcadero 9 Median : Yard 3 Tree 1 DPW 2     24 Width 10ft   6013671.61354 2118630.60451 37.79812457884061 -122.39675640879999 (37.7981245788406, -122.3967564088)
154063 154063 131160 DPW Maintained 3 Maytenus boaria :: Mayten 22 1237x Robert C Levy Tunl 16 Median : Yard 3 Tree 1 DPW 2     22     6007730.43085 2118156.7577 37.7964910475791 -122.41728110074301 (37.7964910475791, -122.417281100743)
147922 147922 131159 DPW Maintained 3 Maytenus boaria :: Mayten 22 1237x Robert C Levy Tunl 14 Median : Yard 3 Tree 1 DPW 2     15     6007700.78305 2118156.69801 37.7964892156499 -122.41738368460199 (37.7964892156499, -122.417383684602)
164473 164473 136005 DPW Maintained 3 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1237x Robert C Levy Tunl 9 Median : Yard 3 Tree 1 DPW 2     3     6007661.46268 2118150.4985 37.7964699809712 -122.417519302367 (37.7964699809712, -122.417519302367)
184176 184176 131158 DPW Maintained 3 Maytenus boaria :: Mayten 22 1237x Robert C Levy Tunl 13 Median : Yard 3 Tree 1 DPW 2     13     6007691.70139 2118146.70965 37.79646127913271 -122.417414400977 (37.7964612791327, -122.417414400977)
35780 35780 128877 DPW Maintained 3 Geijera parviflora :: Australian Willow 68 1237x Robert C Levy Tunl 6 Median : Yard 3 Tree 1 DPW 2     3     6007635.0884300005 2118146.70213 37.796458073045 -122.417610293998 (37.796458073045, -122.417610293998)
151682 151682 128876 DPW Maintained 3 Geijera parviflora :: Australian Willow 68 1237x Robert C Levy Tunl 5 Median : Yard 3 Tree 1 DPW 2     3     6007635.33447 2118142.36056 37.7964461660197 -122.417609134775 (37.7964461660197, -122.417609134775)
44709 44709 125485 DPW Maintained 3 Afrocarpus gracilior :: Fern Pine 70 1237x Robert C Levy Tunl 3 Median : Yard 3 Tree 1 DPW 2     10     6007640.9414 2118138.07584 37.796434716745 -122.417589429708 (37.796434716745, -122.417589429708)
174163 174163 125486 DPW Maintained 3 Afrocarpus gracilior :: Fern Pine 70 1237x Robert C Levy Tunl 4 Median : Yard 3 Tree 1 DPW 2     6     6007645.270330001 2118136.8198 37.7964315115565 -122.417574361577 (37.7964315115565, -122.417574361577)
182998 182998 128875 DPW Maintained 3 Geijera parviflora :: Australian Willow 68 1237x Robert C Levy Tunl 2 Median : Yard 3 Tree 1 DPW 2     2     6007636.05536 2118136.6748900004 37.7964305951503 -122.417606237154 (37.7964305951503, -122.417606237154)

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 875.698ms · Data source: data.sfgov.org