trees
15 rows where PlotSize = "Width 4ft" and qSpecies_id = 202 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
84362 | 121976 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 200 15th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5991206.08725 | 2113988.74508 | 37.7841033304005 | -122.474154072624 | (37.7841033304005, -122.474154072624) | 11 | 6 | 2 | 54 | 26 | |||
87180 | 121977 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 200 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5991207.54931 | 2113971.26516 | 37.7840554200842 | -122.474147738612 | (37.7840554200842, -122.474147738612) | 11 | 6 | 2 | 54 | 26 | |||
65494 | 121978 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 200 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5991208.06978 | 2113958.75361 | 37.7840210969883 | -122.474145024774 | (37.7840210969883, -122.474145024774) | 11 | 6 | 2 | 54 | 26 | |||
137530 | 123393 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 667 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5995006.92654 | 2111007.28114 | 37.7761364727826 | -122.460788484161 | (37.7761364727826, -122.460788484161) | 11 | 6 | 2 | 54 | 11 | |||
55533 | 123429 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 690 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5995057.91765 | 2110847.92629 | 37.7757018603334 | -122.460600543143 | (37.7757018603334, -122.460600543143) | 11 | 6 | 2 | 54 | 11 | |||
53582 | 125566 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 2809 Buchanan St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 6003481.18787 | 2118079.55095 | 37.7960390779962 | -122.431978879228 | (37.7960390779962, -122.431978879228) | 13 | 9 | 1 | 57 | 17 | |||
54080 | 125567 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 2809 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6003482.8439 | 2118067.55033 | 37.7960062212666 | -122.431972291689 | (37.7960062212666, -122.431972291689) | 13 | 9 | 1 | 57 | 17 | |||
78033 | 175218 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 93 Morse St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6001014.57653 | 2087970.42853 | 37.7132265721263 | -122.438355644521 | (37.7132265721263, -122.438355644521) | 9 | 7 | 6 | 28861 | 5 | |||
169515 | 175220 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 178 Allison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6000035.73488 | 2087742.43428 | 37.7125448266481 | -122.441722494022 | (37.7125448266481, -122.441722494022) | 9 | 7 | 6 | 28861 | 5 | |||
44573 | 175223 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 39 Naylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6002350.25908 | 2087113.68805 | 37.7109500327891 | -122.433677880228 | (37.7109500327891, -122.433677880228) | 9 | 7 | 6 | 28861 | 5 | |||
55725 | 203601 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 601 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5995029.86532 | 2089100.67816 | 37.7159877489258 | -122.459122505898 | (37.7159877489258, -122.459122505898) | 9 | 8 | 6 | 28861 | 24 | |||
64600 | 203602 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 601 Capitol Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5995030.39824 | 2089062.56731 | 37.7158831361758 | -122.459117905878 | (37.7158831361758, -122.459117905878) | 9 | 8 | 6 | 28861 | 24 | |||
12088 | 221940 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 168 Tiffany Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6006049.87669 | 2099255.63478 | 37.7444983936957 | -122.421752983209 | (37.7444983936957, -122.421752983209) | 2 | 7 | 5 | 28859 | 2 | |||
143401 | 221955 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 271 Bemis St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6002975.66032 | 2096224.16146 | 37.7360008273625 | -122.432166542558 | (37.7360008273625, -122.432166542558) | 2 | 7 | 5 | 63 | 7 | |||
20682 | 246691 | DPW Maintained 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 96 Stoneman St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 6007854.4475 | 2099435.64946 | 37.7450942718828 | -122.415525868717 | (37.7450942718828, -122.415525868717) | 2 | 7 | 7 | 28859 | 2 |
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) );