trees
12 rows where Zip Codes = 29491 and qSpecies_id = 91
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11956 | 72875 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2506 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5989254.9412 | 2098243.205 | 37.7407571191622 | -122.47975172868 | (37.7407571191622, -122.47975172868) | 1 | 8 | 3 | 29491 | 35 | |||
| 34168 | 68064 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 1911 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/1993 12:00:00 AM | Permit Number 31801 | 5993434.8119843 | 2102472.74927138 | 37.7526123103472 | -122.465606631992 | (37.7526123103472, -122.465606631992) | 1 | 8 | 4 | 29491 | 12 | ||
| 59190 | 183549 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2593 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5989226.3762 | 2097721.7265 | 37.7393236152619 | -122.479812344828 | (37.7393236152619, -122.479812344828) | 1 | 8 | 3 | 29491 | 35 | |||
| 59784 | 45068 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2227 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2001 12:00:00 AM | 4 | Permit Number 43949 | 5987902.9352 | 2100130.6194 | 37.7458608246267 | -122.4845648054 | (37.7458608246267, -122.4845648054) | 1 | 8 | 3 | 29491 | 35 | |
| 62891 | 214155 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 495 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5993543.01566 | 2101855.50119 | 37.7509237457529 | -122.46518761832 | (37.7509237457529, -122.46518761832) | 1 | 8 | 4 | 29491 | 40 | |||
| 74800 | 214156 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 495 Pacheco St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 5993555.55486 | 2101853.98601 | 37.7509203085364 | -122.465144146879 | (37.7509203085364, -122.465144146879) | 1 | 8 | 4 | 29491 | 40 | |||
| 76751 | 49937 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2591 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/02/2003 12:00:00 AM | 4 | Permit Number 46696 | 5988296.2269 | 2097703.198 | 37.7392186595719 | -122.483026991295 | (37.7392186595719, -122.483026991295) | 1 | 8 | 3 | 29491 | 35 | |
| 119469 | 214167 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1911 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5993435.67173 | 2102452.28847 | 37.7525561798324 | -122.465602172524 | (37.7525561798324, -122.465602172524) | 1 | 8 | 4 | 29491 | 12 | |||
| 147452 | 183550 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2593 23rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 5989227.3726 | 2097702.4617 | 37.7392707770079 | -122.479807490437 | (37.7392707770079, -122.479807490437) | 1 | 8 | 3 | 29491 | 35 | |||
| 159362 | 68308 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2178 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 0 | Permit Number 32119 | 5981736.58109187 | 2100266.85539552 | 37.7458738657157 | -122.505896923616 | (37.7458738657157, -122.505896923616) | 1 | 8 | 3 | 29491 | 35 | |
| 161884 | 214154 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 495 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 5993534.5206 | 2101855.05369 | 37.750922027151 | -122.46521696231 | (37.750922027151, -122.46521696231) | 1 | 8 | 4 | 29491 | 40 | |||
| 194508 | 203796 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 460 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5993728.30174 | 2101878.83793 | 37.7509985054805 | -122.464548580761 | (37.7509985054805, -122.464548580761) | 1 | 8 | 4 | 29491 | 12 |
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) );