trees
15 rows where qSpecies_id = 309
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7187 | 197470 | DPW Maintained 1 | Salix lasiolepis :: Arroyo willow 309 | 300 Tulare St | 11 | Front Yard : Yard | Tree | Private 2 | 18 | 6015061.60017 | 2100303.54529 | 37.7478798059021 | -122.390665231323 | (37.7478798059021, -122.390665231323) | 3 | 8 | 58 | 1 | |||||
| 11095 | 253468 | DPW Maintained 1 | Salix lasiolepis :: Arroyo willow 309 | 851X Alemany Blvd | 12 | Side Yard : Yard | Tree | DPW 1 | 6004188 | 2094500 | 37.7313353304363 | -122.42785218062 | (37.7313353304363, -122.42785218062) | 9 | 7 | 6 | 28861 | 5 | |||||
| 30801 | 240954 | DPW Maintained 1 | Salix lasiolepis :: Arroyo willow 309 | 1101 San Jose Ave | 21 | Front Yard : Yard | Tree | Private 2 | 23 | 6004832.47132 | 2096456.22467 | 37.7367431223852 | -122.425763310243 | (37.7367431223852, -122.425763310243) | 2 | 7 | 5 | 28859 | 2 | ||||
| 40610 | 197469 | DPW Maintained 1 | Salix lasiolepis :: Arroyo willow 309 | 1 24th St | 3 | : Yard | Tree | Private 2 | 12 | 6017071.17305 | 2102662.57862 | 37.7544685090175 | -122.383880386982 | (37.7544685090175, -122.383880386982) | 3 | 8 | 28856 | 29 | |||||
| 45249 | 197471 | DPW Maintained 1 | Salix lasiolepis :: Arroyo willow 309 | 300 Tulare St | 13 | Front Yard : Yard | Tree | Private 2 | 15 | 6015048.81541 | 2100312.7782 | 37.7479044482353 | -122.390710085918 | (37.7479044482353, -122.390710085918) | 3 | 8 | 58 | 1 | |||||
| 45835 | 2396 | DPW Maintained 1 | Salix lasiolepis :: Arroyo willow 309 | 2689 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/15/1990 12:00:00 AM | 12 | 3X3 | 6009821.72724 | 2101682.95822 | 37.7513752692504 | -122.408881857325 | (37.7513752692504, -122.408881857325) | 2 | 4 | 7 | 28859 | 19 | ||
| 50061 | 240952 | DPW Maintained 1 | Salix lasiolepis :: Arroyo willow 309 | 1101 San Jose Ave | 14 | Front Yard : Yard | Tree | Private 2 | 18 | 6004797.42091 | 2096412.76168 | 37.7366218020611 | -122.425881402015 | (37.7366218020611, -122.425881402015) | 2 | 7 | 5 | 28859 | 2 | ||||
| 66161 | 197467 | DPW Maintained 1 | Salix lasiolepis :: Arroyo willow 309 | 1 24th St | 1 | : Yard | Tree | Private 2 | 13 | 6017027.60375 | 2102629.30324 | 37.7543747331295 | -122.384028745448 | (37.7543747331295, -122.384028745448) | 10 | 3 | 8 | 28856 | 29 | ||||
| 86950 | 249724 | DPW Maintained 1 | Salix lasiolepis :: Arroyo willow 309 | 2500 Broderick St | 8 | Front Yard : Yard | Tree | Private 2 | 25 | 6000224.51348 | 2117347.62333 | 37.7938442339643 | -122.443194981868 | (37.7938442339643, -122.443194981868) | 13 | 9 | 1 | 57 | 27 | ||||
| 95386 | 197468 | DPW Maintained 1 | Salix lasiolepis :: Arroyo willow 309 | 1 24th St | 2 | : Yard | Tree | Private 2 | 14 | 6017037.26149 | 2102635.05439 | 37.7543910585113 | -122.383995746633 | (37.7543910585113, -122.383995746633) | 10 | 3 | 8 | 28856 | 29 | ||||
| 111168 | 197473 | DPW Maintained 1 | Salix lasiolepis :: Arroyo willow 309 | 1670 Armstrong Ave | 1 | Front Yard : Yard | Tree | Private 2 | 8 | 6014003.18498 | 2092809.6912 | 37.7272444541432 | -122.393800747332 | (37.7272444541432, -122.393800747332) | 10 | 3 | 8 | 58 | 1 | ||||
| 147860 | 239558 | DPW Maintained 1 | Salix lasiolepis :: Arroyo willow 309 | 26 Ohlone Way | 2 | Back Yard : Yard | Tree | Private 2 | 9 | Width 2ft | 6002169.79283 | 2096347.5297 | 37.7362938444778 | -122.434961566227 | (37.7362938444778, -122.434961566227) | 2 | 7 | 5 | 63 | 7 | |||
| 165135 | 240953 | DPW Maintained 1 | Salix lasiolepis :: Arroyo willow 309 | 1101 San Jose Ave | 15 | Front Yard : Yard | Tree | Private 2 | 12 | 6004805.95854 | 2096424.9931 | 37.7366558692687 | -122.425852754116 | (37.7366558692687, -122.425852754116) | 2 | 7 | 5 | 28859 | 2 | ||||
| 178089 | 239557 | DPW Maintained 1 | Salix lasiolepis :: Arroyo willow 309 | 1100 San Jose Ave | 81 | Front Yard : Yard | Tree | Private 2 | 6 | Width 5ft | 6004609.87718 | 2096414.58836 | 37.7366162172497 | -122.426529951703 | (37.7366162172497, -122.426529951703) | 2 | 7 | 5 | 63 | 7 | |||
| 185371 | 197472 | DPW Maintained 1 | Salix lasiolepis :: Arroyo willow 309 | 1700x Quesada Ave | 31 | Median : Yard | Tree | DPW 1 | 2 | 6014448.1116 | 2095227.50583 | 37.7339079988375 | -122.392431669786 | (37.7339079988375, -122.392431669786) | 10 | 3 | 8 | 58 | 1 |
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) );