trees
19 rows where Zip Codes = 28862 and qSpecies_id = 148
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 32478 | 102160 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 4300X 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769743 | 6001255.1 | 2101750.3 | 37.751076597898 | -122.438511014093 | (37.751076597898, -122.438511014093) | 2 | 4 | 5 | 28862 | 22 |
| 36646 | 14315 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2190X Market St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/22/2000 12:00:00 AM | 6 | 4X4 | 6003585.7913445 | 2107202.1800302 | 37.7661784627239 | -122.430840279858 | (37.7661784627239, -122.430840279858) | 7 | 4 | 5 | 28862 | 3 | ||
| 47413 | 234736 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 200 Henry St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/29/2017 08:58:00 AM | 3 | Width 3ft | 6002089.32864 | 2107372.68693 | 37.7665617321566 | -122.436028447274 | (37.7665617321566, -122.436028447274) | 15 | 5 | 5 | 28862 | 3 | ||
| 53422 | 84564 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1100X Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003799.76299969 | 2101850.31253229 | 37.7514956297527 | -122.429718442511 | (37.7514956297527, -122.429718442511) | 2 | 4 | 5 | 28862 | 22 |
| 58214 | 102158 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 4300X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769743 | 6001255.1 | 2101750.3 | 37.751076597898 | -122.438511014093 | (37.751076597898, -122.438511014093) | 2 | 4 | 5 | 28862 | 22 |
| 79199 | 84561 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1095X Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6003825.808508 | 2101903.8292833 | 37.7516440490083 | -122.429632190427 | (37.7516440490083, -122.429632190427) | 2 | 4 | 5 | 28862 | 22 |
| 95087 | 84562 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1100X Sanchez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003799.76299969 | 2101850.31253229 | 37.7514956297527 | -122.429718442511 | (37.7514956297527, -122.429718442511) | 2 | 4 | 5 | 28862 | 22 |
| 98801 | 84560 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1095X Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003825.808508 | 2101903.8292833 | 37.7516440490083 | -122.429632190427 | (37.7516440490083, -122.429632190427) | 2 | 4 | 5 | 28862 | 22 |
| 103139 | 14244 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2000X Market St | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/12/1993 12:00:00 AM | 12 | 3X3 | 6004581.51553 | 2108125.66106 | 37.76877048508 | -122.427462057771 | (37.76877048508, -122.427462057771) | 7 | 4 | 5 | 28862 | 3 | ||
| 111204 | 102122 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1090X Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6003794.9 | 2101928.3 | 37.7517094896741 | -122.429740821201 | (37.7517094896741, -122.429740821201) | 2 | 4 | 5 | 28862 | 22 |
| 131308 | 102123 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1090X Sanchez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6003794.9 | 2101928.3 | 37.7517094896741 | -122.429740821201 | (37.7517094896741, -122.429740821201) | 2 | 4 | 5 | 28862 | 22 |
| 135140 | 84557 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1111X Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003828.67431583 | 2101851.90831311 | 37.7515016484692 | -122.429618577466 | (37.7515016484692, -122.429618577466) | 2 | 4 | 5 | 28862 | 22 |
| 153932 | 14316 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2190X Market St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/30/2004 12:00:00 AM | 3 | 4X4 | 6003585.7913445 | 2107202.1800302 | 37.7661784627239 | -122.430840279858 | (37.7661784627239, -122.430840279858) | 7 | 4 | 5 | 28862 | 3 | ||
| 161659 | 25176 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3066 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/24/2006 12:00:00 AM | 3 | 3X3 | Permit Number 772743 | 6000144.4461106 | 2105441.7794376 | 37.7611492576992 | -122.442616778303 | (37.7611492576992, -122.442616778303) | 15 | 5 | 5 | 28862 | 3 | |
| 166295 | 102121 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1090X Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6003794.9 | 2101928.3 | 37.7517094896741 | -122.429740821201 | (37.7517094896741, -122.429740821201) | 2 | 4 | 5 | 28862 | 22 |
| 168283 | 84563 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1100X Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003799.76299969 | 2101850.31253229 | 37.7514956297527 | -122.429718442511 | (37.7514956297527, -122.429718442511) | 2 | 4 | 5 | 28862 | 22 |
| 180891 | 84558 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1111X Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003828.67431583 | 2101851.90831311 | 37.7515016484692 | -122.429618577466 | (37.7515016484692, -122.429618577466) | 2 | 4 | 5 | 28862 | 22 |
| 182507 | 53296 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 4124 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2008 12:00:00 AM | 3x3 | Permit Number 50423 | 6002335.15488349 | 2102402.29787451 | 37.7529282071332 | -122.434822699235 | (37.7529282071332, -122.434822699235) | 2 | 4 | 5 | 28862 | 22 | ||
| 189664 | 59740 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 4301 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | Permit Number 769743 | 6001257.45272634 | 2101704.38356178 | 37.7509506561918 | -122.438499588668 | (37.7509506561918, -122.438499588668) | 2 | 4 | 5 | 28862 | 22 |
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) );