trees
17 rows where qCareAssistant = "FUF" and qSpecies_id = 86
This data as json, CSV (advanced)
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
290 | 72670 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 203 04th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 5994586.71732 | 2114106.61682 | 37.7846222306097 | -122.462466948558 | (37.7846222306097, -122.462466948558) | 11 | 6 | 2 | 54 | 11 | |||
1950 | 71713 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 782 40th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5983564.60428 | 2110493.72832 | 37.7740614056929 | -122.500331946576 | (37.7740614056929, -122.500331946576) | 11 | 6 | 2 | 55 | 26 | |||
4496 | 74361 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 299 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6005755.65434 | 2092345.08491 | 37.7255069657486 | -122.422279456248 | (37.7255069657486, -122.422279456248) | 9 | 7 | 7 | 309 | 5 | |||
5140 | 70173 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 246 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 5992471.1879 | 2113801.97828 | 37.7836637247597 | -122.469763717453 | (37.7836637247597, -122.469763717453) | 11 | 6 | 2 | 54 | 11 | |||
5435 | 70223 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2011 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5989310.46344 | 2111227.07993 | 37.776410575875 | -122.480509949706 | (37.776410575875, -122.480509949706) | 11 | 6 | 2 | 55 | 26 | |||
5717 | 72392 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 2220 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 5988673.5466 | 2110578.22329 | 37.7745919608967 | -122.48266563867 | (37.7745919608967, -122.48266563867) | 11 | 6 | 2 | 55 | 26 | |||
6392 | 70172 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 3027 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5989237.11171 | 2111905.73167 | 37.7782697016213 | -122.480813388031 | (37.7782697016213, -122.480813388031) | 11 | 6 | 2 | 55 | 26 | |||
11629 | 47454 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 5135 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | 6 | Permit Number 45360 | 5982684.34734 | 2111666.51211 | 37.7772298203102 | -122.50346371712 | (37.7772298203102, -122.50346371712) | 11 | 6 | 2 | 55 | 26 | |
14728 | 62484 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 81 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/1986 12:00:00 AM | 10 | Permit Number 22655 | 6000565.24487 | 2092874.98588 | 37.7266678079605 | -122.440260189157 | (37.7266678079605, -122.440260189157) | 9 | 7 | 6 | 28861 | 25 | |
34996 | 31114 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 450 Edna St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 5 | Permit Number 34839 | 5998792.19171 | 2094330.53052 | 37.7305632843566 | -122.44649422303 | (37.7305632843566, -122.44649422303) | 9 | 7 | 4 | 28861 | 40 | |
41820 | 68457 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 119 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/04/1993 12:00:00 AM | 12 | Permit Number 32319 | 5991463.79981 | 2114626.05304 | 37.7858681269791 | -122.473308986123 | (37.7858681269791, -122.473308986123) | 11 | 6 | 2 | 54 | 26 | |
47539 | 31120 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 450 Edna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 9 | Permit Number 34839 | 5998792.22814 | 2094324.02861 | 37.7305454337211 | -122.446493629496 | (37.7305454337211, -122.446493629496) | 9 | 7 | 4 | 28861 | 40 | |
94393 | 68663 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 142 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1993 12:00:00 AM | 10 | Permit Number 32570 | 5993373.867 | 2114549.20899 | 37.7857675498482 | -122.466695151518 | (37.7857675498482, -122.466695151518) | 11 | 6 | 2 | 54 | 11 | |
150071 | 67960 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 819 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | 12 | Permit Number 31680 | 5987243.89988 | 2110346.29905 | 37.7738718832899 | -122.487593962509 | (37.7738718832899, -122.487593962509) | 11 | 6 | 2 | 55 | 26 | |
161074 | 41928 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 524 04th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 9 | Permit Number 42287 | 5994708.51972 | 2111929.51477 | 37.7786515066402 | -122.461887634901 | (37.7786515066402, -122.461887634901) | 11 | 6 | 2 | 54 | 11 | |
169423 | 41927 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 524 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 6 | Permit Number 42287 | 5994711.05634 | 2111911.6847 | 37.7786026960614 | -122.46187756658 | (37.7786026960614, -122.46187756658) | 11 | 6 | 2 | 54 | 11 | |
175671 | 67619 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1101 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/14/1992 12:00:00 AM | 11 | Permit Number 31202 | 6007683.17057 | 2118835.54867 | 37.7983521792584 | -122.417492763389 | (37.7983521792584, -122.417492763389) | 5 | 1 | 10 | 28858 | 32 |
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) );