334 rows where qSpecies_id = 59 sorted by XCoord

View and edit SQL

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)
1959 19904 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 100 STAIRWAY34 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 6X6                      
6805 19781 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 100 STAIRWAY19 3 Sidewalk: Curb side : Cutout Tree DPW 1     36 50ST                      
12447 19841 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 100 STAIRWAY25 25 Sidewalk: Curb side : Cutout Tree DPW 1     12 60X                      
13169 20051 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 100 STAIRWAY52 7 Sidewalk: Curb side : Cutout Tree DPW 1     12 10                      
15701 254211 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 300X Esmeralda Ave 3 Unaccepted Street : Yard Tree DPW 1                              
18074 19903 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 100 STAIRWAY34 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 6X6                      
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)          
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)          
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)          
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)          
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)          
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)          
46759 119728 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 104x Octavia St 8 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
53212 119723 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 104x Octavia St 3 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
56641 119767 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 2 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
58975 119683 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 4x Octavia St 1 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
60290 119690 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 4x Octavia St 8 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
62466 119770 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 5 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
64025 119685 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 4x Octavia St 3 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
64910 119734 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 104x Octavia St 14 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
74269 119684 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 4x Octavia St 2 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
75461 119727 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 104x Octavia St 7 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
84324 119697 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 4x Octavia St 15 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
90812 119733 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 104x Octavia St 13 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
104758 119774 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 9 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
106853 119772 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 7 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
106915 119693 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 4x Octavia St 11 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
107339 119694 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 4x Octavia St 12 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
113560 119722 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 104x Octavia St 2 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
113742 119769 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 4 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
119609 119771 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 6 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
126751 119726 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 104x Octavia St 6 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
135794 119725 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 104x Octavia St 5 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
153309 119768 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 3 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
158897 119775 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 10 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
159585 119687 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 4x Octavia St 5 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
160546 119721 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 104x Octavia St 1 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
173837 119695 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 4x Octavia St 13 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
178614 119779 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 14 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
179144 119773 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 8 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
180133 119735 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 104x Octavia St 15 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
187388 119776 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 11 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
189536 119688 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 4x Octavia St 6 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
193664 121867 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 382 18th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5990303.78145 2112825.75308 37.7808577673116 -122.477190674715 (37.7808577673116, -122.477190674715) 11 6 2 55 26
140069 212849 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1201 Ulloa St 3 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5992374.69215 2098410.70315 37.7413977704887 -122.468977090726 (37.7413977704887, -122.468977090726) 1 8 4 59 40
148446 53540 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 308 04th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/05/1969 12:00:00 AM 24   Permit Number 6452 5994656.44022 2113376.70713 37.7826221103339 -122.462172779062 (37.7826221103339, -122.462172779062) 11 6 2 54 11
154598 135665 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 3790 California St 4 Sidewalk: Property side : Yard Tree Private 2     16 Width 3ft   5996326.40952 2114621.95963 37.7861372526689 -122.456485512902 (37.7861372526689, -122.456485512902) 11 6 1 54 31
138606 135664 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 3790 California St 3 Sidewalk: Property side : Yard Tree Private 2     10 Width 3ft   5996336.60886 2114624.27331 37.7861441909595 -122.456450393471 (37.7861441909595, -122.456450393471) 11 6 1 54 31
63685 135663 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 3790 California St 1 Sidewalk: Property side : Yard Tree Private 2     10 Width 3ft   5996346.46825 2114626.15487 37.7861499232377 -122.456416418905 (37.7861499232377, -122.456416418905) 11 6 1 54 31
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
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
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
145764 246917 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 845 Shrader St 2 Sidewalk: Property side : Yard Tree Private 2     17 Width 3ft   5997637.48509 2107521.28402 37.766715824697 -122.451437229753 (37.766715824697, -122.451437229753) 15 5 11 29492 9
74379 246918 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 845 Shrader St 4 Sidewalk: Property side : Yard Tree Private 2     22 Width 3ft   5997638.10514 2107510.95773 37.7666875068428 -122.451434340243 (37.7666875068428, -122.451434340243) 15 5 11 29492 9
96656 248613 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 845 Shrader St 1 Sidewalk: Curb side : Cutout Tree Private 2     28 Width 0ft   5997648.1233 2107524.615 37.766725579885 -122.451400674442 (37.766725579885, -122.451400674442) 15 5 11 29492 9
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
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
109416 212850 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 32 Malta Dr 32 Sidewalk: Curb side : Yard Tree Private 2     32 Width 3ft   5999489.82188 2096117.1264 37.7355086796695 -122.444210754429 (37.7355086796695, -122.444210754429) 9 7 4 63 40
83859 139060 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1455 Lyon St 4 Sidewalk: Curb side : Cutout Tree Private 2     39 Width 0ft   5999670.4186 2113895.7324 37.7843346353185 -122.444863945857 (37.7843346353185, -122.444863945857) 15 6 11 29490 31
78015 135666 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 3001 Divisadero St 4 Sidewalk: Curb side : Yard Tree Private 2     42 Width 9ft   6000472.49775 2118651.89467 37.7974395562567 -122.442430617479 (37.7974395562567, -122.442430617479) 13 9 1 57 17
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
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
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
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
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
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
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
111973 247225 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 754 Duboce Ave 1 Sidewalk: Property side : Yard Tree Private 2     15     6002109.57301 2108309.81574 37.7691360073432 -122.4360254903 (37.7691360073432, -122.4360254903) 15 5 5 29492 9
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
59791 96983 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800X Buchanan St 6 Sidewalk: Curb side : Cutout Tree Private 2     38   Permit Number 25529 6003522.34271 2118089.29041 37.796068153086 -122.431837171257 (37.796068153086, -122.431837171257) 13 9 1 57 17
156312 104131 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800X Buchanan St 7 Sidewalk: Curb side : Cutout Tree Private 2     27     6003522.94878 2118100.93382 37.7961001572485 -122.431835905912 (37.7961001572485, -122.431835905912) 13 9 1 57 17
91372 96982 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800X Buchanan St 5 Sidewalk: Curb side : Cutout Tree Private 2     41   Permit Number 25529 6003530.13563 2118059.26209 37.7959861448054 -122.431808061115 (37.7959861448054, -122.431808061115) 13 9 1 57 17
166467 125725 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Buchanan St 4 Sidewalk: Curb side : Cutout Tree Private 2     36 Width 4ft   6003533.81623 2118024.94741 37.7958921341649 -122.431792874238 (37.7958921341649, -122.431792874238) 13 9 1 57 17
49152 125724 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Buchanan St 3 Sidewalk: Curb side : Cutout Tree Private 2     35 Width 4ft   6003536.06003 2118009.60299 37.7958501295278 -122.431784014136 (37.7958501295278, -122.431784014136) 13 9 1 57 17
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
47415 125722 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2     43 Width 4ft   6003540.89789 2117978.17849 37.7957641201722 -122.431765029446 (37.7957641201722, -122.431765029446) 13 9 1 57 17
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
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
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
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
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
61977 244407 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 202x Octavia St 13 Median : Cutout Tree DPW 1     8 Width 0ft   6005584.4651 2110232.73 37.774612664125 -122.424142794808 (37.774612664125, -122.424142794808) 7 9 11 28852 10
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
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
98854 244404 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 202x Octavia St 10 Median : Cutout Tree DPW 1     8 Width 0ft   6005594.3943 2110164.7531 37.7744265766299 -122.424103612435 (37.7744265766299, -122.424103612435) 7 9 11 28852 10
77096 244403 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 202x Octavia St 9 Median : Cutout Tree DPW 1     7 Width 0ft   6005596.6857 2110150.2412 37.7743868598384 -122.424094653801 (37.7743868598384, -122.424094653801) 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
85065 244266 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 202x Octavia St 7 Median : Cutout Tree DPW 1     4 Width 0ft   6005600.5046 2110125.0362 37.7743178686238 -122.424079650665 (37.7743178686238, -122.424079650665) 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)
);