trees
12 rows where SiteOrder = 1, qSiteInfo = "Sidewalk: Property side : Yard" and qSpecies_id = 63
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6278 | 132178 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2449 Mason St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 36 | 6008741.74811 | 2122071.63658 | 37.807297172691 | -122.414058809171 | (37.807297172691, -122.414058809171) | 3 | 1 | 10 | 308 | 23 | ||||
| 25472 | 201732 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 727 Jamestown Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 8ft | 6015480.18133 | 2087865.40702 | 37.713750386735 | -122.388349797223 | (37.713750386735, -122.388349797223) | 10 | 3 | 8 | 58 | 1 | |||
| 45510 | 185230 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2509 44th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 35 | Width 0ft | 5982693.8052 | 2098008.2989 | 37.7397287878455 | -122.50241990404 | (37.7397287878455, -122.50241990404) | 1 | 8 | 3 | 29491 | 35 | |||
| 59640 | 211078 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 97 Ashton Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | Width 8ft | 5994121.91269 | 2090532.87853 | 37.7198679898921 | -122.462364611346 | (37.7198679898921, -122.462364611346) | 9 | 8 | 6 | 28861 | 24 | |||
| 77915 | 257969 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 1998X 09th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6x15 | 5993560 | 2101938 | 37.7511512457798 | -122.465134876758 | (37.7511512457798, -122.465134876758) | 1 | 8 | 4 | 29491 | 12 | ||||
| 78908 | 194452 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 2001 20th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 6011998.43391 | 2104639.55141 | 37.7596151114626 | -122.401562284167 | (37.7596151114626, -122.401562284167) | 10 | 3 | 8 | 28856 | 29 | |||
| 99612 | 258091 | Undocumented 4 | Pinus pinea :: Italian Stone Pine 63 | 1500x Steiner St | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 15x50 | 6002808 | 2113496 | 37.7834156319858 | -122.433980438269 | (37.7834156319858, -122.433980438269) | 13 | 9 | 11 | 29490 | 41 | ||||
| 108098 | 132177 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 1048 Union St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6007888.26555 | 2119276.18895 | 37.7995736051877 | -122.416814304957 | (37.7995736051877, -122.416814304957) | 5 | 1 | 1 | 308 | 32 | |||
| 108195 | 247896 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 351 Mayflower St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 29 | Width 5ft | 6010145.43386 | 2098385.46575 | 37.7423392041921 | -122.407529975731 | (37.7423392041921, -122.407529975731) | 10 | 7 | 7 | 28859 | 2 | |||
| 110823 | 201753 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 724 Jamestown Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 6015806.16056 | 2087204.98759 | 37.7119550593549 | -122.387177046177 | (37.7119550593549, -122.387177046177) | 10 | 3 | 8 | 58 | 1 | |||
| 113722 | 201749 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 491 Jamestown Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 26 | Width 8ft | 6015821.03447 | 2087045.57383 | 37.7115181633057 | -122.387114525336 | (37.7115181633057, -122.387114525336) | 10 | 3 | 8 | 58 | 1 | |||
| 187217 | 132182 | DPW Maintained 1 | Pinus pinea :: Italian Stone Pine 63 | 601 Beach St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 5ft | 6007241.65576 | 2121894.78138 | 37.8067272057567 | -122.419237667598 | (37.8067272057567, -122.419237667598) | 5 | 1 | 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) );