Street_Tree_List

Data source: data.sfgov.org

430 rows where qSpecies = 53 sorted by qAddress descending

✎ 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
34942 34942 215575 Undocumented 2 Ulmus pumila :: Siberian Elm 53 95 Kirkham St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     41 Width 3ft   5994715.1652 2105292.6604299997 37.76042882975 -122.461383388048 (37.76042882975, -122.461383388048)
54701 54701 215577 Undocumented 2 Ulmus pumila :: Siberian Elm 53 95 Kirkham St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     48 Width 3ft   5994760.78175 2105295.21675 37.7604384740771 -122.461225807922 (37.7604384740771, -122.461225807922)
89632 89632 215576 Undocumented 2 Ulmus pumila :: Siberian Elm 53 95 Kirkham St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     39 Width 3ft   5994736.06961 2105294.2713 37.7604344559039 -122.461311206651 (37.7604344559039, -122.461311206651)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
108076 108076 11722 Permitted Site 1 Ulmus pumila :: Siberian Elm 53 899X Junipero Serra Blvd 13 Sidewalk: Curb side : Cutout 1 Tree 1 PUC 13     18 3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960661998 (37.7216528879997, -122.47220960662)
118796 118796 11718 Permitted Site 1 Ulmus pumila :: Siberian Elm 53 899X Junipero Serra Blvd 7 Sidewalk: Curb side : Cutout 1 Tree 1 PUC 13     36 3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960661998 (37.7216528879997, -122.47220960662)
82094 82094 1645 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 881 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 6X6   5995652.78213 2110475.54294 37.7747135991516 -122.458515810277 (37.7747135991516, -122.458515810277)
99379 99379 1642 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 860 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     100 3X3   5995719.79795 2110383.37965 37.7744643941763 -122.45827731837299 (37.7744643941763, -122.458277318373)
70741 70741 215579 Undocumented 2 Ulmus pumila :: Siberian Elm 53 851 Junipero Serra Blvd 12 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 3ft   5991331.01602 2091664.09591 37.7228129287478 -122.472094084291 (37.7228129287478, -122.472094084291)
76067 76067 215578 Undocumented 2 Ulmus pumila :: Siberian Elm 53 851 Junipero Serra Blvd 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25 Width 3ft   5991318.68956 2091495.76578 37.7223500225082 -122.47212443011101 (37.7223500225082, -122.472124430111)
100174 100174 1637 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 830 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     40 3X3   5995713.25263 2110507.70954 37.7748053952412 -122.45830896062701 (37.7748053952412, -122.458308960627)
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)
789 789 175382 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 80x Junipero Serra Blvd 19 Sidewalk: Curb side : Yard 2 Tree 1 DPW 2     2 Width 3ft   5991305.518069999 2089124.29272 37.7158377779634 -122.471997198511 (37.7158377779634, -122.471997198511)
837 837 175374 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 80x Junipero Serra Blvd 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     2 Width 3ft   5991412.70367 2088734.1730099998 37.714772806192606 -122.47159830692699 (37.7147728061926, -122.471598306927)
160 160 175377 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 80X Junipero Serra Blvd 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5991371.46907 2088876.77956 37.715161983326794 -122.471751215951 (37.7151619833268, -122.471751215951)
798 798 175378 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 80X Junipero Serra Blvd 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 Width 3ft   5991360.88178 2088922.0136900002 37.715285572641 -122.471791104494 (37.715285572641, -122.471791104494)
806 806 177713 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 80X Junipero Serra Blvd 18 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     16 Width 3ft   5991322.37032 2089056.90035 37.715653710133296 -122.471934040933 (37.7156537101333, -122.471934040933)
846 846 175047 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 80X Junipero Serra Blvd 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     21 Width 3ft   5991389.20246 2088805.53688 37.714967394312204 -122.47168473357 (37.7149673943122, -122.47168473357)
19729 19729 11613 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 80X Junipero Serra Blvd 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 2X2   5991396.1674726 2095410.2239213001 37.7331026312309 -122.472141799028 (37.7331026312309, -122.472141799028)
82725 82725 11620 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 80X Junipero Serra Blvd 19 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 2X2   5991396.1674726 2095410.2239213001 37.7331026312309 -122.472141799028 (37.7331026312309, -122.472141799028)
94750 94750 11616 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 80X Junipero Serra Blvd 11 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 2x2   5991396.1674726 2095410.2239213001 37.7331026312309 -122.472141799028 (37.7331026312309, -122.472141799028)
104574 104574 11619 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 80X Junipero Serra Blvd 18 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 2X2   5991396.1674726 2095410.2239213001 37.7331026312309 -122.472141799028 (37.7331026312309, -122.472141799028)
122715 122715 11615 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 80X Junipero Serra Blvd 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 2x2   5991396.1674726 2095410.2239213001 37.7331026312309 -122.472141799028 (37.7331026312309, -122.472141799028)
129272 129272 11614 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 80X Junipero Serra Blvd 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 2X2   5991396.1674726 2095410.2239213001 37.7331026312309 -122.472141799028 (37.7331026312309, -122.472141799028)
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)
79297 79297 11696 Permitted Site 1 Ulmus pumila :: Siberian Elm 53 799X Junipero Serra Blvd 15 Sidewalk: Curb side : Cutout 1 Tree 1 PUC 13     30 3   5991356.324435 2092039.0089713002 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425)
85915 85915 11690 Permitted Site 1 Ulmus pumila :: Siberian Elm 53 799X Junipero Serra Blvd 6 Sidewalk: Curb side : Cutout 1 Tree 1 PUC 13     30 3x3   5991356.324435 2092039.0089713002 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425)
88556 88556 11694 Permitted Site 1 Ulmus pumila :: Siberian Elm 53 799X Junipero Serra Blvd 11 Sidewalk: Curb side : Cutout 1 Tree 1 PUC 13     18 3   5991356.324435 2092039.0089713002 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425)
91904 91904 11692 Permitted Site 1 Ulmus pumila :: Siberian Elm 53 799X Junipero Serra Blvd 9 Sidewalk: Curb side : Cutout 1 Tree 1 PUC 13     24 3   5991356.324435 2092039.0089713002 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425)
92672 92672 85425 Permitted Site 1 Ulmus pumila :: Siberian Elm 53 799X Junipero Serra Blvd 29 Sidewalk: Curb side : Cutout 1 Tree 1 PUC 13     36 3x3   5991351.334229 2092039.32129 37.7238443805247 -122.472051185335 (37.7238443805247, -122.472051185335)
111277 111277 11695 Permitted Site 1 Ulmus pumila :: Siberian Elm 53 799X Junipero Serra Blvd 12 Sidewalk: Curb side : Cutout 1 Tree 1 PUC 13     18 3   5991356.324435 2092039.0089713002 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425)
112345 112345 26171 Permitted Site 1 Ulmus pumila :: Siberian Elm 53 799X Junipero Serra Blvd 16 Sidewalk: Curb side : Cutout 1 Tree 1 PUC 13   03/01/2000 12:00:00 AM 30 3x3   5991356.324435 2092039.0089713002 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425)
113163 113163 11689 Permitted Site 1 Ulmus pumila :: Siberian Elm 53 799X Junipero Serra Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 PUC 13     30 3   5991356.324435 2092039.0089713002 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425)
113884 113884 11686 Permitted Site 1 Ulmus pumila :: Siberian Elm 53 799X Junipero Serra Blvd 8 Sidewalk: Curb side : Cutout 1 Tree 1 PUC 13     30 3x3   5991356.324435 2092039.0089713002 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425)
121766 121766 85427 Permitted Site 1 Ulmus pumila :: Siberian Elm 53 799X Junipero Serra Blvd 18 Sidewalk: Curb side : Cutout 1 Tree 1 PUC 13     18 3x3   5991351.334229 2092039.32129 37.7238443805247 -122.472051185335 (37.7238443805247, -122.472051185335)
83287 83287 1622 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 781 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     21 3X4   5995639.652530001 2110927.44628 37.7759536520848 -122.45859394843201 (37.7759536520848, -122.458593948432)
36799 36799 123470 Undocumented 2 Ulmus pumila :: Siberian Elm 53 778 02nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 3ft   5995383.59468 2110411.0672400002 37.7745210919414 -122.45944230753099 (37.7745210919414, -122.459442307531)
96797 96797 1620 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 777 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     125 3X3   5995637.36215 2110958.16718 37.776037871937206 -122.45860409582599 (37.7760378719372, -122.458604095826)
181118 181118 123469 Undocumented 2 Ulmus pumila :: Siberian Elm 53 772 02nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     26 Width 5ft   5995383.36925 2110442.32995 37.7746069181393 -122.459445351917 (37.7746069181393, -122.459445351917)
89969 89969 1617 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 764 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     135 3X3   5995701.56639 2110898.08045 37.775876579407296 -122.458377647589 (37.7758765794073, -122.458377647589)
86737 86737 1428 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 75X Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     100 5   5995465.63795 2115574.8643900002 37.78870421691 -122.459532573841 (37.78870421691, -122.459532573841)
95505 95505 1429 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 75X Arguello Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     100 5   5995465.54596 2115556.4736099998 37.788653715516205 -122.45953155962 (37.7886537155162, -122.45953155962)
120429 120429 1430 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 75X Arguello Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     40 5   5995476.6114 2115563.93405 37.7886748361207 -122.45949381562299 (37.7886748361207, -122.459493815623)
124439 124439 1431 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 75X Arguello Blvd 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 5   5995471.94905 2115498.24125 37.788494193386896 -122.459505186902 (37.7884941933869, -122.459505186902)

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