trees

334 rows where qSpecies_id = 59 sorted by PlotSize 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)
101044 244406 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 202x Octavia St 12 Median : Cutout Tree DPW 1     12 Width 0ft   6005586.7565 2110217.4543 37.7745708501281 -122.424133781799 (37.7745708501281, -122.424133781799) 7 9 11 28852 10
102733 248614 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 845 Shrader St 3 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 0ft   5997650.5459 2107506.4452 37.7666758289672 -122.451390984496 (37.7666758289672, -122.451390984496) 15 5 11 29492 9
112727 244265 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 202x Octavia St 6 Median : Cutout Tree DPW 1     9 Width 0ft   6005602.0322 2110112.8157 37.7742844003359 -122.42407349717 (37.7742844003359, -122.42407349717) 7 9 11 28852 10
116865 244408 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 202x Octavia St 14 Median : Cutout Tree DPW 1     10 Width 0ft   6005581.41 2110245.7143 37.7746481433715 -122.424154286626 (37.7746481433715, -122.424154286626) 7 9 11 28852 10
117263 244433 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 102x Octavia St 7 Median : Cutout Tree DPW 1     8 Width 0ft   6005647.6499 2109776.1795 37.7733626541324 -122.423891754495 (37.7733626541324, -122.423891754495) 7 9 11 28852 10
121894 244337 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 102x Octavia St 14 Median : Cutout Tree DPW 1     12 Width 0ft   6005627.7809 2109896.0788 37.7736907469384 -122.423969012041 (37.7736907469384, -122.423969012041) 7 9 11 28852 10
122485 244334 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 102x Octavia St 11 Median : Cutout Tree DPW 1     13 Width 0ft   6005631.2066 2109866.6178 37.7736100475528 -122.423955066597 (37.7736100475528, -122.423955066597) 7 9 11 28852 10
124424 244402 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 202x Octavia St 8 Median : Cutout Tree DPW 1     5 Width 0ft   6005599.7408 2110138.7844 37.7743555747298 -122.424083270702 (37.7743555747298, -122.424083270702) 7 9 11 28852 10
125575 244428 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 102x Octavia St 2 Median : Cutout Tree DPW 1     6 Width 0ft   6005659.9824 2109685.0561 37.7731131474821 -122.423842613892 (37.7731131474821, -122.423842613892) 7 9 11 28852 10
126030 140081 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 104 Saint Joseph's Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 0ft   6000726.184 2112472.3974 37.7804867177527 -122.441109224562 (37.7804867177527, -122.441109224562) 15 5 1 29490 41
127892 244264 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 202x Octavia St 5 Median : Cutout Tree DPW 1     6 Width 0ft   6005607.3787 2110087.6108 37.7742154956389 -122.424053209833 (37.7742154956389, -122.424053209833) 7 9 11 28852 10
131182 244434 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 102x Octavia St 8 Median : Cutout Tree DPW 1     10 Width 0ft   6005644.2243 2109791.2526 37.7734038478353 -122.423904676174 (37.7734038478353, -122.423904676174) 7 9 11 28852 10
136053 244405 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 202x Octavia St 11 Median : Cutout Tree DPW 1     10 Width 0ft   6005589.0478 2110200.651 37.7745248417047 -122.424124660487 (37.7745248417047, -122.424124660487) 7 9 11 28852 10
142161 249896 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 230 Greenwich St 32 Back Yard : Yard Tree Private 2     24 Width 0ft   6011386.30387 2120437.51769 37.8029584618196 -122.404791570676 (37.8029584618196, -122.404791570676) 3 1 10 28860 6
147228 244262 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 202x Octavia St 3 Median : Cutout Tree DPW 1     5 Width 0ft   6005612.7252 2110055.5318 37.7741277163216 -122.424032433594 (37.7741277163216, -122.424032433594) 7 9 11 28852 10
148940 244260 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 202x Octavia St 1 Median : Cutout Tree DPW 1     7 Width 0ft   6005614.2528 2110021.9252 37.7740355269714 -122.424024758994 (37.7740355269714, -122.424024758994) 7 9 11 28852 10
150059 249897 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1497 Montgomery St 5 Side Yard : Yard Tree Private 2     20 Width 0ft   6011384.61876 2120458.08201 37.8030148322229 -122.404798850701 (37.8030148322229, -122.404798850701) 3 1 10 28860 6
150696 244432 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 102x Octavia St 6 Median : Cutout Tree DPW 1     11 Width 0ft   6005649.0202 2109761.1065 37.7733213446724 -122.423885942412 (37.7733213446724, -122.423885942412) 7 9 11 28852 10
152832 140079 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 100 Saint Joseph's Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6000729.2298 2112451.4153 37.7804292797496 -122.441097181955 (37.7804292797496, -122.441097181955) 15 5 1 29490 41
153224 244332 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 102x Octavia St 9 Median : Cutout Tree DPW 1     8 Width 0ft   6005642.1688 2109804.2702 37.7734394749788 -122.423912712296 (37.7734394749788, -122.423912712296) 7 9 11 28852 10
154261 140083 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 108 Saint Joseph's Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     24 Width 0ft   6000722.7998 2112497.1022 37.7805543580623 -122.441122705034 (37.7805543580623, -122.441122705034) 15 5 1 29490 41
168738 244338 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 102x Octavia St 15 Median : Cutout Tree DPW 1     11 Width 0ft   6005626.4106 2109908.4113 37.7737245316409 -122.42397462928 (37.7737245316409, -122.42397462928) 7 9 11 28852 10
178442 244333 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 102x Octavia St 10 Median : Cutout Tree DPW 1     12 Width 0ft   6005640.1134 2109813.177 37.773463814863 -122.423920455707 (37.773463814863, -122.423920455707) 7 9 11 28852 10
184838 244427 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 102x Octavia St 1 Median : Cutout Tree DPW 1     10 Width 0ft   6005661.3527 2109672.0384 37.7730774813758 -122.423836948028 (37.7730774813758, -122.423836948028) 7 9 11 28852 10
187951 244409 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 202x Octavia St 15 Median : Cutout Tree DPW 1     15 Width 0ft   6005580.6462 2110260.99 37.7746900436181 -122.424158015373 (37.7746900436181, -122.424158015373) 7 9 11 28852 10
153116 24282 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 300X Winding Way 20 Median : Cutout Tree DPW 1     3 8   6001646.2933309 2086550.8578367 37.7093646550959 -122.436070699117 (37.7093646550959, -122.436070699117) 9 7 6 28861 5
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
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
1959 19904 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 100 STAIRWAY34 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 6X6                      
18074 19903 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 100 STAIRWAY34 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 6X6                      
12447 19841 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 100 STAIRWAY25 25 Sidewalk: Curb side : Cutout Tree DPW 1     12 60X                      
6805 19781 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 100 STAIRWAY19 3 Sidewalk: Curb side : Cutout Tree DPW 1     36 50ST                      
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
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
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
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
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
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
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
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
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
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
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
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
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
129436 6094 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 106X Saint Joseph's Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     20 3X3   6000733.8426241 2112435.5369559 37.7803859446112 -122.44108008458 (37.7803859446112, -122.44108008458) 15 5 1 29490 41
145827 6098 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 106X Saint Joseph's Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6000733.8426241 2112435.5369559 37.7803859446112 -122.44108008458 (37.7803859446112, -122.44108008458) 15 5 1 29490 41
88473 85294 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2255 Mariposa St   Sidewalk: Property side : Cutout Landscaping Private 2   07/27/2007 12:00:00 AM   2x50 Permit Number 49675 6010752 2105977 37.7632178155038 -122.405967315915 (37.7632178155038, -122.405967315915) 8 4 8 28859 19
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
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
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
13169 20051 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 100 STAIRWAY52 7 Sidewalk: Curb side : Cutout Tree DPW 1     12 10                      
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)          
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
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)          
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)          
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)          
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
15701 254211 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 300X Esmeralda Ave 3 Unaccepted Street : Yard Tree DPW 1                              
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)          
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
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
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
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
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
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
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)          
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
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)          
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
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
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
40536 248113 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 108 Brewster St 3 Side Yard : Yard Tree Private 2     17     6010385.30327 2099441.28079 37.7452516667373 -122.406774968811 (37.7452516667373, -122.406774968811) 2 7 7 28859 2
40830 248124 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 109 Brewster St 4 Front Yard : Yard Tree Private 2     10     6010394.26479 2099420.04988 37.7451938726969 -122.406742485274 (37.7451938726969, -122.406742485274) 2 7 7 28859 2
42007 195956 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 2 Back Yard : Yard Tree Private 2     9     6015682.42479 2100340.57249 37.7480158985316 -122.388521013727 (37.7480158985316, -122.388521013727) 10 3 8 58 1
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

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)
);