trees

12 rows where SiteOrder = 2, Zip Codes = 28859 and qSpecies_id = 65 sorted by qSiteInfo

✎ View and edit SQL

This data as json, CSV (advanced)

Zip Codes ✖

  • 28859 · 12 ✖

SiteOrder ✖

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)
3673 221872 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 619 Eugenia Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007332.3833 2097776.98457 37.740510589287 -122.417213566178 (37.740510589287, -122.417213566178) 2 7 7 28859 2
12895 221826 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 499X Tompkins Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6008314.44854 2096531.09899 37.7371448612571 -122.413729852457 (37.7371448612571, -122.413729852457) 2 7 7 28859 2
17657 221821 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 368 Highland Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     21 3x5   6007305.19909 2096505.34711 37.7370174246124 -122.417217471014 (37.7370174246124, -122.417217471014) 2 7 7 28859 2
32667 221878 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 18 Coleridge St 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6006985.0649 2099647.22119 37.7456262946341 -122.41854704763 (37.7456262946341, -122.41854704763) 2 7 7 28859 2
53011 221889 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 190 Bartlett St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6006689.37303 2102664.80303 37.7538952362014 -122.419783585756 (37.7538952362014, -122.419783585756) 2 4 7 28859 19
93872 102475 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 581 Capp St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 38389 6007298 2103932 37.7574089362149 -122.417768621509 (37.7574089362149, -122.417768621509) 2 4 7 28859 19
95633 221883 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 34 Prospect Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6007121.00835 2099271.28888 37.7446017212974 -122.418050328662 (37.7446017212974, -122.418050328662) 2 7 7 28859 2
99508 221835 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 585 Capp St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6007295.48201 2103941.69106 37.7574354039359 -122.41777801665 (37.7574354039359, -122.41777801665) 2 4 7 28859 19
101047 221790 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3456 22nd St 2 Sidewalk: Curb side : Cutout Tree Private 2     36 Width 5ft   6005327.10837 2103145.45598 37.7551381613168 -122.424528807253 (37.7551381613168, -122.424528807253) 2 4 5 28859 19
132523 115548 Permitted Site 7 Agonis flexuosa :: Peppermint Willow 65 368 Highland Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   20 4x6   6007279.07639479 2096499.56656681 37.7370000828457 -122.417307379598 (37.7370000828457, -122.417307379598) 2 7 7 28859 2
179502 221830 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2451 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 4ft   6008241.38226 2104159.63616 37.7580870167112 -122.414522128209 (37.7580870167112, -122.414522128209) 2 4 7 28859 19
188123 248074 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 440 Holladay Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 3ft   6010189.61639 2098448.43347 37.742514572897 -122.407381643363 (37.742514572897, -122.407381643363) 10 7 7 28859 2

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