Street_Tree_List

Data source: data.sfgov.org

314 rows where qSpecies = 86 sorted by qCaretaker

View and edit SQL

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker ▼ qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
85674 113134 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 86 50 03rd St 2 Front Yard : Yard 7 Tree 1 Private 1   09/09/2015 12:00:00 AM   10x10 Permit Number 775860 6011822.9 2114512.2 37.7867133521926 -122.402863731968 (37.7867133521926, -122.402863731968)
86843 109377 Property Tree 7 Populus nigra 'Italica' :: Lombardy Poplar 86 111 BAY ST 4 Back Yard : Yard 13 Tree 1 Private 1           6010193.2 2121519.2 37.8058617340589 -122.40899671325899 (37.8058617340589, -122.408996713259)
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)
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)
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)
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)
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)
96460 109375 Property Tree 7 Populus nigra 'Italica' :: Lombardy Poplar 86 111 BAY ST 2 Back Yard : Yard 13 Tree 1 Private 1           6010193.2 2121519.2 37.8058617340589 -122.40899671325899 (37.8058617340589, -122.408996713259)
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)
101181 117473 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1201x MONTGOMERY ST 1 Unaccepted Street : Cutout 20 Tree 1 Private 1           6011733.0 2119731.0 37.8010379082809 -122.403542078239 (37.8010379082809, -122.403542078239)
101847 117472 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1201x MONTGOMERY ST 2 Unaccepted Street : Cutout 20 Tree 1 Private 1           6011733.0 2119731.0 37.8010379082809 -122.403542078239 (37.8010379082809, -122.403542078239)
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)
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)
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)
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)
112237 109378 Property Tree 7 Populus nigra 'Italica' :: Lombardy Poplar 86 111 BAY ST 5 Back Yard : Yard 13 Tree 1 Private 1           6010193.2 2121519.2 37.8058617340589 -122.40899671325899 (37.8058617340589, -122.408996713259)
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)
118325 109374 Property Tree 7 Populus nigra 'Italica' :: Lombardy Poplar 86 111 BAY ST 1 Back Yard : Yard 13 Tree 1 Private 1           6010193.2 2121519.2 37.8058617340589 -122.40899671325899 (37.8058617340589, -122.408996713259)
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)
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)
127197 249899 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1497 Montgomery St 3 Side Yard : Yard 17 Tree 1 Private 1     17 Width 0ft   6011381.09793 2120471.14228 37.8030504957345 -122.404811954701 (37.8030504957345, -122.404811954701)
127758 109376 Property Tree 7 Populus nigra 'Italica' :: Lombardy Poplar 86 111 BAY ST 3 Back Yard : Yard 13 Tree 1 Private 1           6010193.2 2121519.2 37.8058617340589 -122.40899671325899 (37.8058617340589, -122.408996713259)
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)
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)
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)
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)
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)
133456 234878 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2800 Cesar Chavez St 9 Sidewalk: Property side : Yard 9 Tree 1 Private 1     23     6010615.53478 2100839.3237900003 37.749103267009204 -122.406077336824 (37.7491032670092, -122.406077336824)
134366 135663 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 3790 California St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 3ft   5996346.46825 2114626.15487 37.78614992323771 -122.456416418905 (37.7861499232377, -122.456416418905)
135800 196016 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 212 Terry A Francois Blvd 20 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15     6015678.42156 2110690.23877 37.77643363342779 -122.389257449686 (37.7764336334278, -122.389257449686)
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)
137504 196017 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 212 Terry A Francois Blvd 21 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16     6015653.37625 2110690.3321 37.776432501193 -122.389344095768 (37.776432501193, -122.389344095768)
137968 195965 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 11 Back Yard : Yard 13 Tree 1 Private 1     8     6015497.16873 2100330.63483 37.747978343742794 -122.389160933554 (37.7479783437428, -122.389160933554)
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)
140337 113133 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 86 50 03rd St 1 Front Yard : Yard 7 Tree 1 Private 1   09/09/2015 12:00:00 AM   10x10 Permit Number 775860 6011822.9 2114512.2 37.7867133521926 -122.402863731968 (37.7867133521926, -122.402863731968)
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)
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)
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)
146490 234888 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2827 Cesar Chavez St 2 Front Yard : Yard 7 Tree 1 Private 1     33     6010611.762999999 2100694.95228 37.7487066435094 -122.40608021012699 (37.7487066435094, -122.406080210127)
146994 234890 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2827 Cesar Chavez St 4 Front Yard : Yard 7 Tree 1 Private 1     14     6010623.85334 2100666.44158 37.7486290355994 -122.40603639336099 (37.7486290355994, -122.406036393361)
147141 234872 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2800 Cesar Chavez St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     31     6010732.42318 2100864.09022 37.7491778073048 -122.405674877619 (37.7491778073048, -122.405674877619)
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)
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)
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)
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)
149012 196010 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 212 Terry A Francois Blvd 14 Sidewalk: Property side : Yard 9 Tree 1 Private 1     17     6015807.5178 2110696.90854 37.7764591031505 -122.38881133109 (37.7764591031505, -122.38881133109)
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)
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)
149461 234894 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2827 Cesar Chavez St 12 Front Yard : Yard 7 Tree 1 Private 1     27     6010729.67514 2100698.35511 37.7487225812957 -122.405672708429 (37.7487225812957, -122.405672708429)
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)
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)
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)
154711 249797 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 199 Chestnut St 5 Front Yard : Yard 7 Tree 1 Private 1     13 Width 0ft   6010839.41961 2121064.72571 37.804650038031795 -122.40672831108499 (37.8046500380318, -122.406728311085)
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)
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)
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)
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)
158786 195955 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 1 Back Yard : Yard 13 Tree 1 Private 1     10     6015700.85592 2100342.37267 37.7480218628289 -122.38845740468399 (37.7480218628289, -122.388457404684)
160001 196024 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1670 Owen St 29 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15 Width 8ft   6013848.21751 2107498.5657599997 37.7675683801977 -122.39536504787701 (37.7675683801977, -122.395365047877)
161540 135664 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 3790 California St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 3ft   5996336.60886 2114624.27331 37.786144190959504 -122.45645039347099 (37.7861441909595, -122.456450393471)
161996 196004 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 212 Terry A Francois Blvd 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16     6015940.35109 2110704.12187 37.776486270757204 -122.388352322497 (37.7764862707572, -122.388352322497)
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)
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)
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)
164715 139060 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1455 Lyon St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     39 Width 0ft   5999670.4186 2113895.7324 37.7843346353185 -122.444863945857 (37.7843346353185, -122.444863945857)
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)
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)
166489 195999 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 212 Terry A Francois Blvd 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16     6016051.5903 2110711.60548 37.7765129824099 -122.387968033214 (37.7765129824099, -122.387968033214)
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)
168626 234893 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2827 Cesar Chavez St 7 Front Yard : Yard 7 Tree 1 Private 1     17     6010664.01336 2100659.8191 37.7486130978165 -122.405897053323 (37.7486130978165, -122.405897053323)
168920 196006 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 212 Terry A Francois Blvd 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14     6015895.59891 2110702.13918 37.7764783468376 -122.388506996001 (37.7764783468376, -122.388506996001)
169265 140081 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 104 Saint Joseph's Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 0ft   6000726.183999999 2112472.3974 37.7804867177527 -122.441109224562 (37.7804867177527, -122.441109224562)
169608 234873 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2800 Cesar Chavez St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11     6010726.23893 2100862.83367 37.7491740112676 -122.40569617445699 (37.7491740112676, -122.405696174457)
170865 234887 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2827 Cesar Chavez St 1 Front Yard : Yard 7 Tree 1 Private 1     15     6010600.221609999 2100713.10517 37.7487558418292 -122.40612139908501 (37.7487558418292, -122.406121399085)
171284 249897 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1497 Montgomery St 5 Side Yard : Yard 17 Tree 1 Private 1     20 Width 0ft   6011384.61876 2120458.08201 37.8030148322229 -122.40479885070101 (37.8030148322229, -122.404798850701)
171288 195971 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 17 Back Yard : Yard 13 Tree 1 Private 1     10 Width 4ft   6015377.86647 2100320.4119700002 37.7479436595871 -122.389572765484 (37.7479436595871, -122.389572765484)
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)
172182 234883 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2800 Cesar Chavez St 14 Sidewalk: Property side : Yard 9 Tree 1 Private 1     22     6010542.260840001 2100823.35069 37.7490553097539 -122.406329594845 (37.7490553097539, -122.406329594845)
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)
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)
173216 196023 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 1670 Owen St 28 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12 Width 8ft   6013858.29957 2107482.27299 37.7675242045935 -122.395329033601 (37.7675242045935, -122.395329033601)
173877 195973 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 19 Back Yard : Yard 13 Tree 1 Private 1     10 Width 4ft   6015335.01264 2100318.2949099997 37.747935470342895 -122.38972080559601 (37.7479354703429, -122.389720805596)
175227 140083 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 108 Saint Joseph's Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 Width 0ft   6000722.7998 2112497.1022 37.7805543580623 -122.441122705034 (37.7805543580623, -122.441122705034)
175233 195961 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 7 Back Yard : Yard 13 Tree 1 Private 1     10     6015577.60391 2100335.50195 37.7479961664858 -122.388883129368 (37.7479961664858, -122.388883129368)
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)
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)
176864 135666 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 3001 Divisadero St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     42 Width 9ft   6000472.49775 2118651.8946700003 37.797439556256705 -122.442430617479 (37.7974395562567, -122.442430617479)
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)
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)
177942 196001 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 212 Terry A Francois Blvd 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4     6016008.12939 2110708.52586 37.776502118610395 -122.38811816333401 (37.7765021186104, -122.388118163334)
178922 196011 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 212 Terry A Francois Blvd 15 Sidewalk: Property side : Yard 9 Tree 1 Private 1     16     6015786.39152 2110696.3042599997 37.776456272983204 -122.388884371337 (37.7764562729832, -122.388884371337)
178954 234875 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2800 Cesar Chavez St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12     6010693.4536 2100854.39807 37.7491490155229 -122.405808953037 (37.7491490155229, -122.405808953037)
179584 195959 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 200 Tulare St 5 Back Yard : Yard 13 Tree 1 Private 1     10     6015616.60441 2100338.74984 37.7480072461368 -122.388748492749 (37.7480072461368, -122.388748492749)
180467 246918 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 845 Shrader St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     22 Width 3ft   5997638.105140001 2107510.95773 37.7666875068428 -122.451434340243 (37.7666875068428, -122.451434340243)
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)
180656 247225 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 754 Duboce Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15     6002109.5730099995 2108309.81574 37.7691360073432 -122.43602549030001 (37.7691360073432, -122.4360254903)
180682 234876 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 2800 Cesar Chavez St 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     27     6010649.76891 2100846.09542 37.749123775143204 -122.405959431208 (37.7491237751432, -122.405959431208)
181735 196008 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 212 Terry A Francois Blvd 12 Sidewalk: Property side : Yard 9 Tree 1 Private 1     15     6015854.1615699995 2110700.296 37.7764709894889 -122.388650212137 (37.7764709894889, -122.388650212137)

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