trees
10 rows where DBH = 0, qLegalStatus_id = 1 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 145878 | 100940 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1470 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/20/2012 12:00:00 AM | 0 | Permit Number 769322 | 5982213.5 | 2105098.8 | 37.7591690876422 | -122.504605773131 | (37.7591690876422, -122.504605773131) | 1 | 8 | 3 | 56 | 35 | ||
| 4034 | 158226 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 217 Whitney St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x3 | 6004403.18115 | 2097173.01672 | 37.7386870025035 | -122.427298598675 | (37.7386870025035, -122.427298598675) | 2 | 7 | 5 | 63 | 7 | |||
| 730 | 160454 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 11 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 0ft | 6001177.46897 | 2090398.6691 | 37.7199032415307 | -122.437966457494 | (37.7199032415307, -122.437966457494) | 9 | 7 | 6 | 28861 | 5 | ||
| 9080 | 160643 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 556 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 0ft | 6001401.85862 | 2090517.84189 | 37.7202432212254 | -122.437199350171 | (37.7202432212254, -122.437199350171) | 9 | 7 | 6 | 28861 | 5 | ||
| 19536 | 160455 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 11 France Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2019 12:00:00 AM | 0 | Width 0ft | 6001161.40103 | 2090408.94535 | 37.719930544037 | -122.438022734371 | (37.719930544037, -122.438022734371) | 9 | 7 | 6 | 28861 | 5 | ||
| 74291 | 164206 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2539 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 3ft | 5991384.96424 | 2098131.18541 | 37.7405730525915 | -122.472378820421 | (37.7405730525915, -122.472378820421) | 1 | 8 | 4 | 29491 | 40 | |||
| 652 | 144195 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 630 42nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:17:00 PM | 0 | Width 4ft | 5982905.71974 | 2111464.01201 | 37.7766868258595 | -122.502682939079 | (37.7766868258595, -122.502682939079) | 11 | 6 | 2 | 55 | 26 | ||
| 6851 | 144169 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 638 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/2020 11:23:00 AM | 0 | Width 4ft | 5983217.80995 | 2111442.38703 | 37.7766457853136 | -122.501601744449 | (37.7766457853136, -122.501601744449) | 11 | 6 | 2 | 55 | 26 | ||
| 13145 | 144156 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 750 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:08:00 PM | 0 | Width 4ft | 5983244.96709 | 2110688.35529 | 37.774577028035 | -122.501452009119 | (37.774577028035, -122.501452009119) | 11 | 6 | 2 | 55 | 26 | ||
| 16050 | 144227 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 782 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:48:00 PM | 0 | Width 4ft | 5982631.55426 | 2110466.9997 | 37.7739332051856 | -122.503557493782 | (37.7739332051856, -122.503557493782) | 11 | 6 | 2 | 55 | 26 |
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) );