Street_Tree_List

Data source: data.sfgov.org

430 rows where qSpecies = 53 sorted by qCaretaker

✎ 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
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)
3284 3284 253385 Undocumented 2 Ulmus pumila :: Siberian Elm 53 1100 Golden Gate Ave 1 Front Yard : Yard 7 Tree 1 Private 1           6004275.0 2112509.0 37.780788718892204 -122.428834805692 (37.7807887188922, -122.428834805692)
3375 3375 253429 Undocumented 2 Ulmus pumila :: Siberian Elm 53 2198 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       5x7   5992046.0 2112030.0 37.7787737730441 -122.471105555235 (37.7787737730441, -122.471105555235)
8324 8324 106867 Undocumented 2 Ulmus pumila :: Siberian Elm 53 1974 Union St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 3x3   6003576.11959 2118663.726 37.797648453467396 -122.431692125901 (37.7976484534674, -122.431692125901)
9059 9059 896 Permitted Site 1 Ulmus pumila :: Siberian Elm 53 1155X Alemany Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 4X4   6003365.90456 2094243.1413900002 37.730583513638294 -122.43067599245 (37.7305835136383, -122.43067599245)
9213 9213 885 Permitted Site 1 Ulmus pumila :: Siberian Elm 53 1100X ALEMANY BLVD 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20     6003437.0 2094359.0 37.7309056628368 -122.43043846836599 (37.7309056628368, -122.430438468366)
9367 9367 884 Permitted Site 1 Ulmus pumila :: Siberian Elm 53 1100X ALEMANY BLVD 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/22/2008 12:00:00 AM 24 3X6   6003437.0 2094359.0 37.7309056628368 -122.43043846836599 (37.7309056628368, -122.430438468366)
9461 9461 22540 Permitted Site 1 Ulmus pumila :: Siberian Elm 53 1441X Alemany Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 12X6   6002335.8535400005 2093628.68187 37.728837937275 -122.43419311802099 (37.728837937275, -122.434193118021)
11189 11189 914 Permitted Site 1 Ulmus pumila :: Siberian Elm 53 1233 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 3X5   6003058.45033 2094142.0195400002 37.730288432643796 -122.431731689776 (37.7302884326438, -122.431731689776)
11385 11385 4849 Permitted Site 1 Ulmus pumila :: Siberian Elm 53 1469X Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 3X6   6002249.52444 2093516.68285 37.7285255132222 -122.43448355857402 (37.7285255132222, -122.434483558574)
11865 11865 939 Permitted Site 1 Ulmus pumila :: Siberian Elm 53 1325 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 3X3   6002500.20649 2093846.32088 37.7294448514873 -122.433640487323 (37.7294448514873, -122.433640487323)
11990 11990 1085 Permitted Site 1 Ulmus pumila :: Siberian Elm 53 2156 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 3X3   5999963.70084 2089791.4898700002 37.7181669663093 -122.442118458302 (37.7181669663093, -122.442118458302)
12243 12243 974 Permitted Site 1 Ulmus pumila :: Siberian Elm 53 1599 Alemany Blvd 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     40 3X5   6001933.9280900005 2093061.6302200002 37.7272581220521 -122.435542049851 (37.7272581220521, -122.435542049851)
12842 12842 912 Permitted Site 1 Ulmus pumila :: Siberian Elm 53 1229 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 4X4   6003089.95028 2094152.4368200002 37.730318821659296 -122.431623533692 (37.7303188216593, -122.431623533692)
19243 19243 39175 Permitted Site 1 Ulmus pumila :: Siberian Elm 53 750 South Van Ness Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/27/2002 12:00:00 AM 10   Permit Number 40836 6007492.94598473 2105289.21429212 37.7611465023321 -122.417190590059 (37.7611465023321, -122.417190590059)
19652 19652 99912 Undocumented 2 Ulmus pumila :: Siberian Elm 53 3751X Fair Oaks St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6005509.050559999 2101091.11643 37.7495076933522 -122.42375353501998 (37.7495076933522, -122.42375353502)
19881 19881 19078 Permitted Site 1 Ulmus pumila :: Siberian Elm 53 215 Sagamore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 3X3   5994825.043959999 2087387.37086 37.711271633946296 -122.459706433929 (37.7112716339463, -122.459706433929)
20873 20873 19088 Permitted Site 1 Ulmus pumila :: Siberian Elm 53 238 Sagamore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 3X3   5994602.312969999 2087471.0641 37.7114886250695 -122.460482303322 (37.7114886250695, -122.460482303322)
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)
24510 24510 142976 Undocumented 2 Ulmus pumila :: Siberian Elm 53 392 CHESTNUT ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 0ft   6009963.6556 2120937.6931 37.80425219968421 -122.409750018417 (37.8042521996842, -122.409750018417)
25535 25535 180581 Undocumented 2 Ulmus pumila :: Siberian Elm 53 1394 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     22 Width 5ft   6002394.23037 2093854.8065099998 37.72946213735921 -122.434007462878 (37.7294621373592, -122.434007462878)
26083 26083 123491 Undocumented 2 Ulmus pumila :: Siberian Elm 53 600 Arguello Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     30     5995674.45752 2111730.9534 37.77816187055421 -122.458531727532 (37.7781618705542, -122.458531727532)
26368 26368 137075 Undocumented 2 Ulmus pumila :: Siberian Elm 53 689 Hayes St 1 : 4 Tree 1 Private 1     24 Width 5ft   6004617.552730001 2110839.21576 37.776223284701 -122.42753075415001 (37.776223284701, -122.42753075415)
28271 28271 215581 Undocumented 2 Ulmus pumila :: Siberian Elm 53 751 Junipero Serra Blvd 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25 Width 3ft   5991373.01779 2092318.20321 37.7246113758903 -122.471996546509 (37.7246113758903, -122.471996546509)
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)
30170 30170 180579 Undocumented 2 Ulmus pumila :: Siberian Elm 53 2500 Bay Shore Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 4ft   6010790.74354 2086511.28723 37.7097712796836 -122.404463040238 (37.7097712796836, -122.404463040238)
30230 30230 199847 Undocumented 2 Ulmus pumila :: Siberian Elm 53 1611 Armstrong Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     30 Width 0ft   6014254.2532 2092550.5249 37.7265467847844 -122.392914674805 (37.7265467847844, -122.392914674805)
31393 31393 123644 Undocumented 2 Ulmus pumila :: Siberian Elm 53 445 Arguello Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 3ft   5995555.16132 2113176.03479 37.78212282277371 -122.45904907539101 (37.7821228227737, -122.459049075391)
33957 33957 137078 Undocumented 2 Ulmus pumila :: Siberian Elm 53 1639 Taylor St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6008753.16727 2118586.36158 37.7977281199218 -122.413772601749 (37.7977281199218, -122.413772601749)
34555 34555 180593 Undocumented 2 Ulmus pumila :: Siberian Elm 53 2136 Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 4ft   6000017.35738 2089840.46995 37.718304512220605 -122.44193650477699 (37.7183045122206, -122.441936504777)
34624 34624 142237 Undocumented 2 Ulmus pumila :: Siberian Elm 53 689 HAYES ST 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 0ft   6004726.9033 2110859.9695 37.7762864537737 -122.42715395911101 (37.7762864537737, -122.427153959111)
34747 34747 123483 Undocumented 2 Ulmus pumila :: Siberian Elm 53 600 Arguello Blvd 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     34     5995662.44998 2111958.25695 37.7787852957742 -122.458589724568 (37.7787852957742, -122.458589724568)
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)
36173 36173 137082 Undocumented 2 Ulmus pumila :: Siberian Elm 53 1627 Taylor St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6008777.375519999 2118389.76877 37.7971896841052 -122.413674921875 (37.7971896841052, -122.413674921875)
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)
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)
36822 36822 215590 Undocumented 2 Ulmus pumila :: Siberian Elm 53 501 Junipero Serra Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     26 Width 3ft   5991474.9385 2093941.2931 37.729073873942795 -122.47176245478701 (37.7290738739428, -122.471762454787)
37126 37126 124641 Undocumented 2 Ulmus pumila :: Siberian Elm 53 60 Arguello Blvd 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 3ft   5995529.17868 2115583.09769 37.7887304767053 -122.459313330112 (37.7887304767053, -122.459313330112)
37233 37233 105882 Undocumented 2 Ulmus pumila :: Siberian Elm 53 250 Locust St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19     5997612.13513 2115509.12693 37.78864690886571 -122.45210129905001 (37.7886469088657, -122.45210129905)
37355 37355 124688 Undocumented 2 Ulmus pumila :: Siberian Elm 53 460 Arguello Blvd 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 Width 4ft   5995612.537930001 2113341.5687 37.782580632849395 -122.458862568059 (37.7825806328494, -122.458862568059)
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)
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)
38271 38271 215583 Undocumented 2 Ulmus pumila :: Siberian Elm 53 751 Junipero Serra Blvd 12 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     25 Width 3ft   5991379.44831 2092444.8187099998 37.7249594027384 -122.471983541404 (37.7249594027384, -122.471983541404)
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)
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)
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)
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)
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)

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