trees

11 rows where Zip Codes = 28859 and qSpecies_id = 86

✎ View and edit SQL

This data as json, CSV (advanced)

Zip Codes ✖

  • 28859 · 11 ✖
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)
5600 241053 DPW Maintained 1 Taxus baccata :: Irish Yew 86 201 Coso Ave 3 Side Yard : Yard Tree Private 2     11 Width 5ft   6007672.87316 2099533.13544 37.7453517387841 -122.416160625529 (37.7453517387841, -122.416160625529) 2 7 7 28859 2
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
63554 241060 DPW Maintained 1 Taxus baccata :: Irish Yew 86 112 Crescent Ave 3 Sidewalk: Curb side : Yard Tree Private 2     5 Width 5ft   6005928.78547 2095826.36488 37.7350755589952 -122.421928139697 (37.7350755589952, -122.421928139697) 2 7 7 28859 2
65143 241059 DPW Maintained 1 Taxus baccata :: Irish Yew 86 112 Crescent Ave 2 Sidewalk: Curb side : Yard Tree Private 2     6 Width 5ft   6005916.72603 2095826.92897 37.7350764277358 -122.421969873622 (37.7350764277358, -122.421969873622) 2 7 7 28859 2
68300 241061 DPW Maintained 1 Taxus baccata :: Irish Yew 86 112 Crescent Ave 4 Sidewalk: Curb side : Yard Tree Private 2     7 Width 5ft   6005940.184 2095824.54912 37.7350712161596 -122.421888601897 (37.7350712161596, -122.421888601897) 2 7 7 28859 2
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
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
126944 241063 DPW Maintained 1 Taxus baccata :: Irish Yew 86 112 Crescent Ave 6 Sidewalk: Curb side : Yard Tree Private 2     5 Width 5ft   6005947.85615 2095824.2566 37.73507084564 -122.421862055716 (37.73507084564, -122.421862055716) 2 7 7 28859 2
128394 241062 DPW Maintained 1 Taxus baccata :: Irish Yew 86 112 Crescent Ave 5 Sidewalk: Curb side : Yard Tree Private 2     5 Width 5ft   6005944.68012 2095825.54843 37.7350742136048 -122.421873128139 (37.7350742136048, -122.421873128139) 2 7 7 28859 2
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
188876 241058 DPW Maintained 1 Taxus baccata :: Irish Yew 86 112 Crescent Ave 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 5ft   6005911.64547 2095827.03332 37.7350764277212 -122.421987446374 (37.7350764277212, -122.421987446374) 2 7 7 28859 2

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