Street_Tree_List

Data source: data.sfgov.org

430 rows where qSpecies = 53 sorted by Longitude

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, PermitNotes

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude ▼ Location
5949 5949 19787 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 100 STAIRWAY19 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 50ST            
13931 13931 19779 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 100 STAIRWAY19 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 50ST            
16388 16388 115471 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 10X Junipero Serra Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24              
184481 184481 185713 Undocumented 2 Ulmus pumila :: Siberian Elm 53 2101 Sunset Blvd 44 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984850.6272 2100403.3767 37.746431518886105 -122.49513921196301 (37.7464315188861, -122.495139211963)
153233 153233 185963 Undocumented 2 Ulmus pumila :: Siberian Elm 53 2001 Sunset Blvd 22 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 0ft   5984881.7314 2101336.1941 37.7489946017929 -122.495100432866 (37.7489946017929, -122.495100432866)
136173 136173 185691 Undocumented 2 Ulmus pumila :: Siberian Elm 53 2101 Sunset Blvd 23 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984865.9917 2100533.4848 37.746789659782 -122.49509567655001 (37.746789659782, -122.49509567655)
37961 37961 185716 Undocumented 2 Ulmus pumila :: Siberian Elm 53 2101 Sunset Blvd 48 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984901.6243 2100400.4346 37.746426426174395 -122.49496265549601 (37.7464264261744, -122.494962655496)
133362 133362 185690 Undocumented 2 Ulmus pumila :: Siberian Elm 53 2101 Sunset Blvd 22 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 0ft   5984904.8934 2100540.6767 37.7468116841536 -122.494961690438 (37.7468116841536, -122.494961690438)
184155 184155 185728 Undocumented 2 Ulmus pumila :: Siberian Elm 53 2101 Sunset Blvd 60 Sidewalk: Property side : Yard 9 Tree 1 Private 1     21 Width 0ft   5984906.201 2100307.5936 37.7461717779802 -122.494939985658 (37.7461717779802, -122.494939985658)
170878 170878 185719 Undocumented 2 Ulmus pumila :: Siberian Elm 53 2101 Sunset Blvd 51 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 0ft   5984913.7198 2100361.206 37.7463194231796 -122.49491793929899 (37.7463194231796, -122.494917939299)
48389 48389 182457 Undocumented 2 Ulmus pumila :: Siberian Elm 53 1500 31st Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     27 Width 0ft   5986548.9803 2104732.6813 37.7584178970063 -122.48958488521099 (37.7584178970063, -122.489584885211)
163752 163752 182456 Undocumented 2 Ulmus pumila :: Siberian Elm 53 1500 31st Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     23 Width 0ft   5986548.9803 2104699.0505 37.758325556062104 -122.489582412162 (37.7583255560621, -122.489582412162)
177920 177920 182454 Undocumented 2 Ulmus pumila :: Siberian Elm 53 1500 31st Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     21 Width 0ft   5986553.619 2104615.5531 37.7580965659316 -122.489560229786 (37.7580965659316, -122.489560229786)
85887 85887 117255 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 1570 31ST AVE 3 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4           5986686.8 2104596.0 37.7580506528461 -122.489098201432 (37.7580506528461, -122.489098201432)
94173 94173 117256 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 1570 31ST AVE 4 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4           5986686.8 2104596.0 37.7580506528461 -122.489098201432 (37.7580506528461, -122.489098201432)
143144 143144 105784 Undocumented 2 Ulmus pumila :: Siberian Elm 53 1570 31ST AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4   04/18/2014 12:00:00 AM     Permit Number 772914 5986686.8 2104596.0 37.7580506528461 -122.489098201432 (37.7580506528461, -122.489098201432)
172059 172059 182465 Undocumented 2 Ulmus pumila :: Siberian Elm 53 2400 Lawton St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 0ft   5986689.3022 2104396.9525 37.7575042689843 -122.489074914666 (37.7575042689843, -122.489074914666)
77050 77050 181893 Undocumented 2 Ulmus pumila :: Siberian Elm 53 2370 29th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 0ft   5987361.9916 2099162.5217 37.7431711693476 -122.486364226347 (37.7431711693476, -122.486364226347)
128658 128658 398 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 3790X 19th Ave 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     15 2   5990471.16794 2090846.61881 37.7205185437854 -122.475006721555 (37.7205185437854, -122.475006721555)
112174 112174 400 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 3790X 19th Ave 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     22 2   5990476.72602 2090904.23897 37.7206770765591 -122.474991713144 (37.7206770765591, -122.474991713144)
86527 86527 397 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 3790X 19th Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     30 2   5990474.691459999 2090771.6766099997 37.720312975301 -122.474989074306 (37.720312975301, -122.474989074306)
90284 90284 401 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 3790X 19th Ave 12 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 2   5990481.9086 2090947.8037400001 37.7207969949539 -122.474976977183 (37.7207969949539, -122.474976977183)
87989 87989 395 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 3790X 19th Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     32 2   5990486.24663 2090696.51982 37.720107283055604 -122.474943649084 (37.7201072830556, -122.474943649084)
115742 115742 394 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 3790X 19th Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     30 2   5990492.73788 2090676.25296 37.720052011465896 -122.474919732673 (37.7200520114659, -122.474919732673)
113267 113267 393 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 3790X 19th Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     23 2   5990507.18031 2090652.7596599997 37.7199883416446 -122.47486809669701 (37.7199883416446, -122.474868096697)
72528 72528 392 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 3790X 19th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     19 2   5990516.36157 2090620.3648599999 37.7198999256056 -122.47483399727899 (37.7198999256056, -122.474833997279)
86397 86397 239 Permitted Site 1 Ulmus pumila :: Siberian Elm 53 3010X 19th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Dept of Real Estate 5     90 2   5990623.3177 2095139.449 37.73231439650579 -122.474793962374 (37.7323143965058, -122.474793962374)
117409 117409 227 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 2968 19th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     22 2X3   5990630.67566 2095430.1647700001 37.7331130547028 -122.474789735965 (37.7331130547028, -122.474789735965)
89332 89332 391 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 3790X 19th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     34 2   5990530.65648 2090591.3498 37.7198210858115 -122.474782468587 (37.7198210858115, -122.474782468587)
101162 101162 87591 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 3840 19th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     60     5990782.62319 2090250.3116099997 37.7188992769151 -122.473886649335 (37.7188992769151, -122.473886649335)
94747 94747 114034 Significant Tree 6 Ulmus pumila :: Siberian Elm 53 198x FONT BLVD 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     40 3x3   5990818.0 2089012.0 37.7155012267577 -122.473674083302 (37.7155012267577, -122.473674083302)
114875 114875 415 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 3862 19th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     70 2X6   5990878.963880001 2090116.60552 37.718537732694394 -122.473543893183 (37.7185377326944, -122.473543893183)
39612 39612 215615 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 57 : 4 Tree 1 Private 1     14 Width 0ft   5991138.24471 2090632.0819 37.719968115927 -122.472685238326 (37.719968115927, -122.472685238326)
157916 157916 215630 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 73 : 4 Tree 1 Private 1     9 Width 0ft   5991138.04395 2090591.7564599998 37.7198573805858 -122.47268299363998 (37.7198573805858, -122.47268299364)
63629 63629 215620 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 62 : 4 Tree 1 Private 1     3 Width 0ft   5991138.86268 2090625.2601299998 37.7199494208 -122.472682605115 (37.7199494208, -122.472682605115)
23924 23924 215624 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 66 : 4 Tree 1 Private 1     4 Width 0ft   5991139.11135 2090614.21248 37.7199191010706 -122.47268094048201 (37.7199191010706, -122.472680940482)
175424 175424 215628 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 71 : 4 Tree 1 Private 1     11 Width 0ft   5991139.39343 2090599.4181400002 37.7198784957874 -122.47267888733299 (37.7198784957874, -122.472678887333)
124841 124841 11792 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 1200X Junipero Serra Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 2   5991118.2706518 2089586.5464946998 37.7170961765154 -122.472678089933 (37.7170961765154, -122.472678089933)
55354 55354 215614 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 55 : 4 Tree 1 Private 1     5 Width 0ft   5991140.92054 2090646.29638 37.7200073002795 -122.472677024844 (37.7200073002795, -122.472677024844)
36497 36497 215645 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 88 : 4 Tree 1 Private 1     15 Width 0ft   5991139.08964 2090556.8339200001 37.7197615524271 -122.47267683419099 (37.7197615524271, -122.472676834191)
64737 64737 215641 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 84 : 4 Tree 1 Private 1     24 Width 0ft   5991139.80827 2090562.73433 37.719777795098 -122.472674780143 (37.719777795098, -122.472674780143)
187609 187609 215640 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 83 : 4 Tree 1 Private 1     5 Width 0ft   5991139.98278 2090571.01197 37.71980053355961 -122.472674780143 (37.7198005335596, -122.472674780143)
41079 41079 215635 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 78 : 4 Tree 1 Private 1     3 Width 0ft   5991140.257019999 2090584.0200099999 37.7198362663069 -122.47267478013 (37.7198362663069, -122.47267478013)
185313 185313 215647 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 90 : 4 Tree 1 Private 1     5 Width 0ft   5991141.92136 2090550.26747 37.719743686490396 -122.472666567521 (37.7197436864904, -122.472666567521)
65202 65202 215616 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 58 : 4 Tree 1 Private 1     18 Width 0ft   5991145.54579 2090633.2217299999 37.719971668250295 -122.472660084316 (37.7199716682503, -122.472660084316)
38027 38027 215623 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 65 : 4 Tree 1 Private 1     7 Width 0ft   5991145.2526 2090614.88415 37.7199213008035 -122.472659761464 (37.7199213008035, -122.472659761464)
53965 53965 215613 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 54 : 4 Tree 1 Private 1     6 Width 0ft   5991146.23554 2090648.32868 37.720013188138296 -122.47265880098699 (37.7200131881383, -122.472658800987)
75277 75277 215631 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 74 : 4 Tree 1 Private 1     4 Width 0ft   5991145.11917 2090589.24121 37.719850883885606 -122.472658354026 (37.7198508838856, -122.472658354026)
170489 170489 215610 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 50 : 4 Tree 1 Private 1     6 Width 0ft   5991146.77446 2090663.32778 37.7200544031655 -122.472658031161 (37.7200544031655, -122.472658031161)
54677 54677 215629 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 72 : 4 Tree 1 Private 1     6 Width 0ft   5991145.86247 2090596.3241400002 37.7198703748925 -122.47265630087 (37.7198703748925, -122.47265630087)
64611 64611 215646 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 89 : 4 Tree 1 Private 1     21 Width 0ft   5991144.95252 2090553.1611900001 37.71975180739361 -122.47265630084999 (37.7197518073936, -122.47265630085)
130396 130396 215622 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 64 : 4 Tree 1 Private 1     3 Width 0ft   5991146.64961 2090624.8002099998 37.7199486087273 -122.472655655135 (37.7199486087273, -122.472655655135)
188100 188100 215642 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 85 : 4 Tree 1 Private 1     3 Width 0ft   5991146.327190001 2090562.0053700001 37.7197761709066 -122.47265219363999 (37.7197761709066, -122.47265219364)
136462 136462 215621 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 63 : 4 Tree 1 Private 1     3 Width 0ft   5991148.3674800005 2090618.2199 37.7199306402575 -122.47264923758999 (37.7199306402575, -122.47264923759)
176243 176243 215636 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 79 : 4 Tree 1 Private 1     4 Width 0ft   5991147.9135 2090580.90098 37.7198281454204 -122.472648087333 (37.7198281454204, -122.472648087333)
58824 58824 215633 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 76 : 4 Tree 1 Private 1     4 Width 0ft   5991148.619390001 2090586.20981 37.719842763020104 -122.472646034205 (37.7198427630201, -122.472646034205)
39237 39237 215650 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 101 : 4 Tree 1 Private 1     14 Width 0ft   5991145.973069999 2090449.2056 37.7194664300225 -122.472645197812 (37.7194664300225, -122.472645197812)
160644 160644 215625 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 67 : 4 Tree 1 Private 1     7 Width 0ft   5991149.7740400005 2090612.8046400002 37.719915852707295 -122.472643981029 (37.7199158527073, -122.472643981029)
184159 184159 215648 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 92 : 4 Tree 1 Private 1     3 Width 0ft   5991148.46508 2090549.7895400003 37.7197427529995 -122.472643913597 (37.7197427529995, -122.472643913597)
62692 62692 215609 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 49 : 4 Tree 1 Private 1     6 Width 0ft   5991151.21969 2090669.8888599998 37.7200726755881 -122.472643143781 (37.7200726755881, -122.472643143781)
179478 179478 215604 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 38 : 4 Tree 1 Private 1     3 Width 0ft   5991153.81619 2090748.1801 37.7202877943298 -122.472639873854 (37.7202877943298, -122.472639873854)
129875 129875 215617 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 59 : 4 Tree 1 Private 1     6 Width 0ft   5991151.604669999 2090631.8002400002 37.71996811591 -122.47263903747299 (37.71996811591, -122.472639037473)
155249 155249 215634 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 77 : 4 Tree 1 Private 1     4 Width 0ft   5991150.9321800005 2090583.20344 37.7198346421452 -122.47263782070101 (37.7198346421452, -122.472637820701)
54836 54836 215643 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 86 : 4 Tree 1 Private 1     7 Width 0ft   5991150.43358 2090559.55238 37.7197696732999 -122.47263782068701 (37.7197696732999, -122.472637820687)
70971 70971 215639 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 82 : 4 Tree 1 Private 1     8 Width 0ft   5991150.62056 2090568.4216099998 37.719794036843794 -122.472637820681 (37.7197940368438, -122.472637820681)
183192 183192 215611 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 51 : 4 Tree 1 Private 1     3 Width 0ft   5991153.406 2090660.89558 37.720048108812705 -122.472634931171 (37.7200481088127, -122.472634931171)
155297 155297 215637 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 80 : 4 Tree 1 Private 1     4 Width 0ft   5991151.99496 2090577.2658 37.7198184003677 -122.47263371439699 (37.7198184003677, -122.472633714397)
129995 129995 215632 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 75 : 4 Tree 1 Private 1     7 Width 0ft   5991152.25672 2090589.68226 37.7198525080596 -122.472633714394 (37.7198525080596, -122.472633714394)
39462 39462 215649 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 93 : 4 Tree 1 Private 1     4 Width 0ft   5991151.37081 2090546.73366 37.7197345305043 -122.472633646933 (37.7197345305043, -122.472633646933)
163579 163579 215612 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 53 : 4 Tree 1 Private 1     1 Width 0ft   5991154.50456 2090649.59615 37.720017146953 -122.472630310457 (37.720017146953, -122.472630310457)
159718 159718 215608 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 48 : 4 Tree 1 Private 1     2 Width 0ft   5991156.01629 2090675.51857 37.720088411035206 -122.47262697396799 (37.7200884110352, -122.472626973968)
38177 38177 215644 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 87 : 4 Tree 1 Private 1     4 Width 0ft   5991153.983659999 2090558.88602 37.7197680491356 -122.472625500878 (37.7197680491356, -122.472625500878)
73830 73830 215605 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 39 : 4 Tree 1 Private 1     6 Width 0ft   5991158.3667 2090738.6198 37.7202618075092 -122.472623447724 (37.7202618075092, -122.472623447724)
136479 136479 215618 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 60 : 4 Tree 1 Private 1     8 Width 0ft   5991156.49559 2090631.32735 37.719967100580796 -122.472622096952 (37.7199671005808, -122.472622096952)
161666 161666 215607 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 47 : 4 Tree 1 Private 1     2 Width 0ft   5991157.54734 2090681.2167900002 37.7201041455671 -122.47262209693301 (37.7201041455671, -122.472622096933)
157547 157547 215619 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 61 : 4 Tree 1 Private 1     10 Width 0ft   5991156.50194 2090623.6682099998 37.719946070837395 -122.472621516875 (37.7199460708374, -122.472621516875)
57358 57358 215626 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 68 : 4 Tree 1 Private 1     3 Width 0ft   5991156.30566 2090612.66695 37.7199158527268 -122.47262139367099 (37.7199158527268, -122.472621393671)
158658 158658 215606 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 40 : 4 Tree 1 Private 1     11 Width 0ft   5991163.46661 2090729.52448 37.7202371292081 -122.47260515641399 (37.7202371292081, -122.472605156414)
44990 44990 215603 Undocumented 2 Ulmus pumila :: Siberian Elm 53 700 Junipero Serra Blvd 168 : 4 Tree 1 Private 1     16 Width 0ft   5991175.95809 2091313.6332900003 37.7218416708418 -122.47260454218399 (37.7218416708418, -122.472604542184)
133735 133735 215638 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 81 : 4 Tree 1 Private 1     17 Width 0ft   5991161.28352 2090567.01377 37.7197907884826 -122.47260086035801 (37.7197907884826, -122.472600860358)
43417 43417 215627 Undocumented 2 Ulmus pumila :: Siberian Elm 53 900 Junipero Serra Blvd 69 : 4 Tree 1 Private 1     13 Width 0ft   5991161.91923 2090597.1686900002 37.7198736232612 -122.472600860338 (37.7198736232612, -122.472600860338)
129670 129670 215602 Undocumented 2 Ulmus pumila :: Siberian Elm 53 700 Junipero Serra Blvd 166 : 4 Tree 1 Private 1     4 Width 0ft   5991204.303730001 2091328.4883700002 37.7218840999401 -122.47250764202101 (37.7218840999401, -122.472507642021)
104287 104287 215601 Undocumented 2 Ulmus pumila :: Siberian Elm 53 700 Junipero Serra Blvd 155 : 4 Tree 1 Private 1     15 Width 0ft   5991211.33426 2091424.54649 37.7221482587196 -122.472490339055 (37.7221482587196, -122.472490339055)
110227 110227 11741 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 900X Junipero Serra Blvd 19 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3X3   5991216.9689233005 2091217.0890623 37.7215789580388 -122.472455744827 (37.7215789580388, -122.472455744827)
122262 122262 11737 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 900X Junipero Serra Blvd 15 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 2x2   5991216.9689233005 2091217.0890623 37.7215789580388 -122.472455744827 (37.7215789580388, -122.472455744827)
94026 94026 29916 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 810 Junipero Serra Blvd 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12     5991252.04535388 2092080.81829703 37.7239525748811 -122.472397431071 (37.7239525748811, -122.472397431071)
95655 95655 29917 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 810 Junipero Serra Blvd 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   5991252.04535388 2092080.81829703 37.7239525748811 -122.472397431071 (37.7239525748811, -122.472397431071)
126369 126369 29915 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 810 Junipero Serra Blvd 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12     5991252.04535388 2092080.81829703 37.7239525748811 -122.472397431071 (37.7239525748811, -122.472397431071)
139259 139259 29914 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 810 Junipero Serra Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12     5991252.04535388 2092080.81829703 37.7239525748811 -122.472397431071 (37.7239525748811, -122.472397431071)
38340 38340 11711 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 800X Junipero Serra Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   5991258.8213354 2092171.434032 37.7242017753849 -122.472380610595 (37.7242017753849, -122.472380610595)
90813 90813 26778 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 800X Junipero Serra Blvd 31 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 4X4   5991258.8213354 2092171.434032 37.7242017753849 -122.472380610595 (37.7242017753849, -122.472380610595)
92989 92989 26772 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 800X Junipero Serra Blvd 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   5991258.8213354 2092171.434032 37.7242017753849 -122.472380610595 (37.7242017753849, -122.472380610595)
120490 120490 11712 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 800X Junipero Serra Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 4X4   5991258.8213354 2092171.434032 37.7242017753849 -122.472380610595 (37.7242017753849, -122.472380610595)
123546 123546 11713 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 800X Junipero Serra Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   5991258.8213354 2092171.434032 37.7242017753849 -122.472380610595 (37.7242017753849, -122.472380610595)
141037 141037 26779 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 800X Junipero Serra Blvd 34 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 4x4   5991258.8213354 2092171.434032 37.7242017753849 -122.472380610595 (37.7242017753849, -122.472380610595)
29922 29922 215600 Undocumented 2 Ulmus pumila :: Siberian Elm 53 700 Junipero Serra Blvd 67 : 4 Tree 1 Private 1     13 Width 0ft   5991265.7011400005 2092317.6532400001 37.724603655215894 -122.472367482699 (37.7246036552159, -122.472367482699)
41864 41864 215599 Undocumented 2 Ulmus pumila :: Siberian Elm 53 700 Junipero Serra Blvd 52 : 4 Tree 1 Private 1     14 Width 0ft   5991273.40065 2092440.71249 37.724941990971395 -122.47234983348999 (37.7249419909714, -122.47234983349)
62090 62090 215597 Undocumented 2 Ulmus pumila :: Siberian Elm 53 700 Junipero Serra Blvd 44 : 4 Tree 1 Private 1     15 Width 0ft   5991275.01695 2092498.39745 37.7251004730822 -122.47234844942498 (37.7251004730822, -122.472348449425)
176952 176952 215598 Undocumented 2 Ulmus pumila :: Siberian Elm 53 700 Junipero Serra Blvd 48 : 4 Tree 1 Private 1     13 Width 0ft   5991274.418330001 2092469.9979599998 37.725022460494706 -122.472348449422 (37.7250224604947, -122.472348449422)
20933 20933 11752 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 700X Junipero Serra Blvd 35 Median : Cutout 11 Tree 1 DPW 2   03/09/2013 12:00:00 AM 3 6X6   5991283.50431 2092598.4954900001 37.7253758086322 -122.47232640343799 (37.7253758086322, -122.472326403438)

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