trees

26 rows where Zip Codes = 59 and qSpecies_id = 86

✎ View and edit SQL

This data as json, CSV (advanced)

Zip Codes ✖

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)
54331 215340 DPW Maintained 1 Taxus baccata :: Irish Yew 86 637 Detroit St 7 Sidewalk: Property side : Yard Tree Private 2     8 Width 8ft   5999417.92849 2095175.79644 37.7329199074284 -122.444391688153 (37.7329199074284, -122.444391688153) 9 7 4 59 40
56720 116300 Undocumented 4 Taxus baccata :: Irish Yew 86 699X DETROIT ST 6 Sidewalk: Property side : Yard Tree Private 2       3x20   5999400 2095202 37.7329908332996 -122.444455553893 (37.7329908332996, -122.444455553893) 9 7 4 59 40
69762 11201 DPW Maintained 1 Taxus baccata :: Irish Yew 86 100 Idora Ave 4 Median : Cutout Tree DPW 1     3 8   5995318.65927 2099418.1217 37.7443335470614 -122.458870864793 (37.7443335470614, -122.458870864793) 1 8 4 59 40
88955 215335 DPW Maintained 1 Taxus baccata :: Irish Yew 86 800 Foerster St 4 Sidewalk: Property side : Yard Tree Private 2     5 Width 3ft   5998237.40059 2096398.28008 37.7362091292407 -122.448561071933 (37.7362091292407, -122.448561071933) 9 7 4 59 40
92456 215336 DPW Maintained 1 Taxus baccata :: Irish Yew 86 800 Foerster St 3 Sidewalk: Property side : Yard Tree Private 2     5 Width 3ft   5998234.84844 2096392.28962 37.7361925349403 -122.448569464424 (37.7361925349403, -122.448569464424) 9 7 4 59 40
112263 97298 Permitted Site 7 Taxus baccata :: Irish Yew 86 1051 Portola Dr 1 Sidewalk: Property side : Yard Tree Private 2           5995688.7 2098126.6 37.7408086112536 -122.457497926865 (37.7408086112536, -122.457497926865) 9 7 4 59 40
112452 116298 Undocumented 4 Taxus baccata :: Irish Yew 86 699X DETROIT ST 4 Sidewalk: Property side : Yard Tree Private 2       3x20   5999400 2095202 37.7329908332996 -122.444455553893 (37.7329908332996, -122.444455553893) 9 7 4 59 40
125099 215304 DPW Maintained 1 Taxus baccata :: Irish Yew 86 681 Joost Ave 5 Sidewalk: Property side : Yard Tree Private 2     19     5997552.24164 2094964.50066 37.7322331140486 -122.450826587399 (37.7322331140486, -122.450826587399) 9 7 4 59 40
129526 215329 DPW Maintained 1 Taxus baccata :: Irish Yew 86 415 Dewey Blvd 1 Sidewalk: Curb side : Yard Tree Private 2     15 Width 3ft   5995144.12297 2100352.21108 37.7468882889814 -122.459542009073 (37.7468882889814, -122.459542009073) 1 8 4 59 40
138676 215328 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1301 14th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5992029.37698 2098355.00215 37.7412248722329 -122.470167004418 (37.7412248722329, -122.470167004418) 1 8 4 59 40
142955 215334 DPW Maintained 1 Taxus baccata :: Irish Yew 86 800 Foerster St 5 Sidewalk: Property side : Yard Tree Private 2     4 Width 3ft   5998241.14099 2096403.03655 37.7362224032408 -122.448548482343 (37.7362224032408, -122.448548482343) 9 7 4 59 40
151400 97300 Permitted Site 7 Taxus baccata :: Irish Yew 86 1051 Portola Dr 3 Sidewalk: Property side : Yard Tree Private 2           5995688.7 2098126.6 37.7408086112536 -122.457497926865 (37.7408086112536, -122.457497926865) 9 7 4 59 40
157310 215326 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1301 14th Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5992028.53266 2098327.51469 37.7411493498502 -122.470167922636 (37.7411493498502, -122.470167922636) 1 8 4 59 40
167373 215302 DPW Maintained 1 Taxus baccata :: Irish Yew 86 698 Hearst Ave 9 Sidewalk: Property side : Yard Tree Private 2     15 Width 5ft   5996836.53539 2094438.39167 37.7307475482438 -122.453262964135 (37.7307475482438, -122.453262964135) 9 7 4 59 40
175531 116299 Undocumented 4 Taxus baccata :: Irish Yew 86 699X DETROIT ST 5 Sidewalk: Property side : Yard Tree Private 2       3x20   5999400 2095202 37.7329908332996 -122.444455553893 (37.7329908332996, -122.444455553893) 9 7 4 59 40
183619 215325 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1301 14th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5992027.65667 2098311.13553 37.7411043262013 -122.470169759048 (37.7411043262013, -122.470169759048) 1 8 4 59 40
192763 215327 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1301 14th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5992028.3413 2098343.65136 37.7411936459769 -122.470169759049 (37.7411936459769, -122.470169759049) 1 8 4 59 40

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