trees
11 rows where PlotSize = "2X3" and qSpecies_id = 6
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 31662 | 27080 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 799X Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/29/2009 12:00:00 AM | 6 | 2X3 | 6006577.59669 | 2093640.72947 | 37.7291108536609 | -122.419529947915 | (37.7291108536609, -122.419529947915) | 9 | 7 | 7 | 309 | 5 | ||
| 46761 | 27182 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 214 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/03/2015 07:50:00 AM | 3 | 2X3 | 6002674.64617 | 2093876.57211 | 37.7295378108224 | -122.433039593603 | (37.7295378108224, -122.433039593603) | 9 | 7 | 6 | 28861 | 25 | ||
| 76315 | 27177 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 241 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2005 12:00:00 AM | 3 | 2X3 | 6002847.37275 | 2093824.85102 | 37.7294055924915 | -122.432438768257 | (37.7294055924915, -122.432438768257) | 9 | 7 | 6 | 28861 | 25 | ||
| 82967 | 25763 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1682 Geneva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/20/2015 06:02:00 PM | 3 | 2X3 | 6004184.86566 | 2087196.38583 | 37.711281031873 | -122.427342931648 | (37.711281031873, -122.427342931648) | 9 | 7 | 6 | 28861 | 5 | ||
| 109581 | 27083 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 773 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/2007 12:00:00 AM | 3 | 2X3 | 6006444.73415 | 2093622.02758 | 37.7290520177348 | -122.419987938702 | (37.7290520177348, -122.419987938702) | 9 | 7 | 7 | 309 | 5 | ||
| 111468 | 27168 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2070X Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2007 12:00:00 AM | 6 | 2X3 | 6012351.75792 | 2095958.07131 | 37.735797342091 | -122.399730727068 | (37.735797342091, -122.399730727068) | 10 | 3 | 8 | 58 | 1 | ||
| 122988 | 27089 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 725 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/30/2009 12:00:00 AM | 3 | 2X3 | 6006167.96193 | 2093597.45552 | 37.728968950933 | -122.420943019604 | (37.728968950933, -122.420943019604) | 9 | 7 | 6 | 28861 | 5 | ||
| 125710 | 27179 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 231 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/27/2009 12:00:00 AM | 3 | 2X3 | 6002801.57598 | 2093850.95144 | 37.7294746613043 | -122.432598955494 | (37.7294746613043, -122.432598955494) | 9 | 7 | 6 | 28861 | 25 | ||
| 156893 | 27081 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 799X Silver Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2007 12:00:00 AM | 3 | 2X3 | 6006577.59669 | 2093640.72947 | 37.7291108536609 | -122.419529947915 | (37.7291108536609, -122.419529947915) | 9 | 7 | 7 | 309 | 5 | ||
| 157521 | 27181 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 225 Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2009 12:00:00 AM | 3 | 2X3 | 6002702.00816 | 2093915.39197 | 37.7296459533895 | -122.432947772843 | (37.7296459533895, -122.432947772843) | 9 | 7 | 6 | 28861 | 25 | ||
| 175351 | 27251 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 547 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2X3 | 6005015.49022 | 2093543.05731 | 37.7287545552706 | -122.424923334442 | (37.7287545552706, -122.424923334442) | 9 | 7 | 6 | 28861 | 5 |
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) );