trees
16 rows where Zip Codes = 28853 and qSpecies_id = 12 sorted by PlantType
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16235 | 112148 | Undocumented 4 | Tilia cordata :: Littleleaf Linden 12 | 101X 05TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 10 | 3x3 | 6010794 | 2113100 | 37.782778280213 | -122.406323959165 | (37.782778280213, -122.406323959165) | 12 | 2 | 9 | 28853 | 34 | |||
28759 | 197973 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 90 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6011498.91524 | 2113552.62708 | 37.7840604950255 | -122.403917097798 | (37.7840604950255, -122.403917097798) | 12 | 2 | 9 | 28853 | 34 | |||
28889 | 197972 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 90 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6011477.0733 | 2113572.89989 | 37.7841149391088 | -122.403994090559 | (37.7841149391088, -122.403994090559) | 12 | 2 | 9 | 28853 | 34 | |||
40312 | 197971 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 90 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6011459.89889 | 2113592.30017 | 37.7841672481653 | -122.404054873931 | (37.7841672481653, -122.404054873931) | 12 | 2 | 9 | 28853 | 34 | |||
42209 | 112149 | Undocumented 4 | Tilia cordata :: Littleleaf Linden 12 | 101X 05TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 10 | 3x3 | 6010794 | 2113100 | 37.782778280213 | -122.406323959165 | (37.782778280213, -122.406323959165) | 12 | 2 | 9 | 28853 | 34 | |||
42591 | 197967 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 153 05th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6010879.01966 | 2113009.66156 | 37.7825349876424 | -122.406023459311 | (37.7825349876424, -122.406023459311) | 12 | 2 | 9 | 28853 | 34 | |||
46324 | 112150 | Undocumented 4 | Tilia cordata :: Littleleaf Linden 12 | 101X 05TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 10 | 3x3 | 6010794 | 2113100 | 37.782778280213 | -122.406323959165 | (37.782778280213, -122.406323959165) | 12 | 2 | 9 | 28853 | 34 | |||
62007 | 51401 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 423 Tehama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2017 12:00:00 AM | 3 | 3x3 | Permit Number 774507 | 6011161.37558 | 2112281.69407 | 37.7805519474533 | -122.404995352556 | (37.7805519474533, -122.404995352556) | 14 | 2 | 9 | 28853 | 34 | |
66782 | 197966 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 153 05th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6010894.68049 | 2112991.13579 | 37.7824849961321 | -122.405967973868 | (37.7824849961321, -122.405967973868) | 12 | 2 | 9 | 28853 | 34 | |||
77213 | 59528 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 286 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/1981 12:00:00 AM | 6 | 3x3 | Permit Number 18910 | 6010887.1653 | 2111573.26099 | 37.7785914236007 | -122.405894062179 | (37.7785914236007, -122.405894062179) | 14 | 2 | 9 | 28853 | 34 | |
106319 | 197974 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 248 06th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6010760.66114 | 2111705.859 | 37.7789484310553 | -122.406341036019 | (37.7789484310553, -122.406341036019) | 14 | 2 | 9 | 28853 | 34 | |||
107947 | 28499 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 270 06th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3X3 | 6010842.7805 | 2111615.69591 | 37.7787054576155 | -122.406050597275 | (37.7787054576155, -122.406050597275) | 14 | 2 | 9 | 28853 | 34 | |||
111850 | 197969 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 153 05th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6010835.00932 | 2113053.67977 | 37.7826533896919 | -122.406178819023 | (37.7826533896919, -122.406178819023) | 12 | 2 | 9 | 28853 | 34 | |||
168053 | 197970 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 90 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6011429.88 | 2113631.09913 | 37.7842721037271 | -122.404161460703 | (37.7842721037271, -122.404161460703) | 12 | 2 | 9 | 28853 | 34 | |||
184350 | 197968 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 153 05th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6010849.47884 | 2113039.65001 | 37.7826156766079 | -122.406127771681 | (37.7826156766079, -122.406127771681) | 12 | 2 | 9 | 28853 | 34 | |||
188945 | 112147 | Undocumented 4 | Tilia cordata :: Littleleaf Linden 12 | 101X 05TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 10 | 3x3 | 6010794 | 2113100 | 37.782778280213 | -122.406323959165 | (37.782778280213, -122.406323959165) | 12 | 2 | 9 | 28853 | 34 |
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) );