trees
14 rows where PlotSize = "" and qSpecies_id = 101
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5194 | 187549 | DPW Maintained 1 | Ficus Spp. :: 101 | 130 Alpha St | 6 | Front Yard : Yard | Tree | Private 2 | 4 | 6010899.87279 | 2088102.00857 | 37.714145178328 | -122.404197749245 | (37.714145178328, -122.404197749245) | 9 | 7 | 8 | 309 | 39 | ||||
| 16405 | 114682 | Undocumented 4 | Ficus Spp. :: 101 | 235 GEARY ST | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6010571 | 2114715 | 37.7872002104764 | -122.407209329428 | (37.7872002104764, -122.407209329428) | 5 | 10 | 10 | 28852 | 6 | |||||
| 16951 | 75484 | DPW Maintained 1 | Ficus Spp. :: 101 | 618X Missouri St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6013532.97937 | 2104188.47658 | 37.7584620655002 | -122.396223406681 | (37.7584620655002, -122.396223406681) | 10 | 3 | 8 | 28856 | 29 | |||
| 30356 | 39213 | DPW Maintained 1 | Ficus Spp. :: 101 | 1143 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/1998 12:00:00 AM | 5 | Permit Number 40857 | 6008076.21791 | 2116463.13279 | 37.7918602198281 | -122.415964603882 | (37.7918602198281, -122.415964603882) | 5 | 1 | 10 | 28858 | 21 | ||
| 31980 | 39169 | Permitted Site 7 | Ficus Spp. :: 101 | 1176 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/2004 12:00:00 AM | 7 | Permit Number 40832 | 6008043.68924223 | 2101079.24763886 | 37.7496178601646 | -122.414987812819 | (37.7496178601646, -122.414987812819) | 2 | 4 | 7 | 28859 | 19 | |
| 34419 | 116605 | Undocumented 4 | Ficus Spp. :: 101 | 1325x 08TH AVE | 2 | Front Yard : Yard | Tree | MTA 3 | 5993613 | 2106469 | 37.7635952548206 | -122.465280685608 | (37.7635952548206, -122.465280685608) | 1 | 8 | 11 | 56 | 12 | |||||
| 52902 | 114681 | Undocumented 4 | Ficus Spp. :: 101 | 235 GEARY ST | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6010571 | 2114715 | 37.7872002104764 | -122.407209329428 | (37.7872002104764, -122.407209329428) | 5 | 10 | 10 | 28852 | 6 | |||||
| 74002 | 110160 | Undocumented 4 | Ficus Spp. :: 101 | 484 Sanchez St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | Permit Number 774829 | 6003562.4 | 2105468.5 | 37.761416869862 | -122.430797452614 | (37.761416869862, -122.430797452614) | 15 | 4 | 5 | 28862 | 3 | ||||
| 96414 | 114394 | Significant Tree 6 | Ficus Spp. :: 101 | 134x TAPIA DR | 1 | Front Yard : Yard | Tree | Private 2 | 28 | 5988379 | 2090615 | 37.7197611043299 | -122.482221632222 | (37.7197611043299, -122.482221632222) | 1 | 8 | 4 | 64 | 14 | ||||
| 120029 | 199428 | DPW Maintained 1 | Ficus Spp. :: 101 | 1427x Innes Ave | 6 | Median : Yard | Tree | DPW 1 | 10 | 6016347.26409 | 2096602.76879 | 37.7377894745941 | -122.385961493726 | (37.7377894745941, -122.385961493726) | 10 | 3 | 8 | 58 | 1 | ||||
| 132913 | 199427 | DPW Maintained 1 | Ficus Spp. :: 101 | 1 25th St | 14 | : Yard | Tree | Private 2 | 3 | 6015002.60045 | 2102216.78268 | 37.7531298789641 | -122.391002952844 | (37.7531298789641, -122.391002952844) | 10 | 3 | 8 | 28856 | 29 | ||||
| 160410 | 116604 | Undocumented 4 | Ficus Spp. :: 101 | 1325x 08TH AVE | 1 | Front Yard : Yard | Tree | MTA 3 | 5993613 | 2106469 | 37.7635952548206 | -122.465280685608 | (37.7635952548206, -122.465280685608) | 1 | 8 | 11 | 56 | 12 | |||||
| 184580 | 114393 | Significant Tree 6 | Ficus Spp. :: 101 | 118x TAPIA DR | 1 | Front Yard : Yard | Tree | Private 2 | 36 | 5988638 | 2090878 | 37.7204982977387 | -122.481345621141 | (37.7204982977387, -122.481345621141) | 1 | 8 | 4 | 64 | 14 | ||||
| 194037 | 42829 | DPW Maintained 1 | Ficus Spp. :: 101 | 74 Bernard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/2000 12:00:00 AM | 8 | Permit Number 42766 | 6008488.5125 | 2118110.11878 | 37.7964056092797 | -122.414654663105 | (37.7964056092797, -122.414654663105) | 5 | 1 | 10 | 308 | 21 |
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) );