Street_Tree_List

Data source: data.sfgov.org

430 rows where qSpecies = 53

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
40956 40956 242792 Undocumented 2 Ulmus pumila :: Siberian Elm 53 1200 San Jose Ave 12 Front Yard : Yard 7 Tree 1 Private 1     37     6003987.76148 2095934.3227099997 37.7352623274905 -122.42864664822399 (37.7352623274905, -122.428646648224)
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)
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)
42957 42957 137072 Undocumented 2 Ulmus pumila :: Siberian Elm 53 3598 Clay St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     26 Width 4ft   5997679.8137 2115460.2442400004 37.788516566519604 -122.451863614513 (37.7885165665196, -122.451863614513)
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)
44014 44014 215580 Undocumented 2 Ulmus pumila :: Siberian Elm 53 751 Junipero Serra Blvd 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24 Width 3ft   5991366.74972 2092229.04743 37.7243662135233 -122.47201171896499 (37.7243662135233, -122.472011718965)
44608 44608 215594 Undocumented 2 Ulmus pumila :: Siberian Elm 53 246 Sagamore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 4ft   5994531.01193 2087471.53389 37.7114858129011 -122.46072877062299 (37.7114858129011, -122.460728770623)
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)
45548 45548 45657 Permitted Site 1 Ulmus pumila :: Siberian Elm 53 1330 Union St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/13/2001 12:00:00 AM 18   Permit Number 44353 6006609.23369 2119082.98627 37.798971095388396 -122.421226497612 (37.7989710953884, -122.421226497612)
46257 46257 97505 Undocumented 2 Ulmus pumila :: Siberian Elm 53 20X 10th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/18/2011 12:00:00 AM 12 3x3 Permit Number 768079 6007672.0 2110712.0 37.7760462700595 -122.416955543158 (37.7760462700595, -122.416955543158)
47125 47125 123486 Undocumented 2 Ulmus pumila :: Siberian Elm 53 600 Arguello Blvd 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     24     5995665.690219999 2111872.7664900003 37.7785507478592 -122.458572325088 (37.7785507478592, -122.458572325088)
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)
49070 49070 137073 Undocumented 2 Ulmus pumila :: Siberian Elm 53 3598 Clay St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     16 Width 4ft   5997662.024569999 2115459.05462 37.7885122812527 -122.45192507598699 (37.7885122812527, -122.451925075987)
50637 50637 117189 Permitted Site 1 Ulmus pumila :: Siberian Elm 53 1335 Washington St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6008262.17379 2117224.41185 37.793960957890896 -122.415375111785 (37.7939609578909, -122.415375111785)
52498 52498 123489 Undocumented 2 Ulmus pumila :: Siberian Elm 53 600 Arguello Blvd 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     20     5995672.03179 2111788.60232 37.7783200198099 -122.458544293173 (37.7783200198099, -122.458544293173)
52532 52532 124686 Undocumented 2 Ulmus pumila :: Siberian Elm 53 460 Arguello Blvd 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 4ft   5995607.11329 2113402.43136 37.7827474336358 -122.458885742796 (37.7827474336358, -122.458885742796)
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)
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)
54703 54703 39229 Permitted Site 1 Ulmus pumila :: Siberian Elm 53 1335 Washington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/04/1998 12:00:00 AM 15 3x3 Permit Number 40871 6008226.63206 2117220.6849599998 37.793948727108 -122.41549782608699 (37.793948727108, -122.415497826087)
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)
56269 56269 1048 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 2029X Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3X3   6000595.57615 2090275.75201 37.719532630863 -122.439969044998 (37.719532630863, -122.439969044998)
57260 57260 242793 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 2x Coso Ave 1 Median : Yard 3 Tree 1 DPW 2     30 Width 9ft   6007083.58829 2099965.0449 37.746504513177 -122.418228897148 (37.746504513177, -122.418228897148)
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)
57951 57951 199844 Undocumented 2 Ulmus pumila :: Siberian Elm 53 1617 Armstrong Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     32 Width 0ft   6014142.1837 2092625.4409 37.7267462633936 -122.39330733792801 (37.7267462633936, -122.393307337928)
58162 58162 180588 Undocumented 2 Ulmus pumila :: Siberian Elm 53 1447 Alemany Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 Width 5ft   6002392.55611 2093716.4847400002 37.729082242150795 -122.434003367375 (37.7290822421508, -122.434003367375)
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)
60171 60171 242791 Undocumented 2 Ulmus pumila :: Siberian Elm 53 1001 San Jose Ave 14 Front Yard : Yard 7 Tree 1 Private 1     5     6005175.70924 2096892.8816200001 37.7379614744454 -122.424607638258 (37.7379614744454, -122.424607638258)
60841 60841 215593 Undocumented 2 Ulmus pumila :: Siberian Elm 53 103 Sagamore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 3ft   5995757.42889 2087376.9000799998 37.7112964570463 -122.45648314049801 (37.7112964570463, -122.456483140498)
61015 61015 242794 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 2x Coso Ave 4 Median : Yard 3 Tree 1 DPW 2     30     6007112.52178 2099889.35747 37.746298321115 -122.418123483128 (37.746298321115, -122.418123483128)
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)
62104 62104 215587 Undocumented 2 Ulmus pumila :: Siberian Elm 53 751 Junipero Serra Blvd 29 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     27 Width 3ft   5991411.41096 2092949.8935 37.7263480620905 -122.47190984556002 (37.7263480620905, -122.47190984556)
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)
66690 66690 137069 Undocumented 2 Ulmus pumila :: Siberian Elm 53 7 Laurel St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   5997939.35301 2116349.8609700003 37.7909740791344 -122.45102982968099 (37.7909740791344, -122.451029829681)
66806 66806 123958 Undocumented 2 Ulmus pumila :: Siberian Elm 53 295 07th Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   5993672.37881 2113557.39213 37.7830615134244 -122.46559031264799 (37.7830615134244, -122.465590312648)
66816 66816 124642 Undocumented 2 Ulmus pumila :: Siberian Elm 53 50 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   5995529.95307 2115590.13506 37.7887498439417 -122.459311160683 (37.7887498439417, -122.459311160683)
69286 69286 58907 Permitted Site 1 Ulmus pumila :: Siberian Elm 53 354 Peninsula Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/07/1980 12:00:00 AM 29   Permit Number 18182 6012260.63611 2086890.34143 37.7108941228427 -122.39940938545601 (37.7108941228427, -122.399409385456)
69626 69626 180591 Undocumented 2 Ulmus pumila :: Siberian Elm 53 1804 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     22 Width 4ft   6001183.24158 2091479.89441 37.72287237033329 -122.438023911598 (37.7228723703333, -122.438023911598)
69819 69819 180585 Undocumented 2 Ulmus pumila :: Siberian Elm 53 177 Santa Rosa Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 2ft   6001325.27813 2093179.51545 37.7275472199251 -122.43765458428999 (37.7275472199251, -122.43765458429)
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)
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)
72396 72396 180590 Undocumented 2 Ulmus pumila :: Siberian Elm 53 1159 Alemany Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 4ft   6003628.44812 2094335.41976 37.7308517598817 -122.429774919684 (37.7308517598817, -122.429774919684)
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)
72604 72604 180587 Undocumented 2 Ulmus pumila :: Siberian Elm 53 1473 Alemany Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     23 Width 4ft   6002172.86661 2093413.1451700001 37.7282368704302 -122.434741167586 (37.7282368704302, -122.434741167586)
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)
74903 74903 215591 Undocumented 2 Ulmus pumila :: Siberian Elm 53 233 Sagamore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   5994635.3694400005 2087388.76073 37.711264541001206 -122.460362092762 (37.7112645410012, -122.460362092762)
74958 74958 180583 Undocumented 2 Ulmus pumila :: Siberian Elm 53 1114 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 Width 4ft   6003761.56491 2094470.84041 37.731231131690706 -122.42932436652599 (37.7312311316907, -122.429324366526)
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)
75801 75801 180584 Undocumented 2 Ulmus pumila :: Siberian Elm 53 1114 Alemany Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     22 Width 4ft   6003732.95256 2094463.1481400002 37.7312083905422 -122.42942273618601 (37.7312083905422, -122.429422736186)
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)
76669 76669 215596 Undocumented 2 Ulmus pumila :: Siberian Elm 53 500 Junipero Serra Blvd 52 : 4 Tree 1 Private 1     13 Width 0ft   5991321.6635 2093392.1066299998 37.7275570755768 -122.472252316385 (37.7275570755768, -122.472252316385)
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)
77659 77659 7482 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 2650X Folsom St 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     60 3x3   6008254.1361302 2102990.9843832003 37.7548788814664 -122.414395330099 (37.7548788814664, -122.414395330099)
77875 77875 106884 Undocumented 2 Ulmus pumila :: Siberian Elm 53 180X SAN MARCOS AVE 6 Median : Cutout 11 Tree 1 Private 1 DPW 4   4     5993452.8 2100406.9 37.746941053663505 -122.46539437233801 (37.7469410536635, -122.465394372338)
77976 77976 99913 Undocumented 2 Ulmus pumila :: Siberian Elm 53 3751X Fair Oaks St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3 Permit Number 768933 6005509.050559999 2101091.11643 37.7495076933522 -122.42375353501998 (37.7495076933522, -122.42375353502)
79283 79283 21830 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 1419X Alemany Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X6   6002361.46709 2093663.80125 37.7289358208429 -122.43410707985599 (37.7289358208429, -122.434107079856)
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)
79677 79677 10721 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 50X Hollis St 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6003939.0547033 2113373.9919105 37.783144751009495 -122.430058726681 (37.7831447510095, -122.430058726681)
79844 79844 1477 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 245 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     35 3X3   5995501.2635699995 2114653.66128 37.7861768902412 -122.45934257653799 (37.7861768902412, -122.459342576538)
79845 79845 933 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 1294X Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     30 3x3   6002802.17626 2094143.63343 37.7302783338422 -122.432617778446 (37.7302783338422, -122.432617778446)
80029 80029 11626 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 300X Junipero Serra Blvd 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   5991444.7104442 2094652.0546396 37.7310236980815 -122.471918736195 (37.7310236980815, -122.471918736195)
80768 80768 10719 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 50X Hollis St 6 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6003939.0547033 2113373.9919105 37.783144751009495 -122.430058726681 (37.7831447510095, -122.430058726681)
81090 81090 6279 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 1475 Ellis St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6003832.24761 2113162.85488 37.782558971887205 -122.430413166544 (37.7825589718872, -122.430413166544)
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)
82113 82113 929 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 1286X Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     25 3x3   6002834.53778 2094157.0386599998 37.73031697676271 -122.432506857514 (37.7303169767627, -122.432506857514)
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)
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)
83537 83537 1032 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 1989X Alemany Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     60 3X6   6000752.12664 2090469.86783 37.7200745396752 -122.439441815719 (37.7200745396752, -122.439441815719)
83607 83607 1433 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 100X Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     30 5X5   5995535.85964 2115388.7214900004 37.7881971563264 -122.459276133553 (37.7881971563264, -122.459276133553)
83779 83779 1867 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 2555 Bay Shore Blvd 8 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     18 3x3   6010748.9210869 2086419.1045134 37.7095158271004 -122.404601102054 (37.7095158271004, -122.404601102054)
84012 84012 1042 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 1999X Alemany Blvd 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     40 4X4   6000738.08152 2090455.78835 37.72003508127371 -122.439489356062 (37.7200350812737, -122.439489356062)
84024 84024 11677 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 700X Junipero Serra Blvd 10 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 4x4   5991320.9947906 2093088.5989831001 37.7267236805691 -122.472232513363 (37.7267236805691, -122.472232513363)
84863 84863 1182 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 3003 Alemany Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 3x3   5996737.10872 2087300.2249 37.7111421206036 -122.45309160658 (37.7111421206036, -122.45309160658)
85463 85463 1534 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 470X Arguello Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     125 3X3   5995618.147655 2113146.451022 37.7820452142616 -122.458829030077 (37.7820452142616, -122.458829030077)
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)
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)
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)
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)
86707 86707 7464 Permitted Site 1 Ulmus pumila :: Siberian Elm 53 2599 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     60 3X3   6008286.46562 2103308.5385 37.7557526290701 -122.41430599230301 (37.7557526290701, -122.414305992303)
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)
86841 86841 7477 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 2650X Folsom St 5 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     60 3x3   6008254.1361302 2102990.9843832003 37.7548788814664 -122.414395330099 (37.7548788814664, -122.414395330099)
87059 87059 1438 Permitted Site 1 Ulmus pumila :: Siberian Elm 53 101X Arguello Blvd 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 5   5995477.38208 2115292.8933900003 37.787930676078794 -122.45947151175501 (37.7879306760788, -122.459471511755)
87254 87254 7476 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 2650X Folsom St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     60 3x3   6008254.1361302 2102990.9843832003 37.7548788814664 -122.414395330099 (37.7548788814664, -122.414395330099)
87541 87541 121665 Undocumented 2 Ulmus pumila :: Siberian Elm 53 100 Montalvo Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x6   5993653.0 2099666.0 37.7449182738718 -122.46464831295299 (37.7449182738718, -122.464648312953)
87555 87555 19303 Permitted Site 1 Ulmus pumila :: Siberian Elm 53 2087X Alemany Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     35 3X3   6000281.49897 2089976.15715 37.7186921269443 -122.44103321029101 (37.7186921269443, -122.441033210291)
87605 87605 1441 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 138 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     42 5X5   5995537.91826 2115271.42403 37.7878752075455 -122.459260513654 (37.7878752075455, -122.459260513654)
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)
88057 88057 883 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 1100X ALEMANY BLVD 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     30 3X6   6003437.0 2094359.0 37.7309056628368 -122.43043846836599 (37.7309056628368, -122.430438468366)
88173 88173 6271 Permitted Site 1 Ulmus pumila :: Siberian Elm 53 1420X Ellis St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 4X4   6004021.46971 2113238.82139 37.782778273754104 -122.429763959937 (37.7827782737541, -122.429763959937)
88210 88210 11676 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 700X Junipero Serra Blvd 9 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     24 4x4   5991320.9947906 2093088.5989831001 37.7267236805691 -122.472232513363 (37.7267236805691, -122.472232513363)
88227 88227 51907 Permitted Site 1 Ulmus pumila :: Siberian Elm 53 157 Day St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/18/2005 12:00:00 AM     Permit Number 48113 6004926.17092668 2098691.36646376 37.7428856098168 -122.42559837996599 (37.7428856098168, -122.425598379966)
88504 88504 19105 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 3155X Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     32 3x3   5995592.56281 2086919.9321700002 37.7100322629968 -122.457019923286 (37.7100322629968, -122.457019923286)
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)
89099 89099 6281 DPW Maintained 3 Ulmus pumila :: Siberian Elm 53 1475 Ellis St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 4X4   6003892.9969 2113024.38483 37.7821822086902 -122.43019311854601 (37.7821822086902, -122.430193118546)
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)

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