trees

16 rows where Zip Codes = 28853 and qSpecies_id = 12

✎ View and edit SQL

This data as json, CSV (advanced)

Zip Codes ✖

  • 28853 · 16 ✖
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

CSV options: 

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)
);