trees

334 rows where qSpecies_id = 59

✎ 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)
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
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
172175 248118 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 108 Brewster St 8 Side Yard : Yard Tree Private 2     6     6010376.97092 2099406.95495 37.7451569492381 -122.40680136209 (37.7451569492381, -122.40680136209) 2 7 7 28859 2
173532 195957 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 3 Back Yard : Yard Tree Private 2     12     6015667.37966 2100340.53223 37.7480149542209 -122.388573036834 (37.7480149542209, -122.388573036834) 10 3 8 58 1
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)          
175828 195997 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 1 Sidewalk: Property side : Yard Tree Private 2     23     6016094.12732 2110713.51522 37.776520582607 -122.387821017432 (37.776520582607, -122.387821017432) 14 3 9 310 20
176690 195958 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 4 Back Yard : Yard Tree Private 2     10     6015649.24062 2100340.89834 37.7480149542299 -122.388635787013 (37.7480149542299, -122.388635787013) 10 3 8 58 1
176786 195987 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 401 Amador St 6 Sidewalk: Curb side : Yard Tree Private 2     6     6018466.53487 2099573.76457 37.7460642923433 -122.378840325441 (37.7460642923433, -122.378840325441) 10 3 8 58 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
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
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)          
178720 196029 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2 Lane St 7 Sidewalk: Property side : Yard Tree Private 2     10 Width 10ft   6017027.27121 2097051.6476 37.7390596150087 -122.383641598974 (37.7390596150087, -122.383641598974) 10 3 8 58 1
178785 246557 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2x Octavia St 1 Median : Yard Tree DPW 1     11 Width 7ft   6005728.07536 2109359.17359 37.7722221964256 -122.4235838977 (37.7722221964256, -122.4235838977) 7 9 11 28852 10
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)          
179780 234900 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 50 Alemany Blvd 4 Sidewalk: Property side : Yard Tree Private 2     17     6009696.65795 2096435.22954 37.7369591476365 -122.40894414348 (37.7369591476365, -122.40894414348) 10 7 7 28859 2
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)          
182229 234877 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Cesar Chavez St 8 Sidewalk: Property side : Yard Tree Private 2     38     6010643.54009 2100844.31084 37.7491185267072 -122.405980844948 (37.7491185267072, -122.405980844948) 10 4 7 28859 19
183244 195979 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 900 Phelps St 1 Side Yard : Yard Tree Private 2     30 Width 9ft   6014704.25324 2097268.53042 37.7395264548697 -122.39168875964 (37.7395264548697, -122.39168875964) 10 3 8 58 1
184380 196015 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 19 Sidewalk: Property side : Yard Tree Private 2     17     6015698.09519 2110690.66596 37.7764358970472 -122.389189422279 (37.7764358970472, -122.389189422279) 14 3 9 310 20
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
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
185019 195976 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 22 Back Yard : Yard Tree Private 2     5 Width 4ft   6015275.57642 2100315.10939 37.7479234275315 -122.389926112714 (37.7479234275315, -122.389926112714)   3 8 58 1
185058 196002 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 6 Sidewalk: Property side : Yard Tree Private 2     18     6015985.51722 2110706.09628 37.7764941946745 -122.388196216398 (37.7764941946745, -122.388196216398) 14 3 9 310 20
185083 195981 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 401 Amador St 12 Sidewalk: Curb side : Yard Tree Private 2     7     6018524.13374 2099557.33259 37.7460223488573 -122.378640013128 (37.7460223488573, -122.378640013128) 10 3 8 58 1
187174 234894 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2827 Cesar Chavez St 12 Front Yard : Yard Tree Private 2     27     6010729.67514 2100698.35511 37.7487225812957 -122.405672708429 (37.7487225812957, -122.405672708429) 2 7 7 28859 2
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)          
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
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)          
189964 195993 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2101 Newcomb Ave 2 Side Yard : Yard Tree Private 2     23 Width 3ft   6012429.27896 2097757.0265 37.7407412159349 -122.399588970171 (37.7407412159349, -122.399588970171) 10 3 8 58 1
191532 196004 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 8 Sidewalk: Property side : Yard Tree Private 2     16     6015940.35109 2110704.12187 37.7764862707572 -122.388352322497 (37.7764862707572, -122.388352322497) 14 3 9 310 20
191905 248123 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 109 Brewster St 3 Front Yard : Yard Tree Private 2     13     6010392.06783 2099413.07866 37.7451746083214 -122.406749590819 (37.7451746083214, -122.406749590819) 2 7 7 28859 2
192137 195960 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 6 Back Yard : Yard Tree Private 2     8     6015597.7328 2100337.72732 37.7480033925609 -122.388813679213 (37.7480033925609, -122.388813679213) 10 3 8 58 1
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

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