trees
18 rows where qSpecies_id = 292
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5531 | 197040 | DPW Maintained 1 | Pyrus calleryana 'Redspire' :: Ornamental Pear Tree 'Redspire' 292 | 1751 Armstrong Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 6013586.08958 | 2093037.55926 | 37.7278469459806 | -122.395258609504 | (37.7278469459806, -122.395258609504) | 10 | 3 | 8 | 58 | 1 | |||
| 10084 | 91045 | Permitted Site 7 | Pyrus calleryana 'Redspire' :: Ornamental Pear Tree 'Redspire' 292 | 1100X Chestnut St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/2006 12:00:00 AM | 3x3 | Permit Number 48418 | 6006545 | 2120445 | 37.8027072182013 | -122.42154555229 | (37.8027072182013, -122.42154555229) | 5 | 9 | 1 | 28858 | 32 | |||
| 24654 | 197048 | DPW Maintained 1 | Pyrus calleryana 'Redspire' :: Ornamental Pear Tree 'Redspire' 292 | 1751 Armstrong Ave | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 6013748.7232 | 2092915.94894 | 37.7275220721631 | -122.394687864649 | (37.7275220721631, -122.394687864649) | 10 | 3 | 8 | 58 | 1 | |||
| 39202 | 197055 | DPW Maintained 1 | Pyrus calleryana 'Redspire' :: Ornamental Pear Tree 'Redspire' 292 | 1751 Armstrong Ave | 18 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 6013870.2556 | 2092825.67225 | 37.7272809468354 | -122.39426140526 | (37.7272809468354, -122.39426140526) | 10 | 3 | 8 | 58 | 1 | |||
| 61273 | 197053 | DPW Maintained 1 | Pyrus calleryana 'Redspire' :: Ornamental Pear Tree 'Redspire' 292 | 1751 Armstrong Ave | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 6013835.9279 | 2092850.83508 | 37.7273481306962 | -122.394381837951 | (37.7273481306962, -122.394381837951) | 10 | 3 | 8 | 58 | 1 | |||
| 78994 | 197042 | DPW Maintained 1 | Pyrus calleryana 'Redspire' :: Ornamental Pear Tree 'Redspire' 292 | 1751 Armstrong Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6013621.73197 | 2093010.86154 | 37.7277756216363 | -122.395133522804 | (37.7277756216363, -122.395133522804) | 10 | 3 | 8 | 58 | 1 | |||
| 87555 | 197049 | DPW Maintained 1 | Pyrus calleryana 'Redspire' :: Ornamental Pear Tree 'Redspire' 292 | 1751 Armstrong Ave | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6013764.80042 | 2092903.72469 | 37.7274894006957 | -122.394631429511 | (37.7274894006957, -122.394631429511) | 10 | 3 | 8 | 58 | 1 | |||
| 96350 | 197046 | DPW Maintained 1 | Pyrus calleryana 'Redspire' :: Ornamental Pear Tree 'Redspire' 292 | 1751 Armstrong Ave | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6013693.17841 | 2092957.12727 | 37.7276320511772 | -122.39488276754 | (37.7276320511772, -122.39488276754) | 10 | 3 | 8 | 58 | 1 | |||
| 114232 | 197050 | DPW Maintained 1 | Pyrus calleryana 'Redspire' :: Ornamental Pear Tree 'Redspire' 292 | 1751 Armstrong Ave | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 6013784.53754 | 2092889.41533 | 37.7274512073814 | -122.394562196094 | (37.7274512073814, -122.394562196094) | 10 | 3 | 8 | 58 | 1 | |||
| 140349 | 197047 | DPW Maintained 1 | Pyrus calleryana 'Redspire' :: Ornamental Pear Tree 'Redspire' 292 | 1751 Armstrong Ave | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6013710.59449 | 2092944.54081 | 37.7275984596917 | -122.39482167839 | (37.7275984596917, -122.39482167839) | 10 | 3 | 8 | 58 | 1 | |||
| 146335 | 197041 | DPW Maintained 1 | Pyrus calleryana 'Redspire' :: Ornamental Pear Tree 'Redspire' 292 | 1751 Armstrong Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 6013605.15041 | 2093023.09609 | 37.7278082930957 | -122.395191702628 | (37.7278082930957, -122.395191702628) | 10 | 3 | 8 | 58 | 1 | |||
| 158822 | 197043 | DPW Maintained 1 | Pyrus calleryana 'Redspire' :: Ornamental Pear Tree 'Redspire' 292 | 1751 Armstrong Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6013640.62798 | 2092996.56911 | 37.7277374283318 | -122.395067197801 | (37.7277374283318, -122.395067197801) | 10 | 3 | 8 | 58 | 1 | |||
| 159411 | 197044 | DPW Maintained 1 | Pyrus calleryana 'Redspire' :: Ornamental Pear Tree 'Redspire' 292 | 1751 Armstrong Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6013656.53687 | 2092984.3482 | 37.7277047568578 | -122.395011344491 | (37.7277047568578, -122.395011344491) | 10 | 3 | 8 | 58 | 1 | |||
| 165529 | 197054 | DPW Maintained 1 | Pyrus calleryana 'Redspire' :: Ornamental Pear Tree 'Redspire' 292 | 1751 Armstrong Ave | 17 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 6013854.32279 | 2092836.72064 | 37.7273103978347 | -122.394317258555 | (37.7273103978347, -122.394317258555) | 10 | 3 | 8 | 58 | 1 | |||
| 168194 | 197045 | DPW Maintained 1 | Pyrus calleryana 'Redspire' :: Ornamental Pear Tree 'Redspire' 292 | 1751 Armstrong Ave | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6013673.46175 | 2092972.44179 | 37.7276730054053 | -122.39495200093 | (37.7276730054053, -122.39495200093) | 10 | 3 | 8 | 58 | 1 | |||
| 175528 | 197056 | DPW Maintained 1 | Pyrus calleryana 'Redspire' :: Ornamental Pear Tree 'Redspire' 292 | 1751 Armstrong Ave | 19 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6013889.03643 | 2092811.44718 | 37.7272429315917 | -122.394195484039 | (37.7272429315917, -122.394195484039) | 10 | 3 | 8 | 58 | 1 | |||
| 176279 | 197051 | DPW Maintained 1 | Pyrus calleryana 'Redspire' :: Ornamental Pear Tree 'Redspire' 292 | 1751 Armstrong Ave | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6013800.11346 | 2092877.36895 | 37.7274189963798 | -122.394507506523 | (37.7274189963798, -122.394507506523) | 10 | 3 | 8 | 58 | 1 | |||
| 192198 | 197052 | DPW Maintained 1 | Pyrus calleryana 'Redspire' :: Ornamental Pear Tree 'Redspire' 292 | 1751 Armstrong Ave | 15 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6013818.36042 | 2092864.26266 | 37.72738402354 | -122.39444350896 | (37.72738402354, -122.39444350896) | 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) );