trees
16 rows where qSpecies_id = 287
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5158 | 116663 | DPW Maintained 1 | Araucaria araucana :: Monkey puzzle 287 | 199x Esmeralda Ave | 16 | Unaccepted Street : Yard | Tree | DPW 1 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 2 | 7 | 7 | 28859 | 2 | |||||
| 21308 | 186403 | DPW Maintained 1 | Araucaria araucana :: Monkey puzzle 287 | 1801 Sunset Blvd | 70 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984820.922 | 2102312.2628 | 37.7516710584533 | -122.495382684544 | (37.7516710584533, -122.495382684544) | 1 | 8 | 3 | 56 | 35 | |||
| 32221 | 186190 | DPW Maintained 1 | Araucaria araucana :: Monkey puzzle 287 | 1701 Sunset Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984778.3318 | 2103573.7698 | 37.7551323147484 | -122.495623003209 | (37.7551323147484, -122.495623003209) | 1 | 8 | 3 | 56 | 35 | |||
| 48197 | 76514 | Permitted Site 7 | Araucaria araucana :: Monkey puzzle 287 | 1000 Tompkins Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/13/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778440 | 6009284.86795875 | 2096393.41418024 | 37.7368212561993 | -122.41036493916 | (37.7368212561993, -122.41036493916) | 10 | 7 | 7 | 28859 | 2 | |
| 58962 | 185390 | DPW Maintained 1 | Araucaria araucana :: Monkey puzzle 287 | 2300 Sunset Blvd | 1 | unknown : Yard | Tree | Private 2 | 2 | Width 0ft | 5985092.6382 | 2098924.4627 | 37.7423849872747 | -122.4941933909 | (37.7423849872747, -122.4941933909) | 1 | 8 | 3 | 29491 | 35 | |||
| 68469 | 116068 | DPW Maintained 1 | Araucaria araucana :: Monkey puzzle 287 | 4150X CLEMENT ST | 2 | Front Yard : Yard | Tree | DPW 1 | 3 | 3x3 | 5983115 | 2113126 | 37.7812624555251 | -122.502082001527 | (37.7812624555251, -122.502082001527) | 11 | 6 | 2 | 55 | 15 | |||
| 73855 | 20774 | DPW Maintained 1 | Araucaria araucana :: Monkey puzzle 287 | 1701X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 5984888.092725 | 2103630.7874996 | 37.7552952964732 | -122.49524762816 | (37.7552952964732, -122.49524762816) | 1 | 8 | 3 | 56 | 35 | ||||
| 102814 | 186044 | DPW Maintained 1 | Araucaria araucana :: Monkey puzzle 287 | 1900 Sunset Blvd | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985010.438 | 2102178.2104 | 37.7513140820988 | -122.494717441079 | (37.7513140820988, -122.494717441079) | 1 | 8 | 3 | 29491 | 35 | |||
| 122345 | 184886 | DPW Maintained 1 | Araucaria araucana :: Monkey puzzle 287 | 1201 Sunset Blvd | 76 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984683.9949 | 2106763.6802 | 37.7638853936031 | -122.496184581552 | (37.7638853936031, -122.496184581552) | 1 | 8 | 3 | 56 | 35 | |||
| 126481 | 186563 | DPW Maintained 1 | Araucaria araucana :: Monkey puzzle 287 | 1501 Sunset Blvd | 34 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5984717.9132 | 2104705.2165 | 37.7582354149831 | -122.495915407531 | (37.7582354149831, -122.495915407531) | 1 | 8 | 3 | 56 | 35 | |||
| 127295 | 186116 | DPW Maintained 1 | Araucaria araucana :: Monkey puzzle 287 | 1700 Sunset Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984983.194 | 2103006.193 | 37.7535858999024 | -122.49487269449 | (37.7535858999024, -122.49487269449) | 1 | 8 | 3 | 56 | 35 | |||
| 134258 | 186323 | DPW Maintained 1 | Araucaria araucana :: Monkey puzzle 287 | 1800 Sunset Blvd | 61 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984977.2414 | 2102887.891 | 37.7532607267541 | -122.4948845576 | (37.7532607267541, -122.4948845576) | 1 | 8 | 3 | 56 | 35 | |||
| 135022 | 185581 | DPW Maintained 1 | Araucaria araucana :: Monkey puzzle 287 | 2201 Sunset Blvd | 65 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984892.0445 | 2099593.3004 | 37.7442096942241 | -122.494936277947 | (37.7442096942241, -122.494936277947) | 1 | 8 | 3 | 29491 | 35 | |||
| 161602 | 124181 | DPW Maintained 1 | Araucaria araucana :: Monkey puzzle 287 | 18 Almaden Ct | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 9ft | 5995866.53824 | 2112606.84156 | 37.7805778644243 | -122.457930655785 | (37.7805778644243, -122.457930655785) | 11 | 6 | 2 | 54 | 16 | |||
| 167399 | 186264 | DPW Maintained 1 | Araucaria araucana :: Monkey puzzle 287 | 1800 Sunset Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985008.2513 | 2102330.1154 | 37.751731043534 | -122.49473620106 | (37.751731043534, -122.49473620106) | 1 | 8 | 3 | 56 | 35 | |||
| 173974 | 251394 | Significant Tree 6 | Araucaria araucana :: Monkey puzzle 287 | 203 Corbett Ave | 1 | Front Yard : Yard | Tree | Private 2 | 05/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779803 | 6000094 | 2105620 | 37.7616357315689 | -122.442804047122 | (37.7616357315689, -122.442804047122) | 15 | 5 | 5 | 28862 | 3 |
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) );