trees
14 rows where DBH = 6, Fire Prevention Districts = 8 and qSpecies_id = 50
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 30663 | 190724 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2277 Alameda St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6010411.73546 | 2107844.78326 | 37.7683272866084 | -122.407275858794 | (37.7683272866084, -122.407275858794) | 8 | 4 | 8 | 28853 | 19 | |||
| 48475 | 226811 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 62 Landers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004456.5508 | 2107418.49179 | 37.7668217000839 | -122.427843906179 | (37.7668217000839, -122.427843906179) | 8 | 4 | 5 | 28862 | 3 | |||
| 52561 | 226312 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2180 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6008090.95388 | 2105786.60151 | 37.7625458374421 | -122.4151575397 | (37.7625458374421, -122.4151575397) | 8 | 4 | 7 | 28859 | 19 | |||
| 53107 | 190726 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2211 Alameda St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6010460.27046 | 2107847.89076 | 37.7683385353269 | -122.40710819908 | (37.7683385353269, -122.40710819908) | 8 | 4 | 8 | 28853 | 19 | |||
| 76015 | 190723 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2277 Alameda St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6010387.48096 | 2107844.66484 | 37.7683256039748 | -122.407359744866 | (37.7683256039748, -122.407359744866) | 8 | 4 | 8 | 28853 | 19 | |||
| 82268 | 229743 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 120 Albion St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005873.02878 | 2106520.6426 | 37.7644364480055 | -122.422880717778 | (37.7644364480055, -122.422880717778) | 8 | 4 | 5 | 28859 | 19 | |||
| 86346 | 30658 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 47 Lafayette St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34591 | 6007577.41772 | 2109608.9608 | 37.7730122661246 | -122.417204548653 | (37.7730122661246, -122.417204548653) | 8 | 2 | 9 | 28853 | 19 |
| 102667 | 190730 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 100 Utah St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6010525.46494 | 2107766.85443 | 37.7681196762964 | -122.406876984296 | (37.7681196762964, -122.406876984296) | 8 | 4 | 8 | 28853 | 19 | |||
| 130757 | 35314 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 120 Albion St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1998 12:00:00 AM | 6 | 3x3 | Permit Number 38781 | 6005865.10533901 | 2106546.77110861 | 37.7645077436281 | -122.422909979953 | (37.7645077436281, -122.422909979953) | 8 | 4 | 5 | 28859 | 19 |
| 135288 | 190736 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 128 Utah St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6010534.2694 | 2107640.09784 | 37.7677721243224 | -122.406837595791 | (37.7677721243224, -122.406837595791) | 8 | 4 | 8 | 28853 | 19 | |||
| 140682 | 66211 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 543 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 6 | 3x3 | Permit Number 53588 | 6011817.82357 | 2105837.41873 | 37.7628941088863 | -122.402271150494 | (37.7628941088863, -122.402271150494) | 8 | 3 | 8 | 28856 | 29 |
| 151047 | 190732 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 100 Utah St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6010527.29182 | 2107717.8289 | 37.7679851656226 | -122.406867209579 | (37.7679851656226, -122.406867209579) | 8 | 4 | 8 | 28853 | 19 | |||
| 156163 | 190734 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 128 Utah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6010530.37912 | 2107677.75559 | 37.7678753062214 | -122.406853706245 | (37.7678753062214, -122.406853706245) | 8 | 4 | 8 | 28853 | 19 | |||
| 175061 | 228532 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1000 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6009375.26414 | 2107362.10106 | 37.7669438900682 | -122.410826835502 | (37.7669438900682, -122.410826835502) | 8 | 4 | 7 | 28853 | 19 |
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) );