trees
10 rows where Zip Codes = 28853 and qSpecies_id = 95 sorted by qSpecies_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5674 | 69960 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1084 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6007591.27933 | 2109447.46349 | 37.7725696126174 | -122.417145153823 | (37.7725696126174, -122.417145153823) | 8 | 2 | 9 | 28853 | 19 | |||
| 22936 | 42216 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 202X Dore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 3 | 3X3 | Permit Number 42481 | 6009500.82528 | 2109156.27117 | 37.7718773055291 | -122.410519244875 | (37.7718773055291, -122.410519244875) | 8 | 2 | 9 | 28853 | 34 |
| 32340 | 194551 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 364 09th St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6009495.1726 | 2109485.56506 | 37.7727811529595 | -122.410562055301 | (37.7727811529595, -122.410562055301) | 8 | 2 | 9 | 28853 | 34 | |||
| 52206 | 233518 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 100 Hwy 101 Southbound | 10 | Back Yard : Yard | Tree | Private 2 | 7 | 6005873.99672 | 2108944.2877 | 37.7710912548825 | -122.423049648243 | (37.7710912548825, -122.423049648243) | 8 | 2 | 5 | 28853 | 19 | ||||
| 67193 | 61924 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 456 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1985 12:00:00 AM | Permit Number 21978 | 6005733.06565102 | 2107870.63152991 | 37.768135298323 | -122.423460793102 | (37.768135298323, -122.423460793102) | 8 | 4 | 5 | 28853 | 19 | ||
| 79049 | 194552 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1084 Natoma St | 1 | : | Tree | Private 2 | 12 | Width 3ft | 6007595.2752 | 2109454.36065 | 37.772588775377 | -122.417131820472 | (37.772588775377, -122.417131820472) | 8 | 2 | 9 | 28853 | 19 | |||
| 143804 | 88992 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 680 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013080.3 | 2113726.9 | 37.784627230328 | -122.398458274764 | (37.784627230328, -122.398458274764) | 6 | 2 | 9 | 28853 | 6 | ||||
| 150260 | 233517 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 100 Hwy 101 Southbound | 12 | Back Yard : Yard | Tree | Private 2 | 7 | 6005882.82166 | 2108930.28485 | 37.7710533043986 | -122.423018127005 | (37.7710533043986, -122.423018127005) | 8 | 2 | 5 | 28853 | 19 | ||||
| 178700 | 61907 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 410 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1985 12:00:00 AM | Permit Number 21954 | 6006015.61965589 | 2107886.23746349 | 37.7681940923018 | -122.422484575665 | (37.7681940923018, -122.422484575665) | 8 | 4 | 5 | 28853 | 19 | ||
| 189412 | 194573 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 614 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009542.67378 | 2111646.52636 | 37.7787173088821 | -122.410550367712 | (37.7787173088821, -122.410550367712) | 8 | 2 | 9 | 28853 | 34 |
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) );