Street_Tree_List

Data source: data.sfgov.org

314 rows where qSpecies = 86 sorted by Location

View and edit SQL

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

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location ▼
5897 19904 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 100 STAIRWAY34 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 6X6            
6788 19903 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 100 STAIRWAY34 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 6X6            
7574 19781 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 100 STAIRWAY19 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     36 50ST            
13863 19841 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 100 STAIRWAY25 25 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 60X            
16741 20051 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 100 STAIRWAY52 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 10            
123249 24282 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 300X Winding Way 20 Median : Cutout 11 Tree 1 DPW 2     3 8   6001646.2933309 2086550.8578367 37.7093646550959 -122.436070699117 (37.7093646550959, -122.436070699117)
89334 116094 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 86 300x EXECUTIVE PARK BLVD 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6014482.0 2086919.0 37.7110963749119 -122.39173377323799 (37.7110963749119, -122.391733773238)
92450 116095 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 86 300x EXECUTIVE PARK BLVD 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6014482.0 2086919.0 37.7110963749119 -122.39173377323799 (37.7110963749119, -122.391733773238)
106195 116091 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 86 300x EXECUTIVE PARK BLVD 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     30 3x3   6014482.0 2086919.0 37.7110963749119 -122.39173377323799 (37.7110963749119, -122.391733773238)
114742 116093 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 86 300x EXECUTIVE PARK BLVD 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6014482.0 2086919.0 37.7110963749119 -122.39173377323799 (37.7110963749119, -122.391733773238)
118020 116097 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 86 300x EXECUTIVE PARK BLVD 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6014482.0 2086919.0 37.7110963749119 -122.39173377323799 (37.7110963749119, -122.391733773238)
119705 116096 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 86 300x EXECUTIVE PARK BLVD 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6014482.0 2086919.0 37.7110963749119 -122.39173377323799 (37.7110963749119, -122.391733773238)
144536 116092 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 86 300x EXECUTIVE PARK BLVD 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6014482.0 2086919.0 37.7110963749119 -122.39173377323799 (37.7110963749119, -122.391733773238)
164241 201993 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1799 Carroll Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     6013314.351009999 2092488.44605 37.726324076294205 -122.396159554816 (37.7263240762942, -122.396159554816)
132662 201996 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1799 Carroll Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     6013312.67339 2092499.74696 37.7263550129554 -122.396166145968 (37.7263550129554, -122.396166145968)
51068 201994 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1799 Carroll Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     6013316.6056 2092506.69666 37.7263743142142 -122.396153039251 (37.7263743142142, -122.396153039251)
137250 201997 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1799 Carroll Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     6013313.68951 2092516.98736 37.7264024081338 -122.39616384100201 (37.7264024081338, -122.396163841002)
157844 201995 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1799 Carroll Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     6013319.20907 2092521.7003099998 37.726415656052104 -122.396145090149 (37.7264156560521, -122.396145090149)
49096 212850 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 32 Malta Dr 32 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     32 Width 3ft   5999489.821880001 2096117.1264 37.7355086796695 -122.444210754429 (37.7355086796695, -122.444210754429)
78277 98312 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 160 Stanford Heights Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1           5998064.7 2096544.4 37.7366004632858 -122.449168689734 (37.7366004632858, -122.449168689734)
47717 234909 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 50 Alemany Blvd 13 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17 Width 10ft   6009677.77783 2096362.7223200002 37.73675900081071 -122.409004306302 (37.7367590008107, -122.409004306302)
172242 234908 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 50 Alemany Blvd 12 Sidewalk: Property side : Yard 9 Tree 1 Private 1     20 Width 10ft   6009679.550530001 2096368.23252 37.73677422993671 -122.408998565949 (37.7367742299367, -122.408998565949)
176193 234907 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 50 Alemany Blvd 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18 Width 8ft   6009682.36778 2096375.42259 37.7367941301369 -122.40898933260401 (37.7367941301369, -122.408989332604)
72864 234906 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 50 Alemany Blvd 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17 Width 8ft   6009686.024230001 2096384.83518 37.7368201799074 -122.408977354526 (37.7368201799074, -122.408977354526)
156252 234905 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 50 Alemany Blvd 9 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18 Width 8ft   6009688.58582 2096390.10165 37.736834783993004 -122.40896886942 (37.736834783993, -122.40896886942)
180616 234904 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 50 Alemany Blvd 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15     6009689.76503 2096405.45865 37.73687701706479 -122.408965875569 (37.7368770170648, -122.408965875569)
52696 234902 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 50 Alemany Blvd 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6     6009698.6344099995 2096418.94153 37.7369145349811 -122.40893616107799 (37.7369145349811, -122.408936161078)
184850 234903 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 50 Alemany Blvd 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18     6009692.653580001 2096419.54828 37.7369158659624 -122.40895688234801 (37.7369158659624, -122.408956882348)
68610 234900 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 50 Alemany Blvd 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17     6009696.65795 2096435.2295400002 37.7369591476365 -122.40894414348 (37.7369591476365, -122.40894414348)
73733 234901 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 50 Alemany Blvd 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12     6009690.97834 2096436.6273599998 37.7369626675976 -122.408963879105 (37.7369626675976, -122.408963879105)
186239 234899 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 50 Alemany Blvd 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     24     6009698.94501 2096439.52165 37.7369710609585 -122.408936538802 (37.7369710609585, -122.408936538802)
173066 234898 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 50 Alemany Blvd 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     24     6009700.61042 2096445.6891 37.736988088737704 -122.40893121572901 (37.7369880887377, -122.408931215729)
175927 234897 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 50 Alemany Blvd 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4     6009692.09622 2096449.4371099998 37.7369979030329 -122.408960917621 (37.7369979030329, -122.408960917621)
74651 196034 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     19 Width 10ft   6017038.2356199995 2096967.92235 37.738830328350794 -122.38359786136002 (37.7388303283508, -122.38359786136)
35215 196035 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18 Width 10ft   6017042.43736 2096973.9330400003 37.7388470647366 -122.38358375190501 (37.7388470647366, -122.383583751905)
55642 196036 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17 Width 10ft   6017046.41048 2096978.7292799999 37.738860453849 -122.383570348389 (37.738860453849, -122.383570348389)
162017 196037 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 10ft   6017049.14343 2096982.7375599998 37.7388716108342 -122.383561177999 (37.7388716108342, -122.383561177999)
166201 196038 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 10ft   6017052.09274 2096987.35134 37.7388844423585 -122.38355130167 (37.7388844423585, -122.38355130167)
168448 196039 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 9 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17 Width 10ft   6017058.78761 2096996.2330599998 37.7389091998064 -122.38352877183998 (37.7389091998064, -122.38352877184)
149400 196040 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 10ft   6017061.14337 2096999.0636099998 37.738917102131204 -122.383520823632 (37.7389171021312, -122.383520823632)
38488 196041 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 13 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 10ft   6017065.52556 2097005.9762799998 37.738936325136706 -122.383506153 (37.7389363251367, -122.383506153)
150116 196042 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 14 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 10ft   6017068.02223 2097008.3641400002 37.7389430197102 -122.383497686772 (37.7389430197102, -122.383497686772)
152860 196043 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 15 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 10ft   6017069.89025 2097009.95172 37.7389474821301 -122.38349133844801 (37.7389474821301, -122.383491338448)
148840 196044 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 18 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 10ft   6017074.4672 2097014.32935 37.7389597551859 -122.38347581797701 (37.7389597551859, -122.383475817977)
53814 196045 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 19 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 10ft   6017076.588380001 2097018.35028 37.7389709130863 -122.383468763681 (37.7389709130863, -122.383468763681)
65477 196046 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 20 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 10ft   6017076.84536 2097020.9862799998 37.7389781652152 -122.383468058608 (37.7389781652152, -122.383468058608)
73353 196047 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 23 Sidewalk: Property side : Yard 9 Tree 1 Private 1     21 Width 10ft   6017083.0987599995 2097027.5652 37.7389965752218 -122.383446894874 (37.7389965752218, -122.383446894874)
69044 196048 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 25 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 10ft   6017086.8639400005 2097032.1625700002 37.7390094067689 -122.383434196434 (37.7390094067689, -122.383434196434)
62070 196033 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2 Lane St 13 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 10ft   6017016.3348 2097035.41086 37.7390144276853 -122.38367828232501 (37.7390144276853, -122.383678282325)
187036 196032 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2 Lane St 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 10ft   6017018.892530001 2097040.8451099999 37.7390294904202 -122.383669817022 (37.7390294904202, -122.383669817022)
61094 196049 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1 Lane St 26 Sidewalk: Property side : Yard 9 Tree 1 Private 1     35 Width 10ft   6017090.910619999 2097040.61449 37.7390328376916 -122.38342079293501 (37.7390328376916, -122.383420792935)
24182 196031 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2 Lane St 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 10ft   6017021.60504 2097043.8381400001 37.7390378586108 -122.383660646635 (37.7390378586108, -122.383660646635)
155952 196030 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2 Lane St 9 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 10ft   6017023.70578 2097046.84349 37.739046226814 -122.38365359234601 (37.739046226814, -122.383653592346)
48598 196029 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2 Lane St 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 10ft   6017027.27121 2097051.6476 37.7390596150087 -122.383641598974 (37.7390596150087, -122.383641598974)
147185 196028 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2 Lane St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 10ft   6017030.6363699995 2097056.65947 37.7390735625998 -122.383630312507 (37.7390735625998, -122.383630312507)
65821 196027 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2 Lane St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 10ft   6017034.20589 2097061.6668900002 37.739087509266604 -122.383618319135 (37.7390875092666, -122.383618319135)
146435 196026 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2 Lane St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     20 Width 10ft   6017039.21913 2097067.45785 37.7391036871735 -122.383601388517 (37.7391036871735, -122.383601388517)
102782 196025 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2 Lane St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     20 Width 10ft   6017042.181609999 2097072.1185299999 37.7391166482065 -122.38359146989201 (37.7391166482065, -122.383591469892)
165153 195980 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 900 Phelps St 2 Side Yard : Yard 17 Tree 1 Private 1     24     6014694.29284 2097256.8818599996 37.7394939174204 -122.39172238440399 (37.7394939174204, -122.391722384404)
162455 195979 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 900 Phelps St 1 Side Yard : Yard 17 Tree 1 Private 1     30 Width 9ft   6014704.25324 2097268.53042 37.739526454869704 -122.39168875963999 (37.7395264548697, -122.39168875964)
39702 195996 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2101 Newcomb Ave 5 Side Yard : Yard 17 Tree 1 Private 1     14 Width 3ft   6012499.275719999 2097703.95349 37.7405993901482 -122.39934322143101 (37.7405993901482, -122.399343221431)
156951 195995 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2101 Newcomb Ave 4 Side Yard : Yard 17 Tree 1 Private 1     23 Width 3ft   6012483.54441 2097715.89022 37.7406312890986 -122.399398452383 (37.7406312890986, -122.399398452383)
183132 195994 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2101 Newcomb Ave 3 Side Yard : Yard 17 Tree 1 Private 1     20 Width 3ft   6012438.11131 2097750.05558 37.74072256758821 -122.39955794174999 (37.7407225675882, -122.39955794175)
154008 195993 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2101 Newcomb Ave 2 Side Yard : Yard 17 Tree 1 Private 1     23 Width 3ft   6012429.27896 2097757.0265 37.7407412159349 -122.399588970171 (37.7407412159349, -122.399588970171)
44122 212849 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1201 Ulloa St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   5992374.69215 2098410.70315 37.7413977704887 -122.468977090726 (37.7413977704887, -122.468977090726)
56013 248173 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 218 Esmeralda Ave 2 Side Yard : Yard 17 Tree 1 Private 1     6     6007303.951309999 2098726.55555 37.743116300271 -122.41737915022101 (37.743116300271, -122.417379150221)
41744 248172 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 218 Esmeralda Ave 1 Side Yard : Yard 17 Tree 1 Private 1     12     6007302.01446 2098729.32454 37.74312379432521 -122.41738604353701 (37.7431237943252, -122.417386043537)
154282 248120 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 108 Brewster St 10 Side Yard : Yard 17 Tree 1 Private 1     12     6010373.21137 2099395.33781 37.745124840742 -122.40681354343701 (37.745124840742, -122.406813543437)
30434 248121 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 109 Brewster St 1 Front Yard : Yard 7 Tree 1 Private 1     11     6010387.395819999 2099398.52057 37.7451343735684 -122.40676472010901 (37.7451343735684, -122.406764720109)
24297 248119 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 108 Brewster St 9 Side Yard : Yard 17 Tree 1 Private 1     18     6010375.35501 2099399.67941 37.7451368817742 -122.40680643699301 (37.7451368817742, -122.406806436993)
54920 248118 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 108 Brewster St 8 Side Yard : Yard 17 Tree 1 Private 1     6     6010376.970919999 2099406.95495 37.7451569492381 -122.40680136209 (37.7451569492381, -122.40680136209)
182677 248122 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 109 Brewster St 2 Front Yard : Yard 7 Tree 1 Private 1     14     6010390.78091 2099407.55033 37.7451593567256 -122.406753651253 (37.7451593567256, -122.406753651253)
129839 248123 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 109 Brewster St 3 Front Yard : Yard 7 Tree 1 Private 1     13     6010392.06783 2099413.0786599996 37.7451746083214 -122.40674959081899 (37.7451746083214, -122.406749590819)
148699 248117 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 108 Brewster St 7 Side Yard : Yard 17 Tree 1 Private 1     6     6010378.29952 2099414.5285 37.7451778188963 -122.40679730165701 (37.7451778188963, -122.406797301657)
38800 248116 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 108 Brewster St 6 Side Yard : Yard 17 Tree 1 Private 1     9     6010379.57479 2099419.47211 37.745191464327995 -122.406793240314 (37.745191464328, -122.406793240314)
51090 248124 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 109 Brewster St 4 Front Yard : Yard 7 Tree 1 Private 1     10     6010394.26479 2099420.04988 37.7451938726969 -122.406742485274 (37.7451938726969, -122.406742485274)
32347 248125 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 109 Brewster St 5 Front Yard : Yard 7 Tree 1 Private 1     7     6010397.048769999 2099427.00914 37.745213137076796 -122.406733349058 (37.7452131370768, -122.406733349058)
36690 248115 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 108 Brewster St 5 Side Yard : Yard 17 Tree 1 Private 1     7     6010382.6698900005 2099427.30215 37.7452131370921 -122.406783089664 (37.7452131370921, -122.406783089664)
35883 248126 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 109 Brewster St 6 Front Yard : Yard 7 Tree 1 Private 1     6     6010387.789530001 2099433.6295 37.7452307970734 -122.40676583257401 (37.7452307970734, -122.406765832574)
46620 248114 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 108 Brewster St 4 Side Yard : Yard 17 Tree 1 Private 1     15     6010381.0463 2099434.05906 37.7452315992509 -122.406789179902 (37.7452315992509, -122.406789179902)
185609 248127 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 109 Brewster St 7 Front Yard : Yard 7 Tree 1 Private 1     18     6010399.6226 2099438.06548 37.7452436393873 -122.40672522818701 (37.7452436393873, -122.406725228187)
130896 248113 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 108 Brewster St 3 Side Yard : Yard 17 Tree 1 Private 1     17     6010385.30327 2099441.28079 37.745251666737296 -122.40677496881099 (37.7452516667373, -122.406774968811)
70123 248111 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 108 Brewster St 1 Side Yard : Yard 17 Tree 1 Private 1     24     6010383.711069999 2099443.8594400003 37.7452586580609 -122.406780656096 (37.7452586580609, -122.406780656096)
130066 195985 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 401 Amador St 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     6018474.359130001 2099556.32192 37.74601682971289 -122.378812058831 (37.7460168297129, -122.378812058831)
26910 195984 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 401 Amador St 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     6018485.16554 2099556.70792 37.7460184853642 -122.378774718093 (37.7460184853642, -122.378774718093)
187127 195982 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 401 Amador St 11 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10     6018502.102580001 2099556.87815 37.746019886521296 -122.378716163238 (37.7460198865213, -122.378716163238)
25205 195981 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 401 Amador St 12 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7     6018524.13374 2099557.3325900002 37.746022348857295 -122.37864001312799 (37.7460223488573, -122.378640013128)
46984 195986 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 401 Amador St 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3     6018468.61509 2099561.7634900003 37.7460314544851 -122.378832298987 (37.7460314544851, -122.378832298987)
120047 195988 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 401 Amador St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3     6018362.603680001 2099564.59582 37.7460333862374 -122.379199073078 (37.7460333862374, -122.379199073078)
61850 195989 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 401 Amador St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3     6018358.23149 2099573.02507 37.7460562901585 -122.37921477706699 (37.7460562901585, -122.379214777067)
149276 195992 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 401 Amador St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     6018320.61791 2099573.80473 37.7460563567193 -122.379344895446 (37.7460563567193, -122.379344895446)
69871 195990 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 401 Amador St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4     6018348.89198 2099575.3229 37.746062084515295 -122.379247231793 (37.7460620845153, -122.379247231793)
177923 195991 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 401 Amador St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5     6018339.20952 2099575.6179 37.7460623605839 -122.379280733321 (37.7460623605839, -122.379280733321)
29206 195983 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 401 Amador St 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4     6018491.3513 2099573.26629 37.7460642923356 -122.378754477939 (37.7460642923356, -122.378754477939)
130871 195987 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 401 Amador St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6     6018466.53487 2099573.76457 37.7460642923433 -122.378840325441 (37.7460642923433, -122.378840325441)
49446 195978 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 24 Back Yard : Yard 13 Tree 1 Private 1     9 Width 4ft   6015236.23042 2100312.22008 37.747913311958605 -122.390061968785 (37.7479133119586, -122.390061968785)
42525 195977 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 23 Back Yard : Yard 13 Tree 1 Private 1     5 Width 4ft   6015256.877230001 2100313.90806 37.7479190918917 -122.389990690329 (37.7479190918917, -122.389990690329)
147625 195976 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 22 Back Yard : Yard 13 Tree 1 Private 1     5 Width 4ft   6015275.57642 2100315.1093900003 37.7479234275315 -122.38992611271401 (37.7479234275315, -122.389926112714)
61234 195975 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 21 Back Yard : Yard 13 Tree 1 Private 1     9 Width 4ft   6015294.9834 2100316.47199 37.747928245201 -122.389859098828 (37.747928245201, -122.389859098828)
171805 195974 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 20 Back Yard : Yard 13 Tree 1 Private 1     12 Width 4ft   6015315.44713 2100317.81293 37.7479330619596 -122.389788429193 (37.7479330619596, -122.389788429193)

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