trees
15 rows where qSiteInfo = "Sidewalk: Curb side : Yard" and qSpecies_id = 50 sorted by qAddress
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 34108 | 190689 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1001 Minnesota St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 6015296.26829 | 2103832.96006 | 37.7575838496448 | -122.390100279027 | (37.7575838496448, -122.390100279027) | 10 | 3 | 8 | 28856 | 29 | |||
| 72353 | 190688 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1001 Minnesota St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6015295.35609 | 2103854.98706 | 37.7576442804869 | -122.390104972579 | (37.7576442804869, -122.390104972579) | 10 | 3 | 8 | 28856 | 29 | |||
| 129660 | 190687 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1001 Minnesota St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6015294.95519 | 2103873.52866 | 37.7576951695231 | -122.390107654354 | (37.7576951695231, -122.390107654354) | 10 | 3 | 8 | 28856 | 29 | |||
| 102465 | 190690 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1003 Minnesota St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6015296.6982 | 2103817.69544 | 37.7575419601034 | -122.390097725855 | (37.7575419601034, -122.390097725855) | 10 | 3 | 8 | 28856 | 29 | |||
| 146544 | 190691 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1005 Minnesota St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6015298.33049 | 2103800.67785 | 37.757495323968 | -122.390090891879 | (37.757495323968, -122.390090891879) | 10 | 3 | 8 | 28856 | 29 | |||
| 65837 | 190717 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1150 19th St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6014133.64605 | 2105280.55607 | 37.7614940829991 | -122.394222475384 | (37.7614940829991, -122.394222475384) | 10 | 3 | 8 | 28856 | 29 | |||
| 63197 | 190746 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1725 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6014545.66843 | 2096162.71895 | 37.7364813198484 | -122.392159766062 | (37.7364813198484, -122.392159766062) | 10 | 3 | 8 | 58 | 1 | |||
| 53104 | 229794 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 270 14th St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 6006938.57132 | 2107935.81183 | 37.7683822351787 | -122.419295689168 | (37.7683822351787, -122.419295689168) | 8 | 4 | 7 | 28853 | 19 | |||
| 63895 | 226815 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4132 17th St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 6001471.84267 | 2105861.76416 | 37.7623780104526 | -122.438055976903 | (37.7623780104526, -122.438055976903) | 15 | 5 | 5 | 28862 | 3 | |||
| 74231 | 226816 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4132 17th St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 6001458.28578 | 2105860.25499 | 37.7623730956507 | -122.438102756943 | (37.7623730956507, -122.438102756943) | 15 | 5 | 5 | 28862 | 3 | |||
| 108539 | 219235 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 5 Sequoia Way | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5998215.18129 | 2097817.79881 | 37.7401055166597 | -122.448740104476 | (37.7401055166597, -122.448740104476) | 9 | 7 | 4 | 59 | 40 | |||
| 153023 | 226782 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 579 Noe St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 6003036.36439 | 2104869.3742 | 37.7597419968272 | -122.432573993 | (37.7597419968272, -122.432573993) | 2 | 4 | 5 | 28862 | 3 | |||
| 163736 | 226783 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 579 Noe St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003034.17518 | 2104887.2525 | 37.7597909621971 | -122.432582841439 | (37.7597909621971, -122.432582841439) | 2 | 4 | 5 | 28862 | 3 | |||
| 105814 | 229742 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 749 Dolores St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 8ft | 6005048.07948 | 2104060.60475 | 37.7576351838315 | -122.425558898838 | (37.7576351838315, -122.425558898838) | 2 | 4 | 5 | 28859 | 19 | |||
| 49110 | 190693 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 949 Minnesota St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 6ft | 6015286.01268 | 2104068.80958 | 37.7582308731831 | -122.390152223841 | (37.7582308731831, -122.390152223841) | 10 | 3 | 8 | 28856 | 29 |
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) );