trees

334 rows where qSpecies_id = 59 sorted by qLegalStatus_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

rowid TreeID qLegalStatus_id ▲ qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
26017 109376 Property Tree 8 Populus nigra 'Italica' :: Lombardy Poplar 59 111 BAY ST 3 Back Yard : Yard Tree Private 2           6010193.2 2121519.2 37.8058617340589 -122.408996713259 (37.8058617340589, -122.408996713259) 3 1 10 308 23
64778 109377 Property Tree 8 Populus nigra 'Italica' :: Lombardy Poplar 59 111 BAY ST 4 Back Yard : Yard Tree Private 2           6010193.2 2121519.2 37.8058617340589 -122.408996713259 (37.8058617340589, -122.408996713259) 3 1 10 308 23
84676 109375 Property Tree 8 Populus nigra 'Italica' :: Lombardy Poplar 59 111 BAY ST 2 Back Yard : Yard Tree Private 2           6010193.2 2121519.2 37.8058617340589 -122.408996713259 (37.8058617340589, -122.408996713259) 3 1 10 308 23
99978 234895 Property Tree 8 Populus nigra 'Italica' :: Lombardy Poplar 59 3255x 24th St 6 Side Yard : Cutout Tree Private 2     40 Width 10ft   6007298 2102020 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694) 2 4 7 28859 19
137889 109378 Property Tree 8 Populus nigra 'Italica' :: Lombardy Poplar 59 111 BAY ST 5 Back Yard : Yard Tree Private 2           6010193.2 2121519.2 37.8058617340589 -122.408996713259 (37.8058617340589, -122.408996713259) 3 1 10 308 23
155569 109374 Property Tree 8 Populus nigra 'Italica' :: Lombardy Poplar 59 111 BAY ST 1 Back Yard : Yard Tree Private 2           6010193.2 2121519.2 37.8058617340589 -122.408996713259 (37.8058617340589, -122.408996713259) 3 1 10 308 23
15414 96980 Permitted Site 7 Populus nigra 'Italica' :: Lombardy Poplar 59 2090@Buchanan Vallejo St 3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 25529 6003561 2117963 37.7957235834131 -122.431694388271 (37.7957235834131, -122.431694388271) 13 9 1 57 17
74255 96979 Permitted Site 7 Populus nigra 'Italica' :: Lombardy Poplar 59 2090@Buchanan Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 25529 6003561 2117963 37.7957235834131 -122.431694388271 (37.7957235834131, -122.431694388271) 13 9 1 57 17
86942 103067 Permitted Site 7 Populus nigra 'Italica' :: Lombardy Poplar 59 255 Broadway 6 Sidewalk: Curb side : Cutout Tree Private 2   12/11/2014 12:00:00 AM 3 6x6 Permit Number 769997 6012256.1 2118721.6 37.7982955442476 -122.401660929382 (37.7982955442476, -122.401660929382) 3 1 10 28860 6
93639 91056 Permitted Site 7 Populus nigra 'Italica' :: Lombardy Poplar 59 750 FOLSOM ST 6 Sidewalk: Curb side : Cutout Tree Private 2       6x4   6012569 2113092 37.7828554456154 -122.400182606689 (37.7828554456154, -122.400182606689) 6 2 9 28853 34
123430 96984 Permitted Site 7 Populus nigra 'Italica' :: Lombardy Poplar 59 2090@Buchanan Vallejo St 7 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 25529 6003561 2117963 37.7957235834131 -122.431694388271 (37.7957235834131, -122.431694388271) 13 9 1 57 17
148445 91057 Permitted Site 7 Populus nigra 'Italica' :: Lombardy Poplar 59 750 FOLSOM ST 7 Sidewalk: Curb side : Cutout Tree Private 2     25 6x4   6012569 2113092 37.7828554456154 -122.400182606689 (37.7828554456154, -122.400182606689) 6 2 9 28853 34
171267 96981 Permitted Site 7 Populus nigra 'Italica' :: Lombardy Poplar 59 2090@Buchanan Vallejo St 4 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 25529 6003561 2117963 37.7957235834131 -122.431694388271 (37.7957235834131, -122.431694388271) 13 9 1 57 17
187717 96978 Permitted Site 7 Populus nigra 'Italica' :: Lombardy Poplar 59 2090@Buchanan Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 25529 6003561 2117963 37.7957235834131 -122.431694388271 (37.7957235834131, -122.431694388271) 13 9 1 57 17
1248 260958 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 3790 California St 2 Sidewalk: Property side : Cutout Tree Private 2       Width 3ft   5996359 2114633 37.786169437555 -122.456373557771 (37.786169437555, -122.456373557771) 11 6 1 54 31
4419 260950 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 460x Davis Ct 2 Side Yard : Yard Tree Private 2       3x3   6013239 2118152 37.7967863568579 -122.398219792292 (37.7967863568579, -122.398219792292) 3 1 10 28860 6
13002 260949 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 460x Davis Ct 1 Side Yard : Yard Tree Private 2       3x3   6013239 2118152 37.7967863568579 -122.398219792292 (37.7967863568579, -122.398219792292) 3 1 10 28860 6
17671 260957 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 3790 California St 1 Sidewalk: Property side : Cutout Tree Private 2       Width 3ft   5996359 2114633 37.786169437555 -122.456373557771 (37.786169437555, -122.456373557771) 11 6 1 54 31
67051 113134 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 50 03rd St 2 Front Yard : Yard Tree Private 2   09/09/2015 12:00:00 AM   10x10 Permit Number 775860 6011822.9 2114512.2 37.7867133521926 -122.402863731968 (37.7867133521926, -122.402863731968) 12 2 9 28853 6
73440 116094 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
80147 116095 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
118842 116091 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 1 Sidewalk: Curb side : Cutout Tree Private 2     30 3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
142556 256880 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 2701 Alemany Blvd 1 Side Yard : Yard Tree Private 2       10x10   5997600 2087902 37.7128438731446 -122.450152604107 (37.7128438731446, -122.450152604107) 9 7 6 28861 25
145439 116093 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
154885 116096 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
170444 116097 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
177168 116092 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
184663 113133 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 50 03rd St 1 Front Yard : Yard Tree Private 2   09/09/2015 12:00:00 AM   10x10 Permit Number 775860 6011822.9 2114512.2 37.7867133521926 -122.402863731968 (37.7867133521926, -122.402863731968) 12 2 9 28853 6
1376 263620 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 900 Beach St 3 Side Yard : Yard Tree DPW 1 Rec/Park     3x3   6005896 2121751 37.8062565433008 -122.423884345484 (37.8062565433008, -122.423884345484) 3 1 1 28858 32
10225 263619 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 900 Beach St 2 Side Yard : Yard Tree DPW 1 Rec/Park     3x3   6005896 2121751 37.8062565433008 -122.423884345484 (37.8062565433008, -122.423884345484) 3 1 1 28858 32
10567 263621 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 900 Beach St 4 Side Yard : Yard Tree DPW 1 Rec/Park     3x3   6005896 2121751 37.8062565433008 -122.423884345484 (37.8062565433008, -122.423884345484) 3 1 1 28858 32
11694 263618 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 900 Beach St 1 Side Yard : Yard Tree DPW 1 Rec/Park     3x3   6005896 2121751 37.8062565433008 -122.423884345484 (37.8062565433008, -122.423884345484) 3 1 1 28858 32
24272 117475 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 1200x MONTGOMERY ST 2 Unaccepted Street : Cutout Tree Private 2           6011580 2119440 37.800230345698 -122.404051036068 (37.800230345698, -122.404051036068) 3 1 10 308 23
42959 117474 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 1200x MONTGOMERY ST 1 Unaccepted Street : Cutout Tree Private 2           6011580 2119440 37.800230345698 -122.404051036068 (37.800230345698, -122.404051036068) 3 1 10 308 23
52665 254470 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 1601 Evans Ave 11 Sidewalk: Property side : Yard Tree Private 2       3x3   6015397 2098706 37.7435118805521 -122.389393878977 (37.7435118805521, -122.389393878977) 10 3 8 58 1
55125 98312 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 160 Stanford Heights Ave 1 Sidewalk: Curb side : Yard Tree Private 2           5998064.7 2096544.4 37.7366004632858 -122.449168689734 (37.7366004632858, -122.449168689734) 9 7 4 59 40
95955 117473 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 1201x MONTGOMERY ST 1 Unaccepted Street : Cutout Tree Private 2           6011733 2119731 37.8010379082809 -122.403542078239 (37.8010379082809, -122.403542078239) 3 1 10 308 23
114094 117472 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 1201x MONTGOMERY ST 2 Unaccepted Street : Cutout Tree Private 2           6011733 2119731 37.8010379082809 -122.403542078239 (37.8010379082809, -122.403542078239) 3 1 10 308 23
151245 255455 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 31x Garlington Ct 1 Side Yard : Yard Tree Private 2       3x3   6016454 2094669 37.7324856396877 -122.385457730704 (37.7324856396877, -122.385457730704) 10 3 8 58 1
169477 255308 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 50 Mendell St 1 Front Yard : Yard Tree Private 2   06/05/2018 12:00:00 AM 3 3x3   6017061 2098665 37.7434914187463 -122.383637271506 (37.7434914187463, -122.383637271506) 10 3 8 58 1
127 119777 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 12 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
215 119692 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 4x Octavia St 10 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
248 119766 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 1 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
313 119729 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 104x Octavia St 9 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
413 119686 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 4x Octavia St 4 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
431 119778 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 13 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
1959 19904 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 100 STAIRWAY34 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 6X6                      
3136 234897 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 50 Alemany Blvd 1 Sidewalk: Property side : Yard Tree Private 2     4     6009692.09622 2096449.43711 37.7369979030329 -122.408960917621 (37.7369979030329, -122.408960917621) 10 7 7 28859 2
6092 196018 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 22 Sidewalk: Property side : Yard Tree Private 2     15     6015632.04702 2110689.93838 37.7764302375944 -122.389417852744 (37.7764302375944, -122.389417852744) 14 3 9 310 20
6805 19781 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 100 STAIRWAY19 3 Sidewalk: Curb side : Cutout Tree DPW 1     36 50ST                      
10408 195999 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 3 Sidewalk: Property side : Yard Tree Private 2     16     6016051.5903 2110711.60548 37.7765129824099 -122.387968033214 (37.7765129824099, -122.387968033214) 14 3 9 310 20
12376 119696 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 4x Octavia St 14 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
12447 19841 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 100 STAIRWAY25 25 Sidewalk: Curb side : Cutout Tree DPW 1     12 60X                      
12617 249797 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 199 Chestnut St 5 Front Yard : Yard Tree Private 2     13 Width 0ft   6010839.41961 2121064.72571 37.8046500380318 -122.406728311085 (37.8046500380318, -122.406728311085) 3 1 10 308 23
12956 119689 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 4x Octavia St 7 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
13169 20051 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 100 STAIRWAY52 7 Sidewalk: Curb side : Cutout Tree DPW 1     12 10                      
14005 119780 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 15 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
14173 140080 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 102 Saint Joseph's Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   6000726.8608 2112462.5832 37.7804598090154 -122.441106178881 (37.7804598090154, -122.441106178881) 15 5 1 29490 41
14196 6096 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 106X Saint Joseph's Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6000733.8426241 2112435.5369559 37.7803859446112 -122.44108008458 (37.7803859446112, -122.44108008458) 15 5 1 29490 41
15701 254211 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 300X Esmeralda Ave 3 Unaccepted Street : Yard Tree DPW 1                              
16015 220524 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 110 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/09/1974 12:00:00 AM 38 Width 3ft Permit Number 14125 6003373.13767 2108706.4584 37.7702967937804 -122.431683217203 (37.7702967937804, -122.431683217203) 15 9 11 29492 10
16277 119724 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 104x Octavia St 4 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
16362 119731 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 104x Octavia St 11 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
18074 19903 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 100 STAIRWAY34 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 6X6                      
19126 234903 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 50 Alemany Blvd 7 Sidewalk: Property side : Yard Tree Private 2     18     6009692.65358 2096419.54828 37.7369158659624 -122.408956882348 (37.7369158659624, -122.408956882348) 10 7 7 28859 2
19786 248125 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 109 Brewster St 5 Front Yard : Yard Tree Private 2     7     6010397.04877 2099427.00914 37.7452131370768 -122.406733349058 (37.7452131370768, -122.406733349058) 2 7 7 28859 2
19788 246559 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2x Octavia St 3 Median : Yard Tree DPW 1     6 Width 7ft   6005723.21879 2109372.62983 37.7722588698898 -122.423601653893 (37.7722588698898, -122.423601653893) 7 9 11 28852 10
20810 248173 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 218 Esmeralda Ave 2 Side Yard : Yard Tree Private 2     6     6007303.95131 2098726.55555 37.743116300271 -122.417379150221 (37.743116300271, -122.417379150221) 2 7 7 28859 2
21014 119730 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 104x Octavia St 10 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
21087 234873 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Cesar Chavez St 3 Sidewalk: Property side : Yard Tree Private 2     11     6010726.23893 2100862.83367 37.7491740112676 -122.405696174457 (37.7491740112676, -122.405696174457) 10 4 7 28859 19
21224 196043 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1 Lane St 15 Sidewalk: Property side : Yard Tree Private 2     13 Width 10ft   6017069.89025 2097009.95172 37.7389474821301 -122.383491338448 (37.7389474821301, -122.383491338448) 10 3 8 58 1
21347 201996 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1799 Carroll Ave 4 Sidewalk: Curb side : Yard Tree Private 2     2     6013312.67339 2092499.74696 37.7263550129554 -122.396166145968 (37.7263550129554, -122.396166145968) 10 3 8 58 1
23378 234893 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2827 Cesar Chavez St 7 Front Yard : Yard Tree Private 2     17     6010664.01336 2100659.8191 37.7486130978165 -122.405897053323 (37.7486130978165, -122.405897053323) 2 7 7 28859 2
23490 196012 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 16 Sidewalk: Property side : Yard Tree Private 2     16     6015764.41678 2110694.68671 37.7764506135265 -122.388960275907 (37.7764506135265, -122.388960275907) 14 3 9 310 20
24737 246562 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2x Octavia St 6 Median : Yard Tree DPW 1     16 Width 7ft   6005708.50416 2109443.88838 37.7724536981194 -122.423657620518 (37.7724536981194, -122.423657620518) 7 9 11 28852 10
24893 234872 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Cesar Chavez St 2 Sidewalk: Property side : Yard Tree Private 2     31     6010732.42318 2100864.09022 37.7491778073048 -122.405674877619 (37.7491778073048, -122.405674877619) 10 4 7 28859 19
26372 246564 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2x Octavia St 8 Median : Yard Tree DPW 1     9 Width 7ft   6005706.72335 2109459.01828 37.7724951406584 -122.423664856449 (37.7724951406584, -122.423664856449) 7 9 11 28852 10
27833 249798 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 199 Chestnut St 6 Front Yard : Yard Tree Private 2     14 Width 0ft   6010832.73906 2121063.1197 37.8046452545423 -122.406751316639 (37.8046452545423, -122.406751316639) 3 1 10 308 23
28533 195986 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 401 Amador St 7 Sidewalk: Curb side : Yard Tree Private 2     3     6018468.61509 2099561.76349 37.7460314544851 -122.378832298987 (37.7460314544851, -122.378832298987) 10 3 8 58 1
29793 195970 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 16 Back Yard : Yard Tree Private 2     8     6015399.1088 2100325.42161 37.7479585928282 -122.389499659601 (37.7479585928282, -122.389499659601)   3 8 58 1
30255 196014 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 18 Sidewalk: Property side : Yard Tree Private 2     17     6015720.48392 2110692.27541 37.7764415573597 -122.389112085054 (37.7764415573597, -122.389112085054) 14 3 9 310 20
31585 119691 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 4x Octavia St 9 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
32210 195994 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2101 Newcomb Ave 3 Side Yard : Yard Tree Private 2     20 Width 3ft   6012438.11131 2097750.05558 37.7407225675882 -122.39955794175 (37.7407225675882, -122.39955794175) 10 3 8 58 1
32481 246567 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2x Octavia St 11 Median : Yard Tree DPW 1     10 Width 7ft   6005696.09569 2109523.68249 37.7726720930872 -122.423706217176 (37.7726720930872, -122.423706217176) 7 9 11 28852 10
32582 196000 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 4 Sidewalk: Property side : Yard Tree Private 2     17     6016029.90141 2110710.35403 37.7765083446095 -122.38804297462 (37.7765083446095, -122.38804297462) 14 3 9 310 20
34861 234884 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Cesar Chavez St 15 Sidewalk: Property side : Yard Tree Private 2     20     6010535.25533 2100821.90556 37.7490509498578 -122.406353718268 (37.7490509498578, -122.406353718268) 10 4 7 28859 19
34981 244429 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 102x Octavia St 3 Median : Cutout Tree DPW 1     9 Width 0ft   6005659.2973 2109696.7034 37.7731450894818 -122.4238458121 (37.7731450894818, -122.4238458121) 7 9 11 28852 10
35055 196038 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1 Lane St 7 Sidewalk: Property side : Yard Tree Private 2     15 Width 10ft   6017052.09274 2096987.35134 37.7388844423585 -122.38355130167 (37.7388844423585, -122.38355130167) 10 3 8 58 1
35274 249899 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1497 Montgomery St 3 Side Yard : Yard Tree Private 2     17 Width 0ft   6011381.09793 2120471.14228 37.8030504957345 -122.404811954701 (37.8030504957345, -122.404811954701) 3 1 10 28860 6
35297 248111 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 108 Brewster St 1 Side Yard : Yard Tree Private 2     24     6010383.71107 2099443.85944 37.7452586580609 -122.406780656096 (37.7452586580609, -122.406780656096) 2 7 7 28859 2
35418 119732 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 104x Octavia St 12 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
36058 6095 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 106X Saint Joseph's Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   10/19/2015 12:00:00 AM 12 3X3   6000733.8426241 2112435.5369559 37.7803859446112 -122.44108008458 (37.7803859446112, -122.44108008458) 15 5 1 29490 41
37565 125723 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2     38 Width 4ft   6003539.04242 2117994.60754 37.7958091249389 -122.431772623315 (37.7958091249389, -122.431772623315) 13 9 1 57 17
37570 248117 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 108 Brewster St 7 Side Yard : Yard Tree Private 2     6     6010378.29952 2099414.5285 37.7451778188963 -122.406797301657 (37.7451778188963, -122.406797301657) 2 7 7 28859 2
37731 196046 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1 Lane St 20 Sidewalk: Property side : Yard Tree Private 2     15 Width 10ft   6017076.84536 2097020.98628 37.7389781652152 -122.383468058608 (37.7389781652152, -122.383468058608) 10 3 8 58 1
37957 196010 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 14 Sidewalk: Property side : Yard Tree Private 2     17     6015807.5178 2110696.90854 37.7764591031505 -122.38881133109 (37.7764591031505, -122.38881133109) 14 3 9 310 20
37967 246565 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2x Octavia St 9 Median : Yard Tree DPW 1     11 Width 7ft   6005706.10974 2109468.40026 37.7725208666788 -122.423667646169 (37.7725208666788, -122.423667646169) 7 9 11 28852 10
38227 196030 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2 Lane St 9 Sidewalk: Property side : Yard Tree Private 2     9 Width 10ft   6017023.70578 2097046.84349 37.739046226814 -122.383653592346 (37.739046226814, -122.383653592346) 10 3 8 58 1
39747 196021 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 25 Sidewalk: Property side : Yard Tree Private 2     20     6015567.39764 2110686.7089 37.7764177856004 -122.389641269543 (37.7764177856004, -122.389641269543) 14 3 9 310 20
39892 244430 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 102x Octavia St 4 Median : Cutout Tree DPW 1     7 Width 0ft   6005657.927 2109705.6102 37.7731694680478 -122.423851185605 (37.7731694680478, -122.423851185605) 7 9 11 28852 10

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);