trees
26 rows where Zip Codes = 59 and qSpecies_id = 86 sorted by qSpecies_id
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
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) );