trees
10 rows where SiteOrder = 7 and qSpecies_id = 65 sorted by PlotSize
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 30708 | 175201 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 648 Peru Ave | 7 | Side Yard : Yard | Tree | Private 2 | 14 | 6005063.1365 | 2092591.26253 | 37.7261438278596 | -122.424690937041 | (37.7261438278596, -122.424690937041) | 9 | 7 | 6 | 28861 | 5 | ||||
| 66364 | 175206 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 653 Peru Ave | 7 | Side Yard : Yard | Tree | Private 2 | 13 | 6005071.10082 | 2092642.69367 | 37.7262854962678 | -122.424667061852 | (37.7262854962678, -122.424667061852) | 9 | 7 | 6 | 28861 | 5 | ||||
| 124927 | 114086 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 20 Cook St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 5997489.0948 | 2113600.1035 | 37.783398187645 | -122.452389185424 | (37.783398187645, -122.452389185424) | 15 | 6 | 1 | 54 | 31 | |||
| 129534 | 247526 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1101 Waller St | 7 | Side Yard : Yard | Tree | Private 2 | 25 | 6000042.11565 | 2108480.23517 | 37.7694862662998 | -122.44318892675 | (37.7694862662998, -122.44318892675) | 15 | 5 | 11 | 29492 | 9 | ||||
| 88447 | 113211 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 50x DASHIELL HAMMETT ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010410 | 2116139 | 37.7911011617465 | -122.407866810246 | (37.7911011617465, -122.407866810246) | 5 | 1 | 10 | 28857 | 21 | ||||
| 29348 | 221851 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 19 Saint Marys Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6004484.38042 | 2095546.73676 | 37.7342261969882 | -122.426902058798 | (37.7342261969882, -122.426902058798) | 2 | 7 | 5 | 28861 | 25 | |||
| 50598 | 221896 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 7 Marsily St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6004330.56552 | 2095607.66514 | 37.7343847942306 | -122.427438185126 | (37.7343847942306, -122.427438185126) | 2 | 7 | 5 | 28861 | 25 | |||
| 61711 | 175190 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2201 Bay Shore Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6011418.48668 | 2087333.27614 | 37.7120633584163 | -122.402351191059 | (37.7120633584163, -122.402351191059) | 10 | 3 | 8 | 309 | 1 | |||
| 117173 | 203550 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 181 Flood Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5999525.01063 | 2094056.66117 | 37.7298531329131 | -122.443941098101 | (37.7298531329131, -122.443941098101) | 9 | 7 | 4 | 63 | 40 | |||
| 46734 | 125549 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1445 Greenwich St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6006015.52243 | 2119649.2025 | 37.8004922923456 | -122.423321211112 | (37.8004922923456, -122.423321211112) | 13 | 9 | 1 | 28858 | 32 |
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) );