Street_Tree_List

Data source: data.sfgov.org

314 rows where qSpecies = 86 sorted by qLegalStatus

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
4763 220524 Permitted Site 1 Populus nigra 'Italica' :: Lombardy Poplar 86 110 Steiner St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/09/1974 12:00:00 AM 38 Width 3ft Permit Number 14125 6003373.13767 2108706.4584 37.770296793780396 -122.431683217203 (37.7702967937804, -122.431683217203)
51312 96980 Permitted Site 1 Populus nigra 'Italica' :: Lombardy Poplar 86 2090@Buchanan Vallejo St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 25529 6003561.0 2117963.0 37.7957235834131 -122.43169438827101 (37.7957235834131, -122.431694388271)
87484 96979 Permitted Site 1 Populus nigra 'Italica' :: Lombardy Poplar 86 2090@Buchanan Vallejo St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 25529 6003561.0 2117963.0 37.7957235834131 -122.43169438827101 (37.7957235834131, -122.431694388271)
91724 103067 Permitted Site 1 Populus nigra 'Italica' :: Lombardy Poplar 86 255 Broadway 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/11/2014 12:00:00 AM 3 6x6 Permit Number 769997 6012256.1 2118721.6 37.7982955442476 -122.401660929382 (37.7982955442476, -122.401660929382)
95683 91056 Permitted Site 1 Populus nigra 'Italica' :: Lombardy Poplar 86 750 FOLSOM ST 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       6x4   6012569.0 2113092.0 37.7828554456154 -122.400182606689 (37.7828554456154, -122.400182606689)
97405 85294 Permitted Site 1 Populus nigra 'Italica' :: Lombardy Poplar 86 2255 Mariposa St   Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1   07/27/2007 12:00:00 AM   2x50 Permit Number 49675 6010752.0 2105977.0 37.7632178155038 -122.40596731591499 (37.7632178155038, -122.405967315915)
106073 96984 Permitted Site 1 Populus nigra 'Italica' :: Lombardy Poplar 86 2090@Buchanan Vallejo St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 25529 6003561.0 2117963.0 37.7957235834131 -122.43169438827101 (37.7957235834131, -122.431694388271)
110210 91057 Permitted Site 1 Populus nigra 'Italica' :: Lombardy Poplar 86 750 FOLSOM ST 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 6x4   6012569.0 2113092.0 37.7828554456154 -122.400182606689 (37.7828554456154, -122.400182606689)
139286 96978 Permitted Site 1 Populus nigra 'Italica' :: Lombardy Poplar 86 2090@Buchanan Vallejo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 25529 6003561.0 2117963.0 37.7957235834131 -122.43169438827101 (37.7957235834131, -122.431694388271)
141279 96981 Permitted Site 1 Populus nigra 'Italica' :: Lombardy Poplar 86 2090@Buchanan Vallejo St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 25529 6003561.0 2117963.0 37.7957235834131 -122.43169438827101 (37.7957235834131, -122.431694388271)
177775 53540 Permitted Site 1 Populus nigra 'Italica' :: Lombardy Poplar 86 308 04th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/05/1969 12:00:00 AM 24   Permit Number 6452 5994656.440219999 2113376.70713 37.782622110333904 -122.462172779062 (37.7826221103339, -122.462172779062)
495 248613 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 845 Shrader St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     28 Width 0ft   5997648.1233 2107524.615 37.766725579885 -122.451400674442 (37.766725579885, -122.451400674442)
3855 248614 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 845 Shrader St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     19 Width 0ft   5997650.5459 2107506.4452 37.7666758289672 -122.451390984496 (37.7666758289672, -122.451390984496)
3856 246917 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 845 Shrader St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17 Width 3ft   5997637.485090001 2107521.28402 37.766715824697 -122.451437229753 (37.766715824697, -122.451437229753)
23421 195972 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 18 Back Yard : Yard 13 Tree 1 Private 1     10 Width 4ft   6015355.8319 2100319.8042599997 37.7479407691514 -122.389648918288 (37.7479407691514, -122.389648918288)
23464 121867 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 382 18th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5990303.78145 2112825.7530799997 37.7808577673116 -122.477190674715 (37.7808577673116, -122.477190674715)
24124 234881 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2800 Cesar Chavez St 12 Sidewalk: Property side : Yard 9 Tree 1 Private 1     29     6010567.07854 2100828.40228 37.749070568567 -122.40624413046899 (37.749070568567, -122.406244130469)
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)
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)
25030 196022 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 212 Terry A Francois Blvd 26 Sidewalk: Property side : Yard 9 Tree 1 Private 1     21     6015549.75144 2110684.1794 37.7764098616684 -122.389702136539 (37.7764098616684, -122.389702136539)
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)
26205 195969 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 15 Back Yard : Yard 13 Tree 1 Private 1     8     6015417.97335 2100326.09336 37.7479614832509 -122.389434473133 (37.7479614832509, -122.389434473133)
26304 140079 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 100 Saint Joseph's Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 0ft   6000729.2298 2112451.4153 37.780429279749605 -122.44109718195499 (37.7804292797496, -122.441097181955)
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)
28429 234882 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2800 Cesar Chavez St 13 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14     6010551.469930001 2100825.34606 37.7490613037485 -122.406297890147 (37.7490613037485, -122.406297890147)
28993 196012 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 212 Terry A Francois Blvd 16 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16     6015764.416780001 2110694.68671 37.7764506135265 -122.388960275907 (37.7764506135265, -122.388960275907)
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)
29497 135665 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 3790 California St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16 Width 3ft   5996326.409519999 2114621.95963 37.7861372526689 -122.45648551290199 (37.7861372526689, -122.456485512902)
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)
31601 195958 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 4 Back Yard : Yard 13 Tree 1 Private 1     10     6015649.240619999 2100340.8983400003 37.7480149542299 -122.388635787013 (37.7480149542299, -122.388635787013)
31815 196007 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 212 Terry A Francois Blvd 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15     6015874.48096 2110701.94702 37.7764766489106 -122.388580036236 (37.7764766489106, -122.388580036236)
32073 234877 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2800 Cesar Chavez St 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     38     6010643.54009 2100844.31084 37.7491185267072 -122.405980844948 (37.7491185267072, -122.405980844948)
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)
33120 249800 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 199 Chestnut St 8 Front Yard : Yard 7 Tree 1 Private 1     16 Width 0ft   6010811.58408 2121055.18857 37.8046222939481 -122.406823966551 (37.8046222939481, -122.406823966551)
33201 195967 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 13 Back Yard : Yard 13 Tree 1 Private 1     5     6015456.783980001 2100328.64296 37.747970635647 -122.389300444473 (37.747970635647, -122.389300444473)
33236 195970 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 16 Back Yard : Yard 13 Tree 1 Private 1     8     6015399.1088 2100325.42161 37.747958592828205 -122.389499659601 (37.7479585928282, -122.389499659601)
33398 196014 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 212 Terry A Francois Blvd 18 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17     6015720.48392 2110692.27541 37.7764415573597 -122.389112085054 (37.7764415573597, -122.389112085054)
33977 249894 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 230 Greenwich St 30 Back Yard : Yard 13 Tree 1 Private 1     24 Width 0ft   6011403.76038 2120447.63681 37.802987222140395 -122.40473187458599 (37.8029872221404, -122.404731874586)
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)
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)
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)
38334 195966 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 12 Back Yard : Yard 13 Tree 1 Private 1     6     6015475.98989 2100328.78152 37.7479720808553 -122.389234040342 (37.7479720808553, -122.389234040342)
38396 195968 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 14 Back Yard : Yard 13 Tree 1 Private 1     7     6015437.03514 2100327.8138099997 37.747967264084295 -122.389368677829 (37.7479672640843, -122.389368677829)
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)
38753 234884 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2800 Cesar Chavez St 15 Sidewalk: Property side : Yard 9 Tree 1 Private 1     20     6010535.25533 2100821.90556 37.749050949857796 -122.406353718268 (37.7490509498578, -122.406353718268)
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)
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)
41087 196003 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 212 Terry A Francois Blvd 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16     6015962.95079 2110705.93329 37.776492496775106 -122.388274269443 (37.7764924967751, -122.388274269443)
41709 234885 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2800 Cesar Chavez St 16 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7     6010529.65259 2100820.82881 37.7490476799194 -122.406373016826 (37.7490476799194, -122.406373016826)
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)
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)
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)
45266 196009 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 212 Terry A Francois Blvd 13 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16     6015830.73834 2110698.70731 37.776465329147 -122.388731129538 (37.776465329147, -122.388731129538)
46092 195960 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 6 Back Yard : Yard 13 Tree 1 Private 1     8     6015597.7328 2100337.72732 37.748003392560896 -122.38881367921302 (37.7480033925609, -122.388813679213)
46532 196000 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 212 Terry A Francois Blvd 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17     6016029.9014099995 2110710.35403 37.776508344609496 -122.38804297461999 (37.7765083446095, -122.38804297462)
46578 234892 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2827 Cesar Chavez St 6 Front Yard : Yard 7 Tree 1 Private 1     18     6010653.55518 2100656.49907 37.7486033968442 -122.40593298392 (37.7486033968442, -122.40593298392)
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)
46771 140080 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 102 Saint Joseph's Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     17 Width 0ft   6000726.8608 2112462.5832 37.7804598090154 -122.441106178881 (37.7804598090154, -122.441106178881)
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)
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)
47853 196002 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 212 Terry A Francois Blvd 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18     6015985.51722 2110706.0962799997 37.7764941946745 -122.38819621639799 (37.7764941946745, -122.388196216398)
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)
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)
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)
50221 234891 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2827 Cesar Chavez St 5 Front Yard : Yard 7 Tree 1 Private 1     12     6010619.31212 2100642.55964 37.748563207025704 -122.406050414705 (37.7485632070257, -122.406050414705)
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)
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)
51715 234880 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2800 Cesar Chavez St 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     24     6010577.49101 2100830.77043 37.7490776534227 -122.40620829069799 (37.7490776534227, -122.406208290698)
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)
52998 195998 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 212 Terry A Francois Blvd 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18     6016075.490669999 2110714.30849 37.776521728336604 -122.387885542896 (37.7765217283366, -122.387885542896)
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)
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)
55335 234886 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2800 Cesar Chavez St 17 Sidewalk: Property side : Yard 9 Tree 1 Private 1     28     6010522.647340001 2100819.38367 37.7490433200014 -122.40639713934401 (37.7490433200014, -122.406397139344)
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)
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)
59758 234871 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2800 Cesar Chavez St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17     6010740.989580001 2100867.24575 37.7491869507297 -122.405645476962 (37.7491869507297, -122.405645476962)
60534 196005 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 212 Terry A Francois Blvd 9 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15     6015919.22066 2110703.31156 37.7764828749315 -122.38842536276 (37.7764828749315, -122.38842536276)
60765 195957 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 3 Back Yard : Yard 13 Tree 1 Private 1     12     6015667.37966 2100340.53223 37.7480149542209 -122.38857303683399 (37.7480149542209, -122.388573036834)
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)
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)
61728 249895 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 230 Greenwich St 31 Back Yard : Yard 13 Tree 1 Private 1     18 Width 0ft   6011395.76102 2120447.38073 37.8029860719045 -122.404759538639 (37.8029860719045, -122.404759538639)
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)
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)
62177 195962 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 8 Back Yard : Yard 13 Tree 1 Private 1     9     6015556.6084199995 2100333.99599 37.7479908676843 -122.388955626422 (37.7479908676843, -122.388955626422)
63128 196020 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 212 Terry A Francois Blvd 24 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18     6015589.15281 2110687.71234 37.7764217471115 -122.38956608171999 (37.7764217471115, -122.38956608172)
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)
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)
65833 249798 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 199 Chestnut St 6 Front Yard : Yard 7 Tree 1 Private 1     14 Width 0ft   6010832.73906 2121063.1197 37.8046452545423 -122.406751316639 (37.8046452545423, -122.406751316639)
65985 195964 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 10 Back Yard : Yard 13 Tree 1 Private 1     8     6015516.57214 2100331.8217700003 37.7479826784534 -122.38909391965001 (37.7479826784534, -122.38909391965)
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)
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)
69678 195997 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 212 Terry A Francois Blvd 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     23     6016094.12732 2110713.51522 37.776520582607 -122.387821017432 (37.776520582607, -122.387821017432)
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)
69986 196013 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 212 Terry A Francois Blvd 17 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17     6015743.28218 2110693.6702799997 37.7764466511333 -122.38903331613899 (37.7764466511333, -122.389033316139)
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)
71617 196015 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 212 Terry A Francois Blvd 19 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17     6015698.09519 2110690.66596 37.77643589704721 -122.38918942227899 (37.7764358970472, -122.389189422279)
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)
72921 234889 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2827 Cesar Chavez St 3 Front Yard : Yard 7 Tree 1 Private 1     25     6010620.28496 2100677.87035 37.7486602169168 -122.406049537871 (37.7486602169168, -122.406049537871)
73079 196019 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 212 Terry A Francois Blvd 23 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17     6015611.09455 2110687.68162 37.776422879345496 -122.389490176245 (37.7764228793455, -122.389490176245)
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)

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