trees

11 rows where qSiteInfo = ":" and qSpecies_id = 86

✎ View and edit SQL

This data as json, CSV (advanced)

qSiteInfo ✖

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)
12157 241051 DPW Maintained 1 Taxus baccata :: Irish Yew 86 961 San Bruno Ave 1 : Tree Private 2     6 Width 2ft   6011090.2221 2103848.38169 37.757392016144 -122.40464765488 (37.757392016144, -122.40464765488) 10 4 8 28859 19
29197 136662 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1307 Bay St 4 : Tree Private 2     1 Width 1ft   6004522.84241 2120815.90939 37.8036114118857 -122.428569697738 (37.8036114118857, -122.428569697738) 13 9 1 28858 17
53129 136663 DPW Maintained 1 Taxus baccata :: Irish Yew 86 3109 Franklin St 1 : Tree Private 2     7 Width 3ft   6005049.76701 2120690.58566 37.8032971105329 -122.426737318298 (37.8032971105329, -122.426737318298) 13 9 1 28858 17
84447 241052 DPW Maintained 1 Taxus baccata :: Irish Yew 86 961 San Bruno Ave 2 : Tree Private 2     6 Width 2ft   6011089.42148 2103864.30149 37.7574356836305 -122.404651544442 (37.7574356836305, -122.404651544442) 10 4 8 28859 19
93014 136664 DPW Maintained 1 Taxus baccata :: Irish Yew 86 3109 Franklin St 2 : Tree Private 2     7 Width 3ft   6005052.80958 2120674.99367 37.8032544709705 -122.42672567836 (37.8032544709705, -122.42672567836) 13 9 1 28858 17
103768 136642 DPW Maintained 1 Taxus baccata :: Irish Yew 86 3035 Divisadero St 1 : Tree Private 2     12 Width 4ft   6000450.1684 2118732.62208 37.7976599396021 -122.442513681577 (37.7976599396021, -122.442513681577) 13 9 1 57 17
105124 136656 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1425 Jefferson St 4 : Tree Private 2     18 Width 3ft   6002391.37561 2121563.03053 37.8055419559627 -122.435999224706 (37.8055419559627, -122.435999224706) 13 9 1 57 17
114945 241055 DPW Maintained 1 Taxus baccata :: Irish Yew 86 877 Treat Ave 2 : Tree Private 2     2 Width 2ft   6008598.03279 2103456.37285 37.7561760455159 -122.413238943149 (37.7561760455159, -122.413238943149) 2 4 7 28859 19
128853 136661 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1307 Bay St 3 : Tree Private 2     4 Width 1ft   6004511.51487 2120814.19666 37.8036060681264 -122.428608775088 (37.8036060681264, -122.428608775088) 13 9 1 28858 17
140976 241054 DPW Maintained 1 Taxus baccata :: Irish Yew 86 877 Treat Ave 1 : Tree Private 2     10 Width 2ft   6008599.28066 2103440.07697 37.7561313707826 -122.413233475267 (37.7561313707826, -122.413233475267) 2 4 7 28859 19
144301 136647 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1490 Jefferson St 1 : Tree Private 2     8 Width 2ft   6002197.32767 2121601.52004 37.8056366123151 -122.436673510277 (37.8056366123151, -122.436673510277) 13 9 1 57 17

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