trees

26 rows where Zip Codes = 59 and qSpecies_id = 86

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: 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)
8931 215339 DPW Maintained 1 Taxus baccata :: Irish Yew 86 637 Detroit St 5 Sidewalk: Property side : Yard Tree Private 2     9 Width 8ft   5999420.83111 2095184.41503 37.7329437376643 -122.444382272244 (37.7329437376643, -122.444382272244) 9 7 4 59 40
20747 215303 DPW Maintained 1 Taxus baccata :: Irish Yew 86 681 Joost Ave 4 Sidewalk: Property side : Yard Tree Private 2     15     5997546.26853 2094964.87379 37.7322337966419 -122.450847264584 (37.7322337966419, -122.450847264584) 9 7 4 59 40
24655 215338 DPW Maintained 1 Taxus baccata :: Irish Yew 86 800 Foerster St 1 Sidewalk: Property side : Yard Tree Private 2     5 Width 3ft   5998226.11251 2096380.78786 37.7361604543418 -122.448598839867 (37.7361604543418, -122.448598839867) 9 7 4 59 40
27037 106347 Undocumented 4 Taxus baccata :: Irish Yew 86 415 DEWEY BLVD 2 Sidewalk: Curb side : Yard Tree Private 2           5995172.1 2100351 37.7468865723154 -122.459445180048 (37.7468865723154, -122.459445180048) 1 8 4 59 40
33262 116307 Undocumented 4 Taxus baccata :: Irish Yew 86 699X DETROIT ST 7 Sidewalk: Property side : Yard Tree Private 2     5 3x20   5999400 2095202 37.7329908332996 -122.444455553893 (37.7329908332996, -122.444455553893) 9 7 4 59 40
35059 116297 Undocumented 4 Taxus baccata :: Irish Yew 86 699X DETROIT ST 3 Sidewalk: Property side : Yard Tree Private 2       3x20   5999400 2095202 37.7329908332996 -122.444455553893 (37.7329908332996, -122.444455553893) 9 7 4 59 40
37032 215337 DPW Maintained 1 Taxus baccata :: Irish Yew 86 800 Foerster St 2 Sidewalk: Property side : Yard Tree Private 2     5 Width 3ft   5998231.9169 2096387.51631 37.7361792609492 -122.448579256245 (37.7361792609492, -122.448579256245) 9 7 4 59 40
43129 100849 Undocumented 4 Taxus baccata :: Irish Yew 86 1 Estero Ave 6 Sidewalk: Property side : Yard Tree Private 2           5992057.7 2091642.6 37.7227959320346 -122.469580550695 (37.7227959320346, -122.469580550695) 9 8 4 59 40
44377 116296 Undocumented 4 Taxus baccata :: Irish Yew 86 699X DETROIT ST 2 Sidewalk: Property side : Yard Tree Private 2       3x20   5999400 2095202 37.7329908332996 -122.444455553893 (37.7329908332996, -122.444455553893) 9 7 4 59 40
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)
);